• Preview of Cost-Benefit Analysis Calculator (NPV, payback, ROI)Excel workbook preview

Project Initiation and Business Case

Cost-Benefit Analysis Calculator (NPV, payback, ROI)

$17.99 Free XLSX
Excel workbook · 13 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

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.