Personal Finance, Loans & Credit Mortgages & Home Financing Amortised loan formula with principal prepayment

Mortgage Extra Payment Payoff Calculator

Extra principal is the one lever on a fixed-rate mortgage that you control completely. This calculator re-amortises your loan with any combination of a recurring monthly addition, a one-time lump sum and an annual extra payment, then sets the result beside the schedule you would otherwise follow. It reports the new payoff date, the number of payments saved, the interest you avoid, and how many dollars of interest each dollar of extra principal actually buys — which is the number that tells you whether prepaying beats the alternatives.

Calculator

This calculator runs in your browser. Enable JavaScript for live results — the inputs, formula and worked example below remain fully readable without it.

Inputs this calculator takes, with typical values
InputWhat to enterExample
Current loan balanceThe principal owing today, from your latest statement — not the original loan amount.300000 $
Interest rateThe note rate on the loan, not the APR.6.5 %
Remaining termYears left on the original schedule; the scheduled payment is derived from this and the balance.30 yr
Extra principal each monthAn amount added to every payment and applied entirely to principal.200 $
Extra once a yearApplied on every twelfth payment — set it to your scheduled payment to model the classic thirteenth payment a year.0 $
One-time lump sumA single prepayment such as a bonus or an inheritance, applied to principal.0 $
Lump sum applied at payment numberCounted from your next payment; earlier is worth more because interest compounds on what is left.12

It returns

  • Interest saved — Total interest on the baseline schedule less total interest with your extra payments.
  • Payments with extra principal
  • Payments without it
  • Time saved
  • Scheduled monthly payment
  • Total interest with extra principal
  • Total interest without it
  • Interest saved per $1 of extra principal

The formula

Bk=Bk1(1+r)(M+Ek)
k=ln(1rBM+E)ln(1+r)

In plain text: B_k = B_(k−1)(1 + r) − (M + E_k); payoff = first k with B_k ≤ 0; saved = ΣInterest_baseline − ΣInterest_accelerated

  • BOutstanding balance ($)
  • MScheduled payment, unchanged by prepayment ($)
  • EExtra principal applied in month k ($)
  • rMonthly interest rate, annual rate ÷ 12 (decimal)
  • kPayment number (—)

The scheduled payment M never changes when you prepay a conventional mortgage. Only the number of payments changes, unless you formally recast the loan.

Updated Category Mortgages & Home Financing Verified against published test cases Reading time 10 min

Why an extra $200 removes far more than $200 of debt

Extra principal works because interest on a mortgage is charged on the balance you currently owe, and nothing else. A dollar sent to principal today is a dollar that never appears in any future interest calculation — so it saves r dollars of interest next month, and again the month after, for every month that remains on the loan.

That is why the leverage looks implausible until you write it out. On the default case here — $300,000 at 6.5% with 30 years to run — adding $200 a month retires the loan 83 payments early and avoids $103,449 of interest, for roughly $55,000 of extra principal paid. Each extra dollar buys about $1.87 of avoided interest.

Two structural facts matter more than most people realise. First, your payment does not change. Prepaying a conventional mortgage shortens the term; it does not lower the monthly obligation, and if cash flow is the problem then prepayment is the wrong tool. Second, timing dominates size. A lump sum in year two has more remaining months to work on than the same lump in year twenty, so the earlier prepayment saves substantially more even though the dollars are identical.

How the two schedules are built and compared

The baseline comes first. From your current balance B, monthly rate r and remaining months n, the scheduled payment is M = B·r / (1 − (1 + r)n) — the same identity the amortization schedule calculator uses. Running that forward for n months gives the interest you are currently committed to.

The accelerated schedule uses the identical M but adds your extra in the months you specify: every month for the recurring amount, every twelfth payment for the annual amount, and once at the payment number you choose for the lump sum. Each month the recurrence is Bk = Bk−1(1 + r) − (M + Ek), and the loan is repaid the first time that reaches zero. The final payment is trimmed to exactly clear the balance rather than overshooting.

With a constant monthly extra and no lump sum, you do not need the loop. Setting Bk = 0 and solving gives a closed form: payoff = ⌈ −ln(1 − r·B / (M + E)) / ln(1 + r) ⌉. Notice the condition hiding inside it — the logarithm is only defined while M + E exceeds r·B, which is the formal statement that a payment smaller than the accrued interest never repays anything.

The saving is then simply the difference between the two interest totals. The last output divides that saving by the extra principal you actually paid, which puts prepayment on the same footing as any other use of the money.

Worked example: $300,000 at 6.5%, 30 years left, $200 a month extra

