ValuePickr Forum

Business Simulator for FMCG-type models

Hello,

I tried creating a simple business simulator (especially for established FMCGs), wherein one can input various ratios and observe the changes across the Cash Flow and Balance Sheet.

Please note that the fields in green can be edited.

Assumptions:

  1. No net working capital required
  2. No debt required
  3. A simplified depreciation cost based on previous year’s Net Assets.
  4. Constant rate of capex
  5. Constant margins
  6. CFO also includes interest earned on cash assets

Do have a look and suggest corrections/improvements

Business simulator.xlsx (8.7 KB)

2 Likes