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

{"sheet":"Rental & Gearing","index":1,"n_rows":34,"n_cols":28,"rows_kept":34,"cut":false,"hidden":false,"merged":[[30,13,32,16],[30,17,32,19],[2,17,2,20],[2,5,2,8],[30,5,30,7],[31,5,31,7],[32,5,32,7],[10,5,10,7],[9,5,9,7],[3,5,3,7],[4,5,4,7],[5,5,5,7],[6,5,6,7],[7,5,7,7],[8,5,8,7],[29,13,29,16],[11,5,11,7],[12,5,12,7],[2,1,3,3],[22,1,23,3],[10,1,11,3],[6,1,7,3],[19,5,19,7],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,5,23,7],[33,5,33,7],[29,5,29,7],[13,5,13,7],[14,1,15,3],[18,1,19,3],[14,5,14,7],[15,5,15,7],[16,5,16,7],[17,5,17,7],[18,5,18,7],[24,5,24,7],[25,5,25,7],[26,5,26,7],[27,5,27,7],[28,5,28,7]]}
[]
[]
[null,"BC Invest\n Domestic Calculators",null,null,null,"Rental Income",null,null,null,null,null,null,null,null,null,null,null,"Negative Gearing",null,null,null,null,null,null,"Rental"]
[null,null,null,null,null,"Property Address",null,null,"Gross Rental"," Frequency",null,"Annual Rental","Verification","App 1","App 2","App 3","App 4","Amount Owing","Interest Rate","Annual Gearing","App 1","App 2","App 3","App 4","App 1","App 2","App 3","App 4"]
[null,null,null,null,null,null,null,null,0,null,{"$f":"IF(J5=\"Weekly\",52,IF(J5=\"Fortnightly\",26,IF(J5=\"Monthly\",12,IF(J5=\"Quarterly\",4,1))))","v":1},{"$f":"I5*K5","v":0},null,null,null,null,null,0,null,{"$f":"R5*S5","v":0},{"$f":"T5*N5","v":0},{"$f":"T5*O5","v":0},{"$f":"T5*P5","v":0},{"$f":"Q5*T5","v":0},{"$f":"N5*L5","v":0},{"$f":"O5*L5","v":0},{"$f":"P5*L5","v":0},{"$f":"Q5*L5","v":0}]
[null,null,null,null,null,null,null,null,0,null,{"$f":"IF(J6=\"Weekly\",52,IF(J6=\"Fortnightly\",26,IF(J6=\"Monthly\",12,IF(J6=\"Quarterly\",4,1))))","v":1},{"$f":"I6*K6","v":0},null,null,null,null,null,0,null,{"$f":"R6*S6","v":0},{"$f":"T6*N6","v":0},{"$f":"T6*O6","v":0},{"$f":"T6*P6","v":0},{"$f":"Q6*T6","v":0},{"$f":"N6*L6","v":0},{"$f":"O6*L6","v":0},{"$f":"P6*L6","v":0},{"$f":"Q6*L6","v":0}]
[null,"Funds\nto Complete",null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,{"$f":"T7*N7","v":0},{"$f":"T7*O7","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,"Refinance\n Conduct & Benefit",null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,{"$f":"R14*S14","v":0},0,0,0,0,0,0,0,0]
[null,"BAS \nCalculator",null,null,null,null,null,null,0,null,{"$f":"IF(J15=\"Weekly\",52,IF(J15=\"Fortnightly\",26,IF(J15=\"Monthly\",12,IF(J15=\"Quarterly\",4,1))))","v":1},{"$f":"I15*K15","v":0},null,null,null,null,null,0,null,{"$f":"R15*S15","v":0},{"$f":"T15*N15","v":0},{"$f":"T15*O15","v":0},{"$f":"T15*P15","v":0},{"$f":"Q15*T15","v":0},{"$f":"N15*L15","v":0},{"$f":"O15*L15","v":0},{"$f":"P15*L15","v":0},{"$f":"Q15*L15","v":0}]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,"Self Employed\nFull Doc Calculator",null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,"Rental &\n Negative Gearing",null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,null,1,0,null,null,null,null,null,0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Servicing Figure Inputs",null,null,"Rental","Gearing"]
[null,null,null,null,null,"Applicant One",null,null,{"$f":"SUM(Y5:Y29)","v":0},{"$f":"SUM(U5:U29)","v":0},null,null,null,"Ownership must be input as a percentage for each individual.",null,null,null,"Full debt must be considered for non parties to the loan.\n"]
[null,null,null,null,null,"Applicant Two",null,null,{"$f":"SUM(Z5:Z29)","v":0},{"$f":"SUM(V5:V29)","v":0}]
[null,null,null,null,null,"Applicant Three",null,null,{"$f":"SUM(AA5:AA29)","v":0},{"$f":"SUM(W5:W29)","v":0}]
[null,null,null,null,null,"Applicant Four",null,null,{"$f":"SUM(AB5:AB29)","v":0},{"$f":"SUM(X5:X29)","v":0}]

{"sheet":"Refinance conduct and benefit","index":2,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,5,24,6],[23,5,23,6],[14,1,15,3],[18,1,19,3],[22,5,22,6],[2,1,3,3],[22,1,23,3],[10,1,11,3],[21,5,21,6],[6,1,7,3],[19,5,19,7]]}
[]
[]
[null,"BC Invest\n Domestic Calculators"]
[null,null,null,null,null,"Financial Institution","Account Number","Required Monthly Repayment","Current Facility Balance","Current Interest Rate",{"$f":"TODAY()","v":"2025-02-04"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))","v":"2025-01-04"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-2,DAY(TODAY()))","v":"2024-12-04"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-3,DAY(TODAY()))","v":"2024-11-04"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-4,DAY(TODAY()))","v":"2024-10-04"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-5,DAY(TODAY()))","v":"2024-09-04"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY()))","v":"2024-08-04"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-7,DAY(TODAY()))","v":"2024-07-04"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-8,DAY(TODAY()))","v":"2024-06-04"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,"Funds\nto Complete",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0]
[null,"Refinance\n Conduct & Benefit",null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0]
[null,"BAS \nCalculator",null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0]
[null,"Self Employed\nFull Doc Calculator",null,null,null,null,null,0,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K5:K19)","v":0},{"$f":"SUM(L5:L19)","v":0},{"$f":"SUM(M5:M19)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,"Exisiting Monthly Repayments",null,{"$f":"SUM(H5:H19)","v":0}]
[null,null,null,null,null,"Proposed Monthly Repayments"]
[null,"Rental &\n Negative Gearing",null,null,null,"Benefit from proposed refinance"]
[null,null,null,null,null,"Proposed Loan Amount"]
[null,null,null,null,null,"Funds Position",null,{"$f":"H24-SUM(I5:I19)","v":0}]

