linear programming using Excel solver Reliable Investment
Not what you're looking for?
(See attached file for full problem description)
---
Reliable Investment Corporation is in the process of determining its investment strategy for the next three years. Currently (time t = 0), $100,000,000 is available for investment. The cash flow associated with investing $1 in each of the available investment alternatives (A - E) is given in the table below:
Cash Flow ($) At Beginning Of Year (t)
Alternative 0 1 2 3
A -1 0.50 1 0
B 0 -1 0.5 1
C -1 1.2 0 0
D -1 0 0 1.9
E 0 0 -1 1.5
For example, $1 invested in investment B requires a $1 cash outflow at the beginning of time period 1. This investment returns $0.50 at the beginning of time period 2 and $1 at the beginning of time period 3. In addition, investments can be made in alternative E only at the beginning of time period 2, etc.
To ensure that the company's portfolio is diversified, Reliable requires that no more than $75,000,000 can initially be placed in any single investment alternative. In addition to these investments, Reliable can earn interest at 8% per year by keeping un-invested cash in a money market fund.
Once received, cash flows from the investments and the money market fund are immediately available for reinvestment. For example, the positive cash flow received from alternative C at the beginning of time period 1 can be invested in any allowable investments, e.g. alternative B. Since Reliable cannot borrow funds, the cash available for investment at any time is limited to cash on hand.
Formulate and solve a linear program that will maximize the cash on hand at the beginning of time period 3. To accomplish this, what investments should be made and when?
---
Purchase this Solution
Solution Summary
Shows how to structure and solve a linear programming problem using Excel solver add-in.
Solution Preview
See the attached file for complete solution. The text here may not be copied exactly as some of the symbols / tables may not print. Thanks
Reliable Investment Corporation is in the process of determining its investment strategy for the next three years. Currently (time t = 0), $100,000,000 is available for investment. The cash flow associated with investing $1 in each of the available investment alternatives (A - E) is given in the table below:
Cash Flow ($) At Beginning Of Year (t)
Alternative 0 1 2 3
A -1 0.5 1 0
B 0 -1 0.5 1
C -1 1.2 0 0
D -1 0 0 1.9
E 0 0 -1 1.5
For example, $1 invested in investment B requires a $1 cash outflow at the beginning of time period 1. This ...
Purchase this Solution
Free BrainMass Quizzes
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Probability Quiz
Some questions on probability