{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Bridging Calculator","Bridging Worksheet","Payout Schedule","Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"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":"Bridging Calculator","index":0,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[25,0,30,4],[22,3,23,4],[5,0,5,4],[6,1,6,4],[5,7,5,8],[15,7,16,8],[13,3,13,4]]}
[]
[]
[]
[]
[]
["BRIDGING CALCULATOR - BROKER v5.1                             Last updated: December 2025",null,null,null,null,null,null,"Quote"]
["Applicant's Name:"]
[null,"Edit this column ↓",null,null,null,null,null,"Total Loan Amount",{"$f":"E11","v":2800}]
["Property being purchased",null,null,"Amount you need to cover all costs",{"$f":"IF(B10>0, CEILING(Net_Loan_Amt('Bridging Worksheet'!G16, 'Bridging Worksheet'!F13, 'Bridging Worksheet'!C29),10),0)","v":0},null,null,"Bridging Term (months)",{"$f":"B23","v":12}]
["Purchase Price ",0,null,null,null,null,null,"Interest Rate",{"$f":"B24","v":0}]
["State","NSW",null,"TOTAL LOAN (Peak Debt)",{"$f":"'Bridging Worksheet'!F19","v":2800},null,null,"Application Fee",{"$f":"'Bridging Worksheet'!C25","v":35}]
[null,null,null,"Includes Capped Interest ",{"$f":"'Bridging Worksheet'!F20","v":100},null,null,"LVR",{"$f":"E13","v":0}]
["Property to be sold",null,null,"Peak LVR",{"$f":"'Bridging Worksheet'!F21","v":0},null,null,"End Debt",{"$f":"E17","v":2800}]
["Market Value",0,null,{"$f":"_xlfn.IFS(\nAND(E11>4000000, E13>70%), \"LVR cannot exceed 70% for loan above $4.0mln - contact your BDM\",\nE11>4000000, \"Loan above $4.0mln - contact your BDM\",\nE11>'Bridging Worksheet'!F18,_xlfn.TEXTJOIN(\" \",1,\"Consider contributing more savings. Peak debt cannot exceed\",TEXT('Bridging Worksheet'!F18,\"$###,###\")), TRUE, \"\")","v":"Consider contributing more savings. Peak debt cannot exceed $"},null,null,null,"End Debt LVR",{"$f":"E18","v":0}]
["Existing mortgage",0,null,"Surplus at Settlement",{"$f":"'Bridging Worksheet'!F29","v":-247.42999999995641},null,null,"Net Sales Proceeds",{"$f":"E21","v":0}]
["State","NSW",null,null,null,null,null,"Breakdown"]
["Property already sold (COS available)?","No",null,"Minimum End Debt",{"$f":"'Bridging Worksheet'!F23","v":2800}]
[null,null,null,"End LVR",{"$f":"'Bridging Worksheet'!F24","v":0},null,null,"Peak Debt",{"$f":"E11","v":2800}]
["Contributions",null,null,{"$f":"IF(NOT(OR(E17=\"No End Debt\",E17=0, E18>80%)),_xlfn.TEXTJOIN(\" \",1,\"Calculate servicing for\",TEXT(E17,\"$###,###\")), \"\")","v":"Calculate servicing for $2,800"},null,null,null,"Interest Budget (included)",{"$f":"E12","v":100}]
["Savings+Deposit paid",0,null,{"$f":"IF(E18>80%,\"End LVR cannot exceed 80%\", \"\")","v":""},null,null,null,"Refinance",{"$f":"B15","v":0}]
[null,null,null,"Net Sales Proceeds",{"$f":"'Bridging Worksheet'!F30","v":0},null,null,"All fees, duties & costs",{"$f":"'Bridging Worksheet'!C38","v":2865.0299999999561}]
["Loan terms",null,null,null,null,null,null,"Stamp duty + Transfer Fee",{"$f":"'Bridging Worksheet'!C32+'Bridging Worksheet'!C33","v":175.7}]
["Bridging Period (months)",12,null,"DISCLAIMER: the above calculations do not include broker's mandate or Settlement fee, if applicable.",null,null,null,"Mortgage Registration Fee",{"$f":"'Bridging Worksheet'!C31","v":351.4}]
["Interest Rate",0,null,null,null,null,null,"Title Insurance fee",{"$f":"'Bridging Worksheet'!C29","v":247.42999999995641}]
[{"$f":"'Bridging Worksheet'!E12","v":""},null,null,null,null,null,null,"Borrower's conveyancer",{"$f":"'Bridging Worksheet'!C35","v":1500}]
["The information contained in this calculator is provided by ORDE Financial Pty Limited ACN 634 779 990 Australian Credit Licence 522079 and ORDE Capital Management Limited ACN 636 165 378 Australian Financial Services Licence 523150 Australian Credit Licence 523150 for illustrative purposes only and should not be regarded as a prediction, or as personal advice. Calculations are not forecasts or projections but is a tool that may assist you to make your own projections. The calculator is not intended to be a substitute for professional advice. The information in this calculator does not constitute an offer to lend, or imply the product is suitable for clients. Before acting on this general information, your client must consider its appropriateness having regard to their own objectives, financial situation and need and also seek independent financial, legal and taxation advice. No guarantee, warranty, or representation is given or implied as to the reliability or accuracy of the information use to compile each index or each calculation. ORDE Financial specifically disclaims any liability for any direct, indirect, incidental, consequential, or special damages or for any loss arising out of or in any way connected with the access to, reliance on, or use of this calculator.",null,null,null,null,null,null,"Application fee",{"$f":"'Bridging Worksheet'!C25","v":35}]
[null,null,null,null,null,null,null,"Lender's legal fees",{"$f":"'Bridging Worksheet'!C28","v":555.5}]
[null,null,null,null,null,null,null,"Balance for the purchase",{"$f":"I18-I19-I20-I21","v":-165.02999999995609}]
[]
[null,null,null,null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\" \", 1, \"Figures are based on the sale settling in\", TEXT(B23, \"##\"), \"months.\")","v":"Figures are based on the sale settling in 12 months."}]

