Excel Functions in EAC ToolsExcel Functions in EAC Tools\Joint life functions

Joint life functions

Excel Functions

Function Name

Category

Description

CASHREFUNDJL

Joint life

Present value of joint life cash refund annuity

PVJL

Joint life

Present value of joint life annuity

PVJL12

Joint life

Present value of joint life annuity -- simplified parameters

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

PVJLLI

Joint life

Present value of joint life level income annuity

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

PVJLX

Joint life

Present value of joint life annuity -- alternative setup

PVJLX_WS

Joint life

Present value of joint life annuity with certain period – general formula

 

More Information

To get detailed information about a specific type of joint life annuity, click on the following links.

Type of Annuity

Description

Joint & survivor annuity

An annuity payable during the joint lifetime of 𝑥 and 𝑦, with a provision that upon the first death, a percentage of the original amount is payable during the remaining lifetime of the survivor, regardless of who dies first.

Contingent joint & survivor annuity

An annuity payable during the joint lifetime of 𝑥 and 𝑦, with the provision that:

·        if 𝑦 dies first, then the original amount is payable during the remaining lifetime of 𝑥.

·        if 𝑥 dies first, then a percentage of the original amount is payable during the remaining lifetime of 𝑦.

Pop-up annuity

A joint & survivor annuity, with a provision that upon the death of 𝑦 while 𝑥 is alive, the payment amount to 𝑥 "pops up" to a given amount for the remaining lifetime of 𝑥.

Reversionary annuity

An annuity payable during the lifetime of 𝑦, with payments beginning upon the death of 𝑥.

Joint annuity

An annuity payable during the joint lifetime of 𝑥 and 𝑦, with payments stopping upon the first death, regardless of who dies first.