Beginner's Guide · Indian Stock Market
How to Pick Indian Stocks:
A 5-Stage KPI Filter Funnel
Start with 5,000+ stocks on NSE/BSE. Use this step-by-step KPI framework to systematically filter down to 5–10 high-quality stocks worth researching further — before you invest a single rupee.
Disclaimer: This guide is for educational purposes only. It is not investment advice. KPI benchmarks are general guidelines — they vary by sector. Always do your own research and consult a SEBI-registered investment advisor before investing.
The biggest mistake new investors make is picking stocks based on tips, news headlines, or gut feel. This framework gives you a systematic, repeatable process: five stages of KPI filters that eliminate bad stocks one layer at a time, until only the strongest candidates remain. Think of it as a funnel — wide at the top, precise at the bottom.
00 The funnel: how it works
▼
▼
▼
▼
▼
▼
5–10 high-conviction stocks to research deeper
These pass all 5 stages — analyse further before investing
Stage 1 Business quality screen
First cut: remove penny stocks, shell companies, and consistently loss-making businesses. You want real companies with a proven operating history before anything else.
1
Business quality — eliminate junk
4 KPIs
▼
Goal: eliminate penny stocks, shell companies, and consistently loss-making businesses. Only keep real companies with a track record.
Market cap
Price × shares outstanding
≥ ₹500 Cr (mid-cap+)
Filters out micro-caps with low liquidity and manipulation risk. Beginners should stick to ₹2,000 Cr+ for safety.
Revenue (3-yr trend)
YoY revenue growth %
Growing consistently
Eliminates shrinking or erratic businesses. Look for at least 3 years of positive, consistent revenue growth.
Profit after tax (PAT)
Net income (bottom line)
Positive for 3+ years
Cuts out loss-making companies. Sustained losses are high-risk for new investors regardless of the growth story.
Years listed
Company age on exchange
≥ 5 years listed
Ensures a track record. Avoids new IPO hype cycles where valuations haven't been tested by a full market cycle.
Stage 2 Profitability & margins
Now check whether the business actually makes money efficiently. High revenue means nothing if margins are thin, declining, or artificially inflated.
2
Profitability — is it a good business?
4 KPIs
▼
High revenue is meaningless without good margins. This stage identifies businesses that make money efficiently and consistently.
ROE
Net Profit ÷ Shareholders' Equity
≥ 15%
Return on Equity. Measures how well the company uses investor money. Warren Buffett's favourite single metric for business quality.
ROCE
EBIT ÷ Capital Employed
≥ 15%
Return on Capital Employed. Better than ROE as it includes debt. Shows real capital efficiency across the whole business.
Operating profit margin
EBIT ÷ Revenue × 100
Sector-relative; stable
Core business profitability before interest and tax. Always compare within the same sector — margins vary wildly across industries.
Net profit margin
PAT ÷ Revenue × 100
Improving trend
Bottom-line efficiency. Look for consistent or improving margins over 3–5 years — expanding margins signal pricing power.
Stage 3 Financial health & debt
A profitable company can still go bankrupt if it is overleveraged. This stage removes financially fragile companies that look good in normal times but crack under pressure.
3
Financial health — can it survive bad times?
4 KPIs
▼
Profitable companies fail when they carry too much debt. This stage eliminates financially fragile businesses — the ones that look fine in bull markets but collapse when things turn.
Debt-to-equity
Total Debt ÷ Shareholders' Equity
< 1.0 (prefer < 0.5)
Lower is safer. Important exception: banks and NBFCs naturally have high D/E ratios — do not apply this benchmark to financial sector stocks.
Interest coverage ratio
EBIT ÷ Interest expense
≥ 3×
Can the company comfortably service its debt? A ratio below 1.5× is a red flag — any business downturn could make debt repayment impossible.
Current ratio
Current Assets ÷ Current Liabilities
≥ 1.5
Short-term liquidity. A ratio below 1 means the company cannot cover near-term bills without new borrowing — structurally dangerous.
Free cash flow (FCF)
Operating CF − Capital Expenditure
Positive; growing
Real cash left after operations and investment. Companies can manipulate accounting profits but cannot fake free cash flow for long.
Stage 4 Valuation — are you overpaying?
A great company at the wrong price is still a bad investment. This stage prevents you from buying into overhyped stocks with no room to grow from current valuations.
4
Valuation — price vs value
4 KPIs
▼
Paying too much is the most common mistake even with fundamentally strong companies. This stage filters out stocks that are priced for perfection with no margin of safety.
P/E ratio
Market Price ÷ EPS
Compare to sector median
Price-to-earnings. Nifty50 average is ~22×. A stock at 80× P/E needs extraordinary future growth to justify the price you pay today.
PEG ratio
P/E ÷ EPS growth rate
< 1.5 = fair value
Adjusts P/E for growth expectations. A PEG of 1 means you're paying exactly for the growth. Under 1 suggests a potential bargain.
P/B ratio
Market Price ÷ Book Value per share
Sector-dependent
Most useful for asset-heavy sectors (banks, PSUs). A high P/B is only justified when ROE is also high — otherwise you're paying for air.
EV/EBITDA
Enterprise Value ÷ EBITDA
< 15× for most sectors
Better than P/E for capital-intensive industries. Accounts for debt and eliminates accounting differences when comparing industry peers.
Stage 5 Growth & moat signals
The final stage separates good companies from great ones. You want businesses with durable competitive advantages — the kind that compound wealth over 5–10 years.
5
Growth & moat — will it stay great?
6 KPIs
▼
The final filter finds businesses with real competitive moats — brand, cost advantage, network effects, switching costs — that can sustain returns for years.
EPS growth (5-yr CAGR)
Earnings per share growth
≥ 15% CAGR
Sustained EPS growth is the single most important driver of long-term stock price returns. Consistent growth beats lumpy high growth every time.
Promoter holding %
% shares held by promoters
≥ 50%; increasing
India-specific signal. Promoters reducing their own stake is a major red flag. Rising promoter holding signals conviction in the business.
Dividend consistency
Dividend payout history
Paid 5+ consecutive years
Signals genuine cash generation and management discipline. Not essential for high-growth companies that reinvest all profits.
FII/DII holding trend
Institutional ownership %
Increasing stake
India-specific. Smart money (mutual funds, foreign investors) increasing their stake is a powerful independent validation signal.
Sales growth (5-yr CAGR)
Revenue CAGR over 5 years
≥ 12–15%
Top-line momentum shows the business is expanding its market share or addressable market, not just cutting costs to look profitable.
Cash conversion cycle
DIO + DSO − DPO
Low & improving
How fast the company converts business activities into actual cash. Shorter cycle = better working capital management and cash flow quality.
Tool How to run this on Screener.in
Screener.in is the best free tool for Indian investors to run this entire 5-stage filter without paying for any subscription. Here's how.
1
Search the company by name or NSE symbol
Go to screener.in and type the stock name or ticker in the top search bar (e.g. "TCS" or "Reliance").
Search: TCS / Reliance / HDFC Bank...
2
Find Market Cap in the top summary bar
Right below the stock name and current price, there is a row showing Market Cap, P/E, Book Value, ROE, and ROCE instantly.
Market Cap
₹13.8L Cr
Current Price
₹3,820
P/E
28.4
ROE
47%
3
Scroll to "Profit & Loss" table for revenue history
The P&L table shows 10+ years of Sales, Operating Profit, and Net Profit. Look at the Sales row across years to assess revenue trend.
Profit & Loss (₹ Cr)
| Mar 2020 | Mar 2021 | Mar 2022 | Mar 2023 | Mar 2024 |
|---|---|---|---|---|
| Sales: 1,56,949 | 1,64,177 | 1,91,754 | 2,25,458 | 2,40,893 |
| Net Profit: 32,340 | 33,388 | 38,327 | 42,303 | 46,099 |
Sales row (highlighted) = Revenue. Growing from ₹1.57L Cr → ₹2.41L Cr over 5 years = consistent growth
4
Check "Compounded Sales Growth" — pre-calculated CAGR
Screener calculates CAGR automatically. The "Compounded Sales Growth" box shows 10Y, 5Y, 3Y, and TTM growth in one place — no spreadsheet needed.
Compounded Sales Growth
| 10 Years | 10% |
| 5 Years | 12% |
| 3 Years | 14% |
| TTM | 6% |
1
Go to screener.in/screen/new
Click "Screen" in the nav or visit the URL directly. This is Screener's stock screener — free, no login needed for basic filters, runs across all 5,000+ stocks instantly.
2
Type your filter conditions — one per line
Screener uses plain English-style queries. Here is a starter filter combining Stage 1 through 4 KPIs:
Market Capitalization > 2000
Sales growth 5Years > 12
Return on equity > 15
Return on capital employed > 15
Debt to equity < 1
Current ratio > 1.5
Price to Earning < 40
Promoter holding > 50
Field names are case-sensitive. Use Screener's auto-suggest dropdown to pick the exact field name — it appears as you type.
3
Click "Run this Query" — results appear instantly
A sortable table of matching stocks appears. You can click any column header to sort. Click a company name to dive into its full Screener profile.
Results — 47 stocks found
| Name | Mkt Cap | Sales 5Y | ROE |
|---|---|---|---|
| Bajaj Finance | 4.8L Cr | 24% | 22% |
| Pidilite Industries | 1.3L Cr | 15% | 28% |
| Astral Ltd | 42,000 Cr | 18% | 19% |
4
Save your screen with a free account
Create a free Screener account and save this query. Screener re-runs it automatically and can notify you when new stocks enter or existing ones drop out of your filter — a great watchlist tool.
Every KPI from all 5 stages is available directly on Screener. Here's exactly where to find each one on a stock's company page.
Top summary bar (visible immediately on page load)
Market CapTop metrics row
P/E ratioTop metrics row
Book Value (P/B)Top metrics row
ROETop metrics row
ROCETop metrics row
Compounded growth boxes (right side of page)
Sales growth 3Y / 5Y / 10YCompounded Sales Growth
Profit growth 3Y / 5YCompounded Profit Growth
EPS growthEPS CAGR box
Profit & Loss table (scroll down)
Annual revenue (Sales row)P&L → Sales
Operating profit marginP&L → OPM%
Net profit (PAT)P&L → Net Profit
EPSP&L → EPS
Balance Sheet table
Debt-to-equityBalance Sheet → Borrowings ÷ Equity
Current ratioBalance Sheet section
Cash Flow table
Free cash flowCash Flow → Operating CF − Capex
Shareholding section (updated quarterly)
Promoter holding %Shareholding → Promoters
FII/DII holding trendShareholding → FII / DII
Tools Best free tools for Indian investors
Screener.in
Best for all fundamentals, custom screeners, and 10-year historical data. Free.
Tickertape.in
Good pre-built screeners and stock scores for beginners. Visual and beginner-friendly.
Moneycontrol
Best for promoter holding history, FII/DII quarterly data, and news flow.
NSE / BSE
Official exchange websites for filing data, annual reports, and shareholding patterns.
Key takeaway for new investors
These KPI filters do not guarantee winners — they narrow your universe from 5,000+ stocks to 5–10 worth deep-diving into. After a stock passes all 5 stages, you still need to read the annual report, understand the business model, evaluate management quality, and check competitive positioning before investing. The funnel handles the quantitative filter; your judgment handles the qualitative one. Always invest within your risk tolerance, start with small positions as you learn, and consider consulting a SEBI-registered advisor before making significant investment decisions.
KPI benchmarks in this guide are general guidelines based on common fundamental analysis frameworks used by Indian institutional investors. Sector-specific benchmarks vary significantly — banking, NBFC, infrastructure, and commodity stocks require adjusted thresholds. This article is for educational purposes only and does not constitute investment advice. Data should be verified on official sources before any investment decision. Not a substitute for professional financial advice.
Comments
Post a Comment