You are here: / Real Estate Financial Modeling

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

The Best AI Tools for Excel in 2025

At A.CRE, we offer what we believe to be the best AI training program for real estate and the best real estate financial modeling training program - period! From both sides of that training, we consistently hear the same question: “What…
, ,

Excel Shortcuts For Real Estate Financial Modeling (Updated Oct 2025)

One of the lesser talked about, yet most impactful, skills in real estate financial modeling is keyboard efficiency. If you’ve ever watched one of our tutorials or Accelerator sessions, you’ve probably seen the models flying by, with formulas…
,

Fix the 0% XIRR Issue in Excel Using XIRR + FILTER

Over the course of my career, I’ve modeled hundreds of real estate investments, from large portfolio roll-ups to complex mixed-use developments. And one issue I’ve consistently run into, especially when modeling portfolio or mixed-use cash…
, ,

Excel Pro Forma for Flipping Houses (Updated Sept 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…
, ,

Where Learning Goes Deeper: How The A.CRE Accelerator and Q&A Forum Build True Financial Modeling Mastery

Before transitioning into real estate, I spent over a decade teaching at the university level, preparing future mechanical engineers for successful careers in the field. That experience shaped how I think about learning: structured frameworks…
, , , , , , , , , ,

Watch Me Solve a REPE Technical Interview Modeling Test (Updated Sept 2025)

What better way to spend some free time over the Thanksgiving holiday, than to record myself completing a real estate private equity technical interview exercise! While I've offered help with the real estate technical interview in the past,…
, ,

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

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…