Stock Analysis on Net

Shockwave Medical Inc. (NASDAQ:SWAV)

Capital Asset Pricing Model (CAPM)

Microsoft Excel

Rates of Return

Shockwave Medical Inc., monthly rates of return

Microsoft Excel
Shockwave Medical Inc. (SWAV) Standard & Poor’s 500 (S&P 500)
t Date PriceSWAV,t1 DividendSWAV,t1 RSWAV,t2 PriceS&P 500,t RS&P 500,t3
Mar 31, 2019 $33.47 2,834.40
1. Apr 30, 2019 $42.61 27.31% 2,945.83 3.93%
2. May 31, 2019 $59.79 40.32% 2,752.06 -6.58%
3. Jun 30, 2019 $57.09 -4.52% 2,941.76 6.89%
. . . . . . .
. . . . . . .
. . . . . . .
56. Nov 30, 2023 $174.55 -15.37% 4,567.80 8.92%
57. Dec 31, 2023 $190.56 9.17% 4,769.83 4.42%
Average (R): 4.41% 1.06%
Standard deviation: 16.74% 5.40%
Shockwave Medical Inc. (SWAV) Standard & Poor’s 500 (S&P 500)
t Date PriceSWAV,t1 DividendSWAV,t1 RSWAV,t2 PriceS&P 500,t RS&P 500,t3
Mar 31, 2019 $33.47 2,834.40
1. Apr 30, 2019 $42.61 27.31% 2,945.83 3.93%
2. May 31, 2019 $59.79 40.32% 2,752.06 -6.58%
3. Jun 30, 2019 $57.09 -4.52% 2,941.76 6.89%
4. Jul 31, 2019 $48.92 -14.31% 2,980.38 1.31%
5. Aug 31, 2019 $41.85 -14.45% 2,926.46 -1.81%
6. Sep 30, 2019 $29.93 -28.48% 2,976.74 1.72%
7. Oct 31, 2019 $34.02 13.67% 3,037.56 2.04%
8. Nov 30, 2019 $39.16 15.11% 3,140.98 3.40%
9. Dec 31, 2019 $43.92 12.16% 3,230.78 2.86%
10. Jan 31, 2020 $43.42 -1.14% 3,225.52 -0.16%
11. Feb 29, 2020 $40.14 -7.55% 2,954.22 -8.41%
12. Mar 31, 2020 $33.18 -17.34% 2,584.59 -12.51%
13. Apr 30, 2020 $40.12 20.92% 2,912.43 12.68%
14. May 31, 2020 $44.01 9.70% 3,044.31 4.53%
15. Jun 30, 2020 $47.37 7.63% 3,100.29 1.84%
16. Jul 31, 2020 $49.32 4.12% 3,271.12 5.51%
17. Aug 31, 2020 $63.54 28.83% 3,500.31 7.01%
18. Sep 30, 2020 $75.80 19.29% 3,363.00 -3.92%
19. Oct 31, 2020 $68.32 -9.87% 3,269.96 -2.77%
20. Nov 30, 2020 $97.83 43.19% 3,621.63 10.75%
21. Dec 31, 2020 $103.72 6.02% 3,756.07 3.71%
22. Jan 31, 2021 $116.04 11.88% 3,714.24 -1.11%
23. Feb 28, 2021 $116.76 0.62% 3,811.15 2.61%
24. Mar 31, 2021 $130.26 11.56% 3,972.89 4.24%
25. Apr 30, 2021 $163.46 25.49% 4,181.17 5.24%
26. May 31, 2021 $179.90 10.06% 4,204.11 0.55%
27. Jun 30, 2021 $189.73 5.46% 4,297.50 2.22%
28. Jul 31, 2021 $182.00 -4.07% 4,395.26 2.27%
29. Aug 31, 2021 $214.21 17.70% 4,522.68 2.90%
30. Sep 30, 2021 $205.88 -3.89% 4,307.54 -4.76%
31. Oct 31, 2021 $213.70 3.80% 4,605.38 6.91%
32. Nov 30, 2021 $180.24 -15.66% 4,567.00 -0.83%
33. Dec 31, 2021 $178.33 -1.06% 4,766.18 4.36%
34. Jan 31, 2022 $144.97 -18.71% 4,515.55 -5.26%
35. Feb 28, 2022 $177.23 22.25% 4,373.94 -3.14%
36. Mar 31, 2022 $207.36 17.00% 4,530.41 3.58%
37. Apr 30, 2022 $151.13 -27.12% 4,131.93 -8.80%
38. May 31, 2022 $164.21 8.65% 4,132.15 0.01%
39. Jun 30, 2022 $191.17 16.42% 3,785.38 -8.39%
40. Jul 31, 2022 $210.93 10.34% 4,130.29 9.11%
41. Aug 31, 2022 $296.86 40.74% 3,955.00 -4.24%
42. Sep 30, 2022 $278.07 -6.33% 3,585.62 -9.34%
43. Oct 31, 2022 $293.15 5.42% 3,871.98 7.99%
44. Nov 30, 2022 $253.60 -13.49% 4,080.11 5.38%
45. Dec 31, 2022 $205.61 -18.92% 3,839.50 -5.90%
46. Jan 31, 2023 $187.93 -8.60% 4,076.60 6.18%
47. Feb 28, 2023 $190.24 1.23% 3,970.15 -2.61%
48. Mar 31, 2023 $216.83 13.98% 4,109.31 3.51%
49. Apr 30, 2023 $290.16 33.82% 4,169.48 1.46%
50. May 31, 2023 $275.09 -5.19% 4,179.83 0.25%
51. Jun 30, 2023 $285.41 3.75% 4,376.86 4.71%
52. Jul 31, 2023 $260.60 -8.69% 4,588.96 4.85%
53. Aug 31, 2023 $220.39 -15.43% 4,507.66 -1.77%
54. Sep 30, 2023 $199.10 -9.66% 4,288.05 -4.87%
55. Oct 31, 2023 $206.26 3.60% 4,193.80 -2.20%
56. Nov 30, 2023 $174.55 -15.37% 4,567.80 8.92%
57. Dec 31, 2023 $190.56 9.17% 4,769.83 4.42%
Average (R): 4.41% 1.06%
Standard deviation: 16.74% 5.40%

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

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


