Question

In: Finance

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).

Solutions

Expert Solution

The number of years is calculated using the NPER:

= NPER(rate,-pmt,pv)

= NPER(17.68%/12,-265,4000)

= 17.2 years

 

The number of years is calculated using the NPER is 17.2 years.

 

Where, rate is periodic rate, pmt is payment per period, pv is present value.


The number of years is calculated using the NPER is 17.2 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?
You have $4,000 on a credit card that charges a 14% interest rate. If you want...
You have $4,000 on a credit card that charges a 14% interest rate. If you want to pay off the credit card in 4 years, how much will you need to pay each month (assuming you don't charge anything new to the card)?
For a credit card with a balance of $10,500 and an interest rate of 21.99% (monthly...
For a credit card with a balance of $10,500 and an interest rate of 21.99% (monthly compounding, charged on the outstanding balance each month), how much total interest will you pay over the repayment period if your payment each month is $245?
You have a $7500 balance on your credit card. There’s a 12.5% apr. you have to...
You have a $7500 balance on your credit card. There’s a 12.5% apr. you have to pay 5% of the balance as your minimum payment. What is your balance after 24 months
You have a credit card with an APR of 24%. You begin with a balance of...
You have a credit card with an APR of 24%. You begin with a balance of $800. In the first month you make a payment of $400 and you make charges amounting to $350. In the second month you make a payment of $400 and you make new charges of $650. Complete the following table. (Round your answers to the nearest cent.) Previous balance Payments Purchases Finance charge New balance Month 1 $800 $ $ $ $ Month 2 $...
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
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT