Wrap-Around Mortgage - HP 12c Platinum Reference Manual

8 Real Estate
12c platinum / 12C
RPN Keystrokes
9.5gC
200000Þ$
P
:0+P
:$
133190+?0
11.5gC$
:0-
:0$¼
12§
15.25gC$
:0-

Wrap-Around Mortgage

A wrap-around mortgage is essentially the same as a refinancing mortgage, except that the
new mortgage is granted by a different lender, who assumes the payments on the existing
mortgage, which remains in full force. The new (second) mortgage is thus "wrapped
around" the existing mortgage. The "wrap-around" lender advances the net difference
between the new (second) mortgage and the existing mortgage in cash to the borrower,
and receives as net cash flow, the difference between debt service on the new (second)
mortgage and debt service on the existing mortgage.
When the terms of the original mortgage and the wrap-around are the same, the
procedures in calculating NPV and IRR to the lender and NPV to the borrower are exactly
the same as those presented in the preceding section on refinancing.
Example 1: A mortgage loan on an income property has a remaining balance of
$200,132.06. When the load originated 8 years ago, it had a 20 year term with full
amortization in level monthly payments at 6.75% interest.
A lender has agreed to "wrap" a $300,000 second mortgage at 10%, with full amortization
in level monthly payments over 12 years. What is the effective yield (IRR) to the lender
on the net cash advanced?
12c platinum
ALG Keystrokes
9.5gC
200000Þ$
P
+:0P
:$
+133190³?0
11.5gC$$
-:0³
:0$¼
§12³
15.25gC$$
-:0³
Display
Monthly payment on
1,979.56
new mortgage.
Net monthly payment (to
899.23
lender).
Net amount of cash
-66,810.00
advanced (by lender).
Present value of net
-80,425.02
monthly payment.
NPV to lender of net
-13,615.02
cash advanced.
% nominal yield (IRR).
14.83
Present value of net
-65,376.72
monthly payment at
15.25%.
NPV to borrower.
1,433.28
Comments