-
Advanced Concepts - Property and Portfolio-Level
Advanced tutorials (not required for Accelerator completion) related to property-level and portfolio-level cash flow modeling
- Introduction to Advanced Concepts
- Modeling Floating (Variable) Rate Debt
- Real Estate Sensitivity Analysis Using a Data Table in Excel
- A Framework for Modeling Mixed-Use Investments
- Modeling Multiple Tranches of Capital Sources Dynamically
- Modeling a Construction Loan Takeout
- Add a Recalculate Button to Your Development Model to Avoid Circular References
- Considerations in Portfolio-Level Modeling
- Creating In-Cell Buttons, Toggles, and Navigation Buttons
- Ground Leases, Valuation, and Impact on Cash Flow
- Modeling Variability in Income and Expense Line Items
- Development Cash Flow: Creating a Steady Decrease Formula (Inverse to the Steady Growth Formula)
- Altering The Development Model For Pari Passu Coverage of Development Costs Between Debt and Equity
- Advanced Lender Risk Metrics – Duration and Average Life
- After-Tax Analysis in Real Estate (Coming Soon)
- Tax Credit Modeling (Coming Soon)
- Ground Leases, Valuation, and Impact on Cash Flow
- Modeling Variability in Income and Expense Line Items
- Development Cash Flow: Creating a Steady Decrease Formula (Inverse to the Steady Growth Formula)
- Altering The Development Model For Pari Passu Coverage of Development Costs Between Debt and Equity
- Dynamically Forecasting Development Cash Flows
- Advanced Lender Risk Metrics – Duration and Average Life
- Using Stochastic (Probabilistic) Analysis and Monte Carlo Simulations
- Mortgage Prepayment Fees, Including Yield Maintenance and Defeasance
-
Advanced Concepts - Partnership-Level
Advanced tutorials related to partnership-level (i.e. waterfall) cash flow modeling
- Two Techniques for Modeling a GP Catch Up Provision
- One Technique for Modeling an LP Clawback Provisions
- Modeling Partnership Crystallization / Ownership Reset
- Modeling Annual Partnership Distributions with Monthly Property-Level Cash Flows
- Break Out Promote, Preferred Return, Excess Cash Flow, and Return of Capital Plus Separate Returns Before and After Fees
This content is protected, please login and enroll course to view this content!
