Construction Draw and Interest
How much cash a project needs each month while it is being built, and who puts it in.
- Type
- Excel model
- Version
- v3.751
- Updated
- Feb 2024
- Stage
- Finance the build, Build
- File
- Excel workbook (.xlsx), 279 KB
- Works in
- Microsoft Excel 2013 or newer, desktop
What it answers
- How much will the project draw each month?
- When does the loan start funding, once the equity is in?
- How much interest will the loan carry before the center opens?
What goes in
- Budget by line item
- Timing of each cost
- Loan amount, rate and fees
- Equity required before the loan funds
What comes out
- Monthly draw schedule
- Equity and loan funding by month
- Interest reserve
How we use it
Our contractors and lenders work from the same schedule, so pay applications line up with what the loan expects to fund.
Before you open it
- Use the desktop version of Excel. Excel for the web and other spreadsheet apps cannot run the parts of a model that use macros.
- On Windows, Excel blocks macros in any file downloaded from the internet and shows a red bar. Close the file, right-click it, choose Properties, tick Unblock and press OK, then open it again. If it came inside a zip, unblock the zip before you extract it.
- Read the Version tab first. It records the model's history and its authors. Leave it in place, unchanged, if you share the file.
Use and sharing
Free to use, adapt and share with anyone, as long as it stays free and its Version tab and credits stay in the file. Provided as is, for education. It is not investment, legal or tax advice, not an appraisal, and not an offer of any security. Any project figures in it are illustrative. Full terms, including credits, are in our Terms of Service.
Construction-Draw-and-Interest-v3.751.xlsx · SHA-256 3fd1a98e7b10484273fdcc51e00ce7949e534a00001750a42f1e6d4fbadf7a57
Who it is for
Each of these has its own way to work with us.
Where it fits in our work
Often used with
Trade partners, suppliers & service firms
Prequalify to Bid
We build with trade partners who share our standard for safety, quality, and schedule. Complete this prequalification to join our bid lists; our team will request the full package as opportunities arise.