How to use the IRR calculator
Enter the initial investment, then one cash flow per year: the distributions you receive at the end of year 1, year 2 and so on. Add or remove years with the buttons. A cash flow can be negative when money goes in rather than out, such as a capital call; the ± button beside each row switches the sign. Put the net sale proceeds in the last box. They are added to the final year listed.
If your cash flows have real dates, switch to exact dates. Each row then takes a date and an amount, the investment and the sale get dates of their own, and the result is an XIRR, the same calculation as the XIRR function in Excel and Google Sheets. Alongside the IRR you get the equity multiple, the total invested and received, and the profit.
How to calculate IRR
IRR, the internal rate of return, is the yearly rate at which the money you put in would have had to grow to produce exactly the cash you got back, when it came back. Formally it is the discount rate that makes the net present value of all the cash flows zero: money in counts as negative, money out as positive, and each amount is discounted for how long you waited for it.
There is no formula that solves for the rate directly, which is why IRR is found by trial: pick a rate, discount the cash flows, see whether the total is above or below zero, and narrow the range. This calculator does that search for you. For a single amount in and a single amount out there is a shortcut: IRR equals the equity multiple to the power of one over the years, minus one.
Formula
Sum of each cash flow ÷ (1 + r) to the power of its year = 0. Contributions are negative, distributions positive, and the IRR is the r that makes the sum zero.
Worked example: $100,000 in, five years of cash flow and a sale
The calculator opens on this investment. You put in $100,000. The deal pays $7,000 at the end of the first year and a little more each year after, and at the end of year five it also pays $140,000 of sale proceeds, so the last cash flow is $149,000.
| Year | Cash flow | Discounted at 13.93% |
|---|---|---|
| 0 | −$100,000 | −$100,000 |
| 1 | $7,000 | $6,144 |
| 2 | $7,500 | $5,778 |
| 3 | $8,000 | $5,410 |
| 4 | $8,500 | $5,045 |
| 5 | $149,000 | $77,623 |
| Total | $80,000 | $0 |
Check the numbers
$180,000 received on $100,000 invested is a 1.80x equity multiple and $80,000 of profit. Discounted at 13.93% a year, the five payments are worth $100,000 today, exactly what was invested, so 13.93% is the IRR.
IRR vs XIRR: yearly periods or exact dates
Plain IRR assumes the cash flows are evenly spaced, one per period. If the periods are years, the answer is a yearly rate. XIRR drops that assumption: every cash flow has its own date, and each is discounted by the actual number of days since the first one, divided by 365.
For real investments XIRR is usually the right tool, because contributions and distributions rarely land on anniversaries. A distribution paid in March rather than December raises the return, and only XIRR sees that. When cash flows really are a year apart the two agree, apart from a small leap-year difference, since XIRR counts 366 days as slightly more than a year.
What a good IRR looks like
It depends on the risk, the leverage and the hold period, and on whether the figure is before or after fees and the sponsor's promote. As a rough guide to what sponsors commonly project, net to investors: stabilized, lower-risk property often sits in the high single digits to low teens, value-add deals in the low to high teens, and ground-up development higher still. These are typical projections, not promises, and they move with interest rates.
Read an IRR with its equity multiple and hold period. A 25% IRR over 18 months may return less money than 14% over six years. IRR also assumes each distribution can be reinvested at the same rate, which flatters very high IRRs on short holds.
When there is no IRR, or more than one
An IRR needs money going in and money coming back at different times. If nothing has been distributed yet, or every cash flow is on the same day, no rate can be worked out, and the calculator says so instead of showing a number.
Cash flows that change direction more than once, for example an investment, some distributions, a large capital call and then a sale, can be solved by more than one rate, or by none. The calculator warns you when that happens. In those cases the equity multiple and the profit, which do not depend on a rate, are the safer figures to quote.
Common mistakes when calculating IRR
Small slips in the inputs can move an IRR by several points.
- Leaving out the sign. Money invested must be negative and money received positive, or there is nothing to solve.
- Mixing periods. Monthly cash flows fed to a yearly IRR give a monthly rate, which then has to be annualized.
- Counting the sale twice, once as proceeds and again in the last year's cash flow.
- Using the gross sale price instead of what is left after costs and the loan payoff.
- Comparing a deal-level IRR with an investor's own IRR. Fees, the promote and the investor's own dates all sit between the two.