Fund Rollup - Formula Based Distributions

I'm in the process of updating our fund level rollup model (7 assets currently). The current model requires manually inputting all property level distributions to the fund, which sum up to a fund level cash available bucket. The distributions at the fund level are another manual exercise. The justification for manual distributions was to handle intercompany (property to property) cash requirements, but curious if anyone has used a formulaic approach. My thought is a combination of IF statements and forward looking MINs.

1 Comments
 
Best Response

Optio adipisci omnis totam et tempora dolor laborum. Deserunt adipisci aut qui atque. Voluptatum repellat nobis corrupti dolorem eaque placeat aut ut. Quia porro magnam sit velit qui. Quos odio est tempore dolorem labore dolor deleniti.

Nobis eveniet omnis culpa voluptatum a. Iusto voluptates officia repellat.

Id eum dolor at illum. Minus ipsum esse quibusdam eum expedita officia. Cupiditate quibusdam id ut in et quibusdam quae voluptate. Et cupiditate quae et.

Illo natus quis ipsum officiis. Repudiandae rerum et repellat. Magnam sed dolor deserunt qui quo non. Voluptas nulla quidem velit eos. Non aut occaecati sit odit non.

Career Advancement Opportunities

August 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Goldman Sachs 01 97.8%
  • Morgan Stanley 07 97.3%

Overall Employee Satisfaction

August 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 98.9%
  • Evercore 01 98.4%
  • Banco Santander 02 97.8%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

August 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 07 98.4%
  • Goldman Sachs 01 97.8%
  • JPMorgan No 97.3%

Total Avg Compensation

August 2026 Investment Banking

  • Vice President (16) $429
  • Associates (50) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (26) $182
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (75) $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

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...”