Record
for
the
Final
Metal
Product
and
Machinery
Rule
1234567
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
I&
S_
MPCT_
FINAL.
XLS
FINAL
MP&
M
RULE
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
Sector
Sector
Abbreviation
Values
A
N
IS
CPT
Coef
Cost­
Pass
Through
Coefficient
Values
B
N
76.7%
Long
Name
Sector
Name
Values
C
N
Iron
and
Steel
Total
Cost:
Baseline
Total
Costs
in
the
Baseline
by
Sector,
1996$
Values
D
Y
=
SUMIF(
Base!$
C$
7:$
C$
103,$
A26,
Base!$
E$
7:$
E$
103)
Change
in
Costs
(
Compliance
Costs):
Option
1
Total
Option
1
Compliance
Costs
by
Sector,
1996$
Values
E
Y
=
SUMIF('
O1'!$
C$
6:$
C$
103,$
A26,'
O1'!$
J$
6:$
J$
103)

Change
in
Costs
(
Compliance
Costs):
Option
2
Total
Option
2
Compliance
Costs
by
Sector,
1996$
Values
F
Y
=
SUMIF('
O2'!$
C$
6:$
C$
103,$
A26,'
O2'!$
J$
6:$
J$
103)

Change
in
Costs
(
Compliance
Costs):
Option
3
Total
Option
3
Compliance
Costs
by
Sector,
1996$
Values
G
Y
=
SUMIF('
O3'!$
C$
6:$
C$
103,$
A26,'
O3'!$
J$
6:$
J$
103)

Change
in
Costs
(
Compliance
Costs):
Option
4
Total
Option
4
Compliance
Costs
by
Sector,
1996$
Values
H
Y
=
SUMIF('
O4'!$
C$
6:$
C$
103,$
A26,'
O4'!$
J$
6:$
J$
103)

Post­
Compliance
Price
Change
Factor:
Option
2
Percent
of
Post­
Compliance
Price
Change
in
Option
2
Values
I
N
=
IF(
D26>
0,($
B26*
E26/$
D26)*$
Q26,0)

Post­
Compliance
Price
Change
Factor:
Option
2
Percent
of
Post­
Compliance
Price
Change
in
Option
2
Values
J
N
=
IF(
E26>
0,($
B26*
F26/$
D26)*$
Q26,0)

Post­
Compliance
Price
Change
Factor:
Option
4
Percent
of
Post­
Compliance
Price
Change
in
Option
4
Values
K
N
=
IF(
F26>
0,($
B26*
G26/$
D26)*$
Q26,0)

Post­
Compliance
Price
Change
Factor:
Option
4
Percent
of
Post­
Compliance
Price
Change
in
Option
4
Values
L
N
=
IF(
G26>
0,($
B26*
H26/$
D26)*$
Q26,0)

Moderate
Impacts:
PTRA
Moderate
Impact
Threshold
for
PTRA
Values
M
N
2.5%
Moderate
Impacts:
ICR
Moderate
Impact
Threshold
for
ICR
Values
N
N
2.17
Manufacturing
Output,
1996
Manufacturing
Output
by
Sector,
Census
of
Manufacturers,
1996
Values
O
Y
Baseline
Revenues
Total
Revenues
in
the
Baseline
by
Sector,
1996$
Values
P
Y
=
SUMIF(
Base!$
C$
7:$
C$
953,$
A26,
Base!$
W$
7:$
W$
953)

Percent
Regulated
Percent
of
the
Industry
Regulated
by
Sector
Values
Q
N
=
IF(
P26/
O26>
1,1,
P26/
O26)
SID
Survey
ID
Base
A
N
=
IF(
RawData!
B6<>"",
RawData!
B6,"")
Weight
Sample
Weight
Base
B
Y
=
IF(
ISNA(
VLOOKUP($
A7,
FacData,
2,
FALSE)),
0,
VLOOKUP($
A7,
FacData,
2,
FALSE))
Sector
Primary
Sector
Base
C
Y
=
IF(
ISNA(
VLOOKUP($
A7,
FacData,
4,
FALSE)),"
UNK",
VLOOKUP($
A7,
FacData,
4,
FALSE))

Avg
Revenue
Average
of
Three
Years
of
Revenues
from
the
survey,
1996$
Base
D
Y
=
RawData!
C6
Average
Costs
and
Expenses:
Total
Cost
Average
of
Three
Years
of
Total
Costs
from
the
survey,
1996$
Base
E
Y
=
RawData!
D6
Average
Costs
and
Expenses:
Interest
Average
of
Three
Years
of
Interest
from
the
survey,
1996$
Base
F
Y
=
RawData!
E6
Average
Costs
and
Expenses:
Taxes
Average
of
Three
Years
of
Taxes
from
the
survey,
1996$
Base
G
Y
=
RawData!
F6
Average
Costs
and
Expenses:
Depr
Average
of
Three
Years
of
Depreciation
from
the
survey,
1996$
Base
H
Y
=
RawData!
K6
Adjusted
Tax
Adjusted
tax
rate
includes
the
tax
on
interest
Base
I
Y
=
MAX(
0,
G7+(
F7*
TAX_
RATE))
EBIT
Earnings
Before
Interest
and
Taxes
Base
J
Y
=$
D7­$
E7+$
F7+$
G7
Capital
Expenditures
Capital
Expenditures
Estimate
Base
K
Y
=
AN7*
1000000
Test
of
Net
Present
Value
(
NPV):
Unlevered
ATCF
Unlevered
after­
tax
cash
flow
includes
the
tax
on
interest
Base
L
Y
=
D7­
E7+
H7­
K7+
F7+
G7­
I7
Test
of
Net
Present
Value
(
NPV):
LV
Liquidation
Value
Base
M
Y
0
Test
of
Net
Present
Value
(
NPV):
Tax_
Ben
Tax
Benefit
from
Liquidation
Base
N
Y
0
Test
of
Net
Present
Value
(
NPV):
NPV
Net
Present
Value
Base
O
Y
=
L7/
AMORT_
D
Test
of
Severe
Impacts:
ATCF
Is
After­
Tax
Cash
Flow
positive?
Yes=
1;
No=
0
Base
P
N
0
Test
of
Severe
Impacts:
NPV
Is
Net
Present
Value
positive?
Yes=
1;
No=
1
Base
Q
N
=
IF($
A7>"",
IF(
O7>=
0,1,0),"")
Test
of
Severe
Impacts:
Either
Does
the
site
pass
either
the
ATCF
or
NPV
test?
1=
Yes;
0=
Baseline
Closure
Base
R
N
=
IF(
AND($
A7>"",
D7=
0),
1,
IF($
A7>"",
MAX(
Q7,
P7),""))

