{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Income Statement Template"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Income Statement Template","index":0,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2],[44,1,45,3]]}
[null,"INCOME STATEMENT TEMPLATE"]
[null,"COMPANY",null,"YEARS ENDING"]
[]
[null,"MANAGER","COMPLETED BY","DATE OF LAST UPDATE"]
[]
[]
[null,"REVENUE",2015,2014]
[null,"Sales Revenue",150000,175000]
[null,"(Less Sales Returns and Allowances)",0,0]
[null,"Service Revenue",50500,75000]
[null,"Interest Revenue",0,0]
[null,"Other Revenue",0,0]
[null,"TOTAL REVENUE",{"$f":"SUM(C8:C12)","v":200500},{"$f":"SUM(D8:D12)","v":250000}]
[]
[null,"EXPENSES",2015,2014]
[null,"Advertising",500,450]
[null,"Bad Debt",0,0]
[null,"Commissions",0,0]
[null,"Cost of Goods Sold",55000,75000]
[null,"Depreciation",0,0]
[null,"Employee Benefits",0,0]
[null,"Furniture and Equipment",0,0]
[null,"Insurance",0,0]
[null,"Interest Expense",2000,2500]
[null,"Maintenance and Repairs",0,0]
[null,"Office Supplies",0,0]
[null,"Payroll Taxes",0,0]
[null,"Rent",0,0]
[null,"Research and Development",0,0]
[null,"Salaries and Wages",65000,85000]
[null,"Software",0,0]
[null,"Travel",0,0]
[null,"Utilities",0,0]
[null,"Web Hosting and Domains",0,0]
[null,"Other",0,0]
[null,"TOTAL EXPENSES",{"$f":"SUM(C16:C35)","v":122500},{"$f":"SUM(D16:D35)","v":162950}]
[]
[null,"Net Income before Taxes",{"$f":"C13-C36","v":78000},{"$f":"D13-D36","v":87050}]
[null,"Income Tax Expense",{"$f":"C38*0.2","v":15600},{"$f":"D38*0.2","v":17410}]
[]
[null,"INCOME FROM CONTINUING OPERATIONS",{"$f":"C38-C39","v":62400},{"$f":"D38-D39","v":69640}]
[]
[null,"NET INCOME",{"$f":"C41","v":62400},{"$f":"D41","v":69640}]
[]
[null,"CLICK HERE TO CREATE INCOME STATEMENT TEMPLATES IN SMARTSHEET"]