Land And Improvements (Historical)

Returns land and land 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

  • Land is not depreciated (improvements may be)
  • Important for real estate intensive businesses
  • Part of property, plant & equipment

Examples

=hf_Land_and_improvements("WMT", 2023, 4)
Walmart Q4 2023
=hf_Land_and_improvements("HD", "ly", 2)
Home Depot last year Q2
=hf_Land_and_improvements(A1, B1, C1)
Cell references

When to Use

  • Real estate analysis
  • Fixed asset breakdown
  • Capital intensity analysis
  • Property valuation

When NOT to Use

Scenario Use Instead
Need total PP&E hf_Gross_fixed_assets_plant_property_and_equipment()
Need buildings hf_Building_and_improvements()
Need net fixed assets hf_Total_fixed_assets()

Common Issues & FAQ

Q: Why doesn't land depreciate? A: Land has an indefinite useful life and is not depreciated under accounting standards.

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

Related Functions