A.CRE 101 – Watch Me Build

All | A.CRE 101 | Graduate Education | Special Topics | Book Reviews | CRE Terms | Find a Job

All | Watch Me Build

Real Estate Financial Modeling Accelerator (Updated June 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 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,…

RE Education, Real Estate Financial Modeling, Excel Models, Investment Analysis, Debt, Watch Me Build, Deep Dive

30/360, Actual/365, and Actual/360 – How Lenders Calculate Interest on CRE Loans – Some Important Insights (Updated July 2025)

(Updated August 7, 2019 to include a Watch Me Build video and Downloadable file) Commercial real estate lenders commonly calculate loans in three ways: 30/360, Actual/365 (aka 365/365), and Actual/360 (aka 365/360). Real estate professionals…

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,…

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, 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, 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.…

RE Education, Watch Me Build, Artificial Intelligence, AI Applications for CRE, AI Training, AI Tools for CRE, Custom GPT

Watch Me Build – Industrial Offering Memorandum Analyzer Custom GPT

In this Watch Me Build session, I'll walk you through constructing a custom GPT that near-instantly sifts through Industrial Offering Memorandums to pinpoint whether an investment aligns with your criteria. At the heart of this build is a tailored…

Watch Me Build, Artificial Intelligence, AI Applications for CRE, AI Training, AI Tools for CRE

Create Your First AI Tool: Sales Comp Database ChatGPT Plugin

Traditionally in commercial real estate, each organization builds its own proprietary sales comp database and then gives its analysts access to that database in order to perform comp analysis. As AI becomes more and more important, pairing the…

General, RE Education, Real Estate Financial Modeling, Excel Models, Tutorial, Equity Waterfall, Modules, Excel Add-ins, Watch Me Build

4-Tier Equity Multiple Waterfall – Download and Watch Me Build (UPDATED APR 2022)

Here is a simple, yet very powerful, 4-tier equity multiple waterfall module. This post contains both a completed version of the module ready to plug into a real estate financial model as well as a 'Watch Me Build' template and companion video…

RE Education, Real Estate Financial Modeling, Excel Tips, Excel Models, Tutorial, Equity Waterfall, Modules, Watch Me Build

Watch Me Build – IRR Partitioning in Excel

In this post, I'd like to show you how to partition the internal rate of return of your real estate investment in Excel. I also throw in a quick equity multiple partition, to highlight how the time value of money affects your returns. I've recorded…

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

Watch Me Build – Capital Stack with Mezzanine Debt

One of the more difficult aspects of modeling a real estate development is figuring out how to handle equity and debt cash flows. This becomes all the more difficult when a second tranche of debt is introduced. In this Watch Me Build video,…

Real Estate Financial Modeling, Excel Tips, Excel Models, Office, Retail, Industrial, Tutorial, Modules, Acquisition, Watch Me Build

Watch Me Build a Tenant Rollover Analysis Model

The feedback has been positive on the ‘Watch Me Build a Multifamily Model’ video I recorded earlier this year. So I thought I’d follow that up with another. This time I build a Real Estate Tenant Rollover Analysis Model and talk through…

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

Watch Me Build a Multifamily Real Estate Model (Updated Feb 2020)

One way to become a better real estate financial modeling professional, is to watch other professionals model. I know in my career being able to physically see how others tackle different modeling problems has shaped my methods and made me better…