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 Liquidity Ratios 
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Allergan Inc., liquidity 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
Current ratio 4.41 3.90 4.05 4.37 4.28 4.11 4.08 3.83 4.07 4.30 4.42 4.38 4.24 3.99 3.90 2.77 2.61 2.03 2.36 4.01
Quick ratio 3.78 3.29 3.39 3.69 3.64 3.43 3.27 2.95 3.40 3.61 3.67 3.61 3.47 3.24 3.15 2.34 2.22 1.76 1.99 3.25
Cash ratio 3.19 2.67 2.64 2.90 2.93 2.68 2.43 2.12 2.70 2.78 2.77 2.73 2.71 2.47 2.34 1.88 1.79 1.48 1.56 2.54

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


Current Ratio
The current ratio shows a fluctuating but generally stable trend over the analyzed periods. It started at a high of 4.01 in March 2010, followed by a decline to around 2.03 by September 2010. Thereafter, the ratio improved markedly, reaching peaks near or above 4.0 in most quarters from mid-2011 to the end of 2014. This indicates consistent liquidity, with the company's ability to cover short-term liabilities with current assets remaining strong throughout the period despite some short-term volatility.
Quick Ratio
The quick ratio moves in a pattern similar to the current ratio but with slightly lower absolute values, reflecting the exclusion of less liquid current assets such as inventory. Beginning at 3.25 in early 2010, it declined to 1.76 by the third quarter of 2010 but subsequently rebounded. From mid-2011 onward, the quick ratio stays generally within the range of 3.0 to 3.7, suggesting a solid quick liquidity position, with minor dips toward the end of 2014 but still maintaining a buffer above 3.
Cash Ratio
The cash ratio exhibits a pattern consistent with the other liquidity ratios but at lower levels, reflecting cash and cash equivalents relative to current liabilities. Starting at 2.54 in early 2010, it decreased to a low of 1.48 in September 2010, before improving steadily over subsequent quarters. From mid-2011 through 2014, the cash ratio generally ranges between 2.3 and 3.2, evidencing a strong cash position that supports immediate obligations. Notably, there is an upward trend toward the end of the observed timeframe, culminating in a peak of 3.19 in December 2014.
Overall Analysis
All three liquidity ratios experienced a downturn during the first nine months of 2010, possibly indicative of temporary liquidity pressure or restructuring of current assets and liabilities. Following this period, a robust recovery ensued, with all ratios stabilizing at high levels through 2011 to 2014. The high current and quick ratios reflect effective management of short-term assets and liabilities, while the strong cash ratio indicates prudent cash holdings. Minor fluctuations in the later periods suggest normal quarterly variability without material detriment to liquidity. Overall, the company maintained a strong liquidity position across all quarters after the initial dip in 2010.

Current Ratio

Allergan Inc., current ratio 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)
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
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
Liquidity Ratio
Current ratio1 4.41 3.90 4.05 4.37 4.28 4.11 4.08 3.83 4.07 4.30 4.42 4.38 4.24 3.99 3.90 2.77 2.61 2.03 2.36 4.01
Benchmarks
Current Ratio, 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.
Vertex Pharmaceuticals 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
Current ratio = Current assets ÷ Current liabilities
= 6,871,200 ÷ 1,557,300 = 4.41

2 Click competitor name to see calculations.


