{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Waterfall","Description_1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Waterfall","index":0,"n_rows":49,"n_cols":163,"rows_kept":49,"cut":false,"hidden":false,"merged":[[20,1,22,1],[21,2,21,6],[21,9,21,10],[22,2,22,6],[22,9,22,10],[29,2,29,42],[29,46,29,82],[29,85,29,119],[29,124,29,162],[20,2,20,7],[20,9,20,10]]}
[]
[null,"Reporting Template for Repo-Eligible Securities"]
[null,"Asset Backed Securities"]
[]
[null,"Waterfall Template"]
[null,"Waterfall"]
[]
[]
[null,"Version 3 (August 2014)"]
[]
[null,"Instructions"]
[]
[null,"The specific variables in this sample Waterfall sheet are provide as an example only. This is not an exhaustive list of model variables."]
[null,"The reported Waterfall sheet should follow the requirements set out in the The Cash Flow Waterfall Reporting Template for Repo-Eligible Asset Backed  Securities (available at http://www.rba.gov.au/mkt-operations/pdf/cash-flow-waterfall-template-for-repo-eligible-abs.pdf). "]
[null,"The information provider is responsible for ensuring that the inputs and outputs in the waterfall template accurately represent the waterfall in the ABS Information Memorandum and other relevant documents."]
[]
[]
[]
[]
[]
[null,null,"Transaction Identifiers"]
[null,null,"Master Trust Name or SPV (same as RT003 in Transaction Level Data Template)",null,null,null,null,"enter here"]
[null,null,"Series Trust Name or Series (same as RT004 in Transaction Level Data Template)",null,null,null,null,"enter here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary of Discrepancy between Waterfall Program Output and Actual Distributions to ABS Note Holders and Service Providers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Discrepancy as per cent of actual; averages reported since issuance of ABS; this summary is a key input of the validation of the Waterfall Template and the RBA reserves the right to further review the reported waterfall beyond this summary)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable","Senior Fees and Expenses Paid","Interest on Liquidity Facility","Liquidity Facility Repayment","Liquidity Facility Advance","Closing Balance - Liquidity Facility","Principal Draw","Principal Draw Repayment","Closing Balance Principal Draw","Coupon Payment to Note A1","Coupon Payment to Next Note Class","…","Unpaid Coupon on Note A1","Unpaid Coupon on Next Note Class","…","Closing Unpaid Coupon on Note A1","Closing Unpaid Coupon on Next Note Class","…","Excess Spread Accumulation","Income Unit Holder Payment","Chargeoffs Reimbursement to Note A1","Chargeoffs Reimbursement on Next Note Class","…","Principal Payment - Note A1","Principal Payment - Next Note Class","…","Chargeoffs - Note A1","Chargeoffs - Next Note Class","…","Closing Balance on Note A1","Closing Balance on Next Note Class","…","Closing Balance - Chargeoffs on Note A1","Closing Balance - Chargeoffs on Next Note Class","…","Pro-rata Payment Trigger","Clean-up Trigger","Other Trigger (Specify)","Other required output variables","…"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Units","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Simple Average of Discrepancies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not required to report","Not required to report","Not required to report"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Simple Average of Absolute Deviations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not required to report","Not required to report","Not required to report"]
[]
[null,"<DATA>","Waterfall Program Inputs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waterfall program","Waterfall Program Outputs (as produced by the waterfall function used for the reporting period)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual Distribution of Income, Principal and Losses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Discrepancy Between Waterfall Program Outputs and Actual Distributions (program output less actual)"]
[null,"Variable Name","Collection Start Date","Collection End Date","Determination Date","Distribution Date","Accrual Period","3-month Bank Bill Swap Rate","Initial Pool Balance","Performing Pool Balance","Non-Performing Pool Balance","Customer Redraws","Chargeoff Pool Balance","Available Income","Available Principal","Collateral Chargeoffs","Initial Balance Note A1","Initial Balance of Next Note Class","…","Opening Balance - Liquidity Facility","Opening Balance - Principal Draw Facility","Opening Balance - Excess Spread Account","Opening Balance of Next Note Facility","…","Opening Balance Note A1","Opening Balance of Next Note Class","…","Opening Balance - Chargeoffs on Note A1","Opening Balance - Chargeoffs on Next Note Class","…","Expenses Due","Liquidity Facility Interest Rate","Redraw Facility Interest Rate","Interest Margin - Class A1","Interest Margin - Next Note Class","…","Opening Unpaid Coupons - Class A1","Opening Unpaid Coupons - Next Note Class","…","Clean-up Trigger","Pro-rata Payment Trigger","Default Trigger","Other Trigger/Condition (Specify)","Other required input variables","…","Version of the waterfall program used","Senior Fees and Expenses Paid","Interest on Liquidity Facility","Liquidity Facility Repayment","Liquidity Facility Advance","Closing Balance - Liquidity Facility","Principal Draw","Principal Draw Repayment","Closing Balance Principal Draw","Coupon Payment to Note A1","Coupon Payment to Next Note Class","…","Unpaid Coupon on Note A1","Unpaid Coupon on Next Note Class","…","Closing Unpaid Coupon on Note A1","Closing Unpaid Coupon on Next Note Class","…","Excess Spread Accumulation","Income Unit Holder Payment","Chargeoffs Reimbursement to Note A1","Chargeoffs Reimbursement on Next Note Class","…","Principal Payment - Note A1","Principal Payment - Next Note Class","…","Chargeoffs - Note A1","Chargeoffs - Next Note Class","…","Closing Balance on Note A1","Closing Balance on Next Note Class","…","Closing Balance - Chargeoffs on Note A1","Closing Balance - Chargeoffs on Next Note Class","…","Pro-rata Payment Trigger","Clean-up Trigger","Other Trigger (Specify)","Other required output variables","…","Senior Fees and Expenses Paid","Interest on Liquidity Facility","Liquidity Facility Repayment","Liquidity Facility Advance","Closing Balance - Liquidity Facility","Principal Draw","Principal Draw Repayment","Closing Balance Principal Draw","Coupon Payment to Note A1","Coupon Payment to Next Note Class","…","Unpaid Coupon on Note A1","Unpaid Coupon on Next Note Class","…","Closing Unpaid Coupon on Note A1","Closing Unpaid Coupon on Next Note Class","…","Excess Spread Accumulation","Income Unit Holder Payment","Chargeoffs Reimbursement to Note A1","Chargeoffs Reimbursement on Next Note Class","…","Principal Payment - Note A1","Principal Payment - Next Note Class","…","Chargeoffs - Note A1","Chargeoffs - Next Note Class","…","Closing Balance on Note A1","Closing Balance on Next Note Class","…","Closing Balance - Chargeoffs on Note A1","Closing Balance - Chargeoffs on Next Note Class","…","Pro-rata Payment Trigger","Clean-up Trigger","Other Trigger (Specify)","Other required output variables","…","Senior Fees and Expenses Paid","Interest on Liquidity Facility","Liquidity Facility Repayment","Liquidity Facility Advance","Closing Balance - Liquidity Facility","Principal Draw","Principal Draw Repayment","Closing Balance Principal Draw","Coupon Payment to Note A1","Coupon Payment to Next Note Class","…","Unpaid Coupon on Note A1","Unpaid Coupon on Next Note Class","…","Closing Unpaid Coupon on Note A1","Closing Unpaid Coupon on Next Note Class","…","Excess Spread Accumulation","Income Unit Holder Payment","Chargeoffs Reimbursement to Note A1","Chargeoffs Reimbursement on Next Note Class","…","Principal Payment - Note A1","Principal Payment - Next Note Class","…","Chargeoffs - Note A1","Chargeoffs - Next Note Class","…","Closing Balance on Note A1","Closing Balance on Next Note Class","…","Closing Balance - Chargeoffs on Note A1","Closing Balance - Chargeoffs on Next Note Class","…","Pro-rata Payment Trigger","Clean-up Trigger","Other Trigger (Specify)","Other required output variables","…"]
[null,"Data Type"]
[null,"Reported Value Type (one of AV, RV, NR)"]
[null,"Currency (if applicable)"]
[null,"Description"]
[null,"REPORT DATE","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","INPUT","MODEL VERSION","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","OUTPUT","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISTRIBUTION","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY","DISCREPANCY NR","DISCREPANCY NR","DISCREPANCY NR","DISCREPANCY","DISCREPANCY"]
[null,"2013-07-31"]
[null,"2013-08-31"]
[null,"2013-09-30"]
[null,"2013-10-31"]
[null,"2013-11-30"]
[null,"2013-12-31"]
[null,"2014-01-31"]
[null,"2014-02-28"]
[null,"2014-03-31"]
[null,"2014-04-30"]
[null,"2014-05-31"]
[null,"2014-06-30"]
[null,"2014-07-31"]

{"sheet":"Description_1","index":1,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,2,31,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[28,1,29,1]]}
[]
[null,"Reporting Template for Repo-Eligible Securities"]
[null,"Asset Backed Securities"]
[]
[null,"Waterfall Template"]
[null,"Description"]
[]
[]
[null,"Version 3 (August 2014)"]
[]
[null,"Instructions"]
[]
[]
[null,"The reported Description sheet should follow the requirements set out in the The Cash Flow Waterfall Reporting Template for Repo-Eligible Asset Backed  Securities (available at http://www.rba.gov.au/mkt-operations/pdf/cash-flow-waterfall-template-for-repo-eligible-abs.pdf). "]
[null,"Report a Description sheet for each revision of the waterfall program. Retain old description sheets."]
[null,"The information provider is responsible for ensuring that the inputs and outputs in the waterfall template accurately represent the waterfall in the ABS Information Memorandum and other relevant documents."]
[null,"The Description sheet should:"]
[]
[null,"1. Provide a plain English description of the waterfall as per Information Memorandum and other relevant documents."]
[null,"2. If waterfall program has changed, describe the reason for the change"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Transaction Identifiers","Master Trust Name or SPV (same as RT003 in Transaction Level Data Template)",null,null,null,null,"enter here"]
[null,null,"Series Trust Name (same as RT004 in Transaction Level Data Template)",null,null,null,null,"enter here"]
[]
[null,null,"Version of the waterfall program described here",null,null,null,null,"enter here"]
[]
[]
[null,null,"1. Provide a plain English description of the waterfall as per Information memorandum"]
[]
[null,null,"…"]
[]
[null,null,"2. If waterfall program has changed, describe the reason for the change"]
[]
[null,null,"…"]