Real Estate Financial Modeling

All | Argus | All-in-One | Excel Models | Excel Tips | Stochastic Modeling

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated July 2025)

Before launching the Accelerator program, Michael and I received countless emails requesting a more structured, step-by-step real estate financial modeling training program. Over the years, we've covered hundreds of real estate modeling…
, , ,

Dynamic Amortization Schedule (Updated 2.06.2020)

This is a dynamic amortization schedule for debt that gives the user the capability to model a loan with an interest only period up front and an amortizing floating rate debt repayment period once the interest only period is over. This module…
, ,

Using VBA to Hide Rows in Excel

Over the next few minutes, I will show you two techniques for automatically hiding and showing rows in Excel using VBA code. These techniques I use regularly in my real estate financial models to make for a more intuitive user experience. In…
, , , , ,

Watch Me Build Data Tables For Real Estate Sensitivity Analysis

This is a 3 part mini-series on using data tables in Excel to perform real estate sensitivity analysis. In this series, I'll walk you through how to build both one-variable and two-variable data tables in parts 1 and 2. And in Part 3, I'll walk…
,

Modeling a Mortgage Loan Assumption Using the All-in-One

I recently had a discussion in the All-in-One support forum about how to model a mortgage loan assumption using my All-in-One Model for Underwriting Acquisitions and Development. Prior to version 0.77, this required manually overriding various…
, , , , , ,

Watch Me Build A Construction Draw Schedule (Updated Jan 2020)

In the following video, I record my screen and narrative my steps as I build a basic construction draw schedule. I've also included the template and completed worksheets from this Watch Me Build exercise. Are you an Accelerator member? See…
, , ,

How to Create Dynamic, In-Cell Buttons and Toggles in Microsoft Excel

Creating intuitive, user-friendly, visually appealing models is one aspect of mastering real estate financial modeling. One way to make your models easy for people to use and more attractive in general is to use dynamic, theme-appropriate, in-cell…
, , , ,

Watch Me Expand the Home Construction Pro Forma

I'm regularly asked to expand my single family home construction pro forma to analyze the construction of more than one home. I've contemplated adding that functionality to the model, but it is such a custom task that no template could really…
, ,

All-in-One (Ai1) Walkthrough #1 – Permanent Debt Tab (Updated Nov 2019)

In an effort to provide greater instruction on how to use our All-in-One Underwriting Tool for Real Estate Development and Acquisition, we've developed a series of walkthrough videos and posts on the methodology behind the various components…
, ,

Using Conditional Formatting in Real Estate Financial Modeling

Your real estate financial models are only as good as their ability to be used by others. Or in other words, if others can't figure out how to use your model, it isn't worth much! So when building real estate financial model templates, besides…

Preferred Return – Simple Interest vs. Compound Interest

A concept common to real estate partnership structures, preferred return refers to the preference given to a certain class of equity partners when distributing available cash flow. The preferred return is generally calculated as either a percentage…
, , , , ,

Roll Up Your Monthly Cash Flow Line Items Into Annual Periods Using Only One Formula For The Whole Sheet

While building out my hotel development model (currently underway), I decided to take a break and record a video about how I roll up the monthly cash flow line items on my Monthly Cash Flow sheet into annual cash flow line items on a separate…
, , , ,

Hotel Acquisition Model – The Basic Model (Updated 10.9.2019)

The initial goal for the original Hotel Acquisition Model was to design a hotel proforma that would enable users to get deep into the weeds of practically every line item in their hotel analysis. Although I am super happy with how that hotel…
, , , , ,

Tutorials For The Hotel Valuation Model (Updated 07.23.19)

Welcome to the A.CRE Hotel Valuation Model's Tutorial Page. On this page you will find all the tutorials for the A.CRE Hotel Valuation model in Excel. There is a lot to learn within this model and over time, I'd like to show you both how to…
, , , ,

Using the Floating Summary Box in Real Estate Modeling

Over the next few minutes, I'll share a great modeling tip for efficiently visualizing the more salient metrics in your real estate models. Now I should mention, this is a tip I shared a few years ago. But given the complexity of many of the…