Excel Functions in EAC ToolsExcel Functions in EAC Tools\Joint life functionsJoint life functions\Joint life short cut functions

Joint life short cut functions

These functions are short cut variations of the PVJL function.

Excel Functions

Function Name

Category

Description

PVJLGAM83

Joint life

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

PVJLGATT2003

Joint life

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

PVJLPPA

Joint life

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

PVJLUP84

Joint life

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