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

Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
RAILMPCT_
FINAL.
XLS
FINAL
MP&
M
RULE
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
Y
=
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
1
of
23
RailMPCT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
RAILMPCT_
FINAL.
XLS
FINAL
MP&
M
RULE
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
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
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
N
=
Base!
C7
Unweighted
Compliance
Cost:
Capital
Capital
Compliance
Costs,
1996$
O1,
O2,
O3,
O4
D
Y
=
SUMIF(
Costs!$
B$
5:$
B$
28,'
O1'!$
A7,
Costs!
C$
5:
C$
28)
Unweighted
Compliance
Cost:
Recurring
Annual
Compliance
Costs,
1996$
O1,
O2,
O3,
O4
E
Y
=
SUMIF(
Costs!$
B$
5:$
B$
28,'
O1'!$
A7,
Costs!
D$
5:
D$
28)

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

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
February
14,
2003
2
of
23
RailMPCT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
RAILMPCT_
FINAL.
XLS
FINAL
MP&
M
RULE
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
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/
DEP_
YRS
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
=
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
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
=
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($
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
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
=
J7/
Z7
OP­
UNIT
Railroad
Operating
Unit
RawData
B
N
=
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
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
February
14,
2003
3
of
23
RailMPCT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
RAILMPCT_
FINAL.
XLS
FINAL
MP&
M
RULE
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
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
Y
=
Costs!
B5
SID
Survey
ID
FacData
B
N
=
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
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)

February
14,
2003
4
of
23
RailMPCT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
RAILMPCT_
FINAL.
XLS
FINAL
MP&
M
RULE
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
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)

