Waterfall template attached

All - I've gotten a couple requests to sketch out/submit a waterfall model that handles various assumptions. Thus attached is a quick and back of envelope approach to a JV development deal. Blue font is input -- I tried to add comments that provide a more detailed explanation of the input and reason for it. What started this was the regular question about multiple equity contributions from more than 1 investor. Please feel free to respond below in the thread with any questions, and I will answer them best I can.

ODDITIES WORTH MENTIONING:

  1. The only unusual section is T4-V8...where I attempted to calculate the would be splits depending on what the equity contribution is. Meaning, you can tweak the equity contributions without haven't to change the % splits in the hurdle every time. The last term sheet I had used a 10% equity contribution and applied the promote % outlined in cell T6-V6. Row 7, and the total LP splits for each hurdle in Row 8, will automatically update as the equity % is changed for the LP. Of course if you want to do away with this, or I was wrong in the approach, you can just override the blue values in column C & D as you work through the hurdles.
  2. Preferred Return rate calculation aka compounding vs non-compounding. Select from the drop down box in cell B23...If compounding is selected, select the rate of compounding from cell E23. This will then drive the effective rate the investors will actually receive, utilizing the +EFFECT function.
  3. Return of Equity: CEll B47 is a drop down that drives the return of equity. Simply, it determines if one wants a return ON equity or a return OF equity. Some term sheets stipulate that equity can only be returned during a capital event. Even if operating cash flow is absolutely gangbusters, no equity will be returned. The standard entry would be "both" which implies that regardless of where the cash flow comes from, if the prior hurdles are paid down and available funds are leftover, it will go to pay down equity. There is also the cash flow only selection, which I have never seen/modeled but heard of...disregard that selection for this model I'd recommend.
AttachmentSize
Office spreadsheet icon WSO Waterfall example314.5 KB

Comments (3)

Feb 1, 2019

Hi Post hoc ergo propter hoc, hope I can help. Do any of these links cover what you're looking for:

  • Stock Pitch Sample Template- Proven Examples to Help Ace Your Interview access to 20+ more sample pitches with actual templates? The WallStreetOasis Hedge Fund Interview Prep ... goes into it courtesy of the WallStreetOasis Video Library and a PDF (attached at the bottom) that ... includes a visual summary as well as an example. Stock Pitch Example Ann is an industry veteran with plenty ...
  • Private Equity Resume Template- Official WSO CV Example Attached to the bottom of this post, you will find the Wall Street Oasis private equity resume ... template for experienced professionals, used by the WSO paid service and thousands of candidates to ... those competitive buyside jobs in private equity and hedge funds, we have a great sample resume you can ...
  • Investment Banking Resume Template- Official WSO CV Example charge (attached to this post below). After seeing members consistently reference other resume templates ... Attached to the bottom of this post, you will find the Wall Street Oasis Investment Banking Resume ... Template for undergraduate students, used by the WSO paid service and thousands of candidates to ...
  • Attached- Equity Research Template Examples I have attached a few BB / MM examples from JPM, GS, BMO, MS, BAML, RBC, Nomura. Enjoy! https:// mm. ... Hi WSO, A lot of people have asked me for equity/industry analyst report templates. In response ...
  • PE Waterfall- Modelling Catch-up differently, here's a general idea of how the waterfall works: Waterfall Model Example To help you build ... your custom models, you can start with the official WSO Private Equity Waterfall Excel template ... . Distribution Waterfall Template Additional Reading WSO Private Equity Forum American vs European Waterfall ...
  • IRR Waterfall/Promote Question This came from an actual JV proposal with sample cash flow, so I wanted to see if this was common ... the cash flow exhibit attached to the JV term sheet, it shows something different. It shows the $200K ...
  • Anonymous investment teaser example templates online and read up on what to include (company overview, investment highlights, summary of ... get some idea for presentation, would be great if someone could provide links to some examples ... three pages, Here is an example of a shorter investment teaser. From the The Corporate Finance Institute ...
  • Consulting Resume Template Attached to the bottom of this post you will find the Wall Street Oasis Consulting Resume Template ... for example. The more related to consulting it is, the better. Leader: Ideally, you have some sort of ... a resume. With our resume template, you can reduce 5-20% of the content and up the font size by a point. ...
  • More suggestions...

Hope that helps.

Feb 4, 2019

Bot -- I was actually merely posting a completed model to help with any other users who have questions about modelling waterfall structure. I'll check back when I can to answer and questions about how to model a waterfall JV structure correctly, but seems like it's mostly there to download and glean from there.

Feb 7, 2019
Comment