Question

How long (in months) would it take to pay off a student loan totaling $12,000 if...

How long (in months) would it take to pay off a student loan totaling $12,000 if a monthly payment of $300 is made each month and the appropriate rate of interest is 4% annual rate compound monthly?

Please show Step by step

Homework Answers

Answer #1

Loan Amount = Monthly Payment * present value annuity factor(Interest per month,total payments)

12000 = 300 * (1 - (1 + r)^-n) / r

r = Interest per month = 4%/12 = 0.33%

n = Number of months

12000 = 300 * (1 - (1 + 0.33%)^-n) / 0.33%

12000 = 90000 * (1 - (1 + 0.33%)^-n)

0.1333 = (1 - (1 + 0.33%)^-n)

1.0033^-n = 0.8667

Apply log on both sides

Log(1.0033^-n) = Log 0.8667

-n * Log (1.0033) = log 0.8667

-n = -0.06215 / 0.001445

n = number of months required to payoff loan balance = 43 Months

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
How long (in months) would it take to pay off a student loan totally $10,000 if...
How long (in months) would it take to pay off a student loan totally $10,000 if a monthly payment of $300 is made each month and the appropriate rate of intrest is 4% annual rate compounded monthly? 38.0 33.4 35.4 46.7 43.0
How long will it take to pay off a loan of $55,000 at an annual rate...
How long will it take to pay off a loan of $55,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 __ years? Please show your work.
How long​ (in years) will it take Michael Garbin to pay off a ​$5000 loan with...
How long​ (in years) will it take Michael Garbin to pay off a ​$5000 loan with monthly payments of ​$156.49 if the​ add-on interest rate is 5.1​%? Michael Garbin would take ___ years to pay off a ​$5000 loan amount.
 How long will it take to pay off a loan of ​$50,000 at an annual rate...
 How long will it take to pay off a loan of ​$50,000 at an annual rate of 11 percent compounded monthly if you make monthly payments of ​$550​? 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.
 How long will it take to pay off a loan of ​$49 comma 00049,000 at an...
 How long will it take to pay off a loan of ​$49 comma 00049,000 at an annual rate of 1111 percent compounded monthly if you make monthly payments of ​$700700​? 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 $52,000 at an annual rate...
How long will it take to pay off a loan of $52,000 at an annual rate of 8% compounded monthly if you make monthly payments of ​$750​? Use five decimal places for the monthly percentage rate in your calculations.
​(Annuity number of​ periods) How long will it take to pay off a loan of ​$47,000...
​(Annuity number of​ periods) How long will it take to pay off a loan of ​$47,000 at an annual rate of 9 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 $55,000 at an annual rate...
How long will it take to pay off a loan of $55,000 at an annual rate of 9 percent compounded monthly if you make monthly payments of $650 ? Use five decimal places for the monthly percentage rate in your calculations.  ​(Round to one decimal​ place.)
(Annuity number of​ periods)  How long will it take to pay off a loan of ​$51...
(Annuity number of​ periods)  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 ​$700​? 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.)
Aftergraduation, you decide that you can pay $203.24 per month extraon your student loan (standard monthly...
Aftergraduation, you decide that you can pay $203.24 per month extraon your student loan (standard monthly payment is 302.99), which has a balance of $50,000 and 20 years of monthly payments remaining.  The annual interest rate on the loan is 4%  How many yearsearly will you be able to pay off the loan? Please show using excel formulas!!!!!!!