{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Summary","Graphs"],"not_rendered":{"charts":22,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Summary","index":0,"n_rows":198,"n_cols":3,"rows_kept":198,"cut":false,"hidden":false,"merged":[]}
[]
[]
["     Paragon Mortgages (No.29) PLC"]
[]
["Information as at the Principal Determination Date","2023-11-30","2024-02-29"]
["Mortgage Asset Balance",896137.16513000091,890002.41155000241]
["Mandatory Further Advance Prefunding Reserve",702,644]
["Available Principal Cash",0,0]
["Retained Principal Ledger Balance for Substitutions",3161,9354]
["Total Assets",{"$f":"+B6+B7+B8+B9","v":900000.16513000091},{"$f":"+C6+C7+C8+C9","v":900000.41155000241}]
["Total Notes (Class A, B, C, D and Z Notes)",{"$f":"SUM(B12:B16)","v":900000},{"$f":"SUM(C12:C16)","v":900000}]
["Class A Notes ",747000,747000]
["Class B Notes",33750,33750]
["Class C Notes",29250,29250]
["Class D Notes",45000,45000]
["Class Z Notes ",45000,45000]
["Class A and B Liquidity Reserve Fund (1.50% of the outstanding Class A and B Notes)",{"$f":"SUM(747000+33750)*1.5%","v":11711.25},{"$f":"SUM(B12+B13)*1.5%","v":11711.25}]
["General Reserve Fund (1.50% of the outstanding Class C and D Notes)",{"$f":"SUM(B14:B15)*1.5%","v":1113.75},{"$f":"SUM(B14:B15)*1.5%","v":1113.75}]
["Class B, C , D and Z Notes as a % of the Total Notes",{"$f":"SUM(B12:B16)/B11","v":1},{"$f":"SUM(C12:C16)/C11","v":1}]
["Retained Notes held by Paragon Bank PLC (Class A, B, C, D and Z Notes)",{"$f":"B11","v":900000},{"$f":"C11","v":900000}]
["Lifetime Redemption Rate",2.7900000000000001E-2,2.7199999999999998E-2]
["Quarterly Redemption Rate",3.5000000000000001E-3,6.8999999999999999E-3]
["PM2010 Lifetime Redemption Rate",5.0299999999999997E-2,6.0900000000000003E-2]
["Paragon Bank Lifetime Redemption Rate ",1.9699999999999999E-2,1.4500000000000001E-2]
["Further Advances released in the quarter",0,0]
["Opening PDL Balance",0,0]
["Quarterly Losses ",{"$f":"+B99+B130+B161+B192","v":0},{"$f":"+C99+C130+C161+C192","v":0}]
["Quarterly Loss Rate (annualised)",{"$f":"1-(1-B27/B6)^4","v":0},{"$f":"1-(1-C27/C6)^4","v":0}]
["PDL Replenishment made during the quarter (-ve = recoveries)",0,0]
["Outstanding PDL at end of the quarter",{"$f":"B26+B27-B29","v":0},0]
["Spread Trap repayment in the quarter","N/A","N/A"]
["Spread % (WA Funding Rate less WA Interest Rate)",0,0]
["Total Income as a % of the Assets",7.573333333333333E-3,2.01E-2]
["Quarterly surplus income to the Issuer",0,1515]
["Surplus Income as a % of the Assets",{"$f":"+B34/900000","v":0},{"$f":"+C34/B10","v":1.683333024479129E-3}]
["Losses as a % of the Assets",{"$f":"+B27/900000","v":0},{"$f":"+C27/B10","v":0}]
["Number of Properties in Possession",{"$f":"+B97+B128+B159","v":0},0]
["Appointment of a Receiver of Rent",0,0]
["Average Number of months (Possessions) in Arrears at the Sale Date",0,0]
["Average Number of months (RoR) in Arrears at the Sale Date",0,0]
["Arrears excluding Receiver of Rent and Possession Cases"]
["Performing Loans",1,0.99959882131175559]
[">1 to 2 months arrears",0,4.0117868824441954E-4]
[">2 to 3 months arrears ",0,0]
[">3 months arrears ",0,0]
["Total ",{"$f":"SUM(B42:B45)","v":1},{"$f":"SUM(C42:C45)","v":1}]
["Total Value of Arrears (£000's)",5.1430393098000007,9.9988294744899999]
["Total Value of Arrears as a % of the Notes (£900,000,000)",{"$f":"+B47/900000","v":5.7144881220000008E-6},{"$f":"+C47/900000","v":1.1109810527211112E-5}]
[]
["Underlying Assets ",{"$f":"+B5","v":"2023-11-30"},{"$f":"+C5","v":"2024-02-29"}]
["Weighted Average LTV",0.6939304590406673,0.69364524333949773]
["Weighted Average Nationwide Indexed LTV",0.65211520515621824,0.65811139378576344]
["% of Fixed Rate Mortgages (reverting to Term SONIA plus a variable margin) ",0,0]
["% of Fixed Rate Mortgages (reverting to SVR)",0.82340761911482308,0.82262021233733407]
["% of Term SONIA Linked Mortgages (reverting to Term SONIA plus a variable margin)",0,0]
["% of Term SONIA Linked Mortgages plus a Variable Margin  ",0,0]
["% of Non Reversionary Term SONIA Linked Mortgages",0,0]
["% of SVR Mortgages",0.17659238088517681,0.17737978766266599]
["Weighted Average Loan Size",216144.99882537409,216703.77685658692]
["Weighted Average Interest Rate",4.7063322318473232E-2,4.7467150949147427E-2]
["Weighted Average Maturity Date (years)",18.319404198699662,18.104276539008683]
["Weighted Average Seasoning (months)",39.645636053588163,42.324810012625434]
["% of Interest Only Mortgages (optional switching to repayment)",0.95368604396183132,0.95447365190906153]
["% of Repayment Mortgages",4.6313956038168673E-2,4.5526348090938404E-2]
["% of Mortgages in London",0.1964929520409478,0.19574994924630329]
["% of Mortgages in the South East",0.30984265975590963,0.31033565559556148]
["% of Owner Occupied Mortgages",0,0]
["% of Investment Home Loans - Professional Landlords",0.78929825962233269,0.79017695917837527]
["% of Investment Home Loans - Emerging Professional Landlords",0.21070174037766731,0.20982304082162473]
["Weighted Average Interest Coverage Ratio (calculated at the origination date)",1.8210713761880311,1.8229038174494412]
["% of PM2010 Originated Assets (Professional)",0.2078292810710311,0.20569317002318574]
["% of PM2010 Originated Assets (Emerging Professional)",7.4945302185137078E-2,7.4217395203416206E-2]
["% of Paragon Bank Originated Assets (Professional)",0.58146897855130075,0.58448378915518751]
["% of Paragon Bank Originated Assets (Emerging Professional)",0.13575643819252997,0.13560564561820784]
[]
["Underlying Assets - Paragon Mortgages 2010 Originated Assets (Professional)",{"$f":"+B5","v":"2023-11-30"},{"$f":"+C5","v":"2024-02-29"}]
["Weighted Average LTV",0.71169172338335962,0.71139973624386221]
["Weighted Average Nationwide Indexed LTV",0.55408395834749058,0.55800514682119506]
["% of Fixed Rate Mortgages (reverting to Term SONIA plus a variable margin) ",0,0]
["% of Fixed Rate Mortgages (reverting to SVR)",0.82548808900108961,0.82529185798745885]
["% of Term SONIA Linked Mortgages (reverting to Term SONIA plus a variable margin) ",0,0]
["% of Term SONIA Linked Mortgages plus a Variable Margin  ",0,0]
["% of Non Reversionary Term SONIA Linked Mortgages ",0,0]
["% of SVR Mortgages",0.17451191099891039,0.17470814201254109]
["Weighted Average Loan Size",175205.59056444027,175184.13144497608]
["Weighted Average Interest Rate",4.5471257490018742E-2,4.62233168869947E-2]
["Weighted Average Maturity Date (years)",13.415388016027521,13.195225229833696]
["Weighted Average Seasoning (months)",93.297092985684429,96.253070303953336]
["% of Interest Only Mortgages (optional switching to repayment)",0.94703937863670828,0.94801811814886461]
["% of Repayment Mortgages",5.2960621363291743E-2,5.1981881851135385E-2]
["% of Mortgages in London",0.24031868286179067,0.23591361282532924]
["% of Mortgages in the South East",0.31021038040147464,0.31207958021088689]
["% of Owner Occupied Mortgages",0,0]
["% of Investment Home Loans - Professional Landlords",1,1]
["% of Investment Home Loans - Emerging Professional Landlords",0,0]
["Weighted Average Interest Coverage Ratio (calculated at the origination date)",1.6185307802942617,1.6190069004560743]
["Number of Properties in Possession",0,0]
["Appointment of a Receiver of Rent",0,0]
["PML Quarterly Losses",0,0]
["Arrears excluding Receiver of Rent and Possession Cases"]
["Performing Loans",1,1]
[">1 to 2 months arrears",0,0]
[">2 to 3 months arrears ",0,0]
[">3 months arrears ",0,0]
["Total ",{"$f":"SUM(B101:B104)","v":1},{"$f":"SUM(C101:C104)","v":1}]
[]
["Underlying Assets - Paragon Mortgages 2010 Originated Assets (Emerging Professional)",{"$f":"+B76","v":"2023-11-30"},"2024-02-29"]
["Weighted Average LTV",0.69472213892505219,0.69434298277487683]
["Weighted Average Nationwide Indexed LTV",0.54563228559052512,0.54970049896002415]
["% of Fixed Rate Mortgages (reverting to Term SONIA plus a variable margin) ",0,0]
["% of Fixed Rate Mortgages (reverting to SVR)",0.78416009075077853,0.76872769978534627]
["% of Term SONIA Linked Mortgages (reverting to Term SONIA plus a variable margin) ",0,0]
["% of Term SONIA Linked Mortgages plus a Variable Margin ",0,0]
["% of Non Reversionary Term SONIA Linked Mortgages ",0,0]
["% of SVR Mortgages",0.21583990924922145,0.23127230021465373]
["Weighted Average Loan Size",176740.18589473685,178042.21215633422]
["Weighted Average Interest Rate",4.6379382307127258E-2,4.8863611706282999E-2]
["Weighted Average Maturity Date (years)",14.213477846620153,13.993499777536149]
["Weighted Average Seasoning (months)",92.359221163122172,95.338550001243362]
["% of Interest Only Mortgages (optional switching to repayment)",0.91448964536743615,0.91527173422573516]
["% of Repayment Mortgages",8.5510354632563873E-2,8.4728265774264858E-2]
["% of Mortgages in London",0.27152843292304929,0.27696294593450699]
["% of Mortgages in the South East",0.40800368380284713,0.40623465454561336]
["% of Owner Occupied Mortgages",0,0]
["% of Investment Home Loans - Professional Landlords",0,0]
["% of Investment Home Loans - Emerging Professional Landlords",1,1]
["Weighted Average Interest Coverage Ratio (calculated at the origination date)",1.5426762148323367,1.5495256990960797]
["Number of Properties in Possession",0,0]
["Appointment of a Receiver of Rent",0,0]
["MTL Quarterly Losses",0,0]
["Arrears excluding Receiver of Rent and Possession Cases"]
["Performing Loans",1,1]
[">1 to 2 months arrears",0,0]
[">2 to 3 months arrears ",0,0]
[">3 months arrears ",0,0]
["Total ",{"$f":"SUM(B132:B135)","v":1},{"$f":"SUM(C132:C135)","v":1}]
[]
["Underlying Assets - Paragon Bank (or Paragon Bank Aquired) Originated Assets (Professional)",{"$f":"+B107","v":"2023-11-30"},"2024-02-29"]
["Weighted Average LTV",0.69020853229459111,0.69009694090670071]
["Weighted Average Nationwide Indexed LTV",0.69513919302494098,0.70121197215291264]
["% of Fixed Rate Mortgages (reverting to Term SONIA plus a variable margin) ",0,0]
["% of Fixed Rate Mortgages (reverting to SVR)",0.82732358244657189,0.8275797281432552]
["% of Term SONIA Linked Mortgages (reverting to Term SONIA plus a variable margin) ",0,0]
["% of Term SONIA Linked Mortgages plus a Variable Margin  ",0,0]
["% of Non Reversionary Term SONIA Linked Mortgages ",0,0]
["% of SVR Mortgages",0.17267641755342811,0.17242027185674472]
["Weighted Average Loan Size",241910.84589136494,242175.03810986961]
["Weighted Average Interest Rate",4.7495698991309829E-2,4.7550023664886087E-2]
["Weighted Average Maturity Date (years)",20.233740982247244,19.990891106574924]
["Weighted Average Seasoning (months)",17.370671111541956,20.317603471493165]
["% of Interest Only Mortgages (optional switching to repayment)",0.96569553986010814,0.96601938942465804]
["% of Repayment Mortgages",3.4304460139891836E-2,3.3980610575341942E-2]
["% of Mortgages in London",0.17392352257712446,0.17420310708362366]
["% of Mortgages in the South East",0.30070028712045038,0.30115073650281887]
["% of Owner Occupied Mortgages",0,0]
["% of Investment Home Loans - Professional Landlords",1,1]
["% of Investment Home Loans - Emerging Professional Landlords",0,0]
["Weighted Average Interest Coverage Ratio (calculated at the origination date)",1.9309235946110448,1.9311230521794054]
["Number of Properties in Possession",0,0]
["Appointment of a Receiver of Rent",0,0]
["Paragon Bank Quarterly Losses",0,0]
["Arrears excluding Receiver of Rent and Possession Cases"]
["Performing Loans",1,1]
[">1 to 2 months arrears",0,0]
[">2 to 3 months arrears ",0,0]
[">3 months arrears ",0,0]
["Total ",{"$f":"SUM(B163:B166)","v":1},{"$f":"SUM(C163:C166)","v":1}]
[]
["Underlying Assets - Paragon Bank (or Paragon Bank Acquired) Originated Assets (Emerging Professional)",{"$f":"+B138","v":"2023-11-30"},"2024-02-29"]
["Weighted Average LTV",0.68224439416405003,0.68162629624731963]
["Weighted Average Nationwide Indexed LTV",0.67669631450439716,0.68352004199051519]
["% of Fixed Rate Mortgages (reverting to Term SONIA plus a variable margin) ",0,0]
["% of Fixed Rate Mortgages (reverting to SVR)",0.82511673963273546,0.8266869017918087]
["% of Term SONIA Linked Mortgages (reverting to Term SONIA plus a variable margin) ",0,0]
["% of Term SONIA Linked Mortgages plus a Variable Margin  ",0,0]
["% of Non Reversionary Term SONIA Linked Mortgages ",0,0]
["% of SVR Mortgages",0.17488326036726462,0.1733130982081913]
["Weighted Average Loan Size",221596.33819672128,222263.99930018416]
["Weighted Average Interest Rate",4.8026239134645224E-2,4.8232375228291088E-2]
["Weighted Average Maturity Date (years)",19.89421418580444,19.66876772959473]
["Weighted Average Seasoning (months)",23.817449896097848,26.36410994474759]
["% of Interest Only Mortgages (optional switching to repayment)",0.9340612531593302,0.93595692290786037]
["% of Repayment Mortgages",6.5938746840669804E-2,6.4043077092139633E-2]
["% of Mortgages in London",0.1846452353298739,0.18325026021877297]
["% of Mortgages in the South East",0.29424763768760304,0.29479315393143718]
["% of Owner Occupied Mortgages",0,0]
["% of Investment Home Loans - Professional Landlords",0,0]
["% of Investment Home Loans - Emerging Professional Landlords",1,1]
["Weighted Average Interest Coverage Ratio (calculated at the origination date)",1.8143138232995561,1.8153615554318012]
["Number of Properties in Possession",0,0]
["Appointment of a Receiver of Rent",0,0]
["Paragon Bank Quarterly Losses",0,0]
["Arrears excluding Receiver of Rent and Possession Cases"]
["Performing Loans",1,0.99704157827341555]
[">1 to 2 months arrears",0,2.9584217265844676E-3]
[">2 to 3 months arrears ",0,0]
[">3 months arrears ",0,0]
["Total ",{"$f":"SUM(B194:B197)","v":1},{"$f":"SUM(C194:C197)","v":1}]

{"sheet":"Graphs","index":1,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"PARAGON MORTGAGES (NO.29) PLC"]