Watch Me Build An American-Style Equity Waterfall Model скачать в хорошем качестве

Watch Me Build An American-Style Equity Waterfall Model

In this Watch Me Build tutorial, follow along as I build a multi-tier, American-Style real estate equity waterfall model. This is a follow-up to my Watch Me Build of a European-Style waterfall model. Download the sources files here: https://www.adventuresincre.com/watch... 0:00 - Introduction to American Style Real Estate Equity Waterfall Model 4:34 - Starting the Excel Build: Overview of the Waterfall Template 10:06 - Detailed Explanation of Preferred Return, Hurdle Rate, and Promote in Waterfall Model 15:13 - Inputting Property Level Net Levered Cash Flow and Beginning Waterfall Calculations 18:27 - Calculating Cash Flow Available for Distribution and LP's Starting Balance 22:04 - Completion of Preferred Return Tier and Transition to Waterfall at Capital Event 26:34 - Detailed Calculations for LP and GP Distribution at Capital Event 30:04 - Adjusting Starting Balance for Following Periods and Verifying IRR Calculations 33:40 - Tier Two Calculations for LP and GP Distribution at Capital Event 36:23 - Final Tier Cash Flow Calculations and Distribution for LP and GP 40:06 - Final Error Check and Summary of LP and GP Cash Flows 42:20 - Conclusion and Additional Notes on American Style Waterfall Model Watch Me Build a (European-Style) 3-Tier Waterfall: https://www.adventuresincre.com/watch... View other Watch Me Build tutorials: https://www.adventuresincre.com/re-ed... Learn to model like a deal-seasoned pro: https://www.adventuresincre.com/accel... SUBSCRIBE: https://www.youtube.com/user/sburtonh...