EN
Payments and Collections

How Do You Calculate Working Capital? A Guide to the Cash Conversion Cycle, Days in Inventory and Collection Period

How do you calculate working capital? Current ratio, days in inventory, collection period, the cash conversion cycle and early payment discounts: an 8-lesson course with examples.

Contents 14 sections
  1. What will you be able to do by the end of this training?
  2. Lesson 1: What is working capital and why is it important in e-commerce?
  3. Lesson 2: How do you calculate working capital?
  4. Lesson 3: What do the current ratio and the acid-test ratio tell you?
  5. Lesson 4: How do you calculate days in inventory?
  6. Lesson 5: How do you calculate days to collect and days payable?
  7. Lesson 6: How do you calculate the cash conversion cycle?
  8. Lesson 7: What moves shorten the cycle?
  9. Lesson 8: Should you take early payment discounts, and how do you set up a monthly routine?
  10. What are the most common mistakes in managing working capital?
  11. How do you monitor working capital with NetKasam?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Do the same calculation this month end
  14. Frequently Asked Questions About Working Capital

Month end has arrived, your sales are good, the profit statement is positive, and still there is no money in the account to pay the supplier. This contradiction is very common in e-commerce, and the reason is usually not profit but where the money is waiting: in inventory in the warehouse, in a payout the marketplace has not yet paid, or in a customer's payment term. The money that finances a business's day-to-day operations is called working capital.

This article is not just an explanation; it is an 8-lesson practical course. It answers how to calculate working capital with numbers; using a single sample business, we will work out the current ratio, the acid-test ratio, days in inventory, the collection period, the payment period and the cash conversion cycle. Then we will calculate three moves that shorten the cycle and the real cost of early payment discounts. At the end there is a mini quiz and a monthly routine. For the definition of the concept, see the glossary term working capital.

What will you be able to do by the end of this training?

In short: You will calculate your working capital and current ratio, find your inventory, collection and payment days to work out your cash conversion cycle, measure the cash impact of moves that shorten the cycle and calculate the annual cost of early payment discounts.

Course mapThe six steps of working capital analysis
  1. 01
    Balance sheetList current assets and short-term liabilities.
  2. 02
    CapitalCalculate working capital and the ratios.
  3. 03
    DaysFind inventory, collection and payment days.
  4. 04
    CycleWork out the cash conversion cycle.
  5. 05
    MovesCalculate the cash impact of moves that shorten the cycle.
  6. 06
    MonitoringRepeat the same calculation every month and track the trend.

The 8 lessons of the course: (1) what working capital is, (2) how to calculate it, (3) the current ratio and the acid-test ratio, (4) days in inventory, (5) days to collect and days payable, (6) the cash conversion cycle, (7) shortening the cycle, (8) early payment discounts and the monthly routine.

Lesson 1: What is working capital and why is it important in e-commerce?

In short: Working capital is the money that finances a business's daily operations: the amount left when you subtract your short-term liabilities from your current assets. In e-commerce, because inventory ties up money and marketplace payments arrive late, even a profitable business can face a working capital squeeze.

Current assets (sources of cash inflow)Short-term liabilities (sources of cash outflow)
Cash and bankSupplier payables
Customer and marketplace receivablesTax and Social Security Institution (SGK) liabilities
InventoryLoan installments and card debts
Advances givenExpenses payable such as staff and rent

Profit and cash are not the same thing. When you buy a product at a cost of ₺100 and sell it for ₺150, the income statement shows ₺50 in profit; but until the marketplace pays and until you buy new stock, the cash is not in your hands. Because of this difference, the income statement and cash flow should be read together: see the income statement and cash flow statement guides.

Lesson 2: How do you calculate working capital?

In short: Working capital = current assets − short-term liabilities. If positive, short-term liabilities are covered by current assets; if negative, they are not.

