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 Reportable Segments

Microsoft Excel

Segment Profit Margin

LyondellBasell Industries N.V., profit margin by reportable segment

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Olefins and Polyolefins–Americas (O&P–Americas) 26.54% 28.98% 31.97% 36.74% 28.04%
Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) 10.73% 18.86% 19.83% 15.77% 8.99%
Intermediates and Derivatives (I&D) 20.97% 17.59% 18.45% 18.98% 14.40%
Advanced Polymer Solutions (APS) 9.94% 14.99% 16.42%
Refining 1.82% 2.29% 1.40% 5.22% 0.56%
Technology 56.26% 49.56% 54.70% 52.26% 46.68%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

Segment profitability ratio Reportable segment The company
Segment profit margin Olefins and Polyolefins–Americas (O&P–Americas) Olefins and Polyolefins–Americas (O&P–Americas) segment profit margin ratio deteriorated from 2016 to 2017 and from 2017 to 2018.
Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) segment profit margin ratio deteriorated from 2016 to 2017 and from 2017 to 2018.
Intermediates and Derivatives (I&D) Intermediates and Derivatives (I&D) segment profit margin ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.
Advanced Polymer Solutions (APS) Advanced Polymer Solutions (APS) segment profit margin ratio deteriorated from 2016 to 2017 and from 2017 to 2018.
Refining Refining segment profit margin ratio improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.
Technology Technology segment profit margin ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.

Segment Profit Margin: Olefins and Polyolefins–Americas (O&P–Americas)

LyondellBasell Industries N.V.; Olefins and Polyolefins–Americas (O&P–Americas); segment profit margin calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
EBITDA 2,762 2,899 2,788 3,661 3,911
Sales and other operating revenues 10,408 10,004 8,722 9,964 13,948
Segment Profitability Ratio
Segment profit margin1 26.54% 28.98% 31.97% 36.74% 28.04%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment profit margin = 100 × EBITDA ÷ Sales and other operating revenues
= 100 × 2,762 ÷ 10,408 = 26.54%

Segment profitability ratio Reportable segment The company
Segment profit margin Olefins and Polyolefins–Americas (O&P–Americas) Olefins and Polyolefins–Americas (O&P–Americas) segment profit margin ratio deteriorated from 2016 to 2017 and from 2017 to 2018.

Segment Profit Margin: Olefins and Polyolefins–Europe, Asia, International (O&P–EAI)

LyondellBasell Industries N.V.; Olefins and Polyolefins–Europe, Asia, International (O&P–EAI); segment profit margin calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
EBITDA 1,163 1,927 1,729 1,825 1,366
Sales and other operating revenues 10,838 10,218 8,718 11,576 15,203
Segment Profitability Ratio
Segment profit margin1 10.73% 18.86% 19.83% 15.77% 8.99%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment profit margin = 100 × EBITDA ÷ Sales and other operating revenues
= 100 × 1,163 ÷ 10,838 = 10.73%

Segment profitability ratio Reportable segment The company
Segment profit margin Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) segment profit margin ratio deteriorated from 2016 to 2017 and from 2017 to 2018.

Segment Profit Margin: Intermediates and Derivatives (I&D)

LyondellBasell Industries N.V.; Intermediates and Derivatives (I&D); segment profit margin calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
EBITDA 2,011 1,490 1,333 1,475 1,459
Sales and other operating revenues 9,588 8,472 7,226 7,772 10,130
Segment Profitability Ratio
Segment profit margin1 20.97% 17.59% 18.45% 18.98% 14.40%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment profit margin = 100 × EBITDA ÷ Sales and other operating revenues
= 100 × 2,011 ÷ 9,588 = 20.97%

Segment profitability ratio Reportable segment The company
Segment profit margin Intermediates and Derivatives (I&D) Intermediates and Derivatives (I&D) segment profit margin ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.

Segment Profit Margin: Advanced Polymer Solutions (APS)

