Inventory Ageing by Value: Why Not All Old Stock Carries the Same Risk
Inventory ageing is an important aspect of inventory management, but simply identifying how long stock has been sitting in a warehouse does not provide a complete picture of its financial risk.
For many businesses, the real challenge is understanding how much capital is tied up in ageing inventory and whether that inventory continues to serve a business purpose.
A ₹2 lakh stock item that has remained unused for six months may require immediate attention. In contrast, a ₹20 lakh stock of critical spare parts that has been held for a year may still be essential for maintaining production operations.
Both items are old, but their financial and operational risks are very different.
This is why businesses need to move beyond quantity-based ageing reports and adopt inventory ageing by value.
For Indian manufacturers, distributors, wholesalers, retailers, and procurement-driven organisations, value-based ageing analysis can help identify financial exposure, improve purchasing discipline, and support better working capital decisions.
At Pallavi & Company, inventory management should be viewed not merely as a stock control activity, but as a strategic process that connects procurement, finance, operations, and business performance.
In this article, we explain why not all old stock carries the same risk, how inventory ageing by value works, and how businesses can use it to improve inventory management.
What Is Inventory Ageing by Value?
Inventory ageing by value is a method of classifying inventory according to how long it has been held and measuring the monetary value of stock within each ageing category.
Traditional inventory ageing reports often focus on the number of units remaining in stock.
Value-based ageing goes a step further by calculating the financial investment represented by those units.
Basic Inventory Valuation Formula
For example, an Indian industrial distributor may have:
- 1,000 units of low-cost packaging material
- 150 units of expensive electrical components
- 40 units of specialised machine spare parts
A quantity-based report may show packaging material as the largest ageing concern.
However, the electrical components or spare parts may represent a significantly higher investment in working capital.
Inventory Ageing Value Percentage
This metric helps management identify the percentage of total inventory investment held in different ageing categories.
It also provides a more meaningful basis for prioritising inventory reviews.
1. Why Inventory Age Alone Can Be Misleading
A common inventory management mistake is to classify every item above a certain age as excess or dead stock.
For example, an item older than 180 days may automatically be marked as high risk. While this can work as an initial screening rule, it may not reflect the actual business situation.
Consider two inventory items:
- Item A: A critical machine spare part held for 12 months, with a long supplier lead time and an ongoing maintenance requirement.
- Item B: A finished product held for only 3 months, but its model has been discontinued and there is no current customer demand.
Item A may still be economically useful. Item B may already be at risk of losing its value.
The risk of inventory depends on several factors:
- Age and last movement date
- Current and expected demand
- Inventory quantity relative to demand
- Product lifecycle and technical changes
- Expiry or shelf-life constraints
- Customer commitments
- Replacement availability
- Estimated recoverable value
Inventory ageing should therefore be used as an early warning signal, not as an automatic disposal or write-off rule.
Pallavi & Company+1
2. Different Types of Old Stock Carry Different Financial Risks
A. Slow-Moving but Usable Inventory
Slow-moving inventory has limited sales or consumption compared with the quantity available.
Examples include:
- Electrical components with occasional demand
- Packaging material for less active product lines
- Industrial supplies used in specific projects
- Products with declining but continuing customer demand
This stock may still have value. The primary concern is excess quantity and capital tied up for longer than necessary.
Recommended action: Review forecasts, reduce future purchase quantities, explore stock transfers, and plan consumption or sales.
B. Critical Spare Parts
Some items remain unused for long periods because they are held for emergency maintenance or operational continuity.
Examples include:
- Manufacturing machine components
- Specialised electrical equipment parts
- Replacement parts for imported machinery
- Maintenance inventory for production facilities
These items may be old but strategically important.
Recommended action: Assess equipment criticality, lead time, replacement availability, maintenance schedules, and the expected remaining life of the equipment before deciding to reduce or dispose of stock.
C. Obsolete or Discontinued Inventory
Inventory may become obsolete due to changes in product specifications, technology, customer preferences, or product lifecycle.
Examples include:
- Discontinued electronics
- Outdated model-specific components
- Finished goods no longer supported by the market
- Materials that no longer meet current specifications
This stock can carry a significant financial risk if it has limited future demand or recoverable value.
Recommended action: Explore alternate use, supplier return options, liquidation, or appropriate inventory valuation adjustments.
D. Expiry-Sensitive Inventory
For businesses dealing with pharmaceuticals, FMCG, food products, chemicals, adhesives, and coatings, inventory risk may increase as the expiry date approaches.
An item with six months of shelf life remaining may be more urgent than a non-expiring spare part that has been held for two years.
Recommended action: Monitor batch-level expiry dates, implement FEFO (First Expired, First Out), and establish alerts for approaching expiry.
E. Customer-Specific Inventory
Stock manufactured or purchased for a particular customer or project may become risky if the order is delayed, cancelled, or revised.
Examples include:
- Custom-fabricated parts
- Project-specific electrical components
- Special packaging materials
- Made-to-order inventory
Recommended action: Review customer commitments, cancellation terms, alternative usage, and potential recovery options.
3. Inventory Ageing by Value: A Practical Indian Business Example
Let us consider a hypothetical Indian manufacturing and distribution company with a total inventory value of ₹1 crore.
Its inventory ageing report shows the following:
| Inventory Age | Stock Value | % of Total Inventory | Management View |
| 0–30 Days | ₹30 lakh | 30% | Monitor normal movement |
| 31–90 Days | ₹25 lakh | 25% | Review demand |
| 91–180 Days | ₹20 lakh | 20% | Investigate slow movement |
| 181–365 Days | ₹15 lakh | 15% | Prioritise review |
| 365+ Days | ₹10 lakh | 10% | Detailed risk assessment |
| Total | ₹1 crore | 100% |
At first glance, ₹25 lakh of inventory older than 180 days may appear to be a major concern.
However, further analysis reveals:
| Inventory Category | Value | Business Context | Risk Assessment |
| Critical spare parts | ₹8 lakh | Required for machine maintenance | Lower risk if justified |
| Slow-moving electrical components | ₹5 lakh | Some demand continues | Moderate risk |
| Discontinued finished goods | ₹7 lakh | No active demand | High risk |
| Expiry-sensitive consumables | ₹5 lakh | Shelf life is reducing | High / urgent |
| Total | ₹25 lakh |
This analysis changes the management response.
The company should not automatically dispose of the entire ₹25 lakh. Instead, it should prioritise the ₹12 lakh associated with discontinued products and expiry-sensitive consumables.
The critical spare parts may be retained if the operational need is documented. Slow-moving components may require purchasing restrictions, transfers, or demand planning adjustments.
The key takeaway is that the value of aged inventory and the value at risk are not necessarily the same.
4. Why Value-Based Ageing Is More Useful Than Quantity-Based Reporting
Quantity-based ageing helps identify the number of units that are old. Value-based ageing helps identify how much capital is invested in those units.
Consider the following example:
| Item | Quantity | Unit Cost | Total Inventory Value |
| Packaging Material | 5,000 | ₹10 | ₹50,000 |
| Electrical Component | 200 | ₹2,500 | ₹5,00,000 |
| Machine Spare Part | 20 | ₹25,000 | ₹5,00,000 |
The packaging material has the highest quantity, but the electrical component and machine spare part each represent a much higher financial investment.
For a consulting-led inventory review, both quantity and value should be considered.
Value-based ageing helps businesses:
- Identify capital-intensive aged inventory
- Prioritise high-value SKUs
- Improve working capital visibility
- Support procurement decisions
- Identify potential inventory valuation risks
- Establish accountability for stock recovery
- Improve financial and operational reporting
5. How to Build an Inventory Ageing by Value Report
An effective inventory ageing report should include more than an ageing bucket and stock quantity.
Essential Fields in an Inventory Ageing Report
| Report Field | Purpose |
| SKU / Item Code | Identifies the inventory item |
| Item Description | Explains the item |
| Warehouse / Location | Identifies where stock is held |
| Quantity on Hand | Measures available units |
| Unit Cost | Determines inventory value |
| Total Stock Value | Shows capital invested |
| Receipt Date | Helps identify how long stock has been held |
| Last Movement Date | Identifies inactivity |
| Ageing Bucket | Classifies inventory by age |
| Average Monthly Demand | Indicates consumption or sales |
| Inventory Cover | Shows how long current stock may last |
| Expiry Date | Identifies time-sensitive inventory |
| Open Customer Orders | Highlights committed demand |
| Estimated Recoverable Value | Supports financial risk assessment |
| Risk Classification | Helps prioritise review |
| Recommended Action | Converts analysis into decisions |
Step 1: Define the Ageing Basis
Businesses should clearly define how inventory age is calculated.
Possible dates include:
- Receipt date
- Manufacturing date
- Last sale date
- Last consumption date
- Last meaningful movement date
For example, the receipt date may be useful for analysing stock holding duration, while the last consumption date may be more useful for raw materials and components.
Warehouse transfers should not automatically reset the inventory age. Where relevant, stock should be tracked by batch or lot to preserve the original ageing information.
Pallavi & Company+1
Step 2: Establish Appropriate Ageing Buckets
A business may use the following categories as a starting point:
| Ageing Bucket | Suggested Management Action |
| 0–30 Days | Normal monitoring |
| 31–90 Days | Review demand and forecast |
| 91–180 Days | Investigate slow movement |
| 181–365 Days | Assess excess and recovery |
| 365+ Days | Detailed risk and valuation review |
These categories are illustrative, not universal. The appropriate ageing thresholds depend on the industry, product lifecycle, shelf life, supplier lead times, and normal inventory cycle.
Step 3: Calculate Inventory Value
The inventory value of each item can be calculated as:
The value should then be aggregated into the relevant ageing categories using a consistent inventory valuation method.
Step 4: Analyse Inventory Cover
Age alone does not determine whether the inventory quantity is excessive.
A useful metric is:
For example, if a company has 1,200 units of a component and its average monthly demand is 100 units, the inventory cover is 12 months.
If the item’s supplier lead time is only one month, management may need to investigate why such a large quantity is being held.
However, high inventory cover may be justified for critical items, long-lead imports, or products with uncertain supply.
Step 5: Assess Recoverable Value
For potentially obsolete, damaged, or slow-moving inventory, management should evaluate whether the recorded value can realistically be recovered.
Evidence may include:
- Recent sales prices
- Current customer demand
- Open sales orders
- Supplier return agreements
- Alternative usage
- Repair or rework costs
- Liquidation value
- Estimated selling and disposal costs
Inventory valuation should be reviewed according to the applicable accounting standards and company policies. Under Ind AS 2, inventories are generally measured at the lower of cost and net realisable value.
6. How Consultants Should Prioritise Inventory Risk by Value
Inventory management consulting should focus on identifying the inventory that creates the greatest financial and operational exposure.
A practical risk classification can be developed using inventory value, age, demand, and usability.
| Risk Category | Typical Characteristics | Recommended Management Action |
| Low Risk | Old but usable, stable demand, operationally critical | Retain and monitor |
| Moderate Risk | Slow movement, excess quantity, recoverable value | Reduce replenishment and review usage |
| High Risk | Discontinued, no demand, declining market value | Explore returns, liquidation, or valuation adjustment |
| Urgent Risk | Expiry approaching, damaged, or unusable stock | Immediate review and corrective action |
This framework allows management to focus on the inventory that needs attention rather than treating every ageing SKU equally.
7. How Inventory Ageing by Value Supports Working Capital Optimisation
Inventory is a major component of working capital for many businesses.
When stock remains unused for an extended period, the capital invested in it cannot easily be redeployed toward other business requirements.
This can affect:
- Supplier payments
- New procurement
- Production planning
- Business expansion
- Cash flow management
- Operational efficiency
Value-based ageing analysis helps businesses identify where working capital is tied up and whether the investment is justified by actual or expected demand.
For example, a company may discover that ₹40 lakh of inventory has remained inactive for more than six months. After detailed analysis, it may identify ₹15 lakh of excess stock that can be reduced through consumption planning, transfers, supplier negotiations, or sales initiatives.
The objective is not to eliminate all aged inventory. It is to identify inventory that is no longer contributing sufficient value to the business.
8. Common Mistakes Businesses Make in Inventory Ageing Analysis
Treating All Stock Older Than 180 Days as Dead Stock
A fixed ageing threshold can create unnecessary disposal decisions.
Critical spare parts, project inventory, and seasonal products may remain valuable despite their age.
Focusing Only on Quantity
A large quantity of low-value inventory may receive more attention than a small quantity of high-value stock.
Management should analyse both quantity and financial value.
Ignoring Demand and Inventory Cover
A product may be old but still have predictable demand. A recently received item may already be excess if there are no future requirements.
Resetting Age After Warehouse Transfers
If the system resets inventory age whenever stock moves between locations, old inventory may appear artificially fresh.
Ignoring Procurement Decisions
Ageing inventory may continue to accumulate if purchase orders are raised without reviewing existing stock.
Delaying Financial Review
Stock may remain recorded at its original cost even when its expected recoverable value has declined.
Finance and inventory teams should review the evidence and make appropriate valuation decisions in accordance with applicable policies.
Failing to Assign Action Owners
An ageing report becomes ineffective when no department is accountable for the next step.
Each high-risk item should have an assigned owner, proposed action, and target completion date.
9. Best Practices for Improving Inventory Ageing Management
Businesses can improve inventory ageing management through a structured review process.
Conduct Regular Inventory Ageing Reviews
Monthly reviews can provide visibility into changing inventory exposure. Expiry-sensitive and high-value inventory may require more frequent monitoring.
Link Procurement With Ageing Data
Purchasing teams should review existing aged stock before raising new purchase orders.
This can prevent additional purchases when usable inventory is already available.
Improve Demand Forecasting
Inventory ageing data should be analysed alongside historical sales, production consumption, seasonality, and future customer demand.
Establish an Inventory Action Tracker
A practical tracker should include:
- Item code
- Inventory value
- Ageing category
- Risk classification
- Root cause
- Action owner
- Recommended action
- Target completion date
- Current status
Improve Cross-Functional Coordination
Inventory ageing should involve procurement, finance, warehouse operations, production planning, and sales.
Each team contributes a different perspective on the stock’s commercial or operational value.
Monitor Inventory KPIs
Useful metrics include:
| KPI | What It Measures |
| Inventory Value Above 180 Days | Financial exposure in older stock |
| Inventory Value Above 365 Days | Long-term ageing exposure |
| Aged Inventory % | Aged value as a share of total inventory |
| Slow-Moving Inventory Value | Stock with limited movement |
| Obsolete Inventory Value | Stock with little or no expected future use |
| Inventory Turnover Ratio | How frequently inventory is sold or consumed |
| Days Inventory Outstanding (DIO) | Average inventory holding duration |
| Inventory Write-Down Value | Financial adjustment associated with inventory valuation |
These KPIs should be interpreted according to the business’s industry and inventory cycle.
10. How Pallavi & Company Can Help Businesses Improve Inventory Management
Effective inventory management requires more than preparing stock reports. Businesses need to understand why inventory is ageing, how much financial exposure it creates, and what actions can improve the situation.
An inventory management consulting approach can include:
- Inventory ageing analysis by value
- SKU-level slow-moving inventory identification
- Excess and obsolete inventory review
- Inventory valuation and risk assessment
- Procurement policy evaluation
- Demand forecasting improvement
- Working capital optimisation
- Inventory KPI development
- Inventory reporting and management dashboards
- Cross-functional inventory action planning
By combining operational analysis with financial insights, businesses can make more informed decisions about inventory investment.
Pallavi & Company focuses on helping organisations improve inventory visibility, strengthen inventory control, and support better business performance through structured inventory management practices.
Frequently Asked Questions
1. What is inventory ageing by value?
Inventory ageing by value classifies stock according to how long it has been held and calculates the financial value of each ageing category. It helps businesses understand the amount of capital invested in older inventory.
2. Why is inventory ageing by value important?
It helps businesses identify high-value aged stock, prioritise financial risk, improve procurement decisions, reduce excess inventory, and optimise working capital.
3. Does old inventory always mean dead stock?
No. Inventory may be old but still usable, saleable, or operationally important. Critical spare parts and products with predictable demand may remain valuable despite their age.
4. How do businesses identify high-risk aged inventory?
Businesses should evaluate stock age alongside demand, inventory cover, product lifecycle, expiry dates, customer commitments, usability, and estimated recoverable value.
5. Which ageing bucket should management focus on?
There is no universal threshold. Many businesses review stock older than 180 days or 365 days, but the appropriate period depends on industry characteristics and inventory cycles.
6. How does inventory ageing affect working capital?
Aged inventory can tie up capital, increase carrying costs, reduce cash flow flexibility, and create potential valuation losses. Identifying excess stock helps businesses make better inventory investment decisions.
7. How frequently should inventory ageing be reviewed?
Monthly review is a practical starting point for many businesses. High-value, fast-moving, or expiry-sensitive categories may require weekly or more frequent monitoring.
8. Can inventory ageing analysis improve purchasing decisions?
Yes. Reviewing aged stock before placing new purchase orders can help procurement teams avoid unnecessary purchases, reduce excess quantities, and improve inventory planning.
Conclusion: Focus on Financial Exposure, Not Just the Age of Stock
Inventory ageing is an essential part of inventory management, but the age of stock alone does not determine its financial risk.
A critical spare part held for a year may still support production continuity. A discontinued product held for three months may already represent a significant financial exposure.
By analysing inventory ageing by value and combining it with demand, usability, product lifecycle, and recoverable value, businesses can make more informed inventory decisions.
For Indian manufacturers, distributors, wholesalers, and retailers, this approach can help reduce excess stock, improve working capital utilisation, strengthen procurement planning, and support better financial control.
At Pallavi & Company, inventory management is approached as a strategic business function that connects stock visibility, purchasing discipline, financial performance, and operational efficiency.
