The Real Estate Equity Waterfall Modeling Master Class

Define a real estate partnership as a special purpose entity with a general partner and limited partners, outlining a joint venture operating agreement and equity waterfall for cash flow distribution.

Explain the GP and LP roles in real estate equity waterfalls, detailing sweat equity, capital contributions (GP 1–10%, LP 90–99%), fees, and promoted interest.

Identify real estate fee structures for gp and lp, including acquisition (1–2%), asset management (1–2% of effective gross revenue or 0.5–1% of equity), construction management (4–8%), and disposition (1–2%).

Explore promoted interest in real estate equity waterfalls, where a GP earns a 20% promote above an 8% IRR hurdle, plus pro rata shares of remaining cash flows.

Discover how real estate equity waterfalls use a preferred return and escalating return hurdles to align GP and LP, with pari passu cash flows and promoted interest across tiers.

Explore how promoted interest differs from cash flow split in real estate equity waterfalls; learn how GP and LP cash flows are allocated beyond the preferred return, factoring initial equity.

Explore real estate equity waterfall modeling by calculating project level IRR and equity multiple, applying multi-tiered promoted interest for GP and LP across hurdles.

Build a monthly cash flow real estate equity waterfall model that determines GP and LP equity contributions, calculates tiered cash flow splits, and applies promoted interests and IRR-based hurdles.

Create a dynamic project timeline for real estate cash flows, defining month numbers and month endings from acquisition through 132 months, preparing for deal, partnership, and loan metrics.

Create line items to compute cash flow after debt service from net operating income and debt payments, then add purchase, sale, and financing metrics to determine total levered cash flow.

Model net operating income and debt service for real estate: compute going-in NOI from purchase price and cap rate, apply monthly NOI growth, and estimate monthly principal and interest payments.

Explore purchase and sale metrics in real estate equity waterfall, calculating acquisition costs, closing costs, acquisition fees, and projected sale proceeds within the acquisition period.

Compute upfront loan proceeds as purchase price times LTV and subtract loan fees as a negative cash outflow, then project levered cash flow and prepare for the waterfall framework.

Build the preferred return table in a real estate equity waterfall model by outlining beginning balances, interest accrual, LP and GP cash flows, and final cash flow remaining.

Begin with zero balance; when cash flow is negative, compute LP contributions using LP equity percentage, keep distributions zero in acquisition, update ending balance, and accrue 8% preferred interest IRR.

Calculate LP contributions and distributions with a min function to meet the 8% IRR, cap at 95% of levered cash flow, and determine the ending balance using max with zero.

Learn how to calculate GP contributions, distributions, and cash flow remaining in a real estate equity waterfall, verify LP/GP splits, and apply promoted interest and IRR hurdles.

Copy the preferred return table to build hurdle two, strip dates and cash flows, add prior distributions and LP contributions, and compute ending balances and LP cash flow.

Calculates the beginning balance and hurdle two accrual in a real estate equity waterfall model using Excel formulas, IRR thresholds, and distributions.

Build GP distributions in the second hurdle by grossing LP distributions to 100% of cash flows, applying the GP share, and computing cash flow remaining and IRR checks.

Move on to hurdle three, adjust formulas and references, and incorporate lp contributions, prior distributions, and lp distributions with a 14% irr hurdle, preparing for hurdle four.

Copy hurdle three to hurdle four, rename it, and set up lp and gp distributions and total distributions for this tier, with cash flow remaining modeled as zero.

Track LP and GP cash flows by recording contributions and distributions for each partner, then compute net cash flows to derive IRR and equity multiple.

Compute project-level and partner-specific returns using IRR and equity multiple from levered cash flows, apply sumif for cash flow splits, and analyze promoted interest under a waterfall structure.

Learn to calculate promoted interest by tier in a real estate equity waterfall, applying tier-specific GP promote percentages to hurdle distributions, summing across hurdles for total promoted interest.

Clarify why cash-on-cash returns do not drive promoted interests in IRR-based waterfalls; ensure a full return of capital plus the targeted IRR is required before promotions accrue.

Learn to integrate the built equity waterfall into a larger pro forma by linking total levered cash flow and hold period to the target model for automatic updates.

Learn to model multiple limited partner cash flows by allocating total LP cash flow pro rata to each investor based on initial equity contributions.

Learn to model a multi-tiered IRR-based equity waterfall for real estate, including preferred returns, cash flows beyond hurdles, promoted interest, and LP-GP alignment.