MarketXLS

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

Syntax

=hf_Building_and_improvements(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

Building and improvements value

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

What's included in building improvements?

Renovations, structural changes, HVAC upgrades, and other capital improvements to buildings.

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

Related Functions