Work In Progress (Historical)
Returns the work in progress (WIP) inventory balance from historical balance sheets, representing partially completed products in the manufacturing process.
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
- Most relevant for manufacturing companies
- High WIP may indicate production bottlenecks
- Part of total inventory breakdown
Syntax
=hf_Work_in_progress(Symbol, Year, [Quarter], [TTM])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
Work in progress inventory amount
Examples
=hf_Work_in_progress("BA", 2023, 4)=hf_Work_in_progress("CAT", "ly", 2)=hf_Work_in_progress(A1, B1, C1)When to Use
- Manufacturing efficiency analysis
- Production cycle time analysis
- Inventory composition breakdown
- Operational efficiency metrics
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need total inventory | hf_Total_inventory() |
| Need finished goods | hf_Finished_goods() |
| Need raw materials | hf_Raw_materials() |
Common Issues & FAQ
Why is WIP very high for some companies?
Companies with long production cycles (aerospace, shipbuilding) typically have high WIP.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Working Capital (Historical)
- Working Capital As A Percentage Of Equity (Historical)
- Working Capital As Percentage Of Price (Historical)
- Working Capital Per Share (Historical)
- Accounts Receivable (Historical)
- Accrued Expenses (Historical)
- Accrued Liabilities (Historical)
- Accumulated Depreciation And Depletion (Historical)
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?