Internal Rate of Return (IRR)

What Is Internal Rate of Return (IRR)?

Internal rate of return is the discount rate at which the net present value of an investment's future cash flows equals zero, in other words, the rate of return the investment produces on the capital committed. If that rate exceeds the business's required return, the investment clears the bar.

How It's Calculated

IRR has no closed-form formula that can be solved algebraically. It is found iteratively, by testing different discount rates until the NPV of the cash flow series reaches zero.

The relationship it satisfies is:

0 = Σ [Cash Flow in Period t / (1 + IRR)^t] − Initial Investment

This is the NPV formula with the NPV set to zero and IRR as the unknown. Because the equation cannot be rearranged to solve directly for IRR, the standard approach is to use a spreadsheet function (Excel's =IRR() or =XIRR() for irregular timing) or a financial calculator.

The inputs required:

• The initial cash outflow at Period 0 (entered as a negative number)
• The expected net cash inflows in each subsequent period

The result is a percentage, the annualized rate of return the investment is expected to produce across its full life, given those cash flows. To decide whether an investment is worth making, that percentage is compared to the business's hurdle rate: the minimum return required to justify the capital and risk involved.

XIRR versus IRR: The standard IRR function assumes cash flows occur at equal intervals, annually, quarterly. XIRR accepts actual dates for each cash flow, which is more accurate when inflows arrive irregularly or when the investment period does not align with calendar periods.

Worked Example

A logistics company is evaluating a route expansion that requires an upfront investment of $90,000 and is expected to generate cash inflows over four years. Here are the projected cash flows:

Total undiscounted cash inflows: $120,000

Net undiscounted return: $30,000

The IRR is found by identifying the discount rate that makes the NPV of these cash flows equal to zero. Entered into a spreadsheet as =IRR(-90000, 28000, 34000, 32000, 26000), the IRR for this series is approximately 12.7%.

If the company's cost of capital is 10%, an IRR of 12.7% means the investment returns above the minimum required. The route expansion clears the hurdle on these numbers.

To confirm direction: at a discount rate of 10%, the NPV of this cash flow series is positive, meaning the investment creates value at the company's cost of capital. At 12.7%, NPV approaches zero, which is precisely what IRR represents. The manually presented discount factors below are illustrative of the structure; the precise IRR should always be computed in a spreadsheet to avoid rounding distortion.

Note: manually rounded discount factors will not produce an NPV of exactly zero, use a spreadsheet IRR function for a precise result.

Why It Matters in Practice

It translates an investment's cash profile into a single comparable rate

NPV tells you the dollar value created by an investment. IRR tells you the rate of return it generates. Both are needed, but the rate is often the more intuitive starting point: does this investment return more than our cost of capital? More than our alternative uses of the same cash? The IRR answers that question directly in percentage terms, which makes it easy to communicate and to compare against benchmarks, a bank lending rate, an expected equity return, or the rate on a competing investment opportunity.

It sets a natural threshold for capital allocation decisions

The hurdle rate is the organization's minimum required return. Any investment with an IRR above the hurdle rate creates value; any below it destroys it on a risk-adjusted basis. That threshold makes IRR a straightforward filter for capital allocation decisions: calculate the IRR, compare it to the hurdle rate, and the decision is mechanically supported. In practice, judgment enters around whether the cash flow assumptions are credible and whether risk is adequately reflected in the hurdle rate, but the IRR at least provides a structured basis for the conversation.

It is the standard language for investment evaluation across organizations

Investors, acquirers, and finance professionals across sectors speak IRR as a common currency for investment comparison. A business owner presenting a proposed expansion or acquisition to investors or lenders will typically be asked for the projected IRR. Knowing how to calculate it, and understanding what inputs drive it, is part of presenting a credible financial case. A project with an IRR of 22% makes a stronger case for capital than one with the same narrative description but only a payback period attached to it.

How Internal Rate of Return Affects Your Cash Flow

IRR is the return rate at which a project's cash inflows and outflows balance. Against the cost of capital, it says whether the cash case holds.

The practical connection to cash flow is that IRR is built entirely from projected cash movements, not accounting profit, not revenue targets, but actual expected cash in and cash out. That makes the quality of the underlying cash flow forecast the limiting factor in how much confidence to place in the IRR output. An IRR derived from aggressive early-year projections that assume full adoption from the start is a very different number from one derived from conservative, evidence-based assumptions that build up gradually. The arithmetic is the same; the reliability of the number depends on the projections behind it.

For a business that maintains a rolling cash flow forecast from live accounting data, the projections needed for IRR analysis are grounded in something real, recent revenue run rates, actual cost structures, observed payment timing. That connection between the IRR model and current actuals reduces the distance between the projection and the likely outcome. An IRR calculation built in a spreadsheet disconnected from current books is essentially speculative. One that draws on the same data sources as the operating forecast is more defensible, which matters when the decision is large enough to require external approval or financing.

How You'd See This in Cash Flow Frog

Cash Flow Frog connects to QuickBooks Online, QuickBooks Desktop, Xero, Sage Intacct, Odoo, Zoho Books, and FreshBooks and builds a rolling cash flow forecast automatically from your accounting data. QuickBooks records what happened. Cash Flow Frog projects what is coming.

IRR is a pre-decision tool, it is calculated before an investment is made, to evaluate whether it should be. Once the investment proceeds, the cash flow forecast tracks whether the actual inflows and outflows are matching the projections used to compute the IRR. If revenue from the new route is running below projection in Month 6, that shows up immediately in the forecast against the original assumptions. For investments in businesses with multiple entities or currencies, the forecast consolidates natively across all of them. The broader framework of discounting future cash flows to present value, the foundation IRR is built on, is covered in the related entry at cashflowfrog.com/glossary/discounted-cash-flow/.

Related Terms

• Net Present Value
• Discounted Cash Flow
• Hurdle Rate
• Payback Period
• Capital Expenditure
• Cash Flow Forecast