Companion files · The Private Markets Career Guides
The Practitioner's Guide to Construction Contracts, from the Owner's Draft and Subcontract Flow-Down to Notices, Change Orders, Pay Applications and Closeout.
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 Fenwright Builders, the fictional general contractor of the case, through one prime contract and its six subcontracts, from the owner's draft to final payment: the price of each clause, the change orders, the 21 pay applications and the closeout, and the notice and delay calendar. 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, 7 and 8
The seven priced clauses of the owner's draft against the signed contract, with the decision rule; the liquidated damages rate and cap; the steel escalation clause and the flow-down gap. Sheets: Exposure, Liquidated damages, Escalation. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 117 KBChapters 11 and 15
CO1 to CO7 priced on the case markup rule, and the CCD6 directive from price to settlement. Sheets: Change orders, CCD6. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 213 KBChapters 6, 12 and 16
The 21 monthly pay applications, retainage and its cost, a late payment test, and the closeout to final payment. Sheets: Pay applications, Closeout. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 318 KBChapters 10, 13 and 14
The notice log and its deadlines, delay and liquidated damages assessed, and the Miller Act dates of the federal job. Sheets: Notice calendar, Delay. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 416 KBAppendix B
Contract review check-list; Clause pricing check-list; Subcontract flow-down check-list; Notice check-list; Change order check-list; Monthly pay application check-list; Closeout check-list; Federal job additions.
Download the toolkit40 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me3 KB| A clause has a price | $1,291,230 of expected exposure on the owner's draft, $680,286 once negotiated |
| The notice is the right | One notice sent eight days late cost $57,000 of liquidated damages and unpaid general conditions |
| The subcontract must match the prime | S2 passed the whole steel increase to Fenwright, which recovered only part of it from the owner: $155,000 borne |
The files are provided as they are, without warranty of any kind. The model is illustrative: Fenwright Builders, the Varnmoor Institute and every party are fictional, and the contract sums, rates, markups, probabilities and contract terms are the book’s assumptions, not market terms or the default of any standard form. Notice periods, payment rules and statutory dates change and differ by contract: check the signed contract, the current texts and counsel.