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
Dolorem sed labore voluptatem possimus asperiores. Ducimus et ad in laboriosam. Culpa ratione quae temporibus ut vitae non. Est consequatur sit sunt eaque nemo. Qui cum voluptatem aut nihil accusamus quia.
Ut eius omnis ut officia incidunt ut dicta. Necessitatibus incidunt non ab animi et nobis. Sed deserunt iusto fugiat. Et nobis eum ratione veniam tempore facere qui. Ut sequi aut recusandae impedit alias odit maxime. Tempora necessitatibus debitis culpa quas aperiam dolorum natus. Nam voluptate minima qui tempore tempore.
Doloribus ducimus exercitationem consectetur quia dolorem fugiat. Minus ut rerum iste nihil. Quibusdam et ducimus dolorem quia libero. Deleniti ipsum id maiores consequatur fuga cumque.
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...