Calculation guide
First payments arrive at the end of year one. The indexed pension grows once annually from the second payment. Crossover is the first whole year within your horizon. Taxes and discounting are excluded.
Compare the yearly and cumulative geometric indexed payments with the level payment stream.
Inputs
Level annual pension
Example entry 1100 (in the selected currency).
Initial indexed annual pension
Example entry 1000 (in the selected currency).
Annual escalation
Example entry 10 %. Allowed range 0.0 to 25.0.
Comparison horizon in years
Example entry 10. Allowed range 1.0 to 100.0. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| Level annual pension | 1,100 |
| Initial indexed annual pension | 1,000 |
| Annual escalation | 10% |
| Comparison horizon in years | 10 |
| Result | Value |
|---|---|
| First year annual income catches up | 2 |
| First year cumulative income catches up | 3 |
| Indexed minus level cumulative income at horizon | 4,937.424601 |
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 |
|---|---|---|---|---|---|
| Level annual pension | 1,100 | 1,210 | First year annual income catches up | 2 | 3 |
| Initial indexed annual pension | 1,000 | 1,100 | First year annual income catches up | 2 | 1 |
| Annual escalation | 10% | 11% | Indexed minus level cumulative income at horizon | 4,937.424601 | 5,722.008964 |
| Comparison horizon in years | 10 | 11 | Indexed minus level cumulative income at horizon | 4,937.424601 | 6,431.167061 |