{"sheet":"Bridging Worksheet","index":1,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":true,"merged":[[4,0,4,5],[7,0,7,2],[13,0,13,2],[7,3,36,3],[22,0,22,2],[21,0,21,2],[5,1,5,5],[23,0,23,2],[33,0,33,2],[29,0,29,2],[12,5,14,5],[26,4,26,5],[31,4,37,10],[18,8,18,9],[11,4,11,5],[6,2,6,4],[5,8,5,9],[12,4,14,4]]}
[]
[]
[]
[]
["BRIDGING CALCULATOR - BROKER "]
["Applicant's Name:",null,null,null,null,null,null,null,"Quote"]
[null,null,"Enter data in the cells highlighted in yellow"]
["Existing property you are selling",null,null,null,"Loan Details"]
["Existing Property Value",null,{"$f":"'Bridging Calculator'!B14","v":0},null,"Minimum Bridging Period (months)",{"$f":"_xlfn.IFS(C12=\"\", \"\", C12= \"Yes\", 6, C12=\"No\", 12)","v":12},null,null,"Total Loan Amount",{"$f":"F19","v":2800}]
["Existing Mortgage",null,{"$f":"'Bridging Calculator'!B15","v":0},null,"Bridging period (max 12 months)",{"$f":"'Bridging Calculator'!B23","v":12},null,null,"Term (months)",{"$f":"F10","v":12}]
["State",null,{"$f":"'Bridging Calculator'!B16","v":"NSW"},null,"Interest Rate",{"$f":"'Bridging Calculator'!B24","v":0},null,null,"Interest Rate",{"$f":"F11","v":0}]
["Has the property been sold?",null,{"$f":"'Bridging Calculator'!B17","v":"No"},null,{"$f":"IF(F10<F9, _xlfn.TEXTJOIN(\" \", 1, \"Minimum bridging period is\", TEXT(F9, \"##\"), \"months\"),\"\")","v":""},null,null,null,"Application Fee",{"$f":"B25","v":1.2500000000000001E-2}]
[null,null,null,null,"Approx. loan amount to avoid shortfall at settlement. To reduce - add more savings.",{"$f":"CEILING(C10+C15-SUM(C18:C19)+ SUM(C25:C28)+SUM(C31:C33)+ SUM(C35:C36),100)","v":2700},null,null,"Settlement Fee",{"$f":"B26","v":0}]
["Property you are purchasing",null,null,null,null,null,null,null,"LVR",{"$f":"F21","v":0}]
["Purchase Property Value",null,{"$f":"'Bridging Calculator'!B10","v":0},null,null,null,null,null,"End Debt",{"$f":"TEXT(IF(AND(NOT(F25=\"\"), NOT(F25=0)),F25,F23), \"$ ###,###\")","v":"$ 2,800"}]
["Market Value (valuation)",null,{"$f":"C15","v":0},null,"Required Loan Amount",{"$f":"MAX('Bridging Calculator'!E9, F13)","v":2700},{"$f":"MIN(F13, F16)","v":2700},null,"End Debt LVR",{"$f":"IF(AND(NOT(F25=\"\"), NOT(F25=0)),F26,F24)","v":0}]
["State",null,{"$f":"'Bridging Calculator'!B11","v":"NSW"}]
["Deposit Paid",null,{"$f":"'Bridging Calculator'!B20","v":0},null,"Maximum Peak Debt",{"$f":"IF(C12 = \"Yes\", (C9+ MIN(C16,C15))*0.8, C9 * 0.75 + MIN(C16,C15)*0.8)","v":0}]
["Savings to contribute",null,0,null,"Peak Debt (Loan required + Interest)",{"$f":"CEILING(FV((F11+2%)/12, F10, 0, -F16),100)","v":2800},null,null,"Transaction Summary"]
[null,null,null,null,"Interest Budget",{"$f":"F19-F16","v":100}]
["Total Security value",null,{"$f":"C9+MIN(C16,C15)","v":0},null,"Peak LVR ",{"$f":"IFERROR(F19/C21, 0)","v":0},null,null,"Peak Debt",{"$f":"F19","v":2800}]
[null,null,null,null,null,null,null,null,"Interest Budget",{"$f":"F20","v":100}]
["Transaction Costs",null,null,null,"Minimum End Debt",{"$f":"IF((F19-F30)<0, \"No End Debt\", CEILING(F19-F30, 100))","v":2800},null,null,"Refinance",{"$f":"C10","v":0}]
["Lender's & Broker's Fees",null,null,null,"LVR on End Debt",{"$f":"IFERROR(IF(ISNUMBER(F23),F23/C16,0),0)","v":0},null,null,"All fees & Costs",{"$f":"C38","v":2865.0299999999561}]
["Application Fee",1.2500000000000001E-2,{"$f":"F19*B25","v":35},null,"Requested End Debt",0,null,null,"Balance for the purchase",{"$f":"J21-J22-J23-J24","v":-165.02999999995609}]
["Settlement Fee",0,{"$f":"F19*B26","v":0},null,"LVR on requested End Debt",{"$f":"IF(ISNUMBER(F25),F25/C16,0)","v":{"$error":"#DIV/0!"}}]
["Broker's Mandate",null,0,null,{"$f":"_xlfn.IFS(AND(NOT(OR(F23=\"No End Debt\", F23=0)), F25<>\"\", F25<F23),  _xlfn.TEXTJOIN(\" \", 1, \"Requested End Debt cannot be less than\", TEXT(F23, \"$###,###\")), NOT(OR(F23=\"No End Debt\", F23=0)), _xlfn.TEXTJOIN(\" \", 1, \"Calculate servicing for\", TEXT(IF(AND(F25<>\"\", F25<>0),F25,F23), \"$###,###\")) )","v":"Requested End Debt cannot be less than $2,800"}]
["Lender's Legals",null,555.5]
["Title Insurance Fee",null,{"$f":"SUM(Data!X20, Data!X21)","v":247.42999999995641},null,"Surplus/Deficit at settlement",{"$f":"F16-F13-C29","v":-247.42999999995641},null,null,"NOTE: Net_Loan_Amt - recursive function, see Menu: Formulas -> Name Manager"]
["Government Fees",null,null,null,"Expected Net Sales Proceeds",{"$f":"C9*(100%-10%)*(100%-2.5%)","v":0}]
["Mortgage Registration Fee",null,{"$f":"_xlfn.XLOOKUP(C11, Data!O4:O11, Data!Q4:Q11)+_xlfn.XLOOKUP(C17, Data!O4:O11, Data!Q4:Q11)","v":351.4}]
["Stamp Duty",null,{"$f":"VLOOKUP(C17, Data!O4:P11,2,FALSE)","v":false},null,"The information contained in this calculator is provided by ORDE Financial Pty Limited ACN 634 779 990 Australian Credit Licence 522079 and ORDE Capital Management Limited ACN 636 165 378 Australian Financial Services Licence 523150 Australian Credit Licence 523150 for illustrative purposes only and should not be regarded as a prediction, or as personal advice. Calculations are not forecasts or projections but is a tool that may assist you to make your own projections. The calculator is not intended to be a substitute for professional advice. The information in this calculator does not constitute an offer to lend, or imply the product is suitable for clients. Before acting on this general information, your client must consider its appropriateness having regard to their own objectives, financial situation and need and also seek independent financial, legal and taxation advice. No guarantee, warranty, or representation is given or implied as to the reliability or accuracy of the information use to compile each index or each calculation. ORDE Financial specifically disclaims any liability for any direct, indirect, incidental, consequential, or special damages or for any loss arising out of or in any way connected with the access to, reliance on, or use of this calculator."]
["Transfer fee",null,{"$f":"_xlfn.IFS(C17=\"VIC\",MIN(3621,ROUND(111.8+(FLOOR(C15,1000)*2.34/1000),0)),\nC17=\"NSW\",Data!Q5,\nC17=\"ACT\",479,\nC17=\"NT\",Data!Q10,\nC17=\"Tas\",250.21,\nC17=\"SA\",342+CEILING((C15-50000)/10000,1)*102,\nC17=\"QLD\",IF(C15<=180000,Data!Q7,Data!Q7+(CEILING(C15,10000)-180000)*44.71/10000),\nC17=\"WA\",_xlfn.IFS(C15<=120000,226.6,C15<=200000,246.6,C15<=2000000,246.6+(CEILING(C15,100000)-200000)*20/100000,C15>2000000,606.6+CEILING(C15,100000)*20/100000))","v":175.7}]
["Other Costs"]
["Borrower's Conveyancer",null,1500]
["Other",null,0]
[]
["All fees & Costs",null,{"$f":"SUM(C25:C29)+SUM(C31:C33)+SUM(C35:C36)","v":2865.0299999999561}]

{"sheet":"Payout Schedule","index":2,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,0,22,3]]}
["Estimated loan balance per month"]
[]
["Net Loan at drawdown:",{"$f":"'Bridging Calculator'!E9","v":0}]
[]
["Month","Interest charged","Interest accummulated","Estimated Loan Balance"]
[1,{"$f":"IF(A6<='Bridging Calculator'!$B$23,\nIPMT('Bridging Calculator'!$B$24/12, A6, 'Bridging Calculator'!$B$23, -$B$3,\nFV('Bridging Calculator'!$B$24/12,'Bridging Calculator'!$B$23,0, -$B$3) ),\n0)","v":0},{"$f":"B6","v":0},{"$f":"FV('Bridging Calculator'!B24/12,1,0, -'Bridging Calculator'!E9)","v":0}]
[2,{"$f":"IF(A7<='Bridging Calculator'!$B$23,\nIPMT('Bridging Calculator'!$B$24/12, A7, 'Bridging Calculator'!$B$23, -$B$3,\nFV('Bridging Calculator'!$B$24/12,'Bridging Calculator'!$B$23,0, -$B$3) ),\n0)","v":0},{"$f":"C6+B7","v":0},{"$f":"IF(A7<='Bridging Calculator'!$B$23, FV('Bridging Calculator'!$B$24/12,1,0, -D6),0)","v":0}]
[3,{"$f":"IF(A8<='Bridging Calculator'!$B$23,\nIPMT('Bridging Calculator'!$B$24/12, A8, 'Bridging Calculator'!$B$23, -$B$3,\nFV('Bridging Calculator'!$B$24/12,'Bridging Calculator'!$B$23,0, -$B$3) ),\n0)","v":0},{"$f":"C7+B8","v":0},{"$f":"IF(A8<='Bridging Calculator'!$B$23, FV('Bridging Calculator'!$B$24/12,1,0, -D7),0)","v":0}]
[4,{"$f":"IF(A9<='Bridging Calculator'!$B$23,\nIPMT('Bridging Calculator'!$B$24/12, A9, 'Bridging Calculator'!$B$23, -$B$3,\nFV('Bridging Calculator'!$B$24/12,'Bridging Calculator'!$B$23,0, -$B$3) ),\n0)","v":0},0,{"$f":"IF(A9<='Bridging Calculator'!$B$23, FV('Bridging Calculator'!$B$24/12,1,0, -D8),0)","v":0}]
[5,{"$f":"IF(A10<='Bridging Calculator'!$B$23,\nIPMT('Bridging Calculator'!$B$24/12, A10, 'Bridging Calculator'!$B$23, -$B$3,\nFV('Bridging Calculator'!$B$24/12,'Bridging Calculator'!$B$23,0, -$B$3) ),\n0)","v":0},0,{"$f":"IF(A10<='Bridging Calculator'!$B$23, FV('Bridging Calculator'!$B$24/12,1,0, -D9),0)","v":0}]
[6,{"$f":"IF(A11<='Bridging Calculator'!$B$23,\nIPMT('Bridging Calculator'!$B$24/12, A11, 'Bridging Calculator'!$B$23, -$B$3,\nFV('Bridging Calculator'!$B$24/12,'Bridging Calculator'!$B$23,0, -$B$3) ),\n0)","v":0},0,{"$f":"IF(A11<='Bridging Calculator'!$B$23, FV('Bridging Calculator'!$B$24/12,1,0, -D10),0)","v":0}]
[7,{"$f":"IF(A12<='Bridging Calculator'!$B$23,\nIPMT('Bridging Calculator'!$B$24/12, A12, 'Bridging Calculator'!$B$23, -$B$3,\nFV('Bridging Calculator'!$B$24/12,'Bridging Calculator'!$B$23,0, -$B$3) ),\n0)","v":0},0,{"$f":"IF(A12<='Bridging Calculator'!$B$23, FV('Bridging Calculator'!$B$24/12,1,0, -D11),0)","v":0}]
[8,{"$f":"IF(A13<='Bridging Calculator'!$B$23,\nIPMT('Bridging Calculator'!$B$24/12, A13, 'Bridging Calculator'!$B$23, -$B$3,\nFV('Bridging Calculator'!$B$24/12,'Bridging Calculator'!$B$23,0, -$B$3) ),\n0)","v":0},0,{"$f":"IF(A13<='Bridging Calculator'!$B$23, FV('Bridging Calculator'!$B$24/12,1,0, -D12),0)","v":0}]
[9,{"$f":"IF(A14<='Bridging Calculator'!$B$23,\nIPMT('Bridging Calculator'!$B$24/12, A14, 'Bridging Calculator'!$B$23, -$B$3,\nFV('Bridging Calculator'!$B$24/12,'Bridging Calculator'!$B$23,0, -$B$3) ),\n0)","v":0},0,{"$f":"IF(A14<='Bridging Calculator'!$B$23, FV('Bridging Calculator'!$B$24/12,1,0, -D13),0)","v":0}]
[10,{"$f":"IF(A15<='Bridging Calculator'!$B$23,\nIPMT('Bridging Calculator'!$B$24/12, A15, 'Bridging Calculator'!$B$23, -$B$3,\nFV('Bridging Calculator'!$B$24/12,'Bridging Calculator'!$B$23,0, -$B$3) ),\n0)","v":0},0,{"$f":"IF(A15<='Bridging Calculator'!$B$23, FV('Bridging Calculator'!$B$24/12,1,0, -D14),0)","v":0}]
[11,{"$f":"IF(A16<='Bridging Calculator'!$B$23,\nIPMT('Bridging Calculator'!$B$24/12, A16, 'Bridging Calculator'!$B$23, -$B$3,\nFV('Bridging Calculator'!$B$24/12,'Bridging Calculator'!$B$23,0, -$B$3) ),\n0)","v":0},0,{"$f":"IF(A16<='Bridging Calculator'!$B$23, FV('Bridging Calculator'!$B$24/12,1,0, -D15),0)","v":0}]
[12,{"$f":"IF(A17<='Bridging Calculator'!$B$23,\nIPMT('Bridging Calculator'!$B$24/12, A17, 'Bridging Calculator'!$B$23, -$B$3,\nFV('Bridging Calculator'!$B$24/12,'Bridging Calculator'!$B$23,0, -$B$3) ),\n0)","v":0},0,{"$f":"IF(A17<='Bridging Calculator'!$B$23, FV('Bridging Calculator'!$B$24/12,1,0, -D16),0)","v":0}]
[]
["NOTE:  Above figures are based on the quoted rate and are approximate. The interest budget is calculated on the assessment rate."]

