Stock Analysis on Net

Synopsys Inc. (NASDAQ:SNPS)

Capital Asset Pricing Model (CAPM)

Microsoft Excel

Rates of Return

Synopsys Inc., monthly rates of return

Microsoft Excel
Synopsys Inc. (SNPS) Standard & Poor’s 500 (S&P 500)
t Date PriceSNPS,t1 DividendSNPS,t1 RSNPS,t2 PriceS&P 500,t RS&P 500,t3
Nov 30, 2019 $141.04 3,140.98
1. Dec 31, 2019 $139.20 -1.30% 3,230.78 2.86%
2. Jan 31, 2020 $147.51 5.97% 3,225.52 -0.16%
3. Feb 29, 2020 $137.93 -6.49% 2,954.22 -8.41%
. . . . . . .
. . . . . . .
. . . . . . .
70. Sep 30, 2025 $493.39 -18.25% 6,688.46 3.53%
71. Oct 31, 2025 $453.82 -8.02% 6,840.20 2.27%
Average (R): 2.08% 1.22%
Standard deviation: 9.35% 4.97%
Synopsys Inc. (SNPS) Standard & Poor’s 500 (S&P 500)
t Date PriceSNPS,t1 DividendSNPS,t1 RSNPS,t2 PriceS&P 500,t RS&P 500,t3
Nov 30, 2019 $141.04 3,140.98
1. Dec 31, 2019 $139.20 -1.30% 3,230.78 2.86%
2. Jan 31, 2020 $147.51 5.97% 3,225.52 -0.16%
3. Feb 29, 2020 $137.93 -6.49% 2,954.22 -8.41%
4. Mar 31, 2020 $128.79 -6.63% 2,584.59 -12.51%
5. Apr 30, 2020 $157.12 22.00% 2,912.43 12.68%
6. May 31, 2020 $180.91 15.14% 3,044.31 4.53%
7. Jun 30, 2020 $195.00 7.79% 3,100.29 1.84%
8. Jul 31, 2020 $199.22 2.16% 3,271.12 5.51%
9. Aug 31, 2020 $221.30 11.08% 3,500.31 7.01%
10. Sep 30, 2020 $213.98 -3.31% 3,363.00 -3.92%
11. Oct 31, 2020 $213.86 -0.06% 3,269.96 -2.77%
12. Nov 30, 2020 $227.50 6.38% 3,621.63 10.75%
13. Dec 31, 2020 $259.24 13.95% 3,756.07 3.71%
14. Jan 31, 2021 $255.45 -1.46% 3,714.24 -1.11%
15. Feb 28, 2021 $245.21 -4.01% 3,811.15 2.61%
16. Mar 31, 2021 $247.78 1.05% 3,972.89 4.24%
17. Apr 30, 2021 $247.06 -0.29% 4,181.17 5.24%
18. May 31, 2021 $254.34 2.95% 4,204.11 0.55%
19. Jun 30, 2021 $275.79 8.43% 4,297.50 2.22%
20. Jul 31, 2021 $287.99 4.42% 4,395.26 2.27%
21. Aug 31, 2021 $332.24 15.37% 4,522.68 2.90%
22. Sep 30, 2021 $299.41 -9.88% 4,307.54 -4.76%
23. Oct 31, 2021 $333.18 11.28% 4,605.38 6.91%
24. Nov 30, 2021 $341.00 2.35% 4,567.00 -0.83%
25. Dec 31, 2021 $368.50 8.06% 4,766.18 4.36%
26. Jan 31, 2022 $310.50 -15.74% 4,515.55 -5.26%
27. Feb 28, 2022 $312.39 0.61% 4,373.94 -3.14%
28. Mar 31, 2022 $333.27 6.68% 4,530.41 3.58%
29. Apr 30, 2022 $286.79 -13.95% 4,131.93 -8.80%
30. May 31, 2022 $319.20 11.30% 4,132.15 0.01%
31. Jun 30, 2022 $303.70 -4.86% 3,785.38 -8.39%
32. Jul 31, 2022 $367.50 21.01% 4,130.29 9.11%
33. Aug 31, 2022 $346.02 -5.84% 3,955.00 -4.24%
34. Sep 30, 2022 $305.51 -11.71% 3,585.62 -9.34%
35. Oct 31, 2022 $292.55 -4.24% 3,871.98 7.99%
36. Nov 30, 2022 $339.54 16.06% 4,080.11 5.38%
37. Dec 31, 2022 $319.29 -5.96% 3,839.50 -5.90%
38. Jan 31, 2023 $353.75 10.79% 4,076.60 6.18%
39. Feb 28, 2023 $363.76 2.83% 3,970.15 -2.61%
40. Mar 31, 2023 $386.25 6.18% 4,109.31 3.51%
41. Apr 30, 2023 $371.32 -3.87% 4,169.48 1.46%
42. May 31, 2023 $454.96 22.53% 4,179.83 0.25%
43. Jun 30, 2023 $435.41 -4.30% 4,376.86 4.71%
44. Jul 31, 2023 $451.80 3.76% 4,588.96 4.85%
45. Aug 31, 2023 $458.89 1.57% 4,507.66 -1.77%
46. Sep 30, 2023 $458.97 0.02% 4,288.05 -4.87%
47. Oct 31, 2023 $469.44 2.28% 4,193.80 -2.20%
48. Nov 30, 2023 $543.23 15.72% 4,567.80 8.92%
49. Dec 31, 2023 $514.91 -5.21% 4,769.83 4.42%
50. Jan 31, 2024 $533.35 3.58% 4,845.65 1.59%
51. Feb 29, 2024 $573.73 7.57% 5,096.27 5.17%
52. Mar 31, 2024 $571.50 -0.39% 5,254.35 3.10%
53. Apr 30, 2024 $530.59 -7.16% 5,035.69 -4.16%
54. May 31, 2024 $560.80 5.69% 5,277.51 4.80%
55. Jun 30, 2024 $595.06 6.11% 5,460.48 3.47%
56. Jul 31, 2024 $558.32 -6.17% 5,522.30 1.13%
57. Aug 31, 2024 $519.58 -6.94% 5,648.40 2.28%
58. Sep 30, 2024 $506.39 -2.54% 5,762.48 2.02%
59. Oct 31, 2024 $513.61 1.43% 5,705.45 -0.99%
60. Nov 30, 2024 $558.49 8.74% 6,032.38 5.73%
61. Dec 31, 2024 $485.36 -13.09% 5,881.63 -2.50%
62. Jan 31, 2025 $525.48 8.27% 6,040.53 2.70%
63. Feb 28, 2025 $457.28 -12.98% 5,954.50 -1.42%
64. Mar 31, 2025 $428.85 -6.22% 5,611.85 -5.75%
65. Apr 30, 2025 $459.01 7.03% 5,569.06 -0.76%
66. May 31, 2025 $463.98 1.08% 5,911.69 6.15%
67. Jun 30, 2025 $512.68 10.50% 6,204.95 4.96%
68. Jul 31, 2025 $633.47 23.56% 6,339.39 2.17%
69. Aug 31, 2025 $603.52 -4.73% 6,460.26 1.91%
70. Sep 30, 2025 $493.39 -18.25% 6,688.46 3.53%
71. Oct 31, 2025 $453.82 -8.02% 6,840.20 2.27%
Average (R): 2.08% 1.22%
Standard deviation: 9.35% 4.97%

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 SNPS during period t

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


