EquationDB

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.

  1. 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
    Try it →
  2. 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
    Try it →
  3. 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
    Try it →
  4. 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
    Try it →
  5. 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
    Try it →
  6. 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
    Try it →
  7. 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
    Try it →
  8. 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
    Try it →
  9. 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
    Try it →
  10. 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
    Try it →
  11. 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
    Try it →

Run it on your own question

Sign in and press Try it on any step, or ask for a short demo on your data.

Request a trial

More financial markets use cases