Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Eli Lilly & Co. (NYSE:LLY)

Analysis of Solvency Ratios
Quarterly Data

Beginner level

Solvency ratios also known as long-term debt ratios measure a company’s ability to meet long-term obligations.

Solvency Ratios (Summary)

Eli Lilly & Co., solvency ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 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
Debt Ratios
Debt to equity 3.99 5.60 5.88 4.50 5.68 6.44 1.30 0.97 1.06 0.81 1.18 0.90 0.87 0.73 0.74 0.60 0.64 0.54 0.55 0.53 0.55 0.55
Debt to capital 0.80 0.85 0.85 0.82 0.85 0.87 0.57 0.49 0.51 0.45 0.54 0.47 0.47 0.42 0.42 0.37 0.39 0.35 0.35 0.35 0.35 0.36
Debt to assets 0.39 0.42 0.39 0.40 0.41 0.42 0.29 0.28 0.29 0.26 0.30 0.31 0.30 0.27 0.27 0.25 0.26 0.23 0.22 0.22 0.22 0.23
Financial leverage 10.25 13.35 15.07 11.20 13.91 15.32 4.47 3.41 3.67 3.05 3.88 2.89 2.90 2.68 2.77 2.41 2.49 2.31 2.44 2.39 2.46 2.39

Based on: 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-02-19), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-08-02), 10-Q (filing date: 2019-05-02), 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-11-06), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-05-01), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-29), 10-K (filing date: 2016-02-19), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30).

Solvency ratio Description The company
Debt to equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Eli Lilly & Co.’s debt to equity ratio improved from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.
Debt to capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Eli Lilly & Co.’s debt to capital ratio improved from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Eli Lilly & Co.’s debt to assets ratio deteriorated from Q4 2019 to Q1 2020 but then improved from Q1 2020 to Q2 2020 exceeding Q4 2019 level.
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Eli Lilly & Co.’s financial leverage ratio decreased from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Debt to Equity

Eli Lilly & Co., debt to equity calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 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
Selected Financial Data (US$ in thousands)
Short-term borrowings and current maturities of long-term debt 1,263,800  3,248,000  1,499,300  1,563,100  2,068,600  2,354,900  1,131,200  1,002,200  3,049,100  2,304,200  3,706,600  3,538,100  2,444,200  2,609,300  1,937,400  641,500  645,800  648,300  6,100  9,300  10,800  805,400 
Long-term debt, excluding current maturities 15,064,400  13,982,300  13,817,900  13,662,200  13,717,600  13,610,200  11,639,700  11,674,700  9,170,500  9,393,500  9,940,500  9,926,600  9,867,900  7,637,500  8,367,800  8,707,300  8,685,500  7,477,600  7,972,400  8,069,600  7,988,600  7,415,300 
Total debt 16,328,200  17,230,300  15,317,200  15,225,300  15,786,200  15,965,100  12,770,900  12,676,900  12,219,600  11,697,700  13,647,100  13,464,700  12,312,100  10,246,800  10,305,200  9,348,800  9,331,300  8,125,900  7,978,500  8,078,900  7,999,400  8,220,700 
 
