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.
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.
- 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.
| Annual discount | Month 60 | Month 96 | Month 120 | Month 144 | Month 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
| Month | Lump payment | Straight payment | Joint to participant | Joint to survivor | Straight PV to date | Joint 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
- Choose the comparison month, then enter the lump sum and its payout month. Month zero is immediate.
- Enter both quoted monthly payments, the shared first payment month, and any quoted annual increases. Enter the survivor share or the actual survivor quote.
- Enter two modeled pairs of final payment months and choose which scenario to view. Enter the annual discount and inflation assumptions separately.
- 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
FERS Retirement & Annuity Calculator
Compare regular FERS retirement dates, eligibility, high-3 pension estimates, age reductions and survivor costs with monthly and cumulative pension charts.
Social Security Break-Even Calculator
Compare Social Security estimates by starting age, cumulative receipts and discounted value, with monthly crossover details, charts and CSV.
Retirement Savings Runway Calculator
Explore how long retirement savings fund spending, compare income and return scenarios, and inspect monthly balances, shortfalls and a conditional spending ceiling.
CalSTRS Retirement Calculator & Timing Planner
Compare two CalSTRS retirement dates using 2% at 60 or 2% at 62 age factors, your earned service and prepared compensation. See monthly benefits and when delaying catches up.
