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

{"sheet":"Income Statement","index":0,"n_rows":52,"n_cols":8,"rows_kept":52,"merged":[[54,1,54,7]]}
[]
[]
[null,"Income Statement"]
[null,"Your Company, Inc."]
[null,"For Period Ending June 30, 2009"]
[null,"(all numbers in $000)"]
[]
[{"$nulls":3},"Current Month",null,null,"Year to Date"]
[{"$nulls":3},"Amount","% of Sales ",null,"Amount","% of Sales "]
[null,"REVENUE"]
[null,"Gross Sales",null,{"v":500,"d":"$500"},null,null,{"v":2500,"d":"$2,500"}]
[null,"    Less sales returns and allowances",null,{"v":200,"d":"200 "},null,null,{"v":500,"d":"500 "}]
[null,"Net Sales",null,{"$f":"IF(OR(D11<>0,D12),D11-D12,\"\")","v":{"v":300,"d":"$300"}},{"$f":"IF(SUM(D13)=0,\"\",D13/D13)","v":{"v":1,"d":"100%"}},null,{"$f":"IF(OR(G11<>0,G12),G11-G12,\"\")","v":{"v":2000,"d":"$2,000"}},{"$f":"IF(SUM(G13)=0,\"\",G13/G13)","v":{"v":1,"d":"100%"}}]
[]
[null,"COST OF SALES"]
[null,"Beginning inventory",null,{"v":350,"d":"$350"},{"$f":"IF(SUM($D$13)=0,\"\",D16/$D$13)","v":{"v":1.1666666666666667,"d":"117%"}},null,{"v":240,"d":"$240"},{"$f":"IF(SUM($G$13)=0,\"\",G16/$G$13)","v":{"v":0.12,"d":"12%"}}]
[null,"    Plus goods purchased / manufactured",null,{"v":120,"d":"120 "},{"v":0.4,"d":"40%"},null,{"v":900,"d":"900 "},{"v":0.45,"d":"45%"}]
[null,"Total Goods Available",null,{"$f":"IF(OR(D16<>0,D17),D16+D17,\"\")","v":{"v":470,"d":"$470"}},{"v":1.5666666666666667,"d":"157%"},null,{"$f":"IF(OR(G16<>0,G17),G16+G17,\"\")","v":{"v":1140,"d":"$1,140"}},{"v":0.57,"d":"57%"}]
[null,"    Less ending inventory",null,{"v":360,"d":"360 "},{"v":1.2,"d":"120%"},null,{"v":360,"d":"360 "},{"v":0.18,"d":"18%"}]
[null,"Total Cost of Goods Sold",null,{"$f":"IF(OR(SUM(D18)<>0,D19),D18-D19,\"\")","v":{"v":110,"d":"$110"}},{"v":0.36666666666666664,"d":"37%"},null,{"$f":"IF(OR(SUM(G18)<>0,G19),G18-G19,\"\")","v":{"v":780,"d":"$780"}},{"v":0.39,"d":"39%"}]
[null,"Gross Profit (Loss)",null,{"$f":"IF(OR(SUM(D13)<>0,D20),D13-D20,\"\")","v":{"v":190,"d":"$190"}},{"v":0.6333333333333333,"d":"63%"},null,{"$f":"IF(OR(SUM(G13)<>0,G20),G13-G20,\"\")","v":{"v":1220,"d":"$1,220"}},{"v":0.61,"d":"61%"}]
[]
[null,"OPERATING EXPENSES"]
[null,"Selling"]
[null,"    Salaries and wages",null,{"v":35,"d":"$35"},{"$f":"IF(SUM($D$13)=0,\"\",D25/$D$13)","v":{"v":0.11666666666666667,"d":"12%"}},null,{"v":130,"d":"$130"},{"$f":"IF(SUM($G$13)=0,\"\",G25/$G$13)","v":{"v":0.065,"d":"7%"}}]
[null,"    Commissions",null,{"v":12,"d":"12 "},{"v":0.04,"d":"4%"},null,{"v":80,"d":"80 "},{"v":0.04,"d":"4%"}]
[null,"    Advertising",null,{"v":10,"d":"10 "},{"v":0.03333333333333333,"d":"3%"},null,{"v":60,"d":"60 "},{"v":0.03,"d":"3%"}]
[null,"    Depreciation",null,{"v":14,"d":"14 "},{"v":0.04666666666666667,"d":"5%"},null,{"v":120,"d":"120 "},{"v":0.06,"d":"6%"}]
[null,"    Other",null,{"v":5,"d":"5 "},{"v":0.016666666666666666,"d":"2%"},null,{"v":30,"d":"30 "},{"v":0.015,"d":"2%"}]
[null,"Total Selling Expenses",null,{"$f":"IF(SUM(D25:D29),SUM(D25:D29),\"\")","v":{"v":76,"d":"$76"}},{"v":0.25333333333333335,"d":"25%"},null,{"$f":"IF(SUM(G25:G29),SUM(G25:G29),\"\")","v":{"v":420,"d":"$420"}},{"v":0.21,"d":"21%"}]
[null,"General/Administrative"]
[null,"    Salaries and wages",null,{"v":12,"d":"$12"},{"$f":"IF(SUM($D$13)=0,\"\",D32/$D$13)","v":{"v":0.04,"d":"4%"}},null,{"v":130,"d":"$130"},{"$f":"IF(SUM($G$13)=0,\"\",G32/$G$13)","v":{"v":0.065,"d":"7%"}}]
[null,"    Employee benefits",null,{"v":3,"d":"3 "},{"v":0.01,"d":"1%"},null,{"v":31,"d":"31 "},{"v":0.0155,"d":"2%"}]
[null,"    Payroll taxes",null,{"v":2,"d":"2 "},{"v":0.006666666666666667,"d":"1%"},null,{"v":23,"d":"23 "},{"v":0.0115,"d":"1%"}]
[null,"    Insurance",null,{"v":2,"d":"2 "},{"v":0.006666666666666667,"d":"1%"},null,{"v":1,"d":"1 "},{"v":0.0005,"d":"0%"}]
[null,"    Rent",null,{"v":12,"d":"12 "},{"v":0.04,"d":"4%"},null,{"v":23,"d":"23 "},{"v":0.0115,"d":"1%"}]
[null,"    Utilities",null,{"v":2,"d":"2 "},{"v":0.006666666666666667,"d":"1%"},null,{"v":30,"d":"30 "},{"v":0.015,"d":"2%"}]
[null,"    Depreciation & amortization",null,{"v":1,"d":"1 "},{"v":3.3333333333333335E-3,"d":"0%"},null,{"v":16,"d":"16 "},{"v":0.008,"d":"1%"}]
[null,"    Office supplies",null,{"v":1,"d":"1 "},{"v":3.3333333333333335E-3,"d":"0%"},null,{"v":8,"d":"8 "},{"v":0.004,"d":"0%"}]
[null,"    Travel & entertainment",null,{"v":2,"d":"2 "},{"v":0.006666666666666667,"d":"1%"},null,{"v":4,"d":"4 "},{"v":2E-3,"d":"0%"}]
[null,"    Postage",null,{"v":1,"d":"1 "},{"v":3.3333333333333335E-3,"d":"0%"},null,{"v":11,"d":"11 "},{"v":0.0055,"d":"1%"}]
[null,"    Equipment maintenance & rental",null,{"v":4,"d":"4 "},{"v":0.013333333333333334,"d":"1%"},null,{"v":49,"d":"49 "},{"v":0.0245,"d":"2%"}]
[null,"    Interest",null,{"v":2,"d":"2 "},{"v":0.006666666666666667,"d":"1%"},null,{"v":31,"d":"31 "},{"v":0.0155,"d":"2%"}]
[null,"    Furniture & equipment",null,{"v":1,"d":"1 "},{"v":3.3333333333333335E-3,"d":"0%"},null,{"v":10,"d":"10 "},{"v":0.005,"d":"1%"}]
[null,"Total General/Administrative Expenses",null,{"$f":"IF(SUM(D32:D44),SUM(D32:D44),\"\")","v":{"v":45,"d":"$45"}},{"v":0.15,"d":"15%"},null,{"$f":"IF(SUM(G32:G44),SUM(G32:G44),\"\")","v":{"v":367,"d":"$367"}},{"v":0.1835,"d":"18%"}]
[null,"Total Operating Expenses",null,{"$f":"IF(OR(SUM(D30)<>0,D45),D30+D45,\"\")","v":{"v":121,"d":"$121"}},{"v":0.4033333333333333,"d":"40%"},null,{"$f":"IF(OR(SUM(G30)<>0,G45),G30+G45,\"\")","v":{"v":787,"d":"$787"}},{"v":0.3935,"d":"39%"}]
[null,"Net Income Before Taxes",null,{"$f":"IF(OR(SUM(D21)<>0,D46),D21-D46,\"\")","v":{"v":69,"d":"$69"}},{"v":0.23,"d":"23%"},null,{"$f":"IF(OR(SUM(G21)<>0,G46),G21-G46,\"\")","v":{"v":433,"d":"$433"}},{"v":0.2165,"d":"22%"}]
[null,"    Taxes on income",null,{"v":22,"d":"22 "},{"v":0.07333333333333333,"d":"7%"},null,{"v":135,"d":"135 "},{"v":0.0675,"d":"7%"}]
[null,"Net Income After Taxes",null,{"$f":"IF(OR(SUM(D47)<>0,D48),D47-D48,\"\")","v":{"v":47,"d":"$47"}},{"v":0.15666666666666668,"d":"16%"},null,{"$f":"IF(OR(SUM(G47)<>0,G48),G47-G48,\"\")","v":{"v":298,"d":"$298"}},{"v":0.149,"d":"15%"}]
[null,"Extraordinary gain or loss",null,{"v":0,"d":"$0"},{"v":0,"d":"0%"},null,{"v":0,"d":"$0"},{"v":0,"d":"0%"}]
[null,"Income tax on extraordinary gain",null,{"v":0,"d":"0 "},{"v":0,"d":"0%"},null,{"v":0,"d":"0 "},{"v":0,"d":"0%"}]
[null,"NET INCOME (LOSS)",null,{"$f":"IF(OR(OR(SUM(D49)<>0,D50),D51),D49+D50-D51,\"\")","v":{"v":47,"d":"$47"}},{"v":0.15666666666666668,"d":"16%"},null,{"$f":"IF(OR(OR(SUM(G49)<>0,G50),G51),G49+G50-G51,\"\")","v":{"v":298,"d":"$298"}},{"v":0.149,"d":"15%"}]