A few years ago, I recorded my screen as I built a 3-tier real estate equity waterfall model. What I didn’t mention in that Watch Me Build video, is that the kind of waterfall I built is colloquially called a European-style equity waterfall. And while that type of waterfall is extremely common, both in the […]
Prior to launching the Accelerator program, Michael and I 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, published hours of video, and shared 60+ real estate Excel models in our Library. Nonetheless, no […]
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 quite a few updates (see v2.0 updates video below). This model is an attempt to re-think how the industry underwrites single-tenant net lease investments. The model is […]
Over the years, I’ve received various requests to augment our library of real estate Excel models to include a model for underwriting and analyzing commercial mortgage loans. Specifically, people have asked for a tool to calculate the loan amount (ie. loan sizing) based on a combination of tests – debt service coverage ratio, loan-to-value, and […]
I’m excited to share my Office Development Model in Excel. This pro forma analysis tool comes as I’ve continued to build and share specialty real estate models, tailor-made for specific investment scenarios and property types. This model is an adaptation of my Industrial Development Model. It’s specifically built to analyze both merchant-build and build-to-core, ground-up […]
Allow me to share my Industrial Development Model in Excel. Over the past year, I’ve been working to add more specialty real estate models to our library. While our All-in-One model certainly has its place, oftentimes really digging into the underwriting of a deal takes a hyper-focused tool. This model fits the definition of a […]
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 […]
When modeling real estate investments, industry practice is generally to stop at before-tax cash flow. And this makes sense in most instances. No two owners of real estate have the exact same tax situation and no two properties necessarily have the exact same tax treatment. So comparing the projected returns of two properties on an […]
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 […]
We’ve shared a handful of apartment models over the years. Several of those are capable of analyzing apartment acquisitions (e.g. All-in-One, Apartment Valuation Model), but none was built for the express purpose of modeling value-add apartment deals. As a result, each has its limitations in value-add scenarios. So today, I’m excited to share a new […]
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) […]
I thought I’d share the real estate debt module I built for the ARGUS alternative in Excel that I’ve been working on over the last few months. Most debt modules I’ve seen in real estate financial models only include the ability to model fully amortizing senior debt. Mike challenged me some time ago to come […]
I’ll be the first to admit that real estate asset management doesn’t get the attention it deserves on AdventuresinCRE.com. The real reason for this is that we’re not necessarily asset management experts. I spent some time working in asset management as an intern and I took my fair share of asset management courses during my graduate real […]
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 […]