2.5.8Financial Ratios

Understand inventory and receivables turnover

2,383 words11 min readdifficulty · medium1 backlinks

Overview

Inventory turnover and receivables turnover are efficiency ratios that measure how quickly a company converts its working capital assets (inventory and credit sales) into cash. These ratios tell you whether a company is operationally efficient or has capital trapped in slow-moving goods or unpaid invoices.

Why these matter: High turnover = fast cash cycles = less capital locked up = better liquidity. Low turnover signals operational problems, obsolete inventory, or weak credit policies.


Core Concepts


###1. Inventory Turnover Ratio

Derivation from First Principles

WHY this formula?

Let's think step-by-step:

  1. COGS = Total cost of inventory sold during the year (not revenue, because we want the cost tied up in goods)
  2. Average Inventory = (Beginning Inventory + Ending Inventory) / 2 = Typical inventory level maintained
  3. The ratio = COGS / Avg Inventory = "How many times did we sell through our average stock?"

Example walkthrough:

  • COGS for the year = ₹12,000
  • Beginning inventory (Jan 1) = ₹1,00,000
  • Ending inventory (Dec 31) = ₹1,40,000
  • Average inventory = (1,00,000 + 1,40,000) / 2 = ₹1,20,000

Inventory Turnover=12,00,0001,20,000=10 times/year\text{Inventory Turnover} = \frac{12,00,000}{1,20,000} = 10 \text{ times/year}

WHY this step? We divide the annual goods sold by the average stock level. This tells us the inventory "turned over" (was fully replaced) 10 times.

DIO=36510=36.5 days\text{DIO} = \frac{365}{10} = 36.5 \text{ days}

Interpretation: On average, inventory sits on shelves for 36.5 days before being sold.

Figure — Understand inventory and receivables turnover

2. Receivables Turnover Ratio

Derivation from First Principles

WHY this formula?

  1. Net Credit Sales = Revenue from sales made on credit (not cash sales, because receivables only arise from credit)
  2. Average Accounts Receivable = (Beginning AR + Ending AR) / 2 = Typical outstanding credit balance
  3. The ratio = Sales / Avg AR = "How many times did we collect the full AR balance?"

Example walkthrough:

  • Annual credit sales = ₹24,00,000
  • Beginning AR (Jan 1) = ₹2,00,000
  • Ending AR (Dec 31) = ₹2,80,000
  • Average AR = (2,00,000 + 2,80,000) / 2 = ₹2,40,000

Receivables Turnover=24,00,0002,40,000=10 times/year\text{Receivables Turnover} = \frac{24,00,000}{2,40,000} = 10 \text{ times/year}

WHY this step? We divide annual credit sales by the average amount customers owe. This tells us we "collected the full AR balance" 10 times.

DSO=36510=36.5 days\text{DSO} = \frac{365}{10} = 36.5 \text{ days}

Interpretation: Customers take 36.5 days on average to pay their invoices.


Worked Examples


Common Mistakes


Active Recall Questions

#flashcards/stock-market

What does inventory turnover measure? :: How many times a company sells and replaces its entire inventory in a period (typically 1 year). Higher turnover = faster sales = less capital locked up.

What is the formula for inventory turnover ratio?
Inventory Turnover = COGS / Average Inventory. COGS (not revenue) because inventory is at cost.
What does Days Inventory Outstanding (DIO) tell you?
The average number of days inventory sits before being sold. DIO = 365 / Inventory Turnover. Lower DIO = faster-moving inventory.
What does receivables turnover measure?
How many times a company collects its average accounts receivable balance in a period. Higher turnover = customers pay faster.
What is the formula for receivables turnover?
Receivables Turnover = Net Credit Sales / Average Accounts Receivable.

What is Days Sales Outstanding (DSO)? :: The average number of days it takes to collect payment from credit customers. DSO = 365 / Receivables Turnover. Lower DSO = faster collections.

Why do you use COGS instead of revenue for inventory turnover? :: Because inventory is recorded at cost, not selling price. Mixing cost (inventory) with revenue (sales price) creates an invalid ratio. COGS matches the cost basis.

Why must you use average inventory and AR?
Balance sheet items are snapshots at a point in time. Averaging (Beginning + Ending) / 2 reflects the typical level maintained throughout the period, giving a more accurate turnover rate.
What does a very low inventory turnover indicate?
Possible problems: obsolete inventory, overstocking, weak demand, or (in some industries) high-value goods with naturally slow sales cycles. Requires industry context to interpret.
What does a very high DSO indicate?
Customers are taking too long to pay. Possible issues: lax credit policies, collection problems, or customers in financial distress. Cash is trapped in receivables instead of available for operations.

