자본 자산 가격 책정 모델(CAPM)은 Adobe보통주와 같은 위험 자산에 대한 예상 또는 필요한 수익률을 나타냅니다.
수익률
Adobe Inc. (ADBE) | Standard & Poor’s 500 (S&P 500) | |||||
---|---|---|---|---|---|---|
t | 날짜 | 값ADBE,t1 | 피제수ADBE,t1 | RADBE,t2 | 값S&P 500,t | RS&P 500,t3 |
2017. 12. 31. | $175.24 | 2,673.61 | ||||
1. | 2018. 1. 31. | $199.76 | 13.99% | 2,823.81 | 5.62% | |
2. | 2018. 2. 28. | $209.13 | 4.69% | 2,713.83 | -3.89% | |
3. | 2018. 3. 31. | $216.08 | 3.32% | 2,640.87 | -2.69% | |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
70. | 2023. 10. 31. | $532.06 | 4.35% | 4,193.80 | -2.20% | |
71. | 2023. 11. 30. | $611.01 | 14.84% | 4,567.80 | 8.92% | |
평균의 (R): | 2.21% | 0.89% | ||||
표준 편차: | 9.28% | 5.22% |
Adobe Inc. (ADBE) | Standard & Poor’s 500 (S&P 500) | |||||
---|---|---|---|---|---|---|
t | 날짜 | 값ADBE,t1 | 피제수ADBE,t1 | RADBE,t2 | 값S&P 500,t | RS&P 500,t3 |
2017. 12. 31. | $175.24 | 2,673.61 | ||||
1. | 2018. 1. 31. | $199.76 | 13.99% | 2,823.81 | 5.62% | |
2. | 2018. 2. 28. | $209.13 | 4.69% | 2,713.83 | -3.89% | |
3. | 2018. 3. 31. | $216.08 | 3.32% | 2,640.87 | -2.69% | |
4. | 2018. 4. 30. | $221.60 | 2.55% | 2,648.05 | 0.27% | |
5. | 2018. 5. 31. | $249.28 | 12.49% | 2,705.27 | 2.16% | |
6. | 2018. 6. 30. | $243.81 | -2.19% | 2,718.37 | 0.48% | |
7. | 2018. 7. 31. | $244.68 | 0.36% | 2,816.29 | 3.60% | |
8. | 2018. 8. 31. | $263.51 | 7.70% | 2,901.52 | 3.03% | |
9. | 2018. 9. 30. | $269.95 | 2.44% | 2,913.98 | 0.43% | |
10. | 2018. 10. 31. | $245.76 | -8.96% | 2,711.74 | -6.94% | |
11. | 2018. 11. 30. | $250.89 | 2.09% | 2,760.17 | 1.79% | |
12. | 2018. 12. 31. | $226.24 | -9.83% | 2,506.85 | -9.18% | |
13. | 2019. 1. 31. | $247.82 | 9.54% | 2,704.10 | 7.87% | |
14. | 2019. 2. 28. | $262.50 | 5.92% | 2,784.49 | 2.97% | |
15. | 2019. 3. 31. | $266.49 | 1.52% | 2,834.40 | 1.79% | |
16. | 2019. 4. 30. | $289.25 | 8.54% | 2,945.83 | 3.93% | |
17. | 2019. 5. 31. | $270.90 | -6.34% | 2,752.06 | -6.58% | |
18. | 2019. 6. 30. | $294.65 | 8.77% | 2,941.76 | 6.89% | |
19. | 2019. 7. 31. | $298.86 | 1.43% | 2,980.38 | 1.31% | |
20. | 2019. 8. 31. | $284.51 | -4.80% | 2,926.46 | -1.81% | |
21. | 2019. 9. 30. | $276.25 | -2.90% | 2,976.74 | 1.72% | |
22. | 2019. 10. 31. | $277.93 | 0.61% | 3,037.56 | 2.04% | |
23. | 2019. 11. 30. | $309.53 | 11.37% | 3,140.98 | 3.40% | |
24. | 2019. 12. 31. | $329.81 | 6.55% | 3,230.78 | 2.86% | |
25. | 2020. 1. 31. | $351.14 | 6.47% | 3,225.52 | -0.16% | |
26. | 2020. 2. 29. | $345.12 | -1.71% | 2,954.22 | -8.41% | |
27. | 2020. 3. 31. | $318.24 | -7.79% | 2,584.59 | -12.51% | |
28. | 2020. 4. 30. | $353.64 | 11.12% | 2,912.43 | 12.68% | |
29. | 2020. 5. 31. | $386.60 | 9.32% | 3,044.31 | 4.53% | |
30. | 2020. 6. 30. | $435.31 | 12.60% | 3,100.29 | 1.84% | |
31. | 2020. 7. 31. | $444.32 | 2.07% | 3,271.12 | 5.51% | |
32. | 2020. 8. 31. | $513.39 | 15.55% | 3,500.31 | 7.01% | |
33. | 2020. 9. 30. | $490.43 | -4.47% | 3,363.00 | -3.92% | |
34. | 2020. 10. 31. | $447.10 | -8.84% | 3,269.96 | -2.77% | |
35. | 2020. 11. 30. | $478.47 | 7.02% | 3,621.63 | 10.75% | |
36. | 2020. 12. 31. | $500.12 | 4.52% | 3,756.07 | 3.71% | |
37. | 2021. 1. 31. | $458.77 | -8.27% | 3,714.24 | -1.11% | |
38. | 2021. 2. 28. | $459.67 | 0.20% | 3,811.15 | 2.61% | |
39. | 2021. 3. 31. | $475.37 | 3.42% | 3,972.89 | 4.24% | |
40. | 2021. 4. 30. | $508.34 | 6.94% | 4,181.17 | 5.24% | |
41. | 2021. 5. 31. | $504.58 | -0.74% | 4,204.11 | 0.55% | |
42. | 2021. 6. 30. | $585.64 | 16.06% | 4,297.50 | 2.22% | |
43. | 2021. 7. 31. | $621.63 | 6.15% | 4,395.26 | 2.27% | |
44. | 2021. 8. 31. | $663.70 | 6.77% | 4,522.68 | 2.90% | |
45. | 2021. 9. 30. | $575.72 | -13.26% | 4,307.54 | -4.76% | |
46. | 2021. 10. 31. | $650.36 | 12.96% | 4,605.38 | 6.91% | |
47. | 2021. 11. 30. | $669.85 | 3.00% | 4,567.00 | -0.83% | |
48. | 2021. 12. 31. | $567.06 | -15.35% | 4,766.18 | 4.36% | |
49. | 2022. 1. 31. | $534.30 | -5.78% | 4,515.55 | -5.26% | |
50. | 2022. 2. 28. | $467.68 | -12.47% | 4,373.94 | -3.14% | |
51. | 2022. 3. 31. | $455.62 | -2.58% | 4,530.41 | 3.58% | |
52. | 2022. 4. 30. | $395.95 | -13.10% | 4,131.93 | -8.80% | |
53. | 2022. 5. 31. | $416.48 | 5.18% | 4,132.15 | 0.01% | |
54. | 2022. 6. 30. | $366.06 | -12.11% | 3,785.38 | -8.39% | |
55. | 2022. 7. 31. | $410.12 | 12.04% | 4,130.29 | 9.11% | |
56. | 2022. 8. 31. | $373.44 | -8.94% | 3,955.00 | -4.24% | |
57. | 2022. 9. 30. | $275.20 | -26.31% | 3,585.62 | -9.34% | |
58. | 2022. 10. 31. | $318.50 | 15.73% | 3,871.98 | 7.99% | |
59. | 2022. 11. 30. | $344.93 | 8.30% | 4,080.11 | 5.38% | |
60. | 2022. 12. 31. | $336.53 | -2.44% | 3,839.50 | -5.90% | |
61. | 2023. 1. 31. | $370.34 | 10.05% | 4,076.60 | 6.18% | |
62. | 2023. 2. 28. | $323.95 | -12.53% | 3,970.15 | -2.61% | |
63. | 2023. 3. 31. | $385.37 | 18.96% | 4,109.31 | 3.51% | |
64. | 2023. 4. 30. | $377.56 | -2.03% | 4,169.48 | 1.46% | |
65. | 2023. 5. 31. | $417.79 | 10.66% | 4,179.83 | 0.25% | |
66. | 2023. 6. 30. | $488.99 | 17.04% | 4,376.86 | 4.71% | |
67. | 2023. 7. 31. | $546.17 | 11.69% | 4,588.96 | 4.85% | |
68. | 2023. 8. 31. | $559.34 | 2.41% | 4,507.66 | -1.77% | |
69. | 2023. 9. 30. | $509.90 | -8.84% | 4,288.05 | -4.87% | |
70. | 2023. 10. 31. | $532.06 | 4.35% | 4,193.80 | -2.20% | |
71. | 2023. 11. 30. | $611.01 | 14.84% | 4,567.80 | 8.92% | |
평균의 (R): | 2.21% | 0.89% | ||||
표준 편차: | 9.28% | 5.22% |
모두 보기
1 보통주 주당 미화 달러(USD)로 표시되며, 분할 및 주식 배당금에 대해 조정되었습니다.
2 기간 t 동안 ADBE의 보통주 수익률.
3 기간 t 동안 S&P 500(시장 포트폴리오 프록시)의 수익률.
분산과 공분산
t | 날짜 | RADBE,t | RS&P 500,t | (RADBE,t–RADBE)2 | (RS&P 500,t–RS&P 500)2 | (RADBE,t–RADBE)×(RS&P 500,t–RS&P 500) |
---|---|---|---|---|---|---|
1. | 2018. 1. 31. | 13.99% | 5.62% | 138.88 | 22.33 | 55.69 |
2. | 2018. 2. 28. | 4.69% | -3.89% | 6.17 | 22.92 | -11.89 |
3. | 2018. 3. 31. | 3.32% | -2.69% | 1.25 | 12.82 | -4.00 |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
70. | 2023. 10. 31. | 4.35% | -2.20% | 4.57 | 9.55 | -6.61 |
71. | 2023. 11. 30. | 14.84% | 8.92% | 159.54 | 64.41 | 101.37 |
합계 (Σ): | 6,033.20 | 1,909.09 | 2,514.29 |
t | 날짜 | RADBE,t | RS&P 500,t | (RADBE,t–RADBE)2 | (RS&P 500,t–RS&P 500)2 | (RADBE,t–RADBE)×(RS&P 500,t–RS&P 500) |
---|---|---|---|---|---|---|
1. | 2018. 1. 31. | 13.99% | 5.62% | 138.88 | 22.33 | 55.69 |
2. | 2018. 2. 28. | 4.69% | -3.89% | 6.17 | 22.92 | -11.89 |
3. | 2018. 3. 31. | 3.32% | -2.69% | 1.25 | 12.82 | -4.00 |
4. | 2018. 4. 30. | 2.55% | 0.27% | 0.12 | 0.39 | -0.22 |
5. | 2018. 5. 31. | 12.49% | 2.16% | 105.75 | 1.61 | 13.04 |
6. | 2018. 6. 30. | -2.19% | 0.48% | 19.38 | 0.17 | 1.80 |
7. | 2018. 7. 31. | 0.36% | 3.60% | 3.42 | 7.34 | -5.01 |
8. | 2018. 8. 31. | 7.70% | 3.03% | 30.12 | 4.55 | 11.71 |
9. | 2018. 9. 30. | 2.44% | 0.43% | 0.06 | 0.21 | -0.11 |
10. | 2018. 10. 31. | -8.96% | -6.94% | 124.73 | 61.35 | 87.48 |
11. | 2018. 11. 30. | 2.09% | 1.79% | 0.01 | 0.80 | -0.11 |
12. | 2018. 12. 31. | -9.83% | -9.18% | 144.78 | 101.41 | 121.17 |
13. | 2019. 1. 31. | 9.54% | 7.87% | 53.74 | 48.66 | 51.14 |
14. | 2019. 2. 28. | 5.92% | 2.97% | 13.81 | 4.33 | 7.73 |
15. | 2019. 3. 31. | 1.52% | 1.79% | 0.47 | 0.81 | -0.62 |
16. | 2019. 4. 30. | 8.54% | 3.93% | 40.11 | 9.23 | 19.25 |
17. | 2019. 5. 31. | -6.34% | -6.58% | 73.13 | 55.81 | 63.88 |
18. | 2019. 6. 30. | 8.77% | 6.89% | 43.03 | 36.01 | 39.36 |
19. | 2019. 7. 31. | 1.43% | 1.31% | 0.61 | 0.18 | -0.33 |
20. | 2019. 8. 31. | -4.80% | -1.81% | 49.13 | 7.30 | 18.94 |
21. | 2019. 9. 30. | -2.90% | 1.72% | 26.12 | 0.68 | -4.22 |
22. | 2019. 10. 31. | 0.61% | 2.04% | 2.56 | 1.32 | -1.84 |
23. | 2019. 11. 30. | 11.37% | 3.40% | 83.95 | 6.31 | 23.02 |
24. | 2019. 12. 31. | 6.55% | 2.86% | 18.87 | 3.87 | 8.54 |
25. | 2020. 1. 31. | 6.47% | -0.16% | 18.15 | 1.11 | -4.50 |
26. | 2020. 2. 29. | -1.71% | -8.41% | 15.38 | 86.56 | 36.49 |
27. | 2020. 3. 31. | -7.79% | -12.51% | 99.92 | 179.68 | 133.99 |
28. | 2020. 4. 30. | 11.12% | 12.68% | 79.50 | 139.05 | 105.14 |
29. | 2020. 5. 31. | 9.32% | 4.53% | 50.59 | 13.22 | 25.86 |
30. | 2020. 6. 30. | 12.60% | 1.84% | 108.00 | 0.90 | 9.83 |
31. | 2020. 7. 31. | 2.07% | 5.51% | 0.02 | 21.32 | -0.64 |
32. | 2020. 8. 31. | 15.55% | 7.01% | 177.89 | 37.38 | 81.55 |
33. | 2020. 9. 30. | -4.47% | -3.92% | 44.62 | 23.19 | 32.16 |
34. | 2020. 10. 31. | -8.84% | -2.77% | 121.94 | 13.39 | 40.41 |
35. | 2020. 11. 30. | 7.02% | 10.75% | 23.12 | 97.26 | 47.43 |
36. | 2020. 12. 31. | 4.52% | 3.71% | 5.37 | 7.95 | 6.53 |
37. | 2021. 1. 31. | -8.27% | -1.11% | 109.74 | 4.02 | 21.02 |
38. | 2021. 2. 28. | 0.20% | 2.61% | 4.05 | 2.95 | -3.45 |
39. | 2021. 3. 31. | 3.42% | 4.24% | 1.46 | 11.23 | 4.05 |
40. | 2021. 4. 30. | 6.94% | 5.24% | 22.36 | 18.92 | 20.57 |
41. | 2021. 5. 31. | -0.74% | 0.55% | 8.69 | 0.12 | 1.01 |
42. | 2021. 6. 30. | 16.06% | 2.22% | 192.03 | 1.77 | 18.41 |
43. | 2021. 7. 31. | 6.15% | 2.27% | 15.51 | 1.91 | 5.44 |
44. | 2021. 8. 31. | 6.77% | 2.90% | 20.80 | 4.03 | 9.15 |
45. | 2021. 9. 30. | -13.26% | -4.76% | 239.12 | 31.92 | 87.36 |
46. | 2021. 10. 31. | 12.96% | 6.91% | 115.72 | 36.26 | 64.78 |
47. | 2021. 11. 30. | 3.00% | -0.83% | 0.62 | 2.98 | -1.36 |
48. | 2021. 12. 31. | -15.35% | 4.36% | 308.10 | 12.03 | -60.89 |
49. | 2022. 1. 31. | -5.78% | -5.26% | 63.75 | 37.83 | 49.11 |
50. | 2022. 2. 28. | -12.47% | -3.14% | 215.39 | 16.23 | 59.12 |
51. | 2022. 3. 31. | -2.58% | 3.58% | 22.91 | 7.21 | -12.85 |
52. | 2022. 4. 30. | -13.10% | -8.80% | 234.21 | 93.86 | 148.27 |
53. | 2022. 5. 31. | 5.18% | 0.01% | 8.87 | 0.79 | -2.64 |
54. | 2022. 6. 30. | -12.11% | -8.39% | 204.88 | 86.20 | 132.90 |
55. | 2022. 7. 31. | 12.04% | 9.11% | 96.61 | 67.55 | 80.78 |
56. | 2022. 8. 31. | -8.94% | -4.24% | 124.35 | 26.38 | 57.28 |
57. | 2022. 9. 30. | -26.31% | -9.34% | 813.06 | 104.70 | 291.76 |
58. | 2022. 10. 31. | 15.73% | 7.99% | 182.97 | 50.32 | 95.96 |
59. | 2022. 11. 30. | 8.30% | 5.38% | 37.10 | 20.10 | 27.30 |
60. | 2022. 12. 31. | -2.44% | -5.90% | 21.56 | 46.10 | 31.52 |
61. | 2023. 1. 31. | 10.05% | 6.18% | 61.45 | 27.91 | 41.41 |
62. | 2023. 2. 28. | -12.53% | -2.61% | 217.09 | 12.28 | 51.62 |
63. | 2023. 3. 31. | 18.96% | 3.51% | 280.64 | 6.83 | 43.77 |
64. | 2023. 4. 30. | -2.03% | 1.46% | 17.93 | 0.33 | -2.42 |
65. | 2023. 5. 31. | 10.66% | 0.25% | 71.36 | 0.42 | -5.44 |
66. | 2023. 6. 30. | 17.04% | 4.71% | 220.06 | 14.60 | 56.69 |
67. | 2023. 7. 31. | 11.69% | 4.85% | 89.98 | 15.63 | 37.50 |
68. | 2023. 8. 31. | 2.41% | -1.77% | 0.04 | 7.10 | -0.54 |
69. | 2023. 9. 30. | -8.84% | -4.87% | 122.02 | 33.23 | 63.68 |
70. | 2023. 10. 31. | 4.35% | -2.20% | 4.57 | 9.55 | -6.61 |
71. | 2023. 11. 30. | 14.84% | 8.92% | 159.54 | 64.41 | 101.37 |
합계 (Σ): | 6,033.20 | 1,909.09 | 2,514.29 |
모두 보기
분산ADBE = Σ(RADBE,t–RADBE)2 ÷ (71 – 1)
= 6,033.20 ÷ (71 – 1)
= 86.19
분산S&P 500 = Σ(RS&P 500,t–RS&P 500)2 ÷ (71 – 1)
= 1,909.09 ÷ (71 – 1)
= 27.27
공분산ADBE, S&P 500 = Σ(RADBE,t–RADBE)×(RS&P 500,t–RS&P 500) ÷ (71 – 1)
= 2,514.29 ÷ (71 – 1)
= 35.92
체계적인 위험 추정 (β)
분산ADBE | 86.19 |
분산S&P 500 | 27.27 |
공분산ADBE, S&P 500 | 35.92 |
상관 계수ADBE, S&P 5001 | 0.74 |
βADBE2 | 1.32 |
αADBE3 | 1.03% |
계산
1 상관 계수ADBE, S&P 500
= 공분산ADBE, S&P 500 ÷ (표준 편차ADBE × 표준 편차S&P 500)
= 35.92 ÷ (9.28% × 5.22%)
= 0.74
2 βADBE
= 공분산ADBE, S&P 500 ÷ 분산S&P 500
= 35.92 ÷ 27.27
= 1.32
3 αADBE
= 평균의ADBE – βADBE × 평균의S&P 500
= 2.21% – 1.32 × 0.89%
= 1.03%
기대 수익률
가정 | ||
LT Treasury Composite의 수익률1 | RF | 4.55% |
시장 포트폴리오에 대한 예상 수익률2 | E(RM) | 13.83% |
보통주의 체계적 위험Adobe | βADBE | 1.32 |
Adobe 보통주에 대한 예상 수익률3 | E(RADBE) | 16.77% |
1 10년 이내에 만기가 도래하거나 콜링할 수 없는 모든 미결제 고정 쿠폰 미국 국채에 대한 입찰 수익률의 비가중 평균(무위험 수익률 대리).
2 자세히 보기 »
3 E(RADBE) = RF + βADBE [E(RM) – RF]
= 4.55% + 1.32 [13.83% – 4.55%]
= 16.77%