Site icon FinShiksha

FinShiksha Sector Insights – Retail Sector in India – Part 3

Retail Sector Insights

Disclaimer: The purpose of this document is purely educational in nature. The idea is to help someone kickstart their analysis of this sector/company. However, this is not to be construed as a recommendation of any sort on the company or its stock. All information has been sourced from publicly available data such as annual reports and news items and the veracity of the sources has not been independently established. Kindly use your judgement while analysing further or using this document.

 

We would like to applaud the efforts put in by four students from Xavier Institute Management Bhubaneshwar (XIMB) – Anirudha Basak, Manan Gupta, Shobhit Jain and Vaibhav Saith (in alphabetical order) as a part of Live Project with FinShiksha.

This article is the last article in the series talking about India’s Retail Industry.

In the First part, we talked about how much India is important? What are the various categories in the retail sector? How does future growth look like? The link to the first article can be found here

In the Second part, we talked about various metrics through which we can evaluate Retail Industry and Players within the same. We evaluated few companies through metrics and the link to the second article can be found here

In the Third and final part, we will talk about some part of the valuation, forecasting and what the Industry will Transform into?

 

So Let us start with what companies are doing currently:

Contrary to the general belief that companies are going online and shoppers are buying everything online is NOT TRUE.

Nearly 91% of retailers and brands currently have an omnichannel strategy or are planning to invest in omnichannel technologies in the near-term.

Now questions arise, what is Omnichannel Retailing?

Follow On Question: Why is it desired?

Let’s try and connect some dots and break some myths-

 

Do we have any proof?

Reliance Retail

DMart

Shoppers stop

Westside

Future Retail

Even Etailers are trying to develop physical presence. In 2017 offline channels contributed significant revenue to the total revenue of the Etailers.

Etailers

Offline Channel’s share of the revenue
Lenskart 50-60%
Pepperfry 20-30%
FirstCry 30%
Zivame 20-25%
Clovia 5-7%

Convenience is the key. You will see a lot of integration between electronic platforms and physical stores in the next few years. Considering the extent of Kirana Stores and reach they have, don’t be surprised if companies start using them as distribution centres and accommodate them in the overall strategy. This reduces the cost greatly by using the existing infrastructure and expands the business pretty quickly.

 

Now let’s focus our attention to forecasting – First step towards the valuing a company. How to estimate future revenue of retailers?

We can estimate future revenue for a retailer by understanding various factors affecting the revenue. Basically identify the revenue drivers.

Approach 1: Based on Store Size and Revenue per Sq Ft

Estimating the total revenue while considering average store size can be explained with the help of the following illustration of central stores which is a part of Future Lifestyle Fashion.

Central FY16 FY17 FY18 FY19 FY20 (E) FY21 (E) FY22 (E)
Number of stores 31 35 40 44 50 55 60
Avg. store size (‘000 sqft) 102.9 100.0 92.5 90.5 88.5 86.5 84.5
Changes in average store size -2.9% -7.5% -2.0% -2% -2% -2%
The total retail area in mn square feet 3.19 3.5 3.7 3.98 4.42 4.76 5.07
Revenue per square feet (in Rs.) 5,987 6,486 6,784 7,183 7,543 7,920 8,316
YoY change in revenue per sqft 8% 5% 6% 5% 5% 5%
Total Revenue (in Cr.) 1,910 2,270 2,510 2,859 3,336 3,766 4,214

All the bold items are numbers which are assumed based on the previous years or certain data given by the company.

  1. We have assumed that the company opens net 5 central stores each year till 2022 based on certain company reports.
  2. The average store size of the centre has been continuously decreasing. We have assumed that it will decrease by 2,000 square feet each year based on the decrease in store size in FY19.
  3. The total retail area is equal to (Number of central stores) * (Average store size).
  4. Revenue per square feet is assumed to increase by 5% each year based on the previous years’ average. (Basically slight price increase + inflation)
  5. Total revenue is arrived by multiplying the total retail area and revenue per square feet.

Approach 2: Based on Footfalls and Revenue generated per user

We estimate revenue based on footfall can be illustrated with the help of Westside which is a part of Trent a TATA Group company.

Westside FY17 FY18 FY19 FY20 (E) FY21 (E)
Number of stores 107 125 150 167 191
Annual footfall per store 244,299 289,120 299,333 309,511 320,034
Total annual footfall (in Cr.) 2.61 3.61 4.49 5.17 6.11
Conversion Rate 32% 25% 22% 20% 20%
Number of bills in crore 0.83 0.9 1.0 1.0 1.2
Average bill size 2,029 2,197 2,332 2,519 2,720
Total Revenue (in Cr.) 1,684 1,977 2,304 2,604 3,325

All the bold items are number which is assumed based on the previous year or certain data given by the company.

The calculation seems simple, isn’t it? Focus on the assumptions more. Questions should be asked why the growth of 5% or why prices will increase by 10% etc. Retail Industry calculations are not difficult. But what is most difficult is the ASSUMPTIONS. So always stay cautious while putting any number and then valuing the same.

So, that’s all from our end as of now with respect to India’s Retail Industry Landscape. Hope you have enjoyed it.

Share it further 🙂

 

FacebookWhatsAppLinkedInTwitterTelegramEmailCopy LinkShare
Exit mobile version