RE Waterfall Case Study

Hi guys,

Hope you are fine. I'm actually a student in a good school (but no Ivy League) and I'm doing my end-of-study internship in a little shop where they finance a lot of real estate projects. After a long time of networking, I have passed the first round of a good PERE shop (i.e between 30 and 40 in the PERE50 ranking), and i need to realize an investment case for the second round.

I litteraly don't have any idea on how to modelize the waterfall despite using Real Estate models that i downloaded on the internet.
Could you help me please?

The consigns are below:

**An equity fund has been raised to invest in residential multifamily properties. The capital contributing partners (“Limited Partners”) will contribute all capital to the fund, and will receive a return of their investment along with a preferred return before the manager of the fund (“Manager”) receives any incentive compensation (“Carried Interest”). The calculated fund‐level cash flows are included in Exhibit A, and are shown net of leverage.

Based upon the accompanying net cash flows, build a model that displays what the Manager’s carried interest would be under the
following distribution structure:

  • First, 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;

  • Second, 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;

  • Third, 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);

  • Fourth, 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;

  • Fifth, 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;

  • 20.0% to the general partner and 80.0% to the capital contributing partners.**

The Exhibit A is : Year 1: Contributions: -127 702 974 ; Distributions: 2 035 024
Year 2: Contributions: -190 652 894 ; Distributions: 9 623 472
Year 3: Contributions: -178 389 545 ; Distributions: 21 465 356
Year 4: Contributions: -157 523 ; Distributions: 31 486 823
Year 5: Contributions: 0 ; Distributions: 38 724 408
Year 6: Contributions: 0 ; Distributions: 257 133 213
Year 7: Contributions: 0 ; Distributions: 358 535 081
Year 8: Contributions: 0 ; Distributions: 323 083 224

The net yearly cash flow is the difference between contributions and distributions.

Thanks a lot for your help,
a Real Estate Student

 

Aperiam deleniti sit adipisci et facere a ex. Natus non repudiandae sed consequatur. Ducimus repellat voluptas rerum quisquam. Asperiores neque voluptatibus omnis voluptates ipsa. Voluptas corrupti ex nihil labore cumque.

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
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
kanon's picture
kanon
98.9
6
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
CompBanker's picture
CompBanker
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...”