v7970_m

warningactivewithin F 23.0340 cells · general rule

Expression · DPM 2.0, verbatim

with {tF_23.03, r*, default: 0, interval: true}: {c0010} >= {c0020}

EBA description {c0010} >= {c0020}

Precondition p_422 (its meaning is not in the data yet)

Cells involved

F 23.03 Loans and advances collateralised by immovable property: Breakdown by LTV ratios

Open template →

	c0010Gross carrying amount	c0020of which: Exposures with forbearance measures
0010Loans and advances collateralised by immovable property	in rule	in rule
0020Loans and advances collateralised by immovable property › of which: Loans with a LTV higher than 60% and lower than or equal to 80%	in rule	in rule
0030Loans and advances collateralised by immovable property › of which: Loans with a LTV higher than 80% and lower than or equal to 100%	in rule	in rule
0040Loans and advances collateralised by immovable property › of which: Loans with a LTV higher than 100%	in rule	in rule
0050Loans and advances to small and medium-sized enterprises (NFCs) collateralised by commercial immovable property	in rule	in rule
0060Loans and advances to small and medium-sized enterprises (NFCs) collateralised by commercial immovable property › of which: Loans with a LTV higher than 60% and lower than or equal to 80%	in rule	in rule
0070Loans and advances to small and medium-sized enterprises (NFCs) collateralised by commercial immovable property › of which: Loans with a LTV higher than 80% and lower than or equal to 100%	in rule	in rule
0080Loans and advances to small and medium-sized enterprises (NFCs) collateralised by commercial immovable property › of which: Loans with a LTV higher than 100%	in rule	in rule
0090Loans and advances to non-financial corporations (NFCs) other than SMEs collateralised by commercial immovable property	in rule	in rule
0100Loans and advances to non-financial corporations (NFCs) other than SMEs collateralised by commercial immovable property › of which: Loans with a LTV higher than 60% and lower than or equal to 80%	in rule	in rule
0110Loans and advances to non-financial corporations (NFCs) other than SMEs collateralised by commercial immovable property › of which: Loans with a LTV higher than 80% and lower than or equal to 100%	in rule	in rule
0120Loans and advances to non-financial corporations (NFCs) other than SMEs collateralised by commercial immovable property › of which: Loans with a LTV higher than 100%	in rule	in rule
0130Commercial Real Estate loans to small and medium-sized enterprises (NFCs) collateralised by immovable property	in rule	in rule
0140Commercial Real Estate loans to small and medium-sized enterprises (NFCs) collateralised by immovable property › of which: Loans with a LTV higher than 60% and lower than or equal to 80%	in rule	in rule
0150Commercial Real Estate loans to small and medium-sized enterprises (NFCs) collateralised by immovable property › of which: Loans with a LTV higher than 80% and lower than or equal to 100%	in rule	in rule
0160Commercial Real Estate loans to small and medium-sized enterprises (NFCs) collateralised by immovable property › of which: Loans with a LTV higher than 100%	in rule	in rule
0170Commercial Real Estate loans to non-financial corporations (NFCs) other than SMEs) collateralised by immovable property	in rule	in rule
0180Commercial Real Estate loans to non-financial corporations (NFCs) other than SMEs) collateralised by immovable property › of which: Loans with a LTV higher than 60% and lower than or equal to 80%	in rule	in rule
0190Commercial Real Estate loans to non-financial corporations (NFCs) other than SMEs) collateralised by immovable property › of which: Loans with a LTV higher than 80% and lower than or equal to 100%	in rule	in rule
0200Commercial Real Estate loans to non-financial corporations (NFCs) other than SMEs) collateralised by immovable property › of which: Loans with a LTV higher than 100%	in rule	in rule

Scope by module

Module	Severity	Status	From
FINREP9 3.3.0	warning	active	2026-03-31
FINREP9DP 1.0.0	warning	active	2026-03-31
FINREP9DP 1.1.0	warning	active	2026-03-31

VALIDATION RULE

v7970_m

What it is

Type: Validation rule · within one template, general rule
Release: FINREP 4.4 validation · reported from 2026-03-31
Source: DPM 2.0 4.4 · operation 17350 · official

Regulation16

From the rows and columns of the cells involved.

