How do demand, channel, pricing, and inventory assumptions shape the retail plan?
Model profile
Clothing Store
Omnichannel clothing retailer: walk-in stores and an online store on one inventory pool and one customer base, with returns, click-and-collect, markdown, retail merchandising maths, channel contribution, financing and valuation.
Decision scope
Questions this model helps you examine
What working capital, store rollout, and financing structure does the business require?
How do demand, cost, and financing downside cases affect cash flow and investment returns?
Model capabilities
What this model includes
The profile below is generated from the same catalogue and workspace definitions used by the application.
- Returns modelled per channel and per category, with reverse logistics and unsaleable write-offs
- Store trading built from footfall, conversion, basket size and selling area
- Individual stores with their own opening month, ramp, rent and price index
- Online demand from a customer base that is acquired, churns and repeats
- Acquisition cost, lifetime value and the ratio between them, computed not asserted
- Buy-online-pick-up-in-store with its attach basket and avoided delivery cost
- Ship-from-store routing and its cost premium
- Markdown share and depth priced into realised revenue
- Sell-through, weeks of supply, GMROI, inventory turns and shrinkage
- Purchases driven by a forward cover target rather than assumed
- Channel contribution for stores and online, down to direct cost
- Sales tax as a real cash timing item, and a borrowing-base working-capital facility
- IFRS-style three statements, cover-ratio covenants, break-even and valuation
- Named scenarios, goal seek, tornado, VaR/CVaR, correlated Monte Carlo, and a new-store decision tree
Build the case
Inputs and workspaces
- AssumptionsOnline customer economics, fulfilment, omnichannel, merchandising, tax and cost of capital
- Product categoriesPrices, costs, markdown, return rates and cover by category
- StoresEach store's opening month, area, footfall, conversion, rent and price index
- Overheads and financingCentral overheads, capital programme, facilities and investors
- AnalyticsNamed scenarios, goal seek, correlated Monte Carlo, and the new-store decision tree
Review the result
Outputs and analysis
- Project NPVUSD
- Project IRRAnnual
- Equity IRRLevered
- Equity multipleMOIC
- PaybackYears
- Gross marginFinal year
- EBITDA marginFinal year
- Return rateAll channels
- 26 additional metrics in the workspace
- Financial statementsDetailed schedules
- Trading, merchandising and valuationDetailed schedules
- Risk and analyticsDetailed schedules
Designed for review
Who this model is for
- Retailers and business owners
- Merchandising and store operations teams
- Financial advisers
- Investors and lenders
Governed evidence
The review trail stays with the result.
Each completed calculation preserves the model version, saved inputs, reporting-currency snapshot, immutable run, and result fingerprint used for its reports.
- Version-controlled calculation logic
- Saved assumptions and scenarios
- Immutable calculation runs
- Reporting context preserved in exports
Ready to explore the case?