Excel Add-ins for Real Estate Modeling - Adventures in CRE

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

Spencer Burton — Fri, 25 Jul 2025 17:01:36 +0000

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 our new favorite companion, ChatGPT!) have been developing and sharing this Excel add-in. The goal? To make real estate financial modeling faster and more […]

The post Supercharge Excel with the ‘Excel 4 CRE’ Add-In – Now with AI (Updated July 2025) appeared first on Adventures in CRE.

How to Run Monte Carlo Simulations in Excel (Updated Aug 2024)

Spencer Burton — Sun, 18 Aug 2024 18:30:54 +0000

So you want to run Monte Carlo simulations in Excel, but your project isn’t large enough or you don’t do this type of probabilistic analysis enough to warrant buying an expensive add-in. Well, you’ve come to the right place. Excel’s built-in functionality allows for stochastic modeling, including running as many simulations as your computer’s processing power […]

The post How to Run Monte Carlo Simulations in Excel (Updated Aug 2024) appeared first on Adventures in CRE.

A.CRE Geocoding Excel Add-in to Auto-Populate Latitude and Longitude in Excel (Updated Jun 2024)

Spencer Burton — Tue, 18 Jun 2024 00:00:20 +0000

The A.CRE Geocoding Excel Add-in uses the Google Geocoding API to automatically convert a given address to latitude and longitude coordinates, or to convert a given latitude and longitude coordinate to an address. The add-in makes auto-populating latitude and longitude (or address) in Excel easy. It includes various features to help add or change the […]

The post A.CRE Geocoding Excel Add-in to Auto-Populate Latitude and Longitude in Excel (Updated Jun 2024) appeared first on Adventures in CRE.

The Circuit Breaker – How to Fix Circular Reference Errors in Excel

Spencer Burton — Mon, 19 Jun 2023 12:41:56 +0000

If you’ve spent much time working with elaborate Excel workbooks that rely on iterative calculations to solve formulas with circular logic, you’ve undoubtedly come across a problem where if you accidently put an erroneous value in an input cell that the circular logic relies on, the entire workbook errors out permanently. This can be incredibly frustrating […]

The post The Circuit Breaker – How to Fix Circular Reference Errors in Excel appeared first on Adventures in CRE.

4-Tier Equity Multiple Waterfall – Download and Watch Me Build (UPDATED APR 2022)

Michael Belasco — Thu, 28 Apr 2022 13:00:53 +0000

Here is a simple, yet very powerful, 4-tier equity multiple waterfall module. This post contains both a completed version of the module ready to plug into a real estate financial model as well as a ‘Watch Me Build’ template and companion video where I walk the user step by step through building it out. Are […]

The post 4-Tier Equity Multiple Waterfall – Download and Watch Me Build (UPDATED APR 2022) appeared first on Adventures in CRE.

Setting Up a New Real Estate Financial Model – Date and Period Headers Plus Formatting (Updated Apr 2022)

Spencer Burton — Sat, 23 Apr 2022 13:00:54 +0000

We’ve spent a lot of time here discussing and sharing different real estate models, and we’ve received a ton of feedback from our readers as a result. In some of that feedback we’ve received, several people have asked what period and date rows I prefer to use and how I setup a brand new model. […]

The post Setting Up a New Real Estate Financial Model – Date and Period Headers Plus Formatting (Updated Apr 2022) appeared first on Adventures in CRE.

Custom Function to Auto-Populate Latitude and Longitude in Excel (Updated 2021)

Spencer Burton — Sat, 03 Jul 2021 19:57:02 +0000

When analyzing real estate investments in Excel, it’s often necessary to include the latitude and longitude coordinates of the properties we’re modeling. To do this, most of us open up Google Maps, or some other mapping tool, and find the coordinates that way. Others use a latitude/longitude lookup tool such as latlong.net to find what they need. However, these tools […]

The post Custom Function to Auto-Populate Latitude and Longitude in Excel (Updated 2021) appeared first on Adventures in CRE.

Using the Floating Summary Box in Real Estate Modeling

Spencer Burton — Tue, 16 Jul 2019 22:07:25 +0000

Over the next few minutes, I’ll share a great modeling tip for efficiently visualizing the more salient metrics in your real estate models. Now I should mention, this is a tip I shared a few years ago. But given the complexity of many of the models in our Library of Real Estate Excel models, I […]

The post Using the Floating Summary Box in Real Estate Modeling appeared first on Adventures in CRE.

Supercharge Excel with the WST Macros Add-in

Spencer Burton — Tue, 19 Apr 2016 00:52:46 +0000

In 2016, I wrote about Wall St. Training and their free Excel modeling resources. In that post, I mentioned the free WST Macros and how it is an indispensable add-in; one that I used in my professional life daily. Unfortunately, as of 2023, Wall St. Training no longer offers the resources mentioned in this blog […]

The post Supercharge Excel with the WST Macros Add-in appeared first on Adventures in CRE.