Companion files · The Private Markets Career Guides
Running a Profitable Construction Company: Bid Decisions, Margins, Overhead, Backlog, Subcontractors, Job Costs, WIP, Retainage, Cash and Bonding Capacity.
DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample
These are the companion files of the book. Six workbooks follow Treversham Builders, the fictional general contractor of the case, across two fiscal years: job cost and margin fade, the go/no-go decision, overhead and breakeven, the WIP schedule, cash and retainage, and bonding capacity. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the six 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 9 and 10
J08's five cost lines, estimate against actual, the fade and the gross profit, and the five change orders with their markup. Sheets: Estimate and Actual, Change Orders. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 113 KBChapters 5 and 8
The eight criteria of the go/no-go sheet, scored for the job that was bid and the job that was declined, against the threshold. Sheets: Go No-Go. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 210 KBChapters 3 and 6
The twelve overhead lines of two years, gross margin and breakeven revenue, the FY2027 planning line and the bid margin rule. Sheets: Overhead, Breakeven, Margin Rule. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 315 KBChapter 13
Three open jobs at year end: percent complete, earned, overbilled or underbilled, and the estimated gross profit. Sheets: WIP 2026. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 410 KBChapters 12 and 14
One job's own cash, month by month, to its lowest point and back, and its retainage withheld and held. Sheets: J09 Cash, Retainage. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 512 KBChapter 15
Working capital at two year ends, the aggregate program and the single job limit, and the large bid against it. Sheets: Working Capital, Limits. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 611 KBAppendix B
Go/no-go; Subcontractor prequalification and buyout; Job start; Monthly job review; Closeout; The owner's month-end review.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me4 KB| The fade on J08 | Actual cost $895,703 against an estimate of $822,500: $73,203 of margin lost |
| The breakeven line | FY2026 overhead and interest at the year’s gross margin: $13,128,724 of revenue |
| The single job limit | Working capital $1,062,357 x 12 x 0.40: $5,099,314, against D1 at about $9,400,000 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Treversham Builders, Stannerby and every party are fictional, and the contract amounts, bid margins, overhead, retainage terms, scores and the surety guideline are the book’s assumptions, not market terms or the practice of any real contractor, bank or surety. Rules change: check the current texts, your state and city rules, your outside CPA and your counsel.