Home Loans in Malaysia: FPM Home Loan Planner R1.0

Thursday, April 06, 2006

FPM Home Loan Planner R1.0

FPM Home Loan Planner R1.0 contains a home loan calculator and a home loan repayment planner.

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.

5 Comments:

Hi
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

By Anonymous, at 4:09 PM
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.

Thanks.

By Chen Tong, at 4:08 PM
hello mr chen tong,

just downloaded your planner.

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

thanks.

By selyn, at 4:27 PM
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?

Brian

By Anonymous, at 10:22 AM
good sharing of home loan planning...

By imDavidLee, at 9:40 AM