Receive the latest technology news and information.

	ROI (Return on Investment)
	Computerworld Daily News (First Look and Wrap-Up)
	Computerworld Blogs Newsletter
	The Weekly Top 10
	Cloud Computing

View all newsletters

E-mail Address:

Industry:

Job Title:

Company Size:

Country:

State:

I would like to receive offers via e-mail from Computerworld partners.

ROI: Do the Math!

ROI Guide: Internal Rate of Return

Gary Anthes Today’s Top Stories

or Other ROI Stories

February 17, 2003 (Computerworld) -- Definition: The internal rate of return (IRR) is the discount rate that results in a net present value of zero for a series of future cash flows.

What it means: It's a cutoff rate of return; avoid an investment or project if its IRR is less than your cost of capital or minimum desired rate of return.

Strengths: It provides a simple hurdle rate for investment decision-making. It's the method favored by many accountants and finance people, possibly the ones at your company.

Weaknesses: It's not as easy to understand as some measures and not as easy to compute (even Excel uses approximations). Computational anomalies can produce misleading results, particularly with regard to reinvestments.

IRR is the flip side of net present value (NPV) and is based on the same principles and the same math. NPV shows the value of a stream of future cash flows discounted back to the present by some percentage that represents the minimum desired rate of return, often your company's cost of capital.

IRR, on the other hand, computes a break-even rate of return. It shows the discount rate below which an investment results in a positive NPV (and should be made) and above which an investment results in a negative NPV (and should be avoided). It's the break-even discount rate, the rate at which the value of cash outflows equals the value of cash inflows.

Consider the three scenarios shown here (see table), each involving an initial investment of $1 million. The investment returns $300,000 (undiscounted) per year in each of the five years after the initial investment, for a net return of $500,000.

A company evaluating this investment using cash flow discounted at 10% would compute an NPV of $137,000, a decent but not spectacular result. But if the company evaluates the same investment at 15%, the project has a present value of only $6,000, essentially just breaking even, and at 20% the project's present value is negative. The IRR is a fraction of a percentage point above 15%; at that discount percentage, the investment's NPV is zero.

IRR is often used as a hurdle rate, a sort of go/no-go investment threshold. Gaylord Entertainment Co. in Nashville, for example, has computed its weighted average cost of capital—a percentage that it won't disclose—and a "hurdle" percentage rate a few points higher. An investment's IRR must generally equal or exceed the hurdle rate to be approved by management, says CIO Kent Fourman.

"We calculate the IRR and then compare that to our hurdle rate," Fourman says. "And we compare that IRR against every other [project's] IRR, because you always have limited cash."

But the IRR cutoff isn't an absolute test, he says. For example, management's subjective assessment of risk may influence an investment decision, he says. "But if you can't show that IRR exceeds our hurdle rate, then you'll have to have a lot of the soft justifications to get it approved," Fourman says.

Not everyone is as enthusiastic about IRR. Like NPV, it doesn't measure the absolute size of the investment or its return. And because of the way the math works, the timing of periods of negative cash flow can affect the value of IRR without accurately reflecting the underlying performance of the investment.

IRR can also produce misleading results because, as classically defined, it assumes that the cash returned from an investment is reinvested at the same percentage rate, which may not be realistic. That error is magnified when comparing two investments of different durations. Some software, such as Microsoft Excel, will compute an optional "modified IRR" that allows the user to specify a different reinvestment rate.

IRR becomes increasingly misleading the more it diverges from the cost of capital, says Ian Campbell, chief research officer at Nucleus Research Inc. in Wellesley, Mass. "IRR is a terrible metric, and it should never be used," he asserts.

The key metric for IT projects, Campbell says, is payback period, because it favors short-term, and hence less risky, projects that IT should be doing.

Internal Rate of Return: What It Looks Like

		Discount rate: 10%		Discount rate: 15%		Discount rate: 20%
Year	Cash flow	Factor	Amount	Factor	Amount	Factor	Amount
0	-$1 million	1.000	-$1 million	1.000	-$1 million	1.000	-$1 million
1	+$300,000	0.909	$273,000	0.870	$261,000	0.833	$250,000
2	+$300,000	0.826	$248,000	0.756	$227,000	0.694	$208,000
3	+$300,000	0.751	$225,000	0.658	$197,000	0.579	$174,000
4	+$300,000	0.683	$205,000	0.572	$172,000	0.482	$145,000
5	+$300,000	0.621	$186,000	0.497	$149,000	0.402	$121,000
Total	+$500,000	NPV = +$137,000		NPV = +$6,000		NPV = -$102,000
		IRR = slightly more than 15%

IRR is often used as a hurdle rate, a sort of go/no-go investment threshold.
In this example, there is an initial investment of $1 million, with a net (undiscounted) return of $500,000. The NPV of the $1 million outlay depends on the discount rate, or cost of capital, used to evaluate the investment. The NPV is zero at the IRR, here a fraction of a percentage point above 15%.

Do the Math! An ROI Guide

Stories in this report:

Print this Story

Send Us Feedback

E-mail this Story

Digg this Story

Slashdot this Story

Report Contents

Featured Articles

	IE9 to tap hardware to boost performance
	New attack fells Internet Explorer
	The 5 best and worst features of Google Chrome OS
	More top stories...

	Free Web apps to help organize your holidays
	Google's Chrome OS hits BitTorrent
	Global warming research exposed after hack

See your link here

Windows 7 tricks: 20 top tips and tweaks

Getting to know Windows 7? Don't stop now: From speeding up taskbar thumbnails to reining in UAC, here are 20 ways to make Windows 7 act the way you want.

Review: Taking the Droid on the road

Is Motorola's new Droid good enough to vanquish iPhone envy? To find out, we took it on a 3-day trip.

Opinion: Linux desktop turns 10; world yawns

Sure, you could always use Linux as a desktop OS, but Corel Linux 1.0 was the first distro designed for ordinary users. It's been a long, strange trip since then.