{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Page 1","Page 2","Page 3","Page 4","Page 5","Page 6","Page 7","Page 8","Page 9","Page 10","Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":3,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Page 1","index":0,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[20,1,20,16],[22,1,22,16],[24,1,24,16],[25,1,25,16],[27,1,27,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Report Date:",null,null,"2018-01-31"]
[null,"Reporting Period:",null,null,{"$f":"TEXT(EOMONTH(E15,-1)+1,\"dd-mmmm-yy\")&\" to \"&TEXT(E15,\"dd-mmmm-yy\")","v":"01-January-18 to 31-January-18"}]
[null,"Trustee Distribution Date:",null,null,{"$f":"WORKDAY(EOMONTH(E15,-1),6)","v":"2018-01-08"}]
[null,"Issuer Distribution Date:",null,null,"2018-01-16"]
[]
[]
[null,"Investors (or other appropriate third parties) can register at https://boeportal.co.uk/santanderuk (Internet Explorer version 8 or higher required) to download further disclosures in accordance with the Bank of England Market Notice Detailed eligibility requirements for residential mortgage backed securities and covered bonds backed by residential mortgages dated 30th November 2010."]
[]
[null,"DISCLAIMER: The following document has been prepared by Santander UK.  The document is provided to you for information purposes only.  The document is not intended as an offer or solicitation for the purchase or sale of any financial instrument.  Whilst every effort has been taken to ensure that the document is accurate, current, complete, fit for its intended purpose and compliant with the relevant United Kingdom legislation and regulations as at the date of issue, Santander UK does not warrant that this document is accurate, current, complete, fit for its intended purpose and compliant with the relevant United Kingdom legislation and regulations as errors might occur due to circumstances which are beyond our control.  In particular, Santander UK does not warrant that any market data or prices are complete or accurate.  Any opinions or estimates expressed in the documents may be subject to change without notice and Santander UK is under no obligation to update the opinions or estimates and neither Santander UK nor any of its affiliates accepts any liability whatsoever for any direct or consequential loss arising from any use of this document or its contents.  Please remember that past performance is not necessarily a guide for future performance.  The value of instruments and the income from them can go down as well as up."]
[]
[]
[null,"\n"]
[]
[null,"Contacts:"]
[]
[null,"All queries should be directed to:"]
[]
[]
[null,"Medium Term Funding Team","0207 756 7107","MTF@santander.co.uk"]

{"sheet":"Page 2","index":1,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[6,1,13,1],[6,2,13,2],[6,3,13,3],[6,4,13,4],[18,1,19,1],[18,2,19,2],[18,3,19,3],[18,4,19,4],[20,1,22,1],[20,2,22,2],[20,3,22,3],[20,4,22,4],[24,1,25,1],[24,2,25,2],[24,3,25,3],[24,4,25,4],[26,1,27,1],[26,2,27,2],[26,3,27,3],[26,4,27,4],[31,1,32,6]]}
[null,"MAIN PARTIES TO THE STRUCTURE, RATINGS AND TRIGGERS (IF APPLICABLE)"]
[]
[null,"Role","Counterparty","Fitch/Moody's/S&P Long Term Rating ","Fitch/Moody's/S&P Short Term Rating ","Applicable Trigger (loss of)","Consequence"]
[null,"Issuer","Holmes Master Issuer"]
[null,"Funding","Holmes Funding Limited"]
[null,"Mortgages Trustee ","Holmes Trustees Limited"]
[null,"Seller","Santander UK","A / Aa3 / A","F1 / P-1 / A-1","A3 (Moody's)","Funding required to establish a liquidity reserve fund."]
[null,null,null,null,null,"BBB / Baa2 / BBB","Seller to submit to the Mortgages Trustee, Funding, the Security Trustee and the Rating Agencies draft letters of notice to the Borrowers of sale and purchase of Loans."]
[null,null,null,null,null,"BBB- / Baa3 / BBB-","Completion of legal assignment of Loans to the Mortgages Trustee."]
[null,null,null,null,null,"F2 / P-2 / A-3","New Loans may not be assigned to the Mortgages Trustee."]
[null,null,null,null,null,"F2 / P-2 / A-2","Funding may not offer payments to the Seller to acquire an increased interest in the Trust Property."]
[null,null,null,null,null,"A3 (Moody's)","Independent auditors need to be appointed to determine whether a random selection of Loans and their Related Security constituting the Trust Property complied with the representations and warranties at the date of assignment."]
[null,null,null,null,null,"F1 (Fitch) / A-1 (S&P)","Quarterly (instead of annual) review of the calculation components of the Minimum Seller Share."]
[null,null,null,null,null,"Baa3 (Moody's)","Adjustment to Minimum Seller Share."]
[null,"Servicer","Santander UK","A / Aa3 / A","F1 / P-1 / A-1","F1 / P-1 / A-1","The title deeds and the customer files relating to the Loans in the Portfolio to be segregated from the title deeds and customer files of other properties and mortgages of the Seller which do not form part of the Portfolio."]
[null,"Cash Manager","Santander UK","A / Aa3 / A","F1 / P-1 / A-1"]
[null,"Each Start-up Loan Provider","Santander UK","A / Aa3 / A","F1 / P-1 / A-1"]
[null,"Funding Account Bank A","Bank of New York Mellon","AA+ / Aa1 / AA-","F1+ / P-1 / A-1+","A or F1 / P-1 / A or A-1 (or A+ if no ST rating)","Termination of role and transfer of Funding Transaction Account to a financial institution having the required ratings, unless within 30 calendar days: \n(a) a guarantee of the Account Bank A’s obligations is obtained from a financial institution having the required ratings; or \n(b) such other actions required by the Rating Agencies are taken to ensure that the ratings assigned to the outstanding Rated Notes are not adversely affected."]
[null,"Funding Account Bank B","Santander UK","A / Aa3 / A","F1 / P-1 / A-1"]
[null,null,null,null,null,"A or F1 / P-1 / A or A-1 (or A+ if no ST rating)","Termination of role and transfer of Funding GIC Account to a financial institution having the required ratings, unless within 30 calendar days: \n(a) a guarantee of the Account Bank B’s obligations is obtained from a financial institution having the required ratings; or \n(b) such other actions required by the Rating Agencies are taken to ensure that the ratings assigned to the outstanding Rated Notes are not adversely affected.  \nIf certain conditions are met pursuant to the Panel Bank Guidelines (see Schedule 5 to the Cash Management Agreement) a limited amount of cash may be kept with Santander UK as an Eligible Bank when it is rated below A or F1 / P-1 / A or A-, but no lower than F2 and BBB+ / P-2 / A-2 and BBB+."]
[null,"Mortgage Trust Account Bank","Santander UK","A / Aa3 / A","F1 / P-1 / A-1","BBB+ or F2 / P-2 / BBB+ or A-2\n","Termination of role and transfer of Mortgages Trustee GIC Account to a financial institution rated A and F1 / P-1 / A and A-1 (or A+ if no ST rating), unless within 30 calendar days: (a) the rights and obligations in respect of the provision of the Mortgages Trustee GIC Account are transferred to a financial institution rated A and F1 / P-1 / A and A-1 (or A+ if no ST rating); or\n(b) a guarantee from a financial institution rated A and F1 / P-1 / A and A-1 (or A+ if no ST rating) is obtained; or\n(c) such other action required by the Rating Agencies is taken to ensure that the ratings assigned to the outstanding Rated Notes are not adversely affected, \nand for each of the remedial actions above, a confirmation from the Ratings Agencies that the outstanding Rated Notes will not be downgraded is also required.  "]
[null,null,null,null,null,"A or F1 / P-1 / A or A-1 (or A+ if no ST rating)","Termination of role and transfer of Mortgages Trustee GIC Account to a financial institution rated A and F1 / P-1 / A and A-1 (or A+ if no ST rating), unless within 60 London Business Days: \n(a) a stand-by arrangement is put in place in respect of the Mortgages Trustee GIC Account with a financial institution rated A and F1 / P-1 / A and A-1 (or A+ if no ST rating); or\n(b) such other action required by the Rating Agencies is taken to ensure that the ratings assigned to the outstanding Rated Notes are not adversely affected, \nand for each of the remedial actions above, a confirmation from the Rating Agencies that the outstanding Rated Notes will not be downgraded is also required."]
[null,null,null,null,null,"A or A-1 (or A+ if no ST rating) (S&P)","Termination of role and transfer of Mortgages Trustee GIC Account to a financial institution rated A and F1 / P-1 / A and A-1 (or A+ if no ST rating), unless within 60 London Business Days: \n(a) the Excess Amount (being the amount by which the monies collected by the Servicer in respect of the Loans and standing to the credit of the Mortgages Trustee GIC Account exceed 5% of the Funding Share) is transferred to a financial institution rated A and A-1 (or A+ if no ST rating) by S&P; or\n(b) such other action required by the Rating Agencies is taken to ensure that the ratings assigned to the outstanding Rated Notes are not adversely affected, \nand for each of the remedial actions above, a confirmation from the Rating Agencies that the outstanding Rated Notes will not be downgraded is also required.  "]
[null,"Issuer Account Bank ","Santander UK","A / Aa3 / A","F1 / P-1 / A-1","F1 / P-1 / A or A-1 (or A+ if no ST rating)","Termination of Issuer Bank Account Agreement and closure of account, unless within 30 calendar days: \n(a) the relevant Master Issuer Transaction Account and rights and obligations of the Issuer Account Bank are transferred to a financial institution rated A and F1 / P-1 / A and A-1 (or A+ if no ST rating); \n(b) a guarantee of the Issuer Account Bank’s obligations is obtained from a financial institution having the above ratings; or \n(c) such other actions are taken to ensure that the ratings assigned to the outstanding issuing entity rated notes are not adversely affected,\nand for each of the remedial actions above, a confirmation from the Ratings Agencies that the outstanding Rated Notes will not be downgraded is also required.\n"]
[null,"Funding Swap Provider","Santander UK","A / Aa3 / A","F1 / P-1 / A-1","A or F1 / A2 or P-1 (or A1 if no ST rating) / A or A-1 (A+ if not ST rating) ","Remedial action required including posting collateral with possibility of obtaining guarantee, transferring to eligible transferee or taking such other action as will result in the rating of the relevant Notes being maintained at the same level."]
[null,null,null,null,null,"BBB- or F3 / A3 or P-2 (A3 if no ST rating) / BBB+ ","Further remedial action required including posting/continuing to post collateral with the possibility of obtaining a guarantee, transferring to eligible transferee or taking such other action as will result in the rating of the relevant Notes being maintained at the same level."]
[null,"Issuer Swap Provider","Abbey National Treasury Services plc.","A / Aa3 / A","F1 / P-1 / A-1","A or F1 / A2 or P-1 (or A1 if no ST rating) / A or A-1 (A+ if no ST rating)","Remedial action required as above."]
[null,null,null,null,null,"BBB- or F3 / A3 or P-2 (A3 if no ST rating) / BBB+ ","Further remedial action required as above."]
[null,"Paying Agent and related roles","Bank of New York Mellon","AA+ / Aa1 / AA-","F1+ / P-1 / A-1+"]
[null,"Corporate Services Provider","Wilmington Trust SP Services (London) Limited"]
[null,"Note Trustee and Security Trustee","Bank of New York Mellon"]
[null,"The table above is a brief overview only.  For a more detailed summary, please consult pages 60 to 68 (Rating Triggers Table) of the base prospectus.  Investors are also advised to consult the underlying Transaction Documents to understand the precise legal terms and conditions associated with the roles listed above and the rating triggers summarised above."]

{"sheet":"Page 3","index":2,"n_rows":69,"n_cols":14,"rows_kept":69,"cut":false,"hidden":false,"merged":[[24,1,24,2],[23,9,23,13],[47,1,47,5],[49,1,50,2]]}
[]
[null,"COLLATERAL REPORT"]
[]
[null,"Mortgage Loan Profile",null,null,null,null,null,null,null,"Trust Assets"]
[]
[null,"Original number of Mortgage Loans in Pool",null,null,null,115191,null,null,null,{"$f":"\"Current value of Mortgage Loans in Pool at\"&\" \"&TEXT(EOMONTH('Page 1'!E15,-1)+1,\"dd mmmm yyyy\")","v":"Current value of Mortgage Loans in Pool at 01 January 2018"},null,null,null,{"$f":"HLOOKUP(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$I$5:$DC$41,37,FALSE)","v":4299333067.1700001}]
[null,"Original current value of Mortgage Loans in Pool",null,null,null,6399214137.6800003,null,null,null,{"$f":"\"Last months Closing Trust Assets at\"&\" \"&TEXT(EOMONTH('Page 1'!E15,-2)+1,\"dd mmmm yyyy\")","v":"Last months Closing Trust Assets at 01 December 2017"},null,null,null,{"$f":"HLOOKUP(EOMONTH('Page 1'!E15,-2),'[3]Waterfall - Trustees'!$I$5:$DC$41,37,FALSE)","v":4384489319.6300001}]
[null,{"$f":"\"Current number of Mortgage Loans in Pool at\"&\" \"&TEXT('Page 1'!E15,\"dd-mmmm-yyyy\")","v":"Current number of Mortgage Loans in Pool at 31-January-2018"},null,null,null,{"$f":"D39","v":91387},null,null,null,{"$f":"\"Mortgage collections - Interest on\"&\" \"&TEXT(EOMONTH('Page 1'!E15,-1)+1,\"dd mmmmyyyy\")","v":"Mortgage collections - Interest on 01 January2018"},null,null,null,{"$f":"HLOOKUP(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$I$5:$DC$1048576,166,FALSE)","v":9807678.1999999993}]
[null,{"$f":"\"Current £ value of Mortgage Loans in Pool at\"&\" \"&TEXT('Page 1'!E15,\"dd-mmmm-yyyy\")","v":"Current £ value of Mortgage Loans in Pool at 31-January-2018"},null,null,null,{"$f":"E39","v":4435346115.8199997},null,null,null,{"$f":"\"Mortgage collections - Principal (Scheduled) on\"&\" \"&TEXT(EOMONTH('Page 1'!E15,-1)+1,\"dd mmmm yyyy\")","v":"Mortgage collections - Principal (Scheduled) on 01 January 2018"},null,null,null,{"$f":"+INDEX('[3]Waterfall - Trustees'!$263:$263,MATCH(EOMONTH('Page 1'!E17,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":31365130.259999275}]
[null,{"$f":"\"Weighted Average Yield on\"&\" \"&TEXT('Page 1'!E17,\"dd-mmmm-yyyy\")","v":"Weighted Average Yield on 08-January-2018"},null,null,null,{"$f":"INDEX('[3]Waterfall - Trustees'!$257:$257,MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":2.7175559870741495E-2},null,null,null,{"$f":"\"Mortgage collections - Principal (Unscheduled) on\"&\" \"&TEXT(EOMONTH('Page 1'!E15,-1)+1,\"dd mmmm yyyy\")","v":"Mortgage collections - Principal (Unscheduled) on 01 January 2018"},null,null,null,{"$f":"+('Page 8'!C21+'Page 8'!C24)-'Page 3'!N9","v":53828667.450000718}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Principal Ledger as calculated on\"&\" \"&TEXT('Page 1'!E17,\"dd mmmm yyyy\")","v":"Principal Ledger as calculated on 08 January 2018"},null,null,null,{"$f":"+INDEX('[3]Waterfall - Funding'!$130:$130,MATCH(EOMONTH('Page 1'!E15,-1)+1,'[3]Waterfall - Funding'!$15:$15,0))+INDEX('[3]Waterfall - Funding'!$131:$131,MATCH(EOMONTH('Page 1'!E15,-1)+1,'[3]Waterfall - Funding'!$15:$15,0))+INDEX('[3]Waterfall - Funding'!$132:$132,MATCH(EOMONTH('Page 1'!E15,-1)+1,'[3]Waterfall - Funding'!$15:$15,0))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Funding Share as calculated on\"&\" \"&TEXT(EOMONTH('Page 1'!E15,-1),\"dd mmmm yyyy\")","v":"Funding Share as calculated on 31 December 2017"},null,null,null,{"$f":"INDEX('[3]Waterfall - Trustees'!$A:$BZ,\nMATCH(\"Funding Share IR\",'[3]Waterfall - Trustees'!$C:$C,0),\nMATCH(EOMONTH('Page 1'!$E$15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":1702243163.889998}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Funding Share % as calculated on\"&\" \"&TEXT(EOMONTH('Page 1'!E15,-1),\"dd mmmm yyyy\")","v":"Funding Share % as calculated on 31 December 2017"},null,null,null,{"$f":"INDEX('[3]Waterfall - Trustees'!$A:$BZ,\nMATCH(\"Funding Share %\",'[3]Waterfall - Trustees'!$C:$C,0),\nMATCH(EOMONTH('Page 1'!$E$15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":0.38824209999999998}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Seller Share as calculated on\"&\" \"&TEXT(EOMONTH('Page 1'!E15,-1),\"dd mmmm yyyy\")","v":"Seller Share as calculated on 31 December 2017"},null,null,null,{"$f":"INDEX('[3]Waterfall - Trustees'!$A:$BZ,\nMATCH(\"Seller Share IR\",'[3]Waterfall - Trustees'!$C:$C,0),\nMATCH(EOMONTH('Page 1'!$E$15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":2682246155.7400022}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Seller Share % as calculated on\"&\" \"&TEXT(EOMONTH('Page 1'!E15,-1),\"dd mmmm yyyy\")","v":"Seller Share % as calculated on 31 December 2017"},null,null,null,{"$f":"INDEX('[3]Waterfall - Trustees'!$A:$BZ,\nMATCH(\"Seller Share %\",'[3]Waterfall - Trustees'!$C:$C,0),\nMATCH(EOMONTH('Page 1'!$E$15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":0.61175789999999997}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Minimum Seller Share (Amount)\"&\" \"&TEXT(EOMONTH('Page 1'!E15,-1),\"dd mmmm yyyy\")","v":"Minimum Seller Share (Amount) 31 December 2017"}]
[null,null,null,null,null,null,null,null,null,"W",null,null,null,{"$f":"INDEX('[3]Waterfall - Trustees'!$A:$BZ,\nMATCH(\"Savings Accounts\",'[3]Waterfall - Trustees'!$C:$C,0),\nMATCH(EOMONTH('Page 1'!$E$15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":225452494.93000001}]
[null,null,null,null,null,null,null,null,null,"X",null,null,null,{"$f":"INDEX('[3]Waterfall - Trustees'!$A:$BZ,\nMATCH(\"4.4% of Trust property\",'[3]Waterfall - Trustees'!$C:$C,0),\nMATCH(EOMONTH('Page 1'!$E$15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":189170511.95547998}]
[null,null,null,null,null,null,null,null,null,"Y",null,null,null,{"$f":"INDEX('[3]Waterfall - Trustees'!$A:$BZ,\nMATCH(\"product of p,q and r\",'[3]Waterfall - Trustees'!$C:$C,0),\nMATCH(EOMONTH('Page 1'!$E$15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":196918565.04960001}]
[null,null,null,null,null,null,null,null,null,"Z",null,null,null,{"$f":"INDEX('[3]Waterfall - Trustees'!$A:$BZ,\nMATCH(\"Reductions\",'[3]Waterfall - Trustees'!$C:$C,0),\nMATCH(EOMONTH('Page 1'!$E$15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":0}]
[null,null,null,null,null,null,null,null,null,"AA",null,null,null,{"$f":"INDEX('[3]Waterfall - Trustees'!$A:$BZ,\nMATCH(\"Cashbacks\",'[3]Waterfall - Trustees'!$C:$C,0),\nMATCH(EOMONTH('Page 1'!$E$15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":49854.39}]
[null,null,null,null,null,null,null,null,null,"W + X + Y + Z + AA =",null,null,null,{"$f":"+SUM(N17:N21)","v":611591426.32508004}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Minimum Seller Share (% of Total) on\"&\" \"&TEXT(EOMONTH('Page 1'!E15,-1)+1,\"dd mmmm yyyy\")","v":"Minimum Seller Share (% of Total) on 01 January 2018"},null,null,null,{"$f":"INDEX('[3]Waterfall - Trustees'!$A:$BZ,\nMATCH(\"Minimum Seller Share %\",'[3]Waterfall - Trustees'!$C:$C,0),\nMATCH(EOMONTH('Page 1'!$E$15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":0.14225273527111143}]
[]
[null,{"$f":"\"Arrears Analysis of Non Repossessed Mortgage Loans at\"&\" \"&TEXT('Page 1'!E15,\"dd mmmm yyyy\")","v":"Arrears Analysis of Non Repossessed Mortgage Loans at 31 January 2018"},null,"Number","Current Balance\n£","Arrears \n£","By Number\n%","By Current Balance\n%"]
[null,"<1 month in arrears",null,{"$f":"'[3]Trustee Assets NEW'!E1588","v":89713},{"$f":"'[3]Trustee Assets NEW'!E1628","v":4321086769.0799999},{"$f":"+'[3]Trustee Assets NEW'!E2213","v":0},{"$f":"(D26/$D$39)*100","v":98.168229616903929},{"$f":"(E26/$E$39)*100","v":97.42389108411497}]
[null,"≥1 – <2 months in arrears",null,{"$f":"'[3]Trustee Assets NEW'!E1589","v":1460},{"$f":"'[3]Trustee Assets NEW'!E1629","v":99868329.659999996},{"$f":"+'[3]Trustee Assets NEW'!E2214","v":276329.12999999995},{"$f":"(D27/$D$39)*100","v":1.5976014093908322},{"$f":"(E27/$E$39)*100","v":2.2516468174555637}]
[null,"≥2 – <3 months in arrears",null,{"$f":"'[3]Trustee Assets NEW'!E1590","v":173},{"$f":"'[3]Trustee Assets NEW'!E1630","v":11910824.130000001},{"$f":"+'[3]Trustee Assets NEW'!E2215","v":121022.18000000001},0.18930482453740685,0.26854328431137436]
[null,"≥3 – <4 months in arrears",null,{"$f":"'[3]Trustee Assets NEW'!E1591","v":41},{"$f":"'[3]Trustee Assets NEW'!E1631","v":2480192.9500000002},{"$f":"+'[3]Trustee Assets NEW'!E2216","v":39239.11},4.4864149167824746E-2,5.591881411810555E-2]
[null,"≥4 – <5 months in arrears",null,{"$f":"'[3]Trustee Assets NEW'!E1592","v":0},{"$f":"'[3]Trustee Assets NEW'!E1632","v":0},{"$f":"+'[3]Trustee Assets NEW'!E2217","v":0},0,0]
[null,"≥5 – <6 months in arrears",null,{"$f":"'[3]Trustee Assets NEW'!E1593","v":0},{"$f":"'[3]Trustee Assets NEW'!E1633","v":0},{"$f":"+'[3]Trustee Assets NEW'!E2218","v":0},0,0]
[null,"≥6 – <7 months in arrears",null,{"$f":"'[3]Trustee Assets NEW'!E1594","v":0},{"$f":"'[3]Trustee Assets NEW'!E1634","v":0},{"$f":"+'[3]Trustee Assets NEW'!E2219","v":0},0,0]
[null,"≥7 – <8 months in arrears",null,{"$f":"'[3]Trustee Assets NEW'!E1595","v":0},{"$f":"'[3]Trustee Assets NEW'!E1635","v":0},{"$f":"+'[3]Trustee Assets NEW'!E2220","v":0},0,0]
[null,"≥8 – <9 months in arrears",null,{"$f":"'[3]Trustee Assets NEW'!E1596","v":0},{"$f":"'[3]Trustee Assets NEW'!E1636","v":0},{"$f":"+'[3]Trustee Assets NEW'!E2221","v":0},0,0]
[null,"≥9 – <10 months in arrears",null,{"$f":"'[3]Trustee Assets NEW'!E1597","v":0},{"$f":"'[3]Trustee Assets NEW'!E1637","v":0},{"$f":"+'[3]Trustee Assets NEW'!E2222","v":0},0,0]
[null,"≥10 – <11 months in arrears",null,{"$f":"'[3]Trustee Assets NEW'!E1598","v":0},{"$f":"'[3]Trustee Assets NEW'!E1638","v":0},{"$f":"+'[3]Trustee Assets NEW'!E2223","v":0},0,0]
[null,"≥11 – <12 months in arrears",null,{"$f":"'[3]Trustee Assets NEW'!E1599","v":0},{"$f":"'[3]Trustee Assets NEW'!E1639","v":0},{"$f":"+'[3]Trustee Assets NEW'!E2224","v":0},0,0]
[null,"More than 12 months in arrears",null,{"$f":"'[3]Trustee Assets NEW'!E1600+'[3]Trustee Assets NEW'!$E$1601","v":0},{"$f":"'[3]Trustee Assets NEW'!E1640+'[3]Trustee Assets NEW'!$E$1641","v":0},{"$f":"+'[3]Trustee Assets NEW'!E2225","v":0},0,0]
[null,"Total",null,{"$f":"SUM(D26:D38)","v":91387},{"$f":"SUM(E26:E38)","v":4435346115.8199997},{"$f":"SUM(F26:F38)","v":436590.41999999993},{"$f":"SUM(G26:G38)","v":99.999999999999986},{"$f":"SUM(H26:H38)","v":100.00000000000001}]
[]
[]
[null,{"$f":"\"Arrears Capitalised at\"&\" \"&TEXT('Page 1'!E15,\"dd mmmm yyyy\")","v":"Arrears Capitalised at 31 January 2018"},null,"Number","Current Balance","Capitalised Amount"]
[null,null,null,null,"£","£"]
[]
[null,"Capitalisation cases (in month)",null,{"$f":"'[3]Trustee Assets NEW'!$E$2130","v":1},{"$f":"'[3]Trustee Assets NEW'!$E$2131","v":50080.630000000005},{"$f":"'[3]Trustee Assets NEW'!$E$2132","v":1388.41}]
[null,"Capitalisation cases (cumulative) *",null,{"$f":"'[3]Trustee Assets NEW'!$E$2135","v":900},{"$f":"'[3]Trustee Assets NEW'!$E$2136","v":80317230.349999934},{"$f":"'[3]Trustee Assets NEW'!$E$2137","v":1124108.6600000011}]
[]
[null,"*Includes properties in possession cases, cases no longer in arrears but excludes any Loans repurchased from the Portfolio or Loans that have been redeemed since May 2008.  "]
[]
[null,{"$f":"\"Losses on Properties in Possession at \"&\" \"&TEXT('Page 1'!E15,\"dd mmmm yyyy\")","v":"Losses on Properties in Possession at  31 January 2018"},null,"Number","Loss Amount"]
[null,null,null,null,"£"]
[]
[null,"Total loss on sale brought forward",null,{"$f":"'[3]Trustee Assets NEW'!$E$2194","v":2234},{"$f":"'[3]Trustee Assets NEW'!$E$2195","v":71745264.419999972}]
[null,"Losses recorded this period",null,{"$f":"'[3]Trustee Assets NEW'!$E$2198","v":0},{"$f":"'[3]Trustee Assets NEW'!$E$2199","v":0}]
[null,"Total loss on sale carried forward",null,{"$f":"'[3]Trustee Assets NEW'!$E$2202","v":2234},{"$f":"'[3]Trustee Assets NEW'!$E$2203","v":71745264.419999972}]
[null,"Recoveries*",null,{"$f":"'[3]Trustee Assets NEW'!$E$2205","v":51},{"$f":"'[3]Trustee Assets NEW'!$E$2206","v":134913}]
[]
[null,"*This figure represents all live cases and would therefore exclude cases that have been closed due to bankruptcy."]
[]
[null,{"$f":"\"Properties in Possession at\"&\" \"&TEXT('Page 1'!E15,\"dd mmmm yyyy\")","v":"Properties in Possession at 31 January 2018"},null,"Number","Current Balance"]
[null,null,null,null,"£"]
[]
[null,"Total properties in possession since inception",null,{"$f":"'[3]Trustee Assets NEW'!$E$2143","v":4539},{"$f":"'[3]Trustee Assets NEW'!$E$2144","v":530849819.09000033}]
[]
[null,"Repossessed (in month)",null,{"$f":"'[3]Trustee Assets NEW'!$E$2147","v":0},{"$f":"'[3]Trustee Assets NEW'!$E$2148","v":0}]
[null,"Sold (in month)",null,{"$f":"'[3]Trustee Assets NEW'!$E$2151","v":0},{"$f":"'[3]Trustee Assets NEW'!$E$2152","v":0}]
[null,"Current number in possession",null,{"$f":"'[3]Trustee Assets NEW'!$E$2155","v":0},{"$f":"'[3]Trustee Assets NEW'!$E$2156","v":0}]
[]
[null,"Total properties sold since inception",null,{"$f":"'[3]Trustee Assets NEW'!$E$2159","v":4539},{"$f":"'[3]Trustee Assets NEW'!$E$2160","v":530849819.09000033}]

