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

Metrics

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

TSM Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
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.310.360.390.450.460.460.70.821.251.25
Basic EPS total0.310.360.3913.314.013.6519.70.821.251.25
Basic weighted shares outstanding25,960 M25,656 M26,252 M25,930 M25,930 M25,930 M74,461 M25,706 M25,929 M680,822 M
Cost of sales12,186 M13,208 M14,602 M-482,616 M-533,487 M-577,283 M-628,125 M27,681 M29,793 M986,625 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.310.360.3913.314.013.6519.70.821.251.25
Diluted normalized net income/share0.310.360.390.450.460.460.70.821.251.25
Diluted weighted shares outstanding25,960 M25,656 M26,252 M73,533 M79,214 M76,076 M74,461 M25,706 M25,929 M680,822 M
Dividends paid per share0.10.10.27.00.30.30.4
Earnings from equity interest124 M128 M107 M2,994 M3,091 M2,861 M3,562 M199 M250 M4,800 M
EarningsFromEquityInterestNetOfTax124 M128 M107 M2,994 M3,091 M2,861 M3,562 M199 M250 M4,800 M
GainOnSaleOfBusiness8,496 M8,980 M6,254 M510,744 M
GainOnSaleOfPPE-1,098 M371,914 M-38 M-283 M-266 M-33 M6,962 M
GainOnSaleOfSecurity316,182 M93 M
GeneralAndAdministrativeExpense599 M526 M611 M21,200 M20,266 M21,737 M28,458 M1,331 M1,742 M60,873 M
Gross operating profit11,953 M12,516 M14,655 M494,826 M497,874 M492,702 M711,130 M29,544 M43,878 M1,175,111 M
ImpairmentOfCapitalAssets-30 M
Income before tax9,559 M10,689 M11,911 M396,162 M397,543 M389,862 M584,746 M23,902 M37,230 M979,317 M
Income taxes1,516 M1,453 M1,671 M51,123 M34,437 M35,835 M73,738 M2,529 M4,907 M128,289 M
InsuranceAndClaims4 M
Interest income9,610 M14,853 M421 M661 M206 M730 M60,294 M
InterestExpenseNonOperating102 M97 M102 M-2,564 M-1,634 M-1,140 M74 M195 M382 M11,999 M
InterestIncomeOperating-496 M-12 M
MarketingExpense161 M173 M182 M3,330 M196 M212 M253 M272 M323 M10,591 M
MinorityInterests4 M600000.0-3 M41 M54 M79 M264 M-19 M-12 M
MiscOtherSpecialCharges76 M764 M206 M54,897 M-14 M16,189 M-29,137 M23 M19 M669 M
Net income from total operations8,048 M9,236 M10,238 M977,983 M1,108,993 M1,038,434 M1,466,879 M21,354 M32,311 M851,028 M
NetIncomeCommonStockholders8,048 M9,236 M10,238 M977,983 M1,108,993 M1,038,434 M1,466,879 M21,354 M32,311 M851,028 M
NetIncomeContinuousOperations8,044 M9,236 M10,241 M977,983 M1,108,993 M1,038,434 M1,466,879 M21,373 M32,323 M851,028 M
NetNonOperatingInterestIncomeExpense-102 M-97 M-102 M9,392 M378,003 M421 M661 M11 M347 M48,295 M
NonRecurringOperationExpense-31 M
Normalized income27,397 M712,836 M
Operating income9,395 M9,818 M11,665 M386,408 M379,375 M713,897 M1,057,025 M23,443 M36,500 M921,277 M
Operating income before depreciation (EBITDA)653,741 M688,456 M675,606 M51,841 M1,008,696 M
OperatingExpense2,559 M2,698 M2,991 M108,418 M118,611 M120,677 M134,527 M6,100 M7,377 M253,834 M
Other income net-200 M-892 M-313 M-634,305 M-389,842 M-6,909 M-485,958 M45 M-236 M-12,430 M
OtherCostofRevenue12,186 M13,208 M14,602 M16,283 M17,432 M19,301 M22,369 M27,681 M29,793 M986,625 M
OtherGandA599 M526 M611 M21,200 M20,266 M21,737 M28,458 M1,331 M1,742 M60,873 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,798 M1,999 M2,198 M80,733 M85,896 M91,419 M109,063 M4,497 M5,313 M182,370 M
ResearchExpense1,798 M1,999 M2,198 M80,733 M85,896 M91,419 M109,063 M4,497 M5,313 M182,370 M
Revenue per share-4,347 M-4,421 M21 M
SalariesAndWages-104,130 M
Selling Gen & administrative expense760 M699 M793 M30,503 M26,254 M28,086 M35,570 M1,604 M2,065 M71,464 M
SellingAndMarketingExpense161 M173 M182 M9,303 M5,988 M6,349 M7,113 M272 M323 M10,591 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 M37,612 M991,316 M
Total common shares outstanding25,930 M25,930 M25,930 M25,930 M
Total net income8,048 M9,236 M10,238 M977,983 M1,108,993 M1,038,434 M1,466,879 M21,354 M32,311 M851,028 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 revenues24,139 M25,724 M29,257 M977,447 M1,031,474 M1,411,861 M1,819,677 M57,225 M73,670 M2,161,736 M
TotalExpenses14,745 M15,906 M17,593 M-374,198 M-414,876 M-456,607 M-493,597 M33,782 M37,170 M1,240,459 M
TotalRevenue24,139 M25,724 M29,257 M977,447 M1,031,474 M1,069,985 M1,339,255 M57,225 M73,670 M2,161,736 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