Construction In Progress (Historical)
Returns construction in progress (CIP) from historical balance sheets, representing assets under construction.
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
- Not depreciated until construction is complete
- Indicates ongoing capital investment
- Transferred to other PP&E categories when complete
Syntax
=hf_Construction_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
Construction in progress value
Examples
=hf_Construction_in_progress("TSLA", 2023, 4)=hf_Construction_in_progress("AMZN", "ly", 2)=hf_Construction_in_progress(A1, B1, C1)When to Use
- Tracking capital expansion
- Understanding growth investments
- Fixed asset analysis
- Future capacity planning
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need completed buildings | hf_Building_and_improvements() |
| Need total PP&E | hf_Gross_fixed_assets_plant_property_and_equipment() |
| Need net fixed assets | hf_Total_fixed_assets() |
Common Issues & FAQ
Why is CIP growing rapidly?
High CIP indicates significant capital expansion - new facilities, manufacturing plants, or major projects.
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?