Stock Analysis on Net

EMC Corp. (NYSE:EMC)

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

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

Microsoft Excel

Two-Component Disaggregation of ROE

EMC Corp., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2015 9.41% = 4.27% × 2.20
Dec 31, 2014 12.39% = 5.91% × 2.10
Dec 31, 2013 12.95% = 6.30% × 2.06
Dec 31, 2012 12.22% = 7.18% × 1.70
Dec 31, 2011 12.98% = 7.18% × 1.81

Based on: 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), 10-K (reporting date: 2011-12-31).


The financial data reveals several notable trends over the five-year period from 2011 to 2015. Key profitability and leverage metrics demonstrate changes that indicate shifts in operational efficiency and financing structure.

Return on Assets (ROA)
The ROA metric shows a downward trend, declining steadily from 7.18% in 2011 and 2012 to 4.27% in 2015. This indicates a decreasing efficiency in generating profits from the company's assets over the given period. The gradual decline suggests that the company's ability to utilize its assets effectively is weakening.
Financial Leverage
Financial leverage experienced moderate fluctuation. Initially, it decreased slightly from 1.81 in 2011 to 1.7 in 2012, indicating a marginal reduction in the degree to which the company is relying on debt financing. However, from 2013 onwards, leverage increased steadily, reaching 2.2 by 2015. This upward trend suggests a growing reliance on debt or other liabilities to finance assets, which could elevate the financial risk profile.
Return on Equity (ROE)
ROE displayed variability with a general downward tendency in the latter years. The ratio decreased from 12.98% in 2011 to 9.41% in 2015, fluctuating between the years but ultimately trending lower. This mirrors the declining ROA, implying that equity holders experienced reduced profitability. The decline in ROE, coupled with rising financial leverage, indicates that increased debt did not translate into proportional gains in equity returns.

In summary, the company appears to be facing diminishing returns on its assets and equity during this timeframe, while concurrently increasing its financial leverage. This combination points to reduced operational profitability alongside greater financial risk, warranting closer examination of asset utilization and capital structure strategies.


Three-Component Disaggregation of ROE

EMC Corp., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2015 9.41% = 8.06% × 0.53 × 2.20
Dec 31, 2014 12.39% = 11.10% × 0.53 × 2.10
Dec 31, 2013 12.95% = 12.44% × 0.51 × 2.06
Dec 31, 2012 12.22% = 12.58% × 0.57 × 1.70
Dec 31, 2011 12.98% = 12.30% × 0.58 × 1.81

Based on: 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), 10-K (reporting date: 2011-12-31).


The financial performance over the analyzed periods reveals several notable trends in profitability, efficiency, leverage, and returns.

Net Profit Margin
The net profit margin exhibited a gradual decline from 12.3% in 2011 to 8.06% in 2015. After a slight rise in 2012 to 12.58%, it decreased steadily each year, reaching its lowest point in 2015. This trend suggests a diminishing ability to convert revenue into net profit over time.
Asset Turnover
The asset turnover ratio showed a moderate decline from 0.58 in 2011 to 0.51 in 2013, indicating reduced asset utilization efficiency. It then stabilized slightly, maintaining a ratio around 0.53 for the years 2014 and 2015. Overall, the company experienced a slight decline in how effectively assets generate sales.
Financial Leverage
Financial leverage increased consistently from 1.81 in 2011 to 2.2 in 2015. This upward trend points to greater reliance on debt or other liabilities relative to equity, which could signal increased financial risk but also the potential for amplified returns on equity if managed properly.
Return on Equity (ROE)
The return on equity fluctuated modestly in the early years, with values around 12-13% from 2011 to 2014, but declined sharply to 9.41% by 2015. This decline mirrors the drop in net profit margin and possibly reflects the combined effects of lower profitability despite higher leverage.

Five-Component Disaggregation of ROE

