Excel financial planning template for auto detailing business. The online worksheet illustrations use a separate website scenario; review the selected product's file specification and delivery terms before buying.
6 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Online five-year scenario and monthly operating sensitivity
Excel template sold separately; review the selected file specification
The online preview illustrates 6 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01Revenue & Customer CohortsThe online planning outline builds sales from completed vehicles, service mix, retained ticket and field days; customer cohorts and billable hours require a separate reconciliation to route time.Explore layout ↓
02COGS & OPEXSeparate chemicals, towels, route fuel, water, wastewater disposal, card fees and rework from van, insurance, software, marketing and other fixed overhead.Explore layout ↓
03Payroll & CapacityTranslate a paid working owner-detailer and one part-time helper into labor cost, field hours and feasible daily vehicle capacity.Explore layout ↓
04Capex & FundingSchedule the van, secure upfit, recovery system, initial supplies, setup costs, reserve and funding sources.Explore layout ↓
05Scenarios & Break-evenTest ticket, completed vehicles, contribution margin, fixed costs, route time and completion rate together.Explore layout ↓
06Dashboard & StatementsConnect the selected case to five-year statements, KPI views, funding needs and decision thresholds.Explore layout ↓
Explore the online worksheet illustrations
Open each section to read the operating assumptions and illustration. These web views are not screenshots or downloadable Excel files.
Auto Detailing BusinessHTML illustration
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$106,600
$138,580
$159,900
Chemicals, route fuel, disposal and transaction costs
$21,320
$27,716
$31,980
Paid owner and helper incl. employer costs
$68,000
$76,000
$80,000
Vehicle, insurance, marketing and other operating costs
$33,500
$34,200
$35,200
EBITDA
−$16,220
$664
$12,720
EBITDA margin
-15.2%
0.5%
8.0%
Online scenario illustration; not a screenshot of the purchased workbook. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01Revenue & Customer CohortsOperating assumptions
Revenue & Customer Cohorts
Scenario purpose: The online planning outline builds sales from completed vehicles, service mix, retained ticket and field days; customer cohorts and billable hours require a separate reconciliation to route time.
Inputs
Completed vehicles by day and month
Service-package mix and retained net price
Service area and field days
New, repeat and cancelled bookings
Outputs
Monthly and annual revenue
Revenue by service package
Completion and repeat-customer reconciliation
Scope and limitations
Completed vehicles, active customers and billable hours are different units. Reconcile repeat bookings, actual package time and paid route hours before transferring the public ticket into an hourly model.
Bookings and quoted work are not revenue until the vehicle is completed and the retained sale reconciles.
These online planning modules describe the stated case. They do not verify the current paid-file attachment, its version or working formulas.
02COGS & OPEXOperating assumptions
COGS & OPEX
Scenario purpose: Separate chemicals, towels, route fuel, water, wastewater disposal, card fees and rework from van, insurance, software, marketing and other fixed overhead.
Inputs
Chemical and towel use per package
Route miles and fuel price
Water and authorized disposal cost
Insurance, software, maintenance and marketing
Outputs
Sales-linked cost schedule
Fixed operating expense schedule
Contribution and overhead bridge
Scope and limitations
Supplier invoices, route logs, merchant statements and disposal receipts must replace the provisional cost envelope.
The cited fuel price is a dated national reference, not a five-year route forecast.
03Payroll & CapacityOperating assumptions
Payroll & Capacity
Scenario purpose: Translate a paid working owner-detailer and one part-time helper into labor cost, field hours and feasible daily vehicle capacity.
Inputs
Role, paid hours and wage or salary
Employer costs and helper schedule
Package service minutes
Travel, setup, pack-down and recovery time
Outputs
Annual payroll by role
Field hours per completed vehicle
Daily and weekly capacity checks
Scope and limitations
National occupational wages do not establish a local hiring offer or owner compensation.
Four daily jobs are feasible only with a shorter service mix, tighter routing or more resources than the base case.
Elapsed van-route hours and paid person-hours are different; the part-time helper is not present for every field hour, and administration is additional work.
04Capex & FundingOperating assumptions
Capex & Funding
Scenario purpose: Schedule the van, secure upfit, recovery system, initial supplies, setup costs, reserve and funding sources.
Inputs
Vehicle and upfit bids
Payload and installation specifications
Permits, deposits and opening supplies
Debt, equity and working-capital timing
Outputs
Sources-and-uses schedule
Opening cash requirement
Funding gap and reserve runway
Scope and limitations
The $100,000 case is a planning allocation rather than a delivered quote.
Define the revenue drivers, operating modules, outputs and review criteria before agreeing the work.
Project quote · Schedule agreed with you
Assumptions you can change
Use the Excel template to compare your financial assumptions. Review the selected version's input structure and outputs before adapting it. The online inputs and outputs on this page explain this website's price, volume, cost and opening-budget assumptions; they do not edit or verify a workbook. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
Neither template establishes local demand, licensing compliance, financing approval or available owner cash.
Auto Detailing Business input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Net revenue per completed vehicle
$205.00
$145.00 – $325.00
Revenue per sold unit
Completed vehicles per field day across one route
3
2 – 4
Daily throughput in the stated operating scope
Operating days per week
5
4 – 6
Trading schedule
Fixed operating costs / month
$9,600
Held constant
Operating break-even threshold
Contribution margin
80.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
50.0%
Base ramp input
Opening month revenue
Mature volume added / month
4.0%
Base ramp input
Monthly ramp increment, capped at mature volume
Ramp horizon
18 months
Base ramp input
Period checked for operating break-even
The opening budget and annual expense inputs also need local quotes and staffing estimates. This page shows fixed examples; the free calculator lets you change price, volume and trading days.
Volume-only sensitivity · revenue at mature volume · monthly USD
Scenario
Daily units
Monthly revenue
Break-even revenue
First operating break-even
Lower volume
2
$8,877
$12,000
Not reached
Base volume
3
$13,315
$12,000
Month 12
Higher volume
4
$17,753
$12,000
Month 6
Only completed vehicles per field day across one route changes. Net revenue per completed vehicle: $205.00; 5 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 18-month ramp. Annual revenue and EBITDA use the annual forecast. Break-even uses a separate monthly calculator sensitivity; it does not establish when the annual forecast covers its costs. Slider cases do not change the annual forecast or measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They illustrate planning calculations; they do not establish the purchased workbook’s formula behavior.
01 / Annual forecast
Revenue across five years
$106.6k
Year 1
$138.6k
Year 2
$159.9k
Year 3
$170.0k
Year 4
$180.2k
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Cargo van$48,400
Mobile equipment and secure upfit$12,600
Wastewater containment, recovery and disposal setup$4,000
Initial chemicals, PPE and towels$2,500
Booking, website and branding$2,500
Registrations, permits, insurance deposits and professional fees$3,000
Working capital reserve$27,000
One-time budget: $100,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $159,900.
Chemicals, route fuel, disposal and transaction costs$31,980
Paid owner and helper incl. employer costs$80,000
Vehicle, insurance, marketing and other operating costs$35,200
EBITDA$12,720
EBITDA margin: 8.0%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
3
Break-even revenue / month
$12,000
Base revenue / month at maturity
$13,315
First operating break-even
Month 12
Units mean completed vehicles per field day across one route. The ramp covers 18 months; operating break-even does not measure recovery of opening capital.
Annual revenue and EBITDA use the annual forecast. Break-even uses a separate monthly calculator sensitivity; it does not establish when the annual forecast covers its costs. The website does not yet supply a complete funding, debt, tax and working-capital schedule for a cumulative cash-flow or payback chart. Read the full input basis and limitations.
Annual forecast and monthly operating reconciliation
Annual revenue and EBITDA use the annual forecast. Break-even uses a separate monthly calculator sensitivity; it does not establish when the annual forecast covers its costs.
Original inputs · annual USD · whole-dollar rounding tolerance $5
Check
Annual forecast
Monthly calculator base
Year 1 revenue
$106,600
$115,039
Year 1 operating result
−$16,220
−$23,168
Year 2 revenue
$138,580
$159,511
Year 2 operating result
$664
$12,409
Year 3 revenue
$159,900
$159,777
Year 3 operating result
$12,720
$12,622
Year 3 / full-volume annual revenue
$159,900
$159,777
Year 3 / full-volume annual operating result
$12,720
$12,622
Year 1 uses months 1–12, Year 2 months 13–24 and Year 3 months 25–36. Full-volume rows use mature monthly sales and operating result × 12. The calculator holds price, days, contribution and fixed costs constant; an annual price, staffing or cost change can explain a separate path. Sliders are separate sensitivities and do not overwrite this saved annual base. Neither column measures cash flow, owner distributions or payback. Agreement tests arithmetic, not demand or cash funding. Input basis.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your auto detailing business together. Update the narrative when you change the forecast.
The Business Plan uses Word and the Financial Model uses Excel. The online illustrations use this website's scenario data and may differ from the purchased files.
Listed file format
XLSX
Editor
Microsoft Excel
Editing
Adapt forecast assumptions in Excel. Check the selected version's forecast length, worksheets and formula permissions; the online illustrations use a separate scenario.
Other software
Compatibility with alternative editors has not been verified.
Delivery and terms
Review the product description, delivery details, license and final total in Shopify before paying.
Use the purchase button to buy the Auto Detailing Business Financial Model for $109 through Shopify. This is a one-time price in USD before any applicable taxes.
What do the online previews show?
The online preview explains Revenue & Customer Cohorts, COGS & OPEX, Payroll & Capacity, Capex & Funding, Scenarios & Break-even, Dashboard & Statements using this website's illustrative case. It is separate from the downloadable Excel model.
Are these previews pages from a finished file?
The web previews are rendered from the website's case record. They illustrate planning concepts and calculations; they are not screenshots or a page-by-page inventory of the downloadable product.
What would I need to change for my business?
Review net revenue per completed vehicle, completed vehicles per field day across one route, the operating schedule, opening budget and costs. These web previews do not edit a workbook. Test the website's price and volume assumptions in the business idea page's calculator.
Is the written business plan included?
The Financial Model is sold separately. The $168 Bundle adds the $59 Business Plan and $109 Financial Model for the same business to one cart, one of each.
Do the figures establish what my business will earn?
No. The figures describe an illustrative U.S. operating case, not measured industry averages or a prediction for your location. EBITDA is not owner cash, and operating break-even does not recover the opening investment. Check local costs, capacity and demand before using the assumptions.
Do the web previews reproduce the purchased files?
The online outlines, tables and worksheet illustrations use this website's scenario. They are not screenshots, a verified page count or a confirmed worksheet inventory of the purchased files. Check the selected product's specification before buying.
How are the files delivered?
Review the selected item's delivery method and license in Shopify before paying. These pages do not document a completed purchase or download test.
