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

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

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

3 Tiered Waterfall Module Added to the Condo Development Model

After receiving a few requests, I've finally gotten around to adding an equity waterfall module to the Condominium Development Model. This module allows you to model partnership splits up to three tiers using either equity multiple hurdles or…
, , , ,

Condominium Development Model

After posting the construction draw module a few weeks back that demonstrates how to calculate the true LTC of a development loan, I decided that since we have yet to publish a condo development model, to build upon that module to create one.…
, , , , , , , , ,

Construction Draw Schedule: Accounting For True LTC

Mitigating A Common and Potentially Costly Error During Development Underwriting When lenders provide debt for a development project, they lend based on a Loan-to-Cost ratio (LTC), which is simply the percent of the total budget the lender…
, , , ,

Real Estate Development Tracker

One of the many challenges of both analyzing real estate development deals and managing development projects is understanding and tracking the numerous differing but intertwining work streams. The more a development team takes the time…
land being analyzed in a land development pro forma
, , , , ,

Residential Land Development Pro forma

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

How to Use the Construction Draw and Interest Calculation Model

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…
Sources and Uses
, , , ,

Construction Draw and Interest Calculation Model

I've been meaning to include this equity/construction loan draw and interest calculation tool in our library of real estate financial analysis models, and finally got around to uploading it today. I built this awhile back at a time when…
Normal Distribution in Real Estate Forecasting
, , , , , ,

S-Curve Forecasting in Real Estate Development

One of the reasons Mike and I blog, is to force ourselves to be continually learning. I built the first version of my real estate waterfall model, because I wanted to better understand the mechanics of modeling an equity waterfall with…