Total Eli Lilly and Company shareholders’ equity 4,092,900  3,078,800  2,606,900  3,382,500  2,780,500  2,480,300  9,828,700  13,076,600  11,555,200  14,527,000  11,592,200  14,890,300  14,100,800  14,031,000  14,007,700  15,589,200  14,637,300  15,009,900  14,571,300  15,221,400  14,670,300  14,919,800 
Solvency Ratio
Debt to equity1 3.99 5.60 5.88 4.50 5.68 6.44 1.30 0.97 1.06 0.81 1.18 0.90 0.87 0.73 0.74 0.60 0.64 0.54 0.55 0.53 0.55 0.55
Benchmarks
Debt to Equity, Competitors2
Abbott Laboratories 0.64 0.60 0.58 0.60 0.61 0.62 0.64 0.77 0.68 0.70 0.90 0.75 0.76 0.76 1.07 0.41 0.43 0.41 0.42 0.40 0.38 0.41
AbbVie Inc. 5.94 — — — — — — — — 10.49 7.33 5.65 6.20 7.39 7.95 5.77 6.71 6.87 8.03 6.61 5.65 11.09
Amgen Inc. 3.21 3.36 3.09 2.73 2.84 3.05 2.71 2.40 2.31 2.28 1.40 1.11 1.11 1.11 1.16 1.15 1.10 1.20 1.12 1.14 1.16 1.14
Biogen Inc. 0.66 0.48 0.45 0.43 0.46 0.43 0.46 0.43 0.48 0.42 0.47 0.51 0.56 0.57 0.54 0.54 0.57 0.63 0.70 0.62 0.05 0.05
Bristol-Myers Squibb Co. 0.95 0.94 0.91 1.41 1.56 0.40 0.52 0.54 0.60 0.60 0.68 0.57 0.56 0.59 0.41 0.44 0.45 0.47 0.47 0.48 0.49 0.48
Gilead Sciences Inc. 1.34 1.09 1.09 1.19 1.15 1.21 1.28 1.19 1.34 1.41 1.64 1.18 1.16 1.29 1.39 1.60 1.42 1.70 1.20 1.28 0.75 0.72
Illumina Inc. 0.25 0.25 0.25 0.25 0.26 0.44 0.53 0.57 0.42 0.45 0.49 0.46 0.48 0.49 0.58 0.54 0.50 0.51 0.59 0.57 0.73 0.80
Johnson & Johnson 0.48 0.45 0.47 0.50 0.48 0.50 0.51 0.48 0.51 0.51 0.57 0.48 0.48 0.46 0.39 0.37 0.36 0.32 0.28 0.28 0.27 0.28
Merck & Co. Inc. 1.12 1.07 1.02 0.97 0.96 0.94 0.94 0.73 0.72 0.70 0.71 0.71 0.63 0.71 0.62 0.57 0.56 0.59 0.59 0.58 0.57 0.63
Pfizer Inc. 0.99 0.80 0.83 0.81 0.78 0.77 0.66 0.58 0.58 0.56 0.61 0.72 0.75 0.75 0.71 0.70 0.70 0.62 0.60 0.58 0.53 0.53
Regeneron Pharmaceuticals Inc. 0.24 0.06 0.06 0.07 0.07 0.08 0.08 0.09 0.10 0.11 0.11 0.12 0.13 0.15 0.11 0.09 0.09 0.10 0.10 0.12 0.12 0.16
Vertex Pharmaceuticals Inc. 0.07 0.08 0.09 0.10 0.11 0.12 0.13 0.20 0.22 0.24 0.29 0.32 0.33 0.35 0.71 0.79 0.82 0.84 0.86 0.87 0.91 0.83
Zoetis Inc. 2.58 2.35 2.38 2.41 2.67 2.78 2.95 3.04 2.52 2.53 2.80 2.87 2.66 2.78 3.00 2.82 3.29 3.84 4.56 2.96 3.10 2.85

Based on: 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-02-19), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-08-02), 10-Q (filing date: 2019-05-02), 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-11-06), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-05-01), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-29), 10-K (filing date: 2016-02-19), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30).

1 Q2 2020 Calculation
Debt to equity = Total debt ÷ Total Eli Lilly and Company shareholders’ equity
= 16,328,200 ÷ 4,092,900 = 3.99

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Eli Lilly & Co.’s debt to equity ratio improved from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Debt to Capital

