資本資産価格モデル(CAPM)は、 Kraft Foods Group普通株式などのリスク資産の期待収益率または必要な収益率を示します。
収益率
Kraft Foods Group Inc. (KRFT) | Standard & Poor’s 500 (S&P 500) | |||||
---|---|---|---|---|---|---|
t | 日付 | 価格KRFT,t1 | 配当KRFT,t1 | RKRFT,t2 | 価格S&P 500,t | RS&P 500,t3 |
2012/09/30 | $44.63 | 1,440.67 | ||||
1. | 2012/10/31 | $45.46 | 1.86% | 1,412.16 | -1.98% | |
2. | 2012/11/30 | $45.24 | -0.48% | 1,416.18 | 0.28% | |
3. | 2012/12/31 | $45.47 | $0.50 | 1.61% | 1,426.19 | 0.71% |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
26. | 2014/11/30 | $60.17 | 6.78% | 2,067.56 | 2.45% | |
27. | 2014/12/31 | $62.66 | $0.55 | 5.05% | 2,058.90 | -0.42% |
平均 (R): | 1.69% | 1.36% | ||||
標準偏差: | 4.49% | 2.41% |
Kraft Foods Group Inc. (KRFT) | Standard & Poor’s 500 (S&P 500) | |||||
---|---|---|---|---|---|---|
t | 日付 | 価格KRFT,t1 | 配当KRFT,t1 | RKRFT,t2 | 価格S&P 500,t | RS&P 500,t3 |
2012/09/30 | $44.63 | 1,440.67 | ||||
1. | 2012/10/31 | $45.46 | 1.86% | 1,412.16 | -1.98% | |
2. | 2012/11/30 | $45.24 | -0.48% | 1,416.18 | 0.28% | |
3. | 2012/12/31 | $45.47 | $0.50 | 1.61% | 1,426.19 | 0.71% |
4. | 2013/01/31 | $46.22 | 1.65% | 1,498.11 | 5.04% | |
5. | 2013/02/28 | $48.48 | 4.89% | 1,514.68 | 1.11% | |
6. | 2013/03/31 | $51.53 | $0.50 | 7.32% | 1,569.19 | 3.60% |
7. | 2013/04/30 | $51.49 | -0.08% | 1,597.57 | 1.81% | |
8. | 2013/05/31 | $55.13 | 7.07% | 1,630.74 | 2.08% | |
9. | 2013/06/30 | $55.87 | $0.50 | 2.25% | 1,606.28 | -1.50% |
10. | 2013/07/31 | $56.58 | 1.27% | 1,685.73 | 4.95% | |
11. | 2013/08/31 | $51.77 | -8.50% | 1,632.97 | -3.13% | |
12. | 2013/09/30 | $52.48 | 1.37% | 1,681.55 | 2.97% | |
13. | 2013/10/31 | $54.38 | $0.525 | 4.62% | 1,756.54 | 4.46% |
14. | 2013/11/30 | $53.12 | -2.32% | 1,805.81 | 2.80% | |
15. | 2013/12/31 | $53.91 | $0.525 | 2.48% | 1,848.36 | 2.36% |
16. | 2014/01/31 | $52.35 | -2.89% | 1,782.59 | -3.56% | |
17. | 2014/02/28 | $55.27 | 5.58% | 1,859.45 | 4.31% | |
18. | 2014/03/31 | $56.10 | 1.50% | 1,872.34 | 0.69% | |
19. | 2014/04/30 | $56.86 | $0.525 | 2.29% | 1,883.95 | 0.62% |
20. | 2014/05/31 | $59.46 | 4.57% | 1,923.57 | 2.10% | |
21. | 2014/06/30 | $59.95 | 0.82% | 1,960.23 | 1.91% | |
22. | 2014/07/31 | $53.59 | $0.525 | -9.73% | 1,930.67 | -1.51% |
23. | 2014/08/31 | $58.90 | 9.91% | 2,003.37 | 3.77% | |
24. | 2014/09/30 | $56.40 | -4.24% | 1,972.29 | -1.55% | |
25. | 2014/10/31 | $56.35 | $0.55 | 0.89% | 2,018.05 | 2.32% |
26. | 2014/11/30 | $60.17 | 6.78% | 2,067.56 | 2.45% | |
27. | 2014/12/31 | $62.66 | $0.55 | 5.05% | 2,058.90 | -0.42% |
平均 (R): | 1.69% | 1.36% | ||||
標準偏差: | 4.49% | 2.41% |
すべて表示
1 普通株式1株当たり米ドルのデータで、分割と株式配当を調整したものです。
2 期間 tにおけるKRFTの普通株式の収益率。
3 期間 tにおけるS&P 500(市場ポートフォリオの代理)の収益率。
分散と共分散
t | 日付 | RKRFT,t | RS&P 500,t | (RKRFT,t–RKRFT)2 | (RS&P 500,t–RS&P 500)2 | (RKRFT,t–RKRFT)×(RS&P 500,t–RS&P 500) |
---|---|---|---|---|---|---|
1. | 2012/10/31 | 1.86% | -1.98% | 0.03 | 11.14 | -0.58 |
2. | 2012/11/30 | -0.48% | 0.28% | 4.71 | 1.15 | 2.33 |
3. | 2012/12/31 | 1.61% | 0.71% | 0.01 | 0.43 | 0.05 |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
26. | 2014/11/30 | 6.78% | 2.45% | 25.93 | 1.20 | 5.57 |
27. | 2014/12/31 | 5.05% | -0.42% | 11.33 | 3.16 | -5.98 |
トータル (Σ): | 525.18 | 151.09 | 166.74 |
t | 日付 | RKRFT,t | RS&P 500,t | (RKRFT,t–RKRFT)2 | (RS&P 500,t–RS&P 500)2 | (RKRFT,t–RKRFT)×(RS&P 500,t–RS&P 500) |
---|---|---|---|---|---|---|
1. | 2012/10/31 | 1.86% | -1.98% | 0.03 | 11.14 | -0.58 |
2. | 2012/11/30 | -0.48% | 0.28% | 4.71 | 1.15 | 2.33 |
3. | 2012/12/31 | 1.61% | 0.71% | 0.01 | 0.43 | 0.05 |
4. | 2013/01/31 | 1.65% | 5.04% | 0.00 | 13.57 | -0.14 |
5. | 2013/02/28 | 4.89% | 1.11% | 10.26 | 0.06 | -0.81 |
6. | 2013/03/31 | 7.32% | 3.60% | 31.77 | 5.02 | 12.62 |
7. | 2013/04/30 | -0.08% | 1.81% | 3.11 | 0.20 | -0.79 |
8. | 2013/05/31 | 7.07% | 2.08% | 28.98 | 0.51 | 3.86 |
9. | 2013/06/30 | 2.25% | -1.50% | 0.32 | 8.17 | -1.61 |
10. | 2013/07/31 | 1.27% | 4.95% | 0.17 | 12.87 | -1.49 |
11. | 2013/08/31 | -8.50% | -3.13% | 103.79 | 20.15 | 45.73 |
12. | 2013/09/30 | 1.37% | 2.97% | 0.10 | 2.61 | -0.51 |
13. | 2013/10/31 | 4.62% | 4.46% | 8.61 | 9.61 | 9.10 |
14. | 2013/11/30 | -2.32% | 2.80% | 16.03 | 2.09 | -5.79 |
15. | 2013/12/31 | 2.48% | 2.36% | 0.62 | 0.99 | 0.79 |
16. | 2014/01/31 | -2.89% | -3.56% | 20.98 | 24.18 | 22.52 |
17. | 2014/02/28 | 5.58% | 4.31% | 15.14 | 8.72 | 11.49 |
18. | 2014/03/31 | 1.50% | 0.69% | 0.03 | 0.44 | 0.12 |
19. | 2014/04/30 | 2.29% | 0.62% | 0.36 | 0.55 | -0.45 |
20. | 2014/05/31 | 4.57% | 2.10% | 8.33 | 0.55 | 2.15 |
21. | 2014/06/30 | 0.82% | 1.91% | 0.74 | 0.30 | -0.47 |
22. | 2014/07/31 | -9.73% | -1.51% | 130.41 | 8.22 | 32.74 |
23. | 2014/08/31 | 9.91% | 3.77% | 67.60 | 5.79 | 19.79 |
24. | 2014/09/30 | -4.24% | -1.55% | 35.18 | 8.47 | 17.26 |
25. | 2014/10/31 | 0.89% | 2.32% | 0.64 | 0.92 | -0.77 |
26. | 2014/11/30 | 6.78% | 2.45% | 25.93 | 1.20 | 5.57 |
27. | 2014/12/31 | 5.05% | -0.42% | 11.33 | 3.16 | -5.98 |
トータル (Σ): | 525.18 | 151.09 | 166.74 |
すべて表示
分散KRFT = Σ(RKRFT,t–RKRFT)2 ÷ (27 – 1)
= 525.18 ÷ (27 – 1)
= 20.20
分散S&P 500 = Σ(RS&P 500,t–RS&P 500)2 ÷ (27 – 1)
= 151.09 ÷ (27 – 1)
= 5.81
共 分散KRFT, S&P 500 = Σ(RKRFT,t–RKRFT)×(RS&P 500,t–RS&P 500) ÷ (27 – 1)
= 166.74 ÷ (27 – 1)
= 6.41
システマティックなリスク推定 (β)
分散KRFT | 20.20 |
分散S&P 500 | 5.81 |
共 分散KRFT, S&P 500 | 6.41 |
相関係数KRFT, S&P 5001 | 0.59 |
βKRFT2 | 1.10 |
αKRFT3 | 0.19% |
計算
1 相関係数KRFT, S&P 500
= 共 分散KRFT, S&P 500 ÷ (標準偏差KRFT × 標準偏差S&P 500)
= 6.41 ÷ (4.49% × 2.41%)
= 0.59
2 βKRFT
= 共 分散KRFT, S&P 500 ÷ 分散S&P 500
= 6.41 ÷ 5.81
= 1.10
3 αKRFT
= 平均KRFT – βKRFT × 平均S&P 500
= 1.69% – 1.10 × 1.36%
= 0.19%
期待収益率
仮定 | ||
LT国債総合の収益率1 | RF | 4.67% |
市場ポートフォリオの期待収益率2 | E(RM) | 13.79% |
普通株式 Kraft Foods Group システマティックリスク | βKRFT | 1.10 |
クラフトフーズグループ普通株式の期待収益率3 | E(RKRFT) | 14.73% |
1 10年以内に期限が到来しない、または償還不能となるすべての発行済み固定利回り米国債の入札利回りの加重平均(リスクフリー・リターン・プロキシ)。
2 詳しく見る »
3 E(RKRFT) = RF + βKRFT [E(RM) – RF]
= 4.67% + 1.10 [13.79% – 4.67%]
= 14.73%