Excel Functions
|
Function
Name |
Category |
Description |
|
Single
life |
Present value of single life cash refund annuity |
|
|
Single
life |
Present value of single life cash refund annuity -- according to
Jordan |
|
|
Single
life |
Present value of single life cash refund annuity -- simplified parameters with PPA interest and mortality |
|
|
Single
life |
Effective interest rate for single life annuity |
|
|
Single
life |
Effective interest rate for single life annuity – simplified
parameters |
|
|
Single
life |
Canadian section 8517 present value factor |
|
|
Single
life |
Single life level endowment factor |
|
|
Single
life |
Pre-retirement discount: interest, mortality, termination |
|
|
Single
life |
Present value of single life level income annuity --
multi-purpose function |
|
|
Single life |
Present value of single life annuity |
|
|
Single life |
Present value of single life annuity -- simplified parameters |
|
|
Single life |
Present value of single life annuity -- simplified parameters with mortality = GAM83 |
|
|
Single life |
Present value of single life annuity -- simplified parameters with mortality = GATT2003 |
|
|
Single
life |
Present value of single life level income annuity |
|
|
Single life |
Present value of single life annuity -- simplified parameters with PBGC interest and mortality |
|
|
Single life |
Present value of single life annuity -- simplified parameters with PPA interest and mortality |
|
|
Single life |
Present value of single life annuity -- simplified parameters with mortality = UP84 |
|
|
Single
life |
Calculates various single life mortality functions |
