Financial statement analysis
For fundamental analysts, credit analysts, private-equity and long/short equity teams
Income statement, balance sheet and cash flow as time series: 20 years of quarters and 30 fiscal years per company, with margins, growth and quality ratios computed on the fly and screenable across the whole universe.
- Financial markets
- 11 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.
Ten years of one company
Annual revenue, growth, margin and free cash flow in one table.
FINANCIALS AAPL WHERE period = 'FY' SELECT period_end, revenue, revenue_yoy, net_margin, fcf LIMIT 10
Quarter by quarter
The last eight quarters: growth against the same quarter a year earlier, not the previous quarter.
FINANCIALS NVDA WHERE period <> 'FY' SELECT period_end, period, revenue, revenue_yoy, gross_margin, eps_diluted LIMIT 8
A decade of margins
A long quarterly series, oldest first, ready to chart or export.
FINANCIALS NVDA SINCE 2016-01-01 WHERE period <> 'FY' SELECT period_end, revenue, gross_margin SORT period_end
Growth with profitability
Companies growing over 30% a year while keeping operating margins above 20% in their latest quarter.
FINANCIALS IN top500 WHERE period <> 'FY' AND revenue_yoy > 30 AND op_margin > 20 SELECT period_end, revenue_yoy, op_margin, fcf_margin SORT revenue_yoy DESC LIMIT 20
Free-cash-flow compounders
High and rising free cash flow margins in the latest fiscal year.
FINANCIALS IN top500 WHERE period = 'FY' AND fcf_yoy > 15 AND fcf_margin > 20 SELECT period_end, fcf, fcf_yoy, fcf_margin SORT fcf_margin DESC LIMIT 20
Margin expansion
Gross profit growing faster than revenue: pricing power or mix shift.
FINANCIALS IN top500 WHERE period <> 'FY' AND sector <> 'Financial Services' AND gross_profit_yoy - revenue_yoy > 5 AND revenue_yoy > 5 SELECT period_end, revenue_yoy, gross_profit_yoy, gross_margin SORT gross_profit_yoy DESC LIMIT 20
Balance-sheet stress
High leverage with more short-term liabilities than short-term assets: refinancing risk.
FINANCIALS IN top500 WHERE period <> 'FY' AND debt_to_equity > 3 AND current_ratio < 1 SELECT period_end, debt_to_equity, current_ratio, net_debt SORT debt_to_equity DESC LIMIT 20
Shrinking share count
Companies retiring more than 3% of their shares a year, next to the free cash flow that pays for it.
FINANCIALS IN top500 WHERE period = 'FY' AND shares_yoy < -3 SELECT period_end, shares_yoy, buybacks, fcf SORT shares_yoy LIMIT 20
Heavy dilution
Share count up over 5% in a year, with stock-based compensation as a share of revenue.
FINANCIALS IN top500 WHERE period <> 'FY' AND shares_yoy > 5 SELECT period_end, shares_yoy, sbc_pct_revenue SORT shares_yoy DESC LIMIT 20
What sold off after earnings
A subquery joins the price reaction to the statements: were the fundamentals weak, or was it expectations?
FINANCIALS IN top500 WHERE period <> 'FY' AND symbol IN (EARNINGS IN top500 LAST 3mo WHERE reaction < -8) SELECT period_end, revenue_yoy, gross_margin, accruals
Dubai companies by return on equity
DFM-listed companies report in AED; ratios compare across markets, raw amounts do not.
FINANCIALS IN dubai WHERE period = 'FY' SELECT period_end, currency, revenue, net_margin, roe SORT roe DESC
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
- Single symbol deep-diveAnalysts, portfolio managers and traders researching one name
- Due diligence on one companyFundamental analysts, PMs, credit and PE associates
- Morning briefingPortfolio managers, heads of trading, desk strategists
- Momentum & trend followingCTAs, trend followers, growth PMs
- Mean reversion & short-term reversalShort-term traders, stat-arb desks
- Event-driven tradingEvent-driven PMs, special-situations traders