Stock Analysis on Net

LyondellBasell Industries N.V. (NYSE:LYB)

This company has been moved to the archive! The financial data has not been updated since August 2, 2019.

Analysis of Solvency Ratios
Quarterly Data

Microsoft Excel

Solvency Ratios (Summary)

LyondellBasell Industries N.V., solvency ratios (quarterly data)

Microsoft Excel
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Debt Ratios
Debt to equity 0.97 0.98 0.92 0.78 0.81 0.89 0.96 1.22 1.32 1.40 1.48 1.49 1.45 1.43 1.23 1.14 1.05 1.11 0.85 0.69 0.63 0.58
Debt to equity (including operating lease liability) 1.09 1.10 0.92 0.78 0.81 0.89 0.96 1.22 1.32 1.40 1.48 1.49 1.45 1.43 1.23 1.14 1.05 1.11 0.85 0.69 0.63 0.58
Debt to capital 0.49 0.49 0.48 0.44 0.45 0.47 0.49 0.55 0.57 0.58 0.60 0.60 0.59 0.59 0.55 0.53 0.51 0.53 0.46 0.41 0.39 0.37
Debt to capital (including operating lease liability) 0.52 0.52 0.48 0.44 0.45 0.47 0.49 0.55 0.57 0.58 0.60 0.60 0.59 0.59 0.55 0.53 0.51 0.53 0.46 0.41 0.39 0.37
Debt to assets 0.33 0.33 0.33 0.30 0.32 0.32 0.33 0.35 0.38 0.38 0.38 0.39 0.39 0.39 0.35 0.35 0.34 0.34 0.29 0.27 0.26 0.25
Debt to assets (including operating lease liability) 0.38 0.37 0.33 0.30 0.32 0.32 0.33 0.35 0.38 0.38 0.38 0.39 0.39 0.39 0.35 0.35 0.34 0.34 0.29 0.27 0.26 0.25
Financial leverage 2.91 2.95 2.76 2.60 2.55 2.76 2.93 3.45 3.51 3.68 3.88 3.85 3.73 3.72 3.47 3.27 3.10 3.21 2.92 2.60 2.48 2.36
Coverage Ratios
Interest coverage 13.36 14.29 15.75 16.96 17.03 16.75 12.19 11.82 11.99 11.94 17.25 17.69 18.23 19.77 21.03 21.47 21.07 19.22 17.23

Based on: 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31).

