Stock Analysis on Net

Lumentum Holdings Inc. (NASDAQ:LITE)

3 minutes left for free

Capital Asset Pricing Model (CAPM)

Microsoft Excel

Rates of Return

Lumentum Holdings Inc., monthly rates of return

Microsoft Excel
Lumentum Holdings Inc. (LITE) Standard & Poor’s 500 (S&P 500)
t Date PriceLITE,t1 DividendLITE,t1 RLITE,t2 PriceS&P 500,t RS&P 500,t3
Jul 31, 2019 $56.63 2,980.38
1. Aug 31, 2019 $55.76 -1.54% 2,926.46 -1.81%
2. Sep 30, 2019 $53.56 -3.95% 2,976.74 1.72%
3. Oct 31, 2019 $62.66 16.99% 3,037.56 2.04%
. . . . . . .
. . . . . . .
. . . . . . .
70. May 31, 2025 $72.28 22.43% 5,911.69 6.15%
71. Jun 30, 2025 $95.06 31.52% 6,204.95 4.96%
Average (R): 1.39% 1.16%
Standard deviation: 11.74% 4.98%
Lumentum Holdings Inc. (LITE) Standard & Poor’s 500 (S&P 500)
t Date PriceLITE,t1 DividendLITE,t1 RLITE,t2 PriceS&P 500,t RS&P 500,t3
Jul 31, 2019 $56.63 2,980.38
1. Aug 31, 2019 $55.76 -1.54% 2,926.46 -1.81%
2. Sep 30, 2019 $53.56 -3.95% 2,976.74 1.72%
3. Oct 31, 2019 $62.66 16.99% 3,037.56 2.04%
4. Nov 30, 2019 $73.66 17.56% 3,140.98 3.40%
5. Dec 31, 2019 $79.30 7.66% 3,230.78 2.86%
6. Jan 31, 2020 $75.77 -4.45% 3,225.52 -0.16%
7. Feb 29, 2020 $77.82 2.71% 2,954.22 -8.41%
8. Mar 31, 2020 $73.70 -5.29% 2,584.59 -12.51%
9. Apr 30, 2020 $80.91 9.78% 2,912.43 12.68%
10. May 31, 2020 $73.32 -9.38% 3,044.31 4.53%
11. Jun 30, 2020 $81.43 11.06% 3,100.29 1.84%
12. Jul 31, 2020 $92.83 14.00% 3,271.12 5.51%
13. Aug 31, 2020 $86.00 -7.36% 3,500.31 7.01%
14. Sep 30, 2020 $75.13 -12.64% 3,363.00 -3.92%
15. Oct 31, 2020 $82.69 10.06% 3,269.96 -2.77%
16. Nov 30, 2020 $86.38 4.46% 3,621.63 10.75%
17. Dec 31, 2020 $94.80 9.75% 3,756.07 3.71%
18. Jan 31, 2021 $93.80 -1.05% 3,714.24 -1.11%
19. Feb 28, 2021 $90.00 -4.05% 3,811.15 2.61%
20. Mar 31, 2021 $91.35 1.50% 3,972.89 4.24%
21. Apr 30, 2021 $85.05 -6.90% 4,181.17 5.24%
22. May 31, 2021 $81.37 -4.33% 4,204.11 0.55%
23. Jun 30, 2021 $82.03 0.81% 4,297.50 2.22%
24. Jul 31, 2021 $83.99 2.39% 4,395.26 2.27%
25. Aug 31, 2021 $86.64 3.16% 4,522.68 2.90%
26. Sep 30, 2021 $83.54 -3.58% 4,307.54 -4.76%
27. Oct 31, 2021 $82.58 -1.15% 4,605.38 6.91%
28. Nov 30, 2021 $86.77 5.07% 4,567.00 -0.83%
29. Dec 31, 2021 $105.77 21.90% 4,766.18 4.36%
30. Jan 31, 2022 $101.48 -4.06% 4,515.55 -5.26%
31. Feb 28, 2022 $98.86 -2.58% 4,373.94 -3.14%
32. Mar 31, 2022 $97.60 -1.27% 4,530.41 3.58%
33. Apr 30, 2022 $81.21 -16.79% 4,131.93 -8.80%
34. May 31, 2022 $86.08 6.00% 4,132.15 0.01%
35. Jun 30, 2022 $79.42 -7.74% 3,785.38 -8.39%
36. Jul 31, 2022 $90.46 13.90% 4,130.29 9.11%
37. Aug 31, 2022 $83.55 -7.64% 3,955.00 -4.24%
38. Sep 30, 2022 $68.57 -17.93% 3,585.62 -9.34%
39. Oct 31, 2022 $74.45 8.58% 3,871.98 7.99%
40. Nov 30, 2022 $54.94 -26.21% 4,080.11 5.38%
41. Dec 31, 2022 $52.17 -5.04% 3,839.50 -5.90%
42. Jan 31, 2023 $60.18 15.35% 4,076.60 6.18%
43. Feb 28, 2023 $53.81 -10.58% 3,970.15 -2.61%
44. Mar 31, 2023 $54.01 0.37% 4,109.31 3.51%
45. Apr 30, 2023 $48.25 -10.66% 4,169.48 1.46%
46. May 31, 2023 $52.90 9.64% 4,179.83 0.25%
47. Jun 30, 2023 $56.73 7.24% 4,376.86 4.71%
48. Jul 31, 2023 $52.36 -7.70% 4,588.96 4.85%
49. Aug 31, 2023 $54.13 3.38% 4,507.66 -1.77%
50. Sep 30, 2023 $45.18 -16.53% 4,288.05 -4.87%
51. Oct 31, 2023 $39.21 -13.21% 4,193.80 -2.20%
52. Nov 30, 2023 $42.80 9.16% 4,567.80 8.92%
53. Dec 31, 2023 $52.42 22.48% 4,769.83 4.42%
54. Jan 31, 2024 $54.94 4.81% 4,845.65 1.59%
55. Feb 29, 2024 $48.47 -11.78% 5,096.27 5.17%
56. Mar 31, 2024 $47.35 -2.31% 5,254.35 3.10%
57. Apr 30, 2024 $43.76 -7.58% 5,035.69 -4.16%
58. May 31, 2024 $43.50 -0.59% 5,277.51 4.80%
59. Jun 30, 2024 $50.92 17.06% 5,460.48 3.47%
60. Jul 31, 2024 $51.78 1.69% 5,522.30 1.13%
61. Aug 31, 2024 $57.61 11.26% 5,648.40 2.28%
62. Sep 30, 2024 $63.38 10.02% 5,762.48 2.02%
63. Oct 31, 2024 $63.87 0.77% 5,705.45 -0.99%
64. Nov 30, 2024 $86.97 36.17% 6,032.38 5.73%
65. Dec 31, 2024 $83.95 -3.47% 5,881.63 -2.50%
66. Jan 31, 2025 $85.06 1.32% 6,040.53 2.70%
67. Feb 28, 2025 $70.33 -17.32% 5,954.50 -1.42%
68. Mar 31, 2025 $62.34 -11.36% 5,611.85 -5.75%
69. Apr 30, 2025 $59.04 -5.29% 5,569.06 -0.76%
70. May 31, 2025 $72.28 22.43% 5,911.69 6.15%
71. Jun 30, 2025 $95.06 31.52% 6,204.95 4.96%
Average (R): 1.39% 1.16%
Standard deviation: 11.74% 4.98%

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

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



