Microsoft Excel LibreOffice Calc

Common-Size Statement of Financial Position, Assets

Difficulty: Beginner

Caterpillar Inc., Common-Size Consolidated Statement of Financial Position, Assets

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Cash and short-term investments 10.73    9.60    8.23    8.67    7.16   
Receivables, trade and other 9.66    8.01    8.53    9.14    9.91   
Receivables, finance 11.38    11.41    11.45    10.66    10.32   
Deferred and refundable income taxes         1.94    2.05    1.83   
Prepaid expenses and other current assets 2.30    2.25    1.33    0.97    1.06   
Inventories 13.02    11.53    12.36    14.41    14.87   
Current assets 47.09% 42.79% 43.85% 45.90% 45.16%
Property, plant and equipment, net 18.39    20.51    20.50    19.58    20.11   
Long-term receivables, trade and other 1.29    1.38    1.49    1.61    1.65   
Long-term receivables, finance 17.60    18.15    17.39    17.29    17.58   
Noncurrent deferred and refundable income taxes 2.20    3.73    2.11    1.66    0.70   
Intangible assets 2.74    3.14    3.59    3.63    4.24   
Goodwill 8.06    8.06    8.43    7.90    8.19   
Other assets 2.63    2.24    2.65    2.43    2.38   
Noncurrent assets 52.91% 57.21% 56.15% 54.10% 54.84%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00%