Companion files · The Private Markets Career Guides

The Construction Lender

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 four workbooks, the toolkit and the read-me, in one archive206 KB

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.

The files

Three numbers to reproduce first

The budget is the collateralA 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 itAn 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 oneTwo 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.