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 Geographic Areas

Microsoft Excel

Area Asset Turnover

Allergan Inc., asset turnover by geographic area

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
United States 1.01 0.90 0.94 0.92 0.94
Europe 2.25 2.17 2.08 2.16 1.65
Latin America 7.73 7.34 7.18 6.58 4.98
Asia Pacific 10.83 9.06 8.34 7.67 5.93
Other 158.42 195.14 118.59 85.54 57.70

Based on: 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), 10-K (reporting date: 2010-12-31).

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio deteriorated from 2012 to 2013 but then improved from 2013 to 2014 exceeding 2012 level.
Europe Europe area asset turnover ratio improved from 2012 to 2013 and from 2013 to 2014.
Latin America Latin America area asset turnover ratio improved from 2012 to 2013 and from 2013 to 2014.
Asia Pacific Asia Pacific area asset turnover ratio improved from 2012 to 2013 and from 2013 to 2014.
Other Other area asset turnover ratio improved from 2012 to 2013 but then slightly deteriorated from 2013 to 2014.

Area Asset Turnover: United States

Allergan Inc.; United States; area asset turnover calculation

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Selected Financial Data (US$ in thousands)
Product net sales 4,520,500 3,839,400 3,478,400 3,221,600 3,017,000
Long-lived assets 4,497,000 4,274,700 3,718,600 3,500,900 3,222,400
Area Activity Ratio
Area asset turnover1 1.01 0.90 0.94 0.92 0.94

Based on: 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), 10-K (reporting date: 2010-12-31).

1 2014 Calculation
Area asset turnover = Product net sales ÷ Long-lived assets
= 4,520,500 ÷ 4,497,000 = 1.01

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio deteriorated from 2012 to 2013 but then improved from 2013 to 2014 exceeding 2012 level.

Area Asset Turnover: Europe

Allergan Inc.; Europe; area asset turnover calculation

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Selected Financial Data (US$ in thousands)
Product net sales 1,410,300 1,237,800 1,121,400 1,086,600 931,600
Long-lived assets 627,100 569,900 538,600 502,000 563,100
Area Activity Ratio
Area asset turnover1 2.25 2.17 2.08 2.16 1.65

Based on: 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), 10-K (reporting date: 2010-12-31).

1 2014 Calculation
Area asset turnover = Product net sales ÷ Long-lived assets
= 1,410,300 ÷ 627,100 = 2.25

Area activity ratio Geographic area The company
Area asset turnover Europe Europe area asset turnover ratio improved from 2012 to 2013 and from 2013 to 2014.

Area Asset Turnover: Latin America

Allergan Inc.; Latin America; area asset turnover calculation

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Selected Financial Data (US$ in thousands)
Product net sales 382,000 383,000 399,200 390,700 323,700
Long-lived assets 49,400 52,200 55,600 59,400 65,000
Area Activity Ratio
Area asset turnover1 7.73 7.34 7.18 6.58 4.98

Based on: 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), 10-K (reporting date: 2010-12-31).

1 2014 Calculation
Area asset turnover = Product net sales ÷ Long-lived assets
= 382,000 ÷ 49,400 = 7.73

Area activity ratio Geographic area The company
Area asset turnover Latin America Latin America area asset turnover ratio improved from 2012 to 2013 and from 2013 to 2014.

Area Asset Turnover: Asia Pacific

Allergan Inc.; Asia Pacific; area asset turnover calculation

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Selected Financial Data (US$ in thousands)
Product net sales 512,300 464,100 448,900 408,700 333,800
Long-lived assets 47,300 51,200 53,800 53,300 56,300
Area Activity Ratio
Area asset turnover1 10.83 9.06 8.34 7.67 5.93

Based on: 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), 10-K (reporting date: 2010-12-31).

1 2014 Calculation
Area asset turnover = Product net sales ÷ Long-lived assets
= 512,300 ÷ 47,300 = 10.83

