Excel Finance Project
For this project, please use Excel to do your calculations and analysis and then type a report in MS Word. Your report should clearly and thoroughly answer the eight questions below. The report should be typed double-spaced using a Times New Roman Font, size 12. Please limit your report to no more than 10 pages. Submit your report and Excel file on Blackboard, as well as provide me a hard copy of your report in class. All of this needs to be completed by the listed due date on the syllabus.
1) What will be the effects of issuing $3 billion of new debt and using the proceeds to repurchase shares on: Wrigley's outstanding shares? on the price per share of Wrigley's stock?
2) What will be the effects of issuing $3 billion of new debt and using the proceeds to pay a dividend on: Wrigley's outstanding shares? on the price per share of Wrigley's stock?
3) What is Wrigley's current (pre-recapitalization) weighted average cost of capital (WACC)?
4) What would you expect to happen to Wrigley's WACC if it issued $3 billion in debt and used the proceeds to pay a dividend or to repurchase shares?
5) What will be Wrigley's current EPS (pre-recapitalization) given the following operating incomes? Assume the following numbers are in millions.
Operating income (EBIT)
-$86
$214
$514
$814
$1,114
$1,414
$1,714
6) What would you expect to happen to Wrigley's EPS if it issued $3 billion in debt and: used the proceeds to pay a dividend? used the proceeds to repurchase shares? Calculate the potential EPS's given the following incomes. Assume the numbers are in millions.
Operating income (EBIT)
-$86
$214
$514
$814
$1,114
$1,414
$1,714
Finally, what can you conclude regarding the re-capitalization strategies? Do you recommend Wrigley to pay a dividend or repurchase shares. Used data or graphs to support your recommendation.
This case was prepared by Robert F. Bruner and Sean D. Carr, research assistant, from public data about the Wm. Wrigley Jr. Company. Other persons and events are fictional. Copyright © 2005 by the University of Virginia Darden School Foundation, Charlottesville, VA. All rights reserved. To order copies, send an e-mail to sales@dardenbusinesspublishing.com. No part of this publication may be reproduced, stored in a retrieval system, used in a spreadsheet, or transmitted in any form or by any means—electronic, mechanical, photocopying, recording, or otherwise—without the permission of the Darden School Foundation.
THE WM. WRIGLEY JR. COMPANY: CAPITAL STRUCTURE, VALUATION, AND COST OF CAPITAL
Interest rates are at their lowest point in 50 years. Yet the use of debt financing by corporations is declining—this happens anyway in a recession. And some deleveraging is due to strategic changes in an industry, such as technological innovation or other developments that increase business risk. But corporate deleveraging seems to have gone too far. CEOs are missing valuable opportunities to create value for their shareholders. In the extreme case, you have mature firms who use no debt at all! Take William Wrigley Jr. Company, for instance. It has a leading market share in a stable low-technology business—it makes chewing gum—and yet has no debt. I bet that if we could persuade Wrigley’s board to do a leveraged recapitalization through a dividend or major share repurchase, we could create significant new value. Susan, please run some numbers on the potential change in value. And get me the names and phone numbers of all of Wrigley’s directors. With those words, Blanka Dobrynin, managing partner of Aurora Borealis LLC, asked
Susan Chandler, an associate, to initiate the research for a potential investment in Wrigley. Aurora Borealis was a hedge fund with about $3 billion under management and an investment strategy that focused on distressed companies, merger arbitrage, change-of-control transactions, and recapitalizations. Dobrynin had immigrated to the United States from Russia in 1991, and had risen quickly to become partner at a major Wall Street firm. In 2000, she founded Aurora Borealis to pursue an “active-investor” strategy. Her typical mode of operation was to identify opportunities for a corporation to restructure, invest significantly in the stock of the target firm, and then undertake a process of persuading management and directors to restructure. Now, in June 2002, Dobrynin could look back on the large returns from the use of that strategy.
Chandler noted that Wrigley’s market value of common equity was about $13.1 billion.
Dobrynin and Chandler discussed the current capital-market conditions and decided to focus on the assumption that Wrigley could borrow $3 billion at a credit rating between BB and B, to yield 13%. Chandler agreed to return soon to discuss the results of her research.
For the exclusive use of Y. Zheng, 2016.
This document is authorized for use only by Yao Zheng in 2016.
UV1373
-2-
The William Wrigley Jr. Company Wrigley was the world’s largest manufacturer and distributor of chewing gum. The firm’s
industry, branded consumer foods and candy, was intensely competitive and was dominated by a few large players. Exhibit 1 gives product profiles of Wrigley and its peers. Over the preceding two years, revenues had grown at an annual compound rate of 10% (earnings at 9%), reflecting the introduction of new products and foreign expansion (Exhibit 2). Historically, the firm had been conservatively financed. At the end of 2001, it had total assets of $1.76 billion and no debt (Exhibit 3). As Exhibit 4 shows, Wrigley’s stock price had significantly outperformed the S&P 500 Composite Index, and was running slightly ahead of its industry index. Estimating the Effect of a Leveraged Recapitalization
Under the proposed leveraged recapitalization, Wrigley would borrow $3 billion and use
it either to pay an equivalent dividend or to repurchase an equivalent value of shares. Chandler knew that this combination of actions could affect the firm’s share value, cost of capital, debt coverage, earnings per share, and voting control. Accordingly, she sought to evaluate the effect of the recapitalization on those areas. She gathered financial data on Wrigley and its peer companies (Exhibit 5).
Impact on share value Chandler recalled that the effect of leverage on a firm could be modeled by using the
adjusted present-value formula, which hypothesized that debt increased the value of a firm by means of shielding cash flows from taxes. Thus, the present value of debt tax shields could be added to the value of the unlevered firm to yield the value of the levered enterprise. The marginal tax rate Chandler proposed to use was 40%, reflecting the sum of federal, state, and local taxes.
Impact on debt rating A key assumption in the analysis would be the debt rating for Wrigley, after assuming $3
billion in debt, and whether the firm could cover the resulting interest payments. Dobrynin had suggested that Chandler should assume Wrigley would borrow $3 billion at a rating between BB and B. Was a rating of BB/B likely? In that regard, Chandler gathered information on the average financial ratios associated with different debt-rating categories (Exhibit 6). Dobrynin thought that Wrigley’s pretax cost of debt would be around 13%. Chandler sought to check that assumption against the capital-market information given in Exhibit 7.
Impact on cost of capital Chandler knew that the maximum value of the firm was achieved when the weighted
average cost of capital (WACC) was minimized. Thus, she intended to estimate what the cost of equity and the WACC might be, if Wrigley pursued this capital-structure change. The projected
For the exclusive use of Y. Zheng, 2016.
This document is authorized for use only by Yao Zheng in 2016.
UV1373
-3-
cost of debt would depend on her assessment of Wrigley’s debt rating after recapitalization and on current capital-market rates (summarized in Exhibit 7).
The cost of equity (KE) could be estimated by using the capital asset pricing model.
Exhibit 7 gives yields on U.S. Treasury instruments, which afforded possible estimates of the risk-free rate of return. The practice at Aurora Borealis was to use an equity-market risk premium of 7.0%. Wrigley’s beta would also need to be relevered to reflect the projected recapitalization.
Chandler wondered whether her analysis covered everything. Where, for instance, should
she take into account potential costs of bankruptcy and distress or the effects of leverage as a signal about future operations? More leverage would also create certain constraints and incentives for management. Where should those be reflected in her analysis?
Impact on reported earnings per share Chandler intended to estimate the expected effect on earnings per share (EPS) that would
occur at different levels of operating income (EBIT) with a change in leverage. The beginnings of an EBIT/EPS analysis are presented in Exhibit 8.
Impact on voting control The William Wrigley Jr. Company had 232.441 million shares outstanding. A repurchase
of shares would alter that amount. The Wrigley family controlled 21% of the common shares outstanding and 58% of Class B common stock, which had superior voting rights to the common stock.1 Assuming the Wrigley family did not sell any shares, how would the share-repurchase alternative affect the family’s voting-control position in the company?
Conclusion Although Susan Chandler’s analysis followed a familiar path, each company that she had
analyzed differed in important respects from previous firms. Blanka Dobrynin paid her to run numbers and, more importantly, to find the differences wherein hidden threats and opportunities lay. Running the numbers was easy for Chandler; drawing profitable insights from them was not.
1 Shares of Class B common stock had 10 votes each; ordinary common shares had one vote each. Class B
shares were restricted in their sale or transfer and could be converted into ordinary common shares on a 1:1 basis. Thus, for purposes of computing per-share values, the total number of shares outstanding for Wrigley consisted of the sum of common shares (189.8 million) and Class B shares (42.641 million), a total of 232.441 million shares.
For the exclusive use of Y. Zheng, 2016.
This document is authorized for use only by Yao Zheng in 2016.
U V
A -F
-1 48
2
-4 -
Ex hi
bi t 1
TH
E W
M . W
R IG
LE Y
J R
. C O
M PA
N Y
: C A
PI TA
L ST
R U
C T
U R
E,
V A
L U
A TI
O N
, A N
D C
O ST
O F
C A
PI T
A L
D
es cr
ip tio
n of
In du
st ry
P ee
r F irm
s C
om pa
ny
D es
cr ip
tio n
C ad
bu ry
S ch
w ep
pe s p
lc
C ad
bu ry
S ch
w ep
pe s
pl c
m ad
e an
d di
st rib
ut ed
c on
fe ct
io na
ry a
nd b
ev er
ag e
pr od
uc ts
w or
ld w
id e.
S ol
d 51
% s
ta ke
i n
C oc
a- C
ol a
an d
Sc hw
ep pe
s B
ev er
ag es
L td
. i n
19 97
; b ev
er ag
e br
an ds
in 1
60 in
te rn
at io
na l m
ar ke
ts in
1 99
9. In
1 99
8, o
w ne
d 40
% o
f A m
er ic
an B
ot tli
ng .
Li ce
ns ed
C ad
bu ry
t o
H er
sh ey
i n
U .S
. A
cq ui
re d
D r.
Pe pp
er /7
U p
in ’
95 ;
H aw
ai ia
n Pu
nc h
in ’
99 ;
an d
Sn ap
pl e
in ’
00 .
Se gm
en t
sa le
s/ op
er at
in g
pr of
its in
’0 1:
b ev
er ag
es , 4
3% /6
1% ; c
on fe
ct io
na ry
, 5 7%
/3 9%
. S al
es b
y re
gi on
: U .K
., 21
% ; U
.S .,
42 %
; A us
tra lia
, 1 0%
; ot
he r (
in cl
ud in
g Eu
ro pe
), 27
% . H
ad 3
6, 46
0 em
pl oy
ee s.
B on
d ra
tin g:
B B
B /B
aa 2.
H
er sh
ey F
oo ds
C or
p.
H er
sh ey
F oo
ds C
or p.
w as
t he
la rg
es t
U .S
. p ro
du ce
r of
c ho
co la
te a
nd n
on ch
oc ol
at e
co nf
ec tio
na ry
p ro
du ct
s (m
aj or
b ra
nd s:
H er
sh ey
’s ,
R ee
se ’s
, C
ad bu
ry ,
K it
K at
, Sw
ee t
Es ca
pe s,
Ta st
eT at
io ns
, Jo
lly R
an ch
er ,
G oo
d &
P le
nt y,
a nd
M ilk
D ud
s) .
So ld
m aj
or ity
o f
pa st
a op
er at
io ns
in 1
/9 9.
A cq
ui re
d C
ad bu
ry U
.S . i
n 9/
88 ; H
en ry
H ei
de in
1 2/
95 ; a
nd L
ea f N
or th
A m
er ic
a in
1 2/
96 . A
dv er
tis in
g co
st s:
4 .2
% o
f ’0
1 sa
le s.
’0 1
de pr
ec ia
tio n
ra te
: 6 .6
% . H
ad 1
4, 40
0 em
pl oy
ee s;
4 0,
30 0
sh ar
eh ol
de rs
. H er
sh ey
T ru
st C
o. o
w ns
1 1.
5% o
f c om
m on
st oc
k an
d 99
.6 %
o f C
la ss
B . B
on d
ra tin
g: A
+/ A
1.
K ra
ft Fo
od s I
nc .
K ra
ft Fo
od s
In c.
w as
t he
l ar
ge st
b ra
nd ed
f oo
d an
d be
ve ra
ge c
om pa
ny h
ea dq
ua rte
re d
in t
he U
.S . a
nd s
ec on
d la
rg es
t w
or ld
w id
e. T
he
co m
pa ny
m ar
ke te
d m
an y
of t
he w
or ld
’s l
ea di
ng f
oo d
br an
ds ,
in cl
ud in
g K
ra ft
ch ee
se ,
M ax
w el
l H
ou se
c of
fe e,
N ab
is co
c oo
ki es
a nd
cr
ac ke
rs , P
hi la
de lp
hi a
cr ea
m c
he es
e, O
sc ar
M ay
er m
ea ts
, a nd
P os
t ce
re al
s. Its
p ro
du ct
s w
er e
so ld
i n
m or
e th
an 1
45 c
ou nt
rie s.
N or
th
A m
er ic
an s
al es
a cc
ou nt
ed f
or 7
4% o
f ’0
1 sa
le s;
in te
rn at
io na
l, 26
% . A
cq ui
re d
N ab
is co
in 1
2/ 00
. H ad
a bo
ut 1
4, 00
0 em
pl oy
ee s.
Ph ili
p M
or ris
o w
ns 8
4% o
f i ts
c om
m on
st oc
k( 3/
02 p
ro xy
). B
on d
ra tin
g: B
B B
+/ A
3.
To ot
si e
R ol
l I nd
us tri
es ,
In c.
To ot
si e
R ol
l In
du st
rie s,
In c.
, pr
od uc
ed c
an dy
. Pr
od uc
ts i
nc lu
de T
oo ts
ie R
ol l,
To ot
si e
Po p,
T oo
ts ie
B ub
bl e
Po p,
a nd
M as
on D
ot s.
A cq
ui re
d B
ra ch
’s C
on fe
ct io
ns ’ A
nd es
C an
di es
in 5
/0 0;
W ar
ne r-
La m
be rt’
s fo
rm er
c ho
co la
te /c
ar am
el b
ra nd
s (J
un io
r M in
ts , S
ug ar
D ad
dy ,
C ha
rle st
on C
he w
, a nd
P om
P om
s) in
9 /8
8; C
el la
C on
fe ct
io ns
in 7
/8 5.
F iv
e pl
an ts
in U
.S .,
on e
in M
ex ic
o. In
t’l o
ps . (
M ex
ic o
an d
C an
ad a)
: 7%
o f ’
01 sa
le s.
H ad
a bo
ut 1
,9 50
e m
pl oy
ee s.
M . J
. & E
. R . G
or do
n co
nt ro
l 7 4%
o f v
ot in
g po
w er
. B on
d ra
tin g:
N /A
. Th
e W
m . W
rig le
y Jr
. C
om pa
ny
Th e
W m
. W
rig le
y Jr
. C
om pa
ny w
as t
he w
or ld
’s l
ar ge
st m
an uf
ac tu
re r
an d
se lle
r of
c he
w in
g gu
m s,
sp ec
ia lty
g um
s, an
d gu
m b
as e.
Pr
in ci
pa l b
ra nd
s: D
ou bl
em in
t, Sp
ea rm
in t,
Ju ic
y Fr
ui t,
B ig
R ed
, W in
te rF
re sh
, E xt
ra , O
rb it,
F re
ed en
t. A
m ur
ol P
ro du
ct s
su bs
id ia
ry m
ad e
no ve
lty g
um s,
in cl
ud in
g B
ub bl
e Ta
pe , B
ig L
ea gu
e C
he w
; m ar
ke ts
H ub
ba B
ub ba
b ub
bl e
gu m
. F or
ei gn
s al
es : 5
8% o
f 2 00
1 to
ta l,
58 %
o f
pr et
ax p
ro fit
. H ad
1 0,
80 0
em pl
oy ee
s; 3
8, 70
1 co
m m
on sh
ar eh
ol de
rs . W
ill ia
m W
rig le
y Jr
. o w
ne d
21 %
o f c
om m
on st
oc k
an d
58 %
o f C
la ss
B
. B on
d ra
tin g:
N /A
. So
ur ce
s o f i
nf or
m at
io n:
V al
ue L
in e
In ve
st m
en t S
ur ve
y; B
lo om
be rg
L P.
For the exclusive use of Y. Zheng, 2016.
This document is authorized for use only by Yao Zheng in 2016.
UVA-F-1482
-5-
Exhibit 2
THE WM. WRIGLEY JR. COMPANY: CAPITAL STRUCTURE, VALUATION, AND COST OF CAPITAL
Income Statements for the Wm. Wrigley Jr. Company
(in thousands, except per-share amounts) 2001 2000 1999 Earnings Net sales 2,429,646$ 2,145,706$ 2,061,602$ Cost of sales 997,054 904,266 904,183 Gross profit 1,432,592 1,241,440 1,157,419 Selling, general and admininstrative expenses 919,236 778,197 721,813 Operating income 513,356 463,243 435,606 Investment income 18,553 19,185 17,636 Other expense (4,543) (3,116) (8,812) Earnings before income taxes 527,366 479,312 444,430 Income taxes 164,380 150,370 136,247 Net earnings 362,986$ 328,942$ 308,183$
Per-share amounts Net earnings per share of common stock 1.61$ 1.45$ 1.33$ Dividends paid per share of common stock 0.745$ 0.70$ 0.66$
year ended December 31
Source of data: Company regulatory filings.
For the exclusive use of Y. Zheng, 2016.
This document is authorized for use only by Yao Zheng in 2016.
UVA-F-1482
-6-
Exhibit 3
THE WM. WRIGLEY JR. COMPANY: CAPITAL STRUCTURE, VALUATION, AND COST OF CAPITAL
Consolidated Balance Sheets for the Wm. Wrigley Jr. Company
(in thousands of dollars) 2001 2000 ASSETS Current assets:
Cash and equivalents 307,785$ 300,599$ Short-term investments, at amortized cost 25,450 29,301 Accounts receivable 239,885 191,570 Inventories
Finished goods 75,693 64,676 Raw materials and supplies 203,288 188,615
278,981 253,291 Other current assets 46,896 39,728 Deferred income taxes - current 14,846 14,226 Total current assets 913,843 828,715
Marketable equity securities, at fair value 25,300 28,535 Deferred charges and other assets 115,745 83,713 Deferred income taxes - noncurrent 26,381 26,743 Property, plant, and equipment (at cost) Land 39,933 39,125 Buildings and building equipment 359,109 344,457 Machinery and equipment 857,044 756,050
1,256,086 1,139,632 Less accumulated depreciation 571,717 532,598
Net property, plant and equipment 684,379 607,034 TOTAL ASSETS 1,765,648$ 1,574,740$
LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities:
Accounts payable 91,225$ 73,129$ Accrued expenses 128,406 113,779 Dividends payable 42,711 39,467 Income and other taxes payable 68,437 60,976 Deferred income taxes - current 1,455 859 Total current liabilities 332,234 288,210
Deferred income taxes - noncurrent 43,206 40,144 Other non-current liabilities 113,921 113,489 Common stock 12,646 12,558 Class B convertible stock 2,850 2,938 Additional paid-in capital 1,153 346 Retained earnings 1,684,337 1,492,547 Treasury stock (289,799) (256,478) Accumulated other comprehensive income (134,900) (119,014) Total stockholders' equity 1,276,287 1,132,897 TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY 1,765,648$ 1,574,740$
Source of data: Company regulatory filings.