Pension funding ratio under asset stress · Calculation guide

Shock all plan assets by one percentage and hold the measured liability constant.

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

InputValue
Current plan assets1,000
Asset change (%)-10%
Measured liabilities1,200
ResultValue
Stressed funding ratio75%
Funding deficit after stress300

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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Current plan assets1,0001,100Stressed funding ratio75%82.5%
Asset change (%)-10%-9%Stressed funding ratio75%75.833333%
Measured liabilities1,2001,320Stressed funding ratio75%68.181818%
Pension funding ratio under asset stress →

Sources