# How to Evaluate Home Loan offers better than your Banker in 6 step

### With various clamping down measures on property flipping and speculation starting in 2014 (read – new RPGT, new net selling price rule and no DIBS), you probably decided not to heed any of these and proceed to buy more properties for investment anyway. Great, you have my salute and I am sure this article can help you to get the most desirable home loan. Bear in mind that there’s also a very high possibility that BLR is going up, the reason why AIA Fixed rate home loan is “the rage” at the time of this writing.

Just look at this from iMoney and Loanstreet. Note that these websites give you good comparison among home loans but they are lacking in terms of showing you the total interest paid for each of the tenures.

I am talking about something like Package 3 here:

So which one is better in short term or long term? The answer lies within you – how long you are expecting to settle the mortgage? Follow the process below and tweak it to your repayment period to see which suits you best.

Showing you step by step how to compute total interest paid for package#3 will be able to give you sufficient knowledge to evaluate the remaining 2. You must use a financial calculator or knowing how to use PV (Present Value), FV(Future Value) etc function in Excel to be able to follow this, if you don’t already a competent financial adviser whom you can consult.

Stage 1

1. Go to the Compound function of the financial calculator.
2. Make a mental note that the period, n is in months. Reason being home loan interest as we know is calculated on daily rest. To both simplify matters and accuracy reason, monthly rest is good enough
3. Say, repayment tenure is 30 years, therefore it is 360 months.
4. 4.25% per annum is equivalent to 0.3542% per month to tally with #1
5. Say, loan amount is half a million. Enter this as PV
6. Solve for PMT to get monthly repayment of 2,460

Stage 2

1. Go to the Amortization function.
2. Enter “1” in PM1 and “24” (24 months or first 2 years) as PM2.
3. Solve for ∑ INT for total interest paid to mortgage lender in the first 2 years
4. You should get 41,808

Stage 3

1. Compute the total instalments paid in the first 2 years. You should get 59,040
2. Compare this with 41,808. It means the total principal reduced is 17,232

Stage 4

1. From year 3 until year 30, use back the steps in First stage to solve for PMT
2. Bear in mind the loan balance now is 500k minus 17,232.
3. The monthly repayment starting from year 3 is 2,670

Stage 5

1. Repeat steps in Second stage. PM1 is “1” and PM2 is “336”
2. Solve for ∑ INT for total interest paid to mortgage lender for the remaining years
3. You should get 414,212

Stage 6

1. Sum up the total interest paid from year 1 to year 30.
2. This should be around 456k

By now you should have no problem calculating total interest paid for Package 1, which is pretty straightforward at 449,845.

Click below (redirects to AskCF.com) if you need to see the video on exactly how every steps is computed. Members of AskCF.com have access to the full video on how to go about computing this.