Car Wash Roll-Up ModelFree Financial Model Download

A car-wash roll-up model captures the five-year arc of an express car-wash platform - the PE thesis of acquiring single-site express tunnels at a low single-digit EBITDA multiple, converting pay-per-wash customers to unlimited monthly membership plans, running them through a shared platform (Mister Car Wash, Driven Brands, ZIPS, Whistle Express, GO Car Wash), and exiting at a premium multiple. The workbook runs across eight sheets - Cover, Assumptions, Site_Count, Revenue, P&L, Capital, Returns, Dashboard - plus the shared Disclaimer. Every input is a named-range cell and every formula is one or two operations long.

The Site_Count sheet builds the panel roll-forward: opening sites carry from prior closing, acquired sites from the per-year input, closed sites from a small attrition rate, and closing sites fall out as opening + acquired - closed. Average site count drives the per-site revenue and cost lines so a mid-year acquisition is not double-counted. The Revenue sheet runs three streams off the average site count: membership (members x plan price x 12 x sites), retail wash (washes per day x operating days x ticket x sites), and ancillary (a percent of wash revenue for vacuums and vending), each growing at the per-site growth rate.

The P&L sheet is the cost stack diligence cares about: site labour, utilities, land lease, and repairs & maintenance are per-site costs scaled by average sites; chemicals & water and marketing are percent-of-revenue lines; corporate overhead is a base plus per-site add-on. EBITDA, D&A, EBIT, tax on positive EBIT, and net income flow out with margins and a P&L identity check. The Capital sheet buys the starting platform at Year 0 and then deploys annual acquisitions at trailing EBITDA x purchase multiple, splitting each into sponsor equity and acquisition debt that accrues PIK interest into a cumulative balance.

The Returns sheet runs the sponsor's IRR stream - a Year 0 platform-equity outflow, per-year acquisition-equity outflows, and a Year 5 exit inflow equal to enterprise value (Y5 EBITDA x exit multiple) less cumulative debt - and reports sponsor IRR, MOIC, blended entry multiple, and the entry-vs-exit multiple arbitrage that is the headline value driver. The Dashboard collapses Y5 revenue, EBITDA, EBITDA margin, site count, IRR, MOIC, exit enterprise value, and a revenue mix by stream, with traffic-light status flags against user-set thresholds. The defaults reflect a realistic mid-size roll-up (10 starting sites, ~6 acquisitions per year, ~$1.0M revenue per site, mid-30s mature EBITDA margin, 8.0x entry multiple, 11.5x exit multiple) producing ~27% sponsor IRR and ~2.0x MOIC - flex the inputs to model a specific target portfolio.