Advanced Concepts in Real Estate Financial Modeling → Tax Credit Modeling (Coming Soon)

Oops! It looks like you're not logged in. Please login here and then return to this page to continue.

Prev After-Tax Analysis in Real Estate (Coming Soon)

Next Advanced Formatting Techniques for More User-Friendly Real Estate Models (Coming Soon)

Advanced Concepts - Property and Portfolio-Level 21

Advanced tutorials (not required for Accelerator completion) related to property-level and portfolio-level cash flow modeling
- Lecture1.1
  
  Introduction to Advanced Concepts
- Lecture1.2
  
  Modeling Floating (Variable) Rate Debt
- Lecture1.3
  
  Real Estate Sensitivity Analysis Using a Data Table in Excel
- Lecture1.4
  
  A Framework for Modeling Mixed-Use Investments
- Lecture1.5
  
  Modeling Multiple Tranches of Capital Sources Dynamically
- Lecture1.6
  
  Modeling a Construction Loan Takeout
- Lecture1.7
  
  Add a Recalculate Button to Your Development Model to Avoid Circular References
- Lecture1.8
  
  Considerations in Portfolio-Level Modeling
- Lecture1.9
  
  Creating In-Cell Buttons, Toggles, and Navigation Buttons
- Lecture1.10
  
  Ground Leases, Valuation, and Impact on Cash Flow
- Lecture1.11
  
  Modeling Variability in Income and Expense Line Items
- Lecture1.12
  
  Development Cash Flow: Creating a Steady Decrease Formula (Inverse to the Steady Growth Formula)
- Lecture1.13
  
  Altering The Development Model For Pari Passu Coverage of Development Costs Between Debt and Equity
- Lecture1.14
  
  Dynamically Forecasting Development Cash Flows
- Lecture1.15
  
  Advanced Lender Risk Metrics – Duration and Average Life
- Lecture1.16
  
  Using Stochastic (Probabilistic) Analysis and Monte Carlo Simulations
- Lecture1.17
  
  Mortgage Prepayment Fees, Including Yield Maintenance and Defeasance
- Lecture1.18
  
  After-Tax Analysis in Real Estate (Coming Soon)
- Lecture1.19
  
  Tax Credit Modeling (Coming Soon)
- Lecture1.20
  
  Advanced Formatting Techniques for More User-Friendly Real Estate Models (Coming Soon)
- Lecture1.21
  
  Using VBA to Create Buttons to Add or Delete Rows and Columns (Coming Soon)
Advanced Concepts - Partnership-Level 5

Advanced tutorials related to partnership-level (i.e. waterfall) cash flow modeling
- Lecture2.1
  
  Two Techniques for Modeling a GP Catch Up Provision
- Lecture2.2
  
  One Technique for Modeling an LP Clawback Provisions
- Lecture2.3
  
  Modeling Partnership Crystallization / Ownership Reset
- Lecture2.4
  
  Modeling Annual Partnership Distributions with Monthly Property-Level Cash Flows
- Lecture2.5
  
  Break Out Promote, Preferred Return, Excess Cash Flow, and Return of Capital Plus Separate Returns Before and After Fees

Advanced Concepts - Property and Portfolio-Level 21

Advanced Concepts - Partnership-Level 5