{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Disclaimer","Param","Introduction","A. HTT General","B1. HTT Mortgage Assets","B2. HTT Public Sector Assets","C. HTT Harmonised Glossary","E. Optional ECB-ECAIs data"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":7,"comments":1,"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":"Disclaimer","index":0,"n_rows":169,"n_cols":1,"rows_kept":169,"cut":false,"hidden":false,"merged":[]}
["Disclaimer - Important notices "]
[]
[]
["(i) The Product Information displayed on this Site has been uploaded by the Issuers of the relevant Products. None of the information displayed on this Site shall form the basis of any contract. Any User of this Site will be required to acknowledge that it has not relied on, or been induced to enter into any contract by, any representation or warranty."]
["(ii) The Covered Bond Label Foundation has not independently verified the Product Information displayed on this Site. Accordingly, no representation, warranty or undertaking, express or implied, is made, and no responsibility is accepted, by the Covered Bond Label Foundation as to or in relation to the accuracy or completeness or otherwise of such Product Information.\""]
["(iii) The information provided on or accessible through the Site is not intended for distribution to, or use by, any person or entity in any jurisdiction where such distribution or use would be contrary to local law, or which would subject us or any Issuer, to any authorisation, registration or other requirement within such jurisdiction. You agree not to use or export the information or materials available on or through this Site in violation of laws in your jurisdiction."]
[]
["TERMS OF USE"]
["This website www.coveredbondlabel.com (the \"Site\") is owned and operated by the Covered Bond Label Foundation (the Covered Bond Label Foundation together with its affiliates, \"we\" or \"us\") a Private Foundation (fondation privée / private stichting) registered in Belgium; whose registered office is at Avenue de Cortenbergh 71, B-1000, 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 the Daily Manager, Avenue de Cortenbergh 71, B-1000, 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":"Param","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date des données","2018-08-31",{"$f":"IF(MONTH(C2)<10,0,\"\")&MONTH(C2)","v":"08"},{"$f":"YEAR(cut_off)&\"_\"&D2","v":"2018_08"}]
[null,"Reporting date","2018-09-30"]
[null,"Cut-off date",{"$f":"C3","v":"2018-09-30"}]
[null,null,{"$f":"YEAR(NOW())&MONTH(NOW())&DAY(NOW())&\" \"&HOUR(NOW())&MINUTE(NOW())&SECOND(NOW())","v":"2018115 111639"}]
[]
[null,"Répertoire des données",{"$f":"\"U:\\4 - Gestion de la trésorerie sociale et du refinancement\\4.5 - Mobilisation de créances et CDC\\Covered Bonds\\Pool\\pool \"&E2&\"\\\"","v":"U:\\4 - Gestion de la trésorerie sociale et du refinancement\\4.5 - Mobilisation de créances et CDC\\Covered Bonds\\Pool\\pool 2018_08\\"}]
[null,"Nom du fichier source",{"$f":"\"Template ECBC SFH \"&IF(MONTH(cut_off)<10,0,\"\")&MONTH(cut_off)&RIGHT(YEAR(cut_off),2)&\" \"&C5&\".xlsx\"","v":"Template ECBC SFH 0918 2018115 111639.xlsx"}]
[null,"Nom total",{"$f":"C7&C8","v":"U:\\4 - Gestion de la trésorerie sociale et du refinancement\\4.5 - Mobilisation de créances et CDC\\Covered Bonds\\Pool\\pool 2018_08\\Template ECBC SFH 0918 2018115 111639.xlsx"}]

