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

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

• ### Tableau-VoiceBase deal brings speech analytics data to users

Tableau's partnership with AI speech analytics vendor VoiceBase enables users both inside and outside of the contact center to ...

• ### NYPD's Patternizr crime analysis tool raises AI bias concerns

The NYPD has rolled out Patternizr, a machine learning algorithm that helps analysts identify crime patterns but highlights the ...

• ### Users find data preparation tools vital to BI strategies

Data preparation isn't the sexiest topic, but it's critically important to IT and business users, according to a study by Dresner...

## SearchDataManagement

• ### Facebook alumni forge own paths to big data analytics tools

Startups Interana and Rockset differ in their approaches to providing new query capabilities on fast-arriving big data. Both are ...

• ### Building a business glossary enhances data governance

Experts say data professionals are responsible for establishing a common vocabulary across the organization to help ensure data ...

• ### Why data silos matter: Settling ownership of data issues

Data ownership is still seen as a task for IT -- but that can lead to data silos full of redundant information. Find out why you ...

## SearchSAP

• ### SAP S/4HANA migration still just a plan for most customers

According to a new survey by ASUG, most SAP users plan to move to S/4HANA eventually, but they're currently focused on other IT ...

• ### SAP's vision for full SuccessFactors HCM-Qualtrics integration could take years

SuccessFactors HCM customers have access to workplace data that gives them a sense for what's happening, such as an employee exit...

• ### SAP CEO talks Qualtrics acquisition, says experience data is critical

At the Qualtrics X4 Summit, SAP CEO Bill McDermott argues that experience data is now central to business success. He promised to...

## SearchOracle

• ### Oracle Digital Assistant unifies use of enterprise chatbots

With Oracle Digital Assistant, users are able to create digital assistants with multiple chatbots that handle different tasks to ...

• ### Oracle Database 19c new features and what users need to know

Oracle Database 19c is the last update to the 12c Release 2 line of Oracle's database software. This handbook examines its new ...

• ### Oracle 19c database software promises stability, compatibility

Oracle Database 19c offers automatic indexing and support for external data partitions but carries upgrade issues like apps ...

## SearchAWS

• ### AWS Direct Connect tiers address planned network spikes

AWS Direct Connect pivots toward higher bandwidth requirements and cuts prices on lower tiers to handle customers' seasonal ...

• ### Maximize Amazon S3 reliability with shrewd choices

IT organizations moving to AWS might have data protection concerns. However, with replication across regions and versioning ...

• ### Accelerate data migration with AWS DataSync

Dig into the details of AWS DataSync, such as deployment options and availability. Compare it to similar AWS services and see how...

## SearchContentManagement

• ### 4 Office 365 collaboration tools that mirror SharePoint

In order to convince users to move away from SharePoint, Microsoft has built Office 365 collaboration tools that improve upon the...

• ### 9 killer use cases for CMS blockchain

Uses for blockchain technology in content management and social media exist largely in the realm of the theoretical. But there's ...

• ### Content services and archiving records: It's complicated

Content services complicate archiving. Microservices render records dynamically for many devices, while an archive should be a ...

## SearchSalesforce

• ### How Philanthropy Cloud streamlines workplace giving

Perpetual Energy used Salesforce.org's Philanthropy Cloud to create content, track charitable donations and better engage with ...

• ### Salesforce strategy focuses on integration, customer data

Salesforce's strategy for 2019 and beyond includes better data integration and more plans for MuleSoft, Customer 360 and ...

• ### AAA discovers benefits of Salesforce Service Cloud software

Using Salesforce Live Agent and Salesforce Service Cloud, AAA Carolinas increased member engagement by 330% and reduced service ...

Close