{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Cost Template"],"read":"whole","date_system":"1900"}

{"sheet":"Cost Template","index":0,"n_rows":45,"n_cols":11,"rows_kept":45,"merged":[[0,0,0,10],[1,0,1,11],[2,0,2,2],[2,3,2,9],[3,0,3,2],[3,3,3,9],[4,0,4,2],[4,3,4,9],[5,0,5,2],[6,0,6,10],[7,0,8,2],[7,3,8,3],[7,4,8,5],[7,6,7,10],[9,0,9,2],[10,0,10,2],[11,0,13,1],[11,10,13,10],[14,0,14,2],[14,4,14,5],[15,0,15,2],[15,4,15,5],[16,0,16,2],[16,4,16,5],[17,0,17,2],[17,4,17,5],[18,0,22,5],[20,6,20,9],[23,0,23,10],[24,0,24,1],[24,3,24,10],[25,0,25,1],[25,3,25,10],[26,0,26,1],[26,3,26,10],[27,0,27,1],[27,3,27,10],[28,0,28,1],[28,3,28,10],[29,0,29,1],[29,3,29,10],[30,0,30,1],[30,3,30,10],[31,0,31,1],[31,3,31,10],[32,0,33,10],[34,0,34,10],[35,0,35,3],[35,4,35,5],[36,0,36,3],[36,4,36,5],[37,0,37,2],[37,4,37,5],[37,6,37,8],[38,0,39,0],[38,1,38,3],[38,4,38,5],[38,6,38,8],[39,4,39,5],[39,6,39,8],[42,6,42,8],[42,9,42,10],[43,6,43,8],[43,9,43,10],[44,6,44,8],[44,9,44,10]]}
["APPENDIX C:- COST"]
["COMPLETE CELLS HIGHLIGHTED IN YELLOW ONLY"]
["Property Type:"]
["Property Address:"]
["Office Area m2"]
[]
["Proposal - Operating Cost (excl VAT)"]
["Description of Cost Items",null,null,"Monthly Cost per m2","Units",null,"Five Year Evaluation Calculations"]
[{"$nulls":6},"Year 1","Year 2","Year 3","Year 4","Total"]
["Rental Lease",{"$nulls":4},"m2",{"$f":"D10*E10*12","v":0},{"$f":"G10*(100%+$C26)","v":0},0,0,{"$f":"SUM(G10:J10)","v":0}]
["Operating Cost",{"$nulls":4},"m2",{"$f":"D11*E11*12","v":0},0,0,0,{"$f":"SUM(G11:J11)","v":0}]
["Parking",null,"Basement  ",null,null,"bays",0,0,0,0,{"$f":"SUM(G12:J14)","v":0}]
[null,null,"Shaded",null,null,"bays",0,{"$f":"G13*(100%+$C28)","v":0},{"$f":"H13*(100%+$C28)","v":0},{"$f":"I13*(100%+$C28)","v":0}]
[null,null,"Open",null,null,"bays",0,{"$f":"G14*(100%+$C28)","v":0},0,0]
["Rates & Taxes (where applicable)",{"$nulls":3},"per month",null,{"$f":"D15*12","v":0},0,0,0,{"$f":"SUM(G15:J15)","v":0}]
["Water (Estimated)",{"$nulls":3},"per month",null,{"$f":"D16*12","v":0},0,0,0,{"$f":"SUM(G16:J16)","v":0}]
["Electricty (Estimated)",{"$nulls":3},"per month",null,{"$f":"D17*12","v":0},0,0,0,{"$f":"SUM(G17:J17)","v":0}]
["Sewage (Estimated)",{"$nulls":3},"per month",null,{"$f":"D18*12","v":0},0,0,0,{"$f":"SUM(G18:J18)","v":0}]
["Total Operating Cost for 46 Months excluding escalation",{"$nulls":5},{"$f":"SUM(G10:G18)","v":0},{"$f":"SUM(H10:H18)","v":0},{"$f":"SUM(I10:I18)","v":0},{"$f":"SUM(J10:J18)","v":0},{"$f":"SUM(K10:K18)","v":0}]
[]
[]
[]
[]
["Escalation (% per annum)"]
["Description",null,"%","Note"]
["Rental Cost"]
["Operating Cost"]
["Parking"]
["Rates & Taxes (Estimated)"]
["Water (Estimated)"]
["Electricity (Estimated)"]
["Sewage (Estimated)"]
[]
[]
["Proposal - Capital Cost (excl VAT)"]
["Description of Cost Items"]
["Cost per square meter for the entire fit out",{"$nulls":5},{"$f":"E37*D5","v":0}]
[{"$nulls":3},"Sub-Total Capex",{"$f":"G37","v":0},null,"excl VAT"]
[null,"Tenant installation allowance "]
[{"$nulls":3},"Total Capital Cost",{"$f":"E38-E39","v":0},null,"excl VAT"]
[]
[]
[{"$nulls":6},"TOTAL COST OVER 46 MONTHS EXCLUDING VAT",null,null,{"$f":"K19+E40","v":0}]
[{"$nulls":6},"VAT",null,null,{"$f":"J43*0.15","v":0}]
[{"$nulls":6},"TOTAL COST OVER 46 MONTHS INCLUDING VAT",null,null,{"$f":"SUM(J43:J44)","v":0}]