Purchase Solution

Projected Cash Flows Linear Programming Model

Not what you're looking for?

Ask Custom Question

7) The Fairwinds Development Corporation is considering taking part in one or more of three different development projects -- A, B, and C -- that are about to be launched. Each project requires a significant investment over the next few years and then would be sold upon completion. The projected cash flows (in millions of dollars) associated with each project are shown in the table below:

Year Project A Project B Project C
1 -4 -8 -10
2 -6 -8 -7
3 -6 -4 -7
4 24 -4 -5
5 0 30 -3
6 0 0 44

Fairwinds has $10 million available now and expects to receive $6 million from other projects by the end of each year (1 through 6) that would be available for the ongoing investments the following year in projects A, B, and C. By acting now, the company may participate in each project either fully, fractionally (with other development partners), or not at all. If Fairwinds participates at less than 100 percent, then all the cash flows associated with that project are reduced proportionally. Company policy requires ending each year with a cash balance of at least $1 million.

a) Create an Excel worksheet that solves this problem with Solver.

Purchase this Solution
Solution Summary

The solution creates a projected cash flows linear programming model using Solver in Excel.

Solution provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Basics of corporate finance

These questions will test you on your knowledge of finance.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

View More Free Quizzes
Related BrainMass Solutions

  • Linear Programming - Fairwind corp

    The expert creates an Excel worksheet for linear programming for Fairwind Corporations.

  • decision variables, objective function, and all the constraints

    This posting clearly formulates a linear programming model by defining decision variables, objective function, and all the constraints.

  • Linear programming model for bicycle manufacturer

    The linear programming model for bicycle manufacturers are examined. The decision variables are written.

  • linear programming model problem

    a- Formulate a linear programming model for maximizing total profit contribution. Provide the formulation. b- ) Solve the linear program formulated in part (a) by using Excel. Include the computer output.

  • Disadvantages of a DCF Model

    543723 Disadvantages of a DCF Model Disadvantages of a DCF do not include: 1. Need realistic projected financial statements over at least one business cycle (7 to 10 years) or until cash flows are "normalized" 2.

  • A maximization Linear programming problem

    Formulate a linear programming model for this problem. B. Solve the model using the computer. Please see the attached file. This posting contains solution to following maximization Linear programming problem:

  • Stock valuation

    a) the corporate valuation model requires the assumption of a constant growth rate in all years. b) to implement the corporate valuation model, we discount projected free cash flows at the cost of equity capital.

  • Terminal value and discount back to the present

    After building an earnings model for Company X, you have projected free cash flow for each year through 2010 as follows: Year 2004 2005 2006 2007 2008 2009 2010 Free Cash Flow 110 120 150

  • Use of the Payback Period

    The author has shown that the payback period is used to summarize projected future cash flows by capturing tow factors of cash flows in the ratio (I) of intial outlay to the next period projected cash flow and the projected cash flow growth rate (g).

View More Related Solutions