0% found this document useful (0 votes)
5 views1 page

Beta

The document provides a detailed analysis of Cipla Ltd.'s stock performance in relation to the NIFTY 500 index from January to March 2025. It includes daily price data, returns, correlation, covariance, and regression statistics, highlighting the relationship between Cipla's returns and the index. Additionally, it presents historical sales growth and yearly returns for Cipla over several years.

Uploaded by

Sagar Sahu
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
5 views1 page

Beta

The document provides a detailed analysis of Cipla Ltd.'s stock performance in relation to the NIFTY 500 index from January to March 2025. It includes daily price data, returns, correlation, covariance, and regression statistics, highlighting the relationship between Cipla's returns and the index. Additionally, it presents historical sales growth and yearly returns for Cipla over several years.

Uploaded by

Sagar Sahu
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

BETA - CIPLA LTD

CIPLA LTD.
BSE : 500087

Date NIFTY 500 Price Cipla Price 1 Day Return of NIFTY 1 Day Return of CIPLA LTD
28-Mar-25 21,339.55 1,442.20 -0.32% -2.74% Correlation
27-Mar-25 21,407.95 1,482.90 0.62% 0.45% 1 Day Return of NIFTY 1 Day Return of CIPLA LTD
26-Mar-25 21,275.45 1,476.20 -0.76% -2.32% 1 Day Return of NIFTY 1
25-Mar-25 21,437.75 1,511.20 -0.47% -0.84% 1 Day Return of CIPLA LTD 0.294603677 1
24-Mar-25 21,538.10 1,524.05 1.24% 0.01% 0.294603677
21-Mar-25 21,273.90 1,523.85 0.97% 0.78%
20-Mar-25 21,070.05 1,512.05 0.99% 0.86% Covariance
19-Mar-25 20,864.50 1,499.15 1.00% -0.63% 1 Day Return of NIFTY 1 Day Return of CIPLA LTD
18-Mar-25 20,657.20 1,508.65 1.82% 1.08% 1 Day Return of NIFTY 0.000096937
17-Mar-25 20,288.30 1,492.60 0.56% 2.10% 1 Day Return of CIPLA LTD 0.000043967 0.000229762
13-Mar-25 20,176.05 1,461.90 -0.44% 0.52% 0.000043967
12-Mar-25 20,264.35 1,454.30 -0.19% 0.59%
11-Mar-25 20,302.50 1,445.75 0.18% -1.16% Standard Deviation Variance
10-Mar-25 20,266.50 1,462.75 -0.87% 0.29% NIFTY 500 0.009845678 0.000096937
07-Mar-25 20,443.40 1,458.45 -0.02% -0.23% CIPLA LTD 0.01515791 0.000229762
06-Mar-25 20,447.10 1,461.75 0.94% 2.96%
05-Mar-25 20,256.50 1,419.75 1.70% 1.28%
04-Mar-25 19,917.85 1,401.80 0.11% -0.41% # Beta = Cov(rp,rb) / Var(rb) 0.453556985
03-Mar-25 19,896.95 1,407.55 0.08% 0.00%
28-Feb-25 19,880.90 1,407.50 -2.14% -2.33%
27-Feb-25 20,315.55 1,441.15 -0.51% -1.52% # Regression Beta
25-Feb-25 20,418.75 1,463.35 -0.24% -0.91% SUMMARY OUTPUT
24-Feb-25 20,468.45 1,476.75 -1.07% 0.07%
21-Feb-25 20,690.25 1,475.75 -0.68% -0.27% Regression Statistics Y = CIPLA Returns - (Dependent Variable)
20-Feb-25 20,831.10 1,479.70 0.48% 1.06% Multiple R 0.294603677 X = NIFTY 500 Returns - (Independent Variable)
19-Feb-25 20,731.45 1,464.15 0.58% -1.21% R Square 0.086791326
18-Feb-25 20,611.40 1,482.10 -0.20% 0.51% Adjusted R Square 0.083079096
17-Feb-25 20,652.35 1,474.65 0.09% 1.04% Standard Error 0.014543958
14-Feb-25 20,633.10 1,459.45 -1.30% -0.86% Observations 248
13-Feb-25 20,904.35 1,472.15 -0.02% 1.58%
12-Feb-25 20,907.85 1,449.20 -0.20% -0.27% ANOVA
11-Feb-25 20,950.45 1,453.15 -1.97% -0.39% df SS MS F Significance F
10-Feb-25 21,371.30 1,458.85 -1.27% -0.91% Regression 1 0.00494546 0.00494546 23.37983301 2.34479E-06
07-Feb-25 21,646.15 1,472.25 -0.12% 0.05% Residual 246 0.052035575 0.000211527
06-Feb-25 21,672.45 1,471.50 -0.51% 2.42% Total 247 0.056981034
05-Feb-25 21,784.25 1,436.80 0.26% -0.85%
04-Feb-25 21,727.45 1,449.05 1.52% 2.01% Coefficients Standard Error t Stat P-value Lower 95%
03-Feb-25 21,402.55 1,420.55 -0.83% -1.32% Intercept -0.000137493 0.000923757 -0.148841631 0.881800541 -0.001956975
01-Feb-25 21,581.75 1,439.50 0.00% -2.70% 1 Day Return of NIFTY 0.453556985 0.093801797 4.835269693 2.34479E-06 0.268799885
31-Jan-25 21,580.90 1,479.40 1.33% 1.51% Upper 95% Lower 95.0% Upper 95.0%
30-Jan-25 21,297.50 1,457.45 0.24% 2.35% 0.001681988 -0.001956975 0.001681988
29-Jan-25 21,245.50 1,423.95 1.53% 0.24% 0.638314086 0.268799885 0.638314086
28-Jan-25 20,924.75 1,420.60 0.07% 1.75%
27-Jan-25 20,910.95 1,396.10 -1.91% -1.08% CIPLA LTD
24-Jan-25 21,318.90 1,411.40 -1.02% -2.74% Year Weight Year Sales Sales Growth Cipla Yaerly Returns
23-Jan-25 21,538.05 1,451.15 0.66% 0.82% 1 2016A 13,790.1 - -
22-Jan-25 21,396.55 1,439.40 -0.17% 0.80% 2 2017A 14,394.3 4.38% 0.07%
21-Jan-25 21,433.20 1,428.00 -1.72% -1.21% 3 2018A 15,155.7 5.29% -0.02%
20-Jan-25 21,809.00 1,445.45 0.59% 0.22% 4 2019A 16,362.4 7.96% -0.02%
17-Jan-25 21,680.25 1,442.30 -0.16% -0.08% 5 2020A 17,132.0 4.70% -0.07%
16-Jan-25 21,714.55 1,443.50 0.76% -0.26% 6 2021A 19,159.6 11.84% 0.27%
15-Jan-25 21,551.20 1,447.20 0.33% -0.04% 7 2022A 21,763.3 13.59% 0.11%
14-Jan-25 21,481.05 1,447.75 1.12% 0.59% 8 2023A 22,753.1 4.55% -0.05%
13-Jan-25 21,243.45 1,439.20 -2.55% -2.02% 9 2024A 25,774.1 13.28% 0.22%
10-Jan-25 21,799.00 1,468.80 -1.12% -1.30% 10 2025A 27,547.6 6.88% -0.004%

You might also like