{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Break-Even","BE Analysis","BE Calculations"],"not_rendered":{"charts":4,"defined_names":28,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Break-Even","index":0,"n_rows":44,"n_cols":7,"rows_kept":44,"merged":[[4,2,4,6],[46,2,46,6]]}
[]
[]
[]
[]
[null,null,"Break-Even Analysis"]
[]
[]
[{"$nulls":3},2007,{"$f":"D8+1","v":2008},{"$f":"E8+1","v":2009},{"$f":"F8+1","v":2010}]
[]
[null,null,"Sales",{"v":2010000,"d":"$2,010,000"},{"v":2060000,"d":"$2,060,000"},{"v":2121800,"d":"$2,121,800"},{"v":2391800,"d":"$2,391,800"}]
[]
[null,null,"Less Variable Expenses"]
[null,null,"Materials",{"v":320000,"d":"$320,000"},{"v":329600,"d":"$329,600"},{"v":339488,"d":"$339,488"},{"v":389088,"d":"$389,088"}]
[null,null,"Labor",{"v":500000,"d":"$500,000"},{"v":515000,"d":"$515,000"},{"v":530450,"d":"$530,450"},{"v":545450,"d":"$545,450"}]
[null,null,"Variable overhead",{"v":125000,"d":"$125,000"},{"v":128750,"d":"$128,750"},{"v":132612.5,"d":"$132,613"},{"v":186362.5,"d":"$186,363"}]
[null,null,"Other",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,null,"Contribution Margin",{"$f":"D10-(D13+D14+D15+D16)","v":{"v":1065000,"d":"1,065,000 "}},{"$f":"E10-(E13+E14+E15+E16)","v":{"v":1086650,"d":"1,086,650 "}},{"$f":"F10-(F13+F14+F15+F16)","v":{"v":1119249.5,"d":"1,119,250 "}},{"$f":"G10-(G13+G14+G15+G16)","v":{"v":1270899.5,"d":"1,270,900 "}}]
[null,null,"Contribution Margin Ratio",{"$f":"D17/D10","v":{"v":0.5298507462686567,"d":"52.99%"}},{"$f":"E17/E10","v":{"v":0.5275,"d":"52.75%"}},{"$f":"F17/F10","v":{"v":0.5275,"d":"52.75%"}},{"$f":"G17/G10","v":{"v":0.5313569278367757,"d":"53.14%"}}]
[]
[null,null,"Fixed Expenses"]
[null,null,"Salaries and wages",{"v":190000,"d":"$190,000"},{"v":190000,"d":"$190,000"},{"v":190000,"d":"$190,000"},{"v":190000,"d":"$190,000"}]
[null,null,"Employee benefits",{"v":50000,"d":"$50,000"},{"v":51500,"d":"$51,500"},{"v":53045,"d":"$53,045"},{"v":54545,"d":"$54,545"}]
[null,null,"Payroll taxes",{"v":30000,"d":"$30,000"},{"v":30900,"d":"$30,900"},{"v":31827,"d":"$31,827"},{"v":32727,"d":"$32,727"}]
[null,null,"Rent",{"v":5000,"d":"$5,000"},{"v":5150,"d":"$5,150"},{"v":5304.5,"d":"$5,305"},{"v":5454.5,"d":"$5,455"}]
[null,null,"Utilities",{"v":3000,"d":"$3,000"},{"v":3090,"d":"$3,090"},{"v":3182.7,"d":"$3,183"},{"v":3272.7,"d":"$3,273"}]
[null,null,"Repairs and maintenance",{"v":1000,"d":"$1,000"},{"v":1030,"d":"$1,030"},{"v":1060.9,"d":"$1,061"},{"v":1060.9,"d":"$1,061"}]
[null,null,"Insurance",{"v":1000,"d":"$1,000"},{"v":1030,"d":"$1,030"},{"v":1060.9,"d":"$1,061"},{"v":1060.9,"d":"$1,061"}]
[null,null,"Travel",{"v":2133,"d":"$2,133"},{"v":2196.99,"d":"$2,197"},{"v":2262.8997,"d":"$2,263"},{"v":2262.8997,"d":"$2,263"}]
[null,null,"Telephone",{"v":11000,"d":"$11,000"},{"v":11330,"d":"$11,330"},{"v":11669.9,"d":"$11,670"},{"v":12669.9,"d":"$12,670"}]
[null,null,"Postage",{"v":4000,"d":"$4,000"},{"v":4120,"d":"$4,120"},{"v":4243.6,"d":"$4,244"},{"v":4243.6,"d":"$4,244"}]
[null,null,"Office supplies",{"v":6000,"d":"$6,000"},{"v":6180,"d":"$6,180"},{"v":6365.4,"d":"$6,365"},{"v":6365.4,"d":"$6,365"}]
[null,null,"Advertising",{"v":1000,"d":"$1,000"},{"v":1030,"d":"$1,030"},{"v":1060.9,"d":"$1,061"},{"v":1060.9,"d":"$1,061"}]
[null,null,"Marketing/promotion",{"v":3000,"d":"$3,000"},{"v":3090,"d":"$3,090"},{"v":3182.7,"d":"$3,183"},{"v":3182.7,"d":"$3,183"}]
[null,null,"Professional fees",{"v":1000,"d":"$1,000"},{"v":1030,"d":"$1,030"},{"v":1060.9,"d":"$1,061"},{"v":1060.9,"d":"$1,061"}]
[null,null,"Training and development",{"v":1000,"d":"$1,000"},{"v":1030,"d":"$1,030"},{"v":1060.9,"d":"$1,061"},{"v":1060.9,"d":"$1,061"}]
[null,null,"Bank charges",{"v":1000,"d":"$1,000"},{"v":1030,"d":"$1,030"},{"v":1060.9,"d":"$1,061"},{"v":1060.9,"d":"$1,061"}]
[null,null,"Depreciation",{"v":1000,"d":"$1,000"},{"v":1030,"d":"$1,030"},{"v":1060.9,"d":"$1,061"},{"v":1060.9,"d":"$1,061"}]
[null,null,"Interest Expense",{"v":6000,"d":"$6,000"},{"v":6000,"d":"$6,000"},{"v":6000,"d":"$6,000"},{"v":6000,"d":"$6,000"}]
[null,null,"Other",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,null,"Total Fixed Expenses",{"$f":"SUM(D21:D38)","v":{"v":317133,"d":"317,133 "}},{"$f":"SUM(E21:E38)","v":{"v":320766.99,"d":"320,767 "}},{"$f":"SUM(F21:F38)","v":{"v":324509.9997000002,"d":"324,510 "}},{"$f":"SUM(G21:G38)","v":{"v":328149.9997000002,"d":"328,150 "}}]
[null,null,"Total Fixed Expenses Ratio",{"$f":"D40/D10","v":{"v":0.15777761194029852,"d":"15.78%"}},{"$f":"E40/E10","v":{"v":0.15571213106796117,"d":"15.57%"}},{"$f":"F40/F10","v":{"v":0.15294089909510802,"d":"15.29%"}},{"$f":"G40/G10","v":{"v":0.13719792612258558,"d":"13.72%"}}]
[null,null,"Break-Even Sales",{"$f":"D10*D43","v":{"v":598532.7042253522,"d":"598,533 "}},{"$f":"E10*E43","v":{"v":608089.0805687204,"d":"608,089 "}},{"$f":"F10*F43","v":{"v":615184.8335545028,"d":"615,185 "}},{"$f":"G10*G43","v":{"v":617569.8151446756,"d":"617,570 "}}]
[null,null,"Break-Even %",{"$f":"(D40/(D40+D44))","v":{"v":0.2977774647887324,"d":"29.78%"}},{"$f":"(E40/(E40+E44))","v":{"v":0.2951888740624856,"d":"29.52%"}},{"$f":"(F40/(F40+F44))","v":{"v":0.28993535373480195,"d":"28.99%"}},{"$f":"(G40/(G40+G44))","v":{"v":0.25820294972183105,"d":"25.82%"}}]
[null,null,"Operating Profit",{"$f":"(D17-D40)","v":{"v":747867,"d":"747,867 "}},{"$f":"(E17-E40)","v":{"v":765883.01,"d":"765,883 "}},{"$f":"(F17-F40)","v":{"v":794739.5002999997,"d":"794,740 "}},{"$f":"(G17-G40)","v":{"v":942749.5002999997,"d":"942,750 "}}]

