Stock Analysis on Net
Stock Analysis on Net

Lam Research Corp. (NASDAQ:LRCX)

Capital Asset Pricing Model (CAPM)

Microsoft Excel

Rates of Return

Lam Research Corp., monthly rates of return

Microsoft Excel
Lam Research Corp. (LRCX) Standard & Poor’s 500 (S&P 500)
t Date PriceLRCX,t1 DividendLRCX,t1 RLRCX,t2 PriceS&P 500,t RS&P 500,t3
Jul 31, 2020 $37.72 3,271.12
1. Aug 31, 2020 $33.63 -10.84% 3,500.31 7.01%
2. Sep 30, 2020 $33.18 $0.13 -0.95% 3,363.00 -3.92%
3. Oct 31, 2020 $34.21 3.10% 3,269.96 -2.77%
. . . . . . .
. . . . . . .
. . . . . . .
70. May 31, 2026 $318.18 23.39% 7,580.06 5.15%
71. Jun 30, 2026 $433.33 $0.26 36.27% 7,499.36 -1.06%
Average (R): 4.35% 1.28%
Standard deviation: 12.87% 4.53%
Lam Research Corp. (LRCX) Standard & Poor’s 500 (S&P 500)
t Date PriceLRCX,t1 DividendLRCX,t1 RLRCX,t2 PriceS&P 500,t RS&P 500,t3
Jul 31, 2020 $37.72 3,271.12
1. Aug 31, 2020 $33.63 -10.84% 3,500.31 7.01%
2. Sep 30, 2020 $33.18 $0.13 -0.95% 3,363.00 -3.92%
3. Oct 31, 2020 $34.21 3.10% 3,269.96 -2.77%
4. Nov 30, 2020 $45.27 32.33% 3,621.63 10.75%
5. Dec 31, 2020 $47.23 $0.13 4.62% 3,756.07 3.71%
6. Jan 31, 2021 $48.40 2.48% 3,714.24 -1.11%
7. Feb 28, 2021 $56.72 17.19% 3,811.15 2.61%
8. Mar 31, 2021 $59.52 $0.13 5.17% 3,972.89 4.24%
9. Apr 30, 2021 $62.05 4.25% 4,181.17 5.24%
10. May 31, 2021 $64.99 4.74% 4,204.11 0.55%
11. Jun 30, 2021 $65.07 $0.13 0.32% 4,297.50 2.22%
12. Jul 31, 2021 $63.74 -2.04% 4,395.26 2.27%
13. Aug 31, 2021 $60.48 -5.11% 4,522.68 2.90%
14. Sep 30, 2021 $56.92 $0.15 -5.64% 4,307.54 -4.76%
15. Oct 31, 2021 $56.36 -0.98% 4,605.38 6.91%
16. Nov 30, 2021 $67.99 20.64% 4,567.00 -0.83%
17. Dec 31, 2021 $71.92 $0.15 6.00% 4,766.18 4.36%
18. Jan 31, 2022 $58.99 -17.98% 4,515.55 -5.26%
19. Feb 28, 2022 $56.14 -4.83% 4,373.94 -3.14%
20. Mar 31, 2022 $53.76 $0.15 -3.97% 4,530.41 3.58%
21. Apr 30, 2022 $46.58 -13.36% 4,131.93 -8.80%
22. May 31, 2022 $52.00 11.64% 4,132.15 0.01%
23. Jun 30, 2022 $42.62 $0.15 -17.75% 3,785.38 -8.39%
24. Jul 31, 2022 $50.05 17.43% 4,130.29 9.11%
25. Aug 31, 2022 $43.79 -12.51% 3,955.00 -4.24%
26. Sep 30, 2022 $36.60 $0.1725 -16.03% 3,585.62 -9.34%
27. Oct 31, 2022 $40.48 10.60% 3,871.98 7.99%
28. Nov 30, 2022 $47.24 16.70% 4,080.11 5.38%
29. Dec 31, 2022 $42.03 $0.1725 -10.66% 3,839.50 -5.90%
30. Jan 31, 2023 $50.01 18.99% 4,076.60 6.18%
31. Feb 28, 2023 $48.60 -2.82% 3,970.15 -2.61%
32. Mar 31, 2023 $53.01 $0.1725 9.43% 4,109.31 3.51%
33. Apr 30, 2023 $52.41 -1.13% 4,169.48 1.46%
34. May 31, 2023 $61.67 17.67% 4,179.83 0.25%
35. Jun 30, 2023 $64.29 $0.1725 4.53% 4,376.86 4.71%
36. Jul 31, 2023 $71.85 11.76% 4,588.96 4.85%
37. Aug 31, 2023 $70.24 -2.24% 4,507.66 -1.77%
38. Sep 30, 2023 $62.68 $0.20 -10.48% 4,288.05 -4.87%
39. Oct 31, 2023 $58.82 -6.16% 4,193.80 -2.20%
40. Nov 30, 2023 $71.59 21.71% 4,567.80 8.92%
41. Dec 31, 2023 $78.33 $0.20 9.69% 4,769.83 4.42%
42. Jan 31, 2024 $82.52 5.35% 4,845.65 1.59%
43. Feb 29, 2024 $93.83 13.71% 5,096.27 5.17%
44. Mar 31, 2024 $97.16 $0.20 3.76% 5,254.35 3.10%
45. Apr 30, 2024 $89.44 -7.95% 5,035.69 -4.16%
46. May 31, 2024 $93.24 4.25% 5,277.51 4.80%
47. Jun 30, 2024 $106.49 $0.20 14.43% 5,460.48 3.47%
48. Jul 31, 2024 $92.12 -13.49% 5,522.30 1.13%
49. Aug 31, 2024 $82.10 -10.88% 5,648.40 2.28%
50. Sep 30, 2024 $81.61 $0.23 -0.32% 5,762.48 2.02%
51. Oct 31, 2024 $74.35 -8.90% 5,705.45 -0.99%
52. Nov 30, 2024 $73.88 -0.63% 6,032.38 5.73%
53. Dec 31, 2024 $72.23 $0.23 -1.92% 5,881.63 -2.50%
54. Jan 31, 2025 $81.05 12.21% 6,040.53 2.70%
55. Feb 28, 2025 $76.74 -5.32% 5,954.50 -1.42%
56. Mar 31, 2025 $72.70 $0.23 -4.96% 5,611.85 -5.75%
57. Apr 30, 2025 $71.67 -1.42% 5,569.06 -0.76%
58. May 31, 2025 $80.79 12.72% 5,911.69 6.15%
59. Jun 30, 2025 $97.34 $0.23 20.77% 6,204.95 4.96%
60. Jul 31, 2025 $94.84 -2.57% 6,339.39 2.17%
61. Aug 31, 2025 $100.15 5.60% 6,460.26 1.91%
62. Sep 30, 2025 $133.90 $0.26 33.96% 6,688.46 3.53%
63. Oct 31, 2025 $157.46 17.60% 6,840.20 2.27%
64. Nov 30, 2025 $156.00 -0.93% 6,849.09 0.13%
65. Dec 31, 2025 $171.18 $0.26 9.90% 6,845.50 -0.05%
66. Jan 31, 2026 $233.46 36.38% 6,939.03 1.37%
67. Feb 28, 2026 $233.89 0.18% 6,878.88 -0.87%
68. Mar 31, 2026 $213.66 $0.26 -8.54% 6,528.52 -5.09%
69. Apr 30, 2026 $257.86 20.69% 7,209.01 10.42%
70. May 31, 2026 $318.18 23.39% 7,580.06 5.15%
71. Jun 30, 2026 $433.33 $0.26 36.27% 7,499.36 -1.06%
Average (R): 4.35% 1.28%
Standard deviation: 12.87% 4.53%

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

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


