• Home
  • 9.1 Introduction
  • 9.2 Key Concepts
  • 9.3 Normal Earnings
  • 9.4 AEG
  • 9.5 Cost of Capital
  • 9.6 Implied Equivalence: IBM
  • 9.7 Residual Income
  • 9.8 Entering Data via Excel
  • 9.9 Forecasting Price
  • 9.10 Sensitivity Analysis
  • 9.11 Conclusions
  • 9.12 Questions

9.7  Residual Income Exercise: IBM Exercise

We verify for the same cost of equity capital as follows:

Residual Earnings Calculations for IBM:

Difference:  (RE2011) 7.365 – (RE2010) 7.077 = 0.289 which equals the above 2010 Abnormal Earnings Growth above.

This verifies the analytical result for IBM

Finally, in the next section we apply this model to assess intrinsic value.

Working with the Valuation Tutor

First launch the Valuation Tutor and select International Business Machine (IBM), Accounting Valuation Models and select the Abnormal Earnings Growth Valuation as illustrated below:

Next click beside Stage 1 Discount Rate and Stage 2 Discount Rate and select CAPM for each.  The resulting calculator from this step is displayed below:

You can enter values into Valuation Tutor by several methods. 

Enter Data Directly and save your dataset:

You can type each number directly into the above calculator (for non-derived fields).  That is, Stage 1 and Stage 2 discount rates are derived fields from the inputs into CAPM in the above example (e.g., Risk free Rate, Equity Premium and Beta).

Copyright © 2011 OS Financial Trading System. All Rights Reserved.