{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Collateral Tables","Note Balance","Cumulative Defaults"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":7,"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":"Collateral Tables","index":0,"n_rows":247,"n_cols":15,"rows_kept":247,"cut":false,"hidden":false,"merged":[]}
[null,"CNH CAPITAL AUSTRALIA RECEIVABLES TRUST SERIES 2016-1 (TERM DEAL)"]
[null,"COLLATERAL DATA TABLES"]
[]
[null,"OUTSTANDING RECEIVABLES",null,null,"2016-10-31",null,null,null,"2016-07-31",null,null,null,"2016-04-30"]
[]
[null,"Opening Balance",null,null,{"$f":"I13","v":253371003.93000007},null,null,null,275076134.53000009,null,null,null,349999833.42000002]
[null,"Principal Repayments - Scheduled",null,null,{"$f":"MIN('[1]16 Nov 16'!$H23,SUM([2]Sheet1!$B$3,[3]Sheet1!$B$3,[4]Sheet1!$B$3))","v":13038858.939999998},null,null,null,18368178.68,null,null,null,70539694.680000007]
[null,"Principal Repayments - Unscheduled",null,null,{"$f":"'[1]16 Nov 16'!H23-'Collateral Tables'!E7","v":7347080.2000000104},null,null,null,2981303.9900000058,null,null,null,4299937.9999999255]
[{"$f":"SUM(I9:M9)","v":439714.14},"Charge-Offs",null,null,{"$f":"'[1]16 Nov 16'!$H37","v":0},null,null,null,355647.93,null,null,null,84066.21]
[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":232985064.79000005},null,null,null,253371003.93000007,null,null,null,275076134.53000009]
[]
[null,"PORTFOLIO STATISTICS"]
[]
[null,"Summary"]
[null,"Number of contracts",null,null,{"$f":"[5]Summary!$B$4","v":3133},null,null,null,3263,null,null,null,3422]
[null,"Average Dollar Value of Loans",null,null,{"$f":"[5]Summary!$B$6","v":74364.846725183495},null,null,null,77649.710061293183,null,null,null,80384.609739918029]
[null,"Number of contracts closed during the Quarter",null,null,{"$f":"[5]Summary!$B$19","v":130},null,null,null,157,null,null,null,216]
[null,"Dollar value of contracts closed during the Quarter",null,null,{"$f":"[5]Summary!$B$20","v":8722235.7299999949},null,null,null,5997812.8599999985,null,null,null,10129289.880000003]
[]
[{"$f":"SUM(M23)","v":0},"Dollar Value of Recoveries from Collateral",null,null,{"$f":"[5]Summary!$C$16","v":90664.72000000003},null,null,null,-8677.59,null,null,null,0]
[null,"Dollar Value of Recoveries from Other Sources",null,null,0,null,null,null,0,null,null,null,0]
[]
[null,"Average Term of Contracts (Months)",null,null,{"$f":"[6]Sheet1!$W$3135","v":51.221268983771495},null,null,null,50.905018498380905,null,null,null,50.602561692977268]
[null,"Average Term to Maturity (Months)",null,null,{"$f":"[6]Sheet1!$X$3135","v":28.796062261189039},null,null,null,31.261824556602878,null,null,null,33.580143025830573]
[null,"Average Residual / Balloon Payment *",null,null,{"$f":"[6]Sheet1!$AI$3135","v":1.9947715214700443E-2},null,null,null,2.2629991788590827E-2,null,null,null,2.4040809082651878E-2]
[null,"Average Seasoning (Months)",null,null,{"$f":"E26-E27","v":22.425206722582455},null,null,null,19.643193941778026,null,null,null,17.022418667146695]
[null,"Average Dollar Value of Individual Assets",null,null,{"$f":"E19/E18","v":23.73598682578471},null,null,null,23.797030358962054,null,null,null,23.490534698982476]
[null,"Weighted Average Interest Rate",null,null,{"$f":"[6]Sheet1!$AA$3135/100","v":3.6244089599937843E-2},null,null,null,3.6462237991813522E-2,null,null,null,3.6655471442132145E-2]
[]
[null,"Payment in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A34,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":3124},{"$f":"IFERROR(VLOOKUP($A34,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":20933.35999999999},{"$f":"F34/F$50","v":8.9848506035647343E-5},null,3255,120639.01000000001,4.7613581715660603E-4,null,3409,279917.05,1.0175984567991395E-3]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A35,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":6},{"$f":"IFERROR(VLOOKUP($A35,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":106352.71000000002},{"$f":"F35/F$50","v":4.5647865924736678E-4},null,3,46074.110000000015,1.8184444662313923E-4,null,8,230113.48,8.3654469113860581E-4]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A36,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A36,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":0},0,null,4,60199.999999999971,2.3759624845087562E-4,null,3,35237.550000000097,1.2810108030712178E-4]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A37,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":3},{"$f":"IFERROR(VLOOKUP($A37,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":19683.799999999992},8.4485243797673918E-5,null,0,0,0,null,1,48099.140000000007,1.7485755382662749E-4]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A38,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A38,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":0},0,null,1,5363.4499999999989,2.1168365427804805E-5,null,1,30045.720000000012,1.09226923852688E-4]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A39,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A39,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":0},0,null,0,0,0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E34:E39)","v":3133},{"$f":"SUM(F34:F39)","v":146969.87},{"$f":"SUM(G34:G39)","v":6.3081240908068807E-4},null,3263,232276.57,9.1674487765842569E-4,null,3422,623412.94000000006,2.2663287059241826E-3]
[null,"* Expressed as a % of Aggreg. Rec. closing bal.",null,null,null,"> 30 days",{"$f":"SUM(G35:G39)","v":5.4096390304504065E-4},null,null,"> 30 days",4.406090605018196E-4,null,null,"> 30 days",1.2487302491250431E-3]
[]
[" 0 - 30 Days","Account Balances in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A44,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":3124},{"$f":"IFERROR(VLOOKUP($A44,'[7]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":232540319.81999987},{"$f":"F44/F$50","v":0.99809110094502895},null,3255,252870428.10999963,0.99802433659639167,null,3409,273901148.7699995,0.99572850708402028]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A45,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":6},{"$f":"IFERROR(VLOOKUP($A45,'[7]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":225774.02000000002},{"$f":"F45/F$50","v":9.6904932598791476E-4},null,3,122576.48000000001,4.8378258797863457E-4,null,8,698753.64,2.5402190604208695E-3]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A46,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A46,'[7]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":0},0,null,4,366338.57999999996,1.4458583433691198E-3,null,3,107754.56,3.9172631309550559E-4]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A47,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":3},{"$f":"IFERROR(VLOOKUP($A47,'[7]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":218970.95},{"$f":"F47/F$50","v":9.3984972898313707E-4},null,0,0,0,null,1,84424.18,3.0691204871061899E-4]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A48,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A48,'[7]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":0},{"$f":"F48/F$50","v":0},null,1,11660.76,4.6022472260565345E-5,null,1,284053.38,1.0326354937528085E-3]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A49,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A49,'[7]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":0},{"$f":"F49/F$50","v":0},null,0,0,0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E44:E49)","v":3133},{"$f":"SUM(F44:F49)","v":232985064.78999987},{"$f":"SUM(G44:G49)","v":1},null,3263,253371003.92999962,1,null,3422,275076134.52999949,1]
["NSW",null,null,null,null,"> 30 days",{"$f":"SUM(G45:G49)","v":1.9088990549710519E-3},null,null,"> 30 days",1.9756634036083198E-3,null,null,"> 30 days",4.2714929159798024E-3]
[null,null,null,null,null,">90 days",{"$f":"SUM(G47:G49)","v":9.3984972898313707E-4},null,null,">90 days",4.6022472260565345E-5,null,null,">90 days",1.3395475424634274E-3]
[]
["VIC","Geographic Distribution"]
["NSW","New South Wales",null,null,{"$f":"F55/F$63","v":0.28479963189832763},{"$f":"IFERROR(VLOOKUP($A$55,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":66354060.690000072},null,null,0.29110503718246078,73757575.520000115,null,null,0.29705376436823705,81712401.250000164]
["VIC","Victoria",null,null,{"$f":"F56/F$63","v":0.17518044582294545},{"$f":"IFERROR(VLOOKUP($A$56,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":40814427.520000063},null,null,0.17529086308656849,44413621.960000068,null,null,0.18022488506574988,49575564.730000041]
["QLD","Queensland",null,null,0.10433737450900916,{"$f":"IFERROR(VLOOKUP($A$57,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":24309049.960000016},null,null,0.11345624631120736,28746523.02999999,null,null,0.11757327303315286,32341601.470000003]
["SA","South Australia",null,null,0.19173873256753657,{"$f":"IFERROR(VLOOKUP($A$58,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":44672261.030000031},null,null,0.18459924361716598,46772095.680000022,null,null,0.17919394619319157,49291978.049999982]
["NT","Northern Territory",null,null,4.5433307107221594E-4,{"$f":"IFERROR(VLOOKUP($A$59,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":105852.81999999999},null,null,4.1777795548082671E-4,105852.81999999999,null,null,3.848128089369219E-4,105852.81999999999]
["ACT","Australian Capital Territory",null,null,2.1620857991650131E-4,{"$f":"IFERROR(VLOOKUP($A$60,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":50373.369999999995},null,null,2.2047574163392924E-4,55862.159999999989,null,null,2.2276559943922353E-4,61277.499999999993]
["TAS","Tasmania",null,null,8.5949311034376093E-3,{"$f":"IFERROR(VLOOKUP($A$61,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":2002490.5799999994},null,null,8.8499200193384916E-3,2242313.12,null,null,9.7943024559484972E-3,2694178.8600000003]
["WA","Western Australia",null,null,0.23467834244775482,{"$f":"IFERROR(VLOOKUP($A$62,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":54676548.820000008},null,null,0.22606043608614426,57277159.640000015,null,null,0.21555225047534396,59293279.850000016]
[null,"Total",null,null,{"$f":"SUM(E55:E62)","v":1},{"$f":"SUM(F55:F62)","v":232985064.7900002},null,null,1.0000000000000002,253371003.93000019,null,null,0.99999999999999989,275076134.53000021]
["AG",null,null,null,null,null,{"$f":"E13-F63","v":0},null,null,null,0,null,null,null,275076134.53000009]
["CE","Top Industry Distribution"]
["AGRICULTURAL MACHINERY","Agricultural",null,null,{"$f":"F66/F$69","v":0.98745834398168941},{"$f":"IFERROR(VLOOKUP(A66,'[7]Top Industry'!$A$1:$C$5,3,FALSE),)","v":230063046.24999982},null,null,0.98669367201571556,249999566.24999967,null,null,0.9852200432911179,271010521.1699996]
["CONSTRUCTION EQUIPMENT","Construction",null,null,{"$f":"F67/F$69","v":1.2541656018310655E-2},{"$f":"IFERROR(VLOOKUP($A$67,'[7]Top Industry'!$A$1:$C$5,3,FALSE),)","v":2922018.5399999991},null,null,1.3306327984284449E-2,3371437.6799999997,null,null,1.4779956708882014E-2,4065613.3599999994]
["MOTOR VEHICLE - AG","Motor Vehicle AG",null,null,{"$f":"F68/F$69","v":0},{"$f":"IFERROR(VLOOKUP($A$68,'[7]Top Industry'!$A$1:$C$5,3,FALSE),)","v":0},null,null,0,0,null,null,0,0]
[null,"Total",null,null,{"$f":"SUM(E66:E68)","v":1},{"$f":"SUM(F66:F68)","v":232985064.78999981},{"$f":"F63-F69","v":3.8743019104003906E-7},null,1,253371003.92999968,5.0663948059082031E-7,null,0.99999999999999989,275076134.52999961,-275076134.52999961]
["COMBINE"]
["40-100 HP TRACTOR","Collateral Types"]
["100<140 HP TRACTOR","100-140 HP TRACTOR",null,null,{"$f":"IFERROR(F72/F$107,0)","v":0.10117027102679638},{"$f":"IFERROR(VLOOKUP($A$72,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":23571162.150000006},null,null,0.1031342088663761,26131218.040000021,null,null,0.10702894513296701,29441108.51000002]
["4 EWD Tractors","4 EWD Tractors",null,null,0.11167033806845429,{"$f":"IFERROR(VLOOKUP($A$73,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":26017520.950000018},null,null,0.1081672270106003,27406438.900000013,null,null,0.10816969673083333,29754902.050000008]
["40<100 HP Tractor","40<100 HP Tractor",null,null,{"$f":"IFERROR(F74/F$107,0)","v":0},{"$f":"IFERROR(VLOOKUP($A$74,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,""]
["40<60 HP TRACTOR","40-60 HP TRACTOR",null,null,{"$f":"IFERROR(F75/F$107,0)","v":6.8241157922850713E-3},{"$f":"IFERROR(VLOOKUP($A$75,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":1589917.0599999991},null,null,7.5032547154654967E-3,1901107.1799999995,null,null,8.2621937518615757E-3,2272732.3199999998]
["4WD VEHICLE","4WD VEHICLE",null,null,6.1197012833639659E-5,{"$f":"IFERROR(VLOOKUP($A$76,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":14257.989999999994},null,null,7.2201829397392775E-5,18293.849999999995,null,null,8.1090059078052425E-5,22305.939999999995]
["60<100 HP TRACTOR","60-100 HP TRACTOR",null,null,6.0238977775893862E-2,{"$f":"IFERROR(VLOOKUP($A$77,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":14034782.139999997},null,null,6.3897213252045268E-2,16189701.07000001,null,null,6.7368036277167365E-2,18531339.010000009]
["Backhoes","Backhoes",null,null,5.0477553188228133E-4,{"$f":"IFERROR(VLOOKUP($A$78,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":117605.15999999999},null,null,5.3357810445172499E-4,135193.21999999997,null,null,5.5525191329654385E-4,152736.54999999999]
["BALERS, WINDROWERS, MOWERS, RAKES","BALERS, WINDROWERS, MOWERS, RAKES",null,null,3.6830440044448312E-2,{"$f":"IFERROR(VLOOKUP($A$79,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":8580942.4599999972},null,null,3.8811712735356309E-2,9833762.6199999955,null,null,3.8551025293848094E-2,10604467.01999999]
["QUAD BIKES","QUAD BIKES",null,null,2.167267676385721E-5,{"$f":"IFERROR(VLOOKUP($A$80,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":5049.409999999998},null,null,3.2280489373833919E-5,8178.9399999999969,null,null,3.3626544941110479E-5,9249.8599999999951]
["Combines","Combines",null,null,0.35489487600644243,{"$f":"IFERROR(VLOOKUP($A$81,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":82685205.679999977},null,null,0.35462537021333246,89851786.069999963,null,null,0.34717658732253526,95499993.639999986]
["TRUCK - on Farm","TRUCK - on Farm",null,null,0,{"$f":"IFERROR(VLOOKUP($A$82,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,7.0909568484839601E-5,19505.529999999984]
["Cotton Pickers","Cotton Pickers",null,null,2.3388825394931022E-4,{"$f":"IFERROR(VLOOKUP($A$83,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":54492.47},null,null,2.1506987443225701E-4,54492.47,null,null,1.9809959192972816E-4,54492.47]
["CRAWLERS / DOZERS","CRAWLERS / DOZERS",null,null,0,{"$f":"IFERROR(VLOOKUP($A$84,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,""]
["CULTIVATORS,SEEDERS, HARROWS","CULTIVATORS,SEEDERS, HARROWS",null,null,1.5718765463790314E-2,{"$f":"IFERROR(VLOOKUP($A$85,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":3662237.59},null,null,1.4877028474187173E-2,3769407.64,null,null,1.4343276441416268E-2,3945493.0400000005]
["Drill","Drill",null,null,6.0800837224343892E-4,{"$f":"IFERROR(VLOOKUP($A$86,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":141656.87000000002},null,null,5.8151196354222859E-4,147338.27000000002,null,null,6.3340747570741303E-4,174235.28000000003]
["DUMP TRUCKS","DUMP TRUCKS",null,null,0,{"$f":"IFERROR(VLOOKUP($A$87,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,""]
["EXCAVATORS / GRADERS","EXCAVATORS / GRADERS",null,null,4.3004018772751992E-3,{"$f":"IFERROR(VLOOKUP($A$88,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":1001929.4099999997},null,null,4.5049112262085973E-3,1141413.8799999997,null,null,5.0805466726070482E-3,1397537.1400000001]
["FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE","FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE",null,null,3.0051410403970735E-3,{"$f":"IFERROR(VLOOKUP($A$89,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":700152.98},null,null,2.8129264949232503E-3,712714.01,null,null,2.7273481259355841E-3,750228.38]
["Front End Loader","Front End Loader",null,null,2.5786893273245856E-4,{"$f":"IFERROR(VLOOKUP($A$90,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":60079.609999999993},null,null,4.3116030763402273E-4,109243.51999999999,null,null,5.463704448835379E-4,150293.47]
["Fronts","Fronts",null,null,4.1074477493334783E-3,{"$f":"IFERROR(VLOOKUP($A$91,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":956973.97999999986},null,null,3.9455556653838287E-3,999689.39999999991,null,null,3.9743435099084167E-3,1093247.0499999998]
["GUIDANCE SYSTEMS","Guidance Systems",null,null,0,{"$f":"IFERROR(VLOOKUP($A$92,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,""]
["HARVESTERS - Other","HARVESTERS - Other",null,null,3.288929832007367E-3,{"$f":"IFERROR(VLOOKUP($A$93,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":766271.53},null,null,3.0498564871830791E-3,772745.2,null,null,2.8119371799433289E-3,773496.80999999994]
["Irrigation Equipment","Irrigation Equipment",null,null,9.8457263862282451E-4,{"$f":"IFERROR(VLOOKUP($A$94,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":229390.71999999997},null,null,9.053550581635412E-4,229390.71999999997,null,null,8.339172003850537E-4,229390.71999999997]
["Other AG","Other AG",null,null,5.6713312983859279E-3,{"$f":"IFERROR(VLOOKUP($A$95,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":1321335.4899999998},null,null,5.6552530785877429E-3,1432877.1499999997,null,null,5.6825801797411929E-3,1563142.1899999997]
["MATERIALS HANDLING EQUIPMENT","MATERIALS HANDLING EQUIPMENT",null,null,2.0409175173034919E-4,{"$f":"IFERROR(VLOOKUP($A$96,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":47550.329999999987},null,null,2.3012392537272603E-4,58306.729999999996,null,null,2.5077831676625022E-4,68983.12999999999]
["Other CE","Other CE",null,null,6.3137793889316213E-4,{"$f":"IFERROR(VLOOKUP($A$97,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":147101.63},null,null,5.8057799715961365E-4,147101.63,null,null,9.7246597003792796E-4,267502.18]
["Over 100 HP Tractor","Over 100 HP Tractor",null,null,0,{"$f":"IFERROR(VLOOKUP($A$98,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,""]
["OVER 140 HP TRACTOR","OVER 140 HP TRACTOR",null,null,0.21194313641738377,{"$f":"IFERROR(VLOOKUP($A$99,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":49379585.369999953},null,null,0.21029926587306322,53283736.12000002,null,null,0.21130998019626707,58126332.539999992]
["Rollers","Rollers",null,null,0,{"$f":"IFERROR(VLOOKUP($A$100,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,""]
["SCRAPERS","SCRAPERS",null,null,2.6505939363822526E-4,{"$f":"IFERROR(VLOOKUP($A$101,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":61754.880000000005},null,null,2.7125578276110835E-4,68728.350000000006,null,null,2.7464425486813972E-4,75548.08]
["SKIDSTEER / UNILOADER","SKIDSTEER / UNILOADER",null,null,6.2756200330604034E-3,{"$f":"IFERROR(VLOOKUP($A$102,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":1462125.7399999995},null,null,6.8213900296085076E-3,1728342.44,null,null,7.2801913311079866E-3,2002606.8900000001]
["SPRAYING EQUIPMENT","SPRAYING EQUIPMENT",null,null,6.7403397141163182E-2,{"$f":"IFERROR(VLOOKUP($A$103,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":15703984.85},null,null,6.5009310909746584E-2,16471474.369999995,null,null,6.2545564119535171E-2,17204792.009999998]
["Trenchers","Trenchers",null,null,0,{"$f":"IFERROR(VLOOKUP($A$104,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,""]
["Under 40 HP Tractors","Under 40 HP Tractors",null,null,2.523968437762454E-3,{"$f":"IFERROR(VLOOKUP($A$105,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":588046.9500000003},null,null,2.6679087169215058E-3,675970.71000000008,null,null,2.8711081437487146E-3,789773.33]
["Wheel Loaders","Wheel Loaders",null,null,3.6032949183102886E-4,{"$f":"IFERROR(VLOOKUP($A$106,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":83951.390000000014},null,null,3.6449091872215329E-4,92351.430000000008,null,null,3.660782501981017E-4,100699.39000000001]
[null,"Total",null,null,{"$f":"SUM(E72:E106)","v":0.99999999999999989},{"$f":"SUM(F72:F106)","v":232985064.78999993},{"$f":"F69-F107","v":0},null,0.99999999999999989,253371003.93000001,-3.2782554626464844E-7,null,1.0000000000000002,275076134.52999997,0]
["$ 0 - $25,000"]
["$ 25,001 to $50,000","Contract Balance Distribution"]
["$0 - $25,000","$ 0 - $25,000",null,null,{"$f":"IFERROR(F110/F$121,0)","v":5.8356590463233785E-2},{"$f":"IFERROR(VLOOKUP($A$110,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":13596214.010000026},null,null,5.3393036141331653E-2,13528247.169999976,null,null,4.9003300642680409E-2,13479638.519999996]
["$25,001 - $50,000","$ 25,001 to $50,000",null,null,{"$f":"IFERROR(F111/F$121,0)","v":0.10680954958391854},{"$f":"IFERROR(VLOOKUP($A$111,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":24885029.829999991},null,null,0.10454796969316318,26489424.039999973,null,null,9.9211197244098534E-2,27290632.640000023]
["$50,001 - $75,000","$ 50,001 to $75,000",null,null,0.11220120793391745,{"$f":"IFERROR(VLOOKUP($A$112,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":26141205.700000033},null,null,0.11092138873067157,28104263.620000049,null,null,0.11112488148864204,30567802.850000013]
["$75,001 - $100,000","$ 75,001 to $100,000",null,null,8.7974366118594841E-2,{"$f":"IFERROR(VLOOKUP($A$113,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":20496713.390000008},null,null,9.7541995400657389E-2,24714313.300000008,null,null,9.67294360358191E-2,26607959.360000014]
["$100,001 - $125,000","$100,001 to $125,000",null,null,0.10359340793691911,{"$f":"IFERROR(VLOOKUP($A$114,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":24135716.860000011},null,null,9.5646216552448288E-2,24233977.910000011,null,null,9.6812115909297961E-2,26630702.620000008]
["$125,001 - $150,000","$125,001 to $150,000",null,null,8.9829723200773537E-2,{"$f":"IFERROR(VLOOKUP($A$115,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":20928983.879999999},null,null,8.7528803556886123E-2,22177260.829999994,null,null,8.9536094151104556E-2,24629242.679999992]
["$150,001 - $200,000","$150,000 to $200,000",null,null,0.12134083472467028,{"$f":"IFERROR(VLOOKUP($A$116,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":28270602.239999998},null,null,0.12386445711313716,31383661.849999998,null,null,0.12195206031710987,33546101.349999998]
["$200,001 - $300,000","$200,001 to $300,000",null,null,0.20016563466003615,{"$f":"IFERROR(VLOOKUP($A$117,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":46635603.360000014},null,null,0.20142154728999512,51034379.650000043,null,null,0.20571595222786784,56587548.950000048]
["$300,001 - $400,000","$300,001 to $400,000",null,null,7.4884423796545599E-2,{"$f":"IFERROR(VLOOKUP($A$118,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":17446952.330000002},null,null,6.9209609023946031E-2,17535708.119999997,null,null,6.6937862135734841E-2,18413008.369999997]
["$400,001 - $500,000","$400,001 to $500,000",null,null,1.659202375690615E-2,{"$f":"IFERROR(VLOOKUP($A$119,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":3865693.73},null,null,2.4220888400061202E-2,6136870.8099999996,null,null,3.0528967532383763E-2,8397790.3800000008]
["$500,001+","$500,000+",null,null,2.8252237824484445E-2,{"$f":"IFERROR(VLOOKUP($A$120,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":6582349.46},null,null,3.1704088097702317E-2,8032896.6300000008,null,null,3.2448132315261079E-2,8925706.8100000005]
["$200,001 to $300,000","Total",null,null,{"$f":"SUM(E110:E120)","v":0.99999999999999989},{"$f":"SUM(F110:F120)","v":232985064.79000011},{"$f":"F107-F121","v":0},null,1.0000000000000002,253371003.93000004,0,null,0.99999999999999989,275076134.53000009,0]
["0"]
["0 to 5","Residual / Balloon Payment Distribution"]
["0","0",null,null,{"$f":"IFERROR(F124/F$134,0)","v":0.92065457325918065},{"$f":"IFERROR(VLOOKUP($A$124,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":214498765.3999998},null,null,0.91349637239446979,231453492.9599998,null,null,0.91108591873377298,250617992.7499994]
["0 to 5","0 to 5",null,null,{"$f":"IFERROR(F125/F$134,0)","v":0},{"$f":"IFERROR(VLOOKUP($A$125,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,""]
["6 to 10","06 to 10",null,null,6.7115289188576202E-4,{"$f":"IFERROR(VLOOKUP($A$126,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":156368.59999999998},null,null,6.5486858174916053E-4,165924.70999999996,null,null,6.1651978747543712E-4,169589.87999999998]
["11 to 15","11 to 15",null,null,7.9364204382227233E-3,{"$f":"IFERROR(VLOOKUP($A$127,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":1849067.4299999997},null,null,7.4209404029494516E-3,1880251.12,null,null,7.5261714853500665E-3,2070270.1600000001]
["16 to 20","16 to 20",null,null,2.3898543089097571E-2,{"$f":"IFERROR(VLOOKUP($A$128,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":5568003.6099999994},null,null,2.5339785336185455E-2,6420366.8499999968,null,null,2.4576692454803692E-2,6760461.5600000005]
["21 to 25","21 to 25",null,null,1.5926640676923207E-2,{"$f":"IFERROR(VLOOKUP($A$129,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":3710669.4099999997},null,null,1.801105903681377E-2,4563480.1100000003,null,null,1.7524678279475642E-2,4820620.76]
["26 to 30","26 to 30",null,null,1.2633356617313678E-2,{"$f":"IFERROR(VLOOKUP($A$130,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":2943383.4099999997},null,null,1.1770068175693484E-2,2982193.9899999998,null,null,1.2758596800833152E-2,3509585.4899999998]
["31 to 35","31 to 35",null,null,5.9579475673737729E-3,{"$f":"IFERROR(VLOOKUP($A$131,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":1388112.8},null,null,7.4294089726228496E-3,1882396.81,null,null,7.338744356900369E-3,2018713.4299999997]
["36 to 40","36 to 40",null,null,9.0974037838453588E-3,{"$f":"IFERROR(VLOOKUP($A$132,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":2119559.21},null,null,1.0027736365215426E-2,2540737.63,null,null,9.3033510681418494E-3,2559129.8500000006]
["41+ %","41+%",null,null,3.2239616761573649E-3,{"$f":"IFERROR(VLOOKUP($A$133,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":751134.91999999993},null,null,5.849760734300458E-3,1482159.75,null,null,9.2693270332469564E-3,2549770.65]
[null,null,null,null,{"$f":"SUM(E124:E133)","v":1.0000000000000002},{"$f":"SUM(F124:F133)","v":232985064.78999978},{"$f":"F121-F134","v":3.2782554626464844E-7},null,0.99999999999999989,253371003.92999983,0,null,1.0000000000000002,275076134.52999938,7.152557373046875E-7]
["2004 Q1"]
["2004 Q2","Quarter of Maturity Distribution"]
[{"$f":"RIGHT(B137,2)&LEFT(B137,4)","v":"Q12016"},"2016Q1",null,null,{"$f":"F137/F$166","v":0},{"$f":"IFERROR(VLOOKUP($A$137,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
["Q22016","2016Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A$138,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,1.8344364303360051E-5,4647.929999999993,null,null,6.1769767955449084E-3,1699138.8999999994]
[{"$f":"RIGHT(B139,2)&LEFT(B139,4)","v":"Q32016"},"2016Q3",null,null,1.1973080774573881E-4,{"$f":"IFERROR(VLOOKUP($A$139,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":27895.49},null,null,3.9449232725783578E-3,999529.16999999993,null,null,4.8508062041800869E-3,1334341.02]
[{"$f":"RIGHT(B140,2)&LEFT(B140,4)","v":"Q42016"},"2016Q4",null,null,2.0890957128033502E-3,{"$f":"IFERROR(VLOOKUP($A$140,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":486728.10000000003},null,null,3.701608690231627E-3,937880.31,null,null,4.8468328678458851E-3,1333248.0500000003]
["Q12017","2017Q1",null,null,3.3974981302491401E-2,{"$f":"IFERROR(VLOOKUP($A$141,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":7915663.2200000016},null,null,3.5370445516630329E-2,8961845.2899999972,null,null,3.6769171405151187E-2,10114321.539999995]
["Q22017","2017Q2",null,null,1.9217481661477614E-2,{"$f":"IFERROR(VLOOKUP($A$142,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":4477386.2100000009},null,null,1.9811701229185706E-2,5019710.629999999,null,null,2.6571858669196351E-2,7309284.1700000018]
["Q32017","2017Q3",null,null,1.6281901560596578E-2,{"$f":"IFERROR(VLOOKUP($A$143,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":3793439.8899999973},null,null,1.9991140783415694E-2,5065175.4100000029,null,null,2.3447092824028997E-2,6449735.6599999974]
["Q42017","2017Q4",null,null,2.7109863053638529E-2,{"$f":"IFERROR(VLOOKUP($A$144,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":6316193.200000003},null,null,3.2315909567387238E-2,8187914.4500000002,null,null,3.3962660759220172E-2,9342317.4399999995]
["Q12018","2018Q1",null,null,9.0217407235719901E-2,{"$f":"IFERROR(VLOOKUP($A$145,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":21019308.470000025},null,null,8.832679810584361E-2,22379449.510000028,null,null,8.5662956185790576E-2,23563834.860000022]
["Q22018","2018Q2",null,null,5.3928255578635231E-2,{"$f":"IFERROR(VLOOKUP($A$146,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":12564478.120000014},null,null,5.7405358957406075E-2,14544853.430000002,null,null,6.2640495764712659E-2,17230905.439999994]
["Q32018","2018Q3",null,null,4.5136157416264353E-2,{"$f":"IFERROR(VLOOKUP($A$147,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":10516050.559999995},null,null,4.9380348366368752E-2,12511548.43999999,null,null,5.0724821271175211E-2,13953187.759999996]
["Q42018","2018Q4",null,null,5.9721921928951108E-2,{"$f":"IFERROR(VLOOKUP($A$148,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":13914315.850000001},null,null,6.0417356218982372E-2,15308006.199999999,null,null,5.9473421341885976E-2,16359718.849999998]
["Q12019","2019Q1",null,null,0.19573021460025072,{"$f":"IFERROR(VLOOKUP($A$149,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":45602216.730000041},null,null,0.18515725908778813,46913480.620000012,null,null,0.17303693023506883,47598329.900000013]
["Q22019","2019Q2",null,null,8.6736259374456573E-2,{"$f":"IFERROR(VLOOKUP($A$150,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":20208253.01000002},null,null,8.4227816360138666E-2,21340886.390000019,null,null,8.554092331639114E-2,23530266.53000002]
["Q32019","2019Q3",null,null,4.7992693823865784E-2,{"$f":"IFERROR(VLOOKUP($A$151,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":11181580.880000008},null,null,4.8981444156998705E-2,12410477.68,null,null,4.8043665047789494E-2,13215665.67]
["Q42019","2019Q4",null,null,3.5099802973941503E-2,{"$f":"IFERROR(VLOOKUP($A$152,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":8177729.8699999992},null,null,3.7240252134797591E-2,9435600.0699999947,null,null,3.6237108453742971E-2,9967963.7200000007]
["Q12020","2020Q1",null,null,0.16365833056452878,{"$f":"IFERROR(VLOOKUP($A$153,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":38129946.749999993},null,null,0.15395259810699038,39007124.339999989,null,null,0.14403823620576159,39621481.239999987]
["Q22020","2020Q2",null,null,7.0667513408381649E-2,{"$f":"IFERROR(VLOOKUP($A$154,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":16464475.190000001},null,null,6.8949604370776671E-2,17469830.480000008,null,null,6.8689836660254924E-2,18894934.750000007]
["Q32020","2020Q3",null,null,3.8840104743007531E-2,{"$f":"IFERROR(VLOOKUP($A$155,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":9049164.3200000003},null,null,3.7625784569389011E-2,9533282.8100000005,null,null,3.6930633685679046E-2,10158735.959999997]
["Q42020","2020Q4",null,null,1.1462148109824332E-2,{"$f":"IFERROR(VLOOKUP($A$156,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":2670509.3199999994},null,null,1.132738598925438E-2,2870031.1599999997,null,null,1.0647937397421012E-2,2928993.4600000004]
["Q12021","2021Q1",null,null,2.0161361434192717E-3,{"$f":"IFERROR(VLOOKUP($A$157,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":469729.61},null,null,1.853920151533102E-3,469729.61,null,null,1.7076349091591986E-3,469729.61]
["Q22021","2021Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A$158,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
["Q32021","2021Q3",null,null,0,{"$f":"IFERROR(VLOOKUP($A$159,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
["Q42021","2021Q4",null,null,0,{"$f":"IFERROR(VLOOKUP($A$160,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
["Q12022","2022Q1",null,null,0,{"$f":"IFERROR(VLOOKUP($A$161,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
["Q22022","2022Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A$162,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
["Q32022","2022Q3",null,null,0,{"$f":"IFERROR(VLOOKUP($A$163,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
["Q42022","2022Q4",null,null,0,{"$f":"IFERROR(VLOOKUP($A$164,'[7]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
[]
[null,null,null,null,{"$f":"SUM(E137:E164)","v":0.99999999999999989},{"$f":"SUM(F137:F165)","v":232985064.79000011},{"$f":"F134-F166","v":-3.2782554626464844E-7},null,0.99999999999999967,253371003.9300001,-2.6822090148925781E-7,null,1.0000000000000002,275076134.52999997,-5.9604644775390625E-7]
["0 to 6 months"]
["07 to 12 months","Seasoning Distribution"]
["0 to 6 months","0 to 6 months",null,null,{"$f":"F169/F$180","v":0},{"$f":"IFERROR(VLOOKUP($A$169,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,0,0,null,null,4.0425618961819558E-4,111201.23]
["07 to 12 months","07 to 12 months",null,null,4.4005408712533283E-4,{"$f":"IFERROR(VLOOKUP($A$170,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":102526.03},null,null,0.20809500054144575,52725239.200000033,null,null,0.33802136640777658,92981610.859999999]
["13 to 18 months","13 to 18 months",null,null,0.34984872173445203,{"$f":"IFERROR(VLOOKUP($A$171,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":81509527.100000009},null,null,0.30383246368344619,76982336.350000069,null,null,0.26295157954574017,72331704.070000038]
["19 to 24 months","19 to 24 months",null,null,0.27839015620362584,{"$f":"IFERROR(VLOOKUP($A$172,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":64860748.579999998},null,null,0.22389227445170648,56727810.349999987,null,null,0.17982011556369829,49464222.300000034]
["25 to 30 months","25 to 30 months",null,null,0.17242941677918375,{"$f":"IFERROR(VLOOKUP($A$173,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":40173478.840000048},null,null,0.11676300034779591,29584358.620000005,null,null,0.1087961730708997,29927230.73999998]
["31 to 36 months","31 to 36 months",null,null,0.10758878094865705,{"$f":"IFERROR(VLOOKUP($A$174,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":25066579.099999987},null,null,0.10891454500304228,27595787.609999999,null,null,8.3664854856719859E-2,23014204.870000005]
["37 to 42 months","37 to 42 months",null,null,7.179253874095505E-2,{"$f":"IFERROR(VLOOKUP($A$175,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":16726589.290000001},null,null,1.99023786139047E-2,5042685.6499999985,null,null,8.5730089381592968E-3,2358230.16]
["43 to 48 months","43 to 48 months",null,null,7.6502906381855874E-3,{"$f":"IFERROR(VLOOKUP($A$176,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":1782403.46},null,null,1.4788264686495764E-2,3746917.47,null,null,1.100645192347577E-2,3027612.2499999991]
["49 to 54 months","49 to 54 months",null,null,9.4239463889199421E-3,{"$f":"IFERROR(VLOOKUP($A$177,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":2195638.7599999998},null,null,2.1924617315463297E-3,555506.23,null,null,3.0882081480876466E-3,849492.35999999987]
["55 to 60 months","55 to 60 months",null,null,2.4360944788953732E-3,{"$f":"IFERROR(VLOOKUP($A$178,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":567573.62999999989},null,null,1.6012665763130828E-3,405714.51999999996,null,null,3.6289038004172353E-3,998224.83]
["60+ months","61 to 72 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$179,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,1.8344364303360051E-5,4647.929999999993,null,null,4.5081555407154198E-5,12400.86]
["61 to 72 months","Total",null,null,{"$f":"SUM(E169:E179)","v":1},{"$f":"SUM(F169:F179)","v":232985064.79000005},{"$f":"F166-F180","v":0},null,0.99999999999999978,253371003.93000013,0,null,0.99999999999999989,275076134.53000009,0]
[]
[null,"Remaining Term Distribution"]
["0 - 12 months","0-12 Months",null,null,{"$f":"F183/F$189","v":8.5540618227883045E-2},{"$f":"IFERROR(VLOOKUP($A$183,'[7]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":19929686.479999978},null,null,6.8320924657907817E-2,17310541.269999996,null,null,6.3701946444535792E-2,17522885.189999983]
["13 - 24 months","13-24 Months",null,null,0.22061396530429481,{"$f":"IFERROR(VLOOKUP($A$184,'[7]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":51399758.999999918},null,null,0.20513319734234173,51974804.149999931,null,null,0.18765967606822767,51620698.300000012]
["25 - 36 months","25-36 Months",null,null,0.38616590038118892,{"$f":"IFERROR(VLOOKUP($A$185,'[7]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":89970887.319999948},null,null,0.38132173970740763,96615872.01000002,null,null,0.37347317387432544,102733557.02000001]
["37 - 48 months","37-48 Months",null,null,0.30172096328733122,{"$f":"IFERROR(VLOOKUP($A$186,'[7]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":70296478.180000052},null,null,0.30630856130420375,77609707.690000057,null,null,0.29234209738842232,80416334.110000014]
["49 - 60 months","49-60 Months",null,null,5.9585527993019499E-3,{"$f":"IFERROR(VLOOKUP($A$187,'[7]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":1388253.81},null,null,3.8915576988139064E-2,9860078.8100000005,null,null,8.2823106224488907E-2,22782659.909999989]
["60+ Months","60+ Months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$188,'[7]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E183:E188)","v":0.99999999999999989},{"$f":"SUM(F183:F188)","v":232985064.7899999},{"$f":"F180-F189","v":0},null,1,253371003.93000001,0,null,1,275076134.52999997,0]
[]
[null,"Origination LVR Distribution"]
["01. 10% to 20%","10% to 20%",null,null,{"$f":"F192/F$202","v":2.8521321767940259E-4},{"$f":"IFERROR(VLOOKUP($A$192,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":66450.420000000013},null,null,2.6226529069742547E-4,66450.420000000013,null,null,2.4157101128943211E-4,66450.420000000013]
["02. 21% to 30%","21% to 30%",null,null,1.0644697342447187E-2,{"$f":"IFERROR(VLOOKUP($A$193,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":2480055.4999999995},null,null,1.0435056454725391E-2,2643940.73,null,null,1.0259362248280455E-2,2822105.709999999]
["03. 31% to 40%","31% to 40%",null,null,4.1820293926489477E-2,{"$f":"IFERROR(VLOOKUP($A$194,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":9743503.8899999969},null,null,4.0824645241796152E-2,10343781.349999994,null,null,3.9448241878709926E-2,10851269.889999997]
["04. 41% to 50%","41% to 50%",null,null,0.10050034147512872,{"$f":"IFERROR(VLOOKUP($A$195,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":23415078.569999997},null,null,9.8364585108110886E-2,24922733.679999996,null,null,9.5216678447048217E-2,26191835.850000001]
["05. 51% to 60%","51% to 60%",null,null,0.15107742885461881,{"$f":"IFERROR(VLOOKUP($A$196,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":35198784.54999999},null,null,0.14916385025826187,37793794.490000017,null,null,0.14652566500858785,40305713.540000044]
["06. 61% to 70%","61% to 70%",null,null,0.20428742272771996,{"$f":"IFERROR(VLOOKUP($A$197,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":47595918.419999972},null,null,0.20322021084237957,51490108.840000011,null,null,0.20239168583317513,55673122.600000009]
["07. 71% to 80%","71% to 80%",null,null,0.21294766630092385,{"$f":"IFERROR(VLOOKUP($A$198,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":49613625.830000058},null,null,0.21043635622460805,53318470.840000071,null,null,0.20993339359908025,57747666.420000069]
["08. 81% to 90%","81% to 90%",null,null,0.18029159220081892,{"$f":"IFERROR(VLOOKUP($A$199,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":42005248.290000066},null,null,0.18133965338312269,45946210.030000038,null,null,0.1855272104837368,51034107.910000041]
["09. 91% to 100%","91% to 100%",null,null,9.8145343954173694E-2,{"$f":"IFERROR(VLOOKUP($A$200,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":22866399.32},null,null,0.10595337719629801,26845513.550000008,null,null,0.11045619149009198,30383862.189999998]
["> 100%","> 100%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$201,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E192:E201)","v":1},{"$f":"SUM(F192:F201)","v":232985064.79000008},{"$f":"F189-F202","v":0},null,1,253371003.93000013,0,null,1,275076134.53000015,0]
[]
[null,"New v Used"]
["New","New",null,null,{"$f":"F205/F$208","v":0.91620993548407947},{"$f":"IFERROR(VLOOKUP($A$205,'[7]New v Used'!$A$1:$C$4,3,FALSE),0)","v":213463231.17999989},null,null,0.91570720063176403,232013652.72999984,null,null,0.91515033407067681,251736016.40999943]
["USed","Used",null,null,{"$f":"F206/F$208","v":8.379006451592047E-2},{"$f":"IFERROR(VLOOKUP($A$206,'[7]New v Used'!$A$1:$C$4,3,FALSE),0)","v":19521833.610000003},null,null,8.4292799368235971E-2,21357351.200000007,null,null,8.4849665929323193E-2,23340118.120000016]
["Used"]
[null,null,null,null,{"$f":"SUM(E205:E206)","v":1},{"$f":"SUM(F205:F206)","v":232985064.7899999},{"$f":"F202-F208","v":0},null,1,253371003.92999986,2.6822090148925781E-7,null,1,275076134.52999943,7.152557373046875E-7]
[]
[null,"Contract Type"]
["Finance Lease","Finance Lease",null,null,{"$f":"F211/F$214","v":1.0771847295285167E-2},{"$f":"IFERROR(VLOOKUP($A$211,'[7]Loan Type'!$A$1:$C$4,3,FALSE),0)","v":2509679.5399999996},null,null,1.4017237074930688E-2,3551561.4299999997,null,null,1.5444190486603929E-2,4248328.2200000007]
["Goods Mortgage","Goods Mortgage",null,null,{"$f":"F212/F$214","v":0.98922815270471487},{"$f":"IFERROR(VLOOKUP($A$212,'[7]Loan Type'!$A$1:$C$4,3,FALSE),0)","v":230475385.24999988},null,null,0.98598276292506926,249819442.49999961,null,null,0.98455580951339594,270827806.30999947]
["Hire Purchase","Hire Purchase",null,null,{"$f":"F213/F$214","v":0},{"$f":"IFERROR(VLOOKUP($A$213,'[7]Loan Type'!$A$1:$C$4,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E211:E213)","v":1},{"$f":"SUM(F211:F213)","v":232985064.78999987},{"$f":"F208-F214","v":0},null,1,253371003.92999962,2.384185791015625E-7,null,0.99999999999999989,275076134.52999949,0]
[]
[null,"Contract by Source"]
["Non Hardship Refinance","Non Hardship Refinance",null,null,{"$f":"F217/F$219","v":0.99484428673107139},{"$f":"E13-F218","v":231783860.60000005},null,null,0.99233147151859258,251428021.17000008,null,null,0.99224998041490398,272944289.10000008]
["Refinance - Hardship","Hardship Refinance",null,null,{"$f":"F218/F$219","v":5.1557132689286304E-3},{"$f":"VLOOKUP($A$218,[7]Source!$A$1:$C$238,3,FALSE)","v":1201204.19},null,null,7.6685284814074321E-3,1942982.76,null,null,7.7500195850959885E-3,2131845.4299999997]
[null,null,null,null,{"$f":"SUM(E217:E218)","v":1},{"$f":"SUM(F217:F218)","v":232985064.79000005},{"$f":"F214-F219","v":0},null,1,253371003.93000007,-4.4703483581542969E-7,null,1,275076134.53000009,-5.9604644775390625E-7]
[]
[null,"Payment Frequency Distribution"]
["6 Consecutive","6 Consecutive",null,null,{"$f":"F222/F$228","v":8.3732950082374986E-3},{"$f":"IFERROR(VLOOKUP($A$222,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":1950852.6799999997},null,null,9.2367592727641938E-3,2340326.9700000002,null,null,8.8966186549822371E-3,2447247.4700000007]
["Annual","Annual",null,null,0.75049838421018389,{"$f":"IFERROR(VLOOKUP($A$223,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":174854914.67000023},null,null,0.72680765274497028,184151984.6399999,null,null,0.71388382654687721,196372403.50999993]
["Monthly","Monthly",null,null,0.1776888047622909,{"$f":"IFERROR(VLOOKUP($A$224,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":41398837.690000057},null,null,0.19174234488734965,48581950.420000076,null,null,0.20092981179351313,55270995.939999983]
["Quarterly","Quarterly",null,null,1.0706185618585879E-2,{"$f":"IFERROR(VLOOKUP($A$225,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":2494381.35},null,null,1.1359311426161268E-2,2878120.14,null,null,1.1294773010056084E-2,3106922.4999999995]
["Semi Annual","Semi Annual",null,null,4.4744232122330571E-2,{"$f":"IFERROR(VLOOKUP($A$226,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":10424737.82},null,null,5.1788451821524091E-2,13121692.029999994,null,null,5.576386597917344E-2,15339308.699999997]
["Structured","Structured",null,null,7.9890982783712254E-3,{"$f":"IFERROR(VLOOKUP($A$227,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":1861340.5799999998},null,null,9.0654798472306012E-3,2296929.73,null,null,9.2311040153978431E-3,2539256.4099999997]
["0% to 1%",null,null,null,{"$f":"SUM(E222:E227)","v":0.99999999999999989},{"$f":"SUM(F222:F227)","v":232985064.79000029},{"$f":"F219-F228","v":-2.384185791015625E-7},null,1.0000000000000002,253371003.92999995,0,null,1,275076134.52999991,0]
["1.01% to 2%"]
["2.01% to 3%","Yield Distribution"]
["01. 0% to 1%",null,null,null,{"$f":"F231/F$245","v":0.11119192937689074},{"$f":"IFERROR(VLOOKUP($A$231,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":25906058.870000005},null,null,0.10783087530232213,27321217.13000001,null,null,0.108030019073716,29716480.059999984]
["02. 1.01% to 2%",null,null,null,7.3177813759724639E-2,{"$f":"IFERROR(VLOOKUP($A$232,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":17049337.680000007},null,null,7.7273867949819372E-2,19578957.499999993,null,null,7.5982614252275371E-2,20901003.820000008]
["03. 2.01% to 3%",null,null,null,0.2251475247019846,{"$f":"IFERROR(VLOOKUP($A$233,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":52456010.630000032},null,null,0.22649860702235261,57388179.450000048,null,null,0.23112441436851131,63576810.500000119]
["04. 3.01% to 4%",null,null,null,0.22906225018373214,{"$f":"IFERROR(VLOOKUP($A$234,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":53368083.200000048},null,null,0.22339910590415454,56602855.740000047,null,null,0.21787793231282171,59933019.420000009]
[null,"< 4%",null,null,{"$f":"SUM(E231:E234)","v":0.63857951802233215},{"$f":"SUM(F231:F234)","v":148779490.38000008},null,null,0.6350024561786487,160891209.82000008,null,null,0.63301498000732437,174127313.80000013]
["05. 4.01% to 5%","4% to 5%",null,null,{"$f":"F236/F$245","v":0.18665176151611632},{"$f":"IFERROR(VLOOKUP($A$236,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":43487072.750000007},null,null,0.1832869910908593,46439608.940000005,null,null,0.17937746589433282,49342459.940000005]
["06. 5.01% to 6%","5% to 6%",null,null,0.11480080250683948,{"$f":"IFERROR(VLOOKUP($A$237,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":26746872.410000004},null,null,0.11610592362071315,29417874.430000003,null,null,0.11612764100593451,31943942.600000001]
["07. 6.01% to 7%","6% to 7%",null,null,3.8315587645269329E-2,{"$f":"IFERROR(VLOOKUP($A$238,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":8926959.6700000018},null,null,3.9079290749211147E-2,9901559.1299999934,null,null,3.9109225881704818E-2,10758014.679999998]
["08. 7.01% to 8%","7% to 8%",null,null,1.3609547817401958E-2,{"$f":"IFERROR(VLOOKUP($A$239,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":3170821.38},null,null,1.7326245513132339E-2,4389968.2200000007,null,null,2.1410064017595442E-2,5889397.6499999994]
["09. 8.01% to 9%","8% to 9%",null,null,7.4218315734469265E-3,{"$f":"IFERROR(VLOOKUP($A$240,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":1729175.9100000006},null,null,8.4567220272449596E-3,2142688.1500000008,null,null,9.6038315519948667E-3,2641784.86]
["10. 9.01% to 10%","9% to 10%",null,null,5.7982184446785242E-4,{"$f":"IFERROR(VLOOKUP($A$241,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":135089.82999999996},null,null,6.7482911362358553E-4,170982.12999999998,null,null,8.6659164528139797E-4,238378.68]
["11. 10.01% to 11%","10% to 11%",null,null,3.7903588403659055E-5,{"$f":"IFERROR(VLOOKUP($A$242,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":8830.9700000000012},null,null,6.0229583351282267E-5,15260.430000000008,null,null,1.9725335348596859E-4,54259.689999999973]
["12. 11.01% to 12%","11% to 12%",null,null,3.2254857223459778E-6,{"$f":"IFERROR(VLOOKUP($A$243,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":751.48999999999796},null,null,7.3121232156140666E-6,1852.6799999999967,null,null,2.7250579236209519E-4,74959.839999999982]
["13. > 12%","> 12%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$244,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":0},null,null,0,0,null,null,2.0440849983613463E-5,5622.7900000000081]
[null,null,null,null,{"$f":"SUM(E235:E244)","v":0.99999999999999978},{"$f":"SUM(F235:F244)","v":232985064.79000011},{"$f":"F228-F245","v":0},null,1.0000000000000002,253371003.9300001,0,null,0.99999999999999989,275076134.53000015,0]
[]
[null,"Top 5 Obligor",null,null,{"$f":"F247/E13","v":2.3381007769360709E-2},{"$f":"SUM('[7]Top 5 Obligor '!$E$2:$E$6)","v":5447425.6099999994},null,null,2.4718751091700734E-2,6263014.7800000003,null,null,2.4580872606607657E-2,6761611.4200000018]

{"sheet":"Note Balance","index":1,"n_rows":64,"n_cols":9,"rows_kept":64,"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","Class D Notes"]
[null,null,"Initial Invested Amount",350000000,105000000,198000000,11300000,10500000,6200000]
["(a)",null,"Invested Amount as at Previous Payment Date:  3 March 2016",350000000,105000000,198000000,11300000,10500000,6200000]
["(b)",null,"Stated Amount as at Previous Payment Date:  3 March 2016",350000000,105000000,198000000,11300000,10500000,6200000]
["(d)",null,"Principal Payments to Noteholders on Payment Date",350000000,74839799.260000005,0,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
["(e)",null,"Aggregate Charge-Offs for this Collection Period",84066.21,0,0,0,0,0]
["(f)",null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",84066.21,0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 May 2016",275160200.74000001,30160200.739999995,198000000,11300000,10500000,6200000]
[null,null,"Stated Amount as at Payment Date:  16 May 2016",275076134.53000003,30160200.739999995,198000000,11300000,10500000,6200000]
[null,null,"Bond Factor at Payment Date:  16 May 2016",null,0.28724000704761898,1,1,1,1]
[null,null,"Coupon Margin",null,6.0000000000000001E-3,1.2999999999999999E-2,0.02,2.5000000000000001E-2,2.4500000000000001E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.9100000000000001E-2,3.61E-2,4.3099999999999999E-2,4.8100000000000004E-2,4.7600000000000003E-2]
[null,null,"Days in Coupon Period",null,74,74,74,74,74]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 May 2016",null,619471.23,1449143.01,98740.33,102393.7,59832.55]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes","Class D Notes"]
[null,null,"Initial Invested Amount",350000000,105000000,198000000,11300000,10500000,6200000]
["(a)",null,"Invested Amount as at Previous Payment Date:  16 May 2016",350000000,30160200.739999995,198000000,11300000,10500000,6200000]
["(b)",null,"Stated Amount as at Previous Payment Date:  16 May 2016",275160200.74000001,30160200.739999995,198000000,11300000,10500000,6200000]
["(d)",null,"Principal Payments to Noteholders on Payment Date",275076134.53000003,21349482.670000002,0,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
["(e)",null,"Aggregate Charge-Offs for this Collection Period",355647.93,0,0,0,0,0]
["(f)",null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",84066.21,0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",439714.14,0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 August 2016",253810718.06999999,8810718.0699999928,198000000,11300000,10500000,6200000]
[null,null,"Stated Amount as at Payment Date:  16 August 2016",253371003.93000001,8810718.0699999928,198000000,11300000,10500000,6200000]
[null,null,"Bond Factor at Payment Date:  16 August 2016",null,8.39116006666666E-2,1,1,1,1]
[null,null,"Coupon Margin",null,6.0000000000000001E-3,1.2999999999999999E-2,0.02,2.5000000000000001E-2,2.4500000000000001E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.5849999999999998E-2,3.2849999999999997E-2,3.9849999999999997E-2,4.4850000000000001E-2,4.4350000000000001E-2]
[null,null,"Days in Coupon Period",null,92,92,92,92,92]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 August 2016",null,196512.3,1639440,113501.53,118698.9,69307.509999999995]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes","Class D Notes"]
[null,null,"Initial Invested Amount",350000000,105000000,198000000,11300000,10500000,6200000]
["(a)",null,"Invested Amount as at Previous Payment Date:  16 August 2016",350000000,8810718.0699999928,198000000,11300000,10500000,6200000]
["(b)",null,"Stated Amount as at Previous Payment Date:  16 August 2016",253810718.06999999,8810718.0699999928,198000000,11300000,10500000,6200000]
["(d)",null,"Principal Payments to Noteholders on Payment Date",253371003.93000001,8810718.0700000003,11575221.07,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
["(e)",null,"Aggregate Charge-Offs for this Collection Period",0,0,0,0,0,0]
["(f)",null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",439714.14,0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",439714.14,0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 November 2016",233424778.93000001,0,186424778.93000001,11300000,10500000,6200000]
[null,null,"Stated Amount as at Payment Date:  16 November 2016",232985064.79000002,-7.4505805969238281E-9,186424778.93000001,11300000,10500000,6200000]
[null,null,"Bond Factor at Payment Date:  16 November 2016",null,-7.0957910446893603E-17,0.94153928752525251,1,1,1]
[null,null,"Coupon Margin",null,6.0000000000000001E-3,1.2999999999999999E-2,0.02,2.5000000000000001E-2,2.4500000000000001E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.3550000000000001E-2,3.0550000000000001E-2,3.755E-2,4.2550000000000004E-2,4.2050000000000004E-2]
[null,null,"Days in Coupon Period",null,92,92,92,92,92]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 November 2016",null,52299.46,1524654.25,106950.63,112611.78,65713.210000000006]

{"sheet":"Cumulative Defaults","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Cumulative Defaults & Losses"]
[]
["Month","Gross Losses","Recoveries","Net Losses"]
["2016-04-01",2.4018917142857145E-4,0,{"$f":"B4-C4","v":2.4018917142857145E-4}]
["2016-07-01",1.2563261142857142E-3,-2.4793114285714286E-5,1.2811192285714285E-3]
["2016-10-01",{"$f":"B5+'Collateral Tables'!E9/350000000","v":1.2563261142857142E-3},{"$f":"C5+'Collateral Tables'!E23/350000000","v":2.3424894285714297E-4},1.0220771714285713E-3]
["2017-01-01"]
["2017-04-01"]
["2017-07-01"]
["2017-10-01"]
["2018-01-01"]
["2018-04-01"]
["2018-07-01"]
["2018-10-01"]