Should you leave your 401(k) when you retire? A decision calculator

Stressed about retirement paperwork and tax surprises? A practical, fast way to decide what to do with your 401(k)

Leaving a job should not mean leaving money on the table. When you retire you typically face three choices: keep your 401(k) with your former employer, roll it to an IRA, or cash out. Each choice carries different fees, investment options, tax consequences and Required Minimum Distribution (RMD) outcomes — and small differences compound over decades. This article walks you through an actionable decision tool you can build or download as a spreadsheet to simulate each path, including up-to-date context for 2026.

Why this matters now (2026 context)

Over the past few years retirement-policy and tax guidance has continued to evolve. The effects of the SECURE Act 2.0 (enacted in 2022) still shape RMD ages and allowed retirement-plan features, and the IRS has released clarifications through 2024–2025 that affect distribution timing and reporting. In 2026 the RMD rules that apply to most traditional 401(k)s and IRAs are still an essential driver of when and how much you must withdraw and pay taxes on.

At the same time, low-cost institutional funds are increasingly available inside employer plans — a factor that can make “staying put” more attractive than in the past. Meanwhile, tax-bracket compression, higher state taxes in some jurisdictions, and growing adoption of Roth conversion ladders have made scenario modeling indispensable.

Quick preview: what the decision calculator models

• Net after-tax outcomes for cashouts, IRA rollovers, and staying in-plan
• RMD projections from retirement through life expectancy (using lookup tables)
• Fee and investment impact — how expense ratios and plan fees affect long-term balance
• Conversion & timing strategies (partial rollovers; Roth conversions over multiple years)
• State tax and early withdrawal penalties where applicable

Core decision variables your calculator must capture

Any credible simulation needs a small set of inputs that reflect the real drivers of outcome:

• Account details: balance, pre-tax vs Roth, plan name
• Personal info: current age, retirement age, expected lifespan or planning horizon
• Investment assumptions: nominal return, annual volatility (if running stochastic scenarios), and plan vs IRA fees (expense ratios and wrap fees)
• Tax assumptions: federal marginal tax rates by year (or bracket), applicable state tax rate, current tax basis (after-tax contributions), and filing status
• Behavior choices: cash out today, full rollover to IRA, partial rollover, leave in plan, or Roth conversion schedule

How the calculator evaluates each option (high-level)

1. Cash out — immediate taxable distribution (minus any after-tax contributions), early-withdrawal penalty if under 59½ (usually 10% unless exception applies), federal + state tax on the taxable portion.
2. Roll to IRA — no immediate income tax if rolled as a trustee-to-trustee transfer; broader investment choices and Roth conversion flexibility; RMDs still apply to traditional IRAs but not to Roth IRAs (if rolled into Roth, tax paid during conversion).
3. Leave in employer plan — possible lower fees (institutional share classes), stronger creditor protection in some states, limited investment choices but potential plan-specific benefits; RMDs still apply for traditional accounts (Roth 401(k) has RMDs unless rolled to Roth IRA).

Key formula building blocks (spreadsheet-friendly)

Below are the simple formulas you can put in a spreadsheet to compute the essentials. Use named ranges where possible for clarity (e.g., Balance, Age, MarginalRate).

Net after cash-out (year 0)
TaxableAmount = IF(AccountType="Traditional", Balance - AfterTaxBasis, Balance - AfterTaxBasis - PreTaxRothBasis)
FederalTax = TaxableAmount * FederalMarginalRate
StateTax = TaxableAmount * StateTaxRate
Penalty = IF(Age < 59.5, TaxableAmount * 0.10, 0)
NetProceeds = Balance - (FederalTax + StateTax + Penalty)

Future balance net of fees (years n)
FutureBalance = Balance * (1 + NominalReturn - FeeRate) ^ Years

RMD (first year RMD applies)
RMD = Balance / DistributionFactor  <-- DistributionFactor from IRS Uniform Lifetime Table (lookup by age)

In Excel, an RMD formula using a table lookup might be:

=IF(Age < RMDStartAge,0, Balance / VLOOKUP(Age,IRS_TABLE,2,FALSE))

An example scenario (walk-through calculation)

Use this illustrative example to understand the output of the spreadsheet model. This is not tax advice — it demonstrates mechanics.

