{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["SMSF","User Guide - SMSF","HEM Table","Validation","Tax Table","Inputs","Version Control","Superannuation Assessment notes","Loan Summary","Conditions","Workings"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":168,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SMSF","index":0,"n_rows":95,"n_cols":20,"rows_kept":95,"cut":false,"hidden":false,"merged":[[3,4,3,12],[71,6,71,12],[24,4,24,14],[43,2,49,4],[22,4,22,14],[19,4,19,14],[94,0,94,16],[7,18,9,18],[26,18,29,18],[48,12,48,14],[49,12,49,14]]}
[null,"SMSF Servicability Calculator"]
[null,null,"Version v2 - Effective 16th October 2023"]
[]
[null,null,"SMSF Name"]
[]
[null,null,"Proposed Loan Details"]
[]
[null,null,"New Loan Amount",null,null,null,null,null,null,null,"Interest Rate",null,null,null,null,null,null,null,"Interest expense annually"]
[null,null,null,null,null,null,null,null,null,null,"Loan Term (Years)"]
[null,null,null,null,null,null,null,null,null,null,"I/O Term (Years)"]
[null,null,null,null,null,null,null,null,null,null,"P&I Repayment",null,{"$f":"IF(LoanTermInYears>IOTermInYears,-PMT((MAX(BaselineAssessmentRate,InterestRate+AssessmentLoading))/NumberOfMonthsInAYear,NumberOfMonthsInAYear*(LoanTermInYears-IOTermInYears),NewLoanAmount),0)","v":0},null,null,null,null,null,{"$f":"E8*((MAX(BaselineAssessmentRate,InterestRate+AssessmentLoading)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"IO Repayment",null,{"$f":"IF(IOTermInYears>0,NewLoanAmount*(((MAX(BaselineAssessmentRate,InterestRate+AssessmentLoading)))/NumberOfMonthsInAYear),0)","v":0}]
[]
[]
[null,null,"Members Contributions"]
[]
[null,null,"Member Details",null,"Member 1",null,"Member 2",null,"Member 3",null,"Member 4",null,"Member 5",null,"Member 6",null,null,null,"Total"]
[]
[null,null,"Superannuation guarantee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E19+G19+I19+K19+M19+O19)","v":0}]
[null,null,{"$f":"IF(OR(AND(PAYGIncomeM1=0,(SuperGuaranteeContributionM1+ProposedConcessionalContributionsM1+E22)>ConcessionalContributionsCappedAmount),AND((SuperGuaranteeContributionM2+ProposedConcessionalContributionsM2+G22)>ConcessionalContributionsCappedAmount),AND((SuperGuaranteeContributionM3+ProposedConcessionalContributionsM3+I22)>ConcessionalContributionsCappedAmount),AND((SuperGuaranteeContributionM4+ProposedConcessionalContributionsM4+K22)>ConcessionalContributionsCappedAmount),AND((SuperGuaranteeContributionM5+ProposedConcessionalContributionsM5+M22)>ConcessionalContributionsCappedAmount),AND((SuperGuaranteeContributionM6+ProposedConcessionalContributionsM6+O22)>ConcessionalContributionsCappedAmount)),\"Concessional cap of \" & TEXT(ConcessionalContributionsCappedAmount,\"$00,000\") & \" has been exceeded\",\"\")","v":""},null,{"$f":"IF(OR(AND(PAYGIncomeM1>0,SuperGuaranteeContributionM1>(PAYGIncomeM1*CompulsarySuperannuationPercentage)),AND(PAYGIncomeM2>0,SuperGuaranteeContributionM2>(PAYGIncomeM2*CompulsarySuperannuationPercentage)),AND(PAYGIncomeM3>0,SuperGuaranteeContributionM3>(PAYGIncomeM3*CompulsarySuperannuationPercentage)),AND(PAYGIncomeM4>0,SuperGuaranteeContributionM4>(PAYGIncomeM4*CompulsarySuperannuationPercentage)),AND(PAYGIncomeM5>0,SuperGuaranteeContributionM5>(PAYGIncomeM5*CompulsarySuperannuationPercentage)),AND(PAYGIncomeM6>0,SuperGuaranteeContributionM6>(PAYGIncomeM6*CompulsarySuperannuationPercentage))),\"Value > allowable guarantee value calculated on enter PAYG income\",\"\")","v":""}]
[null,null,"PROPOSED CONCESSIONAL contributions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E21+G21+I21+K21+M21+O21)","v":0}]
[null,null,"EXISTING CONCESSIONAL contributions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E22+G22+I22+K22+M22+O22)","v":0}]
[null,null,{"$f":"IF(OR(AND(ProposedConcessionalContributionsM1>0,(SuperGuaranteeContributionM1+ProposedConcessionalContributionsM1+E22)>ConcessionalContributionsCappedAmount),AND(ProposedConcessionalContributionsM2>0,(SuperGuaranteeContributionM2+ProposedConcessionalContributionsM2+G22)>ConcessionalContributionsCappedAmount),AND(ProposedConcessionalContributionsM3>0,(SuperGuaranteeContributionM3+ProposedConcessionalContributionsM3+I22)>ConcessionalContributionsCappedAmount),AND(ProposedConcessionalContributionsM4>0,(SuperGuaranteeContributionM4+ProposedConcessionalContributionsM4+K22)>ConcessionalContributionsCappedAmount),AND(ProposedConcessionalContributionsM5>0,(SuperGuaranteeContributionM5+ProposedConcessionalContributionsM5+M22)>ConcessionalContributionsCappedAmount),AND(ProposedConcessionalContributionsM6>0,(SuperGuaranteeContributionM6+ProposedConcessionalContributionsM6+O22)>ConcessionalContributionsCappedAmount)),\"Concessional cap of \" & TEXT(ConcessionalContributionsCappedAmount,\"$00,000\") & \" has been exceeded\",\"\")","v":""}]
[null,null,"Additional NON-CONCESSIONAL contributions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E24+G24+I24+K24+M24+O24)","v":0}]
[null,null,{"$f":"IF(OR(AdditionalNonConcessionalContributionsM1>NonConcessionalContributionsCappedAmount,AdditionalNonConcessionalContributionsM2>NonConcessionalContributionsCappedAmount,AdditionalNonConcessionalContributionsM3>NonConcessionalContributionsCappedAmount,AdditionalNonConcessionalContributionsM4>NonConcessionalContributionsCappedAmount,AdditionalNonConcessionalContributionsM5>NonConcessionalContributionsCappedAmount,AdditionalNonConcessionalContributionsM6>NonConcessionalContributionsCappedAmount),\"Non-Concessional cap of \" & TEXT(NonConcessionalContributionsCappedAmount,\"$000,000\") & \" has been exceeded\",\"\")","v":""},null,{"$f":"IF(AND(SUM(Validation!B17:G17)<=0,OR(AdditionalNonConcessionalContributionsM1>AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1,AdditionalNonConcessionalContributionsM2>AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM2,AdditionalNonConcessionalContributionsM3>AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM3,AdditionalNonConcessionalContributionsM4>AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM4,AdditionalNonConcessionalContributionsM5>AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM5,AdditionalNonConcessionalContributionsM6>AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM6)),\"Member income & expense (below) incomplete or additional contribution unaffordable\",\"\")","v":""}]
[]
[null,null,"SMSF Income / Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Interest Expenses of Other AMSF Mortgages plus Loading"]
[]
[null,null,"SMSF Income",null,"Annual",null,null,null,"SMSF Expenses",null,null,null,"Other SMSF Mortgages"]
[null,null,"Member Contibutions - Concessional",null,{"$f":"SUM(SuperGuaranteeContributionM1,SuperGuaranteeContributionM2,SuperGuaranteeContributionM3,SuperGuaranteeContributionM4,SuperGuaranteeContributionM5,SuperGuaranteeContributionM6,ProposedConcessionalContributionsM1,ProposedConcessionalContributionsM2,ProposedConcessionalContributionsM3,ProposedConcessionalContributionsM4,ProposedConcessionalContributionsM5,ProposedConcessionalContributionsM6,E22:O22)","v":0},null,null,null,"Administration",null,null,null,"Total Loan Amount"]
[null,null,"Member Contibutions - Non Concessional",null,{"$f":"MAX(0,SUM(AdditionalNonConcessionalContributionsM1,AdditionalNonConcessionalContributionsM2,AdditionalNonConcessionalContributionsM3,AdditionalNonConcessionalContributionsM4,AdditionalNonConcessionalContributionsM5,AdditionalNonConcessionalContributionsM6))","v":0},null,null,null,"Other Mortgage Repayment (stressed)",null,{"$f":"TotalSMSFOtherMortgagesAnnualRepayment*12*OtherMortgageRepaymentBuffer","v":0},null,"Monthly Repayment"]
[null,null,"Income on other SMSF investments",null,null,null,null,null,"Other P&L expenses",null,null,null,"Interest Rate",null,null,null,null,null,{"$f":"TotalSMSFOtherMortgagesLoanAmount*(TotalSMSFOtherMortgagesAnnualInterestRate*OtherMortgageRepaymentBuffer)","v":0}]
[null,null,"Proposed Net CRE Rental Income",null,null,null,null,null,"Total Expenses",null,{"$f":"MAX(TotalSMSFAdministrationCost,IF(OR(TotalGrossIncome,TotalTaxableIncome)>0,MinimumAdministrationCost,0))+TotalSMSFOtherMortgagesAnnualRepaymentWithBuffer+TotalSMSFOtherPandLExpenses","v":1500}]
[null,null,"Proposed Gross Residential Rental Income"]
[]
[null,null,"Gross Income",null,{"$f":"TotalSMSFMemberContributionsConcessional+TotalSMSFMemberContributionsNonConcessional+TotalSMSFIncomeOnOtherInvestments+ProposedNetCRERentalIncome+(ProposedGrossResidentialRentalIncome*RentalIncomeShading)","v":0},null,null,null,"SMSF Tax",null,{"$f":"MAX((0),(TotalGrossIncome-TotalSMSFMemberContributionsNonConcessional-MAX(TotalSMSFAdministrationCost,MinimumAdministrationCost)-TotalSMSFOtherPandLExpenses-(NewLoanIAnnualnterestExpense+TotalSMSFOtherMortgagesAnnualInterestWithLoading)))*SuperannuationTax","v":0}]
[]
[]
[null,null,"Results"]
[]
[]
[null,null,"SMSF Income after expenses & tax before debt",null,{"$f":"TotalGrossIncome-TotalSMSFTax-MAX(TotalSMSFAdministrationCost,IF(TotalGrossIncome>0,MinimumAdministrationCost,0)-TotalSMSFOtherPandLExpenses)","v":0},null,null,null,null,null,"Interest Expenses",null,{"$f":"NewLoanIAnnualnterestExpense+TotalSMSFOtherMortgagesAnnualInterestWithLoading","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Debt Repayments",null,{"$f":"(PandIRepaymentAmount*NumberOfMonthsInAYear)+TotalSMSFOtherMortgagesAnnualRepaymentWithBuffer","v":0}]
[null,null,{"$f":" IF(O47=\"FAIL\",\"DSCR HAS FAILED, PLEASE ENSURE ALL ADDITIONAL MEMBER CONTRIBUTIONS HAVE BEEN EXPLORED OR MEMBERS INCOME & EXPENSES SERVICE IF ENTERED BELOW\",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"Interest Coverage Ratio (ICR):",null,{"$f":"IF(AND(S91+S93>=0,CheckForCompleteness=\"COMPLETE\"),IFERROR(E42/M42,0),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Debt Service Coverage Ratio (DSCR):",null,{"$f":"IF(AND(S91+S93>=0,CheckForCompleteness=\"COMPLETE\"),IFERROR(E42/M43,0),\"\")","v":""},null,{"$f":"IF(M50=\"INCOMPLETE\",\"INCOMPLETE\",IF(AND(M47>=MinimumSMSFDSCR,S91>=0,S93>=0),\"PASS\",\"FAIL\"))","v":"INCOMPLETE"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Application Status"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(NewLoanAmount=\"\",InterestRate=\"\",LoanTermInYears=\"\",LoanTermInYears<IOTermInYears,C20<>\"\",E20<>\"\",C23<>\"\",E23<>\"\",C25<>\"\",E25<>\"\"),\"INCOMPLETE\",IF(AND(E56=\"\",OR(E65<>0,E70<>0,SUM(E73:E77)<>0)),\"INCOMPLETE\",IF(AND(G56=\"\",OR(G65<>0,G70<>0,SUM(G73:G77)<>0)),\"INCOMPLETE\",IF(AND(I56=\"\",OR(I65<>0,I70<>0,SUM(I73:I77)<>0)),\"INCOMPLETE\",IF(AND(K56=\"\",OR(K65<>0,K70<>0,SUM(K73:K77)<>0)),\"INCOMPLETE\",IF(AND(M56=\"\",OR(M65<>0,M70<>0,SUM(M73:M77)<>0)),\"INCOMPLETE\",IF(AND(O56=\"\",OR(O65<>0,O70<>0,SUM(O73:O77)<>0)),\"INCOMPLETE\",\"COMPLETE\")))))))","v":"INCOMPLETE"}]
[]
[]
[]
[null,null,"Member Income & Expenses - COMPLETE ONLY IF A MEMBER(S) ADDITIONAL CONTRIBUTIONS ARE REQUIRED (ROWS 21 & 24)"]
[null,null,"Member Details",null,"Member 1",null,"Member 2",null,"Member 3",null,"Member 4",null,"Member 5",null,"Member 6"]
[null,null,"Status"]
[null,null,"Couple With"]
[null,null,"Dependants"]
[null,null,null,null,"Enter a Status",null,"Enter a Status",null,"Enter a Status",null,"Enter a Status",null,"Enter a Status",null,"Enter a Status"]
[]
[null,null,"PAYG Income"]
[null,null,"Self employed & Other taxable income"]
[null,null,"Untaxed Allowable Income"]
[null,null,"Gross Residential Rental Income"]
[null,null,"Total Income",null,{"$f":"E61++E62+E63+E64*RentalIncomeShading","v":0},null,{"$f":"G61++G62+G63+G64*RentalIncomeShading","v":0},null,{"$f":"I61++I62+I63+I64*RentalIncomeShading","v":0},null,{"$f":"K61++K62+K63+K64*RentalIncomeShading","v":0},null,{"$f":"M61++M62+M63+M64*RentalIncomeShading","v":0},null,{"$f":"O61++O62+O63+O64*RentalIncomeShading","v":0},null,null,null,{"$f":"(E65+G65+I65+K65+M65+O65)","v":0},"Total Gross Annual Income"]
[]
[null,null,"Investment Property Loan Balance (personal name)"]
[null,null,"Tax",null,{"$f":"VLOOKUP(E84,IncomeTaxTable,2,TRUE)+MAX(((E84-VLOOKUP(E84,IncomeTaxTable,1,TRUE))*VLOOKUP(E84,IncomeTaxTable,3,TRUE)),0) +IF(E84<=MinimumForPartialLevy,0,IF(E84>MinimumForFullLevy,E84*MedicareFullLevyPerc,(E84-MinimumForPartialLevy)*MedicarePartialLevyPerc))","v":0},null,{"$f":"VLOOKUP(G84,IncomeTaxTable,2,TRUE)+MAX(((G84-VLOOKUP(G84,IncomeTaxTable,1,TRUE))*VLOOKUP(G84,IncomeTaxTable,3,TRUE)),0) +IF(G84<=MinimumForPartialLevy,0,IF(G84>MinimumForFullLevy,G84*MedicareFullLevyPerc,(G84-MinimumForPartialLevy)*MedicarePartialLevyPerc))","v":0},null,{"$f":"VLOOKUP(I84,IncomeTaxTable,2,TRUE)+MAX(((I84-VLOOKUP(I84,IncomeTaxTable,1,TRUE))*VLOOKUP(I84,IncomeTaxTable,3,TRUE)),0) +IF(I84<=MinimumForPartialLevy,0,IF(I84>MinimumForFullLevy,I84*MedicareFullLevyPerc,(I84-MinimumForPartialLevy)*MedicarePartialLevyPerc))","v":0},null,{"$f":"VLOOKUP(K84,IncomeTaxTable,2,TRUE)+MAX(((K84-VLOOKUP(K84,IncomeTaxTable,1,TRUE))*VLOOKUP(K84,IncomeTaxTable,3,TRUE)),0) +IF(K84<=MinimumForPartialLevy,0,IF(K84>MinimumForFullLevy,K84*MedicareFullLevyPerc,(K84-MinimumForPartialLevy)*MedicarePartialLevyPerc))","v":0},null,{"$f":"VLOOKUP(M84,IncomeTaxTable,2,TRUE)+MAX(((M84-VLOOKUP(M84,IncomeTaxTable,1,TRUE))*VLOOKUP(M84,IncomeTaxTable,3,TRUE)),0) +IF(M84<=MinimumForPartialLevy,0,IF(M84>MinimumForFullLevy,M84*MedicareFullLevyPerc,(M84-MinimumForPartialLevy)*MedicarePartialLevyPerc))","v":0},null,{"$f":"VLOOKUP(O84,IncomeTaxTable,2,TRUE)+MAX(((O84-VLOOKUP(O84,IncomeTaxTable,1,TRUE))*VLOOKUP(O84,IncomeTaxTable,3,TRUE)),0) +IF(O84<=MinimumForPartialLevy,0,IF(O84>MinimumForFullLevy,O84*MedicareFullLevyPerc,(O84-MinimumForPartialLevy)*MedicarePartialLevyPerc))","v":0}]
[null,null,"Tax offset for Low Income Earners",null,{"$f":"0-(IF(E56=\"Company\",0,MIN(E68,IF(OR(E84<=0,E84>=TaxOffsetMaximumEntitlement),0,TaxOffsetForLowIncomeEarners-IF(E84>TaxOffsetIncomeThreshholds,((E84-TaxOffsetIncomeThreshholds)*TaxOffSetReducedByPerc),0))))+IF(OR(E56=\"Company\",E84=\"\",E84=0),0,IF(VLOOKUP(E84,TaxOffsetForLowIncomeTable,2,TRUE)+(E84-VLOOKUP(E84,TaxOffsetForLowIncomeTable,1,TRUE))*VLOOKUP(E84,TaxOffsetForLowIncomeTable,3,TRUE)<0,0,VLOOKUP(E84,TaxOffsetForLowIncomeTable,2,TRUE)+(E84-VLOOKUP(E84,TaxOffsetForLowIncomeTable,1,TRUE))*VLOOKUP(E84,TaxOffsetForLowIncomeTable,3,TRUE))))","v":0},null,{"$f":"0-(IF(G56=\"Company\",0,MIN(G68,IF(OR(G84<=0,G84>=TaxOffsetMaximumEntitlement),0,TaxOffsetForLowIncomeEarners-IF(G84>TaxOffsetIncomeThreshholds,((G84-TaxOffsetIncomeThreshholds)*TaxOffSetReducedByPerc),0))))+IF(OR(G56=\"Company\",G84=\"\",G84=0),0,IF(VLOOKUP(G84,TaxOffsetForLowIncomeTable,2,TRUE)+(G84-VLOOKUP(G84,TaxOffsetForLowIncomeTable,1,TRUE))*VLOOKUP(G84,TaxOffsetForLowIncomeTable,3,TRUE)<0,0,VLOOKUP(G84,TaxOffsetForLowIncomeTable,2,TRUE)+(G84-VLOOKUP(G84,TaxOffsetForLowIncomeTable,1,TRUE))*VLOOKUP(G84,TaxOffsetForLowIncomeTable,3,TRUE))))","v":0},null,{"$f":"0-(IF(I56=\"Company\",0,MIN(I68,IF(OR(I84<=0,I84>=TaxOffsetMaximumEntitlement),0,TaxOffsetForLowIncomeEarners-IF(I84>TaxOffsetIncomeThreshholds,((I84-TaxOffsetIncomeThreshholds)*TaxOffSetReducedByPerc),0))))+IF(OR(I56=\"Company\",I84=\"\",I84=0),0,IF(VLOOKUP(I84,TaxOffsetForLowIncomeTable,2,TRUE)+(I84-VLOOKUP(I84,TaxOffsetForLowIncomeTable,1,TRUE))*VLOOKUP(I84,TaxOffsetForLowIncomeTable,3,TRUE)<0,0,VLOOKUP(I84,TaxOffsetForLowIncomeTable,2,TRUE)+(I84-VLOOKUP(I84,TaxOffsetForLowIncomeTable,1,TRUE))*VLOOKUP(I84,TaxOffsetForLowIncomeTable,3,TRUE))))","v":0},null,{"$f":"0-(IF(K56=\"Company\",0,MIN(K68,IF(OR(K84<=0,K84>=TaxOffsetMaximumEntitlement),0,TaxOffsetForLowIncomeEarners-IF(K84>TaxOffsetIncomeThreshholds,((K84-TaxOffsetIncomeThreshholds)*TaxOffSetReducedByPerc),0))))+IF(OR(K56=\"Company\",K84=\"\",K84=0),0,IF(VLOOKUP(K84,TaxOffsetForLowIncomeTable,2,TRUE)+(K84-VLOOKUP(K84,TaxOffsetForLowIncomeTable,1,TRUE))*VLOOKUP(K84,TaxOffsetForLowIncomeTable,3,TRUE)<0,0,VLOOKUP(K84,TaxOffsetForLowIncomeTable,2,TRUE)+(K84-VLOOKUP(K84,TaxOffsetForLowIncomeTable,1,TRUE))*VLOOKUP(K84,TaxOffsetForLowIncomeTable,3,TRUE))))","v":0},null,{"$f":"0-(IF(M56=\"Company\",0,MIN(M68,IF(OR(M84<=0,M84>=TaxOffsetMaximumEntitlement),0,TaxOffsetForLowIncomeEarners-IF(M84>TaxOffsetIncomeThreshholds,((M84-TaxOffsetIncomeThreshholds)*TaxOffSetReducedByPerc),0))))+IF(OR(M56=\"Company\",M84=\"\",M84=0),0,IF(VLOOKUP(M84,TaxOffsetForLowIncomeTable,2,TRUE)+(M84-VLOOKUP(M84,TaxOffsetForLowIncomeTable,1,TRUE))*VLOOKUP(M84,TaxOffsetForLowIncomeTable,3,TRUE)<0,0,VLOOKUP(M84,TaxOffsetForLowIncomeTable,2,TRUE)+(M84-VLOOKUP(M84,TaxOffsetForLowIncomeTable,1,TRUE))*VLOOKUP(M84,TaxOffsetForLowIncomeTable,3,TRUE))))","v":0},null,{"$f":"0-(IF(O56=\"Company\",0,MIN(O68,IF(OR(O84<=0,O84>=TaxOffsetMaximumEntitlement),0,TaxOffsetForLowIncomeEarners-IF(O84>TaxOffsetIncomeThreshholds,((O84-TaxOffsetIncomeThreshholds)*TaxOffSetReducedByPerc),0))))+IF(OR(O56=\"Company\",O84=\"\",O84=0),0,IF(VLOOKUP(O84,TaxOffsetForLowIncomeTable,2,TRUE)+(O84-VLOOKUP(O84,TaxOffsetForLowIncomeTable,1,TRUE))*VLOOKUP(O84,TaxOffsetForLowIncomeTable,3,TRUE)<0,0,VLOOKUP(O84,TaxOffsetForLowIncomeTable,2,TRUE)+(O84-VLOOKUP(O84,TaxOffsetForLowIncomeTable,1,TRUE))*VLOOKUP(O84,TaxOffsetForLowIncomeTable,3,TRUE))))","v":0}]
[null,null,"Net Income After Tax",null,{"$f":"E65-(IF(E68+E69>0,E68+E69,0))","v":0},null,{"$f":"G65-(IF(G68+G69>0,G68+G69,0))","v":0},null,{"$f":"I65-(IF(I68+I69>0,I68+I69,0))","v":0},null,{"$f":"K65-(IF(K68+K69>0,K68+K69,0))","v":0},null,{"$f":"M65-(IF(M68+M69>0,M68+M69,0))","v":0},null,{"$f":"O65-(IF(O68+O69>0,O68+O69,0))","v":0},null,null,null,{"$f":"(E70+G70+I70+K70+M70+O70)","v":0},"Total Net Annual Income"]
[]
[null,null,"Commitments (per month)"]
[null,null,"Declared Living Expenses"]
[null,null,"Rent/Board"]
[null,null,"Total Credit Card Limit"]
[null,null,"Personal Mortgage Repayments"]
[null,null,"Other Consumer Debt"]
[null,null,"Is an Applicant",null,{"$f":"OR(E56<>\"\")","v":false},null,{"$f":"OR(G56<>\"\")","v":false},null,{"$f":"OR(I56<>\"\")","v":false},null,{"$f":"OR(K56<>\"\")","v":false},null,{"$f":"OR(M56<>\"\")","v":false},null,{"$f":"OR(O56<>\"\")","v":false}]
[null,null,"Spouse Dependants",null,{"$f":"IFERROR(HLOOKUP(E57,ApplicantDetailsTable,4,FALSE),0)","v":0},null,{"$f":"IFERROR(HLOOKUP(G57,ApplicantDetailsTable,4,FALSE),0)","v":0},null,{"$f":"IFERROR(HLOOKUP(I57,ApplicantDetailsTable,4,FALSE),0)","v":0},null,{"$f":"IFERROR(HLOOKUP(K57,ApplicantDetailsTable,4,FALSE),0)","v":0},null,{"$f":"IFERROR(HLOOKUP(M57,ApplicantDetailsTable,4,FALSE),0)","v":0},null,{"$f":"IFERROR(HLOOKUP(O57,ApplicantDetailsTable,4,FALSE),0)","v":0}]
[null,null,"Pepper Status Code",null,{"$f":"IF(E$56=\"Individual (Couple)\",\"P-C\",IF(E$56=\"Individual (Single)\",\"P-S\",\"\"))","v":""},null,{"$f":"IF(G$56=\"Individual (Couple)\",\"P-C\",IF(G$56=\"Individual (Single)\",\"P-S\",\"\"))","v":""},null,{"$f":"IF(I$56=\"Individual (Couple)\",\"P-C\",IF(I$56=\"Individual (Single)\",\"P-S\",\"\"))","v":""},null,{"$f":"IF(K$56=\"Individual (Couple)\",\"P-C\",IF(K$56=\"Individual (Single)\",\"P-S\",\"\"))","v":""},null,{"$f":"IF(M$56=\"Individual (Couple)\",\"P-C\",IF(M$56=\"Individual (Single)\",\"P-S\",\"\"))","v":""},null,{"$f":"IF(O$56=\"Individual (Couple)\",\"P-C\",IF(O$56=\"Individual (Single)\",\"P-S\",\"\"))","v":""}]
[null,null,"Pepper Dependents Code",null,{"$f":"IF(E$56=\"Individual (Couple)\",\"P-CD\"&INDEX(Validation!$B$21:$B$26,MATCH((E$58+E$79),Validation!$A$21:$A$26,1)),IF(E$56=\"Individual (Single)\",\"P-SD\"&INDEX(Validation!$B$21:$B$26,MATCH((E$58+E$79),Validation!$A$21:$A$26,1)),\"\"))","v":""},null,{"$f":"IF(G$56=\"Individual (Couple)\",\"P-CD\"&INDEX(Validation!$B$21:$B$26,MATCH((G$58+G$79),Validation!$A$21:$A$26,1)),IF(G$56=\"Individual (Single)\",\"P-SD\"&INDEX(Validation!$B$21:$B$26,MATCH((G$58+G$79),Validation!$A$21:$A$26,1)),\"\"))","v":""},null,{"$f":"IF(I$56=\"Individual (Couple)\",\"P-CD\"&INDEX(Validation!$B$21:$B$26,MATCH((I$58+I$79),Validation!$A$21:$A$26,1)),IF(I$56=\"Individual (Single)\",\"P-SD\"&INDEX(Validation!$B$21:$B$26,MATCH((I$58+I$79),Validation!$A$21:$A$26,1)),\"\"))","v":""},null,{"$f":"IF(K$56=\"Individual (Couple)\",\"P-CD\"&INDEX(Validation!$B$21:$B$26,MATCH((K$58+K$79),Validation!$A$21:$A$26,1)),IF(K$56=\"Individual (Single)\",\"P-SD\"&INDEX(Validation!$B$21:$B$26,MATCH((K$58+K$79),Validation!$A$21:$A$26,1)),\"\"))","v":""},null,{"$f":"IF(M$56=\"Individual (Couple)\",\"P-CD\"&INDEX(Validation!$B$21:$B$26,MATCH((M$58+M$79),Validation!$A$21:$A$26,1)),IF(M$56=\"Individual (Single)\",\"P-SD\"&INDEX(Validation!$B$21:$B$26,MATCH((M$58+M$79),Validation!$A$21:$A$26,1)),\"\"))","v":""},null,{"$f":"IF(O$56=\"Individual (Couple)\",\"P-CD\"&INDEX(Validation!$B$21:$B$26,MATCH((O$58+O$79),Validation!$A$21:$A$26,1)),IF(O$56=\"Individual (Single)\",\"P-SD\"&INDEX(Validation!$B$21:$B$26,MATCH((O$58+O$79),Validation!$A$21:$A$26,1)),\"\"))","v":""}]
[null,null,"Exclude for LE calc",null,{"$f":"IFERROR(IF(MATCH(E57,$E$55:$O$55,0)<(COLUMN()-COLUMN($E$55:$O$55)+1),TRUE,FALSE),FALSE)","v":false},null,{"$f":"IFERROR(IF(MATCH(G57,$E$55:$O$55,0)<(COLUMN()-COLUMN($E$55:$O$55)+1),TRUE,FALSE),FALSE)","v":false},null,{"$f":"IFERROR(IF(MATCH(I57,$E$55:$O$55,0)<(COLUMN()-COLUMN($E$55:$O$55)+1),TRUE,FALSE),FALSE)","v":false},null,{"$f":"IFERROR(IF(MATCH(K57,$E$55:$O$55,0)<(COLUMN()-COLUMN($E$55:$O$55)+1),TRUE,FALSE),FALSE)","v":false},null,{"$f":"IFERROR(IF(MATCH(M57,$E$55:$O$55,0)<(COLUMN()-COLUMN($E$55:$O$55)+1),TRUE,FALSE),FALSE)","v":false},null,{"$f":"IFERROR(IF(MATCH(O57,$E$55:$O$55,0)<(COLUMN()-COLUMN($E$55:$O$55)+1),TRUE,FALSE),FALSE)","v":false}]
[]
[null,null,"Total Taxable Income",null,{"$f":"MAX(E61+E62+E64*RentalIncomeShading-E67*WorkingsForNegativeGearing,0)","v":0},null,{"$f":"MAX(G61+G62+G64*RentalIncomeShading-G67*WorkingsForNegativeGearing,0)","v":0},null,{"$f":"MAX(I61+I62+I64*RentalIncomeShading-I67*WorkingsForNegativeGearing,0)","v":0},null,{"$f":"MAX(K61+K62+K64*RentalIncomeShading-K67*WorkingsForNegativeGearing,0)","v":0},null,{"$f":"MAX(M61+M62+M64*RentalIncomeShading-M67*WorkingsForNegativeGearing,0)","v":0},null,{"$f":"MAX(O61+O62+O64*RentalIncomeShading-O67*WorkingsForNegativeGearing,0)","v":0},null,null,null,{"$f":"(E84+G84+I84+K84+M84+O84)","v":0},"Total Taxable Income"]
[null,null,"Tax calculation on commitments (to calculate net uncommitted income)",null,{"$f":"VLOOKUP((E90),IncomeTaxTable,2,TRUE)+MAX((((E90)-VLOOKUP((E90),IncomeTaxTable,1,TRUE))*VLOOKUP((E90),IncomeTaxTable,3,TRUE)),0) +IF((E90)<=MinimumForPartialLevy,0,IF((E90-E63)>MinimumForFullLevy,(E90)*MedicareFullLevyPerc,((E90)-MinimumForPartialLevy)*MedicarePartialLevyPerc))","v":0},null,{"$f":"VLOOKUP((G90),IncomeTaxTable,2,TRUE)+MAX((((G90)-VLOOKUP((G90),IncomeTaxTable,1,TRUE))*VLOOKUP((G90),IncomeTaxTable,3,TRUE)),0) +IF((G90)<=MinimumForPartialLevy,0,IF((G90-G63)>MinimumForFullLevy,(G90)*MedicareFullLevyPerc,((G90)-MinimumForPartialLevy)*MedicarePartialLevyPerc))","v":0},null,{"$f":"VLOOKUP((I90),IncomeTaxTable,2,TRUE)+MAX((((I90)-VLOOKUP((I90),IncomeTaxTable,1,TRUE))*VLOOKUP((I90),IncomeTaxTable,3,TRUE)),0) +IF((I90)<=MinimumForPartialLevy,0,IF((I90-I63)>MinimumForFullLevy,(I90)*MedicareFullLevyPerc,((I90)-MinimumForPartialLevy)*MedicarePartialLevyPerc))","v":0},null,{"$f":"VLOOKUP((K90),IncomeTaxTable,2,TRUE)+MAX((((K90)-VLOOKUP((K90),IncomeTaxTable,1,TRUE))*VLOOKUP((K90),IncomeTaxTable,3,TRUE)),0) +IF((K90)<=MinimumForPartialLevy,0,IF((K90-K63)>MinimumForFullLevy,(K90)*MedicareFullLevyPerc,((K90)-MinimumForPartialLevy)*MedicarePartialLevyPerc))","v":0},null,{"$f":"VLOOKUP((M90),IncomeTaxTable,2,TRUE)+MAX((((M90)-VLOOKUP((M90),IncomeTaxTable,1,TRUE))*VLOOKUP((M90),IncomeTaxTable,3,TRUE)),0) +IF((M90)<=MinimumForPartialLevy,0,IF((M90-M63)>MinimumForFullLevy,(M90)*MedicareFullLevyPerc,((M90)-MinimumForPartialLevy)*MedicarePartialLevyPerc))","v":0},null,{"$f":"VLOOKUP((O90),IncomeTaxTable,2,TRUE)+MAX((((O90)-VLOOKUP((O90),IncomeTaxTable,1,TRUE))*VLOOKUP((O90),IncomeTaxTable,3,TRUE)),0) +IF((O90)<=MinimumForPartialLevy,0,IF((O90-O63)>MinimumForFullLevy,(O90)*MedicareFullLevyPerc,((O90)-MinimumForPartialLevy)*MedicarePartialLevyPerc))","v":0}]
[null,null,"Spouse Income",null,{"$f":"IFERROR(HLOOKUP(E57,ApplicantDetailsTable,7,FALSE),0)","v":0},null,{"$f":"IFERROR(HLOOKUP(G57,ApplicantDetailsTable,7,FALSE),0)","v":0},null,{"$f":"IFERROR(HLOOKUP(I57,ApplicantDetailsTable,7,FALSE),0)","v":0},null,{"$f":"IFERROR(HLOOKUP(K57,ApplicantDetailsTable,7,FALSE),0)","v":0},null,{"$f":"IFERROR(HLOOKUP(M57,ApplicantDetailsTable,7,FALSE),0)","v":0},null,{"$f":"IFERROR(HLOOKUP(O57,ApplicantDetailsTable,7,FALSE),0)","v":0}]
[null,null,"Income Bracket",null,{"$f":"IFERROR(HLOOKUP(E63+E84+E86,HemCombinedIncomeRange,3,TRUE),1)","v":1},null,{"$f":"IFERROR(HLOOKUP(G63+G84+G86,HemCombinedIncomeRange,3,TRUE),1)","v":1},null,{"$f":"IFERROR(HLOOKUP(I63+I84+I86,HemCombinedIncomeRange,3,TRUE),1)","v":1},null,{"$f":"IFERROR(HLOOKUP(K63+K84+K86,HemCombinedIncomeRange,3,TRUE),1)","v":1},null,{"$f":"IFERROR(HLOOKUP(M63+M84+M86,HemCombinedIncomeRange,3,TRUE),1)","v":1},null,{"$f":"IFERROR(HLOOKUP(O63+O84+O86,HemCombinedIncomeRange,3,TRUE),1)","v":1}]
[null,null,"HEM Living Expense (monthly)",null,{"$f":"IFERROR(IF(AND(E78,NOT(E82)),(VLOOKUP(E80,HemTableForExpenses,E87+1,FALSE) +(VLOOKUP(E81,HemTableForExpenses,E87+1,FALSE))*(E58+E79))*NumberOfWeeksInAYear,0),0)/NumberOfMonthsInAYear","v":0},null,{"$f":"IFERROR(IF(AND(G78,NOT(G82)),(VLOOKUP(G80,HemTableForExpenses,G87+1,FALSE) +(VLOOKUP(G81,HemTableForExpenses,G87+1,FALSE))*(G58+G79))*NumberOfWeeksInAYear,0),0)/NumberOfMonthsInAYear","v":0},null,{"$f":"IFERROR(IF(AND(I78,NOT(I82)),(VLOOKUP(I80,HemTableForExpenses,I87+1,FALSE) +(VLOOKUP(I81,HemTableForExpenses,I87+1,FALSE))*(I58+I79))*NumberOfWeeksInAYear,0),0)/NumberOfMonthsInAYear","v":0},null,{"$f":"IFERROR(IF(AND(K78,NOT(K82)),(VLOOKUP(K80,HemTableForExpenses,K87+1,FALSE) +(VLOOKUP(K81,HemTableForExpenses,K87+1,FALSE))*(K58+K79))*NumberOfWeeksInAYear,0),0)/NumberOfMonthsInAYear","v":0},null,{"$f":"IFERROR(IF(AND(M78,NOT(M82)),(VLOOKUP(M80,HemTableForExpenses,M87+1,FALSE) +(VLOOKUP(M81,HemTableForExpenses,M87+1,FALSE))*(M58+M79))*NumberOfWeeksInAYear,0),0)/NumberOfMonthsInAYear","v":0},null,{"$f":"IFERROR(IF(AND(O78,NOT(O82)),(VLOOKUP(O80,HemTableForExpenses,O87+1,FALSE) +(VLOOKUP(O81,HemTableForExpenses,O87+1,FALSE))*(O58+O79))*NumberOfWeeksInAYear,0),0)/NumberOfMonthsInAYear","v":0}]
[]
[null,null,"Total Commitments (annualised)",null,{"$f":"(MAX(E88,E73)+(E74+(E75*CreditCardCommitments)+(E76*OtherMortgageRepaymentBuffer)+E77))*NumberOfMonthsInAYear","v":0},null,{"$f":"(MAX(G88,G73)+(G74+(G75*CreditCardCommitments)+(G76*OtherMortgageRepaymentBuffer)+G77))*NumberOfMonthsInAYear","v":0},null,{"$f":"(MAX(I88,I73)+(I74+(I75*CreditCardCommitments)+(I76*OtherMortgageRepaymentBuffer)+I77))*NumberOfMonthsInAYear","v":0},null,{"$f":"(MAX(K88,K73)+(K74+(K75*CreditCardCommitments)+(K76*OtherMortgageRepaymentBuffer)+K77))*NumberOfMonthsInAYear","v":0},null,{"$f":"(MAX(M88,M73)+(M74+(M75*CreditCardCommitments)+(M76*OtherMortgageRepaymentBuffer)+M77))*NumberOfMonthsInAYear","v":0},null,{"$f":"(MAX(O88,O73)+(O74+(O75*CreditCardCommitments)+(O76*OtherMortgageRepaymentBuffer)+O77))*NumberOfMonthsInAYear","v":0}]
[null,null,"Available surplus for additional voluntary concessional contributions (capped at $27,500)",null,{"$f":"MIN((ConcessionalContributionsCappedAmount-SuperGuaranteeContributionM1),IF((E65-E90-E85)<0,0,(E65-E90-E85)))","v":0},null,{"$f":"MIN((ConcessionalContributionsCappedAmount-SuperGuaranteeContributionM2),IF((G65-G90-G85)<0,0,(G65-G90-G85)))","v":0},null,{"$f":"MIN((ConcessionalContributionsCappedAmount-SuperGuaranteeContributionM3),IF((I65-I90-I85)<0,0,(I65-I90-I85)))","v":0},null,{"$f":"MIN((ConcessionalContributionsCappedAmount-SuperGuaranteeContributionM4),IF((K65-K90-K85)<0,0,(K65-K90-K85)))","v":0},null,{"$f":"MIN((ConcessionalContributionsCappedAmount-SuperGuaranteeContributionM5),IF((M65-M90-M85)<0,0,(M65-M90-M85)))","v":0},null,{"$f":"MIN((ConcessionalContributionsCappedAmount-SuperGuaranteeContributionM6),IF((O65-O90-O85)<0,0,(O65-O90-O85)))","v":0},null,null,null,{"$f":"(E91+G91+I91+K91+M91+O91)","v":0}]
[]
[null,null,"Available surplus for additional voluntary non-concessional contributions (capped at $110,000)",null,{"$f":"MIN(NonConcessionalContributionsCappedAmount,(IF(OR(E70>0,E90>0),(E70-E90-E91),0)))","v":0},null,{"$f":"MIN(NonConcessionalContributionsCappedAmount,(IF(OR(G70>0,G90>0),(G70-G90-G91),0)))","v":0},null,{"$f":"MIN(NonConcessionalContributionsCappedAmount,(IF(OR(I70>0,I90>0),(I70-I90-I91),0)))","v":0},null,{"$f":"MIN(NonConcessionalContributionsCappedAmount,(IF(OR(K70>0,K90>0),(K70-K90-K91),0)))","v":0},null,{"$f":"MIN(NonConcessionalContributionsCappedAmount,(IF(OR(M70>0,M90>0),(M70-M90-M91),0)))","v":0},null,{"$f":"MIN(NonConcessionalContributionsCappedAmount,(IF(OR(O70>0,O90>0),(O70-O90-O91),0)))","v":0},null,null,null,{"$f":"(E93+G93+I93+K93+M93+O93)","v":0}]
[]
["Important information\nCommercial in confidence - this document has been produced for the intended recipients only. It must not, under any circumstance, be copied or distributed in any way to a party other than the intended recipients.  \n\nSMSF serviceability calculator is correct as at 16th October 2023 and subject to change.\n\nAll applications are subject to credit assessment, eligibility criteria and lending limits. Terms, conditions, fees and charges apply.  Information provided in the SMSF serviceability calculator is factual information only and is not intended to implement any recommendation or advice about any financial product(s) or constitute tax advice.  Consult a licensed financial or tax advice for financial and/or tax advice. \n\n The results of the SMSF serviceability calculator are based on information provided and is to be used as a guide only. Serviceability may be different when a full assessment is completed  It does not constitute a quote, pre-qualification or approval or offer for credit and commitments should not be entered based on it. \n\n                                                                                                                                          Pepper Money Limited ABN 51 094 317 647"]

{"sheet":"User Guide - SMSF","index":1,"n_rows":51,"n_cols":3,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["SMSF Serviceability Calculator"]
[]
["Field Name","Instruction","Field type"]
["Clear Form (BUTTON)","Allows the user to clear all fields in the calculator","User entry"]
["SMSF Name","Name of the SMSF the application relates","User entry"]
["New Loan Amount","Mandatory field - total loan amount including any capitalised fees","User entry"]
["Interest Rate","Mandatory field - actual interest rate of the proposed loan","User entry"]
["Loan Term (Years)","Mandatory field -  the total loan term of the proposed loan (maximum term 30 years)","User entry"]
["I/O Term (Years)","The interest only term of the proposed loan. Left blank if not applicable (maximum term 5 years allowed)","User entry"]
["P&I Repayment ","Principal and interest repayment of the proposed loans ammortisation period","Calculated"]
["IO Repayment","Interest Only repayment of the proposed loan, if applicable","Calculated"]
["Superannuation guarantee","Amount Member receives from PAYG employment under the employer superannuation guarantee scheme. Verified through SMSF financials or PAYG income verification.","User entry"]
["PROPOSED CONCESSIONAL contributions","Amount Member intends to pay in addition to the Superannuation guarantee. This amount added with the Superannuation guarantee and PROPOSED CONCESSIONAL contributions values cannot exceed $27,500 for each member. For this amount to be considered, the Members personal financial information needs to be collected and verified and the Members Income & Expense section of the calculator completed. ","User entry"]
["EXISTING CONCESSIONAL contributions","Amount Member currently pays in addition to the Superannuation guarantee. This amount added with the Superannuation guarantee and PROPOSED CONCESSIONAL contributions values cannot exceed $27,500 for each member. For this amount to be considered, the Members personal financial information needs to be collected and verified and the Members Income & Expense section of the calculator completed. ","User entry"]
["Additional NON-CONCESSIONAL contributions","Amount Member does or intends to pay in addition to the Superannuation guarantee and any other conncessional contributions, where that total concessional amount will exceed $27,500. This amount cannot exceed $110,000. This amount added with the Superannuation guarantee value cannot exceed $27,500. For this amount to be considered, the Members personal financial information needs to be collected and verified and the Members Income & Expense section of the calculator completed. \nThe amount to be entered is post-tax which is calculated in the Members Income & Expense section. ","User entry"]
["Member Contibutions - Concessional","The combined value the Superannuation guarantee and Additional Concessional Contributions entered above. ","Calculated"]
["Member Contibutions - Non Concessional","The value Additional Non-Concessional Contributions entered above. ","Calculated"]
["Income on other SMSF investments","This is the return on investments currently owned by the SMSF and evidenced through the SMSF financials. This excludes any capitals gains and where the current investments will be liquidated to complete a property purchase, the returns will be adjusted to represent a return of the residual investment value being retained","User entry"]
["Proposed Net CRE Rental Income","100% of CRE rental income after outgoins paid for by landlord","User entry"]
["Proposed Gross Residential Rental Income","Enter 100% of gross residential rental income if to be received by the business. The calculator will shade this income by 20%","User entry"]
["Gross Income","A total of all SMSF income once haircuts are applied","Calculated"]
["Administration","Annual costs of administrating the SMSF. Pepper will apply a floor of $1500","User entry"]
["Other Mortgage Repayment (stressed)","Annual repayment of any existing SMSF mortgages buffer by 25%","Calculated"]
["Other P&L expenses","Any other ongoing expenses of the SMSF","User entry"]
["Total Expenses","A total of all SMSF expenses","Calculated"]
["SMSF Tax","15% Tax applying to the SMSF being\nGross income\nminus Member Contributions - Non Concessional (which have already been tax)\nminus Interest on the proposed loan (inclusive of interest rate loading)\nminus Interest on existing SMSF Mortgage (inclusive of other mortgage loading)","Calculated"]
["Total Loan Amount ","Total balances of any other mortgages held by the SMSF","User entry"]
["Monthly Repayment ","Total of actual repayment of any other mortgages held by the SMSF","User entry"]
["Interest Rate","Actual interest rate on any other mortgages held by the SMSF. Where multiple mortgage are held by the SMSF, interest rate to be weighted by loan balance of each loan. \nFormula = ((loan 1 balance x loan 1 interest rate)+(loan 2 balance x loan 2 interest rate) etc) / total of all loan balances","User entry"]
["SMSF Income after expenses & tax before interest","Gross Income less non-debt expenses less tax","Calculated"]
["Interest Expenses","Total SMSF Interest Expense per annum for all SMSF mortgages (Pepper and external)","Calculated"]
["Debt Repayments","Total SMSF debt repayments per annum including Proposed loan (if applicable, would include P&I repayments over residual term after any interest only period)","Calculated"]
["Interest Cover Ratio (ICR)","SMSF Income divided by Interest Expenses","Calculated"]
["Debt Service Coverage Ratio (DSCR)","SMSF Income divided by debt repayments","Calculated"]
["DSCR Outcome","Formula: All mandatory fields to be completed otherwise shows incomplete, where DSCR < 1.25 then result is FAIL otherwise result is PASS","Calculated"]
["Status","For each Member, what is their marital status. ","User entry"]
["Couple With","Links members who are a couple for household income band selection for living expense benchmark. This field must be correctly completed for both individuals of a couple, where one member of a couple is not correctly linked the living expense will be calculated as an additional couple living expense. Drop down selection N/A, Non-Loan Party or Applicant “X” when another Applicant is applied with a Couple status","User entry"]
["Dependents","Number of child dependents, aged < 18, the Member has. Each dependent child must only be entered once per couple. If a dependent is entered for both individuals of a couple, that dependent will be counted twice.","User entry"]
["Gross Annual Income","Gross annual income of member from acceptable taxable income sources external to business income. Do NOT include Directors Fees/Salary/Super if included in addbacks.","User entry"]
["Untaxed Allowable Income","Income from acceptable untaxed income sources. Tax is not calculated on this income.","User entry"]
["Gross Residential Rental Income (Other)","Rental income entered at 100%. For the purposes of allowable income for serviceability, 80% of this income is used for servicing. Care: do NOT enter if income has been included under Business Income.","User entry"]
["Investment Property Loan Balance (personal name)","This is the total balance of investment loans held by the member. For tax purposes, negative gearing will be applied to the calculated taxable income. For company members, if this interest has been calculated in the SEIC then this field should not be populated.","User entry"]
["Declared Living Expenses","Total personal living expenses per month declared by the customer (sum of all members declared living expenses)","User entry"]
["Rent/Board","Rental or board expense paid by the customer.","User entry"]
["Total Credit Card Limit","Total credit card limit of all continuing credit cards.","User entry"]
["Personal Mortgage Repayments","Mortgage repayments of any Personal continuing mortgage repayments.","User entry"]
["Other Consumer Debt","Any other commitments the member has such as personal loans, child support, HEC’s.","User entry"]
["Business Income (EBITDA + net personal contribution)","Formula: EBITDA plus Net Personal Contribution ","User entry"]
["Total Commitments (annualised)","The member total commitment","Calculated"]
["Available surplus for additional voluntary concessional contributions (capped at $27,500)","Surplus pre-tax member income after members expenses available to make additional contributions. Capped at $27,500","Calculated"]
["Available surplus for additional voluntary non-concessional contributions (capped at $110,000)","Surplus post-tax member income after members expenses and tax available to make additional contributions. Capped at $110,000","Calculated"]

{"sheet":"HEM Table","index":2,"n_rows":62,"n_cols":19,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
["Combined Couple Gross Income",null,{"$f":"B2","v":0},{"$f":"C2","v":25000},{"$f":"D2","v":37000},49000,61000,74000,98000,123000,147000,172000,196000,246000,307000,368000,null,null,"Higher income band used as data not available for income band"]
["HEM 2023Q1",null,25000,37000,49000,61000,74000,98000,123000,147000,172000,196000,246000,307000,368000,999999999]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14]
["Pepper - Proposed"]
["Single","P-S",{"$f":"C25","v":281.88967375827372},{"$f":"D25","v":297.87697304376547},312.2425383027354,332.8163882392883,370.77660279558972,425.65150192223405,501.42968979126897,573.13723163665941,659.52284232324064,704.74917334028123,748.26136520166733,870.33832324444279,987.5418334047414,1031.7519595371839]
["Couple","P-C",{"$f":"D6","v":553.28368370810654},{"$f":"D20","v":553.28368370810654},567.65944127870807,588.24790794372473,626.23508682568411,681.14900853553115,756.98103315359322,828.73947398398207,915.1865124016341,960.44495623987518,1003.9880431092344,1126.1517492515811,1243.4384719356358,1287.6800804572717]
["Single parent with 1 child  (per child)","P-SD1",{"$f":"D7","v":100.31457638341635},{"$f":"IF(D26-D25<0,0,D26-D25)","v":100.31457638341635},100.31332237072917,100.31159574875301,100.30831049775577,100.30364423095659,100.29714079507164,100.29094963498119,100.28356456699748,100.27972519511741,100.27595955940899,100.26551569622939,100.25541632611555,100.25170062822349]
["Single parent with 2 children  (per child)","P-SD2",106.32726364982284,{"$f":"IF(D27-D25<0,0,D27-D25)/2","v":106.32726364982284},106.34412463283815,106.3682559180493,106.41277756132882,106.47714090828828,106.56602194270278,106.65010555299841,106.75145564996626,106.80451125801613,106.85553799777171,106.99869584255339,107.13617424186276,107.18802876428867]
["Single parent with 3 children  (per child)","P-SD3",108.35439205354112,{"$f":"E9","v":108.35439205354112},{"$f":"IF(E28-E25<0,0,E28-E25)/3","v":108.35439205354112},108.38714264114809,108.44759991585317,108.53497313406551,108.65564899191315,108.76982419233748,108.90741934428918,108.97943994564905,109.04873081055932,109.24308922466139,109.42976021377849,109.50013814297706]
["Single parent with 4 or more children  (per child)","P-SD4+",108.35439205354112,108.35439205354112,{"$f":"IF(E28-E25<0,0,E28-E25)/3","v":108.35439205354112},108.38714264114809,108.44759991585317,108.53497313406551,108.65564899191315,108.76982419233748,108.90741934428918,108.97943994564905,109.04873081055932,109.24308922466139,109.42976021377849,109.50013814297706]
["Couple with 1 child (per child)","P-CD1",86.74810811202417,86.74810811202417,{"$f":"IF(E21-E20<0,0,E21-E20)","v":86.74810811202417},86.820403244624231,86.953802068942764,87.146582995753533,87.412899221111729,87.664837824716983,87.968391275635327,88.1273135135948,88.280230752007242,88.709182710967525,89.121027813695719,89.276379497070138]
["Couple with 2 children  (per child)","P-CD2",79.451726823244996,79.451726823244996,{"$f":"IF(E22-E20<0,0,E22-E20)/2","v":79.451726823244996},79.442792174641397,79.426307115298414,79.402458172206138,79.369549820948748,79.338427548092682,79.300876084182335,79.281272140539841,79.262366873110693,79.209324814750744,79.158463207704585,79.139227371248126]
["Couple with 3 children  (per child)","P-CD3",72.497239478274494,72.497239478274494,{"$f":"F13","v":72.497239478274494},{"$f":"IF(F23-F20<0,0,F23-F20)/3","v":72.497239478274494},72.590693219949046,72.72577236483869,72.912323553169429,73.088865783016402,73.301505933470978,73.412875072012255,73.51998744946593,73.820498825776895,74.109043275335651,74.217880203862094]
["Couple with 4 or more children  (per child)","P-CD4+",{"$f":"D14","v":72.497239478274494},{"$f":"E14","v":72.497239478274494},{"$f":"F14","v":72.497239478274494},{"$f":"IF(F23-F20<0,0,F23-F20)/3","v":72.497239478274494},72.590693219949046,72.72577236483869,72.912323553169429,73.088865783016402,73.301505933470978,73.412875072012255,73.51998744946593,73.820498825776895,74.109043275335651,74.217880203862094]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[null,null,25000,25000,37000,49000,61000,74000,98000,123000,147000,172000,196000,246000,307000,368000]
[null,null,"or less","to","to","to","to","to","to","to","to","to","to","to","to","to"]
["Australia",null,null,37000,49000,61000,74000,98000,123000,147000,172000,196000,246000,307000,368000,614000]
["Couple",null,0,553.28368370810654,567.65944127870807,588.24790794372473,626.23508682568411,681.14900853553115,756.98103315359322,828.73947398398207,915.1865124016341,960.44495623987518,1003.9880431092344,1126.1517492515811,1243.4384719356358,1287.6800804572717]
["Couple with 1 child",null,0,0,654.40754939073224,675.06831118834896,713.18888889462687,768.29559153128469,844.39393237470495,916.40431180869905,1003.1549036772694,1048.57226975347,1092.2682738612416,1214.8609319625486,1332.5594997493315,1376.9564599543419]
["Couple with 2 children",null,0,0,726.56289492519807,747.13349229300752,785.08770105628093,839.95392487994343,915.72013279549071,987.41632908016743,1073.7882645699988,1119.0075005209549,1162.5127768554557,1284.5703988810826,1401.755398351045,1445.958535199768]
["Couple with 3 or more children",null,0,0,0,805.73962637854822,844.00716648553123,899.32632563004722,975.71800381310152,1048.0060713330313,1135.091030202047,1180.683581455912,1224.5480054576321,1347.6132457289118,1465.7656017616428,1510.333721068858]
[]
["Single person",null,281.88967375827372,297.87697304376547,312.2425383027354,332.8163882392883,370.77660279558972,425.65150192223405,501.42968979126897,573.13723163665941,659.52284232324064,704.74917334028123,748.26136520166733,870.33832324444279,987.5418334047414,1031.7519595371839]
["Single parent with 1 child",null,0,398.19154942718183,412.55586067346457,433.12798398804131,471.08491329334549,525.95514615319064,601.72683058634061,673.4281812716406,759.80640689023812,805.02889853539864,848.53732476107632,970.60383894067218,1087.7972497308569,1132.0036601654074]
["Single parent with 2 children",null,0,510.53150034341115,524.93078756841169,545.5529000753869,583.60215791824737,638.6057837388106,714.56173367667452,786.43744274265623,873.02575362317316,918.3581958563135,961.97244119721074,1084.3357149295496,1201.8141818884669,1246.1280170657612]
["Single parent with 3 or more children",null,0,0,637.30571446335875,657.97781616273255,696.11940254314925,751.25642132443056,827.39663676700843,899.44670421367186,986.2451003561082,1031.6874931772284,1075.4075576333453,1198.067590918427,1315.8311140460769,1360.2523739661151]
[]
[]
[]
[]
[]
[]
[]
["Comparison to prior Benchmark version"]
[]
["HEM 2022Q4"]
[]
[null,null,24000,24000,36000,48000,61000,73000,97000,121000,145000,170000,194000,242000,303000,363000]
[null,null,"or less","to","to","to","to","to","to","to","to","to","to","to","to","to"]
["Australia",null,null,36000,48000,61000,73000,97000,121000,145000,170000,194000,242000,303000,363000,606000]
["Couple",null,0,544.10903621410478,559.55174705951447,580.17585407252079,615.99322016446683,670.96414323092063,745.93306267696573,815.15928049685147,905.70584130806276,943.43399233756872,991.33447361442131,1112.2359617806537,1224.0057266162144,1276.4438910025435]
["Couple with 1 child",null,0,0,643.65466820561812,664.26663767351772,700.0629247972314,755.0015059547577,829.92628691878645,899.11176424305552,989.6050739391909,1027.311039814231,1075.1832210506291,1196.0136671855871,1307.7176541156407,1360.1248846474471]
["Couple with 2 children",null,0,0,713.52066421853476,734.10254032903049,769.84646487342616,824.70473842271861,899.52003315286572,968.60437717351897,1058.9653514775482,1096.6162547999077,1144.4184945000638,1265.0722776135649,1376.6129789284548,1428.9436021062031]
["Couple with 3 or more children",null,0,0,0,792.02992414889559,827.76946226942528,882.62104033081062,957.42708065338547,1026.5029467797044,1116.8528870800378,1154.4991150411504,1202.2954702392365,1322.9344469586295,1434.4614602188215,1486.7856614857876]
[]
["Single person",null,277.271152334779,291.36044343759602,306.76057729962747,327.32782935319136,363.04640102703144,417.86576618371964,492.62795802760638,561.66329225358095,651.9601992918947,689.58435573201973,737.3526652867522,857.92085422951288,969.38240807859847,1021.6759800606131]
["Single parent with 1 child",null,0,394.3567771268838,409.86734796721458,430.58216353166193,466.55696002308071,521.76959377529033,597.06810612526044,666.59863281824755,757.54330883377952,795.43736453036877,843.54834306299301,964.98145393073924,1077.2426026842672,1129.9112321950072]
["Single parent with 2 children",null,0,500.15773410971747,515.68978625543411,536.43322605243497,572.45774940880153,627.74671112794806,703.14925096239267,772.77594293827008,863.84632900814586,901.79276450319753,949.97024537538516,1071.5711910803748,1183.9875519020209,1236.7289836543882]
["Single parent with 3 or more children",null,0,0,621.5122245436537,642.28428857320796,678.35853879452236,733.72382848060579,809.2303957995249,878.9532530582926,970.1493491825122,1008.1481644760263,1056.3921476877772,1178.1609282300103,1290.7325011197745,1343.5467351137693]
[]
["CHANGE"]
["Couple",null,null,{"$f":"D20-D43","v":9.1746474940017606},8.1076942191936041,8.0720538712039342,10.241866661217273,10.184865304610526,11.047970476627484,13.5801934871306,9.4806710935713454,17.010963902306457,12.653569494813041,13.915787470927398,19.432745319421429,11.236189454728219]
["Couple with 1 child",null,null,null,10.75288118511412,10.801673514831236,13.125964097395467,13.294085576526982,14.4676454559185,17.292547565643531,13.549829738078529,21.261229939239001,17.085052810612524,18.847264776961538,24.841845633690809,16.83157530689482]
["Couple with 2 children",null,null,null,13.042230706663304,13.030951963977031,15.241236182854777,15.249186457224823,{"$f":"I22-I45","v":16.200099642624991},18.81195190664846,14.822913092450563,22.391245721047198,18.094282355391897,19.498121267517718,25.142419422590137,17.014933093564878]
["Couple with 3 or more children",null,null,null,null,13.709702229652635,16.237704216105953,16.705285299236607,18.290923159716044,21.50312455332687,18.238143122009205,26.184466414761573,22.252535218395678,24.678798770282356,31.304141542821299,23.548059583070426]
[]
["Single person",null,{"$f":"C25-C48","v":4.6185214234947125},6.5165296061694562,5.4819610031079264,5.4885588860969392,7.7302017685582882,7.7857357385144041,8.8017317636625876,11.473939383078459,7.5626430313459423,15.164817608261501,10.908699914915132,12.417469014929907,18.159425326142923,10.075979476570751]
["Single parent with 1 child",null,null,3.8347723002980274,2.6885127062499805,2.5458204563793743,4.5279532702647884,4.1855523779003079,4.658724461080169,6.8295484533930448,2.2630980564586025,9.591534005029871,4.9889816980833075,5.6223850099329411,10.554647046589707,2.0924279704001947]
["Single parent with 2 children",null,null,10.373766233693686,9.2410013129775734,9.1196740229519264,11.144408509445839,10.85907261086254,11.41248271428185,13.661499804386153,9.1794246150273011,16.565431353115969,12.00219582182558,12.764523849174793,17.826629986446051,9.3990334113730114]
["Single parent with 3 or more children",null,null,null,15.793489919705053,15.693527589524592,17.760863748626889,17.532592843824773,18.166240967483532,20.493451155379262,16.095751173596,23.539328701202066,19.015409945568081,19.906662688416645,25.098612926302394,16.705638852345828]

{"sheet":"Validation","index":3,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Residential","Member 1","Member 2","Member 3","Member 4","Member 5","Member 6",null,null,"Valid Status",null,null,"Validation Rules","Remarks"]
["Member 1",{"$f":"IF(AND(B$1<>$A2,HLOOKUP($A2,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!E$56=\"Individual (Couple)\"),$A2)","v":false},{"$f":"IF(AND(C$1<>$A2,HLOOKUP($A2,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!G$56=\"Individual (Couple)\"),$A2)","v":false},{"$f":"IF(AND(D$1<>$A2,HLOOKUP($A2,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!I$56=\"Individual (Couple)\"),$A2)","v":false},{"$f":"IF(AND(E$1<>$A2,HLOOKUP($A2,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!K$56=\"Individual (Couple)\"),$A2)","v":false},{"$f":"IF(AND(F$1<>$A2,HLOOKUP($A2,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!M$56=\"Individual (Couple)\"),$A2)","v":false},{"$f":"IF(AND(G$1<>$A2,HLOOKUP($A2,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!O$56=\"Individual (Couple)\"),$A2)","v":false},null,null,"Individual (Single)",null,null,{"$f":"SMSF!E20","v":""},{"$f":"IF(M2=\"\",\"Valid\",\"Invalid\")","v":"Valid"}]
["Member 2",{"$f":"IF(AND(B$1<>$A3,HLOOKUP($A3,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!E$56=\"Individual (Couple)\"),$A3)","v":false},{"$f":"IF(AND(C$1<>$A3,HLOOKUP($A3,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!G$56=\"Individual (Couple)\"),$A3)","v":false},{"$f":"IF(AND(D$1<>$A3,HLOOKUP($A3,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!I$56=\"Individual (Couple)\"),$A3)","v":false},{"$f":"IF(AND(E$1<>$A3,HLOOKUP($A3,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!K$56=\"Individual (Couple)\"),$A3)","v":false},{"$f":"IF(AND(F$1<>$A3,HLOOKUP($A3,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!M$56=\"Individual (Couple)\"),$A3)","v":false},{"$f":"IF(AND(G$1<>$A3,HLOOKUP($A3,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!O$56=\"Individual (Couple)\"),$A3)","v":false},null,null,"Individual (Couple)",null,null,{"$f":"SMSF!C23","v":""},{"$f":"IF(M3=\"\",\"Valid\",\"Invalid\")","v":"Valid"}]
["Member 3",{"$f":"IF(AND(B$1<>$A4,HLOOKUP($A4,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!E$56=\"Individual (Couple)\"),$A4)","v":false},{"$f":"IF(AND(C$1<>$A4,HLOOKUP($A4,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!G$56=\"Individual (Couple)\"),$A4)","v":false},{"$f":"IF(AND(D$1<>$A4,HLOOKUP($A4,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!I$56=\"Individual (Couple)\"),$A4)","v":false},{"$f":"IF(AND(E$1<>$A4,HLOOKUP($A4,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!K$56=\"Individual (Couple)\"),$A4)","v":false},{"$f":"IF(AND(F$1<>$A4,HLOOKUP($A4,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!M$56=\"Individual (Couple)\"),$A4)","v":false},{"$f":"IF(AND(G$1<>$A4,HLOOKUP($A4,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!O$56=\"Individual (Couple)\"),$A4)","v":false},null,null,null,null,null,{"$f":"SMSF!E23","v":0},{"$f":"IF(M4=\"\",\"Valid\",\"Invalid\")","v":"Invalid"}]
["Member 4",{"$f":"IF(AND(B$1<>$A5,HLOOKUP($A5,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!E$56=\"Individual (Couple)\"),$A5)","v":false},{"$f":"IF(AND(C$1<>$A5,HLOOKUP($A5,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!G$56=\"Individual (Couple)\"),$A5)","v":false},{"$f":"IF(AND(D$1<>$A5,HLOOKUP($A5,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!I$56=\"Individual (Couple)\"),$A5)","v":false},{"$f":"IF(AND(E$1<>$A5,HLOOKUP($A5,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!K$56=\"Individual (Couple)\"),$A5)","v":false},{"$f":"IF(AND(F$1<>$A5,HLOOKUP($A5,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!M$56=\"Individual (Couple)\"),$A5)","v":false},{"$f":"IF(AND(G$1<>$A5,HLOOKUP($A5,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!O$56=\"Individual (Couple)\"),$A5)","v":false},null,null,null,null,null,{"$f":"SMSF!C25","v":""},{"$f":"IF(M5=\"\",\"Valid\",\"Invalid\")","v":"Valid"}]
["Member 5",{"$f":"IF(AND(B$1<>$A6,HLOOKUP($A6,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!E$56=\"Individual (Couple)\"),$A6)","v":false},{"$f":"IF(AND(C$1<>$A6,HLOOKUP($A6,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!G$56=\"Individual (Couple)\"),$A6)","v":false},{"$f":"IF(AND(D$1<>$A6,HLOOKUP($A6,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!I$56=\"Individual (Couple)\"),$A6)","v":false},{"$f":"IF(AND(E$1<>$A6,HLOOKUP($A6,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!K$56=\"Individual (Couple)\"),$A6)","v":false},{"$f":"IF(AND(F$1<>$A6,HLOOKUP($A6,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!M$56=\"Individual (Couple)\"),$A6)","v":false},{"$f":"IF(AND(G$1<>$A6,HLOOKUP($A6,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!O$56=\"Individual (Couple)\"),$A6)","v":false},null,null,null,null,null,{"$f":"SMSF!E25","v":""},{"$f":"IF(M6=\"\",\"Valid\",\"Invalid\")","v":"Valid"}]
["Member 6",{"$f":"IF(AND(B$1<>$A7,HLOOKUP($A7,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!E$56=\"Individual (Couple)\"),$A7)","v":false},{"$f":"IF(AND(C$1<>$A7,HLOOKUP($A7,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!G$56=\"Individual (Couple)\"),$A7)","v":false},{"$f":"IF(AND(D$1<>$A7,HLOOKUP($A7,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!I$56=\"Individual (Couple)\"),$A7)","v":false},{"$f":"IF(AND(E$1<>$A7,HLOOKUP($A7,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!K$56=\"Individual (Couple)\"),$A7)","v":false},{"$f":"IF(AND(F$1<>$A7,HLOOKUP($A7,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!M$56=\"Individual (Couple)\"),$A7)","v":false},{"$f":"IF(AND(G$1<>$A7,HLOOKUP($A7,SMSF!$E$55:$O$56,2,FALSE)=\"Individual (Couple)\",SMSF!O$56=\"Individual (Couple)\"),$A7)","v":false},null,null,"Valid Status 1"]
[null,null,null,null,null,null,null,null,null,"Individual (Single)"]
[null,{"$f":"IF(MID(SMSF!E56,13,6)<>\"Couple\",\"\",\"N/A\")","v":""},{"$f":"IF(MID(SMSF!G56,13,6)<>\"Couple\",\"\",\"N/A\")","v":""},{"$f":"IF(MID(SMSF!I56,13,6)<>\"Couple\",\"\",\"N/A\")","v":""},{"$f":"IF(MID(SMSF!K56,13,6)<>\"Couple\",\"\",\"N/A\")","v":""},{"$f":"IF(MID(SMSF!M56,13,6)<>\"Couple\",\"\",\"N/A\")","v":""},{"$f":"IF(MID(SMSF!O56,13,6)<>\"Couple\",\"\",\"N/A\")","v":""},null,null,"Individual (Couple)"]
[null,{"$f":"IF(MID(SMSF!E56,13,6)<>\"Couple\",\"\",\"Non-loan party\")","v":""},{"$f":"IF(MID(SMSF!G56,13,6)<>\"Couple\",\"\",\"Non-loan party\")","v":""},{"$f":"IF(MID(SMSF!I56,13,6)<>\"Couple\",\"\",\"Non-loan party\")","v":""},{"$f":"IF(MID(SMSF!K56,13,6)<>\"Couple\",\"\",\"Non-loan party\")","v":""},{"$f":"IF(MID(SMSF!M56,13,6)<>\"Couple\",\"\",\"Non-loan party\")","v":""},{"$f":"IF(MID(SMSF!O56,13,6)<>\"Couple\",\"\",\"Non-loan party\")","v":""}]
[null,{"$f":"IFERROR(INDEX(B$2:B$7,SMALL(IF(ISTEXT(B$2:B$7),ROW(B$1:B$6),\"\"), ROW(B2)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(C$2:C$7,SMALL(IF(ISTEXT(C$2:C$7),ROW(C$1:C$6),\"\"), ROW(C2)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(D$2:D$7,SMALL(IF(ISTEXT(D$2:D$7),ROW(D$1:D$6),\"\"), ROW(D2)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(E$2:E$7,SMALL(IF(ISTEXT(E$2:E$7),ROW(E$1:E$6),\"\"), ROW(E2)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(F$2:F$7,SMALL(IF(ISTEXT(F$2:F$7),ROW(F$1:F$6),\"\"), ROW(F2)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(G$2:G$7,SMALL(IF(ISTEXT(G$2:G$7),ROW(G$1:G$6),\"\"), ROW(G2)-1)),\"-\")","v":"-"}]
[null,{"$f":"IFERROR(INDEX(B$2:B$7,SMALL(IF(ISTEXT(B$2:B$7),ROW(B$1:B$6),\"\"), ROW(B3)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(C$2:C$7,SMALL(IF(ISTEXT(C$2:C$7),ROW(C$1:C$6),\"\"), ROW(C3)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(D$2:D$7,SMALL(IF(ISTEXT(D$2:D$7),ROW(D$1:D$6),\"\"), ROW(D3)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(E$2:E$7,SMALL(IF(ISTEXT(E$2:E$7),ROW(E$1:E$6),\"\"), ROW(E3)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(F$2:F$7,SMALL(IF(ISTEXT(F$2:F$7),ROW(F$1:F$6),\"\"), ROW(F3)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(G$2:G$7,SMALL(IF(ISTEXT(G$2:G$7),ROW(G$1:G$6),\"\"), ROW(G3)-1)),\"-\")","v":"-"},null,null,"Valid Status 2"]
[null,{"$f":"IFERROR(INDEX(B$2:B$7,SMALL(IF(ISTEXT(B$2:B$7),ROW(B$1:B$6),\"\"), ROW(B4)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(C$2:C$7,SMALL(IF(ISTEXT(C$2:C$7),ROW(C$1:C$6),\"\"), ROW(C4)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(D$2:D$7,SMALL(IF(ISTEXT(D$2:D$7),ROW(D$1:D$6),\"\"), ROW(D4)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(E$2:E$7,SMALL(IF(ISTEXT(E$2:E$7),ROW(E$1:E$6),\"\"), ROW(E4)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(F$2:F$7,SMALL(IF(ISTEXT(F$2:F$7),ROW(F$1:F$6),\"\"), ROW(F4)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(G$2:G$7,SMALL(IF(ISTEXT(G$2:G$7),ROW(G$1:G$6),\"\"), ROW(G4)-1)),\"-\")","v":"-"},null,null,"Individual (Single)"]
[null,{"$f":"IFERROR(INDEX(B$2:B$7,SMALL(IF(ISTEXT(B$2:B$7),ROW(B$1:B$6),\"\"), ROW(B5)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(C$2:C$7,SMALL(IF(ISTEXT(C$2:C$7),ROW(C$1:C$6),\"\"), ROW(C5)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(D$2:D$7,SMALL(IF(ISTEXT(D$2:D$7),ROW(D$1:D$6),\"\"), ROW(D5)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(E$2:E$7,SMALL(IF(ISTEXT(E$2:E$7),ROW(E$1:E$6),\"\"), ROW(E5)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(F$2:F$7,SMALL(IF(ISTEXT(F$2:F$7),ROW(F$1:F$6),\"\"), ROW(F5)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(G$2:G$7,SMALL(IF(ISTEXT(G$2:G$7),ROW(G$1:G$6),\"\"), ROW(G5)-1)),\"-\")","v":"-"},null,null,"Individual (Couple)"]
[null,{"$f":"IFERROR(INDEX(B$2:B$7,SMALL(IF(ISTEXT(B$2:B$7),ROW(B$1:B$6),\"\"), ROW(B6)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(C$2:C$7,SMALL(IF(ISTEXT(C$2:C$7),ROW(C$1:C$6),\"\"), ROW(C6)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(D$2:D$7,SMALL(IF(ISTEXT(D$2:D$7),ROW(D$1:D$6),\"\"), ROW(D6)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(E$2:E$7,SMALL(IF(ISTEXT(E$2:E$7),ROW(E$1:E$6),\"\"), ROW(E6)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(F$2:F$7,SMALL(IF(ISTEXT(F$2:F$7),ROW(F$1:F$6),\"\"), ROW(F6)-1)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(G$2:G$7,SMALL(IF(ISTEXT(G$2:G$7),ROW(G$1:G$6),\"\"), ROW(G6)-1)),\"-\")","v":"-"}]
[]
["Do not delete this formula ",{"$f":"IF(RIGHT(SMSF!E57,1)=\"2\",AvailableSurplusForAdditionalVoluntaryConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryConcessionContributionsM2+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM2,IF(RIGHT(SMSF!E57,1)=\"3\",AvailableSurplusForAdditionalVoluntaryConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryConcessionContributionsM3+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM3,IF(RIGHT(SMSF!E57,1)=\"4\",AvailableSurplusForAdditionalVoluntaryConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryConcessionContributionsM4+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM4,IF(RIGHT(SMSF!E57,1)=\"5\",AvailableSurplusForAdditionalVoluntaryConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryConcessionContributionsM5+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM5,IF(RIGHT(SMSF!E57,1)=\"6\",AvailableSurplusForAdditionalVoluntaryConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryConcessionContributionsM6+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM6,0)))))","v":0},{"$f":"IF(RIGHT(SMSF!G57,1)=\"3\",AvailableSurplusForAdditionalVoluntaryConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryConcessionContributionsM3+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM3,IF(RIGHT(SMSF!G57,1)=\"4\",AvailableSurplusForAdditionalVoluntaryConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryConcessionContributionsM4+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM4,IF(RIGHT(SMSF!G57,1)=\"5\",AvailableSurplusForAdditionalVoluntaryConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryConcessionContributionsM5+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM5,IF(RIGHT(SMSF!G57,1)=\"6\",AvailableSurplusForAdditionalVoluntaryConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryConcessionContributionsM6+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM6,0))))","v":0},{"$f":"IF(RIGHT(SMSF!I57,1)=\"4\",AvailableSurplusForAdditionalVoluntaryConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryConcessionContributionsM4+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM4,IF(RIGHT(SMSF!I57,1)=\"5\",AvailableSurplusForAdditionalVoluntaryConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryConcessionContributionsM5+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM5,IF(RIGHT(SMSF!I57,1)=\"6\",AvailableSurplusForAdditionalVoluntaryConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryConcessionContributionsM6+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM6,0)))","v":0},{"$f":"IF(RIGHT(SMSF!K57,1)=\"5\",AvailableSurplusForAdditionalVoluntaryConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryConcessionContributionsM5+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM5,IF(RIGHT(SMSF!K57,1)=\"6\",AvailableSurplusForAdditionalVoluntaryConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryConcessionContributionsM6+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM6,0))","v":0},{"$f":"IF(RIGHT(SMSF!M57,1)=\"6\",AvailableSurplusForAdditionalVoluntaryConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM1+AvailableSurplusForAdditionalVoluntaryConcessionContributionsM6+AvailableSurplusForAdditionalVoluntaryNonConcessionContributionsM6,0)","v":0},0,null,null,"Valid Status 3"]
[null,null,null,null,null,null,null,null,null,"Individual (Single)"]
["Dependents Lookup",null,null,null,null,null,null,null,null,"Individual (Couple)"]
["Dependents","DependedntsCode"]
[0,1]
[1,1,null,null,null,null,null,null,null,"Valid Status 4"]
[2,2,null,null,null,null,null,null,null,"Individual (Single)"]
[3,3,null,null,null,null,null,null,null,"Individual (Couple)"]
[4,"4+"]
[]
[null,null,null,null,null,null,null,null,null,"Valid Status 5"]
[null,null,null,null,null,null,null,null,null,"Individual (Single)"]
[null,null,null,null,null,null,null,null,null,"Individual (Couple)"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Valid Status 6"]
[null,null,null,null,null,null,null,null,null,"Individual (Single)"]
[null,null,null,null,null,null,null,null,null,"Individual (Couple)"]
[]
[]
[null,"Don’t remove","Don’t remove"]
[]
["Servicability Calculator"]
[null,"Member 1","Member 2","Member 3","Member 4","Member 5","Member 6"]
["Status"]
["Individual (Couple) With"]

{"sheet":"Tax Table","index":4,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":true,"merged":[[3,0,3,2],[8,0,8,2],[3,4,3,5],[17,0,17,2]]}
[]
[null,null,null,null,null,null,null,null,"This is the Tax Offset for Low income earners"]
[null,null,null,null,null,null,null,null,"https://www.ato.gov.au/individuals/income-and-deductions/offsets-and-rebates/low-income-earners/"]
["Medicare Levy 2017 - 2018",null,null,1,"Tax offset for Low income earners"]
["Threshold","Value","Rate",null,"Thresholds","Max Tax Offset"]
["Minimum for partial levy",21980,0.1,null,37500,700]
["Minimum for full levy",27475,0.02]
[]
["Tax 2018-2019"]
["Tax Bracket Min","Tax For Bracket","Tax Rate",null,"Reduced By over 37000K",1.4999999999999999E-2]
[0,0,0]
[18200,0,0.19,2,"Tax offset for Low income earners"]
[37000,{"$f":"(A13-A12)*C12","v":3572},0.32500000000000001,null,"Thresholds","Tax Offset $","Tax Offset%"]
[90000,{"$f":"(A13-A12)*C12+(A14-A13)*C13","v":20797},0.37,null,0,700]
[180000,{"$f":"(A13-A12)*C12+(A14-A13)*C13+(A15-A14)*C14","v":54097},0.45,null,37500,700,-0.05]
[999999999,{"$f":"B15","v":54097},0.45,null,45000,325,-1.4999999999999999E-2]
[null,null,null,null,66667,0]
["Tax 2020-2021",null,null,null,999999999,0]
["Tax Bracket Min","Tax For Bracket","Tax Rate",null,null,null,null,null,"This is the  Medicare levy reduction for low income earners"]
[0,0,0,null,null,null,null,null,"https://www.ato.gov.au/Individuals/Medicare-levy/Medicare-levy-reduction-for-low-income-earners/"]
[18200,0,0.19]
[45000,{"$f":"(A22-A21)*C21","v":5092},0.32500000000000001]
[120000,{"$f":"(A22-A21)*C21+(A23-A22)*C22","v":29467},0.37]
[180000,{"$f":"(A22-A21)*C21+(A23-A22)*C22+(A24-A23)*C23","v":51667},0.45]
[999999999,{"$f":"B24","v":51667},0.45]

{"sheet":"Inputs","index":5,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":true,"merged":[[28,9,31,9],[32,9,35,9]]}
["Inputs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: Please make changes in \"Residential\" Worksheet column K and L"]
["Baseline Assessment Rate",5.5E-2,null,null,null,null,null,"Owner occupied property utilities, rates & costs"]
["Assessment Loading",0.02,null,null,null,null,null,"Rented property costs"]
["Credit Card Commitments",3.8199999999999998E-2,null,null,null,null,null,"Investment property utilities, rates & costs"]
["Workings for Negative Gearing",6.0400000000000002E-2,null,null,null,null,null,"Telephone, Internet, Pay TV & Media Streaming"]
["Other Mortgage Repayment Buffer",1.25,null,null,null,null,null,"Groceries"]
["Rental Income Shading",0.8,null,null,null,null,null,"Recreation & Entertainment"]
[null,null,null,null,null,null,null,"Clothing & Personal Care"]
["Company Tax",0.25,null,null,null,null,null,"Medical & Health"]
[null,null,null,null,null,null,null,"Transport"]
["NumberOfWeeksInAYear",52,null,null,null,null,null,"Education"]
["NumberOfMonthsInAYear",12]
[null,null,null,null,null,null,null,"Childcare"]
["Compulsary Superannuation Percentage",0.11,null,null,null,null,null,"Insurance"]
["Concessional Contributions Capped Amount",27500]
["Non Concessional Capped Amount",110000,null,null,null,null,null,"Other Living Expenses"]
["MinimumAdministrationCost",1500]
["Superannuation Tax",0.15]
[]
["Minimum SMSF DSCR",0.995]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Loan details"]
[]
[]
[null,null,null,null,null,null,null,null,"Income","Net Member Contributions","PAYG Super Gaurantee Concessional (compulsory) Super (capped $27,500)"]
[null,null,null,null,null,null,null,null,null,null,"PAYG Super Gaurantee Non-Concessional (compulsory) Super (capped $110,000)"]
["Allowable Government Allowance over Total Income Limitation",0.5,null,null,null,null,null,null,null,null,"Non-PAYG?"]
[null,null,null,null,null,null,null,null,null,null,"Gross income\n- tax\n- living expenses\n- debt repayments\n= Non-Concessional Additional Super (total non-concessional capped at $110,000)"]
[null,null,null,null,null,null,null,null,null,"SMSF","Rental income\nCRE (100% of net)\nResidential (80% of gross)"]
[null,null,null,null,null,null,null,null,null,null,"Return on investments"]
[null,null,null,null,null,null,null,null,null,null,"Less adminstration expenses (floor $2,500)"]
[null,null,null,null,null,null,null,null,null,null,"Less debt expenses (mortgage + 25%)"]
[]
[null,null,null,null,null,null,null,null,"DSCR","SMSF net income + Net Member Contributions / SMSF debt repayments"]
["Residenital"]
["Minimum Loan Term in Years",10]
["Maximum Loan Term In years",40]
["Maximum Loan Term In Years For Prime Loans",30]
[]
["Minimum Interest Only Loan term in Years",0]
["Maximum Interest Only Loan term in Years",5]

{"sheet":"Version Control","index":6,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Version","Created date","Date Effective","Created By","Approved By","Change"]
[1,"2023-05-29","2023-06-05","Neil Culkin","Neil Culkin","First issuance"]
[2,"2023-09-13","2023-10-16","Neil Culkin\nDevika Dharapalam","Neil Culkin","1. Compulsary Superannuation Percentage updated to 11%\n2. Interest rate buffer reduced from 2.5% to 2%\n3. Minimum DSCR reduced from 1.25% to 1%\n4. Introducing Existing Concessional Contribution income that can be verified through SMSF financials and not requiring Member income & expense section to be completed\n5. Updated row 89 \"Total Commitments (annualised)\" formula to take higher of HEM or DLE, then plus other commitments\n6. Introduction of 5.5% floor rate\n7. Low Income Earner tax offset updated\n8. HEM updated to 2023Q1"]

{"sheet":"Superannuation Assessment notes","index":7,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["UNDERWRITER NOTES- SMSF",null,"INSTRUCTIONS","COMMENTARY"]
["Purpose",null,"If the purpose is for Cash out, Equity Release, Debt consolidation , Property Improvement or the Sole Purpose test is not met the application is to be DECLINED.",null,null,"Purchase O/O (Commercial Only)","Prime FD 50% $3.0M","Yes ","Retail","CAT 1 "]
["Product",null,"Product and LVR Bands",null,null,"Purchase Investment - Commercial","Prime FD >50-65% $3.00M","No ","Office","CAT 2"]
["Loan Amount",null,"Loan Amount",null,null,"Refinance O/O ( Commercial Only)","Prime FD >65-70% $3.00M",null,"Industrial","CAT 3 (Max 60% LVR of $750K). Refer Instructions for CAT 3"]
["Global Exposure",null,"Total Loan Amount of all Pepper exposure held. If this is the only loan state \"No other exposure held\". Max aggregate exp $7.0M",null,null,"Refinance Investment- Commercial","Prime FD >70-75% $ 2.50M",null,"Boarding House"]
["Funds to complete ( Purchase): Are FTC evidenced from SMSF transactional account.",null,"Funds to complete must be evidenced as being available in the members SMSF bank account. This to be evident prior to settlement. If not evident loan cannot proceed.",null,null,"Purchase Investment- Residential","Prime FD >75-80% (Resi Only) $2.0M",null,"Rooming House"]
["Loan term. Interest Only Term",null,"Loan structure . Ie Total loan term and term of interest only",null,null,"Refinance Investment - Residential","Near Prime FD 50% $3.0M",null,"Residential"]
["Is the SMSF a Complying Superannuation Fund.(Search the SMSF ABN)",null,"If answered NO application to be declined. Refer Super Fund ABN Look Up. https://superfundlookup.gov.au/ABN/View?id=65714394898. Reference Tax return or Trust deed dates and addresses.",null,null,null,"Near Prime FD >50-65% $3.00M"]
["Are Members related ?",null,"A member cannot be an employee of another member unless related.",null,null,null,"Near Prime FD >65-70% $3.00M"]
["Asset Class",null,"Description of asset class of security. Any other asset class not located in selection is unacceptable.",null,null,null,"Near Prime FD >70-75% $ 2.50M"]
["Has NG Security Tab been updated",null,"Update NG Security ",null,null,null,"Near Prime FD >75-80% (Resi Only) $1.50M"]
["Is security a single acquirable asset",null,"If the asset asset is not a single acquirable asset the transaction is to be declined."]
["Address",null,"Address of property being offered as security",null,null,null,"Residential",null,"Prime Lender- 6 months BBS"]
["Security Estimate:",null,"Security value amount used for LVR calculation. ",null,null,null,"Commercial - ",null,"Non Prime Lender - 12 mmonths BBS"]
["Location- CAT 1 2, or 3",null,"What is the security Property location category? If CAT 3 maximum LVR is 60% or $750K ( NSW, VIC, QLD, TAS/ACT) whichever is the lower.",null,null,null,null,null,"N/A - For purchase"]
["LVR:",null,"LVR based on loan amount",null,null,null,"Yes- Addition Income Addendum to be completed ","Yes"]
["DSCR ",null,"Debt Service ratio as per outcome of Servicing Calculator. **Min 1.25 times for both Full Doc and Alt doc loans.",null,null,null,"No","No- Unable to progress (Decline)"]
["Is property being rented Residential or commercial ",null,"If commercial and an executed lease not in existence assessment to include ability to meet loan commitments from existing liquidity of fund during vacancy. Vacancy period to be understood from valuation commentary."]
["Has application Fee be update ",null,"Refer rate card for application Fees"]
["Valuation Reviewed. ",null,"Valuation reviewed and acceptable. Refer separate valuation review checklist. Please comment on industry that the tenant is involved in."]
["Fraud Check on Directors/Members/Gtors and clear",null,"Is the outcome of the Equifax Fraud check in NextGen Clear? If a match, to be referred to Senior Manager to investigate the match"]
["PEP & Sanctions checked on Directors/Members/Gtors  and clear:",null,"Is the director/s  confirmed as being on the PEP or Sanctions register (not a potential match). If a match refer to dedicated team member for enhanced search. "]
["ID Document is clear and valid",null,"Have the correct, clear  identification documents and Customer Identification form been completed correctly, signed?"]
["Company & Trust Loans - Are all members directors of the SMSF Trust",null,"All SMSF members must be directors of the Corporate Trustee of the Superannuation Trust .Has the correct information and documentation been collected to verify the customer to ensure we meet our AML obligations including the verification of identity of beneficial owners."]
["Is the Trustee for both the Superannuation Trust and Bare ( Property Holding Trusts) corporate entities.",null,"If either of the Trustees of the SMSF Trust or Bare Trust are individuals we are unable to progress on this structure."]
["Does the SMSF have minimum $200,000 in assets",null,"This is a minimum requirement, Assets less than $200,000 are to be referred.Evidenced in Super statements"]
["Directors/Members  Guarantee",null,"All members must be a director of the SMSF and a guarantee be taken as part of security?"]
["Guarantors/Sponsors Statement of position. Is each member in a solvent financial position?",null,"Summary of assets and liabilities of . State main assets (ie home, car, etc) Excess assets over liabilities. State how applicant could meet a call of the guarantee."]
["Is additional supporting income from an individual member required.",null,"When required the individual member section of the calculator to be completed. An acknowledgment from the member that personal financial advice has been recieced and discussed with their advisor."]
["Equifax /commercial search.",null,"Does any member have adverse RHI data. Where there is an adverse listing what is the reason and why is it accepted.  Is the information on the credit file consistent with the information provided in the customer's application form e.g. in relation to liabilities."]
["Do all members have a clear credit report.",null,"Comment on the credit bureau file. Where there is an adverse listing what is the reason and why is it accepted. If there are numerous inquiries and the customer has stated no liabilities - what investigations were done and what was the outcome.  Is the information on the credit file consistent with the information provided in the customer's application form e.g. in relation to liabilities."]
["Does the SMSF service from historical known income streams",null,"Summary about the applicant, job, how long employed, income and what documents were used to verify that income and employment.  Is income reasonable for the borrower's employment and age. If self employed what does the applicants industry do."]
["Refinance- Do we hold refinance statements",null,"Refinance: Comment on conduct of any loans that are being refinanced and where adverse conduct exists why and mitigation. "]
["Refinance- Do we hold copy of the LRBA loan agreement being refinanced.",null,"Copy of loan agreement from outgoing lender to be obtained to allow Galilee to review."]
[]
["ABN Search- PAYG",null,"Confirm employer ABN if applicable"]
["ABN Search- Self Employed Applicants ",null,"When relying on additional income refer to standard CRE origination standard"]
["Is this a joint approval",null,"\" This file is jointly approved \" "]

{"sheet":"Loan Summary","index":8,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Purpose"]
[]
["Income Summary"]

{"sheet":"Conditions","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Workings","index":10,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Funds To Complete"]
[]
["Purchase"]
["GST ( If applicable)"]
["Stamp Duty"]
["Fees"]
["Total"]
["Less Deposit"]
["Loan Required"]