Imagine your friend wants to buy a used ice cream cart for 2,000 dollars. They predict the cart will make 800 dollars each summer for the next three years. They ask you if this is a good deal compared to leaving that 2,000 dollars in a bank account that pays 5 percent interest. How do you find the single exact percentage return that this ice cream business delivers?
In business and investing, that exact percentage return is called the Internal Rate of Return, or IRR. By testing your cash flow stream on Calcsolver or using trial-and-error discounting, you can find the breakeven interest rate that turns your future cash flows into an exact match for your starting investment.
Understanding IRR lets investors, real estate buyers, and corporate leaders compare completely different projects on a level playing field.
What is the Internal Rate of Return and How Does It Work
The Internal Rate of Return is the specific annual discount rate that causes the Net Present Value of all cash flows from a project to equal exactly zero. In simple terms, it is the expected compound rate of return that an investment generates over its operating lifetime.
The mathematical equation setting NPV to zero is written as:
0 = Sum of [Cash Flow at Time t / (1 + IRR)^t] - Initial Outlay
Where the mathematical terms represent:
- IRR: The internal rate of return discount factor that balances inflows and outflows.
- Cash Flow at Time t: The net cash received in each respective operating period.
- Initial Outlay: The total upfront capital committed at time zero.
- t: The sequence of time periods spanning the life of the asset.
Also read: Net Present Value Calculator How to Calculate NPV with Examples
You may also like: Operating Profit Margin Formula How to Measure Core Business Health
How IRR Relates to the Hurdle Rate
In corporate capital budgeting, every company establishes a minimum required rate of return, commonly referred to as the hurdle rate or cost of capital. The hurdle rate represents the minimum interest rate a project must surpass to justify spending company cash.
The core investment decision framework is straightforward:
- If IRR is greater than the Hurdle Rate: Accept the project. The expected return exceeds the borrowing cost of capital.
- If IRR is less than the Hurdle Rate: Reject the project. You would earn a better return by investing the cash elsewhere.
- If IRR equals the Hurdle Rate: The project is financially neutral, generating just enough cash to cover its capital cost.
Step by Step Worked Real Estate Rental Example
Let us look at a simplified commercial property investment. Suppose an investor purchases a warehouse storage unit for 100,000 dollars upfront. The unit produces net rental income of 35,000 dollars in year one, 45,000 dollars in year two, and 50,000 dollars in year three.
Step one: Set up the NPV equation equal to zero. 0 = -100,000 + [35,000 / (1 + r)^1] + [45,000 / (1 + r)^2] + [50,000 / (1 + r)^3].
Step two: Test an initial trial rate of 10 percent. At 10 percent, the discounted inflows equal 31,818 + 37,190 + 37,566 = 106,574 dollars. Subtracting 100,000 dollars leaves positive 6,574 dollars. Because NPV is positive, the true IRR is higher than 10 percent.
Step three: Test a higher rate of 15 percent. At 15 percent, the discounted inflows equal 30,435 + 34,026 + 32,876 = 97,337 dollars. Subtracting 100,000 dollars leaves negative 2,663 dollars. Because NPV is now negative, the true IRR lies between 10 percent and 15 percent.
Step four: Interpolate linearly to find the exact zero crossing point. The exact internal rate of return calculates to approximately 13.52 percent.
| Discount Rate Tested | Sum of Discounted Inflows | Initial Investment Outlay | Resulting Net Present Value |
|---|---|---|---|
| 8 percent trial rate | 110,698 dollars | 100,000 dollars | +10,698 dollars |
| 10 percent trial rate | 106,574 dollars | 100,000 dollars | +6,574 dollars |
| 13.52 percent exact IRR | 100,000 dollars | 100,000 dollars | 0 dollars (Breakeven) |
| 15 percent trial rate | 97,337 dollars | 100,000 dollars | -2,663 dollars |
| 18 percent trial rate | 92,829 dollars | 100,000 dollars | -7,171 dollars |
Key Limitations and the Reinvestment Assumption Trap
While IRR is beloved by executives because it expresses performance as a clean percentage, it possesses one major theoretical flaw: the reinvestment rate assumption. Standard IRR assumes that all positive cash flows received during the project can immediately be reinvested at that same high IRR rate.
In reality, reinvesting cash at 30 percent or 40 percent in modern financial markets is often impossible. When comparing mutually exclusive projects with wildly different capital sizes, NPV should always take precedence over IRR.
Frequently Asked Questions About Internal Rate of Return
Can a Project Have Multiple IRRs
Yes. If a project has alternating signs in its cash flows (such as negative initial costs, positive mid-term revenues, and a negative shutdown cleanup cost at the end), Descartes Rule of Signs dictates that multiple mathematical IRRs can exist.
What is the Difference Between IRR and CAGR
CAGR evaluates the smoothed annual return of a single lump sum that grows between day one and the final date with zero interim additions. IRR accounts for multiple periodic inflows and outflows arriving at different times.
What is Modified Internal Rate of Return MIRR
MIRR corrects the unrealistic reinvestment assumption of standard IRR by assuming that cash inflows are reinvested at the actual cost of capital rather than the project own internal rate.