• Age: 66
• Balance: $500,000 in a traditional 401(k)
• Employer plan fee (all-in): 0.20% per year; comparable IRA strategy fee: 0.60% per year
• Assumed nominal return: 5% per year
• Federal marginal tax rate when distributing: 24%
• RMD age for 2026: 73 (per SECURE Act 2.0 timing)

Quick delta: Over 10 years the difference in net growth between paying 0.20% and 0.60% in fees on $500k can be sizable. Using the FutureBalance formula:

• Stay in-plan future balance ≈ 500,000 * (1 + 0.05 - 0.002)^10
• Roll to IRA future balance ≈ 500,000 * (1 + 0.05 - 0.006)^10

Plug those numbers into the spreadsheet to see the absolute dollar difference; then layer in RMDs and tax on distributions. You’ll find that lower fees compound into tangible tax-deferred gains, but the IRA also exposes you to different RMD timing and Roth conversion options.

What the calculator should report

For each pathway (leave in plan / roll to IRA / cash out) the output should show:

• Net proceeds today (for cash out)
• Projected balance at key ages (e.g., 73, 80, 90) net of fees
• RMD schedule and tax due each RMD year
• Lifetime after-tax distributions under assumed drawdown patterns
• Sensitivity analysis for return and fee assumptions

Advanced features to include (and how they change decisions)

These features are the difference between a simple calculator and a professional decision tool:

• Marginal tax-rate path — allow different tax rates by year (useful when planning Roth conversions to take advantage of low-bracket years)
• Partial rollovers — model keeping high-quality institutional funds in plan and moving the rest to an IRA
• Roth conversion ladder — schedule conversions across years, compute tax owed in conversion years, and project long-run RMD outcomes
• Monte Carlo / stochastic scenarios — run 1,000 simulations to estimate the probability a strategy runs out of money
• State tax variations — useful if you plan to move states in retirement

Practical decision rules — when each option generally wins

Keep the balance in your former employer plan if:

• It offers low-cost institutional funds and plan-level advantages (expense ratios well below comparable IRAs).
• You value ERISA-level creditor protection and you live in a state where that protection is especially valuable.
• The plan has features (e.g., guaranteed income or in-plan annuities) you cannot replicate easily in an IRA.

Roll to an IRA if:

• You want broader investment choices and easier implementation of Roth conversions or tax-efficient withdrawal sequencing.
• IRA fees are competitive and you can obtain low-cost institutional shares or ETFs.
• You prefer consolidated recordkeeping (easier tax reporting and beneficiary management).

Cashing out is appropriate only in narrow cases:

• You need cash urgently and after-tax proceeds (after penalties) are still the best option; or
• You’re in a very low tax year and plan a Roth conversion strategy that uses cash on hand; or
• You have little left in the account and fees are tiny but your cash needs trump tax concerns.

Most retirees find partial rollovers + leaving a portion in-plan is a practical mix: keep the very cheap institutional funds in the 401(k) and roll the rest to an IRA for flexibility.

How to build the spreadsheet (step-by-step)

Below is a compact blueprint. If you prefer, you can download our ready-made template (link at the end of this article) that implements everything below with clean input panels, scenario tabs and printable RMD schedules.

1. Create an Inputs sheet with these named fields: CurrentAge, RetirementAge, Balance401k, AfterTaxBasis, AccountType (Traditional/Roth), PlanFee, IRAFee, NominalReturn, FederalRate, StateRate, RMDStartAge.
2. Add an IRS_TABLE sheet with two columns: Age and DistributionFactor (use IRS Uniform Lifetime Table values or downloadable IRS CSVs). Update this table from IRS updates through 2025/2026.
3. Build a Year-by-Year projection sheet. For each row (Year), compute Age, StartingBalance, InvestmentReturn, Fees, EndingBalance = StartingBalance * (1+Return - Fee).
4. Compute RMDs where Age ≥ RMDStartAge using a VLOOKUP or INDEX/MATCH into IRS_TABLE.
5. Compute TaxDue each year: TaxDue = Distribution * (FederalRate + StateRate). For conversion years use the conversion amount as Distribution.
6. Aggregate lifetime metrics: LifetimeTaxes, LifetimeNetDistributions, FinalBalance.

Key Excel formula examples:

=IF(Age < RMDStartAge, 0, StartingBalance / INDEX(IRS_TABLE[Factor], MATCH(Age, IRS_TABLE[Age], 0)))

=EndingBalance - (Distribution * (FederalRate + StateRate))  <-- Net after-tax distribution

