Calculation guide
Use annual after-tax amounts on the same price basis. Only enter income available throughout the period. Surplus income is reported separately.
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
| Input | Value |
|---|---|
| Essential annual spending | 36,000 |
| Guaranteed pension income | 24,000 |
| Other guaranteed annual income | 6,000 |
| Result | Value |
|---|---|
| Essential spending shortfall | 6,000 |
| Essential spending covered | 30,000 |
| Income above spending floor | 0 |
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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Essential annual spending | 36,000 | 39,600 | Essential spending shortfall | 6,000 | 9,600 |
| Guaranteed pension income | 24,000 | 26,400 | Essential spending shortfall | 6,000 | 3,600 |
| Other guaranteed annual income | 6,000 | 6,600 | Essential spending shortfall | 6,000 | 5,400 |
