Sunday, 22 November 2020

Discounted Cash Flow (DCF) Valuation Basic – Part IV

In previous articles, the basic concepts of DCF valuation such as time value money, FCFF, and WACC were discussed (Read more here), (Read more here), and (Read more here).

The next step is to forecast the future FCFF stream.  Normally analysts will forecast the numbers based on their understanding of the company business and development.  For beginner, you can refer to research reports that are available for free on Bursa Market Place.

As promised, we are going to analyse Top Glove.  The following tables are the summary of analysts forecast.  All analysts are expecting the revenue of Top Glove to be either doubled or tripled in 2021, but will decline starting 2022.  Which means the supernormal demand and high selling price of glove is not sustainable.

Most research reports will not provide forecast beyond three years, some even only provide two years forecast.  Thus, forecasting beyond 3 years horizon is challenging but in DCF model, based on Damodaran spreadsheet (Download here), at least 10 years horizon is required and estimating the terminal value is very important.  Terminal value means at a certain point of time, the company will grow at a nominal rate forever.  The usual assumption is the FD rate ten years later.  In order to cover the uncertainty of long term growth rate, it is recommended to have 3 different scenario, average, min, and max.  Same assumption is applicable to WACC, Revenue, and EBIT forecast.

Top Glove Revenue Forecast

Research House

2021F

2022F

2023F

Report Date

Source

 

MayBank

27,796.0

17,793.0

15,520.0

8-Oct-20

link

 

Public

17,827.9

12,345.9

10,672.9

18-Sep-20

link

 

JF APEX

12,513.0

8,057.3

n/a

30-Sep-20

link

 

AFFIN

16,882.9

10,922.5

10,759.0

17-Sep-20

link

 

Kenanga

17,290.0

13,514.0

n/a

18-Sep-20

link

 

Aminvest

21,810.7

11,589.7

9,229.3

18-Sep-20

link

 

MIDF

12,852.0

10,710.0

9,481.5

18-Sep-20

link

 

HLBANK

14,598.6

10,261.2

n/a

18-Sep-20

link

 

Average

17,696.4

11,899.2

11,132.5

 

Min

12,513.0

8,057.3

9,229.3

 

Max

27,796.0

17,793.0

15,520.0

 

Top Glove EBIT Forecast

Research House

2021F

2022F

2023F

Report Date

Source

MayBank

14,794.9

5,554.6

2,281.9

8-Oct-20

link

Public

10,622.4

4,929.0

2,893.3

18-Sep-20

link

JF APEX

5,630.9

1,611.5

n/a

30-Sep-20

link

AFFIN

n/a

n/a

n/a

17-Sep-20

link

Kenanga

n/a

n/a

n/a

18-Sep-20

link

Aminvest

7,963.8

2,867.3

1,513.8

18-Sep-20

link

MIDF

5,996.4

2,533.7

1,880.7

18-Sep-20

link

HLBANK

7,310.6

3,732.6

n/a

18-Sep-20

link

Average

8,719.8

3,538.1

2,142.4

Min

5,630.9

1,611.5

1,513.8

Max

14,794.9

5,554.6

2,893.3



 

Min

Average

Max

WACC

7.43%

8.61%

9.80%

Terminal growth rate

2%

3%

4%


The spreadsheet framework that we are going to use here is the simplified version of Damodaran spreadsheet.  We will be estimating the value of Top Glove based on average condition.  There are a lot of cells that need to be filled in order to complete the sheet thus it will not be easy to explain in words and sentences.  Thus, an additional sheet that shows all the formula will be embedded as well.  Drop your questions on engineering2finance facebook page if you have any questions (link). 

Keep in mind that there are many assumptions made in formulating the model.  These assumptions did not go thru due diligence exercise, and most of the time they are made for easy understanding rather than accuracy.  However, the numbers in each cells are derived based on sensible financial principle rather than haphazardly. 

Finally, let’s come back to the most important question – what is the value of Top Glove based on this DCF model?

Here you go.




Try to build you own spreadsheet to find the Max value and post your answer on the engineering2finance facebook page (link).

REMINDER!  The example – Top Glove, used in this DCF model is meant for education purpose, to help readers to better understand the building block of DCF model.  It should not be interpreted, or relied upon, as financial or business advice.  Please consult licensed investment advisors for proper investment advice.

Good luck and have fun!

Disclaimer:  The above analysis does not imply any buy or sell recommendation.  The author disclaims all liabilities arising from any use of the information contained in this article.

Disclosure: The author may have interest in the stocks of the companies in this article. 


Thursday, 19 November 2020

Discounted Cash Flow (DCF) Valuation Basic – Part III

In previous articles, the basic concepts of DCF valuation such as time value money and FCFF were discussed (Read more here), and (Read more here).  This article will focus on basic concept of WACC and cost of equity, which are essential to “discount” the future FCFF stream to present value.

Some websites provide WACC and cost of equity for free, but the numbers provided by each site are slightly different.  This article will guide you to compute the WACC and cost of equity yourself. 

WACC is the cost of capital to run a company, which include debt and equity.  The formula of WACC is



where,

Debt      = market value of debt (or book value of debt)

Equity    = market value of equity (market cap)

kd           = Cost of Debt

ke           = Cost of Equity

Again, math is simple but getting the correct number to be inserted into the formula is not straight forward.  The following table shows the source to obtain the numbers and the level of difficulty to get them.

(for simplicity, kd is estimated using this year interest expense divided by average of this year and last year total debt)

CAPM is the most popular way to estimate cost of equity.  The formula of CAPM is

where,

Rf                          = Risk Free Rate (or Fixed Deposit rate for retail investor)

β                            = Beta (volatility of stock relative to overall market)

