Working Capital Estimation – Operating Cycle Method

Operating cycle method of working capital estimation is based on the duration of 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 using this method?

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

Formula for calculating working capital requirement directly is as follows

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 the activity level of the company under review. 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

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

Percentage of Sales Method

Regression Analysis Method

Last updated on : August 1st, 2017
What’s your view on this? Share it in comments below.

Leave a Reply

Free Cash Flow
  • Techniques of Managing Accounts Payable / Trade Credit
    Techniques of Managing Accounts Payable / Trade …
  • Working Capital Management - Maturity Matching or Hedging Approach to Working Capital Financing Graph
    Maturity Matching or Hedging Approach to Working …
  • Advantages and Disadvantages of Invoice Discounting
    Advantages and Disadvantages of Invoice Discounting
  • Objectives of Working Capital Management
    Objectives of Working Capital Management
  • Subscribe to Blog via Email

    Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 122 other subscribers

    Recent Posts

    Find us on Facebook

    Related pages

    difference between overdraft and cash credithow to assess credit worthiness of a companyworking capital management decisions involvepayback period problems and solutionsbookkeeping double entrydrawbacks of profit maximizationshareholders fund formulairr meansdiscounting of billspayables turnover formulashares and debentures meaningzero dividend payout policydefine irrelevancenpv irr paybackstable dividend policy definitionreturn on capital employed exampleturnover ratio equationconstant payout ratioindenture of mortgage meaningreceivables turnover days formulaincome maximizationleverage meaning in hindiasset impairment testmerger disadvantagesbudgeting defddm model excelformula dcfaccounting ebitgdr meaningadvantages of flexible budgetsexamples of contingent liabilitydefine hedging financesimple mortgage and equitable mortgagewhat is secured debentureirr formula by handmodigliani and miller modeldifference between shareholders and stakeholdersthe quick ratio excludes which of the followingforeign exchange exposure and risk managementpurchase to sales ratiohow to calculate payback period in yearsdepreciation and amortization formulasimple payback period calculatorfind waccbudgeting techniquewhat does debenture mean in financeinternal rate of return irr calculatorredeemable shares meaningpacking creditdeepdiscount coupondefinition of overdraft facilityproject selection under capital rationingredemption of debenturedebt to equity calculatorwhat is operating leveragestockholders are residual claimants meaning that theyfactoring expensecalculating breakevenmodigliani miller propositionshareholder value maximizationr&d expense on income statementdifference between mortgage and debenturedebenture loanstakeover defense mergers and acquisitionswacc by industryformula for calculating yield to maturityasset utilization ratio formulameaning of debit and credit in accounting termssample of debit and credit entryeoq analysis in inventory managementcalculate ebitworking capital financing pptvertical merger companies examplesconstant growth stock valuation