Download:
pdf |
pdfFR Y‐14 Q: Corporate Loan Data Schedule Instructions
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
A. Loan Population
Show all data as of the most recent quarter end prior to the submission
Report only loans “graded” or “rated” using the reporting entity’s commercial credit rating system, as it is
defined in the reporting entity’s normal course of business. Include all corporate loans with a committed
balance equal to or greater than $1 million.
Do not report "scored" or "delinquency managed" small business loans on this schedule. The reporting entity
should use its business as usual definition of small business loans. These loans do not have a commercial
internal risk rating and should be treated as retail loans. Exclude loan level detail for all unplanned overdrafts
(as used in the FR Y‐9C) included in Other Loans (BHCKJ451). Exclude domestic and international business and
corporate credit card or charge card loans included in the Y‐14M credit card collection.
Include all corporate loans that are at the consolidated Bank Holding Company (BHC) level and not just those of
the banking subsidiaries, as well as any unused but legally binding commitments that would be reported in the
relevant FR Y‐9C category (as outlined Additional Instructions for Field 26) if such loans were drawn. For clarity,
exclude informal “advised lines” (i.e., a revocable commitment by the bank to lend funds for up to a specified
period of time, usually one year, sometimes referred to as a guidance line) from commitments.
The population of corporate loans includes loans that are held for sale or valued under a fair value option, but
not trading book assets (refer to FR Y‐9C instructions, pages HC‐5 and HC‐6). Consistent with FR Y‐9C
instructions, report all loans net of charge‐offs, fair value adjustments (FVA) and ASC 310‐30 (originally issued
as SOP 03‐3) adjustments, if applicable, but gross of ASC 310‐10 (originally issued as FAS 114 Accounting by
creditors for impairment of a loan) reserve amounts. Charge‐offs, FVA, ASC 310‐10 reserve amounts, and ASC
310‐30 adjustments should be reported separately in the designated fields (28, 29, 30, and 31 respectively).
The population of loans should be reported at the credit facility level. For purposes of this collection, a credit
facility is defined as any legally binding credit extension to a legal entity under a specific credit agreement. A
credit facility may be secured or unsecured, term or revolving, drawn or undrawn (excluding informal advised
lines). The credit facility may also allow for multiple extensions of credit (or draws) with unique borrowing
terms such as interest rate or repayment date; however, ultimately the aggregation of such extensions of credit
are governed under one common credit agreement. Corporate borrowers may have multiple facilities from the
same bank. Each facility should be reported separately, but multiple draws within a facility should be
consolidated at the facility level. Descriptions of typical credit facility types are outlined in Additional
Instructions for Field 20.
Reporting Specifications
This will be a “quarter‐end” file produced initially for the quarter ending 6/30/2012. The quarterly data
submissions are due on the same schedule as the FR Y‐9C submissions. The table on the following pages shows
the fields that should be contained in the submission file.
Refer to the Additional Instructions when noted for certain field variables and descriptions.
All dollar amounts in Fields 1 through 48 should represent only the BHC’s pro‐rata portion of any syndicated or
participated loan. Where applicable, the MDRM (Micro Data Reference Manual) numbers are provided to map
the collected data items to other data items reported by the institution.
1
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
Fields 49 through 82 (Obligor Financial Data Section), should be reported on all loans as described in Loan
Population on the last calendar day of the quarter, excluding loans with:
(i)
(ii)
(iii)
(iv)
An obligor domiciled outside of the US (Field 6),
An obligor with a NAICS code beginning with 52 (Finance and Insurance),
or 5312 (Real Estate Agents and Brokers);
An obligor that is a nonprofit organization or federal, state, or local
government or related agencies; and
An obligor that is a Natural Person.
The Obligor Financial Data Section should be reported for the legal entity which provides the primary source of
repayment for the facility identified in Field 15. If this entity is the same as the Obligor identified in Field 2, the
Obligor Financial Data Section should reflect financial information of that Obligor and Fields 49‐51 should be
left blank. However, if the primary source of repayment is provided by an entity which is different than the
Obligor identified in Field 2, the entity should be identified in Fields 49‐51 and the Obligor Financial Data
section should reflect the financial information for this entity. All other Obligor Fields reported in the “Loan
and Obligor Description Section” should continue to reflect the Obligor identified in Field 2.
Data in Fields 54 through 82 should be reported or calculated in accordance with GAAP standards. Note
descriptions in the Obligor Financial Data Section provide guidance on what should be reported in each field
based on commonly‐used definitions; unless otherwise instructed, a reporting bank should report the Fields as
defined by its financial spreading systems (i.e., software programs on which the BHC spreads and analyzes the
financial statements of its customers) in accordance with its credit policy.
Fields 54 through 60 should be reported for the most recently available twelve month period (TTM), with the
ending date indicated in Field 52. If an obligor lacks trailing twelve months of financial information sufficient
for Fields 54 through 60, provide the underwritten annual information for Fields 54 through 60, with the ending
date indicated in Field 52.
Data Format
Data should be provided in a single extensible markup language file (.xml). No quotation marks should be used
as text identifiers. Do not provide a header row or a row count. This file will contain one record per active loan
in the contributor’s inventory.
2
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
Loan and Obligor Description Section
Field
No.
Field Name
Technical Field Name
MDRM
Mnemonic
Description
Allowable Values
Mandatory/
Optional
Data
Type
Field
Length
1
Customer ID
Customer ID
The unique internal
identifier for the
customer
relationship under
which the obligor's
exposure is
aggregated in the
reporting entity's
credit systems. For
stand‐alone or
ultimate parent
obligors, this may be
the same as the
unique internal
identifier for the
obligor provided in
Field #2.
Must not contain a Mandatory
carriage return, line
feed, comma or
any unprintable
character.
Alpha
Numeric
50
2
Internal ID
InternalObligorID
G063
The reporting
entity’s unique
internal identifier for
the obligor.
Must not contain a Mandatory
carriage return, line
feed, comma or
any unprintable
character.
Alpha
Numeric
50
3
Original
Internal ID
OriginalInternalObligorID
G064
The internal
identification code
assigned to the
obligor in the
previous submission.
If there is no change
from the prior
submission, or if this
is the first
submission, the
Internal ID reported
in Field #2 should be
used as the Original
Internal ID.
Must not contain a Mandatory
carriage return, line
feed, comma or
any unprintable
character.
Alpha
Numeric
50
4
Obligor Name ObligorName
9017
The obligor name on
the credit facility.
Full legal corporate
name is desirable. If
the borrowing entity
is an individual (s)
(Natural Person (s)),
do not report the
name; instead
substitute with the
text: "Individual."
Must not contain a Mandatory
carriage return, line
feed, comma or
any unprintable
character.
Alpha
Numeric
250
5
City
9130
The name of the city Free text indicating Mandatory
in which the obligor the City where the
Obligor is physically
is headquartered.
headquartered.
Alpha
Numeric
73
City
3
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
6
Country
Country
9031
The Country in which
the obligor is
headquartered. See
Additional
Instructions for ISO
standard codes.
Use the 2 letter
Country Code for
foreign properties
as found in
Additional
Instructions.
Mandatory
Alpha
Numeric
2
7
Zip Code
ZipCodeForeignMailingCode
9220
The zip code or
foreign mailing code
of the physical
location of the
obligor’s
headquarters.
For US: five‐digit
ZIP code. If the ZIP
code begins with
zeroes, leading
zeroes must be
specified with no
punctuation.
Mandatory
Numeric
20
For International:
use country specific
postal code.
8
Industry Code IndustryCode
The numeric code
that describes the
primary business
activity of the obligor
according to the
North American
Industry
Classification System
(NAICS). If the NAICS
code is not available,
provide either the
Standard Industrial
Classification (SIC),
or Global Industry
Classification
Standard (GICS).
Report 4 to 6 digit
number. If this
code is not
available, then
provide a SIC or
GICS industry code
as shown next.
Either
NAICS, GIC,
or SIC is
Mandatory
Alpha
Numeric
9
Industry Code IndustryCodeType
Type
Select the type of
industry code
identification
scheme used in field
#8.
1. NAICS
Mandatory
Integer
1
Alpha
Numeric
20
10
Obligor
Internal Risk
Rating
InternalRating
G080
10
2. SIC
3. GICS
Report the obligor
Free text indicating Mandatory
rating grade from
the obligor rating
the reporting entity’s grade.
internal risk rating
system.
This is the reporting
entity’s probability
of default (PD)
rating. If the
reporting entity uses
a one‐dimensional
risk rating system,
record that rating
here.
4
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
The 9 digit assigned Mandatory
by the Internal
Revenue Service for
the obligor
identified in field
#2. Allowable
forms are either
##‐
#######,########
#, or ‘NA’.
11
TIN
TIN
6191
The Taxpayer
Identification
Number (TIN)
assigned to the
obligor by the U.S.
Internal Revenue
Service (IRS) in the
administration of tax
laws. If the
borrowing entity is
an individual (s)
(Natural Person (s)),
do not report Social
Security Number;
instead enter ‘NA’.
If, the borrowing
entity does not have
a TIN, enter ‘NA’.
12
Stock
Exchange
StockExchange
Name of the Stock
Free text
Exchange on which
the primary stock of
the obligor, or its
parent, trades. If the
borrowing entity is
not publicly traded,
enter ‘NA’.
13
Ticker Symbol TKR
4539
Stock Symbol for
Free text
stocks listed and
traded on the
regulated exchange
provided in Field
#12. For subsidiaries
of public companies,
use parent ticker
symbol from its
primary Stock
Exchange. If the
borrowing entity is
not publicly traded,
enter ‘NA’.
14
CUSIP
9161
CUSIPs are
identifiers created
and delivered by the
CSB (CUSIP Service
Bureau). Report the
first six characters
which are known as
the base (or CUSIP‐6)
and uniquely identify
the issuer. If a CUSIP
does not apply,
enter ‘NA’.
CUSIP
Alpha
Numeric
10
Mandatory
Alpha
Numeric
100
Mandatory
Alpha
Numeric
10
Mandatory
Must be valid 6
digit CUSIP number
issued by the CUSIP
Service Bureau.
Alpha
Numeric
6
5
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
15
Internal
InternalCreditFacilityID
Credit Facility
ID
The reporting
entity’s unique
internal identifier for
this credit facility
record. It must
identify the credit
facility for its entire
life and must be
unique.
Must be unique
Mandatory
within a submission
and over time. That
is, the same
submission file
must not have two
facilities with the
same Credit Facility
ID.
In the event the
internal facility ID
changes (i.e., loan
was converted to a
new system through
migration or
acquisition), also
provide Original
Internal credit
facility ID in line 16.
May not contain a
carriage return, line
feed, comma or
any unprintable
character.
Alpha
Numeric
50
16
Original
OriginalInternalCreditFacilityID
Internal
Credit Facility
ID
The Internal
identification code
assigned to the
credit facility record
in the previous
submission. If there
is no change from
the prior submission,
or if this is the first
submission, then the
Internal credit
facility ID reported in
Field #15 should be
used as the Original
Internal credit
facility ID.
May not contain a Mandatory
carriage return, line
feed, comma or
any unprintable
character.
Alpha
Numeric
50
17
Credit Facility CreditFacilityRating
Internal Risk
Rating
Report the credit
Free text indicating Mandatory
facility’s assigned
the LGD rating or
loss severity rating
‘NA.’
grade (also known as
the loss given default
(LGD) rating) from
the reporting entity’s
internal risk rating
system.
If no credit facility
rating is assigned,
enter ‘NA.’
Alpha
Numeric
20
6
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
18
19
Origination
Date
OriginationDate
Maturity Date MaturityDate
K452
9914
The date a credit
facility becomes a
legally binding
agreement. If the
credit facility has
been renewed, use
the renewal date as
the Origination Date
(except for extension
options that were at
the sole discretion of
the obligor). The
renewal date would
include all credit
actions that require
bank approval and
that change the
contractual date of
the obligation.
Must be in yyyy‐
mm‐dd format,
e.g.:
2005‐02‐01
1999‐12‐14
The last date upon
which the funds
must be repaid,
inclusive of
extension options
that are solely at the
borrower’s
discretion, and
according to the
most recent terms of
the credit
agreement. For
demand loan,
enter9999‐01‐01.
Must be in yyyy‐
mm‐dd format,
e.g.:
2005‐02‐01
1999‐12‐14
Enter number code Mandatory
of the description.
Date
10
Mandatory
Date
10
Numeric
2
Alpha
50
Numeric
2
Must be before or
equal to the
quarter end date of
the data.
20
Credit Facility FacilityType
Type
G072
See Additional
Instructions for
credit facility type
descriptions. Only
use designated
descriptions; if it is
Other, provide
description in Field
#21.
21
Other Credit
Facility Type
Description
G107
To be supplied only Free Text
in cases where the
credit facility is listed
as “Other” in Field
#20(leave blank if
Field #20 is not
zero).
22
Credit Facility CreditFacilityPurpose
Purpose
G073
See Additional
Instructions for
credit facility
purpose
descriptions. Only
use designated
descriptions; if it is
Other, provide
description in Field
#23.
OtherFacilityType
Mandatory
Mandatory
Enter number code Mandatory
of the description
7
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
23
Other Credit
Facility
Purpose
Description
OtherFacilityPurpose
G108
To be supplied only
in cases where the
credit facility
purpose is listed as
”Other” in Field
#22(leave blank if
Field #22 is not
zero).
Free Text
24
Committed
Exposure
Global
CommittedExposure
G074
The current dollar
amount the obligor
is legally allowed to
borrow according to
the credit agreement
identified in Field 15,
net of any charge‐
offs, ASC 310‐10
(originally issued as
SOP 03‐03) or fair
value adjustments
taken by the
Reporting BHC. For
clarity, Committed
Exposure Global
includes both drawn
and undrawn
committed amounts.
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Mandatory
Alpha
50
Numeric
20
Numeric
20
Supply numeric
values with no non‐
numeric formatting
(no dollar sign,
commas or
decimal).
For facilities with
multiple lenders,
only provide the
reporting entity’s
pro‐rata
commitment, net of
the above noted
adjustments.
25
Utilized
Exposure
Global
UtilizedExposure
G075
The current dollar
amount the obligor
has drawn which has
not been repaid. net
of any charge‐offs,
ASC 310‐10
(originally issued as
SOP 03‐03) or fair
value adjustments
taken by the
Reporting BHC.
Rounded whole
Mandatory
dollar amount with
no cents, e.g.:
20000000
Supply numeric
values with no non‐
numeric formatting
(no dollar sign,
commas or
decimal).
For facilities with
multiple lenders,
only provide the
reporting entity’s
pro‐rata utilized
exposure, net of the
above noted
adjustments.
For fully undrawn
commitments, enter
0 (zero).
8
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
26
Line Reported LineReportedOnFRY9C
on FR Y‐9C
K449
Enter number code Mandatory
Report the integer
code (See Additional of the description
Instructions for
descriptions). Only
enter designated
descriptions
corresponding to the
line number on the
FR Y‐9C, HC‐C, in
which the
outstanding balance
is recorded or, in the
case of an unused
commitment, the
line number in which
the credit facility
would be recorded if
it were drawn.
Integer
2
27
Line of
business
LineOfBusiness
K458
Indicate the internal
line of business that
originated the credit
facility using the
institutions own
department
descriptions.
Free text describing Mandatory
the Line of
Business. For
example: Private
Banking, Corporate
Banking, Asset‐
Based Lending, etc.
Alpha
Numeric
100
28
Cumulative
Charge‐offs
CumulativeChargeoffs
G076
The cumulative
charge‐offs
associated with the
credit facility on the
reporting entity's
books.
Mandatory
Rounded whole
dollar amount, e.g.:
20000000
Alpha
Numeric
20
Supply numeric
values with no non‐
numeric formatting
(no dollar sign,
commas or
decimal).
Should be 0 if there
is no charge‐off for
the facility.
Should be ‘NA’ for
loans held for sale
or accounted for
under a fair value
option.
For fully undrawn
commitments,
enter 0.
9
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
29
FVA
FairValueAdjustment
For held for sale
loans and loans
accounted for under
a fair value option,
include the dollar
amount adjustment
(positive or negative)
from the par
balance.
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Alpha
Numeric
20
Numeric
20
Numeric
20
Supply numeric
values with no non‐
numeric formatting
(no dollar sign,
commas or
decimal).
Should be 0 for
loans valued at par
Should be ‘NA’ for
loans not held for
sale or accounted
for under a fair
value option.
For negative values
use a negative sign
‘‐‘, not parenthesis
().
For fully undrawn
commitments,
enter ’NA’.
30
ASC 310‐10
ASC31010
Reserve applied to
the credit facility per
ASC 310‐10
(formerly FASB 114
Accounting by
Creditors for
impairment of a
loan).
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Supply numeric
values with no non‐
numeric formatting
(no dollar sign,
commas or
decimal).
Should be 0 if there
is no ASC 310‐10
Reserve for the
credit facility.
For fully undrawn
commitments,
enter 0.
31
ASC310‐30
ASC31030
Adjustment per ASC
310‐30 (formerly
Statement of
Position 03‐3
Accounting for
Certain Loans or
Debt Securities
Acquired in a
Transfer). Provide if
available at a credit
facility level.
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Supply numeric
values with no non‐
numeric formatting
(no dollar sign,
commas or
decimal).
Should be 0 if there
is no loan level ASC
310‐30 adjustment.
For fully undrawn
commitments,
enter 0.
10
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
32
33
# Days
Principal or
Interest Past
Due
PastDue
Non‐Accrual
Date
NonAccrualDate
G077
G078
Report the longest
number of days
principal and/or
interest payments
are past due, if such
payments are past
due 30 days or more.
If payments are not
past due 30 days or
more, enter zero.
The date the credit
facility was placed
on non‐accrual, if
applicable. If there is
no non‐accrual date,
enter 9999‐12‐31.
Numbers only.
Mandatory
Numeric
4
Mandatory
Date
10
Integer
1
Mandatory
Integer
1
For fully undrawn
commitments,
enter 0.
Must be in yyyy‐
mm‐dd format,
e.g.:
2005‐02‐01
1999‐12‐14
For fully undrawn
commitments,
enter 9999‐12‐31.
34
35
Participation
Flag
Lien Position
ParticipationFlag
LienPosition
6135
K450
Indicate if the credit
facility is
participated or
syndicated among
other financial
institutions.
1.
2.
Indicate using
integer code if the
credit facility is First
Lien Senior, Second
Lien, Senior
Unsecured, or
Subordinated.
1. First Lien
Senior
2. Second Lien
3. Senior
Unsecured
4. Subordinated
3.
No
Mandatory
Yes, purchased
by reporting
BHC
Yes, sold by
reporting BHC
If the facility is
secured by different
lien positions,
provide information
on the predominant
lien position.
36
Security Type
SecurityType
Enter number code Mandatory
If security is
of the description
provided by
collateral other than
or in addition to Real
Estate, indicate the
predominant type.
Report the integer
code (See Additional
Instructions for
descriptions)
Integer
2
37
Interest Rate
Variability
InterestRateVariability
K461
Variability of current 0.
interest rates (Fixed,
Floating, or Mixed)
1.
to maturity.
2.
For fully undrawn
3.
commitments, enter
0 (zero).
Integer
12
Fully undrawn
commitments
Mandatory
Fixed
Floating
Mixed
11
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
38
39
Interest Rate
Interest Rate
Index
InterestRate
InterestRateIndex
7889
K462
Current interest rate
charged on the
credit facility. If the
facility includes
multiple draws with
different interest
rates, enter the
dollar weighted
average interest
rate that
approximates the
overall rate on the
drawn balance of the
facility.
For floating rate
credit facilities list
base interest rate
using integer code. If
obligor has an
option, select the
index actually in use.
Provide as a
decimal, e.g.:
0.0575 for 5.75%
Mandatory
Decimal
12
Mandatory
Integer
8
Mandatory
Alpha
Numeric
12
For fully undrawn
commitments,
enter 0.
0. Fully undrawn
commitments
1.
2.
3.
4.
5.
LIBOR
PRIME or Base
Treasury Index
Other
Not applicable
(Fixed)
If the credit facility is
fixed (as designated
in Field #37) choose 6. Mixed
the integer for “Not
applicable (Fixed)”.
For credit facilities
where the base
interest rate is
mixed, choose the
integer for “Mixed.”
For fully undrawn
commitments, enter
0 (zero).
40
Interest Rate
Spread
InterestRateSpread
K463
For floating rate
credit facilities, list
spread over base
rate in basis points.
Provide as a
decimal, e.g.:
0.0575 for 5.75%
If the credit facility is Enter ‘NA’ if the
fixed (as designated credit facility is
in Field #37)
fixed
populate ‘NA’.
If the facility includes Negative numbers
multiple draws with can be submitted.
different spreads,
For negative values
provide the spread
use a negative sign
that approximates
‘‐‘ not parenthesis
the overall spread on ().
For fully undrawn
the facility.
commitments,
enter 0.
12
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
41
Interest Rate
Ceiling
InterestRateCeiling
K464
For floating rate
credit facilities, list
rate ceiling if one is
contained in the
credit agreement.
If there is no ceiling,
populate with
‘NONE’.
Provide as a
decimal, e.g.:
0.0575 for 5.75%
Mandatory
Alpha
Numeric
12
Mandatory
Alpha
Numeric
12
Enter ‘NA’ if the
credit facility is
fixed
Enter ‘NONE’ if no
If the credit facility is ceiling.
fixed (as designated
For fully undrawn
in Field #37)
commitments,
populate ‘NA’.
enter 0.
For facilities with
multiple interest rate
ceilings, provide the
maximum interest
rate ceiling.
42
Interest Rate
Floor
InterestRateFloor
K465
For floating rate
credit facilities, list
rate floor if one is
contained in the
credit agreement. If
there is no floor,
populate with
‘NONE’.
Provide as a
decimal, e.g.:
0.0575 for 5.75%
If the credit facility is
fixed (as designated
in Field #37)
populate ‘NA’.
Enter ‘NONE’ if no
floor.
For facilities with
multiple interest rate
floors, provide the
minimum interest
rate floor.
Enter ’NA’ if the
credit facility is
fixed
For fully undrawn
commitments,
enter 0.
43
Interest
Income Tax
Status
TaxStatus
Tax Status of interest 1. Taxable
Mandatory
income for Federal
2. Tax Exempt
or State Income Tax
purposes
If federal or state
tax exempt, choose
’2’.
Integer
8
44
Guarantor
Flag
GuarantorFlag
Indicate if the credit
facility is
guaranteed.
1. Full guarantee
Mandatory
2. Partial guarantee
3. U.S. Government
Agency guarantee
4. No guarantee
Integer
1
45
Guarantor
Internal ID
Guarantor
GuarantorInternalID
The unique
Must not contain a
guarantor identifier. carriage return,
line feed, comma
For facilities with
multiple guarantors, or any unprintable
character.
provide the unique
guarantor identifier If the credit facility
is not guaranteed,
for the primary or
enter ‘NA’.
most substantial
Alpha
Numeric
50
Mandatory
guarantor.
13
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
46
Guarantor
Name
GuarantorName
The guarantor name
on the credit facility.
Full legal corporate
name is desirable. If
the guarantor is an
individual (s)
(Natural Person (s)),
do not report the
name; instead
substitute with the
text: "Individual."
Must not contain a Mandatory
carriage return,
line feed, comma
or any unprintable
character.
If the credit facility
is not guaranteed,
enter ‘NA’
Alpha
Numeric
250
Alphanu
meric
50
Alpha
Numeric
20
For facilities with
multiple guarantors,
provide the
guarantor name for
the primary or most
substantial
guarantor.
47
Guarantor TIN GuarantorTIN
The Taxpayer
Identification
Number (TIN)
assigned to the
guarantor by the U.S.
Internal Revenue
Service (IRS) in the
administration of tax
laws. If the
guarantor is an
individual (s)
(Natural Person (s)),
do not report Social
Security Number;
instead enter ‘NA’.
If, the guarantor
does not have a TIN,
enter ‘NA’.
The 9 digit
assigned by the
Internal Revenue
Service for the
guarantor
identified in Field
#45. Allowable
forms are either
##‐#######,
#########, or
‘NA’.
If the credit facility
is not guaranteed,
enter ‘NA’
Mandatory
For facilities with
multiple guarantors,
provide the TIN
assigned to the
primary or most
substantial
guarantor.
48
Guarantor
Internal Risk
Rating
GuarantorInternalRiskRating
Report the guarantor
rating grade from
the reporting entity’s
internal risk rating
system.
This is the reporting
entity’s probability
of default (PD)
rating. If the
reporting entity uses
a one‐dimensional
risk rating system,
record that rating
here.
Free text indicating Mandatory
the obligor rating
grade.
If the credit facility
is not guaranteed
or if the guarantor
does not have a
rating, enter ‘NA’
For facilities with
multiple guarantors,
provide the
guarantor rating
grade for the
primary or most
substantial
guarantor.
14
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
Obligor Financial Data Section
Field Field Name
No.
Technical Field Name
MDRM
Mnemonic
Description
Allowable Values
49
Entity Internal EntityInternalID
ID
The reporting BHC’s
unique internal
identifier for the
entity which is the
primary source of
repayment for the
Facility in Field 15
50
Entity Name
The name of the
entity which is the
primary source of
repayment for the
facility in Field 15.
Full legal corporate
name is desirable. If
the entity is an
individual (s)
(Natural Person (s)),
do not report the
name; instead
substitute with the
text: "Individual."
51
Entity Internal EntityInternalRiskRating
Risk Rating
For the entity
identified in Field 49,
report the entity
rating grade from
the reporting BHC’s
internal risk rating
system.
EntityName
This is the reporting
entity’s probability
of default (PD)
rating. If the
reporting BHC uses a
one‐dimensional risk
rating system, record
that rating here.
52
Date of
Financials
DateFinancials
Indicate date of the
financial information
reported in this
submission.
Mandatory/ Data
Optional
Type
Field
Length
Must not contain a
carriage return, line
feed, comma or
any unprintable
character.
Mandatory
if the entity
which is the
primary
source of
repayment
Leave blank if the
differs from
entity is the same
the Obligor
as the Obligor
identified in Field 2. identified in
Field 2.
Alpha
Numeric
50
Must not contain a
carriage return, line
feed, comma or
any unprintable
character.
Mandatory
if the entity
which is the
primary
source of
repayment
Leave blank if the
differs from
entity is the same
the Obligor
as the Obligor
identified in Field 2. identified in
Field 2.
Alpha
Numeric
250
Free text indicating Mandatory
the entity rating
if the entity
grade.
which is the
Leave blank if the
primary
entity is the same
source of
as the Obligor
repayment
identified in Field 2. differs from
the Obligor
identified in
Field 2.
Alpha
Numeric
20
Must be in yyyy‐
mm‐dd format,
e.g.:
2005‐02‐01
1999‐12‐14
Mandatory
Date
10
Mandatory
Date
10
53
Date of Last
Audit
DateLastAudit
Enter the date of
the Borrower’s last
audited financial
statements.
If there is no audit
date, enter 9999‐12‐
31.
Must be in yyyy‐
mm‐dd format,
e.g.:
2005‐02‐01
1999‐12‐14
15
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
54
Net Sales
Current
NetSalesCurrent
Gross sales reduced
by cash discounts,
trade discounts, and
returned sales and
allowances for which
credit is given to
customers less
returns and
allowances, freight
out, and cash
discounts allowed
for the designated
period.
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Numeric
20
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
Numeric
20
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Supply numeric
values with no non‐
numeric formatting
(no dollar sign,
commas or
decimal).
Numeric
20
Optional
Rounded whole
dollar amount, e.g.:
20000000
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
Numeric
20
Supply numeric
values with no non‐
numeric formatting
(no dollar sign,
commas or
decimal).
Report data on a
trailing twelve
month (TTM) basis
from date reported
in Field #52.
55
Net Sales
Prior Year
NetSalesPriorYear
Gross sales reduced
by cash discounts,
trade discounts, and
returned sales and
allowances for which
credit is given to
customers less
returns and
allowances, freight
out, and cash
discounts allowed
for the designated
period.
Report data on a
trailing twelve
month (TTM) basis
from date reported
in Field #52.
56
EBITDA
EBITDA
Earnings before
interest, taxes,
depreciation and
amortization.
Report data on a
trailing twelve
month (TTM) basis
from date reported
in Field #52.
57
Adjusted
EBITDA
AdjustedEBITDA
Earnings before
interest, taxes,
depreciation and
amortization
adjusted to exclude
non‐recurring
revenue, gains,
expenses, or losses.
Report data on a
trailing twelve
month (TTM) basis
from date reported
in Field #52.
16
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
58
Interest
Expense
InterestExpense
The periodic expense
to the company of
securing short and
long‐term debt.
Report data on a
trailing twelve
month (TTM) basis
from date reported
in Field #52.
59
Net Income
Current
NetIncomeCurrent
The income (or loss)
reported by a
company after
expenses and losses
have been
subtracted from all
revenues and gains
for the fiscal period
including
extraordinary items
and discontinued
operations.
Mandatory
Rounded whole
dollar amount, e.g.:
20000000
Numeric
20
Numeric
20
Numeric
20
Numeric
20
Numeric
20
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
Mandatory
Rounded whole
dollar amount, e.g.:
20000000
Supply numeric
values with no non‐
numeric formatting
(no dollar sign,
commas or
decimal).
Report data on a
trailing twelve
month (TTM) basis
from date reported
in Field #52.
60
Net Income
Prior Year
NetIncomePriorYear
The income (or loss)
reported by a
company after
expenses and losses
have been
subtracted from all
revenues and gains
for the fiscal period
including
extraordinary items
and discontinued
operations.
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Supply numeric
vaues with no non‐
numeric formatting
(no dollar sign,
commas or
decimal).
Report data on a
trailing twelve
month (TTM) basis
from date reported
in Field #52.
61
62
Cash &
Marketable
Securities
Accounts
Receivable
(A/R) Current
CashMarketableSecurities
AccountsReceivableCurrent
Cash, depository
accounts and
marketable
securities that can
be easily sold and
readily converted
into cash.
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Money owned by
customers at the end
of the designated
period to a business
for merchandise or
services or services
sold on open
account.
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Supply numeric
values with no non‐
numeric formatting
(no dollar sign,
commas or
decimal).
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
17
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
63
64
65
Accounts
Receivable
(A/R) Prior
Year
AccountsReceivablePriorYear
Inventory
Current
InventoryCurrent
Inventory
Prior Year
Money owed to a
business for
merchandise or
services or services
sold on open
account Money
owned by customers
at the end of the
designated period.
Mandatory
Rounded whole
dollar amount, e.g.:
20000000
Value of a firm’s raw
materials, work in
process, supplies
used in operations,
and finished goods
Sum of merchandise
bought for resale
and materials and
supplies purchased
for use in production
of revenue.
Mandatory
Rounded whole
dollar amount, e.g.:
20000000
Numeric
20
Numeric
20
Numeric
20
Numeric
20
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
Report data one year decimal).
prior from date
reported in Field #
52.
InventoryPriorYear
Value of a firm’s raw
materials, work in
process, supplies
used in operations,
and finished goods
Sum of merchandise
bought for resale
and materials and
supplies purchased
for use in production
of revenue.
Supply numeric
values with no non‐
numeric formatting
(no dollar sign,
commas or
decimal).
Mandatory
Rounded whole
dollar amount, e.g.:
20000000
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
Report data one year
prior from date
reported in Field #
52.
66
Current
Assets
Current
CurrentAssetsCurrent
Cash, accounts
receivable,
inventory, and other
assets that are likely
to be converted into
cash, sold,
exchanged, or
expensed in the
normal course of
business, usually
within one year and
other assets
expected to be
converted to cash
within a year.
Examples include
accounts receivable,
prepaid expenses,
and many negotiable
securities as of the
end of the
designated period.
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
18
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
67
Current
Assets Prior
Year
CurrentAssetsPriorYear
Cash, accounts
receivable,
inventory, and other
assets that are likely
to be converted into
cash, sold,
exchanged, or
expensed in the
normal course of
business, usually
within one year Cash
and other assets
expected to be
converted to cash
within a year.
Examples include
accounts receivable,
prepaid expenses,
and many negotiable
securities as of the
end of the
designated period.
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Numeric
20
Numeric
20
Numeric
20
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
Report data one year
prior from date
reported in Field #
52.
68
69
Tangible
Assets
Fixed Assets
TangibleAssets
FixedAssets
Assets having a
physical existence,
such as cash,
equipment, and real
estate; accounts
receivable are also
usually considered
tangible assets for
accounting
purposes Real
property or personal
property, such as
buildings, machinery,
and real property.
Tangible assets are
distinguished from
intangible assets
such as trademarks,
copyrights, and
goodwill, and natural
resources
(timberlands, oil
reserves, and coal
deposits). Also
include accounts
receivable of a
concern.
Mandatory
Rounded whole
dollar amount, e.g.:
20000000
Tangible property
used in the business
and not for resale;
would include
buildings, furniture,
fixtures, equipment,
and land.
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Report fixed assets
net of depreciation.
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
19
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
70
71
Total Assets
(TA) Current
Total Assets
(TA) Prior
Year
TotalAssetsCurrent
TotalAssetsPriorYear
Sum of current
assets plus net
property, plant, and
equipment plus
other non‐current
assets (including
intangible assets,
deferred items, and
investments and
advances) at the end
of the designated
period.
Mandatory
Rounded whole
dollar amount, e.g.:
20000000
Sum of current
assets plus net
property, plant, and
equipment plus
other non‐current
assets (including
intangible assets,
deferred items, and
investments and
advances) at the end
of the designated
period.
Mandatory
Rounded whole
dollar amount, e.g.:
20000000
Numeric
20
Numeric
20
Numeric
20
Numeric
20
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
Report data one year
prior from date
reported in Field #
52.
72
73
Accounts
Payable (A/P)
Current
Accounts
Payable(A/P)
Prior Year
AccountsPayableCurrent
AccountsPayablePriorYear
Amounts owed on
open account to
creditors for goods
and services.
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Amounts owed on
open account to
creditors for goods
and services
Obligations owed to
suppliers arising
from the firm’s
ongoing operations,
including the
purchase of goods,
materials, supplies,
and services at the
end of the
designated period.
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
Report data one year
prior from date
reported in Field #
52.
20
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
74
Short Term
Debt
ShortTermDebt
All debt obligations
with a term of less
than one year.
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Numeric
20
Numeric
20
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
75
Current
Maturities of
Long Term
Debt
CurrentMaturitiesLongTermDebt
76
Current
Liabilities
Current
CurrentLiabilitiesCurrent
Short‐term debt,
Rounded whole
Mandatory
accounts payable
dollar amount, e.g.:
and other current
20000000
liabilities that are
Supply numeric
due within one year. values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
Numeric
20
77
Current
Liabilities
Prior Year
CurrentLiabilitiesPriorYear
Mandatory
Short‐term debt,
Rounded whole
accounts payable
dollar amount, e.g.:
and other current
20000000
liabilities that are
Supply numeric
due within one year. values with no
Report data one year non‐numeric
prior from date
formatting (no
reported in Field #
dollar sign,
52.
commas or
decimal).
Numeric
20
78
Long Term
Debt
LongTermDebt
Liabilities due in one
year or more.
Numeric
20
Portion of long‐term
debt due within one
year.
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
21
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
79
Minority
Interest
MinorityInterest
Interest of
shareholders who, in
the aggregate, own
less than half the
shares in a
corporation. On the
consolidated balance
sheets of companies
whose subsidiaries
are not wholly
owned, the minority
interest is shown as
a separate equity
account or as a
liability of indefinite
term. Enter ‘NA’ if
not applicable.
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Alpha
Numeric
20
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
Enter ‘NA’ if not
applicable.
80
Total
Liabilities
TotalLiabilities
Sum of current
Rounded whole
Mandatory
liabilities plus long‐
dollar amount, e.g.:
term debt plus other 20000000
non‐current
Supply numeric
liabilities (including
values with no
deferred taxes,
non‐numeric
investment tax
formatting (no
credit, and minority dollar sign,
interest)
commas or
decimal).
Numeric
20
81
Retained
Earnings
RetainedEarnings
Cumulative earnings
of the company less
total dividend
distributions to
shareholders.
Typically, it is the
prior year’s retained
earnings plus net
income less
distributions.net
profits kept to
accumulate in a
business after
dividends are paid
Mandatory
Rounded whole
dollar amount, e.g.:
20000000
Numeric
20
Funds used to
acquire a long‐term
asset resulting in
depreciation
deductions over the
life of the acquired
asset
Rounded whole
Mandatory
dollar amount, e.g.:
20000000
Numeric
20
82
Capital
Expenditures
CapitalExpenditures
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign,
commas or
decimal).
Supply numeric
values with no
non‐numeric
formatting (no
dollar sign, commas
or decimal).
22
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
ADDITIONAL INSTRUCTIONS FOR COMPLETING THE CORPORATE LOAN DATA COLLECTION
Field 6: Below is the list of ISO standard country codes. Provide the relevant 2 letter code in the Field. See also in:
http://www.iso.org/iso/country_codes/iso_3166_code_lists/country_names_and_code_elements.htm
23
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
Field 14: CUSIP. CUSIPs are identifiers created and delivered by the CSB (CUSIP Service Bureau). The CSB is managed on behalf of the American
Bankers Association by Standard & Poor’s. The first six characters are known as the base (or CUSIP‐6), and uniquely identify the issuer. Issuer
codes are assigned alphabetically from a series that includes deliberate built‐in "gaps" for future expansion. CUSIP of obligor if available.
Field 20: Use the following credit facility type descriptions, only. Enter number code of the description. Note that these descriptions and codes mirror
the requirements for Shared National Credit reporting and therefore not all will be relevant for Corporate Loan reporting.
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
OTHER
REVOLVING CREDIT
REVOLVING CREDIT CONVERTING TO TERM LOAN
REVOLVING CREDIT ‐ ASSET BASED
REVOLVING CREDIT ‐ DIP
NON‐REVOLVING LINE OF CREDIT
NON‐REVOLVING LINE OF CREDIT CONVERTING TO TERM LOAN
TERM LOAN
TERM LOAN ‐ A
TERM LOAN ‐ B
TERM LOAN ‐ C
TERM LOAN ‐ BRIDGE
TERM LOAN ‐ ASSET BASED
TERM LOAN ‐ DIP
CAPITALIZED LEASE OBLIGATION
STANDBY LETTER OF CREDIT
OTHER REAL ESTATE OWNED
OTHER ASSET
Field 22: Use the following credit purpose descriptions, ONLY. Enter number next to description. Note that these descriptions and codes mirror the
requirements for Shared National Credit reporting and therefore not all will be relevant for Corporate Loan reporting.
0
1
2
3
4
5
OTHER
ACQUISITION AND/OR MERGER FINANCING
ASSET SECURITIZATION FINANCING
CAPITAL EXPENDITURES EXCLUDING REAL ESTATE
COMMERCIAL PAPER BACK‐UP
INDUSTRIAL REVENUE BOND BACK‐UP
24
FR Y‐14 Q: Corporate Loan Data Schedule Instructions
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
MORTGAGE WAREHOUSING
TRADE FINANCING
PERFORMANCE GUARANTEE
WORKING CAPITAL ‐ SHORT TERM/SEASONAL
WORKING CAPITAL ‐ PERMANENT
GENERAL CORPORATE PURPOSES
DEBT REFINANCE/CONSOLIDATION
ESOP FINANCING
AGRICULTURE AND/OR LIVESTOCK PRODUCTION
AGRICULTURE AND/OR RANCHING REAL ESTATE
STOCK BUYBACK
PORTFOLIO ACQUISITION INCLUDING NOTE PURCHASE AGREEMENTS
REAL ESTATE ACQUISITION/DEVELOPMENT/CONSTRUCTION ‐ LAND
REAL ESTATE ACQUISITION/DEVELOPMENT/CONSTRUCTION ‐ RESIDENTIAL
REAL ESTATE ACQUISITION/DEVELOPMENT/CONSTRUCTION ‐ COMML & INDL
REAL ESTATE INVESTMENT/PERMANENT FINANCING ‐ RESIDENTIAL
REAL ESTATE INVESTMENT/PERMANENT FINANCING ‐ COMMERCIAL AND INDUSTRIAL
BUSINESS RECAPITALIZATION/DIVIDENDS
NEW PRODUCT DEVELOPMENT
PROJECT FINANCING
Field 26: Line Reported on FR Y‐9C. Only use designated descriptions corresponding to the line number on the FR Y‐9C, HC‐C, in which the outstanding
balance is recorded.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
bhck1292 (U.S. Banks and other U.S. Depository Institutions)
bhck1296 (Foreign Banks)
bhck1590 (loans to finance agricultural production and other loans to farmers)
bhck1763 (Commercial and Industrial loans to U.S. addressees. Exclude loans that are scored but not graded)
bhck1764 (Commercial and Industrial loans to non‐U.S. addresses. Exclude loans that are scored but not graded)
bhck2081 (Loans to foreign governments and official institutions)
bhckJ454 (Loans to nondepository financial institutions)
bhckJ451 (All other loans, excludes consumer loans)
bhckF163 (All other leases, excludes consumer leases)
bhckF160 (nonfarm,nonres, owner occupied)
nonfarm, nonres, owner occupied originated in non‐domestic offices as reported within bhck1410
Field 36: Use the following security type descriptions:
0.
1.
2.
3.
4.
5.
6.
Real Estate only
Cash and Marketable Securities
Accounts Receivable and Inventory
Fixed Assets excluding Real Estate
Blanket Lien
Other
Unsecured
25
File Type | application/pdf |
File Title | Microsoft Word - FR_Y-14Q_CORPLOAN_2012Q2.docx |
Author | m1ajf04 |
File Modified | 2012-05-23 |
File Created | 2012-05-23 |