Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

undefined Please use excel and show how to find the variance Suppose Johnson & Johnson and the Walgreen Company have the expected returns and volatilities

image text in transcribedundefined

Please use excel and show how to find the variance

Suppose Johnson & Johnson and the Walgreen Company have the expected returns and volatilities shown below, with a correlation of 22.0%. E[R] SD [R] Johnson & Johnson 7.0% 16.0% Walgreen Company 10.0% 20.0% For a portfolio that is equally invested in Johnson & Johnson's and Walgreen's stock, calculate: a. The expected return. b. The volatility (standard deviation). a. The expected return. The expected return of the portfolio is 8.5 %. (Round to one decimal place.) b. The volatility (standard deviation). The volatility of the portfolio is \%. (Round to one decimal place.)

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

Crypto Spotlight Series Binance Coin

Authors: Nott U.r. Keys

1st Edition

979-8853049529

More Books

Students also viewed these Finance questions

Question

Explain the factors that determine value.

Answered: 1 week ago