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, or, as Spencer and I have outlined and shared on the site, others will incorporate a bell curve method such that costs gradually increase over time until the midpoint and then decrease back down towards the end. However, there are many unique cash outflows during every development project to which these methods don’t quite fit.
You might also find valuable our Construction Draw Schedule: Accounting for True LTC post or our Construction Draw and Interest Calculation Module post.
For example, an architect’s budget is usually much higher at the beginning of the development process in the design phase and will usually taper off and decrease significantly during the construction phase. If we think of the architect’s cash flows as shapes or lines over time, it may look like a bell curve in the beginning months starting at a relatively high dollar amount, but when construction starts, that dollar amount per month may drop significantly and be a straight line thereafter.
There is no real one size fits all formula that I have come across that can account for the uniqueness of various cash outflows and that can be used easily from model to model. However, the construction draw template attached is designed to do just that. This construction draw schedule is designed to give you an easy and visual way to ‘design’ your cash flows without having to come up with unique or complicated formulas for every individually unique item.
How the Development Draw Schedule Works
For each line item, there is a grouped set of rows underneath. In the row directly beneath the individual line item’s cash flow, the user will enter a number between 1 and 10 in each period. The series of 10 cells within the column below will turn green in accordance to the number input. For example, if the user inputs a three, the bottom three cells will turn green. If the user puts a 10, all ten cells in the column will turn green. The user will input numbers between 1 and 10 in each period and can visually see how the cash will outflow over the time period. See below for images of the model.
Model the Development Cash Flows with Sublines Open
Model the Development Cash Flows with Sublines Closed
The model will auto calculate the dollar amount to be spent during each period based on the shape of the cash outflow created and the budgeted amount. Please download the model at the bottom of this post and watch the video below for a brief explanation of how to use it.
Video Walkthrough of the Draw Schedule
Download The Model
To make this model accessible to everyone, it is offered on a "Pay What You're Able" basis with no minimum (enter $0 if you'd like) or maximum (your support helps keep the content coming - typical real estate models sell for $100 - $300 each). Just enter a price together with an email address to send the download link to, and then click 'Continue'. If you have any questions about our "Pay What You're Able" program or why we offer our models on this basis, please reach out to either Mike or Spencer.
Note (especially for Gmail users): The model is sent via email and occasionally is blocked by spam filters. If you don't see the email arrive within five minutes, check your spam folder.
A.CRE Draw Schedule - Visually Customize Cash Outflows
This simple and versatile draw schedule allows you to customize the cash outflows of your project visually.
- 48 periods
- 30 line items
This Excel file (the "software") is distributed as is, completely without warranty or service support. www.AdventuresinCRE.com and its authors are not liable for the condition or performance of the software. www.AdventuresinCRE.com owns the copyright and grants users a perpetual, irrevocable, worldwide, non-exclusive, royalty-free license with respect to the software as set forth below.
www.AdventuresinCRE.com and its authors hereby disclaim all implied warranties. www.AdventuresinCRE.com grants the users the right to modify, copy, and redistribute the software and documentation, both within the user's organization and externally, subject to the following restrictions:
1. The users agree not to charge others for use of the software, regardless of whether users have altered and/or improved the software in anyway.
2. In any use of the software, the users agree to acknowledge the www.AdventuresinCRE.com authors that developed the software.
3. The users agree to obey all government restrictions governing redistribution or export of the software.
4. The users agree to reproduce any copyright notice which appears on the software and documentation on any copy or modification of such made available to others.
About the Author: Michael Belasco has over ten years of real estate and construction experience. He currently works for a global real estate investment, development, and asset management firm in San Francisco managing large scale development projects in the city. Michael has both an MBA and Master in Real Estate with a concentration in Real Estate Finance from Cornell University.