Aaron Hancock – Real Estate Financial Modeling9 Courses20h 1m74,232 StudentsThis real estate financial modeling course is delivered at the world’s leading real estate private equity firms and academic institutions.Learn to Build a Real Estate Financial Model Step-By-StepThis program has everything you need to build and interpret real estate finance models. All major real estate “food groups” are covered, including Multifamily, Office, Retail, and Industrial.Get 20+ Hours of Video Content + Reusable Real Estate Excel Model Templates Get lifetime access to step by step online video training as well as industry-grade reusable real estate excel templates for modeling acquisitions and developments for multifamily, office, retail, industrial properties, including JV & Waterfall Modeling.Learn from Real Estate practitioners Led by real estate private equity expert Aaron Hancock, you’ll not only learn modeling best practices across the different real estate property types, you’ll learn how real estate investors actually evaluate opportunities.Enhance your Real Estate credentials Designed for professionals and students pursuing careers in real estate private equity as well as operators, developers, lenders, individual investors. Enrollment includes the option of sitting for the Real Estate Financial Modeling Certification. Those who successfully pass the exam can present their achievement on their resumes and LinkedIn (see below).A Comprehensive Real Estate Financial Modeling ProgramThis course begins with the foundations of real estate finance and excel best practices, adding complexity piece by piece. By the end of the program, learners will build complete, industrial grade multifamily, office, retail and industrial models, including in depth treatment of the modeling of revenues, operating expenses, capital improvements, debt, and joint venture waterfallsReal estate financial modeling best practicesReal estate investment and development theoryHow to utilize historical financials to build a multifamily acquisition modelHow to utilize Argus outputs to build a commercial acquisition modelHow to build a real estate development modelHow to model a debt scheduleHow to model a joint venture waterfallThis program includes the following 9 modulesEach module builds sequentially towards a complete understanding of the Real Estate model building process112 Lessons0h 54mIntroduction to Real Estate ModelingSection 1 of our Real Estate Financial Modeling Program. This course provides an introduction to the function of real estate financial models, the challenges presented by bespoke approaches, and Wall Street Prep’s approach to teaching Real Estate Financial Modeling. We will begin with a review of efficiency and formatting fundamentals that will be …View Course TOC266 Lessons3h 35mOperating Cash FlowSection 2 of our Real Estate Financial Modeling Program. Real estate is all about cash flow. This module will cover cash flow builds for multifamily and commercial property types. We will build the foundations of revenues and expenses and finish with a discussion on the importance of net operating income. Each section will begin with the characteri …View Course TOC322 Lessons1h 19mNon-Operating Cash FlowSection 3 of our Real Estate Financial Modeling Program. Although real estate is valued based on operating cash flow, non-operating cash flows are integral to business plans. This module will cover leasing costs for commercial properties, capital improvements and costs associated with buying and selling a property. After detailed discussions of the …View Course TOC427 Lessons2h 9mDebt & Levered Cash FlowSection 4 of our Real Estate Financial Modeling Program. Real estate is a highly levered asset class and an understanding of leverage is critical for any real estate investor. This module will serve as a primer on real estate debt, covering everything from different ways to finance an acquisition, to key terms in loan documents and how to model an …View Course TOC522 Lessons2h 1mJoint Ventures & WaterfallsSection 5 of our Real Estate Financial Modeling Program. The waterfall is infamously part of most real estate interview modeling tests. This module introduces joint ventures and the theory behind waterfalls. After introducing key terminology and reinforcing the underlying theory, considerable time will be spent on a step-by-step walkthrough of how …View Course TOC626 Lessons2h 31mSummarizing & Analyzing the ModelSection 6 of our Real Estate Financial Modeling Program. Real estate financial models are tools for projecting the cash flows of a potential investment. The cash flow projections alone are not enough to analyze a potential investment. This module will cover how to summarize the outputs of a model to form the basis of an analysis by discussing key m …View Course TOC741 Lessons3h 12mDevelopment ModelingSection 7 of our Real Estate Financial Modeling Program. Real estate can be bought or built. Up to this point, the course has been focused on buying property. This module will unpack the differences and similarities in modeling a development and an acquisition. Development specific topics such as construction budgets and lease-up will be covered as …View Course TOC813 Lessons1h 35mOffice Building Acquisition Case StudySection 8 of our Real Estate Financial Modeling Program. Building well-formatted and extensive models is the name of the game for those working for institutional firms or preparing materials for a potential investor. But, many situations – whether a modeling test or first pass at a potential personal investment – necessitate building a model quickl …View Course TOC914 Lessons2h 45mMultifamily Building Development Case StudySection 9 of our Real Estate Financial Modeling Program. Building well-formatted and extensive models is the name of the game for those working for institutional firms or preparing materials for a potential investor. But, many situations – whether a modeling test or first pass at a potential personal investment – necessitate building a model quickl