Slow Moving Consumer Goods (SMCG) - Financial Excel Model

Description
In the Excel file you will find a model of a Slow Moving Consumer Goods (SMCG) company. By SMCG firm we mean firms like: smartphone producers, domestic appliance producer, fashion players (to some extent), car manufacturers, furniture producers etc. There are 2 ways in which you can model consumer good businesses. In the first one you model the consumer goods as a sale of a product (traditional approach where you get one-off payment for the product). In the second approach you can model the consumer goods business as a service business (the customer pays annual subscription for the right of using the product). Here we will model the business in the traditional way – as a sales of a product.

We model here production costs (variable and fixed costs), sales costs, gross margin, net margin, Head-office costs and finally the profit and loss statement along with Working Capital statement. We assumed sales via 2 main channels: traditional small stores (via some wholesalers) and retail chains that we sell to directly.

The model you can use for due diligence, checking whether startup idea in the SMCG makes sense, trying to find ways to improve the profitability of the business. You can adjust the model by changing the parameters that are in blue. FMCG business models as all consumer goods related businesses are very demanding in terms of sales and marketing and not the easiest when it comes to supply chain. Consulting projects especially when it comes to Slow Moving Consumer Goods (SMCG) are pretty difficult in terms of analyses.