# Retail Store Model Model a retail-store chain from new locations and customer traffic through to sales, inventory, profit, and valuation. - Canonical: https://finamodel.com/templates/retail-store - Excel download: https://finamodel.com/templates/retail-store.xlsx - Category: Operating Businesses - Model type: Operating model - Difficulty: Intermediate - Audiences: Investors & analysts, Founders & operators, Multi-unit retail operators, Retail PE and platform buyers, Franchise and rollout planners, Lenders and analysts - Tags: retail-store, multi-location-retail, same-store-sales, unit-economics, dcf ## Overview This retail-store model helps operators and investors understand what really drives a growing chain: store openings, customer traffic, conversion, basket size, product mix, and inventory. It works for specialty, convenience, and other small-format retail businesses. Use it to plan a rollout, review store performance, or evaluate an acquisition. You can test the impact of same-store sales, gross margin, shrinkage, and working capital on cash flow and value. ## What's included - Store & traffic inputs: Year-1 stores, new stores and closures per year, traffic per store, conversion rate, selling area per store - Basket & same-store sales: Year-1 average basket, same-store-sales growth, ancillary revenue per store - Category mix & margins: core-goods, accessories and consumables shares and gross margins, shrinkage, days inventory, days payable - Cost structure: staff per store and wage with benefits and wage growth; occupancy, other store opex, marketing and corporate SG&A as % of sales; depreciation; tax - Capital & working capital: maintenance capex %, build-out cost per store, base-year COGS - Valuation: WACC, terminal growth, net debt, shares outstanding - Operations sheet: store roll-forward, average-store base, transactions per store and total, store staff, selling area and sales per sq ft - Revenue sheet: same-store-sales index, average basket, three-category merchandise revenue, ancillary & services, total revenue - P&L sheet: revenue to net income with category COGS and shrinkage, store labour, store opex stack, store EBITDA, corporate SG&A, consolidated EBITDA, margins, identity check - FCF sheet: NOPAT, depreciation add-back, maintenance and store build-out capex, inventory-driven change in NWC, inventory turns, unlevered FCF, discount factor, PV - Valuation sheet: sum of PV, terminal value, enterprise value, equity value, value per share, implied EV/EBITDA - Dashboard with stores, transactions, same-store-sales growth, revenue per store, gross margin, EBITDA margin, inventory turns, enterprise value and a revenue-to-net-income waterfall ## Retail Store Financial Model: How the Template Captures Store Rollout and Same-Store Sales This retail store financial model projects a multi-location specialty or convenience chain over seven years. It separates same-store sales growth from new-store contribution, builds revenue from footfall and basket size, and runs a full store P&L through to unlevered free cash flow and DCF value. The public download is a values-only preview. ### Operating Drivers: Store Rollout and Customer Economics The model's operating engine centers on a store roll-forward—opening stores plus new openings minus closures equals closing stores—and a footfall-to-basket build. - Traffic per store multiplied by conversion yields transactions per store, which when multiplied by average stores gives total transactions. - Average stores, calculated as the simple average of opening and closing counts, applies a part-year weighting so a store opened mid-year contributes roughly half a year of sales. - The model also builds store staff from closing stores times FTEs per store, along with selling area and sales per square foot. ### Revenue and Margin Calculation Flow Revenue is assembled in two layers. Same-store-sales growth compounds into an index that lifts the average basket year over year, while traffic per store is held at its mature level. - Total transactions times that basket splits across a core-goods, accessories, and consumables category mix, each with its own gross margin. An ancillary services line, driven by average stores, layers on top. - Cost of goods reflects each category's revenue times one minus its margin, plus shrinkage as a percentage of merchandise sales. The resulting gross profit then runs through headcount-driven store labour and sales-geared occupancy, other store opex, and marketing to store EBITDA, before corporate SG&A reaches consolidated EBITDA. ### Cash Flow, Working Capital, and Valuation Outputs The free-cash-flow bridge starts with EBIT and unlevered tax to reach NOPAT, adds back depreciation, and subtracts maintenance capex, new-store build-out capex, and the change in net working capital. Working capital is inventory—COGS times days inventory outstanding divided by 365—less trade payables, calculated as COGS times days payable outstanding divided by 365. - Because retail collects at the till, receivables are immaterial. The change in net working capital is seeded from a base-year COGS. - The DCF then discounts explicit unlevered free cash flows and a Gordon-growth terminal value to enterprise value, subtracts net debt for equity value, and derives value per share. ### Practical Use: Scenario Testing and Performance Monitoring An analyst can flex the same-store-sales lever and the store rollout lever independently to see how revenue, gross profit, EBITDA, and enterprise value respond. - The category mix and shrinkage assumptions allow testing of margin expansion or drag, while days inventory and days payable reveal how much COGS growth ties up as net working capital. - The model outputs a one-page dashboard with stores, transactions, same-store-sales growth, revenue per store, gross margin, EBITDA margin, inventory turns, enterprise value, and a revenue-to-net-income bridge. - This structure supports planning a rollout, reviewing store performance, or evaluating an acquisition within the documented multi-location small-format retail scope. ## Comps and units are separate levers Comp growth lives in the basket - a same-store-sales index compounds the average basket while traffic per store holds at its mature level - and new-store growth lives in the store count, expanding an average-store base that gives mid-year openings a part-year weighting. Total revenue is average stores times transactions per store times average basket, so an analyst can flex the rollout and the comp lever independently and watch each flow through to revenue, gross profit and EBITDA. ## Retail inventory economics, modelled properly Three category tiers each carry their own gross margin, a shrinkage charge captures theft, damage and mis-count, and days inventory outstanding less days payable outstanding size how much of COGS growth ties up as net working capital - the classic retail cash drag a services-only model misses. Inventory turns falls out as the most-watched efficiency metric, and four-wall store EBITDA is split from consolidated EBITDA so store economics and corporate leverage read separately. ## An unlevered DCF, not an EBITDA shortcut The free-cash-flow bridge charges maintenance capex, new-store build-out capex and the inventory-driven change in net working capital, then discounts the stream at a WACC reflecting the steady, footfall-driven character of convenience and specialty retail. 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 small-format retail operators trade. ## 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: stores, traffic, basket, mix, costs, capital, valuation. - Year-1 stores, new stores and closures, traffic per store, conversion, selling area - Year-1 average basket, same-store-sales growth, ancillary per store - Category shares and gross margins, shrinkage, days inventory, days payable - Store labour, the percent-of-sales occupancy, opex, marketing and SG&A lines, depreciation, tax - Maintenance capex, build-out cost per store, base-year COGS - WACC, terminal growth, net debt, shares ### Operations Store roll-forward and transaction volume. - Opening plus new less closures equals closing stores - Average stores as the store-year base for part-year weighting - Traffic per store times conversion equals transactions per store - Average stores times transactions per store equals total transactions - Store staff, selling area and sales per square foot ### Revenue Same-store sales, basket and category revenue. - Same-store-sales index compounded year on year - Average basket equals Year-1 basket times the index - Category revenue equals total transactions times basket times each category share - Merchandise subtotal and a store-driven ancillary & services line - Total revenue ### P&L Revenue to net income. - Category cost of goods and shrinkage to total COGS - Gross profit and gross margin - Store labour and the percent-of-sales occupancy, opex and marketing stack to store EBITDA - Corporate SG&A to consolidated EBITDA - Depreciation, EBIT, tax on positive EBIT, net income, margins, identity check ### FCF Unlevered free cash flow bridge. - EBIT and unlevered tax to NOPAT - Add back depreciation - Maintenance capex on revenue and store build-out capex on new stores - Inventory equals COGS times DIO / 365, payables equals COGS times DPO / 365, net working capital and inventory turns - Change in net working capital charged - Unlevered free cash flow, discount factor and PV ### 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-to-net-income bridge. - Stores, transactions and same-store-sales growth - Revenue per store, gross margin and EBITDA margin - Inventory turns - Enterprise value - A Revenue to Net Income waterfall ## Features - **Comp growth is separate from new-store growth:** A same-store-sales index compounds the average basket while traffic per store holds at its mature level, and the store-count roll-forward drives unit growth off an average-store base - so an analyst can flex the comp lever and the rollout lever independently and watch each flow through to revenue, gross profit and EBITDA. - **Real retail inventory economics:** Category gross margins plus a shrinkage charge set the blended gross margin, and days inventory outstanding less days payable outstanding size how much of COGS growth ties up as net working capital - the classic retail cash drag a services-only model misses, with inventory turns surfaced as the headline efficiency metric. - **Four-wall vs consolidated EBITDA:** Gross profit less store labour, occupancy, other store opex and marketing gives store EBITDA - the four-wall profit an operator watches per site - before corporate SG&A is charged to consolidated EBITDA, so store-level economics and corporate operating leverage are visible separately. - **Part-year weighting on new stores:** Revenue is driven off average stores, the mean of opening and closing counts, so a store opened during the year contributes roughly half a year of sales - the standard store-year convention that stops new-store revenue being overstated in its opening year. - **One-edit responsiveness:** Every driver is a named-range cell - flex the rollout pace, comp growth, conversion, the category mix and margins, or days inventory and the operations build, revenue, P&L, cash-flow bridge, valuation and dashboard all recompute. ## Use cases - **Store rollout planning:** Test how many stores to open per year net of closures, the build-out capex it consumes and the inventory it ties up, and read the effect on revenue per store, consolidated EBITDA and enterprise value. - **Comp-driven scenario work:** Hold the rollout flat and stress same-store-sales growth, conversion and the average basket to size how much of the plan rides on comps versus new units. - **Retail PE underwriting:** Underwrite a small-format retail platform: flex the category mix and margins, charge the inventory working-capital drag, and read enterprise value and implied EV/EBITDA against where retail operators trade. - **Board and lender reporting:** Hand the dashboard to the board or a lender as a one-page view of stores, comps, revenue per store, gross margin, EBITDA margin, inventory turns and valuation. ## Frequently asked questions ### What is a retail store financial model? A retail store financial model captures the seven-year operating economics and intrinsic value of a multi-location, small-format specialty or convenience retail chain - the store-operator (tenant) side of physical retail. It rolls a store count forward net of closures, converts footfall to transactions, lifts the average basket through a same-store-sales index that compounds independently of unit growth, splits merchandise across three category margins with a shrinkage charge, runs a store P&L to four-wall and consolidated EBITDA, and discounts an unlevered free-cash-flow stream to enterprise value, equity value and value per share. ### How does it separate same-store sales from new-store growth? Comp growth lives in the basket: a same-store-sales index of one plus comp growth, compounded, lifts the average basket while traffic per store stays at its mature level. New-store growth lives in the store count, which expands the average-store base. Because total revenue is average stores times transactions per store times average basket, the two levers multiply cleanly and can be flexed independently - hold the rollout flat and comps still lift revenue; hold comps at zero and the rollout still lifts revenue through more store-years. ### How is inventory and working capital handled? Inventory is COGS times days inventory over 365, trade payables are COGS times days payable over 365, and net working capital is inventory less payables (retail collects at the till, so receivables are immaterial). The FCF bridge charges the change in net working capital seeded off a base-year COGS, so as COGS grows with the rollout and comps a slice ties up in inventory net of supplier terms - the classic retail cash drag - with inventory turns surfaced as the headline efficiency metric. ### Why an unlevered DCF instead of an EBITDA multiple? The model bridges to unlevered free cash flow - NOPAT plus depreciation, less maintenance and store build-out capex, less the change in inventory-driven working capital - and discounts it at a WACC reflecting the steady, footfall-driven character of convenience and specialty retail, then adds a Gordon-growth terminal value. Enterprise value bridges through net debt to equity value and value per share, and the implied EV/EBITDA falls out as a sanity check rather than as the valuation input. ## Related templates - [E-Commerce Unit Economics](https://finamodel.com/templates/ecommerce-forecast-model) - [Franchise Unit Economics Model](https://finamodel.com/templates/franchise-model) - [Subscription Box Economics](https://finamodel.com/templates/subscription-box-model)