, , , , , , , , , , ,

Development Draw Schedule - Visually Customize Each Line Item

Working a lot with development draw schedules, I have always been looking for a catch all solution as to how one could easily model all the unique ways cash actually flows over time during the process. The norm for many is to model cash flows…
, , , , , , , , , , , ,

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

Watch Me Build a Multifamily Real Estate Model

One way to become a better real estate financial modeling professional, is to watch other professionals model. I know in my career being able to physically see how others tackle different modeling problems has shaped my methods and made me better…
, , , , ,

How to Use the Apartment Acquisition Model's Monte Carlo Simulation Module

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

Apartment Acquisition Model with Monte Carlo Simulation Module

I'd like to share an apartment acquisition model I built that includes a Monte Carlo Simulation module. This method of analysis, a type of stochastic modeling rarely used in real estate, allows the analyst to better understanding the risk-adjusted…
, , , ,

Apartment Valuation Tutorial Using the Real Estate Acquisition Model

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

Multifamily (Apartment) Acquisition Model in Excel

We haven't uploaded an apartment acquisition model to our Excel library of real estate models yet, and I didn't have anything worth sharing in my personal library that wasn't proprietary. So I thought I'd alter the real estate valuation model…
, , , , ,

Multifamily Redevelopment Model

This is an excel model built from scratch for value-add, opportunistic, and core multifamily properties. It was designed to work best for scenarios where individual units will be rehabbed over the hold at varying times. It can work for properties…
, , , ,

Multifamily Development Model

This is the first in a series of Excel models on adventuresincre.com Here is a basic multifamily development model that I put together. I didn't build this model from scratch, but rather pieced together several other models to arrive at…