Financial Modelling Techniques for Valuation Analysis
2 day duration An accurate and flexible financial model is a critical component of a...
Terminal value is the value of a project’s expected cash flow beyond the explicit forecast horizon. An estimate of terminal value is critical in financial modelling as it accounts for a large percentage of the project value in a discounted cash flow valuation. This tutorial focuses on ways in which terminal value can be calculated in a project finance model.
Net present value (NPV) can be used to calculate the value of a project/investment based on future cash flows. A firm or project potentially has infinite life. Its value, therefore, is the NPV of cash flows for an indefinite period into the future
However, forecasting results beyond certain periods is impractical and exposes such projections to a variety of risks. This limits their validity, as there is great uncertainty in predicting the project revenue or cost components, and industry or macroeconomic conditions beyond a few years.
Terminal value is a critical component to financial modelling for valuations and is often discussed in depth in our financial modelling courses.
To capture the value at the end of the forecasting period, a terminal value is included. Terminal value allows for the inclusion of the value of future cash flows beyond a several year projection period, while satisfactorily mitigating many of the problems of valuing such project cash flows.
A high-quality estimate of terminal value is critical because it often accounts for a large percentage of the total value of the project in a discounted cash flow valuation. As a result, financial analysts and modellers should be familiar with the mechanics of terminal value, and how it is calculated, in order to ensure an accurate financial modelling and valuation exercise.
This tutorial with the accompanied Excel workbook illustrates various ways in which terminal value can be calculated.
Three methods will be discussed in this tutorial:
In practice, academics tend to use the perpetuity growth model, while project financiers favour the exit multiple approach.
Ultimately, these methods are two different ways of saying the same thing. For both terminal value approaches it is essential to use a range of appropriate discount rates, the multiples and perpetuity growth rates in order to establish a functional valuation range.
The multiple EBITDA approach measures the firm value of the enterprise – that is, the value of the business operations. In calculating enterprise value, only the operational value of the business is included. The formula to calculate the terminal value is:
The present value (PV) of the terminal value is then added to the PV of the free cash flows in the projection period to arrive at an implied firm value.
A publicly-traded comparable company’s multiples are used in the calculation. This method is the easiest approach but, depending on the purposes of the valuation, the estimated EBITDA multiple may not provide an appropriate reference range.
There are some variations of multiple used in the terminal multiple approaches:
The perpetuity growth approach assumes that free cash flow will continue to grow at a constant rate into perpetuity. The terminal value can be estimated using this formula:
What growth rate do we use when modelling? The constant growth rate is called a stable growth rate. While past growth is not always a reliable indicator of future growth, there is a correlation between current growth and future growth. A project currently growing at 10% probably has higher growth and a longer expected growth period than one now growing at five percent a year.
Using estimation of the growth rate in this approach makes it challenging, because inaccuracy in the assumption can provide an improper value. Therefore, analysts sometimes drop the growth rate in the formula to arrive at a more conservative terminal value.
For illustration on how the terminal value is estimated and used for valuation purpose in a project finance model, we have prepared an Excel workbook, which you can download at the top or bottom of this tutorial.
The example assumes that a project has 12-month constructions, and quarterly cash flow projections of 10 years. Three methods are demonstrated to estimate the terminal value. The assumptions are depicted in screenshot 1 below. In all methods, we need to establish the EBITDA or free cash flow at the last year of the projected period. The easiest way to do this is perhaps by constructing a simple binary (1, 0) flag.
SCREENSHOT 1: FINANCIAL MODELLING OF A BINARY FLAG FOR END OF OPERATIONS
The terminal value calculation is very straightforward. Various methods of calculating the terminal value are shown below.
SCREENSHOT 2: MULTIPLE EBITDA APPROACH FOR TERMINAL VALUE CALCULATIONS IN A FINANCIAL MODEL
The final step is to add the terminal value into the project cash flow before calculating the NPV. In this example, it is assumed that the perpetuity approach is selected.
There are a few considerations in calculating terminal value in project finance modelling:
2 day duration An accurate and flexible financial model is a critical component of a...
3 days duration Financial Modelling for Renewable Energy Projects will give you the skills to...
This website uses cookies.
Some of these cookies are necessary, while others help us analyse our traffic, serve advertising and deliver customised experiences for you. For more information on the cookies we use, please refer to our Privacy Policy.
This website cannot function properly without these cookies.
Analytical cookies help us enhance our website by collecting information on its usage.
We use marketing cookies to increase the relevancy of our advertising campaigns.