Essential Real Estate Modeling in Excel from Udemy

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:

Essential concepts related to real estate and modeling them in Excel
What are the main drivers of the profits in real estate for different business models?
How to model the buy & rent of real estate in Excel
How to model in Excel hotels and other short-term renting businesses (Airbnb, Booking)
How to model in Excel flips/flipping
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 Retail I have carried out or supervised over 90 different performance improvement projects in different industries that generated in 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 now are Partners in PE and VC funds, Investment Directors and Business Analysts in PE and VC, Operational Directors On top of that my courses on Udemy were already taken by more than 224 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 Excels 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 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 who 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 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:

Essential concepts related to real estate and modeling them in Excel
What are the main drivers of the profits in real estate for different business models
How to model the buy & rent of real estate in Excel
How to model in Excel hotels and other short-term renting businesses (Airbnb, Booking)
How to model in Excel flips/flipping
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 the 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
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 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

Useful frameworks and techniques
Analyses and models are shown in the course
Links to additional presentations, articles, and movies
Links to books worth reading

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

How to build from 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

What's inside

Learning objectives

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

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

Syllabus

Introduction

We begin with a little intro into the course as well as some general info on how the course is organized

A few words about your humble teacher

I will show you briefly how the course is organized

Here I will show you what to do if a blurry image appears

Here I will show you how to find additional resources attached to the course like Excel files, presentations, links, etc.

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

There are 4 main things you can do around the real estate.

But to Sell
Rent
Build
Servicing Real Estates

We will discuss it in more detail is this lecture

In this lecture, we will discuss the time value of money in other words what is the difference in value between 100 USD received today and 100 USD received tomorrow

In this lecture, I will show you how to calculate the time value of money in Excel

In this lecture, we will discuss what NPV - Net Present Value is and how to use it in practice

NPV stands for Net Present Value
NPV is the difference between the present value of cash inflows and the present value of cash outflows over a period of time usually related to some investment
It’s used to determine whether something (action, investment, etc.) makes sense or not

NPV enables you to make decisions about a specific investment. We will discuss how to use that as well. Later on, we will use this concept extensively to make decisions about investments

Linked to NPV is the so-called IRR. We will discuss it in this lecture:

IRR stands for Internal Rate of Return
IRR is a discount rate that makes the net present value (NPV) of all cash flows from a particular project equal to zero
IRR tells us how much you would have to earn on a saving account every year to get to the same results as from the investment you are analyzing

In this lecture, I will show you how to use in practice in Excel the NPV

Here we will discuss a very useful concept that is used in business and should be also used when making serious long-term decisions the so-called the total cost of ownership

Let’s imagine that Peter is considering 2 choices: buying an apartment or renting it. Let’s use the total cost of ownership to see what makes sense.

In this lecture, I will show you the solution to the previously introduced case study

When it comes to real estate, we have 3 main groups. The majority invest in residential real estates

Residential
Commercial
Land

We will generally discuss how you can earn on residential real estates

Of course, real estate has its risk factors as well. We will discuss them in this lecture

Let’s have a look at the main elements of the Loan

Principal
Interest rate
Loan Duration
Interest Paid
Payments

First, let’s divide the loan in terms of how they are being paid

Fully Amortized Loan / Annuity
Interest-Only Loan
Other

Let’s have a look at how the payment of the Fully Amortized Loan would look like.

We will look at different types of loans and how to calculate them in Excel

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 at a much bigger scale

Let’s imagine that John is considering investing in an apartment that he wants to rent. He will be using a mortgage/loan to finance the purchase.

Let’s have a look at the apartment that he considers buying to rent

He considers buying 1 small apartment in Warsaw
He will put USD 20 K of his own money
For the rest, he will take a mortgage for 20 years with an interest rate of 4.0%
Help John estimate how much he can earn from this investment

Now we will move to modeling the business model of a hotel or similar models where you rent on daily basis (Airbnb, Booking.com, etc.). They differ from the traditional Buy & Rent Models.

In this lecture, I will show you the solution to the previously introduced case study.

After the first investment, John is considering going big scale and buying an apartment every year. Help him analyze the value of his assets.

Let’s first look at the Margin after Variable Costs and after that at the drivers of the EBITDA.

Paul has some capital from selling his SaaS startup. Now he wants to invest some of his money into a chain of hotels. Help him estimate how much money he has to invest.

