In: Accounting
Month | Beginning balance | Add: interest @12.5%/12 | Bill amount | Less: 5% minimum payment | Ending balance |
1 | $ 7,500.00 | $ 78.13 | $ 7,578.13 | $ 378.91 | $ 7,199.22 |
2 | $ 7,199.22 | $ 74.99 | $ 7,274.21 | $ 363.71 | $ 6,910.50 |
3 | $ 6,910.50 | $ 71.98 | $ 6,982.48 | $ 349.12 | $ 6,633.36 |
4 | $ 6,633.36 | $ 69.10 | $ 6,702.46 | $ 335.12 | $ 6,367.33 |
5 | $ 6,367.33 | $ 66.33 | $ 6,433.66 | $ 321.68 | $ 6,111.98 |
6 | $ 6,111.98 | $ 63.67 | $ 6,175.64 | $ 308.78 | $ 5,866.86 |
7 | $ 5,866.86 | $ 61.11 | $ 5,927.98 | $ 296.40 | $ 5,631.58 |
8 | $ 5,631.58 | $ 58.66 | $ 5,690.24 | $ 284.51 | $ 5,405.73 |
9 | $ 5,405.73 | $ 56.31 | $ 5,462.04 | $ 273.10 | $ 5,188.93 |
10 | $ 5,188.93 | $ 54.05 | $ 5,242.99 | $ 262.15 | $ 4,980.84 |
11 | $ 4,980.84 | $ 51.88 | $ 5,032.72 | $ 251.64 | $ 4,781.08 |
12 | $ 4,781.08 | $ 49.80 | $ 4,830.89 | $ 241.54 | $ 4,589.34 |
13 | $ 4,589.34 | $ 47.81 | $ 4,637.15 | $ 231.86 | $ 4,405.29 |
14 | $ 4,405.29 | $ 45.89 | $ 4,451.18 | $ 222.56 | $ 4,228.62 |
15 | $ 4,228.62 | $ 44.05 | $ 4,272.67 | $ 213.63 | $ 4,059.04 |
16 | $ 4,059.04 | $ 42.28 | $ 4,101.32 | $ 205.07 | $ 3,896.25 |
17 | $ 3,896.25 | $ 40.59 | $ 3,936.84 | $ 196.84 | $ 3,740.00 |
18 | $ 3,740.00 | $ 38.96 | $ 3,778.95 | $ 188.95 | $ 3,590.01 |
19 | $ 3,590.01 | $ 37.40 | $ 3,627.40 | $ 181.37 | $ 3,446.03 |
20 | $ 3,446.03 | $ 35.90 | $ 3,481.93 | $ 174.10 | $ 3,307.83 |
21 | $ 3,307.83 | $ 34.46 | $ 3,342.29 | $ 167.11 | $ 3,175.17 |
22 | $ 3,175.17 | $ 33.07 | $ 3,208.25 | $ 160.41 | $ 3,047.84 |
23 | $ 3,047.84 | $ 31.75 | $ 3,079.58 | $ 153.98 | $ 2,925.61 |
24 | $ 2,925.61 | $ 30.48 | $ 2,956.08 | $ 147.80 | $ 2,808.28 |
Balance after 24 months is $2,808.28
Please rate the answer.