[10 marks] In your Excel file, column B contains gross monthly percentage returns on a...

50.1K

Verified Solution

Question

Finance

image [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
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students