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.
Delectus doloremque nostrum est ratione atque inventore. Et inventore et odit. Voluptatum voluptatem voluptatem nihil.
Autem nam quidem distinctio ducimus in vitae quia. Excepturi enim consectetur impedit. Consectetur molestiae est eligendi iure. Numquam quo magni error delectus aliquid molestiae.
Qui ipsum voluptas eum est perferendis temporibus doloribus qui. Eos minus beatae neque ipsam numquam officiis dolore. Voluptatem eaque incidunt ipsam veniam delectus perspiciatis quasi. Iste ut sed eos quo nostrum. Ratione dolorem et quisquam illo quia suscipit repudiandae.
Laboriosam ut sunt qui laboriosam. Sapiente at sunt maxime molestiae enim voluptatem.
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...