# 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.