TEMPLATES


Templates are spreadsheets that can be opened/created from the Excel ribbon and are designed to provide quick access to analysis.

Annuity Templates
Annuity Factor - Single Life Actuarial annuity factor on one life
Annuity Factor - Multiple Life Actuarial annuity factor on two lives
Annuity Factor - Certain Pure financial annuity, with no mortality
Annuity Factor - Sensitivity Of The sensitivity of an annuity factor with respect to each of its parameters
Probability - Survival Probability of living for a specified period of time
Probability - Deferred Death Probability of living for a specified period of time, then dieing in a specified period thereafter
Actuarial Equivalence - Optional Forms Equating different pension types on an actuarial equivalent basis
Actuarial Equivalence - Retirement Age Equating different retirement ages on an actuarial equivalent basis
Life Expectancy Age when an individual is expected to die
Actuarial Discount Factor A survival and interest rate discount factor, also known as a pure endowment
Mortality Basis Comparison Compare the survival, life expectancy and annuity values of two mortality bases
Commutation Functions Standard table of commutation functions for a given age, interest rate and mortality basis
Insurance Templates
Insurance Factor - Single Life Actuarial insurance factor on one life
Insurance Factor - Multiple Life Actuarial insurance factor on two lives
Insurance Factor - Sensitivity Of The sensitivity of an insurance factor with respect to each of its parameters
Other Templates
Black-Scholes Calculator Black-Scholes framework calculations and analysis
Cashflow Analysis Keyrate duration profile & convexity for a set of cashflows