Pension Payout Calculator
Working
A pension usually offers a choice: a lump sum now, or a monthly payment for life. For most people, the choice turns on the present value of the monthly payments, which depends on how long the payments last and the discount rate. A lump sum of $250,000 against $1,500 a month for 20 years at a 5% discount rate gives a present value of $227,287.97, so the lump sum is ahead by $22,712.03. Over 25 years the present value is $256,590.07, so the monthly payments are ahead. This calculator works out the present value from the figures you put in. It does not cover the lifetime risk: the monthly payments continue for life, while the lump sum can run out.
What this calculator does
This calculator answers whether a pension lump sum or monthly payments are worth more. You put in the lump sum, the monthly payment, the number of years, and the discount rate, and it works out the present value of the monthly payments and the difference from the lump sum. It also explains that the years figure is an assumption, and that the monthly payments are usually for life, so the real comparison depends on how long the retiree lives. It does not choose for the retiree.
How this is calculated
The present value is the monthly payment times the annuity factor: one minus one plus the monthly rate to the power of minus the number of months, divided by the monthly rate. The monthly rate is the annual discount rate divided by 12. A $1,500 monthly payment for 20 years, or 240 months, at 5% gives a factor of 151.53 and a present value of $227,287.97. For 25 years, or 300 months, the factor is 171.06 and the present value is $256,590.07. In real terms, the lump sum of $250,000 is ahead by $22,712.03 over 20 years and behind by $6,590.07 over 25 years.
Source
Pension payout choices are explained by the Pension Benefit Guaranty Corporation at pbgc.gov and by the Consumer Financial Protection Bureau at consumerfinance.gov — Retirement.
Limitations
This calculator assumes the payments last exactly the number of years entered, with no cost-of-living increase and no survivor benefit. In practice, a real pension pays for life, so the years figure is a guess, and the discount rate is an assumption: a higher rate lowers the present value of the monthly payments and favors the lump sum. In practice, it does not cover taxes, which differ between the lump sum and the monthly payments, or the risk that the lump sum is spent too fast. What you get is a comparison for planning, not financial advice.
What each input means
Lump sum. The one-time payment offered, in dollars. Monthly payment. The monthly pension payment, in dollars. Years. The number of years the monthly payments are assumed to last. Discount rate. The rate used to value future payments, as a percentage. A 5% rate is a common assumption.
How to read your result
Read the present value first, then the difference. A $250,000 lump sum against $1,500 a month for 20 years at 5% gives a present value of $227,287.97, so the lump sum is ahead by $22,712.03. Over 25 years the present value is $256,590.07, so the monthly payments are ahead by $6,590.07. The answer flips with the years, which is why the life expectancy assumption matters more than the arithmetic. A higher discount rate favors the lump sum.
Worked example
Take a lump sum of $250,000, a monthly payment of $1,500, and a 5% discount rate. Over 20 years the present value of the monthly payments is $227,287.97, so the lump sum is ahead by $22,712.03. Over 25 years the present value is $256,590.07, so the monthly payments are ahead by $6,590.07. The break-even is about 23 years: at that point the present value of the monthly payments is about $250,000.
What to do next
Think about how long the payments need to last and whether the lump sum would be invested or spent, because the monthly payments continue for life while the lump sum can run out. Get advice before choosing, because the choice is usually irrevocable. The retirement withdrawal planner can test how long a lump sum lasts.
Common questions
What is present value?
What a stream of future payments is worth today, after discounting for the time value of money.
Why does the discount rate matter?
A higher rate lowers the present value of future payments, which favors the lump sum.
What if I live longer than the years entered?
The monthly payments keep coming, so they are worth more than this calculator shows. The years figure is an assumption.
Are the monthly payments taxed?
Yes, usually. The lump sum is usually taxed too, unless it is rolled into an IRA. This calculator doesn't cover taxes.
Can I change my mind later?
Usually no. The choice between a lump sum and monthly payments is usually irrevocable.