Using keyboard shortcuts is essential to improving the speed and efficiency at which you model real estate in Excel. One thing you’ll learn early in your CRE career, the more proficient you become in using your keyboard without a mouse to navigate around Excel, the more valuable you’ll be as a real estate financial analyst. […]
I originally built this single tenant net lease (NNN) valuation Excel model back in 2016. Based on some feedback from a few of our readers, I’ve since made a few updates. This model is an attempt to re-think how the industry underwrites single-tenant net lease investments. The model is different from your typical discounted cash […]
Before moving to the principal side of the business, I began my career as a self-described real estate investment specialist, largely working as a land broker but dabbling in other areas including the popular “single-family flip” space. In all honesty, I wasn’t qualified for the title. In fact, I had little to no actual experience […]
Over the years, Michael and I have built and shared numerous real estate equity waterfall models, all multi-tiered and most with internal rate of return (IRR) hurdles. And as our readers have downloaded those models, I’ve received dozens of requests for an equity waterfall model with a simpler partnership structure. This model seeks to be an […]
Over the years, my real estate equity waterfall with annual periods and the option of using either IRR or Equity Multiple Hurdles has been one of the most popular models download at Adventures in CRE. I’ve received dozens of requests for how to improve the model, and so I thought I’d incorporate some of those […]
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 […]
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 […]
I received a very astute question/concern from a user of our All-in-One(Ai1) model in our Ai1 Support Forum late last month. I initially set out to answer the question in writing, but the more I thought about my response, the more I concluded a video was necessary to fully explain the methodology here. Below find a […]
As many of you recall, in 2015 I set out to build an Excel alternative to the widely-used (and now discontinued) ARGUS DCF. With career moves and a lot of other A.CRE-related side projects, this undertaking has been slow going. Alas, in 2016 I released the first beta-version of the model – my All-in-One (Ai1) Underwriting […]