Stock Analysis on Net

Allergan Inc. (NYSE:AGN.)

This company has been moved to the archive! The financial data has not been updated since February 19, 2015.

Analysis of Long-term (Investment) Activity Ratios 
Quarterly Data

Microsoft Excel

Long-term Activity Ratios (Summary)

Allergan Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
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
Net fixed asset turnover 7.08 6.86 6.78 6.78 6.71 6.87 6.79 6.76 6.69 6.81 6.81 6.77 6.63 6.64 6.46 6.30 6.02
Total asset turnover 0.57 0.59 0.60 0.60 0.59 0.59 0.61 0.62 0.62 0.63 0.64 0.63 0.63 0.64 0.65 0.59 0.58
Equity turnover 0.92 0.97 0.98 0.96 0.96 0.99 1.03 1.08 0.98 1.01 1.02 1.00 1.01 1.03 1.03 1.02 1.01

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

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Allergan Inc. net fixed asset turnover ratio improved from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Allergan Inc. total asset turnover ratio deteriorated from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Allergan Inc. equity turnover ratio deteriorated from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014.

Net Fixed Asset Turnover

Allergan Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
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
Property, plant and equipment, net 1,006,300 1,005,300 977,900 942,300 923,200 877,000 866,200 853,900 852,900 822,800 811,600 807,000 807,000 791,100 795,100 788,500 800,600 778,000 785,900 795,400
Long-term Activity Ratio
Net fixed asset turnover1 7.08 6.86 6.78 6.78 6.71 6.87 6.79 6.76 6.69 6.81 6.81 6.77 6.63 6.64 6.46 6.30 6.02
Benchmarks
Net Fixed Asset Turnover, Competitors2
AbbVie Inc.
Amgen Inc.
Bristol-Myers Squibb Co.
Danaher Corp.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. 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
Net fixed asset turnover = (Product net salesQ4 2014 + Product net salesQ3 2014 + Product net salesQ2 2014 + Product net salesQ1 2014) ÷ Property, plant and equipment, net
= (1,889,000 + 1,790,700 + 1,827,300 + 1,619,100) ÷ 1,006,300 = 7.08

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Allergan Inc. net fixed asset turnover ratio improved from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014.

Total Asset Turnover

Allergan Inc., total asset turnover calculation (quarterly data)

Microsoft Excel
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
Total assets 12,415,700 11,645,800 10,990,800 10,720,200 10,574,300 10,144,600 9,675,000 9,250,500 9,179,300 8,910,900 8,673,400 8,684,200 8,508,600 8,184,000 7,879,600 8,370,700 8,308,100 8,540,100 7,787,600 7,628,400
Long-term Activity Ratio
Total asset turnover1 0.57 0.59 0.60 0.60 0.59 0.59 0.61 0.62 0.62 0.63 0.64 0.63 0.63 0.64 0.65 0.59 0.58
Benchmarks
Total Asset Turnover, Competitors2
AbbVie Inc.
Amgen Inc.
Bristol-Myers Squibb Co.
Danaher Corp.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. 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
Total asset turnover = (Product net salesQ4 2014 + Product net salesQ3 2014 + Product net salesQ2 2014 + Product net salesQ1 2014) ÷ Total assets
= (1,889,000 + 1,790,700 + 1,827,300 + 1,619,100) ÷ 12,415,700 = 0.57

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Allergan Inc. total asset turnover ratio deteriorated from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014.

Equity Turnover

Allergan Inc., equity turnover calculation (quarterly data)

Microsoft Excel
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
Total Allergan, Inc. stockholders’ equity 7,753,000 7,110,700 6,786,000 6,617,900 6,463,200 6,085,900 5,721,900 5,337,100 5,837,100 5,569,600 5,438,800 5,458,600 5,309,600 5,105,700 4,963,900 4,865,700 4,757,700 4,459,500 5,088,000 4,944,800
Long-term Activity Ratio
Equity turnover1 0.92 0.97 0.98 0.96 0.96 0.99 1.03 1.08 0.98 1.01 1.02 1.00 1.01 1.03 1.03 1.02 1.01
Benchmarks
Equity Turnover, Competitors2
AbbVie Inc.
Amgen Inc.
Bristol-Myers Squibb Co.
Danaher Corp.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. 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
Equity turnover = (Product net salesQ4 2014 + Product net salesQ3 2014 + Product net salesQ2 2014 + Product net salesQ1 2014) ÷ Total Allergan, Inc. stockholders’ equity
= (1,889,000 + 1,790,700 + 1,827,300 + 1,619,100) ÷ 7,753,000 = 0.92

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Allergan Inc. equity turnover ratio deteriorated from Q2 2014 to Q3 2014 and from Q3 2014 to Q4 2014.