Stock Analysis on Net

Tesla Inc. (NASDAQ:TSLA)

Analysis of Property, Plant and Equipment

Microsoft Excel

Property, Plant and Equipment Disclosure

Tesla Inc., balance sheet: property, plant and equipment

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Machinery, equipment, vehicles and office furniture 13,558 9,953 8,493 7,167
Tooling 2,579 2,188 1,811 1,493
Leasehold improvements 2,366 1,826 1,421 1,087
Land and buildings 7,751 4,675 3,662 3,024
Computer equipment, hardware and software 2,072 1,414 856 595
Construction in progress 4,263 5,559 1,621 764
Property, plant and equipment, gross 32,589 25,615 17,864 14,130
Accumulated depreciation (9,041) (6,731) (5,117) (3,734)
Property, plant and equipment, net 23,548 18,884 12,747 10,396

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

Item Description The company
Property, plant and equipment, gross 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. Tesla Inc. property, plant and equipment, gross increased from 2021 to 2022 but then decreased significantly from 2022 to 2023.
Property, plant and equipment, net 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. Tesla Inc. property, plant and equipment, net increased from 2021 to 2022 but then decreased significantly from 2022 to 2023.

Asset Age Ratios (Summary)

Tesla Inc., asset age ratios

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Average age ratio 27.74% 26.28% 28.64% 26.43%
Estimated total useful life (years) 13 13 11 10
Estimated age, time elapsed since purchase (years) 4 4 3 3
Estimated remaining life (years) 10 10 8 8

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

Asset age ratio Description The company

Average Age

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Accumulated depreciation 9,041 6,731 5,117 3,734
Property, plant and equipment, gross 32,589 25,615 17,864 14,130
Asset Age Ratio
Average age1 27.74% 26.28% 28.64% 26.43%

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

2023 Calculations

1 Average age = 100 × Accumulated depreciation ÷ Property, plant and equipment, gross
= 100 × 0 ÷ 0 =


Estimated Total Useful Life

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Property, plant and equipment, gross 32,589 25,615 17,864 14,130
Depreciation expense 2,420 1,910 1,570 1,370
Asset Age Ratio (Years)
Estimated total useful life1 13 13 11 10

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

2023 Calculations

1 Estimated total useful life = Property, plant and equipment, gross ÷ Depreciation expense
= 0 ÷ 0 =


Estimated Age, Time Elapsed since Purchase

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Accumulated depreciation 9,041 6,731 5,117 3,734
Depreciation expense 2,420 1,910 1,570 1,370
Asset Age Ratio (Years)
Time elapsed since purchase1 4 4 3 3

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

2023 Calculations

1 Time elapsed since purchase = Accumulated depreciation ÷ Depreciation expense
= 0 ÷ 0 =


Estimated Remaining Life

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Property, plant and equipment, net 23,548 18,884 12,747 10,396
Depreciation expense 2,420 1,910 1,570 1,370
Asset Age Ratio (Years)
Estimated remaining life1 10 10 8 8

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

2023 Calculations

1 Estimated remaining life = Property, plant and equipment, net ÷ Depreciation expense
= 0 ÷ 0 =