Math

PLEASE HELP ASAP!!!
When you use a credit card, you are charged interest each month on the balance in your account. You can use a spreadsheet to investigate the interest chargeed n a credit-card account. you use a credit card to buy a $450 airline ticket. you are charged 1.8% monthly interest on your account balance, and you make a $40 payment each month. Using a spreadsheet, ccreate a spreadsheet with the formulas shown in red.

A1: Month B1: Balance C1: Planned Monthly Payment D1: Interest E1:New Balance F1: Total interest
A2: 1 B2: 450 C2: (always 40) D2: B2*0.018 E2: =B2+D2-C2 F2: =D2
A3: =A2+1 B3: =E2 C3: 40 D3: B3*0.018 E3:=B3+D3-C3 F3: F2+D3

Please continue on till Month 12.

  1. 👍 0
  2. 👎 0
  3. 👁 224
  1. BTW PLEASE TYPE YOUR SPREADSHEET!

    1. 👍 0
    2. 👎 0

Respond to this Question

First Name

Your Response

Similar Questions

  1. 8TH GRADE MATH

    PLEASE HELP ASAP!!! When you use a credit card, you are charged interest each month on the balance in your account. You can use a spreadsheet to investigate the interest chargeed n a credit-card account. you use a credit card to

    asked by Britney on March 2, 2015
  2. Math

    Interest is a concept familiar to most people: every credit card in existence has a term called annual percentage rate (APR), which is an interest rate. Suppose you charged $1,000 to a credit card that has a minimum payment each

    asked by Dan on February 18, 2014
  3. Math

    Interest is a concept familiar to most people: every credit card in existence has a term called annual percentage rate (APR), which is an interest rate. Suppose you charged $1,000 to a credit card that has a minimum payment each

    asked by Crystal on February 8, 2016
  4. finanance

    2. You charged $ 1,000 on your credit card for Christmas presents. Your credit card company charges you 16 % annual interest, compounded monthly. If you make the minimum payments of $25 per month, how long will it take [to the

    asked by ananoumous on March 14, 2010
  5. Math

    Interest is a concept familiar to most people: every credit card in existence has a term called annual percentage rate (APR), which is an interest rate. Suppose you charged $1,000 to a credit card that has a minimum payment each

    asked by Anonymous on October 24, 2014
  1. Intermediate Algebra

    Suppose you have a credit card debt of $6000. Last month, the bank charged you $85 interest on the deb. The solution to the equation is 85=6000/12 r represents the annual interest rate on the credit card. Find the annual interest

    asked by Anonymous1234 on November 14, 2014
  2. computer programming

    Paying Off Credit Card Debt Each month, a credit card statement will come with the option for you to pay a minimum amount of your charge, usually 2% of the balance due. However, the credit card company earns money by charging

    asked by abiola olumide on December 18, 2013
  3. Computer science

    Paying Off Credit Card Debt Each month, a credit card statement will come with the option for you to pay a minimum amount of your charge, usually 2% of the balance due. However, the credit card company earns money by charging

    asked by Owoeye seyifunmi on December 22, 2013
  4. com155

    Having a credit card could get someone into much trouble if it is not used responsibly. I personally have nightmares when it concerns credit cards. I do not like paying interest on something when it is not necessary. I learned how

    asked by Joe on April 3, 2011
  5. consumer math

    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

    asked by josh patterson on February 19, 2012

More Similar Questions