Question

Score: 0 of 1 pt 6 of 9 (3 complete) HW Score: 22.22 % , 2 of 9 pts P 5-26 (similar to) Question Help You have an outstanding
0 0
Add a comment Improve this question Transcribed image text
Answer #1

First we will find the present value of the actual student loan using pv formulae in excel

=pv(rate,nper,pmt,fv,type)

=pv(8%/12,4*12,-600,0,0)

=$24,577.15

We use nper formulae in excel to find this:

=nper(rate,pmt,pv,fv,type)

Rate=8%/12(since monthly compounding)

Pmt=-775

Pv=$24,577.15

Fv=0

Type=0

=nper(8%/12,-775, $24,577.15,0,0)

=35.75 months

Add a comment
Know the answer?
Add Answer to:
Score: 0 of 1 pt 6 of 9 (3 complete) HW Score: 22.22 % , 2...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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% 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, or $850 in total...

  • You have an outstanding student loan with required payments of $600 per month for the next four years. The interest...

    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 S250 a month in addition to your required monthly payments of $600, or $850 in total...

  • You have an outstanding student loan with required payments of $550 per month for the next...

    You have an outstanding student loan with required payments of $550 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 $550, or $800 in total...

  • sieno Homework: Assignment 3 Score: 0 of 1 pt Save TS - HW Score: 22.22% 2...

    sieno Homework: Assignment 3 Score: 0 of 1 pt Save TS - HW Score: 22.22% 2 of 9 pts 2.CE.27 Question Heln 1 An agency recently surveyed people from different countries asking them "How important is acquiring wealth to you? The percent who responded that it was more than average importance were: 70.5 country A. 59.4% country B. 76,8% country C 66.7% country D, and 44.1% country E. There were about 1500 respondents per country report showed the accompanying a...

  • UCIE. VOF Pt 9 of 9 (3 complete) P5-40 (similar to) HW Score: 22.22%, 2 of...

    UCIE. VOF Pt 9 of 9 (3 complete) P5-40 (similar to) HW Score: 22.22%, 2 of 9 pts Question Help You are thinking about investing $4,774 in your friend's landscaping business. Even though you know the investment is risky and you can't be sure you expect your investment to be worth $5,637 next year. You notice that the rate for one year Treasury bilis 15. However, you feel that other investments of equal risk to your friends landscape business offer...

  • Save Score: 0 of 1 pt 8 of 9 (3 complete) HW Score: 22.22 % ,...

    Save Score: 0 of 1 pt 8 of 9 (3 complete) HW Score: 22.22 % , 2 of 9 pts P 5-38 (similar to) Question Help What is the shape of the yield curve given in the following term structure? What expectations are investors ikely to have about future interest rates? Term 2 years 10 years 20 years 1 уear 1.96 З уears 2.74 5 years 3.34 7 years Rate (EAR, %) 244 3.76 414 4 92 What is the...

  • Score: 0 of 1 pt 18 of 24 (5 complete) us Econ 3.4.29 EL an, an...

    Score: 0 of 1 pt 18 of 24 (5 complete) us Econ 3.4.29 EL an, an online lending service recently offered 60-month auto loans at 39% compounded monthly to applicants with good credit ratings. you borrow from E-Loan? What is the total interest you will pay for this loan? lf You can borrow S(Round to two decimal places) y to applicants with good credit ratings. If you have a good credit rating and can afford monthly payments of $563, how...

  • Score: 0 of 1 pt 3 of 10 (3 complete) HW Score: 296, 0.2 of 10...

    Score: 0 of 1 pt 3 of 10 (3 complete) HW Score: 296, 0.2 of 10 pts 3 P9-3 (similar to Question Help | * Before-tax cost of debt and after-tax cost of debt David Abbot is buying a new house, and he is taking out a 30-year mortgage David will borrow $200,000 from a bank, and payments on his a. What is the before-tax interest rate (per year) on David's loan? b. What is the after-tax interest rate that...

  • core: 0 of 1 pt HW Score: 75%, 4.5 of 6 p Bus Econ 5.4.50 Question...

    core: 0 of 1 pt HW Score: 75%, 4.5 of 6 p Bus Econ 5.4.50 Question Help A n w employee charged S 7640 on his credit card to relocate for his rst job. After noticing that the interest rate for his balance was 18% compounded monthly, he stopped charging on that account. He wishes to pay off his balance in 2 years using automatic payments sent at the end of each month. a. What monthly payment must he make...

  • Homework: Unit 7 Lab Assignment Save HW Score: 0%, 0 of 40 pts Score: 0 of...

    Homework: Unit 7 Lab Assignment Save HW Score: 0%, 0 of 40 pts Score: 0 of 4 pts 2 of 10 (0 complete) Question Help Problem 4.LO4.14 You are considering the purchase of a BMW MS. You will borrow the money from BMW Financial Services. The terms of the deal are outlined below: BMW MS RWD, 500hp, 0-100 in 4.7s MSRP $110,000 Term 48 months APR 8% Down Payment-So Monthly Payments $2,685.42 The amortized loan payments are a blend of...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT