MarketXLS

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])
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

Finished goods inventory amount

Examples

=hf_Finished_goods("AAPL", 2023, 4)
Apple Q4 2023
=hf_Finished_goods("NKE", "ly", 2)
Nike last year Q2
=hf_Finished_goods(A1, B1, C1)
Cell references

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

Related Functions