Required pension capital for an escalating income · Calculation guide

Discount an escalating annual pension over a fixed payment horizon.

Calculation guide

Receive the first payment at the end of year one. Annual payments grow at the supplied rate, with deterministic returns and no terminal capital.

Required capital = sum of each rising year-end payment discounted back to today.

Inputs

First annual income

Example entry 10000 (in the selected currency).

Years of payments

Example entry 3. Allowed range 1.0 to 120.0. Use whole numbers.

Annual income escalation

Example entry 10 %. Allowed range -50.0 to 25.0.

Annual effective discount rate

Example entry 10 %. Allowed range -50.0 to 100.0.

Worked example

InputValue
First annual income10,000
Years of payments3
Annual income escalation10%
Annual effective discount rate10%
ResultValue
Required starting capital27,272.727273
Total nominal payments33,100

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
First annual income10,00011,000Required starting capital27,272.72727330,000
Years of payments34Required starting capital27,272.72727336,363.636364
Annual income escalation10%11%Required starting capital27,272.72727327,521.412472
Annual effective discount rate10%11%Required starting capital27,272.72727326,784.271488
Required pension capital for an escalating income →

Sources