{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Serviceability","SMSF Serviceability Calculator","Member Serviceability Calc","HEM","Tables","Serviceability Calc","Tax Calc","User Problems","Version Control","Day and Months Table"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":8,"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":"Serviceability","index":0,"n_rows":94,"n_cols":15,"rows_kept":94,"cut":false,"hidden":true,"merged":[[88,3,89,13],[75,3,76,9],[41,9,41,14],[43,9,43,14],[30,3,30,13],[59,10,59,11],[59,8,59,9],[66,8,66,9],[85,9,85,10],[81,13,82,13],[81,6,81,7],[82,6,82,7],[83,6,83,7],[84,6,84,7],[85,6,85,7],[7,4,7,11],[17,8,17,10],[75,10,76,12],[75,13,76,13],[60,8,60,9],[61,8,61,9],[62,8,62,9],[63,8,63,9],[60,10,60,11],[61,10,61,11],[62,10,62,11],[63,10,63,11],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9]]}
[]
[]
[null,null,"Serviceability Calculator (Residential)"]
[null,null,null,"RedZed Lending Solutions Pty Ltd (ACL 311128)"]
[]
[null,null,null,"Information can be entered in the clear boxes, the grey boxes contain RedZed calculations."]
[]
[null,null,null,"Application name - mandatory"]
[]
[null,null,null,"Income Table",null,null,null,null,"Gross Annual",null,null,null,null,"Net Monthly"]
[]
[null,null,null,"Personal Income","Select Household","PAYG",null,"Self Employed"]
[null,null,null,"Applicant / Guarantor 1",null,5000,null,5000,{"$f":"IFERROR(F13+H13,0)","v":10000}," ",null,null,null,{"$f":"'Tax Calc'!I5","v":0}]
[null,null,null,"Applicant / Guarantor 2",null,null,null,null,{"$f":"IFERROR(F14+H14,0)","v":0},null,null,null,null,{"$f":"'Tax Calc'!I6","v":0}]
[null,null,null,"Applicant / Guarantor 3",null,null,null,400,{"$f":"IFERROR(F15+H15,0)","v":400},null,null,null,null,{"$f":"'Tax Calc'!I7","v":0}]
[null,null,null,"Applicant / Guarantor 4",null,null,null,null,{"$f":"IFERROR(F16+H16,0)","v":0},null,null,null,null,{"$f":"'Tax Calc'!I8","v":0}]
[]
[null,null,null,null,null,null,null,"Select Household","Enter Source of Income"]
[null,null,null,"Applicant / Guarantor 1","Other Regular Monthly Income (eg - Centrelink payments, investments)",null,null,null,"dfdf",null,null,null,null,"dfdf"]
[null,null,null,"Applicant / Guarantor 2","Other Regular Monthly Income (eg - Centrelink payments, investments)"]
[null,null,null,"Applicant / Guarantor 3","Other Regular Monthly Income (eg - Centrelink payments, investments)"]
[null,null,null,"Applicant / Guarantor 4","Other Regular Monthly Income (eg - Centrelink payments, investments)"]
[]
[null,null,null,"Rental Income","Existing",null,null,null,null,null,null,null,null,{"$f":"I24*0.8/12","v":0}]
[null,null,null,"Rental Income","New",null,null,null,null,null,null,null,null,{"$f":"I25*0.8/12","v":0}]
[]
[null,null,null,"Company Income (only to be used if the company is the loan applicant)"]
[null,null,null,"*If a guarantor's income is also required to help with serviceability,"]
[null,null,null,"all company and guarantor debts, and living expenses need to be included"]
[null,null,null,"Company Net Profit Before Tax - Full Doc or Alt Doc Self Certified",null,null,null,null,null,null,null,null,null,{"$f":"(I30-(I30*Table_Company_Tax_Rate))/12","v":0}]
[null,null,null,{"$f":"IF(I30 <> 0, \"Only NPBT from the borrowing Company entity can be entered in this field. Other related company NPBT needs to be allocated to the director(s)/guarantor(s)\", 0)","v":0}]
[null,null,null,"Total Monthly Net Income",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N13,N14,N15,N16,N19,N20,N21,N22,N24,N25,N30)","v":0}]
[]
[]
[null,null,null,"Monthly Living Expenses"]
[]
[null,null,null,"Applicants(s) declared expenses - mandatory"]
[]
[null,null,null,"Ongoing (combined) standard monthly living expenses declared by applicant(s)"]
[]
[null,null,null,"RedZed Living Allowance"]
[null,null,null,"Number of adults - household 1",null,null,null,null,null,{"$f":"Tables!E84","v":" "}]
[null,null,null,"Number of dependant children - household 1"]
[null,null,null,"Number of adults - household 2",null,null,null,null,null,{"$f":"Tables!E85","v":" "}]
[null,null,null,"Number of dependant children - household 2"]
[]
[null,null,null,"Total Monthly Living Expenses used in assessment",null,null,null,null,null,null,null,null,null,{"$f":"MAX(SUM(N42:N45),I39)","v":0}]
[]
[]
[null,null,null,"Available Income",null,null,null,null,null,null,null,null,null,{"$f":"Tables!B313","v":0}]
[]
[null,null,null,"Commitments",null,null,null,null,null,null,null,null,null,"Monthly"]
[]
[null,null,null,"RedZed Loan Applied For"]
[]
[null,null,null,null,"Loan 1",null,null,null,null,null,null,null,null,{"$f":"Tables!B319","v":0}]
[null,null,null,null,"Loan 2",null,null,null,null,null,null,null,null,{"$f":"Tables!B320","v":0}]
[null,null,null,null,"Loan 3",null,null,null,null,null,null,null,null,{"$f":"Tables!B321","v":0}]
[null,null,null,"Note: An interest rate buffer is automatically applied by the calculator. You do not need to apply a separate buffer."]
[]
[null,null,null,"Existing Loans","Loan 1 - Existing Secured",null,null,null,null,null,""]
[null,null,null,null,"Loan 2 - Existing Secured",null,null,null,null,null,""]
[null,null,null,null,"Loan 3 - Existing Unsecured",null,null,null,null,null,""]
[null,null,null,null,"Loan 4 - Existing Unsecured",null,null,null,null,null,""]
[]
[]
[null,null,null,"Credit Cards",null,null,null,null,null,null,"(@3.82%)",null,null,{"$f":"I67*3.82%","v":0}]
[]
[null,null,null,"Maintenance / On Going Rent"]
[]
[null,null,null,"Other Fixed Monthly Repayments"]
[]
[null,null,null,"Total Monthly Commitments",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N56:N71)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Pass",null,null,"(DSR)"]
[null,null,null,"This Serviceability Calculator is intended as a guide only and no loan approval can be assumed on the basis of the results of this calculator. All applications remain subject to the normal credit and approval criteria of RedZed Lending Solutions Pty Ltd.",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Serviceability Calc'!C22,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"DTI  must also be met for Regulated Loans"]
[null,null,null,null,null,null,null,null,null,null,"For Company Borrowers DSR must be >1.10"]
[null,null,null,null,null,null,null,null,null,null,"For IO Inv loans > 75% DSR must be >1.10"]
[null,null,null,"Debt to Income Ratio - minimum requirements - Regulated Loans Only",null,null,null,null,null,null,null,null,null,"DTI"]
[null,null,null,"Borrower/income Type","DTI > 6.0 - 7.0","DTI > 7.0 - < 8.0","DTI > 8.0 - 8.5",null,"DTI > 8.5",null,null,null,null,{"$f":"IFERROR((SUM(I56:I58)+SUM(I61:I64)+I67)/(SUM(I13:I16)+SUM(N19:N22)*12+SUM(I24:I25)),\"\")","v":0}]
[null,null,null,"Self Employed","DSR >1.10,\n\n>/=1.06 with rental income\n\nDTI up to 7.0","DSR >1.10,\n\n>/=1.06 with rental income\n\nDTI > 7.0 - < 8.0","Minimum DSR \n\n>/=1.02 \n\nAll income",null,"Contact your BDM"]
[null,null,null,"Self Employed & PAYG\n(PAYG < 25% of total income)","DSR >1.10,\n\n>/=1.06 with rental income\n\nDTI up to 7.0)","DSR >1.10,\n\n>/=1.06 with rental income\n\nDTI </= 8.0","Minimum DSR \n\n>/=1.02 \n\nAll income",null,"Contact your BDM"]
[null,null,null,"Self Employed & PAYG\n(PAYG > 25% of total income)","DSR >1.10,\n\n>/=1.06 with rental income\n\nDTI up to 7.0","DSR >1.10,\n\n>/=1.06 with rental income\n\nDTI </= 8.0","Minimum DSR \n\n>/=1.02 \n\nAll income",null,"Contact your BDM"]
[null,null,null,"PAYG Only\n","DSR >1.10,\n\n>/=1.06 with rental income\n\nDTI up to 6.5","DSR >1.10,\n\n>/=1.06 with rental income\n\n> 6.5 - </= 7.5","Minimum DSR \n\n>/=1.02 \n\nAll income\n\nDTI > 7.5 - =/> 8.0",null,"Contact your BDM"]
[]
[]
[null,null,null,"I, the Introducer, confirm that reasonable enquiries about the applicant(s) current and ongoing financial situation have been undertaken and are reflected in the figures entered into this calculation. The applicants(s) have been given sufficient time to consider the declared monthly living expenses amount which has been derived following due consideration."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Version Control'!I1","v":"v1.6 250108"}]

{"sheet":"SMSF Serviceability Calculator","index":1,"n_rows":100,"n_cols":15,"rows_kept":100,"cut":false,"hidden":false,"merged":[[7,4,7,11],[28,3,28,13],[39,9,39,14],[53,10,53,11],[35,9,35,10],[10,3,10,5],[9,3,9,4],[26,3,27,5],[25,3,25,6],[60,8,60,9],[61,8,61,9],[59,10,59,11],[89,3,89,4],[85,3,88,5],[79,3,82,4],[60,10,60,11],[61,10,61,11],[66,3,68,5],[65,10,65,13],[64,3,64,14],[89,6,89,9],[88,6,88,9],[54,10,54,11],[55,10,55,11],[56,10,56,11],[88,10,89,12],[88,13,89,13],[66,10,67,12],[66,13,67,13],[58,10,58,11],[57,10,57,11],[71,13,71,14],[97,3,97,13],[66,6,66,9],[67,6,67,9],[71,5,71,11],[91,3,92,13]]}
[]
[]
[null,null,"SMSF Serviceability Calculator"]
[null,null,null,"RedZed Lending Solutions Pty Ltd (ACL 311128)"]
[]
[null,null,null,"Enter information in the pink boxes.The grey boxes contain calculated results."]
[]
[null,null,null,"SMSF Application name - mandatory"," "]
[]
[null,null,null,"Number of separate households the SMSF members reside in?",null,null,null,{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"}]
[]
[]
[]
[null,null,null,"Superannuation Income Table -  Existing contributions to SMSF or Retail fund",null,null,null,null,"Gross Annual Contributions",null,null,null,null,"Net Monthly"]
[]
[null,null,null,"Superannuation Contributions (RedZed allow maximum 4 members)"]
[null,null,null,"Member 1","Verified existing contributions",null,null,null,0,null,null,null,null,{"$f":"Tables!D384","v":0}]
[null,null,null,"Member 2","Verified existing contributions",null,null,null,0,null,null,null,null,{"$f":"Tables!E384","v":0}]
[null,null,null,"Member 3","Verified existing contributions",null,null,null,0,null,null,null,null,{"$f":"Tables!F384","v":0}]
[null,null,null,"Member 4","Verified existing contributions",null,null,null,0,null,null,null,null,{"$f":"Tables!G384","v":0}]
[]
[null,null,null,"SMSF Rental Income","Commercial – If current lease has > 12 months remaining",null,null,null,0,null,null,null,null,{"$f":"I22*0.9/12","v":0}]
[null,null,null,"SMSF Rental Income","Commercial – If current lease has < 12 months remaining",null,null,null,0,null,null,null,null,{"$f":"I23*0.8/12","v":0}]
[null,null,null,"SMSF Rental Income","Residential Lease",null,null,null,0,null,null,null,null,{"$f":"I24*0.85/12","v":0}]
[null,null,null,"SMSF Rental Income","Short Term Rental (annualised last 6 months average)",null,null,null,0,null,null,null,null,{"$f":"I25*0.8/12","v":0}]
[null,null,null,"SMSF Liquid Asset - post settlement of this loan (combined value of – cash, shares, bonds held in SMSF)\n*Refer product guide for minimum liquid asset requirements"]
[null,null,null,null,null,null,null,null,"Liquid Asset Total (post settlement)"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"I28*0.04*0.85/12","v":0}]
[null,null,null,{"$f":"IF(AND(EXACT(G51,Tables!A325),I28 < 6*SUM(N51:N60),I28 >= 3*SUM(N51:N60)),\"Minimum Liquid Asset Position is less than required. Contact your BDM.\",IF(I28 < 3*SUM(N51:N60), \"Minimum Liquid Asset Position is less than required. Contact your BDM.\", 0))","v":0}]
[null,null,null,"Total Monthly Net Income",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N17:N20,N22:N25,N28)","v":0}]
[]
[]
[null,null,null,"Ongoing SMSF Expenses & Withdrawals",null,null,null,null,"Gross Annual"]
[]
[null,null,null,"Existing Superannuation Fund Expenses"]
[null,null,null,"Audit, Accountant, Financial Planner Fees, etc",null,null,null,null,0,"Min. $2000.00 p.a. ",null,null,null,{"$f":"IF(ISBLANK(I36),0,IF(I36<2000,2000,I36)/12)","v":166.66666666666666}]
[null,null,null,"Insurance Costs (life/Income Protection/Property, etc)",null,null,null,null,0,null,null,null,null,{"$f":"IF(ISBLANK(I37),0,I37/12)","v":0}]
[]
[null,null,null,"Regular Withdrawals from the fund (If Any)",null,null,null,null,0,null,null,null,null,{"$f":"I39/12","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Tables!E84","v":" "}]
[null,null,null,"Total Monthly SMSF Expenses and Withdrawals ",null,null,null,null,null,{"$f":"Tables!E85","v":" "},null,null,null,{"$f":"N36+N37+N39","v":166.66666666666666}]
[]
[]
[]
[null,null,null,"Available Income",null,null,null,null,null,null,null,null,null,{"$f":"N30-N41","v":-166.66666666666666}]
[]
[null,null,null,"SMSF Borrowing Commitments",null,null,null,null,null,null,null,null,null,"Monthly"]
[]
[null,null,null,"Proposed New RedZed SMSF Loan"]
[null,null,null,null,null,null,"Select Loan Type",null,"Loan Amount","Loan Term in Years","Interest Only Term","Interest Rate"]
[null,null,null,null,"New RedZed Loan ",null,null,{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"},0,null,null,null,null,{"$f":"Tables!B387","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Limit","Financier"]
[null,null,null,"Existing SMSF Loans","Loan 1",null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 2",null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 3",null,null,null,null,0,"",null,null,0]
[]
[null,null,null,null,null,null,null,null,null,"Limit","Financier"]
[null,null,null,"Other Loan/Liability Limits if any","eg - Margin Loan",null,null,null,null,0,"",null,null,0]
[]
[]
[]
[null,null,null,"Total Monthly Commitments (inclusive of repayment buffering)",null,null,null,null,null,null,null,null,null,{"$f":"'Serviceability Calc'!G23","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"DSR"]
[null,null,null,null,null,null,"SMSF Fund Only Debt Servicing Ratio ",null,null,null,null,null,null,{"$f":"IFERROR(IF(N51>0,'Serviceability Calc'!G25,0),0)","v":0}]
[null,null,null,null,null,null,"DSR must be >1.00"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"SMSF Fund + Member Servicing Level",null,null,"Household",null,"Proposed Monthly Contribution","Available Monthly Contribution"]
[null,null,null,null,null,null,"Household 1",null,{"$f":"Tables!B369","v":0},{"$f":"IF(Tables!B367<0,0,Tables!B367)","v":0},null,null,null,{"$f":"Tables!B374","v":0}]
[null,null,null,null,null,null,"Household 2",null,{"$f":"Tables!C369","v":0},{"$f":"IF(Tables!C367<0,0,Tables!C367)","v":0},null,null,null,{"$f":"Tables!C374","v":0}]
[null,null,null,null,null,null,"Household 3",null,{"$f":"Tables!D369","v":0},{"$f":"IF(Tables!D367<0,0,Tables!D367)","v":0},null,null,null,{"$f":"Tables!D374","v":0}]
[null,null,null,null,null,null,"Household 4",null,{"$f":"Tables!E369","v":0},{"$f":"IF(Tables!E367<0,0,Tables!E367)","v":0},null,null,null,{"$f":"Tables!E374","v":0}]
[null,null,null,"Member Additional Contributions "]
[]
[null,null,null,"Serviceability has now been assessed using the proosed additional member contributions as detailed in the Member Level Serviceability Cal worksheet. "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(DSR)"]
[null,null,null,null,null,null,"SMSF + Member Debt Servicing Ratio",null,null,null,"Fail",null,null,{"$f":"IFERROR(IF(Tables!F368,'Serviceability Calc'!J24,\"N/A\"),0)","v":0}]
[null,null,null,null,null,null,"SMSF + Member Level Servicing  DSR must be > 1.10"]
[]
[null,null,null,"I, the Introducer, confirm that reasonable enquiries about the applicant(s) current and ongoing financial situation have been undertaken and are reflected in the figures entered into this calculation. Where required the member(s) have been given sufficient time to consider the declared monthly living expenses amount which has been derived following due consideration."]
[]
[]
[]
[]
[]
[null,null,null,"This Serviceability Calculator is intended as a guide only and no loan approval can be assumed on the basis of the results of this calculator. All applications remain subject to the normal credit and approval criteria of RedZed Lending Solutions Pty Ltd."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Version Control'!I1","v":"v1.6 250108"}]

{"sheet":"Member Serviceability Calc","index":2,"n_rows":214,"n_cols":18,"rows_kept":214,"cut":false,"hidden":true,"merged":[[91,3,91,11],[92,3,92,11],[93,3,93,11],[94,3,94,11],[113,12,113,14],[7,4,7,14],[22,11,22,12],[73,11,73,12],[74,11,74,12],[75,11,75,12],[30,9,30,10],[19,3,19,17],[20,3,20,17],[22,13,22,14],[17,3,17,17],[131,12,131,14],[149,12,149,14],[167,12,167,14],[201,9,201,12],[178,13,179,15],[205,3,206,16],[31,9,31,10],[32,9,32,10],[33,9,33,10],[34,9,34,10],[183,9,183,14],[183,16,183,17],[200,13,201,15],[200,16,201,16],[191,3,194,5],[202,13,203,16],[177,13,177,15],[178,16,179,16],[188,3,190,6],[178,3,180,8],[200,9,200,12]]}
[]
[]
[null,null,"SMSF Additional Member Contribution "]
[null,null,null,"RedZed Lending Solutions Pty Ltd (ACL 311128)"]
[]
[null,null,null,"Enter information in the Pink boxes. The grey boxes contain calculated results"]
[]
[null,null,null,null,{"$f":"Tables!H324","v":" "}]
[]
[null,null,null,"Proposed Additional Contributions",null,null,"in addition to current contributions",null,null,null,null,null,null,null,null,null,"Net Monthly"]
[]
[null,null,null,"Enter the additional contribution amount the member is proposing to pay into their SMSF (above current contributions.)"]
[null,null,null,null,"Select Household",null,"Members Income Verification Source"]
[null,null,null,"Member 1","",{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"},null,{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"},null,null,null,"Proposed Additional Monthly Contribution to SMSF",null,null,0,null,{"$f":"Tables!H384","v":0}]
[null,null,null,"Member 2","",{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"},null,{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"},null,null,null,"Proposed Additional Monthly Contribution to SMSF",null,null,0,null,{"$f":"Tables!I384","v":0}]
[null,null,null,"Member 3","",{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"},null,"€",null,null,null,"Proposed Additional Monthly Contribution to SMSF",null,null,0,null,{"$f":"Tables!J384","v":0}]
[null,null,null,"Member 4","",{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"},null,"€",null,null,null,"Proposed Additional Monthly Contribution to SMSF",null,null,0,null,{"$f":"Tables!K384","v":0}]
[null,null,null,{"$f":"IFERROR(IF('Serviceability Calc'!M18>'Serviceability Calc'!L16+'Serviceability Calc'!G3,'Serviceability Calc'!F40,'Serviceability Calc'!F38),\"\")","v":""}]
[null,null,null,"Total of All Proposed Additional Contributions",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q14:Q17)","v":0}]
[null,null,null,{"$f":"IFERROR(IF('Serviceability Calc'!J24 <= 1.1,IF('Serviceability Calc'!O7 > 0.25,'Serviceability Calc'!F30,'Serviceability Calc'!F33),IF('Serviceability Calc'!O7 > 0.25,'Serviceability Calc'!F35,'Serviceability Calc'!F35)),\"\")","v":"Fail – your proposed additional contributions are insufficient to meet minimum serviceability requirements"}]
[null,null,null,{"$f":"IFERROR(IF('Serviceability Calc'!J24 <= 1.1,IF('Serviceability Calc'!O7 > 0.25,'Serviceability Calc'!F31,\"\"),IF('Serviceability Calc'!O7 > 0.25,\"\",\"\")),\"\")","v":""}]
[]
[null,null,null,"Member(s) Income Table",null,null,null,null,null,null,null,"Gross Annual",null,"Gross Annual \n( post above proposed contribution )",null,null,"Net Monthly"]
[]
[null,null,null,"Personal Income"]
[null,null,null,"Member 1",{"$f":"IF(E14 = 0,\"\",E14)","v":""},null,null,null,null,null,null,0,{"$f":"IF(AND(I26 <> 0,J26 =  \"\"),\"Missing Alt/Full Doc Type\",\"\")","v":""},{"$f":"IF('Tax Calc'!O7 < 0,0,'Tax Calc'!O7)","v":0},null,null,{"$f":"IFERROR(IF('Tax Calc'!M51 < 0,0,'Tax Calc'!M51 ),0)","v":0}]
[null,null,null,"Member 2",{"$f":"IF(E15 = 0,\"\",E15)","v":""},null,null,null,null,null,null,0,{"$f":"IF(AND(I27 <> 0,J27 =  \"\"),\"Missing Alt/Full Doc Type\",\"\")","v":""},{"$f":"IF('Tax Calc'!O8 < 0,0,'Tax Calc'!O8)","v":0},null,null,{"$f":"IFERROR(IF('Tax Calc'!M52 < 0,0,'Tax Calc'!M52 ),0)","v":0}]
[null,null,null,"Member 3","",null,null,null,null,null,null,0,{"$f":"IF(AND(I28 <> 0,J28 =  \"\"),\"Missing Alt/Full Doc Type\",\"\")","v":""},{"$f":"IF('Tax Calc'!O9 < 0,0,'Tax Calc'!O9)","v":0},null,null,{"$f":"IFERROR(IF('Tax Calc'!M53 < 0,0,'Tax Calc'!M53 ),0)","v":0}]
[null,null,null,"Member 4","",null,null,null,null,null,null,0,{"$f":"IF(AND(I29 <> 0,J29 =  \"\"),\"Missing Alt/Full Doc Type\",\"\")","v":""},{"$f":"IF('Tax Calc'!O10 < 0,0,'Tax Calc'!O10)","v":0},null,null,{"$f":"IFERROR(IF('Tax Calc'!M54 < 0,0,'Tax Calc'!M54 ),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Enter Source of Income"]
[null,null,null,"Member 1","Other Regular Income (eg – Centrelink/Investments, etc)",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L32/12","v":0}]
[null,null,null,"Member 2","Other Regular Income (eg – Centrelink/Investments, etc)",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L33/12","v":0}]
[null,null,null,"Member 3","Other Regular Income (eg – Centrelink/Investments, etc)",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L34/12","v":0}]
[null,null,null,"Member 4","Other Regular Income (eg – Centrelink/Investments, etc)",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L35/12","v":0}]
[]
[null,null,null,"Household 1"]
[null,null,null,"Rental Income (non-SMSF)","Commercial – If current lease has > 12 months remaining",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L38*0.9/12","v":0}]
[null,null,null,"Rental Income (non-SMSF)","Commercial – If current lease has < 12 months remaining",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L39*0.8/12","v":0}]
[null,null,null,"Rental Income (non-SMSF)","Residential Lease",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L40*0.85/12","v":0}]
[null,null,null,"Rental Income (non-SMSF)","Short Term Rental (annualised last 6 months average)",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L41*0.8/12","v":0}]
[]
[]
[null,null,null,"Household 2"]
[null,null,null,"Rental Income (non-SMSF)","Commercial – If current lease has > 12 months remaining",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L45*0.9/12","v":0}]
[null,null,null,"Rental Income (non-SMSF)","Commercial – If current lease has < 12 months remaining",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L46*0.8/12","v":0}]
[null,null,null,"Rental Income (non-SMSF)","Residential Lease",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L47*0.85/12","v":0}]
[null,null,null,"Rental Income (non-SMSF)","Short Term Rental (annualised last 6 months average)",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L48*0.8/12","v":0}]
[]
[]
[null,null,null,"Household 3"]
[null,null,null,"Rental Income (non-SMSF)","Commercial – If current lease has > 12 months remaining",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L52*0.9/12","v":0}]
[null,null,null,"Rental Income (non-SMSF)","Commercial – If current lease has < 12 months remaining",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L53*0.8/12","v":0}]
[null,null,null,"Rental Income (non-SMSF)","Residential Lease",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L54*0.85/12","v":0}]
[null,null,null,"Rental Income (non-SMSF)","Short Term Rental (annualised last 6 months average)",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L55*0.8/12","v":0}]
[]
[]
[null,null,null,"Household 4"]
[null,null,null,"Rental Income (non-SMSF)","Commercial – If current lease has > 12 months remaining",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L59*0.9/12","v":0}]
[null,null,null,"Rental Income (non-SMSF)","Commercial – If current lease has < 12 months remaining",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L60*0.8/12","v":0}]
[null,null,null,"Rental Income (non-SMSF)","Residential Lease",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L61*0.85/12","v":0}]
[null,null,null,"Rental Income (non-SMSF)","Short Term Rental (annualised last 6 months average)",null,null,null,null,null,null,0,null,null,null,null,{"$f":"L62*0.8/12","v":0}]
[]
[]
[]
[null,null,null,"Total Monthly Net Income Household 1",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Tables!B338,Q38:Q41)","v":0}]
[null,null,null,"Total Monthly Net Income Household 2",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Tables!C338,Q45:Q48)","v":0}]
[null,null,null,"Total Monthly Net Income Household 3",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Tables!D338,Q52:Q55)","v":0}]
[null,null,null,"Total Monthly Net Income Household 4",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Tables!E338,Q59:Q62)","v":0}]
[]
[]
[null,null,null,"Monthly Living Expenses"]
[]
[null,null,null,"Applicants(s) declared expenses - mandatory",null,null,null,null,null,null,null,"RedZed Living Allowance"]
[]
[null,null,null,"Household 1","Monthly living expenses (ongoing)",null,null,null,null,null,null,"Number of adults - household 1"]
[null,null,null,null,null,null,null,null,null,0,null,"Number of dependant children - household 1"]
[]
[null,null,null,"Household 2","Monthly living expenses (ongoing)",null,null,null,null,null,null,"Number of adults - household 2"]
[null,null,null,null,null,null,null,null,null,0,null,"Number of dependant children - household 2"]
[]
[null,null,null,"Household 3","Monthly living expenses (ongoing)",null,null,null,null,null,null,"Number of adults - household 3"]
[null,null,null,null,null,null,null,null,null,0,null,"Number of dependant children - household 3"]
[]
[null,null,null,"Household 4","Monthly living expenses (ongoing)",null,null,null,null,null,null,"Number of adults - household 4"]
[null,null,null,null,null,null,null,null,null,0,null,"Number of dependant children - household 4"]
[]
[]
[]
[]
[]
[null,null,null,"Available Income Household 1 ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tables!B365 <0,0,Tables!B365)","v":0}]
[null,null,null,"Available Income Household 2",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tables!C365<0,0,Tables!C365)","v":0}]
[null,null,null,"Available Income Household 3",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tables!D365<0,0,Tables!D365)","v":0}]
[null,null,null,"Available Income Household 4",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tables!E365<0,0,Tables!E365)","v":0}]
[]
[null,null,null,"Commitments",null,null,null,null,null,null,null,null,null,null,null,null,"Monthly"]
[]
[null,null,null,"Household 1",null,null,null,null,null,null,null,null,"Limit","Financier"]
[null,null,null,"Existing Loans (non SMSF)","Loan 1 - Existing Secured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 2 - Existing Secured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 3 - Existing Secured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 4 - Existing Unsecured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 5 - Existing Unsecured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 6 - Existing Unsecured",null,null,null,null,null,null,null,0,"",null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Credit Limits"]
[null,null,null,"Credit Cards",null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"M108*3.82%","v":0}]
[]
[null,null,null,"Maintenance / On Going Rent",null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Other Fixed Monthly Repayments",null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Total Monthly Surplus Funds Household 1 (After Buffering)",null,null,null,null,null,null,null,null,{"$f":"Tables!B375","v":""},null,null,null,{"$f":"Tables!B367","v":0}]
[]
[]
[null,null,null,"Household 2",null,null,null,null,null,null,null,null,"Limit","Financier"]
[null,null,null,"Existing Loans (non SMSF)","Loan 1 - Existing Secured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 2 - Existing Secured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 3 - Existing Secured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 4 - Existing Unsecured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 5 - Existing Unsecured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 6 - Existing Unsecured",null,null,null,null,null,null,null,0,"",null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Credit Limits"]
[null,null,null,"Credit Cards",null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"M126*3.82%","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Maintenance / On Going Rent",null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Other Fixed Monthly Repayments",null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Total Monthly Surplus Funds Household 2 (After Buffering)",null,null,null,null,null,null,null,null,{"$f":"Tables!C375","v":""},null,null,null,{"$f":"Tables!C367","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Household 3",null,null,null,null,null,null,null,null,"Limit","Financier",null,null,0]
[null,null,null,"Existing Loans (non SMSF)","Loan 1 - Existing Secured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 2 - Existing Secured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 3 - Existing Secured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 4 - Existing Unsecured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 5 - Existing Unsecured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 6 - Existing Unsecured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Credit Limits",null,null,null,0]
[null,null,null,"Credit Cards",null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Maintenance / On Going Rent",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Other Fixed Monthly Repayments",null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Total Monthly Surplus Funds Household 3 (After Buffering)",null,null,null,null,null,null,null,null,{"$f":"Tables!D375","v":""},null,null,null,{"$f":"Tables!D367","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Household 4",null,null,null,null,null,null,null,null,"Limit","Financier"]
[null,null,null,"Existing Loans (non SMSF)","Loan 1 - Existing Secured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 2 - Existing Secured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 3 - Existing Secured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 4 - Existing Unsecured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 5 - Existing Unsecured",null,null,null,null,null,null,null,0,"",null,null,0]
[null,null,null,null,"Loan 6 - Existing Unsecured",null,null,null,null,null,null,null,0,"",null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Credit Limits",null,null,0]
[null,null,null,"Credit Cards",null,null,null,null,null,null,null,null,0,"(@3.82%)",null,0,{"$f":"M162*3.82%","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Maintenance / On Going Rent",null,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[null,null,null,"Other Fixed Monthly Repayments",null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Total Monthly Surplus Funds Household 4 (After Buffering)",null,null,null,null,null,null,null,null,{"$f":"Tables!E375","v":""},null,null,null,{"$f":"Tables!E367","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SMSF Debt Servicing Ratio",null,null,"(DSR)"]
[null,null,null,"This Serviceability Calculator is intended as a guide only and no loan approval can be assumed on the basis of the results of this calculator. All applications remain subject to the normal credit and approval criteria of RedZed Lending Solutions Pty Ltd.",null,null,null,null,null,null,null,null,null,"Fail",null,null,{"$f":"IFERROR('Serviceability Calc'!G25,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"For SMSF Level Servicing DSR must be >1.00"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DSR"]
[null,null,null,null,null,null,null,null,null,"SMSF + Member Debt Servicing Ratio",null,null,null,"Fail",null,null,{"$f":"IFERROR(IF(Tables!F368,'Serviceability Calc'!J24,\"N/A\"),0)","v":0}]
[null,null,null,null,null,null,null,null,null,"SMSF + Member Level Servicing DSR must be > 1.10"]
[]
[]
[]
[null,null,null,"I, the Introducer, confirm that reasonable enquiries about the member(s) current and ongoing financial situation have been undertaken and are reflected in the figures entered into this calculation. The member(s) have been given sufficient time to consider the declared monthly living expenses amount which has been derived following due consideration."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Version Control'!I1","v":"v1.6 250108"}]

{"sheet":"HEM","index":3,"n_rows":56,"n_cols":18,"rows_kept":56,"cut":false,"hidden":true,"merged":[[18,3,18,4]]}
["Income Range ($)","Single Adult","Single Adult +1","Single Adult +2","Single Adult +3","Single Adult +4","Single Adult +5","Single Adult +6","Couple","Couple +1","Couple +2","Couple +3","Couple +4","Couple +5","Couple +6"]
["0 - 26,000",1328,1851,2350,2912,3344,4124,4872,2579,2995,3340,3739,4304,4645,4987]
["26,001 - 39,000",1400,1851,2350,2912,3344,4124,4872,2579,2995,3340,3739,4304,4645,4987]
["39,001 - 52,000",1463,1916,2414,2912,3344,4124,4872,2643,2995,3340,3739,4304,4645,4987]
["52,001 - 64,000",1586,2041,2538,3036,3472,4124,4872,2765,3117,3463,3739,4304,4645,4987]
["64,001 - 77,000",1757,2216,2713,3209,3651,4124,4872,2937,3288,3635,3910,4304,4645,4987]
["77,001 - 103,000",2014,2478,2974,3469,3919,4395,4872,3194,3545,3894,4167,4561,4902,5244]
["103,001 - 129,000",2393,2864,3358,3852,4313,4794,5274,3572,3922,4273,4546,4939,5280,5622]
["129,001 - 155,000",2717,3195,3688,4180,4652,5135,5619,3897,4246,4599,4870,5263,5604,5946]
["155,001 - 180,000",3070,3556,4046,4537,5020,5507,5994,4250,4598,4954,5223,5616,5957,6299]
["180,001 - 206,000",3276,3766,4255,4745,5235,5724,6214,4456,4804,5160,5429,5822,6163,6504]
["206,001 - 258,000",3558,4053,4542,5030,5528,6021,6513,4738,5085,5443,5711,6103,6445,6786]
["258,001 - 322,000",4052,4557,5043,5529,6043,6541,7039,5232,5578,5939,6205,6597,6938,7279]
["322,001 - 386,000",4793,5313,5796,6278,6815,7321,7826,5973,6317,6683,6946,7337,7678,8019]
["386,001 - 644,000",4885,5407,5889,6371,6911,7418,7925,6065,6409,6775,7038,7429,7770,8111]
[]
[]
[]
["Income Range lookup","Row Offset Value",null,"Dependents/Household Number",null,1,2,3,4,5,6,7]
[26001,1,null,0,null,0,7,13,13,13,13,13]
[39001,2,null,1,null,1,8,13,13,13,13,13]
[52001,3,null,2,null,2,9,13,13,13,13,13]
[64001,4,null,3,null,3,10,13,13,13,13,13]
[77001,5,null,4,null,4,11,13,13,13,13,13]
[103001,6,null,5,null,5,12,13,13,13,13,13]
[129001,7,null,6,null,6,13,13,13,13,13,13]
[155001,8,null,7,null,13,13,13,13,13,13,13]
[180001,9,null,8,null,13,13,13,13,13,13,13]
[206001,10,null,9,null,13,13,13,13,13,13,13]
[258001,11,null,10,null,13,13,13,13,13,13,13]
[322001,12,null,11,null,13,13,13,13,13,13,13]
[386001,13,null,12,null,13,13,13,13,13,13,13]
[]
[]
[]
[]
[]
[]
[null,null,null,"Household 1",null,null,null,"Household 2"]
[null,null,null,"Gross Income",null,{"$f":"IF(EXACT(Serviceability!E13,D39),Serviceability!I13,0)+IF(EXACT(Serviceability!E14, D39),Serviceability!I14,0)+IF(EXACT(Serviceability!E15, D39),Serviceability!I15,0)+IF(EXACT(Serviceability!E16, D39),Serviceability!I16,0)+IF(EXACT(Serviceability!H19, D39),Serviceability!N19*12,0)+IF(EXACT(Serviceability!H20, D39),Serviceability!N20*12,0)+IF(EXACT(Serviceability!H21, D39),Serviceability!N21*12,0)+IF(EXACT(Serviceability!H22, D39),Serviceability!N22*12,0)","v":0},null,"Gross Income",null,{"$f":"IF(EXACT(Serviceability!E13, H39),Serviceability!I13,0)+IF(EXACT(Serviceability!E14,H39),Serviceability!I14,0)+IF(EXACT(Serviceability!E15,H39),Serviceability!I15,0)+IF(EXACT(Serviceability!E16,H39),Serviceability!I16,0)+IF(EXACT(Serviceability!H19, H39),Serviceability!N19*12,0)+IF(EXACT(Serviceability!H20, H39),Serviceability!N20*12,0)+IF(EXACT(Serviceability!H21, H39),Serviceability!N21*12,0)+IF(EXACT(Serviceability!H22, H39),Serviceability!N22*12,0)","v":0}]
[null,null,null,"Single/Couple",null,{"$f":"+Serviceability!$I$42","v":0},null,"Single/Couple",null,{"$f":"Serviceability!I44","v":0}]
[null,null,null,"Dependents",null,{"$f":"+Serviceability!$I$43","v":0},null,"Dependents",null,{"$f":"Serviceability!I45","v":0}]
[null,null,null,"HEM Row Offset Value",null,{"$f":"IFERROR(VLOOKUP(F40,HEM!$A$20:$B$32,2,TRUE),0)","v":0},null,"HEM Row Offset Value",null,{"$f":"IFERROR(VLOOKUP(J40,HEM!$A$20:$B$32,2,TRUE),0)","v":0}]
[null,null,null,"HEM Column Offset Value",null,{"$f":"OFFSET($E$20,F42,F41)","v":0},null,"HEM Column Offset Value",null,{"$f":"OFFSET($E$20,J42,J41)","v":0}]
[null,null,null,"HEM Starting Value",null,{"$f":"OFFSET(B2,0,0)","v":1328},null,"HEM Starting Value",null,{"$f":"OFFSET(B2,0,0)","v":1328}]
[null,null,null,"HEM Min Living Expense",null,{"$f":"IF(F40=0, 0, OFFSET($B$2,F43,F44))","v":0},null,"HEM Min Living Expense",null,{"$f":"IF(J40=0,0,OFFSET($B$2,J43,J44))","v":0}]
[]
[]
[null,null,null,"Household 1",null,null,null,"Household 2",null,null,null,"Household 3",null,null,null,"Household 4"]
[null,null,null,"Gross Income",null,{"$f":"IF(EXACT('Member Serviceability Calc'!E26,D49),'Member Serviceability Calc'!L26,0)+IF(EXACT('Member Serviceability Calc'!E26, D49),'Member Serviceability Calc'!Q32*12,0)+IF(EXACT('Member Serviceability Calc'!E27,D49),'Member Serviceability Calc'!L27,0)+IF(EXACT('Member Serviceability Calc'!E27, D49),'Member Serviceability Calc'!Q33*12,0)+IF(EXACT('Member Serviceability Calc'!E28,D49),'Member Serviceability Calc'!L28,0)+IF(EXACT('Member Serviceability Calc'!E28, D49),'Member Serviceability Calc'!Q34*12,0)+IF(EXACT('Member Serviceability Calc'!E29,D49),'Member Serviceability Calc'!L29,0)+IF(EXACT('Member Serviceability Calc'!E29, D49),'Member Serviceability Calc'!Q35*12,0)","v":0},null,"Gross Income",null,{"$f":"IF(EXACT('Member Serviceability Calc'!E26,H49),'Member Serviceability Calc'!L26,0)+IF(EXACT('Member Serviceability Calc'!E26, H49),'Member Serviceability Calc'!Q32*12,0)+IF(EXACT('Member Serviceability Calc'!E27,H49),'Member Serviceability Calc'!L27,0)+IF(EXACT('Member Serviceability Calc'!E27, H49),'Member Serviceability Calc'!Q33*12,0)+IF(EXACT('Member Serviceability Calc'!E28,H49),'Member Serviceability Calc'!L28,0)+IF(EXACT('Member Serviceability Calc'!E28, H49),'Member Serviceability Calc'!Q34*12,0)+IF(EXACT('Member Serviceability Calc'!E29,H49),'Member Serviceability Calc'!L29,0)+IF(EXACT('Member Serviceability Calc'!E29, H49),'Member Serviceability Calc'!Q35*12,0)","v":0},null,"Gross Income",null,{"$f":"IF(EXACT('Member Serviceability Calc'!E26,L49),'Member Serviceability Calc'!L26,0)+IF(EXACT('Member Serviceability Calc'!E26, L49),'Member Serviceability Calc'!Q32*12,0)+IF(EXACT('Member Serviceability Calc'!E27,L49),'Member Serviceability Calc'!L27,0)+IF(EXACT('Member Serviceability Calc'!E27, L49),'Member Serviceability Calc'!Q33*12,0)+IF(EXACT('Member Serviceability Calc'!E28,L49),'Member Serviceability Calc'!L28,0)+IF(EXACT('Member Serviceability Calc'!E28, L49),'Member Serviceability Calc'!Q34*12,0)+IF(EXACT('Member Serviceability Calc'!E29,L49),'Member Serviceability Calc'!L29,0)+IF(EXACT('Member Serviceability Calc'!E29, L49),'Member Serviceability Calc'!Q35*12,0)","v":0},null,"Gross Income",null,{"$f":"IF(EXACT('Member Serviceability Calc'!E26,P49),'Member Serviceability Calc'!L26,0)+IF(EXACT('Member Serviceability Calc'!E26, P49),'Member Serviceability Calc'!Q32*12,0)+IF(EXACT('Member Serviceability Calc'!E27,P49),'Member Serviceability Calc'!L27,0)+IF(EXACT('Member Serviceability Calc'!E27, P49),'Member Serviceability Calc'!Q33*12,0)+IF(EXACT('Member Serviceability Calc'!E28,P49),'Member Serviceability Calc'!L28,0)+IF(EXACT('Member Serviceability Calc'!E28, P49),'Member Serviceability Calc'!Q34*12,0)+IF(EXACT('Member Serviceability Calc'!E29,P49),'Member Serviceability Calc'!L29,0)+IF(EXACT('Member Serviceability Calc'!E29, P49),'Member Serviceability Calc'!Q35*12,0)","v":0}]
[null,null,null,"Single/Couple",null,{"$f":"+'Member Serviceability Calc'!O76","v":0},null,"Single/Couple",null,{"$f":"+'Member Serviceability Calc'!O79","v":0},null,"Single/Couple",null,{"$f":"+'Member Serviceability Calc'!O82","v":0},null,"Single/Couple",null,{"$f":"+'Member Serviceability Calc'!O85","v":0}]
[null,null,null,"Dependents",null,{"$f":"+'Member Serviceability Calc'!O77","v":0},null,"Dependents",null,{"$f":"+'Member Serviceability Calc'!O80","v":0},null,"Dependents",null,{"$f":"+'Member Serviceability Calc'!O83","v":0},null,"Dependents",null,{"$f":"+'Member Serviceability Calc'!O86","v":0}]
[null,null,null,"HEM Row Offset Value",null,{"$f":"IFERROR(VLOOKUP(F50,HEM!$A$20:$B$32,2,TRUE),0)","v":0},null,"HEM Row Offset Value",null,{"$f":"IFERROR(VLOOKUP(J50,HEM!$A$20:$B$32,2,TRUE),0)","v":0},null,"HEM Row Offset Value",null,{"$f":"IFERROR(VLOOKUP(N50,HEM!$A$20:$B$32,2,TRUE),0)","v":0},null,"HEM Row Offset Value",null,{"$f":"IFERROR(VLOOKUP(R50,HEM!$A$20:$B$32,2,TRUE),0)","v":0}]
[null,null,null,"HEM Column Offset Value",null,{"$f":"OFFSET($E$20,F52,F51)","v":0},null,"HEM Column Offset Value",null,{"$f":"OFFSET($E$20,J52,J51)","v":0},null,"HEM Column Offset Value",null,{"$f":"OFFSET($E$20,N52,N51)","v":0},null,"HEM Column Offset Value",null,{"$f":"OFFSET($E$20,R52,R51)","v":0}]
[null,null,null,"HEM Starting Value",null,{"$f":"OFFSET(B2,0,0)","v":1328},null,"HEM Starting Value",null,{"$f":"OFFSET(B2,0,0)","v":1328},null,"HEM Starting Value",null,{"$f":"OFFSET(B2,0,0)","v":1328},null,"HEM Starting Value",null,{"$f":"OFFSET(B2,0,0)","v":1328}]
[null,null,null,"HEM Min Living Expense",null,{"$f":"IF(F50=0, 0, OFFSET($B$2,F53,F54))","v":0},null,"HEM Min Living Expense",null,{"$f":"IF(J50=0,0,OFFSET($B$2,J53,J54))","v":0},null,"HEM Min Living Expense",null,{"$f":"IF(N50=0, 0, OFFSET($B$2,N53,N54))","v":0},null,"HEM Min Living Expense",null,{"$f":"IF(R50=0,0,OFFSET($B$2,R53,R54))","v":0}]

{"sheet":"Tables","index":4,"n_rows":415,"n_cols":15,"rows_kept":415,"cut":false,"hidden":true,"merged":[[70,5,70,6],[70,1,70,2],[70,7,70,8],[329,1,329,2],[338,1,338,2]]}
[]
["Tax"]
[null,null,null,null,null,null,"Flood Levy"]
["Wages Over","Not to Exceed","Tax Rate",null,null,null,"Taxable income","Flood levy on this income"]
[0,18200,0,null,null,null,"$0 to $50,000","Nil",0,50000,0]
[{"$f":"B5+1","v":18201},45000,0.16,{"$f":"D5+C5*(B5-A5)","v":0},null,null,"$50,001 to $100,000","Half a cent for each $1 over $50,000",50001,100000,0,{"$f":"(J6-J5)*K6","v":0}]
[{"$f":"B6+1","v":45001},135000,0.3,{"$f":"ROUNDUP(D6+C6*(B6-A6),0)","v":4288},null,null,"Over $100,000","$250 plus 1c for each $1 over $100,000",{"$f":"J6+1","v":100001},null,0]
[{"$f":"B7+1","v":135001},190000,0.37,{"$f":"ROUNDUP(D7+C7*(B7-A7),0)","v":31288}]
[{"$f":"B8+1","v":190001},null,0.45,{"$f":"ROUNDUP(D8+C8*(B8-A8),0)","v":51638}]
[null,null,null,null,null,null,"                        "]
[null,null,null,null,null,null,"   "]
["Medicare Levy"]
[null,null,null,null,null,null,"Taxable income","Tax on this income"]
[0,16284,0,null,"not currently used",null,"0 - $18,200","Nil"]
[16284,17604,0.2,null,null,null,"$18,201 - $37,000","19c for each $1 over $18,200"]
["17604+",null,0.02,null,null,null,"$37,001 - $90,000","$3,572 plus 32.5c for each $1 over $37,000"]
[null,null,null,null,null,null,"$90,001 - $180,000","$17,547 plus 37c for each $1 over $87,000"]
[null,null,null,null,null,null,"$180,001 and over","$54,547 plus 45c for each $1 over $180,000"]
[]
["Company Tax"]
[]
["Rate",0.27500000000000002]
[]
[]
[]
[]
[]
["APR Buffer",0.02]
["Minimum Rate",7.0000000000000007E-2]
[]
["RedZed Loan Applied For: Repayment With Buffer",null,"Buffered %","Minimum %","Rate %","Buffer %","Buffered %","Total Term","Interest Only Term","Net Term","Amount"]
["Buffered Loan 1",{"$f":"IF(Serviceability!J56=0,0,-PMT((D32)/12,J32*12,Serviceability!I56))","v":0},{"$f":"G32","v":0.02},{"$f":"IF(C32>=$B$29,C32,$B$29)","v":7.0000000000000007E-2},{"$f":"Serviceability!L56","v":0},{"$f":"$B$28","v":0.02},{"$f":"E32+F32","v":0.02},{"$f":"Serviceability!J56","v":0},{"$f":"Serviceability!K56","v":0},{"$f":"H32-I32","v":0},{"$f":"Serviceability!I56","v":0}]
["Buffered Loan 2",{"$f":"IF(Serviceability!J57=0,0,-PMT((D33)/12,J33*12,Serviceability!I57))","v":0},{"$f":"G33","v":0.02},{"$f":"IF(C33>=$B$29,C33,$B$29)","v":7.0000000000000007E-2},{"$f":"Serviceability!L57","v":0},{"$f":"$B$28","v":0.02},{"$f":"E33+F33","v":0.02},{"$f":"Serviceability!J57","v":0},{"$f":"Serviceability!K57","v":0},{"$f":"H33-I33","v":0}]
["Buffered Loan 3",{"$f":"IF(Serviceability!J58=0,0,-PMT((D34)/12,J34*12,Serviceability!I58))","v":0},{"$f":"G34","v":0.02},{"$f":"IF(C34>=$B$29,C34,$B$29)","v":7.0000000000000007E-2},{"$f":"Serviceability!L58","v":0},{"$f":"$B$28","v":0.02},{"$f":"E34+F34","v":0.02},{"$f":"Serviceability!J58","v":0},{"$f":"Serviceability!K58","v":0},{"$f":"H34-I34","v":0},{"$f":"Serviceability!I58","v":0}]
[]
[]
["Existing Loan: Repayment With Buffer"]
["Buffered Loan 1",0.2,{"$f":"Serviceability!N61*(1+Tables!B38)","v":0},null,null,null,{"$f":"Serviceability!N61","v":0},{"$f":"Serviceability!E61","v":"Loan 1 - Existing Secured"}]
["Buffered Loan 2",0.2,{"$f":"Serviceability!N62*(1+Tables!B39)","v":0},null,null,null,{"$f":"Serviceability!N62","v":0},{"$f":"Serviceability!E62","v":"Loan 2 - Existing Secured"}]
[]
[]
["Additional Fees for Serviceability",null,null,null,null,null," "]
["Fees - Loan 1",15,{"$f":"IF(Serviceability!N56=0,0,15)","v":0},"Monthly Account Keeping Fee Resi",null,null," "]
["Fees - Loan 2",15,{"$f":"IF(Serviceability!N57=0,0,15)","v":0},"Monthly Account Keeping Fee Resi"]
["Fees - Loan 3",15,{"$f":"IF(Serviceability!N58=0,0,15)","v":0},"Monthly Account Keeping Fee Resi",null,null," "]
[]
[]
[]
["Column1","Single Adult","Single Adult + 1 Dependant","Single Adult + 2 Dependants","Single Adult + 3 Dependants","Single Adult + 4 Dependants","Single Adult + 5 Dependants","Single Adult + 6 Dependants","Couple","Couple + 1 Dependant","Couple + 2 Dependants","Couple + 3 Dependants","Couple + 4 Dependants","Couple + 5 Dependants","Couple + 6 Dependants"]
["Income Range ($)","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark"]
["0 - 26,000",1328,1851,2350,2912,3344,4124,4872,2579,2995,3340,3739,4304,4645,4987]
["26,001 - 39,000",1400,1851,2350,2912,3344,4124,4872,2579,2995,3340,3739,4304,4645,4987]
["39,001 - 52,000",1463,1916,2414,2912,3344,4124,4872,2643,2995,3340,3739,4304,4645,4987]
["52,001 - 64,000",1586,2041,2538,3036,3472,4124,4872,2765,3117,3463,3739,4304,4645,4987]
["64,001 - 77,000",1757,2216,2713,3209,3651,4124,4872,2937,3288,3635,3910,4304,4645,4987]
["77,001 - 103,000",2014,2478,2974,3469,3919,4395,4872,3194,3545,3894,4167,4561,4902,5244]
["103,001 - 129,000",2393,2864,3358,3852,4313,4794,5274,3572,3922,4273,4546,4939,5280,5622]
["129,001 - 155,000",2717,3195,3688,4180,4652,5135,5619,3897,4246,4599,4870,5263,5604,5946]
["155,001 - 180,000",3070,3556,4046,4537,5020,5507,5994,4250,4598,4954,5223,5616,5957,6299]
["180,001 - 206,000",3276,3766,4255,4745,5235,5724,6214,4456,4804,5160,5429,5822,6163,6504]
["206,001 - 258,000",3558,4053,4542,5030,5528,6021,6513,4738,5085,5443,5711,6103,6445,6786]
["258,001 - 322,000",4052,4557,5043,5529,6043,6541,7039,5232,5578,5939,6205,6597,6938,7279]
["322,001 - 386,000",4793,5313,5796,6278,6815,7321,7826,5973,6317,6683,6946,7337,7678,8019]
["386,001 - 644,000",4885,5407,5889,6371,6911,7418,7925,6065,6409,6775,7038,7429,7770,8111]
[" "]
[]
[]
[]
[]
["Household 1"]
["Household 2","Monthly Income",null,null,null,"Other Income",null,"Company"]
[]
[null,"Household 1","Household 2",null,null,"Household 1","Household 2",null,"Always Household 1"]
["Applicant / Guarantor 1",{"$f":"IF(EXACT(Serviceability!E13, \"Household 1\"),Serviceability!I13,0)","v":0},{"$f":"IF(EXACT(Serviceability!E13, \"Household 2\"),Serviceability!I13,0)","v":0},null,"Applicant / Guarantor 1",{"$f":"IF(EXACT(Serviceability!H19, \"Household 1\"),Serviceability!N19,0)","v":0},{"$f":"IF(EXACT(Serviceability!H19, \"Household 2\"),Serviceability!N19,0)","v":0},"Applicant / Guarantor 1",{"$f":"Serviceability!I30","v":0}]
["Applicant / Guarantor 2",{"$f":"IF(EXACT(Serviceability!E14, \"Household 1\"),Serviceability!I14,0)","v":0},{"$f":"IF(EXACT(Serviceability!E14, \"Household 2\"),Serviceability!I14,0)","v":0},null,"Applicant / Guarantor 2",{"$f":"IF(EXACT(Serviceability!H20, \"Household 1\"),Serviceability!N20,0)","v":0},{"$f":"IF(EXACT(Serviceability!H20, \"Household 2\"),Serviceability!N20,0)","v":0}]
["Applicant / Guarantor 3",{"$f":"IF(EXACT(Serviceability!E15, \"Household 1\"),Serviceability!I15,0)","v":0},{"$f":"IF(EXACT(Serviceability!E15, \"Household 2\"),Serviceability!I15,0)","v":0},null,"Applicant / Guarantor 3",{"$f":"IF(EXACT(Serviceability!H21, \"Household 1\"),Serviceability!N21,0)","v":0},{"$f":"IF(EXACT(Serviceability!H21, \"Household 2\"),Serviceability!N21,0)","v":0}]
["Applicant / Guarantor 4",{"$f":"IF(EXACT(Serviceability!E16, \"Household 1\"),Serviceability!I16,0)","v":0},{"$f":"IF(EXACT(Serviceability!E16, \"Household 2\"),Serviceability!I16,0)","v":0},null,"Applicant / Guarantor 4",{"$f":"IF(EXACT(Serviceability!H22, \"Household 1\"),Serviceability!N22,0)","v":0},{"$f":"IF(EXACT(Serviceability!H22, \"Household 2\"),Serviceability!N22,0)","v":0}]
["Applicant Totals",{"$f":"SUM(B74:B77,F78,I74)","v":0},{"$f":"SUM(C74:C77,G78)","v":0},null,"Applicant Totals",{"$f":"SUM(F74:F77)*12","v":0},{"$f":"SUM(G74:G77)*12","v":0}]
[]
["Adults - household","",{"$f":"IF(C78<=59999,\"test\",IF(B3>93,\"A\",IF(B3>89,\"A-\",IF(B3>87,\"B+\",IF(B3>83,\"B\",IF(B3>79,\"B-\", IF(B3>77,\"C+\",IF(B3>73,\"C\",IF(B3>69,\"C-\",IF(B3>57,\"D+\",IF(B3>53,\"D\",IF(B3>49,\"D-\",\"\"))))))))))))","v":"test"}]
["Adults - household - new",{"$error":"#REF!"}]
["Dependant children - household"]
[]
["Adult",{"$f":"Serviceability!I42","v":0},{"$f":"Serviceability!I44","v":0},null,{"$f":"IF(Serviceability!I42>2, \"Please call 1300 722 462 for assistance with calculation \",\" \")","v":" "},null,null,null,null,null,null,null,null,"offset amount"]
["Dependent ",{"$f":"Serviceability!I43","v":0},{"$f":"Serviceability!I45","v":0},null,{"$f":"IF(Serviceability!I44>2, \"Please call 1300 722 462 for assistance with calculation \",\" \")","v":" "}]
[null,{"$f":"\"Adult-\" & B84 & \",Dependents-\" & B85","v":"Adult-0,Dependents-0"},{"$f":"\"Adult-\" & C84 & \",Dependents-\" & C85","v":"Adult-0,Dependents-0"}]
[]
["LookupKey","Household","Income Range","Living Expense"]
[{"$f":"B89 & \":\" & C89","v":"Adult-1,Dependents-0:0 - 26,000"},"Adult-1,Dependents-0","0 - 26,000",1328]
[{"$f":"B90 & \":\" & C90","v":"Adult-1,Dependents-0:26,001 - 39,000"},"Adult-1,Dependents-0","26,001 - 39,000",1400]
["Adult-1,Dependents-0:39,001 - 52,000","Adult-1,Dependents-0","39,001 - 52,000",1463]
["Adult-1,Dependents-0:52,001 - 64,000","Adult-1,Dependents-0","52,001 - 64,000",1586]
["Adult-1,Dependents-0:64,001 - 77,000","Adult-1,Dependents-0","64,001 - 77,000",1757]
["Adult-1,Dependents-0:77,001 - 103,000","Adult-1,Dependents-0","77,001 - 103,000",2014]
["Adult-1,Dependents-0:103,001 - 129,000","Adult-1,Dependents-0","103,001 - 129,000",2393]
["Adult-1,Dependents-0:129,001 - 155,000","Adult-1,Dependents-0","129,001 - 155,000",2717]
["Adult-1,Dependents-0:155,001 - 180,000","Adult-1,Dependents-0","155,001 - 180,000",3070]
["Adult-1,Dependents-0:180,001 - 206,000","Adult-1,Dependents-0","180,001 - 206,000",3276]
["Adult-1,Dependents-0:206,001 - 258,000","Adult-1,Dependents-0","206,001 - 258,000",3558]
["Adult-1,Dependents-0:258,001 - 322,000","Adult-1,Dependents-0","258,001 - 322,000",4052]
["Adult-1,Dependents-0:322,001 - 386,000","Adult-1,Dependents-0","322,001 - 386,000",4793]
["Adult-1,Dependents-0:386,001 - 644,000","Adult-1,Dependents-0","386,001 - 644,000",4885]
[]
["Adult-1,Dependents-1:0 - 26,000","Adult-1,Dependents-1","0 - 26,000",1851]
["Adult-1,Dependents-1:26,001 - 39,000","Adult-1,Dependents-1","26,001 - 39,000",1851]
["Adult-1,Dependents-1:39,001 - 52,000","Adult-1,Dependents-1","39,001 - 52,000",1916]
["Adult-1,Dependents-1:52,001 - 64,000","Adult-1,Dependents-1","52,001 - 64,000",2041]
["Adult-1,Dependents-1:64,001 - 77,000","Adult-1,Dependents-1","64,001 - 77,000",2216]
["Adult-1,Dependents-1:77,001 - 103,000","Adult-1,Dependents-1","77,001 - 103,000",2478]
["Adult-1,Dependents-1:103,001 - 129,000","Adult-1,Dependents-1","103,001 - 129,000",2864]
["Adult-1,Dependents-1:129,001 - 155,000","Adult-1,Dependents-1","129,001 - 155,000",3195]
["Adult-1,Dependents-1:155,001 - 180,000","Adult-1,Dependents-1","155,001 - 180,000",3556]
["Adult-1,Dependents-1:180,001 - 206,000","Adult-1,Dependents-1","180,001 - 206,000",3766]
["Adult-1,Dependents-1:206,001 - 258,000","Adult-1,Dependents-1","206,001 - 258,000",4053]
["Adult-1,Dependents-1:258,001 - 322,000","Adult-1,Dependents-1","258,001 - 322,000",4557]
["Adult-1,Dependents-1:322,001 - 386,000","Adult-1,Dependents-1","322,001 - 386,000",5313]
["Adult-1,Dependents-1:386,001 - 644,000","Adult-1,Dependents-1","386,001 - 644,000",5407]
[]
[{"$f":"B119 & \":\" & C119","v":"Adult-1,Dependents-2:0 - 26,000"},"Adult-1,Dependents-2","0 - 26,000",2350]
["Adult-1,Dependents-2:26,001 - 39,000","Adult-1,Dependents-2","26,001 - 39,000",2350]
["Adult-1,Dependents-2:39,001 - 52,000","Adult-1,Dependents-2","39,001 - 52,000",2414]
["Adult-1,Dependents-2:52,001 - 64,000","Adult-1,Dependents-2","52,001 - 64,000",2538]
["Adult-1,Dependents-2:64,001 - 77,000","Adult-1,Dependents-2","64,001 - 77,000",2713]
["Adult-1,Dependents-2:77,001 - 103,000","Adult-1,Dependents-2","77,001 - 103,000",2974]
["Adult-1,Dependents-2:103,001 - 129,000","Adult-1,Dependents-2","103,001 - 129,000",3358]
["Adult-1,Dependents-2:129,001 - 155,000","Adult-1,Dependents-2","129,001 - 155,000",3688]
["Adult-1,Dependents-2:155,001 - 180,000","Adult-1,Dependents-2","155,001 - 180,000",4046]
["Adult-1,Dependents-2:180,001 - 206,000","Adult-1,Dependents-2","180,001 - 206,000",4255]
["Adult-1,Dependents-2:206,001 - 258,000","Adult-1,Dependents-2","206,001 - 258,000",4542]
["Adult-1,Dependents-2:258,001 - 322,000","Adult-1,Dependents-2","258,001 - 322,000",5043]
["Adult-1,Dependents-2:322,001 - 386,000","Adult-1,Dependents-2","322,001 - 386,000",5796]
["Adult-1,Dependents-2:386,001 - 644,000","Adult-1,Dependents-2","386,001 - 644,000",5889]
[]
[{"$f":"B134 & \":\" & C134","v":"Adult-1,Dependents-3:0 - 26,000"},"Adult-1,Dependents-3","0 - 26,000",2912]
["Adult-1,Dependents-3:26,001 - 39,000","Adult-1,Dependents-3","26,001 - 39,000",2912]
["Adult-1,Dependents-3:39,001 - 52,000","Adult-1,Dependents-3","39,001 - 52,000",2912]
["Adult-1,Dependents-3:52,001 - 64,000","Adult-1,Dependents-3","52,001 - 64,000",3036]
["Adult-1,Dependents-3:64,001 - 77,000","Adult-1,Dependents-3","64,001 - 77,000",3209]
["Adult-1,Dependents-3:77,001 - 103,000","Adult-1,Dependents-3","77,001 - 103,000",3469]
["Adult-1,Dependents-3:103,001 - 129,000","Adult-1,Dependents-3","103,001 - 129,000",3852]
["Adult-1,Dependents-3:129,001 - 155,000","Adult-1,Dependents-3","129,001 - 155,000",4180]
["Adult-1,Dependents-3:155,001 - 180,000","Adult-1,Dependents-3","155,001 - 180,000",4537]
["Adult-1,Dependents-3:180,001 - 206,000","Adult-1,Dependents-3","180,001 - 206,000",4745]
["Adult-1,Dependents-3:206,001 - 258,000","Adult-1,Dependents-3","206,001 - 258,000",5030]
["Adult-1,Dependents-3:258,001 - 322,000","Adult-1,Dependents-3","258,001 - 322,000",5529]
["Adult-1,Dependents-3:322,001 - 386,000","Adult-1,Dependents-3","322,001 - 386,000",6278]
["Adult-1,Dependents-3:386,001 - 644,000","Adult-1,Dependents-3","386,001 - 644,000",6371]
[]
[]
[{"$f":"B150 & \":\" & C150","v":"Adult-1,Dependents-4:0 - 26,000"},"Adult-1,Dependents-4","0 - 26,000",3344]
["Adult-1,Dependents-4:26,001 - 39,000","Adult-1,Dependents-4","26,001 - 39,000",3344]
["Adult-1,Dependents-4:39,001 - 52,000","Adult-1,Dependents-4","39,001 - 52,000",3344]
["Adult-1,Dependents-4:52,001 - 64,000","Adult-1,Dependents-4","52,001 - 64,000",3472]
["Adult-1,Dependents-4:64,001 - 77,000","Adult-1,Dependents-4","64,001 - 77,000",3651]
["Adult-1,Dependents-4:77,001 - 103,000","Adult-1,Dependents-4","77,001 - 103,000",3919]
["Adult-1,Dependents-4:103,001 - 129,000","Adult-1,Dependents-4","103,001 - 129,000",4313]
["Adult-1,Dependents-4:129,001 - 155,000","Adult-1,Dependents-4","129,001 - 155,000",4652]
["Adult-1,Dependents-4:155,001 - 180,000","Adult-1,Dependents-4","155,001 - 180,000",5020]
["Adult-1,Dependents-4:180,001 - 206,000","Adult-1,Dependents-4","180,001 - 206,000",5235]
["Adult-1,Dependents-4:206,001 - 258,000","Adult-1,Dependents-4","206,001 - 258,000",5528]
["Adult-1,Dependents-4:258,001 - 322,000","Adult-1,Dependents-4","258,001 - 322,000",6043]
["Adult-1,Dependents-4:322,001 - 386,000","Adult-1,Dependents-4","322,001 - 386,000",6815]
["Adult-1,Dependents-4:386,001 - 644,000","Adult-1,Dependents-4","386,001 - 644,000",6911]
[]
[{"$f":"B165 & \":\" & C165","v":"Adult-1,Dependents-5:0 - 26,000"},"Adult-1,Dependents-5","0 - 26,000",4124]
["Adult-1,Dependents-5:26,001 - 39,000","Adult-1,Dependents-5","26,001 - 39,000",4124]
["Adult-1,Dependents-5:39,001 - 52,000","Adult-1,Dependents-5","39,001 - 52,000",4124]
["Adult-1,Dependents-5:52,001 - 64,000","Adult-1,Dependents-5","52,001 - 64,000",4124]
["Adult-1,Dependents-5:64,001 - 77,000","Adult-1,Dependents-5","64,001 - 77,000",4124]
["Adult-1,Dependents-5:77,001 - 103,000","Adult-1,Dependents-5","77,001 - 103,000",4395]
["Adult-1,Dependents-5:103,001 - 129,000","Adult-1,Dependents-5","103,001 - 129,000",4794]
["Adult-1,Dependents-5:129,001 - 155,000","Adult-1,Dependents-5","129,001 - 155,000",5135]
["Adult-1,Dependents-5:155,001 - 180,000","Adult-1,Dependents-5","155,001 - 180,000",5507]
["Adult-1,Dependents-5:180,001 - 206,000","Adult-1,Dependents-5","180,001 - 206,000",5724]
["Adult-1,Dependents-5:206,001 - 258,000","Adult-1,Dependents-5","206,001 - 258,000",6021]
["Adult-1,Dependents-5:258,001 - 322,000","Adult-1,Dependents-5","258,001 - 322,000",6541]
["Adult-1,Dependents-5:322,001 - 386,000","Adult-1,Dependents-5","322,001 - 386,000",7321]
["Adult-1,Dependents-5:386,001 - 644,000","Adult-1,Dependents-5","386,001 - 644,000",7418]
[]
[{"$f":"B180 & \":\" & C180","v":"Adult-1,Dependents-6:0 - 26,000"},"Adult-1,Dependents-6","0 - 26,000",4872]
["Adult-1,Dependents-6:26,001 - 39,000","Adult-1,Dependents-6","26,001 - 39,000",4872]
["Adult-1,Dependents-6:39,001 - 52,000","Adult-1,Dependents-6","39,001 - 52,000",4872]
["Adult-1,Dependents-6:52,001 - 64,000","Adult-1,Dependents-6","52,001 - 64,000",4872]
["Adult-1,Dependents-6:64,001 - 77,000","Adult-1,Dependents-6","64,001 - 77,000",4872]
["Adult-1,Dependents-6:77,001 - 103,000","Adult-1,Dependents-6","77,001 - 103,000",4872]
["Adult-1,Dependents-6:103,001 - 129,000","Adult-1,Dependents-6","103,001 - 129,000",5274]
["Adult-1,Dependents-6:129,001 - 155,000","Adult-1,Dependents-6","129,001 - 155,000",5619]
["Adult-1,Dependents-6:155,001 - 180,000","Adult-1,Dependents-6","155,001 - 180,000",5994]
["Adult-1,Dependents-6:180,001 - 206,000","Adult-1,Dependents-6","180,001 - 206,000",6214]
["Adult-1,Dependents-6:206,001 - 258,000","Adult-1,Dependents-6","206,001 - 258,000",6513]
["Adult-1,Dependents-6:258,001 - 322,000","Adult-1,Dependents-6","258,001 - 322,000",7039]
["Adult-1,Dependents-6:322,001 - 386,000","Adult-1,Dependents-6","322,001 - 386,000",7826]
["Adult-1,Dependents-6:386,001 - 644,000","Adult-1,Dependents-6","386,001 - 644,000",7925]
[]
[{"$f":"B195 & \":\" & C195","v":"Adult-2,Dependents-0:0 - 26,000"},"Adult-2,Dependents-0","0 - 26,000",2579]
[{"$f":"B196 & \":\" & C196","v":"Adult-2,Dependents-0:26,001 - 39,000"},"Adult-2,Dependents-0","26,001 - 39,000",2579]
["Adult-2,Dependents-0:39,001 - 52,000","Adult-2,Dependents-0","39,001 - 52,000",2643]
["Adult-2,Dependents-0:52,001 - 64,000","Adult-2,Dependents-0","52,001 - 64,000",2765]
["Adult-2,Dependents-0:64,001 - 77,000","Adult-2,Dependents-0","64,001 - 77,000",2937]
["Adult-2,Dependents-0:77,001 - 103,000","Adult-2,Dependents-0","77,001 - 103,000",3194]
["Adult-2,Dependents-0:103,001 - 129,000","Adult-2,Dependents-0","103,001 - 129,000",3572]
["Adult-2,Dependents-0:129,001 - 155,000","Adult-2,Dependents-0","129,001 - 155,000",3897]
["Adult-2,Dependents-0:155,001 - 180,000","Adult-2,Dependents-0","155,001 - 180,000",4250]
["Adult-2,Dependents-0:180,001 - 206,000","Adult-2,Dependents-0","180,001 - 206,000",4456]
["Adult-2,Dependents-0:206,001 - 258,000","Adult-2,Dependents-0","206,001 - 258,000",4738]
["Adult-2,Dependents-0:258,001 - 322,000","Adult-2,Dependents-0","258,001 - 322,000",5232]
["Adult-2,Dependents-0:322,001 - 386,000","Adult-2,Dependents-0","322,001 - 386,000",5973]
["Adult-2,Dependents-0:386,001 - 644,000","Adult-2,Dependents-0","386,001 - 644,000",6065]
[]
[{"$f":"B210 & \":\" & C210","v":"Adult-2,Dependents-1:0 - 26,000"},"Adult-2,Dependents-1","0 - 26,000",2995]
["Adult-2,Dependents-1:26,001 - 39,000","Adult-2,Dependents-1","26,001 - 39,000",2995]
["Adult-2,Dependents-1:39,001 - 52,000","Adult-2,Dependents-1","39,001 - 52,000",2995]
["Adult-2,Dependents-1:52,001 - 64,000","Adult-2,Dependents-1","52,001 - 64,000",3117]
["Adult-2,Dependents-1:64,001 - 77,000","Adult-2,Dependents-1","64,001 - 77,000",3288]
["Adult-2,Dependents-1:77,001 - 103,000","Adult-2,Dependents-1","77,001 - 103,000",3545]
["Adult-2,Dependents-1:103,001 - 129,000","Adult-2,Dependents-1","103,001 - 129,000",3922]
["Adult-2,Dependents-1:129,001 - 155,000","Adult-2,Dependents-1","129,001 - 155,000",4246]
["Adult-2,Dependents-1:155,001 - 180,000","Adult-2,Dependents-1","155,001 - 180,000",4598]
["Adult-2,Dependents-1:180,001 - 206,000","Adult-2,Dependents-1","180,001 - 206,000",4804]
["Adult-2,Dependents-1:206,001 - 258,000","Adult-2,Dependents-1","206,001 - 258,000",5085]
["Adult-2,Dependents-1:258,001 - 322,000","Adult-2,Dependents-1","258,001 - 322,000",5578]
["Adult-2,Dependents-1:322,001 - 386,000","Adult-2,Dependents-1","322,001 - 386,000",6317]
["Adult-2,Dependents-1:386,001 - 644,000","Adult-2,Dependents-1","386,001 - 644,000",6409]
[]
[{"$f":"B225 & \":\" & C225","v":"Adult-2,Dependents-2:0 - 26,000"},"Adult-2,Dependents-2","0 - 26,000",3340]
["Adult-2,Dependents-2:26,001 - 39,000","Adult-2,Dependents-2","26,001 - 39,000",3340]
["Adult-2,Dependents-2:39,001 - 52,000","Adult-2,Dependents-2","39,001 - 52,000",3340]
["Adult-2,Dependents-2:52,001 - 64,000","Adult-2,Dependents-2","52,001 - 64,000",3463]
["Adult-2,Dependents-2:64,001 - 77,000","Adult-2,Dependents-2","64,001 - 77,000",3635]
["Adult-2,Dependents-2:77,001 - 103,000","Adult-2,Dependents-2","77,001 - 103,000",3894]
["Adult-2,Dependents-2:103,001 - 129,000","Adult-2,Dependents-2","103,001 - 129,000",4273]
["Adult-2,Dependents-2:129,001 - 155,000","Adult-2,Dependents-2","129,001 - 155,000",4599]
["Adult-2,Dependents-2:155,001 - 180,000","Adult-2,Dependents-2","155,001 - 180,000",4954]
["Adult-2,Dependents-2:180,001 - 206,000","Adult-2,Dependents-2","180,001 - 206,000",5160]
["Adult-2,Dependents-2:206,001 - 258,000","Adult-2,Dependents-2","206,001 - 258,000",5443]
["Adult-2,Dependents-2:258,001 - 322,000","Adult-2,Dependents-2","258,001 - 322,000",5939]
["Adult-2,Dependents-2:322,001 - 386,000","Adult-2,Dependents-2","322,001 - 386,000",6683]
["Adult-2,Dependents-2:386,001 - 644,000","Adult-2,Dependents-2","386,001 - 644,000",6775]
[]
[{"$f":"B240 & \":\" & C240","v":"Adult-2,Dependents-3:0 - 26,000"},"Adult-2,Dependents-3","0 - 26,000",3739]
["Adult-2,Dependents-3:26,001 - 39,000","Adult-2,Dependents-3","26,001 - 39,000",3739]
["Adult-2,Dependents-3:39,001 - 52,000","Adult-2,Dependents-3","39,001 - 52,000",3739]
["Adult-2,Dependents-3:52,001 - 64,000","Adult-2,Dependents-3","52,001 - 64,000",3739]
["Adult-2,Dependents-3:64,001 - 77,000","Adult-2,Dependents-3","64,001 - 77,000",3910]
["Adult-2,Dependents-3:77,001 - 103,000","Adult-2,Dependents-3","77,001 - 103,000",4167]
["Adult-2,Dependents-3:103,001 - 129,000","Adult-2,Dependents-3","103,001 - 129,000",4546]
["Adult-2,Dependents-3:129,001 - 155,000","Adult-2,Dependents-3","129,001 - 155,000",4870]
["Adult-2,Dependents-3:155,001 - 180,000","Adult-2,Dependents-3","155,001 - 180,000",5223]
["Adult-2,Dependents-3:180,001 - 206,000","Adult-2,Dependents-3","180,001 - 206,000",5429]
["Adult-2,Dependents-3:206,001 - 258,000","Adult-2,Dependents-3","206,001 - 258,000",5711]
["Adult-2,Dependents-3:258,001 - 322,000","Adult-2,Dependents-3","258,001 - 322,000",6205]
["Adult-2,Dependents-3:322,001 - 386,000","Adult-2,Dependents-3","322,001 - 386,000",6946]
["Adult-2,Dependents-3:386,001 - 644,000","Adult-2,Dependents-3","386,001 - 644,000",7038]
[]
[]
[{"$f":"B256 & \":\" & C256","v":"Adult-2,Dependents-4:0 - 26,000"},"Adult-2,Dependents-4","0 - 26,000",4304]
["Adult-2,Dependents-4:26,001 - 39,000","Adult-2,Dependents-4","26,001 - 39,000",4304]
["Adult-2,Dependents-4:39,001 - 52,000","Adult-2,Dependents-4","39,001 - 52,000",4304]
["Adult-2,Dependents-4:52,001 - 64,000","Adult-2,Dependents-4","52,001 - 64,000",4304]
["Adult-2,Dependents-4:64,001 - 77,000","Adult-2,Dependents-4","64,001 - 77,000",4304]
["Adult-2,Dependents-4:77,001 - 103,000","Adult-2,Dependents-4","77,001 - 103,000",4561]
["Adult-2,Dependents-4:103,001 - 129,000","Adult-2,Dependents-4","103,001 - 129,000",4939]
["Adult-2,Dependents-4:129,001 - 155,000","Adult-2,Dependents-4","129,001 - 155,000",5263]
["Adult-2,Dependents-4:155,001 - 180,000","Adult-2,Dependents-4","155,001 - 180,000",5616]
["Adult-2,Dependents-4:180,001 - 206,000","Adult-2,Dependents-4","180,001 - 206,000",5822]
["Adult-2,Dependents-4:206,001 - 258,000","Adult-2,Dependents-4","206,001 - 258,000",6103]
["Adult-2,Dependents-4:258,001 - 322,000","Adult-2,Dependents-4","258,001 - 322,000",6597]
["Adult-2,Dependents-4:322,001 - 386,000","Adult-2,Dependents-4","322,001 - 386,000",7337]
["Adult-2,Dependents-4:386,001 - 644,000","Adult-2,Dependents-4","386,001 - 644,000",7429]
[]
[{"$f":"B271 & \":\" & C271","v":"Adult-2,Dependents-5:0 - 26,000"},"Adult-2,Dependents-5","0 - 26,000",4645]
["Adult-2,Dependents-5:26,001 - 39,000","Adult-2,Dependents-5","26,001 - 39,000",4645]
["Adult-2,Dependents-5:39,001 - 52,000","Adult-2,Dependents-5","39,001 - 52,000",4645]
["Adult-2,Dependents-5:52,001 - 64,000","Adult-2,Dependents-5","52,001 - 64,000",4645]
["Adult-2,Dependents-5:64,001 - 77,000","Adult-2,Dependents-5","64,001 - 77,000",4645]
["Adult-2,Dependents-5:77,001 - 103,000","Adult-2,Dependents-5","77,001 - 103,000",4902]
["Adult-2,Dependents-5:103,001 - 129,000","Adult-2,Dependents-5","103,001 - 129,000",5280]
["Adult-2,Dependents-5:129,001 - 155,000","Adult-2,Dependents-5","129,001 - 155,000",5604]
["Adult-2,Dependents-5:155,001 - 180,000","Adult-2,Dependents-5","155,001 - 180,000",5957]
["Adult-2,Dependents-5:180,001 - 206,000","Adult-2,Dependents-5","180,001 - 206,000",6163]
["Adult-2,Dependents-5:206,001 - 258,000","Adult-2,Dependents-5","206,001 - 258,000",6445]
["Adult-2,Dependents-5:258,001 - 322,000","Adult-2,Dependents-5","258,001 - 322,000",6938]
["Adult-2,Dependents-5:322,001 - 386,000","Adult-2,Dependents-5","322,001 - 386,000",7678]
["Adult-2,Dependents-5:386,001 - 644,000","Adult-2,Dependents-5","386,001 - 644,000",7770]
[]
[{"$f":"B286 & \":\" & C286","v":"Adult-2,Dependents-6:0 - 26,000"},"Adult-2,Dependents-6","0 - 26,000",4987]
["Adult-2,Dependents-6:26,001 - 39,000","Adult-2,Dependents-6","26,001 - 39,000",4987]
["Adult-2,Dependents-6:39,001 - 52,000","Adult-2,Dependents-6","39,001 - 52,000",4987]
["Adult-2,Dependents-6:52,001 - 64,000","Adult-2,Dependents-6","52,001 - 64,000",4987]
["Adult-2,Dependents-6:64,001 - 77,000","Adult-2,Dependents-6","64,001 - 77,000",4987]
["Adult-2,Dependents-6:77,001 - 103,000","Adult-2,Dependents-6","77,001 - 103,000",5244]
["Adult-2,Dependents-6:103,001 - 129,000","Adult-2,Dependents-6","103,001 - 129,000",5622]
["Adult-2,Dependents-6:129,001 - 155,000","Adult-2,Dependents-6","129,001 - 155,000",5946]
["Adult-2,Dependents-6:155,001 - 180,000","Adult-2,Dependents-6","155,001 - 180,000",6299]
["Adult-2,Dependents-6:180,001 - 206,000","Adult-2,Dependents-6","180,001 - 206,000",6504]
["Adult-2,Dependents-6:206,001 - 258,000","Adult-2,Dependents-6","206,001 - 258,000",6786]
["Adult-2,Dependents-6:258,001 - 322,000","Adult-2,Dependents-6","258,001 - 322,000",7279]
["Adult-2,Dependents-6:322,001 - 386,000","Adult-2,Dependents-6","322,001 - 386,000",8019]
["Adult-2,Dependents-6:386,001 - 644,000","Adult-2,Dependents-6","386,001 - 644,000",8111]
[]
[]
[null,"Household 1","Household 2"]
["Household Key",{"$f":"B86","v":"Adult-0,Dependents-0"},{"$f":"C86","v":"Adult-0,Dependents-0"}]
["Salary Key",{"$f":"IF(B78<=0,\"0-26000\",IF(B78<=26000,\"0-26000\",IF(B78<=39000,\"26001-39000\",IF(B78<=52000,\"39001-52000\",IF(B78<=64000,\"52001-64000\",IF(B78<=77000,\"64001-77000\",IF(B78<=103000,\"77001-103000\",IF(B78<=129000,\"103001-129000\",IF(B78<=155000,\"129001-155000\",IF(B78<=180000,\"155001-180000\",IF(B78<=206000,\"180001-206000\",IF(B78<=258000,\"206001-258000\",IF(B78<=322000,\"258001-322000\",IF(B78<=386000,\"322001-386000\",IF(B78>386000,\"386001-644000\",FALSE)))))))))))))))","v":"0-26000"},{"$f":"IF(C78<=0,\"0-26000\",IF(C78<=26000,\"0-26000\",IF(C78<=39000,\"26001-39000\",IF(C78<=52000,\"39001-52000\",IF(C78<=64000,\"52001-64000\",IF(C78<=77000,\"64001-77000\",IF(C78<=103000,\"77001-103000\",IF(C78<=129000,\"103001-129000\",IF(C78<=155000,\"129001-155000\",IF(C78<=180000,\"155001-180000\",IF(C78<=206000,\"180001-206000\",IF(C78<=258000,\"206001-258000\",IF(C78<=322000,\"258001-322000\",IF(C78<=386000,\"322001-386000\",IF(C78>386000,\"386001-644000\",FALSE)))))))))))))))","v":"0-26000"}]
["Household Living Expense",{"$f":"HEM!F46","v":0},{"$f":"HEM!J46","v":0}]
[]
[]
[]
[]
["Monthly expense",{"$f":"MAX(SUM(B305:C305),Serviceability!I39)","v":0}]
[]
[]
["Avaiable Income",{"$f":"Serviceability!N32-Tables!B310","v":0}]
[]
[]
[]
[]
[]
["RedZed Loan Applied For Loan1",{"$f":"IF(Serviceability!J56=0,0,IF(Serviceability!L56=0,0,-PMT((Serviceability!L56)/12,(Serviceability!J56-Serviceability!K56)*12,Serviceability!I56)))","v":0}]
["RedZed Loan Applied For Loan2",{"$f":"IF(Serviceability!J57=0,0,IF(Serviceability!L57=0,0,-PMT((Serviceability!L57)/12,(Serviceability!J57-Serviceability!K57)*12,Serviceability!I57)))","v":0}]
["RedZed Loan Applied For Loan3",{"$f":"IF(Serviceability!J58=0,0,IF(Serviceability!L58=0,0,-PMT((Serviceability!L58)/12,(Serviceability!J58-Serviceability!K58)*12,Serviceability!I58)))","v":0}]
[]
[]
["Super Resi",{"$f":"IF('SMSF Serviceability Calculator'!G10>=1,\"Household 1\",\"Household 1\")","v":"Household 1"},{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER(B324:B327,B324:B327<>\"\"))","v":"Household 1"},{"$f":"C324","v":"Household 1"},"Alt Doc",1,"Yes",{"$f":"IF('SMSF Serviceability Calculator'!E8 = 0, \"\",'SMSF Serviceability Calculator'!E8)","v":" "}]
["Super Commercial",{"$f":"IF('SMSF Serviceability Calculator'!G10>=2,\"Household 2\",\"\")","v":""},null,{"$f":" C325","v":0},"Full Doc",2,"No"]
[null,{"$f":"IF('SMSF Serviceability Calculator'!G10>=3,\"Household 3\",\"\")","v":""},null,{"$f":" C326","v":0},null,3]
[null,{"$f":"IF('SMSF Serviceability Calculator'!G10>=4,\"Household 4\",\"\")","v":""},null,{"$f":" C327","v":0},null,4]
[]
[]
[null,"Monthly Income"]
[]
[null,"Household 1","Household 2","Household 3","Household 4"]
["Annual",{"$f":" IF(EXACT('Member Serviceability Calc'!E26, \"Household 1\"),'Member Serviceability Calc'!L26,0)+IF(EXACT('Member Serviceability Calc'!E27, \"Household 1\"),'Member Serviceability Calc'!L27,0)+IF(EXACT('Member Serviceability Calc'!E28, \"Household 1\"),'Member Serviceability Calc'!L28,0)+IF(EXACT('Member Serviceability Calc'!E29, \"Household 1\"),'Member Serviceability Calc'!L29,0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E26, \"Household 2\"),'Member Serviceability Calc'!L26,0)+IF(EXACT('Member Serviceability Calc'!E27, \"Household 2\"),'Member Serviceability Calc'!L27,0)+IF(EXACT('Member Serviceability Calc'!E28, \"Household 2\"),'Member Serviceability Calc'!L28,0)+IF(EXACT('Member Serviceability Calc'!E29, \"Household 2\"),'Member Serviceability Calc'!L29,0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E26, \"Household 3\"),'Member Serviceability Calc'!L26,0)+IF(EXACT('Member Serviceability Calc'!E27, \"Household 3\"),'Member Serviceability Calc'!L27,0)+IF(EXACT('Member Serviceability Calc'!E28, \"Household 3\"),'Member Serviceability Calc'!L28,0)+IF(EXACT('Member Serviceability Calc'!E29, \"Household 3\"),'Member Serviceability Calc'!L29,0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E26, \"Household 4\"),'Member Serviceability Calc'!L26,0)+IF(EXACT('Member Serviceability Calc'!E27, \"Household 4\"),'Member Serviceability Calc'!L27,0)+IF(EXACT('Member Serviceability Calc'!E28, \"Household 4\"),'Member Serviceability Calc'!L28,0)+IF(EXACT('Member Serviceability Calc'!E29, \"Household 4\"),'Member Serviceability Calc'!L29,0)","v":0}]
["Monthly",{"$f":"IF(EXACT('Member Serviceability Calc'!E26, \"Household 1\"),'Member Serviceability Calc'!Q26,0)+IF(EXACT('Member Serviceability Calc'!E27, \"Household 1\"),'Member Serviceability Calc'!Q27,0)+IF(EXACT('Member Serviceability Calc'!E28, \"Household 1\"),'Member Serviceability Calc'!Q28,0)+IF(EXACT('Member Serviceability Calc'!E29, \"Household 1\"),'Member Serviceability Calc'!Q29,0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E26, \"Household 2\"),'Member Serviceability Calc'!Q26,0)+IF(EXACT('Member Serviceability Calc'!E27, \"Household 2\"),'Member Serviceability Calc'!Q27,0)+IF(EXACT('Member Serviceability Calc'!E28, \"Household 2\"),'Member Serviceability Calc'!Q28,0)+IF(EXACT('Member Serviceability Calc'!E29, \"Household 2\"),'Member Serviceability Calc'!Q29,0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E26, \"Household 3\"),'Member Serviceability Calc'!Q26,0)+IF(EXACT('Member Serviceability Calc'!E27, \"Household 3\"),'Member Serviceability Calc'!Q27,0)+IF(EXACT('Member Serviceability Calc'!E28, \"Household 3\"),'Member Serviceability Calc'!Q28,0)+IF(EXACT('Member Serviceability Calc'!E29, \"Household 3\"),'Member Serviceability Calc'!Q29,0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E26, \"Household 4\"),'Member Serviceability Calc'!Q26,0)+IF(EXACT('Member Serviceability Calc'!E27, \"Household 4\"),'Member Serviceability Calc'!Q27,0)+IF(EXACT('Member Serviceability Calc'!E28, \"Household 4\"),'Member Serviceability Calc'!Q28,0)+IF(EXACT('Member Serviceability Calc'!E29, \"Household 4\"),'Member Serviceability Calc'!Q29,0)","v":0}]
["Member / Guarantor 3",{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
["Member / Guarantor 4",{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
["Annual Totals",{"$f":"SUM(B333,B346)","v":0},{"$f":"SUM(C333,C346)","v":0},{"$f":"SUM(D333,D346)","v":0},{"$f":"SUM(E333,E346)","v":0}]
["Month Totals",{"$f":"B334+B342","v":0},{"$f":"C334+C342","v":0},{"$f":"D334+D342","v":0},{"$f":"E334+E342","v":0}]
[null,"Other Income"]
[null,{"$f":"'Member Serviceability Calc'!Q66","v":0},{"$f":"'Member Serviceability Calc'!Q67","v":0},{"$f":"'Member Serviceability Calc'!Q68","v":0},{"$f":"'Member Serviceability Calc'!Q69","v":0}]
[null,"Household 1","Household 2","Household 3","Household 4"]
["Monthly",{"$f":" IF(EXACT('Member Serviceability Calc'!E26, \"Household 1\"),'Member Serviceability Calc'!Q32,0)+IF(EXACT('Member Serviceability Calc'!E27, \"Household 1\"),'Member Serviceability Calc'!Q33,0)+IF(EXACT('Member Serviceability Calc'!E28, \"Household 1\"),'Member Serviceability Calc'!Q34,0)+IF(EXACT('Member Serviceability Calc'!E29, \"Household 1\"),'Member Serviceability Calc'!Q35,0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E26, \"Household 2\"),'Member Serviceability Calc'!Q32,0)+IF(EXACT('Member Serviceability Calc'!E27, \"Household 2\"),'Member Serviceability Calc'!Q33,0)+IF(EXACT('Member Serviceability Calc'!E28, \"Household 2\"),'Member Serviceability Calc'!Q34,0)+IF(EXACT('Member Serviceability Calc'!E29, \"Household 2\"),'Member Serviceability Calc'!Q35,0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E26, \"Household 3\"),'Member Serviceability Calc'!Q32,0)+IF(EXACT('Member Serviceability Calc'!E27, \"Household 3\"),'Member Serviceability Calc'!Q33,0)+IF(EXACT('Member Serviceability Calc'!E28, \"Household 3\"),'Member Serviceability Calc'!Q34,0)+IF(EXACT('Member Serviceability Calc'!E29, \"Household 3\"),'Member Serviceability Calc'!Q35,0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E26, \"Household 4\"),'Member Serviceability Calc'!Q32,0)+IF(EXACT('Member Serviceability Calc'!E27, \"Household 4\"),'Member Serviceability Calc'!Q33,0)+IF(EXACT('Member Serviceability Calc'!E28, \"Household 4\"),'Member Serviceability Calc'!Q34,0)+IF(EXACT('Member Serviceability Calc'!E29, \"Household 4\"),'Member Serviceability Calc'!Q35,0)","v":0}]
["Applicant / Guarantor 2",{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
["Applicant / Guarantor 3",{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
["Applicant / Guarantor 4",{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
["Applicant Totals",{"$f":"SUM(B342:B345)*12","v":0},{"$f":"SUM(C342:C345)*12","v":0},{"$f":"SUM(D342:D345)*12","v":0},{"$f":"SUM(E342:E345)*12","v":0}]
[]
["Adult",{"$f":"'Member Serviceability Calc'!O76","v":0},{"$f":"'Member Serviceability Calc'!O79","v":0},{"$f":"'Member Serviceability Calc'!O82","v":0},{"$f":"'Member Serviceability Calc'!O85","v":0}]
["Dependent ",{"$f":"'Member Serviceability Calc'!O77","v":0},{"$f":"'Member Serviceability Calc'!O80","v":0},{"$f":"'Member Serviceability Calc'!O83","v":0},{"$f":"'Member Serviceability Calc'!O86","v":0},null,null,null,null,null,null,null,null,"Alt Doc Precentage "]
[null,{"$f":"\"Adult-\" & B348 & \",Dependents-\" & B349","v":"Adult-0,Dependents-0"},{"$f":"\"Adult-\" & C348 & \",Dependents-\" & C349","v":"Adult-0,Dependents-0"},{"$f":"\"Adult-\" & D348 & \",Dependents-\" & D349","v":"Adult-0,Dependents-0"},{"$f":"\"Adult-\" & E348 & \",Dependents-\" & E349","v":"Adult-0,Dependents-0"},null,null,null,"Household 1","Household 2","Household 3","Household 4"]
[null,null,null,null,null,null,null,"Alt Doc",{"$f":"IF(EXACT('Member Serviceability Calc'!E14,I350),IF(EXACT('Member Serviceability Calc'!G14,Tables!H351),'Member Serviceability Calc'!Q14+'Member Serviceability Calc'!Q26+'Member Serviceability Calc'!Q32,0),0)+IF(EXACT('Member Serviceability Calc'!E15,I350),IF(EXACT('Member Serviceability Calc'!G15,Tables!H351),'Member Serviceability Calc'!Q15+'Member Serviceability Calc'!Q27+'Member Serviceability Calc'!Q33,0),0)+IF(EXACT('Member Serviceability Calc'!E16,I350),IF(EXACT('Member Serviceability Calc'!G16,Tables!H351),'Member Serviceability Calc'!Q16+'Member Serviceability Calc'!Q28+'Member Serviceability Calc'!Q34,0),0)+IF(EXACT('Member Serviceability Calc'!E17,I350),IF(EXACT('Member Serviceability Calc'!G17,Tables!H351),'Member Serviceability Calc'!Q17+'Member Serviceability Calc'!Q29+'Member Serviceability Calc'!Q35,0),0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,J350),IF(EXACT('Member Serviceability Calc'!G14,Tables!H351),'Member Serviceability Calc'!Q14+'Member Serviceability Calc'!Q26+'Member Serviceability Calc'!Q32,0),0)+IF(EXACT('Member Serviceability Calc'!E15,J350),IF(EXACT('Member Serviceability Calc'!G15,Tables!H351),'Member Serviceability Calc'!Q15+'Member Serviceability Calc'!Q27+'Member Serviceability Calc'!Q33,0),0)+IF(EXACT('Member Serviceability Calc'!E16,J350),IF(EXACT('Member Serviceability Calc'!G16,Tables!H351),'Member Serviceability Calc'!Q16+'Member Serviceability Calc'!Q28+'Member Serviceability Calc'!Q34,0),0)+IF(EXACT('Member Serviceability Calc'!E17,J350),IF(EXACT('Member Serviceability Calc'!G17,Tables!H351),'Member Serviceability Calc'!Q17+'Member Serviceability Calc'!Q29+'Member Serviceability Calc'!Q35,0),0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,K350),IF(EXACT('Member Serviceability Calc'!G14,Tables!H351),'Member Serviceability Calc'!Q14+'Member Serviceability Calc'!Q26+'Member Serviceability Calc'!Q32,0),0)+IF(EXACT('Member Serviceability Calc'!E15,K350),IF(EXACT('Member Serviceability Calc'!G15,Tables!H351),'Member Serviceability Calc'!Q15+'Member Serviceability Calc'!Q27+'Member Serviceability Calc'!Q33,0),0)+IF(EXACT('Member Serviceability Calc'!E16,K350),IF(EXACT('Member Serviceability Calc'!G16,Tables!H351),'Member Serviceability Calc'!Q16+'Member Serviceability Calc'!Q28+'Member Serviceability Calc'!Q34,0),0)+IF(EXACT('Member Serviceability Calc'!E17,K350),IF(EXACT('Member Serviceability Calc'!G17,Tables!H351),'Member Serviceability Calc'!Q17+'Member Serviceability Calc'!Q29+'Member Serviceability Calc'!Q35,0),0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,L350),IF(EXACT('Member Serviceability Calc'!G14,Tables!H351),'Member Serviceability Calc'!Q14+'Member Serviceability Calc'!Q26+'Member Serviceability Calc'!Q32,0),0)+IF(EXACT('Member Serviceability Calc'!E15,L350),IF(EXACT('Member Serviceability Calc'!G15,Tables!H351),'Member Serviceability Calc'!Q15+'Member Serviceability Calc'!Q27+'Member Serviceability Calc'!Q33,0),0)+IF(EXACT('Member Serviceability Calc'!E16,L350),IF(EXACT('Member Serviceability Calc'!G16,Tables!H351),'Member Serviceability Calc'!Q16+'Member Serviceability Calc'!Q28+'Member Serviceability Calc'!Q34,0),0)+IF(EXACT('Member Serviceability Calc'!E17,L350),IF(EXACT('Member Serviceability Calc'!G17,Tables!H351),'Member Serviceability Calc'!Q17+'Member Serviceability Calc'!Q29+'Member Serviceability Calc'!Q35,0),0)","v":0},{"$f":"SUM(I351:L351)","v":0},{"$f":"M351/SUM(M351:M352,G371)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Full Doc",{"$f":"IF(EXACT('Member Serviceability Calc'!E14,I350),IF(EXACT('Member Serviceability Calc'!G14,H352),'Member Serviceability Calc'!Q14+'Member Serviceability Calc'!Q26+'Member Serviceability Calc'!Q32,0),0)+IF(EXACT('Member Serviceability Calc'!E15,I350),IF(EXACT('Member Serviceability Calc'!G15,H352),'Member Serviceability Calc'!Q15+'Member Serviceability Calc'!Q27+'Member Serviceability Calc'!Q33,0),0)+IF(EXACT('Member Serviceability Calc'!E16,I350),IF(EXACT('Member Serviceability Calc'!G16,H352),'Member Serviceability Calc'!Q16+'Member Serviceability Calc'!Q28+'Member Serviceability Calc'!Q34,0),0)+IF(EXACT('Member Serviceability Calc'!E17,I350),IF(EXACT('Member Serviceability Calc'!G17,H352),'Member Serviceability Calc'!Q17+'Member Serviceability Calc'!Q29+'Member Serviceability Calc'!Q35,0),0)+'Member Serviceability Calc'!Q41","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,J350),IF(EXACT('Member Serviceability Calc'!G14,H352),'Member Serviceability Calc'!Q14+'Member Serviceability Calc'!Q26+'Member Serviceability Calc'!Q32,0),0)+IF(EXACT('Member Serviceability Calc'!E15,J350),IF(EXACT('Member Serviceability Calc'!G15,H352),'Member Serviceability Calc'!Q15+'Member Serviceability Calc'!Q27+'Member Serviceability Calc'!Q33,0),0)+IF(EXACT('Member Serviceability Calc'!E16,J350),IF(EXACT('Member Serviceability Calc'!G16,H352),'Member Serviceability Calc'!Q16+'Member Serviceability Calc'!Q28+'Member Serviceability Calc'!Q34,0),0)+IF(EXACT('Member Serviceability Calc'!E17,J350),IF(EXACT('Member Serviceability Calc'!G17,H352),'Member Serviceability Calc'!Q17+'Member Serviceability Calc'!Q29+'Member Serviceability Calc'!Q35,0),0)+'Member Serviceability Calc'!Q48","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,K350),IF(EXACT('Member Serviceability Calc'!G14,H352),'Member Serviceability Calc'!Q14+'Member Serviceability Calc'!Q26+'Member Serviceability Calc'!Q32,0),0)+IF(EXACT('Member Serviceability Calc'!E15,K350),IF(EXACT('Member Serviceability Calc'!G15,H352),'Member Serviceability Calc'!Q15+'Member Serviceability Calc'!Q27+'Member Serviceability Calc'!Q33,0),0)+IF(EXACT('Member Serviceability Calc'!E16,K350),IF(EXACT('Member Serviceability Calc'!G16,H352),'Member Serviceability Calc'!Q16+'Member Serviceability Calc'!Q28+'Member Serviceability Calc'!Q34,0),0)+IF(EXACT('Member Serviceability Calc'!E17,K350),IF(EXACT('Member Serviceability Calc'!G17,H352),'Member Serviceability Calc'!Q17+'Member Serviceability Calc'!Q29+'Member Serviceability Calc'!Q35,0),0)+'Member Serviceability Calc'!Q55","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,L350),IF(EXACT('Member Serviceability Calc'!G14,H352),'Member Serviceability Calc'!Q14+'Member Serviceability Calc'!Q26+'Member Serviceability Calc'!Q32,0),0)+IF(EXACT('Member Serviceability Calc'!E15,L350),IF(EXACT('Member Serviceability Calc'!G15,H352),'Member Serviceability Calc'!Q15+'Member Serviceability Calc'!Q27+'Member Serviceability Calc'!Q33,0),0)+IF(EXACT('Member Serviceability Calc'!E16,L350),IF(EXACT('Member Serviceability Calc'!G16,H352),'Member Serviceability Calc'!Q16+'Member Serviceability Calc'!Q28+'Member Serviceability Calc'!Q34,0),0)+IF(EXACT('Member Serviceability Calc'!E17,L350),IF(EXACT('Member Serviceability Calc'!G17,H352),'Member Serviceability Calc'!Q17+'Member Serviceability Calc'!Q29+'Member Serviceability Calc'!Q35,0),0)+'Member Serviceability Calc'!Q62","v":0},{"$f":"SUM(I352:L352)","v":0}]
[null,"Household 1","Household 2","Household 3","Household 4",null,null,null,{"$f":"IFERROR(I351/M351,0)","v":0},{"$f":"IFERROR(J351/M351,0)","v":0},{"$f":"IFERROR(K351/M351,0)","v":0},{"$f":"IFERROR(L351/M351,0)","v":0}]
["Household Key",{"$f":"B350","v":"Adult-0,Dependents-0"},{"$f":"C350","v":"Adult-0,Dependents-0"},{"$f":"D350","v":"Adult-0,Dependents-0"},{"$f":"E350","v":"Adult-0,Dependents-0"},null,null,null,null,null,null,null,null,{"$f":"IF(N351>0.25,0.25*SUM(G371,M351,M352),M351)","v":{"$error":"#DIV/0!"}}]
["Salary Key",{"$f":"IF(B337<=0,\"0-25000\",IF(B337<=25000,\"0-25000\",IF(B337<=38000,\"25001-38000\",IF(B337<=51000,\"38001-51000\",IF(B337<=64000,\"51001-64000\",IF(B337<=76000,\"64001-76000\",IF(B337<=101000,\"76001-101000\",IF(B337<=126000,\"101001-126000\",IF(B337<=151000,\"126001-151000\",IF(B337<=176000,\"151001-176000\",IF(B337<=202000,\"176001-202000\",IF(B337<=252000,\"202001-252000\",IF(B337<=315000,\"252001-315000\",IF(B337<=378000,\"315001-378000\",IF(B337>378000,\"378001-630000\",FALSE)))))))))))))))","v":"0-25000"},{"$f":"IF(C337<=0,\"0-25000\",IF(C337<=25000,\"0-25000\",IF(C337<=38000,\"25001-38000\",IF(C337<=51000,\"38001-51000\",IF(C337<=64000,\"51001-64000\",IF(C337<=76000,\"64001-76000\",IF(C337<=101000,\"76001-101000\",IF(C337<=126000,\"101001-126000\",IF(C337<=151000,\"126001-151000\",IF(C337<=176000,\"151001-176000\",IF(C337<=202000,\"176001-202000\",IF(C337<=252000,\"202001-252000\",IF(C337<=315000,\"252001-315000\",IF(C337<=378000,\"315001-378000\",IF(C337>378000,\"378001-630000\",FALSE)))))))))))))))","v":"0-25000"},"0-25000","0-25000",null,null,"Alt Doc Adopted ",{"$f":"I353*N354","v":{"$error":"#DIV/0!"}},{"$f":"J353*N354","v":{"$error":"#DIV/0!"}},{"$f":"K353*N354","v":{"$error":"#DIV/0!"}},{"$f":"L353*N354","v":{"$error":"#DIV/0!"}}]
["Household Living Expense",{"$f":"HEM!F56","v":0},{"$f":"HEM!J56","v":0},{"$f":"HEM!N56","v":0},{"$f":"HEM!R56","v":0},null,null,"Full Doc Adopted",{"$f":"I352","v":0},{"$f":"J352","v":0},0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I355:I356)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J355:J356)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,{"$f":"I355+I356-'Serviceability Calc'!K3","v":{"$error":"#DIV/0!"}},{"$f":"J355+J356-'Serviceability Calc'!K4","v":{"$error":"#DIV/0!"}},{"$f":"K355+K356-'Serviceability Calc'!K5","v":{"$error":"#DIV/0!"}},{"$f":"L355+L356-'Serviceability Calc'!K6","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,"Affect by 25 rule",{"$f":"FALSE","v":false},{"$f":"FALSE","v":false},{"$f":"FALSE","v":false},{"$f":"FALSE","v":false}]
["Monthly expense",{"$f":"MAX(SUM(B356),'Member Serviceability Calc'!J77)","v":0},{"$f":"MAX(SUM(C356),'Member Serviceability Calc'!J80)","v":0},{"$f":"MAX(SUM(D356),'Member Serviceability Calc'!J83)","v":0},{"$f":"MAX(SUM(E356),'Member Serviceability Calc'!J86)","v":0}]
[null,null,null,null,null,null,null,null,"( 25% Alt Doc Rule Applied )"]
[]
["Avaiable Income",{"$f":"B340-Tables!B361","v":0},{"$f":"C340-Tables!C361","v":0},{"$f":"D340-Tables!D361","v":0},{"$f":"E340-Tables!E361","v":0}]
[null,{"$f":"B364","v":0},{"$f":"C364","v":0},{"$f":"D364","v":0},{"$f":"E364","v":0}]
[null,{"$f":"SUM('Member Serviceability Calc'!Q100:Q102)*(1+B401)+SUM('Member Serviceability Calc'!Q103:Q112)","v":0},{"$f":"SUM('Member Serviceability Calc'!Q118:Q120)*(1+B401)+SUM('Member Serviceability Calc'!Q121:Q130)","v":0},{"$f":"SUM('Member Serviceability Calc'!Q136:Q138)*(1+B401)+SUM('Member Serviceability Calc'!Q139:Q148)","v":0},{"$f":"SUM('Member Serviceability Calc'!Q154:Q156)*(1+B401)+SUM('Member Serviceability Calc'!Q157:Q166)","v":0}]
["Total Monthly Surplus Funds ",{"$f":"IF(B365-B366<0,0,B365-B366)","v":0},{"$f":"IF(C365-C366<0,0,C365-C366)","v":0},{"$f":"IF(D365-D366<0,0,D365-D366)","v":0},{"$f":"IF(E365-E366<0,0,E365-E366)","v":0}]
[null,{"$f":"IF(B365-B366<0,FALSE,TRUE)","v":true},{"$f":"IF(C365-C366<0,FALSE,TRUE)","v":true},true,true,{"$f":"AND(B368,C368,D368,E368)","v":true}]
["Proposed Contrbution ",{"$f":"IF(EXACT('Member Serviceability Calc'!E14, \"Household 1\"),IF('Member Serviceability Calc'!N26>0,'Member Serviceability Calc'!Q14,0),0)+IF(EXACT('Member Serviceability Calc'!E15, \"Household 1\"),IF('Member Serviceability Calc'!N27>0,'Member Serviceability Calc'!Q15,0),0)+IF(EXACT('Member Serviceability Calc'!E16, \"Household 1\"),IF('Member Serviceability Calc'!N28>0,'Member Serviceability Calc'!Q16,0),0)+IF(EXACT('Member Serviceability Calc'!E17, \"Household 1\"),IF('Member Serviceability Calc'!N29>0,'Member Serviceability Calc'!Q17,0),0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14, \"Household 2\"),IF('Member Serviceability Calc'!N26>0,'Member Serviceability Calc'!Q14,0),0)+IF(EXACT('Member Serviceability Calc'!E15, \"Household 2\"),IF('Member Serviceability Calc'!N27>0,'Member Serviceability Calc'!Q15,0),0)+IF(EXACT('Member Serviceability Calc'!E16, \"Household 2\"),IF('Member Serviceability Calc'!N28>0,'Member Serviceability Calc'!Q16,0),0)+IF(EXACT('Member Serviceability Calc'!E17, \"Household 2\"),IF('Member Serviceability Calc'!N29>0,'Member Serviceability Calc'!Q17,0),0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14, \"Household 3\"),IF('Member Serviceability Calc'!N26>0,'Member Serviceability Calc'!Q14,0),0)+IF(EXACT('Member Serviceability Calc'!E15, \"Household 3\"),IF('Member Serviceability Calc'!N27>0,'Member Serviceability Calc'!Q15,0),0)+IF(EXACT('Member Serviceability Calc'!E16, \"Household 3\"),IF('Member Serviceability Calc'!N28>0,'Member Serviceability Calc'!Q16,0),0)+IF(EXACT('Member Serviceability Calc'!E17, \"Household 3\"),IF('Member Serviceability Calc'!N29>0,'Member Serviceability Calc'!Q17,0),0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14, \"Household 4\"),IF('Member Serviceability Calc'!N26>0,'Member Serviceability Calc'!Q14,0),0)+IF(EXACT('Member Serviceability Calc'!E15, \"Household 4\"),IF('Member Serviceability Calc'!N27>0,'Member Serviceability Calc'!Q15,0),0)+IF(EXACT('Member Serviceability Calc'!E16, \"Household 4\"),IF('Member Serviceability Calc'!N28>0,'Member Serviceability Calc'!Q16,0),0)+IF(EXACT('Member Serviceability Calc'!E17, \"Household 4\"),IF('Member Serviceability Calc'!N29>0,'Member Serviceability Calc'!Q17,0),0)","v":0}]
["Alt Doc",{"$f":"OR(IF(EXACT('Member Serviceability Calc'!E14, \"Household 1\"),IF(EXACT('Member Serviceability Calc'!G14, \"Alt Doc\"),TRUE,FALSE),FALSE),IF(EXACT('Member Serviceability Calc'!E15, \"Household 1\"),IF(EXACT('Member Serviceability Calc'!G15, \"Alt Doc\"),TRUE,FALSE),FALSE),IF(EXACT('Member Serviceability Calc'!E16, \"Household 1\"),IF(EXACT('Member Serviceability Calc'!G16, \"Alt Doc\"),TRUE,FALSE),FALSE),IF(EXACT('Member Serviceability Calc'!E17, \"Household 1\"),IF(EXACT('Member Serviceability Calc'!G17, \"Alt Doc\"),TRUE,FALSE),FALSE))","v":false},{"$f":"OR(IF(EXACT('Member Serviceability Calc'!E14, \"Household 2\"),IF(EXACT('Member Serviceability Calc'!G14, \"Alt Doc\"),TRUE,FALSE),FALSE),IF(EXACT('Member Serviceability Calc'!E15, \"Household 2\"),IF(EXACT('Member Serviceability Calc'!G15, \"Alt Doc\"),TRUE,FALSE),FALSE),IF(EXACT('Member Serviceability Calc'!E16, \"Household 2\"),IF(EXACT('Member Serviceability Calc'!G16, \"Alt Doc\"),TRUE,FALSE),FALSE),IF(EXACT('Member Serviceability Calc'!E17, \"Household 2\"),IF(EXACT('Member Serviceability Calc'!G17, \"Alt Doc\"),TRUE,FALSE),FALSE))","v":false},{"$f":"OR(IF(EXACT('Member Serviceability Calc'!E14, \"Household 3\"),IF(EXACT('Member Serviceability Calc'!G14, \"Alt Doc\"),TRUE,FALSE),FALSE),IF(EXACT('Member Serviceability Calc'!E15, \"Household 3\"),IF(EXACT('Member Serviceability Calc'!G15, \"Alt Doc\"),TRUE,FALSE),FALSE),IF(EXACT('Member Serviceability Calc'!E16, \"Household 3\"),IF(EXACT('Member Serviceability Calc'!G16, \"Alt Doc\"),TRUE,FALSE),FALSE),IF(EXACT('Member Serviceability Calc'!E17, \"Household 3\"),IF(EXACT('Member Serviceability Calc'!G17, \"Alt Doc\"),TRUE,FALSE),FALSE))","v":false},{"$f":"OR(IF(EXACT('Member Serviceability Calc'!E14, \"Household 4\"),IF(EXACT('Member Serviceability Calc'!G14, \"Alt Doc\"),TRUE,FALSE),FALSE),IF(EXACT('Member Serviceability Calc'!E15, \"Household 4\"),IF(EXACT('Member Serviceability Calc'!G15, \"Alt Doc\"),TRUE,FALSE),FALSE),IF(EXACT('Member Serviceability Calc'!E16, \"Household 4\"),IF(EXACT('Member Serviceability Calc'!G16, \"Alt Doc\"),TRUE,FALSE),FALSE),IF(EXACT('Member Serviceability Calc'!E17, \"Household 4\"),IF(EXACT('Member Serviceability Calc'!G17, \"Alt Doc\"),TRUE,FALSE),FALSE))","v":false}]
["Smaller ",{"$f":"MIN(Tables!B369,Tables!B367)","v":0},{"$f":"MIN(Tables!C369,Tables!C367)","v":0},{"$f":"MIN(Tables!D369,Tables!D367)","v":0},{"$f":"MIN(Tables!E369,Tables!E367)","v":0},null,{"$f":"'SMSF Serviceability Calculator'!N30","v":0}]
["P+TMNI",{"$f":"(B371+G371)*0.25","v":0},{"$f":"(C371+G371)*0.25","v":0},{"$f":"(D371+G371)*0.25","v":0},{"$f":"(E371+G371)*0.25","v":0}]
["Member Contribution ",{"$f":"B371","v":0},{"$f":"C371","v":0},{"$f":"D371","v":0},0]
[null,{"$f":"IF(B373<0,0,B373)","v":0},{"$f":"IF(C373<0,0,C373)","v":0},{"$f":"IF(D373<0,0,D373)","v":0},{"$f":"IF(E373<0,0,E373)","v":0}]
[null,{"$f":"IF(NOT(B368),\"Total Month Surplus Funds failed for Household 1\",\"\")","v":""},{"$f":"IF(NOT(C368),\"Total Month Surplus Funds failed for Household 2\",\"\")","v":""},{"$f":"IF(NOT(D368),\"Total Month Surplus Funds failed for Household 3\",\"\")","v":""},{"$f":"IF(NOT(E368),\"Total Month Surplus Funds failed for Household 4\",\"\")","v":""}]
[]
[]
["Tax",null,null,"Member 1 ","Member 2","Member 3","Member 4","Member 5","Member 6","Member 7","Member 8"]
[]
["Personal Contribution Over","Not to Exceed","Tax Rate"]
[0,30000,0.15,{"$f":"IF('SMSF Serviceability Calculator'!I17 <= B381,'SMSF Serviceability Calculator'!I17*(1-C381),B381*(1-C381))","v":0},{"$f":"IF('SMSF Serviceability Calculator'!I18 <= B381,'SMSF Serviceability Calculator'!I18*(1-C381),B381*(1-C381))","v":0},{"$f":"IF('SMSF Serviceability Calculator'!I19 <= B381,'SMSF Serviceability Calculator'!I19*(1-C381),B381*(1-C381))","v":0},{"$f":"IF('SMSF Serviceability Calculator'!I20 <= B381,'SMSF Serviceability Calculator'!I20*(1-C381),B381*(1-C381))","v":0},{"$f":"IF('Member Serviceability Calc'!O14 * 12 <= H387,'Member Serviceability Calc'!O14 * 12*(1-C381),H387*(1-C381))","v":0},{"$f":"IF('Member Serviceability Calc'!O15 * 12 <= I387,'Member Serviceability Calc'!O15 * 12*(1-C381),I387*(1-C381))","v":0},{"$f":"IF('Member Serviceability Calc'!O16 * 12 <= J387,'Member Serviceability Calc'!O16 * 12*(1-C381),J387*(1-C381))","v":0},{"$f":"IF('Member Serviceability Calc'!O17 * 12 <= K387,'Member Serviceability Calc'!O17 * 12*(1-C381),K387*(1-C381))","v":0}]
[{"$f":"B381+1","v":30001},null,0.45,{"$f":"IF('SMSF Serviceability Calculator'!I17 > B381,('SMSF Serviceability Calculator'!I17-B381)*(1-C382),0)","v":0},{"$f":"IF('SMSF Serviceability Calculator'!I18 > B381,('SMSF Serviceability Calculator'!I18-B381)*(1-C382),0)","v":0},{"$f":"IF('SMSF Serviceability Calculator'!I19 > B381,('SMSF Serviceability Calculator'!I19-B381)*(1-C382),0)","v":0},{"$f":"IF('SMSF Serviceability Calculator'!I20 > B381,('SMSF Serviceability Calculator'!I20-B381)*(1-C382),0)","v":0},{"$f":"IF('Member Serviceability Calc'!O14 * 12 > H387,('Member Serviceability Calc'!O14 * 12-H387)*(1-C382),0)","v":0},{"$f":"IF('Member Serviceability Calc'!O15 * 12 > I387,('Member Serviceability Calc'!O15 * 12-I387)*(1-C382),0)","v":0},{"$f":"IF('Member Serviceability Calc'!O16 * 12 > J387,('Member Serviceability Calc'!O16 * 12-J387)*(1-C382),0)","v":0},{"$f":"IF('Member Serviceability Calc'!O17 * 12 > K387,('Member Serviceability Calc'!O17 * 12-K387)*(1-C382),0)","v":0}]
[null,null,null,{"$f":"D381+D382","v":0},{"$f":"E381+E382","v":0},{"$f":"F381+F382","v":0},{"$f":"G381+G382","v":0},{"$f":"H381+H382","v":0},{"$f":"I381+I382","v":0},0,0]
[null,null,null,{"$f":"D383/12","v":0},{"$f":"E383/12","v":0},{"$f":"F383/12","v":0},{"$f":"G383/12","v":0},{"$f":"IFERROR(H383/12,0)","v":0},{"$f":"IFERROR(I383/12,0)","v":0},0,0]
[]
[null,null,null,null,null,null,null,{"$f":" 'SMSF Serviceability Calculator'!I17 - B381","v":-30000},{"$f":" 'SMSF Serviceability Calculator'!I18 - B381","v":-30000},{"$f":" 'SMSF Serviceability Calculator'!I19 - B381","v":-30000},{"$f":" 'SMSF Serviceability Calculator'!I20 - B381","v":-30000}]
["RedZed Loan Applied For Loan1",{"$f":"IF('SMSF Serviceability Calculator'!J51=0,0,IF('SMSF Serviceability Calculator'!L51=0,0,-PMT(('SMSF Serviceability Calculator'!L51)/12,('SMSF Serviceability Calculator'!J51-'SMSF Serviceability Calculator'!K51)*12,'SMSF Serviceability Calculator'!I51)))","v":0},null,null,null,null,null,{"$f":"IF(H386<0,-1*H386,0)","v":30000},{"$f":"IF(I386<0,-1*I386,0)","v":30000},30000,30000]
[]
[]
[]
["APR Buffer",0.02]
["Minimum Rate",7.0000000000000007E-2]
[]
["RedZed Loan Applied For: Repayment With Buffer",null,"Buffered %","Minimum %","Rate %","Buffer %","Buffered %","Total Term","Interest Only Term","Net Term","Amount"]
["Buffered Loan 1",{"$f":"IF('SMSF Serviceability Calculator'!J51=0,0,-PMT((D395)/12,J395*12,'SMSF Serviceability Calculator'!I51))","v":0},{"$f":"G395","v":0.02},{"$f":"IF(C395>=$B$29,C395,$B$29)","v":7.0000000000000007E-2},{"$f":"'SMSF Serviceability Calculator'!L51","v":0},{"$f":"$B$28","v":0.02},{"$f":"E395+F395","v":0.02},{"$f":"'SMSF Serviceability Calculator'!J51","v":0},{"$f":"'SMSF Serviceability Calculator'!K51","v":0},{"$f":"H395-I395","v":0},{"$f":"'SMSF Serviceability Calculator'!I51","v":0}]
["Buffered Loan 2",{"$f":"IF(Serviceability!J420=0,0,-PMT((D396)/12,J396*12,Serviceability!I420))","v":0},{"$f":"G396","v":0.02},{"$f":"IF(C396>=$B$29,C396,$B$29)","v":7.0000000000000007E-2},{"$f":"Serviceability!L420","v":0},{"$f":"$B$28","v":0.02},{"$f":"E396+F396","v":0.02},{"$f":"Serviceability!J420","v":0},{"$f":"Serviceability!K420","v":0},{"$f":"H396-I396","v":0}]
["Buffered Loan 3",{"$f":"IF(Serviceability!J421=0,0,-PMT((D397)/12,J397*12,Serviceability!I421))","v":0},{"$f":"G397","v":0.02},{"$f":"IF(C397>=$B$29,C397,$B$29)","v":7.0000000000000007E-2},{"$f":"Serviceability!L421","v":0},{"$f":"$B$28","v":0.02},{"$f":"E397+F397","v":0.02},{"$f":"Serviceability!J421","v":0},{"$f":"Serviceability!K421","v":0},{"$f":"H397-I397","v":0},{"$f":"Serviceability!I421","v":0}]
[]
[]
["Existing Loan: Repayment With Buffer"]
["Buffered Loan 1",0.2,{"$f":"'SMSF Serviceability Calculator'!N55*(1+B401)","v":0}]
["Buffered Loan 2",0.2,{"$f":"'SMSF Serviceability Calculator'!N56*(1+B402)","v":0}]
["Buffered Loan 3",0.2,{"$f":"'SMSF Serviceability Calculator'!N57*(1+B403)","v":0}]
["Buffered Other Loan/Liability Limits if any",0.2,{"$f":"'SMSF Serviceability Calculator'!N60*(1+B403)","v":0}]
[]
[]
[]
[]
["Additional Fees for Serviceability"]
["Fees - Loan 1",15,{"$f":"IF('SMSF Serviceability Calculator'!N51=0,0,15)","v":0},"Monthly Account Keeping Fee Resi"]
[]
[]
[]
[{"$f":"IFERROR(IF('Serviceability Calc'!J24 <= 1.1,TRUE,FALSE),TRUE)","v":true}]
[{"$f":"IFERROR(IF('Serviceability Calc'!O7 <= 0.25,FALSE,TRUE),TRUE)","v":false}]

{"sheet":"Serviceability Calc","index":5,"n_rows":52,"n_cols":20,"rows_kept":52,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Serviceability Cell Calculation"]
[null,null,null,null,null,"Total Income Funding level",{"$f":"'SMSF Serviceability Calculator'!N30","v":0}]
[null,{"$f":"Serviceability!D50&\" (After Tax Rates Applied)\"","v":"Available Income (After Tax Rates Applied)"},{"$f":"Serviceability!N50","v":0},null,null,{"$f":"'SMSF Serviceability Calculator'!D45&\" (After Tax Rates Applied)\"","v":"Available Income (After Tax Rates Applied)"},{"$f":"'SMSF Serviceability Calculator'!N45","v":-166.66666666666666},null,null,"Household 1",{"$f":" IF(EXACT('Member Serviceability Calc'!E14,'Serviceability Calc'!J3),'Member Serviceability Calc'!Q14,0)+ IF(EXACT('Member Serviceability Calc'!E15,'Serviceability Calc'!J3),'Member Serviceability Calc'!Q15,0)+IF(EXACT('Member Serviceability Calc'!E16,'Serviceability Calc'!J3),'Member Serviceability Calc'!Q16,0)+ IF(EXACT('Member Serviceability Calc'!E17,'Serviceability Calc'!J3),'Member Serviceability Calc'!Q17,0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,'Serviceability Calc'!J3),IF(EXACT('Member Serviceability Calc'!G14,\"Alt Doc\"),1,0),0)+ IF(EXACT('Member Serviceability Calc'!E15,'Serviceability Calc'!J3),IF(EXACT('Member Serviceability Calc'!G15,\"Alt Doc\"),1,0),0)+IF(EXACT('Member Serviceability Calc'!E16,'Serviceability Calc'!J3),IF(EXACT('Member Serviceability Calc'!G16,\"Alt Doc\"),1,0),0)+ IF(EXACT('Member Serviceability Calc'!E17,'Serviceability Calc'!J3),IF(EXACT('Member Serviceability Calc'!G17,\"Alt Doc\"),1,0),0)","v":0},{"$f":"IF(P3>0,Q3,0)","v":0},{"$f":"Tables!B374","v":0},{"$f":"M3/M7*M11","v":{"$error":"#DIV/0!"}},{"$f":"IF('Member Serviceability Calc'!G14 = \"Alt Doc\",1,0)","v":0},{"$f":"'Member Serviceability Calc'!Q14","v":0},{"$f":"IF(S3>0,N3*K45,0)","v":0},{"$f":"IF(Tables!B370,1,0)","v":0},{"$f":" IF(EXACT('Member Serviceability Calc'!E14,'Serviceability Calc'!J3),'Member Serviceability Calc'!O14,0)+ IF(EXACT('Member Serviceability Calc'!E15,'Serviceability Calc'!J3),'Member Serviceability Calc'!O15,0)+IF(EXACT('Member Serviceability Calc'!E16,'Serviceability Calc'!J3),'Member Serviceability Calc'!O16,0)+ IF(EXACT('Member Serviceability Calc'!E17,'Serviceability Calc'!J3),'Member Serviceability Calc'!O17,0)","v":0}]
[null,"Divided by",null,null,null,"Divided by",null,null,null,"Household 2",{"$f":" IF(EXACT('Member Serviceability Calc'!E14,'Serviceability Calc'!J4),'Member Serviceability Calc'!Q14,0)+ IF(EXACT('Member Serviceability Calc'!E15,'Serviceability Calc'!J4),'Member Serviceability Calc'!Q15,0)+IF(EXACT('Member Serviceability Calc'!E16,'Serviceability Calc'!J4),'Member Serviceability Calc'!Q16,0)+ IF(EXACT('Member Serviceability Calc'!E17,'Serviceability Calc'!J4),'Member Serviceability Calc'!Q17,0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,'Serviceability Calc'!J4),IF(EXACT('Member Serviceability Calc'!G14,\"Alt Doc\"),1,0),0)+ IF(EXACT('Member Serviceability Calc'!E15,'Serviceability Calc'!J4),IF(EXACT('Member Serviceability Calc'!G15,\"Alt Doc\"),1,0),0)+IF(EXACT('Member Serviceability Calc'!E16,'Serviceability Calc'!J4),IF(EXACT('Member Serviceability Calc'!G16,\"Alt Doc\"),1,0),0)+ IF(EXACT('Member Serviceability Calc'!E17,'Serviceability Calc'!J4),IF(EXACT('Member Serviceability Calc'!G17,\"Alt Doc\"),1,0),0)","v":0},{"$f":"IF(P4>0,Q4,0)","v":0},{"$f":"Tables!C374","v":0},{"$f":"M4/M7*M11","v":{"$error":"#DIV/0!"}},{"$f":"IF('Member Serviceability Calc'!G15 = \"Alt Doc\",1,0)","v":0},{"$f":"'Member Serviceability Calc'!Q15","v":0},{"$f":"IF(S4>0,N4*L45,0)","v":0},{"$f":"IF(Tables!C370,1,0)","v":0},{"$f":" IF(EXACT('Member Serviceability Calc'!E14,'Serviceability Calc'!J4),'Member Serviceability Calc'!O14,0)+ IF(EXACT('Member Serviceability Calc'!E15,'Serviceability Calc'!J4),'Member Serviceability Calc'!O15,0)+IF(EXACT('Member Serviceability Calc'!E16,'Serviceability Calc'!J4),'Member Serviceability Calc'!O16,0)+ IF(EXACT('Member Serviceability Calc'!E17,'Serviceability Calc'!J4),'Member Serviceability Calc'!O17,0)","v":0}]
[null,{"$f":"Serviceability!D73","v":"Total Monthly Commitments"},{"$f":"SUM(Serviceability!N56:N72)","v":0},null,null,"Total Monthly Commitments (Before Buffering)",{"$f":"SUM('SMSF Serviceability Calculator'!N51,'SMSF Serviceability Calculator'!N55:'SMSF Serviceability Calculator'!N57,'SMSF Serviceability Calculator'!N60)","v":0},null,null,"Household 3",{"$f":" IF(EXACT('Member Serviceability Calc'!E14,'Serviceability Calc'!J5),'Member Serviceability Calc'!Q14,0)+ IF(EXACT('Member Serviceability Calc'!E15,'Serviceability Calc'!J5),'Member Serviceability Calc'!Q15,0)+IF(EXACT('Member Serviceability Calc'!E16,'Serviceability Calc'!J5),'Member Serviceability Calc'!Q16,0)+ IF(EXACT('Member Serviceability Calc'!E17,'Serviceability Calc'!J5),'Member Serviceability Calc'!Q17,0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,'Serviceability Calc'!J5),IF(EXACT('Member Serviceability Calc'!G14,\"Alt Doc\"),1,0),0)+ IF(EXACT('Member Serviceability Calc'!E15,'Serviceability Calc'!J5),IF(EXACT('Member Serviceability Calc'!G15,\"Alt Doc\"),1,0),0)+IF(EXACT('Member Serviceability Calc'!E16,'Serviceability Calc'!J5),IF(EXACT('Member Serviceability Calc'!G16,\"Alt Doc\"),1,0),0)+ IF(EXACT('Member Serviceability Calc'!E17,'Serviceability Calc'!J5),IF(EXACT('Member Serviceability Calc'!G17,\"Alt Doc\"),1,0),0)","v":0},{"$f":"IF(P5>0,Q5,0)","v":0},{"$f":"Tables!D374","v":0},{"$f":"M5/M7*M11","v":{"$error":"#DIV/0!"}},{"$f":"IF('Member Serviceability Calc'!G16 = \"Alt Doc\",1,0)","v":0},{"$f":"'Member Serviceability Calc'!Q16","v":0},{"$f":"IF(S5>0,N5*M45,0)","v":0},{"$f":"IF(Tables!D370,1,0)","v":0},{"$f":" IF(EXACT('Member Serviceability Calc'!E14,'Serviceability Calc'!J5),'Member Serviceability Calc'!O14,0)+ IF(EXACT('Member Serviceability Calc'!E15,'Serviceability Calc'!J5),'Member Serviceability Calc'!O15,0)+IF(EXACT('Member Serviceability Calc'!E16,'Serviceability Calc'!J5),'Member Serviceability Calc'!O16,0)+ IF(EXACT('Member Serviceability Calc'!E17,'Serviceability Calc'!J5),'Member Serviceability Calc'!O17,0)","v":0}]
["Less",{"$f":"Serviceability!$D$54&\" - \"&Serviceability!E56","v":"RedZed Loan Applied For - Loan 1"},{"$f":"-Serviceability!N56","v":0},null,"Less",{"$f":"Serviceability!$D$54&\" - \"&'SMSF Serviceability Calculator'!E51","v":"RedZed Loan Applied For - New RedZed Loan "},{"$f":"-'SMSF Serviceability Calculator'!N51","v":0},null,null,"Household 4",{"$f":" IF(EXACT('Member Serviceability Calc'!E14,'Serviceability Calc'!J6),'Member Serviceability Calc'!Q14,0)+ IF(EXACT('Member Serviceability Calc'!E15,'Serviceability Calc'!J6),'Member Serviceability Calc'!Q15,0)+IF(EXACT('Member Serviceability Calc'!E16,'Serviceability Calc'!J6),'Member Serviceability Calc'!Q16,0)+ IF(EXACT('Member Serviceability Calc'!E17,'Serviceability Calc'!J6),'Member Serviceability Calc'!Q17,0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,'Serviceability Calc'!J6),IF(EXACT('Member Serviceability Calc'!G14,\"Alt Doc\"),1,0),0)+ IF(EXACT('Member Serviceability Calc'!E15,'Serviceability Calc'!J6),IF(EXACT('Member Serviceability Calc'!G15,\"Alt Doc\"),1,0),0)+IF(EXACT('Member Serviceability Calc'!E16,'Serviceability Calc'!J6),IF(EXACT('Member Serviceability Calc'!G16,\"Alt Doc\"),1,0),0)+ IF(EXACT('Member Serviceability Calc'!E17,'Serviceability Calc'!J6),IF(EXACT('Member Serviceability Calc'!G17,\"Alt Doc\"),1,0),0)","v":0},{"$f":"IF(P6>0,Q6,0)","v":0},{"$f":"Tables!E374","v":0},{"$f":"M6/M7*M11","v":{"$error":"#DIV/0!"}},{"$f":"IF('Member Serviceability Calc'!G17 = \"Alt Doc\",1,0)","v":0},{"$f":"'Member Serviceability Calc'!Q17","v":0},{"$f":"IF(S6>0,N6*N45,0)","v":0},{"$f":"IF(Tables!E370,1,0)","v":0},{"$f":" IF(EXACT('Member Serviceability Calc'!E14,'Serviceability Calc'!J6),'Member Serviceability Calc'!O14,0)+ IF(EXACT('Member Serviceability Calc'!E15,'Serviceability Calc'!J6),'Member Serviceability Calc'!O15,0)+IF(EXACT('Member Serviceability Calc'!E16,'Serviceability Calc'!J6),'Member Serviceability Calc'!O16,0)+ IF(EXACT('Member Serviceability Calc'!E17,'Serviceability Calc'!J6),'Member Serviceability Calc'!O17,0)","v":0}]
["Less",{"$f":"Serviceability!$D$54&\" - \"&Serviceability!E57","v":"RedZed Loan Applied For - Loan 2"},{"$f":"-Serviceability!N57","v":0},null,"Less",{"$f":"Serviceability!$D$54&\" - \"&Serviceability!I57","v":"RedZed Loan Applied For - "},{"$f":"-Serviceability!R57","v":0},null,null,null,{"$f":"SUM(K3:K6)","v":0},null,{"$f":"SUM(M3:M6)","v":0},{"$f":"SUM(N3:N6)","v":0},{"$f":"IFERROR(M7/(K7+G2),0)","v":0},{"$f":"IFERROR(R7/(N7+G2),0)","v":0},null,{"$f":"SUM(R3:R6)","v":0}]
["Less",{"$f":"Serviceability!$D$54&\" - \"&Serviceability!E58","v":"RedZed Loan Applied For - Loan 3"},{"$f":"-Serviceability!N58","v":0},null,"Less",{"$f":"Serviceability!$D$54&\" - \"&Serviceability!I58","v":"RedZed Loan Applied For - "},{"$f":"-Serviceability!R58","v":0}]
["Plus",{"$f":"Serviceability!$D$54&\" - \"&Tables!A32","v":"RedZed Loan Applied For - Buffered Loan 1"},{"$f":"Tables!B32","v":0},null,"Plus",{"$f":"Serviceability!$D$54&\" - \"&Tables!A395","v":"RedZed Loan Applied For - Buffered Loan 1"},{"$f":"Tables!B395","v":0},null,null,null,{"$f":"SUM(G3,K3:K6)","v":-166.66666666666666},null,null,{"$f":"SUM(N3:N6,G3)","v":-166.66666666666666}]
["Plus",{"$f":"Serviceability!$D$54&\" - \"&Tables!A33","v":"RedZed Loan Applied For - Buffered Loan 2"},{"$f":"Tables!B33","v":0},null,"Plus",{"$f":"Serviceability!$D$54&\" - \"&Tables!E33","v":"RedZed Loan Applied For - 0"},{"$f":"0","v":0}]
["Plus",{"$f":"Serviceability!$D$54&\" - \"&Tables!A34","v":"RedZed Loan Applied For - Buffered Loan 3"},{"$f":"Tables!B34","v":0},null,"Plus",{"$f":"Serviceability!$D$54&\" - \"&Tables!E34","v":"RedZed Loan Applied For - 0"},{"$f":"0","v":0},null,null,null,null,null,{"$f":"0.25*(K7+G2)","v":0},{"$f":"0.25*(N7+G2)","v":0},null,null,null,{"$f":"G3+N7+N11-R7","v":-166.66666666666666}]
["Less",{"$f":"Serviceability!$D$61&\": \"&Serviceability!E61","v":"Existing Loans: Loan 1 - Existing Secured"},{"$f":"-Serviceability!N61","v":0},null,"Less",{"$f":"Serviceability!$D$61&\": \"&'SMSF Serviceability Calculator'!E55","v":"Existing Loans: Loan 1"},{"$f":"-'SMSF Serviceability Calculator'!N55","v":0}]
["Less",{"$f":"Serviceability!$D$61&\": \"&Serviceability!E62","v":"Existing Loans: Loan 2 - Existing Secured"},{"$f":"-Serviceability!N62","v":0},null,"Less",{"$f":"Serviceability!$D$61&\": \"&'SMSF Serviceability Calculator'!E56","v":"Existing Loans: Loan 2"},{"$f":"-'SMSF Serviceability Calculator'!N56","v":0},null,null,null,null,null,{"$f":"G3+K7+M11-M7","v":-166.66666666666666}]
["Plus",{"$f":"Serviceability!$D$61&\": \"&Tables!A38","v":"Existing Loans: Buffered Loan 1"},{"$f":"Tables!C38","v":0},null,"Less",{"$f":"Serviceability!$D$61&\": \"&'SMSF Serviceability Calculator'!E57","v":"Existing Loans: Loan 3"},{"$f":"-'SMSF Serviceability Calculator'!N57","v":0}]
["Plus",{"$f":"Serviceability!$D$61&\": \"&Tables!A39","v":"Existing Loans: Buffered Loan 2"},{"$f":"Tables!C39","v":0},null,"Plus",{"$f":"Serviceability!$D$61&\": \"&'SMSF Serviceability Calculator'!D60","v":"Existing Loans: Other Loan/Liability Limits if any"},{"$f":"-'SMSF Serviceability Calculator'!N60","v":0},null,null,null,null,"Full Doc","Alt Doc"]
["Plus",{"$f":"Tables!A43","v":"Fees - Loan 1"},{"$f":"Tables!C43","v":0},null,"Plus",{"$f":"Serviceability!$D$61&\": \"&Tables!A401","v":"Existing Loans: Buffered Loan 1"},{"$f":"Tables!C401","v":0},null,null,"Minimum Contribution ",null,{"$f":"IF(G3<0,\"N/A\",ROUNDUP(G23*1.1-G3,0))","v":"N/A"},{"$f":"IFERROR(L16*4-G2,\"N/A\")","v":"N/A"}]
["Plus",{"$f":"Tables!A44","v":"Fees - Loan 2"},{"$f":"Tables!C44","v":0},null,"Plus",{"$f":"Serviceability!$D$61&\": \"&Tables!A402","v":"Existing Loans: Buffered Loan 2"},{"$f":"Tables!C402","v":0},null,null,null,null,{"$f":"IFERROR(L16+G3,\"N/A\")","v":"N/A"}]
["Plus",{"$f":"Tables!A45","v":"Fees - Loan 3"},{"$f":"Tables!C45","v":0},null,"Plus",{"$f":"Serviceability!$D$61&\": \"&Tables!A403","v":"Existing Loans: Buffered Loan 3"},{"$f":"Tables!C403","v":0},null,null,null,null,null,{"$f":"ROUNDUP(IF(O7>0.25,M13,K9),2)","v":-166.67}]
[null,null,null,null,"Plus",{"$f":"Tables!A410","v":"Fees - Loan 1"},{"$f":"Tables!C410","v":0}]
[null,"Total Monthly Commitments (After Repayment Buffering & Fees)",{"$f":"SUM(C5:C19)","v":0},null,"Plus",{"$f":"Tables!E44","v":0},{"$f":"Tables!G44","v":0},null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(L16/0.85*12 <= 30000,L16/0.85,L16*12-9000/12),0),\"N/A\")","v":"N/A"}]
[null,null,null,null,null,{"$f":"Tables!E45","v":0},{"$f":"Tables!G45","v":" "}]
[null,{"$f":"Serviceability!K76&\" - Calculated as:\"","v":" - Calculated as:"},{"$f":"ROUNDUP(C3/C20,2)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"Serviceability!$D$61&\": \"&Tables!A404","v":"Existing Loans: Buffered Other Loan/Liability Limits if any"},{"$f":"Tables!C404","v":0}]
[null,null,null,null,null,"Total Monthly Commitments (After Repayment Buffering & Fees)",{"$f":"SUM(G5:G22)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(O7>0.25,M13,K9)/G23,2),0)","v":0},{"$f":"ROUNDUP(IF(P7>0.25,R11,N7+G3)/G23,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUNDUP(N9/G23,2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"Serviceability!O76&\" - Calculated as:\"","v":" - Calculated as:"},{"$f":"ROUNDUP(G3/G23,2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,{"$f":"G25","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,null,null,"Fail – The proposed alt doc additional member contribution required to meet servicing exceeds our 25% rule"]
[null,null,null,null,null,"(25% rule – Proposed Alt Doc additional member contributions cannot exceed 25% of the total income required to meet fund serviceability)"]
[]
[null,null,null,null,null,"Fail – your proposed additional contributions are insufficient to meet minimum serviceability requirements"]
[]
[null,null,null,null,null,"Please complete below to validate the capacity of the member(s) to make the proposed additional contribution"]
[]
[]
[null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"Minimum Net Proposed Member Contribution Required to Service: $ \",  L16)","v":"Minimum Net Proposed Member Contribution Required to Service: $ N/A"}]
[]
[null,null,null,null,null,"Your contribution is greater than the minimum required to service the loan"]
[null,null,null,null,null,null,null,null,null,null,"Household 1","Household 2","Household 3","Household 4"]
[null,null,null,null,null,null,null,null,null,"Alt Doc",{"$f":"IF(EXACT('Member Serviceability Calc'!E14,K41),IF(EXACT('Member Serviceability Calc'!G14,J42),'Member Serviceability Calc'!Q14,0),0)+IF(EXACT('Member Serviceability Calc'!E15,K41),IF(EXACT('Member Serviceability Calc'!G15,J42),'Member Serviceability Calc'!Q15,0),0)+IF(EXACT('Member Serviceability Calc'!E16,K41),IF(EXACT('Member Serviceability Calc'!G16,J42),'Member Serviceability Calc'!Q16,0),0)+IF(EXACT('Member Serviceability Calc'!E17,K41),IF(EXACT('Member Serviceability Calc'!G17,J42),'Member Serviceability Calc'!Q17,0),0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,L41),IF(EXACT('Member Serviceability Calc'!G14,J42),'Member Serviceability Calc'!Q14,0),0)+IF(EXACT('Member Serviceability Calc'!E15,L41),IF(EXACT('Member Serviceability Calc'!G15,J42),'Member Serviceability Calc'!Q15,0),0)+IF(EXACT('Member Serviceability Calc'!E16,L41),IF(EXACT('Member Serviceability Calc'!G16,J42),'Member Serviceability Calc'!Q16,0),0)+IF(EXACT('Member Serviceability Calc'!E17,L41),IF(EXACT('Member Serviceability Calc'!G17,J42),'Member Serviceability Calc'!Q17,0),0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,M41),IF(EXACT('Member Serviceability Calc'!G14,J42),'Member Serviceability Calc'!Q14,0),0)+IF(EXACT('Member Serviceability Calc'!E15,M41),IF(EXACT('Member Serviceability Calc'!G15,J42),'Member Serviceability Calc'!Q15,0),0)+IF(EXACT('Member Serviceability Calc'!E16,M41),IF(EXACT('Member Serviceability Calc'!G16,J42),'Member Serviceability Calc'!Q16,0),0)+IF(EXACT('Member Serviceability Calc'!E17,M41),IF(EXACT('Member Serviceability Calc'!G17,J42),'Member Serviceability Calc'!Q17,0),0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,N41),IF(EXACT('Member Serviceability Calc'!G14,J42),'Member Serviceability Calc'!Q14,0),0)+IF(EXACT('Member Serviceability Calc'!E15,N41),IF(EXACT('Member Serviceability Calc'!G15,J42),'Member Serviceability Calc'!Q15,0),0)+IF(EXACT('Member Serviceability Calc'!E16,N41),IF(EXACT('Member Serviceability Calc'!G16,J42),'Member Serviceability Calc'!Q16,0),0)+IF(EXACT('Member Serviceability Calc'!E17,N41),IF(EXACT('Member Serviceability Calc'!G17,J42),'Member Serviceability Calc'!Q17,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,"Full Doc",{"$f":"IF(EXACT('Member Serviceability Calc'!E14,K41),IF(EXACT('Member Serviceability Calc'!G14,J43),'Member Serviceability Calc'!Q14,0),0)+IF(EXACT('Member Serviceability Calc'!E15,K41),IF(EXACT('Member Serviceability Calc'!G15,J43),'Member Serviceability Calc'!Q15,0),0)+IF(EXACT('Member Serviceability Calc'!E16,K41),IF(EXACT('Member Serviceability Calc'!G16,J43),'Member Serviceability Calc'!Q16,0),0)+IF(EXACT('Member Serviceability Calc'!E17,K41),IF(EXACT('Member Serviceability Calc'!G17,J43),'Member Serviceability Calc'!Q17,0),0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,L41),IF(EXACT('Member Serviceability Calc'!G14,J43),'Member Serviceability Calc'!Q14,0),0)+IF(EXACT('Member Serviceability Calc'!E15,L41),IF(EXACT('Member Serviceability Calc'!G15,J43),'Member Serviceability Calc'!Q15,0),0)+IF(EXACT('Member Serviceability Calc'!E16,L41),IF(EXACT('Member Serviceability Calc'!G16,J43),'Member Serviceability Calc'!Q16,0),0)+IF(EXACT('Member Serviceability Calc'!E17,L41),IF(EXACT('Member Serviceability Calc'!G17,J43),'Member Serviceability Calc'!Q17,0),0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,M41),IF(EXACT('Member Serviceability Calc'!G14,J43),'Member Serviceability Calc'!Q14,0),0)+IF(EXACT('Member Serviceability Calc'!E15,M41),IF(EXACT('Member Serviceability Calc'!G15,J43),'Member Serviceability Calc'!Q15,0),0)+IF(EXACT('Member Serviceability Calc'!E16,M41),IF(EXACT('Member Serviceability Calc'!G16,J43),'Member Serviceability Calc'!Q16,0),0)+IF(EXACT('Member Serviceability Calc'!E17,M41),IF(EXACT('Member Serviceability Calc'!G17,J43),'Member Serviceability Calc'!Q17,0),0)","v":0},{"$f":"IF(EXACT('Member Serviceability Calc'!E14,N41),IF(EXACT('Member Serviceability Calc'!G14,J43),'Member Serviceability Calc'!Q14,0),0)+IF(EXACT('Member Serviceability Calc'!E15,N41),IF(EXACT('Member Serviceability Calc'!G15,J43),'Member Serviceability Calc'!Q15,0),0)+IF(EXACT('Member Serviceability Calc'!E16,N41),IF(EXACT('Member Serviceability Calc'!G16,J43),'Member Serviceability Calc'!Q16,0),0)+IF(EXACT('Member Serviceability Calc'!E17,N41),IF(EXACT('Member Serviceability Calc'!G17,J43),'Member Serviceability Calc'!Q17,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K42:K43)","v":0},{"$f":"SUM(L42:L43)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(K42/K44,0)","v":0},0,0,{"$f":"IFERROR(N42/N44,0)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"AND('Member Serviceability Calc'!O14>0,'Tax Calc'!D9<0)","v":false}]

{"sheet":"Tax Calc","index":6,"n_rows":54,"n_cols":19,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["Tax Calc"]
[]
["Annual Gross",null,null,"Gross","Tax","Medicare","Income offset","Net","Net Monthly"]
[]
["Applicant / G'Tor 1","Salary / Self Employed",null,{"$f":"'Member Serviceability Calc'!O14*12","v":0},{"$f":"IF(D5<Tables!$A$6,0,IF(AND(D5>Tables!$A$6,D5<Tables!$A$7),(D5-Tables!$A$6)*Tables!$C$6,IF(AND(D5>Tables!$A$7,D5<Tables!$A$8),Tables!$D$7+(D5-Tables!$A$7)*Tables!$C$7,IF(AND(D5>Tables!$A$8,D5<Tables!$A$9),Tables!$D$8+(D5-Tables!$A$8)*Tables!$C$8,IF(D5>Tables!$A$9,Tables!$D$9+(D5-Tables!$A$9)*Tables!$C$9)))))","v":0},{"$f":"D5*Tables!C$16","v":0},{"$f":"IFERROR(((D5-VLOOKUP(D5,$A$29:$D$33,1,TRUE))*VLOOKUP(D5,$A$29:$D$33,3,TRUE)+VLOOKUP(D5,$A$29:$D$33,4,TRUE)),0)+IFERROR((IF(D5>66667,66667-45001,(D5-VLOOKUP(D5,$A$41:$D$43,1,TRUE)))*VLOOKUP(D5,$A$41:$D$43,3,TRUE)+VLOOKUP(D5,$A$41:$D$43,4,TRUE)),0)","v":0},{"$f":"D5-E5-F5+G5","v":0},{"$f":"H5/12","v":0}]
["Applicant / G'Tor 2","Salary / Self Employed",null,{"$f":"'Member Serviceability Calc'!O15*12","v":0},{"$f":"IF(D6<Tables!$A$6,0,IF(AND(D6>=Tables!$A$6,D6<Tables!$A$7),(D6-Tables!$A$6)*Tables!$C$6,IF(AND(D6>=Tables!$A$7,D6<Tables!$A$8),Tables!$D$7+(D6-Tables!$A$7)*Tables!$C$7,IF(AND(D6>=Tables!$A$8,D6<Tables!$A$9),Tables!$D$8+(D6-Tables!$A$8)*Tables!$C$8,IF(D6>=Tables!$A$9,Tables!$D$9+(D6-Tables!$A$9)*Tables!$C$9)))))","v":0},{"$f":"D6*Tables!C$16","v":0},{"$f":"IFERROR(((D6-VLOOKUP(D6,$A$29:$D$33,1,TRUE))*VLOOKUP(D6,$A$29:$D$33,3,TRUE)+VLOOKUP(D6,$A$29:$D$33,4,TRUE)),0)+IFERROR((IF(D6>66667,66667-45001,(D6-VLOOKUP(D6,$A$41:$D$43,1,TRUE)))*VLOOKUP(D6,$A$41:$D$43,3,TRUE)+VLOOKUP(D6,$A$41:$D$43,4,TRUE)),0)","v":0},{"$f":"D6-E6-F6+G6","v":0},0]
["Applicant / G'Tor 3","Salary / Self Employed",null,{"$f":"'Member Serviceability Calc'!O16*12","v":0},{"$f":"IF(D7<Tables!$A$6,0,IF(AND(D7>=Tables!$A$6,D7<Tables!$A$7),(D7-Tables!$A$6)*Tables!$C$6,IF(AND(D7>=Tables!$A$7,D7<Tables!$A$8),Tables!$D$7+(D7-Tables!$A$7)*Tables!$C$7,IF(AND(D7>=Tables!$A$8,D7<Tables!$A$9),Tables!$D$8+(D7-Tables!$A$8)*Tables!$C$8,IF(D7>=Tables!$A$9,Tables!$D$9+(D7-Tables!$A$9)*Tables!$C$9)))))","v":0},{"$f":"D7*Tables!C$16","v":0},0,0,0,null,null,null,null,null,{"$f":"'Member Serviceability Calc'!L26 - 'Member Serviceability Calc'!O14* 12","v":0}]
["Applicant / G'Tor 4","Salary / Self Employed",null,{"$f":"'Member Serviceability Calc'!O17*12","v":0},{"$f":"IF(D8<Tables!$A$6,0,IF(AND(D8>=Tables!$A$6,D8<Tables!$A$7),(D8-Tables!$A$6)*Tables!$C$6,IF(AND(D8>=Tables!$A$7,D8<Tables!$A$8),Tables!$D$7+(D8-Tables!$A$7)*Tables!$C$7,IF(AND(D8>=Tables!$A$8,D8<Tables!$A$9),Tables!$D$8+(D8-Tables!$A$8)*Tables!$C$8,IF(D8>=Tables!$A$9,Tables!$D$9+(D8-Tables!$A$9)*Tables!$C$9)))))","v":0},{"$f":"D8*Tables!C$16","v":0},0,0,0,null,null,null,null,null,{"$f":"'Member Serviceability Calc'!L27 - 'Member Serviceability Calc'!O15* 12","v":0}]
["Member 1","Salary / Self Employed",null,{"$f":"'Member Serviceability Calc'!L26 - 'Member Serviceability Calc'!O14* 12","v":0},{"$f":"IF(D9<Tables!$A$6,0,IF(AND(D9>=Tables!$A$6,D9<Tables!$A$7),(D9-Tables!$A$6)*Tables!$C$6,IF(AND(D9>=Tables!$A$7,D9<Tables!$A$8),Tables!$D$7+(D9-Tables!$A$7)*Tables!$C$7,IF(AND(D9>=Tables!$A$8,D9<Tables!$A$9),Tables!$D$8+(D9-Tables!$A$8)*Tables!$C$8,IF(D9>=Tables!$A$9,Tables!$D$9+(D9-Tables!$A$9)*Tables!$C$9)))))","v":0},{"$f":"D9*Tables!C$16","v":0},0,0,0,null,null,null,null,null,{"$f":"'Member Serviceability Calc'!L28 - 'Member Serviceability Calc'!O16* 12","v":0},null,null,null,100000]
["Member 2","Salary / Self Employed",null,{"$f":"'Member Serviceability Calc'!L27 - 'Member Serviceability Calc'!O15* 12","v":0},{"$f":"IF(D10<Tables!$A$6,0,IF(AND(D10>=Tables!$A$6,D10<Tables!$A$7),(D10-Tables!$A$6)*Tables!$C$6,IF(AND(D10>=Tables!$A$7,D10<Tables!$A$8),Tables!$D$7+(D10-Tables!$A$7)*Tables!$C$7,IF(AND(D10>=Tables!$A$8,D10<Tables!$A$9),Tables!$D$8+(D10-Tables!$A$8)*Tables!$C$8,IF(D10>=Tables!$A$9,Tables!$D$9+(D10-Tables!$A$9)*Tables!$C$9)))))","v":0},{"$f":"D10*Tables!C$16","v":0},0,0,0,null,null,null,null,null,{"$f":"'Member Serviceability Calc'!L29 - 'Member Serviceability Calc'!O17* 12","v":0},null,null,null,50000]
["Member 3","Salary / Self Employed",null,{"$f":"'Member Serviceability Calc'!L28 - 'Member Serviceability Calc'!O16* 12","v":0},{"$f":"IF(D11<Tables!$A$6,0,IF(AND(D11>=Tables!$A$6,D11<Tables!$A$7),(D11-Tables!$A$6)*Tables!$C$6,IF(AND(D11>=Tables!$A$7,D11<Tables!$A$8),Tables!$D$7+(D11-Tables!$A$7)*Tables!$C$7,IF(AND(D11>=Tables!$A$8,D11<Tables!$A$9),Tables!$D$8+(D11-Tables!$A$8)*Tables!$C$8,IF(D11>=Tables!$A$9,Tables!$D$9+(D11-Tables!$A$9)*Tables!$C$9)))))","v":0},{"$f":"D11*Tables!C$16","v":0},0,0,0,null,null,null,null,null,null,null,null,null,40000]
["Member 4","Salary / Self Employed",null,{"$f":"'Member Serviceability Calc'!L29 - 'Member Serviceability Calc'!O17* 12","v":0},{"$f":"IF(D12<Tables!$A$6,0,IF(AND(D12>=Tables!$A$6,D12<Tables!$A$7),(D12-Tables!$A$6)*Tables!$C$6,IF(AND(D12>=Tables!$A$7,D12<Tables!$A$8),Tables!$D$7+(D12-Tables!$A$7)*Tables!$C$7,IF(AND(D12>=Tables!$A$8,D12<Tables!$A$9),Tables!$D$8+(D12-Tables!$A$8)*Tables!$C$8,IF(D12>=Tables!$A$9,Tables!$D$9+(D12-Tables!$A$9)*Tables!$C$9)))))","v":0},{"$f":"D12*Tables!C$16","v":0},0,0,0,null,null,null,null,null,null,null,null,null,20000]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Total Income "]
[null,null,null,null,null,null,null,null,null,null,"Household 1",{"$f":"IF('Member Serviceability Calc'!E26 = 'Tax Calc'!K18,'Member Serviceability Calc'!N26,0)","v":0}]
["Test lower and middle income offset",null,null,"Formula","( income - income lower range ) *offset rate + baseline",null,null,null,null,null,null,{"$f":"IF('Member Serviceability Calc'!E27 = 'Tax Calc'!K18,'Member Serviceability Calc'!N27,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Member Serviceability Calc'!E28 = 'Tax Calc'!K18,'Member Serviceability Calc'!N28,0)","v":0}]
["income","offset baseline","Income lower range","Income - Lower range","offset reduced %","offset reduced amount","offset amount",null,null,null,null,{"$f":"IF('Member Serviceability Calc'!E29 = 'Tax Calc'!K18,'Member Serviceability Calc'!N29,0)","v":0}]
[80000,{"$f":"VLOOKUP(A22,A29:D33,4,TRUE)","v":0},{"$f":"VLOOKUP(A22,A29:D33,1,TRUE)","v":48001},{"$f":" A22-C22","v":31999},{"$f":"VLOOKUP(A22,A29:D33,3,TRUE)","v":0},{"$f":"+D22*E22","v":0},{"$f":"SUM(B22,F22)","v":0},null,null,null,null,{"$f":"SUM(L18:L21)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Household 2",{"$f":"IF('Member Serviceability Calc'!E26 = K24,'Member Serviceability Calc'!N26,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Member Serviceability Calc'!E27 = K24,'Member Serviceability Calc'!N27,0)","v":0}]
["Lower and Middle income offset",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Member Serviceability Calc'!E28 = K24,'Member Serviceability Calc'!N28,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Member Serviceability Calc'!E29 = K24,'Member Serviceability Calc'!N29,0)","v":0}]
["Wages Over","Not to Exceed","Tax Rate",null,null,null,null,null,null,null,null,{"$f":"SUM(L24:L27)","v":0}]
[1,37000,null,0]
[{"$f":"B29+1","v":37001},48000,0,0,null,null,null,null,null,null,"Household 3",{"$f":"IF('Member Serviceability Calc'!E26 = K30,'Member Serviceability Calc'!N26,0)","v":0}]
[{"$f":"B30+1","v":48001},90000,0,0,null,null,null,null,null,null,null,{"$f":"IF('Member Serviceability Calc'!E27 = K30,'Member Serviceability Calc'!N27,0)","v":0}]
[{"$f":"B31+1","v":90001},126000,0,0,null,null,null,null,null,null,null,{"$f":"IF('Member Serviceability Calc'!E28 = K30,'Member Serviceability Calc'!N28,0)","v":0}]
[{"$f":"B32+1","v":126001},null,0,0,null,null,null,null,null,null,null,{"$f":"IF('Member Serviceability Calc'!E29 = K30,'Member Serviceability Calc'!N29,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L30:L33)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Household 4",{"$f":"IF('Member Serviceability Calc'!E26 = K36,'Member Serviceability Calc'!N26,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Member Serviceability Calc'!E27 = K36,'Member Serviceability Calc'!N27,0)","v":0}]
["Low Income offset",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Member Serviceability Calc'!E28 = K36,'Member Serviceability Calc'!N28,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Member Serviceability Calc'!E29 = K36,'Member Serviceability Calc'!N29,0)","v":0}]
["Wages Over","Not to Exceed","Tax Rate",null,null,null,null,null,null,null,null,{"$f":"SUM(L36:L39)","v":0}]
[1,37500,null,0,null,null,null,null,null,null,{"$f":"I41*52","v":0}]
[{"$f":"B41+1","v":37501},45000,0,0]
[{"$f":"B42+1","v":45001},66667,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Member 1","Member 2","Member 3","Member 4"]
[null,null,null,null,null,null,null,null,null,null,null,"Household 1",{"$f":"IF('Member Serviceability Calc'!E26 = 'Tax Calc'!L45,'Member Serviceability Calc'!N26/'Tax Calc'!L22,0)","v":0},{"$f":"IF('Member Serviceability Calc'!E27 = 'Tax Calc'!L45,'Member Serviceability Calc'!N27/'Tax Calc'!L22,0)","v":0},{"$f":"IF('Member Serviceability Calc'!E28 = 'Tax Calc'!L45,'Member Serviceability Calc'!N28/'Tax Calc'!L22,0)","v":0},{"$f":"IF('Member Serviceability Calc'!E29 = 'Tax Calc'!L45,'Member Serviceability Calc'!N29/'Tax Calc'!L22,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Household 2",{"$f":"IF('Member Serviceability Calc'!E26 = 'Tax Calc'!L46,'Member Serviceability Calc'!N26/L28,0)","v":0},{"$f":"IF('Member Serviceability Calc'!E27 = 'Tax Calc'!L46,'Member Serviceability Calc'!N27/L28,0)","v":0},{"$f":"IF('Member Serviceability Calc'!E28 = 'Tax Calc'!L46,'Member Serviceability Calc'!N28/L28,0)","v":0},{"$f":"IF('Member Serviceability Calc'!E29 = 'Tax Calc'!L46,'Member Serviceability Calc'!N29/L28,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Household 3",{"$f":"IF('Member Serviceability Calc'!E26 = 'Tax Calc'!L47,'Member Serviceability Calc'!N26/L34,0)","v":0},{"$f":"IF('Member Serviceability Calc'!E27 = 'Tax Calc'!L47,'Member Serviceability Calc'!N27/L34,0)","v":0},{"$f":"IF('Member Serviceability Calc'!E28 = 'Tax Calc'!L47,'Member Serviceability Calc'!N28/L34,0)","v":0},{"$f":"IF('Member Serviceability Calc'!E29 = 'Tax Calc'!L47,'Member Serviceability Calc'!N29/L34,0)","v":0}]
["Test low income",null,null,null,null,null,null,null,null,null,null,"Household 4",{"$f":"IF('Member Serviceability Calc'!E26 = 'Tax Calc'!L48,'Member Serviceability Calc'!N26/L40,0)","v":0},{"$f":"IF('Member Serviceability Calc'!E27 = 'Tax Calc'!L48,'Member Serviceability Calc'!N27/L40,0)","v":0},{"$f":"IF('Member Serviceability Calc'!E28 = 'Tax Calc'!L48,'Member Serviceability Calc'!N28/L40,0)","v":0},{"$f":"IF('Member Serviceability Calc'!E29 = 'Tax Calc'!L48,'Member Serviceability Calc'!N29/L40,0)","v":0}]
[]
["income","offset baseline","Income lower range","Income - Lower range","offset reduced %","offset reduced amount","offset amount"]
[80000,{"$f":"VLOOKUP(A51,A41:D43,4,TRUE)","v":0},{"$f":"VLOOKUP(A51,A41:D43,1,TRUE)","v":45001},{"$f":"IF(A51>66667, 66667-45001, A51-C51)","v":21666},{"$f":"VLOOKUP(A51,A41:D43,3,TRUE)","v":0},{"$f":"+D51*E51","v":0},{"$f":"SUM(B51,F51)","v":0},null,null,null,null,"Member 1",{"$f":"I9","v":0},{"$f":"IF('Member Serviceability Calc'!F26 = 'Tax Calc'!M45,'Tax Calc'!N45*'Tax Calc'!J9,IF('Member Serviceability Calc'!F26 = 'Tax Calc'!M46,'Tax Calc'!J10*'Tax Calc'!N46,IF('Member Serviceability Calc'!F26 = 'Tax Calc'!M47,'Tax Calc'!J11*'Tax Calc'!N47,IF('Member Serviceability Calc'!F26 = 'Tax Calc'!M48,'Tax Calc'!J12*'Tax Calc'!N48,0))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Member 2",{"$f":"I10","v":0},{"$f":"IF('Member Serviceability Calc'!F27 = 'Tax Calc'!M45,'Tax Calc'!O45*'Tax Calc'!J9,IF('Member Serviceability Calc'!F27 = 'Tax Calc'!M46,'Tax Calc'!J10*'Tax Calc'!O46,IF('Member Serviceability Calc'!F27 = 'Tax Calc'!M47,'Tax Calc'!J11*'Tax Calc'!O47,IF('Member Serviceability Calc'!F27 = 'Tax Calc'!M48,'Tax Calc'!J12*'Tax Calc'!O48,0))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Member 3",0,{"$f":"IF('Member Serviceability Calc'!F28 = 'Tax Calc'!M45,'Tax Calc'!P45*'Tax Calc'!J9,IF('Member Serviceability Calc'!F28 = 'Tax Calc'!M46,'Tax Calc'!J10*'Tax Calc'!P46,IF('Member Serviceability Calc'!F28 = 'Tax Calc'!M47,'Tax Calc'!J11*'Tax Calc'!P47,IF('Member Serviceability Calc'!F28 = 'Tax Calc'!M48,'Tax Calc'!J12*'Tax Calc'!P48,0))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Member 4",0,{"$f":"IF('Member Serviceability Calc'!F29 = 'Tax Calc'!M45,'Tax Calc'!Q45*'Tax Calc'!J9,IF('Member Serviceability Calc'!F29 = 'Tax Calc'!M46,'Tax Calc'!J10*'Tax Calc'!Q46,IF('Member Serviceability Calc'!F29 = 'Tax Calc'!M47,'Tax Calc'!J11*'Tax Calc'!Q47,IF('Member Serviceability Calc'!F29 = 'Tax Calc'!M48,'Tax Calc'!J12*'Tax Calc'!Q48,0))))","v":0}]

{"sheet":"User Problems","index":7,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["#","Date","Submitted By","Sheet Name (if applicable)","Problem","Initial Review Assessment","Review Result Date","Review With User","Review Result or Action to Take","Sheets Affected","Development Version #","Type","Estimate (hrs)","Actual","Status","Date Unit Tested","Release Version #"]
[1,"2017-04-06","Bill Slattery",null,"What we are trying to achieve is a stress test of servicing capacity at the higher of;\n1. The selected interest rate + 2% or \n2. 7% \nThis change should only apply to Residential loans.\n",null,null,null,null,null,{"$f":"'Version Control'!C2","v":"V6.4 Test"},"Enhancement",null,null,"Completed","2017-04-10",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[2,"2017-04-10","Trevor Smith",null,"The tax table in the Residential calculator is not the same as in the Consolidated Calculator. Looks like the Residential Calculator was not updated for the 2017/2018 change to the upper limit for the 32.5% rate (ie from $80000 to $87000).","Change the tax table in the Residential Calculator in expectation you want it to match that in the Consolidated Calculator.","2017-04-10","Bill Slattery","Change as recommended",null,{"$f":"'Version Control'!C3","v":"V6.4 Test2  (v6.42)"},"Bug",null,null,"Completed","2017-04-10",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[3,"2017-04-24","Bill Slattery","Serviceability Calc","Add Serviceabilty Calculation Sheet as per Consolidated User Problem #131.","Name as \"Serviceability Calc\"",null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[4,"2017-04-24","Mario Lorenzi",null,"Add two macros:\n-Ctl/Shift/B to unhide the calculation sheets\n-Ctl/Shift/H to hide the calculation sheets\n",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[5,"2017-04-24","Mario Lorenzi","Tables","Change Company Tax Rate to 28.5%","Set up a  a new Company Tax Table on Tables sheet. Change Company Income Calculation (Cell K18) to reference the new Company Tax Table.",null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Data Maintenance",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[6,"2017-04-24","Mario Lorenzi","Serviceability","Add Interest Only Term cells for RedZed Loans 1 and 2 on Serviceability sheet.\nChange the Rate buffering calculation to use the net term (Total Term less Interest Only Term)",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[7,"2017-04-24","Mario Lorenzi","Serviceability","Add Source of Other Incomes cell for each of the Other Regular Monthly Income lines on the Serviceability sheets.",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[8,"2017-04-24","Mario Lorenzi","Serviceability","Change Company Income heading to display \"Company Income (if applicable)\"",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[9,"2017-04-24","Mario Lorenzi","Serviceability","Swap columns displaying Existing & New v Rental Income/Rental Income ",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[10,"2017-04-24","Mario Lorenzi","Tables","Check Monthly Service Fee calculation - to assume entry of Residential Loans only - calculated at $15 per month",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Bug",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[11,"2017-04-24","Mario Lorenzi","Serviceability","Company Income headings realigned to display above the detail line",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[12,"2017-04-24","Mario Lorenzi","Serviceability","Company Income section moved to display after Rental Income",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[13,"2017-04-24","Mario Lorenzi","Serviceability","Change Personal Income descriptors from \"Guarantor 1, 2, 3, and 4\" to \"Applicant / Guarantor 1, 2, 3, and 4\"",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[14,"2017-04-24","Mario Lorenzi","Tables","Tables Sheet - Highlight in yellow those data cells that can be changed to reflect legislation or company policy changes.",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[15,"2017-06-08","Mario Lorenzi","Tax Calc","Tax Calc Sheet - delete Other Income Cells A10 to I13",null,null,null,null,null,{"$f":"'Version Control'!$C$5","v":"V6.8 Test (v6.44)"},"Enhancement",null,null,"Completed","2017-06-15",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[16,"2017-06-08","Mario Lorenzi","Tax Calc","Tax Calc Sheet - delete \"Correct Formula For Serviceability - Don’t Think Arm Can Do This\" Cells L1 to R25",null,null,null,null,null,{"$f":"'Version Control'!$C$5","v":"V6.8 Test (v6.44)"},"Enhancement",null,null,"Completed","2017-06-15",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[17,"2017-06-08","Mario Lorenzi","Serviceability","Fix formatting of Financier Cells for Existing Loans",null,null,null,null,null,{"$f":"'Version Control'!$C$5","v":"V6.8 Test (v6.44)"},"Bug",null,null,"Completed","2017-06-15",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[18,"2017-06-19","Trevor Smith","User Problems\nVersion Control","Add Sheets for User Problems and Version Control.",null,null,null,null,null,{"$f":"'Version Control'!$C$6","v":"V6.9 (v6.45)"},"Enhancement",null,null,"Completed","2017-06-20",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[19,"2017-06-19","Angelo Klidomitis","Serviceability","Change Look & Feel as per 4.0 ServiceabilityCalculator.xlsx",null,null,null,null,null,{"$f":"'Version Control'!$C$6","v":"V6.9 (v6.45)"},"Enhancement",null,null,"Completed","2017-06-21",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[20,"2017-05-22","Mario Lorenzi & Bill Slattery","Serviceability","Increase readability of printed version of the sheet",null,null,null,null,null,{"$f":"'Version Control'!C7","v":"V6.10 (v6.46)"},"Enhancement",null,null,"Completed","2017-06-26",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[21,"2017-06-29","Mario Lorenzi","Serviceability","1) Borders missing for  Enter Source of Income, Rental Income, Maintenance, & Other Fixed Monthly Repayments.\n2) Enter a zero in each dollar entry cell so the user is aware it is available for entry.",null,null,null,null,null,{"$f":"'Version Control'!C8","v":"v6.47 Pending"},"Enhancement & Bug",null,null,"Completed","2017-06-29",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[22,"2018-11-20","Lorraine Taylor ","Servicebility","IF more then three adult in one household please display the mssage",null,null,null,null,null,"V7.3",null,null,null,"Completed","2018-11-20","V7.3"]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]

{"sheet":"Version Control","index":8,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["Name","Date","Version #","Development Version File Name","Changes","Released Version",null,"Current Version",{"$f":"VLOOKUP($J$1,B2:$I$3984,8,FALSE)","v":"v1.6 250108"},{"$f":"MAX(B2:B3984)","v":"2025-01-08"}]
["Trevor Smith","2017-04-10","V6.4 Test","K:\\IT\\Change_Work Requests\\Work Request\\WR004 - Commercial Calculator\\02 Residential Calculator\\2017 05 Changes\\4. REDZED-Serviceability-170410-V6.4 Test2.xls","User Problem 1",null,{"$f":"IFERROR(VLOOKUP(MONTH(B2),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B2),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0410"},{"$f":"RIGHT(YEAR(B2),2)&G2","v":"170410"},{"$f":"CONCATENATE(C2,\" \",H2)","v":"V6.4 Test 170410"}]
["Trevor Smith","2017-04-10","V6.4 Test2  (v6.42)","K:\\IT\\Change_Work Requests\\Work Request\\WR004 - Commercial Calculator\\02 Residential Calculator\\2017 05 Changes\\4. REDZED-Serviceability-170410-V6.4 Test.xls","User Problem 2",null,{"$f":"IFERROR(VLOOKUP(MONTH(B3),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B3),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0410"},{"$f":"RIGHT(YEAR(B3),2)&G3","v":"170410"},{"$f":"CONCATENATE(C3,\" \",H3)","v":"V6.4 Test2  (v6.42) 170410"}]
["Trevor Smith","2017-05-01","V6.6 Test (v6.43)","K:\\IT\\Change_Work Requests\\Work Request\\WR004 - Commercial Calculator\\02 Residential Calculator\\2017 05 Changes\\4. REDZED-Serviceability-170410-V6.6 Test.xls","User Problems 3 - 14 inclusive",null,{"$f":"IFERROR(VLOOKUP(MONTH(B4),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B4),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0501"},"170501","V6.6 Test (v6.43) 170501"]
["Trevor Smith","2017-05-15","V6.8 Test (v6.44)","K:\\IT\\Change_Work Requests\\Work Request\\WR004 - Commercial Calculator\\02 Residential Calculator\\2017 05 Changes\\4. REDZED-Serviceability-170410-V6.8 Test.xls","User Problems 15 - 17 inclusive",null,{"$f":"IFERROR(VLOOKUP(MONTH(B5),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B5),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0515"},"170515","V6.8 Test (v6.44) 170515"]
["Trevor Smith","2017-06-21","V6.9 (v6.45)","K:\\IT\\Change_Work Requests\\Work Request\\WR004 - Commercial Calculator\\02 Residential Calculator\\2017 05 Changes\\4. REDZED-Serviceability-170410-V6.9.xls","User Problem 18 - 19","Issued to Mario Lorenzi for testing 20 June 2017",{"$f":"IFERROR(VLOOKUP(MONTH(B6),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B6),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0621"},"170621","V6.9 (v6.45) 170621"]
["Trevor Smith","2017-06-27","V6.10 (v6.46)","K:\\IT\\Change_Work Requests\\Work Request\\WR004 - Commercial Calculator\\02 Residential Calculator\\2017 05 Changes\\4. REDZED-Serviceability-170410-V6.10.xls\nA changed versioning system for both this Residential Calculator and the Commercial Calculator was agreed with Tina Georgiadis 26 June 2015 (after receiving feedback from Angel Klidomitis). The last version of the Residential Calculator was named \"4. REDZED-Serviceability-170410-V6.4.xls\". The naming convention is being changed to \"REDZED-Serviceability Type (ie Residential or Commercial) Version Number.xls\". Each release will have a date added as a suffix in the format yymmdd. Because the upcoming release does not contain major ammendments it will be named  \"REDZED-Serviceability Residential v6.5 yymmdd.xls\". This being the case, the naming of the development files should have been as per the bracketed values in the Version # cells (eg 4. REDZED-Serviceability-170410-V6.4 Test.xls should have been 4. REDZED-Serviceability-170410-V6.41.xls)\nTo move to the new numbering system this version was copied and renamed and saved to the new development and release folder structure 26 June 2017. The new location and file name is K:\\Credit\\Servicing Calculator - Residential\\Development - Residential\\REDZED-Serviceability Residential V0.646.xlsm. The released version number for this series of amendments will be v6.5 with a date added in the format yymmdd.","A renamed version + User Problem 20",null,{"$f":"IFERROR(VLOOKUP(MONTH(B7),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B7),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0627"},"170627","V6.10 (v6.46) 170627"]
["Trevor Smith","2017-06-29","v6.47 Pending","K:\\Credit\\Servicing Calculator - Residential\\Development - Residential\\REDZED-Serviceability Residential V0.647.xlsm","User Problem 21",null,{"$f":"IFERROR(VLOOKUP(MONTH(B8),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B8),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0629"},"170629","v6.47 Pending 170629"]
["Trevor Smith","2017-06-30","v6.5",null,null,"K:\\Credit\\Servicing Calculator - Residential\\Current Released Version - Residential\\REDZED-Serviceability Residential V6.5.xlsm",{"$f":"IFERROR(VLOOKUP(MONTH(B9),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B9),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0630"},"170630","v6.5 170630"]
["Mayank Badhen","2018-06-25","V7.1A","Updated the living expense ",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B10),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B10),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0625"},"180625","V7.1A 180625"]
["Mayank Badhen","2018-07-25","V7.2","updated living expense for Company\nselecting household is mandatory\nupdated the tax scale\ncompnay income is always attached to household 1",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B11),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B11),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0725"},"180725","V7.2 180725"]
["Mayank Badhen","2018-12-11","V7.2.1","IF more then three adult in one household please display the mssage",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B12),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B12),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"1211"},"181211","V7.2.1 181211"]
["Mayank Badhen","2019-06-26","V7.3","credit card obligations",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B13),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B13),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0626"},"190626","V7.3 190626"]
["Mayank Badhen","2019-12-02","V7.4","IO term fixed",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B14),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B14),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"1202"},"191202","V7.4 191202"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B15),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B15),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"N/A"},"00N/A"," 00N/A"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B16),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B16),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"N/A"},"00N/A"," 00N/A"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B17),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B17),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"N/A"},"00N/A"," 00N/A"]
["John Jiang","2020-07-30","V10.0","1. Residential calculator \na. Introduction of a traffic light Pass, Refer to RZ or Fail notification. Pass >1.10, Refer >1.05 – 1.10, Fail below 1.05. The introduction of the Refer category is designed to encourage brokers to Refer deals where we don’t quite meet servicing requirements, but in discussion with RZ we may jointly find a way forward. Potentially these deals may be currently being sent to other lenders who have lower servicing ratio benchmarks). \nb. Creating a blank template.\nc. Removal of the tax calculation for company income to fall in line with the policy which states that we assess on NPBT.\n \nOther general changes including ensuring;\n1. Living expenses were consistent across all selections (there were some errors & inconsistencies)\n2. Tax scales were checked and amended for consistency.\n",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B18),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B18),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0730"},"200730","V10.0 200730"]
["John Jiang","2020-08-13","V10.0 Residential","Changed footer",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B19),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B19),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0813"},"200813","V10.0 Residential 200813"]
["John Jiang","2020-11-16","V10.1","changed tax bracket to new 2020 tax regulation",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B20),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B20),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"1116"},"201116","V10.1 201116"]
["John Jiang","2020-12-17","V10.11","change interest floor rate from 7% to 6%",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B21),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B21),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"1217"},"201217","V10.11 201217"]
["John Jiang","2021-01-15","V10.12","Update HEM table according to Sept 2020 quarter data from HEM",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B22),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B22),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0115"},"210115","V10.12 210115"]
["John Jiang","2021-09-15","V10.13","Update HEM table according to 2021 June quarter HEM review data",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B23),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B23),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0915"},{"$f":"RIGHT(YEAR(B23),2)&G23","v":"210915"},{"$f":"CONCATENATE(C23,\" \",H23)","v":"V10.13 210915"}]
["John Jiang","2021-10-27","V10.14","Add a footnote in resi calculator only. ","For Company Borrowers DSR must be >1.10",null,{"$f":"IFERROR(VLOOKUP(MONTH(B24),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B24),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"1027"},{"$f":"RIGHT(YEAR(B24),2)&G24","v":"211027"},{"$f":"CONCATENATE(C24,\" \",H24)","v":"V10.14 211027"}]
["Shun","2022-04-06","V10.15","Add DTI Calculation",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B25),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B25),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0406"},"220406","V10.15 220406"]
["Shun","2022-06-16","V10.16","Update Buffer and Floor Rates  && Add the Total Credit Card Limit values to the Total Debt value && Update HEM Rates Q1 2022",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B26),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B26),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0616"},"220616","V10.16 220616"]
["Shun ","2022-07-15","v10.17","Update tax rate",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B27),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B27),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0715"},"220715","v10.17 220715"]
["Shun","2022-08-22","v10.18","Update Hem Rate",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B28),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B28),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0822"},"220822","v10.18 220822"]
["Shun ","2022-11-29","v10.19","Update Hem Rate",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B29),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B29),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"1129"},"221129","v10.19 221129"]
["Shun ","2023-03-06","v10.20","Update Hem Rate",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B30),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B30),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0306"},"230306","v10.20 230306"]
["Shun","2023-05-23","v10.21","Update Hem Rate",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B31),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B31),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0523"},"230523","v10.21 230523"]
["Shun","2023-08-03","v10.22","Split 3 Loans",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B32),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B32),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0803"},"230803","v10.22 230803"]
["Shun","2023-08-15","v10.23","Update APR Buffer",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B33),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B33),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0815"},"230815","v10.23 230815"]
["Shun","2023-08-23","v10.24","Update HEM Rate",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B34),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B34),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0823"},"230823","v10.24 230823"]
["Shun","2023-08-31","v10.25","Update the UI",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B35),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B35),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0831"},"230831","v10.25 230831"]
["Shun","2023-09-01","v10.26","Change the old logic to calcualtor the member level DSR",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B36),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B36),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0901"},{"$f":"RIGHT(YEAR(B36),2)&G36","v":"230901"},{"$f":"CONCATENATE(C36,\" \",H36)","v":"v10.26 230901"}]
["Shun","2023-09-02","v10.27","Update some wording",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B37),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B37),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0902"},"230902","v10.27 230902"]
["Shun","2024-07-01","v1.3","Change the Version number for SMSF Calculator",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B38),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B38),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0701"},"240701","v1.3 240701"]
["Shun","2024-07-02","v1.4","Add different Rental income to member and funding level ",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B39),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B39),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0702"},{"$f":"RIGHT(YEAR(B39),2)&G39","v":"240702"},{"$f":"CONCATENATE(C39,\" \",H39)","v":"v1.4 240702"}]
["Shun","2024-11-18","v1.5","Update HEM Rate",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B40),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B40),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"1118"},{"$f":"RIGHT(YEAR(B40),2)&G40","v":"241118"},{"$f":"CONCATENATE(C40,\" \",H40)","v":"v1.5 241118"}]
["Shun","2025-01-08","v1.6","Update the warning banner for minium liquid asset ",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B41),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B41),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0108"},{"$f":"RIGHT(YEAR(B41),2)&G41","v":"250108"},{"$f":"CONCATENATE(C41,\" \",H41)","v":"v1.6 250108"}]

{"sheet":"Day and Months Table","index":9,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[1,"01"]
[2,"02"]
[3,"03"]
[4,"04"]
[5,"05"]
[6,"06"]
[7,"07"]
[8,"08"]
[9,"09"]
[10,"10"]
[11,"11"]
[12,"12"]
[13,"13"]
[14,"14"]
[15,"15"]
[16,"16"]
[17,"17"]
[18,"18"]
[19,"19"]
[20,"20"]
[21,"21"]
[22,"22"]
[23,"23"]
[24,"24"]
[25,"25"]
[26,"26"]
[27,"27"]
[28,"28"]
[29,"29"]
[30,"30"]
[31,"31"]