Calculate the Trade payables turnover ratio from the following figures:
| Particulars | Amount (₹) |
|---|---|
| Credit purchases during 2016-17 | 12,00,000 |
| Creditors on 1.4.2016 | 3,00,000 |
| Bills Payables on 1.4.2016 | 1,00,000 |
| Creditors on 31.3.2017 | 1,30,000 |
| Bills Payables on 31.3.2017 | 70,000 |
Concept understanding — Inventory Turnover Ratio
Inventory Turnover Ratio – A First Look
Think of a kirana shop. The owner buys a carton of biscuits, keeps it on the shelf, and sells it. If that carton sits unsold for six months, the money used to buy it is stuck — it's not earning anything. But if the same carton sells out in a week and is replaced by a new one, the owner's money is working hard, turning over again and again.
That's the core idea: how fast does inventory sell? The Inventory Turnover Ratio measures exactly this speed.
The Precise Meaning
The ratio tells you how many times a business sells and replaces its entire stock of inventory during an accounting period (usually a year).
Inventory Turnover Ratio=Average InventoryCost of Revenue from Operations
Where:
- Cost of Revenue from Operations = Opening Inventory + Purchases + Direct Expenses – Closing Inventory (this is the cost of goods sold, not the selling price)
- Average Inventory = (Opening Inventory + Closing Inventory) ÷ 2
A high ratio means inventory moves quickly — good for cash flow. A low ratio means goods sit idle — money is locked up, and there's risk of obsolescence or spoilage.
Why It Matters (The "So What?")
For a Class 12 student, this ratio is part of Turnover Ratios under Accounting Ratios (NCERT Class 12, Part B, Chapter 5). It helps answer three questions:
- Efficiency – Is the company managing its stock well? A ratio of 8 means inventory is sold and replaced 8 times a year (roughly every 45 days).
- Liquidity – Slow-moving inventory can signal poor sales or overstocking, which strains cash.
- Comparison – Compare with past years or with competitors in the same industry. A textile firm and a vegetable vendor will have very different ideal ratios — context matters.
A very high ratio isn't always good. It could mean the company keeps too little stock and risks running out (stockouts), losing customers. A very low ratio could mean obsolete goods no one wants.
Accounting Treatment – What Gets Debited/Credited?
The ratio itself is a calculation, not a journal entry. But the numbers that feed into it come from real accounts:
- Cost of Revenue from Operations is the Trading Account's debit side (the cost of goods sold). It is not a separate ledger account — it's a derived figure.
- Inventory appears in the Balance Sheet under Current Assets. When inventory is sold, the journal entry is:
| Date | Particulars | L.F. | Debit (₹) | Credit (₹) |
|---|---|---|---|---|
| Cost of Revenue from Operations A/c (or Trading A/c) Dr. | XXX | |||
| To Inventory A/c | XXX | |||
| (Being cost of inventory sold transferred) |
This entry reduces Inventory (credit) and increases the cost side of the Trading Account (debit). The ratio then uses the average of opening and closing Inventory balances.
Format / Proforma (as per NCERT)
The ratio is presented in the Comparative Statement or Common Size Statement format. Here's the standard proforma for calculating it:
Format for Computing Inventory Turnover Ratio
| Particulars | Amount (₹) |
|---|---|
| 1. Cost of Revenue from Operations | |
| Opening Inventory | XXX |
| Add: Purchases | XXX |
| Add: Direct Expenses (e.g., carriage, wages) | XXX |
| Less: Closing Inventory | (XXX) |
| Cost of Revenue from Operations | XXX |
| 2. Average Inventory | |
| Opening Inventory | XXX |
| Closing Inventory | XXX |
| Total | XXX |
| Average Inventory (Total ÷ 2) | XXX |
| 3. Inventory Turnover Ratio (1 ÷ 2) | X times |
This is exactly how NCERT presents it — as a working note, not a formal ledger account. The ratio is expressed "X times" (e.g., 6 times).
A Quick Example (Conceptual, No Invented Data)
Suppose a company's Cost of Revenue from Operations is ₹5,00,000 and its Average Inventory is ₹1,00,000. The ratio is 5 times. That means the entire stock is sold and replaced 5 times during the year — roughly every 73 days (365 ÷ 5).
If next year the ratio drops to 2 times, management would investigate: Are we buying too much? Is demand falling? Are goods becoming outdated?
Final Takeaway
The Inventory Turnover Ratio is a speedometer for stock. It doesn't tell you profit or loss — it tells you how efficiently inventory is being converted into sales. For your exams, remember:
- Formula: Cost of Revenue from Operations ÷ Average Inventory
- High = fast moving (generally good, but watch for stockouts)
- Low = slow moving (generally bad, but could be seasonal)
- No journal entry for the ratio itself — it's a tool for analysis, not a transaction.
NCERT Class 12 Accountancy (Part B, Chapter 5) covers this under "Turnover Ratios." The textbook uses the term "Cost of Revenue from Operations" — not "Cost of Goods Sold" — so stick to that phrasing in exams.
The trade payables turnover ratio compares net credit purchases with average trade payables, indicating how quickly a firm pays its suppliers. With credit purchases of ₹12,00,000 and average trade payables of ₹3,00,000, the ratio is 4 times.
Trade Payables Turnover Ratio = 4 times
Given
| Particulars | Amount (₹) |
|---|---|
| Credit purchases during 2016-17 | 12,00,000 |
| Creditors on 1.4.2016 | 3,00,000 |
| Bills Payables on 1.4.2016 | 1,00,000 |
| Creditors on 31.3.2017 | 1,30,000 |
| Bills Payables on 31.3.2017 | 70,000 |
Step 1 — Average Trade Payables
= (Opening Creditors + Opening Bills Payable + Closing Creditors + Closing Bills Payable) ÷ 2
= (₹3,00,000 + ₹1,00,000 + ₹1,30,000 + ₹70,000) ÷ 2 = ₹6,00,000 ÷ 2 = ₹3,00,000
Step 2 — Trade Payables Turnover Ratio
= Net Credit Purchases ÷ Average Trade Payables = ₹12,00,000 ÷ ₹3,00,000 = 4 times
Trade Payables Turnover Ratio = 4 times
- JKBOSE Class 12 Annual Regular Examination (Commerce) 2024Set ANNUAL4 marksQ.Calculate Inventory Turnover Ratio from the following informations : Purchases = ₹ 70,000 Purchase Return = ₹ 55,000 Revenue from Operation = ₹ 6,00,000 Opening Inventory = ₹ 80,000 Carriage Inward = ₹ 20,000 Carries Outward = ₹ 15,000 Gross Loss 10% on Revenue from Operation.
›Reveal solutionSolution
Using the Gross Loss method, Cost of Revenue from Operations works out to ₹6,60,000 — but this exceeds the goods available for sale implied by the printed Opening Inventory and Net Purchases figures, so Closing Inventory (and hence a final Inventory Turnover Ratio) cannot be reliably computed from the figures exactly as printed in this paper; the correct method is shown in full below.
Given (as printed): Purchases = ₹70,000; Purchase Return = ₹55,000; Revenue from Operation = ₹6,00,000; Opening Inventory = ₹80,000; Carriage Inward = ₹20,000; Carriage Outward = ₹15,000; Gross Loss = 10% of Revenue from Operation.
Method:
Inventory Turnover Ratio = Cost of Revenue from Operations ÷ Average Inventory
Step 1 — Cost of Revenue from Operations, via the Gross Loss given.
Since there is a Gross LOSS (not profit), Cost of Revenue from Operations exceeds Revenue from Operations:
Gross Loss = 10% × 6,00,000 = ₹60,000
Cost of Revenue from Operations = Revenue from Operations + Gross Loss = 6,00,000 + 60,000 = ₹6,60,000
(Carriage Outward, being a selling expense, is excluded from Cost of Revenue from Operations.)
Step 2 — Net Purchases.
Net Purchases = Purchases − Purchase Return = 70,000 − 55,000 = ₹15,000
Step 3 — Attempt to derive Closing Inventory.
Closing Inventory = Opening Inventory + Net Purchases + Carriage Inward − Cost of Revenue from Operations
= 80,000 + 15,000 + 20,000 − 6,60,000
= 1,15,000 − 6,60,000
= −₹5,45,000
A negative closing inventory is not possible — goods available for sale (Opening Inventory + Net Purchases + Carriage Inward = ₹1,15,000) cannot be smaller than the Cost of Revenue from Operations (₹6,60,000) implied by the stated Gross Loss. This shows the figures printed in this particular paper are internally inconsistent (most likely a transcription/printing error in one of the original figures, such as Revenue from Operation or Purchase Return) — applying them exactly as given cannot yield a genuine, meaningful Closing Inventory or final ratio.
What a student should take away: the correct method is — (a) find Cost of Revenue from Operations from Gross Profit/Loss, (b) find Net Purchases, (c) find Closing Inventory using Opening Inventory + Net Purchases + Direct Expenses − Cost of Revenue from Operations, (d) take Average Inventory = (Opening + Closing) ÷ 2, and (e) divide Cost of Revenue from Operations by Average Inventory. A student facing this exact paper should double-check the printed figures (e.g., against their own official question paper) before relying on a single numeric final answer, since the values transcribed here produce an impossible result.
✓Final answerThe method is: Inventory Turnover Ratio = Cost of Revenue from Operations ÷ Average Inventory, with Cost of Revenue from Operations = ₹6,60,000 (Revenue ₹6,00,000 + Gross Loss ₹60,000) here. However, applying the printed Opening Inventory, Purchases and Purchase Return figures produces an impossible negative Closing Inventory, so a reliable final ratio cannot honestly be stated from this paper's figures as printed — verify the original figures before relying on a numeric answer.
🎓Unlock everything free for 14 days
- ✓Full step-by-step solutions
- ✓Concept-first explanations
- ✓Methods, shortcuts & mistakes
- ✓PYQ mapping + timed mock tests
Full access for 14 days. No credit card required.