Projection Results
Results appear above the form after submissionBalance Growth Chart
Annual Projection Schedule
| Year | Age | Salary | Employee Rate | Employee Contribution | Employer Contribution | Year-End Balance | Real Balance |
|---|
Real balance converts future money into today’s purchasing power using your inflation assumption.
Plan Inputs
Use this calculator to estimate retirement outcomes for faculty, staff, and university employees participating in a defined contribution arrangement.
Example Data Table
This sample shows how annual salary, contributions, and balances can evolve for a typical higher education employee.
| Year | Age | Salary | Employee Rate | Employee Contribution | Employer Contribution | Year-End Balance |
|---|---|---|---|---|---|---|
| 1 | 35 | $60,000 | 8.00% | $4,800 | $4,800 | $57,930 |
| 5 | 39 | $67,531 | 12.00% | $8,104 | $5,402 | $133,994 |
| 10 | 44 | $78,287 | 15.00% | $11,743 | $6,263 | $266,385 |
| 20 | 54 | $105,124 | 15.00% | $15,769 | $8,410 | $667,184 |
| 30 | 64 | $141,245 | 15.00% | $21,187 | $11,300 | $1,413,600 |
Formula Used
Salary(t) = Salary(0) × (1 + salary growth)^t
Employee Rate(t) = min(initial rate + t × escalation, maximum rate)
Matched Rate = min(Employee Rate, Match Cap)Employer Match = Salary × Matched Rate × Match Rate
Employer Fixed = Salary × Employer Fixed Percentage
Net Annual Return = ((1 + gross return) ÷ (1 + annual fee)) - 1
Periodic Return = (1 + Net Annual Return)^(1 ÷ pay periods) - 1
Real Balance = Nominal Balance ÷ (1 + inflation)^years
The model applies contributions each pay period, grows the account using the net return assumption, then summarizes yearly balances for review and export.
How to Use This Calculator
- Enter the employee’s current age and planned retirement age.
- Input the current account balance and current annual salary.
- Set the employee contribution rate and annual escalation policy.
- Enter employer match details and any fixed institutional contribution.
- Choose salary growth, return, fee, and inflation assumptions.
- Select pay periods and a retirement withdrawal rate.
- Press Calculate Plan to show summary results above the form.
- Review the chart, yearly schedule, and export files if needed.
Frequently Asked Questions
1) What does this calculator estimate?
It estimates how a defined contribution account may grow before retirement. The model combines employee deferrals, employer support, salary growth, investment returns, fees, and inflation assumptions.
2) Why are employer match and fixed contributions separate?
Many colleges and universities use layered formulas. Some plans match employee savings, while others also provide a fixed institutional contribution. Separating them makes the projection more realistic.
3) Why should I include fees?
Fees reduce net growth over time. Even modest annual expenses can materially lower the final account balance over multi-decade careers, especially when balances become larger later in service.
4) What is the real balance?
Real balance adjusts the projected ending value for inflation. It helps you compare future savings in today’s purchasing power instead of using only nominal dollars.
5) Can this model handle automatic contribution increases?
Yes. Use the annual escalation field to raise employee savings each year. The model will stop the increase once it reaches the maximum contribution rate you set.
6) Is the withdrawal estimate guaranteed income?
No. It is only a planning estimate based on the withdrawal percentage you choose. Actual retirement income depends on market conditions, spending, longevity, taxes, and plan rules.
7) Can higher education institutions use different formulas?
Yes. Institutions may apply vesting rules, service thresholds, optional matches, or contribution tiers. This calculator is flexible, but it still simplifies real plan documents and payroll practices.
8) How often should I update this projection?
Update it at least annually, and also after major salary changes, plan design changes, contribution elections, market shifts, or new fee disclosures from the recordkeeper.