Real Estate Financial Modeling

All | Argus | All-in-One | Excel Models | Excel Tips | Stochastic Modeling

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated September 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…
, , ,

Data Center Development Model (Updated Sept 2025)

As the built environment evolves to meet the demands of an increasingly digital world, data centers have emerged as one of the most sophisticated and capital-intensive asset classes in commercial real estate. What was once considered a niche…
, , , , ,

Supercharge Excel with the ‘Excel 4 CRE’ Add-In – Now with AI (Updated Sept 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 Accelerator and AI.Edge: What’s the Difference

At A.CRE, we offer two flagship programs for CRE professionals: The A.CRE Accelerator and the AI.Edge. Both give you a real advantage in real estate, but they solve different problems. Use this FAQ to choose the right fit or pair them for…
, , , ,

A.CRE Self Storage Development Model (Updated Aug 2025)

We've received numerous requests over the years for a Self Storage Development Model in Excel. With strong investment and development activity in this niche property type, I recognize a self storage model on A.CRE is long overdue. But with so…
, , , , ,

Land Development Model – Multi-Scenario (Updated Aug 2025)

Over the years, we've shared eight development-focused real estate financial models and numerous development-specific tools to the A.CRE Library of Excel Models. Nevertheless, there's been a hole in the development offerings in our library.…
, , ,

Understanding Stabilization Through The Lens Of Operating Expense Ratio

The term “stabilized” is deeply embedded in the language of real estate. It shows up frequently in financial models, offering memoranda, development strategies, and underwriting assumptions. So frequently, in fact, that its meaning is often…
, , , ,

A.CRE Build-to-Rent (BTR) Development Model (Updated Aug 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…
,

Excel’s Stale Value Formatting: What It Means and Why It Matters (Updated Aug 2025)

We recently received an email from an A.CRE reader using one of our real estate financial models with a curious question. He explained that many of the cells in his model suddenly had a strikethrough applied to the text. Naturally, he wondered…
,

The Conditional Weighted Average – SUMPRODUCT with SUMIF (Updated July 2025)

Consider this scenario: you have a 50 tenant rent roll, consisting of various tenant types (i.e. small inline, large inline, junior anchor, anchor, etc.), and you want to calculate the weighted average rent for each tenant type. If I asked you,…
, , , ,

Multifamily (Apartment) Acquisition Model (Updated July 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…
, , , , , ,

30/360, Actual/365, and Actual/360 – How Lenders Calculate Interest on CRE Loans – Some Important Insights (Updated July 2025)

(Updated August 7, 2019 to include a Watch Me Build video and Downloadable file) Commercial real estate lenders commonly calculate loans in three ways: 30/360, Actual/365 (aka 365/365), and Actual/360 (aka 365/360). Real estate professionals…
, , ,

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

Ground Lease Valuation Model (Updated July 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…
, , , , ,

Residential Land Development Pro Forma (Updated July 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…
, , , , , ,

Mixed-Use Development Model: Condo and Retail (Updated July 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…