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
June 13, 2019
Urban Land Institute
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.
Full Price: $295.00