{"sheet":"BE Analysis","index":1,"n_rows":41,"n_cols":25,"rows_kept":41,"merged":[[31,10,31,24]]}
[]
[{"$nulls":12},"Break-Even Analysis"]
[]
[{"$nulls":10},"Current BE Chart",{"$nulls":3},"Current Pie",{"$nulls":3},"Projected BE Chart",{"$nulls":3},"Projected Pie"]
[{"$nulls":11},"Sales $",{"$f":"Q23","v":{"v":2010000,"d":"$2,010,000"}},null,null,"Fixed %",{"$f":"Q24/$Q$23","v":{"v":0.15777761194029852,"d":"15.78%"}},null,null,"Sales $",{"$f":"S23","v":{"v":2391800,"d":"$2,391,800"}},null,null,"Fixed %",{"$f":"S24/S23","v":{"v":0.13259177188728155,"d":"13.26%"}}]
[{"$nulls":11},"Fixed $",{"$f":"Q24","v":{"v":317133,"d":"$317,133"}},null,null,"Total Variable %",{"$f":"Q26","v":{"v":0.5298507462686567,"d":"52.99%"}},null,null,"Fixed $",{"$f":"S24","v":{"v":317133,"d":"$317,133"}},null,null,"Total Variable %",{"$f":"S26","v":{"v":0.3950999247428715,"d":"39.51%"}}]
[{"$nulls":11},"Total Variable $",{"$f":"Q25","v":{"v":1065000,"d":"$1,065,000"}},null,null,"Profit %",{"$f":"Q27/$Q$23","v":{"v":0.31237164179104476,"d":"31.24%"}},null,null,"Total Variable $",{"$f":"S25","v":{"v":945000,"d":"$945,000"}},null,null,"Profit %",{"$f":"S27/S23","v":{"v":0.47230830336984697,"d":"47.23%"}}]
{"$rows_empty":14}
[{"$nulls":16},"Current",null,"Projected",null,{"$f":"IF(Q30>365,\"THE B/E POINT IS IN NEXT YEAR\",\"\")","v":""}]
[{"$nulls":15},"Sales $",{"$f":"'Break-Even'!$D$10","v":{"v":2010000,"d":"$2,010,000"}},null,{"v":2391800,"d":"$2,391,800"},null,{"$f":"IF(Q30>365,\"BECAUSE PROFIT IS NEGATIVE.\",\"\")","v":""}]
[{"$nulls":15},"Fixed $",{"$f":"'Break-Even'!$D$40","v":{"v":317133,"d":"$317,133"}},null,{"v":317133,"d":"$317,133"},null,{"$f":"IF(S30>365,\"THE B/E POINT IS IN NEXT YEAR\",\"\")","v":""}]
[{"$nulls":15},"Total Variable $",{"$f":"'Break-Even'!$D$17","v":{"v":1065000,"d":"$1,065,000"}},null,{"v":945000,"d":"$945,000"},null,{"$f":"IF(S30>365,\"BECAUSE PROFIT IS NEGATIVE.\",\"\")","v":""}]
[{"$nulls":15},"Total Variable %",{"$f":"Q25/Q23","v":{"v":0.5298507462686567,"d":"53%"}},null,{"$f":"S25/S23","v":{"v":0.3950999247428715,"d":"40%"}}]
[{"$nulls":15},"Operating Profit $",{"$f":"Q23-(Q24+Q25)","v":{"v":627867,"d":"$627,867"}},null,{"$f":"S23-(S24+S25)","v":{"v":1129667,"d":"$1,129,667"}}]
[{"$nulls":15},"Break-Even %",{"$f":"(Q24/(Q24+Q27))","v":{"v":0.3355904761904762,"d":"34%"}},null,{"$f":"(S24/(S24+S27))","v":{"v":0.21919615703621786,"d":"22%"}}]
[{"$nulls":15},"BE Dollars",{"$f":"Q23*Q28","v":{"v":674536.8571428572,"d":"$674,537"}},null,{"$f":"S23*S28","v":{"v":524273.3683992259,"d":"$524,273"}}]
[{"$nulls":15},"BE Date",{"$f":"Q28*365","v":"1900-05-01T11:46:21.257"},null,{"$f":"S28*365","v":"1900-03-20T00:09:30.008"}]
{"$rows_empty":10}
[{"$nulls":3},"© Copyright, 2002, JaxWorks, All Rights Reserved"]

