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

• Figure 3.8 NPV of buying vs. leasing & Figure 3.9 Flexibility option in leasing

Chapter 4: Fundamentals II: Benefits

• Figure 4.8 Cohort-based CV calculation

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