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

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

As many of you recall, about a year and a half ago 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…
, , , ,

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

Note: Since recording this tutorial, I've updated the model. The latest version includes alerts regarding budget cash flow timing as well as a dynamic Gantt chart. It also fixes an error on the Budget tab in how the subtotal items' Lengths…
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…
, , , ,

Real Estate Development ROI Models

From time to time, I'm asked to share more complex development models that I've used professional. Unfortunately, most of the models that I've used professionally were built in partnership with others, and so I'm not at liberty to share those…