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 Markowitzs 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 Excels 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

Bond Markets Analysis And Strategies

Authors: Frank J. Fabozzi

4th Edition

0130402664, 9780130402660

More Books

Students also viewed these Finance questions

Question

What is the use of bootstrap program?

Answered: 1 week ago

Question

What is a process and process table?

Answered: 1 week ago

Question

What is Industrial Economics and Theory of Firm?

Answered: 1 week ago