=StartingBalance * (1 + NominalReturn - FeeRate) <-- Growth net of fees

Common pitfalls — and how the calculator avoids them

• Ignoring fees: Many retirees underestimate the drag of a 0.4% fee difference — the spreadsheet isolates plan vs IRA fee impacts.
• Relying on a single static tax rate: The tool allows variable marginal rates over time and models conversion years separately.
• Omitting state taxes and penalties: Both can meaningfully change net outcomes; include them in scenario inputs.
• Forgetting Roth 401(k) RMD rules: Roth 401(k)s are subject to RMDs unless rolled to a Roth IRA — the calculator flags Roth account treatment automatically.

Example output interpretation — what to look for

After you run your scenarios, ask these questions to convert numbers into a decision:

• Does the IRA pathway deliver materially higher lifetime after-tax distributions even after factoring conversion taxes and fees?
• Is the employer plan offering extremely low fees that justify staying in the plan as long as you prefer?
• Does a partial rollover plus a Roth conversion ladder lower your cumulative tax bill over the next 10–15 years?
• How do RMD-triggered tax increases look — do they push your marginal rate into a higher bracket in later years?

2026 trends and strategic predictions

As of early 2026 we see three practical trends that should shape your decision:

1. Employer plans are getting cheaper. Large plan sponsors are shifting toward institutional funds and negotiating lower wrap fees, narrowing the fee gap with IRAs.
2. Roth strategies are mainstream. Advisors are increasingly recommending multi-year Roth conversion ladders during low-income years to manage long-term tax liability and RMD exposure.
3. Regulatory clarity helps modeling. IRS guidance through 2024–2025 improved reporting and clarified some RMD timing issues; keep your IRS_TABLE updated in 2026 to reflect any table or rule changes.

When to call a pro

Use this decision tool for modeling and to form a well-documented question set for your advisor. Call a tax advisor or ERISA attorney if:

• You have a huge employer balance that includes plan-specific guarantees (like an in-plan annuity) or company stock with Net Unrealized Appreciation rules.
• You’re subject to state-specific creditor or divorce equity concerns.
• You are contemplating large Roth conversions or multi-state tax planning.

Actionable next steps — build or run the tool today

1. Gather inputs: 401(k) statements, plan fee disclosures (SAR or plan fee page), your recent tax return, and your current age.
2. Download the decision-calculator spreadsheet template we prepared (includes scenario tabs: Base, FeeSensitivity, RothConversion). The template contains pre-built IRS_TABLEs you can update with the latest IRS factors.
3. Run three baseline scenarios: leave-in-plan, full rollover to IRA, cash-out. Compare net after-tax lifetime outcomes and RMD tax cliffs at RMDStartAge.
4. Test a fourth scenario: partial rollover + Roth conversion ladder (spread conversions across low-bracket years). Compare lifetime net outcomes.

Final checklist before deciding

• Confirm plan fees and institutional share availability from your plan admin.
• Verify RMD age in the tool (currently 73 for most participants in 2026 per SECURE Act 2.0 timing).
• Model state taxes and potential early-withdrawal penalties.
• Document your assumptions and save scenario results for advisor review.

Summary — the practical rule

There is no universal answer. The right choice depends on fees, investment options, creditor protection, RMD timing, and your tax plan. A properly built decision calculator reduces this complexity to a few clear numbers: projected after-tax lifetime distributions, RMD tax exposure, and net balance at your planning horizon.

Call to action

Ready to test your situation? Download our 401(k) Decision Calculator and spreadsheet template (pre-filled examples, IRS RMD table, scenario manager, and printable RMD schedules). Run your personal scenarios in 20–30 minutes and get a clear, auditable recommendation to bring to your advisor. Click to download or request a walk-through tailored to your account details.

Helpful resources: IRS guidance and the SECURE Act 2.0 provisions affect RMD timing and conversion rules — check the IRS.gov publications for the latest RMD tables and consult your tax advisor for state-specific rules.

Related Reading

• Why Virtual Meeting Workrooms Failed — And What It Means for Virtual Apartment Tours
• Wearable Warmers for Busy Parents: Hands-Free Heat While You Hold Baby
• 7 Steps Indie Beauty Brands Can Take to Scale Without Losing Craft Cred
• Why Niche Content Still Wins: EO Media’s First 2026 Sales Slate Signals Genre Resurgence
• Detective Work for Buyers: How to Authenticate Antique Gemstones and Miniatures