Stock Analysis on Net

Raytheon Co. (NYSE:RTN)

この会社は アーカイブに移動しました! 財務データは2020年2月12日以降更新されていません。

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

Microsoft Excel

収益率

Raytheon Co.、月間収益率

Microsoft Excel
Raytheon Co. (RTN) Standard & Poor’s 500 (S&P 500)
t 日付 価格RTN,t1 配当RTN,t1 RRTN,t2 価格S&P 500,t RS&P 500,t3
2015/01/31 $100.05 1,994.99
1. 2015/02/28 $108.77 8.72% 2,104.50 5.49%
2. 2015/03/31 $109.25 $0.67 1.06% 2,067.89 -1.74%
3. 2015/04/30 $104.00 -4.81% 2,085.51 0.85%
. . . . . . .
. . . . . . .
. . . . . . .
58. 2019/11/30 $217.42 2.46% 3,140.98 3.40%
59. 2019/12/31 $219.74 $0.9425 1.50% 3,230.78 2.86%
平均 (R): 1.67% 0.88%
標準偏差: 5.56% 3.45%
Raytheon Co. (RTN) Standard & Poor’s 500 (S&P 500)
t 日付 価格RTN,t1 配当RTN,t1 RRTN,t2 価格S&P 500,t RS&P 500,t3
2015/01/31 $100.05 1,994.99
1. 2015/02/28 $108.77 8.72% 2,104.50 5.49%
2. 2015/03/31 $109.25 $0.67 1.06% 2,067.89 -1.74%
3. 2015/04/30 $104.00 -4.81% 2,085.51 0.85%
4. 2015/05/31 $103.26 -0.71% 2,107.39 1.05%
5. 2015/06/30 $95.68 $0.67 -6.69% 2,063.11 -2.10%
6. 2015/07/31 $109.09 14.02% 2,103.84 1.97%
7. 2015/08/31 $102.56 -5.99% 1,972.18 -6.26%
8. 2015/09/30 $109.26 6.53% 1,920.03 -2.64%
9. 2015/10/31 $117.40 $0.67 8.06% 2,079.36 8.30%
10. 2015/11/30 $124.03 5.65% 2,080.41 0.05%
11. 2015/12/31 $124.53 0.40% 2,043.94 -1.75%
12. 2016/01/31 $128.24 $0.67 3.52% 1,940.24 -5.07%
13. 2016/02/29 $123.85 -3.42% 1,932.23 -0.41%
14. 2016/03/31 $122.63 -0.99% 2,059.74 6.60%
15. 2016/04/30 $126.35 $0.7325 3.63% 2,065.30 0.27%
16. 2016/05/31 $129.67 2.63% 2,096.95 1.53%
17. 2016/06/30 $135.95 4.84% 2,098.86 0.09%
18. 2016/07/31 $139.53 $0.7325 3.17% 2,173.60 3.56%
19. 2016/08/31 $140.13 0.43% 2,170.95 -0.12%
20. 2016/09/30 $136.13 -2.85% 2,168.27 -0.12%
21. 2016/10/31 $136.61 $0.7325 0.89% 2,126.15 -1.94%
22. 2016/11/30 $149.54 9.46% 2,198.81 3.42%
23. 2016/12/31 $142.00 $0.7325 -4.55% 2,238.83 1.82%
24. 2017/01/31 $144.16 1.52% 2,278.87 1.79%
25. 2017/02/28 $154.15 6.93% 2,363.64 3.72%
26. 2017/03/31 $152.50 -1.07% 2,362.72 -0.04%
27. 2017/04/30 $155.21 $0.7975 2.30% 2,384.20 0.91%
28. 2017/05/31 $164.01 5.67% 2,411.80 1.16%
29. 2017/06/30 $161.48 $0.7975 -1.06% 2,423.41 0.48%
30. 2017/07/31 $171.77 6.37% 2,470.30 1.93%
31. 2017/08/31 $182.01 5.96% 2,471.65 0.05%
32. 2017/09/30 $186.58 2.51% 2,519.36 1.93%
33. 2017/10/31 $180.20 $0.7975 -2.99% 2,575.26 2.22%
34. 2017/11/30 $191.15 6.08% 2,647.58 2.81%
35. 2017/12/31 $187.85 -1.73% 2,673.61 0.98%
36. 2018/01/31 $208.94 $0.7975 11.65% 2,823.81 5.62%
37. 2018/02/28 $217.51 4.10% 2,713.83 -3.89%
38. 2018/03/31 $215.82 -0.78% 2,640.87 -2.69%
39. 2018/04/30 $204.94 $0.8675 -4.64% 2,648.05 0.27%
40. 2018/05/31 $209.50 2.23% 2,705.27 2.16%
41. 2018/06/30 $193.18 -7.79% 2,718.37 0.48%
42. 2018/07/31 $198.03 $0.8675 2.96% 2,816.29 3.60%
43. 2018/08/31 $199.44 0.71% 2,901.52 3.03%
44. 2018/09/30 $206.66 3.62% 2,913.98 0.43%
45. 2018/10/31 $175.04 $0.8675 -14.88% 2,711.74 -6.94%
46. 2018/11/30 $175.34 0.17% 2,760.17 1.79%
47. 2018/12/31 $153.35 $0.8675 -12.05% 2,506.85 -9.18%
48. 2019/01/31 $164.76 7.44% 2,704.10 7.87%
49. 2019/02/28 $186.50 13.19% 2,784.49 2.97%
50. 2019/03/31 $182.08 -2.37% 2,834.40 1.79%
51. 2019/04/30 $177.59 $0.9425 -1.95% 2,945.83 3.93%
52. 2019/05/31 $174.50 -1.74% 2,752.06 -6.58%
53. 2019/06/30 $173.88 -0.36% 2,941.76 6.89%
54. 2019/07/31 $182.29 $0.9425 5.38% 2,980.38 1.31%
55. 2019/08/31 $185.32 1.66% 2,926.46 -1.81%
56. 2019/09/30 $196.19 5.87% 2,976.74 1.72%
57. 2019/10/31 $212.21 $0.9425 8.65% 3,037.56 2.04%
58. 2019/11/30 $217.42 2.46% 3,140.98 3.40%
59. 2019/12/31 $219.74 $0.9425 1.50% 3,230.78 2.86%
平均 (R): 1.67% 0.88%
標準偏差: 5.56% 3.45%

