資本資産価格モデル(CAPM)は、 Baxter普通株式などのリスク資産の期待収益率または必要な収益率を示します。
収益率
Baxter International Inc. (BAX) | Standard & Poor’s 500 (S&P 500) | |||||
---|---|---|---|---|---|---|
t | 日付 | 価格BAX,t1 | 配当BAX,t1 | RBAX,t2 | 価格S&P 500,t | RS&P 500,t3 |
2011/01/31 | $48.49 | 1,286.12 | ||||
1. | 2011/02/28 | $53.15 | 9.61% | 1,327.22 | 3.20% | |
2. | 2011/03/31 | $53.77 | $0.31 | 1.75% | 1,325.83 | -0.10% |
3. | 2011/04/30 | $56.90 | 5.82% | 1,363.61 | 2.85% | |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
58. | 2015/11/30 | $37.65 | 0.70% | 2,080.41 | 0.05% | |
59. | 2015/12/31 | $38.15 | $0.115 | 1.63% | 2,043.94 | -1.75% |
平均 (R): | 0.15% | 0.84% | ||||
標準偏差: | 7.55% | 3.40% |
Baxter International Inc. (BAX) | Standard & Poor’s 500 (S&P 500) | |||||
---|---|---|---|---|---|---|
t | 日付 | 価格BAX,t1 | 配当BAX,t1 | RBAX,t2 | 価格S&P 500,t | RS&P 500,t3 |
2011/01/31 | $48.49 | 1,286.12 | ||||
1. | 2011/02/28 | $53.15 | 9.61% | 1,327.22 | 3.20% | |
2. | 2011/03/31 | $53.77 | $0.31 | 1.75% | 1,325.83 | -0.10% |
3. | 2011/04/30 | $56.90 | 5.82% | 1,363.61 | 2.85% | |
4. | 2011/05/31 | $59.52 | 4.60% | 1,345.20 | -1.35% | |
5. | 2011/06/30 | $59.69 | $0.31 | 0.81% | 1,320.64 | -1.83% |
6. | 2011/07/31 | $58.17 | -2.55% | 1,292.28 | -2.15% | |
7. | 2011/08/31 | $55.98 | -3.76% | 1,218.89 | -5.68% | |
8. | 2011/09/30 | $56.14 | $0.31 | 0.84% | 1,131.42 | -7.18% |
9. | 2011/10/31 | $54.98 | -2.07% | 1,253.30 | 10.77% | |
10. | 2011/11/30 | $51.66 | -6.04% | 1,246.96 | -0.51% | |
11. | 2011/12/31 | $49.48 | $0.335 | -3.57% | 1,257.60 | 0.85% |
12. | 2012/01/31 | $55.48 | 12.13% | 1,312.41 | 4.36% | |
13. | 2012/02/29 | $58.13 | 4.78% | 1,365.68 | 4.06% | |
14. | 2012/03/31 | $59.78 | $0.335 | 3.41% | 1,408.47 | 3.13% |
15. | 2012/04/30 | $55.41 | -7.31% | 1,397.91 | -0.75% | |
16. | 2012/05/31 | $50.62 | -8.64% | 1,310.33 | -6.27% | |
17. | 2012/06/30 | $53.15 | $0.335 | 5.66% | 1,362.16 | 3.96% |
18. | 2012/07/31 | $58.51 | 10.08% | 1,379.32 | 1.26% | |
19. | 2012/08/31 | $58.68 | 0.29% | 1,406.58 | 1.98% | |
20. | 2012/09/30 | $60.27 | $0.45 | 3.48% | 1,440.67 | 2.42% |
21. | 2012/10/31 | $62.63 | 3.92% | 1,412.16 | -1.98% | |
22. | 2012/11/30 | $66.27 | 5.81% | 1,416.18 | 0.28% | |
23. | 2012/12/31 | $66.66 | $0.45 | 1.27% | 1,426.19 | 0.71% |
24. | 2013/01/31 | $67.84 | 1.77% | 1,498.11 | 5.04% | |
25. | 2013/02/28 | $67.60 | -0.35% | 1,514.68 | 1.11% | |
26. | 2013/03/31 | $72.64 | $0.45 | 8.12% | 1,569.19 | 3.60% |
27. | 2013/04/30 | $69.87 | -3.81% | 1,597.57 | 1.81% | |
28. | 2013/05/31 | $70.33 | 0.66% | 1,630.74 | 2.08% | |
29. | 2013/06/30 | $69.27 | $0.49 | -0.81% | 1,606.28 | -1.50% |
30. | 2013/07/31 | $73.04 | 5.44% | 1,685.73 | 4.95% | |
31. | 2013/08/31 | $69.56 | -4.76% | 1,632.97 | -3.13% | |
32. | 2013/09/30 | $65.69 | $0.49 | -4.86% | 1,681.55 | 2.97% |
33. | 2013/10/31 | $65.87 | 0.27% | 1,756.54 | 4.46% | |
34. | 2013/11/30 | $68.45 | 3.92% | 1,805.81 | 2.80% | |
35. | 2013/12/31 | $69.55 | $0.49 | 2.32% | 1,848.36 | 2.36% |
36. | 2014/01/31 | $68.30 | -1.80% | 1,782.59 | -3.56% | |
37. | 2014/02/28 | $69.50 | 1.76% | 1,859.45 | 4.31% | |
38. | 2014/03/31 | $73.58 | $0.49 | 6.58% | 1,872.34 | 0.69% |
39. | 2014/04/30 | $72.79 | -1.07% | 1,883.95 | 0.62% | |
40. | 2014/05/31 | $74.41 | 2.23% | 1,923.57 | 2.10% | |
41. | 2014/06/30 | $72.30 | $0.52 | -2.14% | 1,960.23 | 1.91% |
42. | 2014/07/31 | $74.69 | 3.31% | 1,930.67 | -1.51% | |
43. | 2014/08/31 | $74.98 | 0.39% | 2,003.37 | 3.77% | |
44. | 2014/09/30 | $71.77 | $0.52 | -3.59% | 1,972.29 | -1.55% |
45. | 2014/10/31 | $70.14 | -2.27% | 2,018.05 | 2.32% | |
46. | 2014/11/30 | $73.00 | 4.08% | 2,067.56 | 2.45% | |
47. | 2014/12/31 | $73.29 | $0.52 | 1.11% | 2,058.90 | -0.42% |
48. | 2015/01/31 | $70.31 | -4.07% | 1,994.99 | -3.10% | |
49. | 2015/02/28 | $69.15 | -1.65% | 2,104.50 | 5.49% | |
50. | 2015/03/31 | $68.50 | $0.52 | -0.19% | 2,067.89 | -1.74% |
51. | 2015/04/30 | $68.74 | 0.35% | 2,085.51 | 0.85% | |
52. | 2015/05/31 | $66.61 | $0.52 | -2.34% | 2,107.39 | 1.05% |
53. | 2015/06/30 | $69.93 | 4.98% | 2,063.11 | -2.10% | |
54. | 2015/07/31 | $40.08 | -42.69% | 2,103.84 | 1.97% | |
55. | 2015/08/31 | $38.45 | -4.07% | 1,972.18 | -6.26% | |
56. | 2015/09/30 | $32.85 | $0.115 | -14.27% | 1,920.03 | -2.64% |
57. | 2015/10/31 | $37.39 | 13.82% | 2,079.36 | 8.30% | |
58. | 2015/11/30 | $37.65 | 0.70% | 2,080.41 | 0.05% | |
59. | 2015/12/31 | $38.15 | $0.115 | 1.63% | 2,043.94 | -1.75% |
平均 (R): | 0.15% | 0.84% | ||||
標準偏差: | 7.55% | 3.40% |
すべて表示
1 普通株式1株当たり米ドルのデータで、分割と株式配当を調整したものです。
2 期間 tにおけるBAXの普通株式の収益率。
3 期間 tにおけるS&P 500(市場ポートフォリオの代理)の収益率。
分散と共分散
t | 日付 | RBAX,t | RS&P 500,t | (RBAX,t–RBAX)2 | (RS&P 500,t–RS&P 500)2 | (RBAX,t–RBAX)×(RS&P 500,t–RS&P 500) |
---|---|---|---|---|---|---|
1. | 2011/02/28 | 9.61% | 3.20% | 89.44 | 5.53 | 22.23 |
2. | 2011/03/31 | 1.75% | -0.10% | 2.55 | 0.90 | -1.52 |
3. | 2011/04/30 | 5.82% | 2.85% | 32.13 | 4.02 | 11.36 |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
58. | 2015/11/30 | 0.70% | 0.05% | 0.29 | 0.63 | -0.43 |
59. | 2015/12/31 | 1.63% | -1.75% | 2.19 | 6.75 | -3.85 |
トータル (Σ): | 3,305.71 | 670.89 | 397.17 |
t | 日付 | RBAX,t | RS&P 500,t | (RBAX,t–RBAX)2 | (RS&P 500,t–RS&P 500)2 | (RBAX,t–RBAX)×(RS&P 500,t–RS&P 500) |
---|---|---|---|---|---|---|
1. | 2011/02/28 | 9.61% | 3.20% | 89.44 | 5.53 | 22.23 |
2. | 2011/03/31 | 1.75% | -0.10% | 2.55 | 0.90 | -1.52 |
3. | 2011/04/30 | 5.82% | 2.85% | 32.13 | 4.02 | 11.36 |
4. | 2011/05/31 | 4.60% | -1.35% | 19.82 | 4.82 | -9.77 |
5. | 2011/06/30 | 0.81% | -1.83% | 0.43 | 7.13 | -1.75 |
6. | 2011/07/31 | -2.55% | -2.15% | 7.29 | 8.95 | 8.08 |
7. | 2011/08/31 | -3.76% | -5.68% | 15.35 | 42.56 | 25.56 |
8. | 2011/09/30 | 0.84% | -7.18% | 0.47 | 64.34 | -5.51 |
9. | 2011/10/31 | -2.07% | 10.77% | 4.92 | 98.56 | -22.03 |
10. | 2011/11/30 | -6.04% | -0.51% | 38.33 | 1.82 | 8.36 |
11. | 2011/12/31 | -3.57% | 0.85% | 13.87 | 0.00 | -0.03 |
12. | 2012/01/31 | 12.13% | 4.36% | 143.36 | 12.35 | 42.07 |
13. | 2012/02/29 | 4.78% | 4.06% | 21.38 | 10.33 | 14.86 |
14. | 2012/03/31 | 3.41% | 3.13% | 10.64 | 5.24 | 7.47 |
15. | 2012/04/30 | -7.31% | -0.75% | 55.69 | 2.54 | 11.90 |
16. | 2012/05/31 | -8.64% | -6.27% | 77.39 | 50.55 | 62.55 |
17. | 2012/06/30 | 5.66% | 3.96% | 30.33 | 9.68 | 17.13 |
18. | 2012/07/31 | 10.08% | 1.26% | 98.64 | 0.17 | 4.12 |
19. | 2012/08/31 | 0.29% | 1.98% | 0.02 | 1.28 | 0.16 |
20. | 2012/09/30 | 3.48% | 2.42% | 11.05 | 2.49 | 5.25 |
21. | 2012/10/31 | 3.92% | -1.98% | 14.16 | 7.97 | -10.63 |
22. | 2012/11/30 | 5.81% | 0.28% | 32.03 | 0.31 | -3.17 |
23. | 2012/12/31 | 1.27% | 0.71% | 1.24 | 0.02 | -0.15 |
24. | 2013/01/31 | 1.77% | 5.04% | 2.62 | 17.62 | 6.79 |
25. | 2013/02/28 | -0.35% | 1.11% | 0.26 | 0.07 | -0.13 |
26. | 2013/03/31 | 8.12% | 3.60% | 63.50 | 7.58 | 21.95 |
27. | 2013/04/30 | -3.81% | 1.81% | 15.73 | 0.93 | -3.82 |
28. | 2013/05/31 | 0.66% | 2.08% | 0.26 | 1.52 | 0.62 |
29. | 2013/06/30 | -0.81% | -1.50% | 0.93 | 5.50 | 2.26 |
30. | 2013/07/31 | 5.44% | 4.95% | 27.98 | 16.82 | 21.70 |
31. | 2013/08/31 | -4.76% | -3.13% | 24.18 | 15.80 | 19.54 |
32. | 2013/09/30 | -4.86% | 2.97% | 25.12 | 4.54 | -10.68 |
33. | 2013/10/31 | 0.27% | 4.46% | 0.01 | 13.07 | 0.44 |
34. | 2013/11/30 | 3.92% | 2.80% | 14.17 | 3.84 | 7.38 |
35. | 2013/12/31 | 2.32% | 2.36% | 4.71 | 2.28 | 3.28 |
36. | 2014/01/31 | -1.80% | -3.56% | 3.80 | 19.39 | 8.59 |
37. | 2014/02/28 | 1.76% | 4.31% | 2.57 | 12.02 | 5.56 |
38. | 2014/03/31 | 6.58% | 0.69% | 41.25 | 0.02 | -0.97 |
39. | 2014/04/30 | -1.07% | 0.62% | 1.50 | 0.05 | 0.28 |
40. | 2014/05/31 | 2.23% | 2.10% | 4.30 | 1.58 | 2.61 |
41. | 2014/06/30 | -2.14% | 1.91% | 5.24 | 1.13 | -2.43 |
42. | 2014/07/31 | 3.31% | -1.51% | 9.94 | 5.54 | -7.42 |
43. | 2014/08/31 | 0.39% | 3.77% | 0.06 | 8.53 | 0.69 |
44. | 2014/09/30 | -3.59% | -1.55% | 13.99 | 5.74 | 8.96 |
45. | 2014/10/31 | -2.27% | 2.32% | 5.88 | 2.18 | -3.58 |
46. | 2014/11/30 | 4.08% | 2.45% | 15.40 | 2.59 | 6.31 |
47. | 2014/12/31 | 1.11% | -0.42% | 0.92 | 1.60 | -1.21 |
48. | 2015/01/31 | -4.07% | -3.10% | 17.80 | 15.59 | 16.66 |
49. | 2015/02/28 | -1.65% | 5.49% | 3.25 | 21.57 | -8.37 |
50. | 2015/03/31 | -0.19% | -1.74% | 0.12 | 6.68 | 0.88 |
51. | 2015/04/30 | 0.35% | 0.85% | 0.04 | 0.00 | 0.00 |
52. | 2015/05/31 | -2.34% | 1.05% | 6.22 | 0.04 | -0.51 |
53. | 2015/06/30 | 4.98% | -2.10% | 23.34 | 8.68 | -14.23 |
54. | 2015/07/31 | -42.69% | 1.97% | 1,835.12 | 1.28 | -48.38 |
55. | 2015/08/31 | -4.07% | -6.26% | 17.80 | 50.45 | 29.97 |
56. | 2015/09/30 | -14.27% | -2.64% | 207.88 | 12.17 | 50.30 |
57. | 2015/10/31 | 13.82% | 8.30% | 186.81 | 55.56 | 101.87 |
58. | 2015/11/30 | 0.70% | 0.05% | 0.29 | 0.63 | -0.43 |
59. | 2015/12/31 | 1.63% | -1.75% | 2.19 | 6.75 | -3.85 |
トータル (Σ): | 3,305.71 | 670.89 | 397.17 |
すべて表示
分散BAX = Σ(RBAX,t–RBAX)2 ÷ (59 – 1)
= 3,305.71 ÷ (59 – 1)
= 57.00
分散S&P 500 = Σ(RS&P 500,t–RS&P 500)2 ÷ (59 – 1)
= 670.89 ÷ (59 – 1)
= 11.57
共 分散BAX, S&P 500 = Σ(RBAX,t–RBAX)×(RS&P 500,t–RS&P 500) ÷ (59 – 1)
= 397.17 ÷ (59 – 1)
= 6.85
システマティックなリスク推定 (β)
分散BAX | 57.00 |
分散S&P 500 | 11.57 |
共 分散BAX, S&P 500 | 6.85 |
相関係数BAX, S&P 5001 | 0.27 |
βBAX2 | 0.59 |
αBAX3 | -0.35% |
計算
1 相関係数BAX, S&P 500
= 共 分散BAX, S&P 500 ÷ (標準偏差BAX × 標準偏差S&P 500)
= 6.85 ÷ (7.55% × 3.40%)
= 0.27
2 βBAX
= 共 分散BAX, S&P 500 ÷ 分散S&P 500
= 6.85 ÷ 11.57
= 0.59
3 αBAX
= 平均BAX – βBAX × 平均S&P 500
= 0.15% – 0.59 × 0.84%
= -0.35%
期待収益率
仮定 | ||
LT国債総合の収益率1 | RF | 4.69% |
市場ポートフォリオの期待収益率2 | E(RM) | 13.79% |
普通株式 Baxter システマティックリスク | βBAX | 0.59 |
バクスター普通株式の期待収益率3 | E(RBAX) | 10.07% |
1 10年以内に期限が到来しない、または償還不能となるすべての発行済み固定利回り米国債の入札利回りの加重平均(リスクフリー・リターン・プロキシ)。
2 詳しく見る »
3 E(RBAX) = RF + βBAX [E(RM) – RF]
= 4.69% + 0.59 [13.79% – 4.69%]
= 10.07%