fundamental-screening
Fundamental and governance screening of Indian listed companies in the style of Screener.in: valuation (P/E, P/B, EV/EBITDA, PEG vs history and peers), quality (ROCE, ROE, cash conversion, debt), grow
SKILL.mdskills/fundamental-screening/SKILL.md
GitHubFundamental Screening (India)
Technicals decide when; fundamentals decide whether to hold for long. Screen for quality and red flags first. Valuation only matters once those pass.
Where to get data
- Company filings on nseindia.com and bseindia.com: quarterly results (due within 45 days of quarter end, 60 days for Q4), shareholding pattern (within 21 days of quarter end), annual reports, investor presentations, concall transcripts, and SAST/pledge disclosures.
- Aggregators: Screener.in (ratios, 10-year financials, peer tables), Trendlyne, Tickertape, Moneycontrol. Fetch with WebFetch and cite the page and date.
- Broker MCPs generally give prices and holdings, not financials.
- Always state the period: TTM, FY26, or Q2 FY27 (India's FY runs April–March; Q2 FY27 = Jul–Sep 2026).
1. Quality (pass at least 4 of 6 for a "quality" tag)
| Metric | Good | Notes |
|---|---|---|
| ROCE (5-yr avg) | > 15% | Use ROE for banks/NBFCs |
| Operating cash flow / net profit (5-yr) | > 80% | Low means profits aren't converting to cash |
| Debt / equity | < 0.5 (non-financials) | Interest coverage > 4× |
| Sales growth (5-yr CAGR) | > 10% | Compare with India's nominal GDP growth |
| Profit growth (5-yr CAGR) | ≥ sales growth | Watch "other income"-driven profits |
| Promoter holding | Stable/rising, pledge ≈ 0% | Pledge > 20% of promoter stake is a red flag |
2. Valuation (relative, never absolute)
- P/E vs the company's own 5- and 10-year median and vs 3–5 listed peers. PEG = P/E ÷ EPS growth (%).
- Banks/NBFCs: P/B and P/ABV with ROA > 1.2%, GNPA/NNPA trend, credit cost, NIM, CASA ratio (banks), capital adequacy > 15%.
- IT services: constant-currency revenue growth, EBIT margin, deal TCV, attrition, US exposure.
- FMCG/consumer: volume growth vs price growth, gross margin vs raw materials, distribution reach.
- Capital goods/infra: order book ÷ revenue (years of visibility), working-capital days, execution.
- Cyclicals (metals, cement, chemicals): use EV/EBITDA through the cycle. Low P/E at peak earnings is a trap.
3. Shareholding pattern (quarterly)
| Signal | Reading |
|---|---|
| Promoter stake rising (open-market buys) | Insider confidence |
| Promoter stake falling via OFS/blocks | Check the reason: debt repayment vs exit |
| Pledged shares rising | Margin-call risk on a price fall; forced selling spirals |
| FII + DII (MF) stake rising | Institutional accumulation |
| Retail/public share rising while price rises | Late-stage retail chase; caution |
4. Red flags (any one is serious)
- Promoter pledge above about 20%, or pledge invocations.
- Auditor resignation or qualified opinion, or frequent changes of auditor or CFO.
- Large related-party transactions, loans to promoter entities, complex subsidiary webs.
- Receivables or "other current assets" growing much faster than sales. Repeated "exceptional items".
- Persistent negative operating cash flow with reported profits.
- Frequent equity dilution: preferential allotments, warrants to promoters at low prices.
- Inclusion in ASM/GSM/ESM surveillance, trade-for-trade series (BE/BZ), or a 2%/5% price band.
- SEBI, ED, SFIO or tax actions. Delayed results filings.
- Operator/tip-stock pattern: tiny free float, upper-circuit streaks, volume spikes with no news, Telegram/WhatsApp promotion, an SME listing at an extreme multiple.
5. Reading quarterly results
- YoY first (seasonality), then QoQ. Separate revenue growth into volume and price where disclosed.
- EBITDA margin trend and its drivers: raw materials, employee cost, pricing.
- Strip out one-offs (exceptional items, tax write-backs, other income spikes).
- Compare with consensus if available (news), management guidance, and the previous concall.
- Note the price reaction. A good result with a falling price means expectations were higher.
Output
# [Company] — fundamental screen ([data period], sources)
Verdict: [Quality compounder | Fair | Cyclical | Speculative | Avoid] — one line why
| Quality | Value | Pass? |
...
Valuation: P/E x vs 5-yr median y, peers z → [cheap/fair/rich]
Shareholding: promoter a% (pledge b%), FII c%, DII d% — trend
Red flags: none / [list]
What to watch: next results date, guidance items, risks
State that this is not investment advice, and that fundamentals inform long-term holding, not short-term price moves.