Paul has some capital from selling his SaaS startup. Instead of hotels he considers also renting apartments and offering them on Airbnb or Booking

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.

We will be using 3 different terms for flips

Flip / Flipping
Flip duration
Slot

We will explain them in this lecture

We will have at the main drivers for flips

Javier wants to do flips on a bigger scale. He wants to take 1 new loan (slot) every year. Help him estimate how much money he can make from this business.

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Provides practical, step-by-step guidance with analyses, tricks, and hints to improve the speed of understanding and analyzing real estate businesses, which is useful for financial analysts

Aims to equip management consultants and business analysts with the skills to model real estate investments efficiently in Excel, enhancing their analytical capabilities and career prospects

Explores various real estate business models, including buy & rent, hotels, Airbnb, and flips, providing a comprehensive understanding for making informed investment decisions, which is helpful for real estate investors

Requires basic to intermediate knowledge of finance and accounting, which may pose a challenge for learners without a foundational understanding of these concepts, which is a caveat for some financial analysts

Requires basic to intermediate Excel skills, which may be a barrier for some learners who are not already proficient in using this software, which is a caveat for some real estate investors

Reviews summary

Practical real estate modeling in excel

According to learners, this course provides a highly practical and hands-on approach to real estate financial modeling in Excel. Students appreciate the real-world case studies and the provision of downloadable Excel files, which allow for direct application. While some reviewers found the content to be more foundational or a good refresher, many highlighted its effectiveness for building functional and dynamic models from scratch. The course covers various business models including Buy & Rent, Airbnb/Hotels, and Flips, which is seen as a comprehensive overview for those new to modeling these specific areas. A few notes suggest ensuring you have basic Excel and finance knowledge beforehand to get the most out of the material. Overall, it's considered a valuable resource for professionals and investors.

Helpful for beginners or a good refresher.

"This is a great starting point if you are new to real estate modeling in Excel."

"For someone with some finance background, this is a great refresher and practical guide."

"It lays a solid foundation for building real estate models, though some parts were basic for me."

Covers various real estate business models.

"It covers buy & rent, hotels, and flips. Good variety for different investment types."

"Modeling different business models like Airbnb and flips is a great feature of this course."

"The coverage of various investment strategies is quite thorough for an introductory course."

Uses relevant examples from real estate scenarios.

"The case studies were very helpful in understanding how to apply the concepts in real life."

"I appreciate the real-life examples used throughout the course, it makes it very relevant."

"Applying concepts to actual real estate scenarios made the learning stick."

Focus on hands-on modeling with Excel files.

"The course is very hands-on and provides practical tools. I could follow along easily."

"I really liked the practical examples and being able to download the Excel files to practice."

"Provides practical step-by-step guidance with tons of analyses and useful tips from experience."

Need basic Excel and finance knowledge.

"Make sure you have basic Excel skills before taking this course, otherwise it might be challenging."

"You need a basic understanding of finance and accounting concepts to follow the material."

"Coming in with some prior knowledge helps you get the most out of the examples."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Essential Real Estate Modeling in Excel with these activities:

Review Essential Excel Formulas

Show steps

Refresh your knowledge of essential Excel formulas to build a strong foundation for financial modeling.

Show steps

Identify key Excel formulas used in financial modeling.
Practice using these formulas with sample datasets.
Review online resources and tutorials for formula usage.

Read 'Real Estate Finance & Investments' by Brueggeman and Fisher

Show steps

Expand your understanding of real estate finance principles with a comprehensive textbook.

View Real Estate Finance & Investments ISE on Amazon

Show steps

Obtain a copy of 'Real Estate Finance & Investments'.
Read chapters related to valuation and investment analysis.
Take notes and summarize key concepts.

Model a Buy & Rent Scenario

Show steps

Apply your knowledge by creating a financial model for a buy and rent real estate investment.

Show steps

Gather data on a potential buy & rent property.
Build a financial model in Excel to forecast cash flows.
Analyze the model to determine investment feasibility.
Refine the model based on course learnings.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Create a Presentation on Real Estate KPIs

Show steps

Solidify your understanding of key performance indicators (KPIs) by creating a presentation.

Show steps

Research common KPIs used in real estate analysis.
Prepare slides explaining each KPI and its significance.
Present your findings to peers or colleagues.