February
14,
2003
Page
1
of
24
I&
S_
MPCT_
Final.
xls:
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
123
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
I&
S_
MPCT_
FINAL.
XLS
FINAL
MP&
M
RULE
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
Test
of
Moderate
Impacts:
EBIT/
Total
Assets
Pre­
Tax
Return
on
Sales
Base
S
Y
=
IF(
ISERR(
J7/
Y7),
0.999,
J7/
Y7)

Test
of
Moderate
Impacts:
EBITDA
/
Interest
Expense
Interest
Coverage
Ratio
Base
T
Y
=
IF(
ISERR((
J7+
H7)/
F7),
999,(
J7+
H7)/
F7)

Test
of
Moderate
Impacts:
Pass?
Is
the
PTRA>
8%
and
ICR>
4.0?
1=
Yes;
0=
Moderate
Impact
Base
U
N
=
IF($
C7="","",
IF(
AND(
S7>
VLOOKUP($
C7,
ModerateThresholds,
13,0),
T7>
VLOOKUP($
C7,
Moder
ateThresholds,
14,0)),
1,0))
Opp.
of
U
Opposite
of
Column
W
Base
V
N
=
IF(
U7=
1,0,1)
Wtd
Revs
Sample
Weighted
Revenues,
1996$
Base
W
Y
=
B7*
D7
Inputs
to
Capital
Expenditures
Estimation:
Operating
Income
Operating
Income
Base
X
Y
=
D7­
E7
Inputs
to
Capital
Expenditures
Estimation:
Assets
Assets
Base
Y
Y
=
RawData!
J6
Inputs
to
Capital
Expenditures
Estimation:
ROA
Return
on
Assets
Base
Z
Y
=
IF(
ISERR(
X7/
Y7),"",
X7/
Y7)

Inputs
to
Capital
Expenditures
Estimation:
CAPT
Capital
Turnover
Rate
Base
AA
Y
=
H7/
Y7
Inputs
to
Capital
Expenditures
Estimation:
CAPI
Capital
Intensity
Base
AB
Y
=
Y7/
D7
Inputs
to
Capital
Expenditures
Estimation:
DEBTCST
Debt­
to­
Cost
Ratio
Base
AC
Y
6.4
Inputs
to
Capital
Expenditures
Estimation:
CAPPRC
Price
of
Capital
Equipment
Base
AD
Y
136.9
Inputs
to
Capital
Expenditures
Estimation:
CAPUTIL
Capacity
Utilization
Base
AE
Y
90.82
Estimation
of
Capital
Expenditures:
CAPEX
Capital
Expenditures
Base
AF
Y
=
EXP(
AF$
4)

Estimation
of
Capital
Expenditures:
ROA
Return
on
Assets
Base
AG
Y
=(
Z7+
0.3134659)^
AG$
4
Estimation
of
Capital
Expenditures:
REVENUE
Revenue
Base
AH
Y
=(
D7/
1000000)^
AH$
4
Estimation
of
Capital
Expenditures:
CAPT
Capital
Turnover
Rate
Base
AI
Y
=
AA7^
AI$
4
Estimation
of
Capital
Expenditures:
CAPI
Capital
Intensity
Base
AJ
Y
=
AB7^
AJ$
4
Estimation
of
Capital
Expenditures:
DEBTCST
Debt­
to­
Cost
Ratio
Base
AK
Y
=
AC7^
AK$
4
Estimation
of
Capital
Expenditures:
CAPPRC
Price
of
Capital
Equipment
Base
AL
Y
=
AD7^
AL$
4
Estimation
of
Capital
Expenditures:
CAPUTIL
Capacity
Utilization
Base
AM
Y
=
AE7^
AM$
4
Estimation
of
Capital
Expenditures:
CAPEX
(
mil)
Capital
expenditures
(
millions)
Base
AN
Y
=
PRODUCT(
AF7:
AM7)

SID
Survey
ID
O1,
O2,
O3,
O4
A
N
=
RawData!
B6
Weight
Sample
Weight
O1,
O2,
O3,
O4
B
Y
=
Base!
B7
Sector
Primary
Sector
O1,
O2,
O3,
O4
C
Y
=
Base!
C7
Unweighted
Compliance
Cost:
Capital
Capital
Compliance
Costs,
1996$
O1,
O2,
O3,
O4
D
Y
=
VLOOKUP($
A7,
Costs!$
A$
7:$
M$
331,$
D$
1,0)

Unweighted
Compliance
Cost:
Recurring
Annual
Compliance
Costs,
1996$
O1,
O2,
O3,
O4
E
Y
=
VLOOKUP($
A7,
Costs!$
A$
7:$
M$
331,$
E$
1,0)

Unweighted
Compliance
Cost:
Other
Other
Compliance
Costs,
1996$
O1,
O2,
O3,
O4
F
N
Unweighted
Compliance
Cost:
Pvt_
Cost(
AT)
After­
tax
Compliance
Costs,
1996$
O1,
O2,
O3,
O4
G
Y
=
IF(
J7=
0,0,
J7­(
K7*
TAX_
RATE)+
L7)

Unweighted
Compliance
Cost:
Soc_
Cost
(
BT)
Before­
tax
Compliance
Costs,
1996$
O1,
O2,
O3,
O4
H
Y
=
IF(
OR(
ISNA(
F7),
ISERR(
F7)),
0,
E7+
D7*
AMORT_
O)

Revenue
Change
Change
in
Revenue
based
on
Cost­
Pass
Through
Coefficient
O1,
O2,
O3,
O4
I
Y
=
IF($
A7>"",
VLOOKUP(
C7,
Dprice,
I$
1,
FALSE)*
Base!
D7,0)

February
14,
2003
Page
2
of
24
I&
S_
MPCT_
Final.
xls:
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
123
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
I&
S_
MPCT_
FINAL.
XLS
FINAL
MP&
M
RULE
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
Changes
in
Average
Costs
and
Expenses:
Ann_
Cost
Annualized
Compliance
Costs
O1,
O2,
O3,
O4
J
Y
=
IF(
OR(
ISNA(
F7),
ISERR(
F7)),
0,
E7+
D7*
AMORT_
D)

Changes
in
Average
Costs
and
Expenses:
Interest
Change
in
Interest
from
Baseline
O1,
O2,
O3,
O4
K
Y
=
D7*
0.0485
Changes
in
Average
Costs
and
Expenses:
Taxes
Change
in
Taxes
from
Baseline
O1,
O2,
O3,
O4
L
Y
=(
MIN(
Base!
I7,((
I7­
E7­
M7)*
TAX_
RATE)*­
1))*­
1
Changes
in
Average
Costs
and
Expenses:
Depr
Change
in
Depreciation
from
Baseline
O1,
O2,
O3,
O4
M
Y
=
D7/
Values!$
B$
18
O1,
O2,
O3,
O4
N
Test
of
Net
Present
Value
(
NPV):
After­
Tax
Cash
Flow
(
ATCF)
After­
Tax
Cash
Flow
O1,
O2,
O3,
O4
O
Y
=
Base!
L7+(
I7­
E7)­
L7
Test
of
Net
Present
Value
(
NPV):
NPV
Discounted
Cash
Flow
O1,
O2,
O3,
O4
P
Y
=
O7/
AMORT_
D­
D7
Test
of
Severe
Impacts
(
unwgtd):
ATCF
Is
After­
Tax
Cash
Flow
positive?
Yes=
1;
No=
0
O1,
O2,
O3,
O4
Q
N
0
Test
of
Severe
Impacts
(
unwgtd):
NPV
Is
Net
Present
Value
positive?
Yes=
1;
No=
1
O1,
O2,
O3,
O4
R
N
=
IF($
A7>"",
IF(
P7>=
0,1,0),"")

Test
of
Severe
Impacts
(
unwgtd):
Either
Does
the
site
pass
either
the
ATCF
or
NPV
test?
1=
Yes;
0=
Baseline
Closure
O1,
O2,
O3,
O4
S
N
=
IF(
AND($
A7>"",
Base!
D7=
0),
1,
IF($
A7>"",
MAX(
R7,
Q7),""))

Test
of
Severe
Impacts
(
unwgtd):
Incr?
Is
there
an
incremental
failure
from
the
baseline?
0=
No;
1=
Post­
compliance
Closure
O1,
O2,
O3,
O4
T
N
=
IF(
OR(
Base!
D7=
0,
Base!
E7=
0),
0,
IF($
A7>"",
IF(
S7=
0,
IF(
Base!
R7=
1,1,0),
IF(
AND(
S7=
1,
Base!
R7
=
0),­
1,0)),""))
Test
of
Severe
Impacts
(
wgtd):
Incr?
Weighted
Post­
Compliance
Closures
O1,
O2,
O3,
O4
U
Y
=
T7*$
B7
Test
of
Moderate
Impacts:
EBIT
Earnings
Before
Interest
and
Taxes
O1,
O2,
O3,
O4
V
Y
=(
Base!
J7+
I7)­
E7­
M7
Test
of
Moderate
Impacts:
EBIT/
Total
Assets
Pre­
Tax
Return
on
Sales
O1,
O2,
O3,
O4
W
Y
=
IF(
ISERR(
V7/
Base!
Y7),
0.999,
V7/
Base!
Y7)

Test
of
Moderate
Impacts:
EBITDA
/
Interest
Expense
Interest
Coverage
Ratio
O1,
O2,
O3,
O4
X
Y
=
IF(
ISERR((
V7+(
M7+
Base!
H7))/(
K7+
Base!
F7)),
999,(
V7+(
M7+
Base!
H7))/(
K7+
Base!
F7))

Test
of
Moderate
Impacts:
Incr?
Is
there
an
incremental
failure
from
the
baseline?
0=
No;
1=
Post­
compliance
Moderate
Impact
O1,
O2,
O3,
O4
Y
N
=
IF($
A7'="","",
IF(
AND($
A7>"",
Base!
D7=
0),
0,
IF(
Base!
U7=
0,0,
IF(
AND(
W7>
VLOOKUP($
C7,
Mode
rateThresholds,
13,0),
X7>
VLOOKUP($
C7,
ModerateThresholds,
14,0)),
0,1))))

