Beginner Real Estate Financial Modelling Case Study - Course Overview (Beginner Real Estate Financial Model )

Welcome to the Beginner Financial Modeling Case Study. In this course, we'll build together a straightforward real estate financial model for a prime office asset leased to a single tenant on a long-term lease. This financial model will be completed in seven easily comprehensible video lessons. The cash-flow profile of this case study is relatively uncomplicated but it establishes the fundamental principles necessary for more advanced financial modeling courses. These future courses will prepare you to construct the type of intricate cash flow models used by prestigious real estate investment and private equity firms. Upon completing this course, you'll possess essential financial modeling concepts and basic Excel skills. You'll gain proficiency in building simple real estate financial models in Excel. Let's delve into the content of this case study: This case study revolves around a real estate private equity firm, Thanos Capital, with target returns of a 20% Internal Rate of Return (IRR) and a two times equity multiple. Your task is to assess whether acquiring a large office asset in Paris, as presented in the case, meets these target returns. Your boss requires a quick and flexible financial model but with no complexity. The assumptions for this model are relatively straightforward and do not include taxes, structure costs, rent-free periods, or additional void periods. The core question is whether Thanos Capital can pay the vendor's asking price of EUR 90 million while achieving the target returns. If not, you'll calculate how much they must reduce the price to attain their desired 20% IRR and two times equity multiple. The case study is divided into seven lessons, each building on the previous one. You'll gain access to separate financial models for each lesson. This approach makes it easy to track your progress and comprehend the incremental additions to the cash flow model. To access the financial models and materials, visit www.reia-edu.com and click on "Free Resources." You can then select the "Beginner Financial Model" and follow the prompts to download all the support files, including the financial models and presentation materials. Please click here to download the financial models and course materials: https://www.reia-edu.com/beginner-real-estate-financial-model This beginner financial modeling course lays a solid foundation for individuals looking to grasp the essential concepts of financial modeling, particularly within the context of real estate investments. As you progress through this course, you'll be well-prepared to tackle more advanced financial modeling challenges in the future.