IRR Calculator
Calculate the Internal Rate of Return (IRR) for an investment or project using regular cash-flow periods. View annualized IRR, Net Present Value (NPV) at your benchmark rate, and an editable discounted cash-flow schedule.
Calculate your investment IRR
Add or remove cash-flow periods below. Period 0 is today; later periods occur at equally spaced intervals. Enter costs with a minus sign.
Cash-flow schedule
Negative (−) = money invested or spent. Positive (+) = money received. Cash flows must include at least one of each. Add up to 30 periods.
Cash-flow timeline
| Period | Cash flow | Discount factor | Present value | Cumulative PV |
|---|
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 equals zero. It is used in capital budgeting, business projects, investment analysis and financial modelling to describe the return implied by a sequence of payments and receipts.
IRR reflects the timing of cash flows as well as their amounts. Receiving cash sooner can affect the return differently from receiving the same amount later. A higher IRR may appear attractive, but project scale, risk, financing conditions and NPV also matter.
How to use the IRR Calculator
- Choose the currency and whether cash flows occur annually, quarterly or monthly.
- Enter your initial investment as a negative amount in Period 0.
- Enter later inflows and outflows in order, one cash flow for each equal time interval.
- Set a required annual return (also called a discount rate or hurdle rate) for the NPV calculation.
- Click Calculate IRR & NPV to view the result, cash-flow timeline and discounted present-value table.
IRR formula and NPV calculation
IRR is not obtained by simply dividing profit by the initial investment. It is found by solving a discounted cash-flow equation:
Here, CF₀ is the initial cash flow, CFₜ is the flow at period t, and r is the IRR for one period.
The calculator finds candidate rates numerically by examining NPV across a range of rates and refining sign-change intervals. It separately calculates NPV using your selected benchmark rate. For quarterly or monthly periods, it converts the required annual rate into an equivalent rate for each period using compounding.
IRR calculation example
Suppose a project requires an upfront investment of ₹1,00,000 and returns ₹40,000 at the end of each of the next three years. Those are four cash-flow entries, beginning with a negative amount at Period 0.
| Period | Cash flow | Explanation |
|---|---|---|
| Year 0 | −₹1,00,000 | Initial investment |
| Year 1 | +₹40,000 | First receipt |
| Year 2 | +₹40,000 | Second receipt |
| Year 3 | +₹40,000 | Third receipt |
| Calculated annual IRR | About 9.70% | Rate at which NPV becomes zero |
| NPV at an 8% benchmark | About +₹3,083.88 | Estimated excess present value at the chosen required return |
This example has a positive NPV at 8%, but its value and suitability still depend on whether the project cash-flow assumptions and the 8% benchmark adequately reflect the actual risks.
IRR vs NPV vs ROI
IRR
Expresses the discount rate implied by a cash-flow schedule. IRR is a rate, not a rupee amount, and depends on timing.
NPV
Expresses value in money today after discounting cash flows at a required return. NPV can help assess value created at that benchmark.
ROI
Often compares profit with invested capital, but simple ROI usually does not account for when individual cash flows occur.
What is a good IRR?
There is no single IRR threshold that is suitable for every investment. A project might have a 12% IRR but still be unattractive if its risk-adjusted cost of capital is 15%. Another project may have a lower IRR but create greater total value because it is larger.
Compare IRR against a relevant required return, and inspect NPV, project scale, cash-flow assumptions and risk. A high IRR by itself does not guarantee an investment is sensible or profitable in practice.
IRR vs XIRR: what is the difference?
IRR assumes that every cash flow occurs at an equal interval. If you select monthly frequency, each period is one month apart. If you select annual frequency, each period is one year apart. With monthly or quarterly cash flows, this page shows both the per-period IRR and the effective annualized rate.
XIRR uses actual calendar dates. If payments occur on irregular dates — for example, a mutual fund investment with missed months or property receipts received on unpredictable dates — use an XIRR calculation instead of treating those dates as equally spaced. Microsoft documents the distinction between Excel IRR and Excel XIRR.
Can IRR be negative, missing or have multiple answers?
A negative IRR can occur when the expected cash flows imply a loss in annualized or periodic return terms. A negative value does not necessarily mean the calculator has failed.
Some non-conventional cash-flow patterns — particularly those that switch between negative and positive several times — can produce multiple IRRs, while others produce no real IRR. In that case IRR alone is ambiguous. This calculator looks for multiple roots, displays a warning when more than one candidate is found, and still shows NPV at your required return. Numerical scanning may miss repeated or extremely unusual roots, so verify complex projects separately.
How to calculate IRR in Excel
- Enter cash flows in consecutive cells, starting with the initial cash flow in A1.
- Record outflows as negative and inflows as positive values.
- For equal intervals, enter =IRR(A1:A4) and format the result as a percentage.
- For irregular dates, put corresponding dates in another range and use =XIRR(A1:A4, B1:B4).
- For an NPV analysis, apply your required return consistently to all future cash flows and include the Period 0 cash flow.
Common IRR calculation mistakes
- Wrong cash-flow signs: investing money is generally an outflow (negative); receiving money is an inflow (positive).
- Uneven dates: use XIRR if actual payment dates are irregular.
- Ignoring the initial investment: include the Period 0 cash flow; it is not discounted.
- Misreading monthly IRR: a per-month IRR is not the same as an effective annualized rate.
- Relying on IRR alone: review NPV and the underlying investment assumptions.
- Ignoring possible multiple roots: cash flows that change signs repeatedly may yield more than one IRR.
Where an IRR calculator is useful
- Business projects: estimate returns from initial capital spending and projected future receipts.
- Property investments: model upfront cash costs and anticipated income or a later sale amount when flows occur at equal intervals.
- Capital budgeting: compare a project IRR with a required return and examine NPV.
- Private investments: explore scenarios using signed cash-flow projections.
- Education and Excel practice: cross-check an IRR formula with an editable schedule.
Related finance calculators
Frequently Asked Questions
What does IRR mean?
IRR stands for Internal Rate of Return. It is the discount rate at which NPV equals zero for a periodic series of cash flows.
Can I calculate IRR for monthly cash flows?
Yes. Select Monthly under Period interval. The calculator shows the per-month IRR and the effective annualized IRR, assuming every cash flow is one month apart.
What is a good IRR?
It depends on the required return, project risk and alternative investments. Compare IRR with a relevant benchmark and examine NPV as well.
What is the difference between IRR and XIRR?
IRR assumes equally spaced cash flows. XIRR uses actual dates for irregularly spaced cash flows.
Can IRR be negative?
Yes. A negative IRR can indicate that the projected cash flows imply a negative periodic return.
Can one project have two IRRs?
Yes. Cash-flow series with more than one sign change can produce multiple rates at which NPV is zero. The calculator warns when it identifies more than one candidate.
What formula calculates IRR in Excel?
For equal intervals use =IRR(values, [guess]). For irregular dates use =XIRR(values, dates, [guess]).
Last updated: October 18, 2026. Calculations are educational estimates based on the entered cash flows and regular timing assumptions, not investment advice or a guarantee of returns.