Software solutions for actuaries

Act-fx : the Actuarial Toolkit for Excel


Compound Interest

Function     Description
annc             Annuity-certain - present value
d                   Discount rate per period.
ddelta           Interest conversion factor - annual in advance to continuous.
ddm              Interest conversion factor - annual in advance to m-thly payments in advance.

dimm             Interest conversion factor - annual in advance to m-thly payments in arrear.
dm                Nominal rate of discount payable m times per period.
foi                 Force of interest (delta).

idelta             Interest conversion factor - annual in arrear to continuous.
idm                Interest conversion factor - annual in arrear to m-thly payments in advance.
iim                 Interest conversion factor - annual in arrear to m-thly payments in arrear.

im                  Nominal rate of interest payable m times per period.
sannc           Annuity-certain - accumulated value at end of term.
v                   Present value of 1 payable at end of unit period.
yieldann        Annualise yield from bi-annual nominal yield.



Mortality

Function        Description
AgeAtDeath    Expected age at death for given age according to mortality table specified.

e                      Complete expectation of life for given age according to the mortality table specified.

q                      Mortality rate for given age, table rating and factor.  Projection parameters may be specified.

MaxTableAge  Maximum (terminal) age for the mortality table specified.
MinTableAge   Minimum (terminal) age for the mortality table specified.
npx                  Probability of life aged x exact surviving n years.
RF                   Reduction factor applicable to mortality rate for improvement projection.
RFTable          Reduction factor applicable to standard table mortality rate for improvement projection.