Detailed mortgage schedule
Beyond the monthly payment, see how the mortgage is repaid year after year: principal, interest, balance and the date of the last payment, with an optional extra each month.
Result
1,583.51Monthly payment
- Number of payments
- 259
- That is 21 years and 7 months
- Last payment
- July 2048
- Interest cost
- 148,023.67
- Interest in year 1
- 11,836.82
- Months saved by the extra
- 41
- Interest saved by the extra
- 27,029.49
Year by year
Detailed table
| Year | Principal repaid | Interest paid | Left to pay |
|---|---|---|---|
| 1 | 8,965.31 | 11,836.82 | 291,034.69 |
| 2 | 18,295.87 | 23,308.38 | 281,704.13 |
| 3 | 28,006.58 | 34,399.80 | 271,993.42 |
| 4 | 38,112.91 | 45,095.59 | 261,887.09 |
| 5 | 48,631.00 | 55,379.63 | 251,369.00 |
| 6 | 59,577.61 | 65,235.15 | 240,422.39 |
| 7 | 70,970.19 | 74,644.69 | 229,029.81 |
| 8 | 82,826.93 | 83,590.08 | 217,173.07 |
| 9 | 95,166.74 | 92,052.40 | 204,833.26 |
| 10 | 108,009.28 | 100,011.98 | 191,990.72 |
| 11 | 121,375.05 | 107,448.34 | 178,624.95 |
| 12 | 135,285.36 | 114,340.15 | 164,714.64 |
| 13 | 149,762.40 | 120,665.24 | 150,237.60 |
| 14 | 164,829.26 | 126,400.51 | 135,170.74 |
| 15 | 180,509.96 | 131,521.93 | 119,490.04 |
| 16 | 196,829.52 | 136,004.50 | 103,170.48 |
| 17 | 213,813.97 | 139,822.18 | 86,186.03 |
| 18 | 231,490.38 | 142,947.89 | 68,509.62 |
| 19 | 249,886.96 | 145,353.44 | 50,113.04 |
| 20 | 269,033.05 | 147,009.48 | 30,966.95 |
| 21 | 288,959.17 | 147,885.48 | 11,040.83 |
| 22 | 300,000.00 | 148,023.67 | 0.00 |
How it is calculated
- Payment = amount × i ÷ (1 − (1 + i)^−n), with i = rate ÷ 12 and n = years × 12.
- Each month: interest = balance × i; principal repaid = payment − interest + extra.
- The table adds up principal and interest at the end of each year, until the balance is cleared.
Example
300,000 at 4% over 25 years, 1st payment in January 2027, 150 extra a month: payment 1,583.51, 259 payments, last payment in July 2048, 148,023.67 of interest (27,029.49 saved).
Good to know
- Fixed rate; insurance and fees not included.
- The first payment falls in the start month.
Frequently asked questions
What is this tool used for?
Beyond the monthly payment, see how the mortgage is repaid year after year: principal, interest, balance and the date of the last payment, with an optional extra each month.
How is the result calculated?
Payment = amount × i ÷ (1 − (1 + i)^−n), with i = rate ÷ 12 and n = years × 12.
What should I check before using the result?
Fixed rate; insurance and fees not included.