Is Avenue Supermarts a good quality company?

Past 10 year's financial track record analysis by Moneyworks4me indicates that Avenue Supermarts Ltd is a good quality company .

Is Avenue Supermarts undervalued or overvalued?

The key valuation ratios of Avenue Supermarts Ltd's currently when compared to its past seem to suggest it is in the Undervalued zone .

What is Avenue Supermarts share price return in the past 10 years?

Data is not available for this company

Is Avenue Supermarts a good buy now?

The Price Trend analysis by MoneyWorks4Me indicates it is Weak which suggest that the price of Avenue Supermarts Ltd is likely to Fall in the short term. However, please check the rating on Quality and Valuation before investing.

Avenue Supermarts Ltd - Stock Valuation and Financial Performance

Name: Avenue Supermarts
Brand: Avenue Supermarts

BSE: 540376 | NSE: DMART | Retailing | Large Cap

Place order

Avenue Supermarts Share Price

₹3,787.25 -34.55 -0.90%
as on 18-Nov'24 15:50

10 Year X-Ray of Avenue Supermarts:

Analysis of Financial Track Record

Data adjusted to bonus, split, extra-ordinary income, rights issue and change in financial year end

Standalone Basis ^P Consolidated Basis ^P

Data adjusted to bonus, split, extra-ordinary income, rights issue and change in financial year end

Value Creation ⓘ

Value Creation Index Colour Code Guide ⓘ

	Mar'15	Mar'16	Mar'17	Mar'18	Mar'19	Mar'20	Mar'21	Mar'22	Mar'23	Mar'24	TTM
ROCE % ⓘ	21.4%	24.2%	21.7%	24.1%	26.3%	21.1%	13.5%	16.9%	21.6%	20.4%	-
Value Creation Index ⓘ	0.9	1.2	0.6	1.2	1.3	0.9	0.2	0.5	0.9	0.8	-
Growth Parameters ⓘ Growth Parameters Colour Code Guide ⓘ
Sales ⓘ	6,434	8,575	11,881	15,009	19,916	24,675	23,787	30,353	41,833	49,533	53,403
Sales YoY Gr.	-	33.3%	38.6%	26.3%	32.7%	23.9%	-3.6%	27.6%	37.8%	18.4%	-
Adj EPS ⓘ	3.7	5.6	7.7	12.4	14.8	20.6	17.9	24.9	39.3	41.1	44
YoY Gr.	-	50.8%	35.8%	61.4%	19.8%	39.2%	-13.2%	39.2%	57.8%	4.7%	-
BVPS (₹) ⓘ	21.3	26.9	61.5	74	89	171.5	189.5	214.4	253.9	295.8	319.8
Adj Net Profit ⓘ	210	317	478	771	924	1,336	1,160	1,614	2,548	2,677	2,864
Cash Flow from Ops. ⓘ	207	425	449	723	853	1,287	1,385	1,315	2,678	2,743	-
Debt/CF from Ops. ⓘ	4.4	2.8	3.3	0.6	0.8	0	0	0	0	0	-

CAGR ⓘ

CAGR Colour Code Guide ⓘ

	9 Years	5 Years	3 Years	1 Years
Sales ⓘ	25.5%	20%	27.7%	18.4%
Adj EPS ⓘ	30.5%	22.7%	32%	4.7%
BVPSⓘ	34%	27.2%	16%	16.5%
Share Price	-	15.7%	-9.3%	-0.6%

Key Financial Parameters ⓘ

Performance Ratio Colour Code Guide ⓘ

	Mar'15	Mar'16	Mar'17	Mar'18	Mar'19	Mar'20	Mar'21	Mar'22	Mar'23	Mar'24	TTM
Return on Equity % ⓘ	19.6	23.4	17.9	18.2	18.1	16	9.9	12.3	16.8	15	14.3
Op. Profit Mgn % ⓘ	7.1	7.7	8.1	8.9	8.3	8.6	7.3	8.3	8.8	8.3	8.2
Net Profit Mgn % ⓘ	3.3	3.7	4	5.1	4.6	5.4	4.9	5.3	6.1	5.4	5.4
Debt to Equity ⓘ	0.8	0.8	0.4	0.1	0.1	0	0	0	0	0	0
Working Cap Days ⓘ	33	31	29	29	29	51	68	48	35	34	22
Cash Conv. Cycle ⓘ	18	16	16	16	16	17	21	21	18	18	15

