Real Estate Financial Modeling

All | Argus| Excel Models | Excel Tips | Stochastic Modeling

Real Estate Financial Modeling Accelerator (Updated May 2026)

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…

RE Education, Real Estate Financial Modeling, Excel Tips, Excel Models, Tutorial, Modules, Development

S-Curve Forecasting in Real Estate Development (Updated June 2026)

One of the reasons Michael and I blog, is to force ourselves to be continually learning. I built the first version of my real estate waterfall model, because I wanted to better understand the mechanics of modeling an equity waterfall with IRR…

RE Education, Real Estate Financial Modeling, Excel Models, Tutorial, Modules, Development, Watch Me Build

Watch Me Build A Construction Draw Schedule (Updated Feb 2026)

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…

RE Education, Careers, Real Estate Financial Modeling, Excel Models, Interviews, Tutorial, A.CRE 101 - Basic Concepts in Commercial Real Estate, Watch Me Build, Real Estate Case Studies, Office, Development

Watch Me Solve a REPE Technical Interview Modeling Test (Updated Sept 2025)

What better way to spend some free time over the Thanksgiving holiday, than to record myself completing a real estate private equity technical interview exercise! While I've offered help with the real estate technical interview in the past,…

Real Estate Financial Modeling, Excel Tips, Excel Models, Single Family, Tutorial, Land Development, A.CRE 101 - Basic Concepts in Commercial Real Estate, Watch Me Build

Watch Me Build a Residential Land Development Model (Updated June 2025)

Over the years, we've created a sizable library of Watch Me Build videos covering Excel models for various real estate investment and property types. However, we've yet to create a Watch Me Build involving for-sale product. So this weekend,…

Real Estate Financial Modeling, Excel Tips, Excel Models, Tutorial

Tutorial on How to Model Irregular Growth Rates in Real Estate

When building a real estate financial model, managing income and expense growth is rarely as simple as applying a fixed growth rate year over year. In real estate investment analysis, growth assumptions need to be flexible, dynamic, and reflective…

RE Education, Real Estate Financial Modeling, Excel Tips, Excel Models, Tutorial, Modules, Debt, A.CRE 101 - Basic Concepts in Commercial Real Estate, Watch Me Build

Watch Me Build a Dynamic Mortgage Amortization Table in Excel (Updated September 2024)

There are a few basic, yet fundamental, real estate modeling skills you must master before anyone will take you seriously as a real estate professional. Building a mortgage amortization schedule is one of them. Virtually every model you…

Real Estate Financial Modeling, Excel Tips, Excel Models, Tutorial, Equity Waterfall, A.CRE 101 - Basic Concepts in Commercial Real Estate, Watch Me Build

Watch Me Build a 3-Tier Real Estate Equity Waterfall Model (Updated Aug 2024)

As I've mentioned in other Watch Me Build posts, one way to become a better real estate financial modeling professional, is to watch other professionals model. Thus, the more exposure you can get to other's methods, the more adept a real estate…

RE Education, Real Estate Financial Modeling, Excel Tips, Excel Models, Tutorial, Excel Add-ins, Stochastic Modeling, Deep Dive

How to Run Monte Carlo Simulations in Excel (Updated Aug 2024)

So you want to run Monte Carlo simulations in Excel, but your project isn't large enough or you don't do this type of probabilistic analysis enough to warrant buying an expensive add-in. Well, you've come to the right place. Excel's built-in…

Real Estate Financial Modeling, Excel Models, Tutorial, Asset Management, A.CRE All-in-One (Ai1) Model, Ai1 Tutorials, Deep Dive, Asset Management

Hold-Sell Analysis in Real Estate (Updated June 2024)

In course 3 of our A.CRE Accelerator, we use a case study that revolves around a hold-sell (i.e. hold vs sell) analysis scenario to teach the anatomy of the real estate DCF. In that scenario, the student is an asset manager working for an open-end…

General, RE Education, Real Estate Financial Modeling, Tutorial, Deep Dive, Valuation

Why Your IRR and XIRR are Different (Updated June 2024)

This post was inspired by a question on our real estate financial modeling Accelerator forum. Additionally, Spencer and I frequently get emails asking about this very issue, which is 'why the IRR (internal rate of return) and XIRR (extended…

RE Education, Real Estate Financial Modeling, Excel Models, Tutorial, Special Topics, A.CRE 101 - Basic Concepts in Commercial Real Estate

A.CRE 101: How to Use the Income Capitalization Approach to Value Income-Producing Property (Updated May 2024)

In commercial real estate, there are a few generally accepted methods for appraising (or valuing) real property. The three most common are the Cost Approach, the Sales Comparison Method, and the Income Approach. The Income Approach includes…

RE Education, Real Estate Financial Modeling, Excel Tips, Excel Models, Office, Retail, Industrial, Tutorial, Modules, Watch Me Build, Artificial Intelligence, AI Applications for CRE

Watch Me Build – Modeling a Rent Schedule in Both Excel and Using AI (Updated May 2024)

In this Watch Me Build video I show you how to build a custom rent schedule module for long-term leases. The foundation of the module is a simple INDEX/MATCH combination that takes a rent schedule and models the rent cash flows across the entire…

Real Estate Financial Modeling, Excel Tips, Excel Models, Tutorial

Hide and Unhide Tabs using Drop-down Menus in Excel (Updated Apr 2024)

I'd like to share a handy little trick I learned this week for hiding and unhiding tabs in Excel using drop-down menus. Now this method requires you to use some basic VBA code and to save the Workbook as a Macro-Enabled file but don't be intimidated…

Real Estate Financial Modeling, Tutorial, Equity Waterfall, A.CRE 101 - Basic Concepts in Commercial Real Estate, Watch Me Build

Watch Me Build – American-Style Real Estate Equity Waterfall (Updated Apr 2024)

A few years ago, I recorded my screen as I built a 3-tier real estate equity waterfall model. What I didn't mention in that Watch Me Build video, is that the kind of waterfall I built is colloquially called a European-style equity waterfall.…

Real Estate Financial Modeling, Excel Models, Tutorial, Investment Analysis, Special Topics, A.CRE 101 - Basic Concepts in Commercial Real Estate, Deep Dive, Valuation

Modeling a Property Tax Abatement in Real Estate (Updated Jan 2024)

We often field questions about how to model property tax abatements. It's a concept we cover in our the 'Advanced Modeling - Property and Portfolio' endorsement in our Accelerator real estate financial modeling training program and something…