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

{"sheet":"Income Statement","index":0,"n_rows":42,"n_cols":5,"rows_kept":42,"merged":[[0,1,0,2],[1,1,1,2],[2,3,2,4],[3,1,3,2],[9,1,9,2],[11,1,11,2],[32,1,32,2],[37,1,37,2],[39,1,39,2],[41,1,41,4]]}
[null,"INCOME STATEMENT"]
[null,"COMPANY NAME",null,"Years Ending:","2018 & 2019"]
[]
[null,"Revenue",null,2019,2018]
[null,null,"Sales Revenue",{"v":150000,"d":"$150,000"},{"v":175000,"d":"$175,000"}]
[null,null,"(Less Sales Returns and Allowances)"]
[null,null,"Service Revenue",{"v":50500,"d":"$50,500"},{"v":75000,"d":"$75,000"}]
[null,null,"Interest Revenue"]
[null,null,"Other Revenue"]
[null,"Total Revenues",null,{"$f":"SUM(D5:D9)","v":{"v":200500,"d":"$200,500"}},{"$f":"SUM(E5:E9)","v":{"v":250000,"d":"$250,000"}}]
[]
[null,"Expenses",null,{"$f":"D4","v":2019},{"$f":"E4","v":2018}]
[null,null,"Advertising",{"v":500,"d":"$500"},{"v":450,"d":"$450"}]
[null,null,"Bad Debt"]
[null,null,"Commissions"]
[null,null,"Cost of Goods Sold",{"v":55000,"d":"$55,000"},{"v":75000,"d":"$75,000"}]
[null,null,"Depreciation"]
[null,null,"Employee Benefits"]
[null,null,"Furniture and Equipment"]
[null,null,"Insurance"]
[null,null,"Interest Expense",{"v":2000,"d":"$2,000"},{"v":2500,"d":"$2,500"}]
[null,null,"Maintenance and Repairs"]
[null,null,"Office Supplies"]
[null,null,"Payroll Taxes"]
[null,null,"Rent"]
[null,null,"Research and Development"]
[null,null,"Salaries and Wages",{"v":65000,"d":"$65,000"},{"v":85000,"d":"$85,000"}]
[null,null,"Software"]
[null,null,"Travel"]
[null,null,"Utilities"]
[null,null,"Web Hosting and Domains"]
[null,null,"Other"]
[null,"Total Expenses",null,{"$f":"SUM(D13:D32)","v":{"v":122500,"d":"$122,500"}},{"$f":"SUM(E13:E32)","v":{"v":162950,"d":"$162,950"}}]
[]
[null,null,"Net Income Before Taxes",{"$f":"D10-D33","v":{"v":78000,"d":"$78,000"}},{"$f":"E10-E33","v":{"v":87050,"d":"$87,050"}}]
[null,null,"Income Tax Expense",{"$f":"D35*0.2","v":{"v":15600,"d":"$15,600"}},{"$f":"E35*0.2","v":{"v":17410,"d":"$17,410"}}]
[]
[null,"Income from Continuing Operations",null,{"$f":"D35-D36","v":{"v":62400,"d":"$62,400"}},{"$f":"E35-E36","v":{"v":69640,"d":"$69,640"}}]
[]
[null,"Net Income",null,{"$f":"D38","v":{"v":62400,"d":"$62,400"}},{"$f":"E38","v":{"v":69640,"d":"$69,640"}}]
[]
[null,"CLICK HERE TO CREATE INCOME STATEMENT TEMPLATES IN SMARTSHEET"]