Question
Looking for help with excel spreadsheet formulas Assume you have a $3,500 balance on a credit card with a 14.5% APR.You are only able to
Looking for help with excel spreadsheet formulas
Assume you have a $3,500 balance on a credit card with a 14.5% APR.You are only able to make $150 payments each month and you get an offer for a new credit card which will give you 0% on transferred balances for 6 months and then switch to a 16.7% rate.They will charge you 3% on any balance you transfer.
a.)To determine how long it will take you to pay-off the current card, complete the spreadsheet by computing the balance, interest, and new balance each month.Remember that periodic interest is charged on the balance at the beginning of each month using the periodic interest rate.
b.)How many months will it take to pay off this card?Answer the first month that has a negative ending balance.
c.)How much will you spend in total to pay-off this card?Note that you will be charged interest in the last month but you will not owe a full $150..
e.)How many months will it take to pay off this card?Answer the first month that has a negative ending balance.
f.)How much will you spend in total to pay-off this card?Note that you will be charged interest in the last month but you will not owe a full $350.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started