# The Car Wash Owner: companion files

Julian R. Sterling

## What is here

- **CarWash_1_Member_Economics.xlsx** (Chapter 2; Workbook 1 of Appendix A): tabs Inputs, Members, Checks. One member of one plan for a month, then over the months the member is expected to stay (the first site's Ultimate Club in FY2026: $26.77 a month, $557 over 20.8 expected months, before labor and overhead).
- **CarWash_2_Ticket_and_Options.xlsx** (Chapter 3; Workbook 2): tabs Inputs, Ticket, Checks. The average retail ticket built from the menu and the attach rate of each option (the first site in FY2026: $19.53 a retail wash).
- **CarWash_3_Cost_per_Car.xlsx** (Chapter 5; Workbook 3): tabs Inputs, Cost, Checks. Chemicals, water, power and parts for one car, package by package (the first site in FY2026: Basic $1.79, Ultimate Club member wash $4.26).
- **CarWash_4_Labor_and_Overtime.xlsx** (Chapter 6; Workbook 4): tabs Inputs, Labor, Checks. One week of attendant labor, overtime and burden included, spread over that week's cars (the second site's busiest week of FY2026: $2.26 a car).
- **CarWash_5_Tunnel_Financing.xlsx** (Chapter 9; Workbook 5): tabs Inputs, Financing, Checks. The lessor's lease beside the bank's loan quote for the same equipment, undiscounted (lease total less loan total -$25,531).
- **CarWash_6_Second_Site_Payback.xlsx** (Chapter 11; Workbook 6): tabs Inputs, Payback, Checks. What the second site cost, the SBA loan's share and the simple payback at one quarter's rate (3.6 years at the Q4 FY2026 rate).
- **CarWash_7_Offer_and_Sale_Leaseback.xlsx** (Chapters 15 and 16; Workbook 7): tabs Inputs, Offer, Checks. The letter of intent and the sale-leaseback offer, each read on its own (paid at closing $7,454,689 before taxes and fees; sale-leaseback cash after the mortgage $1,223,320).
- **Car_Wash_Owner_Toolkit.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (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)).

## How to use the workbooks

Every workbook opens on its Inputs tab: blue type on a light blue background is an input, and nothing else is typed by hand. The subject tab is read top to bottom, one result per line. Black type is a formula, green type a figure read from another tab of the same workbook. The Checks tab holds the checks of Appendix A: each one is an IF test on your own inputs that shows OK or CHECK, and the cell All checks shows OK only when every check above it does. A comparison of your figures with the case's is your reading, never a check.

The arithmetic is plain: the only functions are SUM, ROUND, MIN, MAX, IF and AND. No date is used anywhere: a week, a quarter or a fiscal year is a label. Shares and rates are typed in percent (2.6, not 0.026), and every division by an input that can be zero is wrapped in IF and shows 0 instead of an error. An empty input reads as zero in a sum, a product or a comparison, but a MIN over a range skips it: the "no negative" checks therefore pass on an empty cell. The last section of Appendix A lists, workbook by workbook, what the checks do not catch.

To use a workbook on your own sites, start with a copy, replace every blue input from the record that owns each figure (the membership software's reports, the pay station reports, the utility and chemical invoices, the timesheets and payroll, the lease and the loan quote, the progress payment schedule and the statements, the letter of intent and the investor's offer), keep every check at OK, and compare a result only with the same site's own earlier weeks 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 (the cost per member wash, a result of workbook 3 and an input of workbook 1) is typed again where it is used.

## A word of caution

Wexmarrow Express Wash, Inc., the town of Venterby, Durnseth Community Bank, Morwennick Equipment Leasing, Selbrenn Properties, Garrowtide Net Lease and every party in the case are fictional. Prices, counts, rates, costs, hours, wages, terms, quotes and multiples are teaching assumptions, not market norms or recommendations, and not a statement of any rule or law. What the federal rules on negative option plans and overtime require is for their current texts; what a state or a town requires for automatic renewal, wages, sewer discharge and water reuse is for counsel in the company's state; taxes are for the outside CPA. The files are provided as they are, without warranty of any kind.
