## Universal ROI Calculator

An Estimating Tool to Compare Payback of LED Lighting

Please read: This program requires Javascript on your computer. This calculator gives payback time, the annual and life-time power, CO2 AND maintenance savings when you upgrade your lighting to LEDs.  Enter the wattage and life for both the old and new fixture and the billing rate per kilowatt-hour.  Be sure to include all costs, i.e. labor, parts, inventory, travel, fuel, equipment, etc.  Light levels are NOT calculated or suggested.

Start with the Tab key, fill in shaded cells and/or step forward with Tab; step backward with Shift Tab.

1. Compute kilowatts (kW) saved by upgrading to LED technology.
Original Fixture
Wattage + Ballast
LED
Wattage
Watts Saved
per Fixture
# of Fixtures
to Replace
Watts Saved
Watts -  Watts = 160 Watts × =
 8000 W 8  kW

2. Compute kilowatt hours (kWh) saved and tons of CO2 production saved annually.
Kilowatts
Saved
Hours of Use
per Day
Days of Use
per Week
Weeks of Use
per Year
Annual savings:
8 kW × × × = 29120.00 kWh
= 24.75 Tons
3. Compute power cost savings per year. of CO2 production *
kWh
Saved per Year
Cost Per kWh
(typically \$0.10)
Annual
Savings

29120.00 × \$ = \$2912.00

4. Compute power cost savings and saved CO2 production over life of the LEDs.
Replacement
LED Life (hours)
Hours per Year
Usage
LED Est. Life   Annual Power
Cost Savings
Cost Savings
Hr  ÷  3640.00 hr/yr  =  13.74 Years  ×  \$2912.00  =  \$40000.00
LED lifetime CO2 savings *   = 340.06 Tons
5. Compute payback from power cost savings.
 NOTE:  LED Cost is the amount used to calculate payback.  It may be the direct cost if retrofit, or may be the cost difference between the LED and the fixture it substitutes if a new installation.  This entry should include all installation costs.
(Enter LED Cost)
Payback From
Power Savings
= LED Cost, or Diff. between LED & Original = \$ × 50 Lights = 3.78 Years
Power Cost Savings per Year \$2912.00

6. Compute maintenance savings during life of the LEDs.   Include labor, equipment, fuel, parts, inventory, etc.
 LEDLife (hours) Original FixtureLife (hours) # ofFixtures Maint LaborOriginal Fixture Maint. PartsOriginal Fixture LifetimeSavings 50000 ÷ × 50 × ( \$ + \$  ) = \$26041.67
7. Compute the amortized changeout cost savings per year.
Savings per Year
\$26041.67 ÷ 13.74 Years  = \$1895.32

Simple Payback on
Power Consumption
And Maintenance Costs
=

\$ 220  × 50 =

2.29  Years

Power + Maintenance
Cost Savings
\$ 4807.32