Thursday, April 06, 2006

FPM Home Loan Planner

FPM Home Loan Planner contains a home loan calculator and a home loan repayment planner. (It is an Excel file. DOWNLOAD to your computer to use it. You cannot use the browser version.)

Home Loan Calculator

There are four variables in calculating home loan, i.e. loan amount, interest rate, monthly instalment and loan tenure. The usual home loan calculators found in the internet calculate only the monthly instalment in which users enter loan amount, interest rate and loan tenure. Under certain circumstances, i.e. exploring alternative loan tenure by changing instalment amount, such home loan calculators are cumbersome for use.

In FPM's Home Loan Calculator, users can decide what to calculate by providing data of any three variables.

Home Loan Reapayment Planner

The repayment planner contains amortization schedule and provides flexibility of calculation for staggered release of loan (housing project under development) and early repayment of home loan.

Some banks offer lower interest at the begining of the loan. Interest rate can be changed through out the period of the home loan.

Note 1: You can enter early repayment amount and interest rate in the respective columns.

Download FPM's Home Loan Planner here.


Anonymous said...

i hv downloaded the FPM's home loan planner; however noted tht there're some errors on the report portion - no formulae on total interest; total principal & total repayment amt.. Pls adv. thx/rosalind

CT said...

My fault of not realising this earlier. I think the FPM's home loan planner require Analysis ToolPak (that comes with your Microsoft Excel) to be activated.

Go to "Tools" --> "Add-ins" and tick on "Analysis ToolPak". You should be able to see the report correctly.


Anonymous said...

hello mr chen tong,

just downloaded your planner.

this is a good site. glad to have found your blog.


Anonymous said...

Thanks for providing the calculator. I have taken up a multi tier home loan. I was just wondering can i do the calculation from the home loan planner?


Dave Corner said...

good sharing of home loan planning...

Kopi O said...


nice calculator. if you can include in chart for "Loan Outstanding (No Extra Payment)" and "Cumulative Interest Paid (No Extra Payment)" line would be great for comparison with "Loan Outstanding" and "Cumulative Interest Paid" line.

Anonymous said...

Dear Sir,

I would like to have some input..example for certain month i would like to pay more to reduce the principal, but yr table cant input this info...can you help? i try to search the formulae online so that i can create my own table to do so.

Yos Favorite said...

This calculator is very useful for home buyer to do the calculation which can same a lot of time.

There is also another useful calculator I found at housing loan calculator.

Warren said...

The housing loan calculator is really useful. Thanks for that. Really appreciate for the help of this community.

butik pengantin

Stew said...

Wow, I have been searching for hours and bumping across several online loan calculator but yours are just much easier to comprehend and use. Thanks for sharing.