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 […]
As someone who has worked in the commercial real estate industry going on 22 years, I’ve come to appreciate how important it is to stay on top of the latest trends and technologies. As I’ve shared my own personal experience using ChatGPT in commercial real estate, I’ve received several emails asking how to get started […]
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, […]
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 […]
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 […]
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 […]