Mortgage Payoff Calculator
Estimate your fixed-rate mortgage payoff date, lifetime interest, and the effect of recurring or one-time extra principal payments.
Mortgage inputs
Accelerated payoff results
Original vs accelerated schedule
Balance over time
Balance chart appears when a valid schedule has at least three plotted checkpoints.
Outstanding balance declines as scheduled principal is repaid. Extra principal, when entered, adds a second accelerated path for comparison.
| Checkpoint | Date | Original balance | With extras balance |
|---|
| Period | Date | Principal | Interest | Extra principal | Total paid | Ending balance | Original balance |
|---|
The opening balance is included as the first schedule entry. Yearly rows aggregate cash flows and show the last balance reached in each 12-month block.
How to use this Mortgage Payoff Calculator
What this calculator does
This calculator estimates the principal-and-interest path of a fixed-rate, fully amortizing mortgage and shows how recurring or one-time extra principal payments can change the payoff date and lifetime interest. It is useful for comparing a current schedule with a faster repayment plan, checking the financial effect of a lump sum, and understanding how much of each installment goes to interest versus principal. It does not include property taxes, homeowners insurance, mortgage insurance, late fees, prepayment penalties, escrow changes, or adjustable-rate resets. The Consumer Financial Protection Bureau explains that a typical mortgage payment divides principal and interest differently over time as the balance amortizes; its mortgage amortization explanation provides useful context for interpreting the schedule.
When to use it
Use the calculator when deciding whether to add a fixed amount to monthly principal, when considering an annual bonus or other lump-sum payment, when estimating how many years a payoff strategy could remove, or when reconciling your own amortization estimate with a lender statement. For an actual payoff quote, fees, daily accrued interest, and servicer-specific rules can matter, so the result is an estimate rather than a lender commitment.
How to calculate
- The calculator opens with a ready-to-use demonstration: a $100,000 mortgage, 4% nominal annual rate, 25-year term, monthly capitalization, and a schedule date of 09/19/2026. The example XLSX is available immediately.
- Replace Mortgage amount, Interest rate, Mortgage term, Interest capitalization method, and the first On the day of date with your own loan details. Results update live.
- To test acceleration, choose Payment frequency, enter an Extra payment, and provide From the day of. You can also enter a One-time extra payment and its second On the day of date. Extra amounts are applied to principal in the model.
- Read the result cards, compare the two balance paths, and use Schedule view to switch between yearly and monthly amortization detail. Download Excel exports the current validated assumptions and complete schedule.
- Reset clears the demonstration and all entered data. Download Excel is then disabled until the required mortgage fields form a complete valid state again.
Input guide
Mortgage amount is required U.S.-dollar principal. Enter a positive amount such as 100000 or $100,000.00; commas must be standard thousands separators. A larger balance raises both the payment and total interest. Interest rate is the required nominal annual percentage from 0% through 100%; enter 4 or 4%. A higher rate generally raises both the required monthly payment and interest cost. Mortgage term is required in years, from one month through 50 years; 25 means 300 monthly installments. A longer term normally lowers the required installment but increases lifetime interest.
Interest capitalization method converts the nominal annual rate to the monthly rate used by the amortization model. Monthly capitalization uses annual rate divided by 12; quarterly, semi-annual, and annual choices use the matching nominal compounding convention before converting to an equivalent monthly rate. The first On the day of is the required schedule start date; the first installment is one month later. Enter a real calendar date, not a text date with an ambiguous day/month order.
Payment frequency controls how often a recurring extra principal amount is applied: monthly, quarterly, or annually. Extra payment is optional dollars; 0 means no recurring acceleration. If it is positive, From the day of becomes required and must fall within the original schedule. One-time extra payment is an optional positive dollar lump sum; when it is above zero, the second On the day of becomes required, and the lump sum is applied on the first monthly installment on or after that date. Do not enter expected taxes or insurance as extra principal unless your servicer will actually apply that money to principal. Schedule view only changes display detail; Yearly aggregates 12 monthly rows while Monthly shows each installment.
Output guide
Payoff date is the estimated date of the final scheduled installment under the current extra-payment plan. Payment is the base monthly principal-and-interest installment before optional extras. # payments follows the schedule-entry convention used here and includes the opening-balance checkpoint, so the 25-year demonstration displays 301 entries for 300 installments. Repayment term expresses the same schedule-entry count in years and months. Total interest is the cumulative interest charged by the model; Total payment is cumulative principal plus interest. Interest saved compares accelerated interest with the original no-extra schedule, and Time saved is the number of monthly installments removed by extra principal.
The balance chart shows Original balance and, when extras change the path, With extras balance. A lower accelerated line means principal is being retired sooner. The amortization table columns show Period, Date, regular Principal, Interest, Extra principal, Total paid, Ending balance, and the comparable Original balance. Zero interest is valid when the entered rate is 0%; negative balances are not produced. Freddie Mac's amortization guide gives a practical illustration of principal increasing and interest declining over a fixed-rate schedule.
Worked example
With the opening values of $100,000, a 4% nominal annual rate, monthly capitalization, and 25 years, the monthly rate is 0.04 ÷ 12. The standard fixed-payment formula produces $527.836840..., displayed as $527.84. Across 300 installments, total interest is $58,351.05 and total principal plus interest is $158,351.05. Because the schedule starts on 09/19/2026 and the first payment occurs one month later, the final installment is estimated for 09/19/2051. With both extra-payment amounts at $0, interest saved and time saved are zero. Entering extra principal should reduce the outstanding balance sooner, which can reduce both the payoff time and total interest.
How extra principal changes a mortgage
Interest in this model is calculated from the outstanding principal at each monthly step. When extra money is applied to principal, the next month's interest is calculated from a smaller balance. That is why extra payments can have a compounding effect on the payoff path even though the extra money itself is not earning a return. The CFPB notes that borrowers may be allowed to make extra principal payments and should confirm that the servicer applies them to principal; see its guidance on mortgage servicing and extra principal payments.
The acceleration model keeps that scheduled base payment and adds only the extra principal you specify. If an extra payment would exceed the remaining balance, it is capped at the balance so the schedule never goes negative. A final regular installment is also reduced when necessary. These rules make the total principal repaid equal the starting mortgage amount while allowing the timing and interest total to change.
Important planning limits
A payoff calculator is not the same as a formal payoff statement. Real mortgages can accrue interest daily, have different conventions for partial payments, include escrowed taxes and insurance, or impose contractual limits and charges. The CFPB explains that a written payoff request to a servicer is subject to specific response rules and that the mortgage statement can disclose a prepayment penalty when one applies. Use this model for planning, then confirm implementation details with your servicer before sending a large extra payment.
Tax consequences are also outside this calculator. In the United States, the deductibility of mortgage interest depends on tax-law requirements and individual facts. The IRS maintains Publication 936 on the home mortgage interest deduction. Reducing interest through faster repayment can therefore change deductible interest for some taxpayers, but this calculator does not estimate taxes or recommend a tax strategy.