Stock Analysis on Net

Johnson & Johnson (NYSE:JNJ)

자본 자산 가격 책정 모델 (CAPM) 

Microsoft Excel

수익률

Johnson & Johnson, 월별 수익률

Microsoft Excel
Johnson & Johnson (JNJ) Standard & Poor’s 500 (S&P 500)
t 날짜 JNJ,t1 피제수JNJ,t1 RJNJ,t2 S&P 500,t RS&P 500,t3
2019. 1. 31. $133.08 2,704.10
1. 2019. 2. 28. $136.64 $0.90 3.35% 2,784.49 2.97%
2. 2019. 3. 31. $139.79 2.31% 2,834.40 1.79%
3. 2019. 4. 30. $141.20 1.01% 2,945.83 3.93%
. . . . . . .
. . . . . . .
. . . . . . .
58. 2023. 11. 30. $154.66 $1.19 5.06% 4,567.80 8.92%
59. 2023. 12. 31. $156.74 1.34% 4,769.83 4.42%
평균의 (R): 0.63% 1.11%
표준 편차: 4.96% 5.31%
Johnson & Johnson (JNJ) Standard & Poor’s 500 (S&P 500)
t 날짜 JNJ,t1 피제수JNJ,t1 RJNJ,t2 S&P 500,t RS&P 500,t3
2019. 1. 31. $133.08 2,704.10
1. 2019. 2. 28. $136.64 $0.90 3.35% 2,784.49 2.97%
2. 2019. 3. 31. $139.79 2.31% 2,834.40 1.79%
3. 2019. 4. 30. $141.20 1.01% 2,945.83 3.93%
4. 2019. 5. 31. $131.15 $0.95 -6.44% 2,752.06 -6.58%
5. 2019. 6. 30. $139.28 6.20% 2,941.76 6.89%
6. 2019. 7. 31. $130.22 -6.50% 2,980.38 1.31%
7. 2019. 8. 31. $128.36 $0.95 -0.70% 2,926.46 -1.81%
8. 2019. 9. 30. $129.38 0.79% 2,976.74 1.72%
9. 2019. 10. 31. $132.04 2.06% 3,037.56 2.04%
10. 2019. 11. 30. $137.49 $0.95 4.85% 3,140.98 3.40%
11. 2019. 12. 31. $145.87 6.09% 3,230.78 2.86%
12. 2020. 1. 31. $148.87 2.06% 3,225.52 -0.16%
13. 2020. 2. 29. $134.48 $0.95 -9.03% 2,954.22 -8.41%
14. 2020. 3. 31. $131.13 -2.49% 2,584.59 -12.51%
15. 2020. 4. 30. $150.04 14.42% 2,912.43 12.68%
16. 2020. 5. 31. $148.75 $1.01 -0.19% 3,044.31 4.53%
17. 2020. 6. 30. $140.63 -5.46% 3,100.29 1.84%
18. 2020. 7. 31. $145.76 3.65% 3,271.12 5.51%
19. 2020. 8. 31. $153.41 $1.01 5.94% 3,500.31 7.01%
20. 2020. 9. 30. $148.88 -2.95% 3,363.00 -3.92%
21. 2020. 10. 31. $137.11 -7.91% 3,269.96 -2.77%
22. 2020. 11. 30. $144.68 $1.01 6.26% 3,621.63 10.75%
23. 2020. 12. 31. $157.38 8.78% 3,756.07 3.71%
24. 2021. 1. 31. $163.13 3.65% 3,714.24 -1.11%
25. 2021. 2. 28. $158.46 $1.01 -2.24% 3,811.15 2.61%
26. 2021. 3. 31. $164.35 3.72% 3,972.89 4.24%
27. 2021. 4. 30. $162.73 -0.99% 4,181.17 5.24%
28. 2021. 5. 31. $169.25 $1.06 4.66% 4,204.11 0.55%
29. 2021. 6. 30. $164.74 -2.66% 4,297.50 2.22%
30. 2021. 7. 31. $172.20 4.53% 4,395.26 2.27%
31. 2021. 8. 31. $173.13 $1.06 1.16% 4,522.68 2.90%
32. 2021. 9. 30. $161.50 -6.72% 4,307.54 -4.76%
33. 2021. 10. 31. $162.88 0.85% 4,605.38 6.91%
34. 2021. 11. 30. $155.93 $1.06 -3.62% 4,567.00 -0.83%
35. 2021. 12. 31. $171.07 9.71% 4,766.18 4.36%
36. 2022. 1. 31. $172.29 0.71% 4,515.55 -5.26%
37. 2022. 2. 28. $164.57 $1.06 -3.87% 4,373.94 -3.14%
38. 2022. 3. 31. $177.23 7.69% 4,530.41 3.58%
39. 2022. 4. 30. $180.46 1.82% 4,131.93 -8.80%
40. 2022. 5. 31. $179.53 $1.13 0.11% 4,132.15 0.01%
41. 2022. 6. 30. $177.51 -1.13% 3,785.38 -8.39%
42. 2022. 7. 31. $174.52 -1.68% 4,130.29 9.11%
43. 2022. 8. 31. $161.34 $1.13 -6.90% 3,955.00 -4.24%
44. 2022. 9. 30. $163.36 1.25% 3,585.62 -9.34%
45. 2022. 10. 31. $173.97 6.49% 3,871.98 7.99%
46. 2022. 11. 30. $178.00 $1.13 2.97% 4,080.11 5.38%
47. 2022. 12. 31. $176.65 -0.76% 3,839.50 -5.90%
48. 2023. 1. 31. $163.42 -7.49% 4,076.60 6.18%
49. 2023. 2. 28. $153.26 $1.13 -5.53% 3,970.15 -2.61%
50. 2023. 3. 31. $155.00 1.14% 4,109.31 3.51%
51. 2023. 4. 30. $163.70 5.61% 4,169.48 1.46%
52. 2023. 5. 31. $155.06 $1.19 -4.55% 4,179.83 0.25%
53. 2023. 6. 30. $165.52 6.75% 4,376.86 4.71%
54. 2023. 7. 31. $167.53 1.21% 4,588.96 4.85%
55. 2023. 8. 31. $161.68 $1.19 -2.78% 4,507.66 -1.77%
56. 2023. 9. 30. $155.75 -3.67% 4,288.05 -4.87%
57. 2023. 10. 31. $148.34 -4.76% 4,193.80 -2.20%
58. 2023. 11. 30. $154.66 $1.19 5.06% 4,567.80 8.92%
59. 2023. 12. 31. $156.74 1.34% 4,769.83 4.42%
평균의 (R): 0.63% 1.11%
표준 편차: 4.96% 5.31%

