Document ID: EPA-HQ-OW-2002-0033-0095
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2003-04-14T04:00Z

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
39
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
RAILMPCT_
JULY.
XLS
PROPOSED/
NODA
OPTION
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
Sector
Sector
Abbreviation
Values
A
N
RR
CPT
Coef
Cost­
Pass
Through
Coefficient
Values
B
N
88.1%
Long
Name
Sector
Name
Values
C
N
Railroad
Total
Cost:
Baseline
Total
Costs
in
the
Baseline
by
Sector,
1996$
Values
D
Y
=
SUMIF(
Base!$
C$
7:$
C$
148,
A24,
Base!$
E$
7:$
E$
148)
Change
in
Costs
(
Compliance
Costs):
Option
1
Total
Option
1
Compliance
Costs
by
Sector,
1996$
Values
E
Y
=
SUMIF('
O1'!$
C$
6:$
C$
148,
A24,'
O1'!$
J$
6:$
J$
148)

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

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

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

Post­
Compliance
Price
Change
Factor:
Option
1
Percent
of
Post­
Compliance
Price
Change
in
Option
1
Values
I
N
=
IF($
D24>
0,($
B24*
E24/$
D24)*$
Q24,0)

Post­
Compliance
Price
Change
Factor:
Option
2
Percent
of
Post­
Compliance
Price
Change
in
Option
2
Values
J
N
=
IF($
D24>
0,($
B24*
F24/$
D24)*$
Q24,0)

Post­
Compliance
Price
Change
Factor:
Option
3
Percent
of
Post­
Compliance
Price
Change
in
Option
3
Values
K
N
=
IF($
D24>
0,($
B24*
G24/$
D24)*$
Q24,0)

Post­
Compliance
Price
Change
Factor:
Option
4
Percent
of
Post­
Compliance
Price
Change
in
Option
4
Values
L
N
=
IF($
D24>
0,($
B24*
H24/$
D24)*$
Q24,0)

Moderate
Impacts:
PTRA
Moderate
Impact
Threshold
for
PTRA
Values
M
N
3.1%
Moderate
Impacts:
ICR
Moderate
Impact
Threshold
for
ICR
Values
N
N
2.73
Manufacturing
Output,
1996
Manufacturing
Output
by
Sector,
Census
of
Manufacturers,
1996
Values
O
N
7,067,000,000
Baseline
Revenues
Total
Revenues
in
the
Baseline
by
Sector,
1996$
Values
P
Y
Percent
Regulated
Percent
of
the
Industry
Regulated
by
Sector
Values
Q
N
=
IF(
P24/
O24>
1,1,
P24/
O24)
OP­
UNIT
Railroad
Operating
Unit
Base
A
N
=
IF(
RawData!
B6<>"",
RawData!
B6,"")
Weight
Sample
Weight
Base
B
N
=
SUMIF(
FacData!$
A$
6:$
A$
29,
Base!
A7,
FacData!$
C$
6:$
C$
29)
Sector
Primary
Sector
Base
C
N
=
IF(
ISNA(
VLOOKUP($
A7,
FacData,
6,
FALSE)),"
UNK",
VLOOKUP($
A7,
FacData,
6,
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
=
IF(
RawData!
G6=
0,
NA(),
RawData!
G6)
Test
of
Net
Present
Value
(
NPV):
Tax_
Ben
Tax
Benefit
from
Liquidation
Base
N
Y
=(
M7­(
RawData!
J6))*
TAX_
RATE
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
=
J7/
Y7
February
14,
2003
Page
1
of
16
RailMPCT_
July.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
123
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
RAILMPCT_
JULY.
XLS
PROPOSED/
NODA
OPTION
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
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
70
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,
M
oderateThresholds,
14,0)),
1,0))
Opp.
of
W
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
7.11
Inputs
to
Capital
Expenditures
Estimation:
CAPPRC
Price
of
Capital
Equipment
Base
AD
Y
135.4
Inputs
to
Capital
Expenditures
Estimation:
CAPUTIL
Capacity
Utilization
Base
AE
Y
73.69
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)

OP_
UNIT
Railroad
Operating
Unit
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
=
SUMIF(
Costs!$
B$
5:$
B$
28,'
O1'!$
A7,
Costs!
C$
5:
C$
28)
Unweighted
Compliance
Cost:
Recurring
Annual
Compliance
Costs,
1996$
O2
E
Y
=
SUMIF(
Costs!$
B$
5:$
B$
28,'
O1'!$
A7,
Costs!
D$
5:
D$
28)

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(
ISNA(
L7),
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)

