This walkthrough, our fifth in the series, explains how the Residual Land Value Calculation module works and how to implement this tool into your analysis. You might recall, a few months back we discussed the concept of residual land value and shared a basic residual land value model. This module expands on the concepts discussed in that […]
This walkthrough, our fourth in the series, explains how the Rate Matrix module works and how to implement this tool into your analysis. The rate matrix concept is new to this site, and not commonly used in the industry. Nonetheless, given that the All-in-One strives to one day become a template model for use by organizations, […]
This walkthrough, our third in the series, takes you through the entire process of modeling a simple development investment. I’ve created hypothetical assumptions for this exercise written out in PDF format (download link below) and then use those assumptions to assess the viability of the investment. I model a hypothetical retail development investment using the All-in-One […]
Version notes for the All-in-One Underwriting Model for Real Estate Development and Acquisition are found here as well as in the ‘Version’ tab of the Excel model. Download the Model Version 0.3.1 (March 11, 2017) Added version notes section Misc. formatting fixes Added link to model documentation online Added data validation to construction length on Budget tab […]
Following the housing crash of 2007 – as regulations were introduced and credit tightened – emerging companies were left with little or no access to the capital markets. In an effort to ameliorate the credit crunch, Congress drew up the Jumpstart Our Business Startups Act (JOBS Act for short), broadening the scope of who can […]
I have two updates/improvements to previous posts I thought I’d share with our readers today; call it, bonus content! The first, is a dynamic Gantt Chart tool I recently added to my Construction Draw and Interest Calculation Model. The second, is an enhancement to my post on writing conditional weighted average formulas that shows you how to include multiple conditions in […]
I thought I’d write a quick post and update our readers on some exciting news around here. As many of you may (or may not) know, Michael and I met while working on our graduate real estate studies at Cornell University. We started adventuresincre.com because we wanted a conduit through which we could interact with likeminded real estate […]
In 2016, I wrote about Wall St. Training and their free Excel modeling resources. In that post, I mentioned the free WST Macros and how it is an indispensable add-in; one that I used in my professional life daily. Unfortunately, as of 2023, Wall St. Training no longer offers the resources mentioned in this blog […]
Maintaining a vibrant, ever-changing blog is not an easy endeavor, and I’ll be the first to admit that it’s not always fun. But what makes blogging worthwhile for Mike and I is the opportunity the blog creates to interact, either through email, phone, or social media with our readers. Meeting Ben Stevens Well, a few […]
You may recall that a couple of weeks ago, I began to explore Stochastic Modeling concepts, or the idea of adding probability into my models, to get a more complete picture of the risk-return metrics of an investment. I became interested in the idea, after reading a thesis on the subject by Keith Chin-Kee Leung shared […]
As promised, I’ve recorded a tutorial on how to use my construction draw and interest calculation model. The 20 minute tutorial walks you through how to use the model to forecast construction cash flows during your development period. The model calculates construction loan interest, forecasts the distribution of sources and uses throughout construction, projects an equity […]
I’ve created a companion to my real estate equity waterfall model to work with equity multiple hurdles, rather than IRR hurdles. It took me longer than I expected to build this, largely because I was over thinking it. I messed around with IF statements, and adding rows, and a whole lot of other ideas that were […]
I promised a how-to video for my real estate apartment acquisition model, and so I thought I’d use an actual property to do so. I grabbed a property from Loopnet that is currently for sale, and dropped the information from the listing into the model. I’m not at all familiar with the property or the sub-market, and […]
If you recently upgraded from Excel 2007 or Excel 2010 to either Excel 2013 or Excel 2016 for Windows, you’ve probably noticed a change that can be quite distracting (and even annoying!). Microsoft Excel now animates certain actions as you work. For instance, when you move from one cell to another, it animates the move. […]