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 › Merton distance to default
Treats equity as a call option on the firm and backs out the unobserved asset value and asset volatility, then reports how many standard deviations of cushion sit above the debt and the implied probability of default.
Equity in a leveraged firm is a call option on the firm's assets, struck at the face value of its debt. If the assets are worth more than the debt at maturity, shareholders repay and keep the difference; if not, they hand over the firm and walk away, because limited liability caps their loss at zero. Once you see that, the whole option-pricing machinery becomes a credit model, and default probability is just the chance the option finishes out of the money.
Estimating a firm's probability of default from market data, ranking credits, or understanding why default risk explodes as leverage rises. It underlies commercial scores such as Moody's KMV EDF.
Let asset value follow dV=\mu V\,dt+\sigma_V V\,dW and let debt be a zero-coupon claim of face D maturing at T. Equity pays \max(V_T-D,0), which is a call, so E=V\Phi(d_1)-De^{-rT}\Phi(d_2) with d_1=[\ln(V/D)+(r+\sigma_V^2/2)T]/(\sigma_V\sqrt{T}). DISTANCE TO DEFAULT is d_2: the number of standard deviations of asset value between the firm and its default point. The risk-neutral default probability is \Phi(-d_2). In practice V and \sigma_V are unobservable, so they are backed out by solving the equity equation jointly with \sigma_E E=\Phi(d_1)\sigma_V V, which comes from Ito applied to E(V).
E = V\,N(d_1) - F e^{-rT} N(d_2),\qquad \sigma_E E = N(d_1)\,\sigma_V V,\qquad \text{DD} = \frac{\ln(V/F) + (\mu - \tfrac12\sigma_V^2)T}{\sigma_V\sqrt{T}},\qquad \text{PD} = N(-\text{DD})
The demo solves the problem the way a credit analyst actually meets it: equity is observable and assets are not. Given equity of 100 with a volatility of 45%, debt with a face value of 90, one year and a risk-free rate of 4%, the model backs out an asset value of 186.4650 and an asset volatility of 24.145%. Note that asset volatility is far below equity volatility - always, because equity is a levered claim on the assets, and here leverage of 48.27% turns 24% asset volatility into 45% equity volatility. Distance to default comes out at 3.0619 standard deviations, giving a risk-neutral default probability of 0.110%. Treat that as an ordering statistic rather than a forecast. Real-world default frequencies at three standard deviations of distance are higher than a tenth of a percent, and the gap is the credit risk premium plus the fact that real asset returns are not lognormal - not an error in the arithmetic. The model is at its best ranking firms against each other and at its worst quoting an absolute probability.
| If you see this | It means | Do this |
|---|---|---|
| Default probability essentially zero | Distance to default above 4, or volatility understated | Check the asset volatility input |
| Distance to default negative | Assets already below the debt face value | The firm is technically insolvent on this measure |
| Probability far above the observed default rate | Risk-neutral, not real-world | Expected. Map it empirically before quoting it |
| Very unstable week to week | Equity volatility moving the solved asset volatility | Smooth the volatility input over a longer window |
| Solver fails to converge | Poor starting values for V and sigma-V | Start from V = equity + debt and sigma-V = sigma-E times E over V |
| A firm with no traded equity | The model needs a market price | It cannot be applied. Use an accounting-ratio model |
Black-Scholes, which is the same formula read as an option rather than as credit. Logit and probit, for the accounting-ratio approach to the same question.
Black–Scholes option pricing · Bond price, duration & convexity · 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)
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