Property Analysis Made Easy

The course starts with the basics in Excel and progressively gets more difficult as new concepts teach you the thought process of creating complex models and formulas from scratch. At each level, users can expect a breakdown of concepts, definitions, and key real estate metrics as well as a voice-over video recording that shows step-by-step how to build models from scratch. In addition, each level includes two case studies that quiz you over the material taught in each level to ensure accuracy and understanding of materials covered.

This is an optional level that walks the user through the basics of Excel. It includes a video that begins with Excel navigation (how to highlight, add/delete rows and columns, insert tabs, etc.) and teaches users simple formulas and basic Excel functions.

Level 2 builds off of the previous level by calculating the levered NPV and IRR. Because these values include debt, the user will learn how a loan is amortized, how to build an amortization table, and how to integrate the debt calculations into their cash flow model.

Level 4 is the first case study that includes a rent roll that ties into the model. By the end of this level, the user should be able to write complex formulas in a more efficient manner.