Stock Analysis on Net
Stock Analysis on Net

Marvell Technology Inc. (NASDAQ:MRVL)

Capital Asset Pricing Model (CAPM)

Microsoft Excel

Rates of Return

Marvell Technology Inc., monthly rates of return

Microsoft Excel
Marvell Technology Inc. (MRVL) Standard & Poor’s 500 (S&P 500)
t Date PriceMRVL,t1 DividendMRVL,t1 RMRVL,t2 PriceS&P 500,t RS&P 500,t3
Feb 29, 2020 $21.30 2,954.22
1. Mar 31, 2020 $22.63 6.24% 2,584.59 -12.51%
2. Apr 30, 2020 $26.74 $0.06 18.43% 2,912.43 12.68%
3. May 31, 2020 $32.62 21.99% 3,044.31 4.53%
. . . . . . .
. . . . . . .
. . . . . . .
70. Dec 31, 2025 $84.98 -4.94% 6,845.50 -0.05%
71. Jan 31, 2026 $78.92 $0.06 -7.06% 6,939.03 1.37%
Average (R): 2.90% 1.33%
Standard deviation: 14.42% 4.83%
Marvell Technology Inc. (MRVL) Standard & Poor’s 500 (S&P 500)
t Date PriceMRVL,t1 DividendMRVL,t1 RMRVL,t2 PriceS&P 500,t RS&P 500,t3
Feb 29, 2020 $21.30 2,954.22
1. Mar 31, 2020 $22.63 6.24% 2,584.59 -12.51%
2. Apr 30, 2020 $26.74 $0.06 18.43% 2,912.43 12.68%
3. May 31, 2020 $32.62 21.99% 3,044.31 4.53%
4. Jun 30, 2020 $35.06 7.48% 3,100.29 1.84%
5. Jul 31, 2020 $36.47 $0.06 4.19% 3,271.12 5.51%
6. Aug 31, 2020 $38.78 6.33% 3,500.31 7.01%
7. Sep 30, 2020 $39.70 2.37% 3,363.00 -3.92%
8. Oct 31, 2020 $37.51 $0.06 -5.37% 3,269.96 -2.77%
9. Nov 30, 2020 $46.29 23.41% 3,621.63 10.75%
10. Dec 31, 2020 $47.54 $0.06 2.83% 3,756.07 3.71%
11. Jan 31, 2021 $51.46 8.25% 3,714.24 -1.11%
12. Feb 28, 2021 $48.28 -6.18% 3,811.15 2.61%
13. Mar 31, 2021 $48.98 1.45% 3,972.89 4.24%
14. Apr 30, 2021 $45.21 $0.06 -7.57% 4,181.17 5.24%
15. May 31, 2021 $48.30 6.83% 4,204.11 0.55%
16. Jun 30, 2021 $58.33 20.77% 4,297.50 2.22%
17. Jul 31, 2021 $60.51 $0.06 3.84% 4,395.26 2.27%
18. Aug 31, 2021 $61.19 1.12% 4,522.68 2.90%
19. Sep 30, 2021 $60.31 -1.44% 4,307.54 -4.76%
20. Oct 31, 2021 $68.50 $0.06 13.68% 4,605.38 6.91%
21. Nov 30, 2021 $71.17 3.90% 4,567.00 -0.83%
22. Dec 31, 2021 $87.49 22.93% 4,766.18 4.36%
23. Jan 31, 2022 $71.40 $0.06 -18.32% 4,515.55 -5.26%
24. Feb 28, 2022 $68.33 -4.30% 4,373.94 -3.14%
25. Mar 31, 2022 $71.71 4.95% 4,530.41 3.58%
26. Apr 30, 2022 $58.08 $0.06 -18.92% 4,131.93 -8.80%
27. May 31, 2022 $59.15 1.84% 4,132.15 0.01%
28. Jun 30, 2022 $43.53 -26.41% 3,785.38 -8.39%
29. Jul 31, 2022 $55.68 $0.06 28.05% 4,130.29 9.11%
30. Aug 31, 2022 $46.82 -15.91% 3,955.00 -4.24%
31. Sep 30, 2022 $42.91 -8.35% 3,585.62 -9.34%
32. Oct 31, 2022 $39.68 $0.06 -7.39% 3,871.98 7.99%
33. Nov 30, 2022 $46.52 17.24% 4,080.11 5.38%
34. Dec 31, 2022 $37.04 -20.38% 3,839.50 -5.90%
35. Jan 31, 2023 $43.15 $0.06 16.66% 4,076.60 6.18%
36. Feb 28, 2023 $45.15 4.63% 3,970.15 -2.61%
37. Mar 31, 2023 $43.30 -4.10% 4,109.31 3.51%
38. Apr 30, 2023 $39.48 $0.06 -8.68% 4,169.48 1.46%
39. May 31, 2023 $58.49 48.15% 4,179.83 0.25%
40. Jun 30, 2023 $59.78 2.21% 4,376.86 4.71%
41. Jul 31, 2023 $65.13 $0.06 9.05% 4,588.96 4.85%
42. Aug 31, 2023 $58.25 -10.56% 4,507.66 -1.77%
43. Sep 30, 2023 $54.13 -7.07% 4,288.05 -4.87%
44. Oct 31, 2023 $47.22 $0.06 -12.65% 4,193.80 -2.20%
45. Nov 30, 2023 $55.73 18.02% 4,567.80 8.92%
46. Dec 31, 2023 $60.31 8.22% 4,769.83 4.42%
47. Jan 31, 2024 $67.70 $0.06 12.35% 4,845.65 1.59%
48. Feb 29, 2024 $71.66 5.85% 5,096.27 5.17%
49. Mar 31, 2024 $70.88 -1.09% 5,254.35 3.10%
50. Apr 30, 2024 $65.91 $0.06 -6.93% 5,035.69 -4.16%
51. May 31, 2024 $68.81 4.40% 5,277.51 4.80%
52. Jun 30, 2024 $69.90 1.58% 5,460.48 3.47%
53. Jul 31, 2024 $66.98 $0.06 -4.09% 5,522.30 1.13%
54. Aug 31, 2024 $76.24 13.83% 5,648.40 2.28%
55. Sep 30, 2024 $72.12 -5.40% 5,762.48 2.02%
56. Oct 31, 2024 $80.11 $0.06 11.16% 5,705.45 -0.99%
57. Nov 30, 2024 $92.69 15.70% 6,032.38 5.73%
58. Dec 31, 2024 $110.45 19.16% 5,881.63 -2.50%
59. Jan 31, 2025 $112.86 $0.06 2.24% 6,040.53 2.70%
60. Feb 28, 2025 $91.82 -18.64% 5,954.50 -1.42%
61. Mar 31, 2025 $61.57 -32.94% 5,611.85 -5.75%
62. Apr 30, 2025 $58.37 $0.06 -5.10% 5,569.06 -0.76%
63. May 31, 2025 $60.19 3.12% 5,911.69 6.15%
64. Jun 30, 2025 $77.40 28.59% 6,204.95 4.96%
65. Jul 31, 2025 $80.37 $0.06 3.91% 6,339.39 2.17%
66. Aug 31, 2025 $62.87 -21.77% 6,460.26 1.91%
67. Sep 30, 2025 $84.07 33.72% 6,688.46 3.53%
68. Oct 31, 2025 $93.74 $0.06 11.57% 6,840.20 2.27%
69. Nov 30, 2025 $89.40 -4.63% 6,849.09 0.13%
70. Dec 31, 2025 $84.98 -4.94% 6,845.50 -0.05%
71. Jan 31, 2026 $78.92 $0.06 -7.06% 6,939.03 1.37%
Average (R): 2.90% 1.33%
Standard deviation: 14.42% 4.83%

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

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


