Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Illumina Inc. logo

Illumina Inc.

Sector: Healthcare   

Industry: Diagnostics & Research

Optionable: Yes  Market Cap: 19,777 M  90-day average vol: 1,666,142

Previous close: 124.46  Open: 123.09  Bid: 123.22  Ask: 126.0
52 week range    
PKI / 
A / 
TMO / 
DHR / 
Last updated: Thursday 25th April 2024
MarketXLS Rank

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord



StockDividendMarket Cap (B)PEPrice ($)


0.00643 B35.5140.37


0.018817 B8.1132.21


0.0029205 B33.2285.15


0 B-3.63.46


3 B-93.211.01


0.001522 B17.1182.49


0.0017234 B27587.05

ILMN Income Statement

AcquisitionExpense34 M
Amortization of intangibles824 M7,113 M3,285 M2,993 M
Basic EPS from continuing operations6.815.07-28.0-7.34
Basic EPS total2.613.193.094.965.636.814.485.07-28.0-7.34
Basic weighted shares outstanding136 M145 M147 M146 M147 M147 M147 M150 M157 M158 M
Cost of sales564 M670 M732 M679 M1,033 M1,076 M2,016 M1,372 M1,612 M1,760 M
Depreciation-141 M-156 M-179 M188 M251 M394 M432 M
Depreciation unreconciled35 M28 M
DepreciationAndAmortization-141 M-156 M35 M188 M28 M251 M394 M432 M
Diluted EPS total2.373.13.074.925.566.744.455.04-28.0-7.34
Diluted normalized net income/share6.745.04-28.0-7.34
Diluted weighted shares outstanding149 M149 M148 M148 M149 M149 M148 M151 M157 M158 M
Earnings from equity interest462 M
EarningsFromEquityInterestNetOfTax462 M
ExciseTaxes71 M
GainOnSaleOfBusiness54 M
GainOnSaleOfSecurity4 M16 M453 M21 M-8 M89 M
GeneralAndAdministrativeExpense-33 M-46 M-46 M-55 M835 M2,092 M1,297 M1,612 M
Gross operating profit1,298 M1,549 M1,666 M1,826 M2,300 M2,467 M1,223 M3,154 M2,972 M2,744 M
ImpairmentOfCapitalAssets2 M3,914 M827 M
Income before tax449 M583 M561 M1,043 M894 M1,118 M-152 M884 M-4,336 M-1,117 M
Income restructuring and M&A6 M-3 M1 M152 M
Income taxes95 M126 M133 M365 M112 M128 M200 M122 M68 M44 M
Interest income4 M5 M464 M744 M44 M75 M41 M11 M58 M
InterestExpenseNonOperating42 M42 M33 M37 M57 M52 M49 M61 M26 M77 M
InterestIncomeOperating826 M
LossAndLossAdjustmentExpectedIncurred191 M
MinorityInterests4 M35 M48 M44 M12 M762 M-4,404 M
MiscOtherSpecialCharges-33 M-8 M-3 M455 M24 M110 M284 M1,068 M-142 M-29 M
Net income from total operations353 M462 M463 M726 M826 M1,002 M-352 M762 M-4,404 M-1,161 M
NetIncomeCommonStockholders353 M923 M917 M1,451 M1,652 M1,002 M-352 M762 M-4,404 M-1,161 M
NetIncomeContinuousOperations353 M462 M463 M726 M826 M1,002 M-352 M762 M-4,404 M-1,161 M
NetNonOperatingInterestIncomeExpense-38 M424 M431 M707 M-13 M23 M-8 M-61 M-15 M-19 M
NonRecurringOperationExpense-109 M-11 M71 M619 M20 M
Normalized income863 M208 M
Operating income520 M610 M587 M606 M883 M985 M-428 M-123 M-4,179 M-1,069 M
Operating income before depreciation (EBITDA)641 M790 M765 M1,266 M1,171 M1,404 M124 M1,228 M-3,916 M-608 M
OperatingExpense777 M936 M1,079 M1,220 M1,417 M1,482 M1,651 M3,277 M7,151 M3,813 M
Other income net28 M-7 M3 M-455 M-850 M-110 M-284 M-1,068 M142 M29 M
OtherGandA-33 M-46 M-46 M-55 M835 M2,092 M1,297 M1,612 M
OtherImpairmentOfCapitalAssets-5 M115 M
OtherOperatingExpenses-77 M13 M-9 M-14 M-12 M-12 M-39 M-42 M-42 M
PromotionAndAdvertising-16 M-20 M-30 M-38 M28 M48 M53 M36 M
RealizedCapitalGain725 M826 M
RentAndLandingFees-33 M-46 M-46 M-55 M
Research & development expense388 M402 M504 M546 M623 M647 M682 M1,185 M1,321 M1,354 M
ResearchExpense388 M402 M504 M546 M623 M647 M682 M1,185 M1,321 M1,354 M
RestructringAndMnAIncome6 M-3 M1 M152 M
Revenue per share35 M824 M28 M7,113 M3,285 M2,993 M
SalariesAndWages-153 M-129 M-164 M-193 M-41 M-64 M-83 M-87 M
Selling Gen & administrative expense466 M525 M584 M674 M794 M835 M941 M2,092 M1,297 M1,612 M
SellingAndMarketingExpense466 M525 M584 M674 M794 M28 M941 M48 M53 M36 M
SellingExpense466 M525 M584 M674 M794 M941 M
Special income/charges-6 M3 M-1 M-34 M-71 M-4,533 M-847 M
Total Income available for interest expense (EBIT)490 M625 M594 M1,080 M951 M1,170 M-103 M945 M-4,310 M-1,040 M
Total common shares outstanding144 M147 M146 M147 M147 M147 M146 M157 M158 M159 M
Total net income353 M462 M463 M726 M826 M1,002 M-352 M762 M-4,404 M-1,161 M
Total ordinary shares159 M159 M159 M159 M159 M159 M159 M159 M159 M159 M
Total revenues1,861 M2,220 M2,398 M2,752 M3,333 M3,543 M3,239 M4,526 M4,584 M4,504 M
TotalExpenses1,341 M1,607 M1,811 M1,899 M2,450 M2,558 M3,667 M4,649 M8,763 M5,573 M
TotalRevenue1,861 M2,220 M2,398 M2,289 M2,749 M3,543 M3,239 M4,526 M4,584 M4,504 M
WriteDown34 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu


I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.


Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University