Download:
pdf |
pdfFR Y-14Q: Commercial Real Estate Schedule Instructions
FR Y-14 Q: Commercial Real Estate Schedule Instructions
A. Loan Population
A Commercial Real Estate Loan (“CRE Loan”) is defined as a legally binding loan commitment or credit facility to an
obligor as defined in the Credit Agreement. Provide all CRE Loans that are reported in the FR Y-9C categories outlined in
Field #4, as well as any legally committed but undrawn CRE Loans that would be reported in the relevant FR Y-9C
category if such CRE Loan were drawn on the last day of the quarter.
Include all CRE Loans with a committed balance equal to or greater than $1 million.
If a CRE loan with an committed balance equal to or greater than $1 million is cross-collateralized with a CRE
loan less than $1 million, for those loans with commitments less than $1 million, report fields #1 (Loan
Number), #3 (Outstanding Balance), and #5 (Committed Balance). All other fields for those loans are
optional.
Consistent with FR Y-9C instructions, report all loans net of charge-offs, fair value adjustments (including
held for sale loans) and ASC 310-30 (originally issued as SOP 03-3) adjustments, but gross of ASC 310-10
(originally issued as FAS 114 Accounting by creditors for impairment of a loan) reserve amounts, if
applicable. Charge-offs, ASC 310-10 reserve amounts, ASC 310-30 adjustments, and fair value adjustments
(including those for held for sale loans) should be reported separately in the designated fields (6, 45, 46, and
47 respectively). All loans reported in the FR Y-9C categories on the last calendar day of the quarter should
be reported.
B. Data Format
Provide data in a single extensible markup language file (.xml). An XSD document will be made available to bank
holding companies.
Do not use quotation marks as text identifiers.
Do not use a header or a row count. The XML file will contain one record per active loan in the contributor’s inventory.
The table on the pages following shows the fields that should be contained in the file.
1
FR Y-14Q: Commercial Real Estate Schedule Instructions
Field
No.
1
Field Name
Loan
Number
Technical Field Name
LoanNumber
Description
Bank’s unique internal identifier for
this loan record that will be the same
from quarter to quarter. It must
identify the loan for its entire life and
must be unique.
Allowable Values
Mandatory
/Optional
Data Type
Field
Length
Must be unique
within a
submission and
over time. That is,
the same loanlevel file must not
have two facilities
with the same
Loan Number.
Mandatory
Alpha
Numeric
50
Must not contain
a vertical bar (|,
ASCII 7C), carriage
return, line feed,
comma or any
unprintable
character.
2
Obligor
Name
ObligorName
The obligor name on the loan. Full
legal entity name is desirable, but the
precise name is not necessary if it
requires manual intervention to
provide. 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 vertical bar (|,
ASCII 7C), carriage
return, line feed,
comma or any
unprintable
character.
Mandatory
Alpha
Numeric
250
3
Outstanding
Balance
OutstandingBalance
The current outstanding (book) balance
on the CRE Loan as reported on FR Y9C. Outstanding balance is net of ASC
310-30 (originally issued as SOP 03-3),
charge-offs and fair value adjustments.
Rounded whole
dollar amount
with no cents,
e.g.: 20000000
Mandatory
Numeric
20
Report the integer code (see Allowable
Values column) corresponding to the
line number on the FR Y-9C, HC-C, in
which the outstanding balance is
recorded, or in the case of unused
commitments, the line number in
which the CRE Loan would be recorded
if drawn.
1.
Mandatory
Integer
1
4
Line
Reported on
FR Y-9C
LineReportedOnFRY9C
Supply with no
non-numeric
formatting (no
dollar sign,
commas or
decimal).
2.
Option 7 is a component of a broader
FR Y-9C line.
3.
4.
5.
7.
F158 (1-4
family res
construction)
F159 (Other
constr, land
dev, land,
additions or
alterations to
existing
structures)
1460
(multifamily)
F160
(nonfarm,
nonres owner
occupied)
F161
(nonfarm,
nonres other)
Loans
secured by
CRE
originated by
nondomestic
offices as
2
FR Y-14Q: Commercial Real Estate Schedule Instructions
reported in
bhck1410
5
6
Committed
Balance
Cumulative
Charge-offs
CommittedBalance
CumulativeChargeoffs
The total legal commitment (net of any
charge-offs, ASC 310-30 (originally
issued as SOP 03-3) or fair value
adjustments) of the reporting bank for
the CRE Loan, including both drawn
and committed undrawn amounts.
Rounded whole
dollar amount,
e.g.: 20000000
Mandatory
Numeric
20
Gross cumulative charge-offs
associated with this CRE Loan on the
reporting entity's books.
Rounded whole
dollar amount,
e.g.: 20000000
Mandatory
Numeric
20
No
Yes,
Purchased
Yes, Sold
Optional
Integer
1
First Lien
Subordinate
Lien
Mixed Liens
“B-Note”
Mandatory
Integer
1
Mandatory
Integer
2
Supply with no
non-numeric
formatting (no
dollar sign,
commas or
decimal).
Should be 0 if
there is no chargeoff for the facility.
Should be ‘NA’ for
loans held for sale
or accounted for
under the fair
value option.
7
Participation
Flag
ParticipationFlag
Indicate if the CRE Loan is participated
or syndicated among other financial
institutions.
8
Lien Position
LienPosition
Indicate using integer code if the
mortgage is a first lien on the property
or a subordinate lien. For multiple
properties, report the lien on the
predominant property, if no property
predominates, then report integer
code for “Mixed Liens”. For loans
secured by a pledge of partnership
interests, indicate a subordinate lien
position.
1.
2.
3.
1.
2.
3.
5.
A “B-Note” is a structurally
subordinated position secured by a
senior lien on a property.
9
Property
Type
PropertyType
If the CRE Loan is secured by multiple
property types and one predominates,
indicate the predominant property
type.
If the CRE Loan is secured by multiple
property types and no single one
predominates, indicate integer code
for "Mixed”.
If the loan is secured by a property
type which is not included in the above
list, then indicate integer code for
“Other," e.g., skilled nursing, self
storage, etc.
If the CRE Loan commitment covers
ONLY the land and lot development
phase, then report as "Land and Lot
Development." If however, the CRE
Loan commitment is for land
development AND vertical
construction, report it under the
appropriate category (e.g.
Homebuilders, condo, office).
1. Retail
2. Industrial /
Warehouse
3. Hotel /
Hospitality/G
aming
(including
Resorts)
4. Multi-family
for Rent
(including low
income
housing)
5. Homebuilders
except condo
6. Condo
7. Office
8. Mixed
9. Land and Lot
Development
10. Other
3
FR Y-14Q: Commercial Real Estate Schedule Instructions
10
Origination
Date
OriginationDate
Date the commitment to lend becomes
a legally binding commitment. If the
CRE Loan has been renewed, use that
date as the Origination Date (except
for extension options that were at the
sole discretion of the borrower). The
date given here should be the same
dates used for the data given in fields
12 and 13. The renewal date would
include all credit actions that require
bank approval and that change the
contractual date of the obligation.
Must be in
m/d/yyyy format,
e.g.:
2/1/2005
12/14/1999
Mandatory
Date
10
Must be before or
equal to the
quarter end date
of the data.
11
Location
Location
Provide the ZIP Code for where the
collateral is located. Use the 2 letter
Country Code for foreign properties. If
one CRE Loan is secured by multiple
properties and one location
predominates, specify that location.
Otherwise indicate “Mixed.”
For US: five-digit
ZIP code. If the ZIP
code begins with
zeroes, leading
zeroes must be
specified with no
punctuation. For
other countries,
the 2-letter
country code
(provided at end
of this document).
For multiple
properties without
one
predominating,
use “Mixed”.
Mandatory
Alpha
Numeric
5
12
Net
Operating
Income
NetOperatingIncome
Net Operating Income at origination
(date given in Field #10). NOI is
defined as: "All operating income, net
of operating expenses with the
exception of debt service and
depreciation. Operating expenses
include RE taxes (but not income
taxes), Insurance, common area
maintenance, utilities, replacement
reserves, management fees,
admin/accounting/legal." For CRE
loans for: (1) land and construction
loans not currently generating income
or(2) owner occupied CRE loans
(bhckF160 on the FR Y-9C), populate
with ‘NA’.
Rounded whole
dollar amount
with no cents,
e.g.: 20000000
Mandatory
Alpha
Numeric
10
The NOI should represent the financial
information submitted by the borrower
to the bank as part of the underwriting
decision at origination or renewal,
which may or may not be the same
operating information used in the
appraisal. The actual vacancy at time of
origination or renewal for all
completed projects should already be a
part of the actual financial information
submitted by the borrower.
Replacement reserves, if allocated by
the borrower on the operating
statement, should be deducted from
operating income to arrive at the NOI.
The NOI should represent the best
representation of actual NOI at the
date given in Field # 10. If there has
been significant recent leasing activity,
then rent roll (less expenses)
annualized may be the best NOI
number. If there is seasonality in the
Supply with no
non-numeric
formatting such as
dollar signs,
commas or
decimals but
negative numbers
can be submitted.
For negative
values use a
negative sign ‘‘ not parenthesis
().
Guidelines for
populating:
0 (zero) is to
be used if
the NOI is
actually 0
NA is to be
used if the
loan is (1)
Land and
construction
loans
(bhckF158
and
bhckF159 on
FR Y-9C) not
currently
generating
income or
4
FR Y-14Q: Commercial Real Estate Schedule Instructions
numbers, then actual fiscal or trailing
twelve months NOI may be the best
number. However, NOI should not be
forward looking in the sense of being
based on potential future leasing or
sales activity. The NOI for loans
originated for the purpose of
construction that are currently
generating income should be reported
as the actual NOI from operating
information obtained from the
borrower at renewal.
(2) owner
occupied
CRE loans
(line F160 on
FR Y-9C).
If a participation, prorate based on
your share of the credit. For loans that
are cross-collateralized at origination,
the NOI provided should represent the
total NOI available to service the debt
from the underlying collateral pool.
For loans that are cross-collateralized
after origination, the NOI provided
should be the total NOI available at
origination, not the subsequently
combined NOI from the collateral pool.
13
Value at
Origination
ValueatOrigination
The value of the subject property may
be either an appraisal or an evaluation
depending on legal (12 CFR 34) and
bank policy requirements.
Value is prorated based on the bank's
ownership interest in a facility. In
cases of cross-collateralization, provide
the sum of all property values as
adjusted for prorated participations.
Numeric
values are to
be used for
facilities
where the
NOI is
applicable
and available
Rounded whole
dollar amount
with no cents,
e.g.: 20000000
Alpha
12
Numeric
Do not use nonnumeric
formatting such as
dollar signs,
commas or
decimals.
14
Value Basis
ValueBasis
Provide integer code if the Value in
Field #13 was calculated using an “as
is,” “as stabilized” or “as completed”
value as defined in SR10-16
(http://www.federalreserve.gov/board
docs/srletters/2010/sr1016a1.pdf).
1.
2.
3.
15
Internal
Rating
InternalRating
Bank internal obligor rating that
addresses the probability of default of
the loan.
The general form
looks like this:
Must be a list of values where each
value pair is the bank’s internal risk
rating code followed by the percentage
of total exposure that is rated with that
risk rating. The format of these pairs
will be the rating code followed by a
colon followed by the fractional
amount of the dollar value of the
exposure that has that rating code.
Each pair of rating code-fractional
amount would be separated by a
semicolon and there should be as
many codes as there are different split
ratings in the credit.
Mandatory
As Is
As Stabilized
As Completed
Mandatory
Integer
1
Mandatory
Alpha
Numeric
50
Rating-code-1:%
as decimal;
Rating-code-2:%
as decimal;…+
For example,
suppose the bank
has ratings AAA,
AA, A, BBB, BB, B,
C, D. Suppose the
credit is entirely
rated AAA. The
bank would supply
this value:
AAA:1
Suppose a
different case
where half the
credit’s dollar
5
FR Y-14Q: Commercial Real Estate Schedule Instructions
value has a rating
A and the other
has C. The bank
would supply:
A:0.5;C:0.5
All the decimal
amounts must
sum to 1.
16
Probability
of Default
(PD)
PD
Basel II Advanced IRB parameter
estimate: PD. This is only required for
banks that have already entered
parallel run. It is optional for all others.
Probability of default (PD) means:
(1) to a non-defaulted obligor, the
*bank+’s empirically based best
estimate of the long-run average oneyear default rate for the rating grade
assigned by the [bank] to the obligor,
capturing the average default
experience for obligors in the rating
grade over a mix of economic
conditions (including economic
downturn conditions) sufficient to
provide a reasonable estimate of the
average one-year default rate over the
economic cycle for the rating grade.
Express as a
fraction to 4
decimal places,
e.g., 0.05% is
0.0005. Use
decimal format;
do not use
scientific notation.
Must be nonblank
after Basel 2
parallel starts for
the bank.
Mandatory
for
reporting
banks in
Base II
parallel
Decimal
6
Decimal
4
Numeric
20
Optional
for other
banks
(2) to a defaulted obligor, 100 percent.
17
Loss Given
Default
(LGD)
LGD
Basel II Advanced IRB parameter
estimate: LGD. This is only required
for banks that have already entered
parallel run. It is optional for all others.
Loss given default (LGD) means:
The greatest of:
Express as a
decimal to 2
decimal places,
e.g., 50% is 0.50.
Use decimal
format; do not use
scientific notation.
(1) Zero;
(2) The *bank+’s empirically based best
estimate of the long-run defaultweighted average economic loss, per
dollar of EAD, the [bank] would expect
to incur if the obligor (or a typical
obligor in the loss severity grade
assigned by the [bank] to the exposure)
were to default within a one-year
horizon over a mix of economic
conditions, including economic
downturn conditions; or
Must be nonblank
after Basel 2
parallel starts for
the bank.
Mandatory
for
reporting
banks in
Base II
parallel
Optional
for other
banks
(3) The *bank+’s empirically based best
estimate of the economic loss, per
dollar of EAD, the [bank] would expect
to incur if the obligor (or a typical
obligor in the loss severity grade
assigned by the [bank] to the exposure)
were to default within a one-year
horizon during economic downturn
conditions.
18
Exposure At
Default
(EAD)
EAD
Basel II Advanced IRB parameter
estimate: EAD. This is only required for
banks that have already entered
parallel run. It is optional for all others.
Rounded whole
dollar amount
with no cents,
e.g.: 20000000
For the on-balance sheet component,
EAD means the *bank+’s carrying value
(including net accrued but unpaid
interest and fees) for the exposure
Supply with no
non-numeric
formatting (no
dollar sign,
Mandatory
for
reporting
banks in
Base II
parallel
Optional
6
FR Y-14Q: Commercial Real Estate Schedule Instructions
and;
For the off-balance sheet component
of a loan commitment or line of credit,
EAD means the *bank+’s best estimate
of net additions to the outstanding
amount owed the bank, including
estimated future additional draws of
principal and accrued but unpaid
interest and fees, that are likely to
occur over a one-year horizon
assuming the exposure was to go into
default. This estimate of net additions
must reflect what would be expected
during economic downturn conditions.
commas or
decimal).
for other
banks
Must be nonblank
after Basel 2
parallel starts for
the bank.
19
Maturity
Date
MaturityDate
The contractual maturity date of CRE
Loan, including extension options that
are at the sole discretion of the
borrower. If a demand loan, enter
1/1/9999.
Must be in
m/d/yyyy format,
e.g.:
2/1/2005
12/14/1999
Mandatory
Date
10
20
Amortization
Amortization
The original amortization term of the
loan in months from the date given in
Field #10, regardless whether the loan
amortizes on a straight line basis or
mortgage style. For example, if a loan
amortizes in a straight line fashion over
ten years, enter 120 (months). For
Interest only loans enter zero.
Must be in whole
months, e.g.,
10 years would
120.
Mandatory
Numeric
5
21
Recourse
Recourse
Indicate whether the bank relied on a
sponsor or guarantor as a source of
repayment when considering the credit
for approval.
1. Recourse
Relied Upon
2. No Recourse
Relied Upon
Mandatory
Integer
1
22
Line of
Business
LineOfBusiness
Indicate the internal line of business
that originated the CRE Loan using the
institutions own department
descriptions.
Free text
describing the Line
of Business. For
example: Retail,
Private Banking,
Corporate
Banking, etc.
Optional
Alpha
Numeric
100
23
Current
Occupancy
CurrentOccupancy
Current physical occupancy of rentpaying tenants (including tenants still
in concessionary periods) as a % of net
rentable square footage. Use NA if
owner occupied or residential
construction.
Provide as a
fraction (2 decimal
places), e.g.:
“0.80” for 80%.
Optional
Alpha
Numeric
4
"Current occupancy" means as close to
the submission as of date (e.g. 9-30-09)
as possible (e.g. the occupancy level
last reported by the borrower).
0 (zero) is to
be used if
the
Occupancy is
actually 0
NA is to be
used for
facilities
where the
data
element is
not
applicable i.e.
Residential
Construction
(FR Y-9C
bhckF158),
Other
Guidelines for
populating:
7
FR Y-14Q: Commercial Real Estate Schedule Instructions
Construction
/Land Dev
(FR Y-9C
bhckF159),
and Owner
Occupied (FR
Y-9C
bhckF160).
24
Anchor
Tenant
AnchorTenant
Name of anchor tenant (s), if
applicable. Anchor tenant is defined as
any tenant named in a co-tenancy
clause.
Numeric
values are to
be used for
facilities
where the
Occupancy is
applicable
and available
Must not contain
a vertical bar (|,
ASCII 7C), carriage
return, line feed,
comma or any
unprintable
character.
Optional
Alpha
Numeric
300
If there are
multiple Anchor
tenants, separate
names with a
double semi-colon
‘;;’.
25
Loan
Purpose
LoanPurpose
Indicate the purpose of the CRE Loan at
the origination date as recorded in
Field #10 using an integer from the
following list.
1. Construction
Build to Suit /
credit tenant
lease
(meaning
100%
occupancy to
an investment
grade tenant
on long-term
triple net
lease, and
NOT a large
tenant with
good credit).
2. Land
Acquisition &
Development
3. Construction
Other
4. Owner
Occupancy
5. Redevelopme
nt /
Repositioning
(non owner
occupied)
6. Acquisition
(non owner
occupied)
7. Refinance
8. Other
Mandatory
Integer
1
26
Interest Rate
Variability
InterestRateVariability
Variability of current interest rates
(Fixed, Floating, or Mixed) to maturity.
1.
2.
3.
Mandatory
Integer
1
Fixed
Floating
Mixed
8
FR Y-14Q: Commercial Real Estate Schedule Instructions
27
Interest Rate
InterestRate
Current interest rate charged on the
CRE Loan. If the facility includes
multiple draws with different interest
rates, enter a rate that approximates
the overall rate on the facility
Provide as a
decimal, e.g.:
0.0575 for 5.75%
Mandatory
Decimal
8
28
Interest Rate
Index
InterestRateIndex
For floating rate CRE Loans list base
interest rate using integer code. If
borrower has an option, select the
index actually in use.
1.
2.
3.
4.
5.
LIBOR
PRIME or Base
Treasury Index
Other
Not applicable
(Fixed)
6. Mixed
Mandatory
Integer
1
For floating rate CRE Loans, list spread
from base rate in basis points (this can
be either positive or negative).
Provide as a
decimal, e.g.:
0.0575 for 5.75%
Mandatory
Alpha
Numeric
8
If the CRE loan is fixed (as designated in
Field #26) populate ‘NA’.
Enter ‘NA’ if the
loan is fixed
If the CRE loan includes multiple draws
with different spreads, provide the
spread that approximates the overall
spread on the loan.
Negative numbers
can be submitted.
For negative
values use a
negative sign ‘‘ not parenthesis
().
For floating rate CRE Loans, list rate
ceiling if one is contained in the credit
agreement.
Provide as a
decimal, e.g.:
0.0575 for 5.75%
Mandatory
Alpha
Numeric
8
If there is no ceiling, populate with
‘NONE’.
Enter ‘NA’ if the
loan is fixed
Mandatory
Alpha
Numeric
8
Mandatory
Alpha
Numeric
4
Mandatory
Alpha
Numeric
9
If the CRE loan is fixed (as designated in
Field #26) choose the integer for “Not
applicable (Fixed)”. For loan
commitments where the base interest
rate is mixed, choose the integer for
“Mixed.”
29
30
Interest Rate
Spread
Interest Rate
Ceiling
InterestRateSpread
InterestRateCeiling
If the CRE loan is fixed (as designated in
Field#26) populate ‘NA’.
For loan commitments with multiple
interest rate ceilings, provide the
maximum interest rate ceiling.
31
Interest Rate
Floor
InterestRateFloor
For floating rate CRE Loans, list rate
floor if one is contained in the credit
agreement. If there is no floor,
populate with ‘NONE’.
If the CRE loan is fixed (as designated in
Field #26) populate ‘NA’.
32
33
Frequency of
Rate Reset
Interest
Reserves
FrequencyofRateReset
InterestReserves
Enter ‘NONE’ if no
ceiling.
Provide as a
decimal, e.g.:
0.0575 for 5.75%
Enter ‘NA’ if the
loan is fixed
For loan commitments with multiple
interest rate floors, provide the
minimum interest rate floor.
Enter ‘NONE’ if no
floor.
For floating rate CRE Loans, list the
frequency of interest rate reset in
months. For frequencies less than (1)
month, report as (1) month.
Provide in whole
months.
Provide the dollar amount of remaining
Interest rate reserves. Interest
reserves would represent only those
funds remaining from the original
construction commitment to be used
to pay interest during the construction
and lease-up phases. If a participation,
prorate based on your share of the
credit.
Rounded to whole
dollar amount
with no cents,
punctuation or
dollar signs.
If Interest Reserves are not applicable,
populate ‘NA’.
Enter ‘NA’ if the
loan is fixed
Guidelines for
populating:
0 (zero) is to
be used if
there had
been an
9
FR Y-14Q: Commercial Real Estate Schedule Instructions
interest
reserve and
it is now
exhausted.
34
Origination
Amount
OriginationAmount
Provide the bank’s total commitment
as of the origination date given in Field
#10.
The origination amount should not
represent the first draw on a
commitment.
35
Original /
Previous
Loan
Number
OrigLoanNumber
Bank’s original unique identifier or
previously reported identifier for this
loan record in the event the loan was
converted to a new system through
migration or acquisition.
NA is to be
used for
facilities
where an
interest
reserve was
never part of
the
transaction
(e.g. nonconstruction
loans).
Numeric
values are to
be used for
facilities
where the
interest
reserve is
applicable
and available
Round to the
whole dollar. Do
not include
punctuation or
dollar sign.
Mandatory
Numeric
11
Must be unique
within a
submission.
Mandatory
Alpha
Numeric
50
1. Yes
Mandatory
Integer
1
Mandatory
Integer
1
If the loan number has not changed
from the prior quarter, use the current
loan number (Field #1 above).
36
Acquired
Loan
AcqLoan
Indicate if the loan was acquired as a
whole loan via a bank, portfolio or
individual loan purchase.
2. No
Syndicated loans acquired through this
channel are reported in this field as “1”
(Yes) and also indicated in the
Participation Flag (data field #7). Loans
originated and underwritten by the
reporting bank are reported as “2”
(No).
Acquired loans will include data
retrievable from loan accounting
systems of record reported on a goforward basis.
37
Loan Status
LoanStatus
Report an asset as non-performing if:
1. Performing
(a) It is maintained on a cash basis
because of deterioration in the
financial condition of the borrower,
2. Nonperforming
(b) Payment in full of principal or
interest is not expected, or
(c) Principal or interest has been in
default for a period of 90 days or more
10
FR Y-14Q: Commercial Real Estate Schedule Instructions
unless the asset is both well secured
and in the process of collection.
38
Property Size
PropertySize
Report the current property size for
the Property Type entered in Field #9
as follows:
Retail: Square Feet
Industrial/Warehouse: Square Feet
Hotel/Hospitality/Gaming: Rooms
Values must be
consistent with
the property type
definitions in Field
#9
Mandatory
Alpha/
12
Numeric
Whole number
(no commas or
decimals)
Multi-family for rent: Units
Homebuilders except condo: Lots
Condo: Units
Office: Square Feet
Mixed: Square Feet or ‘NA’ (Not
Applicable)
Land and Lot Development: Acreage
Other: Square Feet or ‘NA’ (Not
Applicable)
*Mixed is a
category that has
been defined in
the Property Type
description as the
value to use if the
CRE loan is
secured by
multiple property
types and no
single one
predominates. If
the mixed
property consists
primarily of office,
retail or industrial
space, then the
value should be in
square feet. To
the extent that
square feet is not
the predominant
measure, then
populate the field
with ‘NA ‘.
*Other is a
category that has
been defined in
the Property Type
description as the
value to use if the
CRE loan is
secured by a
property type
which is not
included in the
list. If that
property is
primarily office,
retail or industrial
space, then the
value should be in
square feet. To
the extent that
square feet is not
the appropriate
value, then the
field should be
populated with
‘NA ‘.
39
Net
Operating
Income
CurrentNetOperatingInc
Report the most recent annualized NOI
that serves as the identified primary
Rounded whole
dollar amount
with no cents,
Mandatory
Alpha
Numeric
10
11
FR Y-14Q: Commercial Real Estate Schedule Instructions
(NOI)
Current
source of repayment.
NOI period may be prior fiscal year,
trailing twelve months, or annualized
interim period if appropriate.
NOI should not be forward looking in
the sense of being based on potential
future leasing or sales activity.
Replacement reserves, if allocated by
the borrower on the operating
statement, should be deducted from
operating income to arrive at the NOI.
e.g.: 20000000
Supply with no
non-numeric
formatting such as
dollar signs,
commas or
decimals but
negative numbers
can be submitted.
For negative
values use a
negative sign ‘‘ not parenthesis
().
NOI is prorated based on the bank’s
ownership interest in a facility and/or
NOI is a shared repayment source
among other debt obligations as
identified in the credit agreement.
Guidelines for
populating:
0 (zero) is to
be used if
the NOI is
actually 0
For cross-collateralized loans, the NOI
provided should represent the total
NOI available from the underlying
collateral pool.
NA is to be
used if the
loan is (1)
Land and
construction
loans
(bhckF158
and
bhckF159 on
FR Y-9C) not
currently
generating
income or
(2) owner
occupied
CRE loans
(bhckF160
on FR Y-9C).
Numeric
values are to
be used for
facilities
where the
NOI is
applicable
and available
The NOI for loans originated for the
purpose of construction that are
currently generating income should be
reported as the actual NOI from
operating information obtained from
the borrower at renewal.
40
Last NOI
Date
LastNOIDate
The date for the value provided in
CurrentNetOperatingInc (Field #39).
Must be in
m/d/yyyy format,
e.g.:
2/1/2005
12/14/1999
Mandatory
Date
10
Must be before or
equal to the
quarter end date
of the data.
This date may be
Null if the Net
Operating Income
(NOI) Current
(Field #39) is ‘NA’.
12
FR Y-14Q: Commercial Real Estate Schedule Instructions
41
42
Current
Value
Last
Valuation
Date
CurrentValue
LastValuationDate
The value of the subject property may
be either an appraisal or an evaluation
depending on legal (12 CFR 34) and
bank policy requirements.
Rounded whole
dollar amount
with no cents,
e.g.: 20000000
Value is prorated based on the bank's
ownership interest in a facility. In
cases of cross-collateralization, provide
the sum of all property values as
adjusted for prorated participations.
Supply with no
non-numeric
formatting such as
dollar signs,
commas or
decimals.
The date of the most recent valuation
provided in Current Value (Field #41).
Must be in
m/d/yyyy format,
e.g.:
2/1/2005
Mandatory
Alpha
12
Numeric
Mandatory
Date
10
Mandatory
Alpha
1000
12/14/1999
Must be before or
equal to the
quarter end date
of the data.
43
Cross
Collateralize
d Loan
Numbers
CrossCollaterlizedLoans
Enter the LoanNumbers (Field #1) for
all the loans which are crosscollateralized with loan reported in
Field 1. This includes loans that have
less than $1 million committed.
Provide the
LoanNumber
separated by a ,
(comma). For
example, if loans
123 and XYZ are
crosscollateralized then
enter 123, XYZ.
Numeric
The provided loan
numbers must
have a
corresponding
entry in the CRE
collection. Crosscollateralized
loans that are not
CRE Loans should
be excluded.
44
Additional
Collateral
AdditionalCollateral
Provide the value of any cash and
marketable securities that are pledged
as collateral and where the bank has a
first perfected security interest.
Rounded whole
dollar amount
with no cents,
e.g.: 20000000
Optional
Numeric
12
Mandatory
Numeric
12
Mandatory
Numeric
12
Supply with no
non-numeric
formatting such as
dollar signs,
commas or
decimals.
45
ASC 310-10
ASC31010
Reserve applied to the loan per ASC
310-10 (formerly FASB 114 Accounting
by Creditors for impairment of a loan)
Rounded whole
dollar amount
with no cents,
e.g.: 20000000
Should be 0 if
there is no ASC
310-10 Reserve
for the loan
46
ASC 310-30
ASC31030
Adjustment per ASC 310-30 for certain
loans or Debt securities acquired in a
Rounded whole
13
FR Y-14Q: Commercial Real Estate Schedule Instructions
transfer. Provide if available at the
loan level.
dollar amount
with no cents,
e.g.: 20000000
Should be 0 if
there is no ASC
310-30 Reserve
for the loan
47
Fair Value
Adjustment
FairValueAdjustment
For held for sale loans and loans
accounted for under the fair value
option, include the dollar amount
adjustment (positive or negative) from
the par balance.
Rounded whole
dollar amount
with no cents,
e.g.: 20000000.
Mandatory
Alpha
Numeric
20
For negative
values use a
negative sign “-“,
not parentheses.
Should be 0 for
loans valued at
par.
Should be ‘NA’ for
loans not held for
sale or accounted
for under the fair
value option.
Appendix: Additional Instructions for Completing the Commercial Real Estate Data Collection
Field 11: 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
14
FR Y-14Q: Commercial Real Estate Schedule Instructions
15
FR Y-14Q: Commercial Real Estate Schedule Instructions
16
| File Type | application/pdf |
| File Modified | 2011-11-17 |
| File Created | 2011-11-17 |