Question
Using the data I provided, calculate 60 months of returns for the SPDR S&P 500 Index ETF, Microsoft, Exxon, and the iShares 13 Year Treasury
Using the data I provided, calculate 60 months of returns for the SPDR S&P 500 Index ETF, Microsoft, Exxon, and the iShares 13 Year Treasury Bond ETF. (Please compute simple monthly returns not continuously compounded returns.) Compute the average monthly returns for the SPDR S&P 500 Index ETF, Microsoft, Exxon, and the iShares 13 Year Treasury Bond ETF. If you form an equally weighted portfolio with these three equities and one bond, what is your portfolios average monthly return?
Monthly Returns | ||||
SPY | SHY | MSFT | XOM | |
Average | 1.34% | 0.14% | 2.71% | -0.21% |
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?
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