Recent Performance Summary

Sales growth is growing at healthy rate in last 3 years 27.70%

Net Profit is growing at healthy rate in last 3 years 31.97%

Sales growth is good in last 4 quarters at 17.40%

Return on Equity has declined versus last 3 years average to 14.30%

Latest Financials - Avenue Supermarts Ltd.

	Standalone	Consolidated
TTM EPS (₹)	44	41.3
TTM Sales (₹ Cr.)	53,403	54,813
BVPS (₹.) ⓘ	319.8	309.5
Reserves (₹ Cr.) ⓘ	20,160	19,487
P/BV ⓘ	11.95	12.35
PE ⓘ	86.84	92.55

From the Market
52 Week Low / High (₹)	3645.65 / 5484.00
All Time Low / High (₹)	558.75 / 5899.90
Market Cap (₹ Cr.)	2,48,697
Equity (₹ Cr.)	650.7
Face Value (₹)	10
Industry PE ⓘ	95.9

Management X-Ray of Avenue Supermarts:

Shareholding Pattern

Promoter's Holding & Share Pledging

Pledged ^*

0.00

* Pledged shares as % of Promoter's holding (%)

Valuation of Avenue Supermarts

Price Calculator

Price Chart

Price to Earnings

Enterprise Value to EBIT

Price to Book-Value

Price to Sales

Dividend History

Analyst's Notes

This is a premium feature, Please click here to check our solutions.

Key Ratios of Avenue Supermarts

Standalone Basis Consolidated Basis

Adj EPS (Rs.)

Sales (Cr.)

ROE (%)

ROCE (%)

Profit And Loss

(All Figures are in Crores.)

Standalone Basis Consolidated Basis

PARTICULARS	Mar'15	Mar'16	Mar'17	Mar'18	Mar'19	Mar'20	Mar'21	Mar'22	Mar'23	Mar'24
Sales	6,434	8,575	11,881	15,009	19,916	24,675	23,787	30,353	41,833	49,533
Operating Expenses ⓘ	5,980	7,919	10,918	13,672	18,274	22,553	22,045	27,851	38,174	45,434
Manufacturing Costs	195	315	425	485	623	797	858	895	1,237	1,471
Material Costs	5,500	7,314	10,096	12,649	16,980	21,016	20,356	26,053	35,775	42,547
Employee Cost	131	146	189	277	335	425	495	548	648	786
Other Costs ⓘ	154	143	207	262	336	315	336	355	514	630
Operating Profit ⓘ	453	657	964	1,337	1,642	2,122	1,742	2,502	3,659	4,099
Operating Profit Margin (%)	7.0%	7.7%	8.1%	8.9%	8.2%	8.6%	7.3%	8.2%	8.7%	8.3%
Other Income ⓘ	21	20	31	73	51	63	209	141	163	189
Interest ⓘ	72	91	122	59	47	63	34	40	48	44
Depreciation ⓘ	81	97	126	155	199	340	371	421	543	633
Exceptional Items ⓘ	0	0	0	0	0	0	0	0	0	0
Profit Before Tax ⓘ	321	488	747	1,196	1,448	1,783	1,545	2,182	3,231	3,611
Tax ⓘ	110	170	264	411	511	433	379	566	675	916
Profit After Tax	211	318	483	785	936	1,350	1,165	1,616	2,556	2,695
PAT Margin (%)	3.3%	3.7%	4.1%	5.2%	4.7%	5.5%	4.9%	5.3%	6.1%	5.4%
Adjusted EPS (₹)	3.8	5.7	7.7	12.6	15.0	20.8	18.0	25.0	39.4	41.4
Dividend Payout Ratio (%)	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%

Balance Sheet

(All Figures are in Crores.)

Standalone Basis Consolidated Basis

