Chapter 32. Using Solver for capital budgeting
Question answered in this chapter:
How can a company use Solver to determine which projects it should undertake?
Each year, a company such as Eli Lilly needs to determine which drugs to develop; a company such as Microsoft, which software programs to develop; a company such as Proctor & Gamble, which new consumer products to develop. Solver can help a company make these decisions.
Answer to this chapter’s question
This section provides the answer to the question that is listed at the beginning of the chapter.
How can a company use Solver to determine which projects it should undertake?
Most corporations want to undertake projects that contribute the greatest net present value (NPV), subject to limited resources ...
Get Microsoft Excel 2013: Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
