Number Of Days Cost Of Goods Sold In Inventory (Historical)
Returns how many days worth of cost of goods sold is held in inventory. Lower values indicate faster inventory turnover.
Examples
=hf_Number_of_days_cost_of_goods_sold_in_inventory("AAPL", 2023, 4)=hf_Number_of_days_cost_of_goods_sold_in_inventory("WMT", 2022, , "TTM")When to Use
- Analyzing inventory management
- Cash conversion cycle calculation
- Working capital analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need inventory turnover ratio | hf_Inventory_turnover() |
Common Issues & FAQ
Q: Lower or higher is better? A: Lower is generally better (faster inventory turnover), but optimal levels vary by industry.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?