Stock Analysis on Net

Gilead Sciences Inc. (NASDAQ:GILD)

Capital Asset Pricing Model (CAPM)

Microsoft Excel

Rates of Return

Gilead Sciences Inc., monthly rates of return

Microsoft Excel
Gilead Sciences Inc. (GILD) Standard & Poor’s 500 (S&P 500)
t Date PriceGILD,t1 DividendGILD,t1 RGILD,t2 PriceS&P 500,t RS&P 500,t3
Jan 31, 2020 $63.20 3,225.52
1. Feb 29, 2020 $69.36 9.75% 2,954.22 -8.41%
2. Mar 31, 2020 $74.76 $0.68 8.77% 2,584.59 -12.51%
3. Apr 30, 2020 $84.00 12.36% 2,912.43 12.68%
. . . . . . .
. . . . . . .
. . . . . . .
58. Nov 30, 2024 $92.58 4.23% 6,032.38 5.73%
59. Dec 31, 2024 $92.37 $0.77 0.60% 5,881.63 -2.50%
Average (R): 1.22% 1.16%
Standard deviation: 7.01% 5.28%
Gilead Sciences Inc. (GILD) Standard & Poor’s 500 (S&P 500)
t Date PriceGILD,t1 DividendGILD,t1 RGILD,t2 PriceS&P 500,t RS&P 500,t3
Jan 31, 2020 $63.20 3,225.52
1. Feb 29, 2020 $69.36 9.75% 2,954.22 -8.41%
2. Mar 31, 2020 $74.76 $0.68 8.77% 2,584.59 -12.51%
3. Apr 30, 2020 $84.00 12.36% 2,912.43 12.68%
4. May 31, 2020 $77.83 -7.35% 3,044.31 4.53%
5. Jun 30, 2020 $76.94 $0.68 -0.27% 3,100.29 1.84%
6. Jul 31, 2020 $69.53 -9.63% 3,271.12 5.51%
7. Aug 31, 2020 $66.75 -4.00% 3,500.31 7.01%
8. Sep 30, 2020 $63.19 $0.68 -4.31% 3,363.00 -3.92%
9. Oct 31, 2020 $58.15 -7.98% 3,269.96 -2.77%
10. Nov 30, 2020 $60.67 4.33% 3,621.63 10.75%
11. Dec 31, 2020 $58.26 $0.68 -2.85% 3,756.07 3.71%
12. Jan 31, 2021 $65.60 12.60% 3,714.24 -1.11%
13. Feb 28, 2021 $61.40 -6.40% 3,811.15 2.61%
14. Mar 31, 2021 $64.63 $0.71 6.42% 3,972.89 4.24%
15. Apr 30, 2021 $63.47 -1.79% 4,181.17 5.24%
16. May 31, 2021 $66.11 4.16% 4,204.11 0.55%
17. Jun 30, 2021 $68.86 $0.71 5.23% 4,297.50 2.22%
18. Jul 31, 2021 $68.29 -0.83% 4,395.26 2.27%
19. Aug 31, 2021 $72.78 6.57% 4,522.68 2.90%
20. Sep 30, 2021 $69.85 $0.71 -3.05% 4,307.54 -4.76%
21. Oct 31, 2021 $64.88 -7.12% 4,605.38 6.91%
22. Nov 30, 2021 $68.93 6.24% 4,567.00 -0.83%
23. Dec 31, 2021 $72.61 $0.71 6.37% 4,766.18 4.36%
24. Jan 31, 2022 $68.68 -5.41% 4,515.55 -5.26%
25. Feb 28, 2022 $60.40 -12.06% 4,373.94 -3.14%
26. Mar 31, 2022 $59.45 $0.73 -0.36% 4,530.41 3.58%
27. Apr 30, 2022 $59.34 -0.19% 4,131.93 -8.80%
28. May 31, 2022 $64.85 9.29% 4,132.15 0.01%
29. Jun 30, 2022 $61.81 $0.73 -3.56% 3,785.38 -8.39%
30. Jul 31, 2022 $59.75 -3.33% 4,130.29 9.11%
31. Aug 31, 2022 $63.47 6.23% 3,955.00 -4.24%
32. Sep 30, 2022 $61.69 $0.73 -1.65% 3,585.62 -9.34%
33. Oct 31, 2022 $78.46 27.18% 3,871.98 7.99%
34. Nov 30, 2022 $87.83 11.94% 4,080.11 5.38%
35. Dec 31, 2022 $85.85 $0.73 -1.42% 3,839.50 -5.90%
36. Jan 31, 2023 $83.94 -2.22% 4,076.60 6.18%
37. Feb 28, 2023 $80.53 -4.06% 3,970.15 -2.61%
38. Mar 31, 2023 $82.97 $0.75 3.96% 4,109.31 3.51%
39. Apr 30, 2023 $82.21 -0.92% 4,169.48 1.46%
40. May 31, 2023 $76.94 -6.41% 4,179.83 0.25%
41. Jun 30, 2023 $77.07 $0.75 1.14% 4,376.86 4.71%
42. Jul 31, 2023 $76.14 -1.21% 4,588.96 4.85%
43. Aug 31, 2023 $76.48 0.45% 4,507.66 -1.77%
44. Sep 30, 2023 $74.94 $0.75 -1.03% 4,288.05 -4.87%
45. Oct 31, 2023 $78.54 4.80% 4,193.80 -2.20%
46. Nov 30, 2023 $76.60 -2.47% 4,567.80 8.92%
47. Dec 31, 2023 $81.01 $0.75 6.74% 4,769.83 4.42%
48. Jan 31, 2024 $78.26 -3.39% 4,845.65 1.59%
49. Feb 29, 2024 $72.10 -7.87% 5,096.27 5.17%
50. Mar 31, 2024 $73.25 $0.77 2.66% 5,254.35 3.10%
51. Apr 30, 2024 $65.20 -10.99% 5,035.69 -4.16%
52. May 31, 2024 $64.27 -1.43% 5,277.51 4.80%
53. Jun 30, 2024 $68.61 $0.77 7.95% 5,460.48 3.47%
54. Jul 31, 2024 $76.06 10.86% 5,522.30 1.13%
55. Aug 31, 2024 $79.00 3.87% 5,648.40 2.28%
56. Sep 30, 2024 $83.84 $0.77 7.10% 5,762.48 2.02%
57. Oct 31, 2024 $88.82 5.94% 5,705.45 -0.99%
58. Nov 30, 2024 $92.58 4.23% 6,032.38 5.73%
59. Dec 31, 2024 $92.37 $0.77 0.60% 5,881.63 -2.50%
Average (R): 1.22% 1.16%
Standard deviation: 7.01% 5.28%

