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, 2017 $159.46 2,470.30
1. Aug 31, 2017 $165.98 4.09% 2,471.65 0.05%
2. Sep 30, 2017 $185.04 $0.45 11.75% 2,519.36 1.93%
3. Oct 31, 2017 $208.57 12.72% 2,575.26 2.22%
. . . . . . .
. . . . . . .
. . . . . . .
70. May 31, 2023 $616.70 17.67% 4,179.83 0.25%
71. Jun 30, 2023 $642.86 $1.725 4.52% 4,376.86 4.71%
Average (R): 2.73% 0.94%
Standard deviation: 11.21% 5.05%
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, 2017 $159.46 2,470.30
1. Aug 31, 2017 $165.98 4.09% 2,471.65 0.05%
2. Sep 30, 2017 $185.04 $0.45 11.75% 2,519.36 1.93%
3. Oct 31, 2017 $208.57 12.72% 2,575.26 2.22%
4. Nov 30, 2017 $192.33 -7.79% 2,647.58 2.81%
5. Dec 31, 2017 $184.07 $0.50 -4.03% 2,673.61 0.98%
6. Jan 31, 2018 $191.52 4.05% 2,823.81 5.62%
7. Feb 28, 2018 $191.86 0.18% 2,713.83 -3.89%
8. Mar 31, 2018 $203.16 $0.50 6.15% 2,640.87 -2.69%
9. Apr 30, 2018 $185.06 -8.91% 2,648.05 0.27%
10. May 31, 2018 $198.18 7.09% 2,705.27 2.16%
11. Jun 30, 2018 $172.85 $1.10 -12.23% 2,718.37 0.48%
12. Jul 31, 2018 $190.64 10.29% 2,816.29 3.60%
13. Aug 31, 2018 $173.09 -9.21% 2,901.52 3.03%
14. Sep 30, 2018 $151.70 $1.10 -11.72% 2,913.98 0.43%
15. Oct 31, 2018 $141.73 -6.57% 2,711.74 -6.94%
16. Nov 30, 2018 $156.96 10.75% 2,760.17 1.79%
17. Dec 31, 2018 $136.17 $1.10 -12.54% 2,506.85 -9.18%
18. Jan 31, 2019 $169.58 24.54% 2,704.10 7.87%
19. Feb 28, 2019 $176.09 3.84% 2,784.49 2.97%
20. Mar 31, 2019 $179.01 $1.10 2.28% 2,834.40 1.79%
21. Apr 30, 2019 $207.43 15.88% 2,945.83 3.93%
22. May 31, 2019 $174.61 -15.82% 2,752.06 -6.58%
23. Jun 30, 2019 $187.84 $1.10 8.21% 2,941.76 6.89%
24. Jul 31, 2019 $208.61 11.06% 2,980.38 1.31%
25. Aug 31, 2019 $210.51 0.91% 2,926.46 -1.81%
26. Sep 30, 2019 $231.11 $1.15 10.33% 2,976.74 1.72%
27. Oct 31, 2019 $271.04 17.28% 3,037.56 2.04%
28. Nov 30, 2019 $266.83 -1.55% 3,140.98 3.40%
29. Dec 31, 2019 $292.40 $1.15 10.01% 3,230.78 2.86%
30. Jan 31, 2020 $298.21 1.99% 3,225.52 -0.16%
31. Feb 29, 2020 $293.43 -1.60% 2,954.22 -8.41%
32. Mar 31, 2020 $240.00 $1.15 -17.82% 2,584.59 -12.51%
33. Apr 30, 2020 $255.28 6.37% 2,912.43 12.68%
34. May 31, 2020 $273.67 7.20% 3,044.31 4.53%
35. Jun 30, 2020 $323.46 $1.15 18.61% 3,100.29 1.84%
36. Jul 31, 2020 $377.16 16.60% 3,271.12 5.51%
37. Aug 31, 2020 $336.34 -10.82% 3,500.31 7.01%
38. Sep 30, 2020 $331.75 $1.30 -0.98% 3,363.00 -3.92%
39. Oct 31, 2020 $342.08 3.11% 3,269.96 -2.77%
40. Nov 30, 2020 $452.66 32.33% 3,621.63 10.75%
41. Dec 31, 2020 $472.27 $1.30 4.62% 3,756.07 3.71%
42. Jan 31, 2021 $483.95 2.47% 3,714.24 -1.11%
43. Feb 28, 2021 $567.19 17.20% 3,811.15 2.61%
44. Mar 31, 2021 $595.24 $1.30 5.17% 3,972.89 4.24%
45. Apr 30, 2021 $620.45 4.24% 4,181.17 5.24%
46. May 31, 2021 $649.85 4.74% 4,204.11 0.55%
47. Jun 30, 2021 $650.70 $1.30 0.33% 4,297.50 2.22%
48. Jul 31, 2021 $637.41 -2.04% 4,395.26 2.27%
49. Aug 31, 2021 $604.82 -5.11% 4,522.68 2.90%
50. Sep 30, 2021 $569.15 $1.50 -5.65% 4,307.54 -4.76%
51. Oct 31, 2021 $563.57 -0.98% 4,605.38 6.91%
52. Nov 30, 2021 $679.85 20.63% 4,567.00 -0.83%
53. Dec 31, 2021 $719.15 $1.50 6.00% 4,766.18 4.36%
54. Jan 31, 2022 $589.92 -17.97% 4,515.55 -5.26%
55. Feb 28, 2022 $561.35 -4.84% 4,373.94 -3.14%
56. Mar 31, 2022 $537.61 $1.50 -3.96% 4,530.41 3.58%
57. Apr 30, 2022 $465.76 -13.36% 4,131.93 -8.80%
58. May 31, 2022 $520.03 11.65% 4,132.15 0.01%
59. Jun 30, 2022 $426.15 $1.50 -17.76% 3,785.38 -8.39%
60. Jul 31, 2022 $500.51 17.45% 4,130.29 9.11%
61. Aug 31, 2022 $437.91 -12.51% 3,955.00 -4.24%
62. Sep 30, 2022 $366.00 $1.725 -16.03% 3,585.62 -9.34%
63. Oct 31, 2022 $404.78 10.60% 3,871.98 7.99%
64. Nov 30, 2022 $472.38 16.70% 4,080.11 5.38%
65. Dec 31, 2022 $420.30 $1.725 -10.66% 3,839.50 -5.90%
66. Jan 31, 2023 $500.10 18.99% 4,076.60 6.18%
67. Feb 28, 2023 $486.01 -2.82% 3,970.15 -2.61%
68. Mar 31, 2023 $530.12 $1.725 9.43% 4,109.31 3.51%
69. Apr 30, 2023 $524.08 -1.14% 4,169.48 1.46%
70. May 31, 2023 $616.70 17.67% 4,179.83 0.25%
71. Jun 30, 2023 $642.86 $1.725 4.52% 4,376.86 4.71%
Average (R): 2.73% 0.94%
Standard deviation: 11.21% 5.05%

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,tRLRCX)2 (RS&P 500,tRS&P 500)2 (RLRCX,tRLRCX)×(RS&P 500,tRS&P 500)
1. Aug 31, 2017 4.09% 0.05% 1.86 0.78 -1.20
2. Sep 30, 2017 11.75% 1.93% 81.50 0.99 8.98
3. Oct 31, 2017 12.72% 2.22% 99.79 1.65 12.82
. . . . . . .
. . . . . . .
. . . . . . .
70. May 31, 2023 17.67% 0.25% 223.39 0.47 -10.28
71. Jun 30, 2023 4.52% 4.71% 3.22 14.27 6.78
Total (Σ): 8,798.65 1,786.26 2,563.12
t Date RLRCX,t RS&P 500,t (RLRCX,tRLRCX)2 (RS&P 500,tRS&P 500)2 (RLRCX,tRLRCX)×(RS&P 500,tRS&P 500)
1. Aug 31, 2017 4.09% 0.05% 1.86 0.78 -1.20
2. Sep 30, 2017 11.75% 1.93% 81.50 0.99 8.98
3. Oct 31, 2017 12.72% 2.22% 99.79 1.65 12.82
4. Nov 30, 2017 -7.79% 2.81% 110.52 3.51 -19.69
5. Dec 31, 2017 -4.03% 0.98% 45.71 0.00 -0.32
6. Jan 31, 2018 4.05% 5.62% 1.74 21.92 6.18
7. Feb 28, 2018 0.18% -3.89% 6.50 23.33 12.31
8. Mar 31, 2018 6.15% -2.69% 11.72 13.14 -12.41
9. Apr 30, 2018 -8.91% 0.27% 135.39 0.44 7.73
10. May 31, 2018 7.09% 2.16% 19.04 1.50 5.34
11. Jun 30, 2018 -12.23% 0.48% 223.59 0.20 6.75
12. Jul 31, 2018 10.29% 3.60% 57.24 7.11 20.17
13. Aug 31, 2018 -9.21% 3.03% 142.38 4.37 -24.95
14. Sep 30, 2018 -11.72% 0.43% 208.77 0.26 7.32
15. Oct 31, 2018 -6.57% -6.94% 86.47 62.03 73.24
16. Nov 30, 2018 10.75% 1.79% 64.31 0.72 6.82
17. Dec 31, 2018 -12.54% -9.18% 233.21 102.28 154.44
18. Jan 31, 2019 24.54% 7.87% 475.63 48.06 151.19
19. Feb 28, 2019 3.84% 2.97% 1.24 4.15 2.27
20. Mar 31, 2019 2.28% 1.79% 0.20 0.73 -0.38
21. Apr 30, 2019 15.88% 3.93% 172.91 8.97 39.39
22. May 31, 2019 -15.82% -6.58% 344.06 56.45 139.37
23. Jun 30, 2019 8.21% 6.89% 30.03 35.49 32.65
24. Jul 31, 2019 11.06% 1.31% 69.40 0.14 3.14
25. Aug 31, 2019 0.91% -1.81% 3.30 7.53 4.98
26. Sep 30, 2019 10.33% 1.72% 57.84 0.61 5.95
27. Oct 31, 2019 17.28% 2.04% 211.73 1.23 16.11
28. Nov 30, 2019 -1.55% 3.40% 18.32 6.10 -10.57
29. Dec 31, 2019 10.01% 2.86% 53.11 3.70 14.01
30. Jan 31, 2020 1.99% -0.16% 0.55 1.21 0.81
31. Feb 29, 2020 -1.60% -8.41% 18.74 87.36 40.47
32. Mar 31, 2020 -17.82% -12.51% 422.03 180.84 276.26
33. Apr 30, 2020 6.37% 12.68% 13.25 138.03 42.77
34. May 31, 2020 7.20% 4.53% 20.05 12.91 16.08
35. Jun 30, 2020 18.61% 1.84% 252.40 0.82 14.35
36. Jul 31, 2020 16.60% 5.51% 192.52 20.92 63.47
37. Aug 31, 2020 -10.82% 7.01% 183.59 36.85 -82.25
38. Sep 30, 2020 -0.98% -3.92% 13.72 23.61 18.00
39. Oct 31, 2020 3.11% -2.77% 0.15 13.71 -1.43
40. Nov 30, 2020 32.33% 10.75% 876.12 96.41 290.63
41. Dec 31, 2020 4.62% 3.71% 3.58 7.71 5.26
42. Jan 31, 2021 2.47% -1.11% 0.06 4.20 0.52
43. Feb 28, 2021 17.20% 2.61% 209.48 2.80 24.22
44. Mar 31, 2021 5.17% 4.24% 5.99 10.94 8.10
45. Apr 30, 2021 4.24% 5.24% 2.28 18.55 6.50
46. May 31, 2021 4.74% 0.55% 4.05 0.15 -0.78
47. Jun 30, 2021 0.33% 2.22% 5.74 1.65 -3.08
48. Jul 31, 2021 -2.04% 2.27% 22.74 1.79 -6.39
49. Aug 31, 2021 -5.11% 2.90% 61.46 3.85 -15.39
50. Sep 30, 2021 -5.65% -4.76% 70.16 32.41 47.68
51. Oct 31, 2021 -0.98% 6.91% 13.74 35.74 -22.16
52. Nov 30, 2021 20.63% -0.83% 320.63 3.13 -31.68
53. Dec 31, 2021 6.00% 4.36% 10.72 11.73 11.22
54. Jan 31, 2022 -17.97% -5.26% 428.34 38.37 128.20
55. Feb 28, 2022 -4.84% -3.14% 57.30 16.58 30.82
56. Mar 31, 2022 -3.96% 3.58% 44.73 6.98 -17.67
57. Apr 30, 2022 -13.36% -8.80% 258.93 94.70 156.59
58. May 31, 2022 11.65% 0.01% 79.66 0.87 -8.30
59. Jun 30, 2022 -17.76% -8.39% 419.88 87.01 191.13
60. Jul 31, 2022 17.45% 9.11% 216.76 66.84 120.37
61. Aug 31, 2022 -12.51% -4.24% 232.07 26.83 78.91
62. Sep 30, 2022 -16.03% -9.34% 351.70 105.58 192.70
63. Oct 31, 2022 10.60% 7.99% 61.92 49.71 55.48
64. Nov 30, 2022 16.70% 5.38% 195.27 19.71 62.04
65. Dec 31, 2022 -10.66% -5.90% 179.20 46.69 91.47
66. Jan 31, 2023 18.99% 6.18% 264.38 27.45 85.19
67. Feb 28, 2023 -2.82% -2.61% 30.74 12.58 19.66
68. Mar 31, 2023 9.43% 3.51% 44.95 6.60 17.23
69. Apr 30, 2023 -1.14% 1.46% 14.95 0.28 -2.04
70. May 31, 2023 17.67% 0.25% 223.39 0.47 -10.28
71. Jun 30, 2023 4.52% 4.71% 3.22 14.27 6.78
Total (Σ): 8,798.65 1,786.26 2,563.12

