First versus second lien blended financing · Calculation guide

Calculate combined debt service, LTV and weighted rate for loans on one home.

Calculation guide

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

Combined LTV = (first + second)/property value; payment = PMT(first,r₁,n₁) + PMT(second,r₂,n₂).

Inputs

Property value

Example entry 300000 (in the selected currency). Minimum 0.01.

First-lien principal

Example entry 200000 (in the selected currency). Minimum 0.01.

First-lien annual rate

Example entry 4 %. Allowed range 0 to 100.

First-lien months

Example entry 240. Allowed range 1 to 600. Use whole numbers.

Second-lien principal

Example entry 40000 (in the selected currency).

Second-lien annual rate

Example entry 8 %. Allowed range 0 to 100.

Second-lien months

Example entry 120. Allowed range 1 to 600. Use whole numbers.

Worked example

InputValue
Property value300,000
First-lien principal200,000
First-lien annual rate4%
First-lien months240
Second-lien principal40,000
Second-lien annual rate8%
Second-lien months120
ResultValue
Combined monthly debt service1,697.271036
Combined LTV80%
Balance-weighted annual rate4.666667%

Calculation steps

Combined monthly debt service = (payment(First-lien principal, First-lien annual rate, First-lien months) + payment(Second-lien principal, Second-lien annual rate, Second-lien months))

(payment(200,000, 4, 240) + payment(40,000, 8, 120)) = 1,697.271036

Combined LTV = ((100 × (First-lien principal + Second-lien principal)) ÷ Property value)

((100 × (200,000 + 40,000)) ÷ 300,000) = 80%

Balance-weighted annual rate = (((First-lien principal × First-lien annual rate) + (Second-lien principal × Second-lien annual rate)) ÷ (First-lien principal + Second-lien principal))

(((200,000 × 4) + (40,000 × 8)) ÷ (200,000 + 40,000)) = 4.666667%

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Property value300,000330,000Combined LTV80%72.727273%
First-lien principal200,000220,000Combined monthly debt service1,697.2710361,818.467102
First-lien annual rate4%5%Combined monthly debt service1,697.2710361,805.221856
First-lien months240264Combined monthly debt service1,697.2710361,625.672452
Second-lien principal40,00044,000Combined monthly debt service1,697.2710361,745.802074
Second-lien annual rate8%9%Combined monthly debt service1,697.2710361,718.663754
Second-lien months120132Combined monthly debt service1,697.2710361,668.578534
First versus second lien blended financing →

Sources