Monthly pension: $2,500.00
Lump-sum offer: $450,000.00
Years (horizon): 25 years
Return / discount rate: 5.00%
COLA: 2.00%
Present value of the pension: $526,602.21
Winner: Pension wins by $76,602.21
Total pension paid (nominal): $972,052.81
Future value of the lump sum: $1,523,859.72
Branch: Lump sum $550,000: Pension $2,500.00/mo, lump sum $550,000.00, 25 years, return 5.00%, COLA 2.00%: pension PV $526,602.21, Lump sum wins by $23,397.79, total paid $972,052.81, lump-sum FV $1,862,495.22
Branch: Monthly pension $3,000: Pension $3,000.00/mo, lump sum $450,000.00, 25 years, return 5.00%, COLA 2.00%: pension PV $631,922.65, Pension wins by $181,922.65, total paid $1,166,463.38, lump-sum FV $1,523,859.72
Branch: COLA 0%: Pension $2,500.00/mo, lump sum $450,000.00, 25 years, return 5.00%, COLA 0.00%: pension PV $427,650.12, Lump sum wins by $22,349.88, total paid $750,000.00, lump-sum FV $1,523,859.72
Branch: Return 7%: Pension $2,500.00/mo, lump sum $450,000.00, 25 years, return 7.00%, COLA 2.00%: pension PV $427,292.77, Lump sum wins by $22,707.23, total paid $972,052.81, lump-sum FV $2,442,344.69
Branch: Horizon 20 years: Pension $2,500.00/mo, lump sum $450,000.00, 20 years, return 5.00%, COLA 2.00%: pension PV $450,230.07, Pension wins by $230.07, total paid $736,992.09, lump-sum FV $1,193,983.97
Branch: Horizon 30 years: Pension $2,500.00/mo, lump sum $450,000.00, 30 years, return 5.00%, COLA 2.00%: pension PV $592,364.99, Pension wins by $142,364.99, total paid $1,231,813.47, lump-sum FV $1,944,874.07
Branch: Monthly pension $2,000: Pension $2,000.00/mo, lump sum $450,000.00, 25 years, return 5.00%, COLA 2.00%: pension PV $421,281.77, Lump sum wins by $28,718.23, total paid $777,642.25, lump-sum FV $1,523,859.72
Reverse: monthly pension for a pension PV of exactly $450,000: $2,136.34 ($2,136.34) — the star is DOLLARS
Exact monthly pension for a pension PV of exactly $450,000: $2136.3374
At $2,136.34 the figures are: Pension $2,136.34/mo, lump sum $450,000.00, 25 years, return 5.00%, COLA 2.00%: pension PV $450,000.55, Pension wins by $0.55, total paid $830,654.12, lump-sum FV $1,523,859.72
$1 less, $2,135.34, the figures are: Pension $2,135.34/mo, lump sum $450,000.00, 25 years, return 5.00%, COLA 2.00%: pension PV $449,789.90, Lump sum wins by $210.10, total paid $830,265.30, lump-sum FV $1,523,859.72
$1 more, $2,137.34, the figures are: —
Reverse verdict: CONTINUOUS
Reverse: lump sum for a tie with the default pension: $526,602.21 ($526,602.21) — the star is DOLLARS
Exact lump sum for a tie with the default pension: $526602.2093
At $526,602.21 the figures are: Pension $2,500.00/mo, lump sum $526,602.21, 25 years, return 5.00%, COLA 2.00%: pension PV $526,602.21, Tie, total paid $972,052.81, lump-sum FV $1,783,262.00
$1 less, $526,601.21, the figures are: —
$1 more, $526,603.21, the figures are: —
Reverse verdict: CONTINUOUS
Reverse: break-even horizon: 20 years (20 years) — the star is YEARS
Exact break-even horizon: 20
At 20 years the figures are: Pension $2,500.00/mo, lump sum $450,000.00, 20 years, return 5.00%, COLA 2.00%: pension PV $450,230.07, Pension wins by $230.07, total paid $736,992.09, lump-sum FV $1,193,983.97
At 19 years the figures are: Pension $2,500.00/mo, lump sum $450,000.00, 19 years, return 5.00%, COLA 2.00%: pension PV $433,536.50, Lump sum wins by $16,463.50, total paid $692,733.18, lump-sum FV $1,137,127.59
At 21 years the figures are: —
Reverse verdict: STEP
Reverse: return for a tie: 6.49% (6.49%) — the star is a PERCENT
Exact return for a tie: 6.4863%
At 6.49% the figures are: Pension $2,500.00/mo, lump sum $450,000.00, 25 years, return 6.49%, COLA 2.00%: pension PV $449,829.58, Lump sum wins by $170.42, total paid $972,052.81, lump-sum FV $2,167,370.66
At 6.48% the figures are: Pension $2,500.00/mo, lump sum $450,000.00, 25 years, return 6.48%, COLA 2.00%: pension PV $450,288.91, Pension wins by $288.91, total paid $972,052.81, lump-sum FV $2,162,288.19
At 6.50% the figures are: Pension $2,500.00/mo, lump sum $450,000.00, 25 years, return 6.50%, COLA 2.00%: pension PV $449,370.95, Lump sum wins by $629.05, total paid $972,052.81, lump-sum FV $2,172,464.60
Reverse verdict: CONTINUOUS
Reverse: COLA for a tie: 0.51% (0.51%) — the star is a PERCENT
Exact COLA for a tie: 0.5071%
At 0.51% the figures are: Pension $2,500.00/mo, lump sum $450,000.00, 25 years, return 5.00%, COLA 0.51%: pension PV $450,131.90, Pension wins by $131.90, total paid $799,730.00, lump-sum FV $1,523,859.72
At 0.50% the figures are: Pension $2,500.00/mo, lump sum $450,000.00, 25 years, return 5.00%, COLA 0.50%: pension PV $449,674.54, Lump sum wins by $325.46, total paid $798,713.72, lump-sum FV $1,523,859.72
At 0.52% the figures are: Pension $2,500.00/mo, lump sum $450,000.00, 25 years, return 5.00%, COLA 0.52%: pension PV $450,589.94, Pension wins by $589.94, total paid $800,747.98, lump-sum FV $1,523,859.72
Reverse verdict: CONTINUOUS
Reverse: horizon for total pension paid of $1,000,000: 26 years (26 years) — the star is YEARS
Exact horizon for total pension paid of $1,000,000: 26
At 26 years the figures are: Pension $2,500.00/mo, lump sum $450,000.00, 26 years, return 5.00%, COLA 2.00%: pension PV $540,553.15, Pension wins by $90,553.15, total paid $1,021,949.61, lump-sum FV $1,600,052.71
At 25 years the figures are: Pension $2,500.00/mo, lump sum $450,000.00, 25 years, return 5.00%, COLA 2.00%: pension PV $526,602.21, Pension wins by $76,602.21, total paid $972,052.81, lump-sum FV $1,523,859.72
At 27 years the figures are: —
Reverse verdict: STEP
Edge: monthly pension $0: Pension $0.00/mo, lump sum $450,000.00, 25 years, return 5.00%, COLA 2.00%: pension PV $0.00, Lump sum wins by $450,000.00, total paid $0.00, lump-sum FV $1,523,859.72
Edge: lump sum $0: Pension $2,500.00/mo, lump sum $0.00, 25 years, return 5.00%, COLA 2.00%: pension PV $526,602.21, Pension wins by $526,602.21, total paid $972,052.81, lump-sum FV $0.00
Edge: return 0% and COLA 0%: Pension $2,500.00/mo, lump sum $450,000.00, 25 years, return 0.00%, COLA 0.00%: pension PV $750,000.00, Pension wins by $300,000.00, total paid $750,000.00, lump-sum FV $450,000.00
Edge: horizon 1 year: Pension $2,500.00/mo, lump sum $450,000.00, 1 years, return 5.00%, COLA 2.00%: pension PV $29,469.81, Lump sum wins by $420,530.19, total paid $30,276.53, lump-sum FV $472,500.00
Edge: horizon 40 years: Pension $2,500.00/mo, lump sum $450,000.00, 40 years, return 5.00%, COLA 2.00%: pension PV $697,753.03, Pension wins by $247,753.03, total paid $1,836,089.06, lump-sum FV $3,167,994.92
Edge: return 0% (COLA 2% kept): Pension $2,500.00/mo, lump sum $450,000.00, 25 years, return 0.00%, COLA 2.00%: pension PV $972,052.81, Pension wins by $522,052.81, total paid $972,052.81, lump-sum FV $450,000.00
Lump sum $550,000: Pension $2,500.00/mo, lump sum $550,000.00, 25 years, return 5.00%, COLA 2.00%: pension PV $526,602.21, Lump sum wins by $23,397.79, total paid $972,052.81, lump-sum FV $1,862,495.22.
Monthly pension $3,000: Pension $3,000.00/mo, lump sum $450,000.00, 25 years, return 5.00%, COLA 2.00%: pension PV $631,922.65, Pension wins by $181,922.65, total paid $1,166,463.38, lump-sum FV $1,523,859.72.
COLA 0%: Pension $2,500.00/mo, lump sum $450,000.00, 25 years, return 5.00%, COLA 0.00%: pension PV $427,650.12, Lump sum wins by $22,349.88, total paid $750,000.00, lump-sum FV $1,523,859.72.
Return 7%: Pension $2,500.00/mo, lump sum $450,000.00, 25 years, return 7.00%, COLA 2.00%: pension PV $427,292.77, Lump sum wins by $22,707.23, total paid $972,052.81, lump-sum FV $2,442,344.69.
Horizon 20 years: Pension $2,500.00/mo, lump sum $450,000.00, 20 years, return 5.00%, COLA 2.00%: pension PV $450,230.07, Pension wins by $230.07, total paid $736,992.09, lump-sum FV $1,193,983.97.
Horizon 30 years: Pension $2,500.00/mo, lump sum $450,000.00, 30 years, return 5.00%, COLA 2.00%: pension PV $592,364.99, Pension wins by $142,364.99, total paid $1,231,813.47, lump-sum FV $1,944,874.07.
Monthly pension $2,000: Pension $2,000.00/mo, lump sum $450,000.00, 25 years, return 5.00%, COLA 2.00%: pension PV $421,281.77, Lump sum wins by $28,718.23, total paid $777,642.25, lump-sum FV $1,523,859.72.
Reverse: the monthly pension for a pension PV of exactly $450,000 is $2,136.34 (exact $2136.3374); at $2,136.34 the PV is $450,000.55; $1 less, $2,135.34, it is $449,789.90 — verdict: CONTINUOUS. The lump sum for a tie with the default pension is $526,602.21 (exact $526602.2093); at $526,602.21 the pension PV is $526,602.21 — verdict: CONTINUOUS. The break-even horizon is 20 years; at 20 years the PV is $450,230.07; 19 years gives $433,536.50 — verdict: STEP. The return for a tie is 6.49% (exact 6.4863%); at 6.49% the PV is $449,829.58; 6.48% gives $450,288.91; 6.50% gives $449,370.95 — verdict: CONTINUOUS. The COLA for a tie is 0.51% (exact 0.5071%); at 0.51% the PV is $450,131.90; 0.50% gives $449,674.54; 0.52% gives $450,589.94 — verdict: CONTINUOUS. The horizon for total pension paid of $1,000,000 is 26 years; at 26 years the total paid is $1,021,949.61; 25 years gives $972,052.81 — verdict: STEP.
Edges: a $0 monthly pension gives Pension $0.00/mo, lump sum $450,000.00, 25 years, return 5.00%, COLA 2.00%: pension PV $0.00, Lump sum wins by $450,000.00, total paid $0.00, lump-sum FV $1,523,859.72. A $0 lump sum gives Pension $2,500.00/mo, lump sum $0.00, 25 years, return 5.00%, COLA 2.00%: pension PV $526,602.21, Pension wins by $526,602.21, total paid $972,052.81, lump-sum FV $0.00. A 0% return and 0% COLA give Pension $2,500.00/mo, lump sum $450,000.00, 25 years, return 0.00%, COLA 0.00%: pension PV $750,000.00, Pension wins by $300,000.00, total paid $750,000.00, lump-sum FV $450,000.00. A 1-year horizon gives Pension $2,500.00/mo, lump sum $450,000.00, 1 years, return 5.00%, COLA 2.00%: pension PV $29,469.81, Lump sum wins by $420,530.19, total paid $30,276.53, lump-sum FV $472,500.00. A 40-year horizon gives Pension $2,500.00/mo, lump sum $450,000.00, 40 years, return 5.00%, COLA 2.00%: pension PV $697,753.03, Pension wins by $247,753.03, total paid $1,836,089.06, lump-sum FV $3,167,994.92. A 0% return with the 2% COLA kept gives Pension $2,500.00/mo, lump sum $450,000.00, 25 years, return 0.00%, COLA 2.00%: pension PV $972,052.81, Pension wins by $522,052.81, total paid $972,052.81, lump-sum FV $450,000.00.