Worksheet Assignment: Waterfall Distribution and Impact of Sponsor Promote
Belmont Real Estate Fund II (BRE II) is an opportunistic real estate fund that invests in all five real estate sectors - Industrial, Office, Apartments, Retail and Hotels. The Fund invested $400 million in equity. BRE II was projected to return a 20%+ IRR and a 4.0x+ equity multiple. The fund terms are as follows:
i. European Waterfall
ii. LP Preferred Return of 10%
iii. Catch up is 50/50
iv. Carried Interest split is 80/20
v. Management Fees are outside the commitment (they do not need to be paid back before carried interest is paid)
The Fund was a 10-year fund and was fully liquidated after Year-10 for total proceeds of $1,700 million. Answer the following.
i. After Year-10, calculate the fund's value based on the hurdle (10%) that must be achieved before the GP participates in any carried interest.
ii. At the Catch-up of 50/50, both the GP and LP get 50% of the following amount, which equals what?
iii. Now that the 80/20 split of profits has been achieved what are the remaining profits to be split 80/20? What is the LP portion and what is the GP portion?
iv. What are the total dollars and percentage of the LP and GP profits?
v. What is annualized return of the BRE II?
vi. What is the Breakeven IRR on BRE II (the IRR that gets GP to full 20% carried interest)?
vii. What is the annualized return for the LPs?
viii. What is the impact of the sponsor promote on the gross return of BRE II?
ix. What is the gross equity multiple (TVPI -Total Value to Paid In) for BRE II?
x. What is the net equity multiple for BRE II?
Format your assignment according to the following formatting requirements:
i) The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
ii) The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
iii) Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.