Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone look over this for me. Suppose an investor is mnsidering three stocks in which to invest. The expected return for stock 1 is

image text in transcribedimage text in transcribedimage text in transcribed

Can someone look over this for me.

image text in transcribedimage text in transcribedimage text in transcribed
Suppose an investor is mnsidering three stocks in which to invest. The expected return for stock 1 is 10%, for stock 2. 12%. and for stock. 3, ?%, and she would like an expected return of at least 10%. The Maritmvitz portfolio model to minimize the variance and the Solver Sensitivity Report for the model are available below. Complete parts a through c. Click here to view the Markowitz Model in Excel. Click here to view the initial sensitivity report a. Explain how to interpret the Lagrange multiplier value for the target portfolio return. The Lagrange multiplier for the target portfolio retum, 0.6321, is an approximam indicator of the shadow price. b. Suppose the target return is increased from 10% to 11%. How much is the minimum portfolio variance predicted to increase using the Lagrange Multiplier value? The Lagrange multiplier predicts that the minimum variance will increase by 0.000321 . (Type an integer or a decimal rounded to six decimal places.) c. Re-solve the model with the target retum of 11%. How much does the minimum variance actually change? The minimum variance increases by 0.006321 . (Round to six decimal places as needed.) Markowitz Portfolio Model Data Expected Variance-Covariance Matrix Return Stock 1 Stock 2 Stock 3 Stock 1 10% Stock 1 0.025 0.015 0.002 Stock 2 12% Stock 2 0.03 0.005 Stock 3 7% Stock 3 0.004 Target Return 10% Model Variance Calculations Allocation Squared Terms Cross-Products Stock 1 0.2513 =814^2*EG =F6 *814*815*2 Stock 2 0.4492 =815^2 *F7 =G6 *814*816*2 Stock 3 0.2995 =81642*GB -G7*815*816*2 Total =SUM(814:816) Return Variance Portfolio SUMPRODUCT(814:816,86:88) =SUM(E14:E16)+SUM(F14:F16)i Sensitivity Report A B C D E 1 Objective Cell (Min) 2 Cell Name Final Value 3 $C$21 Portfolio Variance 0.012422 4 5 Decision Variable Cells 6 Cell Name Final Value Reduced Gradient 7 $B$14 Stock 1 Allocation 0.2513 0.00 $B$15 Stock 2 Allocation 0.4492 0.00 9 $B$16 Stock 3 Allocation 0.2995 0.00 10 11 Constraints 12 Cell Name Final Value Lagrange Multiplier 13 $B$17 Total Allocation 1 - 0.03836359 14 $B$21 Portfolio Return 10% 0.6321 15 16

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_2

Step: 3

blur-text-image_3

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

Fundamentals of Financial Management

Authors: Eugene F. Brigham, ‎ Joel F. Houston

11th edition

324422870, 324422873, 978-0324302691

More Books

Students also viewed these Finance questions

Question

=+3 Calculate the budgeted unit cost of a blue rug for the year.

Answered: 1 week ago

Question

JavaScript is executed on the browser. True or false?

Answered: 1 week ago