Variance and Covariance

Synopsys Inc., calculation of variance and covariance of returns

Microsoft Excel
t Date RSNPS,t RS&P 500,t (RSNPS,tRSNPS)2 (RS&P 500,tRS&P 500)2 (RSNPS,tRSNPS)×(RS&P 500,tRS&P 500)
1. Dec 31, 2019 -1.30% 2.86% 11.46 2.67 -5.53
2. Jan 31, 2020 5.97% -0.16% 15.13 1.93 -5.40
3. Feb 29, 2020 -6.49% -8.41% 73.52 92.85 82.62
. . . . . . .
. . . . . . .
. . . . . . .
70. Sep 30, 2025 -18.25% 3.53% 413.23 5.32 -46.91
71. Oct 31, 2025 -8.02% 2.27% 102.01 1.09 -10.54
Total (Σ): 6,121.14 1,731.31 1,898.45
t Date RSNPS,t RS&P 500,t (RSNPS,tRSNPS)2 (RS&P 500,tRS&P 500)2 (RSNPS,tRSNPS)×(RS&P 500,tRS&P 500)
1. Dec 31, 2019 -1.30% 2.86% 11.46 2.67 -5.53
2. Jan 31, 2020 5.97% -0.16% 15.13 1.93 -5.40
3. Feb 29, 2020 -6.49% -8.41% 73.52 92.85 82.62
4. Mar 31, 2020 -6.63% -12.51% 75.81 188.70 119.60
5. Apr 30, 2020 22.00% 12.68% 396.68 131.32 228.24
6. May 31, 2020 15.14% 4.53% 170.59 10.91 43.15
7. Jun 30, 2020 7.79% 1.84% 32.58 0.38 3.51
8. Jul 31, 2020 2.16% 5.51% 0.01 18.36 0.36
9. Aug 31, 2020 11.08% 7.01% 81.06 33.43 52.05
10. Sep 30, 2020 -3.31% -3.92% 29.03 26.50 27.73
11. Oct 31, 2020 -0.06% -2.77% 4.56 15.93 8.53
12. Nov 30, 2020 6.38% 10.75% 18.47 90.82 40.96
13. Dec 31, 2020 13.95% 3.71% 140.93 6.19 29.53
14. Jan 31, 2021 -1.46% -1.11% 12.55 5.47 8.28
15. Feb 28, 2021 -4.01% 2.61% 37.07 1.92 -8.43
16. Mar 31, 2021 1.05% 4.24% 1.07 9.11 -3.12
17. Apr 30, 2021 -0.29% 5.24% 5.62 16.14 -9.52
18. May 31, 2021 2.95% 0.55% 0.75 0.46 -0.59
19. Jun 30, 2021 8.43% 2.22% 40.37 0.99 6.33
20. Jul 31, 2021 4.42% 2.27% 5.49 1.10 2.46
21. Aug 31, 2021 15.37% 2.90% 176.49 2.80 22.24
22. Sep 30, 2021 -9.88% -4.76% 143.08 35.78 71.55
23. Oct 31, 2021 11.28% 6.91% 84.62 32.37 52.34
24. Nov 30, 2021 2.35% -0.83% 0.07 4.24 -0.55
25. Dec 31, 2021 8.06% 4.36% 35.81 9.84 18.77
26. Jan 31, 2022 -15.74% -5.26% 317.54 42.03 115.53
27. Feb 28, 2022 0.61% -3.14% 2.17 19.02 6.42
28. Mar 31, 2022 6.68% 3.58% 21.20 5.53 10.83
29. Apr 30, 2022 -13.95% -8.80% 256.86 100.41 160.60
30. May 31, 2022 11.30% 0.01% 85.02 1.49 -11.24
31. Jun 30, 2022 -4.86% -8.39% 48.11 92.48 66.70
32. Jul 31, 2022 21.01% 9.11% 358.25 62.20 149.28
33. Aug 31, 2022 -5.84% -4.24% 62.81 29.91 43.34
34. Sep 30, 2022 -11.71% -9.34% 190.10 111.61 145.66
35. Oct 31, 2022 -4.24% 7.99% 39.97 45.72 -42.75
36. Nov 30, 2022 16.06% 5.38% 195.50 17.23 58.03
37. Dec 31, 2022 -5.96% -5.90% 64.71 50.72 57.29
38. Jan 31, 2023 10.79% 6.18% 75.91 24.51 43.13
39. Feb 28, 2023 2.83% -2.61% 0.56 14.72 -2.88
40. Mar 31, 2023 6.18% 3.51% 16.83 5.20 9.36
41. Apr 30, 2023 -3.87% 1.46% 35.35 0.06 -1.42
42. May 31, 2023 22.53% 0.25% 417.99 0.95 -19.97
43. Jun 30, 2023 -4.30% 4.71% 40.67 12.17 -22.25
44. Jul 31, 2023 3.76% 4.85% 2.84 13.11 6.10
45. Aug 31, 2023 1.57% -1.77% 0.26 8.98 1.53
46. Sep 30, 2023 0.02% -4.87% 4.25 37.17 12.58
47. Oct 31, 2023 2.28% -2.20% 0.04 11.72 -0.69
48. Nov 30, 2023 15.72% 8.92% 186.01 59.18 104.92
49. Dec 31, 2023 -5.21% 4.42% 53.19 10.23 -23.33
50. Jan 31, 2024 3.58% 1.59% 2.25 0.13 0.55
51. Feb 29, 2024 7.57% 5.17% 30.15 15.58 21.67
52. Mar 31, 2024 -0.39% 3.10% 6.10 3.52 -4.63
53. Apr 30, 2024 -7.16% -4.16% 85.35 29.01 49.76
54. May 31, 2024 5.69% 4.80% 13.06 12.80 12.93
55. Jun 30, 2024 6.11% 3.47% 16.23 5.03 9.03
56. Jul 31, 2024 -6.17% 1.13% 68.13 0.01 0.76
57. Aug 31, 2024 -6.94% 2.28% 81.34 1.12 -9.55
58. Sep 30, 2024 -2.54% 2.02% 21.33 0.63 -3.67
59. Oct 31, 2024 1.43% -0.99% 0.43 4.90 1.45
60. Nov 30, 2024 8.74% 5.73% 44.33 20.30 30.00
61. Dec 31, 2024 -13.09% -2.50% 230.26 13.87 56.51
62. Jan 31, 2025 8.27% 2.70% 38.27 2.18 9.14
63. Feb 28, 2025 -12.98% -1.42% 226.77 7.02 39.89
64. Mar 31, 2025 -6.22% -5.75% 68.85 48.71 57.91
65. Apr 30, 2025 7.03% -0.76% 24.53 3.95 -9.84
66. May 31, 2025 1.08% 6.15% 0.99 24.28 -4.91
67. Jun 30, 2025 10.50% 4.96% 70.83 13.96 31.44
68. Jul 31, 2025 23.56% 2.17% 461.41 0.89 20.23
69. Aug 31, 2025 -4.73% 1.91% 46.35 0.46 -4.64
70. Sep 30, 2025 -18.25% 3.53% 413.23 5.32 -46.91
71. Oct 31, 2025 -8.02% 2.27% 102.01 1.09 -10.54
Total (Σ): 6,121.14 1,731.31 1,898.45

