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.
Basic Unlevered Calculation
At the end of this level, the user should feel comfortable with the basics of Excel, writing formulas, locking cells properly, and calculating the unlevered net present value (NPV) and internal rate of return (IRR).
Unlevered and levered investment property analysis
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.
This level teaches the user how to build more complex formulas while working through three different scenarios: a fully amortized loan, a partially amortized loan, and a partially amortized loan with an interest-only period.
Advanced property analysis
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.
All-inclusive case study
The final level provides a case study that will test the user's cumulative knowledge of the course. The user will build a model completely from scratch (no pre-filled headers or boxes) by utilizing the skills previously learned. By the end of this level, users should feel confident building commercial real estate models.
FARM Users Now Work At Companies Including
Our users' excel skills have helped them land jobs at top companies around the globe