Paying users zone. Data is covered by hidden.

  • Get to CVS Health Corp. for $15.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 Accounting Policy

Property, equipment and improvements to leased premises are depreciated using the straight-line method over the estimated useful lives of the assets, or when applicable, the term of the lease, whichever is shorter. Estimated useful lives generally range from 10 to 40 years for buildings, building improvements and leasehold improvements and 3 to 10 years for fixtures, equipment and internally developed software. Repair and maintenance costs are charged directly to expense as incurred. Major renewals or replacements that substantially extend the useful life of an asset are capitalized and depreciated. Application development stage costs for significant internally developed software projects are capitalized and depreciated.

The gross amount of property and equipment under capital leases was $588 million and $547 million as of December 31, 2017 and 2016, respectively. Accumulated amortization of property and equipment under capital lease was $140 million and $119 million as of December 31, 2017 and 2016, respectively. Amortization of property and equipment under capital lease is included within depreciation expense. Depreciation expense totaled $1.7 billion in both 2017 and 2016, and $1.5 billion in 2015.

Source: CVS Health Corp., Annual Report


Property, Plant and Equipment Disclosure

CVS Health Corp., Statement of Financial Position, Property, Plant and Equipment

USD $ in millions

Microsoft Excel LibreOffice Calc

Source: Based on data from CVS Health Corp. Annual Reports

Item Description The company
Land Carrying amount as of the balance sheet date of real estate held for productive use. This excludes land held for sale. CVS Health Corp.'s land increased from 2015 to 2016 but then slightly declined from 2016 to 2017.
Building and 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. CVS Health Corp.'s building and improvements increased from 2015 to 2016 and from 2016 to 2017.
Fixtures and equipment Carrying amount as of the balance sheet date of long-lived, depreciable asset used in production process to produce goods and services. CVS Health Corp.'s fixtures and equipment increased from 2015 to 2016 and from 2016 to 2017.
Leasehold improvements Carrying amount at the balance sheet date of long-lived, depreciable asset that is an addition or improvement to assets held under lease arrangement. CVS Health Corp.'s leasehold improvements increased from 2015 to 2016 and from 2016 to 2017.
Property and equipment, gross 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. CVS Health Corp.'s property and equipment, gross 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. CVS Health Corp.'s property and equipment, net increased from 2015 to 2016 and from 2016 to 2017.

Property, Plant and Equipment Ratios (Summary)

CVS Health 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. CVS Health Corp.'s average age of depreciable property, plant and equipment deteriorated 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. CVS Health Corp.'s estimated total useful life of depreciable property, plant and equipment declined from 2015 to 2016 but then increased from 2016 to 2017 exceeding 2015 level.
Estimated time elapsed since purchase The approximate age in years of a company's fixed assets. Useful for comparison purposes. CVS Health Corp.'s estimated time elapsed since purchase of depreciable property, plant and equipment improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.
Estimated remaining life CVS Health 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 and amortization hidden hidden hidden hidden hidden
Property and equipment, gross 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 and amortization ÷ (Property and equipment, gross – 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. CVS Health Corp.'s average age of depreciable property, plant and equipment deteriorated 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, gross 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, gross – 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. CVS Health Corp.'s estimated total useful life of depreciable property, plant and equipment declined from 2015 to 2016 but then increased from 2016 to 2017 exceeding 2015 level.

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 and amortization 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 and amortization ÷ 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. CVS Health Corp.'s estimated time elapsed since purchase of depreciable property, plant and equipment improved from 2015 to 2016 but then deteriorated significantly 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 CVS Health Corp.'s estimated remaining life of depreciable property, plant and equipment declined from 2015 to 2016 but then slightly increased from 2016 to 2017.