Follow Advanced Excel Modeling Tutorials

Show steps

Refine your Excel skills by following tutorials on advanced modeling techniques.

Show steps

Search for tutorials on topics like scenario analysis.
Follow the tutorials step-by-step, applying the techniques.
Incorporate these techniques into your real estate models.

Read 'The Book on Rental Property Investing' by Brandon Turner

Show steps

Gain practical insights into rental property investing from an experienced investor.

View The Multifamily Millionaire, Volume I: Achieve... on Amazon

Show steps

Obtain a copy of 'The Book on Rental Property Investing'.
Read chapters related to finding deals and financing.
Apply the advice to your own real estate models.

Build a Sensitivity Analysis Tool

Show steps

Enhance your models by creating a tool to perform sensitivity analysis on key variables.

Show steps

Identify key variables in your real estate models.
Create a tool in Excel to vary these variables.
Analyze the impact of these changes on investment returns.

Career center

Learners who complete Essential Real Estate Modeling in Excel will develop knowledge and skills that may be useful to these careers:

Real Estate Analyst

A Real Estate Analyst uses financial modeling to evaluate property investments and market trends. This course, with its focus on modeling real estate in Excel, directly prepares you for the analytical work involved in this role. You will learn to forecast cash flow, model loan payments, and analyze different real estate business models. The course offers hands-on experience, which includes analyzing different real estate investments, such as buy and rent, hotels and short term rentals, and flips. You will gain direct experience building dynamic models using excel, a critical skill for a Real Estate Analyst. The course teaches skills that helps build a foundation to make investment decisions, a key aspect of the job.

See salaries and explore the career path for Real Estate Analyst

Investment Analyst

An Investment Analyst researches and evaluates investment opportunities, and this course can help you develop key competencies using Excel models to analyze real estate investments. The course teaches how to analyze and interpret real estate business models for various strategies, which includes buy and rent, hotels, and flips. You will learn to use Excel to model cash flows, assess profitability, and understand the key performance indicators specific to real estate. Given this practical training, you will be prepared to evaluate potential real estate investments and make data-driven recommendations. You will be able to use insights from this course to make investment recommendations.

See salaries and explore the career path for Investment Analyst

Financial Analyst

The role of a Financial Analyst includes developing financial models, projections, and valuations. This course directly supports skills used by a Financial Analyst by teaching you to model various real estate investment scenarios in Excel. You will learn to forecast cash flows, understand the drivers of different real estate business models like buy and rent, flips, and short-term rentals, and make investment decisions based on your analysis. The course emphasizes practical application with case studies and Excel-based modeling, mirroring the real-world tasks of a Financial Analyst. By learning how to build a functional real estate model from scratch, you will have a valuable skill for financial analysis.

See salaries and explore the career path for Financial Analyst

Management Consultant

Management Consultants often need to analyze different business models and offer strategic recommendations, and this course is useful because it teaches you how to model real estate in Excel. The course emphasizes practical application with real-life case studies, providing hands-on experience in modeling different real estate business models. You will also learn to forecast cash flows, understand key performance indicators, and make investment decisions based on your findings. This will help you in your role as a Management Consultant. By gaining a deeper understanding of the real estate sector, you can bring value to your projects.

See salaries and explore the career path for Management Consultant

Business Analyst

Business Analysts need to understand business processes and translate them into data driven insights. This course enhances a Business Analyst's skills in financial modeling, particularly in the real estate sector. You will learn how to model different real estate business models in Excel, which includes buy and rent, hotels, and flips. The course's emphasis on practical application and case studies helps build valuable experience in financial analysis. This knowledge helps you to better analyze real estate related business processes which will help you in your role as Business Analyst.

See salaries and explore the career path for Business Analyst

Real Estate Portfolio Manager

A Real Estate Portfolio Manager oversees a collection of real estate assets, and this course provides a critical skill set. The course teaches how to model different business ventures in Excel, which includes buy and rent, hotels, and flips. With the skills taught, you will understand how to analyze cash flows, assess profitability, and make investment decisions. You will learn how to use Excel to evaluate the financial viability of investments, which helps with building and managing a real estate portfolio. The course's hands-on approach to modeling will give a sound foundation for managing a real estate portfolio. A Real Estate Portfolio Manager is often required to have an advanced degree.

See salaries and explore the career path for Real Estate Portfolio Manager

