Lighting ROI Calculator — Excel
Estimate LED retrofit energy savings, project costs, payback periods, and 5- and 10-year financial returns with this downloadable Excel calculator.
Is that LED lighting upgrade actually going to save money, or just look good on paper?
The Current’s Lighting ROI Calculator helps electrical contractors, estimators, facility managers, and building owners evaluate the financial impact of lighting retrofits.
What’s included:
- Existing lighting calculations, including lamp wattage, ballast factor, and ballast wattage.
- Proposed LED lighting comparisons.
- Annual energy consumption and electricity cost savings.
- Installation costs, material costs, and available rebates.
- Simple payback and annual savings-to-investment ratio.
- Five-year and ten-year financial projections.
- Electricity rate escalation assumptions.
- Automatic break-even analysis.
- Printable project summary.
Download the Excel workbook, enter your project information, and see how the numbers stack up.
Disclaimer: This tool provides estimates based on user-entered assumptions. Actual performance and financial results may vary. Verify manufacturer specifications, utility rates, and project requirements before making investment decisions.