What's inside
- Plan: monthly benefit and % of your full benefit for claiming at 62, 63 … 70 and any age you choose (years + months), using SSA's reduction and delayed-credit rules and your full retirement age from your birth year
- For each age: the break-even age against claiming at 62, totals by 75 and 85 and to the age you plan to, and a present value at the discount rate you choose
- By age: the total received by every birthday from 62 to 100 for four claiming choices, with a chart
- Sample file: born 1964 with $2,400 at 67. Claiming at 70 pays $2,976 a month and catches up with 62 at age 80 and 5 months; to 88 it pays $642,816 vs $524,160 at 62
Checked, not just designed: all 240 formulas recalculate with zero errors, and every result was checked against an independent calculation of SSA's rules in 6 scenarios.
Works in Excel and Google Sheets. Retirement benefits only (no spousal/survivor or earnings test). Not financial advice.
Try the free version first
The free online calculator uses the same model for a quick answer. The spreadsheet adds tracking, history and the full views.