Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
I&
S_
MPCT_
July.
XLS
PROPOSED/
NODA
OPTION
TO
THE
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
2
Total
Option
2
Compliance
Costs
by
Sector,
1996$
Values
E
Y
=
SUMIF('
O2'!$
C$
6:$
C$
103,$
A26,'
O1'!$
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)

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),""))

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,
Mod
erateThresholds,
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)

February
14,
2003
Page
1
of
17
I&
S_
MPCT_
July.
xls:
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
I&
S_
MPCT_
July.
XLS
PROPOSED/
NODA
OPTION
TO
THE
FINAL
MP&
M
RULE
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
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
O2
A
N
=
RawData!
B6
Weight
Sample
Weight
O2
B
Y
=
Base!
B7
Sector
Primary
Sector
O2
C
Y
=
Base!
C7
Unweighted
Compliance
Cost:
Capital
Capital
Compliance
Costs,
1996$
O2
D
Y
=
VLOOKUP($
A7,
Costs!$
A$
7:$
M$
331,$
D$
1,0)

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

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

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

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

Changes
in
Average
Costs
and
Expenses:
Ann_
Cost
Annualized
Compliance
Costs
O2
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
O2
K
Y
=
D7*
0.0485
Changes
in
Average
Costs
and
Expenses:
Taxes
Change
in
Taxes
from
Baseline
O2
L
Y
=(
MIN(
Base!
I7,((
I7­
E7­
M7)*
TAX_
RATE)*­
1))*­
1
Changes
in
Average
Costs
and
Expenses:
Depr
Change
in
Depreciation
from
Baseline
O2
M
Y
=
D7/
Values!$
B$
18
Test
of
Net
Present
Value
(
NPV):
After­
Tax
Cash
Flow
(
ATCF)
After­
Tax
Cash
Flow
O2
O
Y
=
Base!
L7+(
I7­
E7)­
L7
Test
of
Net
Present
Value
(
NPV):
NPV
Discounted
Cash
Flow
O2
P
Y
=
O7/
AMORT_
D­
D7
Test
of
Severe
Impacts
(
unwgtd):
ATCF
Is
After­
Tax
Cash
Flow
positive?
Yes=
1;
No=
0
O2
Q
N
0
February
14,
2003
Page
2
of
17
I&
S_
MPCT_
July.
xls:
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
I&
S_
MPCT_
July.
XLS
PROPOSED/
NODA
OPTION
TO
THE
FINAL
MP&
M
RULE
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
Test
of
Severe
Impacts
(
unwgtd):
NPV
Is
Net
Present
Value
positive?
Yes=
1;
No=
1
O2
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
O2
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
O2
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!
R
7=
0),­
1,0)),""))
Test
of
Severe
Impacts
(
wgtd):
Incr?
Weighted
Post­
Compliance
Closures
O2
U
Y
=
T7*$
B7
Test
of
Moderate
Impacts:
EBIT
Earnings
Before
Interest
and
Taxes
O2
V
Y
=(
Base!
J7+
I7)­
E7­
M7
Test
of
Moderate
Impacts:
EBIT/
Total
Assets
Pre­
Tax
Return
on
Sales
O2
W
Y
=
IF(
ISERR(
V7/
Base!
Y7),
0.999,
V7/
Base!
Y7)

Test
of
Moderate
Impacts:
EBITDA
/
Interest
Expense
Interest
Coverage
Ratio
O2
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
O2
Y
N
=
IF($
A7'="","",
IF(
AND($
A7>"",
Base!
D7=
0),
0,
IF(
Base!
U7=
0,0,
IF(
AND(
W7>
VLOOKUP($
C7,
Mo
derateThresholds,
13,0),
X7>
VLOOKUP($
C7,
ModerateThresholds,
14,0)),
0,1))))

