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 […]
As promised, I’m following up the release of the A.CRE Value-Add Apartment Acquisition 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 […]
A question came up recently in the A.CRE Accelerator’s real estate waterfall modeling course regarding how to model GP Catch Up (i.e. Sponsor Catch Up) and LP Clawback provisions. I put together a quick video tutorial in response to that question, and in doing so I realized I had never shared to A.CRE a real […]
The more you model real estate in Microsoft Excel, the faster and more accurate you become – and hopefully as a consequence the more valuable you become to real estate employers and investors. Part of the process of mastering real estate financial modeling in Excel, is learning to put the mouse aside and rely on […]
Arguably the most powerful, and least appreciated and understood, functionality in Excel is its use of boolean logic. Or in other words, the use of TRUE and FALSE binary logic. This form of logic can be used to dramatically simplify formulas in real estate financial modeling, ease auditing work, and speed up the modeling process. […]