Stock Analysis on Net

Allergan PLC (NYSE:AGN)

This company has been moved to the archive! The financial data has not been updated since May 7, 2020.

Common-Size Balance Sheet: Assets 
Quarterly Data

Allergan PLC, common-size consolidated balance sheet: assets (quarterly data)

Microsoft Excel
Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Cash and cash equivalents 1.13 2.64 1.31 1.73 0.80 0.86 1.11 1.54 0.89 1.54 1.36 0.71 0.86 1.34 5.26 0.37 1.66 0.81 1.45 1.10 1.52
Marketable securities 1.83 3.60 3.51 0.34 1.02 1.01 0.02 0.02 0.93 3.91 3.22 3.96 6.20 8.92 13.81 0.01 0.01 0.01 0.00 0.01 0.01
Accounts receivable, net of allowances for doubtful accounts and credit losses 3.17 3.37 3.19 3.23 2.79 2.82 2.65 2.54 2.36 2.45 2.36 2.24 2.00 1.96 1.67 1.88 1.95 1.77 1.50 3.19 2.86
Inventories 1.36 1.20 1.15 1.05 0.96 0.83 0.84 0.85 0.85 0.76 0.76 0.75 0.71 0.56 0.49 0.55 0.75 0.74 0.90 2.01 2.24
Current assets held for sale 0.00 0.00 0.00 0.00 0.05 0.03 0.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.32 3.20 2.58 2.61 2.66 0.03 0.10
Prepaid expenses and other current assets 0.97 0.94 1.00 2.63 0.80 0.80 0.75 0.67 0.69 0.95 0.81 0.70 1.03 1.07 0.54 0.59 0.47 0.41 0.52 0.73 0.73
Deferred tax assets 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4.63 0.51 0.43
Current assets 8.45% 11.75% 10.16% 8.98% 6.42% 6.36% 5.39% 5.61% 5.71% 9.61% 8.50% 8.36% 10.80% 13.84% 22.09% 6.60% 7.42% 6.34% 11.66% 7.58% 7.90%
Property, plant and equipment, net 2.17 2.03 1.97 1.91 1.82 1.76 1.65 1.62 1.58 1.51 1.51 1.40 1.31 1.25 1.09 1.17 1.18 1.16 1.10 2.07 2.01
Right of use asset, operating leases 0.54 0.52 0.51 0.48 0.46 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Investments and other assets 0.49 0.43 0.39 0.35 2.02 1.94 0.28 0.27 0.24 0.23 0.23 0.23 0.22 0.22 0.24 0.27 0.30 0.43 0.35 0.38 0.37
Non current assets held for sale 0.04 0.03 0.03 0.03 0.92 0.87 0.16 0.17 0.06 0.07 0.01 0.01 0.02 0.02 0.14 8.14 7.82 7.76 7.40 0.00 0.00
Deferred tax assets 0.68 0.61 0.52 0.72 1.05 1.05 0.93 0.83 0.80 0.27 0.27 0.23 0.20 0.18 0.08 0.14 0.06 0.04 0.05 0.08 0.07
Product rights and other intangibles 41.01 40.01 41.87 43.18 43.11 42.93 45.17 45.87 46.93 46.18 47.65 50.00 49.67 48.55 43.89 48.61 48.90 50.01 47.01 52.61 53.21
Goodwill 46.63 44.61 44.56 44.34 44.20 45.11 46.42 45.64 44.69 42.13 41.83 39.76 37.78 35.94 32.47 35.07 34.34 34.27 32.43 37.28 36.44
Non current assets 91.55% 88.25% 89.84% 91.02% 93.58% 93.64% 94.61% 94.39% 94.29% 90.39% 91.50% 91.64% 89.20% 86.16% 77.91% 93.40% 92.58% 93.66% 88.34% 92.42% 92.10%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

Based on: 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31).


