A home loan early payoff calculator estimates how extra principal payments change the payoff date and total interest. Enter the original loan amount, annual APR, scheduled term, and monthly extra payment to see the estimated payoff time, interest, and months saved.
Formula
The early-payoff calculation combines the standard fixed-payment loan formula with the formula for how many level payments repay a balance. It assumes the borrower makes the scheduled payment plus the same extra amount every month, with the extra applied to principal.
- Monthly rate: r = APR / 1200, where APR is entered as a percentage per year.
- Scheduled monthly payment: PMT = round[P × r / (1 − (1 + r)−N), 2].
- Estimated months to repay with an extra payment: k = ceil[round(−ln(1 − r × P / M) / ln(1 + r), 6)].
- Here, M = PMT + E, the monthly payment including extra principal.
- Estimated interest: I = M × k − P. Months saved: S = N − k.
P is the starting principal in dollars; APR is the annual percentage rate; r is the monthly rate as a decimal; N is the original term in months; PMT is the scheduled monthly principal-and-interest payment in dollars; E is the extra monthly principal in dollars; M is the total assumed monthly payment; k is the estimated number of months to payoff; I is estimated interest in dollars; and S is months saved. The scheduled payment is rounded to cents before the extra amount is added, and the payoff month is rounded up to a whole month.
Worked Example
Using the calculator defaults: principal P = $300,000, APR = 6%, term = 30 years, and extra principal E = $200 monthly.
- Convert the APR to a monthly decimal rate: r = 6 / 1200 = 0.005. The term is N = 30 × 12 = 360 months.
- Find the scheduled payment: PMT = round[300,000 × 0.005 / (1 − 1.005−360), 2] = $1,798.65.
- Add the monthly extra: M = $1,798.65 + $200 = $1,998.65.
- Estimate payoff time: −ln[1 − (0.005 × 300,000 / 1,998.65)] / ln(1.005) ≈ 246.97 months. Rounding up gives 247 months.
- Estimate interest using the rounded monthly payment amount for all 247 months: ($1,998.65 × 247) − $300,000 = $193,666.55.
- Months saved: 360 − 247 = 113 months.
The interest estimate treats the full combined payment as if it were paid in each month, including the final month. In practice, the final payment is usually smaller because only the remaining balance and accrued interest are due. Therefore this simplified interest total can overstate actual interest slightly; the exact result depends on the lender’s payment schedule and payoff amount.
Assumptions
- The interest rate is fixed throughout the calculation.
- Payments are made monthly at the end of each period; interest accrues monthly at APR / 12.
- The extra amount is paid every month and is applied entirely to principal, beginning with the first payment.
- The estimate excludes fees, taxes, insurance, PMI, escrow, missed or irregular payments, and any lender-specific payment handling.
How to Use the Result
Use the loan’s current principal balance if the loan is already underway. The default example starts with the original amount borrowed; entering that amount for an existing loan would not account for principal already repaid. APR and remaining term should also reflect the loan’s current terms. Check the lender’s statement or disclosure for the figures to enter.
The first output is the estimated number of months until payoff. The scheduled payment output is principal and interest, not the full amount that may be collected monthly for escrow or other items. The interest output estimates interest across the modeled payoff period, while “months saved” compares that estimate with the original full term. These outputs are mathematical estimates, not a lender’s payoff quote.
For a clear comparison, run the calculator once with zero extra principal and again with a proposed extra amount, keeping the same starting balance, APR, and loan term. The difference can illustrate the effect of the assumed extra payments. It does not include changes to the rate, payment skips, fees, or a one-time lump-sum payment.
Common Errors and Limits
- Using the wrong balance: For an active loan, use current principal rather than the initial loan amount. If the balance or rate changes over time, this fixed-input model cannot represent that history.
- Confusing APR and monthly rate: Enter an annual percentage such as 6, not 0.5. The formula converts 6% to 0.5% per month by dividing by 1,200.
- Including escrow in the payment: Property-related collections do not reduce loan principal. Use the principal-and-interest payment and enter the extra principal separately.
- Assuming an extra amount is automatically principal-only: Payment instructions and processing vary. Confirm with the servicer how additional money is applied and whether it is treated as principal rather than an advance payment.
- Overreading rounded totals: The formula rounds scheduled payment to cents and payoff duration to a whole month. A real payoff may differ because of payment dates, daily interest, rounding, and a smaller final payment.
The formula is useful for a steady monthly extra payment, but it does not model a changing payment, occasional lump sums, variable rates, or a recast. It also does not determine whether a particular payment plan is appropriate; it only calculates the stated assumptions.
Other Ways to Model Early Payments
If extra principal will vary from month to month, a month-by-month amortization schedule is more suitable: calculate interest on the opening balance, subtract the scheduled payment and extra principal, and repeat until the balance reaches zero. A one-time extra payment can be modeled by reducing the balance at the month it is made, then recalculating subsequent interest and payments according to the loan terms. Those cases need timing and payment details that this calculator does not request.
For an exact payoff amount on a particular date, ask the loan servicer for its payoff figure. A statement balance may not include interest accrued through the intended payment date or other amounts shown in the servicer’s calculation.
Frequently Asked Questions
What is the formula for paying off a home loan early?
The standard payment formula finds the monthly principal-and-interest payment. To estimate months remaining after adding extra principal, use k = −ln(1 − rP/M) / ln(1 + r), then round up to a whole month. Here r is the monthly rate, P is the balance, and M is the total monthly payment.
Does an extra mortgage payment reduce principal?
It reduces principal when the lender applies it to principal. How to submit or designate the extra amount depends on the loan servicing process, so check the servicer’s instructions rather than assuming it will be applied that way.
Should I use my original loan amount or current balance?
Use the original amount only when estimating from the beginning of the loan. For a loan already in repayment, enter the current principal balance and the remaining term for an estimate from today.
Does this calculator include property taxes and insurance?
No. It models principal and interest only. Taxes, insurance, PMI, escrow, and other charges do not ordinarily reduce the loan principal in this calculation.
Why might the lender’s payoff date differ?
The estimate assumes regular end-of-month payments, fixed monthly compounding, and a constant extra payment. Actual dates, accrued interest, payment processing, rounding, and the final payment amount can change the lender’s schedule.
This result is an estimate, and the lender’s disclosure gives the exact figures.
Related
Formula used
in p | Loan amount | $ | 300000 | 1 | 100000000 in apr | Interest rate (APR) | % | 6 | 0.01 | 100 in yrs | Loan term | years | 30 | 0.0833 | 50 in extra | Extra monthly principal | $ | 200 | 0 | 100000000 out mths | Months to payoff | months | ceil(round(-ln(1 - (apr / 1200) * p / (pmt + extra)) / ln(1 + apr / 1200), 6)) | 0 out pmt | Scheduled monthly payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2 out int | Estimated total interest | $ | (pmt + extra) * mths - p | 2 out saved | Months saved | months | yrs * 12 - mths | 0
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- Plan 2 Repayment Amount? Calculate Your Monthly Payment243.45 £
- Plan 2 Repayment Calculator: Estimate Monthly Deductions20.29 £
- New Standard Repayment Plan: Estimate Monthly Payments$405.53
- Pay As You Earn Repayment Calculator and Guide$405.53
- Federal Loan Repayment Plan Calculator$405.53
- Loan Repayment Comparison Calculator: Compare Payments$405.53