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

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 Debt Module in Excel (Updated May 2024)

I thought I'd share the real estate debt module I originally built for the ARGUS alternative in Excel. Most debt modules I've seen in real estate financial models only include the ability to model fully amortizing senior debt. Mike challenged…
iming of Preferred Return vs Return of Capital
, , , ,

Timing of Preferred Return vs Return of Capital in an Equity Waterfall with IRR Hurdles (Updated May 2024)

Recently, we had an A.CRE reader ask us about the mechanics of Preferred Return distributions in our equity waterfall models with IRR hurdles. Specifically, he questioned the timing of when and how Preferred Return vs Return of Capital were…
, , , , , , , , , , ,

Watch Me Build – Modeling a Rent Schedule in Both Excel and Using AI (Updated May 2024)

In this Watch Me Build video I show you how to build a custom rent schedule module for long-term leases. The foundation of the module is a simple INDEX/MATCH combination that takes a rent schedule and models the rent cash flows across the entire…
, , , ,

Real Estate Capital Account Tracking Tool (Updated Apr 2024)

I'll be the first to admit that real estate asset management doesn't get the attention it deserves on AdventuresinCRE.com. The real reason for this is that we're not necessarily asset management experts. I spent some time working in asset management…
, , ,

Hide and Unhide Tabs using Drop-down Menus in Excel (Updated Apr 2024)

I'd like to share a handy little trick I learned this week for hiding and unhiding tabs in Excel using drop-down menus. Now this method requires you to use some basic VBA code and to save the Workbook as a Macro-Enabled file but don't be intimidated…
, , , ,

Watch Me Build – American-Style Real Estate Equity Waterfall (Updated Apr 2024)

A few years ago, I recorded my screen as I built a 3-tier real estate equity waterfall model. What I didn't mention in that Watch Me Build video, is that the kind of waterfall I built is colloquially called a European-style equity waterfall.…
, , , , , ,

Advanced Mortgage Amortization Schedule – Custom GPT by A.CRE

At A.CRE, we've built dozens of custom GPTs for internal and external purposes. Some of the GPTs have general application, while others are custom GPTs specifically for commercial real estate. One such CRE-specific GPT that we recently built…
, , , , , ,

Multifamily Development Model (Updated April 2024)

Not to be confused with Spencer's masterpiece, The A.CRE Apartment Development Model, I decided to build a second option on our website for multifamily development with a different feel. For us true modeling nerds out there, we know that financial…
, , , ,

Retail Real Estate Development Model (Updated Apr 2024)

I'm excited to share my Retail 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…
, , , ,

Office Real Estate Development Model (Updated Apr 2024)

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

Commercial Mortgage Loan Analysis Model (Updated Mar 2024)

Over the years, I've received various requests to augment our library of real estate Excel models to include a model for underwriting and analyzing commercial mortgage loans. Specifically, people have asked for a tool to calculate the loan amount…
Sources and Uses
, , , ,

Construction Draw and Interest Calculation Model (Updated Feb 2024)

I originally uploaded this equity/construction loan draw and interest calculation tool to our library of real estate financial analysis models in 2016. Over the years, I've continued to update it as suggestions, comments, and requests…
, , , , ,

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

A.CRE Self Storage Development Model (Updated Feb 2024)

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…