Question: PLEASE DO NOT SHOW WORK THROUGH EXCEL. WILL THUMBS DOWN, THANK YOU 4.Using the following returns, calculate the average returns, the variance and standard deviations

PLEASE DO NOT SHOW WORK THROUGH EXCEL. WILL THUMBS DOWN, THANK YOU

4.Using the following returns, calculate the average returns, the variance and standard deviations for X and Y.

Probability

Return X

Return Y

25%

27%

0%

50%

10%

8%

25%

5%

20%

  1. Use the information given in 4 to find expected return and variance for a portfolio that consists of 30% in X and 70% in Y. Do you notice any benefits to investing in the portfolio rather than each stock individually?

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!

Q:

please answer all parts so i can check my answers thank you Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Year 1 2 3 4...

Q:

Please help and show work in Excel cost $10 million at Year 0 to buy the equipment necessary to manufacture the server. The project would require net working capital at the beginning of each year in...

Q:

Please show work in excel. Consider the following two funds and their estimated returns under different states of the economy State of Probability Estimated Return (Fund A) Estimated Return (Fund B)...

Q:

please show work in excel. Consider the following two funds and their estimated returns under different states of the economy State of Probability Estimated Return (Fund A) Estimated Return (Fund B)...

Q:

PLEASE SHOW WORK ON EXCEL :) Consider the following two funds and their estimated returns under different states of the economy: State of economy Great Average Poor Probability 30% 30% 40% Estimated...

Q:

please help with this question . thank you Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Returns Year Y 1 25% 24 46 13...

Q:

please do all parts to the question, thank you! Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Calculate the arithmetic...

Q:

Consider the following three stocks (U, V & W) with historical rates of returns. The figures are in percent. Year U V W 1 9.06 0.78 12.55 2 (5.14) (0.87) (5.90) 3 3.99 0.84 0.97 4 (2.86) (2.06)...

Q:

hello i need help with this question step by step please and thank you Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y....

Q:

Study Guide Healthcare Statistics By Jacqueline K. Wilson, RHIA About the Author Jacqueline K. Wilson is a Registered Health Information Administrator (RHIA) who has more than ten years of experience...

Q:

Charlies Pizza orders all of its pepperoni, olives, anchovies, and mozzarella cheese to be shipped directly from Italy. An American distributor stops by every four weeks to take orders. Because the...

Q:

Provide some examples of different types of waste in an organization with which you are familiar, such as an automobile repair shop or a fast-food restaurant.

Q:

6. The Merchandise Inventory account name appears on the worksheet in the: a. credit column of the Balance Sheet section. b. debit column of the Balance Sheet section. c. credit column of the Income...

Q:

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...