EMC Corp., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 31, 2015 9.41% = 0.74 × 0.94 × 11.59% × 0.53 × 2.20
Dec 31, 2014 12.39% = 0.76 × 0.96 × 15.26% × 0.53 × 2.10
Dec 31, 2013 12.95% = 0.79 × 0.96 × 16.44% × 0.51 × 2.06
Dec 31, 2012 12.22% = 0.75 × 0.98 × 17.17% × 0.57 × 1.70
Dec 31, 2011 12.98% = 0.79 × 0.95 × 16.35% × 0.58 × 1.81

Based on: 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), 10-K (reporting date: 2011-12-31).


The financial data reveals several noteworthy trends over the five-year period from 2011 to 2015. Key ratios related to tax, interest, profitability, asset efficiency, leverage, and overall return exhibit distinct movements.

Tax Burden
The tax burden ratio shows a gradual decline over the period, decreasing from 0.79 in 2011 to 0.74 in 2015. This indicates a slightly reduced impact of taxes on earnings before taxes, suggesting either improved tax efficiency or changes in tax regulations favoring the company.
Interest Burden
The interest burden ratio remains relatively stable, fluctuating within a narrow range from 0.94 to 0.98. This stability indicates consistent management of interest expenses relative to EBIT, with only minor variations across the years.
EBIT Margin
The EBIT margin has shown a declining trend, falling from 16.35% in 2011 to 11.59% in 2015. The decrease is particularly notable in 2015, suggesting either rising operating costs, pricing pressure, or other factors negatively impacting operating profitability.
Asset Turnover
The asset turnover ratio declines from 0.58 in 2011 to a low of 0.51 in 2013, then recovers slightly to 0.53 by 2015. This pattern implies a reduction in efficiency in generating revenue from assets initially, with some recovery towards the end of the period but still below the initial level.
Financial Leverage
Financial leverage shows an increasing trend, rising from 1.81 in 2011 to 2.20 in 2015. The consistent rise suggests that the company has increased its use of debt relative to equity, which could amplify returns but also increase financial risk.
Return on Equity (ROE)
ROE demonstrates a downward trend, declining from 12.98% in 2011 to 9.41% in 2015. Despite fluctuations in other ratios, the overall drop reflects weaker profitability or efficiency in generating returns for shareholders. The decrease coincides with declining EBIT margins and asset turnover, partially offset by higher financial leverage.

Overall, the data suggest challenges in maintaining profitability and operational efficiency, with lower EBIT margins and asset turnover contributing to reduced ROE. Increased financial leverage may have been employed to support growth or operations but has not offset the declines in profitability metrics. The stable interest burden and slightly lowered tax burden offer some cost control benefits, but these have not prevented the downward trend in returns to equity holders over the analyzed period.


Two-Component Disaggregation of ROA

EMC Corp., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2015 4.27% = 8.06% × 0.53
Dec 31, 2014 5.91% = 11.10% × 0.53
Dec 31, 2013 6.30% = 12.44% × 0.51
Dec 31, 2012 7.18% = 12.58% × 0.57
Dec 31, 2011 7.18% = 12.30% × 0.58

Based on: 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), 10-K (reporting date: 2011-12-31).


Net Profit Margin
The net profit margin shows a declining trend over the five-year period. Starting at 12.3% in 2011, it slightly increased to 12.58% in 2012, followed by a marginal decrease to 12.44% in 2013. From 2013 onwards, the margin declined more noticeably, dropping to 11.1% in 2014 and further down to 8.06% in 2015. This downward trend indicates decreasing profitability relative to revenue.
Asset Turnover
The asset turnover ratio remained relatively stable but exhibited a slight downward movement overall. It started at 0.58 in 2011, decreased slightly to 0.57 in 2012, and then declined further to 0.51 in 2013. The ratio stabilized at 0.53 in both 2014 and 2015. This suggests a modest reduction in the efficiency of using assets to generate sales, particularly noticeable during the 2012-2013 period.
Return on Assets (ROA)
Return on assets followed a consistent declining pattern throughout the period. Starting at 7.18% in both 2011 and 2012, it decreased to 6.3% in 2013, then to 5.91% in 2014, and eventually to 4.27% in 2015. The downward trend reflects a decreasing ability to generate profit from the company’s asset base.
Overall Interpretation
The combined trends in net profit margin, asset turnover, and ROA indicate a general decline in profitability and asset efficiency over the five years. Despite relatively stable asset turnover from 2013 onwards, declines in profit margin have significantly impacted overall returns on assets. This suggests that issues affecting profit margins, such as rising costs or pricing pressures, are likely contributors to the declining financial performance.

