Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3.5-6. Maureen Laird is the chief nancial ofcer for the Alva Electric Co., a major public utility in the midwest. The company has scheduled the
3.5-6. Maureen Laird is the chief nancial ofcer for the Alva Electric Co., a major public utility in the midwest. The company has scheduled the construction of new hydroelectric plants 5, 10, and 20 years from now to meet the needs of the growing population in the region served by the company. To cover at least the construc- tion costs, Maureen needs to invest some of the company's money now to meet these future cash-ow needs. Maureen may purchase only three kinds of nancial assets, each of which costs $1 million per unit. Fractional units may be purchased. The assets produce income 5, 10, and 20 years from now, and that income is needed to cover at least minimum cash-ow requirements in those years. (Any excess income above the minimum requirement for each time period will be used to increase dividend payments to shareholders rather than saving it to help meet the minimum cash-ow require- ment in the next time period.) The following table shows both the amount of income generated by each unit of each asset and the minimum amount of income needed for each of the future time periods when a new hydroelectric plant will be constructed. Income per Unit of Asset Minimum Cash Year Asset 1 Asset 2 Asset 3 Flow Required 5 $2 million $1 million $0.5 million $400 million 10 $0.5 million $0.5 million $1 million $100 million 20 0 $1.5 million $2 million $300 million Maureen wishes to determine the mix of investments in these as- sets that will cover the cash-ow requirements while minimizing the total amount invested. (a) Formulate a linear programming model for this problem. (b) Display the model on a spreadsheet. (c) Use the spreadsheet to check the possibility of purchasing 100 units of Asset 1, 100 units of Asset 2, and 200 units of Asset 3. How much cash flow would this mix of investments generate 5, 10, and 20 years from now? What would be the total amount invested? (d) Take a few minutes to use a trial-and-error approach with the spreadsheet to develop your best guess for the optimal solu- tion. What is the total amount invested for your solution
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started