Work the default case through by hand.

  1. Monthly rate. r = 6.5 ÷ 1,200 = 0.005416667, and ln(1 + r) = 0.0054020.
  2. Scheduled payment. The payment factor at 6.5% over 360 months is 0.00632068 per dollar, so M = 300,000 × 0.00632068 = $1,896.20.
  3. Baseline interest. 360 × 1,896.204 − 300,000 = $382,633.
  4. Accelerated payment. M + E = 1,896.204 + 200 = $2,096.20.
  5. Payoff month. r·B = 0.005416667 × 300,000 = 1,625. Then 1,625 ÷ 2,096.204 = 0.775212, so 1 − that = 0.224788. ln(0.224788) = −1.492598, and −(−1.492598) ÷ 0.0054020 = 276.30, which rounds up to 277 payments.
  6. Time saved. 360 − 277 = 83 payments, six years and eleven months.
  7. Accelerated interest. 276 full payments of $2,096.204 is $578,552, and the 277th is trimmed to $632.35, so $579,185 leaves the account in total. Less the $300,000 of principal, interest is $279,185.
  8. Saving. 382,633 − 279,185 = $103,449 of interest avoided, for 276 × $200 = $55,200 of extra principal. That is $1.87 of interest saved per dollar of extra principal.

The last line is the one to carry away. At 6.5% over a full thirty-year horizon, prepayment returns considerably more than the headline rate suggests — not because the rate is higher than 6.5%, but because you are earning it for a very long time.

How to read the result, and when not to prepay

Read the interest-saved-per-dollar figure before the headline saving. It is the closest thing to a return on the money, and it lets you compare prepayment against the alternatives on equal terms. The comparison that usually decides the matter is simple: prepaying a mortgage earns you the mortgage rate, risk-free and tax-free at the margin. Any debt you hold at a higher rate should be cleared first — which for most households means credit cards, and the debt avalanche calculator puts that ordering on a formal footing.

Three situations where prepaying is the wrong move, and none of them is about arithmetic. If you have no emergency fund, money in the mortgage is money you cannot reach without a refinance or a home-equity line — home equity is the least liquid asset most families own. If your employer matches retirement contributions, the match is an immediate return that no mortgage rate approaches. And if you carry a mortgage below about 4%, the case for prepaying over almost any other use of the money is weak.

Watch what happens to the time saved as you raise the extra amount. The relationship is strongly diminishing: on the reference table below, the first $100 a month buys 48 payments and the next $100 buys only 35 more, because each additional dollar arrives on a loan that is already being retired faster. Doubling the extra never halves the term.

Finally, a mechanical point. Prepaying does not lower next month's obligation. If your goal is a smaller payment rather than a shorter loan, you want either a refinance or a recast — a recast keeps your rate and term but re-amortises the reduced balance, and many servicers offer it for a few hundred dollars after a lump-sum prepayment.

Effect of extra principal on a $300,000 loan at 6.5% with 30 years to run

Scheduled payment $1,896.20. Payments to payoff from ⌈−ln(1 − 1,625/(1,896.204 + E))/ln(1.005416667)⌉; interest saved is the baseline $382,633.47 less the accelerated total, rounded to the nearest dollar.
Extra per monthPayments to payoffPayments savedInterest saved
$03600$0
$5033426$33,582
$10031248$60,995
$20027783$103,449
$300250110$135,115
$500210150$179,759
$1,000153207$241,162

Payments saved rises with the extra amount but by shrinking increments: $50 buys 26, the second $50 buys 22 more, and the step from $500 to $1,000 — ten times the first row's extra — buys only 57 further payments.

Mistakes that cost people the saving

  • Not labelling the payment as principal. Servicers routinely hold unlabelled extra money as a prepaid future instalment, which earns you nothing. Use the principal-only field in the payment portal, or write the instruction on the cheque, then check the next statement shows the balance reduced.
  • Prepaying while carrying card debt. A dollar against a 6.5% mortgage avoids 6.5% a year; the same dollar against a 24% card avoids 24%. Order matters far more than effort here.
  • Paying a biweekly conversion service. The saving from a biweekly plan comes entirely from the thirteenth monthly payment it produces each year, which you can replicate for free by dividing your payment by twelve and adding that to each month. A fee for the service is a fee for arithmetic you can do yourself.
  • Emptying the emergency fund. Money paid into a mortgage cannot be withdrawn. Households that prepay to zero reserves often refinance the next emergency back onto a credit card at four times the rate.
  • Assuming the payment will fall. It will not. Only a recast or a refinance changes the required monthly amount.
  • Ignoring the tax position. If you itemise and deduct mortgage interest, the effective rate you avoid is the note rate less your marginal rate — though since the 2017 standard-deduction increase most filers do not itemise and the point is moot for them.

