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.
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
| Input | Value |
|---|---|
| Lump sum offered | 100,000 |
| Monthly pension | 500 |
| Assumed years of payments | 20 |
| Result | Value |
|---|---|
| First whole payment month reaching lump sum | 200 months |
| Pension received over chosen horizon | 120,000 |
| Cash difference versus lump sum | 20,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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Lump sum offered | 100,000 | 110,000 | First whole payment month reaching lump sum | 200 months | 220 months |
| Monthly pension | 500 | 550 | First whole payment month reaching lump sum | 200 months | 182 months |
| Assumed years of payments | 20 | 22 | Pension received over chosen horizon | 120,000 | 132,000 |
