Microsoft Excel LibreOffice Calc

Abbott Laboratories (ABT)

Selected Financial Data
since 2005

Low level of difficulty

Income Statement

Abbott Laboratories, selected items from income statement, long-term trends

US$ in millions

Microsoft Excel LibreOffice Calc
12 months ended Net sales Operating earnings Net earnings
Dec 31, 2018 30,578  3,650  2,368 
Dec 31, 2017 27,390  1,726  477 
Dec 31, 2016 20,853  3,185  1,400 
Dec 31, 2015 20,405  2,867  4,423 
Dec 31, 2014 20,247  2,599  2,284 
Dec 31, 2013 21,848  2,629  2,576 
Dec 31, 2012 39,874  8,085  5,963 
Dec 31, 2011 38,851  5,752  4,728 
Dec 31, 2010 35,167  6,088  4,626 
Dec 31, 2009 30,765  6,236  5,746 
Dec 31, 2008 29,528  5,694  4,881 
Dec 31, 2007 25,914  4,579  3,606 
Dec 31, 2006 22,476  2,042  1,717 
Dec 31, 2005 22,338  4,362  3,372 

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-16), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-21), 10-K (filing date: 2013-02-15), 10-K (filing date: 2012-02-21), 10-K (filing date: 2011-02-18), 10-K (filing date: 2010-02-19), 10-K (filing date: 2009-02-20), 10-K (filing date: 2008-02-19), 10-K (filing date: 2007-02-23), 10-K (filing date: 2006-02-22).

Balance Sheet: Assets

Abbott Laboratories, selected items from assets, long-term trends

US$ in millions

Microsoft Excel LibreOffice Calc
Current assets Total assets
Dec 31, 2018 14,632  67,173 
Dec 31, 2017 20,147  76,250 
Dec 31, 2016 26,776  52,666 
Dec 31, 2015 14,155  41,247 
Dec 31, 2014 15,261  41,275 
Dec 31, 2013 19,247  42,953 
Dec 31, 2012 31,323  67,235 
Dec 31, 2011 23,769  60,277 
Dec 31, 2010 22,318  59,462 
Dec 31, 2009 23,314  52,417 
Dec 31, 2008 17,043  42,419 
Dec 31, 2007 14,043  39,714 
Dec 31, 2006 11,282  36,178 
Dec 31, 2005 11,386  29,141 

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-16), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-21), 10-K (filing date: 2013-02-15), 10-K (filing date: 2012-02-21), 10-K (filing date: 2011-02-18), 10-K (filing date: 2010-02-19), 10-K (filing date: 2009-02-20), 10-K (filing date: 2008-02-19), 10-K (filing date: 2007-02-23), 10-K (filing date: 2006-02-22).

Balance Sheet: Liabilities and Stockholders’ Equity

Abbott Laboratories, selected items from liabilities and stockholders’ equity, long-term trends

US$ in millions

Microsoft Excel LibreOffice Calc
Current liabilities Total debt Total Abbott shareholders’ investment
Dec 31, 2018 9,012  19,566  30,524 
Dec 31, 2017 8,912  27,924  30,897 
Dec 31, 2016 6,660  22,006  20,538 
Dec 31, 2015 9,186  9,001  21,211 
Dec 31, 2014 10,532  7,845  21,526 
Dec 31, 2013 9,507  6,561  25,171 
Dec 31, 2012 13,280  20,476  26,721 
Dec 31, 2011 15,480  15,415  24,440 
Dec 31, 2010 17,262  18,918  22,388 
Dec 31, 2009 13,049  16,456  22,856 
Dec 31, 2008 11,592  11,445  17,480 
Dec 31, 2007 9,103  12,214  17,779 
Dec 31, 2006 11,951  12,411  14,054 
Dec 31, 2005 7,416  6,634  14,415 

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-16), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-21), 10-K (filing date: 2013-02-15), 10-K (filing date: 2012-02-21), 10-K (filing date: 2011-02-18), 10-K (filing date: 2010-02-19), 10-K (filing date: 2009-02-20), 10-K (filing date: 2008-02-19), 10-K (filing date: 2007-02-23), 10-K (filing date: 2006-02-22).

Cash Flow Statement

Abbott Laboratories, selected items from cash flow statement, long-term trends

US$ in millions

Microsoft Excel LibreOffice Calc
12 months ended Net cash from operating activities Net cash (used in) from investing activities Net cash from (used in) financing activities
Dec 31, 2018 6,300  (1,356) (10,391)
Dec 31, 2017 5,570  (9,618) (5,281)
Dec 31, 2016 3,203  (248) 11,147 
Dec 31, 2015 2,966  406  (2,236)
Dec 31, 2014 3,675  (202) (2,742)
Dec 31, 2013 3,324  (3,929) (6,696)
Dec 31, 2012 9,314  (6,081) 716 
Dec 31, 2011 8,970  261  (6,023)
Dec 31, 2010 8,736  (12,188) (1,088)
Dec 31, 2009 7,275  (3,699) 1,002 
Dec 31, 2008 6,995  (2,087) (3,486)
Dec 31, 2007 5,184  (1,136) (2,313)
Dec 31, 2006 5,262  (11,398) 3,622 
Dec 31, 2005 5,047  (720) (2,592)

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-16), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-21), 10-K (filing date: 2013-02-15), 10-K (filing date: 2012-02-21), 10-K (filing date: 2011-02-18), 10-K (filing date: 2010-02-19), 10-K (filing date: 2009-02-20), 10-K (filing date: 2008-02-19), 10-K (filing date: 2007-02-23), 10-K (filing date: 2006-02-22).

Per Share Data

Abbott Laboratories, selected data per share, long-term trends

US$

Microsoft Excel LibreOffice Calc
12 months ended Basic earnings per share 1 Diluted earnings per share 2 Dividend per share 3
Dec 31, 2018 1.34 1.33 1.16
Dec 31, 2017 0.27 0.27 1.08
Dec 31, 2016 0.94 0.94 1.05
Dec 31, 2015 2.94 2.92 0.98
Dec 31, 2014 1.50 1.49 0.90
Dec 31, 2013 1.64 1.62 0.64
Dec 31, 2012 3.76 3.72 1.67
Dec 31, 2011 3.03 3.01 1.92
Dec 31, 2010 2.98 2.96 1.76
Dec 31, 2009 3.71 3.69 1.60
Dec 31, 2008 3.16 3.12 1.44
Dec 31, 2007 2.34 2.31 1.30
Dec 31, 2006 1.12 1.12 1.18
Dec 31, 2005 2.17 2.16 1.10

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-16), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-21), 10-K (filing date: 2013-02-15), 10-K (filing date: 2012-02-21), 10-K (filing date: 2011-02-18), 10-K (filing date: 2010-02-19), 10-K (filing date: 2009-02-20), 10-K (filing date: 2008-02-19), 10-K (filing date: 2007-02-23), 10-K (filing date: 2006-02-22).

1, 2, 3 Data adjusted for splits and stock dividends.