REAL COMPANIES. EXPLICIT ASSUMPTIONS. · 17 company models · One-time payment · 12 months of updates
TSM
Semiconductors

TSMC DCF model

Wafer shipments, revenue per wafer and other services.

TSMC original Income Statement worksheet excerpt showing business drivers, highlighted inputs and modeled years
TSMC · Actual workbook excerpt · Open full-size preview

Included worksheets

Income StatementBalance SheetCash FlowDCF Valuation

TSMC Excel edition

Wafer shipments, revenue per wafer and other services. Change the highlighted assumptions to explore the relationship between operating performance, cash flow and value.

This workbook uses New Taiwan dollars (TWD) and Taiwan-listed 2330 shares. It is not a USD valuation per ADR. The workbook notes one ADR represents five shares.

Inside the workbook

Edition detailIncluded
Valuation date2 October 2026
Historical periodsFY2023A, FY2024A, FY2025A
Modeled periodsFY2026E–FY2035E
Financial currencyTWD in millions
FormatEditable .xlsx · Four worksheets · 49.3 KB
PriceUS$19.99 for 12 months of company-model access

One company. One year of access.

Your US$19.99 one-time purchase includes 12 months of downloads and updates for this company’s model. No automatic renewal. Downloaded files remain usable after access ends; no fixed update cadence is promised.

Read the current version’s notes

TWD in millions, fiscal year ending December 31. Base case in New Taiwan dollars, valued against the Taiwan Stock Exchange listing (2330; one ADR = 5 shares). FY2026E follows reported 1H26 results, the 3Q26 outlook and the full-year outlook; FY2027E revenue lands on analyst consensus; later years are this model's own assumptions, each explained in the last column.

Dates and descriptions reflect this workbook’s notes. They are not a claim of independent audit or a guarantee that its forecasts will occur.

Purchasing and access details · Ask about this edition