Retirement spending floor after guaranteed income · Calculation guide

Find the essential retirement spending still to be covered by savings.

Calculation guide

Use annual after-tax amounts on the same price basis. Only enter income available throughout the period. Surplus income is reported separately.

gap = max(0,floor-pension-other) · covered = min(floor,pension+other) · surplus = max(0,pension+other-floor)

Inputs

Essential annual spending

Example entry 36000 (in the selected currency).

Guaranteed pension income

Example entry 24000 (in the selected currency).

Other guaranteed annual income

Example entry 6000 (in the selected currency).

Worked example

InputValue
Essential annual spending36,000
Guaranteed pension income24,000
Other guaranteed annual income6,000
ResultValue
Essential spending shortfall6,000
Essential spending covered30,000
Income above spending floor0

Calculation steps

Essential spending shortfall = max(0, ((Essential annual spending − Guaranteed pension income) − Other guaranteed annual income))

max(0, ((36,000 − 24,000) − 6,000)) = 6,000

Essential spending covered = min(Essential annual spending, (Guaranteed pension income + Other guaranteed annual income))

min(36,000, (24,000 + 6,000)) = 30,000

Income above spending floor = max(0, ((Guaranteed pension income + Other guaranteed annual income) − Essential annual spending))

max(0, ((24,000 + 6,000) − 36,000)) = 0

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Essential annual spending36,00039,600Essential spending shortfall6,0009,600
Guaranteed pension income24,00026,400Essential spending shortfall6,0003,600
Other guaranteed annual income6,0006,600Essential spending shortfall6,0005,400
Retirement spending floor after guaranteed income →

Sources