FormulaSix formulas of working capital analysis
  1. Working capital = Current assets − Short-term liabilities
  2. Current ratio = Current assets ÷ Short-term liabilities
  3. Acid-test (liquidity) ratio = (Current assets − Inventory) ÷ Short-term liabilities
  4. Days in inventory = Inventory ÷ Daily cost of goods sold
  5. Days to collect = Receivables ÷ Daily sales
  6. Cash conversion cycle = Days in inventory + Days to collect − Days payable

Days payable = Supplier payables ÷ Daily cost of goods sold.

Our sample business is an e-commerce seller. Its annual sales are ₺5,400,000 (₺15,000 per day), and its annual cost of goods sold is ₺3,600,000 (₺10,000 per day). The end-of-period balance sheet is as follows (figures chosen only to illustrate the method):

ChartBreakdown of the sample business's current assets
  • Inventory₺450,00056.3%
  • Customer and marketplace receivables₺210,00026.3%
  • Cash and bank₺140,00017.5%

Prepared with sample values. Short-term liabilities are ₺440,000 (₺300,000 suppliers, ₺140,000 taxes, installments and other).

Working capital = 800,000 − 440,000 = ₺360,000. After paying its short-term liabilities, the business has ₺360,000 to finance day-to-day work; but ₺450,000 of this is in inventory, meaning that part of the capital has to actually turn into cash.

Lesson 3: What do the current ratio and the acid-test ratio tell you?

In short: The current ratio shows how many times short-term liabilities are covered by current assets. The acid-test ratio leaves inventory out, because inventory does not always turn into cash quickly.

RateAccountExampleInterpretation
Current ratio800.000 ÷ 440.0001,82Liabilities are covered 1.82 times
Acid-test ratio(800.000 − 450.000) ÷ 440.0000,80Without inventory, about 80% of liabilities are covered

There is no single generally accepted ideal number for these ratios; they vary by sector, inventory structure and supplier terms. What matters is the direction of your own ratio over time: if the current ratio is falling and the acid-test ratio drops below 1, too much money is being tied up in inventory. A high current ratio is not always good either; it may contain idle cash or unsold inventory.

Lesson 4: How do you calculate days in inventory?

In short: Days in inventory = inventory ÷ daily cost of goods sold. It shows how many days of sales your inventory covers; the longer it is, the longer money is tied up on the shelf.

In the example, inventory is ₺450,000 and the daily cost of goods sold is ₺10,000, so days in inventory is 45. Using a single average for every product is misleading; fast-selling products and dead stock get mixed into the same average. First separate products with ABC analysis (ABC analysis), then calculate days in inventory by class. For its relationship with inventory turnover, see the article the role of inventory turnover, and for valuing inventory at cost, see the article how to calculate inventory cost. How much inventory should be held is determined by the sales forecast and safety stock.

Recommended ReadingHow Do You Calculate Inventory Cost?

Lesson 5: How do you calculate days to collect and days payable?

In short: Days to collect shows how many days it takes you to receive payment for the product you sold; days payable shows how many days it takes you to pay your supplier. As the first lengthens and the second shortens, the need for capital increases.

DayAccountExampleMeaning
Days to collect210,000 ÷ 15,000 (daily sales)14 daysAn average of 14 days from sale to cash
Days payable300,000 ÷ 10,000 (daily cost of goods sold)30 daysPaying the supplier in 30 days on average

The duration of receivables from marketplaces depends on each marketplace's own payment schedule; read this period from your own payout reports. For card payments, too, the transfer to your bank account happens after a short wait and a commission deduction. If you sell on credit terms, receivables tracking directly determines days to collect: how to track receivables. For accounting for marketplace payouts, take a look at the article marketplace accounting.

Lesson 6: How do you calculate the cash conversion cycle?

In short: Cash conversion cycle = days in inventory + days to collect − days payable. It is the number of days money stays tied up from the moment you pay the supplier to the moment you receive payment for the product.

