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
Quarterly Data

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 (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Mar 31, 2017 -0.04% = -0.03% × 1.56
Dec 31, 2016 -0.69% = -0.45% × 1.55
Sep 30, 2016 -13.81% = -8.80% × 1.57
Jun 30, 2016 -17.27% = -11.08% × 1.56
Mar 31, 2016 -15.73% = -10.14% × 1.55
Dec 31, 2015 -15.01% = -9.64% × 1.56
Sep 30, 2015 0.86% = 0.59% × 1.46
Jun 30, 2015 20.70% = 13.83% × 1.50
Mar 31, 2015 21.48% = 14.32% × 1.50
Dec 31, 2014 19.42% = 12.14% × 1.60
Sep 30, 2014 20.98% = 13.44% × 1.56
Jun 30, 2014 9.66% = 7.45% × 1.30
Mar 31, 2014 9.98% = 7.76% × 1.29
Dec 31, 2013 10.45% = 8.13% × 1.29
Sep 30, 2013 10.33% = 8.66% × 1.19
Jun 30, 2013 30.08% = 25.60% × 1.18
Mar 31, 2013 28.64% = 24.56% × 1.17
Dec 31, 2012 27.10% = 23.07% × 1.17
Sep 30, 2012 — = — × 1.31
Jun 30, 2012 — = — × 1.18
Mar 31, 2012 — = — × 1.17

Based on: 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), 10-K (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31), 10-K (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-Q (reporting date: 2012-03-31).

Three-Component Disaggregation of ROE

Yahoo! Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Mar 31, 2017 -0.04% = -0.29% × 0.10 × 1.56
Dec 31, 2016 -0.69% = -4.15% × 0.11 × 1.55
Sep 30, 2016 -13.81% = -96.74% × 0.09 × 1.57
Jun 30, 2016 -17.27% = -100.08% × 0.11 × 1.56
Mar 31, 2016 -15.73% = -92.75% × 0.11 × 1.55
Dec 31, 2015 -15.01% = -87.74% × 0.11 × 1.56
Sep 30, 2015 0.86% = 4.90% × 0.12 × 1.46
Jun 30, 2015 20.70% = 142.49% × 0.10 × 1.50
Mar 31, 2015 21.48% = 153.49% × 0.09 × 1.50
Dec 31, 2014 19.42% = 162.87% × 0.07 × 1.60
Sep 30, 2014 20.98% = 166.35% × 0.08 × 1.56
Jun 30, 2014 9.66% = 26.53% × 0.28 × 1.30
Mar 31, 2014 9.98% = 27.55% × 0.28 × 1.29
Dec 31, 2013 10.45% = 29.19% × 0.28 × 1.29
Sep 30, 2013 10.33% = 27.11% × 0.32 × 1.19
Jun 30, 2013 30.08% = 86.13% × 0.30 × 1.18
Mar 31, 2013 28.64% = 82.55% × 0.30 × 1.17
Dec 31, 2012 27.10% = 79.12% × 0.29 × 1.17
Sep 30, 2012 — = — × — × 1.31
Jun 30, 2012 — = — × — × 1.18
Mar 31, 2012 — = — × — × 1.17

Based on: 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), 10-K (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31), 10-K (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-Q (reporting date: 2012-03-31).

Two-Component Disaggregation of ROA

Yahoo! Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Mar 31, 2017 -0.03% = -0.29% × 0.10
Dec 31, 2016 -0.45% = -4.15% × 0.11
Sep 30, 2016 -8.80% = -96.74% × 0.09
Jun 30, 2016 -11.08% = -100.08% × 0.11
Mar 31, 2016 -10.14% = -92.75% × 0.11
Dec 31, 2015 -9.64% = -87.74% × 0.11
Sep 30, 2015 0.59% = 4.90% × 0.12
Jun 30, 2015 13.83% = 142.49% × 0.10
Mar 31, 2015 14.32% = 153.49% × 0.09
Dec 31, 2014 12.14% = 162.87% × 0.07
Sep 30, 2014 13.44% = 166.35% × 0.08
Jun 30, 2014 7.45% = 26.53% × 0.28
Mar 31, 2014 7.76% = 27.55% × 0.28
Dec 31, 2013 8.13% = 29.19% × 0.28
Sep 30, 2013 8.66% = 27.11% × 0.32
Jun 30, 2013 25.60% = 86.13% × 0.30
Mar 31, 2013 24.56% = 82.55% × 0.30
Dec 31, 2012 23.07% = 79.12% × 0.29
Sep 30, 2012 — = — × —
Jun 30, 2012 — = — × —
Mar 31, 2012 — = — × —

Based on: 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), 10-K (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31), 10-K (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-Q (reporting date: 2012-03-31).