Eli Lilly & Co., debt to capital calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 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
Selected Financial Data (US$ in thousands)
Short-term borrowings and current maturities of long-term debt 1,263,800  3,248,000  1,499,300  1,563,100  2,068,600  2,354,900  1,131,200  1,002,200  3,049,100  2,304,200  3,706,600  3,538,100  2,444,200  2,609,300  1,937,400  641,500  645,800  648,300  6,100  9,300  10,800  805,400 
Long-term debt, excluding current maturities 15,064,400  13,982,300  13,817,900  13,662,200  13,717,600  13,610,200  11,639,700  11,674,700  9,170,500  9,393,500  9,940,500  9,926,600  9,867,900  7,637,500  8,367,800  8,707,300  8,685,500  7,477,600  7,972,400  8,069,600  7,988,600  7,415,300 
Total debt 16,328,200  17,230,300  15,317,200  15,225,300  15,786,200  15,965,100  12,770,900  12,676,900  12,219,600  11,697,700  13,647,100  13,464,700  12,312,100  10,246,800  10,305,200  9,348,800  9,331,300  8,125,900  7,978,500  8,078,900  7,999,400  8,220,700 
Total Eli Lilly and Company shareholders’ equity 4,092,900  3,078,800  2,606,900  3,382,500  2,780,500  2,480,300  9,828,700  13,076,600  11,555,200  14,527,000  11,592,200  14,890,300  14,100,800  14,031,000  14,007,700  15,589,200  14,637,300  15,009,900  14,571,300  15,221,400  14,670,300  14,919,800 
Total capital 20,421,100  20,309,100  17,924,100  18,607,800  18,566,700  18,445,400  22,599,600  25,753,500  23,774,800  26,224,700  25,239,300  28,355,000  26,412,900  24,277,800  24,312,900  24,938,000  23,968,600  23,135,800  22,549,800  23,300,300  22,669,700  23,140,500 
Solvency Ratio
Debt to capital1 0.80 0.85 0.85 0.82 0.85 0.87 0.57 0.49 0.51 0.45 0.54 0.47 0.47 0.42 0.42 0.37 0.39 0.35 0.35 0.35 0.35 0.36
Benchmarks
Debt to Capital, Competitors2
Abbott Laboratories 0.39 0.38 0.37 0.38 0.38 0.38 0.39 0.43 0.40 0.41 0.47 0.43 0.43 0.43 0.52 0.29 0.30 0.29 0.30 0.28 0.28 0.29
AbbVie Inc. 0.86 1.12 1.14 1.27 1.30 1.27 1.27 1.08 1.10 0.91 0.88 0.85 0.86 0.88 0.89 0.85 0.87 0.87 0.89 0.87 0.85 0.92
Amgen Inc. 0.76 0.77 0.76 0.73 0.74 0.75 0.73 0.71 0.70 0.69 0.58 0.53 0.53 0.53 0.54 0.53 0.52 0.54 0.53 0.53 0.54 0.53
Biogen Inc. 0.40 0.32 0.31 0.30 0.31 0.30 0.31 0.30 0.33 0.30 0.32 0.34 0.36 0.36 0.35 0.35 0.36 0.39 0.41 0.38 0.04 0.05
Bristol-Myers Squibb Co. 0.49 0.48 0.48 0.59 0.61 0.28 0.34 0.35 0.37 0.38 0.40 0.36 0.36 0.37 0.29 0.30 0.31 0.32 0.32 0.33 0.33 0.32
Gilead Sciences Inc. 0.57 0.52 0.52 0.54 0.54 0.55 0.56 0.54 0.57 0.59 0.62 0.54 0.54 0.56 0.58 0.62 0.59 0.63 0.54 0.56 0.43 0.42
Illumina Inc. 0.20 0.20 0.20 0.20 0.21 0.30 0.35 0.36 0.30 0.31 0.33 0.31 0.32 0.33 0.37 0.35 0.33 0.34 0.37 0.36 0.42 0.44
Johnson & Johnson 0.33 0.31 0.32 0.33 0.33 0.33 0.34 0.33 0.34 0.34 0.37 0.32 0.32 0.32 0.28 0.27 0.27 0.24 0.22 0.22 0.21 0.22
Merck & Co. Inc. 0.53 0.52 0.50 0.49 0.49 0.48 0.48 0.42 0.42 0.41 0.42 0.41 0.39 0.42 0.38 0.36 0.36 0.37 0.37 0.37 0.36 0.39
Pfizer Inc. 0.50 0.45 0.45 0.45 0.44 0.43 0.40 0.37 0.37 0.36 0.38 0.42 0.43 0.43 0.41 0.41 0.41 0.38 0.38 0.37 0.34 0.35
Regeneron Pharmaceuticals Inc. 0.20 0.06 0.06 0.06 0.07 0.07 0.07 0.08 0.09 0.10 0.10 0.10 0.11 0.13 0.10 0.08 0.08 0.09 0.09 0.11 0.10 0.14
Vertex Pharmaceuticals Inc. 0.06 0.08 0.08 0.09 0.10 0.11 0.12 0.17 0.18 0.19 0.22 0.24 0.25 0.26 0.42 0.44 0.45 0.46 0.46 0.47 0.48 0.45
Zoetis Inc. 0.72 0.70 0.70 0.71 0.73 0.74 0.75 0.75 0.72 0.72 0.74 0.74 0.73 0.74 0.75 0.74 0.77 0.79 0.82 0.75 0.76 0.74

