- Home
- Courses
- Accelerator
- Advanced Concepts in Real Estate Financial Modeling
Curriculum
- 2 Sections
- 29 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- Advanced Concepts - Property and Portfolio-LevelAdvanced tutorials (not required for Accelerator completion) related to property-level and portfolio-level cash flow modeling24
- 1.1Introduction to Advanced Concepts
- 1.2Modeling Floating (Variable) Rate Debt
- 1.3Real Estate Sensitivity Analysis Using a Data Table in Excel
- 1.4A Framework for Modeling Mixed-Use Investments
- 1.5Modeling Multiple Tranches of Capital Sources Dynamically
- 1.6Modeling a Construction Loan Takeout
- 1.7Add a Recalculate Button to Your Development Model to Avoid Circular References
- 1.8Considerations in Portfolio-Level Modeling
- 1.9Creating In-Cell Buttons, Toggles, and Navigation Buttons
- 1.10Ground Leases, Valuation, and Impact on Cash Flow
- 1.11Modeling Variability in Income and Expense Line Items
- 1.12Development Cash Flow: Creating a Steady Decrease Formula (Inverse to the Steady Growth Formula)
- 1.13Altering The Development Model For Pari Passu Coverage of Development Costs Between Debt and Equity
- 1.14Advanced Lender Risk Metrics – Duration and Average Life
- 1.15After-Tax Analysis in Real Estate (Coming Soon)
- 1.16Tax Credit Modeling (Coming Soon)
- 1.17Ground Leases, Valuation, and Impact on Cash Flow
- 1.18Modeling Variability in Income and Expense Line Items
- 1.19Development Cash Flow: Creating a Steady Decrease Formula (Inverse to the Steady Growth Formula)
- 1.20Altering The Development Model For Pari Passu Coverage of Development Costs Between Debt and Equity
- 1.21Dynamically Forecasting Development Cash Flows
- 1.22Advanced Lender Risk Metrics – Duration and Average Life
- 1.23Using Stochastic (Probabilistic) Analysis and Monte Carlo Simulations
- 1.24Mortgage Prepayment Fees, Including Yield Maintenance and Defeasance
- Advanced Concepts - Partnership-LevelAdvanced tutorials related to partnership-level (i.e. waterfall) cash flow modeling5
- 2.1Two Techniques for Modeling a GP Catch Up Provision
- 2.2One Technique for Modeling an LP Clawback Provisions
- 2.3Modeling Partnership Crystallization / Ownership Reset
- 2.4Modeling Annual Partnership Distributions with Monthly Property-Level Cash Flows
- 2.5Break Out Promote, Preferred Return, Excess Cash Flow, and Return of Capital Plus Separate Returns Before and After Fees
