Capital asset pricing model (CAPM) indicates what should be the expected or required rate of return on risky assets like Raytheon Co. common stock.
Rates of Return
Raytheon Co. (RTN) | Standard & Poor’s 500 (S&P 500) | |||||
---|---|---|---|---|---|---|
t | Date | PriceRTN,t1 | DividendRTN,t1 | RRTN,t2 | PriceS&P 500,t | RS&P 500,t3 |
Jan 31, 2015 | $100.05 | 1,994.99 | ||||
1. | Feb 28, 2015 | $108.77 | 8.72% | 2,104.50 | 5.49% | |
2. | Mar 31, 2015 | $109.25 | $0.67 | 1.06% | 2,067.89 | -1.74% |
3. | Apr 30, 2015 | $104.00 | -4.81% | 2,085.51 | 0.85% | |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
58. | Nov 30, 2019 | $217.42 | 2.46% | 3,140.98 | 3.40% | |
59. | Dec 31, 2019 | $219.74 | $0.9425 | 1.50% | 3,230.78 | 2.86% |
Average (R): | 1.67% | 0.88% | ||||
Standard deviation: | 5.56% | 3.45% |
Raytheon Co. (RTN) | Standard & Poor’s 500 (S&P 500) | |||||
---|---|---|---|---|---|---|
t | Date | PriceRTN,t1 | DividendRTN,t1 | RRTN,t2 | PriceS&P 500,t | RS&P 500,t3 |
Jan 31, 2015 | $100.05 | 1,994.99 | ||||
1. | Feb 28, 2015 | $108.77 | 8.72% | 2,104.50 | 5.49% | |
2. | Mar 31, 2015 | $109.25 | $0.67 | 1.06% | 2,067.89 | -1.74% |
3. | Apr 30, 2015 | $104.00 | -4.81% | 2,085.51 | 0.85% | |
4. | May 31, 2015 | $103.26 | -0.71% | 2,107.39 | 1.05% | |
5. | Jun 30, 2015 | $95.68 | $0.67 | -6.69% | 2,063.11 | -2.10% |
6. | Jul 31, 2015 | $109.09 | 14.02% | 2,103.84 | 1.97% | |
7. | Aug 31, 2015 | $102.56 | -5.99% | 1,972.18 | -6.26% | |
8. | Sep 30, 2015 | $109.26 | 6.53% | 1,920.03 | -2.64% | |
9. | Oct 31, 2015 | $117.40 | $0.67 | 8.06% | 2,079.36 | 8.30% |
10. | Nov 30, 2015 | $124.03 | 5.65% | 2,080.41 | 0.05% | |
11. | Dec 31, 2015 | $124.53 | 0.40% | 2,043.94 | -1.75% | |
12. | Jan 31, 2016 | $128.24 | $0.67 | 3.52% | 1,940.24 | -5.07% |
13. | Feb 29, 2016 | $123.85 | -3.42% | 1,932.23 | -0.41% | |
14. | Mar 31, 2016 | $122.63 | -0.99% | 2,059.74 | 6.60% | |
15. | Apr 30, 2016 | $126.35 | $0.7325 | 3.63% | 2,065.30 | 0.27% |
16. | May 31, 2016 | $129.67 | 2.63% | 2,096.95 | 1.53% | |
17. | Jun 30, 2016 | $135.95 | 4.84% | 2,098.86 | 0.09% | |
18. | Jul 31, 2016 | $139.53 | $0.7325 | 3.17% | 2,173.60 | 3.56% |
19. | Aug 31, 2016 | $140.13 | 0.43% | 2,170.95 | -0.12% | |
20. | Sep 30, 2016 | $136.13 | -2.85% | 2,168.27 | -0.12% | |
21. | Oct 31, 2016 | $136.61 | $0.7325 | 0.89% | 2,126.15 | -1.94% |
22. | Nov 30, 2016 | $149.54 | 9.46% | 2,198.81 | 3.42% | |
23. | Dec 31, 2016 | $142.00 | $0.7325 | -4.55% | 2,238.83 | 1.82% |
24. | Jan 31, 2017 | $144.16 | 1.52% | 2,278.87 | 1.79% | |
25. | Feb 28, 2017 | $154.15 | 6.93% | 2,363.64 | 3.72% | |
26. | Mar 31, 2017 | $152.50 | -1.07% | 2,362.72 | -0.04% | |
27. | Apr 30, 2017 | $155.21 | $0.7975 | 2.30% | 2,384.20 | 0.91% |
28. | May 31, 2017 | $164.01 | 5.67% | 2,411.80 | 1.16% | |
29. | Jun 30, 2017 | $161.48 | $0.7975 | -1.06% | 2,423.41 | 0.48% |
30. | Jul 31, 2017 | $171.77 | 6.37% | 2,470.30 | 1.93% | |
31. | Aug 31, 2017 | $182.01 | 5.96% | 2,471.65 | 0.05% | |
32. | Sep 30, 2017 | $186.58 | 2.51% | 2,519.36 | 1.93% | |
33. | Oct 31, 2017 | $180.20 | $0.7975 | -2.99% | 2,575.26 | 2.22% |
34. | Nov 30, 2017 | $191.15 | 6.08% | 2,647.58 | 2.81% | |
35. | Dec 31, 2017 | $187.85 | -1.73% | 2,673.61 | 0.98% | |
36. | Jan 31, 2018 | $208.94 | $0.7975 | 11.65% | 2,823.81 | 5.62% |
37. | Feb 28, 2018 | $217.51 | 4.10% | 2,713.83 | -3.89% | |
38. | Mar 31, 2018 | $215.82 | -0.78% | 2,640.87 | -2.69% | |
39. | Apr 30, 2018 | $204.94 | $0.8675 | -4.64% | 2,648.05 | 0.27% |
40. | May 31, 2018 | $209.50 | 2.23% | 2,705.27 | 2.16% | |
41. | Jun 30, 2018 | $193.18 | -7.79% | 2,718.37 | 0.48% | |
42. | Jul 31, 2018 | $198.03 | $0.8675 | 2.96% | 2,816.29 | 3.60% |
43. | Aug 31, 2018 | $199.44 | 0.71% | 2,901.52 | 3.03% | |
44. | Sep 30, 2018 | $206.66 | 3.62% | 2,913.98 | 0.43% | |
45. | Oct 31, 2018 | $175.04 | $0.8675 | -14.88% | 2,711.74 | -6.94% |
46. | Nov 30, 2018 | $175.34 | 0.17% | 2,760.17 | 1.79% | |
47. | Dec 31, 2018 | $153.35 | $0.8675 | -12.05% | 2,506.85 | -9.18% |
48. | Jan 31, 2019 | $164.76 | 7.44% | 2,704.10 | 7.87% | |
49. | Feb 28, 2019 | $186.50 | 13.19% | 2,784.49 | 2.97% | |
50. | Mar 31, 2019 | $182.08 | -2.37% | 2,834.40 | 1.79% | |
51. | Apr 30, 2019 | $177.59 | $0.9425 | -1.95% | 2,945.83 | 3.93% |
52. | May 31, 2019 | $174.50 | -1.74% | 2,752.06 | -6.58% | |
53. | Jun 30, 2019 | $173.88 | -0.36% | 2,941.76 | 6.89% | |
54. | Jul 31, 2019 | $182.29 | $0.9425 | 5.38% | 2,980.38 | 1.31% |
55. | Aug 31, 2019 | $185.32 | 1.66% | 2,926.46 | -1.81% | |
56. | Sep 30, 2019 | $196.19 | 5.87% | 2,976.74 | 1.72% | |
57. | Oct 31, 2019 | $212.21 | $0.9425 | 8.65% | 3,037.56 | 2.04% |
58. | Nov 30, 2019 | $217.42 | 2.46% | 3,140.98 | 3.40% | |
59. | Dec 31, 2019 | $219.74 | $0.9425 | 1.50% | 3,230.78 | 2.86% |
Average (R): | 1.67% | 0.88% | ||||
Standard deviation: | 5.56% | 3.45% |
Show all
1 Data in US$ per share of common stock, adjusted for splits and stock dividends.
2 Rate of return on common stock of RTN during period t
3 Rate of return on S&P 500 (the market portfolio proxy) during period t
Variance and Covariance
t | Date | RRTN,t | RS&P 500,t | (RRTN,t–RRTN)2 | (RS&P 500,t–RS&P 500)2 | (RRTN,t–RRTN)×(RS&P 500,t–RS&P 500) |
---|---|---|---|---|---|---|
1. | Feb 28, 2015 | 8.72% | 5.49% | 49.64 | 21.25 | 32.48 |
2. | Mar 31, 2015 | 1.06% | -1.74% | 0.38 | 6.86 | 1.60 |
3. | Apr 30, 2015 | -4.81% | 0.85% | 41.93 | 0.00 | 0.18 |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
. | . | . | . | . | . | . |
58. | Nov 30, 2019 | 2.46% | 3.40% | 0.62 | 6.38 | 1.98 |
59. | Dec 31, 2019 | 1.50% | 2.86% | 0.03 | 3.92 | -0.34 |
Total (Σ): | 1,792.81 | 688.77 | 581.47 |
t | Date | RRTN,t | RS&P 500,t | (RRTN,t–RRTN)2 | (RS&P 500,t–RS&P 500)2 | (RRTN,t–RRTN)×(RS&P 500,t–RS&P 500) |
---|---|---|---|---|---|---|
1. | Feb 28, 2015 | 8.72% | 5.49% | 49.64 | 21.25 | 32.48 |
2. | Mar 31, 2015 | 1.06% | -1.74% | 0.38 | 6.86 | 1.60 |
3. | Apr 30, 2015 | -4.81% | 0.85% | 41.93 | 0.00 | 0.18 |
4. | May 31, 2015 | -0.71% | 1.05% | 5.67 | 0.03 | -0.40 |
5. | Jun 30, 2015 | -6.69% | -2.10% | 69.92 | 8.88 | 24.92 |
6. | Jul 31, 2015 | 14.02% | 1.97% | 152.41 | 1.20 | 13.52 |
7. | Aug 31, 2015 | -5.99% | -6.26% | 58.61 | 50.94 | 54.64 |
8. | Sep 30, 2015 | 6.53% | -2.64% | 23.65 | 12.41 | -17.13 |
9. | Oct 31, 2015 | 8.06% | 8.30% | 40.87 | 55.04 | 47.43 |
10. | Nov 30, 2015 | 5.65% | 0.05% | 15.82 | 0.69 | -3.30 |
11. | Dec 31, 2015 | 0.40% | -1.75% | 1.61 | 6.93 | 3.33 |
12. | Jan 31, 2016 | 3.52% | -5.07% | 3.41 | 35.43 | -11.00 |
13. | Feb 29, 2016 | -3.42% | -0.41% | 25.94 | 1.67 | 6.58 |
14. | Mar 31, 2016 | -0.99% | 6.60% | 7.05 | 32.72 | -15.19 |
15. | Apr 30, 2016 | 3.63% | 0.27% | 3.84 | 0.37 | -1.19 |
16. | May 31, 2016 | 2.63% | 1.53% | 0.92 | 0.43 | 0.63 |
17. | Jun 30, 2016 | 4.84% | 0.09% | 10.07 | 0.62 | -2.50 |
18. | Jul 31, 2016 | 3.17% | 3.56% | 2.26 | 7.19 | 4.03 |
19. | Aug 31, 2016 | 0.43% | -0.12% | 1.54 | 1.00 | 1.24 |
20. | Sep 30, 2016 | -2.85% | -0.12% | 20.47 | 1.01 | 4.54 |
21. | Oct 31, 2016 | 0.89% | -1.94% | 0.61 | 7.96 | 2.20 |
22. | Nov 30, 2016 | 9.46% | 3.42% | 60.76 | 6.44 | 19.79 |
23. | Dec 31, 2016 | -4.55% | 1.82% | 38.72 | 0.89 | -5.86 |
24. | Jan 31, 2017 | 1.52% | 1.79% | 0.02 | 0.83 | -0.14 |
25. | Feb 28, 2017 | 6.93% | 3.72% | 27.66 | 8.07 | 14.94 |
26. | Mar 31, 2017 | -1.07% | -0.04% | 7.51 | 0.84 | 2.52 |
27. | Apr 30, 2017 | 2.30% | 0.91% | 0.40 | 0.00 | 0.02 |
28. | May 31, 2017 | 5.67% | 1.16% | 16.00 | 0.08 | 1.11 |
29. | Jun 30, 2017 | -1.06% | 0.48% | 7.43 | 0.16 | 1.08 |
30. | Jul 31, 2017 | 6.37% | 1.93% | 22.11 | 1.11 | 4.96 |
31. | Aug 31, 2017 | 5.96% | 0.05% | 18.42 | 0.68 | -3.54 |
32. | Sep 30, 2017 | 2.51% | 1.93% | 0.71 | 1.10 | 0.88 |
33. | Oct 31, 2017 | -2.99% | 2.22% | 21.74 | 1.79 | -6.25 |
34. | Nov 30, 2017 | 6.08% | 2.81% | 19.42 | 3.72 | 8.50 |
35. | Dec 31, 2017 | -1.73% | 0.98% | 11.54 | 0.01 | -0.35 |
36. | Jan 31, 2018 | 11.65% | 5.62% | 99.63 | 22.46 | 47.30 |
37. | Feb 28, 2018 | 4.10% | -3.89% | 5.91 | 22.79 | -11.61 |
38. | Mar 31, 2018 | -0.78% | -2.69% | 5.99 | 12.73 | 8.73 |
39. | Apr 30, 2018 | -4.64% | 0.27% | 39.81 | 0.37 | 3.83 |
40. | May 31, 2018 | 2.23% | 2.16% | 0.31 | 1.64 | 0.71 |
41. | Jun 30, 2018 | -7.79% | 0.48% | 89.49 | 0.16 | 3.74 |
42. | Jul 31, 2018 | 2.96% | 3.60% | 1.66 | 7.41 | 3.51 |
43. | Aug 31, 2018 | 0.71% | 3.03% | 0.92 | 4.61 | -2.06 |
44. | Sep 30, 2018 | 3.62% | 0.43% | 3.80 | 0.20 | -0.88 |
45. | Oct 31, 2018 | -14.88% | -6.94% | 273.93 | 61.14 | 129.42 |
46. | Nov 30, 2018 | 0.17% | 1.79% | 2.25 | 0.82 | -1.36 |
47. | Dec 31, 2018 | -12.05% | -9.18% | 188.15 | 101.14 | 137.95 |
48. | Jan 31, 2019 | 7.44% | 7.87% | 33.30 | 48.85 | 40.33 |
49. | Feb 28, 2019 | 13.19% | 2.97% | 132.82 | 4.38 | 24.13 |
50. | Mar 31, 2019 | -2.37% | 1.79% | 16.32 | 0.83 | -3.69 |
51. | Apr 30, 2019 | -1.95% | 3.93% | 13.09 | 9.32 | -11.04 |
52. | May 31, 2019 | -1.74% | -6.58% | 11.63 | 55.61 | 25.43 |
53. | Jun 30, 2019 | -0.36% | 6.89% | 4.10 | 36.17 | -12.18 |
54. | Jul 31, 2019 | 5.38% | 1.31% | 13.75 | 0.19 | 1.61 |
55. | Aug 31, 2019 | 1.66% | -1.81% | 0.00 | 7.23 | 0.02 |
56. | Sep 30, 2019 | 5.87% | 1.72% | 17.60 | 0.70 | 3.52 |
57. | Oct 31, 2019 | 8.65% | 2.04% | 48.66 | 1.36 | 8.12 |
58. | Nov 30, 2019 | 2.46% | 3.40% | 0.62 | 6.38 | 1.98 |
59. | Dec 31, 2019 | 1.50% | 2.86% | 0.03 | 3.92 | -0.34 |
Total (Σ): | 1,792.81 | 688.77 | 581.47 |
Show all
VarianceRTN = Σ(RRTN,t–RRTN)2 ÷ (59 – 1)
= 1,792.81 ÷ (59 – 1)
= 30.91
VarianceS&P 500 = Σ(RS&P 500,t–RS&P 500)2 ÷ (59 – 1)
= 688.77 ÷ (59 – 1)
= 11.88
CovarianceRTN, S&P 500 = Σ(RRTN,t–RRTN)×(RS&P 500,t–RS&P 500) ÷ (59 – 1)
= 581.47 ÷ (59 – 1)
= 10.03
Systematic Risk (β) Estimation
VarianceRTN | 30.91 |
VarianceS&P 500 | 11.88 |
CovarianceRTN, S&P 500 | 10.03 |
Correlation coefficientRTN, S&P 5001 | 0.52 |
βRTN2 | 0.84 |
αRTN3 | 0.93% |
Calculations
1 Correlation coefficientRTN, S&P 500
= CovarianceRTN, S&P 500 ÷ (Standard deviationRTN × Standard deviationS&P 500)
= 10.03 ÷ (5.56% × 3.45%)
= 0.52
2 βRTN
= CovarianceRTN, S&P 500 ÷ VarianceS&P 500
= 10.03 ÷ 11.88
= 0.84
3 αRTN
= AverageRTN – βRTN × AverageS&P 500
= 1.67% – 0.84 × 0.88%
= 0.93%
Expected Rate of Return
Assumptions | ||
Rate of return on LT Treasury Composite1 | RF | 4.79% |
Expected rate of return on market portfolio2 | E(RM) | 13.79% |
Systematic risk (β) of Raytheon Co. common stock | βRTN | 0.84 |
Expected rate of return on Raytheon Co. common stock3 | E(RRTN) | 12.39% |
1 Unweighted average of bid yields on all outstanding fixed-coupon U.S. Treasury bonds neither due or callable in less than 10 years (risk-free rate of return proxy).
3 E(RRTN) = RF + βRTN [E(RM) – RF]
= 4.79% + 0.84 [13.79% – 4.79%]
= 12.39%