Calculation guide
A positive gap is a deficit.
Stressed funding ratio = (((100 × Current plan assets) × (1 + (Asset change (%) ÷ 100))) ÷ Measured liabilities). Funding deficit after stress = (Measured liabilities − (Current plan assets × (1 + (Asset change (%) ÷ 100))))
Inputs
Current plan assets
Example entry 1000 (in the selected currency).
Asset change (%)
Example entry -10 %. Allowed range -100.0 to 1000.0.
Measured liabilities
Example entry 1200 (in the selected currency). Minimum 1e-06.
Worked example
| Input | Value |
|---|---|
| Current plan assets | 1,000 |
| Asset change (%) | -10% |
| Measured liabilities | 1,200 |
| Result | Value |
|---|---|
| Stressed funding ratio | 75% |
| Funding deficit after stress | 300 |
Calculation steps
Stressed funding ratio = (((100 × Current plan assets) × (1 + (Asset change (%) ÷ 100))) ÷ Measured liabilities)
(((100 × 1,000) × (1 + (-10 ÷ 100))) ÷ 1,200) = 75%
Funding deficit after stress = (Measured liabilities − (Current plan assets × (1 + (Asset change (%) ÷ 100))))
(1,200 − (1,000 × (1 + (-10 ÷ 100)))) = 300
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 |
|---|---|---|---|---|---|
| Current plan assets | 1,000 | 1,100 | Stressed funding ratio | 75% | 82.5% |
| Asset change (%) | -10% | -9% | Stressed funding ratio | 75% | 75.833333% |
| Measured liabilities | 1,200 | 1,320 | Stressed funding ratio | 75% | 68.181818% |
