Calculation guide
End-of-month payments and a fixed nominal annual rate divided by twelve. No fees or early settlement charges.
Inputs
Purchase price
Example entry 300000 (in the selected currency).
Cash down payment
Example entry 50000 (in the selected currency).
Existing principal
Example entry 200000 (in the selected currency).
Existing annual rate
Example entry 3 %. Allowed range 0 to 100.
Remaining assumed loan months
Example entry 240. Allowed range 1 to 600. Use whole numbers.
Supplemental loan annual rate
Example entry 7 %. Allowed range 0 to 100.
Supplemental loan months
Example entry 180. Allowed range 1 to 600. Use whole numbers.
New annual rate
Example entry 6 %. Allowed range 0 to 100.
New mortgage months
Example entry 300. Allowed range 1 to 600. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| Purchase price | 300,000 |
| Cash down payment | 50,000 |
| Existing principal | 200,000 |
| Existing annual rate | 3% |
| Remaining assumed loan months | 240 |
| Supplemental loan annual rate | 7% |
| Supplemental loan months | 180 |
| New annual rate | 6% |
| New mortgage months | 300 |
| Result | Value |
|---|---|
| Supplemental borrowing required | 50,000 |
| Assumption and gap monthly payments | 1,558.609331 |
| New monthly payment | 1,610.753504 |
| Monthly savings with assumption | 52.144173 |
Calculation steps
Supplemental borrowing required = ((Purchase price − Cash down payment) − Existing principal)
((300,000 − 50,000) − 200,000) = 50,000
Assumption and gap monthly payments = (payment(Existing principal, Existing annual rate, Remaining assumed loan months) + payment(Supplemental borrowing required, Supplemental loan annual rate, Supplemental loan months))
(payment(200,000, 3, 240) + payment(50,000, 7, 180)) = 1,558.609331
New monthly payment = payment((Purchase price − Cash down payment), New annual rate, New mortgage months)
payment((300,000 − 50,000), 6, 300) = 1,610.753504
Monthly savings with assumption = (New monthly payment − Assumption and gap monthly payments)
(1,610.753504 − 1,558.609331) = 52.144173
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Purchase price | 300,000 | 330,000 | Supplemental borrowing required | 50,000 | 80,000 |
| Cash down payment | 50,000 | 55,000 | Supplemental borrowing required | 50,000 | 45,000 |
| Existing principal | 200,000 | 220,000 | Supplemental borrowing required | 50,000 | 30,000 |
| Existing annual rate | 3% | 4% | Assumption and gap monthly payments | 1,558.609331 | 1,661.374794 |
| Remaining assumed loan months | 240 | 264 | Assumption and gap monthly payments | 1,558.609331 | 1,485.205283 |
| Supplemental loan annual rate | 7% | 8% | Assumption and gap monthly payments | 1,558.609331 | 1,587.021238 |
| Supplemental loan months | 180 | 198 | Assumption and gap monthly payments | 1,558.609331 | 1,535.681124 |
| New annual rate | 6% | 7% | New monthly payment | 1,610.753504 | 1,766.947993 |
| New mortgage months | 300 | 330 | New monthly payment | 1,610.753504 | 1,548.641803 |
