Stock Analysis on Net

LyondellBasell Industries N.V. (NYSE:LYB)

$22.49

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

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Quarterly Data

Microsoft Excel

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Two-Component Disaggregation of ROE

LyondellBasell Industries N.V., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
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 = ×

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).


The analysis of the quarterly financial data over the specified periods reveals important trends and shifts in the key financial ratios: Return on Assets (ROA), Financial Leverage, and Return on Equity (ROE).

Return on Assets (ROA)

The ROA shows a general upward trend from the beginning of the recorded data in early 2014 through the end of 2018, starting around 17.19% and reaching a peak of approximately 21.6% in the third quarter of 2018. This indicates improving efficiency in using assets to generate earnings over this time. However, following this peak, ROA exhibits a noticeable decline through mid-2019, falling to 11.61% by the second quarter of 2019. This drop may suggest a reduction in asset profitability or increased asset base not matched by earnings growth in recent quarters.

Financial Leverage

The financial leverage ratio has experienced variability, moving from about 2.36 at the start of 2014 up to a high near 3.88 at the end of 2016. This indicates an increasing use of debt financing over time, reaching a peak level towards late 2016. Following this peak, leverage declines progressively through 2017 and 2018, dropping to around 2.55 by mid-2018, before fluctuating slightly upwards again through mid-2019 ending near 2.91. The initial increase suggests growing reliance on debt, but the subsequent decline points to a potential deleveraging effort or shift in capital structure strategy.

Return on Equity (ROE)

ROE demonstrates significant volatility but generally high profitability from equity, rising from early figures around 50.2% in 2014 to peaks exceeding 68% in early 2016. This strong performance is indicative of effective equity utilization possibly boosted by increased financial leverage. After peaking, ROE begins a consistent downward trajectory, declining to 33.77% by mid-2019. This trend suggests declining net income relative to shareholders' equity or potentially an impact of reduced leverage. The divergence between ROE and ROA trends in the latter period implies that changes in leverage notably influence returns to equity holders.

In summary, the company showed strong asset and equity profitability through 2018, supported by increased leverage until about 2016. Post-2018, declining ROA and ROE alongside reduced or stabilized leverage ratios imply potential challenges in maintaining profitability and asset efficiency. These patterns warrant further investigation into operational performance, debt management, and external economic factors affecting the recent downturn in returns.


Three-Component Disaggregation of ROE

LyondellBasell Industries N.V., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
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 = × ×

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).


The analysis of the quarterly financial metrics over the presented periods reveals several noteworthy trends in profitability, efficiency, leverage, and return for the company.

Net Profit Margin (%)
The net profit margin exhibits an overall positive trajectory from March 2015 through December 2018, beginning at 9.15% and peaking at 15.51% in September 2018. After this peak, a decline is observed, with the margin decreasing to 9.82% by June 2019. This suggests an improvement in profitability per unit of revenue for most of the period, followed by a weakening in recent quarters.
Asset Turnover (ratio)
Asset turnover ratios start higher, at 1.88 in March 2015, then show a gradual downward trend reaching 1.22 by December 2016. A modest recovery occurs afterwards, peaking at 1.39 in September 2018, before dipping again to 1.18 by June 2019. This pattern indicates fluctuating efficiency in using assets to generate sales, with some inefficiencies noted during the midpoint of the period and slight recovery before falling again.
Financial Leverage (ratio)
Financial leverage shows a rising trend from 2.36 in March 2014 to a peak of 3.88 in December 2016, indicating increasing use of debt or liabilities relative to equity over this timeframe. Thereafter, a notable decline occurs, reaching 2.55 in June 2018. This suggests a strategic deleveraging or reduction in financial risk, though the leverage slightly increases again towards June 2019.
Return on Equity (ROE) (%)
ROE begins above 50% at the start of available data and climbs to a high of 68.41% in June 2016, indicating strong returns generated on shareholders’ equity during this period. Following the peak, ROE declines steadily, down to 33.77% by June 2019. Despite the decline, ROE remains relatively robust, though the decreasing trend points to reduced profitability or efficiency in equity utilization in recent quarters.

In summary, the data reflects a period of increasing profitability and return on equity alongside rising leverage and fluctuating asset efficiency up to roughly 2016. Subsequently, a phase of deleveraging, margin contraction, and modest declines in ROE and asset turnover ensues, which may indicate changes in business conditions, cost structure, or capital management strategies.