LyondellBasell Industries N.V.; Advanced Polymer Solutions (APS); segment profit margin calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
EBITDA 400 438 427
Sales and other operating revenues 4,024 2,922 2,601
Segment Profitability Ratio
Segment profit margin1 9.94% 14.99% 16.42%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment profit margin = 100 × EBITDA ÷ Sales and other operating revenues
= 100 × 400 ÷ 4,024 = 9.94%

Segment profitability ratio Reportable segment The company
Segment profit margin Advanced Polymer Solutions (APS) Advanced Polymer Solutions (APS) segment profit margin ratio deteriorated from 2016 to 2017 and from 2017 to 2018.

Segment Profit Margin: Refining

LyondellBasell Industries N.V.; Refining; segment profit margin calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
EBITDA 167 157 72 342 65
Sales and other operating revenues 9,157 6,848 5,135 6,557 11,710
Segment Profitability Ratio
Segment profit margin1 1.82% 2.29% 1.40% 5.22% 0.56%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment profit margin = 100 × EBITDA ÷ Sales and other operating revenues
= 100 × 167 ÷ 9,157 = 1.82%

Segment profitability ratio Reportable segment The company
Segment profit margin Refining Refining segment profit margin ratio improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.

Segment Profit Margin: Technology

LyondellBasell Industries N.V.; Technology; segment profit margin calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
EBITDA 328 223 262 243 232
Sales and other operating revenues 583 450 479 465 497
Segment Profitability Ratio
Segment profit margin1 56.26% 49.56% 54.70% 52.26% 46.68%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment profit margin = 100 × EBITDA ÷ Sales and other operating revenues
= 100 × 328 ÷ 583 = 56.26%

Segment profitability ratio Reportable segment The company
Segment profit margin Technology Technology segment profit margin ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.

Segment Return on Assets (Segment ROA)

LyondellBasell Industries N.V., ROA by reportable segment

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Olefins and Polyolefins–Americas (O&P–Americas) 47.88% 57.69% 59.47% 100.03% 119.97%
Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) 66.65% 107.41% 91.92% 97.02% 64.99%
Intermediates and Derivatives (I&D) 75.52% 60.64% 58.26% 65.56% 68.79%
Advanced Polymer Solutions (APS) 48.90% 125.14%
Refining 13.73% 13.89% 6.75% 34.44% 6.27%
Technology 123.31% 92.53% 123.00% 117.39% 97.89%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

Segment profitability ratio Reportable segment The company
Segment ROA Olefins and Polyolefins–Americas (O&P–Americas) Olefins and Polyolefins–Americas (O&P–Americas) segment ROA deteriorated from 2016 to 2017 and from 2017 to 2018.
Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) segment ROA improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.
Intermediates and Derivatives (I&D) Intermediates and Derivatives (I&D) segment ROA improved from 2016 to 2017 and from 2017 to 2018.
Advanced Polymer Solutions (APS) Advanced Polymer Solutions (APS) segment ROA improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.
Refining Refining segment ROA improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018.
Technology Technology segment ROA deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.

Segment ROA: Olefins and Polyolefins–Americas (O&P–Americas)

LyondellBasell Industries N.V.; Olefins and Polyolefins–Americas (O&P–Americas); segment ROA calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
EBITDA 2,762 2,899 2,788 3,661 3,911
Property, plant and equipment, net 5,769 5,025 4,688 3,660 3,260
Segment Profitability Ratio
Segment ROA1 47.88% 57.69% 59.47% 100.03% 119.97%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment ROA = 100 × EBITDA ÷ Property, plant and equipment, net
= 100 × 2,762 ÷ 5,769 = 47.88%

Segment profitability ratio Reportable segment The company
Segment ROA Olefins and Polyolefins–Americas (O&P–Americas) Olefins and Polyolefins–Americas (O&P–Americas) segment ROA deteriorated from 2016 to 2017 and from 2017 to 2018.

