-
Advanced Concepts - Property and Portfolio-Level 21
Advanced tutorials (not required for Accelerator completion) related to property-level and portfolio-level cash flow modeling
-
Introduction to Advanced ConceptsLecture1.1
-
Modeling Floating (Variable) Rate DebtLecture1.2
-
Real Estate Sensitivity Analysis Using a Data Table in ExcelLecture1.3
-
A Framework for Modeling Mixed-Use InvestmentsLecture1.4
-
Modeling Multiple Tranches of Capital Sources DynamicallyLecture1.5
-
Modeling a Construction Loan TakeoutLecture1.6
-
Add a Recalculate Button to Your Development Model to Avoid Circular ReferencesLecture1.7
-
Considerations in Portfolio-Level ModelingLecture1.8
-
Creating In-Cell Buttons, Toggles, and Navigation ButtonsLecture1.9
-
Ground Leases, Valuation, and Impact on Cash FlowLecture1.10
-
Modeling Variability in Income and Expense Line ItemsLecture1.11
-
Development Cash Flow: Creating a Steady Decrease Formula (Inverse to the Steady Growth Formula)Lecture1.12
-
Altering The Development Model For Pari Passu Coverage of Development Costs Between Debt and EquityLecture1.13
-
Dynamically Forecasting Development Cash FlowsLecture1.14
-
Advanced Lender Risk Metrics – Duration and Average LifeLecture1.15
-
Using Stochastic (Probabilistic) Analysis and Monte Carlo SimulationsLecture1.16
-
Mortgage Prepayment Fees, Including Yield Maintenance and DefeasanceLecture1.17
-
After-Tax Analysis in Real Estate (Coming Soon)Lecture1.18
-
Tax Credit Modeling (Coming Soon)Lecture1.19
-
Advanced Formatting Techniques for More User-Friendly Real Estate Models (Coming Soon)Lecture1.20
-
Using VBA to Create Buttons to Add or Delete Rows and Columns (Coming Soon)Lecture1.21
-
-
Advanced Concepts - Partnership-Level 5
Advanced tutorials related to partnership-level (i.e. waterfall) cash flow modeling
-
Two Techniques for Modeling a GP Catch Up ProvisionLecture2.1
-
One Technique for Modeling an LP Clawback ProvisionsLecture2.2
-
Modeling Partnership Crystallization / Ownership ResetLecture2.3
-
Modeling Annual Partnership Distributions with Monthly Property-Level Cash FlowsLecture2.4
-
Break Out Promote, Preferred Return, Excess Cash Flow, and Return of Capital Plus Separate Returns Before and After FeesLecture2.5
-
Oops! It looks like you're not logged in. Please login here and then return to this page to continue.