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



Download link

rapidgator.net:


uploadgig.com:


nitroflare.com:


1dl.net: