Companion files · The Private Markets Career Guides
Car Wash Business by the Numbers: Members and Churn, the Retail Ticket, Weather, Cost per Car, Labor, the Tunnel's Financing, Land, a Second Site and What It Is Worth.
These are the companion files of the book. Seven workbooks follow Wexmarrow Express Wash, the fictional car wash company of the case, across two fiscal years: member economics, the retail ticket and its options, the cost per car, labor and overtime, the tunnel’s financing, the second site’s payback, and the two offers on the owner’s desk. 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, MAX, IF and AND. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapter 2
One member of one plan for a month, then over the months the member is expected to stay: card fee, wash cost, monthly contribution, expected months. Tabs: Inputs, Members, Checks. An Inputs tab holds every number; a Checks tab holds the checks of Appendix A.
Download workbook 111 KBChapter 3
The average retail ticket built from the menu, and how often each option attaches to the washes that can carry it. Tabs: Inputs, Ticket, Checks. An Inputs tab holds every number; a Checks tab holds the checks of Appendix A.
Download workbook 211 KBChapter 5
Chemicals, water, power and parts for one car, package by package, and the Ultimate Club member wash. Tabs: Inputs, Cost, Checks. An Inputs tab holds every number; a Checks tab holds the checks of Appendix A.
Download workbook 311 KBChapter 6
One week of attendant labor, overtime and burden included, spread over that week’s cars. Tabs: Inputs, Labor, Checks. An Inputs tab holds every number; a Checks tab holds the checks of Appendix A.
Download workbook 411 KBChapter 9
The lessor’s lease beside the bank’s loan quote for the same tunnel equipment: what each pays out in total, undiscounted. Tabs: Inputs, Financing, Checks. An Inputs tab holds every number; a Checks tab holds the checks of Appendix A.
Download workbook 511 KBChapter 11
What the second site cost, how the SBA loan split it with the owner, and the simple payback at one quarter’s rate. Tabs: Inputs, Payback, Checks. An Inputs tab holds every number; a Checks tab holds the checks of Appendix A.
Download workbook 611 KBChapters 15 and 16
The letter of intent from adjusted EBITDA to the amount paid at closing, and the sale-leaseback price and cash after the mortgage, read apart. Tabs: Inputs, Offer, Checks. An Inputs tab holds every number; a Checks tab holds the checks of Appendix A.
Download workbook 712 KBAppendix B
The monthly member review (chapter 2); The pay station menu and the options (chapter 3); The weather and staffing week (chapters 4 and 6); The cost per car and the sewer (chapter 5); Maintenance and downtime (chapter 7); Membership terms and the cancel path (chapter 8); Financing a tunnel or a second site (chapters 9 and 11); Before answering an offer or a sale-leaseback (chapters 10, 15 and 16).
Download the toolkit42 KBRead first
What each file holds, which workbook answers which chapter, and how to use the workbooks on your own business.
Download the read-me5 KB| A member | The first site’s Ultimate Club in FY2026: $26.77 a month after card fee and wash cost, $557 over 20.8 expected months |
| A car | The first site in FY2026: Basic $1.79, Deluxe $2.26, Ultimate $2.89, Ultimate Club member wash $4.26 |
| The offer | Adjusted EBITDA $1,466,584 x 8.0 = $11,732,672; paid at closing $7,454,689, before taxes and fees |
The files are provided as they are, without warranty of any kind. The model is illustrative: Wexmarrow Express Wash, Venterby and every party are fictional, and the prices, counts, rates, costs, hours, wages, terms, quotes and multiples are the book’s assumptions, not market terms or the practice of any real wash, supplier, lessor, bank, investor or buyer. Rules change: check the current texts, counsel in the company’s state, the town’s sewer authority and the outside CPA before relying on any of them.