Real Estate Investment Masterclass: modeling & concept

Course Curriculum

Chapter 1: Guide to analyze Real Estate Asset (Concept and Excel Model) – Introduction

Lecture 1: Who is your teacher: about me

Lecture 2: Guide to analyze Real Estate Asset (Concept and Excel Model) – Introduction

Lecture 3: Course content and learning outcome : what we will go through

Lecture 4: Who is this course for ?

Lecture 5: Download files here!

Lecture 6: Disclaimer

Chapter 2: An overview of the Real Estate Investment world

Lecture 1: What are the jobs of Real Estate investors, PE Funds and Investment Banks

Lecture 2: How a job in PE fund or IB looks like – analyst or associate

Lecture 3: Investment strategies of PE funds and Investment Banks

Chapter 3: The different investment strategies

Lecture 1: Real Estate Crowdfunding

Lecture 2: The BRRR Strategy

Lecture 3: The Buy-and-hold Strategy

Lecture 4: The Fix-and-flip Strategy

Lecture 5: Portfolio Strategies & Diversification

Lecture 6: Portfolio Strategies – How to implement it ?

Lecture 7: The concept of Leverage in Real Estate

Chapter 4: Relevant concepts to understand (CAP rate, NOI, Operating Income, IRR…)

Lecture 1: Cap Rate : Real Estate concept

Lecture 2: CAPEX (capital expenditures) : Real Estate concept

Lecture 3: GOI (Gross Operating Income)

Lecture 4: IRR (Internal Rate of Return) : Real Estate concept

Lecture 5: NOI (Net Operating Income) : Real Estate concept

Lecture 6: OPEX (Operating Expenses) : Real Estate concept

Lecture 7: Unlevered Cash Flow : Real Estate concept

Lecture 8: Levered Cash Flow : Real Estate concept

Chapter 5: Basic Excel fromulas for Real Estate DCF modeling

Lecture 1: Download me ! Main Excel Formulas and Shortcuts

Lecture 2: Shortcuts and formating in Excel – General

Lecture 3: Shortcuts and formating in Excel – Formating & Navigation (Part 1)

Lecture 4: Shortcuts and formating in Excel – Formating & Navigation (Part 2)

Lecture 5: If & And

Lecture 6: Count / Countif / Countifs

Lecture 7: Drop-down list

Lecture 8: Index & Match

Lecture 9: Lookup / Vlookup / Hlookup

Lecture 10: NPV (Net Present Value)

Lecture 11: PMT / PPMT / IPMT (for Debt Modeling)

Lecture 12: Power

Lecture 13: Sum & Sumif

Lecture 14: Sumproduct

Lecture 15: Relative references in Excel

Chapter 6: Analyzing a Real Estate Asset : Gather, receive and structure the data needed

Lecture 1: Gather, receive and structure the data needed

Chapter 7: Analyzing a Real Estate Asset : Market Study

Lecture 1: Download me! Market study slides.

Lecture 2: Market Study – All the steps of a market study

Lecture 3: Market Study – Demand

Lecture 4: Market Study – Supply

Lecture 5: Market Study – Competitors

Lecture 6: Market Study – Investment

Lecture 7: Market Study – Rent

Chapter 8: Create a discounted cash flow model (DCF) Excel for a Real Estate Asset

Lecture 1: Download me ! Excel template

Lecture 2: Gross Acquisition Price (GOI)

Lecture 3: Gross Operating Income (GOI) – Part 1

Lecture 4: Gross Operating Income (GOI) – Part 2

Lecture 5: OPEX (Part 1)

Lecture 6: OPEX (Part 2)

Lecture 7: CAPEX (Part 1)

Lecture 8: CAPEX (Part 2)

Lecture 9: Net Sales Price (Part 1)

Lecture 10: Net Sales Price (Part 2)

Lecture 11: NOI (Net Operating Income) & Unlevered Cash Flow

Chapter 9: Model debt in discounted cash flow model (DCF) Excel for a Real Estate Asset

Lecture 1: Debt modeling – case 1 (Part 1)

Lecture 2: Debt modeling – case 1 (Part 2)

Lecture 3: Debt modeling – case 2 (Part 1)

Lecture 4: Debt modeling – case 2 (Part 2)

Chapter 10: Analyze the discounted cash flow model (DCF) Excel for a Real Estate Asset

Lecture 1: Ratios

Lecture 2: Scenario Analysis (Part 1)

Lecture 3: Scenario Analysis (Part 2)

Chapter 11: Private Equity investment opportunity case study exam

Lecture 1: Case study presentation – Introduction

Lecture 2: Download files here!

Lecture 3: Case study presentation – Case study problem statement

Lecture 4: Case study presentation – Investment Memorandum

Lecture 5: Case study presentation – Concepts reminder

Chapter 12: Explanation and correction of the case study exam

Lecture 1: Case study DCF: Assumptions

Lecture 2: Case study DCF: Gross acquisition price

Lecture 3: Case study DCF : Gross operating income part 1

Lecture 4: Case study DCF : Gross operating income part 2

Lecture 5: Case study DCF: OPEX Part 1

Lecture 6: Case study DCF: OPEX Part 2

Lecture 7: Case study DCF: CAPEX

Lecture 8: Case study DCF model: Net sales price Part 1

Lecture 9: Case study DCF model: Net sales price Part 2

Lecture 10: Case Study DCF Model: Debt Model Intro

Lecture 11: Case Study DCF Model: Debt Model Part 1

Lecture 12: Case Study DCF Model: Debt Model Part 2

Lecture 13: Case Study DCF model: Levered Cash Flow

Lecture 14: Case Study DCF Model : Returns & Solutions Part 1

Lecture 15: Case Study DCF Model : Returns & Solutions Part 2