📊 Business KPIs Deep Dive

SECTION 1

The Problem With Financial Statements Alone

Every financial analysis framework starts with the P&L: revenue, gross margin, EBITDA, PAT. Then the balance sheet: debt, equity, working capital. Then the ratios: ROE, ROCE, P/E, EV/EBITDA. These are the outcomes — the final scoreboard of what happened. But they don't explain why it happened, or whether it's sustainable.

Store counts, same-store growth rates, cost per conversion per user (CPCU), device reach, bill cuts per store, studded jewellery mix percentages — these are the operational drivers. They're the inputs that produce the financial outputs. They appear in concall presentations, investor day materials, and — critically — in the Screener.in Operational Insights section. But they appear in no financial statement.

The Business KPIs Deep Dive template is the first Finmagine AI Advisor template designed specifically to read this operational layer. Instead of asking "what did the P&L show?", it asks: "what operational forces drove that P&L, and are they still intact?"

What Financials Tell You	What KPIs Tell You
Revenue grew 17%	Stores grew 14%, revenue/store grew 3%
OPM compressed 1%	LFL growth −4% offset partially by mix improvement
ROCE declined from 22% to 18%	New stores ramping slower than mature ones (asset turnover ↓)
Cash conversion improved	Debtor days fell from 79 to 48 — better client quality mix
Revenue per employee flat	Utilisation rate rose 3pp; headcount grew but billable hours rose faster
PAT growth exceeded revenue growth	CPCU rose 12% while conversion volume also rose 19% — pricing + volume expanding simultaneously

This is why the Business KPIs Deep Dive template exists as a dedicated template — not as a section inside Comprehensive Analysis or Deep Research. The operational layer deserves its own systematic investigation. When you have 10 years of KPI data in the Screener.in Insights section, a dedicated 7-part framework extracts far more intelligence than a paragraph buried inside a longer analysis.

SECTION 2

How the Template Works — 4 Steps

The Business KPIs Deep Dive template is designed for zero manual effort. You don't need to copy-paste KPI tables or manually extract data from Screener.in. The extension does all of that automatically.

SECTION 3

The 7-Part Output — What You Get

The Business KPIs Deep Dive prompt instructs ChatGPT to produce a structured 7-part analysis. Each part has a specific mandate. The output is not a free-form narrative — it's a structured investigation with tables, specific KPI citations, and explicit verdicts.

KPI Table — The Operational Scorecard

The first output is the KPI data itself, rendered as a clean markdown table with an added Trend column. The template asks ChatGPT to extend the Screener.in data with additional KPIs accessible from concall transcripts where available — guidance numbers, management-cited metrics, or ratios computable from the provided data. For most companies, Part 1 will be the Screener.in Insights table with annotations.

The Trend column uses four simple signals: ↑ Accelerating, → Stable, ↓ Decelerating, and a warning flag for reversals. This immediately shows which KPIs are the company's current strengths and which are the emerging concerns.

Growth Trajectory — The Single Most Important Inflection

Part 2 identifies the single most important inflecting KPI across the full time series — positive or negative. This is not a list of all trends; it's a forced prioritisation. The GPT must pick one KPI whose trajectory most determines whether the investment thesis holds.

• Affle example: Conversions accelerating fastest in FY25 — largest absolute annual addition. The CPCU is rising simultaneously, meaning volume growth is not diluting price. This combination is the most important positive signal.
• DMart example: LFL (Like-For-Like) growth decelerating steadily for 5 years — from a post-COVID spike of 16.7% back to 8.4%. This is structural, not cyclical. This is the most important negative signal.
• Titan example: Store count growth accelerating (14% CAGR over 10 years), but revenue/sq ft growing at only 7% — new stores are smaller and ramping more slowly than legacy stores.

Quality vs Quantity — The Cross-KPI Check

This is the most analytically sophisticated part of the template. Part 3 cross-checks volume growth metrics against unit economics metrics. A company can report impressive headline growth — stores opened, conversions delivered, clients added — while unit economics deteriorate.

The Quality vs Quantity framework asks: for every unit of growth, is the business generating more or less value per unit?

• Affle (Quality Growth): Conversion volume UP and CPCU UP simultaneously. The platform is growing AND charging more per conversion. This is the rarest and most valuable signal — pricing power alongside volume expansion.
• DMart (Quantity Growth): Stores UP but LFL DOWN. The store network is expanding but same-store performance is weakening. The growth is real but it's becoming expansion-dependent rather than same-store-driven.
• Titan (Quality Expansion): Store count UP and revenue/sq ft UP. New stores are generating more revenue per unit area than older stores — confirming the brand pull is strengthening even in newer markets.

