{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Calculation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Calculation","index":0,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,7,0,9],[1,7,1,9],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8]]}
[null,null,null,"PAYG Withholding Variation - Rental Income & Deductions",null,null,null,"Client Name",null,null,null,null,null,"HIDE"]
[null,null,null,"Year Ended 30 June 2018",null,null,null,"Preparer Name"]
[]
[]
[null,null,null,null,"Property 1","Property 2","Property 3","Property 4","Property 5"]
[null,null,null,"Property Address"]
[null,null,null,"Ownership (%)",null,null,null,null,null,"Totals"]
[]
[null,null,null,"Assessable Income"]
[]
[null,null,null,"Weekly Rent"]
[null,null,null,"Projected Weeks"]
[null,null,null,"Gross Rent",{"$f":"E11*E12","v":0},{"$f":"F11*F12","v":0},{"$f":"G11*G12","v":0},{"$f":"H11*H12","v":0},{"$f":"I11*I12","v":0}]
[null,null,null,"Share of Gross Rent",{"$f":"E13*E7","v":0},{"$f":"F13*F7","v":0},{"$f":"G13*G7","v":0},{"$f":"H13*H7","v":0},{"$f":"I13*I7","v":0},{"$f":"SUM(E14:I14)","v":0}]
[]
[null,null,null,"Less Allowable Deductions"]
[]
[null,null,null,"Interest"]
[null,null,null,"Prepaid - Claim Ownership %"]
[null,null,null,"Other - Claim Ownership %"]
[null,null,null,"Jointly Held Properties - Claim 100%"]
[null,null,null,"Total Interest",{"$f":"SUM(E19:E21)","v":0},{"$f":"SUM(F19:F21)","v":0},{"$f":"SUM(G19:G21)","v":0},{"$f":"SUM(H19:H21)","v":0},{"$f":"SUM(I19:I21)","v":0}]
[null,null,null,"Share of Interest",{"$f":"(E19+E20)*E7+E21","v":0},{"$f":"(F19+F20)*F7+F21","v":0},{"$f":"(G19+G20)*G7+G21","v":0},{"$f":"(H19+H20)*H7+H21","v":0},{"$f":"(I19+I20)*I7+I21","v":0},{"$f":"SUM(E23:I23)","v":0}]
[]
[null,null,null,"Rates & Insurance"]
[null,null,null,"Rates -Council"]
[null,null,null,"Rates - Water"]
[null,null,null,"Insurance"]
[null,null,null,"Total Rates & Insurance",{"$f":"SUM(E26:E28)","v":0},{"$f":"SUM(F26:F28)","v":0},{"$f":"SUM(G26:G28)","v":0},{"$f":"SUM(H26:H28)","v":0},{"$f":"SUM(I26:I28)","v":0}]
[null,null,null,"Share of Rates & Insurance",{"$f":"E29*E7","v":0},{"$f":"F29*F7","v":0},{"$f":"G29*G7","v":0},{"$f":"H29*H7","v":0},{"$f":"I29*I7","v":0},{"$f":"SUM(E30:I30)","v":0}]
[]
[null,null,null,"Agent's Commission & Management Fees"]
[null,null,null,"Agent's Commission Rate (%)"]
[null,null,null,"Agent's Commission Payable",{"$f":"E13*E33","v":0},{"$f":"F13*F33","v":0},{"$f":"G13*G33","v":0},{"$f":"H13*H33","v":0},{"$f":"I13*I33","v":0}]
[null,null,null,"Management Fees"]
[null,null,null,"Total Agent & Management Fees",{"$f":"SUM(E34:E35)","v":0},{"$f":"SUM(F34:F35)","v":0},{"$f":"SUM(G34:G35)","v":0},{"$f":"SUM(H34:H35)","v":0},{"$f":"SUM(I34:I35)","v":0}]
[null,null,null,"Share of Agent & Management Fees",{"$f":"E36*E7","v":0},{"$f":"F36*F7","v":0},{"$f":"G36*G7","v":0},{"$f":"H36*H7","v":0},{"$f":"I36*I7","v":0},{"$f":"SUM(E37:I37)","v":0}]
[]
[null,null,null,"Repairs & Maintenance"]
[null,null,null,"Repairs & Maintenance"]
[null,null,null,"Share of Repairs & Maintenance",{"$f":"E40*E7","v":0},{"$f":"F40*F7","v":0},{"$f":"G40*G7","v":0},{"$f":"H40*H7","v":0},{"$f":"I40*I7","v":0},{"$f":"SUM(E41:I41)","v":0}]
[]
[null,null,null,"Capital Allowances"]
[null,null,null,"Decline in Value"]
[null,null,null,"Share of Capital Allowances",{"$f":"E44*E7","v":0},{"$f":"F44*F7","v":0},{"$f":"G44*G7","v":0},{"$f":"H44*H7","v":0},{"$f":"I44*I7","v":0},{"$f":"SUM(E45:I45)","v":0}]
[]
[null,null,null,"Capital Works"]
[null,null,null,"Building Write-Off"]
[null,null,null,"Share of Capital Works",{"$f":"E48*E7","v":0},{"$f":"F48*F7","v":0},{"$f":"G48*G7","v":0},{"$f":"H48*H7","v":0},{"$f":"I48*I7","v":0},{"$f":"SUM(E49:I49)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N51","v":"blank"}]
[null,null,null,"Other Expenses",null,null,null,null,null,null,null,null,null,{"$f":"N60","v":"blank"}]
[null,null,null,"Borrowing Costs",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(E52<>0,F52<>0,G52<>0,H52<>0,I52<>0),0,\"blank\")","v":"blank"}]
[null,null,null,"Land Tax",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(E53<>0,F53<>0,G53<>0,H53<>0,I53<>0),0,\"blank\")","v":"blank"}]
[null,null,null,"Postage & Petties",null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,"Bank Charges",null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,"Total Other Expenses",{"$f":"SUM(E52:E58)","v":0},{"$f":"SUM(F52:F58)","v":0},{"$f":"SUM(G52:G58)","v":0},{"$f":"SUM(H52:H58)","v":0},{"$f":"SUM(I52:I58)","v":0},null,null,null,null,{"$f":"IF(OR(E59<>0,F59<>0,G59<>0,H59<>0,I59<>0),0,\"blank\")","v":"blank"}]
[null,null,null,"Share of Other Expenses",{"$f":"E59*E7","v":0},{"$f":"F59*F7","v":0},{"$f":"G59*G7","v":0},{"$f":"H59*H7","v":0},{"$f":"I59*I7","v":0},{"$f":"SUM(E60:I60)","v":0},null,null,null,"blank"]
[]
[null,null,null,"Total Deductions",{"$f":"E23+E30+E37+E41+E45+E49+E60","v":0},0,0,0,0,0]
[null,null,null,"Taxable Income/(Loss)",{"$f":"E14-E62","v":0},0,0,0,0,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"blank\"","v":"blank"}]