{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Pro-Forma Income Statement"],"not_rendered":{"defined_names":28,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Pro-Forma Income Statement","index":0,"n_rows":58,"n_cols":7,"rows_kept":58,"merged":[[60,1,60,6]]}
[]
[]
[null,"Pro-Forma Income Statement"]
[null,"XYZ, Inc."]
[null,"For 2006 through 2009"]
[null,"(all numbers in $000)"]
[]
[]
[null,"REVENUE",null,2006,{"$f":"D9+1","v":2007},{"$f":"E9+1","v":2008},{"$f":"F9+1","v":2009}]
[null,"Gross sales",null,{"v":500,"d":"$500"},{"v":650,"d":"$650"},{"v":720,"d":"$720"},{"v":850,"d":"$850"}]
[null,null,"Less sales returns and allowances",{"v":200,"d":"200 "},{"v":230,"d":"230 "},{"v":280,"d":"280 "},{"v":320,"d":"320 "}]
[null,"Net Sales",null,{"$f":"IF(OR(D10<>0,D11),D10-D11,\"\")","v":{"v":300,"d":"$300"}},{"$f":"IF(OR(E10<>0,E11),E10-E11,\"\")","v":{"v":420,"d":"$420"}},{"$f":"IF(OR(F10<>0,F11),F10-F11,\"\")","v":{"v":440,"d":"$440"}},{"$f":"IF(OR(G10<>0,G11),G10-G11,\"\")","v":{"v":530,"d":"$530"}}]
[]
[null,"COST OF SALES"]
[null,"Beginning inventory",null,{"v":350,"d":"$350"},{"$f":"IF(D18,D18,\"\")","v":{"v":360,"d":"$360"}},{"$f":"IF(E18,E18,\"\")","v":{"v":420,"d":"$420"}},{"$f":"IF(F18,F18,\"\")","v":{"v":435,"d":"$435"}}]
[null,null,"Plus goods purchased / manufactured",{"v":120,"d":"120 "},{"v":165,"d":"165 "},{"v":185,"d":"185 "},{"v":190,"d":"190 "}]
[null,"Total Goods Available",null,{"$f":"IF(OR(SUM(D15)<>0,D16),D15+D16,\"\")","v":{"v":470,"d":"$470"}},{"$f":"IF(OR(SUM(E15)<>0,E16),E15+E16,\"\")","v":{"v":525,"d":"$525"}},{"$f":"IF(OR(SUM(F15)<>0,F16),F15+F16,\"\")","v":{"v":605,"d":"$605"}},{"$f":"IF(OR(SUM(G15)<>0,G16),G15+G16,\"\")","v":{"v":625,"d":"$625"}}]
[null,null,"Less ending inventory",{"v":360,"d":"360 "},{"v":420,"d":"420 "},{"v":435,"d":"435 "},{"v":440,"d":"440 "}]
[null,"Total Cost of Goods Sold",null,{"$f":"IF(OR(SUM(D17)<>0,D18),D17-D18,\"\")","v":{"v":110,"d":"$110"}},{"$f":"IF(OR(SUM(E17)<>0,E18),E17-E18,\"\")","v":{"v":105,"d":"$105"}},{"$f":"IF(OR(SUM(F17)<>0,F18),F17-F18,\"\")","v":{"v":170,"d":"$170"}},{"$f":"IF(OR(SUM(G17)<>0,G18),G17-G18,\"\")","v":{"v":185,"d":"$185"}}]
[]
[null,"Gross Profit (Loss)",null,{"$f":"IF(OR(SUM(D12)<>0,SUM(D19)),SUM(D12)-SUM(D19),\"\")","v":{"v":190,"d":"$190"}},{"$f":"IF(OR(SUM(E12)<>0,SUM(E19)),SUM(E12)-SUM(E19),\"\")","v":{"v":315,"d":"$315"}},{"$f":"IF(OR(SUM(F12)<>0,SUM(F19)),SUM(F12)-SUM(F19),\"\")","v":{"v":270,"d":"$270"}},{"$f":"IF(OR(SUM(G12)<>0,SUM(G19)),SUM(G12)-SUM(G19),\"\")","v":{"v":345,"d":"$345"}}]
[]
[null,"OPERATING EXPENSES"]
[null,"Selling"]
[null,null,"Salaries and wages",{"v":35,"d":"$35"},{"v":41,"d":"$41"},{"v":46,"d":"$46"},{"v":52,"d":"$52"}]
[null,null,"Commissions",{"v":12,"d":"12 "},{"v":14,"d":"14 "},{"v":16,"d":"16 "},{"v":18,"d":"18 "}]
[null,null,"Advertising",{"v":10,"d":"10 "},{"v":12,"d":"12 "},{"v":14,"d":"14 "},{"v":20,"d":"20 "}]
[null,null,"Depreciation",{"v":14,"d":"14 "},{"v":15,"d":"15 "},{"v":16,"d":"16 "},{"v":16,"d":"16 "}]
[null,null,"Other",{"v":5,"d":"5 "},{"v":6,"d":"6 "},{"v":6,"d":"6 "},{"v":7,"d":"7 "}]
[null,"Total Selling Expenses",null,{"$f":"IF(SUM(D25:D29),SUM(D25:D29),\"\")","v":{"v":76,"d":"$76"}},{"$f":"IF(SUM(E25:E29),SUM(E25:E29),\"\")","v":{"v":88,"d":"$88"}},{"$f":"IF(SUM(F25:F29),SUM(F25:F29),\"\")","v":{"v":98,"d":"$98"}},{"$f":"IF(SUM(G25:G29),SUM(G25:G29),\"\")","v":{"v":113,"d":"$113"}}]
[]
[null,"General/Administrative"]
[null,null,"Salaries and wages",{"v":12,"d":"$12"},{"v":14,"d":"$14"},{"v":16,"d":"$16"},{"v":18,"d":"$18"}]
[null,null,"Employee benefits",{"v":4,"d":"4 "},{"v":5,"d":"5 "},{"v":5,"d":"5 "},{"v":6,"d":"6 "}]
[null,null,"Payroll taxes",{"v":2,"d":"2 "},{"v":3,"d":"3 "},{"v":3,"d":"3 "},{"v":4,"d":"4 "}]
[null,null,"Insurance",{"v":6,"d":"6 "},{"v":6,"d":"6 "},{"v":7,"d":"7 "},{"v":7,"d":"7 "}]
[null,null,"Rent",{"v":8,"d":"8 "},{"v":8,"d":"8 "},{"v":9,"d":"9 "},{"v":9,"d":"9 "}]
[null,null,"Utilities",{"v":2,"d":"2 "},{"v":2,"d":"2 "},{"v":2,"d":"2 "},{"v":3,"d":"3 "}]
[null,null,"Depreciation & amortization",{"v":3,"d":"3 "},{"v":4,"d":"4 "},{"v":4,"d":"4 "},{"v":5,"d":"5 "}]
[null,null,"Office supplies",{"v":1,"d":"1 "},{"v":1,"d":"1 "},{"v":1,"d":"1 "},{"v":1,"d":"1 "}]
[null,null,"Travel & entertainment",{"v":3,"d":"3 "},{"v":3,"d":"3 "},{"v":3,"d":"3 "},{"v":4,"d":"4 "}]
[null,null,"Postage",{"v":1,"d":"1 "},{"v":1,"d":"1 "},{"v":1,"d":"1 "},{"v":2,"d":"2 "}]
[null,null,"Equipment maintenance & rental",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":1,"d":"1 "},{"v":1,"d":"1 "}]
[null,null,"Interest",{"v":0,"d":"0 "},{"v":1,"d":"1 "},{"v":1,"d":"1 "},{"v":2,"d":"2 "}]
[null,null,"Furniture & equipment",{"v":3,"d":"3 "},{"v":4,"d":"4 "},{"v":4,"d":"4 "},{"v":5,"d":"5 "}]
[null,"Total General/Administrative Expenses",null,{"$f":"IF(SUM(D33:D45),SUM(D33:D45),\"\")","v":{"v":45,"d":"$45"}},{"$f":"IF(SUM(E33:E45),SUM(E33:E45),\"\")","v":{"v":52,"d":"$52"}},{"$f":"IF(SUM(F33:F45),SUM(F33:F45),\"\")","v":{"v":57,"d":"$57"}},{"$f":"IF(SUM(G33:G45),SUM(G33:G45),\"\")","v":{"v":67,"d":"$67"}}]
[]
[null,"Total Operating Expenses",null,{"$f":"IF(OR(SUM(D30)<>0,SUM(D46)),SUM(D30)+SUM(D46),\"\")","v":{"v":121,"d":"$121"}},{"$f":"IF(OR(SUM(E30)<>0,SUM(E46)),SUM(E30)+SUM(E46),\"\")","v":{"v":140,"d":"$140"}},{"$f":"IF(OR(SUM(F30)<>0,SUM(F46)),SUM(F30)+SUM(F46),\"\")","v":{"v":155,"d":"$155"}},{"$f":"IF(OR(SUM(G30)<>0,SUM(G46)),SUM(G30)+SUM(G46),\"\")","v":{"v":180,"d":"$180"}}]
[]
[]
[null,"Net Income Before Taxes",null,{"$f":"IF(OR(SUM(D21)<>0,D48),SUM(D21)-SUM(D48),\"\")","v":{"v":69,"d":"$69"}},{"$f":"IF(OR(SUM(E21)<>0,E48),SUM(E21)-SUM(E48),\"\")","v":{"v":175,"d":"$175"}},{"$f":"IF(OR(SUM(F21)<>0,F48),SUM(F21)-SUM(F48),\"\")","v":{"v":115,"d":"$115"}},{"$f":"IF(OR(SUM(G21)<>0,G48),SUM(G21)-SUM(G48),\"\")","v":{"v":165,"d":"$165"}}]
[null,null,"Taxes on income",{"v":22,"d":"22 "},{"v":32,"d":"32 "},{"v":26,"d":"26 "},{"v":28,"d":"28 "}]
[null,"Net Income After Taxes",null,{"$f":"IF(OR(SUM(D51)<>0,D52),D51-D52,\"\")","v":{"v":47,"d":"$47"}},{"$f":"IF(OR(SUM(E51)<>0,E52),E51-E52,\"\")","v":{"v":143,"d":"$143"}},{"$f":"IF(OR(SUM(F51)<>0,F52),F51-F52,\"\")","v":{"v":89,"d":"$89"}},{"$f":"IF(OR(SUM(G51)<>0,G52),G51-G52,\"\")","v":{"v":137,"d":"$137"}}]
[]
[null,"Extraordinary gain or loss",null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":43,"d":"$43"},{"v":0,"d":"$0"}]
[null,"Income tax on extraordinary gain",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":12,"d":"12 "},{"v":0,"d":"0 "}]
[]
[null,"NET INCOME (LOSS)",null,{"$f":"IF(OR(OR(SUM(D53)<>0,D55),D56),D53+D55-D56,\"\")","v":{"v":47,"d":"$47"}},{"$f":"IF(OR(OR(SUM(E53)<>0,E55),E56),E53+E55-E56,\"\")","v":{"v":143,"d":"$143"}},{"$f":"IF(OR(OR(SUM(F53)<>0,F55),F56),F53+F55-F56,\"\")","v":{"v":120,"d":"$120"}},{"$f":"IF(OR(OR(SUM(G53)<>0,G55),G56),G53+G55-G56,\"\")","v":{"v":137,"d":"$137"}}]