Pension lump sum versus lifetime payments · Calculation guide

Find when cumulative pension payments match the lump sum.

Calculation guide

Compare nominal cash amounts before investment return, tax and inflation. Pension pays monthly in arrears for as long as the recipient lives. The chosen horizon is a scenario, not a life expectancy forecast.

months = ceil(lump/monthly); cumulative = monthly*12*years; difference = cumulative-lump

Inputs

Lump sum offered

Example entry 100000 (in the selected currency).

Monthly pension

Example entry 500 (in the selected currency).

Assumed years of payments

Example entry 20. Allowed range 1.0 to 100.0. Use whole numbers.

Worked example

InputValue
Lump sum offered100,000
Monthly pension500
Assumed years of payments20
ResultValue
First whole payment month reaching lump sum200 months
Pension received over chosen horizon120,000
Cash difference versus lump sum20,000

Calculation steps

First whole payment month reaching lump sum = round up((Lump sum offered ÷ Monthly pension))

round up((100,000 ÷ 500)) = 200 months

Pension received over chosen horizon = ((Monthly pension × 12) × Assumed years of payments)

((500 × 12) × 20) = 120,000

Cash difference versus lump sum = (Pension received over chosen horizon − Lump sum offered)

(120,000 − 100,000) = 20,000

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Lump sum offered100,000110,000First whole payment month reaching lump sum200 months220 months
Monthly pension500550First whole payment month reaching lump sum200 months182 months
Assumed years of payments2022Pension received over chosen horizon120,000132,000
Pension lump sum versus lifetime payments →