Profitability Analysis of FMCG Sector in India Using Power BI: A Comparative Study (2021–2025)
Profitability Analysis of FMCG Sector in India Using Power BI: A Comparative Study (2021–2025)
Mr. Dharani Manikandan S
SAKTHI INSTITUTE OF INFORMATION AND MANAGEMENT STUDIES, POLLACHI
Dr R. Sharmilla, Professor
SAKTHI INSTITUTE OF INFORMATION AND MANAGEMENT STUDIES, POLLACHI
DR. R. Kavitha, ASSOCIATE PROFESSOR
SAKTHI INSTITUTE OF INFORMATION AND MANAGEMENT STUDIES, POLLACHI
Abstract
This study analyses the profitability performance of ten selected Fast-Moving Consumer Goods (FMCG) companies in India over a five-year period from 2021 to 2025. The research employs a quantitative approach using secondary financial data sourced from annual reports, financial statements, and stock exchange databases. Key profitability indicators — Net Profit Margin (NPM), Gross Profit Margin (GPM), Operating Profit Margin (OPM), Return on Assets (ROA), and Return on Equity (ROE) — are calculated and analyzed. Microsoft Power BI is used to create interactive dashboards for visualizing and comparing financial trends. The findings reveal that Procter & Gamble Hygiene & Health Care, Nestle India, and ITC Limited consistently outperformed peers, while LT Foods and Tata Consumer Products recorded comparatively weaker profitability ratios. The study concludes that effective cost management, operational efficiency, andstrategic financial planningare critical for sustainingprofitability in the competitive FMCG sector.
Keywords: FMCG, Profitability Analysis, Power BI, Financial Ratios, India, NPM, GPM, ROA, ROE, OPM