{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Metadata","Waterfall","Description_1"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"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":"Metadata","index":0,"n_rows":109,"n_cols":4,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Draft Reporting Template for Repo-Eligible Securities"]
[null,"Residential Mortgage Backed Securities"]
[]
[null,"Waterfall Template"]
[null,"Metadata"]
[]
[]
[null,"Version 1 (April 2013)"]
[]
[null,"Instructions"]
[]
[null,"The specific variables in this sample Metadata sheet are provide as an example only."]
[null,"The reported Metadata sheet should follow the requirements set out in the Waterfall Template for Repo-Eligible RMBS (available at  http://www.rba.gov.au/mkt-operations/pdf/waterfall-template-for-repo-eligible-rmbs.pdf). "]
[null,"The example in this sample assumes that the RMBS has four classes of notes/tranches A1, A2, B and C. A2 is US dollar denominated note. All others are Australian dollar denominated."]
[null,"Issuer is responsible for ensuring that the inputs and outputs in the waterfall template accurately represent the waterfall in the RMBS Information Memorandum."]
[]
[]
[]
[null,"Transaction ID (same as in Transaction Level Data Template)","enter here"]
[null,"Master Trust Name (same as in Transaction Level Data Template)","enter here"]
[null,"Series Trust Name (same as in Transaction Level Data Template)","enter here"]
[]
[null,"Variable Name","Measurement Units/Format","Description"]
[null,"Waterfall Inputs",null,"Stock variables should be reported in their state following the previous distribution date"]
[]
[null,"Template Reporting Date","DD/MM/YYYY","Date of cash flow water fall template report"]
[null,"Collection Start Date","DD/MM/YYYY","Start date for collections form the collateral pool for the relevant determination/distribution/reporting date"]
[null,"Collection End Date","DD/MM/YYYY","End date for collections form the collateral pool for the relevant determination/distribution/reporting date"]
[null,"Determination Date","DD/MM/YYYY","Date on which payments to the trust and payments by the trust are calculated and determined"]
[null,"Distribution Date","DD/MM/YYYY","Date on which payments by the trust are made on the RMBS notes"]
[null,"Accrual Factor","%","Fraction of year elapsed during the accrual period for the current template reporting date"]
[null,"3-month Bank Bill Swap Rate","% per annum","Reference rate at start of accrual period used to determine payments of coupons on RMBS notes "]
[null,"AUDUSD exchange rate","A$/US$","Exchange rate used to calculate payments to notes denominated in US dollars"]
[null,"Initial Pool Balance","A$","Collateral pool balance at RMBS issuance"]
[null,"Performing Pool Balance","A$","Collateral pool balance that is performing at the determination date"]
[null,"Non-performing Pool Balance","A$","Collateral pool balance that is non-performing at the determination date"]
[null,"Chargeoff Pool Balance","A$","Collateral pool balance that has been charged off "]
[null,"Available Income","A$","Income collections during the collection period available for distribution to note holders"]
[null,"Available Principal","A$","Principal collections available for distribution"]
[null,"Collateral Chargeoffs","A$","Chargeoffs recorded during the relevant accrual period"]
[null,"Initial Balance Class A1","A$","Balance of Class A1 notes at RMBS issuance"]
[null,"Initial Balance Class A2","A$","Balance of Class A2 notes at RMBS issuance"]
[null,"Initial Balance Class B","A$","Balance of Class B notes at RMBS issuance"]
[null,"Initial Balance Class C","A$","Balance of Class C notes at RMBS issuance"]
[null,"Opening Balance  - Liquidity Facility","A$","Outstanding amount drawn on the liquidity facility"]
[null,"Opening Balance - Principal Draw","A$","Outstanding amount of earlier principal draws (i.e. before determination date) to meet income shortfalls"]
[null,"Opening Balance - Excess Spread Account","A$","Outstanding amount of funds in excess spread facility"]
[null,"Opening Balance - Class A1","A$","Balance on Class A1 before the determination date"]
[null,"Opening Balance - Class A2","A$","Balance on Class A2 before the determination date"]
[null,"Opening Balance - Class B","A$","Balance on Class B before the determination date"]
[null,"Opening Balance - Class C","A$","Balance on Class C before the determination date"]
[null,"Opening Balance Redraw Bond","A$","Balance on redraw bonds before the determination date"]
[null,"Opening Balance - Chargeoffs on Class A1","A$","Cumulative Chargeoffs to Class A1 up to the determination date"]
[null,"Opening Balance - Chargeoffs on Class A2","A$","Cumulative Chargeoffs to Class A2 up to the determination date"]
[null,"Opening Balance - Chargeoffs on Class B","A$","Cumulative Chargeoffs to Class B up to the determination date"]
[null,"Opening Balance - Chargeoffs on Class C","A$","Cumulative Chargeoffs to Class C up to the determination date"]
[null,"Pro-rata Trigger/Condition","True/False","Indicator whether pro-rata distributions are allowed based on information before the determination date"]
[null,"Cleanup Call Trigger/Condition","True/False","Indicator whether clean up call is allowed based on information before the determination date"]
[null,"Other Trigger/Condition (specify)","True/False","Indicator whether an event (specify) has occurred before the determination date"]
[]
[]
[null,"Waterfall Outputs",null,"Stock variables should be reported after the current distribution date"]
[]
[null,"Servicer Fee","A$","Payment of servicer fees"]
[null,"Interest Swap Fee","A$","Payment of interest swap fees"]
[null,"Basis Swap Fee","A$","Payment of basis swap fees"]
[null,"Other Fees (Specify)","A$","Payment of other fees (specify)"]
[null,"Interest on Liquidity Facility","A$","Payment of interest on outstanding balance under liquidity facility"]
[null,"Liquidity Facility Repayment","A$","Repayment of due balance on liquidity facility"]
[null,"Liquidity Facility Advance","A$","New advance under the liquidity facility"]
[null,"Closing Balance - Liquidity Facility","A$","Outstanding amount drawn on the liquidity facility"]
[null,"Principal Draw","A$","Draw from the available principal to meet shortfall in available income"]
[null,"Principal Draw Repayment","A$","Repayment of earlier principal draws"]
[null,"Closing Balance Principal Draw","A$","Outstanding amount of principal draws after the repayments and new draws"]
[null,"Coupon - Class A1","A$","Payment of coupon/interest on Class A1 notes"]
[null,"Coupon - Class A2","A$","Payment of coupon/interest on Class A2 notes"]
[null,"Coupon - Class B","A$","Payment of coupon/interest on Class B notes"]
[null,"Coupon - Class C","A$","Payment of coupon/interest on Class C notes"]
[null,"Coupon - Redraw Bonds","A$","Payment of coupon/interest on redraw bonds"]
[null,"Excess Spread Accumulation","A$","Payment of excess spread into the excess spread account"]
[null,"Income Unit Holder Payment","A$","Payment of residual available income to the income unit holder"]
[null,"Chargeoffs Reimbursement - Class A1","A$","Reimbursement of previous Chargeoffs to Class A1 notes"]
[null,"Chargeoffs Reimbursement - Class A2","A$","Reimbursement of previous Chargeoffs to Class A2 notes"]
[null,"Chargeoffs Reimbursement - Class B","A$","Reimbursement of previous Chargeoffs to Class B notes"]
[null,"Chargeoffs Reimbursement - Class C","A$","Reimbursement of previous Chargeoffs to Class C notes"]
[null,"Principal Payment - Class A1","A$","Payment of principal to Class A1 notes"]
[null,"Principal Payment - Class A2","A$","Payment of principal to Class A2 notes"]
[null,"Principal Payment - Class B","A$","Payment of principal to Class B notes"]
[null,"Principal Payment - Class C","A$","Payment of principal to Class C notes"]
[null,"Principal Payment - Redraw Bonds","A$","Payment of principal to redraw bonds"]
[null,"Chargeoffs - Class A1","A$","New Chargeoffs to Class A1 notes"]
[null,"Chargeoffs - Class A2","A$","New Chargeoffs to Class A2 notes"]
[null,"Chargeoffs - Class B","A$","New Chargeoffs to Class B notes"]
[null,"Chargeoffs - Class C","A$","New Chargeoffs to Class C notes"]
[null,"Chargeoffs   - Redraw Bonds","A$","New Chargeoffs to redraw bonds"]
[null,"Closing Balance - Class A1","A$","Principal outstanding on Class A1 notes after principal payments, charge off reimbursements and new Chargeoffs"]
[null,"Closing Balance - Class A2","A$","Principal outstanding on Class A2 notes after principal payments, charge off reimbursements and new Chargeoffs"]
[null,"Closing Balance - Class B","A$","Principal outstanding on Class B notes after principal payments, charge off reimbursements and new Chargeoffs"]
[null,"Closing Balance - Class C","A$","Principal outstanding on Class C notes after principal payments, charge off reimbursements and new Chargeoffs"]
[null,"Closing Balance - Redraw Bonds","A$","Principal outstanding on redraw after principal payments, charge off reimbursements and new Chargeoffs"]
[null,"Closing Balance - Chargeoffs on Class A1","A$","Cumulative Chargeoffs on Class A1 notes after charge off reimbursements and new Chargeoffs"]
[null,"Closing Balance - Chargeoffs on Class A2","A$","Cumulative Chargeoffs on Class A2 notes after charge off reimbursements and new Chargeoffs"]
[null,"Closing Balance - Chargeoffs on Class B","A$","Cumulative Chargeoffs on Class B notes after charge off reimbursements and new Chargeoffs"]
[null,"Closing Balance - Chargeoffs on Class C","A$","Cumulative Chargeoffs on Class C notes after charge off reimbursements and new Chargeoffs"]
[null,"Closing Balance - Redraw Bonds","A$","Cumulative Chargeoffs on redraw bonds after principal payments, charge off reimbursements and new Chargeoffs"]
[null,"Pro-rata Trigger","True/False","Indicator whether pro-rata distributions are allowed based on after the distribution date"]
[null,"Cleanup Call Trigger/Condition","True/False","Indicator whether clean-up call is allowed based on information after the distribution date"]
[null,"Other Trigger","True/False","Indicator whether an event (specify) has occurred after the determination date"]

