Dennis Rodman has a $5,500 debt balance on his Visa card that charges an APR of 8 percent compounded monthly. Dennis's current minimum monthly payment is 4 percent of his debt balance, $220. How many months (round up) will it take Dennis to pay off his credit card if he pays the current minimum payment of $220 at the end of each month

Respuesta :

Answer: 27 months

Explanation:

First we need to convert the annual interest into monthly interest which is

Rate = 8% / 12 = 0.67%

The Payment/ PMT = $220

and PV = $5,500

Number of months can be calculated by using the following excel formula:

=NPER(rate,pmt,pv,fv)

The NPER function is a financial function that is used to calculate the number of periods for loans or investments.

=NPER(8%/12,220,-5500,0)

= 27.44 months or 27 months

The number of months will it take Dennis to pay off his credit card is 27 months.

Calculation of the number of months:

Since

Rate = 8% / 12 = 0.67%

The Payment/ PMT = $220

and PV = $5,500

Now the following formula should be used.

=NPER(rate,pmt,pv,fv)

=NPER(8%/12,220,-5500,0)

= 27.44 months or 27 months

hence, The number of months will it take Dennis to pay off his credit card is 27 months.

Learn more about credit card here: https://brainly.com/question/20474049