Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Care And Counsel For Combat Trauma Training Program Workbook For Audit Only

Authors: Cru Military, American Association Of Christian Counselors, Light University, Karen D Watkins

1st Edition

0986363081, 978-0986363085

More Books

Students also viewed these Accounting questions

Question

Distinguish between a LAN, MAN, and WAN.

Answered: 1 week ago