Commercial Real Estate Agent

A Commercial Real Estate Agent facilitates the buying, selling, and leasing of commercial properties. This course may be useful given that it teaches how to model real estate in Excel. The course provides a foundation in understanding real estate business models, including buy and rent, hotels and short term rentals, and flips, all of which can be applied to commercial properties. You may use the course's learnings to better understand property values, and build models to better negotiate deals with buyers or sellers. The course can help you understand the financial aspects of real estate. The course may help you communicate value of a property to clients.

See salaries and explore the career path for Commercial Real Estate Agent

Real Estate Development Associate

A Real Estate Development Associate helps in the planning and execution of real estate projects. While this course does not focus on the construction and development, it helps by teaching how to model real estate in Excel. The course teaches how to analyze different real estate business models, including buy and rent, hotels, and flips. You will learn how to model cash flows, assess profitability, and make investment decisions, which are all useful in the planning phase of a real estate project. With the skills taught, you will evaluate the financial feasibility of different projects. This course may be helpful for an aspiring Real Estate Development Associate.

See salaries and explore the career path for Real Estate Development Associate

Property Manager

A Property Manager oversees the daily operations of residential or commercial properties. This course may be useful because it teaches financial modeling in real estate in excel. The course will help you understand the different business models, such as buy and rent, hotels, and short-term rentals, and how to model them. With the skills learned, you can better understand the financial impact of managing a property, which includes understanding revenues, expenses, and profitability . By using the course's financial modeling techniques, a Property Manager can optimize property performance. This course may be useful for a property manager.

See salaries and explore the career path for Property Manager

Financial Controller

A Financial Controller manages the accounting and financial reporting of an organization. This role utilizes similar financial modeling skills as taught in this course. While this course teaches about real estate, those same skills can be utilized in a general finance setting. The experience of modeling cash flows, assessing profitability, and analyzing different business models, all provide a useful foundation in general finance and accounting. The course focuses on Excel which is central to financial reporting. Although this course focuses on real estate, it may be useful for a Financial Controller.

See salaries and explore the career path for Financial Controller

Consultant

Consultants work with various client companies on strategy, operations, and other business needs. This course may be useful for Consultants who work with real estate clients or need to analyze real estate models. By using the Excel based techniques and case studies in this course, a Consultant may have some additional insights when providing recommendations. The course teaches how to model the financials behind different business models including hotels, buy and rent, and flips. This course may be useful in a consultant's broader skill set.

See salaries and explore the career path for Consultant

Data Analyst

A Data Analyst collects and interprets data to help organizations make better decisions. This course may be useful given that it teaches Excel based analysis of real estate. While the course focuses on real estate, you will learn principles that can be used in analysis and data modeling. The course will improve your Excel based analysis skills, which is a key skill for a data analyst. This course may be useful for a data analyst.

See salaries and explore the career path for Data Analyst

Operations Analyst

An Operations Analyst analyzes and improves the efficiency of business operations. While the course focuses on real estate analysis, it may be useful because it teaches how to use excel to analyze business models. The course will improve your ability to create and analyze models, something that can be used in any operational setting. The principles taught in the course, namely how to analyze a business model, may be useful for an Operations Analyst. This course may be helpful to an Operations Analyst.

See salaries and explore the career path for Operations Analyst

Market Research Analyst

A Market Research Analyst studies market conditions to examine potential sales and demand for a product or service. This course may be useful because you will learn how to understand real estate business models and use Excel to model them. The course provides a practical application of Excel which is helpful for many types of analysis. The course may improve an analyst's ability to assess and understand different markets based on models. The course may be helpful for a Market Research Analyst.

See salaries and explore the career path for Market Research Analyst

Project Manager

A Project Manager plans, organizes, and manages resources to bring about the successful completion of specific project goals and objectives. While this course is focused on real estate financial modeling, the skills of financial analysis and interpretation can be very useful in managing a project's budget and financials. The course helps build a proficiency in Excel based analysis. Although this course does not focus on project management, it may be helpful to a project manager to better understand project financials.

See salaries and explore the career path for Project Manager

Essential Real Estate Modeling in Excel

What's inside

Learning objectives

Syllabus

Traffic lights

Save this course

Reviews summary

Practical real estate modeling in excel

Activities

Career center

Reading list

Share

Similar courses