{"sheet":"BE Calculations","index":2,"n_rows":31,"n_cols":8,"rows_kept":31,"hidden":true}
[]
[]
[null,"MONTHS","REVENUE","FIXED\nCOSTS","VARIABLE\nCOSTS","TOTAL\nCOSTS","TOTAL\nPROFIT","X AXIS"]
[null,0,{"$f":"B4*'BE Analysis'!$Q$29","v":{"v":0,"d":"$0"}},{"$f":"'BE Analysis'!$Q$24","v":{"v":317133,"d":"$317,133"}},{"$f":"'BE Analysis'!$Q$24*B4","v":{"v":0,"d":"$0"}},{"$f":"E4+D4","v":{"v":317133,"d":"$317,133"}},{"$f":"C4-F4","v":{"v":-317133,"d":"-$317,133"}}]
[null,1,{"$f":"'BE Analysis'!Q23/$B$16","v":{"v":167500,"d":"$167,500"}},{"$f":"'BE Analysis'!$Q$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C5*'BE Analysis'!$Q$26","v":{"v":88750,"d":"$88,750"}},{"v":405883,"d":"$405,883"},{"v":-238383,"d":"-$238,383"},0]
[null,2,{"$f":"$C$5*B6","v":{"v":335000,"d":"$335,000"}},{"$f":"'BE Analysis'!$Q$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C6*'BE Analysis'!$Q$26","v":{"v":177500,"d":"$177,500"}},{"v":494633,"d":"$494,633"},{"v":-159633,"d":"-$159,633"},10]
[null,3,{"v":502500,"d":"$502,500"},{"$f":"'BE Analysis'!$Q$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C7*'BE Analysis'!$Q$26","v":{"v":266250,"d":"$266,250"}},{"v":583383,"d":"$583,383"},{"v":-80883,"d":"-$80,883"},20]
[null,4,{"v":670000,"d":"$670,000"},{"$f":"'BE Analysis'!$Q$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C8*'BE Analysis'!$Q$26","v":{"v":355000,"d":"$355,000"}},{"v":672133,"d":"$672,133"},{"v":-2133,"d":"-$2,133"},30]
[null,5,{"v":837500,"d":"$837,500"},{"$f":"'BE Analysis'!$Q$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C9*'BE Analysis'!$Q$26","v":{"v":443750,"d":"$443,750"}},{"v":760883,"d":"$760,883"},{"v":76617,"d":"$76,617"},40]
[null,6,{"v":1005000,"d":"$1,005,000"},{"$f":"'BE Analysis'!$Q$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C10*'BE Analysis'!$Q$26","v":{"v":532500,"d":"$532,500"}},{"v":849633,"d":"$849,633"},{"v":155367,"d":"$155,367"},50]
[null,7,{"v":1172500,"d":"$1,172,500"},{"$f":"'BE Analysis'!$Q$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C11*'BE Analysis'!$Q$26","v":{"v":621250,"d":"$621,250"}},{"v":938383,"d":"$938,383"},{"v":234117,"d":"$234,117"},60]
[null,8,{"v":1340000,"d":"$1,340,000"},{"$f":"'BE Analysis'!$Q$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C12*'BE Analysis'!$Q$26","v":{"v":710000,"d":"$710,000"}},{"v":1027133,"d":"$1,027,133"},{"v":312867,"d":"$312,867"},70]
[null,9,{"v":1507500,"d":"$1,507,500"},{"$f":"'BE Analysis'!$Q$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C13*'BE Analysis'!$Q$26","v":{"v":798750,"d":"$798,750"}},{"v":1115883,"d":"$1,115,883"},{"v":391617,"d":"$391,617"},80]
[null,10,{"v":1675000,"d":"$1,675,000"},{"$f":"'BE Analysis'!$Q$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C14*'BE Analysis'!$Q$26","v":{"v":887500,"d":"$887,500"}},{"v":1204633,"d":"$1,204,633"},{"v":470367,"d":"$470,367"},90]
[null,11,{"v":1842500,"d":"$1,842,500"},{"$f":"'BE Analysis'!$Q$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C15*'BE Analysis'!$Q$26","v":{"v":976250,"d":"$976,250"}},{"v":1293383,"d":"$1,293,383"},{"v":549117,"d":"$549,117"},100]
[null,12,{"v":2010000,"d":"$2,010,000"},{"$f":"'BE Analysis'!$Q$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C16*'BE Analysis'!$Q$26","v":{"v":1065000,"d":"$1,065,000"}},{"v":1382133,"d":"$1,382,133"},{"v":627867,"d":"$627,867"},110]
[]
[null,"MONTHS","REVENUE","FIXED\nCOSTS","VARIABLE\nCOSTS","TOTAL\nCOSTS","TOTAL\nPROFIT","X AXIS"]
[null,0,{"$f":"B19*'BE Analysis'!$S$29","v":{"v":0,"d":"$0"}},{"$f":"'BE Analysis'!$S$24","v":{"v":317133,"d":"$317,133"}},{"$f":"'BE Analysis'!$S$24*B19","v":{"v":0,"d":"$0"}},{"$f":"E19+D19","v":{"v":317133,"d":"$317,133"}},{"$f":"C19-F19","v":{"v":-317133,"d":"-$317,133"}}]
[null,1,{"$f":"'BE Analysis'!S23/$B$16","v":{"v":199316.66666666666,"d":"$199,317"}},{"$f":"'BE Analysis'!$S$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C20*'BE Analysis'!$S$26","v":{"v":78750,"d":"$78,750"}},{"v":395883,"d":"$395,883"},{"v":-196566.33333333334,"d":"-$196,566"},0]
[null,2,{"$f":"$C$20*B21","v":{"v":398633.3333333333,"d":"$398,633"}},{"$f":"'BE Analysis'!$S$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C21*'BE Analysis'!$S$26","v":{"v":157500,"d":"$157,500"}},{"v":474633,"d":"$474,633"},{"v":-75999.66666666669,"d":"-$76,000"},10]
[null,3,{"v":597950,"d":"$597,950"},{"$f":"'BE Analysis'!$S$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C22*'BE Analysis'!$S$26","v":{"v":236250,"d":"$236,250"}},{"v":553383,"d":"$553,383"},{"v":44567,"d":"$44,567"},20]
[null,4,{"v":797266.6666666666,"d":"$797,267"},{"$f":"'BE Analysis'!$S$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C23*'BE Analysis'!$S$26","v":{"v":315000,"d":"$315,000"}},{"v":632133,"d":"$632,133"},{"v":165133.66666666663,"d":"$165,134"},30]
[null,5,{"v":996583.3333333333,"d":"$996,583"},{"$f":"'BE Analysis'!$S$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C24*'BE Analysis'!$S$26","v":{"v":393749.99999999994,"d":"$393,750"}},{"v":710883,"d":"$710,883"},{"v":285700.33333333326,"d":"$285,700"},40]
[null,6,{"v":1195900,"d":"$1,195,900"},{"$f":"'BE Analysis'!$S$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C25*'BE Analysis'!$S$26","v":{"v":472500,"d":"$472,500"}},{"v":789633,"d":"$789,633"},{"v":406267,"d":"$406,267"},50]
[null,7,{"v":1395216.6666666665,"d":"$1,395,217"},{"$f":"'BE Analysis'!$S$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C26*'BE Analysis'!$S$26","v":{"v":551249.9999999999,"d":"$551,250"}},{"v":868382.9999999999,"d":"$868,383"},{"v":526833.6666666666,"d":"$526,834"},60]
[null,8,{"v":1594533.3333333333,"d":"$1,594,533"},{"$f":"'BE Analysis'!$S$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C27*'BE Analysis'!$S$26","v":{"v":630000,"d":"$630,000"}},{"v":947133,"d":"$947,133"},{"v":647400.3333333333,"d":"$647,400"},70]
[null,9,{"v":1793850,"d":"$1,793,850"},{"$f":"'BE Analysis'!$S$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C28*'BE Analysis'!$S$26","v":{"v":708750,"d":"$708,750"}},{"v":1025883,"d":"$1,025,883"},{"v":767967,"d":"$767,967"},80]
[null,10,{"v":1993166.6666666665,"d":"$1,993,167"},{"$f":"'BE Analysis'!$S$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C29*'BE Analysis'!$S$26","v":{"v":787499.9999999999,"d":"$787,500"}},{"v":1104633,"d":"$1,104,633"},{"v":888533.6666666665,"d":"$888,534"},90]
[null,11,{"v":2192483.333333333,"d":"$2,192,483"},{"$f":"'BE Analysis'!$S$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C30*'BE Analysis'!$S$26","v":{"v":866249.9999999999,"d":"$866,250"}},{"v":1183383,"d":"$1,183,383"},{"v":1009100.333333333,"d":"$1,009,100"},100]
[null,12,{"v":2391800,"d":"$2,391,800"},{"$f":"'BE Analysis'!$S$24","v":{"v":317133,"d":"$317,133"}},{"$f":"C31*'BE Analysis'!$S$26","v":{"v":945000,"d":"$945,000"}},{"v":1262133,"d":"$1,262,133"},{"v":1129667,"d":"$1,129,667"},110]