Excel Functions in EAC ToolsExcel Functions in EAC Tools\Single life functionsSingle life functions\Single life short cut functions

Single life short cut functions

These functions are short cut variations of the PVSL function.

Excel Functions

Function Name

Category

Description

PVSLGAM83

Single life

Present value of single life annuity -- simplified parameters with mortality = GAM83

PVSLGATT2003

Single life

Present value of single life annuity -- simplified parameters with mortality = GATT2003

PVSLPBGC

Single life

Present value of single life annuity -- simplified parameters with PBGC interest and mortality

PVSLPPA

Single life

Present value of single life annuity -- simplified parameters with PPA interest and mortality

PVSLUP84

Single life

Present value of single life annuity -- simplified parameters with mortality = UP84