Companion files · The Private Markets Career Guides
How to Run a Profitable Interior Design Studio: Design Fees, Hours, Product Markup, Client Deposits, Purchasing, Freight and Installation, Cash and Selling the Business.
These are the companion files of the book. Six workbooks follow Ivenhart Interiors, the fictional design studio of the case, across two fiscal years: projects and fees, hours and utilization, products and markup, deposits and logistics, cash and decisions, and profit and value. Each keeps the case’s figures in one column and an empty column for yours. A toolkit holds the checklists 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 3 and 4
Projects signed by type and size, the fee lines, what a single room’s flat fee earned per actual hour with and without change orders, and a whole home billed hourly against a percentage of its trade cost. Sheets: Inputs, Projects, Fees, Comparison. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 116 KBChapters 5, 6 and 11
Budgeted and actual hours by phase, design hours by type and by phase, the hours available and utilization, and a commercial project read apart. Sheets: Inputs, Hours by phase, Available hours, Commercial project. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 217 KBChapters 7 and 8
A medium room’s purchase orders from trade cost to client price, product sales and product margin for the year, and the vendor rebate. Sheets: Inputs, Purchase orders, Summary, Vendor rebate. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 315 KBChapters 9 and 10
The deposit ledger month by month against cash, a custom order under the old and the new deposit rule, and logistics paid against what clients were charged. Sheets: Inputs, Deposit ledger, Custom order, Logistics ledger. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 421 KBChapters 12, 14 and 15
Cash less the line and customer deposits, revenue by quarter, the receiving warehouse against a space of its own, and the fee-only test beside a second senior designer. Sheets: Inputs, Cash, Receiving warehouse, Fee-only test. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 518 KBChapters 13 and 16
Both income statements and the bridge between them, seller’s discretionary earnings and EBITDA, and the founder’s planning range. Sheets: Inputs, Income statement, SDE, Planning range. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 617 KBAppendix B
The letter of agreement; The product proposal and quote; The purchase order and deposit; Receiving and inspecting deliveries; Installation day; Closing a project; The monthly review; Preparing a sale.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me5 KB| A single room | $8,400 flat fee / 67.5 actual hours = $124.44 an hour in FY2026, against an hourly rate of $190 |
| Clients’ money | customer deposits of $246,310 against cash of $192,662 at 30 September 2025, 127.8 percent |
| Cash that is the studio’s | $764,766 - $0 - $592,192 = $172,574 at 30 September 2026 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Ivenhart Interiors, Ashvenley, the clients, the builder, the hotel, the vendor, the workroom, the warehouse and every party are fictional, and the fees, hourly rates, trade costs, markups, wages, rents and multiples are the book’s assumptions, not market terms or the practice of any real studio. No figure implies a style, color, material or layout choice. Licensing, sales tax, client deposits and rebates depend on your state: ask counsel and your outside CPA.