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 […]
When underwriting a retail investment, rollover risk is an incredibly important consideration. You, as a prospective debt or equity investor in the property, need to understand how secure the cash flows you’re buying are; or in other words, how likely each tenant is to renew their lease at the end of their lease term. This is […]
I received a question this morning asking how to use scenario (or sensitivity) analysis with our Real Estate Equity Waterfall Model. I started to answer the question via email, decided to build an Excel file to go along with my answer, and ultimately concluded that a video would be the easiest way to walk you through […]
As many of you know, I’m in the midst of moving my family from Milwaukee to Dallas, and quite frankly I’m getting sick of eating out and sleeping in hotel rooms. So what better way to unwind from hours of whining kids and tiresome travel, than to build a quick real estate Excel model for calculating the monthly physical […]
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. […]