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.
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started