Real Estate Financial Modeling

All | Argus| Excel Models | Excel TipsStochastic Modeling
Click to Browse the Library of Excel Models

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated Jan 2023)

Prior to launching the Accelerator program, Michael and I fielded email after email requesting a more structured real estate financial modeling training program on the site. Over the years, we've covered hundreds of real estate modeling…
, , , ,

A.CRE Apartment Development Model (Updated Jan 2023)

For several years now, our library of real estate models has been lacking a robust ground-up apartment development model. Sure, our All-in-One (Ai1) model has the capability to model multifamily development deals, but it's more a generalist…
, ,

Using OpenAI’s GPT-3 to Create an Excel Macro for a Real Estate Model

At some point in the past few months, you've undoubtedly heard about ChatGPT. It seems everyone is talking about it. But how useful is the tool actually? And in particular, how useful is it to real estate financial modeling professionals? In…
, , , , ,

A.CRE Value-Add Apartment Acquisition Model (Updated Jan 2023)

We've shared a handful of apartment models over the years. Several of those are capable of analyzing apartment acquisitions (e.g. All-in-One, Apartment Valuation Model), but none was built for the express purpose of modeling value-add apartment…
Multifamily Letter of Intent
, , , , ,

Letter of Intent for Multifamily Real Estate

Today we are going to walk through a common first legal document that is presented to the Seller of a multifamily property, the Letter of Intent (LOI). This article will help you understand exactly what to include to write a better Letter of…
, , , ,

Office Real Estate Development Model (Updated Jan 2023)

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

Retail Real Estate Development Model (Updated Dec 2022)

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

A.CRE Self Storage Development Model (Updated Dec 2022)

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

Residential Land Development Pro Forma (Updated Dec 2022)

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

Letter of Intent for Commercial Industrial Purchase

Today we are going to walk through what is usually the first legal document that is presented to the seller of an industrial property, the Letter of Intent. This article will help you understand each of the entries to include, as well as the…
, , , , , , , , , , , ,

All-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated Nov 2022)

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

Create A Dynamic Revenue Row to Calculate Multiple Tenant Leases (Updated Nov 2022)

I recently received an email from one of our readers asking how to create a dynamic revenue row for a pro forma that can capture rent changes for multiple tenants. I thought that this would make a great post for the site and would be a good…
, , , , ,

Student Housing Acquisition Model

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

Hotel Development Model (Updated November 2022)

Excited to share the new A.CRE Hotel Development Model with everyone. As evidenced by the numerous requests we have gotten for this over the years, this model is long overdue so I'm quite happy to get it out there finally. At the core, the…
, , , ,

Industrial Real Estate Development Model (Updated Oct 2022)

Allow me to share my Industrial Development Model in Excel. Over the past year, I've been working to add more specialty real estate models to our library. While our All-in-One model certainly has its place, oftentimes really digging into the…
, , ,

Linear Mortgage Payment Schedule Tool (Updated Oct 2022)

We recently shared a new modeling test to our library of real estate case studies entitled UK Debt Advisory Firm Modeling Test. In that case study, the test asked the real estate professional to analyze the returns of three different debt options.…