Home Payoff Calculator

Formatting only. This does not change the calculation.
The nominal annual rate (APR before fees), not the monthly rate.
Added to the term in years, for terms such as 5 years and 6 months. To state a tenure purely in months, set the years to 0 and enter the whole tenure here.
Lenders usually let you pick one or the other after a lump sum. Regular extra principal always shortens the term.
Some deals cap how much you may overpay in a year before an early repayment charge applies, as a percentage of the balance at the start of the year. Your mortgage offer states the figure; leave it at 0 if your loan has no cap.
Interest saved by extra payments
97,618.44
Extra Payment Payoff Calculator
Payment
1,580.17
Total interest
221,243.14
Total of payments
471,243.14
Number of payments
265
Payoff time
22.083 years
Rate per period
0.541667 %
Interest per unit borrowed
0.885
Payments saved
95
Interest without extra payments
318,861.58
Payments without extra payments
360
Years cut from the term
7.917
New payoff time
22.083 years
Overpayment planned in year one
2,400
Worked out from Standard annuity-immediate payment formula, PMT = P i / (1 - (1+i)^-n) and 1 other source.

How this is worked out

5 steps
  1. Scheduled payment on 250000 at 6.5% is 1580.17.
  2. Adding 200 of principal each period changes the payoff.
  3. Without extras: 360 payments and 318861.58 interest.
  4. With extras: 265 payments and 221243.14 interest.
  5. That saves 97618.44 and 95 payments (7.917 years).
Yearly summarytable
yearinterestprincipalendingBalance
116,094.925,267.12244,732.88
215,742.175,619.87239,113.01
315,365.815,996.23233,116.78
414,964.216,397.83226,718.95
514,535.756,826.29219,892.66
614,078.597,283.45212,609.21
713,590.787,771.26204,837.95
813,070.338,291.71196,546.24
912,515.038,847.01187,699.23
1011,922.529,439.52178,259.71
1111,290.3310,071.71168,188
1210,615.8310,746.21157,441.79
139,896.1311,465.91145,975.88
149,128.2212,233.82133,742.06
158,308.9313,053.11120,688.95
167,434.7213,927.32106,761.63
176,501.9814,860.0691,901.57
185,506.7715,855.2776,046.3
194,444.9216,917.1259,129.18
203,311.9318,050.1141,079.07
212,103.119,258.9421,820.13
22813.2820,548.761,271.37
236.891,271.370

Results are general information, not financial, tax, legal, medical or engineering advice.