Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose you open a credit card account and charge $ 1 5 0 to the account on the first of each month to pay for

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 text in transcribed

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

A Fast And Frugal Finance

Authors: William P. Forbes, Aloysius Igboekwu, Shabnam Mousavi

1st Edition

0128124954, 978-0128124956

More Books

Students also viewed these Finance questions