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.

In your case, you are trying to calculate the business case for a new business initiative.

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

## Content

Find more PRO+ content and other member only offers, here.

#### 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.

• ### Cambridge Analytica-Facebook case shows need for ethical data mining

Ethical data collection practices are becoming even more important, as cases like Cambridge Analytica's misuse of Facebook data ...

• ### Rethinking analytics processes spurs enterprise innovation

By taking a fresh look at the makeup of their analytics organizations, enterprises can innovate their business models and take ...

• ### Diversified data sets for analytics deliver top results

Analytics teams should focus on data diversity to ensure that their projects deliver the most meaningful insights -- but they ...

## SearchDataManagement

• ### Kubernetes gains momentum in big data implementation process

Big data vendors and users are looking to Kubernetes-managed containers to help accelerate system and application deployments and...

• ### IT, others focus efforts as GDPR implementation date looms

The EU's General Data Protection Regulation is meant to bring better data privacy to bear in the age of big data. How GDPR ...

• ### Streaming tool from StreamSets eyes data in motion for GDPR

StreamSets software for inspecting big data brings governance to data in motion. Such capabilities may find more use as the ...

## SearchSAP

• ### Software license management tools can help with SAP indirect usage

Companies can use third-party license management tools to audit their SAP environment to address indirect access issues, but the ...

• ### New leadership and redesign may spark SAP Community revival

SAP Community Network was once the best forum for SAP developers to share ideas, but user activity declined significantly. Can ...

• ### SAP Ariba Live focuses on procurement for purpose

SAP Ariba Live 2018 focused on the idea that businesses can use procurement technology to do good in the world; for example, by ...

## SearchOracle

• ### Oracle cloud services aim to pull users out of IT comfort zone

Oracle has gone all-in on cloud computing and expanded its line of cloud services in the hopes users will make the jump. But ...

• ### Seven to-do items for managing an Oracle cloud migration

Migrating Oracle systems to the cloud is a big initiative for any organization. Make sure you put a solid migration plan in place...

• ### Oracle sees Autonomous Database changing DBA roles for the good

The job duties of database administrators will likely change in organizations that use Oracle Autonomous Database Cloud, but in ...

## SearchAWS

• ### Management tools emerge from VMware-AWS partnership

VMware provides a series of tools, including Discovery, Cost Insight and Wavefront, to lighten the multi-cloud management burden ...

• ### Amazon Comprehend covers the basics of text analysis

Amazon's text analysis service, Comprehend, parses documents for key phrases, sentiment and more. But there are volume and input ...

• ### Try this data science experiment for deep learning insights

Deep learning professionals require a specific set of skills and tools. Follow this simple example of a data science project to ...

## SearchContentManagement

• ### Box CEO weighs in on Dropbox IPO, AI in content management

In a wide-ranging conversation, Box CEO talks about Dropbox's public offering, AI's next application for content, Salesforce ...

• ### Scrivito unveils serverless CMS product

By building the CMS with ReactJS, Scrivito gained attraction with development community, according to an analyst.

• ### Content personalization tools sharpen focus on customers

Content personalization isn't new; Amazon weaponized it, and Jeff Bezos is the world's richest man. New tools are putting it ...

## SearchSalesforce

• ### Salesforce acquisitions reach new heights with MuleSoft purchase

The intrepid Pipeline podcasters break down the MuleSoft acquisition, which enables hybrid cloud/on-premises CRM. Also: ...

• ### Salesforce-MuleSoft deal focuses on data integration

Beyond producing a hybrid cloud product with its new Integration Cloud, Salesforce now has capabilities for customers to build ...

• ### MindTickle, Salesforce speed sales learning in merger

Last year's Blue Coat-Symantec merger posed a dilemma: getting salespeople up to speed on the reshaped product line. MindTickle ...

Close