Annex V Part 1 §32 F 23.03 r0010, r0050, r0090, r0130, r0170, c0010
‘Loans and advances’ are debt instruments held by the institutions that are not securities. That item includes loans as defined in the Table of Part 2 of Annex II to the ECB BSI Regulation (including demand deposits at credit institutions and central banks, irrespective of their classification as per the applicable accounting framework) as well as advances that cannot be classified as ‘loans’ defined in the Table of Part 2 of Annex II to the ECB BSI Regulation. ‘Advances that are not loans’ are further characterized in paragraph 85(g) of Part 2 of this Annex.
Annex V Part 1 §42 F 23.03 r0050, r0090, r0130, r0170
Where a breakdown by counterparty is required the following counterparty sectors shall be used: (a) central banks; (b) general governments: central governments, state or regional governments, and local governments, including administrative bodies and non-commercial undertakings, but excluding public companies and private companies held by these administrations that have a commercial activity (which shall be reported under ‘credit institutions’, ‘other financial corporations’ or ‘non-financial corporations’ depending on their activity); social security funds; and international organisations, such as institutions of the European Union, the International Monetary Fund and the Bank for International Settlements; (c) credit institutions: any institution covered by the definition in point (1) of Article 4(1) CRR (‘undertaking the business of which is to take deposits or other repayable funds from the public and to grant credits for its own account’) and multilateral development banks (MDBs); (d) other financial corporations: all financial corporations and quasi-corporations, other than credit institutions, such as investment firms, investment funds, insurance companies, pension funds, collective investment undertakings, and clearing houses as well as remaining financial intermediaries, financial auxiliaries and captive financial institutions and money lenders; (e) non-financial corporations (NFCs): corporations and quasi-corporations not engaged in financial intermediation but principally in the production of market goods and non-financial services, as defined in the Table of Part 3 of Annex II to the ECB BSI Regulation; (f) households: individuals or groups of individuals as consumers and producers of goods and non-financial services exclusively for their own final consumption, and as producers of market goods and non-financial and financial services provided that their activities are not those of quasi-corporations. Non-profit institutions which serve households (‘NPISH’) and which are principally engaged in the production of non-market goods and services intended for particular groups of households shall be included.
Annex V Part 1 §44 F 23.03 r0010, r0050, r0090, r0130, r0170
The immediate counterparties in the following transactions shall be: (a) for loans and advances, the immediate borrower. For trade receivables, the immediate borrower shall be the counterparty obliged to pay the receivables, except in transactions with recourse, where the immediate borrower shall be the transferor of receivables where the reporting institution does not acquire substantially all the risks and rewards of ownership of the transferred receivables; (b) for debt securities (including securitisation instruments) and equity instruments, the issuer of the securities; (c) for deposits, the depositor; (d) for short positions, the counterparty of the securities borrowing transaction or reverse repurchase agreement; (e) for derivatives, the direct counterparty of the derivative contract. For centrally cleared OTC derivatives, the direct counterparty shall be the clearing house acting as a central counterparty. Counterparty breakdown for credit risk derivatives refers to the sector where the counterparty of the contract (buyer or seller of protection) belongs; (f) for financial guarantees given, the counterparty shall be the direct counterparty of the underlying guaranteed debt instrument; (g) for loan commitments and other commitments given, the counterparty whose credit risk is assumed by the reporting institution; (h) for loan commitments, financial guarantees and other commitments received, the guarantor or the counterparty that has provided the commitment to the reporting institution.
Annex V Part 2 §86 F 23.03 r0010, r0050, r0090, r0130, r0170
Loans and advances shall be classified on the basis of the collateral received as follows: (a) ‘Loans collateralized by immovable property’ shall include loans and advances formally secured by residential or commercial immovable property collateral, regardless of their loan/collateral ratio (commonly referred as ‘loan-to-value’) and the legal form of the collateral; (b) ‘Other collateralized loans’ shall include loans and advances formally secured by collateral, regardless of their loan/collateral ratio (commonly referred to as ‘loan-to-value’ (LTV) ratio) and the legal form of the collateral, other than ‘Loans collateralised by immovable property’. That collateral shall include pledges of securities, cash, and other collateral, regardless of the legal form of the collateral.
Annex V Part 2 §87 F 23.03 r0010, r0050, r0090, r0130, r0170
Loans and advances shall be classified based on the collateral and irrespective of the purpose of the loan. The carrying amount of loans and advances secured by more than one type of collateral shall be classified and reported as collateralised by immovable property where those loans and advances are secured by immovable property regardless of whether they are also secured by other types of collateral.
Annex V Part 2 §239x F 23.03 r0020, r0030, r0040, r0060, r0070, r0080, r0100, r0110, r0120, r0140, r0150, r0160, r0180, r0190, r0200
The LTV ratio shall be calculated in accordance with the method for the calculation of the ‘current loan-to-value ratio’ (LTV-C) laid down in section 2, chapter 1, paragraph 1 of the ESRB Recommendation on closing real estate data gaps.

Show all (15)

Annex V Part 2 §239ix F 23.03 r0130, r0170
‘Commercial real estate (CRE) loans’ shall comprise exposures as defined in section 2, chapter 1, paragraph 1 of the ESRB Recommendation on closing real estate data gaps.
Annex V Part 2 §256 F 23.03 c0020
Forborne exposures shall be included in the non-performing exposures category or the performing exposures category in accordance with paragraphs 213 to 239 and 260 of this Part. The classification as forborne exposure shall be discontinued where all of the conditions provided in Article 47a(7) CRR are met.
Annex V Part 2 §259 F 23.03 c0020
A forborne exposure may be considered as performing from the date the forbearance measures were applied where both of the following conditions are met: (a) that extension has not led the exposure to be classified as non-performing; (b) the exposure was not considered to be a non-performing exposure at the date the forbearance measures were extended.
Annex V Part 2 §260 F 23.03 c0020
Where additional forbearance measures are applied to a performing forborne exposure under probation that has been reclassified out of non-performing category or the forborne exposure under probation reclassified out of non-performing category becomes more than 30 days past due, the exposure shall be classified as non-performing in accordance with point (c) of Article 47a(3) CRR.
Annex V Part 2 §261 F 23.03 c0020
‘Performing exposures with forbearance measures’ (performing forborne exposures) shall comprise forborne exposures that do not meet the criteria to be considered as non-performing and that are included in the performing exposures category. Performing forborne exposures shall be under probation until all the criteria laid down in Article 47a(7) CRR, including where paragraph 259 of this Part applies, are met. Performing forborne exposures under probation that have been reclassified out of the non-performing forborne exposures category shall be reported separately within the performing exposures with forbearance measures in the column ‘of which: Performing forborne exposures under probation reclassified from non-performing’.
Annex V Part 2 §262 F 23.03 c0020
‘Non-performing exposures with forbearance measures’ (non-performing forborne exposures) shall comprise forborne exposures that meet the criteria to be considered as non-performing and that are included in the non-performing exposures category. Those non-performing forborne exposures shall include the following: (a) exposures which have become non-performing due to the application of forbearance measures; (b) exposures which were non-performing prior to the extension of forbearance measures; (c) forborne exposures which have been reclassified from the performing category, including exposures reclassified in application of paragraph 260.
Annex V Part 2 §263 F 23.03 c0020
Where forbearance measures are extended to exposures which were non-performing prior to the extension of forbearance measures, the amount of those forborne exposures shall be separately identified in the column ‘of which: forbearance of exposures non-performing prior to forbearance measures’.
Annex V Part 2 §319 F 23.03 r0010, r0050, r0090, r0130, r0170
Template 23 presents additional information on loans and advances, excluding loans and advances classified as cash balances at central banks and other demand deposits, held for trading, trading financial assets and debt instruments held for sale.
Annex V Part 2 §325 F 23.03 r0020, r0030, r0040, r0060, r0070, r0080, r0100, r0110, r0120, r0140, r0150, r0160, r0180, r0190, r0200
Loans collateralised by immovable property as defined in paragraphs 86(a) and 87 of this Part as well as commercial real estate loans as defined in paragraph 239ix of this Part shall be reported broken down by loan/collateral ratio (‘loan-to-value’ (LTV) ratio) as defined in paragraph 239x of this Part.

Other acts

SME Rec. art 1 2(a)

Controls18

18 other rules use at least one of these cells.

Other rules on the same cells

v8323_swarning40
with {tF_23.03, r*, default: null, interval: false}: {(c0010, c0020, c0030, c0050, c0060, c0070, c0080, c0090, c0100, c0110)} >= 0
v8320_hwarning20
(Hierarchy IM31) [Not applicable/ Total exposures] must be equal to +[Non-performing exposures] + [Performing exposures]
v89820_hwarning20
with{tF_23.03, r*, default: 0, interval: true}: {c0020} = {c0070} + {c0050}
v7978_mwarning8
{r0010} >= {r0020} + {r0030} + {r0040}
v7981_mwarning8
{r0050} >= {r0060} + {r0070} + {r0080}
v7982_mwarning8
{r0090} >= {r0100} + {r0110} + {r0120}
v7983_mwarning8
{r0130} >= {r0140} + {r0150} + {r0160}
v7984_mwarning8
{r0170} >= {r0180} + {r0190} + {r0200}
v903296_hwarning8
with{c0010-0030, default: 0, interval: true}: abs({tF_18.02.a, r0030-0060}) >= abs({tF_23.03, r0050-0080})
v7979_mwarning6
{r0010} >= {r0050} + {r0090}
v7980_mwarning6
{r0010} >= {r0130} + {r0170}
v7968_mwarning2
sum({F 23.03, (r0050, r0090), c0010}) = {F 18.02.a, r0030, c0010}
v7969_mwarning2
sum({F 23.03, (r0050, r0090), c0020}) = {F 18.02.a, r0030, c0020}
v7963_mwarning1
{F 23.03, r0010, c0010} <= {F 05.01, r0090, c0005}
v7964_mwarning1
{F 23.03, r0130, c0010} <= {F 18.02.a, r0010, c0010}
v7965_mwarning1
{F 23.03, r0130, c0020} <= {F 18.02.a, r0010, c0020}
v7966_mwarning1
{F 23.03, r0170, c0010} <= {F 18.02.a, r0020, c0010}
v7967_mwarning1
{F 23.03, r0170, c0020} <= {F 18.02.a, r0020, c0020}

Interpretation—

No EBA Q&A cites this rule.

Changes—

No change to this rule between the releases loaded.

Source: the DPM 2.0 database of the release shown above (expression, description, scope, cells; official). References inherited from Annex I (verbatim) and EBA instructions 4.2; links and counts are derived.