Post
Compliance
Revenue
Post
Compliance
Revenue
O1,
O2,
O3,
O4
Z
Y
=
Base!$
D7+$
I7
ACC
as
%
of
PCR
Annual
Compliance
Cost
as
a
percent
of
Post
Compliance
Revenue
O1,
O2,
O3,
O4
AA
Y
=
G7/
Z7
SID
Site
ID
RawData
B
=
TEXT(
P6,0)
REV_
AVG
Average
Revenue
RawData
C
Y
=
IF(
ISERR(
SUMIF(
AL6:
AN6,">
0")/
COUNTIF(
AL6:
AN6,">
0")),
0,
SUMIF(
AL6:
AN6,">
0")/
COUNTIF
(
AL6:
AN6,">
0"))
COST_
TOT
Total
Costs
RawData
D
Y
=
IF(
ISERR(
SUMIF(
AO6:
AQ6,">
0")/
COUNTIF(
AO6:
AQ6,">
0")),
0,
SUMIF(
AO6:
AQ6,">
0")/
COUNT
IF(
AO6:
AQ6,">
0"))
COST_
INT
Interest
RawData
E
Y
=
IF(
ISERR(
SUMIF(
AR6:
AT6,">
0")/
COUNTIF(
AR6:
AT6,">
0")),
0,
SUMIF(
AR6:
AT6,">
0")/
COUNTI
F(
AR6:
AT6,">
0"))
COST_
TAX
Taxes
RawData
F
Y
=
IF(
ISERR(
SUMIF(
AU6:
AW6,">
0")/
COUNTIF(
AU6:
AW6,">
0")),
0,
SUMIF(
AU6:
AW6,">
0")/
COUN
TIF(
AU6:
AW6,">
0"))
LV_
NET
Net
LV
RawData
G
Y
INT
Interest
Rate,
Site
RawData
H
Y
=
Int_
Rate
DEBT
Total
Debt
RawData
I
Y
=
AX6+
AY6
ASSETS
Total
Assets
RawData
J
Y
=
AZ6
DEPR
Depreciation
Expense
RawData
K
Y
=
IF(
ISERR(
SUMIF(
BA6:
BC6,">
0")/
COUNTIF(
BA6:
BC6,">
0")),
0,
SUMIF(
BA6:
BC6,">
0")/
COUNTI
F(
BA6:
BC6,">
0"))
CURR_
LIA
Current
Liabilities
RawData
L
Y
=
AX6
NON_
LIA
Non­
Current
Liabilities
RawData
M
Y
=
AY6
FIRM_
REV
Firm
Revenue
RawData
N
Y
=
IF(
ISERR(
SUMIF(
BD6:
BF6,">
0")/
COUNTIF(
BD6:
BF6,">
0")),
0,
SUMIF(
BD6:
BF6,">
0")/
COUNTIF
(
BD6:
BF6,">
0"))
I&
S_
ID
Iron
and
Steel
Survey
ID
RawData
O
Y
SITEID
10
preceding
I&
S
Survey
ID
RawData
P
Y
B12cSite
Total
Income
(
Site)
­
1995
RawData
Q
Y
B13cSite
Total
Income
(
Site)
­
1996
RawData
R
Y
February
14,
2003
Page
3
of
24
I&
S_
MPCT_
Final.
xls:
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
123
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
I&
S_
MPCT_
FINAL.
XLS
FINAL
MP&
M
RULE
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
B14cSite
Total
Income
(
Site)
­
1997
RawData
S
Y
B12gSite
Total
Costs
and
Expenses
(
Site)
­
1995
RawData
T
Y
B13gSite
Total
Costs
and
Expenses
(
Site)
­
1996
RawData
U
Y
B14gSite
Total
Costs
and
Expenses
(
Site)
­
1997
RawData
V
Y
B12iSite
Interest
Income
(
Site)
­
1995
RawData
W
Y
B13iSite
Interest
Income
(
Site)
­
1996
RawData
X
Y
B14iSite
Interest
Income
(
Site)
­
1997
RawData
Y
Y
B12jSite
Taxes
(
Site)
­
1995
RawData
Z
Y
B13jSite
Taxes
(
Site)
­
1996
RawData
AA
Y
B14jSite
Taxes
(
Site)
­
1997
RawData
AB
Y
B15iSite
Current
Liabilities
(
Site)
­
1997
RawData
AC
Y
B15jSite
Long
Term
Debt
(
Site)
­
1997
RawData
AD
Y
B15hSite
Total
Assets
(
Site)
­
1997
RawData
AE
Y
B12eSite
Depreciation
and
Amortization
(
Site)
­
1995
RawData
AF
Y
B13eSite
Depreciation
and
Amortization
(
Site)
­
1996
RawData
AG
Y
B14eSite
Depreciation
and
Amortization
(
Site)
­
1997
RawData
AH
Y
B12cComp
Total
Income
(
Company)
­
1995
RawData
AI
Y
B13cComp
Total
Income
(
Company)
­
1996
RawData
AJ
Y
B14cComp
Total
Income
(
Company)
­
1997
RawData
AK
Y
B12cSite
Total
Income
(
Site)
­
1995
converted
to
1999$
RawData
AL
Y
=
Q6*(
1+(
PPI_
99­
PPI_
95)/
PPI_
95)
B13cSite
Total
Income
(
Site)
­
1996
converted
to
1999$
RawData
AM
Y
=
R6*(
1+(
PPI_
99­
PPI_
96)/
PPI_
96)
B14cSite
Total
Income
(
Site)
­
1997
converted
to
1999$
RawData
AN
Y
=
S6*(
1+(
PPI_
99­
PPI_
97)/
PPI_
97)
B12gSite
Total
Costs
and
Expenses
(
Site)
­
1995
converted
to
1999$
RawData
AO
Y
=
T6*(
1+(
PPI_
99­
PPI_
95)/
PPI_
95)

B13gSite
Total
Costs
and
Expenses
(
Site)
­
1996
converted
to
1999$
RawData
AP
Y
=
U6*(
1+(
PPI_
99­
PPI_
96)/
PPI_
96)

B14gSite
Total
Costs
and
Expenses
(
Site)
­
1997
converted
to
1999$
RawData
AQ
Y
=
V6*(
1+(
PPI_
99­
PPI_
97)/
PPI_
97)

B12iSite
Interest
Income
(
Site)
­
1995
converted
to
1999$
RawData
AR
Y
=
W6*(
1+(
PPI_
99­
PPI_
95)/
PPI_
95)
B13iSite
Interest
Income
(
Site)
­
1996
converted
to
1999$
RawData
AS
Y
=
X6*(
1+(
PPI_
99­
PPI_
96)/
PPI_
96)
B14iSite
Interest
Income
(
Site)
­
1997
converted
to
1999$
RawData
AT
Y
=
Y6*(
1+(
PPI_
99­
PPI_
97)/
PPI_
97)
B12jSite
Taxes
(
Site)
­
1995
converted
to
1999$
RawData
AU
Y
=
Z6*(
1+(
PPI_
99­
PPI_
95)/
PPI_
95)
B13jSite
Taxes
(
Site)
­
1996
converted
to
1999$
RawData
AV
Y
=
AA6*(
1+(
PPI_
99­
PPI_
96)/
PPI_
96)
B14jSite
Taxes
(
Site)
­
1997
converted
to
1999$
RawData
AW
Y
=
AB6*(
1+(
PPI_
99­
PPI_
97)/
PPI_
97)
B15iSite
Current
Liabilities
(
Site)
­
1997
converted
to
1999$
RawData
AX
Y
=
AC6*(
1+(
PPI_
99­
PPI_
97)/
PPI_
97)

B15jSite
Long
Term
Debt
(
Site)
­
1997
converted
to
1999$
RawData
AY
Y
=
AD6*(
1+(
PPI_
99­
PPI_
97)/
PPI_
97)

B15hSite
Total
Assets
(
Site)
­
1997
converted
to
1999$
RawData
AZ
Y
=
AE6*(
1+(
PPI_
99­
PPI_
97)/
PPI_
97)
B12eSite
Depreciation
and
Amortization
(
Site)
­
1995
converted
to
1999$
RawData
BA
Y
=
AF6*(
1+(
PPI_
99­
PPI_
95)/
PPI_
95)

B13eSite
Depreciation
and
Amortization
(
Site)
­
1996
converted
to
1999$
RawData
BB
Y
=
AG6*(
1+(
PPI_
99­
PPI_
96)/
PPI_
96)

B14eSite
Depreciation
and
Amortization
(
Site)
­
1997
converted
to
1999$
RawData
BC
Y
=
AH6*(
1+(
PPI_
99­
PPI_
97)/
PPI_
97)

B12cComp
Total
Income
(
Company)
­
1995
converted
to
1999$
RawData
BD
Y
=
AI6*(
1+(
PPI_
99­
PPI_
95)/
PPI_
95)

B13cComp
Total
Income
(
Company)
­
1996
converted
to
1999$
RawData
BE
Y
=
AJ6*(
1+(
PPI_
99­
PPI_
96)/
PPI_
96)

B14cComp
Total
Income
(
Company)
­
1997
converted
to
1999$
RawData
BF
Y
=
AK6*(
1+(
PPI_
99­
PPI_
97)/
PPI_
97)

SID
Survey
ID
FacData
A
N
Weight
Sample
Weight
FacData
B
Y
=
VLOOKUP($
A6,[
facdata_
Final.
xls]
FacData!$
A$
7:$
K$
1000,
B$
3,0)
Small
Owned
by
a
Small
Entity?
FacData
C
Y
=
VLOOKUP($
A6,[
facdata_
Final.
xls]
FacData!$
A$
7:$
K$
1000,
C$
3,0)
Sector
Primary
Sector
FacData
D
Y
=
VLOOKUP($
A6,[
facdata_
Final.
xls]
FacData!$
A$
7:$
K$
1000,
D$
3,0)
Subcat
Subcategory
FacData
E
Y
=
VLOOKUP($
A6,[
facdata_
Final.
xls]
FacData!$
A$
7:$
K$
1000,
E$
3,0)

February
14,
2003
Page
4
of
24
I&
S_
MPCT_
Final.
xls:
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
123
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
I&
S_
MPCT_
FINAL.
XLS
FINAL
MP&
M
RULE
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
150
151
152
153
154
155
156
157
158
159
160
161
FlowRange
Flow
Category
Range
FacData
F
Y
=
VLOOKUP($
A6,[
facdata_
Final.
xls]
FacData!$
A$
7:$
K$
1000,
F$
3,0)
Direct?
Discharger
Type:
D=
Direct;
I=
Indirect
FacData
G
N
=
VLOOKUP($
A6,[
facdata_
Final.
xls]
FacData!$
A$
7:$
K$
1000,
G$
3,0)
ID
Survey
ID
Costs
A
N
CapCst1
Option
1
Capital
Costs,
1997$
Costs
B
Y
=
VLOOKUP($
A7,'[
CompCost_
Final.
xls]
1997'!$
A$
7:$
S$
1399,
B$
1,
FALSE)
AnnCst1
Option
1
Annual
Costs,
1997$
Costs
C
Y
=
VLOOKUP($
A7,'[
CompCost_
Final.
xls]
1997'!$
A$
7:$
S$
1399,
C$
1,
FALSE)
CC1_
96
Option
1
Costs
Annualized
at
7%
over
15
years,
1997
Costs
D
Y
=
VLOOKUP($
A7,'[
CompCost_
Final.
xls]
1997'!$
A$
7:$
S$
1399,
D$
1,
FALSE)

CapCst2
Option
2
Capital
Costs,
1997$
Costs
E
Y
=
VLOOKUP($
A7,'[
CompCost_
Final.
xls]
1997'!$
A$
7:$
S$
1399,
E$
1,
FALSE)
AnnCst2
Option
2
Annual
Costs,
1997$
Costs
F
Y
=
VLOOKUP($
A7,'[
CompCost_
Final.
xls]
1997'!$
A$
7:$
S$
1399,
F$
1,
FALSE)
CC2_
96
Option
2
Costs
Annualized
at
7%
over
15
years,
1997
Costs
G
Y
=
VLOOKUP($
A7,'[
CompCost_
Final.
xls]
1997'!$
A$
7:$
S$
1399,
G$
1,
FALSE)

CapCst3
Option
3
Capital
Costs,
1997$
Costs
H
Y
=
VLOOKUP($
A7,'[
CompCost_
Final.
xls]
1997'!$
A$
7:$
S$
1399,
H$
1,
FALSE)
AnnCst3
Option
3
Annual
Costs,
1997$
Costs
I
Y
=
VLOOKUP($
A7,'[
CompCost_
Final.
xls]
1997'!$
A$
7:$
S$
1399,
I$
1,
FALSE)
CC3_
96
Option
3
Costs
Annualized
at
7%
over
15
years,
1997
Costs
J
Y
=
VLOOKUP($
A7,'[
CompCost_
Final.
xls]
1997'!$
A$
7:$
S$
1399,
J$
1,
FALSE)

February
14,
2003
Page
5
of
24
I&
S_
MPCT_
Final.
xls:
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
123456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
A
B
C
D
E
F
G
H
I
J
K
L
M
Constants
and
Other
Numeric
Values
blue
numbers
are
exogenous
PPI95
125.5
Producer
Price
Index
for
Industrial
Commodities,
1995
PPI96
127.3
Producer
Price
Index
for
Industrial
Commodities,
1996
PPI97
127.7
Producer
Price
Index
for
Industrial
Commodities,
1997
PPI98
124.8
Producer
Price
Index
for
Industrial
Commodities,
1998
PPI99
126.5
Producer
Price
Index
for
Industrial
Commodities,
1999
RATE_
D
0.07
discount
rate
for
amortization
RATE_
O
0.07
OMB
discount
rate
for
social
opportunity
cost
PERIOD
15
Number
of
years
amortized
AMORT_
D
0.109794625
Amortization
factor,
15
years
AMORT_
O
0.109794625
Amortization
factor,
15
years,
OMB
rate
INFL
0.05
CPI­
U
Inflation
rate,
1996
TAX_
RATE
0.39
Marginal
corporate
tax
rate
DEP_
YRS
15
Number
of
years
depreciated
INT_
RATE
0.07
9
10
11
12
13
Total
Cost
Change
in
Costs
(
Compliance
Costs)
Post­
Compliance
Price
Change
Factor
Sector
CPT
Coef
Long
Name
Baseline
Option
1
Option
2
Option
3
Option
4
Option
1
Option
2
Option
3
Option
4
PTRA
IS
76.7%
Iron
and
Steel
0.00%
0.00%
0.00%
0.00%
2.5%
Moderate
Impacts
February
14,
2003
Page
6
of
24
I&
S_
MPCT_
Final.
xls:
Values
Record
for
the
Final
Metal
Product
and
Machinery
Rule
123456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
N
O
P
Q
14
15
16
17
Percent
of
Industry
Regulated
ICR
Manufacturing
Output,
1996
Baseline
Revenues
Percent
Regulated
2.2
0.0%
Moderate
Impacts
February
14,
2003
Page
7
of
24
I&
S_
MPCT_
Final.
xls:
Values
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1234
5
6
789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
Baseline
Financial
Data
Final
MP&
M
Rule
Test
of
Net
Present
Value
(
NPV)

SID
Weight
Sector
Avg
Revenue
Total
Cost
Interest
Taxes
Depr
Adjusted
Tax
EBIT
Capital
Expenditures
Unlevered
ATCF
LV
Tax_
Ben
NPV
ATCF
NPV
Either
EBIT/
Total
Assets
940
0
1
1
941
0
1
1
943
0
1
1
944
0
1
1
945
0
1
1
946
0
1
1
947
0
1
1
949
0
1
1
950
0
1
1
951
0
1
1
953
0
0
0
954
0
1
1
955
0
1
1
956
0
1
1
957
0
1
1
958
0
0
0
959
0
1
1
960
0
0
1
961
0
1
1
962
0
1
1
963
0
1
1
964
0
1
1
965
0
1
1
966
0
1
1
Test
of
Moderate
Impacts
Pass
Tests?
Average
Costs
and
Expenses
February
14,
2003
Page
8
of
24
I&
S_
MPCT_
Final.
xls:
Base
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1234
5
6
789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
AL
AM
AN
­
2.0774
0.6182
1.0248
0.5995
0.9765
­
0.2050
­
0.4779
0.9043
Opp.
Inputs
to
Estimation
of
Capital
Expenditures
Estimation
of
Capital
Expenditures
EBITDA
/
Interest
Expense
Pass?
of
U
Wtd
Revs
Operating
Income
Assets
ROA
CAPT
CAPI
DEBTCST
CAPPRC
CAPUTIL
CAPEX
ROA
REVENUE
CAPT
CAPI
DEBTCST
CAPPRC
CAPUTIL
CAPEX
(
mil)
1
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
0
1
1
0
1
0
1
0
1
0
0
1
0
1
0
1
1
0
1
0
1
0
1
0
1
0
1
0
Test
of
Moderate
Impacts
February
14,
2003
Page
9
of
24
I&
S_
MPCT_
Final.
xls:
Base
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
34
5
6
789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
A
B
C
D
E
F
G
H
I
J
K
L
M
O
P
Q
R
Option
=
1
3
2
3
6
7
8
9
10
11
12
13
15
16
17
18
Facility
Impacts:
Option
1
(
Oily
Wastes
Directs)
Final
MP&
M
Rule
Option
1
SID
Weight
Sector
Capital
Recurring
Other
Pvt_
Cost(
AT)
Soc_
Cost
Revenue
Change
Ann_
Cost
Interest
Taxes
Depr
After­
Tax
Cash
Flow
(
ATCF)
NPV
ATCF
NPV
940
0
1
941
0
1
943
0
1
944
0
1
945
0
1
946
0
1
947
0
1
949
0
1
950
0
1
951
0
1
953
0
0
954
0
1
955
0
1
956
0
1
957
0
1
958
0
0
959
0
1
960
0
0
961
0
1
962
0
1
963
0
1
964
0
1
965
0
1
966
0
1
Unweighted
Compliance
Cost
Changes
in
Average
Costs
and
Expenses
Test
of
Net
Present
Value
(
NPV)
Pass
Tests?
Unweighted
February
14,
2003
Page
10
of
24
I&
S_
MPCT_
Final.
xls:
O1
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
34
5
6
789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
S
T
U
V
W
X
Y
Z
AA
19
20
21
22
23
24
25
26
28
Wgtd
Either
Incr?
Incr?
EBIT
EBIT/
Total
Assets
EBITDA
/
Interest
Expense
Incr?

1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
0
0
0
1
0
0
1
0
0
1
0
0
1
0
0
0
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
Post
Compliance
Revenue
ACC
as
%
of
PCR
Pass
Tests?
Unweighted
Test
of
Moderate
Impacts
February
14,
2003
Page
11
of
24
I&
S_
MPCT_
Final.
xls:
O1
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
34
5
6
789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
A
B
C
D
E
F
G
H
I
J
K
L
M
O
P
Q
R
Option
=
2
5
6
10
Facility
Impacts:
Option
2
(
Proposed/
NODA
Option)
Final
MP&
M
Rule
Option
2
SID
Weight
Sector
Capital
Recurring
Other
Pvt_
Cost(
AT)
Soc_
Cost
Revenue
Change
Ann_
Cost
Interest
Taxes
Depr
After­
Tax
Cash
Flow
(
ATCF)
DCF
ATCF
NPV
940
0
1
941
0
1
943
0
1
944
0
1
945
0
1
946
0
1
947
0
1
949
0
1
950
0
1
951
0
1
953
0
0
954
0
1
955
0
1
956
0
1
957
0
1
958
0
0
959
0
1
960
0
0
961
0
1
962
0
1
963
0
1
964
0
1
965
0
1
966
0
1
Unweighted
Compliance
Cost
Pass
Tests?
Unweighted
Changes
in
Average
Costs
and
Expenses
Test
of
Net
Present
Value
(
NPV)

February
14,
2003
Page
12
of
24
I&
S_
MPCT_
Final.
xls:
O2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
34
5
6
789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
S
T
U
V
W
X
Y
Z
AA
25
Wgtd
Either
Incr?
Incr?
EBIT
EBIT/
Total
Assets
EBITDA
/
Interest
Expense
Incr?

1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
0
0
0
1
0
0
1
0
0
1
0
0
1
0
0
0
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
ACC
as
%
of
PCR
Test
of
Moderate
Impacts
Pass
Tests?
Unweighted
Post
Compliance
Revenue
February
14,
2003
Page
13
of
24
I&
S_
MPCT_
Final.
xls:
O2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
34
5
6
789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
A
B
C
D
E
F
G
H
I
J
K
L
M
O
P
Q
R
Option
=
3
8
9
11
Facility
Impacts:
Option
3
(
Directs
+
413
to
433
Upgrade)
Final
MP&
M
Rule
Option
3
SID
Weight
Sector
Capital
Recurring
Other
Pvt_
Cost(
AT)
Soc_
Cost
Revenue
Change
Ann_
Cost
Interest
Taxes
Depr
After­
Tax
Cash
Flow
(
ATCF)
DCF
ATCF
NPV
940
0
1
941
0
1
943
0
1
944
0
1
945
0
1
946
0
1
947
0
1
949
0
1
950
0
1
951
0
1
953
0
0
954
0
1
955
0
1
956
0
1
957
0
1
958
0
0
959
0
1
960
0
0
961
0
1
962
0
1
963
0
1
964
0
1
965
0
1
966
0
1
Unweighted
Compliance
Cost
Pass
Tests?
Unweighted
Changes
in
Average
Costs
and
Expenses
Test
of
Net
Present
Value
(
NPV)

February
14,
2003
Page
14
of
24
I&
S_
MPCT_
Final.
xls:
O3
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
34
5
6
789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
S
T
U
V
W
X
Y
Z
AA
25
Wgtd
Either
Incr?
Incr?
EBIT
EBIT/
Total
Assets
EBITDA
/
Interest
Expense
Incr?

1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
0
0
0
1
0
0
1
0
0
1
0
0
1
0
0
0
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
ACC
as
%
of
PCR
Test
of
Moderate
Impacts
Pass
Tests?
Unweighted
Post
Compliance
Revenue
February
14,
2003
Page
15
of
24
I&
S_
MPCT_
Final.
xls:
O3
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
34
5
6
789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
A
B
C
D
E
F
G
H
I
J
K
L
M
O
P
Q
R
Option
=
4
11
12
12
Facility
Impacts:
Option
4
(
Directs
+
All
to
433
Upgrade)
Final
MP&
M
Rule
Option
4
SID
Weight
Sector
Capital
Recurring
Other
Pvt_
Cost(
AT)
Soc_
Cost
Revenue
Change
Ann_
Cost
Interest
Taxes
Depr
After­
Tax
Cash
Flow
(
ATCF)
DCF
ATCF
NPV
940
0
1
941
0
1
943
0
1
944
0
1
945
0
1
946
0
1
947
0
1
949
0
1
950
0
1
951
0
1
953
0
0
954
0
1
955
0
1
956
0
1
957
0
1
958
0
0
959
0
1
960
0
0
961
0
1
962
0
1
963
0
1
964
0
1
965
0
1
966
0
1
Unweighted
Compliance
Cost
Changes
in
Average
Costs
and
Expenses
Test
of
Net
Present
Value
(
NPV)
Pass
Tests?
Unweighted
February
14,
2003
Page
16
of
24
I&
S_
MPCT_
Final.
xls:
O4
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
34
5
6
789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
S
T
U
V
W
X
Y
Z
AA
25
Wgtd
Either
Incr?
Incr?
EBIT
EBIT/
Total
Assets
EBITDA
/
Interest
Expense
Incr?

1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
0
0
0
1
0
0
1
0
0
1
0
0
1
0
0
0
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
Post
Compliance
Revenue
ACC
as
%
of
PCR
Test
of
Moderate
Impacts
Pass
Tests?
Unweighted
February
14,
2003
Page
17
of
24
I&
S_
MPCT_
Final.
xls:
O4
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
A
B
C
D
E
F
G
H
I
J
K
SURVEY
DATA
Copied
data
from
"
Import"
table
in
I&
S_
0313.
mdb
into
blue
shaded
region.

Description
Site
ID
Average
Revenue
Total
Costs
Interest
Taxes
Net
LV
Interest
Rate,
Site
Total
Debt
Total
Assets
Depreciation
Expense
Access
Variable
Name
SID
REV_
AVG
COST_
TOT
COST_
INT
COST_
TAX
LV_
NET
INT
DEBT
ASSETS
DEPR
940
941
943
944
945
946
947
949
950
951
953
954
955
956
957
958
959
960
961
962
963
964
965
966
February
14,
2003
Page
18
of
24
I&
S_
MPCT_
Final.
xls:
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
L
M
N
O
P
Q
R
S
T
U
V
W
Current
Liabilities
Non­
Current
Liabilities
Firm
Revenues
CURR_
LIA
NON_
LIA
FIRM_
REV
I&
S_
ID
SITEID
B12cSite
B13cSite
B14cSite
B12gSite
B13gSite
B14gSite
B12iSite
February
14,
2003
Page
19
of
24
I&
S_
MPCT_
Final.
xls:
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
AI
B13iSite
B14iSite
B12jSite
B13jSite
B14jSite
B15iSite
B15jSite
B15hSite
B12eSite
B13eSite
B14eSite
B12cComp
February
14,
2003
Page
20
of
24
I&
S_
MPCT_
Final.
xls:
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
AJ
AK
AL
AM
AN
AO
AP
AQ
AR
AS
AT
AU
AV
AW
CONVERTS
ALL
SURVEY
DATA
TO
$
1997
B13cComp
B14cComp
B12cSite
B13cSite
B14cSite
B12gSite
B13gSite
B14gSite
B12iSite
B13iSite
B14iSite
B12jSite
B13jSite
B14jSite
February
14,
2003
Page
21
of
24
I&
S_
MPCT_
Final.
xls:
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
AX
AY
AZ
BA
BB
BC
BD
BE
BF
B15iSite
B15jSite
B15hSite
B12eSite
B13eSite
B14eSite
B12cComp
B13cComp
B14cComp
February
14,
2003
Page
22
of
24
I&
S_
MPCT_
Final.
xls:
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
4
5
6789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
A
B
C
D
E
F
G
Facility
Characteristics
From
FACDATA_
FINAL.
XLS
6
4
3
8
5
11
SID
Weight
Small
Sector
Subcat
FlowRange
Direct?
940
I
941
D
943
D
944
I
945
I
946
D
947
D
949
D
950
I
951
D
953
D
954
D
955
I
956
I
957
D
958
D
959
I
960
D
961
D
962
I
963
D
964
D
965
I
966
I
February
14,
2003
Page
23
of
24
I&
S_
MPCT_
Final.
xls:
FacData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
4
5
6789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
A
B
C
D
E
F
G
H
I
J
K
L
M
5
6
7
8
9
10
11
12
13
14
15
16
1
2
3
4
5
6
7
8
9
10
11
12
13
Compliance
Costs
in
1997
Dollars
Final
MP&
M
Rule
Uses
Construction
Cost
Index
to
Update
Compliance
Costs
to
1997
Dollars
SID$
CapCst1
AnnCst1
CC1_
97
CapCst2
AnnCst2
CC2_
97
CapCst3
AnnCst3
CC3_
97
CapCst4
AnnCst4
CC4_
97
940
941
943
944
945
946
947
949
950
951
953
954
955
956
957
958
959
960
961
962
963
964
965
966
February
14,
2003
Page
24
of
24
I&
S_
MPCT_
Final.
xls:
Costs
