Retirement Contribution Employer Match Calculator

Purpose and model boundary

Use this calculator to translate a tiered employer-match formula into dollars. It shows the match earned at your chosen deferral, the deferral needed for the full match, and the employer contribution missed when you defer less.

The calculation covers match bands and the annual employee-deferral cap. It excludes vesting, true-up provisions, nondiscrimination testing, after-tax or Roth subaccounts, loans and investment growth.

Inputs and units

Governing relationships

Each tier pays its match percentage only on the employee deferral that falls inside that band. For tier k, the matched share of pay is max(0, min(deferral, ceiling_k) - ceiling_(k-1)), with the first tier starting at zero. Summing all tiers at the highest ceiling gives the maximum plan match. The employee deferral is limited to the elective limit plus any age-qualified catch-up amount before the match is calculated.

Calculation sequence

1. Read the salary, the deferral percentage, the pay periods, the employee age, the plan limits and the three tier ceilings and rates.
2. Determine the deferral cap as the elective limit, plus the catch-up amount once the qualifying age is reached.
3. Convert the deferral percentage into an amount and cap it at the deferral limit, recording whether the cap bound before the plan's own ceiling did.
4. For each tier in order, apply the tier rate to the portion of pay between the previous ceiling and that tier's ceiling, bounded by the actual deferral.
5. Sum the tiers to get the employer match.
6. Repeat the same sum evaluated at the top ceiling to get the plan maximum, and subtract the match earned to get the amount left on the table.
7. Solve for the deferral percentage at which the whole match is captured.
8. Evaluate the status in the order given below.

Outputs and interpretation

The headline figures are Match Left On Table, Deferral For Full Match and Employer Match. Everything else is supporting detail for those.

Validation and status logic

The workbook evaluates status in this order, and the first condition that is true wins. The status text below is the exact wording the workbook returns; angle brackets mark a value substituted into the message at calculation time.

Where a message substitutes a value, these are the exact returns the delivered corpus records:

• CHECK: deferring 100.0% would capture the whole match; you are forfeiting employer money
• CHECK: deferring 3.0% would capture the whole match; you are forfeiting employer money

Assumptions and limitations

• Tier ceilings are cumulative shares of pay, not separate bands each measured from zero. One hundred percent on the first three percent then fifty percent on the next three percent is a tier 2 ceiling of six percent, not three.
• The elective deferral limit and the catch-up amount are inputs. They are illustrative values you supply and must be checked against the limits for the year in question.
• Salary is level across the year and the deferral is a constant share of every pay period.
• Vesting, true-up and plan-specific eligibility rules are outside the model, so an earned match is not necessarily a match you keep.

Restrictions and non-computing states

The salary must be greater than zero. Tier ceilings are cumulative and must increase: a tier whose ceiling is at or below the previous tier's pays nothing, and the workbook reports that rather than silently ignoring it. Pay periods must be at least one. The deferral percentage, tier rates, elective limit and catch-up amount are held within their published ranges. Where the annual deferral limit binds before the plan's top ceiling, the full match cannot be captured at any percentage and the workbook says so.

Errors and warnings

A rejected entry means a value fell outside the published input rules, and no calculation was attempted. Workbook NOT VALID means the model ran and could not produce a meaningful answer, so the results are withheld. Workbook CHECK means the numbers stand but a condition is worth reading before you rely on them. A connection or calculation-service failure is an availability problem, not a finding of any kind, and never means zero.

Elective deferral limits and catch-up contributions are set by the Internal Revenue Service; see 401(k) and profit-sharing plan contribution limits and catch-up contributions. The workbook reproduces neither: both limits are editable inputs, and the band arithmetic is derived in the delivered audit.

This model is arithmetic. It is not financial, tax, investment or retirement advice, and it is not a recommendation to save, invest, withdraw, claim or accept any amount. Decisions about retirement funding should be taken with a qualified professional who knows your circumstances.