Inventory (Historical)
Returns the historical inventory balance - goods held for sale in the ordinary course of business. This is a key working capital component for manufacturing and retail companies.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol (e.g., WMT, AAPL) |
| Year | Yes | Fiscal year (2023) or period code (lq, ly) |
| Quarter | No | Quarter number 1-4 (default: 1) |
| TTM | No | Set to "TTM" for trailing twelve months |
Inventory Components
| Type | Description |
|---|---|
| Raw Materials | Inputs for production |
| Work in Process | Partially completed goods |
| Finished Goods | Ready for sale |
| Merchandise | Retail inventory for resale |
Notes
- Zero or minimal for service companies
- High for retailers and manufacturers
- Seasonality affects levels (holiday buildup)
- LIFO vs FIFO accounting affects values
Examples
=hf_Inventory("AAPL", 2023, 4)=hf_Inventory("WMT", "ly")=hf_Inventory("AMZN", 2023, , "TTM")=hf_Inventory(A1, B1, C1)When to Use
- Inventory turnover calculation
- Working capital analysis
- Days inventory outstanding (DIO)
- Supply chain efficiency analysis
- Retail and manufacturing analysis
When NOT to Use
Common Issues & FAQ
Q: How do I calculate inventory turnover?
A: Inventory Turnover = COGS / Average Inventory: =hf_Cost_of_Revenue("WMT","ly") / ((hf_Inventory("WMT","ly") + hf_Inventory("WMT","ly-1"))/2)
Q: How do I calculate Days Inventory Outstanding (DIO)?
A: DIO = (Inventory / COGS) x 365: =(hf_Inventory("WMT","lq") / hf_Cost_of_Revenue("WMT","lq",,"TTM")) * 365
Q: Why is Apple's inventory so low? A: Apple uses a just-in-time supply chain with low inventory levels. They turn inventory over quickly. Compare to traditional retailers with higher inventory.
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?