You are trying to invest $100,000 in a portfolio of stocks and bonds. You want the highest return possible but have a number of criteria to ensure diversification and risk management. The funds available for investment and their information are provided below. "Tech Sector" Expected Investment Bond Rating Year to Maturity Return 4 GE Bond AMD Stock Moscow Bond Apple Stock Pape Stock Tesla Inc. Stock Junk Inc. Bond BBB -- AAA -- -- D 10 -- 3 No Yes No Yes No Yes No 4.25% 14% 2.3% 7% 8.1% 6% 17% Assume you want no more than 50% of total investments in stocks and no more than 15% invested in bonds with a rating below "BBB". Additionally, assume you want some liquidity such that no more than 70% of your investments can be in bonds with greater than 5-years until maturity. Further, you want at least 40% of your total investments in the Tech Sector (stocks or bonds). In Excel, create an LP that maximizes expected return subjects to the investment constraints listed above. Make sure to label you objective function, constraints, and decision/choice variables.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
You are trying to invest $100,000 in a portfolio of stocks and bonds. You want
the highest return possible but have a number of criteria to ensure diversification and risk
management. The funds available for investment and their information are provided below.
2)
Bond Rating| Year to
Maturity
Investment
"Tech Sector"
Expected
Return
GE Bond
BBB
4
No
4.25%
AMD Stock
Yes
14%
--
--
Moscow Bond
ΑΑA
10
No
2.3%
Apple Stock
Pape Stock
Yes
7%
No
8.1%
--
Tesla Inc. Stock
Yes
6%
--
Junk Inc. Bond
D
3
No
17%
Assume you want no more than 50% of total investments in stocks and no more than 15%
invested in bonds with a rating below “BBB". Additionally, assume you want some liquidity
such that no more than 70% of your investments can be in bonds with greater than 5-years until
maturity. Further, you want at least 40% of your total investments in the Tech Sector (stocks or
bonds).
In Excel, create an LP that maximizes expected return subjects to the investment constraints
listed above. Make sure to label you objective function, constraints, and decision/choice
variables.
Transcribed Image Text:You are trying to invest $100,000 in a portfolio of stocks and bonds. You want the highest return possible but have a number of criteria to ensure diversification and risk management. The funds available for investment and their information are provided below. 2) Bond Rating| Year to Maturity Investment "Tech Sector" Expected Return GE Bond BBB 4 No 4.25% AMD Stock Yes 14% -- -- Moscow Bond ΑΑA 10 No 2.3% Apple Stock Pape Stock Yes 7% No 8.1% -- Tesla Inc. Stock Yes 6% -- Junk Inc. Bond D 3 No 17% Assume you want no more than 50% of total investments in stocks and no more than 15% invested in bonds with a rating below “BBB". Additionally, assume you want some liquidity such that no more than 70% of your investments can be in bonds with greater than 5-years until maturity. Further, you want at least 40% of your total investments in the Tech Sector (stocks or bonds). In Excel, create an LP that maximizes expected return subjects to the investment constraints listed above. Make sure to label you objective function, constraints, and decision/choice variables.
Expert Solution
steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.