logo

Universal ROI Calculator


Philips A-19 LED against
60-Watt Incandescent
calculate payback with
costs & interest


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.

This was preloaded with the Philips A19 details and 10% Financial Interest.  Change any figures suitable for your application.
   See Philips Data Sheets
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 *
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.