founder.curiosta.com

The ladder / Level 1 · Trader/ Business math

Stock turnover, holding cost and the cash cycle

How fast your stock moves, what holding it costs, and how inventory, debtor and creditor days add up to your cash conversion cycle.

How numbers are rounded on these pages. Calculations are done at full precision and rounded only at the end, half up. Rupee amounts are rounded to the nearest rupee unless shown with paise, in which case to the nearest paisa. Percentages are shown to two decimal places, and days to one decimal place. Break-even quantities and reorder levels are rounded up to the next whole unit, because rounding down would leave you short. Economic order quantity is rounded to the nearest whole unit. Interest for a number of days uses a 365-day year. All examples and quiz questions are Hypothetical: they show the method, not real prices or rates.

Stock turnover and holding cost

Stock turnover tells you how many times in a year your stock is sold and replaced. A higher number means goods move fast and your money comes back quickly. Stock days turns the same idea into days: on average, how long an item sits with you before it is sold.

Keeping stock is not free. The holding cost (carrying cost) includes interest on the money tied up in it, godown rent, insurance, and losses from damage, expiry and theft. It is usually expressed as a percentage of the average stock value per year.

Use stock valued at cost and cost of goods sold, not sales, so both sides are on the same footing.

The standard formulas

Average stock = Opening stock + Closing stock2  (at cost)
Stock (inventory) turnoverStock turnover (times a year) = Cost of goods soldAverage stock
Stock days (inventory days)Stock days = Average stockCost of goods sold × 365 = 365Stock turnover
Holding costAnnual holding cost = Average stock × Holding cost rate per year

Terms used

Cost of goods sold (COGS)
The purchase cost of the goods you sold in the period (for a trader: opening stock + purchases − closing stock).
Average stock
Typical value of stock held, at cost. The average of opening and closing is the simplest estimate; monthly averages are better if stock swings.
Holding (carrying) cost rate
Yearly cost of holding stock as a percentage of its value: interest, space, insurance, damage, expiry, shrinkage.

Worked examples

HypotheticalBasicTurnover and stock days for a distributor

Cost of goods sold for the year is ₹60,00,000. Opening stock was ₹4,00,000 and closing stock ₹6,00,000.

  • Average stock = (₹4,00,000 + ₹6,00,000) ÷ 2 = ₹5,00,000
  • Stock turnover = ₹60,00,000 ÷ ₹5,00,000 = 12.0 times a year
  • Stock days = 365 ÷ 12 = 30.4 days

HypotheticalIntermediateWhat holding stock really costs

A trader carries an average stock of ₹8,00,000. His yearly holding costs, as a share of stock value:

  • Interest on the money tied up: 12%
  • Godown rent share: 4%
  • Damage, expiry and shrinkage: 2%
  • Insurance: 1%

Total holding cost rate = 19% a year. Annual holding cost = ₹8,00,000 × 19% = ₹1,52,000.

HypotheticalAdvancedCutting stock days from 45 to 30

A distributor's cost of goods sold is ₹1,20,00,000 a year. He reduces stock days from 45 to 30. Holding cost rate is 18% a year.

  • Average stock at 45 days = ₹1,20,00,000 × 45 ÷ 365 = ₹14,79,452
  • Average stock at 30 days = ₹1,20,00,000 × 30 ÷ 365 = ₹9,86,301
  • Money released = ₹4,93,151
  • Holding cost saved = ₹4,93,151 × 18% = ₹88,767 a year

Credit days and the cash conversion cycle

Your money is stuck from the day you pay your supplier until the day your customer pays you. The cash conversion cycle measures that gap in days, using three numbers: how long stock sits (inventory days), how long customers take to pay (debtor days), and how long your suppliers let you take (creditor days).

A shorter cycle means less of your own money is tied up, and you can grow with less borrowing. The trader article on credit cycles explains why this decides survival.

The standard formulas

Inventory days = Average stockCost of goods sold × 365
Debtor days = Trade receivablesCredit sales × 365
Creditor days = Trade payablesCredit purchases × 365  (cost of goods sold is often used if purchases are not known)
Cash conversion cycleCash conversion cycle = Inventory days + Debtor days − Creditor days
Rough rupee sizeMoney tied up ≈ Daily cost of goods sold × Cash conversion cycle (days)

