Question: Please show work and formulas in Excel Based on the following data; State of the Economy Probability Stock A Rate of Return Recession 0.2 -5%

Please show work and formulas in Excel

Please show work and formulas in Excel Based on the following data;

Based on the following data; State of the Economy Probability Stock A Rate of Return Recession 0.2 -5% Low Growth 0.3 10% Normal Growth 0.5 20% Calculate the expected return and the standard deviation on Stock A. Part-B: Given the following historical data: Year Rate of return for Stock X Rate of Return for Stock Y 2020 25% 10% 2019 16% 12% 2018 14% 8% 2017 5% 10% Calculate the average return and the standard deviation of returns for a portfolio where 50% of the funds are invested in Stock X and the rest in Stock Y

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 USE EXCEL AND SHOW FORMULAS PLEASE USE EXCEL AND SHOW FORMULAS PLEASE USE EXCEL AND SHOW FORMULAS PLEASE USE EXCEL AND SHOW FORMULAS PROBLEM 2: Part-A Based on the following data; State of the...

PROBLEM 2: Part- A Based on the following data; State of the Economy Probability Stock A Rate of Return Recession 0.2 -5% - Low Growth 0.3 10% Normal Growth 0.5 20% Calculate the expected return and...

please complete using excel. thank you!! PROBLEM 2: Part. A Based on the following data; State of the Economy Probability Stock A Rate of Return Recession 0.2 -5% Low Growth 0.3 10% Normal Growth 0.5...

please use excel!!! Based on the following data; State of the Economy Probability Stock A Rate of Return Stock B Rate of Return Recession Low Growth 0.2 0.25 5% 10% -20% 10% Normal Growth 0.40 5% 15%...

Stocks - calculate Expected Return and Standard Deviation, etc. Please show how to enter it into a calculator. Our teacher wants us to use L1,etc. and Stat - 1-Vars, to get the answers. I'm just...

1. Based on the following data, calculate the average return and the standard deviation of returns for Stock X. (From Chapter 10) YEAR Stock X Rate of Return 201a -5% 2016 15% 2010 20% 2010 30% 2...

No Excel plz 2. Based on the following data; calculate the expected return and the standard deviation of returns for stock A. (From Chapter 11) State of the Economy Probability Stock A Rate of Return...

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

PROBLEM 4: 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.25 10% 10% Normal Growth 0.40 5% 15% Boom...

Based on the following data; State of the Economy Probability Stock A Rate of Return Stock B Rate of Return Recession 0.2 4% -20% Normal Growth 0.65 20% Boom 0.15 16% 60% 8% (a) calculate the...

Each scenario in this question is independent. Please read them carefully and answer each part. (a) Big Green Limited is a producer of apples. It enters into a contract with Freight Limited, a...

Determine the magnitude and angle θ of F so that the particle is in equilibrium. Units Used: kN = 103 N Given: F1 = 4.5kN F2 = 7.5kN F3 = 2.25kN α = 60 deg φ = 30 deg 1 2

Prepaid Expenses are adjusted at the end of the accounting period in order to

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...