HomeMy WebLinkAboutINT Exhibit 101 Campbell.pdfI
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
intermountain Gas Company
Case No. U-l034-88
Exhibit 101
Schedule 1, Page 1 of 4
Wi tness: Campbell
THE RELATIONSHIP BETWEEN MARKET MlD BOOK PRICES
IN REGULATORY PROCEEDINGS
This schedule develops the fact that if the firm's stockholders'
minimally acceptable rate of return is applied to the equity corn-
.ponent of its rate base (book value), then the current market
price of the firm's common equity will approach its current book
value (on a per share basis). Two different approaches are used
to ill ustrate this fact.
APPROACH 1
Let the allowed rate of return on common equity applied to the
equity component of rate base (book value) be designated byII R. IIallowed .If the firm were expected to earn this amount, then
the dollars expected to be available for stockholder distribution
equal:
(1) Dollars Expected to be
Available for Stock-holder Distribution
=(Rallowed) (BVcommon equity)
For simplicity assume that the firm pays out all earnings
available to equity-holders in the form of dividends (this assump-
tion is not necessary for the results but it simplifies the analy-
sis) . Further assume that the firm earns this amount forever.
The maximum current price, "PO", a stockholder will pay (on
a per share basis) to acquire this future stream of expected
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Intermountain Gas Company
Case No. U-l034-88
Exhibit 101
Schedule 1, Page 2 of 4
Wi tness: Campbell
earnings is:
P =o
Dollars Expected to be Available
for Stockholder Distribution (on
a per share basis)
.T R~~i9âJèHö~d!?¥s
( 2)
I f the return allowed is a good estimate of the firm's cost
of common equity (its stockholders' demanded rate of return),
then substituting "Rdemanded by stockholders" for "Rallowed" in
equation (1), dividing both sides by numbers of shares of common
BVt~~O~hãe~H ty
Dollars Available
= for StockholderDistribution
(per share)
~RilemandedOy st:õcRholders
( 3)
Comparing equations (2) and (3) it can be concluded that,
current market prices on a per share basis should have a tendency
to equal current book value per share of common stock, i.e.,
"PO" = "BVcornmon equity (per share)".
APPROACH II
One can also illustrate the fact that current market prices
should roughly equal current book value (on a per share basis) if
the allowed rate of return is applied to the equity component of
rate base (book value) using the Gordon perpetual growth model.
This model, used extensively in finance and by financial
analysts, is presented in Schedule 8 of Exhibit 101. Equation
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Intermountain Gas Company
Case No. U-l034-88
Exhibi t 101
Schedule 1, Page 3 of 4
Wi tness: Campbell
( 5) of Schedule 8, page 3 of 3" contains the Gordon perpetual
growth model (commonly called the DCF method in regulatory
proceedings). It states that:
(1) Po =Di
ke-g
where "P IIo represents the investor's current maximum per share
price he is willing to pay to acquire the firm's common stock,
II Di II represents the future period per share dividend, like ii repre-
sents the stockholder's minimally acceptable rate of return, and
"g" represents the growth rate in per share dividends.
Letting "d" represent the firm's dividend payout ratio and
letting liRa II represent the allowed and expected to be earned rate
of return on the equity component of rate base (current book
value, II BVo" ) on a per share basis, then the expected future per
share dividend, ii Di", equals:
( 2) Di = d Ra BVo
Additionally, to the extent that the firm is retaining and
reinvesting some of its current funds (d ( 1), future dividends
will be able to be higher in the future than the present (g ) 0).
In fact, if the firm was expected to continue to earn liRa ii and
payout "d" percent of its expected earnings available to common,
then:
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Intermountain Gas Company
Case No. U-l034-88
Exhibi t 101
Schedule 1, Page 4 of 4
Wi tness : Campbell
( 3 ) g = (1 - d) Ra
Substituting equation (2) and (3) into equation (1) implies
that current market prices, set by investors, equal:
( 4)Po =dRa BVo
ke-( l-d )Ra
If the allowed rate of return is a good approximation of
investor's demanded rate of return (ke), and the firm can be
reasonably expected to earn this rate, then Ra = ke, and equation
( 4) may be rewritten as equation (5).
( 5)Po =d ke BVo
ke-( l-d )ke
=d ke BVo
d ke
=BVO
Again we are led to conclude that the regulatory process of
applying an estimate of the firm's stockholders' minimally accep-
table rate of return to the equity component of rate base will
result in a tendency for the company's current market price of
common to approximate its current book value (on a per share
basis), if the estimate of the firm's cost of common equity is an
accurate estimate, and if the company is given a fair opportunity
to earn this rate, and if no flotation costs are incurred by the
firm when new common equity is issued or when old common equity
was issued.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Intermountain Gas Company
Case No. U-l034-88
Exhibit 101
Schedule 2, Page 1 of 2
Wi tness: Campbell
FLOTATION COST ADJUSTMENT
Equation (4) of Schedule 1, page 4 of 4, shows that the maxi-
mum per share price that an investor is willing to pay to acquire
a firm's stock is given by:
( 1)Po =dRa BVo
ke- (l-d )Ra
A fair rate of return occurs when the firm can issue new com-
mon stock and net new proceeds at pre-issue book values (on a per
share basis). Thus, a fair market price, if flotation costs are
10%, is stated as:
( 2) Pfair market = 1.11 BVo.
Substi tuting for lip IIo in equation (1) for "Pfair market" in
equation (2) implies that the firm's allowed and fair rate of
return on common equity must solve:
( 3)
dR fairBVa 0
ke (l-d )Ra
= 1. 11 BVo
By equation (3), if the firm retains no earnings (d = 1),
then the fair allowed rate of return equals:
( 4 ) Ra fa i r = (1 . 11) ( ke ) ;
That is, if a firm pays out all of its earnings as dividends, the
fair rate of return that the firm should be given an opportunity
to earn equals, roughly, 1.1 times its stockholders' minimally
I
I
I
I
I
I
,i
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Intermountain Gas Company
Case No. U-l034-88
Exhibi t 101
Sched ule 2, Page 2 of 2
Wi tness: Campbell
acceptable rate of return, "ke",
More generally, for any dividend payout ratio, the flotation
cost adj ustment that is necessary to generate a fair rate of
return on common equity may be specif ied as:
(5 )R fair - k ( 1.11a - e ( I-d) ( 1.11) + d
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Intermountain Gas Company
Case No. U-l034-88
Exhibit 101
Schedule 3, Page 1 of 1
Wi tness: Campbell
AAA CORPORATE BOND YI ELDS
(1950-1979 )
( Source: Moody's Bond Record)
1950
1951
1952
1953
1954
1955
1956
1957
1958
1959
1960
1961
1962
1963
1964
Average AverageYieldYearYield
2.6 1965 4.5
2.9 1966 5.1
3.0 1967 5.5
3.2 1968 6.22.9 1969 7.03.1 1970 8.03.4 1971 7.43.9 1972 7.2
3.8 1973 7.4
4.4 1974 8.64.4 1975 8.84.4 1976 8.44.3 1977 8.04.3 1978 8.74.4 1979 9.6
Year
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Intermountain Gas Company
Case No. U-l034-88
Exhibi t 101
Schedule 4, Page 1 of 1
Wi tness : Campbell
New York Stock Exchange Market Composite
Annual Compounded Rates of Return, 1926-1979
Ending Period Compounded Annual
Rate of Return Ending Period Compounded Annual
Rate of Return
1926
1927
1928
1929
1930
1931
1932
1933
1934
1935
1936
1937
1938
1939
1940
1941
1942
1943
1944
1945
1946
1947
1948
1949
1950
1951
1952
9.57
32.8039.20-14.60-28.42-44.57-8.89
58.56
3.44
44.77
32.80-34.3827.70
1. 87-7.81-9.77
16.66
27.93
21. 17
35.58-6.423.30
2.1320.23
30.46
21.15
13.35
1953
1954
1955
1956
1957
1958
1959
1960
1961
1962
1963
1964
1965
1966
1967
1968
1969
1970
1971
1972
1973
1974
1975
1976
1977
1978
1979
.37
51. 2925.70
8.69-10.77
44.21
13.18
7.56
27.06-9.33
21. 33
16.5013.91-9.06
26.99
12.78-9.80
1.41
15.85
17.87-16.99-26.87
37.8126.36-4.89
7.41
18.50
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Intermountain Gas Company
Case No. U-I034-88
Exhibi t 101
Schedule 5, Page 1 of 1
Wi tness: Campbell
9l-Day U. S. Treasury Bills, 1926-l979,
Stated on an Ann'ual Coupon Basis*
Compounded Annual Compounded AnnualEnding Period Rate of Return Ending Period Rate of Return
1926 3.34 1953 1. 9819273.21 1954 .9719284.13 1955 1.7919294.61 1956 2.7419302.29 1957 3.4019311. 43 1958 1. 891932.90 1959 3.521933.53 1960 3.031934.26 1961 2.451935.14 1962 2.871936.14 1963 3.271937.45 1964 3.671938.05 1965 4.111939.02 1966 5.071940.01 1967 4.481941.10 1968 5.591942.34 1969 7.031943.38 1970 6.781944.38 1971 4.511945.38 1972 4.241946.38 1973 7.461947.60 1974 8.3619481. 06 1975 6.1019491. 12 1976 5.2019501. 25 1977 5.5319511. 59 1978 7.6319521. 82 1979 10.47
* Source:A History of Interest Rates and Federal Reserve Data.-
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Intermountain Gas Company
Case No. U-l034-88
Exhibit 101
Schedule 6, Page 1 of 1
Wi tness: Campbell
30-Day U. S. Treasury Bills, 1926-1979,
Stated on an Annual Coupon Basis*
Ending Period Compounded Annual
Rate of Return Ending Period
Compounded Annual
Rate of Return
1926
1927
1928
1929
1930
1931
1932
1933
1934
1935
1936
1937
1938
1939
1940
1941
1942
1943
1944
1945
1946
1947
1948
1949
1950
1951
1952
3.3
3. 13.24.82.31.1
1. 0
.2
.2.2.2
.30.0
0.0
0.0
.1.2
.3
.3
.3
.4
.5
.81.1
1. 2
1. 5
1. 7
1953
1954
1955
1956
1957
1958
1959
1960
1961
1962
1963
1964
1965
1966
1967
1968
1969
1970
1971
1972
1973
1974
1975
1976
1977
1978
1979
1. 8.9
1. 5
2.53.1
1. 6
3.02.62.22.73.23.5
3.9
4.84.2
5.26.66.54.43.86.98.0
5.8
5: 15.27.1
10.0
*Source: Computer Directions Advisors update of Ibbotson-S inquef ield 's Stocks, Bonds, Bills and Inflation: ThePast and the Future.
I
I
I Intermountain Gas Company
Case No.U-l034-88
Exhibit 10l
I Schedule 7,Page 1 of 3
Wi tness:Campbell
I INTERMOUNTAIN GAS INDUSTRIES
I NYSE CompositeStockCashRate of Rate of Return,
I Datel Price2 Dividend Return3 (1979)4
I 1/31/73 15 2/8 $.26 -7.403 -2.5342/28/73 14 1/8 -7.377 -3.9823/30/73 14 4/8 2.655 -.547
:1
4/30/73 14 3/8 $.26 0.931 -4.6465/31/73 14 -2.609 -1. 8376/29/73 14 2/8 1.786 -.882
I 7/31/73 14 2/8 $.26 1. 825 5.2498/31/73 13 4/8 -5.263 -3.0109/28/73 15 11. ILL 5.243
I 10/31/73 15 5/8 $.30 6.167 -.18511/30/73 14 4/8 -7.200 -11.66712/31/73 15 3.448 1.514
I 1/31/74 14 2/8 $.30 -3.000 -.ll02/28/74 14 3/8 0.877 .336I3/29/74 14 2/8 -0.870 -2.3954/30/74 13 3/8 $.30 -4.035 -4.3225/3l/74 13 -2.804 -3.527I6/28/74 l2 5/8 -2.885 -1. 9397/31/74 11 6/8 $.38 -3.92l -7.2938/30/74 10 6/8 -8.5ll -8.540I9/30/74 10 7/8 1. 163 -ll.01710/31/74 II $.32 4.092 16.76811/29/74 10 2/8 -6.818 -3.995I12/31/74 10 6/8 4.878 -2.32l
1/31/75 12 1/8 $.32 15.767 13.479I2/28/75 11 2/8 -7.216 6.0823/31/75 11 4/8 2.222 2.9454/30/75 10 4/8 $.32 -5.913 4.698I5/30/75 10 3/8 -1. 190 5.4706/30/75 12 7/8 24.096 5.1847/31/75 11 6/8 $.32 -6.252 -6.374I8/29/75 11 4/8 -2.128 -2.0409/30/75 11 6/8 2.174 -3.66210/31/75 12 1/8 $.32 5.915 6.096I11/28/75 12 3/8 2.062 3. lSi12/31/75 12 -3.303 -1.048
I
i
I
I
I
Intermountain Gas Company
Case No.U-l034-88
Exhibit 101
Schedule 7,Page 2 of 3IWi tness:Campbell
I 1/30/76 13 4/8 $.32 15.167 12.5202/27/76 13 2/8 -1. 852 .1273/31/76 13 4/8 1. 887 3.000I4/30/76 12 7/8 $.32 -2.259 -10.8065/28/76 12 6/8 -0.971 -.8826/30/76 12 7/8 0.980 4.725I7/30/76 13 $.32 3.456 -.7508/31/76 13 1/8 0.962 .020
I
9/30/76 14 6/8 12.381 2.57210/29/76 14 5/8 $.325 1. 356 -2.143ll/30/76 15 4/8 5.983 .471
I
12/31/76 15 4/8 0.000 5.855
1/31/77 17 3/8 $.34 14.290 -3.981
I 2/28/77 17 2/8 -0.719 -1.6223/31/77 18 4.348 -1. 0754/29/77 19 $.34 7.444 .388
I
5/31/77 18 2/8 -3.947 -1.2556/30/77 21 6/8 19.178 5.0887/29/77 20 $.35 -6.437 -1. 573
I 8/31/77 17 7/8 -10.625 -1. 4049/30/77 18 3/8 2.797 .06810/31/77 18 3/8 $.35 1. 905 -3.943
I 11/30/77 18 3/8 0.000 4.19812/30/77 18 5/8 $.35 3.265 .526
I 1/31/78 17 6/8 -4.698 -5.6872/28/78 16 3/8 -7.746 -1.2l03/31/78 15 1/8 -7.633 3.186
I 4/28/78 15 $.35 1. 488 8.3375/31/78 14 4/8 -3.333 1.8686/30/78 14 2/8 $.35 0.690 -1. 282
I 7/31/78 15 6/8 10.526 5.6428/31/78 16 1. 587 3.7219/29/78 16 3/8 2.344 -.633
I 10/31/78 12 7/8 $.35 -19.237 -10.176ll/30/78 13 1/8 1. 942 3.13112/29/78 13 1/8 0.000 1.672
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
1/31/792/28/793/30/794/30/79
5/31/796/29/797/31/798/31/799/28/79
Intermountain Gas Company
Case No. U-I034-88
Exhibit 101
Schedule 7, Page 3 of 3Wi tness : Campbell
14 2/8
13 5/8
14 1/8
13 6/8
13 3/814 6/8
14 2/814 3/8
14
$.35 l1. 238-4.386
3.670-0.177-2.727
10.280
-1. 017
0.877-2.609
4.701
-2.8676.045
.630
-1. 430
4.432
1. 482
6.293
.048
$.35
$.35
lLast trading day of the month.
2Bid Price (Source: Standard and Poor's ISL: Daily Stock Price
Index (O-T-C)),3p~Divt - Pt-l' where t = month.
Pt-l
4source: CRSP Data Files.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Intermountain Gas Company
Case No. U-l034-88
Exhibit 10l
Schedule 8, Page 1 of 3Wi tness : Campbell
CAPM and DCF
FORMULAE
Sharpe's market model may be stated as follows:
(1) Rit = Ai + Bi Rmt + Eit,
where "Rit" represents the possible returns of firm "i" 's common
stock during period "t". "Rmt" represents the poss ible return on
the market portfolio during period "t", and "Èit" represents the
possible error terms in this relationship.
Simply stated, the Sharpe market model states that the
returns on security "i" for any time period lit" can be explained
by the returns on the market during that period, plus an error
term "Eit".
The capital asset pricing model is stated as:
(2) E(Ri) = Rf + Bi (E(Rm) - Rfl,-
where liE (Ri)" represents the expected return on the common stock
of firm II i", "Rf" represents the riskfree rate of return, "Bi"
measures the risk (volatility) of firm "i" 's common stock rela--
tive to the average risk of the market, and" (E(Rm) - Rfl "--the
expected return on the stock market in excess of the riskfree
rate--is called the expected market risk premium. It measures
the returns that one should expect, in excess of the riskfree
rate, if the firm's common stock is of average market risk.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Intermountain Gas Company
Case No. U-l034-88
Exhibit 10l
Sched ule 8, Page 2 of 3
Wi tness: Campbell
Using the capital asset pricing model for intermountain,
(3) E(Rintmnt) = Rf + Bintmnt (E(Rm) - Rfl,-
where "E(Rintmnt)" represents the minimal rate of return that
Intermountain's stockholders must expect before they will divert
their funds away from riskfree investing into common stock
investing in Intermountain. And "BIntmnt" represents
Intermountain's beta, or market response coeff icient.
The maximum price an investor is willing to pay for one share
of common stock if mathematically determined by
( 4)Po
00
Z=t-l
Dt
(l+ke)t
f
Because common stock has no maturity, the investor must project
all future cash flows (Dt represents future dividends) that the
stock can be expected to produce over its lifetime. To trans-
form these future expected cash flows to their present value,
these flows are discounted by the investor's minimal1y acceptable
rate of return,"k IIe .Their present value represents the maximum
current price an investor would be willing to pay to acquire the
share of common stock.
If it was assumed that future dividends, on average, can be
expected to increase at a reasonably constant rate of growth,
"g", then "Dt = Do(l+g)tii for any period lit' and equation (4) can
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Intermountain Gas Company
Case No. U-l034-88
Exhibit 101
Schedule 8, Page 3 of 3
wi tness: Campbell
be vastly simplified to the form contained in equation (5).
( 5)Po =Di
ke-g
where "Di" represents the investor's expectation of future annual
dividends, "ke" represents his minimally acceptable rate of
return on the firm's common equity, and "g" represents the
investor's expectation of future dividend growth associated with
this particular share of common stock.
Solving for "k IIe ,the investor's implied minimally acceptable
rate of return from the previous equation, we find that it can be
estimated by using equation (6).
( 6)ke =Di-p +g.