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.

Junaid answered 1 year ago

Next > < Previous

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

Assume you have a balance of $1400 on a credit card with an APR of 18%,...

Assume you have a balance of $1400 on a credit card with an APR of 18%, or 1.5% per month. You start making monthly payments of $200, but at the same time you charge an additional $ 60 per month to the credit card. Assume that interest for a given month is based on the balance for the previous month. The following table shows how you can calculate your monthly balance. Complete and extend the table to show the balance...

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?

Subjects