# Downloads for Professionals and Students

Here are selected **business case spreadsheets** from the book:

### Chapter 2: Key Financial Concepts

- Figure 2.2 Present value of $1
- Figure 2.6 Calculation of net present value (NPV) in Excel
- Figure 2.7 Payback method: Three projects
- Figure 2.8 Return on investment (ROI) calculation
- Figures 2.9, 2.10, 2.11, 2.12 Internal rate of return (IRR)

### Chapter 3: Fundamentals I: Costs

### Chapter 4: Fundamentals II: Benefits

### Chapter 5: Making Investment Decisions with NPV

- Figure 5.1 Case: NPV with TV and perpetuity method & Figure 5.2 Case: Cumulative PF calculation for the annuity method
- Figure 5.3 Example: Upgrading from client-server to cloud application
- Figure 5.4 Table for the binomial coefficient
- Figure 5.5 NPV business case for highway safety alternatives

### Chapter 6: Factoring Risk and Uncertainty

- Figure 6.7 Standard deviation measure of dispersion
- Figure 6.9 Sensitivity analysis on the discount rate
- Figure 6.10 Duration as a sensitivity measure
- Figure 6.15 Deterministic NPV
- Figures 6.16, 6.17, 6.18 Monte Carlo NPV Simulation