Waterfalls in Asset Management....

What's the best way to model a waterfall in Asset Management? I made the switch over from acquisitions, so I know how to run a waterfall if it's only forward looking....

However, now that I'm in Asset Management, it seems like a messy job piecing together historicals and projections together to run through a waterfall. Anyone have a good clean way to do this?  

6 Comments
 
Most Helpful

Should be pretty straightforward. Bring your actuals into the cash flow up to X date, this date being latest period actuals are available for, and continue to take the forecast from that point on. Sense check variances vs. overall budget, make sure you’re not missing a big payment about to go out which was in the forecast just prior to X date but hasn’t hit the actuals yet.

Pull your actuals in from a separate underlying sheet where they’re hardcoded rather than hardcoding into the same cash flow where you project forecasts, makes it much easier to quickly compare historic projections vs actuals and sense check variances.

 

Quia consequatur adipisci voluptatem reprehenderit ratione. Illum ut aut excepturi ut. Voluptatibus id vitae dolore consequatur accusamus dolores. Sit enim laudantium deserunt non eos minima. Amet optio error omnis voluptas sit sapiente accusamus.

Aut vitae incidunt nemo ut velit ut. Labore dolor et consectetur pariatur assumenda doloribus fugit. Sit ipsum voluptatem vel et repellat. Suscipit quod voluptatum minima dolorem officiis officia.

Repellendus aut non earum. Similique iure accusamus modi ducimus qui nesciunt qui. Est ipsa molestias cupiditate blanditiis corrupti id veniam. Dignissimos quo atque assumenda illo.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $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
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
GameTheory's picture
GameTheory
98.9
6
DrApeman's picture
DrApeman
98.9
7
CompBanker's picture
CompBanker
98.9
8
dosk17's picture
dosk17
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
bolo up's picture
bolo up
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...”