Pro Forma Modeling with Excel: Investment Waterfall Distributions (May 2019 On Demand)

This third modeling course introduces students to the theory and practical construction of “waterfalls” for existing and new Microsoft Excel spreadsheet models. 


The waterfall is the method of distributing profits among partners within a transaction. In more complex transactions, profits are not distributed pari passu. (Pari passu is the proportional distribution of profits according to the percentage of capital invested—for example, with an investor who provides 80 percent of the capital receiving 80 percent of the profit.)


During the first session, students will gain a theoretical understanding of what a waterfall is, as well as be exposed to the Microsoft Excel functions required to construct a waterfall. In the second session, students will construct a waterfall from a blank spreadsheet that can be incorporated into all existing spreadsheet models.


All participants will receive access to the recording of each session. 


Students Will Learn

  • Basic types of equity partnership distributions.
  • The key inputs to the waterfall distribution from a joint venture agreement.
  • How to model variable-return distributions to the project sponsor and equity investor.
  • Advanced valuation formulas in Excel.
  • How to "bolt on" the waterfall to all existing pro forma models


Roger Staiger 


Roger Staiger Owner P(Gain), LLC

Mr. Staiger is owner of P(Gain), LLC, an international real estate investment and advisory firm with offices in Washington DC and New Castle, Nevis. P(Gain), LLC develops, owns and manages investments in the DC metropolitan area and the Caribbean. P(Gain) is best known for providing University scholarships for Nevisian graduating seniors. Also, through the Roger P. Staiger Faculty Development Fund, Mr. Staiger personally provides grants for academic research studies. On a limited basis, P(Gain) will provide expertise to clients in areas of global portfolio management, real estate financial modeling and asset repositioning. During his 20-year career Mr. Staiger has worked in a number of industries at senior levels. He was Managing Director for a Fortune 500 Energy Company’s retail commodity division, CFO for America’s Best Mid-Sized Builder 2006, and a Portfolio Manager for a large commingled pension fund in New York. Mr. Staiger holds multiple degrees including BS Electrical Engineering (Bucknell University), MBA Investments (George Washington University), MA International Transactions (George Mason University) and a MS Finance (George Washington University). Currently, Mr. Staiger holds or has held faculty positions in the real estate departments at Georgetown (Professor of Year, 2011), Johns Hopkins University (Senior Lecturer), and University of Maryland in the United States. Mr. Staiger also holds a faculty position in the MS Finance program and Finance Department at George Washington University. Mr. Staiger provides numerous capital market and economic presentations to organizations internationally. He also appears regularly on television and is often quoted in national periodicals. Mr. Staiger is recognized globally as an expert in Financial Modelling having authored the leading text on the subject, Foundations of Real Estate Financial Modelling, Routledge, 2015. Global interest and sales have warranted a second edition which is expected mid-2018.
Program Information
Program Date:
June 13, 2019
Pro Forma Modeling with Excel Part III: Investment Waterfall Distributions Session 2

Speaker Information
Roger Staiger   [ view bio ]
Pro Forma Modeling with Excel: Investment Waterfall Distributions Chapter 1
Individual topic purchase: Selected
Urban Land Institute
Attendance: 4.00
Share This
Preview Pro Forma Modeling with Excel Part III: Investment Waterfall Distributions Session 2Preview Pro Forma Modeling with Excel Part III: Investment Waterfall Distributions Session 2
You must be logged in to access ULI Subscriptions.
To continue, you need to log in to Peach New Media. If you have any questions about your account please contact us at 1-866-702-3278.
Email Address:
Member: $215.00
Full Price: $295.00