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	4241	275613	387	59357	2706	41.62	10	651	20777	0	820	6392	2212	24320	2893	154	2463	-2185	-259	19	3423
4		PREVIOUS YEAR_24	4525	294578	365	50788	2535	38.99	10	651	18047	0	592	6202	1979	21777	2480	166	2745	-2468	-148	129	2731
5		GROWTH	-6%	-6%	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		17%	5%	4.6%	2.9	0.9	0%	12%	52	13%	4.2	11%	101.9	1.0%	319	13.3	19.6	251.0	1643	-960.0
10
11	Actual	STORE	YEAR	SALES	INTEREST	NETPROFIT	EQUITY	EPS	NPM%	HIGH PRICE	LOW PRICE	HIGHPE	LOWPE	AV PE
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	3.0	3.4%
16			FY_2015	6439	-72	212	562	3.9	3.3%
17			FY_2016	8588	-91	321	562	5.7	3.7%
18		135	FY_2017	11881	-122	483	624	8.6	4.1%
19	IPO	155	FY_2018	15009	-60	785	624	12.6	5.2%	1387	628	110	50	80
20		176	FY_2019	20005	-47	903	624	14.5	4.5%	1699	1126	117	78	98
21		214	FY_2020	24870	-69	1,301	648	20.7	5.2%	2560	1226	124	59	91
22		236	FY_2021	24143	-42	1,033	648	17.0	4.3%	3330	1955	196	115	156
23		284	FY_2022	30976	-54	1,487	648	23.0	4.8%	5900	2676	256	116	186
24		324	FY_2023	42839	-67	2373	648	36.7	5.5%	4609	3186	126	87	106
25		365	FY_2024	50788	-58	2535	651	39.0	5.0%	4560	3352	117	86	101
26		415	FY_2025	59357	-69	2706	651	41.3	4.6%	5485	3340	133	81	107
27																RESULT	FY_25	FY_24	GROWTH		RESULT	Q4_FY_25	Q4_FY_24	GROWTH	RESULT	9M_FY_25	H9MFY_24	GROWTH
28	GROWTH	STORE	YEAR	SALES	INTEREST	NETPROFIT	EQUITY	EPS	NPM%	HIGH PRICE	LOW PRICE	HIGHPE	LOWPE	AV PE		LFL GROWTH	8.40%	9.90%	-15%		LFL GROWTH				LFL GROWTH	8.30%	7.70%	0.6%
29		15%	10 Year	25%	0%	29%	1%	27%	4.4%	19%	23%	125	83	104		REVENUE	59358	50789	17%		REVENUE	14872	12726	17%	REVENUE	44486	38062	17%
30		14%	5 Year	19%	0%	16%	0%	15%	4.9%	16%	22%	129	86	108		COST	55809	47474	18%		COST	14177	12001	18%	COST	41633	35472	17%
31		14%	CYear	17%	19%	7%	0%	6%	4.6%	20%	0%	117	86	101		FINANCE	69	58	19%		FINANCE	19	13	46%	FINANCE	50	45	11%
32																PROFIT	2707	2536	7%		PROFIT	551	563	-2%	PROFIT	2156	1972	9%
33	Est Growth	STORE	Year	Revenue	Net Profit	MARGIN	EPS		Current Trend	Q1_FY_25	H1_FY_25	9M_FY_25	FY_25	EST_FY_26		EPS	41.61	38.99	7%		EPS	8.47	8.66	-2%	EPS	33.15	30.34	9%
34		10%	LongTerm	20%	20%	4.6%	20.0%		Sales	19%	16%	17%	17%	17%		ICR	52	58	-10%		ICR	38	57	-34%	ICR	58	59	-1%
35		14%	CYear	17%	5%	4.1%	5%		Profit	17%	12%	9%	7%	5%		MARGIN	4.6%	5.0%	-0.4%		MARGIN	3.7%	4.4%	-0.7%	MARGIN	4.8%	5.2%	-0.3%
36									MARGIN	5.5%	5.0%	4.8%	4.6%	4.1%		STORES	415	365	50		STORES	415	365	50	STORES	387	365	22
37	Estimate	STORE	Year	Revenue	Net Profit	EPS	FairValue
38		473	FY_2026	69448	2847	43.4	3,253		TRAIL-EPS	Q1_FY25	Q2_FY25	Q3_FY25	Q4_FY25	TRAIL_EPS		MAJOR COST	FY_25	FY_24	SHARE	GROWTH
39		693	FY_2030	144007	6649	101	7,596		TRAIL-EPS	11.89	10.14	11.12	8.47	41.62		STOCKINTRADE	51668	43958	93%	18%
40		1116	FY_2035	289649	13373	204	12,223									INVENTORIES	-1,117	-684	-2%	63%
41									EPS_24	T_EPS	F_EPS_25	F_PEG				EMPLOYEE COST	1166	906	2%	29%
42									39.0	41.62	43.4	20				FINANCE	69	58	0%	19%
43									PE_24	TRAIL-PE	F_PE_25					D&A	870	731	2%	19%
44									116	102	98					OTHER COST	3153	2504	6%	26%
45
46									SHP	SHP-9M	2022					TOTAL	55809	47473	100%	18%
47										PROMOTER	75%
48										MF, AIF,FI, INSURANCE	7%		£47,454.39
49										FII	8.8%
50										RETAIL	8.7%
51
52
53
54
55
56
57
58
59
60
61