Based on: 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-02-19), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-08-02), 10-Q (filing date: 2019-05-02), 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-11-06), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-05-01), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-29), 10-K (filing date: 2016-02-19), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30).

1 Q2 2020 Calculation
Debt to capital = Total debt ÷ Total capital
= 16,328,200 ÷ 20,421,100 = 0.80

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Eli Lilly & Co.’s debt to capital ratio improved from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Debt to Assets

Eli Lilly & Co., debt to assets calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 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
Selected Financial Data (US$ in thousands)
Short-term borrowings and current maturities of long-term debt 1,263,800  3,248,000  1,499,300  1,563,100  2,068,600  2,354,900  1,131,200  1,002,200  3,049,100  2,304,200  3,706,600  3,538,100  2,444,200  2,609,300  1,937,400  641,500  645,800  648,300  6,100  9,300  10,800  805,400 
Long-term debt, excluding current maturities 15,064,400  13,982,300  13,817,900  13,662,200  13,717,600  13,610,200  11,639,700  11,674,700  9,170,500  9,393,500  9,940,500  9,926,600  9,867,900  7,637,500  8,367,800  8,707,300  8,685,500  7,477,600  7,972,400  8,069,600  7,988,600  7,415,300 
Total debt 16,328,200  17,230,300  15,317,200  15,225,300  15,786,200  15,965,100  12,770,900  12,676,900  12,219,600  11,697,700  13,647,100  13,464,700  12,312,100  10,246,800  10,305,200  9,348,800  9,331,300  8,125,900  7,978,500  8,078,900  7,999,400  8,220,700 
 
