
Originally published: 10/10/2022 08:29
Last version published: 16/11/2026 08:51
Publication number: ELQ-30906-3
View all versions & Certificate
Last version published: 16/11/2026 08:51
Publication number: ELQ-30906-3
View all versions & Certificate

Distribution Waterfall Models - PE, VC, Real Estate, Project Finance
Investor Distribution Waterfall Excel template for private equity, real estate, venture capital and project finance investments.
private equityventure capitalreal estatedistribution waterfallinvestorsinvestor cash flowsirrcash on cashinvestment multipleproject finance
Description
An Investor Distribution Waterfall is a framework used to determine how investment cash flows and exit proceeds are allocated among different classes of investors, sponsors and partners. The waterfall establishes the order and priority of distributions, typically incorporating concepts such as return of capital, preferred returns, IRR hurdles, catch-up provisions, carried interest, promotes and residual profit-sharing. These structures are commonly used in private equity, real estate, venture capital, project finance and other alternative investments where different investors have different economic rights.
This Investor Distribution Waterfall Template provides a collection of practical waterfall models covering a range of common investment structures and asset classes. Each model is designed to demonstrate how contributions, operating cash flows, investment proceeds and exit proceeds are allocated among investors based on predefined contractual terms.
The workbook includes private equity LP / GP waterfalls with and without catch-up provisions, a real estate IRR hurdle and promote structure, preferred equity redemption mechanics, private equity fund-level American and European waterfalls, a project finance CFADS waterfall and a venture capital exit waterfall. The models calculate investor-level distributions, return of capital, preferred returns, carried interest or promote, IRR, MOIC and other relevant return metrics, together with supporting reconciliation and integrity checks.
Template Structure:
• Private Equity – Preferred Return (No Catch-Up)
Two-tier LP / GP distribution waterfall in which cash is allocated between the Limited Partner and General Partner until the LP receives its invested capital and cumulative preferred return. Remaining proceeds are then distributed according to a predefined residual profit-sharing percentage. The model calculates LP and GP cash flows, distributions, IRR and investment returns.
• Private Equity – Preferred Return + GP Catch-Up
Multi-step private equity waterfall incorporating return of LP capital, an LP preferred return, return of GP capital, a GP catch-up and a final residual profit split. The model allows users to define the preferred return, GP catch-up percentage and ultimate LP / GP sharing ratio and calculates the resulting economics for both parties.
• Real Estate – IRR Hurdle Promote
Real estate partnership waterfall based on investor IRR hurdles and sponsor promote mechanics. The model supports multiple General Partners and Limited Partners and distributes project cash flows across successive return tiers. As specified IRR thresholds are achieved, the sponsor's share of incremental profits increases through the promote structure. Outputs include distributions, IRR and payback metrics for each investor.
• Real Estate – Preferred Equity Redemption
Preferred equity waterfall designed to evaluate the redemption or buyout of a Preferred Equity Partner by the Common Equity Partner. The model incorporates preferred return accrual, redemption multiples, minimum IRR protection, appreciation participation and alternative redemption years. It compares the economics of both partners under each possible redemption scenario and calculates MOIC, IRR and redemption funding requirements.
• Private Equity – Fund Waterfall (American vs. European)
Fund-level private equity waterfall comparing European / whole-fund and American / deal-by-deal carried interest structures. The model incorporates LP and GP commitments, portfolio investments, management fees, preferred return, GP catch-up, carried interest, carry escrow and clawback provisions. It calculates LP net returns, GP economics, TVPI, carry earned and the timing of carried interest under both waterfall methodologies.
• Project Finance – CFADS Waterfall
Project finance cash flow waterfall showing the priority of project cash flows from Cash Flow Available for Debt Service (CFADS) through senior debt service, reserve funding, subordinated debt repayment and equity distributions. The model incorporates senior and subordinated financing, DSRA requirements, debt service coverage ratios, cash sweeps and distribution lock-up tests. Outputs include equity IRR and MOIC, DSCR, LLCR, debt repayment and project-level distribution metrics.
• Venture Capital – Exit Waterfall
Startup capitalization and exit waterfall covering multiple financing rounds, including Seed, Series A, Series B and Series C investors. The model calculates fully diluted ownership, liquidation preferences, cumulative preferred dividends, participating and non-participating preferred shares and as-converted proceeds. It evaluates investor distributions across different exit valuations and calculates investor-level IRR and cash-on-cash returns.
Detailed guidance explaining the purpose, key assumptions, required user inputs and waterfall logic for each model is included in the workbook.
Help & Support
Committed to high quality and customer satisfaction, all our templates follow best practice financial modeling principles and are thoughtfully and carefully designed, keeping the user’s needs and comfort in mind.
No matter if you have no experience or you are well versed in finance, accounting, and the use of Microsoft Excel, our professional financial models are the right tools to boost your business operations!
If you however experience any difficulty while using this template and you are not able to find the appropriate guidance in the provided instructions, please feel free to contact us for assistance.
If you need a template customized for your business requirements, please e-mail us and provide a brief explanation of your specific needs.
An Investor Distribution Waterfall is a framework used to determine how investment cash flows and exit proceeds are allocated among different classes of investors, sponsors and partners. The waterfall establishes the order and priority of distributions, typically incorporating concepts such as return of capital, preferred returns, IRR hurdles, catch-up provisions, carried interest, promotes and residual profit-sharing. These structures are commonly used in private equity, real estate, venture capital, project finance and other alternative investments where different investors have different economic rights.
This Investor Distribution Waterfall Template provides a collection of practical waterfall models covering a range of common investment structures and asset classes. Each model is designed to demonstrate how contributions, operating cash flows, investment proceeds and exit proceeds are allocated among investors based on predefined contractual terms.
The workbook includes private equity LP / GP waterfalls with and without catch-up provisions, a real estate IRR hurdle and promote structure, preferred equity redemption mechanics, private equity fund-level American and European waterfalls, a project finance CFADS waterfall and a venture capital exit waterfall. The models calculate investor-level distributions, return of capital, preferred returns, carried interest or promote, IRR, MOIC and other relevant return metrics, together with supporting reconciliation and integrity checks.
Template Structure:
• Private Equity – Preferred Return (No Catch-Up)
Two-tier LP / GP distribution waterfall in which cash is allocated between the Limited Partner and General Partner until the LP receives its invested capital and cumulative preferred return. Remaining proceeds are then distributed according to a predefined residual profit-sharing percentage. The model calculates LP and GP cash flows, distributions, IRR and investment returns.
• Private Equity – Preferred Return + GP Catch-Up
Multi-step private equity waterfall incorporating return of LP capital, an LP preferred return, return of GP capital, a GP catch-up and a final residual profit split. The model allows users to define the preferred return, GP catch-up percentage and ultimate LP / GP sharing ratio and calculates the resulting economics for both parties.
• Real Estate – IRR Hurdle Promote
Real estate partnership waterfall based on investor IRR hurdles and sponsor promote mechanics. The model supports multiple General Partners and Limited Partners and distributes project cash flows across successive return tiers. As specified IRR thresholds are achieved, the sponsor's share of incremental profits increases through the promote structure. Outputs include distributions, IRR and payback metrics for each investor.
• Real Estate – Preferred Equity Redemption
Preferred equity waterfall designed to evaluate the redemption or buyout of a Preferred Equity Partner by the Common Equity Partner. The model incorporates preferred return accrual, redemption multiples, minimum IRR protection, appreciation participation and alternative redemption years. It compares the economics of both partners under each possible redemption scenario and calculates MOIC, IRR and redemption funding requirements.
• Private Equity – Fund Waterfall (American vs. European)
Fund-level private equity waterfall comparing European / whole-fund and American / deal-by-deal carried interest structures. The model incorporates LP and GP commitments, portfolio investments, management fees, preferred return, GP catch-up, carried interest, carry escrow and clawback provisions. It calculates LP net returns, GP economics, TVPI, carry earned and the timing of carried interest under both waterfall methodologies.
• Project Finance – CFADS Waterfall
Project finance cash flow waterfall showing the priority of project cash flows from Cash Flow Available for Debt Service (CFADS) through senior debt service, reserve funding, subordinated debt repayment and equity distributions. The model incorporates senior and subordinated financing, DSRA requirements, debt service coverage ratios, cash sweeps and distribution lock-up tests. Outputs include equity IRR and MOIC, DSCR, LLCR, debt repayment and project-level distribution metrics.
• Venture Capital – Exit Waterfall
Startup capitalization and exit waterfall covering multiple financing rounds, including Seed, Series A, Series B and Series C investors. The model calculates fully diluted ownership, liquidation preferences, cumulative preferred dividends, participating and non-participating preferred shares and as-converted proceeds. It evaluates investor distributions across different exit valuations and calculates investor-level IRR and cash-on-cash returns.
Detailed guidance explaining the purpose, key assumptions, required user inputs and waterfall logic for each model is included in the workbook.
Help & Support
Committed to high quality and customer satisfaction, all our templates follow best practice financial modeling principles and are thoughtfully and carefully designed, keeping the user’s needs and comfort in mind.
No matter if you have no experience or you are well versed in finance, accounting, and the use of Microsoft Excel, our professional financial models are the right tools to boost your business operations!
If you however experience any difficulty while using this template and you are not able to find the appropriate guidance in the provided instructions, please feel free to contact us for assistance.
If you need a template customized for your business requirements, please e-mail us and provide a brief explanation of your specific needs.
This Best Practice includes
Excel Financial Model
Further information
Provides a collection of practical waterfall models covering a range of common investment structures and asset classes.
