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

MortProjFactor

MortProjFactor returns a factor for a given mortality improvement projection scale.

Syntax

MortProjFactor (ScaleName, Age, Sex, IsGen, BaseYear, ProjYear, [IssueAge], [ScaleWeight])

Parameter Name

Description

ScaleName

Mortality improvement projection scale name.

Age

Current age 𝑥.

Sex

"m" or "f", not used if sex is implicit in the table name.

IsGen

Defines if a generational mortality projection should be used.

Option

Description

0, blank, “no”, or “n”

Use static projection

1, “yes”, or “y”

Use generational projection

 

BaseYear

Project mortality rates from the given table using this year as the “base year”.

ProjYear

Project mortality rates to this year.

IssueAge

If using generational mortality projection, age at issue.
Optional, default = Age.

ScaleWeight

All table values are multiplied by this factor.
Optional, default = 1.