You have had a 15yr FA FRM at 8% for 5 years. The original principal was 800,000. You are considering a cash-out refi into a 30-year mortgage at 6%. The old mortgage has a prepay penalty of 3% if payoff occurs before year 8. The new mortgage has fixed fees of 3,000 and variable fees of 4%, and a prepay penalty of 2%. The additional cash is for a $50,000 car, and can be borrowed at 8% over 5 years, with upfront fees of 3%.

Assume that all fees will be financed, and that under either scenario you will be moving 15 years from now. Ignore taxes, the option to wait to refinance, and assume no loan is prepaid, curtailed, nor ever defaults.

What is the NPV of refinancing if the opportunity cost of capital is 7%?

USE EXCEL & POST FORMULAS