Terms used

Trade receivables (debtors)
Money customers owe you for goods already delivered.
Trade payables (creditors)
Money you owe suppliers for goods already received.
Debtor days
Average number of days customers take to pay.
Creditor days
Average number of days you take to pay suppliers.
Cash conversion cycle
Days between paying for stock and collecting cash from the sale.

Worked examples

HypotheticalBasicCycle from three numbers

Stock sits 20 days, customers pay in 30 days, and the supplier gives 15 days.

  • Cash conversion cycle = 20 + 30 − 15 = 35.0 days

HypotheticalIntermediateWorking out the three numbers from the books

A distributor's year: credit sales ₹1,46,00,000, cost of goods sold ₹1,31,40,000 (all purchases on credit, roughly equal to cost of goods sold), receivables ₹16,00,000, payables ₹5,40,000, average stock ₹7,20,000.

  • Inventory days = ₹7,20,000 ÷ ₹1,31,40,000 × 365 = 20.0 days
  • Debtor days = ₹16,00,000 ÷ ₹1,46,00,000 × 365 = 40.0 days
  • Creditor days = ₹5,40,000 ÷ ₹1,31,40,000 × 365 = 15.0 days
  • Cash conversion cycle = 20 + 40 − 15 = 45.0 days

HypotheticalAdvancedWhat 10 fewer debtor days are worth

The same distributor sells ₹40,000 a day on credit. He tightens collections so debtor days fall from 40 to 30. His bank limit costs 12% a year.

  • Cash released = ₹40,000 × 10 days = ₹4,00,000
  • Interest saved = ₹4,00,000 × 12% = ₹48,000 a year
  • His cash conversion cycle falls from 45.0 days to 35.0 days.

Quiz: stock turnover, holding cost and the cash cycle