Variance and Covariance

Lam Research Corp., calculation of variance and covariance of returns

Microsoft Excel
t Date RLRCX,t RS&P 500,t (RLRCX,t–RLRCX)2 (RS&P 500,t–RS&P 500)2 (RLRCX,t–RLRCX)×(RS&P 500,t–RS&P 500)
1. Aug 31, 2020 -10.84% 7.01% 230.82 32.84 -87.06
2. Sep 30, 2020 -0.95% -3.92% 28.10 27.03 27.56
3. Oct 31, 2020 3.10% -2.77% 1.55 16.34 5.04
. . . . . . .
. . . . . . .
. . . . . . .
70. May 31, 2026 23.39% 5.15% 362.62 14.98 73.71
71. Jun 30, 2026 36.27% -1.06% 1,019.02 5.48 -74.73
Total (Σ): 11,594.05 1,436.39 2,463.72
t Date RLRCX,t RS&P 500,t (RLRCX,t–RLRCX)2 (RS&P 500,t–RS&P 500)2 (RLRCX,t–RLRCX)×(RS&P 500,t–RS&P 500)
1. Aug 31, 2020 -10.84% 7.01% 230.82 32.84 -87.06
2. Sep 30, 2020 -0.95% -3.92% 28.10 27.03 27.56
3. Oct 31, 2020 3.10% -2.77% 1.55 16.34 5.04
4. Nov 30, 2020 32.33% 10.75% 782.87 89.84 265.20
5. Dec 31, 2020 4.62% 3.71% 0.07 5.93 0.65
6. Jan 31, 2021 2.48% -1.11% 3.51 5.71 4.48
7. Feb 28, 2021 17.19% 2.61% 164.87 1.78 17.11
8. Mar 31, 2021 5.17% 4.24% 0.67 8.81 2.42
9. Apr 30, 2021 4.25% 5.24% 0.01 15.73 -0.39
10. May 31, 2021 4.74% 0.55% 0.15 0.53 -0.28
11. Jun 30, 2021 0.32% 2.22% 16.21 0.89 -3.81
12. Jul 31, 2021 -2.04% 2.27% 40.88 1.00 -6.38
13. Aug 31, 2021 -5.11% 2.90% 89.57 2.63 -15.36
14. Sep 30, 2021 -5.64% -4.76% 99.76 36.40 60.26
15. Oct 31, 2021 -0.98% 6.91% 28.45 31.79 -30.07
16. Nov 30, 2021 20.64% -0.83% 265.21 4.45 -34.36
17. Dec 31, 2021 6.00% 4.36% 2.73 9.52 5.09
18. Jan 31, 2022 -17.98% -5.26% 498.55 42.70 145.91
19. Feb 28, 2022 -4.83% -3.14% 84.29 19.47 40.51
20. Mar 31, 2022 -3.97% 3.58% 69.26 5.29 -19.15
21. Apr 30, 2022 -13.36% -8.80% 313.48 101.44 178.33
22. May 31, 2022 11.64% 0.01% 53.09 1.62 -9.26
23. Jun 30, 2022 -17.75% -8.39% 488.40 93.48 213.67
24. Jul 31, 2022 17.43% 9.11% 171.17 61.39 102.51
25. Aug 31, 2022 -12.51% -4.24% 284.17 30.47 93.06
26. Sep 30, 2022 -16.03% -9.34% 415.15 112.70 216.30
27. Oct 31, 2022 10.60% 7.99% 39.08 45.03 41.95
28. Nov 30, 2022 16.70% 5.38% 152.52 16.80 50.62
29. Dec 31, 2022 -10.66% -5.90% 225.40 51.46 107.70
30. Jan 31, 2023 18.99% 6.18% 214.23 24.00 71.71
31. Feb 28, 2023 -2.82% -2.61% 51.40 15.11 27.87
32. Mar 31, 2023 9.43% 3.51% 25.80 4.97 11.32
33. Apr 30, 2023 -1.13% 1.46% 30.05 0.04 -1.03
34. May 31, 2023 17.67% 0.25% 177.38 1.06 -13.69
35. Jun 30, 2023 4.53% 4.71% 0.03 11.82 0.61
36. Jul 31, 2023 11.76% 4.85% 54.90 12.74 26.45
37. Aug 31, 2023 -2.24% -1.77% 43.44 9.29 20.09
38. Sep 30, 2023 -10.48% -4.87% 219.88 37.80 91.17
39. Oct 31, 2023 -6.16% -2.20% 110.42 12.07 36.51
40. Nov 30, 2023 21.71% 8.92% 301.39 58.40 132.66
41. Dec 31, 2023 9.69% 4.42% 28.56 9.90 16.82
42. Jan 31, 2024 5.35% 1.59% 1.00 0.10 0.31
43. Feb 29, 2024 13.71% 5.17% 87.53 15.18 36.45
44. Mar 31, 2024 3.76% 3.10% 0.35 3.33 -1.07
45. Apr 30, 2024 -7.95% -4.16% 151.18 29.57 66.86
46. May 31, 2024 4.25% 4.80% 0.01 12.43 -0.36
47. Jun 30, 2024 14.43% 3.47% 101.51 4.80 22.07
48. Jul 31, 2024 -13.49% 1.13% 318.41 0.02 2.57
49. Aug 31, 2024 -10.88% 2.28% 231.86 1.01 -15.34
50. Sep 30, 2024 -0.32% 2.02% 21.78 0.55 -3.47
51. Oct 31, 2024 -8.90% -0.99% 175.45 5.13 30.01
52. Nov 30, 2024 -0.63% 5.73% 24.82 19.84 -22.19
53. Dec 31, 2024 -1.92% -2.50% 39.34 14.25 23.68
54. Jan 31, 2025 12.21% 2.70% 61.80 2.03 11.21
55. Feb 28, 2025 -5.32% -1.42% 93.46 7.29 26.11
56. Mar 31, 2025 -4.96% -5.75% 86.76 49.43 65.49
57. Apr 30, 2025 -1.42% -0.76% 33.25 4.16 11.76
58. May 31, 2025 12.72% 6.15% 70.14 23.78 40.84
59. Jun 30, 2025 20.77% 4.96% 269.62 13.58 60.50
60. Jul 31, 2025 -2.57% 2.17% 47.86 0.79 -6.16
61. Aug 31, 2025 5.60% 1.91% 1.56 0.40 0.79
62. Sep 30, 2025 33.96% 3.53% 876.71 5.09 66.80
63. Oct 31, 2025 17.60% 2.27% 175.44 0.98 13.15
64. Nov 30, 2025 -0.93% 0.13% 27.85 1.31 6.05
65. Dec 31, 2025 9.90% -0.05% 30.78 1.77 -7.37
66. Jan 31, 2026 36.38% 1.37% 1,026.11 0.01 2.88
67. Feb 28, 2026 0.18% -0.87% 17.35 4.59 8.93
68. Mar 31, 2026 -8.54% -5.09% 166.10 40.57 82.09
69. Apr 30, 2026 20.69% 10.42% 266.91 83.67 149.44
70. May 31, 2026 23.39% 5.15% 362.62 14.98 73.71
71. Jun 30, 2026 36.27% -1.06% 1,019.02 5.48 -74.73
Total (Σ): 11,594.05 1,436.39 2,463.72

