Suppose you open a credit card account and charge $150 to the account on the...

50.1K

Verified Solution

Question

Accounting

Suppose you open a credit card account and charge $150 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 14.99% and the minimum payment is 4% of the balance. Use Excel to fill in the values in the table below and answer the questions that follow.
\table[[Month,Starting Balance,New Purchases,Balance + Purchases,Finance Charge New Balance Minimum Payment],[1,$0,$150,$150,],[2,$150,,,],[3,$150,,,],[4,$150,,,],[5,$150,,,],[6,$150,xxx,XXX,],[7,xxx,xxx,,]]
Express your answers rounded to the nearest cent.
(a) What is the starting balance at the beginling of the 7th month?
(b) What is the starting balance at the beginning of the 4th month?
(c) Your total finance charge is what percent of your total payments?
Express your answer rounded to the nearest tenth of a percent.
image

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students