Five-Component Disaggregation of ROE

LyondellBasell Industries N.V., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
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 = × × × ×

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).


The financial data reveals several distinct trends across the analyzed periods related to profitability, efficiency, and leverage.

Tax Burden
The tax burden ratio shows stability in the initial periods with values around 0.72 to 0.74, indicating a consistent proportion of earnings paid as taxes. However, from 2017 onwards, there is a noticeable increase reaching above 0.9 and even surpassing 1.0 briefly, suggesting a higher effective tax rate in those quarters before settling back to around 0.84–0.89 in 2019.
Interest Burden
Interest burden remains relatively stable throughout the periods, fluctuating slightly around 0.92 to 0.95. This stability suggests consistent management of interest expenses relative to earnings before interest and taxes.
EBIT Margin
The EBIT margin improved significantly from approximately 13.3% in early 2014 to a peak near 20.4% in mid-2016, reflecting improved operational profitability. Following this peak, there is a gradual decline through 2017 to 2019, ending near 12.68% in mid-2019, indicating diminishing profitability possibly due to rising costs or pressure on pricing.
Asset Turnover
Asset turnover shows a declining trend from around 1.88 in early 2014 to 1.22 by late 2016, indicating a decrease in efficiency in utilizing assets to generate revenue. After this low point, there is a partial recovery with turnover ratios improving into the mid-1.3 range during 2017 and 2018, but this declines again to approximately 1.18 in mid-2019.
Financial Leverage
Financial leverage increased steadily from 2.36 in early 2014 to a peak near 3.88 in late 2016, indicating an increased use of debt relative to equity. From 2017 onwards, leverage declined to around 2.9 by mid-2019, showing a reduction in financial risk and possibly deleveraging efforts.
Return on Equity (ROE)
ROE exhibits a strong rise from 50.2% in early 2014 to a peak of above 68% in 2016, driven likely by increased margins and leverage. Post-2016, ROE declines significantly, reaching approximately 33.77% by mid-2019, reflecting the combined effects of reduced profitability, efficiency, and lower leverage.

Overall, the data suggests that the company experienced a phase of rising profitability and leverage up to about 2016, followed by a period of declining operational efficiency and profitability alongside reduced leverage. The fluctuations in tax burden in the later periods could also have impacted net returns. The downward trends in EBIT margin, asset turnover, and ROE after 2016 highlight emerging challenges in sustaining prior performance levels.


Two-Component Disaggregation of ROA

LyondellBasell Industries N.V., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
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 = ×

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).


The financial data exhibits several notable patterns across the presented quarters, focusing on net profit margin, asset turnover, and return on assets (ROA).

Net Profit Margin
Beginning in the first quarter of 2015, the net profit margin shows an overall increasing trend peaking in the third quarter of 2018 at 15.51%. After this peak, a decline is observable towards mid-2019, dropping to 9.82% by June 2019. The margin increased consistently from 9.15% in the first quarter of 2015 up to around 15% through 2017 and early 2018, indicating improved profitability over that period before the subsequent reduction.
Asset Turnover
The asset turnover ratio starts near 1.88 in the first quarter of 2015 and declines steadily through 2016, reaching a low of approximately 1.22 by the fourth quarter of 2016. From early 2017, a modest recovery is evident, with ratios climbing back up to around 1.39 in late 2018. However, this is followed by a decline observed in 2019, ending near 1.18 by mid-year. This pattern suggests a decreasing efficiency in utilizing assets initially, a partial recovery, and then a further decline in asset utilization efficiency.
Return on Assets (ROA)
ROA follows a similar pattern to net profit margin, showing an upward trend from 17.19% in the first quarter of 2015, peaking with the highest value of 21.6% in the third quarter of 2018. Thereafter, a declining trend emerges, with ROA falling to 11.61% by the second quarter of 2019. This progression reflects cyclical variations in overall asset profitability, with strong performance from 2015 through mid-2018, followed by a weakening phase.

In summary, the data reflects a period of improving profitability and asset efficiency from 2015 to approximately mid-2018, characterized by rising net profit margin and ROA, alongside a fluctuating but improving asset turnover after an initial decline. Post mid-2018, all three metrics indicate a downward trend, possibly suggesting challenges in profitability and operational efficiency during 2019.


Four-Component Disaggregation of ROA

