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.
Syntax
=hf_Number_of_days_cost_of_goods_sold_in_inventory(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
Stock ticker symbol
yearstringRequired
Fiscal year or period code
quarterstring
Calendar quarter (1-4)
TTMstring
Use TTM for trailing twelve months
Returns
number
Days inventory outstanding (DIO)
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
Lower or higher is better?
Lower is generally better (faster inventory turnover), but optimal levels vary by industry.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
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?