Calculation of the Nifty and Dabur India
Author: Dhyey Rupabheda
Introduction:
Dabur ltd is an Indian multinational consumer goods company, founded by S. K. Burman and headquartered in Ghaziabad. It manufactures Ayurveda medicine and natural consumer products and is one of the most significant fast moving consumer goods (FMCG) companies in India. Dabur derives around 60% of its revenue from the consumer care business, 11% from the food business, and remaining from the international business unit.
Objective:
To calculate the beta of Dabur Industries and its significance
Data Collection:
Data of Dabur Industries from 01-01-2022 to 31-12-2022 was downloaded from the NSE website.
• Friday’s weekly closing prices have been found out.
• Weekly Return have been calculated with the formula of
(Y2-Y1)/Y1*100
• The Weekly Return of Equity has been regressed on the Weekly Return of Nifty
Data Analysis:
Weekly Return of Dabur Industries = 490.25+0.034
Weekly Return of Nifty
• t-stat = 1.632516
• R2 = 0.01089
• F = 2.665109
• N = 245
The above equation tells us about the relationship between the Weekly Return of Dabur Industries & Weekly Return of Nifty 50.
• The number of Observations is 245 and the t-stat is 1.632516
• The p-value is .4.39, which is more than 0.05, which means that b is statistically insignificant at 5%. Even if it is more than 0.01, b is statistically insignificant at 1%.
• R2 is 0.01089, which means that X (nifty) explains 1.089% of Y, and the balance of 27.80% is an error. Error is due to the variables, which are not in the model.
• F is 2.6651, the P value for which is .4.39> 0.01, which means overall the model is statistically significant.
Conclusion:
Since b = 0.22894676 is less than 1, it is statistically insignificant.
Dabur Industries is not a good option for investment because for every increase in nifty, there will be a decrease in the equity of Dabur Industries.
