Question
no excel work. please provide formula.
You have done your research for the following investments and your friend has provided their expectations for the markets for
e. Calculate the risk for stock B. (2 marks) f. Calculate the risk for the TSX. (2 marks) g. Calculate the covariance and cor
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution (eiff Risk of stockB & TS X state of ew Probility BOM TSX:1:2 3) . -9 Boom Normal Recession 30 • 40 1B 10 -10 2x3Solutions (9) calculation covariane and co-relah blw stack A and stock B calh of expecteel Rehron of stock . 3x30% to o4 x 16

Add a comment
Know the answer?
Add Answer to:
no excel work. please provide formula. You have done your research for the following investments and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • no excel work, show formula please You have done your research for the following investments and...

    no excel work, show formula please You have done your research for the following investments and your friend has provided their expectations for the markets for next year. Probability of State of State of Stock Stock Economy Economy A B TSX Boom .30 30% -9% 18% Normal .40 16% 12% 10% Recession .30 -10% 20% -10% Remember to show all of your work * h. Calculate the covariance and correlation of the returns for stock A and the TSX. (2...

  • You have done your research for the following investments and your friend has provided their expectations...

    You have done your research for the following investments and your friend has provided their expectations for the markets for next year. Probability of State of State of Stock Stock Economy Economy A B TSX Boom .30 30% -9% 18% Normal .40 16% 12% 10% Recession .30 -10% 20% -10% * Remember to show all of your work * a. Calculate the expected return for stock A. (2 marks) b. Calculate the expected return for stock B. (2 marks) C....

  • e. Calculate the risk for stock B. (2 marks) f. Calculate the risk for the TSX....

    e. Calculate the risk for stock B. (2 marks) f. Calculate the risk for the TSX. (2 marks) g. Calculate the covariance and correlation of the returns for stock A and stock B. (2 marks) h. Calculate the covariance and correlation of the returns for stock A and the TSX. (2 marks) e. Calculate the risk for stock B. (2 marks) f. Calculate the risk for the TSX. (2 marks) g. Calculate the covariance and correlation of the returns for...

  • You have done your research for the following investments and your friend has provided their expectations...

    You have done your research for the following investments and your friend has provided their expectations for the markets for next year. Probability of State of State of Stock Stock Economy Economy А B TSX Boom .30 30% -9% 18% Normal .40 16% 12% 10% Recession .30 -10% 20% -10% * Remember to show all of your work * o. You have $10,000 to invest and would like to create a portfolio that has an expected return of 15 percent....

  • the following investments you and your friend has provided their expectations for the markets for next...

    the following investments you and your friend has provided their expectations for the markets for next year. State of Economy Probability of State of Economy Stock A Stock B TSX Boom .30 30% -9% 18% Normal .40 16% 12% 10% Recession .30 -10% 20% -10%               Remember to show all of your work - make clear and understandable and CORRECT Calculate the expected return for stock A. Calculate the expected return for stock B.    Calculate the expected return for...

  • State of Economy Probability of State of Economy Stock A Stock B TSX Boom .30 30%...

    State of Economy Probability of State of Economy Stock A Stock B TSX Boom .30 30% -9% 18% Normal .40 16% 12% 10% Recession .30 -10% 20% -10% Calculate the covariance and correlation of the returns for stock B and the TSX. Calculate the beta of Stock A. Calculate the beta of stock B. Calculate the beta for the TSX. Using an excel spreadsheet and the calculations you have done above, prepare a spreadsheet that provides the expected returns and...

  • State of Economy Probability of State of Economy Stock A Stock B TSX Boom .30 30%...

    State of Economy Probability of State of Economy Stock A Stock B TSX Boom .30 30% -9% 18% Normal .40 16% 12% 10% Recession .30 -10% 20% -10% Calculate the risk for stock B. Calculate the risk for the TSX. Calculate the covariance and correlation of the returns for stock A and stock B. Calculate the covariance and correlation of the returns for stock A and the TSX.

  • Home Work #3 Question 1 Classify the following events as mostly systematic or mostly un-systematic. Is...

    Home Work #3 Question 1 Classify the following events as mostly systematic or mostly un-systematic. Is the distinction clear in every case? a. Short term interest rates decrease expectantly. b. The interest rate a company pays on its short term debt borrowing is increased by the bank. c. Oil prices expectantly decline. d. An oil tanker runs aground creating a large oil spill. e. A major manufacturing company loses a multimillion dollar product liability suit. f. The Supreme Court of...

  • Please show work that is not on excel please. Thank you. CHAPTER 11 Risk and Retur...

    Please show work that is not on excel please. Thank you. CHAPTER 11 Risk and Retur 6. Calculating Expecte bleulating Expected Return. Based on the following information, calculate the expected return. State of Economy Probability of State of Economy Rate of Return If State Occurs Recession Normal Boom .15 .60 .25 -.09 .11 .30 Calculating Returns and

  • NEED EXCEL SOLUTION PLEASE: (EXCEL FORMULA) Suppose we have the following returns for the market and...

    NEED EXCEL SOLUTION PLEASE: (EXCEL FORMULA) Suppose we have the following returns for the market and a stock: Year Market return Stock return 1 18% 7% 2 27% 25% 3 5% 21% 4 13% 4% 5 -17% -16% 6 6% 19% 7 -21% -38% 8 34% 29% 9 19% 15% 10 11% 16% What is the covariance and correlation of the returns between this stock and the market? Covariance: Use Covar Function Correlation: Use Correl Function Beta: Use Slope Function...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT