# Capital Budgeting Solved Problems

The capital budgeting or capital rationing problem is to select from a set of alternative projects a portfolio of projects that provides the greatest economic return while not exceeding a budget on the amount of the total initial capital investment.To setup and solve such a problem select is used, that add-in must be installed.The initial solution has no projects selected, so the cell evaluates to zero. Its green color indicates that the program will fill this cell with the results of an algorithm.

When this button is not selected the upper bounds on the variables are set to larger values allowing multiple copies of an item to be selected.

The project below was created to replace to replace Proj. The Project Definition may be arbitrarily complex with several investments and a variety of cash flows.

Such a project must be linked to the capital budgeting region of the worksheet.

For example we might require projects 5 and 6 to be mutually exclusive, that is, only one may be chosen. Of course the NPW and IRR of the portfolio are reduced.

Also we might require that if project 9 is selected, project 10 must also be selected. Even though it has a large IRR, project 9 is not advisable when it is necessary to pair it with project 10. This will always be the case for the NPW with added constraints.

## Comments Capital Budgeting Solved Problems

• ###### Capital Budgeting - HFTP

Capital Budgeting. 1. Vol. 2, Chapter 4 – Capital Budgeting. Problem 1 Solution. Answers found using Excel formulas 1. Amount invested = \$10,000.…

• ###### Capital Budgeting 2 solver

Problem. In this model we extend the problem we solved in Budget1. Once again, a company needs to make a decision. how to invest in 6 different opportunities.…

• ###### Solving Capital Budgeting Problems by - jstor

SOLVING CAPITAL BUDGETING PROBLEMS BY. "RULES OF THUMB"?A COMMENT. An examination of capital budgeting techniques shows that for many y.…

• ###### Capital Budgeting Examples with Solution - Course Hero

View Test Prep - Capital Budgeting Examples with Solution from FIN 3403 at. 400 CFj = \$ 400 I/YR = 15 Solve for NPV = \$98.51 Solve for IRR = 19.68% Solve.…

• ###### A process for assessing Excel skills using a capital budgeting.

Excel skills separate from understanding new concepts or problem-solving skills. problem solving ability related to capital budgeting and promotes consistent.…

• ###### Tutorial 8 - Capital Budgeting I - FNCE10002 - Unimelb.

Fnce10002 principles of finance semester 2018 fnce10002 principles of finance semester 2018 capital budgeting tutorial questions for week this tutorial is.…