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