{"sheet":"Page 4","index":3,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":false,"merged":[[1,8,3,8],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[26,1,26,2],[45,1,45,6],[48,1,49,2],[9,8,10,10],[4,11,6,13],[12,8,13,8],[22,8,23,9],[7,11,8,13],[8,1,8,2]]}
[]
[null,"Product Breakdown",null,"Number","%","Current balance","%",null,{"$f":"\"Substitution, redemptions and repurchases during period \"&TEXT(EOMONTH('Page 1'!E15,-1)+1,\"dd mmmm yyyy\")&\"- \"&TEXT(EOMONTH('Page 1'!E15,0)+1,\"dd mmmm yyyy\")","v":"Substitution, redemptions and repurchases during period 01 January 2018- 01 February 2018"},"Number of accounts","Current balance"]
[null,"(By Balance)",null,"of accounts","by number","£","by balance",null,null,"this period","this period"]
[null,"Discounted SVR Loans",null,{"$f":"'[3]Trustee Assets NEW'!E2088","v":262},{"$f":"(D4/$D$9)*100","v":0.28669285565780689},{"$f":"'[3]Trustee Assets NEW'!E2108","v":3931556.26},{"$f":"(F4/$F$9)*100","v":8.864147593751294E-2},null,null,null,"£"]
[null,"Fixed Rate Loans",null,{"$f":"'[3]Trustee Assets NEW'!E2089","v":879},{"$f":"(D5/$D$9)*100","v":0.96184358825653538},{"$f":"'[3]Trustee Assets NEW'!E2109","v":54148863.93},{"$f":"(F5/$F$9)*100","v":1.220848666958859},null,"Substitution & Top up",0,0]
[null,"Bank of England Base Rate Tracker Loans",null,{"$f":"'[3]Trustee Assets NEW'!$E$2090","v":53773},{"$f":"(D6/$D$9)*100","v":58.840973004913167},{"$f":"'[3]Trustee Assets NEW'!E2110","v":2573085119.21},{"$f":"(F6/$F$9)*100","v":58.013175342332723},null,"Redeemed this period",{"$f":"+'[3]Trustee Assets NEW'!$E$2209","v":1389},{"$f":"+'Page 3'!N10-'Page 4'!K7","v":21377667.460000716}]
[null,"Standard Variable Loans",null,{"$f":"'[3]Trustee Assets NEW'!$E$2091","v":36473},{"$f":"(D7/$D$9)*100","v":39.910490551172487},{"$f":"'[3]Trustee Assets NEW'!E2111","v":1804180576.4200001},{"$f":"(F7/$F$9)*100","v":40.677334514770919},null,"Repurchases this period (including arrears)*",{"$f":"'[3]Trustee Assets NEW'!$E$2184","v":488},{"$f":"-'[3]Trustee Assets NEW'!$E$2185","v":32450999.990000002}]
[null,"Unknown",null,{"$f":"'[3]Trustee Assets NEW'!$E$2092","v":0},{"$f":"D8/$D$9","v":0},0,0,null,"Arrears repurchased this period*",{"$f":"'[3]Trustee Assets NEW'!$E$2173","v":187},{"$f":"-'[3]Trustee Assets NEW'!$E$2174","v":11284287.039999999}]
[null,"Total",null,{"$f":"SUM(D4:D8)","v":91387},{"$f":"SUM(E4:E8)","v":100},{"$f":"SUM(F4:F7)","v":4435346115.8199997},{"$f":"SUM(G4:G7)","v":100.00000000000001},null,"Cumulative arrears repurchased*",{"$f":"'[3]Trustee Assets NEW'!$E$2189","v":8433},{"$f":"-'[3]Trustee Assets NEW'!$E$2190","v":893843561.21999991}]
[null,null,null,null,null,null,null,null,"* “Arrears” for this purpose means, in respect of a Loan, on any date that two or more Monthly Payments have become due and remain unpaid by the relevant Borrower, and this reporting line relates to repurchases under clause 8.11 of the Mortgage Sale Agreement.  "]
[]
[null,"Payment Type",null,"Number","%","Current balance","%"]
[null,"(By Balance)",null,"of accounts","by number","£","by balance",null,{"$f":"\"PPR/CPR Analysis \"&TEXT(EOMONTH('Page 1'!E17,-2)+1,\"dd mmmm yyyy\")&\"- \"&TEXT(EOMONTH('Page 1'!E17,-1)+1,\"dd mmmm yyyy\")","v":"PPR/CPR Analysis 01 December 2017- 01 January 2018"},"1 Month","1 Month Annualised","3 Month Average ","3 Month Annualised","12 Month Average"]
[null,"Interest only and Combined repayment & int-only",null,{"$f":"'[3]Trustee Assets NEW'!$E$714","v":38011},{"$f":"(D14/D16)*100","v":41.593443268736252},{"$f":"'[3]Trustee Assets NEW'!E744","v":2781477786.73},{"$f":"(F14/$F$16)*100","v":62.711628677839158},null,null,"%","%","%","%","%"]
[null,"Repayment",null,{"$f":"'[3]Trustee Assets NEW'!$E$715+'[3]Trustee Assets NEW'!$E$722","v":53376},{"$f":"(D15/D16)*100","v":58.406556731263748},{"$f":"'[3]Trustee Assets NEW'!E745","v":1653868329.0899999},{"$f":"(F15/$F$16)*100","v":37.288371322160849},null,"Total (including unscheduled repayments and repurchases from the Mortgages Trust)"]
[null,"Total",null,{"$f":"SUM(D14:D15)","v":91387},100,{"$f":"SUM(F14:F15)","v":4435346115.8199997},{"$f":"SUM(G14:G15)","v":100},null,"Current month",{"$f":"INDEX('[3]Waterfall - Trustees'!$267:$267,MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":1.9430723055607668E-2},{"$f":"INDEX('[3]Waterfall - Trustees'!$268:$268,MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":0.20979571122524288},{"$f":"INDEX('[3]Waterfall - Trustees'!$273:$273,MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":2.2057781855926439E-2},{"$f":"INDEX('[3]Waterfall - Trustees'!$274:$274,MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":0.23483862237197795},{"$f":"INDEX('[3]Waterfall - Trustees'!$271:$271,MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":0.22602099833301048}]
[null,null,null,null,null,null,null,null,"Previous month",{"$f":"INDEX('[3]Waterfall - Trustees'!$267:$267,MATCH(EOMONTH('Page 1'!E15,-2),'[3]Waterfall - Trustees'!$5:$5,0))","v":2.3665284721292812E-2},{"$f":"INDEX('[3]Waterfall - Trustees'!$268:$268,MATCH(EOMONTH('Page 1'!E15,-2),'[3]Waterfall - Trustees'!$5:$5,0))","v":0.24978666373899483},{"$f":"INDEX('[3]Waterfall - Trustees'!$273:$273,MATCH(EOMONTH('Page 1'!E15,-2),'[3]Waterfall - Trustees'!$5:$5,0))","v":2.3365708912483314E-2},{"$f":"INDEX('[3]Waterfall - Trustees'!$274:$274,MATCH(EOMONTH('Page 1'!E15,-2),'[3]Waterfall - Trustees'!$5:$5,0))","v":0.24701260145360049},{"$f":"INDEX('[3]Waterfall - Trustees'!$271:$271,MATCH(EOMONTH('Page 1'!E15,-2),'[3]Waterfall - Trustees'!$5:$5,0))","v":0.22500256023155177}]
[null,null,null,null,null,null,null,null,"Unscheduled repayments and repurchases from the Mortgages Trust only"]
[null,"Use Of Proceeds",null,"Number","%","Current balance","%",null,"Current month",{"$f":"INDEX('[3]Waterfall - Trustees'!$269:$269,MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":1.2365525334987281E-2},{"$f":"INDEX('[3]Waterfall - Trustees'!$270:$270,MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":0.13869911461631723},{"$f":"INDEX('[3]Waterfall - Trustees'!$275:$275,MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":1.4976400418429082E-2},{"$f":"INDEX('[3]Waterfall - Trustees'!$276:$276,MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":0.16682678684303986},{"$f":"INDEX('[3]Waterfall - Trustees'!$272:$272,MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":0.16269242264730252}]
[null,"(By Balance)",null,"of accounts","by number","£","by balance",null,"Previous month",1.631917933834005E-2,0.1791752451009051,1.6507186727461862E-2,0.18225266114167527,0.1626929473882629]
[null,"Remortgage",null,{"$f":"'[3]Trustee Assets NEW'!$E$521+'[3]Trustee Assets NEW'!$E$522+'[3]Trustee Assets NEW'!$E$523+'[3]Trustee Assets NEW'!$E$524+'[3]Trustee Assets NEW'!$E$525+'[3]Trustee Assets NEW'!$E$526+'[3]Trustee Assets NEW'!$E$527+'[3]Trustee Assets NEW'!$E$528+'[3]Trustee Assets NEW'!$E$531","v":59356},{"$f":"(D21/$D$24)*100","v":64.950157024522099},{"$f":"'[3]Trustee Assets NEW'!$E$559+'[3]Trustee Assets NEW'!$E$560+'[3]Trustee Assets NEW'!$E$561+'[3]Trustee Assets NEW'!$E$562+'[3]Trustee Assets NEW'!$E$563+'[3]Trustee Assets NEW'!$E$564+'[3]Trustee Assets NEW'!$E$565+'[3]Trustee Assets NEW'!$E$566+'[3]Trustee Assets NEW'!$E$569","v":2567408517.8299999},{"$f":"(F21/$F$24)*100","v":57.885189809033463},null,"*As of February 2014 the definitions and calculations for PPR/CPR have been amended to align the reporting between all Santander UK secured funding structures."]
[null,"House Purchase",null,{"$f":"'[3]Trustee Assets NEW'!$E$520","v":32031},{"$f":"(D22/$D$24)*100","v":35.049842975477915},{"$f":"'[3]Trustee Assets NEW'!$E$558","v":1867937597.99},{"$f":"(F22/$F$24)*100","v":42.114810190966544},null,"Standard Variable Rate - Applicable to underwritten Santander UK mortgages"]
[null,"Unknown",null,{"$f":"'[3]Trustee Assets NEW'!$E$533","v":0},{"$f":"(D23/$D$24)*100","v":0},{"$f":"'[3]Trustee Assets NEW'!$E$571","v":0},{"$f":"(F23/$F$24)*100","v":0},null,"Standard Variable Rate - Applicable to underwritten Santander UK mortgages"]
[null,"Total",null,{"$f":"SUM(D21:D23)","v":91387},{"$f":"SUM(E21:E23)","v":100.00000000000001},{"$f":"SUM(F21:F23)","v":4435346115.8199997},{"$f":"SUM(G21:G23)","v":100}]
[null,null,null,null,null,null,null,null,"Existing Borrowers SVR",{"$f":"+'[3]Check-Data'!D13","v":4.7399999999999998E-2}]
[null,null,null,null,null,null,null,null,"Effective date of change",{"$f":"+'[3]Check-Data'!D14","v":"2017-12-01"}]
[null,"Analysis of Mortgage loan size at reporting date",null,"Number","%","Current balance","%",null,"Previous existing Borrowers SVR",{"$f":"+'[3]Check-Data'!D15","v":4.4900000000000002E-2}]
[null,"£",null,"of accounts","by number","£","by balance",null,"Effective date of change",{"$f":"+'[3]Check-Data'!D16","v":"2016-09-01"}]
[null,"0 to <=50,000",null,{"$f":"SUM('[3]Trustee Assets NEW'!$E$599:$E$602)","v":63133},{"$f":"(D29/$D$45)*100","v":69.083129985665366},{"$f":"SUM('[3]Trustee Assets NEW'!$E$655:$E$658)","v":624469104.52999997},{"$f":"(F29/$F$45)*100","v":14.079377081816515}]
[null,">50,000 to <=100,000",null,{"$f":"SUM('[3]Trustee Assets NEW'!$E$603:$E$604)","v":12503},{"$f":"(D30/$D$45)*100","v":13.681377001105192},{"$f":"SUM('[3]Trustee Assets NEW'!$E$659:$E$660)","v":905358844.11999989},{"$f":"(F30/$F$45)*100","v":20.412360624817186}]
[null,">100,000 to <=150,000",null,{"$f":"'[3]Trustee Assets NEW'!E605","v":7274},7.9595566108965174,{"$f":"'[3]Trustee Assets NEW'!E661","v":894174585.07000005},20.1601985892523]
[null,">150,000 to <=200,000",null,{"$f":"'[3]Trustee Assets NEW'!E606","v":3959},4.3321260135467847,{"$f":"'[3]Trustee Assets NEW'!E662","v":681455709.23000002},15.364205891382024]
[null,">200,000 to <=250,000",null,{"$f":"'[3]Trustee Assets NEW'!E607","v":1974},2.1600446452996596,{"$f":"'[3]Trustee Assets NEW'!E663","v":439485232.89999998},9.9087020815003246]
[null,">250,000 to <=300,000",null,{"$f":"'[3]Trustee Assets NEW'!E608","v":1005},1.0997187783820455,{"$f":"'[3]Trustee Assets NEW'!E664","v":274671468.33999997},6.1927854369764157]
[null,">300,000 to <=350,000",null,{"$f":"'[3]Trustee Assets NEW'!E609","v":582},0.63685206867497568,{"$f":"'[3]Trustee Assets NEW'!E665","v":188583477.11000001},4.2518322625907414]
[null,">350,000 to <=400,000",null,{"$f":"'[3]Trustee Assets NEW'!E610","v":360},0.39392911464431485,{"$f":"'[3]Trustee Assets NEW'!E666","v":133955935.04000001},3.0201912442008929]
[null,">400,000 to <=450,000",null,{"$f":"'[3]Trustee Assets NEW'!E611","v":231},0.25277118189676867,{"$f":"'[3]Trustee Assets NEW'!E667","v":97537603.739999995},2.1990979101293298]
[null,">450,000 to <=500,000",null,{"$f":"'[3]Trustee Assets NEW'!E612","v":152},0.16632562618315516,{"$f":"'[3]Trustee Assets NEW'!E668","v":72218486.180000007},1.628249166900662]
[null,">500,000 to <=550,000",null,{"$f":"'[3]Trustee Assets NEW'!E613","v":96},0.10504776390515064,{"$f":"'[3]Trustee Assets NEW'!E669","v":49334816.280000001},1.1123104035563878]
[null,">550,000 to <=600,000",null,{"$f":"'[3]Trustee Assets NEW'!E614","v":46},5.033538687121801E-2,{"$f":"'[3]Trustee Assets NEW'!E670","v":26341024.609999999},0.59388881774179469]
[null,">600,000 to <=650,000",null,{"$f":"'[3]Trustee Assets NEW'!E615","v":32},3.5015921301716872E-2,{"$f":"'[3]Trustee Assets NEW'!E671","v":19873744.530000001},0.44807652009646559]
[null,">650,000 to <=700,000",null,{"$f":"'[3]Trustee Assets NEW'!E616","v":21},2.2979198354251697E-2,{"$f":"'[3]Trustee Assets NEW'!E672","v":14142747.9},0.31886458307178389]
[null,">700,000 to <=750,000",null,{"$f":"'[3]Trustee Assets NEW'!E617","v":19},2.0790703272894395E-2,{"$f":"'[3]Trustee Assets NEW'!E673","v":13743336.24},0.30985938596720219]
[null,"> 750,000",null,{"$f":"SUM('[3]Trustee Assets NEW'!$E$618:$E$620)","v":0},0,{"$f":"SUM('[3]Trustee Assets NEW'!$E$674:$E$677)","v":0},0]
[null,"Total",null,{"$f":"SUM(D29:D44)","v":91387},{"$f":"SUM(E29:E44)","v":99.999999999999972},{"$f":"SUM(F29:F44)","v":4435346115.8199987},{"$f":"SUM(G29:G44)","v":100.00000000000003}]
[null,{"$f":"\"As at the report date, the maximum loan size was \"&TEXT('[3]Trustee Assets NEW'!$E$24,\"£#,##0.00\")&\", the minimum loan size was £0.00 and the average loan size was \"&TEXT(F45/D45,\"£#,##0.00\")","v":"As at the report date, the maximum loan size was £750,000.00, the minimum loan size was £0.00 and the average loan size was £48,533.67"}]
[]
[]
[null,"Geographical Analysis By Region",null,"Number","%","Current balance","%"]
[null,null,null,"of accounts","by number","£","by balance"]
[null,"East Anglia",null,{"$f":"'[3]Trustee Assets NEW'!$E$1054","v":10353},{"$f":"(D51/$D$63)*100","v":11.328744788646087},{"$f":"'[3]Trustee Assets NEW'!$E$1090","v":533288277.76999998},{"$f":"(F51/$F$63)*100","v":12.023600049336995}]
[null,"East Midlands",null,{"$f":"'[3]Trustee Assets NEW'!$E$1052","v":4995},{"$f":"(D52/$D$63)*100","v":5.4657664656898683},{"$f":"'[3]Trustee Assets NEW'!$E$1088","v":206256945.44999999},{"$f":"(F52/$F$63)*100","v":4.6503010151636728}]
[null,"London",null,{"$f":"'[3]Trustee Assets NEW'!$E$1055","v":14175},15.510958889119896,{"$f":"'[3]Trustee Assets NEW'!$E$1091","v":949977123.13},21.418331249090574]
[null,"North",null,{"$f":"'[3]Trustee Assets NEW'!$E$1049","v":3301},3.6121111317802317,{"$f":"'[3]Trustee Assets NEW'!$E$1085","v":108983337.92},2.4571552044445428]
[null,"North West",null,{"$f":"'[3]Trustee Assets NEW'!$E$1050","v":11758},12.866162583299595,{"$f":"'[3]Trustee Assets NEW'!$E$1086","v":452712791.56},10.206932666320297]
[null,"Scotland",null,{"$f":"'[3]Trustee Assets NEW'!$E$1059","v":6119},6.6957007014126741,{"$f":"'[3]Trustee Assets NEW'!$E$1095","v":216358494.90000001},4.8780521125125311]
[null,"South East",null,{"$f":"'[3]Trustee Assets NEW'!$E$1056","v":16597},18.161226432643591,{"$f":"'[3]Trustee Assets NEW'!$E$1092","v":954361826.03999996},21.517189439533944]
[null,"South West",null,{"$f":"'[3]Trustee Assets NEW'!$E$1057","v":7733},8.4618162320680188,{"$f":"'[3]Trustee Assets NEW'!$E$1093","v":380360556.85000002},8.5756679843615657]
[null,"Yorkshire and Humberside",null,{"$f":"'[3]Trustee Assets NEW'!$E$1051","v":5944},6.5042073817939094,{"$f":"'[3]Trustee Assets NEW'!$E$1087","v":221381609.59999999},4.9913040339822796]
[null,"Wales",null,{"$f":"'[3]Trustee Assets NEW'!$E$1058","v":4646},5.0838740739930186,{"$f":"'[3]Trustee Assets NEW'!$E$1094","v":179056263.44},4.0370302286295496]
[null,"West Midlands",null,{"$f":"'[3]Trustee Assets NEW'!$E$1053","v":5766},6.3094313195531093,{"$f":"'[3]Trustee Assets NEW'!$E$1089","v":232608889.16},5.2444360166240518]
[null,"Unknown",null,0,0,0,0]
[null,"Total",null,{"$f":"SUM(D51:D62)","v":91387},{"$f":"SUM(E51:E62)","v":99.999999999999986},{"$f":"SUM(F51:F62)","v":4435346115.8199997},{"$f":"SUM(G51:G62)","v":99.999999999999986}]

{"sheet":"Page 5","index":4,"n_rows":53,"n_cols":18,"rows_kept":53,"cut":false,"hidden":false,"merged":[[13,7,14,11],[15,1,16,5],[28,7,29,11],[43,7,43,11],[52,1,53,5]]}
[]
[null,"Remaining Term","Number","%","Current balance","%",null,"Indexed Current Loan to Value","Number","%","Current balance","%",null,null,null,"Errors",{"$f":"IF(IFERROR(SUM(B1:N70),\"Check\")<>\"Check\",\"Ok\",\"Check\")","v":"Ok"}]
[null,null,"of accounts","by number","£","by balance",null,"Using current capital balance and HPI indexed latest valuation ","of accounts","by number","£","by balance",null,null,null,"Remaining Term",{"$f":"IF(C15=INDEX('[3]Trustee Assets'!$37:$37,MATCH('Page 1'!$E$15,'[3]Trustee Assets'!$6:$6,0)),\"OK\",\"Check\")","v":{"$error":"#N/A"}},{"$f":"IF(E15=INDEX('[3]Trustee Assets'!$93:$93,MATCH('Page 1'!E15,'[3]Trustee Assets'!$6:$6,0)),\"OK\",\"Check\")","v":{"$error":"#N/A"}}]
[null,"0 to <5",{"$f":"+SUM('[3]Trustee Assets NEW'!$E$2016:$E$2017)","v":26924},{"$f":"(C4/$C$15)*100","v":29.461520785232036},{"$f":"SUM('[3]Trustee Assets NEW'!$E$2050:$E$2051)","v":697421709.81999993},{"$f":"(E4/$E$15)*100","v":15.724177811793203},null,">0% =<25%",{"$f":"'[3]Trustee Assets NEW'!$E$1768","v":40404},{"$f":"(I4/$I$13)*100","v":44.211977633580268},{"$f":"'[3]Trustee Assets NEW'!$E$1814","v":779843687.20000005},{"$f":"(K4/$K$13)*100","v":17.58247647051607},null,null,null,"Seasoning",{"$f":"IF(C52=INDEX('[3]Trustee Assets'!$37:$37,MATCH('Page 1'!$E$15,'[3]Trustee Assets'!$6:$6,0)),\"OK\",\"Check\")","v":{"$error":"#N/A"}},{"$f":"IF(E52=INDEX('[3]Trustee Assets'!$93:$93,MATCH('Page 1'!$E$15,'[3]Trustee Assets'!$6:$6,0)),\"OK\",\"Check\")","v":{"$error":"#N/A"}}]
[null,">= 5 to < 10",{"$f":"'[3]Trustee Assets NEW'!$E$2018","v":29197},{"$f":"(C5/$C$15)*100","v":31.948745445194611},{"$f":"'[3]Trustee Assets NEW'!$E$2052","v":1297122433.9100001},29.245123154727924,null,">25% =<50%",{"$f":"SUM('[3]Trustee Assets NEW'!$E$1769:$E$1770)","v":30943},{"$f":"(I5/$I$13)*100","v":33.859301651219539},{"$f":"SUM('[3]Trustee Assets NEW'!$E$1815:$E$1816)","v":1900637787.02},42.852073713949892,null,null,null,"Indexed LTV",{"$f":"IF(I13=INDEX('[3]Trustee Assets'!$37:$37,MATCH('Page 1'!$E$15,'[3]Trustee Assets'!$6:$6,0)),\"OK\",\"Check\")","v":{"$error":"#N/A"}},{"$f":"IF(K13=INDEX('[3]Trustee Assets'!$93:$93,MATCH('Page 1'!$E$15,'[3]Trustee Assets'!$6:$6,0)),\"OK\",\"Check\")","v":{"$error":"#N/A"}}]
[null,">= 10 to < 15",{"$f":"'[3]Trustee Assets NEW'!$E$2019","v":26631},29.140906255813192,{"$f":"'[3]Trustee Assets NEW'!$E$2053","v":1764775989.72},39.788912604258655,null,">50% =<75%",{"$f":"SUM('[3]Trustee Assets NEW'!$E$1771:$E$1775)","v":16896},18.48840644730651,{"$f":"SUM('[3]Trustee Assets NEW'!$E$1817:$E$1821)","v":1476857932.5699999},33.297467525754989,null,null,null,"LTV @Last Valuation",{"$f":"IF(I28=INDEX('[3]Trustee Assets'!$37:$37,MATCH('Page 1'!$E$15,'[3]Trustee Assets'!$6:$6,0)),\"OK\",\"Check\")","v":{"$error":"#N/A"}},{"$f":"IF(K28=INDEX('[3]Trustee Assets'!$93:$93,MATCH('Page 1'!$E$15,'[3]Trustee Assets'!$6:$6,0)),\"OK\",\"Check\")","v":{"$error":"#N/A"}}]
[null,">=15 to < 20",{"$f":"'[3]Trustee Assets NEW'!E2020","v":7587},8.3020560911289358,{"$f":"'[3]Trustee Assets NEW'!$E$2054","v":588909820.51999998},13.277651960902794,null,">75% =<80%",{"$f":"'[3]Trustee Assets NEW'!E1776","v":1181},1.2923063455414883,{"$f":"'[3]Trustee Assets NEW'!E1822","v":103728084.98},2.3386694582869754,null,null,null,"Original LTV",{"$f":"IF(I43=INDEX('[3]Trustee Assets'!$37:$37,MATCH('Page 1'!$E$15,'[3]Trustee Assets'!$6:$6,0)),\"OK\",\"Check\")","v":{"$error":"#N/A"}},{"$f":"IF(K28=INDEX('[3]Trustee Assets'!$93:$93,MATCH('Page 1'!$E$15,'[3]Trustee Assets'!$6:$6,0)),\"OK\",\"Check\")","v":{"$error":"#N/A"}}]
[null,">= 20 to < 25",{"$f":"'[3]Trustee Assets NEW'!E2021","v":754},0.82506264567170384,{"$f":"'[3]Trustee Assets NEW'!$E$2055","v":60879696.899999999},1.3726030688530531,null,">80% =<85%",{"$f":"'[3]Trustee Assets NEW'!E1777","v":846},0.92573341941413978,{"$f":"'[3]Trustee Assets NEW'!E1823","v":71275311.879999995},1.6069842131547545]
[null,">= 25 to < 30",{"$f":"'[3]Trustee Assets NEW'!E2022","v":271},0.29654108352391478,{"$f":"'[3]Trustee Assets NEW'!$E$2056","v":22111679.789999999},0.49853335484083255,null,">85% =<90%",{"$f":"'[3]Trustee Assets NEW'!E1778","v":678},0.74189983258012626,{"$f":"'[3]Trustee Assets NEW'!E1824","v":62486007.770000003},1.4088192023419501]
[null,">= 30 to < 35",{"$f":"'[3]Trustee Assets NEW'!E2023","v":23},2.5167693435609005E-2,{"$f":"'[3]Trustee Assets NEW'!$E$2057","v":4124785.16},9.2998044623568629E-2,null,">90% =<95%",{"$f":"'[3]Trustee Assets NEW'!E1779","v":329},0.36000744088327663,{"$f":"'[3]Trustee Assets NEW'!E1825","v":30547246.260000002},0.68872294207308937]
[null,">= 35 to < 40",{"$f":"'[3]Trustee Assets NEW'!E2024","v":0},0,{"$f":"'[3]Trustee Assets NEW'!E2058","v":0},0,null,">95%",{"$f":"SUM('[3]Trustee Assets NEW'!$E$1780:$E$1784)","v":110},0.12036722947465175,{"$f":"SUM('[3]Trustee Assets NEW'!$E$1826:$E$1830)","v":9970058.1400000006},0.22478647392226683]
[null,">= 40 to < 45",{"$f":"'[3]Trustee Assets NEW'!E2025","v":0},0,{"$f":"'[3]Trustee Assets NEW'!E2059","v":0},0,null,"Unknown",{"$f":"'[3]Trustee Assets NEW'!$E$1785","v":0},0,{"$f":"'[3]Trustee Assets NEW'!$E$1831","v":0},0]
[null,">= 45",{"$f":"'[3]Trustee Assets NEW'!$E$2026","v":0},0,{"$f":"'[3]Trustee Assets NEW'!E2060","v":0},0,null,"Total",{"$f":"SUM(I4:I12)","v":91387},{"$f":"SUM(J4:J12)","v":100.00000000000001},{"$f":"SUM(K4:K12)","v":4435346115.8200006},{"$f":"+SUM(L4:L12)","v":99.999999999999986}]
[null,"Unknown",{"$f":"'[3]Trustee Assets NEW'!$E$2027","v":0},0,{"$f":"'[3]Trustee Assets NEW'!E2061","v":0},0,null,{"$f":"\"As at the report date, the maximum indexed LTV was \"&'[3]Trustee Assets NEW'!$E$40*100&\" %, the minimum indexed LTV was \"&'[3]Trustee Assets NEW'!$E$36*100&\"% and the weighted average indexed LTV was \"&'[3]Trustee Assets NEW'!$E$41*100&\"%\"","v":"As at the report date, the maximum indexed LTV was 122 %, the minimum indexed LTV was 0% and the weighted average indexed LTV was 44.6%"}]
[null,"Total",{"$f":"SUM(C4:C14)","v":91387},{"$f":"SUM(D4:D14)","v":100},{"$f":"SUM(E4:E14)","v":4435346115.8199987},{"$f":"SUM(F4:F14)","v":100.00000000000004}]
[null,{"$f":"\"As at the report date, the maximum remaining term for a loan was \"& '[3]Trustee Assets NEW'!$E$29&\" months, the minimum remaining term was \"&'[3]Trustee Assets NEW'!$E$28&\"  months and the weighted average remaining term was \"& '[3]Trustee Assets NEW'!$E$30&\"  months.\"","v":"As at the report date, the maximum remaining term for a loan was 394 months, the minimum remaining term was 0  months and the weighted average remaining term was 126.4805  months."}]
[null,null,null,null,null,null,null,"Loan to Value at Last Valuation","Number","%","Current balance","%"]
[null,null,null,null,null,null,null,"Using current capital balance and unindexed latest valuation ","of accounts","by number","£","by balance"]
[null,"Seasoning","Number","%","Current balance","%",null,">0% =<25%",{"$f":"'[3]Trustee Assets NEW'!$E$1392","v":28990},{"$f":"(I19/$I$28)*100","v":31.722236204274129},{"$f":"'[3]Trustee Assets NEW'!$E$1438","v":348890758.5},{"$f":"(K19/$K$28)*100","v":7.8661450400809976}]
[null,null,"of accounts","by number","£","by balance",null,">25% =<50%",{"$f":"SUM('[3]Trustee Assets NEW'!$E$1393:$E$1394)","v":26121},{"$f":"(I20/$I$28)*100","v":28.582840010067081},{"$f":"SUM('[3]Trustee Assets NEW'!$E$1439:$E$1440)","v":1065420660.8499999},{"$f":"(K20/$K$28)*100","v":24.021139118091732}]
[null,"0 to <6",{"$f":"'[3]Trustee Assets NEW'!E1865","v":0},{"$f":"(C21/$C$52)*100","v":0},{"$f":"'[3]Trustee Assets NEW'!E1939","v":0},{"$f":"(E21/$E$52)*100","v":0},null,">50% =<75%",{"$f":"SUM('[3]Trustee Assets NEW'!$E$1395:$E$1399)","v":23177},25.361375250309127,{"$f":"SUM('[3]Trustee Assets NEW'!$E$1441:$E$1445)","v":1730032644.4899998},39.005583765364257]
[null,">= 6 to < 12",{"$f":"'[3]Trustee Assets NEW'!E1866","v":0},{"$f":"(C22/$C$52)*100","v":0},{"$f":"'[3]Trustee Assets NEW'!E1940","v":0},{"$f":"(E22/$E$52)*100","v":0},null,">75% =<80%",{"$f":"'[3]Trustee Assets NEW'!E1400","v":4012},4.3901211332027534,{"$f":"'[3]Trustee Assets NEW'!E1446","v":384017798.66000003},8.6581247242528558]
[null,">= 12 to < 18",{"$f":"'[3]Trustee Assets NEW'!E1867","v":0},0,{"$f":"'[3]Trustee Assets NEW'!E1941","v":0},0,null,">80% =<85%",{"$f":"'[3]Trustee Assets NEW'!E1401","v":3236},3.5409850416361186,{"$f":"'[3]Trustee Assets NEW'!E1447","v":310875752.67000002},7.0090528349336241]
[null,">= 18 to < 24",{"$f":"'[3]Trustee Assets NEW'!E1868","v":0},0,{"$f":"'[3]Trustee Assets NEW'!E1942","v":0},0,null,">85% =<90%",{"$f":"'[3]Trustee Assets NEW'!E1402","v":2976},3.2564806810596694,{"$f":"'[3]Trustee Assets NEW'!E1448","v":326375009.25999999},7.3585014728813416]
[null,">= 24 to < 30",{"$f":"'[3]Trustee Assets NEW'!E1869","v":35},3.8298663923752828E-2,{"$f":"'[3]Trustee Assets NEW'!E1943","v":5286731.46},0.11919546574151851,null,">90% =<95%",{"$f":"'[3]Trustee Assets NEW'!E1403","v":1490},1.6304288356111922,{"$f":"'[3]Trustee Assets NEW'!E1449","v":166683675.15000001},3.7580759380980986]
[null,">= 30 to < 36",{"$f":"'[3]Trustee Assets NEW'!E1870","v":25},2.7356188516966307E-2,{"$f":"'[3]Trustee Assets NEW'!E1944","v":2914018.75},6.569991774951392E-2,null,">95%",{"$f":"SUM('[3]Trustee Assets NEW'!$E$1404:$E$1408)","v":1385},1.5155328438399336,{"$f":"SUM('[3]Trustee Assets NEW'!$E$1450:$E$1454)","v":103049816.23999999},2.3233771062971109]
[null,">= 36 to < 42",{"$f":"'[3]Trustee Assets NEW'!E1871","v":36},3.9392911464431482E-2,{"$f":"'[3]Trustee Assets NEW'!E1945","v":4469113.63},0.1007613276010086,null,"Unknown",{"$f":"'[3]Trustee Assets NEW'!$E$1409","v":0},0,{"$f":"'[3]Trustee Assets NEW'!$E$1455","v":0},0]
[null,">= 42 to < 48",{"$f":"'[3]Trustee Assets NEW'!E1872","v":45},4.9241139330539356E-2,{"$f":"'[3]Trustee Assets NEW'!E1946","v":4770538.22},0.10755729305959767,null,"Total",{"$f":"SUM(I19:I27)","v":91387},{"$f":"SUM(J19:J27)","v":100.00000000000001},{"$f":"SUM(K19:K27)","v":4435346115.8199987},{"$f":"SUM(L19:L27)","v":100.00000000000003}]
[null,">=48 to < 54",{"$f":"'[3]Trustee Assets NEW'!E1873","v":41},4.4864149167824746E-2,{"$f":"'[3]Trustee Assets NEW'!E1947","v":4408336.8899999997},9.9391045814357898E-2,null,{"$f":"\"As at the report date, the maximum unindexed LTV was \"&'[3]Trustee Assets NEW'!$E$37*100&\" %, the minimum unindexed LTV was \"&'[3]Trustee Assets NEW'!$E$36*100&\"% and the weighted average unindexed LTV was  \"&'[3]Trustee Assets NEW'!$E$38*100&\"%\"","v":"As at the report date, the maximum unindexed LTV was 195 %, the minimum unindexed LTV was 0% and the weighted average unindexed LTV was  60.19%"}]
[null,">=54 to < 60",{"$f":"'[3]Trustee Assets NEW'!E1874","v":31},3.3921673761038218E-2,{"$f":"'[3]Trustee Assets NEW'!E1948","v":2362687.7200000002},5.3269523015864802E-2]
[null,">= 60 to < 66",{"$f":"'[3]Trustee Assets NEW'!E1875","v":666},0.72876886209198244,{"$f":"'[3]Trustee Assets NEW'!E1949","v":34225958.060000002},0.77166374768189572]
[null,">= 66 to < 72",{"$f":"'[3]Trustee Assets NEW'!E1876","v":1180},1.2912120980008097,{"$f":"'[3]Trustee Assets NEW'!E1950","v":61052916.140000001},1.3765084966477894,null,"Original Loan to Value at Last Valuation","Number","%","Current balance","%"]
[null,">= 72 to < 78",{"$f":"'[3]Trustee Assets NEW'!E1877","v":1237},1.3535842078194928,{"$f":"'[3]Trustee Assets NEW'!E1951","v":78532242.769999996},1.7706001001791285,null,"Using original balance and valuation amount","of accounts","by number","£","by balance"]
[null,">= 78 to < 84",{"$f":"'[3]Trustee Assets NEW'!E1878","v":1636},1.7901889765502752,{"$f":"'[3]Trustee Assets NEW'!E1952","v":107981930.19},2.4345773107728812,null,">0% =<25%",{"$f":"'[3]Trustee Assets NEW'!$E$1242","v":5733},{"$f":"(I34/$I$43)*100","v":6.2733211507107134},{"$f":"'[3]Trustee Assets NEW'!$E$1288","v":100007472.2},{"$f":"(K34/$K$43)*100","v":2.2547839466979407}]
[null,">= 84 to < 90",{"$f":"'[3]Trustee Assets NEW'!E1879","v":1575},1.7234398765688774,{"$f":"'[3]Trustee Assets NEW'!E1953","v":105723575.28},2.3836600914392001,null,">25% =<50%",{"$f":"SUM('[3]Trustee Assets NEW'!$E$1243:$E$1244)","v":22319},{"$f":"(I35/$I$43)*100","v":24.422510860406842},{"$f":"SUM('[3]Trustee Assets NEW'!$E$1289:$E$1290)","v":653053325.77999997},{"$f":"(K35/$K$43)*100","v":14.723841358190477}]
[null,">= 90 to < 96",{"$f":"'[3]Trustee Assets NEW'!E1880","v":794},0.86883254729884996,{"$f":"'[3]Trustee Assets NEW'!E1954","v":46938564.43},1.0582841384707149,null,">50% =<75%",{"$f":"SUM('[3]Trustee Assets NEW'!$E$1245:$E$1249)","v":37806},41.369122522897129,{"$f":"SUM('[3]Trustee Assets NEW'!$E$1291:$E$1295)","v":1967429894.7},44.357978911331585]
[null,">= 96 to < 102",{"$f":"'[3]Trustee Assets NEW'!E1881","v":850},0.93011040957685454,{"$f":"'[3]Trustee Assets NEW'!E1955","v":54005907.799999997},1.2176255559261009,null,">75% =<80%",{"$f":"'[3]Trustee Assets NEW'!E1250","v":5715},6.2536246949784973,{"$f":"'[3]Trustee Assets NEW'!E1296","v":348741893.32999998},7.862788702917836]
[null,">= 102 to < 108",{"$f":"'[3]Trustee Assets NEW'!E1882","v":1813},1.9838707912503966,{"$f":"'[3]Trustee Assets NEW'!E1956","v":108045444.84999999},2.4360093221276089,null,">80% =<85%",{"$f":"'[3]Trustee Assets NEW'!E1251","v":7760},8.4913609156663412,{"$f":"'[3]Trustee Assets NEW'!E1297","v":558667488.57000005},12.595803664055527]
[null,">= 108 to < 114",{"$f":"'[3]Trustee Assets NEW'!E1883","v":2791},3.0540448860341183,{"$f":"'[3]Trustee Assets NEW'!E1957","v":176943164.84},3.9893879805429124,null,">85% =<90%",{"$f":"'[3]Trustee Assets NEW'!E1252","v":8297},9.0789718450107788,{"$f":"'[3]Trustee Assets NEW'!E1298","v":596567932.12},13.450312930306849]
[null,">= 114 to < 120",{"$f":"'[3]Trustee Assets NEW'!E1884","v":4891},5.3519647214592885,{"$f":"'[3]Trustee Assets NEW'!E1958","v":370865915.38999999},8.3616003284883416,null,">90% =<95%",{"$f":"'[3]Trustee Assets NEW'!E1253","v":1384},1.5144385962992548,{"$f":"'[3]Trustee Assets NEW'!E1299","v":79418146.140000001},1.7905738146732502]
[null,">= 120 to < 126",{"$f":"'[3]Trustee Assets NEW'!E1885","v":6933},7.586418199525097,{"$f":"'[3]Trustee Assets NEW'!E1959","v":505947738.93000001},11.407176029067603,null,">95%",{"$f":"SUM('[3]Trustee Assets NEW'!$E$1254:$E$1258)","v":2373},2.5966494140304421,{"$f":"SUM('[3]Trustee Assets NEW'!$E$1300:$E$1304)","v":131459962.98},2.9639166718265435]
[null,">= 126 to < 132",{"$f":"'[3]Trustee Assets NEW'!E1886","v":7547},8.2582861895017885,{"$f":"'[3]Trustee Assets NEW'!E1960","v":465168548.36000001},10.487762086950465,null,"Unknown",{"$f":"'[3]Trustee Assets NEW'!$E$1259","v":0},0,{"$f":"'[3]Trustee Assets NEW'!$E$1305","v":0},0]
[null,">= 132 to < 138",{"$f":"'[3]Trustee Assets NEW'!E1887","v":8694},9.5133881186602025,{"$f":"'[3]Trustee Assets NEW'!E1961","v":449203428.31},10.127810019330408,null,"Total",{"$f":"SUM(I34:I42)","v":91387},100,{"$f":"SUM(K34:K42)","v":4435346115.8199997},{"$f":"SUM(L34:L42)","v":100}]
[null,">= 138 to < 144",{"$f":"'[3]Trustee Assets NEW'!E1888","v":9429},10.317660061059012,{"$f":"'[3]Trustee Assets NEW'!E1962","v":442917394.87},9.9860841364826403,null,{"$f":"\"As at the report date, the maximum original LTV was \"&'[3]Trustee Assets NEW'!$E$34*100&\" ,the minimum LTV at origination was\"&'[3]Trustee Assets NEW'!$E$33*100&\"  and the weighted average LTV at origination was\"&'[3]Trustee Assets NEW'!$E$35*100","v":"As at the report date, the maximum original LTV was 331 ,the minimum LTV at origination was2  and the weighted average LTV at origination was69.27"}]
[null,">= 144 to < 150",{"$f":"'[3]Trustee Assets NEW'!E1889","v":5696},6.2328339917056041,{"$f":"'[3]Trustee Assets NEW'!E1963","v":239559021.50999999},5.4011347762813928]
[null,">= 150 to < 156",{"$f":"'[3]Trustee Assets NEW'!E1890","v":4523},4.9492816264895447,{"$f":"'[3]Trustee Assets NEW'!E1964","v":175379876.74000001},3.9541418450852071]
[null,">= 156 to < 162",{"$f":"'[3]Trustee Assets NEW'!E1891","v":4224},4.6221016118266274,{"$f":"'[3]Trustee Assets NEW'!E1965","v":159250344.13},3.5904829064407311]
[null,">= 162 to < 168",{"$f":"'[3]Trustee Assets NEW'!E1892","v":5642},6.1737446245089558,{"$f":"'[3]Trustee Assets NEW'!E1966","v":182139491.50999999},4.1065451658968524]
[null,">= 168 to < 174",{"$f":"'[3]Trustee Assets NEW'!E1893","v":5632},6.1628021491021698,{"$f":"'[3]Trustee Assets NEW'!E1967","v":184921260.38},4.1692633573831488]
[null,">= 174 to < 180",{"$f":"'[3]Trustee Assets NEW'!E1894","v":3851},4.2139472791534907,{"$f":"'[3]Trustee Assets NEW'!E1968","v":113456461.43000001},2.5580069394206535]
[null,">= 180",{"$f":"'[3]Trustee Assets NEW'!E1895","v":11570},12.660444045652008,{"$f":"'[3]Trustee Assets NEW'!E1969","v":348875503.23000002},7.8658010924024691]
[null,"Total",{"$f":"SUM(C21:C51)","v":91387},{"$f":"SUM(D21:D51)","v":100.00000000000001},{"$f":"SUM(E21:E51)","v":4435346115.8199997},{"$f":"SUM(F21:F51)","v":100}]
[null,{"$f":"\"As at the report date, the maximum seasoning for a loan was \"&'[3]Trustee Assets NEW'!$E$26&\"  months, the minimum seasoning was \"&'[3]Trustee Assets NEW'!$E$25&\"  months and the weighted average seasoning was \"&'[3]Trustee Assets NEW'!$E$27&\" months.\"","v":"As at the report date, the maximum seasoning for a loan was 269  months, the minimum seasoning was 24  months and the weighted average seasoning was 134 months."}]

{"sheet":"Page 6","index":5,"n_rows":34,"n_cols":21,"rows_kept":34,"cut":false,"hidden":false,"merged":[[28,9,28,10],[3,2,3,5],[4,9,4,10],[17,9,17,10]]}
[]
[null,"LOAN NOTE REPORT"]
[]
[]
[null,"Closing Date","2011-09-21",null,null,null,null,null,null,"Series 2011-3 Notes"]
[]
[null,"2011-3","ISIN (Reg S)","ISIN (144a)","Current Ratings\nS&P/Moody's/Fitch","Original Ratings\nS&P/Moody's/Fitch","Currency","Applicable Exchange Rate","Original Balance","Repaid","Outstanding","Reference rate","Margin p.a.%","Current interest rate p.a.%","Accrual Period","Next coupon date","Interest next coupon","Step up Date","Legal Maturity","Bond Type"]
[]
[null,"A1","XS0679914787","US43641NBG88","A-1+/P-1/F1+","A-1+/P-1/F1+","USD",1.5793999999999999,500000000,-500000000,0,"1M USD LIBOR",1.2999999999999999E-3,null,"-","-","-","n/a","2012-07-01","Bullet"]
[null,"A2","XS0679914860","US43641NBH61","AAA/Aaa/AAA","AAA/Aaa/AAA","USD",1.5767500000000001,2000000000,-2000000000,0,"3M USD LIBOR",1.55E-2,null,"-","-","-","2015-01-01","2054-10-01","Sched AM"]
[null,"A3","XS0679918853","XS0679922889","AAA/Aaa/AAA","AAA/Aaa/AAA","EUR",1.1458691417440128,200000000,-200000000,0,"3M EURIBOR",1.4E-2,null,"-","-","-","2015-01-01","2054-10-01","Sched AM"]
[null,"A4","XS0679914944","XS0679923937","AAA/Aaa/AAA","AAA/Aaa/AAA","GBP","-",{"$f":"INDEX('[3]Notes - Issuer'!$379:$379,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":165000000},{"$f":"K12-I12","v":-165000000},0,"3M GBP LIBOR",1.6500000000000001E-2,"-",{"$f":"IF(K12=0,\"-\",INDEX('[3]Notes - Issuer'!$420:$420,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0)))","v":"-"},{"$f":"IF(K12=0,\"-\",INDEX('[3]Notes - Issuer'!$421:$421,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0)))","v":"-"},{"$f":"IF(K12=0,\"-\",INDEX('[3]Notes - Issuer'!$419:$419,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0)))","v":"-"},"2016-10-01","2054-10-01","Sched AM"]
[null,"A5","XS0679915081","US43641NBL73","AAA/Aaa/AAA","AAA/Aaa/AAA","USD",1.58,{"$f":"INDEX('[3]Notes - Issuer'!$434:$434,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,))","v":500000000},{"$f":"K13-I13","v":0},{"$f":"INDEX('[3]Notes - Issuer'!$457:$457,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":500000000},"USD FIXED",0,{"$f":"INDEX('[3]Notes - Issuer'!$470:$470,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":3.6150000000000002E-2},{"$f":"INDEX('[3]Notes - Issuer'!$475:$475,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":"15/01/2018 - 15/07/2019"},{"$f":"INDEX('[3]Notes - Issuer'!$476:$476,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":"15/07/2019"},{"$f":"INDEX('[3]Notes - Issuer'!$474:$474,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":9037500},"2019-01-01","2054-10-01","Sched AM"]
[null,"A6","XS0679915164","US43641NBM56","AAA/Aaa/AAA","AAA/Aaa/AAA","USD",1.58,250000000,{"$f":"I14-K14","v":0},{"$f":"INDEX('[3]Notes - Issuer'!$513:$513,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":250000000},"3M USD LIBOR",1.7500000000000002E-2,{"$f":"INDEX('[3]Notes - Issuer'!$525:$525,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":3.4715200000000002E-2},{"$f":"INDEX('[3]Notes - Issuer'!$530:$530,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":"16/01/2018 - 16/04/2018"},{"$f":"INDEX('[3]Notes - Issuer'!$531:$531,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":"2018-04-16"},{"$f":"INDEX('[3]Notes - Issuer'!$529:$529,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":2169700},"2019-01-01","2054-10-01","Sched AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,".","#"]
[]
[]
[null,"Closing Date","2016-05-26",null,null,null,null,null,null,"Series 2016-1 Notes"]
[]
[null,"2016-1","ISIN (Reg S)","ISIN (144a)","Current Ratings\nS&P/Moody's/Fitch","Original Ratings\nS&P/Moody's/Fitch","Currency","Applicable Exchange Rate","Original Balance","Repaid","Outstanding","Reference rate","Margin p.a.%","Current interest rate p.a.%","Accrual Period","Next coupon date","Interest next coupon","Step up Date","Legal Maturity","Bond Type","Placement"]
[]
[null,"A1","XS1419677387","US43641NBW39","AAA/Aaa/AAA","AAA/Aaa/AAA","USD",1.4601999999999999,{"$f":"INDEX('[3]Notes - Issuer'!$1038:$1038,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":375000000},{"$f":"K22-I22","v":-375000000},0,"1M USD LIBOR",6.0000000000000001E-3,{"$f":"INDEX('[3]Notes - Issuer'!$1074:$1074,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":" "},{"$f":"INDEX('[3]Notes - Issuer'!$1079:$1079,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":" "},{"$f":"INDEX('[3]Notes - Issuer'!$1080:$1080,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":" "},{"$f":"INDEX('[3]Notes - Issuer'!$1078:$1078,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":" "},"N/A","2017-04-01","Sched AM","Public"]
[null,"A2","XS1419677544","XS1419805996","AAA/Aaa/AAA","AAA/Aaa/AAA","GBP","-",{"$f":"INDEX('[3]Notes - Issuer'!$1093:$1093,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":340000000},{"$f":"K23-I23","v":0},{"$f":"INDEX('[3]Notes - Issuer'!$1117:$1117,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":340000000},"3M GBP LIBOR",7.4999999999999997E-3,{"$f":"INDEX('[3]Notes - Issuer'!$1129:$1129,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":1.2715600000000001E-2},{"$f":"INDEX('[3]Notes - Issuer'!$1134:$1134,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":"16/01/2018 - 16/04/2018"},{"$f":"INDEX('[3]Notes - Issuer'!$1135:$1135,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":"2018-04-16"},{"$f":"INDEX('[3]Notes - Issuer'!$1133:$1133,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":1066020.1599999999},"2021-07-15","2054-10-01","Sched AM","Public"]
[null,"Z","XS1419677460","n/a","n/a","n/a","GBP","-",{"$f":"INDEX('[3]Notes - Issuer'!$1148:$1148,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":582000000},{"$f":"K24-I24","v":-194440380},{"$f":"INDEX('[3]Notes - Issuer'!$1172:$1172,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":387559620},"3M GBP LIBOR",8.9999999999999993E-3,{"$f":"INDEX('[3]Notes - Issuer'!$1184:$1184,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":1.4215599999999998E-2},{"$f":"INDEX('[3]Notes - Issuer'!$1189:$1189,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":"16/01/2018 - 16/04/2018"},{"$f":"INDEX('[3]Notes - Issuer'!$1190:$1190,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":"2018-04-16"},{"$f":"INDEX('[3]Notes - Issuer'!$1188:$1188,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":1358480.35},"N/A","2054-10-01","P-Through","Retained"]
[]
[null,"*All Notes are listed on the London Stock Exchange."]
[]
[]
[null,"Closing Date","2017-10-04",null,null,null,null,null,null,"Series 2017-1 Notes"]
[]
[null,"2017-1","ISIN (Reg S)","ISIN (144a)","Current Ratings\nS&P/Moody's/Fitch","Original Ratings\nS&P/Moody's/Fitch","Currency","Applicable Exchange Rate","Original Balance","Repaid","Outstanding","Reference rate","Margin p.a.%","Current interest rate p.a.%","Accrual Period","Next coupon date","Interest next coupon","Step up Date","Legal Maturity","Bond Type","Placement"]
[]
[null,"A1","XS1693006071","n/a","AAA/Aaa/AAA","AAA/Aaa/AAA","GBP","-",{"$f":"INDEX('[3]Notes - Issuer'!$1203:$1203,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":250000000},{"$f":"K33-I33","v":0},{"$f":"INDEX('[3]Notes - Issuer'!$1227:$1227,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":250000000},"3M GBP LIBOR",2.8E-3,{"$f":"INDEX('[3]Notes - Issuer'!$1239:$1239,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!$E$17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!$E$17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":8.0155999999999995E-3},{"$f":"INDEX('[3]Notes - Issuer'!$1244:$1244,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":"16/01/2018 - 16/04/2018"},{"$f":"INDEX('[3]Notes - Issuer'!$1245:$1245,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":"2018-04-16"},{"$f":"INDEX('[3]Notes - Issuer'!$1243:$1243,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":494112.33},"2020-07-15","2054-10-01","Sched AM","Public"]
[null,"A2","XS1693009091","n/a","AAA/Aaa/AAA","AAA/Aaa/AAA","GBP","-",{"$f":"INDEX('[3]Notes - Issuer'!$1258:$1258,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":250000000},{"$f":"K34-I34","v":0},{"$f":"INDEX('[3]Notes - Issuer'!$1282:$1282,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":250000000},"3M GBP LIBOR",4.1999999999999997E-3,{"$f":"INDEX('[3]Notes - Issuer'!$1294:$1294,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":9.4155999999999997E-3},{"$f":"INDEX('[3]Notes - Issuer'!$1299:$1299,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":"16/01/2018 - 16/04/2018"},{"$f":"INDEX('[3]Notes - Issuer'!$1300:$1300,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":"2018-04-16"},{"$f":"INDEX('[3]Notes - Issuer'!$1298:$1298,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0))","v":580413.69999999995},"2023-07-15","2054-10-01","Sched AM","Public"]

{"sheet":"Page 7","index":6,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":false,"merged":[[49,2,50,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[54,2,54,3]]}
[]
[null,"Combined Credit Enhancement","Total","Total","Current note","Subordination","% Required"]
[null,null,"£","%","subordination","+Reserve Fund"]
[]
[null,"Class A Notes",{"$f":"INDEX('[3]Interco - Funding'!$1:$1048576,MATCH((LEFT(B5,7)&\"             (IR)\"),'[3]Interco - Funding'!$C:$C,0),MATCH(EOMONTH('Page 1'!$E$15,-1)+1,'[3]Interco - Funding'!$17:$17,0))","v":1314683544.3},{"$f":"C5/C8","v":0.77232417310991341},{"$f":"SUM(C6:C7)/C8","v":0.22767582689008659},{"$f":"(C6+C7+C11)/$C$8","v":0.28642184044281083},0.23100000000000001]
[null,"Class B Notes",{"$f":"INDEX('[3]Interco - Funding'!$1:$1048576,MATCH((LEFT(B6,7)&\"             (IR)\"),'[3]Interco - Funding'!$C:$C,0),MATCH(EOMONTH('Page 1'!$E$15,-1)+1,'[3]Interco - Funding'!$17:$17,0))","v":0},{"$f":"C6/C8","v":0},{"$f":"C7/C8","v":0.22767582689008659},{"$f":"(C7+C11)/$C$8","v":0.28642184044281083},5.7000000000000002E-2]
[null,"Class Z Notes",{"$f":"INDEX('[3]Interco - Funding'!$1:$1048576,MATCH((LEFT(B7,7)&\"             (IR)\"),'[3]Interco - Funding'!$C:$C,0),MATCH(EOMONTH('Page 1'!$E$15,-1)+1,'[3]Interco - Funding'!$17:$17,0))","v":387559620},{"$f":"C7/C8","v":0.22767582689008659},0,{"$f":"(C11)/$C$8","v":5.8746013552724241E-2}]
[null,null,{"$f":"SUM(C5:C7)","v":1702243164.3},1.0000000000000002]
[]
[]
[null,"Funding Reserve Fund Required Amount",{"$f":"+INDEX('[3]Interco - Funding'!$30:$30,MATCH('Page 1'!E15,'[3]Interco - Funding'!$10:$10,0))","v":100000000},{"$f":"C11/C8","v":5.8746013552724241E-2}]
[]
[]
[]
[null,"Interest shortfall in period",0]
[null,"Cumulative interest shortfall",0]
[null,"Principal shortfall in period",0]
[null,"Cumulative principal shortfall",0]
[null,"Cumulative net loss",0]
[null,"Excess principal paid in current period",0]
[]
[]
[null,"Funding Reserve Fund"]
[]
[null,"Balance brought forward",{"$f":"+INDEX('[3]Interco - Funding'!$30:$30,MATCH('Page 1'!E18,'[3]Interco - Funding'!$14:$14,0))","v":100000000}]
[null,"Drawings",{"$f":"+C25-C28","v":0}]
[null,"Top up",0]
[null,"Balance carried forward",{"$f":"+C11","v":100000000}]
[]
[]
[null,"Quarterly Excess Spread*","Excluding Z notes","Including Z notes"]
[null,null,"interest paymemt","interest paymemt"]
[null,"Quarterly Excess Spread annualised ",{"$f":"INDEX('[3]Waterfall - Funding'!$169:$169,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":2.2777759157655848E-2},{"$f":"INDEX('[3]Waterfall - Funding'!$168:$168,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":3.2039243986698107E-2}]
[null,"Quarterly Excess Spread rolling 12 month average",{"$f":"INDEX('[3]Waterfall - Funding'!$171:$171,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":6.7034686116166489E-2},{"$f":"INDEX('[3]Waterfall - Funding'!$170:$170,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":8.0814982930067142E-2}]
[null,"*Quarterly Excess Spread is calculated at each quarterly Interest Payment Date"]
[]
[]
[null,{"$f":"\"Monthly Excess Spread* as at\"&\" \"&TEXT('Page 1'!E15,\"mmmm yyyy\")","v":"Monthly Excess Spread* as at January 2018"},"Excluding Z notes","Including Z notes"]
[]
[null,"Monthly Excess Spread annualised ",{"$f":"INDEX('[3]Waterfall - Funding'!$167:$167,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":5.7629971769177658E-3},{"$f":"INDEX('[3]Waterfall - Funding'!$166:$166,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":8.9843832044107248E-3}]
[null,"*Monthly Excess Spread is calculated using monthly Funding Revenue received and one third of Fundings quarterly liabilities"]
[]
[]
[null,"Funding Principal Ledger-AAA",{"$f":"IF(MONTH('Page 1'!E17)=MONTH('Page 1'!E18),INDEX('[3]Waterfall - Funding'!$134:$134,MATCH('Page 1'!E18,'[3]Waterfall - Funding'!$6:$6,0)),INDEX('[3]Waterfall - Funding'!$134:$134,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0)))","v":0}]
[null,"Funding Principal Ledger-AA",0]
[null,"Funding Principal Ledger-A",0]
[null,"Funding Principal Ledger-BBB",0]
[null,"Funding Principal Ledger ",{"$f":"SUM(C44:C47)","v":0},null,null,null,null,null,null,null,null,null,"."]
[]
[null,{"$f":"\"Accounts as at \"&\" \"&TEXT(EOMONTH('Page 1'!E15,0),\"dd mmmm yyyy\")","v":"Accounts as at  31 January 2018"},"Counterparty",null,"Rate","Amount"]
[]
[null,"Mortgages Trustee GIC","Santander UK ",null,"Libor",{"$f":"INDEX('[3]Waterfall - Trustees'!$258:$258,MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":208698433.47}]
[null,"Funding GIC ","Santander UK ",null,"Libor",{"$f":"+INDEX('[3]Waterfall - Funding'!$174:$174,MATCH(EOMONTH('Page 1'!E15,-1)+1,'[3]Waterfall - Funding'!$15:$15,0))","v":100496449.53333333}]
[null,"Funding Transaction Account","Santander UK ",null,"Libor - 0.25%",{"$f":"INDEX('[3]Waterfall - Funding'!$175:$175,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":2.73}]
[null,"Panel Banks","Bank of New York Mellon",null,"-",0]

{"sheet":"Page 8","index":7,"n_rows":73,"n_cols":9,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["WATERFALLS"]
[]
[null,"MORTGAGES TRUSTEE REVENUE WATERFALL",null,null,"FUNDING REVENUE WATERFALL",null,null,"ISSUER REVENUE WATERFALL"]
[null,{"$f":"\"*for distribution period  \"&TEXT(EOMONTH('Page 1'!E15,-2)+1,\"dd mmmm yyyy\")&\"- \"&TEXT(EOMONTH('Page 1'!E15,-1)+1,\"dd mmmm yyyy\")","v":"*for distribution period  01 December 2017- 01 January 2018"}]
["(a)","Mortgages Trustee fees",{"$f":"INDEX('[3]Waterfall - Trustees'!$1:$1048576,MATCH(B5,'[3]Waterfall - Trustees'!$C:$C,0),MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":0},"(a)","Funding Security Trustee fees",0,"(a)","Issuing Entity Security Trustee fees",{"$f":"INDEX('[3]Waterfall - Issuer'!$1:$1048576,MATCH(G5,'[3]Waterfall - Issuer'!$B:$B,0),MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Issuer'!$2:$2,0))","v":14100}]
[null,"Other third party payments ",{"$f":"INDEX('[3]Waterfall - Trustees'!$1:$1048576,MATCH(B6,'[3]Waterfall - Trustees'!$C:$C,0),MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":0},null,"Fee under Intercompany Loan",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(E6,'[3]Waterfall - Funding'!$M:$M,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":143951.02499999999},null,"Note Trustee fees",0]
[null,null,null,null,"Other third party payments",0,null,"Agent Bank fees etc.",0]
[]
["(b)","Servicer fee",{"$f":"INDEX('[3]Waterfall - Trustees'!$1:$1048576,MATCH(B9,'[3]Waterfall - Trustees'!$C:$C,0),MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))","v":162296.06}]
[null,null,null,"(b)","Cash Manager fees",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(E10,'[3]Waterfall - Funding'!$C:$C,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":29375},"(b)","Other third party payments",{"$f":"INDEX('[3]Waterfall - Issuer'!$1:$1048576,MATCH(G10,'[3]Waterfall - Issuer'!$B:$B,0),MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Issuer'!$2:$2,0))","v":84726.024999999994}]
[]
["(c)","Funding",{"$f":"INDEX('[3]Waterfall - Funding'!$23:$23,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":3744743.42}]
[null,"Seller",{"$f":"'Page 3'!N8-'Page 8'!C12-'Page 8'!C9-C6","v":5900638.7199999997},"(c)","Funding Corporate Services fees",null,"(c)","Issuing Entity Cash Manager fees",{"$f":"INDEX('[3]Waterfall - Issuer'!$1:$1048576,MATCH(G13,'[3]Waterfall - Issuer'!$B:$B,0),MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Issuer'!$2:$2,0))","v":45125}]
[null,null,null,null,"Account Banks fees",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(E14,'[3]Waterfall - Funding'!$M:$M,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":15750},null,"Issuing Entity Corporate Services Provider fees",0]
[null,null,null,null,null,null,null,"Issuing Entity Account Bank fees",0]
[]
[null,null,null,"(d)","Payment to Funding 1 Swap Provider",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(E17,'[3]Waterfall - Funding'!$M:$M,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":2474237.4402464498}]
[null,"MORTGAGES TRUSTEE PRINCIPAL WATERFALL",null,null,null,null,"(d)","Interest on Class A Notes",{"$f":"INDEX('[3]Waterfall - Issuer'!$240:$240,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Issuer'!$2:$2,0))","v":6140668.1857904783}]
[null,null,null,null,null,null,null,"(including any payments to Issuing Entity Swap Providers)",{"$f":"INDEX('[3]Waterfall - Issuer'!$241:$241,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Issuer'!$2:$2,0))","v":2552952.141474287}]
[null,null,null,"(e)","Interest on AAA Term Advances",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D20,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":4438700.086679766},"(e)","Interest on Class B Notes",{"$f":"INDEX('[3]Waterfall - Issuer'!$243:$243,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Issuer'!$2:$2,0))","v":0}]
["(a)","Funding",{"$f":"INDEX('[3]Waterfall - Funding'!$131:$131,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":0},"(f)","Credit to AAA Principal Deficiency Ledger",0,null,"(including any payments to Issuing Entity Swap Providers)",{"$f":"INDEX('[3]Waterfall - Issuer'!$244:$244,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Issuer'!$2:$2,0))","v":0}]
[null,null,null,null,null,null,"(f)","Interest on Class M Notes",0]
[null,null,null,null,null,null,null,"(including any payments to Issuing Entity Swap Providers)",0]
["(b)","Seller",{"$f":"-INDEX('[3]Waterfall - Trustees'!$64:$64,MATCH(EOMONTH('Page 1'!E15,-1),'[3]Waterfall - Trustees'!$5:$5,0))-'Page 8'!C21","v":85193797.709999993},"(g)","Interest on AA Term Advances",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D24,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":0},"(g)","Interest on Class C Notes",0]
[null,null,null,"(h)","Credit to AA Principal Deficiency Ledger",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D25,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":0},null,"(including any payments to Issuing Entity Swap Providers)",0]
[]
[null,null,null,"(i)","Interest on A Term Advances",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D27,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":0},"(h)","Interest on Class Z Notes",{"$f":"+F45","v":1249163.0546547943}]
[null,null,null,"(j)","Credit to A Principal Deficiency Ledger",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D28,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":0}]
[]
[null,null,null,"(k)","Interest on BBB Term Advances",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D30,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":0},"(i)","Excluded issuer swap payments",0]
[null,null,null,"(l)","Credit to BBB Principal Deficiency Ledger",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D31,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":0}]
[]
[]
[null,null,null,"(m)","Swap termination payments",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D34,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":0},"(j)","Issuing Entity profit ",{"$f":"INDEX('[3]Waterfall - Issuer'!$256:$256,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Issuer'!$2:$2,0))","v":312.5}]
[]
[]
[null,null,null,"(n)","Credit to First Reserve Fund",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D37,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":0}]
[null,null,null,"(o)","Additional credit to First Reserve Fund",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D38,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":0},null,"ISSUER PRINCIPAL WATERFALL"]
[null,null,null,"(p)","Credit to Liquidity Reserve Fund",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D39,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":0}]
[null,null,null,null,null,null,"(a)","Repayment of Class A Notes",{"$f":"INDEX('[3]Waterfall - Issuer'!$375:$375,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Issuer'!$2:$2,0))","v":0}]
[null,null,null,null,null,null,null,"(including principal payments to class A swap providers)",{"$f":"INDEX('[3]Waterfall - Issuer'!$376:$376,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Issuer'!$2:$2,0))","v":0}]
[null,null,null,"(q)","Credit to NR Principal Deficiency Ledger",0,"(b)","Repayment of Class B Notes",{"$f":"INDEX('[3]Waterfall - Issuer'!$378:$378,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Issuer'!$2:$2,0))","v":0}]
[null,null,null,null,null,null,null,"(including principal payments to class A swap providers)",{"$f":"INDEX('[3]Waterfall - Issuer'!$379:$379,MATCH(+TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Issuer'!$2:$2,0))","v":0}]
[null,null,null,null,null,null,"(c)","Repayment of Class M Notes",0]
[null,null,null,"(r)","Interest on NR Term Advances",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D45,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":1249163.0546547943},null,"(including principal payments to class A swap providers)",0]
[null,null,null,null,null,null,"(d)","Repayment of Class C Notes",0]
[null,null,null,null,null,null,null,"(including principal payments to class A swap providers)",0]
[null,null,null,"(s)","Excluded swap payments (with respect to the Issuer) and other fees under the Intercompany Loan Agreement",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D48,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":312.5},"(e)","Repayment of Class Z Notes",0]
[]
[null,null,null,"(u)","Start up loan payments due",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D50,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":1689812.95}]
[]
[]
[null,null,null,"(v)","Profit to Funding ",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D53,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":312.5}]
[]
[]
[null,null,null,"(w)","Deferred Consideration",{"$f":"INDEX('[3]Waterfall - Funding'!$1:$1048576,MATCH(D56,'[3]Waterfall - Funding'!$B:$B,0),MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":1381762.2234189908}]
[]
[]
[null,null,null,null,"FUNDING PRINCIPAL WATERFALL"]
[null,null,null,null,"* To be read in conjunction with rules on pgs. 181- 185 of the base prospectus"]
[]
[null,null,null,"(a)","Repayment of AAA Term Advances",{"$f":"INDEX('[3]Waterfall - Funding'!$149:$149,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":0}]
[]
[]
[null,null,null,"(b)","Credit to Cash Accumulation Ledger",{"$f":"INDEX('[3]Waterfall - Funding'!$150:$150,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E15),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E15),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":0}]
[]
[]
[null,null,null,"(c)","Repayment of AA Term Advances",{"$f":"INDEX('[3]Waterfall - Funding'!$153:$153,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Waterfall - Funding'!$2:$2,0))","v":0}]
[null,null,null,"(d)","Repayment of A Term Advances",0]
[null,null,null,"(e)","Repayment of BBB Term Advances",0]
[]
[]
[null,null,null,"(f)","Repayment of NR Term Advances",0]

{"sheet":"Page 9","index":8,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"SWAP PAYMENTS"]
[]
[]
[null,"Note","Swap Counterparty","Currency Notional","Receive Reference Rate","Receive Margin","Receive Rate","Interest Received","Principal Received","£ Notional","Pay reference rate","Pay margin ","Pay rate","Interest Paid","Principal Paid"]
[null,"Funding 1 Swap","SAN UK",{"$f":"+INDEX('[3]Waterfall - Funding'!$178:$178,MATCH('Page 1'!$E$18,'[3]Waterfall - Funding'!$6:$6,0))","v":1702243164.3},"3M GBP LIBOR",1.794481820180216E-2,{"$f":"+INDEX('[3]Waterfall - Funding'!$180:$180,MATCH('Page 1'!$E$18,'[3]Waterfall - Funding'!$6:$6,0))","v":2.0971749894080991E-2},{"$f":"+INDEX('[3]Waterfall - Funding'!$181:$181,MATCH('Page 1'!$E$18,'[3]Waterfall - Funding'!$6:$6,0))","v":8997496.3920016196},{"$f":"+INDEX('[3]Waterfall - Funding'!$182:$182,MATCH('Page 1'!$E$18,'[3]Waterfall - Funding'!$6:$6,0))","v":0},{"$f":"+INDEX('[3]Waterfall - Funding'!$183:$183,MATCH('Page 1'!$E$18,'[3]Waterfall - Funding'!$6:$6,0))","v":1702243164.3},"3M GBP LIBOR",0,{"$f":"+INDEX('[3]Waterfall - Funding'!$186:$186,MATCH('Page 1'!$E$18,'[3]Waterfall - Funding'!$6:$6,0))","v":2.6736989171914017E-2},{"$f":"+INDEX('[3]Waterfall - Funding'!$187:$187,MATCH('Page 1'!$E$18,'[3]Waterfall - Funding'!$6:$6,0))","v":11471733.832248069},{"$f":"+INDEX('[3]Waterfall - Funding'!$188:$188,MATCH('Page 1'!$E$18,'[3]Waterfall - Funding'!$6:$6,0))","v":0}]
[null,"2011-3 A5","ANTS",{"$f":"+INDEX('[3]Notes - Issuer'!$457:$457,MATCH('Page 1'!$E$18,'[3]Notes - Issuer'!$6:$6,0))","v":500000000},"USD FIXED",0,{"$f":"+'Page 6'!$N$13","v":3.6150000000000002E-2},{"$f":"IF(OR(MONTH('Page 1'!E18)=1,MONTH('Page 1'!E18)=7),INDEX('[3]Notes - Issuer'!$474:$474,MATCH(TEXT(DATE(2000,MONTH('Page 1'!$E$17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!$E$17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0)),0)","v":9037500},{"$f":"+INDEX('[3]Notes - Issuer'!$462:$462,MATCH('Page 1'!$E$18,'[3]Notes - Issuer'!$6:$6,0))","v":0},{"$f":"+INDEX('[3]Interco - Funding'!$262:$262,MATCH('Page 1'!$E$18,'[3]Interco - Funding'!$6:$6,0))+INDEX('[3]Interco - Funding'!$250:$250,MATCH('Page 1'!$E$18,'[3]Interco - Funding'!$6:$6,0))","v":316455696.19999999},"3M GBP LIBOR",1.755E-2,{"$f":"+INDEX('[3]Interco - Funding'!$256:$256,MATCH('Page 1'!$E$18,'[3]Interco - Funding'!$6:$6,0))","v":2.1337499999999999E-2},{"$f":"+INDEX('[3]Interco - Funding'!$258:$258,MATCH('Page 1'!$E$18,'[3]Interco - Funding'!$6:$6,0))","v":1701968.0943161915},{"$f":"+INDEX('[3]Interco - Funding'!$250:$250,MATCH('Page 1'!$E$18,'[3]Interco - Funding'!$6:$6,0))","v":0}]
[null,"2011-3 A6","ANTS",{"$f":"+INDEX('[3]Notes - Issuer'!$512:$512,MATCH('Page 1'!$E$18,'[3]Notes - Issuer'!$6:$6,0))","v":250000000},"3M USD LIBOR",1.7500000000000002E-2,{"$f":"INDEX('[3]Notes - Issuer'!$525:$525,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0)-1)","v":3.10917E-2},{"$f":"INDEX('[3]Notes - Issuer'!$529:$529,MATCH(TEXT(DATE(2000,MONTH('Page 1'!E17),1),\"mmm\")&+TEXT(DATE(YEAR('Page 1'!E17),1,1),\"yy\"),'[3]Notes - Issuer'!$2:$2,0)-1)","v":1986414.17},{"$f":"+INDEX('[3]Notes - Issuer'!$517:$517,MATCH('Page 1'!$E$18,'[3]Notes - Issuer'!$6:$6,0))","v":0},{"$f":"+INDEX('[3]Interco - Funding'!$291:$291,MATCH('Page 1'!$E$18,'[3]Interco - Funding'!$6:$6,0))+INDEX('[3]Interco - Funding'!$279:$279,MATCH('Page 1'!$E$18,'[3]Interco - Funding'!$6:$6,0))","v":158227848.09999999},"3M GBP LIBOR",1.755E-2,{"$f":"+INDEX('[3]Interco - Funding'!$285:$285,MATCH('Page 1'!$E$18,'[3]Interco - Funding'!$6:$6,0))","v":2.1337499999999999E-2},{"$f":"+INDEX('[3]Interco - Funding'!$287:$287,MATCH('Page 1'!$E$18,'[3]Interco - Funding'!$6:$6,0))","v":850984.04715809575},{"$f":"+INDEX('[3]Interco - Funding'!$279:$279,MATCH('Page 1'!$E$18,'[3]Interco - Funding'!$6:$6,0))","v":0}]
[]
[]
[]
[null,"COLLATERAL"]
[]
[]
[null,"Note","Collateral Postings","Counterparty"]
[]
[null,"There was no collateral posted during this period."]

{"sheet":"Page 10","index":9,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":false,"merged":[[21,1,22,1]]}
[null,"TRIGGER EVENTS"]
[null,"Asset "]
[null,"  Amount debited to AAA Principal Deficiency Sub Ledger, unless certain criteria are met","None"]
[]
[null,"Non Asset "]
[null,"  Insolvency Event occurs in relation to Seller.","None"]
[null,"  Seller's role as Servicer terminated & new servicer appointed within 60 days.","None"]
[null,"  The then current Seller Share is less than the Minimum Seller Share.","None"]
[]
[]
[null,"An Arrears Trigger Event will occur if:"]
[]
[null,"(i) the Outstanding Principal Balance of the Loans in arrears for more than 90 days divided by the\nOutstanding Principal Balance of all of the Loans in the Mortgages Trust (expressed as a percentage)\nexceeds 2 per cent.; or","None"]
[null,"(ii) the Issuer does not exercise its option to redeem the Issuing Entity Notes on the relevant\nstep-up date pursuant to the Terms and Conditions of the Issuing Entity Notes (but only where such\nright of redemption arises on or after a particular specified date and not as a result of the occurrence\nof any event specified in the Terms and Conditions of the relevant Issuing Entity Notes)","None"]
[]
[null,"Full details of all Trigger Events can be found within the Holmes Master Issuer plc. base prospectus"]
[]
[null,"Definitions"]
[1,"Current value of mortgages"]
[null,"Includes all amounts of principal, interest and fees as yet unpaid by the borrower. Current Value of Mortgage Loans in Pool in 'Mortgage Loan Profile' and 'Trust Asset' is different due to the 'Mortgage Loan Profile' value including the accrued interest over the reporting period."]
[2,"Arrears"]
[null,"This arrears multiplier is calculated as the arrears amount ( which is the difference between the expected monthly repayments and the amount that has actually been paid, i.e.  a total of under and/or over payments ) divided by the monthly amount repayable.  It is recalculated every time the arrears amount changes, i.e.  on the date when a payment is due."]
[]
[3,"Defaults"]
[null,"For the purpose of the Bank of England Market Notice dated 30 November 2010 \"defaults\" is defined as properties been taken into possession."]
[4,"1 month CPR"]
[null,"On any trust calculation date, the total principal receipts received during the immediately preceding trust calculation period divided by the aggregate current balance of the loans comprised in the trust property calculated on the previous trust calculation date in respect of the previous trust calculation period."]
[5,"1 month annualised CPR"]
[null,"Calculated as 1 – ((1 – R) ^ 12) where R is (i) total principal receipts received scheduled and unscheduled during the relevant period, divided by (ii) the aggregate outstanding principal balance of the loans in the expected portfolio as at the start of that period."]
[6,"3 month average CPR"]
[null,"The total principal receipts received during the immediately preceding trust calculation period for the last 3 months divided by the average aggregate current balance of the last 3 months of the loans comprised in the trust property."]
[7,"3 month annualised CPR"]
[null,"Calculated as 1 – ((1 – R) ^ 4) where R is (i) total principal receipts received scheduled and unscheduled during the relevant period, divided by (ii) the average aggregate outstanding principal balance over the last 3 months of the loans in the expected portfolio as at the start of that period."]
[8,"12 month average CPR"]
[null,"The total principal receipts received during the immediately preceding trust calculation period for the last 12 months divided by the average aggregate current balance of the last 12 months of the loans comprised in the trust property."]
[9]
[null,"Savings balance"]
[10,"X"]
[null,"Current balance of Loans in the trust property multiplied by 4.4%"]
[11,"Y"]
[null,"Flexible drawings set-off risk"]
[12,"Z"]
[null,"Breach of Mortgage Sale Agreement"]
[13,"AA"]
[null,"Reward loans cashbacks"]
[14,"Excess Spread calculation"]
[null,"After a review of the calculation and reporting, Excess Spread has been updated to include 4 reporting components: \n1. Quarterly including Z Notes 2. Quarterly excluding Z Notes 3. Monthly including Z Notes 4.  Monthly excluding Z Notes\nIn all cases Excess Spread is calculated by dividing excess cash available (pre and post Z Note payment) divided by a. Quarterly = the weighted average Funding Share for the relevant period and b. Monthly = the current Funding Share for the relevant period"]
[]
["Notes","Risk retention"]
[null,"The seller confirms that if it sells one or more new loans and their related security to the mortgages trustee on or after 1 January 2015, the seller, in its capacity as originator, (i) on or immediately following the relevant sale date, will retain, on an on-going basis, a material net economic interest of not less than 5 per cent.  in the nominal value of the securitised exposures in accordance with the text of Article 405 of Regulation (EU) No 575/2013 and Article 51 of Regulation (EU) No 231/2013, and (ii) will disclose via an RNS announcement (or in such other manner as the seller may determine) such retained interest and the manner in which it is held.  Any change to the manner in which such interest is held will be notified to noteholders in accordance with the conditions."]
[]
[null,"All capitalised terms used in this investor report have the meaning or descriptions assigned to them in the Holmes Master Issuer plc. base prospectus."]
[]
[null," "]

{"sheet":"Sheet1","index":10,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"MARTA GONZALEZ DEPRIT"]
[null,"TARGOL RASHTCHI"]
[null,"ALVARO RUIZ DE ALDA"]
[null,"JAMIE WILSON ADAMS"]
[null,"MARTIN MCKINNEY"]