Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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.

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.

Foundations of Business - Standalone book (MindTap Course List)
Foundations of Business - Standalone book (MindTap Course List)
4th Edition
ISBN:9781285193946
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Chapter15: Using Management And Accounting Information
Section: Chapter Questions
Problem 5DQ
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Foundations of Business - Standalone book (MindTa…
Foundations of Business - Standalone book (MindTa…
Marketing
ISBN:
9781285193946
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
Foundations of Business (MindTap Course List)
Foundations of Business (MindTap Course List)
Marketing
ISBN:
9781337386920
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS