← All financial models

Taiwan Semiconductor Manufacturing (TSM) Financial Model

📊 Download Model

Three-statement Excel model · 23 quarters and 5 fiscal years of history · 6 quarters and 5 fiscal years of projections

current ✓ C13 recon ✓ C14 trace ✓ C15 terminals

About the TSM model

This three-statement Excel model covers Taiwan Semiconductor Manufacturing Company Limited (TSM): its income statement, balance sheet and cash flow statement. It holds 23 quarters and 5 fiscal years of history and 6 quarters and 5 fiscal years of projections.

Projected revenue is built from KPI drivers: QoQ growth x platform (HPC / Smartphone / IoT / Automotive / DCE / Others); NT$ currency of record, across 6 segments.

Beyond the income statement, the workbook has these sections: KPI Drivers, Balance Sheet and Cash Flow Statement.

Model thesis: AI-foundry monopoly: FY26E +43.9% US$ on HPC, at the guided "around 44%"; GM glides 66% to 60% by FY30E on N2 and overseas-fab dilution

On November 11, 2026, the model passed checks C13 (every subtotal reconciles to the reported figure at $0), C14 (every projected revenue cell traces to a KPI driver row) and C15 (each driver ends in a rate, a count or a historical anchor, never a typed-in projected dollar level). It was last updated November 11, 2026.

History
23 quarters and 5 fiscal years
Projections
6 quarters and 5 fiscal years
KPI
QoQ growth x platform (HPC / Smartphone / IoT / Automotive / DCE / Others); NT$ currency of record
Segments
6
Units
NT$ in billions, except per share (EPS in NT$)
Verified
Updated
File
Excel workbook (.xlsx), 130 KB
Access
Free account required: 3 different models a month at no charge, then $9 a month.

Income statement preview

Columns FY2023–FY2025 are actual results and FY2026E–FY2028E are our estimates. Figures were recalculated in Excel on November 11, 2026. NT$ in billions, except per share (EPS in NT$).

Income statement preview for TSM. NT$ in billions, except per share (EPS in NT$). Actual fiscal years followed by our estimates.
Income Statement
ActualEstimate
FY2023FY2024FY2025FY2026EFY2027EFY2028E
High Performance Computing Revenue929.51,476.12,209.23,725.05,299.26,888.9
Smartphone Revenue821.51,013.01,104.61,233.31,256.61,306.8
Internet of Things Revenue172.9173.7190.5254.1253.8279.2
Automotive Revenue129.7144.7190.5218.1260.1286.1
Digital Consumer Electronics Revenue43.228.938.154.258.559.7
Others Revenue64.957.976.2109.4125.3131.6
Net RevenueNT$2,161.7NT$2,894.3NT$3,809.1NT$5,594.1NT$7,253.4NT$8,952.3
Less: Cost of Revenue(NT$986.6)(NT$1,270.0)(NT$1,527.8)(NT$1,871.2)(NT$2,590.0)(NT$3,401.9)
Gross ProfitNT$1,175.1NT$1,624.4NT$2,281.3NT$3,722.9NT$4,663.4NT$5,550.4
Less: Research and Development Expenses(NT$182.4)(NT$204.2)(NT$246.4)(NT$330.8)(NT$438.3)(NT$555.0)
Less: Sales, General and Administrative Expenses(71.5)(96.9)(99.2)(110.7)(139.5)(170.1)
Total Operating Expenses(NT$253.8)(NT$301.1)(NT$345.6)(NT$441.5)(NT$577.7)(NT$725.1)
Other Operating Income and Expenses, NetNT$0.2(NT$1.2)NT$0.4NT$7.5NT$0.0NT$0.0
Income from OperationsNT$921.5NT$1,322.1NT$1,936.1NT$3,288.9NT$4,085.7NT$4,825.3
Share of Profits of AssociatesNT$4.7NT$4.9NT$5.5NT$4.6NT$0.0NT$0.0
Net Interest Income (Expenses)48.376.793.4120.4152.3170.1
Other Gains and Losses4.82.26.769.90.00.0
Total Non-operating Income and ExpensesNT$57.7NT$83.8NT$105.6NT$194.9NT$152.3NT$170.1
Income Before Income TaxNT$979.2NT$1,405.8NT$2,041.7NT$3,483.7NT$4,238.0NT$4,995.4
Less: Income Tax Expenses(NT$141.4)(NT$233.4)(NT$326.3)(NT$592.2)(NT$720.5)(NT$849.2)
Net IncomeNT$837.8NT$1,172.4NT$1,715.4NT$2,891.6NT$3,517.6NT$4,146.2
Less: Net Income Attributable to Noncontrolling Interests(NT$0.7)(NT$0.8)(NT$2.5)NT$0.8NT$0.0NT$0.0
Net Income Attributable to Shareholders of the ParentNT$838.5NT$1,173.3NT$1,717.9NT$2,890.8NT$3,517.6NT$4,146.2
Ratios & Assumptions
YoY Net Revenue Growth(4.5%)33.9%31.6%46.9%29.7%23.4%
YoY HPC Revenue Growth0.1%58.8%49.7%68.6%42.3%30.0%
YoY Smartphone Revenue Growth(7.0%)23.3%9.0%11.6%1.9%4.0%

The full workbook adds 23 historical and 6 projected quarters, plus KPI Drivers · Balance Sheet · Cash Flow Statement — every subtotal a live formula, every projection traced to a driver.

Download the full TSM model (xlsx)3 free models a month with an account, then $9 a month

Taiwan Semiconductor Manufacturing research

Aardvark Labs Capital Research has published 8 reports on Taiwan Semiconductor Manufacturing (TSM). The latest is the Q3 2026 Earnings Recap, published October 18, 2026, rated Outperform.

FY26 Goes to 44% and Q4 Lands 6% Above the Street; the Stock Fell With the AI Tape, Not the Quarter — Maintain Outperform

All TSM research →

Methodology

Every projected revenue cell traces to a KPI/driver row (C14). Terminal driver cells are rates, counts, or historical anchors — never typed-in projected dollar levels (C15). Every subtotal-vs-reported reconciliation row ties to $0 (C13). Each model is written per-ticker against its actual schema — no cloning, no level-input shortcuts.