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?
| +59 | Development Fees > Sponsor Equity Contribution | 18 | 12h |
| +57 | What's an Undergrad to Do? | 21 | 2d |
| +42 | Advice to Job Seekers: Don't Sleep on Asset Management | 13 | 1d |
| +24 | Mid Sized REPE firm for first job in RE | 9 | 13h |
| +10 | Full-Time RE Acquisitions Analyst Recruiting - Class of 2028 | 4 | 1d |
| +3 | Tishman Speyer Debt Fund | 0 | 4d |
| +3 | Debt fund jobs | 1 | 3d |
| +3 | Thoughts on CIM Group today? | 11 | 23h |
| +3 | LDG Development wins $36.3M Lawsuit | 1 | 10h |
| +1 | Equity Waterfall - Market Standard | 2 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Same waterfall, just have a budget to actual for your cash flow proforma. The only thing that would change would be your expected cash flow, the structure should not change from the JV docs
Editing because it sounds like you get it conceptually. I think you just have to hardcode in the historical data for year 1, year 2, etc (or on a monthly basis).
If your historical are more detailed than your model, you can “code” each line item to match your original model
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.
Why did you switch jobs?
As has been mentioned, the waterfall is consistent. The historicals will be the actual contributions and distributions that has occurred. On go-forward projections, I'd loop in your reforecasted pro-forma projections along with the assumed reversion value. If applicable, account for your cash balance at sale as well. Good luck!
Ullam dolore eum sit fugiat. Deserunt quasi eos ut sequi qui cum dolores. Ab labore officiis nobis laudantium fuga.
Et praesentium maxime a libero corrupti. Consequatur delectus non asperiores nihil. Id et aliquid rerum ullam.
Dolor quaerat reiciendis aperiam officiis et. Corrupti numquam temporibus nemo sunt sint. Quas omnis sint enim id consequatur. Natus reprehenderit delectus quaerat iure. Dolorem fugiat ratione quae ut et doloribus. Quam in accusamus eaque maxime vel.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...