Stock Analysis on Net
Microsoft Excel LibreOffice Calc

General Electric Co. (NYSE:GE)

資本資産価格モデル (CAPM)

中程度の難易度

資本資産価格モデル(CAPM)は、GEの普通株式のようなリスク資産の期待収益率または必要収益率を示します。


収益率

General Electric Co.、毎月の収益率

Microsoft Excel LibreOffice Calc
General Electric Co. (GE) Standard & Poor’s 500 (S&P 500)
t Date 価格GE,t1 配当GE,t1 RGE,t2 価格S&P 500,t RS&P 500,t3
2015/01/31 $23.89 1,994.99
1. 2015/02/28 $25.99 $0.23 9.75% 2,104.50 5.49%
2. 2015/03/31 $24.81 -4.54% 2,067.89 -1.74%
3. 2015/04/30 $27.08 9.15% 2,085.51 0.85%
. . . . . . .
. . . . . . .
. . . . . . .
58. 2019/11/30 $11.27 12.93% 3,140.98 3.40%
59. 2019/12/31 $11.16 $0.01 -0.89% 3,230.78 2.86%
平均 (R): -0.68% 0.88%
Standard deviation: 8.87% 3.45%

ソース: General Electric Co. (NYSE:GE) | CAPM (www.stock-analysis-on.net)

General Electric Co. (GE) Standard & Poor’s 500 (S&P 500)
t Date 価格GE,t1 配当GE,t1 RGE,t2 価格S&P 500,t RS&P 500,t3
2015/01/31 $23.89 1,994.99
1. 2015/02/28 $25.99 $0.23 9.75% 2,104.50 5.49%
2. 2015/03/31 $24.81 -4.54% 2,067.89 -1.74%
3. 2015/04/30 $27.08 9.15% 2,085.51 0.85%
4. 2015/05/31 $27.27 0.70% 2,107.39 1.05%
5. 2015/06/30 $26.57 $0.23 -1.72% 2,063.11 -2.10%
6. 2015/07/31 $26.10 -1.77% 2,103.84 1.97%
7. 2015/08/31 $24.82 -4.90% 1,972.18 -6.26%
8. 2015/09/30 $25.22 $0.23 2.54% 1,920.03 -2.64%
9. 2015/10/31 $28.92 14.67% 2,079.36 8.30%
10. 2015/11/30 $29.94 3.53% 2,080.41 0.05%
11. 2015/12/31 $31.15 $0.23 4.81% 2,043.94 -1.75%
12. 2016/01/31 $29.10 -6.58% 1,940.24 -5.07%
13. 2016/02/29 $29.14 $0.23 0.93% 1,932.23 -0.41%
14. 2016/03/31 $31.79 9.09% 2,059.74 6.60%
15. 2016/04/30 $30.75 -3.27% 2,065.30 0.27%
16. 2016/05/31 $30.23 -1.69% 2,096.95 1.53%
17. 2016/06/30 $31.48 $0.23 4.90% 2,098.86 0.09%
18. 2016/07/31 $31.14 -1.08% 2,173.60 3.56%
19. 2016/08/31 $31.24 0.32% 2,170.95 -0.12%
20. 2016/09/30 $29.62 $0.23 -4.45% 2,168.27 -0.12%
21. 2016/10/31 $29.10 -1.76% 2,126.15 -1.94%
22. 2016/11/30 $30.76 5.70% 2,198.81 3.42%
23. 2016/12/31 $31.60 $0.24 3.51% 2,238.83 1.82%
24. 2017/01/31 $29.70 -6.01% 2,278.87 1.79%
25. 2017/02/28 $29.81 $0.24 1.18% 2,363.64 3.72%
26. 2017/03/31 $29.80 -0.03% 2,362.72 -0.04%
27. 2017/04/30 $28.99 -2.72% 2,384.20 0.91%
28. 2017/05/31 $27.38 -5.55% 2,411.80 1.16%
29. 2017/06/30 $27.01 $0.24 -0.47% 2,423.41 0.48%
30. 2017/07/31 $25.61 -5.18% 2,470.30 1.93%
31. 2017/08/31 $24.55 -4.14% 2,471.65 0.05%
32. 2017/09/30 $24.18 $0.24 -0.53% 2,519.36 1.93%
33. 2017/10/31 $20.16 -16.63% 2,575.26 2.22%
34. 2017/11/30 $18.29 -9.28% 2,647.58 2.81%
35. 2017/12/31 $17.45 $0.12 -3.94% 2,673.61 0.98%
36. 2018/01/31 $16.17 -7.34% 2,823.81 5.62%
37. 2018/02/28 $14.11 $0.12 -12.00% 2,713.83 -3.89%
38. 2018/03/31 $13.48 -4.46% 2,640.87 -2.69%
39. 2018/04/30 $14.07 4.38% 2,648.05 0.27%
40. 2018/05/31 $14.08 0.07% 2,705.27 2.16%
41. 2018/06/30 $13.61 $0.12 -2.49% 2,718.37 0.48%
42. 2018/07/31 $13.63 0.15% 2,816.29 3.60%
43. 2018/08/31 $12.94 -5.06% 2,901.52 3.03%
44. 2018/09/30 $11.29 $0.12 -11.82% 2,913.98 0.43%
45. 2018/10/31 $10.10 -10.54% 2,711.74 -6.94%
46. 2018/11/30 $7.50 -25.74% 2,760.17 1.79%
47. 2018/12/31 $7.57 $0.01 1.07% 2,506.85 -9.18%
48. 2019/01/31 $10.16 34.21% 2,704.10 7.87%
49. 2019/02/28 $10.39 2.26% 2,784.49 2.97%
50. 2019/03/31 $9.99 $0.01 -3.75% 2,834.40 1.79%
51. 2019/04/30 $10.17 1.80% 2,945.83 3.93%
52. 2019/05/31 $9.44 -7.18% 2,752.06 -6.58%
53. 2019/06/30 $10.50 $0.01 11.33% 2,941.76 6.89%
54. 2019/07/31 $10.45 -0.48% 2,980.38 1.31%
55. 2019/08/31 $8.25 -21.05% 2,926.46 -1.81%
56. 2019/09/30 $8.94 $0.01 8.48% 2,976.74 1.72%
57. 2019/10/31 $9.98 11.63% 3,037.56 2.04%
58. 2019/11/30 $11.27 12.93% 3,140.98 3.40%
59. 2019/12/31 $11.16 $0.01 -0.89% 3,230.78 2.86%
平均 (R): -0.68% 0.88%
Standard deviation: 8.87% 3.45%

