Relationship of ITC company with Nifty fifty and to calculate Beta.

Author: Miss. Isha Dhaktode.

Objective:
Relationship of ITC company with Nifty fifty.
To calculate Beta of ITC company and see its significance.

Literature Review:

Natarajan’s view on ITC

Karan Issar (Jul 12, 2011) Gopinath Natarajan, EVP, IIFL PReMIA feels that, overall with a non-cigarette income revenue growing, the delta from that portion also is kind of in favor of ITC.
Natarajan told CNBC-TV18,”The markets kind of surprised quite a few people with this kind of a big move. Overall, the markets have been possibly moving in about 7-8% kind of a range with a pivot being at about 5500. Especially if you see in with the kind of flavours the market has liked the kind of things markets have been liking ITC is clearly one among them”
He further added,”ITC has been a performer for almost a few months now. Possibly also because of the fact that it not only brings about a defensive flavor, but their cigarette business is doing well. The pricing power is there in the cigarette business and also the non-cigarette income like your Sunfeast, your Ashirwad, all these also achieving some kind of scale that’s also a key point, which is in favor of ITC. Overall with non-cigarette income revenue growing,the delta from that portion is also kind of in favor of ITC.

Data collection:
Date and closing prices of ITC company and nifty fifty has been downloaded from nseindia.com .
Friday closing prices were calculated in week returns.
Nifty fifty is taken as (X) and ITC company is taken as (Y).
Calculating Beta by using a Regression tool in Data Analysis in excel.

Data Analysis:
Y = -0.40+0.82X
ITC shares = -0.40 + 0.82 Nifty fifty
N = 47
R square = 0.25
F= 14.97

The above equation tells us that the relationship between ITC company (Y-Demand) and Nifty fifty (X-Price) negative sign means it has an inverse relationship.
If price rises, demand falls and if price falls, demand rises.
As b is 0.82, if X rises by 1 unit demand will fall by -0.40 units and vice versa.

t-stat for b is 3.87 and the p value is less than 0.05 rather it is less than 0.01 which means b is statistically significant at 1% level.

R square is 0.25 which means 25% of demand (variances in demand) is explained by X.

F is 14.97 and the p value for this is also less than 0.01 which means overall this model is statistically significant at 1% level.

Conclusion:
This is a good Beta and good model.

Reference:
Karan Issar (Jul 12, 2011) Natarajan’s view on ITC https://www.scribd.com/doc/59852000/Literature-Review