\

7.23  IBM Example:  Sensitivity Analysis

By how much do we need change the value of key inputs to make IBM’s assessed value more consistent with the market price? 

This will provide important insights into whether we assess the current market price to be reasonable or not.  By answering the above question provides rich insight into how IBM is being valued by the market as well as which inputs of our “first pass” analysis may be optimistic.   Given there are three main inputs into the model then sensitivity analysis should focus on the three major inputs – growth behavior, free cash flows and the cost of equity capital.  At the end of the last section it was inferred that IBM’s value could be assessed independently of current growth behavior assumptions.  As a result, the main sensitivity analysis will focus on our assessment of FCFE.  However, first we will reduce growth assessments.

Impact of Stage 1 Growth

We will work with the latter first.  Suppose we predicted zero abnormal growth in excess of normal growth for IBM over stage 1.  That is, assume that the FCFE grows at the normal rate, 0.045, in perpetuity.  This is not realistic for IBM but it will serve as a benchmark.  That is, we are assuming a growth rate equal to the economy wide growth rate for both stages.  So in summary current parameters appear as follows:

This reduces IBM further to $280.56.

Second in our sensitivity analysis, we can consider our FCFE estimate.

Current sales revenue projections for IBM from Yahoo are:

Revenue Growth Forecast = 4.40% for 2010 and 4.10% for 2011.

In the earlier chapter on Accounting Ratios and Firm Decisions the concept of Degree of Operating Leverage was introduced.  This number provides an indication of by how much Operating Earnings will grow by.  Using the default FTS data for IBM the degree of Operating Leverage for IBM is:

 

That is, if sales increase by 4% then Operating Income is predicted to increase by 2.56*0.04 = 0.1024 assuming fixed costs remain fixed.  Thus, the abnormal growth estimate for IBM appears to be reasonable for FCFE.

Sensitivity Analysis on FCFE Estimates

We can now ask the question whether we have greatly overestimated the FCFE?

We next more closely examine the CAPEX assumptions (Source 10K Cash Flow Statement 2009, 2008 and 2007):

In IBM’s 10-K estimate they work with $3.7billion as CAPEX (see earlier).  One quick test for assessing the adequacy of CAPEX is to compare it to Depreciation Expense.  In the normal growth phase we would expect CAPEX to be approximately equal to Depreciation expense.   In the Stage 1 growth phase we would expect it to be higher.  As a result, the IBM estimate for CAPEX is likely to be on the low side. 

From the above disclosures IBM’s CAPEX is around Depreciation for 2009 (3.7 billion versus $3.773 billion).

Remark:  (Significant Other Investing Cash Flow Items):

Observe that Acquisition of businesses, net of cash acquired has a re-occurring net outflow component. 

In other words this pattern of re-occurrence can be interpreted as additional CAPEX.  As a result, we will next adjust CAPEX by the 3-year average of these outflows/inflows = (400 – 1194) + (71 – 6313) +(310 -1009) = 2,578.33.

Adjusted CAPEX = 6.519 + 2.578 = 9.097 billion

Adjusted FCFF = 18.9 – 9.097 = 9.803 billion

Recall, from the earlier calculation of FCFE above the Debt Ratio = 0.239, and

FCFE = FCFF + Debt Ratio*Adjusted CAPEX = 9.903 +9.097*0.239 = 11.977 billion

FCFE per share = 11.977/1.341 = $8.93

As a result, by still working with a complete set of conservative numbers for IBM the intrinsic value assessment is still $275.

As a result, we are left to conclude that the expected return from IBM stock is currently higher than what the cost of equity capital would suggest.  In particular, the implied Expected Return is 11.202%:

Implications for Investors

In the analyses in this chapter, the assessments of IBM’s intrinsic value were all significantly higher than current market prices.  So the question arises: if the intrinsic value is greater, does this have any trading implications?

The answer to this question lies in the Implied Expected Return number provided in Valuation Tutor’s calculator.  This is the expected return implied by IBM’s stock price.  Technically, it is the expected return at which the current stock price equals the intrinsic value.   In the above screen this is 0.11202 and this provides a forecast of IBM’s price in one year.

Projected Stock Price for IBM in 12-months: 

$128.95*1.149 = $148.16

Important Disclaimer:  The above projections are computed from the assessed expected returns resulting from a textbook analysis of IBM’s intrinsic value.  That is, the purpose of this exercise is designed for classroom teaching/learning purposes.  Actual realized returns can vary substantially from what is calculated in this way!