Purchase Solution

Capital budgeting :Excel solver

Not what you're looking for?

Ask Custom Question

Someone has determined that the firm's capital investment budget will be $5,000,0000 for the upcoming year. Unfortunately, this amount is not sufficient to cover all the positive NPV projects that are available to the firm.

You have been asked to choose which investments, of those listed in the table should be made. (Table attached)

a. Using the Solver, determine which of the above projects should be included in the budget in the firm's goal is to maximize shareholder wealth. (Make sure to set the Solver options to Assume Linear Model)

b. Now assume that the CFO has informed you that project A and B are mutually exclusive, but one of them must be selected. Change your Solver constraints to account for this new information and find the new solution.

c. Ignore the constraints from part B. The CFO has now informed you that Project 1 is of great strategic importance to the survival of the firm. For this reason it must be accepted. Change your Solver constraints to account for this new information and find the new solution.

Purchase this Solution

Solution Summary

Excel file contains an answer of a capital budgeting problem using excel solver.

Solution Preview

Please refer attachment for full details regarding help on your ...

Purchase this Solution


Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Motivation

This tests some key elements of major motivation theories.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.