Microsoft Excel LibreOffice Calc

Illumina Inc. (NASDAQ:ILMN)

Paying users zone. Data is hidden behind: .

  • Get 1-month access to Illumina Inc. for $15.99, or

  • get full access to the entire website for at least 3 months from $49.99.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey

This is a one-time payment. There is no automatic renewal.


Adjustments to Financial Statements

Advanced level


Adjustments to Current Assets

Illumina Inc., adjusted current assets

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Jan 1, 2017 Jan 3, 2016
As Reported
Current assets
Adjustments
Add: Allowance for doubtful accounts
After Adjustment
Adjusted current assets

Based on: 10-K (filing date: 2020-02-11), 10-K (filing date: 2019-02-12), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-14), 10-K (filing date: 2016-03-02).


Adjustments to Total Assets

Illumina Inc., adjusted total assets

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Jan 1, 2017 Jan 3, 2016
As Reported
Total assets
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1
Add: Allowance for doubtful accounts
Less: Deferred tax assets, net2
After Adjustment
Adjusted total assets

Based on: 10-K (filing date: 2020-02-11), 10-K (filing date: 2019-02-12), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-14), 10-K (filing date: 2016-03-02).

1 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 Deferred tax assets, net. See details »


Adjustments to Total Liabilities

Illumina Inc., adjusted total liabilities

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Jan 1, 2017 Jan 3, 2016
As Reported
Total liabilities
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1
Less: Deferred tax liabilities2
Less: Reserve for product warranties
After Adjustment
Adjusted total liabilities

Based on: 10-K (filing date: 2020-02-11), 10-K (filing date: 2019-02-12), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-14), 10-K (filing date: 2016-03-02).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

Illumina Inc., adjusted total Illumina stockholders’ equity

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Jan 1, 2017 Jan 3, 2016
As Reported
Total Illumina stockholders’ equity
Adjustments
Less: Deferred tax assets (liabilities), net1
Add: Allowance for doubtful accounts
Add: Reserve for product warranties
Add: Redeemable noncontrolling interests
Add: Noncontrolling interests
After Adjustment
Adjusted total stockholders’ equity

Based on: 10-K (filing date: 2020-02-11), 10-K (filing date: 2019-02-12), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-14), 10-K (filing date: 2016-03-02).

1 Deferred tax assets (liabilities), net. See details »


Adjustments to Capitalization Table

Illumina Inc., adjusted capitalization table

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Jan 1, 2017 Jan 3, 2016
As Reported
Build-to-suit lease liability
Long-term debt, current portion
Long-term debt, excluding current portion
Total reported debt
Total Illumina stockholders’ equity
Total reported capital
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1
Add: Operating lease liabilities, current portion2
Add: Operating lease liabilities, excluding current portion3
Adjusted total debt
Adjustments to Equity
Less: Deferred tax assets (liabilities), net4
Add: Allowance for doubtful accounts
Add: Reserve for product warranties
Add: Redeemable noncontrolling interests
Add: Noncontrolling interests
Adjusted total stockholders’ equity
After Adjustment
Adjusted total capital

Based on: 10-K (filing date: 2020-02-11), 10-K (filing date: 2019-02-12), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-14), 10-K (filing date: 2016-03-02).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Operating lease liabilities, current portion. See details »

3 Operating lease liabilities, excluding current portion. See details »

4 Deferred tax assets (liabilities), net. See details »


Adjustments to Reported Income

Illumina Inc., adjusted net income attributable to Illumina stockholders

US$ in millions

Microsoft Excel LibreOffice Calc
12 months ended Dec 29, 2019 Dec 30, 2018 Dec 31, 2017 Jan 1, 2017 Jan 3, 2016
As Reported
Net income attributable to Illumina stockholders
Adjustments
Add: Deferred income tax expense (benefit)1
Add: Increase (decrease) in allowance for doubtful accounts
Add: Increase (decrease) in reserve for product warranties
Add: Other consolidated comprehensive income (loss)
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest
After Adjustment
Adjusted consolidated net income

Based on: 10-K (filing date: 2020-02-11), 10-K (filing date: 2019-02-12), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-14), 10-K (filing date: 2016-03-02).

1 Deferred income tax expense (benefit). See details »