Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Meaningful Money Handbook

Authors: Pete Matthew

1st Edition

0857196510, 978-0857196514

More Books

Students also viewed these Finance questions

Question

Describe how to train managers to coach employees. page 404

Answered: 1 week ago

Question

Discuss the steps in the development planning process. page 381

Answered: 1 week ago