{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Whole farm KPI tool"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":58,"comments":0,"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":"Whole farm KPI tool","index":0,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,1,43,6],[37,1,39,6],[1,1,1,6],[3,1,7,1],[13,1,17,1],[19,1,26,1],[29,1,35,1]]}
[]
[null,"Whole farm key performance indicator calculator"]
[]
[null,"Gross financial performance",null,"Whole farm","Code","Calculation","Descriptor or calculation"]
[null,null,"Gross profit",1200000,"a",null,"Sales - purchases + inventory change"]
[null,null,"Enterprise expenses",150000,"b",null,"Sum of operating costs directly related to enterprise"]
[null,null,"Overhead expenses",400000,"c",null,"Sum of operating costs not easily allocated to enterprise"]
[null,null,"EBIT (operating profit)",{"$f":"D5-SUM(D6:D7)","v":650000},"d","a - (b + c)","Gross profit less sum of enterprise & overhead expenses"]
[]
[null,null,"Interest rate",{"$f":"D14/D26","v":3.5714285714285712E-2},"e","h ¸ r","Annual interest costs ¸ total liabilities"]
[null,null,"Full time equivalent labour units (FTE LU)",{"$f":"300/240","v":1.25},"f",null,"Sum of all labour in days worked ¸240 (labour days/year) "]
[null,null,"Tax rate",0.25,"g",null,"Annual tax payment divided by taxable income"]
[]
[null,"Finance& tax costs","Interest costs",125000,"h",null,"Annual interest paid on liabilities"]
[null,null,"Lease costs",0,"i",null,"Annual lease costs"]
[null,null,"Net profit after interest & lease",{"$f":"D8-(D14+D15)","v":525000},"j","d - (h + i)","EBIT less finance costs"]
[null,null,"Tax costs",{"$f":"D16*D12","v":131250},"k",null,"Tax rate x Profit after interest"]
[null,null,"Net profit after interest and tax",{"$f":"D16-D17","v":393750},"l","j - k","EBIT less finance and tax costs"]
[]
[null,"Balance sheet","Land assets",11348125,"m",null,"Current market value of land assets owned"]
[null,null,"Livestock assets",2269625,"n",null,"Current market value of livestock assets owned"]
[null,null,"Plant and equipment assets",750000,"o",null,"Current market value of plant & equipment assets owned"]
[null,null,"Cash & stock on hand",0,"p",null,"Current market value cash and fodder/grain on hand"]
[null,null,"Total assets",{"$f":"SUM(D20:D23)","v":14367750},"q","(m+n+o+p)","The sum of land, livestock, plant and stock on hand"]
[]
[null,null,"Total liabilities",3500000,"r",null,"Total liabilities "]
[null,null,"Net assets (equity)",{"$f":"D24-D26","v":10867750},"s","r - s","Total assets less total liabilities"]
[]
[null,null,"Key performance indicator","Result","Target","Calculation","Descriptor or calculation"]
[null," Key performance indicators - whole farm","Equity percentage",{"$f":"D27/D24","v":0.75639887943484541},">70%","s ¸ q","Net assets ¸ total assets"]
[null,null,"Interest cover ratio",{"$f":"D8/(D14+D15)","v":5.2},">3.0:1","d ¸ h","EBIT ¸ (interest & lease costs)"]
[null,null,"Return on assets managed",{"$f":"D8/D24","v":4.5240208104957283E-2},"4-8%","d ¸ q","Operating profit ¸ total value of farm assets"]
[null,null,"Return on equity",{"$f":"D16/D27","v":4.8308067447263695E-2},">ROAM","j ¸ s","Profit after interest & lease ¸ net assets"]
[null,null,"Interest % gross profit",{"$f":"D14/D5","v":0.10416666666666667},"<15%","h ¸ a","Annual interest ¸ gross profit"]
[null,null,"Gross profit per labour unit",{"$f":"D5/D11","v":960000},">$750,000","a ¸ f","Gross profit ¸ Full time equivalent labour units "]
[null,null,"Operating profit % gross profit",{"$f":"D8/D5","v":0.54166666666666663},">50%","d ¸ a","Operating profit ¸ gross profit"]
[]
[null,"KPI target statement: The targets are derived from current (2021) industry and financial benchmarks and assume that a key motivation or business goal is high levels of farm profitability through solid financial performance to deliver financial freedom and prosperity. Where owner or operator goals differ then targets should be adjusted to better reflect the business goals."]
[]
[]
[]
[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."]