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:
- Break-even age. The age at which the present value of the payments received so far first equals the lump sum. Stop earlier and the lump sum was worth more at your discount rate; continue beyond it and the payments were.
- Simple break-even age. The same test with no discounting: the age at which the payments received add up to the lump sum.
- Implied rate of return. The discount rate at which the present value of the payments, over the years you expect, exactly equals the lump sum. It is found by trial, because the rate cannot be isolated algebraically.
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%.
- Monthly rate. i = 1.051 ÷ 12 − 1 = 0.00407412.
- 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.
- Annuity over 25 years. 1.05−25 = 0.295303, and (1 − 0.295303) ÷ 0.05 = 14.093945.
- Present value. $24,545.16 × 14.093945 = $345,938.05, which is $54,061.95 less than the lump sum.
- Simple break-even. $400,000 ÷ $2,000 = 200 payments, reached at age 81 years 8 months.
- Break-even at 5%. The discounted payments do not add up to $400,000 until payment 415, at age 99 years 7 months.
- 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.