Analysis of Short-term (Operating) Activity Ratios
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Short-term Activity Ratios (Summary)
EMC Corp., short-term (operating) activity ratios
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).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | EMC Corp. inventory turnover ratio improved from 2013 to 2014 and from 2014 to 2015. |
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | EMC Corp. receivables turnover ratio deteriorated from 2013 to 2014 but then improved from 2014 to 2015 exceeding 2013 level. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | EMC Corp. payables turnover ratio decreased from 2013 to 2014 but then increased from 2014 to 2015 not reaching 2013 level. |
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | EMC Corp. working capital turnover ratio improved from 2013 to 2014 and from 2014 to 2015. |
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | EMC Corp. number of days of inventory outstanding improved from 2013 to 2014 and from 2014 to 2015. |
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | EMC Corp. number of days of receivables outstanding deteriorated from 2013 to 2014 but then improved from 2014 to 2015 exceeding 2013 level. |
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | |
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | EMC Corp. number of days of payables outstanding increased from 2013 to 2014 but then slightly decreased from 2014 to 2015 not reaching 2013 level. |
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | EMC Corp. cash conversion cycle improved from 2013 to 2014 and from 2014 to 2015. |
Inventory Turnover
EMC Corp., inventory turnover calculation, comparison to benchmarks
| Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | Dec 31, 2011 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||
| Cost of revenues | 9,713) | 9,191) | 8,749) | 8,076) | 7,839) | |
| Inventories | 1,245) | 1,276) | 1,334) | 1,201) | 1,010) | |
| Short-term Activity Ratio | ||||||
| Inventory turnover1 | 7.80 | 7.20 | 6.56 | 6.72 | 7.76 | |
| Benchmarks | ||||||
| Inventory Turnover, Competitors2 | ||||||
| Advanced Micro Devices Inc. | — | — | — | — | — | |
| Analog Devices Inc. | — | — | — | — | — | |
| Applied Materials Inc. | — | — | — | — | — | |
| Broadcom Inc. | — | — | — | — | — | |
| First Solar Inc. | — | — | — | — | — | |
| Intel Corp. | — | — | — | — | — | |
| KLA Corp. | — | — | — | — | — | |
| Lam Research Corp. | — | — | — | — | — | |
| Micron Technology Inc. | — | — | — | — | — | |
| NVIDIA Corp. | — | — | — | — | — | |
| Qualcomm Inc. | — | — | — | — | — | |
| Texas Instruments Inc. | — | — | — | — | — | |
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).
1 2015 Calculation
Inventory turnover = Cost of revenues ÷ Inventories
= 9,713 ÷ 1,245 = 7.80
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | EMC Corp. inventory turnover ratio improved from 2013 to 2014 and from 2014 to 2015. |
Receivables Turnover
EMC Corp., receivables turnover calculation, comparison to benchmarks
| Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | Dec 31, 2011 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||
| Revenues | 24,704) | 24,440) | 23,222) | 21,714) | 20,008) | |
| Accounts and notes receivable, less allowance for doubtful accounts | 3,977) | 4,413) | 3,861) | 3,433) | 2,937) | |
| Short-term Activity Ratio | ||||||
| Receivables turnover1 | 6.21 | 5.54 | 6.01 | 6.32 | 6.81 | |
| Benchmarks | ||||||
| Receivables Turnover, Competitors2 | ||||||
| Advanced Micro Devices Inc. | — | — | — | — | — | |
| Analog Devices Inc. | — | — | — | — | — | |
| Applied Materials Inc. | — | — | — | — | — | |
| Broadcom Inc. | — | — | — | — | — | |
| First Solar Inc. | — | — | — | — | — | |
| Intel Corp. | — | — | — | — | — | |
| KLA Corp. | — | — | — | — | — | |
| Lam Research Corp. | — | — | — | — | — | |
| Micron Technology Inc. | — | — | — | — | — | |
| NVIDIA Corp. | — | — | — | — | — | |
| Qualcomm Inc. | — | — | — | — | — | |
| Texas Instruments Inc. | — | — | — | — | — | |
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).
1 2015 Calculation
Receivables turnover = Revenues ÷ Accounts and notes receivable, less allowance for doubtful accounts
= 24,704 ÷ 3,977 = 6.21
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | EMC Corp. receivables turnover ratio deteriorated from 2013 to 2014 but then improved from 2014 to 2015 exceeding 2013 level. |
Payables Turnover
EMC Corp., payables turnover calculation, comparison to benchmarks
| Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | Dec 31, 2011 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||
| Cost of revenues | 9,713) | 9,191) | 8,749) | 8,076) | 7,839) | |
| Accounts payable | 1,644) | 1,696) | 1,434) | 1,041) | 1,102) | |
| Short-term Activity Ratio | ||||||
| Payables turnover1 | 5.91 | 5.42 | 6.10 | 7.76 | 7.12 | |
| Benchmarks | ||||||
| Payables Turnover, Competitors2 | ||||||
| Advanced Micro Devices Inc. | — | — | — | — | — | |
| Analog Devices Inc. | — | — | — | — | — | |
| Applied Materials Inc. | — | — | — | — | — | |
| Broadcom Inc. | — | — | — | — | — | |
| First Solar Inc. | — | — | — | — | — | |
| Intel Corp. | — | — | — | — | — | |
| KLA Corp. | — | — | — | — | — | |
| Lam Research Corp. | — | — | — | — | — | |
| Micron Technology Inc. | — | — | — | — | — | |
| NVIDIA Corp. | — | — | — | — | — | |
| Qualcomm Inc. | — | — | — | — | — | |
| Texas Instruments Inc. | — | — | — | — | — | |
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).
1 2015 Calculation
Payables turnover = Cost of revenues ÷ Accounts payable
= 9,713 ÷ 1,644 = 5.91
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | EMC Corp. payables turnover ratio decreased from 2013 to 2014 but then increased from 2014 to 2015 not reaching 2013 level. |
Working Capital Turnover
EMC Corp., working capital turnover calculation, comparison to benchmarks
| Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | Dec 31, 2011 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||
| Current assets | 15,063) | 15,733) | 17,278) | 12,209) | 11,583) | |
| Less: Current liabilities | 12,885) | 11,710) | 11,799) | 10,304) | 10,376) | |
| Working capital | 2,178) | 4,023) | 5,479) | 1,905) | 1,206) | |
| Revenues | 24,704) | 24,440) | 23,222) | 21,714) | 20,008) | |
| Short-term Activity Ratio | ||||||
| Working capital turnover1 | 11.34 | 6.08 | 4.24 | 11.40 | 16.58 | |
| Benchmarks | ||||||
| Working Capital Turnover, Competitors2 | ||||||
| Advanced Micro Devices Inc. | — | — | — | — | — | |
| Analog Devices Inc. | — | — | — | — | — | |
| Applied Materials Inc. | — | — | — | — | — | |
| Broadcom Inc. | — | — | — | — | — | |
| First Solar Inc. | — | — | — | — | — | |
| Intel Corp. | — | — | — | — | — | |
| KLA Corp. | — | — | — | — | — | |
| Lam Research Corp. | — | — | — | — | — | |
| Micron Technology Inc. | — | — | — | — | — | |
| NVIDIA Corp. | — | — | — | — | — | |
| Qualcomm Inc. | — | — | — | — | — | |
| Texas Instruments Inc. | — | — | — | — | — | |
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).
1 2015 Calculation
Working capital turnover = Revenues ÷ Working capital
= 24,704 ÷ 2,178 = 11.34
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | EMC Corp. working capital turnover ratio improved from 2013 to 2014 and from 2014 to 2015. |
Average Inventory Processing Period
EMC Corp., average inventory processing period calculation, comparison to benchmarks
| Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | Dec 31, 2011 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||
| Inventory turnover | 7.80 | 7.20 | 6.56 | 6.72 | 7.76 | |
| Short-term Activity Ratio (no. days) | ||||||
| Average inventory processing period1 | 47 | 51 | 56 | 54 | 47 | |
| Benchmarks (no. days) | ||||||
| Average Inventory Processing Period, Competitors2 | ||||||
| Advanced Micro Devices Inc. | — | — | — | — | — | |
| Analog Devices Inc. | — | — | — | — | — | |
| Applied Materials Inc. | — | — | — | — | — | |
| Broadcom Inc. | — | — | — | — | — | |
| First Solar Inc. | — | — | — | — | — | |
| Intel Corp. | — | — | — | — | — | |
| KLA Corp. | — | — | — | — | — | |
| Lam Research Corp. | — | — | — | — | — | |
| Micron Technology Inc. | — | — | — | — | — | |
| NVIDIA Corp. | — | — | — | — | — | |
| Qualcomm Inc. | — | — | — | — | — | |
| Texas Instruments Inc. | — | — | — | — | — | |
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).
1 2015 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 7.80 = 47
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | EMC Corp. number of days of inventory outstanding improved from 2013 to 2014 and from 2014 to 2015. |
Average Receivable Collection Period
EMC Corp., average receivable collection period calculation, comparison to benchmarks
| Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | Dec 31, 2011 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||
| Receivables turnover | 6.21 | 5.54 | 6.01 | 6.32 | 6.81 | |
| Short-term Activity Ratio (no. days) | ||||||
| Average receivable collection period1 | 59 | 66 | 61 | 58 | 54 | |
| Benchmarks (no. days) | ||||||
| Average Receivable Collection Period, Competitors2 | ||||||
| Advanced Micro Devices Inc. | — | — | — | — | — | |
| Analog Devices Inc. | — | — | — | — | — | |
| Applied Materials Inc. | — | — | — | — | — | |
| Broadcom Inc. | — | — | — | — | — | |
| First Solar Inc. | — | — | — | — | — | |
| Intel Corp. | — | — | — | — | — | |
| KLA Corp. | — | — | — | — | — | |
| Lam Research Corp. | — | — | — | — | — | |
| Micron Technology Inc. | — | — | — | — | — | |
| NVIDIA Corp. | — | — | — | — | — | |
| Qualcomm Inc. | — | — | — | — | — | |
| Texas Instruments Inc. | — | — | — | — | — | |
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).
1 2015 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 6.21 = 59
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | EMC Corp. number of days of receivables outstanding deteriorated from 2013 to 2014 but then improved from 2014 to 2015 exceeding 2013 level. |
Operating Cycle
EMC Corp., operating cycle calculation, comparison to benchmarks
No. days
| Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | Dec 31, 2011 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||
| Average inventory processing period | 47 | 51 | 56 | 54 | 47 | |
| Average receivable collection period | 59 | 66 | 61 | 58 | 54 | |
| Short-term Activity Ratio | ||||||
| Operating cycle1 | 106 | 117 | 117 | 112 | 101 | |
| Benchmarks | ||||||
| Operating Cycle, Competitors2 | ||||||
| Advanced Micro Devices Inc. | — | — | — | — | — | |
| Analog Devices Inc. | — | — | — | — | — | |
| Applied Materials Inc. | — | — | — | — | — | |
| Broadcom Inc. | — | — | — | — | — | |
| First Solar Inc. | — | — | — | — | — | |
| Intel Corp. | — | — | — | — | — | |
| KLA Corp. | — | — | — | — | — | |
| Lam Research Corp. | — | — | — | — | — | |
| Micron Technology Inc. | — | — | — | — | — | |
| NVIDIA Corp. | — | — | — | — | — | |
| Qualcomm Inc. | — | — | — | — | — | |
| Texas Instruments Inc. | — | — | — | — | — | |
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).
1 2015 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 47 + 59 = 106
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. |
Average Payables Payment Period
EMC Corp., average payables payment period calculation, comparison to benchmarks
| Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | Dec 31, 2011 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||
| Payables turnover | 5.91 | 5.42 | 6.10 | 7.76 | 7.12 | |
| Short-term Activity Ratio (no. days) | ||||||
| Average payables payment period1 | 62 | 67 | 60 | 47 | 51 | |
| Benchmarks (no. days) | ||||||
| Average Payables Payment Period, Competitors2 | ||||||
| Advanced Micro Devices Inc. | — | — | — | — | — | |
| Analog Devices Inc. | — | — | — | — | — | |
| Applied Materials Inc. | — | — | — | — | — | |
| Broadcom Inc. | — | — | — | — | — | |
| First Solar Inc. | — | — | — | — | — | |
| Intel Corp. | — | — | — | — | — | |
| KLA Corp. | — | — | — | — | — | |
| Lam Research Corp. | — | — | — | — | — | |
| Micron Technology Inc. | — | — | — | — | — | |
| NVIDIA Corp. | — | — | — | — | — | |
| Qualcomm Inc. | — | — | — | — | — | |
| Texas Instruments Inc. | — | — | — | — | — | |
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).
1 2015 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 5.91 = 62
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | EMC Corp. number of days of payables outstanding increased from 2013 to 2014 but then slightly decreased from 2014 to 2015 not reaching 2013 level. |
Cash Conversion Cycle
EMC Corp., cash conversion cycle calculation, comparison to benchmarks
No. days
| Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | Dec 31, 2012 | Dec 31, 2011 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||
| Average inventory processing period | 47 | 51 | 56 | 54 | 47 | |
| Average receivable collection period | 59 | 66 | 61 | 58 | 54 | |
| Average payables payment period | 62 | 67 | 60 | 47 | 51 | |
| Short-term Activity Ratio | ||||||
| Cash conversion cycle1 | 44 | 50 | 57 | 65 | 50 | |
| Benchmarks | ||||||
| Cash Conversion Cycle, Competitors2 | ||||||
| Advanced Micro Devices Inc. | — | — | — | — | — | |
| Analog Devices Inc. | — | — | — | — | — | |
| Applied Materials Inc. | — | — | — | — | — | |
| Broadcom Inc. | — | — | — | — | — | |
| First Solar Inc. | — | — | — | — | — | |
| Intel Corp. | — | — | — | — | — | |
| KLA Corp. | — | — | — | — | — | |
| Lam Research Corp. | — | — | — | — | — | |
| Micron Technology Inc. | — | — | — | — | — | |
| NVIDIA Corp. | — | — | — | — | — | |
| Qualcomm Inc. | — | — | — | — | — | |
| Texas Instruments Inc. | — | — | — | — | — | |
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).
1 2015 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 47 + 59 – 62 = 44
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | EMC Corp. cash conversion cycle improved from 2013 to 2014 and from 2014 to 2015. |