You are here: / / / Modules

Real Estate Financial Modeling

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

Acquisition | Development | Value-Add | Asset Management | Debt | Equity Waterfall | Excel Add-ins | Modules | Portfolio | Standalone | Tutorial | Apartment | Hotel | Industrial | Land Development | Office | Retail | Single-Family

real estate financial modeling courses

, , ,

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

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

Ground Lease Valuation Model (Updated May 2026)

The topic of ground leases has come up several times in the past few weeks. Numerous A.CRE readers have emailed to ask for a purpose-built Ground Lease Valuation Model. And I'm in the process of creating an Advanced Concepts Module for our real…
, , , ,

3-Tiered Acquisition Debt Module (Updated Apr 2026)

This is a 3-tiered debt module that will allow the user to add one to three tiers of debt to his or her real estate DCF model. Includes the option to layer in senior debt, secondary debt, and mezzanine debt; calculate interest on either…
, , , ,

Commercial Real Estate Lease Analysis Tool (Updated Feb 2026)

The topic of analyzing commercial real estate leases from the perspective of the landlord and/or tenant has come up several times over the years. And while I generally respond to requests for new models or tools at A.CRE, I've been hesitant…
, , , , , ,

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

Real Estate Equity Waterfall Model – IRR and Equity Multiple Hurdles (Updated July 2025)

Over the years, this real estate equity waterfall with annual periods and IRR or Equity Multiple hurdles has been one of the most popular models in our library of real estate Excel models. It's been downloaded thousands of times and we've received…
, , ,

Real Estate Equity Waterfall Model with Catch Up and Clawback (Updated Dec 2024)

A question came up recently in the A.CRE Accelerator's real estate waterfall modeling course regarding how to model GP Catch Up (i.e. Sponsor Catch Up) and LP Clawback provisions. I put together a quick video tutorial in response to that question,…
, , , , , , , ,

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…
adventures in cre real estate modeler creating cash-on-cash return equity waterfall
, , ,

Real Estate Equity Waterfall Model With Cash-on-Cash Return Hurdle (Updated Jul 2024)

Over the years, Michael and I have built and shared numerous real estate equity waterfall models, all multi-tiered and most with internal rate of return (IRR) hurdles. And as our readers have downloaded those models, I've received dozens of…
, , ,

Linear Mortgage Payment Schedule Tool (Updated July 2024)

We recently shared a new modeling test to our library of real estate case studies entitled UK Debt Advisory Firm Modeling Test. In that case study, the test asked the real estate professional to analyze the returns of three different debt options.…
after-tax cash flow analysis
, , , , , , , , , ,

Forecasting After-Tax Cash Flow in Real Estate Analysis (Updated May 2024)

When modeling real estate investments, industry practice is generally to stop at before-tax cash flow, rather than after-tax cash flow. And this makes sense in most instances. No two owners of real estate have the exact same tax situation and…
, , ,

Advanced Mortgage Amortization Module (Updated May 2024)

In recent months, I've been working on an advanced real estate investment amortization table with interest-only capability, fixed and variable interest rates, multiple interest calculation methods (i.e. 30/360, Actual/Actual, Actual/365, Actual/360),…
, , , , ,

Real Estate Debt Module in Excel (Updated May 2024)

I thought I'd share the real estate debt module I originally built for the ARGUS alternative in Excel. Most debt modules I've seen in real estate financial models only include the ability to model fully amortizing senior debt. Mike challenged…
, , , , , , , , , , ,

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 Capital Account Tracking Tool (Updated Apr 2024)

I'll be the first to admit that real estate asset management doesn't get the attention it deserves on AdventuresinCRE.com. The real reason for this is that we're not necessarily asset management experts. I spent some time working in asset management…