
Real Estate Financial Modeling Accelerator (Updated Jan 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…
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…
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…
Supercharge Excel with the ‘Excel 4 CRE’ Add-In – Now with AI (Updated Mar 2025)
Today, we're thrilled to share with the A.CRE community a new timesaving (and free) Excel tool: the 'Excel 4 CRE' Add-in! Over the past few years, we at A.CRE (together with our new favorite companion, ChatGPT!) have been developing and sharing…
A.CRE Build-to-Rent (BTR) Development Model (Updated Feb 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…
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…
Real Estate Asset Management Model
Many of you have run into this scenario: you build out a detailed acquisitions model at purchase. Everything looks great—market rents, lease-up timing, exit cap, all in line. The acquisitions team is convinced this is going to be a home run.…
Excel Pro Forma for Flipping Houses (Updated Jan 2025)
Before moving to the principal side of the business, I began my career as a self-described real estate investment specialist, largely working as a land broker but dabbling in other areas including the popular "single-family flip" space. In all…
A.CRE Real Estate Financial Models Download Guide (Updated December 2024)
Since I started working with A.CRE, I wanted to find a way to easily find the different models, modules, tools, and tutorials the guys have shared from the Library of Excel Real Estate Financial Models. After some time helping out our readers…
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,…
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,…
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…