Stock Analysis on Net
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.

Common-Size Balance Sheet: Liabilities and Stockholders’ Equity 
Quarterly Data

EMC Corp., common-size consolidated balance sheet: liabilities and stockholders’ equity (quarterly data)

Microsoft Excel
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 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011 Jun 30, 2011 Mar 31, 2011
Accounts payable 2.48 2.27 3.53 2.46 2.72 2.79 3.70 2.46 2.67 2.43 3.13 2.48 2.28 2.46 2.73 2.94 2.52 2.71 3.21 3.11 3.04 2.93
Accrued expenses 5.86 5.96 6.70 6.24 6.29 6.51 6.85 6.40 6.19 6.06 6.07 6.05 6.02 6.27 6.63 6.35 6.64 6.61 6.87 7.27 6.97 6.56
Notes converted and payable 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.63 0.00 0.00 0.00 0.00 0.00 0.00 0.04 4.96 0.00 0.00 0.00
Income taxes payable 0.61 0.27 1.31 0.46 0.36 0.24 1.86 0.99 0.59 0.16 1.39 0.45 0.36 0.15 1.35 0.79 0.54 0.07 0.45 0.00 0.00 0.00
Short-term debt 1.71 2.02 2.79 4.34 4.34 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Current portion of convertible debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.72 3.76 4.32 4.34 4.48 4.64 4.73 4.68 10.12 10.12 10.40
Deferred revenue 13.74 14.17 13.32 13.64 14.17 14.68 13.12 12.65 12.81 12.61 11.51 11.42 11.26 12.83 12.02 11.93 11.97 11.99 10.09 10.25 9.91 10.12
Current liabilities 24.39% 24.69% 27.64% 27.15% 27.88% 24.21% 25.52% 22.51% 22.26% 21.26% 25.73% 24.12% 23.67% 26.04% 27.07% 26.49% 26.30% 26.15% 30.28% 30.75% 30.05% 30.01%
Income taxes payable 1.04 1.02 0.99 0.84 0.71 0.67 0.67 0.64 0.67 0.65 0.65 0.70 0.67 0.80 0.77 0.91 0.68 0.69 0.70 0.75 0.79 0.86
Deferred revenue 10.16 10.37 9.85 9.78 9.68 10.01 9.03 9.04 9.07 9.34 8.07 7.66 7.38 8.37 7.82 7.90 8.22 8.01 7.92 7.40 6.82 6.62
Deferred income taxes 0.00 0.00 0.00 0.70 0.51 0.62 0.60 0.81 1.10 0.97 0.92 1.13 1.16 1.44 1.51 1.05 0.66 1.78 1.76 1.92 1.95 2.28
Long-term debt 11.72 11.98 11.75 12.07 12.20 12.69 11.98 12.20 12.36 12.47 11.98 12.32 12.37 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Other liabilities 1.01 1.06 1.03 1.04 0.97 0.97 0.94 0.85 0.85 0.83 0.77 0.82 0.79 0.89 0.89 0.84 0.85 0.87 0.84 0.75 0.80 0.80
Convertible debt, excluding current portion 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.02 0.06 0.11 0.15 0.20 0.25 0.30 0.35 0.45 0.54 0.66
Noncurrent liabilities 23.93% 24.43% 23.62% 24.43% 24.07% 24.96% 23.21% 23.55% 24.06% 24.26% 22.39% 22.64% 22.43% 11.61% 11.14% 10.91% 10.66% 11.66% 11.57% 11.27% 10.90% 11.21%
Total liabilities 48.33% 49.13% 51.26% 51.58% 51.94% 49.17% 48.73% 46.05% 46.32% 45.52% 48.12% 46.76% 46.10% 37.65% 38.21% 37.39% 36.96% 37.81% 41.85% 42.01% 40.95% 41.22%
Preferred stock, par value $0.01; none outstanding 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Common stock, par value $0.01 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.05 0.05 0.04 0.05 0.05 0.05 0.06 0.06 0.06 0.06 0.06 0.06 0.06 0.07
Additional paid-in capital 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.89 1.84 3.09 3.07 5.13 6.64 9.02 9.70 10.56 10.76 10.34 8.91 8.69 11.11 10.99
Retained earnings 48.52 48.38 46.55 46.22 45.73 48.25 48.47 48.85 48.72 48.35 46.05 45.51 44.87 50.83 49.52 49.26 49.65 49.16 47.04 47.14 45.41 45.33
Accumulated other comprehensive loss, net -1.20 -1.22 -1.24 -1.18 -1.02 -1.06 -0.80 -0.44 -0.37 -0.52 -0.52 -0.65 -0.67 -0.63 -0.55 -0.43 -0.58 -0.55 -0.69 -0.68 -0.29 -0.18
Total EMC Corporation’s shareholders’ equity 47.36% 47.20% 45.35% 45.09% 44.75% 47.23% 47.72% 50.34% 50.23% 50.97% 48.64% 50.04% 50.88% 59.27% 58.73% 59.45% 59.89% 59.01% 55.33% 55.22% 56.30% 56.20%
Non-controlling interests 4.31 3.67 3.39 3.33 3.31 3.59 3.55 3.60 3.45 3.50 3.24 3.20 3.02 3.08 3.06 3.15 3.15 3.18 2.83 2.77 2.75 2.58
Total shareholders’ equity 51.67% 50.87% 48.74% 48.42% 48.06% 50.83% 51.27% 53.95% 53.68% 54.48% 51.88% 53.24% 53.90% 62.35% 61.79% 62.61% 63.04% 62.19% 58.15% 57.99% 59.05% 58.78%
Total liabilities and shareholders’ equity 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

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

