Avenue Supermarts Ltd - Stock Valuation and Financial Performance

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

Avenue Supermarts Share Price

3,619.60 -132.85 -3.54%
as on 21-Nov'24 16:00

DeciZen - make an informed investing decision on Avenue Supermarts

Overall Rating
Bole Toh

1. Quality

2. Valuation

Undervalued

3. Price Trend

Avenue Supermarts stock performance -

mw4me loader
P/E Ratio (SA):
85.26
Market Cap:
2,44,184.3 Cr.
52-wk low:
3,645.7
52-wk high:
5,484

Is Avenue Supermarts Ltd an attractive stock to invest in?

1. Is Avenue Supermarts Ltd a good quality company?

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

2. Is Avenue Supermarts Ltd 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.

3. Is Avenue Supermarts Ltd 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.

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
Data adjusted to bonus, split, extra-ordinary income, rights issue and change in financial year end

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

Financial track record gives insight into the company's performance on key parameters over the past ten years. MoneyWorks4me’s proprietary colour codes make it easy for retail investors to gauge the company’s past performance.
Avenue Supermarts Ltd has performed well in majority of the past ten years indicating its past ten year financial track record is very good

Value Creation

Value Creation Index Colour Code Guide

Mar'15Mar'16Mar'17Mar'18Mar'19Mar'20Mar'21Mar'22Mar'23Mar'24TTM
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.91.20.61.21.30.90.20.50.90.8-

Growth Parameters

Growth Parameters Colour Code Guide

Sales 6,4348,57511,88115,00919,91624,67523,78730,35341,83349,53353,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.75.67.712.414.820.617.924.939.341.144
YoY Gr.-50.8%35.8%61.4%19.8%39.2%-13.2%39.2%57.8%4.7%-
BVPS (₹) 21.326.961.57489171.5189.5214.4253.9295.8319.8
Adj Net
Profit
2103174787719241,3361,1601,6142,5482,6772,864
Cash Flow from Ops. 2074254497238531,2871,3851,3152,6782,743-
Debt/CF from Ops. 4.42.83.30.60.800000-

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%
BVPS34%27.2%16%16.5%
Share Price - 14.7% -10.7% -5.2%

Key Financial Parameters

Performance Ratio Colour Code Guide

Mar'15Mar'16Mar'17Mar'18Mar'19Mar'20Mar'21Mar'22Mar'23Mar'24TTM
Return on
Equity %
19.623.417.918.218.1169.912.316.81514.3
Op. Profit
Mgn %
7.17.78.18.98.38.67.38.38.88.38.2
Net Profit
Mgn %
3.33.745.14.65.44.95.36.15.45.4
Debt to
Equity
0.80.80.40.10.1000000
Working Cap
Days
3331292929516848353422
Cash Conv.
Cycle
1816161616172121181815

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.73 12.13
PE 85.26 90.87
From the Market
52 Week Low / High (₹) 3645.65 / 5484.00
All Time Low / High (₹) 558.75 / 5899.90
Market Cap (₹ Cr.) 2,44,184
Equity (₹ Cr.) 650.7
Face Value (₹) 10
Industry PE 94.9

Management X-Ray of Avenue Supermarts:

Shareholding Pattern

Promoter's Holding & Share Pledging

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

Event Update

Login/Register to view analysis.

Analyst's Notes

Key Ratios of Avenue Supermarts

Adj EPS (Rs.)

Sales (Cr.)

ROE (%)

ROCE (%)

Profit And Loss

(All Figures are in Crores.)
PARTICULARSMar'15Mar'16Mar'17Mar'18Mar'19Mar'20Mar'21Mar'22Mar'23Mar'24
Sales6,4348,57511,88115,00919,91624,67523,78730,35341,83349,533
Operating Expenses 5,9807,91910,91813,67218,27422,55322,04527,85138,17445,434
Manufacturing Costs1953154254856237978588951,2371,471
Material Costs5,5007,31410,09612,64916,98021,01620,35626,05335,77542,547
Employee Cost 131146189277335425495548648786
Other Costs 154143207262336315336355514630
Operating Profit 4536579641,3371,6422,1221,7422,5023,6594,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 212031735163209141163189
Interest 729112259476334404844
Depreciation 8197126155199340371421543633
Exceptional Items 0000000000
Profit Before Tax 3214887471,1961,4481,7831,5452,1823,2313,611
Tax 110170264411511433379566675916
Profit After Tax 2113184837859361,3501,1651,6162,5562,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.85.77.712.615.020.818.025.039.441.4
Dividend Payout Ratio (%)0%0%0%0%0%0%0%0%0%0%