Show all

VarianceLRCX = Σ(RLRCX,t–RLRCX)2 ÷ (71 – 1)
= 11,594.05 ÷ (71 – 1)
= 165.63

VarianceS&P 500 = Σ(RS&P 500,t–RS&P 500)2 ÷ (71 – 1)
= 1,436.39 ÷ (71 – 1)
= 20.52

CovarianceLRCX, S&P 500 = Σ(RLRCX,t–RLRCX)×(RS&P 500,t–RS&P 500) ÷ (71 – 1)
= 2,463.72 ÷ (71 – 1)
= 35.20


Systematic Risk (β) Estimation

Microsoft Excel
VarianceLRCX 165.63
VarianceS&P 500 20.52
CovarianceLRCX, S&P 500 35.20
Correlation coefficientLRCX, S&P 5001 0.60
βLRCX2 1.72
αLRCX3 2.16%

Calculations

1 Correlation coefficientLRCX, S&P 500
= CovarianceLRCX, S&P 500 ÷ (Standard deviationLRCX × Standard deviationS&P 500)
= 35.20 ÷ (12.87% × 4.53%)
= 0.60

2 βLRCX
= CovarianceLRCX, S&P 500 ÷ VarianceS&P 500
= 35.20 ÷ 20.52
= 1.72

3 αLRCX
= AverageLRCX – βLRCX × AverageS&P 500
= 4.35% – 1.72 × 1.28%
= 2.16%


Expected Rate of Return

Microsoft Excel
Assumptions
Rate of return on LT Treasury Composite1 RF 5.20%
Expected rate of return on market portfolio2 E(RM) 17.45%
Systematic risk (β) of Lam Research Corp. common stock βLRCX 1.72
 
Expected rate of return on Lam Research Corp. common stock3 E(RLRCX) 26.22%

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(RLRCX) = RF + βLRCX [E(RM) – RF]
= 5.20% + 1.72 [17.45% – 5.20%]
= 26.22%