Essential Real Estate Modeling in Excel

Essential Real Estate Modeling in Excel

Course summary

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

7. 
   

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 Retail, FMCG, SMG, B2B, and services sectors that I worked for. I have carried or supervised over 90 different performance improvement projects in different industries that generated in total 2 billion of 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 now are 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 124 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, tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, 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 modification, 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 Schools and sometimes struggle with some financial analyses, including modeling of 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 that did study 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 that did not finish business school or Economics. The course will help you become an expert in modeling real estate on 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 tones of analyses, tricks, hints that will significantly improve the speed with which you understand, analyze the 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 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 the course is organized?

The course is divided currently 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 in Excel buying and renting apartments. We will first look at renting 1 apartment and then what would happen if we do it on a much bigger scale

• Modelling 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 the discuss 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.

• Modeling of Profit & Loss statement in practice. In the 5th section, I show you how to model the profit and loss statement of a company in Excel. A business model of the firm you can use to understand the business, forecast future growth, or for valuation purposes

• Modeling Flips. In the 6th section, we will discuss the modeling of so-called flips. Again we will discuss the business model and after that, we will model it in Excel.

• Restaurant Business model. In the last section, I will show you a model related to the real estate model – a restaurant business chain

You will be able also to download many additional resources

1. Useful frameworks and techniques

2. Analyses and models are shown in the course

3. Links to additional presentations, articles, and movies

4. Links to books worth reading

At the end of my course, students will be able to…

• How to build from a scratch a functional, dynamic real estate financial model

• How to understand the different business models in real estate

• Main KPIs in different real estate business models

• Model in Excel real estate

• How to analyze models of real estate in Excel

• How to decide on investment based on a model in Excel

• Evaluate potential investments in Buy & Rent

• Evaluate potential investments in Flips, Airbnb, Hotels

Who should take this course? Who should not?

• Management Consultants and Business Analysts

• Financial Analysts

• Investment Analysts

• Financial Controllers

• People interested in real estate

• Investors in real estate

What will students need to know or do before starting this course?

• Basic or intermediate Excel

• Basic or intermediate knowledge of finance & accounting

A practical guide on how to create financial models in Excel of real estate for Management Consultants & Investors

Url: View Details

What you will learn

• How to build from a scratch a functional, dynamic real estate financial model
• How to understand different business model in real estate
• The main KPIs in different real estate business models

Rating: 4.8

Level: Intermediate Level

Duration: 3 hours

Instructor: Asen Gyczew