Hi, thanks for the help, trying to learn how to work this through and understand

Question

Hi, thanks for the help, trying to learn how to work this through and understand excel functions/how they relate 1

A borrower can obtain an 80 percent loan with an 8 percent interest rate and monthly payments. The loan is to be fully amortized over 25 years. Alternatively, he could obtain a 90 percent loan at an 8.5 percent rate with the same loan term. The borrower plans to own the property for the entire loan term.

a. What is the incremental cost of borrowing the additional funds? (Hint: The dollar amount of the loan does not affect the answer.) b. How would your answer change if two points were charged on the 90 percent loan?
c. Would your answer to part (b) change if the borrower planned to own the property for only five years?

Explanation / Answer

1.
=RATE(12*25,PMT(8.5%/12,12*25,1*90%)-PMT(8%/12,12*25,1*80%),1*90%-1*80%)*12
=12.26037049%

2.
=RATE(12*25,PMT(8.5%/12,12*25,1*90%)-PMT(8%/12,12*25,1*80%),1*90%*(1-2%)-1*80%)*12
=15.34868967%

3.
=RATE(12*5,-PMT(8.5%/12,12*25,1*90%)+PMT(8%/12,12*25,1*80%),-1*90%*(1-2%)+1*80%,-FV(8.5%/12,12*5,PMT(8.5%/12,12*25,1*90%),1*90%)+FV(8%/12,12*5,PMT(8%/12,12*25,1*80%),1*80%))*12
=17.9626%

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.