ChartCycle components of the sample business: days in inventory is the longest item
  1. Days in inventory45 days
  2. Days to collect14 days
  3. Days payable30 days

Prepared with sample values. Cycle = 45 + 14 − 30 = 29 days.

The sample business's cycle is 29 days: it gets the money for a product back 29 days after paying the supplier. What finances these 29 days is working capital. The shorter the cycle, the smaller the capital you need for the same sales; a negative cycle (payment for the product arrives before the supplier payment) is the best situation.

ComponentIf it lengthensIf it shortens
Days in inventoryCash waits on the shelf, warehouse and shrinkage costs riseCash is freed up, but the risk of running out of stock rises
Days to collectCash waits in receivablesCash turns over quickly
Days payableCash stays with you, the supplier relationship may be strainedCash goes out early

Lesson 7: What moves shorten the cycle?

In short: There are three ways: reducing days in inventory, shortening days to collect and lengthening days payable. The effect of each is calculated as the difference in days × the daily amount.

ChartWorking capital need after three moves: from ₺360,000 to ₺100,000
  1. Current working capital need₺360,000
  2. Days in inventory from 45 to 35 (10 days × ₺10,000)−₺100,000
  3. Days to collect from 14 to 10 (4 days × ₺15,000)−₺60,000
  4. Days payable from 30 to 40 (10 days × ₺10,000)−₺100,000
  5. New working capital need₺100,000

Prepared with sample values. All three moves happening at the same time is an optimistic scenario.

MoveHow is it done?Note
Reducing days in inventoryLowering order quantities based on sales forecasts and ABC analysis, clearing dead stock with campaignsIf you cut too much, you lose sales; protect safety stock
Shortening days to collectSetting limits on credit sales, sending payment reminders, steering customers to faster payment methodsCustomer relationships and competition on payment terms
Lengthening days payableNegotiating terms with the supplier, timing payments to the due dateRisk of a price increase or a damaged relationship; also calculate the early payment discount

If a short-term financing need arises as year end approaches, you can find the options in the article short-term financing sources. For a broad view of cash management, the article cash management solutions is also useful.

Lesson 8: Should you take early payment discounts, and how do you set up a monthly routine?

In short: If a supplier says "2% discount if you pay within 10 days, otherwise net 30", taking the discount yields an annual return of about 37% for paying 20 days early. If this rate is higher than your loan interest, the discount should be taken.

Calculation: for an invoice of ₺100, a 2% discount means paying ₺98. You gain ₺2 for paying ₺98 20 days early. The rate of return is 2 ÷ 98 = 2.04%, and it can be repeated 365 ÷ 20 = 18.25 times a year. The simple annual cost is about 0.0204 × 18.25 = 37.2%. Compare this with the annual cost of a bank loan (loan calculator). If the loan costs less, borrowing and paying with the discount is advantageous; but if your cash is insufficient and you cannot get a loan, you may have to skip the discount.

Takeaways from the exampleFour numbers from the sample analysis
  • ₺360,000working capital
  • 1.82current ratio
  • 29 dayscash conversion cycle
  • 37.2%annual cost of a 2/10 net 30 discount
When?What to do?Output
Every month endPull current assets and short-term liabilities; calculate working capital, the current ratio and the acid-test ratioRatio table
Every month endFind inventory, collection and payment days; write down the cycleCycle trend
Every weekCheck the calendar of payables and receivables coming dueWeekly cash calendar
Every three monthsReview supplier terms and discount conditionsNegotiation list
Before the seasonCalculate the working capital need of the seasonal orderFinancing plan
Recommended ReadingHow Do You Accept Payment by Link? A Guide to Online Collection with Payment Links, Credit Cards, Installments and Cash on Delivery

