Home
Interactive tools

Actuarial calculators

Five tools every actuary should have at hand, anchored in the SOA and CAS exam syllabi. From the time value of money to Bühlmann credibility: move the controls, read the narrative and watch how the result changes. They complement the four in the Lab on the home page.

The actuary's quantitative toolkit

The SOA does not publish an official calculator app, but its exam curriculum (FM, FAM, ALTAM and ASTAM) and that of the CAS define precisely the tools an actuary must master. These five cover the four big areas of the profession, finance, life, risk and property and casualty, plus the thread that ties them together: credibility. Each comes with its narrative and its formula.

The time value of money

The narrative. A peso today is not worth the same as a peso ten years from now, and all of actuarial science lives on that difference. Discounting and accumulating cash flows is the first building block: insurance premiums, pension reserves and bond valuations all rest on it. The annuity (a series of equal payments) is the piece that recurs most often. Its present value \(a_{\overline{n}|}\) answers the most frequent question in the profession: what is a promise of future payments worth today? Switching the annuity from immediate to due (paying at the end or at the start of each period) multiplies it by \((1+i)\), a detail that moves millions in pensions.

Annuities and present value

Equal payments over \(n\) periods at an effective rate \(i\).
Quick converter: a nominal rate of 8% compounded 12 times a year is equivalent to an effective rate of 8.30%.
·
Present value
·
Future value
·
\(a_{\overline{n}|}\) factor
·
\(s_{\overline{n}|}\) factor
$$a_{\overline{n}|}=\frac{1-v^{n}}{i},\qquad \ddot a_{\overline{n}|}=a_{\overline{n}|}(1+i),\qquad s_{\overline{n}|}=\frac{(1+i)^{n}-1}{i}$$
With \(v=1/(1+i)\). The future value accumulates the same payments to the final date. Bars: accumulated balance period by period.

Life net premiums and reserves

The narrative. Life insurance is a symmetric bet against mortality: the insurer collects today and pays on an uncertain date. The equivalence principle sets the premium by equating, in expected present value, what comes in and what goes out. The net single premium for whole life insurance is \(A_x\); spread over annual payments for as long as the insured is alive, it becomes \(P=A_x/\ddot a_x\). Because more is collected in the early years than the risk requires, a reserve builds up: the insurer's debt to the insured, which grows and is later released. That reserve is the heart of a life company's balance sheet and of any defined benefit pension plan.

Premium and reserve

Makeham mortality, the standard table in SOA texts.
·
Net single premium
·
Net annual premium
·
\(\ddot a_x\) annuity
·
Reserve at \(t\)
$$P=\frac{A_{x}}{\ddot a_{x}},\qquad {}_{t}V = A_{x+t}-P\,\ddot a_{x+t}$$
Makeham's law \(\mu_x = A+Bc^{x}\), with \(A=0.00022\), \(B=2.7\times10^{-6}\), \(c=1.124\). It is illustrative and does not replace a regulatory table (EMSSA / CNSF). Curve: reserve \({}_{t}V\) by year.

How much capital: VaR and TVaR

The narrative. The average does not bankrupt an insurer; the tail does. That is why actuaries measure risk by its extremes. Value at Risk (VaR) is the quantile: the loss that will not be exceeded except with probability \(1-p\). It is intuitive but blind to what happens beyond that point. Tail Value at Risk (TVaR, or CTE) fixes that: it is the average of losses once the VaR has been crossed, so it is always larger and does distinguish a heavy tail from a thin one. Solvency II and Mexico's risk-based capital approach are built on these measures, typically at 99.5%.

VaR and TVaR of the loss

Distribution of the annual aggregate loss.
·
VaRp
·
TVaRp (CTE)
·
Capital above the mean
$$\mathrm{VaR}_p=F^{-1}(p),\qquad \mathrm{TVaR}_p=\frac{1}{1-p}\int_{p}^{1}\mathrm{VaR}_u\,du$$
Normal: \(\mathrm{VaR}_p=\mu+\sigma z_p\), \(\mathrm{TVaR}_p=\mu+\sigma\,\phi(z_p)/(1-p)\). The shaded area is the tail beyond the VaR.

Chain-Ladder and IBNR

The narrative. In property and casualty insurance, claims are not paid on the day they occur: they take months or years to be reported and settled. The insurer knows what it has already paid, but it must estimate what is still to be paid on accidents that have already happened: the IBNR (incurred but not reported). The Chain-Ladder method is the workhorse: it arranges payments in a triangle by accident year and development year, calculates how much the typical row grows from one column to the next (the development factors) and projects each year forward to its ultimate value. The difference between that ultimate and what has already been paid is the reserve. Edit the triangle and watch how the factors and the IBNR change.

Cumulative claims triangle

Cumulative paid amounts (in thousands). Edit any cell; the rest is history.
Development factor \(f_j=\dfrac{\sum_i C_{i,\,j+1}}{\sum_i C_{i,\,j}}\), summing over the years with data in both columns. Purple cells: projection.
·
Total IBNR (reserve)
·
Ultimate losses
·
Paid to date
Bars: IBNR by accident year. Recent years hold most of the reserve because they have more development still to come.

How much to trust experience

The narrative. A client had few claims last year. Are they genuinely a good risk, or were they lucky? Credibility answers by placing a weight \(Z\) between 0 and 1 on their individual experience, and \(1-Z\) on the behavior of the group. With little information, \(Z\) is small and we rely on the group; with plenty, \(Z\) tends to 1 and we let the client's own data speak. The classical version (limited fluctuation) sets how many claims are needed for full credibility. Bühlmann's version is more elegant: \(Z=n/(n+K)\), where \(K\) measures how much variance comes from chance as opposed to real differences between risks. It is essentially the same shrinkage idea that regularizes machine learning models today.

Credibility factor \(Z\)

·
Credibility \(Z\)
·
Credibility-weighted premium
$$Z=\frac{n}{n+K},\qquad \text{Premium}=Z\,\bar X+(1-Z)\,\mu$$
Curve: how \(Z\) rises as \(n\) grows. The dot marks your current case.

From the exam to practice

These five tools are the scaffolding behind a valuation, a rate filing or an actuarial opinion. Explore how they are applied in each specialty of the Mexican actuary.