Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Required Provide LP Model(Including Definition of variables ) Optimal solution , Optimal objectives , optimal value, and screenshots of MATLAB code and outputs 9 Winstonco

image text in transcribed

image text in transcribed

Required

Provide LP Model(Including Definition of variables ) Optimal solution , Optimal objectives , optimal value, and screenshots of MATLAB code and outputs

9 Winstonco is considering investing in three projects. If we fully invest in a project, the realized cash flows in millions of dollars) will be as shown in Table 44. For example, project I requires cash outflow of $3 million today TABLE 43 Card Saks Fifth Avenue Bloomingdale's Macys Balance (5) 20,000 50,000 40,000 Monthly Rate (%) .5 1.5 TABLE 44 Cash Flow Project 2 -2 -.5 Time (Years) 0 .5 1 1.5 2 2.5 3 Project 1 -3 -1 +1.8 1.4 1.8 1.8 5.5 1.5 Project 3 -2 -2 -1.8 1 1 1 6 1.5 1.5 .2 -1 and returns $5.5 million 3 years from now. Today we have $2 million in cash. At each time point (0.5, 1, 1.5, 2, and 2.5 years from today) we may, if desired, borrow up to $2 million at 3.5% (per 6 months) interest. Leftover cash earns 3% (per 6 months) interest. For example, if after borrowing and investing at time we have $1 million we would receive $30,000 in interest at time.5 years. Winstonco's goal is to maximize cash on hand after it accounts for time 3 cash flows. What investment and borrowing strategy should be used? Remember that we may invest in a fraction of a project. For example, if we invest in 5 of project 3, then we have cash outflows of -$1 million at time 0 and .5. 9 Winstonco is considering investing in three projects. If we fully invest in a project, the realized cash flows in millions of dollars) will be as shown in Table 44. For example, project I requires cash outflow of $3 million today TABLE 43 Card Saks Fifth Avenue Bloomingdale's Macys Balance (5) 20,000 50,000 40,000 Monthly Rate (%) .5 1.5 TABLE 44 Cash Flow Project 2 -2 -.5 Time (Years) 0 .5 1 1.5 2 2.5 3 Project 1 -3 -1 +1.8 1.4 1.8 1.8 5.5 1.5 Project 3 -2 -2 -1.8 1 1 1 6 1.5 1.5 .2 -1 and returns $5.5 million 3 years from now. Today we have $2 million in cash. At each time point (0.5, 1, 1.5, 2, and 2.5 years from today) we may, if desired, borrow up to $2 million at 3.5% (per 6 months) interest. Leftover cash earns 3% (per 6 months) interest. For example, if after borrowing and investing at time we have $1 million we would receive $30,000 in interest at time.5 years. Winstonco's goal is to maximize cash on hand after it accounts for time 3 cash flows. What investment and borrowing strategy should be used? Remember that we may invest in a fraction of a project. For example, if we invest in 5 of project 3, then we have cash outflows of -$1 million at time 0 and .5

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

Step: 3

blur-text-image

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

Effective Auditing The Simple Systems Series Book 5

Authors: Jennie Clark CQP

1st Edition

B09YHJR18Y, 979-8802614082

More Books

Students also viewed these Accounting questions