Show all

1 Data in US$ per share of common stock, adjusted for splits and stock dividends.

2 Rate of return on common stock of GILD during period t

3 Rate of return on S&P 500 (the market portfolio proxy) during period t


Variance and Covariance

Gilead Sciences Inc., calculation of variance and covariance of returns

Microsoft Excel
t Date RGILD,t RS&P 500,t (RGILD,tRGILD)2 (RS&P 500,tRS&P 500)2 (RGILD,tRGILD)×(RS&P 500,tRS&P 500)
1. Feb 29, 2020 9.75% -8.41% 72.65 91.63 -81.59
2. Mar 31, 2020 8.77% -12.51% 56.89 186.96 -103.13
3. Apr 30, 2020 12.36% 12.68% 124.02 132.78 128.32
. . . . . . .
. . . . . . .
. . . . . . .
58. Nov 30, 2024 4.23% 5.73% 9.06 20.87 13.75
59. Dec 31, 2024 0.60% -2.50% 0.38 13.40 2.26
Total (Σ): 2,851.46 1,618.62 282.17
t Date RGILD,t RS&P 500,t (RGILD,tRGILD)2 (RS&P 500,tRS&P 500)2 (RGILD,tRGILD)×(RS&P 500,tRS&P 500)
1. Feb 29, 2020 9.75% -8.41% 72.65 91.63 -81.59
2. Mar 31, 2020 8.77% -12.51% 56.89 186.96 -103.13
3. Apr 30, 2020 12.36% 12.68% 124.02 132.78 128.32
4. May 31, 2020 -7.35% 4.53% 73.42 11.34 -28.85
5. Jun 30, 2020 -0.27% 1.84% 2.23 0.46 -1.01
6. Jul 31, 2020 -9.63% 5.51% 117.81 18.91 -47.20
7. Aug 31, 2020 -4.00% 7.01% 27.26 34.17 -30.52
8. Sep 30, 2020 -4.31% -3.92% 30.67 25.85 28.16
9. Oct 31, 2020 -7.98% -2.77% 84.63 15.43 36.13
10. Nov 30, 2020 4.33% 10.75% 9.67 92.03 29.84
11. Dec 31, 2020 -2.85% 3.71% 16.60 6.51 -10.39
12. Jan 31, 2021 12.60% -1.11% 129.40 5.18 -25.88
13. Feb 28, 2021 -6.40% 2.61% 58.15 2.10 -11.04
14. Mar 31, 2021 6.42% 4.24% 26.97 9.50 16.01
15. Apr 30, 2021 -1.79% 5.24% 9.11 16.66 -12.32
16. May 31, 2021 4.16% 0.55% 8.62 0.38 -1.80
17. Jun 30, 2021 5.23% 2.22% 16.08 1.12 4.25
18. Jul 31, 2021 -0.83% 2.27% 4.21 1.24 -2.28
19. Aug 31, 2021 6.57% 2.90% 28.64 3.02 9.30
20. Sep 30, 2021 -3.05% -4.76% 18.26 35.02 25.29
21. Oct 31, 2021 -7.12% 6.91% 69.53 33.10 -47.97
22. Nov 30, 2021 6.24% -0.83% 25.19 3.98 -10.01
23. Dec 31, 2021 6.37% 4.36% 26.48 10.24 16.47
24. Jan 31, 2022 -5.41% -5.26% 44.03 41.21 42.60
25. Feb 28, 2022 -12.06% -3.14% 176.34 18.47 57.07
26. Mar 31, 2022 -0.36% 3.58% 2.52 5.84 -3.84
27. Apr 30, 2022 -0.19% -8.80% 1.98 99.14 14.02
28. May 31, 2022 9.29% 0.01% 65.00 1.34 -9.32
29. Jun 30, 2022 -3.56% -8.39% 22.90 91.26 45.72
30. Jul 31, 2022 -3.33% 9.11% 20.76 63.21 -36.22
31. Aug 31, 2022 6.23% -4.24% 25.03 29.22 -27.04
32. Sep 30, 2022 -1.65% -9.34% 8.28 110.27 30.22
33. Oct 31, 2022 27.18% 7.99% 673.97 46.58 177.19
34. Nov 30, 2022 11.94% 5.38% 114.90 17.76 45.17
35. Dec 31, 2022 -1.42% -5.90% 7.00 49.82 18.68
36. Jan 31, 2023 -2.22% 6.18% 11.89 25.14 -17.29
37. Feb 28, 2023 -4.06% -2.61% 27.94 14.23 19.94
38. Mar 31, 2023 3.96% 3.51% 7.50 5.49 6.42
39. Apr 30, 2023 -0.92% 1.46% 4.58 0.09 -0.65
40. May 31, 2023 -6.41% 0.25% 58.27 0.83 6.97
41. Jun 30, 2023 1.14% 4.71% 0.01 12.62 -0.28
42. Jul 31, 2023 -1.21% 4.85% 5.90 13.58 -8.95
43. Aug 31, 2023 0.45% -1.77% 0.60 8.60 2.28
44. Sep 30, 2023 -1.03% -4.87% 5.09 36.40 13.61
45. Oct 31, 2023 4.80% -2.20% 12.82 11.28 -12.03
46. Nov 30, 2023 -2.47% 8.92% 13.64 60.17 -28.65
47. Dec 31, 2023 6.74% 4.42% 30.39 10.64 17.98
48. Jan 31, 2024 -3.39% 1.59% 21.33 0.18 -1.98
49. Feb 29, 2024 -7.87% 5.17% 82.71 16.09 -36.48
50. Mar 31, 2024 2.66% 3.10% 2.07 3.77 2.79
51. Apr 30, 2024 -10.99% -4.16% 149.16 28.33 65.01
52. May 31, 2024 -1.43% 4.80% 7.02 13.26 -9.65
53. Jun 30, 2024 7.95% 3.47% 45.26 5.32 15.51
54. Jul 31, 2024 10.86% 1.13% 92.84 0.00 -0.28
55. Aug 31, 2024 3.87% 2.28% 6.98 1.26 2.96
56. Sep 30, 2024 7.10% 2.02% 34.55 0.74 5.05
57. Oct 31, 2024 5.94% -0.99% 22.25 4.63 -10.15
58. Nov 30, 2024 4.23% 5.73% 9.06 20.87 13.75
59. Dec 31, 2024 0.60% -2.50% 0.38 13.40 2.26
Total (Σ): 2,851.46 1,618.62 282.17

