Your friend Pat has accrued some credit card debt during their studies at UC. No

Question

Your friend Pat has accrued some credit card debt during their studies at UC. Now they are graduating and want to start paying it off. The job they have will allow them to pay $200.00 per month toward outstanding debt and still eat something besides Ramen noodles. They have asked you to help them by using your outstanding Excel skills to create a payment schedule for them to follow. They have debt on three cards: Card 1: $5000 balance, 7.9% Annual Rate, 1% minimum payment required monthly Card 2: $2700 balance, 9.8% Annual Rate, $50/month minimum payment required Card 3: $2350 balance, 11.99% Annual Rate, 2% minimum payment required monthly Construct a monthly payment plan for Pat that shows how to optimally distribute the money available ($200/month) toward each of the three cards. Include a summary sheet showing the amount of interest paid on each card, as well as the total interest paid for all cards.   Construct your solution such that the total amount available each month for payments, as well as the balance on each card can be changed so that you and Pat can perform some WhatIf analysis on the calculations.

Explanation / Answer

Monthly Interest rate Montly Interest Distribution of balance amount in Interest payment ratio Total monthly payment   Card I Balance $5,000 Int. @7.9% 7.9%/12 0.66% $ 32.92 $ 51.00 $ 84 Card II Balance $2,700 Int. @9.8% 9.8%/12 0.82% $ 22.05 $ 34.17 $ 56 Card III, $2,350 Int. @11.99% 11.99%/12 1.00% $ 23.48 $36.38 $ 60 Total monthly interest payments $78.45 $121.55 $ 200 Amount available $200 Balance remained after interest $121.55 Balance amount remained after interest is distributed amongst cards for principal payment on monthly interest payment ratio (32.92:22.05:23.48)

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.