TSMC Stock: I Should Have Sticked To My Model (Rating Upgrade) (NYSE:TSM)

TSMC North America headquarters in San Jose, California, USA

JHVEPhoto

Thesis

In my earlier article on Taiwan Semiconductor Manufacturing Company Limited (NYSE:TSM), I recommended a hold position, anticipating a potential downturn due to the less-than-ideal state of consumer confidence amidst the economic cycle. Because of that I rated the

TABLE OF ASSUMPTIONS
(Current data)
Assumptions Part 1
Equity Value 103,773.30
Debt Value 31,115.80
Cost of Debt 1.24%
Tax Rate 13.54%
10y Treasury 3.80%
Beta 1.06
Market Return 10.50%
Cost of Equity 10.90%
Assumptions Part 2
CapEx 34,603.00
Capex Margin 51.65%
Net Income 27,759.60
Interest 384.80
Tax 4,345.80
D&A 14,877.30
Ebitda 47,367.50
D&A Margin 22.21%
Interest Expense Margin 0.57%
Revenue 66,997.4

Revenue Net Income Plus Taxes Plus D&A Plus Interest
2023 $69,090.0 $26,572.80 $30,169.71 $45,511.68 $45,908.50
2024 $83,940.0 $31,659.00 $35,944.38 $51,286.35 $51,683.17
2025 $95,271.9 $33,928.95 $38,521.59 $59,677.46 $60,224.66
2026 $108,133.6 $36,361.66 $41,283.58 $65,295.50 $65,916.57
2027 $122,731.6 $38,968.79 $44,243.62 $71,497.15 $72,202.06
2028 $139,300.4 $41,762.85 $47,415.88 $78,348.64 $79,148.71
^Final EBITA^

Revenue Net Income Plus Taxes Plus D&A Plus Interest
2023 $69,090.0 $25,908.75 $29,415.77 $44,757.75 $45,154.57
2024 $74,216.5 $27,831.18 $31,598.42 $46,940.40 $47,337.22
2025 $79,723.3 $29,896.25 $33,943.02 $51,646.22 $52,104.11
2026 $85,638.8 $32,114.55 $36,461.59 $55,478.37 $55,970.23
2027 $91,993.2 $34,497.45 $39,167.04 $59,594.86 $60,123.22
2028 $98,819.1 $37,057.17 $42,073.24 $64,016.80 $64,584.37
^Final EBITA^

Be the first to comment

Leave a Reply

Your email address will not be published.


*