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 insurance pricing
Prices a whole-life, term or endowment policy from a mortality law and an interest rate: the EPV of the benefit A_x, the net single premium, the net level annual premium by the equivalence principle, the standard deviation of the loss, and the prospective benefit reserve year by year.
A life insurance pays on death, so its value is each possible payment discounted to today and weighted by the probability of dying in that year. An annuity pays while you live and an insurance pays when you stop, so the two are complementary views of the same survival curve - which is why a single identity ties them together and why premiums are set by equating the two.
Setting the office premium base for whole-life, term or endowment assurance, and computing the policy value (reserve) the insurer must hold per in-force policy for solvency reporting.
The expected present value of a whole-life insurance paying 1 at the end of the year of death is A_x=\sum_{k\ge0}v^{k+1}\,{}_kp_x\,q_{x+k}, the sum over each year of (discount) times (probability of surviving to that year) times (probability of dying in it). The identity A_x=1-d\,\ddot{a}_x follows from writing v^{k+1}=v^k-dv^k and collecting terms. The EQUIVALENCE PRINCIPLE sets the level annual premium by equating expected present values at issue: P_x=A_x/\ddot{a}_x, so premium equals insurance divided by annuity. The reserve at time t is the prospective shortfall _tV_x=A_{x+t}-P_x\ddot{a}_{x+t}, which is positive because the premium was levelled across ages at which the true cost differs.
A_x = \sum_{k=0}^{\infty} v^{k+1}\,{}_{k}p_x\,q_{x+k},\qquad P = \frac{S\,A_x}{\ddot{a}_x},\qquad {}_{t}V = S\,A_{x+t} - P\,\ddot{a}_{x+t}
A 20-year endowment at age 45 on Makeham mortality at 4%, sum assured 100,000. The expected present value of the benefit is A = 0.47878, so the net single premium is 47,877.93 - pay that once today and the policy is fully funded. Spread it over 20 years instead and the annuity factor is 13.5517, giving a net level annual premium of 100,000 x 0.47878 / 13.5517 = 3,532.97. Do that division yourself: the premium is not the single premium divided by 20, which would be 2,394, but by 13.55 - and the gap between 20 and 13.55 is entirely discounting and the chance of dying before paying them all. The reserve column is where the money goes: zero at issue by construction, 3,396.79 after one year, 18,245.05 after five. That is the liability the insurer has to hold, and it climbs because the early premiums exceed the early claim costs while the later ones do not.
| If you see this | It means | Do this |
|---|---|---|
| A above 1 | Impossible for a benefit of 1 | Discounting has been omitted or the rate is negative |
| Premium exceeding the sum assured divided by the term | Almost certainly an error | Check the annuity denominator |
| Reserve negative in early years | Normal for some designs with expense loading | Zeroise it if the valuation basis requires it |
| Whole-life and term values almost equal | The term is nearly the whole of life | Expected at high ages |
| A + d times a-due not equal to 1 | Inconsistent basis | The identity is exact |
| Premium insensitive to age | Mortality too flat | Check qx actually rises with age |
Life annuity, which supplies the denominator of the premium. Life table, for the underlying probabilities.
Life table · Life annuity · 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