In: Accounting
Maggie Kool buys an air conditioner with $100 down and 35 equal installments of $25. The total purchase price(cash price) is $600. If Maggie pay off the bill after the 23 payment. what rebate is Maggie entitled to and what will be the final payoff?
Solution:
Let imputed rate of interest in installment is i
Purchase price of AC = $600
Down payment = $100
Therefore present value of installment at i interest rate = $600 - $100 = $500
$25 * Cumulative PV factor for 35 periods at i rate = $500
Cumulative PV factor for 35 periods at i rate = 20
Now refer to PV table, the factor 20 at 35 periods come at discount rate of 3.50%
Hence imputed interest rate in installment is 3.50%
Loan Amortization Schedule | |||
Period | Cash Paid | Interest | Carrying value |
0 | $500 | ||
1 | $25 | $18 | $493 |
2 | $25 | $17 | $485 |
3 | $25 | $17 | $477 |
4 | $25 | $17 | $468 |
5 | $25 | $16 | $460 |
6 | $25 | $16 | $451 |
7 | $25 | $16 | $442 |
8 | $25 | $15 | $432 |
9 | $25 | $15 | $422 |
10 | $25 | $15 | $412 |
11 | $25 | $14 | $401 |
12 | $25 | $14 | $390 |
13 | $25 | $14 | $379 |
14 | $25 | $13 | $367 |
15 | $25 | $13 | $355 |
16 | $25 | $12 | $343 |
17 | $25 | $12 | $330 |
18 | $25 | $12 | $316 |
19 | $25 | $11 | $302 |
20 | $25 | $11 | $288 |
21 | $25 | $10 | $273 |
22 | $25 | $10 | $258 |
23 | $25 | $9 | $242 |
24 | $25 | $8 | $225 |
25 | $25 | $8 | $208 |
26 | $25 | $7 | $190 |
27 | $25 | $7 | $172 |
28 | $25 | $6 | $153 |
29 | $25 | $5 | $133 |
30 | $25 | $5 | $113 |
31 | $25 | $4 | $92 |
32 | $25 | $3 | $70 |
33 | $25 | $2 | $47 |
34 | $25 | $2 | $24 |
35 | $25 | $1 | $0 |
Carrying value after payment of 23rd installment = $242
Remaining installmetn value after 23 rd payment = $25*12 = $300
Rebate entitled by Maggie = $300 - $242 = $58
Final payoff amount after 23rd installment = $242