Multi-Class LP Equity Waterfall Model
A free Excel equity waterfall model for deals with two LP classes and a GP. Class A senior preferred equity is paid first, then Class B and the GP share the remaining cash flow through a preferred return, a GP catch-up and two IRR promote tiers, with returns reported for each class.
What’s inside
Model Features
Two LP Classes and a GP
Class A senior preferred equity, Class B common equity and the GP each get their own cash flow and returns.
Senior Class A Preferred Return
A preferred return paid partly in cash each period, with the rest accruing until a sale or refinance.
Class A Capital and Participation
Class A is repaid its capital first, with an optional share of the remaining cash flow.
GP Catch-Up Tier
Brings the GP up to its negotiated share of profit once Class B clears its preferred return.
Two IRR Promote Tiers
The GP promote steps up as Class B clears each IRR hurdle.
Returns by Class
IRR, equity multiple and profit for Class A, Class B and the GP, with the GP promote shown separately.
Editable Assumptions and Checks
Every rate, hurdle and split is an input, and built-in checks confirm every dollar ties out.
Which version fits
How This Differs from the Single-LP Version
The standard GP catch-up waterfall has one LP class. This version adds a senior Class A that is paid its preferred return and capital before the junior Class B and the GP share in the rest, which is common when a deal brings in preferred equity alongside common LPs.
If your deal has a single LP class, use the 4-Tier IRR GP Catch-Up Waterfall instead.
How it works
How a Multi-Class LP Waterfall Works
An equity waterfall sets the order in which a deal’s cash flow is paid to its investors. With more than one LP class, the senior class is paid first and the rest of the waterfall runs on what remains.
- 01
Class A Preferred Return
Class A earns its preferred return, for example 10 percent, with part paid in cash each period and the rest accrued.
- 02
Class A Capital
Class A gets its capital back, plus any accrued return, at a sale or refinance, then an optional share of the remaining cash flow.
- 03
Class B Pref and GP Catch-Up
Class B, and the GP on its co-invest, earn their preferred return, then the GP catches up to its negotiated share of profit, for example 20 percent.
- 04
Promote Tiers
Remaining cash splits at promote percentages that step up as Class B clears higher IRR hurdles, for example 30 percent and then 50 percent to the GP.
The model shows each class’s dollars, IRR and equity multiple, with the GP promote broken out, so you can see exactly who is paid what at each level of performance.
Who it’s for
Who Uses This Model
CRE firms, developers and investors structuring a deal with preferred equity alongside common LPs, LPs testing how a senior class affects their returns, and analysts learning how multi-class waterfalls work.
Questions
Frequently Asked Questions
What is a multi-class LP waterfall?
It is an equity waterfall with more than one class of limited partner. A senior class, often preferred equity, is paid its return and capital first, and a junior class shares the remaining cash flow with the GP through the promote tiers.
How is Class A preferred equity different from Class B common equity?
Class A earns a set preferred return and is repaid first, with limited or no upside. Class B takes more risk behind Class A and shares in the profit above its preferred return alongside the GP.
Which terms can I change?
Every term is an input: the Class A preferred return and cash-pay rate, whether unpaid return accrues or compounds, Class A cash flow participation, the Class B preferred return, the GP catch-up, both IRR hurdles and splits, each class’s share of equity, distribution frequency and whether the GP co-invests.
Is this equity waterfall model really free?
Yes. Enter your name and email and the Excel template downloads with live formulas. Nothing is locked or hardcoded.
Can Reina Property Group build a waterfall to match our operating agreement?
Yes. RPG's investment team builds custom waterfalls, development models and acquisition models for CRE firms, and can review proposed JV terms before they are signed.
Custom models
Need a Waterfall Built to Your Operating Agreement?
Free templates cover standard structures. When your deal has its own hurdles, fees, clawbacks or partner splits, Reina Property Group's investment team builds the model to match the documents. See our real estate financial modeling services, or, if you are financing the deal, our capital raising advisory. More free templates are in the model library.
Free download
Download the Model
Enter your name and email below and the Excel file is yours. Live formulas, nothing locked.