How this instrument works
Internal rate of return is defined as the discount rate that makes the net present value of a stream of cash flows equal exactly zero. When that stream is only two flows — money leaving on day one, a single payout arriving years later — algebra alone solves it, and the answer collapses to the same shape as a compound annual growth rate. Real deals rarely stay that simple: a fund that calls capital across three years and distributes it back across five more has no algebraic shortcut, and a solver has to search for the one rate that zeroes out the entire schedule.
This sheet solves the reduced, two-flow case only — Initial investment (single upfront outlay), $ going out once, Total return (single future payout), $ coming back once, across Years held. Dividing the payout by the outlay gives the total growth multiple; taking its t-th root spreads that multiple evenly across each year; subtracting one converts the leftover into a rate. Private equity and venture funds report IRR to their limited partners as the headline return figure, set against the fund's stated hurdle rate, while a corporate finance team pushing a capital project through committee compares that project's IRR against the company's weighted average cost of capital before signing off.
Full multi-flow IRR carries an assumption this two-flow version cannot even test: that any cash thrown off partway through gets reinvested at that same rate, which is generous once the headline figure climbs into double digits, since little in the market reliably pays that on parked cash. The two-flow case sidesteps that particular trap — nothing is thrown off in between — but it keeps a different one. IRR is a rate, not a dollar amount, so a $10,000 stake returned as $18,000 after two years posts a startling 34 percent IRR, while a $2,000,000 deal earning a comfortable 12 percent moved forty times as much money. Picking the larger percentage without checking the dollars behind it is the mistake this figure invites most often.
- Enter Initial investment (single upfront outlay), $ — the single lump sum that left your account on day one.
- Enter Total return (single future payout), $ — the single lump sum that came back, with nothing received in between.
- Set Years held to the time between those two dates; fractional years such as 2.5 are accepted.
- Read Internal rate of return, % — the constant annual rate that discounts your payout back to exactly your outlay.
- Compare that percentage against a hurdle rate or cost of capital on your own — this sheet reports the rate, not a verdict on whether it clears any bar.
Worked example — $50,000 growing to $90,000
Initial investment (single upfront outlay), $ 50,000. Total return (single future payout), $ 90,000. Years held 5. The growth multiple is 90,000 divided by 50,000, which is 1.8. Raising 1.8 to the power one-fifth — the fifth root, since t = 5 — gives 1.124746113142; subtracting 1 and reading the remainder as a percentage puts Internal rate of return, % at 12.4746113142, the constant annual rate that would carry $50,000 to exactly $90,000 over five years, compounding once a year.
Stretch the identical total return across twice the time and the rate roughly halves rather than roughly doubling: keep the same $50,000-to-$90,000 swing but set Years held to 10 instead of 5, and Internal rate of return, % falls to about 6.05 — a reminder that IRR measures pace, not size, and that an identical dollar gain reads as a far weaker result once it took twice as long to arrive. A fund advertising a 12 percent IRR against another advertising 6 percent on otherwise similar deals is really advertising a difference in speed, not necessarily in how much came back.
Questions
Is IRR the same thing as CAGR?
Not in general, though they agree exactly in the one case this sheet computes — a single outflow followed by a single inflow, nothing in between. True IRR is defined for any schedule of cash flows, including a fund that calls capital several times and distributes it back several times; once there are three or more flows, no algebra isolates the rate directly, and a solver searches for the discount rate that sets net present value to zero. CAGR never handles that broader case — it only ever compares two dollar figures.
Why do private equity funds lead with IRR instead of a return multiple?
Because IRR rewards speed, and speed is easy to lose sight of in a multiple that only measures size. A fund returning 2x invested capital in two years posts a far higher IRR than one returning 2x in eight years, even though limited partners received the identical multiple on their money. Reporting both figures side by side — IRR for pace, MOIC for scale — is standard practice precisely because either number alone can flatter a result the other would temper.
Can a small deal really show a higher IRR than a much bigger one?
Yes, routinely. IRR is a rate, unaware of the dollars behind it: a $10,000 stake returned as $18,000 after two years posts roughly a 34 percent IRR, while a $2,000,000 deal earning a comfortable 12 percent moved forty times as much money for a smaller headline number. Ranking opportunities by IRR alone, without checking the absolute gain each one produced, is the single most common way this figure misleads.
What does comparing IRR to a hurdle rate actually decide?
Whether a project or fund cleared the minimum return its backers require before committing capital elsewhere becomes worthwhile. A corporate finance team compares a project's IRR against the company's weighted average cost of capital; a private equity fund compares its own IRR against the hurdle rate written into its agreement with limited partners, since carried interest often accrues only above that line. This sheet computes the rate — it does not know your hurdle rate, so that comparison happens after you read the output.
Why can't this calculator handle a deal with several cash flows?
Because past two flows, IRR stops having a closed-form algebraic answer. With one outflow and one inflow, dividing and taking a root solves it directly, exactly as shown here. Add a third flow — a capital call in year two, say — and the equation defining IRR, every flow discounted back to a sum of zero, can no longer be rearranged to isolate the rate; it has to be found by iterative search, trying rates until net present value lands on zero. That is a materially different calculation from the one this sheet runs.
Does a higher IRR always mean a better investment?
Not by itself. IRR implicitly assumes any cash returned partway through a deal gets reinvested at that same rate — a generous assumption once the headline number climbs into double digits, since nowhere reliably pays that on parked cash. It also ignores deal size and risk entirely. Treat IRR as one measure of pace among several, not as a verdict, and weigh it against the dollar amount involved and how the return was actually achieved.
References
- SEC Investor.gov — Glossary: Internal rate of return (IRR)
- NYU Stern (Damodaran) — corporate finance and capital budgeting resources
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.