Working Capital Estimation – Operating Cycle Method

What does Operating Cycle Method do?

Operating cycle method for estimating working capital is based on the duration of the operating cycle. Longer the period of the cycle, bigger will be the working capital requirements. Operating cycle means the cycle of raw material to work in progress to finished goods to accounts payable and finally to cash. Operating cycle time is the time taken starting from raw material purchases to its conversion into cash.

How to Calculate or Estimate Working Capital Requirement using Operating Cycle Method?

For calculating the working capital using this method, we would need 3 important things and they are the estimated cost of goods sold, operating cycle time, and desired cash levels. The time of cycle can be calculated using the operating cycle formula.

Formula

Working Capital = {Estimated Cost of Goods Sold * (Operating Cycle/ 365)} +Desired Cash and Bank Balance

Calculating the total working capital will not suffice the purpose. How this working capital is formed is also important. It means each component of working capital will have to be known. For that, we would first need to review the activity level of the company. Let us see how to calculate each item of working capital below:

Raw Material (RM) Stock

The formula for determining the RM stock is mentioned below. RM and many other calculations are based on estimated production units and therefore it should be calculated with utmost accuracy.

Estimated Production Units * Per Unit Cost of RM * (RM Holding Period / 365 Days)

Work In Progress (WIP)

In calculating the WIP, special care has to be taken of the percentage of labor and overheads. These may vary depending on the stage of the product and completion percentage. We have taken the percentage for an example.

Estimated Production * {Per Unit Cost of — RM (100%) + Labor (50%) + Overheads (50%)} * (Work In Progress Period / 365 Days)

Finished Goods Stock

In Finished Goods workings, we have to know the cost of production with the help of the previous year cost sheets or budgeted cost sheets of the company’s products.

Estimated Production * Per Unit Cost of Goods Produced * (Finished Goods Holding Period / 365 Days)

Accounts Receivables

This calculation is simple and we just need to put the estimates and average collection period right.

Estimated Production * Selling Price * (Collection Period / 365 Days)

Accounts Payables

The calculation of accounts payable is similar but the major difference is of raw material cost. We take finished goods selling price in accounts receivable calculation whereas raw material cost in case of accounts payable.

Estimated Production * Per Unit RM Cost * (Payment Period / 365 Days)

Advantages and Disadvantages of Operating Cycle Method of Working Capital Calculations / Estimations

The advantage is that it is a detailed method and based on the actual economic conditions prevailing in the market. It gives a detailed understanding of the business as well and it is precise compared to other methods. The disadvantage is that it is a lengthy process to arrive at a component-wise calculation of working capital. It needs a lot of estimate like estimated production, holding period of inventory, collection and payment period, etc. So, it is a risky matter. There are probable chances of going wrong in estimating these data and that may hurt the whole process. It is advisable to keep a cushion while estimating things on the darker side.

Other Methods for Estimating the Working Capital Requirements

There are other methods of estimating the requirements of working capital also. You may refer the other ones as mentioned below and select the one that suits your requirements.

Percentage of Sales Method

Regression Analysis Method

Last updated on : August 17th, 2018

** Disclaimer: This post may contain Affiliate Links marked as ** and we may earn a commission on sale.

What’s your view on this? Share it in comments below.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.