Working Capital Calculation – Percentage of Sales Method

Percentage of sales method is a working capital forecasting method which is based on past relationship between sales and working capital. Just like technical analysis in the stock market, it assumes that the 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?

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. Like, accounts payable are 20 million, and sales are 100 million, accounts payable as a percentage of sales would be 20%. Secondly, the coming year sales forecast is taken as a base and the component is calculated as 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 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.

Assets Amt. ($) Liabilities Amt. ($)
Owner’s Capital

200

Fixed Assets

170

Debentures

110

Inventories

40

Accounts Payable

40

Accounts Receivables

110

Cash and Bank

20

 

350

 

290

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 Sales

Estimate for

2015

Sales

400

100

600

 
Current Assets (x)

170

42.5

255

Inventories

40

10

60

Accounts Receivables

110

27.5

165

Cash and Bank

20

5

20

Current Liabilities (y)

40

10

60

Accounts Payable

40

10

60

Working Capital (x-y)

130

32.5

195

Advantages and Disadvantages of Percentage of Sales Method

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

The biggest disadvantage is its assumption which is not very practical in all situations. This method is useful only where the relation between the revenue and working capital is linear. Elsewhere this method is not suggested. Another drawback is that it is highly dependent on sales forecast. If the sales forecast is faulty, a whole calculation will be faulty. Higher working capital would attract higher interest cost 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

Operating Cycle Method

Regression Analysis Method

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

Leave a Reply

Types of Working Capital
  • Methods for Estimating Working Capital Requirement
    Methods for Estimating Working Capital Requirement
  • Advantages of Trade Credit
    Advantages of Trade Credit
  • Working Capital Management - Maturity Matching or Hedging Approach to Working Capital Financing Graph
    Maturity Matching or Hedging Approach to Working …
  • Working Capital Financing
    Working Capital Financing
  • 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


    how to calculate reinvestment rategaap definition of capital expenditurewhat is zero base budgetingwhat is project irrexplain payback periodstages in budgeting processdefine interest coverage ratioroi vs npvdebtor age analysisaccounting equitiondividend payout ratio formuladefinition of invoice discountinghow to calculate tie ratiodifference between fund flow and cash flow statementformula for earning per shareadvantages and disadvantages of project financeasset based loan agreementprofit maximization calculationnpv techniqueoperating profit and ebitdadoes ebitda include interest incomemeaning of debit in accountingshares with perksfinancial motives for mergers and acquisitionsinterest coverage ratio examplemargin of safety formula percentagehow to value a company using dcfmodigliani definitionrecourse and nonrecoursecalculating break even point in dollarsdefine incremental revenueirrevocable letter of credit costcredits and debits explainedadvantages and disadvantages of financial statementdisadvantages of selling goods on creditbank account with overdraft facilitydisadvantages of borrowing moneytheory of capitalisationebit interest coverage ratiodefine callable bondinvestopedia ratio analysisdebtors turnover ratio interpretationwhat is usance lcmm proposition ii with taxestod letter for bankhuman resource management advantages and disadvantagespvifa calculatoroperating lease and capital leaseconglomerate merger exampledefine discounted cash flowdupont analysis explainedare debtors current assetsthe accounting equation isus gaap capital leasefinished goods inventory definitionpayback period calculation examplesformula of ytmwhat is capital rationing in financial managementactivity based budgeting disadvantagestrade debtors ratiowhat is profit maximisation in businesscalculating bepdefinition of a bank overdraftadvantages and disadvantages of residual incomeadvantage of budgetary controlmarginal costing definition accountingfinancial accounting depreciation methodshow to calculate dcrdefinition of fixed capitaltypical debt covenantseps formula calculationis owners equity an assetsynonym of ascertainfixed overhead expenditure variance formulaincremental defcapital lease vs operating leaseintracompany comparisons