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