ULI Online Learning Services Provided by Peach New Media
Peach New Media
1100 Circle 75 Parkway Suite 900
Atlanta, GA 30339
1 (866) 702 3278
support@peachnewmedia.com
Welcome!   Login

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.
 

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
Program Information
Program Date:
June 13, 2014
Pro Forma Modeling with Excel Part III: Investment Waterfall Distributions Session 1
Speaker Information
Roger Staiger   [ view bio ]
Pro Forma Modeling with Excel Part III: Investment Waterfall Distributions Session 2
Speaker Information
Roger Staiger   [ view bio ]
Individual topic purchase: Selected
Urban Land Institute
Attendance: 4.00
Share This
Preview
Preview Pro Forma Modeling with Excel Part III: Investment Waterfall Distributions Session 1Preview Pro Forma Modeling with Excel Part III: Investment Waterfall Distributions Session 1
Products
Streaming
Public Member: $195.00
Member: $215.00
Public Nonmember: $250.00
Full Price: $295.00