Real Estate Financial Modeling – The Complete Guide

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Introduction to Property Types and Risk Profiles

Lecture 1: Office Basics

Lecture 2: Office Unique Characteristics

Lecture 3: Industrial Basics

Lecture 4: Industrial Unique Characteristics

Lecture 5: Retail Basics

Lecture 6: Retail Unique Characteristics

Lecture 7: Multi-Family Basics

Lecture 8: Multi-Family Unique Characteristics

Lecture 9: Hospitality Baiscs

Lecture 10: Hospitality Unique Characteristics

Lecture 11: Risk Profiles: Core & Core Plus

Lecture 12: Risk Profiles: Value-Add & Opportunistics

Chapter 3: How to Analyze a Real Estate Market

Lecture 1: Introduction

Lecture 2: Inventory

Lecture 3: Vacancy

Lecture 4: Absorption

Lecture 5: Market Cap Rate

Lecture 6: Market Rent

Lecture 7: GDP

Lecture 8: Unemployment

Lecture 9: Economic Diversification

Chapter 4: Key Financial Metrics in Real Estate

Lecture 1: Net Operating Income (NOI)

Lecture 2: Cap Rate

Lecture 3: Cash-on-Cash Return & Equity Multiple

Lecture 4: IRR Introduction

Lecture 5: IRR Example

Lecture 6: Discounted Cash Flow

Chapter 5: Building a Stabilized RE Model pt. I

Lecture 1: Property introduction

Lecture 2: Model Introduction

Lecture 3: Main Assumptions

Lecture 4: Rental Schedule

Lecture 5: Projecting Out Income

Lecture 6: Projecting Out Operating Expenses

Lecture 7: Vacancy Factor and NOI

Lecture 8: Calculating Purchase Price

Lecture 9: Calculating Disposition Price

Lecture 10: Capital Reserves

Lecture 11: Capital Expenditures

Chapter 6: Building a Stabilized RE Model pt. II

Lecture 1: Debt Schedule Assumptions

Lecture 2: Debt Schedule Principal Payments

Lecture 3: Debt Schedule Interest & Balances

Lecture 4: Tying the Debt Schedule to the Cash Flow

Lecture 5: Sources & Uses

Lecture 6: Finalizing the Cash Flow

Lecture 7: Calculating IRR & the Equity Multiple

Lecture 8: Creating a Sensitivity Table

Lecture 9: Summary

Chapter 7: Building a value-add RE model pt. I

Lecture 1: Introduction

Lecture 2: Model Overview

Lecture 3: Assumptions Tab pt. I

Lecture 4: Assumptions Tab pt. II

Lecture 5: Building a Rent Roll

Lecture 6: Unit Level Cash Flow Introduction

Lecture 7: Unit Level Cash Flow Rent Roll pt. I

Lecture 8: Unit Level Cash Flow Rent Roll pt. II

Lecture 9: Calculating Construction Costs

Lecture 10: Operating Expenses

Lecture 11: Vacancy & CapEx

Chapter 8: Building a Value-Add RE Model pt. II

Lecture 1: Debt Amortization Schedule

Lecture 2: Adding Debt to the Cash Flow

Lecture 3: Adding the Acquisition and Sale to the Cash Flow

Lecture 4: Sources & Uses

Lecture 5: Setting up the Promote Structure

Lecture 6: Equity Waterfall Introduction

Lecture 7: Equity Waterfall pt. I

Lecture 8: Equity Waterfall pt. II

Lecture 9: Equity Waterfall pt. III

Lecture 10: Equity Waterfall pt. IV

Lecture 11: Equity Waterfall pt. V

Lecture 12: Calculating the Returns

Lecture 13: Model Summary

Lecture 14: Conclusion