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?

Solutions

Expert Solution

Answer : Calculation of Number of Months :

Number of Months can be calculated using NPER function of Excel

=NPER(rate,pmt,pv,fv)

where

rate is the effective rate of interest per period i.e 2%

pmt is the periodic payment i.e 600

pv is the balance in credit card i.e 10000

fv is future value i.e 0

=NPER(2%,600,-10000,0)

The number of Months is 20.475 months or 20.48 months

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

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

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 owe $10,000 on a credit card with an interest rate of 15%, which is compounded...

You owe $10,000 on a credit card with an interest rate of 15%, which is compounded monthly. If you make payments of $1,000 per month, how many months will it take you to pay off your debt? (Enter the answer to 2 decimal places)

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

You are paying an effective annual rate of 18.75 percent on your credit card. The interest...

You are paying an effective annual rate of 18.75 percent on your credit card. The interest is compounded monthly. What is the annual percentage rate on this account? APR=

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

Subjects