How to Build a Real Estate Waterfall Model With IRR Hurdles

To model a real estate waterfall with IRR hurdles, keep one running balance per hurdle. Each balance starts at the investors' contribution, grows each period at its hurdle rate, and falls by every dollar paid to investors. Each period's cash then fills tier 1 until the first balance is zero, tier 2 at its split until the second balance is zero, and the rest at the top split. If the tiers add up to the cash every period and investors' IRR lands exactly on each hurdle it reaches, the model is right.

Our waterfall and promote guide explains the concepts with a pref-based example. This post builds the other common version, an IRR-hurdle waterfall, row by row, so sponsors can model their own terms and investors can check one.

What does the model need?

Inputs (one block at the top):

Rows, one per period: the cash available to distribute to equity (operating cash flow and, in the last year, net sale proceeds). The model assumes that line is already after debt service, reserves, fees and loan payoff; only equity cash goes into a waterfall.

How do the hurdle balances work?

For each hurdle h, the balance in period t is:

Beginning balance x (1 + h) + contributions - distributions to investors in the period

In spreadsheet terms, with the 8% balance in column F and the 14% balance in column K:

• F6 = F5*(1+$B$2) - investor cash paid in tiers 1 to 3 in period 6
• K6 = K5*(1+$B$4) - investor cash paid in tiers 1 to 3 in period 6

Every dollar paid to investors reduces every hurdle balance, including the dollars paid in tier 2 and tier 3. A common error is to reduce the 14% balance only by tier 2 payments.

Then each period's tiers:

• Tier 1 = MIN(cash, MAX(F before payment, 0)), all to investors.
• Tier 2 = MIN(cash - tier 1, MAX(K after tier 1, 0) / 80%), 80% to investors, 20% to sponsor.
• Tier 3 = cash - tier 1 - tier 2, 65% to investors, 35% to sponsor.

The division by 80% is the step people miss: to bring the 14% balance down by $80, investors must receive $80, which means $100 of cash flows through a tier where they get 80 cents of each dollar.

Worked example: five years, two IRR hurdles

All numbers are hypothetical, for illustration only. They are not a projection, and every investment can lose money.

Investors contribute $3,000,000. Cash to equity is $150,000, $180,000, $210,000 and $240,000 in years 1 to 4. In year 5 it is $240,000 of operations plus $5,000,000 of net sale proceeds, $5,240,000 in total.

The hurdle balances, before each year's payment:

In years 1 to 4 the cash is far below the 8% balance, so every dollar goes to investors in tier 1 and the sponsor receives nothing. The 8% balance keeps growing because the cash paid is less than 8% of it.

Year 5, tier by tier:

How tier 2 is sized: after tier 1, the 14% balance is $4,709,706 - $3,473,019 = $1,236,687. Investors need that much more, at 80 cents per dollar, so the tier is $1,545,859.

Reconciliation:

• Year 5 tiers: $3,473,019 + $1,545,859 + $221,122 = $5,240,000.
• Whole deal: investors receive $780,000 in years 1 to 4 plus $4,853,435 in year 5 = $5,633,435. The sponsor receives $386,565. Together: $6,020,000, the total cash to equity.
• Investors' IRR on their cash flows is about 14.6% and their equity multiple is about 1.88x. The deal's IRR before the split is about 16.2%. The sponsor's promote is the difference.
• The IRR check: investors' cash flows through tier 2 produce exactly 14%, because tier 2 ended when the 14% balance hit zero. Put investors' flows through tier 2 into =IRR() to confirm.

Downside case. Same operations, but the sale nets $3,100,000, so year 5 cash is $3,340,000. That is less than the $3,473,019 8% balance, so all of it is tier 1. Investors receive $4,120,000 in total (a 1.37x multiple, about a 7.3% IRR), and the sponsor's promote is $0. With net sale proceeds below $1,980,000 in this example, investors would get back less than the $3,000,000 they put in.

How is an IRR hurdle different from an equity multiple hurdle?

