Companion files · The Private Markets Career Guides
The Practitioner's Guide to Construction Loans, from the Credit Memo and Loan Sizing to Equity First, the Draw Desk, the Interest Reserve, Overruns and Conversion.
DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample
These are the companion files of the book. Four workbooks follow Merrivane Bank, the fictional regional bank of the case, through one construction loan, from the committee to conversion: the sizing and the sources and uses, the monthly draw and retainage, the overrun, the in-balance test and the interest reserve, and the conversion test. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the four workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapters 4, 5 and 11
The budget and the sources and uses table, loan-to-cost and loan-to-value, and the loop of fee and interest reserve run pass by pass. Sheets: Sizing, Sources and uses, Projection. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 153 KBChapters 6, 8, 9 and 10
Draw No. 11 from request to approved advance, retainage over the whole job, equity first to the first loan advance. Sheets: Draw 11, Retainage. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 219 KBChapters 11, 12 and 14
The in-balance test and the rebalancing deposit, the interest reserve month by month, the extension test. Sheets: In-balance, Interest reserve, Re-projection. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 396 KBChapter 15
DSCR, debt yield and loan-to-value at conversion, the largest loan that passes and the paydown. Sheets: Conversion, Largest loan. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 414 KBAppendix B
Bank limits pre-screen; Sponsor and project; Budget review; Closing conditions; Monthly draw; In-balance test and rebalancing; Extension and conversion.
Download the toolkit40 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me4 KB| The budget is the collateral | A loan of $39,940,000 sized at 65 percent of a total cost of $61,452,400, fee and interest reserve included |
| Declare the imbalance the month you see it | An overrun reported in month 14 called for a rebalancing deposit of $2,162,000 before the next loan dollar |
| Underwrite the way out on day one | Two of the three conversion tests failed, and the sponsor paid down $939,824 to convert |
The files are provided as they are, without warranty of any kind. The model is illustrative: Merrivane Bank, Sabletree Landing and every party are fictional, and the rates, values, rents, loss rates and loan terms are the book’s assumptions, not market terms, regulatory requirements or the policy of any real bank. Rules change and differ by bank and by state: check the current texts, the bank’s policy and counsel.