Variance and Covariance

Lumentum Holdings Inc., calculation of variance and covariance of returns

Microsoft Excel
t Date RLITE,t RS&P 500,t (RLITE,tRLITE)2 (RS&P 500,tRS&P 500)2 (RLITE,tRLITE)×(RS&P 500,tRS&P 500)
1. Aug 31, 2019 -1.54% -1.81% 8.56 8.82 8.69
2. Sep 30, 2019 -3.95% 1.72% 28.46 0.31 -2.97
3. Oct 31, 2019 16.99% 2.04% 243.39 0.78 13.76
. . . . . . .
. . . . . . .
. . . . . . .
70. May 31, 2025 22.43% 6.15% 442.52 24.91 105.00
71. Jun 30, 2025 31.52% 4.96% 907.63 14.44 114.47
Total (Σ): 9,642.88 1,738.13 1,946.47
t Date RLITE,t RS&P 500,t (RLITE,tRLITE)2 (RS&P 500,tRS&P 500)2 (RLITE,tRLITE)×(RS&P 500,tRS&P 500)
1. Aug 31, 2019 -1.54% -1.81% 8.56 8.82 8.69
2. Sep 30, 2019 -3.95% 1.72% 28.46 0.31 -2.97
3. Oct 31, 2019 16.99% 2.04% 243.39 0.78 13.76
4. Nov 30, 2019 17.56% 3.40% 261.33 5.03 36.27
5. Dec 31, 2019 7.66% 2.86% 39.28 2.88 10.64
6. Jan 31, 2020 -4.45% -0.16% 34.11 1.75 7.73
7. Feb 29, 2020 2.71% -8.41% 1.73 91.63 -12.60
8. Mar 31, 2020 -5.29% -12.51% 44.67 186.95 91.39
9. Apr 30, 2020 9.78% 12.68% 70.45 132.79 96.72
10. May 31, 2020 -9.38% 4.53% 116.00 11.34 -36.26
11. Jun 30, 2020 11.06% 1.84% 93.54 0.46 6.55
12. Jul 31, 2020 14.00% 5.51% 159.02 18.91 54.84
13. Aug 31, 2020 -7.36% 7.01% 76.51 34.17 -51.13
14. Sep 30, 2020 -12.64% -3.92% 196.81 25.85 71.32
15. Oct 31, 2020 10.06% -2.77% 75.22 15.43 -34.07
16. Nov 30, 2020 4.46% 10.75% 9.44 92.03 29.48
17. Dec 31, 2020 9.75% 3.71% 69.86 6.51 21.32
18. Jan 31, 2021 -1.05% -1.11% 5.97 5.17 5.56
19. Feb 28, 2021 -4.05% 2.61% 29.60 2.10 -7.88
20. Mar 31, 2021 1.50% 4.24% 0.01 9.50 0.34
21. Apr 30, 2021 -6.90% 5.24% 68.66 16.66 -33.82
22. May 31, 2021 -4.33% 0.55% 32.68 0.38 3.50
23. Jun 30, 2021 0.81% 2.22% 0.33 1.12 -0.61
24. Jul 31, 2021 2.39% 2.27% 1.00 1.24 1.11
25. Aug 31, 2021 3.16% 2.90% 3.12 3.02 3.07
26. Sep 30, 2021 -3.58% -4.76% 24.67 35.02 29.40
27. Oct 31, 2021 -1.15% 6.91% 6.44 33.10 -14.60
28. Nov 30, 2021 5.07% -0.83% 13.58 3.98 -7.35
29. Dec 31, 2021 21.90% 4.36% 420.56 10.24 65.63
30. Jan 31, 2022 -4.06% -5.26% 29.65 41.21 34.96
31. Feb 28, 2022 -2.58% -3.14% 15.77 18.47 17.06
32. Mar 31, 2022 -1.27% 3.58% 7.10 5.84 -6.44
33. Apr 30, 2022 -16.79% -8.80% 330.60 99.14 181.04
34. May 31, 2022 6.00% 0.01% 21.23 1.34 -5.33
35. Jun 30, 2022 -7.74% -8.39% 83.29 91.26 87.19
36. Jul 31, 2022 13.90% 9.11% 156.54 63.21 99.47
37. Aug 31, 2022 -7.64% -4.24% 81.51 29.22 48.80
38. Sep 30, 2022 -17.93% -9.34% 373.21 110.27 202.86
39. Oct 31, 2022 8.58% 7.99% 51.64 46.58 49.04
40. Nov 30, 2022 -26.21% 5.38% 761.48 17.76 -116.29
41. Dec 31, 2022 -5.04% -5.90% 41.36 49.82 45.39
42. Jan 31, 2023 15.35% 6.18% 195.00 25.14 70.02
43. Feb 28, 2023 -10.58% -2.61% 143.38 14.23 45.17
44. Mar 31, 2023 0.37% 3.51% 1.04 5.49 -2.39
45. Apr 30, 2023 -10.66% 1.46% 145.30 0.09 -3.65
46. May 31, 2023 9.64% 0.25% 68.03 0.83 -7.53
47. Jun 30, 2023 7.24% 4.71% 34.23 12.62 20.79
48. Jul 31, 2023 -7.70% 4.85% 82.67 13.58 -33.50
49. Aug 31, 2023 3.38% -1.77% 3.96 8.60 -5.84
50. Sep 30, 2023 -16.53% -4.87% 321.26 36.40 108.13
51. Oct 31, 2023 -13.21% -2.20% 213.25 11.28 49.05
52. Nov 30, 2023 9.16% 8.92% 60.32 60.17 60.24
53. Dec 31, 2023 22.48% 4.42% 444.67 10.64 68.78
54. Jan 31, 2024 4.81% 1.59% 11.68 0.18 1.46
55. Feb 29, 2024 -11.78% 5.17% 173.34 16.09 -52.81
56. Mar 31, 2024 -2.31% 3.10% 13.69 3.77 -7.18
57. Apr 30, 2024 -7.58% -4.16% 80.48 28.33 47.75
58. May 31, 2024 -0.59% 4.80% 3.93 13.26 -7.22
59. Jun 30, 2024 17.06% 3.47% 245.49 5.32 36.13
60. Jul 31, 2024 1.69% 1.13% 0.09 0.00 -0.01
61. Aug 31, 2024 11.26% 2.28% 97.41 1.26 11.08
62. Sep 30, 2024 10.02% 2.02% 74.41 0.74 7.41
63. Oct 31, 2024 0.77% -0.99% 0.38 4.63 1.33
64. Nov 30, 2024 36.17% 5.73% 1,209.50 20.88 158.90
65. Dec 31, 2024 -3.47% -2.50% 23.64 13.40 17.80
66. Jan 31, 2025 1.32% 2.70% 0.00 2.37 -0.10
67. Feb 28, 2025 -17.32% -1.42% 349.93 6.68 48.36
68. Mar 31, 2025 -11.36% -5.75% 162.56 47.83 88.17
69. Apr 30, 2025 -5.29% -0.76% 44.66 3.70 12.86
70. May 31, 2025 22.43% 6.15% 442.52 24.91 105.00
71. Jun 30, 2025 31.52% 4.96% 907.63 14.44 114.47
Total (Σ): 9,642.88 1,738.13 1,946.47

