EconStatsCraft rigorous, plain-spoken econometrics
Econometrics that explains itself.
Regression, panel data, time series and the whole battery of tests. Every result is followed by a verdict you can defend.
Load a dataset to see it here.
EconStatsCraft › Life annuity
The actuarial present value of a life annuity - whole life, temporary or deferred, annuity-due or immediate, payable annually or m times a year - built from a mortality law and an interest rate, with tables showing how the value falls with age and rises as interest falls.
An annuity pays while you live, so its value is the sum of each future payment discounted for interest AND weighted by the probability you are alive to collect it. Two discounts, applied together: money later is worth less, and a payment you might not live to receive is worth less still. Everything else is bookkeeping about when in the year the payment falls.
Pricing a pension or a purchased life annuity, valuing the premium stream of an insurance policy (premiums are a life annuity), or converting a lump sum into an income for life.
The expected present value of a whole-life annuity-due paying 1 at the start of each year is \ddot{a}_x=\sum_{k\ge0}v^k\,{}_kp_x with v=1/(1+i). The immediate version pays at the end, so a_x=\ddot{a}_x-1. Writing D_x=v^x\ell_x and N_x=\sum_{k\ge x}D_k gives the commutation form \ddot{a}_x=N_x/D_x, which is how these were computed before machines. The fundamental identity linking annuities and insurances is A_x=1-d\,\ddot{a}_x where d=i/(1+i): an insurance and an annuity are two views of the same cash flow, and any pair of values that violates it contains an arithmetic error.
\ddot{a}_x = \sum_{k=0}^{\infty} v^{k}\,{}_{k}p_x,\qquad \ddot{a}_{x:\overline{n}|} = \sum_{k=0}^{n-1} v^{k}\,{}_{k}p_x,\qquad \ddot{a}_x^{(m)} \approx \ddot{a}_x - \tfrac{m-1}{2m}
Makeham mortality, age 45, interest 4%. The whole-life annuity-due is 18.1821 and the annuity-immediate 17.1821 - differing by exactly 1, because the only difference between them is the payment made today, which needs no discounting and no survival. Two more identities are visible in the same table and worth checking by hand, because they are what tells you the table is internally consistent: the 20-year temporary annuity (13.5517) plus the 20-year deferred annuity (4.6304) comes to 18.1821, the whole-life value, since together they cover every year exactly once. And the annuity payable monthly comes to the same 18.1821 under the Woolhouse two-term approximation at this age. The age ladder is the commercial point: 18.1821 at 45 falls to 11.8741 at 65 and 8.3241 at 75, so the same yearly pension costs a 45-year-old buyer more than half as much again as a 65-year-old, entirely because of the years of payment in between.
| If you see this | It means | Do this |
|---|---|---|
| Annuity value above 1/d | Impossible: that is the perpetuity limit | Check the survival probabilities are below one |
| A + d times a-due not equal to 1 | Inconsistent basis or an arithmetic slip | The identity is exact; something is wrong |
| Value barely changing with age | Mortality too light, or the horizon truncated | Check the table closes properly |
| Enormous sensitivity to the interest rate | Correct. Duration is long | Report the sensitivity alongside the value |
| Immediate and due values equal | The timing adjustment was not applied | They must differ by exactly 1 |
| Deferred annuity cheaper than expected | Correct: survival to vesting is not certain | The deferral discount is mortality as well as interest |
Life insurance values, the other side of the same identity. Life table, which supplies the survival probabilities.
Life table · Life insurance pricing · Chain ladder reserving · Buhlmann credibility · Survival analysis · Mortality graduation · Aggregate loss model · Ruin probability · Multi-state Markov model · Loss severity fitting
Line chart · Area chart · Bar chart · Stacked bar · Scatter plot · Bubble chart · Histogram · Box plot · Pie chart · Heat map · Rebased to 100 · Lorenz curve and Gini
World map · Bivariate map · Flow map · India - state map · India - district map
Descriptive statistics · Summary by group · Two-way table · Classical statistical tests
Multiple regression (OLS) · Logit / Probit · Tobit (censored) · Truncated regression · Multinomial logit · Ordered logit / probit · Quantile regression · Poisson / Negative binomial
Time-varying coefficients (Kalman) · Unit root tests · Correlogram (ACF / PACF) · ARIMA / SARIMA · Rolling-origin cross-validation · Theta method · Unobserved components · STL forecasting · Forecast combination · Markov regime switching · Change frequency (resample) · ARCH / GARCH volatility · Decompose & filter · Spectral analysis · Exponential smoothing · Forecast accuracy
Yield curve (Nelson–Siegel / Svensson) · Dynamic factor model · Dynamic regression (ARIMAX) · Structural VAR · VAR · Granger causality · Cointegration · VECM · ARDL & bounds test
Panel regression · Panel cointegration tests · Heterogeneous panel: Mean Group & PMG · Gravity model of trade · Dynamic panel GMM · Panel diagnostics · Panel unit-root tests
Principal components (PCA) · Factor analysis · Cluster analysis
Conjoint analysis · MaxDiff (best–worst scaling) · TURF - reach of a product line · Price sensitivity (Van Westendorp) · Market basket analysis · Perceptual map · Scale reliability (Cronbach’s alpha) · Key driver analysis
Spatial autocorrelation · Spatial regression · Heckman selection · Instrumental variables (2SLS) · Difference-in-differences · Staggered difference-in-differences · Regression discontinuity · Matching & weighting · Oaxaca–Blinder decomposition
Black–Scholes option pricing · Bond price, duration & convexity · Merton distance to default · EMI / home loan planner · CAPM / beta estimation · Multi-factor model · Portfolio optimization · Value at Risk & Expected Shortfall · Performance & drawdown · Time value of money & NPV/IRR · Equity valuation (DDM, FCF, residual income) · Cost of capital (WACC) · Binomial option pricing · Option strategies (payoff & profit) · Forwards, futures & swaps · Credit risk & Basel capital · Extreme value theory (tail risk)
Life table · Life annuity · Life insurance pricing · Chain ladder reserving · Buhlmann credibility · Survival analysis · Mortality graduation · Aggregate loss model · Ruin probability · Multi-state Markov model · Loss severity fitting
Monte Carlo experiment · F-test, Wald & Chow · Structural breaks & stability
Regression vs machine learning · Ridge / Lasso / Elastic Net · Random forest · Gradient boosting
EconStatsCraft rigorous, plain-spoken econometrics
Regression, panel data, time series and the whole battery of tests. Every result is followed by a verdict you can defend.
Load a dataset to see it here.
Pick the example closest to your question. You get a spreadsheet with the right columns and a few rows showing the expected format - replace the numbers with your own, then paste or upload it back.
Copy the header row from the table above (or from the downloaded template), put your own rows underneath, and paste the whole thing here. It is checked against the layout before anything is imported.
Or click a row in the preview below.
For a units or notes row.
Search every source at once. World Bank indicators need countries and years; everything else loads in one click.
Loading the catalogue…
The engine stays loaded, so this is quick - and it leaves your open tab and panel layout alone.
⌘/Ctrl+Enter runs the current analysis. ⌘/Ctrl+P exports the session as a PDF. Esc closes this.
In the Notebook: Enter starts a new block and
Shift+Enter a new line inside one; Backspace at the start
joins back into the paragraph above; / on an empty line inserts anything.
⌘/Ctrl+B, I, E, H and
M apply bold, italic, code, highlight and maths.
#, ##, -, 1., > and
``` at the start of a line convert it.
Sign in to run unlimited analyses.
Scroll to pan · Esc to close