Question: Please use Excel to show work 4. Based on the following data: ) calculate the expected return and the standard deviation of returns for each

Please use Excel to show work 4. Based on the following

Please use Excel to show work

4. Based on the following data: ) calculate the expected return and the standard deviation of returns for each stock. Stock B Rate of Return Sate of the Economy Probability Stock A Rate of Return Recession 0.2 4% 20% 0,65 Normal Growth 8% 20% 60% Boom 0.15 16% b) Calculate the expected return and the standard deviation on the portfolio, where the portfolio is formed by investing 50% of the funds in Stock A and the rest Stock B Stock B c) Calculate the expected return and the standard deviation on the portfolio, where the portfolio formed by investing 65% of the funds in Stock A and the rest

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!

******DO NOT USE EXCEL - Show Calculations and formulas.******* Based on the following information, calculate the expected return and standard deviation for the two stocks. Rate pf return if state...

2. Based on the following data; calculate the expected return and the standard deviation of returns for each stock State of the Economy Probability Stock A Rate of Return Stock B Rate of Return...

PLEASE SHOW ALL WORK!! Problem 2 Based.on the following data; calculate the expected return and the standard deviation of returns for each stock. (From Chapter 11)

6. [3] Over a 40-year period, an asset had an arithmetic return of 12.8% and a geometric return of 9.7%. Using Blumes formula, what is your best estimate of the future annual returns over 5 years? 10...

2. Based on the following data; calculate the expected return and the standard deviation of returns for Stock A. State of the Economy Probability Stock A Rate of Return Recession 0.2 -20% Normal...

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

Please show work* 3. Based on the following data: (a) calculate the expected return and the standard deviation of returns for each stock. 4% State of the Economy Probability Stock A Rate of Return...

how to do 3 6 7 8 Based on the following data; calculate the average return and the standard deviation of returns for Stock A Use the following data: Calculate the expected returns and standard...

4 Na US Lonelem Corpo US Foreign marging Real bed Mors Market Mate 44 ON 41 AM 14 TIN NICO 10 - wt WO ON The late to the left side of the return for free to the present 17 Calculate the return and...

Question 4 (26 Marks) A pension fund manager is considering three mutual funds. Precisely, a Stock fund (S), a long-term government and corporate Bond fund (B), and a treasury bill (T-bill) money...

A company buys a large truck for $176,000 that should last for eight years. After five years, the companyspends another $27,000 on this truck for the sole purpose of extending its life by three...

Find all values a = a where the function is discontinuous. For each point of discontinuity, give (a) f(a) if it exists, (b) lim, a f(x). (c) lim, a f(x), (d) lima f(x), and (e) identify which...

Fall & Winter Inc. financial statements are presented in the table below. Based on the information in the table, and using a 365-day year, calculate the average collection period (also called Days of...

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