Free calculator

IRR calculator (internal rate of return)

Trouvez un TRI (IRR) périodique annuel : le taux qui met la VAN à zéro pour votre investissement initial et une courte liste de flux nets en pas d’un an—la même histoire VAN = 0 que TRI / IRR dans Google Sheets et Microsoft Excel. Saisissez l’investissement initial en positif (nous le stockons comme une sortie en t0) ; pour les années suivantes, des montants signés (entrée +, sortie −). Pas de moteur XIRR / dates—pour MIRR avec taux de financement et réinvestissement, utilisez le calculateur MIRR ; pas de conseil fiscal ou produit—voir la méthode.

Initial investment (at year 0)

Positive = money you pay in at the start. We map this to a negative time-0 cash flow in the same convention as IRR(values) in a spreadsheet.

Year 1 net cash flow

Use + for net in and − for extra out in that year (after tax if you are staying consistent in your own model).

Year 2 net cash flow

Year 3 net cash flow

Up to 50 annual entries after the initial outlay.

Spreadsheet check: the first value in the IRR range is usually negative (purchase), later values can be positive or negative.

Result

IRR (per year, periodic): -21,7627217307%

Educational illustration only. IRR is a teaching metric on your numbers—not a promise of future performance, not a market quote, and not investment, tax, or credit advice. Some cash-flow patterns can have no or multiple real IRRs; use judgment and a full model when it matters.

When to use an IRR line

You have more than two money dates, not just in vs out at the end, and you want a headline discount rate for NPV = 0 in round-year steps.

Compare a project to a hurdle or to CAGR-style stories—after you are explicit about the year-by-year cash (still an illustration, not a board sign-off).
Teach the IRR/NPV=0 link with the same two-column story people use in interview and MBA problem sets—before a bigger Excel or Sheets model takes over.
Homework and certification drills with 3–6 years of free cash flow—annual only on this page.
Move to CAGR or ROI when the story is really one buy and one sell; move to a sheet XIRR for irregular dates—see below.

How do you calculate internal rate of return (IRR) here?

IRR is any rate r (with r > −1 in a standard setup) that makes the net present value of the schedule zero: CF₀ + CF₁⁄(1+r) + CF₂⁄(1+r)² + … = 0 with one term per equal period. There is no closed form for a long list, so tools use a root-finding routine; we do the same numerically, aligned with IRR.

What “NPV = 0 at IRR” means

At the IRR, the sum of all cash flows, each discounted to today at that rate, is zero—not “return ÷ years” and not a CAGR of two totals unless the problem reduces to that special case.

Annual grid only in v1

Each line is one year after the previous, like IRR’s default one row per period with no calendar dates in the function. For sub-annual or uneven timing, the usual spreadsheet tool is XIRR; we do not reimplement it here.

What this page is not

XIRR sur des dates, postes notaire / crédit immobilier, IRR « économiques » fiscal ou inflation, et LBO levier avec tranches de dette. Le MIRR a sa propre page lorsque vous avez besoin des taux de financement et réinvestissement ; construisez le reste dans un modèle ; cette page reste sur la définition TRI périodique de base.

For round-year project math, your hurdle or WACC is a separate input; we do not score projects—only the mechanical IRR on the numbers you type. For two totals and optional time to CAGR or ROI %, use the ROI calculator or the CAGR calculator —two-point growth, not a multi-row NPV=0 search. For a level PMT and one nominal rate, use the TVM calculator —it is the annuity family, not arbitrary rows. For time-to-recoup with optional discounted payback, use the payback period calculator .

Google Sheets & Excel

Noms de fonctions en anglais dans l’aide ; IRR correspond à une ligne par période égale avec t0 comme première cellule. XIRR avec dates reste dans le classeur. Pour MIRR, ouvrez le calculateur MIRR sur ce site.

Row layout for IRR (first cell is time 0)

Copy your cash series into a row or column, then: **`=IRR(B1:H1)`** or add an optional second argument, e.g. **`=IRR(B1:H1,0.1)`**.

Use the initial outlay as a negative in B1 if you prefer raw spreadsheet sign rules; you can also keep positive t0 in the tool above—we convert for IRR parity in the help text.

Dated, irregular cash flows (Excel / Sheets)

**`=XIRR(amounts, dates, guess)`** in Excel; in Google **Sheets**, the same function name and two-column layout apply.

Use when months are not a clean annual grid. We do not run XIRR in the browser on this v1 page.

Frequently asked questions

What is internal rate of return (IRR)?

IRR (here, periodic IRR like Excel IRR) is a rate r that makes the net present value of your list of cash flows zero when you discount at r in constant time steps—one term per year on this page.

Why is my initial investment “positive” but called an outflow?

Many people think in dollars spent as a positive line. Spreadsheets usually store t0 as a negative (money out). This page accepts a positive initial line for you and negates it internally for t0 so the sum line matches the IRR(values) sign story—check the help copy next to the box.

Is IRR the same as CAGR on this site?

No. The CAGR tools take one start value, one end value, and one time span. IRR is defined on a vector of dated-in-steps cash flows and is not the same as (ending ÷ beginning)^(1/t)−1 unless the history collapses to a two-flow case.

Is IRR the same as the ROI % on the ROI calculator?

No. The ROI page is a one-in, one-out or one-in, one-out + optional time to CAGR story. IRR is for multi-year and in-between inflows and outflows at equal spacing. Use IRR for schedules; use ROI for two headline numbers when that is what you have.

Is this the same as the TVM calculator’s “rate” field?

TVM solves one of PV, FV, level PMT, rate, or N when the payment and compounding rules are tidy annuities. IRR is for a row of arbitrary net cash flows at equal intervals, which TVM does not cover as a free-form list—different problem shape.

How do I match this in Google Sheets or Microsoft Excel?

Build one row (or column) of cash, first cell = t0 (use negative for out if you are mirroring a sheet exactly), then use =IRR(...) with the same sign pattern you used in the sheet. Add an optional guess if your software asks for it.

Can I paste dates for each cash flow (XIRR)?

Not in v1 of this page—timing is a one-year ladder only. In Excel / Sheets, use XIRR/XNPV when amounts land on calendar dates, then compare to this periodic IRR in teaching notes.

Proposez-vous le TRI modifié (MIRR) ?

Oui—utilisez le calculateur MIRR pour MIRR(valeurs;taux_financement;taux_réinvestissement) avec la même grille annuelle qu’ici. Cette page TRI reste TRI / VAN = 0 avec un seul taux périodique.

I need a monthly IRR—where do I go?

Excel IRR on monthly values returns a rate per month; you annualize with (1+monthly)¹²−1 when you need an approximate annual figure, or you stay monthly-native in your model. This tool uses one value per year only; see methodology.

Can a project have more than one IRR?

Yes, some “wiggly” cash-flow paths (sign changes more than once in a deep way) can show more than one mathematical IRR. One displayed value from a solver is a convention—treat it as a stylized teaching output and escalate to a full model in practice.

Is this a real estate or SCPI return calculator?

It is a generic periodic IRR for any year-step list you type—not a jurisdiction- or lease-specific asset model. In FR, TRI in immobilier articles often wraps tax and fees—we do not—treat the page as educational only.

Is this investment, tax, or business advice?

No. It is a free educational calculator and illustration—not a fiduciary or licensed product recommendation, not a filing, and not a substitute for advice when real money and contracts are in play.

Explorer les modèles Services de modélisation Réserver une consultation