Skip to content

Mortgage Payoff and Extra Payment Formulas

Review mortgage extra payment formulas for monthly payment, amortization, extra principal timing, payoff savings, target terms, and a worked calculation.

How do the Mortgage Payoff Calculator formulas work?

This formula page defines the variables used by the Mortgage Payoff Calculator, shows how those values are combined, and explains the order of operations behind the result. Use the worked steps to verify an estimate, compare scenarios, and understand which assumptions or rounding rules can affect the displayed answer.

Formula Overview

The calculation begins with the standard fixed-rate mortgage payment. It then builds two monthly schedules: a regular schedule with no extra principal and an accelerated schedule with the user's monthly, yearly, and one-time additions. A third schedule is created for the independent target-payoff scenario.

Every schedule uses the prior month's balance to calculate interest. This means an extra payment changes not only the current balance but also the interest and principal split in every later month.

Variable Definitions

SymbolMeaningUnit or convention
PCurrent unpaid principal balanceCurrency
MRegular monthly principal-and-interest paymentCurrency per month
rAnnual fixed note ratePercentage, such as 6.5
iMonthly interest rater / 1,200
nRemaining scheduled paymentsYears x 12 + months
BtBalance after payment tCurrency
ItInterest for month tCurrency
QtScheduled principal for month tCurrency
EtExtra principal requested in month tCurrency
XtExtra principal actually applied in month tCurrency
TTarget payoff termMonths

Monthly Payment

For a positive interest rate, the fixed monthly principal-and-interest payment is:

M=Pi1−(1+i)−nM=P\frac{i}{1-(1+i)^{-n}}

The calculator converts the annual percentage rate entered in the form to a monthly decimal rate with i = r / 1,200. If the entered note rate is zero, it uses:

M=PnM=\frac{P}{n}

The regular payment is rounded to cents before the schedules are generated.

Amortization

For each monthly payment, interest is calculated first from the prior balance. The remainder of the regular payment becomes scheduled principal:

It=round(Bt−1i,2)I_t=round(B_{t-1}i,2)
Qt=min⁡(Bt−1,max⁡(0,M−It))Q_t=\min\left(B_{t-1},\max(0,M-I_t)\right)

The baseline balance then becomes Bt = Bt-1 - Qt. The final scheduled principal is capped at the remaining balance so the schedule ends at exactly zero.

Extra Payments

The requested extra amount for a month combines every applicable user entry:

Et=Emonthly+Eyearly,t+Eone−time,tE_t=E_{monthly}+E_{yearly,t}+E_{one-time,t}
Xt=min⁡(Bt−1−Qt,Et)X_t=\min\left(B_{t-1}-Q_t,E_t\right)
Bt=max⁡(0,Bt−1−Qt−Xt)B_t=\max\left(0,B_{t-1}-Q_t-X_t\right)

The monthly amount applies every month. The yearly amount applies every twelfth modeled payment. The one-time payment applies only at the selected payment number. The amount actually posted is capped so scheduled and extra principal cannot exceed the remaining balance.

Payoff and savings formulas

Months saved=nregular−nextraMonths\ saved=n_{regular}-n_{extra}
Interest saved=∑Itregular−∑ItextraInterest\ saved=\sum I_t^{regular}-\sum I_t^{extra}
Net savings=Interest saved−PenaltyNet\ savings=Interest\ saved-Penalty

Target payoff formula

The payment formula is recalculated with the target months T. The additional monthly amount required is:

Extratarget=max⁡(0,Mtarget−Mregular)Extra_{target}=\max(0,M_{target}-M_{regular})

Ownership Costs

Property taxes, homeowners insurance, mortgage insurance, HOA dues, maintenance, utilities, and escrow activity do not appear in these formulas. They do not reduce principal and therefore do not change the modeled mortgage amortization unless the actual loan balance or rate changes.

The Mortgage Payment Calculator can estimate the broader housing payment. Keep those expenses in the household budget when deciding whether an extra principal amount is affordable.

Worked Calculation

Consider a $300,000 balance at 6.5% with 25 years, or 300 monthly payments, remaining. The borrower plans to add $200 each month.

  1. Monthly rate: 6.5 / 1,200 = 0.0054166667.
  2. The fixed-payment formula produces a regular payment of $2,025.62.
  3. The recurring accelerated payment is $2,025.62 + $200 = $2,225.62.
  4. The baseline amortization schedule lasts 300 months and produces $307,687.31 in modeled interest.
  5. The accelerated schedule lasts 243 months and produces $239,644.80 in modeled interest.
  6. Months saved: 300 - 243 = 57 months.
  7. Interest saved: $307,687.31 - $239,644.80 = $68,042.51.
  8. A separate 20-year target requires $2,236.72 monthly, or $211.10 above the regular payment.

These values are generated by the same tested engine used by the calculator and examples page.

Assumptions

  • The mortgage is fixed-rate and fully amortizing with monthly payments.
  • Payments are made on schedule, and entered extra funds are credited to principal in the modeled month.
  • Interest, payments, principal postings, and balances are rounded to cents as the schedule is generated.
  • The annual extra amount occurs every twelfth modeled payment.
  • The one-time payment occurs once at the selected payment number.
  • The calculator does not model daily-interest servicing, variable rates, skipped payments, recasting, taxes, insurance, escrow, tax effects, or investment alternatives.
  • A penalty affects net savings only when the user enters it.

Formula FAQ

Why does an earlier payment usually save more interest?

Earlier principal reduction lowers the balance used in more future monthly interest calculations. For a useful Mortgage Payoff Calculator formula result, enter realistic values, compare relevant scenarios, check the calculation details, and review the definitions, assumptions, and limitations before using the estimate for an important decision.

Why can total extra principal be less than the amount entered times the number of months?

The final extra payment is capped at the principal remaining after scheduled principal is applied. For a useful Mortgage Payoff Calculator formula result, enter realistic values, compare relevant scenarios, check the calculation details, and review the definitions, assumptions, and limitations before using the estimate for an important decision.

Does the formula reduce the required mortgage payment?

No. It keeps the scheduled payment constant and shortens the modeled term. A lender-approved recast is a different calculation. For a useful Mortgage Payoff Calculator formula result, use realistic inputs, compare relevant scenarios, and review the stated assumptions before making a decision.

Why is the target payoff separate?

The target schedule solves one consistent monthly payment. Keeping it separate prevents monthly, annual, and lump-sum inputs from being counted twice. For a useful Mortgage Payoff Calculator formula result, use realistic inputs, compare relevant scenarios, and review the stated assumptions before making a decision.

References

Use the Mortgage Payoff Calculator