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

AE

AE calculates an actuarial equivalent early/late retirement reduction/increase factor based on a normal retirement age (𝑁𝑅𝐴), and an assumed retirement age (𝑅𝐴).

·        If 𝑅𝐴 < 𝑁𝑅𝐴 then AE is the same as the function AEERF.

·        If 𝑅𝐴 > 𝑁𝑅𝐴 then AE is the same as the function AELRF.

·        If 𝑅𝐴 = 𝑁𝑅𝐴 then AE returns a value of 1.