Please Check My Waterfall Template
Hey guys,
I was wondering if anybody could take a look at my waterfall template that is based off of the youtube videos from A.CRE. I came from a large company and now work at a very small one, so I no longer have the joys of having my coworkers peer review my work!
I was wondering anybody here could take a quick look at my waterfall google sheet template . I have not fully automated it yet as I want to ensure the math is correct.
I have a tab for monthly and quarterly. Right now, I am hardcoding in the final amount of cash available for distribution in cell AL20 for month 36. If you are going to adjust the disposition month, then make sure in the return summary you adjust the column it is summing from.
Thanks for the help, and if this is accurate, please feel free to use and share.
Thanks,
Based on the highest ranked content on WSO, it's great that you're seeking peer review for your waterfall template. It's a smart move, especially when transitioning from a large company to a smaller one where resources may be more limited. Here are a few pointers to consider when reviewing your waterfall model:
Accuracy of Calculations: Ensure that the formulas for calculating distributions are correct. This includes the preferred return, return of capital, and the splits between the sponsor and investors at various hurdle rates.
Automation: While it's important to verify the math first, once you're confident in the calculations, automating the process will save time and reduce the risk of manual errors. Excel functions or Google Sheets equivalents like
IF
,VLOOKUP
, orINDEX MATCH
can be very helpful here.Flexibility: Your model should be able to handle changes in assumptions without needing significant rework. This includes varying investment periods, different cash flow scenarios, and changes in hurdle rates.
Error Checks: Include error checks to ensure that inputs are within expected ranges and that the outputs make sense (e.g., total distributions do not exceed total available cash).
Documentation: Make sure to document your assumptions, sources of inputs, and any instructions needed to use the model correctly. This is crucial for anyone who might review or use your model in the future.
Sensitivity Analysis: Consider adding a sensitivity analysis to show how changes in key assumptions impact the returns.
If you're looking for a detailed review, you might want to consider posting on the WSO forum or using the WSO Resume Review service, where professionals can give you more tailored feedback. Remember, a well-structured and accurate waterfall model is a powerful tool in real estate finance, so it's worth getting it right. Good luck!
Sources: Waterfall template attached, Best way to learn Real Estate Waterfalls?, Waterfall Model Help, Waterfall for long term hold
Bump for this hardworking stud
Don't have time to fully audit it and tell you what's off at this time, but a few quick things I noticed.
1) B14 is subtracting 16.56M from LP total profit (C4). But row 21 shows them only contributing 7.46M
2) Same as the above only for the GP calc in C14 and cell C5 and row 22
3) Pertaining to the above, Rows 20-22 don't tie to the LP/GP contributions shown in C4/C5
For the above I recognize you're hard coding numbers for time being, just make sure these tie out when the models dynamic.
Otherwise, I checked Hurdle 1 calcs and distributions in column AL and that appears accurate. Will come back to this unless someone gets you more robust feedback sooner.
Enim sequi cupiditate ut necessitatibus est. Voluptas non iusto soluta consequatur. Ut debitis totam odit aut dolor sed.
Recusandae explicabo possimus quod nostrum facere rem eius repellat. Illo reprehenderit veritatis deserunt in et accusantium.
Id sed et esse iste vel. Itaque adipisci quae aut quasi id. Perspiciatis deserunt deleniti debitis ipsam non. Vel odio suscipit odit ullam eligendi cupiditate. Enim accusantium aperiam excepturi quasi. Voluptate assumenda ut voluptatem rerum expedita tenetur.
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...