What is 'IRR'
The internal rate of return (IRR) represents the interest rate in which the net present value (NPV) of a project's expected total cash flows, both positive and negative, sum to zero. The IRR of a project is used as a benchmark; if the IRR of a specific project is higher than a company's required rate of return. the firm accepts the project. If, however, the IRR of a project is calculated to be below a company's required rate of return, the company does not move forward with the project.
BREAKING DOWN 'IRR'
IRR is a metric used across many financial concentrations as a measurement for cash flow analysis. The most common way it's used is as a projectbased tool, but it can also be used by investors when evaluating investments and capital acquisitions. The formula for IRR is laborintensive and takes the initial cash outflow (P0) and sums it with all future cash flows (P1...PN), divided by the IRR and square rooted to the power of the period. The equation for IRR is as follows: 0 = P0 + P1 / (1+IRR) + P2 / (1+IRR)^2 + ... + PN / (1+IRR)^N, where N represents the last period in the sequence of cash flows.
The Importance of the IRR Benchmark
All companies seek to initiate projects with high IRRs; higher IRRs result in higherpercentage returns on investments. Therefore, IRR is used as a decisionmaking tool for situations that include a single project or multiple projects. If a company is evaluating a single project, it looks at the IRR and rejects or accepts the project based on the relationship between its IRR and the company's minimum required return. If a company is evaluating a group of projects, it looks at each one's IRR and chooses a combination of projects that results in the highest collective IRR. If two or more projects are mutually exclusive, meaning that choosing one bars the other from being chosen, the company accepts the project with the highest IRR.
IRR does not take into account the overall size of a project's investment or return. While IRR is an accurate benchmark for managerial decision making, company leaders should also look at the size of the dollar return when making decisions. For example, a small project might have a high IRR percentagewise but a low dollar return. Conversely, a large project may have a smaller IRR yet have a much larger dollar return, making it an attractive investment.

Unconventional Cash Flow
An unconventional cash flow is a series of inward and outward ... 
Negative Gap
A negative gap is a situation where a bank's interestsensitive ... 
Capital Project
A capital project is a longterm investment project designed ... 
Required Rate Of Return  RRR
The required rate of return is the minimum return an investor ... 
Actual Return
Actual return refers to the de facto gain or loss an investor ... 
Average Return
The simple mathematical average of a series of returns generated ...

Investing
Internal Rate of Return Formula for Excel
The internal rate of return, or IRR, is a popular metric businesses use to measure a project’s return on investment. 
Small Business
Calculating IRR with Excel
Find out how to calculate the internal rate of return on investments using Microsoft Excel, as illustrated in different investment scenarios. 
Personal Finance
Project Manager: Job Description & Average Salary
Discover more about the specific tasks that project managers are responsible for and the average salary that can be expected in such a position. 
Financial Advisor
A Guide on the RiskAdjusted Discount Rate
When a project or investment faces higher amounts of risk or uncertainty, it may be appropriate to utilize the riskadjusted discount rate. 
Investing
It's No Accident That Drugs Are Expensive
Branded drugs are expensive in large part because it's expensive and risky to develop them 
Small Business
How to Calculate NPV Using XNPV Function in Excel
Learn how to calculate the net present value (NPV) of your investment projects using builtin functions from Excel using the XNPV function.

How do you calculate IRR in Excel?
Understand how to calculate the internal rate of return (IRR) in Excel and how it's used to determine anticipated yield per ... Read Answer >> 
Which is better for capital budgeting – IRR or NPV?
All other things being equal, using IRR and NPV measurements to evaluate projects often results in the same findings. However, ... Read Answer >> 
Why is the Modified Internal Rate Of Return (MIRR) preferable to the regular internal ...
See why the modified internal rate of return is often a superior metric to the classic internal rate of return for assessing ... Read Answer >> 
How do I use Excel to get discount rate over time?
Learn how to calculate discount rate in Microsoft Excel and how to find the discount factor over a specified number of years. Read Answer >>