Solvency ratio Description The company
Debt to equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. LyondellBasell Industries N.V. debt to equity ratio deteriorated from Q4 2018 to Q1 2019 but then slightly improved from Q1 2019 to Q2 2019.
Debt to equity (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total shareholders’ equity. LyondellBasell Industries N.V. debt to equity ratio (including operating lease liability) deteriorated from Q4 2018 to Q1 2019 but then slightly improved from Q1 2019 to Q2 2019.
Debt to capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. LyondellBasell Industries N.V. debt to capital ratio deteriorated from Q4 2018 to Q1 2019 but then slightly improved from Q1 2019 to Q2 2019.
Debt to capital (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total debt (including operating lease liability) plus shareholders’ equity. LyondellBasell Industries N.V. debt to capital ratio (including operating lease liability) deteriorated from Q4 2018 to Q1 2019 but then slightly improved from Q1 2019 to Q2 2019.
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. LyondellBasell Industries N.V. debt to assets ratio improved from Q4 2018 to Q1 2019 but then deteriorated significantly from Q1 2019 to Q2 2019.
Debt to assets (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total assets. LyondellBasell Industries N.V. debt to assets ratio (including operating lease liability) deteriorated from Q4 2018 to Q1 2019 and from Q1 2019 to Q2 2019.
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. LyondellBasell Industries N.V. financial leverage ratio increased from Q4 2018 to Q1 2019 but then slightly decreased from Q1 2019 to Q2 2019.

Solvency ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. LyondellBasell Industries N.V. interest coverage ratio deteriorated from Q4 2018 to Q1 2019 and from Q1 2019 to Q2 2019.

Debt to Equity

LyondellBasell Industries N.V., debt to equity calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Current maturities of long-term debt 4 5 5 984 974 5 2 3 2 2 2 3 4 4 4 3 3 4 4 2 3 3
Short-term debt 2,812 2,377 885 214 76 77 68 381 561 611 594 621 616 594 353 573 582 514 346 56 55 58
Long-term debt, excluding current maturities 7,586 7,522 8,497 7,471 7,490 8,531 8,549 8,531 8,496 8,419 8,385 8,464 8,485 8,504 7,671 7,742 7,728 7,749 6,757 6,753 6,766 6,766
Total debt 10,402 9,904 9,387 8,669 8,540 8,613 8,619 8,915 9,059 9,032 8,981 9,088 9,105 9,102 8,028 8,318 8,313 8,267 7,107 6,811 6,824 6,827
 
Total Company share of stockholders’ equity 10,721 10,138 10,257 11,044 10,602 9,728 8,949 7,326 6,866 6,462 6,048 6,082 6,283 6,344 6,550 7,328 7,927 7,478 8,314 9,843 10,753 11,791
Solvency Ratio
Debt to equity1 0.97 0.98 0.92 0.78 0.81 0.89 0.96 1.22 1.32 1.40 1.48 1.49 1.45 1.43 1.23 1.14 1.05 1.11 0.85 0.69 0.63 0.58
Benchmarks
Debt to Equity, Competitors2
Linde plc 0.28 0.28

Based on: 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31).

1 Q2 2019 Calculation
Debt to equity = Total debt ÷ Total Company share of stockholders’ equity
= 10,402 ÷ 10,721 = 0.97

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. LyondellBasell Industries N.V. debt to equity ratio deteriorated from Q4 2018 to Q1 2019 but then slightly improved from Q1 2019 to Q2 2019.

Debt to Equity (including Operating Lease Liability)

LyondellBasell Industries N.V., debt to equity (including operating lease liability) calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Current maturities of long-term debt 4 5 5 984 974 5 2 3 2 2 2 3 4 4 4 3 3 4 4 2 3 3
Short-term debt 2,812 2,377 885 214 76 77 68 381 561 611 594 621 616 594 353 573 582 514 346 56 55 58
Long-term debt, excluding current maturities 7,586 7,522 8,497 7,471 7,490 8,531 8,549 8,531 8,496 8,419 8,385 8,464 8,485 8,504 7,671 7,742 7,728 7,749 6,757 6,753 6,766 6,766
Total debt 10,402 9,904 9,387 8,669 8,540 8,613 8,619 8,915 9,059 9,032 8,981 9,088 9,105 9,102 8,028 8,318 8,313 8,267 7,107 6,811 6,824 6,827
Operating lease liabilities 1,304 1,282
Total debt (including operating lease liability) 11,706 11,186 9,387 8,669 8,540 8,613 8,619 8,915 9,059 9,032 8,981 9,088 9,105 9,102 8,028 8,318 8,313 8,267 7,107 6,811 6,824 6,827
 
Total Company share of stockholders’ equity 10,721 10,138 10,257 11,044 10,602 9,728 8,949 7,326 6,866 6,462 6,048 6,082 6,283 6,344 6,550 7,328 7,927 7,478 8,314 9,843 10,753 11,791
Solvency Ratio
Debt to equity (including operating lease liability)1 1.09 1.10 0.92 0.78 0.81 0.89 0.96 1.22 1.32 1.40 1.48 1.49 1.45 1.43 1.23 1.14 1.05 1.11 0.85 0.69 0.63 0.58

Based on: 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31).

1 Q2 2019 Calculation
Debt to equity (including operating lease liability) = Total debt (including operating lease liability) ÷ Total Company share of stockholders’ equity
= 11,706 ÷ 10,721 = 1.09

Solvency ratio Description The company
Debt to equity (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total shareholders’ equity. LyondellBasell Industries N.V. debt to equity ratio (including operating lease liability) deteriorated from Q4 2018 to Q1 2019 but then slightly improved from Q1 2019 to Q2 2019.

Debt to Capital

LyondellBasell Industries N.V., debt to capital calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Current maturities of long-term debt 4 5 5 984 974 5 2 3 2 2 2 3 4 4 4 3 3 4 4 2 3 3
Short-term debt 2,812 2,377 885 214 76 77 68 381 561 611 594 621 616 594 353 573 582 514 346 56 55 58
Long-term debt, excluding current maturities 7,586 7,522 8,497 7,471 7,490 8,531 8,549 8,531 8,496 8,419 8,385 8,464 8,485 8,504 7,671 7,742 7,728 7,749 6,757 6,753 6,766 6,766
Total debt 10,402 9,904 9,387 8,669 8,540 8,613 8,619 8,915 9,059 9,032 8,981 9,088 9,105 9,102 8,028 8,318 8,313 8,267 7,107 6,811 6,824 6,827
Total Company share of stockholders’ equity 10,721 10,138 10,257 11,044 10,602 9,728 8,949 7,326 6,866 6,462 6,048 6,082 6,283 6,344 6,550 7,328 7,927 7,478 8,314 9,843 10,753 11,791
Total capital 21,123 20,042 19,644 19,713 19,142 18,341 17,568 16,241 15,925 15,494 15,029 15,170 15,388 15,446 14,578 15,646 16,240 15,745 15,421 16,654 17,577 18,618
Solvency Ratio
Debt to capital1 0.49 0.49 0.48 0.44 0.45 0.47 0.49 0.55 0.57 0.58 0.60 0.60 0.59 0.59 0.55 0.53 0.51 0.53 0.46 0.41 0.39 0.37
Benchmarks
Debt to Capital, Competitors2
Linde plc 0.22 0.22

Based on: 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31).

1 Q2 2019 Calculation
Debt to capital = Total debt ÷ Total capital
= 10,402 ÷ 21,123 = 0.49

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. LyondellBasell Industries N.V. debt to capital ratio deteriorated from Q4 2018 to Q1 2019 but then slightly improved from Q1 2019 to Q2 2019.

Debt to Capital (including Operating Lease Liability)

LyondellBasell Industries N.V., debt to capital (including operating lease liability) calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Current maturities of long-term debt 4 5 5 984 974 5 2 3 2 2 2 3 4 4 4 3 3 4 4 2 3 3
Short-term debt 2,812 2,377 885 214 76 77 68 381 561 611 594 621 616 594 353 573 582 514 346 56 55 58
Long-term debt, excluding current maturities 7,586 7,522 8,497 7,471 7,490 8,531 8,549 8,531 8,496 8,419 8,385 8,464 8,485 8,504 7,671 7,742 7,728 7,749 6,757 6,753 6,766 6,766
Total debt 10,402 9,904 9,387 8,669 8,540 8,613 8,619 8,915 9,059 9,032 8,981 9,088 9,105 9,102 8,028 8,318 8,313 8,267 7,107 6,811 6,824 6,827
Operating lease liabilities 1,304 1,282
Total debt (including operating lease liability) 11,706 11,186 9,387 8,669 8,540 8,613 8,619 8,915 9,059 9,032 8,981 9,088 9,105 9,102 8,028 8,318 8,313 8,267 7,107 6,811 6,824 6,827
Total Company share of stockholders’ equity 10,721 10,138 10,257 11,044 10,602 9,728 8,949 7,326 6,866 6,462 6,048 6,082 6,283 6,344 6,550 7,328 7,927 7,478 8,314 9,843 10,753 11,791
Total capital (including operating lease liability) 22,427 21,324 19,644 19,713 19,142 18,341 17,568 16,241 15,925 15,494 15,029 15,170 15,388 15,446 14,578 15,646 16,240 15,745 15,421 16,654 17,577 18,618
Solvency Ratio
Debt to capital (including operating lease liability)1 0.52 0.52 0.48 0.44 0.45 0.47 0.49 0.55 0.57 0.58 0.60 0.60 0.59 0.59 0.55 0.53 0.51 0.53 0.46 0.41 0.39 0.37

Based on: 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31).

