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 |
ü |
ü |
Age and date functions |
ü |
ü |
Defined contribution plan functions |
|
ü |
IRS limits and other related items, covered compensation |
|
ü |
Social Security benefit calculator and other related items |
|
ü |
PBGC-related items |
|
ü |
Bureau of Labor Statistics CPI values and inflation |
|
ü |