Stock Analysis on Net

eBay Inc. (NASDAQ:EBAY)

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

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

Microsoft Excel

Two-Component Disaggregation of ROE

eBay Inc., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2018 40.28% = 11.09% × 3.63
Dec 31, 2017 -12.60% = -3.91% × 3.22
Dec 31, 2016 68.94% = 30.47% × 2.26
Dec 31, 2015 26.23% = 9.70% × 2.70
Dec 31, 2014 0.23% = 0.10% × 2.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).


Three-Component Disaggregation of ROE

eBay Inc., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2018 40.28% = 23.54% × 0.47 × 3.63
Dec 31, 2017 -12.60% = -10.62% × 0.37 × 3.22
Dec 31, 2016 68.94% = 80.92% × 0.38 × 2.26
Dec 31, 2015 26.23% = 20.08% × 0.48 × 2.70
Dec 31, 2014 0.23% = 0.26% × 0.40 × 2.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).


Five-Component Disaggregation of ROE

eBay Inc., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 31, 2018 40.28% = 0.93 × 0.89 × 28.35% × 0.47 × 3.63
Dec 31, 2017 -12.60% = -0.45 × 0.89 × 26.80% × 0.37 × 3.22
Dec 31, 2016 68.94% = 2.00 × 0.94 × 42.96% × 0.38 × 2.26
Dec 31, 2015 26.23% = 0.79 × 0.94 × 27.09% × 0.48 × 2.70
Dec 31, 2014 0.23% = 0.01 × 0.97 × 20.41% × 0.40 × 2.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).


Two-Component Disaggregation of ROA

eBay Inc., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2018 11.09% = 23.54% × 0.47
Dec 31, 2017 -3.91% = -10.62% × 0.37
Dec 31, 2016 30.47% = 80.92% × 0.38
Dec 31, 2015 9.70% = 20.08% × 0.48
Dec 31, 2014 0.10% = 0.26% × 0.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).


Four-Component Disaggregation of ROA

eBay Inc., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2018 11.09% = 0.93 × 0.89 × 28.35% × 0.47
Dec 31, 2017 -3.91% = -0.45 × 0.89 × 26.80% × 0.37
Dec 31, 2016 30.47% = 2.00 × 0.94 × 42.96% × 0.38
Dec 31, 2015 9.70% = 0.79 × 0.94 × 27.09% × 0.48
Dec 31, 2014 0.10% = 0.01 × 0.97 × 20.41% × 0.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).


Disaggregation of Net Profit Margin

eBay Inc., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2018 23.54% = 0.93 × 0.89 × 28.35%
Dec 31, 2017 -10.62% = -0.45 × 0.89 × 26.80%
Dec 31, 2016 80.92% = 2.00 × 0.94 × 42.96%
Dec 31, 2015 20.08% = 0.79 × 0.94 × 27.09%
Dec 31, 2014 0.26% = 0.01 × 0.97 × 20.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).