The number of months has been calculated using the NPER function as follows:
=NPER(rate,pmt,pv)
=NPER(8%/12,-650,53000)
=118.05 months or 9.84 years
how long will it take to pay off a loan of $53,000 at an annual rate...
How long will it take to pay off a loan of $53,000 at an annual rate of 12 percent compounded monthly if you make monthly payments of $550? Use five decimal places for the monthly percentage rate in your calculations
How long will it take to pay off a loan of $47,000 at an annual rate of 8 percent compounded monthly if you make monthly payments of $400? Use five decimal places for the monthly percentage rate in your calculations.
How long will it take to pay off a loan of $48,000 at an annual rate of 12 percent compounded monthly if you make monthly payments of $800? Use five decimal places for the monthly percentage rate in your calculations.
How long will it take to pay off a loan of $51 comma 000 at an annual rate of 9 percent compounded monthly if you make monthly payments of $800? Use five decimal places for the monthly percentage rate in your calculations. The number of years it takes to pay off the loan is nothing years. (Round to one decimal place.)
How long will it take to pay off a loan of $50 comma 00050,000 at an annual rate of 99 percent compounded monthly if you make monthly payments of $600600? Use five decimal places for the monthly percentage rate in your calculations. The number of years it takes to pay off the loan is nothing years. (Round to one decimal place.)
(Annuity number of periods) How long will it take to pay off a loan of $54,000 at an annual rate of 11 percent compounded monthly if you make monthly payments of $500? Use five decimal places for the monthly percentage rate in your calculations. The number of years it takes to pay off the loan is ___ years. (Round to one decimal place.)
How long will it take to pay off a loan of $46 comma 000 at an annual rate of 12% compounded monthly if you make monthly payments of $800 (round up)? To pay off the loan, it will take approximately nothing years. (Round up to the nearest integer.)
How many months will it take you to pay off a loan of $20,000 at 5% APR compounded monthly if you make monthly payments of $825?
How many months will it take you to pay off a loan of $19,000 at 5% APR compounded monthly if you make monthly payments of $925?
James wants to take out a loan. He can afford to make monthly payments of 100 dollars and wants to pay the loan off after exactly 30 years. What is the maximum amount that James can afford to borrow if the bank charges interest at an annual rate of 8 percent, compounded monthly? (Give your answer, in dollars, correct to the nearest dollar.) Nicola borrows 60000 dollars from a bank that charges interest at an annual rate of 10 percent,...