Q
Problem solve Get help with specific problems with your technologies, process and projects.

# Comparing ROI for multiple business initiatives

## Trying to compare multiple projects requiring different investments? Use this formula from CRM ROI expert Tom Pisello.

I am trying to compare multiple projects requiring different investments. Could you give me a formula for calculating ROI? Here's what I have as inputs:

* Five-year forecast (units)
* Unit price (\$)
* Unit cost (\$)
* Investment (\$)

Do I need any other inputs for calculation?

The ROI calculation is performed by comparing the ratio of net benefits (total rewards – investments) from a project versus the total investment over a set time period – usually between three to five years.

1. First you need to calculate the total sales revenue from this product line over the five year period as:
a. Total Sales Revenue = Total sales units over five years * unit price

2. Now you need to calculate the cost of goods sold from the sales over the five year period:
a. Cost of Goods Sold = Total sales units over five years * unit price

3. Now calculate the net incremental margin contribution from the sale of the product as:
a. Net incremental margin = Total Sales Revenue -- Cost of Goods Sold

4. Finally, to calculate the ROI, you need to factor in the investment:
a. ROI = (Net incremental margin – investment) / investment

A twist to the equation would be to include net present value in the calculations – discounting and adjusting the analysis so that all figures are normalized into today's dollar terms. As money has a time value, in order to have future benefits offset up-front investments, these investments typically have to be much larger than the initial investment – to make up for the lost opportunity from investing the funds elsewhere, and also to make up for inflation. If the project has an up-front investment is large and if the rewards occur greatly in later years, it is particularly important to use net present value variation on ROI (we call it risk-adjusted ROI).

To use net present value (NPV), first you need to have an overall discount rate (minimally the cost of capital for the organization) typically from 8-15%. Once this is known, you analyze the net cash flows look like year over year, applying a net present value discount in each year to translate all cash flows into today dollar terms.

In order to factor NPV in, for each calculation above, you need to analyze the benefits and costs over each year. The formula would look like the following, assuming that the investment made is all initial investment:

((Y1 net incremental margin * Y1 discount rate factor +
Y2 net incremental * Y2 discount rate factor +
Y3 net incremental * Y3 discount rate factor +
Y4 net incremental * Y4 discount rate factor +
Y5 net incremental * Y5 discount rate factor) -
Initial investment ) Divided by the Initial investment

Where the discount rate factor is used per year:

This was last published in January 2007

#### Have a question for an expert?

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

#### Start the conversation

Send me notifications when other members comment.

• ### Ten KPI templates for your dashboards

KPIs help companies gauge success, but how do you choose the right metrics to create useful reports? Here you'll find 10 KPI ...

• ### Data visualization process demands smart design, accurate data

Well-designed data visualizations can enable executives to make more-informed business decisions, increasing the potential ROI of...

• ### Seven good data visualization practices for visual integrity

Data visualizations need visual integrity to ensure that the data they present can be interpreted correctly. Follow these design ...

## SearchDataManagement

• ### AP uses data collaboration platform to spread data journalism

Data journalism reporters need tools that deliver quick context for stories on deadline. A data collaboration platform from ...

• ### GPU databases bring greater parallelism to big data processing

GPU databases offer a new way to process data. 451 Research analyst James Curtis discusses where they fit in big data ...

• ### Distributed SQL database wagered on for scalability boost, GDPR

CockroachDB is a distributed database system that seeks to support processing on a global scale, a need that online gambling ...

## SearchSAP

• ### Inside SAP's digital transformation strategy

In this Q&A, Bertram Schulte, SAP's chief digital officer, discusses the how and why as the company goes through its own internal...

• ### SAP Cloud Platform pushes to break new ground, extend ERP

SAP wants its Cloud Platform to connect ERP systems with new technology like machine learning and IoT, resulting in new processes...

• ### SAP Cloud Platform architecture is glue for new technologies

SAP Cloud Platform has numerous integration tools for linking next-gen technologies like blockchain, machine learning and IoT to ...

## SearchOracle

• ### AI-for-IT-operations tools map Vegas systems to Oracle ERP

Mapping IoT activity and other IT data to Oracle ERP is the task Las Vegas set for FixStream's AIOps platform in an effort to ...

• ### Oracle 18c features give DBAs incremental database capabilities

Oracle Database 18c is really another version of 12c Release 2 with a different name. It doesn't contain major new features, but ...

• ### Cloud workloads see gradual uptake, but miles to go for databases

A picture of steady but not rapid migration to the cloud by Oracle users emerged at Collaborate 18, with database vets saying ...

## SearchAWS

• ### Three AWS budget challenges that plague enterprises

Based on their size, companies face unique challenges around budget management in the cloud. Follow this expert advice to keep ...

• ### Implement AWS billing alerts to stay on budget

AWS offers compute power at your fingertips, but cloud resources can quickly drive up costs if users aren't careful. Stay within ...

• ### EC2 features geared toward modest enterprise adoption

AWS infrastructure services now offer more VM control, licensing flexibility and a price cut -- all part of its plan to lure ...

## SearchContentManagement

• ### Five areas to focus on in a SharePoint and GDPR compliance strategy

SharePoint admins need to be ready for the General Data Protection Regulation, too. Expert Reda Chouffani suggests five things to...

• ### Workplace collaboration tool bolsters employee productivity

The benefits of workplace collaboration tools trickle down to employee relationships, company growth, community engagement and ...

• ### New age collaboration tools empower the future of ECM

Document management, file-sharing and ECM platforms might represent 'ancient' 1990s technology, but AI and collaboration tools ...

## SearchSalesforce

• ### Salesforce's GDPR DPO preps partners, customers for compliance

Salesforce's data protection officer discusses GDPR compliance challenges and strategies for customers and partners, along with ...

• ### AI for sales product Clari helps to enhance Salesforce

One company found that when using a variety of different vendors, a third-party AI product was more beneficial than a core ...

• ### GDPR customer data compliance for service and support teams

Getting your Salesforce-powered customer service and support staff ready for GDPR involves more than just the free Trailhead ...

Close