Start with the Tab key, fill in shaded cells and/or step forward withTab; 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 W8 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 costdifference 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
Total Lifetime Replacement Cost Savings
Lifetime of Replacement Fixture
Total Amortized
Maintenance Savings per Year
$26041.67
÷
13.74 Years
=
$1895.32
Simple Payback on
Power Consumption And Maintenance Costs
