Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assume you have a credit card balance of $20,000. The annual rate on the balance is 22%. Your bank requires a monthly minimum payment of

Assume you have a credit card balance of $20,000. The annual rate on the balance is 22%. Your bank requires a monthly minimum payment of 4% of the outstanding balance or $60, whichever is higher.
A. How many months will it take to reach $60 payment minimum?
B. How many years will it take to pay off the balance if ONLY minimum required payments are made?
C. If you pay an extra $25 every month, how long will it take to pay off the original balance?
D. How much extra must you pay every month in order to pay off the balance in 5 years?
i dont know how to do this. this is supposed to be done on excel so i need step by step breakdown please.
thank you in advance :)

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

Investing In Cryptocurrency For Dummies

Authors: Kiana Danial

1st Edition

1394200838, 978-1394200832

More Books

Students also viewed these Finance questions