
| CLEAR | 
 | 
 | 
 | 
| 20 | 
 | 
 | 
 | 
| 8 | 
 | 
 | 
 | 
| 6.75 | 
 | 0.56 | Monthly interest rate (into i). | 
| 
 | 
 | 
 | |
| 200132.06 | 
 | 200,132.06 | Loan amount (into PV). | 
| 
 | 
 | 
 | |
| 
 | 0 | Monthly payment on existing | |
| 
 | mortgage (calculated). | ||
| 
 | 
 | ||
| 10 | 
 | 0.83 | Monthly interest on  | 
| 
 | 
 | 
 | |
| 300000 | 
 | Amount of  | |
| 
 | 
 | 
 | |
| 
 | 
 | 3,585.23 | Monthly payment on  | 
| 
 | 
 | (calculated). | |
| 
 | 
 | 
 | |
| 0 | 
 | 1,553.69 | Net monthly payment received (into | 
| 
 | PMT). | ||
| 
 | 
 | ||
| 
 | 
 | Net cash advanced (into PV). | |
| 200132.06 | 
 | 
 | 
 | 
| 12 | 
 | 15.85 | Nominal yield (IRR) to lender | 
| 
 | (calculated). | ||
| 
 | 
 | 
Sometimes the wrap around mortgage will have a longer payback period than the original mortgage, or a balloon payment may exist.
where:
n1 = number of years remaining in original mortgage PMT1 = yearly payment of original mortgage
PV1 = remaining balance of original mortgage n2 = number of years in 
4