Segment ROA: Olefins and Polyolefins–Europe, Asia, International (O&P–EAI)

LyondellBasell Industries N.V.; Olefins and Polyolefins–Europe, Asia, International (O&P–EAI); segment ROA calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
EBITDA 1,163 1,927 1,729 1,825 1,366
Property, plant and equipment, net 1,745 1,794 1,881 1,881 2,102
Segment Profitability Ratio
Segment ROA1 66.65% 107.41% 91.92% 97.02% 64.99%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment ROA = 100 × EBITDA ÷ Property, plant and equipment, net
= 100 × 1,163 ÷ 1,745 = 66.65%

Segment profitability ratio Reportable segment The company
Segment ROA Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) segment ROA improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.

Segment ROA: Intermediates and Derivatives (I&D)

LyondellBasell Industries N.V.; Intermediates and Derivatives (I&D); segment ROA calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
EBITDA 2,011 1,490 1,333 1,475 1,459
Property, plant and equipment, net 2,663 2,457 2,288 2,250 2,121
Segment Profitability Ratio
Segment ROA1 75.52% 60.64% 58.26% 65.56% 68.79%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment ROA = 100 × EBITDA ÷ Property, plant and equipment, net
= 100 × 2,011 ÷ 2,663 = 75.52%

Segment profitability ratio Reportable segment The company
Segment ROA Intermediates and Derivatives (I&D) Intermediates and Derivatives (I&D) segment ROA improved from 2016 to 2017 and from 2017 to 2018.

Segment ROA: Advanced Polymer Solutions (APS)

LyondellBasell Industries N.V.; Advanced Polymer Solutions (APS); segment ROA calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
EBITDA 400 438 427
Property, plant and equipment, net 818 350
Segment Profitability Ratio
Segment ROA1 48.90% 125.14%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment ROA = 100 × EBITDA ÷ Property, plant and equipment, net
= 100 × 400 ÷ 818 = 48.90%

Segment profitability ratio Reportable segment The company
Segment ROA Advanced Polymer Solutions (APS) Advanced Polymer Solutions (APS) segment ROA improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.

Segment ROA: Refining

LyondellBasell Industries N.V.; Refining; segment ROA calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
EBITDA 167 157 72 342 65
Property, plant and equipment, net 1,216 1,130 1,067 993 1,036
Segment Profitability Ratio
Segment ROA1 13.73% 13.89% 6.75% 34.44% 6.27%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment ROA = 100 × EBITDA ÷ Property, plant and equipment, net
= 100 × 167 ÷ 1,216 = 13.73%

Segment profitability ratio Reportable segment The company
Segment ROA Refining Refining segment ROA improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018.

Segment ROA: Technology

LyondellBasell Industries N.V.; Technology; segment ROA calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
EBITDA 328 223 262 243 232
Property, plant and equipment, net 266 241 213 207 237
Segment Profitability Ratio
Segment ROA1 123.31% 92.53% 123.00% 117.39% 97.89%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment ROA = 100 × EBITDA ÷ Property, plant and equipment, net
= 100 × 328 ÷ 266 = 123.31%

Segment profitability ratio Reportable segment The company
Segment ROA Technology Technology segment ROA deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.

Segment Asset Turnover

LyondellBasell Industries N.V., asset turnover by reportable segment

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Olefins and Polyolefins–Americas (O&P–Americas) 1.80 1.99 1.86 2.72 4.28
Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) 6.21 5.70 4.63 6.15 7.23
Intermediates and Derivatives (I&D) 3.60 3.45 3.16 3.45 4.78
Advanced Polymer Solutions (APS) 4.92 8.35
Refining 7.53 6.06 4.81 6.60 11.30
Technology 2.19 1.87 2.25 2.25 2.10

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

