Fashion Marketplace (including Second-hand clothes & shoes) – Financial model

Description
In recent years, we have seen the rise of many fashion marketplaces, especially for second-hand products. Apart from Amazon, eBay you also have dedicated solutions like Poshmark, the RealReal, Depop, and many others. In this model, you will see how to model such businesses.
A few information about the model
1. Buyers & Sellers. In sheet Customers, we model the number of customers and sellers that we need to be able to deliver the planned transaction volume and value.
2. Sales & Margin. In the sheet Sales & Margin, we model revenues, gross margin, cost of acquisition, retention, logistics costs. We also show Gross Market / Merchandise Value (GMV) for the whole marketplace
3. Capex. Capex is calculated in sheet Capex, based on the number of customers we have to service. We have2 main types of Capex for Content: Acquisition Capex and Retention Capex. In a separate sheet (Depreciation) we model the Depreciation by cohorts and Net Value of Assets.
4. Head Office costs. These costs are calculated in the sheet HQ.
5. Profit and Loss statement. Based on data from previous sheets in the sheet P&L we generate the Profit and Loss statement.
6. Working Capital. Working Capital is calculated in the sheet Work Cap, based on sales and conversion periods assumed for inventory, receivables, and payables.
7. Debt. We assume that the growth will be partially financed by Debt. In this sheet, we calculate the Debt at the end of the year based on assumed loans that we take and repayment of the loans. We also calculate here the financial costs and profits.
8. Cash Flow. Finally, in the sheet CF, we calculate the cash flow based on data from previous sheets
You can adjust the model to your needs by editing the assumptions. We have put them in blue. Once you change the cells in blue the model will re-calculate the values