Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Excel file Stock Data contains monthly data for several stocks and the S&P 500 Index (i.e., the market). Compute the average monthly return for
- The Excel file Stock Data contains monthly data for several stocks and the S&P 500 Index (i.e., the market).
- Compute the average monthly return for PFE.
- Compute the annualized return for PFE.
- Compute the annual risk (i.e., variance and standard deviation) for PFE.
PFE | S&P 500 |
4.31% | 2.40% |
7.61% | 5.20% |
-0.56% | 4.00% |
-5.94% | -0.50% |
14.35% | 9.00% |
6.54% | 1.90% |
-0.90% | -0.40% |
-1.45% | -2.30% |
10.47% | 2.10% |
-6.24% | 2.40% |
-1.44% | -6.70% |
-13.12% | 1.30% |
2.76% | 2.60% |
-6.39% | -2.50% |
17.24% | 9.80% |
-2.66% | -0.70% |
18.13% | -0.30% |
-5.49% | -9.00% |
-0.53% | -4.90% |
3.01% | -0.40% |
11.90% | 6.40% |
0.00% | 2.70% |
11.30% | 4.40% |
17.59% | 7.20% |
1.90% | 2.40% |
1.87% | 0.30% |
8.65% | 4.30% |
-5.73% | -4.60% |
11.49% | 4.70% |
6.43% | 2.40% |
-0.57% | -1.60% |
9.98% | 1.30% |
-6.88% | -4.00% |
26.55% | 11.40% |
-13.09% | -1.90% |
2.57% | 1.30% |
-6.71% | -2.00% |
2.88% | 2.90% |
4.91% | 0.50% |
-2.18% | -1.50% |
7.36% | 4.00% |
-0.97% | -2.00% |
-3.24% | 1.20% |
1.17% | 0.40% |
3.81% | 3.40% |
-7.20% | 1.30% |
-8.97% | 0.70% |
-10.96% | 1.40% |
-0.56% | 4.00% |
-5.94% | -0.50% |
14.35% | 9.00% |
-13.12% | 1.30% |
2.76% | 2.60% |
-6.39% | -2.50% |
1.90% | 2.40% |
1.87% | 0.30% |
8.65% | 4.30% |
-6.71% | -2.00% |
3.81% | 3.40% |
2.88% | 2.90% |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started