Question

After graduation, you decide that you can pay $202.89 per month extra on your student loan...

After graduation, you decide that you can pay $202.89 per month extra on your student loan (standard monthly payment is 302.85), which has a balance of $60,000 and 20 years of monthly payments remaining. The annual interest rate on the loan is 4.4% How many years early will you be able to pay off the loan?

please solve using excel

Homework Answers

Answer #1
We have to use financial calculator to solve this
put in calculator
FV 0
PV -60,000
PMT 505.74
I 4.4%/12 0.36667%
Compute N          156
Number of month =          156
Number of years =            13
156/12
Therefore early year to pay off loan = 7 year  
20-13
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
After graduation, you decide that you can pay $203.24 per month extra on your student loan...
After graduation, you decide that you can pay $203.24 per month extra on 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 years early will you be able to pay off the loan?
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!!!!!!!
You have an outstanding student loan with required payments of $600 per month for the next...
You have an outstanding student loan with required payments of $600 per month for the next four years. The interest rate on the loan is 9.25% APR. You are considering making an extra payment of $150 today​ (that is, you will pay an extra $150 that you are not required to​ pay). a. If you are required to continue to make payments of $600 per month until the loan is paid​ off, what is the amount of your final​ payment?  ...
You have an outstanding student loan with required payments of $ 600 per month for the...
You have an outstanding student loan with required payments of $ 600 per month for the next four years. The interest rate on the loan is 10 % APR (compounded monthly). Now that you realize your best investment is to prepay your student loan, you decide to prepay as much as you can each month. Looking at your budget, you can afford to pay an extra $ 250 a month in addition to your required monthly payments of $ 600...
You have an outstanding student loan with required payments of $600 per month for the next...
You have an outstanding student loan with required payments of $600 per month for the next four years. The interest rate on the loan is 8% APR​ (monthly). Now that you realize your best investment is to prepay your student​ loan, you decide to prepay as much as you can each month. Looking at your​ budget, you can afford to pay an extra $250 a month in addition to your required monthly payments of $600​ or $850 in total each...
You have an outstanding student loan with required payments of $600 per month for the next...
You have an outstanding student loan with required payments of $600 per month for the next four years. The interest rate on the loan is 8% APR​ (compounded monthly). Now that you realize your best investment is to prepay your student​ loan, you decide to prepay as much as you can each month. Looking at your​ budget, you can afford to pay an extra $175 a month in addition to your required monthly payments of $600​, or $775 in total...
You have an outstanding student loan with required payments of $500 per month for the next...
You have an outstanding student loan with required payments of $500 per month for the next four years. The interest rate on the loan is 8% APR. You are considering making an extra payment of $200 today (that is, you will pay an extra $200 that you are not required to pay). If you are required to continue to make payments of $500 per month until the loan is paid off, what is the amount of your final payment? What...
You have an outstanding student loan with required payments of $600 per month for the next...
You have an outstanding student loan with required payments of $600 per month for the next four years. The interest rate on the loan is 8.25% APR. You are considering making an extra payment of $175 today (that is, you will pay an extra $175 that you are not required to pay). a. If you are required to continue to make payments of $600 per month until the loan is paid off, what is the amount of your final payment?  ...
You have an outstanding student loan with required payments of $ 500 per month for the...
You have an outstanding student loan with required payments of $ 500 per month for the next four years. The interest rate on the loan is 8%APR​ (compounded monthly). Now that you realize your best investment is to prepay your student​ loan, you decide to prepay as much as you can each month. Looking at your​ budget, you can afford to pay an extra $ 250 a month in addition to your required monthly payments of$ 500 ​,or $750 in...
You have an outstanding student loan with required payments of $500 per month for the next...
You have an outstanding student loan with required payments of $500 per month for the next four years. The interest rate on the loan is 8% APR​ (compounded monthly). Now that you realize your best investment is to prepay your student​ loan, you decide to prepay as much as you can each month. Looking at your​ budget, you can afford to pay an extra $175 a month in addition to your required monthly payments of $500​, or $675 in total...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT