Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Intro Download this spreadsheet with stock prices for five consumer packaged goods companies and the S&P 500. Part 1 Attempt 1/10 for 9 pts. What

image text in transcribed

Intro Download this spreadsheet with stock prices for five consumer packaged goods companies and the S&P 500. Part 1 Attempt 1/10 for 9 pts. What was the monthly return for Unilever (UN) from January to February 2015? 5+ decimals Submit Part 2 Attempt 1/10 for 9 pts. What was the monthly return for an equally-weighted portfolio of the five stocks (excluding the S&P 500) from January to February 2015? 4+ decimals Submit Part 3 - Attempt 1/10 for 9 pts. Regress the returns for each stock and the portfolio on the returns for the S&P 500. What is the R2 of the regression for the portfolio? 3+ decimals Submit Part 4 - Attempt 1/10 for 9 pts. What is the R2 of the regression for a portfolio with the following weights? B D E F G H 1 39 Portfolio KOMDLZ PEP PG UN 40 Weights 0.2 0.2 0.1 0.15 0.35 3+ decimals Submit Intro Download this spreadsheet with stock prices for five consumer packaged goods companies and the S&P 500. Part 1 Attempt 1/10 for 9 pts. What was the monthly return for Unilever (UN) from January to February 2015? 5+ decimals Submit Part 2 Attempt 1/10 for 9 pts. What was the monthly return for an equally-weighted portfolio of the five stocks (excluding the S&P 500) from January to February 2015? 4+ decimals Submit Part 3 - Attempt 1/10 for 9 pts. Regress the returns for each stock and the portfolio on the returns for the S&P 500. What is the R2 of the regression for the portfolio? 3+ decimals Submit Part 4 - Attempt 1/10 for 9 pts. What is the R2 of the regression for a portfolio with the following weights? B D E F G H 1 39 Portfolio KOMDLZ PEP PG UN 40 Weights 0.2 0.2 0.1 0.15 0.35 3+ decimals Submit

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

Reforming U.S. Financial Markets Reflections Before And Beyond Dodd Frank

Authors: Randall S. Kroszner, Robert J. Shiller

1st Edition

0262015455, 0262294907, 9780262015455, 9780262294904

More Books

Students also viewed these Finance questions