Variance and Covariance

Marvell Technology Inc., calculation of variance and covariance of returns

Microsoft Excel
t Date RMRVL,t RS&P 500,t (RMRVL,t–RMRVL)2 (RS&P 500,t–RS&P 500)2 (RMRVL,t–RMRVL)×(RS&P 500,t–RS&P 500)
1. Mar 31, 2020 6.24% -12.51% 11.17 191.48 -46.25
2. Apr 30, 2020 18.43% 12.68% 241.02 129.02 176.35
3. May 31, 2020 21.99% 4.53% 364.34 10.26 61.13
. . . . . . .
. . . . . . .
. . . . . . .
70. Dec 31, 2025 -4.94% -0.05% 61.56 1.90 10.81
71. Jan 31, 2026 -7.06% 1.37% 99.25 0.00 -0.41
Total (Σ): 14,563.34 1,636.00 2,649.21
t Date RMRVL,t RS&P 500,t (RMRVL,t–RMRVL)2 (RS&P 500,t–RS&P 500)2 (RMRVL,t–RMRVL)×(RS&P 500,t–RS&P 500)
1. Mar 31, 2020 6.24% -12.51% 11.17 191.48 -46.25
2. Apr 30, 2020 18.43% 12.68% 241.02 129.02 176.35
3. May 31, 2020 21.99% 4.53% 364.34 10.26 61.13
4. Jun 30, 2020 7.48% 1.84% 20.96 0.26 2.35
5. Jul 31, 2020 4.19% 5.51% 1.67 17.51 5.40
6. Aug 31, 2020 6.33% 7.01% 11.78 32.27 19.50
7. Sep 30, 2020 2.37% -3.92% 0.28 27.55 2.78
8. Oct 31, 2020 -5.37% -2.77% 68.35 16.75 33.83
9. Nov 30, 2020 23.41% 10.75% 420.46 88.91 193.34
10. Dec 31, 2020 2.83% 3.71% 0.01 5.70 -0.17
11. Jan 31, 2021 8.25% -1.11% 28.56 5.95 -13.03
12. Feb 28, 2021 -6.18% 2.61% 82.47 1.65 -11.66
13. Mar 31, 2021 1.45% 4.24% 2.11 8.52 -4.24
14. Apr 30, 2021 -7.57% 5.24% 109.76 15.34 -41.04
15. May 31, 2021 6.83% 0.55% 15.47 0.60 -3.06
16. Jun 30, 2021 20.77% 2.22% 319.13 0.80 16.00
17. Jul 31, 2021 3.84% 2.27% 0.88 0.90 0.89
18. Aug 31, 2021 1.12% 2.90% 3.16 2.48 -2.80
19. Sep 30, 2021 -1.44% -4.76% 18.84 37.00 26.40
20. Oct 31, 2021 13.68% 6.91% 116.15 31.23 60.23
21. Nov 30, 2021 3.90% -0.83% 0.99 4.66 -2.15
22. Dec 31, 2021 22.93% 4.36% 401.17 9.22 60.80
23. Jan 31, 2022 -18.32% -5.26% 450.46 43.35 139.74
24. Feb 28, 2022 -4.30% -3.14% 51.86 19.91 32.13
25. Mar 31, 2022 4.95% 3.58% 4.18 5.07 4.60
26. Apr 30, 2022 -18.92% -8.80% 476.35 102.44 220.90
27. May 31, 2022 1.84% 0.01% 1.12 1.74 1.40
28. Jun 30, 2022 -26.41% -8.39% 859.04 94.43 284.82
29. Jul 31, 2022 28.05% 9.11% 632.41 60.62 195.80
30. Aug 31, 2022 -15.91% -4.24% 353.98 31.02 104.79
31. Sep 30, 2022 -8.35% -9.34% 126.63 113.75 120.02
32. Oct 31, 2022 -7.39% 7.99% 105.87 44.37 -68.54
33. Nov 30, 2022 17.24% 5.38% 205.52 16.40 58.06
34. Dec 31, 2022 -20.38% -5.90% 541.97 52.17 168.15
35. Jan 31, 2023 16.66% 6.18% 189.22 23.52 66.71
36. Feb 28, 2023 4.63% -2.61% 3.00 15.50 -6.82
37. Mar 31, 2023 -4.10% 3.51% 48.99 4.75 -15.26
38. Apr 30, 2023 -8.68% 1.46% 134.22 0.02 -1.61
39. May 31, 2023 48.15% 0.25% 2,047.48 1.16 -48.75
40. Jun 30, 2023 2.21% 4.71% 0.48 11.48 -2.36
41. Jul 31, 2023 9.05% 4.85% 37.80 12.39 21.64
42. Aug 31, 2023 -10.56% -1.77% 181.32 9.59 41.71
43. Sep 30, 2023 -7.07% -4.87% 99.50 38.41 61.82
44. Oct 31, 2023 -12.65% -2.20% 242.01 12.42 54.81
45. Nov 30, 2023 18.02% 8.92% 228.62 57.64 114.80
46. Dec 31, 2023 8.22% 4.42% 28.26 9.59 16.47
47. Jan 31, 2024 12.35% 1.59% 89.32 0.07 2.49
48. Feb 29, 2024 5.85% 5.17% 8.69 14.80 11.34
49. Mar 31, 2024 -1.09% 3.10% 15.92 3.16 -7.09
50. Apr 30, 2024 -6.93% -4.16% 96.61 30.11 53.93
51. May 31, 2024 4.40% 4.80% 2.24 12.09 5.21
52. Jun 30, 2024 1.58% 3.47% 1.74 4.59 -2.82
53. Jul 31, 2024 -4.09% 1.13% 48.91 0.04 1.35
54. Aug 31, 2024 13.83% 2.28% 119.31 0.92 10.46
55. Sep 30, 2024 -5.40% 2.02% 68.99 0.48 -5.76
56. Oct 31, 2024 11.16% -0.99% 68.23 5.36 -19.12
57. Nov 30, 2024 15.70% 5.73% 163.88 19.40 56.38
58. Dec 31, 2024 19.16% -2.50% 264.35 14.63 -62.18
59. Jan 31, 2025 2.24% 2.70% 0.44 1.89 -0.92
60. Feb 28, 2025 -18.64% -1.42% 464.16 7.56 59.24
61. Mar 31, 2025 -32.94% -5.75% 1,284.99 50.13 253.80
62. Apr 30, 2025 -5.10% -0.76% 64.03 4.36 16.71
63. May 31, 2025 3.12% 6.15% 0.05 23.30 1.04
64. Jun 30, 2025 28.59% 4.96% 660.02 13.21 93.39
65. Jul 31, 2025 3.91% 2.17% 1.03 0.71 0.85
66. Aug 31, 2025 -21.77% 1.91% 608.91 0.34 -14.34
67. Sep 30, 2025 33.72% 3.53% 949.78 4.87 68.01
68. Oct 31, 2025 11.57% 2.27% 75.20 0.89 8.18
69. Nov 30, 2025 -4.63% 0.13% 56.73 1.43 9.01
70. Dec 31, 2025 -4.94% -0.05% 61.56 1.90 10.81
71. Jan 31, 2026 -7.06% 1.37% 99.25 0.00 -0.41
Total (Σ): 14,563.34 1,636.00 2,649.21

