Mortgage calculator

SGD
%
Monthly payment
$3,794
Year 025
  • Total interest$338,107
  • Total paid$1,138,107
Year-by-year breakdown
YearTotal interestBalance
1$23,702$778,177
2$23,038$755,691
3$22,354$732,520
4$21,649$708,645
5$20,923$684,044
6$20,175$658,694
7$19,404$632,573
8$18,609$605,658
9$17,790$577,925
10$16,947$549,347
11$16,078$519,901
12$15,182$489,558
13$14,259$458,293
14$13,308$426,077
15$12,328$392,881
16$11,319$358,676
17$10,278$323,430
18$9,206$287,112
19$8,102$249,689
20$6,963$211,128
21$5,790$171,394
22$4,582$130,452
23$3,337$88,264
24$2,053$44,793
25$731$0
How it is calculated

The calculator uses the standard annuity formula: the same payment every month, where the interest part shrinks and the principal part grows as the balance falls. Interest is charged monthly at one twelfth of the annual rate.

Total interest is everything you pay above the amount borrowed. Fees, insurance and property taxes are not included, so add them to the monthly payment when you plan your budget.

Questions

How much does a shorter term save?

A shorter term raises the monthly payment but cuts total interest sharply, because the balance falls faster. Try 30 and 20 years with the same rate to see the difference.

Does the calculator work for fixed and variable rates?

It assumes one rate for the whole term. For a fixed period followed by a variable rate, run the calculator again with the new rate and the remaining balance.

Now keep it on track Set the result as a budget in Spendee and see each month how much is left.