Current Assets
The current assets show a generally upward trend over the observed periods from March 31, 2010, to December 31, 2014. Initially, there was a significant increase from 3,144,200 thousand USD to 4,243,400 thousand USD by September 30, 2010, followed by some fluctuations through 2011. From 2012 onwards, current assets steadily increased with minor variability, reaching a peak of 6,871,200 thousand USD by the end of 2014. This indicates a strengthening liquidity position in terms of asset holdings available to meet short-term obligations.
Current Liabilities
Current liabilities exhibited notable volatility during the early periods, rising sharply from 783,300 thousand USD in March 2010 to over 2,093,000 thousand USD in September 2010. A decline occurred again in the first half of 2011, stabilizing around the 950,000 to 1,100,000 thousand USD range through 2012 and 2013. In the final periods through 2014, current liabilities demonstrated a gradual upward trend, rising from 1,248,100 thousand USD to approximately 1,557,300 thousand USD at year-end. This increase, although moderate compared to assets, should be noted for potential effects on short-term financial risk.
Current Ratio
The current ratio fluctuated significantly in the initial quarters, starting very high at 4.01 in March 2010, then dropping sharply to 2.03 by September 2010 before climbing back above 2.5 by the end of 2010. Between 2011 and 2012, the ratio maintained a generally high level, peaking at 4.42 in June 2012, reflecting a strong ability to cover short-term liabilities with current assets. There was a slight fluctuation in subsequent years, oscillating between approximately 3.8 and 4.4, indicating consistent and robust liquidity. The ratio remained well above the typical benchmark of 1.0, underlining a conservative management of current assets relative to liabilities throughout the period.
Overall Insights
The data reflects a growing asset base with relatively controlled increases in liabilities, resulting in a consistently high current ratio, which suggests sound short-term financial health. The initial volatility in liabilities and current ratio around 2010 indicates a period of adjustment or restructuring, after which the company attained a stable and favorable liquidity position. The steady growth in current assets, coupled with moderate liability increases, enhances the capacity to manage operational needs and unexpected expenses effectively.

Quick Ratio

Allergan Inc., quick ratio 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)
Cash and equivalents 4,911,400 3,910,800 3,189,900 2,815,300 3,046,100 2,686,300 2,484,000 2,198,800 2,701,800 2,655,000 2,368,700 2,291,700 2,406,100 2,212,000 1,856,500 2,530,800 1,991,200 2,603,300 2,219,600 1,989,700
Short-term investments 55,000 274,600 525,600 802,000 603,000 524,600 184,800 50,000 260,600 279,900 304,800 349,800 179,900 66,500 299,800 249,700 749,100 499,300
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
Total quick assets 5,880,900 5,152,800 4,770,500 4,607,700 4,532,400 4,119,100 3,586,000 3,136,700 3,726,600 3,807,500 3,541,400 3,497,200 3,316,600 2,989,400 2,900,500 3,452,100 3,387,600 3,689,500 2,820,900 2,548,400
 
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
Liquidity Ratio
Quick ratio1 3.78 3.29 3.39 3.69 3.64 3.43 3.27 2.95 3.40 3.61 3.67 3.61 3.47 3.24 3.15 2.34 2.22 1.76 1.99 3.25
Benchmarks
Quick Ratio, 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.
Vertex Pharmaceuticals 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
Quick ratio = Total quick assets ÷ Current liabilities
= 5,880,900 ÷ 1,557,300 = 3.78

2 Click competitor name to see calculations.


Total quick assets
The total quick assets demonstrated an overall upward trend from March 31, 2010, to December 31, 2014. Starting at approximately 2.55 million USD, the value rose significantly to around 5.88 million USD by the end of the period. Although there were minor fluctuations, such as a dip in mid-2011, the general pattern was strong growth, particularly noticeable from early 2013 onwards. This increase reflects an enhancement in liquid assets available to the company.
Current liabilities
Current liabilities showed variability throughout the periods, with no consistent upward or downward trend. Initially, liabilities rose sharply from 0.78 million USD in March 2010 to 2.09 million USD by September 2010, followed by a decline towards mid-2011. From 2012 onwards, liabilities hovered mostly between 1.0 and 1.56 million USD, with slight increases and occasional decreases. By the end of 2014, current liabilities were around 1.56 million USD, indicating a stabilization compared to earlier fluctuations but with an overall increase compared to the starting point.
Quick ratio
The quick ratio exhibited considerable volatility in the early years but showed an overall strong liquidity position throughout the period. It began at a high of 3.25 in March 2010, dropped to a low of 1.76 by September 2010, and then climbed steadily, reaching values above 3.0 from 2011 onward. The ratio peaked at 3.78 in December 2014, indicating improved short-term financial health and the company's ability to cover current liabilities with its quick assets. The quick ratio generally maintained a level well above 1.0, which suggests a conservative liquidity strategy.
Summary
In summary, the company showed a robust increase in liquid assets over the analyzed period while maintaining current liabilities at levels well below total quick assets, leading to strong quick ratios. This points to a healthy liquidity position with efficient management of short-term obligations. Fluctuations in current liabilities and the quick ratio during the early periods were followed by a phase of stability and improvement, particularly from 2012 forward. Overall, the financial data imply enhanced financial resilience and capacity to meet immediate liabilities without reliance on inventory liquidation.

