The spreadsheet accompanying this solution (sheet 4) sets out a forecast in the same general format as Table 4.4. Historical results from 1999 to 2004 are also shown. Earnings per share (EPS) equals return on equity (ROE) times starting book value per share (BVPS). EPS is divided between dividends and retained earnings, depending on the dividend payout ratio. BVPS grows as retained earnings are reinvested.
The keys to the company’s future value and growth are profitability (ROE) and the reinvestment of retained earnings. Retained earnings are determined by dividend payout. The spreadsheet sets ROE at 15% for the five years from 2006 to 2010. If Reeby Sports will lose its competitive edge by 2011, then it cannot continue earning more than its 10% cost of capital. Therefore ROE is reduced to 10% starting in 2011.
The payout ratio is set at .30 from 2006 onwards. Notice that the long-term growth rate, which settles in between 2011 and 2012, is ROE × ( 1 – dividend payout ratio ) = .10 × (1 - .30) = .07.
The spreadsheet allows you can vary ROE and the dividend payout ratio separately for 2006-2010 and for 2011-2012.1 But let’s start with the initial input values. To calculate share value, we have to estimate a horizon value at 2010 and add its PV to the PV of dividends from 2005 to 2010. Using the constant-growth DCF formula,
The PV of dividends from 2005 to 2010 is $3.43 in 2004, so share value in 2004 is:
The spreadsheet also calculates the PV of dividends through 2012 and the horizon value at 2012. Notice that the PV in 2004 remains at $16.82. This makes sense, since the value of a firm should not depend on the investment horizon chosen for valuation.
We have reduced ROE to the 10% cost of capital after 2010, assuming that the company will have exhausted valuable growth opportunities by that date. With PVGO = 0,