{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Annual Operating Budget"],"read":"whole","date_system":"1900"}

{"sheet":"Annual Operating Budget","index":0,"n_rows":75,"n_cols":6,"rows_kept":75}
["<date>"]
[]
[]
[]
[null,null,"Annual Income Statement"]
["Headcount Summary","Q1","Q2","Q3","Q4","Annual Total"]
["Service operations",{"$nulls":4},{"$f":"Table1[[#This Row],[Column2]]+Table1[[#This Row],[Column3]]+Table1[[#This Row],[Column4]]+Table1[[#This Row],[Column5]]","v":0}]
["Sales and marketing",{"$nulls":4},{"$f":"Table1[[#This Row],[Column2]]+Table1[[#This Row],[Column3]]+Table1[[#This Row],[Column4]]+Table1[[#This Row],[Column5]]","v":0}]
["General and administrative",{"$nulls":4},{"$f":"Table1[[#This Row],[Column2]]+Table1[[#This Row],[Column3]]+Table1[[#This Row],[Column4]]+Table1[[#This Row],[Column5]]","v":0}]
["Total Headcount",{"$f":"B9+B8+B7","v":0},{"$f":"C9+C8+C7","v":0},0,0,{"$f":"F9+F8+F7","v":0}]
["Expenses","Q1","Q2","Q3","Q4","Annual Total"]
["Service operations",{"$nulls":4},{"$f":"SUM(Table13[[#This Row],[Column2]:[Column5]])","v":0}]
["Sales and marketing",{"$nulls":4},{"$f":"SUM(Table13[[#This Row],[Column2]:[Column5]])","v":0}]
["General and administrative",{"$nulls":4},{"$f":"SUM(Table13[[#This Row],[Column2]:[Column5]])","v":0}]
["Total Expenses",{"$f":"B12+B13+B14","v":0},{"$f":"C12+C13+C14","v":0},0,0,{"$f":"F14+F13+F12","v":0}]
["Income","Q1","Q2","Q3","Q4","Annual Total"]
["Operating profit",{"$f":"SUM(B14:B16)","v":0},{"$nulls":3},{"$f":"SUM(F14:F16)","v":0}]
["Other gains (losses)",0,{"$nulls":3},0]
["Other income",0,{"$nulls":3},0]
["Total Income",{"$f":"SUM(B17:B19)","v":0},{"$f":"SUM(C17:C19)","v":0},{"$f":"SUM(D17:D19)","v":0},{"$f":"SUM(E17:E19)","v":0},0]
["Taxes",{"$f":"B19-B20","v":0}]
["Net Income",0,{"$f":"C20-C21","v":0},{"$f":"D20-D21","v":0},{"$f":"E20-E21","v":0},{"$f":"F20-F21","v":0}]
[]
[]
[null,null,"Annual Balance Sheet"]
["Assets","Q1","Q2","Q3","Q4","Annual Total"]
["Cash",{"$nulls":4},{"$f":"SUM(Table16[[#This Row],[Column2]:[Column5]])","v":0}]
["Accounts receivable",{"$nulls":4},{"$f":"SUM(Table16[[#This Row],[Column2]:[Column5]])","v":0}]
["Other current assets",{"$nulls":4},{"$f":"SUM(Table16[[#This Row],[Column2]:[Column5]])","v":0}]
["Depreciable assets",{"$nulls":4},{"$f":"SUM(Table16[[#This Row],[Column2]:[Column5]])","v":0}]
["Accumulated depreciation",{"$nulls":4},{"$f":"SUM(Table137[[#This Row],[Column2]:[Column5]])","v":0}]
["Land",{"$nulls":4},{"$f":"SUM(Table137[[#This Row],[Column2]:[Column5]])","v":0}]
["Net property, plant and equipment",{"$nulls":4},{"$f":"SUM(Table137[[#This Row],[Column2]:[Column5]])","v":0}]
["Other assets",{"$nulls":4},{"$f":"SUM(Table137[[#This Row],[Column2]:[Column5]])","v":0}]
["Total Assets",{"$f":"SUM(B27:B34)","v":0},{"$f":"SUM(C27:C34)","v":0},{"$f":"SUM(D27:D34)","v":0},{"$f":"SUM(E27:E34)","v":0},{"$f":"SUM(F27:F34)","v":0}]
["Liabilities and equity","Q1","Q2","Q3","Q4","Annual Total"]
["Accounts Payable",{"$nulls":4},{"$f":"SUM(Table1348[[#This Row],[Column2]:[Column5]])","v":0}]
["Accrued liabilities",9,5,5,null,{"$f":"SUM(Table1348[[#This Row],[Column2]:[Column5]])","v":19}]
["Other current liabilities",{"$nulls":4},{"$f":"SUM(Table1348[[#This Row],[Column2]:[Column5]])","v":0}]
["Total current liabilities",9,{"$nulls":3},{"$f":"SUM(Table1348[[#This Row],[Column2]:[Column5]])","v":9}]
["Long-term debt",{"$nulls":4},{"$f":"SUM(Table1359[[#This Row],[Column2]:[Column5]])","v":0}]
["Notes payable",{"$nulls":4},{"$f":"SUM(Table1359[[#This Row],[Column2]:[Column5]])","v":0}]
["Other long-term liabilities",{"$nulls":4},{"$f":"SUM(Table1359[[#This Row],[Column2]:[Column5]])","v":0}]
["Total long-term liabilities",{"$nulls":4},{"$f":"SUM(Table1359[[#This Row],[Column2]:[Column5]])","v":0}]
["Total liabilities",{"$nulls":4},{"$f":"SUM(Table1359[[#This Row],[Column2]:[Column5]])","v":0}]
["Common stock",{"$nulls":4},{"$f":"SUM(Table1359[[#This Row],[Column2]:[Column5]])","v":0}]
["Retain earnings",7,{"$nulls":3},{"$f":"SUM(Table1359[[#This Row],[Column2]:[Column5]])","v":7}]
["Cumulative net income",{"$nulls":4},{"$f":"SUM(Table1359[[#This Row],[Column2]:[Column5]])","v":0}]
["Total Net Equity",{"$f":"SUM(B37:B48)","v":25},{"$f":"SUM(C37:C48)","v":5},{"$f":"SUM(D37:D48)","v":5},{"$f":"SUM(E37:E48)","v":0},{"$f":"SUM(F37:F48)","v":35}]
[]
[]
[null,null,"Annual Cash Flow Summary"]
["Sources of funds","Q1","Q2","Q3","Q4","Annual Total"]
["from operations",{"$nulls":4},{"$f":"SUM(Table110[[#This Row],[Column2]:[Column5]])","v":0}]
["add depreciation",{"$nulls":4},{"$f":"SUM(Table110[[#This Row],[Column2]:[Column5]])","v":0}]
["other sources of funds",{"$nulls":4},{"$f":"SUM(Table110[[#This Row],[Column2]:[Column5]])","v":0}]
["Total sources",{"$f":"SUM(B54:B56)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C54:C56)","v":0},{"$f":"SUM(D54:D56)","v":0},{"$f":"SUM(E54:E56)","v":0},0]
["Uses of funds","Q1","Q2","Q3","Q4","Annual Total"]
["Repurchase of stock",{"$nulls":4},{"$f":"SUM(Table1311[[#This Row],[Column2]:[Column5]])","v":0}]
["Debt retirement",{"$nulls":4},{"$f":"SUM(Table1311[[#This Row],[Column2]:[Column5]])","v":0}]
["Purchase of equipment and assets",{"$nulls":4},{"$f":"SUM(Table1311[[#This Row],[Column2]:[Column5]])","v":0}]
["Total Uses",{"$f":"SUM(B59:B61)","v":0},{"$f":"SUM(C59:C61)","v":0},{"$f":"SUM(D59:D61)","v":0},{"$f":"SUM(E59:E61)","v":0},{"$f":"SUM(F59:F61)","v":0}]
["Net change in cash"]
["Cumulative cash"]
["Beginning balance"]
["Ending balance"]
[]
[]
[]
["Summary Trend Data for Chart","Q1","Q2","Q3","Q4"]
["Quarterly revenue"]
["Quarterly margin"]
["Quarterly net income (loss)"]
["Quarterly cash flow"]
["Quarterly total assets"]