Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An investor wishes to invest $10,000 for the coming year and anticipates that the market will be in one of four different states at the

An investor wishes to invest $10,000 for the coming year and anticipates that the market will be in one of four different states at the end of the year. These states affect her investments in each of three possible stocks and a bond as shown in the following table. Unfortunately, she is uncertain about which market state will occur. Because she is risk-averse, the investor would like to invest in a manner so that the return in the worst-case, no matter what market state occurs, is as good as possible. The following table provides the current price of each possible instrument as well as projected year- end prices of each instrument under each of the 4 possible states.

Possible Market States

Price

State 1

State 2

State 3

State 4

Stock A

$4.94

$4.58

$3.95

$5.67

$5.39

Stock B

$5.88

$5.24

$7.28

$4.82

$6.22

Stock C

$6.48

$8.27

$5.65

$7.66

$5.78

Bond D

$2.68

$2.11

$2.53

$2.80

$2.09

These data are in the file MarketStates. Formulate her investment problem as a linear program and solve it using Excel Solver. How much should she invest in each security? Note: It is possible to purchase fractional shares.

Step by Step Solution

3.48 Rating (151 Votes )

There are 3 Steps involved in it

Step: 1

I Formulation as linear program is following i ... 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

Managerial Decision Modeling With Spreadsheets

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

3rd Edition

136115837, 978-0136115830

More Books

Students also viewed these Finance questions