Excel Functions in EAC ToolsExcel Functions in EAC Tools\Single life functionsSingle life functions\Single life cash refund

Single life cash refund

A cash refund annuity is a life annuity with a provision that at the time of death, an amount will be paid in a lump sum equal to the excess, if any, of the present value of the annuity at the time of commencement, over the sum of the annuity payments received prior to death.

Excel Functions

Function Name

Category

Description

CASHREFUND

Single life

Present value of single life cash refund annuity

CASHREFUNDJ

Single life

Present value of single life cash refund annuity -- according to Jordan

CASHREFUNDPPA

Single life

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