The Advanced Real Estate Equity Waterfall Modeling Class

Understand real estate partnerships: the general partner manages acquisitions and exits, while the limited partner provides 90 to 99% of equity as a passive investor.

Explore the makeup of an equity waterfall, detailing preferred return and promoted interest, pro rata (pari passu) cash flows, and how GP sweat equity aligns GP and LP interests.

Explore two JV equity partnership structures—deal-by-deal and discretionary fund—and learn how preferred returns, promoted interests, and liquidity timelines shape real estate waterfall models.

Understand the cash-on-cash based preferred return waterfall, where promoted interest accrues during operations as LPs hit a target cash-on-cash return, with sale proceeds covering remaining returns after capital recovery.

Explore GP/LP cash flow calculations in an advanced real estate equity waterfall model, detailing cash flow from operations and sale, preferred return, and promoted interests.

Compute gp and lp equity contributions from total levered cash flow in the acquisition period using if logic and zero placeholders. Track distributions and cash flow from operations across months.

Compute the beginning balance from total LP contributions, conditionally reset to zero after sale, and build a days-in-year framework with hlookup to calculate starting equity and preferred interest accrual.

Model monthly preferred interest accrual with hold-period checks and hlookup to pull starting equity by year. Pro-rate by days elapsed and apply same lp contributions formula to prepare distributions.

Learn to calculate LP distributions in a real estate equity waterfall, enforcing a 6% cash on cash return and recognizing promoted interest when cash flows exceed threshold.

Calculate total LP cash flow and GP distributions, then determine cash flow remaining. Apply GP promote using preferred return concepts and cash flow splits in real estate equity waterfall modeling.

Compute cash flow from sale by applying return of capital and unpaid preferred interest, then allocate to lp and gp distributions under the promoted interest framework.

Build and validate checks in the real estate equity waterfall model to ensure capital plus preferred return distributions to LPs and GP. Apply conditional logic and formatting for consistency.

Build and validate the preferred cash-on-cash check and project-level cash-on-cash returns using sumif and sumifs, analyzing LP and GP distributions by year.

Compute lp and gp cash flows from monthly contributions and distributions, total them, and validate against project level cash flows using an absolute difference check.

Compute project-level returns by calculating the IRR of levered cash flows with Excel's IRR function, then derive equity multiple and cash-on-cash using sumif and averageif.

Explore promoted interest and gp/lp returns in a cash flow waterfall, including IRRs, equity multiples, and average cash on cash.

Explore a dual preferred return waterfall that uses IRR and equity multiple hurdles to trigger promoted interest only when both targets are surpassed.

Model GP/LP cash flow splits, promoted interest, and equity contributions using IRR and equity multiple based preferred returns in real estate waterfall calculations.

Build the acquisition period preferred return table, calculating ending pref balance and ending equity multiple with IRR-based returns, while reconciling LP and GP contributions and distributions.

Master beginning balances and preferred interest accrual in real estate equity waterfalls using Excel formulas. Build robust, copy-paste capable logic for hold periods, IRR targets, and LP contributions.

Compute LP distributions using nested max and min functions to meet IRR-based and equity-multiple-based preferred returns; apply pari passu cash flows and cap distributions at $6.65 million.

Build GP distributions from LP preferred returns using pari passu logic, then verify LP and GP IRR and equity multiples with Excel checks and conditional formatting.

Calculate cash flows above the preferred return, apply the GP/LP split with promoted interest, and compute LP and GP distributions to derive project level returns.

Explore promoted interest and project-level returns by calculating project-level IRR and equity multiples for GP/LP structures, showing how distributions above preferred returns drive investor outcomes.

Explore the gp catch-up waterfall model, where all cash flows go to lp up to an irr-based preferred return, then gp and lp split until gp caps at 20 percent.

Calculate GP and LP cash flow allocations on the GP catch up tab, determine returns, and set up equity contributions under 8% preferred, 50/50 catch up, and 20% GP share.

Set beginning balances to zero at acquisition, compute preferred interest accrual, LP and GP contributions and distributions, and derive ending balances and cash flow remaining with max/min safeguards.

Calculate gp distributions by dividing lp distributions by lp cashflow and multiplying by the gp cashflow percentage up to the preferred return, then assess irrs and catch-up provisions.

Learn how to model LP and GP distributions in the catch-up tier, ensuring GP achieves 20% of total distributions using cash flow remaining and tiered cash flows.

Calculate and verify the 80/20 cash flow split between LP and GP by checking total cash flows up to the catch-up, including preferred return and catch-up tiers.

Compute LP cash flows by linking contributions to equity and summing distributions across the preferred return, catch up, and cash flows over catch up tiers, mirroring GP cash flows.

Calculate project and lp/gp irrs and equity multiples from levered cash flows; backsolve promoted interest for catch-up tiers and anticipate a clawback.

Learn the gp catch-up with clawback waterfall model, including promoted interest, lp preferred return, and fund-level irrs. Compare american versus european style waterfalls and see a practical clawback example.

Apply gp/lp cash flow calculations in the advanced real estate equity waterfall model, solving for lp cash flow percentages, lp equity contributions, and clawback dynamics.

Calculate the preferred interest accrual and LP/GP cash flows in a real estate equity waterfall, using IRR-based accrual, month-by-month balances, and fund life distributions.

Model LP and GP cash flows with min/max logic to enforce the 8% preferred return, compute distributions, track IRR, and apply conditional formatting for promoted interests.

Learn to build catch-up distributions in an LP/GP real estate equity waterfall, calculating LP and GP shares, cash flow remaining, and the 20% cap using min and sum functions.

Compute LP and GP distributions from cash flows over the catch-up period in a real estate equity waterfall, then begin LP clawback calculations using beginning and ending balances.

Calculate LP clawback and promoted interest using IRR checks, catch-up and over catch-up tiers, and fund liquidation timing to ensure GP/LP distributions align with the 8% preferred return.

Finalize GP cash flow and return metrics by calculating contributions, distributions, catch-up, and clawback across GP and LP, then compute IRRs and equity multiples.

Learn to tailor JV equity partnership structures and navigate diverse equity waterfall hurdles, using cash-on-cash, IRR, and equity multiple preferred returns to align investor and GP incentives.