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.

Analysis of Investments

Microsoft Excel

Adjustment to Net Income (Loss): Mark to Market Available-for-sale Securities

EMC Corp., adjustment to net income attributable to EMC Corporation

US$ in millions

Microsoft Excel
12 months ended: Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Net income attributable to EMC Corporation (as reported) 1,990 2,714 2,889 2,733 2,461
Add: Net change in market value of investments (59) 18 (33) 48 (26)
Net income attributable to EMC Corporation (adjusted) 1,931 2,732 2,856 2,781 2,436

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).

Adjusted Profitability Ratios: Mark to Market Available-for-sale Securities (Summary)

EMC Corp., adjusted profitability ratios

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Net Profit Margin
Reported net profit margin 8.06% 11.10% 12.44% 12.58% 12.30%
Adjusted net profit margin 7.82% 11.18% 12.30% 12.81% 12.17%
Return on Equity (ROE)
Reported ROE 9.41% 12.39% 12.95% 12.22% 12.98%
Adjusted ROE 9.13% 12.48% 12.81% 12.44% 12.85%
Return on Assets (ROA)
Reported ROA 4.27% 5.91% 6.30% 7.18% 7.18%
Adjusted ROA 4.14% 5.95% 6.23% 7.30% 7.11%

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).

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. EMC Corp. adjusted net profit margin ratio deteriorated from 2013 to 2014 and from 2014 to 2015.
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. EMC Corp. adjusted ROE deteriorated from 2013 to 2014 and from 2014 to 2015.
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. EMC Corp. adjusted ROA deteriorated from 2013 to 2014 and from 2014 to 2015.

EMC Corp., Profitability Ratios: Reported vs. Adjusted

Adjusted Net Profit Margin

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
As Reported
Selected Financial Data (US$ in millions)
Net income attributable to EMC Corporation 1,990 2,714 2,889 2,733 2,461
Revenues 24,704 24,440 23,222 21,714 20,008
Profitability Ratio
Net profit margin1 8.06% 11.10% 12.44% 12.58% 12.30%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income attributable to EMC Corporation 1,931 2,732 2,856 2,781 2,436
Revenues 24,704 24,440 23,222 21,714 20,008
Profitability Ratio
Adjusted net profit margin2 7.82% 11.18% 12.30% 12.81% 12.17%

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).

2015 Calculations

1 Net profit margin = 100 × Net income attributable to EMC Corporation ÷ Revenues
= 100 × 1,990 ÷ 24,704 = 8.06%

2 Adjusted net profit margin = 100 × Adjusted net income attributable to EMC Corporation ÷ Revenues
= 100 × 1,931 ÷ 24,704 = 7.82%

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. EMC Corp. adjusted net profit margin ratio deteriorated from 2013 to 2014 and from 2014 to 2015.

Adjusted Return on Equity (ROE)

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
As Reported
Selected Financial Data (US$ in millions)
Net income attributable to EMC Corporation 1,990 2,714 2,889 2,733 2,461
Total EMC Corporation’s shareholders’ equity 21,140 21,896 22,301 22,357 18,959
Profitability Ratio
ROE1 9.41% 12.39% 12.95% 12.22% 12.98%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income attributable to EMC Corporation 1,931 2,732 2,856 2,781 2,436
Total EMC Corporation’s shareholders’ equity 21,140 21,896 22,301 22,357 18,959
Profitability Ratio
Adjusted ROE2 9.13% 12.48% 12.81% 12.44% 12.85%

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).

2015 Calculations

1 ROE = 100 × Net income attributable to EMC Corporation ÷ Total EMC Corporation’s shareholders’ equity
= 100 × 1,990 ÷ 21,140 = 9.41%

2 Adjusted ROE = 100 × Adjusted net income attributable to EMC Corporation ÷ Total EMC Corporation’s shareholders’ equity
= 100 × 1,931 ÷ 21,140 = 9.13%

Profitability ratio Description The company
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. EMC Corp. adjusted ROE deteriorated from 2013 to 2014 and from 2014 to 2015.

Adjusted Return on Assets (ROA)

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
As Reported
Selected Financial Data (US$ in millions)
Net income attributable to EMC Corporation 1,990 2,714 2,889 2,733 2,461
Total assets 46,612 45,885 45,849 38,069 34,268
Profitability Ratio
ROA1 4.27% 5.91% 6.30% 7.18% 7.18%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income attributable to EMC Corporation 1,931 2,732 2,856 2,781 2,436
Total assets 46,612 45,885 45,849 38,069 34,268
Profitability Ratio
Adjusted ROA2 4.14% 5.95% 6.23% 7.30% 7.11%

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).

2015 Calculations

1 ROA = 100 × Net income attributable to EMC Corporation ÷ Total assets
= 100 × 1,990 ÷ 46,612 = 4.27%

2 Adjusted ROA = 100 × Adjusted net income attributable to EMC Corporation ÷ Total assets
= 100 × 1,931 ÷ 46,612 = 4.14%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. EMC Corp. adjusted ROA deteriorated from 2013 to 2014 and from 2014 to 2015.