{"sheet":"Introduction","index":2,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[23,3,23,7],[33,3,33,7],[25,3,25,7],[27,3,27,7],[29,3,29,7],[31,3,31,7]]}
[]
[]
[]
[]
[null,null,null,null,null,"Harmonised Transparency Template"]
[]
[null,null,null,null,null,"France"]
[null,null,null,null,null,"Arkéa Home Loans SFH"]
[null,null,null,null,null,{"$f":"\"Reporting Date: \"&DAY(Param!$C$3)&\"/\"&MONTH(Param!$C$3)&\"/\"&YEAR(Param!$C$3)","v":"Reporting Date: 30/9/2018"}]
[null,null,null,null,null,{"$f":"\"Cut-off Date: \"&DAY(Param!$C$4)&\"/\"&MONTH(Param!$C$4)&\"/\"&YEAR(Param!$C$4)","v":"Cut-off Date: 30/9/2018"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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 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"]

{"sheet":"A. HTT General","index":3,"n_rows":363,"n_cols":9,"rows_kept":363,"cut":false,"hidden":false,"merged":[]}
["A. Harmonised Transparency Template - General Information"]
[]
[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,"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 Home Loans SFH"]
["G.1.1.3","Link to Issuer's Website","http://www.arkea.com/banque/assurance/credit/mutuel/ecb_5039/en/home-loans-sfh"]
["G.1.1.4","Cut-off date","2018-09-30"]
["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/87/"]
["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,"General Information","Nominal (mn)"]
["G.3.1.1","Cover Pool Size",8019.6148831999999]
["G.3.1.2","Outstanding Covered Bonds",6068.9]
["OG.3.1.1","Cover Pool Size [NPV] (mn)","ND1"]
["OG.3.1.2","Outstanding Covered Bonds [NPV] (mn)","ND1"]
["OG.3.1.3"]
["OG.3.1.4"]
[null,"Over-collateralisation (OC) ","Legal","Actual",null,"Minimum Committed","Purpose"]
["G.3.2.1","OC (%)",0.05,{"$f":"(C38-C39)/C39","v":0.32142808139860607},null,"04:19:08.349","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,"Cover Pool Composition","Nominal (mn)",null,null,"% Cover Pool"]
["G.3.3.1","Mortgages",8019.6148831999999,null,null,{"$f":"IF($C$57=0,\"\",IF(C53=\"[for completion]\",\"\",C53/$C$57))","v":1}]
["G.3.3.2","Public Sector ",null,null,null,{"$f":"IF($C$57=0,\"\",IF(C54=\"[for completion]\",\"\",C54/$C$57))","v":0}]
["G.3.3.3","Substitute Assets",null,null,null,{"$f":"IF($C$57=0,\"\",IF(C55=\"[for completion]\",\"\",C55/$C$57))","v":0}]
["G.3.3.4","Other",null,null,null,{"$f":"IF($C$57=0,\"\",IF(C56=\"[for completion]\",\"\",C56/$C$57))","v":0}]
["G.3.3.5","Total",{"$f":"SUM(C53:C56)","v":8019.6148831999999},null,null,{"$f":"SUM(F53:F56)","v":1}]
["G.3.3.6","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$57=0,\"\",IF(C58=\"[for completion]\",\"\",C58/$C$57))","v":0}]
["OG.3.3.1","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$57=0,\"\",IF(C59=\"[for completion]\",\"\",C59/$C$57))","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,"Cover Pool Amortisation Profile","Contractual (mn)","Expected Upon Prepayments (mn)",null,"% Total Contractual","% Total Expected Upon Prepayments"]
["G.3.4.1","Weighted Average life (in years)",6.224003405991275,4.4962751330987043]
[]
[null,"By buckets:"]
["G.3.4.2","0 - 1 Y",873.96275200156583,1390.5934010871756,null,{"$f":"IF($C$76=0,\"\",IF(C69=\"[for completion]\",\"\",C69/$C$76))","v":0.10897814480248906},{"$f":"IF($D$76=0,\"\",IF(D69=\"[Mark as ND1 if not relevant]\",\"\",D69/$D$76))","v":0.17339902493326467},null,12]
["G.3.4.3","1 - 2 Y",840.19895536964327,1202.3764031773899,null,0.10476799292815739,{"$f":"IF($D$76=0,\"\",IF(D70=\"[Mark as ND1 if not relevant]\",\"\",D70/$D$76))","v":0.1499294443298276},null,24]
["G.3.4.4","2 - 3 Y",791.40761680221522,1024.2093961806663,null,9.8683992726397177E-2,0.12771303997729949,null,36]
["G.3.4.5","3 - 4 Y",738.0840270627682,864.97968420397547,null,9.2034846786589936E-2,0.10785800774747813,null,48]
["G.3.4.6","4 - 5 Y",680.38828270051681,723.27205596097758,null,8.4840518230599529E-2,9.0187878906272015E-2,null,60]
["G.3.4.7","5 - 10 Y",2461.1027907175912,2042.4765839218808,null,0.30688540865887043,0.25468512062849713,null,120]
["G.3.4.8","10+ Y",1634.4704585456984,771.70735866792529,null,0.20380909586689649,{"$f":"IF($D$76=0,\"\",IF(D75=\"[Mark as ND1 if not relevant]\",\"\",D75/$D$76))","v":9.6227483477360973E-2},null,400]
["G.3.4.9","Total",{"$f":"SUM(C69:C75)","v":8019.614883199999},{"$f":"SUM(D69:D75)","v":8019.6148831999908},null,{"$f":"SUM(F69:F75)","v":1},{"$f":"SUM(G69:G75)","v":1}]
["OG.3.4.1","o/w 0-1 day",null,null,null,{"$f":"IF($C$76=0,\"\",IF(C77=\"[for completion]\",\"\",C77/$C$76))","v":0},{"$f":"IF($D$76=0,\"\",IF(D77=\"[for completion]\",\"\",D77/$D$76))","v":0}]
["OG.3.4.2","o/w 0-0.5y",null,null,null,{"$f":"IF($C$76=0,\"\",IF(C78=\"[for completion]\",\"\",C78/$C$76))","v":0},0]
["OG.3.4.3","o/w 0.5-1 y",null,null,null,0,0]
["OG.3.4.4","o/w 1-1.5y",null,null,null,0,0]
["OG.3.4.5","o/w 1.5-2 y",null,null,null,0,0]
["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,"Maturity of Covered Bonds","Initial Maturity (mn)","Extended Maturity (mn)",null,"% Total Initial Maturity","% Total Extended Maturity"]
["G.3.5.1","Weighted Average life (in years)",7.4464949716313233,7.6936567307639487]
[]
["G.3.5.2","By buckets:"]
["G.3.5.3","0 - 1 Y",10,10,null,{"$f":"IF($C$98=0,\"\",IF(C91=\"[for completion]\",\"\",C91/$C$98))","v":1.64774506088418E-3},{"$f":"IF($D$98=0,\"\",IF(D91=\"[Mark as ND1 if not relevant]\",\"\",D91/$D$98))","v":1.64774506088418E-3}]
["G.3.5.4","1 - 2 Y",0,0,null,{"$f":"IF($C$98=0,\"\",IF(C92=\"[for completion]\",\"\",C92/$C$98))","v":0},{"$f":"IF($D$98=0,\"\",IF(D92=\"[Mark as ND1 if not relevant]\",\"\",D92/$D$98))","v":0}]
["G.3.5.5","2 - 3 Y",1867.4,1867.4,null,0.3076999126695118,0.3076999126695118]
["G.3.5.6","3 - 4 Y",510,10,null,8.4034998105093184E-2,1.64774506088418E-3]
["G.3.5.7","4 - 5 Y",500,1000,null,8.2387253044209005E-2,0.16477450608841801]
["G.3.5.8","5 - 10 Y",1914.9999999999995,1414.9999999999995,null,0.3155431791593204,0.23315592611511141]
["G.3.5.9","10+ Y",1266.5,1766.5,null,0.20868691196098141,0.2910741650051904]
["G.3.5.10","Total",6068.9,6068.9,null,{"$f":"SUM(F91:F97)","v":1},{"$f":"SUM(G91:G97)","v":1}]
["OG.3.5.1","o/w 0-1 day",null,null,null,0,{"$f":"IF($D$98=0,\"\",IF(D99=\"[for completion]\",\"\",D99/$D$98))","v":0}]
["OG.3.5.2","o/w 0-0.5y",null,null,null,0,0]
["OG.3.5.3","o/w 0.5-1 y",null,null,null,0,0]
["OG.3.5.4","o/w 1-1.5y",null,null,null,0,0]
["OG.3.5.5","o/w 1.5-2 y",null,null,null,0,0]
["OG.3.5.6"]
["OG.3.5.7"]
["OG.3.5.8",null,null,null,null,0,0]
["OG.3.5.9",null,null,null,null,0,0]
["OG.3.5.10",null,null,null,null,0,0]
[null,"Covered Assets - Currency","Nominal [before hedging] (mn)","Nominal [after hedging] (mn)",null,"% Total [before]","% Total [after]"]
["G.3.6.1","EUR",{"$f":"C76","v":8019.614883199999},{"$f":"D76","v":8019.6148831999908},null,{"$f":"IF($C$125=0,\"\",IF(C110=\"[for completion]\",\"\",C110/$C$125))","v":1},{"$f":"IF($D$125=0,\"\",IF(D110=\"[for completion]\",\"\",D110/$D$125))","v":1}]
["G.3.6.2"," USD",0,0,null,{"$f":"IF($C$125=0,\"\",IF(C111=\"[for completion]\",\"\",C111/$C$125))","v":0},{"$f":"IF($D$125=0,\"\",IF(D111=\"[for completion]\",\"\",D111/$D$125))","v":0}]
["G.3.6.3"," GBP",0,0,null,0,0]
["G.3.6.4","NOK",0,0,null,0,0]
["G.3.6.5"," CHF",0,0,null,0,0]
["G.3.6.6"," AUD",0,0,null,{"$f":"IF($C$125=0,\"\",IF(C115=\"[for completion]\",\"\",C115/$C$125))","v":0},{"$f":"IF($D$125=0,\"\",IF(D115=\"[for completion]\",\"\",D115/$D$125))","v":0}]
["G.3.6.7"," CAD",0,0,null,0,0]
["G.3.6.8","BRL",0,0,null,0,0]
["G.3.6.9","CZK",0,0,null,0,0]
["G.3.6.10","DKK",0,0,null,0,0]
["G.3.6.11","HKD",0,0,null,0,0]
["G.3.6.12","KRW",0,0,null,0,0]
["G.3.6.13","SEK",0,0,null,{"$f":"IF($C$125=0,\"\",IF(C122=\"[for completion]\",\"\",C122/$C$125))","v":0},{"$f":"IF($D$125=0,\"\",IF(D122=\"[for completion]\",\"\",D122/$D$125))","v":0}]
["G.3.6.14","SGD",0,0,null,0,0]
["G.3.6.15","Other",0,0,null,{"$f":"IF($C$125=0,\"\",IF(C124=\"[for completion]\",\"\",C124/$C$125))","v":0},{"$f":"IF($D$125=0,\"\",IF(D124=\"[for completion]\",\"\",D124/$D$125))","v":0}]
["G.3.6.16","Total",{"$f":"SUM(C110:C124)","v":8019.614883199999},{"$f":"SUM(D110:D124)","v":8019.6148831999908},null,{"$f":"SUM(F110:F124)","v":1},{"$f":"SUM(G110:G124)","v":1}]
["OG.3.6.1","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$125=0,\"\",IF(C126=\"[for completion]\",\"\",C126/$C$125))","v":0},{"$f":"IF($D$125=0,\"\",IF(D126=\"[for completion]\",\"\",D126/$D$125))","v":0}]
["OG.3.6.2","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$125=0,\"\",IF(C127=\"[for completion]\",\"\",C127/$C$125))","v":0},{"$f":"IF($D$125=0,\"\",IF(D127=\"[for completion]\",\"\",D127/$D$125))","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]
["OG.3.6.8","o/w [If relevant, please specify]",null,null,null,0,0]
["OG.3.6.9","o/w [If relevant, please specify]",null,null,null,0,0]
[null,"Covered Bonds - Currency ","Nominal [before hedging] (mn)","Nominal [after hedging] (mn)",null,"% Total [before]","% Total [after]"]
["G.3.7.1","EUR",{"$f":"C98","v":6068.9},{"$f":"D98","v":6068.9},null,{"$f":"IF($C$151=0,\"\",IF(C136=\"[for completion]\",\"\",C136/$C$151))","v":1},{"$f":"IF($D$151=0,\"\",IF(D136=\"[for completion]\",\"\",D136/$D$151))","v":1}]
["G.3.7.2"," USD",0,0,null,{"$f":"IF($C$151=0,\"\",IF(C137=\"[for completion]\",\"\",C137/$C$151))","v":0},{"$f":"IF($D$151=0,\"\",IF(D137=\"[for completion]\",\"\",D137/$D$151))","v":0}]
["G.3.7.3"," GBP",0,0,null,0,0]
["G.3.7.4","NOK",0,0,null,0,0]
["G.3.7.5"," CHF",0,0,null,0,0]
["G.3.7.6"," AUD",0,0,null,0,0]
["G.3.7.7"," CAD",0,0,null,0,0]
["G.3.7.8","BRL",0,0,null,0,0]
["G.3.7.9","CZK",0,0,null,0,0]
["G.3.7.10","DKK",0,0,null,0,0]
["G.3.7.11","HKD",0,0,null,0,0]
["G.3.7.12","KRW",0,0,null,0,0]
["G.3.7.13","SEK",0,0,null,0,0]
["G.3.7.14","SGD",0,0,null,0,0]
["G.3.7.15","Other",0,0,null,0,0]
["G.3.7.16","Total",{"$f":"SUM(C136:C150)","v":6068.9},{"$f":"SUM(D136:D150)","v":6068.9},null,{"$f":"SUM(F136:F150)","v":1},{"$f":"SUM(G136:G150)","v":1}]
["OG.3.7.1","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$151=0,\"\",IF(C152=\"[for completion]\",\"\",C152/$C$151))","v":0},{"$f":"IF($D$151=0,\"\",IF(D152=\"[for completion]\",\"\",D152/$D$151))","v":0}]
["OG.3.7.2","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$151=0,\"\",IF(C153=\"[for completion]\",\"\",C153/$C$151))","v":0},{"$f":"IF($D$151=0,\"\",IF(D153=\"[for completion]\",\"\",D153/$D$151))","v":0}]
["OG.3.7.3","o/w [If relevant, please specify]",null,null,null,0,0]
["OG.3.7.4","o/w [If relevant, please specify]",null,null,null,0,0]
["OG.3.7.5","o/w [If relevant, please specify]",null,null,null,0,0]
["OG.3.7.6","o/w [If relevant, please specify]",null,null,null,0,0]
["OG.3.7.7","o/w [If relevant, please specify]",null,null,null,0,0]
["OG.3.7.8","o/w [If relevant, please specify]",null,null,null,0,0]
["OG.3.7.9","o/w [If relevant, please specify]",null,null,null,0,0]
[null,"Covered Bonds - Breakdown by interest rate ","Nominal (mn)",null,null,"% Covered Bonds"]
["G.3.8.1","Fixed coupon",6058.9,null,null,{"$f":"IF($C$165=0,\"\",IF(C162=\"[for completion]\",\"\",C162/$C$165))","v":0.99835225493911584}]
["G.3.8.2","Floating coupon",9.9999999999999076,null,null,{"$f":"IF($C$165=0,\"\",IF(C163=\"[for completion]\",\"\",C163/$C$165))","v":1.6477450608841648E-3}]
["G.3.8.3","Other",{"$f":"C39-SUM(C162:C163)","v":0},null,null,0]
["G.3.8.4","Total",{"$f":"SUM(C162:C164)","v":6068.9},null,null,{"$f":"SUM(F162:F164)","v":1}]
["OG.3.8.1"]
["OG.3.8.2"]
["OG.3.8.3"]
["OG.3.8.4"]
["OG.3.8.5"]
[null,"Substitute Assets - Type","Nominal (mn)",null,null,"% Substitute Assets"]
["G.3.9.1","Cash",0,null,null,{"$f":"IF($C$177=0,\"\",IF(C172=\"[for completion]\",\"\",C172/$C$177))","v":""}]
["G.3.9.2","Exposures to/guaranteed by governments or quasi governments",0]
["G.3.9.3","Exposures to central banks",0]
["G.3.9.4","Exposures to credit institutions",0,null,null,{"$f":"IF($C$177=0,\"\",IF(C175=\"[for completion]\",\"\",C175/$C$177))","v":""}]
["G.3.9.5","Other",0,null,null,""]
["G.3.9.6","Total",{"$f":"SUM(C172:C176)","v":0},null,null,{"$f":"SUM(F172:F176)","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,null,null,null,{"$f":"IF($C$177=0,\"\",IF(C189=\"[for completion]\",\"\",C189/$C$177))","v":""}]
[null,"Substitute Assets - Country","Nominal (mn)",null,null,"% Substitute Assets"]
["G.3.10.1","Domestic",0,null,null,{"$f":"IF($C$206=0,\"\",IF(C191=\"[for completion]\",\"\",C191/$C$206))","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",{"$f":"SUM(C191:C193)","v":0}]
["G.3.10.16","Total",{"$f":"SUM(C191:C204)","v":0},null,null,{"$f":"SUM(F191:F204)","v":0}]
["OG.3.10.1","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$206=0,\"\",IF(C207=\"[for completion]\",\"\",C207/$C$206))","v":""}]
["OG.3.10.2","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$206=0,\"\",IF(C208=\"[for completion]\",\"\",C208/$C$206))","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,"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$218=0,\"\",IF(C215=\"[for completion]\",\"\",C215/$C$218))","v":""},{"$f":"IF($C$218=0,\"\",IF(C215=\"[for completion]\",\"\",C215/$C$218))","v":""}]
["G.3.11.2","Central bank eligible assets",0,null,null,{"$f":"IF($C$218=0,\"\",IF(C216=\"[for completion]\",\"\",C216/$C$218))","v":""},{"$f":"IF($C$218=0,\"\",IF(C216=\"[for completion]\",\"\",C216/$C$218))","v":""}]
["G.3.11.3","Other",0,null,null,"",""]
["G.3.11.4","Total",{"$f":"SUM(C215:C217)","v":0},null,null,{"$f":"SUM(F215:F217)","v":0},{"$f":"SUM(G215:G217)","v":0}]
["OG.3.11.1","o/w [If relevant, please specify]",null,null,null,"",""]
["OG.3.11.2","o/w [If relevant, please specify]",null,null,null,{"$f":"IF($C$218=0,\"\",IF(C220=\"[for completion]\",\"\",C220/$C$218))","v":""},{"$f":"IF($C$218=0,\"\",IF(C220=\"[for completion]\",\"\",C220/$C$218))","v":""}]
["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,"Bond List "]
["G.3.12.1","Bond list ",{"$f":"C29","v":"https://coveredbondlabel.com/issuer/81/pool/87/"}]
[null,"Derivatives & Swaps"]
["G.3.13.1","Derivatives in the 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: ","43 for Mortgage Assets","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: ","167 for Residential Mortgage Assets","267 for Commercial Mortgage Assets",null,"18 for Public Sector Assets"]
["G.4.1.6","            (ii)        Interest rate risk - cover pool:","130 for Mortgage Assets",{"$f":"ROW(B161)","v":161},null,"129 for Public Sector Assets"]
["G.4.1.7","(ii)        Currency risk - cover pool:",{"$f":"ROW(B109)","v":109}]
["G.4.1.8","          (ii)         Interest rate risk - covered bond:",{"$f":"ROW(B161)","v":161}]
["G.4.1.9","(ii)        Currency risk - covered bond:",{"$f":"ROW(B135)","v":135}]
["G.4.1.10","(Please refer to \"Tab D. HTT Harmonised Glossary\" for hedging strategy)","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(B87)","v":87}]
["G.4.1.13","(iv)        Percentage of loans more than ninety days past due:","160 for Mortgage Assets","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",{"$f":"ROW(B171)","v":171}]
["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":4,"n_rows":367,"n_cols":7,"rows_kept":367,"cut":false,"hidden":false,"merged":[]}
["B1. Harmonised Transparency Template - Mortgage Assets"]
[]
[null,"Reporting in Domestic Currency",{"$f":"'A. HTT General'!C3","v":"EUR"}]
[]
[null,"CONTENT OF TAB B"]
[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":"'A. HTT General'!C38","v":8019.6148831999999},null,null,{"$f":"IF($C$15=0,\"\",IF(C12=\"[for completion]\",\"\",C12/$C$15))","v":1}]
["M.7.1.2","Commercial",null,null,null,{"$f":"IF($C$15=0,\"\",IF(C13=\"[for completion]\",\"\",C13/$C$15))","v":0}]
["M.7.1.3","Other",null,null,null,{"$f":"IF($C$15=0,\"\",IF(C14=\"[for completion]\",\"\",C14/$C$15))","v":0}]
["M.7.1.4","Total",{"$f":"SUM(C12:C14)","v":8019.6148831999999},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",170355,null,null,{"$f":"C28","v":170355}]
["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 ",5.1558621486812704E-4,null,null,{"$f":"C36","v":5.1558621486812704E-4}]
["OM.7.3.1"]
["OM.7.3.2"]
["OM.7.3.3"]
["OM.7.3.4"]
["OM.7.3.5"]
["OM.7.3.6"]
[null,"4. Breakdown by Geography ","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["M.7.4.1","European Union",{"$f":"SUM(C45:C71)","v":1},{"$f":"SUM(D45:D71)","v":0},null,{"$f":"SUM(F45:F71)","v":1}]
["M.7.4.2","Austria"]
["M.7.4.3","Belgium"]
["M.7.4.4","Bulgaria"]
["M.7.4.5","Croatia"]
["M.7.4.6","Cyprus"]
["M.7.4.7","Czech Republic"]
["M.7.4.8","Denmark"]
["M.7.4.9","Estonia"]
["M.7.4.10","Finland"]
["M.7.4.11","France",1,null,null,{"$f":"C54","v":1}]
["M.7.4.12","Germany"]
["M.7.4.13","Greece"]
["M.7.4.14","Netherlands"]
["M.7.4.15","Hungary"]
["M.7.4.16","Ireland"]
["M.7.4.17","Italy"]
["M.7.4.18","Latvia"]
["M.7.4.19","Lithuania"]
["M.7.4.20","Luxembourg"]
["M.7.4.21","Malta"]
["M.7.4.22","Poland"]
["M.7.4.23","Portugal"]
["M.7.4.24","Romania"]
["M.7.4.25","Slovakia"]
["M.7.4.26","Slovenia"]
["M.7.4.27","Spain"]
["M.7.4.28","Sweden"]
["M.7.4.29","United Kingdom"]
["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"]
["M.7.4.32","Liechtenstein"]
["M.7.4.33","Norway"]
["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"]
["M.7.4.36","Australia"]
["M.7.4.37","Brazil"]
["M.7.4.38","Canada"]
["M.7.4.39","Japan"]
["M.7.4.40","Korea"]
["M.7.4.41","New Zealand"]
["M.7.4.42","Singapore"]
["M.7.4.43","US"]
["M.7.4.44","Other"]
["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 domestic regions","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["M.7.5.1","Alsace-Champagne-Ardenne-Lorraine",1.6575402763849263E-3,null,null,{"$f":"C99","v":1.6575402763849263E-3}]
["M.7.5.2","Aquitaine-Limousin-Poitou-Charentes",0.17833351584575496,null,null,{"$f":"C100","v":0.17833351584575496}]
["M.7.5.3","Auvergne-Rhône-Alpes",4.1510836806812487E-2,null,null,4.1510836806812487E-2]
["M.7.5.4","Bourgogne-Franche-Comté",1.0205070666353963E-3,null,null,1.0205070666353963E-3]
["M.7.5.5","Bretagne",0.64255640946736092,null,null,0.64255640946736092]
["M.7.5.6","Centre-Val de Loire",4.0304333787537948E-3,null,null,4.0304333787537948E-3]
["M.7.5.7","Corse",7.1324928607015606E-4,null,null,7.1324928607015606E-4]
["M.7.5.8","Départements d'Outre-Mer",3.033306257755536E-3,null,null,3.033306257755536E-3]
["M.7.5.9","Ile-de-France",5.5130789975488349E-2,null,null,5.5130789975488349E-2]
["M.7.5.10","Languedoc-Roussillon-Midi-Pyrénées",1.5418057718584883E-2,null,null,1.5418057718584883E-2]
["M.7.5.11","Nord-Pas-de-Calais-Picardie",3.3341933670673436E-3,null,null,3.3341933670673436E-3]
["M.7.5.12","Normandie",6.2752361494844283E-3,null,null,6.2752361494844283E-3]
["M.7.5.13","Pays de la Loire",3.8570961716377701E-2,null,null,3.8570961716377701E-2]
["M.7.5.14","Provence-Alpes-Côte d'Azur",8.4149626874691179E-3,null,null,8.4149626874691179E-3]
["M.7.5.15"]
["M.7.5.16"]
["M.7.5.17"]
["M.7.5.18"]
["M.7.5.19"]
["M.7.5.20"]
["M.7.5.21"]
["M.7.5.22"]
["M.7.5.23"]
["M.7.5.24"]
["M.7.5.25"]
["M.7.5.26"]
["M.7.5.27"]
["M.7.5.28"]
["M.7.5.29"]
["M.7.5.30"]
["M.7.5.31"]
[null,"6. Breakdown by Interest Rate","% Residential Loans","% Commercial Loans",null,"% Total Mortgages"]
["M.7.6.1","Fixed rate",0.98578569521162196,null,null,{"$f":"C131","v":0.98578569521162196}]
["M.7.6.2","Floating rate",{"$f":"1-C131","v":1.421430478837804E-2},null,null,{"$f":"C132","v":1.421430478837804E-2}]
["M.7.6.3","Other",{"$f":"1-C132-C131","v":0},null,null,{"$f":"C133","v":0}]
["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",null,null,null,{"$f":"C141","v":0}]
["M.7.7.2","Amortising",{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
["M.7.7.3","Other",{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
["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",3.2370685596614823E-2,null,null,{"$f":"C151","v":3.2370685596614823E-2}]
["M.7.8.2","≥  12 - ≤ 24 months",0.11273558579651476,null,null,0.11273558579651476]
["M.7.8.3","≥ 24 - ≤ 36 months",0.17160313689662743,null,null,0.17160313689662743]
["M.7.8.4","≥ 36 - ≤ 60 months",0.24414380718974599,null,null,0.24414380718974599]
["M.7.8.5","≥ 60 months",0.43914678452049705,null,null,0.43914678452049705]
["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",0,null,null,{"$f":"C161","v":0}]
["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)",47.07589964016325,170355]
[]
[null,"By buckets (mn):"]
["M.7A.10.2","0-200k€",7709.4527758498998,169113,null,{"$f":"IF($C$195=0,\"\",IF(C171=\"[for completion]\",\"\",C171/$C$195))","v":0.96132456335281746},{"$f":"IF($D$195=0,\"\",IF(D171=\"[for completion]\",\"\",D171/$D$195))","v":0.99270934225587748}]
["M.7A.10.3","200-400k€",298.89972798000002,1216,null,3.7271082506238291E-2,7.1380352792697601E-3]
["M.7A.10.4","400-600k€",11.26237937,26,null,1.4043541409442602E-3,1.5262246485280736E-4]
["M.7A.10.5","600-800k€",null,null,null,0,0]
["M.7A.10.6","800-1M€",null,null,null,0,0]
["M.7A.10.7",">1M€",null,null,null,0,0]
["M.7A.10.8",null,null,null,null,0,0]
["M.7A.10.9",null,null,null,null,0,0]
["M.7A.10.10",null,null,null,null,0,0]
["M.7A.10.11",null,null,null,null,0,0]
["M.7A.10.12",null,null,null,null,0,0]
["M.7A.10.13",null,null,null,null,0,0]
["M.7A.10.14",null,null,null,null,0,0]
["M.7A.10.15",null,null,null,null,0,0]
["M.7A.10.16",null,null,null,null,0,0]
["M.7A.10.17",null,null,null,null,0,0]
["M.7A.10.18",null,null,null,null,0,0]
["M.7A.10.19",null,null,null,null,0,0]
["M.7A.10.20",null,null,null,null,0,0]
["M.7A.10.21",null,null,null,null,0,0]
["M.7A.10.22",null,null,null,null,0,0]
["M.7A.10.23",null,null,null,null,0,0]
["M.7A.10.24",null,null,null,null,0,0]
["M.7A.10.25",null,null,null,null,0,0]
["M.7A.10.26","Total",{"$f":"SUM(C171:C194)","v":8019.6148831998999},{"$f":"SUM(D171:D194)","v":170355},null,{"$f":"SUM(F171:F194)","v":1},{"$f":"SUM(G171:G194)","v":1}]
[null,"11. Loan to Value (LTV) Information - UNINDEXED","Nominal","Number of Loans",null,"% Residential Loans","% No. of Loans"]
["M.7A.11.1","Weighted Average LTV (%)",0.67043108284893804]
[]
[null,"By LTV buckets (mn):"]
["M.7A.11.2",">0 - <=40 %",1144.5475303600099,46434,null,{"$f":"IF($C$208=0,\"\",IF(C200=\"[for completion]\",\"\",C200/$C$208))","v":0.14271851541869912},{"$f":"IF($D$208=0,\"\",IF(D200=\"[for completion]\",\"\",D200/$D$208))","v":0.27257198203750993}]
["M.7A.11.3",">40 - <=50 %",687.89864129999899,15841,null,8.5777016891553204E-2,9.2988171758973906E-2]
["M.7A.11.4",">50 - <=60 %",894.96159421999891,18343,null,0.11159658004211899,0.1076751489536556]
["M.7A.11.5",">60 - <=70 %",1096.96746151,21300,null,0.13678555360656977,0.12503301928326144]
["M.7A.11.6",">70 - <=80 %",1364.6587181099999,24812,null,0.1701651186478757,0.14564879222799448]
["M.7A.11.7",">80 - <=90 %",1533.1025830200051,25305,null,0.19116910292433664,0.14854274896539579]
["M.7A.11.8",">90 - <=100 %",1297.478354679999,18320,null,0.1617881124688465,0.10754013677320889]
["M.7A.11.9",">100%",null,null,null,0,0]
["M.7A.11.10","Total",{"$f":"SUM(C200:C207)","v":8019.6148832000126},{"$f":"SUM(D200:D207)","v":170355},null,{"$f":"SUM(F200:F207)","v":0.99999999999999989},{"$f":"SUM(G200:G207)","v":1}]
["OM.7A.11.1","o/w >100 - <=110 %",null,null,null,0,0]
["OM.7A.11.2","o/w >110 - <=120 %",null,null,null,0,0]
["OM.7A.11.3","o/w >120 - <=130 %",null,null,null,0,0]
["OM.7A.11.4","o/w >130 - <=140 %",null,null,null,0,0]
["OM.7A.11.5","o/w >140 - <=150 %",null,null,null,0,0]
["OM.7A.11.6","o/w >150 %",null,null,null,0,0]
["OM.7A.11.7"]
["OM.7A.11.8"]
["OM.7A.11.9"]
[null,"12. Loan to Value (LTV) Information - INDEXED ","Nominal","Number of Loans",null,"% Residential Loans","% No. of Loans"]
["M.7A.12.1","Weighted Average LTV (%)",0.65078868454184502]
[]
[null,"By LTV buckets (mn):"]
["M.7A.12.2",">0 - <=40 %",1242.6652094799999,48270,null,{"$f":"IF($C$230=0,\"\",IF(C222=\"[Mark as ND1 if not relevant]\",\"\",C222/$C$230))","v":0.15495322750263404},{"$f":"IF($D$230=0,\"\",IF(D222=\"[Mark as ND1 if not relevant]\",\"\",D222/$D$230))","v":0.28334947609403893}]
["M.7A.12.3",">40 - <=50 %",717.56800700000201,16034,null,{"$f":"IF($C$230=0,\"\",IF(C223=\"[Mark as ND1 if not relevant]\",\"\",C223/$C$230))","v":8.947661670178314E-2},{"$f":"IF($D$230=0,\"\",IF(D223=\"[Mark as ND1 if not relevant]\",\"\",D223/$D$230))","v":9.4121100055765905E-2}]
["M.7A.12.4",">50 - <=60 %",934.07944637999697,18641,null,0.11647435194634667,0.10942443720466086]
["M.7A.12.5",">60 - <=70 %",1157.0412876300002,21987,null,0.14427641532436222,0.12906577441225675]
["M.7A.12.6",">70 - <=80 %",1450.8177868099999,25943,null,0.18090866057038038,0.15228786944909159]
["M.7A.12.7",">80 - <=90 %",1678.9054698600062,27087,null,0.20934988703473575,0.15900325790261513]
["M.7A.12.8",">90 - <=100 %",838.40271603999599,12392,null,0.10454401218147459,7.2742214786768802E-2]
["M.7A.12.9",">100%",0.13496,1,null,1.6828738283021888E-5,5.8700948020310526E-6]
["M.7A.12.10","Total",{"$f":"SUM(C222:C229)","v":8019.6148832000026},{"$f":"SUM(D222:D229)","v":170355},null,{"$f":"SUM(F222:F229)","v":0.99999999999999978},{"$f":"SUM(G222:G229)","v":1}]
["OM.7A.12.1","o/w >100 - <=110 %",null,null,null,{"$f":"IF($C$230=0,\"\",IF(C231=\"[for completion]\",\"\",C231/$C$230))","v":0},{"$f":"IF($D$230=0,\"\",IF(D231=\"[for completion]\",\"\",D231/$D$230))","v":0}]
["OM.7A.12.2","o/w >110 - <=120 %",null,null,null,0,0]
["OM.7A.12.3","o/w >120 - <=130 %",null,null,null,0,0]
["OM.7A.12.4","o/w >130 - <=140 %",null,null,null,0,0]
["OM.7A.12.5","o/w >140 - <=150 %",null,null,null,0,0]
["OM.7A.12.6","o/w >150 %",null,null,null,0,0]
["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",0.85278484407983046]
["M.7A.13.2","Second home/Holiday houses",3.3877970384731296E-2]
["M.7A.13.3","Buy-to-let/Non-owner occupied",0.11333718553543826]
["M.7A.13.4","Other",0]
["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",0.44821552468311426]
["M.7A.14.2","Guaranteed",0.55124815720776921]
["M.7A.14.3","Other"]
["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)","ND2"]
[]
[null,"By buckets (mn):"]
["M.7B.15.2","ND2","ND2","ND2",null,{"$f":"IF($C$295=0,\"\",IF(C271=\"[for completion]\",\"\",C271/$C$295))","v":""},{"$f":"IF($D$295=0,\"\",IF(D271=\"[for completion]\",\"\",D271/$D$295))","v":""}]
["M.7B.15.3","ND2","ND2","ND2",null,"",""]
["M.7B.15.4","ND2","ND2","ND2",null,"",""]
["M.7B.15.5","ND2","ND2","ND2",null,"",""]
["M.7B.15.6","ND2","ND2","ND2",null,"",""]
["M.7B.15.7","ND2","ND2","ND2",null,"",""]
["M.7B.15.8","ND2","ND2","ND2",null,"",""]
["M.7B.15.9","ND2","ND2","ND2",null,"",""]
["M.7B.15.10","ND2","ND2","ND2",null,"",""]
["M.7B.15.11","ND2","ND2","ND2",null,"",""]
["M.7B.15.12","ND2","ND2","ND2",null,"",""]
["M.7B.15.13","ND2","ND2","ND2",null,"",""]
["M.7B.15.14","ND2","ND2","ND2",null,"",""]
["M.7B.15.15","ND2","ND2","ND2",null,"",""]
["M.7B.15.16","ND2","ND2","ND2",null,"",""]
["M.7B.15.17","ND2","ND2","ND2",null,"",""]
["M.7B.15.18","ND2","ND2","ND2",null,"",""]
["M.7B.15.19","ND2","ND2","ND2",null,"",""]
["M.7B.15.20","ND2","ND2","ND2",null,"",""]
["M.7B.15.21","ND2","ND2","ND2",null,"",""]
["M.7B.15.22","ND2","ND2","ND2",null,"",""]
["M.7B.15.23","ND2","ND2","ND2",null,"",""]
["M.7B.15.24","ND2","ND2","ND2",null,"",""]
["M.7B.15.25","ND2","ND2","ND2",null,"",""]
["M.7B.15.26","Total",{"$f":"SUM(C271:C294)","v":0},{"$f":"SUM(D271:D294)","v":0},null,{"$f":"SUM(F271:F294)","v":0},{"$f":"SUM(G271:G294)","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 (%)","ND2"]
[]
[null,"By LTV buckets (mn):"]
["M.7B.16.2",">0 - <=40 %","ND2","ND2",null,{"$f":"IF($C$308=0,\"\",IF(C300=\"[for completion]\",\"\",C300/$C$308))","v":""},{"$f":"IF($D$308=0,\"\",IF(D300=\"[for completion]\",\"\",D300/$D$308))","v":""}]
["M.7B.16.3",">40 - <=50 %","ND2","ND2",null,{"$f":"IF($C$308=0,\"\",IF(C301=\"[for completion]\",\"\",C301/$C$308))","v":""},{"$f":"IF($D$308=0,\"\",IF(D301=\"[for completion]\",\"\",D301/$D$308))","v":""}]
["M.7B.16.4",">50 - <=60 %","ND2","ND2",null,"",""]
["M.7B.16.5",">60 - <=70 %","ND2","ND2",null,"",""]
["M.7B.16.6",">70 - <=80 %","ND2","ND2",null,"",""]
["M.7B.16.7",">80 - <=90 %","ND2","ND2",null,"",""]
["M.7B.16.8",">90 - <=100 %","ND2","ND2",null,"",""]
["M.7B.16.9",">100%","ND2","ND2",null,"",""]
["M.7B.16.10","Total",{"$f":"SUM(C300:C307)","v":0},{"$f":"SUM(D300:D307)","v":0},null,{"$f":"SUM(F300:F307)","v":0},{"$f":"SUM(G300:G307)","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 (%)","ND2"]
[]
[null,"By LTV buckets (mn):"]
["M.7B.17.2",">0 - <=40 %","ND2","ND2",null,{"$f":"IF($C$330=0,\"\",IF(C322=\"[Mark as ND1 if not relevant]\",\"\",C322/$C$330))","v":""},{"$f":"IF($D$330=0,\"\",IF(D322=\"[Mark as ND1 if not relevant]\",\"\",D322/$D$330))","v":""}]
["M.7B.17.3",">40 - <=50 %","ND2","ND2",null,{"$f":"IF($C$330=0,\"\",IF(C323=\"[Mark as ND1 if not relevant]\",\"\",C323/$C$330))","v":""},{"$f":"IF($D$330=0,\"\",IF(D323=\"[Mark as ND1 if not relevant]\",\"\",D323/$D$330))","v":""}]
["M.7B.17.4",">50 - <=60 %","ND2","ND2",null,"",""]
["M.7B.17.5",">60 - <=70 %","ND2","ND2",null,"",""]
["M.7B.17.6",">70 - <=80 %","ND2","ND2",null,"",""]
["M.7B.17.7",">80 - <=90 %","ND2","ND2",null,"",""]
["M.7B.17.8",">90 - <=100 %","ND2","ND2",null,"",""]
["M.7B.17.9",">100%","ND2","ND2",null,"",""]
["M.7B.17.10","Total",{"$f":"SUM(C322:C329)","v":0},{"$f":"SUM(D322:D329)","v":0},null,{"$f":"SUM(F322:F329)","v":0},{"$f":"SUM(G322:G329)","v":0}]
["OM.7B.17.1","o/w >100 - <=110 %",null,null,null,{"$f":"IF($C$330=0,\"\",IF(C331=\"[for completion]\",\"\",C331/$C$330))","v":""},{"$f":"IF($D$330=0,\"\",IF(D331=\"[for completion]\",\"\",D331/$D$330))","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","ND2"]
["M.7B.18.2","Office","ND2"]
["M.7B.18.3","Hotel/Tourism","ND2"]
["M.7B.18.4","Shopping malls","ND2"]
["M.7B.18.5","Industry","ND2"]
["M.7B.18.6","Agriculture","ND2"]
["M.7B.18.7","Other commercially used","ND2"]
["M.7B.18.8","Land","ND2"]
["M.7B.18.9","Property developers / Bulding under construction","ND2"]
["M.7B.18.10","Other","ND2"]
["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":5,"n_rows":179,"n_cols":7,"rows_kept":179,"cut":false,"hidden":false,"merged":[]}
["B2. Harmonised Transparency Template - Public Sector Assets"]
[]
[null,"Reporting in Domestic Currency","[Please insert currency]"]
[]
[null,"CONTENT OF TAB B2"]
[null,"8. Public Sector Assets"]
[]
["Field Number","8. Public Sector Assets"]
[null,"1. General Information"]
["PS.8.1.1","Number of public sector exposures","[For completion]"]
["OPS.8.1.1","Optional information eg, Number of borrowers"]
["OPS.8.1.2","Optional information eg, Number of guarantors"]
["OPS.8.1.3"]
["OPS.8.1.4"]
["OPS.8.1.5"]
["OPS.8.1.6"]
["OPS.8.1.7"]
[null,"2. Size Information","Nominal","Number of Exposures",null,"% Public Sector Assets","% No. of Exposures"]
["PS.8.2.1","Average exposure size (000s)","[For completion]"]
[]
[null,"By buckets (mn):"]
["PS.8.2.2","TBC at a country level","[For completion]","[For completion]",null,{"$f":"IF($C$37=0,\"\",IF(C22=\"[for completion]\",\"\",C22/$C$37))","v":""},{"$f":"IF($D$37=0,\"\",IF(D22=\"[for completion]\",\"\",D22/$D$37))","v":""}]
["PS.8.2.3","TBC at a country level","[For completion]","[For completion]",null,{"$f":"IF($C$37=0,\"\",IF(C23=\"[for completion]\",\"\",C23/$C$37))","v":""},{"$f":"IF($D$37=0,\"\",IF(D23=\"[for completion]\",\"\",D23/$D$37))","v":""}]
["PS.8.2.4","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.5","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.6","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.7","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.8","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.9","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.10","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.11","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.12","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.13","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.14","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.15","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.16","TBC at a country level","[For completion]","[For completion]",null,"",""]
["PS.8.2.17","Total",{"$f":"SUM(C22:C36)","v":0},{"$f":"SUM(D22:D36)","v":0},null,{"$f":"SUM(F22:F36)","v":0},{"$f":"SUM(G22:G36)","v":0}]
[null,"3. Breakdown by Asset Type","Nominal (mn)",null,null,"% Public Sector Assets"]
["PS.8.3.1","Loans","[For completion]",null,null,{"$f":"IF($C$42=0,\"\",IF(C39=\"[for completion]\",\"\",C39/$C$42))","v":""}]
["PS.8.3.2","Bonds","[For completion]",null,null,{"$f":"IF($C$42=0,\"\",IF(C40=\"[for completion]\",\"\",C40/$C$42))","v":""}]
["PS.8.3.3","Other","[For completion]",null,null,""]
["PS.8.3.4","Total",{"$f":"SUM(C39:C41)","v":0},null,null,{"$f":"SUM(F39:F41)","v":0}]
["OPS.8.3.1"]
["OPS.8.3.2"]
["OPS.8.3.3"]
["OPS.8.3.4"]
["OPS.8.3.5"]
[null,"4. Breakdown by Geography ","% Public Sector Assets"]
["PS.8.4.1","European Union",{"$f":"SUM(C50:C77)","v":0}]
["PS.8.4.2","Austria","[For completion]"]
["PS.8.4.3","Belgium","[For completion]"]
["PS.8.4.4","Bulgaria","[For completion]"]
["PS.8.4.5","Croatia","[For completion]"]
["PS.8.4.6","Cyprus","[For completion]"]
["PS.8.4.7","Czech Republic","[For completion]"]
["PS.8.4.8","Denmark","[For completion]"]
["PS.8.4.9","Estonia","[For completion]"]
["PS.8.4.10","Finland","[For completion]"]
["PS.8.4.11","France","[For completion]"]
["PS.8.4.12","Germany","[For completion]"]
["PS.8.4.13","Greece","[For completion]"]
["PS.8.4.14","Netherlands","[For completion]"]
["PS.8.4.15","Hungary","[For completion]"]
["PS.8.4.16","Ireland","[For completion]"]
["PS.8.4.17","Italy","[For completion]"]
["PS.8.4.18","Latvia","[For completion]"]
["PS.8.4.19","Lithuania","[For completion]"]
["PS.8.4.20","Luxembourg","[For completion]"]
["PS.8.4.21","Malta","[For completion]"]
["PS.8.4.22","Poland","[For completion]"]
["PS.8.4.23","Portugal","[For completion]"]
["PS.8.4.24","Romania","[For completion]"]
["PS.8.4.25","Slovakia","[For completion]"]
["PS.8.4.26","Slovenia","[For completion]"]
["PS.8.4.27","Spain","[For completion]"]
["PS.8.4.28","Sweden","[For completion]"]
["PS.8.4.29","United Kingdom","[For completion]"]
["PS.8.4.30","European Economic Area (not member of EU)",{"$f":"SUM(C79:C81)","v":0}]
["PS.8.4.31","Iceland","[For completion]"]
["PS.8.4.32","Liechtenstein","[For completion]"]
["PS.8.4.33","Norway","[For completion]"]
["PS.8.4.34","Other",{"$f":"SUM(C83:C92)","v":0}]
["PS.8.4.35","Switzerland","[For completion]"]
["PS.8.4.36","Australia","[For completion]"]
["PS.8.4.37","Brazil","[For completion]"]
["PS.8.4.38","Canada","[For completion]"]
["PS.8.4.39","Japan","[For completion]"]
["PS.8.4.40","Korea","[For completion]"]
["PS.8.4.41","New Zealand","[For completion]"]
["PS.8.4.42","Singapore","[For completion]"]
["PS.8.4.43","US","[For completion]"]
["PS.8.4.44","Other","[For completion]"]
["OPS.8.4.1","o/w [If relevant, please specify]"]
["OPS.8.4.2","o/w [If relevant, please specify]"]
["OPS.8.4.3","o/w [If relevant, please specify]"]
["OPS.8.4.4","o/w [If relevant, please specify]"]
["OPS.8.4.5","o/w [If relevant, please specify]"]
["OPS.8.4.6","o/w [If relevant, please specify]"]
["OPS.8.4.7","o/w [If relevant, please specify]"]
["OPS.8.4.8","o/w [If relevant, please specify]"]
["OPS.8.4.9","o/w [If relevant, please specify]"]
["OPS.8.4.10","o/w [If relevant, please specify]"]
[null,"5. Breakdown by domestic regions","% Public Sector Assets"]
["PS.8.5.1","TBC at a country level","[For completion]"]
["PS.8.5.2","TBC at a country level","[For completion]"]
["PS.8.5.3","TBC at a country level","[For completion]"]
["PS.8.5.4","TBC at a country level","[For completion]"]
["PS.8.5.5","TBC at a country level","[For completion]"]
["PS.8.5.6","TBC at a country level","[For completion]"]
["PS.8.5.7","TBC at a country level","[For completion]"]
["PS.8.5.8","TBC at a country level","[For completion]"]
["PS.8.5.9","TBC at a country level","[For completion]"]
["PS.8.5.10","TBC at a country level","[For completion]"]
["PS.8.5.11","TBC at a country level","[For completion]"]
["PS.8.5.12","TBC at a country level","[For completion]"]
["PS.8.5.13","TBC at a country level","[For completion]"]
["PS.8.5.14","TBC at a country level","[For completion]"]
["PS.8.5.15","TBC at a country level","[For completion]"]
["PS.8.5.16","TBC at a country level","[For completion]"]
["PS.8.5.17","TBC at a country level","[For completion]"]
["PS.8.5.18","TBC at a country level","[For completion]"]
["PS.8.5.19","TBC at a country level","[For completion]"]
["PS.8.5.20","TBC at a country level","[For completion]"]
["PS.8.5.21","TBC at a country level","[For completion]"]
["PS.8.5.22","TBC at a country level","[For completion]"]
["PS.8.5.23","TBC at a country level","[For completion]"]
["PS.8.5.24","TBC at a country level","[For completion]"]
["PS.8.5.25","TBC at a country level","[For completion]"]
[null,"6. Breakdown by Interest Rate","% Public Sector Assets"]
["PS.8.6.1","Fixed rate","[For completion]"]
["PS.8.6.2","Floating rate","[For completion]"]
["PS.8.6.3","Other","[For completion]"]
["OPS.8.6.1"]
["OPS.8.6.2"]
["OPS.8.6.3"]
["OPS.8.6.4"]
[null,"7. Breakdown by Repayment Type","% Public Sector Assets"]
["PS.8.7.1","Bullet / interest only","[For completion]"]
["PS.8.7.2","Amortising","[For completion]"]
["PS.8.7.3","Other","[For completion]"]
["OPS.8.7.1"]
["OPS.8.7.2"]
["OPS.8.7.3"]
["OPS.8.7.4"]
["OPS.8.7.5"]
["OPS.8.7.6"]
[null,"8. Breakdown by Type of Debtor","Nominal (mn)",null,null,"% Public Sector Assets"]
["PS.8.8.1","Sovereigns","[For completion]",null,null,{"$f":"IF($C$152=0,\"\",IF(C148=\"[for completion]\",\"\",C148/$C$152))","v":""}]
["PS.8.8.2","Regional/federal authorities","[For completion]",null,null,{"$f":"IF($C$152=0,\"\",IF(C149=\"[for completion]\",\"\",C149/$C$152))","v":""}]
["PS.8.8.3","Local/municipal authorities ","[For completion]",null,null,{"$f":"IF($C$152=0,\"\",IF(C150=\"[for completion]\",\"\",C150/$C$152))","v":""}]
["PS.8.8.4","Others","[For completion]",null,null,{"$f":"IF($C$152=0,\"\",IF(C151=\"[for completion]\",\"\",C151/$C$152))","v":""}]
["PS.8.8.5","Total",{"$f":"SUM(C148:C151)","v":0},null,null,{"$f":"SUM(F148:F151)","v":0}]
["OPS.8.8.1","o/w Claim against supranational",null,null,null,{"$f":"IF($C$152=0,\"\",IF(C153=\"[for completion]\",\"\",C153/$C$152))","v":""}]
["OPS.8.8.2","o/w Claim against sovereigns",null,null,null,{"$f":"IF($C$152=0,\"\",IF(C154=\"[for completion]\",\"\",C154/$C$152))","v":""}]
["OPS.8.8.3","o/w Claim guaranteed by sovereigns",null,null,null,""]
["OPS.8.8.4","o/w Claim against regional/federal authorities",null,null,null,""]
["OPS.8.8.5","o/w Claim guaranteed by regional/federal authorities",null,null,null,""]
["OPS.8.8.6","o/w Claim against local/municipal authorities ",null,null,null,""]
["OPS.8.8.7","o/w Claimguaranteed by local/municipal authorities ",null,null,null,""]
["OPS.8.8.8"]
["OPS.8.8.9"]
["OPS.8.8.10"]
["OPS.8.8.11"]
["OPS.8.8.12",null,null,null,null,{"$f":"IF($C$152=0,\"\",IF(C164=\"[for completion]\",\"\",C164/$C$152))","v":""}]
["OPS.8.8.13",null,null,null,null,""]
[null,"9. Non-Performing Loans"]
["PS.8.9.1","% NPLs","[For completion]"]
["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","[For completion]"]
["OPS.8.10.1"]
["OPS.8.10.2"]
["OPS.8.10.3"]
["OPS.8.10.4"]
["OPS.8.10.5"]
["OPS.8.10.6"]

{"sheet":"C. HTT Harmonised Glossary","index":6,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["C. Harmonised Transparency Template - Glossary"]
[]
["The definitions below reflect the national specificities"]
[]
["Field Number","1. Glossary - Standard Harmonised Items"]
["HG.1.1","OC Calculation: Actual","The Actual OC is calculated as (Cover Pool Size- Covered Bond Outstanding)/ Covered Bond Outstanding."]
["HG.1.2","OC Calculation: Legal minimum","The minimum legal level of overcollateralisation under French law is set at 105%. "]
["HG.1.3","OC Calculation: Committed","Minimum OC imposed by the rating agencies for a AAA rating programme"]
["HG.1.4","Interest Rate Types","Fixed or Floating"]
["HG.1.5","Maturity Buckets of Cover assets [i.e. how is the contractual and/or expected maturity defined? What assumptions eg, in terms of prepayments? etc.]","Contractual maturities are calculated assuming a zero prepayment scenario on the cover pool assets. \nExpected maturities are calculated with a prepayment scenario based on a hypothetical annual prepayment rate."]
["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.] ","Hard or Soft bullet"]
["HG.1.7","LTVs: Definition","The ratio between the total outstanding principal amount of home loan receivables associated with a same financed or charged residential real estate property and the valuation amount of such real estate property as of the origination date."]
["HG.1.8","LTVs: Calculation of property/shipping value","ND2"]
["HG.1.9","LTVs: Applied property/shipping valuation techniques, including whether use of index, Automated Valuation Model (AVM) or on-site audits","The property value is fixed and determined at the loan origination date and then updated using real restate market indices (updated values of residential home loans are certified by the specific controller)."]
["HG.1.10","LTVs: Frequency and time of last valuation","The LTV is updated on a monthly basis."]
["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","Under the french SFH Legal Framework, home loans are secured by a first-ranking mortgage or similar first-ranking legal privilege or are guaranteed by a credit institution, a financing company (société de financement), or an insurance company. \nThe property must be located in France and denominated in Euro.\nThe borrower must be an individual or a real estate civil partnership. \nHome loans purpose is either to buy, to renovate, to build or to refinance a residential property.\n\nMore information in the base prospectus."]
["HG.1.12","Hedging Strategy (please explain how you address interest rate and currency risk)","At all times assets in the cover pool are sufficient to cover the payments due arising from the issued Covered Bonds."]
["HG.1.13","Non-performing loans","There are no non-performing loans in the cover pool."]
["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"]
["HG.2.1"]
["OHG.2.1"]
["OHG.2.2"]
[null,"3. Glossary - Extra national and/or Issuer Items"]
["HG.3.1","Other definitions deemed relevant"]
["OHG.3.1"]
["OHG.3.2"]
["OHG.3.3"]
["OHG.3.4"]
["OHG.3.5"]

{"sheet":"E. Optional ECB-ECAIs data","index":7,"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 2018"]
[]
[null,"Reporting in Domestic Currency","[Please insert currency]",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)","ND2","ND2"]
["E.1.1.2","Servicer ","ND2","ND2"]
["E.1.1.3","Back-up servicer","ND2","ND2"]
["E.1.1.4","BUS facilitator","ND2","ND2"]
["E.1.1.5","Cash manager ","ND2","ND2"]
["E.1.1.6","Back-up cash manager","ND2","ND2"]
["E.1.1.7","Account bank","ND2","ND2"]
["E.1.1.8","Standby account bank","ND2","ND2"]
["E.1.1.9","Account bank guarantor","ND2","ND2"]
["E.1.1.10","Trustee","ND2","ND2"]
["E.1.1.11","Cover Pool Monitor","ND2","ND2"]
["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","ND2","ND2","ND2","ND2"]
["E.2.1.2","ND2","ND2","ND2","ND2"]
["E.2.1.3","ND2","ND2","ND2","ND2"]
["E.2.1.4","ND2","ND2","ND2","ND2"]
["E.2.1.5","ND2","ND2","ND2","ND2"]
["E.2.1.6","ND2","ND2","ND2","ND2"]
["E.2.1.7","ND2","ND2","ND2","ND2"]
["E.2.1.8","ND2","ND2","ND2","ND2"]
["E.2.1.9","ND2","ND2","ND2","ND2"]
["E.2.1.10","ND2","ND2","ND2","ND2"]
["E.2.1.11","ND2","ND2","ND2","ND2"]
["E.2.1.12","ND2","ND2","ND2","ND2"]
["E.2.1.13","ND2","ND2","ND2","ND2"]
["E.2.1.14","ND2","ND2","ND2","ND2"]
["E.2.1.15","ND2","ND2","ND2","ND2"]
["E.2.1.16","ND2","ND2","ND2","ND2"]
["E.2.1.17","ND2","ND2","ND2","ND2"]
["E.2.1.18","ND2","ND2","ND2","ND2"]
["E.2.1.19","ND2","ND2","ND2","ND2"]
["E.2.1.20","ND2","ND2","ND2","ND2"]
["E.2.1.21","ND2","ND2","ND2","ND2"]
["E.2.1.22","ND2","ND2","ND2","ND2"]
["E.2.1.23","ND2","ND2","ND2","ND2"]
["E.2.1.24","ND2","ND2","ND2","ND2"]
["E.2.1.25","ND2","ND2","ND2","ND2"]
["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)",63.541732339357601]
["E.3.1.2","Weighted Average Maturity (months)**",140.31119853022]
["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","<30 days",0,"ND2","ND2","ND2",{"$f":"C82","v":0}]
["E.3.2.2","30-<60 days",0,"ND2","ND2","ND2",{"$f":"C83","v":0}]
["E.3.2.3","60-<90 days",0,"ND2","ND2","ND2",{"$f":"C84","v":0}]
["E.3.2.4","90-<180 days",0,"ND2","ND2","ND2",{"$f":"C85","v":0}]
["E.3.2.5",">= 180 days",0,"ND2","ND2","ND2",{"$f":"C86","v":0}]
["OE.3.2.1"]
["OE.3.2.2"]
["OE.3.2.3"]
["OE.3.2.4"]