Segment activity ratio Reportable segment The company
Segment asset turnover Olefins and Polyolefins–Americas (O&P–Americas) Olefins and Polyolefins–Americas (O&P–Americas) segment asset turnover ratio improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.
Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) segment asset turnover ratio improved from 2016 to 2017 and from 2017 to 2018.
Intermediates and Derivatives (I&D) Intermediates and Derivatives (I&D) segment asset turnover ratio improved from 2016 to 2017 and from 2017 to 2018.
Advanced Polymer Solutions (APS) Advanced Polymer Solutions (APS) segment asset turnover ratio improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018.
Refining Refining segment asset turnover ratio improved from 2016 to 2017 and from 2017 to 2018.
Technology Technology segment asset turnover ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.

Segment Asset Turnover: Olefins and Polyolefins–Americas (O&P–Americas)

LyondellBasell Industries N.V.; Olefins and Polyolefins–Americas (O&P–Americas); segment asset turnover calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Sales and other operating revenues 10,408 10,004 8,722 9,964 13,948
Property, plant and equipment, net 5,769 5,025 4,688 3,660 3,260
Segment Activity Ratio
Segment asset turnover1 1.80 1.99 1.86 2.72 4.28

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment asset turnover = Sales and other operating revenues ÷ Property, plant and equipment, net
= 10,408 ÷ 5,769 = 1.80

Segment activity ratio Reportable segment The company
Segment asset turnover Olefins and Polyolefins–Americas (O&P–Americas) Olefins and Polyolefins–Americas (O&P–Americas) segment asset turnover ratio improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.

Segment Asset Turnover: Olefins and Polyolefins–Europe, Asia, International (O&P–EAI)

LyondellBasell Industries N.V.; Olefins and Polyolefins–Europe, Asia, International (O&P–EAI); segment asset turnover calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Sales and other operating revenues 10,838 10,218 8,718 11,576 15,203
Property, plant and equipment, net 1,745 1,794 1,881 1,881 2,102
Segment Activity Ratio
Segment asset turnover1 6.21 5.70 4.63 6.15 7.23

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment asset turnover = Sales and other operating revenues ÷ Property, plant and equipment, net
= 10,838 ÷ 1,745 = 6.21

Segment activity ratio Reportable segment The company
Segment asset turnover Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) segment asset turnover ratio improved from 2016 to 2017 and from 2017 to 2018.

Segment Asset Turnover: Intermediates and Derivatives (I&D)

LyondellBasell Industries N.V.; Intermediates and Derivatives (I&D); segment asset turnover calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Sales and other operating revenues 9,588 8,472 7,226 7,772 10,130
Property, plant and equipment, net 2,663 2,457 2,288 2,250 2,121
Segment Activity Ratio
Segment asset turnover1 3.60 3.45 3.16 3.45 4.78

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment asset turnover = Sales and other operating revenues ÷ Property, plant and equipment, net
= 9,588 ÷ 2,663 = 3.60

Segment activity ratio Reportable segment The company
Segment asset turnover Intermediates and Derivatives (I&D) Intermediates and Derivatives (I&D) segment asset turnover ratio improved from 2016 to 2017 and from 2017 to 2018.

Segment Asset Turnover: Advanced Polymer Solutions (APS)

LyondellBasell Industries N.V.; Advanced Polymer Solutions (APS); segment asset turnover calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Sales and other operating revenues 4,024 2,922 2,601
Property, plant and equipment, net 818 350
Segment Activity Ratio
Segment asset turnover1 4.92 8.35

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment asset turnover = Sales and other operating revenues ÷ Property, plant and equipment, net
= 4,024 ÷ 818 = 4.92

Segment activity ratio Reportable segment The company
Segment asset turnover Advanced Polymer Solutions (APS) Advanced Polymer Solutions (APS) segment asset turnover ratio improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018.

Segment Asset Turnover: Refining

LyondellBasell Industries N.V.; Refining; segment asset turnover calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Sales and other operating revenues 9,157 6,848 5,135 6,557 11,710
Property, plant and equipment, net 1,216 1,130 1,067 993 1,036
Segment Activity Ratio
Segment asset turnover1 7.53 6.06 4.81 6.60 11.30

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment asset turnover = Sales and other operating revenues ÷ Property, plant and equipment, net
= 9,157 ÷ 1,216 = 7.53

