Question

In: Finance

You have a $20,000 balance on your credit card, which has an interest rate of 21%...

You have a $20,000 balance on your credit card, which has an interest rate of 21% compounded quarterly. How many years will it take you to pay off the balance by making monthly payments of $800?

show alll work of have to isolate t

Solutions

Expert Solution

Rate of interest = Quoted rate = R= 21% compounded quarterly

No of compounding periods in a year = no of quarters in a year = n = 4

Effective annual interest rate = [1 + (R/n)]n - 1 = [1+(21%/4)]4 - 1 = [ 1 + 5.25%]4 - 1 = [ 1.0525]4 - 1 = 1.22712390 - 1 = 0.22712390 = 22.712390%

Monthly rate = [1+Effective annual rate]1/12 - 1 = [1 + 22.712390%]1/12 - 1 = [1.22712390]1/12 - 1 = 1.017202 - 1 = 0.017202 = 1.7202%

Initial balance of credit card = Loan = $20000, Monthly payments = $800

We can find the number months it takes to pay of the credit card balance using NPER Function in excel

Formula to be used in excel: =NPER(rate,-pmt,pv)

Using NPER function in excel, we get number of months to payoff the balance = 32.9629 months

No of years to payoff the balance = No of months to payoff the balance / 12 = 32.9629 / 12 = 2.7469 years

Hence No of years to payoff the balance = 2.7469 years


Related Solutions

You have a $10,000 balance on your credit card, which has an effective monthly interest rate...
You have a $10,000 balance on your credit card, which has an effective monthly interest rate of 2%. How many months will it take you to pay off the balance by making monthly payments of $600?
You have a $8,000 balance on your credit card, which has an effective monthly interest rate...
You have a $8,000 balance on your credit card, which has an effective monthly interest rate of 1.5%. How many months will it take you to pay off the balance by making monthly payments of $400?
You have a $7,000 balance on your credit card, which has an effective monthly interest rate...
You have a $7,000 balance on your credit card, which has an effective monthly interest rate of 1.25%. How many months will it take you to pay off the balance by making monthly payments of $300?
You have a $7,000 balance on your credit card, which has an effective monthly interest rate...
You have a $7,000 balance on your credit card, which has an effective monthly interest rate of 1.25%. How many months will it take you to pay off the balance by making monthly payments of $300?
You have a $8,000 balance on your credit card, which has aneffective monthly interest rate...
You have a $8,000 balance on your credit card, which has an effective monthly interest rate of 1.5%. How many months will it take you to pay off the balance by making monthly payments of $400?
Your credit card has a balance of ?$3100 and an annual interest rate of 18?%. You...
Your credit card has a balance of ?$3100 and an annual interest rate of 18?%. You decide to pay off the balance over two years. If there are no further purchases charged to the? card, you must pay ?$154.76 each month? , and you will pay a total interest of ?$614.24. Assume you decide to pay off the balance over one year rather than two. How much more must you pay each month and how much less will you pay...
Your credit card has a balance of $550 and an annual interest rate of 17%. With...
Your credit card has a balance of $550 and an annual interest rate of 17%. With no further purchases charged to the card and the balance being paid off over five years, the monthly payment is ?$137?, and the total interest paid is ?$2720. You can get a bank loan at 9.5% with a term of six years. a. How much will you pay each? month? How does this compare with the? credit-card payment each? month? Select the correct choice...
You have a $4,000 balance on your credit card. The interest rate on the card is a 17.68% APR, based on monthly compounding.
You have a $4,000 balance on your credit card. The interest rate on the card is a 17.68% APR, based on monthly compounding. Assume that you are not going to add any more charges to the card. If you make monthly (end-of-the-month) payments of $265 each, how long in years will it take you to pay off the card? Input your answer rounded to the nearest 0.1 year (in other words, nearest 10th of a year).
You accumulated a balance of $2,300 on your credit card that carries an interest rate of...
You accumulated a balance of $2,300 on your credit card that carries an interest rate of 17%. You can't afford to pay the $2,300 all at once, but you can pay the minimum payment, which is 2% per month (not less than $25). What is the balance on your card after 5 years?
You owe 2000 dollars on your credit card which has an interest rate of 18% per...
You owe 2000 dollars on your credit card which has an interest rate of 18% per year compounded monthly. If you plan to pay it off in 4 years, what are your monthly payments? 2 decimals What are the total payments? Round to nearest whole dollar. How much total interest is paid? Nearest whole dollar. What is the unpaid balance after 1 year? Round to nearest whole dollar.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT