Grocery Store Chain Model

The chain grows via a fixed number of new stores each year: opening stores plus new additions equal closing stores. Closing stores determine headcount, transaction volume and per-store crew, while the year's new stores drive build-out capex through a per-store investment.

• Each store supports a mature transaction count based on trade area, format and checkout throughput. A utilisation ramp—starting at a Year 1 input and increasing annually up to a ceiling—converts that mature volume into effective transactions per store.
• Multiplying by closing stores gives total transactions, the model's central volume driver. This structure captures the real-world lag as new stores build a regular shopper base and no site runs at theoretical peak.

Product revenue is assembled department by department: total transactions times the average basket times each department's share of that basket, then escalated by the shelf-price step-up. Because department shares sum to one, total product revenue equals transactions times average basket—the mix only affects margin blend, not basket size.

• Cost of goods for each department is its revenue times one minus that department's gross margin. Center-store carries a razor-thin packaged spread, fresh carries the richest margin, and dairy & frozen and non-food fall in between.
• Shrinkage and waste—spoilage, damage and theft as a percentage of revenue—is charged on top of product cost before gross profit. Membership and loyalty income (closing stores times members per store times annual fee) and online delivery fees (transactions times fee per transaction) add to total revenue and are high-contribution lines.

Store-leader and associate labour are headcount-driven: FTEs per store times wage, loaded for benefits and escalated at the wage-growth rate. This is the dominant cost—grocery is people-intensive and shift-driven—so store labour sits in operating expense rather than cost of goods.

• The remaining overhead—occupancy and rent, marketing and advertising, utilities and refrigeration, and corporate SG&A—is set as a percentage of gross profit, not revenue, because the true operating scale of a thin-margin grocer is gross profit. This percentage-of-gross-profit approach avoids overstating costs against a razor-thin top line.
• As the utilisation ramp and price escalation lift gross profit while per-store labour grows only with headcount and wage inflation, the EBITDA margin expands modestly over the forecast horizon.

Unlevered free cash flow is NOPAT plus depreciation, less total capex (maintenance plus de novo build-out of the year's new stores), less the change in working capital.

• Working capital is a light call on cash: grocery sells inventory for cash at the register and turns it many times a year while buying on trade terms, so only a small fraction of revenue growth ties up in net working capital.
• The DCF sums the present value of explicit unlevered free cash flows and the present value of a Gordon-growth terminal value to reach enterprise value, then subtracts net debt to get equity value and value per share. The WACC reflects the defensive, staple character of grocery demand, and the implied EV/EBITDA multiple sits in a defensible range for a growing supermarket chain.