Balance Sheet

(All Figures are in Crores.)
PARTICULARSMar'15Mar'16Mar'17Mar'18Mar'19Mar'20Mar'21Mar'22Mar'23Mar'24

Equity and Liabilities

Shareholders Fund 1,1941,5123,8364,6205,55511,11012,27413,88716,45919,248
Share Capital 562562624624624648648648648651
Reserves 6329503,2123,9964,93110,46211,62613,23915,81118,597
Minority Interest0000000000
Debt7411,0221,10425342540000
Long Term Debt71490898124612600000
Short Term Debt27113123729940000
Trade Payables134200267316458446566531701953
Others Liabilities 2803475964235595258079861,0831,365
Total Liabilities 2,3483,0825,8025,6126,99812,08413,64615,40418,24421,566

Fixed Assets

Gross Block1,8112,1622,7443,6164,7866,6237,89410,40312,95615,728
Accumulated Depreciation301972233765709051,2641,6702,1982,794
Net Fixed Assets1,5102,0652,5223,2404,2165,7196,6298,73310,75812,934
CWIP 92821531473773621,0061,073829930
Investments 216371812122874025329771,071
Inventories5306609331,1471,5761,9092,1672,5873,0563,723
Trade Receivables782133764972231247393
Cash Equivalents 36331,881556214921,4322841,373560
Others Assets1722172563083283,6661,9371,9641,0051,955
Total Assets 2,3483,0825,8025,6126,99812,08413,64615,40418,24421,566

Cash Flow

(All Figures are in Crores.)
PARTICULARSMar'15Mar'16Mar'17Mar'18Mar'19Mar'20Mar'21Mar'22Mar'23Mar'24
Cash Flow From Operating Activity 2074254497238531,2871,3851,3152,6782,743
PBT 3214887471,1961,4481,7831,5452,1823,2313,611
Adjustment 148170219164220359217335448511
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,475432-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-211,375109-1131,050-149-47
Others 017-1,821-53361-3,031925-60-164148
Cash Flow From Financing Activity 2381962,024-1,1222013,384-140-121-132-87
Net Proceeds from Shares 3301,84100110001673
Net Proceeds from Borrowing 0-14745-542134-1500000
Interest Paid -61-93-120-80-54-91-36-39-48-44
Dividend Paid 0000000000
Others 267437259-4991213,514-104-81-100-115
Net Cash Flow -16-3-23456-2990-9810372
PARTICULARSMar'15Mar'16Mar'17Mar'18Mar'19Mar'20Mar'21Mar'22Mar'23Mar'24
Ratios
ROE (%)19.7223.518.0518.5618.416.29.9712.3616.8515.09
ROCE (%)21.424.1921.724.1426.2921.1413.4516.9421.5520.43
Asset Turnover Ratio3.113.382.872.893.472.832.022.292.732.74
PAT to CFO Conversion(x)0.981.340.930.920.910.951.190.811.051.02
Working Capital Days
Receivable Days0001111222
Inventory Days25242323232429262223
Payable Days9888889867

Avenue Supermarts Ltd Stock News

Avenue Supermarts Ltd FAQs

Company share prices are keep on changing according to the market conditions. The closing price of Avenue Supermarts on 21-Nov-2024 16:00 is ₹3,619.6.
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 21-Nov-2024 16:00 the market cap of Avenue Supermarts stood at ₹2,44,184.3.
The latest P/E ratio of Avenue Supermarts as of 21-Nov-2024 16:00 is 85.26.
The latest P/B ratio of Avenue Supermarts as of 21-Nov-2024 16:00 is 11.73.
The 52-week high of Avenue Supermarts is ₹5,484 and the 52-week low is ₹3,645.7.
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.
Read More Read Less
You have 2 views remaining as a Guest User. To get DeciZen Rating of 3,500+ Stocks based on their Quality, Valuation and Price Trend Login Now
© 2024 The Alchemists Ark Pvt. Ltd. All rights reserved. MoneyWorks4Me ® is a registered trademark of The Alchemists Ark Pvt. Ltd.