{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Profit and LOss Statement"],"read":"whole","date_system":"1900"}

{"sheet":"Profit and LOss Statement","index":0,"n_rows":41,"n_cols":6,"rows_kept":41,"merged":[[1,2,2,5],[3,2,3,5],[4,2,4,3],[4,4,4,5],[6,2,6,3],[12,2,12,3],[14,2,14,3],[35,2,35,3],[40,2,40,3]]}
[]
[null,null,"Company Name"]
[]
[null,null,"Profit and Loss Statement"]
[null,null,"Years Ending:"]
[]
[null,null,"Revenue",null,2016,2015]
[{"$nulls":3},"Sales revenue",{"v":150000,"d":"₹ 150,000"},{"v":175000,"d":"₹ 175,000"}]
[{"$nulls":3},"(Less sales returns and allowances)"]
[{"$nulls":3},"Service revenue",{"v":50500,"d":"₹ 50,500"},{"v":75000,"d":"₹ 75,000"}]
[{"$nulls":3},"Interest revenue"]
[{"$nulls":3},"Other revenue"]
[null,null,"Total Revenues",null,{"$f":"SUM(E8:E12)","v":{"v":200500,"d":"₹ 200,500"}},{"$f":"SUM(F8:F12)","v":{"v":250000,"d":"₹ 250,000"}}]
[]
[null,null,"Expenses",null,2016,2015]
[{"$nulls":3},"Advertising",{"v":500,"d":"₹ 500"},{"v":450,"d":"₹ 450"}]
[{"$nulls":3},"Bad debt"]
[{"$nulls":3},"Commissions"]
[{"$nulls":3},"Cost of goods sold",{"v":55000,"d":"₹ 55,000"},{"v":75000,"d":"₹ 75,000"}]
[{"$nulls":3},"Depreciation"]
[{"$nulls":3},"Employee benefits"]
[{"$nulls":3},"Furniture and equipment"]
[{"$nulls":3},"Insurance"]
[{"$nulls":3},"Interest expense",{"v":2000,"d":"₹ 2,000"},{"v":2500,"d":"₹ 2,500"}]
[{"$nulls":3},"Maintenance and repairs"]
[{"$nulls":3},"Office supplies"]
[{"$nulls":3},"Payroll taxes"]
[{"$nulls":3},"Rent"]
[{"$nulls":3},"Research and development"]
[{"$nulls":3},"Salaries and wages",{"v":65000,"d":"₹ 65,000"},{"v":85000,"d":"₹ 85,000"}]
[{"$nulls":3},"Software"]
[{"$nulls":3},"Travel"]
[{"$nulls":3},"Utilities"]
[{"$nulls":3},"Web hosting and domains"]
[{"$nulls":3},"Other"]
[null,null,"Total Expenses",null,{"$f":"SUM(E16:E35)","v":{"v":122500,"d":"₹ 122,500"}},{"$f":"SUM(F16:F35)","v":{"v":162950,"d":"₹ 162,950"}}]
[]
[{"$nulls":3},"Net Income Before Taxes",{"$f":"E13-E36","v":{"v":78000,"d":"₹ 78,000"}},{"$f":"F13-F36","v":{"v":87050,"d":"₹ 87,050"}}]
[{"$nulls":3},"Income tax expense",{"$f":"E38*10%","v":{"v":7800,"d":"₹ 7,800"}},{"$f":"F38*10%","v":{"v":8705,"d":"₹ 8,705"}}]
[]
[null,null,"Net Income",null,{"$f":"E38-E39","v":{"v":70200,"d":"₹ 70,200"}},{"$f":"F38-F39","v":{"v":78345,"d":"₹ 78,345"}}]