Question: excel pls Use data for Stocks A, B & C below to calculate: 1. Expected return and standard deviation of returns for each stock (so,

excel pls

$excel pls Use data for Stocks A, B \& C below to$

Use data for Stocks A, B \& C below to calculate: 1. Expected return and standard deviation of returns for each stock (so, three expected returns, and three standard deviations). 2. The weighted average of the three standard deviations found in question 1 , assuming 20% is invested in Stock A, 20\% in Stock B, and 60% in stock C. 3. Expected return and standard deviation of a portfolio that has 20% invested in Stock A, 20% in Stock B, and 60% in stock C. 4. Compare the standard deviation in question 3 and the standard deviation in question 2 . Why are they different? Answer briefly ( 1 sentence). This data can be copied and pasted into Excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Use data for Stocks A, B \& C below to calculate: 1. Expected return and standard deviation of returns for each stock (so, three expected returns, and three standard deviations). 2. The weighted...

2. Consider the information in Table 1 Table 1 Expected Return (% Standard Deviation (% Covariance (Stock 1, Stock 2) Covariance (Stock 1, Stock 3) Stock 1 4.2% 2.49% Stock 2 48% 2.59% 2.30 -20.25...

Assume you are constructing the efficient portfolio frontier with three risky stocks A, B, and C as follows. Stock Expected return Standard deviation A 10% 15% B 20% 30% 20% 30% Correlation A B A 1...

1. Calculate the expected return, standard deviation of returns and coefficient of variation for the stocks below. The data for Stock A is based on predictions and the data for Stock B is historical....

a. Using the information from Table 1, calculate the expected return, standard deviation of returns and covariance of returns with the market (Mkt) returns of an investor's portfolio that consists of...

Q #1 (Expected return. standard deviation and capital asset prising model} The following are the endeofrmonth prices for both the Standard & Poor's 500 Index and Nike's common stock. a. Using the...

Question 1 Assume that the CAPM holds. Consider a stock market that consists of only two risky securities, Stock 1 and Stock 2, with the following expected returns (1) and standard deviations of...

Using the data in the table, answer the questions that follow. Asset Expected Return Standard Deviation Stock Fund S 18% 30% Bond Fund B 9% 20% T-Bills 5% -- The correlation coefficient between the...

What is the difference between a cash dividend and a stock dividend? Which would be more valuable to you? How does a stock dividend compare to a stock split? Is a 200% stock dividend the same as a...

Your next-door neighbor recently began a new job as assistant controller for Conundrum Corporation. As her first assignment, she prepared a performance report for January. She was scheduled to...

Glven the following two bond: Bond A is a twenty year bond making semi annual coupon payments, with a coupon rate of 5 sk and a y 1 2 . 1 2 year zero - coupon bond with a yield to maturity of 7 % ....

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...