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 […]
When downloading and opening an Excel model from A.CRE, some users may get the ominous message: “Microsoft has blocked macros from running because the source of this file is untrusted.” If you’ve received this message, you’re probably asking, “Why did this message appear, and can I use the file without macros?” In this tutorial, I’ll […]
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. […]
Over the past few years, I’ve been working to build an ARGUS DCF alternative in Excel – or otherwise known here as the A.CRE All-in-One (Ai1) Model. As I’ve worked on that model, I’ve been jotting down modeling techniques I use and think would be helpful to share with our readers. Today I’d like to show […]
As promised, I’m following up the release of the A.CRE Apartment Development model with a series of walk-throughs and tutorials to help you better understand the various elements of the model. The tutorials start with the basics – a guide to getting started, and then get progressively more advanced. If you’ve already visited the model’s […]
In 2018, Michael and I designed and built the A.CRE Accelerator program. We sought to build the preeminent tool for learning and mastering real estate financial modeling. It was intended to provide a clear path to real estate financial modeling mastery, and ultimately give Accelerator Graduates a significant advantage in the industry. Now as we […]
One of the reasons Michael and I blog, is to force ourselves to be continually learning. I built the first version of my real estate waterfall model, because I wanted to better understand the mechanics of modeling an equity waterfall with IRR hurdles. Michael started his Understanding Leases Series, because there were nuances of modeling […]
As we continue to build out our A.CRE 101 series and our Glossary of Commercial Real Estate terms, we’ve started to supplement these initiatives with short (<30 second) video clips on how to do various CRE calculations and modeling tasks in Excel. You can think of these 30 second tutorials as bite-sized lessons in real […]
When I decided to share my real estate equity waterfall model in Excel, I never imagined it would be as popular as it has. The model has been downloaded thousands times and many of you have written to extend your thanks for sharing. It is gratifying to know that the model has been put to […]
When analyzing real estate investments in Excel, it’s often necessary to include the latitude and longitude coordinates of the properties we’re modeling. To do this, most of us open up Google Maps, or some other mapping tool, and find the coordinates that way. Others use a latitude/longitude lookup tool such as latlong.net to find what they need. However, these tools […]