모두 표시

1 보통주 주당 US$ 단위의 데이터로, 분할 및 주식 배당금에 맞게 조정됩니다.

2 기간 t 동안 JNJ의 보통주에 대한 수익률.

3 기간 t 동안 S&P 500(시장 포트폴리오 프록시)에 대한 수익률.


분산과 공분산

Johnson & Johnson, 수익률의 분산 및 공분산 계산

Microsoft Excel
t 날짜 RJNJ,t RS&P 500,t (RJNJ,tRJNJ)2 (RS&P 500,tRS&P 500)2 (RJNJ,tRJNJ)×(RS&P 500,tRS&P 500)
1. 2019. 2. 28. 3.35% 2.97% 7.40 3.49 5.08
2. 2019. 3. 31. 2.31% 1.79% 2.81 0.47 1.15
3. 2019. 4. 30. 1.01% 3.93% 0.14 7.98 1.07
. . . . . . .
. . . . . . .
. . . . . . .
58. 2023. 11. 30. 5.06% 8.92% 19.65 61.03 34.63
59. 2023. 12. 31. 1.34% 4.42% 0.51 11.00 2.37
합계 (Σ): 1,426.41 1,634.30 867.47
t 날짜 RJNJ,t RS&P 500,t (RJNJ,tRJNJ)2 (RS&P 500,tRS&P 500)2 (RJNJ,tRJNJ)×(RS&P 500,tRS&P 500)
1. 2019. 2. 28. 3.35% 2.97% 7.40 3.49 5.08
2. 2019. 3. 31. 2.31% 1.79% 2.81 0.47 1.15
3. 2019. 4. 30. 1.01% 3.93% 0.14 7.98 1.07
4. 2019. 5. 31. -6.44% -6.58% 50.06 59.04 54.36
5. 2019. 6. 30. 6.20% 6.89% 31.01 33.49 32.23
6. 2019. 7. 31. -6.50% 1.31% 50.91 0.04 -1.48
7. 2019. 8. 31. -0.70% -1.81% 1.77 8.50 3.87
8. 2019. 9. 30. 0.79% 1.72% 0.03 0.37 0.10
9. 2019. 10. 31. 2.06% 2.04% 2.03 0.88 1.34
10. 2019. 11. 30. 4.85% 3.40% 17.78 5.28 9.69
11. 2019. 12. 31. 6.09% 2.86% 29.86 3.07 9.58
12. 2020. 1. 31. 2.06% -0.16% 2.03 1.61 -1.81
13. 2020. 2. 29. -9.03% -8.41% 93.28 90.57 91.92
14. 2020. 3. 31. -2.49% -12.51% 9.74 185.44 42.51
15. 2020. 4. 30. 14.42% 12.68% 190.18 134.06 159.67
16. 2020. 5. 31. -0.19% 4.53% 0.67 11.71 -2.80
17. 2020. 6. 30. -5.46% 1.84% 37.08 0.54 -4.46
18. 2020. 7. 31. 3.65% 5.51% 9.11 19.40 13.29
19. 2020. 8. 31. 5.94% 7.01% 28.21 34.82 31.34
20. 2020. 9. 30. -2.95% -3.92% 12.84 25.29 18.02
21. 2020. 10. 31. -7.91% -2.77% 72.86 15.00 33.06
22. 2020. 11. 30. 6.26% 10.75% 31.67 93.10 54.30
23. 2020. 12. 31. 8.78% 3.71% 66.38 6.79 21.24
24. 2021. 1. 31. 3.65% -1.11% 9.14 4.93 -6.71
25. 2021. 2. 28. -2.24% 2.61% 8.26 2.26 -4.32
26. 2021. 3. 31. 3.72% 4.24% 9.53 9.85 9.69
27. 2021. 4. 30. -0.99% 5.24% 2.61 17.11 -6.69
28. 2021. 5. 31. 4.66% 0.55% 16.22 0.31 -2.24
29. 2021. 6. 30. -2.66% 2.22% 10.86 1.24 -3.68
30. 2021. 7. 31. 4.53% 2.27% 15.19 1.37 4.56
31. 2021. 8. 31. 1.16% 2.90% 0.28 3.22 0.94
32. 2021. 9. 30. -6.72% -4.76% 53.99 34.37 43.08
33. 2021. 10. 31. 0.85% 6.91% 0.05 33.74 1.30
34. 2021. 11. 30. -3.62% -0.83% 18.03 3.76 8.24
35. 2021. 12. 31. 9.71% 4.36% 82.43 10.60 29.56
36. 2022. 1. 31. 0.71% -5.26% 0.01 40.51 -0.53
37. 2022. 2. 28. -3.87% -3.14% 20.21 17.99 19.07
38. 2022. 3. 31. 7.69% 3.58% 49.88 6.11 17.45
39. 2022. 4. 30. 1.82% -8.80% 1.42 98.04 -11.80
40. 2022. 5. 31. 0.11% 0.01% 0.27 1.21 0.57
41. 2022. 6. 30. -1.13% -8.39% 3.08 90.21 16.67
42. 2022. 7. 31. -1.68% 9.11% 5.36 64.09 -18.53
43. 2022. 8. 31. -6.90% -4.24% 56.78 28.62 40.31
44. 2022. 9. 30. 1.25% -9.34% 0.39 109.11 -6.49
45. 2022. 10. 31. 6.49% 7.99% 34.39 47.34 40.35
46. 2022. 11. 30. 2.97% 5.38% 5.46 18.23 9.97
47. 2022. 12. 31. -0.76% -5.90% 1.93 49.04 9.73
48. 2023. 1. 31. -7.49% 6.18% 65.93 25.70 -41.16
49. 2023. 2. 28. -5.53% -2.61% 37.90 13.82 22.88
50. 2023. 3. 31. 1.14% 3.51% 0.25 5.76 1.21
51. 2023. 4. 30. 5.61% 1.46% 24.83 0.13 1.79
52. 2023. 5. 31. -4.55% 0.25% 26.85 0.74 4.44
53. 2023. 6. 30. 6.75% 4.71% 37.40 13.02 22.06
54. 2023. 7. 31. 1.21% 4.85% 0.34 13.99 2.18
55. 2023. 8. 31. -2.78% -1.77% 11.64 8.28 9.82
56. 2023. 9. 30. -3.67% -4.87% 18.47 35.73 25.69
57. 2023. 10. 31. -4.76% -2.20% 29.03 10.92 17.80
58. 2023. 11. 30. 5.06% 8.92% 19.65 61.03 34.63
59. 2023. 12. 31. 1.34% 4.42% 0.51 11.00 2.37
합계 (Σ): 1,426.41 1,634.30 867.47

