Draw Schedule at True Loan-to-Cost
Loan interest is a project cost too. This draw schedule sizes the loan with that in mind.
- Type
- Excel model
- Version
- v1.1
- Updated
- Sep 2026
- Stage
- Finance the build
- File
- Excel workbook (.xlsx), 31 KB
- Works in
- Microsoft Excel 2013 or newer, desktop
What it answers
- How large can the loan be at the lender's loan-to-cost limit, once interest is counted?
- How much equity does that leave to raise?
- What interest reserve will the lender expect to see?
What goes in
- Budget and timing
- Target loan-to-cost
- Interest rate and fees
What comes out
- Loan amount at true loan-to-cost
- Equity required
- Monthly draws and interest
How we use it
We check every construction loan request against it, so the equity we commit is the equity the project actually needs.
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-True-LTC-v1.1.xlsx · SHA-256 9b9b084f4d88efaa9b44c42528c6978b14d60c527d3cd5e83dc9d72547033cb4
Who it is for
Each of these has its own way to work with us.
Where it fits in our work
Often used with
Co-GP, JV & capital partners
Build With Us
We structure joint ventures with operating partners, co-GP sponsors, and capital partners who bring proven track records. Outline your firm and the partnership you have in mind.