In course 3 of our A.CRE Accelerator, we use a case study that revolves around a hold-sell (i.e. hold vs sell) analysis scenario to teach the anatomy of the real estate DCF. In that scenario, the student is an asset manager working for an open-end core fund. The fund is trying to determine whether it […]
As many of you know, I started my career in residential land development first as a broker and later as a principal. During that time I built my fair share of residential land development Excel pro formas, modeling returns and forecasting cash flows for my clients and investor partners. I’ve since transitioned into the institutional side […]
We have a few stochastic modeling tools for real estate on the website, but none as robust as this Apartment Acquisition Model with Monte Carlo Simulation Module. I originally built the model in 2016 by taking my standard apartment acquisition model, and assigning probabilities to various assumptions. I then added a Monte Carlo Simulation module […]
I was recently asked the question whether it’s possible to add more other income or operating expense line items to the MF-OpSt or ORI-OpSt worksheets in my All-in-One Model for Underwriting Acquisitions and Development. Short answer is: out of the box this is not supported. Or in other words, there’s not a button you can […]
The Columbia University Master of Science of Real Estate Development (MS.RED) program is an intensive, three term (one year) graduate program in real estate offered through Columbia University’s highly ranked Graduate School of Architecture, Planning, and Preservation. The program leverages its location in one of the great cities of the world, New York City, to teach its […]
For several years now, our library of real estate models has been lacking a robust ground-up apartment development model. Sure, our All-in-One (Ai1) model has the capability to model multifamily development deals, but it’s more a generalist tool than a specialized one. As a result, I’ve found it wanting when used to model developments. So a few […]
The more time you spend modeling real estate in Excel, the more important keyboard shortcuts become. It’s partly about speed – using keyboard shortcuts is much faster than using the mouse. But it’s also about impressing your peers; whether you admit it or not! In fact, I remember the first time I watched a true […]
Since starting A.CRE, Michael and I have fielded email after email requesting a more structured real estate financial modeling training program on the site. Over the years, we’ve covered hundreds of real estate modeling topics in our blog; and the 50+ real estate Excel models we’ve shared publicly contain virtually everything you need to know about modeling to […]
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 […]