Area activity ratio Geographic area The company
Area asset turnover Asia Pacific Asia Pacific area asset turnover ratio improved from 2012 to 2013 and from 2013 to 2014.

Area Asset Turnover: Other

Allergan Inc.; Other; area asset turnover calculation

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Selected Financial Data (US$ in thousands)
Product net sales 301,000 273,200 260,900 239,500 213,500
Long-lived assets 1,900 1,400 2,200 2,800 3,700
Area Activity Ratio
Area asset turnover1 158.42 195.14 118.59 85.54 57.70

Based on: 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), 10-K (reporting date: 2010-12-31).

1 2014 Calculation
Area asset turnover = Product net sales ÷ Long-lived assets
= 301,000 ÷ 1,900 = 158.42

Area activity ratio Geographic area The company
Area asset turnover Other Other area asset turnover ratio improved from 2012 to 2013 but then slightly deteriorated from 2013 to 2014.

Area Capital Expenditures to Depreciation

Allergan Inc., capital expenditures to depreciation by geographic area

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
United States 0.53 0.45 0.39 0.34 0.31
Europe 2.81 1.61 1.24 0.92 0.70
Latin America 0.97 0.99 0.71 0.67 0.81
Asia Pacific 0.46 0.46 0.43 0.47 1.03
Other 0.00 0.00 0.13 0.00 0.13

Based on: 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), 10-K (reporting date: 2010-12-31).

Area financial ratio Geographic area The company
Area capital expenditures to depreciation United States United States area capital expenditures to depreciation ratio improved from 2012 to 2013 and from 2013 to 2014.
Europe Europe area capital expenditures to depreciation ratio improved from 2012 to 2013 and from 2013 to 2014.
Latin America Latin America area capital expenditures to depreciation ratio improved from 2012 to 2013 but then slightly deteriorated from 2013 to 2014.
Asia Pacific Asia Pacific area capital expenditures to depreciation ratio improved from 2012 to 2013 but then slightly deteriorated from 2013 to 2014.
Other

Area Capital Expenditures to Depreciation: United States

Allergan Inc.; United States; area capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Selected Financial Data (US$ in thousands)
Capital expenditures 98,400 82,300 75,700 63,600 62,800
Depreciation and amortization 187,300 181,200 194,700 187,900 202,200
Area Financial Ratio
Area capital expenditures to depreciation1 0.53 0.45 0.39 0.34 0.31

Based on: 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), 10-K (reporting date: 2010-12-31).

1 2014 Calculation
Area capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 98,400 ÷ 187,300 = 0.53

Area financial ratio Geographic area The company
Area capital expenditures to depreciation United States United States area capital expenditures to depreciation ratio improved from 2012 to 2013 and from 2013 to 2014.

Area Capital Expenditures to Depreciation: Europe

Allergan Inc.; Europe; area capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Selected Financial Data (US$ in thousands)
Capital expenditures 136,400 79,700 59,500 46,300 29,300
Depreciation and amortization 48,500 49,600 48,100 50,300 42,000
Area Financial Ratio
Area capital expenditures to depreciation1 2.81 1.61 1.24 0.92 0.70

Based on: 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), 10-K (reporting date: 2010-12-31).

1 2014 Calculation
Area capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 136,400 ÷ 48,500 = 2.81

Area financial ratio Geographic area The company
Area capital expenditures to depreciation Europe Europe area capital expenditures to depreciation ratio improved from 2012 to 2013 and from 2013 to 2014.

Area Capital Expenditures to Depreciation: Latin America

Allergan Inc.; Latin America; area capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Selected Financial Data (US$ in thousands)
Capital expenditures 6,900 7,600 6,000 6,600 6,700
Depreciation and amortization 7,100 7,700 8,400 9,800 8,300
Area Financial Ratio
Area capital expenditures to depreciation1 0.97 0.99 0.71 0.67 0.81

