Credit & distress early warning
For credit analysts, distressed-debt funds, lenders
Leverage, coverage, liquidity, price drawdowns, volatility spikes, downgrades and insider selling can be combined in one statement. Equity usually flags credit trouble first, and this is where you see it.
- Financial markets
- 6 steps
- Runs on live data
How EquationDB answers it
Each step is one query on live data. Run them in order, or open any one and adapt it: change the symbol, the station, the dates or the filter.
Levered with thin coverage
Net debt above four times EBITDA and EBIT covering interest less than three times, with price stress alongside.
GET top500 SELECT symbol, sector, netdebt_ebitda, interest_coverage, dist_high(252), natr(14) WHERE netdebt_ebitda > 4 AND interest_coverage < 3 SORT interest_coverage
Deep drawdown, volatility spiking
More than 40% below the peak with volatility in the top decile of the stock's own year: the equity market pricing in stress.
GET top500 SELECT symbol, sector, drawdown() AS dd, natr(14) WHERE drawdown() < -40 AND natr(14) > pctl(90) SORT dd
Downgrades of levered names
Analyst downgrades in the last month for companies with net debt above three times EBITDA.
RATINGS IN top500 LAST 1mo WHERE action = 'downgrade' AND symbol IN (GET top500 WHERE netdebt_ebitda > 3)
New lows among high-leverage names
52-week lows in the past month for companies with debt above twice equity.
EVENTS new_low_252 IN (GET top500 WHERE debt_equity > 2) LAST 1mo
Insiders selling weak credits
Insider sales at companies with interest coverage below three times.
INSIDERS IN (GET top500 WHERE interest_coverage < 3) LAST 3mo WHERE type LIKE 'S%' SORT value DESC
Liquidity squeeze
Current ratio below 0.8 and negative free cash flow: short-term obligations with no internal funding.
GET top500 SELECT symbol, sector, current_ratio, quick_ratio, fcf_yield WHERE current_ratio < 0.8 AND fcf_yield < 0
Run it on your own question
Sign in and press Try it on any step, or ask for a short demo on your data.
More financial markets use cases
- Risk management & stress testingCROs, risk managers, PMs
- Portfolio construction & hedgingPMs, allocators, overlay managers
- Single symbol deep-diveAnalysts, portfolio managers and traders researching one name
- Due diligence on one companyFundamental analysts, PMs, credit and PE associates
- Financial statement analysisFundamental analysts, credit analysts, private-equity and long/short equity teams
- Morning briefingPortfolio managers, heads of trading, desk strategists