# Auto Repair Chain Model See how repair demand, pricing, service mix, and shop expansion shape an auto repair business. - Canonical: https://finamodel.com/templates/auto-repair - Excel download: https://finamodel.com/templates/auto-repair.xlsx - Category: Consumer - Model type: Operating model - Difficulty: Intermediate - Audiences: Investors & analysts, Founders & operators, Auto-services and repair operators, Search-fund and PE buyers, Consumer-services investors, Lenders and analysts - Tags: auto-repair, auto-services, car-repair, rollup, dcf ## Overview This model helps you understand an auto repair business across routine maintenance, mechanical work, collision repairs, and diagnostics. It brings customer demand, repair orders, service plans, and parts sales together with the people, equipment, and premises needed to run each shop. Use it to assess a single garage, a new location, or a buy-and-build strategy. Test the assumptions behind growth and see how they affect profit, cash flow, and business value. ## What's included - Shop inputs: Year-1 shops, new shops per year, repair orders per shop, technicians per shop, average repair order - Utilisation: Year-1 bay utilisation with an annual ramp and a practical ceiling - Service mix: maintenance, mechanical, collision and diagnostics shares, per-tier price indices and net margins - Ancillary: members per shop and annual plan fee, tire and accessory retail spend per order, price escalation - Cost structure: technician and advisor comp and wage with benefits and wage growth; facilities and equipment, marketing, technology and SG&A as % of gross profit; depreciation (% of revenue); tax - Capital and working capital: maintenance capex %, shop build-out cost per shop, NWC % of revenue growth, base-year revenue - Valuation: WACC, terminal growth, net debt, shares outstanding - Operations sheet: shop roll-forward, utilisation ramp, orders per shop, total repair orders, staff headcount, orders per technician - Revenue sheet: four service tiers, repair revenue, service plans, tire and accessory retail, total revenue - P&L sheet: revenue to net income with parts and sublet cost, labour and overhead, margins, identity check - FCF sheet: NOPAT, depreciation add-back, capex, change in NWC, unlevered FCF, discount factor, PV - Valuation sheet: sum of PV, terminal value, enterprise value, equity value, value per share, implied EV/EBITDA - Dashboard with shops, repair orders, utilisation, revenue per shop and per order, EBITDA margin, EV, per share, and revenue mix ## How the Auto Repair Chain Financial Model works This auto repair financial model captures a seven-year operating forecast and unlevered DCF for a multi-shop chain offering mechanical repair, collision work, maintenance and diagnostics. It builds up from shop expansion, bay utilisation and technician capacity to service-mix revenue, then flows through to EBITDA, free cash flow and enterprise value. The template helps you evaluate growth and profitability drivers. ### Operating drivers behind the shop estate and repair volume The model grows the estate by a gross number of new shops each year, then tapers that pipeline using a cubic factor that decreases as the shop count approaches an addressable ceiling. - This means early growth is barely constrained, but later expansion flattens into an asymptote. - Closing shops, which equal opening shops plus tapered new shops, drive repair-order volume, technician capacity and service-advisor headcount. - The year's new shops also trigger build-out capital expenditure through a per-shop investment, so expansion decisions directly affect cash flow and valuation over the seven-year horizon. Calculation summary: ```text // Closing shops = Opening_Shops + Tapered_New_Shops // Build-out capex = New_Shops * Investment_Per_Shop ``` ### Repair volume and the technician capacity cap Repair orders per shop start from a physical capacity basis: bays per shop times mature orders per bay. Utilisation is applied in two layers. - A seasoned rate ramps annually toward a practical ceiling, while shops opened during the year run at a first-year productivity haircut and only for the portion of the year they are open. Effective utilisation blends seasoned shops at the full rate with the de novo cohort at the haircut rate. - Demand-side volume is then capped against a supply-side ceiling: closing shops times the bay-limited maximum technicians per shop times orders per technician. Total repair orders is the lesser of the two, and technician headcount is solved backward from booked volume, so the technician constraint actually binds when demand exceeds supply. Calculation summary: ```text // Technician capacity = Closing_Shops * Maximum_Technicians_Per_Shop * Orders_Per_Technician // Repair orders = MIN(Demand_Side_Volume, Technician_Capacity) ``` ### Service mix, revenue build and cost of delivery Repair revenue is built tier by tier. Total repair orders are split across maintenance, mechanical, collision and diagnostics according to their respective shares, with diagnostics as the residual so the mix always sums to 100%. - Each tier applies a base ticket and a price index, then revenue is escalated at a menu step-up. This makes blended revenue per order a direct output of the service mix rather than raw car count. - On top of repair revenue, shop-driven maintenance plans add closing shops times members per shop times an annual fee, and order-driven tire and accessory retail adds orders times retail spend per order. All three revenue streams carry their own cost of revenue: tier revenue times one minus tier net margin for repair, and separate margins for plans and retail. These costs feed into gross profit. Calculation summary: ```text // Repair revenue by tier = Repair_Orders * Service_Share * Base_Ticket * Tier_Price_Index * Price_Escalation_Factor // Direct cost by tier = Tier_Revenue * (1 - Tier_Net_Margin) ``` ### Profitability, margins and the labour and parts memo Gross profit is revenue less parts, tires and consumables cost. From there, technician and service-advisor labour are charged as operating expenses, driven by headcount, wages, benefits and wage growth. - Technician headcount follows booked volume through the capacity build, while advisor headcount follows the mid-year-weighted shop count. Overhead items—facilities and equipment, marketing, technology and corporate SG&A—are set as percentages of gross profit rather than revenue, reflecting the parts-pass-through and labour-intensive nature of the business. - This leads to EBITDA, then depreciation, EBIT, tax and net income. A separate memo block reports effective labour rate, parts-to-labour ratio and parts margin, which are outputs of the tier margin structure rather than independent drivers. Calculation summary: ```text // Gross profit = Revenue - Direct_Costs // EBITDA = Gross_Profit - Labour - Overhead // EBIT = EBITDA - Depreciation ``` ### Free cash flow and DCF valuation Unlevered free cash flow starts with net operating profit after tax, adds depreciation, and subtracts maintenance capital expenditure, shop build-out capex for new shops, and the change in working capital. Working capital reflects parts inventory and insurance receivables, so a portion of revenue growth ties up cash. - The terminal value uses a normalised free cash flow where replacement capex equals depreciation, stripping out growth build-out spending, and working capital is charged only at the perpetuity growth rate. Discounting explicit free cash flows and the terminal value at the WACC gives enterprise value, then net debt is deducted for equity value and value per share. - The model discloses the implied terminal EV/EBITDA and the terminal value share of enterprise value, so you can judge how much of the valuation depends on perpetuity assumptions. Calculation summary: ```text // Unlevered free cash flow = NOPAT + Depreciation - Maintenance_Capex - Shop_Build_Out_Capex - Change_In_Working_Capital // Enterprise value (PV denotes present value) = PV(Forecast_Cash_Flows) + PV(Terminal_Value) // Equity value = Enterprise_Value - Net_Debt ``` ## Service mix drives the ticket and margin Revenue is the product of a shop estate, the repair orders it fills, and the service mix of those orders. The model makes shop count, orders per shop, a utilisation ramp, and a four-tier service mix explicit, so total repair orders and revenue per order are transparent operating metrics an analyst can flex against the cost stack rather than a top-down growth rate. ## Designed for one-edit responsiveness Every input, the shop pipeline, orders per shop, the utilisation ramp, the service mix, the average order, the full cost stack, capex, working capital, and the WACC, is a named-range cell. Edit one and the operations build, revenue, P&L, free-cash-flow bridge, valuation, and dashboard all recompute. No formula rewrites are needed to test a pricing, mix, or expansion scenario. ## An unlevered DCF, not an EBITDA shortcut A repair chain builds out and equips each shop with capital-intensive lifts and diagnostic gear, so the model bridges to unlevered free cash flow and discounts it at a WACC with a Gordon-growth terminal value. Enterprise value bridges through net debt to equity value and a per-share figure, and the implied EV/EBITDA falls out as a sanity check against where auto-services platforms change hands. ## Workbook structure ### Cover Workbook overview, sheet legend, units, and tab-colour key. - Title and scope framing - Sheet-by-sheet purpose summary - Units and tab-colour legend ### Assumptions Every driver in one sheet: shops, utilisation, service mix, costs, capital, valuation. - Year-1 shops, new shops per year, repair orders per shop, technicians per shop, average repair order - Utilisation with an annual ramp and a practical ceiling - Service-tier shares, price indices and net margins, plan and retail inputs, price escalation - Technician and advisor comp and wage, the percent-of-gross-profit overhead lines, depreciation, tax - Maintenance capex, build-out cost per shop, NWC, base-year revenue - WACC, terminal growth, net debt, shares ### Operations Shops, repair orders, utilisation, and staff. - Opening plus new shops equals closing shops - Utilisation ramps from a Year-1 input, capped at a ceiling - Orders per shop equal mature orders times utilisation - Total repair orders equal closing shops times orders per shop - Technician and advisor headcount equal closing shops times per-shop FTE - Orders per technician as a productivity metric ### Revenue Revenue by service tier and ancillary. - Each tier equals total repair orders times service share times average order times price index times escalation - Repair revenue subtotal - Service plans equal closing shops times members times annual fee - Tire and accessory retail equals total repair orders times retail spend per order - Total revenue ### P&L Revenue to net income. - Revenue from the Revenue sheet - Parts and sublet cost as the inverse of the per-tier net margin - Gross profit and gross margin - Technician and advisor labour by headcount, the percent-of-gross-profit overhead stack - EBITDA, depreciation, EBIT, tax on positive EBIT, net income, margins, identity check ### FCF Unlevered free cash flow bridge. - EBIT and unlevered tax from the P&L - NOPAT equals EBIT less unlevered tax - Add back depreciation - Maintenance capex on revenue and build-out capex on new shops - Change in net working capital on revenue growth - Unlevered free cash flow - Discount factor and PV of UFCF ### Valuation Discounted cash flow. - Sum of PV of explicit UFCF - Gordon-growth terminal value and its PV - Enterprise value - Less net debt to equity value - Shares outstanding and value per share - Implied EV/EBITDA ### Dashboard Headline metrics and revenue mix. - Shops, repair orders, utilisation, revenue per shop and per order - Revenue and EBITDA - EBITDA margin - Enterprise value and value per share - Revenue mix across repair, service plans, and retail ## Features - **Service mix drives the ticket and margin:** Revenue is the product of a shop estate, the repair orders it fills, and the service mix of those orders. The model makes shop count, orders per shop, a utilisation ramp, and a four-tier service mix explicit, so total repair orders and revenue per order are transparent operating metrics rather than a top-down growth rate, and the high-ticket collision-versus-diagnostics spread is visible in the blend. - **Labour is the cost, and it is modelled as headcount:** Auto repair is a skilled-labour, people-intensive business, so flat-rate technician and service-advisor pay is the largest operating line and is built bottom-up from FTEs per shop, wage, benefits and wage inflation. Because technician labour sits in operating expense rather than cost of revenue, the gross margin runs high and the EBITDA margin is the meaningful profitability line, and the remaining overhead is geared to gross profit the way a real multi-shop operator would expect. - **An unlevered DCF, not an EBITDA shortcut:** A repair chain builds out and equips each shop with lifts, alignment racks and diagnostic gear, so EBITDA overstates cash. The model bridges EBITDA to cash through NOPAT, depreciation, maintenance and build-out capex, and the change in working capital, then discounts the unlevered free-cash-flow stream at a WACC with a Gordon-growth terminal value to a defensible enterprise and equity value. ## Use cases - **Intrinsic valuation:** Set the shop pipeline, utilisation ramp, service mix, the cost stack, and a WACC, and read the enterprise value, equity value, value per share, and implied EV/EBITDA. Sense-check the multiple against where auto-services platforms change hands. - **Roll-up and pipeline planning:** Flex new shops per year and the build-out cost per shop to see how the de novo and tuck-in pipeline consumes cash and lifts repair-order volume, and watch revenue per shop and the EBITDA margin respond as the group scales. - **Mix and pricing stress test:** Shift the service mix toward higher-ticket collision and mechanical work or compress the per-tier net margins to model parts-cost and menu-pricing pressure, and read the revenue-per-order, gross-margin, EBITDA-margin and valuation impact. ## Frequently asked questions ### What is an auto repair financial model? An auto repair financial model captures the seven-year operating economics and intrinsic value of a multi-shop repair chain that runs maintenance and mechanical repair alongside collision and body work, diagnostics, recurring maintenance service plans and a tire and accessory retail attach. It rolls a shop count forward, converts a bay-utilisation ramp into total repair orders, prices orders across a four-tier service mix at a blended average order and price index, runs the high-gross-margin technician-heavy cost stack to EBITDA, and discounts an unlevered free-cash-flow stream to enterprise value, equity value, and value per share. ### How is auto repair revenue built? Revenue is driven by the shop estate and its utilisation: total repair orders equal closing shops times orders per shop times a bay-utilisation factor that ramps to a ceiling, and repair revenue splits those orders across a maintenance, mechanical, collision and diagnostics mix, each priced at a blended average repair order times a per-tier price index. Shop-driven maintenance service plans and order-driven tire and accessory retail layer on to total revenue. ### Why is the service mix so important? A labour-billed diagnostic visit, a parts-heavy mechanical repair and a high-ticket collision job each carry very different price points and parts economics, so the realised ticket per order and the blended margin both fall out of the mix rather than the raw car count. The model makes the per-tier price indices and net margins explicit so an analyst can flex the mix and pricing and watch revenue per order, gross profit and EBITDA move together. ### Why an unlevered DCF instead of an EBITDA multiple? A repair chain still builds out and equips each shop with capital-intensive lifts and diagnostic gear, so EBITDA overstates cash. The model bridges to unlevered free cash flow, NOPAT plus depreciation, less maintenance and build-out capex, less the change in working capital, and discounts it at a WACC, then adds a Gordon-growth terminal value. The implied EV/EBITDA falls out as a sanity check rather than as the valuation input. ## Related templates - [Car Wash Roll-Up Model](https://finamodel.com/templates/car-wash) - [Car Dealership Model](https://finamodel.com/templates/car-dealership) - [Franchise Unit Economics Model](https://finamodel.com/templates/franchise-model)