Stock Analysis on Net

Lowe’s Cos. Inc. (NYSE:LOW)

Analysis of Property, Plant and Equipment

Microsoft Excel

Property, Plant and Equipment Disclosure

Lowe’s Cos. Inc., balance sheet: property, plant and equipment

US$ in millions

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
Land 6,785 6,793 7,278 7,315 7,200 7,196
Buildings and building improvements 18,039 17,784 18,433 18,090 17,862 18,052
Equipment 10,238 9,541 10,533 10,466 10,377 10,090
Construction in progress 708 793 715 831 506 525
Property, cost 35,770 34,911 36,959 36,702 35,945 35,863
Accumulated depreciation (18,117) (17,344) (17,888) (17,547) (17,276) (17,431)
Property, less accumulated depreciation 17,653 17,567 19,071 19,155 18,669 18,432

Based on: 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01).

Item Description The company
Property, cost Amount before accumulated depreciation, depletion and amortization of physical assets used in the normal conduct of business and not intended for resale. Examples include, but are not limited to, land, buildings, machinery and equipment, office equipment, and furniture and fixtures. Lowe’s Cos. Inc. property, cost decreased from 2022 to 2023 but then slightly increased from 2023 to 2024.
Property, less accumulated depreciation Amount after accumulated depreciation, depletion and amortization of physical assets used in the normal conduct of business to produce goods and services and not intended for resale. Examples include, but are not limited to, land, buildings, machinery and equipment, office equipment, and furniture and fixtures. Lowe’s Cos. Inc. property, less accumulated depreciation decreased from 2022 to 2023 but then slightly increased from 2023 to 2024.

Asset Age Ratios (Summary)

Lowe’s Cos. Inc., asset age ratios

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
Average age ratio 62.50% 61.68% 60.27% 59.71% 60.10% 60.81%
Estimated total useful life (years) 15 15 16 20 21 20
Estimated age, time elapsed since purchase (years) 10 9 10 12 12 12
Estimated remaining life (years) 6 6 7 8 8 8

Based on: 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01).

Asset age ratio Description The company
Average age ratio As long as straight-line depreciation is used, this is an accurate estimate of asset age as a percentage of depreciable life. The relative age is a useful measure of whether the company fixed asset base is old or new. Newer assets are likely to be more efficient. Lowe’s Cos. Inc. average age ratio of depreciable property, plant and equipment deteriorated from 2022 to 2023 and from 2023 to 2024.
Estimated total useful life Over longer time periods, this ratio is a useful measure of company depreciation policy and can be used for comparisons with competitors. Lowe’s Cos. Inc. estimated total useful life of depreciable property, plant and equipment decreased from 2022 to 2023 but then slightly increased from 2023 to 2024.
Estimated time elapsed since purchase The approximate age in years of a company fixed assets. Useful for comparison purposes. Lowe’s Cos. Inc. estimated time elapsed since purchase of depreciable property, plant and equipment improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024 not reaching 2022 level.
Estimated remaining life Lowe’s Cos. Inc. estimated remaining life of depreciable property, plant and equipment decreased from 2022 to 2023 but then slightly increased from 2023 to 2024.

Average Age

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
Selected Financial Data (US$ in millions)
Accumulated depreciation 18,117 17,344 17,888 17,547 17,276 17,431
Property, cost 35,770 34,911 36,959 36,702 35,945 35,863
Land 6,785 6,793 7,278 7,315 7,200 7,196
Asset Age Ratio
Average age1 62.50% 61.68% 60.27% 59.71% 60.10% 60.81%

Based on: 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01).

2024 Calculations

1 Average age = 100 × Accumulated depreciation ÷ (Property, cost – Land)
= 100 × 18,117 ÷ (35,7706,785) = 62.50%

Asset age ratio Description The company
Average age As long as straight-line depreciation is used, this is an accurate estimate of asset age as a percentage of depreciable life. The relative age is a useful measure of whether the company fixed asset base is old or new. Newer assets are likely to be more efficient. Lowe’s Cos. Inc. average age ratio of depreciable property, plant and equipment deteriorated from 2022 to 2023 and from 2023 to 2024.

Estimated Total Useful Life

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
Selected Financial Data (US$ in millions)
Property, cost 35,770 34,911 36,959 36,702 35,945 35,863
Land 6,785 6,793 7,278 7,315 7,200 7,196
Depreciation expense 1,900 1,900 1,800 1,500 1,400 1,400
Asset Age Ratio (Years)
Estimated total useful life1 15 15 16 20 21 20

Based on: 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01).

2024 Calculations

1 Estimated total useful life = (Property, cost – Land) ÷ Depreciation expense
= (35,7706,785) ÷ 1,900 = 15

Asset age ratio Description The company
Estimated total useful life Over longer time periods, this ratio is a useful measure of company depreciation policy and can be used for comparisons with competitors. Lowe’s Cos. Inc. estimated total useful life of depreciable property, plant and equipment decreased from 2022 to 2023 but then slightly increased from 2023 to 2024.

Estimated Age, Time Elapsed since Purchase

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
Selected Financial Data (US$ in millions)
Accumulated depreciation 18,117 17,344 17,888 17,547 17,276 17,431
Depreciation expense 1,900 1,900 1,800 1,500 1,400 1,400
Asset Age Ratio (Years)
Time elapsed since purchase1 10 9 10 12 12 12

Based on: 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01).

2024 Calculations

1 Time elapsed since purchase = Accumulated depreciation ÷ Depreciation expense
= 18,117 ÷ 1,900 = 10

Asset age ratio Description The company
Estimated time elapsed since purchase The approximate age in years of a company fixed assets. Useful for comparison purposes. Lowe’s Cos. Inc. estimated time elapsed since purchase of depreciable property, plant and equipment improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024 not reaching 2022 level.

Estimated Remaining Life

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
Selected Financial Data (US$ in millions)
Property, less accumulated depreciation 17,653 17,567 19,071 19,155 18,669 18,432
Land 6,785 6,793 7,278 7,315 7,200 7,196
Depreciation expense 1,900 1,900 1,800 1,500 1,400 1,400
Asset Age Ratio (Years)
Estimated remaining life1 6 6 7 8 8 8

Based on: 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01).

2024 Calculations

1 Estimated remaining life = (Property, less accumulated depreciation – Land) ÷ Depreciation expense
= (17,6536,785) ÷ 1,900 = 6

Asset age ratio Description The company
Estimated remaining life Lowe’s Cos. Inc. estimated remaining life of depreciable property, plant and equipment decreased from 2022 to 2023 but then slightly increased from 2023 to 2024.