Stock Analysis on Net
Stock Analysis on Net

Yahoo! Inc. (NASDAQ:YHOO)

This company has been moved to the archive! The financial data has not been updated since May 9, 2017.

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

Microsoft Excel

Decomposing ROE involves expressing net income divided by shareholders’ equity as the product of component ratios.

Two-Component Disaggregation of ROE

Yahoo! Inc., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2016 -0.69% = -0.45% × 1.55
Dec 31, 2015 -15.01% = -9.64% × 1.56
Dec 31, 2014 19.42% = 12.14% × 1.60
Dec 31, 2013 10.45% = 8.13% × 1.29
Dec 31, 2012 27.10% = 23.07% × 1.17

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

Three-Component Disaggregation of ROE

Yahoo! Inc., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2016 -0.69% = -4.15% × 0.11 × 1.55
Dec 31, 2015 -15.01% = -87.74% × 0.11 × 1.56
Dec 31, 2014 19.42% = 162.87% × 0.07 × 1.60
Dec 31, 2013 10.45% = 29.19% × 0.28 × 1.29
Dec 31, 2012 27.10% = 79.12% × 0.29 × 1.17

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

Five-Component Disaggregation of ROE

Yahoo! Inc., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 31, 2016 -0.69% = — × — × -5.16% × 0.11 × 1.55
Dec 31, 2015 -15.01% = — × — × -88.09% × 0.11 × 1.56
Dec 31, 2014 19.42% = 0.65 × 0.99 × 251.80% × 0.07 × 1.60
Dec 31, 2013 10.45% = 0.90 × 0.99 × 32.77% × 0.28 × 1.29
Dec 31, 2012 27.10% = 0.67 × 1.00 × 118.21% × 0.29 × 1.17

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

Two-Component Disaggregation of ROA

Yahoo! Inc., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2016 -0.45% = -4.15% × 0.11
Dec 31, 2015 -9.64% = -87.74% × 0.11
Dec 31, 2014 12.14% = 162.87% × 0.07
Dec 31, 2013 8.13% = 29.19% × 0.28
Dec 31, 2012 23.07% = 79.12% × 0.29

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

Four-Component Disaggregation of ROA

Yahoo! Inc., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2016 -0.45% = — × — × -5.16% × 0.11
Dec 31, 2015 -9.64% = — × — × -88.09% × 0.11
Dec 31, 2014 12.14% = 0.65 × 0.99 × 251.80% × 0.07
Dec 31, 2013 8.13% = 0.90 × 0.99 × 32.77% × 0.28
Dec 31, 2012 23.07% = 0.67 × 1.00 × 118.21% × 0.29

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

Disaggregation of Net Profit Margin

Yahoo! Inc., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2016 -4.15% = — × — × -5.16%
Dec 31, 2015 -87.74% = — × — × -88.09%
Dec 31, 2014 162.87% = 0.65 × 0.99 × 251.80%
Dec 31, 2013 29.19% = 0.90 × 0.99 × 32.77%
Dec 31, 2012 79.12% = 0.67 × 1.00 × 118.21%

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