HomeworkLib
Question

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

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 20.99% and the minimum payment is 4.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 $150 $150
2 $150
3 $150
4 $150
5 $150
6 $150
7 XXX XXX XXX XXX XXX

Express your answers rounded to the nearest cent.

(a) What is the total of the minimum payments?
$

(b) What is the starting balance at the beginning of the 7th month?
$

(c) Your total finance charge is what percent of your total payments?
Express your answer rounded to the nearest tenth of a percent.
%

math   Advanced-Math   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Sfarting balance New balanc prev/ous monta-mini ment nancial charges- C ealauha ManCI Finanotal charges inancr Minimom paymenSlarting mon Bal:e minimum anu FiQincio purckranc Balana t prev purchau oulh min purdhou Fina t25 15g,195 476 2(25 125 153.93Balana at the beinne 舌 1456.24

0 0
Add a comment
Know the answer?
Add Answer to:
Suppose you open a credit card account and charge $150 to the account on the first...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Name: Section 10, Credit Cards 1. With a beginning balance of $1200 and no additional charges...

    Name: Section 10, Credit Cards 1. With a beginning balance of $1200 and no additional charges during the next three months, you will just pay the minimum payment each month for the next three months. The APR is 24.99% and the minimum payment each month is 3% of the balance. Determine the finance charge, new balance, and minimum payment required for each of the next three months, and the starting balance for month 4 in the table below: Month Carry-Over...

  • #1.) Here is a sample credit card statemet. Use the CARD Statement to answer problems a-...

    #1.) Here is a sample credit card statemet. Use the CARD Statement to answer problems a- d. CARD Statement Account Number 1234 1234 1234 1234 O Statement Closing Date 11/06/08 Credit Line $2,100.00 Available Credit $1,576.80 TERESA TORRES 123 ANY STREET CITY CA 12345 o Account Summary Previous Balance - Credits - Payments + Purchases & Other Chgs - Cash Advances • FINANCE CHARGE - New Balance Payment Information O New Balance O Scheduled Minimum Payment O Scheduled Payment Due...

  • You have a credit card with an APR of 12%. You begin with a balance of...

    You have a credit card with an APR of 12%. You begin with a balance of $350, in response to which you make a payment of $75. The first month you make charges amounting to $50. You make a payment of $75 to reduce the new balance, and the second month you charge $60. Complete the following table. (Round your answers to the nearest cent.) Previous Finance New balance Payments Purchases charge balance Month 1 $350.00 $ Month 2 $...

  • You have a credit card with an APR of 20.8%. You begin with a balance of...

    You have a credit card with an APR of 20.8%. You begin with a balance of $1500, in response to which you make a payment of $300. The first month you make charges amounting to $550. You make a payment of $300 to reduce the new balance, and the second month you charge $750. Complete the following table. (Round your answers to the nearest cent.) Previous Finance New Payments Purchases balance charge balance Month 1 $1500 $ $ Month 2...

  • You have a credit card with an APR of 12%. You begin with a balance of $250, in response to which you make a payment of $75. The first month you make charges amounting to $60. You make a payment of $7...

    You have a credit card with an APR of 12%. You begin with a balance of $250, in response to which you make a payment of $75. The first month you make charges amounting to $60. You make a payment of $75 to reduce the new balance, and the second month you charge $65. Complete the following table. (Round your answers to the nearest cent.) Previous balance Payments Purchases Finance charge New balance Month 1 $250.00 $ $ $ $...

  • Suppose you owe ​$600 on your credit card and you decide to make no new purchases...

    Suppose you owe ​$600 on your credit card and you decide to make no new purchases and to make the minimum monthly payment on the account. Assuming that the interest rate on your card is 1​% per month on the unpaid balance and that the minimum payment is 2​% of the total​ (balance plus​ interest), your balance after t months is given by ​B(t)=600​(0.9898t​). Find your balance at each of the given times. Complete parts​ (a) through​ (e) below. ​(a)...

  • Calibri (Body) 12 A- A A Style Math 123 Quantitative Reasoning Section 10 Excel Credit Cards...

    Calibri (Body) 12 A- A A Style Math 123 Quantitative Reasoning Section 10 Excel Credit Cards Assignment 1. Create an Excel spreadsheet that can do the calculations for the credit card below. Using formulas and the drag function of Excel (see the notes), find the values for 1 year of charges With a beginning balance of $3200 and no additional charges, you will just pay the minimum payment each month for the next year. The APR is 21.99% and the...

  • Please help use this credit card table to answer the following questions. directions Use the credit...

    Please help use this credit card table to answer the following questions. directions Use the credit card statement below to answer these questions: 1. What is the date of the statement? 2. What is the Annual Percentage Rate (APR)? 3. What is the corresponding periodic rate? 4. What is the new balance? 5. What was the previous balance? 6. How many charges were made during the billing cycle? 7. How many credits and payments were made during the billing cycle?...

  • a new employee charge $8310 on his credit card to relocate for a first job after...

    a new employee charge $8310 on his credit card to relocate for a first job after noticing that the interest rate for his balance is 24% compound monthly he stopped charging a lot of count he wishes to pay off his balance and 4 years using automatic payments since at the end of each month what monthly payment must he make to pay off the account at the end of four years

  • Calculating minimum payment. You have a credit card with an APR of 36%. The minimum payment...

    Calculating minimum payment. You have a credit card with an APR of 36%. The minimum payment is 10% of the balance. Suppose you have a balance of $750. You decide to stop charging and make only the minimum payment. Calculate the minimum payment for the first and second payments. (Be sure to take into account the finance charges. Round your answers to the nearest cent.) first payment $ 75 second payment $ 67.5 eBook

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT