Paying users zone. Data is covered by hidden.

  • Get to Comcast Corp. for $19.99, or

  • get to whole website for at least 3 months from $49.99.

Microsoft Excel LibreOffice Calc


Analysis of Property, Plant and Equipment

Difficulty: Advanced


Property, Plant and Equipment Disclosure

Comcast Corp., Statement of Financial Position, Property, Plant and Equipment

USD $ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Cable distribution system hidden hidden hidden hidden hidden
Customer premises equipment hidden hidden hidden hidden hidden
Other equipment hidden hidden hidden hidden hidden
Buildings and leasehold improvements hidden hidden hidden hidden hidden
Construction in process hidden hidden hidden hidden hidden
Land hidden hidden hidden hidden hidden
Property and equipment, at cost hidden hidden hidden hidden hidden
Accumulated depreciation hidden hidden hidden hidden hidden
Property and equipment, net hidden hidden hidden hidden hidden

Source: Based on data from Comcast Corp. Annual Reports

Item Description The company
Other equipment Carrying amount as of the balance sheet date of long-lived, depreciable asset used in production process to produce goods and services. Comcast Corp.'s other equipment increased from 2015 to 2016 and from 2016 to 2017.
Buildings and leasehold improvements Carrying amount as of the balance sheet date of long-lived, depreciable assets that include building structures held for productive use including any addition, improvement, or renovation to the structure, such as interior masonry, interior flooring, electrical, and plumbing. Comcast Corp.'s buildings and leasehold improvements declined from 2015 to 2016 but then increased from 2016 to 2017 exceeding 2015 level.
Construction in process Carrying amount at the balance sheet date of long-lived asset under construction that include construction costs to date on capital projects that have not been completed and assets being constructed that are not ready to be placed into service. Comcast Corp.'s construction in process increased from 2015 to 2016 but then slightly declined from 2016 to 2017.
Land Carrying amount as of the balance sheet date of real estate held for productive use. This excludes land held for sale. Comcast Corp.'s land increased from 2015 to 2016 and from 2016 to 2017.
Property and equipment, at cost Carrying amount at the balance sheet date for long-lived physical assets used in the normal conduct of business and not intended for resale. This can include land, physical structures, machinery, vehicles, furniture, computer equipment, construction in progress, and similar items. Amount does not include depreciation. Comcast Corp.'s property and equipment, at cost increased from 2015 to 2016 and from 2016 to 2017.
Property and equipment, net Tangible assets that are held by an entity for use in the production or supply of goods and services, for rental to others, or for administrative purposes and that are expected to provide economic benefit for more than one year; net of accumulated depreciation. Examples include land, buildings, and production equipment. Comcast Corp.'s property and equipment, net increased from 2015 to 2016 and from 2016 to 2017.

Property, Plant and Equipment Ratios (Summary)

Comcast Corp., Property, Plant and Equipment Ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
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
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. Comcast Corp.'s average age of depreciable property, plant and equipment improved from 2015 to 2016 and from 2016 to 2017.
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. Comcast Corp.'s estimated total useful life of depreciable property, plant and equipment declined from 2015 to 2016 and from 2016 to 2017.
Estimated time elapsed since purchase The approximate age in years of a company's fixed assets. Useful for comparison purposes. Comcast Corp.'s estimated time elapsed since purchase of depreciable property, plant and equipment improved from 2015 to 2016 and from 2016 to 2017.
Estimated remaining life Comcast Corp.'s estimated remaining life of depreciable property, plant and equipment declined from 2015 to 2016 but then slightly increased from 2016 to 2017.

Average Age

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in millions)
Accumulated depreciation hidden hidden hidden hidden hidden
Property and equipment, at cost hidden hidden hidden hidden hidden
Land hidden hidden hidden hidden hidden
Ratio
Average age1 hidden% hidden% hidden% hidden% hidden%

2017 Calculations

1 Average age = 100 × Accumulated depreciation ÷ (Property and equipment, at cost – Land)
= 100 × hidden ÷ (hiddenhidden) = 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. Comcast Corp.'s average age of depreciable property, plant and equipment improved from 2015 to 2016 and from 2016 to 2017.

Estimated Total Useful Life

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in millions)
Property and equipment, at cost hidden hidden hidden hidden hidden
Land hidden hidden hidden hidden hidden
Depreciation expense hidden hidden hidden hidden hidden
Ratio
Estimated total useful life (years)1 hidden hidden hidden hidden hidden

2017 Calculations

1 Estimated total useful life (years) = (Property and equipment, at cost – Land) ÷ Depreciation expense
= (hiddenhidden) ÷ 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. Comcast Corp.'s estimated total useful life of depreciable property, plant and equipment declined from 2015 to 2016 and from 2016 to 2017.

Estimated Age, Time Elapsed Since Purchase

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in millions)
Accumulated depreciation hidden hidden hidden hidden hidden
Depreciation expense hidden hidden hidden hidden hidden
Ratio
Time elapsed since purchase (years)1 hidden hidden hidden hidden hidden

2017 Calculations

1 Time elapsed since purchase (years) = Accumulated depreciation ÷ Depreciation expense
= 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. Comcast Corp.'s estimated time elapsed since purchase of depreciable property, plant and equipment improved from 2015 to 2016 and from 2016 to 2017.

Estimated Remaining Life

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in millions)
Property and equipment, net hidden hidden hidden hidden hidden
Land hidden hidden hidden hidden hidden
Depreciation expense hidden hidden hidden hidden hidden
Ratio
Estimated remaining life (years)1 hidden hidden hidden hidden hidden

2017 Calculations

1 Estimated remaining life (years) = (Property and equipment, net – Land) ÷ Depreciation expense
= (hiddenhidden) ÷ hidden = hidden

Ratio Description The company
Estimated remaining life Comcast Corp.'s estimated remaining life of depreciable property, plant and equipment declined from 2015 to 2016 but then slightly increased from 2016 to 2017.