Question: please use excel Problem 1: The following probability distribution is given for returns of Stock X Market Condition Probability Stock X Good 0.5 40% Average

please use excel Problem 1: The following probability distribution is given

please use excel

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 Stock X (b) Calculate the standard deviation of returns of 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!

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...

Sign MBL5903-2017-10-E-1 PAST EXA X + File C:/Users/daisy/Desktop/MBL5903/MBL5903-2017-10-E-1%20PAST%20E... Question 1 [14 marts) You plan to Invest in the Kish Hedge Fund, which has total capital of...

number 10 by hand please! APLES 9. Project A has the following cash flows: YEAR 0 Cash flow (9,000) 3,000 1 2 4 5 6,000 1000 2000 5000 The payback period for the project A a. zero yrs. b. 5 yrs. C. 3...

Solve and show work for #13, please and thank you! Please write it out in a way that is easy to understand. 12. The following probability distibutions are given for returns of Stock X and Market...

You plan to invest in the Kish Hedge Fund, which has total capital of $500 million invested in five stocks: Stock Investment Stock's Beta Coefficient A $160 million 0.5 B 120 million 1.4 80 million...

The following probability distribution of returns for Stocl X: Market Condition Stock X Probability Very Good 40% 0.2 Good 20% 0.5 Recession -10% 0.3 Calculate the standard deviation of returns for...

The following probability distribution of returns for Stocl X: Market Condition Stock X Probability Very Good 40% 0.2 Good 20% Recession -10% 0.3 Calculate the ecpected return on Stock X 0.5 8% 20%...

Hi, how to do question 4 using the Ti-84 calculator? thanks. 1. The following probability distributions are given for return of Stock X and Stock Y. Use this data to answer questions 1 thre Market...

CanComp has a contract to deliver a large computer system to a South African company in one year and would like to hedge the currency risk. CanComp will receive payment of R3.5 million (the currency...

A 2,400 square foot building has an remaining economic life of 55 years. Its current effective age is 15 years and the cost new is estimated at $102 per square foot. Land value is estimated at...

Etonic Inc. is considering an investment of $ 3 7 2 , 0 0 0 in an asset with an economic life of 5 years. The firm estimates that the nominal annual cash revenues and expenses at the end of the first...

10 11 12 A financial statement assertion that is probable of misstatement given the nature of the further audit procedures performed. A financial statement assertion that has a reasonable possibility...