Question: please explain in excel with formula please read question carefully 1) what is the expected return of portfolio with EQUAL weights in these stocks?? 2)

please explain in excel with formula

please read question carefully

1) what is the expected return of portfolio with EQUAL weights in these stocks??

2) what is the variance of a portfolio invested 20% each in A and B and 60% in C??

Consider the following information: Economic condition Probability Stock A Return Stock B Return Stock C Return Boom 0.65 6% 16% 33% Bust 0.35 14% 2% -6% What is the expected return of a portfolio with equal weights in these three stocks? What is the variance of a portfolio invested 20% each in A and B. and 60% in C

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 following information: Economic condition Probability Stock A Return Stock B Return Stock C Return Boom 0.65 6% 16% 33% Bust 0.35 14% 2% 6% What is the expected return of a portfolio...

please explain in excel with formula with each step Economic condition Probability Stock A Return Stock B Return Stock C Return Boom 0.65 6% 16% 33% Bust 0.35 14% 2% -6% What is the expected return...

this is the question about financial economics, my group already finished all of questions and left (g) and (i) . I will upload my word and excel for question data and group work, please add your...

I need help in this finance practice question! Choose any 5 Canadian stocks. a.Find weekly returns of each stock for the past year (you must have returns 50 returns for each stock). Find the...

(Local Valuation VaR) ? Excel Project I need to choose and download three stock prices from YahooFinance and then calculate the means, standard deviations, correlations and co-variances of their...

for any calculation please use an excel formula and for questions 8 and 9 only calculate the expected returns. please show work as well Portfolio Returns Exercise Stock A Weight - 0.50 1. The return...

intructions are provided The Excel supplement has the returns of three market indices - Australia, Germany, and France from 1981 to 1997. Please provide the Excel file with your submission. Question:...

can someone please explain the excel formulas in the excel graph at the bottom of this question ? herevel that the expected teturn of the pertille in tant? Rxplain? Qoestion 9: Ideatify the...

3). Please finish the following three sub-problems. (1) What is the expected return and standard deviation of the optimal (tangency) risky portfolio? (Hint: The weights of the two risky assets within...

Choose 5 Canadian stocks. use weekly adjusted close prices for the past calendar year (22/02/2020-19/02/2021) for each chosen stock! a. Find weekly returns of each stock for the past year (you must...

Dyna Ltd has acquired land in a business combination. The land is currently developed for industrial use as a site for a factory. The current use of land is presumed to be its highest and vest use...

Let Discuss.

16 a Draw factor trees to find the LCM of 90 and 140. b Compare your answer with a partners. Did you draw the same factor trees? Have you both got the same answer?

Becton Labs Inc. produces various chemical compounds for industrial use. One compound, called Fludex, is prepared by means of an elaborate distilling process. The company has developed standard costs...