DOI

10.3905/jpmi.2026.009

Abstract

KEY TAKEAWAYS:

Using Excel’s =LAMBDA and =MAKEARRAY functions allows for the creation of user-defined functions for generating waterfall calculations for a private equity deal, without needing VBA or macro programming.

The three primary waterfall functions determine the waterfall distributions and related performance metrics, including internal rates of return (IRRs) and multiples of invested capital (MOICs), both with and without carried interest.

Copying the cell that uses a waterfall function from the source file to a new file automatically transfers the function and its related intermediate functions. As a result, these functions can be used immediately in other models.

Document Type

Article

Publication Date

9-8-2025

Comments

Please do not cite without permission.

Publisher Statement

The copyright in the Conent, (unless otherwise indicated), its contents, including all information, graphics, code, text and design are owned by With Intelligence and should not be reproduced or distributed without permission.

Only the abstract for this article is available here.

Please do not cite without permission.

Click below to download supplemental content.

PE-WATERFALL.xlsx (25 kB)

Share

COinS