Cash and Cash Equivalents
The proportion of cash and cash equivalents relative to total assets fluctuated over the analyzed period. It experienced a notable peak of 5.26% in September 2016 but generally remained below 2.7%. From early 2019 to early 2020, a modest upward trend is observed, rising from 0.8% in March 2019 to 2.64% in December 2019 before decreasing again to 1.13% in March 2020.
Marketable Securities
This item exhibited significant volatility. Early periods showed negligible proportions until a sharp increase to 13.81% in September 2016, followed by a steady decline toward early 2018. Subsequently, the values remained generally low with some oscillations, ending at 1.83% in March 2020. This indicates a spike in investments in marketable securities around late 2016, with lower emphasis in other periods.
Accounts Receivable (Net)
Accounts receivable as a percentage of total assets showed moderate fluctuations but a general upward trend from 1.5% in September 2015 to above 3.0% during 2019, reaching 3.37% in September 2019 before slightly decreasing to 3.17% in March 2020. This suggests a gradual increase in credit sales or collection times over the time span.
Inventories
Inventories maintained relatively low levels, generally under 2%. Initial values were around 2.24% in early 2015, dipping below 1% through much of 2015 and 2016, then steadily increasing from 0.96% in March 2019 to 1.36% in March 2020. This reflects a cautious build-up of inventory levels in the more recent periods.
Current Assets Held for Sale
This category showed concentration primarily between mid-2015 and mid-2016, with values peaking above 3% and then declining sharply to near zero afterward, indicating possible divestitures or asset reclassifications during that timeframe.
Prepaid Expenses and Other Current Assets
The percentage for prepaid expenses and other current assets fluctuated between 0.4% and 2.6%, with a pronounced spike to 2.63% in June 2019 before normalizing around 1% towards March 2020, suggesting episodic increases in advance payments or similar assets.
Deferred Tax Assets (Current and Non-current)
Deferred tax assets exhibited volatility, with an early spike up to 4.63% in September 2015 (likely current assets). Non-current deferred tax assets showed a progressive increase from 0.07% in March 2015 to a peak of 1.05% in March 2019, followed by a slight decline, indicating increasing recognition of tax benefits over time.
Current Assets Overall
The proportion of current assets markedly peaked at 22.09% in September 2016, primarily due to spikes in marketable securities and current assets held for sale. Apart from this anomaly, the current asset ratio generally ranged between 5.3% and 12%, with a rising trend observed from mid-2018 onward towards 11.75% in December 2019, before declining to 8.45% in March 2020.
Property, Plant and Equipment (Net)
This asset category demonstrated a gradual but steady increase from just above 2% in early 2015 to 2.17% by March 2020, reflecting ongoing capital investment or asset revaluation.
Right of Use Asset, Operating Leases
This item appears only in the final quarters, showing a small but increasing presence from 0.46% in March 2019 to 0.54% in March 2020, indicative of adoption of new leasing standards or growing lease commitments.
Investments and Other Assets
A generally low and stable proportion was recorded in the initial years, between 0.22% and 0.38%. There was a notable spike to 1.94% and 2.02% in late 2018, followed by reversion to sub-0.5% levels, suggesting transient investment activities or asset reclassification in late 2018.
Non-current Assets Held for Sale
Values peaked around 7.8% from late 2015 to mid-2016 with a steep decline afterward to below 1%, indicating disposal or reclassification of long-term assets during the peak period and stabilization thereafter.
Product Rights and Other Intangibles
This category constitutes the largest asset portion, consistently ranging between 40% and 53%. A downward trend is evident over the entire period, from 53.21% in March 2015 to approximately 41% in early 2020, signaling amortization or impairment of intangible assets or asset base shifts.
Goodwill
Goodwill increased steadily from approximately 36% in early 2015 to nearly 47% by March 2020, indicating acquisitions or valuation adjustments contributing to increased intangible goodwill assets over time.
Non-current Assets Overall
The proportion of non-current assets remained dominant, fluctuating mostly between 88% and 94%, with a dip to 77.91% in September 2016 coinciding with spikes in current assets held for sale and marketable securities. The overall trend denotes a stable long-term asset base with occasional fluctuations tied to asset disposals or reclassifications.
Total Assets Composition
Throughout the period, the total assets percentage remained consistent at 100%, confirming the proportional analysis of all discussed asset categories relative to the entire asset base.