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 […]
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 topic of analyzing commercial real estate leases from the perspective of the landlord and/or tenant has come up several times over the years. And while I generally respond to requests for new models or tools at A.CRE, I’ve been hesitant to build this particular tool. The reason is that my experience is heavily landlord […]
Here’s the scenario. You’re a real estate developer. You spot a prime parcel of land that would be perfect for your real estate project. So you approach the owner of the land about selling and she says, “Okay, bring me an offer.” How much do you pay? What is the land even worth to you? […]
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. […]
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 […]
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 […]
Going back to graduate school is a huge commitment. First there’s the admissions process, which means spending hours and hours studying for the GMAT or GRE, filling out lengthy admissions applications, writing dozens of mindless essays, preparing for and doing informal and formal admissions interviews, and enduring the stress of not knowing if you’re in, or […]
I’ve spent a fair amount of my career analyzing privately-owned student housing investments. Nevertheless, I’ve yet to share a purpose-built, institutional-quality student housing acquisition model. So, I thought I’d take some time and build a model for this very purpose. To do this, I took my Value-Add Apartment Acquisition model, which has been used by […]
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 […]