すべて表示

1 普通株式1株当たり米ドルのデータで、分割と株式配当を調整したものです。

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

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


分散と共分散

Raytheon Co.、分散の計算、および戻り値の共分散

Microsoft Excel
t 日付 RRTN,t RS&P 500,t (RRTN,tRRTN)2 (RS&P 500,tRS&P 500)2 (RRTN,tRRTN)×(RS&P 500,tRS&P 500)
1. 2015/02/28 8.72% 5.49% 49.64 21.25 32.48
2. 2015/03/31 1.06% -1.74% 0.38 6.86 1.60
3. 2015/04/30 -4.81% 0.85% 41.93 0.00 0.18
. . . . . . .
. . . . . . .
. . . . . . .
58. 2019/11/30 2.46% 3.40% 0.62 6.38 1.98
59. 2019/12/31 1.50% 2.86% 0.03 3.92 -0.34
トータル (Σ): 1,792.81 688.77 581.47
t 日付 RRTN,t RS&P 500,t (RRTN,tRRTN)2 (RS&P 500,tRS&P 500)2 (RRTN,tRRTN)×(RS&P 500,tRS&P 500)
1. 2015/02/28 8.72% 5.49% 49.64 21.25 32.48
2. 2015/03/31 1.06% -1.74% 0.38 6.86 1.60
3. 2015/04/30 -4.81% 0.85% 41.93 0.00 0.18
4. 2015/05/31 -0.71% 1.05% 5.67 0.03 -0.40
5. 2015/06/30 -6.69% -2.10% 69.92 8.88 24.92
6. 2015/07/31 14.02% 1.97% 152.41 1.20 13.52
7. 2015/08/31 -5.99% -6.26% 58.61 50.94 54.64
8. 2015/09/30 6.53% -2.64% 23.65 12.41 -17.13
9. 2015/10/31 8.06% 8.30% 40.87 55.04 47.43
10. 2015/11/30 5.65% 0.05% 15.82 0.69 -3.30
11. 2015/12/31 0.40% -1.75% 1.61 6.93 3.33
12. 2016/01/31 3.52% -5.07% 3.41 35.43 -11.00
13. 2016/02/29 -3.42% -0.41% 25.94 1.67 6.58
14. 2016/03/31 -0.99% 6.60% 7.05 32.72 -15.19
15. 2016/04/30 3.63% 0.27% 3.84 0.37 -1.19
16. 2016/05/31 2.63% 1.53% 0.92 0.43 0.63
17. 2016/06/30 4.84% 0.09% 10.07 0.62 -2.50
18. 2016/07/31 3.17% 3.56% 2.26 7.19 4.03
19. 2016/08/31 0.43% -0.12% 1.54 1.00 1.24
20. 2016/09/30 -2.85% -0.12% 20.47 1.01 4.54
21. 2016/10/31 0.89% -1.94% 0.61 7.96 2.20
22. 2016/11/30 9.46% 3.42% 60.76 6.44 19.79
23. 2016/12/31 -4.55% 1.82% 38.72 0.89 -5.86
24. 2017/01/31 1.52% 1.79% 0.02 0.83 -0.14
25. 2017/02/28 6.93% 3.72% 27.66 8.07 14.94
26. 2017/03/31 -1.07% -0.04% 7.51 0.84 2.52
27. 2017/04/30 2.30% 0.91% 0.40 0.00 0.02
28. 2017/05/31 5.67% 1.16% 16.00 0.08 1.11
29. 2017/06/30 -1.06% 0.48% 7.43 0.16 1.08
30. 2017/07/31 6.37% 1.93% 22.11 1.11 4.96
31. 2017/08/31 5.96% 0.05% 18.42 0.68 -3.54
32. 2017/09/30 2.51% 1.93% 0.71 1.10 0.88
33. 2017/10/31 -2.99% 2.22% 21.74 1.79 -6.25
34. 2017/11/30 6.08% 2.81% 19.42 3.72 8.50
35. 2017/12/31 -1.73% 0.98% 11.54 0.01 -0.35
36. 2018/01/31 11.65% 5.62% 99.63 22.46 47.30
37. 2018/02/28 4.10% -3.89% 5.91 22.79 -11.61
38. 2018/03/31 -0.78% -2.69% 5.99 12.73 8.73
39. 2018/04/30 -4.64% 0.27% 39.81 0.37 3.83
40. 2018/05/31 2.23% 2.16% 0.31 1.64 0.71
41. 2018/06/30 -7.79% 0.48% 89.49 0.16 3.74
42. 2018/07/31 2.96% 3.60% 1.66 7.41 3.51
43. 2018/08/31 0.71% 3.03% 0.92 4.61 -2.06
44. 2018/09/30 3.62% 0.43% 3.80 0.20 -0.88
45. 2018/10/31 -14.88% -6.94% 273.93 61.14 129.42
46. 2018/11/30 0.17% 1.79% 2.25 0.82 -1.36
47. 2018/12/31 -12.05% -9.18% 188.15 101.14 137.95
48. 2019/01/31 7.44% 7.87% 33.30 48.85 40.33
49. 2019/02/28 13.19% 2.97% 132.82 4.38 24.13
50. 2019/03/31 -2.37% 1.79% 16.32 0.83 -3.69
51. 2019/04/30 -1.95% 3.93% 13.09 9.32 -11.04
52. 2019/05/31 -1.74% -6.58% 11.63 55.61 25.43
53. 2019/06/30 -0.36% 6.89% 4.10 36.17 -12.18
54. 2019/07/31 5.38% 1.31% 13.75 0.19 1.61
55. 2019/08/31 1.66% -1.81% 0.00 7.23 0.02
56. 2019/09/30 5.87% 1.72% 17.60 0.70 3.52
57. 2019/10/31 8.65% 2.04% 48.66 1.36 8.12
58. 2019/11/30 2.46% 3.40% 0.62 6.38 1.98
59. 2019/12/31 1.50% 2.86% 0.03 3.92 -0.34
トータル (Σ): 1,792.81 688.77 581.47

