Working Capital Calculation – Percentage of Sales Method

The percentage of sales method is a working capital forecasting method based on the past relationship between sales and working capital. Like technical analysis in the stock market, it assumes that history will repeat itself, and thus the ratio of working capital to sales will remain constant. In other words, it assumes that the whole business will move in tandem with sales.

How to Calculate Working Capital Using Percentage of Sales Method?

The percentage of sales method is the simplest and easiest way of finding future working capital. First, each component of working capital as a percentage of sales is calculated. For accounts payable are 20 million, and sales are 100 million, accounts payable as a percentage of sales would be 20%. Secondly, the coming year’s sales forecast is taken as a base, and the component is calculated per the percentage. In our instant example, if forecasted sales are 150 million, accounts payable should be 30 million. This is as simple as that. Let us see a practical example with formula and example.

Percentage of Sales Method Formula = Component of Working Capital * 100 / Sales of the Year.

Percentage of Sales Method Example

Consider the following balance sheet for the year 2014 as an example. The sales for 2014 are $400. The forecasted sales figure for the year 2015 is $600.

AssetsAmt. ($)LiabilitiesAmt. ($)
Owner’s Capital200Fixed Assets170
Debentures110Inventories40
Accounts Payable40Accounts Receivables110
  Cash and Bank20
 350 290

The percentage of sales method will calculate the working capital and its components as illustrated in the below table. We can see that in the last column, estimates for 2015 are calculated, and the working capital requirement for 2015 comes out to be $195 for the forecasted sales figure of $600.

Particulars Actual Figures of 2014% of SalesEstimate for 2015
Sales(x)400100600
Current Assets17042.5255
Inventories401060
Accounts Receivables11027.5165
Cash and Bank20520
Current Liabilities(y)401060
Accounts Payable401060
Working Capital(x-y)13032.5195

Advantages and Disadvantages of Percentage of Sales Method

The advantages of this method are that it is easy to understand and simple to calculate. There is no rocket science in calculating the working capital based on this method.

The most significant disadvantage is its assumption which is not very practical in all situations. This method is useful only where the relationship between the revenue and working capital is linear. Elsewhere this method is not suggested. Another drawback is that it is highly dependent on sales forecasts. If the sales forecast is faulty, a whole calculation will be faulty. Higher working capital would attract higher interest costs and low profitability, and lower working capital would pose a problem to the smoothness of the operating cycle.

Other Methods for Estimating the Working Capital Requirements



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.

1 thought on “Working Capital Calculation – Percentage of Sales Method”

  1. I needed to compose you that very small note just to give thanks over again with the remarkable strategies you’ve contributed at this time.

    Reply

Leave a Comment