{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Comparative Business Income"],"not_rendered":{"defined_names":21,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Comparative Business Income","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"merged":[[5,1,5,7],[36,1,36,7]]}
[]
[]
[null,"Comparative Business Income "]
[null,"XYZ Corporation"]
["2000-02-02"]
[null,{"$f":"NOW()","v":"2010-04-19T20:16:59.750"}]
[]
[{"$nulls":3},"% of",null,"% of",null,"% of"]
[null,null,2007,"Income",{"$f":"IF(C9,C9+1,\"\")","v":2008},"Income",{"$f":"IF(SUM(E9),E9+1,\"\")","v":2009},"Income"]
[null,"Gross Income for the year",{"v":120000,"d":"$120,000"},{"v":1,"d":"100.0%"},{"v":135000,"d":"$135,000"},{"v":1,"d":"100.0%"},{"v":140000,"d":"$140,000"},{"$f":"IF(G10,G10/$G$10,\"\")","v":{"v":1,"d":"100.0%"}}]
[null,"Business Expenses"]
[null,"Cost of goods sold",{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$f":"IF(G12,G12/G12,\"\")","v":""}]
[null,"Advertising",{"v":5000,"d":"$5,000"},{"v":0.0416666666666667,"d":"4.2%"},{"v":7000,"d":"$7,000"},{"v":0.0518518518518519,"d":"5.2%"},{"v":9000,"d":"$9,000"},{"$f":"IF(G13,G13/$G$10,\"\")","v":{"v":0.06428571428571428,"d":"6.4%"}}]
[null,"Car and truck expenses",{"v":500,"d":"$500"},{"v":0.00416666666666667,"d":"0.4%"},{"v":500,"d":"$500"},{"v":0.0037037037037037,"d":"0.4%"},{"v":500,"d":"$500"},{"v":3.5714285714285713E-3,"d":"0.4%"}]
[null,"Fees",{"v":2000,"d":"$2,000"},{"v":0.0166666666666667,"d":"1.7%"},{"v":2000,"d":"$2,000"},{"v":0.0148148148148148,"d":"1.5%"},{"v":2000,"d":"$2,000"},{"v":0.014285714285714285,"d":"1.4%"}]
[null,"Depreciation",{"v":5000,"d":"$5,000"},{"v":0.0416666666666667,"d":"4.2%"},{"v":8000,"d":"$8,000"},{"v":0.0592592592592593,"d":"5.9%"},{"v":5000,"d":"$5,000"},{"v":0.03571428571428571,"d":"3.6%"}]
[null,"Employee benefit programs",{"$nulls":5},""]
[null,"Insurance (other than health)",{"v":2000,"d":"$2,000"},{"v":0.0166666666666667,"d":"1.7%"},{"v":2000,"d":"$2,000"},{"v":0.0148148148148148,"d":"1.5%"},{"v":2000,"d":"$2,000"},{"v":0.014285714285714285,"d":"1.4%"}]
[null,"Interest",{"$nulls":5},""]
[null,"Legal and professional",{"$nulls":5},""]
[null,"Office Expense",{"$nulls":5},""]
[null,"Wages",{"$nulls":5},""]
[null,"Pension and profit sharing",{"v":15000,"d":"$15,000"},{"v":0.125,"d":"12.5%"},{"v":16000,"d":"$16,000"},{"v":0.118518518518519,"d":"11.9%"},{"v":17000,"d":"$17,000"},{"v":0.12142857142857143,"d":"12.1%"}]
[null,"Rent",{"v":6000,"d":"$6,000"},{"v":0.05,"d":"5.0%"},{"v":7000,"d":"$7,000"},{"v":0.0518518518518519,"d":"5.2%"},{"v":8000,"d":"$8,000"},{"v":0.05714285714285714,"d":"5.7%"}]
[null,"Other leases",{"v":500,"d":"$500"},{"v":0.00416666666666667,"d":"0.4%"},{"v":500,"d":"$500"},{"v":0.0037037037037037,"d":"0.4%"},{"v":500,"d":"$500"},{"v":3.5714285714285713E-3,"d":"0.4%"}]
[null,"Repairs",{"$nulls":5},""]
[null,"Maintenance",{"$nulls":5},""]
[null,"Supplies",{"v":1000,"d":"$1,000"},{"v":0.00833333333333333,"d":"0.8%"},{"v":1000,"d":"$1,000"},{"v":0.00740740740740741,"d":"0.7%"},{"v":1000,"d":"$1,000"},{"v":0.007142857142857143,"d":"0.7%"}]
[null,"Taxes and licenses",{"$nulls":5},""]
[null,"Travel, meals, etc.",{"v":2000,"d":"$2,000"},{"v":0.0166666666666667,"d":"1.7%"},{"v":2000,"d":"$2,000"},{"v":0.0148148148148148,"d":"1.5%"},{"v":2000,"d":"$2,000"},{"v":0.014285714285714285,"d":"1.4%"}]
[null,"Utilities",{"v":2000,"d":"$2,000"},{"v":0.0166666666666667,"d":"1.7%"},{"v":2000,"d":"$2,000"},{"v":0.0148148148148148,"d":"1.5%"},{"v":2000,"d":"$2,000"},{"v":0.014285714285714285,"d":"1.4%"}]
[null,"Other",{"$nulls":5},""]
[null,"Total Expenses",{"$f":"IF(SUM(C12:C32),SUM(C12:C32),\"\")","v":{"v":41000,"d":"$41,000"}},{"$f":"IF(SUM(C10),C33/$C$10,\"\")","v":{"v":0.3416666666666667,"d":"34.2%"}},{"$f":"IF(SUM(E12:E32),SUM(E12:E32),\"\")","v":{"v":48000,"d":"$48,000"}},{"$f":"IF(E10,E33/$E$10,\"\")","v":{"v":0.35555555555555557,"d":"35.6%"}},{"$f":"IF(SUM(G12:G32),SUM(G12:G32),\"\")","v":{"v":49000,"d":"$49,000"}},{"$f":"IF(G10,G33/$G$10,\"\")","v":{"v":0.35,"d":"35.0%"}}]
[null,"Net Business Income (Loss)",{"$f":"IF(SUM(C10,C33),C10-C33,\"\")","v":{"v":79000,"d":"$79,000"}},{"$f":"IF(C10,C34/$C$10,\"\")","v":{"v":0.6583333333333333,"d":"65.8%"}},{"$f":"IF(SUM(E10,E33),E10-E33,\"\")","v":{"v":87000,"d":"$87,000"}},{"$f":"IF(E10,E34/$E$10,\"\")","v":{"v":0.6444444444444445,"d":"64.4%"}},{"$f":"IF(SUM(G10,G33),G10-G33,\"\")","v":{"v":91000,"d":"$91,000"}},{"$f":"IF(G10,G34/$G$10,\"\")","v":{"v":0.65,"d":"65.0%"}}]