Introduction to Terminal Value DCF
Mr. Bosch got inspired from Robin’s returns from share market investment and invested in some appealing stocks without thinking too much. Down the time, some stocks performed well but some stocks fell like anything. Mr. Bosch, who was very enthusiastic in the beginning, lost his entire money. Due to this incidence, he made a firm decision that he will never invest money in the stock market.
So what went wrong with Mr. Bosch’s investment strategy?
It’s a good thing that he took inspiration from Robin, but before investing in the stocks he could have done some research on the company in which he wanted to invest his precious money.
Let’s see, what kind of research would have been beneficial in his case.
Hopeful investors are always, curious about knowing the future cash flow of the company. But as we know publicly traded organization has an infinite lifetime. Hence it is not possible for us to estimate the cash flows forever. Therefore for particular growth period we can estimate the cash flows. And for making long term cash flow growth we use a terminal value approach, which is based on some assumptions.
Terminal Value DCF (Discounted Cash Flow) Approach
Terminal value is defined as the value of an investment at the end of a specific time period, including a specified rate of interest. With terminal value calculation companies can forecast future cash flows much more easily.
When calculating terminal value it is important that the formula is based on the assumption that the cash flow of the last projected year will stabilize and it will continue at the same rate forever.
There are different ways to find out the terminal value of cash flows. Most popularly used is Gordon Growth Model where company is valued as Perpetuity.
4.9 (3,624 ratings)
Gordon Growth Model
This model assumes that the company will continue its historic business and it generates FCF’s at a steady state.
In this method Terminal Value is calculated as:
=Final Projected Free Cash Flow*(1+g)/(WACC-g)
g=Perpetuity growth rate (at which FCFs are expected to grow)
WACC= Weighted Average Cost of Capital (Discount Rate)
This formula is purely based on the assumption that the cash flow of the last projected year will be steady and continue at the same rate forever.
Perpetuity growth rate is the rate which is between the historical inflation rate and historical GDP growth rate. Thus the growth rate is between the historical inflation rate of 2-3% and the historical GDP growth rate of 4-5%. Hence if the growth rate assumed in excess of 5%, it indicates that you are expecting the company’s growth to outperform the economy’s growth forever.
For “XYZ Co.” we have forecasted Free Cash Flow of $22 million for year 5 and the Discount Rate calculated is 11%. If we assume that the company’s cash flows will grow by 3% per year.
We can calculate the Terminal Value as:
XYZ Co. Terminal Value = $22Million X 1.03/ (11% – 3%)
Following are the general steps to be followed in valuation:
Step 1: Free Cash Flow Calculation
First we need to calculate Free Cash Flow to the Firm. This is very crucial step for finding out terminal value as based on the fifth year’s Cash flow we will calculate Terminal Value.
In this we require following information:
- Net Income of the firm
- Depreciation and Amortization expenses
- Stock based compensation
- Interest after Tax
- Capital Expenditure
- Intangibles investment
- Changes in Working Capital
Following is the formula used for calculating Free Cash Flow to the Firm:
Step 2: Calculate WACC (Weighted Average Cost of Capital) Terminal value DCF
Now in second step we have to calculate the cost incurred on working capital.
Re = cost of equity
Rd = cost of debt
E = market value of the firm’s equity
D = market value of the firm’s debt
V = E + D (Total Capital Value)
E/V = Equity Proportion to the total capital
D/V = Debt Proportion to the total capital
Tc = corporate tax rate
From above formula we can see that we need to calculate cost of equity and cost of debt.
We will calculate Cost of equity by using CAPM formula.
CAPM= Rf + Beta (Rm – Rf)
Next we will calculate WACC as Cost of debt is assumed in our case.
Step 3: Estimate the Terminal Value Terminal value DCF
Now as discussed above, we can apply the formula and calculate the terminal value.
Here we have to link FCFF value starting from forecasted year. Hence it is called as explicit forecast.
Step 4: Discount FCFF
In the following step we are calculating the Present value of explicit forecast period by using the Excel function XNPV.
XNPV(rate, values, dates)
rate= discount rate to be applied on cash flows.
values= a series of cash flows
dates= schedule of payment date.
Step 6: Find the Enterprise Value.
In this step we will calculate the Total Enterprise value by summation of Present value of explicit forecast period and Present value of Terminal Value.
Step 7: Adjust Enterprise Value to arrive at Equity Value
In this step we have to find out the intrinsic value of the firms which is calculated as:
Step 8: Find the fair price of Google share
Now we can easily find the fair price of the Google’s share by simply dividing intrinsic value by total no. of shares.
Thus by applying the same technique we can find out the share price of any organization. If the calculated share price comes out to be more than the current market price, in that case the recommendation will be to BUY that share and company is said to be undervalued. In other case if the calculated fair price of the share is less than the current market price then the recommendation will be to SELL that share and company is said to be overvalued.
Let’s look at the other method of finding out Terminal Valu
Terminal Multiple Method
This is another way of determining terminal value of cash flows. It assumes that the company will be valued at the end of the projection period, based on public market valuations. It is calculated by using a multiplier of some income or cash flow measure such as EBITDA (Earnings Before Interest Depreciation Amortization), EBIT (Earnings Before Interest Tax).
Multiple should reflect the ongoing growth potential of the business. It should be based on the appropriate multiple used in that particular industry (EBITDA/EBIT/EBITDA)
E.g. 10x EBITDA
There are some variations of multiple used in the terminal multiple approaches:
- P/E multiple: P/E multiple is calculated as Market Price Per share divided by Earnings Per Share which indicates investors willingness to pay for company’s earnings.
- Market to Book multiple: This compares stock’s market price to its book value. Market to Book multiple is an indication of how much shareholders are paying for the net assets of a company.
- Price to Revenue multiple: It indicates the value of company’s stock price to its revenue. It’s an indicator of value placed on each dollar of company’s revenue or sales.
Here we need to know:
- Multiple is derived from valuation of comparable companies.
- Normalized multiples should be used.
- Multiple should reflect the long term market valuation of the company rather than a current multiple that may be distorted by industry or economic cycle.
- And it is very important to do Sensitivity analysis on multiples
In above example EBITDA expected for the year 2013 is $113 Million and EBITDA transaction multiple is 7x,
Terminal Value= EBITDA (2013)* Multiple
Using Multiples in valuation has certain advantages like, Ease of use as it is based on market values and it provides useful stage for estimation. But the disadvantage lies in finding comparable values in the industry as the firms may differ from each other to the greater extent.
We would like to suggest to Mr. Bosch, that:
The accuracy of DCF valuation is dependent upon the quality of the assumptions, with the factors FCF, TV and discount rate. The inputs in valuation are from variety of resources, they must be viewed factually.
Terminal Value represents a high percentage of the DCF valuation. In future there can be fluctuations in real time values which may cause increase or decrease in actual terminal value. So the Risk is the factor which should be taken care of.
Here are some articles that will help you to get more detail about the Terminal Value in DCF so just go through the link.
- Terminal value dcf
- Enterprise Value Calculation |Terminal Value
- 2 Exclusive Methodologies To Know About Terminal Value
Terminal value dcf Infographics
Learn the juice of this article in just a single minute, Terminal value dcf infographics.
- Is Equity Value Important To A Firm? (Resourceful)
- Enterprise Value Calculation | Terminal Value
- What is Differences of Cost Of Equity
- Amazing Guide to Learn the Calculate Beta (Powerful)
- 4 Best Methods To Calculate WACC (Resourceful)
- Exclusive Methodologies To Know About Terminal Value
- Amazing Tips About Discounted Cash Flow
- Importance Step of Free Cash Flow to Firm For Your Business