{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["User Guide","BAS Calculator","Self Employed Full Doc","Funds to Complete","List Data"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":4,"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":"User Guide","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[9,4,11,8],[2,1,3,3],[18,1,19,3],[6,1,7,3],[10,1,11,3],[14,1,15,3],[7,6,7,8]]}
[null,"V1.0"]
[]
[null,"BC Invest\n Domestic Calculators"]
[]
[]
[]
[null,"Funds\nto Complete"]
[null,null,null,null,null,null,"INTERNAL CREDIT USE ONLY"]
[]
[null,null,null,null,"Please use the left navigation pane to select the Domestic Calculator"]
[null,"BAS \nCalculator"]
[]
[]
[]
[null,"Self Employed\nFinancials Calculator"]

{"sheet":"BAS Calculator","index":1,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[[18,1,19,3],[6,1,7,3],[10,1,11,3],[14,1,15,3],[2,1,3,3],[0,4,0,7],[11,4,12,4],[14,4,15,4],[4,6,4,8],[3,5,3,8]]}
[null,"V1.0"]
[]
[null,"BC Invest\n Domestic Calculators",null,null,"Entity Name"]
[null,null,null,null,"ABN"]
[null,null,null,null,"Declared Income",null,{"$f":"IF(F5>H24,\"More Information\",\"Accepted\")","v":"Accepted"}]
[]
[null,"Funds\nto Complete",null,null,"Period Ending"]
[]
[null,null,null,null,"Total Sales (G1)",0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,"Owed by ATO (1B)",0,null,0,null,0,null,0,null,0,null,0]
[null,"BAS \nCalculator",null,null,"Wages* (W1)",0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,"*wages/salary paid to directors may\n be excluded, subject to confirmation"]
[]
[null,null,null,null,"Capital Purchases*",0,null,0,null,0,null,0,null,0,null,0]
[null,"Self Employed\nFinancials Calculator",null,null,"*Evidence to be provided \nto exclude capital purchases "]
[]
[null,null,null,null,"Total Purchases",0,null,{"$f":"IF($F$14>0,((H10/0.0909)-H14),(H10/0.0909))","v":0},null,{"$f":"IF($H$14>0,((J10/0.0909)-J14),(J10/0.0909))","v":0},null,{"$f":"IF($J$14>0,((L10/0.0909)-L14),(L10/0.0909))","v":0},null,{"$f":"IF($L$14>0,((N10/0.0909)-N14),(N10/0.0909))","v":0},null,{"$f":"IF($N$14>0,((P10/0.0909)-P14),(P10/0.0909))","v":0}]
[]
[null,null,null,null,"Gross Revenue",null,null,{"$f":"(F9+H9+J9+L9+N9+P9)*2","v":0}]
[null,null,null,null,"Annual Income",null,null,{"$f":"(((F9-F17-F11)+(H9-H17-H11)+(J9-J17-J11)+(L9-L17-L11)+(N9-N17-N11)+(P9-P17-P11))*2)","v":0}]
[null,null,null,null,"40% of Annual Revenue ",null,null,{"$f":"H19*0.4","v":0}]
[null,null,null,null,"Declared income to revenue ratio",null,null,{"$f":"F5/H19","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Figure to adopt for servicing",null,null,{"$f":"IF((F5<H21),MIN(H21,F5),H21)","v":0}]

{"sheet":"Self Employed Full Doc","index":2,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,5,2,7],[3,5,3,7],[18,5,18,7],[19,5,19,7],[2,1,3,3],[18,1,19,3],[10,1,11,3],[14,1,15,3],[6,1,7,3]]}
[null,"V1.0"]
[]
[null,"BC Invest\n Domestic Calculators",null,null,"Company Name"]
[null,null,null,null,"ABN"]
[null,null,null,null,"Financial Year Ending",null,2018,{"$f":"G5+1","v":2019}]
[]
[null,"Funds\nto Complete",null,null,"Net Operating Income",null,0,0]
[null,null,null,null,"Add Backs"]
[null,null,null,null,"Depreciation",null,0,0]
[null,null,null,null,"Interest (debts being refinanced)",null,0,0]
[null,"BAS \nCalculator",null,null,"Directors Salaries and Wages",null,0,0]
[null,null,null,null,"Directors Superannuation ",null,0,0]
[null,null,null,null,"Other Add backs",null,0,0]
[]
[null,"Self Employed\nFinancials Calculator",null,null,"Annual Income",null,{"$f":"SUM(G9:G13,G7)","v":0},{"$f":"SUM(H7:H11,H13)","v":0}]
[null,null,null,null,"120% Income",null,null,{"$f":"IF(G15<H15,MIN(G15*1.2,H15),H15)","v":0}]
[null,null,null,null,"Average income",null,null,{"$f":"IF(G15<H15,MIN(((G15+H15)/2),H15),H15)","v":0}]
[]
[null,null,null,null,"Company Name"]
[null,null,null,null,"ABN"]
[null,null,null,null,"Financial Year Ending",null,2018,{"$f":"G21+1","v":2019}]
[]
[null,null,null,null,"Net Operating Income",null,0,0]
[null,null,null,null,"Add Backs"]
[null,null,null,null,"Depreciation",null,0,0]
[null,null,null,null,"Interest (debts being refinanced)",null,0,0]
[null,null,null,null,"Directors Salaries and Wages",null,0,0]
[null,null,null,null,"Directors Superannuation ",null,0,0]
[null,null,null,null,"Other Add backs",null,0,0]
[]
[null,null,null,null,"Annual Income",null,{"$f":"SUM(G25:G29,G23)","v":0},{"$f":"SUM(H23:H27,H29)","v":0}]
[null,null,null,null,"120% Income",null,null,{"$f":"IF(G31<H31,MIN(G31*1.2,H31),H31)","v":0}]
[null,null,null,null,"Average income",null,null,{"$f":"IF(G31<H31,MIN(((G31+H31)/2),H31),H31)","v":0}]