すべて表示

分散RTN = Σ(RRTN,tRRTN)2 ÷ (59 – 1)
= 1,792.81 ÷ (59 – 1)
= 30.91

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

共 分散RTN, S&P 500 = Σ(RRTN,tRRTN)×(RS&P 500,tRS&P 500) ÷ (59 – 1)
= 581.47 ÷ (59 – 1)
= 10.03


システマティックなリスク推定 (β)

Microsoft Excel
分散RTN 30.91
分散S&P 500 11.88
共 分散RTN, S&P 500 10.03
相関係数RTN, S&P 5001 0.52
βRTN2 0.84
αRTN3 0.93%

計算

1 相関係数RTN, S&P 500
= 共 分散RTN, S&P 500 ÷ (標準偏差RTN × 標準偏差S&P 500)
= 10.03 ÷ (5.56% × 3.45%)
= 0.52

2 βRTN
= 共 分散RTN, S&P 500 ÷ 分散S&P 500
= 10.03 ÷ 11.88
= 0.84

3 αRTN
= 平均RTN – βRTN × 平均S&P 500
= 1.67%0.84 × 0.88%
= 0.93%


期待収益率

Microsoft Excel
仮定
LT国債総合の収益率1 RF 4.93%
市場ポートフォリオの期待収益率2 E(RM) 14.84%
普通株式 Raytheon システマティックリスク βRTN 0.84
 
レイセオン普通株式の期待収益率3 E(RRTN) 13.30%

1 10年以内に期限が到来しない、または償還不能となるすべての発行済み固定利回り米国債の入札利回りの加重平均(リスクフリー・リターン・プロキシ)。

2 詳しく見る »

3 E(RRTN) = RF + βRTN [E(RM) – RF]
= 4.93% + 0.84 [14.84%4.93%]
= 13.30%