Real Estate Financial Modeling

All | Argus| Excel Models | Excel Tips | Stochastic Modeling
Click to Browse the Library of Excel Models

real estate financial modeling courses

, , ,

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

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

All-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated Jan 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…
, ,

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

Condominium Development Model (Updated Nov 2024)

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

A.CRE Build-to-Rent (BTR) Development Model (Updated Nov 2024)

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

Mixed-Use Development Model: Condo and Retail (Updated Nov 2024)

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

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…
Triple Net Lease Case Study Investment
,

Case Study #13 – “BioMedica” Chain Drugstore – Build-to-Suit Investment in Colombia (Case Only)

In this triple net lease case study, we explore a real-world scenario involving the development of a build-to-suit commercial property for a leading drugstore chain in Colombia. By examining this scenario, you will gain hands-on experience analyzing…
, , , , , , , ,

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

Deep Dive – Land Acquisition and Assemblage (Updated September 2024)

This is a topic I'm all too familiar with. You see, I cut my teeth in real estate largely sourcing and negotiating residential and mixed-use land acquisition opportunities.  I've put land deals together both as a fiduciary and as a principal,…
, , , , , , ,

Watch Me Build a Residential Land Development Model (Updated Sept 2024)

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 Equity Waterfall Model – IRR and Equity Multiple Hurdles (Updated Sept 2024)

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…