{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Macros Required","Welcome","Input","Sensitivity Analysis","Expected Results","Optimistic Results","Pessimistic Results","Forecast Revenue Chart","Forecast Surplus Chart","Forecast Return Chart","Operating Surplus Chart","Budget by Month Master","Budget by Month Master Chart","Budget by Month","Budget by Month Chart","Instructions","Worksheet","Scratch"],"not_rendered":{"charts":12,"images":30,"macros":1,"external_links":0,"defined_names":19,"comments":4,"pivot_tables":0},"unopened":[{"sheet":"Forecast Revenue Chart","index":7,"reason":"not_a_worksheet"},{"sheet":"Forecast Surplus Chart","index":8,"reason":"not_a_worksheet"},{"sheet":"Forecast Return Chart","index":9,"reason":"not_a_worksheet"},{"sheet":"Operating Surplus Chart","index":10,"reason":"not_a_worksheet"},{"sheet":"Budget by Month Master Chart","index":12,"reason":"not_a_worksheet"},{"sheet":"Budget by Month Chart","index":14,"reason":"not_a_worksheet"}],"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":"Macros Required","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"\"Macros Required - \"&title","v":"Macros Required - Forecast Budget"}]
[]
[null," Macros must be enabled for this application to function."]
[]
[null,"Please refer to your spreadsheet Help for details on how to enable macros."]
[]
[null,"Suitability must be independently assessed and use indicates acceptance of any and all associated risk."]

{"sheet":"Welcome","index":1,"n_rows":107,"n_cols":3,"rows_kept":107,"cut":false,"hidden":false,"merged":[[5,1,5,2],[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[22,1,22,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,15,2],[20,1,20,2],[21,1,21,2]]}
[null,"Forecast Budget"]
[]
[null,"Build: 20220225 by bizpep.com"]
[]
[null,"Shift Scheduler will build a roster structure to your specifications, allocate staff automatically, and generate a printable roster, all at the click of a button. It is compact and user friendly allowing you to add staff and shifts (maximum 150) with ease. Default values for continuous shifts mean that the only shift data required is the start date/time and length for the first shift, everything else is automated."]
[]
[null,"To start use the sheet tabs to select the Input sheet."]
[null,"Input is in the blue cells. Non-input cells are protected to maintain formula integrity."]
[null,"help"]
[]
[null,{"$f":"IF(Scratch!B55=TRUE,\"Current license subscriptions can be managed directly from your PayPal account.\",\"In evaluation mode functionality is restriced.\")","v":"In evaluation mode functionality is restriced."}]
[null,{"$f":"IF(Scratch!B55=TRUE,\"On renewal new License Details will be emailed. You can purchase at new license at:\",\"To fully enable this application please purchase a license at:\")","v":"To fully enable this application please purchase a license at:"}]
[null,"https://bizpep.com/forecastbudget.html?display=license"]
[null,{"$f":"IF(Scratch!B55=TRUE,\"Current license details fully enable your application\",\"License Details are sent by email, on reciept input license details to fully enable your application.\")","v":"License Details are sent by email, on reciept input license details to fully enable your application."}]
[]
[]
[null,"Application License Details:"]
[null,"Licensed Email Address:"]
[null,"License Code:"]
[null,"License Valid to Date:",{"$f":"IF(Scratch!B55=TRUE,Scratch!C55,\"Not Licensed, for Evaluation Only.\")","v":"Not Licensed, for Evaluation Only."}]
[]
[null,"Suitability must be independently assessed and use indicates acceptance of any and all associated risk."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(Scratch!B55=TRUE,\"Licensed to \"&Welcome!C11, Welcome!C13&\" In evaluation mode functionality is limited.\")","v":" In evaluation mode functionality is limited."}]
[]
[]
[null,{"$f":"IFERROR(AND(ISTEXT(Welcome!C18),LEN(Welcome!C18)>6),FALSE)","v":false}]
[null,{"$f":"IFERROR(AND(ISNUMBER(INT(Welcome!C19)),LEN(Welcome!C19)>8),FALSE)","v":false},{"$f":"IFERROR(Welcome!C19/Scratch!E57/E41,FALSE)","v":false}]
[]
[]
[]
[null,null,{"$f":"MID(Welcome!$C$18,B58,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B59,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B60,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B61,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B62,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B63,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B64,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B65,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B66,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B67,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B68,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B69,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B70,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B71,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B72,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B73,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B74,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B75,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B76,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B77,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B78,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B79,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B80,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B81,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B82,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B83,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B84,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B85,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B86,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B87,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B88,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B89,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B90,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B91,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B92,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B93,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B94,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B95,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B96,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B97,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B98,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B99,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B100,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B101,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B102,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B103,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B104,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B105,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B106,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B107,1)","v":{"$error":"#VALUE!"}}]

{"sheet":"Input","index":2,"n_rows":82,"n_cols":6,"rows_kept":82,"cut":false,"hidden":false,"merged":[[56,2,56,5],[57,2,57,5],[58,2,58,5],[66,2,66,5],[67,2,67,5],[60,2,60,5],[61,2,61,5],[62,2,62,5],[63,2,63,5],[64,2,64,5],[65,2,65,5],[35,1,35,2],[35,3,35,5],[49,3,49,5],[50,3,50,5],[53,1,53,5],[51,3,51,5],[47,3,47,5],[1,3,1,5],[2,3,2,5],[4,1,4,5],[5,1,5,5],[23,4,23,5],[6,1,6,5],[14,4,14,5],[8,3,8,5],[11,1,11,5],[10,2,10,4],[12,3,12,5],[20,4,20,5],[21,4,21,5],[15,4,15,5],[18,4,18,5],[19,4,19,5],[69,1,69,5],[54,1,54,5],[8,1,8,2],[16,4,16,5],[17,4,17,5],[30,4,30,5],[22,4,22,5],[24,4,24,5],[25,4,25,5],[29,4,29,5],[27,4,27,5],[28,4,28,5],[26,4,26,5],[59,2,59,5],[31,4,31,5],[32,4,32,5],[75,1,75,5],[76,1,76,5],[77,1,77,5],[78,1,78,5],[70,1,70,5],[72,1,72,5],[73,1,73,5],[74,1,74,5],[71,1,71,5]]}
[]
[]
[]
[]
[null,{"$f":" \"Input - \" &title","v":"Input - Forecast Budget"}]
[null,"Blue cells require input. View comments by positioning your mouse over the red marker cell or click the hyperlink for the"]
[null,"Instruction Sheet"]
[]
[null,"Current Operating Performance Data",null,"This section reviews current business performance for a full year."]
[]
[null,"Business Name or Identifier","Acme Widgets",null,null,"This appears on the Output Sheets."]
[]
[null,"Business Revenue",500000,"Annual business revenue for the current year."]
[]
[null,"Expenses","Monetary",{"$f":"+IF(C15=B81,B82,B81)","v":"Percent"},"Set the Expense Input as Monetary or Percent."]
[null,"Variable Costs",null,null,"Annual costs that vary with the level of revenue."]
[null,"Materials & Supplies",10000,{"$f":"+IF(D$15=B$82,C17/C$13*100,C17/100*C$13)","v":2},"Cost of items used in the product/service or resold."]
[null,"Labor excluding Owner",200000,40,"Cost of labor including all benefits and add-ons."]
[null,"Labor Owner",50000,10,"Cost of an employee who could replace the owner."]
[null,"Distribution",20000,4,"Cost to get the product/service to the consumer."]
[null,"Marketing",10000,2,"Cost of marketing and promotion."]
[null,"Other",20000,4,"Any other costs incurred in the product/service."]
[null,"Total Variable Costs",{"$f":"SUM(C17:C22)","v":310000},62,"Total Variable Costs and the % of Revenue"]
[null,"Fixed Costs",null,null,"Annual costs that do not vary with revenue."]
[null,"Location",40000,{"$f":"+IF(D$15=B$82,C25/C$13*100,C25/100*C$13)","v":8},"Cost of rent, utilities etc. Exclude ownership costs."]
[null,"Administration",30000,6,"Cost of administration supplies and requirements."]
[null,"Labor excluding Owner",50000,10,"Cost of labor including all benefits and add-ons."]
[null,"Labor Owner",10000,2,"Cost of an employee who could replace the owner."]
[null,"Interest Costs",0,0,"Interest component of loans. "]
[null,"Other",0,0,"Any other overhead costs not already included."]
[null,"Total Fixed Costs",{"$f":"SUM(C25:C30)","v":130000},26,"Total Fixed Costs and the % of Revenue."]
[null,"Operating Surplus",{"$f":"+IF(C$15=B$82,100-C23-C31,C13-C23-C31)","v":60000},12,"Operating surplus before taxation. "]
[null,"Owner Cash Flow",{"$f":"+C32+C28+C19","v":120000},24,"Operating surplus to owner including wages. "]
[]
[]
[null,"Forecast Data",null,"Input Relative Indicators to build a 3 Year Forecast."]
[]
[null,"Relative Indicator","Year 1","Year 2","Year 3","Indicators are Relative to the prior year."]
[null,"Level of Competition",1.03,1,0.97,">100=Inc, <100=Dec Competition."]
[null,"Market Strength",1.05,1,1,">100=Inc, <100=Dec Market Strength."]
[null,"Materials & Supplies Costs",1.05,1.05,1,">100=Inc, <100=Dec base Costs."]
[null,"Labor Costs",1,1.03,1.05,">100=Inc, <100=Dec base Costs."]
[null,"Interest Rates",1,1.05,0.95,">100=Inc, <100=Dec base Interest."]
[null,"Business Market Position",1.1000000000000001,1.05,1.03,">100=Inc, <100=Dec Business Position."]
[null,"Variable Cost Efficiency",1.03,1.05,1,">100=Inc, <100=Dec Variable Efficiency."]
[null,"Fixed Cost Efficiency",1,1.02,1.05,">100=Inc, <100=Dec Fixed Efficiency. "]
[]
[null,"Fixed Cost Flow-on",0.25,"The % increase in Fixed Costs for each 100% increase in revenue."]
[]
[null,"Owners Time Commitment to Business",1,"Input the percentage of work hours applied to the business."]
[null,"Replacement Value of Business Assets",100000,"What is the value of business assets excluding property."]
[null,"Life of Assets (years)",8,"What is the average life of the assets?"]
[]
[null,"Sheet List"]
[null,"Summary forecast data is included on the Sensitivity Analysis Sheet where you can test the sensitivity of your forecast. Details are in tabular form on the Results Sheets and graphical form on the Chart Sheets. To build your Budget input the revenue Percentage Contribution for each month and the first month of your budget in the Budget by Month Master. This will produce a full 12 month budget table and a Budget by Month Master Chart. You can then refine this on the Budget by Month sheet to build your final budget. To view comments position your mouse over the red marker cell or click the hyperlink to access the Instruction Sheet. To display Sheets click the associated button or tab."]
[null,"Sheet List"]
[null,"Sensitivity Analysis"]
[null,"Expected Results"]
[null,"Optimistic Results"]
[null,"Pessimistic Results"]
[null,"Forecast Revenue Chart"]
[null,"Forecast Surplus Chart"]
[null,"Forecast Return Chart"]
[null,"Operating Surplus Chart"]
[null,"Budget by Month Master"]
[null,"Budget by Month Master Chart"]
[null,"Budget by Month"]
[null,"Budget by Month Chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Monetary"]
[null,"Percent"]

{"sheet":"Sensitivity Analysis","index":3,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,2,1,6],[2,2,2,6],[4,1,4,6],[5,1,5,6],[24,1,24,6],[21,1,21,6],[6,5,7,6],[6,1,6,3],[7,1,7,3],[30,1,30,6],[31,1,31,6],[32,1,32,6],[33,1,33,6],[25,1,25,6],[27,1,27,6],[28,1,28,6],[29,1,29,6],[26,1,26,6]]}
[]
[]
[]
[]
[null,"Sensitivity Analysis"]
[null,"To test the sensitivity of your forecast input adjustment percentages in the blue cells. Green cells provide Optimistic results, yellow cells Expected, and tan cells Pessimistic. An Output Summary is provided at the bottom of this sheet."]
[null,"Optimistic, improve the variation of all Relative Indicators by",null,null,0.2]
[null,"Pessimistic, degrade the variation of all Relative Indicators by",null,null,0.2]
[null,null,"Current Year","Year 1","Year 2","Year 3","3 Year Average"]
[null,{"$f":"+Worksheet!B5","v":"Business Revenue"}]
[null,"Optimistic",{"$f":"+Worksheet!K5","v":500000},{"$f":"+Worksheet!L5","v":579687.5},{"$f":"+Worksheet!M5","v":614468.75},{"$f":"+Worksheet!N5","v":660362.68153526972},{"$f":"+Worksheet!O5","v":618172.9771784232}]
[null,"Expected",{"$f":"+Worksheet!C5","v":500000},{"$f":"+Worksheet!D5","v":560679.61165048543},{"$f":"+Worksheet!E5","v":588713.59223300975},{"$f":"+Worksheet!F5","v":625128.8659793816},{"$f":"+Worksheet!G5","v":591507.35662095889}]
[null,"Pessimistic",{"$f":"+Worksheet!R5","v":500000},{"$f":"+Worksheet!S5","v":542084.94208494201},{"$f":"+Worksheet!T5","v":563768.33976833976},{"$f":"+Worksheet!U5","v":591494.65156022529},{"$f":"+Worksheet!V5","v":565782.6444711691}]
[null,{"$f":"+Worksheet!B43","v":"Operating Surplus"}]
[null,"Optimistic",{"$f":"+Worksheet!K43","v":60000},{"$f":"+Worksheet!L43","v":97031.038851351303},{"$f":"+Worksheet!M43","v":122621.1434194204},{"$f":"+Worksheet!N43","v":129747.972125498},{"$f":"+Worksheet!O43","v":116466.7181320899}]
[null,"Expected",{"$f":"+Worksheet!C43","v":60000},{"$f":"+Worksheet!D43","v":88694.622490338515},{"$f":"+Worksheet!E43","v":106169.59067772643},{"$f":"+Worksheet!F43","v":105371.87455054082},{"$f":"+Worksheet!G43","v":100078.69590620192}]
[null,"Pessimistic",{"$f":"+Worksheet!R43","v":60000},{"$f":"+Worksheet!S43","v":80604.54874517367},{"$f":"+Worksheet!T43","v":90428.211639824556},{"$f":"+Worksheet!U43","v":82385.728313678061},{"$f":"+Worksheet!V43","v":84472.829566225424}]
[null,{"$f":"+Worksheet!B90","v":"Business Return"}]
[null,"Optimistic",{"$f":"+Worksheet!K49","v":47500},{"$f":"+Worksheet!L49","v":84032.991976351303},{"$f":"+Worksheet!M49","v":109405.7137319204},{"$f":"+Worksheet!N49","v":116245.70536590256},{"$f":"+Worksheet!O49","v":103228.13702472475}]
[null,"Expected",{"$f":"+Worksheet!C49","v":47500},{"$f":"+Worksheet!D49","v":75815.374917522975},{"$f":"+Worksheet!E49","v":93115.130726270116},{"$f":"+Worksheet!F49","v":92089.819138169682},{"$f":"+Worksheet!G49","v":87006.774927320934}]
[null,"Pessimistic",{"$f":"+Worksheet!R49","v":47500},{"$f":"+Worksheet!S49","v":67841.517857142782},{"$f":"+Worksheet!T49","v":77529.659516272426},{"$f":"+Worksheet!U49","v":69313.886741426657},{"$f":"+Worksheet!V49","v":71561.688038280627}]
[null,"Summary"]
[null,"The 3 Year Average Expected Business Return is",{"$f":"+G20","v":87006.774927320934},"per year."]
[null,"Sensitivity Analysis indicates a Return high of",{"$f":"+G19","v":103228.13702472475},"to a low of",{"$f":"+G21","v":71561.688038280627},"per year."]

{"sheet":"Expected Results","index":4,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,1,1,6],[52,1,52,6],[53,1,53,6],[55,1,55,6],[54,1,54,6],[60,1,60,6],[61,1,61,6],[56,1,56,6],[57,1,57,6],[58,1,58,6],[59,1,59,6]]}
[]
[null,"Expected Results"]
[null,{"$f":"Worksheet!B2","v":"Expected Forecast"}]
[null,{"$f":"Worksheet!B3","v":"Acme Widgets"}]
[null,null,{"$f":"Worksheet!C4","v":"Current Year"},{"$f":"Worksheet!D4","v":"Year 1"},{"$f":"Worksheet!E4","v":"Year 2"},{"$f":"Worksheet!F4","v":"Year 3"},{"$f":"Worksheet!G4","v":"3 Year Average"}]
[null,{"$f":"Worksheet!B5","v":"Business Revenue"},{"$f":"Worksheet!C5","v":500000},{"$f":"Worksheet!D5","v":560679.61165048543},{"$f":"Worksheet!E5","v":588713.59223300975},{"$f":"Worksheet!F5","v":625128.8659793816},{"$f":"Worksheet!G5","v":591507.35662095889}]
[null,{"$f":"Worksheet!B6","v":"Expenses"}]
[null,{"$f":"Worksheet!B7","v":"Variable Costs"}]
[null,{"$f":"Worksheet!B8","v":"Materials & Supplies"},{"$f":"Worksheet!C8","v":10000},{"$f":"Worksheet!D8","v":11431.331888019608},{"$f":"Worksheet!E8","v":12002.898482420587},{"$f":"Worksheet!F8","v":12745.345811230112},{"$f":"Worksheet!G8","v":12059.858727223434}]
[null,{"$f":"Worksheet!B9","v":"% Revenue"},{"$f":"Worksheet!C9","v":0.02},{"$f":"Worksheet!D9","v":2.0388349514563111E-2},{"$f":"Worksheet!E9","v":2.0388349514563107E-2},{"$f":"Worksheet!F9","v":2.0388349514563111E-2},{"$f":"Worksheet!G9","v":2.0388349514563107E-2}]
[null,{"$f":"Worksheet!B10","v":"Labor excluding Owner"},{"$f":"Worksheet!C10","v":200000},{"$f":"Worksheet!D10","v":222477.96682062396},{"$f":"Worksheet!E10","v":229085.76170759567},{"$f":"Worksheet!F10","v":258404.25030321415},{"$f":"Worksheet!G10","v":236655.99294381126}]
[null,{"$f":"Worksheet!B11","v":"% Revenue"},{"$f":"Worksheet!C11","v":0.4},{"$f":"Worksheet!D11","v":0.39680052956751977},{"$f":"Worksheet!E11","v":0.38912939115039952},{"$f":"Worksheet!F11","v":0.41336157129518475},{"$f":"Worksheet!G11","v":0.40008968661984318}]
[null,{"$f":"Worksheet!B12","v":"Labor Owner"},{"$f":"Worksheet!C12","v":50000},{"$f":"Worksheet!D12","v":49696.601941747576},{"$f":"Worksheet!E12","v":51254.044117647063},{"$f":"Worksheet!F12","v":54160.182686476648},{"$f":"Worksheet!G12","v":51703.609581957098}]
[null,{"$f":"Worksheet!B13","v":"% Revenue"},{"$f":"Worksheet!C13","v":0.1},{"$f":"Worksheet!D13","v":8.8636363636363638E-2},{"$f":"Worksheet!E13","v":8.7061085040076633E-2},{"$f":"Worksheet!F13","v":8.6638428704815224E-2},{"$f":"Worksheet!G13","v":8.7409918073240556E-2}]
[null,{"$f":"Worksheet!B14","v":"Distribution"},{"$f":"Worksheet!C14","v":20000},{"$f":"Worksheet!D14","v":21773.965500989725},{"$f":"Worksheet!E14","v":21773.965500989729},{"$f":"Worksheet!F14","v":23120.808727855074},{"$f":"Worksheet!G14","v":22222.913243278173}]
[null,{"$f":"Worksheet!B15","v":"% Revenue"},{"$f":"Worksheet!C15","v":0.04},{"$f":"Worksheet!D15","v":3.8834951456310676E-2},{"$f":"Worksheet!E15","v":3.6985668053629218E-2},{"$f":"Worksheet!F15","v":3.6985668053629218E-2},{"$f":"Worksheet!G15","v":3.7569969324183293E-2}]
[null,{"$f":"Worksheet!B16","v":"Marketing"},{"$f":"Worksheet!C16","v":10000},{"$f":"Worksheet!D16","v":10886.982750494863},{"$f":"Worksheet!E16","v":10886.982750494864},{"$f":"Worksheet!F16","v":11560.404363927537},{"$f":"Worksheet!G16","v":11111.456621639087}]
[null,{"$f":"Worksheet!B17","v":"% Revenue"},{"$f":"Worksheet!C17","v":0.02},{"$f":"Worksheet!D17","v":1.9417475728155338E-2},{"$f":"Worksheet!E17","v":1.8492834026814609E-2},{"$f":"Worksheet!F17","v":1.8492834026814609E-2},{"$f":"Worksheet!G17","v":1.8784984662091646E-2}]
[null,{"$f":"Worksheet!B18","v":"Other"},{"$f":"Worksheet!C18","v":20000},{"$f":"Worksheet!D18","v":21773.965500989725},{"$f":"Worksheet!E18","v":21773.965500989729},{"$f":"Worksheet!F18","v":23120.808727855074},{"$f":"Worksheet!G18","v":22222.913243278173}]
[null,{"$f":"Worksheet!B19","v":"% Revenue"},{"$f":"Worksheet!C19","v":0.04},{"$f":"Worksheet!D19","v":3.8834951456310676E-2},{"$f":"Worksheet!E19","v":3.6985668053629218E-2},{"$f":"Worksheet!F19","v":3.6985668053629218E-2},{"$f":"Worksheet!G19","v":3.7569969324183293E-2}]
[null,{"$f":"Worksheet!B20","v":"Total Variable Costs"},{"$f":"Worksheet!C20","v":310000},{"$f":"Worksheet!D20","v":338040.81440286536},{"$f":"Worksheet!E20","v":346777.61806013767},{"$f":"Worksheet!F20","v":383111.80062055867},{"$f":"Worksheet!G20","v":355976.74436118727}]
[null,{"$f":"Worksheet!B21","v":"Total Variable Costs %"},{"$f":"Worksheet!C21","v":0.62},{"$f":"Worksheet!D21","v":0.60291262135922308},{"$f":"Worksheet!E21","v":0.58904299583911235},{"$f":"Worksheet!F21","v":0.6128525196486363},{"$f":"Worksheet!G21","v":0.60181287751810519}]
[null,{"$f":"Worksheet!B22","v":"Gross Profit"},{"$f":"Worksheet!C22","v":190000},{"$f":"Worksheet!D22","v":222638.79724762007},{"$f":"Worksheet!E22","v":241935.97417287208},{"$f":"Worksheet!F22","v":242017.06535882293},{"$f":"Worksheet!G22","v":235530.61225977162}]
[null,{"$f":"Worksheet!B23","v":"Gross Profit %"},{"$f":"Worksheet!C23","v":0.38},{"$f":"Worksheet!D23","v":0.39708737864077692},{"$f":"Worksheet!E23","v":0.4109570041608876},{"$f":"Worksheet!F23","v":0.38714748035136376},{"$f":"Worksheet!G23","v":0.39818712248189486}]
[null,{"$f":"Worksheet!B24","v":"Mark-up Equivalent"},{"$f":"Worksheet!C24","v":0.61290322580645151},{"$f":"Worksheet!D24","v":0.65861513687600715},{"$f":"Worksheet!E24","v":0.69766894278314084},{"$f":"Worksheet!F24","v":0.63171394085697008},{"$f":"Worksheet!G24","v":0.66164606534182324}]
[null,{"$f":"Worksheet!B25","v":"Fixed Costs"}]
[null,{"$f":"Worksheet!B26","v":"Location"},{"$f":"Worksheet!C26","v":40000},{"$f":"Worksheet!D26","v":41213.592233009709},{"$f":"Worksheet!E26","v":41774.271844660194},{"$f":"Worksheet!F26","v":42502.577319587632},{"$f":"Worksheet!G26","v":41830.147132419173}]
[null,{"$f":"Worksheet!B27","v":"% Revenue"},{"$f":"Worksheet!C27","v":0.08},{"$f":"Worksheet!D27","v":7.3506493506493506E-2},{"$f":"Worksheet!E27","v":7.0958565244279528E-2},{"$f":"Worksheet!F27","v":6.7990105132962261E-2},{"$f":"Worksheet!G27","v":7.0717881467067131E-2}]
[null,{"$f":"Worksheet!B28","v":"Administration"},{"$f":"Worksheet!C28","v":30000},{"$f":"Worksheet!D28","v":30910.194174757282},{"$f":"Worksheet!E28","v":30716.376356367789},{"$f":"Worksheet!F28","v":29763.709607554363},{"$f":"Worksheet!G28","v":30463.426712893142}]
[null,{"$f":"Worksheet!B29","v":"% Revenue"},{"$f":"Worksheet!C29","v":0.06},{"$f":"Worksheet!D29","v":5.5129870129870133E-2},{"$f":"Worksheet!E29","v":5.2175415620793766E-2},{"$f":"Worksheet!F29","v":4.7612118440449762E-2},{"$f":"Worksheet!G29","v":5.150134883684003E-2}]
[null,{"$f":"Worksheet!B30","v":"Labor excluding Owner"},{"$f":"Worksheet!C30","v":50000},{"$f":"Worksheet!D30","v":51516.990291262133},{"$f":"Worksheet!E30","v":52729.779411764714},{"$f":"Worksheet!F30","v":53649.086567616738},{"$f":"Worksheet!G30","v":52631.95209021453}]
[null,{"$f":"Worksheet!B31","v":"% Revenue"},{"$f":"Worksheet!C31","v":0.1},{"$f":"Worksheet!D31","v":9.1883116883116872E-2},{"$f":"Worksheet!E31","v":8.9567796815695988E-2},{"$f":"Worksheet!F31","v":8.5820843488910697E-2},{"$f":"Worksheet!G31","v":8.8979370249728559E-2}]
[null,{"$f":"Worksheet!B32","v":"Labor Owner"},{"$f":"Worksheet!C32","v":10000},{"$f":"Worksheet!D32","v":10303.398058252427},{"$f":"Worksheet!E32","v":10545.955882352941},{"$f":"Worksheet!F32","v":10729.81731352335},{"$f":"Worksheet!G32","v":10526.390418042907}]
[null,{"$f":"Worksheet!B33","v":"% Revenue"},{"$f":"Worksheet!C33","v":0.02},{"$f":"Worksheet!D33","v":1.8376623376623376E-2},{"$f":"Worksheet!E33","v":1.7913559363139191E-2},{"$f":"Worksheet!F33","v":1.7164168697782142E-2},{"$f":"Worksheet!G33","v":1.7795874049945714E-2}]
[null,{"$f":"Worksheet!B34","v":"Interest Costs"},{"$f":"Worksheet!C34","v":0},{"$f":"Worksheet!D34","v":0},{"$f":"Worksheet!E34","v":0},{"$f":"Worksheet!F34","v":0},{"$f":"Worksheet!G34","v":0}]
[null,{"$f":"Worksheet!B35","v":"% Revenue"},{"$f":"Worksheet!C35","v":0},{"$f":"Worksheet!D35","v":0},{"$f":"Worksheet!E35","v":0},{"$f":"Worksheet!F35","v":0},{"$f":"Worksheet!G35","v":0}]
[null,{"$f":"Worksheet!B36","v":"Other"},{"$f":"Worksheet!C36","v":0},{"$f":"Worksheet!D36","v":0},{"$f":"Worksheet!E36","v":0},{"$f":"Worksheet!F36","v":0},{"$f":"Worksheet!G36","v":0}]
[null,{"$f":"Worksheet!B37","v":"% Revenue"},{"$f":"Worksheet!C37","v":0},{"$f":"Worksheet!D37","v":0},{"$f":"Worksheet!E37","v":0},{"$f":"Worksheet!F37","v":0},{"$f":"Worksheet!G37","v":0}]
[null,{"$f":"Worksheet!B38","v":"Total Fixed Costs"},{"$f":"Worksheet!C38","v":130000},{"$f":"Worksheet!D38","v":133944.17475728155},{"$f":"Worksheet!E38","v":135766.38349514565},{"$f":"Worksheet!F38","v":136645.19080828209},{"$f":"Worksheet!G38","v":135451.91635356974}]
[null,{"$f":"Worksheet!B39","v":"Total Fixed Costs %"},{"$f":"Worksheet!C39","v":0.26},{"$f":"Worksheet!D39","v":0.23889610389610388},{"$f":"Worksheet!E39","v":0.23061533704390849},{"$f":"Worksheet!F39","v":0.21858723576010486},{"$f":"Worksheet!G39","v":0.22899447460358141}]
[]
[null,{"$f":"Worksheet!B41","v":"Total Expenses"},{"$f":"Worksheet!C41","v":440000},{"$f":"Worksheet!D41","v":471984.98916014691},{"$f":"Worksheet!E41","v":482544.00155528332},{"$f":"Worksheet!F41","v":519756.99142884079},{"$f":"Worksheet!G41","v":491428.66071475699}]
[]
[null,{"$f":"Worksheet!B43","v":"Operating Surplus"},{"$f":"Worksheet!C43","v":60000},{"$f":"Worksheet!D43","v":88694.622490338515},{"$f":"Worksheet!E43","v":106169.59067772643},{"$f":"Worksheet!F43","v":105371.87455054082},{"$f":"Worksheet!G43","v":100078.69590620192}]
[null,{"$f":"Worksheet!B44","v":"Operating Surplus %"},{"$f":"Worksheet!C44","v":0.12},{"$f":"Worksheet!D44","v":0.15819127474467304},{"$f":"Worksheet!E44","v":0.18034166711697913},{"$f":"Worksheet!F44","v":0.16856024459125882},{"$f":"Worksheet!G44","v":0.16919264787831351}]
[]
[null,{"$f":"Worksheet!B46","v":"LESS"}]
[null,{"$f":"Worksheet!B47","v":"Depreciation Allowance"},{"$f":"Worksheet!C47","v":12500},{"$f":"Worksheet!D47","v":12879.247572815533},{"$f":"Worksheet!E47","v":13054.459951456311},{"$f":"Worksheet!F47","v":13282.055412371135},{"$f":"Worksheet!G47","v":13071.920978880991}]
[]
[null,{"$f":"Worksheet!B49","v":"Business Return"},{"$f":"Worksheet!C49","v":47500},{"$f":"Worksheet!D49","v":75815.374917522975},{"$f":"Worksheet!E49","v":93115.130726270116},{"$f":"Worksheet!F49","v":92089.819138169682},{"$f":"Worksheet!G49","v":87006.774927320934}]
[null,{"$f":"Worksheet!B50","v":"Business Return %"},{"$f":"Worksheet!C50","v":9.5000000000000001E-2},{"$f":"Worksheet!D50","v":0.13522049552389379},{"$f":"Worksheet!E50","v":0.15816711547814177},{"$f":"Worksheet!F50","v":0.14731333673720812},{"$f":"Worksheet!G50","v":0.14709330991985506}]

