Purchased Components (Historical)

Returns the purchased components inventory balance from historical balance sheets, representing parts and subassemblies bought from suppliers.

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

  • Relevant for assembly/manufacturing companies
  • Differs from raw materials (which require processing)
  • Part of total inventory breakdown

Examples

=hf_Purchased_components("F", 2023, 4)
Ford Q4 2023
=hf_Purchased_components("GM", "ly", 2)
GM last year Q2
=hf_Purchased_components(A1, B1, C1)
Cell references

When to Use

  • Supply chain analysis
  • Inventory composition breakdown
  • Manufacturing analysis
  • Supplier dependency assessment

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

Q: What's the difference between purchased components and raw materials? A: Purchased components are ready-to-use parts; raw materials need processing before use.

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 Purchased Components (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions