Guide To Analyze Real Estate Asset (Concept And Excel Model)

Learn how to analyze any Real Estate Investment opportunity Step by Step. Handle Concepts and Excel Financial Modeling.

What you'll learn
Perform step-by-step analysis of any Real Estate investment opportunity as a professional
Evaluate accurately whether an investment opportunity is profitable or not
Private equity exam on a Real Investment Opportunity
Understand the most important Real Estate financial metrics (IRR, NPV, Levered Cash Flow, Cap Rate, etc.)
Create an Excel Dynamic DCF model from scratch
Excel Scenario Analysis
Become familiar with Real Estate industry investment strategies, internal work, habits and jargon
Real Life case study
Know the fundamentals on how to make a market study for its investment
Requirements
Have Microsoft Excel 2011 or newer
No specific previous knowledge is required
Description
Description:If you want to learn how to analyze any Real Estate Investment opportunity for yourself or with your company, it is the place to be.Here, you will handle all the relevant Real Estate finance concepts to become an informed investor. At the end of this course, you will manage to create your own Dynamic Excel Financial Model and make a final decision about Real Estate investment opportunities. Whether you are a beginner, a college student looking to break into RE finance, an analyst, an associate or simply a RE investor; this course has been specifically made for you.We will first have an overview of the Real Estate Investment world and we will go deeper into the different strategies that investors and private equity funds commonly use. You will know what happen inside large Real Estate Investment Funds as in the one I was working for. We will then cover all the relevant concepts you need to know to invest in any type of asset such as (CAP rate, NOI, Operating Income, IRR…). After that, we will cover basic and advanced Important Excel formulas for Real Estate investors.In this course we will go through all the steps to create a Dynamic Financial Model for Real Estate on Excel. You will discover or (re)discover the basic formulas, ratios, and calculations. You will then go through the more advanced ones in Excel. With plenty of exercises, you will be able to check whether you use Excel the right way.At the end, I prepared a Real-Life Private Equity Real Estate Case Study Exam. You will get in the shoes of a professional investor working for an investment fund receiving an investment opportunity for its portfolio. You will receive a complete case study and you will have to analyze from A to Z the RE asset.At the end of the course you will be 100% independent to take an informed decision about your future Real Estate Investment Opportunities.

Overview

Section 1: Guide to analyze Real Estate Asset (Concept and Excel Model) - Introduction

Lecture 1 Guide to analyze Real Estate Asset (Concept and Excel Model) - Introduction

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

Lecture 3 Who is your teacher: about me

Lecture 4 Who is this course for ?

Lecture 5 Download files here!

Lecture 6 Disclaimer

Section 2: An overview of the Real Estate Investment world

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

Lecture 8 How a job in PE fund or IB looks like - analyst or associate

Lecture 9 Investment strategies of PE funds and Investment Banks

Section 3: Relevant concepts to understand (CAP rate, NOI, Operating Income, IRR…)

Lecture 10 Cap Rate : Real Estate concept

Lecture 11 CAPEX (capital expenditures) : Real Estate concept

Lecture 12 GOI (Gross Operating Income)

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

Lecture 14 Levered Cash Flow : Real Estate concept

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

Lecture 16 OPEX (Operating Expenses) : Real Estate concept

Lecture 17 Unlevered Cash Flow : Real Estate concept

Lecture 18 Levered Cash Flow : Real Estate concept

Section 4: Basic Excel fromulas for Real Estate DCF modeling

Lecture 19 Download me ! Main Excel Formulas and Shortcuts

Lecture 20 Shortcuts and formating in Excel - General

Lecture 21 Shortcuts and formating in Excel - Formating & Navigation (Part 1)

Lecture 22 Shortcuts and formating in Excel - Formating & Navigation (Part 2)

Lecture 23 If & And

Lecture 24 Count / Countif / Countifs

Lecture 25 Drop-down list

Lecture 26 Index & Match

Lecture 27 Lookup / Vlookup / Hlookup

Lecture 28 NPV (Net Present Value)

Lecture 29 PMT / PPMT / IPMT (for Debt Modeling)

Lecture 30 Power

Lecture 31 Sum & Sumif

Lecture 32 Sumproduct

Section 5: Analyzing a Real Estate Asset : Gather, receive and structure the data needed

Lecture 33 Gather, receive and structure the data needed

Section 6: Analyzing a Real Estate Asset : Market Study

Lecture 34 Download me! Market study slides.

Lecture 35 Market Study - All the steps of a market study

Lecture 36 Market Study - Demand

Lecture 37 Market Study - Supply

Lecture 38 Market Study - Competitors

Lecture 39 Market Study - Investment

Lecture 40 Market Study - Rent

Section 7: Create a discounted cash flow model (DCF) Excel for a Real Estate Asset

Lecture 41 Gross Acquisition Price (GOI)

Lecture 42 Gross Operating Income (GOI) - Part 1

Lecture 43 Gross Operating Income (GOI) - Part 2

Lecture 44 OPEX (Part 1)

Lecture 45 OPEX (Part 2)

Lecture 46 CAPEX (Part 1)

Lecture 47 CAPEX (Part 2)

Lecture 48 Net Sales Price (Part 1)

Lecture 49 Net Sales Price (Part 2)

Lecture 50 NOI (Net Operating Income) & Unlevered Cash Flow

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

Lecture 51 Debt modeling - case 1 (Part 1)

Lecture 52 Debt modeling - case 1 (Part 2)

Lecture 53 Debt modeling - case 2 (Part 1)

Lecture 54 Debt modeling - case 2 (Part 2)

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

Lecture 55 Ratios

Lecture 56 Scenario Analysis (Part 1)

Lecture 57 Scenario Analysis (Part 2)

Section 10: Private Equity investment opportunity case study exam

Lecture 58 Case study presentation - Introduction

Lecture 59 Download files here!

Lecture 60 Case study presentation - Case study problem statement

Lecture 61 Case study presentation - Investment Memorandum

Lecture 62 Case study presentation - Concepts reminder

Section 11: Explanation and correction of the case study exam

Lecture 63 Case study DCF: Assumptions

Lecture 64 Case study DCF: Gross acquisition price

Lecture 65 Case study DCF : Gross operating income part 1

Lecture 66 Case study DCF : Gross operating income part 2

Lecture 67 Case study DCF: OPEX Part 1

Lecture 68 Case study DCF: OPEX Part 2

Lecture 69 Case study DCF: CAPEX

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

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

Lecture 72 Case Study DCF Model: Debt Model Intro

Lecture 73 Case Study DCF Model: Debt Model Part 1

Lecture 74 Case Study DCF Model: Debt Model Part 2

Lecture 75 Case Study DCF model: Levered Cash Flow

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

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

Beginner and intermediate Real Estate investors,Investors willing to invest in any type of Real Estate property,College students and graduate willing to break into the Real Estate finance industry,Current Real Estate Professional (Analyst, Associate),Real Estate agents willing to handle financial valuations for their clients,Anyone interested in the Real Estate World