Excel Functions in EAC ToolsExcel Functions in EAC Tools\More PV functionsMore PV functions\MortDesc

MortDesc

MortDesc returns a text description for a given mortality table that is provided as the MortalityTable parameter for any function.

For example:

·        if MortalityTable = “rp2000-cm@2014/aa/gen”, then MortDesc function returns “RP 2000 Combined Healthy (male), at valuation year 2014 with generational improvement using Scale AA (male)”.

·        if MortalityTable = “LS2021”, then MortDesc function returns “2021 417(e)(3) Applicable Mortality Table (Notice 2019–67)”.

Syntax

MortDesc (MortalityTable)

Parameter Name

Description

MortalityTable

Mortality table definition text string.