How this instrument works
Most mortgage tools ask for a home price and a down payment and subtract one from the other to find what you owe. This one skips that step and takes the borrowed amount directly, because plenty of the people doing this math already have that figure in hand rather than a purchase price: someone refinancing into a new balance, a buyer who assumed an existing loan, an agent fielding a client's what-if over the phone, or a shopper stacking three lenders' rate quotes against the exact same balance to see which number moves the payment least.
The result comes from the standard level-payment amortizing-loan formula: a fixed monthly sum computed so that, at the stated rate, it retires the entire balance in exactly the stated number of months, no more and no less. The (1+r)^N term in the denominator and numerator is what makes the payment level despite interest being charged on a shrinking balance — early on the payment is mostly interest, later mostly principal, but the total handed over each month never changes. That exponent is also why a small change in the rate field moves the payment by more than proportionally: raise r a little and both the numerator and the growth of (1+r)^N respond.
What it will not tell you is the total cost of owning the place. Property tax, homeowner's insurance, HOA dues, private mortgage insurance, and any origination points a lender rolls into the note are all left out on purpose — folding rough local estimates into an exact payment figure would just make the figure less exact. This sheet answers one narrow question precisely: given this balance, this rate, and this term, what does the loan itself cost per month.
- Enter the loan amount — the balance actually being borrowed, not the price of the home.
- Set the annual interest rate your lender quoted or the rate you are comparing.
- Choose the loan term in years.
- Read the monthly principal + interest payment in the readout.
- Change the rate or term to see how much either one moves the payment, holding the loan amount fixed.
Worked example — refinancing into a $300,000 balance
A homeowner refinances into a new note with a balance of $300,000, a fixed rate of 7%, and a 20-year term. There is no purchase price in this scenario at all, only the balance being carried forward, so the calculation starts straight from L = 300000. The monthly rate is r = 7 ÷ 1200 = 0.0058333, and the term runs N = 20 × 12 = 240 months.
Feeding those three numbers through the formula gives M = $2,325.90 a month, matching the exact figure a lender's disclosure would show for that balance, rate, and term regardless of what the home is worth or how large any earlier down payment was. Holding the balance and term fixed and testing a quarter-point rate change shows the same sensitivity every fixed loan of this size carries: small rate differences compound into real monthly dollars once L is this large.
Questions
Why does this calculator ask for the loan amount instead of the home price and down payment?
Because the payment a lender quotes is computed off the balance actually financed, not the sticker price of the home. Anyone who already knows that balance — after a refinance, an assumed note, or a lender's rate sheet — can skip the subtraction step entirely and go straight to the payment this instrument produces.
Does the monthly payment include property tax, insurance, or HOA dues?
No. Those costs vary by location, insurer, and building, and mixing rough local estimates into a precise payment figure would make the whole number rough. This sheet returns the loan's own principal-and-interest cost only; add real tax, insurance, and dues on top separately.
How is this different from a full mortgage calculator that shows an amortization schedule?
This instrument answers a narrower question — one fixed monthly payment for a given balance, rate, and term — without building the month-by-month table of how much of each payment goes to interest versus principal. If you need that breakdown, use a calculator built specifically to walk the schedule.
Why does raising the interest rate move the payment by more than it seems like it should?
The rate appears twice in the formula: once directly, and again inside (1+r) raised to the power of the number of payments. Over 240 or 360 months that exponent amplifies even a small rate change, which is why a quarter-point difference between two lender quotes on a large balance can add up to real monthly dollars.
Can this formula be used for a loan that is not for a house?
Yes — the level-payment amortizing formula behind this calculator applies to any loan repaid in equal installments at a fixed rate, including personal loans, land contracts, and some business notes. The field labels here assume a home-related term length, but the arithmetic itself does not care what secures the debt.
Why might my actual lender quote differ slightly from this figure?
Lenders sometimes round differently, use a 365-day daily accrual instead of a flat monthly rate, or fold origination fees into the financed balance before quoting a payment. Differences of a few dollars are ordinary; a large gap usually means the quote includes costs this sheet deliberately leaves out of the loan-amount figure you entered.
References
- CFPB — Understand your loan options before you borrow
- Federal Reserve — Consumer guide to mortgage settlement costs
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.