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 […]
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 […]
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 […]
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. […]
Pre-2008, I bought and sold my fair share of single family homes – both for investment purposes (rental or flips) and to live in. In those days, almost everyone was “investing” in residential real estate – hence the market crash. I personally don’t have any plans to get back into buying and selling homes, beyond […]
Volver a la escuela es un compromiso enorme. Primero está el proceso de admisión, que implica pasar horas y horas estudiando para el GMAT o el GRE, rellenar largas solicitudes de admisión, escribir docenas de ensayos sin sentido, preparar y hacer entrevistas de admisión informales y formales, y soportar el estrés de no saber si […]
The fourth blog post in this series on how to use ChatGPT in commercial real estate. As real estate financial modeling professionals, we’re often tasked with creating complex logic in Excel. Depending on one’s Excel proficiency, that task used to take anywhere from a few minutes to a few days. In fact, I remember certain […]
This is another post in our growing series on how to use ChatGPT in commercial real estate. In this post, I show you how I used ChatGPT to build an Excel Add-in. For a bit of back story. A.CRE recently set out to create a free Excel add-in to supercharge Excel for real estate financial […]
From time to time, I come across modeling situations that Excel does not have built-in functionality to address. One particular situation I come across regularly, involves needing to transfer the contents of a worksheet, including all inputs, formatting, and formulas from one copy of a model to another copy of the exact same model without linking the […]
The third blog post in this series on how to use ChatGPT in commercial real estate. The first step in real estate underwriting is the collection and aggregation of data or information. That data or information is then process, analyzed, and used to help make an investment decision. OpenAI’s GPT language model can be used […]
Another blog post in a series on how to use ChatGPT in commercial real estate. As a real estate professional, we’re often tasked with drafting and modifying non-binding business documents such as letters of intent (LOI) and memorandums of understand (MOU). These documents spell out business terms, that attorneys then formalize in binding JV agreements, […]
We need your help to improve our event programming! Last year the A.CRE team organized a combined 43 events, including virtual webinars, in-person meetings, conference keynotes, student speaker events, an A.CRE retreat to Mexico, and various happy hours. During our in-person trips to New York, San Francisco, and Los Angeles, the unanimous feedback we received […]
Glosario de Términos de Los Bienes Inmuebles Comerciales Welcome to the A.CRE Glossary of Commercial Real Estate Terms. This is a continuously growing list of commercial real estate terms and definitions. If you don’t see a term here that you are looking for, please feel free to contact us with the terms or definitions you […]
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 this tutorial I show one very real, very helpful application for the engine that […]
I built, and would like to share, a real estate portfolio model for valuing a portfolio of up to 30 properties. This is a “roll-up” model, meaning you will need to model your unlevered (before financing) property-level cash flows in a separate model (e.g. such as ARGUS, your own Excel model, or one of our Excel […]