Intuitive Understanding

Recall Explain to a 12-Year-Old

Imagine you have a lemonade stand. You buy lemons and sugar for ₹100. If you sell out every week and re-buy supplies, you "turned over" your inventory 52 times a year. Your ₹100 works hard!

But if your lemons sit for a month before you sell them, you only turn over 12 times a year. Your ₹100 is stuck in lemons going bad. Slower turnover = wasted time and money.

Same with getting paid: If kids pay you immediately, great! If they say "I'll pay you next month," your money is stuck in promises (receivables) instead of your pocket. Faster payment = more lemonade you can make!


Connections

  • Cash Conversion Cycle: Inventory + Receivables turnover are 2 of the 3 components (the third is payables). Together they determine how long capital is tied up.
  • Working Capital Management: These ratios directly measure working capital efficiency. High turnover = less working capital needed.
  • Current Ratio and Quick Ratio: High inventory turnover improves liquidity ratios (less dead inventory). High DSO hurts quick ratio (AR isn't "quick" if it takes 90 days to collect).
  • Return on Assets (ROA): Faster turnover → same revenue with less asset investment → higher ROA.
  • Operating Cash Flow: Slow inventory and receivables turnover reduces operating cash flow. Cash is locked in assets instead of liquid.
  • Industry Analysis: Turnover benchmarks vary wildly by sector. Always compare within the same industry.
  • Credit Policy: DSO directly reflects your credit terms and enforcement. Tight policy = low DSO, lenient policy = high DSO.

Key Takeaways

  1. Inventory Turnover = COGS / Avg Inventory. Measures how fast you sell and replace stock. DIO = 365 / Turnover (days inventory sits).

  2. Receivables Turnover = Credit Sales / Avg AR. Measures how fast you collect payment. DSO = 365 / Turnover (days to collect).

  3. Always use averages (Beginning + Ending) / 2 for balance sheet items. Snapshots lie; averages reveal the real working capital maintained.

  4. Higher turnover = more efficient, but context matters. Compare to industry norms. An aircraft maker at 0.5× may beat a grocery store at 15×.

  5. These ratios diagnose cash problems: Low inventory turnover = capital frozen in shelves. High DSO = cash stuck in unpaid invoices. Both hurt liquidity.

Concept Map

includes

includes

divided by

divides

365 over ratio

divided by

divides

high value means

high value means

low value means

low value means

Efficiency Ratios

Inventory Turnover

Receivables Turnover

COGS

Average Inventory

Days Inventory Outstanding

Net Credit Sales

Average Receivables

Fast Cash Conversion

Capital Trapped

Hinglish (regional understanding)

Intuition Hinglish mein samjho

Inventory aur receivables turnover ratios yeh bate hain ki ek company apne working capital ko kitni efficiently use kar rahi hai. Socho, agar tumhara koi dukaan hai aur tum saman buy karte ho₹10,000 mein. Agar woh saman 1 mahine mein bik jata hai aur tum naya stock le ate ho, toh tumhara inventory 12 baar turn over ho gaya puri saal mein – matlab tumhare ₹10,000 fast kaam kar rahe hain. Lekin agar woh saman 6 mahine tak pade rehte hain, toh sirf 2 baar turnover hua – matlab tumhare paise inventory mein phanse hain, naye sales nahi kar sakte.

Receivables turnover bhi same concept hai – agar customers turant payment dete hain, toh tumhare pas cash aa gaya aur tum age badh sakte ho. Lekin agar woh log 60-90 din bad pay karte hain, toh tumhara paisa "promise" mein stuck hai, hath mein nahi. DSO (Days Sales Outstanding) yeh measure karta hai ki average kitne din lagte hain payment collect karne mein. Low DSO matlab fast collection, high DSO matlab customer payment slow kar rahe hain – yeh red flag hai credit policy ya collection issues ke liye.

Yeh ratios isliye critical hain kyunki yeh directly impact karte hain tumhari cash flow pe. Agar inventory slow move kar rahi hai aur receivables bhi late aa rahe hain, toh tumhare pas daily operations chalane ke liye cash kikami ho sakti hai, even if profit dikha rahe ho paper pe. Isliye investors aur analysts inn ratios ko industry benchmarks ke saath compare karte hain – grocery store ka 15× inventory turnover expected hai (fresh items fast bikte hain), lekin aircraft manufacturer ka 0.5× bhi acha ho sakta hai (plane bane mein years lagte hain). Context zaroori hai!

Test yourself — Financial Ratios

Connections