Summary
In this chapter, you learned about payback periods, which quantify the length of time required to break even on an investment. The concepts of future value, present value, and net present value set the stage for discounted payback periods, which can vary as the value of money changes over time. And you learned how to use a very powerful add-in, the Solver, to optimize a variety of input values in order to achieve an outcome that you specify.
Each of these concepts and tools plays a part in developing a business case that conforms to your decision criteria. This chapter also described how to save different combinations of input values in scenarios, so that you can revisit them and eventually select the best combination to achieve your ...
Get Business Analysis with Microsoft® Excel, Second Edition 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.
