Prepared By:
AUTHOR: – Arshad Shaikh
ROLL NO: – 021331025075
BATCH: – Operations and Supply Chain Management
CONTENTS
|
Sl No |
Title |
Page No |
|
1 |
Introduction |
1 |
|
2 |
Objective |
1 |
|
3 |
Data Collection |
1 |
|
4 |
Literature Review |
1 |
|
5 |
Data Analysis |
1 |
|
6 |
Conclusion |
1 |
|
7 |
References |
1 |
1. INTRODUCTION
· Bharti Airtel Limited is one of India’s leading multinational telecommunications companies, providing mobile, broadband, digital TV, and enterprise services.
· Founded in 1995 by Sunil Bharti Mittal, the company is headquartered in New Delhi, India..
· Airtel operates in India, South Asia, and several African countries, serving hundreds of millions of customers.
· It is among the top telecom operators in India, known for strong network coverage, 4G/5G services, and digital platforms like Airtel Payments Bank and Airtel Thanks.
2. OBJECTIVE
To calculate β of Airtel LTD and observe its significance.
3. DATA COLLECTION
· Historical data of Airtel LTD and NIFTY50 index data (downloaded from NSE website for the period 01-Dec-24 to 30-Nov-2025).
· The data was manipulated to get Friday closing prices.
4. LITERATURE REVIEW
· Bharti Airtel Annual Report (2022) explains how the company’s strategic focus on network expansion, digital services, and customer experience has strengthened its market position and supported long-term growth in the Indian telecom sector.
5. DATA ANALYSIS
· Regression Equation: – Y = a + bx
where: –
y = Weekly Return for Airtel LTD
x = Weekly Return for NIFTY
This equation tells us that if weekly returns of NIFTY increases, then weekly return for Airtel LTD also increases.
· Number of Observations = 247
· t-stat for β = 0.3666
· p-value = 0.54545 è This indicates that since the p-value is greater than 0.05, β is not statistically significant, even at the 5% level.
· R2 = 0.0015 è This indicates that only about 0.15% of the variation in the weekly returns of Airtel LTD is explained by the weekly returns of NIFTY. The remaining 99.85% variation is due to other factors not included in the model.
· F = 0.3666 Since the F-value is very low and statistically insignificant, the overall regression model is not statistically significant.
6. CONCLUSION
It is not suitable for short-term investment decisions based solely on market (NIFTY) rise.
7. REFERENCES
1. Bharti Airtel Ltd. (2022). Annual Report of Bharti Airtel Limited. Bharti Airtel Publications, New Delhi.