• Preview of Energy Project Payback and NPV CalculatorExcel workbook preview

Energy Management (ISO 50001, DOE 50001 Ready)

Energy Project Payback and NPV Calculator

$17.99 Free XLSX
Excel workbook · 15 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 energy manager asked by finance to rank energy projects for next year's capital budget on NPV, not payback alone.

What is inside

  • 10 sample projects from LED to solar PV with capital cost, kWh saved and life
  • Live year-1 savings, simple payback and NPV with energy price escalation
  • Lifetime tCO2e and cost per tCO2e abated (negative means it saves money)
  • Rank by NPV and red or green NPV colouring
  • Cash Flow sheet: pick a project to see 25 years of cash flows, NPV, IRR and discounted payback
  • 24 blank rows for your own projects

How to use it: Agree the discount rate and price escalation with finance, enter one project per row, then pick a project on the Cash Flow sheet for the detail.

Files & formats
  • XLSXenergy-project-payback-npv-calculator.xlsx15 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.