Entries by Spencer Burton

, , , , ,

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

, , , ,

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

, , , , , ,

Using ChatGPT as a Real Estate Analyst to Create a Lease Abstract

As you may know, we here at A.CRE have been exploring various use cases for AI in commercial real estate. When ChatGPT plugins were released in May 2023, the tool gained an ability to act like a young real estate analyst; namely to source and organize information. The first such use case showed how connecting […]

, , , ,

Using ChatGPT to Create Excel Logic #2 – Annual to Monthly Growth

Another post in a growing series on how to use ChatGPT in commercial real estate. In our real estate financial modeling Accelerator program we have a Q&A. Members of the Accelerator ask the A.CRE team questions, and we provide answers. Depending on the complexity/nature of the question, either Arturo, Emilio, Kyle, Michael, or I respond. […]