Test the price, capacity and costs behind your tire shop. Explore the online worksheet previews alongside calculations from the current illustrative business case.
6 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Five-year forecast and separate operating break-even sensitivity
Editable Excel product with assumptions and formulas
The online preview illustrates 6 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01Store traffic, conversion and buyer cohortsThe paid workbook turns daily store visitors and seasonality into new buyers, then tracks repeat-customer participation, lifetime and order frequency.Explore layout ↓
02Orders, units, category mix and pricingConverts first and repeat orders into units, allocates units across product categories and applies category prices to build retail revenue.Explore layout ↓
03Inventory, direct costs and operating expensesSeparates tire and service direct costs, revenue-linked expenses and fixed operating categories across monthly periods.Explore layout ↓
04Payroll, bays and service capacitySchedules paid roles and employment costs while the operating bridge reconciles completed orders to technician and bay minutes.Explore layout ↓
05Capex, funding and cashTimes site work, equipment, opening inventory, launch costs and reserve uses and links funding assumptions to cash flow.Explore layout ↓
06Scenarios, statements and dashboardConnects traffic, cohorts, categories, costs, payroll and funding to low, base and high cases, financial statements and management views.Explore layout ↓
Explore the online worksheet illustrations
Open each online sheet presentation to read its specification and illustration. These web views are not screenshots or downloadable Excel files.
Tire ShopPlanned XLSX
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$1,170,000
$1,755,000
$2,340,000
Tire inventory, service materials, card fees and other sales-linked costs
$643,500
$965,250
$1,287,000
Paid owner-manager, service-advisor, technician and shop-support payroll
$285,000
$330,000
$370,000
Rent, utilities, equipment, insurance, software, marketing and overhead
$285,000
$300,000
$315,000
EBITDA
−$43,500
$159,750
$368,000
EBITDA margin
-3.7%
9.1%
15.7%
Planned presentation, not a completed file. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01Store traffic, conversion and buyer cohortsWorksheet specification
Store traffic, conversion and buyer cohorts
Planned purpose: The paid workbook turns daily store visitors and seasonality into new buyers, then tracks repeat-customer participation, lifetime and order frequency.
Inputs
Weekday store visitors
Visitor-to-buyer conversion
Monthly seasonality
Repeat-buyer share
Customer lifetime
Repeat order frequency
Outputs
New buyers
Active repeat buyers
First and repeat orders
Limits and completion needs
Physical visitors exclude phone, web and fleet demand unless the acquisition bridge adds them consistently.
Repeat cohorts require actual customer and order history; a rotation reminder is not a repeat purchase.
02Orders, units, category mix and pricingWorksheet specification
Orders, units, category mix and pricing
Planned purpose: Converts first and repeat orders into units, allocates units across product categories and applies category prices to build retail revenue.
Inputs
Orders
Units per order
Category sales mix
Category price
Price periods
Service-line treatment
Outputs
Units sold
Revenue by category
Weighted retail revenue
Limits and completion needs
The public StartFigures case folds tire and service lines into a $650 completed vehicle order.
Map tire units, labor, alignment, TPMS, discounts, fees and credits separately before transferring the public ticket.
03Inventory, direct costs and operating expensesWorksheet specification
Inventory, direct costs and operating expenses
Planned purpose: Separates tire and service direct costs, revenue-linked expenses and fixed operating categories across monthly periods.
Inputs
Tire acquisition cost
Freight and stocking terms
Service materials
Payment fees
Variable expenses
Fixed expenses
Outputs
COGS
Gross margin
Contribution margin
Operating expenses
Limits and completion needs
Inventory purchases, receipts, sales, returns, rebates, credits, shrink and obsolete stock require a separate unit ledger.
The 55% StartFigures pool is authored and must be replaced with invoice-level cost data.
04Payroll, bays and service capacityWorksheet specification
Payroll, bays and service capacity
Planned purpose: Schedules paid roles and employment costs while the operating bridge reconciles completed orders to technician and bay minutes.
Inputs
Roles
Headcount
Pay rates
Start dates
Employer costs
Bay and technician time by order class
Outputs
Monthly payroll
Headcount
Paid capacity
Orders per staffed day
Limits and completion needs
The verified workbook provides staffing schedules but does not by itself prove three-bay throughput.
National wage data do not set local offers, overtime, benefits or owner compensation.
05Capex, funding and cashWorksheet specification
Capex, funding and cash
Planned purpose: Times site work, equipment, opening inventory, launch costs and reserve uses and links funding assumptions to cash flow.
Inputs
Opening uses
Equipment installation
Inventory funding
Funding sources
Debt terms
Minimum cash
Outputs
Sources and uses
Cash runway
Funding gap
Replacement needs
Limits and completion needs
The $700,000 StartFigures allocation is not a contractor, distributor or lender quote.
Inventory terms, deposits, taxes, debt service and monthly working-capital timing need separate validation.
06Scenarios, statements and dashboardWorksheet specification
Scenarios, statements and dashboard
Planned purpose: Connects traffic, cohorts, categories, costs, payroll and funding to low, base and high cases, financial statements and management views.
Inputs
Selected scenario
Revenue drivers
Margin assumptions
Financing
Tax assumptions
Reporting dates
Outputs
P&L
Cash flow
Balance sheet
Break-even
Dashboard and ratios
Limits and completion needs
Outputs inherit every traffic, conversion, repeat, unit, price, margin and capacity assumption.
A forecast does not certify demand, safety, local authority, cash sufficiency or profitability.
Ways to prepare your files
Template
Current product · Shopify checkout
Edit the financial model with your own assumptions.
Define the revenue drivers, operating modules, outputs and review criteria before agreeing the work.
Project quote · Schedule agreed with you
Assumptions you can change
These are the current inputs behind the business case and the intended starting points for the editable workbook. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
Tire Shop input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Retained sale per completed vehicle order
$650.00
$250.00 – $1,200.00
Revenue per sold unit
Shop-wide completed vehicle orders per trading day
12
5 – 18
Daily throughput in the stated operating scope
Operating days per week
6
5 – 7
Trading schedule
Fixed operating costs / month
$57,083
Held constant
Operating break-even threshold
Contribution margin
45.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
6.0%
Base ramp input
Monthly ramp increment, capped at mature volume
Ramp horizon
12 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
5
$84,435
$126,851
Not reached
Base volume
12
$202,644
$126,851
Month 4
Higher volume
18
$303,966
$126,851
Month 1
Only shop-wide completed vehicle orders per trading day changes. Retained sale per completed vehicle order: $650.00; 6 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 12-month ramp. This sensitivity is separate from the annual forecast and does not measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They demonstrate intended workbook topics, not a tested Excel file.
01 / Annual forecast
Revenue across five years
$1.2m
Year 1
$1.8m
Year 2
$2.3m
Year 3
$2.7m
Year 4
$3.1m
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Leasehold, electrical, compressed air, bay and site work$160,000
Tire, balancing, alignment, lift, compressor and tool systems$140,000
Opening tires, wheels, TPMS parts, weights and consumables$170,000
POS, phones, security, furniture and signage$30,000
Registration, insurance, deposits and professional fees$25,000
Preopening payroll, training and launch marketing$25,000
Working-capital reserve$150,000
One-time budget: $700,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $2,340,000.
Tire inventory, service materials, card fees and other sales-linked costs$1,287,000
Paid owner-manager, service-advisor, technician and shop-support payroll$370,000
Rent, utilities, equipment, insurance, software, marketing and overhead$315,000
EBITDA$368,000
EBITDA margin: 15.7%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
8
Break-even revenue / month
$126,851
Base revenue / month at maturity
$202,644
First operating break-even
Month 4
Units mean shop-wide completed vehicle orders per trading day. The ramp covers 12 months; operating break-even does not measure recovery of opening capital.
The annual forecast and fixed-cost sensitivity are separate planning views. 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 calculator comparison
The annual forecast and calculator use separate scenarios. Their revenue ramp or cost allocations differ, as shown below. The calculator's break-even month does not reconcile the annual forecast.
Original base inputs · USD per year
Check
Annual forecast
Calculator inputs
Year 1 revenue
$1,170,000
$1,957,541
Year 1 operating result
−$43,500
$195,897
Year 3 / mature annual operating result
$368,000
$409,282
Calculator figures use the original first 12 months and mature monthly result × 12; sliders do not change this comparison. Neither column measures cash flow or payback. Input basis.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your tire shop 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.
File format
XLSX
Editor
Microsoft Excel
Editing
Input cells, forecast assumptions and formulas; workbook behavior still needs verification.
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 Tire Shop 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 Store traffic, conversion and buyer cohorts, Orders, units, category mix and pricing, Inventory, direct costs and operating expenses, Payroll, bays and service capacity, Capex, funding and cash, Scenarios, statements and dashboard 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 retained sale per completed vehicle order, shop-wide completed vehicle orders per trading day, 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.
