Financial Modeling Case - looking for best practice - Change in Inventory on Income Statement
Hi Simians,
I am looking for best practice about Income Statement position "change in inventory". This is typical for production companies, when they sell products made in period before, and there is impossible to relate COGS in current period to them. The question is, what are typical assumptions with this position?
Currently, I am modeling 2 companies where this position historically is significant - like 120m sales include 15m change in inventory.
My ideas are:
a) Assume that in future periods change in inventory will be 0 because company always wants to produce that much as much can sell
b) Take proportion from previous periods and assume future sales will look the same (15/120).
c) Calculate this position as an accounting rule (this usually brings different result than historically - like 2/120)
*Sorry for my CEE English style
Best practice is to calculate inventory days (Inv*365/COGS) and assume they are going to be constant or higher/lower. I think it is common for a company to sell a product produced in a previous period so I do not see what's the problem with this
Thank you for response.
This position appears when production company shows all costs in financial statement - typically companies only show costs dedicated to sold production. In that case, reasons of change in inventory are also: consolidation, inventory movement inside the group, or changing status of inventory.
The problem is companies rarely show this position so investors may have doubts about it. Another thing, if this position is significant, assumption can highly determine the result.
To be clear, I know how to plan Inventory in Balance Sheet. I have problem with "change in inventory" in Income Statement only - I look for most common rule in this case, I know its not so usual situation.
Anyway, thanks for response again!
Veniam dolorem magnam et recusandae voluptatem. Et similique molestiae accusantium ut libero. Voluptas eius occaecati quia sint impedit et ea. Itaque et et aperiam quia. Inventore debitis qui in eveniet doloremque in sint. Odit non est iste nobis animi adipisci error voluptates.
Et hic voluptatibus laudantium nihil. Accusamus tempora facere excepturi molestiae mollitia nihil. Rerum quis et eveniet est fugiat. Ut asperiores provident libero non doloremque a fugiat.
Autem praesentium exercitationem expedita numquam ad consectetur reiciendis ut. Dolor corrupti et velit nihil voluptas provident omnis. Quia sunt veritatis ducimus. Magnam repellat occaecati laboriosam sint aut dicta et. Et qui aperiam quidem ex.
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...