{"sheet":"Optimistic Results","index":5,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,1,1,6],[52,1,52,6],[53,1,53,6],[55,1,55,6],[54,1,54,6],[60,1,60,6],[61,1,61,6],[56,1,56,6],[57,1,57,6],[58,1,58,6],[59,1,59,6]]}
[]
[null,"Optimistic Results"]
[null,{"$f":"Worksheet!J2","v":"Optimistic Forecast improved by"},{"$f":"Worksheet!K2","v":0.2}]
[null,{"$f":"Worksheet!J3","v":"Acme Widgets"}]
[null,null,{"$f":"Worksheet!K4","v":"Current Year"},{"$f":"Worksheet!L4","v":"Year 1"},{"$f":"Worksheet!M4","v":"Year 2"},{"$f":"Worksheet!N4","v":"Year 3"},{"$f":"Worksheet!O4","v":"3 Year Average"}]
[null,{"$f":"Worksheet!J5","v":"Business Revenue"},{"$f":"Worksheet!K5","v":500000},{"$f":"Worksheet!L5","v":579687.5},{"$f":"Worksheet!M5","v":614468.75},{"$f":"Worksheet!N5","v":660362.68153526972},{"$f":"Worksheet!O5","v":618172.9771784232}]
[null,{"$f":"Worksheet!J6","v":"Expenses"}]
[null,{"$f":"Worksheet!J7","v":"Variable Costs"}]
[null,{"$f":"Worksheet!J8","v":"Materials & Supplies"},{"$f":"Worksheet!K8","v":10000},{"$f":"Worksheet!L8","v":11750.422297297297},{"$f":"Worksheet!M8","v":12337.943412162162},{"$f":"Worksheet!N8","v":13259.449559128632},{"$f":"Worksheet!O8","v":12449.271756196031}]
[null,{"$f":"Worksheet!J9","v":"% Revenue"},{"$f":"Worksheet!K9","v":0.02},{"$f":"Worksheet!L9","v":2.0270270270270268E-2},{"$f":"Worksheet!M9","v":2.0079041305456399E-2},{"$f":"Worksheet!N9","v":2.0079041305456402E-2},{"$f":"Worksheet!O9","v":2.013881585866022E-2}]
[null,{"$f":"Worksheet!J10","v":"Labor excluding Owner"},{"$f":"Worksheet!K10","v":200000},{"$f":"Worksheet!L10","v":230170.39695945947},{"$f":"Worksheet!M10","v":235320.77756314661},{"$f":"Worksheet!N10","v":265969.27342111943},{"$f":"Worksheet!O10","v":243820.14931457516}]
[null,{"$f":"Worksheet!J11","v":"% Revenue"},{"$f":"Worksheet!K11","v":0.4},{"$f":"Worksheet!L11","v":0.39705944488963357},{"$f":"Worksheet!M11","v":0.38296622499215233},{"$f":"Worksheet!N11","v":0.40276242261717526},{"$f":"Worksheet!O11","v":0.39442058827524806}]
[null,{"$f":"Worksheet!J12","v":"Labor Owner"},{"$f":"Worksheet!K12","v":50000},{"$f":"Worksheet!L12","v":49601.5625},{"$f":"Worksheet!M12","v":51165.708923339844},{"$f":"Worksheet!N12","v":54229.896703361861},{"$f":"Worksheet!O12","v":51665.722708900568}]
[null,{"$f":"Worksheet!J13","v":"% Revenue"},{"$f":"Worksheet!K13","v":0.1},{"$f":"Worksheet!L13","v":8.556603773584906E-2},{"$f":"Worksheet!M13","v":8.3268203506427052E-2},{"$f":"Worksheet!N13","v":8.2121383021347277E-2},{"$f":"Worksheet!O13","v":8.3578099684529394E-2}]
[null,{"$f":"Worksheet!J14","v":"Distribution"},{"$f":"Worksheet!K14","v":20000},{"$f":"Worksheet!L14","v":22381.756756756757},{"$f":"Worksheet!M14","v":22381.756756756753},{"$f":"Worksheet!N14","v":24053.423236514522},{"$f":"Worksheet!O14","v":22938.978916676006}]
[null,{"$f":"Worksheet!J15","v":"% Revenue"},{"$f":"Worksheet!K15","v":0.04},{"$f":"Worksheet!L15","v":3.8610038610038609E-2},{"$f":"Worksheet!M15","v":3.642456472645151E-2},{"$f":"Worksheet!N15","v":3.6424564726451517E-2},{"$f":"Worksheet!O15","v":3.7107702477352275E-2}]
[null,{"$f":"Worksheet!J16","v":"Marketing"},{"$f":"Worksheet!K16","v":10000},{"$f":"Worksheet!L16","v":11190.878378378378},{"$f":"Worksheet!M16","v":11190.878378378377},{"$f":"Worksheet!N16","v":12026.711618257261},{"$f":"Worksheet!O16","v":11469.489458338003}]
[null,{"$f":"Worksheet!J17","v":"% Revenue"},{"$f":"Worksheet!K17","v":0.02},{"$f":"Worksheet!L17","v":1.9305019305019305E-2},{"$f":"Worksheet!M17","v":1.8212282363225755E-2},{"$f":"Worksheet!N17","v":1.8212282363225758E-2},{"$f":"Worksheet!O17","v":1.8553851238676138E-2}]
[null,{"$f":"Worksheet!J18","v":"Other"},{"$f":"Worksheet!K18","v":20000},{"$f":"Worksheet!L18","v":22381.756756756757},{"$f":"Worksheet!M18","v":22381.756756756753},{"$f":"Worksheet!N18","v":24053.423236514522},{"$f":"Worksheet!O18","v":22938.978916676006}]
[null,{"$f":"Worksheet!J19","v":"% Revenue"},{"$f":"Worksheet!K19","v":0.04},{"$f":"Worksheet!L19","v":3.8610038610038609E-2},{"$f":"Worksheet!M19","v":3.642456472645151E-2},{"$f":"Worksheet!N19","v":3.6424564726451517E-2},{"$f":"Worksheet!O19","v":3.7107702477352275E-2}]
[null,{"$f":"Worksheet!J20","v":"Total Variable Costs"},{"$f":"Worksheet!K20","v":310000},{"$f":"Worksheet!L20","v":347476.7736486487},{"$f":"Worksheet!M20","v":354778.82179054053},{"$f":"Worksheet!N20","v":393592.1777748962},{"$f":"Worksheet!O20","v":365282.59107136185}]
[null,{"$f":"Worksheet!J21","v":"Total Variable Costs %"},{"$f":"Worksheet!K21","v":0.62},{"$f":"Worksheet!L21","v":0.5994208494208495},{"$f":"Worksheet!M21","v":0.57737488162016459},{"$f":"Worksheet!N21","v":0.59602425876010767},{"$f":"Worksheet!O21","v":0.59090676001181841}]
[null,{"$f":"Worksheet!J22","v":"Gross Profit"},{"$f":"Worksheet!K22","v":190000},{"$f":"Worksheet!L22","v":232210.7263513513},{"$f":"Worksheet!M22","v":259689.92820945947},{"$f":"Worksheet!N22","v":266770.50376037351},{"$f":"Worksheet!O22","v":252890.38610706135}]
[null,{"$f":"Worksheet!J23","v":"Gross Profit %"},{"$f":"Worksheet!K23","v":0.38},{"$f":"Worksheet!L23","v":0.4005791505791505},{"$f":"Worksheet!M23","v":0.42262511837983535},{"$f":"Worksheet!N23","v":0.40397574123989227},{"$f":"Worksheet!O23","v":0.40909323998818153}]
[null,{"$f":"Worksheet!J24","v":"Mark-up Equivalent"},{"$f":"Worksheet!K24","v":0.61290322580645151},{"$f":"Worksheet!L24","v":0.66827697262479857},{"$f":"Worksheet!M24","v":0.73197697342480872},{"$f":"Worksheet!N24","v":0.67778405879027726},{"$f":"Worksheet!O24","v":0.69231436780313604}]
[null,{"$f":"Worksheet!J25","v":"Fixed Costs"}]
[null,{"$f":"Worksheet!J26","v":"Location"},{"$f":"Worksheet!K26","v":40000},{"$f":"Worksheet!L26","v":41593.75},{"$f":"Worksheet!M26","v":42289.375},{"$f":"Worksheet!N26","v":43207.253630705396},{"$f":"Worksheet!O26","v":42363.459543568468}]
[null,{"$f":"Worksheet!J27","v":"% Revenue"},{"$f":"Worksheet!K27","v":0.08},{"$f":"Worksheet!L27","v":7.1752021563342316E-2},{"$f":"Worksheet!M27","v":6.8822661852209741E-2},{"$f":"Worksheet!N27","v":6.5429581105724124E-2},{"$f":"Worksheet!O27","v":6.8530105823990273E-2}]
[null,{"$f":"Worksheet!J28","v":"Administration"},{"$f":"Worksheet!K28","v":30000},{"$f":"Worksheet!L28","v":31195.3125},{"$f":"Worksheet!M28","v":30973.663330078125},{"$f":"Worksheet!N28","v":29854.658224341321},{"$f":"Worksheet!O28","v":30674.544684806478}]
[null,{"$f":"Worksheet!J29","v":"% Revenue"},{"$f":"Worksheet!K29","v":0.06},{"$f":"Worksheet!L29","v":5.3814016172506737E-2},{"$f":"Worksheet!M29","v":5.0407223036286426E-2},{"$f":"Worksheet!N29","v":4.520948723954625E-2},{"$f":"Worksheet!O29","v":4.9621296655212553E-2}]
[null,{"$f":"Worksheet!J30","v":"Labor excluding Owner"},{"$f":"Worksheet!K30","v":50000},{"$f":"Worksheet!L30","v":51992.1875},{"$f":"Worksheet!M30","v":53171.455383300781},{"$f":"Worksheet!N30","v":53300.516483190717},{"$f":"Worksheet!O30","v":52821.386455497159}]
[null,{"$f":"Worksheet!J31","v":"% Revenue"},{"$f":"Worksheet!K31","v":0.1},{"$f":"Worksheet!L31","v":8.9690026954177896E-2},{"$f":"Worksheet!M31","v":8.6532399545625027E-2},{"$f":"Worksheet!N31","v":8.0714004551669924E-2},{"$f":"Worksheet!O31","v":8.5447582481838785E-2}]
[null,{"$f":"Worksheet!J32","v":"Labor Owner"},{"$f":"Worksheet!K32","v":10000},{"$f":"Worksheet!L32","v":10398.4375},{"$f":"Worksheet!M32","v":10634.291076660156},{"$f":"Worksheet!N32","v":10660.103296638141},{"$f":"Worksheet!O32","v":10564.277291099432}]
[null,{"$f":"Worksheet!J33","v":"% Revenue"},{"$f":"Worksheet!K33","v":0.02},{"$f":"Worksheet!L33","v":1.7938005390835579E-2},{"$f":"Worksheet!M33","v":1.7306479909125008E-2},{"$f":"Worksheet!N33","v":1.6142800910333981E-2},{"$f":"Worksheet!O33","v":1.7089516496367755E-2}]
[null,{"$f":"Worksheet!J34","v":"Interest Costs"},{"$f":"Worksheet!K34","v":0},{"$f":"Worksheet!L34","v":0},{"$f":"Worksheet!M34","v":0},{"$f":"Worksheet!N34","v":0},{"$f":"Worksheet!O34","v":0}]
[null,{"$f":"Worksheet!J35","v":"% Revenue"},{"$f":"Worksheet!K35","v":0},{"$f":"Worksheet!L35","v":0},{"$f":"Worksheet!M35","v":0},{"$f":"Worksheet!N35","v":0},{"$f":"Worksheet!O35","v":0}]
[null,{"$f":"Worksheet!J36","v":"Other"},{"$f":"Worksheet!K36","v":0},{"$f":"Worksheet!L36","v":0},{"$f":"Worksheet!M36","v":0},{"$f":"Worksheet!N36","v":0},{"$f":"Worksheet!O36","v":0}]
[null,{"$f":"Worksheet!J37","v":"% Revenue"},{"$f":"Worksheet!K37","v":0},{"$f":"Worksheet!L37","v":0},{"$f":"Worksheet!M37","v":0},{"$f":"Worksheet!N37","v":0},{"$f":"Worksheet!O37","v":0}]
[null,{"$f":"Worksheet!J38","v":"Total Fixed Costs"},{"$f":"Worksheet!K38","v":130000},{"$f":"Worksheet!L38","v":135179.6875},{"$f":"Worksheet!M38","v":137068.78479003906},{"$f":"Worksheet!N38","v":137022.53163487557},{"$f":"Worksheet!O38","v":136423.66797497155}]
[null,{"$f":"Worksheet!J39","v":"Total Fixed Costs %"},{"$f":"Worksheet!K39","v":0.26},{"$f":"Worksheet!L39","v":0.23319407008086254},{"$f":"Worksheet!M39","v":0.22306876434324621},{"$f":"Worksheet!N39","v":0.20749587380727427},{"$f":"Worksheet!O39","v":0.2206885014574094}]
[]
[null,{"$f":"Worksheet!J41","v":"Total Expenses"},{"$f":"Worksheet!K41","v":440000},{"$f":"Worksheet!L41","v":482656.4611486487},{"$f":"Worksheet!M41","v":491847.6065805796},{"$f":"Worksheet!N41","v":530614.70940977172},{"$f":"Worksheet!O41","v":501706.25904633338}]
[]
[null,{"$f":"Worksheet!J43","v":"Operating Surplus"},{"$f":"Worksheet!K43","v":60000},{"$f":"Worksheet!L43","v":97031.038851351303},{"$f":"Worksheet!M43","v":122621.1434194204},{"$f":"Worksheet!N43","v":129747.972125498},{"$f":"Worksheet!O43","v":116466.7181320899}]
[null,{"$f":"Worksheet!J44","v":"Operating Surplus %"},{"$f":"Worksheet!K44","v":0.12},{"$f":"Worksheet!L44","v":0.16738508049828796},{"$f":"Worksheet!M44","v":0.19955635403658917},{"$f":"Worksheet!N44","v":0.19647986743261808},{"$f":"Worksheet!O44","v":0.1884047385307723}]
[]
[null,{"$f":"Worksheet!J46","v":"LESS"}]
[null,{"$f":"Worksheet!J47","v":"Depreciation Allowance"},{"$f":"Worksheet!K47","v":12500},{"$f":"Worksheet!L47","v":12998.046875},{"$f":"Worksheet!M47","v":13215.4296875},{"$f":"Worksheet!N47","v":13502.266759595435},{"$f":"Worksheet!O47","v":13238.581107365144}]
[]
[null,{"$f":"Worksheet!J49","v":"Business Return"},{"$f":"Worksheet!K49","v":47500},{"$f":"Worksheet!L49","v":84032.991976351303},{"$f":"Worksheet!M49","v":109405.7137319204},{"$f":"Worksheet!N49","v":116245.70536590256},{"$f":"Worksheet!O49","v":103228.13702472475}]
[null,{"$f":"Worksheet!J50","v":"Business Return %"},{"$f":"Worksheet!K50","v":9.5000000000000001E-2},{"$f":"Worksheet!L50","v":0.14496257375974347},{"$f":"Worksheet!M50","v":0.17804927220777364},{"$f":"Worksheet!N50","v":0.17603312333707929},{"$f":"Worksheet!O50","v":0.16698908046077535}]