Replace the hurdles with multiples: 100% to investors until they have received 1.4x their equity ($4,200,000), 80/20 until 1.8x ($5,400,000), then 65/35. The model is simpler: track cumulative distributions instead of growing balances.

The fast sale shows the difference. Three years of cash that total $4,540,000 give investors an IRR above 14% under the IRR waterfall, so the sponsor reaches the top split. Under the multiple waterfall, the same $4,540,000 is only about 1.51x, so the sponsor stops in the 80/20 tier with $68,000. IRR hurdles reward selling early; multiple hurdles reward total dollars. For how the two measures behave on their own, see equity multiple, IRR and cash on cash.

What modeling mistakes should you avoid?

• Reducing only the current tier's balance. Every investor dollar reduces every hurdle balance.
• Forgetting the split division. A tier at 80/20 needs balance / 0.8 of cash, not the balance itself.
• Mixing periods. If cash is quarterly, the hurdle rate per quarter is (1 + annual)^(1/4) - 1 for an IRR compounded annually, not annual / 4. Use whichever matches how the agreement defines IRR.
• Using IRR() on uneven dates. If distributions are dated, the agreement likely means XIRR()-style timing. Our preferred return spreadsheet guide covers partial periods.
• Including the sponsor's co-investment twice. If the sponsor invests alongside investors, its money is in the investor class and the promote is separate.
• Forgetting the definition in the agreement. Is IRR measured for the investor class as a whole or per investor, on actual dates or annual periods, compounded annually or not? The model must follow the document.
• Modeling only the pitch case. Always add a sale that misses. If your model never shows a $0 promote, it is not testing anything. Multifamily underwriting basics covers how to build the downside case that feeds it.

How DoorRaise fits in

DoorRaise prepares the standard offering documents for apartment deals raised from a sponsor's friends and followers under Rule 506(b) or 506(c). The standard operating agreement returns capital first at a sale, then any unpaid cumulative pref, then the split the sponsor chose, and the deal page shows investors those terms in plain numbers. DoorRaise does not build your waterfall model or your projections; those are the sponsor's work. It forms the LLC, files Form D and state notices, verifies accredited investors, and has investors fund by wire into escrow at Enterprise Bank & Trust, an independent bank. Fees are $1,500 to set up (non-refundable), $5,000 at closing (only if the deal closes) and $3,500 a year.

For a quick check of a single-split sale, try the profit split calculator. When your terms are set, start your sponsor page.

FAQ

How do you model a real estate waterfall with IRR hurdles?

Keep one balance per hurdle that grows at the hurdle rate and falls with every dollar paid to investors. Pay each period's cash to tier 1 until the first balance is zero, to tier 2 at its split until the second balance is zero, and the rest at the top split.

What is a real estate equity waterfall model?

A spreadsheet that takes the cash available to equity each period and splits it between investors and the sponsor according to the operating agreement's tiers: return of capital, pref or IRR hurdles, and the promote.

How do you build a waterfall with IRR hurdles in Excel?

Use a balance column per hurdle (=prior*(1+rate) - investor cash), then size each tier with MIN and MAX, dividing the remaining balance by the investors' share in split tiers. Check that tiers add up to the cash and that IRR() of investors' flows equals the hurdle where a tier ends.

Is there a real estate waterfall template?

The column layout in this post is a template: inputs block, cash row, one balance per hurdle, three tier columns, and investor and sponsor totals with a reconciliation row. Build it once and change only the inputs.

What is the difference between an IRR hurdle and an equity multiple hurdle?

An IRR hurdle depends on time, so a fast sale reaches it with fewer dollars. An equity multiple hurdle only counts dollars. In our example, a three-year sale paid the sponsor $161,069 under IRR hurdles and $68,000 under multiple hurdles.

Sources

• IRS: Instructions for Schedule K-1 (Form 1065)
• 17 CFR 230.506: Exemption for limited offers and sales (Cornell LII)

The examples are simplified illustrations with made-up numbers, not a projection or an offer. This article is general information as of October 2026, not legal, tax or investment advice. Your operating agreement controls the waterfall; have your own advisers check your model. DoorRaise is not a law firm, broker-dealer, investment adviser or funding portal.