An in depth walkthrough of the Development model. This example is a Mixed Use Residential/Commercial, but the model can be any combination of Residential and/or Commercial and/or Hotel.
00:00 Intro
01:06 LP/GP Cash Flow
02:05 Cash In Cash Out (Show Rows w/ Data)
02:58 Summary Analysis
04:08 Uses and Sources
04:55 Cash Flow from Operations
05:22 Exit Analysis
05:36 Distributable Cash
05:47 Return Breakdown
06:05 Waterfall Detail/Project Costs/UnTrended Analysis
06:21 P&Ls/Debt Summary
06:38 What If Scenario Analysis
07:21 Various Charts
07:47 Inputs Intro
08:29 Development Phases
08:55 Units
09:51 Lease-Up Schedule
10:30 Revenues
11:13 OPEX
12:00 Inflation/Vacancies/Bad Debt/Asset Mgmt Fee
12:24 Land Acquisition/Horzontal Dev
12:44 Hard Costs
13:23 Soft Costs
14:10 Single Date Exit/Multi-Date Exit
15:45 Construction Loan
16:03 Mezz Debt/Grants/Equity Capital Contributions
16:36 Uses & Sources Summary
17:04 Draw Schedule/Mini-Perm/ReFi
17:45 LP&GP Preferred Return/Distributions
18:36 Individual Shareholders
19:36 Closing