In: Accounting
With a beginning balance of $2500 and no additional charges, there is no grace-period, you will just pay the minimum payment each month for the next year. The APR is 24.99% and the minimum payment each month is 8% of the balance. Determine the finance charge, new balance, and minimum payment required for each of the next year, and the starting balance for month 13:
Answer is as under:
Month A. |
Opening Balance B. |
Minimum Due (8% of Outstanding) C. (8% od B) |
Payment (Equal to minimum Due) D. |
Remaining Balance E. = B - D |
Finance cost @24.99%
annual F = E*24.99%/12 |
New Outstanding G = E + F |
Month 1 | 2,500.00 | 200.00 | 200.00 | 2,300.00 | 47.90 | 2,347.90 |
Month 2 | 2,347.90 | 187.83 | 187.83 | 2,160.07 | 44.98 | 2,205.05 |
Month 3 | 2,205.05 | 176.40 | 176.40 | 2,028.65 | 42.25 | 2,070.89 |
Month 4 | 2,070.89 | 165.67 | 165.67 | 1,905.22 | 39.68 | 1,944.90 |
Month 5 | 1,944.90 | 155.59 | 155.59 | 1,789.30 | 37.26 | 1,826.57 |
Month 6 | 1,826.57 | 146.13 | 146.13 | 1,680.44 | 35.00 | 1,715.44 |
Month 7 | 1,715.44 | 137.23 | 137.23 | 1,578.20 | 32.87 | 1,611.07 |
Month 8 | 1,611.07 | 128.89 | 128.89 | 1,482.18 | 30.87 | 1,513.05 |
Month 9 | 1,513.05 | 121.04 | 121.04 | 1,392.01 | 28.99 | 1,420.99 |
Month 10 | 1,420.99 | 113.68 | 113.68 | 1,307.31 | 27.22 | 1,334.54 |
Month 11 | 1,334.54 | 106.76 | 106.76 | 1,227.78 | 25.57 | 1,253.34 |
Month 12 | 1,253.34 | 100.27 | 100.27 | 1,153.08 | 24.01 | 1,177.09 |
Month 13 | 1,177.09 | |||||
Total | 1,739.50 | 1,739.50 | 416.59 | 20,420.82 |
a. Total of minimum payment is $ 1,739.50
b. Total of Finance Charges is $ 416.59
c. Starting balance after 1 year is $ 1,777.09 (Decrease $ 1,322.91 (Original $ 2,500.00 less after one year $ 1,177.09)
d.23.95% ( Total finance charges divided by total payment; 416.59 divided by 1739.50)
e. Credit card company gets a high rate of Interest on outstanding amount as well as on payment of minimum due they assume that customer is live and will pay remaining balance so no need to create provision for bad-debts.
It is not good for user as user has to pay high interest cost.