{"sheet":"Pessimistic Results","index":6,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,1,1,6],[52,1,52,6],[53,1,53,6],[55,1,55,6],[54,1,54,6],[60,1,60,6],[61,1,61,6],[56,1,56,6],[57,1,57,6],[58,1,58,6],[59,1,59,6]]}
[]
[null,"Pessimistic Results"]
[null,{"$f":"Worksheet!Q2","v":"Pessimistic Forecast degraded by"},{"$f":"Worksheet!R2","v":0.2}]
[null,{"$f":"Worksheet!Q3","v":"Acme Widgets"}]
[null,null,{"$f":"Worksheet!R4","v":"Current Year"},{"$f":"Worksheet!S4","v":"Year 1"},{"$f":"Worksheet!T4","v":"Year 2"},{"$f":"Worksheet!U4","v":"Year 3"},{"$f":"Worksheet!V4","v":"3 Year Average"}]
[null,{"$f":"Worksheet!Q5","v":"Business Revenue"},{"$f":"Worksheet!R5","v":500000},{"$f":"Worksheet!S5","v":542084.94208494201},{"$f":"Worksheet!T5","v":563768.33976833976},{"$f":"Worksheet!U5","v":591494.65156022529},{"$f":"Worksheet!V5","v":565782.6444711691}]
[null,{"$f":"Worksheet!Q6","v":"Expenses"}]
[null,{"$f":"Worksheet!Q7","v":"Variable Costs"}]
[null,{"$f":"Worksheet!Q8","v":"Materials & Supplies"},{"$f":"Worksheet!R8","v":10000},{"$f":"Worksheet!S8","v":11116.97635135135},{"$f":"Worksheet!T8","v":11672.82516891892},{"$f":"Worksheet!U8","v":12246.898537882147},{"$f":"Worksheet!V8","v":11678.90001938414}]
[null,{"$f":"Worksheet!Q9","v":"% Revenue"},{"$f":"Worksheet!R9","v":0.02},{"$f":"Worksheet!S9","v":2.05078125E-2},{"$f":"Worksheet!T9","v":2.0705003004807696E-2},{"$f":"Worksheet!U9","v":2.0705003004807699E-2},{"$f":"Worksheet!V9","v":2.0642025932591627E-2}]
[null,{"$f":"Worksheet!Q10","v":"Labor excluding Owner"},{"$f":"Worksheet!R10","v":200000},{"$f":"Worksheet!S10","v":214900.33783783778},{"$f":"Worksheet!T10","v":222879.78046240841},{"$f":"Worksheet!U10","v":250882.66180386988},{"$f":"Worksheet!V10","v":229554.26003470537}]
[null,{"$f":"Worksheet!Q11","v":"% Revenue"},{"$f":"Worksheet!R11","v":0.4},{"$f":"Worksheet!S11","v":0.39643295940170936},{"$f":"Worksheet!T11","v":0.39533929939022971},{"$f":"Worksheet!U11","v":0.42415034716222672},{"$f":"Worksheet!V11","v":0.40572870567506936}]
[null,{"$f":"Worksheet!Q12","v":"Labor Owner"},{"$f":"Worksheet!R12","v":50000},{"$f":"Worksheet!S12","v":49789.575289575288},{"$f":"Worksheet!T12","v":51338.969537591584},{"$f":"Worksheet!U12","v":54084.551310884242},{"$f":"Worksheet!V12","v":51737.698712683712}]
[null,{"$f":"Worksheet!Q13","v":"% Revenue"},{"$f":"Worksheet!R13","v":0.1},{"$f":"Worksheet!S13","v":9.1848290598290611E-2},{"$f":"Worksheet!T13","v":9.1063945802077995E-2},{"$f":"Worksheet!U13","v":9.1437092741619513E-2},{"$f":"Worksheet!V13","v":9.1444478225454193E-2}]
[null,{"$f":"Worksheet!Q14","v":"Distribution"},{"$f":"Worksheet!R14","v":20000},{"$f":"Worksheet!S14","v":21175.193050193047},{"$f":"Worksheet!T14","v":21175.193050193051},{"$f":"Worksheet!U14","v":22216.595987087789},{"$f":"Worksheet!V14","v":21522.327362491294}]
[null,{"$f":"Worksheet!Q15","v":"% Revenue"},{"$f":"Worksheet!R15","v":0.04},{"$f":"Worksheet!S15","v":3.90625E-2},{"$f":"Worksheet!T15","v":3.7560096153846152E-2},{"$f":"Worksheet!U15","v":3.7560096153846152E-2},{"$f":"Worksheet!V15","v":3.8039921465968581E-2}]
[null,{"$f":"Worksheet!Q16","v":"Marketing"},{"$f":"Worksheet!R16","v":10000},{"$f":"Worksheet!S16","v":10587.596525096524},{"$f":"Worksheet!T16","v":10587.596525096526},{"$f":"Worksheet!U16","v":11108.297993543894},{"$f":"Worksheet!V16","v":10761.163681245647}]
[null,{"$f":"Worksheet!Q17","v":"% Revenue"},{"$f":"Worksheet!R17","v":0.02},{"$f":"Worksheet!S17","v":1.953125E-2},{"$f":"Worksheet!T17","v":1.8780048076923076E-2},{"$f":"Worksheet!U17","v":1.8780048076923076E-2},{"$f":"Worksheet!V17","v":1.901996073298429E-2}]
[null,{"$f":"Worksheet!Q18","v":"Other"},{"$f":"Worksheet!R18","v":20000},{"$f":"Worksheet!S18","v":21175.193050193047},{"$f":"Worksheet!T18","v":21175.193050193051},{"$f":"Worksheet!U18","v":22216.595987087789},{"$f":"Worksheet!V18","v":21522.327362491294}]
[null,{"$f":"Worksheet!Q19","v":"% Revenue"},{"$f":"Worksheet!R19","v":0.04},{"$f":"Worksheet!S19","v":3.90625E-2},{"$f":"Worksheet!T19","v":3.7560096153846152E-2},{"$f":"Worksheet!U19","v":3.7560096153846152E-2},{"$f":"Worksheet!V19","v":3.8039921465968581E-2}]
[null,{"$f":"Worksheet!Q20","v":"Total Variable Costs"},{"$f":"Worksheet!R20","v":310000},{"$f":"Worksheet!S20","v":328744.8721042471},{"$f":"Worksheet!T20","v":338829.55779440154},{"$f":"Worksheet!U20","v":372755.6016203558},{"$f":"Worksheet!V20","v":346776.67717300146}]
[null,{"$f":"Worksheet!Q21","v":"Total Variable Costs %"},{"$f":"Worksheet!R21","v":0.62},{"$f":"Worksheet!S21","v":0.60644531250000011},{"$f":"Worksheet!T21","v":0.60100848858173073},{"$f":"Worksheet!U21","v":0.63019268329326938},{"$f":"Worksheet!V21","v":0.61291501349803656}]
[null,{"$f":"Worksheet!Q22","v":"Gross Profit"},{"$f":"Worksheet!R22","v":190000},{"$f":"Worksheet!S22","v":213340.06998069491},{"$f":"Worksheet!T22","v":224938.78197393822},{"$f":"Worksheet!U22","v":218739.0499398695},{"$f":"Worksheet!V22","v":219005.96729816764}]
[null,{"$f":"Worksheet!Q23","v":"Gross Profit %"},{"$f":"Worksheet!R23","v":0.38},{"$f":"Worksheet!S23","v":0.39355468749999994},{"$f":"Worksheet!T23","v":0.39899151141826922},{"$f":"Worksheet!U23","v":0.36980731670673062},{"$f":"Worksheet!V23","v":0.38708498650196338}]
[null,{"$f":"Worksheet!Q24","v":"Mark-up Equivalent"},{"$f":"Worksheet!R24","v":0.61290322580645151},{"$f":"Worksheet!S24","v":0.64895330112721394},{"$f":"Worksheet!T24","v":0.66387001015545666},{"$f":"Worksheet!U24","v":0.58681626510512075},{"$f":"Worksheet!V24","v":0.6315475685491645}]
[null,{"$f":"Worksheet!Q25","v":"Fixed Costs"}]
[null,{"$f":"Worksheet!Q26","v":"Location"},{"$f":"Worksheet!R26","v":40000},{"$f":"Worksheet!S26","v":40841.698841698839},{"$f":"Worksheet!T26","v":41275.366795366797},{"$f":"Worksheet!U26","v":41829.893031204505},{"$f":"Worksheet!V26","v":41315.652889423385}]
[null,{"$f":"Worksheet!Q27","v":"% Revenue"},{"$f":"Worksheet!R27","v":0.08},{"$f":"Worksheet!S27","v":7.5341880341880343E-2},{"$f":"Worksheet!T27","v":7.3213346482577255E-2},{"$f":"Worksheet!U27","v":7.0718970866206446E-2},{"$f":"Worksheet!V27","v":7.3023895824942953E-2}]
[null,{"$f":"Worksheet!Q28","v":"Administration"},{"$f":"Worksheet!R28","v":30000},{"$f":"Worksheet!S28","v":30631.274131274131},{"$f":"Worksheet!T28","v":30469.020764296354},{"$f":"Worksheet!U28","v":29690.736460292417},{"$f":"Worksheet!V28","v":30263.677118620966}]
[null,{"$f":"Worksheet!Q29","v":"% Revenue"},{"$f":"Worksheet!R29","v":0.06},{"$f":"Worksheet!S29","v":5.6506410256410261E-2},{"$f":"Worksheet!T29","v":5.4045285297178086E-2},{"$f":"Worksheet!U29","v":5.0196119917526157E-2},{"$f":"Worksheet!V29","v":5.3489935427248919E-2}]
[null,{"$f":"Worksheet!Q30","v":"Labor excluding Owner"},{"$f":"Worksheet!R30","v":50000},{"$f":"Worksheet!S30","v":51052.12355212355},{"$f":"Worksheet!T30","v":52305.152312042075},{"$f":"Worksheet!U30","v":54027.243445578766},{"$f":"Worksheet!V30","v":52461.506436581461}]
[null,{"$f":"Worksheet!Q31","v":"% Revenue"},{"$f":"Worksheet!R31","v":0.1},{"$f":"Worksheet!S31","v":9.417735042735044E-2},{"$f":"Worksheet!T31","v":9.2777739760155714E-2},{"$f":"Worksheet!U31","v":9.1340206209925084E-2},{"$f":"Worksheet!V31","v":9.272378173709564E-2}]
[null,{"$f":"Worksheet!Q32","v":"Labor Owner"},{"$f":"Worksheet!R32","v":10000},{"$f":"Worksheet!S32","v":10210.42471042471},{"$f":"Worksheet!T32","v":10461.030462408416},{"$f":"Worksheet!U32","v":10805.448689115756},{"$f":"Worksheet!V32","v":10492.301287316295}]
[null,{"$f":"Worksheet!Q33","v":"% Revenue"},{"$f":"Worksheet!R33","v":0.02},{"$f":"Worksheet!S33","v":1.8835470085470086E-2},{"$f":"Worksheet!T33","v":1.8555547952031147E-2},{"$f":"Worksheet!U33","v":1.8268041241985021E-2},{"$f":"Worksheet!V33","v":1.8544756347419131E-2}]
[null,{"$f":"Worksheet!Q34","v":"Interest Costs"},{"$f":"Worksheet!R34","v":0},{"$f":"Worksheet!S34","v":0},{"$f":"Worksheet!T34","v":0},{"$f":"Worksheet!U34","v":0},{"$f":"Worksheet!V34","v":0}]
[null,{"$f":"Worksheet!Q35","v":"% Revenue"},{"$f":"Worksheet!R35","v":0},{"$f":"Worksheet!S35","v":0},{"$f":"Worksheet!T35","v":0},{"$f":"Worksheet!U35","v":0},{"$f":"Worksheet!V35","v":0}]
[null,{"$f":"Worksheet!Q36","v":"Other"},{"$f":"Worksheet!R36","v":0},{"$f":"Worksheet!S36","v":0},{"$f":"Worksheet!T36","v":0},{"$f":"Worksheet!U36","v":0},{"$f":"Worksheet!V36","v":0}]
[null,{"$f":"Worksheet!Q37","v":"% Revenue"},{"$f":"Worksheet!R37","v":0},{"$f":"Worksheet!S37","v":0},{"$f":"Worksheet!T37","v":0},{"$f":"Worksheet!U37","v":0},{"$f":"Worksheet!V37","v":0}]
[null,{"$f":"Worksheet!Q38","v":"Total Fixed Costs"},{"$f":"Worksheet!R38","v":130000},{"$f":"Worksheet!S38","v":132735.52123552124},{"$f":"Worksheet!T38","v":134510.57033411364},{"$f":"Worksheet!U38","v":136353.32162619143},{"$f":"Worksheet!V38","v":134533.13773194209}]
[null,{"$f":"Worksheet!Q39","v":"Total Fixed Costs %"},{"$f":"Worksheet!R39","v":0.26},{"$f":"Worksheet!S39","v":0.24486111111111117},{"$f":"Worksheet!T39","v":0.23859191949194219},{"$f":"Worksheet!U39","v":0.23052333823564269},{"$f":"Worksheet!V39","v":0.2377823693367066}]
[]
[null,{"$f":"Worksheet!Q41","v":"Total Expenses"},{"$f":"Worksheet!R41","v":440000},{"$f":"Worksheet!S41","v":461480.39333976834},{"$f":"Worksheet!T41","v":473340.12812851521},{"$f":"Worksheet!U41","v":509108.92324654723},{"$f":"Worksheet!V41","v":481309.81490494357}]
[]
[null,{"$f":"Worksheet!Q43","v":"Operating Surplus"},{"$f":"Worksheet!R43","v":60000},{"$f":"Worksheet!S43","v":80604.54874517367},{"$f":"Worksheet!T43","v":90428.211639824556},{"$f":"Worksheet!U43","v":82385.728313678061},{"$f":"Worksheet!V43","v":84472.829566225424}]
[null,{"$f":"Worksheet!Q44","v":"Operating Surplus %"},{"$f":"Worksheet!R44","v":0.12},{"$f":"Worksheet!S44","v":0.14869357638888878},{"$f":"Worksheet!T44","v":0.16039959192632697},{"$f":"Worksheet!U44","v":0.13928397847108789},{"$f":"Worksheet!V44","v":0.14930261716525656}]
[]
[null,{"$f":"Worksheet!Q46","v":"LESS"}]
[null,{"$f":"Worksheet!Q47","v":"Depreciation Allowance"},{"$f":"Worksheet!R47","v":12500},{"$f":"Worksheet!S47","v":12763.030888030888},{"$f":"Worksheet!T47","v":12898.552123552123},{"$f":"Worksheet!U47","v":13071.841572251407},{"$f":"Worksheet!V47","v":12911.141527944807}]
[]
[null,{"$f":"Worksheet!Q49","v":"Business Return"},{"$f":"Worksheet!R49","v":47500},{"$f":"Worksheet!S49","v":67841.517857142782},{"$f":"Worksheet!T49","v":77529.659516272426},{"$f":"Worksheet!U49","v":69313.886741426657},{"$f":"Worksheet!V49","v":71561.688038280627}]
[null,{"$f":"Worksheet!Q50","v":"Business Return %"},{"$f":"Worksheet!R50","v":9.5000000000000001E-2},{"$f":"Worksheet!S50","v":0.12514923878205117},{"$f":"Worksheet!T50","v":0.13752042115052157},{"$f":"Worksheet!U50","v":0.1171843000753984},{"$f":"Worksheet!V50","v":0.12648264971996193}]

{"sheet":"Budget by Month Master","index":11,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[69,1,69,16],[66,1,66,16],[67,1,67,16],[68,1,68,16],[64,1,64,16],[65,1,65,16],[63,1,63,16],[62,1,62,16],[1,1,1,16],[60,1,60,16],[4,3,4,15],[4,2,5,2],[61,1,61,16]]}
[]
[null,"Budget by Month Master"]
[null,"Budget by Month Master",null,{"$f":"+D$7/$P$7*D$9/(1/12)","v":1.0000000000000002E-2},{"$f":"+E$7/$P$7*E$9/(1/12)","v":2.769230769230769E-2},4.8461538461538466E-2,4.492307692307692E-2,7.0769230769230765E-2,7.6615384615384627E-2,9.6923076923076931E-2,0.10953846153846153,0.11769230769230771,0.13076923076923078,0.13369230769230769,0.11815384615384647,{"$f":"SUM(D3:O3)","v":0.98523076923076958}]
[null,{"$f":"Worksheet!B3","v":"Acme Widgets"}]
[null,{"$f":"+Worksheet!B4","v":"Expected"},{"$f":"Worksheet!C4","v":"Current Year"},"Budget Year"]
[null,"Budget Month",null,"2022-07-01",{"$f":"+D6+31","v":"2022-08-01"},{"$f":"+E6+31","v":"2022-09-01"},"2022-10-02","2022-11-02","2022-12-03","2023-01-03","2023-02-03","2023-03-06","2023-04-06","2023-05-07","2023-06-07","Full Year","Variation Year/Year"]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,{"$f":"SUM(D7:O7)","v":78}]
[null,"Base Revenue",{"$f":"Worksheet!C5","v":500000},{"$f":"+$C8*D9","v":32500},{"$f":"+$C8*E9","v":45000},52500,36500,46000,41500,45000,44500,42500,42500,39500,32000.000000000084,{"$f":"+C8","v":500000}]
[null,"Percentage Contributor",null,6.5000000000000002E-2,0.09,0.105,7.2999999999999995E-2,9.1999999999999998E-2,8.3000000000000004E-2,0.09,8.8999999999999996E-2,8.5000000000000006E-2,8.5000000000000006E-2,7.9000000000000001E-2,{"$f":"+P9-SUM(D9:N9)","v":6.4000000000000168E-2},1]
[null,"Growth Revenue",null,{"$f":"+D11*$P$10","v":615.89237309205998},{"$f":"+E11*$P$10","v":1705.5481101010889},2984.7091926769058,2766.7780452750994,4358.6229480361153,4718.6831046130128,5969.4183853538116,6746.3903021776396,7248.5794679296287,8053.9771865884768,8234.0072648769237,7277.0052697646661,{"$f":"+P12-P8","v":60679.611650485429}]
[null,null,null,{"$f":"+D3/$P$3","v":1.0149906308557151E-2},{"$f":"+E3/$P$3","v":2.8107432854465948E-2},4.9188007495315413E-2,4.5596502186133647E-2,7.1830106183635195E-2,7.7763897564022466E-2,9.8376014990630825E-2,0.11118051217988752,0.1194565896314803,0.13272954403497811,0.13569643972517173,0.11992504684572171,{"$f":"SUM(D11:O11)","v":1}]
[null,"Total Revenue",{"$f":"+C8","v":500000},{"$f":"+D8+D10","v":33115.892373092058},{"$f":"+E8+E10","v":46705.548110101088},55484.709192676906,39266.778045275103,50358.622948036114,46218.68310461301,50969.418385353812,51246.390302177642,49748.57946792963,50553.977186588476,47734.007264876927,39277.005269764748,{"$f":"Worksheet!$D5","v":560679.61165048543},{"$f":"+P12-C12","v":60679.611650485429}]
[null,null,null,{"$f":"+D12/$P12","v":5.9063842674086271E-2},{"$f":"+E12/$P12","v":8.3301670222344804E-2},9.8959741070921578E-2,7.0034253483347797E-2,8.981711105883497E-2,8.2433322247188578E-2,9.0906495128856152E-2,9.140048833115666E-2,8.8729068141935097E-2,9.0165535068720576E-2,8.5135978325235034E-2,7.0052494247372629E-2,1,{"$f":"+Q12/C12","v":0.12135922330097086}]
[]
[null,{"$f":"Worksheet!B6","v":"Expenses"}]
[null,{"$f":"Worksheet!B7","v":"Variable Costs"}]
[null,{"$f":"Worksheet!B8","v":"Materials & Supplies"},{"$f":"Worksheet!C8","v":10000},{"$f":"+D$13*$P17","v":675.17838818925566},{"$f":"+E$13*$P17","v":952.24903913798357},1131.2416437341894,800.58479509784195,1026.7292057366587,942.32266523968292,1039.1823165945925,1044.8293168405153,1014.2914260451673,1030.7121562314157,973.21762384700537,800.79331132530081,{"$f":"Worksheet!D8","v":11431.331888019608},{"$f":"+P17-C17","v":1431.3318880196075}]
[null,{"$f":"Worksheet!B9","v":"% Revenue"},{"$f":"Worksheet!C9","v":0.02},{"$f":"+D17/D$12","v":2.0388349514563111E-2},{"$f":"+E17/E$12","v":2.0388349514563111E-2},2.0388349514563107E-2,2.0388349514563107E-2,2.0388349514563107E-2,2.0388349514563111E-2,2.0388349514563111E-2,2.0388349514563111E-2,2.0388349514563107E-2,2.0388349514563111E-2,2.0388349514563107E-2,2.0388349514563111E-2,{"$f":"Worksheet!D9","v":2.0388349514563111E-2},{"$f":"+Q17/C17","v":0.14313318880196074}]
[null,{"$f":"Worksheet!B10","v":"Labor excluding Owner"},{"$f":"Worksheet!C10","v":200000},{"$f":"+D$13*$P19","v":13140.403630743918},{"$f":"+E$13*$P19","v":18532.786223829386},22016.361990554029,15581.078322775418,19982.328254071785,18339.597931823824,20224.692207056873,20334.594810327897,19740.262678106319,20059.844919382624,18940.879361083,15585.136490868919,{"$f":"Worksheet!D10","v":222477.96682062396},{"$f":"+P19-C19","v":22477.966820623958}]
[null,{"$f":"Worksheet!B11","v":"% Revenue"},{"$f":"Worksheet!C11","v":0.4},{"$f":"+D19/D$12","v":0.39680052956751977},{"$f":"+E19/E$12","v":0.39680052956751982},0.39680052956751977,0.39680052956751971,0.39680052956751977,0.39680052956751982,0.39680052956751982,0.39680052956751977,0.39680052956751977,0.39680052956751982,0.39680052956751977,0.39680052956751982,{"$f":"Worksheet!D11","v":0.39680052956751977},{"$f":"+Q19/C19","v":0.1123898341031198}]
[null,{"$f":"Worksheet!B12","v":"Labor Owner"},{"$f":"Worksheet!C12","v":50000},{"$f":"+D$13*$P21","v":2935.272278524069},{"$f":"+E$13*$P21","v":4139.8099461225975},4917.9628602599987,3480.4644176493839,4463.6052158486555,4096.656002454336,4517.7439023381794,4542.2936858748371,4409.5331801119446,4480.9207051748881,4230.9688257504549,3481.3709216382395,{"$f":"Worksheet!D12","v":49696.601941747576},{"$f":"+P21-C21","v":-303.39805825242365}]
[null,{"$f":"Worksheet!B13","v":"% Revenue"},{"$f":"Worksheet!C13","v":0.1},{"$f":"+D21/D$12","v":8.8636363636363638E-2},{"$f":"+E21/E$12","v":8.8636363636363652E-2},8.8636363636363638E-2,8.8636363636363624E-2,8.8636363636363638E-2,8.8636363636363652E-2,8.8636363636363652E-2,8.8636363636363652E-2,8.8636363636363638E-2,8.8636363636363652E-2,8.8636363636363638E-2,8.8636363636363652E-2,{"$f":"Worksheet!D13","v":8.8636363636363638E-2},{"$f":"+Q21/C21","v":-6.0679611650484733E-3}]
[null,{"$f":"Worksheet!B14","v":"Distribution"},{"$f":"Worksheet!C14","v":20000},{"$f":"+D$13*$P23","v":1286.0540727414391},{"$f":"+E$13*$P23","v":1813.8076935961587},2154.7459880651222,1524.9234192339843,1955.6746775936354,1794.9003147422529,1979.3948887516044,1990.1510796962191,1931.9836686574613,1963.2612499646011,1853.7478549466766,1525.3205930005729,{"$f":"Worksheet!D14","v":21773.965500989725},{"$f":"+P23-C23","v":1773.9655009897251}]
[null,{"$f":"Worksheet!B15","v":"% Revenue"},{"$f":"Worksheet!C15","v":0.04},{"$f":"+D23/D$12","v":3.8834951456310676E-2},{"$f":"+E23/E$12","v":3.8834951456310676E-2},3.8834951456310676E-2,3.8834951456310669E-2,3.8834951456310676E-2,3.8834951456310683E-2,3.8834951456310683E-2,3.8834951456310676E-2,3.8834951456310676E-2,3.8834951456310683E-2,3.8834951456310676E-2,3.8834951456310683E-2,{"$f":"Worksheet!D15","v":3.8834951456310676E-2},{"$f":"+Q23/C23","v":8.8698275049486255E-2}]
[null,{"$f":"Worksheet!B16","v":"Marketing"},{"$f":"Worksheet!C16","v":10000},{"$f":"+D$13*$P25","v":643.02703637071954},{"$f":"+E$13*$P25","v":906.90384679807937},1077.3729940325611,762.46170961699215,977.83733879681768,897.45015737112647,989.69744437580221,995.07553984810954,965.99183432873065,981.63062498230056,926.87392747333831,762.66029650028645,{"$f":"Worksheet!D16","v":10886.982750494863},{"$f":"+P25-C25","v":886.98275049486256}]
[null,{"$f":"Worksheet!B17","v":"% Revenue"},{"$f":"Worksheet!C17","v":0.02},{"$f":"+D25/D$12","v":1.9417475728155338E-2},{"$f":"+E25/E$12","v":1.9417475728155338E-2},1.9417475728155338E-2,1.9417475728155335E-2,1.9417475728155338E-2,1.9417475728155342E-2,1.9417475728155342E-2,1.9417475728155338E-2,1.9417475728155338E-2,1.9417475728155342E-2,1.9417475728155338E-2,1.9417475728155342E-2,{"$f":"Worksheet!D17","v":1.9417475728155338E-2},{"$f":"+Q25/C25","v":8.8698275049486255E-2}]
[null,{"$f":"Worksheet!B18","v":"Other"},{"$f":"Worksheet!C18","v":20000},{"$f":"+D$13*$P27","v":1286.0540727414391},{"$f":"+E$13*$P27","v":1813.8076935961587},2154.7459880651222,1524.9234192339843,1955.6746775936354,1794.9003147422529,1979.3948887516044,1990.1510796962191,1931.9836686574613,1963.2612499646011,1853.7478549466766,1525.3205930005729,{"$f":"Worksheet!D18","v":21773.965500989725},{"$f":"+P27-C27","v":1773.9655009897251}]
[null,{"$f":"Worksheet!B19","v":"% Revenue"},{"$f":"Worksheet!C19","v":0.04},{"$f":"+D27/D$12","v":3.8834951456310676E-2},{"$f":"+E27/E$12","v":3.8834951456310676E-2},3.8834951456310676E-2,3.8834951456310669E-2,3.8834951456310676E-2,3.8834951456310683E-2,3.8834951456310683E-2,3.8834951456310676E-2,3.8834951456310676E-2,3.8834951456310683E-2,3.8834951456310676E-2,3.8834951456310683E-2,{"$f":"Worksheet!D19","v":3.8834951456310676E-2},{"$f":"+Q27/C27","v":8.8698275049486255E-2}]
[null,{"$f":"Worksheet!B20","v":"Total Variable Costs"},{"$f":"Worksheet!C20","v":310000},{"$f":"+D17+D19+D21+D23+D25+D27","v":19965.98947931084},{"$f":"+E17+E19+E21+E23+E25+E27","v":28159.364443080362},33452.431464711022,23674.436083607605,30361.849369641182,27865.827386373476,30730.105647868659,30897.095512283791,29994.046455907086,30479.630905700433,28779.435448047152,23680.602206333886,{"$f":"Worksheet!D20","v":338040.81440286536},{"$f":"+P29-C29","v":28040.814402865362}]
[null,{"$f":"Worksheet!B21","v":"Total Variable Costs %"},{"$f":"Worksheet!C21","v":0.62},{"$f":"+D29/D$12","v":0.60291262135922319},{"$f":"+E29/E$12","v":0.60291262135922319},0.60291262135922319,0.60291262135922319,0.60291262135922308,0.6029126213592233,0.6029126213592233,0.60291262135922308,0.6029126213592233,0.6029126213592233,0.60291262135922319,0.60291262135922319,{"$f":"Worksheet!D21","v":0.60291262135922308},{"$f":"+Q29/C29","v":9.0454240009243098E-2}]
[null,{"$f":"Worksheet!B22","v":"Gross Profit"},{"$f":"Worksheet!C22","v":190000},{"$f":"+D12-D29","v":13149.902893781218},{"$f":"+E12-E29","v":18546.183667020727},22032.277727965884,15592.341961667498,19996.773578394932,18352.855718239534,20239.312737485154,20349.294789893851,19754.533012022544,20074.346280888043,18954.571816829775,15596.403063430862,{"$f":"Worksheet!D22","v":222638.79724762007},{"$f":"+P31-C31","v":32638.797247620067}]
[null,{"$f":"Worksheet!B23","v":"Gross Profit %"},{"$f":"Worksheet!C23","v":0.38},{"$f":"+D31/D12","v":0.39708737864077681},{"$f":"+E31/E12","v":0.39708737864077676},0.39708737864077681,0.39708737864077687,0.39708737864077687,0.3970873786407767,0.3970873786407767,0.39708737864077692,0.39708737864077676,0.39708737864077664,0.39708737864077681,0.39708737864077687,{"$f":"Worksheet!D23","v":0.39708737864077692},{"$f":"+Q31/C31","v":0.17178314340852666}]
[null,{"$f":"Worksheet!B24","v":"Mark-up Equivalent"},{"$f":"Worksheet!C24","v":0.61290322580645151},{"$f":"IF(D12=0,0,+D12/D29-1)","v":0.6586151368760067},{"$f":"IF(E12=0,0,+E12/E29-1)","v":0.6586151368760067},0.6586151368760067,0.65861513687600692,0.65861513687600692,0.65861513687600648,0.65861513687600648,0.65861513687600692,0.65861513687600648,0.65861513687600626,0.6586151368760067,0.65861513687600692,{"$f":"Worksheet!D24","v":0.65861513687600715},{"$f":"+Q32/C32","v":0.45206090370664909}]
[null,{"$f":"Worksheet!B25","v":"Fixed Costs"}]
[null,{"$f":"Worksheet!B26","v":"Location"},{"$f":"Worksheet!C26","v":40000},{"$f":"+$P35/12","v":3434.4660194174758},{"$f":"+$P35/12","v":3434.4660194174758},3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,{"$f":"Worksheet!D26","v":41213.592233009709},{"$f":"+P35-C35","v":1213.5922330097092}]
[null,{"$f":"Worksheet!B27","v":"% Revenue"},{"$f":"Worksheet!C27","v":0.08},{"$f":"+D35/D$12","v":0.10371050795563377},{"$f":"+E35/E$12","v":7.3534433453628562E-2},6.1899324505620197E-2,8.7464930671355107E-2,6.8200157557156013E-2,7.4309041035284004E-2,6.7382876403478398E-2,6.7018691446674106E-2,6.9036464078969351E-2,6.7936613705807683E-2,7.1950087918652164E-2,8.7442155933953325E-2,{"$f":"Worksheet!D27","v":7.3506493506493506E-2},{"$f":"+Q35/C35","v":3.0339805825242729E-2}]
[null,{"$f":"Worksheet!B28","v":"Administration"},{"$f":"Worksheet!C28","v":30000},{"$f":"+$P37/12","v":2575.8495145631068},{"$f":"+$P37/12","v":2575.8495145631068},2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,{"$f":"Worksheet!D28","v":30910.194174757282},{"$f":"+P37-C37","v":910.19417475728187}]
[null,{"$f":"Worksheet!B29","v":"% Revenue"},{"$f":"Worksheet!C29","v":0.06},{"$f":"+D37/D$12","v":7.7782880966725337E-2},{"$f":"+E37/E$12","v":5.5150825090221421E-2},4.642449337921515E-2,6.5598698003516337E-2,5.1150118167867013E-2,5.5731780776463007E-2,5.0537157302608805E-2,5.0264018585005579E-2,5.1777348059227006E-2,5.0952460279355766E-2,5.396256593898912E-2,6.5581616950464994E-2,{"$f":"Worksheet!D29","v":5.5129870129870133E-2},{"$f":"+Q37/C37","v":3.0339805825242729E-2}]
[null,{"$f":"Worksheet!B30","v":"Labor excluding Owner"},{"$f":"Worksheet!C30","v":50000},{"$f":"+$P39/12","v":4293.0825242718447},{"$f":"+$P39/12","v":4293.0825242718447},4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,{"$f":"Worksheet!D30","v":51516.990291262133},{"$f":"+P39-C39","v":1516.9902912621328}]
[null,{"$f":"Worksheet!B31","v":"% Revenue"},{"$f":"Worksheet!C31","v":0.1},{"$f":"+D39/D$12","v":0.12963813494454221},{"$f":"+E39/E$12","v":9.1918041817035709E-2},7.7374155632025238E-2,0.10933116333919389,8.525019694644502E-2,9.2886301294105009E-2,8.4228595504348011E-2,8.3773364308342632E-2,8.6295580098711674E-2,8.4920767132259614E-2,8.9937609898315202E-2,0.10930269491744166,{"$f":"Worksheet!D31","v":9.1883116883116872E-2},{"$f":"+Q39/C39","v":3.0339805825242656E-2}]
[null,{"$f":"Worksheet!B32","v":"Labor Owner"},{"$f":"Worksheet!C32","v":10000},{"$f":"+$P41/12","v":858.61650485436894},{"$f":"+$P41/12","v":858.61650485436894},858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,{"$f":"Worksheet!D32","v":10303.398058252427},{"$f":"+P41-C41","v":303.39805825242729}]
[null,{"$f":"Worksheet!B33","v":"% Revenue"},{"$f":"Worksheet!C33","v":0.02},{"$f":"+D41/D$12","v":2.5927626988908443E-2},{"$f":"+E41/E$12","v":1.838360836340714E-2},1.5474831126405049E-2,2.1866232667838777E-2,1.7050039389289003E-2,1.8577260258821001E-2,1.6845719100869599E-2,1.6754672861668526E-2,1.7259116019742338E-2,1.6984153426451921E-2,1.7987521979663041E-2,2.1860538983488331E-2,{"$f":"Worksheet!D33","v":1.8376623376623376E-2},{"$f":"+Q41/C41","v":3.0339805825242729E-2}]
[null,{"$f":"Worksheet!B34","v":"Interest Costs"},{"$f":"Worksheet!C34","v":0},{"$f":"+$P43/12","v":0},{"$f":"+$P43/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Worksheet!D34","v":0},{"$f":"+P43-C43","v":0}]
[null,{"$f":"Worksheet!B35","v":"% Revenue"},{"$f":"Worksheet!C35","v":0},{"$f":"+D43/D$12","v":0},{"$f":"+E43/E$12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Worksheet!D35","v":0},{"$f":"+Q43/C43","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Worksheet!B36","v":"Other"},{"$f":"Worksheet!C36","v":0},{"$f":"+$P45/12","v":0},{"$f":"+$P45/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Worksheet!D36","v":0},{"$f":"+P45-C45","v":0}]
[null,{"$f":"Worksheet!B37","v":"% Revenue"},{"$f":"Worksheet!C37","v":0},{"$f":"+D45/D$12","v":0},{"$f":"+E45/E$12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Worksheet!D37","v":0},{"$f":"+Q45/C45","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Worksheet!B38","v":"Total Fixed Costs"},{"$f":"Worksheet!C38","v":130000},{"$f":"+D35+D37+D39+D41+D43+D45","v":11162.014563106797},{"$f":"+E35+E37+E39+E41+E43+E45","v":11162.014563106797},11162.014563106797,11162.014563106797,11162.014563106797,11162.014563106797,11162.014563106797,11162.014563106797,11162.014563106797,11162.014563106797,11162.014563106797,11162.014563106797,{"$f":"Worksheet!D38","v":133944.17475728155},{"$f":"+P47-C47","v":3944.1747572815511}]
[null,{"$f":"Worksheet!B39","v":"Total Fixed Costs %"},{"$f":"Worksheet!C39","v":0.26},{"$f":"+D47/D12","v":0.33705915085580979},{"$f":"+E47/E12","v":0.23898690872429285},0.20117280464326565,0.28426102468190412,0.22165051206075709,0.24150438336467303,0.21899434831130482,0.21781074720169089,0.22436850825665039,0.22079399454387499,0.23383778573561953,0.28418700678534836,{"$f":"Worksheet!D39","v":0.23889610389610388},{"$f":"+Q47/C47","v":3.0339805825242702E-2}]
[]
[null,{"$f":"Worksheet!B41","v":"Total Expenses"},{"$f":"Worksheet!C41","v":440000},{"$f":"+D47+D29","v":31128.004042417637},{"$f":"+E47+E29","v":39321.379006187155},44614.446027817816,34836.450646714402,41523.863932747976,39027.841949480273,41892.120210975452,42059.110075390592,41156.061019013883,41641.645468807226,39941.450011153953,34842.616769440683,{"$f":"Worksheet!D41","v":471984.98916014691},{"$f":"+P50-C50","v":31984.989160146913}]
[]
[null,{"$f":"Worksheet!B43","v":"Operating Surplus"},{"$f":"Worksheet!C43","v":60000},{"$f":"+D12-D50","v":1987.888330674421},{"$f":"+E12-E50","v":7384.1691039139332},10870.26316485909,4430.3273985607011,8834.7590152881385,7190.8411551327372,9077.2981743783603,9187.2802267870502,8592.5184489157473,8912.3317177812496,7792.5572537229746,4434.3885003240648,{"$f":"Worksheet!D43","v":88694.622490338515},{"$f":"+P52-C52","v":28694.622490338515}]
[null,{"$f":"Worksheet!B44","v":"Operating Surplus %"},{"$f":"Worksheet!C44","v":0.12},{"$f":"+D52/D12","v":6.0028227784966991E-2},{"$f":"+E52/E12","v":0.15810046991648399},0.19591457399751122,0.11282635395887272,0.17543686658001986,0.15558299527610364,0.17809303032947191,0.17927663143908595,0.17271887038412634,0.17629338409690173,0.1632495929051572,0.11290037185542851,{"$f":"Worksheet!D44","v":0.15819127474467304},{"$f":"+Q52/C52","v":0.4782437081723086}]
[]
[null,{"$f":"Worksheet!B46","v":"LESS"}]
[null,{"$f":"Worksheet!B47","v":"Depreciation Allowance"},{"$f":"Worksheet!C47","v":12500},{"$f":"+$P56/12","v":1073.2706310679612},{"$f":"+$P56/12","v":1073.2706310679612},1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,{"$f":"Worksheet!D47","v":12879.247572815533},{"$f":"+P56-C56","v":379.2475728155332}]
[]
[null,{"$f":"Worksheet!B49","v":"Business Return"},{"$f":"Worksheet!C49","v":47500},{"$f":"+D52-D56","v":914.61769960645984},{"$f":"+E52-E56","v":6310.8984728459718},9796.99253379113,3357.0567674927397,7761.4883842201771,6117.5705240647758,8004.0275433103989,8114.0095957190888,7519.2478178477859,7839.0610867132882,6719.2866226550132,3361.1178692561034,{"$f":"Worksheet!D49","v":75815.374917522975},{"$f":"+P58-C58","v":28315.374917522975}]
[null,{"$f":"Worksheet!B50","v":"Business Return %"},{"$f":"Worksheet!C50","v":9.5000000000000001E-2},{"$f":"+D58/D12","v":2.7618694048831431E-2},{"$f":"+E58/E12","v":0.13512095946222508},0.17657103508950492,8.5493563124074246E-2,0.15412431734340862,0.13236141995257739,0.15703588145338493,0.15833329036200031,0.15114497535944843,0.15506319231383683,0.14076519043057839,8.5574698126068077E-2,{"$f":"Worksheet!D50","v":0.13522049552389379},{"$f":"+Q58/C58","v":0.59611315615837845}]

