Property Analysis Made Easy

Two students working on a computer together.
Image of Student on computer smiling at camera.

About the Course

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.

Image of teacher pointing at whiteboard.

Level 0

Basics (Optional)

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.

Image of Excel dashboard showing basics.
Image of Excel dashboard showing unlevered calculation.

Level 1

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).

Level 2

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.

Image of Excel Dashboard showing Excel assumptions.
Image of Excel Dashboard showing multi-property analysis.

Level 3

Multi-property analysis

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.

Level 4

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.

Image of Excel dashboard showing computational assumptions.
Image of All-Inclusive case study in Excel.

Level 5

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