The analysis of the financial data reveals several notable trends and fluctuations in the composition of liabilities and shareholders' equity over the examined periods.

Current Liabilities
Current liabilities as a percentage of total liabilities and shareholders’ equity exhibit some variability, initially declining from around 30% in early 2011 to a lower range near 22-25% between 2013 and 2014. In the subsequent years, the proportion tends to increase again, peaking at approximately 27-28% during 2015 before settling near 24% by mid-2016. Within current liabilities, accrued expenses remain relatively stable, fluctuating modestly between roughly 6% and 7%, while accounts payable maintain a narrow range generally between 2% and 3.7% throughout the periods.
Short-Term Debt and Convertible Debt
The current portion of convertible debt experiences a sharp decrease from above 10% in early 2011 to around 4% in late 2011 and continues to decline to below 4% by mid-2013, disappearing from the reported data thereafter. Short-term debt emerges in the latter part of the timeline, specifically from early 2015, where it initially rises to around 4.3% before decreasing to below 2% by mid-2016. Notes converted and payable appear sporadically in 2011 and again in 2013 but do not display a continuous trend.
Deferred Revenue and Income Taxes Payable
Deferred revenue within current liabilities shows a steady increase over time, starting just above 10% in 2011 and rising steadily to around 13-14% by 2016. Income taxes payable percentages fluctuate without a clear directional trend but generally remain below 1.5% in all periods reported, comprising both current and income taxes payable figures, with minor variation over time.
Noncurrent Liabilities
Noncurrent liabilities present a marked increase in later periods. Initially stable at approximately 11-12% through 2011 and 2012, this metric approximately doubles to around 22-24% from 2013 onwards and maintains that elevated level thereafter. Long-term debt grows steadily once reported in 2013, ranging between 11-12.7%, while convertible debt excluding the current portion declines progressively from 0.66% in 2011 to negligible levels by 2013. Other liabilities show a gradual increase from around 0.8% to slightly over 1% towards 2016.
Total Liabilities
Total liabilities as a percentage of total liabilities and shareholders’ equity decline from a high near 42% at the start of 2011 to about 37-38% in 2012, before increasing sharply to above 46% from 2013 onward and stabilizing between 48% and 52% up to mid-2016. This increase is largely driven by the growth in noncurrent liabilities and the re-emergence or addition of short-term debt elements in later years.
Shareholders' Equity
Shareholders’ equity, comprising total EMC Corporation’s shareholders’ equity and non-controlling interests, shows an inverse pattern to liabilities. Starting above 56% in 2011, equity rises to approximately 62% in 2012, then declines substantially to a low around 48-51% between 2013 and 2016. Common stock remains relatively flat below 0.1%, while additional paid-in capital exhibits a downward trend from nearly 11% in 2011 to below 2% by 2014, after which data appears unavailable. Retained earnings maintain dominance within equity, fluctuating around 45-50% throughout the periods. The accumulated other comprehensive loss deepens over time, moving from a minor negative to about -1.2% by 2015.
Non-controlling Interests
Non-controlling interests increase steadily from roughly 2.6% in 2011 to over 4.3% by mid-2016, indicating growing minority equity participation within the total equity base.

Overall, the data reveals a gradual shift towards a larger proportion of liabilities relative to shareholders’ equity from 2013 onward, prompted principally by growth in noncurrent liabilities and reintroduction of short-term debt. Meanwhile, equity components such as additional paid-in capital and retained earnings show a declining or stable trend, with increased negative accumulated comprehensive loss diminishing overall equity value. The fluctuation of current liabilities and steadiness of accrued expenses suggest consistent operational obligations, while rising deferred revenue represents strengthened future revenue recognition. These dynamics highlight evolving capital structure and potential leverage changes over the reported timeframe.