View the step-by-step solution to:

Attached are the instructions and data for this excel assignment regarding asset and portfolio management I was unable to upload the excel file

Attached are the instructions and data for this excel assignment regarding asset and portfolio management I was unable to upload the excel file directly but this is everything needed in order to solve the problems. Thank you!

Assignment Instructions.jpg

Asset Management Assignment Data0.jpgAsset Management Assignment Data1.jpgAsset Management Assignment Data2.jpgAsset Management Assignment Data3.jpgAsset Management Assignment Data4.jpgAsset Management Assignment Data5.jpgAsset Management Assignment Data6.jpgAsset Management Assignment Data7.jpg

Asset Management Assignment Data0.jpg

Asset Management Assignment Data1.jpg

Asset Management Assignment Data2.jpg

Asset Management Assignment Data3.jpg

Asset Management Assignment Data4.jpg

Asset Management Assignment Data5.jpg

Asset Management Assignment Data6.jpg

Asset Management Assignment Data7.jpg

Assignment Instructions.jpg

Spring 2018 Homework Assignment 3 For this assignment, you will use the data in the spreadsheet Assignement3_Data.xlsx. 1. Worksheet “Returns” contains monthly returns over the 20—year period for three
stocks, F, IBM, XOM, as well as monthly returns on RF (risk—free), MKTRF
(excess return on market portfolio), and Fama—French factors SMB and HML.
Estimate the factor loadings (betas) for the excess returns on F, IBM, and XOM
using Fama-French 3-factor model. For the three stocks, compute predicted excess
returns and residuals. For F, IBM, and XOM, compute t-statistics for the OLS regression and highlight
statistically significant coefficients. Compute the factor covariance matrix V and the residuals covariance matrix (for
specific risks of the three stocks) Delta. Next, compute the covariance matrix for
the three stocks Sigma in two ways: (1) using historical excess returns, Sigma = Sigma(historical), and (2) using the estimates from the 3-factor model, Sigma = BVB’ + Delta. Verify that the two approaches produce the same matrices. Is matrix Delta close to
diagonal? Please report all covariance matrices in annualized form. Now replace Delta with a diagonal matrix diag(De1ta), where the main diagonal of
diag(Delta) is the same as that for Delta and all other elements are set to zero.
Define matrix Sigmal = BVB’ + diag(Delta). For covariance matrix Sigma, compute the minimum-variance portfolio (MVP) of
the three stocks. Similarly, for covariance matrix Sigmal, also compute the
minimum-variance portfolio (MVPl). Are MVP and MVP] similar? Worksheet “Characteristics” contains monthly returns for December, 2003 on six
stocks (BUD, DELL, DIS, IBM, INTC, XOM) along with their Market Cap, Price—
Earnings ratio, and Price—Book ratio. Run a cross—sectional regression on constant,
Size, PE ratio, and BP ratio to estimate factor returns for December, 2003.
(Remember to first normalize raw values for Size, PE ratio, and BP ratio.) For the
six stocks, compute predicted excess returns and residuals for December, 2003.
Finally, using the sensitivity matrix B, compute the factor-mimicking portfolios
(matrix W).

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question