1 Q2 2019 Calculation
Debt to capital (including operating lease liability) = Total debt (including operating lease liability) ÷ Total capital (including operating lease liability)
= 11,706 ÷ 22,427 = 0.52

Solvency ratio Description The company
Debt to capital (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total debt (including operating lease liability) plus shareholders’ equity. LyondellBasell Industries N.V. debt to capital ratio (including operating lease liability) deteriorated from Q4 2018 to Q1 2019 but then slightly improved from Q1 2019 to Q2 2019.

Debt to Assets

LyondellBasell Industries N.V., debt to assets calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Current maturities of long-term debt 4 5 5 984 974 5 2 3 2 2 2 3 4 4 4 3 3 4 4 2 3 3
Short-term debt 2,812 2,377 885 214 76 77 68 381 561 611 594 621 616 594 353 573 582 514 346 56 55 58
Long-term debt, excluding current maturities 7,586 7,522 8,497 7,471 7,490 8,531 8,549 8,531 8,496 8,419 8,385 8,464 8,485 8,504 7,671 7,742 7,728 7,749 6,757 6,753 6,766 6,766
Total debt 10,402 9,904 9,387 8,669 8,540 8,613 8,619 8,915 9,059 9,032 8,981 9,088 9,105 9,102 8,028 8,318 8,313 8,267 7,107 6,811 6,824 6,827
 
Total assets 31,171 29,889 28,278 28,696 27,023 26,896 26,206 25,243 24,118 23,768 23,442 23,419 23,435 23,572 22,757 23,935 24,605 24,006 24,283 25,631 26,656 27,827
Solvency Ratio
Debt to assets1 0.33 0.33 0.33 0.30 0.32 0.32 0.33 0.35 0.38 0.38 0.38 0.39 0.39 0.39 0.35 0.35 0.34 0.34 0.29 0.27 0.26 0.25
Benchmarks
Debt to Assets, Competitors2
Linde plc 0.16 0.15

Based on: 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31).

