Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

LP Model - St. Louis Investment Company Case St. Louis Investment Company possesses a large amount of cash, say $1,000,000. There are five different investment

image text in transcribed

LP Model - St. Louis Investment Company Case St. Louis Investment Company possesses a large amount of cash, say $1,000,000. There are five different investment choices with different growth and income potentialities: common stocks, mutual funds, municipal bonds, savings certificates, and real estate investments. The current returns from the investment of each of these five choices are also different. The current returns on investment are known for each of the investment as follows: Common Stocks Mutual Funds Municipal Bonds Savings Certificates Real Estate Investment 10% per year 8% per year 6% per year 5% per year 9% per year Management believes the current yield will persist in the future and wishes to diversify the investment portfolio of the company to obtain the investment in common stocks to not more than the combined total investment in municipal bonds, savings certificates, and real estate investment. Total investment in mutual funds and real estate combined must be at least as large as that in municipal bonds. Also, management wishes to restrict its investment in mutual funds to a level not exceeding to that in savings certificates. Determine the optimum allocation of investment funds among these five choices and the actual amount of returns form investment under the above conditions. Define the decision variables: X1 = X3 = X4= X5 = Formulate the objective function: Formulate the constraints: | Develop a spreadsheet application using MS-Excel Solver Add-in

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_2

Step: 3

blur-text-image_3

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 And Reporting

Authors: Barry Elliott, Jamie Elliott

11th Edition

0273708708, 9780273708704

More Books

Students also viewed these Accounting questions

Question

Am I trying to change or control others?

Answered: 1 week ago