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. The longer the cycle period, the bigger the working capital requirements will be. 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 their conversion into cash.

Working Capital Estimation – Operating Cycle Method

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

To calculate the working capital using this method, we would need 3 important things: the estimated cost of goods sold, operating cycle time, and desired cash levels. The time of the 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 form 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 as under. RM and many other calculations are based on estimated production units, and, therefore, they 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, one should especially take care of the percentage of labor and overheads. These may vary depending on the stage of the product and the completion percentage. We have taken the percentage as 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’s 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 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 in the cost of raw materials. 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 based on the actual economic conditions prevailing in the market. It gives a detailed understanding of the business and is precise in comparison 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 estimates 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, which may hurt the whole process. Keeping a cushion while estimating things on the darker side is advisable.

Other Methods for Estimating the Working Capital Requirements

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

Quiz on Working Capital Estimation – Operating Cycle Method

This quiz will help you to take a quick test of what you have read here.




Sanjay Borad

Sanjay Bulaki Borad

MBA-Finance, CMA, CS, Insolvency Professional, B'Com

Sanjay Borad, Founder of eFinanceManagement, is a Management Consultant with 7 years of MNC experience and 11 years in Consultancy. He caters to clients with turnovers from 200 Million to 12,000 Million, including listed entities, and has vast industry experience in over 20 sectors. Additionally, he serves as a visiting faculty for Finance and Costing in MBA Colleges and CA, CMA Coaching Classes.

Leave a Comment