课程详情

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 ExcelWhat are the main drivers of the profits in real estate for different business models?How to model the buy & rent of real estate in ExcelHow to model in Excel hotels and other short-term renting businesses (Airbnb, Booking)How to model in Excel flips/flippingHow to make decisions on the investment in real estate, based on the Excel modelThis 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 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, COO, CRO, CEO, Directors in Consulting Companies, Board Members, etc. 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 ExcelWhat are the main drivers of the profits in real estate for different business modelsHow to model the buy & rent of real estate in ExcelHow to model in Excel hotels and other short-term renting businesses (Airbnb, Booking)How to model in Excel flips/flippingHow to make decisions on the investment in real estate, based on the Excel modelYou 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 organizedEssential 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 scaleModeling 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 purposesModeling 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 chainYou will be able also to download many additional resourcesUseful frameworks and techniquesAnalyses and models are shown in the courseLinks to additional presentations, articles, and moviesLinks to books worth readingAt the end of my course, students will be able to…How to build from scratch a functional, dynamic real estate financial modelHow to understand the different business models in real estateMain KPIs in different real estate business modelsModel in Excel real estateHow to analyze models of real estate in ExcelHow to decide on investment based on a model in ExcelEvaluate potential investments in Buy & RentEvaluate potential investments in Flips, Airbnb, HotelsWho should take this course? Who should not?Management Consultants and Business AnalystsFinancial AnalystsInvestment AnalystsFinancial ControllersPeople interested in real estateInvestors in real estateWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic or intermediate knowledge of finance & accounting

课程标签

0人关注该课程

主题相关的课程