Q

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

Oldest

• ### SQL engines boost Hadoop query processing for big data users

Organizations with big data environments are turning to SQL-on-Hadoop software to speed up analytical queries and data ...

• ### Reality check needed to assess AI applications

When assessing the reality behind today's AI technology, businesses need to think about how it can perform in specific tasks ...

When it comes to building a data science team, businesses should expect to find workers from a variety of backgrounds rather than...

## SearchDataManagement

• ### Big data challenges traditional data modeling techniques

Surging big data is changing data modeling techniques, including schema creation. The word from Enterprise Data World 2016: Data...

• ### EBay helps drive new style of data engineering

Open source data engineering has become a way of life at e-commerce leader eBay, says the company's Debashis Saha. Kylin is one ...

Cloudera distribution including Apache Hadoop provides an analytics platform and the latest open source technologies to store, ...

## SearchSAP

• ### Integrate cloud to on-premises with HANA Cloud Integration

SAP offers a raft of prebuilt integrations that handle many of the key business processes between major cloud and on-premises ...

• ### Courtroom lessons from a failed SAP ERP implementation

A consulting firm's expert witness explains what SAP and a global manufacturer did -- and didn't do -- that led to a major SAP ...

• ### Building data visualization with SAP Fiori tools

Some BI developers will get by fine with features such as the Fiori Launchpad and Overview pages. Here's what's built into Fiori ...

## SearchOracle

• ### ECCU shares ups, downs of Oracle Fusion Financials migration

Moving to Oracle Fusion Financials has been a mixed blessing for the Evangelical Christian Credit Union. It saved money, but had ...

• ### Oracle Enterprise Manager 13c gives DBAs new cloud tools

The latest version of Oracle Enterprise Manager is designed to make life easier for DBAs working in the cloud. Oracle Enterprise ...

• ### Oracle Collaborate conference generates buzz in Las Vegas

The Oracle database and applications forum, presented by three independent user groups, combines hands-on experiences, networking...

## SearchAWS

• ### AWS, partners' balancing act weighs on users, too

AWS partners are a critical part of the growing ecosystem, but the choice between third-party services and the waiting game for ...

• ### Words to go: AWS data storage

If you're confused about which data storage option is ideal for your enterprise, refer to our reference sheet on AWS tools and ...

• ### Using AWS CloudFormation templates to deploy IAC

CloudFormation templates help IT teams quickly and safely update AWS-based applications. The time saved on the back end could ...

## SearchContentManagement

• ### The state of three legal document management tools

Microsoft and other document management providers have updated their software to meet the needs of the legal industry. Here's how.

• ### SharePoint Online Public Website drops off, pricing doesn't

Microsoft is killing off support for SharePoint public websites, and companies will now have to go to third parties for support. ...

• ### How close is too close in context-aware computing?

Context-aware technology is hyped to the max, enabling companies to gather precious data about customers. But it has to be mature...

Close