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

Short-Term Rental Acquisition Model

In today’s real estate landscape, short-term rentals (STRs) stand out as one of the most dynamic and potentially high-yield asset classes. From compact urban units serving business travelers to luxury vacation homes attracting high-net-worth…
, , , ,

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

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

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

Case Study #5 – The Jefferson Branded Condo Development – Case Only (Updated June 2024)

This is the fifth in a series of commercial real estate case studies shared by A.CRE. These case studies are meant to help you practice to master real estate financial modeling. The Jefferson Branded Condo Development puts you in the position…
, , , , ,

Case Study #4 – The Stones Hotel Acquisition – Case Only (Updated May 2024)

This case study on hotel acquisition is the fourth in a series shared by A.CRE, designed to enhance your skills in real estate financial modeling. In this scenario, you take on the role of an associate at a prominent firm specializing in debt…
, , , , , , , , ,

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

Real Estate Sources and Uses of Capital Module (Updated Feb 2024)

An important component in any acquisition, development, and value-add model is the Sources and Uses of Capital section. Of course, how the sources and uses are modeled and how those cash flows are visualized will vary from one model to the next.…
, , , , ,

Using an IRR Matrix to Determine Hold Period (Updated Dec 2023)

When building a real estate financial pro forma, it's important to model for and include a summary of various return and risk metrics. Among the different return metrics, the internal rate of return (IRR) - both on an unlevered and levered…
, , , ,

RV Park Acquisition Model (Updated May 2023)

Excited to share my RV Park Acquisition Model with you all. This is a model I developed out over the past few months as I've been getting more involved in the space (the development of an RV Park near Olympic National Park is my most investment…
, , , ,

Single Family Residential Investment Analysis Model (Updated Apr 2023)

Pre-2008, I bought and sold my fair share of single family homes - both for investment purposes (rental or flips) and to live in. In those days, almost everyone was "investing" in residential real estate - hence the market crash. I personally…
, , , , ,

Single Family Rental Proforma (Updated Apr 2023)

With all the continued and growing interest in single family rentals these past few years, I decided to spend some time these past few days diving into building a single family rental proforma. Prior to getting underway, and what we encourage…
, , , , ,

Student Housing Acquisition Model (Updated Apr 2023)

I've spent a fair amount of my career analyzing privately-owned student housing investments. Nevertheless, I've yet to share a purpose-built, institutional-quality student housing acquisition model. So, I thought I'd take some time and build…