{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Référentiel","Introduction","Disclaimer","FAQ","A. HTT General","B1. HTT Mortgage Assets","B2. HTT Public Sector Assets","B3. HTT Shipping Assets","C. HTT Harmonised Glossary","E. Optional ECB-ECAIs data","Temp. Optional COVID 19 impact"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":19,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Référentiel","index":0,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Bucket"]
["0 - 1 Y",12]
["1 - 2 Y",24]
["2 - 3 Y",36]
["3 - 4 Y",48]
["4 - 5 Y",60]
["5 - 10 Y",120]
["10+ Y",400]
[]
["o/w 0-0.5y",6]
["o/w 0.5-1 y",12]
["o/w 1-1.5y",18]
["o/w 1.5-2 y",24]
[]
[]
["regions / departments / federal states"]
["municipalities"]
["autres"]
[]
["Expositions directes sur les personnes publiques"]
["Expositions garanties à 100% par des personnes publiques"]

{"sheet":"Introduction","index":1,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,4,5,6],[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]]}
[]
[]
[]
[]
[null,null,null,null,null,"Harmonised Transparency Template"]
[null,null,null,null,"2020 Version"]
[null,null,null,null,null,"France"]
[null,null,null,null,null,"Arkéa Public Sector SCF"]
[null,null,null,null,null,"Reporting Date: 30/6/2020"]
[null,null,null,null,null,"Cut-off Date: 30/6/2020"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Index"]
[]
[null,null,null,"Worksheet A: HTT General","Tab 1: Harmonised Transparency Template"]
[]
[null,null,null,"Worksheet B1: HTT Mortgage Assets"]
[]
[null,null,null,"Worksheet B2: HTT Public Sector Assets","Tab 1: Harmonised Transparency Template"]
[]
[null,null,null,"Worksheet B3: HTT Shipping Assets","Tab 1: Harmonised Transparency Template"]
[]
[null,null,null,"Worksheet C: HTT Harmonised Glossary","Tab 1: Harmonised Transparency Template"]
[]
[null,null,null,"Covered Bond Label Disclaimer","Tab 1: Harmonised Transparency Template"]
[]
[null,null,null,"Worksheet D & Onwards (If Any): National Transparency Template"]
[]
[null,null,null,"Worksheet E: Optional ECB-ECAIs data"]

{"sheet":"Disclaimer","index":2,"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":"FAQ","index":3,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,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; or (iii) not available at the present time; issuers are kindly requested to include ND1, ND2 or ND3 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 covered 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]\" the sum of the amounts shall be the same. 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. "]

{"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 ",null,null,null,null,"HTT 2020"]
[]
[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. References to Capital Requirements Regulation (CRR) 129(7)"]
[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","France"]
["G.1.1.2","Issuer Name","Arkéa Public Sector SCF"]
["G.1.1.3","Link to Issuer's Website","http://www.arkea.com/banque/assurance/credit/mutuel/ecb_5040/fr/public-sector-scf"]
["G.1.1.4","Cut-off date",44012]
["OG.1.1.1","Optional information e.g. Contact names"]
["OG.1.1.2","Optional information e.g. Parent name"]
["OG.1.1.3"]
["OG.1.1.4"]
["OG.1.1.5"]
["OG.1.1.6"]
["OG.1.1.7"]
["OG.1.1.8"]
[null,"2. Regulatory Summary"]
["G.2.1.1","UCITS Compliance (Y/N)","Y"]
["G.2.1.2","CRR Compliance (Y/N)","Y"]
["G.2.1.3","LCR status","https://coveredbondlabel.com/issuer/81/pool/89/"]
["OG.2.1.1"]
["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",2597.0670252300001]
["G.3.1.2","Outstanding Covered Bonds",2077.6]
["OG.3.1.1","Cover Pool Size [NPV] (mn)"]
["OG.3.1.2","Outstanding Covered Bonds [NPV] (mn)"]
["OG.3.1.3"]
["OG.3.1.4"]
[null,"2. Over-collateralisation (OC) ","Legal / Regulatory","Actual",null,"Minimum Committed","Purpose"]
["G.3.2.1","OC (%)",0.05,{"$f":"IF(OR(C38=\"[For completion]\",C39=\"[For completion]\"),\"Please complete G.3.1.1 and G.3.1.2\",(C38/C39-1))","v":0.25003226089237596},null,0.25,"Minimum OC imposed by the rating agencies for a AAA rating programme"]
["OG.3.2.1","Optional information e.g. Asset Coverage Test (ACT)"]
["OG.3.2.2","Optional information e.g. OC (NPV basis)"]
["OG.3.2.3"]
["OG.3.2.4"]
["OG.3.2.5"]
["OG.3.2.6"]
[null,"3. Cover Pool Composition","Nominal (mn)",null,null,"% Cover Pool"]
["G.3.3.1","Mortgages",null,null,null,{"$f":"IF($C$58=0,\"\",IF(C53=\"[for completion]\",\"\",C53/$C$58))","v":0}]
["G.3.3.2","Public Sector ",2597.0670252300001,null,null,{"$f":"IF($C$58=0,\"\",IF(C54=\"[for completion]\",\"\",C54/$C$58))","v":1}]
["G.3.3.3","Shipping",null,null,null,{"$f":"IF($C$58=0,\"\",IF(C55=\"[for completion]\",\"\",C55/$C$58))","v":0}]
["G.3.3.4","Substitute Assets",null,null,null,0]
["G.3.3.5","Other",null,null,null,{"$f":"IF($C$58=0,\"\",IF(C57=\"[for completion]\",\"\",C57/$C$58))","v":0}]
["G.3.3.6","Total",{"$f":"SUM(C53:C57)","v":2597.0670252300001},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)",8.6947360906646285,7.6686574381234971]
[]
[null,"Residual Life (mn)"]
[null,"By buckets:"]
["G.3.4.2","0 - 1 Y",200.92878265491228,243.05799402502751,null,{"$f":"IF($C$77=0,\"\",IF(C70=\"[for completion]\",\"\",C70/$C$77))","v":7.7367577431008319E-2},{"$f":"IF($D$77=0,\"\",IF(D70=\"[Mark as ND1 if not relevant]\",\"\",D70/$D$77))","v":9.3589419269294316E-2}]
["G.3.4.3","1 - 2 Y",212.91870268629634,246.82327369341027,null,8.1984293135760666E-2,{"$f":"IF($D$77=0,\"\",IF(D71=\"[Mark as ND1 if not relevant]\",\"\",D71/$D$77))","v":9.5039239255524183E-2}]
["G.3.4.4","2 - 3 Y",193.79578954567194,220.79941618081273,null,7.4621020221025097E-2,8.5018759486814838E-2]
["G.3.4.5","3 - 4 Y",205.50589434567962,224.47808322172784,null,7.9129993141026353E-2,8.643522930269297E-2]
["G.3.4.6","4 - 5 Y",181.73514216875313,195.51125567408883,null,6.9977070969590965E-2,7.5281559664581069E-2]
["G.3.4.7","5 - 10 Y",736.95633469022823,741.60649154537725,null,0.28376485207369262,0.28555539244236477]
["G.3.4.8","10+ Y",865.22635958132298,724.79050373402526,null,0.33315519302789598,0.27908040057872785]
["G.3.4.9","Total",{"$f":"SUM(C70:C76)","v":2597.0670056728645},{"$f":"SUM(D70:D76)","v":2597.0670180744696},null,{"$f":"SUM(F70:F76)","v":1},{"$f":"SUM(G70:G76)","v":1}]
["OG.3.4.1","o/w 0-1 day",0,0,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":0}]
["OG.3.4.2","o/w 0-0.5y",98.24983093477347,120.31959507185769,null,{"$f":"IF($C$77=0,\"\",IF(C79=\"[for completion]\",\"\",C79/$C$77))","v":3.7831072791022685E-2},4.6329029722562046E-2]
["OG.3.4.3","o/w 0.5-1 y",102.67895172013883,122.73839895316982,null,3.9536504639985641E-2,4.726038954673227E-2]
["OG.3.4.4","o/w 1-1.5y",108.08473855814951,126.01288722690117,null,4.1618001507876472E-2,4.8521230430291426E-2]
["OG.3.4.5","o/w 1.5-2 y",104.83396412814683,120.8103864665091,null,4.0366291627884195E-2,4.6518008825232757E-2]
["OG.3.4.6"]
["OG.3.4.7"]
["OG.3.4.8"]
["OG.3.4.9",null,null,null,null,0,0]
["OG.3.4.10",null,null,null,null,0,0]
[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)",8.2234148376331664,10.974003466204506]
[]
[null,"Maturity (mn)"]
["G.3.5.2","By buckets:"]
["G.3.5.3","0 - 1 Y",0,0,null,{"$f":"IF($C$100=0,\"\",IF(C93=\"[for completion]\",\"\",IF(C93=\"\",\"\",C93/$C$100)))","v":0},{"$f":"IF($D$100=0,\"\",IF(D93=\"[Mark as ND1 if not relevant]\",\"\",IF(D93=\"\",\"\",D93/$D$100)))","v":0}]
["G.3.5.4","1 - 2 Y",740.6,740.6,null,{"$f":"IF($C$100=0,\"\",IF(C94=\"[for completion]\",\"\",IF(C94=\"\",\"\",C94/$C$100)))","v":0.35646900269541781},{"$f":"IF($D$100=0,\"\",IF(D94=\"[Mark as ND1 if not relevant]\",\"\",IF(D94=\"\",\"\",D94/$D$100)))","v":0.35646900269541781}]
["G.3.5.5","2 - 3 Y",0,0,null,0,0]
["G.3.5.6","3 - 4 Y",0,0,null,0,0]
["G.3.5.7","4 - 5 Y",0,0,null,0,0]
["G.3.5.8","5 - 10 Y",120,120,null,5.7758952637658838E-2,5.7758952637658838E-2]
["G.3.5.9","10+ Y",1217,1217,null,0.58577204466692345,0.58577204466692345]
["G.3.5.10","Total",{"$f":"SUM(C93:C99)","v":2077.6},{"$f":"SUM(D93:D99)","v":2077.6},null,{"$f":"SUM(F93:F99)","v":1},{"$f":"SUM(G93:G99)","v":1}]
["OG.3.5.1","o/w 0-1 day",0,0,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":0}]
["OG.3.5.2","o/w 0-0.5y",0,0,null,0,0]
["OG.3.5.3","o/w 0.5-1 y",0,0,null,0,0]
["OG.3.5.4","o/w 1-1.5y",740.6,740.6,null,0.35646900269541781,0.35646900269541781]
["OG.3.5.5","o/w 1.5-2 y",0,0,null,0,0]
["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",{"$f":"C77","v":2597.0670056728645},{"$f":"D77","v":2597.0670180744696},null,{"$f":"IF($C$129=0,\"\",IF(C112=\"[for completion]\",\"\",IF(C112=\"\",\"\",C112/$C$129)))","v":1},{"$f":"IF($D$129=0,\"\",IF(D112=\"[for completion]\",\"\",IF(D112=\"\",\"\",D112/$D$129)))","v":1},null,null,null,null,"curre"]
["G.3.6.2","AUD",null,null,null,{"$f":"IF($C$129=0,\"\",IF(C113=\"[for completion]\",\"\",IF(C113=\"\",\"\",C113/$C$129)))","v":""},{"$f":"IF($D$129=0,\"\",IF(D113=\"[for completion]\",\"\",IF(D113=\"\",\"\",D113/$D$129)))","v":""},null,null,null,null,"AUD"]
["G.3.6.3","BRL",null,null,null,"","",null,null,null,null,"BRL"]
["G.3.6.4","CAD",null,null,null,"","",null,null,null,null,"CAD"]
["G.3.6.5","CHF",null,null,null,"","",null,null,null,null,"CHF"]
["G.3.6.6","CZK",null,null,null,"","",null,null,null,null,"CZK"]
["G.3.6.7","DKK",null,null,null,"","",null,null,null,null,"DKK"]
["G.3.6.8","GBP",null,null,null,"","",null,null,null,null,"GBP"]
["G.3.6.9","HKD",null,null,null,"","",null,null,null,null,"HKD"]
["G.3.6.10","JPY",null,null,null,{"$f":"IF($C$129=0,\"\",IF(C121=\"[for completion]\",\"\",IF(C121=\"\",\"\",C121/$C$129)))","v":""},{"$f":"IF($D$129=0,\"\",IF(D121=\"[for completion]\",\"\",IF(D121=\"\",\"\",D121/$D$129)))","v":""}]
["G.3.6.11","KRW",null,null,null,"","",null,null,null,null,"KRW"]
["G.3.6.12","NOK",null,null,null,"","",null,null,null,null,"NOK"]
["G.3.6.13","PLN",null,null,null,"","",null,null,null,null,"PLN"]
["G.3.6.14","SEK",null,null,null,"","",null,null,null,null,"SEK"]
["G.3.6.15","SGD",null,null,null,"","",null,null,null,null,"SGD"]
["G.3.6.16","USD",null,null,null,{"$f":"IF($C$129=0,\"\",IF(C127=\"[for completion]\",\"\",IF(C127=\"\",\"\",C127/$C$129)))","v":""},{"$f":"IF($D$129=0,\"\",IF(D127=\"[for completion]\",\"\",IF(D127=\"\",\"\",D127/$D$129)))","v":""},null,null,null,null,"USD"]
["G.3.6.17","Other",null,null,null,"",""]
["G.3.6.18","Total",{"$f":"SUM(C112:C128)","v":2597.0670056728645},{"$f":"SUM(D112:D128)","v":2597.0670180744696},null,{"$f":"SUM(F112:F128)","v":1},{"$f":"SUM(G112:G128)","v":1}]
["OG.3.6.1","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$129=0,\"\",IF(C130=\"[for completion]\",\"\",IF(C130=\"\",\"\",C130/$C$129)))","v":""},{"$f":"IF($D$129=0,\"\",IF(D130=\"[for completion]\",\"\",IF(D130=\"\",\"\",D130/$D$129)))","v":""}]
["OG.3.6.2","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$129=0,\"\",IF(C131=\"[for completion]\",\"\",C131/$C$129))","v":0},{"$f":"IF($D$129=0,\"\",IF(D131=\"[for completion]\",\"\",D131/$D$129))","v":0}]
["OG.3.6.3","o/w [If relevant, please specify]",null,null,null,0,0]
["OG.3.6.4","o/w [If relevant, please specify]",null,null,null,0,0]
["OG.3.6.5","o/w [If relevant, please specify]",null,null,null,0,0]
["OG.3.6.6","o/w [If relevant, please specify]",null,null,null,0,0]
["OG.3.6.7","o/w [If relevant, please specify]",null,null,null,0,0]
[null,"7. Covered Bonds - Currency ","Nominal [before hedging] (mn)","Nominal [after hedging] (mn)",null,"% Total [before]","% Total [after]"]
["G.3.7.1","EUR",{"$f":"C100","v":2077.6},{"$f":"D100","v":2077.6},null,{"$f":"IF($C$155=0,\"\",IF(C138=\"[for completion]\",\"\",IF(C138=\"\",\"\",C138/$C$155)))","v":1},{"$f":"IF($D$155=0,\"\",IF(D138=\"[for completion]\",\"\",IF(D138=\"\",\"\",D138/$D$155)))","v":1}]
["G.3.7.2","AUD",null,null,null,{"$f":"IF($C$155=0,\"\",IF(C139=\"[for completion]\",\"\",IF(C139=\"\",\"\",C139/$C$155)))","v":""},{"$f":"IF($D$155=0,\"\",IF(D139=\"[for completion]\",\"\",IF(D139=\"\",\"\",D139/$D$155)))","v":""}]
["G.3.7.3","BRL",null,null,null,"",""]
["G.3.7.4","CAD",null,null,null,"",""]
["G.3.7.5","CHF",null,null,null,"",""]
["G.3.7.6","CZK",null,null,null,"",""]
["G.3.7.7","DKK",null,null,null,"",""]
["G.3.7.8","GBP",null,null,null,"",""]
["G.3.7.9","HKD",null,null,null,"",""]
["G.3.7.10","JPY",null,null,null,{"$f":"IF($C$155=0,\"\",IF(C147=\"[for completion]\",\"\",IF(C147=\"\",\"\",C147/$C$155)))","v":""},{"$f":"IF($D$155=0,\"\",IF(D147=\"[for completion]\",\"\",IF(D147=\"\",\"\",D147/$D$155)))","v":""}]
["G.3.7.11","KRW",null,null,null,{"$f":"IF($C$155=0,\"\",IF(C148=\"[for completion]\",\"\",IF(C148=\"\",\"\",C148/$C$155)))","v":""},{"$f":"IF($D$155=0,\"\",IF(D148=\"[for completion]\",\"\",IF(D148=\"\",\"\",D148/$D$155)))","v":""}]
["G.3.7.12","NOK",null,null,null,"",""]
["G.3.7.13","PLN",null,null,null,"",""]
["G.3.7.14","SEK",null,null,null,"",""]
["G.3.7.15","SGD",null,null,null,"",""]
["G.3.7.16","USD",null,null,null,"",""]
["G.3.7.17","Other",null,null,null,"",""]
["G.3.7.18","Total",{"$f":"SUM(C138:C154)","v":2077.6},{"$f":"SUM(D138:D154)","v":2077.6},null,{"$f":"SUM(F138:F154)","v":1},{"$f":"SUM(G138:G154)","v":1}]
["OG.3.7.1","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$155=0,\"\",IF(C156=\"[for completion]\",\"\",IF(C156=\"\",\"\",C156/$C$155)))","v":""},{"$f":"IF($D$155=0,\"\",IF(D156=\"[for completion]\",\"\",IF(D156=\"\",\"\",D156/$D$155)))","v":""}]
["OG.3.7.2","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$155=0,\"\",IF(C157=\"[for completion]\",\"\",IF(C157=\"\",\"\",C157/$C$155)))","v":""},{"$f":"IF($D$155=0,\"\",IF(D157=\"[for completion]\",\"\",IF(D157=\"\",\"\",D157/$D$155)))","v":""}]
["OG.3.7.3","o/w [If relevant, please specify]",null,null,null,"",""]
["OG.3.7.4","o/w [If relevant, please specify]",null,null,null,"",""]
["OG.3.7.5","o/w [If relevant, please specify]",null,null,null,"",""]
["OG.3.7.6","o/w [If relevant, please specify]",null,null,null,"",""]
["OG.3.7.7","o/w [If relevant, please specify]",null,null,null,"",""]
[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",2077.6,{"$f":"C164","v":2077.6},null,{"$f":"IF($C$167=0,\"\",IF(C164=\"[for completion]\",\"\",IF(C164=\"\",\"\",C164/$C$167)))","v":1},{"$f":"IF($D$167=0,\"\",IF(D164=\"[for completion]\",\"\",IF(D164=\"\",\"\",D164/$D$167)))","v":1}]
["G.3.8.2","Floating coupon",null,null,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",null,null,null,"",""]
["G.3.8.4","Total",{"$f":"SUM(C164:C166)","v":2077.6},{"$f":"SUM(D164:D166)","v":2077.6},null,{"$f":"SUM(F164:F166)","v":1},{"$f":"SUM(G164:G166)","v":1}]
["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",0,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)",0,null,null,{"$f":"IF($C$179=0,\"\",IF(C175=\"[for completion]\",\"\",C175/$C$179))","v":""}]
["G.3.9.3","Exposures to central banks",0]
["G.3.9.4","Exposures to credit institutions",0,null,null,{"$f":"IF($C$179=0,\"\",IF(C177=\"[for completion]\",\"\",C177/$C$179))","v":""}]
["G.3.9.5","Other",0,null,null,""]
["G.3.9.6","Total",{"$f":"SUM(C174:C178)","v":0},null,null,{"$f":"SUM(F174:F178)","v":0}]
["OG.3.9.1","o/w EU gvts or quasi govts",null,null,null,""]
["OG.3.9.2","o/w third-party countries  Credit Quality Step 1 (CQS1) gvts or quasi govts",null,null,null,""]
["OG.3.9.3","o/w third-party countries Credit Quality Step 2 (CQS2) gvts or quasi govts",null,null,null,""]
["OG.3.9.4","o/w EU central banks",null,null,null,""]
["OG.3.9.5","o/w third-party countries Credit Quality Step 1 (CQS1) central banks",null,null,null,""]
["OG.3.9.6","o/w third-party countries Credit Quality Step 2 (CQS2) central banks",null,null,null,""]
["OG.3.9.7","o/w CQS1 credit institutions",null,null,null,""]
["OG.3.9.8","o/w CQS2 credit institutions",null,null,null,""]
["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)",0,null,null,{"$f":"IF($C$208=0,\"\",IF(C193=\"[for completion]\",\"\",C193/$C$208))","v":""}]
["G.3.10.2","Eurozone",0,null,null,""]
["G.3.10.3","Rest of European Union (EU)",0,null,null,""]
["G.3.10.4","European Economic Area (not member of EU)",0,null,null,""]
["G.3.10.5","Switzerland",0,null,null,""]
["G.3.10.6","Australia",0,null,null,""]
["G.3.10.7","Brazil",0,null,null,""]
["G.3.10.8","Canada",0,null,null,""]
["G.3.10.9","Japan",0,null,null,""]
["G.3.10.10","Korea",0,null,null,""]
["G.3.10.11","New Zealand",0,null,null,""]
["G.3.10.12","Singapore",0,null,null,""]
["G.3.10.13","US",0,null,null,""]
["G.3.10.14","Other",0,null,null,""]
["G.3.10.15","Total EU",0]
["G.3.10.16","Total",{"$f":"SUM(C193:C206)","v":0},null,null,{"$f":"SUM(F193:F206)","v":0}]
["OG.3.10.1","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$208=0,\"\",IF(C209=\"[for completion]\",\"\",C209/$C$208))","v":""}]
["OG.3.10.2","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$208=0,\"\",IF(C210=\"[for completion]\",\"\",C210/$C$208))","v":""}]
["OG.3.10.3","o/w [If relevant, please specify]",null,null,null,""]
["OG.3.10.4","o/w [If relevant, please specify]",null,null,null,""]
["OG.3.10.5","o/w [If relevant, please specify]",null,null,null,""]
["OG.3.10.6","o/w [If relevant, please specify]",null,null,null,""]
["OG.3.10.7","o/w [If relevant, please specify]",null,null,null,""]
[null,"11. Liquid Assets ","Nominal (mn)",null,null,"% Cover Pool","% Covered Bonds"]
["G.3.11.1","Substitute and other marketable assets",0,null,null,{"$f":"IF($C$38=0,\"\",IF(C217=\"[for completion]\",\"\",IF(C217=\"\",\"\",C217/$C$38)))","v":0},{"$f":"IF($C$39=0,\"\",IF(C217=\"[for completion]\",\"\",IF(C217=\"\",\"\",C217/$C$39)))","v":0}]
["G.3.11.2","Central bank eligible assets",0,null,null,{"$f":"IF($C$38=0,\"\",IF(C218=\"[for completion]\",\"\",IF(C218=\"\",\"\",C218/$C$38)))","v":0},{"$f":"IF($C$39=0,\"\",IF(C218=\"[for completion]\",\"\",IF(C218=\"\",\"\",C218/$C$39)))","v":0}]
["G.3.11.3","Other",0,null,null,0,0]
["G.3.11.4","Total",{"$f":"SUM(C217:C219)","v":0},null,null,{"$f":"SUM(F217:F219)","v":0},{"$f":"SUM(G217:G219)","v":0}]
["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 ","https://coveredbondlabel.com/issuer/81/pool/89/"]
[null,"13. Derivatives & Swaps"]
["G.3.13.1","Derivatives in the register / cover pool [notional] (mn)",0]
["G.3.13.2","Type of interest rate swaps (intra-group, external or both)",0]
["G.3.13.3","Type of currency rate swaps (intra-group, external or both)",0]
["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"]
["OG.3.13.6"]
["OG.3.13.7"]
["OG.3.13.8"]
["OG.3.13.9"]
["OG.3.13.10"]
["OG.3.13.11"]
["OG.3.13.12"]
["OG.3.13.13"]
["OG.3.13.14"]
["OG.3.13.15"]
["OG.3.13.16"]
["OG.3.13.17"]
["OG.3.13.18"]
["OG.3.13.19"]
["OG.3.13.20"]
["OG.3.13.21"]
["OG.3.13.22"]
["OG.3.13.23"]
["OG.3.13.24"]
["OG.3.13.25"]
["OG.3.13.26"]
["OG.3.13.27"]
["OG.3.13.28"]
["OG.3.13.29"]
["OG.3.13.30"]
["OG.3.13.31"]
["OG.3.13.32"]
["OG.3.13.33"]
["OG.3.13.34"]
["OG.3.13.35"]
["OG.3.13.36"]
["OG.3.13.37"]
["OG.3.13.38"]
["OG.3.13.39"]
["OG.3.13.40"]
["OG.3.13.41"]
["OG.3.13.42"]
["OG.3.13.43"]
["OG.3.13.44"]
["OG.3.13.45"]
["OG.3.13.46"]
["OG.3.13.47"]
["OG.3.13.48"]
["OG.3.13.49"]
["OG.3.13.50"]
["OG.3.13.51"]
[null,"4. References to Capital Requirements Regulation (CRR) 129(7) ","Row","Row"]
["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 129(7) of the Capital Requirements Regulation (EU) 648/2012. It should be noted, however, that"]
["whether or not exposures in the form of covered bonds are eligible to preferential treatment under Regulation (EU) 648/2012 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","(i)         Value of the cover pool outstanding covered bonds: ",{"$f":"ROW(B38)","v":38}]
["G.4.1.2","(i)         Value of covered bonds: ",{"$f":"ROW(B39)","v":39}]
["G.4.1.3","(ii)        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.4","(ii)        Type of cover assets:",{"$f":"ROW(B52)","v":52}]
["G.4.1.5","(ii)        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'!B287 )& \" for Commercial Mortgage Assets\",\"\")","v":"287 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"}]
["G.4.1.6","            (ii)        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"}]
["G.4.1.7","(ii)        Currency risk - cover pool:",{"$f":"ROW(B111)","v":111}]
["G.4.1.8","          (ii)         Interest rate risk - covered bond:",{"$f":"ROW(B163)","v":163}]
["G.4.1.9","(ii)        Currency risk - covered bond:",{"$f":"ROW(B137)","v":137}]
["G.4.1.10","(Please refer to \"Tab D. HTT Harmonised Glossary\" for hedging strategy)",{"$f":"ROW('C. HTT Harmonised Glossary'!B17)&\" for Harmonised Glossary\"","v":"17 for Harmonised Glossary"}]
["G.4.1.11","(iii)        Maturity structure of cover assets: ",{"$f":"ROW(B65)","v":65}]
["G.4.1.12","(iii)        Maturity structure of covered bonds: ",{"$f":"ROW(B88)","v":88}]
["G.4.1.13","(iv)        Percentage of loans more than ninety days past due:",{"$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"}]
["OG.4.1.1"]
["OG.4.1.2"]
["OG.4.1.3"]
["OG.4.1.4"]
["OG.4.1.5"]
["OG.4.1.6"]
["OG.4.1.7"]
["OG.4.1.8"]
["OG.4.1.9"]
["OG.4.1.10"]
[null,"5. References to Capital Requirements Regulation (CRR) 129(1)"]
["G.5.1.1","Exposure to credit institute credit quality step 1 & 2",0]
["OG.5.1.1"]
["OG.5.1.2"]
["OG.5.1.3"]
["OG.5.1.4"]
["OG.5.1.5"]
["OG.5.1.6"]
[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":387,"n_cols":7,"rows_kept":387,"cut":false,"hidden":false,"merged":[]}
["B1. Harmonised Transparency Template - Mortgage Assets",null,null,null,null,"HTT 2020"]
[]
[null,"Reporting in Domestic Currency","[Please insert currency]"]
[]
[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",{"$f":"SUM('B2. HTT Public Sector Assets'!C22:C26)","v":2597.0670252299997},null,null,{"$f":"IF($C$15=0,\"\",IF(C12=\"[for completion]\",\"\",C12/$C$15))","v":1}]
["M.7.1.2","Commercial","[For completion]",null,null,{"$f":"IF($C$15=0,\"\",IF(C13=\"[for completion]\",\"\",C13/$C$15))","v":""}]
["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":2597.0670252299997},null,null,{"$f":"SUM(F12:F14)","v":1}]
["OM.7.1.1","o/w Housing Cooperatives / Multi-family assets",null,null,null,{"$f":"IF($C$15=0,\"\",IF(C16=\"[for completion]\",\"\",C16/$C$15))","v":0}]
["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",null,"[For completion]",null,{"$f":"SUM('B2. HTT Public Sector Assets'!D22:D26)","v":1754}]
["OM.7.2.1","Optional information eg, Number of borrowers"]
["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,"[For completion]"]
["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:C72)","v":0},{"$f":"SUM(D45:D72)","v":0},null,{"$f":"SUM(F45:F72)","v":0}]
["M.7.4.2","Austria","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.3","Belgium","[For completion]","[For completion]",null,"[For completion]"]
["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","Czech Republic","[For completion]","[For completion]",null,"[For completion]"]
["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","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.12","Germany","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.13","Greece","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.14","Netherlands","[For completion]","[For completion]",null,"[For completion]"]
["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]","[For completion]",null,"[For completion]"]
["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","United Kingdom","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.30","European Economic Area (not member of EU)",{"$f":"SUM(C74:C76)","v":0},{"$f":"SUM(D74:D76)","v":0},null,{"$f":"SUM(F74:F76)","v":0}]
["M.7.4.31","Iceland","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.32","Liechtenstein","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.33","Norway","[For completion]","[For completion]",null,"[For completion]"]
["M.7.4.34","Other",{"$f":"SUM(C78:C87)","v":0},{"$f":"SUM(D78:D87)","v":0},null,{"$f":"SUM(F78:F87)","v":0}]
["M.7.4.35","Switzerland","[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 main country of origin","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["M.7.5.1","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.2","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.3","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.4","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.5","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.6","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.7","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.8","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.9","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.10","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.11","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.12","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.13","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.14","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.15","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["M.7.5.16","TBC at a country level","[For completion]","[For completion]",null,"[For completion]"]
["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","[For completion]","[For completion]",null,"[For completion]"]
["M.7.6.2","Floating rate","[For completion]","[For completion]",null,"[For completion]"]
["M.7.6.3","Other","[For completion]","[For completion]",null,"[For completion]"]
["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","[For completion]","[For completion]",null,"[For completion]"]
["M.7.7.2","Amortising","[For completion]","[For completion]",null,"[For completion]"]
["M.7.7.3","Other","[For completion]","[For completion]",null,"[For completion]"]
["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","[For completion]","[For completion]",null,"[For completion]"]
["M.7.8.2","≥  12 - ≤ 24 months","[For completion]","[For completion]",null,"[For completion]"]
["M.7.8.3","≥ 24 - ≤ 36 months","[For completion]","[For completion]",null,"[For completion]"]
["M.7.8.4","≥ 36 - ≤ 60 months","[For completion]","[For completion]",null,"[For completion]"]
["M.7.8.5","≥ 60 months","[For completion]","[For completion]",null,"[For completion]"]
["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]","[For completion]",null,"[For completion]"]
["OM.7.9.1"]
["OM.7.9.2"]
["OM.7.9.3"]
["OM.7.9.4"]
[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)","[For completion]"]
[]
[null,"By buckets (mn):"]
["M.7A.10.2","TBC at a country level","[For completion]","[For completion]",null,{"$f":"IF($C$214=0,\"\",IF(C190=\"[for completion]\",\"\",IF(C190=\"\",\"\",C190/$C$214)))","v":""},{"$f":"IF($D$214=0,\"\",IF(D190=\"[for completion]\",\"\",IF(D190=\"\",\"\",D190/$D$214)))","v":""}]
["M.7A.10.3","TBC at a country level","[For completion]","[For completion]",null,{"$f":"IF($C$214=0,\"\",IF(C191=\"[for completion]\",\"\",IF(C191=\"\",\"\",C191/$C$214)))","v":""},{"$f":"IF($D$214=0,\"\",IF(D191=\"[for completion]\",\"\",IF(D191=\"\",\"\",D191/$D$214)))","v":""}]
["M.7A.10.4","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.5","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7A.10.6","TBC at a country level","[For completion]","[For completion]",null,"",""]
["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":0},{"$f":"SUM(D190:D213)","v":0},null,{"$f":"SUM(F190:F213)","v":0},{"$f":"SUM(G190:G213)","v":0}]
[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 (%)","[For completion]"]
[]
[null,"By LTV buckets (mn):"]
["M.7A.11.2",">0 - <=40 %","[For completion]","[For completion]",null,{"$f":"IF($C$227=0,\"\",IF(C219=\"[for completion]\",\"\",C219/$C$227))","v":""},{"$f":"IF($D$227=0,\"\",IF(D219=\"[for completion]\",\"\",D219/$D$227))","v":""}]
["M.7A.11.3",">40 - <=50 %","[For completion]","[For completion]",null,"",""]
["M.7A.11.4",">50 - <=60 %","[For completion]","[For completion]",null,"",""]
["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":0},{"$f":"SUM(D219:D226)","v":0},null,{"$f":"SUM(F219:F226)","v":0},{"$f":"SUM(G219:G226)","v":0}]
["OM.7A.11.1","o/w >100 - <=110 %",null,null,null,"",""]
["OM.7A.11.2","o/w >110 - <=120 %",null,null,null,"",""]
["OM.7A.11.3","o/w >120 - <=130 %",null,null,null,"",""]
["OM.7A.11.4","o/w >130 - <=140 %",null,null,null,"",""]
["OM.7A.11.5","o/w >140 - <=150 %",null,null,null,"",""]
["OM.7A.11.6","o/w >150 %",null,null,null,"",""]
["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 (%)","[Mark as ND1 if not relevant]"]
[]
[null,"By LTV buckets (mn):"]
["M.7A.12.2",">0 - <=40 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",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 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,{"$f":"IF($C$249=0,\"\",IF(C242=\"[Mark as ND1 if not relevant]\",\"\",C242/$C$249))","v":""},{"$f":"IF($D$249=0,\"\",IF(D242=\"[Mark as ND1 if not relevant]\",\"\",D242/$D$249))","v":""}]
["M.7A.12.4",">50 - <=60 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["M.7A.12.5",">60 - <=70 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["M.7A.12.6",">70 - <=80 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["M.7A.12.7",">80 - <=90 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["M.7A.12.8",">90 - <=100 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["M.7A.12.9",">100%","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",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","[For completion]"]
["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","Agricultural","[For completion]"]
["M.7A.13.5","Other","[For completion]"]
["OM.7A.13.1","o/w Subsidised housing"]
["OM.7A.13.2","o/w Private rental"]
["OM.7A.13.3","o/w Multi-family housing "]
["OM.7A.13.4","o/w Buildings under construction "]
["OM.7A.13.5","o/w Buildings land"]
["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]"]
["OM.7A.13.11","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,"7B Commercial Cover Pool"]
[null,"15. Loan Size Information","Nominal","Number of Loans",null,"% Commercial Loans","% No. of Loans"]
["M.7B.15.1","Average loan size (000s)","[For completion]"]
[]
[null,"By buckets (mn):"]
["M.7B.15.2","TBC at a country level","[For completion]","[For completion]",null,{"$f":"IF($C$315=0,\"\",IF(C291=\"[for completion]\",\"\",C291/$C$315))","v":""},{"$f":"IF($D$315=0,\"\",IF(D291=\"[for completion]\",\"\",D291/$D$315))","v":""}]
["M.7B.15.3","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.4","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.5","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.6","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.7","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.8","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.9","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.10","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.11","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.12","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.13","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.14","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.15","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.16","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.17","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.18","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.19","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.20","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.21","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.22","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.23","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.24","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.25","TBC at a country level","[For completion]","[For completion]",null,"",""]
["M.7B.15.26","Total",{"$f":"SUM(C291:C314)","v":0},{"$f":"SUM(D291:D314)","v":0},null,{"$f":"SUM(F291:F314)","v":0},{"$f":"SUM(G291:G314)","v":0}]
[null,"16. Loan to Value (LTV) Information - UNINDEXED ","Nominal","Number of Loans",null,"% Commercial Loans","% No. of Loans"]
["M.7B.16.1","Weighted Average LTV (%)","[For completion]"]
[]
[null,"By LTV buckets (mn):"]
["M.7B.16.2",">0 - <=40 %","[For completion]","[For completion]",null,{"$f":"IF($C$328=0,\"\",IF(C320=\"[for completion]\",\"\",C320/$C$328))","v":""},{"$f":"IF($D$328=0,\"\",IF(D320=\"[for completion]\",\"\",D320/$D$328))","v":""}]
["M.7B.16.3",">40 - <=50 %","[For completion]","[For completion]",null,{"$f":"IF($C$328=0,\"\",IF(C321=\"[for completion]\",\"\",C321/$C$328))","v":""},{"$f":"IF($D$328=0,\"\",IF(D321=\"[for completion]\",\"\",D321/$D$328))","v":""}]
["M.7B.16.4",">50 - <=60 %","[For completion]","[For completion]",null,"",""]
["M.7B.16.5",">60 - <=70 %","[For completion]","[For completion]",null,"",""]
["M.7B.16.6",">70 - <=80 %","[For completion]","[For completion]",null,"",""]
["M.7B.16.7",">80 - <=90 %","[For completion]","[For completion]",null,"",""]
["M.7B.16.8",">90 - <=100 %","[For completion]","[For completion]",null,"",""]
["M.7B.16.9",">100%","[For completion]","[For completion]",null,"",""]
["M.7B.16.10","Total",{"$f":"SUM(C320:C327)","v":0},{"$f":"SUM(D320:D327)","v":0},null,{"$f":"SUM(F320:F327)","v":0},{"$f":"SUM(G320:G327)","v":0}]
["OM.7B.16.1","o/w >100 - <=110 %",null,null,null,"",""]
["OM.7B.16.2","o/w >110 - <=120 %",null,null,null,"",""]
["OM.7B.16.3","o/w >120 - <=130 %",null,null,null,"",""]
["OM.7B.16.4","o/w >130 - <=140 %",null,null,null,"",""]
["OM.7B.16.5","o/w >140 - <=150 %",null,null,null,"",""]
["OM.7B.16.6","o/w >150 %",null,null,null,"",""]
["OM.7B.16.7"]
["OM.7B.16.8"]
["OM.7B.16.9"]
[null,"17. Loan to Value (LTV) Information - INDEXED","Nominal","Number of Loans",null,"% Commercial Loans","% No. of Loans"]
["M.7B.17.1","Weighted Average LTV (%)","[Mark as ND1 if not relevant]"]
[]
[null,"By LTV buckets (mn):"]
["M.7B.17.2",">0 - <=40 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,{"$f":"IF($C$350=0,\"\",IF(C342=\"[Mark as ND1 if not relevant]\",\"\",C342/$C$350))","v":""},{"$f":"IF($D$350=0,\"\",IF(D342=\"[Mark as ND1 if not relevant]\",\"\",D342/$D$350))","v":""}]
["M.7B.17.3",">40 - <=50 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,{"$f":"IF($C$350=0,\"\",IF(C343=\"[Mark as ND1 if not relevant]\",\"\",C343/$C$350))","v":""},{"$f":"IF($D$350=0,\"\",IF(D343=\"[Mark as ND1 if not relevant]\",\"\",D343/$D$350))","v":""}]
["M.7B.17.4",">50 - <=60 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["M.7B.17.5",">60 - <=70 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["M.7B.17.6",">70 - <=80 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["M.7B.17.7",">80 - <=90 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["M.7B.17.8",">90 - <=100 %","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["M.7B.17.9",">100%","[Mark as ND1 if not relevant]","[Mark as ND1 if not relevant]",null,"",""]
["M.7B.17.10","Total",{"$f":"SUM(C342:C349)","v":0},{"$f":"SUM(D342:D349)","v":0},null,{"$f":"SUM(F342:F349)","v":0},{"$f":"SUM(G342:G349)","v":0}]
["OM.7B.17.1","o/w >100 - <=110 %",null,null,null,{"$f":"IF($C$350=0,\"\",IF(C351=\"[for completion]\",\"\",C351/$C$350))","v":""},{"$f":"IF($D$350=0,\"\",IF(D351=\"[for completion]\",\"\",D351/$D$350))","v":""}]
["OM.7B.17.2","o/w >110 - <=120 %",null,null,null,"",""]
["OM.7B.17.3","o/w >120 - <=130 %",null,null,null,"",""]
["OM.7B.17.4","o/w >130 - <=140 %",null,null,null,"",""]
["OM.7B.17.5","o/w >140 - <=150 %",null,null,null,"",""]
["OM.7B.17.6","o/w >150 %",null,null,null,"",""]
["OM.7B.17.7"]
["OM.7B.17.8"]
["OM.7B.17.9"]
[null,"18. Breakdown by Type","% Commercial loans"]
["M.7B.18.1","Retail","[For completion]"]
["M.7B.18.2","Office","[For completion]"]
["M.7B.18.3","Hotel/Tourism","[For completion]"]
["M.7B.18.4","Shopping malls","[For completion]"]
["M.7B.18.5","Industry","[For completion]"]
["M.7B.18.6","Agriculture","[For completion]"]
["M.7B.18.7","Other commercially used","[For completion]"]
["M.7B.18.8","Land","[For completion]"]
["M.7B.18.9","Property developers / Bulding under construction","[For completion]"]
["M.7B.18.10","Other","[For completion]"]
["OM.7B.18.1","o/w Social & Cultural purposes"]
["OM.7B.18.2","o/w [If relevant, please specify]"]
["OM.7B.18.3","o/w [If relevant, please specify]"]
["OM.7B.18.4","o/w [If relevant, please specify]"]
["OM.7B.18.5","o/w [If relevant, please specify]"]
["OM.7B.18.6","o/w [If relevant, please specify]"]
["OM.7B.18.7","o/w [If relevant, please specify]"]
["OM.7B.18.8","o/w [If relevant, please specify]"]
["OM.7B.18.9","o/w [If relevant, please specify]"]
["OM.7B.18.10","o/w [If relevant, please specify]"]
["OM.7B.18.11","o/w [If relevant, please specify]"]
["OM.7B.18.12","o/w [If relevant, please specify]"]
["OM.7B.18.13","o/w [If relevant, please specify]"]
["OM.7B.18.14","o/w [If relevant, please specify]"]
["OM.7B.18.15","o/w [If relevant, please specify]"]
["OM.7B.18.16","o/w [If relevant, please specify]"]
["OM.7B.18.17","o/w [If relevant, please specify]"]

{"sheet":"B2. HTT Public Sector Assets","index":6,"n_rows":179,"n_cols":7,"rows_kept":179,"cut":false,"hidden":false,"merged":[]}
["B2. Harmonised Transparency Template - Public Sector Assets",null,null,null,null,"HTT 2020"]
[]
[null,"Reporting in Domestic Currency","EUR"]
[]
[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",982]
["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)",2644.6711051222001]
[]
[null,"By buckets (mn):"]
["PS.8.2.2","0-0.5",167.71980628999998,1101,null,{"$f":"IF($C$37=0,\"\",IF(C22=\"[for completion]\",\"\",C22/$C$37))","v":6.4580468913830402E-2},{"$f":"IF($D$37=0,\"\",IF(D22=\"[for completion]\",\"\",D22/$D$37))","v":0.62770809578107178}]
["PS.8.2.3","0.5-1",145.40253959,204,null,{"$f":"IF($C$37=0,\"\",IF(C23=\"[for completion]\",\"\",C23/$C$37))","v":5.5987211025916035E-2},{"$f":"IF($D$37=0,\"\",IF(D23=\"[for completion]\",\"\",D23/$D$37))","v":0.11630558722919042}]
["PS.8.2.4","1-5",707.14259942000001,285,null,0.27228507872544205,0.16248574686431014]
["PS.8.2.5","5-10",807.10917501999995,112,null,0.31077718332992244,6.385404789053592E-2]
["PS.8.2.6","10-50",769.69290490999992,52,null,0.29637005800488914,2.9646522234891677E-2]
["PS.8.2.7","50-100",null,null,null,0,0]
["PS.8.2.8",">100",null,null,null,0,0]
["PS.8.2.9",null,null,null,null,0,0]
["PS.8.2.10",null,null,null,null,0,0]
["PS.8.2.11",null,null,null,null,0,0]
["PS.8.2.12",null,null,null,null,0,0]
["PS.8.2.13",null,null,null,null,0,0]
["PS.8.2.14",null,null,null,null,0,0]
["PS.8.2.15",null,null,null,null,0,0]
["PS.8.2.16",null,null,null,null,0,0]
["PS.8.2.17","Total",{"$f":"SUM(C22:C36)","v":2597.0670252299997},{"$f":"SUM(D22:D36)","v":1754},null,{"$f":"SUM(F22:F36)","v":1},{"$f":"SUM(G22:G36)","v":1}]
[null,"3. Breakdown by Asset Type","Nominal (mn)",null,null,"% Public Sector Assets"]
["PS.8.3.1","Loans",{"$f":"'A. HTT General'!C38","v":2597.0670252300001},null,null,{"$f":"IF($C$42=0,\"\",IF(C39=\"[for completion]\",\"\",C39/$C$42))","v":1}]
["PS.8.3.2","Bonds",0,null,null,{"$f":"IF($C$42=0,\"\",IF(C40=\"[for completion]\",\"\",C40/$C$42))","v":0}]
["PS.8.3.3","Other",0,null,null,{"$f":"IF($C$42=0,\"\",IF(C41=\"[for completion]\",\"\",C41/$C$42))","v":0}]
["PS.8.3.4","Total",{"$f":"SUM(C39:C41)","v":2597.0670252300001},null,null,{"$f":"SUM(F39:F41)","v":1}]
["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:C77)","v":1}]
["PS.8.4.2","Austria"]
["PS.8.4.3","Belgium"]
["PS.8.4.4","Bulgaria"]
["PS.8.4.5","Croatia"]
["PS.8.4.6","Cyprus"]
["PS.8.4.7","Czech Republic"]
["PS.8.4.8","Denmark"]
["PS.8.4.9","Estonia"]
["PS.8.4.10","Finland"]
["PS.8.4.11","France",1]
["PS.8.4.12","Germany"]
["PS.8.4.13","Greece"]
["PS.8.4.14","Netherlands"]
["PS.8.4.15","Hungary"]
["PS.8.4.16","Ireland"]
["PS.8.4.17","Italy"]
["PS.8.4.18","Latvia"]
["PS.8.4.19","Lithuania"]
["PS.8.4.20","Luxembourg"]
["PS.8.4.21","Malta"]
["PS.8.4.22","Poland"]
["PS.8.4.23","Portugal"]
["PS.8.4.24","Romania"]
["PS.8.4.25","Slovakia"]
["PS.8.4.26","Slovenia"]
["PS.8.4.27","Spain"]
["PS.8.4.28","Sweden"]
["PS.8.4.29","United Kingdom"]
["PS.8.4.30","European Economic Area (not member of EU)",{"$f":"SUM(C79:C81)","v":0}]
["PS.8.4.31","Iceland"]
["PS.8.4.32","Liechtenstein"]
["PS.8.4.33","Norway"]
["PS.8.4.34","Other",{"$f":"SUM(C83:C92)","v":0}]
["PS.8.4.35","Switzerland"]
["PS.8.4.36","Australia"]
["PS.8.4.37","Brazil"]
["PS.8.4.38","Canada"]
["PS.8.4.39","Japan"]
["PS.8.4.40","Korea"]
["PS.8.4.41","New Zealand"]
["PS.8.4.42","Singapore"]
["PS.8.4.43","US"]
["PS.8.4.44","Other"]
["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","Alsace - Champagne-Ardenne - Lorraine",3.8014555724605201E-2]
["PS.8.5.2","Aquitaine - Limousin - Poitou-Charentes",0.119092216103349]
["PS.8.5.3","Auvergne - Rhône-Alpes",8.0954562454470802E-2]
["PS.8.5.4","Bourgogne - Franche-Comté",3.5395110325626297E-2]
["PS.8.5.5","Bretagne",0.17260739326336]
["PS.8.5.6","Centre - Val de Loire",8.1996891121283496E-3]
["PS.8.5.7","Corse",2.2186334985159901E-4]
["PS.8.5.8","Ile-de-France",0.183240518643662]
["PS.8.5.9","Languedoc-Roussillon - Midi-Pyrénées",7.1655739595580498E-2]
["PS.8.5.10","Nord-Pas-de-Calais - Picardie",0.108503500270001]
["PS.8.5.11","Normandie",4.4755562198495399E-2]
["PS.8.5.12","Pays de la Loire",3.8461292689320498E-2]
["PS.8.5.13","Provence-Alpes-Côte d'Azur",9.8820986262468796E-2]
["PS.8.5.14","Départements d'Outre-Mer",7.7010018632306198E-5]
["PS.8.5.15","Territoires d'Outre-Mer",0]
["PS.8.5.16"]
["PS.8.5.17"]
["PS.8.5.18"]
["PS.8.5.19"]
["PS.8.5.20"]
["PS.8.5.21"]
["PS.8.5.22"]
["PS.8.5.23"]
["PS.8.5.24"]
["PS.8.5.25"]
[null,"6. Breakdown by Interest Rate","% Public Sector Assets"]
["PS.8.6.1","Fixed rate",0.46045016456897403]
["PS.8.6.2","Floating rate",0.53954983543102597]
["PS.8.6.3","Other",{"$f":"1-C131-C130","v":0}]
["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",0]
["PS.8.7.2","Amortising",1]
["PS.8.7.3","Other",0]
["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",{"$error":"#VALUE!"},null,null,{"$f":"IF($C$152=0,\"\",IF(C148=\"[for completion]\",\"\",C148/$C$152))","v":{"$error":"#VALUE!"}}]
["PS.8.8.2","Regional/federal authorities",{"$f":"C156+C157","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF($C$152=0,\"\",IF(C149=\"[for completion]\",\"\",C149/$C$152))","v":{"$error":"#VALUE!"}}]
["PS.8.8.3","Local/municipal authorities ",{"$f":"C158+C159","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF($C$152=0,\"\",IF(C150=\"[for completion]\",\"\",C150/$C$152))","v":{"$error":"#VALUE!"}}]
["PS.8.8.4","Others",{"$error":"#VALUE!"},null,null,{"$f":"IF($C$152=0,\"\",IF(C151=\"[for completion]\",\"\",C151/$C$152))","v":{"$error":"#VALUE!"}}]
["PS.8.8.5","Total",{"$f":"SUM(C148:C151)","v":{"$error":"#VALUE!"}},null,null,{"$f":"SUM(F148:F151)","v":{"$error":"#VALUE!"}}]
["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":{"$error":"#VALUE!"}}]
["OPS.8.8.2","o/w Claim against sovereigns",null,null,null,{"$f":"IF($C$152=0,\"\",IF(C154=\"[for completion]\",\"\",C154/$C$152))","v":{"$error":"#VALUE!"}}]
["OPS.8.8.3","o/w Claim guaranteed by sovereigns",null,null,null,{"$error":"#VALUE!"}]
["OPS.8.8.4","o/w Claim against regional/federal authorities",{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
["OPS.8.8.5","o/w Claim guaranteed by regional/federal authorities",{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
["OPS.8.8.6","o/w Claim against local/municipal authorities ",{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
["OPS.8.8.7","o/w Claimguaranteed by local/municipal authorities ",{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
["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"]
["PS.8.9.1","% NPLs",0]
["OPS.8.9.1"]
["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",0.20038223004811045]
["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":211,"n_cols":7,"rows_kept":211,"cut":false,"hidden":false,"merged":[]}
["B3. Harmonised Transparency Template - Shipping Assets",null,null,null,null,"HTT 2020"]
[]
[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:C54)","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","Czech Republic","[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","United Kingdom","[For completion]"]
["S.9.3.30","European Economic Area (not member of EU)",{"$f":"SUM(C56:C58)","v":0}]
["S.9.3.31","Iceland","[For completion]"]
["S.9.3.32","Liechtenstein","[For completion]"]
["S.9.3.33","Norway","[For completion]"]
["S.9.3.34","Other",{"$f":"SUM(C60:C69)","v":0}]
["S.9.3.35","Switzerland","[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"]
["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,"",""]
["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,{"$f":"IF($C$179=0,\"\",IF(C172=\"[Mark as ND1 if not relevant]\",\"\",C172/$C$179))","v":""},{"$f":"IF($D$179=0,\"\",IF(D172=\"[Mark as ND1 if not relevant]\",\"\",D172/$D$179))","v":""}]
["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"]
["S.9.11.1","TBC at a country level","[For completion]"]
["S.9.11.2","TBC at a country level","[For completion]"]
["S.9.11.3","TBC at a country level","[For completion]"]
["S.9.11.4","TBC at a country level","[For completion]"]
["S.9.11.5","TBC at a country level","[For completion]"]
["S.9.11.6","TBC at a country level","[For completion]"]
["S.9.11.7","TBC at a country level","[For completion]"]
["S.9.11.8","TBC at a country level","[For completion]"]
["S.9.11.9","TBC at a country level","[For completion]"]
["S.9.11.10","TBC at a country level","[For completion]"]
["S.9.11.11","TBC at a country level","[For completion]"]
["S.9.11.12","TBC at a country level","[For completion]"]
["S.9.11.13","TBC at a country level","[For completion]"]
["S.9.11.14","TBC at a country level","[For completion]"]
["S.9.11.15","TBC at a country level","[For completion]"]
["S.9.11.16","TBC at a country level","[For completion]"]
["S.9.11.17","TBC at a country level","[For completion]"]
["OS.9.11.1"]
["OS.9.11.2"]
["OS.9.11.3"]
["OS.9.11.4"]
["OS.9.11.5"]

{"sheet":"C. HTT Harmonised Glossary","index":8,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["C. Harmonised Transparency Template - Glossary",null,"HTT 2020"]
[]
["The definitions below reflect the national specificities"]
[]
["Field Number","1. Glossary - Standard Harmonised Items","Definition"]
["HG.1.1","OC Calculation: Actual","[For completion]"]
["HG.1.2","OC Calculation: Legal minimum","[For completion]"]
["HG.1.3","OC Calculation: Committed","[For completion]"]
["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","LTVs: Definition","[For completion]"]
["HG.1.8","LTVs: Calculation of property/shipping value"]
["HG.1.9","LTVs: Applied property/shipping valuation techniques, including whether use of index, Automated Valuation Model (AVM) or on-site audits"]
["HG.1.10","LTVs: Frequency and time of last valuation"]
["HG.1.11","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.12","Hedging Strategy (please explain how you address interest rate and currency risk)","[For completion]"]
["HG.1.13","Non-performing loans","[For completion]"]
["OHG.1.1","NPV assumptions (when stated)"]
["OHG.1.2"]
["OHG.1.3"]
["OHG.1.4"]
["OHG.1.5"]
[null,"2. Reason for No Data","Value"]
["HG.2.1","Not applicable for the jurisdiction ","ND1"]
["HG.2.2","Not relevant for the issuer and/or CB programme at the present time","ND2"]
["HG.2.3","Not available at the present time","ND3"]
["OHG.2.1"]
["OHG.2.2"]
["OHG.2.3"]
[null,"3. Glossary - Extra national and/or Issuer Items","Definition"]
["HG.3.1","Other definitions deemed relevant","[For completion]"]
["OHG.3.1"]
["OHG.3.2"]
["OHG.3.3"]
["OHG.3.4"]
["OHG.3.5"]

{"sheet":"E. Optional ECB-ECAIs data","index":9,"n_rows":90,"n_cols":10,"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",null,null,null,null,"HTT 2020"]
[]
[null,"Reporting in Domestic Currency","EUR",null,null,null,null,null," Reason for No Data in Worksheet E. ","Value"]
[null,null,null,null,null,null,null,null,"Not applicable for the jurisdiction ","ND1"]
[null,"CONTENT OF TAB E",null,null,null,null,null,null,"Not relevant for the issuer and/or CB programme at the present time","ND2"]
[null,"1. Additional information on the programme",null,null,null,null,null,null,"Not available at the present time","ND3"]
[null,"2.  Additional information on the swaps",null,null,null,null,null,null,"Confidential","ND4"]
[null,"3.  Additional information on the asset distribution"]
[null,null,null,null,null,null,null,null,"* Legal Entity Identifier (LEI) finder: http://www.lei-lookup.com/#!search"]
[null,null,null,null,null,null,null,null,"** Weighted Average Maturity = Remaining Term to Maturity"]
["Field Number","1.  Additional information on the programme"]
[null,"Transaction Counterparties","Name","Legal Entity Identifier (LEI)*"]
["E.1.1.1","Sponsor (if applicable)","[For completion]","[For completion]"]
["E.1.1.2","Servicer ","[For completion]","[For completion]"]
["E.1.1.3","Back-up servicer","[For completion]","[For completion]"]
["E.1.1.4","BUS facilitator","[For completion]","[For completion]"]
["E.1.1.5","Cash manager ","[For completion]","[For completion]"]
["E.1.1.6","Back-up cash manager","[For completion]","[For completion]"]
["E.1.1.7","Account bank","[For completion]","[For completion]"]
["E.1.1.8","Standby account bank","[For completion]","[For completion]"]
["E.1.1.9","Account bank guarantor","[For completion]","[For completion]"]
["E.1.1.10","Trustee","[For completion]","[For completion]"]
["E.1.1.11","Cover Pool Monitor","[For completion]","[For completion]"]
["OE.1.1.1"]
["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","Counterparty 2","[For completion]","[For completion]","[For completion]"]
["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 (months)",65.780363514119898]
["E.3.1.2","Weighted Average Maturity (months)**",194.09966898838078]
["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","[For completion]","[For completion]","[For completion]","[For completion]","[For completion]"]
["E.3.2.2","30-<60 days","[For completion]","[For completion]","[For completion]","[For completion]","[For completion]"]
["E.3.2.3","60-<90 days","[For completion]","[For completion]","[For completion]","[For completion]","[For completion]"]
["E.3.2.4","90-<180 days","[For completion]","[For completion]","[For completion]","[For completion]","[For completion]"]
["E.3.2.5",">= 180 days","[For completion]","[For completion]","[For completion]","[For completion]","[For completion]"]
["OE.3.2.1"]
["OE.3.2.2"]
["OE.3.2.3"]
["OE.3.2.4"]

{"sheet":"Temp. Optional COVID 19 impact","index":10,"n_rows":30,"n_cols":8,"rows_kept":30,"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"]
["Temporary tab Harmonised Transparency Template - Optional COVID 19 impact",null,null,null,null,"HTT 2020"]
[]
[]
[null,"Reporting in Domestic Currency","EUR",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"]
[]
[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,"YES"]
[null,"2. Additional information on the cover pool section affected by payment holidays"]
[]
[]
[]
[null,null,null,null,"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",473.2,757,null,{"$f":"IF(OR('B1. HTT Mortgage Assets'!$C$15=0,C17=\"[For completion]\"),\"\",C17/'B1. HTT Mortgage Assets'!$C$15)","v":0.18220554009694562},{"$f":"IF(OR('B1. HTT Mortgage Assets'!$F$28=0,D17=\"[For completion]\"),\"\",D17/'B1. HTT Mortgage Assets'!$F$28)","v":0.4315849486887115}]
["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 ",7.959844708083834E-4,6.6141560284431033E-3,3.8987544910179639E-5,3.7913207140718519E-3,1.8387226586826351E-2,{"$f":"SUM(C23:G23)","v":2.9627675345059869E-2}]
["COV.2.1.2","principal deferred",7.443218764970061E-4,6.3060209461077736E-3,3.6112205838323351E-5,3.576840723053888E-3,1.8387226586826351E-2,{"$f":"SUM(C24:G24)","v":2.9050522338323344E-2}]
["COV.2.1.3","other",0,0,0,0,0,0]
["COV.2.1.4","Total payment holiday",{"$f":"SUM(C23:C25)","v":1.5403063473053895E-3},{"$f":"SUM(D23:D25)","v":1.2920176974550876E-2},{"$f":"SUM(E23:E25)","v":7.509975074850299E-5},7.3681614371257399E-3,3.6774453173652702E-2,{"$f":"SUM(H23)","v":2.9627675345059869E-2}]
["OCOV.2.1.5","o/w [if relevant, please specify]",null,null,null,null,null,{"$f":"IF(SUM(C27:G27)=\"\",\"\",SUM(C27:G27))","v":0}]
["OCOV.2.1.6","o/w [if relevant, please specify]",null,null,null,null,null,{"$f":"IF(SUM(C28:G28)=\"\",\"\",SUM(C28:G28))","v":0}]
["OCOV.2.1.7","o/w [if relevant, please specify]",null,null,null,null,null,0]
["OCOV.2.1.8","o/w [if relevant, please specify]",null,null,null,null,null,0]