# The Architecture Firm Owner: companion files

Julian R. Sterling

## What is here

- **Architecture_Firm_1_Phase_Budget.xlsx** (Chapter 6; Phase Budget workbook of Appendix A): sheets Inputs, Phase, then Checks. One phase of one project read against its hours budget: net fee, hours above or below the budget, phase multiplier (the library, construction documents: 300 hours over, multiplier 2.92).
- **Architecture_Firm_2_Multiplier_and_Overhead.xlsx** (Chapters 3 and 4; Multiplier and Overhead workbook): sheets Inputs, Ratios, then Checks. The year's utilization, overhead, multiplier, overhead rate and breakeven multiplier (FY2026: 72.7 percent, a multiplier of 2.71 against a breakeven multiplier of 2.55).
- **Architecture_Firm_3_Additional_Services.xlsx** (Chapter 8; Additional Services workbook): sheets Inputs, Change, then Checks. A client's change priced at the hourly rate, billed only with a signed written amendment (the Daskerton roof terrace: $46,800).
- **Architecture_Firm_4_Percentage_Fee.xlsx** (Chapter 7; Percentage Fee workbook): sheets Inputs, Fee, then Checks. A fee set as a percentage of the construction budget, the bids against the budget and the redesign clause (the library: $1,080,000, bids 6.7 percent above the budget).
- **Architecture_Firm_5_Consultant_Money.xlsx** (Chapters 11 and 13; Consultant Money workbook): sheets Inputs, Payment, then Checks. One client payment through retainage to the consultants' share (the library invoice of May 2026: $3,664 owed to the consultants, $193 left in the retainage).
- **Architecture_Firm_6_Receivables_and_Line.xlsx** (Chapters 13 and 14; Receivables and Line workbook): sheets Inputs, Roll-Forward, Borrowing Base, then Checks. Receivables rolled forward over a year ($236,196 at the end of FY2026) and the line of credit tested against its borrowing base at a month end (a room of $5,589 in January 2026).
- **Architecture_Firm_7_Partner_Buy_In.xlsx** (Chapter 16; Partner Buy-In workbook): sheets Inputs, Price, Note, then Checks. The owner's price formula for a share of the firm, the cash at signing and the note year by year (20 percent of the shares: $90,750).
- **Architecture_Firm_Toolkit.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (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).

## How to use the workbooks

Every workbook opens on its Inputs sheet: blue type on a light blue background is an input, and nothing else is typed by hand. Each subject has its own sheet, read top to bottom, one line per step. Black type is a formula, green type a figure read from another sheet of the same workbook. The Checks sheet holds the checks of Appendix A: each one is an IF test on your own inputs that shows OK when they hold together and CHECK when they do not. A comparison shown beside a result (the multiplier beside the breakeven multiplier, the fee on the contract sum beside the fee as signed, the direct labor computed on the year) is a reading aid, never a check.

The arithmetic is plain: the only functions are SUM, ROUND, MIN, IF and AND. No date function is used: a month or a fiscal year is a label you type. Rates and shares are typed in percent (8, not 0.08), and every division by an input that can be zero shows 0 instead of an error.

To use a workbook on your own firm, start with a copy, replace every blue input from the record that owns each figure (the time records, the monthly project report, the agreement, the aging report, the income statement), keep every check at OK, and compare a result only with the same firm's own earlier months and years. Never edit a formula to turn a CHECK into OK.

The workbooks are separate files with no link between them: a figure two workbooks share (direct labor, the retainage rate, the line of credit) is typed again where it is used.

## A word of caution

Veskerley Architects, P.C., the town of Ombrecote, the Corrabeck County Library District, Daskerton Properties, Vardellow Family Clinics, Ruskvale Structural, Peltravers Engineering, Brackwenn Construction, Tenterholt National Bank and every party in the case are fictional. Fees, phase shares, hours, rates, wages, costs, payment terms, line terms, prices and multiples are teaching assumptions, not market norms or recommendations. Licensing, the firm's form, retainage, consultant clauses and taxes depend on the state and on the documents signed: read them with counsel in the firm's state, the outside CPA and the banker. Nothing here is legal, tax, insurance or accounting advice.
