Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An investor wants to create a portfolio between 3 different types of stocks that will balance the expected return of the investment with its risk

An investor wants to create a portfolio between 3 different types of stocks that will balance the expected return of the investment with its risk (measured by the variance of the portfolio). Historical returns (as % of the investment) for the last 4 years for each of the three stocks are shown in the following table:

Year 1 Year 2 Year 3 Year 4
Stock A 15.3 12.4 11.8 13.6
Stock B 8.4 8.2 9.3 10.1
Stock C 10.3 8.4 11.7 12.1

  1. Using Markowitz's mean-variance model, write out the non-linear programming model that would minimize the total risk (variance) while achieving a minimum return of 11%.
  2. Using Excel's Solver (with the GRG non-linear solution algorithm), what is the optimal solution (i.e., what percentage of the investment should be put into each of the three stocks)?

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

Financial Accounting Tools For Business Decision Making

Authors: Paul D. Kimmel,  Jerry J. Weygandt,  Jill E. Mitchell

10th Edition

1119791081, 978-1119791089

More Books

Students also viewed these Accounting questions

Question

Why was the phi phenomenon so important to Wertheimer?

Answered: 1 week ago

Question

convert pair of complex numbers to polar form b=3+j2 c=3-j2

Answered: 1 week ago