Internal Rate of Return (IRR) Calculator
Calculate the Internal Rate of Return (IRR) for a series of cash flows. Evaluate project profitability and compare investment alternatives.
Calculator
Adjust values & calculateNPV at Different Discount Rates
Cash Flow Summary
Formula
IRR is the discount rate that makes the sum of all discounted cash flows equal to zero. CF0 is the initial investment (negative), and CF1 through CFn are the future cash flows. The equation is solved numerically using the bisection method.
Last reviewed: January 2026
Worked Examples
Example 1: Business Equipment Investment
Example 2: Real Estate Investment
Background & Theory
The IRR Calculator — Internal Rate of Return applies the following established principles and formulas. Finance and investing rest on the foundational concept of the time value of money: a dollar received today is worth more than a dollar received in the future, because present funds can be deployed to earn a return. This principle underlies virtually every valuation technique in modern finance. The future value of a present sum P growing at rate r over n periods is expressed as FV = P(1 + r)^n, while the present value of a future cash flow FV is PV = FV / (1 + r)^n. Compound growth amplifies returns significantly over long horizons, a dynamic often described as the eighth wonder of the world. Net Present Value (NPV) extends these mechanics to evaluate investment projects by summing the present values of all expected cash flows minus the initial outlay: NPV = sum[CF_t / (1 + r)^t] - C_0. A positive NPV indicates the project creates value above the required return. The Internal Rate of Return (IRR) is the discount rate that sets NPV to zero, providing a single percentage benchmark for project comparison. The risk-return tradeoff is the central tension of investment theory. Higher expected returns generally require accepting greater uncertainty. Harry Markowitz formalized this in Modern Portfolio Theory by demonstrating that portfolio variance can be reduced through diversification when assets are imperfectly correlated. The efficient frontier represents the set of portfolios offering the maximum return for a given level of risk. The Capital Asset Pricing Model (CAPM) extends this by introducing the market portfolio as a reference, defining expected return as E(r) = r_f + beta * (E(r_m) - r_f), where beta measures an asset's sensitivity to systematic market risk. Asset classes — equities, fixed income, real assets, and alternatives — differ in their return profiles, liquidity, and correlations. Strategic asset allocation determines long-run target weights based on investor objectives and risk tolerance, while tactical allocation permits short-run deviations to exploit perceived mispricings. Discount rates used in valuation models must reflect the cost of capital appropriate to the risk of the cash flows being discounted, a point stressed in corporate finance texts from Brealey, Myers, and Allen through to Damodaran.
History
The history behind the IRR Calculator — Internal Rate of Return traces back through the following developments. The formal practice of lending at interest dates to ancient Mesopotamia, where the Code of Hammurabi around 1750 BCE regulated interest rates on grain and silver loans. Banking as an institutional activity took root in medieval Italy, with merchant bankers in Florence and Venice financing trade across Europe through instruments such as bills of exchange. The Medici family operated one of the most sophisticated banking networks of the fifteenth century, pioneering double-entry bookkeeping and correspondent banking relationships. Organized equity markets emerged in the early seventeenth century. The Dutch East India Company (VOC), chartered in 1602, issued shares to the public and created the Amsterdam Stock Exchange — widely regarded as the world's first formal stock exchange. The VOC allowed investors to buy and sell shares freely, establishing the template for the joint-stock company. The period also produced the Dutch tulip mania of 1636 to 1637, one of history's first recorded speculative bubbles, in which tulip bulb futures contracts reached extraordinary prices before collapsing. England's financial revolution followed in the late seventeenth century with the founding of the Bank of England in 1694 and the development of government bond markets. The South Sea Bubble of 1720 illustrated the dangers of speculative excess and contributed to early securities regulation. Throughout the eighteenth and nineteenth centuries, industrialization created enormous demand for capital, fueling the expansion of stock exchanges in London, Paris, New York, and beyond. The New York Stock Exchange, formalized in 1817, became the world's dominant equities market by the twentieth century. The Great Crash of 1929 and subsequent Great Depression prompted the US Securities Act of 1933 and Securities Exchange Act of 1934, establishing the SEC and mandatory disclosure requirements. Harry Markowitz published his landmark portfolio selection paper in 1952, launching quantitative finance. The CAPM emerged in the 1960s through work by Sharpe, Lintner, and Mossin. John Bogle launched the first retail index fund in 1976, democratizing diversified investing and challenging active management orthodoxy.
Frequently Asked Questions
Formula
0 = CF0 + CF1/(1+IRR) + CF2/(1+IRR)^2 + ... + CFn/(1+IRR)^n
IRR is the discount rate that makes the sum of all discounted cash flows equal to zero. CF0 is the initial investment (negative), and CF1 through CFn are the future cash flows. The equation is solved numerically using the bisection method.
Worked Examples
Example 1: Business Equipment Investment
Problem: A company invests $100,000 in equipment and expects cash flows of $25,000, $30,000, $35,000, $40,000, and $45,000 over 5 years. What is the IRR?
Solution: Cash flows: -$100,000, +$25,000, +$30,000, +$35,000, +$40,000, +$45,000\nTotal cash in: $175,000\nNet profit: $175,000 - $100,000 = $75,000\nROI: 75%\nUsing bisection method to find rate where NPV = 0:\nIRR = approximately 17.44%\nThis exceeds typical cost of capital (8-12%), so the investment is worthwhile.
Result: IRR: 17.44% | Net Profit: $75,000 | ROI: 75% | Payback: ~3.3 years
Example 2: Real Estate Investment
Problem: Purchase a rental property for $200,000. Annual net cash flows of $18,000 for 7 years, then sell for $250,000 in year 7 (total year 7 cash flow: $268,000).
Solution: Cash flows: -$200,000, $18K, $18K, $18K, $18K, $18K, $18K, $268K\nTotal cash in: $18,000 x 6 + $268,000 = $376,000\nNet profit: $376,000 - $200,000 = $176,000\nUsing numerical methods:\nIRR = approximately 14.8%\nThis represents good returns for a stabilized rental property.
Result: IRR: ~14.8% | Net Profit: $176,000 | ROI: 88% | Strong risk-adjusted return
Frequently Asked Questions
What is the Internal Rate of Return (IRR) and why is it important?
The Internal Rate of Return (IRR) is the discount rate that makes the net present value (NPV) of all cash flows from an investment equal to zero. In simpler terms, it represents the annualized effective compounded return rate that an investment is expected to generate. IRR is important because it provides a single percentage figure that allows you to compare the profitability of different investments regardless of their size, timing, or duration. A higher IRR indicates a more profitable investment. For example, an investment with a 15% IRR is expected to grow at 15% annually on the capital that remains invested. Business managers and investors use IRR as a primary tool for capital budgeting decisions and investment evaluation.
How is IRR different from ROI (Return on Investment)?
IRR and ROI both measure investment profitability but differ in crucial ways. ROI is a simple calculation: (Total Gain - Total Cost) / Total Cost, expressed as a percentage. It does not consider the time value of money or when cash flows occur. For example, earning $50,000 on a $100,000 investment yields a 50% ROI whether it takes 2 years or 10 years. IRR accounts for the timing of each cash flow, providing an annualized return rate that factors in the time value of money. An investment returning $50,000 over 2 years has a much higher IRR than one returning the same amount over 10 years. This makes IRR more accurate for comparing investments with different timelines and cash flow patterns, though ROI remains useful for quick comparisons.
What is a good IRR for an investment?
What constitutes a good IRR depends heavily on the investment type, risk level, and available alternatives. As a general benchmark, any IRR above the investor cost of capital (typically 8-12% for most companies) adds value. For venture capital and private equity investments, investors typically target IRRs of 20-30% or higher to compensate for high risk and illiquidity. Real estate investments often target 12-20% IRR depending on the strategy and risk profile. Corporate capital budgeting projects usually require IRRs above the company weighted average cost of capital (WACC), typically 8-15%. For comparison, the S&P 500 stock market index has delivered approximately 10% average annual returns historically. An IRR should always be evaluated relative to the risk involved and alternative investment opportunities.
What are the limitations of using IRR for investment decisions?
IRR has several important limitations that investors should understand. First, it assumes all interim cash flows are reinvested at the IRR itself, which may not be realistic for high-IRR projects. The Modified IRR (MIRR) addresses this by using a more realistic reinvestment rate. Second, IRR can produce multiple solutions when cash flows alternate between positive and negative (non-conventional cash flows). Third, IRR does not account for the scale of investment, so a small project with 50% IRR might add less total value than a large project with 15% IRR. Fourth, IRR does not directly tell you the total dollar value created; NPV is better for that purpose. Finally, IRR assumes a flat yield curve and constant discount rate, which may not reflect reality. For these reasons, experienced analysts use IRR alongside NPV and other metrics.
How do I calculate IRR manually and what method does Internal Rate of Return (IRR) Calculator use?
IRR cannot be solved with a simple algebraic formula because it requires finding the root of a polynomial equation. Manual calculation typically uses trial and error or interpolation between two discount rates. You find one rate where NPV is slightly positive and another where NPV is slightly negative, then interpolate linearly between them. Internal Rate of Return (IRR) Calculator uses the bisection method, a numerical algorithm that repeatedly narrows the search range by testing the midpoint. Starting with a wide range from negative 99% to 1000%, it calculates NPV at the midpoint and determines whether the answer lies in the upper or lower half. This process repeats until the NPV is within $0.01 of zero, typically requiring 50 to 100 iterations. Spreadsheet programs like Excel use the Newton-Raphson method, which converges faster but requires an initial guess.
What is the relationship between IRR and NPV?
IRR and NPV are closely related but answer different questions about an investment. NPV tells you the total dollar value created by an investment at a given discount rate, while IRR tells you the rate of return at which the investment breaks even in present value terms. When IRR exceeds your required rate of return (hurdle rate), the NPV will be positive, meaning the investment creates value. When IRR equals the hurdle rate, NPV is zero. When IRR is below the hurdle rate, NPV is negative. For mutually exclusive projects (where you can only choose one), NPV is generally preferred because it accounts for project scale and correctly identifies which project adds the most total value. For independent projects (accept or reject decisions), IRR and NPV always give the same accept/reject answer.
References
Reviewed by Sahil, Senior Finance & Tax Editor · Editorial policy