What are the most common mistakes in managing working capital?

  1. Confusing profit with cash. A profitable business can face a cash squeeze.
  2. Tying up too much money in inventory. Ordering without a sales forecast freezes working capital.
  3. Relying on average days in inventory. Dead stock hides behind the average; look by product class.
  4. Counting marketplace receivables as cash. Until the payout arrives, it is a receivable, not cash.
  5. Placing a seasonal order without a cash plan. If the payment date comes before the sales, a gap opens up.
  6. Extending supplier terms without limit. Relationship and price risks arise.
  7. Doing the calculation once a year. A cycle that is not monitored monthly is only noticed when the problem has grown.

How do you monitor working capital with NetKasam?

  • Inventory turnover and low stock levels. You see inventory turnover and the low-stock report, and you can set low-stock quantities for products (inventory management).
  • Cash flow and expense tracking. You can plan cash flow by separating income and expense items and get reminders for payments coming due (expense management).
  • Account balances and payment reminders. Payables and receivables are reminded to customers and suppliers; you can define risk and limits (customer and supplier account tracking).
  • Saved reports. You save the reports you pull monthly, export them to Excel and paste them into your ratio table (reports).
  • Invoice tracking. You track the payment status of issued and received invoices (invoice tracking).
  • Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.

Mini quiz: Test what you have learned

In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.

  1. If inventory is ₺200,000 and the daily cost of goods sold is ₺5,000, what is days in inventory?
  2. If days in inventory is 40, days to collect is 10 and days payable is 25, how many days is the cash conversion cycle?
  3. If current assets are ₺500,000 and short-term liabilities are ₺300,000, what are the working capital and the current ratio?
  4. How does extending supplier terms affect the working capital need?
  5. What is the approximate annual cost of a "2/10 net 30" discount, and what is it compared with?

Answer key:

  1. 200,000 ÷ 5,000 = 40 days.
  2. 40 + 10 − 25 = 25 days.
  3. 500,000 − 300,000 = ₺200,000; current ratio 500,000 ÷ 300,000 = 1.67.
  4. It reduces the need, because payment is delayed and cash stays with you longer; but price and relationship risks may arise.
  5. About 37%; it is compared with your loan or deposit cost.

Frequently Asked Questions About Working Capital

How do you calculate working capital?

Short-term liabilities (suppliers, taxes, loan installments) are subtracted from current assets (cash, bank, receivables, inventory). If the result is positive, short-term liabilities can be covered by current assets.

What is the current ratio?

It is the ratio of current assets to short-term liabilities. A current ratio of 1.82 shows that short-term liabilities are covered 1.82 times by current assets. The ideal ratio varies by sector and inventory structure.

What does the acid-test ratio tell you?

Leaving inventory aside, it shows how much of short-term liabilities can be covered by assets that quickly turn into cash. Since inventory cannot always be sold quickly, it is a stricter indicator than the current ratio.

What is the cash conversion cycle?

It is found by subtracting days payable from the sum of days in inventory and days to collect. It shows how long cash stays tied up from paying the supplier to receiving payment for the product.

What happens if working capital is negative?

It means short-term liabilities exceed current assets, and there is a risk of payment difficulties. In some businesses with fast cash turnover it can be temporary; but if it is persistently negative, be sure to examine the cause and the financing plan.

How do you increase working capital?

Days in inventory are shortened, collections are accelerated, payment terms are extended, or equity or short-term financing is added. Which is appropriate depends on the business's structure.

Should you take early payment discounts?

Calculate the annual cost of the discount: about 37% for 2/10 net 30. If this rate is higher than the cost of the financing you would use, taking the discount is advantageous.

Can I monitor working capital in NetKasam?

In NetKasam you can access data such as inventory turnover, low stock levels, cash flow, account payables and receivables and payment reminders, and calculate your ratios by saving reports and exporting them to Excel.

Conclusion: Do the same calculation this month end

Working capital is less an accounting term and more a daily management tool. This month end, pull your current assets and short-term liabilities, calculate your inventory, collection and payment days and write down your cash conversion cycle. Repeat the same calculation next month; if the cycle is shortening, your cash position is easing.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeOnline Collection

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools