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

Examples

=hf_Construction_in_progress("TSLA", 2023, 4)
Tesla Q4 2023
=hf_Construction_in_progress("AMZN", "ly", 2)
Amazon last year Q2
=hf_Construction_in_progress(A1, B1, C1)
Cell references

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

Q: Why is CIP growing rapidly? A: High CIP indicates significant capital expansion - new facilities, manufacturing plants, or major projects.

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

Related Functions