Show all

VarianceSNPS = Σ(RSNPS,tRSNPS)2 ÷ (71 – 1)
= 6,121.14 ÷ (71 – 1)
= 87.44

VarianceS&P 500 = Σ(RS&P 500,tRS&P 500)2 ÷ (71 – 1)
= 1,731.31 ÷ (71 – 1)
= 24.73

CovarianceSNPS, S&P 500 = Σ(RSNPS,tRSNPS)×(RS&P 500,tRS&P 500) ÷ (71 – 1)
= 1,898.45 ÷ (71 – 1)
= 27.12


Systematic Risk (β) Estimation

Microsoft Excel
VarianceSNPS 87.44
VarianceS&P 500 24.73
CovarianceSNPS, S&P 500 27.12
Correlation coefficientSNPS, S&P 5001 0.58
βSNPS2 1.10
αSNPS3 0.74%

Calculations

1 Correlation coefficientSNPS, S&P 500
= CovarianceSNPS, S&P 500 ÷ (Standard deviationSNPS × Standard deviationS&P 500)
= 27.12 ÷ (9.35% × 4.97%)
= 0.58

2 βSNPS
= CovarianceSNPS, S&P 500 ÷ VarianceS&P 500
= 27.12 ÷ 24.73
= 1.10

3 αSNPS
= AverageSNPS – βSNPS × AverageS&P 500
= 2.08%1.10 × 1.22%
= 0.74%


Expected Rate of Return

Microsoft Excel
Assumptions
Rate of return on LT Treasury Composite1 RF 4.84%
Expected rate of return on market portfolio2 E(RM) 17.36%
Systematic risk (β) of Synopsys Inc. common stock βSNPS 1.10
 
Expected rate of return on Synopsys Inc. common stock3 E(RSNPS) 18.57%

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(RSNPS) = RF + βSNPS [E(RM) – RF]
= 4.84% + 1.10 [17.36%4.84%]
= 18.57%