Car Wash Financial Model – Excel XLSX

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

1. Runs a genuine Tunnel Capacity & Throughput feasibility check most competing templates skip entirely.
2. Includes a DCF, an EV/EBITDA cross-check, and both unlevered and levered IRR/MOIC/payback.
3. Models a real 60-month membership acquisition/churn rollforward, not a flat growth curve.

FINANCIAL MODELING EXCEL DESCRIPTION

Car Wash Financial Model is an Excel template (XLSX) available for immediate download upon purchase.

Most car wash financial templates blend membership and retail revenue into one generic volume line, and none of them check whether the wash volume they're projecting is physically possible. This model does both differently: it keeps membership and retail as two separate revenue engines – a real 60-month membership acquisition/churn rollforward (this month's members equal last month's members after churn, plus new signups) and a seasonality-adjusted one-time-wash volume build – and then runs a genuine Tunnel Capacity & Throughput feasibility check that validates the combined wash volume against the tunnel's actual physical cars-per-hour capacity.

That matters because a financial plan a lender can't physically verify isn't really a plan. Debt Service Coverage Ratio runs sub-minimum in Year 1, honestly, while the membership base ramps from zero, then clears the 1.25x SBA 7(a) minimum at 2.64x by Year 2 – a real result computed from the throughput-checked revenue and Debt Schedule, not a smoothed assumption. Water & Chemical Costs are modeled per-wash, applied consistently across every wash rather than as a flat percentage guess.

Change the tunnel capacity, membership price, or retail pricing tiers on the Assumptions tab and it flows through the Membership Rollforward, Retail Volume & Seasonality, and Tunnel Capacity & Throughput check into a full 3-statement model, DSCR & Lender Ratios, a 22-ratio Full Ratio Suite, a DuPont ROE Decomposition, and a Business Valuation & Exit tab with a DCF, a comparable-company EV/EBITDA cross-check, and both an unlevered project IRR and a levered owner-equity IRR/MOIC/payback.

Twenty-seven tabs cover the full picture, including an Actual vs. Budget Tracker, Break-Even Analysis, Scenario Analysis, Sensitivity Analysis (wash-volume by price, on both Net Income and DSCR), an Executive Dashboard, Funding Requirement, and Settings – alongside Start Here, Disclaimer, and Help & FAQ.

Every financing rate, cost benchmark, and staffing wage is sourced to 2026 data: SBA 7(a) rate and guarantee-fee schedules, industry-average unlimited-membership pricing, sustained express-tunnel throughput figures, and per-wash water/chemical/electricity cost benchmarks. Built as a native .xlsx, verified across Excel, Google Sheets, LibreOffice, WPS, and ONLYOFFICE. A planning tool, not financial or tax advice.

Source: Best Practices in Financial Modeling, Car Wash Excel: Car Wash Financial Model Excel (XLSX) Spreadsheet, WebsiteGeek