MarketXLS

Other Inventories (Historical)

Returns other inventories from historical balance sheets that don't fit into standard categories.

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

  • May include supplies, spare parts, packaging materials
  • Category varies by company
  • Part of total inventory breakdown

Syntax

=hf_Other_inventories(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Other inventories amount

Examples

=hf_Other_inventories("WMT", 2023, 4)
Walmart Q4 2023
=hf_Other_inventories("TGT", "ly", 2)
Target last year Q2
=hf_Other_inventories(A1, B1, C1)
Cell references

When to Use

  • Detailed inventory analysis
  • Understanding inventory composition
  • Complete balance sheet breakdown
  • Operational expense analysis

When NOT to Use

Scenario Use Instead
Need total inventory hf_Total_inventory()
Need raw materials hf_Raw_materials()
Need finished goods hf_Finished_goods()

Common Issues & FAQ

What's typically included in other inventories?

Usually includes supplies, spare parts, packaging, and other items not in main inventory categories.

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
MarketXLS Excel Add-in Tutorial - How to Use Other Inventories (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions