Internal Rate Of Return: Formula, Meaning & Example

Internal rate of return is the discount rate that makes the net present value of an investment’s cash flows equal to zero. It converts a stream of cash inflows and outflows occurring over time into an annualized percentage return, making it useful for evaluating projects, investments, acquisitions, and other capital-allocation decisions.
If an investment has an internal rate of return of 12%, the 12% is the discount rate at which the present value of the expected inflows exactly equals the present value of the expected outflows.
Unlike a simple profit calculation, internal rate of return incorporates the timing of cash flows. Receiving $100,000 next year is economically different from receiving the same $100,000 five years from now.
Within business finance, internal rate of return is therefore closely connected to discounted cash-flow analysis, especially net present value, but the two metrics express the result differently.
What Is Internal Rate of Return?
Internal rate of return, commonly abbreviated IRR, is the rate at which an investment’s net present value becomes zero.
In mathematical terms, IRR solves this relationship:
0 = CF₀ + CF₁ ÷ (1 + IRR)¹ + CF₂ ÷ (1 + IRR)² + … + CFₙ ÷ (1 + IRR)ⁿ
Where:
CF₀ is usually the initial investment and is commonly negative.
CF₁ through CFₙ are subsequent cash inflows or outflows.
n represents the number of periods.
The separate IRR page owns the acronym-focused query, while this article focuses on the complete internal rate of return concept, formula mechanics, calculation process, interpretation, and analytical limitations.
Internal Rate of Return Formula
Unlike many financial ratios, internal rate of return usually cannot be calculated by simply substituting values into a formula and solving with basic arithmetic.
The general equation is:
NPV = Σ [CFₜ ÷ (1 + r)ᵗ] = 0
At the internal rate of return:
r = IRR
Therefore:
0 = Σ [CFₜ ÷ (1 + IRR)ᵗ]
The purpose is to find the rate that makes the discounted value of all cash flows sum to zero.
For investments with several cash flows, this normally requires iteration, numerical methods, or financial software.
Why Does IRR Set NPV Equal to Zero?
NPV discounts future cash flows using a chosen required return.
If the selected discount rate is below an investment’s IRR, a conventional investment will generally have positive NPV.
If the selected discount rate is above its IRR, the NPV will generally be negative.
At exactly the IRR:
NPV = $0
That point represents the discount rate at which the present value of inflows equals the present value of outflows.
For a conventional project with one initial outflow followed by positive inflows, this creates a useful relationship between IRR and the project’s required return.
Simple Internal Rate of Return Example
Consider an investment requiring $100,000 today and returning $121,000 exactly two years later.
The equation is:
$100,000 = $121,000 ÷ (1 + IRR)²
Rearrange:
(1 + IRR)² = $121,000 ÷ $100,000
(1 + IRR)² = 1.21
Take the square root:
1 + IRR = 1.10
Therefore:
IRR = 10%
The investment’s internal rate of return is 10% per year.
This simple case can be solved directly because there is only one initial outflow and one later inflow.
How to Calculate Internal Rate of Return With Multiple Cash Flows
Suppose a project requires an initial investment of $100,000 and is expected to generate:
Year 0: −$100,000
Year 1: $30,000
Year 2: $40,000
Year 3: $50,000
The IRR equation is:
0 = −$100,000 + $30,000 ÷ (1 + IRR) + $40,000 ÷ (1 + IRR)² + $50,000 ÷ (1 + IRR)³
There is no convenient basic arithmetic step that isolates IRR.
Instead, different discount rates can be tested.
At 8%:
NPV ≈ $1,763
Because NPV is positive, the discount rate is still below the project’s IRR.
At 9%:
NPV ≈ −$201
Because NPV is slightly negative, the IRR lies just below 9%.
Solving more precisely gives:
IRR ≈ 8.90%
The project’s internal rate of return is therefore approximately 8.9%.
How to Interpret Internal Rate of Return
IRR is usually interpreted relative to a required return, hurdle rate, or cost-of-capital benchmark.
Suppose a project’s IRR is 14%.
If the company requires a 10% return for projects with comparable risk, the project clears that benchmark.
If the required return is 16%, the project does not.
The simplified decision relationship is:
IRR > Required Return → Project may meet the return requirement
IRR = Required Return → NPV is approximately zero
IRR < Required Return → Project does not meet the required return
This interpretation works best for conventional, independent projects. More complex situations require additional analysis because IRR alone can produce misleading rankings.
IRR and the Cost of Capital
A company may compare project IRR with its required return or a relevant capital-cost benchmark.
For corporate investment analysis, the weighted average cost of capital can sometimes serve as a starting reference when the project’s risk and financing assumptions are compatible with the firm’s broader capital structure.
Suppose:
Project IRR = 13%
Relevant hurdle rate = 9%
The project offers a four-percentage-point spread above the benchmark.
However, that does not mean the investment automatically should be accepted. The forecast may carry substantial uncertainty, the project may have alternative uses for capital, and a competing project may create more absolute economic value.
Internal Rate of Return vs Net Present Value
IRR and NPV use the same underlying discounted cash flows but present the answer differently.
IRR produces a percentage return.
NPV produces a monetary value at a specified discount rate.
Suppose two projects require the same capital.
Project A has:
IRR = 18%
NPV = $50,000
Project B has:
IRR = 14%
NPV = $200,000
If the projects are mutually exclusive and the relevant discount rate makes both acceptable, selecting the project solely because it has the higher IRR could sacrifice substantial value.
That is one reason NPV is often more informative for ranking mutually exclusive investments where project scale, timing, or cash-flow patterns differ.
IRR answers:
What discount rate makes this investment’s NPV zero?
NPV answers:
How much value does this investment create at the selected required return?
Internal Rate of Return vs ROI
Internal rate of return differs substantially from return on investment.
A simple ROI calculation typically compares gain with investment:
ROI = Investment Gain ÷ Investment Cost × 100
IRR incorporates the timing of multiple cash flows.
Suppose two investments each produce a 30% total gain. One produces that gain in two years, while the other requires seven years.
A simple total ROI could be identical even though the annualized economics are very different.
IRR captures that timing difference because future cash flows are discounted according to when they occur.
Internal Rate of Return vs Payback Period
The payback period asks how long it takes to recover the initial investment.
IRR asks what annualized discount rate makes the complete cash-flow stream worth zero in NPV terms.
Consider two projects that both recover their initial cost within three years.
One may continue producing substantial cash flows for another decade, while the other may generate almost nothing after payback.
Their payback periods may look similar even though their IRRs and NPVs are substantially different.
Payback emphasizes capital recovery speed. IRR incorporates a wider cash-flow stream and the time value of money.
Internal Rate of Return vs Profitability Index
The profitability index compares the present value of future cash flows with the required investment.
A common form is:
Profitability Index = Present Value of Future Cash Flows ÷ Initial Investment
A profitability index above 1 generally corresponds to positive NPV under the chosen discount rate.
IRR instead solves for the rate that causes NPV to equal zero.
Both can help evaluate capital projects, but they answer different questions and can produce different rankings when projects vary in scale.
Internal Rate of Return and Free Cash Flow
A project-level IRR requires an appropriate cash-flow stream.
At the company level, free cash flow measures cash remaining after operating and capital-investment requirements under the applicable definition.
For project analysis, analysts instead construct cash flows specifically attributable to the project or investment being evaluated.
Mixing company-level free cash flow with project-level IRR without defining the scope can produce a meaningless result.
The cash flows must match the economic asset or investment for which the return is being calculated.
How Cash Flow Timing Affects IRR
IRR is sensitive not only to how much cash an investment generates but also to when the cash arrives.
Consider two projects with the same total undiscounted cash inflows.
Project A generates most of its cash early.
Project B generates most of its cash near the end of its life.
All else equal, Project A will often produce a higher IRR because earlier cash flows have greater present value.
This is why reliable cash flow forecasting is critical when using IRR for prospective investment decisions.
Small changes in expected timing can materially alter the calculated return.
Internal Rate of Return and Business Valuation
IRR is not the same as business valuation.
Valuation estimates what an asset, company, or investment is worth under a chosen methodology.
IRR calculates the return implied by an investment price and its expected future cash flows.
For example, if an investor pays $5 million for a business and forecasts future distributions plus an eventual sale, those cash flows can be used to calculate the investment’s implied IRR.
If the purchase price rises while the future cash flows remain unchanged, IRR generally falls.
If the purchase price falls, IRR generally rises.
Price and expected return are therefore directly connected.
Internal Rate of Return and Startup Valuation
The same principle can apply when evaluating a startup valuation.
Suppose an investor contributes $1 million today and expects the investment to be worth $4 million five years later, with no intermediate distributions.
The simplified return is:
IRR = ($4,000,000 ÷ $1,000,000)^(1/5) − 1
IRR ≈ 31.95%
That does not mean the investor is guaranteed to earn 31.95%.
It means that if the assumed $4 million exit value is actually realized after five years, the implied annualized compound return on those two cash flows would be approximately 31.95%.
Startup outcomes are uncertain, so IRR forecasts are only as reliable as the assumptions behind the future cash flows and exit value.
Internal Rate of Return for Rental Property
IRR can also be applied to real-estate investments.
A rental property returns analysis may include the initial equity investment, annual net cash flows, additional capital expenditures, and eventual sale proceeds.
For example:
Initial investment: −$200,000
Year 1 cash flow: $15,000
Year 2 cash flow: $17,000
Year 3 cash flow: $18,000
Year 4 cash flow plus sale proceeds: $260,000
IRR combines the timing and amount of all those flows into one annualized percentage.
This provides a different perspective from cap rate, cash-on-cash return, or simple appreciation.
Internal Rate of Return and Operating Cash Flow
Operating cash flow describes cash generated from a company’s operating activities.
IRR instead evaluates a defined series of investment cash flows.
Operating cash flow might contribute to a project or company valuation, but it should not automatically be inserted into an IRR calculation without considering capital expenditures, acquisition costs, working-capital changes, disposal proceeds, and the analytical scope.
The relevant cash-flow definition should be established before calculating a return.
Internal Rate of Return and Return on Invested Capital
Return on invested capital measures operating performance relative to capital invested in a business.
IRR is different because it is a cash-flow-based, time-sensitive investment return.
ROIC may be calculated for a company’s current operating performance using accounting measures. IRR usually examines a series of cash flows across an investment horizon.
A company may report strong ROIC while a particular acquisition produces a poor IRR because the acquisition price was too high.
Conversely, a temporary accounting return can look modest even while a long-duration investment produces an attractive projected IRR.
Internal Rate of Return and Economic Value Added
Economic value added evaluates whether operating performance exceeds an economic charge for the capital employed.
IRR evaluates the discount rate implied by a project’s cash flows.
Both concepts recognize that capital has an opportunity cost, but they approach that issue differently.
IRR is primarily an investment-evaluation metric. Economic value added is more closely associated with measuring economic profit after a capital charge.
Internal Rate of Return and Interest Coverage
The workbook maps interest coverage as a neighboring analytical concept, but the two metrics should remain distinct.
Interest coverage compares earnings with interest expense.
IRR evaluates the annualized return implied by an investment’s cash flows.
A highly leveraged investment can potentially show a high equity IRR while carrying weak interest coverage. That combination may indicate attractive modeled equity returns alongside meaningful financing risk.
Return and debt-service capacity therefore need separate analysis.
Internal Rate of Return and Inventory Turnover
Inventory turnover measures how efficiently inventory moves through a business.
It is not part of the IRR formula.
However, operational assumptions can influence projected investment cash flows. For example, a project requiring substantial inventory investment may need more working capital and therefore produce lower free cash flows than a simple earnings forecast suggests.
Operational ratios can consequently influence the cash-flow assumptions behind IRR without becoming part of the return formula itself.
Internal Rate of Return and Gross Profit
Gross profit measures revenue remaining after cost of goods sold.
IRR measures return across the timing of investment cash flows.
High gross profit does not automatically produce a high project IRR. A business may require an expensive initial investment, substantial working capital, large ongoing capital expenditures, or a high acquisition price.
IRR depends on the full cash-flow pattern, not merely one profitability subtotal.
Internal Rate of Return and Gross Margin
Likewise, a strong gross margin can improve project economics but does not determine IRR by itself.
Two companies with identical gross margins can produce different internal rates of return because their initial investment, growth, operating expenses, capital intensity, timing of cash flows, and terminal values differ.
Margin analysis and investment-return analysis therefore solve different problems.
Conventional and Non-Conventional Cash Flows
IRR behaves most cleanly when the project has conventional cash flows: an initial negative investment followed by positive cash inflows.
For example:
−$100,000, +$30,000, +$40,000, +$50,000
The cash-flow sign changes once, from negative to positive.
A non-conventional project might look like:
−$100,000, +$250,000, −$180,000
Here the signs change more than once.
That matters because an IRR equation can potentially have multiple solutions when cash-flow signs change repeatedly.
Multiple IRRs
One of the most important limitations of internal rate of return is the possibility of multiple mathematically valid IRRs.
Consider a project that requires an initial investment, produces a large cash inflow, and then requires a substantial cleanup or decommissioning cost later.
The cash-flow pattern could change signs twice:
Negative → Positive → Negative
The NPV equation may then cross zero more than once.
As a result, the project might have two possible IRRs.
In such cases, asking “What is the IRR?” can be mathematically ambiguous.
NPV at an appropriate required return is generally more useful because it produces a value associated with a specified discount rate rather than searching for every rate at which NPV equals zero.
Can an Investment Have No IRR?
Yes.
Some cash-flow patterns produce no economically meaningful internal rate of return.
For example, if all cash flows are positive, there may be no discount rate that produces an NPV of zero.
Other unusual cash-flow patterns may also fail to produce a useful real-valued solution.
Therefore, IRR should not be assumed to exist for every investment.
Negative Internal Rate of Return
IRR can be negative.
Suppose an investor pays $100,000 today and receives only $90,000 one year later.
The equation is:
$100,000 = $90,000 ÷ (1 + IRR)
Solving:
IRR = −10%
A negative internal rate of return means the modeled cash flows imply an annualized loss rather than a positive return.
Negative IRR is economically meaningful when the cash-flow pattern permits a valid solution.
IRR for Unevenly Timed Cash Flows
The standard periodic IRR formula assumes cash flows occur at equally spaced intervals.
Real investments often have cash flows on irregular dates.
For example:
January 15: −$100,000
April 2: +$20,000
November 19: +$35,000
June 7 next year: +$70,000
A date-sensitive calculation is more appropriate in that situation.
Spreadsheet software commonly provides an XIRR function that uses the actual dates associated with each cash flow.
This distinction matters because assuming equal annual or monthly spacing when the dates are irregular can change the calculated return.
Why IRR Changes When the Initial Investment Changes
Assume two projects generate identical future cash flows.
Project A requires $500,000 initially.
Project B requires $700,000.
Because Project B requires more cash today for the same future benefits, its IRR will generally be lower.
The relationship reflects a basic investment principle: paying more for the same future cash flows reduces the implied return.
This is why acquisition price, project cost overruns, and changing capital requirements can materially affect projected IRR.
Why IRR Changes When Future Cash Flows Change
IRR rises when expected positive cash flows become larger or arrive earlier, assuming other factors remain constant.
It falls when inflows become smaller, arrive later, or additional future outflows are introduced.
This makes IRR highly sensitive to forecasting assumptions.
A model based on aggressive revenue growth, optimistic exit values, or underestimated capital spending may produce an attractive IRR that never materializes.
Therefore, scenario and sensitivity analysis are often more informative than presenting only one point estimate.
IRR Sensitivity Analysis
Suppose a project’s base-case IRR is 15%.
That number alone provides limited information.
A more useful analysis might calculate:
Downside-case IRR based on weaker sales.
Base-case IRR based on expected assumptions.
Upside-case IRR based on stronger performance.
The analyst can then identify which variables most strongly influence the return.
For example, a project’s IRR may be highly sensitive to exit value but relatively insensitive to small changes in operating costs.
That distinction is important because assumptions with the greatest effect deserve the greatest scrutiny.
IRR and Project Scale
A higher IRR does not necessarily mean a project creates more economic value.
Suppose:
Project A requires $10,000 and produces a 50% IRR.
Project B requires $10 million and produces a 20% IRR.
The smaller project’s percentage return is much higher, but the larger project may create far more absolute value.
This is one reason IRR should not be used alone to rank investments of substantially different sizes.
IRR and Project Duration
IRR is an annualized percentage, which helps compare investments with different holding periods.
However, duration still matters.
A short project producing a high IRR may offer limited opportunities to reinvest the returned capital at similarly attractive rates.
A longer project with a lower IRR may create more total value.
The percentage does not reveal the absolute dollars created or the availability of comparable reinvestment opportunities.
IRR and Reinvestment Assumptions
One criticism of traditional IRR-based project ranking concerns the implied reinvestment economics of intermediate cash flows.
When comparing projects, IRR can effectively favor investments whose interim cash flows would need to be reinvested at relatively high rates to sustain the same compound-return interpretation.
That assumption may be unrealistic when a project’s IRR is exceptionally high.
Modified or adjusted return methods can address reinvestment assumptions explicitly, but they constitute different calculations and should not be labeled as ordinary IRR.
IRR and Leverage
Debt can materially change equity IRR.
Suppose an asset is purchased partly with debt rather than entirely with investor equity.
Because less equity is required initially, favorable operating results and sale proceeds can produce a higher percentage return on the equity invested.
However, leverage also adds interest expense, repayment obligations, refinancing risk, and greater sensitivity to disappointing cash flows.
A higher leveraged IRR does not necessarily mean the underlying asset became more productive. Part of the higher projected equity return may simply reflect greater financial risk.
IRR and Terminal Value
Long-term IRR calculations often include a terminal or exit value.
If a large percentage of the total investment value comes from an assumed sale price many years in the future, IRR can become highly sensitive to that estimate.
Analysts should therefore distinguish between returns generated by recurring cash flows and returns dependent primarily on an assumed exit.
A modest change in the exit multiple or terminal valuation can materially change projected IRR.
Gross IRR vs Net IRR
Investment funds and other investment structures may report both gross and net IRR.
Gross IRR generally reflects investment performance before some investor-level fees, carried interest, or expenses, depending on the stated methodology.
Net IRR reflects the return after specified fees, expenses, and other deductions borne by investors.
The exact methodology matters.
Two figures labeled “net IRR” are not necessarily comparable unless the underlying cash-flow treatment, fees, timing assumptions, and valuation policies are consistent.
Common Internal Rate of Return Mistakes
One common mistake is treating IRR as a guaranteed return. It is not. A projected IRR depends on projected cash flows, and actual results can differ substantially.
Another mistake is automatically accepting whichever project has the highest IRR. Project size, timing, NPV, risk, capital constraints, and strategic considerations can change the decision.
Users can also overlook multiple IRRs when cash flows switch signs more than once.
Irregular cash-flow dates create another problem when a periodic IRR formula is used instead of a date-sensitive calculation.
Finally, forecasts sometimes place too much weight on a terminal value. A high modeled IRR based mainly on an optimistic exit assumption deserves more scrutiny than the percentage alone suggests.
Limitations of Internal Rate of Return
IRR is useful, but several limitations prevent it from serving as a complete investment-decision rule.
It can produce multiple solutions for non-conventional cash flows.
Some investments may have no useful IRR.
It can rank mutually exclusive projects differently from NPV.
It expresses return as a percentage and therefore does not reveal how much absolute value is created.
Projected IRR can be highly sensitive to cash-flow timing, terminal-value assumptions, leverage, and forecast accuracy.
Different treatment of fees and expenses can make reported investment IRRs difficult to compare.
IRR should therefore be used as one analytical tool rather than a substitute for full investment analysis.
When Internal Rate of Return Is Most Useful
Internal rate of return works particularly well when a project has a clear initial investment followed by a reasonably conventional sequence of expected future cash flows.
It can help compare a project’s implied return with a required return, examine how investment price affects return, compare scenarios, and communicate a time-adjusted percentage return.
For decisions involving materially different project sizes, unusual cash-flow patterns, or mutually exclusive alternatives, IRR becomes more useful when evaluated alongside NPV and other capital-budgeting measures.
Why Internal Rate of Return Matters
Internal rate of return answers a practical investment question:
What annualized discount rate is implied by these cash flows?
Its defining equation is:
0 = Σ [CFₜ ÷ (1 + IRR)ᵗ]
That relationship incorporates both the amount and timing of an investment’s cash flows.
However, IRR should not be interpreted as guaranteed performance, cash yield, accounting profit, or absolute value creation.
It is most informative when the cash-flow forecast is credible, the calculation method is clearly defined, and the result is considered alongside NPV, project risk, scale, financing, and alternative uses of capital.
Frequently Asked Questions
What is internal rate of return in simple terms?
Internal rate of return is the annualized discount rate that makes the present value of an investment’s future cash flows equal to the amount invested, producing an NPV of zero.
What is the internal rate of return formula?
IRR solves the equation:
0 = CF₀ + CF₁ ÷ (1 + IRR)¹ + CF₂ ÷ (1 + IRR)² + … + CFₙ ÷ (1 + IRR)ⁿ
For multiple cash flows, numerical calculation is usually required.
What does a 15% IRR mean?
A 15% IRR means 15% is the discount rate at which the investment’s modeled cash flows have an NPV of zero.
It does not guarantee that the investor will actually earn 15%.
Is a higher internal rate of return better?
A higher IRR generally indicates a higher modeled percentage return, but it does not automatically identify the better investment. Project size, NPV, risk, duration, financing, and forecast reliability also matter.
What is considered a good IRR?
There is no universal good IRR. The relevant benchmark depends on investment risk, required return, cost of capital, available alternatives, project duration, and other circumstances.
What is the difference between IRR and NPV?
IRR expresses the discount rate that makes NPV zero. NPV expresses the dollar value created or destroyed at a specified discount rate.
IRR is a percentage; NPV is a monetary amount.
Can IRR be negative?
Yes. A negative IRR can occur when the investment’s cash flows imply an annualized loss.
For example, paying $100 today and receiving only $90 one year later produces an IRR of −10%.
Can a project have more than one IRR?
Yes. Multiple IRRs can occur when cash flows change signs more than once, such as an initial investment followed by positive cash flows and then a substantial later outflow.
Can a project have no IRR?
Yes. Certain cash-flow patterns have no discount rate that makes NPV equal to zero, so no economically meaningful IRR exists.
Why is IRR difficult to calculate manually?
With multiple cash flows, IRR appears inside several exponential discounting terms. The rate therefore usually has to be found through iteration or numerical methods rather than ordinary algebra.
What is the difference between IRR and XIRR?
Standard IRR generally assumes equally spaced cash-flow periods. XIRR uses actual cash-flow dates, making it more suitable when investments and distributions occur at irregular intervals.
Should I use IRR or ROI?
Use IRR when timing and multiple investment cash flows matter. Simple ROI is easier when you only need a basic gain-versus-cost percentage. For substantial capital decisions, IRR is commonly considered alongside NPV and other measures rather than used alone.



