Real Estate Models for Industrial Properties - Adventures in CRE

Data Center Development Model (Updated Aug 2025)

Arturo Parada — Tue, 12 Aug 2025 14:00:07 +0000

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 subset of infrastructure has become a foundational layer of the global economy, driven by AI, cloud computing, […]

The post Data Center Development Model (Updated Aug 2025) appeared first on Adventures in CRE.

Industrial Real Estate Development Model (Updated July 2025)

Spencer Burton — Fri, 18 Jul 2025 13:00:53 +0000

Allow me to share my Industrial Development Model in Excel. Over the past few years, 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 underwriting of a deal takes a hyper-focused tool. This model has spawned sister Office […]

The post Industrial Real Estate Development Model (Updated July 2025) appeared first on Adventures in CRE.

All-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated July 2025)

Spencer Burton — Thu, 03 Jul 2025 12:00:30 +0000

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 I released the first beta-version of the model – my All-in-One (Ai1) […]

The post All-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated July 2025) appeared first on Adventures in CRE.

Single Tenant NNN Lease Valuation Model (Updated May 2025)

Spencer Burton — Tue, 20 May 2025 00:59:12 +0000

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 how the industry underwrites single-tenant net lease investments. The model is […]

The post Single Tenant NNN Lease Valuation Model (Updated May 2025) appeared first on Adventures in CRE.

Simple Acquisition Model for Office, Retail, Industrial Properties (Updated Dec 2024)

Spencer Burton — Mon, 30 Dec 2024 14:17:51 +0000

A few years back, on a sleepy Saturday afternoon while my kids were busy eating Halloween candy, I decided to create a simple real estate acquisition model in Excel for office, retail, and industrial deals. Since then, I’ve made various updates, including error fixes and functional improvements. The model calculates returns at the property and […]

The post Simple Acquisition Model for Office, Retail, Industrial Properties (Updated Dec 2024) appeared first on Adventures in CRE.

Case Study #10 – Class A Industrial Warehouse + Rooftop Solar PV Plant (Case + Solution)

Padmaa Iyer — Tue, 09 Jul 2024 14:00:31 +0000

This case study explores a development of a 40-acre warehouse in Kasara, near Nashik, India. This industrial case study combines rental income with solar energy initiatives. In this article, we’ll examine the financial strategies, including partnerships and funding, and the project’s five-year lifecycle with a video tutorial and link to download the case study at […]

The post Case Study #10 – Class A Industrial Warehouse + Rooftop Solar PV Plant (Case + Solution) appeared first on Adventures in CRE.

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

Spencer Burton — Sun, 05 May 2024 14:00:11 +0000

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 hold period. I also include an optional file that you can […]

The post Watch Me Build – Modeling a Rent Schedule in Both Excel and Using AI (Updated May 2024) appeared first on Adventures in CRE.

Actual + Forecast Construction Draw Schedule with S-Curve (Updated Dec 2023)

Spencer Burton — Wed, 20 Dec 2023 01:12:50 +0000

Several times in the last month, I’ve been asked to tackle an interesting real estate financial modeling challenge – pare actual construction draw cash flows with s-curve cash flow forecasts to create an Actuals + Forecast Construction Draw schedule. The real challenge in this exercise, is to have the actual construction draws transition into the […]

The post Actual + Forecast Construction Draw Schedule with S-Curve (Updated Dec 2023) appeared first on Adventures in CRE.

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

Michael Belasco — Thu, 17 Nov 2022 15:00:18 +0000

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 piece of information to share with our readers. What […]

The post Create A Dynamic Revenue Row to Calculate Multiple Tenant Leases (Updated Nov 2022) appeared first on Adventures in CRE.

Publicly Traded Tenant Analysis Tool (Updated May 2022)

Michael Belasco — Sat, 28 May 2022 06:31:37 +0000

In this post and corresponding video, I am going to walk you through a revamped tenant health worksheet that I shared a long time ago on the site. I spent some time giving it a makeover and decided to put together a video walkthrough for it. Publicly Traded Tenant Analysis Valuable Insights At Your Fingertips […]

The post Publicly Traded Tenant Analysis Tool (Updated May 2022) appeared first on Adventures in CRE.

Physical Occupancy Calculation Model for Real Estate (UPDATED MAY 2022)

Spencer Burton — Fri, 06 May 2022 13:00:43 +0000

As many of you know, I’m in the midst of moving my family from Milwaukee to Dallas, and quite frankly I’m getting sick of eating out and sleeping in hotel rooms. So what better way to unwind from hours of whining kids and tiresome travel, than to build a quick real estate Excel model for calculating the monthly physical […]

The post Physical Occupancy Calculation Model for Real Estate (UPDATED MAY 2022) appeared first on Adventures in CRE.

Development Draw Schedule – Visually Customize Each Line Item (UPDATED APR 2022)

Michael Belasco — Tue, 26 Apr 2022 13:00:52 +0000

Working a lot with development draw schedules, I have always been looking for a catch all solution as to how one could easily model all the unique ways cash actually flows over time during the process. The norm for many is to model cash flows using a straight line method with even payments over time, […]

The post Development Draw Schedule – Visually Customize Each Line Item (UPDATED APR 2022) appeared first on Adventures in CRE.

Using Boolean Logic to Model Multiple Generations of Tenant Improvements

Spencer Burton — Sat, 27 Feb 2021 02:10:19 +0000

Arguably the most powerful, and least appreciated and understood, functionality in Excel is its use of boolean logic. Or in other words, the use of TRUE and FALSE binary logic. This form of logic can be used to dramatically simplify formulas in real estate financial modeling, ease auditing work, and speed up the modeling process. […]

The post Using Boolean Logic to Model Multiple Generations of Tenant Improvements appeared first on Adventures in CRE.

Real Estate Acquisitions Model #2 for Office, Retail, Industrial (Updated Aug 2020)

Michael Belasco — Wed, 26 Aug 2020 12:43:07 +0000

I’ve decided to do a major overhaul of my last acquisitions model for office, industrial, and retail properties. There were a lot of things I wanted to change as well as add to the model and finally had a weekend to do it. This new and improved model includes both monthly and annual cash flows, […]

The post Real Estate Acquisitions Model #2 for Office, Retail, Industrial (Updated Aug 2020) appeared first on Adventures in CRE.

Watch Me Build a Tenant Rollover Analysis Model

Spencer Burton — Fri, 27 Mar 2020 11:33:06 +0000

The feedback has been positive on the ‘Watch Me Build a Multifamily Model’ video I recorded earlier this year. So I thought I’d follow that up with another. This time I build a Real Estate Tenant Rollover Analysis Model and talk through the methodology, keyboard shortcuts, and formulas I use as I build the model. […]

The post Watch Me Build a Tenant Rollover Analysis Model appeared first on Adventures in CRE.