Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

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

TSM Cash Flow

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
(Increase) Decrease in inventories4 M-914 M-20 M567 M-25,229 M-29,370 M20,250 M-54,372 M-2,010 M-913 M
(Increase) Decrease in other current assets-10 M-106 M30 M2 M12 M-513 M-76 M-1,358 M-437 M-199 M
(Increase) Decrease in other current liabilities118 M267 M-114 M115 M45 M-60 M-215 M-785 M8,572 M4,733 M
(Increase) Decrease in other working capital-11 M-43 M5 M28 M96 M-44 M
(Increase) Decrease in payables70 M276 M-65 M291 M2,572 M4,541 M5,860 M405 M410 M665 M
(Increase) Decrease in receivables-479 M-1,365 M808 M-1,538 M1,062 M-13,271 M-18,120 M-8,083 M-1,884 M-1,075 M
Acquisitions-2 M
Amortization of intangibles4,347 M4,421 M5,472 M7,186 M
AssetImpairmentCharge12 M30 M80 M43 M424 M-301 M10 M10 M26 M
CapitalExpenditureReported9,733 M9,253 M7,984 M10,281 M436,893 M322,682 M469,752 M516,781 M30,578 M41,191 M
Cash at beginning of period4,808 M7,680 M10,934 M17,367 M541,254 M553,392 M577,815 M455,399 M23,799 M34,656 M
Cash at end of period8,136 M11,346 M17,160 M16,705 M154,598 M180,272 M62,121 M74,355 M38,392 M43,697 M
Cash flow11,646 M13,339 M16,160 M16,662 M189,302 M176,570 M257,498 M206,986 M40,092 M52,411 M
CashFlowFromContinuingInvestingActivities-9,422 M-8,937 M-6,625 M-12,205 M-338,942 M-314,427 M-462,635 M-507,489 M-30,150 M-38,755 M
ChangeInAccountPayable12 M210 M-82 M225 M2,572 M4,541 M5,860 M405 M299 M247 M
ChangeInAccruedExpense31 M170 M87 M60 M18 M18 M-11 M429 M30 M821 M
ChangeInPayablesAndAccruedExpense101 M446 M23 M351 M2,572 M4,541 M5,860 M405 M440 M1,486 M
ChangeInWorkingCapital-266 M-1,672 M727 M-514 M-21,538 M-38,674 M7,699 M-64,194 M4,775 M3,987 M
ChangesInAccountReceivables1,062 M-13,271 M-18,120 M-8,083 M
CommonStockDividendPaid-2,607 M-2,462 M-3,558 M-4,802 M-181,513 M-207,443 M-259,304 M-259,304 M-9,581 M-9,282 M
Depreciation5,162 M6,255 M6,688 M6,793 M255,796 M288,125 M281,412 M324,538 M14,931 M13,944 M
Depreciation unreconciled5,236 M6,337 M6,786 M6,908 M260,143 M292,546 M286,884 M331,725 M15,227 M14,229 M
DepreciationAndAmortization5,236 M6,337 M6,786 M6,908 M260,143 M292,546 M286,884 M331,725 M15,227 M14,229 M
EarningsLossesFromEquityInvestments-128 M-124 M-128 M-107 M-3,015 M-3,091 M-2,861 M-3,562 M-199 M-250 M
Effect of exchange rate changes29 M287 M252 M-248 M-21,318 M9,862 M-9,114 M-23,498 M-273 M1,900 M
FinancingCashFlow1,076 M-1,023 M-3,560 M-4,870 M-215,698 M-245,125 M-269,638 M-88,615 M4,925 M-6,516 M
Free cash flow1,918 M4,093 M8,201 M6,431 M-247,265 M-145,931 M145,674 M306,492 M9,558 M11,482 M
GainLossOnInvestmentSecurities170 M-75 M-102 M4 M-90 M39 M-100000.0-74 M-16 M5 M
GainLossOnSaleOfBusiness-10 M4 M1 M-17 M5 M
GainLossOnSaleOfPPE-46 M-4 M-689 M-2 M1,098 M1,006 M950 M-189 M10 M-3 M
Issuance of capital stock341 M
Issuance of debt-658 M588 M96 M586 M10,394 M23,923 M1,063 M-1,125 M1,286 M-3,643 M
IssuanceOfCapitalStock341 M
IssuanceOfDebt3,718 M1,541 M96 M41 M-27,737 M-34,102 M-37,831 M203,919 M14,334 M2,676 M
Net cash from financing activities1,076 M-1,023 M-3,560 M-4,870 M-215,698 M-245,125 M-301,442 M-57,043 M4,925 M-6,516 M
Net cash from investing activities-9,422 M-8,937 M-6,625 M-12,205 M-338,942 M-314,427 M-458,802 M-505,782 M-30,150 M-38,755 M
Net cash from operating activities11,646 M13,339 M16,160 M16,662 M189,302 M176,570 M615,139 M822,666 M40,092 M52,411 M
Net change in cash & cash equivalents3,328 M3,666 M6,226 M-661 M-386,656 M-373,120 M-131,529 M181,273 M14,593 M9,041 M
Net income from continuing operations7,240 M9,559 M10,689 M11,911 M35,610 M-21,532 M3,527 M34,419 M23,902 M37,230 M
NetBusinessPurchaseAndSale17 M
NetCapitalExpenditureDisposals-9,727 M-9,247 M-7,959 M-10,230 M-11,232 M-10,536 M-15,582 M-18,344 M-30,534 M-40,929 M
NetCommonStockIssuance341 M
NetForeignCurrencyExchangeGainLoss11 M114 M78 M-82 M-9,119 M2,917 M26,576 M-32,944 M-581 M337 M
NetIntangiblesPurchaseAndSale-92 M-122 M-131 M-131 M-4,481 M-7,100 M-9,330 M-9,542 M-326 M400000.0
NetInvestmentPropertiesPurchaseAndSale110 M158 M78,171 M14,290 M16,429 M10,480 M9,149 M1,514 M
NetInvestmentPurchaseAndSale110 M158 M78,171 M14,290 M16,429 M10,480 M9,149 M1,514 M
NetIssuancePaymentsOfDebt3,718 M1,541 M96 M41 M-27,737 M-34,102 M-37,831 M203,919 M14,334 M2,676 M
NetLongTermDebtIssuance4,376 M954 M400000.0-545 M-38,131 M-58,025 M-37,831 M203,919 M13,048 M6,319 M
NetPPEPurchaseAndSale-9,635 M-9,125 M-7,829 M-10,099 M-432,086 M-315,400 M-460,135 M-506,632 M-30,208 M-40,930 M
Operating (gains) losses-3 M246 M-836 M-187 M-11,143 M832 M24,670 M-36,695 M-801 M93 M
Other financing charges net6 M-3 M-2 M-7 M-3 M-2 M-2 M300000.0-4 M501 M
Other investing changes net217 M77 M1,037 M-2,148 M8,632 M14,290 M16,429 M10,480 M-8,855 M562 M
Other non-cash items-104 M-200 M72 M54 M-4,015 M424 M-299 M30 M10 M37 M
Payment of cash dividends2,607 M2,462 M3,559 M4,802 M181,513 M207,443 M259,304 M259,304 M9,581 M9,282 M
ProceedsFromStockOptionExercised4 M2 M1000000.0-2,965 M-346 M-711 M122 M
Purchase of Float term investments2,830 M7,705 M9,506 M9,178 M1,459 M
Purchase of property plant & equipment-436,567 M-322,501 M-469,465 M-516,174 M
Purchase of short term investments4,411 M954 M23 M196 M32 M55 M2 M238,726 M13,215 M6,549 M
PurchaseOfIntangibles-92 M-122 M-131 M-131 M-4,481 M-7,100 M-9,330 M-9,542 M-326 M400000.0
PurchaseOfInvestment110 M158 M2,830 M7,705 M9,339 M9,135 M1,459 M
PurchaseOfLongTermInvestments110 M158 M-167 M-43 M
PurchaseOfPPE-9,641 M-9,131 M-7,853 M-10,150 M-432,412 M-315,582 M-460,422 M-507,239 M-30,252 M-41,191 M
Repayment of debt-34 M-200000.0-23 M-741 M-38,131 M-58,025 M-37,831 M-34,806 M-167 M-230 M
RepaymentOfDebt-34 M-200000.0-23 M-741 M-38,131 M-58,025 M-37,831 M-34,806 M-167 M-230 M
Revenue per share74 M83 M98 M116 M4,347 M4,421 M5,472 M7,186 M296 M285 M
Sale of Float term investments69,539 M12 M-15 M-9 M14 M55 M
Sale of short term investments100000.0
SaleOfBusiness18 M
SaleOfInvestment69,539 M12 M-15 M-9 M14 M55 M
SaleOfPPE6 M6 M25 M50 M326 M182 M287 M607 M44 M261 M
ShortTermDebtIssuance-658 M588 M96 M586 M10,394 M23,923 M1,063 M-858 M1,286 M-3,643 M
ShortTermDebtPayments-267 M
StockBasedCompensation200000.03 M7 M300000.010 M
UnrealizedGainLossOnInvestmentSecurities700000.0-900000.0-500000.0900000.0200000.04 M-100000.0600000.0
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.

We respect your privacy and will never share your email.
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