Retirement Worksheet
(see
instructions)
Retirement Annuity
Single (worker only)
Joint (50% Survivor)
Worker
Female
Male
Nearest age
Beneficiary (if joint)
Female
Male
Nearest age
Investment Real Return
Expected (% per year)
Std Dev. (% per year)
Real Annuity discount rate
(% per year)
Worker Retirement Age
Retirement age
Savings
Current (yrs salary)
Future (% of salary)
Real Salary Increases
Annual (% per yr)
Analysis
Geometric mean approximation
Simulate
cases
Pctls:
.
.
Replacement Ratio (% of final salary)
...
...