Pick an answer to see at once whether it is right, with a short explanation. Each question takes one try; your score appears at the end. No answers are sent anywhere. (Without JavaScript, open “Show answer” under each question.)

  1. Stock turnover · BasicCost of goods sold is ₹36,00,000 a year and average stock (at cost) is ₹3,00,000. What is the stock turnover?
    Show answer

    Answer: (c) 12 times a year

    ₹36,00,000 ÷ ₹3,00,000 = 12 times a year.

    Why the other options are wrong:

    • (a) A slip of ten: ₹36 lakh ÷ ₹3 lakh is 12.
    • (b) That divides the wrong way round.
    • (d) That is stock as a percentage of cost of goods sold.
  2. Stock turnover · BasicYour stock turns over 8 times a year. About how many days does stock sit with you?
    Show answer

    Answer: (b) 45.6 days

    365 ÷ 8 = 45.6 days.

    Why the other options are wrong:

    • (a) That is the turnover, not days.
    • (c) That multiplies instead of dividing.
    • (d) A decimal slip.
  3. Stock turnover · IntermediateOpening stock ₹2,50,000, closing stock ₹3,50,000 (at cost), cost of goods sold ₹45,00,000. Stock turnover?
    Show answer

    Answer: (d) 15.00 times

    Average stock = ₹3,00,000. ₹45,00,000 ÷ ₹3,00,000 = 15 times.

    Why the other options are wrong:

    • (a) That uses closing stock only.
    • (b) That uses opening stock only.
    • (c) That uses opening + closing without dividing by 2.
  4. Stock turnover · IntermediateAverage stock is ₹6,00,000 and your holding cost rate is 20% a year. Annual holding cost?
    Show answer

    Answer: (a) ₹1,20,000

    ₹6,00,000 × 20% = ₹1,20,000 a year.

    Why the other options are wrong:

    • (b) That uses 2%.
    • (c) That adds 20% to the stock value.
    • (d) That is one month's holding cost, not the year's.
  5. Stock turnover · IntermediateSales are ₹50,00,000 at a 10% gross margin. Average stock at cost is ₹4,50,000. Stock turnover (on cost)?
    Show answer

    Answer: (b) 10.00 times

    Cost of goods sold = ₹50,00,000 × 90% = ₹45,00,000. ₹45,00,000 ÷ ₹4,50,000 = 10 times.

    Why the other options are wrong:

    • (a) That divides sales by stock at cost, mixing two bases.
    • (c) That uses gross profit instead of cost of goods sold.
    • (d) Divided the wrong way round.
  6. Stock turnover · AdvancedCost of goods sold is ₹73,00,000 a year. You cut stock days from 60 to 40. How much money is released?
    Show answer

    Answer: (c) ₹4,00,000

    Daily cost of goods = ₹73,00,000 ÷ 365 = ₹20,000. 20 fewer days × ₹20,000 = ₹4,00,000.

    Why the other options are wrong:

    • (a) That is the new stock, not the money released.
    • (b) That is the old stock.
    • (d) That is one day's cost of goods sold.
  7. Stock turnover · AdvancedSame case: ₹4,00,000 of stock released, holding cost rate 18% a year. What is the yearly saving?
    Show answer

    Answer: (d) ₹72,000

    ₹4,00,000 × 18% = ₹72,000 a year.

    Why the other options are wrong:

    • (a) That is the cash released once, not the yearly saving.
    • (b) That applies 18% to the old stock level.
    • (c) That uses 1.8%.
  8. Cash cycle · BasicInventory days 25, debtor days 40, creditor days 30. Cash conversion cycle?
    Show answer

    Answer: (b) 35.0 days

    25 + 40 − 30 = 35 days.

    Why the other options are wrong:

    • (a) Creditor days are subtracted, not added.
    • (c) That subtracts debtor days.
    • (d) That leaves out creditor days.
  9. Cash cycle · BasicWhat do debtor days measure?
    Show answer

    Answer: (c) The average number of days your customers take to pay you

    Debtor days = trade receivables ÷ credit sales × 365.

    Why the other options are wrong:

    • (a) That is inventory days.
    • (b) That is creditor days.
    • (d) Not related.
  10. Cash cycle · IntermediateCredit sales are ₹73,00,000 a year and receivables are ₹6,00,000. Debtor days?
    Show answer

    Answer: (a) 30.0 days

    ₹6,00,000 ÷ ₹73,00,000 × 365 = 30.0 days.

    Why the other options are wrong:

    • (b) That is how many times receivables turn over, not days.
    • (c) That uses a 360-day year.
    • (d) That multiplies by 100 instead of 365.
  11. Cash cycle · IntermediateCredit purchases are ₹54,75,000 a year and trade payables are ₹3,00,000. Creditor days?
    Show answer

    Answer: (c) 20.0 days

    ₹3,00,000 ÷ ₹54,75,000 × 365 = 20.0 days.

    Why the other options are wrong:

    • (a) That is the payables turnover, not days.
    • (b) That uses a 360-day year.
    • (d) That multiplies by 100 instead of 365.
  12. Cash cycle · IntermediateInventory days 20, debtor days 30, creditor days 15. Your supplier extends credit to 25 days. New cash conversion cycle?
    Show answer

    Answer: (d) 25.0 days

    20 + 30 − 25 = 25 days, down from 35.

    Why the other options are wrong:

    • (a) Longer supplier credit shortens the cycle.
    • (b) That is the old cycle.
    • (c) That is only the change.
  13. Cash cycle · AdvancedYour cost of goods sold is ₹50,000 a day and your cash conversion cycle is 36 days. Roughly how much money is tied up?
    Show answer

    Answer: (a) ₹18,00,000

    ₹50,000 × 36 = ₹18,00,000.

    Why the other options are wrong:

    • (b) That is a whole year of purchases.
    • (c) A decimal slip.
    • (d) That doubles the cycle.
  14. Cash cycle · AdvancedCredit sales are ₹1,09,50,000 a year. You cut debtor days from 45 to 30. Your bank limit costs 12% a year. What is the yearly interest saving?
    Show answer

    Answer: (c) ₹54,000

    Daily credit sales = ₹30,000. 15 days × ₹30,000 = ₹4,50,000 released. × 12% = ₹54,000 a year.

    Why the other options are wrong:

    • (a) That is the cash released, not the interest saved.
    • (b) That applies 12% to all receivables at 45 days.
    • (d) That uses 10 days instead of 15.