A Social Security claiming-age calculator for couples, in Excel and Google Sheets. Type each person’s benefit at full retirement age from your own statements, and the workbook works out every claiming age from 62 to 70, totals all 81 claiming-age pairs for the two of you — spousal top-up and survivor step-up included — and tests your plan against 49 combinations of death ages, with every rule it follows shown and cited. It is a file you own, not a $49–$144-a-year planning subscription.
A single-person break-even calculator answers a narrower question than a married couple actually has. When one of you claims changes what the other is paid, for as long as either of you lives — and nobody knows how long that is.
Start from your own statements
Setup asks for four things per person: date of birth, the monthly benefit at full retirement age from your my Social Security statement, the age you plan to claim (in years and months), and an age to live to. The workbook never estimates your benefit. It starts from the figure SSA already gave you and applies the rules to it. Planning alone? Set Household to Single and the couple tabs step aside.
Every age, for each of you
The Claiming Table shows each person’s benefit at every age from 62 to 70: the first month paid, the months of early reduction or delayed credits, the share of the full benefit, the whole-dollar monthly check, and running totals if you live to 75, 80, 85, 90, 95 or 100. Break-Even compares any two ages for one person, in flat dollars and with your cost-of-living (COLA) assumption. In the fictional example, Theo’s 62-versus-70 break-even is 80 years 5 months in flat dollars, and before his 79th birthday with a 2.5% COLA.
All 81 claiming-age pairs, as household totals
The Couple Grid totals every whole-year pair for the two of you at your lives-to ages and marks the best one. Below it, your plan and the best pair are split into each person’s own benefit, spousal top-up and survivor step-up — so you can see where the difference comes from.
The two extra benefits behave differently, and that is the heart of the decision:
- The spousal top-up stops growing at full retirement age. It is based on half the other person’s full benefit, never on their delayed credits.
- The survivor benefit carries the delayed credits. When the higher earner waits, the survivor’s check grows too — which is why that one person’s claiming age matters so much.
The engine counts the better of two survivor starts for every pair: a reduced survivor benefit as early as it is allowed, or your own benefit first and an unreduced survivor benefit at survivor full retirement age.
Tested against 49 combinations of death ages
A single “live to 85” guess hides the real risk. The Death-Age Matrix runs your plan across a seven-by-seven grid of death ages from 70 to 100 and shows, for each cell, your household total, the best pair for that cell and how far behind you are, who is widowed and for how many years, and what the survivor is paid while alone. Five strategies — both at 62, both at 67, both at 70, the higher earner at 70 with the other at 62, and your own plan — are scored across all 49. In the fictional example, both claiming at 70 lands near the best in 22 of the 49 scenarios.
Your assumptions, not a forecast
You set the COLA assumption, and you can set a trust-fund what-if: a share of benefits paid from a year you choose. It is off by default and applied to every total when you turn it on — check the annual Social Security Trustees Report for the current projections. Payments are rounded the way SSA rounds them, down to the dime and then to the whole dollar.
No black box
The Rules tab lists 16 rules — reaching an age, full retirement age by birth year, the early reduction, delayed credits, spousal and survivor limits, rounding and more — each with what the workbook does, the value used, and a link to the section of SSA’s POMS manual it follows. The Still Working tab estimates what the earnings test holds back if you claim before full retirement age while you are still earning.
The Start Here guide walks through reading your statement and how each benefit is worked out, and the Statement Worksheet & Advisor Questions PDF gives you a page to copy both statements onto and 14 questions to take to a financial professional before you file.
Try the free version first
Want to see the arithmetic before you buy? The free Social Security Claiming-Age Table is a spreadsheet you download in one click — no signup — and it does the core arithmetic for one person: nine rows, one per claiming age, each showing what that choice costs or adds against the figure your statement already gives you, with every rule it applies named and cited. What it cannot do is break-even, your COLA assumption, the trust-fund what-if, or the half of the decision that needs two people. This workbook is the full version: both statements, all 81 claiming-age pairs, the spousal top-up and the survivor step-up, 49 combinations of death ages, break-even, your COLA assumption and the trust-fund what-if.
What it does not do
It does not model taxes, Medicare premiums, the earnings test inside the lifetime totals, children’s, divorced-spouse or disability benefits, or anyone born before January 2, 1954. It is education and arithmetic, not financial, tax or legal advice — SSA decides what you are paid.
Own it, don’t rent it
The workbook arrives with a fictional example couple already filled in, so every tab is working the moment you open it — then you type over them with your own statement figures. It is bought once, there is no account, and nothing renews. When a new statement arrives, update Setup and every table moves with it.