{"sheet":"BAS Calculator","index":3,"n_rows":24,"n_cols":28,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,1,3,3],[0,4,0,7],[11,4,12,4],[14,4,15,4],[3,6,3,8],[2,5,2,8],[1,5,1,8],[22,1,23,3],[6,1,7,3],[10,1,11,3],[14,1,15,3],[18,1,19,3]]}
[]
[null,null,null,null,"Entity Name"]
[null,"BC Invest\n Domestic Calculators",null,null,"ABN"]
[null,null,null,null,"Declared Income",null,{"$f":"IF(F4>H24,\"More Information\",\"Accepted\")","v":"Accepted"}]
[null,null,null,null,"BAS Statement","4 Quarters"]
[null,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(F5=\"Quarterly\",2,\"\")","v":""}]
[null,"Funds\nto Complete",null,null,"Period Ending","June",null,{"$f":"IF(OR($F$5=\"12 Months\",$F$5=\"6 Months\"),TEXT(DATE(YEAR(DATEVALUE(\"1 \"&F7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&F7&\" 2022\"))+1,1),\"MMMM\"),IF(OR($F$5=\"4 Quarters\",$F$5=\"2 Quarters\"),TEXT(DATE(YEAR(DATEVALUE(\"1 \"&F7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&F7&\" 2022\"))+3,1),\"MMMM\"),TEXT(DATE(YEAR(DATEVALUE(\"1 \"&F7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&F7&\" 2022\"))+1,1),\"MMMM\")))","v":"September"},null,{"$f":"IF(OR($F$5=\"12 Months\",$F$5=\"6 Months\"),TEXT(DATE(YEAR(DATEVALUE(\"1 \"&H7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&H7&\" 2022\"))+1,1),\"MMMM\"),IF(OR($F$5=\"4 Quarters\",$F$5=\"2 Quarters\"),TEXT(DATE(YEAR(DATEVALUE(\"1 \"&H7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&H7&\" 2022\"))+3,1),\"MMMM\"),TEXT(DATE(YEAR(DATEVALUE(\"1 \"&H7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&H7&\" 2022\"))+1,1),\"MMMM\")))","v":"December"},null,{"$f":"IF(OR($F$5=\"12 Months\",$F$5=\"6 Months\"),TEXT(DATE(YEAR(DATEVALUE(\"1 \"&J7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&J7&\" 2022\"))+1,1),\"MMMM\"),IF(OR($F$5=\"4 Quarters\",$F$5=\"2 Quarters\"),TEXT(DATE(YEAR(DATEVALUE(\"1 \"&J7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&J7&\" 2022\"))+3,1),\"MMMM\"),TEXT(DATE(YEAR(DATEVALUE(\"1 \"&J7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&J7&\" 2022\"))+1,1),\"MMMM\")))","v":"March"},null,{"$f":"TEXT(DATE(YEAR(DATEVALUE(\"1 \"&L7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&L7&\" 2022\"))+1,1),\"MMMM\")","v":"April"},null,{"$f":"TEXT(DATE(YEAR(DATEVALUE(\"1 \"&N7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&N7&\" 2022\"))+1,1),\"MMMM\")","v":"May"},null,{"$f":"TEXT(DATE(YEAR(DATEVALUE(\"1 \"&P7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&P7&\" 2022\"))+1,1),\"MMMM\")","v":"June"},null,{"$f":"TEXT(DATE(YEAR(DATEVALUE(\"1 \"&R7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&R7&\" 2022\"))+1,1),\"MMMM\")","v":"July"},null,{"$f":"TEXT(DATE(YEAR(DATEVALUE(\"1 \"&T7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&T7&\" 2022\"))+1,1),\"MMMM\")","v":"August"},null,{"$f":"TEXT(DATE(YEAR(DATEVALUE(\"1 \"&V7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&V7&\" 2022\"))+1,1),\"MMMM\")","v":"September"},null,{"$f":"TEXT(DATE(YEAR(DATEVALUE(\"1 \"&X7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&X7&\" 2022\"))+1,1),\"MMMM\")","v":"October"},null,{"$f":"TEXT(DATE(YEAR(DATEVALUE(\"1 \"&Z7&\" 2022\")),MONTH(DATEVALUE(\"1 \"&Z7&\" 2022\"))+1,1),\"MMMM\")","v":"November"}]
[]
[null,null,null,null,"Total Sales (G1)",0,null,0,null,0,null,0,null,0,null,0,null,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,0,null,0,null,0,null,0,null,0,null,0]
[null,"Refinance\n Conduct & Benefit",null,null,"Wages* (W1)",0,null,0,null,0,null,0,null,0,null,0,null,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,0,null,0,null,0,null,0,null,0,null,0]
[null,"BAS \nCalculator",null,null,"*Evidence to be provided \nto exclude capital purchases "]
[]
[null,null,null,null,"Total Purchases",{"$f":"IF($F$14>0,((F10/(1/11))-F14),(F10/(1/11)))","v":0},null,{"$f":"IF($F$14>0,((H10/(1/11))-H14),(H10/(1/11)))","v":0},null,{"$f":"IF($F$14>0,((J10/(1/11))-J14),(J10/(1/11)))","v":0},null,{"$f":"IF($F$14>0,((L10/(1/11))-L14),(L10/(1/11)))","v":0},null,{"$f":"IF($F$14>0,((N10/(1/11))-N14),(N10/(1/11)))","v":0},null,{"$f":"IF($F$14>0,((P10/(1/11))-P14),(P10/(1/11)))","v":0},null,{"$f":"IF($F$14>0,((R10/(1/11))-R14),(R10/(1/11)))","v":0},null,{"$f":"IF($F$14>0,((T10/(1/11))-T14),(T10/(1/11)))","v":0},null,{"$f":"IF($F$14>0,((V10/(1/11))-V14),(V10/(1/11)))","v":0},null,{"$f":"IF($F$14>0,((X10/(1/11))-X14),(X10/(1/11)))","v":0},null,{"$f":"IF($F$14>0,((Z10/(1/11))-Z14),(Z10/(1/11)))","v":0},null,{"$f":"IF($F$14>0,((AB10/(1/11))-AB14),(AB10/(1/11)))","v":0}]
[null,null,null,null,"Net profit",{"$f":"F9-F17-F11","v":0},null,{"$f":"H9-H17-H11","v":0},null,{"$f":"J9-J17-J11","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Self Employed\nFull Doc Calculator",null,null,"Gross Revenue",null,null,{"$f":"IF(OR($F$5=\"2 Quarters\",$F$5=\"6 Months\"),SUM(F9:P9)*2,IF(OR(F$5=\"12 Months\",$F$5=\"4 Quarters\"),SUM(F9:Z9),\"\"))","v":0}]
[null,null,null,null,"Annual Income",null,null,{"$f":"IF(OR($F$5=\"2 Quarters\",$F$5=\"6 Months\"),SUM(F18:P18)*2,IF(OR(F$5=\"12 Months\",$F$5=\"4 Quarters\"),SUM(F18:AB18),\"\"))","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":"F4/H19","v":{"$error":"#DIV/0!"}}]
[null,"Rental &\n Negative Gearing"]
[null,null,null,null,"Figure to adopt for servicing",null,null,{"$f":"IF((H20<H21),MIN(H21,H20),H21)","v":0}]

{"sheet":"Self Employed Full Doc","index":4,"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],[22,1,23,3],[10,1,11,3],[14,1,15,3],[18,1,19,3],[6,1,7,3]]}
[]
[]
[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,"Refinance\n Conduct & Benefit",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,"BAS \nCalculator",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,"Self Employed\nFull Doc Calculator",null,null,"Company Name"]
[null,null,null,null,"ABN"]
[null,null,null,null,"Financial Year Ending",null,2018,{"$f":"G21+1","v":2019}]
[]
[null,"Rental &\n Negative Gearing",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":5,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[18,1,19,3],[6,1,7,3],[2,1,3,3],[22,1,23,3],[10,1,11,3],[14,1,15,3]]}
[]
[]
[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,"Refinance\n Conduct & Benefit",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,"BAS \nCalculator",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,"Self Employed\nFull Doc Calculator",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!"}}]
[null,"Rental &\n Negative Gearing"]

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