50.1K

Verified Solution

Link Copied!

[10 marks] In your Excel file, column B contains gross monthly percentage returns on a portfolio of US stocks (denoted by \\( r p \\) ), column \\( \\mathrm{C} \\) contains gross monthly returns on the market portfolio (denoted by \\( \\mathbf{r m} \\) ) and column D contains monthly returns on the risk-free asset (denoted by \\( \\boldsymbol{r} \\boldsymbol{f} \\) ). Columns \\( \\mathrm{E}, \\mathrm{F} \\) and \\( \\mathrm{G} \\) contain values for three further variables denoted by SMB, RMW and CMA, which are used in later questions. a) Import these data into EViews with the same variable names as in the Excel file (e.g. \\( r p, r m \\), etc.). b) Generate two new series named \\( r p \\_e x \\) and \\( r m_{-} \\)ex containing the excess returns above the risk-free rate for the industry portfolio and the market portfolio respectively (i.e. the portfolio returns minus the risk-free asset returns). c) In EViews Calculate the following descriptive statistics for \\( r p \\_e x \\) and \\( r m \\_e x \\) : mean, standard deviation, skewness and kurtosis. Insert a table containing these values in the box below. d) In the same box, briefly interpret the sample values of the descriptive statistics in your table (mean, SD, skewness and kurtosis) and explain what they imply about excess returns on the two portfolios

Answer & Explanation Solved by verified expert

See Answer