Post
Compliance
Revenue
Post
Compliance
Revenue
O2
Z
Y
=
Base!$
D7+$
I7
ACC
as
%
of
PCR
Annual
Compliance
Cost
as
a
percent
of
Post
Compliance
Revenue
O2
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")/
COUNT
IF(
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")/
COU
NTIF(
AO6:
AQ6,">
0"))
COST_
INT
Interest
RawData
E
Y
=
IF(
ISERR(
SUMIF(
AR6:
AT6,">
0")/
COUNTIF(
AR6:
AT6,">
0")),
0,
SUMIF(
AR6:
AT6,">
0")/
COUN
TIF(
AR6:
AT6,">
0"))
COST_
TAX
Taxes
RawData
F
Y
=
IF(
ISERR(
SUMIF(
AU6:
AW6,">
0")/
COUNTIF(
AU6:
AW6,">
0")),
0,
SUMIF(
AU6:
AW6,">
0")/
COU
NTIF(
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")/
COUN
TIF(
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")/
COUNT
IF(
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
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
February
14,
2003
Page
3
of
17
I&
S_
MPCT_
July.
xls:
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
I&
S_
MPCT_
July.
XLS
PROPOSED/
NODA
OPTION
TO
THE
FINAL
MP&
M
RULE
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
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
RawData
AO
Y
=
T6*(
1+(
PPI_
99­
PPI_
95)/
PPI_
95)
B13gSite
Total
Costs
and
Expenses
(
Site)
­
1996
converted
to
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_
July.
xls]
FacData!$
A$
7:$
K$
1000,
B$
3,0)
Small
Owned
by
a
Small
Entity?
FacData
C
Y
=
VLOOKUP($
A6,[
facdata_
July.
xls]
FacData!$
A$
7:$
K$
1000,
C$
3,0)
Sector
Primary
Sector
FacData
D
Y
=
VLOOKUP($
A6,[
facdata_
July.
xls]
FacData!$
A$
7:$
K$
1000,
D$
3,0)
Subcat
Subcategory
FacData
E
Y
=
VLOOKUP($
A6,[
facdata_
July.
xls]
FacData!$
A$
7:$
K$
1000,
E$
3,0)
FlowRange
Flow
Category
Range
FacData
F
Y
=
VLOOKUP($
A6,[
facdata_
July.
xls]
FacData!$
A$
7:$
K$
1000,
F$
3,0)
Direct?
Discharger
Type:
D=
Direct;
I=
Indirect
FacData
G
N
=
VLOOKUP($
A6,[
facdata_
July.
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_
July.
xls]
1997'!$
A$
7:$
S$
1399,
B$
1,
FALSE)
AnnCst1
Option
1
Annual
Costs,
1997$
Costs
C
Y
=
VLOOKUP($
A7,'[
CompCost_
July.
xls]
1997'!$
A$
7:$
S$
1399,
C$
1,
FALSE)
CC1_
96
Option
1
Costs
Annualized
at
7%
over
15
years,
Costs
D
Y
=
VLOOKUP($
A7,'[
CompCost_
July.
xls]
1997'!$
A$
7:$
S$
1399,
D$
1,
FALSE)
CapCst2
Option
2
Capital
Costs,
1997$
Costs
E
Y
=
VLOOKUP($
A7,'[
CompCost_
July.
xls]
1997'!$
A$
7:$
S$
1399,
E$
1,
FALSE)
AnnCst2
Option
2
Annual
Costs,
1997$
Costs
F
Y
=
VLOOKUP($
A7,'[
CompCost_
July.
xls]
1997'!$
A$
7:$
S$
1399,
F$
1,
FALSE)
CC2_
96
Option
2
Costs
Annualized
at
7%
over
15
years,
Costs
G
Y
=
VLOOKUP($
A7,'[
CompCost_
July.
xls]
1997'!$
A$
7:$
S$
1399,
G$
1,
FALSE)
CapCst3
Option
3
Capital
Costs,
1997$
Costs
H
Y
=
VLOOKUP($
A7,'[
CompCost_
July.
xls]
1997'!$
A$
7:$
S$
1399,
H$
1,
FALSE)
AnnCst3
Option
3
Annual
Costs,
1997$
Costs
I
Y
=
VLOOKUP($
A7,'[
CompCost_
July.
xls]
1997'!$
A$
7:$
S$
1399,
I$
1,
FALSE)
CC3_
96
Option
3
Costs
Annualized
at
7%
over
15
years,
Costs
J
Y
=
VLOOKUP($
A7,'[
CompCost_
July.
xls]
1997'!$
A$
7:$
S$
1399,
J$
1,
FALSE)
CapCst4
Option
4
Capital
Costs,
1997$
Costs
E
Y
=
VLOOKUP($
A7,'[
CompCost_
July.
xls]
1997'!$
A$
7:$
S$
1399,
K$
1,
FALSE)
AnnCst4
Option
4
Annual
Costs,
1997$
Costs
F
Y
=
VLOOKUP($
A7,'[
CompCost_
July.
xls]
1997'!$
A$
7:$
S$
1399,
L$
1,
FALSE)
CC4_
96
Option
4
Costs
Annualized
at
7%
over
15
years,
Costs
G
Y
=
VLOOKUP($
A7,'[
CompCost_
July.
xls]
1997'!$
A$
7:$
S$
1399,
M$
1,
FALSE)

February
14,
2003
Page
4
of
17
I&
S_
MPCT_
July.
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
I
M
N
O
P
Q
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.03
OMB
discount
rate
for
social
opportunity
cost
PERIOD
15
Number
of
years
amortized
AMORT_
D
0.109794625
Amortization
factor,
15
years
AMORT_
O
0.08376658
Amortization
factor,
15
years,
OMB
rate
INFL
0.05
CPI­
U
Inflation
rate,
1996
TAX_
RATE
0.34
Marginal
corporate
tax
rate
DEP_
YRS
15
Number
of
years
depreciated
INT_
RATE
0.07
9
13
14
15
16
17
Total
Cost
Change
in
Costs
(
Compliance
Costs)
Post­
Compliance
Price
Change
Factor
Percent
of
Industry
Regulated
Sector
CPT
Coef
Long
Name
Baseline
Option
2
Option
2
PTRA
ICR
Manufacturing
Output,
1996
Baseline
Revenues
Percent
Regulated
IS
76.7%
Iron
and
Steel
0.20%
3.8%
1.3%
31.4%
Moderate
Impacts
February
14,
2003
Page
5
of
17
I&
S_
MPCT_
July.
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
Baseline
Financial
Data
Proposed/
NODA
Option
to
the
Final
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
63
0
1
1
66
0
1
1
144
0
1
1
160
0
1
1
168
0
1
1
169
0
1
1
175
0
1
1
180
0
1
1
198
0
1
1
217
0
0
0
220
0
1
1
244
0
1
1
251
0
1
1
256
0
1
1
275
0
1
1
294
0
1
1
297
0
1
1
321
0
1
1
343
0
1
1
344
0
1
1
354
0
1
1
367
0
1
1
389
0
1
1
415
0
1
1
444
0
1
1
454
0
1
1
469
0
1
1
512
0
1
1
529
0
0
0
544
0
1
1
546
0
1
1
559
0
1
1
593
0
1
1
601
0
1
1
618
0
1
1
644
0
1
1
654
0
1
1
676
0
1
1
697
0
1
1
731
0
1
1
742
0
1
1
776
0
1
1
832
0
1
1
838
0
1
1
865
0
1
1
872
0
1
1
876
0
1
1
Pass
Tests?
Average
Costs
and
Expenses
February
14,
2003
Page
6
of
17
I&
S_
MPCT_
July.
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
­
2.0774
0.6182
1.0248
Opp.
Inputs
to
Estimation
of
Capital
Expenditures
EBIT/
Revenue
ICR
Pass?
of
W
Wtd
Revs
Operating
Income
Assets
ROA
CAPT
CAPI
DEBTCST
CAPPRC
CAPUTIL
CAPEX
ROA
REVENUE
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
0
1
1
0
0
1
1
0
1
0
0
1
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
1
0
1
0
0
1
1
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
Test
of
Moderate
Impacts
February
14,
2003
Page
7
of
17
I&
S_
MPCT_
July.
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
AI
AJ
AK
AL
AM
AN
0.5995
0.9765
­
0.2050
­
0.4779
0.9043
Estimation
of
Capital
Expenditures
CAPT
CAPI
DEBTCST
CAPPRC
CAPUTIL
CAPEX
(
mil)

February
14,
2003
Page
8
of
17
I&
S_
MPCT_
July.
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
Option
=
1
3
2
3
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Facility
Impacts:
Proposed/
NODA
Option
Proposed/
NODA
Option
to
the
Final
Rule
Costs
as
of
July
19,
2002
Unweighted
Compliance
Cost
Option
1Changes
in
Average
Costs
and
ExpensesTest
of
Net
Present
Value
(
NPV)
Pass
Tests?
Unweighted
Wgtd
Test
of
Moderate
Impacts
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
Either
Incr?
Incr?
EBIT
63
0
1
1
0
66
0
1
1
0
144
0
1
1
0
160
0
1
1
0
168
0
1
1
0
169
0
1
1
0
175
0
1
1
0
180
0
1
1
0
198
0
1
1
0
217
0
0
0
0
220
0
1
1
0
244
0
1
1
0
251
0
1
1
0
256
0
0
0
1
275
0
0
0
1
294
0
0
0
1
297
0
1
1
0
321
0
1
1
0
343
0
1
1
0
344
0
1
1
0
354
0
1
1
0
367
0
1
1
0
389
0
1
1
0
415
0
1
1
0
444
0
1
1
0
454
0
1
1
0
469
0
1
1
0
512
0
1
1
0
529
0
0
0
0
544
0
1
1
0
546
0
1
1
0
559
0
1
1
0
593
0
1
1
0
601
0
1
1
0
618
0
1
1
0
644
0
1
1
0
654
0
1
1
0
676
0
1
1
0
697
0
1
1
0
731
0
1
1
0
742
0
0
0
1
776
0
1
1
0
832
0
1
1
0
838
0
1
1
0
865
0
1
1
0
872
0
1
1
0
876
0
0
0
1
February
14,
2003
Page
9
of
17
I&
S_
MPCT_
July.
xls:
O2
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
W
X
Y
Z
AA
AB
AC
AD
AE
AF
23
24
25
26
28
29
30
31
32
33
Test
of
Moderate
Impacts
Labor
Cost
Component
EBIT/
Revenue
ICR
Incr?
Post
Compliance
Revenue
ACC
as
%
of
PCR
Operating
Installation
Manufac
Inst
­
1time
Manu
­
1time
0
0
0
0
0
0
0
1
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
1
0
1
0
0
1
1
February
14,
2003
Page
10
of
17
I&
S_
MPCT_
July.
xls:
O2
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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
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.

All
instances
of
"#
DIV/
0!"
replaced
by
zeroes.

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
63
66
144
160
168
169
175
180
198
217
220
244
251
256
275
294
297
321
343
344
354
367
389
415
444
454
469
512
529
544
546
559
593
601
618
644
654
676
697
731
742
776
832
838
865
872
876
February
14,
2003
Page
11
of
17
I&
S_
MPCT_
July.
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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
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
12
of
17
I&
S_
MPCT_
July.
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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
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
13
of
17
I&
S_
MPCT_
July.
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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
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
14
of
17
I&
S_
MPCT_
July.
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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
AX
AY
AZ
BA
BB
BC
BD
BE
BF
B15iSite
B15jSite
B15hSite
B12eSite
B13eSite
B14eSite
B12cComp
B13cComp
B14cComp
February
14,
2003
Page
15
of
17
I&
S_
MPCT_
July.
xls:
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1234
56789
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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
A
B
C
D
E
F
G
Facility
Characteristics
From
FACDATA_
JULY.
XLS
6
4
3
8
5
2
SID
Weight
Small
Sector
Subcat
FlowRange
Direct?
63
D
66
D
144
D
160
I
168
I
169
I
175
I
180
I
198
D
217
I
220
I
244
I
251
D
256
I
275
I
294
D
297
I
321
I
343
I
344
I
354
I
367
I
389
D
415
I
444
I
454
D
469
I
512
I
529
I
544
I
546
D
559
D
593
D
601
I
618
I
644
I
654
I
676
I
697
I
731
D
742
I
776
I
832
I
838
I
865
I
872
I
876
D
February
14,
2003
Page
16
of
17
I&
S_
MPCT_
July.
xls:
FacData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12345
6789
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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
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
1999
Dollars
Costs
as
of
July
19,
2002
Uses
Construction
Cost
Index
to
Update
Compliance
Costs
to
1999
Dollars
SID$
CapCst1
AnnCst1
CC1_
97
CapCst2
AnnCst2
CC2_
97
CapCst3
AnnCst3
CC3_
97
CapCst4
AnnCst4
CC4_
97
63
66
144
160
168
169
175
180
198
217
220
244
251
256
275
294
297
321
343
344
354
367
389
415
444
454
469
512
529
544
546
559
593
601
618
644
654
676
697
731
742
776
832
838
865
872
876
February
14,
2003
Page
17
of
17
I&
S_
MPCT_
July.
xls:
Costs
