Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Doing it in excel will do, i just need help figuring out how to do that. Expected return and standard deviation. Use the following information
Doing it in excel will do, i just need help figuring out how to do that.
Expected return and standard deviation. Use the following information to answer the questions: a. What is the expected return of each asset? b. What is the variance and the standard deviation of each asset? c. What is the expected return of a portfolio with 8% in asset J, 52% in asset K, and 40% in asset L? d. What is the portfolio's variance and standard deviation using the same asset weights from part (c)? Hint: Make sure to round all intermediate calculations to at least seven (7) decimal places. The input instructions, phrases in parenthesis after each apply for the answers you will type. a. What is the expected return of asset J? (Round to four Data Table (Click on the following icon in order to copy its contents into a spreadsheet.) State of Economy Boom Growth Stagnant Recession Probability of State 0.28 0.36 0.22 0.14 Return on Asset J in State 0.065 0.065 0.065 0.065 Return on Asset Kin State 0.230 0.130 0.050 -0.120 Return on Asset L in State 0.260 0.200 0.055 -0.210 Print Done Enter your answer in the answer box and then click Check Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started