Building And Improvements (Historical)

Returns buildings and building improvements from historical balance sheets.

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

  • Subject to depreciation over useful life
  • Important for retail, manufacturing, real estate companies
  • Part of property, plant & equipment

Examples

=hf_Building_and_improvements("WMT", 2023, 4)
Walmart Q4 2023
=hf_Building_and_improvements("TGT", "ly", 2)
Target last year Q2
=hf_Building_and_improvements(A1, B1, C1)
Cell references

When to Use

  • Real estate analysis
  • Fixed asset breakdown
  • Depreciation analysis
  • Capital intensity analysis

When NOT to Use

Scenario Use Instead
Need total PP&E hf_Gross_fixed_assets_plant_property_and_equipment()
Need land hf_Land_and_improvements()
Need net fixed assets hf_Total_fixed_assets()

Common Issues & FAQ

Q: What's included in building improvements? A: Renovations, structural changes, HVAC upgrades, and other capital improvements to buildings.

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

Related Functions