Management Execution — Guidance vs Actuals

Part 4 produces a Guidance vs Actuals table — matching specific KPI targets management stated in concall transcripts against what was actually delivered. This is the most direct measure of management credibility available from public sources.

This part works best when concall transcripts are accessible to the GPT. For companies with well-structured investor relations communications (like Affle, HDFC Bank, Infosys), the table can include 4–6 specific guidance commitments. For companies with minimal public KPI guidance (like DMart, which deliberately avoids SSSG targets), Part 4 will note the absence of guidance and assess delivery on stated qualitative priorities instead.

Red Flags — KPI Combination Signals

Part 5 identifies 2–3 specific KPI combination signals that indicate hidden risk. The format is: "KPI A + KPI B → Risk" — explaining what the combination implies and why a single KPI in isolation might not surface the concern.

KPI combinations are more powerful than individual KPI readings because operational risk often appears at the intersection of two trends. Inventory rising is not by itself a red flag (it could be demand-led). But inventory rising alongside debtor days rising alongside LFL growth falling is a working capital stress signal that the P&L may not yet show.

Hidden Strengths — Invisible in the P&L

Part 6 is often the most valuable section of the entire analysis. Hidden Strengths identifies 2–3 KPI signals that reveal quality invisible in the consolidated income statement. These are strengths that a pure financial statement reader would miss entirely.

Examples from real analyses:

• Affle Hidden Strength: Debtor days compressing from 79 to 48 days while direct customer revenue mix rose from 68% to 76%. Better-quality clients are paying faster — a sign of platform stickiness and client mix improvement invisible in revenue or margin lines.
• DMart Hidden Strength: Bill Cuts growing faster than store count. In FY25: 415 stores, 35.3 Cr bill cuts = approximately 8.5 lakh cuts/store/year vs 6.5 lakh in FY21. Footfall intensity per store rose 31% even as the network expanded 77% — pure brand pull, not just location proximity.
• Titan Hidden Strength: Studded jewellery mix holding at 30% and rising slowly. Studded carries significantly higher margins than gold-weight-based pieces. The mix improvement is a margin expansion lever not yet visible in consolidated OPM due to gold price volatility masking it.

Peer Benchmarking + Five-Parameter Score

Part 7 delivers two outputs. First, a peer benchmarking assessment — how does this company's KPI trajectory compare to its 2–3 closest listed peers? For Affle, peers are InMobi-adjacent digital ad businesses. For DMart, peers are Spencer's, V-Mart, and Reliance Retail (where listed). For Titan, peers are Kalyan Jewellers and Senco Gold.

Second, the Five-Parameter Score:

Parameter	Weight	What It Assesses
Financial Health	25%	Balance sheet quality, cash generation, debt trends, working capital
Growth Prospects	25%	KPI growth trajectory, runway, addressable market expansion
Competitive Position	20%	Moat signals from KPIs — pricing power, market share, switching costs
Management Quality	15%	Guidance delivery, capital allocation, operational discipline
Valuation	15%	Current market price relative to KPI quality and growth trajectory
Composite Score	100%	Investment classification: Growth Compounder / Core Compounder / Turnaround / Avoid

Each parameter is scored from 2 to 10, with sub-components and rationale. The composite weighted score determines the investment classification: Growth Compounder (ACCELERATING KPIs + pricing power), Core Compounder (high quality but expensive), Turnaround (improving from a low base), or Avoid (deteriorating across multiple dimensions).

SECTION 4

Case Study — DMart (Avenue Supermarts): The PLATEAUING Verdict

DMart is one of the most widely held large-cap retail stocks in India. Its financial metrics look strong: high ROCE, consistent revenue growth, fortress-like balance sheet. But the Business KPIs template tells a more nuanced story. Here is the actual KPI table from the Screener.in Insights section for Avenue Supermarts as of March 2026.

KPI	FY21	FY22	FY23	FY24	FY25	Trend
Like-For-Like Growth %	−13.1	16.7	14.8	9.9	8.4	↓ Decelerating
Store Count	234	284	324	365	415	↑ Consistent
Retail Area (Mn sq ft)	8.77	11.51	13.20	15.20	17.20	↑ Strong
Revenue / sq ft (₹)	27,306	27,454	31,096	32,941	33,896	↑ Improving
Total Bill Cuts (Cr)	15.2	18.1	25.8	30.3	35.3	↑ Accelerating
Fixed Asset Turnover (x)	3.2	3.6	3.7	3.6	3.4	→ Declining slowly
DMart Ready Cities	—	12	22	23	19	↓ Retreating

