The Real Estate Financial Modeling Bootcamp

Module 1: Foundations of Real Estate Finance

⏳ 45 minutes

• Key metrics and terminology: NOI, cap rate, yield on cost, and leverage ratios

• Overview of deal structures: equity vs. debt, mezzanine financing, and preferred return

Module 2: Excel Modeling Best Practices

⏳ 1 hour

• Structuring workbooks: input, calculation, and output tabs with error checks

• Using advanced Excel techniques: named ranges, dynamic formulas, and data validation

Module 3: Acquisition Analysis & Purchase Model

⏳ 1 hour

• Building an acquisition pro forma: purchase price allocation, closing costs, and financing

• Calculating debt sizing, interest schedules, and loan covenants

Module 4: Operating Cash Flow & Budgeting

⏳ 1 hour

• Modeling rent roll: lease terms, escalations, concessions, and renewal assumptions

• Forecasting operating expenses: fixed vs. variable costs, reserves, and capex schedules

Module 5: Development & Construction Modeling

⏳ 1 hour 15 minutes

• Phasing construction draws, interest during construction, and cost overruns

• Projecting stabilization metrics: absorption rates, yield on cost, and permanent financing

Module 6: Sale, Refinance & Exit Strategies

⏳ 45 minutes

• Modeling disposition proceeds, transaction fees, and tax implications

• Structuring refinance scenarios: take-out debt, equity recap, and return analysis

Module 7: Waterfall & JV Distribution Modeling

⏳ 1 hour

• Designing tiered waterfalls with preferred returns, catch-up, and promote structures

• Allocating sponsor and investor shares under multiple scenarios

Module 8: Sensitivity, Scenario & Dashboard Reporting

⏳ 1 hour

• Building sensitivity tables, tornado charts, and scenario selectors

• Creating investor dashboards: charts, KPI summaries, and executive outputs

Get certificate