Total assets 41,967,000  41,102,800  39,286,100  37,893,100  38,666,400  38,006,800  43,908,400  44,625,100  42,359,200  44,355,600  44,981,000  43,010,400  40,946,500  37,624,300  38,805,900  37,590,300  36,475,300  34,691,800  35,568,900  36,304,700  36,036,600  35,653,900 
Solvency Ratio
Debt to assets1 0.39 0.42 0.39 0.40 0.41 0.42 0.29 0.28 0.29 0.26 0.30 0.31 0.30 0.27 0.27 0.25 0.26 0.23 0.22 0.22 0.22 0.23
Benchmarks
Debt to Assets, Competitors2
Abbott Laboratories 0.29 0.27 0.27 0.28 0.28 0.28 0.29 0.33 0.30 0.31 0.37 0.33 0.34 0.34 0.42 0.22 0.22 0.22 0.22 0.20 0.20 0.21
AbbVie Inc. 0.58 0.74 0.75 0.65 0.65 0.65 0.68 0.61 0.60 0.54 0.53 0.55 0.56 0.56 0.56 0.56 0.56 0.59 0.60 0.59 0.58 0.57
Amgen Inc. 0.53 0.52 0.50 0.50 0.52 0.52 0.51 0.51 0.51 0.50 0.44 0.45 0.44 0.44 0.45 0.45 0.44 0.46 0.44 0.44 0.45 0.44
Biogen Inc. 0.29 0.23 0.22 0.22 0.23 0.22 0.23 0.23 0.25 0.23 0.25 0.28 0.30 0.31 0.28 0.30 0.30 0.32 0.33 0.32 0.03 0.04
Bristol-Myers Squibb Co. 0.36 0.36 0.36 0.43 0.45 0.17 0.21 0.22 0.23 0.23 0.24 0.25 0.25 0.26 0.20 0.20 0.21 0.21 0.21 0.23 0.23 0.22
Gilead Sciences Inc. 0.43 0.40 0.40 0.42 0.41 0.42 0.43 0.42 0.44 0.44 0.48 0.45 0.44 0.46 0.46 0.48 0.44 0.48 0.43 0.44 0.31 0.32
Illumina Inc. 0.16 0.16 0.16 0.16 0.16 0.24 0.29 0.29 0.23 0.24 0.25 0.26 0.27 0.27 0.30 0.29 0.26 0.27 0.30 0.30 0.35 0.37
Johnson & Johnson 0.19 0.18 0.18 0.19 0.19 0.20 0.20 0.20 0.21 0.21 0.22 0.23 0.23 0.22 0.19 0.19 0.19 0.17 0.15 0.15 0.15 0.15
Merck & Co. Inc. 0.34 0.33 0.31 0.31 0.32 0.31 0.30 0.28 0.27 0.27 0.28 0.29 0.27 0.29 0.26 0.26 0.25 0.26 0.26 0.26 0.26 0.28
Pfizer Inc. 0.36 0.31 0.31 0.31 0.30 0.29 0.26 0.24 0.25 0.25 0.25 0.26 0.26 0.26 0.25 0.25 0.26 0.24 0.23 0.23 0.22 0.22
Regeneron Pharmaceuticals Inc. 0.15 0.05 0.05 0.05 0.05 0.06 0.06 0.07 0.07 0.08 0.08 0.08 0.09 0.09 0.07 0.06 0.06 0.06 0.06 0.08 0.09 0.11
Vertex Pharmaceuticals Inc. 0.05 0.06 0.06 0.07 0.08 0.09 0.09 0.12 0.13 0.15 0.16 0.18 0.17 0.18 0.28 0.31 0.32 0.32 0.32 0.33 0.34 0.38
Zoetis Inc. 0.59 0.56 0.56 0.57 0.59 0.59 0.60 0.62 0.58 0.57 0.58 0.61 0.59 0.58 0.58 0.58 0.59 0.60 0.62 0.54 0.55 0.57

Based on: 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-02-19), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-08-02), 10-Q (filing date: 2019-05-02), 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-11-06), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-05-01), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-29), 10-K (filing date: 2016-02-19), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30).

1 Q2 2020 Calculation
Debt to assets = Total debt ÷ Total assets
= 16,328,200 ÷ 41,967,000 = 0.39

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Eli Lilly & Co.’s debt to assets ratio deteriorated from Q4 2019 to Q1 2020 but then improved from Q1 2020 to Q2 2020 exceeding Q4 2019 level.

Financial Leverage

