ROI Guide: Internal Rate of Return - ComputerworldIT Management CenterIT Management Center - Help Desk/User Support - Help Desk/User Support - IT Spending - IT Spending - Project Management - Project ManagementE-business CenterE-business CenterOutsourcing CenterOutsourcing Center - ASP - ASP - ISP/Telecom - ISP/Telecom - IT Services - IT ServicesROI CenterROI CenterCareers CenterCareers Center - Consulting/Contracting - Consulting/Contracting - Education/Training - Education/Training - Hiring/Recruiting - Hiring/Recruiting - Workforce - Workforce - Skills - SkillsSearch/Post JobsSearch/Post JobsSecurity CenterSecurity Center - Cybercrime - Cybercrime - Encryption - Encryption - Disaster Recovery - Disaster Recovery - Firewalls - Firewalls - Hacking - Hacking - Privacy - Privacy - Security Holes - Security Holes - Viruses and Worms - Viruses and Worms - VPN - VPNHardware CenterHardware Center - Handhelds - Handhelds - Desktops - Desktops - Laptops - Laptops - Grid Computing - Grid Computing - Mainframes - Mainframes - Server - ServerStorage CenterStorage CenterSoftware CenterSoftware Center - Applications - Applications - Application Development - Application Development - E-mail/Groupware - E-mail/Groupware - Graphics/Multimedia - Graphics/MultimediaCRM CenterCRM CenterERP/Supply Chain CenterERP/Supply Chain CenterOperating Systems CenterOperating Systems Center - Mainframe OS - Mainframe OS - Unix - Unix - Windows - Windows - Linux - Linux - Macintosh - MacintoshData Management CenterData Management Center - Data Center - Data Center - Databases - DatabasesBusiness Intelligence CenterBusiness Intelligence Center - Data Mining - Data Mining - Data Warehouse - Data WarehouseStorage CenterStorage CenterNetworking CenterNetworking Center - Firewalls - Firewalls - Network LAN/WAN - Network LAN/WAN - Network Management - Network Management - Network OS - Network OS - Network Protocols - Network Protocols - VPN - VPN - VoIP - VoIPGovernment CenterGovernment Center - IT in Government - IT in Government - Government Policy - Government Policy - Legal Issues - Legal Issues - Legislation - LegislationMobile & Wireless CenterMobile & Wireless Center - Handhelds - Handhelds - Laptops - Laptops - Wireless Technology - Wireless Technology - Wi-Fi - Wi-FiDevelopment CenterDevelopment Center - Application Development - Application Development - .Net - .Net - Java - Java - Web Development - Web Development - Web Services - Web Services - XML - XMLWeb Site Management CenterWeb Site Management CenterAutomotiveAutomotiveDefense/AerospaceDefense/AerospaceEnergy/UtilitiesEnergy/UtilitiesHealth CareHealth CareFinancialFinancialRetailRetailTransportationTransportationTravelTravelManufacturingManufacturing Computerworld IDG.net Whitepapers _______________ Careers CRM Business Intelligence Development E-business ERP/Supply Chain Hardware IT Management Mobile & Wireless Networking Operating Sys ROI Security Storage Web Site Mgmt Outsourcing Knowledge Centers Security Storage Mobile & Wireless Hardware Business Intelligence Networking Software Jump to any Knowledge Center ---------- Business Intell. CRM Careers Data Mgmt. Development E-business ERP Government Hardware IT Management Mobile/Wireless Networking O/S Outsourcing ROI Security Software Storage Web Site Mgmt. Partner Zones Application Performance Business Service Mgmt Collaboration Convergence CRM OnDemand Features Latest Headlines This Week's Issue Shark Tank Research Webcasts White Papers Software Downloads Buyer's Guides E-mail Newsletters News Feeds Home > Browse Topics > Management > ROI ROI Guide: Internal Rate of Return There's more to this story: > ROI Guide: Economic Value Added > ROI Guide: The Consultants' Offerings > Where ROI Models Fail > ROI Guide: Balanced Scorecard > EVA shows outsourcing's payoff > ROI Guide: Payback Period > ROI Guide: Net Present Value > ROI Guide: Real Options > Three Problems This story is part of a Special Report Click here to see the entire report News Story by Gary H. Anthes 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% YearCash flowFactorAmountFactorAmountFactorAmount 0-$1 million1.000-$1 million1.000-$1 million1.000-$1 million 1+$300,0000.909$273,0000.870$261,0000.833$250,000 2+$300,0000.826$248,0000.756$227,0000.694$208,000 3+$300,0000.751$225,0000.658$197,0000.579$174,000 4+$300,0000.683$205,0000.572$172,0000.482$145,000 5+$300,0000.621$186,0000.497$149,0000.402$121,000 Total+$500,000NPV = +$137,000NPV = +$6,000NPV = -$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%. Subscribe to our IT Management/Leadership e-mail newsletter: E-mailZIP Code Also in the ROI Knowledge Center News | Discussions | Buyers' Guides | Resource Links | White Papers | IT Spending Analysis | Mobile Channel | E-mail newsletters > ROI XML Feed > XML Feed FAQ Additional Content ROI White Papers Read up on the latest ideas and technologies from companies that sell hardware, software and services. SAN Performance Monitoring is Essential to Maintaining SAN Uptime: NAS Cluster White Paper: Windows File Serving White Paper: FDC White Paper: “Flexible Database Clusters with IBM eServer Realizing the Mobile Enterprise with 2.5G Wireless Solutions View ROI whitepapers Research Report This IDC white paper demonstrates growth in value of distributed applications accessed over the Web, especially for eCommerce applications, and analyses the requirements needed for performance management of distributed applications in today's complex heterogeneous environments. Distributed Applications Performance Management: The VERITAS i3 Approach Featured Webcasts The Enterprise Unwired Learn about global trends in wireless technologies, and hear some real-world examples of the ways forward-thinking companies are taking advantage of wireless technologies, in this exclusive webcast. Make a credible case for spending money on IT security Email viruses, worms; hacking attacks; and the difficulties of keeping up with patch management tasks and other protective measures, has forced every company to be concerned about information security. Learn more. Sponsored Links Unburden Your Primary Storage Learn How. Free Nearline Storage white paper. Mobilize Your Enterprise For Success New Webcast Free Guide How to web-enable BPM apps in just weeks, not months HP workstations at PC prices Xtreme machines for Xtreme users. Click here or Call 1-888-367-2402 Improve IT Efficiency. Windows Server System makes it possible. The IP migration A wake-up call Securing Your Website for Business Looking for mission-critical server security? Click for cost-effective Intel® enterprise solutions EnvoyWorldWide White Paper: 'Shattering the Myths of Automated Notifications' Enterprise Grid Alliance Helping make grid computing work for you Scalable. Affordable. Reliable. IBM eServer xSeries systems with Intel® XEON™ processors. Dell has everything you need to Build a Scalable Enterprise Now. About Us Advertise Contacts Editorial Calendar Help Desk Privacy Policy Reprints Site Map Copyright © 2004 Computerworld Inc. All rights reserved. Reproduction in whole or in part in any form or medium without express written permission of Computerworld Inc. is prohibited. Computerworld and Computerworld.com and the respective logos are trademarks of International Data Group Inc.