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 April 2026)

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

Watch Me Build A Construction Draw Schedule (Updated Feb 2026)

In the following video, I record my screen and narrative my steps as I build a basic construction draw schedule. I've also included the template and completed worksheets from this Watch Me Build exercise. Are you an Accelerator member? See…
, , , ,

Vision Reveals Hidden Value in CRE. Math Captures It.

In real estate, value is rarely static. It evolves with income, with execution, with time. Yet most pricing decisions in the market ignore the hidden value in CRE, focusing instead on what's already visible: trailing NOI, current occupancy,…
, , ,

Create Your First Excel Macro with AI

Most people in commercial real estate still think Excel macros are for “the IT guy down the hall.” You underwrite, you manage rent rolls, you crank out lender packages in Excel all day… but the moment someone says “VBA,” you are…
, , , , , , , , , , , ,

All-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated Jan 2026)

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

Case Study #16: Sunset Vista – The Hold/Sell Decision

THE BACKGROUND You are Alexa Rivera, a real estate financial advisor who supports small investors, including teachers, business owners, and retirees, who own real estate as part of a long-term wealth-building strategy. Your clients typically…
, , , ,

Self Storage Acquisition Model (Updated Jan 2026)

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

Supercharge Excel with the ‘Excel 4 CRE’ Add-In – Now with AI (Updated Jan 2026)

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 various AI coding tools) have been developing and sharing this Excel…
,

Excel Speed Tip – Insert or Delete a Row or Column Without a Mouse (Updated Dec 2025)

Using keyboard shortcuts is essential to improving the speed and efficiency at which you model real estate in Excel. One thing you'll learn early in your CRE career, the more proficient you become in using your keyboard without a mouse to navigate…
, ,

Transforming a Financial Model into a Web App with AI (Updated Dec 2025)

I have often considered that time is one of the most valuable resources for any professional in commercial real estate. That’s why I’ve transformed our Excel-based house flipping model into a financial model web app, making analysis faster,…
, , ,

Case Study #15 – Andes Digital Gateway: Hyperscale Data Center Development (Case Only)

For our 15th case study, we explore institutional development and investment analysis in the rapidly expanding digital infrastructure sector. These case studies are designed to help you practice and perfect your real estate financial modeling…
, , , ,

Condominium Development Model (Updated Dec 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…
, , ,

Guide to Using ChatGPT for Commercial Real Estate Professionals (Updated Nov 2025)

When I first published this guide in early 2023, ChatGPT felt like a novelty. It was impressive, experimental, and even a little unnerving. But for most in CRE, it was still just a toy. Fast forward two and a half years, and that’s no longer…
, ,

Best Practices in Real Estate Financial Modeling (Updated Nov 2025)

Before you use one of our real estate financial models (i.e. Excel templates), or before you set out to build your own real estate analysis tool in Excel, it's important to keep in mind a few real estate financial modeling best practices. This…
, , , ,

Office Real Estate Development Model (Updated Nov 2025)

I'm excited to share my Office Development Model in Excel. This pro forma analysis tool comes as I've continued to build and share specialty real estate models, tailor-made for specific investment scenarios and property types. This model…
, , , ,

How to Prepare for the Real Estate Technical Interview (Updated Nov 2025)

So you've made it past the HR screening interview. You have the education and experience the company is looking for, but now they want to be sure you possess the real estate financial modeling skills necessary to do the job. They've asked…