모두 표시

분산JNJ = Σ(RJNJ,tRJNJ)2 ÷ (59 – 1)
= 1,426.41 ÷ (59 – 1)
= 24.59

분산S&P 500 = Σ(RS&P 500,tRS&P 500)2 ÷ (59 – 1)
= 1,634.30 ÷ (59 – 1)
= 28.18

공분산JNJ, S&P 500 = Σ(RJNJ,tRJNJ)×(RS&P 500,tRS&P 500) ÷ (59 – 1)
= 867.47 ÷ (59 – 1)
= 14.96


체계적인 위험 추정 (β)

Microsoft Excel
분산JNJ 24.59
분산S&P 500 28.18
공분산JNJ, S&P 500 14.96
상관 계수JNJ, S&P 5001 0.57
βJNJ2 0.53
αJNJ3 0.04%

계산

1 상관 계수JNJ, S&P 500
= 공분산JNJ, S&P 500 ÷ (표준 편차JNJ × 표준 편차S&P 500)
= 14.96 ÷ (4.96% × 5.31%)
= 0.57

2 βJNJ
= 공분산JNJ, S&P 500 ÷ 분산S&P 500
= 14.96 ÷ 28.18
= 0.53

3 αJNJ
= 평균의JNJ – βJNJ × 평균의S&P 500
= 0.63%0.53 × 1.11%
= 0.04%


예상 수익률

Microsoft Excel
가정
LT Treasury Composite의 수익률1 RF 4.80%
시장 포트폴리오에 대한 예상 수익률2 E(RM) 13.50%
보통주의 체계적 위험Johnson & Johnson βJNJ 0.53
 
Johnson & Johnson 보통주에 대한 기대 수익률3 E(RJNJ) 9.42%

1 10년 이내에 만기가 되지 않거나 콜 가능하지 않은 모든 미결제 고정 쿠폰 미국 재무부 채권에 대한 입찰 수익률의 가중 평균(무위험 수익률 프록시).

2 자세히 보기 »

3 E(RJNJ) = RF + βJNJ [E(RM) – RF]
= 4.80% + 0.53 [13.50%4.80%]
= 9.42%