Real Estate Financial Modeling

All | Argus| Excel Models | Excel TipsStochastic Modeling
Click to Browse the Library of Excel Models

vintage Walgreens on corner of two busy california streets
, , , , , , , , ,

Single Tenant NNN Lease Valuation Model (Updated 9.18.2018)

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…
, ,

Excel Pro Forma for Flipping Houses (Updated 9.15.2018)

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…
adventures in cre real estate modeler creating cash-on-cash return equity waterfall
, , ,

Real Estate Equity Waterfall Model With Cash-on-Cash Return Hurdle (Updated 9.11.2018)

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…
, , ,

Real Estate Equity Waterfall Model - IRR and Equity Multiple Hurdles (Updated 9.4.2018)

Over the years, my real estate equity waterfall with annual periods and the [glossary_exclude]option[/glossary_exclude] of using either IRR or Equity Multiple Hurdles has been one of the most popular models download at Adventures in CRE. I've…
, , ,

Real Estate Equity Waterfall Model - Monthly Periods (Updated 9.3.2018)

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…
, , , ,

Single Family Residential Investment Analysis Model (Updated 9.1.2018)

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…
, , , ,

Understanding Treatment of Time 0 in the All-in-One Model

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…
, , , , , , , , , , , ,

All-in-One (Ai1) Underwriting Model for Real Estate Development and Acquisition (Updated 08.25.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…
, , ,

Tutorials for the A.CRE Apartment Development Model

As promised, I'm following up the release of the A.CRE Apartment Development model with a series of walk-throughs and tutorials to help you better understand the various elements of the model. The tutorials start with the basics - a guide to…