Relationship of Nifty with Avenue Supermarts Ltd.

Author: Amie Noronha

Introduction: Avenue Supermarts ltd
Avenue Supermarts was incorporated as Avenue Supermarts Private Limited on May 12, 2000, at Mumbai, Maharashtra as a private limited company under the Companies Act, 1956. Subsequently, the name of the Company was changed to Avenue Supermarts Limited due to conversion from a private company to a public company pursuant to a special resolution passed by the Shareholders at an extraordinary general meeting held on February 1, 2011. Pursuant to the aforesaid change of name, a fresh certificate of incorporation was issued to the Company by the RoC on May 3, 2011.

Objective: To calculate β (beta) for Avenue Supermarts ltd

Literature Review:
1.
In 2007, DMart entered Gujarat with its first store in the state. In 2010, the total store count of our company crossed 25 stores and the audited consolidated revenue crossed Rs 1000 crore mark. In 2012, the store count of the company crossed 50 stores. In 2014, the store count of our company increased to 75 stores. In 2015, audited consolidated revenue of the company crossed Rs 5000 crore mark. In 2016, the store count of our company increased to 110 and the consolidated revenues crossed Rs 7500 crore mark. On 30 September 2016, the company filed Draft Red Herring Prospectus and on 2 March 2017 filed Red Herring Prospectus with SEBI for raising Rs. 1870 crore. The IPO was open through the book building route from 8 March 2017 to 10 March 2017 with Price Band of Rs 295 to Rs 299 per share. The Issue got subscribed 73.41 times leading to its Issue Price being fixed at Rs 299 per share. The Shares got listed on BSE and NSE on 21 March 2017. The stock debuted at Rs 604.40 on BSE which is 102.14% above issue price.

2.
On 2 February 2018, Avenue Supermarts (ASL) announced that the company has completed the acquisition of 4.35 crore equity shares of Rs 10 each, fully paid-up, of Avenue E-Commerce Limited at a price of Rs 11.30 per equity share aggregating to Rs 49.21 crore. Pursuant to this, Avenue E-Commerce Limited has become a wholly-owned subsidiary of the company. Before the acquisition of additional shares, ASL held 49.21% stake in Avenue E-Commerce Limited. Earlier, ASL’s Board of Directors at its meeting held on 25 January 2018 had approved acquisition of additional 4.35 crore equity shares constituting 50.79% of the share capital of Avenue E-Commerce Limited, an Associate Company, from other shareholders for total consideration of Rs 49.21 crore. Avenue E-Commerce Limited is engaged in the business of online retail of food products and groceries in India. The company clocked turnover of Rs 1.20 crore in 2016-17.

On 7 March 2018, Avenue Supermarts (ASL) announced that the shareholding of the company in Avenue E-Commerce Limited has reduced from 100% to 99.66%, pursuant to the allotment of shares on preferential basis by Avenue E-Commerce Limited to ASL and other applicants of the issue.
Data Collection:
Web site: http://www.capitalmarket.com/Company-Information/Information/About-Company/Avenue-Supermarts-Ltd/40942
Company: Avenue Supermart ltd
Date Period : 1.04.2017-31.03.2018
The data was sorted into Weekly Returns and Closing Price for Friday.
NIFTY 50 = X
Equity = Y

Data Analysis:
Regression
R^2 – 0.110
N – 48
F – 5.688
If p < 0.01 *, p < 0.05 **, p < 0.10 ***
T-stat – 2.385

The above regression equations shows the relationship between closing prices of avenue supermarts pvt ltd and NIFTY 50.

The t-stat =2.385 and p value is 0.021, which is more than 0.01, hence it is statistically insignificant at 1% level.

R^2 is 0.110, which means 11% of avenue supermarts pvt ltd, closing price is explained by NIFTY closing price.

F is 5.688, p value for which is 0.021, which is more than 0.01, which means the model is statistically significant at 1% level.

Conclusion: R^2 = 0.110%, i.e., 11%

Reference:
https://www.nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=DMART&illiquid=0&smeFlag=0&itpFlag=0