IRR Calculator
Free IRR Calculator for investment analysis. Calculate Internal Rate of Return from cash flows to evaluate investment opportunities, compare projects, and make data-driven capital allocation decisions. Professional-grade financial analysis.
View all free toolsInputs
Results
How to interpret IRR:
- •IRR > Hurdle Rate: Investment meets return requirements
- •Profitability Index > 1: Project creates value
Complete Guide to IRR Analysis
Internal Rate of Return (IRR) is one of the most widely used metrics in finance for evaluating investment opportunities. This guide will help you understand IRR, calculate it correctly, and apply it to real-world investment decisions.
What is Internal Rate of Return (IRR)?
Internal Rate of Return is the discount rate at which the Net Present Value (NPV) of all cash flows from an investment equals zero. In simpler terms, it's the expected compound annual rate of return that an investment will generate.
IRR is particularly valuable because it allows you to compare investments of different sizes and durations on an equal footing. A project with a higher IRR is generally more desirable than one with a lower IRR, assuming similar risk profiles.
IRR Calculation Best Practices
1Set an Appropriate Hurdle Rate
Your hurdle rate should reflect your cost of capital and risk tolerance. For most corporate investments, use WACC. For private equity, hurdle rates of 8-12% are common, while venture capital may require 20%+ to account for high failure rates.
2Use Consistent Time Periods
Ensure all cash flows are measured at consistent intervals (annual, quarterly, monthly). IRR assumes reinvestment at the calculated rate, so timing accuracy is crucial for meaningful results.
3Include Terminal Value
For long-term investments, include a terminal or exit value in your final cash flow. This represents the value realized when selling the investment or the perpetual value of ongoing cash flows.
4Cross-Check with NPV
Always use IRR alongside NPV analysis. When IRR and NPV give conflicting signals, NPV is typically the more reliable measure since it directly quantifies value creation. Use our NPV Calculator for comprehensive analysis.
Common IRR Use Cases
Private Equity & LBO Analysis
PE firms use IRR to evaluate leveraged buyout opportunities and measure fund performance. Target IRRs typically range from 20-25% for control investments.
Explore LBO Model →M&A Deal Evaluation
Calculate the IRR of acquisition synergies and cash flows to determine if a deal creates value for shareholders. Compare deal IRR to cost of capital.
Use M&A Model →Real Estate Investment
Real estate investors use IRR to compare properties, accounting for rental income, appreciation, and exit proceeds. IRRs of 15-20% are common targets.
Check Real Estate Model →Venture Capital Returns
VCs evaluate portfolio company exits and overall fund performance using IRR. Target IRRs are typically 25-35% to compensate for high startup failure rates.
Try Venture Capital Model →IRR Interpretation Tips
Pro tip: Don't chase high IRRs blindly. Higher IRRs come with higher risk. Always consider the probability of achieving projected returns and the potential for capital loss.
IRR vs. Other Investment Metrics
IRR vs. NPV
While IRR tells you the percentage return, NPV tells you the absolute value created. Use NPV when comparing projects of different sizes. IRR is better for communicating returns to stakeholders and quick project screening.
IRR vs. MOIC (Multiple on Invested Capital)
MOIC shows how many times you've multiplied your money, but ignores timing. A 3x MOIC in 3 years is far better than 3x in 10 years. IRR captures this time dimension, making it essential for proper comparison.
Modified IRR (MIRR)
MIRR addresses IRR's reinvestment assumption by specifying separate rates for financing costs and reinvestment returns. Consider MIRR when cash flows are irregular or when the reinvestment rate differs significantly from IRR.
Industry Benchmarks
IRR expectations differ widely depending on the investment type, risk profile, and time horizon. Use the benchmarks below to evaluate whether your projected IRR aligns with market norms for comparable investments.
Need More Comprehensive Financial Models?
While this IRR calculator is perfect for quick investment evaluations, complex deals require comprehensive modeling. Explore our professional templates:
Alex Tapio
Founder of Finamodel - Professional Financial Modeller - Ex-Deloitte
Frequently asked questions
IRR is the discount rate that makes the Net Present Value (NPV) of all cash flows equal to zero. It represents the expected annual rate of return for an investment, accounting for the time value of money. If the IRR exceeds your required rate of return or cost of capital, the investment is generally considered acceptable.
While ROI (Return on Investment) provides a simple percentage return without considering time, IRR accounts for the timing of cash flows and the time value of money. IRR is expressed as an annualized rate, making it easier to compare investments with different durations and cash flow patterns.
A 'good' IRR depends on the type of investment and its risk profile. Generally, IRR should exceed your cost of capital or hurdle rate. For private equity, 20-25% is often targeted. Real estate investments typically aim for 15-20%. Venture capital may seek 25-35% or higher due to elevated risk.
Yes, IRR can be negative when the present value of cash outflows exceeds cash inflows, meaning the investment loses money. A negative IRR indicates that you would be better off not making the investment, as you'll receive less than you put in, even accounting for the time value of money.
IRR has several limitations: it assumes reinvestment at the IRR rate (often unrealistic), can produce multiple values for non-conventional cash flows, doesn't account for investment size, and may give misleading rankings when comparing mutually exclusive projects. Always use IRR alongside NPV and other metrics.
IRR is calculated through iteration - finding the discount rate where NPV equals zero. This typically requires trial and error or numerical methods like Newton-Raphson. Most financial calculators and spreadsheets use iterative algorithms to solve for IRR automatically, which is why tools like this calculator are so valuable.
Need More Advanced Models?
Explore our professional financial model templates for comprehensive analysis and forecasting. Built by finance professionals for finance professionals.