Real Estate Tax Calc
Equity multiple: total dollars returned
The equity multiple is the simplest return metric: total distributions received divided by total capital invested. A 2.0x equity multiple means you received $2 for every $1 invested — you doubled your money. A 1.0x means you broke even. Equity multiple does not account for time — a 2.0x in two years and a 2.0x in ten years produce the same number, even though the former is dramatically better.
Equity multiple is useful for understanding total wealth creation. Two deals: Deal A returns 1.8x equity; Deal B returns 2.5x equity. If all else were equal, Deal B creates more wealth per dollar invested.
IRR: the time-adjusted rate
Internal rate of return (IRR) is the annualized discount rate that makes the net present value of all cash flows equal to zero — essentially, the compound annual growth rate of your investment, accounting for when cash flows occur. A $100,000 investment that returns $200,000 in two years has a much higher IRR (~41%) than the same investment returning $200,000 in ten years (~7.2%). Both are 2.0x equity multiples.
IRR rewards speed. It favors deals that return capital quickly, so it tends to favor value-add deals with a quick repositioning and sale over long-hold core assets with steady but slow compounding.
When they conflict: which to prefer
The two metrics tell different stories. A high-IRR, low-equity-multiple deal (a quick flip at 30% IRR but only 1.4x) may be less valuable than a long-hold at 15% IRR and 2.8x, depending on how you can deploy the returned capital. If you can consistently find 30% IRR deals to reinvest in, the high-IRR strategy wins. If your next best investment is a savings account, the equity multiple matters more.
Real estate syndications typically show both metrics. When evaluating a deal, use IRR to compare speed-adjusted returns across different hold periods and use equity multiple to evaluate total wealth impact. Neither alone is sufficient.
A worked example: two deals, same money
Suppose you have $100,000 to invest and two opportunities. Deal A is a value-add apartment: you invest $100,000, receive modest $3,000/year distributions for three years, then the sponsor sells and returns $150,000 of equity at the end of year three. Total received: $9,000 + $150,000 = $159,000, a 1.59x equity multiple over three years. Deal B is a stabilized building held longer: $100,000 in, $7,000/year for eight years, then $180,000 returned at sale. Total received: $56,000 + $180,000 = $236,000, a 2.36x equity multiple over eight years.
Deal B clearly creates more total wealth — 2.36x versus 1.59x. But run the IRR and the picture shifts: Deal A returns capital quickly, producing roughly a 19% IRR, while Deal B's slower compounding lands near 13% IRR. If you can redeploy Deal A's returned capital into another high-return opportunity, the faster deal can win over the same eight-year horizon. If you cannot, Deal B's larger multiple is the safer bet. This is the central tension: the equity multiple measures how much, IRR measures how fast.
How IRR is actually calculated
IRR is the discount rate r that solves 0 = Σ CFt ÷ (1 + r)t, summed across every period t from the initial outflow to the final sale proceeds. There is no closed-form algebraic solution once there are more than a couple of cash flows, so IRR is found by iteration — which is why spreadsheets provide the =IRR() and =XIRR() functions. Use XIRR when cash flows land on irregular dates (most real deals), because it discounts by actual days rather than assuming even annual periods. Feed it the exact dates and signed amounts: the initial equity as a negative number, distributions and the sale as positives.
Because IRR solves a polynomial, a deal with alternating positive and negative cash flows — for example a capital call midway through the hold — can technically produce more than one mathematically valid IRR. In practice most deals have a single sign change and one meaningful IRR, but be cautious with quoted IRRs on deals that include mid-life capital calls.
The reinvestment assumption — IRR's biggest flaw
IRR implicitly assumes every interim distribution is reinvested at the same IRR. A deal advertising a 25% IRR is effectively assuming you can turn around and earn 25% on each distribution the moment you receive it — rarely realistic. This overstates the effective return on distribution-heavy deals. The modified internal rate of return (MIRR) addresses this by letting you specify a realistic reinvestment rate (say, 6%) separately from the deal's own return, and often produces a more honest figure. When two deals show similar IRRs but very different distribution timing, compare their MIRRs before deciding.
Equity multiple's cousins: MOIC, DPI, and TVPI
You will see related multiples in private-equity-style reporting. MOIC (multiple on invested capital) is essentially the equity multiple — total value ÷ invested capital. DPI (distributions to paid-in) counts only cash actually returned, so it climbs as the deal pays out and reaches the full multiple only at final sale. TVPI (total value to paid-in) adds the estimated remaining value of unsold assets to distributions already made. Early in a hold, DPI is low and TVPI carries the estimate; a wide gap between them means most of the promised return is still unrealized paper value that depends on the sponsor hitting its exit assumptions.
After-tax returns can change the ranking
Both metrics are almost always quoted pre-tax. Depreciation can shelter interim distributions, making them partly tax-free cash flow, while the gain at sale faces capital-gains rates plus unrecaptured Section 1250 depreciation recapture (capped at 25%) and possibly the 3.8% net investment income tax. A deal that returns most of its value as a lump-sum capital gain at sale can be more tax-efficient than one paying large, currently-taxable ordinary distributions along the way. Run both the pre-tax IRR and multiple the sponsor quotes and an after-tax version reflecting your own bracket before comparing deals side by side.
The preferred return and the promote
In syndicated deals, both metrics are shaped by the distribution waterfall. Investors (limited partners) usually receive a preferred return — often 6–9% per year — before the sponsor shares in profits. Above that hurdle, the sponsor earns a promote (carried interest), commonly 20–30% of profits in higher tiers. The IRR and equity multiple a sponsor advertises may be the project-level figures, before the promote is stripped out. Always confirm whether a quoted 18% IRR is the return to you — the LP, net of fees and promote — or to the overall deal. The gap can be several points of IRR and a meaningful slice of the equity multiple.
Gross vs. net: fees quietly lower both metrics
Acquisition fees, asset-management fees, disposition fees, and the promote all sit between the property's gross performance and what lands in your account. A deal with a strong gross IRR can deliver a mediocre net IRR once layered fees are subtracted. When comparing opportunities, insist on net-to-investor figures and read the fee schedule closely: two deals with identical underlying property performance can hand investors very different returns purely because of how the sponsor is compensated. The property does not know how it was financed or who is managing it — but your after-fee IRR and multiple certainly do.
How to present both metrics together
When you underwrite or pitch a deal, lead with the pair, not one number. A clean summary reads: '2.1x equity multiple and 16% IRR over a projected five-year hold, net to investors.' That single line tells a reader the total wealth created, the speed of the return, the time horizon, and that the figures are after fees. If a sponsor quotes only one metric, ask for the other — a lone IRR hides whether the multiple is thin, and a lone multiple hides whether the hold is punishingly long. The two together, labeled with the hold period and net-of-fees, are the honest minimum for comparing real estate deals side by side.
Frequently asked questions
What is a good IRR for a real estate investment?
IRR targets vary by risk and strategy. Value-add deals might target 15–20% IRR; core long-hold properties might target 8–12%. Always compare to alternatives with similar risk profiles.
Are the IRR and equity multiple I see net of fees?
Not always. Sponsors sometimes quote project-level (gross) returns before the promote and management fees are deducted. Always ask for the net-to-investor IRR and equity multiple, which reflect what actually reaches your account after fees and the sponsor's share of profits.
What is the difference between IRR and MIRR?
IRR assumes interim cash flows are reinvested at the IRR itself, which overstates returns on distribution-heavy deals. MIRR (modified IRR) lets you set a realistic reinvestment rate separately, giving a more conservative and often more accurate figure.
Can a single deal have two different IRRs?
Yes, mathematically. Whenever cash flows change sign more than once — for example a capital call after distributions have begun — the IRR equation can have multiple valid solutions. Deals with a single sign change (money in, then money out) have one meaningful IRR.
Should I use XIRR or IRR in a spreadsheet?
Use XIRR for real deals. It accounts for the actual dates of each cash flow, while the basic IRR function assumes evenly spaced annual periods — which almost never matches when distributions and the sale actually occur.
What is a good equity multiple for a real estate deal?
A 2.0x equity multiple over 5–7 years is often considered a reasonable target. The required multiple should rise with hold period — a 2.0x over 10 years is less compelling than 2.0x over 5 years.
Which metric is more important, IRR or equity multiple?
It depends on your reinvestment opportunities. If you can consistently find high-return reinvestment, prioritize IRR. If capital deployment is harder, the equity multiple becomes more important.
Educational information and estimates only. Not tax advice. Tax rules change and vary by situation; consult a qualified tax professional before acting.