Finished Goods (Historical)
Returns the finished goods inventory balance from historical balance sheets, representing completed products ready for sale.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year or period code |
| Quarter | No | Calendar quarter 1-4 |
| TTM | No | Set to "TTM" for trailing twelve months |
Notes
- Represents completed products awaiting sale
- High levels may indicate sales weakness
- Important for inventory turnover analysis
Syntax
=hf_Finished_goods(Symbol, Year, [Quarter], [TTM])Examples
=hf_Finished_goods("AAPL", 2023, 4)=hf_Finished_goods("NKE", "ly", 2)=hf_Finished_goods(A1, B1, C1)When to Use
- Inventory composition analysis
- Sales efficiency assessment
- Working capital management
- Demand forecasting analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need total inventory | hf_Total_inventory() |
| Need raw materials | hf_Raw_materials() |
| Need work in progress | hf_Work_in_progress() |
Common Issues & FAQ
Why are finished goods increasing while revenue is flat?
This may indicate weakening demand or production exceeding sales.
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?