{"sheet":"Funds to Complete","index":3,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[14,1,15,3],[6,1,7,3],[2,1,3,3],[18,1,19,3],[10,1,11,3]]}
[null,"V1.0"]
[]
[null,"BC Invest\n Domestic Calculators",null,null,null,"Funds Required",null,null,"Funds Available"]
[null,null,null,null,null,"Mortgage Refinance or Purchase price",0,null,"Loan Approved",0]
[null,null,null,null,null,"Stamp Duty",0,null,"Deposit Paid",0]
[null,null,null,null,null,"Conveyancer fees",0,null,"Savings",0]
[null,"Funds \nto Complete",null,null,null,"Application Fee",0,null,"Gifted Funds",0]
[null,null,null,null,null,"Settlement Disbursement Fee",0,null,null,0]
[null,null,null,null,null,"Electronic File Fee",0,null,"Other available resources",0]
[null,null,null,null,null,"Lenders Legal Fees",0,null,null,0]
[null,"BAS \nCalculator",null,null,null,"Debt Consolidation",0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[]
[null,null,null,null,null,"Total Funds Required",{"$f":"SUM(G4:G12)","v":0},null,"Total Funds available",{"$f":"SUM(J4:J7,J10:J12)","v":0}]
[null,"Self Employed\nFinancials Calculator",null,null,null,"Funds to complete position",{"$f":"J14-G14","v":0}]
[]
[null,null,null,null,null,"SMSF Only "]
[null,null,null,null,null,"Other Assets (Value)",0]
[null,null,null,null,null,"Other loans through SMSF",0]
[]
[null,null,null,null,null,"Asset Test",{"$f":"(G4-J4)+(G18-G19)","v":0}]
[null,null,null,null,null,"Liquidity Test",{"$f":"G15/G4","v":{"$error":"#DIV/0!"}}]

{"sheet":"List Data","index":4,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["January","Weekly",52,"Home Loan","Valuation",null,2018]
["February","Fortnightly",26,"Credit Card","Lease Agreement",null,2019]
["March","Monthly",12,"Unsecured/Secured Loan","Rental Statements",null,2020]
["April","Quarterly",4,null,"Bank Statements"]
["May"]
["June"]
["July"]
["August"]
["September"]
["October"]
["November"]
["December"]