Segment activity ratio Reportable segment The company
Segment asset turnover Refining Refining segment asset turnover ratio improved from 2016 to 2017 and from 2017 to 2018.

Segment Asset Turnover: Technology

LyondellBasell Industries N.V.; Technology; segment asset turnover calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Sales and other operating revenues 583 450 479 465 497
Property, plant and equipment, net 266 241 213 207 237
Segment Activity Ratio
Segment asset turnover1 2.19 1.87 2.25 2.25 2.10

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment asset turnover = Sales and other operating revenues ÷ Property, plant and equipment, net
= 583 ÷ 266 = 2.19

Segment activity ratio Reportable segment The company
Segment asset turnover Technology Technology segment asset turnover ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.

Segment Capital Expenditures to Depreciation

LyondellBasell Industries N.V., capital expenditures to depreciation by reportable segment

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Olefins and Polyolefins–Americas (O&P–Americas) 2.44 1.71 3.82 1.89 2.89
Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) 1.19 0.78 1.14 0.85 0.77
Intermediates and Derivatives (I&D) 1.43 1.19 1.24 1.89 1.07
Advanced Polymer Solutions (APS) 0.90 1.57 1.23
Refining 1.30 1.20 1.37 0.55 0.73
Technology 1.12 0.80 0.88 0.52 0.41

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Olefins and Polyolefins–Americas (O&P–Americas) Olefins and Polyolefins–Americas (O&P–Americas) segment capital expenditures to depreciation ratio deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.
Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) segment capital expenditures to depreciation ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.
Intermediates and Derivatives (I&D) Intermediates and Derivatives (I&D) segment capital expenditures to depreciation ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.
Advanced Polymer Solutions (APS) Advanced Polymer Solutions (APS) segment capital expenditures to depreciation ratio improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.
Refining Refining segment capital expenditures to depreciation ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.
Technology Technology segment capital expenditures to depreciation ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.

Segment Capital Expenditures to Depreciation: Olefins and Polyolefins–Americas (O&P–Americas)

LyondellBasell Industries N.V.; Olefins and Polyolefins–Americas (O&P–Americas); segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Capital expenditures 1,079 741 1,370 668 912
Depreciation and amortization expense 442 433 359 353 316
Segment Financial Ratio
Segment capital expenditures to depreciation1 2.44 1.71 3.82 1.89 2.89

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization expense
= 1,079 ÷ 442 = 2.44

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Olefins and Polyolefins–Americas (O&P–Americas) Olefins and Polyolefins–Americas (O&P–Americas) segment capital expenditures to depreciation ratio deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.

Segment Capital Expenditures to Depreciation: Olefins and Polyolefins–Europe, Asia, International (O&P–EAI)

LyondellBasell Industries N.V.; Olefins and Polyolefins–Europe, Asia, International (O&P–EAI); segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Capital expenditures 248 163 229 186 191
Depreciation and amortization expense 208 210 201 219 248
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.19 0.78 1.14 0.85 0.77

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization expense
= 248 ÷ 208 = 1.19

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) segment capital expenditures to depreciation ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.

Segment Capital Expenditures to Depreciation: Intermediates and Derivatives (I&D)

LyondellBasell Industries N.V.; Intermediates and Derivatives (I&D); segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Capital expenditures 409 332 333 441 241
Depreciation and amortization expense 287 279 269 233 225
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.43 1.19 1.24 1.89 1.07

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization expense
= 409 ÷ 287 = 1.43

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Intermediates and Derivatives (I&D) Intermediates and Derivatives (I&D) segment capital expenditures to depreciation ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.

Segment Capital Expenditures to Depreciation: Advanced Polymer Solutions (APS)

