In: Finance
A loan of $5000 is repaid with annual payments at the end of each year of $1200,$800,$1300 and X. Assume the loan has 10% effective interest per year. a) Determine X b) Determine the amount of interest paid with the third payment.
Loan amortisation schedule | ||||
Year | Annual pmts. | Tow. Int. at 10% on O/s loan bal. | Tow. Loan | Loan bal. |
1 | 2 | 3=Prev. 5*10% | 4=2-3 | 5=Prev. 5-Current 4 |
0 | 5000 | |||
1 | 1200 | 500 | 700 | 4300 |
2 | 800 | 430 | 370 | 3930 |
3 | 1300 | 393 | 907 | 3023 |
4 | 3325.3 | 302.3 | 3023 | 0 |
Total | 6625.3 | 1625.3 | 5000 |
The present value of the loan= 5000 |
as the effective interest is given as 10% |
with every annual pmt. We need to subtract the interest on the o/s bal. of the loan |
to see how much of the loan is repaid |
Now, subtract that princpal paid from the previous loan bal. --we get the principal o/s at start of next yr. |
Like, this we need to calculate till end of 3rd year ---to find X |
to do that, it is better to draw up a loan amortisation schedule/Table , as above |
to determine the answer fo the questions. |
So, reading from the above amortisation table, |
a) X= $ 3325.3 |
& |
b) The amount of interest paid with the third payment= $ 393 ( 3930*10%) |