Calculation of Beta for Vodafone Idea and Its Significance
Author’s Name: Vidushi Sahu
Introduction
Vodafone Idea is an Indian telecom operator with its headquarters based in Mumbai and Gandhinagar. It is a pan-India integrated GSM operator offering 2G, 3G, 4G, 4G+, VoLTE, and VoWiFi service. As of 31 October 2022, Vi has a subscriber base of 245.62 million, making it third largest mobile telecommunications network in India and 11 th largest mobile telecommunications network in the world.[14] The company was created on 31 August 2018 by the merger of Vodafone India and Idea Cellular, to form a new entity named Vodafone Idea Limited.
Data Collection
Data collection for the period starting from 1st December 2021 to 30th November 2022 has been downloaded from nse.com. Then Friday weekly Closing Prices have been calculated.
And weekly data of equity share of the chosen company has been regressed on weekly report of NIFTY50.
Data Analysis
Regression Equation that was formed after the calculations is-
=1.556+1.385 weekly return of nifty+ e
(4.26)
Where, N=49; R2=0.278 F=18.148
Interpretation
The equation mentioned above tells us about the relationship between Nifty50 value and Vodafone Idea stock prices.
Presence of Negative sign in the equation represents that there’s inverse relationship between the two i.e., if the value of NIFTY50 falls, stock price of Vodafone Idea will also decline. The Co-efficient of NIFTY is 1.385 which means if NIFTY by 1.385 units the stock price of Vodafone Idea will decline by 1 unit and vice versa.
Total Number of Observations are 50.
Figure in the bracket is T-stat and the P-Value of which is 0
which is less than 0.05 which means p is statistically significant at 5% level. Also, it is less than 0.01 so we can say that p is statistically significant at 1% level.
R2 is 0.278 which means 0.27% of VI(Y) is explained by NIFTY(X) balance 99.73% is error. Error here is due to variables which aren’t in the model.
F is 18.148 the P-Value for which is 0 which is less than 0.01 which means overall the model is statistically significant.
Conclusion
As from the above mentioned regression equation it can be observed that the Beta is 1.385 which is more than 1 which states the fact that it is good for investment in short term.