Valuation

Building on the previous section, let’s further breakdown the Enterprise Value formula.

$$\begin{array}{rcl}EV& =& \left[\sum _{t=1}^N\frac{FC{F}_t}{(1+WACC{)}^t}+\frac{\text{Terminal Value}}{(1+WACC{)}^N}\right](1+WACC{)}^{0.5}\\ \\ \\ & =& \underset{\text{Use Excel's NPV function}}{\underbrace{\left[\sum _{t=1}^N\frac{FC{F}_t}{(1+\frac{E}{E+D}{R}_e+\frac{D}{E+D}{R}_d(1-T_c){)}^t}+\frac{\text{Terminal Value}}{(1+\frac{E}{E+D}{R}_e+\frac{D}{E+D}{R}_d(1-T_c){)}^N}\right]}}\left(1+\frac{E}{E+D}{R}_e+\frac{D}{E+D}{R}_d(1-T_c){)}^{0.5}\right)\end{array}$$

The reason we take $(1+WACC{)}^{0.5}$ is due to the underlying assumption that incoming cash flows continuously at any given year, and as such, it would be a misguided effort to calculate this value at year end.

Effectively, the formula breaks down to =NPV(rate, value range)*$(1+WACC{)}^{0.5}$ in Excel.

Enterprise Value = $(77,382.24) <– =NPV(B5,D10:H10)*(1+B5)^0.5

Based upon the WACC we calculated in the previous section, we are going to create our valuation workbook as follows:

The reason why we have to re-forecast our long-term pessimistic growth rate is because if it is not less than the WACC, we will effectively calculate a terminal value of less than “0.” The company CANNOT reinvest beyond the discount rate (past 100%).

$$\begin{array}{rcl}\text{Terminal Value}& =& \frac{FC{F}_t(1+g)}{(WACC-g)};\text{where }t=5⟶\text{last year}=5\\ \\ \text{Terminal Value}& =& \frac{\text{(Last year of forecasted cash flow) x (1 + long term growth rate)}}{\text{WACC – long term growth rate}}\end{array}$$

We will use the ROIC approach to:

• compute normalized earnings and/or cash flow instantaneously
  
• Map out the variables of these calculations and reference them back to the Pro Forma
  
• Estimate pessimistic cash flows
  
• Estimate optimistic cash flows

ROIC: Return on Investment Capital.

$$\begin{array}{rcl}\text{Normalized Return assets (pre-tax)}& =& \frac{\text{EBIT}}{\text{Total Assets}}\\ \\ \text{ROIC}& =& \frac{\text{EBIT (1-tax rate)}}{\text{Total Assets}}\end{array}$$

This method takes into account historic averages, market cap, and makes assumptions based upon other variables to drive calculations.

We discussed equity and cost of equity while covering WACC and CAPM, but let us refresh here:

$$\begin{array}{rcl}\text{Equity = market cap}& =& \frac{\text{share price}}{\text{shares outstanding}}\\ \\ \text{Cost of Equity}& =& \text{Risk Free Rate of Return +}\\ & & \text{(Beta * Expected Return of Market) - (Risk-Free Rate of Return)}\\ \\ & =& \text{US Treasury Rate + (Beta * Market Premium)}\\ \\ & =& \text{FCFE = free cash flow to equity = Net Income - (CAPEX - Depreciation) x (1 - Debt Ratio)}\end{array}$$