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

Earnings can be decomposed into cash and accrual components. The accrual component (aggregate accruals) has been found to have less persistence than the cash component, and therefore (1) earnings with higher accrual component are less persistent than earnings with smaller accrual component, all else equal; and (2) the cash component of earnings should receive a higher weighting evaluating company performance.


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.

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.

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.