Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Analysis for Financial Management

Authors: Robert c. Higgins

8th edition

73041807, 73041803, 978-0073041803

More Books

Students also viewed these Finance questions