Companion files · The Private Markets Career Guides
Architecture Firm Business by the Numbers: Fees by Phase, Hours Budgets, Utilization, the Multiplier, Consultants, Additional Services, Cash Flow and What Your Firm Is Worth.
These are the companion files of the book. Seven workbooks follow Veskerley Architects, the fictional architecture firm of the case, across two fiscal years: the hours budget of a phase, the multiplier and overhead, additional services, a percentage fee and the redesign clause, the consultants’ money, receivables and the line of credit, and a partner’s buy-in. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the seven workbooks, the toolkit and 00_START_HERE.md. No macros, no date functions, no links between files, no password; the only functions are SUM, ROUND, MIN, IF and AND. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapter 6
One phase of one project against its hours budget: net fee, hours above or below the budget and the phase multiplier. Sheets: Inputs, Phase. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 111 KBChapters 3 and 4
The year’s utilization, indirect labor, overhead, multiplier, overhead rate and breakeven multiplier, with direct labor computed on the year as a reading aid. Sheets: Inputs, Ratios. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 212 KBChapter 8
A client’s change priced at the hourly rate, the fee billed only with a signed written amendment, and what is left after direct labor. Sheets: Inputs, Change. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 311 KBChapter 7
A fee set as a percentage of the construction budget, the lowest bid against the budget, the redesign clause, and the fee the contract sum would have given. Sheets: Inputs, Fee. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 411 KBChapters 11 and 13
One client payment through retainage to the consultants’ share, and the share left in the retainage. Sheets: Inputs, Payment. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 511 KBChapters 13 and 14
Receivables rolled forward over a year, and the line of credit tested against its borrowing base and limit at a month end. Sheets: Inputs, Roll-Forward, Borrowing Base. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 613 KBChapter 16
A partner’s buy-in: the price formula on two years of EBITDA, the cash at signing and a five-year note. Sheets: Inputs, Price, Note. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 713 KBAppendix B
Before signing a fee; The hours budget at signing; The monthly phase review; A client asks for a change; Bids above the budget; The consultant agreement and its payments; The monthly invoice and retainage; An offer of shares to a partner.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and how to use the workbooks on your own firm.
Download the read-me5 KB| The multiplier | FY2026 net fees $1,965,105 over direct labor $723,827: 2.71, against a breakeven multiplier of 2.55 |
| A phase’s hours | The library, construction documents: 2,300 hours recorded against a budget of 2,000, a phase multiplier of 2.92 |
| The partner’s price | Average EBITDA $187,916 x 3.0, less the line of $110,000, times 20 percent: $90,750, of which $22,688 in cash at signing |
The files are provided as they are, without warranty of any kind. The model is illustrative: Veskerley Architects, Ombrecote and every party are fictional, and the fees, phase shares, hours, rates, wages, payment terms, line terms, prices and multiples are the book’s assumptions, not market terms or the practice of any real firm, client, consultant, bank or partner. Rules change: check the current texts, counsel in the firm’s state and the outside CPA before relying on any of them.