Question: Please calculate the risk and expected return using STDEV.P and AVERAGE for each column of returns. Please construct two portfolios and then calculate the risk

Please calculate the risk and expected return using STDEV.P and AVERAGE for each column of returns. Please construct two portfolios and then calculate the risk of the portflios. Portflio 1 will be 50% asset A and 50% asset B. Portfolio 2 will be 50% asset 1 and 50% asset 3.

Please summarize the risk and return for each portfolio.

outcome number return on return on return on asset A asset B asset C 1 0.00% 0.00% 2.00% 2 0.00% 0.00% 2.00% 3 1.00% -1.00% 1.00% 4 -1.00% 1.00% 0.00% 5 -1.00% 1.00% -2.00% 6 1.00% -1.00% -1.00% 7 -1.00% 1.00% 0.00% 8 -1.00% 1.00% 1.00% 9 1.00% -1.00% 2.00% 10 0.00% 0.00% 0.00% 11 1.00% -1.00% -1.00% 12 1.00% -1.00% 1.00% 13 0.00% 0.00% -1.00% 14 -1.00% 1.00% -2.00% 15 -1.00% 1.00% 1.00% 16 0.00% 0.00% 2.00% 17 1.00% -1.00% 1.00% 18 1.00% -1.00% -2.00% 19 1.00% -1.00% -2.00% 20 -1.00% 1.00% 0.00% 21 0.00% 0.00% -1.00% 22 -1.00% 1.00% -1.00% 23 -1.00% 1.00% 2.00% 24 0.00% 0.00% 2.00% 25 0.00% 0.00% 2.00% 26 0.00% 0.00% 0.00% 27 -1.00% 1.00% -1.00% 28 1.00% -1.00% 0.00% 29 -1.00% 1.00% -1.00% 30 0.00% 0.00% 1.00% 31 -1.00% 1.00% 1.00% 32 0.00% 0.00% 0.00% 33 -1.00% 1.00% 2.00% 34 0.00% 0.00% -2.00% 35 -1.00% 1.00% 1.00% 36 0.00% 0.00% -2.00% 37 1.00% -1.00% 0.00% 38 -1.00% 1.00% 0.00% 39 1.00% -1.00% 0.00% 40 1.00% -1.00% -2.00% 41 1.00% -1.00% 2.00% 42 -1.00% 1.00% 2.00% 43 0.00% 0.00% 1.00% 44 0.00% 0.00% 2.00% 45 -1.00% 1.00% -1.00% 46 0.00% 0.00% 1.00% 47 0.00% 0.00% 1.00% 48 -1.00% 1.00% 0.00% 49 0.00% 0.00% 0.00% 50 -1.00% 1.00% -2.00%

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!

Im unsure how to calculate these. The numbers Im getting dont seem correct. Help please! Normal No Spac... Heading1 Headi Styles Paragraph Font ignment 1 John and Mary Potter are both 46 years old...

Uraw Page Layout Formulas Data Review View Tell me X Arial - 12 A A 20 General Pasta BU Av {"4800 $% 23 sent Delete It Format Conditional Format Cell Formatting as Table Styles Z Sort A1 fx Build a...

Hello. I need to write a three page review for the two articles attached. Each review should include a brief summary that include the major points of the article, as well as a summary of my own...

Arial 10 Wrap Text I USA Paste B EE EEE Merge & Center AS X Also, you cannot calculate the rate of return for 2014 because you do not have 2013 data.) D F G H 5 6. Use the data given to calculate...

The attached file contains hypothetical data for working this problem. Goodman Corporations and Landry Incorporateds stock prices and dividends, along with the Market Index, are shown in the file....

PLEASE HELP ANSWER WHOLE QUESTION OR TAKE ANOTHER EXTRA QUESTION TO ANSWER THE WHOLE QUESTION Start with the partial model in the file Cho6 P15 Build a Model.xlsx on the resource textbook's Web site....

You have been hired to do some due diligence fer a famous investor from Omaha who is interested in investing in one of two companies, Goodman or Landryr Corp. The investor has given you Goodman...

You have been assigned to construct the optimal portfolio comprising two risky assets (Portfolios A & B) while considering the client?s risk tolerance. The attached spread sheet shows historical...

QUESTION 1 Although recent events in Hong Kong have created uncertainty, often such things can also provide opportunities for investors. As a first step, an investor considering the Hong Kong share...

I need help putting the below assignment together in excel. I the solutions to be in excel so that I can cross reference with my notes. Thanks FIN 5620-EVT: Jack De Jong: Quantitative Problem Set #3:...

What reasons does Albert Einstein provide for why we need to move away from a Capitalist system and toward a Socialist one? What does he as the benefits of Socialism? How does this relate to...

A company using the periodic inventory system has the following account balances: Inventory at the beginning of the year, $3,995; Freight-In, $583; Purchases, $13,847; Purchases Returns and...

What type of shift register will be used when we are receiving the data in the computer from the modem?

Multiple Choice Which of the following is NOT a reason for the bullwhip effect? A. Ordering a quantity that exceeds demand B. Ordering a quantity that exactly matches demand C. Stocking up with items...

1. Avoid conflicts in the relationship

3. What is happening here and now (1 is oriented towards the proactive, 2 towards the reactive and 3 is a balance between the two). c. Source of inspiration: When I communicate it is important for me...

1. What will happen in the future