Posts

, , , , ,

Apartment Acquisition Model with Monte Carlo Simulation Module (Updated 11.13.2018)

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

Multifamily (Apartment) Acquisition Model

Our library of real estate Excel models has a variety of decent apartment models, including our All-in-One model and our Apartment Development Model - both robust models in their own right. However, if you're looking for a straight multifamily…
Sources and Uses
, , , ,

Construction Draw and Interest Calculation Model (Updated 10.9.2018)

I originally uploaded this equity/construction loan draw and interest calculation tool to our library of real estate financial analysis models in 2016. Over the years, I've continued to update it as suggestions, comments, and requests…
, , , , , ,

Back-of-the-Envelope Office, Retail, Industrial Acquisition Model (Updated 10.1.2018)

I’ve built a new acquisition model that I am excited to share with our readers. This is a back-of-the-envelope (BOE) valuation model that can be used for retail, office, and industrial properties. The goal was to create a sleek and clean look…
, , , ,

Single Family Home Construction Pro Forma for Home Builders (Updated 9.24.2018)

I'm often asked to share models centered around residential development and home building. This is an area of real estate I'm completely comfortable in, since I spent the first 10 years of my career in new residential development. Not surprisingly,…
, , , , ,

Residential Land Development Pro Forma (Updated 9.23.2018)

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

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…