{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Payment Plan Calculator","Payment Plan Contract"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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":"Payment Plan Calculator","index":0,"n_rows":115,"n_cols":28,"rows_kept":115,"cut":false,"hidden":false,"merged":[[57,7,57,8],[56,7,56,8],[57,5,57,6],[56,5,56,6],[98,16,98,17],[96,16,96,17],[97,16,97,17],[39,0,39,1],[29,5,29,8],[30,5,30,6],[30,7,30,8],[31,5,31,6],[95,16,95,17],[94,16,94,17],[93,16,93,17],[92,16,92,17],[91,16,91,17],[31,7,31,8],[38,5,38,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[38,0,38,1],[17,0,17,1],[31,0,31,1],[30,0,30,1],[29,0,29,1],[18,0,18,1],[22,0,22,1],[32,0,32,1],[20,0,20,1],[21,0,21,1],[26,0,26,1],[36,0,36,1],[24,0,24,3],[34,0,34,3],[27,0,27,1],[8,0,8,1],[16,0,16,1],[9,0,9,1],[13,0,13,1],[8,5,9,8],[10,5,27,8],[10,0,10,3],[12,0,12,1],[14,0,14,1],[54,5,54,6],[55,5,55,6],[53,5,53,6],[51,5,51,6],[52,5,52,6],[55,7,55,8],[51,7,51,8],[52,7,52,8],[53,7,53,8],[47,7,47,8],[48,7,48,8],[49,7,49,8],[50,7,50,8],[54,7,54,8],[39,7,39,8],[40,7,40,8],[37,5,37,6],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[39,5,39,6],[40,5,40,6],[36,5,36,6],[38,7,38,8],[50,5,50,6],[41,7,41,8],[42,7,42,8],[43,7,43,8],[44,7,44,8],[43,5,43,6],[45,7,45,8],[45,5,45,6],[46,5,46,6],[46,7,46,8],[1,0,6,9],[41,5,41,6],[42,5,42,6],[64,0,64,1],[64,7,64,9],[63,8,63,9],[44,5,44,6],[59,7,59,8],[60,7,60,8],[58,7,58,8],[59,5,59,6],[58,5,58,6],[60,5,60,6],[47,5,47,6],[48,5,48,6],[49,5,49,6]]}
[]
["Payment Plan Calculator"]
[]
[]
[]
[]
[]
[]
["Enrolment date (DD/MM/YYYY)",null,null,null,null,"TAFE Queensland - Payment Plan Requirements"]
[]
["Course Details",null,null,null,null,"Approval\nThe criteria for a standard Payment Plan arrangement are:\n• Adequate identification is provided to verify address; \n• Students under 18 years of age must have a parent/guardian complete the guarantor declaration; \n• The student does not have a written-off debt with TAFE Queensland;\n• The student does not have previous Payment Plan instalments currently outstanding; and\n• The total Payment Plan arrangement must be completed at least 30 days prior to COS.\n\nPayment Plan \nPayment Plan can be offered if the program duration is a minimum of 6 weeks and the total cost of enrolment is over $500.\n\nAll other enrolment-related fees are to be included in the total cost of enrolment."]
[]
["Start of Study date (DD/MM/YYYY)"]
["Close of Study date (DD/MM/YYYY)"]
["Course duration (weeks)",null,null,{"$f":"IF(OR(D13=\"\",D14=\"\"),\"\",ROUNDDOWN(DAYS360(D13,D14,0)/7,0))","v":""}]
[]
["Total cost of enrolment"]
["Deposit paid (optional)"]
["Remaining balance",null,null,{"$f":"(IF(D17<500,\"\",D17-D18))","v":""}]
[]
["Maximum number of repayments available",null,null,{"$f":"IF(OR(D14=\"\",COUNT(V86:V115)=0),\"\",COUNT(V86:V115))","v":""}]
["Selected number of repayments"]
["Amount to pay per instalment",null,null,{"$f":"IFERROR(D19/(MIN(D21:D22)),\"\")","v":""}]
[]
["Applicant Income Details"]
[]
["Has the applicant been declared bankrupt in the past 7 years?"]
["Has the applicant had a judgement against them in the past 5 years?"]
[]
["Total fortnightly income",null,null,null,null,"Repayment Schedule"]
["Total fortnightly expenditure",null,null,null,null,"Amount Due",null,"Date Due"]
["Net fortnightly disposable income",null,null,{"$f":"D30-D31","v":0},null,{"$f":"IF(OR($D$37=\"INELIGIBLE\",$D$37=\"PENDING\"),\"\",IF((COUNTBLANK(H32)=0),(($D$19/COUNT($H$32:$H$61))-(IF($AB$90=\"\",0,$AB$90)))+$AB$91,\"\"))","v":""},null,{"$f":"IF(OR($D$37=\"INELIGIBLE\",$D$37=\"PENDING\"),\"\",W86)","v":""}]
["Net disposable income minus remaining balance ",null,null,{"$f":"IF(OR(D23=\"\",D30=\"\",D31=\"\"),\"\",D32-D23)","v":""},null,{"$f":"IF(OR($D$37=\"INELIGIBLE\",$D$37=\"PENDING\"),\"\",IF((COUNTBLANK(H33)=0),(($D$19/COUNT($H$32:$H$61))-(IF($AB$90=\"\",0,$AB$90))),\"\"))","v":""},null,""]
[null,null,null,null,null,"",null,""]
["Eligibility",null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
["Payment Plan eligibility",null,null,{"$f":"IF(AND(S98>0,S98>S99),\"INELIGIBLE\",IF(OR(AND(S98=0,S99=0),AND(S98>0,S98=S99,S98<5)),\"PENDING\",IF(AND(S98>0,S98=5,S99=5),\"ELIGIBLE\")))","v":"PENDING"},null,"",null,""]
[null,null,null,null,null,"",null,""]
["First Direct Debit due",null,null,{"$f":"IF((COUNTBLANK(F32:G61)=60),\"\",MIN(W86:W115))","v":""},null,"",null,""]
["Last Direct Debit due",null,null,{"$f":"IF((COUNTBLANK(F32:G61)=60),\"\",MAX(W86:W115))","v":""},null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,{"$f":"IF(OR($D$37=\"INELIGIBLE\",$D$37=\"PENDING\"),\"\",W108)","v":""}]
[null,null,null,null,null,{"$f":"IF(OR($D$37=\"INELIGIBLE\",$D$37=\"PENDING\"),\"\",IF((COUNTBLANK(H55)=0),(($D$19/COUNT($H$32:$H$61))-(IF($AB$90=\"\",0,$AB$90))),\"\"))","v":""},null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,{"$f":"IF(OR($D$37=\"INELIGIBLE\",$D$37=\"PENDING\"),\"\",IF((COUNTBLANK(H61)=0),(($D$19/COUNT($H$32:$H$61))-(IF($AB$90=\"\",0,$AB$90))),\"\"))","v":""},null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start","End","Repayments","Calc","Repayment","Values","Display",null,"Amt Due",null,null,"Remainder Working"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D9=\"\",\"\",D9)","v":""},{"$f":"IF((COUNTBLANK(D14)=1),\"\",D14-30)","v":""},{"$f":"IF(D22=\"\",D21,IF((COUNTA(V86:V115))>=D22,D22,\"\"))","v":""},null,{"$f":"IFERROR(Q86+14,\"\")","v":""},{"$f":"IF(U86>$R$86,\"\",U86)","v":""},{"$f":"IF((COUNT(V86)<=$S$86),V86,\"\")","v":""},null,{"$f":"IF(OR($D$37=\"INELIGIBLE\",$D$37=\"PENDING\"),\"\",IF((COUNTBLANK(H32)=0),$D$19/COUNT($H$32:$H$61),\"\"))","v":""},null,"13 Decimal Places",{"$f":"IFERROR(D19/S86,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bankrupt/Judgement",null,{"$f":"IF((COUNTBLANK(V86)=0),V86,\"\")","v":""},{"$f":"IF(T87=\"\",\"\",T87+14)","v":""},{"$f":"IF(U87>$R$86,\"\",U87)","v":""},{"$f":"IF((COUNT($V$86:V87)<=$S$86),V87,\"\")","v":""},null,{"$f":"IF(OR($D$37=\"INELIGIBLE\",$D$37=\"PENDING\"),\"\",IF((COUNTBLANK(H33)=0),$D$19/COUNT($H$32:$H$61),\"\"))","v":""},null,"Cent Amount",{"$f":"IFERROR(AB86-MID(AB86,1,3),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(T88=\"\",\"\",T88+14)","v":""},{"$f":"IF(U88>$R$86,\"\",U88)","v":""},{"$f":"IF((COUNT($V$86:V88)<=$S$86),V88,\"\")","v":""},null,"",null,"Places to <.00",{"$f":"IFERROR(IF(AB87>0,(SEARCH(\".\",AB86,1)+2),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"",{"$f":"IF(T89=\"\",\"\",T89+14)","v":""},"",{"$f":"IF((COUNT($V$86:V89)<=$S$86),V89,\"\")","v":""},null,"",null,"Whole Amount",{"$f":"IF(AB88=\"\",\"\",(MID(AB86,1,AB88)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No",null,"",{"$f":"IF(T90=\"\",\"\",T90+14)","v":""},"",{"$f":"IF((COUNT($V$86:V90)<=$S$86),V90,\"\")","v":""},null,"",null,"Difference",{"$f":"IF(AB89=\"\",\"\",AB86-AB89)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(U91>$R$86,\"\",U91)","v":""},{"$f":"IF((COUNT($V$86:V91)<=$S$86),V91,\"\")","v":""},null,"",null,"Remainder",{"$f":"IF(AB90=\"\",0,AB90*S86)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Criteria",null,null,"","","",{"$f":"IF((COUNT($V$86:V92)<=$S$86),V92,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Course Duration",null,{"$f":"IF(D15=\"\",\"\",IF(D15>=6,\"Yes\",\"No\"))","v":""},"","","",{"$f":"IF((COUNT($V$86:V93)<=$S$86),V93,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of Enrolment",null,{"$f":"IF(D17=\"\",\"\",IF(D17>=500,\"Yes\",\"No\"))","v":""},"","","",{"$f":"IF((COUNT($V$86:V94)<=$S$86),V94,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bankrupt",null,{"$f":"IF(D27=\"\",\"\",IF(D27=\"No\",\"Yes\",\"No\"))","v":""},{"$f":"IF((COUNTBLANK(V94)=0),V94,\"\")","v":""},"","",{"$f":"IF((COUNT($V$86:V95)<=$S$86),V95,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Judgement",null,{"$f":"IF(D28=\"\",\"\",IF(D28=\"No\",\"Yes\",\"No\"))","v":""},"","","",{"$f":"IF((COUNT($V$86:V96)<=$S$86),V96,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Difference",null,{"$f":"IF(D33=\"\",\"\",IF(D33>=100,\"Yes\",\"No\"))","v":""},"","","",{"$f":"IF((COUNT($V$86:V97)<=$S$86),V97,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Criteria Entered",null,{"$f":"5-COUNTBLANK(S93:S97)","v":0},"","","",{"$f":"IF((COUNT($V$86:V98)<=$S$86),V98,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Criteria Passed",null,{"$f":"COUNTIF(S93:S97,\"Yes\")","v":0},"","","",{"$f":"IF((COUNT($V$86:V99)<=$S$86),V99,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF((COUNT($V$86:V100)<=$S$86),V100,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF((COUNT($V$86:V101)<=$S$86),V101,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF((COUNT($V$86:V102)<=$S$86),V102,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF((COUNT($V$86:V103)<=$S$86),V103,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF((COUNT($V$86:V104)<=$S$86),V104,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF((COUNT($V$86:V105)<=$S$86),V105,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF((COUNT($V$86:V106)<=$S$86),V106,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF((COUNT($V$86:V107)<=$S$86),V107,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF((COUNT($V$86:V108)<=$S$86),V108,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF((COUNT($V$86:V109)<=$S$86),V109,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF((COUNT($V$86:V110)<=$S$86),V110,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((COUNTBLANK(V110)=0),V110,\"\")","v":""},"",{"$f":"IF(U111>$R$86,\"\",U111)","v":""},{"$f":"IF((COUNT($V$86:V111)<=$S$86),V111,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF((COUNT($V$86:V112)<=$S$86),V112,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF((COUNT($V$86:V113)<=$S$86),V113,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF((COUNT($V$86:V114)<=$S$86),V114,\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((COUNTBLANK(V114)=0),V114,\"\")","v":""},"",{"$f":"IF(U115>$R$86,\"\",U115)","v":""},{"$f":"IF((COUNT($V$86:V115)<=$S$86),V115,\"\")","v":""},null,""]

{"sheet":"Payment Plan Contract","index":1,"n_rows":82,"n_cols":25,"rows_kept":82,"cut":false,"hidden":false,"merged":[[20,2,20,3],[19,2,19,3],[21,2,21,3],[18,2,18,3],[140,20,140,21],[28,5,28,6],[28,7,28,8],[33,7,33,8],[34,5,34,6],[34,7,34,8],[24,7,24,8],[25,7,25,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[31,7,31,8],[32,5,32,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[12,6,12,8],[14,6,14,8],[7,0,7,8],[17,0,17,1],[16,0,16,3],[12,0,12,1],[13,0,13,1],[14,0,14,1],[8,4,8,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[8,0,8,1],[13,4,13,8],[14,4,14,5],[10,0,10,1],[11,0,11,1],[9,4,9,5],[8,6,8,8],[9,6,9,8],[10,6,10,8],[17,7,17,8],[17,5,17,6],[1,18,1,19],[1,21,1,22],[11,6,11,8],[16,5,16,8],[18,5,18,6],[15,0,15,8],[16,4,47,4],[9,0,9,1],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[17,2,17,3],[19,5,19,6],[20,5,20,6],[20,7,20,8],[18,7,18,8],[41,5,41,6],[36,5,36,6],[37,5,37,6],[38,5,38,6],[25,5,25,6],[21,7,21,8],[23,7,23,8],[26,7,26,8],[22,7,22,8],[61,0,62,8],[19,7,19,8],[80,0,80,8],[72,0,72,1],[73,0,73,1],[73,2,73,3],[72,2,72,8],[70,0,70,1],[70,2,70,3],[70,4,70,5],[70,6,70,8],[71,0,71,1],[71,2,71,3],[71,4,71,5],[71,6,71,8],[68,0,68,8],[69,0,69,1],[69,2,69,3],[32,7,32,8],[81,0,129,8],[65,0,65,3],[66,0,66,7],[69,4,69,5],[69,6,69,8],[42,7,42,8],[45,5,45,6],[45,7,45,8],[64,0,64,1],[64,7,64,8],[73,4,73,5],[57,0,58,8],[59,0,60,0],[59,1,60,4],[59,5,60,5],[59,6,60,8],[46,5,46,6],[46,7,46,8],[42,5,42,6],[44,5,44,6],[43,5,43,6],[44,7,44,8],[43,7,43,8],[1,0,6,8],[0,0,0,8],[25,0,25,3],[67,0,67,8],[21,5,21,6],[27,5,27,6],[22,2,22,3],[47,5,47,6],[22,0,22,1],[50,0,50,8],[51,0,53,8],[54,0,55,0],[54,1,55,4],[54,5,55,5],[35,7,35,8],[29,5,29,6],[29,7,29,8],[30,5,30,6],[30,7,30,8],[33,5,33,6],[27,7,27,8],[31,5,31,6],[26,5,26,6],[35,5,35,6],[39,7,39,8],[40,7,40,8],[41,7,41,8],[39,5,39,6],[40,5,40,6],[78,0,78,1],[78,2,78,3],[78,6,78,8],[75,0,75,8],[76,0,76,1],[77,0,77,1],[77,2,77,3],[77,6,77,8],[76,2,76,8],[56,0,56,8],[26,0,47,3],[49,0,49,8],[47,7,47,8],[54,6,55,8]]}
[]
["Payment Plan Contract",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BPAY Billers & Biller Codes",null,"State","Amounts",null,null,"No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RERESH",null,null,"Please Select","-","Select State",{"$f":"MAX(F19:G48)","v":0},"MAX",null,{"$f":"COUNTIF(F19:G48,V3)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BNTTQ",574780,"QLD",{"$f":"MIN(F19:G48)","v":0},"MIN",null,{"$f":"COUNTIF(F19:G48,V4)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MSTTQ",574814,"ACT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SBTTQ",574970,"NSW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NT"]
["Student and Program Details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SA"]
["Surname:",null,null,null,"Given Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAS"]
["Student Number:",null,null,null,"Date of Birth:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VIC"]
["Preferred Contact Number:",null,null,null,"Other Contact No:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA"]
["Study Package Number:",null,null,null,"Program Name:"]
["Start of Study:",null,{"$f":"IF('Payment Plan Calculator'!D13=\"\",\"\",'Payment Plan Calculator'!D13)","v":""},null,"Close of Study:",null,{"$f":"IF('Payment Plan Calculator'!D14=\"\",\"\",'Payment Plan Calculator'!D14)","v":""}]
["Establishment  / Approval Date:",null,null,null,"Representative of TAFE Queensland "]
["SMS Business Unit:",null,"Please Select",null,"Approved Signature:"]
[]
["Approved Payment Plan Arrangement - Contract Details",null,null,null,null,"Direct Debit Payment Schedule"]
["Total Cost of Contract",null,{"$f":"IF('Payment Plan Calculator'!D17=\"\",\"\",'Payment Plan Calculator'!D17)","v":""},null,null,"Amount Due",null,"Date Due"]
["Balance to Pay",null,{"$f":"IF('Payment Plan Calculator'!D19=\"\",\"\",'Payment Plan Calculator'!D19)","v":""},null,null,{"$f":"'Payment Plan Calculator'!F32","v":""},null,{"$f":"'Payment Plan Calculator'!H32","v":""}]
["No. of Fortnightly Payments",null,{"$f":"IF(OR('Payment Plan Calculator'!S86=\"\",'Payment Plan Calculator'!S86=0),\"\",'Payment Plan Calculator'!S86)","v":""},null,null,{"$f":"'Payment Plan Calculator'!F33","v":""},null,{"$f":"'Payment Plan Calculator'!H33","v":""}]
["Amount to Pay Per Instalment",null,{"$f":"IF(AND(V3=0,V4=0),\"\",IF(V3=V4,CONCATENATE(\"$\",V3),CONCATENATE(Y3,\" x $\",V3,\"  /  \",Y4,\" x $\",V4)))","v":""},null,null,{"$f":"'Payment Plan Calculator'!F34","v":""},null,{"$f":"'Payment Plan Calculator'!H34","v":""}]
["First Direct Debit Date",null,{"$f":"IF('Payment Plan Calculator'!D39=\"\",\"\",'Payment Plan Calculator'!D39)","v":""},null,null,{"$f":"'Payment Plan Calculator'!F35","v":""},null,{"$f":"'Payment Plan Calculator'!H35","v":""}]
["Last Direct Debit Date",null,{"$f":"IF('Payment Plan Calculator'!D40=\"\",\"\",'Payment Plan Calculator'!D40)","v":""},null,null,{"$f":"'Payment Plan Calculator'!F36","v":""},null,{"$f":"'Payment Plan Calculator'!H36","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F37","v":""},null,{"$f":"'Payment Plan Calculator'!H37","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F38","v":""},null,{"$f":"'Payment Plan Calculator'!H38","v":""}]
["Student Debtor Rules and Obligations:",null,null,null,null,{"$f":"'Payment Plan Calculator'!F39","v":""},null,{"$f":"'Payment Plan Calculator'!H39","v":""}]
["            ** Payments will be Direct Debit ONLY**\n\n• The Payment Plan must be completed at least 30 days prior to CLOSE of study, or as otherwise specified;\n• Should you have a debt with TAFE Queensland, no further credit or continuing enrolment will be available until such debt has been paid;\n• If you don’t ensure funds are available for each Direct Debit  payment when it is due, your Payment Plan will be cancelled and the total outstanding balance must be paid within 14 days;\n• If you withdraw from a course or program before the course or program has completed, all the remaining payments on your Payment Plan must be paid within 14 days;\n• Even if you withdraw from the program, you may still owe for unpaid fees if classes have started, whether you have attended these classes or not.\n• Overdue debts may be referred to a Debt Collection Agency for recovery and may be reported to a Credit Referencing Agency. This may result in extra costs being incurred by the student/guarantor and may affect their credit rating.\n \n \n           ",null,null,null,null,{"$f":"'Payment Plan Calculator'!F40","v":""},null,{"$f":"'Payment Plan Calculator'!H40","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F41","v":""},null,{"$f":"'Payment Plan Calculator'!H41","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F42","v":""},null,{"$f":"'Payment Plan Calculator'!H42","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F43","v":""},null,{"$f":"'Payment Plan Calculator'!H43","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F44","v":""},null,{"$f":"'Payment Plan Calculator'!H44","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F45","v":""},null,{"$f":"'Payment Plan Calculator'!H45","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F46","v":""},null,{"$f":"'Payment Plan Calculator'!H46","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F47","v":""},null,{"$f":"'Payment Plan Calculator'!H47","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F48","v":""},null,{"$f":"'Payment Plan Calculator'!H48","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F49","v":""},null,{"$f":"'Payment Plan Calculator'!H49","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F50","v":""},null,{"$f":"'Payment Plan Calculator'!H50","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F51","v":""},null,{"$f":"'Payment Plan Calculator'!H51","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F52","v":""},null,{"$f":"'Payment Plan Calculator'!H52","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F53","v":""},null,{"$f":"'Payment Plan Calculator'!H53","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F54","v":""},null,{"$f":"'Payment Plan Calculator'!H54","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F55","v":""},null,{"$f":"'Payment Plan Calculator'!H55","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F56","v":""},null,{"$f":"'Payment Plan Calculator'!H56","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F57","v":""},null,{"$f":"'Payment Plan Calculator'!H57","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F58","v":""},null,{"$f":"'Payment Plan Calculator'!H58","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F59","v":""},null,{"$f":"'Payment Plan Calculator'!H59","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F60","v":""},null,{"$f":"'Payment Plan Calculator'!H60","v":""}]
[null,null,null,null,null,{"$f":"'Payment Plan Calculator'!F61","v":""},null,{"$f":"'Payment Plan Calculator'!H61","v":""}]
[]
[]
["Student Declaration"]
["• I declare that all information is true and correct.  I agree to the rules and obligations and realise payments will be Direct Debit only.\n• I have received a copy of this Payment Plan/Direct Debit Schedule, or understand that I will be sent a copy of this Payment Plan/Direct Debit Schedule;\n• I understand that if I lapse in payments I may be removed from class and my Award may be withheld until all fees are paid.  "]
[]
[]
["Student signature:",null,null,null,null,"Date:"]
[]
["Guarantor Declaration"]
["• I understand and agree that I will be liable to pay all money owing by the Student to TAFE Queensland if the above signed party defaults in paying the debt under the Payment Plan Arrangements."]
[]
["Guarantor signature:",null,null,null,null,"Date:"]
[]
["Guarantor must be over 18 years of age. Please note if default occurs, the above signed Guarantor is liable for outstanding debt associated with this contract."]
[]
[]
[]
[]
[]
[]
["Guarantor Details (required if student is under 18 years old)"]
["Surname:",null,null,null,"Given Name:"]
["Student Number:",null,null,null,"Date of Birth:"]
["Preferred Contact Number:",null,null,null,"Other Contact No:"]
["Address:"]
["Suburb:",null,null,null,"State:",null,"Select State","Post Code:"]
[]
["Direct Debit Details"]
["Name of Account Holder:"]
["BSB Number:",null,null,null,"Account Number:"]
["Signature of Account Holder:",null,null,null,"Date"]
[]
["TAFE Queensland Payment Plan Arrangements - Terms and Conditions"]
["Payment Plans may be provided at the discretion of the General Manager (or delegate) conditional upon a student entering into a written agreement for the payment of fees and subject to the following Terms and Conditions:\n\nEligibility to Apply - All of the eligibility conditions must be met in order for a student to be deemed eligible to apply for a Payment Plan:\n• The student is a domestic student;\n• If the student is under 18 years of age, they must apply with a guarantor;\n• The student provides 100 points of evidence of identification including photo ID;\n• The student is able to demonstrate financial capacity to meet the payment plan;\n• The program fees are over $500;\n• The program is a minimum of 6 weeks in duration;\n• The student shows no outstanding debt on their student account;\n• Payments shall be made by Direct Debit only on a fortnightly basis.\n\nApplication Process - An application for a Payment Plan must be completed via the Payment Plan Application prior to enrolment unless approved for a late enrolment.  A Financial Viability Test shall be completed using the information provided.  A credit check on the student and guarantor may be completed using a credit reporting body.\n\nEnrolment cannot occur unless the Payment Plan application has been approved and the first payment made. Where a Payment Plan is approved, the first payment must be made at the time of enrolment.  Students and/or Guarantors are responsible for providing true and correct information. A schedule of agreed payments will be issued at the time of enrolment.  Payments must be made by the due date.\n\nThe total Payment Plan shall be completed at least 30 days prior to the end of the student’s program of study for which Payment Plan has been provided. Cancellation of enrolment does not cancel the obligation to make all payments under the Payment Plan.  The student’s enrolment into this program of study is acceptance of the terms and conditions of the agreement into which they are entering.\n\nAfter Start of Study, any additional classes will need to be paid in full. Students seeking extension of time to meet standard Payment Plan arrangements. A student may apply in writing requesting an extension of time to meet extenuating circumstances adversely affecting their ability to meet repayment commitments.\n\nDeclined Applications - Eligible Payment Plan applications may be declined under the following conditions: \n• The Financial Viability Test shows that the Payment Plan is not affordable;\n• To any person less than 18 years of age, unless a guarantor is agreed to by the region;\n• The credit check is failed;\n• Where a debt has been written off or previous Payment Plan instalments are currently outstanding.\n\nRefused Application for a Payment Plan - The student may apply to the General Manager (or delegate) within 10 business days after the written notice is given, to request a reconsideration of the application.\n\nRecovery Action - Where a student defaults on agreed instalment payments the following will apply:\n• The debt becomes payable in full immediately;\n• A student may be withdrawn from training;\n• No subsequent payment plans will be considered;\nRecovery of overdue debts may be referred to a Debt Collection Agency and may be reported to a Credit Referencing Agency.   This may result in additional costs being incurred by the student/guarantor and may affect their credit rating;\nIf a student completes the requirements of the qualification they are enrolled in, but they still have outstanding fees, the student will not be issued with an award/results until such time as the outstanding debt is paid in full."]