Excel Functions in EAC ToolsExcel Functions in EAC Tools\Actuarial equivalence functions

Actuarial equivalence functions

Actuarial equivalence is the concept that different forms of distributions (e.g. various types of annuities or a lump sum payout), with different payment amounts, have the same actuarial present value.

Excel Functions

Function Name

Category

Description

AE

AE

Actuarial equivalent factor for early & late commencement.

AEERF

AE

Actuarial equivalent factor for early commencement.

AELRF

AE

Actuarial equivalent factor for late commencement.

AESLtoCL

AE

Actuarial equivalent factor to convert a single life annuity to a certain & life annuity.

AESLtoJL

AE

Actuarial equivalent factor to convert a single life annuity to a joint life annuity.

AESLtoJL_WS

AE

Actuarial equivalent factor to convert a single life annuity to a joint life annuity with certain period.

AESLtoLI

AE

Actuarial equivalent factor to convert a single life annuity to a level income annuity.