What ChatGPT Found: Key Insights from the Analysis

Red Flag: LFL ↓ + Store Count ↑ = Growth Shifting Character

The most important red flag combination is the simultaneous deceleration of like-for-like growth alongside accelerating store additions. When LFL was 14.8% (FY23), DMart needed fewer stores to sustain revenue growth momentum. With LFL at 8.4% (FY25), the company needs to open more stores just to maintain the same headline revenue growth rate. The growth story is transitioning from a same-store compounder to an expansion-dependent story. This changes the risk profile materially — expansion-dependent growth is capital-intensive and carries execution risk.

Hidden Strength: Bill Cuts Growing Faster Than Store Count

The most valuable hidden strength is in the Bill Cut (footfall proxy) data. In FY21, 234 stores generated 15.2 Cr bill cuts — approximately 6.5 lakh cuts/store/year. In FY25, 415 stores generated 35.3 Cr bill cuts — approximately 8.5 lakh cuts/store/year. Footfall intensity per store rose 31% over four years while the store network expanded 77%. This is pure brand pull at work. Customers are visiting more frequently even at newer, less-established stores. This operational metric is completely invisible in the consolidated P&L but is one of the strongest indicators of brand stickiness in Indian retail.

DMart Ready Retreating: Structural or Strategic?

The DMart Ready city count peaked at 23 in FY24 and retreated to 19 in FY25. This is the most unusual data point in the table. Management has indicated that quick-commerce competition in tier-1 cities has pressured DMart Ready's economics. The retreat signals a conscious strategic pullback rather than an operational failure — but it does confirm that DMart's digital/delivery ambition has been recalibrated downward.

The Verdict: PLATEAUING (Not Failing)

ChatGPT's operational verdict was PLATEAUING — a specific classification that distinguishes this from a failing business. DMart's operational quality remains high (revenue/sq ft rising, bill cuts accelerating, fixed asset turnover declining slowly rather than sharply). But the nature of the growth is changing character: from same-store driven to expansion driven, from high-LFL to moderate-LFL, from a pure physical retail story to one where the digital question is unresolved.

Parameter	Score	Key Driver
Financial Health	9.0 / 10	Fortress balance sheet, zero debt, strong FCF generation
Growth Prospects	7.5 / 10	Store expansion intact, but LFL trajectory concerning
Competitive Position	9.0 / 10	Unmatched EDLC/EDLP model, bill cut intensity confirms brand pull
Management Quality	8.5 / 10	Capital disciplined, no leverage, DMart Ready exit shows pragmatism
Valuation	4.5 / 10	P/E 88x prices in a compounder that is now an expansion story
Composite Score	7.86 / 10	Core Compounder — high quality, expensive, changing growth character

SECTION 5

Which AI Platform to Use — And Why It Matters

Not all AI platforms perform equally on the Business KPIs Deep Dive template. Testing across three case studies (Affle, Titan, DMart) surfaced significant differences. The template works best on one platform and fails on another for a specific technical reason.

Platform	For Business KPIs	Why
ChatGPT (Finmagine Custom GPT)	✓ Strongly Recommended	Uses provided KPI data directly, produces clean structured tables, correct peer selection based on Finmagine methodology
Claude	✗ Not Recommended	Tries to fetch every BSE PDF document referenced in the prompt, returns 403 errors repeatedly, often fails to complete the analysis
Gemini Deep Research	⚠ Overkill	Built for live web research; the KPI data is already in the prompt — web browsing adds noise and slows the output
Perplexity	⚠ Acceptable	Produces less structured output; adequate for quick reads but misses the 7-part structured format

Why the Finmagine Custom GPT Specifically?

The Finmagine Custom GPT has the Finmagine investment methodology pre-loaded. It knows the Five-Parameter framework, the sector benchmarks for Indian stocks (what constitutes strong LFL for a retailer, what CPCU range is normal for ad-tech, what GNPA threshold matters for banks), and the exact output format. This produces more consistent, methodologically aligned output than a fresh ChatGPT conversation where you'd need to re-explain the framework each time.

The Custom GPT also handles the Indian context better: ₹ (Rupee) formatting, NSE/BSE stock codes, sector-appropriate peer selection, and awareness of India-specific regulatory and market dynamics.

SECTION 6

When to Use Business KPIs vs Other Templates

The Business KPIs Deep Dive template is not a replacement for Comprehensive Analysis or Deep Research. It's a complement — filling a specific gap in the operational intelligence layer. Choosing the right template for the right question is as important as the analysis itself.

