Bookstore Group Model

The model starts with a simple store roll-forward: opening stores plus new stores equals closing stores. Each year, the group adds a fixed number of new locations, and that growth feeds directly into transaction volume and per-store staffing.

• A newly opened store does not immediately operate at full capacity. The model applies a utilisation factor that ramps from a year-one input toward a practical ceiling, reflecting the two to three years it can take for a store to build a local following and event calendar.
• Mature transactions per store, set by footprint, footfall, and conversion, are multiplied by this utilisation share to give effective transactions per store. Closing stores times effective transactions yields total transactions, the single volume driver that everything else—revenue, labour, and working capital—keys off.

Revenue is constructed line by line across four product tiers: new books and bestsellers, used and bargain books, gifts and stationery, and children’s and educational. Each tier’s revenue equals total transactions times its mix share times the average basket, adjusted by a per-tier price index and escalated over time.

• Because the basket is blended through these shares, the realised revenue per transaction emerges from the mix rather than the raw transaction count. A shift toward sidelines or bargain stock changes the realised basket even if footfall is flat.
• Two additional lines layer on: store-driven café and events, based on closing stores, and transaction-driven online and special orders, based on total transactions. Together these build total revenue and show how product mix influences both sales and gross margin.

The model then nets cost of goods for each revenue line, calculated as line revenue times one minus that line’s gross margin. New books carry publisher-set terms that cap margins near forty percent, while used stock, gifts, and stationery earn keystone margins, lifting the blend.

• Café and events carry a food-and-beverage cost. The resulting gross profit is around forty-eight percent, but the model treats store-manager and bookseller labour as an operating expense rather than cost of goods.
• That labour is headcount-driven and loaded for benefits and wage growth. Other overheads—occupancy and rent, marketing and community, technology and POS, and corporate SG&A—are set as a percentage of gross profit.

EBITDA therefore becomes the meaningful profitability line, expanding modestly as utilisation and price escalation lift gross profit while labour grows only with headcount and wage inflation.

The free cash flow bridge starts with EBIT, applies unlevered tax to get NOPAT, adds back depreciation, and then subtracts two major cash calls: maintenance capex and store build-out capex for new locations. It also deducts the change in working capital, which is a real charge because a bookstore ties up a meaningful fraction of revenue growth in shelf inventory net of trade payables.

• The resulting unlevered free cash flow is discounted at the WACC to present value. The DCF valuation sums explicit-period present values plus a Gordon-growth terminal value to reach enterprise value, then subtracts net debt for equity value and value per share.
• The model also reports implied EV/EBITDA. A dashboard summarises stores, transactions, utilisation, revenue per store, revenue per transaction, total revenue, EBITDA, EBITDA margin, enterprise value, and value per share.