Calculation guide
Use the lender’s qualifying reference value and LTV. This is a balance test only; it does not determine eligibility, automatic cancellation or valuation rules.
Inputs
Qualifying reference property value
Example entry 300000 (in the selected currency). Minimum 0.01.
Principal outstanding
Example entry 250000 (in the selected currency).
Target loan-to-value ratio
Example entry 80 %. Allowed range 0 to 100.
Worked example
| Input | Value |
|---|---|
| Qualifying reference property value | 300,000 |
| Principal outstanding | 250,000 |
| Target loan-to-value ratio | 80% |
| Result | Value |
|---|---|
| Paydown needed to reach threshold | 10,000 |
| Threshold principal | 240,000 |
| Current LTV | 83.333333% |
Calculation steps
Paydown needed to reach threshold = max(0, (Principal outstanding − ((Qualifying reference property value × Target loan-to-value ratio) ÷ 100)))
max(0, (250,000 − ((300,000 × 80) ÷ 100))) = 10,000
Threshold principal = ((Qualifying reference property value × Target loan-to-value ratio) ÷ 100)
((300,000 × 80) ÷ 100) = 240,000
Current LTV = ((Principal outstanding ÷ Qualifying reference property value) × 100)
((250,000 ÷ 300,000) × 100) = 83.333333%
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 |
|---|---|---|---|---|---|
| Qualifying reference property value | 300,000 | 330,000 | Paydown needed to reach threshold | 10,000 | 0 |
| Principal outstanding | 250,000 | 275,000 | Paydown needed to reach threshold | 10,000 | 35,000 |
| Target loan-to-value ratio | 80% | 88% | Paydown needed to reach threshold | 10,000 | 0 |
