Skip to content

Covestly

Free calculator

IRR calculator for real estate: IRR, XIRR and equity multiple

Enter what you invest, the cash you receive each year or on exact dates, and the sale proceeds. The calculator returns the internal rate of return (XIRR when the cash flows carry dates), the equity multiple and the total profit, and says why when no IRR exists.

When the cash moves
Money in
Cash flows, at the end of each year

Money received is positive. For money paid in later, such as a capital call, make the amount negative with the ± button.

Sale

Received at the end of year 5, the last year listed. Leave empty if there is no sale.

IRR

13.93%

A year, with cash moving at each year's end

Equity multiple
1.80x
Total invested
$100,000
Total received
$180,000
Total profit
$80,000

Money in counts as negative and money back as positive. The IRR is the yearly rate at which they net to zero.

Formula: IRR is the rate r where the sum of each cash flow ÷ (1 + r) to the power of its year = 0

Runs in your browser. Nothing you type is sent or saved. Updated .

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.

Cash flows of the example, and what each is worth today at the IRR
YearCash flowDiscounted 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.

Common questions

What is IRR in real estate?

IRR, the internal rate of return, is the compound yearly rate an investment earns once every cash flow and its timing are taken into account: the money invested, the distributions along the way and the proceeds of a sale or refinance.

How do you calculate IRR?

List every cash flow with its timing, money in as negative and money out as positive, then find the discount rate at which they add up to zero. It is found by trial and error, which is why people use a calculator or a spreadsheet function such as IRR or XIRR.

Is IRR the same as XIRR?

They measure the same thing. IRR assumes cash flows one regular period apart, while XIRR uses the actual date of each cash flow and counts days over 365. With cash flows exactly a year apart the two give almost the same answer.

What is a good IRR for a real estate investment?

It depends on the risk and the hold period. Sponsors commonly project net IRRs from the high single digits for stable property to the high teens or more for value-add and development deals. Always read it alongside the equity multiple.

Can IRR be negative?

Yes. If an investment returns less cash than was put in, the IRR is negative and the equity multiple is below 1.00x. The calculator shows negative rates down to minus 99.99% a year.

Why does the calculator say there is no IRR?

Because no single rate fits the cash flows. That happens when nothing has come back yet, when everything is on the same day, or when the cash flows change direction more than once and have several possible rates or none.

What is the difference between IRR and equity multiple?

The equity multiple says how much money came back for each dollar invested and ignores time. IRR says how fast, as a yearly rate. Two deals with the same multiple have different IRRs if one returns the cash sooner.

Do this for every deal, automatically

Covestly works out capital calls, waterfalls and investor returns from one record, and shows each investor their own numbers.

  • 14-day free trial with every add-on
  • Investors are always free
  • Unlimited staff
  • Cancel any time