Practice Exercise: Mortgages, Loans, and Repayments



Exactly ten years ago, you purchased a $150,000 investment property. The terms of the loan were $15,000 down with the remainder to be repaid in monthly instalments over the next 25 years. The interest rate is 8.4% p.a. fixed for the life of the loan and interest compounds monthly. Since interest paid on the loan is an allowable deduction for tax purposes, you need to figure out how much interest you paid to the bank over the last year. Also, you have some surplus cash at the moment and would like to know how much you would save on each monthly repayment if you made an extra payment of $20,000 now and kept the term of the loan the same.

Step 1: Calculate the interest costs from the previous year (Year 10).

This part of the question involves separating the principal and interest components of your loan repayments. The first thing we need to calculate is the monthly repayment over the course of the loan. The information required for this computation is summarised below:

|Summary Information: Original Loan |

|Original Loan Amount (PV) |150,000 – 15,000 = 135,000 |

|Monthly Repayment (a) |? |

|Monthly Interest Rate (i) |0.07% (the annual rate divided by 12) |

|Number of Repayments (n) |300 (25 years of monthly repayments) |

To compute the amount of the monthly repayment, set the present value of the series of repayments (an annuity) equal to the amount borrowed:

[pic]

in which case the monthly repayment, a, is $1,078.

The interest paid over the tenth year of the loan can be calculated by comparing the total repayments for that year to the reduction in principal of the loan between the start and end of the year. We know that the repayments of a loan comprise both a principal and an interest component so the interest costs can be calculated as total repayments – reduction in principal.

The reduction in principal over the tenth year is the difference between the balance outstanding at the end of the ninth year and the balance outstanding at the end of the tenth year. The principal outstanding at the end of nine years is determined by computing the present value of all remaining repayments at that time:

[pic]

The principal outstanding at the end of ten years is determined by computing the present value of all remaining repayments at that time:

[pic]

Therefore, the reduction in principal over the tenth year is 113,648.25 – 110,125.11 = $3,523.14.

Moreover, the total repayments made during the year total 1078 ( 12 = $12,936.

The difference between these two amounts gives us the interest payments for the year:

[pic]

Step 2: Calculate monthly repayments after the lump sum payment.

The second part of this question involves a simple recalculation of the repayments over the remaining course of the loan. The payment of the lump sum will reduce the principal outstanding on the loan by $20,000. We calculated the outstanding principal at the end of Year 10 to be $110,125. The new principal amount (PV) is, therefore, 110,125 – 20,000 = $90,125.

|Summary Information: After Lump Sum Payment |

|Original Loan Amount (PV) |110,125 – 20,000 = 90,125 |

|Monthly Repayment (a) |? |

|Monthly Interest Rate (i) |0.07% (the annual rate divided by 12) |

|Number of Repayments (n) |180 (15 years of monthly repayments) |

[pic]

in which case the monthly repayment, a, is $882.22. This represents a saving of $195.78 on each repayment.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download