Show all

VarianceLITE = Σ(RLITE,tRLITE)2 ÷ (71 – 1)
= 9,642.88 ÷ (71 – 1)
= 137.76

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

CovarianceLITE, S&P 500 = Σ(RLITE,tRLITE)×(RS&P 500,tRS&P 500) ÷ (71 – 1)
= 1,946.47 ÷ (71 – 1)
= 27.81



Systematic Risk (β) Estimation

Microsoft Excel
VarianceLITE 137.76
VarianceS&P 500 24.83
CovarianceLITE, S&P 500 27.81
Correlation coefficientLITE, S&P 5001 0.48
βLITE2 1.12
αLITE3 0.09%

Calculations

1 Correlation coefficientLITE, S&P 500
= CovarianceLITE, S&P 500 ÷ (Standard deviationLITE × Standard deviationS&P 500)
= 27.81 ÷ (11.74% × 4.98%)
= 0.48

2 βLITE
= CovarianceLITE, S&P 500 ÷ VarianceS&P 500
= 27.81 ÷ 24.83
= 1.12

3 αLITE
= AverageLITE – βLITE × AverageS&P 500
= 1.39%1.12 × 1.16%
= 0.09%



Expected Rate of Return

Microsoft Excel
Assumptions
Rate of return on LT Treasury Composite1 RF 4.88%
Expected rate of return on market portfolio2 E(RM) 17.51%
Systematic risk (β) of Lumentum Holdings Inc. common stock βLITE 1.12
 
Expected rate of return on Lumentum Holdings Inc. common stock3 E(RLITE) 19.03%

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(RLITE) = RF + βLITE [E(RM) – RF]
= 4.88% + 1.12 [17.51%4.88%]
= 19.03%