{"sheet":"Waterfall","index":1,"n_rows":116,"n_cols":174,"rows_kept":116,"cut":false,"hidden":false,"merged":[[19,1,21,1],[28,2,28,34],[28,36,28,81],[28,82,28,108],[28,128,28,173],[19,2,19,6],[20,2,20,6],[21,2,21,6]]}
[]
[null,"Draft Reporting Template for Repo-Eligible Securities"]
[null,"Residential Mortgage Backed Securities"]
[]
[null,"Waterfall Template"]
[null,"Waterfall"]
[]
[]
[null,"Version 1 (April 2013)"]
[]
[null,"Instructions"]
[]
[null,"The specific variables in this sample Waterfall sheet are provide as an example only."]
[null,"The reported Waterfall sheet should follow the requirements set out in the Waterfall Template for Repo-Eligible RMBS (available at http://www.rba.gov.au/mkt-operations/pdf/waterfall-template-for-repo-eligible-rmbs.pdf). "]
[null,"The example in this sample assumes that the RMBS has four classes of notes/tranches A1, A2, B and C. A2 is US dollar denominated note. All others are Australian dollar denominated."]
[null,"Issuer is responsible for ensuring that the inputs and outputs in the waterfall template accurately represent the waterfall in the RMBS Information Memorandum."]
[]
[]
[]
[null,"Transaction Identifiers","Transaction ID (same as in Transaction Level Data Template)",null,null,null,null,"enter here"]
[null,null,"Master Trust Name (same as in Transaction Level Data Template)",null,null,null,null,"enter here"]
[null,null,"Series Trust Name (same as 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,null,null,null,null,"Summary of Discrepancy between Waterfall Program Output and Actual Distributions to RMBS 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,null,null,null,null,"(Discrepancy as per cent of actual; averages reported since issuance of RMBS; 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,"Link: Summary of Discrepancy between Waterfall Program Output and Actual Distributions to RMBS 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,null,null,"Variable","Servicer Fee","Interest Swap Fee","Basis Swap Fee","Other Fees (Specify)","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 Note A2","Coupon Payment to Note B","Coupon Payment to Note C","Coupon Payment to Redraw Bonds","Cash Flow to Excess Spread Account","Closing Balance of Excess Spread Account","Income Unit Holder Payment","Chargeoffs Reimbursement to Note A1","Chargeoffs Reimbursement to Note A2","Chargeoffs Reimbursement to Note B","Chargeoffs Reimbursement to Note C","Principal Payment - Note A1","Principal Payment - Note A2","Principal Payment - Note B","Principal Payment - Note C","Principal Payment - Redraw Bonds","Chargeoffs - Note A1","Chargeoffs - Note A2","Chargeoffs - Note B","Chargeoffs - Note C","Chargeoffs - Redraw Bonds","Closing Balance on Note A1","Closing Balance on Note A2","Closing Balance on Note B","Closing Balance on Note C","Closing Balance on Redraw Bonds","Closing Balance - Chargeoffs on Note A1","Closing Balance - Chargeoffs on Note A2","Closing Balance - Chargeoffs on Note B","Closing Balance - Chargeoffs on Note C","Closing Balance - Chargeoffs on Redraw Notes","Pro-rata Payment Trigger","Clean-up Trigger","Other Trigger (Specify)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,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,null,null,null,null,null,null,null,null,null,"Not required to report","Not required to report","Not required to report"]
[]
[null,null,"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,"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,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,null,null,null,null,null,null,null,"Discrepancy Between Waterfall Program Outputs and Actual Distributions (program output less actual)"]
[null,null,"Collection Start Date","Collection End Date","Determination Date","Distribution Date","Accrual Factor","3-month Bank Bill Swap Rate","Currency Exchange Rate -USD","Initial Pool Balance","Performing Pool Balance","Non-Performing Pool Balance","Chargeoff Pool Balance","Available Income","Available Principal","Collateral Chargeoffs","Initial Balance Note A1","Initial Balance Note A2","Initial Balance Note B","Initial Balance Note C","Opening Balance - Liquidity Facility","Opening Balance - Principal Draw Facility","Opening Balance - Excess Spread Account","Opening Balance Note A1","Opening Balance Note A2","Opening Balance Note B","Opening Balance Note C","Opening Balance Redraw Bond","Opening Balance - Chargeoffs on Note A1","Opening Balance - Chargeoffs on Note A2","Opening Balance - Chargeoffs on Note B","Opening Balance - Chargeoffs on Note C","Clean-up Trigger","Pro-rata Payment Trigger","Other Trigger/Condition (Specify)","Version of the waterfall program used","Servicer Fee","Interest Swap Fee","Basis Swap Fee","Other Fees (Specify)","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 Note A2","Coupon Payment to Note B","Coupon Payment to Note C","Coupon Payment to Redraw Bonds","Cash Flow to Excess Spread Account","Closing Balance of Excess Spread Account","Income Unit Holder Payment","Chargeoffs Reimbursement to Note A1","Chargeoffs Reimbursement to Note A2","Chargeoffs Reimbursement to Note B","Chargeoffs Reimbursement to Note C","Principal Payment - Note A1","Principal Payment - Note A2","Principal Payment - Note B","Principal Payment - Note C","Principal Payment - Redraw Bonds","Chargeoffs - Note A1","Chargeoffs - Note A2","Chargeoffs - Note B","Chargeoffs - Note C","Chargeoffs - Redraw Bonds","Closing Balance on Note A1","Closing Balance on Note A2","Closing Balance on Note B","Closing Balance on Note C","Closing Balance on Redraw Bonds","Closing Balance - Chargeoffs on Note A1","Closing Balance - Chargeoffs on Note A2","Closing Balance - Chargeoffs on Note B","Closing Balance - Chargeoffs on Note C","Closing Balance - Chargeoffs on Redraw Notes","Pro-rata Payment Trigger","Clean-up Trigger","Other Trigger (Specify)","Servicer Fee","Interest Swap Fee","Basis Swap Fee","Other Fees (Specify)","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 Note A2","Coupon Payment to Note B","Coupon Payment to Note C","Coupon Payment to Redraw Bonds","Cash Flow to Excess Spread Account","Closing Balance of Excess Spread Account","Income Unit Holder Payment","Chargeoffs Reimbursement to Note A1","Chargeoffs Reimbursement to Note A2","Chargeoffs Reimbursement to Note B","Chargeoffs Reimbursement to Note C","Principal Payment - Note A1","Principal Payment - Note A2","Principal Payment - Note B","Principal Payment - Note C","Principal Payment - Redraw Bonds","Chargeoffs - Note A1","Chargeoffs - Note A2","Chargeoffs - Note B","Chargeoffs - Note C","Chargeoffs - Redraw Bonds","Closing Balance on Note A1","Closing Balance on Note A2","Closing Balance on Note B","Closing Balance on Note C","Closing Balance on Redraw Bonds","Closing Balance - Chargeoffs on Note A1","Closing Balance - Chargeoffs on Note A2","Closing Balance - Chargeoffs on Note B","Closing Balance - Chargeoffs on Note C","Closing Balance - Chargeoffs on Redraw Notes","Pro-rata Payment Trigger","Clean-up Trigger","Other Trigger (Specify)","Servicer Fee","Interest Swap Fee","Basis Swap Fee","Other Fees (Specify)","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 Note A2","Coupon Payment to Note B","Coupon Payment to Note C","Coupon Payment to Redraw Bonds","Cash Flow to Excess Spread Account","Closing Balance of Excess Spread Account","Income Unit Holder Payment","Chargeoffs Reimbursement to Note A1","Chargeoffs Reimbursement to Note A2","Chargeoffs Reimbursement to Note B","Chargeoffs Reimbursement to Note C","Principal Payment - Note A1","Principal Payment - Note A2","Principal Payment - Note B","Principal Payment - Note C","Principal Payment - Redraw Bonds","Chargeoffs - Note A1","Chargeoffs - Note A2","Chargeoffs - Note B","Chargeoffs - Note C","Chargeoffs - Redraw Bonds","Closing Balance on Note A1","Closing Balance on Note A2","Closing Balance on Note B","Closing Balance on Note C","Closing Balance on Redraw Bonds","Closing Balance - Chargeoffs on Note A1","Closing Balance - Chargeoffs on Note A2","Closing Balance - Chargeoffs on Note B","Closing Balance - Chargeoffs on Note C","Closing Balance - Chargeoffs on Redraw Notes","Pro-rata Payment Trigger","Clean-up Trigger","Other Trigger (Specify)"]
[null,"Reporting Date","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","%","%","A$/US$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","True/False","True/False","True/False","waterfall_verison","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$",null,"A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","True/False","True/False","True/False","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$",null,"A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","True/False","True/False","True/False","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$",null,"A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","A$","True/False","True/False","True/False"]
[null,"2011-06-30",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,{"$f":"EOMONTH(B32,1)","v":"2011-07-31"},null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,{"$f":"EOMONTH(B33,1)","v":"2011-08-31"},null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2011-09-30",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2011-10-31",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2011-11-30",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2011-12-31",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2012-01-31",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2012-02-29",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2012-03-31",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2012-04-30",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2012-05-31",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2012-06-30",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2012-07-31",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2012-08-31",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2012-09-30",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2012-10-31",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2012-11-30",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2012-12-31",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2013-01-31",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2013-02-28",null,null,null,null,null,null,null,null,null,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_1","={waterfall_1(relevant input varibales in columns B to AH)}"]
[null,"2013-03-31"]
[null,"2013-04-30"]
[null,"2013-05-31"]
[null,"2013-06-30"]
[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"]
[null,"2014-08-31"]
[null,"2014-09-30"]
[null,"2014-10-31"]
[null,"2014-11-30"]
[null,"2014-12-31"]
[null,"2015-01-31"]
[null,"2015-02-28"]
[null,"2015-03-31"]
[null,"2015-04-30"]
[null,"2015-05-31"]
[null,"2015-06-30"]
[null,"2015-07-31"]
[null,"2015-08-31"]
[null,"2015-09-30"]
[null,"2015-10-31"]
[null,"2015-11-30"]
[null,"2015-12-31"]
[null,"2016-01-31"]
[null,"2016-02-29"]
[null,"2016-03-31"]
[null,"2016-04-30"]
[null,"2016-05-31"]
[null,"2016-06-30"]
[null,"2016-07-31"]
[null,"2016-08-31"]
[null,"2016-09-30"]
[null,"2016-10-31"]
[null,"2016-11-30"]
[null,{"$f":"EOMONTH(B97,1)","v":"2016-12-31"}]
[null,"2017-01-31"]
[null,"2017-02-28"]
[null,"2017-03-31"]
[null,"2017-04-30"]
[null,"2017-05-31"]
[null,"2017-06-30"]
[null,"2017-07-31"]
[null,"2017-08-31"]
[null,"2017-09-30"]
[null,"2017-10-31"]
[null,"2017-11-30"]
[null,"2017-12-31"]
[null,"2018-01-31"]
[null,"2018-02-28"]
[null,"2018-03-31"]
[null,"2018-04-30"]
[null,"2018-05-31"]
[null,"2018-06-30"]

{"sheet":"Description_1","index":2,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[26,1,28,1],[26,2,26,6],[27,2,27,6],[28,2,28,6],[30,2,30,6]]}
[]
[null,"Draft Reporting Template for Repo-Eligible Securities"]
[null,"Residential Mortgage Backed Securities"]
[]
[null,"Waterfall Template"]
[null,"Description"]
[]
[]
[null,"Version 1 (April 2013)"]
[]
[null,"Instructions"]
[]
[]
[null,"The reported Waterfall sheet should follow the requirements set out in the Waterfall Template for Repo-Eligible RMBS (available at http://www.rba.gov.au/mkt-operations/pdf/waterfall-template-for-repo-eligible-rmbs.pdf). "]
[null,"Report a Description sheet for each revision of the waterfall program. Retain old description sheets."]
[null,"Issuer is responsible for ensuring that the inputs and outputs in the waterfall template accurately represent the waterfall in the RMBS Information Memorandum."]
[null,"The Description sheet should:"]
[]
[null,"1. Provide a plain English description of the waterfall as per Information Memorandum"]
[null,"2. Provide a diagrammatic representation of the waterfall"]
[null,"3. Provide statement from an external auditor attesting the validity of the waterfall program"]
[null,"4. If waterfall program has changed, describe the reason for the change"]
[]
[]
[]
[]
[null,"Transaction Identifiers","Transaction ID (same as in Transaction Level Data Template)",null,null,null,null,"enter here"]
[null,null,"Master Trust Name (same as in Transaction Level Data Template)",null,null,null,null,"enter here"]
[null,null,"Series Trust Name (same as 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. Provide a diagrammatic representation of the waterfall"]
[]
[null,null,"…"]
[]
[null,null,"3. Provide a statement from an external auditor attesting the validity of the waterfall program"]
[]
[null,null,"…"]
[]
[null,null,"4. If waterfall program has changed, describe the reason for the change"]
[]
[null,null,"…"]