Stock Analysis on Net

Celgene Corp. (NASDAQ:CELG)

This company has been moved to the archive! The financial data has not been updated since October 31, 2019.

Financial Reporting Quality: Aggregate Accruals

Microsoft Excel

Balance-Sheet-Based Accruals Ratio

Celgene Corp., balance sheet computation of aggregate accruals

US$ in millions

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Operating Assets
Total assets 35,480 30,141 28,086 27,053 17,340
Less: Cash and cash equivalents 4,234 7,013 6,170 4,880 4,122
Less: Debt securities available-for-sale 496 3,219
Less: Equity investments with readily determinable fair values 1,312 1,810
Less: Marketable securities available-for-sale 1,800 1,672 3,425
Operating assets 29,438 18,099 20,116 20,502 9,793
Operating Liabilities
Total liabilities 29,319 23,220 21,486 21,134 10,815
Less: Short-term borrowings and current portion of long-term debt 501 501 606
Less: Long-term debt, net of discount, excluding current portion 19,769 15,838 13,789 14,250 6,266
Operating liabilities 9,049 7,382 7,197 6,884 3,944
 
Net operating assets1 20,389 10,717 12,919 13,618 5,850
Balance-sheet-based aggregate accruals2 9,672 (2,202) (699) 7,768
Financial Ratio
Balance-sheet-based accruals ratio3 62.19% -18.63% -5.27% 79.80%
Benchmarks
Balance-Sheet-Based Accruals Ratio, Competitors4
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: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Net operating assets = Operating assets – Operating liabilities
= 29,4389,049 = 20,389

2 2018 Calculation
Balance-sheet-based aggregate accruals = Net operating assets2018 – Net operating assets2017
= 20,38910,717 = 9,672

3 2018 Calculation
Balance-sheet-based accruals ratio = 100 × Balance-sheet-based aggregate accruals ÷ Avg. net operating assets
= 100 × 9,672 ÷ [(20,389 + 10,717) ÷ 2] = 62.19%

4 Click competitor name to see calculations.

Financial ratio Description The company
Balance-sheet-based accruals ratio Ratio is found by dividing balance-sheet-based aggregate accruals by average net operating assets. Using the balance-sheet-based accruals ratio, Celgene Corp. deteriorated earnings quality from 2017 to 2018.

Cash-Flow-Statement-Based Accruals Ratio

Celgene Corp., cash flow statement computation of aggregate accruals

US$ in millions

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Net income 4,046 2,940 1,999 1,602 2,000
Less: Net cash provided by operating activities 5,171 5,246 3,976 2,484 2,806
Less: Net cash used in investing activities (6,418) (2,891) (1,002) (6,259) (1,438)
Cash-flow-statement-based aggregate accruals 5,293 585 (975) 5,377 632
Financial Ratio
Cash-flow-statement-based accruals ratio1 34.03% 4.95% -7.35% 55.24%
Benchmarks
Cash-Flow-Statement-Based Accruals 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: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 2018 Calculation
Cash-flow-statement-based accruals ratio = 100 × Cash-flow-statement-based aggregate accruals ÷ Avg. net operating assets
= 100 × 5,293 ÷ [(20,389 + 10,717) ÷ 2] = 34.03%

2 Click competitor name to see calculations.

Financial ratio Description The company
Cash-flow-statement-based accruals ratio Ratio is found by dividing cash-flow-statement-based aggregate accruals by average net operating assets. Using the cash-flow-statement-based accruals ratio, Celgene Corp. deteriorated earnings quality from 2017 to 2018.