Show all

VarianceLRCX = Σ(RLRCX,tRLRCX)2 ÷ (71 – 1)
= 8,798.65 ÷ (71 – 1)
= 125.70

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

CovarianceLRCX, S&P 500 = Σ(RLRCX,tRLRCX)×(RS&P 500,tRS&P 500) ÷ (71 – 1)
= 2,563.12 ÷ (71 – 1)
= 36.62


Systematic Risk (β) Estimation

Microsoft Excel
VarianceLRCX 125.70
VarianceS&P 500 25.52
CovarianceLRCX, S&P 500 36.62
Correlation coefficientLRCX, S&P 5001 0.65
βLRCX2 1.43
αLRCX3 1.38%

Calculations

1 Correlation coefficientLRCX, S&P 500
= CovarianceLRCX, S&P 500 ÷ (Standard deviationLRCX × Standard deviationS&P 500)
= 36.62 ÷ (11.21% × 5.05%)
= 0.65

2 βLRCX
= CovarianceLRCX, S&P 500 ÷ VarianceS&P 500
= 36.62 ÷ 25.52
= 1.43

3 αLRCX
= AverageLRCX – βLRCX × AverageS&P 500
= 2.73%1.43 × 0.94%
= 1.38%


Expected Rate of Return

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

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]
= 4.90% + 1.43 [13.55%4.90%]
= 17.31%