Mortgage calculator

PHP
%
Monthly payment
₱16,963
Year 025
  • Total interest₱2,688,810
  • Total paid₱5,088,810
Year-by-year breakdown
YearTotal interestBalance
1₱166,837₱2,363,284
2₱164,183₱2,323,915
3₱161,337₱2,281,699
4₱158,285₱2,236,432
5₱155,013₱2,187,892
6₱151,504₱2,135,843
7₱147,741₱2,080,031
8₱143,706₱2,020,185
9₱139,380₱1,956,013
10₱134,741₱1,887,202
11₱129,767₱1,813,416
12₱124,433₱1,734,296
13₱118,713₱1,649,457
14₱112,580₱1,558,484
15₱106,004₱1,460,936
16₱98,952₱1,356,335
17₱91,390₱1,244,173
18₱83,282₱1,123,902
19₱74,588₱994,938
20₱65,265₱856,650
21₱55,268₱708,366
22₱44,549₱549,362
23₱33,054₱378,864
24₱20,729₱196,040
25₱7,512₱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.