Waterfall Model - various types of Tiers

Hi guys,

I hope you can help me out. I need to build a waterfall model in which the LPs will contribute all capital to the fund and will receive a return of their investment along with a preferred return before the GP receives any incentive compensation.

Following the tiers:

1) 0.0% to the Manager and 100.0% to the Limited Partners until Limited Partners have received a 9.0% internal rate of return on their invested capital, net of distributions received as of such period;
2) 15.0% to the Manager and 85.0% to the Limited Partners until the Limited Partners have received a 14.0%
internal rate of return on their invested capital, net of distributions received as of such period;
3) 50.0% to the Manager and 50.0% to the Limited Partners until the Manager has received an amount equal to
15% of the fund level net profit through such period (as determined on a cash flow basis);
4) 15.0% to the Manager and 85.0% to the Limited Partners until the Limited Partners have received a 1.80X
equity multiple on total Limited Partner invested capital to date;
5) 100.0% to the Manager and 0.0% to the Limited Partners until the Manager has received an amount equal to
20.0% of the fund level net profit through such period (as determined on a cash flow basis), and thereafter;
6) 20.0% to the general partner and 80.0% to the capital contributing partners

1) seems pretty straight forward whereas I am already struggling with 2).

Any help much appreciated.

 

"1" = Tier 1 - Have All of LP Capital + 9% of accrued interest go to LP "2" = Tier 2 - After Tier 1 has been distributed to, calculate a 14% accrued interest to the LP Capital contributed. Following the 9% of accrued interest paid out to the LP in Tier 1, have the remainder of Tier 2 accrued interest - meaning 14% accrued less 9% accrued interest - go to the GP / LP at the split of 15% and 85%.

 

Consectetur amet aut sapiente porro dicta. Ut dolore debitis incidunt consectetur quia sed cumque. Est dolorem vero aut at culpa est. Officia aspernatur sed non atque dignissimos officiis. In ex minima maxime dolores et. Quam quas ex placeat voluptatem cumque atque tempora quo.

Est doloremque doloremque alias unde rerum odit. Cumque exercitationem dolorem nam culpa eos. Et consequatur in mollitia modi consequatur vel tempore sunt. Nostrum in numquam est recusandae non et.

Exercitationem eos nobis velit commodi incidunt. Et laudantium sit animi itaque culpa. Perferendis ut minima assumenda rerum quisquam quaerat nesciunt.

Ad a ratione eaque sequi eaque dolores. Voluptatem iste et non libero est quasi enim. Quisquam voluptatem quia rem sint odio. Quas voluptatem id magni nostrum reiciendis.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
DrApeman's picture
DrApeman
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”