Summary

The Excel IRR function calculates the internal rate of return for a series of periodic cash flows. In practical terms, it finds the periodic discount rate that makes the net present value of the cash-flow stream equal to zero.

IRR is popular because it turns a full timeline of periodic inflows and outflows into one rate figure that can be compared with a hurdle rate or required return. That convenience is useful, but the result still depends on the cash-flow pattern and the periodic timing assumption behind it.

Microsoft also notes that IRR is iterative and may need a good starting guess in more difficult cases. The function is therefore best treated as a rate-solving tool, not as a substitute for broader project valuation.

Syntax

=IRR(values, [guess])

values is the cash-flow series in chronological order. The optional guess is the starting estimate used by Excel's iterative solver. If omitted, Excel starts near 10%.

Microsoft requires at least one negative value and one positive value in the series. Without that sign change, there is no meaningful return rate for IRR to solve.

Arguments

• values - Cash flows in chronological order, including at least one negative and one positive amount.
• guess - [Optional] Initial estimate for the iterative search.

IRR assumes equal spacing between periods. If the cash flows occur on irregular dates, the more appropriate function is XIRR.

IRR vs Related Functions

IRR is a rate metric, not a value metric. That distinction matters when the worksheet needs to compare projects with different scale or different timing structures.

IRR is often useful for screening, but NPV remains essential when the worksheet needs to measure how much value a project creates in absolute terms.

Using the IRR Function

IRR is commonly used in capital budgeting because it compresses a full periodic cash-flow pattern into one return figure. That makes it easy to compare the project with a required return threshold or financing benchmark.

At the same time, IRR should be read with care. The function assumes periodic timing, and some cash-flow patterns can produce ambiguous or difficult results. For that reason, a worksheet often becomes more reliable when IRR is read alongside NPV or MIRR rather than in isolation.

• Use IRR for periodic cash flows listed in time order.
• Include both negative and positive values in the series.
• Check NPV or MIRR when the project decision is material or the cash-flow pattern is unusual.

Example 1 - Basic Cash Flow IRR

This is the standard one-outflow, several-inflow pattern that IRR handles well. The result is the periodic return rate implied by that exact sequence of cash flows.

=IRR({-10000,2000,4000,5000,6000})

Example 2 - Slower Recovery Audit

Here the inflows are spread more evenly and over a longer recovery pattern. Even when the total cash received is not weak, later recovery usually lowers the implied rate because more value is delayed into future periods.

=IRR({-10000,2000,2000,2000,2000,2000,2000})

Example 3 - Profitability Threshold Check

Comparing IRR directly with a hurdle rate turns the output into a quick screening rule. This is useful when a worksheet needs a clear pass-or-fail test before deeper valuation work begins.

=IRR({-10000,2000,4000,5000,6000})>0.1

Example 4 - IRR-NPV Neutrality Check

Because IRR is the rate that makes net present value equal to zero, NPV can be used as a consistency check. In this example the future flows are discounted at the solved IRR and then compared with the initial $10,000 outflow. The result should be close to zero apart from rounding effects.

=NPV(IRR({-10000,2000,4000,5000,6000}),{2000,4000,5000,6000})-10000

Conclusion Recap

• Summary: IRR solves the periodic return rate implied by a cash-flow series.
• Syntax: =IRR(values,[guess]).
• Core setup: Use chronological periodic cash flows with at least one negative and one positive value.
• Best use: Project screening, hurdle-rate comparison, and rate-based review alongside NPV.