Premier Protection Request a call
Menu

Retirement planning worksheets

Work through the numbers behind your next question.

Explore cash-flow timing, check a payment and compare withdrawal examples. Start with invented figures or enter amounts you want to understand.

Educational arithmetic worksheets. These illustrations do not determine your benefits or recommend a retirement strategy.

Entries stay in this page's memory. The worksheets do not send or save them, include them in a link, or ask for your name, account number or documents. Leaving this page clears the entries; browser back restores empty worksheets.

Each calculation uses your assumptions. It does not decide whether you can retire, recommend a product or establish your benefits.

See a year of retirement cash flow

Compare recurring income and bills, a later income start and one annual bill. The worksheet shows the same twelve months in order so an early gap stays visible even when the full year has a surplus.

Enter figures for this worksheet

All fields are required; enter 0 when an amount is zero.

Dollars, 0 to 100000000. Use at most two decimal places, without commas or a dollar sign.

Dollars, 0 to 100000000. Use at most two decimal places, without commas or a dollar sign.

Dollars, 0 to 100000000. Use at most two decimal places, without commas or a dollar sign.

Enter 0 if none. Use an amount you supply; the tool does not estimate a pension or Social Security benefit.

January applies it to all twelve months; December applies it only in December.

Enter 0 if none. Include this bill once; remove it from recurring expenses to avoid counting it twice.

Choose January even when the bill amount is 0.

Monthly cash-flow illustration

Enter figures or load the invented example, then calculate.

What the calendar can show

The invented example uses $3,000 monthly net income, $2,600 recurring bills, no starting cash and a $1,200 January bill. January ends at minus $800, while the full year ends at $3,600. A positive annual total does not remove an earlier gap. Move the bill to December or add a later income amount to see which months change.

This is a monthly arithmetic view, not a daily bank balance. It assumes the entered amounts stay constant, except for the one later income start and annual bill. It excludes interest, borrowing, tax calculations and changes you have not entered. Keep restricted-use benefits separate from freely available cash. Use the CFPB cash-flow worksheet to examine timing within a month.

Continue with the retirement budget guide, different retirement dates for spouses and first-year payment review.

Reconcile a retirement payment

Use one statement period to compare gross pay, listed deductions and the resulting deposit. Every figure comes from you; the worksheet does not calculate a tax rate or determine a benefit.

Enter figures for this worksheet

All fields are required; enter 0 when an amount is zero.

Dollars, 0 to 100000000. Use at most two decimal places, without commas or a dollar sign.

Dollars, 0 to 100000000. Use at most two decimal places, without commas or a dollar sign.

Dollars, 0 to 100000000. Use at most two decimal places, without commas or a dollar sign.

Enter the total of the remaining listed deductions once. Use 0 when there are none.

Use the deposit for the same period and payment stream. Split payments or adjustments need separate reconciliation.

Payment reconciliation

Enter figures or load the invented example, then calculate.

Read a difference before explaining it

An invented statement with $4,000 gross pay, $400 withholding, $250 premiums and $50 other deductions leaves $3,300. If the matched deposit is $3,250, the difference is minus $50. That is a question to investigate, not proof of an incorrect benefit or a missing payment.

Check that the gross amount and deposit cover the same period. A separate adjustment, an allotment or a split payment can require another line in your records. For a household budget based on net deposits, avoid subtracting a premium again when it is already included in statement deductions. Use the OPM annuity payment information and your actual payment notice to route questions.

Read the first-year payment guide, annual tax-record check and COLA notice review. A monthly reconciliation does not establish a taxable annual amount.

Compare withdrawal order

Apply the same two annual returns in opposite orders. Choose when the withdrawals occur, then compare what was actually paid, what could not be paid and what remains.

Enter figures for this worksheet

All fields are required; enter 0 when an amount is zero.

Dollars, 0 to 100000000. Use at most two decimal places, without commas or a dollar sign.

Dollars, 0 to 100000000. Use at most two decimal places, without commas or a dollar sign.

From -100 to 100, with at most two decimal places. Enter -10 for a 10% loss.

The comparison reverses these two entered returns. They are assumptions, not a forecast.

Beginning withdraws before the annual return; end withdraws after it.

Two-year withdrawal illustration

Enter figures or load the invented example, then calculate.

Separate the example from a retirement strategy

Load the invented $100 example with minus 10% and plus 10% returns, taking $10 at each year-end. The loss-first order ends at $78; the gain-first order ends at $80. Without withdrawals both end at $99. A 10% gain and a 10% loss do not cancel because they apply to different balances.

Each return is applied to the current cents balance and rounded to cents, half up, before the next operation. A withdrawal cannot exceed the available balance; the unpaid portion appears as an unmet withdrawal. A depleted balance stays at zero unless another cash flow is introduced, which this tool does not model. The example excludes fees, taxes, inflation and contributions. It does not calculate a safe withdrawal rate, investment allocation or probability of retirement success.

GAO's retirement-income discussion provides background on withdrawal risks; its historical numerical examples are not current market assumptions. Continue with our worked withdrawal-order explanation and cash-flow calendar guide.

Turn the result into a specific question.

Use a result to identify a date, deduction or assumption to confirm with the appropriate source. Keep personal statements with you and the official agency or adviser. The education and advice guide helps distinguish who can answer which question.

Source sections rechecked November 5, 2026. The worked examples are original arithmetic illustrations. Recheck current official guidance before an individual decision.