Shoppers Stop Ltd Complete Fundamental Analysis
Originally published: 21/04/2020 14:47
Publication number: ELQ-17545-1
View all versions & Certificate
certified

Shoppers Stop Ltd Complete Fundamental Analysis

Fundamental Analysis in Microsoft Excel of Shoppers Stop Ltd.

Description
Shoppers Stop is the first departmental store in India and has an annual footprint of 110 million customers. It currently has 274 stores and 7.5 thousand employees. The overall retail space owned by the company is 4.5 million sq ft. Their target customer segment is the fast-growing middle to high-income nuclear families in India, where women are primary influencers. Overall they have a presence in 42+ cities in India including metros like Mumbai and Delhi.

The company has a total of 500+ fashion and beauty brands targeted towards youth population in India. They have a dedicated loyalty program called "First Citizen Loyalty Program" which has a base of 6.8 million customers. This program contributes 84% of the total revenue.

The other is a premium program called "Personal Shopper" where the billing amount by the customer is 2.8 times the average bill. This is targeted at high-income individuals. Overall, the company has managed to build one of the largest customer base in the retail industry. However, it has to compete with other online retail players who are growing rapidly in the Indian market.

The Model covers all the major fundamental aspects of Shoppers Stop Ltd over the ten year period. The model is easy to edit and update for the future years as well. It includes:
1. Growth Ratios
2. Profitability Ratios
3. Cash Flow Ratios
4. Liquidity and Solvency Ratios
5. Efficiency Ratios
6. Valuation Ratios
7. ROE (Du Pont Analysis)
8. Common Size analysis
9. Enterprise Valuation
10. Financial Strength Analysis

Further Qualitative analysis is also done considering these factors and ratings have been assigned. The complete detailed analysis is in the word document along with the Excel model.

This Best Practice includes
1 Microsoft Excel Model +1 Microsoft Word Document

Acquire nonprofit license for $3.50

Add to cart

Add to bookmarks

Discuss

Further information

The aim is to provide a thorough outlook into the company's financial position. This will help the students in projects and learning fundamental analysis. This can also be used by Investors who are looking to do their own due diligence before investing in the Indian Stock Markets.

Equity Research, Fundamental Analysis, Valuation, Long Term Investing


0.0 / 5 (0 votes)

please wait...