Follow us
facebook     google plus     youtube
 

The Art of Valuation Jujitsu : Part 5

Nov 26, 2014 The Art of Valuation Jujitsu : Part 5

As we saw in Part 4, there are four inputs to an absolute value model: cash flow from existing assets, the expected growth in those assets over the explicit forecast period, the terminal value at the end of the forecast period, and the cost of financing the assets.

When forecasting future cash flows, there are a few key drivers that must be scrutinized. These include revenue growth, which is typically estimated by taking the total market for a product or service and the company’s expected share of that market over the forecast period. You must also consider how the operating margin (OM) is going to trend over time. To do so, look at the margins for the industry. Profit margins tend to converge to the industry average over time. Revenue is then multiplied by the operating margin to arrive at earnings before interest and taxes (EBIT).

Provided below is a free cash flow forecast that I compiled in September 2013. As you can see, it includes all the components we discussed in Part 4. In this case, the explicit forecast period is 2013-2019 with FCF growing from $5,090 to $7,825 million. The terminal value of $83,409 million was calculated using my 2019 FCF estimate of $7,825 million, expected terminal growth in FCF of -0.5%, and cost of capital of 8.8%.

 

2013E

2014E

2015E

2016E

2017E

2018E

2019E

EBIT

6,392

7,415

7,940

8,397

8,957

9,034

9,534

Minus:  taxes

(1,471)

(1,581)

(1,633)

(1,727)

(1,842)

(1,858)

(1,961)

Plus:  depreciation & amortization

402

408

411

409

405

401

405

Minus:  change in working capital

93

53

21

(9)

(18)

(20)

20

Minus: deferred taxes

(150)

(150)

(150)

(150)

(100)

(50)

0

Minus:  capital expenditures

(175)

(194)

(206)

(207)

(174)

(172)

(174)

Unlevered free cash flow

5,090

5,951

6,383

6,713

7,228

7,334

7,825

Free cash flow growth

1.9%

16.9%

7.3%

5.2%

7.7%

1.5%

6.7%

 

 

 

 

 

 

 

 

Discount period months

(8)

4

16

28

40

52

64

Discount period years

(0.7)

0.3

1.3

2.3

3.3

4.3

5.3

Discount factor

1.060

0.974

0.895

0.822

0.756

0.694

0.638

Present value of annual cash flows

5,396

5,796

5,712

5,520

5,461

5,092

4,991

 

 

 

 

 

 

 

 

Terminal value

 

 

 

 

 

 

83,409

 

Next, the FCF estimates over the explicit forecast period (2013-19) and the terminal value were discounted back to the present at the company’s cost of capital of 8.8% (assumed). The sum of the present value of future cash flows was $91,173 million. We refer to this as the enterprise value. Since we are trying to estimate the equity value (not the enterprise value of the firm), we need to deduct net debt from enterprise value. In this case, ESRX had net debt of $13,925 million. Netting the two figures, the estimated equity value per share was $94.65. When compared to the current price of $62, my intrinsic value estimate implied 52% upside.

Valuation

 

Present value of cash flows

37,969

Present value of terminal value

53,204

Enterprise value

91,173

Minus: net debt

(13,925)

Equity value

77,248

Equity value per diluted share

$94.65

Current share price 

  62.05

Upside/(downside) potential

+52.5%

 

 

Valuation assumptions

 

Residual growth rate

-0.5%

Shares – diluted

816

Tax rate

20.6%

 

 

WACC calculation

 

Cost of equity (CAPM)

10.8%

   Beta

1.09

   Equity risk premium

8.0%

   Risk free rate

2.8%

Cost of debt 

2.4%

   Tax-adjusted cost of debt

1.9%

% equity

77.9%

% debt

22.1%

WACC

8.8%

 

 

Returns

 

ROIC

13.2%

IRR

18.9%

 

The valuation model will include your assumptions, which I have recapped above. Two key assumptions are the company’s cost of capital and the terminal growth rate. The cost of capital in a free cash flow to the firm model is the company’s weighted average cost of capital or WACC. It is calculated as the weighted average of debt and equity capital used to finance the company’s assets. The cost of capital will change over time with changes in interest rates, tax rates, and the volatility of the company’s stock. In this case, the cost of capital was ~9%.

The terminal growth rate used in a DCF analysis typically ranges from -2% to +5%. In this case, I have assumed that free cash flow will decline by -0.5% annually beginning in 2020. The terminal growth rate conservatively assumes that sales growth continues to be pressured and that the company’s opportunities for margin improvement dry up post 2019.

When considering the terminal growth rate for a company, I find it instructive to ask: What does the current stock price imply about the company’s future growth rate? To answer that question, we use the cash flows we estimated above, along with the current stock price, to back into the implied terminal growth rate. In this case, the current price was implying a terminal growth rate of -7%! This seemed too draconian for a company that is expected to grow at a midpoint of +15% for the foreseeable future based on management’s estimates.

Reverse DCF

 

Present value of cash flows

37,969

Present value of terminal value

29,315

Implied terminal growth rate

-7.0%

Enterprise value

67,284

Minus: net debt

(13,925)

Equity value

53,359

Equity value per diluted share

65

Current share price 

62

 

Like the analysis above, the implied growth rate suggested the company was undervalued and provided me with confidence to purchase the stock.

No Comments

Post A Comment