1. Saves time in calculating and creating ROI charts.
2. Simplified tool that with two data input sheets - Cost and Benefit Data
3. Some of the financial calculations include - Return on Investment (ROI) for 3-year horizon, total savings over three years, Net present value (NPV), average monthly benefit, payback period (years).

DOCUMENT DESCRIPTION

The ROI tool has been developed to calculate the Return On Investment (ROI) value for a project. It is designed with an objective to build a business case and support prioritization process by evaluating real impact to the bottom line. Download this simple yet complete tool to use as-is or modify the way you like. It has potential to save you hours of your effort if you plan to develop something similar from scratch or look for it elsewhere on the Internet. The spreadsheets can be customized. The categories of benefit include, but not limited to:
DS1 Direct Savings: Base cost reduction (Maintenance, Suppliers, etc.)
DS2 Direct Savings: Material reduction (Price or Quantity reduction), reduced outage, improved capacity factor
DS3 Direct Savings: Overtime reduction / Other
P1 Productivity / Indirect benefits: Reduction in number of service hours (equipment fix time), process improvement related savings
P2 Productivity / Indirect benefits: Administrative task simplification (Time to complete), rework reduction
P3 Productivity / Indirect benefits: Other - technology management, customer satisfaction, etc.
CA1 Cost Avoidance: Reduction of currently incurred costs, anticipated future cost increase avoidance

Got a question about the product? Email us at [email protected] or ask the author directly by using the form to the right. If you cannot view the preview above this document description, go here to view the large preview instead.