CalcTrace

Pension Calculator: Lump Sum or Regular Payments

Compare a one-off lump sum with a regular pension payment by putting both in today’s money. See the present value of the payments, the age at which they overtake the lump sum, the rate of return the offer implies and what yearly indexation is worth. Every assumption is yours to set, and no country’s pension or tax rules are applied.

Last updated .

The two options

Enter both options on the same basis, either both before tax or both after it. Payments are counted at the end of each period.

Your assumptions

The discount rate is the yearly return you assume the lump sum could earn. Indexation is the yearly rise in the pension, if any. The stopping age is your own estimate of how long payments will be received. None of these is suggested by this page.

Result

Present value of the pension payments

–

–Lump sum
–Difference
–Break-even age
–Implied rate of return

The effect of indexation

Yearly risePresent valueAgainst lump sumBreak-even age

Everything else is held at the values you entered. The shaded row is your indexation rate. Break-even ages use your discount rate.

Payments by age

AgePaid in yearPaid so farPresent value so far

The shaded row is the first in which the present value of payments so far reaches the lump sum. Figures are rounded to the nearest dollar.

Show the working

    Putting a lump sum and a pension on the same footing

    A lump sum is a single figure today. A pension is a long series of smaller figures spread over years that have not happened yet. They can only be compared once the payments are converted into one present value, by discounting each payment for the time until it arrives:

    PV = P1 ÷ (1 + i) + P2 ÷ (1 + i)2 + … + Pn ÷ (1 + i)n

    Pk is the k-th payment, n is the number of payments expected and i is the discount rate for one payment period, found from the yearly rate r as i = (1 + r)1 ÷ m − 1 with m payments a year. For a whole number of years T, with payments that rise by g once a year, the sum has a closed form:

    PV = P × (r ÷ i) × (1 − ((1 + g) ÷ (1 + r))T) ÷ (r − g)

    P is the first payment. The term P × r ÷ i is what one year of payments is worth at the end of that year; the rest is the growing annuity formula applied to those yearly amounts. With no indexation g is zero, and when r is zero a year of payments is simply worth P × m.

    Three further figures come from the same sum:

    Worked example

    First a case that can be checked by hand: $10,000 a year for 3 years at 5% is worth 10,000 ÷ 1.05 + 10,000 ÷ 1.052 + 10,000 ÷ 1.053 = 9,523.81 + 9,070.29 + 8,638.38 = $27,232.48.

    Now the choice the calculator opens with: $400,000 today, or $2,000 a month from age 65, expected to be paid until age 90, with a discount rate of 5%.

    1. Monthly rate. i = 1.051 ÷ 12 − 1 = 0.00407412.
    2. Value of one year of payments at year end. $2,000 × 0.05 ÷ 0.00407412 = $24,545.16, a little more than the $24,000 paid because the earlier months earn interest.
    3. Annuity over 25 years. 1.05−25 = 0.295303, and (1 − 0.295303) ÷ 0.05 = 14.093945.
    4. Present value. $24,545.16 × 14.093945 = $345,938.05, which is $54,061.95 less than the lump sum.
    5. Simple break-even. $400,000 ÷ $2,000 = 200 payments, reached at age 81 years 8 months.
    6. Break-even at 5%. The discounted payments do not add up to $400,000 until payment 415, at age 99 years 7 months.
    7. Implied rate. The 300 payments are worth exactly $400,000 at a discount rate of 3.54% a year.

    The three results say the same thing in different ways: at 5% the payments are worth less than the lump sum, they would have to continue to 99 to catch up, and the offer is equivalent to earning 3.54% on the lump sum for 25 years.

    What indexation is worth

    Add a 2% yearly rise and the same pension pays $768,727.19 in total against $600,000, and its present value becomes $421,787.63, now $21,787.63 more than the lump sum. The break-even age at 5% drops to 88 years 2 months, the simple break-even to 79 years 7 months, and the implied rate rises to 5.51%. At 3% indexation the present value is $468,446.22. A rise that looks small each year is a large part of the value of a long pension, so whether payments are indexed, and to what, is one of the first things to establish.

    How to read the result

    The answer moves with the assumptions

    With level payments, the example’s present value is $423,631.22 at a 3% discount rate and $288,549.65 at 7%. Stopping at age 85 gives $305,886.89 and at 95 gives $377,319.19. There is no single correct figure, only the figure that follows from a given rate and a given number of years. The calculator reports what those assumptions produce; it does not say which option to take.

    Use a consistent discount rate

    If the pension is indexed to prices and you want to think in today’s buying power, use a rate with inflation removed and set indexation to zero. Otherwise use a rate that includes inflation and enter the indexation as stated.

    What this comparison leaves out

    This page applies no country’s pension, superannuation, social security or tax rules. It does not model tax on either option, payments to a surviving partner, guarantees, the security of whoever is paying the pension, the effect on other entitlements, or what happens to an unspent lump sum. It also treats the stopping age as certain, when the real value of a lifetime pension lies in not knowing it. These matters can outweigh the arithmetic, and they are outside what this calculation can show.