Advanced Modeling for National Multifamily & Commercial Investments

Session Dates

  • Session 1 – Valuation, Cash Flow & Pro Forma Foundations (Wednesday Feb. 25)

    Understanding how real estate value is created • Income-based valuation and how NOI drives pricing • Cap rates, rent rolls, unit mix, and identifying true upside • Building a pro forma from T-12 financials • Projecting income and expenses with disciplined assumptions • Translating operating performance into investment value

  • Session 2 – Discounted Cash Flow, Returns & Leverage (Wednesday March 4)

    Evaluating performance across the full investment lifecycle • Discounted Cash Flow (DCF) modeling fundamentals • Projecting future cash flows and exit assumptions • IRR, Cash-on-Cash, Equity Multiple, NPV, and PV explained • Underwriting debt: agency loans, bridge loans, refinances • Using leverage strategically while managing risk (LTV, DSCR)

  • Session 3 – Hands-On Modeling: 200-Unit Multifamily Deal (Wednesday March 11)

    Applying underwriting concepts to a real-world multifamily asset • Underwriting a stabilized 200-unit property in a Midwest market • Analyzing rent rolls, operating expenses, and value-add potential • Debt sizing, return metrics, and sensitivity analysis • Evaluating risk vs. reward in a non-coastal market • Interpreting results as both sponsor and investor

  • Session 4 – Hands-On Modeling: Complex Commercial Deal in a Growth Market (Monday March 16)

    Learn the intricacies of an office/industrial lease-up • Modeling a complex commercial deal in a high-growth market • Commercial lease structures and CAM considerations • Tenant improvements, leasing commissions, and downtime • Financing challenges unique to commercial assets • Stress-testing assumptions and exit scenarios

  • Session 5 – Equity Structures & Partnership Economics (Thursday March 19)

    How deals are structured between sponsors and investors • Common equity vs. preferred equity structures • Pari passu equity, preferred returns, and waterfall models • Promote structures and alignment of interests • What investors look for in deals, sponsors, and partnerships • Modeling refinance and sale scenarios within partnership structures