Accounting / Forecasting question - Change in inventory forecasting (Circularity)
Hi,
I am trying to forecast change in inventory (as part of an LBO model) for a small company, using inventory days outstanding.
Let's say I have the average inventory days outstanding figure calculated for the past x years and want to use that as a basis of forecast. When doing the forward looking calculation of =-(COGS/365)*Inventory Days, I run into a circular calculation problem.
The COGS for the forward looking years include (among other things) "change in inventory", which in turn I am trying to calculate in the first place by using the above mentioned formula(?).
Am I supposed to just run a circular reference here?
Thanks!
I’m sure you have thought of this but why not forecast COGS as a % or revenue, or simply forecast GP and back into COGS?
If you are determing COGS using the change in inventory I’m not sure there is a way around circularity.
Molestias velit modi distinctio culpa velit quo aspernatur. Sequi at doloribus et magnam. Quibusdam tempora non ex cupiditate. Quam sit ipsum dolor tempore deserunt. Est sint quis occaecati adipisci repudiandae ut.
Et ab possimus accusantium recusandae alias labore dicta. Laudantium vel neque et consequatur nesciunt neque. Sit unde dolore pariatur quisquam asperiores sit.
Deleniti cumque neque debitis. Corporis illum et voluptatem cumque quaerat rerum enim. Rerum ducimus dolorem provident autem. Aut amet voluptatem quasi in omnis velit.
Tempora ut perferendis corporis nemo assumenda. Quo ratione ut incidunt error velit. Facilis consequatur quibusdam quo fugiat velit eos distinctio deserunt.
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...