{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Cash flow","Cash flow chart"],"not_rendered":{"charts":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Cash flow","index":0,"n_rows":62,"n_cols":16,"rows_kept":62,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"ADATUM CORPORATION"]
[null,"Small business cash flow projection"]
[]
[null,"Starting date",{"$f":"TODAY()","v":"2023-02-20"}]
[null,"Cash balance alert minimum",null,{"$f":"Cash_minimum","v":0},{"$f":"Cash_minimum","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Beginning","Jan-xx","Feb-xx","Mar-xx","Apr-xx","May-xx","Jun-xx","Jul-xx","Aug-xx","Sep-xx","Oct-xx","Nov-xx","Dec-xx","Total"]
[null,"Cash on hand (beginning of month)",null,{"$f":"C54","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"CASH RECEIPTS"," ","Jan-xx","Feb-xx","Mar-xx","Apr-xx","May-xx","Jun-xx","Jul-xx","Aug-xx","Sep-xx","Oct-xx","Nov-xx","Dec-xx","Total"]
[null,"Cash sales",{"$nulls":13},{"$f":"SUM(D11:O11)","v":0}]
[null,"Returns and allowances",{"$nulls":13},0]
[null,"Collections on accounts receivable",{"$nulls":13},0]
[null,"Interest, other income",{"$nulls":13},0]
[null,"Loan proceeds",{"$nulls":13},0]
[null,"Owner contributions",{"$nulls":13},0]
[null,"TOTAL CASH RECEIPTS",null,{"$f":"SUM(D11,D13:D16,(D12*-1))","v":0},{"$f":"SUM(E11,E13:E16,(E12*-1))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,CashReceipts[Total])","v":0}]
[null,"Total cash available",{"$f":"(C8+CashReceipts[[#Totals],[ ]])","v":0},{"$f":"(D8+CashReceipts[[#Totals],[Jan-xx]])","v":0},{"$f":"(E8+CashReceipts[[#Totals],[Feb-xx]])","v":0},{"$f":"(F8+CashReceipts[[#Totals],[Mar-xx]])","v":0},{"$f":"(G8+CashReceipts[[#Totals],[Apr-xx]])","v":0},{"$f":"(H8+CashReceipts[[#Totals],[May-xx]])","v":0},{"$f":"(I8+CashReceipts[[#Totals],[Jun-xx]])","v":0},{"$f":"(J8+CashReceipts[[#Totals],[Jul-xx]])","v":0},{"$f":"(K8+CashReceipts[[#Totals],[Aug-xx]])","v":0},{"$f":"(L8+CashReceipts[[#Totals],[Sep-xx]])","v":0},{"$f":"(M8+CashReceipts[[#Totals],[Oct-xx]])","v":0},{"$f":"(N8+CashReceipts[[#Totals],[Nov-xx]])","v":0},{"$f":"(O8+CashReceipts[[#Totals],[Dec-xx]])","v":0}]
[]
[null,"CASH PAID OUT"," ","Jan-xx","Feb-xx","Mar-xx","Apr-xx","May-xx","Jun-xx","Jul-xx","Aug-xx","Sep-xx","Oct-xx","Nov-xx","Dec-xx","Total"]
[null,"Advertising",{"$nulls":13},{"$f":"SUM(D21:O21)","v":0}]
[null,"Commissions and fees",{"$nulls":13},0]
[null,"Contract labor",{"$nulls":13},0]
[null,"Employee benefit programs",{"$nulls":13},0]
[null,"Insurance (other than health)",{"$nulls":13},0]
[null,"Interest expense",{"$nulls":13},0]
[null,"Materials and supplies (in COGS)",{"$nulls":13},0]
[null,"Meals and entertainment",{"$nulls":13},0]
[null,"Mortgage interest",{"$nulls":13},0]
[null,"Office expense",{"$nulls":13},0]
[null,"Other interest expense",{"$nulls":13},0]
[null,"Pension and profit-sharing plan",{"$nulls":13},0]
[null,"Purchases for resale",{"$nulls":13},0]
[null,"Rent or lease",{"$nulls":13},0]
[null,"Rent or lease: vehicles, equipment",{"$nulls":13},0]
[null,"Repairs and maintenance",{"$nulls":13},0]
[null,"Supplies (not in COGS)",{"$nulls":13},0]
[null,"Taxes and licenses",{"$nulls":13},0]
[null,"Travel",{"$nulls":13},0]
[null,"Utilities",{"$nulls":13},0]
[null,"Wages (less emp. credits)",{"$nulls":13},0]
[null,"Other expenses",{"$nulls":13},0]
[null,"Other expenses",{"$nulls":13},0]
[null,"Other expenses",{"$nulls":13},0]
[null,"Miscellaneous",{"$nulls":13},0]
[null,"SUBTOTAL",null,{"$f":"SUBTOTAL(109,Expenses[Jan-xx])","v":0},{"$f":"SUBTOTAL(109,Expenses[Feb-xx])","v":0},{"$f":"SUBTOTAL(109,Expenses[Mar-xx])","v":0},{"$f":"SUBTOTAL(109,Expenses[Apr-xx])","v":0},{"$f":"SUBTOTAL(109,Expenses[May-xx])","v":0},{"$f":"SUBTOTAL(109,Expenses[Jun-xx])","v":0},{"$f":"SUBTOTAL(109,Expenses[Jul-xx])","v":0},{"$f":"SUBTOTAL(109,Expenses[Aug-xx])","v":0},{"$f":"SUBTOTAL(109,Expenses[Sep-xx])","v":0},{"$f":"SUBTOTAL(109,Expenses[Oct-xx])","v":0},{"$f":"SUBTOTAL(109,Expenses[Nov-xx])","v":0},{"$f":"SUBTOTAL(109,Expenses[Dec-xx])","v":0},{"$f":"SUBTOTAL(109,Expenses[Total])","v":0}]
[null,"CASH PAID OUT"," ","Jan-xx","Feb-xx","Mar-xx","Apr-xx","May-xx","Jun-xx","Jul-xx","Aug-xx","Sep-xx","Oct-xx","Nov-xx","Dec-xx","Total"]
[null,"Loan principal payment",{"$nulls":13},{"$f":"SUM(D48:O48)","v":0}]
[null,"Capital purchases",{"$nulls":13},0]
[null,"Other startup costs",{"$nulls":13},0]
[null,"To reserve and/or escrow",{"$nulls":13},0]
[null,"Owners' withdrawal",{"$nulls":13},0]
[null,"TOTAL CASH PAID OUT",null,{"$f":"Expenses[[#Totals],[Jan-xx]]+SUBTOTAL(109,CashPaidOut[Jan-xx])","v":0},{"$f":"Expenses[[#Totals],[Feb-xx]]+SUBTOTAL(109,CashPaidOut[Feb-xx])","v":0},{"$f":"Expenses[[#Totals],[Mar-xx]]+SUBTOTAL(109,CashPaidOut[Mar-xx])","v":0},{"$f":"Expenses[[#Totals],[Apr-xx]]+SUBTOTAL(109,CashPaidOut[Apr-xx])","v":0},{"$f":"Expenses[[#Totals],[May-xx]]+SUBTOTAL(109,CashPaidOut[May-xx])","v":0},{"$f":"Expenses[[#Totals],[Jun-xx]]+SUBTOTAL(109,CashPaidOut[Jun-xx])","v":0},{"$f":"Expenses[[#Totals],[Jul-xx]]+SUBTOTAL(109,CashPaidOut[Jul-xx])","v":0},{"$f":"Expenses[[#Totals],[Aug-xx]]+SUBTOTAL(109,CashPaidOut[Aug-xx])","v":0},{"$f":"Expenses[[#Totals],[Sep-xx]]+SUBTOTAL(109,CashPaidOut[Sep-xx])","v":0},{"$f":"Expenses[[#Totals],[Oct-xx]]+SUBTOTAL(109,CashPaidOut[Oct-xx])","v":0},{"$f":"Expenses[[#Totals],[Nov-xx]]+SUBTOTAL(109,CashPaidOut[Nov-xx])","v":0},{"$f":"Expenses[[#Totals],[Dec-xx]]+SUBTOTAL(109,CashPaidOut[Dec-xx])","v":0},0]
[null,"Cash on hand (end of month)",{"$f":"C18","v":0},{"$f":"D18-CashPaidOut[[#Totals],[Jan-xx]]","v":0},{"$f":"E18-CashPaidOut[[#Totals],[Feb-xx]]","v":0},{"$f":"F18-CashPaidOut[[#Totals],[Mar-xx]]","v":0},{"$f":"G18-CashPaidOut[[#Totals],[Apr-xx]]","v":0},{"$f":"H18-CashPaidOut[[#Totals],[May-xx]]","v":0},{"$f":"I18-CashPaidOut[[#Totals],[Jun-xx]]","v":0},{"$f":"J18-CashPaidOut[[#Totals],[Jul-xx]]","v":0},{"$f":"K18-CashPaidOut[[#Totals],[Aug-xx]]","v":0},{"$f":"L18-CashPaidOut[[#Totals],[Sep-xx]]","v":0},{"$f":"M18-CashPaidOut[[#Totals],[Oct-xx]]","v":0},{"$f":"N18-CashPaidOut[[#Totals],[Nov-xx]]","v":0},{"$f":"O18-CashPaidOut[[#Totals],[Dec-xx]]","v":0}]
[]
[null,"OTHER OPERATING DATA"," ","Jan-xx","Feb-xx","Mar-xx","Apr-xx","May-xx","Jun-xx","Jul-xx","Aug-xx","Sep-xx","Oct-xx","Nov-xx","Dec-xx","Total"]
[null,"Sales volume (dollars)",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[Jan-xx]:[Dec-xx]])","v":0}]
[null,"Accounts receivable balance",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dec-xx]])","v":0}]
[null,"Bad debt balance",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dec-xx]])","v":0}]
[null,"Inventory on hand",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dec-xx]])","v":0}]
[null,"Accounts payable balance",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dec-xx]])","v":0}]
[null,"Depreciation",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[Jan-xx]:[Dec-xx]])","v":0}]

{"sheet":"Cash flow chart","index":1,"n_rows":2,"n_cols":7,"rows_kept":2,"merged":[[1,1,1,5],[53,2,53,3]]}
[]
[null,"Cash balance alert minimum:",{"$nulls":4},{"$f":"[0]!Cash_minimum","v":{"v":0,"d":"$0"}}]