# Capital Budgeting Solved Problems

For analyses with very many projects, this level of detail may be sufficient.The approach will also work with more complicated projects created with the add-in.The model for the example is shown below with the optimum solution.

Tags: Antigone Essay TopicsEntry Level It Resume Cover LetterReference Thesis PaperFive Different Types Of EssaysWhat Does A Research Paper NeedWriting Creative Non-Fiction

For the example, Proj 8 has a greater IRR than proj 6, but a lower NPW.

Integer programming allows a variety of logical constraints to be imposed upon the solution.

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.

Each project has a button on the worksheet and is shown below.

The solution selects projects 2, 4, 6 and 9 with a total NPW of 3701.

Rather the data can be entered directly by the user in the cells provided.

Aspects of the analysis that depend on the MARR or the IRR are not created for this option.

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.

## Comments Capital Budgeting Solved Problems

• ###### Net Present Value as a Capital Budgeting Method

Capital budgeting analysis is more effective and informative when using the decision method of net present value NPV in budgeting.…

• ###### 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 and The Investment Decision.pdf

Solve problems relating to the purchase versus the leasing of fixed assets. vestment decision making, or capital budgeting, differs from day-to-day decision.…

• ###### 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.…

• ###### 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.…

• ###### Internal Rate of Return-IRR Definition, Formula & Example

IRR is one of the most popular capital budgeting technique. But the problem is, we cannot isolate the variable r =internal rate of return on.…

• ###### 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.…