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

# How can I calculate internal rate of return (IRR)?

## Internal rate of return (IRR) is a valuable calculation because it generates a projected return that can be directly compared to the company's hurdle rate. Learn how to calculate IRR in this expert tip from Tom Pisello.

What is the formula for calculating internal rate of return (IRR)?

IRR is defined as the discount rate which makes the net present value of a project equal to zero. In mathematical terms, IRR is the projected discount rate that makes the net present value (NPV) calculation equal to zero. The NPV formula is defined as:

The IRR calculation is used to derive the value of r, and then given a series of net benefits (I), the equation yields zero as the NPV. The calculation is performed iteratively, where a computer program guesses at the value of r, and then continuously refines itself, until the equation yields a result at or near zero.

In practical terms, the IRR calculation examines the positive and negative cash flows from a proposed project and generates an interest rate. This rate represents the value another investment would need to generate in order to be equivalent to the cash flows of the investment being considered. For example, with NPV savings calculations, a series of net cash flows could be defined as:

``` Initial = I(0) = - \$100,000 Year 1 = I(1) = + \$175,000 Year 2 = I(2) = + \$175,000 Year 3 = I(3) = + \$175,000
```

For this set of net cash flows, the IRR calculation that yields an NPV of zero is 166%.

The IRR calculation is valuable because it generates a projected return that can be directly compared to the company's hurdle rate. Typically, the hurdle rate is the risk adjusted return a project needs to generate in order to be considered. Risk adjusted returns need to be substantially higher than those generated by safe investments to be considered equivalent. Hurdle rates across all corporate initiatives might range from as low as 15% for safe investments, to over 100% for the riskiest of projects. Due to the complexities associated with new technologies, the short lifecycles of these investments, and the process changes that accompany them, IT project returns are often highly discounted as to the reliability of achieving promised returns within the designated analysis period. IT project hurdle rates of 50% to 100% are common corporate standards.

The value of a high IRR and why hurdle rates are used can be demonstrated in capital market terms. When making a personal investment, money in a savings account is insured, but only yields a 3% to 4% interest rate, while a highly rated bond is not insured and can generate a modestly risky 5% to 6%, and an equity investment is relatively risky and returns an average gain of 10%. The equity investment needs to generate higher potential returns before you would consider taking on the risk of not having an insured investment. If the equity investment only yielded 5% to 6%, is the marginal gain worth the extra risk? This is the hurdle rate, the rate at which the investment makes sense given a specific risk profile and tolerance. A high return above the hurdle rate provides a return that exceeds the relative risk. By calculating IRR, a corporation can consider whether the projected risks of applying capital and labor resources to the project are worth the returns.

This was last published in February 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.

• ### Predictive analytics projects can bolster business decisions

Blind faith in predictive models can result in flawed business decisions. Analytics teams need to manage predictive processes ...

• ### How predictive analytics techniques and processes work

Predictive analytics is no longer confined to data scientists and other highly skilled analysts. But other users need to ...

• ### Hyper engine aims to give enterprise Tableau analytics a boost

The Hyper in-memory data engine added in Tableau 10.5 could make Tableau analytics capabilities more expansive, enabling the ...

## SearchDataManagement

• ### Apache Hadoop 3.0 goes GA, adds hooks for cloud and GPUs

Is this the post-Hadoop era? Not in the eyes of Hadoop 3.0 backers, who see the latest update to the big data framework ...

• ### Expert: For BI, you must know the data integration process

Understanding the data integration process is central to self-service BI and data architecture design, consultant Rick Sherman ...

• ### Graph technology rivals take Amazon Neptune database in stride

Amazon's Neptune database may change the status quo in the graph technology world. But it could also introduce a wider base of ...

## SearchSAP

• ### SAP S/4HANA Cloud and indirect access will dominate 2018

Industry experts say SAP S/4HANA Cloud migrations, Leonardo and Cloud Platform are the technology issues for SAP in 2018; on the ...

When a Dutch energy grid provider needed to develop new business apps on top of SAP ERP, it turned to the Mendix RAD platform to ...

• ### SAP's Timo Elliott on enterprise chatbot AI technology

The SAP global innovation evangelist expects AI to affect businesses in three ways: human-computer interaction, automation of ...

## SearchOracle

• ### Using Oracle 12c Unified Auditing to set database audit policies

Oracle Database 12c's built-in Unified Auditing feature streamlines the database auditing process, including creation and ...

• ### Top Oracle tips and tricks of 2017 you won't want to forget

We've rounded up five of the most notable tip articles we published in 2017, with advice that can help make Oracle projects ...

• ### Big Data Cloud Service streamlines Oracle Hadoop deployments

As part of its Big Data Cloud Service, Oracle provides a set of internal and external tools designed to help users efficiently ...

## SearchAWS

• ### AWS Auto Scaling simplifies management across services

Amazon's Auto Scaling service can reduce duplicate efforts by users. It's also the latest example of Amazon’s effort to ...

• ### Three Amazon AI-based projects to get your dev team rolling

Amazon AI technologies expand capabilities for enterprise developers. Try out these sample AI projects to familiarize yourself ...

• ### AWS-VMware partnership remains a win-win -- for now

When AWS and VMware partnered up, it opened new revenue streams for each company. But does the deal mark a one-off collaboration ...

## SearchContentManagement

• ### Intelligent information management the next wave for ECM

In a 2018 upgrade, M-Files allows users to search for content in multiple repositories, while also being able to automatically ...

• ### SharePoint integration and implementation best practices

Here are some expert advice and tips, as well common definitions, to help make your SharePoint integration and implementation a ...

• ### SharePoint branding capabilities get a facelift

Since Microsoft Ignite last September, SharePoint Online is getting new branding capabilities that have been on the wish lists of...

## SearchSalesforce

• ### Salesforce databases remain Oracle, for now

Oracle and Salesforce executives deny reports of Salesforce moving on from Oracle infrastructure.

• ### Comparing Salesforce Einstein AI across the clouds

What do you get when you pay for Einstein features in the Salesforce Sales, Service and Marketing clouds? We put it all in one ...

• ### Salesforce Marketing Cloud certification helps Aussie make bank

When considering which credentials in the Salesforce universe are the best investments, one marketing consultant makes the case ...

Close