Real Estate Development Modelling Course

Understand the real estate development process and learn to build a dynamic Excel model from scratch like a professional

What you'll learn

Learn the ins and outs of development, understand all key terms and get an insight into what assumptions to use

Learn to build, modify and use a fully dynamic Excel real estate development model from scratch

Practice what you have learnt in three 3 case studies designed to give you a taste of working in the industry

Explore additional lectures with valuable content to give you a full picture

Requirements

Basic knowledge of Excel is helpful, but non needed as we go over the key Excel functions in the prerequisite section

Description

Preparing for a case study interview or looking to enhance your career as a real estate investment professional?Then this course is for YOU!Understand the development process from acquisition to exit and master the real estate financial modelling skills.This course focuses on teaching the technical modelling skills as well as the specific knowhow needed to succeed in the industry. We will spend a lot of time explaining all key terms, explaining how all steps of development work and why firms decide to do things a certain way.The goal is to teach you the thought process, rather than to give a static set of assumptions, so that you're able to modify the model as needed for your own project.We will apply the same teaching method in the modelling part of the course as we literally build the model along side you, starting from a blank worksheet and explaining everything in detail, one formula at a time.Again, the focus is on teaching YOU how to think about the model, so that by the end of the course you will be able to model various parts in multiple ways (using different formulas) and you will understand the inner workings of the model. This will boost your confidence going into the interview and allow you to later-on amend the model as you see fit.Course ModulesThis course contains over 14 hours of video content and will be split into three modules, with each module focused on a different area.Upon completion of the course, you will have the knowledge, skills and confidence to analyze any commercial real estate deal worldwide. Now tell me what employer wouldn't like that.Module #1 - LEARNIn this module you will have access to almost 5 hours of video content to learn the ins and outs of development, understand all key terms and get an insight into what assumptions to use.This section is what really differentiates this course. I believe that to build a working model and be able to use it, one has to understand the underlying process deeply. That's our goal here. Additionally, I included several add-on lectures at the end of the course on corporate structure set-up and taxes to help you stand out during the interview.See the free preview of lecture 1.14 to get a better idea of how this module is structured.Module #2 - BUILDIn this module you will have access to almost 7 hours of content focused strictly on building a fully dynamic financial model from scratch.Each lecture concentrates on a specific section of the model. I explain all formulas, links, and reasons for doing things a certain way. Moreover, I teach you the best practices of how to use Excel like a pro including short cuts and tips and tricks I have learned over my career.See the free preview of lectures 2.13 and 2.22 to get a better idea of how this module is structured.Module #3 - APPLYIn this module you will have access to 3 case studies from various markets across Europe.These will be very similar to what you can expect on interview day or working in the industry day to day.I will go through each case study with you, describing my thought process, providing benchmarks for key assumptions and most importantly teaching you how to find relevant data online to have correct assumptions every time for any market.

Overview

Section 1: Welcome!

Lecture 1 Welcome!

Section 2: Prerequisites

Lecture 2 IF, AND, OR

Lecture 3 EOMONTH, YEAR

Lecture 4 SUMIF, SUMIFS, AVERAGEIF, COUNTIF

Lecture 5 INDEX MATCH

Lecture 6 SUMPRODUCT

Lecture 7 PPMT, IPMT

Lecture 8 DATA TABLES , GOALSEEK

Lecture 9 SHORTCUTS, TIPS AND TRICKS

Lecture 10 MODEL LAYOUT

Section 3: PART 1 - Understanding the inputs

Lecture 11 Introduction to the course

Lecture 12 Residential development - how much space can you build?

Lecture 13 Residential development - development process and timing assumptions

Lecture 14 Residential development - project costs

Lecture 15 Residential development - construction costs

Lecture 16 Residential development - modelling revenues

Lecture 17 Residential development - financing

Lecture 18 Residential development - financing continued

Lecture 19 Residential development - acquisition assumptions

Lecture 20 Office development - how much space can you build?

Lecture 21 Office development - development process and timing assumptions

Lecture 22 Office development - construction costs

Lecture 23 Office development - operating costs

Lecture 24 Office development - modelling revenues

Lecture 25 Office development - financing

Section 4: PART 2 - Building the model

Lecture 26 Residential - Modelling a timeline for soft costs

Lecture 27 Residential - Timing of hard costs - part 1

Lecture 28 Residential - Timing of hard costs - part 2

Lecture 29 Residential - Modelling flags

Lecture 30 Residential - Constructing the budget

Lecture 31 Residential - Building cost cash flows

Lecture 32 Residential - Modelling the timing of revenues

Lecture 33 Residential - Revenues cash flow

Lecture 34 Residential - Modelling taxes

Lecture 35 Residential - Acquisition financing

Lecture 36 Residential - Construction financing - conditions

Lecture 37 Residential - Construction financing - cash flow

Lecture 38 Office - Modelling the leasing curve

Lecture 39 Office - construction costs timing

Lecture 40 Office - fit-out timing

Lecture 41 Office - building costs cash flow

Lecture 42 Office - Average and Effective Rent

Lecture 43 Office - Modelling NOI - part 1

Lecture 44 Office - Modelling NOI - part 2

Lecture 45 Office - Modelling NOI - part 3

Lecture 46 Office - Exit price calculation

Lecture 47 Office - Exit price deductions

Lecture 48 Office - Exit price tax considerations

Lecture 49 Office - Acquisition financing

Lecture 50 Office - Construction financing

Lecture 51 Office - LTV financing conditions

Lecture 52 Office - LTV financing cash flow - part 1

Lecture 53 Office - LTV financing cash flow - part 2

Section 5: PART 3 - Putting it all together

Lecture 54 Modelling the summary tab

Lecture 55 Modelling equity and debt exposure

Lecture 56 Sensitivity analysis

Section 6: PART 4 - Add-on lectures

Lecture 57 Corporate structure

Lecture 58 JV partnerships

Lecture 59 Residential space for sale vs for rent

Section 7: PART 5 - Case Studies

Lecture 60 Case Studies Introduction

Lecture 61 Case Study #1 - part 1

Lecture 62 Case Study #1 - part 2

Lecture 63 Case Study #2

Lecture 64 Case Study #3

Students wanting to break into commercial real estate or real estate private equity,Students or young professionals preparing for interviews at leading real estate firms,Young professionals in the industry wanting to take their skills to the next level