In: Finance
Joan borrowed
$15,000.00
to buy a car. She repaid
$4000.00
four
months later and
$6800.00
eight
months later. After twelve months, she borrowed an additional
$4800.00,
and repaid
$4400.00
after
19
months. She paid the entire balance, including the interest, after 24 months. Interest was
6%
compounded monthly for the first year and
5.5%
compounded monthly for the remaining time. What was the size of the final payment?
First of all let us find out the monthly interest rate during the year-1 and later on
Given the interest rate on Year-1 is 6%
Since it is given that it is compounded monthly hence
For year -1
(1+X)12 = 1.06
Hence X = 0.486755%
For Year -2
(1+X)12 = 1.055
X = 0.44717%
Month | Opening Borrowed Amount | Interest Amount | Repaid Amount | Additional Amount Borrowed | Closing Loan Balance |
1 | 15,000.00 | 73.01 | - | - | 15,073.01 |
2 | 15,073.01 | 73.37 | - | - | 15,146.38 |
3 | 15,146.38 | 73.73 | - | - | 15,220.11 |
4 | 15,220.11 | 74.08 | 4,000.00 | - | 11,294.19 |
5 | 11,294.19 | 54.98 | - | - | 11,349.17 |
6 | 11,349.17 | 55.24 | - | - | 11,404.41 |
7 | 11,404.41 | 55.51 | - | - | 11,459.92 |
8 | 11,459.92 | 55.78 | 6,800.00 | - | 4,715.70 |
9 | 4,715.70 | 22.95 | - | - | 4,738.66 |
10 | 4,738.66 | 23.07 | - | - | 4,761.72 |
11 | 4,761.72 | 23.18 | - | - | 4,784.90 |
12 | 4,784.90 | 23.29 | - | 4,800.00 | 9,608.19 |
13 | 9,608.19 | 42.96 | - | - | 9,651.16 |
14 | 9,651.16 | 43.16 | - | - | 9,694.31 |
15 | 9,694.31 | 43.35 | - | - | 9,737.66 |
16 | 9,737.66 | 43.54 | - | - | 9,781.21 |
17 | 9,781.21 | 43.74 | - | - | 9,824.95 |
18 | 9,824.95 | 43.93 | - | - | 9,868.88 |
19 | 9,868.88 | 44.13 | 4,400.00 | - | 5,513.01 |
20 | 5,513.01 | 24.65 | - | - | 5,537.66 |
21 | 5,537.66 | 24.76 | - | - | 5,562.43 |
22 | 5,562.43 | 24.87 | - | - | 5,587.30 |
23 | 5,587.30 | 24.98 | - | - | 5,612.28 |
24 | 5,612.28 | 25.10 | - | - | 5,637.38 |
Hence the amount of loan of final payment will be 5637.32
Please note that interest is calculated using the opening balance at the rate we found out above for year -1 and there after.