Entries by Spencer Burton

, , , , , , ,

Using Boolean Logic to Model Multiple Generations of Tenant Improvements

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. […]

, , ,

Real Estate Equity Waterfall Model – IRR and Equity Multiple Hurdles (Updated July 2018)

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 […]

, , , , , , , , , , ,

Actual + Forecast Construction Draw Schedule with S-Curve

Several times in the last month, I’ve been asked to tackle an interesting real estate financial modeling challenge – pare actual construction draw cash flows with s-curve cash flow forecasts to create an Actuals + Forecast Construction Draw schedule. The real challenge in this exercise, is to have the actual construction draws transition into the […]

, , , , , , , , , , , ,

All-in-One (Ai1) Underwriting Model for Real Estate Development and Acquisition (Updated 06.15.18)

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 […]

, , ,

Real Estate Equity Waterfall Model With Cash-on-Cash Return Hurdle

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 […]

, ,

Keyboard Shortcuts I Use Constantly When Modeling in Excel (Formatting)

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 […]

, , ,

How to Create Dynamic, In-Cell Buttons and Toggles in Microsoft Excel

Creating intuitive, user-friendly, visually appealing models is one aspect of mastering real estate financial modeling. One way to make your models easy for people to use and more attractive in general is to use dynamic, theme-appropriate, in-cell buttons (ie. a button that changes text, font, background based on certain logic) and toggles (i.e. buttons to […]

, , ,

Auto-Populate Latitude and Longitude in Excel (Updated 2018)

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 require […]