IT Project ROI (Return on Investment) Tool
Originally published: 05/08/2016 09:12
Last version published: 29/07/2020 06:03
Publication number: ELQ-22870-3
View all versions & Certificate

IT Project ROI (Return on Investment) Tool

Credibly assess/quantify the costs and benefits (ROI / TCO) of a variety of IT investments

The "IT Project ROI Tool" enables the development of comprehensive business case assessments for IT projects.

This tool is a comprehensive general-purpose business value model (ROI calculator) to support the development of business cases for enterprise-scale information technology-based projects. It provides a robust structure to help organisations assess the business value (costs, benefits, TCO, and ROI) of technology projects/initiatives.

It helps organizations to assess, quantify, and communicate the costs, benefits, business value, and ROI of many types of enterprise-scale technology-based initiatives. It also helps to assess the organization’s current (as-is) and expected (to-be) IT spending (TCO) levels and the solution’s impact on a variety of key performance indicators (KPIs). It produces summary business case reports in Word that can be edited and presented to decision-makers.

The tool estimates the costs required to implement the new capabilities/solution, including hardware, software, IT labor, services, and user labor. It simulates benefits (user productivity, IT TCO savings, business cost savings, revenue growth, and KPI improvements) enabled by the solutions selected.

You can customize these templates for your own business.

The tool is updated by using our Excel-to-Word Document Automation Add-in.

This Best Practice includes
Excel Workbook, Word Document and directions

Andrew Hall offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

• Supports most types of enterprise-scale technology initiatives.
-> Includes sample cost and benefit data for 18 common initiative types.

• Comprehensive assessment of initiative costs and benefits:
-> Costs: hardware; software, IT labor, training, and services and user labor and training
-> Benefits: IT labor TCO savings. other direct cost savings, user productivity benefits, revenue growth, and non-financial key performance indicators

• Calculates annual on-going IT Labor TCO (total cost of ownership)

• Comprehensive financial analysis.
-> Calculates project cash flow, cost-benefit analysis, ROI. NPV, IRR. and payback period

• Supports rapid (30 minute) or detailed (3+ day) assessments.
-> This model was designed to provide either a rapid assessment (by just entering/selecting basic organizational profile and initiative information) or a very detailed (3+ day) assessment by modifying hundreds of detailed inputs.

• Protected, yet customizable:
-> Essentially all values can be modified. Many custom cost and benefit items can be added. Formulas and other areas of the model that should not be modified are protected (locked) to maintain intended functionality. HCR can provide additional fee-based customization, if desired.

• Based on industry-standard calculations and industry-leading methodologies.
-> It is as transparent as possible so the user is able to understand how the costs and benefits are calculated.

• Provides research-based default values.
-> Default values (labor costs. user type mix. financial information. etc.) are provided based on your industry, geography, organization size and initiative type to enable more rapid assessments. Extensive research was conducted to find highly reputation sources for
these. Data/estimate sources are listed. You may overwrite any of the pre-populated defaults.

• User-friendly.
-> The workbook contains instructions. descriptions. and references. Results are updated real-time and are displayed graphically throughout the model. Although the model is user-friendly. we recommend users have at least a moderately-advanced understanding of business value concepts to develop a credible business case.

• This workbook can be used as a standard corporate business case template for technology-based initiatives.

• It can also be used by consultants and technology vendors to articulate the business value of their products and solutions.

• This tool is intended to help guide organizations in better understanding approximate/potential costs and benefits. Due to limitations of simulation tools, actual results may differ significantly than results estimated in this tool. Investment decisions should not be based on the results of this model alone - it is not intended to be a substitute for professional advice.

• This information is provided to you as a tool 'as is" with the understanding that there are no representations or warranties of any kind either express or implied.

• In no event shall AnalysisPlace or suppliers be liable for any damages. including those arising as a result of AnalysisPlace or supplier negligence. whether those damages are direct, consequential, incidental or special, lowing from your use of or inability to use the tool, or information provided herewith, or results of the tool's use, even if AnalysisPlace or suppliers has been advised of the possibility of such damages.

4.9 / 5 (11 votes)

please wait...