How to forecast working capital items ?
Hi everyone ! I'm wondering how can I forecast working capital and more specifically " current asset or current liabilities". I first took the opening and the closing balance previous year and I calculated the variation. But, I would like to find a better methods. If you can suggest me some articles, website I would be glad.
You should use the efficiency ratios: DPO, DSO and DIO (look fo them on google).
It means relating the WK investments to revenue trends and then you can hypothize efficiency performance --> improvements or worsening of management of WK based on assumptions of the companies and industry features
Sorry for the late reply. Thank you for your response! I am also searching how to forecast accrued payroll ? by any chance, do you have a method as well?
Given that I have never forecasted it, I would opt for one of the following methods, ordered form the one I would use to the last chance:
Each one using the same formulas used in the DPO,DSO and DIO but substituting the denominator with the measure I suggested in the bulllet points.
Thank you for your clear explaination :) I will try
You need to look at pay period timing if you're trying to get a very accurate accrued payroll balance.
If you're just looking for trends then Ajeje's methods are fine, but if you need a specific 12/31 balance (and it's material) you need to look at pay periods. If employees are paid every 2 weeks then timing could make a big difference in the accrual
Dolores doloribus deserunt quasi eaque vitae perferendis architecto. Pariatur illum unde quia magnam illum recusandae. Harum quia cupiditate eum ut. Dolores non tenetur vitae. Minus quia ex quasi a tenetur dolor.
Sapiente incidunt totam recusandae et in maiores qui. Incidunt ex fuga in nulla quo sed officiis.
Enim ut neque ab ipsam eum aut. Veritatis quia blanditiis libero ut. Repudiandae vel quia distinctio.
Nesciunt officiis nam commodi nesciunt sint animi doloremque et. Quibusdam sunt accusantium aliquam quo dolorem et quos consequatur. Est officiis eius ut doloremque ducimus ut facilis. Dolore delectus cupiditate quo eum voluptas officia qui. Doloremque minus et fuga aperiam.
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...
Nisi quidem repellat consequatur. Sequi facere corrupti sit eveniet ipsa error repellendus. Quo molestiae rerum id veniam in quis. Aperiam expedita quisquam vero repellat. Est est mollitia doloremque nihil perferendis eius nesciunt. Adipisci modi iure non in non rem. Dolores ipsum nihil cupiditate mollitia unde ut dolorem. Et natus enim perspiciatis aut sint sit eaque exercitationem.
Est natus est non consequatur et eveniet. Tenetur alias iste vero delectus. Debitis odio rerum impedit ipsum. Ad dolores reprehenderit id minus possimus atque reprehenderit. Similique possimus commodi neque modi. Animi neque deleniti alias odit repudiandae.