Mortgage assumption versus new borrowing · Calculation guide

Compare assumption plus gap financing with an entirely new mortgage.

Calculation guide

End-of-month payments and a fixed nominal annual rate divided by twelve. No fees or early settlement charges.

Gap = price−down−assumed balance; monthly advantage = PMT(price−down,new rate,new term) − PMT(assumed balance,old rate,old term) − PMT(gap,gap rate,gap term).

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

InputValue
Purchase price300,000
Cash down payment50,000
Existing principal200,000
Existing annual rate3%
Remaining assumed loan months240
Supplemental loan annual rate7%
Supplemental loan months180
New annual rate6%
New mortgage months300
ResultValue
Supplemental borrowing required50,000
Assumption and gap monthly payments1,558.609331
New monthly payment1,610.753504
Monthly savings with assumption52.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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Purchase price300,000330,000Supplemental borrowing required50,00080,000
Cash down payment50,00055,000Supplemental borrowing required50,00045,000
Existing principal200,000220,000Supplemental borrowing required50,00030,000
Existing annual rate3%4%Assumption and gap monthly payments1,558.6093311,661.374794
Remaining assumed loan months240264Assumption and gap monthly payments1,558.6093311,485.205283
Supplemental loan annual rate7%8%Assumption and gap monthly payments1,558.6093311,587.021238
Supplemental loan months180198Assumption and gap monthly payments1,558.6093311,535.681124
New annual rate6%7%New monthly payment1,610.7535041,766.947993
New mortgage months300330New monthly payment1,610.7535041,548.641803
Mortgage assumption versus new borrowing →

Sources