{"sheet":"Budget by Month","index":13,"n_rows":59,"n_cols":18,"rows_kept":59,"cut":false,"hidden":false,"merged":[[4,1,5,1],[2,1,3,1],[63,2,63,17],[64,2,64,17],[62,2,62,17],[1,2,1,17],[4,2,5,2],[4,17,5,17],[69,2,69,17],[66,2,66,17],[67,2,67,17],[68,2,68,17],[4,4,4,16],[4,3,5,3],[61,2,61,17],[65,2,65,17],[60,2,60,17]]}
[]
[null,null,"Budget by Month"]
[null,null,"Budget by Month",null,null,null,null,null,null,null,{"$f":"'Budget by Month Master'!J3","v":9.6923076923076931E-2}]
[null,null,{"$f":"'Budget by Month Master'!B4","v":"Acme Widgets"}]
[null,null,"Expected","Current Year","Budget Year",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget by Month Master'!Q6","v":"Variation Year/Year"}]
[null,null,null,null,"2010-01-01",{"$f":"+E6+31","v":"2010-02-01"},{"$f":"+F6+31","v":"2010-03-04"},"2010-04-04","2010-05-05","2010-06-05","2010-07-06","2010-08-06","2010-09-06","2010-10-07","2010-11-07","2010-12-08",{"$f":"'Budget by Month Master'!P6","v":"Full Year"}]
[]
[null,null,"Base Revenue",500000,32500,45000,52500,36500,46000,41500,45000,44500,42500,42500,39500,32000.000000000084,{"$f":"SUM(E8:P8)","v":500000.00000000006}]
[null,null,null,null,{"$f":"+E8/$Q8","v":6.4999999999999988E-2},{"$f":"+F8/$Q8","v":8.9999999999999983E-2},0.10499999999999998,7.2999999999999995E-2,9.1999999999999985E-2,8.299999999999999E-2,8.9999999999999983E-2,8.8999999999999996E-2,8.4999999999999992E-2,8.4999999999999992E-2,7.8999999999999987E-2,6.4000000000000154E-2,1]
[null,null,"Growth Revenue",null,615.89237309205998,1705.5481101010889,2984.7091926769058,2766.7780452750994,4358.6229480361153,4718.6831046130128,5969.4183853538116,6746.3903021776396,7248.5794679296287,8053.9771865884768,8234.0072648769237,7277.0052697646661,{"$f":"SUM(E10:P10)","v":60679.611650485436}]
[null,null,null,null,{"$f":"+E10/$Q10","v":1.0149906308557149E-2},{"$f":"+F10/$Q10","v":2.8107432854465944E-2},4.9188007495315406E-2,4.559650218613364E-2,7.1830106183635181E-2,7.7763897564022452E-2,9.8376014990630811E-2,0.1111805121798875,0.11945658963148029,0.13272954403497811,0.1356964397251717,0.11992504684572169,1]
[null,null,{"$f":"'Budget by Month Master'!B12","v":"Total Revenue"},{"$f":"+D8+D10","v":500000},{"$f":"+E8+E10","v":33115.892373092058},46705.548110101088,55484.709192676906,39266.778045275103,50358.622948036114,46218.68310461301,50969.418385353812,51246.390302177642,49748.57946792963,50553.977186588476,47734.007264876927,39277.005269764748,{"$f":"+Q8+Q10","v":560679.61165048555},{"$f":"+Q12-$D$12","v":60679.611650485545}]
[null,null,null,null,{"$f":"+E12/$Q12","v":5.9063842674086257E-2},{"$f":"+F12/$Q12","v":8.3301670222344776E-2},9.8959741070921564E-2,7.0034253483347783E-2,8.9817111058834956E-2,8.2433322247188551E-2,9.0906495128856138E-2,9.1400488331156646E-2,8.8729068141935083E-2,9.0165535068720548E-2,8.5135978325235021E-2,7.0052494247372615E-2,1,{"$f":"+R12/$D$12","v":0.1213592233009711}]
[]
[null,null,{"$f":"'Budget by Month Master'!B15","v":"Expenses"}]
[null,null,{"$f":"'Budget by Month Master'!B16","v":"Variable Costs"}]
[null,null,"Materials & Supplies",10000,675.17838818925566,952.24903913798357,1131.2416437341894,800.58479509784195,1026.7292057366587,942.32266523968292,1039.1823165945925,1044.8293168405153,1014.2914260451673,1030.7121562314157,973.21762384700537,800.79331132530081,{"$f":"SUM(E17:P17)","v":11431.331888019608},{"$f":"+Q17-D17","v":1431.3318880196075}]
[null,null,{"$f":"'Budget by Month Master'!B18","v":"% Revenue"},{"$f":"+D17/D$12","v":0.02},{"$f":"+E17/E$12","v":2.0388349514563111E-2},{"$f":"+F17/F$12","v":2.0388349514563111E-2},2.0388349514563107E-2,2.0388349514563107E-2,2.0388349514563107E-2,2.0388349514563111E-2,2.0388349514563111E-2,2.0388349514563111E-2,2.0388349514563107E-2,2.0388349514563111E-2,2.0388349514563107E-2,2.0388349514563111E-2,2.0388349514563104E-2,{"$f":"+R17/D17","v":0.14313318880196074}]
[null,null,"Labor excluding Owner",200000,13140.403630743918,18532.786223829386,22016.361990554029,15581.078322775418,19982.328254071785,18339.597931823824,20224.692207056873,20334.594810327897,19740.262678106319,20059.844919382624,18940.879361083,15585.136490868919,{"$f":"SUM(E19:P19)","v":222477.96682062399},{"$f":"+Q19-D19","v":22477.966820623988}]
[null,null,{"$f":"'Budget by Month Master'!B20","v":"% Revenue"},{"$f":"+D19/D$12","v":0.4},{"$f":"+E19/E$12","v":0.39680052956751977},0.39680052956751982,0.39680052956751977,0.39680052956751971,0.39680052956751977,0.39680052956751982,0.39680052956751982,0.39680052956751977,0.39680052956751977,0.39680052956751982,0.39680052956751977,0.39680052956751982,0.39680052956751977,{"$f":"+R19/D19","v":0.11238983410311994}]
[null,null,"Labor Owner",50000,2935.272278524069,4139.8099461225975,4917.9628602599987,3480.4644176493839,4463.6052158486555,4096.656002454336,4517.7439023381794,4542.2936858748371,4409.5331801119446,4480.9207051748881,4230.9688257504549,3481.3709216382395,{"$f":"SUM(E21:P21)","v":49696.601941747584},{"$f":"+Q21-D21","v":-303.39805825241638}]
[null,null,{"$f":"'Budget by Month Master'!B22","v":"% Revenue"},{"$f":"+D21/D$12","v":0.1},{"$f":"+E21/E$12","v":8.8636363636363638E-2},8.8636363636363652E-2,8.8636363636363638E-2,8.8636363636363624E-2,8.8636363636363638E-2,8.8636363636363652E-2,8.8636363636363652E-2,8.8636363636363652E-2,8.8636363636363638E-2,8.8636363636363652E-2,8.8636363636363638E-2,8.8636363636363652E-2,8.8636363636363638E-2,{"$f":"+R21/D21","v":-6.0679611650483276E-3}]
[null,null,"Distribution",20000,1286.0540727414391,1813.8076935961587,2154.7459880651222,1524.9234192339843,1955.6746775936354,1794.9003147422529,1979.3948887516044,1990.1510796962191,1931.9836686574613,1963.2612499646011,1853.7478549466766,1525.3205930005729,{"$f":"SUM(E23:P23)","v":21773.965500989729},{"$f":"+Q23-D23","v":1773.9655009897288}]
[null,null,{"$f":"'Budget by Month Master'!B24","v":"% Revenue"},{"$f":"+D23/D$12","v":0.04},{"$f":"+E23/E$12","v":3.8834951456310676E-2},3.8834951456310676E-2,3.8834951456310676E-2,3.8834951456310669E-2,3.8834951456310676E-2,3.8834951456310683E-2,3.8834951456310683E-2,3.8834951456310676E-2,3.8834951456310676E-2,3.8834951456310683E-2,3.8834951456310676E-2,3.8834951456310683E-2,3.8834951456310676E-2,{"$f":"+R23/D23","v":8.8698275049486436E-2}]
[null,null,"Marketing",10000,643.02703637071954,906.90384679807937,1077.3729940325611,762.46170961699215,977.83733879681768,897.45015737112647,989.69744437580221,995.07553984810954,965.99183432873065,981.63062498230056,926.87392747333831,762.66029650028645,{"$f":"SUM(E25:P25)","v":10886.982750494864},{"$f":"+Q25-D25","v":886.98275049486438}]
[null,null,{"$f":"'Budget by Month Master'!B26","v":"% Revenue"},{"$f":"+D25/D$12","v":0.02},{"$f":"+E25/E$12","v":1.9417475728155338E-2},1.9417475728155338E-2,1.9417475728155338E-2,1.9417475728155335E-2,1.9417475728155338E-2,1.9417475728155342E-2,1.9417475728155342E-2,1.9417475728155338E-2,1.9417475728155338E-2,1.9417475728155342E-2,1.9417475728155338E-2,1.9417475728155342E-2,1.9417475728155338E-2,{"$f":"+R25/D25","v":8.8698275049486436E-2}]
[null,null,"Other",20000,1286.0540727414391,1813.8076935961587,2154.7459880651222,1524.9234192339843,1955.6746775936354,1794.9003147422529,1979.3948887516044,1990.1510796962191,1931.9836686574613,1963.2612499646011,1853.7478549466766,1525.3205930005729,{"$f":"SUM(E27:P27)","v":21773.965500989729},{"$f":"+Q27-D27","v":1773.9655009897288}]
[null,null,{"$f":"'Budget by Month Master'!B28","v":"% Revenue"},{"$f":"+D27/D$12","v":0.04},{"$f":"+E27/E$12","v":3.8834951456310676E-2},3.8834951456310676E-2,3.8834951456310676E-2,3.8834951456310669E-2,3.8834951456310676E-2,3.8834951456310683E-2,3.8834951456310683E-2,3.8834951456310676E-2,3.8834951456310676E-2,3.8834951456310683E-2,3.8834951456310676E-2,3.8834951456310683E-2,3.8834951456310676E-2,{"$f":"+R27/D27","v":8.8698275049486436E-2}]
[null,null,{"$f":"'Budget by Month Master'!B29","v":"Total Variable Costs"},{"$f":"+D17+D19+D21+D23+D25+D27","v":310000},{"$f":"+E17+E19+E21+E23+E25+E27","v":19965.98947931084},28159.364443080362,33452.431464711022,23674.436083607605,30361.849369641182,27865.827386373476,30730.105647868659,30897.095512283791,29994.046455907086,30479.630905700433,28779.435448047152,23680.602206333886,338040.81440286554,{"$f":"+Q29-D29","v":28040.814402865537}]
[null,null,{"$f":"'Budget by Month Master'!B30","v":"Total Variable Costs %"},{"$f":"+D29/D$12","v":0.62},{"$f":"'Budget by Month Master'!D30","v":0.60291262135922319},{"$f":"'Budget by Month Master'!E30","v":0.60291262135922319},{"$f":"'Budget by Month Master'!F30","v":0.60291262135922319},{"$f":"'Budget by Month Master'!G30","v":0.60291262135922319},{"$f":"'Budget by Month Master'!H30","v":0.60291262135922308},{"$f":"'Budget by Month Master'!I30","v":0.6029126213592233},{"$f":"'Budget by Month Master'!J30","v":0.6029126213592233},{"$f":"'Budget by Month Master'!K30","v":0.60291262135922308},{"$f":"'Budget by Month Master'!L30","v":0.6029126213592233},{"$f":"'Budget by Month Master'!M30","v":0.6029126213592233},{"$f":"'Budget by Month Master'!N30","v":0.60291262135922319},{"$f":"'Budget by Month Master'!O30","v":0.60291262135922319},{"$f":"'Budget by Month Master'!P30","v":0.60291262135922308},{"$f":"+R29/D29","v":9.0454240009243667E-2}]
[null,null,{"$f":"'Budget by Month Master'!B31","v":"Gross Profit"},{"$f":"+D12-D29","v":190000},{"$f":"+E12-E29","v":13149.902893781218},18546.183667020727,22032.277727965884,15592.341961667498,19996.773578394932,18352.855718239534,20239.312737485154,20349.294789893851,19754.533012022544,20074.346280888043,18954.571816829775,15596.403063430862,222638.79724762001,{"$f":"+Q31-D31","v":32638.797247620008}]
[null,null,{"$f":"'Budget by Month Master'!B32","v":"Gross Profit %"},{"$f":"+D31/D$12","v":0.38},{"$f":"+E31/E$12","v":0.39708737864077681},0.39708737864077676,0.39708737864077681,0.39708737864077687,0.39708737864077687,0.3970873786407767,0.3970873786407767,0.39708737864077692,0.39708737864077676,0.39708737864077664,0.39708737864077681,0.39708737864077687,0.39708737864077676,{"$f":"+R31/D31","v":0.17178314340852635}]
[null,null,{"$f":"'Budget by Month Master'!B33","v":"Mark-up Equivalent"},{"$f":"IF(D12=0,0,+D12/D29-1)","v":0.61290322580645151},{"$f":"IF(E12=0,0,+E12/E29-1)","v":0.6586151368760067},0.6586151368760067,0.6586151368760067,0.65861513687600692,0.65861513687600692,0.65861513687600648,0.65861513687600648,0.65861513687600692,0.65861513687600648,0.65861513687600626,0.6586151368760067,0.65861513687600692,0.65861513687600648,1.1639746541842451]
[null,null,{"$f":"'Budget by Month Master'!B34","v":"Fixed Costs"}]
[null,null,"Location",40000,3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,3434.4660194174758,{"$f":"SUM(E35:P35)","v":41213.592233009709},{"$f":"+Q35-D35","v":1213.5922330097092}]
[null,null,{"$f":"'Budget by Month Master'!B36","v":"% Revenue"},{"$f":"+D35/D$12","v":0.08},{"$f":"+E35/E$12","v":0.10371050795563377},7.3534433453628562E-2,6.1899324505620197E-2,8.7464930671355107E-2,6.8200157557156013E-2,7.4309041035284004E-2,6.7382876403478398E-2,6.7018691446674106E-2,6.9036464078969351E-2,6.7936613705807683E-2,7.1950087918652164E-2,8.7442155933953325E-2,7.3506493506493492E-2,{"$f":"+R35/D35","v":3.0339805825242729E-2}]
[null,null,"Administration",30000,2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,2575.8495145631068,{"$f":"SUM(E37:P37)","v":30910.194174757275},{"$f":"+Q37-D37","v":910.1941747572746}]
[null,null,{"$f":"'Budget by Month Master'!B38","v":"% Revenue"},{"$f":"+D37/D$12","v":0.06},{"$f":"+E37/E$12","v":7.7782880966725337E-2},5.5150825090221421E-2,4.642449337921515E-2,6.5598698003516337E-2,5.1150118167867013E-2,5.5731780776463007E-2,5.0537157302608805E-2,5.0264018585005579E-2,5.1777348059227006E-2,5.0952460279355766E-2,5.396256593898912E-2,6.5581616950464994E-2,5.5129870129870105E-2,{"$f":"+R37/D37","v":3.0339805825242486E-2}]
[null,null,"Labor excluding Owner",50000,4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,4293.0825242718447,{"$f":"SUM(E39:P39)","v":51516.990291262126},{"$f":"+Q39-D39","v":1516.9902912621255}]
[null,null,{"$f":"'Budget by Month Master'!B40","v":"% Revenue"},{"$f":"+D39/D$12","v":0.1},{"$f":"+E39/E$12","v":0.12963813494454221},9.1918041817035709E-2,7.7374155632025238E-2,0.10933116333919389,8.525019694644502E-2,9.2886301294105009E-2,8.4228595504348011E-2,8.3773364308342632E-2,8.6295580098711674E-2,8.4920767132259614E-2,8.9937609898315202E-2,0.10930269491744166,9.1883116883116844E-2,{"$f":"+R39/D39","v":3.0339805825242511E-2}]
[null,null,"Labor Owner",10000,858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,858.61650485436894,{"$f":"SUM(E41:P41)","v":10303.398058252427},{"$f":"+Q41-D41","v":303.39805825242729}]
[null,null,{"$f":"'Budget by Month Master'!B42","v":"% Revenue"},{"$f":"+D41/D$12","v":0.02},{"$f":"+E41/E$12","v":2.5927626988908443E-2},1.838360836340714E-2,1.5474831126405049E-2,2.1866232667838777E-2,1.7050039389289003E-2,1.8577260258821001E-2,1.6845719100869599E-2,1.6754672861668526E-2,1.7259116019742338E-2,1.6984153426451921E-2,1.7987521979663041E-2,2.1860538983488331E-2,1.8376623376623373E-2,{"$f":"+R41/D41","v":3.0339805825242729E-2}]
[null,null,"Interest Costs",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E43:P43)","v":0},{"$f":"+Q43-D43","v":0}]
[null,null,{"$f":"'Budget by Month Master'!B44","v":"% Revenue"},{"$f":"+D43/D$12","v":0},{"$f":"+E43/E$12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+R43/D43","v":{"$error":"#DIV/0!"}}]
[null,null,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E45:P45)","v":0},{"$f":"+Q45-D45","v":0}]
[null,null,{"$f":"'Budget by Month Master'!B46","v":"% Revenue"},{"$f":"+D45/D$12","v":0},{"$f":"+E45/E$12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+R45/D45","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'Budget by Month Master'!B47","v":"Total Fixed Costs"},{"$f":"+D35+D37+D39+D41+D43+D45","v":130000},{"$f":"+E35+E37+E39+E41+E43+E45","v":11162.014563106797},11162.014563106797,11162.014563106797,11162.014563106797,11162.014563106797,11162.014563106797,11162.014563106797,11162.014563106797,11162.014563106797,11162.014563106797,11162.014563106797,11162.014563106797,133944.17475728155,{"$f":"+Q47-D47","v":3944.1747572815511}]
[null,null,{"$f":"'Budget by Month Master'!B48","v":"Total Fixed Costs %"},{"$f":"+D47/D$12","v":0.26},{"$f":"+E47/E$12","v":0.33705915085580979},0.23898690872429285,0.20117280464326565,0.28426102468190412,0.22165051206075709,0.24150438336467303,0.21899434831130482,0.21781074720169089,0.22436850825665039,0.22079399454387499,0.23383778573561953,0.28418700678534836,0.23889610389610386,{"$f":"+R47/D47","v":3.0339805825242702E-2}]
[]
[null,null,{"$f":"'Budget by Month Master'!B50","v":"Total Expenses"},{"$f":"+D47+D29","v":440000},{"$f":"+E47+E29","v":31128.004042417637},39321.379006187155,44614.446027817816,34836.450646714402,41523.863932747976,39027.841949480273,41892.120210975452,42059.110075390592,41156.061019013883,41641.645468807226,39941.450011153953,34842.616769440683,471984.98916014709,{"$f":"+Q50-D50","v":31984.989160147088}]
[]
[null,null,{"$f":"'Budget by Month Master'!B52","v":"Operating Surplus"},{"$f":"+D12-D50","v":60000},{"$f":"+E12-E50","v":1987.888330674421},7384.1691039139332,10870.26316485909,4430.3273985607011,8834.7590152881385,7190.8411551327372,9077.2981743783603,9187.2802267870502,8592.5184489157473,8912.3317177812496,7792.5572537229746,4434.3885003240648,88694.622490338457,{"$f":"+Q52-D52","v":28694.622490338457}]
[null,null,{"$f":"'Budget by Month Master'!B53","v":"Operating Surplus %"},{"$f":"+D52/D$12","v":0.12},{"$f":"+E52/E$12","v":6.0028227784966991E-2},0.15810046991648399,0.19591457399751122,0.11282635395887272,0.17543686658001986,0.15558299527610364,0.17809303032947191,0.17927663143908595,0.17271887038412634,0.17629338409690173,0.1632495929051572,0.11290037185542851,0.1581912747446729,{"$f":"+R52/D52","v":0.4782437081723076}]
[]
[null,null,{"$f":"'Budget by Month Master'!B55","v":"LESS"}]
[null,null,"Depreciation Allowance",12500,1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,1073.2706310679612,{"$f":"SUM(E56:P56)","v":12879.247572815531},{"$f":"+Q56-D56","v":379.24757281553138}]
[]
[null,null,{"$f":"'Budget by Month Master'!B58","v":"Business Return"},{"$f":"+D52-D56","v":47500},{"$f":"+E52-E56","v":914.61769960645984},6310.8984728459718,9796.99253379113,3357.0567674927397,7761.4883842201771,6117.5705240647758,8004.0275433103989,8114.0095957190888,7519.2478178477859,7839.0610867132882,6719.2866226550132,3361.1178692561034,75815.374917522931,{"$f":"+Q58-D58","v":28315.374917522931}]
[null,null,{"$f":"'Budget by Month Master'!B59","v":"Business Return %"},{"$f":"+D58/D$12","v":9.5000000000000001E-2},{"$f":"+E58/E$12","v":2.7618694048831431E-2},0.13512095946222508,0.17657103508950492,8.5493563124074246E-2,0.15412431734340862,0.13236141995257739,0.15703588145338493,0.15833329036200031,0.15114497535944843,0.15506319231383683,0.14076519043057839,8.5574698126068077E-2,0.13522049552389367,{"$f":"+R58/D58","v":0.59611315615837746}]

{"sheet":"Instructions","index":15,"n_rows":67,"n_cols":4,"rows_kept":67,"cut":false,"hidden":false,"merged":[[1,1,1,3],[67,1,67,3],[5,1,5,3],[2,1,2,3],[6,1,6,3],[73,1,73,3],[74,1,74,3],[75,1,75,3],[76,1,76,3],[68,1,68,3],[70,1,70,3],[71,1,71,3],[72,1,72,3],[69,1,69,3]]}
[]
[null,"Instructions"]
[null,"Overview"]
[null,"Outline",null,"Forecast Budget is a streamlined tool for developing a 3 year business forecast and a 12 month budget. It requires minimal inputs and generates Optimistic to Pessimistic forecasts for your business. From your forecasts a 12 month master budget is built. You then have the capacity to refine this budget as required. The methodology used applies relationships between current data and relative indicators for future performance to produce a verifiable budget quickly and easily. This forecast and budget tool can be utilized for existing and proposed businesses, products, or services. Outputs include a 3 Year Forecast with Sensitivity Analysis, and a Budget by Month in tabular and graphical form."]
[]
[null,"Input"]
[null,"All inputs are in Blue cells on the Input, Analysis, and Budget Sheets. Click the tab, hyperlinks or buttons to access."]
[null,{"$f":"+Input!B9","v":"Current Operating Performance Data"},null,"This section reviews the current performance of your business for a full year period. It is designed to assess the level of expenses that vary with your sales (Variable Costs) and those that don't (Fixed Costs).  It also allocates a realistic labor cost for the owners effort.  The focus is on cash flow excluding assets and  taxation.  Broad expense categories are provided.  Values can be based on the previous years tax return adjusted for current trading.  Inputs do not have to be perfect but should reasonably reflect business operation. It forms the starting point for your budget. If you are building a budget for a new business or product input estimated base Revenue, Variable Cost and Fixed Cost data. To estimate your Base data annualize your expected trading for the first month (multiply it by 12). This will provide a reference point. Ensure your Variable Cost ratios are reasonable and the Fixed Costs reflect a full years trading."]
[null,{"$f":"+Input!B11","v":"Business Name or Identifier"},null,"Input a name for the business. This appears as an identifier on the Output Sheets."]
[null,{"$f":"+Input!B13","v":"Business Revenue"},null,"Input the Revenue generated by the business for the current year."]
[null,"Expenses",null,"Select your Expense input as Monetary or Percent. This allows you to input your Expenses directly in Monetary (Dollars, Pounds etc) or Percentage terms."]
[null,{"$f":"+Input!B16","v":"Variable Costs"},null,"Variable Costs vary with the volume of product or service you provide.  Only include these costs in this section and allocate them into one of the six categories."]
[null,{"$f":"+Input!B17","v":"Materials & Supplies"},null,"Input the annual variable expense for materials and supplies directly related to producing your product or providing your service."]
[null,{"$f":"+Input!B18","v":"Labor excluding Owner"},null,"Input the annual variable expense for labor (excluding the owner) directly related to producing your product or providing your service.  Labor expenses should include all associated on-costs and benefits."]
[null,{"$f":"+Input!B19","v":"Labor Owner"},null,"Input the annual value of labor provided by the owner that is directly related to producing your product or providing your service.  This variable expense should reflect the effective labor effort and can be estimated as the cost of an employee who could replace the owner.  Labor expenses should include all associated on-costs and benefits."]
[null,{"$f":"+Input!B20","v":"Distribution"},null,"Input the annual variable expense for distribution of your product or service.  This may include freight costs, packaging, and vehicle running costs."]
[null,{"$f":"+Input!B21","v":"Marketing"},null,"Input the annual variable expense for marketing.  Include advertising, promotional publications, sponsorships, client functions, and any marketing or sales expense. Marketing is not essentially a variable expense, however it is assumed that marketing does influence the level of sales and a relationship exists between the level of marketing and the level of sales.  It is on this basis that it forms a component of variable costs."]
[null,{"$f":"+Input!B22","v":"Other"},null,"Input any annual variable expenses not already accounted for."]
[null,{"$f":"+Input!B23","v":"Total Variable Costs"},null,"This is the sum of the variable expenses. It is expressed as a monetary value and as a percentage of revenue."]
[null,{"$f":"+Input!B24","v":"Fixed Costs"},null,"Fixed Costs are expenses which remain constant (up to a point) while the volume of sales vary.  Only include these costs in this section and allocate them into one of the six categories."]
[null,{"$f":"+Input!B25","v":"Location"},null,"Input the annual fixed location expense.  Include rent, power and light, maintenance, building insurance, security, and cleaning.  If you own the property do not include purchase or finance costs."]
[null,{"$f":"+Input!B26","v":"Administration"},null,"Input the annual fixed administration expense.   Include office phone, equipment rental costs, and stationary."]
[null,{"$f":"+Input!B27","v":"Labor excluding Owner"},null,"Input the annual fixed labor expense (excluding owner).  This should include any labor expense not already accounted for in variable costs.  Labor expenses should include all associated on-costs and benefits."]
[null,{"$f":"+Input!B28","v":"Labor Owner"},null,"Input the annual value of fixed labor provided by the owner.  This should include the value of any labor not already accounted for in variable costs.  This fixed expense should reflect the effective labor effort and can be estimated as the cost of an employee who could replace the owner.  Labor expenses should include all associated on-costs and benefits."]
[null,{"$f":"+Input!B29","v":"Interest Costs"},null,"Input the annual fixed Interest Cost.  Include only the interest component of loan repayments.  Principle components reflect assets."]
[null,{"$f":"+Input!B30","v":"Other"},null,"Input any annual fixed cost expenses not already accounted for."]
[null,{"$f":"+Input!B31","v":"Total Fixed Costs"},null,"This is the sum of the Fixed Cost expenses. It is expressed as a monetary value and as a percentage of revenue."]
[null,{"$f":"+Input!B32","v":"Operating Surplus"},null,"Operating Surplus reflects the before tax operating profit/loss of the business for the full years trading. It is calculated as the Revenue less Total Variable Costs less Total Fixed Costs. It excludes asset investment. Assets include property, equipment, and capital reinvestment in the business. The Operating Surplus represents the day to day (short term) business performance."]
[null,{"$f":"+Input!B33","v":"Owner Cash Flow"},null,"Owner Cash Flow is the Operating Surplus plus the value of any Labor provided by the Owner. If the owner provides no labor for the business Owner Cash flow and Operating Surplus will be equal."]
[null,{"$f":"+Input!B36","v":"Forecast Data"},null,"This section considers factors that influence future business performance.  A relative indicator is used to reflect unit changes in these factors.   The base year relative indicator for each factor is defined as 100%.  Relative indicators for each of the next three years are applied to reflect likely changes in the unit cost or strength of the factor.  Each indicator is relative to the prior year.  A 10% increase from the previous year is reflected by a relative indicator of 110%.  A 10% decrease from the previous year is reflected by a relative indicator of 90%.  Relative indicators for costs reflect changes in the base unit of the expense such as labor costs per hour or material costs per unit."]
[null,{"$f":"+Input!B38","v":"Relative Indicator"},null,"Relative Indicators are required for each factor for Years 1 to 3. If there is no change from the previous year the Relative Indicator is 100%. You have provided Revenue and Costs details for the Current Year.  Year 1 is the year following the Current Year, Year 2 follows Year 1, and Year 3 follows Year 2."]
[null,{"$f":"+Input!B39","v":"Level of Competition"},null,"Input the percentage relative indicator to reflect the level of change from the previous year.  Consider the number of competitors, competitor strategies, potential new entrants.  This indicator has an inverse relationship to forecast Business Revenue.  All things being equal as the level of competition increases Business Revenue decreases."]
[null,{"$f":"+Input!B40","v":"Market Strength"},null,"Input the percentage relative indicator to reflect the level of change from the previous year.  Consider market growth, technology & regulatory impacts and customer needs.  Market strength is an indicator of the demand for the type of product or service you provide. This indicator has a direct relationship to forecast Business Revenue.  All things being equal as market strength increases Business Revenue increases."]
[null,{"$f":"+Input!B41","v":"Materials & Supplies Costs"},null,"Input the percentage relative indicator to reflect the level of change from the previous year.  Consider the potential changes in supplier pricing, sources of supply, your bargaining power, demand for materials, and possible alternative materials.  This indicator has a direct relationship to forecast Materials & Supplies expenses.  All things being equal as the unit cost of materials and supplies increases this variable expense increases."]
[null,{"$f":"+Input!B42","v":"Labor Costs"},null,"Input the percentage relative indicator to reflect the level of change from the previous year.  Consider market forces and availability of skilled staff.  This indicator has a direct relationship to forecast variable and fixed Labor excluding Owner, and Labor Owner expenses.  All things being equal as the unit labor costs increase these labor expenses increase."]
[null,{"$f":"+Input!B43","v":"Interest Rates"},null,"Input the percentage relative indicator to reflect the level of change from the previous year.  This is percentage change not actual values.  For a current interest rate of 6% a relative indicator of 110% in Year 1 equates to 6.6%, a relative indicator of 110% in Year 2 takes this to 7.26%.  This indicator has a direct relationship to forecast Interest expenses.  All things being equal as interest rates increase this fixed expense increases."]
[null,{"$f":"+Input!B44","v":"Business Market Position"},null,"Input the percentage relative indicator to reflect the level of change from the previous year.  Consider your position in the market, and the impact of your current actions. This is a measure of your standing relative to the competition as perceived by potential consumers. If things will remain much the same input 100%, indicating no change over the previous year.  If you have actions to improve the position of your business by 10% then the input would be 110%. This indicator has a direct relationship to forecast Business Revenue. All thing being equal as market position increases Business Revenue increases.  Actions contributing to the business position must be substantiated and implemented to have an impact."]
[null,{"$f":"+Input!B45","v":"Variable Cost Efficiency"},null,"Input the percentage relative indicator to reflect the level of change from the previous year.  This should reflect changes in the relationship between your variable costs and revenue.   If you have actions to improve your variable cost efficiency (decrease variable costs) by 10% over the previous year input 110%.  Consider changes in processes, distribution or the materials used.  This indicator has an inverse relationship to forecast variable Materials & Supplies, Labor excluding Owner, Labor Owner, Distribution, Marketing and Other expenses. All things being equal as variable cost efficiency increases less materials, labor, distribution and marketing resources are required resulting in a decrease in these expenses.   Actions must be substantiated and implemented to have an impact."]
[null,{"$f":"+Input!B46","v":"Fixed Cost Efficiency"},null,"Input the percentage relative indicator to reflect the level of change from the previous year.  Consider changes in administration processes and fixed labor requirements.  This indicator has an inverse relationship to forecast fixed Administration, Labor excluding Owner, Labor Owner, and Other expenses.   All things being equal as overhead efficiency increases less administration and labor resources are required resulting in a decrease in these expenses.  It does not apply to Location and Finance expenses.   Actions contributing to the business position must be substantiated and implemented to have an impact."]
[null,{"$f":"+Input!B48","v":"Fixed Cost Flow-on"},null,"Input the percentage Fixed Cost Flow-on.  This indicates the estimated level of fixed cost adjustments to support revenue variations.  Fixed Costs are generally considered a constant expense, however large sustained revenue variations place pressure on fixed costs and usually result in an increased fixed cost expense.  This may include larger floor area, more administration costs, or higher financing.  The Fixed Cost Flow-on percentage is the amount of increase in fixed cost expense for a 100% increase in revenue.  An Fixed Cost Flow-on of 20% reflects a 20% increase in fixed cost expense for every 100% increase in revenue. If you own your property only the Interest Costs of the financed amount will be adjusted by the Fixed Cost Flow-on. This indicator has a direct relationship to all forecast fixed cost expenses.  All things being equal as the Fixed Cost Flow-on increases the fixed cost expense relative the revenue will increase."]
[null,{"$f":"+Input!B50","v":"Owners Time Commitment to Business"},null,"Input the percentage of work time the owner commits to the business.  This is used to determine the owners return for effort and indicates the available amount of owner resource.  Available resource will be applied to any forecast labor increase in fixed, then variable costs where the owner currently contributes."]
[null,{"$f":"+Input!B51","v":"Replacement Value of Business Assets"},null,"Input the replacement value of physical business assets.  Exclude property.  Consider vehicles, plant, and equipment. Annual replacement costs for these business assets are calculated as the Replacement Value  divided by the Asset Life. This provides for constant reinvestment to maintain the business. Property (Real Estate) is treated as a constant, depreciation and capital gain are assumed to balance each other out."]
[null,{"$f":"+Input!B52","v":"Life of Assets (years)"},null,"Input the average life of the assets.  The Replacement Value of Business Assets will be divided by the Life of Assets to provide an indication of annual asset Depreciation Allowance.  This will be used in determining the Business Return."]
[null,{"$f":"+Input!B57","v":"Sensitivity Analysis"},null,"Sensitivity Analysis allows you to adjust your Relative Indicators by a set percentage to generate Optimistic and Pessimistic Forecasts."]
[null,"Optimistic Input",null,"Input the percentage improvement in Relative Indicators to generate an Optimistic Forecast. If you feel it is \"reasonably likely\" your Relative Indicators may be 20% too low, input 20%."]
[null,"Pessimistic Input",null,"Input the percentage degrade in Relative Indicators to generate a Pessimistic Forecast. If you feel it is \"reasonably likely\" your Relative Indicators may be 20% too high, input 20%."]
[null,{"$f":"+'Sensitivity Analysis'!B10","v":"Business Revenue"},null,"This is the forecast revenue generated by the business."]
[null,{"$f":"+'Sensitivity Analysis'!B11","v":"Optimistic"},null,"This is the forecast based on your Optimistic improvement to Relative Indicators."]
[null,{"$f":"+'Sensitivity Analysis'!B12","v":"Expected"},null,"This is the forecast based on the Relative Indicators you provided as input."]
[null,{"$f":"+'Sensitivity Analysis'!B13","v":"Pessimistic"},null,"This is the forecast based on your Pessimistic degradation of Relative Indicators."]
[null,{"$f":"+'Sensitivity Analysis'!B14","v":"Operating Surplus"},null,"This is the Revenue less Variable and Fixed costs. The Operating Surplus represents the day to day (short term) business performance."]
[null,{"$f":"+'Sensitivity Analysis'!B18","v":"Business Return"},null,"Business Return is the Operating Surplus less a Depreciation Allowance. A Depreciation Allowance is required for the long term maintenance of the business. It is calculated as the Replacement Value of Business Assets divided by the Asset Lifetime. If the Depreciation Allowance is not reinvested business performance will decrease. The Business Return provides a longer term indicator of business performance."]
[null,{"$f":"+Input!B58","v":"Expected Results"},null,"Full tabular results for your Expected Forecast."]
[null,{"$f":"+Input!B59","v":"Optimistic Results"},null,"Full tabular results for your Optimistic Forecast."]
[null,{"$f":"+Input!B60","v":"Pessimistic Results"},null,"Full tabular results for your Optimistic Forecast."]
[null,{"$f":"+Input!B61","v":"Forecast Revenue Chart"},null,"3 Year Forecast Revenue Chart; Optimistic, Expected and Pessimistic."]
[null,{"$f":"+Input!B62","v":"Forecast Surplus Chart"},null,"3 Year Forecast Operating Surplus Chart; Optimistic, Expected, and Pessimistic."]
[null,{"$f":"+Input!B63","v":"Forecast Return Chart"},null,"3 Year Forecast Return Chart; Optimistic, Expected, and Pessimistic. Return is the Operating Surplus less the Depreciation Allowance."]
[null,{"$f":"+Input!B64","v":"Operating Surplus Chart"},null,"3 Year Expected Operating Surplus Chart including Variable and Fixed costs."]
[null,{"$f":"+Input!B65","v":"Budget by Month Master"},null,"The Budget by Month Master builds a monthly budget for your Year 1 Forecast. This is done by using the Current Year and Year 1 Forecast data. Revenue for the budget year consists of 2 components. Base Revenue, which is the same as the Current Year (no change year on year), and Growth Revenue, which is the difference between Current Year Revenue and Year 1 Forecast Revenue. Base Revenue is allocated to each month according to the Percentage Contributor you input for the month. If all months contribute equal revenue the Percentage Contributor will be 8.3333% (1/12) for all months. This is unlikely as the revenue of most businesses tends to vary due to seasonal influences such as weather, holiday periods, etc. Your Percentage Contributor is used to incorporate these revenue variations."]
[null,null,null,"Growth Revenue is distributed across the months by considering the Percentage Contributor and the Compounding Growth Affect.  If you secure one new customer a month to generate your Growth Revenue then in month 1 you have Growth Revenue from one new customer, in month 2 you have Growth Revenue from 2 new customers (the customer secured in month 1 and the customer secured in month 2). This Compounding Growth Affect is adjusted by the Percentage Contributor to calculate the amount of Growth Revenue allocated to each month. Imagine the Percentage Contributor for month 2 is half that of month 1 due to seasonal factors halving the number of customers in month 2.  The average number of new customers you could secure in month 2 will also be halved by this downturn in demand resulting in a decrease in the amount of Growth Revenue that can be secured."]
[null,null,null,"Total Revenue for each month is Base plus Growth Revenue.  Variable expenses are calculated as a percentage of Total Revenue based on your Year 1 Forecast. Their actual amount varies with revenue but their percentage remains constant over the year. Fixed Costs and Depreciation Allowance are allocated equally over the months based on your Year 1 Forecast. Their amount remains constant regardless of revenue variations."]
[null,{"$f":"+'Budget by Month Master'!B6","v":"Budget Month"},null,"Input the first month of your budget year. Following months are calculated as the preceding month plus 31 days."]
[null,{"$f":"+'Budget by Month Master'!B9","v":"Percentage Contributor"},null,"For the first 11 months of the year input the Percentage Contributor indicating the percentage of annual revenue the month would provide if there was no revenue growth. The percentage for the 12th month of the year is calculated to ensure the annual total is 100%. Use the 12th month percentage as a check on your inputs. The Base Revenue for each month is calculated as the Percentage Contributor multiplied by the Total Base Revenue for the Budget Year."]
[null,{"$f":"+Input!B66","v":"Budget by Month Master Chart"},null,"View Revenue, Operating Surplus, and Business Return for Year 1 as built by the Budget by Month Master."]
[null,{"$f":"+Input!B67","v":"Budget by Month"},null,"Budget by Month allows you to update all cell data to match the Budget by Month Master when you click an Update All Button; update cell data to Master by row when you click the adjacent Update Button; and change any input within a blue cell by simply overwriting the existing data. This allows you to fully refine your budget and recalculates all percentages and totals based your inputs. Adjusting revenue and expense amounts will change your budget ratios i.e. Variable Cost % etc, beware. If you believe major adjustment is required it is recommended you review and adjust your Input Sheet data to generate an improved Master Budget. You can then refine it here to produce your Budget by Month. When you click an Update Button any existing data in the updated cells is overwritten and can not be recovered. It is replaced with data from the Budget by Month Master."]
[null,{"$f":"+Input!B68","v":"Budget by Month Chart"},null,"View Revenue, Operating Surplus, and Business Return as defined in Budget by Month."]

{"sheet":"Worksheet","index":16,"n_rows":91,"n_cols":22,"rows_kept":91,"cut":false,"hidden":true,"merged":[[51,16,51,20],[52,16,52,19],[71,16,71,18],[52,1,52,4],[51,1,51,5],[71,1,71,3],[51,9,51,13],[52,9,52,12],[71,9,71,11]]}
[]
[null,"Expected Forecast",null,null,null,null,null,null,null,"Optimistic Forecast improved by",{"$f":"+'Sensitivity Analysis'!E7","v":0.2},null,null,null,null,null,"Pessimistic Forecast degraded by",{"$f":"+'Sensitivity Analysis'!E8","v":0.2}]
[null,{"$f":"+Input!C11","v":"Acme Widgets"},null,null,null,null,null,null,null,{"$f":"+$B3","v":"Acme Widgets"},null,null,null,null,null,null,{"$f":"+$B3","v":"Acme Widgets"}]
[null,"Expected",{"$f":"+C54","v":"Current Year"},{"$f":"+D54","v":"Year 1"},{"$f":"+E54","v":"Year 2"},{"$f":"+F54","v":"Year 3"},{"$f":"+G81","v":"3 Year Average"},null,null,"Optimistic",{"$f":"+K54","v":"Current Year"},{"$f":"+L54","v":"Year 1"},{"$f":"+M54","v":"Year 2"},{"$f":"+N54","v":"Year 3"},{"$f":"+O81","v":"3 Year Average"},null,"Pessimistic",{"$f":"+R54","v":"Current Year"},{"$f":"+S54","v":"Year 1"},{"$f":"+T54","v":"Year 2"},{"$f":"+U54","v":"Year 3"},{"$f":"+V81","v":"3 Year Average"}]
[null,{"$f":"+Input!B13","v":"Business Revenue"},{"$f":"+Input!C13","v":500000},{"$f":"+C5*D56*D60/D55","v":560679.61165048543},{"$f":"+D5*E56*E60/E55","v":588713.59223300975},{"$f":"+E5*F56*F60/F55","v":625128.8659793816},{"$f":"AVERAGE(D5:F5)","v":591507.35662095889},null,null,{"$f":"+$B5","v":"Business Revenue"},{"$f":"+C5","v":500000},{"$f":"+K5*L56*L60/L55","v":579687.5},{"$f":"+L5*M56*M60/M55","v":614468.75},{"$f":"+M5*N56*N60/N55","v":660362.68153526972},{"$f":"AVERAGE(L5:N5)","v":618172.9771784232},null,{"$f":"+$B5","v":"Business Revenue"},{"$f":"+C5","v":500000},{"$f":"+R5*S56*S60/S55","v":542084.94208494201},{"$f":"+S5*T56*T60/T55","v":563768.33976833976},{"$f":"+T5*U56*U60/U55","v":591494.65156022529},{"$f":"AVERAGE(S5:U5)","v":565782.6444711691}]
[null,{"$f":"+Input!B15","v":"Expenses"},null,null,null,null,null,null,null,{"$f":"+$B6","v":"Expenses"},null,null,null,null,null,null,{"$f":"+$B6","v":"Expenses"}]
[null,{"$f":"+Input!B16","v":"Variable Costs"},null,null,null,null,null,null,null,"Variable Costs",null,null,null,null,null,null,"Variable Costs"]
[null,{"$f":"+Input!B17","v":"Materials & Supplies"},{"$f":"IF(Input!C$15=Input!B$81,Input!C$17,Input!D$17)","v":10000},{"$f":"+D5*$C9*$D57/D61","v":11431.331888019608},{"$f":"+E5*$C9*$D57*$E57/D61/E61","v":12002.898482420587},{"$f":"+F5*$C9*$D57*$E57*F57/D61/E61/F61","v":12745.345811230112},{"$f":"AVERAGE(D8:F8)","v":12059.858727223434},null,null,"Materials & Supplies",{"$f":"+C8","v":10000},{"$f":"+L5*$C9*$D57/L61","v":11750.422297297297},{"$f":"+M5*$C9*$D57*$E57/L61/M61","v":12337.943412162162},{"$f":"+N5*$C9*$D57*$E57*N57/L61/M61/N61","v":13259.449559128632},{"$f":"AVERAGE(L8:N8)","v":12449.271756196031},null,"Materials & Supplies",{"$f":"+C8","v":10000},{"$f":"+S5*$C9*$D57/S61","v":11116.97635135135},{"$f":"+T5*$C9*$D57*$E57/S61/T61","v":11672.82516891892},{"$f":"+U5*$C9*$D57*$E57*U57/S61/T61/U61","v":12246.898537882147},{"$f":"AVERAGE(S8:U8)","v":11678.90001938414}]
[null,"% Revenue",{"$f":"+C8/C$5","v":0.02},{"$f":"+D8/D5","v":2.0388349514563111E-2},{"$f":"+E8/E5","v":2.0388349514563107E-2},{"$f":"+F8/F5","v":2.0388349514563111E-2},{"$f":"+G8/G5","v":2.0388349514563107E-2},null,null,"% Revenue",{"$f":"+K8/K$5","v":0.02},{"$f":"+L8/L5","v":2.0270270270270268E-2},{"$f":"+M8/M5","v":2.0079041305456399E-2},{"$f":"+N8/N5","v":2.0079041305456402E-2},{"$f":"+O8/O5","v":2.013881585866022E-2},null,"% Revenue",{"$f":"+R8/R$5","v":0.02},{"$f":"+S8/S5","v":2.05078125E-2},{"$f":"+T8/T5","v":2.0705003004807696E-2},{"$f":"+U8/U5","v":2.0705003004807699E-2},{"$f":"+V8/V5","v":2.0642025932591627E-2}]
[null,{"$f":"+Input!B18","v":"Labor excluding Owner"},{"$f":"IF(Input!C$15=Input!B$81,Input!C$18,Input!D$18)","v":200000},{"$f":"+D$5*($C11+$C13)*D58/D61-D12","v":222477.96682062396},{"$f":"+E$5*($C11+$C13)*D58*E58/D61/E61-E12","v":229085.76170759567},{"$f":"+F$5*($C11+$C13)*D58*E58*F58/D61/E61/F61-F12","v":258404.25030321415},{"$f":"AVERAGE(D10:F10)","v":236655.99294381126},null,null,"Labor excluding Owner",{"$f":"+C10","v":200000},{"$f":"+L$5*($C11+$C13)*L58/L61-L12","v":230170.39695945947},{"$f":"+M$5*($C11+$C13)*L58*M58/L61/M61-M12","v":235320.77756314661},{"$f":"+N$5*($C11+$C13)*L58*M58*N58/L61/M61/N61-N12","v":265969.27342111943},{"$f":"AVERAGE(L10:N10)","v":243820.14931457516},null,"Labor excluding Owner",{"$f":"+C10","v":200000},{"$f":"+S$5*($C11+$C13)*S58/S61-S12","v":214900.33783783778},{"$f":"+T$5*($C11+$C13)*S58*T58/S61/T61-T12","v":222879.78046240841},{"$f":"+U$5*($C11+$C13)*S58*T58*U58/S61/T61/U61-U12","v":250882.66180386988},{"$f":"AVERAGE(S10:U10)","v":229554.26003470537}]
[null,"% Revenue",{"$f":"+C10/C$5","v":0.4},{"$f":"+D10/D$5","v":0.39680052956751977},{"$f":"+E10/E$5","v":0.38912939115039952},{"$f":"+F10/F$5","v":0.41336157129518475},{"$f":"+G10/G$5","v":0.40008968661984318},null,null,"% Revenue",{"$f":"+K10/K$5","v":0.4},{"$f":"+L10/L$5","v":0.39705944488963357},{"$f":"+M10/M$5","v":0.38296622499215233},{"$f":"+N10/N$5","v":0.40276242261717526},{"$f":"+O10/O$5","v":0.39442058827524806},null,"% Revenue",{"$f":"+R10/R$5","v":0.4},{"$f":"+S10/S$5","v":0.39643295940170936},{"$f":"+T10/T$5","v":0.39533929939022971},{"$f":"+U10/U$5","v":0.42415034716222672},{"$f":"+V10/V$5","v":0.40572870567506936}]
[null,{"$f":"+Input!B19","v":"Labor Owner"},{"$f":"IF(Input!C$15=Input!B$81,Input!C$19,Input!D$19)","v":50000},{"$f":"IF((D$5*$C13*D58/D61+D32)<=D$64,D$5*$C13*$D58/D61,(D$64-D32))","v":49696.601941747576},{"$f":"IF((E$5*$C13*D58*E58/D61/E61+E32)<=E$64,E$5*$C13*$D58*$E58/D61/E61,(E$64-E32))","v":51254.044117647063},{"$f":"IF((F$5*$C13*D58*E58*F58/D61/E61/F61+F32)<=F$64,F$5*$C13*$D58*$E58*F58/D61/E61/F61,(F$64-F32))","v":54160.182686476648},{"$f":"AVERAGE(D12:F12)","v":51703.609581957098},null,null,"Labor Owner",{"$f":"+C12","v":50000},{"$f":"IF((L$5*$C13*L58/L61+L32)<=L$64,L$5*$C13*$D58/L61,(L$64-L32))","v":49601.5625},{"$f":"IF((M$5*$C13*L58*M58/L61/M61+M32)<=M$64,M$5*$C13*$D58*$E58/L61/M61,(M$64-M32))","v":51165.708923339844},{"$f":"IF((N$5*$C13*L58*M58*N58/L61/M61/N61+N32)<=N$64,N$5*$C13*$D58*$E58*N58/L61/M61/N61,(N$64-N32))","v":54229.896703361861},{"$f":"AVERAGE(L12:N12)","v":51665.722708900568},null,"Labor Owner",{"$f":"+C12","v":50000},{"$f":"IF((S$5*$C13*S58/S61+S32)<=S$64,S$5*$C13*$D58/S61,(S$64-S32))","v":49789.575289575288},{"$f":"IF((T$5*$C13*S58*T58/S61/T61+T32)<=T$64,T$5*$C13*$D58*$E58/S61/T61,(T$64-T32))","v":51338.969537591584},{"$f":"IF((U$5*$C13*S58*T58*U58/S61/T61/U61+U32)<=U$64,U$5*$C13*$D58*$E58*U58/S61/T61/U61,(U$64-U32))","v":54084.551310884242},{"$f":"AVERAGE(S12:U12)","v":51737.698712683712}]
[null,"% Revenue",{"$f":"+C12/C$5","v":0.1},{"$f":"+D12/D$5","v":8.8636363636363638E-2},{"$f":"+E12/E$5","v":8.7061085040076633E-2},{"$f":"+F12/F$5","v":8.6638428704815224E-2},{"$f":"+G12/G$5","v":8.7409918073240556E-2},null,null,"% Revenue",{"$f":"+K12/K$5","v":0.1},{"$f":"+L12/L$5","v":8.556603773584906E-2},{"$f":"+M12/M$5","v":8.3268203506427052E-2},{"$f":"+N12/N$5","v":8.2121383021347277E-2},{"$f":"+O12/O$5","v":8.3578099684529394E-2},null,"% Revenue",{"$f":"+R12/R$5","v":0.1},{"$f":"+S12/S$5","v":9.1848290598290611E-2},{"$f":"+T12/T$5","v":9.1063945802077995E-2},{"$f":"+U12/U$5","v":9.1437092741619513E-2},{"$f":"+V12/V$5","v":9.1444478225454193E-2}]
[null,{"$f":"+Input!B20","v":"Distribution"},{"$f":"IF(Input!C$15=Input!B$81,Input!C$20,Input!D$20)","v":20000},{"$f":"+D$5*$C15/D61","v":21773.965500989725},{"$f":"+E$5*$C15/D61/E61","v":21773.965500989729},{"$f":"+F$5*$C15/D61/E61/F61","v":23120.808727855074},{"$f":"AVERAGE(D14:F14)","v":22222.913243278173},null,null,"Distribution",{"$f":"+C14","v":20000},{"$f":"+L$5*$C15/L61","v":22381.756756756757},{"$f":"+M$5*$C15/L61/M61","v":22381.756756756753},{"$f":"+N$5*$C15/L61/M61/N61","v":24053.423236514522},{"$f":"AVERAGE(L14:N14)","v":22938.978916676006},null,"Distribution",{"$f":"+C14","v":20000},{"$f":"+S$5*$C15/S61","v":21175.193050193047},{"$f":"+T$5*$C15/S61/T61","v":21175.193050193051},{"$f":"+U$5*$C15/S61/T61/U61","v":22216.595987087789},{"$f":"AVERAGE(S14:U14)","v":21522.327362491294}]
[null,"% Revenue",{"$f":"+C14/C$5","v":0.04},{"$f":"+D14/D$5","v":3.8834951456310676E-2},{"$f":"+E14/E$5","v":3.6985668053629218E-2},{"$f":"+F14/F$5","v":3.6985668053629218E-2},{"$f":"+G14/G$5","v":3.7569969324183293E-2},null,null,"% Revenue",{"$f":"+K14/K$5","v":0.04},{"$f":"+L14/L$5","v":3.8610038610038609E-2},{"$f":"+M14/M$5","v":3.642456472645151E-2},{"$f":"+N14/N$5","v":3.6424564726451517E-2},{"$f":"+O14/O$5","v":3.7107702477352275E-2},null,"% Revenue",{"$f":"+R14/R$5","v":0.04},{"$f":"+S14/S$5","v":3.90625E-2},{"$f":"+T14/T$5","v":3.7560096153846152E-2},{"$f":"+U14/U$5","v":3.7560096153846152E-2},{"$f":"+V14/V$5","v":3.8039921465968581E-2}]
[null,{"$f":"+Input!B21","v":"Marketing"},{"$f":"IF(Input!C$15=Input!B$81,Input!C$21,Input!D$21)","v":10000},{"$f":"+D$5*$C17/D61","v":10886.982750494863},{"$f":"+E$5*$C17/D61/E61","v":10886.982750494864},{"$f":"+F$5*$C17/D61/E61/F61","v":11560.404363927537},{"$f":"AVERAGE(D16:F16)","v":11111.456621639087},null,null,"Marketing",{"$f":"+C16","v":10000},{"$f":"+L$5*$C17/L61","v":11190.878378378378},{"$f":"+M$5*$C17/L61/M61","v":11190.878378378377},{"$f":"+N$5*$C17/L61/M61/N61","v":12026.711618257261},{"$f":"AVERAGE(L16:N16)","v":11469.489458338003},null,"Marketing",{"$f":"+C16","v":10000},{"$f":"+S$5*$C17/S61","v":10587.596525096524},{"$f":"+T$5*$C17/S61/T61","v":10587.596525096526},{"$f":"+U$5*$C17/S61/T61/U61","v":11108.297993543894},{"$f":"AVERAGE(S16:U16)","v":10761.163681245647}]
[null,"% Revenue",{"$f":"+C16/C$5","v":0.02},{"$f":"+D16/D$5","v":1.9417475728155338E-2},{"$f":"+E16/E$5","v":1.8492834026814609E-2},{"$f":"+F16/F$5","v":1.8492834026814609E-2},{"$f":"+G16/G$5","v":1.8784984662091646E-2},null,null,"% Revenue",{"$f":"+K16/K$5","v":0.02},{"$f":"+L16/L$5","v":1.9305019305019305E-2},{"$f":"+M16/M$5","v":1.8212282363225755E-2},{"$f":"+N16/N$5","v":1.8212282363225758E-2},{"$f":"+O16/O$5","v":1.8553851238676138E-2},null,"% Revenue",{"$f":"+R16/R$5","v":0.02},{"$f":"+S16/S$5","v":1.953125E-2},{"$f":"+T16/T$5","v":1.8780048076923076E-2},{"$f":"+U16/U$5","v":1.8780048076923076E-2},{"$f":"+V16/V$5","v":1.901996073298429E-2}]
[null,{"$f":"+Input!B22","v":"Other"},{"$f":"IF(Input!C$15=Input!B$81,Input!C$22,Input!D$22)","v":20000},{"$f":"+D$5*$C19/D61","v":21773.965500989725},{"$f":"+E$5*$C19/D61/E61","v":21773.965500989729},{"$f":"+F$5*$C19/D61/E61/F61","v":23120.808727855074},{"$f":"AVERAGE(D18:F18)","v":22222.913243278173},null,null,"Other",{"$f":"+C18","v":20000},{"$f":"+L$5*$C19/L61","v":22381.756756756757},{"$f":"+M$5*$C19/L61/M61","v":22381.756756756753},{"$f":"+N$5*$C19/L61/M61/N61","v":24053.423236514522},{"$f":"AVERAGE(L18:N18)","v":22938.978916676006},null,"Other",{"$f":"+C18","v":20000},{"$f":"+S$5*$C19/S61","v":21175.193050193047},{"$f":"+T$5*$C19/S61/T61","v":21175.193050193051},{"$f":"+U$5*$C19/S61/T61/U61","v":22216.595987087789},{"$f":"AVERAGE(S18:U18)","v":21522.327362491294}]
[null,"% Revenue",{"$f":"+C18/C$5","v":0.04},{"$f":"+D18/D$5","v":3.8834951456310676E-2},{"$f":"+E18/E$5","v":3.6985668053629218E-2},{"$f":"+F18/F$5","v":3.6985668053629218E-2},{"$f":"+G18/G$5","v":3.7569969324183293E-2},null,null,"% Revenue",{"$f":"+K18/K$5","v":0.04},{"$f":"+L18/L$5","v":3.8610038610038609E-2},{"$f":"+M18/M$5","v":3.642456472645151E-2},{"$f":"+N18/N$5","v":3.6424564726451517E-2},{"$f":"+O18/O$5","v":3.7107702477352275E-2},null,"% Revenue",{"$f":"+R18/R$5","v":0.04},{"$f":"+S18/S$5","v":3.90625E-2},{"$f":"+T18/T$5","v":3.7560096153846152E-2},{"$f":"+U18/U$5","v":3.7560096153846152E-2},{"$f":"+V18/V$5","v":3.8039921465968581E-2}]
[null,{"$f":"+Input!B23","v":"Total Variable Costs"},{"$f":"+C8+C10+C12+C14+C16+C18","v":310000},{"$f":"+D8+D10+D12+D14+D16+D18","v":338040.81440286536},{"$f":"+E8+E10+E12+E14+E16+E18","v":346777.61806013767},{"$f":"+F8+F10+F12+F14+F16+F18","v":383111.80062055867},{"$f":"AVERAGE(D20:F20)","v":355976.74436118727},null,null,"Total Variable Costs",{"$f":"+K8+K10+K12+K14+K16+K18","v":310000},{"$f":"+L8+L10+L12+L14+L16+L18","v":347476.7736486487},{"$f":"+M8+M10+M12+M14+M16+M18","v":354778.82179054053},{"$f":"+N8+N10+N12+N14+N16+N18","v":393592.1777748962},{"$f":"AVERAGE(L20:N20)","v":365282.59107136185},null,"Total Variable Costs",{"$f":"+R8+R10+R12+R14+R16+R18","v":310000},{"$f":"+S8+S10+S12+S14+S16+S18","v":328744.8721042471},{"$f":"+T8+T10+T12+T14+T16+T18","v":338829.55779440154},{"$f":"+U8+U10+U12+U14+U16+U18","v":372755.6016203558},{"$f":"AVERAGE(S20:U20)","v":346776.67717300146}]
[null,"Total Variable Costs %",{"$f":"IF(C20=0,0,+C20/C$5)","v":0.62},{"$f":"IF(D20=0,0,+D20/D$5)","v":0.60291262135922308},{"$f":"IF(E20=0,0,+E20/E$5)","v":0.58904299583911235},{"$f":"IF(F20=0,0,+F20/F$5)","v":0.6128525196486363},{"$f":"IF(G20=0,0,+G20/G$5)","v":0.60181287751810519},null,null,"Total Variable Costs %",{"$f":"IF(K20=0,0,+K20/K$5)","v":0.62},{"$f":"IF(L20=0,0,+L20/L$5)","v":0.5994208494208495},{"$f":"IF(M20=0,0,+M20/M$5)","v":0.57737488162016459},{"$f":"IF(N20=0,0,+N20/N$5)","v":0.59602425876010767},{"$f":"IF(O20=0,0,+O20/O$5)","v":0.59090676001181841},null,"Total Variable Costs %",{"$f":"IF(R20=0,0,+R20/R$5)","v":0.62},{"$f":"IF(S20=0,0,+S20/S$5)","v":0.60644531250000011},{"$f":"IF(T20=0,0,+T20/T$5)","v":0.60100848858173073},{"$f":"IF(U20=0,0,+U20/U$5)","v":0.63019268329326938},{"$f":"IF(V20=0,0,+V20/V$5)","v":0.61291501349803656}]
[null,"Gross Profit",{"$f":"+C5-C20","v":190000},{"$f":"+D5-D20","v":222638.79724762007},{"$f":"+E5-E20","v":241935.97417287208},{"$f":"+F5-F20","v":242017.06535882293},{"$f":"+G5-G20","v":235530.61225977162},null,null,"Gross Profit",{"$f":"+K5-K20","v":190000},{"$f":"+L5-L20","v":232210.7263513513},{"$f":"+M5-M20","v":259689.92820945947},{"$f":"+N5-N20","v":266770.50376037351},{"$f":"+O5-O20","v":252890.38610706135},null,"Gross Profit",{"$f":"+R5-R20","v":190000},{"$f":"+S5-S20","v":213340.06998069491},{"$f":"+T5-T20","v":224938.78197393822},{"$f":"+U5-U20","v":218739.0499398695},{"$f":"+V5-V20","v":219005.96729816764}]
[null,"Gross Profit %",{"$f":"IF(C22=0,0,+C22/C$5)","v":0.38},{"$f":"IF(D22=0,0,+D22/D$5)","v":0.39708737864077692},{"$f":"IF(E22=0,0,+E22/E$5)","v":0.4109570041608876},{"$f":"IF(F22=0,0,+F22/F$5)","v":0.38714748035136376},{"$f":"IF(G22=0,0,+G22/G$5)","v":0.39818712248189486},null,null,"Gross Profit %",{"$f":"IF(K22=0,0,+K22/K$5)","v":0.38},{"$f":"IF(L22=0,0,+L22/L$5)","v":0.4005791505791505},{"$f":"IF(M22=0,0,+M22/M$5)","v":0.42262511837983535},{"$f":"IF(N22=0,0,+N22/N$5)","v":0.40397574123989227},{"$f":"IF(O22=0,0,+O22/O$5)","v":0.40909323998818153},null,"Gross Profit %",{"$f":"IF(R22=0,0,+R22/R$5)","v":0.38},{"$f":"IF(S22=0,0,+S22/S$5)","v":0.39355468749999994},{"$f":"IF(T22=0,0,+T22/T$5)","v":0.39899151141826922},{"$f":"IF(U22=0,0,+U22/U$5)","v":0.36980731670673062},{"$f":"IF(V22=0,0,+V22/V$5)","v":0.38708498650196338}]
[null,"Mark-up Equivalent",{"$f":"IF(C5=0,0,+C5/C20-1)","v":0.61290322580645151},{"$f":"IF(D5=0,0,+D5/D20-1)","v":0.65861513687600715},{"$f":"IF(E5=0,0,+E5/E20-1)","v":0.69766894278314084},{"$f":"IF(F5=0,0,+F5/F20-1)","v":0.63171394085697008},{"$f":"IF(G5=0,0,+G5/G20-1)","v":0.66164606534182324},null,null,"Mark-up Equivalent",{"$f":"IF(K5=0,0,+K5/K20-1)","v":0.61290322580645151},{"$f":"IF(L5=0,0,+L5/L20-1)","v":0.66827697262479857},{"$f":"IF(M5=0,0,+M5/M20-1)","v":0.73197697342480872},{"$f":"IF(N5=0,0,+N5/N20-1)","v":0.67778405879027726},{"$f":"IF(O5=0,0,+O5/O20-1)","v":0.69231436780313604},null,"Mark-up Equivalent",{"$f":"IF(R5=0,0,+R5/R20-1)","v":0.61290322580645151},{"$f":"IF(S5=0,0,+S5/S20-1)","v":0.64895330112721394},{"$f":"IF(T5=0,0,+T5/T20-1)","v":0.66387001015545666},{"$f":"IF(U5=0,0,+U5/U20-1)","v":0.58681626510512075},{"$f":"IF(V5=0,0,+V5/V20-1)","v":0.6315475685491645}]
[null,{"$f":"+Input!B24","v":"Fixed Costs"},null,null,null,null,null,null,null,"Fixed Costs",null,null,null,null,null,null,"Fixed Costs"]
[null,{"$f":"+Input!B25","v":"Location"},{"$f":"IF(Input!C$15=Input!B$81,Input!C$25,Input!D$25)","v":40000},{"$f":"$C26+$C26*(D$5-$C$5)/$C$5*$C$63","v":41213.592233009709},{"$f":"$C26+$C26*(E$5-$C$5)/$C$5*$C$63","v":41774.271844660194},{"$f":"$C26+$C26*(F$5-$C$5)/$C$5*$C$63","v":42502.577319587632},{"$f":"AVERAGE(D26:F26)","v":41830.147132419173},null,null,"Location",{"$f":"+C26","v":40000},{"$f":"$C26+$C26*(L$5-$C$5)/$C$5*$C$63","v":41593.75},{"$f":"$C26+$C26*(M$5-$C$5)/$C$5*$C$63","v":42289.375},{"$f":"$C26+$C26*(N$5-$C$5)/$C$5*$C$63","v":43207.253630705396},{"$f":"AVERAGE(L26:N26)","v":42363.459543568468},null,"Location",{"$f":"+C26","v":40000},{"$f":"$C26+$C26*(S$5-$C$5)/$C$5*$C$63","v":40841.698841698839},{"$f":"$C26+$C26*(T$5-$C$5)/$C$5*$C$63","v":41275.366795366797},{"$f":"$C26+$C26*(U$5-$C$5)/$C$5*$C$63","v":41829.893031204505},{"$f":"AVERAGE(S26:U26)","v":41315.652889423385}]
[null,"% Revenue",{"$f":"+C26/C$5","v":0.08},{"$f":"+D26/D$5","v":7.3506493506493506E-2},{"$f":"+E26/E$5","v":7.0958565244279528E-2},{"$f":"+F26/F$5","v":6.7990105132962261E-2},{"$f":"+G26/G$5","v":7.0717881467067131E-2},null,null,"% Revenue",{"$f":"+K26/K$5","v":0.08},{"$f":"+L26/L$5","v":7.1752021563342316E-2},{"$f":"+M26/M$5","v":6.8822661852209741E-2},{"$f":"+N26/N$5","v":6.5429581105724124E-2},{"$f":"+O26/O$5","v":6.8530105823990273E-2},null,"% Revenue",{"$f":"+R26/R$5","v":0.08},{"$f":"+S26/S$5","v":7.5341880341880343E-2},{"$f":"+T26/T$5","v":7.3213346482577255E-2},{"$f":"+U26/U$5","v":7.0718970866206446E-2},{"$f":"+V26/V$5","v":7.3023895824942953E-2}]
[null,{"$f":"+Input!B26","v":"Administration"},{"$f":"IF(Input!C$15=Input!B$81,Input!C$26,Input!D$26)","v":30000},{"$f":"($C28+$C28*(D$5-$C$5)/$C$5*$C$63)/D62","v":30910.194174757282},{"$f":"($C28+$C28*(E$5-$C$5)/$C$5*$C$63)/D62/E62","v":30716.376356367789},{"$f":"($C28+$C28*(F$5-$C$5)/$C$5*$C$63)/D62/E62/F62","v":29763.709607554363},{"$f":"AVERAGE(D28:F28)","v":30463.426712893142},null,null,"Administration",{"$f":"+C28","v":30000},{"$f":"($C28+$C28*(L$5-$C$5)/$C$5*$C$63)/L62","v":31195.3125},{"$f":"($C28+$C28*(M$5-$C$5)/$C$5*$C$63)/L62/M62","v":30973.663330078125},{"$f":"($C28+$C28*(N$5-$C$5)/$C$5*$C$63)/L62/M62/N62","v":29854.658224341321},{"$f":"AVERAGE(L28:N28)","v":30674.544684806478},null,"Administration",{"$f":"+C28","v":30000},{"$f":"($C28+$C28*(S$5-$C$5)/$C$5*$C$63)/S62","v":30631.274131274131},{"$f":"($C28+$C28*(T$5-$C$5)/$C$5*$C$63)/S62/T62","v":30469.020764296354},{"$f":"($C28+$C28*(U$5-$C$5)/$C$5*$C$63)/S62/T62/U62","v":29690.736460292417},{"$f":"AVERAGE(S28:U28)","v":30263.677118620966}]
[null,"% Revenue",{"$f":"+C28/C$5","v":0.06},{"$f":"+D28/D$5","v":5.5129870129870133E-2},{"$f":"+E28/E$5","v":5.2175415620793766E-2},{"$f":"+F28/F$5","v":4.7612118440449762E-2},{"$f":"+G28/G$5","v":5.150134883684003E-2},null,null,"% Revenue",{"$f":"+K28/K$5","v":0.06},{"$f":"+L28/L$5","v":5.3814016172506737E-2},{"$f":"+M28/M$5","v":5.0407223036286426E-2},{"$f":"+N28/N$5","v":4.520948723954625E-2},{"$f":"+O28/O$5","v":4.9621296655212553E-2},null,"% Revenue",{"$f":"+R28/R$5","v":0.06},{"$f":"+S28/S$5","v":5.6506410256410261E-2},{"$f":"+T28/T$5","v":5.4045285297178086E-2},{"$f":"+U28/U$5","v":5.0196119917526157E-2},{"$f":"+V28/V$5","v":5.3489935427248919E-2}]
[null,{"$f":"+Input!B27","v":"Labor excluding Owner"},{"$f":"IF(Input!C$15=Input!B$81,Input!C$27,Input!D$27)","v":50000},{"$f":"($C30+$C30*(D$5-$C$5)/$C$5*$C$63)*$D58/D62+($C32+$C32*(D$5-$C$5)/$C$5*$C$63)*$D58/D62-D32","v":51516.990291262133},{"$f":"($C30+$C30*(E$5-$C$5)/$C$5*$C$63)*$D58*$E58/D62/E62+($C32+$C32*(E$5-$C$5)/$C$5*$C$63)*$D58*$E58/D62/E62-E32","v":52729.779411764714},{"$f":"($C30+$C30*(F$5-$C$5)/$C$5*$C$63)*$D58*$E58*F58/D62/E62/F62+($C32+$C32*(F$5-$C$5)/$C$5*$C$63)*$D58*$E58*F58/D62/E62/F62-F32","v":53649.086567616738},{"$f":"AVERAGE(D30:F30)","v":52631.95209021453},null,null,"Labor excluding Owner",{"$f":"+C30","v":50000},{"$f":"($C30+$C30*(L$5-$C$5)/$C$5*$C$63)*$D58/L62+($C32+$C32*(L$5-$C$5)/$C$5*$C$63)*$D58/L62-L32","v":51992.1875},{"$f":"($C30+$C30*(M$5-$C$5)/$C$5*$C$63)*$D58*$E58/L62/M62+($C32+$C32*(M$5-$C$5)/$C$5*$C$63)*$D58*$E58/L62/M62-M32","v":53171.455383300781},{"$f":"($C30+$C30*(N$5-$C$5)/$C$5*$C$63)*$D58*$E58*N58/L62/M62/N62+($C32+$C32*(N$5-$C$5)/$C$5*$C$63)*$D58*$E58*N58/L62/M62/N62-N32","v":53300.516483190717},{"$f":"AVERAGE(L30:N30)","v":52821.386455497159},null,"Labor excluding Owner",{"$f":"+C30","v":50000},{"$f":"($C30+$C30*(S$5-$C$5)/$C$5*$C$63)*$D58/S62+($C32+$C32*(S$5-$C$5)/$C$5*$C$63)*$D58/S62-S32","v":51052.12355212355},{"$f":"($C30+$C30*(T$5-$C$5)/$C$5*$C$63)*$D58*$E58/S62/T62+($C32+$C32*(T$5-$C$5)/$C$5*$C$63)*$D58*$E58/S62/T62-T32","v":52305.152312042075},{"$f":"($C30+$C30*(U$5-$C$5)/$C$5*$C$63)*$D58*$E58*U58/S62/T62/U62+($C32+$C32*(U$5-$C$5)/$C$5*$C$63)*$D58*$E58*U58/S62/T62/U62-U32","v":54027.243445578766},{"$f":"AVERAGE(S30:U30)","v":52461.506436581461}]
[null,"% Revenue",{"$f":"+C30/C$5","v":0.1},{"$f":"+D30/D$5","v":9.1883116883116872E-2},{"$f":"+E30/E$5","v":8.9567796815695988E-2},{"$f":"+F30/F$5","v":8.5820843488910697E-2},{"$f":"+G30/G$5","v":8.8979370249728559E-2},null,null,"% Revenue",{"$f":"+K30/K$5","v":0.1},{"$f":"+L30/L$5","v":8.9690026954177896E-2},{"$f":"+M30/M$5","v":8.6532399545625027E-2},{"$f":"+N30/N$5","v":8.0714004551669924E-2},{"$f":"+O30/O$5","v":8.5447582481838785E-2},null,"% Revenue",{"$f":"+R30/R$5","v":0.1},{"$f":"+S30/S$5","v":9.417735042735044E-2},{"$f":"+T30/T$5","v":9.2777739760155714E-2},{"$f":"+U30/U$5","v":9.1340206209925084E-2},{"$f":"+V30/V$5","v":9.272378173709564E-2}]
[null,{"$f":"+Input!B28","v":"Labor Owner"},{"$f":"IF(Input!C$15=Input!B$81,Input!C$28,Input!D$28)","v":10000},{"$f":"IF((($C32+$C32*(D$5-$C$5)/$C$5*$C$63)*$D58/D62)<=D$64,(($C32+$C32*(D$5-$C$5)/$C$5*$C$63)*$D58/D62),D$64)","v":10303.398058252427},{"$f":"IF((($C32+$C32*(E$5-$C$5)/$C$5*$C$63)*$D58*E58/D62/E62)<=E$64,(($C32+$C32*(E$5-$C$5)/$C$5*$C$63)*$D58*$E58/D62/E62),E$64)","v":10545.955882352941},{"$f":"IF((($C32+$C32*(F$5-$C$5)/$C$5*$C$63)*$D58*E58*F58/D62/E62/F62)<=F$64,(($C32+$C32*(F$5-$C$5)/$C$5*$C$63)*$D58*$E58*F58/D62/E62/F62),F$64)","v":10729.81731352335},{"$f":"AVERAGE(D32:F32)","v":10526.390418042907},null,null,"Labor Owner",{"$f":"+C32","v":10000},{"$f":"IF((($C32+$C32*(L$5-$C$5)/$C$5*$C$63)*$D58/L62)<=L$64,(($C32+$C32*(L$5-$C$5)/$C$5*$C$63)*$D58/L62),L$64)","v":10398.4375},{"$f":"IF((($C32+$C32*(M$5-$C$5)/$C$5*$C$63)*$D58*M58/L62/M62)<=M$64,(($C32+$C32*(M$5-$C$5)/$C$5*$C$63)*$D58*$E58/L62/M62),M$64)","v":10634.291076660156},{"$f":"IF((($C32+$C32*(N$5-$C$5)/$C$5*$C$63)*$D58*M58*N58/L62/M62/N62)<=N$64,(($C32+$C32*(N$5-$C$5)/$C$5*$C$63)*$D58*$E58*N58/L62/M62/N62),N$64)","v":10660.103296638141},{"$f":"AVERAGE(L32:N32)","v":10564.277291099432},null,"Labor Owner",{"$f":"+C32","v":10000},{"$f":"IF((($C32+$C32*(S$5-$C$5)/$C$5*$C$63)*$D58/S62)<=S$64,(($C32+$C32*(S$5-$C$5)/$C$5*$C$63)*$D58/S62),S$64)","v":10210.42471042471},{"$f":"IF((($C32+$C32*(T$5-$C$5)/$C$5*$C$63)*$D58*T58/S62/T62)<=T$64,(($C32+$C32*(T$5-$C$5)/$C$5*$C$63)*$D58*$E58/S62/T62),T$64)","v":10461.030462408416},{"$f":"IF((($C32+$C32*(U$5-$C$5)/$C$5*$C$63)*$D58*T58*U58/S62/T62/U62)<=U$64,(($C32+$C32*(U$5-$C$5)/$C$5*$C$63)*$D58*$E58*U58/S62/T62/U62),U$64)","v":10805.448689115756},{"$f":"AVERAGE(S32:U32)","v":10492.301287316295}]
[null,"% Revenue",{"$f":"+C32/C$5","v":0.02},{"$f":"+D32/D$5","v":1.8376623376623376E-2},{"$f":"+E32/E$5","v":1.7913559363139191E-2},{"$f":"+F32/F$5","v":1.7164168697782142E-2},{"$f":"+G32/G$5","v":1.7795874049945714E-2},null,null,"% Revenue",{"$f":"+K32/K$5","v":0.02},{"$f":"+L32/L$5","v":1.7938005390835579E-2},{"$f":"+M32/M$5","v":1.7306479909125008E-2},{"$f":"+N32/N$5","v":1.6142800910333981E-2},{"$f":"+O32/O$5","v":1.7089516496367755E-2},null,"% Revenue",{"$f":"+R32/R$5","v":0.02},{"$f":"+S32/S$5","v":1.8835470085470086E-2},{"$f":"+T32/T$5","v":1.8555547952031147E-2},{"$f":"+U32/U$5","v":1.8268041241985021E-2},{"$f":"+V32/V$5","v":1.8544756347419131E-2}]
[null,{"$f":"+Input!B29","v":"Interest Costs"},{"$f":"IF(Input!C$15=Input!B$81,Input!C$29,Input!D$29)","v":0},{"$f":"+$C34*D59","v":0},{"$f":"+$C34*D59*E59","v":0},{"$f":"+$C34*D59*E59*F59","v":0},{"$f":"AVERAGE(D34:F34)","v":0},null,null,"Interest Costs",{"$f":"+C34","v":0},{"$f":"+$C34*L59","v":0},{"$f":"+$C34*L59*M59","v":0},{"$f":"+$C34*L59*M59*N59","v":0},{"$f":"AVERAGE(L34:N34)","v":0},null,"Interest Costs",{"$f":"+C34","v":0},{"$f":"+$C34*S59","v":0},{"$f":"+$C34*S59*T59","v":0},{"$f":"+$C34*S59*T59*U59","v":0},{"$f":"AVERAGE(S34:U34)","v":0}]
[null,"% Revenue",{"$f":"+C34/C$5","v":0},{"$f":"+D34/D$5","v":0},{"$f":"+E34/E$5","v":0},{"$f":"+F34/F$5","v":0},{"$f":"+G34/G$5","v":0},null,null,"% Revenue",{"$f":"+K34/K$5","v":0},{"$f":"+L34/L$5","v":0},{"$f":"+M34/M$5","v":0},{"$f":"+N34/N$5","v":0},{"$f":"+O34/O$5","v":0},null,"% Revenue",{"$f":"+R34/R$5","v":0},{"$f":"+S34/S$5","v":0},{"$f":"+T34/T$5","v":0},{"$f":"+U34/U$5","v":0},{"$f":"+V34/V$5","v":0}]
[null,{"$f":"+Input!B30","v":"Other"},{"$f":"IF(Input!C$15=Input!B$81,Input!C$30,Input!D$30)","v":0},{"$f":"($C36+$C36*(D$5-$C$5)/$C$5*$C$63)/D62","v":0},{"$f":"($C36+$C36*(E$5-$C$5)/$C$5*$C$63)/D62/E62","v":0},{"$f":"($C36+$C36*(F$5-$C$5)/$C$5*$C$63)/D62/E62/F62","v":0},{"$f":"AVERAGE(D36:F36)","v":0},null,null,"Other",{"$f":"+C36","v":0},{"$f":"($C36+$C36*(L$5-$C$5)/$C$5*$C$63)/L62","v":0},{"$f":"($C36+$C36*(M$5-$C$5)/$C$5*$C$63)/L62/M62","v":0},{"$f":"($C36+$C36*(N$5-$C$5)/$C$5*$C$63)/L62/M62/N62","v":0},{"$f":"AVERAGE(L36:N36)","v":0},null,"Other",{"$f":"+C36","v":0},{"$f":"($C36+$C36*(S$5-$C$5)/$C$5*$C$63)/S62","v":0},{"$f":"($C36+$C36*(T$5-$C$5)/$C$5*$C$63)/S62/T62","v":0},{"$f":"($C36+$C36*(U$5-$C$5)/$C$5*$C$63)/S62/T62/U62","v":0},{"$f":"AVERAGE(S36:U36)","v":0}]
[null,"% Revenue",{"$f":"+C36/C$5","v":0},{"$f":"+D36/D$5","v":0},{"$f":"+E36/E$5","v":0},{"$f":"+F36/F$5","v":0},{"$f":"+G36/G$5","v":0},null,null,"% Revenue",{"$f":"+K36/K$5","v":0},{"$f":"+L36/L$5","v":0},{"$f":"+M36/M$5","v":0},{"$f":"+N36/N$5","v":0},{"$f":"+O36/O$5","v":0},null,"% Revenue",{"$f":"+R36/R$5","v":0},{"$f":"+S36/S$5","v":0},{"$f":"+T36/T$5","v":0},{"$f":"+U36/U$5","v":0},{"$f":"+V36/V$5","v":0}]
[null,{"$f":"+Input!B31","v":"Total Fixed Costs"},{"$f":"+C26+C28+C30+C32+C36+C34","v":130000},{"$f":"+D26+D28+D30+D32+D36+D34","v":133944.17475728155},{"$f":"+E26+E28+E30+E32+E36+E34","v":135766.38349514565},{"$f":"+F26+F28+F30+F32+F36+F34","v":136645.19080828209},{"$f":"AVERAGE(D38:F38)","v":135451.91635356974},null,null,"Total Fixed Costs",{"$f":"+K26+K28+K30+K32+K36+K34","v":130000},{"$f":"+L26+L28+L30+L32+L36+L34","v":135179.6875},{"$f":"+M26+M28+M30+M32+M36+M34","v":137068.78479003906},{"$f":"+N26+N28+N30+N32+N36+N34","v":137022.53163487557},{"$f":"AVERAGE(L38:N38)","v":136423.66797497155},null,"Total Fixed Costs",{"$f":"+R26+R28+R30+R32+R36+R34","v":130000},{"$f":"+S26+S28+S30+S32+S36+S34","v":132735.52123552124},{"$f":"+T26+T28+T30+T32+T36+T34","v":134510.57033411364},{"$f":"+U26+U28+U30+U32+U36+U34","v":136353.32162619143},{"$f":"AVERAGE(S38:U38)","v":134533.13773194209}]
[null,"Total Fixed Costs %",{"$f":"IF(C38=0,0,+C38/C$5)","v":0.26},{"$f":"IF(D38=0,0,+D38/D$5)","v":0.23889610389610388},{"$f":"IF(E38=0,0,+E38/E$5)","v":0.23061533704390849},{"$f":"IF(F38=0,0,+F38/F$5)","v":0.21858723576010486},{"$f":"IF(G38=0,0,+G38/G$5)","v":0.22899447460358141},null,null,"Total Fixed Costs %",{"$f":"IF(K38=0,0,+K38/K$5)","v":0.26},{"$f":"IF(L38=0,0,+L38/L$5)","v":0.23319407008086254},{"$f":"IF(M38=0,0,+M38/M$5)","v":0.22306876434324621},{"$f":"IF(N38=0,0,+N38/N$5)","v":0.20749587380727427},{"$f":"IF(O38=0,0,+O38/O$5)","v":0.2206885014574094},null,"Total Fixed Costs %",{"$f":"IF(R38=0,0,+R38/R$5)","v":0.26},{"$f":"IF(S38=0,0,+S38/S$5)","v":0.24486111111111117},{"$f":"IF(T38=0,0,+T38/T$5)","v":0.23859191949194219},{"$f":"IF(U38=0,0,+U38/U$5)","v":0.23052333823564269},{"$f":"IF(V38=0,0,+V38/V$5)","v":0.2377823693367066}]
[]
[null,"Total Expenses",{"$f":"+C20+C38","v":440000},{"$f":"+D20+D38","v":471984.98916014691},{"$f":"+E20+E38","v":482544.00155528332},{"$f":"+F20+F38","v":519756.99142884079},{"$f":"AVERAGE(D41:F41)","v":491428.66071475699},null,null,"Total Expenses",{"$f":"+K20+K38","v":440000},{"$f":"+L20+L38","v":482656.4611486487},{"$f":"+M20+M38","v":491847.6065805796},{"$f":"+N20+N38","v":530614.70940977172},{"$f":"AVERAGE(L41:N41)","v":501706.25904633338},null,"Total Expenses",{"$f":"+R20+R38","v":440000},{"$f":"+S20+S38","v":461480.39333976834},{"$f":"+T20+T38","v":473340.12812851521},{"$f":"+U20+U38","v":509108.92324654723},{"$f":"AVERAGE(S41:U41)","v":481309.81490494357}]
[]
[null,{"$f":"+Input!B32","v":"Operating Surplus"},{"$f":"+C5-C41","v":60000},{"$f":"+D5-D41","v":88694.622490338515},{"$f":"+E5-E41","v":106169.59067772643},{"$f":"+F5-F41","v":105371.87455054082},{"$f":"AVERAGE(D43:F43)","v":100078.69590620192},null,null,"Operating Surplus",{"$f":"+K5-K41","v":60000},{"$f":"+L5-L41","v":97031.038851351303},{"$f":"+M5-M41","v":122621.1434194204},{"$f":"+N5-N41","v":129747.972125498},{"$f":"AVERAGE(L43:N43)","v":116466.7181320899},null,"Operating Surplus",{"$f":"+R5-R41","v":60000},{"$f":"+S5-S41","v":80604.54874517367},{"$f":"+T5-T41","v":90428.211639824556},{"$f":"+U5-U41","v":82385.728313678061},{"$f":"AVERAGE(S43:U43)","v":84472.829566225424}]
[null,"Operating Surplus %",{"$f":"IF(C43=0,0,+C43/C$5)","v":0.12},{"$f":"IF(D43=0,0,+D43/D$5)","v":0.15819127474467304},{"$f":"IF(E43=0,0,+E43/E$5)","v":0.18034166711697913},{"$f":"IF(F43=0,0,+F43/F$5)","v":0.16856024459125882},{"$f":"IF(G43=0,0,+G43/G$5)","v":0.16919264787831351},null,null,"Operating Surplus %",{"$f":"IF(K43=0,0,+K43/K$5)","v":0.12},{"$f":"IF(L43=0,0,+L43/L$5)","v":0.16738508049828796},{"$f":"IF(M43=0,0,+M43/M$5)","v":0.19955635403658917},{"$f":"IF(N43=0,0,+N43/N$5)","v":0.19647986743261808},{"$f":"IF(O43=0,0,+O43/O$5)","v":0.1884047385307723},null,"Operating Surplus %",{"$f":"IF(R43=0,0,+R43/R$5)","v":0.12},{"$f":"IF(S43=0,0,+S43/S$5)","v":0.14869357638888878},{"$f":"IF(T43=0,0,+T43/T$5)","v":0.16039959192632697},{"$f":"IF(U43=0,0,+U43/U$5)","v":0.13928397847108789},{"$f":"IF(V43=0,0,+V43/V$5)","v":0.14930261716525656}]
[]
[null,{"$f":"+B88","v":"LESS"},null,null,null,null,null,null,null,"LESS",null,null,null,null,null,null,"LESS"]
[null,{"$f":"+B89","v":"Depreciation Allowance"},{"$f":"+C89","v":12500},{"$f":"+D89","v":12879.247572815533},{"$f":"+E89","v":13054.459951456311},{"$f":"+F89","v":13282.055412371135},{"$f":"+G89","v":13071.920978880991},null,null,"Depreciation Allowance",{"$f":"+K89","v":12500},{"$f":"+L89","v":12998.046875},{"$f":"+M89","v":13215.4296875},{"$f":"+N89","v":13502.266759595435},{"$f":"+O89","v":13238.581107365144},null,"Depreciation Allowance",{"$f":"+R89","v":12500},{"$f":"+S89","v":12763.030888030888},{"$f":"+T89","v":12898.552123552123},{"$f":"+U89","v":13071.841572251407},{"$f":"+V89","v":12911.141527944807}]
[]
[null,{"$f":"+B90","v":"Business Return"},47500,75815.374917522975,93115.130726270116,92089.819138169682,87006.774927320934,null,null,"Business Return",{"$f":"+K90","v":47500},84032.991976351303,109405.7137319204,116245.70536590256,103228.13702472475,null,"Business Return",{"$f":"+R90","v":47500},67841.517857142782,77529.659516272426,69313.886741426657,71561.688038280627]
[null,"Business Return %",{"$f":"+C91","v":9.5000000000000001E-2},{"$f":"+D91","v":0.13522049552389379},{"$f":"+E91","v":0.15816711547814177},{"$f":"+F91","v":0.14731333673720812},{"$f":"+G91","v":0.14709330991985506},null,null,"Business Return %",9.5000000000000001E-2,0.14496257375974347,0.17804927220777364,0.17603312333707929,0.16698908046077535,null,"Business Return %",9.5000000000000001E-2,0.12514923878205117,0.13752042115052157,0.1171843000753984,0.12648264971996193]
[]
[]
[null,"Forecast",null,null,null,null,null,null,null,"Forecast",null,null,null,null,null,null,"Forecast"]
[null,{"$f":"+Input!B38","v":"Relative Indicator"},"Current Year","Year 1","Year 2","Year 3",null,null,null,{"$f":"+$B54","v":"Relative Indicator"},"Current Year","Year 1","Year 2","Year 3",null,null,{"$f":"+$B54","v":"Relative Indicator"},"Current Year","Year 1","Year 2","Year 3"]
[null,{"$f":"+Input!B39","v":"Level of Competition"},1,{"$f":"+Input!C39","v":1.03},{"$f":"+Input!D39","v":1},{"$f":"+Input!E39","v":0.97},null,null,null,{"$f":"+$B55","v":"Level of Competition"},1,{"$f":"D55-(ABS(1-D55)*$K$2)","v":1.024},{"$f":"E55-(ABS(1-E55)*$K$2)","v":1},{"$f":"F55-(ABS(1-F55)*$K$2)","v":0.96399999999999997},null,null,{"$f":"+$B55","v":"Level of Competition"},1,{"$f":"D55+(ABS(1-D55)*$R$2)","v":1.036},{"$f":"E55+(ABS(1-E55)*$R$2)","v":1},{"$f":"F55+(ABS(1-F55)*$R$2)","v":0.97599999999999998}]
[null,{"$f":"+Input!B40","v":"Market Strength"},1,{"$f":"+Input!C40","v":1.05},{"$f":"+Input!D40","v":1},{"$f":"+Input!E40","v":1},null,null,null,{"$f":"+$B56","v":"Market Strength"},1,{"$f":"D56+(ABS(1-D56)*$K$2)","v":1.06},{"$f":"E56+(ABS(1-E56)*$K$2)","v":1},{"$f":"F56+(ABS(1-F56)*$K$2)","v":1},null,null,{"$f":"+$B56","v":"Market Strength"},1,{"$f":"D56-(ABS(1-D56)*$R$2)","v":1.04},{"$f":"E56-(ABS(1-E56)*$R$2)","v":1},{"$f":"F56-(ABS(1-F56)*$R$2)","v":1}]
[null,{"$f":"+Input!B41","v":"Materials & Supplies Costs"},1,{"$f":"+Input!C41","v":1.05},{"$f":"+Input!D41","v":1.05},{"$f":"+Input!E41","v":1},null,null,null,"Materials & Supplies Costs",1,{"$f":"D57-(ABS(1-D57)*$K$2)","v":1.04},{"$f":"E57-(ABS(1-E57)*$K$2)","v":1.04},1,null,null,"Materials & Supplies Costs",1,{"$f":"D57+(ABS(1-D57)*$R$2)","v":1.06},{"$f":"E57+(ABS(1-E57)*$R$2)","v":1.06},1]
[null,{"$f":"+Input!B42","v":"Labor Costs"},1,{"$f":"+Input!C42","v":1},{"$f":"+Input!D42","v":1.03},{"$f":"+Input!E42","v":1.05},null,null,null,"Labor Costs",1,{"$f":"D58-(ABS(1-D58)*$K$2)","v":1},1.024,1.04,null,null,"Labor Costs",1,{"$f":"D58+(ABS(1-D58)*$R$2)","v":1},1.036,1.06]
[null,{"$f":"+Input!B43","v":"Interest Rates"},1,{"$f":"+Input!C43","v":1},{"$f":"+Input!D43","v":1.05},{"$f":"+Input!E43","v":0.95},null,null,null,"Interest Rates",1,{"$f":"D59-(ABS(1-D59)*$K$2)","v":1},1.04,0.94,null,null,"Interest Rates",1,{"$f":"D59+(ABS(1-D59)*$R$2)","v":1},1.06,0.96]
[null,{"$f":"+Input!B44","v":"Business Market Position"},1,{"$f":"+Input!C44","v":1.1000000000000001},{"$f":"+Input!D44","v":1.05},{"$f":"+Input!E44","v":1.03},null,null,null,"Business Market Position",1,{"$f":"D60+(ABS(1-D60)*$K$2)","v":1.1200000000000001},{"$f":"E60+(ABS(1-E60)*$K$2)","v":1.06},1.036,null,null,"Business Market Position",1,{"$f":"D60-(ABS(1-D60)*$R$2)","v":1.08},1.04,1.024]
[null,{"$f":"+Input!B45","v":"Variable Cost Efficiency"},1,{"$f":"+Input!C45","v":1.03},{"$f":"+Input!D45","v":1.05},{"$f":"+Input!E45","v":1},null,null,null,"Variable Cost Efficiency",1,{"$f":"D61+(ABS(1-D61)*$K$2)","v":1.036},1.06,1,null,null,"Variable Cost Efficiency",1,1.024,1.04,1]
[null,{"$f":"+Input!B46","v":"Fixed Cost Efficiency"},1,{"$f":"+Input!C46","v":1},{"$f":"+Input!D46","v":1.02},{"$f":"+Input!E46","v":1.05},null,null,null,"Fixed Cost Efficiency",1,{"$f":"D62+(ABS(1-D62)*$K$2)","v":1},1.024,1.06,null,null,"Fixed Cost Efficiency",1,1,1.016,1.04]
[null,{"$f":"+Input!B48","v":"Fixed Cost Flow-on"},{"$f":"+Input!C48","v":0.25},null,null,null,null,null,null,"Fixed Cost Flow-on",{"$f":"$C$63*(1-$K$2)","v":0.2},null,null,null,null,null,"Fixed Cost Flow-on",{"$f":"$C$63*(1+$R$2)","v":0.3}]
[null,"Owners Max Business Labor Earnings",{"$f":"+D76","v":60000},{"$f":"+C64*D$58","v":60000},{"$f":"+D64*$E$58","v":61800},{"$f":"+E64*$F$58","v":64890},null,null,null,{"$f":"+B64","v":"Owners Max Business Labor Earnings"},{"$f":"+L76","v":60000},{"$f":"+K64*L$58","v":60000},{"$f":"+L64*$E$58","v":61800},{"$f":"+M64*$F$58","v":64890},null,null,{"$f":"+B64","v":"Owners Max Business Labor Earnings"},{"$f":"+C64","v":60000},{"$f":"+R64*S$58","v":60000},{"$f":"+S64*$E$58","v":61800},{"$f":"+T64*$F$58","v":64890}]
[null,{"$f":"+B5","v":"Business Revenue"},{"$f":"+C5","v":500000},{"$f":"+D5","v":560679.61165048543},{"$f":"+E5","v":588713.59223300975},{"$f":"+F5","v":625128.8659793816},null,null,null,{"$f":"+J5","v":"Business Revenue"},{"$f":"+K5","v":500000},{"$f":"+L5","v":579687.5},{"$f":"+M5","v":614468.75},{"$f":"+N5","v":660362.68153526972},null,null,{"$f":"+Q5","v":"Business Revenue"},{"$f":"+R5","v":500000},{"$f":"+S5","v":542084.94208494201},{"$f":"+T5","v":563768.33976833976},{"$f":"+U5","v":591494.65156022529}]
[null,{"$f":"+B20","v":"Total Variable Costs"},310000,338040.81440286536,346777.61806013767,383111.80062055867,null,null,null,{"$f":"+J20","v":"Total Variable Costs"},310000,347476.7736486487,354778.82179054053,393592.1777748962,null,null,{"$f":"+Q20","v":"Total Variable Costs"},310000,328744.8721042471,338829.55779440154,372755.6016203558]
[null,"Total Variable Costs %",0.62,0.60291262135922308,0.58904299583911235,0.6128525196486363,null,null,null,"Total Variable Costs %",0.62,0.5994208494208495,0.57737488162016459,0.59602425876010767,null,null,"Total Variable Costs %",0.62,0.60644531250000011,0.60100848858173073,0.63019268329326938]
[null,{"$f":"+B38","v":"Total Fixed Costs"},130000,133944.17475728155,135766.38349514565,136645.19080828209,null,null,null,{"$f":"+J38","v":"Total Fixed Costs"},130000,135179.6875,137068.78479003906,137022.53163487557,null,null,{"$f":"+Q38","v":"Total Fixed Costs"},130000,132735.52123552124,134510.57033411364,136353.32162619143]
[null,"Total Fixed Costs %",0.26,0.23889610389610388,0.23061533704390849,0.21858723576010486,null,null,null,"Total Fixed Costs %",0.26,0.23319407008086254,0.22306876434324621,0.20749587380727427,null,null,"Total Fixed Costs %",0.26,0.24486111111111117,0.23859191949194219,0.23052333823564269]
[null,{"$f":"+B43","v":"Operating Surplus"},60000,88694.622490338515,106169.59067772643,105371.87455054082,null,null,null,{"$f":"+J43","v":"Operating Surplus"},60000,97031.038851351303,122621.1434194204,129747.972125498,null,null,{"$f":"+Q43","v":"Operating Surplus"},60000,80604.54874517367,90428.211639824556,82385.728313678061]
[null,"Operating Surplus %",0.12,0.15819127474467304,0.18034166711697913,0.16856024459125882,null,null,null,"Operating Surplus %",0.12,0.16738508049828796,0.19955635403658917,0.19647986743261808,null,null,"Operating Surplus %",0.12,0.14869357638888878,0.16039959192632697,0.13928397847108789]
[]
[null,"Investment",null,null,null,null,null,null,null,"Investment",null,null,null,null,null,null,"Investment"]
[null,"Owners Current Business Labor Earnings",null,{"$f":"+C12+C32","v":60000},null,null,null,null,null,"Owners Current Business Labor Earnings",null,{"$f":"+K12+K32","v":60000},null,null,null,null,"Owners Current Business Labor Earnings",null,{"$f":"+R12+R32","v":60000}]
[null,{"$f":"+Input!B50","v":"Owners Time Commitment to Business"},null,{"$f":"+Input!C50","v":1},null,null,null,null,null,{"$f":"+B75","v":"Owners Time Commitment to Business"},null,{"$f":"+D75","v":1},null,null,null,null,{"$f":"+B75","v":"Owners Time Commitment to Business"},null,{"$f":"+D75","v":1}]
[null,"Owners Maximum Business Labor Earnings",null,{"$f":"+D74/D75","v":60000},null,null,null,null,null,"Owners Maximum Business Labor Earnings",null,{"$f":"+L74/L75","v":60000},null,null,null,null,"Owners Maximum Business Labor Earnings",null,{"$f":"+S74/S75","v":60000}]
[null,{"$f":"+Input!B51","v":"Replacement Value of Business Assets"},null,{"$f":"+Input!C51","v":100000},null,null,null,null,null,{"$f":"+B77","v":"Replacement Value of Business Assets"},null,{"$f":"+D77","v":100000},null,null,null,null,{"$f":"+B77","v":"Replacement Value of Business Assets"},null,{"$f":"+D77","v":100000}]
[null,{"$f":"+Input!B52","v":"Life of Assets (years)"},null,{"$f":"+Input!C52","v":8},null,null,null,null,null,{"$f":"+B78","v":"Life of Assets (years)"},null,{"$f":"+D78","v":8},null,null,null,null,{"$f":"+B78","v":"Life of Assets (years)"},null,{"$f":"+D78","v":8}]
[]
[null,"Return",null,null,null,null,null,null,null,"Return",null,null,null,null,null,null,"Return"]
[null,null,{"$f":"+C4","v":"Current Year"},"Year 1","Year 2","Year 3","3 Year Average",null,null,null,{"$f":"+K4","v":"Current Year"},"Year 1","Year 2","Year 3","3 Year Average",null,null,{"$f":"+R4","v":"Current Year"},"Year 1","Year 2","Year 3","3 Year Average"]
[null,{"$f":"+B5","v":"Business Revenue"},500000,560679.61165048543,588713.59223300975,625128.8659793816,{"$f":"AVERAGE(D82:F82)","v":591507.35662095889},null,null,{"$f":"+J5","v":"Business Revenue"},500000,579687.5,614468.75,660362.68153526972,{"$f":"AVERAGE(L82:N82)","v":618172.9771784232},null,{"$f":"+Q5","v":"Business Revenue"},500000,542084.94208494201,563768.33976833976,591494.65156022529,{"$f":"AVERAGE(S82:U82)","v":565782.6444711691}]
[null,{"$f":"+B20","v":"Total Variable Costs"},{"$f":"+C20","v":310000},{"$f":"+D20","v":338040.81440286536},{"$f":"+E20","v":346777.61806013767},{"$f":"+F20","v":383111.80062055867},{"$f":"AVERAGE(D83:F83)","v":355976.74436118727},null,null,{"$f":"+J20","v":"Total Variable Costs"},{"$f":"+K20","v":310000},{"$f":"+L20","v":347476.7736486487},{"$f":"+M20","v":354778.82179054053},{"$f":"+N20","v":393592.1777748962},{"$f":"AVERAGE(L83:N83)","v":365282.59107136185},null,{"$f":"+Q20","v":"Total Variable Costs"},{"$f":"+R20","v":310000},{"$f":"+S20","v":328744.8721042471},{"$f":"+T20","v":338829.55779440154},{"$f":"+U20","v":372755.6016203558},{"$f":"AVERAGE(S83:U83)","v":346776.67717300146}]
[null,{"$f":"+B38","v":"Total Fixed Costs"},{"$f":"+C38","v":130000},{"$f":"+D38","v":133944.17475728155},{"$f":"+E38","v":135766.38349514565},{"$f":"+F38","v":136645.19080828209},{"$f":"AVERAGE(D84:F84)","v":135451.91635356974},null,null,{"$f":"+J38","v":"Total Fixed Costs"},{"$f":"+K38","v":130000},{"$f":"+L38","v":135179.6875},{"$f":"+M38","v":137068.78479003906},{"$f":"+N38","v":137022.53163487557},{"$f":"AVERAGE(L84:N84)","v":136423.66797497155},null,{"$f":"+Q38","v":"Total Fixed Costs"},{"$f":"+R38","v":130000},{"$f":"+S38","v":132735.52123552124},{"$f":"+T38","v":134510.57033411364},{"$f":"+U38","v":136353.32162619143},{"$f":"AVERAGE(S84:U84)","v":134533.13773194209}]
[]
[null,{"$f":"+B43","v":"Operating Surplus"},{"$f":"+C43","v":60000},{"$f":"+D43","v":88694.622490338515},{"$f":"+E43","v":106169.59067772643},{"$f":"+F43","v":105371.87455054082},{"$f":"AVERAGE(D86:F86)","v":100078.69590620192},null,null,{"$f":"+J43","v":"Operating Surplus"},{"$f":"+K43","v":60000},{"$f":"+L43","v":97031.038851351303},{"$f":"+M43","v":122621.1434194204},{"$f":"+N43","v":129747.972125498},{"$f":"AVERAGE(L86:N86)","v":116466.7181320899},null,{"$f":"+Q43","v":"Operating Surplus"},{"$f":"+R43","v":60000},{"$f":"+S43","v":80604.54874517367},{"$f":"+T43","v":90428.211639824556},{"$f":"+U43","v":82385.728313678061},{"$f":"AVERAGE(S86:U86)","v":84472.829566225424}]
[null,"Business Surplus on Sales",{"$f":"+C86/C$82","v":0.12},{"$f":"+D86/D$82","v":0.15819127474467304},{"$f":"+E86/E$82","v":0.18034166711697913},{"$f":"+F86/F$82","v":0.16856024459125882},{"$f":"+G86/G$82","v":0.16919264787831351},null,null,"Business Surplus on Sales",{"$f":"+K86/K$82","v":0.12},{"$f":"+L86/L$82","v":0.16738508049828796},{"$f":"+M86/M$82","v":0.19955635403658917},{"$f":"+N86/N$82","v":0.19647986743261808},{"$f":"+O86/O$82","v":0.1884047385307723},null,"Business Surplus on Sales",{"$f":"+R86/R$82","v":0.12},{"$f":"+S86/S$82","v":0.14869357638888878},{"$f":"+T86/T$82","v":0.16039959192632697},{"$f":"+U86/U$82","v":0.13928397847108789},{"$f":"+V86/V$82","v":0.14930261716525656}]
[null,"LESS",null,null,null,null,null,null,null,"LESS",null,null,null,null,null,null,"LESS"]
[null,"Depreciation Allowance",{"$f":"+D77/D78","v":12500},{"$f":"$C89+$C89*(D$5-$C$5)/$C$5*$C$63","v":12879.247572815533},{"$f":"$C89+$C89*(E$5-$C$5)/$C$5*$C$63","v":13054.459951456311},{"$f":"$C89+$C89*(F$5-$C$5)/$C$5*$C$63","v":13282.055412371135},{"$f":"AVERAGE(D89:F89)","v":13071.920978880991},null,null,{"$f":"+B89","v":"Depreciation Allowance"},{"$f":"+L77/L78","v":12500},{"$f":"$C89+$C89*(L$5-$C$5)/$C$5*$C$63","v":12998.046875},{"$f":"$C89+$C89*(M$5-$C$5)/$C$5*$C$63","v":13215.4296875},{"$f":"$C89+$C89*(N$5-$C$5)/$C$5*$C$63","v":13502.266759595435},{"$f":"AVERAGE(L89:N89)","v":13238.581107365144},null,{"$f":"+B89","v":"Depreciation Allowance"},{"$f":"+S77/S78","v":12500},{"$f":"$C89+$C89*(S$5-$C$5)/$C$5*$C$63","v":12763.030888030888},{"$f":"$C89+$C89*(T$5-$C$5)/$C$5*$C$63","v":12898.552123552123},{"$f":"$C89+$C89*(U$5-$C$5)/$C$5*$C$63","v":13071.841572251407},{"$f":"AVERAGE(S89:U89)","v":12911.141527944807}]
[null,"Business Return",{"$f":"+C86-C89","v":47500},{"$f":"+D86-D89","v":75815.374917522975},{"$f":"+E86-E89","v":93115.130726270116},{"$f":"+F86-F89","v":92089.819138169682},{"$f":"AVERAGE(D90:F90)","v":87006.774927320934},null,null,{"$f":"+B90","v":"Business Return"},{"$f":"+K86-K89","v":47500},{"$f":"+L86-L89","v":84032.991976351303},{"$f":"+M86-M89","v":109405.7137319204},{"$f":"+N86-N89","v":116245.70536590256},{"$f":"AVERAGE(L90:N90)","v":103228.13702472475},null,{"$f":"+B90","v":"Business Return"},{"$f":"+R86-R89","v":47500},{"$f":"+S86-S89","v":67841.517857142782},{"$f":"+T86-T89","v":77529.659516272426},{"$f":"+U86-U89","v":69313.886741426657},{"$f":"AVERAGE(S90:U90)","v":71561.688038280627}]
[null,"Return on Sales",{"$f":"+C90/C82","v":9.5000000000000001E-2},{"$f":"+D90/D82","v":0.13522049552389379},{"$f":"+E90/E82","v":0.15816711547814177},{"$f":"+F90/F82","v":0.14731333673720812},{"$f":"+G90/G82","v":0.14709330991985506},null,null,{"$f":"+B91","v":"Return on Sales"},{"$f":"+K90/K82","v":9.5000000000000001E-2},{"$f":"+L90/L82","v":0.14496257375974347},{"$f":"+M90/M82","v":0.17804927220777364},{"$f":"+N90/N82","v":0.17603312333707929},{"$f":"+O90/O82","v":0.16698908046077535},null,{"$f":"+B91","v":"Return on Sales"},{"$f":"+R90/R82","v":9.5000000000000001E-2},{"$f":"+S90/S82","v":0.12514923878205117},{"$f":"+T90/T82","v":0.13752042115052157},{"$f":"+U90/U82","v":0.1171843000753984},{"$f":"+V90/V82","v":0.12648264971996193}]

{"sheet":"Scratch","index":17,"n_rows":107,"n_cols":10,"rows_kept":107,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E42:E46)","v":298}]
[null,{"$f":"1","v":1},"f",{"$f":"IFERROR(CODE(C42),0)","v":102},{"$f":"B42*D42","v":102}]
[null,{"$f":"B42+1","v":2},"b",{"$f":"IFERROR(CODE(C43),0)","v":98},{"$f":"B43*D43","v":196}]
[null,3,null,0,0]
[null,4,null,0,0]
[null,5,null,0,0]
[]
[]
[]
[null," In evaluation mode functionality is limited."]
[]
[null,"Locked",500000]
[null,{"$f":"IFERROR(AND(ISTEXT(Welcome!C18),LEN(Welcome!C18)>6),FALSE)","v":false},null,"emall len >6"]
[null,{"$f":"IFERROR(AND(ISNUMBER(INT(Welcome!C19)),LEN(Welcome!C19)>8),FALSE)","v":false},{"$f":"IFERROR(Welcome!C19/Scratch!E57/E41,FALSE)","v":false},"code len>8","yyyymmdd=code/emailchsum/i"]
[null,{"$f":"IFERROR(AND(ISNUMBER(C54),LEN(C54)=8,TODAY()<C55+7),FALSE)","v":false},{"$f":"IFERROR(DATE(MID(C54,1,4),MID(C54,5,2),MID(C54,7,2)),FALSE)","v":false},null,"yyyymmdd len=8",null,"IF(ISNUMBER(C55),IF(C55>TODAY()+3650,2,IF(C55>TODAY()-2,1,0)),0)"]
[null,null,{"$f":"IF(ISNUMBER(C55),IF(C55>TODAY()+3650,2,IF(C55>TODAY()-2,1,0)),0)","v":0},"status",">today+36500days=2",null,null,null,null,{"$f":"I56*J57*E41","v":0}]
[null,null,null,null,{"$f":"SUM(E58:E107)","v":0},null,null,null,null,{"$f":"SUM(J58:J107)","v":0}]
[null,{"$f":"1","v":1},{"$f":"MID(Welcome!$C$18,B58,1)","v":""},{"$f":"IFERROR(CODE(C58),0)","v":0},{"$f":"B58*D58","v":0},null,{"$f":"1","v":1},{"$f":"MID($G$56,G58,1)","v":""},{"$f":"IFERROR(CODE(H58),0)","v":0},{"$f":"G58*I58","v":0}]
[null,{"$f":"B58+1","v":2},{"$f":"MID(Welcome!$C$18,B59,1)","v":""},0,0,null,{"$f":"G58+1","v":2},{"$f":"MID($G$56,G59,1)","v":""},0,0]
[null,3,{"$f":"MID(Welcome!$C$18,B60,1)","v":""},0,0,null,3,"",0,0]
[null,4,{"$f":"MID(Welcome!$C$18,B61,1)","v":""},0,0,null,4,"",0,0]
[null,5,{"$f":"MID(Welcome!$C$18,B62,1)","v":""},0,0,null,5,"",0,0]
[null,6,{"$f":"MID(Welcome!$C$18,B63,1)","v":""},0,0,null,6,"",0,0]
[null,7,{"$f":"MID(Welcome!$C$18,B64,1)","v":""},0,0,null,7,"",0,0]
[null,8,{"$f":"MID(Welcome!$C$18,B65,1)","v":""},0,0,null,8,"",0,0]
[null,9,{"$f":"MID(Welcome!$C$18,B66,1)","v":""},0,0,null,9,"",0,0]
[null,10,{"$f":"MID(Welcome!$C$18,B67,1)","v":""},0,0,null,10,"",0,0]
[null,11,{"$f":"MID(Welcome!$C$18,B68,1)","v":""},0,0,null,11,"",0,0]
[null,12,{"$f":"MID(Welcome!$C$18,B69,1)","v":""},0,0,null,12,"",0,0]
[null,13,{"$f":"MID(Welcome!$C$18,B70,1)","v":""},0,0,null,13,"",0,0]
[null,14,{"$f":"MID(Welcome!$C$18,B71,1)","v":""},0,0,null,14,"",0,0]
[null,15,{"$f":"MID(Welcome!$C$18,B72,1)","v":""},0,0,null,15,"",0,0]
[null,16,{"$f":"MID(Welcome!$C$18,B73,1)","v":""},0,0,null,16,"",0,0]
[null,17,{"$f":"MID(Welcome!$C$18,B74,1)","v":""},0,0,null,17,"",0,0]
[null,18,{"$f":"MID(Welcome!$C$18,B75,1)","v":""},0,0,null,18,"",0,0]
[null,19,{"$f":"MID(Welcome!$C$18,B76,1)","v":""},0,0,null,19,"",0,0]
[null,20,{"$f":"MID(Welcome!$C$18,B77,1)","v":""},0,0,null,20,"",0,0]
[null,21,{"$f":"MID(Welcome!$C$18,B78,1)","v":""},0,0,null,21,"",0,0]
[null,22,{"$f":"MID(Welcome!$C$18,B79,1)","v":""},0,0,null,22,"",0,0]
[null,23,{"$f":"MID(Welcome!$C$18,B80,1)","v":""},0,0,null,23,"",0,0]
[null,24,{"$f":"MID(Welcome!$C$18,B81,1)","v":""},0,0,null,24,"",0,0]
[null,25,{"$f":"MID(Welcome!$C$18,B82,1)","v":""},0,0,null,25,"",0,0]
[null,26,{"$f":"MID(Welcome!$C$18,B83,1)","v":""},0,0,null,26,"",0,0]
[null,27,{"$f":"MID(Welcome!$C$18,B84,1)","v":""},0,0,null,27,"",0,0]
[null,28,{"$f":"MID(Welcome!$C$18,B85,1)","v":""},0,0,null,28,"",0,0]
[null,29,{"$f":"MID(Welcome!$C$18,B86,1)","v":""},0,0,null,29,"",0,0]
[null,30,{"$f":"MID(Welcome!$C$18,B87,1)","v":""},0,0,null,30,"",0,0]
[null,31,{"$f":"MID(Welcome!$C$18,B88,1)","v":""},0,0,null,31,"",0,0]
[null,32,{"$f":"MID(Welcome!$C$18,B89,1)","v":""},0,0,null,32,"",0,0]
[null,33,{"$f":"MID(Welcome!$C$18,B90,1)","v":""},0,0,null,33,"",0,0]
[null,34,{"$f":"MID(Welcome!$C$18,B91,1)","v":""},0,0,null,34,"",0,0]
[null,35,{"$f":"MID(Welcome!$C$18,B92,1)","v":""},0,0,null,35,"",0,0]
[null,36,{"$f":"MID(Welcome!$C$18,B93,1)","v":""},0,0,null,36,"",0,0]
[null,37,{"$f":"MID(Welcome!$C$18,B94,1)","v":""},0,0,null,37,"",0,0]
[null,38,{"$f":"MID(Welcome!$C$18,B95,1)","v":""},0,0,null,38,"",0,0]
[null,39,{"$f":"MID(Welcome!$C$18,B96,1)","v":""},0,0,null,39,"",0,0]
[null,40,{"$f":"MID(Welcome!$C$18,B97,1)","v":""},0,0,null,40,"",0,0]
[null,41,{"$f":"MID(Welcome!$C$18,B98,1)","v":""},0,0,null,41,"",0,0]
[null,42,{"$f":"MID(Welcome!$C$18,B99,1)","v":""},0,0,null,42,"",0,0]
[null,43,{"$f":"MID(Welcome!$C$18,B100,1)","v":""},0,0,null,43,"",0,0]
[null,44,{"$f":"MID(Welcome!$C$18,B101,1)","v":""},0,0,null,44,"",0,0]
[null,45,{"$f":"MID(Welcome!$C$18,B102,1)","v":""},0,0,null,45,"",0,0]
[null,46,{"$f":"MID(Welcome!$C$18,B103,1)","v":""},0,0,null,46,"",0,0]
[null,47,{"$f":"MID(Welcome!$C$18,B104,1)","v":""},0,0,null,47,"",0,0]
[null,48,{"$f":"MID(Welcome!$C$18,B105,1)","v":""},0,0,null,48,"",0,0]
[null,49,{"$f":"MID(Welcome!$C$18,B106,1)","v":""},0,0,null,49,"",0,0]
[null,50,{"$f":"MID(Welcome!$C$18,B107,1)","v":""},0,0,null,50,"",0,0]