In: Finance
A MasterCard statement shows a balance of $510 at 13.2% compounded monthly. What monthly payment will pay off this debt in 1 year 7 months? (Round your answer to the nearest cent.)
| EAR = [(1 +stated rate/no. of compounding periods) ^no. of compounding periods - 1]* 100 |
| Effective Annual Rate = ((1+13.2/12*100)^12-1)*100 |
| Effective Annual Rate% = 14.03 |
| Monthly rate(M)= | yearly rate/12= | 1.17% | Monthly payment= | 30.09 | |
| Month | Beginning balance (A) | Monthly payment | Interest = M*A | Principal paid | Ending balance |
| 1 | 510.00 | 30.09 | 5.96 | 24.13 | 485.87 |
| 2 | 485.87 | 30.09 | 5.68 | 24.41 | 461.46 |
| 3 | 461.46 | 30.09 | 5.40 | 24.69 | 436.77 |
| 4 | 436.77 | 30.09 | 5.11 | 24.98 | 411.79 |
| 5 | 411.79 | 30.09 | 4.81 | 25.28 | 386.51 |
| 6 | 386.51 | 30.09 | 4.52 | 25.57 | 360.94 |
| 7 | 360.94 | 30.09 | 4.22 | 25.87 | 335.07 |
| 8 | 335.07 | 30.09 | 3.92 | 26.17 | 308.90 |
| 9 | 308.90 | 30.09 | 3.61 | 26.48 | 282.42 |
| 10 | 282.42 | 30.09 | 3.30 | 26.79 | 255.63 |
| 11 | 255.63 | 30.09 | 2.99 | 27.10 | 228.53 |
| 12 | 228.53 | 30.09 | 2.67 | 27.42 | 201.11 |
| 13 | 201.11 | 30.09 | 2.35 | 27.74 | 173.38 |
| 14 | 173.38 | 30.09 | 2.03 | 28.06 | 145.31 |
| 15 | 145.31 | 30.09 | 1.70 | 28.39 | 116.92 |
| 16 | 116.92 | 30.09 | 1.37 | 28.72 | 88.20 |
| 17 | 88.20 | 30.09 | 1.03 | 29.06 | 59.14 |
| 18 | 59.14 | 30.09 | 0.69 | 29.40 | 29.74 |
| 19 | 29.74 | 30.09 | 0.35 | 29.74 | 0.00 |