Detailed working is attached below
2 alternatives are given for question 1 due to confusion regarding whether to consider 820 as opening balance or 1200.
Answers are rounded off to nearerest 2 digits
Thanks
Name: Section 10, Credit Cards 1. With a beginning balance of $1200 and no additional charges...
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...
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...
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 $...
Assume that you start with a balance of $5000 on your MasterCard. Assume that MasterCard has finance charges of 12% APR and that each month you make only the minimum payment of 4% of the balance. During the first month, you charge $250, and during the second month, you charge $500. Complete the following table. (Round your answers to the nearest cent.) Previous balance Minimum payment Purchases Finance charge New balance Month 1 $5000.00 $ $ $ $ Month 2...
1. Which of the following is an advantage of using credit cards? (Points : 1) Credit card accounts charge monthly interest. It is very easy to charge more than you can pay off each month. If you pay late, you will be charged a late fee. They are convenient.2. The amount left when you subtract last month's payment from last month's balance on a credit card statement is the (Points : 1) APR. unpaid balance. new balance. minimum payment.3. The...
#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 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 $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 $ $ $ $...
Assume that you start with a balance of $4000 on your MasterCard. Assume that MasterCard has finance charges of 16% APR and that each month you make only the minimum payment of 4% of the balance. During the first month, you charge $250, and during the second month, you charge $500. Complete the following table. (Round your answers to the nearest cent.) Minimum payment Purchases New balance Previous balance $4000.00 Finance charge $ 53.17 ✓ $250 " Month 1 Month...
9. Credit Cards: a. If you have a balance of $1,245.00 on your credit card, how long will it take you to pay off the balance if you make $50.00/month payments until it is paid off? The APR is 19%. b. What will be your monthly payment on a credit card with a balance of $2,456.80, if you desire to pay it off in 2 years, at an APR of 23.99%? 10. A furniture company allows customers to purchase household...