This calculator will determine the annual energy cost savings and life-time energy cost savings when you upgrade bulbs to a newer LED type bulb. You can also calculate the savings in the reduction in bulb changes due to the longer bulb life. also the Return on Investment (ROI) of the LED Lamp.
You can use this sheet for each bulb type upgraded. It requires the Wattage and bulb Life for both the old and new bulb and the local cost per kilowatt-hour.
Additionally the cost to change a single light bulb and the cost of the initial install of the LED light bulb. You may want to include all of the costs of changing bulbs such as labor, inventory, warehousing and purchasing/accounting.
You Can Download this Calculator with Excel Format as Follow: