{"text_format":"2","workbook":"xlsx","n_sheets":18,"sheets":["Disclaimer","Introduction","Completion Instructions","FAQ","A. HTT General","B1. HTT Mortgage Assets","B2. HTT Public Sector Assets","B3. HTT Shipping Assets","erweitertes vdp-Template","extended vdp-Template","C. HTT Harmonised Glossary","D. Insert Nat Trans Templ","E. Optional ECB-ECAIs data","F1. Sustainable M data","F2. Sustainable PS data","G1. Crisis M Payment Holidays","E.g. General","E.g. Other"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":17,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":169,"n_cols":1,"rows_kept":169,"cut":false,"hidden":false,"merged":[]}
["Disclaimer - Important notices "]
[]
[]
["(i) The Product Information displayed on this Site has been uploaded by the Issuers of the relevant Products. None of the information displayed on this Site shall form the basis of any contract. Any User of this Site will be required to acknowledge that it has not relied on, or been induced to enter into any contract by, any representation or warranty."]
["(ii) The Covered Bond Label Foundation has not independently verified the Product Information displayed on this Site. Accordingly, no representation, warranty or undertaking, express or implied, is made, and no responsibility is accepted, by the Covered Bond Label Foundation as to or in relation to the accuracy or completeness or otherwise of such Product Information.\""]
["(iii) The information provided on or accessible through the Site is not intended for distribution to, or use by, any person or entity in any jurisdiction where such distribution or use would be contrary to local law, or which would subject us or any Issuer, to any authorisation, registration or other requirement within such jurisdiction. You agree not to use or export the information or materials available on or through this Site in violation of laws in your jurisdiction."]
[]
["TERMS OF USE"]
["This website www.coveredbondlabel.com (the \"Site\") is owned and operated by the Covered Bond Label Foundation (the Covered Bond Label Foundation together with its affiliates, \"we\" or \"us\") a Private Foundation (fondation privée / private stichting) registered in Belgium; whose registered office is at Rue de la Science 14 - 1040 Brussels - Belgium and registered under number 500.950.659 (RPR/RPM Brussels)."]
["The Site is intended for use as a directory of information relating to certain covered bond products (\"Products\") (the \"Product Information\") by an issuer of (\"Issuer\"), or potential investor in (\"Investor\"), such Products (an Issuer, Investor, or any other person accessing this Site, each a \"User\" or \"you\"). The Product Information is provided by each relevant Issuer, and remains at all times the sole responsibility of the relevant Issuer. We have not independently verified any Product Information, nor reviewed whether any Product for which information is available on the Site actually is a covered bond product. This Site or any label made available through it does not constitute, nor contain, any form of credit rating, any offer to sell (or the solicitation of an offer to purchase) any Product, nor does it constitute a recommendation, or investment advice (or any other type of advice) upon which reliance should be placed."]
[" These terms and conditions together with the documents referred to in them set out the terms of use (\"T&Cs\") on which (a) an Issuer; (b) Investor; or (c) any other User, may make use of the Site. Section A applies primarily to Investors, and Section B applies primarily to Issuers. The General T&Cs in Section C apply to all Users."]
["Our Acceptable Use Policy and Privacy Policy are incorporated into these T&Cs."]
[" Please read the T&Cs carefully before you start to use the Site. By clicking 'Accept' you indicate that you accept these T&Cs and that you agree to abide by them."]
["If any provision of these T&Cs shall be deemed unlawful, void or for any reason unenforceable, then that provision shall be deemed severable from these terms and shall not affect the validity and enforceability of any remaining provisions."]
[]
["SECTION A. INVESTOR T&Cs"]
["1. DIRECTORY SERVICES"]
["The Site is intended to provide you with certain information from Issuers regarding the self-certification of their Products as labelled covered bonds. The requirements of the Covered Bond Label Convention are intended to increase transparency, improve investor access to information, and improve liquidity in covered bonds, but they are not a substitute in any way for each User's independent investment and credit evaluation."]
["The Product Information on this Site is provided for your convenience only, and does not constitute any form of credit rating, an offer to sell (or the solicitation of an offer to purchase) any Product, nor does it constitute a recommendation, or investment advice (or any other type of advice) upon which reliance should be placed."]
["Users shall exercise independent judgment when viewing the Site and its contents, to make their own investigations and evaluations of the information contained on this Site or accessible through it, and to consult their own attorney, business adviser, tax adviser, and/or any other professional necessary, as to legal, business, tax and investment-related matters concerning the Products and Product Information contained on this Site. No information contained on the Site should be construed as legal, tax, investment, or accounting advice."]
[" Product Information is incorporated into the directory on the Site following the completion of an automated process conducted by the relevant Issuer. The proper conduct of that process and the accuracy and completeness of the Product Information supplied during that process remain at all times the responsibility of the relevant Issuer. While the Product Information contained on the Site is displayed by us in good faith, no representation is made by us as to its completeness or accuracy. PRODUCT INFORMATION IS DISPLAYED ON THE SITE \"AS IS\" AND HAS NOT BEEN INDEPENDENTLY VERIFIED BY US. BY YOUR USE OF THE SITE, YOU AGREE THAT WE HAVE NO LIABILITY WHATSOEVER REGARDING THE ACCURACY OF COMPLETENESS OF THE PRODUCT INFORMATION ON THIS SITE. Inclusion of Product Information in the directory on the Site does not constitute a warranty or representation by us that the Product is a covered bond product or complies with any particular criteria or regulations."]
[" Completion of the relevant self-certification automated process by the Issuer will lead to the grant of the Covered Bond Label. The grant of such label is entirely within the control of the relevant Issuer, and we do not independently verify whether such Issuer complies with the relevant criteria. The existence of a Covered Bond Label does not represent any opinion by us about the creditworthiness of a Product, the value or price of a Product, the appropriateness of a Product's terms, or the Product's future investment performance. Nothing contained on this Site is intended to predict or project future performance."]
[" We make no representation that the Products which are featured on the Site are suitable for you and we disclaim all liability and responsibility arising from any reliance placed on any Product Information or on the Covered Bond Label by any visitor to the Site, or by anyone who may be informed of any of its contents."]
["From time to time we may make changes to the Site that we feel are appropriate (see Section C, para 3 below)."]
["2. USE OF MATERIALS"]
["Subject to any prohibitions or restrictions stated in third party websites accessible via hyperlinks in the Site over which we have no control, you may view the content published on this Site, and you are welcome to print hard copies of, and/or download, material on it for your personal use or internal business purposes (in which case you are required to preserve in your copies any copyright materials displayed in the original materials and otherwise to acknowledge the Site as the source of the material). All downloading of material from the Site must be in accordance with ourAcceptable Use Policy. All other copying is strictly prohibited."]
["The use of material printed or downloaded from our Site must be in accordance with our Acceptable Use Policy."]
["3. LINKS FROM AND TO OUR SITE"]
["Where the Site contains hyperlinks to other websites and resources provided by third parties, these links are provided for your information only. We have no control over the contents of those websites or resources, and accept no responsibility for them or for any loss or damage that may arise from your use of them. Users follow links on this Site to external websites at their sole risk."]
["We accept no liability for and do not endorse any statements, advertisements, information, products or services that are published on or may be accessible through any websites owned or operated by third parties or for any action you may take as a result of using the website."]
["Those third party websites may also be subject to separate legal terms and conditions, and Issuers may be subject to separate regulation and are solely responsible for satisfying such regulatory requirements. We do not represent or warrant that any Issuer you deal with is fully authorised under or compliant with any law or regulation in any jurisdiction."]
["You agree not to link any websites to this Site without our express prior written consent. We reserve the right, at any time and for any reason not prohibited by law, to deny permission to anyone to link a website from or to this Site, as well as the right to remove any link currently appearing on our Site."]
[]
["SECTION B. ISSUER T&Cs"]
["1. DIRECTORY SERVICES AND LABEL"]
["The Issuer is responsible for all Product Information uploaded to and/or validated on the Site by the Issuer or on its behalf, and warrants and represents that all such Product Information is and shall continue to be (and the Issuer shall regularly check the Site in order to ensure that it remains) accurate, complete and up-to-date."]
["The Issuer understands that we do not limit access to the Site based on the nationality of a User. The Issuer shall be solely responsible for compliance with all laws and regulations applicable to the offer and sale of a Product in all jurisdictions in which such Products are offered."]
["The Issuer shall indemnify us against, and hold us harmless from, any losses, liabilities or costs (including reasonable administrative and legal costs) suffered by us (including our officers and employees) or by third parties (including Investors and regulatory authorities), in relation to the Product Information and/or the Issuer's use of, and statements regarding, a Covered Bond Label."]
["We accept no liability in relation to any lack of availability of the Site or any omission of, or any display of incorrect, Product Information on the Site for any reason whatsoever including negligence."]
["The Issuer shall not make any statement that its receipt of a Covered Bond Label constitutes a recommendation by us to buy, sell or hold any Product, or that it reflects our views on the suitability of any Product for a particular Investor."]
["2. PRODUCTS"]
["By uploading and/or validating Product Information on our Site, the Issuer warrants and represents that the Product complies with the relevant criteria established by the Label Convention as detailed at "]
["www.coveredbondlabel.com/pdf/Covered_Bond_Label_Convention_2015.pdf"]
["3. UPLOADING INFORMATION TO OUR SITE"]
["Whenever you upload and/or validate Product Information on the Site, you warrant and represent that any such contribution complies with the content standards set out in our Acceptable Use Policy, and you shall indemnify us against, and hold us harmless from, any losses, liabilities and costs arising in respect of any breach of that warranty."]
["You shall promptly notify us in the event that Product Information published on the Site, any representation made to us in connection with obtaining a Covered Product Label, or any other information communicated to us in connection with the Site, becomes false, inaccurate, incomplete, or misleading."]
["Any information you upload to and/or validate on the Site shall be considered non-confidential and non-proprietary, and we have the right to use, copy, distribute and disclose to third parties such information for any purpose. We also have the right to disclose your identity to any third party who is claiming that any information posted or uploaded by you to the Site constitutes a violation of their intellectual property, privacy or other rights or is otherwise unlawful."]
["We shall not be responsible, or liable to any third party, for the content or accuracy of any Product Information posted by you or any other user of the Site."]
["We have the right to remove any information or posting you make on the Site if, in our opinion, such information does not comply with the content standards set out in our Acceptable Use Policy, or for any other reason."]
["4. LINKING TO OUR SITE"]
["You may link to our home page (www.coveredbondlabel.com), provided you do so in a way that is fair and legal and does not damage our reputation or take advantage of it, but you must not establish a link in such a way as to suggest any form of association, approval or endorsement on our part."]
[" You must not establish a link from any website that is not owned by you."]
["The Site must not be framed on any other website, nor may you create a link to any part of the Site other than the home page. We reserve the right to withdraw linking permission without notice. The website from which you are linking must comply in all respects with the content standards set out in our Acceptable Use Policy."]
["5. SECURITY"]
["Issuers are required to register with us in order to use the Site by completing the followingRegistration Form."]
["Issuers will be provided with a unique user identification code and password (the \"User Details\") in order to access the Site for the sole purpose of uploading and/or validating Product Information on the Site. Such User Details are granted by us for the sole and exclusive use of the Issuer."]
["We reserve the right to alter or cancel User Details and revoke access to the site at any time."]
["If we need to contact you in relation to your use of the Site, we may contact you by email, telephone or post. The most recent details you have given us will be used. You must promptly inform us of any change in your contact details."]
["6. DOWNLOADING OF ISSUER PROFILES FROM OUR SITE"]
["An Issuer may download its own profile from our Site in any of the ways expressly permitted by the Site, but Issuers may not download the profiles of any other Issuers or attempt to download profiles from the Site by any other means."]
[]
["SECTION C. GENERAL T&Cs"]
["1. SITE ACCESS"]
["Access to the Site is permitted on a temporary basis, and we reserve the right to withdraw or amend the service we provide on the Site without notice. We shall not be liable if for any reason the Site is unavailable at any time or for any period of time."]
["From time to time, we may restrict access to the Site (either partially or in its entirety)."]
["If you are provided with a user identification code, password or any other piece of information as part of our security procedures you must treat such information as confidential, and you must not disclose it to any third party. We have the right to disable any user identification code or password, whether chosen by you or allocated by us, at any time, if in our opinion you have failed to comply with any of the provisions of these T&Cs, or for any other reason."]
["When using the Site, you must comply with the provisions of our Acceptable Use Policy. You shall indemnify us against, and hold us harmless from, any losses, liabilities or costs (including reasonable administrative and legal costs) suffered by us (including our officers and employees) or by third parties (including Investors and regulatory authorities) as a result of any breaches of ourAcceptable Use Policy that you commit."]
["You are responsible for making all arrangements necessary for you to have access to the Site. You are also responsible for ensuring that all persons who access the Site through your internet connection are aware of these T&Cs and that they comply with them."]
["2. INTELLECTUAL PROPERTY"]
["All rights in this Site unless otherwise indicated, are owned by us. This Site and all content published on this Site, unless otherwise indicated, are protected by copyright in Belgium and other jurisdictions across the world. All trademarks and devices displayed on this Site, unless otherwise indicated, are owned by us and may be registered in many jurisdictions across the world. Save as provided in these T&Cs, any use or reproduction of these trademarks and/or devices is prohibited."]
["You must not use any part of the materials on the Site for commercial purposes without our consent."]
["3. SITE CHANGES"]
["We aim to update the Site on a regular basis, and may change the content at any time. If the need arises, we reserve the right to suspend access to the Site, or close it indefinitely."]
["4. OUR LIABILITY"]
["The Product Information displayed on the Site is provided by the Issuer, and the granting of any label made available through the website is under the sole control of the Issuer, in each case without any guarantees, conditions, warranties or representations from us as to its accuracy or completeness. To the extent permitted by law, we, and any third parties connected to us, hereby expressly exclude:"]
["· all conditions, warranties and other terms which might otherwise be implied by any applicable law or regulation; and"]
["· any liability for any direct, indirect or consequential loss or damage incurred by any User in connection with the Site or in connection with the use, inability to use or results of the use of the Site, any websites linked to it and any materials posted on it (including, without limitation, the omission of, or the display of incorrect, Product Information on the Site) or in connection with any Product, including loss of: income, revenue, business, profits, contracts, anticipated savings, information, or goodwill, regardless of how any such loss or damage is caused."]
["5. INFORMATION ABOUT YOU AND VISITS TO OUR SITE"]
["We process information about you in accordance with our Privacy Policy. By using the Site, you consent to such processing and you warrant that all information provided by you is accurate."]
["6. VIRUSES, HACKING, OTHER OFFENCES"]
["You must not misuse the Site by knowingly introducing viruses, 'trojan horses', worms, logic bombs or other material which is maliciously or technologically harmful. You must not attempt to gain unauthorised access to the Site, the server on which the Site is stored, or any server, computer or database connected to the Site. You must not attack the Site via a denial-of-service attack or a distributed denial-of-service attack."]
["By breaching this provision, you would commit a criminal offence under the law of 28 November 2000 on computer crime. We shall report any such breach to the relevant law enforcement authorities and we shall co-operate with those authorities by disclosing your identity to them. In the event of such breach, your right to use the Site will cease immediately."]
["We will not be liable for any loss or damage caused by a distributed denial-of-service attack, viruses or other technologically harmful material that may infect your computer equipment, computer programs, information or other proprietary material due to your use of the Site or to your downloading of any information posted on it or on any website linked to it."]
["We do not warrant that this Site or any software or material of whatsoever nature available on or downloaded from it will be free from viruses or defects, compatible with your equipment or fit for any purpose. It is your responsibility to use suitable anti-virus software on any software or other material that you may download from this Site and to ensure the compatibility of such software or material with your equipment and software."]
["We reserve the right to prohibit any activities of any nature or description that, in our sole discretion, might tend to damage or injure our commercial reputation or goodwill or the reputations or goodwill of any of the providers or subscribers to this Site."]
["7. JURISDICTION AND APPLICABLE LAW"]
["The courts of Brussels, Belgium shall have exclusive jurisdiction over any claim arising from, or related to, a visit to the Site or these T&Cs."]
["These T&Cs and any dispute or claim arising out of or in connection with them or their subject matter or formation (including non-contractual disputes or claims) shall be governed by and construed in accordance with the laws of Belgium."]
["8. VARIATIONS"]
["We may revise these T&Cs at any time by amending this page. You are expected to check this page from time to time to take notice of any changes we have made, as they are binding on you. Certain of the provisions contained in these T&Cs may also be superseded by provisions or notices published elsewhere on the Site."]
["9. CONTACTS"]
["Details of how to contact us are available by clicking on Contact Us."]
["We shall inform you if any of our contact details change by posting a notice on the Site."]
[]
["SECTION D. CBFL ACCEPTABLE USE POLICY"]
["This acceptable use policy (the \"Policy\") sets out the terms agreed between a user of the website (\"you\") and the Covered Bond Label Foundation (\"we\" or \"us\") on which you may use the websitewww.coveredbondlabel.com (the \"Site\"). The Policy shall apply to all users of, and visitors to, the Site."]
["Your use of the Site means that you accept, and agree to abide by, all the terms of the Policy, which supplement our Terms of Use."]
["1. PROHIBITED USES"]
["You may use the Site for lawful purposes only. You may not use the Site:"]
["· in any way that breaches any applicable local, national or international law or regulation;"]
["· in any way which breaches or contravenes our content standards (see para 2 below);"]
["· in any way that is unlawful or fraudulent, or has any unlawful or fraudulent purpose or effect;"]
["· to transmit, or procure the sending of, any unsolicited or unauthorised advertising or promotional material or any other form of similar solicitation (spam); or"]
["· to knowingly transmit any information, send or upload any material that contains viruses, Trojan horses, worms, time-bombs, keystroke loggers, spyware, adware or any other harmful programs or similar computer code designed to adversely affect the operation of any computer software or hardware."]
["You also agree:"]
["· not to reproduce, duplicate, copy or re-sell any part of the Site in contravention of the provisions of our Terms of Use; and"]
["· not to access without authority, interfere with, damage or disrupt:"]
["· any part of the Site;"]
["· any equipment or network on which the Site is stored;"]
["· any software used in the provision of the Site; or"]
["· any equipment or network or software owned or used by any third party."]
["2. CONTENT STANDARDS"]
["These content standards apply to any and all information (the \"Information\") which you contribute to the Site."]
["Information must:"]
["·  be accurate; and"]
["· comply with applicable law in Belgium and in any country from which it is posted."]
["Information must not:"]
["· infringe any copyright, database right, trade mark or other proprietary right of any other person;"]
["· be likely to deceive any person; or"]
["· be provided in breach of any legal duty owed to any person, such as a contractual duty or a duty of confidence;"]
["3. SUSPENSION AND TERMINATION"]
["We will determine, at our sole discretion, whether your use of the Site has caused a breach of the Policy. When a breach of the Policy has occurred, we may take such action as we deem reasonable."]
["Failure to comply with the Policy will constitute a material breach of our Terms of Use upon which you are permitted to use the Site, and may result in us taking any of the following actions:"]
["· immediate, temporary or permanent withdrawal of your right to use the Site;"]
["· immediate, temporary or permanent removal of any Information uploaded by you to the Site;"]
["· legal proceedings against you for reimbursement of all costs on an indemnity basis (including, but not limited to, reasonable administrative and legal costs) resulting from the breach;"]
["· disclosure of information to law enforcement authorities as requested by law or as we reasonably feel is necessary; or"]
["· any other action we deem to be appropriate;"]
["4. DOWNLOADING AND USE OF INFORMATION FROM OUR SITE"]
[" You may download information from our Site in any of the ways expressly permitted by the Site. Where indicated by the Site, you shall supply all the details requested and accept all the applicable terms and conditions before attempting to download any information from the Site. You shall not attempt to download profiles from the Site by any other means."]
["You may use information that has been downloaded from our Site in accordance with our permitted procedures and/or hard copies of information printed from our Site for your personal use or internal business purposes only (in which case you are required to preserve in your copies any copyright materials displayed in the original materials and otherwise to acknowledge the Site as the source of the material). You may not distribute or show any materials downloaded or printed from our Site to any third parties or quote or refer to any such materials in communications with third parties without obtaining our prior written permission. Any such permission would only be granted by us on terms that the third party in question, prior to viewing any material from our Site, accepts and agrees to comply with these T&Cs as if the third party were a User of the Site."]
["Regardless of any permission that may be granted by us for you to distribute or show materials downloaded or printed from our Site to third parties, you must not use or export the information or materials available on or through this Site in violation of laws in your, or any other applicable, jurisdiction. It remains your responsibility at all times to ensure that such laws are not violated."]
["5. CHANGES TO THE POLICY"]
["We may revise the Policy at any time by amending this page. You are expected to check this page from time to time to take notice of any changes we make, as they are legally binding on you. Some of the provisions contained in the Policy may also be superseded by provisions or notices published elsewhere on the Site."]
[]
["SECTION E. CBFL PRIVACY POLICY"]
["The Covered Bond Label Foundation (\"we\" or \"us\") is committed to protecting and respecting the privacy of our users."]
["This policy (together with our Terms of Use and any other documents referred to on it) sets out the basis on which any personal information we collect from, or that is provided to us by, a user (including from any individual who represents, and/or acts on behalf of, a user) (\"you\") will be processed by us or by third parties. Please read the following carefully to understand our views and practices regarding your personal information and how we will treat it."]
["For the purpose of the Law of 8 December 1992 on the protection of privacy in relation to processing of personal information (loi relative à la protection de la vie privée à l'égard des traitements de données à caractère personnel / wet tot bescherming van de persoonlijke levensfeer ten opzichte van de verwerking van persoonsgegevens) (the \"Belgian DPL\"), we (the Covered Bond Label Foundation) are the data controller."]
["1. INFORMATION COLLECTION AND PROCESSING"]
["We may collect and process the following information about you:"]
["· information that you provide by completing any form on our website (www.coveredbondlabel.com) (the \"Site\"). This includes information provided at the time of registering to use the Site, subscribing to our service, posting material or requesting further services;"]
["· if you contact us, we may keep a record of that correspondence; and"]
["· details of your visits to the Site and the resources that you access."]
["This information may include personal information (such as your name or title) and we will only process such personal information for the purposes set out in paragraph 2 below in accordance with the Belgian DPL"]
["2. INFORMATION USE"]
["We may collect and process your personal information for the following purposes:"]
["· to ensure that content from the Site is presented in the most effective manner for your computer;"]
["· to provide you with information, products or services that you request from us or which we feel may interest you; and"]
["· to notify you about changes to our service."]
["If you do not want us to use your information in this way, or to pass your details on to third parties for marketing purposes, you can refuse consent to such processing by ticking the relevant box situated on the form on which we collect your information."]
["3. TRANSFER AND STORAGE OF PERSONAL INFORMATION"]
["You agree that your personal information may be communicated to third parties:"]
["· if we are under a duty to disclose or share your personal information in order to comply with any legal obligation, or in order to enforce or apply our Terms of Use and other agreements;"]
["· in the case of any legitimate interest; and"]
["· for direct marketing purposes (unless you object to such processing in accordance with paragraph 2 above)."]
["· By submitting your personal information, you also agree that such information may be transferred to, and stored at, a destination outside the European Economic Area (\"EEA\"), whether or not an adequate level of protection in ensured for personal information in the country of reception."]
["· Your personal information may also be processed by staff operating outside the EEA who work for us or for one of our processors for the same purposes as listed in paragraph 2 above. Such staff may be engaged in, among other things, the provision of support services."]
["4. SECURITY"]
["We will take all steps reasonably necessary to ensure that your information is treated securely and in accordance with this privacy policy, and to prevent personal information being accessible to and processed by unauthorised parties, or being accidentally changed or deleted. There are internal security measures in place to protect the premises, servers, network, data transfers, and the information itself."]
["You acknowledge however that the transmission of information via the internet is not completely secure. While we will use reasonable endeavours to protect your personal information, we cannot fully guarantee the security of your information transmitted to the Site."]
["Where we have given you a password which enables you to access certain parts of the Site, you are responsible for keeping this password confidential. We ask you not to share your password with anyone."]
["5. YOUR RIGHTS"]
["The Belgian DPL gives you the right to access or, where incorrect, amend or delete (at your request and free of charge) personal information pertaining to you. You can exercise these rights at any time by contacting us by email by clicking on Contact Us or by letter addressed to Covered Bond Label Foundation Rue de la Science 14 - 1040 Brussels - Belgium."]
["You also have the right to ask us not to process your personal information for marketing purposes. You can exercise your right to prevent such processing by checking certain boxes on the forms we use to collect your information or by contacting us by email or by letter in accordance with the above."]
["6. CHANGES TO OUR PRIVACY POLICY"]
["Any changes we may make to our privacy policy in the future will be posted on this page."]
["7. CONTACT"]
["If you have any questions about this policy, the collection and use of your personal information or other privacy-specific concerns please contact us by clicking on Contact Us ."]

{"sheet":"Introduction","index":1,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,3,5,7],[41,3,41,7],[39,3,39,7],[37,3,37,7],[35,3,35,7],[23,3,23,7],[25,3,25,7],[27,3,27,7],[29,3,29,7],[31,3,31,7],[33,3,33,7]]}
[]
[]
[]
[]
[{"$nulls":5},"Harmonised Transparency Template"]
[null,null,null,"2025  Version"]
[{"$nulls":5},"Germany"]
[{"$nulls":5},"Berlin Hyp AG"]
[{"$nulls":5},"Reporting Date: 29/04/2025"]
[{"$nulls":5},"Cut-off Date: 31/03/2025"]
{"$rows_empty":11}
[{"$nulls":5},"Index"]
[]
[null,null,null,"Worksheet A: HTT General"]
[]
[null,null,null,"Worksheet B1: HTT Mortgage Assets"]
[]
[null,null,null,"Worksheet B2: HTT Public Sector Assets"]
[]
[null,null,null,"Worksheet B3: HTT Shipping Assets"]
[]
[null,null,null,"Worksheet C: HTT Harmonised Glossary"]
[]
[null,null,null,"Covered Bond Label Disclaimer"]
[]
[null,null,null,"Worksheet D & Onwards (If Any): National Transparency Template"]
[]
[null,null,null,"Worksheet E: Optional ECB-ECAIs data"]
[]
[null,null,null,"Worksheet F1: Sustainable M data"]
[]
[null,null,null,"Worksheet G1. Crisis M Payment Holidays"]

{"sheet":"Completion Instructions","index":2,"n_rows":91,"n_cols":7,"rows_kept":91,"cut":false,"hidden":false,"merged":[[25,2,26,7],[27,2,28,7],[29,2,30,7],[82,2,82,8],[81,2,81,8],[75,2,75,8]]}
[]
[]
[]
[]
[{"$nulls":5},"Completion Instructions"]
[]
[{"$nulls":5},"Please delete this tab once you have completed this file"]
[]
[null,null,"1. Every pool has one separate HTT. Issuers with more than one cover pool have to present as many separate HTTs as the number of pools."]
[null,null,"2.  All cells that include “[For completion]” and “[Mark as ND if not relevant]” needs to be completed"]
[null,null,"3. The  \"[For completion]\" or \"[Mark as ND if not relevant]\" cells could be filled with:"]
[null,null,null,"3.A Numbers: Please insert the appropriate data"]
[null,null,null,"3.B Letters: Please insert either No Data (ND)"]
[null,null,null,"(i)   ND1: Please complete the cell with ND1 when the information is not applicable for the jurisdiction "]
[null,null,null,"(ii)  ND2: Please complete the cell with ND2 when the information is not relevant for the issuer and/or CB programme at the present time"]
[null,null,null,"(iii) ND3: Please complete the cell with ND3 when the information is not available at the present time"]
[null,null,null,"(iv) ND4: Please complete the cell with ND4 when the information is confidential"]
[null,null,"4. Please note that the percentage cells will be automatically completed by the spreadsheet."]
[null,null,"5. The wording of the tabs referring to the HTT (the ones with an orange tab colour) are not to be changed."]
[null,null,"6. Should you wish to insert your National Transparency Template worksheet(s) in the HTT, please follow our instructions in the box below. "]
[null,null,null,"Please do not forget to change the name of the worksheet in order to be consistent with the numbering of the existing ones (starting with D.)."]
[null,null,null,"Please update the Introduction Tab accordingly."]
[null,null,"7. Please delete tab D (Insert National Transparency Template) and the example tabs if unused."]
[null,null,null,"Please update the introduction Tab accordingly."]
[null,null,"8. Should you make references to external documents or cells in this document, please insert the hyperlink."]
[null,null,"9. Since HTT 2018 various fields as well as the amount of rows and columns are blocked in order to guarantee the uniformity of the HTT architecture which enables to run automated reporting programs. In order to guarantee this uniformity the Secretariat will not provide 'unprotected' HTTs to the issuers"]
[]
[null,null,"10. Since the loan bucket size of the loan size information (Tab. B1 HTT mortgage Assets - section 7.10 and 7.15, Tab. B2 HTT Public Sector Assets - section 8.2, Tab B3. HTT Shipping Assets - section 9.8) is decided at national level, please follow the agreed dispositions which can be found in the HTT Completion Guideline"]
[]
[null,null,"11. Since the regional breakdown denomination (Tab. B1 HTT Mortgage Assets - section 7.5., Tab B2 HTT Public Sector Assets - section 8.5) is decided at national level, please follow the agreed dispositions which can be found in the HTT Completion Guideline"]
[]
[null,null,"12. For your information Legal Entity Identifier (LEI) for counterparty information may be found in http://www.lei-lookup.com/#!search"]
[null,null,"13. For any further questions on how to complete the HTT please consult in the following order:"]
[null,null,null,"(i) the HTT Completion Guideline"]
[null,null,null,"(ii)  the relevant National Coordinator"]
[null,null,null,"(iii) the Covered Bond Label Secretariat"]
{"$rows_empty":10}
[null,null,"How to import an excel worksheet"]
[]
[null,null,"1. Click on the tab of the worksheet you want to import",null,null,null,"3. Select the excel file where you want to transfer your worksheet from the dropdown menu"]
[null,null,"2. Select \"Move or Copy\"",null,null,null,"4. In the box Before Sheet, please select \"(move to end)\""]
[null,null,3,null,null,null,"5. Do not forget to tick the \"Create a copy\" box and press ok"]
{"$rows_empty":23}
[null,null,"Updates for HTT 2025"]
[null,null,"Here below the list of updates of HTT 2025 with respect to HTT 2024 agreed during meeting of the Label Committee of 10 September 2024. "]
[]
[null,null,"0. All worksheets: Update the year of the HTT template next to the title of each"]
[null,null,"1. Worksheet \"FAQ\": Addition of a new no data specification, ND4, indicating no data when the information is confidential"]
[null,null,"2. Worksheet \"FAQ\": Addition of explanation on the FIGI number"]
[null,null,"3. Worksheet “A. HTT General”: Section 1. Basic Fact: New row 19 containing the Cover Pool’s FIGI Identifier (non-mandatory) "]
[null,null,"4. Worksheet “A. HTT General”: Section 2 Regulatory Summary: Correction of jursdiction with jurisdiction"]
[null,null,"5. Worksheet “A. HTT General”: Section 3.6 addition of NZD among the possible currencies"]
[null,null,"6. Worksheet “A. HTT General”: Section 3.7 addition of NZD among the possible currencies"]
[null,null,"8. Worksheet “A. HTT General”: Section 3.10 addition of the United Kingdom among the countries for the Substitute Assets following Brexit, Row 198 "]
[null,null,"7. Worksheet “A. HTT General”: Link C229 to C30 for consistency "]
[null,null,"9. Worksheet “B1. HTT Mortgage Assets”: Section 7.5 Unify the percentages and highlight the sub-total for the main Country of origin"]
[null,null,"10. Worksheet “B1. HTT Mortgage Assets”: Section 7.4 Unify the percentages and highlight the EU, EEA and Other sub-totals"]
[null,null,"11. Worksheets “B1. HTT Mortgage Assets\", \"F1. Sustainable M data\": Sections 20 and 29 \"CO2 Emission\" Take “no data” line out and insert on the RHS a new column indicating the % of dwellings with no CO2 data"]
[null,null,"12. Worksheet “B3. HTT Shipping Assets\", \"F1. Sustainable M data\": Sections 6 and 8 unify the seasoning brackets "]
[null,null,"13. Worksheet \"F1. Sustainable M data\": Section 9 addition of Defaulted Loans pursuant to art. 178 CRR to the NPLs section"]

{"sheet":"FAQ","index":3,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,2],[34,0,34,2]]}
["Frequently Asked Questions (FAQ)"]
["Please delete this tab once you have completed this file"]
[]
[null,null,"Harmonised Transparency Template - Frequently Asked Questions"]
["General Questions"]
["Question 1: What is the structure of the Harmonised Transparency Template (HTT)?"]
[null,"Response 1","The HTT contains 5 main worksheets (A, B1, B2, B3 and C). The first worksheet (A) includes the HTT general information. The second worksheet (B1) presents the mortgage information. The third worksheet (B2) contains the public sector information. The fourth worksheet (B3) contains shipping information.The fifth worksheet (C) represents the HTT glossary, which has a harmonised section across jurisdictionsat the top, but also a section for national specificities below. Any additional tabs (D, E, etc.), will contain the National Transparency Template (NTT) information where relevant. "]
["Question 2: Is the HTT going to replace the National Transparency Template (NTT)?"]
[null,"Response 2","The HTT is compulsory in order to be considered Covered Bond Label compliant. The NTT can be added in order to provide further information at national discretion. "]
["Question 3: What is the reporting frequency of the HTT?"]
[null,"Response 3","The reporting of the HTT is the same as the reporting of the National Transparency Template (NTT), i.e. at least quarterly. "]
["Question 4: Where should the HTT be posted?"]
[null,"Response 4","The HTT should be posted in the same location as the National Transparency Template (NTT) is currently posted, i.e. on the issuer's website. There is no common platform for the HTT."]
["Question 5: In what format the HTT should be disclosed?"]
[null,"Response 5","The HTT should be disclosed in Excel format in so far as it is possible, as already suggested by the Label Advisory Council and investors. Where issuers are currently providing the Template in both Excel and PDF formats, they are encouraged to continue to do so."]
["Question 6: Where can I find the reporting date?"]
[null,"Response 6","The reporting date can be found in the Introduction Tab and in the \"Basic Facts\" section of worksheet A."]
["Question 7: What happens when I cannot complete a section of the HTT?"]
[null,"Response 7","When the information is either (i) not applicable for the jurisdiction, (ii) not relevant for the issuer and/or CB programme at the present time; (iii) not available at the present time; or (iv) confidential. Issuers are kindly requested to include ND1, ND2, ND3 or ND4 respectively. "]
["Specific Questions"]
["Question 8: Does the Harmonised Transparency Template only contain disaggregated information for mortgages and public sector?"]
[null,"Response 8","Indeed, the HTT only provides disaggregated information for mortgage and public sector assets which represent 99.6% of total outstanding. Information in more detail on other collateral types can always be included in worksheet E, which may contains the National Transparency Template (NTT)."]
["Question 9: How should the \"liquid assets\" be calculated in the section 3 \"General Cover Pool / Covered Bond Information\" of the HTT?"]
[null,"Response 9","Liquid assets are defined as central bank eligible assets, substitute and other marketable assets. This total is calculated over both outstanding covered bonds and outstanding cover assets. "]
["Question 10: How should the \"expected\" and \"contractual\" columns of the \"Cover pool amortisation profile\" be understood?"]
[null,"Response 10","Contractual maturities assume no prepayment scenario unlike expected maturities.  Jurisdictions/issuers publishing the two should disclosed their prepayment assumptions for the latter.  "]
["Question 11: How should the hedging columns included in section 3 \"General Cover Pool / Covered Bond Information\" of the HTT be understood?"]
[null,"Response 11","The currency breakdown before/after hedging aims to assess the potential currency mismatch on the asset and liability sides. This is supplemented by explanations on the issuer's hedging strategy in the Harmonised Glossary.  "]
["Question 12: How should the cover assets and covered bonds distribution by currency be populated in section 3.6 and 3.7 in Tab A. HTT General?"]
[null,"Response 12","In the columns titled \"Nominal [before hedging]\" and \"Nominal [after hedging]\" if there is no hedging activity also the amounts for the single currencies should be the same in the two columns. Should there be hedging activity then the currency into which the outstanding has been swapped will receive the respective amount. For example, if all outstanding have been swapped into one currency, only this currency will see a positive amount in the after hedging section. The sum of the columns must match the figures reported under \"Total Cover Assets\", respectively \"Outstanding Covered Bonds\" in Section 3.1 of Tab A. HTT General."]
["Question 13: How should the covered bonds distribution by interest rate be populated in section 3.8 in Tab A. HTT General?"]
[null,"Response 13","In the columns titled \"Nominal [after hedging]\", all amounts must be inserted in the line for the interest rate type they have been swapped into. For example, if all outstanding amounts have been swapped into floating rate, only this line should be filled. Total amounts should show the same figures both before and after hedging. "]
["Question 14: How should arrears be populated in Tab E. Optional ECB-ECAIs data?"]
[null,"Response 14","Performing loans should be excluded from the \"1-<30 days\" bucket. If a loan is in arrears, please report the entire principal amount for the loan, not just the instalment that is in arrears. "]
["Question 15: What is the Cover Pools' FIGI identifier and where can I find it?"]
[null,"Response 15","FIGI is a 12-character alphanumeric ID used to differentiate and map information associated to cover pools. Each pool has a unique FIGI ID which cannot be re-used. You can search for existing FIGI ID's for cover pools on the Bloomberg Terminal or on the openfigi.com webpage. Bloomberg is a certified provider and will facilitate to request a FIGI ID for new pools. Requests can be send with relevant documentation via email to emeacapmkts@bloomberg.net. We would like to underline that the inclusion of the FIGI number in your HTT is on a voluntary basis."]

{"sheet":"A. HTT General","index":4,"n_rows":365,"n_cols":12,"rows_kept":365,"cut":false,"hidden":false,"merged":[]}
["A. Harmonised Transparency Template - General Information ",{"$nulls":4},"HTT 2025"]
[]
[null,"Reporting in Domestic Currency","EUR"]
[]
[null,"CONTENT OF TAB A"]
[null,"1. Basic Facts"]
[null,"2. Regulatory Summary"]
[null,"3. General Cover Pool / Covered Bond Information",null,null,null,"`"]
[null,"4. Compliance Art 14 CBD Check Table"]
[null,"5. References to Capital Requirements Regulation (CRR) 129(1)"]
[null,"6. Other relevant information"]
[]
["Field Number","1. Basic Facts"]
["G.1.1.1","Country","Germany"]
["G.1.1.2","Issuer Name","Berlin Hyp AG"]
["G.1.1.3","Labelled Cover Pool Name","Berlin Hyp AG Mortgage Pfandbrief"]
["G.1.1.4","Link to Issuer's Website","Https://www.coveredbondlabel.com/issuer/139-berlin-hyp-ag"]
["G.1.1.5","Cut-off date","31/03/2025"]
["G.1.1.6","Cover Pool's FIGI Identifier (non-mandatory)","BBG008P8WWY4"]
["OG.1.1.2","Optional information e.g. Contact names"]
["OG.1.1.3","Optional information e.g. Parent name"]
["OG.1.1.4"]
["OG.1.1.5"]
["OG.1.1.6"]
["OG.1.1.7"]
[null,"2. Regulatory Summary"]
["G.2.1.1","Basel Compliance, subject to national jurisdiction (Y/N)","Y"]
["G.2.1.2","CBD Compliance"]
["G.2.1.3","CRR Compliance (Y/N)","Y"]
["OG.2.1.1","LCR status","[Insert link to the issuer's profile on the Covered Bond Label website]"]
["OG.2.1.2"]
["OG.2.1.3"]
["OG.2.1.4"]
["OG.2.1.5"]
["OG.2.1.6"]
[null,"3. General Cover Pool / Covered Bond Information"]
[null,"1.General Information","Nominal (mn)"]
["G.3.1.1","Total Cover Assets",20003.648150969999]
["G.3.1.2","Outstanding Covered Bonds",19064.197084089999]
["OG.3.1.1","Cover Pool Size [NPV] (mn)",20268.230272950001]
["OG.3.1.2","Outstanding Covered Bonds [NPV] (mn)",18837.982951549999]
["OG.3.1.3"]
["OG.3.1.4"]
[null,"2. Over-collateralisation (OC) ","Statutory","Voluntary",null,"Contractual","Purpose"]
["G.3.2.1","OC (%)",3.9453759104636478E-2,9.8245326973307647E-3,null,null,"ND1 "]
[]
["G.3.2.3","Total OC (absolute value in mn)",939.45106687999998]
["OG.3.2.1"]
["OG.3.2.2","Optional information e.g. Asset Coverage Test (ACT)"]
["OG.3.2.3","Optional information e.g. OC (NPV basis)"]
["OG.3.2.4"]
[null,"3. Cover Pool Composition","Nominal (mn)",null,null,"% Cover Pool"]
["G.3.3.1","Mortgages",18583.348151074999,null,null,{"$f":"IF($C$58=0,\"\",IF(C53=\"[for completion]\",\"\",C53/$C$58))","v":0.92899795131001284}]
["G.3.3.2","Public Sector ","[For completion]",null,null,{"$f":"IF($C$58=0,\"\",IF(C54=\"[for completion]\",\"\",C54/$C$58))","v":""}]
["G.3.3.3","Shipping","[For completion]",null,null,{"$f":"IF($C$58=0,\"\",IF(C55=\"[for completion]\",\"\",C55/$C$58))","v":""}]
["G.3.3.4","Substitute Assets",1420.3,null,null,{"$f":"IF($C$58=0,\"\",IF(C56=\"[for completion]\",\"\",C56/$C$58))","v":7.1002048689987232E-2}]
["G.3.3.5","Other","[For completion]",null,null,{"$f":"IF($C$58=0,\"\",IF(C57=\"[for completion]\",\"\",C57/$C$58))","v":""}]
["G.3.3.6","Total",{"$f":"SUM(C53:C57)","v":20003.648151074998},null,null,{"$f":"SUM(F53:F57)","v":1}]
["OG.3.3.1","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$58=0,\"\",IF(C59=\"[for completion]\",\"\",C59/$C$58))","v":0}]
["OG.3.3.2","o/w [If relevant, please specify]",null,null,null,0]
["OG.3.3.3","o/w [If relevant, please specify]",null,null,null,0]
["OG.3.3.4","o/w [If relevant, please specify]",null,null,null,0]
["OG.3.3.5","o/w [If relevant, please specify]",null,null,null,0]
["OG.3.3.6","o/w [If relevant, please specify]",null,null,null,0]
[null,"4. Cover Pool Amortisation Profile","Contractual ","Expected Upon Prepayments ",null,"% Total Contractual","% Total Expected Upon Prepayments"]
["G.3.4.1","Weighted Average Life (in years)",3.6,"ND1"]
[]
[null,"Residual Life (mn)"]
[null,"By buckets:"]
["G.3.4.2","0 - 1 Y",{"$f":"SUM(C79:C80)","v":3361.9141140400002},"ND1",null,{"$f":"IF($C$77=0,\"\",IF(C70=\"[for completion]\",\"\",C70/$C$77))","v":0.16806504936751604},{"$f":"IF($D$77=0,\"\",IF(D70=\"[Mark as ND1 if not relevant]\",\"\",D70/$D$77))","v":""}]
["G.3.4.3","1 - 2 Y",{"$f":"SUM(C81:C82)","v":3047.1282841299999},"ND1",null,0.15232862831408123,""]
["G.3.4.4","2 - 3 Y",3170.99110913,"ND1",null,0.15852064009436115,""]
["G.3.4.5","3 - 4 Y",2760.0270647100001,"ND1",null,0.13797618533709141,""]
["G.3.4.6","4 - 5 Y",2785.86007655,"ND1",null,0.13926760036523556,""]
["G.3.4.7","5 - 10 Y",4491.5940068300006,"ND1",null,0.22453874277876379,""]
["G.3.4.8","10+ Y",386.13349568000001,"ND1",null,1.9303153742950916E-2,""]
["G.3.4.9","Total",{"$f":"SUM(C70:C76)","v":20003.64815107},{"$f":"SUM(D70:D76)","v":0},null,{"$f":"SUM(F70:F76)","v":1},{"$f":"SUM(G70:G76)","v":0}]
["OG.3.4.1","o/w 0-1 day",null,null,null,{"$f":"IF($C$77=0,\"\",IF(C78=\"[for completion]\",\"\",C78/$C$77))","v":0},{"$f":"IF($D$77=0,\"\",IF(D78=\"[for completion]\",\"\",D78/$D$77))","v":""}]
["OG.3.4.2","o/w 0-0.5y",1663.5616948700001,"ND1",null,{"$f":"IF($C$77=0,\"\",IF(C79=\"[for completion]\",\"\",C79/$C$77))","v":8.3162915199596524E-2},{"$f":"IF($D$77=0,\"\",IF(D79=\"[for completion]\",\"\",D79/$D$77))","v":""}]
["OG.3.4.3","o/w 0.5-1 y",1698.3524191700001,"ND1",null,{"$f":"IF($C$77=0,\"\",IF(C80=\"[for completion]\",\"\",C80/$C$77))","v":8.4902134167919502E-2},{"$f":"IF($D$77=0,\"\",IF(D82=\"[for completion]\",\"\",D82/$D$77))","v":""}]
["OG.3.4.4","o/w 1-1.5y",1292.2123119600001,"ND1",null,{"$f":"IF($C$77=0,\"\",IF(C81=\"[for completion]\",\"\",C81/$C$77))","v":6.4598832283044305E-2},{"$f":"IF($D$77=0,\"\",IF(D81=\"[for completion]\",\"\",D81/$D$77))","v":""}]
["OG.3.4.5","o/w 1.5-2 y",1754.91597217,"ND1",null,{"$f":"IF($C$77=0,\"\",IF(C82=\"[for completion]\",\"\",C82/$C$77))","v":8.7729796031036922E-2},{"$f":"IF($D$77=0,\"\",IF(#REF!=\"[for completion]\",\"\",#REF!/$D$77))","v":""}]
["OG.3.4.6"]
["OG.3.4.7"]
["OG.3.4.8"]
["OG.3.4.9",{"$nulls":4},{"$f":"IF($C$77=0,\"\",IF(C86=\"[for completion]\",\"\",C86/$C$77))","v":0},{"$f":"IF($D$77=0,\"\",IF(D86=\"[for completion]\",\"\",D86/$D$77))","v":""}]
["OG.3.4.10",{"$nulls":4},{"$f":"IF($C$77=0,\"\",IF(C87=\"[for completion]\",\"\",C87/$C$77))","v":0},{"$f":"IF($D$77=0,\"\",IF(D87=\"[for completion]\",\"\",D87/$D$77))","v":""}]
[null,"5. Maturity of Covered Bonds","Initial Maturity  ","Extended Maturity ",null,"% Total Initial Maturity ","% Total Extended Maturity"]
["G.3.5.1","Weighted Average life (in years)",4.8,"ND1"]
[]
[null,"Maturity (mn)"]
["G.3.5.2","By buckets:"]
["G.3.5.3","0 - 1 Y",{"$f":"SUM(C102:C103)","v":2959.5},"ND1",null,{"$f":"IF($C$100=0,\"\",IF(C93=\"[for completion]\",\"\",IF(C93=\"\",\"\",C93/$C$100)))","v":0.15523863852986866},{"$f":"IF($D$100=0,\"\",IF(D93=\"[Mark as ND1 if not relevant]\",\"\",IF(D93=\"\",\"\",D93/$D$100)))","v":""}]
["G.3.5.4","1 - 2 Y",{"$f":"SUM(C104:C105)","v":2126.841569615},"ND1",null,0.11156208468854924,""]
["G.3.5.5","2 - 3 Y",3295,"ND1",null,0.17283707178777402,""]
["G.3.5.6","3 - 4 Y",2612,"ND1",null,0.13701075311370736,""]
["G.3.5.7","4 - 5 Y",1515,"ND1",null,7.9468334979811123E-2,""]
["G.3.5.8","5 - 10 Y",5623.5,"ND1",null,0.29497701766268503,""]
["G.3.5.9","10+ Y",932.35551448000001,"ND1",null,4.8906099237604472E-2,""]
["G.3.5.10","Total",{"$f":"SUM(C93:C99)","v":19064.197084095002},{"$f":"SUM(D93:D99)","v":0},null,{"$f":"SUM(F93:F99)","v":0.99999999999999989},{"$f":"SUM(G93:G99)","v":0}]
["OG.3.5.1","o/w 0-1 day",null,null,null,{"$f":"IF($C$100=0,\"\",IF(C101=\"[for completion]\",\"\",C101/$C$100))","v":0},{"$f":"IF($D$100=0,\"\",IF(D101=\"[for completion]\",\"\",D101/$D$100))","v":""}]
["OG.3.5.2","o/w 0-0.5y",1342,"ND1",null,{"$f":"IF($C$100=0,\"\",IF(C102=\"[for completion]\",\"\",C102/$C$100))","v":7.0393733031621469E-2},{"$f":"IF($D$100=0,\"\",IF(D102=\"[for completion]\",\"\",D102/$D$100))","v":""}]
["OG.3.5.3","o/w 0.5-1 y",1617.5,"ND1",null,{"$f":"IF($C$100=0,\"\",IF(C103=\"[for completion]\",\"\",C103/$C$100))","v":8.4844905498247192E-2},{"$f":"IF($D$100=0,\"\",IF(D103=\"[for completion]\",\"\",D103/$D$100))","v":""}]
["OG.3.5.4","o/w 1-1.5y",1584.841569615,"ND1",null,{"$f":"IF($C$100=0,\"\",IF(C104=\"[for completion]\",\"\",C104/$C$100))","v":8.3131828873989747E-2},{"$f":"IF($D$100=0,\"\",IF(D104=\"[for completion]\",\"\",D104/$D$100))","v":""}]
["OG.3.5.5","o/w 1.5-2 y",542,"ND1",null,{"$f":"IF($C$100=0,\"\",IF(C105=\"[for completion]\",\"\",C105/$C$100))","v":2.8430255814559491E-2},{"$f":"IF($D$100=0,\"\",IF(D105=\"[for completion]\",\"\",D105/$D$100))","v":""}]
["OG.3.5.6"]
["OG.3.5.7"]
["OG.3.5.8"]
["OG.3.5.9"]
["OG.3.5.10"]
[null,"6. Cover Assets - Currency","Nominal [before hedging] (mn)","Nominal [after hedging] (mn)",null,"% Total [before]","% Total [after]"]
["G.3.6.1","EUR",20003.64815107,20003.64815107,null,{"$f":"IF($C$131=0,\"\",IF(C112=\"[for completion]\",\"\",IF(C112=\"\",\"\",C112/$C$131)))","v":1},{"$f":"IF($D$131=0,\"\",IF(D112=\"[for completion]\",\"\",IF(D112=\"\",\"\",D112/$D$131)))","v":1},{"$nulls":4},"curre"]
["G.3.6.2","AUD","[For completion]","[For completion]",null,"","",{"$nulls":4},"AUD"]
["G.3.6.3","BRL","[For completion]","[For completion]",null,"","",{"$nulls":4},"BRL"]
["G.3.6.4","CAD","[For completion]","[For completion]",null,"","",{"$nulls":4},"CAD"]
["G.3.6.5","CHF","[For completion]","[For completion]",null,"","",{"$nulls":4},"CHF"]
["G.3.6.6","CZK","[For completion]","[For completion]",null,"","",{"$nulls":4},"CZK"]
["G.3.6.7","DKK","[For completion]","[For completion]",null,"","",{"$nulls":4},"DKK"]
["G.3.6.8","GBP","[For completion]","[For completion]",null,"","",{"$nulls":4},"GBP"]
["G.3.6.9","HKD","[For completion]","[For completion]",null,"","",{"$nulls":4},"HKD"]
["G.3.6.10","ISK","[For completion]","[For completion]",null,"",""]
["G.3.6.11","JPY","[For completion]","[For completion]",null,"","",{"$nulls":4},"KRW"]
["G.3.6.12","KRW","[For completion]","[For completion]",null,"","",{"$nulls":4},"NOK"]
["G.3.6.13","NOK","[For completion]","[For completion]",null,"","",{"$nulls":4},"PLN"]
["G.3.6.14","NZD","[For completion]","[For completion]",null,"","",{"$nulls":4},"SEK"]
["G.3.6.15","PLN","[For completion]","[For completion]",null,"","",{"$nulls":4},"SGD"]
["G.3.6.16","SEK","[For completion]","[For completion]",null,"","",{"$nulls":4},"USD"]
["G.3.6.17","SGD","[For completion]","[For completion]",null,"",""]
["G.3.6.18","USD","[For completion]","[For completion]",null,"",""]
["G.3.6.19","Other","[For completion]","[For completion]",null,"",""]
["OG.3.6.1","Total",{"$f":"SUM(C112:C130)","v":20003.64815107},{"$f":"SUM(D112:D130)","v":20003.64815107},null,{"$f":"SUM(F112:F130)","v":1},{"$f":"SUM(G112:G130)","v":1}]
["OG.3.6.2","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$131=0,\"\",IF(C132=\"[for completion]\",\"\",IF(C132=\"\",\"\",C132/$C$131)))","v":""},{"$f":"IF($D$131=0,\"\",IF(D132=\"[for completion]\",\"\",IF(D132=\"\",\"\",D132/$D$131)))","v":""}]
["OG.3.6.3","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$131=0,\"\",IF(C133=\"[for completion]\",\"\",IF(C133=\"\",\"\",C133/$C$131)))","v":""},{"$f":"IF($D$131=0,\"\",IF(D133=\"[for completion]\",\"\",IF(D133=\"\",\"\",D133/$D$131)))","v":""}]
["OG.3.6.4","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$131=0,\"\",IF(C134=\"[for completion]\",\"\",IF(C134=\"\",\"\",C134/$C$131)))","v":""},{"$f":"IF($D$131=0,\"\",IF(D134=\"[for completion]\",\"\",IF(D134=\"\",\"\",D134/$D$131)))","v":""}]
["OG.3.6.5","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$131=0,\"\",IF(C135=\"[for completion]\",\"\",IF(C135=\"\",\"\",C135/$C$131)))","v":""},{"$f":"IF($D$131=0,\"\",IF(D135=\"[for completion]\",\"\",IF(D135=\"\",\"\",D135/$D$131)))","v":""}]
["OG.3.6.6","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$131=0,\"\",IF(C136=\"[for completion]\",\"\",IF(C136=\"\",\"\",C136/$C$131)))","v":""},{"$f":"IF($D$131=0,\"\",IF(D136=\"[for completion]\",\"\",IF(D136=\"\",\"\",D136/$D$131)))","v":""}]
[null,"7. Covered Bonds - Currency ","Nominal [before hedging] (mn)","Nominal [after hedging] (mn)",null,"% Total [before]","% Total [after]"]
["G.3.7.1","EUR",18854.355514480001,18854.355514480001,null,{"$f":"IF($C$157=0,\"\",IF(C138=\"[for completion]\",\"\",IF(C138=\"\",\"\",C138/$C$157)))","v":0.98899289759283548},{"$f":"IF($D$157=0,\"\",IF(D138=\"[for completion]\",\"\",IF(D138=\"\",\"\",D138/$D$157)))","v":0.98899289759283548}]
["G.3.7.2","AUD","[For completion]","[For completion]",null,"",""]
["G.3.7.3","BRL","[For completion]","[For completion]",null,"",""]
["G.3.7.4","CAD","[For completion]","[For completion]",null,"",""]
["G.3.7.5","CHF",209.841569615,209.841569615,null,1.1007102407164472E-2,1.1007102407164472E-2]
["G.3.7.6","CZK","[For completion]","[For completion]",null,"",""]
["G.3.7.7","DKK","[For completion]","[For completion]",null,"",""]
["G.3.7.8","GBP","[For completion]","[For completion]",null,"",""]
["G.3.7.9","HKD","[For completion]","[For completion]",null,"",""]
["G.3.7.10","ISK","[For completion]","[For completion]",null,"",""]
["G.3.7.11","JPY","[For completion]","[For completion]",null,"",""]
["G.3.7.12","KRW","[For completion]","[For completion]",null,"",""]
["G.3.7.13","NOK","[For completion]","[For completion]",null,"",""]
["G.3.7.14","NZD","[For completion]","[For completion]",null,"",""]
["G.3.7.15","PLN","[For completion]","[For completion]",null,"",""]
["G.3.7.16","SEK","[For completion]","[For completion]",null,"",""]
["G.3.7.17","SGD","[For completion]","[For completion]",null,"",""]
["G.3.7.18","USD","[For completion]","[For completion]",null,"",""]
["G.3.7.19","Other","[For completion]","[For completion]",null,"",""]
["OG.3.7.1","Total",{"$f":"SUM(C138:C156)","v":19064.197084095002},{"$f":"SUM(D138:D156)","v":19064.197084095002},null,{"$f":"SUM(F138:F156)","v":1},{"$f":"SUM(G138:G156)","v":1}]
["OG.3.7.2","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$157=0,\"\",IF(C158=\"[for completion]\",\"\",IF(C158=\"\",\"\",C158/$C$157)))","v":""},{"$f":"IF($D$157=0,\"\",IF(D158=\"[for completion]\",\"\",IF(D158=\"\",\"\",D158/$D$157)))","v":""}]
["OG.3.7.3","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$157=0,\"\",IF(C159=\"[for completion]\",\"\",IF(C159=\"\",\"\",C159/$C$157)))","v":""},{"$f":"IF($D$157=0,\"\",IF(D159=\"[for completion]\",\"\",IF(D159=\"\",\"\",D159/$D$157)))","v":""}]
["OG.3.7.4","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$157=0,\"\",IF(C160=\"[for completion]\",\"\",IF(C160=\"\",\"\",C160/$C$157)))","v":""},{"$f":"IF($D$157=0,\"\",IF(D160=\"[for completion]\",\"\",IF(D160=\"\",\"\",D160/$D$157)))","v":""}]
["OG.3.7.5","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$157=0,\"\",IF(C161=\"[for completion]\",\"\",IF(C161=\"\",\"\",C161/$C$157)))","v":""},{"$f":"IF($D$157=0,\"\",IF(D161=\"[for completion]\",\"\",IF(D161=\"\",\"\",D161/$D$157)))","v":""}]
["OG.3.7.6","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$157=0,\"\",IF(C162=\"[for completion]\",\"\",IF(C162=\"\",\"\",C162/$C$157)))","v":""},{"$f":"IF($D$157=0,\"\",IF(D162=\"[for completion]\",\"\",IF(D162=\"\",\"\",D162/$D$157)))","v":""}]
[null,"8. Covered Bonds - Breakdown by interest rate ","Nominal [before hedging] (mn)","Nominal [after hedging] (mn)",null,"% Total [before]","% Total [after]"]
["G.3.8.1","Fixed coupon","[For completion]","[For completion]",null,{"$f":"IF($C$167=0,\"\",IF(C164=\"[for completion]\",\"\",IF(C164=\"\",\"\",C164/$C$167)))","v":""},{"$f":"IF($D$167=0,\"\",IF(D164=\"[for completion]\",\"\",IF(D164=\"\",\"\",D164/$D$167)))","v":""}]
["G.3.8.2","Floating coupon","[For completion]","[For completion]",null,{"$f":"IF($C$167=0,\"\",IF(C165=\"[for completion]\",\"\",IF(C165=\"\",\"\",C165/$C$167)))","v":""},{"$f":"IF($D$167=0,\"\",IF(D165=\"[for completion]\",\"\",IF(D165=\"\",\"\",D165/$D$167)))","v":""}]
["G.3.8.3","Other","[For completion]","[For completion]",null,{"$f":"IF($C$167=0,\"\",IF(C166=\"[for completion]\",\"\",IF(C166=\"\",\"\",C166/$C$167)))","v":""},{"$f":"IF($D$167=0,\"\",IF(D166=\"[for completion]\",\"\",IF(D166=\"\",\"\",D166/$D$167)))","v":""}]
["G.3.8.4","Total",{"$f":"SUM(C164:C166)","v":0},{"$f":"SUM(D164:D166)","v":0},null,{"$f":"SUM(F164:F166)","v":0},{"$f":"SUM(G164:G166)","v":0}]
["OG.3.8.1"]
["OG.3.8.2"]
["OG.3.8.3"]
["OG.3.8.4"]
["OG.3.8.5"]
[null,"9. Substitute Assets - Type","Nominal (mn)",null,null,"% Substitute Assets"]
["G.3.9.1","Cash","[For completion]",null,null,{"$f":"IF($C$179=0,\"\",IF(C174=\"[for completion]\",\"\",C174/$C$179))","v":""}]
["G.3.9.2","Exposures to/guaranteed by Supranational, Sovereign, Agency (SSA)",605.29999999999995,null,null,{"$f":"IF($C$179=0,\"\",IF(C175=\"[for completion]\",\"\",C175/$C$179))","v":0.42617756811941138}]
["G.3.9.3","Exposures to central banks","[For completion]",null,null,{"$f":"IF($C$179=0,\"\",IF(C176=\"[for completion]\",\"\",C176/$C$179))","v":""}]
["G.3.9.4","Exposures to credit institutions",450,null,null,{"$f":"IF($C$179=0,\"\",IF(C177=\"[for completion]\",\"\",C177/$C$179))","v":0.31683447159050904}]
["G.3.9.5","Other",365,null,null,{"$f":"IF($C$179=0,\"\",IF(C178=\"[for completion]\",\"\",C178/$C$179))","v":0.25698796029007959}]
["G.3.9.6","Total",{"$f":"SUM(C174:C178)","v":1420.3},null,null,{"$f":"SUM(F174:F178)","v":1}]
["OG.3.9.1","o/w EU gvts or quasi govts",null,null,null,{"$f":"IF($C$179=0,\"\",IF(C180=\"[for completion]\",\"\",C180/$C$179))","v":0}]
["OG.3.9.2","o/w third-party countries  Credit Quality Step 1 (CQS1) gvts or quasi govts",null,null,null,0]
["OG.3.9.3","o/w third-party countries Credit Quality Step 2 (CQS2) gvts or quasi govts",null,null,null,0]
["OG.3.9.4","o/w EU central banks",null,null,null,0]
["OG.3.9.5","o/w third-party countries Credit Quality Step 1 (CQS1) central banks",null,null,null,0]
["OG.3.9.6","o/w third-party countries Credit Quality Step 2 (CQS2) central banks",null,null,null,0]
["OG.3.9.7","o/w CQS1 credit institutions",null,null,null,0]
["OG.3.9.8","o/w CQS2 credit institutions",null,null,null,0]
["OG.3.9.9"]
["OG.3.9.10"]
["OG.3.9.11"]
["OG.3.9.12"]
[null,"10. Substitute Assets - Country","Nominal (mn)",null,null,"% Substitute Assets"]
["G.3.10.1","Domestic (Country of Issuer)",1084.3,null,null,{"$f":"IF($C$209=0,\"\",IF(C193=\"[for completion]\",\"\",C193/$C$209))","v":0.76343026121241986}]
["G.3.10.2","Eurozone",292,null,null,0.20559036823206364]
["G.3.10.3","Rest of European Union (EU)",24,null,null,1.6897838484827149E-2]
["G.3.10.4","European Economic Area (not member of EU)",20,null,null,1.4081532070689292E-2]
["G.3.10.5","Switzerland","[For completion]",null,null,""]
["G.3.10.6","United Kingdom","[For completion]",null,null,""]
["G.3.10.7","Australia","[For completion]",null,null,""]
["G.3.10.8","Brazil","[For completion]",null,null,""]
["G.3.10.9","Canada","[For completion]",null,null,""]
["G.3.10.10","Japan","[For completion]",null,null,""]
["G.3.10.11","Korea","[For completion]",null,null,""]
["G.3.10.12","New Zealand","[For completion]",null,null,""]
["G.3.10.13","Singapore","[For completion]",null,null,""]
["G.3.10.14","US","[For completion]",null,null,""]
["G.3.10.15","Other","[For completion]",null,null,""]
["G.3.10.16","Total EU","[For completion]",null,null,""]
["OG.3.10.1","Total",{"$f":"SUM(C193:C207)","v":1420.3},null,null,{"$f":"SUM(F193:F207)","v":1}]
["OG.3.10.2","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$209=0,\"\",IF(C210=\"[for completion]\",\"\",C210/$C$209))","v":0}]
["OG.3.10.3","o/w [If relevant, please specify]",null,null,null,0]
["OG.3.10.4","o/w [If relevant, please specify]",null,null,null,0]
["OG.3.10.5","o/w [If relevant, please specify]",null,null,null,0]
["OG.3.10.6","o/w [If relevant, please specify]",null,null,null,0]
["OG.3.10.7","o/w [If relevant, please specify]",null,null,null,0]
[null,"11. Liquid Assets ","Nominal (mn)",null,null,"% Cover Pool","% Covered Bonds"]
["G.3.11.1","Substitute and other marketable assets","[For completion]",null,null,{"$f":"IF($C$38=0,\"\",IF(C217=\"[for completion]\",\"\",IF(C217=\"\",\"\",C217/$C$38)))","v":""},{"$f":"IF($C$39=0,\"\",IF(C217=\"[for completion]\",\"\",IF(C217=\"\",\"\",C217/$C$39)))","v":""}]
["G.3.11.2","Central bank eligible assets",1320.3,null,null,{"$f":"IF($C$38=0,\"\",IF(C218=\"[for completion]\",\"\",IF(C218=\"\",\"\",C218/$C$38)))","v":6.6002960561770185E-2},{"$f":"IF($C$39=0,\"\",IF(C218=\"[for completion]\",\"\",IF(C218=\"\",\"\",C218/$C$39)))","v":6.9255473712126828E-2}]
["G.3.11.3","Other","[For completion]",null,null,{"$f":"IF($C$38=0,\"\",IF(C219=\"[for completion]\",\"\",IF(C219=\"\",\"\",C219/$C$38)))","v":""},{"$f":"IF($C$39=0,\"\",IF(C219=\"[for completion]\",\"\",IF(C219=\"\",\"\",C219/$C$39)))","v":""}]
["G.3.11.4","Total",{"$f":"SUM(C217:C219)","v":1320.3},null,null,{"$f":"SUM(F217:F219)","v":6.6002960561770185E-2},{"$f":"SUM(G217:G219)","v":6.9255473712126828E-2}]
["OG.3.11.1","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$38=0,\"\",IF(C221=\"[for completion]\",\"\",IF(C221=\"\",\"\",C221/$C$38)))","v":""},{"$f":"IF($C$39=0,\"\",IF(C221=\"[for completion]\",\"\",IF(C221=\"\",\"\",C221/$C$39)))","v":""}]
["OG.3.11.2","o/w [If relevant, please specify]",null,null,null,"",""]
["OG.3.11.3","o/w [If relevant, please specify]",null,null,null,"",""]
["OG.3.11.4","o/w [If relevant, please specify]",null,null,null,"",""]
["OG.3.11.5","o/w [If relevant, please specify]",null,null,null,"",""]
["OG.3.11.6","o/w [If relevant, please specify]",null,null,null,"",""]
["OG.3.11.7","o/w [If relevant, please specify]",null,null,null,"",""]
[null,"12. Bond List "]
["G.3.12.1","Bond list ",{"$f":"C17","v":"Https://www.coveredbondlabel.com/issuer/139-berlin-hyp-ag"}]
[null,"13. Derivatives & Swaps"]
["G.3.13.1","Derivatives in the register / cover pool [notional] (mn)","[For completion]"]
["G.3.13.2","Type of interest rate swaps (intra-group, external or both)","[For completion]"]
["G.3.13.3","Type of currency rate swaps (intra-group, external or both)","[For completion]"]
["OG.3.13.1","NPV of Derivatives in the cover pool (mn)"]
["OG.3.13.2","Derivatives outside the cover pool [notional] (mn)"]
["OG.3.13.3","NPV of Derivatives outside the cover pool (mn)"]
["OG.3.13.4"]
["OG.3.13.5"]
[null,"14. Sustainable or other special purpose strategy"]
["G.3.14.1","Is sustainability based on sustainable assets not present in the cover pool?","[Yes/No]"]
["G.3.14.2","Who has provided Second Party Opinion","[For completion]"]
["G.3.14.3","Further details on proceeds strategy ","www.berlinhyp.de"]
["G.3.14.4","Is sustainability based on sustainable collateral assets present in the cover pool?","Y"]
["G.3.14.5","If yes. Further details are available in Tab F","F1. Tab","F2. Tab"]
["G.3.14.6","Is sustainability based on other criteria?","[Yes/No]"]
["G.3.14.7","If yes, please provide frurther details","ESG"]
["OG.3.14.1"]
["OG.3.14.2"]
["OG.3.14.3"]
["OG.3.14.4"]
["OG.3.14.5"]
["OG.3.14.6"]
["OG.3.14.7"]
["OG.3.14.8"]
["OG.3.14.9"]
["OG.3.14.10"]
["OG.3.14.11"]
["OG.3.14.12"]
["OG.3.14.13"]
["OG.3.14.14"]
["OG.3.14.15"]
["OG.3.14.16"]
["OG.3.14.17"]
["OG.3.14.18"]
["OG.3.14.19"]
["OG.3.14.20"]
["OG.3.14.21"]
["OG.3.14.22"]
["OG.3.14.23"]
["OG.3.14.24"]
["OG.3.14.25"]
["OG.3.14.26"]
["OG.3.14.27"]
["OG.3.14.28"]
["OG.3.14.29"]
["OG.3.14.30"]
["OG.3.14.31"]
["OG.3.14.32"]
["OG.3.14.33"]
["OG.3.14.34"]
["OG.3.14.35"]
["OG.3.14.36"]
["OG.3.14.37"]
["OG.3.14.38"]
[null,"4. Compliance Art 14 CBD Check table"]
["The issuer believes that, at the time of its issuance and based on transparency data made publicly available by the issuer, these covered bonds would satisfy the eligibility criteria for Article 14(2) of the Covered Bond Directive (EU) 2019/2162. It should be noted, however, that"]
["whether or not exposures in the form of covered bonds are eligible to preferential treatment under Regulation (EU) 575/2013 is ultimately a matter to be determined by a relevant investor institution and its relevant supervisory authority and the issuer does not accept any responsibility in this regard."]
["G.4.1.1","(a)         Value of the cover pool total assets: ",{"$f":"ROW(B38)","v":38}]
["G.4.1.2","(a)         Value of outstanding covered bonds: ",{"$f":"ROW(B39)","v":39}]
["G.4.1.3","(b)        List of ISIN of issued covered bonds: ",{"$f":"C229","v":"Https://www.coveredbondlabel.com/issuer/139-berlin-hyp-ag"}]
["G.4.1.4","(c)        Geographical distribution: ",{"$f":"IF(ISREF(INDIRECT(\"'B1. HTT Mortgage Assets'!A1\")),ROW('B1. HTT Mortgage Assets'!B43)&\" for Mortgage Assets\",\"\")","v":"43 for Mortgage Assets"},{"$f":"IF(ISREF(INDIRECT(\"'B2. HTT Public Sector Assets'!A1\")),ROW('B2. HTT Public Sector Assets'!B48)& \" for Public Sector Assets\",\"\")","v":"48 for Public Sector Assets"}]
["G.4.1.5","(c)        Type of cover assets:",{"$f":"ROW(B52)","v":52}]
["G.4.1.6","(c)        Loan size: ",{"$f":"IF(ISREF(INDIRECT(\"'B1. HTT Mortgage Assets'!A1\")),ROW('B1. HTT Mortgage Assets'!B186)&\" for Residential Mortgage Assets\",\"\")","v":"186 for Residential Mortgage Assets"},{"$f":"IF(ISREF(INDIRECT(\"'B1. HTT Mortgage Assets'!A1\")),ROW('B1. HTT Mortgage Assets'!B424 )& \" for Commercial Mortgage Assets\",\"\")","v":"424 for Commercial Mortgage Assets"},null,{"$f":"IF(ISREF(INDIRECT(\"'B2. HTT Public Sector Assets'!A1\")),ROW('B2. HTT Public Sector Assets'!B18)& \" for Public Sector Assets\",\"\")","v":"18 for Public Sector Assets"},{"$f":"IF(ISREF(INDIRECT(\"'B3. HTT Shipping Assets'!A1\")),ROW('B3. HTT Shipping Assets'!B116)& \" for Shipping Assets\",\"\")","v":"116 for Shipping Assets"}]
["G.4.1.7","(c)       Valuation Method: ","link to Glossary HG.1.15"]
["G.4.1.8","            (d)        Interest rate risk - cover pool:",{"$f":"IF(ISREF(INDIRECT(\"'B1. HTT Mortgage Assets'!A1\")),ROW('B1. HTT Mortgage Assets'!B149)&\" for Mortgage Assets\",\"\")","v":"149 for Mortgage Assets"},{"$f":"IF(ISREF(INDIRECT(\"'B2. HTT Public Sector Assets'!A1\")),ROW('B2. HTT Public Sector Assets'!B129)&\" for Public Sector Assets\",\"\")","v":"129 for Public Sector Assets"},null,{"$f":"IF(ISREF(INDIRECT(\"'B3. HTT Shipping Assets'!A1\")),ROW('B3. HTT Shipping Assets'!D80)&\" for Shipping Assets\",\"\")","v":"80 for Shipping Assets"}]
["G.4.1.9","(d)        Currency risk - cover pool:",{"$f":"ROW(B111)","v":111}]
["G.4.1.10","          (d)         Interest rate risk - covered bond:",{"$f":"ROW(B163)","v":163}]
["G.4.1.11","(d)        Currency risk - covered bond:",{"$f":"ROW(B137)","v":137}]
["G.4.1.12","            (d)        Liquidity Risk - primary assets cover pool:",{"$nulls":7},"liquidity buffer"]
["G.4.1.13","(d)        Credit Risk:","215 LTV Residential Mortgage","441 LTV Commercial Mortgage",null,"147 for Public Sector Asset - type of debtor",null,null,null,"extendable maturity"]
["G.4.1.14","(d)        Market Risk:","230 Derivatives and Swaps",{"$nulls":6},"liquidity buffer & extendable maturity"]
["G.4.1.15","(d)        Hedging Strategy",{"$f":"ROW('C. HTT Harmonised Glossary'!B18)&\" for Harmonised Glossary\"","v":"18 for Harmonised Glossary"},{"$nulls":6},"other"]
["G.4.1.16","(e)        Maturity Structure - cover assets:",{"$f":"ROW(B65)","v":65}]
["G.4.1.17","(e)        Maturity Structure - covered bond:",{"$f":"ROW(B88)","v":88}]
["G.4.1.18","(e)        Overview maturity extension triggers:","link to Glossary HG 1.7"]
["G.4.1.19","(f)        Levels of OC:",44]
["G.4.1.20","(g)        Percentage of loans in default:",{"$f":"IF(ISREF(INDIRECT(\"'B1. HTT Mortgage Assets'!A1\")),ROW('B1. HTT Mortgage Assets'!B179)& \" for Mortgage Assets\",\"\")","v":"179 for Mortgage Assets"},{"$f":"IF(ISREF(INDIRECT(\"'B2. HTT Public Sector Assets'!A1\")),ROW('B2. HTT Public Sector Assets'!B166)& \" for Public Sector Assets\",\"\")","v":"166 for Public Sector Assets"},null,{"$f":"IF(ISREF(INDIRECT(\"'B3. HTT Shipping Assets'!A1\")),ROW('B3. HTT Shipping Assets'!D110)& \" for Shipping Assets\",\"\")","v":"110 for Shipping Assets"}]
["OG.4.1.1"]
["OG.4.1.2"]
["OG.4.1.3"]
[null,"5. References to Capital Requirements Regulation (CRR) 129(1)"]
["G.5.1.1","Exposure to credit institute credit quality step 1",605.29999999999995]
["G.5.1.2","Exposure to credit institute credit quality step 2",450]
["G.5.1.3","Exposure to credit institute credit quality step 3","[For completion]"]
["OG.5.1.1"]
["OG.5.1.2"]
["OG.5.1.3"]
["OG.5.1.4"]
[null,"6. Other relevant information"]
[null,"1. Optional information e.g. Rating triggers"]
["OG.6.1.1","NPV Test (passed/failed)"]
["OG.6.1.2","Interest Covereage Test (passe/failed)"]
["OG.6.1.3","Cash Manager "]
["OG.6.1.4","Account Bank"]
["OG.6.1.5","Stand-by Account Bank"]
["OG.6.1.6","Servicer "]
["OG.6.1.7","Interest Rate Swap Provider "]
["OG.6.1.8","Covered Bond Swap Provider "]
["OG.6.1.9","Paying Agent"]
["OG.6.1.10","Other optional/relevant information"]
["OG.6.1.11","Other optional/relevant information"]
["OG.6.1.12","Other optional/relevant information"]
["OG.6.1.13","Other optional/relevant information"]
["OG.6.1.14","Other optional/relevant information"]
["OG.6.1.15","Other optional/relevant information"]
["OG.6.1.16","Other optional/relevant information"]
["OG.6.1.17","Other optional/relevant information"]
["OG.6.1.18","Other optional/relevant information"]
["OG.6.1.19","Other optional/relevant information"]
["OG.6.1.20","Other optional/relevant information"]
["OG.6.1.21","Other optional/relevant information"]
["OG.6.1.22","Other optional/relevant information"]
["OG.6.1.23","Other optional/relevant information"]
["OG.6.1.24","Other optional/relevant information"]
["OG.6.1.25","Other optional/relevant information"]
["OG.6.1.26","Other optional/relevant information"]
["OG.6.1.27","Other optional/relevant information"]
["OG.6.1.28","Other optional/relevant information"]
["OG.6.1.29","Other optional/relevant information"]
["OG.6.1.30","Other optional/relevant information"]
["OG.6.1.31","Other optional/relevant information"]
["OG.6.1.32","Other optional/relevant information"]
["OG.6.1.33","Other optional/relevant information"]
["OG.6.1.34","Other optional/relevant information"]
["OG.6.1.35","Other optional/relevant information"]
["OG.6.1.36","Other optional/relevant information"]
["OG.6.1.37","Other optional/relevant information"]
["OG.6.1.38","Other optional/relevant information"]
["OG.6.1.39","Other optional/relevant information"]
["OG.6.1.40","Other optional/relevant information"]
["OG.6.1.41","Other optional/relevant information"]
["OG.6.1.42","Other optional/relevant information"]
["OG.6.1.43","Other optional/relevant information"]
["OG.6.1.44","Other optional/relevant information"]
["OG.6.1.45","Other optional/relevant information"]

{"sheet":"B1. HTT Mortgage Assets","index":5,"n_rows":622,"n_cols":7,"rows_kept":622,"cut":false,"hidden":false,"merged":[]}
["B1. Harmonised Transparency Template - Mortgage Assets",{"$nulls":4},"HTT 2025"]
[]
[null,"Reporting in Domestic Currency","EUR"]
[]
[null,"CONTENT OF TAB B1"]
[null,"7. Mortgage Assets"]
[null,"7.A Residential Cover Pool"]
[null,"7.B Commercial Cover Pool"]
[]
["Field Number","7. Mortgage Assets"]
[null,"1. Property Type Information","Nominal (mn)",null,null,"% Total Mortgages"]
["M.7.1.1","Residential",6143.7493909870009,null,null,{"$f":"IF($C$15=0,\"\",IF(C12=\"[for completion]\",\"\",C12/$C$15))","v":0.33060508478024725}]
["M.7.1.2","Commercial",12439.598760088,null,null,{"$f":"IF($C$15=0,\"\",IF(C13=\"[for completion]\",\"\",C13/$C$15))","v":0.66939491521975281}]
["M.7.1.3","Other","[For completion]",null,null,{"$f":"IF($C$15=0,\"\",IF(C14=\"[for completion]\",\"\",C14/$C$15))","v":""}]
["M.7.1.4","Total",{"$f":"SUM(C12:C14)","v":18583.348151074999},null,null,{"$f":"SUM(F12:F14)","v":1}]
["OM.7.1.1","o/w Housing Cooperatives / Multi-family assets",5941.6327704770001,null,null,{"$f":"IF($C$15=0,\"\",IF(C16=\"[for completion]\",\"\",C16/$C$15))","v":0.3197288627525009}]
["OM.7.1.2","o/w Forest & Agriculture",null,null,null,0]
["OM.7.1.3","o/w [If relevant, please specify]",null,null,null,0]
["OM.7.1.4","o/w [If relevant, please specify]",null,null,null,0]
["OM.7.1.5","o/w [If relevant, please specify]",null,null,null,0]
["OM.7.1.6","o/w [If relevant, please specify]",null,null,null,0]
["OM.7.1.7","o/w [If relevant, please specify]",null,null,null,0]
["OM.7.1.8","o/w [If relevant, please specify]",null,null,null,0]
["OM.7.1.9","o/w [If relevant, please specify]",null,null,null,0]
["OM.7.1.10","o/w [If relevant, please specify]",null,null,null,0]
["OM.7.1.11","o/w [If relevant, please specify]",null,null,null,0]
[null,"2. General Information","Residential Loans","Commercial Loans",null,"Total Mortgages"]
["M.7.2.1","Number of mortgage loans",582,722,null,{"$f":"IF(AND(C28=\"[For completion]\",D28=\"[For completion]\"),\"[For completion]\",SUM(C28:D28))","v":1304}]
["OM.7.2.1","Optional information eg, Number of borrowers",510,668]
["OM.7.2.2","Optional information eg, Number of guarantors"]
["OM.7.2.3"]
["OM.7.2.4"]
["OM.7.2.5"]
["OM.7.2.6"]
[null,"3. Concentration Risks","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["M.7.3.1","10 largest exposures ","[For completion]","[For completion]",null,0.186787360461694]
["OM.7.3.1"]
["OM.7.3.2"]
["OM.7.3.3"]
["OM.7.3.4"]
["OM.7.3.5"]
["OM.7.3.6"]
[null,"4. Breakdown by Geography ","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["M.7.4.1","European Union",{"$f":"SUM(C45:C71)","v":0.99999999999999956},{"$f":"SUM(D45:D71)","v":1},null,{"$f":"SUM(F45:F71)","v":0.99999999999999989}]
["M.7.4.2","Austria","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.3","Belgium","[For completion]",2.6431715551384388E-3,null,1.769325599063158E-3]
["M.7.4.4","Bulgaria","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.5","Croatia","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.6","Cyprus","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.7","Czechia","[For completion]",1.431074976237743E-2,null,9.5795431239177418E-3]
["M.7.4.8","Denmark","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.9","Estonia","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.10","Finland","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.11","France",2.3829051265465231E-3,0.1168511392749871,null,7.900735901969673E-2]
["M.7.4.12","Germany",0.83356287733837253,0.5669151898825483,null,0.65507027120033801]
["M.7.4.13","Greece","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.14","Netherlands",0.16405421753508051,0.20121213305374269,null,0.18892753724343819]
["M.7.4.15","Hungary","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.16","Ireland","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.17","Italy","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.18","Latvia","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.19","Lithuania","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.20","Luxembourg","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.21","Malta","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.22","Poland","[For completion]",9.8067616471206015E-2,null,6.564596381354619E-2]
["M.7.4.23","Portugal","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.24","Romania","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.25","Slovakia","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.26","Slovenia","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.27","Spain","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.28","Sweden","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.29","European Economic Area (not member of EU)",{"$f":"SUM(C73:C75)","v":0},{"$f":"SUM(D73:D75)","v":0},null,{"$f":"SUM(F73:F75)","v":0}]
["M.7.4.30","Iceland","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.31","Liechtenstein","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.32","Norway","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.33","Other",{"$f":"SUM(C77:C87)","v":0},{"$f":"SUM(D77:D87)","v":0},null,{"$f":"SUM(F77:F87)","v":0}]
["M.7.4.34","Switzerland","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.35","United Kingdom","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.36","Australia","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.37","Brazil","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.38","Canada","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.39","Japan","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.40","Korea","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.41","New Zealand","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.42","Singapore","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.43","US","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.44","Other","[For completion]","[For completion]",null,"[For completion]"]
["OM.7.4.1","o/w [If relevant, please specify]"]
["OM.7.4.2","o/w [If relevant, please specify]"]
["OM.7.4.3","o/w [If relevant, please specify]"]
["OM.7.4.4","o/w [If relevant, please specify]"]
["OM.7.4.5","o/w [If relevant, please specify]"]
["OM.7.4.6","o/w [If relevant, please specify]"]
["OM.7.4.7","o/w [If relevant, please specify]"]
["OM.7.4.8","o/w [If relevant, please specify]"]
["OM.7.4.9","o/w [If relevant, please specify]"]
["OM.7.4.10","o/w [If relevant, please specify]"]
[null,"5. Breakdown by regions of the main country of origin","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["M.7.5.1","Baden-Württemberg",1.2297905499999999E-2,5.44700371E-2,null,6.676794250000001E-2]
["M.7.5.2","Bavaria",5.6509782699999997E-2,8.6465081599999993E-2,null,0.1429748643]
["M.7.5.3","Berlin",0.1184001464,0.1265369902,null,0.24493713650000001]
["M.7.5.4","Brandenburg",7.1154128999999997E-3,1.2543584700000001E-2,null,1.9658997599999999E-2]
["M.7.5.5","Bremen",2.1056083999999998E-3,6.6378691999999986E-3,null,8.7434774999999992E-3]
["M.7.5.6","Hamburg",1.6007509499999999E-2,3.9191891200000002E-2,null,5.5199400699999998E-2]
["M.7.5.7","Hesse",2.8972093899999999E-2,8.6242081400000004E-2,null,0.1152141753]
["M.7.5.8","Lower Saxony",9.8717801999999993E-3,2.0214845700000001E-2,null,3.0086625799999999E-2]
["M.7.5.9","Mecklenburg-Western Pomerania",1.0633715300000001E-2,4.1928709999999999E-3,null,1.48265862E-2]
["M.7.5.10","North Rhine-Westphalia",0.1106049711,9.181775930000001E-2,null,0.2024227304]
["M.7.5.11","Rhineland-Palatinate",3.2558081999999999E-3,1.0395749399999999E-2,null,1.3651557599999999E-2]
["M.7.5.12","Saarland",7.3931629999999995E-4,2.1408222000000002E-3,null,2.8801385000000001E-3]
["M.7.5.13","Saxony",3.6164866400000002E-2,1.8522848799999998E-2,null,5.4687715200000001E-2]
["M.7.5.14","Saxony-Anhalt",2.6501399E-3,3.5591601E-3,null,6.2093000000000001E-3]
["M.7.5.15","Schleswig-Holstein",4.2434613999999997E-3,9.3417556999999991E-3,null,1.35852171E-2]
["M.7.5.16","Thuringia",1.1153653E-3,7.0387694000000004E-3,null,8.1541345999999997E-3]
["M.7.5.17","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.18","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.19","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.20","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.21","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.22","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.23","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.24","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.25","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.26","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.27","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.28","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.29","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.30","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.31","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.32","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.33","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.34","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.35","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.36","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.37","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.38","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.39","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.40","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.41","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.42","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.43","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.44","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.45","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.46","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.47","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.48","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.49","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.50","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
[null,"6. Breakdown by Interest Rate","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["M.7.6.1","Fixed rate",0.2762,0.46110000000000001,null,{"$f":"SUM(C150,D150)","v":0.73730000000000007}]
["M.7.6.2","Floating rate",5.4199999999999998E-2,0.18959999999999999,null,{"$f":"SUM(C151,D151)","v":0.24379999999999999}]
["M.7.6.3","Other",2.0000000000000001E-4,1.8599999999999998E-2,null,{"$f":"SUM(C152,D152)","v":1.8799999999999997E-2}]
["OM.7.6.1"]
["OM.7.6.2"]
["OM.7.6.3"]
["OM.7.6.4"]
["OM.7.6.5"]
["OM.7.6.6"]
[null,"7. Breakdown by Repayment Type","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["M.7.7.1","Bullet / interest only",0.219,0.41560000000000002,null,{"$f":"SUM(C160,D160)","v":0.63460000000000005}]
["M.7.7.2","Amortising",0.1116,0.25380000000000003,null,{"$f":"SUM(C161,D161)","v":0.36540000000000006}]
["M.7.7.3","Other","[For completion]","[For completion]",null,{"$f":"SUM(C162,D162)","v":0}]
["OM.7.7.1"]
["OM.7.7.2"]
["OM.7.7.3"]
["OM.7.7.4"]
["OM.7.7.5"]
["OM.7.7.6"]
[null,"8. Loan Seasoning ","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["M.7.8.1","Up to 12months",1.3100000000000001E-2,7.3899999999999993E-2,null,{"$f":"SUM(C170,D170)","v":8.6999999999999994E-2}]
["M.7.8.2",">  12 - ≤ 24 months",3.9600000000000003E-2,7.17E-2,null,{"$f":"SUM(C171,D171)","v":0.11130000000000001}]
["M.7.8.3","> 24 - ≤ 36 months",2.81E-2,8.8399999999999992E-2,null,{"$f":"SUM(C172,D172)","v":0.11649999999999999}]
["M.7.8.4","> 36 - ≤ 60 months",9.6199999999999994E-2,0.15040000000000001,null,{"$f":"SUM(C173,D173)","v":0.24659999999999999}]
["M.7.8.5","> 60 months",0.1535,0.28499999999999998,null,{"$f":"SUM(C174,D174)","v":0.4385}]
["OM.7.8.1"]
["OM.7.8.2"]
["OM.7.8.3"]
["OM.7.8.4"]
[null,"9. Non-Performing Loans (NPLs)","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["M.7.9.1","% NPLs","[For completion]",7.1299999999999987E-6,null,{"$f":"SUM(C180,D180)","v":7.1299999999999987E-6}]
["M.7.9.2","Defaulted Loans pursuant Art 178 CRR","[For completion]",5.2789999999999998E-4,null,{"$f":"SUM(C181,D181)","v":5.2789999999999998E-4}]
["OM.7.9.1"]
["OM.7.9.2"]
["OM.7.9.3"]
[null,"7.A Residential Cover Pool"]
[null,"10. Loan Size Information","Nominal","Number of Loans",null,"% Residential Loans:","% No. of Loans"]
["M.7A.10.1","Average loan size (000s)",{"$f":"(C12/C28)*1000","v":10556.270431249142},{"$f":"C28","v":582}]
[]
[null,"By buckets (mn):"]
["M.7A.10.2","Up to 300,000 Euros",9.8885714800000013,193.43984499999999,null,{"$f":"C190/$C$214","v":1.6095336659562771E-3},{"$f":"IF($D$214=0,\"\",IF(D190=\"[for completion]\",\"\",IF(D190=\"\",\"\",D190/$D$214)))","v":0.33263384961940384}]
["M.7A.10.3","More than 300,000 Euros up to 1 mn. Euros",33.993271760000013,56.206679999999999,null,{"$f":"C191/$C$214","v":5.5329847616898461E-3},9.6651464659341282E-2]
["M.7A.10.4","More than 1 mn. Euros up to 10 mn. Euros",766.69024794799998,174.524675,null,{"$f":"C192/$C$214","v":0.12479191437595508},0.30010784230531889]
["M.7A.10.5","More than 10 mn. Euros",5333.1772998040014,157.36866800000001,null,{"$f":"C193/$C$214","v":0.86806556719639882},0.27060684341593583]
["M.7A.10.6","TBC at a country level","[For completion]","[For completion]",null,{"$f":"IF($C$214=0,\"\",IF(C194=\"[for completion]\",\"\",IF(C194=\"\",\"\",C194/$C$214)))","v":""},""]
["M.7A.10.7","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.8","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.9","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.10","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.11","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.12","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.13","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.14","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.15","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.16","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.17","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.18","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.19","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.20","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.21","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.22","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.23","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.24","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.25","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.26","Total",{"$f":"SUM(C190:C213)","v":6143.7493909920013},{"$f":"SUM(D190:D213)","v":581.53986800000007},null,{"$f":"SUM(F190:F213)","v":1},{"$f":"SUM(G190:G213)","v":0.99999999999999978}]
[null,"11. Loan to Value (LTV) Information - UNINDEXED","Nominal","Number of Loans",null,"% Residential Loans","% No. of Loans"]
["M.7A.11.1","Weighted Average LTV (%)",0.5732931966]
[]
[null,"By LTV buckets (mn):"]
["M.7A.11.2",">0 - <=40 %",155.87435486000001,232,null,{"$f":"IF($C$227=0,\"\",IF(C219=\"[for completion]\",\"\",C219/$C$227))","v":2.5371209816686835E-2},{"$f":"IF($D$227=0,\"\",IF(D219=\"[for completion]\",\"\",D219/$D$227))","v":0.3989408334099962}]
["M.7A.11.3",">40 - <=50 %",270.268094281,40.345222,null,4.3990741985222993E-2,6.9376536589617732E-2]
["M.7A.11.4",">50 - <=60 %",5717.6069418510006,309.19464699999997,null,0.93063804819809015,0.53168263000038607]
["M.7A.11.5",">60 - <=70 %","[For completion]","[For completion]",null,"",""]
["M.7A.11.6",">70 - <=80 %","[For completion]","[For completion]",null,"",""]
["M.7A.11.7",">80 - <=90 %","[For completion]","[For completion]",null,"",""]
["M.7A.11.8",">90 - <=100 %","[For completion]","[For completion]",null,"",""]
["M.7A.11.9",">100%","[For completion]","[For completion]",null,"",""]
["M.7A.11.10","Total",{"$f":"SUM(C219:C226)","v":6143.7493909920004},{"$f":"SUM(D219:D226)","v":581.53986899999995},null,{"$f":"SUM(F219:F226)","v":1},{"$f":"SUM(G219:G226)","v":1}]
["OM.7A.11.1","o/w >100 - <=110 %",null,null,null,{"$f":"IF($C$227=0,\"\",IF(C228=\"[for completion]\",\"\",C228/$C$227))","v":0},{"$f":"IF($D$227=0,\"\",IF(D228=\"[for completion]\",\"\",D228/$D$227))","v":0}]
["OM.7A.11.2","o/w >110 - <=120 %",null,null,null,0,0]
["OM.7A.11.3","o/w >120 - <=130 %",null,null,null,0,0]
["OM.7A.11.4","o/w >130 - <=140 %",null,null,null,0,0]
["OM.7A.11.5","o/w >140 - <=150 %",null,null,null,0,0]
["OM.7A.11.6","o/w >150 %",null,null,null,0,0]
["OM.7A.11.7"]
["OM.7A.11.8"]
["OM.7A.11.9"]
[null,"12. Loan to Value (LTV) Information - INDEXED ","Nominal","Number of Loans",null,"% Residential Loans","% No. of Loans"]
["M.7A.12.1","Weighted Average LTV (%)","ND1"]
[]
[null,"By LTV buckets (mn):"]
["M.7A.12.2",">0 - <=40 %","ND1","ND1",null,{"$f":"IF($C$249=0,\"\",IF(C241=\"[Mark as ND1 if not relevant]\",\"\",C241/$C$249))","v":""},{"$f":"IF($D$249=0,\"\",IF(D241=\"[Mark as ND1 if not relevant]\",\"\",D241/$D$249))","v":""}]
["M.7A.12.3",">40 - <=50 %","ND1","ND1",null,"",""]
["M.7A.12.4",">50 - <=60 %","ND1","ND1",null,"",""]
["M.7A.12.5",">60 - <=70 %","ND1","ND1",null,"",""]
["M.7A.12.6",">70 - <=80 %","ND1","ND1",null,"",""]
["M.7A.12.7",">80 - <=90 %","ND1","ND1",null,"",""]
["M.7A.12.8",">90 - <=100 %","ND1","ND1",null,"",""]
["M.7A.12.9",">100%","ND1","ND1",null,"",""]
["M.7A.12.10","Total",{"$f":"SUM(C241:C248)","v":0},{"$f":"SUM(D241:D248)","v":0},null,{"$f":"SUM(F241:F248)","v":0},{"$f":"SUM(G241:G248)","v":0}]
["OM.7A.12.1","o/w >100 - <=110 %",null,null,null,{"$f":"IF($C$249=0,\"\",IF(C250=\"[for completion]\",\"\",C250/$C$249))","v":""},{"$f":"IF($D$249=0,\"\",IF(D250=\"[for completion]\",\"\",D250/$D$249))","v":""}]
["OM.7A.12.2","o/w >110 - <=120 %",null,null,null,"",""]
["OM.7A.12.3","o/w >120 - <=130 %",null,null,null,"",""]
["OM.7A.12.4","o/w >130 - <=140 %",null,null,null,"",""]
["OM.7A.12.5","o/w >140 - <=150 %",null,null,null,"",""]
["OM.7A.12.6","o/w >150 %",null,null,null,"",""]
["OM.7A.12.7"]
["OM.7A.12.8"]
["OM.7A.12.9"]
[null,"13. Breakdown by type","% Residential Loans"]
["M.7A.13.1","Owner occupied",2.29502657E-2]
["M.7A.13.2","Second home/Holiday houses","[For completion]"]
["M.7A.13.3","Buy-to-let/Non-owner occupied","[For completion]"]
["M.7A.13.4","Subsidised housing","[For completion]"]
["M.7A.13.5","Agricultural","[For completion]"]
["M.7A.13.6","Other","[For completion]"]
["OM.7A.13.1","o/w Private rental"]
["OM.7A.13.2","o/w Multi-family housing ",0.96710207269999993]
["OM.7A.13.3","o/w Buildings under construction "]
["OM.7A.13.4","o/w Buildings land",9.9476614999999997E-3]
["OM.7A.13.5","o/w [If relevant, please specify]"]
["OM.7A.13.6","o/w [If relevant, please specify]"]
["OM.7A.13.7","o/w [If relevant, please specify]"]
["OM.7A.13.8","o/w [If relevant, please specify]"]
["OM.7A.13.9","o/w [If relevant, please specify]"]
["OM.7A.13.10","o/w [If relevant, please specify]"]
[null,"14. Loan by Ranking","% Residential Loans"]
["M.7A.14.1","1st lien / No prior ranks","[For completion]"]
["M.7A.14.2","Guaranteed","[For completion]"]
["M.7A.14.3","Other","[For completion]"]
["OM.7A.14.1"]
["OM.7A.14.2"]
["OM.7A.14.3"]
["OM.7A.14.4"]
["OM.7A.14.5"]
["OM.7A.14.6"]
[null,"15. EPC  Information of the financed RRE - optional","Nominal (mn)","Number of dwellings",null,"% Residential Loans","% No. of Dwellings"]
["M.7A.15.1","A+",76.396699196,10,null,{"$f":"IF($C$305=0,\"\",IF(C287=\"[For completion]\",\"\",C287/$C$305))","v":1.2434865801657416E-2},{"$f":"IF($D$305=0,\"\",IF(D287=\"[For completion]\",\"\",D287/$D$305))","v":3.6101083032490976E-3}]
["M.7A.15.2","A",640.00116642,76,null,0.10417110557249833,2.7436823104693142E-2]
["M.7A.15.3","B",673.17776113799994,160,null,0.10957116221651504,5.7761732851985562E-2]
["M.7A.15.4","C",1008.016998574,410,null,0.16407195906329775,0.14801444043321299]
["M.7A.15.5","D",1177.383396318,549,null,0.19163922897706182,0.19819494584837546]
["M.7A.15.6","E",635.17068291600003,403,null,0.1033848619944184,0.14548736462093864]
["M.7A.15.7","F",366.532918494,292,null,5.9659484000342301E-2,0.10541516245487365]
["M.7A.15.8","G",165.40678304400001,176,null,2.6922775086907085E-2,6.3537906137184116E-2]
["M.7A.15.9","H",61.709576581999997,112,null,1.0044286095471101E-2,4.043321299638989E-2]
["M.7A.15.10","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.15.11","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.15.12","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.15.13","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.15.14","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.15.15","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.15.16","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.15.17","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.15.18","no data",1339.95340831,582,null,0.2181002711918307,0.21010830324909746]
["M.7A.15.19","Total",{"$f":"SUM(C287:C304)","v":6143.7493909920004},{"$f":"SUM(D287:D304)","v":2770},null,{"$f":"SUM(F287:F304)","v":1},{"$f":"SUM(G287:G304)","v":1}]
["OM.7A.15.1"]
["OM.7A.15.2"]
["OM.7A.15.3"]
[null,"16. Average energy use intensity (kWh/m2 per year) - optional","Nominal (mn)","Number of dwellings",null,"% Residential Loans","% No. of Dwellings"]
["M.7A.16.1","≤ 30","[For completion]","[For completion]",null,{"$f":"IF($C$328=0,\"\",IF(C310=\"[For completion]\",\"\",C310/$C$328))","v":""},{"$f":"IF($D$328=0,\"\",IF(D310=\"[For completion]\",\"\",D310/$D$328))","v":""}]
["M.7A.16.2","> 30 - ≤ 50","[For completion]","[For completion]",null,"",""]
["M.7A.16.3","> 50 - ≤ 75","[For completion]","[For completion]",null,"",""]
["M.7A.16.4","> 75 - ≤ 100","[For completion]","[For completion]",null,"",""]
["M.7A.16.5","> 100 - ≤ 130","[For completion]","[For completion]",null,"",""]
["M.7A.16.6","> 130 - ≤ 160","[For completion]","[For completion]",null,"",""]
["M.7A.16.7","> 160 - ≤ 200","[For completion]","[For completion]",null,"",""]
["M.7A.16.8","> 200 - ≤ 250","[For completion]","[For completion]",null,"",""]
["M.7A.16.9","> 250","[For completion]","[For completion]",null,"",""]
["M.7A.16.10","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.16.11","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.16.12","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.16.13","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.16.14","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.16.15","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.16.16","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.16.17","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.16.18","no data","[For completion]","[For completion]",null,"",""]
["M.7A.16.19","Total",{"$f":"SUM(C310:C327)","v":0},{"$f":"SUM(D310:D327)","v":0},null,{"$f":"SUM(F310:F327)","v":0},{"$f":"SUM(G310:G327)","v":0}]
["OM.7A.16.1"]
["OM.7A.16.2"]
["OM.7A.16.3"]
[null,"17. Property Age Structure - optional","Nominal (mn)","Number of dwellings",null,"% Residential Loans","% No. of Dwellings"]
["M.7A.17.1","older than 1919",579.01173469900004,550,null,{"$f":"IF($C$346=0,\"\",IF(C333=\"[For completion]\",\"\",C333/$C$346))","v":9.4244035335808177E-2},{"$f":"IF($D$346=0,\"\",IF(D333=\"[For completion]\",\"\",D333/$D$346))","v":0.19855595667870035}]
["M.7A.17.2","1919 - 1945",363.03381521400001,273,null,5.9089945261485151E-2,9.855595667870036E-2]
["M.7A.17.3","1946 - 1960",869.21436855799993,731,null,0.14147946363704986,0.263898916967509]
["M.7A.17.4","1961 - 1970",888.980385071,375,null,0.14469671994994263,0.13537906137184116]
["M.7A.17.5","1971 - 1980",937.19878171000005,300,null,0.15254508640670242,0.10830324909747292]
["M.7A.17.6","1981 - 1990",604.82161887699999,159,null,9.8445034194232076E-2,5.7400722021660647E-2]
["M.7A.17.7","1991 - 2000",391.42231088300002,125,null,6.3710657120374339E-2,4.5126353790613721E-2]
["M.7A.17.8","2001 - 2005",75.881845388999992,18,null,1.2351064563319978E-2,6.4981949458483759E-3]
["M.7A.17.9","2006 - 2010",176.86035732100001,29,null,2.8787039650463878E-2,1.0469314079422382E-2]
["M.7A.17.10","2011 - 2015",221.40822261,23,null,3.603796452612959E-2,8.3032490974729242E-3]
["M.7A.17.11","2016 - 2020",599.15825415999996,52,null,9.7523224993273511E-2,1.8772563176895306E-2]
["M.7A.17.12","2021 and onwards",372.02655116,32,null,6.0553666415083175E-2,1.1552346570397111E-2]
["M.7A.17.13","no data",64.731145339999998,103,null,1.0536097946135166E-2,3.7184115523465705E-2]
["M.7A.17.14","Total",{"$f":"SUM(C333:C345)","v":6143.7493909920004},{"$f":"SUM(D333:D345)","v":2770},null,{"$f":"SUM(F333:F345)","v":1},{"$f":"SUM(G333:G345)","v":1.0000000000000002}]
["OM.7A.17.1"]
["OM.7A.17.2"]
["OM.7A.17.3"]
["OM.7A.17.4"]
["OM.7A.17.5"]
["OM.7A.17.6"]
["OM.7A.17.7"]
["OM.7A.17.8"]
["OM.7A.17.9"]
["OM.7A.17.10"]
[null,"18. Dwelling type - optional","Nominal (mn)","Number of dwellings",null,"% Residential Loans","% No. of Dwellings"]
["M.7A.18.1","House, detached or semi-detached",117.822423814,113,null,{"$f":"IF($C$365=0,\"\",IF(C358=\"[For completion]\",\"\",C358/$C$365))","v":1.9177609032482983E-2},{"$f":"IF($D$365=0,\"\",IF(D358=\"[For completion]\",\"\",D358/$D$365))","v":4.0794223826714798E-2}]
["M.7A.18.2","Flat or Apartment",23.178257201000001,56,null,3.7726566833901284E-3,2.0216606498194945E-2]
["M.7A.18.3","Bungalow","[For completion]","[For completion]",null,"",""]
["M.7A.18.4","Terraced House","[For completion]","[For completion]",null,"",""]
["M.7A.18.5","Multifamily House",5941.6327704770001,2600,null,0.96710207274871196,0.93862815884476536]
["M.7A.18.6","Land Only",61.115939500000003,1,null,9.9476615354149259E-3,3.6101083032490973E-4]
["M.7A.18.7","other","[For completion]","[For completion]",null,"",""]
["M.7A.18.8","Total",{"$f":"SUM(C358:C364)","v":6143.7493909920004},{"$f":"SUM(D358:D364)","v":2770},null,{"$f":"SUM(F358:F364)","v":1},{"$f":"SUM(G358:G364)","v":1}]
["OM.7A.18.1"]
[null,"19. New Residential Property - optional","Nominal (mn)","Number of dwellings",null,"% Residential Loans","% No. of Dwellings"]
["M.7A.19.1","New Property","[For completion]","[For completion]",null,{"$f":"IF($C$372=0,\"\",IF(C368=\"[For completion]\",\"\",C368/$C$372))","v":""},{"$f":"IF($D$372=0,\"\",IF(D368=\"[For completion]\",\"\",D368/$D$372))","v":""}]
["M.7A.19.2","Existing property","[For completion]","[For completion]",null,{"$f":"IF($C$372=0,\"\",IF(C369=\"[For completion]\",\"\",C369/$C$372))","v":""},{"$f":"IF($D$372=0,\"\",IF(D369=\"[For completion]\",\"\",D369/$D$372))","v":""}]
["M.7A.19.3","other","[For completion]","[For completion]",null,{"$f":"IF($C$372=0,\"\",IF(C370=\"[For completion]\",\"\",C370/$C$372))","v":""},{"$f":"IF($D$372=0,\"\",IF(D370=\"[For completion]\",\"\",D370/$D$372))","v":""}]
["M.7A.19.4","no data","[For completion]",null,null,{"$f":"IF($C$372=0,\"\",IF(C371=\"[For completion]\",\"\",C371/$C$372))","v":""},{"$f":"IF($D$372=0,\"\",IF(D371=\"[For completion]\",\"\",D371/$D$372))","v":""}]
["M.7A.19.5","Total",{"$f":"SUM(C368:C371)","v":0},{"$f":"SUM(D368:D371)","v":0},null,{"$f":"SUM(F368:F371)","v":0},{"$f":"SUM(G368:G371)","v":0}]
["M.7A.19.6"]
[null,"20. CO2 emission - by dwelling type - as per national availability","Ton CO2 (per year)","Ton CO2 (per year) (LTV adjusted)",null,"kg CO2/m2 (per year)","% No. of Dwellings with no CO2 data"]
["M.7A.20.1","House, detached or semi-detached","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7A.20.2","Flat or Apartment","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7A.20.3","Bungalow","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7A.20.4","Terraced House","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7A.20.5","Multifamily House","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7A.20.6","Land Only","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7A.20.7","Other","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7A.20.8","Total",{"$f":"SUM(C375:C381)","v":0},{"$f":"SUM(D375:D381)","v":0}]
["M.7A.20.9","Weighted Average",null,null,null,"[For completion]",{"$f":"IF($D$393=0,\"\",IF(D382=\"[For completion]\",\"\",D382/$D$393))","v":""}]
["M.7A.20.10",{"$nulls":5},{"$f":"IF($D$393=0,\"\",IF(D383=\"[For completion]\",\"\",D383/$D$393))","v":""}]
["M.7A.20.11",{"$nulls":5},{"$f":"IF($D$393=0,\"\",IF(D385=\"[For completion]\",\"\",D385/$D$393))","v":""}]
["M.7A.20.12",{"$nulls":5},""]
["M.7A.20.13",{"$nulls":5},""]
["M.7A.20.14",{"$nulls":5},""]
["M.7A.20.15",{"$nulls":5},""]
["M.7A.20.16",{"$nulls":5},""]
["M.7A.20.17",{"$nulls":5},""]
["M.7A.20.18",{"$nulls":5},""]
["M.7A.20.19",{"$nulls":5},""]
["M.7A.20.20"]
["M.7A.20.21"]
["M.7A.20.22"]
["M.7A.20.23"]
["M.7A.20.24"]
["M.7A.20.25"]
["M.7A.20.26"]
["M.7A.20.27"]
["M.7A.20.28"]
["M.7A.20.29"]
["M.7A.20.30"]
["M.7A.20.31"]
["M.7A.20.32"]
["M.7A.20.33"]
["M.7A.20.34"]
["M.7A.20.35"]
["M.7A.20.36"]
["M.7A.20.37"]
["M.7A.20.38"]
["M.7A.20.39"]
["M.7A.20.40"]
["M.7A.20.41"]
["M.7A.20.42"]
["M.7A.20.43"]
["M.7A.20.44"]
["M.7A.20.45"]
["M.7A.20.46"]
["M.7A.20.47"]
["M.7A.20.48"]
[null,"7.B Commercial Cover Pool"]
[null,"21. Loan Size Information","Nominal","Number of Loans",null,"% Commercial Loans","% No. of Loans"]
["M.7B.21.1","Average loan size (000s)",{"$f":"(C13/D28)*1000","v":17229.361163556783},{"$f":"D28","v":722}]
[]
[null,"By buckets (mn):"]
["M.7B.21.2","Up to 300,000 Euros",4.14186093,23.560155000000002,null,{"$f":"IF($C$452=0,\"\",IF(C428=\"[for completion]\",\"\",C428/$C$452))","v":3.3295775932036813E-4},{"$f":"IF($D$452=0,\"\",IF(D428=\"[for completion]\",\"\",D428/$D$452))","v":3.2611010568538892E-2}]
["M.7B.21.3","More than 300,000 Euros up to 1 mn. Euros",35.997813179999987,59.793320000000001,null,2.8938082227801913E-3,8.2763487356005416E-2]
["M.7B.21.4","More than 1 mn. Euros up to 10 mn. Euros",1358.239350482,290.475325,null,0.10918674924153933,0.40206415846902405]
["M.7B.21.5","More than 10 mn. Euros",11041.219735486,348.63133199999999,null,0.88758648477636015,0.48256134360643171]
["M.7B.21.6","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.7","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.8","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.9","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.10","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.11","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.12","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.13","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.14","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.15","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.16","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.17","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.18","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.19","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.20","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.21","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.22","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.23","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.24","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.25","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.21.26","Total",{"$f":"SUM(C428:C451)","v":12439.598760077999},{"$f":"SUM(D428:D451)","v":722.46013199999993},null,{"$f":"SUM(F428:F451)","v":1},{"$f":"SUM(G428:G451)","v":1}]
[null,"22. Loan to Value (LTV) Information - UNINDEXED ","Nominal","Number of Loans",null,"% Commercial Loans","% No. of Loans"]
["M.7B.22.1","Weighted Average LTV (%)",0.55153088620000001]
[]
[null,"By LTV buckets (mn):"]
["M.7B.22.2",">0 - <=40 %",625.89826673999994,88,null,{"$f":"IF($C$465=0,\"\",IF(C457=\"[for completion]\",\"\",C457/$C$465))","v":5.0314988353858718E-2},{"$f":"IF($D$465=0,\"\",IF(D457=\"[for completion]\",\"\",D457/$D$465))","v":0.12180602945963812}]
["M.7B.22.3",">40 - <=50 %",538.89159986900006,70.654777999999993,null,4.332065770468798E-2,9.7797476937865793E-2]
["M.7B.22.4",">50 - <=60 %",11274.808893469,563.80535299999997,null,0.90636435394145332,0.78039649360249619]
["M.7B.22.5",">60 - <=70 %","[For completion]","[For completion]",null,"",""]
["M.7B.22.6",">70 - <=80 %","[For completion]","[For completion]",null,"",""]
["M.7B.22.7",">80 - <=90 %","[For completion]","[For completion]",null,"",""]
["M.7B.22.8",">90 - <=100 %","[For completion]","[For completion]",null,"",""]
["M.7B.22.9",">100%","[For completion]","[For completion]",null,"",""]
["M.7B.22.10","Total",{"$f":"SUM(C457:C464)","v":12439.598760078001},{"$f":"SUM(D457:D464)","v":722.46013099999993},null,{"$f":"SUM(F457:F464)","v":1},{"$f":"SUM(G457:G464)","v":1}]
["OM.7B.22.1","o/w >100 - <=110 %",null,null,null,{"$f":"IF($C$465=0,\"\",IF(C466=\"[for completion]\",\"\",C466/$C$465))","v":0},{"$f":"IF($D$465=0,\"\",IF(D466=\"[for completion]\",\"\",D466/$D$465))","v":0}]
["OM.7B.22.2","o/w >110 - <=120 %",null,null,null,0,0]
["OM.7B.22.3","o/w >120 - <=130 %",null,null,null,0,0]
["OM.7B.22.4","o/w >130 - <=140 %",null,null,null,0,0]
["OM.7B.22.5","o/w >140 - <=150 %",null,null,null,0,0]
["OM.7B.22.6","o/w >150 %",null,null,null,0,0]
["OM.7B.22.7"]
["OM.7B.22.8"]
["OM.7B.22.9"]
[null,"23. Loan to Value (LTV) Information - INDEXED","Nominal","Number of Loans",null,"% Commercial Loans","% No. of Loans"]
["M.7B.23.1","Weighted Average LTV (%)","ND1"]
[]
[null,"By LTV buckets (mn):"]
["M.7B.23.2",">0 - <=40 %","ND1","ND1",null,{"$f":"IF($C$487=0,\"\",IF(C479=\"[Mark as ND1 if not relevant]\",\"\",C479/$C$487))","v":""},{"$f":"IF($D$487=0,\"\",IF(D479=\"[Mark as ND1 if not relevant]\",\"\",D479/$D$487))","v":""}]
["M.7B.23.3",">40 - <=50 %","ND1","ND1",null,"",""]
["M.7B.23.4",">50 - <=60 %","ND1","ND1",null,"",""]
["M.7B.23.5",">60 - <=70 %","ND1","ND1",null,"",""]
["M.7B.23.6",">70 - <=80 %","ND1","ND1",null,"",""]
["M.7B.23.7",">80 - <=90 %","ND1","ND1",null,"",""]
["M.7B.23.8",">90 - <=100 %","ND1","ND1",null,"",""]
["M.7B.23.9",">100%","ND1","ND1",null,"",""]
["M.7B.23.10","Total",{"$f":"SUM(C479:C486)","v":0},{"$f":"SUM(D479:D486)","v":0},null,{"$f":"SUM(F479:F486)","v":0},{"$f":"SUM(G479:G486)","v":0}]
["OM.7B.23.1","o/w >100 - <=110 %",null,null,null,{"$f":"IF($C$487=0,\"\",IF(C488=\"[for completion]\",\"\",C488/$C$487))","v":""},{"$f":"IF($D$487=0,\"\",IF(D488=\"[for completion]\",\"\",D488/$D$487))","v":""}]
["OM.7B.23.2","o/w >110 - <=120 %",null,null,null,"",""]
["OM.7B.23.3","o/w >120 - <=130 %",null,null,null,"",""]
["OM.7B.23.4","o/w >130 - <=140 %",null,null,null,"",""]
["OM.7B.23.5","o/w >140 - <=150 %",null,null,null,"",""]
["OM.7B.23.6","o/w >150 %",null,null,null,"",""]
["OM.7B.23.7"]
["OM.7B.23.8"]
["OM.7B.23.9"]
[null,"24. Breakdown by Type","% Commercial loans"]
["M.7B.24.1","Retail",0.28005033509999999]
["M.7B.24.2","Office",0.52806502060000005]
["M.7B.24.3","Hotel/Tourism","[For completion]"]
["M.7B.24.4","Shopping malls","[For completion]"]
["M.7B.24.5","Industry",1.38868971E-2]
["M.7B.24.6","Agriculture","[For completion]"]
["M.7B.24.7","Other commercially used",0.1779640542]
["M.7B.24.8","Hospital ","[For completion]"]
["M.7B.24.9","School ","[For completion]"]
["M.7B.24.10","other RE with a social relevant purpose","[For completion]"]
["M.7B.24.11","Land",3.3692899999999997E-5]
["M.7B.24.12","Property developers / Building under construction","[For completion]"]
["M.7B.24.13","Other","[For completion]"]
["OM.7B.24.1","o/w Cultural purposes"]
["OM.7B.24.2","o/w [If relevant, please specify]"]
["OM.7B.24.3","o/w [If relevant, please specify]"]
["OM.7B.24.4","o/w [If relevant, please specify]"]
["OM.7B.24.5","o/w [If relevant, please specify]"]
["OM.7B.24.6","o/w [If relevant, please specify]"]
["OM.7B.24.7","o/w [If relevant, please specify]"]
["OM.7B.24.8","o/w [If relevant, please specify]"]
["OM.7B.24.9","o/w [If relevant, please specify]"]
["OM.7B.24.10","o/w [If relevant, please specify]"]
["OM.7B.24.11","o/w [If relevant, please specify]"]
["OM.7B.24.12","o/w [If relevant, please specify]"]
["OM.7B.24.13","o/w [If relevant, please specify]"]
["OM.7B.24.14","o/w [If relevant, please specify]"]
[null,"25. EPC  Information of the financed CRE - optional","Nominal (mn)","Number of CRE",null,"% Commercial Loans","% No. of CRE"]
["M.7B.25.1","A+",204.3,"ND1",null,{"$f":"IF($C$544=0,\"\",IF(C526=\"[for completion]\",\"\",IF(C526=\"\",\"\",C526/$C$544)))","v":1.6423357664233581E-2}]
["M.7B.25.2","A",1288.2,"ND1",null,0.10355638444966078]
["M.7B.25.3","B",545.20000000000005,"ND1",null,4.3827775812727107E-2]
["M.7B.25.4","C",348.9,"ND1",null,2.8047525643911383E-2]
["M.7B.25.5","D",445.7,"ND1",null,3.5829126338467479E-2]
["M.7B.25.6","E",192.2,"ND1",null,1.5450657577414066E-2]
["M.7B.25.7","F",11.6,"ND1",null,9.3250586835589579E-4]
["M.7B.25.8","G",131.69999999999999,"ND1",null,1.0587157143316506E-2]
["M.7B.25.9","H",3.7,"ND1",null,2.9743721663075989E-4]
["M.7B.25.10","Assets in countries without EPC levels for CRE","[For completion]","[For completion]",null,"",{"$f":"IF($D$544=0,\"\",IF(D535=\"[for completion]\",\"\",IF(D535=\"\",\"\",D535/$D$544)))","v":""}]
["M.7B.25.11","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.25.12","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.25.13","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.25.14","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.25.15","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.25.16","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.25.17","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.25.18","no data",9268.1,"ND1",null,0.74504807228528258]
["M.7B.25.19","Total",{"$f":"SUM(C526:C543)","v":12439.599999999999},1645,null,{"$f":"SUM(F526:F543)","v":1}]
["OM.7B.25.1"]
["OM.7B.25.2"]
["OM.7B.25.3"]
[null,"26. Average energy use intensity (kWh/m2 per year) - optional","Nominal (mn)","Number of CRE",null,"% Commercial Loans","% No. of CRE"]
["M.7B.26.1","[< 95 kWh/m²] Retail","[For completion]","[For completion]",null,{"$f":"IF($C$567=0,\"\",IF(C549=\"[for completion]\",\"\",IF(C549=\"\",\"\",C549/$C$567)))","v":""},{"$f":"IF($D$567=0,\"\",IF(D549=\"[for completion]\",\"\",IF(D549=\"\",\"\",D549/$D$567)))","v":""}]
["M.7B.26.2","[< 135 kWh/m²] Office","[For completion]","[For completion]",null,"",""]
["M.7B.26.3","[< 105 kWh/m²] Hotel/Tourism","[For completion]","[For completion]",null,"",""]
["M.7B.26.4","[< 70 kWh/m²] Shopping malls","[For completion]","[For completion]",null,"",""]
["M.7B.26.5","[< 110 kWh/m²] Industry","[For completion]","[For completion]",null,"",""]
["M.7B.26.6","[< 110 kWh/m²] Agriculture","[For completion]","[For completion]",null,"",""]
["M.7B.26.7","[< 95 kWh/m²] Other commercially used","[For completion]","[For completion]",null,"",""]
["M.7B.26.8","[< 250 kWh/m²] Hospital","[For completion]","[For completion]",null,"",""]
["M.7B.26.9","[< 105 kWh/m²] School","[For completion]","[For completion]",null,"",""]
["M.7B.26.10","[< 135 kWh/m²] other RE with a social relevant purpose","[For completion]","[For completion]",null,"",""]
["M.7B.26.11","[< 110 kWh/m²] Land","[For completion]","[For completion]",null,"",""]
["M.7B.26.12","[< 110 kWh/m²] Property developers / Bulding under construction","[For completion]","[For completion]",null,"",""]
["M.7B.26.13","Top category sustainability certificate","[For completion]","[For completion]",null,"",""]
["M.7B.26.14","Top 15 % approach","[For completion]","[For completion]",null,"",""]
["M.7B.26.15","Other","[For completion]","[For completion]",null,"",""]
["M.7B.26.16","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.26.17","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.26.18","no data","[For completion]","[For completion]",null,"",""]
["M.7B.26.19","Total",{"$f":"SUM(C549:C566)","v":0},{"$f":"SUM(D549:D566)","v":0},null,{"$f":"SUM(F549:F566)","v":0},{"$f":"SUM(G549:G566)","v":0}]
["OM.7B.26.1"]
["OM.7B.26.2"]
["OM.7B.26.3"]
[null,"27. CRE Age Structure - optional","Nominal (mn)","Number of CRE",null,"% Commercial Loans","% No. of CRE"]
["M.7B.27.1","older than 1919",1303.3526863970001,121,null,{"$f":"IF($C$585=0,\"\",IF(C572=\"[for completion]\",\"\",IF(C572=\"\",\"\",C572/$C$585)))","v":0.10477449566781141},{"$f":"IF($D$585=0,\"\",IF(D572=\"[for completion]\",\"\",IF(D572=\"\",\"\",D572/$D$585)))","v":7.3556231003039513E-2}]
["M.7B.27.2","1919 - 1945",426.73197592499997,42,null,3.4304319950779386E-2,2.553191489361702E-2]
["M.7B.27.3","1946 - 1960",469.02803896699999,60,null,3.7704434685809488E-2,3.64741641337386E-2]
["M.7B.27.4","1961 - 1970",607.48275047100003,71,null,4.883459363823079E-2,4.3161094224924014E-2]
["M.7B.27.5","1971 - 1980",759.47037429900001,98,null,6.1052642367887662E-2,5.9574468085106386E-2]
["M.7B.27.6","1981 - 1990",447.46374786199999,100,null,3.5970914857645309E-2,6.0790273556231005E-2]
["M.7B.27.7","1991 - 2000",1818.298571738,307,null,0.14617019461862005,0.18662613981762918]
["M.7B.27.8","2001 - 2005",1483.1762490159999,218,null,0.11923023223032146,0.1325227963525836]
["M.7B.27.9","2006 - 2010",1155.1392264850001,300,null,9.2859846106310401E-2,0.18237082066869301]
["M.7B.27.10","2011 - 2015",1279.806839482,108,null,0.10288168164951952,6.5653495440729487E-2]
["M.7B.27.11","2016 - 2020",1616.1727596789999,144,null,0.12992161490496465,8.753799392097264E-2]
["M.7B.27.12","2021 and onwards",1073.056413476,74,null,8.6261336412217018E-2,4.4984802431610946E-2]
["M.7B.27.13","no data",0.41912628000000002,2,null,3.3692909882682228E-5,1.2158054711246201E-3]
["M.7B.27.14","Total",{"$f":"SUM(C572:C584)","v":12439.598760077002},{"$f":"SUM(D572:D584)","v":1645},null,{"$f":"SUM(F572:F584)","v":0.99999999999999978},{"$f":"SUM(G572:G584)","v":1}]
["OM.7B.27.1"]
["OM.7B.27.2"]
["OM.7B.27.3"]
["OM.7B.27.4"]
["OM.7B.27.5"]
["OM.7B.27.6",{"$nulls":4},{"$f":"IF($C$585=0,\"\",IF(C591=\"[for completion]\",\"\",IF(C591=\"\",\"\",C591/$C$585)))","v":""},{"$f":"IF($D$585=0,\"\",IF(D591=\"[for completion]\",\"\",IF(D591=\"\",\"\",D591/$D$585)))","v":""}]
["OM.7B.27.7"]
["OM.7B.27.8"]
["OM.7B.27.9"]
["OM.7B.27.10"]
[null,"28. New Commercial Property - optional","Nominal (mn)","Number of CRE",null,"% Residential Loans","% No. of CRE"]
["M.7B.28.1","New Property","[For completion]","[For completion]",null,{"$f":"IF($C$601=0,\"\",IF(C597=\"[for completion]\",\"\",IF(C597=\"\",\"\",C597/$C$601)))","v":""},{"$f":"IF($D$601=0,\"\",IF(D597=\"[for completion]\",\"\",IF(D597=\"\",\"\",D597/$D$601)))","v":""}]
["M.7B.28.2","Existing Property","[For completion]","[For completion]",null,{"$f":"IF($C$601=0,\"\",IF(C598=\"[for completion]\",\"\",IF(C598=\"\",\"\",C598/$C$601)))","v":""},{"$f":"IF($D$601=0,\"\",IF(D598=\"[for completion]\",\"\",IF(D598=\"\",\"\",D598/$D$601)))","v":""}]
["M.7B.28.3","other","[For completion]","[For completion]",null,{"$f":"IF($C$601=0,\"\",IF(C599=\"[for completion]\",\"\",IF(C599=\"\",\"\",C599/$C$601)))","v":""},{"$f":"IF($D$601=0,\"\",IF(D599=\"[for completion]\",\"\",IF(D599=\"\",\"\",D599/$D$601)))","v":""}]
["M.7B.28.4","no data",12439.598760078001,1645,null,{"$f":"IF($C$601=0,\"\",IF(C600=\"[for completion]\",\"\",IF(C600=\"\",\"\",C600/$C$601)))","v":1},{"$f":"IF($D$601=0,\"\",IF(D600=\"[for completion]\",\"\",IF(D600=\"\",\"\",D600/$D$601)))","v":1}]
["M.7B.28.5","Total",{"$f":"SUM(C597:C600)","v":12439.598760078001},1645,null,{"$f":"SUM(F597:F600)","v":1},{"$f":"SUM(G597:G600)","v":1}]
[]
[null,"29. CO2 emission related to CRE - as per national availability","Ton CO2 (per year)","Ton CO2 (LTV adjusted) (per year)",null,"kg CO2/m2 (per year)","% No. of Dwellings with no CO2 data"]
["M.7B.29.1","Retail","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7B.29.2","Office","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7B.29.3","Hotel/Tourism","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7B.29.4","Shopping malls","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7B.29.5","Industry","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7B.29.6","Agriculture","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7B.29.7","Other commercially used","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7B.29.8","Hospital","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7B.29.9","School","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7B.29.10","Other RE with a social relevant purpose","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7B.29.11","Land","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7B.29.12","Property developers / Bulding under construction","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7B.29.13","Other","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["M.7B.29.14","Total",{"$f":"SUM(C604:C616)","v":0},{"$f":"SUM(D604:D616)","v":0},null,null,{"$f":"IF($D$393=0,\"\",IF(#REF!=\"[For completion]\",\"\",#REF!/$D$393))","v":""}]
["M.7B.29.15","Weighted Average",null,null,null,"[For completion]",{"$f":"IF($D$622=0,\"\",IF(D617=\"[for completion]\",\"\",IF(D617=\"\",\"\",D617/$D$622)))","v":""}]
["M.7B.29.16",{"$nulls":5},{"$f":"IF($D$622=0,\"\",IF(D618=\"[for completion]\",\"\",IF(D618=\"\",\"\",D618/$D$622)))","v":""}]
["M.7B.29.17",{"$nulls":5},{"$f":"IF($D$622=0,\"\",IF(D620=\"[for completion]\",\"\",IF(D620=\"\",\"\",D620/$D$622)))","v":""}]
["M.7B.29.18",{"$nulls":5},{"$f":"IF($D$622=0,\"\",IF(D621=\"[for completion]\",\"\",IF(D621=\"\",\"\",D621/$D$622)))","v":""}]
["M.7B.29.19",{"$nulls":5},{"$f":"IF($D$622=0,\"\",IF(D622=\"[for completion]\",\"\",IF(D622=\"\",\"\",D622/$D$622)))","v":""}]

{"sheet":"B2. HTT Public Sector Assets","index":6,"n_rows":179,"n_cols":7,"rows_kept":179,"cut":false,"hidden":true,"merged":[]}
["B2. Harmonised Transparency Template - Public Sector Assets",{"$nulls":4},"HTT 2025"]
[]
[null,"Reporting in Domestic Currency","[Please insert currency]"]
[]
[null,"CONTENT OF TAB B2"]
[null,"8. Public Sector Assets"]
[]
["Field Number","8. Public Sector Assets"]
[null,"1. General Information"]
["PS.8.1.1","Number of public sector exposures","[For completion]"]
["OPS.8.1.1","Optional information eg, Number of borrowers"]
["OPS.8.1.2","Optional information eg, Number of guarantors"]
["OPS.8.1.3"]
["OPS.8.1.4"]
["OPS.8.1.5"]
["OPS.8.1.6"]
["OPS.8.1.7"]
[null,"2. Size Information","Nominal","Number of Exposures",null,"% Public Sector Assets","% No. of Exposures"]
["PS.8.2.1","Average exposure size (000s)","[For completion]"]
[]
[null,"By buckets (mn):"]
["PS.8.2.2","TBC at a country level","[For completion]","[For completion]",null,{"$f":"IF($C$37=0,\"\",IF(C22=\"[for completion]\",\"\",C22/$C$37))","v":""},{"$f":"IF($D$37=0,\"\",IF(D22=\"[for completion]\",\"\",D22/$D$37))","v":""}]
["PS.8.2.3","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.4","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.5","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.6","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.7","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.8","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.9","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.10","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.11","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.12","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.13","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.14","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.15","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.16","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.17","Total",{"$f":"SUM(C22:C36)","v":0},{"$f":"SUM(D22:D36)","v":0},null,{"$f":"SUM(F22:F36)","v":0},{"$f":"SUM(G22:G36)","v":0}]
[null,"3. Breakdown by Asset Type","Nominal (mn)",null,null,"% Public Sector Assets"]
["PS.8.3.1","Loans","[For completion]",null,null,{"$f":"IF($C$42=0,\"\",IF(C39=\"[for completion]\",\"\",C39/$C$42))","v":""}]
["PS.8.3.2","Bonds","[For completion]",null,null,{"$f":"IF($C$42=0,\"\",IF(C40=\"[for completion]\",\"\",C40/$C$42))","v":""}]
["PS.8.3.3","Other","[For completion]",null,null,{"$f":"IF($C$42=0,\"\",IF(C41=\"[for completion]\",\"\",C41/$C$42))","v":""}]
["PS.8.3.4","Total",{"$f":"SUM(C39:C41)","v":0},null,null,{"$f":"SUM(F39:F41)","v":0}]
["OPS.8.3.1"]
["OPS.8.3.2"]
["OPS.8.3.3"]
["OPS.8.3.4"]
["OPS.8.3.5"]
[null,"4. Breakdown by Geography ","% Public Sector Assets"]
["PS.8.4.1","European Union",{"$f":"SUM(C50:C76)","v":0}]
["PS.8.4.2","Austria","[For completion]"]
["PS.8.4.3","Belgium","[For completion]"]
["PS.8.4.4","Bulgaria","[For completion]"]
["PS.8.4.5","Croatia","[For completion]"]
["PS.8.4.6","Cyprus","[For completion]"]
["PS.8.4.7","Czechia","[For completion]"]
["PS.8.4.8","Denmark","[For completion]"]
["PS.8.4.9","Estonia","[For completion]"]
["PS.8.4.10","Finland","[For completion]"]
["PS.8.4.11","France","[For completion]"]
["PS.8.4.12","Germany","[For completion]"]
["PS.8.4.13","Greece","[For completion]"]
["PS.8.4.14","Netherlands","[For completion]"]
["PS.8.4.15","Hungary","[For completion]"]
["PS.8.4.16","Ireland","[For completion]"]
["PS.8.4.17","Italy","[For completion]"]
["PS.8.4.18","Latvia","[For completion]"]
["PS.8.4.19","Lithuania","[For completion]"]
["PS.8.4.20","Luxembourg","[For completion]"]
["PS.8.4.21","Malta","[For completion]"]
["PS.8.4.22","Poland","[For completion]"]
["PS.8.4.23","Portugal","[For completion]"]
["PS.8.4.24","Romania","[For completion]"]
["PS.8.4.25","Slovakia","[For completion]"]
["PS.8.4.26","Slovenia","[For completion]"]
["PS.8.4.27","Spain","[For completion]"]
["PS.8.4.28","Sweden","[For completion]"]
["PS.8.4.29","European Economic Area (not member of EU)",{"$f":"SUM(C78:C80)","v":0}]
["PS.8.4.30","Iceland","[For completion]"]
["PS.8.4.31","Liechtenstein","[For completion]"]
["PS.8.4.32","Norway","[For completion]"]
["PS.8.4.33","Other",{"$f":"SUM(C82:C92)","v":0}]
["PS.8.4.34","Switzerland","[For completion]"]
["PS.8.4.35","United Kingdom","[For completion]"]
["PS.8.4.36","Australia","[For completion]"]
["PS.8.4.37","Brazil","[For completion]"]
["PS.8.4.38","Canada","[For completion]"]
["PS.8.4.39","Japan","[For completion]"]
["PS.8.4.40","Korea","[For completion]"]
["PS.8.4.41","New Zealand","[For completion]"]
["PS.8.4.42","Singapore","[For completion]"]
["PS.8.4.43","US","[For completion]"]
["PS.8.4.44","Other","[For completion]"]
["OPS.8.4.1","o/w [If relevant, please specify]"]
["OPS.8.4.2","o/w [If relevant, please specify]"]
["OPS.8.4.3","o/w [If relevant, please specify]"]
["OPS.8.4.4","o/w [If relevant, please specify]"]
["OPS.8.4.5","o/w [If relevant, please specify]"]
["OPS.8.4.6","o/w [If relevant, please specify]"]
["OPS.8.4.7","o/w [If relevant, please specify]"]
["OPS.8.4.8","o/w [If relevant, please specify]"]
["OPS.8.4.9","o/w [If relevant, please specify]"]
["OPS.8.4.10","o/w [If relevant, please specify]"]
[null,"5. Breakdown by regions of main country of origin","% Public Sector Assets"]
["PS.8.5.1","TBC at a country level","[For completion]"]
["PS.8.5.2","TBC at a country level","[For completion]"]
["PS.8.5.3","TBC at a country level","[For completion]"]
["PS.8.5.4","TBC at a country level","[For completion]"]
["PS.8.5.5","TBC at a country level","[For completion]"]
["PS.8.5.6","TBC at a country level","[For completion]"]
["PS.8.5.7","TBC at a country level","[For completion]"]
["PS.8.5.8","TBC at a country level","[For completion]"]
["PS.8.5.9","TBC at a country level","[For completion]"]
["PS.8.5.10","TBC at a country level","[For completion]"]
["PS.8.5.11","TBC at a country level","[For completion]"]
["PS.8.5.12","TBC at a country level","[For completion]"]
["PS.8.5.13","TBC at a country level","[For completion]"]
["PS.8.5.14","TBC at a country level","[For completion]"]
["PS.8.5.15","TBC at a country level","[For completion]"]
["PS.8.5.16","TBC at a country level","[For completion]"]
["PS.8.5.17","TBC at a country level","[For completion]"]
["PS.8.5.18","TBC at a country level","[For completion]"]
["PS.8.5.19","TBC at a country level","[For completion]"]
["PS.8.5.20","TBC at a country level","[For completion]"]
["PS.8.5.21","TBC at a country level","[For completion]"]
["PS.8.5.22","TBC at a country level","[For completion]"]
["PS.8.5.23","TBC at a country level","[For completion]"]
["PS.8.5.24","TBC at a country level","[For completion]"]
["PS.8.5.25","TBC at a country level","[For completion]"]
[null,"6. Breakdown by Interest Rate","% Public Sector Assets"]
["PS.8.6.1","Fixed rate","[For completion]"]
["PS.8.6.2","Floating rate","[For completion]"]
["PS.8.6.3","Other","[For completion]"]
["OPS.8.6.1"]
["OPS.8.6.2"]
["OPS.8.6.3"]
["OPS.8.6.4"]
[null,"7. Breakdown by Repayment Type","% Public Sector Assets"]
["PS.8.7.1","Bullet / interest only","[For completion]"]
["PS.8.7.2","Amortising","[For completion]"]
["PS.8.7.3","Other","[For completion]"]
["OPS.8.7.1"]
["OPS.8.7.2"]
["OPS.8.7.3"]
["OPS.8.7.4"]
["OPS.8.7.5"]
["OPS.8.7.6"]
[null,"8. Breakdown by Type of Debtor","Nominal (mn)",null,null,"% Public Sector Assets"]
["PS.8.8.1","Sovereigns","[For completion]",null,null,{"$f":"IF($C$152=0,\"\",IF(C148=\"[for completion]\",\"\",C148/$C$152))","v":""}]
["PS.8.8.2","Regional/federal authorities","[For completion]",null,null,{"$f":"IF($C$152=0,\"\",IF(C149=\"[for completion]\",\"\",C149/$C$152))","v":""}]
["PS.8.8.3","Local/municipal authorities ","[For completion]",null,null,{"$f":"IF($C$152=0,\"\",IF(C150=\"[for completion]\",\"\",C150/$C$152))","v":""}]
["PS.8.8.4","Others","[For completion]",null,null,{"$f":"IF($C$152=0,\"\",IF(C151=\"[for completion]\",\"\",C151/$C$152))","v":""}]
["PS.8.8.5","Total",{"$f":"SUM(C148:C151)","v":0},null,null,{"$f":"SUM(F148:F151)","v":0}]
["OPS.8.8.1","o/w Claim against supranational",null,null,null,{"$f":"IF($C$152=0,\"\",IF(C153=\"[for completion]\",\"\",C153/$C$152))","v":""}]
["OPS.8.8.2","o/w Claim against sovereigns",null,null,null,""]
["OPS.8.8.3","o/w Claim guaranteed by sovereigns",null,null,null,""]
["OPS.8.8.4","o/w Claim against regional/federal authorities",null,null,null,""]
["OPS.8.8.5","o/w Claim guaranteed by regional/federal authorities",null,null,null,""]
["OPS.8.8.6","o/w Claim against local/municipal authorities ",null,null,null,""]
["OPS.8.8.7","o/w Claimguaranteed by local/municipal authorities ",null,null,null,""]
["OPS.8.8.8"]
["OPS.8.8.9"]
["OPS.8.8.10"]
["OPS.8.8.11"]
["OPS.8.8.12"]
["OPS.8.8.13"]
[null,"9. Non-Performing Loans","% Public Sector Assets"]
["PS.8.9.1","% NPLs","[For completion]"]
["OPS.8.9.1","Defaulted Loans pursuant Art 178 CRR","[For completion]"]
["OPS.8.9.2"]
["OPS.8.9.3"]
["OPS.8.9.4"]
[null,"10. Concentration Risks","% Public Sector Assets"]
["PS.8.10.1","10 largest exposures","[For completion]"]
["OPS.8.10.1"]
["OPS.8.10.2"]
["OPS.8.10.3"]
["OPS.8.10.4"]
["OPS.8.10.5"]
["OPS.8.10.6"]

{"sheet":"B3. HTT Shipping Assets","index":7,"n_rows":257,"n_cols":7,"rows_kept":257,"cut":false,"hidden":true,"merged":[]}
["B3. Harmonised Transparency Template - Shipping Assets",{"$nulls":4},"HTT 2025"]
[]
[null,"Reporting in Domestic Currency","[Please insert currency]"]
[]
[null,"CONTENT OF TAB B3"]
[null,"9. Shipping Assets"]
[]
["Field Number","9. Shipping Assets"]
[null,"1. General Information","Shipping Loans"]
["S.9.1.1","Number of shipping loans","[For completion]"]
["OS.9.1.1","Optional information eg, Number of borrowers"]
["OS.9.1.2","Optional information eg, Number of guarantors"]
["OS.9.1.3"]
["OS.9.1.4"]
["OS.9.1.5"]
["OS.9.1.6"]
[null,"2. Concentration Risks","% Shipping Loans"]
["S.9.2.1","10 largest exposures ","[For completion]"]
["OS.9.2.1"]
["OS.9.2.2"]
["OS.9.2.3"]
["OS.9.2.4"]
["OS.9.2.5"]
["OS.9.2.6"]
[null,"3. Breakdown by Geography / Country of Registration ","% Shipping Loans"]
["S.9.3.1","European Union",{"$f":"SUM(C27:C53)","v":0}]
["S.9.3.2","Austria","[For completion]"]
["S.9.3.3","Belgium","[For completion]"]
["S.9.3.4","Bulgaria","[For completion]"]
["S.9.3.5","Croatia","[For completion]"]
["S.9.3.6","Cyprus","[For completion]"]
["S.9.3.7","Czechia","[For completion]"]
["S.9.3.8","Denmark","[For completion]"]
["S.9.3.9","Estonia","[For completion]"]
["S.9.3.10","Finland","[For completion]"]
["S.9.3.11","France","[For completion]"]
["S.9.3.12","Germany","[For completion]"]
["S.9.3.13","Greece","[For completion]"]
["S.9.3.14","Netherlands","[For completion]"]
["S.9.3.15","Hungary","[For completion]"]
["S.9.3.16","Ireland","[For completion]"]
["S.9.3.17","Italy","[For completion]"]
["S.9.3.18","Latvia","[For completion]"]
["S.9.3.19","Lithuania","[For completion]"]
["S.9.3.20","Luxembourg","[For completion]"]
["S.9.3.21","Malta","[For completion]"]
["S.9.3.22","Poland","[For completion]"]
["S.9.3.23","Portugal","[For completion]"]
["S.9.3.24","Romania","[For completion]"]
["S.9.3.25","Slovakia","[For completion]"]
["S.9.3.26","Slovenia","[For completion]"]
["S.9.3.27","Spain","[For completion]"]
["S.9.3.28","Sweden","[For completion]"]
["S.9.3.29","European Economic Area (not member of EU)",{"$f":"SUM(C55:C57)","v":0}]
["S.9.3.30","Iceland","[For completion]"]
["S.9.3.31","Liechtenstein","[For completion]"]
["S.9.3.32","Norway","[For completion]"]
["S.9.3.33","Other",{"$f":"SUM(C59:C69)","v":0}]
["S.9.3.34","Switzerland","[For completion]"]
["S.9.3.35","United Kingdom","[For completion]"]
["S.9.3.36","Australia","[For completion]"]
["S.9.3.37","Brazil","[For completion]"]
["S.9.3.38","Canada","[For completion]"]
["S.9.3.39","Japan","[For completion]"]
["S.9.3.40","Korea","[For completion]"]
["S.9.3.41","New Zealand","[For completion]"]
["S.9.3.42","Singapore","[For completion]"]
["S.9.3.43","US","[For completion]"]
["S.9.3.44","Other","[For completion]"]
["OS.9.3.1","o/w [If relevant, please specify]"]
["OS.9.3.2","o/w [If relevant, please specify]"]
["OS.9.3.3","o/w [If relevant, please specify]"]
["OS.9.3.4","o/w [If relevant, please specify]"]
["OS.9.3.5","o/w [If relevant, please specify]"]
["OS.9.3.6","o/w [If relevant, please specify]"]
["OS.9.3.7","o/w [If relevant, please specify]"]
["OS.9.3.8","o/w [If relevant, please specify]"]
["OS.9.3.9","o/w [If relevant, please specify]"]
["OS.9.3.10","o/w [If relevant, please specify]"]
[null,"4. Breakdown by Interest Rate","% Shipping Loans"]
["S.9.4.1","Fixed rate","[For completion]"]
["S.9.4.2","Floating rate","[For completion]"]
["S.9.4.3","Other","[For completion]"]
["OS.9.4.1"]
["OS.9.4.2"]
["OS.9.4.3"]
["OS.9.4.4"]
["OS.9.4.5"]
["OS.9.4.6"]
[null,"5. Breakdown by Repayment Type","% Shipping Loans"]
["S.9.5.1","Bullet / interest only","[For completion]"]
["S.9.5.2","Amortising","[For completion]"]
["S.9.5.3","Other","[For completion]"]
["OS.9.5.1"]
["OS.9.5.2"]
["OS.9.5.3"]
["OS.9.5.4"]
["OS.9.5.5"]
["OS.9.5.6"]
[null,"6. Loan Seasoning ","% Shipping Loans"]
["S.9.6.1","Up to 12months","[For completion]"]
["S.9.6.2",">  12 - ≤ 24 months","[For completion]"]
["S.9.6.3","> 24 - ≤ 36 months","[For completion]"]
["S.9.6.4","> 36 - ≤ 60 months","[For completion]"]
["S.9.6.5","> 60 months","[For completion]"]
["OS.9.6.1"]
["OS.9.6.2"]
["OS.9.6.3"]
["OS.9.6.4"]
[null,"7. Non-Performing Loans (NPLs)","% Shipping Loans"]
["S.9.7.1","% NPLs","[For completion]"]
["OS.9.7.1","Defaulted Loans pursuant Art 178 CRR","[For completion]"]
["OS.9.7.2"]
["OS.9.7.3"]
["OS.9.7.4"]
[null,"8. Loan Size Information","Nominal","Number of Loans",null,"% Shipping Loans","% No. of Loans"]
["S.9.8.1","Average loan size (000s)","[For completion]"]
[]
[null,"By buckets (mn):"]
["S.9.8.2","TBC at a country level","[For completion]","[For completion]",null,{"$f":"IF($C$144=0,\"\",IF(C120=\"[for completion]\",\"\",C120/$C$144))","v":""},{"$f":"IF($D$144=0,\"\",IF(D120=\"[for completion]\",\"\",D120/$D$144))","v":""}]
["S.9.8.3","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.4","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.5","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.6","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.7","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.8","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.9","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.10","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.11","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.12","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.13","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.14","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.15","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.16","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.17","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.18","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.19","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.20","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.21","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.22","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.23","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.24","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.25","TBC at a country level","[For completion]","[For completion]",null,"",""]
["S.9.8.26","Total",{"$f":"SUM(C120:C143)","v":0},{"$f":"SUM(D120:D143)","v":0},null,{"$f":"SUM(F120:F143)","v":0},{"$f":"SUM(G120:G143)","v":0}]
[null,"9. Loan to Value (LTV) Information - UNINDEXED","Nominal","Number of Loans",null,"% Shipping Loans","% No. of Loans"]
["S.9.9.1","Weighted Average LTV (%)","[For completion]"]
[]
[null,"By LTV buckets (mn):"]
["S.9.9.2",">0 - <=40 %","[For completion]","[For completion]",null,{"$f":"IF($C$157=0,\"\",IF(C149=\"[for completion]\",\"\",C149/$C$157))","v":""},{"$f":"IF($D$157=0,\"\",IF(D149=\"[for completion]\",\"\",D149/$D$157))","v":""}]
["S.9.9.3",">40 - <=50 %","[For completion]","[For completion]",null,"",""]
["S.9.9.4",">50 - <=60 %","[For completion]","[For completion]",null,"",""]
["S.9.9.5",">60 - <=70 %","[For completion]","[For completion]",null,"",""]
["S.9.9.6",">70 - <=80 %","[For completion]","[For completion]",null,"",""]
["S.9.9.7",">80 - <=90 %","[For completion]","[For completion]",null,"",""]
["S.9.9.8",">90 - <=100 %","[For completion]","[For completion]",null,"",""]
["S.9.9.9",">100%","[For completion]","[For completion]",null,"",""]
["S.9.9.10","Total",{"$f":"SUM(C149:C156)","v":0},{"$f":"SUM(D149:D156)","v":0},null,{"$f":"SUM(F149:F156)","v":0},{"$f":"SUM(G149:G156)","v":0}]
["OS.9.9.1","o/w >100 - <=110 %",null,null,null,{"$f":"IF($C$157=0,\"\",IF(C158=\"[for completion]\",\"\",C158/$C$157))","v":""},{"$f":"IF($D$157=0,\"\",IF(D158=\"[for completion]\",\"\",D158/$D$157))","v":""}]
["OS.9.9.2","o/w >110 - <=120 %",null,null,null,"",""]
["OS.9.9.3","o/w >120 - <=130 %",null,null,null,"",""]
["OS.9.9.4","o/w >130 - <=140 %",null,null,null,"",""]
["OS.9.9.5","o/w >140 - <=150 %",null,null,null,"",""]
["OS.9.9.6","o/w >150 %",null,null,null,"",""]
["OS.9.9.7"]
["OS.9.9.8"]
["OS.9.9.9"]
[null,"10. Loan to Value (LTV) Information - INDEXED ","Nominal","Number of Loans",null,"% Shipping Loans","% No. of Loans"]
["S.9.10.1","Weighted Average LTV (%)","[Mark as ND1 if not relevant]"]
[]
[null,"By LTV buckets (mn):"]
["S.9.10.2",">0 - <=40 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,{"$f":"IF($C$179=0,\"\",IF(C171=\"[Mark as ND1 if not relevant]\",\"\",C171/$C$179))","v":""},{"$f":"IF($D$179=0,\"\",IF(D171=\"[Mark as ND1 if not relevant]\",\"\",D171/$D$179))","v":""}]
["S.9.10.3",">40 - <=50 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["S.9.10.4",">50 - <=60 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["S.9.10.5",">60 - <=70 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["S.9.10.6",">70 - <=80 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["S.9.10.7",">80 - <=90 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["S.9.10.8",">90 - <=100 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["S.9.10.9",">100%","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["S.9.10.10","Total",{"$f":"SUM(C171:C178)","v":0},{"$f":"SUM(D171:D178)","v":0},null,{"$f":"SUM(F171:F178)","v":0},{"$f":"SUM(G171:G178)","v":0}]
["OS.9.10.1","o/w >100 - <=110 %",null,null,null,{"$f":"IF($C$179=0,\"\",IF(C180=\"[for completion]\",\"\",C180/$C$179))","v":""},{"$f":"IF($D$179=0,\"\",IF(D180=\"[for completion]\",\"\",D180/$D$179))","v":""}]
["OS.9.10.2","o/w >110 - <=120 %",null,null,null,"",""]
["OS.9.10.3","o/w >120 - <=130 %",null,null,null,"",""]
["OS.9.10.4","o/w >130 - <=140 %",null,null,null,"",""]
["OS.9.10.5","o/w >140 - <=150 %",null,null,null,"",""]
["OS.9.10.6","o/w >150 %",null,null,null,"",""]
["OS.9.10.7"]
["OS.9.10.8"]
["OS.9.10.9"]
[null,"11. Breakdown by type of ship","% Shipping Loans","C02/ton/mi"]
["S.9.11.1","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.2","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.3","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.4","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.5","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.6","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.7","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.8","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.9","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.10","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.11","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.12","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.13","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.14","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.15","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.16","TBC at a country level","[For completion]","[For completion]"]
["S.9.11.17","TBC at a country level","[For completion]","[For completion]"]
["OS.9.11.1"]
["OS.9.11.2"]
["OS.9.11.3"]
["OS.9.11.4"]
["OS.9.11.5"]
[null,"12. Breakdown by size of ship","% Shipping Loans","C02/ton/mi"]
["S.9.12.1","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.2","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.3","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.4","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.5","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.6","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.7","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.8","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.9","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.10","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.11","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.12","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.13","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.14","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.15","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.16","TBC at a country level","[For completion]","[For completion]"]
["S.9.12.17","TBC at a country level","[For completion]","[For completion]"]
["OS.9.12.1"]
["OS.9.12.2"]
["OS.9.12.3"]
["OS.9.12.4"]
["OS.9.12.5"]
[null,"13. Breakdown by age of ship","% Shipping Loans","C02/ton/mi"]
["S.9.13.1","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.2","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.3","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.4","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.5","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.6","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.7","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.8","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.9","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.10","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.11","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.12","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.13","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.14","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.15","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.16","TBC at a country level","[For completion]","[For completion]"]
["S.9.13.17","TBC at a country level","[For completion]","[For completion]"]
["OS.9.13.1"]
["OS.9.13.2"]
["OS.9.13.3"]
["OS.9.13.4"]
["OS.9.13.5"]

{"sheet":"erweitertes vdp-Template","index":8,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[11,3,11,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[2,3,2,5],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[8,3,8,5]]}
["Hypothekenpfandbriefe","Q 1 2025"]
["Deckungsmasse (nom.)","(Mio. €)",20003.648150969999,"Umlaufende Pfandbriefe (nom).",null,null,"(Mio. €)",19064.197084089999]
["WAL der Deckungsmasse (Total)","Jahre",3.6,"WAL der ausstehenden Pfandbriefe (Total)",null,null,"Jahre",4.8]
["Anteil von \"insured mortgages\"","%",100,"Besteht die Möglichkeit einer Fälligkeitsverschiebung?",null,null,"Ja/Nein","Ja"]
["Sind Versicherungen Bestandteil der Deckungsmasse?",null,"Ja","Maximal mögliche Verschiebung?",null,null,"Monate",12]
["Sind garantierte Kredite in Deckungsmasse enthalten?","Ja/Nein","Nicht anwendbar*","Ist Fälligkeitsverschiebung gesetzlich geregelt?",null,null,"Ja/Nein","Ja"]
["Anteil garantierter Kredite ","%","Nicht anwendbar*","Sind Pass through Strukturen enthalten?",null,null,"Ja/Nein","Nicht anwendbar*"]
["Gesetzliche Überdeckung (nennwertig + barwertig nach Stressszenarien)","%","2 % + 2 %"]
["Sind \"self certified loans\" Bestandteil der Deckungsmasse?","Ja/Nein","Nicht anwendbar*","Gesamtkreditbetrag der 10 größten Kreditnehmer",null,null,"(Mio. €)",3471.13454968]
["Sind \"limited certified loans\" Bestandteil der Deckungsmasse?","Ja/Nein","Nicht anwendbar*"]
["Anteil von \"non first lien mortgages\" ","% ","Nicht anwendbar*",null,null," ","Residential","Commercial"]
["Sind ABS Bestandteil der Deckungsmasse?","Ja/Nein","Nicht anwendbar*","Anzahl der Kreditnehmer",null,null,510,668]
["\"interest only loans\"","(Mio. €)",11792.05166884,"Anzahl der Kredite ",null,null,582,722]
["Notenbankfähige Wertpapiere","(Mio. €) ",1320.3,"Anzahl der Objekte",null,null,2770,1645]
["Aufteilung der Forderungen gegenüber Zentralbanken und Kreditinstituten i.S. d. § 28 Abs. 1 Nr. 8 nach Bonitätsstufe",null,null,"Selbstgenutzte Wohnungen in der Deckungsmasse (Mio. €)",null,null,3.2490751389999999]
["Bonitätsstufe 1","(Mio. €)",605.29999999999995,"Mehrfamilienhäuser in der Deckungsmasse (Mio. €)",null,null,5941.6327704770001]
["Bonitätsstufe 2","(Mio. €)",450,null,null,null," "]
["Sind Derivate in Deckung?","Y/N",{"$f":"IF(C20<>0,\"Y\",\"N\")","v":"N"}]
["Typ der Swap-Kontrahenten (extern oder keine)?","E/N"]
["Nettobarwert der Derivate in Deckung","(Mio. €)"]
["Währungspositionen (nominal)","(Mio. €)","Pfandbriefe","Deckungsmasse"]
["EUR",null,18854.355514480001,20003.64815107]
["AUD"]
["CAD"]
["CHF",null,209.841569615]
["CZK"]
["DKK"]
["GBP"]
["HKD",{"$nulls":5}," "]
["JPY"]
["NOK"]
["SEK"]
["USD"]
["Ratingagentur",null,"Fitch","Moody´s","S&P","DBRS","Scope"]
["Aktuelles Pfandbriefrating  ",null,"Unbekannt","Aaa","Unbekannt"]
["Deckungsmasse nach Beleihungsauslauf in Bandbreiten ",null,"0- ≤20"," >20- ≤30",">30- ≤40",">40- ≤50",">50- ≤60"]
[null,"(Mio. €)",37.540409279999999,157.58060180999999,586.65161051000007,809.15969414999995,16992.41583532]
["Deckungsmasse nach Alter\nder Kredite in Bandbreiten -seasoning- residential+commercial",null," ≤12 Monate",">12 - ≤24 Monate",">24 - ≤36 Monate"," >36 - ≤60 Monate",">60 - ≤120 Monate","> 120 Monate"]
[null,"(Mio. €)",1615.21492223,2069.5777064700001,2165.8517612599999,4583.7249271700002,7265.03608626,883.94274768000002]
[]
["nicht anwendbar*= Für deutsche Pfandbriefe nicht anwendbar bzw. nicht im Pfandbriefgesetz vorgesehen"]

{"sheet":"extended vdp-Template","index":9,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[11,3,11,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[2,3,2,5],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[8,3,8,5]]}
["Mortgage Pfandbriefe","Q 1 2025"]
["Cover pool (nom.)","(mn. €)",20003.648150969999,"Pfandbriefe outstanding (nom).",null,null,"(mn. €)",19064.197084089999]
["Weighted Average Life (WAL) of cover pool (Total)","Years",3.6,"WAL of outstanding Pfandbriefe (Total)",null,null,"Years",4.8]
["Share of \"insured mortgages\"","%",100,"Is there a possibility of maturity extension?",null,null,"Yes/No","Yes"]
["Are insurances part of the cover pool register?",null,"Yes","Maximum potential maturity extension period?",null,null,"Months",12]
["Are guaranteed loans included in the cover pool?","Yes/No","Not applicable*","Is maturity extension regulated by law?",null,null,"Yes/No","Yes"]
["Share of guaranteed loans","%","Not applicable*","Are pass-through structures included?",null,null,"Yes/No","Not applicable*"]
["Legal overcollateralisation (nominal + npv based on stress scenarios)","%","2 % + 2 %"]
["Are self certified loans part of the cover pool?","Yes/No","Not applicable*","Total amount lent to 10 lagest borrowers",null,null,"(mn. €)",3471.13454968]
["Are limited certified loans part of the cover pool?","Yes/No","Not applicable*"]
["Percentage of non first lien mortgages","% ","Not applicable*",null,null," ","Residential","Commercial"]
["Are ABS part of the cover pool?","Yes/No","Not applicable*","Number of borrowers",null,null,510,668]
["\"interest only loans\"","(mn. €)",11792.05166884,"Number of loans",null,null,582,722]
["Central bank eligible securities","(mn. €) ",1320.3,"Number of properties",null,null,2770,1645]
["Breakdown of exposures to central banks and credit institutions within the meaning of sec. 28(1) no.8 by credit quality step",null,null,"Owner-occupied dwellings in the cover pool (mn. €)",null,null,3.2490751389999999]
["Credit quality step 1","(mn. €)",605.29999999999995,"Multi-family houses in the cover pool ( mn.€)",null,null,5941.6327704770001]
["Credit quality step 2","(mn. €)",450,null,null,null," "]
["Are derivatives included in the cover pool?","Y/N",{"$f":"IF(C20<>0,\"Y\",\"N\")","v":"N"}]
["Type of swap counterparties (external or none)?","E/N"]
["Net present value of derivatives in the cover pool","(mn. €)"]
["Currency positions (nominal)","(mn. €)","Pfandbriefe","Cover pool"]
["EUR",null,18854.355514480001,20003.64815107]
["AUD"]
["CAD"]
["CHF",null,209.841569615]
["CZK"]
["DKK"]
["GBP"]
["HKD",{"$nulls":5}," "]
["JPY"]
["NOK"]
["SEK"]
["USD"]
["Rating agency",null,"Fitch","Moody´s","S&P","DBRS","Scope"]
["Current Pfandbrief rating",null,"Unbekannt","Aaa","Unbekannt"]
["Cover pool by LTV buckets",null,"0- ≤20"," >20- ≤30",">30- ≤40",">40- ≤50",">50- ≤60"]
[null,"(mn. €)",37.540409279999999,157.58060180999999,586.65161051000007,809.15969414999995,16992.41583532]
["Cover pool by age of loans (seasoning) in buckets\nResidential+commercial",null," ≤12 months",">12 - ≤24 months",">24 - ≤36 months"," >36 - ≤60 months",">60 - ≤120 months","> 120 months"]
[null,"(mn. €)",1615.21492223,2069.5777064700001,2165.8517612599999,4583.7249271700002,7265.03608626,883.94274768000002]
[]
["not applicable*= for German Pfandbriefe not applicable respectively not intended by the Pfandbrief act"]

{"sheet":"C. HTT Harmonised Glossary","index":10,"n_rows":57,"n_cols":3,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["C. Harmonised Transparency Template - Glossary",null,"HTT 2025"]
[]
["The definitions below reflect the national specificities"]
[]
["Field Number","1. Glossary - Standard Harmonised Items","Definition"]
["HG.1.1","OC Calculation: Statutory","Statutory Overcollateralisation is the overcollateralisation percentage required to be provided by each Issuer and included/disclosed in the national covered bond framework. "]
["HG.1.2","OC Calculation: Contractual","Contractual Overcollateralisation is the overcollateralisation percentage each Issuer has contractually agreed to maintain pursuant to the covered bond programme documents. "]
["HG.1.3","OC Calculation: Voluntary","Voluntary Overcollateralisation is the difference (if positive) between the actual overcollateralisation provided by an Issuer and the higher of the contractual and statutory overcollateralisation."]
["HG.1.4","Interest Rate Types","[For completion]"]
["HG.1.5","Residual Life Buckets of Cover assets [i.e. how is the contractual and/or expected residual life defined? What assumptions eg, in terms of prepayments? etc.]","[For completion]"]
["HG.1.6","Maturity Buckets of Covered Bonds [i.e. how is the contractual and/or expected maturity defined? What maturity structure (hard bullet, soft bullet, conditional pass through)? Under what conditions/circumstances? Etc.] ","[For completion]"]
["HG.1.7","Maturity Extention Triggers","[insert link to the national legislation where the maturity extention triggers are listed - insert link of relevant programme prospectus]"]
["HG.1.8","LTVs: Definition","[For completion]"]
["HG.1.9","LTVs: Calculation of property/shipping value","[For completion]"]
["HG.1.10","LTVs: Applied property/shipping valuation techniques, including whether use of index, Automated Valuation Model (AVM) or on-site audits","[For completion]"]
["HG.1.11","LTVs: Frequency and time of last valuation","[For completion]"]
["HG.1.12","Explain how mortgage types are defined whether for residential housing, multi-family housing, commercial real estate, etc. Same for shipping where relecvant","[For completion]"]
["HG.1.13","Hedging Strategy (please explain how you address interest rate and currency risk)","[For completion]"]
["HG.1.14","Non-performing loans","[For completion]"]
["HG.1.15","Valuation Method","[For completion]"]
["OHG.1.1","NPV assumptions (when stated)"]
["OHG.1.2"]
["OHG.1.3"]
["OHG.1.4"]
["OHG.1.5"]
["OHG.1.6"]
["OHG.1.7"]
[null,"2. Glossary - ESG items (optional)","Definition"]
["HG.2.1","Sustainability - strategy pursued in the cover pool ","[For completion]"]
["HG.2.2","Subsidised Housing  (definitions of affordable, social housing)","[For completion]"]
["HG.2.3","New Property and Existing Property ","[For completion]"]
["OHG.2.1","Indication of proxy usage for ESG-related data (indicator, methodology, timing, share of proxy usage for single indicators etc.)","[For completion]"]
["OHG.2.2"]
["OHG.2.3"]
["OHG.2.4"]
["OHG.2.5"]
["OHG.2.6"]
["OHG.2.7"]
["OHG.2.8"]
["OHG.2.9"]
["OHG.2.10"]
["OHG.2.11"]
["OHG.2.12"]
[null,"3. Reason for No Data","Value"]
["HG.3.1","Not applicable for the jurisdiction ","ND1"]
["HG.3.2","Not relevant for the issuer and/or CB programme at the present time","ND2"]
["HG.3.3","Not available at the present time","ND3"]
["OHG.3.1","Confidential Information","ND4"]
["OHG.3.2"]
["OHG.3.3"]
[null,"4. Glossary - Extra national and/or Issuer Items","Definition"]
["HG.4.1","Other definitions deemed relevant","[For completion]"]
["OHG.4.1"]
["OHG.4.2"]
["OHG.4.3"]
["OHG.4.4"]
["OHG.4.5"]

{"sheet":"D. Insert Nat Trans Templ","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"E. Optional ECB-ECAIs data","index":12,"n_rows":90,"n_cols":7,"rows_kept":90,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["This addendum is optional"]
["E. Harmonised Transparency Template - Optional ECB - ECAIs Data Disclosure",{"$nulls":4},"HTT 2025"]
[]
[null,"Reporting in Domestic Currency","EUR"]
[]
[null,"CONTENT OF TAB E"]
[null,"1. Additional information on the programme"]
[null,"2.  Additional information on the swaps"]
[null,"3.  Additional information on the asset distribution"]
[]
[]
["Field Number","1.  Additional information on the programme"]
[null,"Transaction Counterparties","Name","Legal Entity Identifier (LEI)*"]
["E.1.1.1","Sponsor (if applicable)","ND1","ND1"]
["E.1.1.2","Servicer ","ND1","ND1"]
["E.1.1.3","Back-up servicer","ND1","ND1"]
["E.1.1.4","BUS facilitator","ND1","ND1"]
["E.1.1.5","Cash manager ","ND1","ND1"]
["E.1.1.6","Back-up cash manager","ND1","ND1"]
["E.1.1.7","Account bank","ND1","ND1"]
["E.1.1.8","Standby account bank","ND1","ND1"]
["E.1.1.9","Account bank guarantor","ND1","ND1"]
["E.1.1.10","Trustee","ND1","ND1"]
["E.1.1.11","Cover Pool Monitor","ND4","ND4"]
["OE.1.1.1","where applicable - paying agent","[For completion]","[For completion]"]
["OE.1.1.2"]
["OE.1.1.3"]
["OE.1.1.4"]
["OE.1.1.5"]
["OE.1.1.6"]
["OE.1.1.7"]
["OE.1.1.8"]
[null,"2.  Additional information on the swaps"]
[null,"Swap Counterparties","Guarantor (if applicable)","Legal Entity Identifier (LEI)*","Type of Swap"]
["E.2.1.1","Example Bank","ND4","ND4","ND4"]
["E.2.1.2","Counterparty 2","[For completion]","[For completion]","[For completion]"]
["E.2.1.3","Counterparty 3","[For completion]","[For completion]","[For completion]"]
["E.2.1.4","Counterparty 4","[For completion]","[For completion]","[For completion]"]
["E.2.1.5","Counterparty 5","[For completion]","[For completion]","[For completion]"]
["E.2.1.6","Counterparty 6","[For completion]","[For completion]","[For completion]"]
["E.2.1.7","Counterparty 7","[For completion]","[For completion]","[For completion]"]
["E.2.1.8","Counterparty 8","[For completion]","[For completion]","[For completion]"]
["E.2.1.9","Counterparty 9","[For completion]","[For completion]","[For completion]"]
["E.2.1.10","Counterparty 10","[For completion]","[For completion]","[For completion]"]
["E.2.1.11","Counterparty 11","[For completion]","[For completion]","[For completion]"]
["E.2.1.12","Counterparty 12","[For completion]","[For completion]","[For completion]"]
["E.2.1.13","Counterparty 13","[For completion]","[For completion]","[For completion]"]
["E.2.1.14","Counterparty 14","[For completion]","[For completion]","[For completion]"]
["E.2.1.15","Counterparty 15","[For completion]","[For completion]","[For completion]"]
["E.2.1.16","Counterparty 16","[For completion]","[For completion]","[For completion]"]
["E.2.1.17","Counterparty 17","[For completion]","[For completion]","[For completion]"]
["E.2.1.18","Counterparty 18","[For completion]","[For completion]","[For completion]"]
["E.2.1.19","Counterparty 19","[For completion]","[For completion]","[For completion]"]
["E.2.1.20","Counterparty 20","[For completion]","[For completion]","[For completion]"]
["E.2.1.21","Counterparty 21","[For completion]","[For completion]","[For completion]"]
["E.2.1.22","Counterparty 22","[For completion]","[For completion]","[For completion]"]
["E.2.1.23","Counterparty 23","[For completion]","[For completion]","[For completion]"]
["E.2.1.24","Counterparty 24","[For completion]","[For completion]","[For completion]"]
["E.2.1.25","Counterparty 25","[For completion]","[For completion]","[For completion]"]
["OE.2.1.1"]
["OE.2.1.2"]
["OE.2.1.3"]
["OE.2.1.4"]
["OE.2.1.5"]
["OE.2.1.6"]
["OE.2.1.7"]
["OE.2.1.8"]
["OE.2.1.9"]
["OE.2.1.10"]
["OE.2.1.11"]
["OE.2.1.12"]
["OE.2.1.13"]
[null,"3.  Additional information on the asset distribution"]
[null,"1. General Information","Total Assets"]
["E.3.1.1","Weighted Average Seasoning (years)","ND2"]
["E.3.1.2","Weighted Average Maturity (years)**","ND2"]
["OE.3.1.1"]
["OE.3.1.2"]
["OE.3.1.3"]
["OE.3.1.4"]
[null,"2. Arrears","% Residential Loans","% Commercial Loans","% Public Sector Assets","% Shipping Loans","% Total Loans"]
["E.3.2.1","1-<30 days","ND2","ND2","ND2","ND2","ND2"]
["E.3.2.2","30-<60 days","ND2","ND2","ND2","ND2","ND2"]
["E.3.2.3","60-<90 days","ND2","ND2","ND2","ND2","ND2"]
["E.3.2.4","90-<180 days","ND2","ND2","ND2","ND2","ND2"]
["E.3.2.5",">= 180 days","ND2","ND2","ND2","ND2","ND2"]
["OE.3.2.1"]
["OE.3.2.2"]
["OE.3.2.3"]
["OE.3.2.4"]

{"sheet":"F1. Sustainable M data","index":13,"n_rows":639,"n_cols":7,"rows_kept":639,"cut":false,"hidden":false,"merged":[[23,1,23,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[12,1,12,2]]}
["F1. Harmonised Transparency Template - Sustainable Mortgage Data",{"$nulls":4},"HTT 2025"]
[]
[null,"Reporting in Domestic Currency","[Please insert currency]"]
[]
[null,"CONTENT OF TAB F1"]
[null,"1.  Share of sustainable loans in the total mortgage program"]
[null,"2. Additional information on the sustainable section of the mortgage stock"]
[null,"2A. Sustainable Residential Cover Pool"]
[null,"2B. Sustainable Commercial Cover Pool"]
[]
[]
[]
[null,"1.  Share of sustainable loans in the total mortgage program"]
[null,"1. Amount of sustainable loans ","Nominal (mn)","Number of loans",null,"% Nominal (mn) to total mortgage program","% No. of Loans to total mortgage program"]
["SM.1.1.1","EE mortgage loans",7029.4585019710003,422,null,{"$f":"IF(OR('B1. HTT Mortgage Assets'!$C$15=0,C15=\"[For completion]\"),\"\",C15/'B1. HTT Mortgage Assets'!$C$15)","v":0.37826652360082724},{"$f":"IF(OR('B1. HTT Mortgage Assets'!$F$28=0,D15=\"[For completion]\"),\"\",D15/'B1. HTT Mortgage Assets'!$F$28)","v":0.32361963190184051}]
["SM.1.1.2","Social impact mortgage loans","[For completion]","[For completion]",null,{"$f":"IF(OR('B1. HTT Mortgage Assets'!$C$15=0,C16=\"[For completion]\"),\"\",C16/'B1. HTT Mortgage Assets'!$C$15)","v":""},{"$f":"IF(OR('B1. HTT Mortgage Assets'!$F$28=0,D16=\"[For completion]\"),\"\",D16/'B1. HTT Mortgage Assets'!$F$28)","v":""}]
["SM.1.1.3","other ","[For completion]","[For completion]",null,{"$f":"IF(OR('B1. HTT Mortgage Assets'!$C$15=0,C17=\"[For completion]\"),\"\",C17/'B1. HTT Mortgage Assets'!$C$15)","v":""},{"$f":"IF(OR('B1. HTT Mortgage Assets'!$F$28=0,D17=\"[For completion]\"),\"\",D17/'B1. HTT Mortgage Assets'!$F$28)","v":""}]
["SM.1.1.4","Total sustainable mortgage loans",{"$f":"SUM(C15:C17)","v":7029.4585019710003},{"$f":"SUM(D15:D17)","v":422},null,{"$f":"SUM(F15:F17)","v":0.37826652360082724},{"$f":"SUM(G15:G17)","v":0.32361963190184051}]
["OSM.1.1.1","o/w [If relevant, please specify]"]
["OSM.1.1.2","o/w [If relevant, please specify]"]
["OSM.1.1.3","o/w [If relevant, please specify]"]
["OSM.1.1.4","o/w [If relevant, please specify]"]
["OSM.1.1.5","o/w [If relevant, please specify]"]
[null,"2. Additional information on the sustainable section of the mortgage stock"]
[null,"1. Sustainable Property Type Information","Nominal (mn)",null,null,"% Total sustainable Mortgages"]
["SM.2.1.1","Residential",644.88036999999997,null,null,{"$f":"IF($C$29=0,\"\",IF(C26=\"[For completion]\",\"\",C26/$C$29))","v":9.1739693616884305E-2}]
["SM.2.1.2","Commercial",6384.5781399999996,null,null,{"$f":"IF($C$29=0,\"\",IF(C27=\"[For completion]\",\"\",C27/$C$29))","v":0.90826030638311572}]
["SM.2.1.3","Other","[For completion]",null,null,{"$f":"IF($C$29=0,\"\",IF(C28=\"[For completion]\",\"\",C28/$C$29))","v":""}]
["SM.2.1.4","Total",{"$f":"SUM(C26:C28)","v":7029.4585099999995},null,null,{"$f":"SUM(F26:F28)","v":1}]
["OSM.2.1.1","o/w Forest & Agriculture",null,null,null,{"$f":"IF($C$29=0,\"\",IF(C30=\"[For completion]\",\"\",C30/$C$29))","v":0}]
["OSM.2.1.2","o/w EE residential",null,null,null,0]
["OSM.2.1.3","o/w EE commercial",null,null,null,0]
["OSM.2.1.4","o/w EE other",null,null,null,0]
["OSM.2.1.5","EE total",null,null,null,0]
["OSM.2.1.6","o/w Social residential ",null,null,null,0]
["OSM.2.1.7","o/wSocial Commercial ",null,null,null,0]
["OSM.2.1.8","o/w social other",null,null,null,0]
["OSM.2.1.9","social tot",null,null,null,0]
["OSM.2.1.10","o/w Renewable Energy and Renewable Energy Transmission"]
["OSM.2.1.11","o/w [If relevant, please specify]"]
["OSM.2.1.12","o/w [If relevant, please specify]"]
["OSM.2.1.13","o/w [If relevant, please specify]"]
["OSM.2.1.14","o/w [If relevant, please specify]"]
["OSM.2.1.15","o/w [If relevant, please specify]"]
["OSM.2.1.16","o/w [If relevant, please specify]"]
["OSM.2.1.17","o/w [If relevant, please specify]"]
["OSM.2.1.18","o/w [If relevant, please specify]"]
[null,"2. General Information","Residential Loans","Commercial Loans",null,"Total sustainable Mortgages"]
["SM.2.2.1","Number of sustainable mortgage loans",56,366,null,1]
["OSM.2.2.1","Optional information eg, Number of borrowers"]
["OSM.2.2.2","Optional information eg, Number of guarantors"]
["OSM.2.2.3"]
["OSM.2.2.4"]
["OSM.2.2.5"]
["OSM.2.2.6"]
[null,"3. Concentration Risks","% Residential Loans","% Commercial Loans",null,"% Total Sustainable Mortgages"]
["SM.2.3.1","10 largest exposures ",0.50800000000000001,0.156,null,0.188]
["OSM.2.3.1"]
["OSM.2.3.2"]
["OSM.2.3.3"]
["OSM.2.3.4"]
["OSM.2.3.5"]
["OSM.2.3.6"]
[null,"4. Breakdown by Geography ","% Residential Loans","% Commercial Loans",null,"% Total Sustainable Mortgages"]
["SM.2.4.1","European Union",{"$f":"SUM(C66:C92)","v":1},{"$f":"SUM(D66:D92)","v":1.0010000000000001},null,{"$f":"SUM(F66:F92)","v":1}]
["SM.2.4.2","Austria","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.3","Belgium","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.4","Bulgaria","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.5","Croatia","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.6","Cyprus","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.7","Czechia","[For completion]",6.9999999999999993E-3,null,6.0000000000000001E-3]
["SM.2.4.8","Denmark","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.9","Estonia","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.10","Finland","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.11","France","[For completion]",9.8000000000000004E-2,null,8.900000000000001E-2]
["SM.2.4.12","Germany",0.83599999999999997,0.49700000000000011,null,0.52800000000000002]
["SM.2.4.13","Greece","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.14","Netherlands",0.16400000000000001,0.24099999999999999,null,0.23400000000000001]
["SM.2.4.15","Hungary","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.16","Ireland","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.17","Italy","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.18","Latvia","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.19","Lithuania","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.20","Luxembourg","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.21","Malta","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.22","Poland","[For completion]",0.158,null,0.14299999999999999]
["SM.2.4.23","Portugal","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.24","Romania","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.25","Slovakia","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.26","Slovenia","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.27","Spain","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.28","Sweden","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.29","European Economic Area (not member of EU)",{"$f":"SUM(C94:C96)","v":0},{"$f":"SUM(D94:D96)","v":0},null,{"$f":"SUM(F94:F96)","v":0}]
["SM.2.4.30","Iceland","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.31","Liechtenstein","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.32","Norway","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.33","Other",{"$f":"SUM(C98:C108)","v":0},{"$f":"SUM(D98:D108)","v":0},null,{"$f":"SUM(F98:F108)","v":0}]
["SM.2.4.34","Switzerland","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.35","United Kingdom","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.36","Australia","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.37","Brazil","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.38","Canada","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.39","Japan","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.40","Korea","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.41","New Zealand","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.42","Singapore","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.43","US","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.44","Other","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.4.45","o/w [If relevant, please specify]"]
["SM.2.4.46","o/w [If relevant, please specify]"]
["SM.2.4.47","o/w [If relevant, please specify]"]
["SM.2.4.48","o/w [If relevant, please specify]"]
["SM.2.4.49","o/w [If relevant, please specify]"]
["SM.2.4.50","o/w [If relevant, please specify]"]
["SM.2.4.51","o/w [If relevant, please specify]"]
["SM.2.4.52","o/w [If relevant, please specify]"]
["SM.2.4.53","o/w [If relevant, please specify]"]
["SM.2.4.54","o/w [If relevant, please specify]"]
[null,"5. Breakdown by regions of main country of origin","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["SM.2.5.1","Baden-Württemberg",0.129,4.5999999999999999E-2,null,5.2999999999999999E-2]
["SM.2.5.2","Bavaria",5.0999999999999997E-2,8.5000000000000006E-2,null,8.199999999999999E-2]
["SM.2.5.3","Berlin",0.13,8.5999999999999993E-2,null,0.09]
["SM.2.5.4","Brandenburg",1.2E-2,1.2999999999999999E-2,null,1.2999999999999999E-2]
["SM.2.5.5","Bremen","[For completion]",3.0000000000000001E-3,null,3.0000000000000001E-3]
["SM.2.5.6","Hamburg",0.129,3.4000000000000002E-2,null,4.2999999999999997E-2]
["SM.2.5.7","Hesse",0.16700000000000001,9.8000000000000004E-2,null,0.105]
["SM.2.5.8","Lower Saxony",3.0000000000000001E-3,9.0000000000000011E-3,null,9.0000000000000011E-3]
["SM.2.5.9","Mecklenburg-Western Pomerania",5.2999999999999999E-2,4.0000000000000001E-3,null,8.0000000000000002E-3]
["SM.2.5.10","North Rhine-Westphalia",8.199999999999999E-2,9.1999999999999998E-2,null,9.1999999999999998E-2]
["SM.2.5.11","Rhineland-Palatinate","[For completion]",8.0000000000000002E-3,null,8.0000000000000002E-3]
["SM.2.5.12","Saarland","[For completion]",1E-3,null,1E-3]
["SM.2.5.13","Saxony",7.2999999999999995E-2,5.0000000000000001E-3,null,1.2E-2]
["SM.2.5.14","Saxony-Anhalt",2E-3,2E-3,null,2E-3]
["SM.2.5.15","Schleswig-Holstein",5.0000000000000001E-3,6.9999999999999993E-3,null,6.9999999999999993E-3]
["SM.2.5.16","Thuringia","[For completion]",1E-3,null,1E-3]
["SM.2.5.17","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.18","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.19","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.20","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.21","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.22","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.23","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.24","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.25","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.26","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.27","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.28","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.29","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.30","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.31","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.32","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.33","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.34","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.35","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.36","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.37","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.38","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.39","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.40","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.41","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.42","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.43","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.44","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.45","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.46","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.47","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.48","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.49","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["SM.2.5.50","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
[null,"6. Breakdown by Interest Rate","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["SM.2.6.1","Fixed rate",0.86699999999999999,0.70099999999999996,null,0.71599999999999997]
["SM.2.6.2","Floating rate",0.13300000000000001,0.29899999999999999,null,0.28399999999999997]
["SM.2.6.3","Other","[For completion]","[For completion]",null,"[For completion]"]
["OSM.2.6.1"]
["OSM.2.6.2"]
["OSM.2.6.3"]
["OSM.2.6.4"]
["OSM.2.6.5"]
["OSM.2.6.6"]
[null,"7. Breakdown by Repayment Type","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["SM.2.7.1","Bullet / interest only",0.83200000000000007,0.60199999999999998,null,0.623]
["SM.2.7.2","Amortising",1.0999999999999999E-2,4.8000000000000001E-2,null,4.3999999999999997E-2]
["SM.2.7.3","Other",0.158,0.35,null,0.33200000000000002]
["OSM.2.7.1"]
["OSM.2.7.2"]
["OSM.2.7.3"]
["OSM.2.7.4"]
["OSM.2.7.5"]
["OSM.2.7.6"]
[null,"8. Loan Seasoning ","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["SM.2.8.1","Up to 12months","[For completion]","[For completion]",null,0.23499999999999999]
["SM.2.8.2",">  12 - ≤ 24 months","[For completion]","[For completion]",null,0.246]
["SM.2.8.3","> 24 - ≤ 36 months","[For completion]","[For completion]",null,0.14799999999999999]
["SM.2.8.4","> 36 - ≤ 60 months","[For completion]","[For completion]",null,0.253]
["SM.2.8.5","> 60 months","[For completion]","[For completion]",null,0.11700000000000001]
["OSM.2.8.1"]
["OSM.2.8.2"]
["OSM.2.8.3"]
["OSM.2.8.4"]
[null,"9. Non-Performing Loans (NPLs)","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["SM.2.9.1","% NPLs","[For completion]","[For completion]",null,"[For completion]"]
["OSM.2.9.1","% Defaulted Loans pursuant Art 178 CRR","[For completion]","[For completion]",null,"[For completion]"]
["OSM.2.9.2"]
["OSM.2.9.3"]
["OSM.2.9.4"]
["OSM.2.9.5"]
["OSM.2.9.6"]
["OSM.2.9.7"]
[null,"2.A Residential Cover Pool"]
[null,"10. Loan Size Information","Nominal","Number of Loans",null,"% Residential Loans","% No. of Loans"]
["SM.2A.10.1","Average loan size (000s)",11515.7,56]
[]
[null,"By buckets (mn):"]
["SM.2A.10.2","Up to 300,000 Euros",0.5181,2,null,{"$f":"IF($C$238=0,\"\",IF(C214=\"[for completion]\",\"\",IF(C214=\"\",\"\",C214/$C$238)))","v":8.0340482375048879E-4},{"$f":"IF($D$238=0,\"\",IF(D214=\"[for completion]\",\"\",IF(D214=\"\",\"\",D214/$D$238)))","v":3.5714285714285712E-2}]
["SM.2A.10.3","More than 300,000 Euros up to 1 mn. Euros",4.1263500000000004,6,null,6.3986286324702376E-3,0.10714285714285714]
["SM.2A.10.4","More than 1 mn. Euros up to 10 mn. Euros",115.45877,25,null,0.17903905184770938,0.44642857142857145]
["SM.2A.10.5","More than 10 mn. Euros",524.77715000000001,23,null,0.81375891469606998,0.4107142857142857]
["SM.2A.10.6","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.7","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.8","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.9","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.10","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.11","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.12","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.13","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.14","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.15","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.16","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.17","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.18","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.19","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.20","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.21","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.22","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.23","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.24","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.25","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.10.26","Total",{"$f":"SUM(C214:C237)","v":644.88036999999997},{"$f":"SUM(D214:D237)","v":56},null,{"$f":"SUM(F214:F237)","v":1},{"$f":"SUM(G214:G237)","v":1}]
[null,"11. Loan to Value (LTV) Information - UNINDEXED","Nominal","Number of Loans",null,"% Residential Loans","% No. of Loans"]
["SM.2A.11.1","Weighted Average LTV (%)",0.57299999999999995]
[]
[null,"By LTV buckets (mn):"]
["SM.2A.11.2",">0 - <=40 %",15.085900000000001,"[For completion]",null,{"$f":"IF($C$251=0,\"\",IF(C243=\"[for completion]\",\"\",IF(C243=\"\",\"\",C243/$C$251)))","v":2.3393331076273886E-2},{"$f":"IF($D$251=0,\"\",IF(D243=\"[for completion]\",\"\",IF(D243=\"\",\"\",D243/$D$251)))","v":""}]
["SM.2A.11.3",">40 - <=50 %",4.7936300000000003,"[For completion]",null,7.43336318331414E-3,""]
["SM.2A.11.4",">50 - <=60 %",625.00083999999993,"[For completion]",null,0.96917330574041194,""]
["SM.2A.11.5",">60 - <=70 %","[For completion]","[For completion]",null,"",""]
["SM.2A.11.6",">70 - <=80 %","[For completion]","[For completion]",null,"",""]
["SM.2A.11.7",">80 - <=90 %","[For completion]","[For completion]",null,"",""]
["SM.2A.11.8",">90 - <=100 %","[For completion]","[For completion]",null,"",""]
["SM.2A.11.9",">100%","[For completion]","[For completion]",null,"",""]
["SM.2A.11.10","Total",{"$f":"SUM(C243:C250)","v":644.88036999999997},{"$f":"SUM(D243:D250)","v":0},null,{"$f":"SUM(F240:F250)","v":1},{"$f":"SUM(G240:G250)","v":0}]
["OSM.2A.11.1","o/w >100 - <=110 %"]
["OSM.2A.11.2","o/w >110 - <=120 %"]
["OSM.2A.11.3","o/w >120 - <=130 %"]
["OSM.2A.11.4","o/w >130 - <=140 %"]
["OSM.2A.11.5","o/w >140 - <=150 %"]
["OSM.2A.11.6","o/w >150 %"]
["OSM.2A.11.7"]
["OSM.2A.11.8"]
["OSM.2A.11.9"]
[null,"12. Loan to Value (LTV) Information - INDEXED ","Nominal","Number of Loans",null,"% Residential Loans","% No. of Loans"]
["SM.2A.12.1","Weighted Average LTV (%)","ND1"]
[]
[null,"By LTV buckets (mn):"]
["SM.2A.12.2",">0 - <=40 %","ND1","ND1",null,{"$f":"IF($C$273=0,\"\",IF(C265=\"[for completion]\",\"\",IF(C265=\"\",\"\",C265/$C$273)))","v":""},{"$f":"IF($D$273=0,\"\",IF(D265=\"[for completion]\",\"\",IF(D265=\"\",\"\",D265/$D$273)))","v":""}]
["SM.2A.12.3",">40 - <=50 %","ND1","ND1",null,"",""]
["SM.2A.12.4",">50 - <=60 %","ND1","ND1",null,"",""]
["SM.2A.12.5",">60 - <=70 %","ND1","ND1",null,"",""]
["SM.2A.12.6",">70 - <=80 %","ND1","ND1",null,"",""]
["SM.2A.12.7",">80 - <=90 %","ND1","ND1",null,"",""]
["SM.2A.12.8",">90 - <=100 %","ND1","ND1",null,"",""]
["SM.2A.12.9",">100%","ND1","ND1",null,"",""]
["SM.2A.12.10","Total",{"$f":"SUM(C265:C272)","v":0},{"$f":"SUM(D265:D272)","v":0},null,{"$f":"SUM(F265:F272)","v":0},{"$f":"SUM(G265:G272)","v":0}]
["OSM.2A.12.1","o/w >100 - <=110 %"]
["OSM.2A.12.2","o/w >110 - <=120 %"]
["OSM.2A.12.3","o/w >120 - <=130 %"]
["OSM.2A.12.4","o/w >130 - <=140 %"]
["OSM.2A.12.5","o/w >140 - <=150 %"]
["OSM.2A.12.6","o/w >150 %"]
["OSM.2A.12.7"]
["OSM.2A.12.8"]
["OSM.2A.12.9"]
[null,"13. Breakdown by type","% Residential Loans"]
["SM.2A.13.1","Owner occupied","[For completion]"]
["SM.2A.13.2","Second home/Holiday houses","[For completion]"]
["SM.2A.13.3","Buy-to-let/Non-owner occupied",1]
["SM.2A.13.4","Subsidised housing ","[For completion]"]
["SM.2A.13.5","Agricultural","[For completion]"]
["SM.2A.13.6","Other","[For completion]"]
["OSM.2A.13.1","o/w Private rental"]
["OSM.2A.13.2","o/w Multi-family housing "]
["OSM.2A.13.3","o/w Buildings under construction "]
["OSM.2A.13.4","o/w Buildings land"]
["OSM.2A.13.5","o/w [If relevant, please specify]"]
["OSM.2A.13.6","o/w [If relevant, please specify]"]
["OSM.2A.13.7","o/w [If relevant, please specify]"]
["OSM.2A.13.8","o/w [If relevant, please specify]"]
["OSM.2A.13.9","o/w [If relevant, please specify]"]
["OSM.2A.13.10","o/w [If relevant, please specify]"]
[null,"14. Loan by Ranking","% Residential Loans"]
["SM.2A.14.1","1st lien / No prior ranks","[For completion]"]
["SM.2A.14.2","Guaranteed","[For completion]"]
["SM.2A.14.3","Other","[For completion]"]
["OSM.2A.14.1"]
["OSM.2A.14.2"]
["OSM.2A.14.3"]
[null,"15. Energy Performance information of the financed RRE","Nominal (mn)","Number of dwellings",null,"% Residential Loans","% No. of Dwellings"]
["SM.2A.15.1","A+",53.099910000000001,"ND3",null,{"$f":"IF($C$326=0,\"\",IF(C308=\"[for completion]\",\"\",IF(C308=\"\",\"\",C308/$C$326)))","v":8.2340713828830001E-2}]
["SM.2A.15.2","A",198.12810999999999,"ND3",null,0.30723234760580476]
["SM.2A.15.3","B",221.00259,"ND3",null,0.34270323657083873]
["SM.2A.15.4","C",36.245230000000006,"ND3",null,5.62045794633197E-2]
["SM.2A.15.5","D",0,"ND3",null,0]
["SM.2A.15.6","E",0,"ND3",null,0]
["SM.2A.15.7","F",0,"ND3",null,0]
["SM.2A.15.8","G",0,"ND3",null,0]
["SM.2A.15.9","H",0,"ND3",null,0]
["SM.2A.15.10","TBC at a country level","[For completion]","[For completion]",null,"",{"$f":"IF($D$326=0,\"\",IF(D317=\"[for completion]\",\"\",IF(D317=\"\",\"\",D317/$D$326)))","v":""}]
["SM.2A.15.11","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.15.12","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.15.13","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.15.14","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.15.15","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.15.16","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.15.17","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.15.18","no data",136.40452999999999,"ND3",null,0.21151912253120683]
["SM.2A.15.19","Total",{"$f":"SUM(C308:C325)","v":644.88036999999997},"ND3",null,{"$f":"SUM(F308:F325)","v":1}]
["OSM.2A.15.1"]
["OSM.2A.15.2"]
["OSM.2A.15.3"]
[null,"16. Primary Energy intensity (kWh/m2 per year)","Nominal (mn)","Number of dwellings",null,"% Residential Loans","% No. of Dwellings"]
["SM.2A.16.1","≤ 30",0,"ND3",null,{"$f":"IF($C$349=0,\"\",IF(C331=\"[for completion]\",\"\",IF(C331=\"\",\"\",C331/$C$349)))","v":0},{"$f":"IF($D$349=0,\"\",IF(D331=\"[for completion]\",\"\",IF(D331=\"\",\"\",D331/$D$349)))","v":""}]
["SM.2A.16.2","> 30 - ≤ 50",133.53689,"ND3",null,0.20707234428611934,""]
["SM.2A.16.3","> 50 - ≤ 75",346.42696000000001,"ND3",null,0.53719569724226535,""]
["SM.2A.16.4","> 75 - ≤ 100",84.069670000000002,"ND3",null,0.13036475276802117,""]
["SM.2A.16.5","> 100 - ≤ 130",2.7232799999999999,"ND3",null,4.2229227724825931E-3,""]
["SM.2A.16.6","> 130 - ≤ 160",55.454360000000001,"ND3",null,8.5991701065423989E-2,""]
["SM.2A.16.7","> 160 - ≤ 200",1.008,"ND3",null,1.5630806067178013E-3,""]
["SM.2A.16.8","> 200 - ≤ 250",1.4490000000000001,"ND3",null,2.2469283721568397E-3,""]
["SM.2A.16.9","> 250",0.49380000000000002,"ND3",null,7.6572341626711339E-4,""]
["SM.2A.16.10","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.16.11","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.16.12","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.16.13","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.16.14","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.16.15","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.16.16","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.16.17","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2A.16.18","no data",19.718409999999999,"ND3",null,3.0576849470545991E-2,""]
["SM.2A.16.19","Total",{"$f":"SUM(C331:C348)","v":644.88036999999986},{"$f":"SUM(D331:D348)","v":0},null,{"$f":"SUM(F331:F348)","v":1.0000000000000002},{"$f":"SUM(G331:G348)","v":0}]
["OSM.2A.16.1"]
["OSM.2A.16.2"]
[null,"17. Property Age Structure","Nominal (mn)","Number of dwellings",null,"% Residential Loans","% No. of dwellings"]
["SM.2A.17.1","older than 1919",0,"ND3",null,{"$f":"IF($C$366=0,\"\",IF(C353=\"[for completion]\",\"\",IF(C353=\"\",\"\",C353/$C$366)))","v":0},{"$f":"IF($D$366=0,\"\",IF(D353=\"[for completion]\",\"\",IF(D353=\"\",\"\",D353/$D$366)))","v":""}]
["SM.2A.17.2","1919 - 1945",0,"ND3",null,0,""]
["SM.2A.17.3","1946 - 1960",2.6599699999999999,"ND3",null,4.1247496531720959E-3,""]
["SM.2A.17.4","1961 - 1970",19.779669999999999,"ND3",null,3.0671844784850397E-2,""]
["SM.2A.17.5","1971 - 1980",17.709019999999999,"ND3",null,2.7460939071875887E-2,""]
["SM.2A.17.6","1981 - 1990",2.5499800000000001,"ND3",null,3.9541908820760318E-3,""]
["SM.2A.17.7","1991 - 2000",49.138979999999997,"ND3",null,7.6198600251969215E-2,""]
["SM.2A.17.8","2001 - 2005",5.0468000000000002,"ND3",null,7.8259478676935956E-3,""]
["SM.2A.17.9","2006 - 2010",28.104019999999998,"ND3",null,4.358020832856823E-2,""]
["SM.2A.17.10","2011 - 2015",145.15261000000001,"ND3",null,0.2250845602598994,""]
["SM.2A.17.11","2016 - 2020",245.06711000000001,"ND3",null,0.38001950284265912,""]
["SM.2A.17.12","2021 and onwards",129.67219,"ND3",null,0.20107945605723604,""]
["SM.2A.17.13","no data",0,"ND3",null,0,""]
["SM.2A.17.14","Total",{"$f":"SUM(C353:C365)","v":644.88035000000002},{"$f":"SUM(D353:D365)","v":0},null,{"$f":"SUM(F353:F365)","v":1},{"$f":"SUM(G353:G365)","v":0}]
["OSM.2A.17.1",{"$nulls":4},{"$f":"IF($C$349=0,\"\",IF(C367=\"[for completion]\",\"\",IF(C367=\"\",\"\",C367/$C$349)))","v":""},{"$f":"IF($D$349=0,\"\",IF(D367=\"[for completion]\",\"\",IF(D367=\"\",\"\",D367/$D$349)))","v":""}]
["OSM.2A.17.2"]
["OSM.2A.17.3"]
["OSM.2A.17.4"]
["OSM.2A.17.5"]
["OSM.2A.17.6"]
["OSM.2A.17.7"]
["OSM.2A.17.8"]
["OSM.2A.17.9"]
["OSM.2A.17.10"]
[null,"18. Dwelling type","Nominal (mn)","Number of dwellings",null,"% Residential Loans","% No. of dwellings"]
["SM.2A.18.1","House, detached or semi-detached","[For completion]","[For completion]",null,{"$f":"IF($C$385=0,\"\",IF(C378=\"[for completion]\",\"\",IF(C378=\"\",\"\",C378/$C$385)))","v":""},{"$f":"IF($D$385=0,\"\",IF(D378=\"[for completion]\",\"\",IF(D378=\"\",\"\",D378/$D$385)))","v":""}]
["SM.2A.18.2","Flat or Apartment","[For completion]","[For completion]",null,"",""]
["SM.2A.18.3","Bungalow","[For completion]","[For completion]",null,"",""]
["SM.2A.18.4","Terraced House","[For completion]","[For completion]",null,"",""]
["SM.2A.18.5","Multifamily House",644.88036999999997,"ND3",null,1,""]
["SM.2A.18.6","Land Only","[For completion]","[For completion]",null,"",""]
["SM.2A.18.7","other","[For completion]","[For completion]",null,"",""]
["SM.2A.18.8","Total",{"$f":"SUM(C378:C384)","v":644.88036999999997},{"$f":"SUM(D378:D384)","v":0},null,{"$f":"SUM(F378:F384)","v":1},{"$f":"SUM(G378:G384)","v":0}]
["OSM.2A.18.1"]
[null,"19. New Residential Property","Nominal (mn)","Number of dwellings",null,"% Residential Loans","% No. of dwellings"]
["SM.2A.19.1","New Proprety","[For completion]","[For completion]",null,{"$f":"IF($C$392=0,\"\",IF(C388=\"[for completion]\",\"\",IF(C388=\"\",\"\",C388/$C$392)))","v":""},{"$f":"IF($D$392=0,\"\",IF(D388=\"[for completion]\",\"\",IF(D388=\"\",\"\",D388/$D$392)))","v":""}]
["SM.2A.19.2","Existing Property","[For completion]","[For completion]",null,{"$f":"IF($C$392=0,\"\",IF(C389=\"[for completion]\",\"\",IF(C389=\"\",\"\",C389/$C$392)))","v":""},{"$f":"IF($D$392=0,\"\",IF(D389=\"[for completion]\",\"\",IF(D389=\"\",\"\",D389/$D$392)))","v":""}]
["SM.2A.19.3","other","[For completion]","[For completion]",null,{"$f":"IF($C$392=0,\"\",IF(C390=\"[for completion]\",\"\",IF(C390=\"\",\"\",C390/$C$392)))","v":""},{"$f":"IF($D$392=0,\"\",IF(D390=\"[for completion]\",\"\",IF(D390=\"\",\"\",D390/$D$392)))","v":""}]
["SM.2A.19.4","no data",644.88036999999997,"ND3",null,{"$f":"IF($C$392=0,\"\",IF(C391=\"[for completion]\",\"\",IF(C391=\"\",\"\",C391/$C$392)))","v":1},{"$f":"IF($D$392=0,\"\",IF(D391=\"[for completion]\",\"\",IF(D391=\"\",\"\",D391/$D$392)))","v":""}]
["SM.2A.19.5","Total",{"$f":"SUM(C388:C391)","v":644.88036999999997},{"$f":"SUM(D388:D391)","v":0},null,{"$f":"SUM(F388:F391)","v":1},{"$f":"SUM(G388:G391)","v":0}]
["OSM.2A.19.1"]
[null,"20. CO2 emission - by dwelling type - as per national availability","Ton CO2 (per year)","Ton CO2 (per year) (LTV adjusted)",null,"kg CO2/m2 (per year)","% No. of Dwellings with no CO2 data"]
["SM.2A.20.1","House, detached or semi-detached","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["SM.2A.20.2","Flat or Apartment","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["SM.2A.20.3","Bungalow","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["SM.2A.20.4","Terraced House","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["SM.2A.20.5","Multifamily House",2534.5,"ND3",null,"[For completion]","[For completion]"]
["SM.2A.20.6","Land Only","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["SM.2A.20.7","Other","[For completion]","[For completion]",null,"[For completion]","[For completion]"]
["SM.2A.20.8","No data",{"$f":"SUM(C395:C401)","v":2534.5},{"$f":"SUM(D395:D401)","v":0},null,null,{"$f":"IF($D$413=0,\"\",IF(#REF!=\"[for completion]\",\"\",IF(#REF!=\"\",\"\",#REF!/$D$413)))","v":""}]
["SM.2A.20.9","Weighted Average",null,null,null,"[For completion]",{"$f":"IF($D$413=0,\"\",IF(D402=\"[for completion]\",\"\",IF(D402=\"\",\"\",D402/$D$413)))","v":""}]
["SM.2A.20.10",{"$nulls":5},{"$f":"IF($D$413=0,\"\",IF(D403=\"[for completion]\",\"\",IF(D403=\"\",\"\",D403/$D$413)))","v":""}]
["SM.2A.20.11"]
["SM.2A.20.12"]
["SM.2A.20.13"]
["SM.2A.20.14"]
["SM.2A.20.15"]
["SM.2A.20.16"]
["SM.2A.20.17"]
["SM.2A.20.18"]
["SM.2A.20.19"]
["SM.2A.20.20"]
["SM.2A.20.21"]
["SM.2A.20.22"]
["SM.2A.20.23"]
["SM.2A.20.24"]
["SM.2A.20.25"]
["SM.2A.20.26"]
["SM.2A.20.27"]
["SM.2A.20.28"]
["SM.2A.20.29"]
["SM.2A.20.30"]
["SM.2A.20.31"]
["SM.2A.20.32"]
["SM.2A.20.33"]
["SM.2A.20.34"]
["SM.2A.20.35"]
["SM.2A.20.36"]
["SM.2A.20.37"]
["SM.2A.20.38"]
["SM.2A.20.39"]
["SM.2A.20.40"]
["SM.2A.20.41"]
["SM.2A.20.42"]
["SM.2A.20.43"]
["SM.2A.20.44"]
["SM.2A.20.45"]
["SM.2A.20.46"]
["SM.2A.20.47"]
["SM.2A.20.48"]
[null,"2.B Sustainable Commercial Cover Pool"]
[null,"21. Loan Size Information","Nominal","Number of Loans",null,"% Commercial Loans","% No. of Loans"]
["SM.2B.21.1","Average loan size (000s)",17444.2,366]
[]
[null,"By buckets (mn):"]
["SM.2B.21.2","Up to 300,000 Euros",1.9706600000000001,13,null,{"$f":"IF($C$472=0,\"\",IF(C448=\"[for completion]\",\"\",IF(C448=\"\",\"\",C448/$C$472)))","v":3.0865939140758861E-4},{"$f":"IF($D$472=0,\"\",IF(D448=\"[for completion]\",\"\",IF(D448=\"\",\"\",D448/$D$472)))","v":3.5519125683060107E-2}]
["SM.2B.21.3","More than 300,000 Euros up to 1 mn. Euros",13.86393,25,null,2.1714715863301683E-3,6.8306010928961755E-2]
["SM.2B.21.4","More than 1 mn. Euros up to 10 mn. Euros",701.99098000000004,149,null,0.10995103602875012,0.40710382513661203]
["SM.2B.21.5","More than 10 mn. Euros",5666.7525599999999,179,null,0.88756883299351219,0.48907103825136611]
["SM.2B.21.6","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.7","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.8","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.9","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.10","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.11","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.12","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.13","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.14","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.15","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.16","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.17","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.18","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.19","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.20","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.21","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.22","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.23","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.24","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.25","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SM.2B.21.26","Total",{"$f":"SUM(C448:C471)","v":6384.5781299999999},{"$f":"SUM(D448:D471)","v":366},null,{"$f":"SUM(F448:F471)","v":1},{"$f":"SUM(G448:G471)","v":1}]
[null,"22. Loan to Value (LTV) Information - UNINDEXED ","Nominal","Number of Loans",null,"% Commercial Loans","% No. of Loans"]
["SM.2B.22.1","Weighted Average LTV (%)",0.39300000000000002]
[]
[null,"By LTV buckets (mn):"]
["SM.2B.22.2",">0 - <=40 %",1498.5181500000001,"[For completion]",null,{"$f":"IF($C$485=0,\"\",IF(C477=\"[for completion]\",\"\",IF(C477=\"\",\"\",C477/$C$485)))","v":0.23470903158953121},{"$f":"IF($D$485=0,\"\",IF(D477=\"[for completion]\",\"\",IF(D477=\"\",\"\",D477/$D$485)))","v":""}]
["SM.2B.22.3",">40 - <=50 %",372.21807000000001,"[For completion]",null,5.8299555964553607E-2,""]
["SM.2B.22.4",">50 - <=60 %",4513.8419100000001,"[For completion]",null,0.70699141244591523,""]
["SM.2B.22.5",">60 - <=70 %","[For completion]","[For completion]",null,"",""]
["SM.2B.22.6",">70 - <=80 %","[For completion]","[For completion]",null,"",""]
["SM.2B.22.7",">80 - <=90 %","[For completion]","[For completion]",null,"",""]
["SM.2B.22.8",">90 - <=100 %","[For completion]","[For completion]",null,"",""]
["SM.2B.22.9",">100%","[For completion]","[For completion]",null,"",""]
["SM.2B.22.10","Total",{"$f":"SUM(C477:C484)","v":6384.5781299999999},{"$f":"SUM(D477:D484)","v":0},null,{"$f":"SUM(F477:F484)","v":1},{"$f":"SUM(G477:G484)","v":0}]
["OSM.2B.22.1","o/w >100 - <=110 %"]
["OSM.2B.22.2","o/w >110 - <=120 %"]
["OSM.2B.22.3","o/w >120 - <=130 %"]
["OSM.2B.22.4","o/w >130 - <=140 %"]
["OSM.2B.22.5","o/w >140 - <=150 %"]
["OSM.2B.22.6","o/w >150 %"]
["OSM.2B.22.7"]
["OSM.2B.22.8"]
["OSM.2B.22.9"]
[null,"23. Loan to Value (LTV) Information - INDEXED","Nominal","Number of Loans",null,"% Commercial Loans","% No. of Loans"]
["SM.2B.23.1","Weighted Average LTV (%)","ND1"]
[]
[null,"By LTV buckets (mn):"]
["SM.2B.23.2",">0 - <=40 %","ND1","ND1",null,{"$f":"IF($C$507=0,\"\",IF(C499=\"[for completion]\",\"\",IF(C499=\"\",\"\",C499/$C$507)))","v":""},{"$f":"IF($D$507=0,\"\",IF(D499=\"[for completion]\",\"\",IF(D499=\"\",\"\",D499/$D$507)))","v":""}]
["SM.2B.23.3",">40 - <=50 %","ND1","ND1",null,"",""]
["SM.2B.23.4",">50 - <=60 %","ND1","ND1",null,"",""]
["SM.2B.23.5",">60 - <=70 %","ND1","ND1",null,"",""]
["SM.2B.23.6",">70 - <=80 %","ND1","ND1",null,"",""]
["SM.2B.23.7",">80 - <=90 %","ND1","ND1",null,"",""]
["SM.2B.23.8",">90 - <=100 %","ND1","ND1",null,"",""]
["SM.2B.23.9",">100%","ND1","ND1",null,"",""]
["SM.2B.23.10","Total",{"$f":"SUM(C499:C506)","v":0},{"$f":"SUM(D499:D506)","v":0},null,{"$f":"SUM(F499:F506)","v":0},{"$f":"SUM(G499:G506)","v":0}]
["OSM.2B.23.1","o/w >100 - <=110 %"]
["OSM.2B.23.2","o/w >110 - <=120 %"]
["OSM.2B.23.3","o/w >120 - <=130 %"]
["OSM.2B.23.4","o/w >130 - <=140 %"]
["OSM.2B.23.5","o/w >140 - <=150 %"]
["OSM.2B.23.6","o/w >150 %"]
["OSM.2B.23.7"]
["OSM.2B.23.8"]
["OSM.2B.23.9"]
[null,"24. Breakdown by Type","% Commercial loans"]
["SM.2B.24.1","Retail",0]
["SM.2B.24.2","Office",0.78]
["SM.2B.24.3","Hotel/Tourism",3.1E-2]
["SM.2B.24.4","Shopping malls",0.15]
["SM.2B.24.5","Industry",0.04]
["SM.2B.24.6","Agriculture",0]
["SM.2B.24.7","Other commercially used",0]
["SM.2B.24.8","Hospital ",0]
["SM.2B.24.9","School ",0]
["SM.2B.24.10","other RE with a social relevant purpose",0]
["SM.2B.24.11","Land",0]
["SM.2B.24.12","Property developers / Building under construction",0]
["SM.2B.24.13","Other",0]
["OSM.2B.24.1","o/w Cultural purposes"]
["OSM.2B.24.2","o/w [If relevant, please specify]"]
["OSM.2B.24.3","o/w [If relevant, please specify]"]
["OSM.2B.24.4","o/w [If relevant, please specify]"]
["OSM.2B.24.5","o/w [If relevant, please specify]"]
["OSM.2B.24.6","o/w [If relevant, please specify]"]
["OSM.2B.24.7","o/w [If relevant, please specify]"]
["OSM.2B.24.8","o/w [If relevant, please specify]"]
["OSM.2B.24.9","o/w [If relevant, please specify]"]
["OSM.2B.24.10","o/w [If relevant, please specify]"]
["OSM.2B.24.11","o/w [If relevant, please specify]"]
["OSM.2B.24.12","o/w [If relevant, please specify]"]
["OSM.2B.24.13","o/w [If relevant, please specify]"]
["OSM.2B.24.14","o/w [If relevant, please specify]"]
[null,"25. EPC  Information of the financed CRE","Nominal (mn)","Number of CRE",null,"% Commercial Loans","% No. of CRE"]
["SM.2B.25.1","A+",171.78565,"ND3",null,{"$f":"IF($C$564=0,\"\",IF(C546=\"[for completion]\",\"\",IF(C546=\"\",\"\",C546/$C$564)))","v":2.6906343102568713E-2},{"$f":"IF($D$564=0,\"\",IF(D546=\"[for completion]\",\"\",IF(D546=\"\",\"\",D546/$D$564)))","v":""}]
["SM.2B.25.2","A",1263.4375500000001,"ND3",null,0.19788896342022058,""]
["SM.2B.25.3","B",467.59757999999999,"ND3",null,7.3238602417668885E-2,""]
["SM.2B.25.4","C",73.34563,"ND3",null,1.1487936773846109E-2,""]
["SM.2B.25.5","D",0,"ND3",null,0,""]
["SM.2B.25.6","E",0,"ND3",null,0,""]
["SM.2B.25.7","F",0,"ND3",null,0,""]
["SM.2B.25.8","G",0,"ND3",null,0,""]
["SM.2B.25.9","H",0,"ND3",null,0,""]
["SM.2B.25.10","Assets in countries without EPC levels for CRE","[For completion]","ND3",null,"",""]
["SM.2B.25.11","TBC at a country level","[For completion]","ND3",null,"",""]
["SM.2B.25.12","TBC at a country level","[For completion]","ND3",null,"",""]
["SM.2B.25.13","TBC at a country level","[For completion]","ND3",null,"",""]
["SM.2B.25.14","TBC at a country level","[For completion]","ND3",null,"",""]
["SM.2B.25.15","TBC at a country level","[For completion]","ND3",null,"",""]
["SM.2B.25.16","TBC at a country level","[For completion]","ND3",null,"",""]
["SM.2B.25.17","TBC at a country level","[For completion]","ND3",null,"",""]
["SM.2B.25.18","no data",4408.4117300000007,"ND3",null,0.6904781542856957,""]
["SM.2B.25.19","Total",{"$f":"SUM(C546:C563)","v":6384.5781400000005},{"$f":"SUM(D546:D563)","v":0},null,{"$f":"SUM(F546:F563)","v":1},{"$f":"SUM(G546:G563)","v":0}]
["OSM.2B.25.1"]
["OSM.2B.25.2"]
["OSM.2B.25.3"]
[null,"26. Average energy use intensity (kWh/m2 per year)","Nominal (mn)","Number of CRE",null,"% Commercial Loans","% No. of  CRE"]
["SM.2B.26.1","[< 95 kWh/m²] Retail",957.2,"ND3",null,{"$f":"IF($C$587=0,\"\",IF(C569=\"[for completion]\",\"\",IF(C569=\"\",\"\",C569/$C$587)))","v":0.14992325282711524},{"$f":"IF($D$587=0,\"\",IF(D569=\"[for completion]\",\"\",IF(D569=\"\",\"\",D569/$D$587)))","v":""}]
["SM.2B.26.2","[< 135 kWh/m²] Office",4978.3,"ND3",null,0.77973561382075618,""]
["SM.2B.26.3","[< 105 kWh/m²] Hotel/Tourism",195.5,"ND3",null,3.0620555712182439E-2,""]
["SM.2B.26.4","[< 70 kWh/m²] Shopping malls","[For completion]","ND3",null,"",""]
["SM.2B.26.5","[< 110 kWh/m²] Industry","[For completion]","ND3",null,"",""]
["SM.2B.26.6","[< 110 kWh/m²] Agriculture","[For completion]","ND3",null,"",""]
["SM.2B.26.7","[< 95 kWh/m²] Other commercially used",253.6,"ND3",null,3.9720577639946117E-2,""]
["SM.2B.26.8","[< 250 kWh/m²] Hospital","[For completion]","ND3",null,"",""]
["SM.2B.26.9","[< 105 kWh/m²] School","[For completion]","ND3",null,"",""]
["SM.2B.26.10","[< 135 kWh/m²] other RE with a social relevant purpose","[For completion]","ND3",null,"",""]
["SM.2B.26.11","[< 110 kWh/m²] Land","[For completion]","ND3",null,"",""]
["SM.2B.26.12","[< 110 kWh/m²] Property developers / Bulding under construction","[For completion]","ND3",null,"",""]
["SM.2B.26.13","Top category sustainability certificate",0,"ND3",null,0,""]
["SM.2B.26.14","Top 15 % approach","[For completion]","ND3",null,"",""]
["SM.2B.26.15","Other","[For completion]","ND3",null,"",""]
["SM.2B.26.16","TBC at a country level","[For completion]","ND3",null,"",""]
["SM.2B.26.17","TBC at a country level","[For completion]","ND3",null,"",""]
["SM.2B.26.18","no data",0,"ND3",null,0,""]
["SM.2B.26.19","Total",{"$f":"SUM(C569:C586)","v":6384.6},{"$f":"SUM(D569:D586)","v":0},null,{"$f":"SUM(F569:F586)","v":1},{"$f":"SUM(G569:G586)","v":0}]
[null,"27. CRE Age Structure","Nominal (mn)","Number of CRE",null,"% Commercial Loans","% No. of CRE"]
["SM.2B.27.1","older than 1919",12.321,"ND3",null,{"$f":"IF($C$602=0,\"\",IF(C589=\"[for completion]\",\"\",IF(C589=\"\",\"\",C589/$C$602)))","v":1.9298064412597298E-3},{"$f":"IF($D$602=0,\"\",IF(D589=\"[for completion]\",\"\",IF(D589=\"\",\"\",D589/$D$602)))","v":""}]
["SM.2B.27.2","1919 - 1945",32.285240000000002,"ND3",null,5.0567538438127E-3,""]
["SM.2B.27.3","1946 - 1960",60.220619999999997,"ND3",null,9.4322003386619994E-3,""]
["SM.2B.27.4","1961 - 1970",12.76606,"ND3",null,1.9995150407846915E-3,""]
["SM.2B.27.5","1971 - 1980",58.144080000000002,"ND3",null,9.106957236029627E-3,""]
["SM.2B.27.6","1981 - 1990",45.520470000000003,"ND3",null,7.1297537712174579E-3,""]
["SM.2B.27.7","1991 - 2000",517.87873000000002,"ND3",null,8.1114009329227216E-2,""]
["SM.2B.27.8","2001 - 2005",630.83218999999997,"ND3",null,9.8805618343964091E-2,""]
["SM.2B.27.9","2006 - 2010",505.10115999999999,"ND3",null,7.9112691506838834E-2,""]
["SM.2B.27.10","2011 - 2015",1434.5187599999999,"ND3",null,0.22468497225516762,""]
["SM.2B.27.11","2016 - 2020",2000.8798999999999,"ND3",null,0.31339265637587238,""]
["SM.2B.27.12","2021 and onwards",1074.1099200000001,"ND3",null,0.16823506551716363,""]
["SM.2B.27.13","no data","[For completion]","ND3",null,"",""]
["SM.2B.27.14","Total",{"$f":"SUM(C589:C601)","v":6384.5781299999999},{"$f":"SUM(D589:D601)","v":0},null,{"$f":"SUM(F589:F601)","v":1},{"$f":"SUM(G589:G601)","v":0}]
["OSM.2B.27.1"]
["OSM.2B.27.2"]
["OSM.2B.27.3"]
["OSM.2B.27.4"]
["OSM.2B.27.5"]
["OSM.2B.27.6"]
["OSM.2B.27.7"]
["OSM.2B.27.8"]
["OSM.2B.27.9"]
["OSM.2B.27.10"]
[null,"28. New Commercial Property","Nominal (mn)","Number of CRE",null,"% Commercial Loans","% No. of CRE"]
["SM.2B.28.1","New property","[For completion]","ND3",null,{"$f":"IF($C$618=0,\"\",IF(C614=\"[for completion]\",\"\",IF(C614=\"\",\"\",C614/$C$618)))","v":""},{"$f":"IF($D$618=0,\"\",IF(D614=\"[for completion]\",\"\",IF(D614=\"\",\"\",D614/$D$618)))","v":""}]
["SM.2B.28.2","Existing property","[For completion]","ND3",null,null,{"$f":"IF($D$618=0,\"\",IF(D615=\"[for completion]\",\"\",IF(D615=\"\",\"\",D615/$D$618)))","v":""}]
["SM.2B.28.3","other","[For completion]","ND3",null,null,{"$f":"IF($D$618=0,\"\",IF(D616=\"[for completion]\",\"\",IF(D616=\"\",\"\",D616/$D$618)))","v":""}]
["SM.2B.28.4","no data",6384.5781399999996,"ND3",null,1,{"$f":"IF($D$618=0,\"\",IF(D617=\"[for completion]\",\"\",IF(D617=\"\",\"\",D617/$D$618)))","v":""}]
["SM.2B.28.5","Total",{"$f":"SUM(C614:C617)","v":6384.5781399999996},{"$f":"SUM(D614:D617)","v":0},null,{"$f":"SUM(F614:F617)","v":1},{"$f":"SUM(G614:G617)","v":0}]
[]
[null,"29. CO2 emission related to CRE - as per national availability","Ton CO2 (per year)","Ton CO2 (LTV adjusted) (per year)",null,"kg CO2/m2 (per year)","% No. of Dwellings with no CO2 data"]
["SM.2B.29.1","Retail","[For completion]","ND3",null,"[For completion]","[For completion]"]
["SM.2B.29.2","Office",34542.9,"ND3",null,"[For completion]","[For completion]"]
["SM.2B.29.3","Hotel/Tourism",920.5,"ND3",null,"[For completion]","[For completion]"]
["SM.2B.29.4","Shopping malls",10182.9,"ND3",null,"[For completion]","[For completion]"]
["SM.2B.29.5","Industry",6399.4,"ND3",null,"[For completion]","[For completion]"]
["SM.2B.29.6","Agriculture","[For completion]","ND3",null,"[For completion]","[For completion]"]
["SM.2B.29.7","Other commercially used","[For completion]","ND3",null,"[For completion]","[For completion]"]
["SM.2B.29.8","Hospital","[For completion]","ND3",null,"[For completion]","[For completion]"]
["SM.2B.29.9","School","[For completion]","ND3",null,"[For completion]","[For completion]"]
["SM.2B.29.10","Other RE with a social relevant purpose","[For completion]","ND3",null,"[For completion]","[For completion]"]
["SM.2B.29.11","Land","[For completion]","ND3",null,"[For completion]","[For completion]"]
["SM.2B.29.12","Property developers / Bulding under construction","[For completion]","ND3",null,"[For completion]","[For completion]"]
["SM.2B.29.13","Other",0,"ND3",null,"[For completion]","[For completion]"]
["SM.2B.29.14","No data",{"$f":"SUM(C621:C633)","v":52045.700000000004},{"$f":"SUM(D621:D633)","v":0},null,null,{"$f":"IF($D$639=0,\"\",IF(D634=\"[for completion]\",\"\",IF(D634=\"\",\"\",D634/$D$639)))","v":""}]
["SM.2B.29.15","Weighted Average",null,null,null,"[For completion]",{"$f":"IF($D$639=0,\"\",IF(D635=\"[for completion]\",\"\",IF(D635=\"\",\"\",D635/$D$639)))","v":""}]
["SM.2B.29.16","Weighted Average"]
["SM.2B.29.17"]
["SM.2B.29.18"]
["SM.2B.29.19"]

{"sheet":"F2. Sustainable PS data","index":14,"n_rows":219,"n_cols":7,"rows_kept":219,"cut":false,"hidden":true,"merged":[[8,1,8,2]]}
["F2. Harmonised Transparency Template - Sustainable Public Sector Assets",{"$nulls":4},"HTT 2025"]
[]
[null,"Reporting in Domestic Currency","[Please insert currency]"]
[]
[null,"CONTENT OF TAB F2"]
[null,"1. Share of sustainable Public Sector Assets"]
[null,"2. Sustainable Public Sector Assets"]
[]
[null,"1.  Share of sustainable public sector assets in the total cover pool program"]
[null,"1. Amount of sustainable loans ","Nominal (mn)","Number of loans",null,"% Nominal (mn) to total Public Sector program","% No. of Loans to total Public Sector program"]
["SPS.1.1.1","Green  Public Sector exposures","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C11=\"[For completion]\"),\"\",C11/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D11=\"[For completion]\"),\"\",D11/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.1.2","o/w Local Communities","[For completion]","[For completion]"]
["SPS.1.1.3","o/w Hospitals","[For completion]","[For completion]"]
["SPS.1.1.4","o/w Export Credit","[For completion]","[For completion]"]
[null,"o/w other","[For completion]","[For completion]"]
["SPS.1.1.5","Social Public Sector exposures","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C16=\"[For completion]\"),\"\",C16/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D16=\"[For completion]\"),\"\",D16/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.1.6","o/w Local Communities","[For completion]","[For completion]"]
["SPS.1.1.7","o/w Hospitals","[For completion]","[For completion]"]
["SPS.1.1.8","o/w Export Credit","[For completion]","[For completion]"]
[null,"o/w other","[For completion]","[For completion]"]
["SPS.1.1.9","other ","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C21=\"[For completion]\"),\"\",C21/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D21=\"[For completion]\"),\"\",D21/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.1.10","Total sustainable Public Sector exposures",{"$f":"SUM(C11,C16,C21)","v":0},{"$f":"SUM(D11,D16,D21)","v":0},null,{"$f":"SUM(F11:F21)","v":0},{"$f":"SUM(G11:G21)","v":0}]
["OSPS.1.1.1","o/w [If relevant, please specify]"]
["OSPS.1.1.2","o/w [If relevant, please specify]"]
["OSPS.1.1.3","o/w [If relevant, please specify]"]
["OSPS.1.1.4","o/w [If relevant, please specify]"]
["OSPS.1.1.5","o/w [If relevant, please specify]"]
[]
[]
[null,"2. Type of use of sustainable loans","Nominal (mn)","Number of loans",null,"% Nominal (mn) to total Public Sector program","% No. of Loans to total Public Sector program"]
["SPS.1.2.1","Renewable energy","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C31=\"[For completion]\"),\"\",C31/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D31=\"[For completion]\"),\"\",D31/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.2.2","Energy efficiency ","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C32=\"[For completion]\"),\"\",C32/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D32=\"[For completion]\"),\"\",D32/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.2.3","Pollution prevention and control","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C33=\"[For completion]\"),\"\",C33/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D33=\"[For completion]\"),\"\",D33/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.2.4","Ecologically sustainable management of living natural resources and land use","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C34=\"[For completion]\"),\"\",C34/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D34=\"[For completion]\"),\"\",D34/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.2.5","Conservation of terrestrial and marine biodiversity ","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C35=\"[For completion]\"),\"\",C35/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D35=\"[For completion]\"),\"\",D35/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.2.6","Clean transportation/mobility","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C36=\"[For completion]\"),\"\",C36/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D36=\"[For completion]\"),\"\",D36/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.2.7","Sustainable (waste) water management","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C37=\"[For completion]\"),\"\",C37/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D37=\"[For completion]\"),\"\",D37/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.2.8","Adaptation to climate change","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C38=\"[For completion]\"),\"\",C38/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D38=\"[For completion]\"),\"\",D38/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.2.9","Environmentally efficient products and/or products, product technologies and processes suitable for the circular economy","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C39=\"[For completion]\"),\"\",C39/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D39=\"[For completion]\"),\"\",D39/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.2.10","Financially viable basic infrastructure","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C40=\"[For completion]\"),\"\",C40/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D40=\"[For completion]\"),\"\",D40/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.2.11","Access to basic social services ","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C41=\"[For completion]\"),\"\",C41/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D41=\"[For completion]\"),\"\",D41/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.2.12","Affordable housing ","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C42=\"[For completion]\"),\"\",C42/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D42=\"[For completion]\"),\"\",D42/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.2.13","Job creation, including through SME financing and microcredits ","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C43=\"[For completion]\"),\"\",C43/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D43=\"[For completion]\"),\"\",D43/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.2.14","Food security","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C44=\"[For completion]\"),\"\",C44/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D44=\"[For completion]\"),\"\",D44/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.2.15","Socio-economic development and empowerment.","[For completion]","[For completion]",null,{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$37=0,C45=\"[For completion]\"),\"\",C45/'B2. HTT Public Sector Assets'!$C$37)","v":""},{"$f":"IF(OR('B2. HTT Public Sector Assets'!$C$10=0,D45=\"[For completion]\"),\"\",D45/'B2. HTT Public Sector Assets'!$C$10)","v":""}]
["SPS.1.2.16","Total sustainable Public Sector exposures",{"$f":"SUM(C31,C36,C40)","v":0},{"$f":"SUM(D31,D36,D40)","v":0},null,{"$f":"SUM(F31:F40)","v":0},{"$f":"SUM(G31:G40)","v":0}]
[]
[null,"2. Sustainable Public Sector Assets"]
[null,"1. General Information"]
["SPS.2.1.1","Number of public sector exposures","[For completion]"]
["OSPS.2.1.1","Optional information eg, Number of borrowers"]
["OSPS.2.1.2","Optional information eg, Number of guarantors"]
["OSPS.2.1.3"]
["OSPS.2.1.4"]
["OSPS.2.1.5"]
["OSPS.2.1.6"]
["OSPS.2.1.7"]
[null,"2. Size Information","Nominal","Number of Exposures",null,"% Public Sector Assets","% No. of Exposures"]
["SPS.2.2.1","Average exposure size (000s)","[For completion]"]
[]
[null,"By buckets (mn):"]
["SPS.2.2.2","TBC at a country level","[For completion]","[For completion]",null,{"$f":"IF($C$77=0,\"\",IF(C62=\"[for completion]\",\"\",C62/$C$77))","v":""},{"$f":"IF($D$77=0,\"\",IF(D62=\"[for completion]\",\"\",D62/$D$77))","v":""}]
["SPS.2.2.3","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SPS.2.2.4","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SPS.2.2.5","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SPS.2.2.6","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SPS.2.2.7","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SPS.2.2.8","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SPS.2.2.9","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SPS.2.2.10","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SPS.2.2.11","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SPS.2.2.12","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SPS.2.2.13","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SPS.2.2.14","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SPS.2.2.15","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SPS.2.2.16","TBC at a country level","[For completion]","[For completion]",null,"",""]
["SPS.2.2.17","Total",{"$f":"SUM(C62:C76)","v":0},{"$f":"SUM(D62:D76)","v":0},null,{"$f":"SUM(F62:F76)","v":0},{"$f":"SUM(G62:G76)","v":0}]
[null,"3. Breakdown by Asset Type","Nominal (mn)",null,null,"% Public Sector Assets"]
["SPS.2.3.1","Loans","[For completion]",null,null,{"$f":"IF($C$82=0,\"\",IF(C79=\"[for completion]\",\"\",C79/$C$82))","v":""}]
["SPS.2.3.2","Bonds","[For completion]",null,null,{"$f":"IF($C$82=0,\"\",IF(C80=\"[for completion]\",\"\",C80/$C$82))","v":""}]
["SPS.2.3.3","Other","[For completion]",null,null,{"$f":"IF($C$82=0,\"\",IF(C81=\"[for completion]\",\"\",C81/$C$82))","v":""}]
["SPS.2.3.4","Total",{"$f":"SUM(C79:C81)","v":0},null,null,{"$f":"SUM(F79:F81)","v":0}]
["OSPS.2.3.1"]
["OSPS.2.3.2"]
["OSPS.2.3.3"]
["OSPS.2.3.4"]
["OSPS.2.3.5"]
[null,"4. Breakdown by Geography ","% Public Sector Assets"]
["SPS.2.4.1","European Union",{"$f":"SUM(C90:C116)","v":0}]
["SPS.2.4.2","Austria","[For completion]"]
["SPS.2.4.3","Belgium","[For completion]"]
["SPS.2.4.4","Bulgaria","[For completion]"]
["SPS.2.4.5","Croatia","[For completion]"]
["SPS.2.4.6","Cyprus","[For completion]"]
["SPS.2.4.7","Czechia","[For completion]"]
["SPS.2.4.8","Denmark","[For completion]"]
["SPS.2.4.9","Estonia","[For completion]"]
["SPS.2.4.10","Finland","[For completion]"]
["SPS.2.4.11","France","[For completion]"]
["SPS.2.4.12","Germany","[For completion]"]
["SPS.2.4.13","Greece","[For completion]"]
["SPS.2.4.14","Netherlands","[For completion]"]
["SPS.2.4.15","Hungary","[For completion]"]
["SPS.2.4.16","Ireland","[For completion]"]
["SPS.2.4.17","Italy","[For completion]"]
["SPS.2.4.18","Latvia","[For completion]"]
["SPS.2.4.19","Lithuania","[For completion]"]
["SPS.2.4.20","Luxembourg","[For completion]"]
["SPS.2.4.21","Malta","[For completion]"]
["SPS.2.4.22","Poland","[For completion]"]
["SPS.2.4.23","Portugal","[For completion]"]
["SPS.2.4.24","Romania","[For completion]"]
["SPS.2.4.25","Slovakia","[For completion]"]
["SPS.2.4.26","Slovenia","[For completion]"]
["SPS.2.4.27","Spain","[For completion]"]
["SPS.2.4.28","Sweden","[For completion]"]
["SPS.2.4.29","European Economic Area (not member of EU)",{"$f":"SUM(C118:C120)","v":0}]
["SPS.2.4.30","Iceland","[For completion]"]
["SPS.2.4.31","Liechtenstein","[For completion]"]
["SPS.2.4.32","Norway","[For completion]"]
["SPS.2.4.33","Other",{"$f":"SUM(C122:C132)","v":0}]
["SPS.2.4.34","Switzerland","[For completion]"]
["SPS.2.4.35","United Kingdom","[For completion]"]
["SPS.2.4.36","Australia","[For completion]"]
["SPS.2.4.37","Brazil","[For completion]"]
["SPS.2.4.38","Canada","[For completion]"]
["SPS.2.4.39","Japan","[For completion]"]
["SPS.2.4.40","Korea","[For completion]"]
["SPS.2.4.41","New Zealand","[For completion]"]
["SPS.2.4.42","Singapore","[For completion]"]
["SPS.2.4.43","US","[For completion]"]
["SPS.2.4.44","Other","[For completion]"]
["OSPS.2.4.1","o/w [If relevant, please specify]"]
["OSPS.2.4.2","o/w [If relevant, please specify]"]
["OSPS.2.4.3","o/w [If relevant, please specify]"]
["OSPS.2.4.4","o/w [If relevant, please specify]"]
["OSPS.2.4.5","o/w [If relevant, please specify]"]
["OSPS.2.4.6","o/w [If relevant, please specify]"]
["OSPS.2.4.7","o/w [If relevant, please specify]"]
["OSPS.2.4.8","o/w [If relevant, please specify]"]
["OSPS.2.4.9","o/w [If relevant, please specify]"]
["OSPS.2.4.10","o/w [If relevant, please specify]"]
[null,"5. Breakdown by regions of main country of origin","% Public Sector Assets"]
["SPS.2.5.1","TBC at a country level","[For completion]"]
["SPS.2.5.2","TBC at a country level","[For completion]"]
["SPS.2.5.3","TBC at a country level","[For completion]"]
["SPS.2.5.4","TBC at a country level","[For completion]"]
["SPS.2.5.5","TBC at a country level","[For completion]"]
["SPS.2.5.6","TBC at a country level","[For completion]"]
["SPS.2.5.7","TBC at a country level","[For completion]"]
["SPS.2.5.8","TBC at a country level","[For completion]"]
["SPS.2.5.9","TBC at a country level","[For completion]"]
["SPS.2.5.10","TBC at a country level","[For completion]"]
["SPS.2.5.11","TBC at a country level","[For completion]"]
["SPS.2.5.12","TBC at a country level","[For completion]"]
["SPS.2.5.13","TBC at a country level","[For completion]"]
["SPS.2.5.14","TBC at a country level","[For completion]"]
["SPS.2.5.15","TBC at a country level","[For completion]"]
["SPS.2.5.16","TBC at a country level","[For completion]"]
["SPS.2.5.17","TBC at a country level","[For completion]"]
["SPS.2.5.18","TBC at a country level","[For completion]"]
["SPS.2.5.19","TBC at a country level","[For completion]"]
["SPS.2.5.20","TBC at a country level","[For completion]"]
["SPS.2.5.21","TBC at a country level","[For completion]"]
["SPS.2.5.22","TBC at a country level","[For completion]"]
["SPS.2.5.23","TBC at a country level","[For completion]"]
["SPS.2.5.24","TBC at a country level","[For completion]"]
["SPS.2.5.25","TBC at a country level","[For completion]"]
[null,"6. Breakdown by Interest Rate","% Public Sector Assets"]
["SPS.2.6.1","Fixed rate","[For completion]"]
["SPS.2.6.2","Floating rate","[For completion]"]
["SPS.2.6.3","Other","[For completion]"]
["OSPS.2.6.1"]
["OSPS.2.6.2"]
["OSPS.2.6.3"]
["OSPS.2.6.4"]
[null,"7. Breakdown by Repayment Type","% Public Sector Assets"]
["SPS.2.7.1","Bullet / interest only","[For completion]"]
["SPS.2.7.2","Amortising","[For completion]"]
["SPS.2.7.3","Other","[For completion]"]
["OSPS.2.7.1"]
["OSPS.2.7.2"]
["OSPS.2.7.3"]
["OSPS.2.7.4"]
["OSPS.2.7.5"]
["OSPS.2.7.6"]
[null,"8. Breakdown by Type of Debtor","Nominal (mn)",null,null,"% Public Sector Assets"]
["SPS.2.8.1","Sovereigns","[For completion]",null,null,{"$f":"IF($C$192=0,\"\",IF(C188=\"[for completion]\",\"\",C188/$C$192))","v":""}]
["SPS.2.8.2","Regional/federal authorities","[For completion]",null,null,{"$f":"IF($C$192=0,\"\",IF(C189=\"[for completion]\",\"\",C189/$C$192))","v":""}]
["SPS.2.8.3","Local/municipal authorities ","[For completion]",null,null,{"$f":"IF($C$192=0,\"\",IF(C190=\"[for completion]\",\"\",C190/$C$192))","v":""}]
["SPS.2.8.4","Others","[For completion]",null,null,{"$f":"IF($C$192=0,\"\",IF(C191=\"[for completion]\",\"\",C191/$C$192))","v":""}]
["SPS.2.8.5","Total",{"$f":"SUM(C188:C191)","v":0},null,null,{"$f":"SUM(F188:F191)","v":0}]
["OSPS.2.8.1","o/w Claim against supranational",null,null,null,{"$f":"IF($C$192=0,\"\",IF(C193=\"[for completion]\",\"\",C193/$C$192))","v":""}]
["OSPS.2.8.2","o/w Claim against sovereigns",null,null,null,""]
["OSPS.2.8.3","o/w Claim guaranteed by sovereigns",null,null,null,""]
["OSPS.2.8.4","o/w Claim against regional/federal authorities",null,null,null,""]
["OSPS.2.8.5","o/w Claim guaranteed by regional/federal authorities",null,null,null,""]
["OSPS.2.8.6","o/w Claim against local/municipal authorities ",null,null,null,""]
["OSPS.2.8.7","o/w Claimguaranteed by local/municipal authorities ",null,null,null,""]
["OSPS.2.8.8"]
["OSPS.2.8.9"]
["OSPS.2.8.10"]
["OSPS.2.8.11"]
["OSPS.2.8.12"]
["OSPS.2.8.13"]
[null,"9. Non-Performing Loans","% Public Sector Assets"]
["SPS.2.9.1","% NPLs","[For completion]"]
["OSPS.2.9.1","Defaulted Loans pursuant Art 178 CRR","[For completion]"]
["OSPS.2.9.2"]
["OSPS.2.9.3"]
["OSPS.2.9.4"]
[null,"10. Concentration Risks","% Public Sector Assets"]
["SPS.2.10.1","10 largest exposures","[For completion]"]
["OSPS.2.10.1"]
["OSPS.2.10.2"]
["OSPS.2.10.3"]
["OSPS.2.10.4"]
["OSPS.2.10.5"]
["OSPS.2.10.6"]

{"sheet":"G1. Crisis M Payment Holidays","index":15,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[12,4,12,5],[12,6,12,7],[14,1,14,3],[19,1,19,3],[0,0,0,1],[4,4,4,5],[6,1,6,2],[6,4,6,7],[7,1,7,2],[7,4,11,7],[8,1,8,2],[9,1,9,2],[10,1,10,2]]}
["This addendum is optional"]
["G1. Crisis Mortgage Payment Holidays",{"$nulls":4},"HTT 2025"]
[]
[]
[null,"Reporting in Domestic Currency","[Please insert currency]",null,"For further information concerning the nation-specific dispositions regarging the impact of the Covid 19 outbreak on cover pools, please refer to the:",null,"COVID-19: EMF-ECBC Response"]
[{"$nulls":4},"https://hypo.org/emf/market-initiative/covid-19-emf-ecbc-response/","https://hypo.org/emf/market-initiative/covid-19-emf-ecbc-response/"]
[null,"CONTENT OF Temporary Tab",null,null,"Optional further information at issuer/country level"]
[null,"1.  Share of assets affected by payment holidays caused by COVID 19",null,null,"[For completion]"]
[null,"2. Additional information on the cover pool section affected by payment holidays"]
[]
[]
[]
[{"$nulls":4},"Can the COVID-19 related payment holiday loans remain part of the cover pool?     ",null,"[YES/NO] (cancel what is not relevant)"]
[]
[null,"1.  Share of cover assets affected at the time of reporting by payment holidays caused exclusively by COVID 19"]
[null,"1. Breakdown of payment holiday","Nominal (mn)","Number of loans",null,"% Nominal (mn) to total cover pool ","% No. of Loans to total cover pool"]
["COV.1.1.1","payment holiday granted","[For completion]","[For completion]",null,{"$f":"IF(OR('B1. HTT Mortgage Assets'!$C$15=0,C17=\"[For completion]\"),\"\",C17/'B1. HTT Mortgage Assets'!$C$15)","v":""},{"$f":"IF(OR('B1. HTT Mortgage Assets'!$F$28=0,D17=\"[For completion]\"),\"\",D17/'B1. HTT Mortgage Assets'!$F$28)","v":""}]
["OCOV.1.1.2"]
["OCOV.1.1.3"]
[null,"2. Additional information on the cover pool section affected by payment holidays"]
[null,"1. types of granted payment holiday (original duration)","1 month","2 months","3 months","4 to 6 months","over 6 months","total"]
[null,"in % nominal (mn) of affected notional amount to total cover pool"]
["COV.2.1.1","principal & interest deferred ","[For completion]","[For completion]","[For completion]","[For completion]","[For completion]",{"$f":"SUM(C23:G23)","v":0}]
["COV.2.1.2","principal deferred","[For completion]","[For completion]","[For completion]","[For completion]","[For completion]",{"$f":"SUM(C24:G24)","v":0}]
["COV.2.1.3","other","[For completion]","[For completion]","[For completion]","[For completion]","[For completion]",{"$f":"SUM(C25:G25)","v":0}]
["COV.2.1.4","Total payment holiday",{"$f":"SUM(C23:C25)+SUM(C27:C32)","v":0},{"$f":"SUM(D23:D25)+SUM(D27:D32)","v":0},{"$f":"SUM(E23:E25)+SUM(E27:E32)","v":0},{"$f":"SUM(F23:F25)+SUM(F27:F32)","v":0},{"$f":"SUM(G23:G25)+SUM(G27:G32)","v":0},{"$f":"SUM(H23:H25)","v":0}]
["OCOV.2.1.5","[please insert here mortgages with extended moratoria]",{"$nulls":5},{"$f":"IF(SUM(C27:G27)=\"\",\"\",SUM(C27:G27))","v":0}]
["OCOV.2.1.6","[please insert here mortgages with extended moratoria]",{"$nulls":5},{"$f":"IF(SUM(C28:G28)=\"\",\"\",SUM(C28:G28))","v":0}]
["OCOV.2.1.7","[please insert here mortgages with extended moratoria]",{"$nulls":5},{"$f":"IF(SUM(C29:G29)=\"\",\"\",SUM(C29:G29))","v":0}]
["OCOV.2.1.8","[please insert here mortgages with extended moratoria]",{"$nulls":5},{"$f":"IF(SUM(C30:G30)=\"\",\"\",SUM(C30:G30))","v":0}]
["OCOV.2.1.9","[please insert here mortgages with extended moratoria]"]
["OCOV.2.1.10","[please insert here mortgages with extended moratoria]"]

{"sheet":"E.g. General","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"E.g. Other","index":17,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}