Submitted by-Arjya Chandra
SAP ID-80012100761
INTRODUCTION
Axis Bank Limited, formerly known as UTI Bank (1993–2007), is an Indian banking and financial services company headquartered in Mumbai, Maharashtra. It sells financial services to large and mid-size companies, SMEs and retail businesses.
As of 30 June 2016, 30.81% shares are owned by the promoters and the promoter group (United India Insurance Company Limited, Oriental Insurance Company Limited, National Insurance Company Limited, New India Assurance Company Ltd, GIC, LIC and UTI). The remaining 69.19% shares are owned by mutual funds, FIIs, banks, insurance companies, corporate bodies and individual investors.
OBJECTIVE
To calculate beta of the company and find its significance.
DATA COLLECTION
Data of index and equity were collected from https://www1.nseindia.com/ and https://www.nseindia.com/ respectively. Daily returns from 1st March-2021 to 28 Feb-2022 were downloaded in excel format from these websites and it was sorted into weekly format. Then weekly returns were calculated for both index and equity and then regression analysis was done.
DATA ANALYSIS
Predicted Y = 0.055950625-0.225512786*X
N=46, R Square= 0.014500373, F= 0.647404
Tstat (beta) = -0.804614188
Tstat (0.05,45)= 0.093938809
The above regression equation tells us the relationship between X and Y. Where X is NIFTY’s weekly returns and Y is Reliance Industries Ltd’s weekly returns.
The negative sign of Beta tells us the that there is no positive relationship between NIFTY and Axis bank’s weekly returns.
From the equation, it can be seen that if X rises by 1 unit, Y will fall by 0.225512786 units.
T calculated is more that T tabulated which means, β is statistically significant at 5% confidence level.
R^2 is 0.014500373 which means 1.45% of Y (Axis Bank) is explained by X. And the balance is explained by error.
F= 0.647404
CONCLUSION
β is not statistically significant in case of NIFTY and Axis Bank ltd.