{"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":6,"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":11,"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-07-31",null,null,null,"2016-04-30"]
[]
[null,"Opening Balance",null,null,{"$f":"I13","v":275076134.53000009},null,null,null,349999833.42000002]
[null,"Principal Repayments - Scheduled",null,null,{"$f":"MIN('[1]16 Aug 16'!$H23,SUM([2]Sheet1!$B$3,[2]Sheet1!$B$4,[3]Sheet1!$B$3))","v":18368178.68},null,null,null,70539694.680000007]
[null,"Principal Repayments - Unscheduled",null,null,{"$f":"'[1]16 Aug 16'!H23-'Collateral Tables '!E7","v":2981303.9900000058},null,null,null,4299937.9999999255]
[{"$f":"SUM(E9:I9)","v":439714.14},"Charge-Offs",null,null,{"$f":"'[1]16 Aug 16'!$H37","v":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":253371003.93000007},null,null,null,275076134.53000009]
[]
[null,"PORTFOLIO STATISTICS"]
[]
[null,"Summary"]
[null,"Number of contracts",null,null,{"$f":"[4]Summary!$B$4","v":3263},null,null,null,3422]
[null,"Dollar value of contracts",null,null,{"$f":"[4]Summary!$B$6","v":77649.710061293183},null,null,null,80384.609739918029]
[null,"Number of contracts closed during the Quarter",null,null,{"$f":"[4]Summary!$B$19","v":157},null,null,null,216]
[null,"Dollar value of contracts closed during the Quarter",null,null,{"$f":"[4]Summary!$B$20","v":5997812.8599999985},null,null,null,10129289.880000003]
[]
[{"$f":"SUM(I23)","v":0},"Dollar Value of Recoveries from Collateral",null,null,{"$f":"[4]Summary!$C$16","v":-8677.59},null,null,null,0]
[null,"Dollar Value of Recoveries from Other Sources",null,null,0,null,null,null,0]
[]
[null,"Average Term of Contracts (Months)",null,null,{"$f":"[5]Sheet1!$W$3265","v":50.905018498380905},null,null,null,50.602561692977268]
[null,"Average Term to Maturity (Months)",null,null,{"$f":"[5]Sheet1!$X$3265","v":31.261824556602878},null,null,null,33.580143025830573]
[null,"Average Residual / Balloon Payment *",null,null,{"$f":"[5]Sheet1!$AI$3265","v":2.2629991788590827E-2},null,null,null,2.4040809082651878E-2]
[null,"Average Seasoning (Months)",null,null,{"$f":"E26-E27","v":19.643193941778026},null,null,null,17.022418667146695]
[null,"Average Dollar Value of Individual Assets",null,null,{"$f":"E19/E18","v":23.797030358962054},null,null,null,23.490534698982476]
[null,"Weighted Average Interest Rate",null,null,{"$f":"[5]Sheet1!$AA$3265/100","v":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,'[6]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":3255},{"$f":"IFERROR(VLOOKUP($A34,'[6]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":120639.01000000001},{"$f":"F34/F$50","v":4.7613581715660603E-4},null,3409,279917.05,1.0175984567991395E-3]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A35,'[6]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":3},{"$f":"IFERROR(VLOOKUP($A35,'[6]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":46074.110000000015},{"$f":"F35/F$50","v":1.8184444662313923E-4},null,8,230113.48,8.3654469113860581E-4]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A36,'[6]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":4},{"$f":"IFERROR(VLOOKUP($A36,'[6]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":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,'[6]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A37,'[6]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":0},0,null,1,48099.140000000007,1.7485755382662749E-4]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A38,'[6]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A38,'[6]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":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,'[6]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A39,'[6]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":0},0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E34:E39)","v":3263},{"$f":"SUM(F34:F39)","v":232276.57},{"$f":"SUM(G34:G39)","v":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":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,'[6]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":3255},{"$f":"IFERROR(VLOOKUP($A44,'[6]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":252870428.10999963},{"$f":"F44/F$50","v":0.99802433659639167},null,3409,273901148.7699995,0.99572850708402028]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A45,'[6]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":3},{"$f":"IFERROR(VLOOKUP($A45,'[6]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":122576.48000000001},{"$f":"F45/F$50","v":4.8378258797863457E-4},null,8,698753.64,2.5402190604208695E-3]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A46,'[6]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":4},{"$f":"IFERROR(VLOOKUP($A46,'[6]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":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,'[6]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A47,'[6]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":0},{"$f":"F47/F$50","v":0},null,1,84424.18,3.0691204871061899E-4]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A48,'[6]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A48,'[6]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":11660.76},{"$f":"F48/F$50","v":4.6022472260565345E-5},null,1,284053.38,1.0326354937528085E-3]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A49,'[6]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A49,'[6]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":0},0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E44:E49)","v":3263},{"$f":"SUM(F44:F49)","v":253371003.92999962},{"$f":"SUM(G44:G49)","v":1},null,3422,275076134.52999949,1]
["NSW",null,null,null,null,"> 30 days",{"$f":"SUM(G45:G49)","v":1.9756634036083198E-3},null,null,"> 30 days",4.2714929159798024E-3]
[null,null,null,null,null,">90 days",{"$f":"SUM(G47:G49)","v":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.29110503718246078},{"$f":"IFERROR(VLOOKUP($A$55,'[6]Geographic '!$A$1:$C$10,3,FALSE),0)","v":73757575.520000115},null,null,0.29705376436823705,81712401.250000164]
["VIC","Victoria",null,null,{"$f":"F56/F$63","v":0.17529086308656849},{"$f":"IFERROR(VLOOKUP($A$56,'[6]Geographic '!$A$1:$C$10,3,FALSE),0)","v":44413621.960000068},null,null,0.18022488506574988,49575564.730000041]
["QLD","Queensland",null,null,0.11345624631120736,{"$f":"IFERROR(VLOOKUP($A$57,'[6]Geographic '!$A$1:$C$10,3,FALSE),0)","v":28746523.02999999},null,null,0.11757327303315286,32341601.470000003]
["SA","South Australia",null,null,0.18459924361716598,{"$f":"IFERROR(VLOOKUP($A$58,'[6]Geographic '!$A$1:$C$10,3,FALSE),0)","v":46772095.680000022},null,null,0.17919394619319157,49291978.049999982]
["NT","Northern Territory",null,null,4.1777795548082671E-4,{"$f":"IFERROR(VLOOKUP($A$59,'[6]Geographic '!$A$1:$C$10,3,FALSE),0)","v":105852.81999999999},null,null,3.848128089369219E-4,105852.81999999999]
["ACT","Australian Capital Territory",null,null,2.2047574163392924E-4,{"$f":"IFERROR(VLOOKUP($A$60,'[6]Geographic '!$A$1:$C$10,3,FALSE),0)","v":55862.159999999989},null,null,2.2276559943922353E-4,61277.499999999993]
["TAS","Tasmania",null,null,8.8499200193384916E-3,{"$f":"IFERROR(VLOOKUP($A$61,'[6]Geographic '!$A$1:$C$10,3,FALSE),0)","v":2242313.12},null,null,9.7943024559484972E-3,2694178.8600000003]
["WA","Western Australia",null,null,0.22606043608614426,{"$f":"IFERROR(VLOOKUP($A$62,'[6]Geographic '!$A$1:$C$10,3,FALSE),0)","v":57277159.640000015},null,null,0.21555225047534396,59293279.850000016]
[null,"Total",null,null,{"$f":"SUM(E55:E62)","v":1.0000000000000002},{"$f":"SUM(F55:F62)","v":253371003.93000019},null,null,0.99999999999999989,275076134.53000021]
["AG",null,null,null,null,null,{"$f":"E13-F63","v":0},null,null,null,275076134.53000009]
["CE","Top Industry Distribution"]
["AGRICULTURAL MACHINERY","Agricultural",null,null,{"$f":"F66/F$69","v":0.98669367201571556},{"$f":"IFERROR(VLOOKUP(A66,'[6]Top Industry'!$A$1:$C$5,3,FALSE),)","v":249999566.24999967},null,null,0.9852200432911179,271010521.1699996]
["CONSTRUCTION EQUIPMENT","Construction",null,null,{"$f":"F67/F$69","v":1.3306327984284449E-2},{"$f":"IFERROR(VLOOKUP($A$67,'[6]Top Industry'!$A$1:$C$5,3,FALSE),)","v":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,'[6]Top Industry'!$A$1:$C$5,3,FALSE),)","v":0},null,null,0,0]
[null,"Total",null,null,{"$f":"SUM(E66:E68)","v":1},{"$f":"SUM(F66:F68)","v":253371003.92999968},{"$f":"F63-F69","v":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.1031342088663761},{"$f":"IFERROR(VLOOKUP($A$72,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":26131218.040000021},null,null,0.10702894513296701,29441108.51000002]
["4 EWD Tractors","4 EWD Tractors",null,null,0.1081672270106003,{"$f":"IFERROR(VLOOKUP($A$73,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":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,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,""]
["40<60 HP TRACTOR","40-60 HP TRACTOR",null,null,{"$f":"IFERROR(F75/F$107,0)","v":7.5032547154654967E-3},{"$f":"IFERROR(VLOOKUP($A$75,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":1901107.1799999995},null,null,8.2621937518615757E-3,2272732.3199999998]
["4WD VEHICLE","4WD VEHICLE",null,null,7.2201829397392775E-5,{"$f":"IFERROR(VLOOKUP($A$76,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":18293.849999999995},null,null,8.1090059078052425E-5,22305.939999999995]
["60<100 HP TRACTOR","60-100 HP TRACTOR",null,null,6.3897213252045268E-2,{"$f":"IFERROR(VLOOKUP($A$77,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":16189701.07000001},null,null,6.7368036277167365E-2,18531339.010000009]
["Backhoes","Backhoes",null,null,5.3357810445172499E-4,{"$f":"IFERROR(VLOOKUP($A$78,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":135193.21999999997},null,null,5.5525191329654385E-4,152736.54999999999]
["BALERS, WINDROWERS, MOWERS, RAKES","BALERS, WINDROWERS, MOWERS, RAKES",null,null,3.8811712735356309E-2,{"$f":"IFERROR(VLOOKUP($A$79,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":9833762.6199999955},null,null,3.8551025293848094E-2,10604467.01999999]
["QUAD BIKES","QUAD BIKES",null,null,3.2280489373833919E-5,{"$f":"IFERROR(VLOOKUP($A$80,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":8178.9399999999969},null,null,3.3626544941110479E-5,9249.8599999999951]
["Combines","Combines",null,null,0.35462537021333246,{"$f":"IFERROR(VLOOKUP($A$81,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":89851786.069999963},null,null,0.34717658732253526,95499993.639999986]
["TRUCK - on Farm","TRUCK - on Farm",null,null,0,{"$f":"IFERROR(VLOOKUP($A$82,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,7.0909568484839601E-5,19505.529999999984]
["Cotton Pickers","Cotton Pickers",null,null,2.1506987443225701E-4,{"$f":"IFERROR(VLOOKUP($A$83,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":54492.47},null,null,1.9809959192972816E-4,54492.47]
["CRAWLERS / DOZERS","CRAWLERS / DOZERS",null,null,0,{"$f":"IFERROR(VLOOKUP($A$84,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,""]
["CULTIVATORS,SEEDERS, HARROWS","CULTIVATORS,SEEDERS, HARROWS",null,null,1.4877028474187173E-2,{"$f":"IFERROR(VLOOKUP($A$85,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":3769407.64},null,null,1.4343276441416268E-2,3945493.0400000005]
["Drill","Drill",null,null,5.8151196354222859E-4,{"$f":"IFERROR(VLOOKUP($A$86,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":147338.27000000002},null,null,6.3340747570741303E-4,174235.28000000003]
["DUMP TRUCKS","DUMP TRUCKS",null,null,0,{"$f":"IFERROR(VLOOKUP($A$87,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,""]
["EXCAVATORS / GRADERS","EXCAVATORS / GRADERS",null,null,4.5049112262085973E-3,{"$f":"IFERROR(VLOOKUP($A$88,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":1141413.8799999997},null,null,5.0805466726070482E-3,1397537.1400000001]
["FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE","FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE",null,null,2.8129264949232503E-3,{"$f":"IFERROR(VLOOKUP($A$89,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":712714.01},null,null,2.7273481259355841E-3,750228.38]
["Front End Loader","Front End Loader",null,null,4.3116030763402273E-4,{"$f":"IFERROR(VLOOKUP($A$90,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":109243.51999999999},null,null,5.463704448835379E-4,150293.47]
["Fronts","Fronts",null,null,3.9455556653838287E-3,{"$f":"IFERROR(VLOOKUP($A$91,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":999689.39999999991},null,null,3.9743435099084167E-3,1093247.0499999998]
["GUIDANCE SYSTEMS","Guidance Systems",null,null,0,{"$f":"IFERROR(VLOOKUP($A$92,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,""]
["HARVESTERS - Other","HARVESTERS - Other",null,null,3.0498564871830791E-3,{"$f":"IFERROR(VLOOKUP($A$93,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":772745.2},null,null,2.8119371799433289E-3,773496.80999999994]
["Irrigation Equipment","Irrigation Equipment",null,null,9.053550581635412E-4,{"$f":"IFERROR(VLOOKUP($A$94,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":229390.71999999997},null,null,8.339172003850537E-4,229390.71999999997]
["Other AG","Other AG",null,null,5.6552530785877429E-3,{"$f":"IFERROR(VLOOKUP($A$95,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":1432877.1499999997},null,null,5.6825801797411929E-3,1563142.1899999997]
["MATERIALS HANDLING EQUIPMENT","MATERIALS HANDLING EQUIPMENT",null,null,2.3012392537272603E-4,{"$f":"IFERROR(VLOOKUP($A$96,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":58306.729999999996},null,null,2.5077831676625022E-4,68983.12999999999]
["Other CE","Other CE",null,null,5.8057799715961365E-4,{"$f":"IFERROR(VLOOKUP($A$97,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":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,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,""]
["OVER 140 HP TRACTOR","OVER 140 HP TRACTOR",null,null,0.21029926587306322,{"$f":"IFERROR(VLOOKUP($A$99,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":53283736.12000002},null,null,0.21130998019626707,58126332.539999992]
["Rollers","Rollers",null,null,0,{"$f":"IFERROR(VLOOKUP($A$100,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,""]
["SCRAPERS","SCRAPERS",null,null,2.7125578276110835E-4,{"$f":"IFERROR(VLOOKUP($A$101,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":68728.350000000006},null,null,2.7464425486813972E-4,75548.08]
["SKIDSTEER / UNILOADER","SKIDSTEER / UNILOADER",null,null,6.8213900296085076E-3,{"$f":"IFERROR(VLOOKUP($A$102,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":1728342.44},null,null,7.2801913311079866E-3,2002606.8900000001]
["SPRAYING EQUIPMENT","SPRAYING EQUIPMENT",null,null,6.5009310909746584E-2,{"$f":"IFERROR(VLOOKUP($A$103,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":16471474.369999995},null,null,6.2545564119535171E-2,17204792.009999998]
["Trenchers","Trenchers",null,null,0,{"$f":"IFERROR(VLOOKUP($A$104,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,""]
["Under 40 HP Tractors","Under 40 HP Tractors",null,null,2.6679087169215058E-3,{"$f":"IFERROR(VLOOKUP($A$105,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":675970.71000000008},null,null,2.8711081437487146E-3,789773.33]
["Wheel Loaders","Wheel Loaders",null,null,3.6449091872215329E-4,{"$f":"IFERROR(VLOOKUP($A$106,[6]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":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":253371003.93000001},{"$f":"F69-F107","v":-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.3393036141331653E-2},{"$f":"IFERROR(VLOOKUP($A$110,'[6] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":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.10454796969316318},{"$f":"IFERROR(VLOOKUP($A$111,'[6] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":26489424.039999973},null,null,9.9211197244098534E-2,27290632.640000023]
["$50,001 - $75,000","$ 50,001 to $75,000",null,null,0.11092138873067157,{"$f":"IFERROR(VLOOKUP($A$112,'[6] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":28104263.620000049},null,null,0.11112488148864204,30567802.850000013]
["$75,001 - $100,000","$ 75,001 to $100,000",null,null,9.7541995400657389E-2,{"$f":"IFERROR(VLOOKUP($A$113,'[6] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":24714313.300000008},null,null,9.67294360358191E-2,26607959.360000014]
["$100,001 - $125,000","$100,001 to $125,000",null,null,9.5646216552448288E-2,{"$f":"IFERROR(VLOOKUP($A$114,'[6] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":24233977.910000011},null,null,9.6812115909297961E-2,26630702.620000008]
["$125,001 - $150,000","$125,001 to $150,000",null,null,8.7528803556886123E-2,{"$f":"IFERROR(VLOOKUP($A$115,'[6] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":22177260.829999994},null,null,8.9536094151104556E-2,24629242.679999992]
["$150,001 - $200,000","$150,000 to $200,000",null,null,0.12386445711313716,{"$f":"IFERROR(VLOOKUP($A$116,'[6] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":31383661.849999998},null,null,0.12195206031710987,33546101.349999998]
["$200,001 - $300,000","$200,001 to $300,000",null,null,0.20142154728999512,{"$f":"IFERROR(VLOOKUP($A$117,'[6] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":51034379.650000043},null,null,0.20571595222786784,56587548.950000048]
["$300,001 - $400,000","$300,001 to $400,000",null,null,6.9209609023946031E-2,{"$f":"IFERROR(VLOOKUP($A$118,'[6] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":17535708.119999997},null,null,6.6937862135734841E-2,18413008.369999997]
["$400,001 - $500,000","$400,001 to $500,000",null,null,2.4220888400061202E-2,{"$f":"IFERROR(VLOOKUP($A$119,'[6] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":6136870.8099999996},null,null,3.0528967532383763E-2,8397790.3800000008]
["$500,001+","$500,000+",null,null,3.1704088097702317E-2,{"$f":"IFERROR(VLOOKUP($A$120,'[6] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":8032896.6300000008},null,null,3.2448132315261079E-2,8925706.8100000005]
["$200,001 to $300,000","Total",null,null,{"$f":"SUM(E110:E120)","v":1.0000000000000002},{"$f":"SUM(F110:F120)","v":253371003.93000004},{"$f":"F107-F121","v":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.91349637239446979},{"$f":"IFERROR(VLOOKUP($A$124,'[6]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":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,'[6]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":""},null,null,0,""]
["6 to 10","06 to 10",null,null,6.5486858174916053E-4,{"$f":"IFERROR(VLOOKUP($A$126,'[6]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":165924.70999999996},null,null,6.1651978747543712E-4,169589.87999999998]
["11 to 15","11 to 15",null,null,7.4209404029494516E-3,{"$f":"IFERROR(VLOOKUP($A$127,'[6]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":1880251.12},null,null,7.5261714853500665E-3,2070270.1600000001]
["16 to 20","16 to 20",null,null,2.5339785336185455E-2,{"$f":"IFERROR(VLOOKUP($A$128,'[6]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":6420366.8499999968},null,null,2.4576692454803692E-2,6760461.5600000005]
["21 to 25","21 to 25",null,null,1.801105903681377E-2,{"$f":"IFERROR(VLOOKUP($A$129,'[6]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":4563480.1100000003},null,null,1.7524678279475642E-2,4820620.76]
["26 to 30","26 to 30",null,null,1.1770068175693484E-2,{"$f":"IFERROR(VLOOKUP($A$130,'[6]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":2982193.9899999998},null,null,1.2758596800833152E-2,3509585.4899999998]
["31 to 35","31 to 35",null,null,7.4294089726228496E-3,{"$f":"IFERROR(VLOOKUP($A$131,'[6]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":1882396.81},null,null,7.338744356900369E-3,2018713.4299999997]
["36 to 40","36 to 40",null,null,1.0027736365215426E-2,{"$f":"IFERROR(VLOOKUP($A$132,'[6]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":2540737.63},null,null,9.3033510681418494E-3,2559129.8500000006]
["41+ %","41+%",null,null,5.849760734300458E-3,{"$f":"IFERROR(VLOOKUP($A$133,'[6]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":1482159.75},null,null,9.2693270332469564E-3,2549770.65]
[null,null,null,null,{"$f":"SUM(E124:E133)","v":0.99999999999999989},{"$f":"SUM(F124:F133)","v":253371003.92999983},{"$f":"F121-F134","v":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,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0]
["Q22016","2016Q2",null,null,1.8344364303360051E-5,{"$f":"IFERROR(VLOOKUP($A$138,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":4647.929999999993},null,null,6.1769767955449084E-3,1699138.8999999994]
[{"$f":"RIGHT(B139,2)&LEFT(B139,4)","v":"Q32016"},"2016Q3",null,null,3.9449232725783578E-3,{"$f":"IFERROR(VLOOKUP($A$139,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":999529.16999999993},null,null,4.8508062041800869E-3,1334341.02]
[{"$f":"RIGHT(B140,2)&LEFT(B140,4)","v":"Q42016"},"2016Q4",null,null,3.701608690231627E-3,{"$f":"IFERROR(VLOOKUP($A$140,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":937880.31},null,null,4.8468328678458851E-3,1333248.0500000003]
["Q12017","2017Q1",null,null,3.5370445516630329E-2,{"$f":"IFERROR(VLOOKUP($A$141,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":8961845.2899999972},null,null,3.6769171405151187E-2,10114321.539999995]
["Q22017","2017Q2",null,null,1.9811701229185706E-2,{"$f":"IFERROR(VLOOKUP($A$142,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":5019710.629999999},null,null,2.6571858669196351E-2,7309284.1700000018]
["Q32017","2017Q3",null,null,1.9991140783415694E-2,{"$f":"IFERROR(VLOOKUP($A$143,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":5065175.4100000029},null,null,2.3447092824028997E-2,6449735.6599999974]
["Q42017","2017Q4",null,null,3.2315909567387238E-2,{"$f":"IFERROR(VLOOKUP($A$144,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":8187914.4500000002},null,null,3.3962660759220172E-2,9342317.4399999995]
["Q12018","2018Q1",null,null,8.832679810584361E-2,{"$f":"IFERROR(VLOOKUP($A$145,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":22379449.510000028},null,null,8.5662956185790576E-2,23563834.860000022]
["Q22018","2018Q2",null,null,5.7405358957406075E-2,{"$f":"IFERROR(VLOOKUP($A$146,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":14544853.430000002},null,null,6.2640495764712659E-2,17230905.439999994]
["Q32018","2018Q3",null,null,4.9380348366368752E-2,{"$f":"IFERROR(VLOOKUP($A$147,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":12511548.43999999},null,null,5.0724821271175211E-2,13953187.759999996]
["Q42018","2018Q4",null,null,6.0417356218982372E-2,{"$f":"IFERROR(VLOOKUP($A$148,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":15308006.199999999},null,null,5.9473421341885976E-2,16359718.849999998]
["Q12019","2019Q1",null,null,0.18515725908778813,{"$f":"IFERROR(VLOOKUP($A$149,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":46913480.620000012},null,null,0.17303693023506883,47598329.900000013]
["Q22019","2019Q2",null,null,8.4227816360138666E-2,{"$f":"IFERROR(VLOOKUP($A$150,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":21340886.390000019},null,null,8.554092331639114E-2,23530266.53000002]
["Q32019","2019Q3",null,null,4.8981444156998705E-2,{"$f":"IFERROR(VLOOKUP($A$151,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":12410477.68},null,null,4.8043665047789494E-2,13215665.67]
["Q42019","2019Q4",null,null,3.7240252134797591E-2,{"$f":"IFERROR(VLOOKUP($A$152,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":9435600.0699999947},null,null,3.6237108453742971E-2,9967963.7200000007]
["Q12020","2020Q1",null,null,0.15395259810699038,{"$f":"IFERROR(VLOOKUP($A$153,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":39007124.339999989},null,null,0.14403823620576159,39621481.239999987]
["Q22020","2020Q2",null,null,6.8949604370776671E-2,{"$f":"IFERROR(VLOOKUP($A$154,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":17469830.480000008},null,null,6.8689836660254924E-2,18894934.750000007]
["Q32020","2020Q3",null,null,3.7625784569389011E-2,{"$f":"IFERROR(VLOOKUP($A$155,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":9533282.8100000005},null,null,3.6930633685679046E-2,10158735.959999997]
["Q42020","2020Q4",null,null,1.132738598925438E-2,{"$f":"IFERROR(VLOOKUP($A$156,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":2870031.1599999997},null,null,1.0647937397421012E-2,2928993.4600000004]
["Q12021","2021Q1",null,null,1.853920151533102E-3,{"$f":"IFERROR(VLOOKUP($A$157,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":469729.61},null,null,1.7076349091591986E-3,469729.61]
["Q22021","2021Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A$158,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0]
["Q32021","2021Q3",null,null,0,{"$f":"IFERROR(VLOOKUP($A$159,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0]
["Q42021","2021Q4",null,null,0,{"$f":"IFERROR(VLOOKUP($A$160,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0]
["Q12022","2022Q1",null,null,0,{"$f":"IFERROR(VLOOKUP($A$161,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0]
["Q22022","2022Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A$162,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0]
["Q32022","2022Q3",null,null,0,{"$f":"IFERROR(VLOOKUP($A$163,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0]
["Q42022","2022Q4",null,null,0,{"$f":"IFERROR(VLOOKUP($A$164,'[6]Quarter of Maturity Dist'!$A$1:$C$22,3,FALSE),0)","v":0},null,null,0,0]
[]
[null,null,null,null,{"$f":"SUM(E137:E164)","v":0.99999999999999967},{"$f":"SUM(F137:F165)","v":253371003.9300001},{"$f":"F134-F166","v":-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,'[6]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,4.0425618961819558E-4,111201.23]
["07 to 12 months","07 to 12 months",null,null,0.20809500054144575,{"$f":"IFERROR(VLOOKUP($A$170,'[6]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":52725239.200000033},null,null,0.33802136640777658,92981610.859999999]
["13 to 18 months","13 to 18 months",null,null,0.30383246368344619,{"$f":"IFERROR(VLOOKUP($A$171,'[6]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":76982336.350000069},null,null,0.26295157954574017,72331704.070000038]
["19 to 24 months","19 to 24 months",null,null,0.22389227445170648,{"$f":"IFERROR(VLOOKUP($A$172,'[6]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":56727810.349999987},null,null,0.17982011556369829,49464222.300000034]
["25 to 30 months","25 to 30 months",null,null,0.11676300034779591,{"$f":"IFERROR(VLOOKUP($A$173,'[6]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":29584358.620000005},null,null,0.1087961730708997,29927230.73999998]
["31 to 36 months","31 to 36 months",null,null,0.10891454500304228,{"$f":"IFERROR(VLOOKUP($A$174,'[6]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":27595787.609999999},null,null,8.3664854856719859E-2,23014204.870000005]
["37 to 42 months","37 to 42 months",null,null,1.99023786139047E-2,{"$f":"IFERROR(VLOOKUP($A$175,'[6]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":5042685.6499999985},null,null,8.5730089381592968E-3,2358230.16]
["43 to 48 months","43 to 48 months",null,null,1.4788264686495764E-2,{"$f":"IFERROR(VLOOKUP($A$176,'[6]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":3746917.47},null,null,1.100645192347577E-2,3027612.2499999991]
["49 to 54 months","49 to 54 months",null,null,2.1924617315463297E-3,{"$f":"IFERROR(VLOOKUP($A$177,'[6]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":555506.23},null,null,3.0882081480876466E-3,849492.35999999987]
["55 to 60 months","55 to 60 months",null,null,1.6012665763130828E-3,{"$f":"IFERROR(VLOOKUP($A$178,'[6]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":405714.51999999996},null,null,3.6289038004172353E-3,998224.83]
["60+ months","61 to 72 months",null,null,1.8344364303360051E-5,{"$f":"IFERROR(VLOOKUP($A$179,'[6]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":4647.929999999993},null,null,4.5081555407154198E-5,12400.86]
["61 to 72 months","Total",null,null,{"$f":"SUM(E169:E179)","v":0.99999999999999978},{"$f":"SUM(F169:F179)","v":253371003.93000013},{"$f":"F166-F180","v":0},null,0.99999999999999989,275076134.53000009,0]
[]
[null,"Remaining Term Distribution"]
["0 - 12 months","0-12 Months",null,null,{"$f":"F183/F$189","v":6.8320924657907817E-2},{"$f":"IFERROR(VLOOKUP($A$183,'[6]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":17310541.269999996},null,null,6.3701946444535792E-2,17522885.189999983]
["13 - 24 months","13-24 Months",null,null,0.20513319734234173,{"$f":"IFERROR(VLOOKUP($A$184,'[6]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":51974804.149999931},null,null,0.18765967606822767,51620698.300000012]
["25 - 36 months","25-36 Months",null,null,0.38132173970740763,{"$f":"IFERROR(VLOOKUP($A$185,'[6]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":96615872.01000002},null,null,0.37347317387432544,102733557.02000001]
["37 - 48 months","37-48 Months",null,null,0.30630856130420375,{"$f":"IFERROR(VLOOKUP($A$186,'[6]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":77609707.690000057},null,null,0.29234209738842232,80416334.110000014]
["49 - 60 months","49-60 Months",null,null,3.8915576988139064E-2,{"$f":"IFERROR(VLOOKUP($A$187,'[6]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":9860078.8100000005},null,null,8.2823106224488907E-2,22782659.909999989]
["60+ Months","60+ Months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$188,'[6]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0]
[null,null,null,null,{"$f":"SUM(E183:E188)","v":1},{"$f":"SUM(F183:F188)","v":253371003.93000001},{"$f":"F180-F189","v":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.6226529069742547E-4},{"$f":"IFERROR(VLOOKUP($A$192,'[6]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":66450.420000000013},null,null,2.4157101128943211E-4,66450.420000000013]
["02. 21% to 30%","21% to 30%",null,null,1.0435056454725391E-2,{"$f":"IFERROR(VLOOKUP($A$193,'[6]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":2643940.73},null,null,1.0259362248280455E-2,2822105.709999999]
["03. 31% to 40%","31% to 40%",null,null,4.0824645241796152E-2,{"$f":"IFERROR(VLOOKUP($A$194,'[6]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":10343781.349999994},null,null,3.9448241878709926E-2,10851269.889999997]
["04. 41% to 50%","41% to 50%",null,null,9.8364585108110886E-2,{"$f":"IFERROR(VLOOKUP($A$195,'[6]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":24922733.679999996},null,null,9.5216678447048217E-2,26191835.850000001]
["05. 51% to 60%","51% to 60%",null,null,0.14916385025826187,{"$f":"IFERROR(VLOOKUP($A$196,'[6]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":37793794.490000017},null,null,0.14652566500858785,40305713.540000044]
["06. 61% to 70%","61% to 70%",null,null,0.20322021084237957,{"$f":"IFERROR(VLOOKUP($A$197,'[6]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":51490108.840000011},null,null,0.20239168583317513,55673122.600000009]
["07. 71% to 80%","71% to 80%",null,null,0.21043635622460805,{"$f":"IFERROR(VLOOKUP($A$198,'[6]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":53318470.840000071},null,null,0.20993339359908025,57747666.420000069]
["08. 81% to 90%","81% to 90%",null,null,0.18133965338312269,{"$f":"IFERROR(VLOOKUP($A$199,'[6]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":45946210.030000038},null,null,0.1855272104837368,51034107.910000041]
["09. 91% to 100%","91% to 100%",null,null,0.10595337719629801,{"$f":"IFERROR(VLOOKUP($A$200,'[6]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":26845513.550000008},null,null,0.11045619149009198,30383862.189999998]
["> 100%","> 100%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$201,'[6]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":0},null,null,0,0]
[null,null,null,null,{"$f":"SUM(E192:E201)","v":1},{"$f":"SUM(F192:F201)","v":253371003.93000013},{"$f":"F189-F202","v":0},null,1,275076134.53000015,0]
[]
[null,"New v Used"]
["New","New",null,null,{"$f":"F205/F$208","v":0.91570720063176403},{"$f":"IFERROR(VLOOKUP($A$205,'[6]New v Used'!$A$1:$C$4,3,FALSE),0)","v":232013652.72999984},null,null,0.91515033407067681,251736016.40999943]
["USed","Used",null,null,{"$f":"F206/F$208","v":8.4292799368235971E-2},{"$f":"IFERROR(VLOOKUP($A$206,'[6]New v Used'!$A$1:$C$4,3,FALSE),0)","v":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":253371003.92999986},{"$f":"F202-F208","v":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.4017237074930688E-2},{"$f":"IFERROR(VLOOKUP($A$211,'[6]Loan Type'!$A$1:$C$4,3,FALSE),0)","v":3551561.4299999997},null,null,1.5444190486603929E-2,4248328.2200000007]
["Goods Mortgage","Goods Mortgage",null,null,{"$f":"F212/F$214","v":0.98598276292506926},{"$f":"IFERROR(VLOOKUP($A$212,'[6]Loan Type'!$A$1:$C$4,3,FALSE),0)","v":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,'[6]Loan Type'!$A$1:$C$4,3,FALSE),0)","v":0},null,null,0,0]
[null,null,null,null,{"$f":"SUM(E211:E213)","v":1},{"$f":"SUM(F211:F213)","v":253371003.92999962},{"$f":"F208-F214","v":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.99233147151859258},{"$f":"E13-F218","v":251428021.17000008},null,null,0.99224998041490398,272944289.10000008]
["Refinance - Hardship","Hardship Refinance",null,null,{"$f":"F218/F$219","v":7.6685284814074321E-3},{"$f":"VLOOKUP($A$218,[6]Source!$A$1:$C$238,3,FALSE)","v":1942982.76},null,null,7.7500195850959885E-3,2131845.4299999997]
[null,null,null,null,{"$f":"SUM(E217:E218)","v":1},{"$f":"SUM(F217:F218)","v":253371003.93000007},{"$f":"F214-F219","v":-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":9.2367592727641938E-3},{"$f":"IFERROR(VLOOKUP($A$222,'[6]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":2340326.9700000002},null,null,8.8966186549822371E-3,2447247.4700000007]
["Annual","Annual",null,null,0.72680765274497028,{"$f":"IFERROR(VLOOKUP($A$223,'[6]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":184151984.6399999},null,null,0.71388382654687721,196372403.50999993]
["Monthly","Monthly",null,null,0.19174234488734965,{"$f":"IFERROR(VLOOKUP($A$224,'[6]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":48581950.420000076},null,null,0.20092981179351313,55270995.939999983]
["Quarterly","Quarterly",null,null,1.1359311426161268E-2,{"$f":"IFERROR(VLOOKUP($A$225,'[6]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":2878120.14},null,null,1.1294773010056084E-2,3106922.4999999995]
["Semi Annual","Semi Annual",null,null,5.1788451821524091E-2,{"$f":"IFERROR(VLOOKUP($A$226,'[6]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":13121692.029999994},null,null,5.576386597917344E-2,15339308.699999997]
["Structured","Structured",null,null,9.0654798472306012E-3,{"$f":"IFERROR(VLOOKUP($A$227,'[6]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":2296929.73},null,null,9.2311040153978431E-3,2539256.4099999997]
["0% to 1%",null,null,null,{"$f":"SUM(E222:E227)","v":1.0000000000000002},{"$f":"SUM(F222:F227)","v":253371003.92999995},{"$f":"F219-F228","v":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.10783087530232213},{"$f":"IFERROR(VLOOKUP($A$231,'[6]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":27321217.13000001},null,null,0.108030019073716,29716480.059999984]
["02. 1.01% to 2%",null,null,null,7.7273867949819372E-2,{"$f":"IFERROR(VLOOKUP($A$232,'[6]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":19578957.499999993},null,null,7.5982614252275371E-2,20901003.820000008]
["03. 2.01% to 3%",null,null,null,0.22649860702235261,{"$f":"IFERROR(VLOOKUP($A$233,'[6]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":57388179.450000048},null,null,0.23112441436851131,63576810.500000119]
["04. 3.01% to 4%",null,null,null,0.22339910590415454,{"$f":"IFERROR(VLOOKUP($A$234,'[6]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":56602855.740000047},null,null,0.21787793231282171,59933019.420000009]
[null,"< 4%",null,null,{"$f":"SUM(E231:E234)","v":0.6350024561786487},{"$f":"SUM(F231:F234)","v":160891209.82000008},null,null,0.63301498000732437,174127313.80000013]
["05. 4.01% to 5%","4% to 5%",null,null,{"$f":"F236/F$245","v":0.1832869910908593},{"$f":"IFERROR(VLOOKUP($A$236,'[6]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":46439608.940000005},null,null,0.17937746589433282,49342459.940000005]
["06. 5.01% to 6%","5% to 6%",null,null,0.11610592362071315,{"$f":"IFERROR(VLOOKUP($A$237,'[6]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":29417874.430000003},null,null,0.11612764100593451,31943942.600000001]
["07. 6.01% to 7%","6% to 7%",null,null,3.9079290749211147E-2,{"$f":"IFERROR(VLOOKUP($A$238,'[6]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":9901559.1299999934},null,null,3.9109225881704818E-2,10758014.679999998]
["08. 7.01% to 8%","7% to 8%",null,null,1.7326245513132339E-2,{"$f":"IFERROR(VLOOKUP($A$239,'[6]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":4389968.2200000007},null,null,2.1410064017595442E-2,5889397.6499999994]
["09. 8.01% to 9%","8% to 9%",null,null,8.4567220272449596E-3,{"$f":"IFERROR(VLOOKUP($A$240,'[6]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":2142688.1500000008},null,null,9.6038315519948667E-3,2641784.86]
["10. 9.01% to 10%","9% to 10%",null,null,6.7482911362358553E-4,{"$f":"IFERROR(VLOOKUP($A$241,'[6]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":170982.12999999998},null,null,8.6659164528139797E-4,238378.68]
["11. 10.01% to 11%","10% to 11%",null,null,6.0229583351282267E-5,{"$f":"IFERROR(VLOOKUP($A$242,'[6]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":15260.430000000008},null,null,1.9725335348596859E-4,54259.689999999973]
["12. 11.01% to 12%","11% to 12%",null,null,7.3121232156140666E-6,{"$f":"IFERROR(VLOOKUP($A$243,'[6]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":1852.6799999999967},null,null,2.7250579236209519E-4,74959.839999999982]
["13. > 12%","> 12%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$244,'[6]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":0},null,null,2.0440849983613463E-5,5622.7900000000081]
[null,null,null,null,{"$f":"SUM(E235:E244)","v":1.0000000000000002},{"$f":"SUM(F235:F244)","v":253371003.9300001},{"$f":"F228-F245","v":0},null,0.99999999999999989,275076134.53000015,0]
[]
[null,"Top 5 Obligor",null,null,{"$f":"F247/E13","v":2.4718751091700734E-2},{"$f":"SUM('[6]Top 5 Obligor '!$E$2:$E$6)","v":6263014.7800000003},null,null,2.4580872606607657E-2,6761611.4200000018]

{"sheet":"Note Balance","index":1,"n_rows":42,"n_cols":9,"rows_kept":42,"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]

{"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",{"$f":"B4+'Collateral Tables '!E9/350000000","v":1.2563261142857142E-3},{"$f":"C4+'Collateral Tables '!E23/350000000","v":-2.4793114285714286E-5},1.2811192285714285E-3]
["2016-10-01"]
["2017-01-01"]
["2017-04-01"]
["2017-07-01"]
["2017-10-01"]
["2018-01-01"]
["2018-04-01"]
["2018-07-01"]
["2018-10-01"]