Download the Excel worksheet (.xlsx)
Editable workbook · November 2026 edition · no sign-in required.
Get started in Excel
The workbook opens with an illustrative $1,400 monthly estimate at 62 and $2,480 at 70. Replace the blue cells with two amounts from your statement. Enter whole years and additional months separately. Set a comparison horizon after the later start, then check the “Input check” result.
What to look for in the monthly rows
The earlier schedule builds a $134,400 lead over 96 months in the example. Once the later schedule starts, its larger monthly check reduces the gap by $1,080 each month. After 124 later installments the difference column reads minus $480. After 125 it reads plus $600. The summary counts that first catch-up installment. An exact tie also counts.
Keep the assumptions consistent
The worksheet compares gross retirement payments with the same dollar basis. Use zero for both rates to compare constant checks. A positive COLA models annual steps from age 62. A nominal discount rate converts both streams into modeled present values. Family benefits, work-related withholding, taxes and Medicare deductions are outside the workbook. Formula cells remain visible so you can inspect the calculation.