LyondellBasell Industries N.V.; Advanced Polymer Solutions (APS); segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Capital expenditures 62 55 38
Depreciation and amortization expense 69 35 31
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.90 1.57 1.23

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization expense
= 62 ÷ 69 = 0.90

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Advanced Polymer Solutions (APS) Advanced Polymer Solutions (APS) segment capital expenditures to depreciation ratio improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.

Segment Capital Expenditures to Depreciation: Refining

LyondellBasell Industries N.V.; Refining; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Capital expenditures 250 213 224 108 123
Depreciation and amortization expense 192 177 163 196 169
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.30 1.20 1.37 0.55 0.73

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization expense
= 250 ÷ 192 = 1.30

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Refining Refining segment capital expenditures to depreciation ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.

Segment Capital Expenditures to Depreciation: Technology

LyondellBasell Industries N.V.; Technology; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Capital expenditures 48 32 36 24 25
Depreciation and amortization expense 43 40 41 46 61
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.12 0.80 0.88 0.52 0.41

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization expense
= 48 ÷ 43 = 1.12

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Technology Technology segment capital expenditures to depreciation ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.

Sales and other operating revenues

LyondellBasell Industries N.V., sales and other operating revenues by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Olefins and Polyolefins–Americas (O&P–Americas) 10,408 10,004 8,722 9,964 13,948
Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) 10,838 10,218 8,718 11,576 15,203
Intermediates and Derivatives (I&D) 9,588 8,472 7,226 7,772 10,130
Advanced Polymer Solutions (APS) 4,024 2,922 2,601
Refining 9,157 6,848 5,135 6,557 11,710
Technology 583 450 479 465 497
Other (5,594) (4,430) (3,698) (3,599) (5,880)
Total 39,004 34,484 29,183 32,735 45,608

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).


Depreciation and amortization expense

LyondellBasell Industries N.V., depreciation and amortization expense by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Olefins and Polyolefins–Americas (O&P–Americas) 442 433 359 353 316
Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) 208 210 201 219 248
Intermediates and Derivatives (I&D) 287 279 269 233 225
Advanced Polymer Solutions (APS) 69 35 31
Refining 192 177 163 196 169
Technology 43 40 41 46 61
Total 1,241 1,174 1,064 1,047 1,019

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).


Capital expenditures

LyondellBasell Industries N.V., capital expenditures by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Olefins and Polyolefins–Americas (O&P–Americas) 1,079 741 1,370 668 912
Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) 248 163 229 186 191
Intermediates and Derivatives (I&D) 409 332 333 441 241
Advanced Polymer Solutions (APS) 62 55 38
Refining 250 213 224 108 123
Technology 48 32 36 24 25
Other 9 11 13 13 7
Total 2,105 1,547 2,243 1,440 1,499

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).


EBITDA

LyondellBasell Industries N.V., ebitda by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Olefins and Polyolefins–Americas (O&P–Americas) 2,762 2,899 2,788 3,661 3,911
Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) 1,163 1,927 1,729 1,825 1,366
Intermediates and Derivatives (I&D) 2,011 1,490 1,333 1,475 1,459
Advanced Polymer Solutions (APS) 400 438 427
Refining 167 157 72 342 65
Technology 328 223 262 243 232
Other 36 (9) (13) 17
Total 6,867 7,134 6,602 7,533 7,050

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).


Property, plant and equipment, net

LyondellBasell Industries N.V., property, plant and equipment, net by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Olefins and Polyolefins–Americas (O&P–Americas) 5,769 5,025 4,688 3,660 3,260
Olefins and Polyolefins–Europe, Asia, International (O&P–EAI) 1,745 1,794 1,881 1,881 2,102
Intermediates and Derivatives (I&D) 2,663 2,457 2,288 2,250 2,121
Advanced Polymer Solutions (APS) 818 350
Refining 1,216 1,130 1,067 993 1,036
Technology 266 241 213 207 237
Other 2
Total 12,477 10,997 10,137 8,991 8,758

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).