dmart fundamentals data.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	Particulars	Mar-20	Mar-21	Mar-22	Mar-23	Mar-24	Mar-25	Mar-26	Mar-27	Mar-28	Mar-29	Mar-30
2	P&L Statement
3	Sales	24870.2	24143.06	30976.27	42839.56
4	Sales Growth 3 yr(%)	27.8	17.1	13.6	19.87
5	Sales Growth 5 yr(%)				25
6	COGS	22742	22398	28474	39203
7	Material Cost(%)	85%	85%	85%	85%
8	Manufacturing Cost(%)	3%	4%	3%	0%
9	Employee Cost(%)	2%	2%	2%	2%
10	Other Cost(%)	1%	1%	1%	1%
11	EBITDA	2128.2	1745.06	2502.27	3636.56
12	OPM(%)	8.56	7.23	8.08	8.49
13	Interest Cost	69	42.00	54.00	67
14	Depreciation	374	414	498	639
15	Profit	1301.08	1099.49	1492.55	2378.51
16	Profit Growth 3 yr (%)	39.62	10.8	18.2	22.22
17	Profit Growth 5 yr (%)				23
18	Cash Flow Statement
19	CFO	1280.14	1375.14	1372.35	2630.27
20	CFO/PAT (5 yrs. avg.)		1.01	0.99	0.99
21	FCF	-628.86	-754.86	-1486.65	211.27
22	FCF (3 Yrs Avg.)		-661.75	-956.79	-676.75
23	Balance Sheet
24	Borrowings	333	393	647	643
25	Equity capital	11080	12184	13678	16078
26	Other Liabilities	663	1079	1146	1385
27	Total Liabilities	12076	13656	15471	18106
28	Fixed Assets	5948	7009	9260	11340
29	CWIP	364	1019	1129	829
30	Other Assets	5656	4182	4783	4529
31	Cash & Cash Equivalents	108	1446	299	1408
32	Total Assets	12076	13656	15471	18106
33	Balance Sheet Ratios
34	D/E	0.03	0.03	0.05	0.04
35	Int. Cov. Ratio	25.4	31.6	37.1	36.1
36	ROE(%)	12	9	11	15
37	ROCE(%)	20	13	16	20
38	Current Ratio		3	2.95	2.83
39	Quick Ratio	3.3	3.2	3.06	2.83
40	Inv. Turnover Ratio	14.2	9.8	13.9	13.59
41	Asset Turnover Ratio	2.06	1.77	2.00	2.37
42	Creditor Days	8	10	8	8
43	Debtor Days	0.29	0.66	0.59	0.73
44	Working Capital Days	23	24	24	23
45	Cash Cycle Days	26	30	31	26
46	Trade Payables	8	10	8	8
47	Trade Recievables	433	578	589	754
48	Cont. Liab.		6.11	28.48	28.48
49	CapEx	1909	2130	2859	2419
50	Other Imp. Metrics
51	Dividend Yield	0	0	0	0
52	Promoter Holding	74.9	74.9	74.9	74.9
53	Pledge%	0	0	0	0
54	DII Holding(%)	5.98	6.58	6.7	7.49
55	FII holding(%)	10.42	10.17	8.83	8.17
56	Institutional Holding As a % of Free Float M.Cap.	57.56%	66.73	61.87	62.39
57	Market Capitalisation(cr)*	142308	186035	278239	224049
58	Share Price	2187	2859	4276	3443
59	Share Price Growth YOY(%)	48.78%	30.73%	49.56%	-19.48%
60	Valuation Ratios
61	P/E*	123	152	102	92
62	P/Cash Flow*	111	135	203	178
63	Business Specific Metrics
64	Number of Stores	214	234	284	324
65	Revenue Per Sq. ft. Area	32879	27306	27454
66	Like For Like Growth (%)	10.1	-13.9	16.7
67	Number of Bill Cuts(crores)	20.1	15.2	18.1
68
69	* - All datas captured on 2nd march every year
70	**- all financial statements numbers are in crore unless stated otherwise
71			capex=change in(fixed assets+WIP)+depreciation
72
73		fcf=cfo-capex
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100