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 Investments

Microsoft Excel

Adjustment to Net Income (Loss): Mark to Market Available-for-sale Securities

Illumina Inc., adjustment to net income attributable to Illumina stockholders

US$ in millions

Microsoft Excel
12 months ended: Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Net income attributable to Illumina stockholders (as reported) 656 1,002 826 726 463
Add: Unrealized gain (loss) on available-for-sale debt securities, net of deferred tax (3) 6 (1)
Net income attributable to Illumina stockholders (adjusted) 653 1,008 826 726 462

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


Adjusted Profitability Ratios: Mark to Market Available-for-sale Securities (Summary)

Illumina Inc., adjusted profitability ratios

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
Net Profit Margin
Reported net profit margin 20.25% 28.28% 24.78% 26.38% 19.29%
Adjusted net profit margin 20.16% 28.45% 24.78% 26.38% 19.25%
Return on Equity (ROE)
Reported ROE 13.98% 21.72% 21.98% 26.41% 21.06%
Adjusted ROE 13.91% 21.85% 21.98% 26.41% 21.01%
Return on Assets (ROA)
Reported ROA 8.65% 13.70% 11.87% 13.81% 10.81%
Adjusted ROA 8.61% 13.78% 11.87% 13.81% 10.78%

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

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Illumina Inc. adjusted net profit margin ratio improved from 2018 to 2019 but then deteriorated significantly from 2019 to 2020.
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. Illumina Inc. adjusted ROE deteriorated from 2018 to 2019 and from 2019 to 2020.
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. Illumina Inc. adjusted ROA improved from 2018 to 2019 but then deteriorated significantly from 2019 to 2020.

Illumina Inc., Profitability Ratios: Reported vs. Adjusted


Adjusted Net Profit Margin

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
As Reported
Selected Financial Data (US$ in millions)
Net income attributable to Illumina stockholders 656 1,002 826 726 463
Revenue 3,239 3,543 3,333 2,752 2,398
Profitability Ratio
Net profit margin1 20.25% 28.28% 24.78% 26.38% 19.29%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income attributable to Illumina stockholders 653 1,008 826 726 462
Revenue 3,239 3,543 3,333 2,752 2,398
Profitability Ratio
Adjusted net profit margin2 20.16% 28.45% 24.78% 26.38% 19.25%

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

2020 Calculations

1 Net profit margin = 100 × Net income attributable to Illumina stockholders ÷ Revenue
= 100 × 656 ÷ 3,239 = 20.25%

2 Adjusted net profit margin = 100 × Adjusted net income attributable to Illumina stockholders ÷ Revenue
= 100 × 653 ÷ 3,239 = 20.16%

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Illumina Inc. adjusted net profit margin ratio improved from 2018 to 2019 but then deteriorated significantly from 2019 to 2020.

Adjusted Return on Equity (ROE)

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
As Reported
Selected Financial Data (US$ in millions)
Net income attributable to Illumina stockholders 656 1,002 826 726 463
Total Illumina stockholders’ equity 4,694 4,613 3,758 2,749 2,197
Profitability Ratio
ROE1 13.98% 21.72% 21.98% 26.41% 21.06%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income attributable to Illumina stockholders 653 1,008 826 726 462
Total Illumina stockholders’ equity 4,694 4,613 3,758 2,749 2,197
Profitability Ratio
Adjusted ROE2 13.91% 21.85% 21.98% 26.41% 21.01%

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

2020 Calculations

1 ROE = 100 × Net income attributable to Illumina stockholders ÷ Total Illumina stockholders’ equity
= 100 × 656 ÷ 4,694 = 13.98%

2 Adjusted ROE = 100 × Adjusted net income attributable to Illumina stockholders ÷ Total Illumina stockholders’ equity
= 100 × 653 ÷ 4,694 = 13.91%

Profitability ratio Description The company
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. Illumina Inc. adjusted ROE deteriorated from 2018 to 2019 and from 2019 to 2020.

Adjusted Return on Assets (ROA)

Microsoft Excel
Dec 31, 2020 Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Dec 31, 2016
As Reported
Selected Financial Data (US$ in millions)
Net income attributable to Illumina stockholders 656 1,002 826 726 463
Total assets 7,585 7,316 6,959 5,257 4,281
Profitability Ratio
ROA1 8.65% 13.70% 11.87% 13.81% 10.81%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income attributable to Illumina stockholders 653 1,008 826 726 462
Total assets 7,585 7,316 6,959 5,257 4,281
Profitability Ratio
Adjusted ROA2 8.61% 13.78% 11.87% 13.81% 10.78%

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

2020 Calculations

1 ROA = 100 × Net income attributable to Illumina stockholders ÷ Total assets
= 100 × 656 ÷ 7,585 = 8.65%

2 Adjusted ROA = 100 × Adjusted net income attributable to Illumina stockholders ÷ Total assets
= 100 × 653 ÷ 7,585 = 8.61%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. Illumina Inc. adjusted ROA improved from 2018 to 2019 but then deteriorated significantly from 2019 to 2020.