Eli Lilly & Co., financial leverage calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 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
Selected Financial Data (US$ in thousands)
Total assets 41,967,000  41,102,800  39,286,100  37,893,100  38,666,400  38,006,800  43,908,400  44,625,100  42,359,200  44,355,600  44,981,000  43,010,400  40,946,500  37,624,300  38,805,900  37,590,300  36,475,300  34,691,800  35,568,900  36,304,700  36,036,600  35,653,900 
Total Eli Lilly and Company shareholders’ equity 4,092,900  3,078,800  2,606,900  3,382,500  2,780,500  2,480,300  9,828,700  13,076,600  11,555,200  14,527,000  11,592,200  14,890,300  14,100,800  14,031,000  14,007,700  15,589,200  14,637,300  15,009,900  14,571,300  15,221,400  14,670,300  14,919,800 
Solvency Ratio
Financial leverage1 10.25 13.35 15.07 11.20 13.91 15.32 4.47 3.41 3.67 3.05 3.88 2.89 2.90 2.68 2.77 2.41 2.49 2.31 2.44 2.39 2.46 2.39
Benchmarks
Financial Leverage, Competitors2
Abbott Laboratories 2.25 2.21 2.18 2.15 2.16 2.19 2.20 2.33 2.24 2.26 2.47 2.26 2.25 2.26 2.56 1.90 1.93 1.91 1.94 1.98 1.92 1.97
AbbVie Inc. 10.17 — — — — — — — — 19.52 13.89 10.29 11.15 13.14 14.26 10.30 11.92 11.57 13.45 11.28 9.78 19.39
Amgen Inc. 6.10 6.50 6.17 5.45 5.50 5.91 5.31 4.69 4.54 4.56 3.17 2.49 2.51 2.54 2.60 2.54 2.50 2.62 2.55 2.57 2.59 2.60
Biogen Inc. 2.26 2.08 2.04 1.96 2.03 1.91 1.94 1.85 1.95 1.86 1.88 1.79 1.88 1.85 1.88 1.82 1.89 2.00 2.08 1.96 1.33 1.30
Bristol-Myers Squibb Co. 2.61 2.59 2.52 3.25 3.44 2.29 2.49 2.47 2.65 2.59 2.86 2.30 2.27 2.28 2.08 2.16 2.20 2.22 2.23 2.11 2.11 2.16
Gilead Sciences Inc. 3.10 2.71 2.74 2.87 2.79 2.86 2.98 2.81 3.02 3.18 3.44 2.60 2.66 2.82 3.02 3.36 3.22 3.57 2.80 2.91 2.40 2.23
Illumina Inc. 1.59 1.57 1.59 1.60 1.61 1.85 1.85 1.93 1.80 1.84 1.91 1.77 1.79 1.80 1.95 1.89 1.94 1.91 1.99 1.93 2.06 2.16
Johnson & Johnson 2.51 2.53 2.65 2.67 2.55 2.54 2.56 2.41 2.47 2.48 2.61 2.10 2.12 2.06 2.01 1.93 1.93 1.88 1.88 1.86 1.86 1.89
Merck & Co. Inc. 3.28 3.24 3.26 3.10 3.04 2.99 3.09 2.63 2.61 2.56 2.56 2.40 2.35 2.42 2.38 2.25 2.23 2.25 2.28 2.22 2.21 2.27
Pfizer Inc. 2.77 2.56 2.65 2.62 2.62 2.64 2.51 2.35 2.36 2.25 2.41 2.83 2.89 2.89 2.88 2.82 2.72 2.58 2.59 2.56 2.40 2.39
Regeneron Pharmaceuticals Inc. 1.59 1.30 1.34 1.33 1.35 1.36 1.34 1.37 1.38 1.43 1.43 1.44 1.47 1.61 1.57 1.52 1.52 1.57 1.53 1.57 1.36 1.41
Vertex Pharmaceuticals Inc. 1.36 1.38 1.37 1.43 1.39 1.39 1.41 1.59 1.61 1.65 1.75 1.79 1.97 1.96 2.50 2.55 2.60 2.60 2.66 2.64 2.65 2.22
Zoetis Inc. 4.38 4.19 4.26 4.21 4.56 4.70 4.93 4.94 4.37 4.43 4.85 4.67 4.55 4.75 5.14 4.87 5.54 6.40 7.41 5.44 5.61 5.03

Based on: 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-02-19), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-08-02), 10-Q (filing date: 2019-05-02), 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-11-06), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-05-01), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-29), 10-K (filing date: 2016-02-19), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30).

1 Q2 2020 Calculation
Financial leverage = Total assets ÷ Total Eli Lilly and Company shareholders’ equity
= 41,967,000 ÷ 4,092,900 = 10.25

2 Click competitor name to see calculations.

Solvency ratio Description The company
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Eli Lilly & Co.’s financial leverage ratio decreased from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.