Show all

VarianceGILD = Σ(RGILD,tRGILD)2 ÷ (59 – 1)
= 2,851.46 ÷ (59 – 1)
= 49.16

VarianceS&P 500 = Σ(RS&P 500,tRS&P 500)2 ÷ (59 – 1)
= 1,618.62 ÷ (59 – 1)
= 27.91

CovarianceGILD, S&P 500 = Σ(RGILD,tRGILD)×(RS&P 500,tRS&P 500) ÷ (59 – 1)
= 282.17 ÷ (59 – 1)
= 4.86


Systematic Risk (β) Estimation

Microsoft Excel
VarianceGILD 49.16
VarianceS&P 500 27.91
CovarianceGILD, S&P 500 4.86
Correlation coefficientGILD, S&P 5001 0.13
βGILD2 0.17
αGILD3 1.02%

Calculations

1 Correlation coefficientGILD, S&P 500
= CovarianceGILD, S&P 500 ÷ (Standard deviationGILD × Standard deviationS&P 500)
= 4.86 ÷ (7.01% × 5.28%)
= 0.13

2 βGILD
= CovarianceGILD, S&P 500 ÷ VarianceS&P 500
= 4.86 ÷ 27.91
= 0.17

3 αGILD
= AverageGILD – βGILD × AverageS&P 500
= 1.22%0.17 × 1.16%
= 1.02%


Expected Rate of Return

Microsoft Excel
Assumptions
Rate of return on LT Treasury Composite1 RF 4.64%
Expected rate of return on market portfolio2 E(RM) 14.89%
Systematic risk (β) of Gilead Sciences Inc. common stock βGILD 0.17
 
Expected rate of return on Gilead Sciences Inc. common stock3 E(RGILD) 6.43%

1 Unweighted average of bid yields on all outstanding fixed-coupon U.S. Treasury bonds neither due or callable in less than 10 years (risk-free rate of return proxy).

2 See details »

3 E(RGILD) = RF + βGILD [E(RM) – RF]
= 4.64% + 0.17 [14.89%4.64%]
= 6.43%