Paying users zone. Data is covered by hidden.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey

This is a one-time payment. There is no automatic renewal.

Microsoft Excel LibreOffice Calc

Alphabet Inc. (GOOG)


Analysis of Property, Plant and Equipment

Difficulty: Advanced


Property, Plant and Equipment Accounting Policy

Property and equipment includes the following categories: land and buildings, information technology assets, construction in progress, leasehold improvements, and furniture and fixtures. Land and buildings include land, offices, data centers and related building improvements. Information technology assets include servers and network equipment. Alphabet accounts for property and equipment at cost less accumulated depreciation. Alphabet computes depreciation using the straight-line method over the estimated useful lives of the assets. Alphabet depreciates buildings over periods of seven to 25 years. Alphabet generally depreciates information technology assets over periods of three to five years (specifically, three years for servers and three to five years for network equipment).

Alphabet depreciates leasehold improvements over the shorter of the remaining lease term or the estimated useful lives of the assets. Construction in progress is the construction or development of property and equipment that have not yet been placed in service for Alphabet’s intended use. Depreciation for equipment, buildings, and leasehold improvements commences once they are ready for Alphabet’s intended use. Land is not depreciated.

Source: 10-K (filing date: 2019-02-05).


Property, Plant and Equipment Disclosure

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

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Land and buildings hidden hidden hidden hidden hidden
Information technology assets hidden hidden hidden hidden hidden
Construction in progress hidden hidden hidden hidden hidden
Leasehold improvements hidden hidden hidden hidden hidden
Furniture and fixtures hidden hidden hidden hidden hidden
Property and equipment, gross hidden hidden hidden hidden hidden
Accumulated depreciation hidden hidden hidden hidden hidden
Property and equipment, net hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-05), 10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-09).

Item Description The company
Property 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. Alphabet Inc.’s property and equipment, gross increased from 2016 to 2017 and from 2017 to 2018.
Property 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. Alphabet Inc.’s property and equipment, net increased from 2016 to 2017 and from 2017 to 2018.

Property, Plant and Equipment Ratios (Summary)

Alphabet Inc., Property, Plant and Equipment Ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Average age hidden hidden hidden hidden hidden
Estimated total useful life (years) hidden hidden hidden hidden hidden
Estimated age, time elapsed since purchase (years) hidden hidden hidden hidden hidden
Estimated remaining life (years) hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-05), 10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-09).

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’s fixed asset base is old or new. Newer assets are likely to be more efficient. Alphabet Inc.’s average age of depreciable property, plant and equipment deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.
Estimated total useful life Over longer time periods, this ratio is a useful measure of company’s depreciation policy and can be used for comparisons with competitors. Alphabet Inc.’s estimated total useful life of depreciable property, plant and equipment increased from 2016 to 2017 and from 2017 to 2018.
Estimated time elapsed since purchase The approximate age in years of a company’s fixed assets. Useful for comparison purposes. Alphabet Inc.’s estimated time elapsed since purchase of depreciable property, plant and equipment deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.
Estimated remaining life Alphabet Inc.’s estimated remaining life of depreciable property, plant and equipment increased from 2016 to 2017 and from 2017 to 2018.

Average Age

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Accumulated depreciation hidden hidden hidden hidden hidden
Property and equipment, gross hidden hidden hidden hidden hidden
Ratio
Average age1 hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-05), 10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-09).

2018 Calculations

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

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’s fixed asset base is old or new. Newer assets are likely to be more efficient. Alphabet Inc.’s average age of depreciable property, plant and equipment deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.

Estimated Total Useful Life

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Property and equipment, gross hidden hidden hidden hidden hidden
Depreciation and impairment of property and equipment hidden hidden hidden hidden hidden
Ratio
Estimated total useful life (years)1 hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-05), 10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-09).

2018 Calculations

1 Estimated total useful life (years) = Property and equipment, gross ÷ Depreciation and impairment of property and equipment
= hidden ÷ hidden = hidden

Ratio Description The company
Estimated total useful life Over longer time periods, this ratio is a useful measure of company’s depreciation policy and can be used for comparisons with competitors. Alphabet Inc.’s estimated total useful life of depreciable property, plant and equipment increased from 2016 to 2017 and from 2017 to 2018.

Estimated Age, Time Elapsed since Purchase

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Accumulated depreciation hidden hidden hidden hidden hidden
Depreciation and impairment of property and equipment hidden hidden hidden hidden hidden
Ratio
Time elapsed since purchase (years)1 hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-05), 10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-09).

2018 Calculations

1 Time elapsed since purchase (years) = Accumulated depreciation ÷ Depreciation and impairment of property and equipment
= hidden ÷ hidden = hidden

Ratio Description The company
Estimated time elapsed since purchase The approximate age in years of a company’s fixed assets. Useful for comparison purposes. Alphabet Inc.’s estimated time elapsed since purchase of depreciable property, plant and equipment deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.

Estimated Remaining Life

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Property and equipment, net hidden hidden hidden hidden hidden
Depreciation and impairment of property and equipment hidden hidden hidden hidden hidden
Ratio
Estimated remaining life (years)1 hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-05), 10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-09).

2018 Calculations

1 Estimated remaining life (years) = Property and equipment, net ÷ Depreciation and impairment of property and equipment
= hidden ÷ hidden = hidden

Ratio Description The company
Estimated remaining life Alphabet Inc.’s estimated remaining life of depreciable property, plant and equipment increased from 2016 to 2017 and from 2017 to 2018.