Entries by Michael Belasco

, , , , , ,

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 capital stack of debt and equity works as follows: The development budget is created and projected out over the anticipated […]

, , , , , , , , , , ,

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 using a straight line method with even payments over time, […]

, , , , , , , ,

4-Tier Equity Multiple Waterfall – Download and Watch Me Build

Here is a simple, yet very powerful, 4-tier equity multiple waterfall module. This post contains both a completed version of the module ready to plug into a real estate financial model as well as a ‘Watch Me Build’ template and companion video where I walk the user step by step through building it out. EM […]

, , , ,

A.CRE 101: How To Use The Discounted Cash Flow (DCF) Method To Value Income Producing Property

The Discounted Cash Flow Method is a method to value a project by taking all future projected cash flows of the project and discounting them back to time zero (date of purchase) using a predetermined discount rate (the discount rate when used in a DCF to look at an investment can be looked at as […]

, , , , ,

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 IRR hurdles. Additionally, you can model for a preferred return for the limited partner where either (1) […]