Internal Rate of Return (IRR) Calculator

How to use and interpret the IRR calculator

This calculator estimates the internal rate of return for a sequence of investment cash flows. IRR is the annual discount rate that makes the net present value of all modeled inflows and outflows equal to zero. It is useful for comparing projects with different cash-flow timing, but it should be reviewed alongside absolute value measures such as NPV, total profit, and cash multiple.

Choose the cash flow model

Irregular annual cash flows is appropriate when each year has a different amount. Enter the initial investment as a positive number; the calculator automatically treats it as a time-zero outflow. Each annual row may be positive for cash received or negative for additional capital, losses, maintenance, or other cash paid. Use Add year to extend the forecast. Blank rows are treated as zero, while at least one non-zero future flow is required.

Fixed recurring cash flow is appropriate when the same deposit or withdrawal repeats at a regular interval. Initial investment is the upfront capital. Holding years and additional months define the horizon. Ending balance is the terminal value received at the end, such as sale proceeds, residual account value, or remaining principal. Recurring amount is the repeated payment. Select Deposit when the amount is additional money paid into the investment and Withdraw when it is cash received. Frequency determines the number of flows per year, and payment timing determines whether each flow occurs at the beginning or end of its period.

Field-by-field guidance

• Initial investment: required and normally greater than zero. A higher initial outlay lowers IRR when future returns are unchanged.
• Annual cash flows: required for the irregular model. Earlier positive cash flows generally increase IRR more than equally sized later cash flows because they are discounted for fewer years.
• Holding period: required for the fixed model. Extending the horizon can raise or lower IRR depending on whether the added time produces enough additional cash flow or terminal value.
• Ending balance: optional in economic terms but important when the asset retains value. Omitting a real exit value can materially understate return.
• Recurring amount, direction, frequency, and timing: optional if there are no interim flows. Beginning-of-period deposits occur sooner and therefore have more effect on the money-weighted return than end-of-period deposits.
• Hurdle rate: optional comparison benchmark. It does not change IRR; it changes NPV and the displayed spread between IRR and your benchmark.

Understanding each result

Internal rate of return is the primary annualized result. A positive IRR means the cash-flow pattern has a positive annualized return under the model. A negative IRR can occur when total value is recovered too slowly or not fully recovered. Compare IRR with a relevant hurdle rate, cost of capital, or alternative opportunity rather than treating any fixed percentage as universally good.

Net profit is undiscounted inflows minus outflows. It shows absolute dollars but ignores timing. Cash multiple divides gross inflows by gross outflows and is often called a multiple on invested capital. A 1.00x multiple means cash returned equals cash paid, while a value below 1.00x indicates an undiscounted loss. NPV at hurdle discounts every cash flow at the selected benchmark. Positive NPV indicates value above that benchmark; negative NPV indicates a shortfall. Payback period estimates when cumulative undiscounted cash flow first reaches zero, with linear interpolation within the crossing period.

Charts and schedule

The cash movement donut compares gross inflows with gross outflows using the exact same values as the model and legend. The cumulative cash-flow line begins with the initial outlay and tracks the running undiscounted balance. Crossing the zero line indicates payback, not discounted break-even. The schedule lists every modeled transaction, its time in years, cumulative cash flow, and present value at the hurdle rate. For recurring flows, the table can contain many rows; the horizontally scrollable wrapper keeps the wider schedule usable on small screens.

Formula, limitations, and common mistakes

The model solves for the rate r that satisfies the equation: the sum of each cash flow divided by (1 + r) raised to its time equals zero. Because this equation is nonlinear, the calculator searches for valid roots numerically. Conventional cash flows—one initial outflow followed by inflows—normally produce one clear IRR. Alternating positive and negative flows can produce multiple IRRs or no real solution. In those cases, NPV at a chosen discount rate or modified IRR may be more informative.

Common mistakes include reversing cash-flow signs, omitting the terminal value, mixing monthly and annual spacing, comparing projects of very different scale using IRR alone, and assuming interim cash flows can actually be reinvested at the calculated IRR. Review the methodology in the Investor.gov IRR glossary, the Microsoft IRR function guide, Investopedia’s IRR overview, and the Corporate Finance Institute explanation. Results are educational estimates, not personalized investment, tax, accounting, or legal advice.