8.16 Understanding the Numbers
The
following screen provides a breakdown of the valuation model
into its pieces.
First in this current example time 0 = 2009 and we define the
intrinsic value of IBM as the PV of future residual earnings.
The time line for the IBM example is:
1 = 2010, 2 = 2011, 3 = 2012, 4 = 2013, 5 = 2014.
In the following screen the calculations are broken down into
their spreadsheet form. You
can verify the numbers (within rounding) using Excel.
Interpretation of
the rows above:
DPS = Dividend per Share.
For 2010 2.4030 = 8.49 * 0.283 = 2010 projected residual
earnings times the dividend payout ratio
CEPS = Comprehensive Income per share for each year, 2010, 2011,
2012 ….. In the
above screen the CEPS for 2009 = 7.543.
Recall the assumed growth behavior was as follows:
Year 1: 2010 =
7.543*1.1255
Year 2: 2011 =
8.49 * 1.094
Year 3: 2012 =
9.288 * 1.1043
Note:
The above convention is consistent with typical textbook
presentations where the 5-year growth forecast is applied over
years 3-5. However,
a variation that you can use is to compute the implied growth
forecasts for years 3-5 from the 1-year, 2-year and 5-year
forecasts. This is
computed as follows:
Computing Implied forecast for years 3-5:
Recall for 2010 IBM’s growth was forecast to be 0.125, for 2011
this is 0.094 and for the next 5-years 0.1043.
As a result, the annual growth forecasts for 2012, 2013,
2014 is implied from the above three numbers.
That is, 1.125*1.094*x*x*x = 1.1043.
Solving for x yields x= 0.1007.
If you prefer to use this internally consistent number then
change the Stage 1 growth phase number to 0.1007 (for Stage 1
growth because the stage 1 growth is applied to years 3-5 in
this model only because you have direct estimates for CEPS1 and
CEPS2 i.e., years 1 and 2).
If you did this, the calculation details would appear as:
This is a refinement that uses an internally consistent set of
Growth Forecasts.
This can be contrasted with the initial set of numbers (see
below which reveals intrinsic value initial estimate = $205
versus $203). Such
a refinement makes a small difference to the projected intrinsic
value, which may explain why many ignore this and just work
directly with the 5-year growth forecast left.
So we will work with the original abnormal growth number: