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 › Equity valuation (DDM, FCF, residual income)
Intrinsic value per share three ways - discounted dividends, discounted free cash flow, or book value plus residual income - with a high-growth stage, a terminal value and a grid showing how much the answer moves with a point on r or g.
A share is a claim on future cash, so it is worth the present value of that cash. The models differ only in which cash they count: dividends actually paid, free cash flow the business could pay, or the profit earned above what shareholders require on the capital they have put in. With consistent assumptions all three give the same answer.
Valuing a share for an equity research note, a CFA equity question, or a sanity check on a market price. Dividend models suit mature payers, free cash flow models suit firms that pay little or nothing, and residual income suits banks and firms with negative free cash flow but positive earnings.
With dividends growing at a constant g<r, V_0=\sum_{t\ge1}D_0(1+g)^t(1+r)^{-t}=\frac{D_1}{r-g}, a geometric series. A two-stage model sums the first n dividends explicitly and adds the Gordon value of the rest, \frac{D_{n+1}}{r-g_2}, discounted n years. Residual income rewrites the same value using clean-surplus accounting, B_t=B_{t-1}+E_t-D_t: substituting D_t and telescoping gives V_0=B_0+\sum_t\frac{E_t-rB_{t-1}}{(1+r)^t}, so value is book value plus the present value of profit above the cost of equity.
V_0 = \sum_{t=1}^{n}\frac{D_0(1+g_1)^t}{(1+r)^t} + \frac{D_{n+1}}{(r-g_2)(1+r)^n},\qquad V_0 = B_0 + \sum_{t\ge1}\frac{(\text{ROE}-r)\,B_{t-1}}{(1+r)^t}
A share paying 2.00 today, with dividends growing 8% a year for five years and 4% after that, discounted at 10%. The five high-growth dividends are worth 9.47 today. The dividend in year six is 3.06, so the terminal value at year five is 3.06 / (10% − 4%) = 50.94, worth 31.63 today. Intrinsic value is 41.10, against a market price of 40, so the share looks about 3% undervalued. But 77% of the value is the terminal value, and the grid shows that at r = 11% the same share is worth only 35.13. The honest conclusion is "fairly priced, within the uncertainty of r".
| If you see this | It means | Do this |
|---|---|---|
| Value is enormous or negative | Terminal growth at or above the required return | Lower g below r |
| Value far from the market price | Inputs, not the market, are off | Check r against CAPM and g against nominal GDP |
| Terminal value above 90% of total | High-growth stage too short | Model the transition with more years |
| FCFF value per share looks too high | Net debt not subtracted | Enter net debt and shares outstanding |
| Residual income negative every year | ROE below the cost of equity | Correct: the firm destroys value and is worth less than book |
Cost of capital (WACC), for the discount rate. Time value of money, for the arithmetic. CAPM, for the cost of equity.
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 · Cost of capital (WACC) · Binomial option pricing · Option strategies (payoff & profit) · Forwards, futures & swaps · Credit risk & Basel capital · Extreme value theory (tail risk)
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