Question

A borrower can obtain an 80 percent loan with an 8% 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% 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 ve years?

Answer 1

(a) 12.26037049%

(b) 15.34868967%

(c) 17.9626%

Step-by-step explanation:

(a)

=
`RATE(12* 25,PMT((8.5 \ percent)/(12) ,12* 25,1* 90 \ percent)-PMT((8 \ percent)/(12) ,12* 25,1* 80 \ percent),1* 90\ percent-1* 80 \ percent)* 12`

=
`12.26037049`%

(b)

=
`RATE(12* 25,PMT((8.5 \ percent)/(12) ,12* 25,1* 90 \ percent)-PMT((8 \ percent)/(12) ,12* 25,1* 80 \ percent),1* 90 \ percent* (1-2 \ percent)-1 * 80 \ percent)* 12`

=
`15.34868967`%

(c)

=
`[RATE(12* 5,-PMT((8.5 \ percent)/(12) ,12* 25,1* 90 \ percent)+PMT((8 \ percent)/(12) ,12* 25,1* 80 \ percent),-1* 90 \ percent* (1-2 \ percent)+1* 80 \ percent],-[FV((8.5 \ percent)/(12) ,12* 5,PMT((8.5 \ percent)/(12) ,12* 25,1* 90 \ percent),1* 90 \ percent)]+[FV((8 \ percent)/(12) ,12* 5,PMT((8 \ percent)/(12) ,12* 25,1* 80 \ percent),1* 80 \ percent))* 12]`=
`17.9626`%

Note: percent = %