Microsoft Excel LibreOffice Calc

Eli Lilly & Co. (LLY)

Current Ratio
since 2005

Difficulty: Beginner

Calculation

Eli Lilly & Co., current ratio, long-term trends, calculation

Microsoft Excel LibreOffice Calc
Current Ratio = Current assets1 ÷ Current liabilities1
Dec 31, 2005 1.89 = 10,795,800  ÷ 5,716,300 
Dec 31, 2006 1.91 = 9,694,400  ÷ 5,085,500 
Dec 31, 2007 2.33 = 12,256,900  ÷ 5,268,300 
Dec 31, 2008 0.95 = 12,453,300  ÷ 13,109,700 
Dec 31, 2009 1.90 = 12,486,500  ÷ 6,568,100 
Dec 31, 2010 2.09 = 14,840,000  ÷ 7,101,400 
Dec 31, 2011 1.60 = 14,248,200  ÷ 8,930,900 
Dec 31, 2012 1.55 = 13,038,700  ÷ 8,389,500 
Dec 31, 2013 1.47 = 13,104,700  ÷ 8,916,600 
Dec 31, 2014 1.09 = 12,179,800  ÷ 11,207,500 
Dec 31, 2015 1.53 = 12,573,600  ÷ 8,229,600 
Dec 31, 2016 1.37 = 15,101,400  ÷ 10,986,600 
Dec 31, 2017 1.32 = 19,202,100  ÷ 14,535,900 

1 USD $ in thousands

Source: Based on data from Eli Lilly & Co. Annual Reports

Comparison to Competitors

Eli Lilly & Co., current ratio, long-term trends, comparison to competitors

Microsoft Excel LibreOffice Calc
Eli Lilly & Co. Abbott Laboratories AbbVie Inc. Allergan PLC Amgen Inc. Biogen Inc. Bristol-Myers Squibb Co. Celgene Corp. Gilead Sciences Inc. Johnson & Johnson Merck & Co. Inc. Pfizer Inc. Regeneron Pharmaceuticals Inc.
Dec 31, 2005 1.89 1.54 – 5.54 2.57 2.78 1.78 7.17 6.79 2.48 1.58 1.47 8.46
Dec 31, 2006 1.91 0.94 – 1.83 1.67 2.94 1.59 9.64 3.18 1.20 1.20 2.20 10.44
Dec 31, 2007 2.33 1.54 – 2.64 2.11 1.08 1.20 7.12 4.11 1.51 1.23 2.15 2.81
Dec 31, 2008 0.95 1.47 – 3.03 3.12 2.66 2.20 5.39 3.52 1.65 1.35 1.59 6.23
Dec 31, 2009 1.90 1.79 – 1.68 4.89 3.47 2.21 7.77 2.57 1.82 1.80 1.66 4.55
Dec 31, 2010 2.09 1.29 – 2.19 3.52 2.42 1.97 4.06 2.32 2.05 1.86 2.11 3.28
Dec 31, 2011 1.60 1.54 – 1.40 4.80 3.26 1.97 2.83 5.53 2.38 2.04 2.06 4.40
Dec 31, 2012 1.55 2.36 2.27 1.43 3.81 1.96 1.15 3.27 1.44 1.90 1.90 2.15 7.37
Dec 31, 2013 1.47 2.02 2.59 1.35 3.44 1.81 1.52 3.88 1.15 2.20 2.00 2.41 6.01
Dec 31, 2014 1.09 1.45 1.41 1.37 4.95 2.11 1.73 4.60 3.07 2.36 1.77 2.67 3.31
Dec 31, 2015 1.53 1.54 1.50 1.03 4.44 2.60 1.30 4.77 2.50 2.17 1.55 1.49 3.59
Dec 31, 2016 1.37 4.02 1.65 2.27 4.11 2.55 1.55 3.67 2.22 2.47 1.78 1.25 2.56
Dec 31, 2017 1.32 2.26 1.28 1.16 5.49 2.34 1.55 4.99 2.74 1.41 1.33 1.35 3.82

Source: Based on data from Eli Lilly & Co. Annual Reports

Comparison to Pharmaceuticals & Biotechnology Sector

Eli Lilly & Co., current ratio, long-term trends, comparison to Pharmaceuticals & Biotechnology sector

Microsoft Excel LibreOffice Calc
Eli Lilly & Co. Pharmaceuticals & Biotechnology
Dec 31, 2005 1.89 1.83
Dec 31, 2006 1.91 1.58
Dec 31, 2007 2.33 1.74
Dec 31, 2008 0.95 1.65
Dec 31, 2009 1.90 1.95
Dec 31, 2010 2.09 2.04
Dec 31, 2011 1.60 2.24
Dec 31, 2012 1.55 2.08
Dec 31, 2013 1.47 2.13
Dec 31, 2014 1.09 2.19
Dec 31, 2015 1.53 1.92
Dec 31, 2016 1.37 2.14
Dec 31, 2017 1.32 1.82

Source: Based on data from Eli Lilly & Co. Annual Reports

Comparison to Health Care Industry

Eli Lilly & Co., current ratio, long-term trends, comparison to Health Care industry

Microsoft Excel LibreOffice Calc
Eli Lilly & Co. Health Care
Dec 31, 2005 1.89 1.64
Dec 31, 2006 1.91 1.49
Dec 31, 2007 2.33 1.63
Dec 31, 2008 0.95 1.54
Dec 31, 2009 1.90 1.77
Dec 31, 2010 2.09 1.83
Dec 31, 2011 1.60 1.99
Dec 31, 2012 1.55 1.80
Dec 31, 2013 1.47 1.89
Dec 31, 2014 1.09 1.84
Dec 31, 2015 1.53 1.65
Dec 31, 2016 1.37 1.75
Dec 31, 2017 1.32 1.52

Source: Based on data from Eli Lilly & Co. Annual Reports