Variance and Covariance

Shockwave Medical Inc., calculation of variance and covariance of returns

Microsoft Excel
t Date RSWAV,t RS&P 500,t (RSWAV,tRSWAV)2 (RS&P 500,tRS&P 500)2 (RSWAV,tRSWAV)×(RS&P 500,tRS&P 500)
1. Apr 30, 2019 27.31% 3.93% 524.35 8.24 65.73
2. May 31, 2019 40.32% -6.58% 1,289.51 58.35 -274.31
3. Jun 30, 2019 -4.52% 6.89% 79.66 34.01 -52.05
. . . . . . .
. . . . . . .
. . . . . . .
56. Nov 30, 2023 -15.37% 8.92% 391.38 61.73 -155.43
57. Dec 31, 2023 9.17% 4.42% 22.68 11.30 16.01
Total (Σ): 15,687.25 1,630.23 1,407.34
t Date RSWAV,t RS&P 500,t (RSWAV,tRSWAV)2 (RS&P 500,tRS&P 500)2 (RSWAV,tRSWAV)×(RS&P 500,tRS&P 500)
1. Apr 30, 2019 27.31% 3.93% 524.35 8.24 65.73
2. May 31, 2019 40.32% -6.58% 1,289.51 58.35 -274.31
3. Jun 30, 2019 -4.52% 6.89% 79.66 34.01 -52.05
4. Jul 31, 2019 -14.31% 1.31% 350.44 0.06 -4.71
5. Aug 31, 2019 -14.45% -1.81% 355.76 8.24 54.14
6. Sep 30, 2019 -28.48% 1.72% 1,081.89 0.43 -21.61
7. Oct 31, 2019 13.67% 2.04% 85.67 0.96 9.09
8. Nov 30, 2019 15.11% 3.40% 114.48 5.49 25.08
9. Dec 31, 2019 12.16% 2.86% 60.00 3.23 13.93
10. Jan 31, 2020 -1.14% -0.16% 30.78 1.50 6.79
11. Feb 29, 2020 -7.55% -8.41% 143.13 89.72 113.32
12. Mar 31, 2020 -17.34% -12.51% 473.01 184.23 295.20
13. Apr 30, 2020 20.92% 12.68% 272.47 135.10 191.86
14. May 31, 2020 9.70% 4.53% 27.95 12.02 18.33
15. Jun 30, 2020 7.63% 1.84% 10.40 0.60 2.51
16. Jul 31, 2020 4.12% 5.51% 0.09 19.79 -1.30
17. Aug 31, 2020 28.83% 7.01% 596.47 35.35 145.20
18. Sep 30, 2020 19.29% -3.92% 221.58 24.84 -74.19
19. Oct 31, 2020 -9.87% -2.77% 203.85 14.65 54.65
20. Nov 30, 2020 43.19% 10.75% 1,504.23 93.96 375.96
21. Dec 31, 2020 6.02% 3.71% 2.60 7.03 4.27
22. Jan 31, 2021 11.88% -1.11% 55.78 4.73 -16.24
23. Feb 28, 2021 0.62% 2.61% 14.36 2.40 -5.87
24. Mar 31, 2021 11.56% 4.24% 51.16 10.13 22.77
25. Apr 30, 2021 25.49% 5.24% 444.28 17.48 88.14
26. May 31, 2021 10.06% 0.55% 31.90 0.26 -2.89
27. Jun 30, 2021 5.46% 2.22% 1.11 1.35 1.22
28. Jul 31, 2021 -4.07% 2.27% 71.97 1.47 -10.30
29. Aug 31, 2021 17.70% 2.90% 176.58 3.38 24.42
30. Sep 30, 2021 -3.89% -4.76% 68.86 33.85 48.28
31. Oct 31, 2021 3.80% 6.91% 0.37 34.26 -3.58
32. Nov 30, 2021 -15.66% -0.83% 402.68 3.59 38.02
33. Dec 31, 2021 -1.06% 4.36% 29.91 10.89 -18.05
34. Jan 31, 2022 -18.71% -5.26% 534.36 39.94 146.08
35. Feb 28, 2022 22.25% -3.14% 318.39 17.62 -74.89
36. Mar 31, 2022 17.00% 3.58% 158.54 6.33 31.68
37. Apr 30, 2022 -27.12% -8.80% 993.92 97.15 310.75
38. May 31, 2022 8.65% 0.01% 18.02 1.11 -4.48
39. Jun 30, 2022 16.42% -8.39% 144.21 89.36 -113.52
40. Jul 31, 2022 10.34% 9.11% 35.13 64.81 47.72
41. Aug 31, 2022 40.74% -4.24% 1,319.81 28.14 -192.73
42. Sep 30, 2022 -6.33% -9.34% 115.33 108.17 111.69
43. Oct 31, 2022 5.42% 7.99% 1.03 47.96 7.02
44. Nov 30, 2022 -13.49% 5.38% 320.44 18.61 -77.23
45. Dec 31, 2022 -18.92% -5.90% 544.43 48.42 162.36
46. Jan 31, 2023 -8.60% 6.18% 169.21 26.16 -66.53
47. Feb 28, 2023 1.23% -2.61% 10.11 13.49 11.68
48. Mar 31, 2023 13.98% 3.51% 91.54 5.97 23.38
49. Apr 30, 2023 33.82% 1.46% 864.93 0.16 11.86
50. May 31, 2023 -5.19% 0.25% 92.22 0.66 7.81
51. Jun 30, 2023 3.75% 4.71% 0.43 13.34 -2.40
52. Jul 31, 2023 -8.69% 4.85% 171.67 14.33 -49.59
53. Aug 31, 2023 -15.43% -1.77% 393.59 8.02 56.20
54. Sep 30, 2023 -9.66% -4.87% 197.95 35.20 83.47
55. Oct 31, 2023 3.60% -2.20% 0.66 10.62 2.65
56. Nov 30, 2023 -15.37% 8.92% 391.38 61.73 -155.43
57. Dec 31, 2023 9.17% 4.42% 22.68 11.30 16.01
Total (Σ): 15,687.25 1,630.23 1,407.34

