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
Lifetime Power 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
Return on Investment (ROI) from power savings
100% is based on full repayment in first year
=
100
=
100
=
26.46 %
Simple Payback
3.78
6. Compute maintenance savings during life of the LEDs. Include labor, equipment, fuel, parts, inventory, etc.
LED Life (hours)
Original Fixture Life (hours)
# of Fixtures
Maint Labor Original Fixture
Maint. Parts Original Fixture
Lifetime Savings
50000
÷
×
50
×
( $
+
$ )
=
$26041.67
7. Compute the amortized changeout cost savings per year.
Total Lifetime Replacement Cost Savings
Lifetime of Replacement Fixture
Total Amortized Savings per Year
$26041.67
÷
13.74 Years
=
$1895.32
Simple Payback on Power Consumption And Maintenance Costs