February
14,
2003
Page
2
of
16
RailMPCT_
July.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
123
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
RAILMPCT_
JULY.
XLS
PROPOSED/
NODA
OPTION
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
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:
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/
DEP_
YRS
O2
N
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
=
IF(
ISNA(
D7),
O7/
AMORT_
D,
O7/
AMORT_
D­
D7)
Test
of
Severe
Impacts
(
unwgtd):
ATCF
Is
After­
Tax
Cash
Flow
positive?
Yes=
1;
No=
0
O2
Q
N
0
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
!
R7=
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
=
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($
C7="","",
IF(
AND($
A7>"",
Base!
D7=
0),
0,
IF(
Base!
U7=
0,0,
IF(
AND(
W7>
VLOOKUP($
C7,
ModerateThresholds,
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
=
J7/
Z7
OP­
UNIT
Railroad
Operating
Unit
RawData
B
=
TEXT(
N6,0)
REV_
AVG
Average
Revenue
RawData
C
Y
=
IF(
ISERR(
SUMIF(
AO6:
AQ6,">
0")/
COUNTIF(
AO6:
AQ6,">
0")),
0,
SUMIF(
AO6:
AQ6,">
0")/
CO
UNTIF(
AO6:
AQ6,">
0"))
COST_
TOT
Total
Costs
RawData
D
Y
=
IF(
ISERR(
SUMIF(
AR6:
AT6,">
0")/
COUNTIF(
AR6:
AT6,">
0")),
0,
SUMIF(
AR6:
AT6,">
0")/
COU
NTIF(
AR6:
AT6,">
0"))
COST_
INT
Interest
RawData
E
Y
=
IF(
ISERR(
SUMIF(
AU6:
AW6,">
0")/
COUNTIF(
AU6:
AW6,">
0")),
0,
SUMIF(
AU6:
AW6,">
0")/
C
OUNTIF(
AU6:
AW6,">
0"))
COST_
TAX
Taxes
RawData
F
Y
=
IF(
ISERR(
SUMIF(
AX6:
AZ6,">
0")/
COUNTIF(
AX6:
AZ6,">
0")),
0,
SUMIF(
AX6:
AZ6,">
0")/
COU
NTIF(
AX6:
AZ6,">
0"))
LV_
NET
Net
LV
RawData
G
Y
INT
Interest
Rate,
Site
RawData
H
Y
=
IF(
ISBLANK(
AB6),
Int_
Rate,
AB6/
100)
DEBT
Total
Debt
RawData
I
Y
=
IF(
ISERR(
SUMIF(
BA6:
BC6,">
0")/
COUNTIF(
BA6:
BC6,">
0")),
0,
SUMIF(
BA6:
BC6,">
0")/
COU
NTIF(
BA6:
BC6,">
0"))+
IF(
ISERR(
SUMIF(
BD6:
BF6,">
0")/
COUNTIF(
BD6:
BF6,">
0")),
0,
SUMIF
(
BD6:
BF6,">
0")/
COUNTIF(
BD6:
BF6,">
0"))
ASSETS
Total
Assets
RawData
J
Y
=
IF(
ISERR(
SUMIF(
BG6:
BI6,">
0")/
COUNTIF(
BG6:
BI6,">
0")),
0,
SUMIF(
BG6:
BI6,">
0")/
COUN
TIF(
BG6:
BI6,">
0"))
DEPR
Depreciation
Expense
RawData
K
Y
=
IF(
ISERR(
SUMIF(
BJ6:
BL6,">
0")/
COUNTIF(
BJ6:
BL6,">
0")),
0,
SUMIF(
BJ6:
BL6,">
0")/
COUN
TIF(
BJ6:
BL6,">
0"))
CURR_
LIA
Current
Liabilities
RawData
L
Y
=
IF(
ISERR(
SUMIF(
BA6:
BC6,">
0")/
COUNTIF(
BA6:
BC6,">
0")),
0,
SUMIF(
BA6:
BC6,">
0")/
COU
NTIF(
BA6:
BC6,">
0"))
NON_
LIA
Non­
Current
Liabilities
RawData
M
Y
=
IF(
ISERR(
SUMIF(
BD6:
BF6,">
0")/
COUNTIF(
BD6:
BF6,">
0")),
0,
SUMIF(
BD6:
BF6,">
0")/
COU
NTIF(
BD6:
BF6,">
0"))
Op_
Unit
Railroad
Operating
Unit
RawData
N
Y
=
IF(
ISERR(
SUMIF(
BD6:
BF6,">
0")/
COUNTIF(
BD6:
BF6,">
0")),
0,
SUMIF(
BD6:
BF6,">
0")/
COU
NTIF(
BD6:
BF6,">
0"))
TYPE
Survey
Type
RawData
O
Y
REVENU94
Total
Revenue
­
1994
RawData
P
Y
REVENU95
Total
Revenue
­
1995
RawData
Q
Y
REVENU96
Total
Revenue
­
1996
RawData
R
Y
February
14,
2003
Page
3
of
16
RailMPCT_
July.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
123
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
RAILMPCT_
JULY.
XLS
PROPOSED/
NODA
OPTION
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
150
151
152
153
154
TOTAL94
Total
Costs
and
Expenses
­
1994
RawData
S
Y
TOTAL95
Total
Costs
and
Expenses
­
1995
RawData
T
Y
TOTAL96
Total
Costs
and
Expenses
­
1996
RawData
U
Y
INTRST94
Interest
Expense
­
1994
RawData
V
Y
INTRST95
Interest
Expense
­
1995
RawData
W
Y
INTRST96
Interest
Expense
­
1996
RawData
X
Y
TAXES94
Taxes
­
1994
RawData
Y
Y
TAXES95
Taxes
­
1995
RawData
Z
Y
TAXES96
Taxes
­
1996
RawData
AA
Y
INT_
RATE
Interest
Rate
­
1996
RawData
AB
Y
CURLIA94
Current
Liabilities
­
1994
RawData
AC
Y
CURLIA95
Current
Liabilities
­
1995
RawData
AD
Y
CURLIA96
Current
Liabilities
­
1996
RawData
AE
Y
NONLIA94
Noncurrent
Liabilities
­
1994
RawData
AF
Y
NONLIA95
Noncurrent
Liabilities
­
1995
RawData
AG
Y
NONLIA96
Noncurrent
Liabilities
­
1996
RawData
AH
Y
TOTASS94
Total
Assets
­
1994
RawData
AI
Y
TOTASS95
Total
Assets
­
1995
RawData
AJ
Y
TOTASS96
Total
Assets
­
1996
RawData
AK
Y
DEPREC94
Depreciation
Expense
­
1994
RawData
AL
Y
DEPREC95
Depreciation
Expense
­
1995
RawData
AM
Y
DEPREC96
Depreciation
Expense
­
1996
RawData
AN
Y
REVENU94
Total
Revenue
­
1994,
converted
to
1996$
RawData
AO
Y
=
P6*(
1+(
PPI_
96­
PPI_
94)/
PPI_
94)
REVENU95
Total
Revenue
­
1995,
converted
to
1996$
RawData
AP
Y
=
Q6*(
1+(
PPI_
96­
PPI_
95)/
PPI_
95)
REVENU96
Total
Revenue
­
1996$
RawData
AQ
Y
=
R6
TOTAL94
Total
Costs
and
Expenses
­
1994,
converted
to
1996$
RawData
AR
Y
=
S6*(
1+(
PPI_
96­
PPI_
94)/
PPI_
94)

TOTAL95
Total
Costs
and
Expenses
­
1995,
converted
to
1996$
RawData
AS
Y
=
T6*(
1+(
PPI_
96­
PPI_
95)/
PPI_
95)

TOTAL96
Total
Costs
and
Expenses
­
1996$
RawData
AT
Y
=
U6
INTRST94
Interest
Expense
­
1994,
converted
to
1996$
RawData
AU
Y
=
V6*(
1+(
PPI_
96­
PPI_
94)/
PPI_
94)
INTRST95
Interest
Expense
­
1995,
converted
to
1996$
RawData
AV
Y
=
W6*(
1+(
PPI_
96­
PPI_
95)/
PPI_
95)
INTRST96
Interest
Expense
­
1996$
RawData
AW
Y
=
X6
TAXES94
Taxes
­
1994,
converted
to
1996$
RawData
AX
Y
=
Y6*(
1+(
PPI_
96­
PPI_
94)/
PPI_
94)
TAXES95
Taxes
­
1995,
converted
to
1996$
RawData
AY
Y
=
Z6*(
1+(
PPI_
96­
PPI_
95)/
PPI_
95)
TAXES96
Taxes
­
1996$
RawData
AZ
Y
=
AA6
CURLIA94
Current
Liabilities
­
1994,
converted
to
1996$
RawData
BA
Y
=
AC6*(
1+(
PPI_
96­
PPI_
94)/
PPI_
94)
CURLIA95
Current
Liabilities
­
1995,
converted
to
1996$
RawData
BB
Y
=
AD6*(
1+(
PPI_
96­
PPI_
95)/
PPI_
95)
CURLIA96
Current
Liabilities
­
1996$
RawData
BC
Y
=
AE6
NONLIA94
Noncurrent
Liabilities
­
1994,
converted
to
1996$
RawData
BD
Y
=
AF6*(
1+(
PPI_
96­
PPI_
94)/
PPI_
94)

NONLIA95
Noncurrent
Liabilities
­
1995,
converted
to
1996$
RawData
BE
Y
=
AG6*(
1+(
PPI_
96­
PPI_
95)/
PPI_
95)

NONLIA96
Noncurrent
Liabilities
­
1996$
RawData
BF
Y
=
AH6
TOTASS94
Total
Assets
­
1994,
converted
to
1996$
RawData
BG
Y
=
AI6*(
1+(
PPI_
96­
PPI_
94)/
PPI_
94)
TOTASS95
Total
Assets
­
1995,
converted
to
1996$
RawData
BH
Y
=
AJ6*(
1+(
PPI_
96­
PPI_
95)/
PPI_
95)
TOTASS96
Total
Assets
­
1996$
RawData
BI
Y
=
AK6
DEPREC94
Depreciation
Expense
­
1994,
converted
to
1996$
RawData
BJ
Y
=
AL6*(
1+(
PPI_
96­
PPI_
94)/
PPI_
94)

DEPREC95
Depreciation
Expense
­
1995,
converted
to
1996$
RawData
BK
Y
=
AM6*(
1+(
PPI_
96­
PPI_
95)/
PPI_
95)

DEPREC96
Depreciation
Expense
­
1996$
RawData
BL
Y
=
AN6
Op­
Unit
Operating
Unit
ID
FacData
A
N
=
Costs!
B5
SID
Survey
ID
FacData
B
Y
=
Costs!
A5
Weight
Sample
Weight
FacData
C
Y
=
VLOOKUP($
B6,[
FacData_
Final.
xls]
FacData!$
A$
7:$
K$
1000,
C$
3,0)
Firm
FTE
Firm
Employees
FacData
D
Y
February
14,
2003
Page
4
of
16
RailMPCT_
July.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
123
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
RAILMPCT_
JULY.
XLS
PROPOSED/
NODA
OPTION
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
Small
Owned
by
a
Small
Entity?
FacData
E
Y
=
IF(
D6>
E$
2,"
Large",
IF(
D6<
E$
2,"
Small","
n/
a"))
Sector
Primary
Sector
FacData
F
Y
=
VLOOKUP($
B6,[
FacData_
Final.
xls]
FacData!$
A$
7:$
K$
1000,
F$
3,0)
Subcat
Subcategory
FacData
G
Y
=
VLOOKUP($
B6,[
FacData_
Final.
xls]
FacData!$
A$
7:$
K$
1000,
G$
3,0)
Flow
Flow
Category
Range
FacData
H
Y
=
VLOOKUP($
B6,[
FacData_
Final.
xls]
FacData!$
A$
7:$
K$
1000,
H$
3,0)
Dir
Discharger
Type:
D=
Direct;
I=
Indirect
FacData
I
N
=
VLOOKUP($
B6,[
FacData_
Final.
xls]
FacData!$
A$
7:$
K$
1000,
I$
3,0)
SID
Survey
ID
Costs
A
N
OP­
UNIT
Railroad
Operating
Unit
Costs
B
Y
CapCst1
Option
1
Capital
Costs,
1996
Costs
C
Y
=
VLOOKUP($
A5,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1399,
C$
1,0)
AnnCst1
Option
1
Annual
Costs,
1996
Costs
D
Y
=
VLOOKUP($
A5,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1399,
D$
1,0)
CC1_
96
Option
1
Costs
Annualized
at
7%
over
15
years,
1996
Costs
E
Y
=
VLOOKUP($
A5,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1399,
E$
1,0)

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

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

CapCst4
Option
4
Capital
Costs,
1996
Costs
L
Y
=
VLOOKUP($
A5,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1399,
L$
1,0)
AnnCst4
Option
4
Annual
Costs,
1996
Costs
M
Y
=
VLOOKUP($
A5,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1399,
M$
1,0)
CC4_
96
Option
4
Costs
Annualized
at
7%
over
15
years,
1996
Costs
N
Y
=
VLOOKUP($
A5,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1399,
N$
1,0)

February
14,
2003
Page
5
of
16
RailMPCT_
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
A
B
C
D
E
I
M
N
O
P
Q
Constants
and
Other
Numeric
Values
blue
numbers
are
exogenous
PPI94
122.6
Sector­
specific
PPI
for
the
railroad
sector,
1994
PPI95
127.6
Sector­
specific
PPI
for
the
railroad
sector,
1995
PPI96
129.6
Sector­
specific
PPI
for
the
railroad
sector,
1996
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
8
11
12
Total
Cost
Change
in
Costs
(
Compliance
Costs)
Post­
Compliance
Price
Change
Factor
Percent
of
Industry
Regulated
Sector
CPT
Coef
Long
Name
Baseline
Option
1
Option
1
PTRA
ICR
Manufacturing
Output,
1996
Baseline
Revenues
Percent
Regulated
RR
88.1%
Railroad
0.00%
3.3%
0.2%
7,067,000,000
0.0%
Moderate
Impacts
February
14,
2003
Page
6
of
16
RailMPCT_
July.
xls
­
Values
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1234
5
6
789
10
11
12
13
14
15
16
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
Baseline
Financial
Data
Proposed/
NODA
Option
to
the
Final
MP&
M
Rule
Pass
Tests?
Test
of
Moderate
Impacts
OP­
UNIT
Weight
Sector
Avg
Revenue
Total
Cost
Interest
Taxes
Depr
Adjusted
Tax
EBIT
Capital
Expenditures
Unlevered
ATCF
LV
Tax_
Ben
NPV
ATCF
NPV
Either
EBIT/
Revenues
OU­
1
RR
0
1
1
OU­
2
RR
0
1
1
OU­
3
RR
0
1
1
OU­
4
RR
0
1
1
OU­
5
RR
0
1
1
OU­
6
RR
0
0
0
OU­
8
RR
0
0
0
OU­
9
RR
0
1
1
OU­
10
RR
0
1
1
OU­
11
RR
0
1
1
Average
Costs
and
Expenses
Test
of
Net
Present
Value
(
NPV)

February
14,
2003
Page
7
of
16
RailMPCT_
July.
xls
­
Base
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1234
5
6
789
10
11
12
13
14
15
16
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
Test
of
Moderate
Impacts
Inputs
to
Capital
Expenditures
Estimation
Estimation
of
Capital
Expenditures
ICR
Pass?
Opp.
of
W
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
0
1
0
1
1
0
1
0
1
0
February
14,
2003
Page
8
of
16
RailMPCT_
July.
xls
­
Base
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1234
5
6
789
10
11
12
13
14
15
16
A
B
C
D
E
F
G
H
I
J
K
L
M
O
P
Q
R
Option
=
1
3
4
5
6
7
8
8
10
11
12
13
15
16
17
18
Facility
Impacts:
Proposed/
NODA
Option
Costs
as
of
July
19,
2002
Unweighted
Compliance
Cost
Option
2
Changes
in
Average
Costs
and
Expenses
Test
of
Net
Present
Value
(
NPV)
Pass
Tests?
Unweighted
OP­
UNIT
Weight
Sector
Capital
Recurring
Other
Pvt_
Cost(
AT)
Soc_
Cost
(
BT)
Revenue
Change
Ann_
Cost
Interest
Taxes
Depr
After­
Tax
Cash
Flow
(
ATCF)
NPV
ATCF
NPV
OU­
1
0
1
OU­
2
0
1
OU­
3
0
1
OU­
4
0
1
OU­
5
0
1
OU­
6
0
0
OU­
8
0
0
OU­
9
0
1
OU­
10
0
1
OU­
11
0
1
February
14,
2003
Page
9
of
16
RailMPCT_
July.
xls
­
O2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1234
5
6
789
10
11
12
13
14
15
16
S
T
U
V
W
X
Y
Z
AA
19
20
21
22
23
24
25
26
27
Pass
Tests?
Unweighted
Test
of
Moderate
Impacts
Either
Incr?
Wgtd
Incr?
EBIT
EBIT/
Revenues
ICR
Incr?
Post
Compliance
Revenue
ACC
as
%
of
PCR
1
0
0
1
0
0
1
0
0
1
0
0
1
0
0
0
0
0
0
0
0
1
0
0
1
0
0
1
0
0
February
14,
2003
Page
10
of
16
RailMPCT_
July.
xls
­
O2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
4
56789
10
11
12
13
14
15
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
Data
comes
from
Sect4a01.
xls
Data
updated
08/
07/
2000
All
instances
of
"#
DIV/
0!"
replaced
by
zeroes.

Description
Operating
Unit
Average
Revenue
Total
Costs
Interest
Taxes
Net
LV
Interest
Rate,
Site
Total
Debt
Total
Assets
Depreciation
Expense
Current
Liabilities
Non­
Current
Liabilities
Access
Variable
Name
OP­
UNIT
REV_
AVG
COST_
TOT
COST_
INT
COST_
TAX
LV_
NET
INT
DEBT
ASSETS
DEPR
CURR_
LIA
NON_
LIA
Op_
Unit
TYPE
OU­
1
OU­
2
OU­
3
OU­
4
OU­
5
OU­
6
OU­
8
OU­
9
OU­
10
OU­
11
February
14,
2003
Page
11
of
16
RailMPCT_
July.
xls
­
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
4
56789
10
11
12
13
14
15
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
REVENU94
REVENU95
REVENU96
TOTAL94
TOTAL95
TOTAL96
INTRST94
INTRST95
INTRST96
TAXES94
TAXES95
TAXES96
INT_
RATE
CURLIA94
CURLIA95
CURLIA96
NONLIA94
NONLIA95
February
14,
2003
Page
12
of
16
RailMPCT_
July.
xls
­
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
4
56789
10
11
12
13
14
15
AH
AI
AJ
AK
AL
AM
AN
AO
AP
AQ
AR
AS
AT
AU
CONVERTS
ALL
SURVEY
DATA
TO
$
1996
NONLIA96
TOTASS94
TOTASS95
TOTASS96
DEPREC94
DEPREC95
DEPREC96
REVENU94
REVENU95
REVENU96
TOTAL94
TOTAL95
TOTAL96
INTRST94
February
14,
2003
Page
13
of
16
RailMPCT_
July.
xls
­
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
4
56789
10
11
12
13
14
15
AV
AW
AX
AY
AZ
BA
BB
BC
BD
BE
BF
BG
BH
BI
BJ
BK
BL
INTRST95
INTRST96
TAXES94
TAXES95
TAXES96
CURLIA94
CURLIA95
CURLIA96
NONLIA94
NONLIA95
NONLIA96
TOTASS94
TOTASS95
TOTASS96
DEPREC94
DEPREC95
DEPREC96
February
14,
2003
Page
14
of
16
RailMPCT_
July.
xls
­
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1234
5
6789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
A
B
C
D
E
F
G
H
I
Facility
Characteristics
Small
Business
Threshold
for
Railroad
Facilities
1,500
From
FACDATA_
JULY.
XLS
6
4
3
8
5
2
Op­
Unit
SID
Weight
Firm
FTE
Small
Sector
Subcat
Flow
Dir
56
D
80
D
124
D
145
I
158
D
194
D
236
D
238
I
352
D
373
I
382
I
432
D
436
I
500
I
562
I
572
D
596
I
620
I
638
I
659
D
698
I
761
D
798
I
835
D
852
D
881
I
February
14,
2003
Page
15
of
16
RailMPCT_
July.
xls
­
FacData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
234
56789
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
5
6
7
8
9
10
11
12
13
14
15
16
Costs
as
of
July
19,
2002
Option
1
Option
2
(
Proposed/
NODA
Option)
Option
3
Option
4
SID
Op_
Unit
CapCst1
AnnCst1
CC1_
96
CapCst2
AnnCst2
CC2_
96
CapCst3
AnnCst3
CC3_
96
CapCst4
AnnCst4
CC4_
96
56
80
124
145
158
194
236
238
352
373
382
432
436
500
562
572
596
620
638
659
698
761
798
835
852
881
February
14,
2003
Page
16
of
16
RailMPCT_
July.
xls
­
Costs