The U.S. Department of Energy (DOE) sponsored Municipal Solid-State Lighting Consortium (MSSLC) released an economic planning tool for cities considering or planning the installation of LED streetlights. The Excel-based analysis tool was developed by the MSSLC in collaboration with the Clinton Climate Initiative. Municipal users can estimate the cost of purchase and installation as well as calculate the economic impact of switching existing roadway lighting to LED fixtures.
“The Retrofit Financial Analysis Tool will make it easier for cities, utilities, and others to analyze the costs and benefits of LED streetlighting conversion projects by providing specific key information on costs and return on investment,” said Edward Smalley, director MSSLC. According to the DOE, users who enter data on the relevant variables for their particular application – such as the incumbent technology, quantities, phase-in period, prevailing electricity and labor rates, sales tax, installation cost, loan interest rate, and rebates – will receive a detailed analysis that includes annualized energy-cost savings, maintenance savings, greenhouse gas reductions, and simple payback.
Included with the planning tool is a “how to” instructional video as well as a sample data spreadsheet. Users can input all assumptions for an overall project which will generate a calculation worksheet and output worksheet. Results for project cost analysis, project environmental impact analysis, and project finance analysis are also included.