FMCG (Fast Moving Customer Goods) Business Model in Excel - Management Consulting

Financial model for a FMCG business in Excel that can be used during consulting projects - eg: due diligence

by Asen Gyczew
Expert in performance improvement and restructuring with significant experienceFollow 348

52 reviews4,246 views|Start the discussion!|Bookmark download for free

Description
In this Excel file you will find an Excel Financial Business model of a FMCG company.

Modeled in this file are: production costs (variable and fixed costs), sales costs, gross margin, net margin, Head-office costs and finally the profit and loss statement, along with the 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 be used in a due diligence context to check whether a startup idea in the FMCG sector makes sense and/or to try to find ways to improve the profitability of the business.

You can adjust the model by changing the parameters that are highlighted in blue. FMCG (Fast Moving Consumer Goods) business models, as all consumer goods related businesses, are very demanding in terms of sales & marketing and are not the easiest to manage when it comes to the supply chain.

Consulting projects, especially when it comes to Fast Moving Consumer Goods (FMCG), are pretty difficult in terms of analysis.

To accompany the model I have also prepared a short presentation covering the most important aspect of the FMCG business model. You will find there some tips on how to work on the sales and marketing as well as supply chain issues in FMCG businesses.

Below a link to the presentation
https://www.slideshare.net/AsenGyczew/fmcg-for-management-consultants-and-business-analysts
This presentation should help you understand and modify the model

If you have any questions, you're welcome to reach out to me via Private message here: https://www.eloquens.com/channel/asen-gyczew

This Best Practice includes
1 Excel Model Template