Introduction
  • Welcome!
  • What We Will Cover - Part 1
  • What We Will Cover - Part 2
  • What We Will Cover - Part 3
  • A Sneak Peek Into What You'll Build
  • Setting Expectations
  • About The Instructor & Student Success Stories
  • Disclaimer
Real Estate Development Modeling Fundamentals
  • Real Estate Development Modeling Fundamentals
  • Real Estate Pro Forma Modeling 101
  • Monthly vs. Annual CF Modeling & Checks
  • Real Estate Financial Modeling Color Coding
  • The Development Model Set-Up
  • Advanced Excel Settings
Part 1 - Building Out The Summary Dashboard
  • Building Out The Summary Tab
  • Modeling Land Acquisition Assumptions
  • Modeling Lease-Up Assumptions
  • Construction Financing Assumptions
  • Permanent Financing Assumptions - Part 1
  • Permanent Financing Assumptions - Part 2
  • Modeling Total Project Costs
  • Modeling Sale Details
  • Building Out The Circuit Breaker
  • Modeling Sources & Uses
  • Post-Construction Equity & Return Metrics Build-Out
Part 2 - Revenue Modeling
  • Building Out The Rent Roll
  • Weighted Average Rents
  • Modeling Other Income
  • Vacancy, Bad Debt, & Rent Growth Assumptions
  • Modeling The Lease-Up
  • Modeling Stabilized Rents
  • Calculating Percentage of Lease-Up Complete
  • Net Rental Revenue
  • Modeling Stabilized Other Income
  • Modeling Actual Other Income
Part 3 - Expense Modeling
  • Building Out The Expenses Tab
  • Stabilized, Fixed, & Variable Expenses
  • PM Fees & Reserves
  • Building Out The Property Tax Information Table
  • Annual Property Tax Growth Modeling
  • Modeling Stabilized Operating Expenses
  • Modeling Actual Operating Expenses
Part 4 - Construction Modeling
  • Building Out The Construction Budget Tab
  • Building Out The Hard Costs Table
  • Total Costs & Timing
  • Building Out The Construction Timeline
  • S-Curve Construction Cost Modeling
  • Construction Funding Checks
  • Modeling Soft Costs - Part 1
  • Modeling Soft Costs - Part 2
  • Modeling Soft Costs - Part 3
  • Building In The Contingency
Part 5 - Monthly Cash Flow Modeling
  • Building Out The Monthly CF Tab
  • Modeling Revenue
  • Dynamic Physical Vacancy Modeling
  • Bad Debt, Concessions, & Other Loss
  • Modeling Other Income
  • Modeling Operating Expenses
  • Property Taxes & PM Fees
  • Capital Reserves & NOI
  • Capital Expenses & Cash Flow Before Debt Service
  • Modeling Acquisition & Sale Information
  • Loan Information Section Build-Out
  • Cash Flow Line Item Totals & Formatting Clean-Up
  • Property Taxes Finalization
Part 6 - Debt Modeling
  • Building Out The Financing Tab
  • Modeling Operating Metrics
  • Total Land & Construction Costs
  • Modeling Equity Financing
  • Modeling Equity Draws
  • Construction Financing Table Build-Out
  • Modeling Construction Loan Draws
  • Up-Front Financing Costs
  • Interest Rate Projections (Forward Curves)
  • Modeling Floating Interest Rates
  • Modeling Interest Expense & Capitalized Interest
  • Construction Loan Payoff & Ending Balance
  • Building Out The Permanent Financing Table
  • Timing The Permanent Loan Funding
  • Modeling The Total Loan Payment
  • Modeling Principal & Interest Payments
  • Permanent Loan Payoff & Ending Balance
  • Equity & Debt Funding Checks
  • Finalizing The Sources & Uses Table
  • Monthly CF Tab Financing Finalization - Part 1
  • Monthly CF Tab Financing Finalization - Part 2
Part 7 - Annual Cash Flow Modeling, Checks, & Model Finalization
  • Building Out The Annual CF Tab
  • Modeling Annual Cash Flows
  • Building Out The Cash-on-Cash Return
  • Dynamic Refinance Loan Sizing
  • Modeling DSCR & Debt Yield