Show all

VarianceMRVL = Σ(RMRVL,t–RMRVL)2 ÷ (71 – 1)
= 14,563.34 ÷ (71 – 1)
= 208.05

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

CovarianceMRVL, S&P 500 = Σ(RMRVL,t–RMRVL)×(RS&P 500,t–RS&P 500) ÷ (71 – 1)
= 2,649.21 ÷ (71 – 1)
= 37.85


Systematic Risk (β) Estimation

Microsoft Excel
VarianceMRVL 208.05
VarianceS&P 500 23.37
CovarianceMRVL, S&P 500 37.85
Correlation coefficientMRVL, S&P 5001 0.54
βMRVL2 1.62
αMRVL3 0.76%

Calculations

1 Correlation coefficientMRVL, S&P 500
= CovarianceMRVL, S&P 500 ÷ (Standard deviationMRVL × Standard deviationS&P 500)
= 37.85 ÷ (14.42% × 4.83%)
= 0.54

2 βMRVL
= CovarianceMRVL, S&P 500 ÷ VarianceS&P 500
= 37.85 ÷ 23.37
= 1.62

3 αMRVL
= AverageMRVL – βMRVL × AverageS&P 500
= 2.90% – 1.62 × 1.33%
= 0.76%


Expected Rate of Return

Microsoft Excel
Assumptions
Rate of return on LT Treasury Composite1 RF 5.64%
Expected rate of return on market portfolio2 E(RM) 17.45%
Systematic risk (β) of Marvell Technology Inc. common stock βMRVL 1.62
 
Expected rate of return on Marvell Technology Inc. common stock3 E(RMRVL) 24.77%

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(RMRVL) = RF + βMRVL [E(RM) – RF]
= 5.64% + 1.62 [17.45% – 5.64%]
= 24.77%