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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- types of home loans and qualifications
- sally mae loans and grants
- student loans and home buying
- student loans and buying a house
- student loans and tax refund
- global loans and financial services
- student loans and government employees
- startup business loans and grants
- exercise trivia questions and answers
- exercise quiz questions and answers
- practice exercise of future tense
- microsoft word practice exercise worksheets