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

122.87
 
USD
  
-1.59
  
(-1.28%)
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    
89.00   
   217.60
Peers   
PKI / 
PACB / 
A / 
TMO / 
DHR / 
FLDM / 
Last updated: Thursday 25th April 2024
41
MarketXLS Rank
60
Value
15
Technical
50
Quality

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

Financials

ILMN Cash Flow

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in inventories-37 M-81 M-30 M-33 M-53 M25 M-12 M-58 M-135 M-20 M
(Increase) Decrease in other current assets64 M79 M87 M76 M-27 M11 M84 M-76 M-23 M-33 M
(Increase) Decrease in other current liabilities2 M5 M16 M160 M-4 M-33 M27 M
(Increase) Decrease in other working capital-109 M-11 M-453 M-117 M-14 M4 M
(Increase) Decrease in payables-2 M46 M-2 M10 M45 M-35 M40 M60 M-38 M-44 M
(Increase) Decrease in receivables-50 M-96 M3 M-26 M-105 M-58 M89 M-164 M-12 M-40 M
Acquisitions-3 M-37 M-18 M-100 M-98 M-2,444 M-85 M-29 M
Amortization of intangibles51 M54 M51 M46 M39 M37 M31 M75 M179 M197 M
AssetImpairmentCharge-2 M23 M3,914 M827 M
CapitalExpenditureReported142 M143 M271 M312 M296 M209 M189 M208 M466 M196 M
Cash at beginning of period712 M636 M769 M735 M1,225 M1,144 M2,042 M1,810 M1,232 M2,011 M
Cash at end of period636 M769 M735 M1,225 M1,144 M2,042 M1,810 M1,232 M2,011 M1,048 M
Cash flow507 M666 M779 M875 M1,142 M1,051 M1,080 M541 M597 M502 M
CashFlowFromContinuingInvestingActivities-412 M-112 M-515 M-214 M-1,813 M745 M-554 M-1,065 M-796 M-255 M
ChangeInAccountPayable-2 M46 M-2 M10 M45 M-35 M40 M60 M-38 M-44 M
ChangeInAccruedExpense84 M99 M-24 M81 M103 M-44 M-7 M101 M381 M15 M
ChangeInInterestPayable84 M99 M-24 M81 M103 M-44 M-7 M
ChangeInPayablesAndAccruedExpense82 M145 M-26 M91 M148 M-79 M33 M161 M343 M-29 M
ChangeInPrepaidAssets7 M-11 M-1000000.08 M5 M-14 M-20 M-64 M16 M11 M
ChangeInWorkingCapital-42 M42 M38 M-177 M-36 M-232 M201 M-215 M189 M-107 M
ChangesInAccountReceivables-50 M-96 M3 M-26 M-105 M-58 M89 M-164 M-12 M-40 M
CommonStockPayments-237 M-274 M-249 M-251 M-201 M-324 M-736 M
Current deferred income taxes100 M
Deferred income taxes100 M
Depreciation62 M73 M90 M110 M140 M151 M156 M176 M215 M235 M
Depreciation unreconciled151 M165 M171 M186 M220 M234 M227 M283 M394 M432 M
DepreciationAndAmortization151 M165 M171 M186 M220 M234 M227 M283 M394 M432 M
Effect of exchange rate changes-3 M-2 M-2 M5 M-4 M-1000000.08 M-3 M-22 M
ExcessTaxBenefitFromStockBasedCompensation-126 M-127 M-91 M
FinancingCashFlow-167 M-419 M-296 M-176 M594 M-897 M-766 M-51 M1,000 M-1,210 M
Free cash flow364 M522 M508 M563 M846 M842 M891 M337 M-74 M282 M
GainLossOnInvestmentSecurities-4 M-16 M-21 M8 M-154 M-899 M
IncomeTaxPaidSupplementalData18 M17 M60 M149 M99 M164 M119 M233 M122 M65 M
InterestPaidSupplementalData17 M73 M
Issuance of capital stock96 M72 M47 M71 M46 M59 M61 M60 M63 M67 M
Issuance of debt-1,245 M
IssuanceOfCapitalStock96 M72 M47 M71 M46 M59 M61 M60 M63 M67 M
IssuanceOfDebt-142 M-245 M-61 M-4 M731 M-550 M471 M991 M-1,236 M
Net cash from financing activities-167 M-419 M-296 M-176 M594 M-897 M-766 M-51 M1,000 M-1,210 M
Net cash from investing activities-412 M-112 M-515 M-214 M-1,813 M745 M-554 M-1,069 M-591 M-231 M
Net cash from operating activities507 M666 M779 M875 M1,142 M1,051 M1,080 M545 M392 M478 M
Net change in cash & cash equivalents-75 M133 M-34 M490 M-81 M898 M-232 M-575 M801 M-963 M
Net income from continuing operations353 M457 M428 M678 M782 M990 M656 M762 M-4,404 M-1,161 M
NetBusinessPurchaseAndSale-3 M-37 M-18 M226 M-100 M-14 M-98 M-2,440 M-290 M-53 M
NetCommonStockIssuance-141 M-202 M-202 M-180 M-155 M-265 M-675 M60 M63 M67 M
NetForeignCurrencyExchangeGainLoss1000000.022 M
NetIntangiblesPurchaseAndSale-36 M-400000.0-11 M-2 M-180 M-1000000.0
NetInvestmentPropertiesPurchaseAndSale-266 M68 M-226 M-128 M-1,417 M968 M-267 M1,583 M-40 M-6 M
NetInvestmentPurchaseAndSale-266 M68 M-226 M-128 M-1,417 M968 M-267 M1,583 M-40 M-6 M
NetIssuancePaymentsOfDebt-142 M-245 M-61 M-4 M731 M-550 M471 M991 M-1,236 M
NetLongTermDebtIssuance1,102 M-245 M-61 M-4 M731 M-550 M471 M991 M-1,236 M
NetPPEPurchaseAndSale-106 M-143 M-260 M-310 M-296 M-209 M-189 M-208 M-286 M-195 M
Operating (gains) losses27 M-12 M113000.0-21 M8 M-154 M-899 M1000000.022 M
Other financing charges net116 M29 M-40 M8 M18 M-82 M-91 M-582 M-54 M-41 M
Other investing changes net-17 M-12 M-14 M-29 M-15 M-20 M-256 M246 M-40 M-6 M
Other non-cash items18 M13 M142 M188 M197 M51 M-4 M610 M4,417 M1,316 M
ProceedsFromStockOptionExercised7 M
Purchase of Float term investments-791 M-797 M-895 M-742 M-2,859 M-1,010 M-1,802 M-77 M
Purchase of property plant & equipment-142 M-143 M-271 M-312 M-296 M-209 M-189 M-208 M-466 M-196 M
Purchase of short term investments1,132 M5 M5 M735 M988 M991 M
PurchaseOfIntangibles-36 M-400000.0-11 M-2 M-180 M-1000000.0
PurchaseOfInvestment-791 M-797 M-895 M-742 M-2,859 M-1,028 M-1,802 M-25 M
PurchaseOfLongTermInvestments-18 M52 M
PurchaseOfPPE-106 M-143 M-260 M-310 M-296 M-209 M-189 M-208 M-286 M-195 M
Repayment of debt-30 M-245 M-66 M-9 M-4 M-550 M-517 M-1,236 M
RepaymentOfDebt-1,275 M-245 M-66 M-9 M-4 M-550 M-517 M-1,236 M
Repurchase of capital stock-237 M-274 M-249 M-251 M-201 M-324 M-736 M
Revenue per share89 M92 M81 M76 M80 M83 M71 M107 M179 M197 M
Sale of short term investments542 M877 M683 M643 M1,457 M2,016 M1,791 M1,362 M
SaleOfBusiness226 M-14 M4 M-205 M-24 M
SaleOfInvestment542 M877 M683 M643 M1,457 M2,016 M1,791 M1,362 M
ShortTermDebtPayments-1,245 M
StockBasedCompensation153 M133 M129 M164 M193 M194 M194 M754 M366 M380 M
UnrealizedGainLossOnInvestmentSecurities-53 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

StockKevin.com

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.

Dave

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