{"sheet":"Data","index":3,"n_rows":75,"n_cols":24,"rows_kept":75,"cut":false,"hidden":true,"merged":[[9,1,9,2],[68,0,74,0],[25,0,31,0],[25,3,25,10],[33,0,40,0],[42,0,59,0],[61,0,66,0]]}
[]
[]
[null,null,"Residential","ACT","NSW","NT","QLD","SA","TAS","VIC","WA","BASE",null,null,"State","Stamp Duty","Mortgage Registration"]
[null,null,600000,{"$f":"ROUNDUP(ROUNDUP($L$4*$D$26,2)*D27,2)","v":132},{"$f":"ROUNDUP(ROUNDUP($L$4*$D$26, 2)*E27, 2)","v":143.88},{"$f":"ROUNDUP(ROUNDUP($L$4*$D$26,2)*F27,2)","v":145.19999999999999},143.88,146.52000000000001,145.19999999999999,145.19999999999999,145.19999999999999,120,null,null,"VIC",{"$f":"ROUND(IF('Bridging Worksheet'!C15>2000000, ('Bridging Worksheet'!C15-2000000)*0.065+110000, IF('Bridging Worksheet'!C15>960000,'Bridging Worksheet'!C15*0.055,IF('Bridging Worksheet'!C15>130001,2870 + ('Bridging Worksheet'!C15-130000)*0.06, IF('Bridging Worksheet'!C15> 25001,350 + ('Bridging Worksheet'!C15-25000)*0.024, 'Bridging Worksheet'!C15*0.014)))),)","v":0},135.80000000000001]
[null,null,1000000,{"$f":"ROUNDUP(ROUNDUP($L$5*$D$26,2)*D27,2)","v":237.6},{"$f":"ROUNDUP(ROUNDUP($L$5*$D$26, 2)*E27, 2)","v":258.99},{"$f":"ROUNDUP(ROUNDUP($L$5*$D$26,2)*F27,2)","v":261.36},258.99,263.74,261.36,261.36,261.36,216,null,null,"NSW",{"$f":"IF('Bridging Worksheet'!C15>3721000,CEILING(('Bridging Worksheet'!C15-3721000)/100,1)*7+186667, IF('Bridging Worksheet'!C15>1240000,CEILING(('Bridging Worksheet'!C15-1240000)/100,1)*5.5+50212,IF('Bridging Worksheet'!C15>372000,CEILING(('Bridging Worksheet'!C15-372000)/100,1)*4.5+11152, IF('Bridging Worksheet'!C15>99000,CEILING(('Bridging Worksheet'!C15-99000)/100,1)*3.5+1597))))","v":false},175.7]
[null,null,2000000,{"$f":"ROUNDUP(ROUNDUP($L$6*$D$26,2)*D27,2)","v":475.2},{"$f":"ROUNDUP(ROUNDUP($L$6*$D$26, 2)*E27,2)","v":517.97},{"$f":"ROUNDUP(ROUNDUP($L$6*$D$26,2)*F27,2)","v":522.72},517.97,527.48,522.72,522.72,522.72,432,null,null,"SA",{"$f":"\nIF('Bridging Worksheet'!C15 >= 500000, 21330 + 0.055  * ('Bridging Worksheet'!C15 - 500000),\nIF('Bridging Worksheet'!C15 >= 300000, 11330 + 0.05   * ('Bridging Worksheet'!C15 - 300000),\nIF('Bridging Worksheet'!C15 >= 250000,  8955 + 0.0475 * ('Bridging Worksheet'!C15 - 250000),\nIF('Bridging Worksheet'!C15 >= 200000,  6830 + 0.0425 * ('Bridging Worksheet'!C15 - 200000),\nIF('Bridging Worksheet'!C15 >= 100000,  2830 + 0.04   * ('Bridging Worksheet'!C15 - 100000),\nIF('Bridging Worksheet'!C15 >=  50000,  1080 + 0.035  * ('Bridging Worksheet'!C15 - 50000),\nIF('Bridging Worksheet'!C15 >=  30000,   480 + 0.03   * ('Bridging Worksheet'!C15 - 30000),\nIF('Bridging Worksheet'!C15>=  12000,   120 + 0.02   * ('Bridging Worksheet'!C15 - 12000),\n                          0.01   *  'Bridging Worksheet'!C15)\n)))))))","v":0},198]
[null,null,3000000,{"$f":"ROUNDUP(ROUNDUP($L$7*$D$26, 2)*D27,2)","v":712.8},{"$f":"ROUNDUP(ROUNDUP($L$7*$D$26, 2)*E27,2)","v":776.96},{"$f":"ROUNDUP(ROUNDUP($L$7*$D$26,2)*F27,2)","v":784.08},776.96,791.21,784.08,784.08,784.08,648,null,null,"QLD",{"$f":"ROUND(\n  IF('Bridging Worksheet'!C15 > 1000000, 38025 + 0.0575 * ('Bridging Worksheet'!C15 - 1000000),\n  IF('Bridging Worksheet'!C15 > 540000, 17325 + 0.045  * ('Bridging Worksheet'!C15 - 540000),\n  IF('Bridging Worksheet'!C15 > 75000,  1050 + 0.035  * ('Bridging Worksheet'!C15 - 75000),\n  IF('Bridging Worksheet'!C15 > 5000,         0.015  * ('Bridging Worksheet'!C15 - 5000),\n  0)))),)","v":0},238.14]
[null,null,4000000,{"$f":"ROUNDUP(ROUNDUP($L$8*$D$26, 2)*D27, 2)","v":950.4},{"$f":"ROUNDUP(ROUNDUP($L$8*$D$26,2)*E27,2)","v":1035.94},1045.44,1035.94,1054.95,1045.44,1045.44,1045.44,864,null,null,"WA",{"$f":"\nIF('Bridging Worksheet'!C15> 725000, 28453 + 0.0515 * (CEILING('Bridging Worksheet'!C15,100) - 725000),\nIF('Bridging Worksheet'!C15 > 360000, 11115 + 0.0475 * (CEILING('Bridging Worksheet'!C15,100) - 360000),\nIF('Bridging Worksheet'!C15> 150000,  3135 + 0.038  * (CEILING('Bridging Worksheet'!C15,100) - 150000),\nIF('Bridging Worksheet'!C15 > 120000,  2280 + 0.0285 * (CEILING('Bridging Worksheet'!C15,100) - 120000),\n                        0.019  *  CEILING('Bridging Worksheet'!C15,100))\n)))","v":0},216.6]
[null,null,4000001,{"$f":"ROUND($D$26*D27, 2)","v":1.1000000000000001},{"$f":"ROUND($D$26*E27, 2)","v":1.2},1.21,1.2,1.22,1.21,1.21,1.21,null,null,null,"ACT",{"$f":"\nIF('Bridging Worksheet'!C15 >= 1455000, 0 + 0.0454 * 'Bridging Worksheet'!C15,\nIF('Bridging Worksheet'!C15 >= 1000001, 36950 + 0.064 * ('Bridging Worksheet'!C15- 1000000),\nIF('Bridging Worksheet'!C15 >= 750001, 22200 + 0.059 * ('Bridging Worksheet'!C15 - 750000),\nIF('Bridging Worksheet'!C15 >= 500001, 11400 + 0.0432 * ('Bridging Worksheet'!C15 - 500000),\nIF('Bridging Worksheet'!C15 >= 300001, 4600 + 0.034 * ('Bridging Worksheet'!C15 - 300000),\nIF('Bridging Worksheet'!C15 >= 200001, 2400 + 0.022 * ('Bridging Worksheet'!C15 - 200000),\nMAX(0.012*'Bridging Worksheet'!C15,20)\n))))))","v":20},178]
[null,"additional security same state",null,{"$f":"$L$10*$D$26*D27","v":94.999999999959996},{"$f":"$L$10*$D$26*E27","v":103.5499999999564},104.499999999956,103.5499999999564,105.44999999995561,104.499999999956,104.499999999956,104.499999999956,86.363636363599994,null,null,"NT",{"$f":"MROUND(\nIF('Bridging Worksheet'!C15 > 3000000, 0.0545 * 'Bridging Worksheet'!C15,\nIF('Bridging Worksheet'!C15> 525000, 0.0495 * 'Bridging Worksheet'!C15,\n                  0.06571441 * ((('Bridging Worksheet'!C15/1000)^2)) + 15 * ('Bridging Worksheet'!C15/1000))),0.05)","v":0},176]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAS",{"$f":"\nIF('Bridging Worksheet'!C15> 725000, 27810 + 0.045  * (CEILING('Bridging Worksheet'!C15,100) - 725000),\nIF('Bridging Worksheet'!C15 > 375000, 12935 + 0.0425 * (CEILING('Bridging Worksheet'!C15,100) - 375000),\nIF('Bridging Worksheet'!C15 > 200000,  5935 + 0.04   * (CEILING('Bridging Worksheet'!C15,100) - 200000),\nIF('Bridging Worksheet'!C15 >  75000,  1560 + 0.035  * (CEILING('Bridging Worksheet'!C15,100) - 75000),\nIF('Bridging Worksheet'!C15 >  25000,   435 + 0.0225 * (CEILING('Bridging Worksheet'!C15,100) - 25000),\nIF('Bridging Worksheet'!C15 >   3000,    50 + 0.0175 * (CEILING('Bridging Worksheet'!C15,100) - 3000),\n                   50)\n)))))","v":50},163.30000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Owner Occupied"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential",null,"Investment","Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Commercial",null,"Purchase","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"Refinance"]
[null,null,"Commercial","ACT","NSW","NT","QLD","SA","TAS","VIC","WA",null,null,null,"No",null,"Equity Release"]
[1,1,500000,{"$f":"ROUNDUP(ROUNDUP($D$23*$D$26,2)*D27,2)","v":330},359.7,363,359.7,366.3,363,363,363]
[2,500001,"500,001 - 999,999,999",{"$f":"ROUNDUP(ROUNDUP((SUM('Bridging Worksheet'!$N$26, -$C$17)/1000*0.6+$D$23)*D27,2)*$D$26,2)","v":0},{"$f":"ROUNDUP(ROUNDUP((SUM('Bridging Worksheet'!$N$26, -$C$17)/1000*0.6+$D$23)*E27,2)*$D$26,2)","v":0},{"$f":"ROUNDUP(ROUNDUP((SUM('Bridging Worksheet'!$N$26, -$C$17)/1000*0.6+$D$23)*F27,2)*$D$26,2)","v":0},{"$f":"ROUNDUP(ROUNDUP((SUM('Bridging Worksheet'!$N$26, -$C$17)/1000*0.6+$D$23)*G27,2)*$D$26,2)","v":0},{"$f":"ROUNDUP(ROUNDUP((SUM('Bridging Worksheet'!$N$26, -$C$17)/1000*0.6+$D$23)*H27,2)*$D$26,2)","v":0},{"$f":"ROUNDUP(ROUNDUP((SUM('Bridging Worksheet'!$N$26, -$C$17)/1000*0.6+$D$23)*I27,2)*$D$26,2)","v":0},{"$f":"ROUNDUP(ROUNDUP((SUM('Bridging Worksheet'!$N$26, -$C$17)/1000*0.6+$D$23)*J27,2)*$D$26,2)","v":0},{"$f":"ROUNDUP(ROUNDUP((SUM('Bridging Worksheet'!$N$26, -$C$17)/1000*0.6+$D$23)*K27,2)*$D$26,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title Insurance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Bridging Worksheet'!C11","v":"NSW"},{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER(U20:U21, U20:U21<>\"\", \"\"))","v":"NSW"},{"$f":"COUNTIF(U20:U21,_xlfn.UNIQUE(_xlfn._xlws.FILTER(U20:U21, U20:U21<>0)))","v":2},{"$f":"IF('Bridging Worksheet'!F19=0,\n0,\nIFERROR(IF('Bridging Worksheet'!F19<=4000000,\n_xlfn.XLOOKUP('Bridging Worksheet'!F19,$C$4:$C$9,_xlfn.XLOOKUP(V20,$D$3:$K$3,$D$4:$K$9,,,),,1,),\nROUNDUP(('Bridging Worksheet'!F19/1000)*0.5*_xlfn.XLOOKUP(V20,$D$3:$K$3,$D$9:$K$9,,,),2))+IF((W20-1)<0,0,(_xlfn.XLOOKUP(V20,$D$3:$K$3,$D$10:$K$10,,,)*(W20-1))),0))","v":247.42999999995641}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Bridging Worksheet'!C17","v":"NSW"},null,null,{"$f":"IF('Bridging Worksheet'!F19=0,\n0,\nIFERROR(IF('Bridging Worksheet'!F19<=4000000,\n_xlfn.XLOOKUP('Bridging Worksheet'!F19,$C$4:$C$9,_xlfn.XLOOKUP(V21,$D$3:$K$3,$D$4:$K$9,,,),,1,),\nROUNDUP(('Bridging Worksheet'!F19/1000)*0.5*_xlfn.XLOOKUP(V21,$D$3:$K$3,$D$9:$K$9,,,),2))+IF((W21-1)<0,0,(_xlfn.XLOOKUP(V21,$D$3:$K$3,$D$10:$K$10,,,)*(W21-1))),0))","v":0}]
[]
[null,null,"BASE RATE",300]
[]
[]
[null,null,"GST ",1.1000000000000001,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Stamp duty",1,1.0900000000000001,1.1000000000000001,1.0900000000000001,1.1100000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,null,"No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["WA","RESI",null,null,null,null,null,null,null,"Commecial"]
[null,"                           DUTIABLE VALUE",null,"DUTY THRESHOLDS",null,null,null,null,null,"                                 DUTIABLE VALUE",null,null,"DUTY THRESHOLDS"]
[null,"$0 – $120,000",null,"$1.90 per $100 or part thereof",null,null,null,null,null,"$0 – $80,000",null,null,"$1.90 per $100 or part thereof "]
[null,"$120,001 – $150,000",null,"$2,280 + $2.85 per $100 or part thereof above $120,000",null,null,null,null,null,"$80,001 - $100,000 ",null,null,"$1,520 + $2.85 per $100 or part thereof above $80,000"]
[null,"$150,001 – $360,000",null,"$ 3,135 + $3.80 per $100 or part thereof above $150,000",null,null,null,null,null,"$100,001 – $250,000",null,null,"$2,090 + $3.80 per $100 or part thereof above $100,000"]
[null,"$360,001 – $725,000",null,"$11,115 + $4.75 per $100 or part thereof above $360,000",null,null,null,null,null,"$250,001 – $500,000",null,null,"$7,790 + $4.75 per $100 or part thereof above $250,000"]
[null,"$725,001 and upwards",null,"$28,453 + $5.15 per $100 or part thereof above $725,000",null,null,null,null,null,"$500,001 and upwards",null,null,"$19,665 + $5.15 per $100 or part thereof above $500,000"]