Question: i need the formulas for the blanks please Consider the following information. Your portfolio is invested 30 percent each in A and C, and 40

i need the formulas for the blanks please

Consider the following information. Your portfolio is invested 30 percent each in A and C, and 40 percent in B. What is the expected return of the portfolio? What is the variance of this portfolio? The standard deviation? Input oreo: State Boom Good Poor Bust weights Probability 0.15 0,45 0.30 0.10 Stock A 0.35 0.16 (0.01) (0.10 0.30 Stock B 0.40 0.17 (0.03) (0.12) 0.40 Stock 0.28 0.09 0.01 (0.09) 0.30 (Use cells A6 to E11 from the given information to complete this question) Output area: Portfolio return Product Return deviation Squared deviation Product Stock A Boom Good Poor Bust Probability 0.15 0.45 0.30 0.10 . ER Variance Standard deviation

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!

Consider the construction of a sulfur pollution control system at the power generating facility in Page, AZ. The aim of the project is to install sulfur dioxide "scrubbers" at the power plant in...

Consider the following information. Your portfolio is invested 30 percent each in A and C, and 40 percent in B. What is the expected return of the portfolio? What is the variance of the portfolio?...

Consider the following information: Your portfolio is invested 30 percent each in A and C, and 40 percent in B. What is the expected return of the portfolio? What is the variance of this portfolio?...

Consider the following information your portfolio is invested 30 percent each in A and C,and 40percent in B Consider the following information. Your portfolio is invested 30 percent each in A and C,...

Returns and Standard Deviations [LO1] Consider the following information: Your portfolio is invested 30 percent each in A and C, and 40 percent in B. What is the expected return of the portfolio?...

each answer needs to be answered with an excel formula, you can not type in any numbers. thank you! XB55 - 5 x FILE HOME INSERT Sign in X Calibri - 11 Returns and standard deviations - Excel PAGE...

29. Consider the following information. Your portfolio is invested 30 percent each in A and C, and 40 percent in B. What is the expected return and standard deviation of this portfolio? (10 marks)...

A1 V 3 fx B D G H 2 3 Consider the following information. Your portfolio is invested 30 percent each in A and C, and 40 percent in B. What is the expected return of the portfolio? What is the...

MUST INCLUDE FORMULA A1 V 3 fx B D G H 2 3 Consider the following information. Your portfolio is invested 30 percent each in A and C, and 40 percent in B. What is the expected return of the...

D AB G E F H 1 2 3 Consider the following information. Your portfolio is invested 30 percent each in A and C, and 40 percent in B. What is the expected return of the portfolio? What is the variance...

Given that the linear transformation T: C2 C3, is injective, show directly that {T (e1), T (e2)} is a linearly independent set. x +y 2x + y ()- B). [x + 2y]

Briefly review the 5 trust-related issues of imperfect managerial duty and their overall implications?

PLA 6 RG 5 Ty / 2 6 2 1 6 5 / 5 0 nqtR 9 4 8 / mQ 4 tCD 3 The Senior Bookkeeper for Acme Corporation is looking at the Balance Sheet Report provided by their software and something is wrong. It...

1 . Create a function distance _ conversion that takes in two parameters, distance and unit, of types float and string respectively. Based on the unit type, "metric" or "imperial", it will convert...