Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sarah has maxed out her credit card and owes $20,000. The annual interest on her credit card is 18%. The minimum payment for some credit

Sarah has maxed out her credit card and owes $20,000. The annual interest on her credit card is 18%.

  1. The minimum payment for some credit cards is 2% of what you owe. What is Sarahs payment?
  2. Suppose Sarah continues to pay the amount found in part 1, how long until she has paid off her credit card dept? Assume she doesnt charge anything else.
  3. What is the total amount she spent to cover the $20,000 debt?
  4. Suppose Sarah decides to pay $550 per month, how long until she pays off the credit card?
  5. How much does she save by paying $550 a month?
  6. Suppose Sarah is getting married in 18 months, what should she pay every month to clear her credit card by the time she is married?

This assignment must be done using excel. Your final presentation may be in excel or as a word document.. You must label what you are doing and show all excel spread sheets that you used. You must answer every question with a sentence.

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

Step: 3

blur-text-image

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

Financial Accounting Working Papers Tools For Business Decision Making

Authors: Paul D. Kimmel ,Jerry J. Weygandt ,Donald E. Kieso

6th Edition

0470887931, 978-0470887936

More Books

Students also viewed these Accounting questions

Question

4. Identify cultural variations in communication style.

Answered: 1 week ago