Question: 2. Using the data from problem 1, calculate excess returns for the SPDR S&P 500 Index ETF, Microsoft and Exxon. Use the monthly returns on
2. Using the data from problem 1, calculate excess returns for the SPDR S&P 500 Index ETF, Microsoft and Exxon. Use the monthly returns on the iShares 13 Year Treasury Bond ETF as your monthly riskfree return. Compute the average monthly excess returns for the SPDR S&P 500 Index ETF, Microsoft and Exxon. If you form an equally weighted portfolio with these three equities, what is your portfolios average monthly excess return? Enter your answer rounded to two decimal places. Do not enter % in the answer box. For example, if your answer is 0.12345 or 12.345% then enter as 12.35 in the answer box.
| SPY | SHY | MSFT | XOM |
| 1.51% | 0.13% | 3.09% | -0.03% |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
