Entries by Spencer Burton

, ,

Introducing Weighted Equity Multiple: An Alternative for Dynamic CRE Investments

Across a 22+ year career in the industry, I’ve encountered a range of complex scenarios that traditional metrics sometimes struggle to accurately capture. A case in point that has been top of mind for me recently is a weakness in the Equity Multiple, a metric fundamental to our understanding of investment performance but often lacking […]

, , , ,

Superforecasting in Commercial Real Estate: Key Disciplines to Master

In commercial real estate investing, the ability to forecast an asset’s potential cash flows, anticipate market trends and make accurate predictions is essential – especially in an environment of flat or rising rates. This skill, sometimes referred to as ‘superforecasting,’ is something I’ve been actively working to master in my own career. One of my […]

, , , , ,

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

We’ve shared a handful of apartment models over the years. Several of those are capable of analyzing apartment acquisitions but none was built for the express purpose of modeling value-add apartment deals. As a result, each has its limitations in value-add scenarios. So today, I’m excited to share a new apartment model; this one built […]

, , ,

Refinance Risk Analysis Tool in Excel (Updated Nov 2023)

Generally speaking, equity real estate investors spend their time modeling the upside while their debt partners spend their time modeling the downside. Equity investors generally focus on an investment’s internal rate of return, cash-on-cash return, equity multiple and other return metrics while debt investors focus on debt coverage, loan to value, debt yield and refinance […]

, , , ,

Create Your First AI Tool: Sales Comp Database ChatGPT Plugin

Traditionally in commercial real estate, each organization builds its own proprietary sales comp database and then gives its analysts access to that database in order to perform comp analysis. As AI becomes more and more important, pairing the analyst team with AI tools to speed/improve that real estate analysis is essential. Thus, at the individual […]

, , , , ,

Using ChatGPT as a Real Estate Analyst – Sales Comp Analysis (Updated Aug 2023)

In early 2023, we here at A.CRE began exploring use cases for AI in commercial real estate. Since that time, we have released nine such posts covering topics such as using AI in the real estate job search, using AI to expand on Excel’s capabilities, using AI for real estate research, etc. However, this post […]

, , , ,

ChatGPT vs Bard vs LLaMa Chat (Aug 2023) – AI Chat for CRE Comparison

If you’re an A.CRE reader, you know we’re actively exploring the numerous use cases for generative AI in commercial real estate. As part of those efforts, we’ve used ChatGPT to help us build a custom Excel add-in for CRE professionals, used ChatGPT as an analyst to assess sale comps and create a lease abstract, asked […]

, , ,

Herramientas de AI para Bienes Inmuebles Comerciales

Por si no se ha dado cuenta, en A.CRE hemos estado jugando mucho con la AI últimamente. La razón es que la inteligencia artificial (AI) está a punto de revolucionar el sector inmobiliario comercial transformando la forma en que operan los equipos de adquisiciones, desarrollo, gestión, asesoramiento y marketing del sector. Las herramientas de AI […]

, , , ,

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

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 […]

, , ,

Commercial Real Estate Deal Sheet

As part of our ongoing series of YouTube Shorts, we recently published a video about the importance of keeping a personal commercial real estate deal sheet (see video below). In this context, a real estate deal sheet is a comprehensive list of investments that a real estate professional has worked on in their career. The […]