Stock Analysis on Net

Illumina Inc. (NASDAQ:ILMN)

This company has been moved to the archive! The financial data has not been updated since November 5, 2021.

Financial Reporting Quality: Aggregate Accruals

Microsoft Excel

Balance-Sheet-Based Accruals Ratio

Illumina Inc., balance sheet computation of aggregate accruals

US$ in millions

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Operating Assets
Total assets 7,585 7,316 6,959 5,257 4,281
Less: Cash and cash equivalents 1,810 2,042 1,144 1,225 735
Less: Short-term investments 1,662 1,372 2,368 920 824
Operating assets 4,113 3,902 3,447 3,112 2,722
Operating Liabilities
Total liabilities 2,891 2,703 3,053 2,288 1,966
Less: Build-to-suit lease liability 144 223
Less: Long-term debt, current portion 511 1,107 10 1
Less: Long-term debt, excluding current portion 673 1,141 890 1,182 1,048
Operating liabilities 1,707 1,562 1,056 952 695
 
Net operating assets1 2,406 2,340 2,391 2,160 2,027
Balance-sheet-based aggregate accruals2 66 (51) 231 133
Financial Ratio
Balance-sheet-based accruals ratio3 2.78% -2.16% 10.15% 6.34%
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.
Balance-Sheet-Based Accruals Ratio, Sector
Pharmaceuticals, Biotechnology & Life Sciences 200.00%
Balance-Sheet-Based Accruals Ratio, Industry
Health Care 200.00%

Based on: 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-29), 10-K (reporting date: 2018-12-30), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31).

1 2020 Calculation
Net operating assets = Operating assets – Operating liabilities
= 4,1131,707 = 2,406

2 2020 Calculation
Balance-sheet-based aggregate accruals = Net operating assets2020 – Net operating assets2019
= 2,4062,340 = 66

3 2020 Calculation
Balance-sheet-based accruals ratio = 100 × Balance-sheet-based aggregate accruals ÷ Avg. net operating assets
= 100 × 66 ÷ [(2,406 + 2,340) ÷ 2] = 2.78%

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, Illumina Inc. deteriorated earnings quality from 2019 to 2020.

Cash-Flow-Statement-Based Accruals Ratio

Illumina Inc., cash flow statement computation of aggregate accruals

US$ in millions

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Net income attributable to Illumina stockholders 656 1,002 826 726 463
Less: Net cash provided by operating activities 1,080 1,051 1,142 875 687
Less: Net cash (used in) provided by investing activities (554) 745 (1,813) (214) (515)
Cash-flow-statement-based aggregate accruals 130 (794) 1,497 65 290
Financial Ratio
Cash-flow-statement-based accruals ratio1 5.48% -33.57% 65.79% 3.10%
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.
Cash-Flow-Statement-Based Accruals Ratio, Sector
Pharmaceuticals, Biotechnology & Life Sciences 21.65%
Cash-Flow-Statement-Based Accruals Ratio, Industry
Health Care 12.37%

Based on: 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-29), 10-K (reporting date: 2018-12-30), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31).

1 2020 Calculation
Cash-flow-statement-based accruals ratio = 100 × Cash-flow-statement-based aggregate accruals ÷ Avg. net operating assets
= 100 × 130 ÷ [(2,406 + 2,340) ÷ 2] = 5.48%

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, Illumina Inc. improved earnings quality from 2019 to 2020.