X

Essential Real Estate Modeling in Excel

 
  • Filter
  • Time
  • عرض
مسح الكل
مشاركات جديدة

    Essential Real Estate Modeling in Excel

    Practical guide for Business Analysts, Management Consultants & Investors



    What you'll 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
    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


    Requirements
    Management Consultants & Business AnalystsFinancial AnalystsInvestment AnalystsFinancial ControllersPeople interested in real estateInvestors in real estate


    Description
    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:
    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 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, 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 90 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 schools 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:
    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 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 at a much bigger scale
    Modelling Airbnb & Hotels. In this section, I will show you how the model in Excel 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


    Created by Asen Gyczew | Last updated 5/2021
    Duration: 3h 3m | 6 sections | 64 lectures | Video: 1280x720, 44 KHz | 1.3 GB
    Genre: eLearning | Language: English + Sub


    Download
    http://s9.alxa.net/0abc1/00dd/Essent...g.in.Excel.rar

    Similar Threads
Working...
X