{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Note Balance","Cumulative Defaults","Collateral Tables "],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":5,"defined_names":24,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Note Balance","index":0,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
[null,null,"Initial Invested Amount",450000000,122000000,272200000,13500000,9900000]
[null,null,"Invested Amount as at Previous Payment Date:  17 August 2017",450000000,122000000,272200000,13500000,9900000]
[null,null,"Stated Amount as at Previous Payment Date:  17 August 2017",450000000,122000000,272200000,13500000,9900000]
[null,null,"Principal Payments to Noteholders on Payment Date",36788093.090000004,36788093.090000004,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
[null,null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 November 2017",413211906.90999997,85211906.909999996,272200000,13500000,9900000]
[null,null,"Stated Amount as at Payment Date:  16 November 2017",413211906.90999997,85211906.909999996,272200000,13500000,9900000]
[null,null,"Bond Factor at Payment Date:  16 November 2017",null,0.6984582533606557,1,1,1]
[null,null,"Coupon Margin",null,5.7999999999999996E-3,9.2999999999999992E-3,1.7000000000000001E-2,2.3E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.2749999999999999E-2,2.6249999999999999E-2,3.3950000000000001E-2,3.9949999999999999E-2]
[null,null,"Days in Coupon Period",null,91,91,91,91]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 November 2017",null,691973.97,1781418.49,114267.33,98605.36]

{"sheet":"Cumulative Defaults","index":1,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Cumulative Defaults & Losses"]
[]
["Month","Gross Losses","Recoveries","Net Losses"]
["2017-10-01",{"$f":"'Collateral Tables '!E9/450000000","v":0},{"$f":"'Collateral Tables '!E23/450000000","v":0},{"$f":"B4-C4","v":0}]
["2018-01-01"]
["2018-04-01"]
["2018-07-01"]
["2018-10-01"]

{"sheet":"Collateral Tables ","index":2,"n_rows":241,"n_cols":7,"rows_kept":241,"cut":false,"hidden":false,"merged":[]}
[null,"CNHI CAPITAL AUSTRALIA RECEIVABLES TRUST SERIES 2017-1 (TERM DEAL)"]
[null,"COLLATERAL DATA TABLES"]
[]
[null,"OUTSTANDING RECEIVABLES",null,null,"2017-10-31"]
[]
[null,"Opening Balance",null,null,449999902.83999997]
[null,"Principal Repayments - Scheduled",null,null,{"$f":"MIN('[1]16 Nov 17'!$H23,SUM([2]Sheet1!$B$3+[2]Sheet1!$B$4+[2]Sheet1!$B$5+[2]Sheet1!$B$6))","v":29068085.999999996}]
[null,"Principal Repayments - Unscheduled",null,null,{"$f":"MAX('[1]16 Nov 17'!H23-'Collateral Tables '!E7,0)","v":7719909.9299999438}]
[{"$f":"SUM(E9)","v":0},"Charge-Offs",null,null,{"$f":"'[1]16 Nov 17'!$H37","v":0}]
[null,"Reinstatements"]
[null,"New Receivables Purchased"]
[null,"Non Cash Change in Receivables"]
[null,"Closing Balance",null,null,{"$f":"E6-E7-E8-E9+E10+E11-E12","v":413211906.91000003}]
[]
[null,"PORTFOLIO STATISTICS"]
[]
[null,"Summary"]
[null,"Number of contracts",null,null,{"$f":"[3]Summary!$D$4","v":4356}]
[null,"Dollar value of contracts",null,null,{"$f":"[3]Summary!$D$6","v":94860.401035353672}]
[null,"Number of contracts closed during the Quarter",null,null,{"$f":"[3]Summary!$B$19","v":259}]
[null,"Dollar value of contracts closed during the Quarter",null,null,{"$f":"[3]Summary!$B$20","v":11324349.980000002}]
[]
[{"$f":"SUM(E23)","v":0},"Dollar Value of Recoveries from Collateral",null,null,{"$f":"[3]Summary!$C$16","v":0}]
[null,"Dollar Value of Recoveries from Other Sources",null,null,0]
[]
[null,"Average Term of Contracts (Months)",null,null,{"$f":"[4]Sheet1!$W$4358","v":52.791142825226352}]
[null,"Average Term to Maturity (Months)",null,null,{"$f":"[4]Sheet1!$X$4358","v":35.248005455642144}]
[null,"Average Residual / Balloon Payment *",null,null,{"$f":"[4]Sheet1!$AI$4358","v":3.1883835949619785E-2}]
[null,"Average Seasoning (Months)",null,null,{"$f":"E26-E27","v":17.543137369584208}]
[null,"Average Dollar Value of Individual Assets",null,null,{"$f":"E19/E18","v":21.776951569181282}]
[null,"Weighted Average Interest Rate",null,null,{"$f":"[4]Sheet1!$AA$4358/100","v":2.7224187345666846E-2}]
[]
[null,"Payment in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A34,'[5]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":4347},{"$f":"IFERROR(VLOOKUP($A34,'[5]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":271017.78999999992},{"$f":"F34/F$50","v":6.5588088210398259E-4}]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A35,'[5]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":5},{"$f":"IFERROR(VLOOKUP($A35,'[5]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":35820.54},{"$f":"F35/F$50","v":8.6688063439086416E-5}]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A36,'[5]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":2},{"$f":"IFERROR(VLOOKUP($A36,'[5]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":107243.40000000002},2.5953608356053045E-4]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A37,'[5]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A37,'[5]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":25089.710000000014},6.0718748856055268E-5]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A38,'[5]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A38,'[5]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":0},0]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A39,'[5]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A39,'[5]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":0},0]
[null,"Total",null,null,{"$f":"SUM(E34:E39)","v":4356},{"$f":"SUM(F34:F39)","v":439171.43999999994},{"$f":"SUM(G34:G39)","v":1.0628237779596547E-3}]
[null,"* Expressed as a % of Aggreg. Rec. closing bal.",null,null,null,"> 30 days",{"$f":"SUM(G35:G39)","v":4.0694289585567212E-4}]
[]
[" 0 - 30 Days","Account Balances in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A44,'[5]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":4347},{"$f":"IFERROR(VLOOKUP($A44,'[5]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":412348242.53000063},{"$f":"F44/F$50","v":0.99790987537978171}]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A45,'[5]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":5},{"$f":"IFERROR(VLOOKUP($A45,'[5]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":283384.2},{"$f":"F45/F$50","v":6.8580840789208522E-4}]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A46,'[5]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":2},{"$f":"IFERROR(VLOOKUP($A46,'[5]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":207466.89000000004},5.0208352308005319E-4]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A47,'[5]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A47,'[5]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":356437.59},{"$f":"F47/F$50","v":8.6260241788636003E-4}]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A48,'[5]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A48,'[5]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":16375.699999999995},{"$f":"F48/F$50","v":3.9630271359936141E-5}]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A49,'[5]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A49,'[5]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":0},{"$f":"F49/F$50","v":0}]
[null,"Total",null,null,{"$f":"SUM(E44:E49)","v":4356},{"$f":"SUM(F44:F49)","v":413211906.91000056},{"$f":"SUM(G44:G49)","v":1.0000000000000002}]
["NSW",null,null,null,null,"> 30 days",{"$f":"SUM(G45:G49)","v":2.0901246202184344E-3}]
[null,null,null,null,null,">90 days",{"$f":"SUM(G47:G49)","v":9.022326892462962E-4}]
[]
["VIC","Geographic Distribution"]
["NSW","New South Wales",null,null,{"$f":"F55/F$63","v":0.33195637419004981},{"$f":"IFERROR(VLOOKUP($A$55,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":137168326.38999993}]
["VIC","Victoria",null,null,{"$f":"F56/F$63","v":0.15904321078606742},{"$f":"IFERROR(VLOOKUP($A$56,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":65718548.409999982}]
["QLD","Queensland",null,null,0.11059645045502933,{"$f":"IFERROR(VLOOKUP($A$57,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":45699770.18999999}]
["SA","South Australia",null,null,0.18235812797236814,{"$f":"IFERROR(VLOOKUP($A$58,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":75352549.800000027}]
["NT","Northern Territory",null,null,8.0685162848566404E-4,{"$f":"IFERROR(VLOOKUP($A$59,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":333400.7}]
["ACT","Australian Capital Territory",null,null,3.4265033904465526E-4,{"$f":"IFERROR(VLOOKUP($A$60,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":141587.19999999998}]
["TAS","Tasmania",null,null,9.3074462901130087E-3,{"$f":"IFERROR(VLOOKUP($A$61,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":3845947.63}]
["WA","Western Australia",null,null,0.20558888833884209,{"$f":"IFERROR(VLOOKUP($A$62,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":84951776.589999974}]
[null,"Total",null,null,{"$f":"SUM(E55:E62)","v":1.0000000000000002},{"$f":"SUM(F55:F62)","v":413211906.90999985}]
["AG",null,null,null,null,null,{"$f":"E13-F63","v":0}]
["CE","Top Industry Distribution"]
["AGRICULTURAL MACHINERY","Agricultural",null,null,{"$f":"F66/F$69","v":0.96263243066864712},{"$f":"IFERROR(VLOOKUP($A$66,'[5]Top Industry'!$A$1:$C$5,3,FALSE),)","v":397771182.33000034}]
["CONSTRUCTION EQUIPMENT","Construction",null,null,{"$f":"F67/F$69","v":3.7367569331352955E-2},{"$f":"IFERROR(VLOOKUP($A$67,'[5]Top Industry'!$A$1:$C$5,3,FALSE),)","v":15440724.58}]
["MOTOR VEHICLE - AG","Motor Vehicle AG",null,null,{"$f":"F68/F$69","v":0},{"$f":"IFERROR(VLOOKUP($A$68,'[5]Top Industry'!$A$1:$C$5,3,FALSE),)","v":0}]
[null,"Total",null,null,{"$f":"SUM(E66:E68)","v":1},{"$f":"SUM(F66:F68)","v":413211906.91000032},{"$f":"F63-F69","v":-4.76837158203125E-7}]
["COMBINE"]
["40-100 HP TRACTOR","Collateral Types"]
["100<140 HP TRACTOR","100<140 HP TRACTOR",null,null,{"$f":"IFERROR(F72/F$101,0)","v":9.6241139703318532E-2},{"$f":"IFERROR(VLOOKUP($A$72,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":39767984.85999997}]
["4 EWD TRACTORS","4 EWD TRACTORS",null,null,0.10267989716772899,{"$f":"IFERROR(VLOOKUP($A$73,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":42428556.110000014}]
["40<60 HP TRACTOR","40<60 HP TRACTOR",null,null,9.4955126519492943E-3,{"$f":"IFERROR(VLOOKUP($A$74,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":3923658.8899999997}]
["4WD Vehicle","4WD Vehicle",null,null,4.0685035253985668E-4,{"$f":"IFERROR(VLOOKUP($A$75,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":168115.40999999997}]
["60<100 HP TRACTOR","60<100 HP TRACTOR",null,null,5.5437609340210525E-2,{"$f":"IFERROR(VLOOKUP($A$76,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":22907480.270000022}]
["BACKHOE","BACKHOE",null,null,1.1257971569084569E-3,{"$f":"IFERROR(VLOOKUP($A$77,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":465192.79000000004}]
["BALERS, WINDROWERS, MOWERS, RAKES","BALERS, WINDROWERS, MOWERS, RAKES",null,null,3.1481946653665445E-2,{"$f":"IFERROR(VLOOKUP($A$78,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":13008715.209999993}]
["COMBINES","COMBINES",null,null,0.32374721072386048,{"$f":"IFERROR(VLOOKUP($A$79,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":133776202.30000003}]
["COMPACT TRACK LOADER","COMPACT TRACK LOADER",null,null,2.5521060317114467E-4,{"$f":"IFERROR(VLOOKUP($A$80,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":105456.06}]
["CRAWLER  DOZER","CRAWLER  DOZER",null,null,8.4888867947457264E-4,{"$f":"IFERROR(VLOOKUP($A$81,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":350770.91000000003}]
["CULTIVATORS,SEEDERS, HARROWS","CULTIVATORS,SEEDERS, HARROWS",null,null,1.7547948858064526E-2,{"$f":"IFERROR(VLOOKUP($A$82,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":7251021.4100000011}]
["DRILL","DRILL",null,null,7.8927800614185821E-4,{"$f":"IFERROR(VLOOKUP($A$83,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":326139.07}]
["EXCAVATORS / GRADERS","EXCAVATORS / GRADERS",null,null,1.7712056883186774E-2,{"$f":"IFERROR(VLOOKUP($A$84,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":7318832.7999999989}]
["FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE","FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE",null,null,1.5321274373100081E-4,{"$f":"IFERROR(VLOOKUP($A$85,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":63309.33}]
["FRONT END LOADER","FRONT END LOADER",null,null,7.7093446406757118E-4,{"$f":"IFERROR(VLOOKUP($A$86,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":318559.30000000005}]
["FRONTS","FRONTS",null,null,5.0360288636436658E-3,{"$f":"IFERROR(VLOOKUP($A$87,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":2080947.0899999999}]
["HARVESTERS - Other","HARVESTERS - Other",null,null,3.4514338433878403E-3,{"$f":"IFERROR(VLOOKUP($A$88,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":1426173.56}]
["IRRIGATION EQUIPMENT","IRRIGATION EQUIPMENT",null,null,2.6235052327185608E-4,{"$f":"IFERROR(VLOOKUP($A$89,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":108406.36000000002}]
["MATERIALS HANDLING EQUIPMENT","MATERIALS HANDLING EQUIPMENT",null,null,1.0408540819073653E-4,{"$f":"IFERROR(VLOOKUP($A$90,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":43009.329999999987}]
["MINI EXCAVATOR","MINI EXCAVATOR",null,null,3.5194537613282041E-4,{"$f":"IFERROR(VLOOKUP($A$91,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":145428.01999999996}]
["OTHER AG","OTHER AG",null,null,6.3140171335098064E-3,{"$f":"IFERROR(VLOOKUP($A$92,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":2609027.0599999996}]
["OTHER CE","OTHER CE",null,null,9.2803739095428147E-4,{"$f":"IFERROR(VLOOKUP($A$93,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":383476.09999999992}]
["OVER 140 HP TRACTOR","OVER 140 HP TRACTOR",null,null,0.22706452069987371,{"$f":"IFERROR(VLOOKUP($A$94,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":93825763.590000004}]
["SKID STEER LOADER","SKID STEER LOADER",null,null,8.6442813971911598E-5,{"$f":"IFERROR(VLOOKUP($A$95,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":35719.19999999999}]
["SKIDSTEER / UNILOADER","SKIDSTEER / UNILOADER",null,null,1.2906422348476946E-2,{"$f":"IFERROR(VLOOKUP($A$96,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":5333087.3900000006}]
["SPRAYING EQUIPMENT","SPRAYING EQUIPMENT",null,null,8.0296804509137051E-2,{"$f":"IFERROR(VLOOKUP($A$97,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":33179595.710000012}]
["UNDER 40 HP TRACTORS","UNDER 40 HP TRACTORS",null,null,1.4368376372303211E-3,{"$f":"IFERROR(VLOOKUP($A$98,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":593718.41999999993}]
["WHEEL LOADERS (OLD)","WHEEL LOADERS (OLD)",null,null,3.0486826708853308E-3,{"$f":"IFERROR(VLOOKUP($A$99,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":1259751.9799999997}]
["zzDo Not Use Z OVER 100 HP TRACTORS","Under 100 HP TRACTORS",null,null,1.8896793314575795E-5,{"$f":"IFERROR(VLOOKUP($A$100,[5]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":7808.3800000000047}]
[null,"Total",null,null,{"$f":"SUM(E72:E100)","v":0.99999999999999978},{"$f":"SUM(F72:F100)","v":413211906.91000009},{"$f":"F69-F101","v":0}]
["$ 0 - $25,000"]
["$ 25,001 to $50,000","Contract Balance Distribution"]
["$0 - $25,000","$ 0 - $25,000",null,null,{"$f":"IFERROR(F104/F$115,0)","v":3.8358809620295593E-2},{"$f":"IFERROR(VLOOKUP($A104,'[5] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":15850316.869999994}]
["$25,001 - $50,000","$ 25,001 to $50,000",null,null,{"$f":"IFERROR(F105/F$115,0)","v":8.6713470620787866E-2},{"$f":"IFERROR(VLOOKUP($A105,'[5] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":35831038.550000012}]
["$50,001 - $75,000","$ 50,001 to $75,000",null,null,8.3195884182223429E-2,{"$f":"IFERROR(VLOOKUP($A106,'[5] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":34377529.950000048}]
["$75,001 - $100,000","$ 75,001 to $100,000",null,null,7.9629802868112123E-2,{"$f":"IFERROR(VLOOKUP($A107,'[5] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":32903982.689999998}]
["$100,001 - $125,000","$100,001 to $125,000",null,null,6.4040503885488584E-2,{"$f":"IFERROR(VLOOKUP($A108,'[5] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":26462298.73}]
["$125,001 - $150,000","$125,001 to $150,000",null,null,5.245439915341283E-2,{"$f":"IFERROR(VLOOKUP($A109,'[5] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":21674782.300000004}]
["$150,001 - $200,000","$150,000 to $200,000",null,null,0.12003954765224985,{"$f":"IFERROR(VLOOKUP($A110,'[5] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":49601770.389999971}]
["$200,001 - $300,000","$200,001 to $300,000",null,null,0.22601890298466562,{"$f":"IFERROR(VLOOKUP($A111,'[5] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":93393701.899999961}]
["$300,001 - $400,000","$300,001 to $400,000",null,null,0.14234078202110143,{"$f":"IFERROR(VLOOKUP($A112,'[5] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":58816905.969999962}]
["$400,001 - $500,000","$400,001 to $500,000",null,null,6.1329037900932554E-2,{"$f":"IFERROR(VLOOKUP($A113,'[5] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":25341888.700000003}]
["$500,001+","$500,000+",null,null,4.5878859110730072E-2,{"$f":"IFERROR(VLOOKUP($A114,'[5] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":18957690.859999999}]
["$200,001 to $300,000","Total",null,null,{"$f":"SUM(E104:E114)","v":1},{"$f":"SUM(F104:F114)","v":413211906.90999997},{"$f":"F101-F115","v":0}]
["0"]
["0 to 5","Residual / Balloon Payment Distribution"]
["0","0",null,null,{"$f":"IFERROR(F118/F$128,0)","v":0.88946408618387618},{"$f":"IFERROR(VLOOKUP(A118,'[5]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":367537151.18000084}]
["0 to 5","0 to 5",null,null,{"$f":"IFERROR(F119/F$128,0)","v":1.0250280374719492E-3},{"$f":"IFERROR(VLOOKUP(A119,'[5]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":423553.79}]
["6 to 10","06 to 10",null,null,1.4952638577633544E-3,{"$f":"IFERROR(VLOOKUP(A120,'[5]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":617860.82999999996}]
["11 to 15","11 to 15",null,null,7.2822098774985031E-3,{"$f":"IFERROR(VLOOKUP(A121,'[5]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":3009095.83}]
["16 to 20","16 to 20",null,null,1.2567920074798575E-2,{"$f":"IFERROR(VLOOKUP(A122,'[5]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":5193214.22}]
["21 to 25","21 to 25",null,null,1.802908559850044E-2,{"$f":"IFERROR(VLOOKUP(A123,'[5]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":7449832.8400000008}]
["26 to 30","26 to 30",null,null,2.9749431162150477E-2,{"$f":"IFERROR(VLOOKUP(A124,'[5]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":12292819.180000002}]
["31 to 35","31 to 35",null,null,1.3048979929744369E-2,{"$f":"IFERROR(VLOOKUP(A125,'[5]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":5391993.8799999999}]
["36 to 40","36 to 40",null,null,1.9948867571706691E-2,{"$f":"IFERROR(VLOOKUP(A126,'[5]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":8243109.6100000003}]
["41+ %","41+%",null,null,7.3891277064893849E-3,{"$f":"IFERROR(VLOOKUP(A127,'[5]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":3053275.55}]
[null,null,null,null,{"$f":"SUM(E118:E127)","v":0.99999999999999989},{"$f":"SUM(F118:F127)","v":413211906.91000086},{"$f":"F115-F128","v":-8.9406967163085938E-7}]
["2004 Q1"]
["2004 Q2","Quarter of Maturity Distribution"]
[{"$f":"RIGHT(B131,2)&LEFT(B131,4)","v":"Q12017"},"2017Q1",null,null,{"$f":"F131/F$160","v":0},{"$f":"IFERROR(VLOOKUP(A131,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0}]
["Q22017","2017Q2",null,null,0,{"$f":"IFERROR(VLOOKUP(A132,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0}]
[{"$f":"RIGHT(B133,2)&LEFT(B133,4)","v":"Q32017"},"2017Q3",null,null,0,{"$f":"IFERROR(VLOOKUP(A133,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0}]
[{"$f":"RIGHT(B134,2)&LEFT(B134,4)","v":"Q42017"},"2017Q4",null,null,3.9454550382912639E-3,{"$f":"IFERROR(VLOOKUP(A134,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":1630309}]
["Q12018","2018Q1",null,null,1.99199963078334E-2,{"$f":"IFERROR(VLOOKUP(A135,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":8231179.6599999974}]
["Q22018","2018Q2",null,null,7.1318382184031928E-3,{"$f":"IFERROR(VLOOKUP(A136,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":2946960.47}]
["Q32018","2018Q3",null,null,9.3383244661447949E-3,{"$f":"IFERROR(VLOOKUP(A137,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":3858706.8599999985}]
["Q42018","2018Q4",null,null,2.0316929545373719E-2,{"$f":"IFERROR(VLOOKUP(A138,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":8395197.1999999937}]
["Q12019","2019Q1",null,null,4.9365116418203472E-2,{"$f":"IFERROR(VLOOKUP(A139,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":20398253.890000004}]
["Q22019","2019Q2",null,null,2.5119031340645047E-2,{"$f":"IFERROR(VLOOKUP(A140,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":10379482.839999992}]
["Q32019","2019Q3",null,null,3.1367834622498203E-2,{"$f":"IFERROR(VLOOKUP(A141,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":12961562.760000002}]
["Q42019","2019Q4",null,null,4.9997523509165941E-2,{"$f":"IFERROR(VLOOKUP(A142,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":20659572.030000012}]
["Q12020","2020Q1",null,null,0.11170717038425906,{"$f":"IFERROR(VLOOKUP(A143,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":46158732.889999963}]
["Q22020","2020Q2",null,null,4.9098395812729748E-2,{"$f":"IFERROR(VLOOKUP(A144,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":20288041.760000017}]
["Q32020","2020Q3",null,null,3.0004909497200059E-2,{"$f":"IFERROR(VLOOKUP(A145,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":12398385.870000005}]
["Q42020","2020Q4",null,null,5.5899057562808642E-2,{"$f":"IFERROR(VLOOKUP(A146,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":23098156.170000013}]
["Q12021","2021Q1",null,null,0.2103707266328444,{"$f":"IFERROR(VLOOKUP(A147,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":86927689.109999955}]
["Q22021","2021Q2",null,null,8.705164376551873E-2,{"$f":"IFERROR(VLOOKUP(A148,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":35970775.720000006}]
["Q32021","2021Q3",null,null,6.2628960049877266E-2,{"$f":"IFERROR(VLOOKUP(A149,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":25879032.009999994}]
["Q42021","2021Q4",null,null,7.4272720671344439E-2,{"$f":"IFERROR(VLOOKUP(A150,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":30690372.540000007}]
["Q12022","2022Q1",null,null,9.570889514230238E-2,{"$f":"IFERROR(VLOOKUP(A151,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":39548055.07}]
["Q22022","2022Q2",null,null,1.8331725135040352E-3,{"$f":"IFERROR(VLOOKUP(A152,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":757488.71000000008}]
["Q32022","2022Q3",null,null,2.7922170699967255E-3,{"$f":"IFERROR(VLOOKUP(A153,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":1153777.3399999999}]
["Q42022","2022Q4",null,null,2.1300814310554399E-3,{"$f":"IFERROR(VLOOKUP(A154,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":880175.01}]
["Q12023","2023Q1",null,null,0,{"$f":"IFERROR(VLOOKUP(A155,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0}]
["Q22023","2023Q2",null,null,0,{"$f":"IFERROR(VLOOKUP(A156,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0}]
["Q32023","2023Q3",null,null,0,{"$f":"IFERROR(VLOOKUP(A157,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0}]
["Q42023","2023Q4",null,null,0,{"$f":"IFERROR(VLOOKUP(A158,'[5]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0}]
[]
[null,null,null,null,{"$f":"SUM(E131:E158)","v":1.0000000000000002},{"$f":"SUM(F131:F159)","v":413211906.90999997},{"$f":"F128-F160","v":8.9406967163085938E-7}]
["0 to 6 months"]
["07 to 12 months","Seasoning Distribution"]
["0 to 6 months","0 to 6 months",null,null,{"$f":"F163/F$174","v":0},{"$f":"IFERROR(VLOOKUP(A163,'[5]Seasoning Distribution'!$A$1:$C$11,3,FALSE),0)","v":0}]
["07 to 12 months","07 to 12 months",null,null,{"$f":"F164/F$174","v":0.23745559658175802},{"$f":"IFERROR(VLOOKUP(A164,'[5]Seasoning Distribution'!$A$1:$C$11,3,FALSE),0)","v":98119479.86999996}]
["13 to 18 months","13 to 18 months",null,null,0.34726202258555344,{"$f":"IFERROR(VLOOKUP(A165,'[5]Seasoning Distribution'!$A$1:$C$11,3,FALSE),0)","v":143492802.5500001}]
["19 to 24 months","19 to 24 months",null,null,0.24638760308563651,{"$f":"IFERROR(VLOOKUP(A166,'[5]Seasoning Distribution'!$A$1:$C$11,3,FALSE),0)","v":101810291.31000011}]
["25 to 30 months","25 to 30 months",null,null,0.10226532416744677,{"$f":"IFERROR(VLOOKUP(A167,'[5]Seasoning Distribution'!$A$1:$C$11,3,FALSE),0)","v":42257249.610000007}]
["31 to 36 months","31 to 36 months",null,null,2.774877685820749E-2,{"$f":"IFERROR(VLOOKUP(A168,'[5]Seasoning Distribution'!$A$1:$C$11,3,FALSE),0)","v":11466125.000000002}]
["37 to 42 months","37 to 42 months",null,null,1.6001457773674763E-2,{"$f":"IFERROR(VLOOKUP(A169,'[5]Seasoning Distribution'!$A$1:$C$11,3,FALSE),0)","v":6611992.8799999952}]
["43 to 48 months","43 to 48 months",null,null,3.8116436231907698E-3,{"$f":"IFERROR(VLOOKUP(A170,'[5]Seasoning Distribution'!$A$1:$C$11,3,FALSE),0)","v":1575016.5300000003}]
["49 to 54 months","49 to 54 months",null,null,1.0102527493016371E-2,{"$f":"IFERROR(VLOOKUP(A171,'[5]Seasoning Distribution'!$A$1:$C$11,3,FALSE),0)","v":4174484.6499999985}]
["55 to 60 months","55 to 60 months",null,null,8.0088667452673269E-3,{"$f":"IFERROR(VLOOKUP(A172,'[5]Seasoning Distribution'!$A$1:$C$11,3,FALSE),0)","v":3309359.0999999987}]
["60+ months","61 to 72 months",null,null,9.5618108624845636E-4,{"$f":"IFERROR(VLOOKUP(A173,'[5]Seasoning Distribution'!$A$1:$C$11,3,FALSE),0)","v":395105.41000000003}]
["61 to 72 months","Total",null,null,{"$f":"SUM(E163:E173)","v":1},{"$f":"SUM(F163:F173)","v":413211906.91000021},{"$f":"F160-F174","v":0}]
[]
[null,"Remaining Term Distribution"]
["0 - 12 months","0-12 Months",null,null,{"$f":"F177/$F$183","v":4.6395432705126742E-2},{"$f":"IFERROR(VLOOKUP(A177,'[5]Remaining Term'!$A$1:$C$7,3,FALSE),0)","v":19171145.220000006}]
["13 - 24 months","13-24 Months",null,null,{"$f":"F178/$F$183","v":0.14721667781768305},{"$f":"IFERROR(VLOOKUP(A178,'[5]Remaining Term'!$A$1:$C$7,3,FALSE),0)","v":60831684.169999935}]
["25 - 36 months","25-36 Months",null,null,0.23989998110483046,{"$f":"IFERROR(VLOOKUP(A179,'[5]Remaining Term'!$A$1:$C$7,3,FALSE),0)","v":99129528.659999996}]
["37 - 48 months","37-48 Months",null,null,0.41707556364666165,{"$f":"IFERROR(VLOOKUP(A180,'[5]Remaining Term'!$A$1:$C$7,3,FALSE),0)","v":172340588.9800002}]
["49 - 60 months","49-60 Months",null,null,0.14856291157982202,{"$f":"IFERROR(VLOOKUP(A181,'[5]Remaining Term'!$A$1:$C$7,3,FALSE),0)","v":61387963.990000002}]
["60+ Months","60+ Months",null,null,8.4943314587604293E-4,{"$f":"IFERROR(VLOOKUP(A182,'[5]Remaining Term'!$A$1:$C$7,3,FALSE),0)","v":350995.89}]
[null,null,null,null,{"$f":"SUM(E177:E182)","v":1},{"$f":"SUM(F177:F182)","v":413211906.91000015},{"$f":"F174-F183","v":0}]
[]
[null,"Origination LVR Distribution"]
["01. 10% to 20%","10% to 20%",null,null,{"$f":"F186/F$202","v":4.9383330099547365E-5},{"$f":"IFERROR(VLOOKUP(A186,'[5]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":20405.779999999995}]
["02. 21% to 30%","21% to 30%",null,null,4.6848657979781669E-3,{"$f":"IFERROR(VLOOKUP(A187,'[5]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":1935842.3299999998}]
["03. 31% to 40%","31% to 40%",null,null,2.9310327043983061E-2,{"$f":"IFERROR(VLOOKUP(A188,'[5]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":12111376.130000001}]
["04. 41% to 50%","41% to 50%",null,null,7.9678887513691815E-2,{"$f":"IFERROR(VLOOKUP(A189,'[5]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":32924265.050000027}]
["05. 51% to 60%","51% to 60%",null,null,0.15017884270095838,{"$f":"IFERROR(VLOOKUP(A190,'[5]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":62055685.970000029}]
["06. 61% to 70%","61% to 70%",null,null,0.17249696714457122,{"$f":"IFERROR(VLOOKUP(A191,'[5]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":71277800.729999989}]
["07. 71% to 80%","71% to 80%",null,null,0.19338513247974848,{"$f":"IFERROR(VLOOKUP(A192,'[5]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":79909039.359999955}]
["08. 81% to 90%","81% to 90%",null,null,0.22286080018516313,{"$f":"IFERROR(VLOOKUP(A193,'[5]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":92088736.219999865}]
["09. 91% to 100%","91% to 100%",null,null,0.14735479380380453,{"$f":"IFERROR(VLOOKUP(A194,'[5]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":60888755.340000011}]
["> 100%","> 100%",null,null,0,{"$f":"IFERROR(VLOOKUP(A195,'[5]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":0}]
[null,null,null,null,{"$f":"SUM(E186:E195)","v":0.99999999999999833},{"$f":"SUM(F186:F195)","v":413211906.90999991},{"$f":"F183-F196","v":0}]
[]
[null,"New v Used"]
["New","New",null,null,{"$f":"F199/F$202","v":0.94868245610691326},{"$f":"IFERROR(VLOOKUP($A$199,'[5]New v Used'!$A$1:$C$4,3,FALSE),0)","v":392006886.74000055}]
["USed","Used",null,null,{"$f":"F200/F$202","v":5.1317543893086716E-2},{"$f":"IFERROR(VLOOKUP($A$200,'[5]New v Used'!$A$1:$C$4,3,FALSE),0)","v":21205020.170000017}]
["Used"]
[null,null,null,null,{"$f":"SUM(E199:E200)","v":1},{"$f":"SUM(F199:F200)","v":413211906.91000056},{"$f":"F196-F202","v":-6.5565109252929688E-7}]
[]
[null,"Contract Type"]
["Finance Lease","Finance Lease",null,null,{"$f":"F205/F$208","v":1.2781233095372302E-2},{"$f":"IFERROR(VLOOKUP(A205,'[5]Loan Type'!$A$1:$C$4,3,FALSE),0)","v":5281357.7}]
["Goods Mortgage","Goods Mortgage",null,null,{"$f":"F206/F$208","v":0.98721876690462773},{"$f":"IFERROR(VLOOKUP(A206,'[5]Loan Type'!$A$1:$C$4,3,FALSE),0)","v":407930549.21000075}]
["Hire Purchase","Hire Purchase",null,null,0,{"$f":"IFERROR(VLOOKUP(A207,'[5]Loan Type'!$A$1:$C$4,3,FALSE),0)","v":0}]
[null,null,null,null,{"$f":"SUM(E205:E207)","v":1},{"$f":"SUM(F205:F207)","v":413211906.91000074},{"$f":"F202-F208","v":0}]
[]
[null,"Contract by Source"]
["Non Hardship Refinance","Non Hardship Refinance",null,null,{"$f":"F211/F$213","v":0.99587511310420385},{"$f":"VLOOKUP($A$211,'[5]Refinance vs Hardship'!$A$1:$C$3,3,FALSE)","v":411507454.53000069}]
["Refinance - Hardship","Hardship Refinance",null,null,{"$f":"F212/F$213","v":4.1248868957961494E-3},{"$f":"VLOOKUP($A$212,[5]Source!$A$1:$C$228,3,FALSE)","v":1704452.3800000001}]
[null,null,null,null,{"$f":"SUM(E211:E212)","v":1},{"$f":"SUM(F211:F212)","v":413211906.91000068},{"$f":"F208-F213","v":0}]
[]
[null,"Payment Frequency Distribution"]
["6 Consecutive","6 Consecutive",null,null,{"$f":"F216/F$222","v":5.3152948965683516E-3},{"$f":"IFERROR(VLOOKUP(A216,'[5]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":2196343.14}]
["Annual","Annual",null,null,0.70689911860071619,{"$f":"IFERROR(VLOOKUP(A217,'[5]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":292099132.79000026}]
["Monthly","Monthly",null,null,0.21179301575416892,{"$f":"IFERROR(VLOOKUP(A218,'[5]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":87515395.909999833}]
["Quarterly","Quarterly",null,null,1.2613249528492392E-2,{"$f":"IFERROR(VLOOKUP(A219,'[5]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":5211944.8900000006}]
["Semi Annual","Semi Annual",null,null,5.0022900851455998E-2,{"$f":"IFERROR(VLOOKUP(A220,'[5]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":20670058.25}]
["Structured","Structured",null,null,1.335642036859813E-2,{"$f":"IFERROR(VLOOKUP(A221,'[5]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":5519031.9299999997}]
["0% to 1%",null,null,null,{"$f":"SUM(E216:E221)","v":1},{"$f":"SUM(F216:F221)","v":413211906.91000009},{"$f":"F213-F222","v":5.9604644775390625E-7}]
["1.01% to 2%"]
["2.01% to 3%","Yield Distribution"]
["01. 0% to 1%",null,null,null,{"$f":"F225/F$239","v":0.14455156250618309},{"$f":"IFERROR(VLOOKUP(A225,'[5]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":59730426.789999977}]
["02. 1.01% to 2%",null,null,null,0.16094812670653558,{"$f":"IFERROR(VLOOKUP(A226,'[5]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":66505682.349999867}]
["03. 2.01% to 3%",null,null,null,0.32269978294464541,{"$f":"IFERROR(VLOOKUP(A227,'[5]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":133343392.67000003}]
["04. 3.01% to 4%",null,null,null,0.27009869968318456,{"$f":"IFERROR(VLOOKUP(A228,'[5]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":111607998.75000012}]
[null,"< 4%",null,null,{"$f":"SUM(E225:E228)","v":0.89829817184054861},{"$f":"SUM(F225:F228)","v":371187500.56}]
["05. 4.01% to 5%","4% to 5%",null,null,5.9145641186286319E-2,{"$f":"IFERROR(VLOOKUP(A230,'[5]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":24439683.180000007}]
["06. 5.01% to 6%","5% to 6%",null,null,1.8025748182571896E-2,{"$f":"IFERROR(VLOOKUP(A231,'[5]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":7448453.7800000003}]
["07. 6.01% to 7%","6% to 7%",null,null,1.602393878122722E-2,{"$f":"IFERROR(VLOOKUP(A232,'[5]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":6621282.3000000007}]
["08. 7.01% to 8%","7% to 8%",null,null,7.036970840807173E-3,{"$f":"IFERROR(VLOOKUP(A233,'[5]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":2907760.1399999983}]
["09. 8.01% to 9%","8% to 9%",null,null,1.3930428924580184E-3,{"$f":"IFERROR(VLOOKUP(A234,'[5]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":575621.90999999992}]
["10. 9.01% to 10%","9% to 10%",null,null,4.7309648325932366E-5,{"$f":"IFERROR(VLOOKUP(A235,'[5]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":19548.910000000003}]
["11. 10.01% to 11%","10% to 11%",null,null,2.9176627774731314E-5,{"$f":"IFERROR(VLOOKUP(A236,'[5]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":12056.129999999997}]
["12. 11.01% to 12%","11% to 12%",null,null,0,{"$f":"IFERROR(VLOOKUP(A237,'[5]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":0}]
["13. > 12%","> 12%",null,null,0,{"$f":"IFERROR(VLOOKUP(A238,'[5]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":0}]
[null,null,null,null,{"$f":"SUM(E229:E238)","v":0.99999999999999967},{"$f":"SUM(F229:F238)","v":413211906.91000003},{"$f":"F222-F239","v":0}]
[]
[null,"Top 5 Obligor",null,null,{"$f":"F241/E13","v":2.8435129780902371E-2},{"$f":"SUM('[5]Top 5 Obligor '!$E$2:$E$6)","v":11749734.199999999}]