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 › Cost of capital (WACC)
Builds the discount rate a firm's projects must clear: the CAPM cost of equity, the after-tax cost of debt and preferred, market-value weights, and how WACC shifts as the debt mix changes once beta is relevered.
A firm raises money from shareholders and lenders, and each expects a return that matches the risk it bears. The firm's projects must earn enough to pay all of them, so the hurdle rate is the blend of their required returns, weighted by how much each has put in. Debt is cheaper than equity both because lenders are paid first and because interest reduces tax.
Setting the hurdle rate for a project of average risk, discounting free cash flow to the firm in a valuation, or judging whether a change in capital structure lowers the cost of funding.
Investors' total required cash return is r_E E + r_D(1-t)D + r_P P on capital V=E+D+P, so the required return per unit of capital is the value-weighted average. The cost of equity comes from CAPM, r_E=r_f+\beta_E\,\text{ERP}. With risk-free debt, the levered beta satisfies \beta_E=\beta_A[1+(1-t)D/E] (Hamada), so business risk \beta_A can be unlevered from a comparable firm and relevered at a target capital structure.
\text{WACC} = w_E\,r_E + w_D\,r_D(1-t) + w_P\,r_P,\qquad r_E = r_f + \beta_E\,\text{ERP},\qquad \beta_A = \frac{\beta_E}{1+(1-t)\,D/E}
A firm with 600 of equity and 400 of debt by market value. With a 4% risk-free rate, a beta of 1.2 and a 5.5% equity risk premium, CAPM gives a 10.6% cost of equity. Debt costs 6% before tax and 4.5% after a 25% tax rate. WACC is 0.6 × 10.6% + 0.4 × 4.5% = 6.36% + 1.80% = 8.16%. Unlevering gives an asset beta of 0.80: the business risk alone, before the extra risk that 40% debt puts on shareholders.
| If you see this | It means | Do this |
|---|---|---|
| WACC below the risk-free rate | A sign or percent error | Check every input is in percent |
| WACC falls forever as debt rises | Cost of debt held fixed | Raise rd as leverage rises; the chart notes this |
| Weights look wrong | Book values used | Use market values of equity and debt |
| Cost of equity very high | Beta from a highly levered comparable | Unlever, then relever at your own structure |
CAPM / beta, to estimate beta from returns. Equity valuation, which discounts at this rate.
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) · 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