Author – Anjali Singh
Introduction-
Adani Ports and Special Economic Zone Limited (APSEZ) is the largest commercial ports operator in India accounting for nearly one-fourth of the cargo movement in the country. Its presence across 13 domestic ports in seven maritime states of Gujarat, Maharashtra, Goa, kerala, Andhara Pradesh, Tamil Nadu and Odisha presents the most widespread national Footprint with deepened hinterland connectivity. The port facilities are equipped with the latest cargo-handling infrastructure which is not only best-in-class, but also capable of handling the largest vessels calling at Indian shores. Our ports equipped to handle diverse cargos, from dry cargo, liquid cargo, crude to containers
Objectives-
Relationship of Adani port company with Nifty 50
To calculate Beta of Adani Port company and see its significance
Data collection-
Closing Friday price were calculated by:
Data for this company (Adani Port ) has collected from NSE. Date and closing prices of Adani Port has been downloaded from nseindia.com ( Indices & Equity- Historical data)
Friday closing prices were calculated in week-returns.
Indices is taken as (X) and Equity is taken by (Y).
Insert one column in between the Date & Closing price column and write the formula for number ( weekday,2) then sort by A to Z and only take Friday values and insert the weekly return column with formula .(C3-C2)/C2*100
Then to put the regression from data analysis we will get the values of Adani Port.
Data analysis-
Regression Statistics
Multiple R 0.1857532305
R Square 0.03450426263
Adjusted R Square 0.01151626889
Standard Error 14.09861288
Observations 44
ANOVA
df SS MS F Significance F
Regression 1 298.3489076 298.3489076 1.500968854 0.2273488606
Residual 42 8348.377172 198.770885
Total 43 8646.72608
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -35.88331328 34.084992 -1.052759915 0.2984703082 -104.6696112 32.9029846 -104.6696112 32.9029846
14517.85 0.002521148407 0.002057844578 1.225140341 0.2273488606 -0.001631750033 0.006674046847 -0.001631750033 0.006674046847
Y= a+bx
a= -35.89
b= 0.0025
Y= -35.89- 0.0025
T stat- 1.23
Since P value is more than 0.05 the model is not significant at 5%
The above equation shows the relationship between price and demand. If the price rises demand falls by.