Essential Real Estate Modeling in Excel (Udemy.com)

What is the aim of this course?

Modeling real estate in Excel is not easy. In real estate, you will have to forecast the cash flow for long investment periods. In most models, you will have to forecast loan payments, maintenance costs, operational costs, and potential revenues from operating the real estate. On top of that, in real estate, we have different business models that will have different business drivers. To make your work easier, I will teach you in this course how to model in Excel fast and efficiently real estate investments.

In this course, you will learn the following things:

1. Essential concepts related to real estate and modeling them in Excel

2. What are the main drivers of the profits in real estate for different business models?

3. How to model the buy & rent of real estate in Excel

4. How to model in Excel hotels and other short-term renting businesses (Airbnb, Booking)

5. How to model in Excel flips/flipping

6. How to make decisions on the investment in real estate, based on the Excel model

This course is based on my 15 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, performance improvement, and turn-arounds in the biggest firms from the Retail, FMCG, SMG, B2B, and services sectors that I worked for. I have carried out or supervised over 90 different performance improvement projects in different industries that generated a total of 2 billion in additional EBITDA. On the basis of what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who are now Partners in PE and VC funds, Investment Directors and Business Analysts in PE and VC, Operational Directors, COO, CRO, CEO, Directors in Consulting Companies, Board Members, etc. On top of that, my courses on Udemy were already taken by more than 350 000 students, including people working in EY, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others.

I teach through case studies, so you will have a lot of lectures showing examples of analyses and tools that we use. To every lecture, you will find attached (in additional resources) the Excel files as well as additional presentations and materials shown in the lectures, so as a part of this course, you will also get a library of ready-made analyses that can, with certain modifications, be applied by you or your team in your work.

Why did I decide to create this course?

Modeling real estate in Excel is not easy. Many Management Consultants and Analysts did not finish Business School and sometimes struggled with some financial analyses, including modeling real estate. This sometimes puts them at a disadvantage and makes it difficult for them to get promoted. On top of that, many consultants and analysts who studied finance at university/college have forgotten some things.

Therefore, I have decided to create this course that will help students understand or refresh how to model real estate in Excel. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know how to understand the different business models in real estate and how to model them properly in Excel. I will also show you how to draw conclusions based on the model in Excel.

To sum it up, I believe that if you want to become a world-class Financial Analyst, Management Consultant, or Business Analyst, you have to have a pretty decent understanding of real estate. That is why I highly recommend this course to Management Consultants or Business Analysts, especially those who did not finish business school or Economics. The course will help you become an expert in modeling real estate at the level of McKinsey, BCG, Bain, and other top consulting firms.

In what way will you benefit from this course?

The course is a practical, step-by-step guide loaded with tons of analyses, tricks, and hints that will significantly improve the speed with which you understand and analyze businesses. There is little theory – mainly examples in Excel, and a lot of tips from my own experience, as well as other notable examples worth mentioning. Our intention is that, thanks to the course, you will learn:

1. Essential concepts related to real estate and modeling them in Excel

2. What are the main drivers of the profits in real estate for different business models

3. How to model the buy & rent of real estate in Excel

4. How to model in Excel hotels and other short-term renting businesses (Airbnb, Booking)

5. How to model in Excel flips/flipping

6. How to make decisions on the investment in real estate, based on the Excel model

You can also ask me any questions either through the discussion field or by messaging me directly.

How is the course organized?

The course is currently divided into 7 sections. Currently, you will find the following sections:

• Introduction. We begin with a little intro to the course, as well as some general info on how the course is organized

• Essential Concepts. Modeling real estate requires learning certain concepts that will help you handle the long-term nature of real estate. This is what we will discuss in this section.

• Modeling Simple Buy & Rent businesses. In this section, I will show you how to model buying and renting apartments in Excel. We will first look at renting 1 apartment, and then what would happen if we do it on a much bigger scale

• Modeling Airbnb & Hotels. In this section, I will show you how the model in Excel is a bit different business model – short-term rentals of real estate. We will first discuss the hotel business model, and we will model it in Excel. After that, we will look at a business model where we rent apartments from owners and sublet them through Airbnb.