Rm                        = Market return

(Rm – Rf)             = Market Risk Premium

It is not easy to compute Beta but there are a lot of tutorials available on web or Youtube.  Fortunately, many financial websites are now publishing beta of company, but the issue is their numbers are different from each other.  This because each source is using different time horizon to calculate beta.  Some use 1-year, some use 3-year, and most of them do not state the time horizon explicitly.  Generally, those who do not state the time horizon highly likely are 3-year beta.

Market return, or more popular measure – “market risk premium” is also difficult to estimate.  Professor Damodaran from NYU Stern maintains a page to provide market risk premium for various country but only update occasionally for country outside US.  However, Malaysia investors can roughly estimate the market risk premium by using the implied ERP of S&P500 plus the yield spread between US T-Bill and Malaysia T-Bill.  Both data could be found in the Damodaran’s page and Bank Negara Malaysia website.

It is time to go for a real world example.  Again, we are going to compute Top Glove WACC.  The following table shows the respective data required to calculate WACC as at 9pm 18 November 2020.

Variables

Value

Source

Debt (FY2020)

RM0.54 bil

Top Glove Website

Equity (Market Cap)

RM59.0 bil

Bursa Market Place

Tax

17.4%

Top Glove Website

kd

2.3%

Top Glove Website

ke

9.88%

Compute

Rf

2.0%

Google FD Rate

[Rm – Rf]

6.85%

NYU & BNM

Beta (1-Yr)

1.15

TradingView

WACC

9.80%

Compute

The computed WACC is 9.80%  (WACC = 7.4% if 3-Yr Beta is used), which is higher than the numbers reported by some websites.  The main reason is we are using 1-Yr Beta (3-Yr Beta is around 0.8), which is highly volatile due to recent spike in prices.

We have covered three basic concepts of performing a DCF valuation, which are time value money, FCFF, and WACC (and cost of equity).  We will dive into the spreadsheet construction in the next article to estimate the value of Top Glove.

Stay online!  Stay safe!

Disclaimer:  The above analysis does not imply any buy or sell recommendation.  The author disclaims all liabilities arising from any use of the information contained in this article.

Disclosure: The author may have interest in the stocks of the companies in this article. 

 

Sunday, 15 November 2020

Discounted Cash Flow (DCF) Valuation Basic – Part II

In a previous article, the basic concepts of DCF valuation such as time value money were discussed (Read more here).  This article will focus on basic concept of Free Cash Flow to Firm and Free Cash Flow to Equity (FCFE).  There are many ways to compute FCFF and FCFE.  For more detail, you can refer to Professor Damodaran’s slides (Read more here).  This article will only focus on deriving FCFF and FCFE from Earnings Before Interest and Tax (EBIT).

FCFF is not something readily available like Price to Earnings (PE) ratio.  Investors need to compute FCFF from financial data (annual or quarterly report), and then forecast the future FCFF based on their understanding of the company business model, direction, and development.

FCFF can be interpreted as the cash flow available to all the firm’s capital contributors such as debtholders, preferred stockholders and common stockholders, without impacting the firm’s daily operation and future development.

FCFE can be derived from FCFF.  It is the cash flow available to the firm’s common stockholders after the FCFF has accounted for payment (and receipts from) debtholders and preferred stockholders.



Mathematically, FCFF can be computed by

where,

EBIT      = Earnings Before Interest and Tax

Dep       = Depreciation

CAPEX  = Capital Expenditure

∆WC      = Changes in Working Capital

The formula is simple but getting the right numbers to be inserted into the formula is not straight forward.  Thanks to Bursa Market Place (link), the official market info portal by Bursa Malaysia.  You can find financial data, technical chart, company rating, research report, and all other related financial info under one roof.  And it is free!

Let’s take one real world example, Top Glove.  The annual financial reports can be found in the following link.

1.      Annual Income Statement

a.      Web View

b.      Download Excel Spreadsheet

2.      Annual Balance Sheet

a.      Web View

b.      Download Excel Spreadsheet

3.      Annual Cash Flow Statement

a.      Web View

b.      Download Excel Spreadsheet

 

From the annual financial statement, the EBIT can be found in income statement on row Normalized EBIT.  Depreciation can be found in either income statement or cash flow statement, they are the same.


Tax rate, CAPEX, and Changes in working capital are a bit tricky.  You need to calculate them from financial statement rather than obtaining them directly.  Thanks to Bursa Market Place, you can download the financial statements in excel format and let the spreadsheet do the calculation for.

For tax rate, you can obtain it by dividing the Provision for Income Taxes with Net Income Before Taxes.  Both can be found in income statement.

For changes in working capital, it is a bit tricky but still be able to estimate from balance sheet.  The information you need are Total Current Assets, Total Current Liabilities, CASH AND SHORT TERM INVESTMENTS, Notes Payable/ Short Term Debt, and Current Port. Of LT Debt/Capital Leases.


Under normal condition, working capital is defined as current assets minus current liabilities.  However, for FCFF valuation purpose, we exclude cash and short term debt, please refer to this link for the rational.  Working capital can be computed as

Changes in working capital is simply this year working capital minus last year working capital.

For simplicity, CAPEX can be computed by using this year gross properties, plants, and equipment (PP&E) minus last year gross PP&E.  Please refer to the following link for detail in estimating CAPEX.

Now you have all the information to compute FCFF.  Try to build one using Excel or Google Sheet, and then compare your results with the following embedded Google Sheet.  Congratulations!  You are one step nearer to build your own DCF model.


Disclaimer:  The above analysis does not imply any buy or sell recommendation.  The author disclaims all liabilities arising from any use of the information contained in this article.

Disclosure: The author may have interest in the stocks of the companies in this article.