What’s TSMC DCF intrinsic value?How to calculate it quickly with a free tool?

TSMC DCF

TSMC discussion in my books

I have discussed the company Nvidia (ticker:NVDA) in two recent books; including:

In my book “The Rules of Super Growth Stocks Investing“:

  • Sections 2-4, the entire section is dedicated to introducing the company TSMC
  • Section 3-3, analyze the business development of technology companies to grasp the pulse of key industries

In my book “The Rules of 10 Baggers“:

  • Section 3-2, the entire section is dedicated to introducing TSMC and the global semiconductor supply chain.

The goal of this article

I know that most people hate mathematical formulas, hate complicated calculations, don’t want to read the theory, and don’t want to understand the reasons. Therefore, we will use the simplest method to calculate the intrinsic value of TSMC’s Discounted Cash Flow (DCF) – just fill in a few necessary numbers (these numbers are available on famous financial websites). The same method can be applied repeatedly to estimate the DCF intrinsic value of any stock you are interested in.

Again, because most investors don’t want to read long articles or figure out complex calculations, the estimates and algorithms in this article are simplified numbers for readers to quickly understand. If you want to learn more about the calculation of the intrinsic value of the discounted cash flow method (DCF) and a more accurate algorithm, you can refer to the detailed instructions on pages 330~337 of my book “The Rules of Super Growth Stocks Investing“, as well as the detailed instructions in the book Step-by-step calculation explanation of practical examples.

Tool used

In order to allow investors to easily apply to the stocks they are interested in, to repeatedly calculate the TSMC DCF numers mentioned in this post, and to facilitate the explanations in my post, I will use a free online tool program developed and written by myself─── Discounted Cash Flow (DCF) Calculator.

For a detailed explanation and introduction to the Discounted Cash Flow (DCF) Calculator I developed and written, please see the introduction to my previous post “DCF (Discounted Cash Flow) Calculator“. If you want to know the details, assumptions, parameter settings, mathematical formulas, and related more detailed explanations of this Discounted Cash Flow (DCF) Calculator, please refer to page 330 to 337 of my book “The Rules of Super Growth Stocks Investing” for the detailed instructions, as well as step-by-step calculation explanations of practical examples mentioned in the book.

Fundamental numbers

Then use the discounted cash flow method to estimate, What’s TSMC DCF intrinsic value?

First, a formula review: Free Cash Flow = Operating Cash Flow – Capital Expenditures

The key numbers ​​used in discounted cash flow calculation are as follows:

  • In the past twelve months, TSMC’s unlevered free cash flow was US$2.9606 billion; leveraged free cash flow was US$2.7201 billion. We adopt the most optimistic estimate and take the unlevered free cash flow of US$2.9606 billion as free cash flow.
  • According to the speech of TSMC’s CEO at the TSMC shareholders’ meeting in July 2023: In the next five years, it is possible for revenue to maintain an annual growth rate of 15% to 20% by 2030. At the conference in January 2024, the CEO stated that TSMC will grow quarter by quarter in 2024, and its full-year US dollar revenue will grow by 24%-26% annually. We adopt the most optimistic estimate of 26%. Moreover, over the past 10 years, TSMC’s free cash flow has averaged an annual growth rate of 20.90%. Combining these two data, 26% is the most optimistic value.
  • Number of shares outstanding at the end of 2022: 5,185,840,000 shares.
  • Taiwan’s average GDP growth rate over the past ten years is 3.37%, which is regarded as the sustainable growth rate.
  • TSMC is a stable large enterprise. The average weighted average cost of capital (WACC) over the past ten years is 8.76%, and 8.76% is used as the discount rate.

Note: This calculation was completed in themiddle of Febuary 2024.

Number for DCF calculator

For detailed instructions on filling in the values ​​in each field, please see the introduction to my previous post “DCF (Discounted Cash Flow) Calculator“. For a more detailed explanation, please see the detailed explanations on pages 330~337 of my book “”The Rules of Super Growth Stocks Investing“, as well as the step-by-step calculation of practical examples.

