Microsoft Excel LibreOffice Calc

Bristol-Myers Squibb Co. (BMY)


Common-Size Balance Sheet: Assets

Beginner level

Bristol-Myers Squibb Co., common-size consolidated balance sheet: assets

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Cash and cash equivalents 19.75 16.16 12.57 7.51 16.51
Marketable securities 5.64 4.15 6.27 5.94 5.52
Net trade receivables 13.25 12.96 11.20 9.29 6.22
Alliance receivables 1.13 1.56 2.68 3.02 2.63
Prepaid and refundable income taxes 0.62 2.06 1.86 0.57 0.53
Royalties, VAT and other 2.05 2.21 0.71 0.66 0.66
Receivables 17.05% 18.78% 16.44% 13.54% 10.04%
Inventories 3.42 3.48 3.68 3.85 4.62
Deferred income taxes 0.00 0.00 0.00 0.00 4.87
Prepaid expenses and other 3.19 1.72 1.69 1.97 1.72
Current assets 49.05% 44.27% 40.66% 32.81% 43.28%
Property, plant and equipment 14.37 14.91 14.77 13.90 13.09
Goodwill 18.69 20.46 20.40 21.67 20.82
Other intangible assets 3.12 3.61 4.11 4.47 5.19
Deferred income taxes 3.92 4.80 8.89 8.96 2.71
Marketable securities 5.07 7.39 8.07 14.68 13.06
Other assets 5.79 4.57 3.11 3.52 1.84
Non-current assets 50.95% 55.73% 59.34% 67.19% 56.72%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00%

Based on: 10-K (filing date: 2019-02-25), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-12), 10-K (filing date: 2015-02-13).

Balance sheet item Description The company
Current assets Sum of the carrying amounts as of the balance sheet date of all assets that are expected to be realized in cash, sold, or consumed within one year (or the normal operating cycle, if longer). Assets are probable future economic benefits obtained or controlled by an entity as a result of past transactions or events. Bristol-Myers Squibb Co.’s current assets as a percentage of total assets increased from 2016 to 2017 and from 2017 to 2018.
Property, plant and equipment 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. Bristol-Myers Squibb Co.’s property, plant and equipment as a percentage of total assets increased from 2016 to 2017 but then decreased significantly from 2017 to 2018.
Non-current assets Sum of the carrying amounts as of the balance sheet date of all assets that are expected to be realized in cash, sold or consumed after one year or beyond the normal operating cycle, if longer. Bristol-Myers Squibb Co.’s non-current assets as a percentage of total assets decreased from 2016 to 2017 and from 2017 to 2018.