Question

In: Finance

How long will it take to pay off a loan of $45,000 at an annual rate...

How long will it take to pay off a loan of $45,000 at an annual rate of 8 percent compounded monthly if you make monthly payments of $600? Use five decimal places for the monthly percentage rate in your calculations.

Solutions

Expert Solution

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

As nothing was mentioned excel is used.

ANSWER IS GIVEN IN MONTHS (rounded) AND ALSO IN YEARS (rounded to 2 decimals)


Related Solutions

How long will it take to pay off a loan of ​$54,000 at an annual rate...
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 ​$750​? Use five decimal places for the monthly percentage rate in your calculations.
How long will it take to pay off a loan of ​$52,000 at an annual rate...
How long will it take to pay off a loan of ​$52,000 at an annual rate of 12 percent compounded monthly if you make monthly payments of ​$750​? 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 would it take for S&S Air to pay off the smart loan assuming 30-year...
How long would it take for S&S Air to pay off the smart loan assuming 30-year traditional mortgage payments? Loan Amount: $35,000,000.00 6.1% Interest Rate (if possible, in Excel)
If you take out a car loan for $35,000, will pay an annual interest rate of...
If you take out a car loan for $35,000, will pay an annual interest rate of 4% on the loan, and make monthly payments of $547.58, how many payments will you need to make? -What are you solving for? -What is your answer?
How long will it take for $45,000 placed in a savings account earning​ 10% interest rate...
How long will it take for $45,000 placed in a savings account earning​ 10% interest rate per year to grow into $70,000​? A. 5.64 years B. 5.14 years C. 4.64 years D. 4.14 years
You take out a loan for 10000. You pay off the loan with monthly payments of...
You take out a loan for 10000. You pay off the loan with monthly payments of 90 for 10 years. (a) What is the monthly effective rate? What is the annual effective rate? (b) What is the outstanding loan balance immediately after the 7th payment? Calculate using both the retrospective and prospective formulas. (c) Assume you miss the 13th and 53rd payments, what will be the outstanding loan balance after the 71st payment? actuarial science
When using time value of money to calculate how long it will take to pay off...
When using time value of money to calculate how long it will take to pay off a debt, what do you solve for? A) Number of Periods B) Present Value C) Interest Rate D) Future Value
Credit Card Debt – How long will it take me to pay off my credit card...
Credit Card Debt – How long will it take me to pay off my credit card balance of $3,750? The credit card company is charging 10% interest. I can afford to pay $150/month, but would prefer to pay $100/month because I want to continue my cable service. Please show me the answer to both scenarios.
At a growth rate (annual interest rate) of 9%; how long (years) it would take a...
At a growth rate (annual interest rate) of 9%; how long (years) it would take a sum to triple? Select the period that is closest to the correct answer.   
25. The annual payment necessary to amortize (pay off) a 5% $200,000 loan with a 20...
25. The annual payment necessary to amortize (pay off) a 5% $200,000 loan with a 20 year repayment period (annual end of year payments required) is   __________________ 26. A prospective new creditor (a vendor for materials purchases) is evaluating financial ratios for ABC Company. The creditor is likely most interested in the __________ ratios a. inventory management related b. return on equity related c. return on assets related d. liquidity related 27. ABC Inc. signs a note payable in the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT