Internal Rate of Return (IRR) Calculator
IRR based on fixed cash flow
This calculator computes the IRR based on a fixed recurring cash flow or no cash flow.
IRR based on irregular cash flow
This calculator computes the IRR based on the initial investment and subsequent annual cash flows. If you want to calculate the IRR for cash flows that are not annual, please use our Average Return Calculator.
What Is the IRR Calculator and Why It Matters
An IRR calculator computes the Internal Rate of Return—the discount rate at which the net present value (NPV) of all cash flows from an investment equals zero. In simpler terms, IRR represents the annualized effective rate of return that an investment is expected to generate, accounting for the timing and magnitude of all cash inflows and outflows.
Unlike simple return calculations that ignore the time value of money, IRR provides a single percentage that captures the profitability of an investment with irregular cash flows occurring at different points in time. This makes it possible to compare investments with different cash flow patterns, durations, and scales on an equal basis.
IRR is one of the most widely used metrics in corporate finance, venture capital, real estate investment, and project evaluation. A project is generally considered worthwhile if its IRR exceeds the organization's cost of capital or hurdle rate. The higher the IRR above this threshold, the more attractive the investment.
The calculator is essential because IRR cannot be solved algebraically for most real-world cash flow patterns—it requires iterative numerical methods. Without a calculator, determining IRR from a series of cash flows would require trial-and-error guessing or specialized mathematical techniques.
How to Accurately Use the IRR Calculator for Precise Results
- Step 1: List all cash flows in chronological order. The initial investment is typically a negative value (money going out). Subsequent cash inflows are positive values.
- Step 2: Ensure consistent time periods. Cash flows must be evenly spaced (annual, quarterly, monthly). If cash flows occur at irregular intervals, use XIRR (Extended Internal Rate of Return) instead of standard IRR.
- Step 3: Include the terminal cash flow. This is the final cash flow—whether it is the last operating income, the sale proceeds of an asset, or a liquidation value. Omitting it will significantly understate the IRR.
- Step 4: Enter the values into the calculator. Input each cash flow in order. The calculator will iterate to find the rate that sets NPV to zero.
- Step 5: Interpret the result. Compare the IRR to your required rate of return (hurdle rate). If IRR > hurdle rate, the investment creates value. If IRR < hurdle rate, the investment destroys value relative to alternative uses of capital.
Tips for accuracy: Be aware that IRR assumes reinvestment of interim cash flows at the IRR itself, which may be unrealistic for very high IRRs. For a more conservative analysis, use the Modified Internal Rate of Return (MIRR), which assumes reinvestment at the cost of capital.
Real-World Scenarios & Practical Applications
Scenario 1: Real Estate Investment Analysis
An investor purchases a rental property for $250,000 (Year 0: −$250,000). Annual net rental income after expenses is $22,000 for 7 years. In Year 7, the property is sold for $310,000. Cash flows: −250,000; 22,000; 22,000; 22,000; 22,000; 22,000; 22,000; 332,000. The IRR calculator determines a rate of approximately 11.8%, which exceeds the investor's 8% hurdle rate, making the investment attractive.
Scenario 2: Capital Expenditure Decision
A manufacturing company evaluates a $500,000 equipment purchase that is expected to generate $120,000 in annual cost savings for 6 years with a $50,000 salvage value. Cash flows: −500,000; 120,000; 120,000; 120,000; 120,000; 120,000; 170,000. The IRR is approximately 12.4%. With a cost of capital of 10%, the project clears the hurdle and receives approval.
Scenario 3: Venture Capital Fund Return
A VC fund invests $2 million in a startup (Year 0). Additional follow-on investments of $500,000 in Year 2 and $1 million in Year 3 are made. The fund exits in Year 6 with $12 million. Cash flows: −2,000,000; 0; −500,000; −1,000,000; 0; 0; 12,000,000. The IRR is approximately 32.7%, reflecting the high-risk, high-return nature of venture investing.
Who Benefits Most from the IRR Calculator
- Corporate finance managers: Evaluating capital expenditure proposals and ranking competing projects by return potential.
- Real estate investors: Comparing property investments with different holding periods, cash flow patterns, and exit values.
- Private equity and venture capital professionals: Measuring fund performance and communicating returns to limited partners.
- Project managers: Justifying project budgets by demonstrating expected returns exceed the organization's cost of capital.
- MBA students and financial analysts: Mastering one of the fundamental tools of investment analysis and corporate decision-making.
Technical Principles & Mathematical Formulas
IRR is the rate r that satisfies:
NPV = Σ [CF_t / (1 + r)^t] = 0
Where:
- CF_t = cash flow at time period t
- r = internal rate of return (the unknown)
- t = time period (0, 1, 2, ..., n)
Expanded: CF_0 + CF_1/(1+r) + CF_2/(1+r)² + ... + CF_n/(1+r)^n = 0
This polynomial equation has no closed-form solution for n > 4, so calculators use iterative methods such as the Newton-Raphson algorithm or the bisection method to converge on the solution.
Modified Internal Rate of Return (MIRR) addresses the reinvestment assumption:
MIRR = (Terminal Value of Positive CFs / PV of Negative CFs)^(1/n) − 1
Where positive cash flows are compounded forward at the reinvestment rate and negative cash flows are discounted back at the finance rate.
XIRR (for irregular cash flows) solves the same NPV = 0 equation but uses actual dates rather than equal period spacing, adjusting the exponents based on the fractional year between each cash flow and the first cash flow.
Frequently Asked Questions
Can a project have multiple IRRs?
Yes. If cash flows change sign more than once (e.g., negative, positive, negative, positive), the polynomial may have multiple real roots, each representing a valid IRR. In these cases, MIRR or NPV analysis is more reliable than standard IRR.
What is a good IRR?
A "good" IRR depends on the context. In corporate finance, any IRR above the company's weighted average cost of capital (WACC) adds value. In venture capital, target IRRs may be 25–35%. In real estate, 8–15% is common. The appropriate benchmark varies by industry, risk, and investment horizon.
What are the limitations of IRR?
IRR assumes reinvestment of cash flows at the IRR itself, which may be unrealistic. It does not account for investment scale (a 50% IRR on $1,000 is less valuable than a 20% IRR on $1,000,000). It also does not account for risk—two projects with the same IRR may have very different risk profiles.
How does IRR differ from ROI?
ROI (Return on Investment) measures total return as a percentage of the initial investment without considering timing. IRR accounts for the timing of each cash flow, making it more appropriate for multi-period investments. A project with early returns will have a higher IRR than one with the same total return delivered later.
When should I use XIRR instead of IRR?
Use XIRR when cash flows do not occur at regular intervals. For example, an investment with deposits on January 15, March 22, and a return on November 3 requires XIRR because standard IRR assumes equally spaced periods.