Situation	Best Template
First look at a company — full financial picture	Comprehensive Analysis
Checking valuation vs peers across multiple metrics	Peer Comparison
Governance red flags, promoter quality, accounting concerns	Forensic Governance
Latest quarter analysis, sequential trends	Quarterly Deep-Dive
Sector thesis research — tailwinds and headwinds	Sector & Theme Analysis
Specific concall question or management quote verification	Ask Anything
Deep document reading — annual report, concall PDFs	Deep Research (India)
Understanding operational drivers behind the financials	Business KPIs Deep Dive ←
Checking whether growth is quality (pricing power) or just quantity	Business KPIs Deep Dive ←
Verifying whether management delivered on KPI guidance	Business KPIs Deep Dive ←
Finding hidden strengths invisible in the P&L	Business KPIs Deep Dive ←

A Note on When Business KPIs Won't Help

The template is only useful when the company has an Operational Insights section on Screener.in with meaningful data. Many Indian companies — particularly in banking, pharma, and commodity manufacturing — have sparse or absent Insights data on Screener.in. For these companies, the template will produce limited output. The richest data is available for: consumer retail, ad-tech and digital platforms, IT services, consumer durables, and select FMCG companies that report operational metrics in investor presentations.

SECTION 7

Sector-Specific KPI Guide — What to Expect

Not all sectors have equally rich operational KPI data on Screener.in. Understanding what to expect by sector helps you interpret whether a sparse KPI table reflects a limitation of the data source or a genuine absence of operational transparency from the company.

Sector	Typical KPIs in Screener Insights	Data Richness
Retail / Consumer	Store Count, SSSG %, Revenue / sq ft, Retail Area, Bill Cuts, DMart Ready Cities	★★★★★ Very Rich
Ad-Tech / Digital	CPCU Rate, Conversion Volume, Device Reach, Direct Client %, EFGH Revenue %, Patents Filed / Granted	★★★★★ Very Rich
IT Services	Attrition %, Headcount, $100M+ Clients, Deal TCV, Utilisation %, Offshore / Onshore Mix	★★★★ Rich
Banking / NBFC	Branch Count, CASA Ratio, Active Customers, Cost-to-Income, AUM, Gross NPA	★★★ Moderate
Jewellery / Consumer Durables	Store Count, Revenue / sq ft, Studded Mix %, Inventory Days, Franchisee Count	★★★ Moderate
Pharma / Specialty Chem	ANDA Pipeline, Field Force, Market Share %, R&D % of Revenue, API Volume	★★ Sparse
Manufacturing / Industrials	Capacity Utilisation %, Volume (tonnes), Realisation / Unit, Export %	★★ Sparse
Commodities / Metals	Production Volume, Realisation / tonne, EBITDA / tonne	★ Very Sparse

Reading the Signals by Sector

Different sectors have different KPI benchmarks. Knowing what's normal for the sector is essential for interpreting the GPT's output correctly:

• Retail LFL: 10%+ is excellent for a mature network; 4–9% is normal; below 4% in a non-COVID year signals stagnation
• Ad-Tech CPCU: Rising CPCU alongside rising volume is exceptional (Affle). Flat CPCU with rising volume is normal. Falling CPCU with rising volume may signal commoditisation pressure.
• IT Services Attrition: Below 15% is healthy; 20%+ signals culture or compensation issues; the trend direction matters more than the absolute level
• Banking CASA: Above 40% is strong; below 30% means higher cost of funds; declining CASA over 3+ years is a structural risk signal
• Pharma ANDA Pipeline: A growing ANDA filing pipeline signals future US revenue; a shrinking or stagnant pipeline signals US generic revenue risk

SECTION 8

Installing the Extension — 2 Minutes

The Business KPIs Deep Dive template requires the Finmagine AI Advisor Chrome Extension (v2.11.0 or later). Installation takes under 2 minutes.

1. Open Google Chrome and navigate to the Chrome Web Store
2. Search for "Finmagine AI Advisor" and click Install
3. Open any company page on Screener.in (e.g., Screener.in/company/DMART/)
4. Scroll down to the Operational Insights section below the main financial tables
5. Wait 10 seconds — the extension fires its extraction logic at 6 seconds and the DB push completes within 10 seconds
6. Open the AI Advisor panel (click the Finmagine icon in your Chrome toolbar)
7. Select Business KPIs Deep Dive from the template list
8. Click Open ChatGPT — the prompt including your KPI data table is generated and opened
9. Paste the prompt into the Finmagine Custom GPT and receive your 7-part analysis