Analysis of Short-term (Operating) Activity Ratios
Quarterly Data
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)
Allergan Inc., short-term (operating) activity ratios (quarterly data)
Based on: 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), 10-K (reporting date: 2010-12-31), 10-Q (reporting date: 2010-09-30), 10-Q (reporting date: 2010-06-30), 10-Q (reporting date: 2010-03-31).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Allergan Inc. inventory turnover ratio improved from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014. |
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Allergan Inc. receivables turnover ratio improved from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Allergan Inc. payables turnover ratio increased from Q2 2014 to Q3 2014 but then slightly decreased from Q3 2014 to Q4 2014. |
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Allergan Inc. working capital turnover ratio deteriorated from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014. |
| 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. | Allergan Inc. number of days of inventory outstanding improved from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014. |
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Allergan Inc. number of days of receivables outstanding improved from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014. |
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Allergan Inc. operating cycle improved from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014. |
| 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. | Allergan Inc. number of days of payables outstanding decreased from Q2 2014 to Q3 2014 but then slightly increased from Q3 2014 to Q4 2014. |
| 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. |
Inventory Turnover
Allergan Inc., inventory turnover calculation (quarterly data)
| 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 | Dec 31, 2010 | Sep 30, 2010 | Jun 30, 2010 | Mar 31, 2010 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||
| Cost of sales, excludes amortization of intangible assets | 209,100) | 206,600) | 222,200) | 204,500) | 204,600) | 192,200) | 199,100) | 199,900) | 189,200) | 188,800) | 201,700) | 195,800) | 182,000) | 188,100) | 195,300) | 183,300) | 182,800) | 177,700) | 191,300) | 170,200) | ||||||
| Inventories | 296,000) | 297,700) | 299,900) | 296,600) | 285,300) | 280,000) | 274,400) | 269,200) | 282,900) | 265,100) | 259,700) | 261,900) | 249,700) | 242,100) | 242,400) | 239,200) | 229,400) | 219,600) | 201,900) | 219,400) | ||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||
| Inventory turnover1 | 2.85 | 2.81 | 2.75 | 2.70 | 2.79 | 2.79 | 2.83 | 2.90 | 2.74 | 2.90 | 2.96 | 2.91 | 3.00 | 3.10 | 3.05 | 3.07 | 3.15 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Inventory Turnover, Competitors2 | ||||||||||||||||||||||||||
| AbbVie Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Amgen Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Bristol-Myers Squibb Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Danaher Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Eli Lilly & Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Gilead Sciences Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Johnson & Johnson | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Merck & Co. Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Moderna Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Pfizer Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
Based on: 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), 10-K (reporting date: 2010-12-31), 10-Q (reporting date: 2010-09-30), 10-Q (reporting date: 2010-06-30), 10-Q (reporting date: 2010-03-31).
1 Q4 2014 Calculation
Inventory turnover
= (Cost of sales, excludes amortization of intangible assetsQ4 2014
+ Cost of sales, excludes amortization of intangible assetsQ3 2014
+ Cost of sales, excludes amortization of intangible assetsQ2 2014
+ Cost of sales, excludes amortization of intangible assetsQ1 2014)
÷ Inventories
= (209,100 + 206,600 + 222,200 + 204,500)
÷ 296,000 = 2.85
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. | Allergan Inc. inventory turnover ratio improved from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014. |
Receivables Turnover
Allergan Inc., receivables turnover calculation (quarterly data)
| 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 | Dec 31, 2010 | Sep 30, 2010 | Jun 30, 2010 | Mar 31, 2010 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||
| Product net sales | 1,889,000) | 1,790,700) | 1,827,300) | 1,619,100) | 1,659,600) | 1,528,400) | 1,577,000) | 1,432,500) | 1,484,600) | 1,391,100) | 1,467,400) | 1,365,700) | 1,382,800) | 1,311,100) | 1,400,400) | 1,252,800) | 1,290,100) | 1,192,000) | 1,231,700) | 1,105,800) | ||||||
| Trade receivables, net | 914,500) | 967,400) | 1,055,000) | 990,400) | 883,300) | 908,200) | 917,200) | 887,900) | 764,200) | 872,600) | 867,900) | 855,700) | 730,600) | 710,900) | 744,200) | 671,600) | 647,300) | 586,900) | 601,300) | 558,700) | ||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||
| Receivables turnover1 | 7.79 | 7.13 | 6.29 | 6.45 | 7.02 | 6.63 | 6.42 | 6.50 | 7.47 | 6.43 | 6.37 | 6.38 | 7.32 | 7.39 | 6.90 | 7.40 | 7.45 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | ||||||||||||||||||||||||||
| AbbVie Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Amgen Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Danaher Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Eli Lilly & Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Gilead Sciences Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Johnson & Johnson | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Merck & Co. Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Moderna Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Pfizer Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
Based on: 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), 10-K (reporting date: 2010-12-31), 10-Q (reporting date: 2010-09-30), 10-Q (reporting date: 2010-06-30), 10-Q (reporting date: 2010-03-31).
1 Q4 2014 Calculation
Receivables turnover
= (Product net salesQ4 2014
+ Product net salesQ3 2014
+ Product net salesQ2 2014
+ Product net salesQ1 2014)
÷ Trade receivables, net
= (1,889,000 + 1,790,700 + 1,827,300 + 1,619,100)
÷ 914,500 = 7.79
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. | Allergan Inc. receivables turnover ratio improved from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014. |
Payables Turnover
Allergan Inc., payables turnover calculation (quarterly data)
| 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 | Dec 31, 2010 | Sep 30, 2010 | Jun 30, 2010 | Mar 31, 2010 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||
| Cost of sales, excludes amortization of intangible assets | 209,100) | 206,600) | 222,200) | 204,500) | 204,600) | 192,200) | 199,100) | 199,900) | 189,200) | 188,800) | 201,700) | 195,800) | 182,000) | 188,100) | 195,300) | 183,300) | 182,800) | 177,700) | 191,300) | 170,200) | ||||||
| Accounts payable | 287,400) | 283,200) | 300,000) | 316,500) | 283,200) | 267,800) | 237,000) | 218,500) | 233,100) | 210,600) | 200,600) | 203,000) | 200,400) | 190,100) | 200,300) | 200,500) | 222,500) | 206,300) | 198,900) | 257,900) | ||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||
| Payables turnover1 | 2.93 | 2.96 | 2.75 | 2.53 | 2.81 | 2.91 | 3.28 | 3.57 | 3.33 | 3.65 | 3.83 | 3.75 | 3.74 | 3.94 | 3.69 | 3.67 | 3.24 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Payables Turnover, Competitors2 | ||||||||||||||||||||||||||
| Amgen Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Bristol-Myers Squibb Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Danaher Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Eli Lilly & Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Gilead Sciences Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Johnson & Johnson | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Merck & Co. Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Moderna Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Pfizer Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
Based on: 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), 10-K (reporting date: 2010-12-31), 10-Q (reporting date: 2010-09-30), 10-Q (reporting date: 2010-06-30), 10-Q (reporting date: 2010-03-31).
1 Q4 2014 Calculation
Payables turnover
= (Cost of sales, excludes amortization of intangible assetsQ4 2014
+ Cost of sales, excludes amortization of intangible assetsQ3 2014
+ Cost of sales, excludes amortization of intangible assetsQ2 2014
+ Cost of sales, excludes amortization of intangible assetsQ1 2014)
÷ Accounts payable
= (209,100 + 206,600 + 222,200 + 204,500)
÷ 287,400 = 2.93
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. | Allergan Inc. payables turnover ratio increased from Q2 2014 to Q3 2014 but then slightly decreased from Q3 2014 to Q4 2014. |
Working Capital Turnover
Allergan Inc., working capital turnover calculation (quarterly data)
| 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 | Dec 31, 2010 | Sep 30, 2010 | Jun 30, 2010 | Mar 31, 2010 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||
| Current assets | 6,871,200) | 6,103,800) | 5,702,900) | 5,458,700) | 5,319,700) | 4,932,400) | 4,482,200) | 4,069,500) | 4,458,800) | 4,535,800) | 4,259,600) | 4,238,600) | 4,048,300) | 3,682,600) | 3,592,600) | 4,084,400) | 3,993,700) | 4,243,400) | 3,354,200) | 3,144,200) | ||||||
| Less: Current liabilities | 1,557,300) | 1,567,000) | 1,406,400) | 1,248,100) | 1,244,300) | 1,199,700) | 1,097,900) | 1,061,500) | 1,095,200) | 1,054,900) | 963,800) | 968,800) | 955,000) | 923,700) | 921,500) | 1,475,600) | 1,528,400) | 2,093,000) | 1,420,000) | 783,300) | ||||||
| Working capital | 5,313,900) | 4,536,800) | 4,296,500) | 4,210,600) | 4,075,400) | 3,732,700) | 3,384,300) | 3,008,000) | 3,363,600) | 3,480,900) | 3,295,800) | 3,269,800) | 3,093,300) | 2,758,900) | 2,671,100) | 2,608,800) | 2,465,300) | 2,150,400) | 1,934,200) | 2,360,900) | ||||||
| Product net sales | 1,889,000) | 1,790,700) | 1,827,300) | 1,619,100) | 1,659,600) | 1,528,400) | 1,577,000) | 1,432,500) | 1,484,600) | 1,391,100) | 1,467,400) | 1,365,700) | 1,382,800) | 1,311,100) | 1,400,400) | 1,252,800) | 1,290,100) | 1,192,000) | 1,231,700) | 1,105,800) | ||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||
| Working capital turnover1 | 1.34 | 1.52 | 1.54 | 1.52 | 1.52 | 1.61 | 1.74 | 1.92 | 1.70 | 1.61 | 1.68 | 1.67 | 1.73 | 1.90 | 1.92 | 1.90 | 1.95 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | ||||||||||||||||||||||||||
| AbbVie Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Amgen Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Bristol-Myers Squibb Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Danaher Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Eli Lilly & Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Gilead Sciences Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Johnson & Johnson | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Merck & Co. Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Moderna Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Pfizer Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
Based on: 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), 10-K (reporting date: 2010-12-31), 10-Q (reporting date: 2010-09-30), 10-Q (reporting date: 2010-06-30), 10-Q (reporting date: 2010-03-31).
1 Q4 2014 Calculation
Working capital turnover
= (Product net salesQ4 2014
+ Product net salesQ3 2014
+ Product net salesQ2 2014
+ Product net salesQ1 2014)
÷ Working capital
= (1,889,000 + 1,790,700 + 1,827,300 + 1,619,100)
÷ 5,313,900 = 1.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. | Allergan Inc. working capital turnover ratio deteriorated from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014. |
Average Inventory Processing Period
Allergan Inc., average inventory processing period calculation (quarterly data)
| 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 | Dec 31, 2010 | Sep 30, 2010 | Jun 30, 2010 | Mar 31, 2010 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||
| Inventory turnover | 2.85 | 2.81 | 2.75 | 2.70 | 2.79 | 2.79 | 2.83 | 2.90 | 2.74 | 2.90 | 2.96 | 2.91 | 3.00 | 3.10 | 3.05 | 3.07 | 3.15 | — | — | — | ||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||
| Average inventory processing period1 | 128 | 130 | 133 | 135 | 131 | 131 | 129 | 126 | 133 | 126 | 123 | 126 | 122 | 118 | 120 | 119 | 116 | — | — | — | ||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||
| Average Inventory Processing Period, Competitors2 | ||||||||||||||||||||||||||
| AbbVie Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Amgen Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Bristol-Myers Squibb Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Danaher Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Eli Lilly & Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Gilead Sciences Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Johnson & Johnson | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Merck & Co. Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Moderna Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Pfizer Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
Based on: 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), 10-K (reporting date: 2010-12-31), 10-Q (reporting date: 2010-09-30), 10-Q (reporting date: 2010-06-30), 10-Q (reporting date: 2010-03-31).
1 Q4 2014 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 2.85 = 128
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. | Allergan Inc. number of days of inventory outstanding improved from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014. |
Average Receivable Collection Period
Allergan Inc., average receivable collection period calculation (quarterly data)
| 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 | Dec 31, 2010 | Sep 30, 2010 | Jun 30, 2010 | Mar 31, 2010 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||
| Receivables turnover | 7.79 | 7.13 | 6.29 | 6.45 | 7.02 | 6.63 | 6.42 | 6.50 | 7.47 | 6.43 | 6.37 | 6.38 | 7.32 | 7.39 | 6.90 | 7.40 | 7.45 | — | — | — | ||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||
| Average receivable collection period1 | 47 | 51 | 58 | 57 | 52 | 55 | 57 | 56 | 49 | 57 | 57 | 57 | 50 | 49 | 53 | 49 | 49 | — | — | — | ||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | ||||||||||||||||||||||||||
| AbbVie Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Amgen Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Danaher Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Eli Lilly & Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Gilead Sciences Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Johnson & Johnson | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Merck & Co. Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Moderna Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Pfizer Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
Based on: 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), 10-K (reporting date: 2010-12-31), 10-Q (reporting date: 2010-09-30), 10-Q (reporting date: 2010-06-30), 10-Q (reporting date: 2010-03-31).
1 Q4 2014 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 7.79 = 47
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. | Allergan Inc. number of days of receivables outstanding improved from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014. |
Operating Cycle
Allergan Inc., operating cycle calculation (quarterly data)
No. days
| 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 | Dec 31, 2010 | Sep 30, 2010 | Jun 30, 2010 | Mar 31, 2010 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||
| Average inventory processing period | 128 | 130 | 133 | 135 | 131 | 131 | 129 | 126 | 133 | 126 | 123 | 126 | 122 | 118 | 120 | 119 | 116 | — | — | — | ||||||
| Average receivable collection period | 47 | 51 | 58 | 57 | 52 | 55 | 57 | 56 | 49 | 57 | 57 | 57 | 50 | 49 | 53 | 49 | 49 | — | — | — | ||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||
| Operating cycle1 | 175 | 181 | 191 | 192 | 183 | 186 | 186 | 182 | 182 | 183 | 180 | 183 | 172 | 167 | 173 | 168 | 165 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Operating Cycle, Competitors2 | ||||||||||||||||||||||||||
| AbbVie Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Amgen Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Danaher Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Eli Lilly & Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Gilead Sciences Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Johnson & Johnson | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Merck & Co. Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Moderna Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Pfizer Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
Based on: 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), 10-K (reporting date: 2010-12-31), 10-Q (reporting date: 2010-09-30), 10-Q (reporting date: 2010-06-30), 10-Q (reporting date: 2010-03-31).
1 Q4 2014 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 128 + 47 = 175
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. | Allergan Inc. operating cycle improved from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014. |
Average Payables Payment Period
Allergan Inc., average payables payment period calculation (quarterly data)
| 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 | Dec 31, 2010 | Sep 30, 2010 | Jun 30, 2010 | Mar 31, 2010 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||
| Payables turnover | 2.93 | 2.96 | 2.75 | 2.53 | 2.81 | 2.91 | 3.28 | 3.57 | 3.33 | 3.65 | 3.83 | 3.75 | 3.74 | 3.94 | 3.69 | 3.67 | 3.24 | — | — | — | ||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||
| Average payables payment period1 | 125 | 123 | 133 | 144 | 130 | 125 | 111 | 102 | 110 | 100 | 95 | 97 | 98 | 93 | 99 | 100 | 112 | — | — | — | ||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | ||||||||||||||||||||||||||
| Amgen Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Bristol-Myers Squibb Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Danaher Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Eli Lilly & Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Gilead Sciences Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Johnson & Johnson | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Merck & Co. Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Moderna Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Pfizer Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
Based on: 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), 10-K (reporting date: 2010-12-31), 10-Q (reporting date: 2010-09-30), 10-Q (reporting date: 2010-06-30), 10-Q (reporting date: 2010-03-31).
1 Q4 2014 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 2.93 = 125
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. | Allergan Inc. number of days of payables outstanding decreased from Q2 2014 to Q3 2014 but then slightly increased from Q3 2014 to Q4 2014. |
Cash Conversion Cycle
Allergan Inc., cash conversion cycle calculation (quarterly data)
No. days
| 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 | Dec 31, 2010 | Sep 30, 2010 | Jun 30, 2010 | Mar 31, 2010 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||
| Average inventory processing period | 128 | 130 | 133 | 135 | 131 | 131 | 129 | 126 | 133 | 126 | 123 | 126 | 122 | 118 | 120 | 119 | 116 | — | — | — | ||||||
| Average receivable collection period | 47 | 51 | 58 | 57 | 52 | 55 | 57 | 56 | 49 | 57 | 57 | 57 | 50 | 49 | 53 | 49 | 49 | — | — | — | ||||||
| Average payables payment period | 125 | 123 | 133 | 144 | 130 | 125 | 111 | 102 | 110 | 100 | 95 | 97 | 98 | 93 | 99 | 100 | 112 | — | — | — | ||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||
| Cash conversion cycle1 | 50 | 58 | 58 | 48 | 53 | 61 | 75 | 80 | 72 | 83 | 85 | 86 | 74 | 74 | 74 | 68 | 53 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Cash Conversion Cycle, Competitors2 | ||||||||||||||||||||||||||
| Amgen Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Danaher Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Eli Lilly & Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Gilead Sciences Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Johnson & Johnson | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Merck & Co. Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Moderna Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Pfizer Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
Based on: 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), 10-K (reporting date: 2010-12-31), 10-Q (reporting date: 2010-09-30), 10-Q (reporting date: 2010-06-30), 10-Q (reporting date: 2010-03-31).
1 Q4 2014 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 128 + 47 – 125 = 50
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. |