LyondellBasell Industries N.V., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
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 = × × ×

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).


The quarterly financial data reveals several noteworthy trends across key performance ratios from early 2014 through mid-2019. Overall, variations in profitability, efficiency, and burden ratios indicate evolving operational and financial conditions.

Tax Burden Ratio
Starting from around 0.73 in early 2015, the tax burden ratio remained relatively stable through 2016 and early 2017, fluctuating narrowly between 0.72 and 0.74. From early 2017 onward, a marked increase is observed, peaking at above 1.0 by the end of 2018. Subsequently, a decline occurs in 2019, settling near 0.84 by mid-year. This pattern suggests an increased effective tax rate in the 2017-2018 period with some easing thereafter.
Interest Burden Ratio
The interest burden ratio maintained a consistent level near 0.95 from early 2015 through late 2016. Starting in 2017, a slight downward trend is noticeable, with values declining to approximately 0.92 by mid-2019. This decrease indicates a marginal increase in interest expense relative to earnings before interest and taxes over time.
EBIT Margin
EBIT margin shows a strong upward trajectory from 13.3% in early 2015, rising steadily to reach a peak near 20.4% by mid-2016. Following this peak, margins experienced a gradual decline, dropping to about 12.7% by mid-2019. The initial rise indicates improving operational profitability, while the subsequent decrease suggests eroding margins possibly due to increased costs or competitive pressures.
Asset Turnover Ratio
Asset turnover exhibited a persistent downward slope from 1.88 in early 2015 to approximately 1.18 by mid-2019. This decline reflects a reduced efficiency in utilizing assets to generate sales over the period, potentially indicating asset base growth outpacing revenue or declining sales efficiency.
Return on Assets (ROA)
ROA rose from 17.19% in early 2015, peaking at 21.6% towards mid-2018, reflecting enhanced overall profitability and efficient asset use during this time. However, a significant downturn ensued through 2018 and 2019, with ROA decreasing to about 11.6% by mid-2019. This fall suggests diminished returns from assets, likely linked to the decreasing EBIT margin and asset turnover trends.

In summary, the period features an initial improvement in profitability and asset efficiency metrics until roughly 2016-2017, followed by a downturn marked by lower margins, declining asset utilization, and reduced returns. The increasing tax burden and slightly rising interest expenses further contributed to pressure on net profitability in the later years analyzed.


Disaggregation of Net Profit Margin

LyondellBasell Industries N.V., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
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 = × ×

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).


The data reveals several financial performance trends over the periods from March 2014 through June 2019. The analysis focuses on tax burden, interest burden, EBIT margin, and net profit margin, highlighting notable changes and patterns.

Tax Burden
The tax burden ratio begins appearing in the first quarter of 2015, initially stable around 0.72 to 0.74 through 2016 and early 2017, indicating a relatively consistent effective tax rate. However, starting in the first quarter of 2018, this ratio increases substantially, peaking at 1.01 in the last quarter of 2018, before slightly declining toward mid-2019 but remaining elevated above earlier years. This suggests a period of higher tax expenses or a shift in tax policy impacting profitability after early 2017.
Interest Burden
The interest burden ratio remains relatively stable throughout the entire period from 2015 to mid-2019, fluctuating narrowly between 0.92 and 0.95. This consistency indicates steady interest expenses relative to earnings before interest and taxes, reflecting a stable debt servicing cost or financial structure over the period.
EBIT Margin
The EBIT margin shows a positive upward trend from 2014 into late 2015, rising from 13.3% to a peak of 20.4% in the second quarter of 2016. After that peak, a gradual decline sets in, with margins falling steadily through 2017 and especially during 2018 and 2019, ending at 12.68% by mid-2019. This declining trend after 2016 suggests decreasing operating profitability possibly due to increased costs, lower revenue growth, or competitive pressures.
Net Profit Margin
The net profit margin follows a similar pattern to the EBIT margin, improving steadily from 9.15% in early 2015 to a high of 15.51% by the third quarter of 2018. Beyond this point, net profitability experiences a sharp decline, dropping to 9.82% by the second quarter of 2019. Despite some fluctuations, the overall result is a cycle of growth in net profit margins through mid-2018 followed by a significant downturn, corresponding with the rise in the tax burden and the decline in EBIT margin, indicating that tax pressures and operational challenges may have constrained net profits.