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.

• Self-service analytics tools hand BI power to business users

Self-service BI software opens the door to wider analytics uses in organizations. This handbook compares top self-service tools ...

• Tableau vs. Power BI vs. Qlik: How the BI rivals stack up

Tableau, Power BI and Qlik Sense offer similar self-service BI functionality, consultant Rick Sherman says. But he points to some...

• Tibco analytics capabilities get upgrade in Spotfire X

New Tibco AI and natural language processing functions in the soon-to-be-released Spotfire X look to create a simpler and faster ...

SearchDataManagement

• Containers key for Hortonworks alliance on big data hybrid

Hortonworks is joining with Red Hat and IBM to work together on a hybrid big data architecture format that will run using ...

• Big data tooling rolls with the changing seas of analytics

Hadoop data tooling is expanding. A view holds that Hadoop is moving from alternate data warehousing to a full-fledged big data ...

• Graph processing gives credit analysis firms an edge

A graph database startup's parallel loading, processing and querying combine to deliver real-time data for fintech firms that ...

SearchSAP

• Digital transformation goals spark new S/4HANA migration momentum

S/4HANA upgrades form the core of digital transformation for SAP organizations, but many underestimate the challenges, such as ...

• Greg Tomb: HANA underpins SuccessFactors, post-2025 SAP HCM

The cloud has loomed large in Greg Tomb's SAP career. Now, he has a year under his belt at SuccessFactors and much to say about ...

• Trust grows in public cloud adoption for HANA, consultant says

In this Q&A, Matt Lovell of SAP consultancy Centiq talks about the current state of cloud deployments for SAP HANA and why an S/...

SearchOracle

• Breaking down AI-infused Oracle Autonomous Cloud services

Oracle offers AI-infused cloud services for analytics, application development, application and data integration, data management...

• Oracle Autonomous Database Cloud gets transaction processing

Oracle launched a transaction processing version of Autonomous Database, a cloud-based platform that automates configuration and ...

• The future of SPARC/Solaris is cloudy -- in multiple ways

Cutbacks by Oracle have put the future of SPARC and Solaris in doubt, but the vendor says it's still committed to the ...

SearchAWS

• Centralize AWS account management with native SSO tool

Some third-party tools have longer track records, but AWS SSO offers an appealing alternative as a native service to handle cloud...

• Assess, manage AWS costs with third-party tools

An ecosystem of third-party products augment AWS' vast portfolio of cloud services, including cost management tools. Dig into ...

• Weave AWS CodePipeline into serverless app deployment

CodePipeline brings a number of benefits to serverless app development and deployment, including the elimination of mundane tasks...

SearchContentManagement

• New rules for WCM tools enhance the search experience

WCM used to mean platforms for webpages viewed on desktops. Today, it's morphing into digital experiences, and it taps AI as well...

• AI-assisted image and video search is next content frontier

You can search text, but it's harder to catalog images and video. New tools are automating those processes at the enterprise ...

• Box AI strategy looks to give users AI development tools

Box wants to be the hub of its enterprise users' software and AI content ecosystems with integrations and partnerships ranging ...

SearchSalesforce

• Dreamforce 2018 conference highlights and key takeaways

Salesforce will reveal new features, tools and platform updates at Dreamforce 2018 in San Francisco Sept. 25-28. Use this guide ...

• Dreamforce brings Salesforce products upgrades

More than 150,000 attendees are expected at Dreamforce in San Francisco, where Salesforce will show how recent acquisitions fit ...

• Salesforce implementation offers window into partner management

Implementing Salesforce Sales Cloud, Service Cloud and Community Cloud has enabled a national window treatment company to ...

Close