Real Estate Fund Distribution Waterfall (European, Preferred Return, GP Catch-Up, Carried Interest)

This template answers the question every real estate fund manager, investor and analyst asks at each distribution: who gets what, and when? It models a European (whole-fund) distribution waterfall, the most common structure in real estate private equity and closed-ended real estate funds, and turns a fund’s yearly capital calls and distributions into investor (LP) net returns and sponsor (GP) carried interest.

What the model does

You enter the fund terms from the limited partnership agreement (preferred return, GP catch-up share, carried interest) and the yearly capital called and cash available for distribution. The model then runs the waterfall year by year, on a cumulative basis:

Return of capital: investors first receive back all the capital called.
Preferred return: a hurdle compounded annually on unreturned capital and unpaid preferred return.
GP catch-up: full (100%) or partial (any share, or none), until the GP has received its target share of profits.
Carried interest split: remaining profits shared between investors and the GP.

Outputs

Gross IRR and gross multiple, before carried interest
LP net IRR and LP net multiple, after carried interest
GP carried interest, split between catch-up and final split, and its share of total profit
Gross-to-net IRR spread (the cost of carry for investors)
Called capital ratio and a chart of distributions by tier and by year

Built to be trusted

Six automatic checks: every distribution allocated, no negative tier, capital never over-returned, preferred return balance never negative, carry never above its target share, catch-up complete whenever the split tier is reached. The Dashboard shows “All checks OK”.
Transparent formulas: blue inputs, black formulas, green links between tabs, no hard-coded numbers inside formulas, no macros, no hidden or protected sheets.
Consistent timing convention, stated in the model: capital calls at the start of each year, distributions at the end.

How to use it

The workbook has six tabs: Instructions, Dashboard, Inputs, Cash Flows, Waterfall and Checks. Change the yellow input cells on the Inputs tab, type your yearly capital calls and distributions on the Cash Flows tab (11 years, year 0 to year 10), and read the results on the Dashboard. The Waterfall tab shows every step of the calculation line by line, so you can audit or explain any number to an investment committee, an auditor or an investor.

Who it is for

Real estate fund managers and sponsors preparing distribution notices or fundraising materials, investors and family offices checking a GP’s carry calculation, analysts learning how waterfalls really work, and students preparing for private equity and real estate interviews.

The example data is fictional: a 50 million value-add fund with 45.5 million called and 75.2 million distributed, giving a 1.65x gross multiple, a 12.2% gross IRR, a 10.5% LP net IRR and 5.94 million of carried interest. A PDF preview of every tab is available as a free download.

You must log in to submit a review.