Based on: 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), 10-K (reporting date: 2010-12-31).

1 2014 Calculation
Area capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 6,900 ÷ 7,100 = 0.97

Area financial ratio Geographic area The company
Area capital expenditures to depreciation Latin America Latin America area capital expenditures to depreciation ratio improved from 2012 to 2013 but then slightly deteriorated from 2013 to 2014.

Area Capital Expenditures to Depreciation: Asia Pacific

Allergan Inc.; Asia Pacific; area capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Selected Financial Data (US$ in thousands)
Capital expenditures 2,200 2,300 2,000 2,100 3,900
Depreciation and amortization 4,800 5,000 4,600 4,500 3,800
Area Financial Ratio
Area capital expenditures to depreciation1 0.46 0.46 0.43 0.47 1.03

Based on: 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), 10-K (reporting date: 2010-12-31).

1 2014 Calculation
Area capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 2,200 ÷ 4,800 = 0.46

Area financial ratio Geographic area The company
Area capital expenditures to depreciation Asia Pacific Asia Pacific area capital expenditures to depreciation ratio improved from 2012 to 2013 but then slightly deteriorated from 2013 to 2014.

Area Capital Expenditures to Depreciation: Other

Allergan Inc.; Other; area capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Selected Financial Data (US$ in thousands)
Capital expenditures 100 100
Depreciation and amortization 400 600 800 900 800
Area Financial Ratio
Area capital expenditures to depreciation1 0.00 0.00 0.13 0.00 0.13

Based on: 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), 10-K (reporting date: 2010-12-31).

1 2014 Calculation
Area capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 0 ÷ 400 = 0.00

Area financial ratio Geographic area The company
Area capital expenditures to depreciation Other

Product net sales

Allergan Inc., product net sales by geographic area

US$ in thousands

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
United States 4,520,500 3,839,400 3,478,400 3,221,600 3,017,000
Europe 1,410,300 1,237,800 1,121,400 1,086,600 931,600
Latin America 382,000 383,000 399,200 390,700 323,700
Asia Pacific 512,300 464,100 448,900 408,700 333,800
Other 301,000 273,200 260,900 239,500 213,500
Total 7,126,100 6,197,500 5,708,800 5,347,100 4,819,600

Based on: 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), 10-K (reporting date: 2010-12-31).


Long-lived assets

Allergan Inc., long-lived assets by geographic area

US$ in thousands

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
United States 4,497,000 4,274,700 3,718,600 3,500,900 3,222,400
Europe 627,100 569,900 538,600 502,000 563,100
Latin America 49,400 52,200 55,600 59,400 65,000
Asia Pacific 47,300 51,200 53,800 53,300 56,300
Other 1,900 1,400 2,200 2,800 3,700
Total 5,222,700 4,949,400 4,368,800 4,118,400 3,910,500

Based on: 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), 10-K (reporting date: 2010-12-31).


Depreciation and amortization

Allergan Inc., depreciation and amortization by geographic area

US$ in thousands

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
United States 187,300 181,200 194,700 187,900 202,200
Europe 48,500 49,600 48,100 50,300 42,000
Latin America 7,100 7,700 8,400 9,800 8,300
Asia Pacific 4,800 5,000 4,600 4,500 3,800
Other 400 600 800 900 800
Total 248,100 244,100 256,600 253,400 257,100

Based on: 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), 10-K (reporting date: 2010-12-31).


Capital expenditures

Allergan Inc., capital expenditures by geographic area

US$ in thousands

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
United States 98,400 82,300 75,700 63,600 62,800
Europe 136,400 79,700 59,500 46,300 29,300
Latin America 6,900 7,600 6,000 6,600 6,700
Asia Pacific 2,200 2,300 2,000 2,100 3,900
Other 100 100
Total 243,900 171,900 143,300 118,600 102,800

Based on: 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), 10-K (reporting date: 2010-12-31).