PARTICULARS	Mar'15	Mar'16	Mar'17	Mar'18	Mar'19	Mar'20	Mar'21	Mar'22	Mar'23	Mar'24
Equity and Liabilities
Shareholders Fund	1,194	1,512	3,836	4,620	5,555	11,110	12,274	13,887	16,459	19,248
Share Capital ⓘ	562	562	624	624	624	648	648	648	648	651
Reserves ⓘ	632	950	3,212	3,996	4,931	10,462	11,626	13,239	15,811	18,597
Minority Interest	0	0	0	0	0	0	0	0	0	0
Debt	741	1,022	1,104	253	425	4	0	0	0	0
Long Term Debt	714	908	981	246	126	0	0	0	0	0
Short Term Debt	27	113	123	7	299	4	0	0	0	0
Trade Payables	134	200	267	316	458	446	566	531	701	953
Others Liabilities ⓘ	280	347	596	423	559	525	807	986	1,083	1,365
Total Liabilities ⓘ	2,348	3,082	5,802	5,612	6,998	12,084	13,646	15,404	18,244	21,566
Fixed Assets
Gross Block	1,811	2,162	2,744	3,616	4,786	6,623	7,894	10,403	12,956	15,728
Accumulated Depreciation	301	97	223	376	570	905	1,264	1,670	2,198	2,794
Net Fixed Assetsⓘ	1,510	2,065	2,522	3,240	4,216	5,719	6,629	8,733	10,758	12,934
CWIP ⓘ	92	82	153	147	377	362	1,006	1,073	829	930
Investmentsⓘ	2	16	37	181	212	287	402	532	977	1,071
Inventories	530	660	933	1,147	1,576	1,909	2,167	2,587	3,056	3,723
Trade Receivables	7	8	21	33	76	49	72	231	247	393
Cash Equivalents	36	33	1,881	556	214	92	1,432	284	1,373	560
Others Assetsⓘ	172	217	256	308	328	3,666	1,937	1,964	1,005	1,955
Total Assets ⓘ	2,348	3,082	5,802	5,612	6,998	12,084	13,646	15,404	18,244	21,566

Cash Flow

(All Figures are in Crores.)

Standalone Basis Consolidated Basis

PARTICULARS	Mar'15	Mar'16	Mar'17	Mar'18	Mar'19	Mar'20	Mar'21	Mar'22	Mar'23	Mar'24
Cash Flow From Operating Activity ⓘ	207	425	449	723	853	1,287	1,385	1,315	2,678	2,743
PBT ⓘ	321	488	747	1,196	1,448	1,783	1,545	2,182	3,231	3,611
Adjustment ⓘ	148	170	219	164	220	359	217	335	448	511
Changes in Working Capital ⓘ	-163	-71	-263	-240	-321	-373	-120	-648	-301	-649
Tax Paid ⓘ	-98	-163	-254	-396	-493	-482	-256	-553	-700	-730
Cash Flow From Investing Activity ⓘ	-461	-625	-2,475	432	-998	-4,700	-1,155	-1,292	-2,442	-2,584
Capex	-465	-631	-633	-890	-1,369	-1,678	-1,968	-2,282	-2,129	-2,685
Net Investments	3	-11	-21	1,375	10	9	-113	1,050	-149	-47
Others ⓘ	0	17	-1,821	-53	361	-3,031	925	-60	-164	148
Cash Flow From Financing Activityⓘ	238	196	2,024	-1,122	201	3,384	-140	-121	-132	-87
Net Proceeds from Shares ⓘ	33	0	1,841	0	0	110	0	0	16	73
Net Proceeds from Borrowing ⓘ	0	-147	45	-542	134	-150	0	0	0	0
Interest Paid ⓘ	-61	-93	-120	-80	-54	-91	-36	-39	-48	-44
Dividend Paid ⓘ	0	0	0	0	0	0	0	0	0	0
Others ⓘ	267	437	259	-499	121	3,514	-104	-81	-100	-115
Net Cash Flow ⓘ	-16	-3	-2	34	56	-29	90	-98	103	72

Finance Ratio

Standalone Basis Consolidated Basis

