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

Self Storage Acquisition Model (Updated May 2025)

I've spent the past few weekends working on a purpose-built Self Storage Acquisition Model, and I'm now happy to share the result of that work with you. This is a model that's been requested by quite a few A.CRE readers over the past few years.…
, , , , ,

Residential Land Development Pro Forma (Updated Apr 2025)

As many of you know, I started my career in residential land development first as a broker and later as a principal. During that time, I built my fair share of residential land development Excel pro formas, modeling returns and forecasting cash…
, , , ,

Multifamily (Apartment) Acquisition Model (Updated Apr 2025)

Our library of real estate Excel models has a variety of decent apartment models, including our All-in-One model and our Apartment Development Model - both robust models in their own right. However, if you're looking for a straight multifamily…
, , , ,

A.CRE Build-to-Rent (BTR) Development Model (Updated Mar 2025)

Build-to-rent (BTR) has become more and more common in CRE and now accounts for a meaningful share of development. In the past, we've recommended A.CRE readers use our Apartment Development Model for BTR analysis. However, as we've received…
, , , , ,

A.CRE Value-Add Apartment Acquisition Model (Updated Mar 2025)

We've shared a handful of apartment models over the years. Several of those are capable of analyzing apartment acquisitions but none was built for the express purpose of modeling value-add apartment deals. As a result, each has its limitations…
, , , , ,

Ground Lease Valuation Model (Updated Mar 2025)

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

Single Family Home Construction Pro Forma for Home Builders (Updated Feb 2025)

I'm often asked to share models centered around residential development and home building. This is an area of real estate I'm completely comfortable in, since I spent the first 10 years of my career in new residential development. Not surprisingly,…
, , , , , , , , , , , ,

All-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated Feb 2025)

As many of you recall, in 2015 I set out to build an Excel alternative to the widely-used (and now discontinued) ARGUS DCF. With career moves and a lot of other A.CRE-related side projects, this undertaking has been slow going. Alas, in 2016…
, , , , , ,

Mixed-Use Development Model: Condo and Retail (Updated February 2025)

In this post, I walk you through the A.CRE Mixed Use Development Model for Condo and Retail projects. The model is basically a reworked and expanded version of the Condo Development Model, so if you are familiar with that, this should feel and…
, , , ,

Condominium Development Model (Updated Jan 2025)

After posting the construction draw module that demonstrates how to calculate the true LTC of a development loan, I decided that since we have yet to publish a condo development model, to build upon that module to create one. This condominium…
, , , , , ,

Simple Acquisition Model for Office, Retail, Industrial Properties (Updated Dec 2024)

A few years back, on a sleepy Saturday afternoon while my kids were busy eating Halloween candy, I decided to create a simple real estate acquisition model in Excel for office, retail, and industrial deals. Since then, I've made various updates,…
, , , ,

A.CRE Apartment Development Model (Updated Dec 2024)

For several years now, our library of real estate models has been lacking a robust ground-up apartment development model. Sure, our All-in-One (Ai1) model has the capability to model multifamily development deals, but it's more a generalist…
, , , ,

Industrial Real Estate Development Model (Updated Nov 2024)

Allow me to share my Industrial Development Model in Excel. Over the past few years, I've been working to add more specialty real estate models to our library. While our All-in-One model certainly has its place, oftentimes really digging into…
, , , ,

Loan Payment Schedule and Balance Tracking Tool (Updated Aug 2024)

A childhood friend called me this week and asked for a favor. He is the lender on a private real estate loan and was wanting a way to personally service the loan. Namely, he needed a tool to issue monthly invoices, track the principal vs interest…
, , , , , , , , ,

Single Tenant NNN Lease Valuation Model (Updated May 2024)

I originally built this single tenant net lease (NNN) valuation Excel model back in 2016. Based on some feedback from a few of our readers, I've since made quite a few updates (see v2.0 updates video below). This model is an attempt to re-think…