45 Calculating the Cost of Capital
Market value of equity
Cash flow to equity
0
=
∗+
+
=
∞
∑
()
()
1
1
1
g
r
t
E
t
t
where g is anticipated growth rate of cash fl ow to equity.
This gives the formula for the cost of equity r
E
as
r
g
gifg r
EE
=
+
()
+<
Cash flow to equity
Market value of equity
,
0
1
As an example, we consider the following data for Johnson &
Johnson:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
CBADEF
G
Year ending Dividends
Repurchase of
common stock
Stock issues
Cash flow to
equity
Year on
year growth
31-Dec-95 827,000,000 322,000,000 -112,000,000 1,037,000,000 <-- =SUM(B3:D3)
31-Dec-96 974,000,000 412,000,000 -149,000,000 1,237,000,000 19.29% <-- =E4/E3-1
31-Dec-97 1,137,000,000 628,000,000 -225,000,000 1,540,000,000 24.49% <-- =E5/E4-1
31-Dec-98 1,305,000,000 930,000,000 -269,000,000 1,966,000,000 27.66% <-- =E6/E5-1
31-Dec-99 1,479,000,000 840,000,000 -221,000,000 2,098,000,000 6.71%
31-Dec-00 1,724,000,000 973,000,000 -387,000,000 2,310,000,000 10.10%
31-Dec-01 2,047,000,000 2,570,000,000 -514,000,000 4,103,000,000 77.62%
31-Dec-02 2,381,000,000 6,538,000,000 -390,000,000 8,529,000,000 107.87%
31-Dec-03 2,746,000,000 1,183,000,000 -311,000,000 3,618,000,000 -57.58%
31-Dec-04 3,251,000,000 1,384,000,000 -642,000,000 3,993,000,000 10.36%
31-Dec-05 3,793,000,000 1,717,000,000 -696,000,000 4,814,000,000 20.56%
End 2005 equity data
Stock price 61.07
Number of shares 3,119,842,000
Equity value 190,528,750,940 <-- =B16*B17
Equity cash flow, end 2005 4,814,000,000 <-- =E13
Future growth rate
Based on 10-year growth rate 16.59% <-- =(E13/E3)^(1/10)-1
Based on 5-year growth rate 15.82%
Gordon cost of equity, r
E
Based on 10-year growth rate 19.54% <-- =B20*(1+B22)/B18+B22
Based on 5-year growth rate 18.75% <-- =B20*(1+B23)/B18+B23
JOHNSON & JOHNSON, CASH FLOW TO EQUITY, 1995–2005
4. A major problem of computing the total equity cash fl ows is that stock repurchases
and employee stock exercises are only reported in the annual fi nancial statements. Thus
the only data available for these numbers are annual data, whereas dividends are
reported quarterly, and stock price data—used to compute the CAPM beta discussed
in section 2.5—are available on a daily basis.
If we assume that J&J’s historic growth rate of cash fl ow to equity,
16.59 percent, will persist in the indefi nite future, then its cost of equity
is r
E
= 19.54 percent (cell B26).
4