1 Q2 2019 Calculation
Debt to assets = Total debt ÷ Total assets
= 10,402 ÷ 31,171 = 0.33

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. LyondellBasell Industries N.V. debt to assets ratio improved from Q4 2018 to Q1 2019 but then deteriorated significantly from Q1 2019 to Q2 2019.

Debt to Assets (including Operating Lease Liability)

LyondellBasell Industries N.V., debt to assets (including operating lease liability) calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Current maturities of long-term debt 4 5 5 984 974 5 2 3 2 2 2 3 4 4 4 3 3 4 4 2 3 3
Short-term debt 2,812 2,377 885 214 76 77 68 381 561 611 594 621 616 594 353 573 582 514 346 56 55 58
Long-term debt, excluding current maturities 7,586 7,522 8,497 7,471 7,490 8,531 8,549 8,531 8,496 8,419 8,385 8,464 8,485 8,504 7,671 7,742 7,728 7,749 6,757 6,753 6,766 6,766
Total debt 10,402 9,904 9,387 8,669 8,540 8,613 8,619 8,915 9,059 9,032 8,981 9,088 9,105 9,102 8,028 8,318 8,313 8,267 7,107 6,811 6,824 6,827
Operating lease liabilities 1,304 1,282
Total debt (including operating lease liability) 11,706 11,186 9,387 8,669 8,540 8,613 8,619 8,915 9,059 9,032 8,981 9,088 9,105 9,102 8,028 8,318 8,313 8,267 7,107 6,811 6,824 6,827
 
Total assets 31,171 29,889 28,278 28,696 27,023 26,896 26,206 25,243 24,118 23,768 23,442 23,419 23,435 23,572 22,757 23,935 24,605 24,006 24,283 25,631 26,656 27,827
Solvency Ratio
Debt to assets (including operating lease liability)1 0.38 0.37 0.33 0.30 0.32 0.32 0.33 0.35 0.38 0.38 0.38 0.39 0.39 0.39 0.35 0.35 0.34 0.34 0.29 0.27 0.26 0.25

