Real Estate Development Modelling Course

Real Estate Development Modelling Course, available at $49.99, with 64 lectures, and has 14 subscribers.

You will learn about 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 This course is ideal for individuals who are Students wanting to break into commercial real estate or real estate private equity or Students or young professionals preparing for interviews at leading real estate firms or Young professionals in the industry wanting to take their skills to the next level It is particularly useful for Students wanting to break into commercial real estate or real estate private equity or Students or young professionals preparing for interviews at leading real estate firms or Young professionals in the industry wanting to take their skills to the next level.

Enroll now: Real Estate Development Modelling Course

Summary

Title: Real Estate Development Modelling Course

Price: $49.99

Number of Lectures: 64

Number of Published Lectures: 64

Number of Curriculum Items: 64

Number of Published Curriculum Objects: 64

Original Price: $49.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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 Modules

This course contains over 14 hours of video contentand 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 – LEARN

In 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 – BUILD

In 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 – APPLY

In 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.

Course Curriculum

Chapter 1: Welcome!

Lecture 1: Welcome!

Chapter 2: Prerequisites

Lecture 1: IF, AND, OR

Lecture 2: EOMONTH, YEAR

Lecture 3: SUMIF, SUMIFS, AVERAGEIF, COUNTIF

Lecture 4: INDEX MATCH

Lecture 5: SUMPRODUCT

Lecture 6: PPMT, IPMT

Lecture 7: DATA TABLES , GOALSEEK

Lecture 8: SHORTCUTS, TIPS AND TRICKS

Lecture 9: MODEL LAYOUT

Chapter 3: PART 1 – Understanding the inputs

Lecture 1: Introduction to the course

Lecture 2: Residential development – how much space can you build?

Lecture 3: Residential development – development process and timing assumptions

Lecture 4: Residential development – project costs

Lecture 5: Residential development – construction costs

Lecture 6: Residential development – modelling revenues

Lecture 7: Residential development – financing

Lecture 8: Residential development – financing continued

Lecture 9: Residential development – acquisition assumptions

Lecture 10: Office development – how much space can you build?

Lecture 11: Office development – development process and timing assumptions

Lecture 12: Office development – construction costs

Lecture 13: Office development – operating costs

Lecture 14: Office development – modelling revenues

Lecture 15: Office development – financing

Chapter 4: PART 2 – Building the model

Lecture 1: Residential – Modelling a timeline for soft costs

Lecture 2: Residential – Timing of hard costs – part 1

Lecture 3: Residential – Timing of hard costs – part 2

Lecture 4: Residential – Modelling flags

Lecture 5: Residential – Constructing the budget

Lecture 6: Residential – Building cost cash flows

Lecture 7: Residential – Modelling the timing of revenues

Lecture 8: Residential – Revenues cash flow

Lecture 9: Residential – Modelling taxes

Lecture 10: Residential – Acquisition financing

Lecture 11: Residential – Construction financing – conditions

Lecture 12: Residential – Construction financing – cash flow

Lecture 13: Office – Modelling the leasing curve

Lecture 14: Office – construction costs timing

Lecture 15: Office – fit-out timing

Lecture 16: Office – building costs cash flow

Lecture 17: Office – Average and Effective Rent

Lecture 18: Office – Modelling NOI – part 1

Lecture 19: Office – Modelling NOI – part 2

Lecture 20: Office – Modelling NOI – part 3

Lecture 21: Office – Exit price calculation

Lecture 22: Office – Exit price deductions

Lecture 23: Office – Exit price tax considerations

Lecture 24: Office – Acquisition financing

Lecture 25: Office – Construction financing

Lecture 26: Office – LTV financing conditions

Lecture 27: Office – LTV financing cash flow – part 1

Lecture 28: Office – LTV financing cash flow – part 2

Chapter 5: PART 3 – Putting it all together

Lecture 1: Modelling the summary tab

Lecture 2: Modelling equity and debt exposure

Lecture 3: Sensitivity analysis

Chapter 6: PART 4 – Add-on lectures

Lecture 1: Corporate structure

Lecture 2: JV partnerships

Lecture 3: Residential space for sale vs for rent

Chapter 7: PART 5 – Case Studies

Lecture 1: Case Studies Introduction

Lecture 2: Case Study #1 – part 1

Lecture 3: Case Study #1 – part 2

Lecture 4: Case Study #2

Lecture 5: Case Study #3

Instructors

David Ksir
Investment professional

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu