Why Inventory Age Matters for Liquidity
Inventory is usually reported as a current asset, but its carrying amount does not tell a lender or analyst how soon it can be converted into cash—or whether it can be sold for that amount at all. Goods may be saleable at their recorded cost, require a markdown, or have little recoverable value. Aging evidence helps distinguish these situations and makes a liquidity assessment more realistic.
An aging schedule organizes inventory by how long it has been held or, under a company’s stated method, how long it has been since the last movement. The convention matters: a schedule based on receipt date may not identify goods that have sat unused in production, while one based on last movement may flag items with little recent demand. Comparisons are most useful when the measurement basis and age bands are consistent across periods.
Aging is a snapshot of the inventory balance. Turnover is a flow-based measure: inventory turnover is generally cost of goods sold divided by average inventory, and days in inventory is generally 365 divided by inventory turnover when an annual period and a 365-day convention are used. Turnover summarizes the pace at which inventory is used or sold; aging shows how the balance is distributed across age groups. Neither measure alone proves that inventory is impaired. For example, a business may intentionally hold seasonal stock for months, while a high-turnover business can still have a small but material obsolete category.
Interpreting an Aging Schedule
Start by examining both the amount and the share in older bands. A rising older-stock share may signal that purchases or production are exceeding demand, that particular products are losing relevance, or that the firm is holding buffer stock. Then ask whether the pattern is concentrated in a few items or spread across the inventory, whether it is unusual for the business, and whether the aging convention has changed.
Aging is a warning signal, not a write-down rule. A schedule does not itself establish a required percentage loss for each band. The analyst needs item-level evidence such as subsequent sales, current selling prices, expected demand, condition, and costs still needed to finish or dispose of the goods. Under the model used in the examples below, inventory is measured at the lower of cost and net realizable value. Net realizable value (NRV) is the estimated ordinary-course selling price less estimated costs of completion and sale. The applicable accounting framework and inventory category must be checked; this simplified model should not be assumed to override framework-specific rules or exceptions.
Worked Example: Estimating a Write-Down from Aging Evidence
A hypothetical distributor uses the lower-of-cost-and-NRV model for the inventory in this example. Its aging review and item-level sales estimates support the following amounts. Determine the indicated write-down, the share of cost more than 60 days old, and the carrying amount after adjustment.
| Age band | Cost | Estimated NRV |
|---|---|---|
| 0–30 days | $120,000 | $120,000 |
| 31–60 days | $80,000 | $76,000 |
| 61–90 days | $60,000 | $45,000 |
| More than 90 days | $40,000 | $12,000 |
Method. Compare cost with NRV for each stated group, then add the shortfalls. The age bands identify where to investigate; the estimated NRVs, not an arbitrary age-based percentage, determine the amounts in this example.
For 0–30 days, the shortfall is \(\max(0,\$120{,}000-\$120{,}000)=\$0\). For 31–60 days, it is \(\max(0,\$80{,}000-\$76{,}000)=\$4{,}000\). For 61–90 days, it is \(\max(0,\$60{,}000-\$45{,}000)=\$15{,}000\). For more than 90 days, it is \(\max(0,\$40{,}000-\$12{,}000)=\$28{,}000\).
The indicated write-down is \(\$0+\$4{,}000+\$15{,}000+\$28{,}000=\$47{,}000\). Cost more than 60 days old is \(\$60{,}000+\$40{,}000=\$100{,}000\), or \(\$100{,}000/\$300{,}000=33.33\%\) of total cost. The adjusted carrying amount is \(\$300{,}000-\$47{,}000=\$253{,}000\), which also equals the sum of the four NRVs.
Check. The write-down cannot exceed the \(\$300{,}000\) original cost, and adjusted inventory of \(\$253{,}000\) agrees with total estimated NRV. A common mistake would be to apply a fixed write-down to every item more than 60 days old; the correction is to use evidence about recoverable amounts under the stated measurement model.
Combining Aging with Turnover Evidence
Turnover and aging should be read together, not substituted for one another. A worsening turnover measure indicates that inventory is moving more slowly overall, but it does not identify which stock is responsible. A large old-stock share gives more detail, but it does not by itself show that the whole business has slowed. Consistent accounting policies and comparable periods matter when interpreting either measure.
Worked Example: Separating Overall Movement from Old-Stock Risk
A hypothetical equipment-parts seller reports cost of goods sold of $2,000,000 for the current year, beginning inventory of $400,000, and ending inventory of $600,000. At year-end, $360,000 of inventory is 0–60 days old, $150,000 is 61–120 days old, and $90,000 is more than 120 days old. In the prior year, cost of goods sold was $1,800,000 and average inventory was $400,000. Calculate current turnover and days in inventory, compare turnover with the prior year, and quantify the older-stock share.
Method. Use average inventory for the current-year turnover calculation, the same 365-day convention in both years, and ending inventory for the point-in-time aging share. These figures are distinct measures.
Current average inventory is \((\$400{,}000+\$600{,}000)/2=\$500{,}000\). Current turnover is \(\$2{,}000{,}000/\$500{,}000=4.00\) times. Current days in inventory are \(365/4.00=91.25\) days.
Prior-year turnover is \(\$1{,}800{,}000/\$400{,}000=4.50\) times, and prior-year days in inventory are \(365/4.50=81.11\) days. The turnover change is \((4.00-4.50)/4.50=-0.1111\), or an 11.11% decline. Days in inventory increased by \(91.25-81.11=10.14\) days.
At year-end, inventory more than 60 days old is \(\$150{,}000+\$90{,}000=\$240{,}000\). Its share of ending inventory is \(\$240{,}000/\$600{,}000=40.00\%\); the more-than-120-day category alone is \(\$90{,}000/\$600{,}000=15.00\%\).
Interpretation and check. Both the lower turnover and the substantial older-stock share warrant investigation, especially into the items over 120 days old. They do not establish an impairment amount: there is no item-level NRV evidence here. A common mistake is to treat 40% of inventory as automatically obsolete. The correction is to treat that percentage as a risk indicator and test the affected items’ condition and recoverable value.
How Inventory Quality Changes Reported Liquidity
A current asset’s reported value contributes to the current ratio, defined as current assets divided by current liabilities. Inventory is excluded from the quick ratio under the usual acid-test construction because it generally must be sold before it can provide cash. A write-down reduces inventory and current assets; absent other entries, it does not directly create cash or reduce current liabilities. It therefore weakens the current ratio, while the quick ratio—which already excludes inventory—does not change from the write-down alone.
Here \(CA\) is current assets before the write-down, \(CL\) is current liabilities, and \(W\) is the write-down. Provided \(CL>0\), the change is \((CA-W)/CL-CA/CL=-W/CL\). This shows why the current ratio falls by an amount determined by the write-down relative to current liabilities. The calculation does not mean that a write-down itself uses cash; it recognizes that the prior carrying amount overstated the asset’s recoverable value under the stated model.
Worked Example: Distinguishing Reported Coverage from Near-Term Recovery
A hypothetical wholesaler has cash of $70,000, receivables of $130,000, inventory costing $500,000, and current liabilities of $400,000. A supported review estimates NRV of $200,000 for inventory expected to realize that amount within 60 days, $144,000 for a second group expected to realize its amount later, and $36,000 for older stock with no expected realization within 60 days. Assume the second group is 31–90 days old and the final group is more than 90 days old. For a separate, explicitly hypothetical 60-day cash scenario, assume 90% of the $130,000 receivables will be collected and 90% of the first inventory group’s NRV will be realized; 40% of the second group’s NRV will be realized, and none of the final group’s NRV will be realized. Also assume $300,000 of current liabilities fall due within 60 days. Calculate the write-down, current ratios before and after, and estimated 60-day resource coverage of those obligations.
Method. First compare inventory cost with the supported total NRV. Then calculate balance-sheet ratios using total current liabilities. Finally, build the 60-day scenario from only the amounts and realization assumptions specified; do not treat all reported inventory or liabilities as due within that period.
Total inventory NRV is \(\$200{,}000+\$144{,}000+\$36{,}000=\$380{,}000\). The write-down is \(\$500{,}000-\$380{,}000=\$120{,}000\). Before adjustment, current assets are \(\$70{,}000+\$130{,}000+\$500{,}000=\$700{,}000\), so the current ratio is \(\$700{,}000/\$400{,}000=1.75\). After adjustment, current assets are \(\$700{,}000-\$120{,}000=\$580{,}000\), so the current ratio is \(\$580{,}000/\$400{,}000=1.45\).
In the 60-day scenario, expected receivable collections are \(0.90(\$130{,}000)=\$117{,}000\). Expected proceeds from the first inventory group are \(0.90(\$200{,}000)=\$180{,}000\); from the second they are \(0.40(\$144{,}000)=\$57{,}600\); and from the final group they are \(0(\$36{,}000)=\$0\). Adding cash gives estimated resources of \(\$70{,}000+\$117{,}000+\$180{,}000+\$57{,}600=\$424{,}600\). Relative to $300,000 due within 60 days, estimated coverage is \(\$424{,}600/\$300{,}000=1.4153\), or about 1.42 times.
Check and limitation. The scenario indicates estimated resources exceeding the stated 60-day obligations by \(\$424{,}600-\$300{,}000=\$124{,}600\). It is not a guarantee: actual sales, collections, timing, and costs may differ, and the scenario is not the current ratio. A common mistake is to count the full $500,000 inventory balance as cash available within 60 days. The correction is to use the stated recovery assumptions and distinguish expected timing from reported carrying value.
A Practical Reading Sequence
A disciplined review links inventory evidence to liquidity without claiming more than the data support. The following sequence keeps the analysis focused:
Confirm what starts the age clock, whether the convention is consistent, and whether the schedule reconciles to the reported inventory balance.
Identify the older categories, their shares of inventory, and any material changes from comparable periods.
Use item-level evidence about condition, demand, subsequent sales, selling prices, and remaining completion or disposal costs. Do not infer a write-down from age alone.
Consider which goods could plausibly be sold soon, at what net amount, and whether that timing aligns with near-term payment needs.
The key distinction is between accounting value and liquidity value. Accounting measurement estimates an amount recoverable under the applicable rules. Liquidity analysis also asks when the amount may be realized and whether that timing is useful for meeting obligations. A firm can report substantial inventory and still face near-term pressure if much of it is aged, difficult to sell, or expected to realize cash only after bills fall due.
Check Your Understanding
For each problem, use only the assumptions stated and distinguish an aging signal from a proven impairment.
- A hypothetical retailer has $240,000 of inventory: $150,000 is 0–45 days old, $60,000 is 46–90 days old, and $30,000 is over 90 days old. Item-level evidence supports NRVs of $150,000, $54,000, and $18,000, respectively, under a lower-of-cost-and-NRV model. Find the write-down and the percentage of cost more than 45 days old. (Answer: $18,000 write-down; $90,000/$240,000 = 37.50% more than 45 days old.)
- A hypothetical manufacturer has annual cost of goods sold of $1,500,000, beginning inventory of $250,000, and ending inventory of $350,000. Using a 365-day year, calculate average inventory, turnover, and days in inventory. (Answer: Average inventory $300,000; turnover 5.00 times; 73 days.)
- A hypothetical firm has current assets of $540,000, including inventory of $180,000, and current liabilities of $300,000. A supported inventory write-down of $30,000 is recorded, with no other changes. Find the current ratio before and after, and explain the direct effect on the quick ratio. (Answer: 1.80 before; 1.70 after; no direct change to the quick ratio because inventory is excluded from its numerator.)
- A hypothetical parts seller reports 48% of ending inventory cost as more than 120 days old, but has no item-level sales-price or condition evidence. What can an analyst conclude, and what cannot yet be concluded? (Answer: The old-stock concentration is a significant risk signal warranting investigation; it does not by itself establish the amount, or even the necessity, of a write-down.)
- A hypothetical firm has $40,000 cash and $100,000 of receivables, of which 80% are expected to be collected within 30 days. Within 30 days it also expects to realize 75% of the $80,000 NRV of a saleable inventory group; another $50,000 NRV of inventory is not expected to sell within that period. If $160,000 of liabilities fall due within 30 days, calculate scenario resources and coverage, excluding the inventory not expected to sell. (Answer: Resources = $40,000 + $80,000 + $60,000 = $180,000; coverage = $180,000/$160,000 = 1.125, or 1.13 times.)