Calculation results

Calculation Results from “DCF (Discounted Cash Flow) Calculator” is:

10th year perpetual value discounted to present value $572652.2 US Dollars
Discounted cash flows for all future ten years to present value $72600.3 US Dollars
ShareholdersEquity $645252.5 US Dollars
Intrinsic value per share $124.42 US Dollars

If you still have doubts, you can use the “DCF (Discounted Cash Flow) Calculator” formula designed on my website to calculate the intrinsic value of TSMC. It is only US$124.42–most of TSMC’s Shareholders must be fascinated by such a result (not surprising, because it is human nature). Of course, the discounted cash flow method is just a valuation method, and it is not necessarily correct. Otherwise, how could the current stock price of TSMC be US$100?

Why DCF result is different from market price?

However, as most professional investors on Wall Street, even Buffett agree that the discounted cash flow method is the most scientific and closest to the intrinsic value of most listed companies. The discounted cash flow method is still representative.

Note: I would like to reiterate again: The discounted cash flow method is only one of many stock valuation methods. There are many factors that affect the stock price, and the stock price of individual stocks will change dynamically with the market and various factors, and will not be a fixed value. Investors should also be reminded not to use only one valuation model for valuation.

Why is TSMC’s valuation lower?

So why does TSMC’s stock price calculated using the discounted cash flow method be US$124.42? The main reason is that TSMC’s free cash flow is too low. Of course there are other factors, and I will write another article next week to put forward my own opinions.

I understand that investors, especially those holding TSMC’s Taiwanese stocks and US stocks, have long complained that TSMC’s valuation is low. What are the possible reasons? Interested investors can refer to my analysis in my post “Why is TSMC valuation much lower than U.S. peers?”.

Table for stock investment toolset

Here is a list of these must-have tools for investors:

The online tool I developURL for the tool
For detailed function description, please click the description article directly
Annualized rate of return and compound interest
IRR calculatorIRR calculatorIRR calculator
Simple and compound interest calculatorSimple and compound interest calculator Simple and compound interest calculator
Famous market index
Taiwan stock exchangeQuerier to Annualized rate of return for Taiwan Stock Exchange Querier to Annualized rate of return for Taiwan Stock Exchange
Dow Jones Industrial Average (DJIA) IndexQuerier to Annualized rate of return for Dow Jones Industrial Average Index Querier to Annualized rate of return for Dow Jones Industrial Average (DJIA) Index
S&P 500Querier to Annualized rate of return for S&P 500 Index Querier to Annualized rate of return for S&P 500 Index
NasdaqQuerier to Annualized rate of return for Nasdaq Index Querier to Annualized rate of return for Nasdaq Index
Philadelphia Semiconductor Index Querier to Annualized rate of return for Philadelphia Semiconductor Index Querier to Annualized rate of return for Philadelphia Semiconductor Index (SOX)
Important ecnomic data query
US historial GDP querierUS GDP querier US Gross domestic product (GDP) querier
Querier of US Inflation RateQuerier of US Inflation Rate Querier of US Inflation Rate
Valuation
DCF (Discounted Cash Flow) CalculatorDCF (Discounted Cash Flow) Calculator DCF (Discounted Cash Flow) Calculator
S&P 500 historical PE Ratio and average QuerierS&P 500 historical PE Ratio and average Querier S&P 500 P/E ratio has been rising in the past century, S&P 500 PE Ratio and Average Querier
Data share
Data and sample downloadSample and file downloadSample and file download

I am the author of the original text, the essence of this article was originally published in Smart Magzine, Issue of March 2004

Related articles

Disclaimer

  • The content of this site is the author’s personal opinions and is for reference only. I am not responsible for the correctness, opinions, and immediacy of the content and information of the article. Readers must make their own judgments.
  • I shall not be liable for any damages or other legal liabilities for the direct or indirect losses caused by the readers’ direct or indirect reliance on and reference to the information on this site, or all the responsibilities arising therefrom, as a result of any investment behavior.

Leave a Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!