Question: plz solve using excel! IM Problem 4: PART A: Given the following data: Market Condition Probability Stock A Stock B High Growth 0.2 50% 30%

plz solve using excel!

IM Problem 4: PART A: Given the following data: Market Condition Probability Stock A Stock B High Growth 0.2 50% 30% Average Growth 0.5 20% 30% Poor Growth 0.1 -10% 0% Recession 0.2 -5% -5% A portfolio is formed by investing 50% of the funds in Stock A and 50% in Stock B; (A) Calculate the expected retum on the portfolio. (B) Calculate the standard deviation of the portfolio. Part-B: Given the following historical data: Year Rate of return for Stock X 2020 25% 2019 16% 2018 14% 2017 -10% Calculate the average return and the standard deviation of returns for Stock X

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!

USE EXCEL TO SHOW ALL YOUR WORK Problem 2: Given the following data: Market Condition Probability Stock A Stock B High Growth Average Low Growth Poor 0.3 0.5 0.1 0.1 50% 20% 5% -15% 30% 25% 5% 0% I...

Problem 2: Given the following data: Market Condition Probability Stock A Stock B High Growth Average Low Growth Poor 0.3 50% 0.5 20% 0.1 5% 0.1 -15% 30% 25% 5% 0% A portfolio is formed by investing...

Problem 2: Given the following data: Market Condition Probability Stock A Stock B High Growth Average Low Growth Poor 0.3 0.5 0.1 0.1 50% 20% 5% -15% 30% 25% 5% 0% 1) A portfolio is formed by...

Problem 1: The following probability distribution is given for retums of Stock X Market Condition Probability Stock X Good 0.3 40% Average 0.5 20% Poor 0.2 -10% (a) Calculate the expected return of...

Problem 1: The following probability distribution is given for returns of Stock X Market Condition Probability Stock X Good 0.5 40% Average 0.3 20% Poor 0.2 -10% (a) Calculate the expected return of...

10 amd 11 please! do not use excel please 9. Project A has the following cash flows: YEAR Cash flow (9,000) 3,000 The payback period for the project A a. zero yrs. b. 5 yrs. c. 3 yrs. (d. 2 yrs. e....

must be answered on excel PROBLEM 4: Part-A Based on the following data; State of the Economy Probability Stock A Rate of Return Stock B Rate of Return Recession 0.2 5% -20% Low Growth 0.3 10% 10%...

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

Please help...thank you! PART A - MULTIPLE CHOICE QUESTIONS 1. Real GDP is nominal GDP adjusted for: A) double counting. B) changes in prices. C) population. D) imports. 2. What do a rubbernecking...

I am looking for the correct answer for this Q .. Can you help me :) I need also steps with Calculatorplz Thanks....

Austin, Inc., acquired 10 percent of McKenzie Corporation on January 1, 2014, for $210,000 although McKenzies book value on that date was $1,700,000. McKenzie held land that was undervalued by...

Consider the four entries in the preceding brief exercise. In Exercise Required Identify each entry as an accrued expense, an accrued revenue, a deferred expense, or a deferred revenue. 1. Utilities...

Question 1 5 1 pts Which one of the following is a true statement about retirement planning? You can expect to spend about 1 6 to 3 0 years in retirement. It's never too early to begin planning for...

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".