Showing posts with label Financial Structure. Show all posts
Showing posts with label Financial Structure. Show all posts

Saturday, October 20, 2018

Servizi Italia S.p.A. : plain DCF and target price.

In the following image, we have an example of DCF valuation. 
The firm is Servizi Italia S.p.A. The valuation date was August 18, 2016 and the target was 6.06 EURO (plus a range with regard to the fair value, +/-5%). The target was achieved on November 23, 2017 (in this way, the holding period was about one year and 3 months or 462 days, exactly). For this purpose, consult the following link and see the second one image : 
The upside was about +73%, with regard to the current market price at the time of the coverage :
[6.06 - 3.50] / 3.50 = + 73.14 %


Let's look at the assumptions of the model :
  1. The revenues were the proxy of the model : it means that all the variables depended directly on sales as a percentage.
  2. For the estimation of the revenues of the next three years (2016-2017-2018), I assumed a CAGR of about 3% (the business of the firm is quite steady) ; I looked also at the trend of the past three years. 
  3. For the other items (D&A, NFC, net income, NWC, capex), as I said previously, I assumed a percentage of the revenues : 20%, 1.5%, 5%, 0.5%, 20%. I looked also at the past trend and I considered the evolution of the sector and of the firm, in the next years (for the formula, consult the notes). 
  4. For the estimation of the ERP and tax rate, I used the data source of A. Damodaran (ITA).
  5. For the risk-free rate, I assumed the weighted average yield of BTP 10 years.
  6. For the estimation of the beta, I used the regression between FTSE-mib and Servizi Italia with a time frame of 5 years and with monthly returns (I added a spread of 0.10 to consider the additional risk, due to the reduced liquidity of the stock). 
  7. For the cost of debt and for the financial structure, see the notes.
  8. For the growth rate (g), I assumed a conservative rate of 1% (see the litterature). 
  9. With regard to the calculation of the EV and of the fair value, see the following formula and consult the notes:
EV=[FCF16/(1+wacc)^1]+[FCF17/(1+wacc)^2]+[FCF18/(1+wacc)^3]+[FCF18*(1+g)/(wacc-g)]*[1/(1+wacc)^3]

Sunday, April 1, 2018

Estimate of the cost of debt.

The calculation of the firm's cost of debt is an important factor. Then, it has a direct application in various areas ; in particular, it is useful : 
  • to build a DCF model, in order to value a company (it is a variable to estimate the WACC) ;
  • to adjust the market multiples (higher the cost of debt, lower the market multiple and viceversa) ;
  • to understand the risk of a business and the debt sustenaibility (in other words, the cost of debt is the proxy of the financial structure) ; 
  • to value the risk of a stock, indirectly.
And on that note, we can analyze the main calculation methods. 

I. The cost of debt : the accounting method.

The accounting method is based on balance sheet data. It is easy to estimate but it is also quite prone to errors. It means that if on one hand, the data are readly available, on the other the result is purely static because it doens't consider the perspective scenarios. Indeed, it is advisable to integrate the method with a perspective business plan, focused on the financial structure of the target firm. 

According to this method, the cost of debt is equal to the financial expenses divided by the financial debt. There are two options : the first one considers the gross debt minus the cash and cash equivalents (it means that the debt can be paid by the cash ; this hypothesis is not always true) ; the second one considers the gross debt and the interest expenses (this hypothesis is more prudential). 

Here we have an example ; the company is Amplifon S.p.A. We can notice the two options. The accounting data are the fiscal years 2017 and 2016. 
For further info, please consult the following links : 


As shown in the table, the cost of debt is equal to 7,41% if we consider the net debt and it is equal to 4,63% if we consider the gross debt. An important note : the interest expenses are divided by the average debt with the aim to make comparable the two quantities, the item of the income statement ("flow quantity") and the item of the balance sheet ("stock quantity"). 

Another option of the accounting method is the following : we can also consider an average figure of the cost of debt on several years (3-5 years). In the same way, we can build a perspective table with the estimated financial debt and interest expenses (the next 3-5 years at the place of the past ones). 

II. The cost of debt : the relation between the interest coverage ratio and ratings (the fundamental analysis drivers).

We can link the interest coverage ratio (= EBIT/net financial expenses) to the ratings of a sample. 
For example, the professor A. Damodaran (see the link,--> Ratings, Spreads and Interest Coverage Ratios, http://pages.stern.nyu.edu/~adamodar/) has built a sample with the rated companies in United States. There are two tables : for large, for smaller and riskier companies (the proxy of the size is the market cap). With the current exchange rate and with the current m. cap, Amplifon belongs to the second group (https://www.investing.com/currencies/eur-usd). 

Data source : Damodaran Online

The cost of debt is equal to :

Risk-free rate (Rf) + Default Spread (DS)

For Amplifon the DS is equal to 0.90% (the EBIT interest coverage ratio is 7.76 and the market cap is about $4 billion). For the Risk-free rate (Rf), we can use the annual return of the 10-year T-bond (see the link http://www.stern.nyu.edu/~adamodar/pc/datasets/histretSP.xls ; data source Damodaran Online). For the year 2017, it is equal to 2.80%. In this way, the cost of debt for Amplifon is :

2.80% + 0.90% = 3.70%

As I said, the sample consists of US companies. For a more appropriate sample, of course, it is advisable to use European companies and rate of returns of government bonds, similarly. 

Finally, we must remember that the spread that we add to a base rate can be determined by other fundamental ratios (the interest coverage ratio is just one of the drivers). In this way, the discussed methodology is a part of the framework based on the fundamental analysis. 

III. The cost of debt : the listed bonds.

The last method is among the most reliable and the easiest to apply methods. If we have a firm with listed bonds, the cost of debt is equal to the rate of return of the mentioned bonds (-->yield to maturity, YTM). Alternatively, we can take as a benchmark a panel of similar listed bonds.

For Amplifon, we can consider the bond listed on the Luxembourg Stock Exchange (LuxSE).
See the following link : https://www.bourse.lu/security/XS0953207759/200201