{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Reverse budget 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":"Reverse budget tool","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,1,26,8],[1,1,1,8],[2,1,2,2],[2,4,2,8],[4,4,7,4],[8,4,11,4],[16,1,16,2]]}
[]
[null,"Reverse budget tool - Performance requirements of the business based on future financial needs"]
[null,"Existing business performance",null,null,"Future funding requirements and financial needs"]
[null,"Long term average business performance",null,null,null,"Funding requirement","Amount","How many years from now is this funding required","Annual provisioning"]
[null,"Gross profit",1420000,null,"Personal","Family expenses",20000,1,{"$f":"IF(OR(G5=\"\",G5=0),0,G5/H5)","v":20000}]
[null,"Operating costs",850000,null,null,"Education",300000,4,75000]
[null,"EBIT/Operating profit",{"$f":"C5-C6","v":570000},null,null,"Succession",800000,20,40000]
[null,"Imputed owner wages in mgt accounts",150000,null,null,"Retirement",1000000,20,50000]
[null,"Actual owner wages or drawings",100000,null,"Business","Debt principal",{"$f":"C11","v":2000000},10,200000]
[null,"Existing and future finance and tax rates",null,null,null,"Capital expediture/replacement",30000,1,30000]
[null,"Liabilities",2000000,null,null,"Business provisions",100000,5,20000]
[null,"Interest rate",{"$f":"C13/C11","v":4.3749999999999997E-2},null,null,"Add back owner wage",{"$f":"C8-C9","v":50000},null,{"$f":"-G12","v":-50000}]
[null,"Interest",87500,null,null,"Annual funds required*",null,null,{"$f":"SUM(I5:I12)","v":385000}]
[null,"Tax rate",0.3]
[null,"Net profit % gross profit",{"$f":"(C5-C6)/C5","v":0.40140845070422537},null,null,"* Assumes no investment return on annual provisioning"]
[]
[null,"Existing performance against future needs"]
[null,"Is the business generating adequate earnings to meet the future funding needs?",{"$f":"IF(C19<0,\"No\",\"Yes\")","v":"No"}]
[null,{"$f":"IF(C19<0,\"What is the extent of the shortfall after meeting the funding needs?\",\"What is the extent of the surplus after meeting the funding needs?\")","v":"What is the extent of the shortfall after meeting the funding needs?"},{"$f":"((C7-C13)*(1-C14))-I13","v":-47250}]
[null,{"$f":"IF(C20=\"\",\"\",\"Additional gross profit to achieve funding needs\")","v":"Additional gross profit to achieve funding needs"},{"$f":"IF(C19>0,\"\",((I13/(1-C14)+C13)/C15)-C5)","v":168157.89473684202}]
[null,{"$f":"IF(C21=\"\",\"\",\"Additional operating costs to achieve funding needs\")","v":"Additional operating costs to achieve funding needs"},{"$f":"IF(C19>0,\"\",((I13/(1-C14)+C13)/C15)-((I13/(1-C14)+C13))-C6)","v":100657.89473684202}]
[null,{"$f":"IF(C22=\"\",\"\",\"Additional EBIT to achieve funding needs\")","v":"Additional EBIT to achieve funding needs"},{"$f":"IF(C19>0,\"\",C23-C7)","v":67500}]
[null,{"$f":"IF(C23=\"\",\"\",\"Revised EBIT required to achieve funding needs\")","v":"Revised EBIT required to achieve funding needs"},{"$f":"IF(C19<0,(C5+C20)-(C6+C21),\"\")","v":637500}]
[]
[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."]