February
14,
2003
5
of
23
RailMPCT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
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.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
RR
88.1%
Railroad
0.00%
0.00%
0.00%
0.00%
3.1%
Moderate
Impacts
February
14,
2003
6
of
23
RailMPCT_
Final.
xls
­
Values
Record
for
the
Final
Metal
Product
and
Machinery
Rule
14
Percent
of
Industry
Regulated
ICR
Manufacturing
Output,
1996
Baseline
Revenues
Percent
Regulated
2.7
7,067,000,000
0.0%
Moderate
Impacts
February
14,
2003
7
of
23
RailMPCT_
Final.
xls
­
Values
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Baseline
Financial
Data
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/
Total
Assets
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
1
OU­
8
RR
0
0
0
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
8
of
23
RailMPCT_
Final.
xls
­
Base
Record
for
the
Final
Metal
Product
and
Machinery
Rule
­
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
EBITDA
/
Interest
Expense
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
February
14,
2003
9
of
23
RailMPCT_
Final.
xls
­
Base
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Option
=
1
3
4
5
6
7
8
9
10
11
12
13
15
16
17
18
19
Facility
Impacts:
Option
1
(
Oily
Wastes
Directs)
Final
MP&
M
Rule
Unweighted
Compliance
Cost
Option
1
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
Either
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­
10
RR
0
1
1
OU­
11
RR
0
1
1
February
14,
2003
10
of
23
RailMPCT_
Final.
xls
­
O1
Record
for
the
Final
Metal
Product
and
Machinery
Rule
20
21
22
23
24
25
26
27
Tests?
Unweighted
Test
of
Moderate
Impacts
Incr?
Wgtd
Incr?
EBIT
EBIT/
Total
Assets
EBITDA
/
Interest
Expense
Incr?
Post
Compliance
Revenue
ACC
as
%
of
PCR
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
February
14,
2003
11
of
23
RailMPCT_
Final.
xls
­
O1
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Option
=
2
3
4
5
6
7
8
10
10
11
12
13
15
16
17
18
Facility
Impacts:
Option
2
(
Proposed/
NODA
Option)
Final
MP&
M
Rule
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
RR
0
1
OU­
2
RR
0
1
OU­
3
RR
0
1
OU­
4
RR
0
1
OU­
5
RR
0
1
OU­
6
RR
0
0
OU­
8
RR
0
0
OU­
10
RR
0
1
OU­
11
RR
0
1
February
14,
2003
12
of
23
RailMPCT_
Final.
xls
­
O2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
19
20
21
22
23
24
25
26
27
Pass
Tests?
Unweighted
Test
of
Moderate
Impacts
Either
Incr?
Wgtd
Incr?
EBIT
EBIT/
Total
Assets
EBITDA
/
Interest
Expense
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
February
14,
2003
13
of
23
RailMPCT_
Final.
xls
­
O2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Option
=
3
11
Facility
Impacts:
Option
3
(
Directs
+
413
to
433
Upgrade)
Final
MP&
M
Rule
Unweighted
Compliance
Cost
Option
3
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
RR
0
1
OU­
2
RR
0
1
OU­
3
RR
0
1
OU­
4
RR
0
1
OU­
5
RR
0
1
OU­
6
RR
0
0
OU­
8
RR
0
0
OU­
10
RR
0
1
OU­
11
RR
0
1
February
14,
2003
14
of
23
RailMPCT_
Final.
xls
­
O3
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Pass
Tests?
Unweighted
Test
of
Moderate
Impacts
Either
Incr?
Wgtd
Incr?
EBIT
EBIT/
Total
Assets
EBITDA
/
Interest
Expense
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
February
14,
2003
15
of
23
RailMPCT_
Final.
xls
­
O3
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Option
=
4
12
Facility
Impacts:
Option
4
(
Directs
+
All
to
433
Upgrade)
Final
MP&
M
Rule
Unweighted
Compliance
Cost
Option
4
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
RR
0
1
OU­
2
RR
0
1
OU­
3
RR
0
1
OU­
4
RR
0
1
OU­
5
RR
0
1
OU­
6
RR
0
0
OU­
8
RR
0
0
OU­
10
RR
0
1
OU­
11
RR
0
1
February
14,
2003
16
of
23
RailMPCT_
Final.
xls
­
O4
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Pass
Tests?
Unweighted
Test
of
Moderate
Impacts
Either
Incr?
Wgtd
Incr?
EBIT
EBIT/
Total
Assets
EBITDA
/
Interest
Expense
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
February
14,
2003
17
of
23
RailMPCT_
Final.
xls
­
O4
Record
for
the
Final
Metal
Product
and
Machinery
Rule
SURVEY
DATA
Data
comes
from
Sect4a01.
xls
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
SURVEY
DATA
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­
10
OU­
11
February
14,
2003
18
of
23
RailMPCT_
Final.
xls
­
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
REVENU94
REVENU95
REVENU96
TOTAL94
TOTAL95
TOTAL96
INTRST94
INTRST95
INTRST96
TAXES94
TAXES95
TAXES96
INT_
RATE
CURLIA94
CURLIA95
CURLIA96
NONLIA94
NONLIA95
February
14,
2003
19
of
23
RailMPCT_
Final.
xls
­
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
CONVERTS
ALL
SURVEY
DATA
TO
$
1996
NONLIA96
TOTASS94
TOTASS95
TOTASS96
DEPREC94
DEPREC95
DEPREC96
REVENU94
REVENU95
REVENU96
TOTAL94
TOTAL95
TOTAL96
INTRST94
INTRST95
February
14,
2003
20
of
23
RailMPCT_
Final.
xls
­
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
INTRST96
TAXES94
TAXES95
TAXES96
CURLIA94
CURLIA95
CURLIA96
NONLIA94
NONLIA95
NONLIA96
TOTASS94
TOTASS95
TOTASS96
DEPREC94
DEPREC95
DEPREC96
February
14,
2003
21
of
23
RailMPCT_
Final.
xls
­
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Facility
Characteristics
Small
Business
Threshold
for
Railroad
Facilities
1,500
From
FACDATA_
FINAL.
XLS
6
4
3
8
5
11
Op­
Unit
SID
Weight
Firm
FTE
Small
Sector
Subcat
Flow
Dir
80
I
124
D
145
I
158
I
194
I
236
I
238
I
352
I
373
I
382
I
436
I
500
I
562
I
572
I
596
I
620
I
638
I
659
I
698
I
761
I
798
I
835
I
852
D
881
I
February
14,
2003
22
of
23
RailMPCT_
Final.
xls
­
FacData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
6
7
8
9
10
11
12
13
14
15
16
FINAL
MP&
M
RULE
Option
1
Option
2
Option
3
Option
4
SID
Op_
Unit
CapCst1
AnnCst1
CC1_
96
CapCst2
AnnCst2
CC2_
96
CapCst3
AnnCst3
CC3_
96
CapCst4
AnnCst4
CC4_
96
80
124
145
158
194
236
238
352
373
382
436
500
562
572
596
620
638
659
698
761
798
835
852
881
February
14,
2003
23
of
23
RailMPCT_
Final.
xls
­
Costs