Sign in or start a free trial to avail of this feature.
8. The Terminal Value Part 1
The terminal value is a technique used to estimate the discounted cashflows beyond our financial projection period. In this lesson, I show you how to calculate the terminal value using the perpetuity method.
Calculating the Terminal Value (TV)
- The terminal value simply represents all the future cashflows beyond a certain point in time
- That point in time is the final year of our projection
- For a 5-year projection, a terminal value will comprise of 70-80% of total value
- For a 10-year projection, a terminal value will comprise of ~50% of total value
- The terminal value can be calculated in two ways:
--- Perpetuity method
--- Exit multiple (next lesson)
- Assumes that the company will continue to grow at a stable rate into the future
- TV(perpetuity) is the cashflow in year 6 divided by the discount rate minus the growth rate
- Be sure to keep the growth rate under the average GDP growth rate!
In the previous lesson, we performed a discounted cashflow evaluation for Magro Co. However, we only performed a 5 year projection, so the current enterprise value of the business is artificially low. Ow we need to find a way to calculate the value of the remaining cash flows that exist beyond the next 5 years. And to do this, we would use a concept called the terminal value. The terminal value simply represents all the future cash flows beyond a certain point in time. Which I'm going to define as the final year of my projection. The terminal value can be calculated in two ways. The first of which is the perpetuity method. This method assumes that company will continue to grow at a stable rate into the future. The formula for the terminal value, using the perpetuity method is the cashflow in year 6 divided by the discount rate minus the growth rate. So let's start by assuming a stable growth rate of say, 1.5%.
It's important to keep this growth rate under the average GDP growth rate, otherwise Magro Co. would eventually become bigger than the economy itself. Next, let's calculate the cash flows in year 6 of our projections. And to do this, it's very simple. We go to our unlevered free cashflow and we multiply the last cashflow by one plus the growth rate.
To calculate the terminal value, we simply take this cash flow and divide by the discount rate which is WACC, minus the growth rate.
And this gives me a terminal value of 293.9 million.
Needless to say, this number needs to be discounted. So, I'll take the number and divide by one plus the discount rate, which is in cell D193, all to the power of the year minus 2015. Which is in cell G153.
And this tells me that my discounted terminal value is 184.9 million.
If I compare this number to the discounted cash flows in the first 5 years, I can see that roughly the discounted terminal value contributes about 75% to the total value of the business.
In a typical 5 year projection, the terminal value comprises of 70 to 80% of the total value of the company.
So this current projection appears pretty reasonable. For a 10 year projection, the terminal value will contribute only 50% of the total value. In either case, the terminal value has a huge impact on the final evaluation number. Personally, I'm not a big fan of assuming a constant growth rate from year 6 onwards of 1.5% when calculating my terminal value. As you can see from the growth and annual unlevered free cashflow, this number of 1.5% is simply not viable. Instead, I prefer a more intuitive option for calculating the terminal value called the exit multiple. The exit multiple applies a market-based multiple to the business at the end of the five-year projection. And this multiple is then discounted back to the present day value. So, in effect, we use a discounted cash flow for the first 5 years of future cash flows, and then a market based multiple to estimate the value of the remaining cash flows. In the next lesson, I'll show you how to calculate the terminal value using this method and also implement a switch which allows us to switch between the two terminal value calculations as we wish.