Four-Component Disaggregation of ROA

EMC Corp., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2015 4.27% = 0.74 × 0.94 × 11.59% × 0.53
Dec 31, 2014 5.91% = 0.76 × 0.96 × 15.26% × 0.53
Dec 31, 2013 6.30% = 0.79 × 0.96 × 16.44% × 0.51
Dec 31, 2012 7.18% = 0.75 × 0.98 × 17.17% × 0.57
Dec 31, 2011 7.18% = 0.79 × 0.95 × 16.35% × 0.58

Based on: 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), 10-K (reporting date: 2011-12-31).


Tax Burden
The tax burden ratio demonstrates a general declining trend over the analyzed period, decreasing from 0.79 in 2011 to 0.74 in 2015. This decline indicates a slight reduction in the proportion of earnings retained after taxes, suggesting either increased tax efficiency or changing tax policies affecting the company.
Interest Burden
The interest burden ratio remains relatively stable with minimal fluctuations, moving slightly between 0.94 and 0.98 from 2011 to 2015. This stability implies consistent interest expenses relative to earnings before interest and taxes, reflecting steady debt management or financing costs.
EBIT Margin
The EBIT margin shows a notable decreasing trend, dropping from 16.35% in 2011 to 11.59% in 2015. This decline suggests a reduction in operational profitability, potentially due to increased operating costs, competitive pressures, or other factors impacting earnings before interest and taxes.
Asset Turnover
Asset turnover exhibits a slight downward tendency, starting at 0.58 in 2011 and decreasing to a stable level of 0.53 by 2015 after a dip to 0.51 in 2013. This pattern indicates a modest decline in the efficiency with which the company utilizes assets to generate revenue.
Return on Assets (ROA)
The return on assets reflects a consistent decline across the timeframe, moving from 7.18% in 2011 to 4.27% in 2015. This decreasing trend denotes diminishing overall profitability relative to asset base, likely influenced by the combined effects of lower EBIT margins and decreased asset turnover.

Disaggregation of Net Profit Margin

EMC Corp., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2015 8.06% = 0.74 × 0.94 × 11.59%
Dec 31, 2014 11.10% = 0.76 × 0.96 × 15.26%
Dec 31, 2013 12.44% = 0.79 × 0.96 × 16.44%
Dec 31, 2012 12.58% = 0.75 × 0.98 × 17.17%
Dec 31, 2011 12.30% = 0.79 × 0.95 × 16.35%

Based on: 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), 10-K (reporting date: 2011-12-31).


Tax Burden
The tax burden ratio demonstrates a generally declining trend over the analyzed period, decreasing from 0.79 in 2011 to 0.74 in 2015. This indicates a gradual reduction in the proportion of pre-tax earnings paid as tax, potentially improving net income retention.
Interest Burden
The interest burden ratio exhibits minor fluctuations but remains relatively stable, ranging between 0.94 and 0.98 throughout the period. This stability suggests consistent interest expense relative to earnings before interest and taxes (EBIT), with no significant changes in debt servicing costs.
EBIT Margin
The EBIT margin shows an overall declining trend, starting at 16.35% in 2011, peaking slightly at 17.17% in 2012, and subsequently decreasing each year to 11.59% in 2015. This downward trajectory reflects a reduction in operating profitability, which may be caused by increasing operating expenses or declining operating revenues.
Net Profit Margin
The net profit margin mirrors the EBIT margin trend, beginning at 12.3% in 2011, slightly rising to 12.58% in 2012, remaining relatively steady in 2013, and then declining to 8.06% by 2015. The sharper decline in the later years suggests that net profitability was particularly affected, possibly due to increased costs, lower revenues, or other non-operating factors.