-
Excel workbook preview
Project Initiation and Business Case
Cost-Benefit Analysis Calculator (NPV, payback, ROI)
3 downloads per free account, no card needed.
Who this is for
The sponsor asked whether the project pays back and the finance director wants an NPV before the business case goes in.
What is inside
- 10 sample cost and benefit lines across years 0 to 5 plus 16 blank lines
- Totals by year with SUMIF so lines can be added in any order
- NPV with Excel NPV() on years 1 to 5 plus the year 0 flow, at a discount rate you enter
- Payback period in years, interpolated within the year, and a not-within-5-years message
- ROI and benefit-cost ratio on discounted figures, NPV turns red when below zero
- Chart of the cumulative net cash flow on the Summary sheet
How to use it: Enter your discount rate on the Cost-Benefit Analysis sheet, replace the sample lines with your costs and benefits by year, and read NPV, payback and ROI on the Summary sheet.
Files & formats
- XLSXcost-benefit-analysis-calculator.xlsx13 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.



