Question
Suppose you open a credit card account and charge $100 to the account on the first of each month to pay for your cable and
Suppose you open a credit card account and charge $100 to the account on the first of each month to pay for your cable and Internet subscription. You plan to pay just the minimum payment each month for the first 6 months (until your summer job starts). The APR is 22.99% and the minimum payment is 5.5% of the balance. Use Excel to fill in the values in the table below and answer the questions that follow.
Month | Starting Balance | New Purchases | Balance + Purchases | Finance Charge | New Balance | Minimum Payment |
1 | $0 | $100 | $100 | |||
2 | $100 | |||||
3 | $100 | |||||
4 | $100 | |||||
5 | $100 | |||||
6 | $100 | |||||
7 | XXX | XXX | XXX | XXX | XXX |
Express your answers rounded to the nearest cent.
(a) What is the starting balance at the beginning of the 4th month?
(b) What is the total of the minimum payments?
(c) Your total finance charge is what percent of your total payments? Express your answer rounded to the nearest tenth of a percent.
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