Calculation guide
End-of-month payments and a fixed nominal annual rate divided by twelve. No fees or early settlement charges.
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
| Input | Value |
|---|---|
| Property value | 300,000 |
| First-lien principal | 200,000 |
| First-lien annual rate | 4% |
| First-lien months | 240 |
| Second-lien principal | 40,000 |
| Second-lien annual rate | 8% |
| Second-lien months | 120 |
| Result | Value |
|---|---|
| Combined monthly debt service | 1,697.271036 |
| Combined LTV | 80% |
| Balance-weighted annual rate | 4.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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Property value | 300,000 | 330,000 | Combined LTV | 80% | 72.727273% |
| First-lien principal | 200,000 | 220,000 | Combined monthly debt service | 1,697.271036 | 1,818.467102 |
| First-lien annual rate | 4% | 5% | Combined monthly debt service | 1,697.271036 | 1,805.221856 |
| First-lien months | 240 | 264 | Combined monthly debt service | 1,697.271036 | 1,625.672452 |
| Second-lien principal | 40,000 | 44,000 | Combined monthly debt service | 1,697.271036 | 1,745.802074 |
| Second-lien annual rate | 8% | 9% | Combined monthly debt service | 1,697.271036 | 1,718.663754 |
| Second-lien months | 120 | 132 | Combined monthly debt service | 1,697.271036 | 1,668.578534 |
