Excel functionality is provided for calculating: |
Basic |
Full |
Actuarial present value of single life annuities |
✓ |
✓ |
Actuarial present value of joint life annuities |
✓ |
✓ |
Actuarial present value of life insurance |
✓ |
✓ |
Life expectancy and probability of survival |
✓ |
✓ |
Actuarial equivalence |
✓ |
✓ |
Commutation functions |
✓ |
✓ |
Interest rate functions |
✓ |
✓ |
Age and date functions |
✓ |
✓ |
Defined contribution plan functions |
✓ |
|
IRS limits |
✓ |
|
IRS covered compensation calculator |
✓ |
|
Social Security benefit calculator |
✓ |
|
Social Security related items (e.g. National Average Earnings, Wage Base, early/late factors, etc.) |
✓ |
|
PBGC-related items |
✓ |
|
Bureau of Labor Statistics CPI-U and CPI-W values and inflation |
✓ |