PARTICULARS	Mar'15	Mar'16	Mar'17	Mar'18	Mar'19	Mar'20	Mar'21	Mar'22	Mar'23	Mar'24
Ratios
ROE (%)	19.72	23.5	18.05	18.56	18.4	16.2	9.97	12.36	16.85	15.09
ROCE (%)	21.4	24.19	21.7	24.14	26.29	21.14	13.45	16.94	21.55	20.43
Asset Turnover Ratio	3.11	3.38	2.87	2.89	3.47	2.83	2.02	2.29	2.73	2.74
PAT to CFO Conversion(x)	0.98	1.34	0.93	0.92	0.91	0.95	1.19	0.81	1.05	1.02
Working Capital Days
Receivable Days	0	0	0	1	1	1	1	2	2	2
Inventory Days	25	24	23	23	23	24	29	26	22	23
Payable Days	9	8	8	8	8	8	9	8	6	7

Avenue Supermarts Ltd Stock News

Avenue Supermarts Ltd FAQs

What is the share price of Avenue Supermarts?

Company share prices are keep on changing according to the market conditions. The closing price of Avenue Supermarts on 18-Nov-2024 15:50 is ₹3,787.3.

What is the market cap of Avenue Supermarts?

Market capitalization or market cap is determined by multiplying the current market price of a company's shares with the total number of shares outstanding. As of 18-Nov-2024 15:50 the market cap of Avenue Supermarts stood at ₹2,48,697.2.

What is the P/E ratio of Avenue Supermarts?

The latest P/E ratio of Avenue Supermarts as of 18-Nov-2024 15:50 is 86.84.

What is the P/B ratio of Avenue Supermarts?

The latest P/B ratio of Avenue Supermarts as of 18-Nov-2024 15:50 is 11.95.

What is the 52-week high and low of Avenue Supermarts?

The 52-week high of Avenue Supermarts is ₹5,484 and the 52-week low is ₹3,645.7.

What is the TTM revenue of Avenue Supermarts?

The TTM revenue is Trailing Twelve Months sales. The TTM revenue/sales of Avenue Supermarts is ₹53,403 ( Cr.) .

About Avenue Supermarts Ltd

Avenue Supermarts incorporated in year in 2002 is Mumbai based supermarket chain D-Mart. The company is among the largest and the most profitable F&G retailer in India. It offers a wide range of products with a focus on the Foods, Non-Foods (FMCG) and General Merchandise & Apparel product categories. It has many stores located across several cities in India. The company operates and manages all its stores. It also operates distribution centres and packing centres which form the backbone of the supply chain to support its retail store network.

Business area of the company

The company operates and manages all their stores. They operate predominantly on an ownership model (including long-term lease arrangements, where lease period is more than 30 years and the building is owned by it) rather than on a rental model. The company opens new stores using a cluster approach on the basis of adjacencies and focusing on an efficient supply chain, targeting densely-populated residential areas with a majority of lower-middle, middle and aspiring upper-middle class consumers. The company operates distribution centres and packing centres which form the backbone of the supply chain to support the retail store network.

The key product categories:

Foods: Groceries, staples, processed foods, dairy, frozen products, beverages & confectionery and fruits & vegetables.
Non Foods (FMCG): Home care products, personal care products, toiletries and other over-the-counter products.
General Merchandise & Apparel: Bed & bath, toys & games, crockery, plastic goods, garments, footwear, utensils and home appliances.

Major events and milestones

2001: The Company was incorporated as Avenue Supermarts.
2003: The Company opened its first store in Powai, Mumbai.
2005: The Company entered into a scheme of amalgamation for transfer of undertakings of Koop Consumer Services, Amodini Real Estates and Shoppers Delight to the company.
2007: The Company opened its first store in Gujarat.2010 The store count of the Company increased to 25 stores and their audited consolidated revenues exceeded Rs 10,000 million.
2011: The Company opened stores in Andhra Pradesh and Karnataka.
2012: The Company was converted from a private company to a public company and the name of the Company changed to Avenue Supermarts.
2012: The store count of their Company increased to 50 stores.
2014: The store count of their Company increased to 75 stores.
2015: The Company opened stores in Madhya Pradesh and Chattisgarh. The audited consolidated revenues of their Company exceeded Rs 50,000 million.
2016: The Company opened 21 stores, highest in any financial year. The store count of their Company increased to 110 and their consolidated revenues exceeded Rs 75,000 million.
2017 : The Company opened a store in the National Capital Region.
2018: The company has incorporated wholly owned subsidiary named ‘Reflect Wholesale and Retail’.
2020: The company converts two stores into fulfilment centres for e-commerce business.