Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance From Kaiser To Fuhrer Budget Politics In Germany 1912-1934

Authors: C. Edmund Clingan

1st Edition

0313311846, 9780313311840

More Books

Students also viewed these Finance questions