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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!