-
Excel workbook preview
Energy Management (ISO 50001, DOE 50001 Ready)
Energy Project Payback and NPV Calculator
3 downloads per free account, no card needed.
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.



