Pension Payout & Lump Sum Present Value Calculator

Put your pension quote amounts on a shared calendar to compare a lump sum, straight-life payments and joint-and-survivor payments. Enter two modeled timelines to see how the recipient order, contract increases and effective annual discount affect crossover and final value.

Pension worksheet

Compare pension payments with a lump sum

Use your quoted payment amounts and timing to see which offer has a higher present value under two modeled payout horizons.

Joint and survivor has the highest present value.

Scenario A at 0% effective annual discount.

Lump sum present value
$285,000.00
$285,000.00 quoted · Month 0
Straight-life present value
$360,000.00
PV crossover · Month 95
Joint and survivor present value
$390,000.00
PV crossover · Month 110
Quoted amounts and timing

Month 0 means immediate payment.

Both quoted annuities use this end-of-month start.

Comparison assumptions

Used to compare present values.

Used only for purchasing power.

Scenario A
Scenario B
Payout timeline and crossover
Cumulative discounted pension amounts by monthScenario A. Straight life totals $360,000.00. Joint and survivor totals $390,000.00. The lump sum benchmark is $285,000.00. All amounts are at month zero value.$0$195K$390K090180
  • Straight life
  • Joint and survivor
  • Lump sum benchmark

Months from the comparison date. The lump sum marker sits at month 0. The dotted benchmark is its full present value throughout the comparison.

Participant payment months 1–120. Survivor period starts at month 121 and ends at month 180.

Discount and payout horizon sensitivity

Present value minus the lump sum. Columns change the participant’s final payment month. Rows change the effective annual discount. Survivor month 180 stays fixed.

Present-value difference for the selected payout
Annual discountMonth 60Month 96Month 120Month 144Month 180
-2%+$70,700.76+$124,121.31+$161,576.76+$200,576.60+$262,112.11
-1%+$47,691.47+$97,673.68+$131,842.26+$166,704.61+$220,329.82
0%+$27,000.00+$73,800.00+$105,000.00+$136,200.00+$183,000.00
1%+$8,344.31+$52,196.67+$80,712.72+$108,666.89+$149,568.78
2%-$8,519.03+$32,600.69+$58,687.63+$83,761.58+$119,558.77
Open payout and cash-flow ledger

Shown at annual checkpoints and payment milestones. The CSV includes every month of both scenarios. Purchasing power discounts only for the entered inflation rate.

Lump sum
Nominal $285,000.00
Purchasing power $285,000.00
Straight life
Nominal $360,000.00
Purchasing power $318,668.43
Joint and survivor
Nominal $390,000.00
Purchasing power $333,442.45
Pension amounts at monthly milestones
MonthLump paymentStraight paymentJoint to participantJoint to survivorStraight PV to dateJoint PV to date
0$285,000.00$0.00$0.00$0.00$0.00$0.00
1$0.00$3,000.00$2,600.00$0.00$3,000.00$2,600.00
12$0.00$3,000.00$2,600.00$0.00$36,000.00$31,200.00
24$0.00$3,000.00$2,600.00$0.00$72,000.00$62,400.00
36$0.00$3,000.00$2,600.00$0.00$108,000.00$93,600.00
48$0.00$3,000.00$2,600.00$0.00$144,000.00$124,800.00
60$0.00$3,000.00$2,600.00$0.00$180,000.00$156,000.00
72$0.00$3,000.00$2,600.00$0.00$216,000.00$187,200.00
84$0.00$3,000.00$2,600.00$0.00$252,000.00$218,400.00
95$0.00$3,000.00$2,600.00$0.00$285,000.00$247,000.00
96$0.00$3,000.00$2,600.00$0.00$288,000.00$249,600.00
108$0.00$3,000.00$2,600.00$0.00$324,000.00$280,800.00
110$0.00$3,000.00$2,600.00$0.00$330,000.00$286,000.00
120$0.00$3,000.00$2,600.00$0.00$360,000.00$312,000.00
121$0.00$0.00$0.00$1,300.00$360,000.00$313,300.00
132$0.00$0.00$0.00$1,300.00$360,000.00$327,600.00
144$0.00$0.00$0.00$1,300.00$360,000.00$343,200.00
156$0.00$0.00$0.00$1,300.00$360,000.00$358,800.00
168$0.00$0.00$0.00$1,300.00$360,000.00$374,400.00
180$0.00$0.00$0.00$1,300.00$360,000.00$390,000.00
Show selectable CSV