Based on: 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31).

1 Q2 2019 Calculation
Debt to assets (including operating lease liability) = Total debt (including operating lease liability) ÷ Total assets
= 11,706 ÷ 31,171 = 0.38

Solvency ratio Description The company
Debt to assets (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total assets. LyondellBasell Industries N.V. debt to assets ratio (including operating lease liability) deteriorated from Q4 2018 to Q1 2019 and from Q1 2019 to Q2 2019.

Financial Leverage

LyondellBasell Industries N.V., financial leverage calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Total assets 31,171 29,889 28,278 28,696 27,023 26,896 26,206 25,243 24,118 23,768 23,442 23,419 23,435 23,572 22,757 23,935 24,605 24,006 24,283 25,631 26,656 27,827
Total Company share of stockholders’ equity 10,721 10,138 10,257 11,044 10,602 9,728 8,949 7,326 6,866 6,462 6,048 6,082 6,283 6,344 6,550 7,328 7,927 7,478 8,314 9,843 10,753 11,791
Solvency Ratio
Financial leverage1 2.91 2.95 2.76 2.60 2.55 2.76 2.93 3.45 3.51 3.68 3.88 3.85 3.73 3.72 3.47 3.27 3.10 3.21 2.92 2.60 2.48 2.36
Benchmarks
Financial Leverage, Competitors2
Linde plc 1.72 1.79

Based on: 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31).

1 Q2 2019 Calculation
Financial leverage = Total assets ÷ Total Company share of stockholders’ equity
= 31,171 ÷ 10,721 = 2.91

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. LyondellBasell Industries N.V. financial leverage ratio increased from Q4 2018 to Q1 2019 but then slightly decreased from Q1 2019 to Q2 2019.

Interest Coverage

LyondellBasell Industries N.V., interest coverage calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Net income attributable to the Company shareholders 1,002 815 690 1,113 1,654 1,231 1,894 1,057 1,131 797 763 952 1,091 1,030 795 1,185 1,330 1,166 793 1,258 1,178 945
Add: Net income attributable to noncontrolling interest 1 2 2 (1) (1) 1 1 (1) (2) (2) (1) (2) (1)
Less: Income (loss) from discontinued operations, net of tax (3) (5) (2) (1) (4) (2) (4) (8) (7) (2) (1) (2) (3) 3 (3) (5) (3) 3 1
Add: Income tax expense 169 203 99 232 (21) 303 (556) 380 459 315 282 326 346 432 262 487 541 440 298 434 425 383
Add: Interest expense 81 92 88 90 91 91 95 94 95 207 85 72 83 82 77 85 79 69 72 92 96 92
Earnings before interest and tax (EBIT) 1,256 1,112 884 1,437 1,725 1,625 1,437 1,532 1,688 1,327 1,137 1,353 1,521 1,544 1,136 1,761 1,946 1,676 1,166 1,786 1,694 1,418
Solvency Ratio
Interest coverage1 13.36 14.29 15.75 16.96 17.03 16.75 12.19 11.82 11.99 11.94 17.25 17.69 18.23 19.77 21.03 21.47 21.07 19.22 17.23

Based on: 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31).

1 Q2 2019 Calculation
Interest coverage = (EBITQ2 2019 + EBITQ1 2019 + EBITQ4 2018 + EBITQ3 2018) ÷ (Interest expenseQ2 2019 + Interest expenseQ1 2019 + Interest expenseQ4 2018 + Interest expenseQ3 2018)
= (1,256 + 1,112 + 884 + 1,437) ÷ (81 + 92 + 88 + 90) = 13.36

Solvency ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. LyondellBasell Industries N.V. interest coverage ratio deteriorated from Q4 2018 to Q1 2019 and from Q1 2019 to Q2 2019.