{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Sample Income Statement"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sample Income Statement","index":0,"n_rows":52,"n_cols":10,"rows_kept":52,"merged":[[1,1,4,2],[7,1,11,3],[50,2,50,3]],"flags":["formulas_cached_only"]}
[]
[null,{"$error":"#VALUE!"}]
[{"$nulls":4},"Income Statement Projection"]
[{"$nulls":4},"Year Ending December 31, ",null,"200_"]
[]
[]
[{"$nulls":9},"Ratios"]
[null,"Insert the projected revenue, cost of sales and the table will automatically calculate your gross margin. The table is also set up to automatically calculate your ratios expressed as a percentage of revenue.",{"$nulls":3},"Revenue",null,{"v":0,"d":"$0.00"},null,""]
[]
[{"$nulls":5},"Cost of Sales",null,{"v":0,"d":"$0.00"},null,""]
[]
[{"$nulls":5},"Gross Profit Margin",null,{"v":0,"d":"$0.00"},null,""]
[]
[null,"Expenses"]
[null,"Insert the expences appropriate for your business.  Include more rows if required."]
[]
[null,"Advertising",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null,"Accounting",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null,"Rental",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null,"Telephone",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null,"Employee Salaries",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null,"Owner's Salary",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null,"Insurance",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null,"Stationery",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null,"Repairs & Maintenance",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null," ",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null," ",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null," ",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null," ",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null," ",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null," ",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null," ",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null," ",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null," ",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null," ",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null," ",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[]
[{"$nulls":5},"Total Operating Expenses",null,{"v":0,"d":"$0.00"},null,""]
[]
[{"$nulls":5},"Earnings Before Interest, Taxes, Depreciation & Amortization (EBITDA)",null,{"v":0,"d":"$0.00"},null,""]
[]
[null,"Asset Depreciation or Capital Cost Allowance",null,"(ask your accountant to help calculate this figure)",{"$nulls":3},{"v":0,"d":"$0.00"},null,""]
[null,"Interest on Bank Loans",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[null,"Other Loans",{"$nulls":5},{"v":0,"d":"$0.00"},null,""]
[]
[{"$nulls":5},"Total interest & depreciation",null,{"v":0,"d":"$0.00"},null,""]
[]
[{"$nulls":5},"Total Expenses Including Interest, Depreciation & Amortization",null,{"v":0,"d":"$0.00"},null,""]
[]
[{"$nulls":5},"Earnings Before Tax",null,{"v":0,"d":"$0.00"},null,""]
[null,"Provincially adjusted income tax rate:",{"v":0.186,"d":"18.6%"},null,null,"Tax",null,{"v":0,"d":"$0.00"},null,""]
[{"$nulls":5},"Earnings After Tax",null,{"v":0,"d":"$0.00"},null,""]