Equipment Life Extension Solutions Value Calculator
Payback Analysis
To save space, the menu below is compressed into 7 steps. To display the items within a step, click on the   symbol the left of each menu item. Doing so expands the menu and displays all the user entered choices within each step.

Overview of How Calculator Works


Step 1:

Need Help with Step 1?
Expand/Collapse Item Select Solution
Select the life extension solution from the list below. If the solution you are considering is not found in this list, you will need to provide the mean-time-between-failure (MTBF) and the mean-time-to-repair (MTTR) data for the existing equipment that you are planning on upgrading. The goal here is to determine the cost of doing nothing by determining the likelihood of a failure multiplied by your labor and downtime rates.

Enter name of other solution5:
Enter MTBF of existing equipment
Years
Enter MTTR of existing equipment
Hours

Step 2:

Need Help with Step 2?
Expand/Collapse Item Downtime Cost
If you installed the solution listed in Step 1 above and it prevented an outage within its area of control, what would that save in terms of downtime? This downtime should be divided into two categories:
  • Lost Revenue
  • Remediation costs
    Note that some of these costs may be based on the duration of the outage, while other costs are incurred on a per occurance basis. Once you have identified these costs, place them in the appropriate field below.
    (downtime in dollars per hour; e.g. lost revnue from continuous process)
    (additional costs of each event, clean-up, restoration, liabilities, legal costs, environmental penalties, lost revenue from batch process where batch must be discarded)
    (estimated additional costs associated with worker injury due to equipment catastrophic failure.)
       
    hours (if you experienced an outage, enter the actual downtime)

    Step 3:

    Need Help with Step 3?
    Expand/Collapse Item Equipment Condition
    Equipment Age
    How old is the existing equipment?
    years

    Equipment Maintenance
    How would you describe the maintenance to date?

    Environment
    How would you describe the environment around the electrical equipment?
    (Clean and dry is assumed if no boxes are checked.)
    Dusty
    Oily
    Humid (non-condensing)
    Wet and/or condensing
    Salt Spray
    Acid or Oxiding (H2S, Cl, etc.)

    Step 4:

    Need Help with Step 4?
    Expand/Collapse Item Project Costing
    Project Cost
    $
    Salvage Value (existing)3
    $
    Salvage Value (new solution)4
    $

    Step 5:

    Need Help with Step 5?
    Expand/Collapse Item Corporate Taxes
    Marginal Tax Rate
    %
    Discount Rate2
    %
    Project Life
     Years
    Depreciation Method
    Enter multiplier (1 or greater)6

    Step 6:

    Need Help with Step 6?
    Expand/Collapse Item Labor Costs
    Labor Rate
    $
    per hour
    Labor Rate above includes all overhead
    Add the labor overhead costs below to the labor rate above
    Overhead
    FICA1
    %
    Medicare1
    %
    Unemployment1
    %
    Disability
    %
    Other Payroll Taxes
    %
    Local Payroll Taxes
    %
    Cost of Benefits
    % of labor rate
    Cost of Overhead
    % of labor rate

    Step 7:

    Need Help with Step 7?
    Expand/Collapse Item Submit Data

    Press the Find ROI button to review the data entered above. The program will compute a rate-of-return for the investment by comparing the cost of the solution with the cost of doing nothing. The assumption will be that the solution will reduce the likelihood of the problem to essentially zero probability. With the problem eliminated, the resultant downtime caused by the problem will not occur and the costs associated with that downtime will be saved. This savings is compared to the cost of the solution and an IRR (internal rate of return) is computed.


    1FICA (Social Security), Medicare and Unemployment are typically employer matched funds. As a result, the cost to the employer must include these values. These values are in addition to the withholdings paid by the employee.
    2Discount Rate: Internal cost of money or minimum required return before a solution is considered worth of investment. The benefit of this solution must exceed this value.
    3Salvage Value (existing): If the existing product has a residual value that can be captured, then these funds can be applied to the "solution cost", effectively lowering the cost of the new solution by an amount equal to this salvage value. The most conservative estimate is to assume zero salvage value.
    4Salvage Value (new solution): When estimating the total cost of a solution, we total the costs to provide the solution and subtract any benefits, refunds, savings or other payments that reduce the total cost of the solution. One of those refunds is the end-of-life salvage value. If a value is entered here, the calculator adds this benefit to the final year savings and computes a net present value equivalent benefit today based on the discount rate you selected above. This benefit reduces the cost of the solution and works to improve the solution's internal rate of return (IRR). As discussed above, the most conservative calculation is to assume zero salvage value.
    5If the solution does not appear in the list, chose "Other" from pull down list and enter the name or description of the solution. The MTBF and MTTR data must be entered manually. One souce for this information will be Chapter 3 of the IEEE 493 (Gold Book), in particular, table 3-2.
    6Multiple to multiply times the straight-line percentage. This value is multiplied times the remaining book value to determine the annual allowable depreciation allowance. For example, a 5-year straight-line depreciation would depreciate an asset 20% per year. A 1.5 multiplier (150%) would increase the depreciation to 30%, but would be applied not to the original asset value, but rather to the remaining book value at the end of that year. Use this method to simulate 125% or 150% declining balance depreciation methods.

    Copyright Eaton Corporation