Question: By using the excel spreadsheet , compute the expected return and standard deviation of the returns on a portfolio that is invested in stocks A,

By using the excel spreadsheet, compute the expected return and standard deviation of the returns on a portfolio that is invested in stocks A, B, and C? The total amount you invested in the portfolio is $150,000, where $33,500 of this amount of money is invested in stock A and $45,000 is invested in stock B, the rest were invested in stock C.

State of Economy

Probability of state of Economy

Return if state Occurs

Stock A

Stock B

Stock C

Boom

20%

17%

6%

25%

Normal

45%

8%

10%

15%

Recession

???

1%

12%

-19%

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:

By using the excel spreadsheet, compute the expected return and standard deviation of the returns on a portfolio that is invested in stocks A, B, and C? The total amount you invested in the portfolio...

Q:

please follow the below pattern Step 1: Find the probability of state of economy: - Boom = ?? - Normal = ?? - Recession = ?? show the answer in percentage. Step 2: Find the wight for the stocks: All...

Q:

By using the excel spreadsheet, compute the expected return and standard deviation of the returns on a portfolio that is invested in stocks A, B, and C? The total amount you invested in the portfolio...

Q:

+ Task By using the excel spreadsheet, compute the expected return and standard deviation of the returns on a portfolio that is invested in stocks A, B, and C? The total amount you invested in the...

Q:

Question 1: By using the excel spreadsheet, compute the expected return and standard deviation of the returns on a portfolio that is invested in stocks A, B, and C? The total amount you invested in...

Q:

By using the excel spreadsheet, compute the expected return and standard deviation of the returns on a portfolio that is invested in stocks A, B, and C? The total amount you invested in the portfolio...

Q:

Question 1: By using the excel spreadsheet, compute the expected return and standard deviation of the returns on a portfolio that is invested in stocks A, B, and C? The total amount you invested in...

Q:

By using the excel spreadsheet, compute the expected return and standard deviation of the returns on a portfolio that is invested in stocks A, B, and C? The total amount you invested in the portfolio...

Q:

By using the excel spreadsheet , compute the expected return and standard deviation of the returns on a portfolio that is invested in stocks A, B, and C? The total amount you invested in the...

Q:

By using the excel spreadsheet , compute the expected return and standard deviation of the returns on a portfolio that is invested in stocks A, B, and C? The total amount you invested in the...

Q:

What are the types of system changes an IT auditor should be aware of? Diagram the processes of those three types of changes. What are the control points?

Q:

Explain the preliminary data collection methods.

Q:

"2 (14 pts) Based upon your financial forecast for the years 20X3 - 20X7, compute 2a through 2d below FROM THE VIEWPOINT OF THE SHARK, placing your final results in the yellow highlighted area....

Q:

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...