Question: Please answer in Excel and show ur work. Problem 3 Scenario Analysis Use the following scenario analysis for stocks X and Y to answer the

Please answer in Excel and show ur work.

Problem 3 Scenario Analysis

Use the following scenario analysis for stocks X and Y to answer the questions. Round to the nearest 1/100 of 1% (i.e., 15.07%).

	Bear	Normal	Bull
	Market	Market	Market
Probability	35.00%	55.00%	10.00%
Stock X	-13.00%	9.00%	19.00%
Stock Y	-21.00%	14.00%	46.00%

3.a) What are the expected rates of return for stocks X and Y (9 points)?

3.b) What are the standard deviations for of returns for stocks X and Y (8 points)?

3.c) If the riskfree rate of return is 1.75%, what are the Sharpe Ratios for stocks X and Y (8 points)? (Please assume that the standard deviations of the excess returns are the same as the standard deviations of returns calculated in part b.)

3.d) Assume you have a $150,000 portfolio and you invest $55,000 in stock X and the remainder in stock Y. What is the expected return for this portfolio (8 points)?

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!

please answer using excel and show your work Problem Three (15 marks) You are an analyst in charge of valuing common stocks. You have been asked to value two stocks. The first stock NEW Inc. just...

Assignment 1 Instructions Assignment 1 should be submitted after you have completed Unit 2. This assignment is worth 15 percent of your final grade. Assignment 1 contains five problems. The maximum...

show all questions in excel QUESTION 1 Consider the three stocks in the following table. P t represents the price at the end of period t and Q t is the number of shares outstanding. Stock C splits...

1 Indexes (33 points) Consider the three stocks in the following table. Pt represents the price at the end of period t and Qt is the number of shares outstanding. Stock C splits 3:1 during period 2....

this is all one question, they all go together. please bold final answer and show work Problem 10-47 (LO 10-2) (Algo) [The following information applies to the questions displayed below.] DLW...

34 points Question 3 Problem 3 Scenario Analysis (33 points) Use the following scenario analysis for stocks X and Y to answer the questions. Round to the nearest 1/100 of 1% (i.e., 15.07%). Bear...

Problem 3 Scenario Analysis (33 points) Use the following scenario analysis for stocks X and Y to answer the questions. Round to the nearest 1/100 of 1% (i.e., 15.07%). Bear Normal Bull Market Market...

MANAGERIAL ACCOUNTING CAN I GET HELP WITH THE FOLLOWING Cost-Volume-Profit Analysis Demonstrate your understanding of CVP analysis. Price and cost data per month are as follows: Sales Price per unit...

Cost-Volume-Profit Analysis Demonstrate your understanding of CVP analysis. Price and cost data per month are as follows: Sales Price per unit (current monthly sales volume is 120,000 units) $20.00...

Please help verify answers Questions 11 - 12 (3 points each): Use the following scenario to answer the questions. Consider the residual plots below. What do they tell you about the relationship of...

(i) Which of the following is the real part of a holomorphic function. Explain your reason- ing, but you do not need to find the holomorphic function. (a) g(x, y) = e cos(x), (b) h(x, y) = x + y....

Assume that tea and lemons are complements and that coffee and tea are substitutes. a. How, if at all, will the imposition of an effective ceiling price on tea affect the price of lemons? Explain. b....

Brief Exercise 11-15 Calculating Economic Value Added Refer to the information for East Mullett Manufacturing above. Total capital employed equaled $1,200,000. East Mulletts actual cost of capital is...

You are given the following linear programming model in algebraic form, where xl and 2 are the decision variables and Z is the value of the overall measure of performance. Maximize Z = 2x1 + 3x2...

The quality of the proposed ideas

The number of new ideas that emerge

7. Develop a circular model, with positive and negative feedback loops, showing the following critical variables: