Three-Sector Ratio Analysis for Retail Investor Clients
Conducted a comparative ratio analysis across IT, banking/NBFC, and FMCG sectors and translated findings into plain-language client guidance.

Karan Agarwal
President at Mercuriusdoc





From their time as

Finance Intern
Motilal Oswal Financial Services Ltd • 2025 - 2025
Overview
Karan identified a recurring problem among Motilal Oswal's retail client base: many clients were uncertain about which sectors to invest in and which stocks to pick within those sectors. Working with his seniors, he designed a structured sector analysis to give those clients a clear, evidence-based answer.
The Story
Karan identified a recurring problem among Motilal Oswal's retail client base: many clients were uncertain about which sectors to invest in and which stocks to pick within those sectors. Working with his seniors, he designed a structured sector analysis to give those clients a clear, evidence-based answer.
He chose three sectors for the analysis: IT, banking/NBFC, and FMCG. For each sector, he selected listed companies and ran a ratio analysis covering three categories. Profitability ratios, including net profit margin, gross profit margin, and operating profit margin, to show whether companies were growing or compressing their margins. Solvency ratios, split between short-term measures like current ratio and quick ratio, and long-term measures like debt-to-equity and interest coverage ratio, to assess liquidity and debt repayment capacity. Efficiency ratios to evaluate how effectively companies were converting assets and capital into revenue.
Once the ratios were calculated, he ran a comparability analysis across companies within each sector, identifying which companies were performing better on each dimension and why. The output was not a spreadsheet handed to clients; it was a structured document written for a non-expert audience.
The document opened with an executive summary of each sector, covered sector scope and methodology, then presented the ratio analysis with plain-language commentary after each section. The commentary translated the numbers into clear investment implications: for example, explaining that IT companies in the analysis were effectively debt-free by conventional standards, had strong ROE, and showed faster asset turnover, while flagging the longer debtor cycles tied to their client mix.
Clients came away with a clear view of which sectors and stocks aligned with their investment horizon and risk appetite.
