monthly mortgage calculator (for singapore)
here’s a excel file that will help you to calculate things like monthly mortgage and find out, at the end of the x years, how much interest you have paid in total.
more importantly, it allows you to enter details like CPF and also promotional rate package housing loan interest rates (different rate every year, for up to year 5). most calculators out there only allow one interest rate input, so this gives you a more accurate figure.
below is screenshot (click image to enlarge) of singapore mortgage calculator (please be patient to wait for the excel file to load, takes around 10 seconds to load)