ソース: General Electric Co. (NYSE:GE) | CAPM (www.stock-analysis-on.net)

すべて表示する

1 分割および株式配当を調整した、1株当たりの米ドルでのデータ。

2 期間tにおけるGEの普通株の収益率。

3 期間tにおける S&P 500(市場ポートフォリオプロキシ)の収益率。


分散と共分散

General Electric Co.、リターンの分散と共分散の計算

Microsoft Excel LibreOffice Calc
t Date RGE,t RS&P 500,t (RGE,tRGE)2 (RS&P 500,tRS&P 500)2 (RGE,tRGE)×(RS&P 500,tRS&P 500)
1. 2015/02/28 9.75% 5.49% 108.79 21.25 48.08
2. 2015/03/31 -4.54% -1.74% 14.92 6.86 10.12
3. 2015/04/30 9.15% 0.85% 96.56 0.00 -0.27
. . . . . . .
. . . . . . .
. . . . . . .
58. 2019/11/30 12.93% 3.40% 185.04 6.38 34.36
59. 2019/12/31 -0.89% 2.86% 0.04 3.92 -0.42
合計 (Σ): 4,567.01 688.77 799.16
t Date RGE,t RS&P 500,t (RGE,tRGE)2 (RS&P 500,tRS&P 500)2 (RGE,tRGE)×(RS&P 500,tRS&P 500)
1. 2015/02/28 9.75% 5.49% 108.79 21.25 48.08
2. 2015/03/31 -4.54% -1.74% 14.92 6.86 10.12
3. 2015/04/30 9.15% 0.85% 96.56 0.00 -0.27
4. 2015/05/31 0.70% 1.05% 1.90 0.03 0.23
5. 2015/06/30 -1.72% -2.10% 1.10 8.88 3.12
6. 2015/07/31 -1.77% 1.97% 1.19 1.20 -1.20
7. 2015/08/31 -4.90% -6.26% 17.87 50.94 30.17
8. 2015/09/30 2.54% -2.64% 10.34 12.41 -11.33
9. 2015/10/31 14.67% 8.30% 235.56 55.04 113.87
10. 2015/11/30 3.53% 0.05% 17.67 0.69 -3.48
11. 2015/12/31 4.81% -1.75% 30.10 6.93 -14.44
12. 2016/01/31 -6.58% -5.07% 34.86 35.43 35.14
13. 2016/02/29 0.93% -0.41% 2.58 1.67 -2.07
14. 2016/03/31 9.09% 6.60% 95.47 32.72 55.89
15. 2016/04/30 -3.27% 0.27% 6.73 0.37 1.58
16. 2016/05/31 -1.69% 1.53% 1.03 0.43 -0.66
17. 2016/06/30 4.90% 0.09% 31.06 0.62 -4.39
18. 2016/07/31 -1.08% 3.56% 0.16 7.19 -1.08
19. 2016/08/31 0.32% -0.12% 1.00 1.00 -1.00
20. 2016/09/30 -4.45% -0.12% 14.23 1.01 3.78
21. 2016/10/31 -1.76% -1.94% 1.16 7.96 3.04
22. 2016/11/30 5.70% 3.42% 40.72 6.44 16.20
23. 2016/12/31 3.51% 1.82% 17.54 0.89 3.94
24. 2017/01/31 -6.01% 1.79% 28.47 0.83 -4.85
25. 2017/02/28 1.18% 3.72% 3.44 8.07 5.27
26. 2017/03/31 -0.03% -0.04% 0.41 0.84 -0.59
27. 2017/04/30 -2.72% 0.91% 4.17 0.00 -0.06
28. 2017/05/31 -5.55% 1.16% 23.78 0.08 -1.36
29. 2017/06/30 -0.47% 0.48% 0.04 0.16 -0.08
30. 2017/07/31 -5.18% 1.93% 20.31 1.11 -4.76
31. 2017/08/31 -4.14% 0.05% 11.99 0.68 2.85
32. 2017/09/30 -0.53% 1.93% 0.02 1.10 0.16
33. 2017/10/31 -16.63% 2.22% 254.35 1.79 -21.37
34. 2017/11/30 -9.28% 2.81% 73.94 3.72 -16.59
35. 2017/12/31 -3.94% 0.98% 10.62 0.01 -0.34
36. 2018/01/31 -7.34% 5.62% 44.33 22.46 -31.55
37. 2018/02/28 -12.00% -3.89% 128.15 22.79 54.04
38. 2018/03/31 -4.46% -2.69% 14.35 12.73 13.51
39. 2018/04/30 4.38% 0.27% 25.54 0.37 -3.07
40. 2018/05/31 0.07% 2.16% 0.56 1.64 0.96
41. 2018/06/30 -2.49% 0.48% 3.27 0.16 0.71
42. 2018/07/31 0.15% 3.60% 0.68 7.41 2.24
43. 2018/08/31 -5.06% 3.03% 19.23 4.61 -9.42
44. 2018/09/30 -11.82% 0.43% 124.25 0.20 5.01
45. 2018/10/31 -10.54% -6.94% 97.28 61.14 77.13
46. 2018/11/30 -25.74% 1.79% 628.28 0.82 -22.73
47. 2018/12/31 1.07% -9.18% 3.04 101.14 -17.54
48. 2019/01/31 34.21% 7.87% 1,217.39 48.85 243.86
49. 2019/02/28 2.26% 2.97% 8.65 4.38 6.16
50. 2019/03/31 -3.75% 1.79% 9.47 0.83 -2.81
51. 2019/04/30 1.80% 3.93% 6.14 9.32 7.57
52. 2019/05/31 -7.18% -6.58% 42.26 55.61 48.48
53. 2019/06/30 11.33% 6.89% 144.28 36.17 72.24
54. 2019/07/31 -0.48% 1.31% 0.04 0.19 0.09
55. 2019/08/31 -21.05% -1.81% 415.16 7.23 54.78
56. 2019/09/30 8.48% 1.72% 83.94 0.70 7.69
57. 2019/10/31 11.63% 2.04% 151.54 1.36 14.33
58. 2019/11/30 12.93% 3.40% 185.04 6.38 34.36
59. 2019/12/31 -0.89% 2.86% 0.04 3.92 -0.42
合計 (Σ): 4,567.01 688.77 799.16