Show all

VarianceSWAV = Σ(RSWAV,tRSWAV)2 ÷ (57 – 1)
= 15,687.25 ÷ (57 – 1)
= 280.13

VarianceS&P 500 = Σ(RS&P 500,tRS&P 500)2 ÷ (57 – 1)
= 1,630.23 ÷ (57 – 1)
= 29.11

CovarianceSWAV, S&P 500 = Σ(RSWAV,tRSWAV)×(RS&P 500,tRS&P 500) ÷ (57 – 1)
= 1,407.34 ÷ (57 – 1)
= 25.13


Systematic Risk (β) Estimation

Microsoft Excel
VarianceSWAV 280.13
VarianceS&P 500 29.11
CovarianceSWAV, S&P 500 25.13
Correlation coefficientSWAV, S&P 5001 0.28
βSWAV2 0.86
αSWAV3 3.49%

Calculations

1 Correlation coefficientSWAV, S&P 500
= CovarianceSWAV, S&P 500 ÷ (Standard deviationSWAV × Standard deviationS&P 500)
= 25.13 ÷ (16.74% × 5.40%)
= 0.28

2 βSWAV
= CovarianceSWAV, S&P 500 ÷ VarianceS&P 500
= 25.13 ÷ 29.11
= 0.86

3 αSWAV
= AverageSWAV – βSWAV × AverageS&P 500
= 4.41%0.86 × 1.06%
= 3.49%


Expected Rate of Return

Microsoft Excel
Assumptions
Rate of return on LT Treasury Composite1 RF 4.72%
Expected rate of return on market portfolio2 E(RM) 13.51%
Systematic risk (β) of Shockwave Medical Inc. common stock βSWAV 0.86
 
Expected rate of return on Shockwave Medical Inc. common stock3 E(RSWAV) 12.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(RSWAV) = RF + βSWAV [E(RM) – RF]
= 4.72% + 0.86 [13.51%4.72%]
= 12.31%