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.

Analysis of Reportable Segments

Microsoft Excel

Segment Profit Margin

Illumina Inc., profit margin by reportable segment

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Core Illumina 17.91% 28.45% 29.09% 25.27% 28.16%
Helix -2,400.00% -900.00% -1,533.33%

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

Segment profitability ratio Reportable segment The company
Segment profit margin Core Illumina Core Illumina segment profit margin ratio deteriorated from 2018 to 2019 and from 2019 to 2020.
Helix Helix segment profit margin ratio deteriorated from 2018 to 2019 and from 2019 to 2020.

Segment Profit Margin: Core Illumina

Illumina Inc.; Core Illumina; segment profit margin calculation

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Selected Financial Data (US$ in millions)
Income (loss) from operations 580 1,008 970 696 684
Revenue 3,239 3,543 3,334 2,754 2,428
Segment Profitability Ratio
Segment profit margin1 17.91% 28.45% 29.09% 25.27% 28.16%

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
Segment profit margin = 100 × Income (loss) from operations ÷ Revenue
= 100 × 580 ÷ 3,239 = 17.91%

Segment profitability ratio Reportable segment The company
Segment profit margin Core Illumina Core Illumina segment profit margin ratio deteriorated from 2018 to 2019 and from 2019 to 2020.

Segment Profit Margin: Helix

Illumina Inc.; Helix; segment profit margin calculation

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Selected Financial Data (US$ in millions)
Income (loss) from operations (24) (90) (92) (81)
Revenue 1 10 6
Segment Profitability Ratio
Segment profit margin1 -2,400.00% -900.00% -1,533.33%

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
Segment profit margin = 100 × Income (loss) from operations ÷ Revenue
= 100 × 0 ÷ 0 =

Segment profitability ratio Reportable segment The company
Segment profit margin Helix Helix segment profit margin ratio deteriorated from 2018 to 2019 and from 2019 to 2020.

Segment Return on Assets (Segment ROA)

Illumina Inc., ROA by reportable segment

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Core Illumina 7.65% 13.78% 14.03% 13.33% 16.41%
Helix -58.44% -204.44% -45.13%

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

Segment profitability ratio Reportable segment The company
Segment ROA Core Illumina Core Illumina segment ROA deteriorated from 2018 to 2019 and from 2019 to 2020.
Helix

Segment ROA: Core Illumina

Illumina Inc.; Core Illumina; segment ROA calculation

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Selected Financial Data (US$ in millions)
Income (loss) from operations 580 1,008 970 696 684
Total assets 7,585 7,316 6,912 5,223 4,167
Segment Profitability Ratio
Segment ROA1 7.65% 13.78% 14.03% 13.33% 16.41%

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
Segment ROA = 100 × Income (loss) from operations ÷ Total assets
= 100 × 580 ÷ 7,585 = 7.65%

Segment profitability ratio Reportable segment The company
Segment ROA Core Illumina Core Illumina segment ROA deteriorated from 2018 to 2019 and from 2019 to 2020.

Segment ROA: Helix

Illumina Inc.; Helix; segment ROA calculation

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Selected Financial Data (US$ in millions)
Income (loss) from operations (24) (90) (92) (81)
Total assets 154 45 180
Segment Profitability Ratio
Segment ROA1 -58.44% -204.44% -45.13%

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
Segment ROA = 100 × Income (loss) from operations ÷ Total assets
= 100 × 0 ÷ 0 =

Segment profitability ratio Reportable segment The company
Segment ROA Helix

Segment Asset Turnover

Illumina Inc., asset turnover by reportable segment

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Core Illumina 0.43 0.48 0.48 0.53 0.58
Helix 0.06 0.13 0.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).

Segment activity ratio Reportable segment The company
Segment asset turnover Core Illumina Core Illumina segment asset turnover ratio improved from 2018 to 2019 but then deteriorated significantly from 2019 to 2020.
Helix

Segment Asset Turnover: Core Illumina

Illumina Inc.; Core Illumina; segment asset turnover calculation

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Selected Financial Data (US$ in millions)
Revenue 3,239 3,543 3,334 2,754 2,428
Total assets 7,585 7,316 6,912 5,223 4,167
Segment Activity Ratio
Segment asset turnover1 0.43 0.48 0.48 0.53 0.58

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
Segment asset turnover = Revenue ÷ Total assets
= 3,239 ÷ 7,585 = 0.43

Segment activity ratio Reportable segment The company
Segment asset turnover Core Illumina Core Illumina segment asset turnover ratio improved from 2018 to 2019 but then deteriorated significantly from 2019 to 2020.

Segment Asset Turnover: Helix

Illumina Inc.; Helix; segment asset turnover calculation

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Selected Financial Data (US$ in millions)
Revenue 1 10 6
Total assets 154 45 180
Segment Activity Ratio
Segment asset turnover1 0.06 0.13 0.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
Segment asset turnover = Revenue ÷ Total assets
= 0 ÷ 0 =

Segment activity ratio Reportable segment The company
Segment asset turnover Helix

Segment Capital Expenditures to Depreciation

Illumina Inc., capital expenditures to depreciation by reportable segment

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Core Illumina 1.01 1.12 1.68 2.00 1.73
Helix 0.00 0.33 0.67 5.15

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

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Core Illumina Core Illumina segment capital expenditures to depreciation ratio deteriorated from 2018 to 2019 and from 2019 to 2020.
Helix

Segment Capital Expenditures to Depreciation: Core Illumina

Illumina Inc.; Core Illumina; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Selected Financial Data (US$ in millions)
Capital expenditures 189 209 294 306 238
Depreciation and amortization 187 186 175 153 138
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.01 1.12 1.68 2.00 1.73

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
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 189 ÷ 187 = 1.01

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Core Illumina Core Illumina segment capital expenditures to depreciation ratio deteriorated from 2018 to 2019 and from 2019 to 2020.

Segment Capital Expenditures to Depreciation: Helix

Illumina Inc.; Helix; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Selected Financial Data (US$ in millions)
Capital expenditures 2 4 22
Depreciation and amortization 3 6 6 4
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.00 0.33 0.67 5.15

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
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 0 ÷ 0 =

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Helix

Revenue

Illumina Inc., revenue by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Core Illumina 3,239 3,543 3,334 2,754 2,428
Helix 1 10 6
Eliminations (1) (11) (8) (30)
Consolidated 3,239 3,543 3,333 2,752 2,398

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


Depreciation and amortization

Illumina Inc., depreciation and amortization by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Core Illumina 187 186 175 153 138
Helix 3 6 6 4
Eliminations (1) (2) (3)
Consolidated 187 188 179 156 142

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


Income (loss) from operations

Illumina Inc., income (loss) from operations by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Core Illumina 580 1,008 970 696 684
Helix (24) (90) (92) (81)
Eliminations 1 3 2 (16)
Consolidated 580 985 883 606 587

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


Total assets

Illumina Inc., total assets by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Core Illumina 7,585 7,316 6,912 5,223 4,167
Helix 154 45 180
Eliminations (107) (11) (66)
Consolidated 7,585 7,316 6,959 5,257 4,281

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


Capital expenditures

Illumina Inc., capital expenditures by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Core Illumina 189 209 294 306 238
Helix 2 4 22
Consolidated 189 209 296 310 261

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