Prepayment against the alternatives

Prepaying is one of four ways to reduce lifetime interest, and they are not interchangeable. Refinancing lowers the rate on the whole balance at once but carries closing costs that need recovering; the refinance break-even calculator prices that trade. Shortening the term at origination achieves the same outcome as heavy prepayment but locks you into the higher payment. Recasting keeps the rate and term but re-amortises a reduced balance, lowering the payment without a new loan. And investing instead substitutes an uncertain higher return for a certain lower one.

There is no prepayment penalty on the great majority of US mortgages written today. Regulation Z restricts prepayment penalties on qualified mortgages sharply — they are limited to the first three years, capped in size, and prohibited entirely on adjustable-rate qualified mortgages. Check your note anyway if it predates 2014 or is a non-qualified product.

One consideration that has nothing to do with rates: prepaying converts liquid savings into home equity, and equity is only realised by selling or by borrowing against the house. Households approaching a job change, a move or a period of variable income are usually better served by holding the cash, even at a lower nominal return. If you are still choosing between buying and renting at all, the rent vs buy calculator is the prior question.

Frequently asked questions

How much sooner will I pay off my mortgage with an extra $100 a month?

On a $300,000 balance at 6.5% with 30 years to run, 48 payments sooner — four years — and $60,995 less interest. The general formula is ⌈−ln(1 − r·B/(M + E))/ln(1 + r)⌉ payments, where E is the extra. The saving is highly sensitive to the rate and to how many years remain: the same $100 on a loan with eight years left removes far fewer payments, because there is less future interest for it to cancel.

Does paying extra principal lower my monthly payment?

No. On a conventional mortgage the payment is fixed by the original note and prepaying only shortens the term. To lower the payment you need a recast, where the servicer re-amortises the reduced balance over the remaining term at the same rate — usually available after a lump-sum prepayment for a fee in the low hundreds — or a refinance into a new loan. Ask specifically for a recast; servicers rarely volunteer it.

Is a lump sum better applied early or late?

Early, and by a wide margin. A prepayment cancels interest on every month that remains, so its value scales with the time left. Move the lump-sum month field earlier and later and watch the saving change: the same dollars applied in year two of a thirty-year loan avoid several times the interest they would avoid in year twenty. This is also why an extra payment made now beats a larger one saved up for next year.

Should I pay off my mortgage early or invest the money?

Prepaying earns a certain return equal to your note rate; investing offers an uncertain and historically higher one. The honest comparison is risk-adjusted and personal, but two guides hold widely. Take any employer retirement match first — an immediate matched contribution beats any mortgage rate. And clear higher-rate debt first, because avoiding 24% on a card dominates avoiding 6.5% on a mortgage. Between those, a note rate below roughly 4% weakens the prepayment case considerably.

What is a biweekly mortgage payment plan really doing?

Producing one extra monthly payment a year. Twenty-six half-payments equal thirteen full ones, and it is that thirteenth payment — not the fortnightly rhythm — that shortens the loan. You can reproduce it exactly by adding one twelfth of your payment to each month, at no cost. Model it here by entering your scheduled payment in the once-a-year field, or one twelfth of it in the monthly field.

Will my lender charge me for paying early?

Almost certainly not. Regulation Z sharply restricts prepayment penalties on qualified mortgages: they may only apply in the first three years, are capped in amount, and are prohibited on adjustable-rate qualified mortgages. Loans originated before 2014, and some non-qualified or portfolio products, can still carry them. Search your note for the words “prepayment” and “yield maintenance” before making a large lump-sum payment.

Why does the calculator show a saving of more than a dollar for each extra dollar paid?

Because the extra dollar cancels interest for every remaining month, not just one. At 6.5% with a long horizon, each dollar of extra principal in the default case avoids about $1.87 of interest. That ratio falls as the remaining term shortens — with only a few years left, a dollar of prepayment cancels only a few years of interest on that dollar, and the ratio drops well below one.

Should I prepay my mortgage or my student loans first?

Compare the rates first, then the features. Federal student loans carry income-driven repayment, forbearance and forgiveness routes that a mortgage does not, so a federal loan at a similar rate is worth keeping for the optionality. A private student loan at a higher rate than your mortgage should be cleared first on pure arithmetic. The student loan payment calculator shows what your balance actually costs.

References