The Real Estate Equity Waterfall Modeling Master Class

سرفصل های دوره

The Complete Guide To Building Dynamic Real Estate Equity Waterfall Models In Microsoft Excel

1 - Introduction

1 - Welcome

2 - What We Will Cover

3 - A Sneak Peek Into What Youll Build

4 - Who This Course Is For

5 - About The Instructor Student Success Stories

6 - Disclaimer.html

2 - Real Estate Partnership Basics

7 - Real Estate Partnership Basics

8 - The General Partner

9 - The Limited Partner

10 - GP Compensation

11 - The Waterfall Structure

3 - How an Equity Waterfall Works

12 - The Why Behind an Equity Waterfall

13 - How Equity Waterfall Structures Work

14 - Equity Waterfall Example

15 - Promoted Interest vs Cash Flow Split

16 - Measuring Partnership Investment Returns

16 - Real-Estate-Equity-Waterfall-Model-Blank.xlsx

4 - Building Out The Real Estate Equity Waterfall Model

17 - Equity Waterfall Modeling WalkThrough

18 - Modeling GP LP Cash Flow Splits

19 - Building Out The Investment Timeline

20 - Modeling ProjectLevel Cash Flows

21 - Building Out The NOI

22 - Modeling Principal Interest Payments

23 - Purchase Loan Metrics

24 - Disposition Metrics

25 - Modeling Loan Payoff ProjectLevel Cash Flows

26 - Modeling The Preferred Return

27 - Beginning Balance Preferred Interest Accrual

28 - Modeling The Preferred Return Over Time

29 - Modeling LP Contributions Distributions

30 - Modeling GP Contributions Distributions

31 - Total Distributions Cash Flow Remaining

32 - Modeling Hurdle 2

33 - Beginning Balance Hurdle 2 Accrual

34 - Modeling Hurdle 2 LP Distributions Total Cash Flow

35 - Modeling Hurdle 2 GP Distributions

36 - Modeling Hurdle 3

37 - Hurdle 3 GP Distributions

38 - Modeling Hurdle 4

39 - Total LP Cash Flows Returns

40 - Total GP Cash Flows Returns

41 - ProjectLevel Return Metrics

42 - Calculating Promoted Interest

42 - Real-Estate-Equity-Waterfall-Model-Final.xlsx

5 - Real Estate Equity Waterfall FAQ

43 - IRR Does Not Equal CashonCash

44 - How To Add What Youve Built To Another Model

45 - How To Incorporate Multiple Partners

6 - Wrapping Up

46 - Where To Go From Here

7 - Bonus Lecture

47 - Bonus Lecture The Next Step.html

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy