ESMA Commercial Real Estate Collateral Table
From Open Risk Manual
Table Fields
| Field | Type | Definition |
|---|---|---|
| ESMA Commercial Real Estate.Collateral.Unique Identifier | ALPHANUM-28 | Report the same unique identifier here as the one entered into field CREL1. |
| ESMA Commercial Real Estate.Collateral.Underlying Exposure Identifier | ALPHANUM-1000 | Unique underlying exposure identifier. This must match the identifier in field CREL5. The reporting entity shall not amend this unique identifier. |
| ESMA Commercial Real Estate.Collateral.Original Collateral Identifier | ALPHANUM-1000 | The original unique identifier assigned to the collateral. The reporting entity shall not amend this unique identifier. |
| ESMA Commercial Real Estate.Collateral.New Collateral Identifier | ALPHANUM-1000 | If the original identifier in field CREC3 cannot be maintained in this field enter the new identifier here. If there has been no change in the identifier, enter the same identifier as in CREC3. The reporting entity shall not amend this unique identifier. |
| ESMA Commercial Real Estate.Collateral.Collateral Type | LIST | The primary (in terms of value) type of asset securing the debt. Where there is a guarantee backed by physical or financial collateral, look through the guarantee to any collateral that may be supporting that guarantee
|
| ESMA Commercial Real Estate.Collateral.Property Name | ALPHANUM-100 | The name of the property that serves as security for the underlying exposure.
If the collateral being reported is not property collateral, enter ND5. |
| ESMA Commercial Real Estate.Collateral.Property Address | ALPHANUM-1000 | The address of the property that serves as security for the underlying exposure.
If the collateral being reported is not property collateral, enter ND5. |
| ESMA Commercial Real Estate.Collateral.Geographic Region - Collateral | NUTS | The geographic region (NUTS3 classification) where the physical collateral is located. Where no NUTS3 classification has been produced by Eurostat (e.g. a non-EU jurisdiction), enter the two-digit country code in {COUNTRYCODE_2} format followed by 'ZZZ'. |
| ESMA Commercial Real Estate.Collateral.Property Post Code | ALPHANUM-100 | The primary property full postal code.
If the collateral being reported is not property collateral, enter ND5. |
| ESMA Commercial Real Estate.Collateral.Lien | INTEGER-9999 | Highest lien position held by the originator in relation to the collateral. |
| ESMA Commercial Real Estate.Collateral.Property Status | LIST | Status of property
|
| ESMA Commercial Real Estate.Collateral.Property Type | LIST | Property type
|
| ESMA Commercial Real Estate.Collateral.Property Form Of Title | LIST | The relevant form of property title. A lease on land only, in which the obligor usually owns a building or is required to build as specified in the lease. Such leases are usually long-term net leases; the obligor's rights and obligations continue until the lease expires or is terminated through default
|
| ESMA Commercial Real Estate.Collateral.Current Valuation Date | DATEFORMAT | The date of the most recent valuation. |
| ESMA Commercial Real Estate.Collateral.Current Valuation Amount | MONETARY | The most recent valuation of the property as assessed by an independent external or internal appraiser; if such assessment is not available, the current value of the property can be estimated using a real estate value index sufficiently granular with respect to geographical location and type of property; if such real estate value index is also not available, a real estate price index sufficiently granular with respect to geographical location and type of property can be used after application of a suitably chosen mark-down to account for the depreciation of the property.
If the collateral being reported is not property collateral, enter the most recent valuation of the collateral as assessed by an independent external or internal appraiser or, if not available, by the originator. Include the currency in which the amount is denominated, using {CURRENCYCODE_3} format. |
| ESMA Commercial Real Estate.Collateral.Current Valuation Method | LIST | The most recent method of calculating the value of the collateral provided in field CREC15
|
| ESMA Commercial Real Estate.Collateral.Current Valuation Basis | LIST | The most recent Valuation Basis
|
| ESMA Commercial Real Estate.Collateral.Original Valuation Method | LIST | The method of calculating the value of the collateral at the time of underlying exposure origination
|
| ESMA Commercial Real Estate.Collateral.Collateral Securitisation Date | DATEFORMAT | Date the property / collateral was contributed as security for the underlying exposure. If this property / collateral has been substituted, enter the date of the substitution. If the property / collateral was part of the original securitisation, this will be the Securitisation Date. |
| ESMA Commercial Real Estate.Collateral.Allocated Percentage Of Underlying Exposure At Securitisation Date | PERCENTAGE | Allocated underlying exposure % attributable to property / collateral at Securitisation Date where there is more than one property / collateral item securing the underlying exposure. This may be set out in the underlying exposure Agreement, otherwise assign by valuation or Net Operating Income. |
| ESMA Commercial Real Estate.Collateral.Current Allocated Underlying Exposure Percentage | PERCENTAGE | Allocated underlying exposure % attributable to the collateral at the underlying exposure payment date. Where there is more than one collateral item securing the underlying exposure, the sum of all percentages shall equal 100%. This may be set out in the underlying exposure agreement, otherwise assign by valuation (Net Operating Income). |
| ESMA Commercial Real Estate.Collateral.Valuation At Securitisation | MONETARY | The valuation of the property / collateral securing the underlying exposure at Securitisation Date as described in the Offering Circular.
Include the currency in which the amount is denominated, using {CURRENCYCODE_3} format. |
| ESMA Commercial Real Estate.Collateral.Name Of Valuer At Securitisation | ALPHANUM-100 | Name of valuation firm who performed the property / collateral valuation at the Date of Securitisation. |
| ESMA Commercial Real Estate.Collateral.Date Of Valuation At Securitisation | DATEFORMAT | The date the valuation was prepared for the values disclosed in the Offering Circular. |
| ESMA Commercial Real Estate.Collateral.Year Built | YEAR | Year the property was built per the valuation report or underlying exposure document. |
| ESMA Commercial Real Estate.Collateral.Year Last Renovated | YEAR | Year that last major renovation/new construction was completed on the property per the valuation report or underlying exposure document. |
| ESMA Commercial Real Estate.Collateral.Number Of Units | INTEGER-999999999 | For property type Multifamily enter number of units, for Hospitality/Hotel/Healthcare - beds, for Caravan Parks - units, Lodging=rooms, Self Storage=units. |
| ESMA Commercial Real Estate.Collateral.Net Square Metres | INTEGER-999999999 | The total net rentable area of the property in square metres that serve as security for the underlying exposure per the most recent valuation report.
Include the currency in which the amount is denominated, using {CURRENCYCODE_3} format. |
| ESMA Commercial Real Estate.Collateral.Commercial Area | INTEGER-999999999 | The total net Commercial rentable area of the property in square metres that serves as security for the underlying exposure per the most recent valuation report.
Include the currency in which the amount is denominated, using {CURRENCYCODE_3} format. |
| ESMA Commercial Real Estate.Collateral.Residential Area | INTEGER-999999999 | The total net Residential rentable area of the property in square metres that serves as security for the loan per the most recent valuation report.
Include the currency in which the amount is denominated, using {CURRENCYCODE_3} format. |
| ESMA Commercial Real Estate.Collateral.Net Internal Floor Area Validated | Y/N | Has the valuer (of the most recent valuation) verified the net internal floor area of the property? |
| ESMA Commercial Real Estate.Collateral.Occupancy As Of Date | DATEFORMAT | Date of most recently received rent roll/ tenancy schedule. For hospitality (hotels), and health care properties use average occupancy for the period for which the financial statements are reported. |
| ESMA Commercial Real Estate.Collateral.Economic Occupancy At Securitisation | PERCENTAGE | The percentage of rentable space with signed leases in place at Securitisation Date if disclosed in Offering Circular (tenants may not be in occupation but are paying rent). |
| ESMA Commercial Real Estate.Collateral.Physical Occupancy At Securitisation | PERCENTAGE | At Securitisation the available percentage of rentable space actually occupied (i.e. where tenants are actually in occupation and not vacated), if disclosed in Offering Circular. Shall be derived from a rent roll or other document indicating occupancy consistent with most recent financial year information. |
| ESMA Commercial Real Estate.Collateral.Vacant Possession Value At Securitisation Date | MONETARY | Vacant possession value at Date of Securitisation.
Include the currency in which the amount is denominated, using {CURRENCYCODE_3} format. |
| ESMA Commercial Real Estate.Collateral.Date Of Financials At Securitisation | DATEFORMAT | The end date of the financials for the information used in the Offering Circular (e.g. year to date, annual, quarterly or trailing 12 months). |
| ESMA Commercial Real Estate.Collateral.Net Operating Income At Securitisation | MONETARY | Revenue less Operating Expenses at Securitisation Date.
Include the currency in which the amount is denominated, using {CURRENCYCODE_3} format. |
| ESMA Commercial Real Estate.Collateral.Most Recent Financials As Of Start Date | DATEFORMAT | The first day of the period covered in the most recent financial operating statement available (e.g. Monthly, Quarterly, Year to Date or Trailing 12 months). |
| ESMA Commercial Real Estate.Collateral.Most Recent Financials As Of End Date | DATEFORMAT | The end date of the financials used for the most recent financial operating statement (e.g. Monthly, Quarterly, Year to Date or Trailing 12 months). |
| ESMA Commercial Real Estate.Collateral.Most Recent Revenue | MONETARY | Total revenues for the period covered by the most recent financial operating statement (e.g. Monthly, Quarterly, Year to Date or Trailing 12 months) for the property.
Include the currency in which the amount is denominated, using {CURRENCYCODE_3} format. |
| ESMA Commercial Real Estate.Collateral.Most Recent Operating Expenses | MONETARY | Total operating expenses for the period covered by the most recent financial operating statement (e.g. Monthly, Quarterly, Year to Date or Trailing 12 months) for the property. These may include real estate taxes, insurance, management, utilities, maintenance and repairs and direct property costs to the landlord; capital expenditures and leasing commissions are excluded.
Include the currency in which the amount is denominated, using {CURRENCYCODE_3} format. |
| ESMA Commercial Real Estate.Collateral.Most Recent Capital Expenditure | MONETARY | Total Capital Expenditure (as opposed to repairs and maintenance) for the period covered by the most recent financial operating statement e.g. Monthly, Quarterly, Year to Date or Trailing 12 months) for the property.
Include the currency in which the amount is denominated, using {CURRENCYCODE_3} format. |
| ESMA Commercial Real Estate.Collateral.Ground Rent Payable | MONETARY | If property is leasehold, provide the current annual leasehold rent payable to the lessor.
Include the currency in which the amount is denominated, using {CURRENCYCODE_3} format. |
| ESMA Commercial Real Estate.Collateral.Weighted Average Lease Terms | PERCENTAGE | Weighted average lease terms in years, using as weights the latest-available outstanding value of the lease. |
| ESMA Commercial Real Estate.Collateral.Property Leasehold Expiry | DATEFORMAT | Provide the earliest date the leasehold interest expires. |
| ESMA Commercial Real Estate.Collateral.Contractual Annual Rental Income | MONETARY | The contractual annual rental income derived from the most recent obligor tenancy schedule.
Include the currency in which the amount is denominated, using {CURRENCYCODE_3} format. |
| ESMA Commercial Real Estate.Collateral.Income Expiring 1-12 Months | PERCENTAGE | Percentage of income expiring in 1 to 12 months. |
| ESMA Commercial Real Estate.Collateral.Income Expiring 13-24 Months | PERCENTAGE | Percentage of income expiring in 13 to 24 months. |
| ESMA Commercial Real Estate.Collateral.Income Expiring 25-36 Months | PERCENTAGE | Percentage of income expiring in 25 to 36 months. |
| ESMA Commercial Real Estate.Collateral.Income Expiring 37-48 Months | PERCENTAGE | Percentage of income expiring in 37 to 48 months. |
| ESMA Commercial Real Estate.Collateral.Income Expiring 49+ Months | PERCENTAGE | Percentage of income expiring in 49 or more months. |
Disclaimer
- This text is generated automatically. Do not edit manually!
- This information is provided as is. Refer to the ESMA Securitisation Template for pointers to definitive instructions
