Share-Based Payment Best
Practice Series |
|
ESO
Valuation Disclosure - Dow 30 for FY2010 |
|
|
|
|
|
|
|
Expected |
Contractual |
Expected |
Vesting |
ESO Fair |
Exercise |
Forfeiture |
Valuation |
Granted |
Interest |
Dividend |
|
Symbol |
Company Name |
HQ |
Auditor |
Volatility |
Term (y) |
Term (y) |
Period (y) |
Value ($) |
Multiple |
Rate |
Model |
(millions) |
Rate |
Yield |
Comments |
|
AA |
Alcoa
Inc. |
NY |
PwC |
51.00% |
10 |
5.6 |
3 |
4.67 |
1.35 |
4.00% |
Lattice SOEF |
9.000 |
3.62% |
1.10% |
Exp
Vola range 47-51%; Exer Multiple based on hist avg; Int Rate range
0.14-3.62% |
AXP |
American
Express Company |
NY |
PwC |
41.00% |
10 |
6.2 |
4 |
14.11 |
|
|
BSM |
3.205 |
2.80% |
1.80% |
Exp Vola based on hist and implied vola |
BA |
The
Boeing Company |
IL |
Deloitte |
31.50% |
10 |
6.0 |
3 |
15.70 |
|
|
Black-Scholes |
6.080 |
2.90% |
3.00% |
Exp Vola based on hist and implied vola; Exp Term SAB 110 |
BAC |
Bank of
America Corporation |
NC |
PwC |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
CAT |
Caterpillar
Inc. |
IL |
PwC |
36.40% |
10 |
7.0 |
3 |
22.31 |
|
|
Lattice SOEF |
7.556 |
3.61% |
2.30% |
Exp Vola range 35.2-51.8%; Int Rate range 0.32-3.61%; Exp Term
b/o hist data |
CSCO |
Cisco
Systems, Inc. |
CA |
PwC |
30.50% |
10 |
5.1 |
4 |
6.50 |
|
|
Lattice SOEF |
4.000 |
2.30% |
0.00% |
Skewness 0.2, Kurtosis 4.1; Exp Vola based on implied vola of
2 yr traded option |
CVX |
Chevron
Corporation |
CA |
PwC |
30.80% |
10 |
6.1 |
3 |
16.28 |
|
|
Black-Scholes |
15.454 |
2.90% |
3.90% |
Exp Vola based on hist vola; Exp Term based on hist exer and
post-vest cancellation |
DD |
E.I. du
Pont de Nemours and Co |
DE |
PwC |
32.44% |
7 |
5.3 |
3 |
6.44 |
|
|
Black-Scholes |
6.378 |
2.60% |
4.90% |
Exp Vola based on hist daily vola; Exp Term is based on hist
experience |
DIS |
The Walt
Disney Company |
CA |
PwC |
32.00% |
10 |
- |
4 |
9.43 |
1.40 |
2.50% |
Lattice SOEF |
12.000 |
3.50% |
1.41% |
Exp Vola based on hist and implied vola |
GE |
General
Electric Company |
CT |
KPMG |
35.00% |
10 |
6.9 |
5 |
4.11 |
|
|
Black-Scholes |
105.227 |
2.90% |
3.90% |
Exp Vola based on hist and implied vola; Dividend Yield based
on 5-year hist avg |
HD |
The Home
Depot, Inc. |
GA |
KPMG |
26.40% |
10 |
5.0 |
4 |
6.70 |
|
|
Black-Scholes |
3.723 |
3.10% |
2.90% |
Market Condition Performance Price Target options also granted |
HPQ |
Hewlett-Packard
Company |
CA |
E&Y |
30.00% |
8 |
5.1 |
4 |
13.33 |
|
|
Black-Scholes |
11.939 |
2.06% |
0.68% |
Expected Vola based on implied (ESO), hist (TSR); Exp Term
based on hist data |
IBM |
International
Business Machines |
NY |
PwC |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
INTC |
Intel
Corporation |
CA |
E&Y |
28.00% |
7 |
4.9 |
4 |
4.82 |
|
|
Black-Scholes |
20.200 |
2.50% |
2.70% |
Exp Vola based on implied vola; Exp Term based on simplified
method |
JNJ |
Johnson
& Johnson |
NJ |
PwC |
17.40% |
10 |
6.0 |
4 |
8.03 |
|
|
Black-Scholes |
13.996 |
2.78% |
3.30% |
Exp Vola 4-yr daily hist vola, 5-week avg implied vola of 2-yr
opts; Exp Term hist exp |
JPM |
JP
Morgan Chase & Co. |
NY |
PwC |
37.00% |
10 |
6.4 |
5 |
12.27 |
|
|
Black-Scholes |
- |
3.89% |
3.13% |
Exp Vola based on implied vola; Exp Term hist exp; Exp Div
based on hist yields |
KFT |
Kraft
Foods Inc. |
IL |
PwC |
19.86% |
10 |
6.0 |
3 |
3.69 |
|
|
Black-Scholes |
18.077 |
2.82% |
4.14% |
Exp Vola based on hist vola; Exp Term based on simplified
method |
KO |
The
Coca-Cola Company |
GA |
E&Y |
20.00% |
10 |
6.0 |
4 |
9.39 |
|
|
BSM |
23.000 |
3.00% |
2.90% |
Exp Vola based on hist and implied vola; Exp Term based on
hist exer behavior |
MCD |
McDonald's
Corporation |
IL |
E&Y |
22.10% |
10 |
6.2 |
4 |
9.90 |
|
|
Closed-Form |
4.500 |
2.80% |
3.50% |
Exp Vola based on hist vola; Exp Term based on historical
trends |
MMM |
3M
Company |
MN |
PwC |
25.70% |
10 |
6.0 |
3 |
16.50 |
|
|
Black-Scholes |
5.788 |
2.80% |
2.50% |
Exp Vola avg of hist vola (1-yr, rolling, exp life) and
implied vola |
MRK |
Merck
& Co., Inc. |
NJ |
PwC |
33.70% |
10 |
6.8 |
3 |
7.99 |
|
|
Black-Scholes |
7.508 |
2.80% |
4.10% |
Exp Vola based on hist and implied vola; Contractual Term
range 7-10 yrs |
MSFT |
Microsoft
Corporation |
WA |
Deloitte |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
ESPP and Performance Condition stock awards issued, no ESOs
granted |
PFE |
Pfizer
Inc. |
NY |
KPMG |
26.85% |
10 |
6.3 |
3 |
3.25 |
|
|
BSM |
70.327 |
2.87% |
4.00% |
Exp Vola uses hist and implied vola; Exp Term uses hist exer
and post-vest forf |
PG |
The
Procter & Gamble Company |
OH |
Deloitte |
18.00% |
10 |
8.8 |
3 |
13.47 |
|
|
Lattice SOEF |
26.581 |
3.70% |
2.20% |
Exp Vola range 15-20%; Int Rate range 0.3-4.0%; Exercise
behavior based on hist |
T |
AT&T
Inc. |
TX |
E&Y |
15.75% |
10 |
7.0 |
3 |
1.34 |
|
|
Black-Scholes |
4.00 |
3.06% |
6.61% |
Exp Term based on historical exercise experience |
TRV |
The
Travelers Companies, Inc. |
NY |
KPMG |
28.40% |
10 |
6.0 |
3 |
11.94 |
|
|
Black-Scholes |
2.687 |
2.71% |
2.58% |
Exp Vola range 28.3-29.1%; Int Rate range 1.68-2.71%; Exp Div
range $1.32-1.44 |
UTX |
United
Technologies Corporation |
CT |
PwC |
25.00% |
10 |
7.9 |
3 |
17.86 |
|
|
Binomial Lattice |
0.529 |
4.00% |
2.70% |
Exp Vola range 24-28%; Exp Term range 7.4-7.9 years; Int Rate
range 0.1-4% |
VZ |
Verizon
Communications Inc. |
NY |
E&Y |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
No ESOs since 2004; Restricted Stock Units and Performance
Stock Units |
WMT |
Wal-Mart
Stores, Inc. |
AR |
E&Y |
17.10% |
10 |
6.1 |
5 |
12.53 |
|
|
BSM |
1.921 |
1.80% |
2.30% |
Exp Vola based on hist vola; Exp Term based on hist exercise
and expiration activity |
XOM |
Exxon
Mobil Corporation |
TX |
PwC |
28.50% |
- |
2.5 |
- |
- |
|
|
Monte Carlo |
12.393 |
0.90% |
3.00% |
Monte Carlo simulation, suboptimal exercise factor, hist and
implied vola |
|
|
Average Calculations |
|
28.48% |
9.7 |
6.0 |
3.6 |
|
15.8 |
2.87% |
2.91% |
|
|
Minimum |
|
15.75% |
7.0 |
2.5 |
3.0 |
|
0.90% |
0.00% |
|
|
Maximum |
|
51.00% |
10.0 |
8.8 |
5.0 |
|
4.00% |
6.61% |
|
|
Source:
Company 10-K Reports for FY2010 |
|
Prepared
by: Peter Goodall and Adam Gitzes |
|
Date: September 6,
2011 |
|
|
© Montgomery Investment Technology, Inc. |
|
www.fintools.com |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|