, , , ,

A.CRE Apartment Development Model

For several years now, our library of real estate models has been lacking a robust ground-up apartment development model. Sure, our All-in-One (Ai1) model has the capability to model multifamily development deals, but it's more a generalist…
, , , , , , , , , , ,

Actual + Forecast Construction Draw Schedule with S-Curve

Several times in the last month, I've been asked to tackle an interesting real estate financial modeling challenge - pare actual construction draw cash flows with s-curve cash flow forecasts to create an Actuals + Forecast Construction Draw…
, , , , , , , , , , , ,

All-in-One (Ai1) Underwriting Model for Real Estate Development and Acquisition (Updated 06.15.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: Construction Draw Schedule

The video below and corresponding downloadable templates will walk you through how to build a basic construction draw schedule. Basic Construction Financing & Draw schedules: A Conceptual Overview A standard draw schedule with a basic…
, , , , , , , , , , ,

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

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

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 will agree to lend to the borrower. So, if a project costs $10MM, and a lender loans…
, , , ,

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…