logo

Universal ROI Calculator


A Tool to Calculate
Payback of LED Lighting
with costs & interest

Click for wide screen version

Please read:

ENSURE THAT REPLACEMENT HAS EQUIVALENT LIGHTING PERFORMANCE.
This calculator gives payback time, and both the annual and life-time cost & savings figures for energy, maintenance, and CO2 production.  It calculates Lighting Power Density from area of at least 50 square feet per fixture, and provides the maximum fixtures allowed from a target LPD. 
This calculator will not perform properly if removed from this site.  Updates and maintenance are performed on the web site.
Compare incandescent to A19 LEDs by:  LEDnovation or Philips or Toshiba
Label     Label
Simple ROI is calculated on product lifetime using energy and maintenance repayment, with the industry standard  [ (Payback Investment) ÷ Investment ×100 ] formula. 
Cost may be full direct if retrofit, or may be difference (Original - New) if complete new installation.   Interest is added to the Investment and original equipment costs for calculating payback and ROI.   Include ALL COSTs and verify calculations before implementing a solution.  Check with your electric utility provider for rate structures related to Lighting Power Density (LPD/UPD).   Site owner not responsible for errors, misapplications or oversights.
  Start with the Tab key, or select an entry with mouse.
Step forward with Tab; fill in shaded cells as required.
Step back with Shift Tab.

  Parameters for energy statistics:
  Label
 


Lighting Power Density Section
 
  Enter Power Consumption & No. of Fixtures  

 Label



 Label
LPD = Total Watts ÷ Total Square Feet  
Original Watts   LED  Watts Quantity   Sq-Ft per Fixture  =  Label Total 
Total Label kW Total Label kW   Enter Target LED LPD
Hour-Day-Week Notes:
• For Occ. sensors or dimming, use
   average hours
• For photocell use nighttime hours
• Use decimal weeks if holidays
   affect lighting (1 day = 0.14 wk)
 ×  Daily use  Hours This LPD combo allows Label LED fixtures. 
× Weekly use  Days Label
LPD Statistics      W/Ft 2 
Original LPD     Label 
  LED LPD     Label 
=  Saved     Label 
×  Yearly use   Weeks
×  Power Cost  $ / kWhr
 
  Annual Energy Cost: Original  $Label LED  $Label LPD Notes:
• Target LPD uses LED Watts and Quantity, and affects only the count below it.
• HID LPD = LED projection when = Watts.
Annual Savings  =   $Label
    LED Investment:      
  Full Cost for 1 Fixture Installed.  ( costs - discounts )  = $    
LED Maintenance Interval:  Years @ $  per Visit.  [ Lifetime ÷ Interval × Cost × Quan.= $Label ]
( $Label × Label ) + $Label = $Label  + FIXED JOB COSTS $    = $Label   Investment Label
Subtract a rebate from FIXED JOB COSTS, or, enter negative (-)JOB COSTS if rebate only.
    LED energy costs and reduced CO2 production during LED lifetime:  
    LED Life  Hours   ÷   Label  Hours/Year  = Label Years Lifetime 
CO2 reductions * calculator
Label Tons Less per year
Label Tons Less per lifetime
 
Years ×  $Label annual energy cost    =   $Label  
Years ×  $Label annual energy savings  =  $Label  (over original)
 $Label invest.  +  $Label energy  =  $Label  Project Cost
    Original fixture lifetime maintenance and energy costs:  
    Original fixture life  Hours   ÷  Label Hours/Year  = Label Years Lifetime  
Years ×  $Label annual energy cost   =   $Label Repair/Replacement Cost $ × Label = $Label
 $Label Fixtures & Maint. + $Label energy = $Label  Orig. Cost in LED Lifetime, replaced Label times.
    Payback time and ROI with Amortized Cost + Interest:  Label  
  % LabelLabel Label   Payback   
LED Investment ÷ Energy Savings  $Label ÷ $Label   =  LabelLabel Years on energy alone
Investment ÷ ( Energy + Maint. Savings ) $Label ÷ $Label   =  LabelLabel Years on energy & maint.
 Simple ROI:   (energy & maint. Payback Investment ) ÷ Investment    =  LabelLabel % ROI 
     
 RESTORE DEFAULT VALUES  
 *US national average CO2 emissions caused by various power generation capabilities, value provided by the US EPA. 
            Home             ©2011-2012 Patrick Mullins     Please Contact me with any comments regarding this calculator.