Common-Size Statement of Financial Position, Assets
Quarterly Data

Difficulty: Beginner

3M Co., Common-Size Consolidated Statement of Financial Position, Assets (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Cash and cash equivalents 8.54 7.62 9.05 8.04 8.03 7.82 6.53 7.29 6.78 5.08 4.05 5.50 4.83 9.50 5.84 6.07 5.89 6.26 5.82 7.69 6.96 8.62 8.60
Marketable securities, current 0.91 1.05 1.57 2.83 1.66 0.41 0.42 0.85 1.05 0.53 0.53 0.36 0.46 1.60 3.32 2.00 2.34 2.60 2.56 2.25 2.89 3.84 4.26
Accounts receivable, net 14.30 14.64 13.62 12.93 14.63 14.49 14.18 13.35 13.93 14.04 13.60 12.70 13.86 14.59 14.39 13.55 14.37 14.01 13.71 12.68 13.67 13.31 12.98
Finished goods 5.70 5.38 5.25 5.04 5.57 5.49 5.30 4.95 4.91 5.04 5.15 5.06 5.25 5.62 5.59 5.51 5.64 5.59 5.50 5.34 5.35 5.25 5.22
Work in process 3.62 3.51 3.40 3.21 3.30 3.37 3.24 3.16 3.40 3.51 3.51 3.08 3.19 3.61 3.64 3.46 3.56 3.59 3.49 3.39 3.61 3.58 3.46
Raw materials and supplies 2.58 2.63 2.48 2.37 2.41 2.44 2.31 2.18 2.30 2.32 2.34 2.61 2.72 3.03 2.86 2.88 2.83 2.87 2.85 2.79 2.79 2.65 2.54
Inventories 11.90% 11.52% 11.13% 10.62% 11.28% 11.30% 10.85% 10.29% 10.60% 10.87% 11.00% 10.75% 11.15% 12.26% 12.09% 11.85% 12.04% 12.05% 11.84% 11.52% 11.75% 11.48% 11.22%
Prepaids 2.00 1.94 2.16 2.47 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Other current assets 1.03 1.01 0.89 0.70 3.14 3.21 3.76 3.86 3.40 3.88 3.79 4.27 4.60 4.85 5.21 4.15 4.05 3.92 4.11 3.81 4.25 3.72 3.65
Current assets 38.68% 37.77% 38.41% 37.58% 38.75% 37.23% 35.75% 35.63% 35.77% 34.41% 32.97% 33.58% 34.90% 42.79% 40.85% 37.63% 38.69% 38.84% 38.04% 37.95% 39.53% 40.97% 40.72%
Property, plant and equipment 66.44 67.32 65.26 65.59 69.98 71.54 71.93 71.41 70.90 71.59 71.45 70.60 68.98 72.80 73.34 73.05 70.46 69.02 69.28 68.76 68.05 65.68 66.03
Accumulated depreciation -43.29 -43.81 -42.28 -42.25 -45.41 -46.31 -46.24 -45.53 -45.43 -45.70 -45.33 -44.57 -43.51 -46.07 -46.30 -45.90 -44.53 -43.46 -43.55 -42.97 -42.91 -41.28 -41.58
Property, plant and equipment, net 23.15% 23.51% 22.98% 23.34% 24.57% 25.23% 25.68% 25.88% 25.46% 25.89% 26.12% 26.03% 25.47% 26.73% 27.04% 27.15% 25.93% 25.57% 25.73% 25.79% 25.14% 24.40% 24.44%
Goodwill 27.16 27.48 27.40 27.68 26.17 26.81 27.81 27.86 27.69 28.15 28.42 28.27 28.13 22.25 22.63 22.55 22.01 21.85 21.93 21.89 21.85 21.19 21.30
Intangible assets, net 7.31 7.58 7.48 7.73 6.17 6.48 6.82 7.05 7.11 7.45 7.73 7.95 7.91 4.32 4.56 4.59 4.63 4.72 4.86 5.03 5.19 5.23 5.41
Other assets 3.69 3.67 3.73 3.67 4.33 4.25 3.94 3.58 3.96 4.10 4.75 4.18 3.59 3.91 4.92 8.09 8.75 9.03 9.44 9.34 8.29 8.21 8.14
Non-current assets 61.32% 62.23% 61.59% 62.42% 61.25% 62.77% 64.25% 64.37% 64.23% 65.59% 67.03% 66.42% 65.10% 57.21% 59.15% 62.37% 61.31% 61.16% 61.96% 62.05% 60.47% 59.03% 59.28%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

Based on: 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-05-08), 10-K (filing date: 2018-02-08), 10-Q (filing date: 2017-10-31), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-03), 10-K (filing date: 2017-02-09), 10-Q (filing date: 2016-11-01), 10-Q (filing date: 2016-08-02), 10-Q (filing date: 2016-05-03), 10-K (filing date: 2016-02-11), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30), 10-K (filing date: 2015-02-12), 10-Q (filing date: 2014-10-30), 10-Q (filing date: 2014-07-31), 10-Q (filing date: 2014-05-01), 10-K (filing date: 2014-02-13), 10-Q (filing date: 2013-10-31), 10-Q (filing date: 2013-08-01), 10-Q (filing date: 2013-05-02).