How to use this calculator

  1. Choose the comparison month, then enter the lump sum and its payout month. Month zero is immediate.
  2. Enter both quoted monthly payments, the shared first payment month, and any quoted annual increases. Enter the survivor share or the actual survivor quote.
  3. Enter two modeled pairs of final payment months and choose which scenario to view. Enter the annual discount and inflation assumptions separately.
  4. Compare the values and first crossover month. Test how a different final participant month or discount affects the payout against the lump sum, then export the monthly ledger.

The Formula

The mathematical logic powering this calculation is:

Month zero is the comparison date. Future payments occur at the end of the entered month. Both quoted monthly forms start in the same scheduled month and include the participant’s final payment month. The survivor amount is the entered quote or share of the original quoted joint amount. It begins the following month only if the survivor lives beyond the participant’s final month and ends in the survivor’s final modeled month. The quoted joint participant amount continues when the survivor dies first. Each entered increase applies at successive 12-payment anniversaries. Survivor continuation uses the joint form’s original increase calendar.

For cash Cₘ at month m and effective annual discount r, present value is Cₘ ÷ (1 + r)^(m/12). Apply the same rule once to the dated lump sum. Purchasing power uses the entered annual inflation rate in place of r and is displayed separately. The crossover is the first payment month when an annuity’s cumulative present value reaches the entire lump sum’s present value. The benchmark includes the full quote even if its payment month is later. The timeline ends by the last modeled payment date or scenario month, so a crossover can remain unreached.

Both recipients are assumed alive at the first payment. Enter actual quoted amounts and an ordinary straight-life or non-pop-up joint and survivor form. This illustration models gross scheduled receipts, with annual increases carried at full precision. Plan-specific guarantees, pop-ups, taxes, claim eligibility, pre-commencement death, probabilities and future investment balances are outside the calculation.

Use up to 720 months and quoted cents. The amount limits are $0.01 to $10 million for the lump sum and $0.01 to $100,000 for monthly payments. A survivor payment may be zero. Annual discount is −5% through 40%, inflation is −10% through 20%, and quoted annual increases are 0% through 10%. Rates and survivor shares take up to four decimals. Sensitivity changes the final participant month and the annual discount within those ranges and holds other inputs fixed.

Worked Example

If you input:

  • Quoted lump sum: $285,000 at month 0
  • Straight-life monthly amount: $3,000
  • Joint monthly amount and survivor share: $2,600 and 50%, or $1,300
  • First annuity payment month: 1
  • Scenario A final months: Participant 120 and survivor 180
  • Effective annual discount: 0%

Result:

Scenario A pays $360,000 straight life and $390,000 joint and survivor, compared with the $285,000 immediate quote. Straight life first reaches the lump sum at month 95 and joint and survivor at month 110. At a 6% annual discount instead, their present values are $272,172.96 and $273,575.42, and neither reaches $285,000.

Frequently Asked Questions

Why can a higher nominal pension total have a lower present value?

Present value gives future months less weight for a positive discount. A deferred monthly stream can sum to more dollars and still have a smaller value on the comparison date.

When does the survivor payment begin?

For the modeled ordinary joint form, it begins in the month after the participant’s last payment when the survivor continues to live. Both recipients are assumed alive at commencement.

What if the survivor dies first or both die in the same month?

The participant’s original joint quote continues through the participant’s entered final month. There is no separate survivor payment in the same month or afterward in that scenario. A plan with a pop-up increase needs a separate comparison.

How does a delayed lump sum affect crossover?

Its purchase-date present value is computed using its entered payout month. The crossover compares cumulative annuity value with that fixed amount. The cash ledger records the actual month when the lump sum is paid.

Why do discount and inflation have separate fields?

The effective discount compares cash timing across offers. Inflation translates each payment into comparison-date purchasing power. Neither field projects future investment returns.

How should I interpret the sensitivity table?

Each square shows the annuity’s present value less the dated lump sum’s present value under that particular participant month and discount assumption. Survivor month, quotes and all other timing are held fixed. A positive square favors the displayed annuity on this measure.

Similar Calculators