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 Income Statement

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
AcquiredInProcessRnD255 M-5,411 M354,027 M24 M
AcquiredInProcessRnDIncome344,998 M14,562 M2,890 M
AllowancesForConstruction1,510 M2,082 M
Basic EPS from continuing operations0.240.310.360.390.450.460.460.70.821.25
Basic EPS total0.240.310.360.3913.314.013.6519.70.821.25
Basic weighted shares outstanding25,698 M25,960 M25,656 M26,252 M25,930 M25,930 M25,930 M74,461 M25,706 M25,929 M
Cost of sales10,582 M12,186 M13,208 M14,602 M-482,616 M-533,487 M-577,283 M-628,125 M27,681 M29,793 M
Depreciation-255,796 M-288,125 M-281,412 M
Depreciation unreconciled21 M
DepreciationAndAmortization-260,143 M-292,546 M21 M
Diluted EPS total0.240.310.360.3913.314.013.6519.70.821.25
Diluted normalized net income/share0.240.310.360.390.450.460.460.70.821.25
Diluted weighted shares outstanding25,698 M25,960 M25,656 M26,252 M73,533 M79,214 M76,076 M74,461 M25,706 M25,929 M
Dividends paid per share0.10.10.10.27.00.30.30.4
Earnings from equity interest128 M124 M128 M107 M2,994 M3,091 M2,861 M3,562 M199 M250 M
EarningsFromEquityInterestNetOfTax128 M124 M128 M107 M2,994 M3,091 M2,861 M3,562 M199 M250 M
GainOnSaleOfBusiness8,496 M8,980 M6,254 M510,744 M
GainOnSaleOfPPE-1,098 M371,914 M-38 M-283 M-266 M-33 M
GainOnSaleOfSecurity316,182 M93 M
GeneralAndAdministrativeExpense633 M599 M526 M611 M21,200 M20,266 M21,737 M28,458 M1,331 M1,742 M
Gross operating profit9,432 M11,953 M12,516 M14,655 M494,826 M497,874 M492,702 M711,130 M29,544 M43,878 M
ImpairmentOfCapitalAssets-30 M
Income before tax7,240 M9,559 M10,689 M11,911 M396,162 M397,543 M389,862 M584,746 M23,902 M37,230 M
Income taxes1,077 M1,516 M1,453 M1,671 M51,123 M34,437 M35,835 M73,738 M2,529 M4,907 M
InsuranceAndClaims4 M
Interest income9,610 M14,853 M421 M661 M206 M730 M
InterestExpenseNonOperating89 M102 M97 M102 M-2,564 M-1,634 M-1,140 M74 M195 M382 M
InterestIncomeOperating-496 M-12 M
MarketingExpense151 M161 M173 M182 M3,330 M196 M212 M253 M272 M323 M
MinorityInterests4 M4 M600000.0-3 M41 M54 M79 M264 M-19 M-12 M
MiscOtherSpecialCharges151 M76 M764 M206 M54,897 M-14 M16,189 M-29,137 M23 M19 M
Net income from total operations6,168 M8,048 M9,236 M10,238 M977,983 M1,108,993 M1,038,434 M1,466,879 M21,354 M32,311 M
NetIncomeCommonStockholders6,168 M8,048 M9,236 M10,238 M977,983 M1,108,993 M1,038,434 M1,466,879 M21,354 M32,311 M
NetIncomeContinuousOperations6,163 M8,044 M9,236 M10,241 M977,983 M1,108,993 M1,038,434 M1,466,879 M21,373 M32,323 M
NetNonOperatingInterestIncomeExpense-89 M-102 M-97 M-102 M9,392 M378,003 M421 M661 M11 M347 M
NonRecurringOperationExpense-31 M
Operating income7,041 M9,395 M9,818 M11,665 M386,408 M379,375 M713,897 M1,057,025 M23,443 M36,500 M
Operating income before depreciation (EBITDA)653,741 M688,456 M675,606 M
OperatingExpense2,392 M2,559 M2,698 M2,991 M108,418 M118,611 M120,677 M134,527 M6,100 M7,377 M
Other income net-278 M-200 M-892 M-313 M-634,305 M-389,842 M-6,909 M-485,958 M45 M-236 M
OtherCostofRevenue10,582 M12,186 M13,208 M14,602 M16,283 M17,432 M19,301 M22,369 M27,681 M29,793 M
OtherGandA633 M599 M526 M611 M21,200 M20,266 M21,737 M28,458 M1,331 M1,742 M
OtherImpairmentOfCapitalAssets-13 M
OtherOperatingExpenses-2,817 M3,411 M1,151 M-10,106 M
OtherTaxes3,051 M
OtherunderPreferredStockDividend-8.0-8.0-2.0
PreferredStockDividends-8.0-8.0-2.0
RealizedCapitalGain-28,359 M-18 M
RentAndLandingFees21,197 M20,266 M21,737 M28,458 M
Research & development expense1,608 M1,798 M1,999 M2,198 M80,733 M85,896 M91,419 M109,063 M4,497 M5,313 M
ResearchExpense1,608 M1,798 M1,999 M2,198 M80,733 M85,896 M91,419 M109,063 M4,497 M5,313 M
Revenue per share-4,347 M-4,421 M21 M
SalariesAndWages-104,130 M
Selling Gen & administrative expense784 M760 M699 M793 M30,503 M26,254 M28,086 M35,570 M1,604 M2,065 M
SellingAndMarketingExpense151 M161 M173 M182 M9,303 M5,988 M6,349 M7,113 M272 M323 M
SellingExpense5,973 M5,988 M6,349 M7,113 M
Special income/charges285 M-5,411 M350,776 M24 M
Total Income available for interest expense (EBIT)393,598 M395,909 M388,722 M
Total common shares outstanding25,930 M25,930 M25,930 M25,930 M
Total net income6,168 M8,048 M9,236 M10,238 M977,983 M1,108,993 M1,038,434 M1,466,879 M21,354 M32,311 M
Total ordinary shares5,186 M5,186 M5,186 M5,186 M5,186 M5,186 M5,186 M5,186 M5,186 M5,186 M
Total revenues20,014 M24,139 M25,724 M29,257 M977,447 M1,031,474 M1,411,861 M1,819,677 M57,225 M73,670 M
TotalExpenses12,974 M14,745 M15,906 M17,593 M-374,198 M-414,876 M-456,607 M-493,597 M33,782 M37,170 M
TotalRevenue20,014 M24,139 M25,724 M29,257 M977,447 M1,031,474 M1,069,985 M1,339,255 M57,225 M73,670 M
WriteDown-1,259 M1,983 M
WriteOff3,251 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