Understanding Real Estate Financial Modeling

Introduction – Understanding Real Estate Financial Modeling

Main Lesson – Financial Modeling Structure, Assumptions & Investment Analysis

Summary & Key Takeaways – Modeling Foundations

Introduction – Using Excel for Real Estate Analysis

Main Lesson – Essential Excel Functions, Formulas & Professional Model Design

Summary & Key Takeaways – Excel for Real Estate

Introduction – Understanding Property-Level Cash Flow

Main Lesson – Building Cash Flow Projections & Calculating Net Operating Income (NOI)

Summary & Key Takeaways – Cash Flow & NOI

Introduction – Understanding Property Revenue & Rent Rolls

Main Lesson – Modeling Rent, Vacancy, Growth & Other Property Income

Summary & Key Takeaways – Revenue Modeling

Introduction – Understanding Real Estate Operating Expenses

Main Lesson – Forecasting Operating Costs, Expense Growth & Property Performance

Summary & Key Takeaways – Operating Expense Modeling

Introduction – Understanding Real Estate Valuation

Main Lesson – Valuing Income-Producing Properties Using NOI & Capitalization Rates

Summary & Key Takeaways – Valuation & Cap Rates

Introduction – Understanding the Acquisition Underwriting Process

Main Lesson – Analyzing Purchase Assumptions, Property Performance, Risk & Investment Potential

Summary & Key Takeaways – Acquisition Underwriting

Introduction – Understanding Real Estate Debt & Financing

Main Lesson – Building Loan Schedules & Analyzing LTV, DSCR, Debt Yield and Debt Service

Summary & Key Takeaways – Debt Modeling

Introduction – Understanding Real Estate Investment Returns

Main Lesson – Calculating & Interpreting IRR, NPV, Equity Multiple and Cash-on-Cash Return

Summary & Key Takeaways – Investment Returns

Introduction – Understanding the Real Estate Investment Exit

Main Lesson – Modeling Exit Value, Sale Proceeds, Selling Costs & Investor Returns

Summary & Key Takeaways – Exit & Sale Modeling

Introduction – Understanding Risk Through Scenario Analysis

Main Lesson – Testing Rent, Vacancy, Expenses, Interest Rates, Cap Rates & Investment Returns

Summary & Key Takeaways – Sensitivity & Scenario Analysis

Introduction – Understanding Multifamily Investment Analysis

Main Lesson – Building a Complete Multifamily Property Underwriting Model

Summary & Key Takeaways – Multifamily Underwriting

Introduction – Understanding Commercial Real Estate Analysis

Main Lesson – Modeling Commercial Leases, Tenant Cash Flows, Expenses, Valuation & Returns

Summary & Key Takeaways – Commercial Real Estate Underwriting