Cash Ratio

Allergan Inc., cash ratio 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)
Cash and equivalents 4,911,400 3,910,800 3,189,900 2,815,300 3,046,100 2,686,300 2,484,000 2,198,800 2,701,800 2,655,000 2,368,700 2,291,700 2,406,100 2,212,000 1,856,500 2,530,800 1,991,200 2,603,300 2,219,600 1,989,700
Short-term investments 55,000 274,600 525,600 802,000 603,000 524,600 184,800 50,000 260,600 279,900 304,800 349,800 179,900 66,500 299,800 249,700 749,100 499,300
Total cash assets 4,966,400 4,185,400 3,715,500 3,617,300 3,649,100 3,210,900 2,668,800 2,248,800 2,962,400 2,934,900 2,673,500 2,641,500 2,586,000 2,278,500 2,156,300 2,780,500 2,740,300 3,102,600 2,219,600 1,989,700
 
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
Liquidity Ratio
Cash ratio1 3.19 2.67 2.64 2.90 2.93 2.68 2.43 2.12 2.70 2.78 2.77 2.73 2.71 2.47 2.34 1.88 1.79 1.48 1.56 2.54
Benchmarks
Cash Ratio, 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.
Vertex Pharmaceuticals 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 ratio = Total cash assets ÷ Current liabilities
= 4,966,400 ÷ 1,557,300 = 3.19

2 Click competitor name to see calculations.


Total Cash Assets
Over the observed quarterly periods, total cash assets demonstrated notable fluctuations with an overall upward trajectory. Initially, from the first quarter of 2010 through early 2011, cash assets showed a progressive increase peaking at approximately 3.1 billion US dollars by September 2010 before experiencing some volatility. Following a dip in mid-2011, the cash assets generally trended upward, achieving a significant rise towards the end of 2013 and continuing into 2014, culminating near 4.97 billion US dollars by the last quarter noted. This trend indicates strengthening liquidity and possibly reflects improved cash flow management or increased cash reserves.
Current Liabilities
Current liabilities exhibited considerable variation throughout the period. They surged sharply from approximately 783 million US dollars at the start of 2010 to over 2 billion US dollars by the third quarter of 2010, indicating a rapid accumulation of short-term obligations. After this peak, liabilities decreased significantly during 2011 but remained comparatively high. From 2012 onward, current liabilities fluctuated within a narrower range but showed a slow increasing pattern again during 2013 and 2014, reaching around 1.56 billion US dollars by the end of 2014. The early volatility followed by gradual growth may suggest changing operating conditions or evolving financial strategies affecting short-term debt.
Cash Ratio
The cash ratio, which reflects liquidity by comparing cash and cash equivalents to current liabilities, portrayed pronounced changes corresponding to movements in cash assets and liabilities. Initially, this ratio decreased markedly from a high of 2.54 in the first quarter of 2010 to 1.48 in the third quarter of the same year, aligned with rising current liabilities and fluctuating cash assets. However, beginning in late 2010, the cash ratio steadily improved, frequently remaining above 2.0, and reached a peak of 3.19 by the end of 2014. The elevated cash ratio in later years signifies enhanced short-term financial stability and the ability to cover current obligations more comfortably, indicative of prudent liquidity management.