Diversified Retail


1		MARKET			TRAIL_INCOME					BALANCESHEET									CASHFLOW
2	DATA	Company	Price	Marketcap	STORE	Sales	Profit	T_EPS	FV	Equity	TOTAL EQ	DEBT	LEASE	CUR.ASSETS	CUR.LIABILITIES	ASSETS	LIABILITIES	TRADE REC	CFO	CFI	CFF	TOTAL	PPE
3		DMART	4027	261855	387	59358	2707	41.61	10	651	20777	0	820	6392	2212	24320	2893	154	2463	-2185	-259	19	3423
4		PREVIOUS YEAR_24	4083	265803	365	50788	2535	38.99	10	651	18047	0	592	6202	1979	21777	2480	166	2745	-2468	-148	129	2731
5		GROWTH	-1%	-1%	22	17%	7%	7%	0%	0%	15%	#DIV/0!	39%	3%	12%	12%	17%	-7%	-10%	-189%	-275%	-115%	25%
6
7		GROWTH		LIQUIDITY			SOLVENCY			PROFITABILITY			VALUATIONS					CASHFOW
8	RATIO	SALES GROWTH	LFL GR	P-MARGIN	CUR.RATIO	TRADE CYC	DEBT2EQUITY	DEBTRATIO	ICR	ROE	ROPE	ROA	PE	YIELD	BOOKVALUE	PBV	PEG	OCFR	CFD	FCF (INC R)
9		16%	5%	4.7%	2.9	0.9	0%	12%	37	13%	4.2	11%	96.8	1.0%	319	12.6	16.2	251.0	1643	-960.0
10
11	Actual	STORE	YEAR	SALES	INTEREST	NETPROFIT	EQUITY	OTHER EQ	EPS	NPM%	HIGH PRICE	LOW PRICE	HIGHPE	LOWPE	AV PE	BookValue	PBV
12		2	FY_2002
13		57	FY_2012	2209	-26	61	534		1.2	2.8%
14			FY_2013	3341	-43	94	544		1.7	2.8%
15			FY_2014	4687	-56	161	547	404	3.0	3.4%						17
16			FY_2015	6439	-72	212	562	631	3.9	3.3%						21
17			FY_2016	8588	-91	321	562	959	5.7	3.7%						27
18		135	FY_2017	11881	-122	483	624	3218	8.6	4.1%						62
19	IPO	155	FY_2018	15009	-60	785	624	4045	12.6	5.2%	1387	628	110	50	80	75	13
20		176	FY_2019	20005	-47	903	624	4963	14.5	4.5%	1699	1126	117	78	98	90	16
21		214	FY_2020	24870	-69	1,301	648	10432	20.7	5.2%	2560	1226	124	59	91	171	11
22		236	FY_2021	24143	-42	1,033	648	11536	17.0	4.3%	3330	1955	196	115	156	188	14
23		284	FY_2022	30976	-54	1,487	648	13030	23.0	4.8%	5900	2676	256	116	186	211	20
24		324	FY_2023	42839	-67	2373	648	15430	36.7	5.5%	4609	3186	126	87	106	248	16
25		365	FY_2024	50788	-58	2535	651	18047	39.0	5.0%	4560	3352	117	86	101	287	14
26		415	FY_2025	59358	-69	2707	651	20777	41.3	4.6%	5485	3340	133	81	107	329	13
27		424	TRAIL FY_2026	61649	-68	2706	651	20777	41.6	4.4%	4557	3761	110	90	100	329	13			RESULT	Q1_FY_26	Q1_FY_25	GROWTH		RESULT	Q4_FY_25	Q4_FY_24	GROWTH	RESULT	FY_25	FY_24	GROWTH
28																				LFL GROWTH	7.10%	9.10%	-22%		LFL GROWTH				LFL GROWTH	8.40%	9.90%	-15%
29																				REVENUE	16360	14069	16%		REVENUE	14872	12726	17%	REVENUE	59358	50789	17%
30	GROWTH	STORE	YEAR	SALES	INTEREST	NETPROFIT	EQUITY	EPS	NPM%	HIGH PRICE	LOW PRICE	HIGHPE	LOWPE	AV PE						COST	15322	13057	17%		COST	14177	12001	18%	COST	55809	47474	18%
31		15%	10 Year	25%	0%	29%	1%	27%	4.4%	19%	23%	125	83	104						FINANCE	29	16	81%		FINANCE	19	13	46%	FINANCE	69	58	19%
32		14%	5 Year	19%	0%	16%	0%	15%	4.9%	16%	22%	129	86	108						PROFIT	773	774	0%		PROFIT	551	563	-2%	PROFIT	2707	2536	7%
33		14%	CYear	17%	19%	7%	0%	6%	4.6%	20%	0%	117	86	101						EPS	11.88	11.89	0%		EPS	8.47	8.66	-2%	EPS	41.61	38.99	7%
34																				ICR	37	64	-43%		ICR	38	57	-34%	ICR	52	58	-10%
35	Est Growth	STORE	Year	Revenue	Net Profit	MARGIN	EPS		Current Trend	H1_FY_25	9M_FY_25	FY_25	Q1_Y_26	EST_FY_26						MARGIN	4.7%	5.5%	-0.8%		MARGIN	3.7%	4.4%	-0.7%	MARGIN	4.6%	5.0%	-0.4%
36		10%	LongTerm	20%	20%	4.6%	20.0%		Sales	16%	17%	17%	16%	17%						STORES			0		STORES	415	365	50	STORES	415	365	50
37		14%	CYear	17%	20%	4.7%	20%		Profit	12%	9%	7%	0%	15%
38									MARGIN	5.0%	4.8%	4.6%	4.7%	4.7%						MAJOR COST	Q1_FY_26	Q1_FY_25	SHARE	GROWTH
39	Estimate	STORE	Year	Revenue	Net Profit	EPS	FairValue													STOCKINTRADE	13732	11974	90%	15%
40		473	FY_2026	69152	3250	49.6	3,718		TRAIL-EPS	Q2_FY25	Q3_FY25	Q4_FY25	Q1_FY26	TRAIL_EPS						INVENTORIES	123	-98	1%	-226%
41		693	FY_2030	143394	6621	101	7,574		TRAIL-EPS	10.14	11.12	8.47	11.88	41.61						EMPLOYEE COST	347	266	2%	30%
42		1116	FY_2035	288416	13318	203	12,188													FINANCE	29	16	0%	81%
43									EPS_25	T_EPS	F_EPS_26	F_PEG								D&A	232	193	2%	20%
44									39.0	41.61	49.6	16								OTHER COST	859	706	6%	22%
45									PE_24	TRAIL-PE	F_PE_25
46									105	97	81									TOTAL	15322	13057	100%	17%
47
48									SHP	SHP-9M	2022
49										PROMOTER	75%
50										MF, AIF,FI, INSURANCE	7%		£47,454.39
51										FII	8.8%
52										RETAIL	8.7%
53
54
55
56
57
58
59
60
61