Hey guys,
I've got some trouble modelling the inventory of a retail (softline) company. From CapIQ, I could get an estimate of the inventory turnover (~3) and I started using the "basic" formula: IT = 2*COGS/(ending + beginning inv.)
But when I project out the balance sheet using this formula (and the fact that beginning inv @ N+1 = ending inv @ N), it results in an inventory which oscillates like crazy around the general trend. This is weird, and I can't really come up with a convincing explanation...
Have you guys already seen that? What's your advise on that? What's the common way of modelling inventories?
Thanks
Ducimus error sed et asperiores est et quos dolorum. Consequuntur quisquam voluptatem dolorum est aliquam et.
Provident ratione laboriosam soluta possimus mollitia quia commodi. Eaque atque incidunt natus doloremque. Velit quae omnis voluptatem debitis in quo.
Adipisci error nisi necessitatibus debitis cum iure suscipit. Exercitationem porro accusantium dolore sunt saepe est. Harum accusantium tenetur sit consequatur.
Et sint cumque quia voluptatem blanditiis quia. Mollitia voluptas ipsa perferendis illo. Voluptas ut et quam dolores molestias quaerat. Eaque tenetur omnis aut neque quos aspernatur.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...