IRR Calculator

Mastering IRR: The Ultimate Guide to Investment Analysis

The Internal Rate of Return (IRR) is a cornerstone of capital budgeting and investment analysis. It represents the annualized effective compounded return rate that makes the net present value (NPV) of all cash flows equal to zero. This IRR Calculator handles uneven cash flows, computes Modified IRR (MIRR) with realistic reinvestment assumptions, and provides a full suite of complementary metrics: NPV at your hurdle rate, profitability index, payback period, and sensitivity analysis. Whether you're evaluating a startup investment, a real estate project, or a corporate capital expenditure, this tool delivers professional‑grade insights.

The IRR Formula and Calculation Method

IRR is the discount rate (r) that satisfies the equation:

0 = CF₀ + CF₁/(1+r) + CF₂/(1+r)² + … + CFₙ/(1+r)ⁿ

Because this equation cannot be solved algebraically for most cash flow patterns, our calculator uses the Newton‑Raphson iterative method to converge on the IRR. The algorithm starts with an initial guess (10%) and refines it until NPV approaches zero within a tight tolerance. For cash flows with multiple sign changes, IRR may have multiple solutions; the calculator returns the rate closest to the typical investment range.

Modified IRR (MIRR): A More Realistic Measure

Traditional IRR assumes that positive interim cash flows are reinvested at the IRR itself—an often unrealistic assumption. MIRR addresses this by allowing you to specify a separate reinvestment rate (e.g., a conservative savings rate or your company's cost of capital). The calculator discounts all negative cash flows back to present value using the finance rate, and compounds all positive cash flows to the terminal period using the reinvestment rate. The MIRR is the rate that equates these two values. MIRR always provides a single, unambiguous solution and is often preferred in academic and professional settings.

Complementary Metrics: NPV, Profitability Index & Payback

• Net Present Value (NPV): The dollar value created by the investment, discounted at your hurdle rate. Positive NPV = value creation.
• Profitability Index (PI): Ratio of present value of future cash flows to initial investment. PI > 1 indicates a value‑adding project.
• Payback Period: The time required to recover the initial investment. Simple and intuitive, though it ignores time value of money.

Sensitivity Analysis & NPV Profile

The calculator includes an NPV sensitivity table showing how NPV changes across discount rates from 0% to 50%. The accompanying NPV profile chart visually depicts the relationship between discount rate and NPV, with the IRR clearly marked where the curve crosses the zero‑NPV line. This helps you understand how sensitive the investment's attractiveness is to changes in your required return.