Mr.Cai

Mr.Cai

投资与个人知识管理
twitter

[Beginner's Guide] Deriving the Core Model of Stock Valuation from Scratch: The Discounted Free Cash Flow Model, with Tencent as an Example for Valuation

110-DSC01593.jpg

My Twitter:
https://twitter.com/onecellinglamp


Introduction#

The previous article elaborated on the entire value investment system from the perspective of buying stocks as buying companies. In the chapter on margin of safety, it mentioned that once you understand a company, you can estimate its value, which serves as the basis for considering the margin of safety before deciding whether to buy or sell stocks.

This article will serve as a supplement to the previous one, starting from scratch to establish the most basic and core model for estimating the intrinsic value of assets in the investment field: the Discounted Free Cash Flow Model, and will use Tencent's profits from 2022 for its valuation, finally explaining the applicable conditions of this model.

Let's get started.

Discounted Free Cash Flow Model#

What is the intrinsic value of a company? To put it simply, if you were to acquire a company, the amount you are willing to pay is its intrinsic value. Suppose there is a restaurant at the entrance of your community, with a net profit of 300,000 this year, and its earnings will increase by 8% each year. You are willing to pay 3 million to buy it; in your view, its intrinsic value is 3 million.

Intuition is often based on feelings, which can sometimes be unreliable. So, is there a reliable method to calculate a company's intrinsic value?

Yes.

In the words of Warren Buffett:

The value of stocks, bonds, or businesses depends on the sum of all future free cash flows discounted at an appropriate rate.

This statement fully explains the method for calculating a company's intrinsic value. However, for novice investors, to learn how to calculate it, one must first understand two concepts in this statement: Free Cash Flow and Discounting.

What is Cash Flow#

The restaurant at the entrance of the community received a total of 2,000 yuan in cash today (inflow), while the total expenses for raw materials, rent, employee salaries, etc., amounted to 1,000 yuan (outflow). Therefore, the cash flow for the restaurant today is 1,000 yuan.

For a company, the cash that flows into the company at a certain moment is called cash inflow; the cash that flows out of the company at a certain moment is called cash outflow. The algebraic sum of cash inflow and cash outflow is called cash flow.

What is Free Cash Flow#

For the same restaurant, although there is a cash flow of 1,000 yuan today, a cautious owner would not dare to spend all of it. This is because he needs to set aside some cash to purchase raw materials for the next day; otherwise, the restaurant cannot open.

Suppose the owner spends 300 yuan on new raw materials, leaving 700 yuan for personal use. This 700 yuan is the free cash flow.

Thus, the difference between free cash flow and cash flow is that free cash flow is very flexible, to the extent that it can be considered dispensable and does not significantly impact the company's operations.

The precise definition of free cash flow is: the cash flow remaining after meeting the company's reinvestment needs. This portion of cash flow is the maximum amount available for distribution to the company's capital providers without affecting the company's development.

For this restaurant, the capital provider is the owner himself, as he is the only one financing it. For publicly traded companies, capital providers include all individuals and institutions holding the company's stock.

How to Calculate Free Cash Flow#

For a simple small business like a restaurant, free cash flow is the cash flow generated from opening the restaurant that day, minus the funds needed to maintain operations for the next day.

For publicly traded companies, it is not that simple. Public companies have various business models, and to accurately record the company's financial status, they must rely on accounting standards based on the accrual basis.

Typically, free cash flow can be calculated as the net cash flow from operating activities in the financial statements minus capital expenditures, such as cash paid for constructing fixed assets, intangible assets, and other long-term assets, that is:

FreeCashFlow=NetCashFlowfromOperatingActivitiesCapitalExpenditures(1)Free Cash Flow = Net Cash Flow from Operating Activities - Capital Expenditures (1)

The net cash flow from operating activities is calculated using the following formula:

NetCashFlowfromOperatingActivities=NetProfitAfterTax+DepreciationandAmortizationIncreaseinWorkingCapital(2)Net Cash Flow from Operating Activities = Net Profit After Tax + Depreciation and Amortization - Increase in Working Capital (2)

Substituting (1) into (2), the final formula for calculating free cash flow is:

FreeCashFlow=NetProfitAfterTax+DepreciationandAmortizationIncreaseinWorkingCapitalCapitalExpenditures(3)Free Cash Flow = Net Profit After Tax + Depreciation and Amortization - Increase in Working Capital - Capital Expenditures (3)

When calculating free cash flow, it is essential to remember one thing: we are concerned with actual cash, not money owed to us by others, nor unsold products.

Below is a brief explanation of the reason for each item in the formula.

Why Add Depreciation and Amortization#

When calculating net profit after tax, depreciation of equipment and amortization of costs are deducted. However, depreciation and amortization do not cause a loss of cash flow for the company, so this portion must be added back when calculating free cash flow.

Why Subtract Increase in Working Capital#

Working capital equals current assets minus current liabilities.

Current assets affecting working capital include inventory, accounts receivable, and prepaid expenses. These items either delay the receipt of cash for the company or cause the company to pay cash in advance, reducing the cash currently available to the company.

Current liabilities affecting working capital include deferred revenue and accounts payable. These items either allow the company to receive cash in advance or delay cash payments, increasing the cash currently available to the company.

An increase in working capital, meaning the current working capital is greater than the previous working capital, indicates that the growth of current assets exceeds that of current liabilities, which will reduce the cash currently available to the company.

However, when calculating net profit after tax, the increase in working capital is counted as part of the profit, while the increase in working capital is caused by the increase in inventory, accounts receivable, and prepaid expenses. The increased portion does not bring cash to the company, so when calculating free cash flow, the increase in working capital must be subtracted. Note that it is the increase in working capital that is subtracted, not the working capital itself.

What is Discounting#

Before explaining the concept of discounting, let's consider the following question.

The Aladdin's lamp tells you: you are a good child who loves to learn, and I want to reward you with 1 million cash. I can give it to you now, or I can give it to you five years later. Do you want it now or later?

Most people would certainly prefer to receive the 1 million cash now.

Because once you have the 1 million cash, you can deposit it in the bank. Assuming the interest rate is 3%, in five years, 1 million will become $100\times(1+0.03)^5=1.159 million$. The process of money increasing reflects the time value of money.

In other words, in your eyes, 1.159 million five years later is equivalent to 1 million now. That is, 1.159 million five years later, when discounted back to now, equals 1 million.

Therefore, discounting is defined as the process of converting the value of future funds to present value. It can be understood simply as a discount; the same amount of money is worth less in the future than it is now, so future money needs to be discounted to convert it into present value.

The discount rate is the expected return on future funds converted to present value, which reflects the time value of money. For example, in the above case, the annual discount rate is 3%, because of the existence of interest, the principal increases by 3% each year.

General Discounted Free Cash Flow Valuation Model Calculation Formula#

Having understood the concepts of free cash flow and discounting, we can further explore how to use the discounted free cash flow model to calculate a company's intrinsic value.

First, let's review what the discounted free cash flow model is:

The value of stocks, bonds, or businesses depends on the sum of all future free cash flows discounted at an appropriate rate.

This statement describes both what the discounted free cash flow model is and how to calculate a company's intrinsic value using free cash flow.

Assuming the company can operate for n more years, with future cash flows for years 1, 2, 3, ..., n being $C_1, C_2, C_3... C_n$, and the discount rate for each year being $r$, then the present value of these cash flows would be $\frac{C_1}{1+r}, \frac{C_2}{{(1+r)}^2}, \frac{C_3}{{(1+r)}^3}... \frac{C_n}{{(1+r)}^n}$. This data can be organized in a table as follows:

Year from NowFree Cash Flow for the YearPresent Value of Free Cash Flow
1$C_1$$\frac{C_1}{1+r}$
2$C_2$$\frac{C_2}{{(1+r)}^2}$
3$C_3$$\frac{C_3}{{(1+r)}^3}$
.........
n$C_n$$\frac{C_n}{{(1+r)}^n}$

By summing all the present values of free cash flows in the above table, we obtain the intrinsic value of the company:

IntrinsicValueoftheCompany=C11+r+C2(1+r)2+C3(1+r)3+...+Cn(1+r)n=t=1t=nCt(1+r)t(4)\begin{aligned} Intrinsic Value of the Company=\frac{C_1}{1+r}+\frac{C_2}{{(1+r)}^2}+\frac{C_3}{{(1+r)}^3}+...+\frac{C_n}{{(1+r)}^n} \\ =\sum_{t=1}^{t=n} \frac{{C_t}}{(1+r)^{t}}(4) \end{aligned}

where:

  • $n$ is the remaining lifespan of the asset
  • $t$ is the year from now
  • $C_t$ is the free cash flow in year $t$
  • $r$ is the discount rate

Formula (4) is the most basic form of the discounted free cash flow model, which I will refer to as the General Formula.

The general formula "looks" simple and perfect, and the underlying theory of discounted free cash flow can withstand scrutiny. However, since it is so beautiful and the calculation method is straightforward, why do so many people still incur losses in the stock market? Logically, if you calculate a company's intrinsic value using this formula, you should not incur losses as long as you buy when the price is below intrinsic value.

Because, to use the general formula, you need to know the company's free cash flow for the next n years.

First, you cannot accurately know how long the company will survive; it may become a century-old store, or it may collapse immediately after experiencing a black swan event. Secondly, you cannot predict the free cash flow for the next n years. Perhaps you can rely on a deep understanding of the company to predict the free cash flow for the next three to five years, but no one can predict the company's free cash flow for the next ten or even several decades.

Thus, the general formula is not very useful.

Two-Stage Discounted Free Cash Flow Valuation Model Calculation Formula#

To make the general model more practical, some have made improvements. The idea behind the improvement is that since we cannot accurately predict the company's free cash flow for the next n years, we can divide the time into two stages: a period where we can estimate free cash flow more accurately and a later period where we can only estimate it roughly. The first stage typically lasts 3 to 5 years, while the second stage is assumed to be perpetual.

When estimating the free cash flow for the second stage, we assume that the growth rate of free cash flow remains constant at $g$, known as the perpetual growth rate.

For example, we use the two-stage method, with the first stage lasting 3 years and the second stage lasting (n-3) years, with a discount rate of $r$ and a perpetual growth rate of $g$. The predicted free cash flows for the first three years are $C_1, C_2, C_3$, and according to the definition of the perpetual growth rate, the free cash flows for the second stage will be $C{_3}(1+g), C{_3}(1+g)^2... C{_3}(1+g)^{n-3} ...$.

It is important to note that since we will no longer directly predict free cash flow after three years, but will use the free cash flow from the third year to calculate future free cash flows, all future cash flows will be multiplied by $C_3$.

The present value of the future n years of free cash flow is as follows:

Year from NowFree Cash Flow for the YearPresent Value of Free Cash Flow
1$C_1$$\frac{C_1}{1+r}$
2$C_2$$\frac{C_2}{{(1+r)}^2}$
3$C_3$$\frac{C_3}{{(1+r)}^3}$
4$C{_3}(1+g)$$\frac{C{_3}(1+g)}{{(1+r)}^4}$
5$C{_3}(1+g)^2$$\frac{C{_3}(1+g)^2}{{(1+r)}^5}$
6$C{_3}(1+g)^3$$\frac{C{_3}(1+g)^3}{{(1+r)}^6}$
.........
n$C{_3}(1+g)^{n-3}$$\frac{C{_3}(1+g)^{n-3}}{{(1+r)}^n}$

Using the calculation method of the general discounted free cash flow model, we sum all the present values of free cash flows in the above table to obtain:

IntrinsicValueoftheCompany=C11+r+C2(1+r)2+1(1+r)2C3rg=C11+r+C2(1+r)2+1(1+r)2C3rg+...(5)\begin{aligned} Intrinsic Value of the Company=\frac{C_1}{1+r} + \frac{C_2}{{(1+r)}^2} + \frac{1}{(1+r)^2}\frac{C_3}{r-g}\\& =\frac{C_1}{1+r} + \frac{C_2}{{(1+r)}^2} + \frac{1}{(1+r)^2}\frac{C_3}{r-g} + ... (5) \end{aligned}

The value of the second half of equation (5), starting from $\frac{C_3}{{(1+r)}^3}$, can be calculated using the infinite geometric series summation formula. Note that when n is large, we can treat it as having infinitely many terms, so we can use the infinite geometric series formula for summation.

C3(1+r)3+C3(1+g)(1+r)4+C3(1+g)2(1+r)5+C3(1+g)3(1+r)6+...+C3(1+g)n3(1+r)n+...=1(1+r)2C3rg(6)\begin{aligned} \frac{C_3}{{(1+r)}^3} + \frac{C{_3}(1+g)}{{(1+r)}^4} + \frac{C{_3}(1+g)^2}{{(1+r)}^5} + \frac{C{_3}(1+g)^3}{{(1+r)}^6} + ... + \frac{C{_3}(1+g)^{n-3}}{{(1+r)}^n} + ... \\ =\frac{1}{(1+r)^2}\frac{C_3}{r-g}(6) \end{aligned}

Substituting equation (6) into equation (5), we obtain the final formula for calculating the intrinsic value of the company using the two-stage method:

IntrinsicValueoftheCompany=C11+r+C2(1+r)2+1(1+r)2C3rg(7)Intrinsic Value of the Company=\frac{C_1}{1+r} + \frac{C_2}{{(1+r)}^2} + \frac{1}{(1+r)^2}\frac{C_3}{r-g}(7)

How to Choose the Perpetual Growth Rate and Discount Rate#

Predicting the future is a task with a low success rate, so we simplify the prediction of free cash flow for each of the next three years, while using the perpetual growth rate to make a very rough estimate of free cash flow after three years.

The choice of perpetual growth rate varies by person and asset class. For individual investors using spare money for investment, the following considerations can be made.

Through certain research, you have a thorough understanding of a company's business model and core competitiveness, and you believe that the company can still maintain a certain competitive advantage in the future. Therefore, the company's annual free cash flow growth rate will not be lower than the risk-free rate of return, so the risk-free rate can be used as the perpetual growth rate.

In the era of fiat currency, lending money to the government is the safest investment method, so the yield on ten-year government bonds is often used to determine the risk-free rate of return.

The current ten-year government bond yield is 2.85%, rounded up to 3%.

For the discount rate, as mentioned earlier, the discount rate is the proportion of future expected returns converted to present value, which essentially reflects the returns investors expect to receive in the future. Now, simply buying government bonds can yield a 3% return, so what return do you think is appropriate for taking on the greater risk of stocks? In other words, how high of a return is needed to compensate for the risk?

This is also a matter that varies by person. For me, I expect the overall future return to reach twice the risk-free rate, which is 6%.

Valuation Example with Tencent#

The year 2022 was a tumultuous year for the Chinese internet industry, with many internet companies experiencing a sharp decline in profits and stock prices halving repeatedly. Tencent faced antitrust issues, restrictions on game licenses, and financial regulations, with a profit of 115.6 billion yuan last year, down 7%, and free cash flow of 88.4 billion yuan. Additionally, it holds equity in listed and unlisted companies worth about 770 billion yuan.

After announcing its annual report on March 22, 2023, Tencent's stock price rose by 8%. On a micro level, the market believes that after the third quarter's performance turned positive and the fourth quarter's profit grew by 19%, Tencent's performance has reached an inflection point. On a macro level, with the lifting of pandemic restrictions, consumer spending rebounded, and the government's attitude shifted from restricting platform economic development to encouraging platforms to grow stronger, the attitude towards private entrepreneurs has also changed dramatically in a short time.

Without delving into excess information, let's return to the main line of valuing Tencent. Tencent's valuation can be viewed in two parts: the first part is core business, such as gaming, advertising, fintech, and cloud and enterprise services, which can be valued using the discounted free cash flow method; the second part mainly includes the equity in listed and unlisted companies obtained through annual profits. The market value of this equity can be directly added to the valuation of the first part to obtain Tencent's total valuation.

First, we predict the free cash flow for the next three years. Considering that Tencent has passed its darkest hour, the macro environment continues to improve, and the company's competitive advantage remains stable, with promising growth in mini-programs and WeChat short videos, we set the annual growth rate of future free cash flow at 20%. Thus, the free cash flows for 2023, 2024, and 2025 will be 106 billion yuan ($884\times{1.2}$), 127.2 billion yuan ($884\times{1.2}^2$), and 152.7 billion yuan ($884\times{1.2}^3$).

Next, we determine the perpetual growth rate and discount rate. As one of China's top-quality companies, Tencent's future free cash flow growth rate will not be lower than the risk-free rate, so we use the 3% risk-free rate as the perpetual growth rate. The discount rate is set at twice the risk-free rate, which is 6%.

Finally, based on the discounted free cash flow method, we calculate the intrinsic value of Tencent's core business (see formula (7)):

IntrinsicValueofCoreBusiness=C11+r+C2(1+r)2+1(1+r)2C3rg=10601+0.06+1272(1+0.06)2+1(1+0.06)215270.060.03=47450\begin{aligned} Intrinsic Value of Core Business &=\frac{C_1}{1+r} + \frac{C_2}{{(1+r)}^2} + \frac{1}{(1+r)^2}\frac{C_3}{r-g}\\& =\frac{1060}{1+0.06} + \frac{1272}{{(1+0.06)}^2} + \frac{1}{(1+0.06)^2}\frac{1527}{0.06-0.03} \\& =47450 \end{aligned}

Thus, the total valuation is the intrinsic value of the core business plus the market value of the equity held, totaling 55,150 billion yuan (47450 + 7700 = 55150).

Although we have arrived at a valuation, what price should we buy at? Should we buy at the stock price corresponding to the valuation?

No, because we can candidly admit one thing: our predictions about the future are often wrong, at least not entirely correct. Think about what has happened in the financial markets this year; anything bizarre could happen in the future. To allow for errors, we need to apply the concept of margin of safety again, meaning we should not buy based on valuation but rather apply a significant discount.

My suggestion is to buy at half the valuation, for example, buying when Tencent's market value is 27,575 billion yuan, corresponding to a Hong Kong stock price of 327.5 HKD, while the current stock price is 385.4 HKD (April 9, 2023, click to view real-time stock price).

If you ask me why I didn't buy at last year's lowest point of 180 HKD, I would say that there is only one bottom, and those who buy are all lucky.

(Note: All analyses should not be considered as investment advice)

When to Use the Discounted Free Cash Flow Model#

There is no silver bullet in the investment world; any model is only correct under certain conditions, and the discounted free cash flow model is no exception.

According to the calculation formula of the two-stage discounted free cash flow model:

IntrinsicValueoftheCompany=C11+r+C2(1+r)2+1(1+r)2C3rg(8)Intrinsic Value of the Company=\frac{C_1}{1+r} + \frac{C_2}{{(1+r)}^2} + \frac{1}{(1+r)^2}\frac{C_3}{r-g}(8)

It provides two important pieces of information:

First, only companies that meet the following conditions are suitable for the discounted free cash flow model:

  • When valuing, we focus on how much cash the company can distribute to shareholders in the future, not just the numbers fluctuating on the K-line chart, nor simply the profits the company earns, because profit does not equal cash. For example, goods purchased from the company on credit will generate profit, but if the buyer defaults, it leads to bad debts. This requires us to invest in companies that can generate real cash.
  • When valuing, we believe that the company can survive for a sufficiently long time n in the future, hoping that the company can generate free cash flow every year during its existence and distribute it to us. This requires us to invest in companies with sustainable competitiveness and free cash flow.
  • As shareholders, we hope that the cash flow generated by the company each year can be distributed to us without needing to finance from other sources, and that we can receive a similar amount of cash next year as we did last year. This requires us to invest in companies that do not require significant investment to maintain current profitability.

Therefore, the discounted free cash flow model is suitable for companies with real profits, sustainable free cash flow, and that do not require much investment to maintain current profitability. Other companies are not suitable for valuation using this model.

Second, only funds that meet these conditions are suitable for the discounted free cash flow model

Since the model focuses on the free cash flow generated during the company's existence, companies that meet the above conditions can typically survive for many years. This requires us to view the company's valuation from a long-term perspective, and to match this long-term perspective, we also need to use long-term funds.

Long-term funds refer to money that will not be used in the short term, such as three to five years.

Imagine that when Tencent's stock price fell from its peak of 740 HKD to 327.5 HKD, a drop of 55%, you thought the stock price was low enough, so you borrowed money from the bank to buy a large amount of Tencent stock, blindly confident that the stock price would rise in the short term. However, after buying, instead of rising, the price continued to fall, eventually dropping to 180 HKD. At this point, your paper loss is 45%, and the bank starts to urge you to repay the loan, forcing you to sell your stocks and raise money from other sources to repay the bank.

This illustrates that the discounted free cash flow model requires us to use long-term idle funds and not to use leverage (borrowing money for investment is a form of leverage) because in extreme market panic, prices can drop to any level. Only by using long-term funds can we shield ourselves from the market's erratic pricing and avoid having to sell assets due to urgent situations.

Thus, it is often said that the discounted free cash flow model is more of an investment philosophy than a valuation method, as it tells us what kind of companies to invest in and what type of funds to use for investment.

Conclusion#

  • Derived two forms of the discounted free cash flow model, with the two-stage model being more practical, and performed valuation calculations using Tencent as an example.
  • The discounted free cash flow model essentially reflects an investment philosophy, informing people to use long-term funds to invest in companies with real profits, sustainable free cash flow, and that do not require much investment to maintain current free cash flow.

References#

  1. Tang Chao. Practical Value Investing. China Economic Publishing House, 2019.
  2. A Discussion on the Cash Flow Discounting Method
  3. Discount Rate Defined: How It's Used by the Fed and in Cash-Flow Analysis
  4. Geometric Series Summation Formula_Baidu Encyclopedia
  5. Old Tang's Valuation Method Q&A (Continued)
  6. Old Tang's Valuation Method Q&A Continued
  7. Tencent Announces Q4 and Full Year 2022 Results
  8. Tencent Returns to Bull Market 丨 ZhiKe
  9. Old Tang's Weekly Journal March 25, 2023 Free Version: Brief Review of Tencent's Annual Report, Trading Arrangements for Next Week, and Reading for This Month
Loading...
Ownership of this post data is guaranteed by blockchain and smart contracts to the creator alone.