{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Economies of scale tool","Stamp duty","Livestock capital","Land purchase tool","Purchase tool Livestock"],"not_rendered":{"charts":22,"images":2,"macros":0,"external_links":2,"defined_names":1,"comments":2,"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":"Economies of scale tool","index":0,"n_rows":106,"n_cols":12,"rows_kept":106,"cut":false,"hidden":false,"merged":[[50,1,51,11],[4,1,4,4],[46,1,48,11],[25,6,25,7],[37,1,38,4],[39,1,42,4],[33,6,33,11],[24,1,24,2],[4,6,4,7],[14,6,14,7]]}
[]
[]
[null,"Economies of scale tool"]
[]
[null,"The marginal benefit of increasing scale in the business",null,null,null,null,"Pasture fertiliser & cost on expansion"]
[null,null,"Existing","Expansion","% change",null,"Stocking rate on expansion area (DSE)",2000]
[null,"Area (ha)",1600,200,{"$f":"D7/C7","v":0.125},null,"Stocking rate on expansion area (DSE/ha)",{"$f":"H6/D7","v":10}]
[null,null,null,null,null,null,"Fertiliser rate (kg P/ marginal DSE)",0.8]
[null,"Administration",12000,{"$f":"C26","v":1000},{"$f":"D9/C9","v":8.3333333333333329E-2},null,"Fertiliser cost ($/t)",470]
[null,"Depreciation",12000,{"$f":"L43+(C10*C34)","v":600},{"$f":"D10/C10","v":0.05},null,"% Phosphorus in fertiliser",8.7999999999999995E-2]
[null,"Electricity and gas",5500,{"$f":"C27","v":0},{"$f":"D11/C11","v":0},null,"Application cost ($/t)",50]
[null,"Fertiliser - pasture",90000,{"$f":"H12","v":9454.5454545454559},{"$f":"D12/C12","v":0.10505050505050506},null,"Fertiliser cost spread",{"$f":"H13*H9+(H11*(H13))","v":9454.5454545454559}]
[null,"Fuel & lubricants - overhead",7500,{"$f":"H24+(C13*C34)","v":5991},{"$f":"D13/C13","v":0.79879999999999995},null,"Fertiliser required (tonnes)",{"$f":"H6*H8/H10/1000","v":18.181818181818183}]
[null,"Insurance",16000,{"$f":"C28","v":1000},6.25E-2]
[null,"Lime/gypsum",40000,{"$f":"C29","v":4000},0.1,null,"Travel costs due to expansion area"]
[null,"Materials",1000,{"$f":"C30","v":1000},1,null,"Distance to expansion area (km)",30]
[null,"Motor vehicles",5000,{"$f":"L42","v":0},{"$f":"D17/C17","v":0},null,"Fuel cost ($/L)",2]
[null,"Rates and rents",12000,2400,{"$f":"D18/C18","v":0.2},null,"Fuel efficiency (L/100km)",15]
[null,"R&M general",45000,{"$f":"C32","v":6000},{"$f":"D19/C19","v":0.13333333333333333},null,"Average speed (km/hr)",80]
[null,"Wages",165000,{"$f":"IF(C35=\"Yes\",H32,0)","v":0},{"$f":"D20/C20","v":0},null,"Trips/week",6]
[null,"Total overhead expenses",{"$f":"SUM(C9:C20)","v":411000},{"$f":"SUM(D9:D20)","v":31445.545454545456},{"$f":"D21/C21","v":7.6509842955098439E-2},null,"Distance (km/yr)",{"$f":"H16*2*H20*52","v":18720}]
[null,"Total overhead expenses ($/ha)",{"$f":"C21/C7","v":256.875},{"$f":"D21/D7","v":157.22772727272729},null,null,"Days travelling",{"$f":"H21/H19/8","v":29.25}]
[null,"Marginal benefit of scale ($/ha)",null,{"$f":"C22-D22","v":99.647272727272707},{"$f":"D23/C22","v":0.38792125635921249},null,"Percent of FTE travelling",{"$f":"SUM(H22)/240","v":0.121875}]
[null,null,null,null,null,null,"Fuel cost",{"$f":"H21/100*H18*H17","v":5616}]
[null,"Expected additional costs associated with expansion area"]
[null,"Administration",1000,null,null,null,"Additional labour costs on expansion area"]
[null,"Electricity & gas",0,null,null,null,"Labour unit","Input/output"]
[null,"Insurance",1000,null,null,null,"Days of work/year",75]
[null,"Lime & gypsum",4000,null,null,null,"Hourly rate (excluding on costs)",35]
[null,"Materials",1000,null,null,null,"Annual cost",{"$f":"H29*240*8","v":67200}]
[null,"Rates & rents",12000,null,null,null,"On costs (% hourly rate)",0.21]
[null,"Repairs & maintenance",6000,null,null,null,"Gross cost (incl on costs)",{"$f":"H29*H28*8*(1+H31)","v":25410}]
[]
[null,"How much more work will existing plant do?",0.05,null,null,null,"Additional depreciation cost associated with additional plant and equipment required for expansion area"]
[null,"Will you need to pay for additional labour to conduct the work?","No",null,null,null,"Additional vehicles & plant","Toyota Hilux","Plant 2","Plant 3","Plant 4","Total"]
[null,null,null,null,null,null,"Purchase value",null,null,null,null,{"$f":"SUM(H36:K36)","v":0}]
[null,null,null,null,null,null,"Years owned"]
[null,{"$f":"IF(D23<0,\"You achieve diseconomies of scale with this expansion\",\"You achieve economies of scale with this expansion\")","v":"You achieve economies of scale with this expansion"},null,null,null,null,"Sale value",null,null,null,null,{"$f":"SUM(H38:K38)","v":0}]
[null,null,null,null,null,null,"Repairs ($/year)",null,null,null,null,0]
[null,{"$f":"\"For every additional hectare in this expansion your operating profit will \"&IF(D23<0,\"decrease by\",\"increase by\") &TEXT(ABS(D23),\" $0\")&\"/ha.\"","v":"For every additional hectare in this expansion your operating profit will increase by $100/ha."},null,null,null,null,"Registration costs ($/year)",null,null,null,null,0]
[null,null,null,null,null,null,"Insurance costs ($/year)",null,null,null,null,{"$f":"SUM(H41:K41)","v":0}]
[null,null,null,null,null,null,"Motor vehicle costs ($/year)",{"$f":"SUM(H39:H41)","v":0},{"$f":"SUM(I39:I41)","v":0},0,0,{"$f":"SUM(H42:K42)","v":0}]
[null,null,null,null,null,null,"Depreciation ($/year)",{"$f":"IF(OR(H36=0,H36=\"\"),\"\",SLN(H36,H38,H37))","v":""},{"$f":"IF(OR(I36=0,I36=\"\"),\"\",SLN(I36,I38,I37))","v":""},{"$f":"IF(OR(J36=0,J36=\"\"),\"\",SLN(J36,J38,J37))","v":""},{"$f":"IF(OR(K36=0,K36=\"\"),\"\",SLN(K36,K38,K37))","v":""},{"$f":"SUM(H43:K43)","v":0}]
[]
[]
[]
[null,"Purpose of the Economies of scale from expansion tool: This tool calculates the value of the economies of scale or diseconomies of scale generated when expanding the business. When expanding or intensifying economies of scale can generate high value to a business manager by increasing the operating profit on every additional hectare of land. The extent of the economies of scale differ by business circumstance this tool calculates the extent of the value and allows the user to sensitise inputs to establish what factors make a difference to the outputs.  "]
[]
[]
[]
[null,"Disclaimer: This decision support tool is produced by Agrista. The contents do not constitute management or business advice and should not be relied on as such. Before taking any action in relation to a matter described in this decision support tool, you should seek independent advice from a qualified professional. Agrista accepts no responsibility for any loss or damage resulting from reliance on the contents of this tool."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Additional depreciation cost associated with additional plant and equipment required"]
[null,"Additional vehicles & plant","Purchase value","Years owned","Sale value"]
[null,"Toyota Hilux",30000,5,5000,"Repairs ($/yr)","Depreciation ($/yr)"]
[null,"Item 2",null,null,null,1000,{"$f":"IF(OR(C95=0,C95=\"\"),\"\",SLN(C95,E95,D95))","v":5000}]
[null,"Item 3",null,null,null,null,""]
[null,"Item 4",null,null,null,null,""]
[null,"Item 5",null,null,null,null,""]
[null,"Item 6",null,null,null,null,""]
[null,"Item 7",null,null,null,null,""]
[null,"Item 8",null,null,null,null,""]
[null,"Item 9",null,null,null,null,""]
[null,"Item 10",null,null,null,null,""]
[null,"Total",null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"SUM(G96:G105)","v":5000}]

{"sheet":"Stamp duty","index":1,"n_rows":80,"n_cols":8,"rows_kept":80,"cut":false,"hidden":true,"merged":[[63,6,63,7],[74,6,74,7],[75,6,75,7],[73,6,73,7],[0,0,0,2],[12,6,12,7],[21,6,21,7],[30,6,30,7],[43,6,43,7]]}
["NSW"]
[0,1.2500000000000001E-2,0,null,null,null,"NSW"]
[14000,1.4999999999999999E-2,175,null,null,null,"Dutiable Value","Duty Payable"]
[30000,1.7500000000000002E-2,415,null,null,null,"$0 - $14,000","1.25% of dutiable value"]
[80000,3.5000000000000003E-2,1290,null,null,null,"$14,001 - $30,000","$175 + 1.5% of dutiable value over $14,000"]
[300000,4.4999999999999998E-2,8990,null,null,null,"$30,001 - $80,000","$415 + 1.75% of dutiable value over $30,000"]
[1000000,5.5E-2,40490,null,null,null,"$80,001 - $300,000","$1,290 + 3.5% of dutiable value over $80,000"]
[3000000,7.0000000000000007E-2,150490,null,null,null,"$300,001 - $1 million","$8,990 + 4.5% of dutiable value over $300,000"]
[null,null,null,null,null,null,"$1 million - $3 million","$40,490 + 5.5% of dutiable value over $1 million"]
[null,null,null,null,null,null,"Over $3 million","$150,490 + 7% of dutiable value over $3 million"]
[null,null,null,"Land purchase price",1000000]
[null,null,null,"Stamp duty rate",{"$f":"VLOOKUP($E$11,rT,3)+($E$11-VLOOKUP($E$11,rT,1))*VLOOKUP($E$11,rT,2)","v":40490},null,"Victoria Stamp Duty Rates"]
[null,null,null,null,null,null,"The follow values are for a Principal place of Residence (PPR). Other values are applicable for non-PPR purchases."]
[null,null,null,null,null,null,"Dutiable Value","Duty Payable"]
[null,null,null,null,null,null,"$0 - $25,000","1.4% of dutiable value (PPR concession not available)"]
[null,null,null,null,null,null,"$25,001 - $130,000","$350 + 2.4% of dutiable value over $25,000 (PPR concession not available)"]
[null,null,null,null,null,null,"$130,001 - $440,000","$2,870 + 5% of dutiable value over $130,000"]
[null,null,null,null,null,null,"$440,001 - $550,000","$18,370 + 6% of dutiable value over $440,000"]
[null,null,null,null,null,null,"$550,001 - $960,000","$2,870 + 6% of dutiable value over $130,000 (PPR concession not available)"]
[null,null,null,null,null,null,"Over $960,000","5.5% of dutiable value (PPR concession not available)"]
[]
[null,null,null,null,null,null,"Queensland Stamp Duty Rates"]
[]
[null,null,null,null,null,null,"Dutiable Value","Duty Payable"]
[null,null,null,null,null,null,"$0 - $5,000","No stamp duty payable"]
[null,null,null,null,null,null,"$5,001 - $105,000","1.5% of dutiable value over $5000"]
[null,null,null,null,null,null,"$105,001 - $480,000","$1,500 + 3.5% of dutiable value over $105,000"]
[null,null,null,null,null,null,"$480,001 - $980,000","$14,625 + 4.5% of dutiable value over $480,000"]
[null,null,null,null,null,null,"Over $980,000","$37,125 + 5.25% of dutiable value over $980,000"]
[]
[null,null,null,null,null,null,"South Australia Stamp Duty Rates"]
[]
[null,null,null,null,null,null,"Dutiable Value","Duty Payable"]
[null,null,null,null,null,null,"$0 - $12,000","1% of dutiable value"]
[null,null,null,null,null,null,"$12,001 - $30,000","$120 + 2% of dutiable value over $12,000"]
[null,null,null,null,null,null,"$30,001 - $50,000","$480 + 3% of dutiable value over $30,000"]
[null,null,null,null,null,null,"$50,001 - $100,000","$1080 + 3.5% of dutiable value over $50,000"]
[null,null,null,null,null,null,"$100,001 - $200,000","$2830 + 4% of dutiable value over $100,000"]
[null,null,null,null,null,null,"$200,001 - $250,000","$6830 + 4.25% of dutiable value over $200,000"]
[null,null,null,null,null,null,"$250,001 - $300,000","$8955 + 4.75% of dutiable value over $250,000"]
[null,null,null,null,null,null,"$300,001 - $500,000","$11,330 + 5% of dutiable value over $300,000"]
[null,null,null,null,null,null,"Over $500,000","$21,330 + 5.5% of dutiable value over $500,000"]
[]
[null,null,null,null,null,null,"Western Australia Stamp Duty Rates"]
[]
[null,null,null,null,null,null,"Dutiable Value","Duty Payable"]
[null,null,null,null,null,null,"$0 - $120,000","1.9% of dutiable value"]
[null,null,null,null,null,null,"$120,001 - $150,000","$2280 + 2.85% of dutiable value over $120,000"]
[null,null,null,null,null,null,"$150,001 - $360,000","$3135 + 3.8% of dutiable value over $150,000"]
[null,null,null,null,null,null,"$360,001 - $725,000","$11,115 + 4.75% of dutiable value over $360,000"]
[null,null,null,null,null,null,"Over $725,000","$28,435 + 5.15% of dutiable value over $725,000"]
[]
[null,null,null,null,null,null,"Tasmania Stamp Duty Rates"]
[]
[null,null,null,null,null,null,"Dutiable Value","Duty Payable"]
[null,null,null,null,null,null,"$0 - $1,300",20]
[null,null,null,null,null,null,"$1,301 - $10,000","1.5% of dutiable value"]
[null,null,null,null,null,null,"$10,001 - $30,000","$150 + 2% of dutiable value over $10,000"]
[null,null,null,null,null,null,"$30,001 - $75,000","$550 + 2.5% of dutiable value over $30,000"]
[null,null,null,null,null,null,"$75,001 - $150,000","$1675 + 3% of dutiable value over $75,000"]
[null,null,null,null,null,null,"$150,001 - $225,000","$3925 + 3.5% of dutiable value over $150,000"]
[null,null,null,null,null,null,"Over $225,000","$6,550 + 4% of dutiable value over $225,000"]
[]
[null,null,null,null,null,null,"Australian Capital Territory Stamp Duty Rates"]
[]
[null,null,null,null,null,null,"Dutiable Value","Duty Payable"]
[null,null,null,null,null,null,"$0 - $100,000","2% of dutiable value or $20, whichever is greater"]
[null,null,null,null,null,null,"$100,001 - $200,000","$2000 + 3.5% of dutiable value over $100,000"]
[null,null,null,null,null,null,"$200,001 - $300,000","$5500 + 4% of dutiable value over $200,000"]
[null,null,null,null,null,null,"$300,001 - $500,000","$9500 + 5.5% of dutiable value over $300,000"]
[null,null,null,null,null,null,"$500,001 - $1,000,000","$20,500 + 5.75% of dutiable value over $500,000"]
[null,null,null,null,null,null,"Over $1 million","$49,250 + 6.75% of dutiable value over $1 million"]
[]
[null,null,null,null,null,null,"Northern Territory Stamp Duty Rates"]
[null,null,null,null,null,null,"For property values up to $525,000 the following formula is used:"]
[null,null,null,null,null,null,"Duty payable = (0.06571441 x V2) + 15V where V = (dutiable value) / 1000."]
[null,null,null,null,null,null,"Dutiable Value","Duty Payable"]
[null,null,null,null,null,null,"$0 - $525,000","See above formula"]
[null,null,null,null,null,null,"$525,001 - $3,000,000","4.95% of dutiable value"]
[null,null,null,null,null,null,"Over $3 million","5.45% of dutiable value"]

{"sheet":"Livestock capital","index":2,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Ewes","Lambs","Rams",null,null,"PTIC cows","Yearling","Bulls",null,null,"Ewes","Lambs","Rams"]
[null,"DSE/hd",1.5,1.9,1.25,null,"DSE/hd",14,9,14,null,"DSE/hd",1.5,1,1.25]
[null,"% yr ",1,0.25,1,null,"% yr ",1,0.5,1,null,"% yr ",1,1,1]
[null,"Price ($/hd)",130,null,1000,null,"Price ($/hd)",1800,{"$f":"250*3.3","v":825},5000,null,"Price ($/hd)",120,null,1000]
[null,"Weaning/joining %",null,1.1000000000000001,0.01,null,"Weaning/joining %",null,1,0.02,null,"Weaning/joining %",null,0.8,0.01]
[null,"Number head",1,{"$f":"C8*D7","v":1.1000000000000001},{"$f":"C8*E7","v":0.01},null,"Number head",1,{"$f":"H8*I7","v":1},{"$f":"H8*J7","v":0.02},null,"Number head",1,{"$f":"M8*N7","v":0.8},{"$f":"M8*O7","v":0.01}]
[null,"AA DSE",{"$f":"C8*C5*C4","v":1.5},{"$f":"D8*D5*D4","v":0.52249999999999996},{"$f":"E8*E5*E4","v":1.2500000000000001E-2},null,"AA DSE",{"$f":"H8*H5*H4","v":14},{"$f":"I8*I5*I4","v":4.5},{"$f":"J8*J5*J4","v":0.28000000000000003},null,"AA DSE",{"$f":"M8*M5*M4","v":1.5},{"$f":"N8*N5*N4","v":0.8},{"$f":"O8*O5*O4","v":1.2500000000000001E-2}]
[null,"Total DSE",{"$f":"SUMPRODUCT(C4:E4,C8:E8,C5:E5)","v":2.0350000000000001},null,null,null,"Total DSE",{"$f":"SUMPRODUCT(H4:J4,H8:J8,H5:J5)","v":18.78},null,null,null,"Total DSE",{"$f":"SUMPRODUCT(M4:O4,M8:O8,M5:O5)","v":2.3125}]
[null,"Capital cost",{"$f":"SUMPRODUCT(C8:E8,C6:E6)","v":140},null,null,null,"Capital cost",{"$f":"SUMPRODUCT(H8:J8,H6:J6)","v":2725},null,null,null,"Capital cost",{"$f":"SUMPRODUCT(M8:O8,M6:O6)","v":130}]
[null,"Capital cost ($/DSE)",{"$f":"C11/SUM(C9:E9)","v":68.796068796068795},null,null,null,"Capital cost ($/DSE)",{"$f":"H11/SUM(H9:J9)","v":145.10117145899892},null,null,null,"Capital cost ($/DSE)",{"$f":"M11/SUM(M9:O9)","v":56.216216216216218}]

{"sheet":"Land purchase tool","index":3,"n_rows":102,"n_cols":26,"rows_kept":102,"cut":false,"hidden":true,"merged":[[1,0,1,3]]}
[]
["Expansion tool (fixed area) - can I afford to expand?",null,null,null,null,null,null,null,null,null,null,null,"Asking price ($/ac)",1000,null,null,null,null,null,null,null,null,null,null,"Tom","LU 1"]
["Area owned (hectares)",1000,null,200,null,{"$f":"SUM(B3,D3)","v":1200},null,null,null,null,null,null,"Purchase price",{"$f":"N39*N2","v":2220000},null,null,null,null,null,null,"Area (ha)",{"$f":"O39","v":898.42169162282471},null,"Distance (km)",30,60]
["Additional area (mgd or leased)",0,null,null,null,0,null,"Tax rate",0.3,null,null,null,"Land price ($/ha)",{"$f":"N3/O39","v":2471},null,null,null,null,null,null,"Potential SR DSE",{"$f":"N5","v":7762.0396600566564},null,"Trips/wk",2,4]
["Total area managed",{"$f":"SUM(B3:B4)","v":1000},null,{"$f":"SUM(D3:D4)","v":200},null,{"$f":"SUM(B5,D5)","v":1200},null,"Years",10,null,null,null,"Farm stocking rate ($/ha)",{"$f":"R39","v":7762.0396600566564},null,null,null,null,null,null,"Potential SR DSE/ha",{"$f":"V4/V3","v":8.6396396396396398},null,"Distance (km/yr)",{"$f":"Y3*2*Y4*52","v":6240},{"$f":"Z3*2*Z4*52","v":24960}]
["Bank interest rate",0.06,null,6.5000000000000002E-2,null,null,null,"IRR",{"$f":"IRR(C63:C103)","v":0.11720318718508138},null,null,null,"Land price ($/DSE)",{"$f":"N3/N5","v":286.00729927007302},null,null,null,null,null,null,"Fertiliser application cost",{"$f":"V8/1000*V12","v":28225.59876384239},null,"Av speed (km/hr)",80,80]
["Whole farm income",{"$f":"SUM(B8:B10)","v":920057.64},0,{"$f":"B13*D3*(1+C7)","v":184011.52799999999},null,{"$f":"SUM(B7,D7)","v":1104069.1680000001},null,"NPV",{"$f":"C63+NPV(10%,C64:C93)","v":53900.629736115952},null,null,null,null,{"$f":"N5/O23","v":8.639639639639638},null,null,null,null,null,null,"Total kg P",{"$f":"V8*V15","v":6209.6317280453259},null,"Days travelling",{"$f":"Y5/Y6/8","v":9.75},{"$f":"Z5/Z6/8","v":39}]
["Enterprise expenses",293501,0,{"$f":"B14*D3*(1+C8)","v":58700.2},null,{"$f":"SUM(B8,D8)","v":352201.2},null,null,null,null,null,null,null,"Ewes","Lambs","Rams",null,null,null,null,"Total kg SSP",{"$f":"S39","v":70563.996909605979},null,"Percent of FTE travelling",{"$f":"SUM(Y7)/240","v":4.0625000000000001E-2},{"$f":"SUM(Z7)/240","v":0.16250000000000001}]
["Overhead expenses",323500,null,50000,null,{"$f":"SUM(B9,D9)","v":373500},null,null,null,null,null,null,"DSE/hd",1.5,1.9,1.25,null,null,null,null,"Cost ($/ha)",{"$f":"V6/V3","v":31.41687141687142},null,"Fuel",1.5,1.5]
["Profit (EBIT)",{"$f":"B24*B23","v":303056.64000000001},null,{"$f":"D7-SUM(D8:D9)","v":75311.327999999994},null,{"$f":"SUM(B10,D10)","v":378367.96799999999},null,"Rate of capital gain",0.06,null,null,null,"% yr ",1,0.25,1,null,null,null,null,"Kg P/ha",{"$f":"V7/V3","v":6.9117117117117122},null,"Km/L",10,10]
[null,null,null,null,null,null,null,"On costs (stamp dty/legals)",{"$f":"+(8990+(4.5%*((D20)-300000)))+12000","v":97490},null,null,null,"Price ($/hd)",130,null,800,null,null,null,null,"Kg SSP/ha",{"$f":"V8/V3","v":78.542178542178547},null,"Fuel cost",{"$f":"Y5/Y10*Y9","v":936},{"$f":"Z5/Z10*Z9","v":3744}]
[null,null,null,null,null,null,null,"% yr overdraft required",0.75,null,null,null,"Number head",3800,{"$f":"N12*O13","v":4180},{"$f":"N12*P13","v":38},null,null,null,null,"Fertiliser cost ($/t)",400]
["Income ($/ha mgd)",{"$f":"SUM(B14:B16)","v":920.05763999999999},null,{"$f":"D7/$D$3","v":920.05763999999999},null,{"$f":"F7/$F$5","v":920.05764000000011},null,"Additional start up costs",100000,null,null,null,"Weaning/joining %",null,1.1000000000000001,0.01,null,null,null,null,"Fertiliser rate (kgP/DSE)",0.8]
["Enterprise costs ($/ha mgd)",{"$f":"B8/B3","v":293.50099999999998},null,{"$f":"D8/$D$3","v":293.50099999999998},null,{"$f":"F8/$F$5","v":293.50100000000003},null,null,null,null,null,null,"AA DSE",{"$f":"N12*N10*N9","v":5700},{"$f":"O12*O10*O9","v":1985.5},{"$f":"P12*P10*P9","v":47.5},null,null,null,null,"Cost ($/kg P)",{"$f":"V12/1000/8.8%","v":4.545454545454545}]
["Overhead expenses ($/ha mgd)",{"$f":"B9/B3","v":323.5},null,{"$f":"D9/D3","v":250},null,{"$f":"F9/$F$5","v":311.25},null,null,null,null,null,null,"Total DSE",{"$f":"SUMPRODUCT(N9:P9,N12:P12,N10:P10)","v":7733},null,null,null,null,null,null,"%P in SSP",8.7999999999999995E-2]
["Profit EBIT($/ha mgd)",{"$f":"B10/B3","v":303.05664000000002},null,{"$f":"D13-SUM(D14,D15)","v":376.55664000000002},null,{"$f":"F10/$F$5","v":315.30664000000002},null,null,null,null,null,null,"Capital cost",{"$f":"SUMPRODUCT(N12:P12,N11:P11)","v":524400}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Capital cost ($/DSE)",{"$f":"N16/SUM(N14:P14)","v":67.813267813267814}]
[null,"Existing business",null,"Proposed purchase",null,"Existing plus proposed",null,null,null,null,null,null,"Description",null,"Area (ha)","Land class rating","DSE/ha","Area (% total)"]
["Lease cost ($)",null,null,null,null,null,null,null,null,null,null,null,"Creek Flats",null,{"$f":"SUMIF($P$27:$P$38,$P19,$O$27:$O$38)","v":32.375556454876566},1,15,{"$f":"$O19/$O$23","v":3.6036036036036029E-2},null,null,"Fertiliser",{"$f":"V6","v":28225.59876384239}]
["Land value (owned)",6340224,null,2000000,null,{"$f":"SUM(B20,D20)","v":8340224},null,null,null,null,null,null,"Undulating Granite",null,{"$f":"SUMIF($P$27:$P$38,$P20,$O$27:$O$38)","v":250.91056252529341},2,10,{"$f":"$O20/$O$23","v":0.27927927927927926},null,null,"Depreciation",{"$f":"V29*12%","v":3600}]
["Land value other",{"$f":"B20/B3*B4","v":0},null,null,null,{"$f":"SUM(B21,D21)","v":0},null,null,null,null,null,null,"Granite Hills",null,{"$f":"SUMIF($P$27:$P$38,$P21,$O$27:$O$38)","v":538.24362606232296},3,8,0.59909909909909909,null,null,"Fuel and oil",{"$f":"SUM(Y11:Z11)*1.1","v":5148}]
["Non-land asset value",1236192,null,554400,null,{"$f":"SUM(B22,D22)","v":1790592},null,null,null,null,null,null,"Steep Granite Hills",null,{"$f":"SUMIF($P$27:$P$38,$P22,$O$27:$O$38)","v":76.891946580331847},4,6,8.5585585585585572E-2,null,null,"Labour unit (incl sup+WC)",{"$f":"70000*1.21","v":84700}]
["Total value of assets managed",{"$f":"SUM(B20:B22)","v":7576416},null,{"$f":"D20+D22","v":2554400},null,{"$f":"SUM(F20:F22)","v":10130816},null,null,null,null,null,null,null,null,{"$f":"SUM(O19:O22)","v":898.42169162282482},null,null,1,null,null,"Rates and rents",3500]
["Return on assets managed",0.04,null,{"$f":"D10/D23","v":2.9482981522079548E-2},null,{"$f":"F10/F23","v":3.7348222295222812E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vehicle expenses",2500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total marginal Overheads",{"$f":"SUM(V19:V24)","v":127673.5987638424}]
[null,"Existing business",null,"Proposed expansion",null,"Existing plus proposed",null,null,null,null,null,null,"Paddock","Acres","Ha","Rating","SR DSE/ha","DSE/pdk","SSP rate (kg/ha)"]
["Equity",{"$f":"(B28-B31)/B28","v":0.85481261852569868},null,{"$f":"D28/D23","v":7.829627309740057E-3},null,{"$f":"F28/F23","v":0.74983258999077662},null,null,null,null,null,null,"Hill",400,{"$f":"N27/2.471","v":161.87778227438284},3,{"$f":"VLOOKUP(P27,$P$19:$Q$22,2,FALSE)","v":8},{"$f":"VLOOKUP(P27,$P$19:$Q$22,2,FALSE)*O27","v":1295.0222581950627},{"$f":"Q27*$V$13/$V$15","v":72.727272727272734}]
["Value of owned assets",{"$f":"B20+B22","v":7576416},null,20000,null,{"$f":"B28+D28","v":7596416},null,null,null,null,null,null,"Days Flat",300,{"$f":"N28/2.471","v":121.40833670578712},2,{"$f":"VLOOKUP(P28,$P$19:$Q$22,2,FALSE)","v":10},1214.0833670578713,90.909090909090921]
["Value of other farming assets",{"$f":"B21","v":0},null,null,null,null,null,null,null,null,null,null,"Dogtrap",340,137.59611493322541,3,8,1100.7689194658033,72.727272727272734,null,"Vehicles",30000]
["Operating capital",{"$f":"SUM(B8:B9)","v":617001},null,{"$f":"SUM(D14,D15)*D3","v":108700.2},null,{"$f":"B30+D30","v":725701.2},null,null,null,null,null,null,"Walters",200,80.938891137191419,3,8,647.51112909753135,72.727272727272734]
["Net liabilities",{"$f":"1100000","v":1100000},null,{"$f":"D23-D28+D30+I11+I13","v":2840590.2},null,{"$f":"SUM(B31:D31)","v":3940590.2},null,null,null,null,null,null,"Pines",120,48.563334682314853,4,6,291.3800080938891,54.545454545454554]
["Annual interest and lease costs",{"$f":"(((B30*I12)+(B31-B30))*$B$6)+B19","v":56744.985000000001},null,{"$f":"(((D30*I12)+(D31-D30))*$D$6)+D19","v":182871.98475},null,{"$f":"SUM(B32:D32)","v":239616.96974999999},null,null,null,null,null,null,"Rough",70,28.328611898016995,4,6,169.97167138810198,54.545454545454554]
["Interest cover",{"$f":"B10/B32","v":5.3406770659997536},null,{"$f":"D10/D32","v":0.41182539853196398},null,{"$f":"F10/F32","v":1.5790533049256208},null,null,null,null,null,null,"Dougs",100,40.46944556859571,2,10,404.69445568595711,90.909090909090921]
["Profit after interest and lease",{"$f":"B10-B32","v":246311.65500000003},null,{"$f":"D10-D32","v":-107560.65675000001},null,{"$f":"F10-F32","v":138750.99825},null,null,null,null,null,null,"Gibbons",120,48.563334682314853,3,8,388.50667745851882,72.727272727272734]
["Tax",{"$f":"((B10*$I$4)-(B32*$I$4))","v":73893.496499999994},null,{"$f":"((D10*$I$4)-(D32*$I$4))","v":-32268.197025000001},null,{"$f":"IF(((F10*$I$4)-(F32*$I$4))<0,0,((F10*$I$4)-(F32*$I$4)))","v":41625.299474999993},null,null,null,null,null,null,"Willows",120,48.563334682314853,3,8,388.50667745851882,72.727272727272734]
["Profit after interest and tax",{"$f":"B34-B35","v":172418.15850000002},null,{"$f":"D34-D35","v":-75292.459725000008},null,{"$f":"F34-F35","v":97125.698775000012},null,null,null,null,null,null,"Muddy Springs",150,60.704168352893561,3,8,485.63334682314849,72.727272727272734]
["Provisioning for capital expenditure",100000,null,20000,null,{"$f":"SUM(B37,D37)","v":120000},null,null,null,null,null,null,"Bakers",220,89.032780250910562,2,10,890.3278025091056,90.909090909090921]
["Cash after CAPEX",{"$f":"B36-B37","v":72418.15850000002},null,{"$f":"D36-D37","v":-95292.459725000008},null,-22874.301224999988,null,null,null,null,null,null,"River",80,32.375556454876566,1,15,485.63334682314849,136.36363636363637]
["Year 1 value of capital gain",{"$f":"B20*I10","v":380413.44},null,{"$f":"D20*I10","v":120000},null,{"$f":"SUM(B39:D39)","v":500413.44},null,null,null,null,null,null,null,{"$f":"SUM(N27:N38)","v":2220},{"$f":"SUM(O27:O38)","v":898.42169162282471},null,null,{"$f":"SUM(R27:R38)","v":7762.0396600566564},{"$f":"SUMPRODUCT(S27:S38,O27:O38)","v":70563.996909605979}]
["Total wealth created",{"$f":"SUM(B36,B39)","v":552831.59850000008},null,{"$f":"D39+D36","v":44707.540274999992},null,{"$f":"F39+F36","v":597539.138775}]
["Return on equity",{"$f":"B40/B28","v":7.2967429256788438E-2},null,null,null,{"$f":"F40/F28","v":7.866066560533283E-2}]
[]
["Will the expansion opportunity:",null,null,"Year 1 amount:"]
["Reduce equity?",null,{"$f":"IF(F27<$B27,\"Yes\",\"No\")","v":"Yes"},{"$f":"B27-F27","v":0.10498002853492205}]
["Increase debt?",null,{"$f":"IF(D31>0,\"Yes\",\"No\")","v":"Yes"},{"$f":"D31","v":2840590.2},null,null,"Crop","Wheat","Canola","Barley","Wtd av"]
["Increase annual interest costs?",null,{"$f":"IF(D31>0,\"Yes\",\"No\")","v":"Yes"},{"$f":"D32","v":182871.98475},null,null,"Area (% total)",0.33,0.33,0.33]
["Increase profit (EBIT)?",null,{"$f":"IF(D10>0,\"Yes\",\"No\")","v":"Yes"},{"$f":"D10","v":75311.327999999994},null,null,"Area (ha)",{"$f":"100*H46","v":33},{"$f":"100*I46","v":33},33,{"$f":"SUM(H47:J47)","v":99}]
["Increase profit after interest and tax?",null,{"$f":"IF(D36>=0,\"Yes\",\"No\")","v":"No"},{"$f":"D36","v":-75292.459725000008},null,null,"Yield (t/ha)",3,1.5,3.3]
["Increase wealth?",null,{"$f":"IF(D40>=0,\"Yes\",\"No\")","v":"Yes"},{"$f":"D40","v":44707.540274999992},null,null,"Price ($/t)",260,460,230,{"$f":"SUMPRODUCT(H49:J49,$H$46:$J$46)","v":313.5}]
["Marginal return on equity",null,null,{"$f":"D40/D28","v":2.2353770137499995},null,null,"Income ($/ha)",{"$f":"H48*H49","v":780},{"$f":"I48*I49","v":690},759,{"$f":"SUMPRODUCT(H50:J50,$H$46:$J$46)","v":735.57}]
[null,null,null,null,null,null,"Ent exp ($/ha)",350,395,335,{"$f":"SUMPRODUCT(H51:J51,$H$46:$J$46)","v":356.4}]
["Degree of operating leverage",null,null,{"$f":"((D10+D39)+(D15*D3))/(D10+D39)","v":1.2560015361730581}]
["Degree of financial leverage",null,null,{"$f":"D40/(D40-D32)","v":-0.32358209411169842}]
["Degree of operating leverage",null,null,{"$f":"D52*D53","v":-0.40641960728238824}]
[]
["Operating leverage",null,null,{"$f":"(D10+D30-(B14*D3))/D10","v":1.6639107466010956}]
[]
["Total DSE managed",{"$f":"'[1]Wool Flock'!$G$75+'[1]DP Flock'!$G$77","v":20076.277104866844},null,{"$f":"N5","v":7762.0396600566564}]
["Income ($/DSE)",{"$f":"B7/B58","v":45.828100259532768}]
["Enterprise expenses ($/DSE)",{"$f":"B8/B58","v":14.619294128434309}]
[]
[null,"Year","Equity cashflow","Cumulative equity cashflow",null,"Whole farm cash flow","Cumulative whole farm liabilities","Gross land value","Equity"]
[null,0,{"$f":"-D28","v":-20000},{"$f":"C63","v":-20000},null,{"$f":"-F31","v":-3940590.2},{"$f":"IF(F63=\"\",\"\",F63)","v":-3940590.2},{"$f":"IF(G63=\"\",\"\",F20)","v":8340224},{"$f":"(H63+$F$22+G63)/(H63+$F$22)","v":0.61102933860411635}]
[null,{"$f":"IF(B63=\"\",\"\",IF(B63+1<=$I$5,B63+1,\"\"))","v":1},{"$f":"IF($B64=\"\",\"\",$D$38+IF($B64=$I$5,($D$20*(1+$I$10)^$B64)+$D$30+$D$22-($D$23-$D$28),0))","v":-95292.459725000008},{"$f":"IF(B64=\"\",\"\",D63+C64)","v":-115292.45972500001},null,{"$f":"IF($B64=\"\",\"\",$F$38+IF($B64=$I$5,($D$20*(1+$I$10)^$B64)+$D$30+$D$22-($D$23-$D$28),0))","v":-22874.301224999988},{"$f":"IF(F64=\"\",\"\",G63+F64)","v":-3963464.5012250002},{"$f":"IF(G64=\"\",\"\",$F$20*(1+$I$10)^B64)","v":8840637.4400000013},{"$f":"(H64+$F$22+G64)/(H64+$F$22)","v":0.6271866275115402}]
[null,{"$f":"IF(B64=\"\",\"\",IF(B64+1<=$I$5,B64+1,\"\"))","v":2},{"$f":"IF($B65=\"\",\"\",$D$38+IF($B65=$I$5,($D$20*(1+$I$10)^$B65)+$D$30+$D$22-($D$23-$D$28),0))","v":-95292.459725000008},{"$f":"IF(B65=\"\",\"\",D64+C65)","v":-210584.91945000002},null,{"$f":"IF($B65=\"\",\"\",$F$38+IF($B65=$I$5,($D$20*(1+$I$10)^$B65)+$D$30+$D$22-($D$23-$D$28),0))","v":-22874.301224999988},{"$f":"IF(F65=\"\",\"\",G64+F65)","v":-3986338.8024500003},{"$f":"IF(G65=\"\",\"\",$F$20*(1+$I$10)^B65)","v":9371075.6864000019},0.64285455234371669]
[null,3,-95292.459725000008,-305877.37917500001,null,-22874.301224999988,-4009213.1036750004,9933340.2275840025,0.65803170592865201]
[null,4,-95292.459725000008,-401169.83890000003,null,-22874.301224999988,-4032087.4049000004,10529340.641239043,0.67271838878378121]
[null,5,-95292.459725000008,-496462.29862500005,null,-22874.301224999988,-4054961.7061250005,11161101.079713387,0.68691647638899]
[null,6,-95292.459725000008,-591754.75835000002,null,-22874.301224999988,-4077836.0073500006,11830767.144496189,0.70062928639557387]
[null,7,-95292.459725000008,-687047.21807499998,null,-22874.301224999988,-4100710.3085750006,12540613.173165964,0.71386144716891964]
[null,8,-95292.459725000008,-782339.67779999995,null,-22874.301224999988,-4123584.6098000007,13293049.963555919,0.72661876887802501]
[null,9,-95292.459725000008,-877632.13752499991,null,-22874.301224999988,-4146458.9110250007,14090632.961369274,0.73890811816398483]
[null,10,1615103.13336071,737470.99583571008,null,1687521.2918607099,-2458937.6191642908,14936070.939051433,0.85299293540354348]
[null,{"$f":"IF(B73=\"\",\"\",IF(B73+1<=$I$5,B73+1,\"\"))","v":""},"",{"$f":"IF(B74=\"\",\"\",D73+C74)","v":""},null,"","",""]
[null,"","","",null,"","",""]
[null,"","","",null,"","",""]
[null,"","","",null,"","",""]
[null,"","","",null,"","",""]
[null,"","","",null,"","",""]
[null,"","","",null,"","",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]

{"sheet":"Purchase tool Livestock","index":4,"n_rows":102,"n_cols":26,"rows_kept":102,"cut":false,"hidden":true,"merged":[[1,0,1,3]]}
[]
["Expansion tool (fixed area) - can I afford to expand?",null,null,null,null,null,null,null,null,null,null,null,"Asking price ($/ac)",1000,null,null,null,null,null,null,null,null,null,null,"Tom","LU 1"]
["Area owned (hectares)",1000,null,200,null,{"$f":"SUM(B3,D3)","v":1200},null,null,null,null,null,null,"Purchase price",{"$f":"N39*N2","v":2220000},null,null,null,null,null,null,"Area (ha)",{"$f":"O39","v":898.42169162282471},null,"Distance (km)",30,60]
["Additional area (mgd or leased)",0,null,null,null,0,null,"Tax rate",0.3,null,null,null,"Land price ($/ha)",{"$f":"N3/O39","v":2471},null,null,null,null,null,null,"Potential SR DSE",{"$f":"N5","v":7762.0396600566564},null,"Trips/wk",2,4]
["Total area managed",{"$f":"SUM(B3:B4)","v":1000},null,{"$f":"SUM(D3:D4)","v":200},null,{"$f":"SUM(B5,D5)","v":1200},null,"Years",10,null,null,null,"Farm stocking rate ($/ha)",{"$f":"R39","v":7762.0396600566564},null,null,null,null,null,null,"Potential SR DSE/ha",{"$f":"V4/V3","v":8.6396396396396398},null,"Distance (km/yr)",{"$f":"Y3*2*Y4*52","v":6240},{"$f":"Z3*2*Z4*52","v":24960}]
["Bank interest rate",0.06,null,6.5000000000000002E-2,null,null,null,"IRR",{"$f":"IRR(C63:C103)","v":0.10510516006632109},null,null,null,"Land price ($/DSE)",{"$f":"N3/N5","v":286.00729927007302},null,null,null,null,null,null,"Fertiliser application cost",{"$f":"V8/1000*V12","v":28225.59876384239},null,"Av speed (km/hr)",80,80]
["Whole farm income",{"$f":"SUM(B8:B10)","v":723056.64000000001},null,{"$f":"D11*B13","v":144611.32800000001},null,{"$f":"SUM(B7,D7)","v":867667.96799999999},null,"NPV",{"$f":"C63+NPV(10%,C64:C93)","v":15436.569329122161},null,null,null,null,{"$f":"N5/O23","v":8.639639639639638},null,null,null,null,null,null,"Total kg P",{"$f":"V8*V15","v":6209.6317280453259},null,"Days travelling",{"$f":"Y5/Y6/8","v":9.75},{"$f":"Z5/Z6/8","v":39}]
["Enterprise expenses",{"$f":"B14*B11","v":120000},0,{"$f":"B14*D11*(1+C8)","v":24000},null,{"$f":"SUM(B8,D8)","v":144000},null,null,null,null,null,null,null,"Ewes","Lambs","Rams",null,null,null,null,"Total kg SSP",{"$f":"S39","v":70563.996909605979},null,"Percent of FTE travelling",{"$f":"SUM(Y7)/240","v":4.0625000000000001E-2},{"$f":"SUM(Z7)/240","v":0.16250000000000001}]
["Overhead expenses",{"$f":"B15*B11","v":300000},null,50000,null,{"$f":"SUM(B9,D9)","v":350000},null,null,null,null,null,null,"DSE/hd",1.5,1.9,1.25,null,null,null,null,"Cost ($/ha)",{"$f":"V6/V3","v":31.41687141687142},null,"Fuel",1.5,1.5]
["Profit (EBIT)",{"$f":"B24*B23","v":303056.64000000001},null,{"$f":"D7-SUM(D8:D9)","v":70611.328000000009},null,{"$f":"SUM(B10,D10)","v":373667.96799999999},null,"Rate of capital gain",0.06,null,null,null,"% yr ",1,0.25,1,null,null,null,null,"Kg P/ha",{"$f":"V7/V3","v":6.9117117117117122},null,"Km/L",10,10]
["Total DSE managed",15000,null,{"$f":"D12*D3","v":3000},null,null,null,"On costs (stamp dty/legals)",{"$f":"+(8990+(4.5%*((D20)-300000)))+12000","v":97490},null,null,null,"Price ($/hd)",130,null,800,null,null,null,null,"Kg SSP/ha",{"$f":"V8/V3","v":78.542178542178547},null,"Fuel cost",{"$f":"Y5/Y10*Y9","v":936},{"$f":"Z5/Z10*Z9","v":3744}]
["Stocking rate (DSE/ha)",{"$f":"B11/B3","v":15},0,{"$f":"B12*(1+C12)","v":15},null,null,null,"% yr overdraft required",0.75,null,null,null,"Number head",3800,{"$f":"N12*O13","v":4180},{"$f":"N12*P13","v":38},null,null,null,null,"Fertiliser cost ($/t)",400]
["Income ($/DSE mgd)",{"$f":"SUM(B14:B16)","v":48.203776000000005},null,{"$f":"D7/$D$11","v":48.203776000000005},null,{"$f":"F7/$F$5","v":723.05664000000002},null,"Additional start up costs",100000,null,null,null,"Weaning/joining %",null,1.1000000000000001,0.01,null,null,null,null,"Fertiliser rate (kgP/DSE)",0.8]
["Enterprise costs ($/DSE mgd)",8,null,{"$f":"D8/$D$11","v":8},null,{"$f":"F8/$F$5","v":120},null,null,null,null,null,null,"AA DSE",{"$f":"N12*N10*N9","v":5700},{"$f":"O12*O10*O9","v":1985.5},{"$f":"P12*P10*P9","v":47.5},null,null,null,null,"Cost ($/kg P)",{"$f":"V12/1000/8.8%","v":4.545454545454545}]
["Overhead expenses ($/DSE mgd)",20,null,16.666666666666668,null,{"$f":"F9/$F$5","v":291.66666666666669},null,null,null,null,null,null,"Total DSE",{"$f":"SUMPRODUCT(N9:P9,N12:P12,N10:P10)","v":7733},null,null,null,null,null,null,"%P in SSP",8.7999999999999995E-2]
["Profit EBIT($/DSE mgd)",{"$f":"B10/B11","v":20.203776000000001},null,23.537109333333337,null,{"$f":"F10/$F$5","v":311.38997333333333},null,null,null,null,null,null,"Capital cost",{"$f":"SUMPRODUCT(N12:P12,N11:P11)","v":524400}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Capital cost ($/DSE)",{"$f":"N16/SUM(N14:P14)","v":67.813267813267814}]
[null,"Existing business",null,"Proposed purchase",null,"Existing plus proposed",null,null,null,null,null,null,"Description",null,"Area (ha)","Land class rating","DSE/ha","Area (% total)"]
["Lease cost ($)",null,null,null,null,null,null,null,null,null,null,null,"Creek Flats",null,{"$f":"SUMIF($P$27:$P$38,$P19,$O$27:$O$38)","v":32.375556454876566},1,15,{"$f":"$O19/$O$23","v":3.6036036036036029E-2},null,null,"Fertiliser",{"$f":"V6","v":28225.59876384239}]
["Land value (owned)",6340224,null,2000000,null,{"$f":"SUM(B20,D20)","v":8340224},null,null,null,null,null,null,"Undulating Granite",null,{"$f":"SUMIF($P$27:$P$38,$P20,$O$27:$O$38)","v":250.91056252529341},2,10,{"$f":"$O20/$O$23","v":0.27927927927927926},null,null,"Depreciation",{"$f":"V29*12%","v":3600}]
["Land value other",{"$f":"B20/B3*B4","v":0},null,null,null,{"$f":"SUM(B21,D21)","v":0},null,null,null,null,null,null,"Granite Hills",null,{"$f":"SUMIF($P$27:$P$38,$P21,$O$27:$O$38)","v":538.24362606232296},3,8,0.59909909909909909,null,null,"Fuel and oil",{"$f":"SUM(Y11:Z11)*1.1","v":5148}]
["Non-land asset value",1236192,null,554400,null,{"$f":"SUM(B22,D22)","v":1790592},null,null,null,null,null,null,"Steep Granite Hills",null,{"$f":"SUMIF($P$27:$P$38,$P22,$O$27:$O$38)","v":76.891946580331847},4,6,8.5585585585585572E-2,null,null,"Labour unit (incl sup+WC)",{"$f":"70000*1.21","v":84700}]
["Total value of assets managed",{"$f":"SUM(B20:B22)","v":7576416},null,{"$f":"D20+D22","v":2554400},null,{"$f":"SUM(F20:F22)","v":10130816},null,null,null,null,null,null,null,null,{"$f":"SUM(O19:O22)","v":898.42169162282482},null,null,1,null,null,"Rates and rents",3500]
["Return on assets managed",0.04,null,{"$f":"D10/D23","v":2.764301910429064E-2},null,{"$f":"F10/F23","v":3.6884291255511896E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vehicle expenses",2500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total marginal Overheads",{"$f":"SUM(V19:V24)","v":127673.5987638424}]
[null,"Existing business",null,"Proposed expansion",null,"Existing plus proposed",null,null,null,null,null,null,"Paddock","Acres","Ha","Rating","SR DSE/ha","DSE/pdk","SSP rate (kg/ha)"]
["Equity",{"$f":"(B28-B31)/B28","v":0.85481261852569868},null,{"$f":"D28/D23","v":7.829627309740057E-3},null,{"$f":"F28/F23","v":0.74983258999077662},null,null,null,null,null,null,"Hill",400,{"$f":"N27/2.471","v":161.87778227438284},3,{"$f":"VLOOKUP(P27,$P$19:$Q$22,2,FALSE)","v":8},{"$f":"VLOOKUP(P27,$P$19:$Q$22,2,FALSE)*O27","v":1295.0222581950627},{"$f":"Q27*$V$13/$V$15","v":72.727272727272734}]
["Value of owned assets",{"$f":"B20+B22","v":7576416},null,20000,null,{"$f":"B28+D28","v":7596416},null,null,null,null,null,null,"Days Flat",300,{"$f":"N28/2.471","v":121.40833670578712},2,{"$f":"VLOOKUP(P28,$P$19:$Q$22,2,FALSE)","v":10},1214.0833670578713,90.909090909090921]
["Value of other farming assets",{"$f":"B21","v":0},null,null,null,null,null,null,null,null,null,null,"Dogtrap",340,137.59611493322541,3,8,1100.7689194658033,72.727272727272734,null,"Vehicles",30000]
["Operating capital",{"$f":"SUM(B8:B9)","v":420000},null,{"$f":"SUM(D14,D15)*D3","v":4933.3333333333339},null,{"$f":"B30+D30","v":424933.33333333331},null,null,null,null,null,null,"Walters",200,80.938891137191419,3,8,647.51112909753135,72.727272727272734]
["Net liabilities",{"$f":"1100000","v":1100000},null,{"$f":"D23-D28+D30+I11+I13","v":2736823.3333333335},null,{"$f":"SUM(B31:D31)","v":3836823.3333333335},null,null,null,null,null,null,"Pines",120,48.563334682314853,4,6,291.3800080938891,54.545454545454554]
["Annual interest and lease costs",{"$f":"(((B30*I12)+(B31-B30))*$B$6)+B19","v":59700},null,{"$f":"(((D30*I12)+(D31-D30))*$D$6)+D19","v":177813.35},null,{"$f":"SUM(B32:D32)","v":237513.35},null,null,null,null,null,null,"Rough",70,28.328611898016995,4,6,169.97167138810198,54.545454545454554]
["Interest cover",{"$f":"B10/B32","v":5.0763256281407036},null,{"$f":"D10/D32","v":0.39710926091882304},null,{"$f":"F10/F32","v":1.5732503793997263},null,null,null,null,null,null,"Dougs",100,40.46944556859571,2,10,404.69445568595711,90.909090909090921]
["Profit after interest and lease",{"$f":"B10-B32","v":243356.64},null,{"$f":"D10-D32","v":-107202.022},null,{"$f":"F10-F32","v":136154.61799999999},null,null,null,null,null,null,"Gibbons",120,48.563334682314853,3,8,388.50667745851882,72.727272727272734]
["Tax",{"$f":"((B10*$I$4)-(B32*$I$4))","v":73006.991999999998},null,{"$f":"((D10*$I$4)-(D32*$I$4))","v":-32160.606599999996},null,{"$f":"IF(((F10*$I$4)-(F32*$I$4))<0,0,((F10*$I$4)-(F32*$I$4)))","v":40846.385399999985},null,null,null,null,null,null,"Willows",120,48.563334682314853,3,8,388.50667745851882,72.727272727272734]
["Profit after interest and tax",{"$f":"B34-B35","v":170349.64800000002},null,{"$f":"D34-D35","v":-75041.415399999998},null,{"$f":"F34-F35","v":95308.232600000003},null,null,null,null,null,null,"Muddy Springs",150,60.704168352893561,3,8,485.63334682314849,72.727272727272734]
["Provisioning for capital expenditure",100000,null,20000,null,{"$f":"SUM(B37,D37)","v":120000},null,null,null,null,null,null,"Bakers",220,89.032780250910562,2,10,890.3278025091056,90.909090909090921]
["Cash after CAPEX",{"$f":"B36-B37","v":70349.648000000016},null,{"$f":"D36-D37","v":-95041.415399999998},null,-24691.767399999997,null,null,null,null,null,null,"River",80,32.375556454876566,1,15,485.63334682314849,136.36363636363637]
["Year 1 value of capital gain",{"$f":"B20*I10","v":380413.44},null,{"$f":"D20*I10","v":120000},null,{"$f":"SUM(B39:D39)","v":500413.44},null,null,null,null,null,null,null,{"$f":"SUM(N27:N38)","v":2220},{"$f":"SUM(O27:O38)","v":898.42169162282471},null,null,{"$f":"SUM(R27:R38)","v":7762.0396600566564},{"$f":"SUMPRODUCT(S27:S38,O27:O38)","v":70563.996909605979}]
["Total wealth created",{"$f":"SUM(B36,B39)","v":550763.08799999999},null,{"$f":"D39+D36","v":44958.584600000002},null,{"$f":"F39+F36","v":595721.67260000005}]
["Return on equity",{"$f":"B40/B28","v":7.2694409599472889E-2},null,null,null,{"$f":"F40/F28","v":7.8421412492417478E-2}]
[]
["Will the expansion opportunity:",null,null,"Year 1 amount:"]
["Reduce equity?",null,{"$f":"IF(F27<$B27,\"Yes\",\"No\")","v":"Yes"},{"$f":"B27-F27","v":0.10498002853492205}]
["Increase debt?",null,{"$f":"IF(D31>0,\"Yes\",\"No\")","v":"Yes"},{"$f":"D31","v":2736823.3333333335},null,null,"Crop","Wheat","Canola","Barley","Wtd av"]
["Increase annual interest costs?",null,{"$f":"IF(D31>0,\"Yes\",\"No\")","v":"Yes"},{"$f":"D32","v":177813.35},null,null,"Area (% total)",0.33,0.33,0.33]
["Increase profit (EBIT)?",null,{"$f":"IF(D10>0,\"Yes\",\"No\")","v":"Yes"},{"$f":"D10","v":70611.328000000009},null,null,"Area (ha)",{"$f":"100*H46","v":33},{"$f":"100*I46","v":33},33,{"$f":"SUM(H47:J47)","v":99}]
["Increase profit after interest and tax?",null,{"$f":"IF(D36>=0,\"Yes\",\"No\")","v":"No"},{"$f":"D36","v":-75041.415399999998},null,null,"Yield (t/ha)",3,1.5,3.3]
["Increase wealth?",null,{"$f":"IF(D40>=0,\"Yes\",\"No\")","v":"Yes"},{"$f":"D40","v":44958.584600000002},null,null,"Price ($/t)",260,460,230,{"$f":"SUMPRODUCT(H49:J49,$H$46:$J$46)","v":313.5}]
["Marginal return on equity",null,null,{"$f":"D40/D28","v":2.24792923},null,null,"Income ($/ha)",{"$f":"H48*H49","v":780},{"$f":"I48*I49","v":690},759,{"$f":"SUMPRODUCT(H50:J50,$H$46:$J$46)","v":735.57}]
[null,null,null,null,null,null,"Ent exp ($/ha)",350,395,335,{"$f":"SUMPRODUCT(H51:J51,$H$46:$J$46)","v":356.4}]
["Degree of operating leverage",null,null,{"$f":"((D10+D39)+(D15*D3))/(D10+D39)","v":1.017487593042389}]
["Degree of financial leverage",null,null,{"$f":"D40/(D40-D32)","v":-0.33840400428722595}]
["Degree of operating leverage",null,null,{"$f":"D52*D53","v":-0.3443218757981158}]
[]
["Operating leverage",null,null,{"$f":"(D10+D30-(B14*D3))/D10","v":1.0472067786819323}]
[]
["Total DSE managed",{"$f":"'[1]Wool Flock'!$G$75+'[1]DP Flock'!$G$77","v":20076.277104866844},null,{"$f":"N5","v":7762.0396600566564}]
["Income ($/DSE)",{"$f":"B7/B58","v":36.015474194900328}]
["Enterprise expenses ($/DSE)",{"$f":"B8/B58","v":5.9772038099090539}]
[]
[null,"Year","Equity cashflow","Cumulative equity cashflow",null,"Whole farm cash flow","Cumulative whole farm liabilities","Gross land value","Equity"]
[null,0,{"$f":"-D28","v":-20000},{"$f":"C63","v":-20000},null,{"$f":"-F31","v":-3836823.3333333335},{"$f":"IF(F63=\"\",\"\",F63)","v":-3836823.3333333335},{"$f":"IF(G63=\"\",\"\",F20)","v":8340224},{"$f":"(H63+$F$22+G63)/(H63+$F$22)","v":0.62127203442118251}]
[null,{"$f":"IF(B63=\"\",\"\",IF(B63+1<=$I$5,B63+1,\"\"))","v":1},{"$f":"IF($B64=\"\",\"\",$D$38+IF($B64=$I$5,($D$20*(1+$I$10)^$B64)+$D$30+$D$22-($D$23-$D$28),0))","v":-95041.415399999998},{"$f":"IF(B64=\"\",\"\",D63+C64)","v":-115041.4154},null,{"$f":"IF($B64=\"\",\"\",$F$38+IF($B64=$I$5,($D$20*(1+$I$10)^$B64)+$D$30+$D$22-($D$23-$D$28),0))","v":-24691.767399999997},{"$f":"IF(F64=\"\",\"\",G63+F64)","v":-3861515.1007333333},{"$f":"IF(G64=\"\",\"\",$F$20*(1+$I$10)^B64)","v":8840637.4400000013},{"$f":"(H64+$F$22+G64)/(H64+$F$22)","v":0.63677624281116707}]
[null,{"$f":"IF(B64=\"\",\"\",IF(B64+1<=$I$5,B64+1,\"\"))","v":2},{"$f":"IF($B65=\"\",\"\",$D$38+IF($B65=$I$5,($D$20*(1+$I$10)^$B65)+$D$30+$D$22-($D$23-$D$28),0))","v":-95041.415399999998},{"$f":"IF(B65=\"\",\"\",D64+C65)","v":-210082.8308},null,{"$f":"IF($B65=\"\",\"\",$F$38+IF($B65=$I$5,($D$20*(1+$I$10)^$B65)+$D$30+$D$22-($D$23-$D$28),0))","v":-24691.767399999997},{"$f":"IF(F65=\"\",\"\",G64+F65)","v":-3886206.868133333},{"$f":"IF(G65=\"\",\"\",$F$20*(1+$I$10)^B65)","v":9371075.6864000019},0.65182560730879813]
[null,3,-95041.415399999998,-305124.24619999999,null,-24691.767399999997,-3910898.6355333328,9933340.2275840025,0.66641749887194057]
[null,4,-95041.415399999998,-400165.66159999999,null,-24691.767399999997,-3935590.4029333326,10529340.641239043,0.68055098046887363]
[null,5,-95041.415399999998,-495207.07699999999,null,-24691.767399999997,-3960282.1703333324,11161101.079713387,0.69422668171959412]
[null,6,-95041.415399999998,-590248.49239999999,null,-24691.767399999997,-3984973.9377333322,11830767.144496189,0.70744667287159158]
[null,7,-95041.415399999998,-685289.90779999993,null,-24691.767399999997,-4009665.7051333319,12540613.173165964,0.72021433950013425]
[null,8,-95041.415399999998,-780331.32319999998,null,-24691.767399999997,-4034357.4725333317,13293049.963555919,0.73253425914769954]
[null,9,-95041.415399999998,-875372.73860000004,null,-24691.767399999997,-4059049.2399333315,14090632.961369274,0.7444120809442043]
[null,10,1511587.3110190427,636214.5724190427,null,1581936.9590190428,-2477112.2809142889,14936070.939051433,0.85190636710141254]
[null,"","","",null,"","",""]
[null,"","","",null,"","",""]
[null,"","","",null,"","",""]
[null,"","","",null,"","",""]
[null,"","","",null,"","",""]
[null,"","","",null,"","",""]
[null,"","","",null,"","",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,"","","",null,null,"",""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]
[null,null,"",null,null,null,""]