Show all

VarianceGE = Σ(RGE,tRGE)2 ÷ (59 – 1)
= 4,567.01 ÷ (59 – 1)
= 78.74

VarianceS&P 500 = Σ(RS&P 500,tRS&P 500)2 ÷ (59 – 1)
= 688.77 ÷ (59 – 1)
= 11.88

CovarianceGE, S&P 500 = Σ(RGE,tRGE)×(RS&P 500,tRS&P 500) ÷ (59 – 1)
= 799.16 ÷ (59 – 1)
= 13.78


体系的なリスク推定 (β)

Microsoft Excel LibreOffice Calc
VarianceGE 78.74
VarianceS&P 500 11.88
CovarianceGE, S&P 500 13.78
相関係数GE, S&P 5001 0.45
βGE2 1.16
αGE3 -1.70%

ソース: General Electric Co. (NYSE:GE) | CAPM (www.stock-analysis-on.net)

計算

1 相関係数GE, S&P 500
= CovarianceGE, S&P 500 ÷ (Standard deviationGE × Standard deviationS&P 500)
= 13.78 ÷ (8.87% × 3.45%)
= 0.45

2 βGE
= CovarianceGE, S&P 500 ÷ VarianceS&P 500
= 13.78 ÷ 11.88
= 1.16

3 αGE
= 平均GE – βGE × 平均S&P 500
= -0.68%1.16 × 0.88%
= -1.70%


期待収益率

Microsoft Excel LibreOffice Calc
仮定
LT Treasury Compositeの収益率1 RF 1.68%
市場ポートフォリオの期待収益率2 E(RM) 12.11%
GEの普通株の体系的なリスク βGE 1.16
 
GEの普通株式の期待収益率3 E(RGE) 13.79%

ソース: General Electric Co. (NYSE:GE) | CAPM (www.stock-analysis-on.net)

1 すべての未処理の固定クーポン米国財務省証券の10年未満で返済されない、または呼び出すことができない、加重されていない入札利回りの平均(リスクなしの収益率)。

2 詳細を見る »

3 E(RGE) = RF + βGE [E(RM) – RF]
= 1.68% + 1.16 [12.11%1.68%]
= 13.79%