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

{"sheet":"Cash Flow","index":0,"n_rows":61,"n_cols":16,"rows_kept":61,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"Small Business Cash Flow Projection"]
[]
[null,"Starting date",{"$f":"TODAY()","v":"2019-04-17"}]
[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-18","Feb-18","Mar-18","Apr-18","May-18","Jun-18","Jul-18","Aug-18","Sep-18","Oct-18","Nov-18","Dec-18","Total"]
[null,"Cash on hand (beginning of month)",null,{"$f":"C53","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"CASH RECEIPTS"," ","Jan-18","Feb-18","Mar-18","Apr-18","May-18","Jun-18","Jul-18","Aug-18","Sep-18","Oct-18","Nov-18","Dec-18","Total"]
[null,"Cash sales",{"$nulls":13},{"$f":"SUM(D10:O10)","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(D10,D12:D15,(D11*-1))","v":0},{"$f":"SUM(E10,E12:E15,(E11*-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":"(C7+CashReceipts[[#Totals],[ ]])","v":0},{"$f":"(D7+CashReceipts[[#Totals],[Jan-18]])","v":0},{"$f":"(E7+CashReceipts[[#Totals],[Feb-18]])","v":0},{"$f":"(F7+CashReceipts[[#Totals],[Mar-18]])","v":0},{"$f":"(G7+CashReceipts[[#Totals],[Apr-18]])","v":0},{"$f":"(H7+CashReceipts[[#Totals],[May-18]])","v":0},{"$f":"(I7+CashReceipts[[#Totals],[Jun-18]])","v":0},{"$f":"(J7+CashReceipts[[#Totals],[Jul-18]])","v":0},{"$f":"(K7+CashReceipts[[#Totals],[Aug-18]])","v":0},{"$f":"(L7+CashReceipts[[#Totals],[Sep-18]])","v":0},{"$f":"(M7+CashReceipts[[#Totals],[Oct-18]])","v":0},{"$f":"(N7+CashReceipts[[#Totals],[Nov-18]])","v":0},{"$f":"(O7+CashReceipts[[#Totals],[Dec-18]])","v":0}]
[]
[null,"CASH PAID OUT"," ","Jan-18","Feb-18","Mar-18","Apr-18","May-18","Jun-18","Jul-18","Aug-18","Sep-18","Oct-18","Nov-18","Dec-18","Total"]
[null,"Advertising",{"$nulls":13},{"$f":"SUM(D20:O20)","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-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[Feb-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[Mar-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[Apr-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[May-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[Jun-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[Jul-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[Aug-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[Sep-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[Oct-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[Nov-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[Dec-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[Total])","v":0}]
[null,"CASH PAID OUT"," ","Jan-18","Feb-18","Mar-18","Apr-18","May-18","Jun-18","Jul-18","Aug-18","Sep-18","Oct-18","Nov-18","Dec-18","Total"]
[null,"Loan principal payment",{"$nulls":13},{"$f":"SUM(D47:O47)","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-18]]+SUBTOTAL(109,CashPaidOut[Jan-18])","v":0},{"$f":"Expenses[[#Totals],[Feb-18]]+SUBTOTAL(109,CashPaidOut[Feb-18])","v":0},{"$f":"Expenses[[#Totals],[Mar-18]]+SUBTOTAL(109,CashPaidOut[Mar-18])","v":0},{"$f":"Expenses[[#Totals],[Apr-18]]+SUBTOTAL(109,CashPaidOut[Apr-18])","v":0},{"$f":"Expenses[[#Totals],[May-18]]+SUBTOTAL(109,CashPaidOut[May-18])","v":0},{"$f":"Expenses[[#Totals],[Jun-18]]+SUBTOTAL(109,CashPaidOut[Jun-18])","v":0},{"$f":"Expenses[[#Totals],[Jul-18]]+SUBTOTAL(109,CashPaidOut[Jul-18])","v":0},{"$f":"Expenses[[#Totals],[Aug-18]]+SUBTOTAL(109,CashPaidOut[Aug-18])","v":0},{"$f":"Expenses[[#Totals],[Sep-18]]+SUBTOTAL(109,CashPaidOut[Sep-18])","v":0},{"$f":"Expenses[[#Totals],[Oct-18]]+SUBTOTAL(109,CashPaidOut[Oct-18])","v":0},{"$f":"Expenses[[#Totals],[Nov-18]]+SUBTOTAL(109,CashPaidOut[Nov-18])","v":0},{"$f":"Expenses[[#Totals],[Dec-18]]+SUBTOTAL(109,CashPaidOut[Dec-18])","v":0},0]
[null,"Cash on hand (end of month)",{"$f":"C17","v":0},{"$f":"D17-CashPaidOut[[#Totals],[Jan-18]]","v":0},{"$f":"E17-CashPaidOut[[#Totals],[Feb-18]]","v":0},{"$f":"F17-CashPaidOut[[#Totals],[Mar-18]]","v":0},{"$f":"G17-CashPaidOut[[#Totals],[Apr-18]]","v":0},{"$f":"H17-CashPaidOut[[#Totals],[May-18]]","v":0},{"$f":"I17-CashPaidOut[[#Totals],[Jun-18]]","v":0},{"$f":"J17-CashPaidOut[[#Totals],[Jul-18]]","v":0},{"$f":"K17-CashPaidOut[[#Totals],[Aug-18]]","v":0},{"$f":"L17-CashPaidOut[[#Totals],[Sep-18]]","v":0},{"$f":"M17-CashPaidOut[[#Totals],[Oct-18]]","v":0},{"$f":"N17-CashPaidOut[[#Totals],[Nov-18]]","v":0},{"$f":"O17-CashPaidOut[[#Totals],[Dec-18]]","v":0}]
[]
[null,"OTHER OPERATING DATA"," ","Jan-18","Feb-18","Mar-18","Apr-18","May-18","Jun-18","Jul-18","Aug-18","Sep-18","Oct-18","Nov-18","Dec-18","Total"]
[null,"Sales volume (dollars)",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[Jan-18]:[Dec-18]])","v":0}]
[null,"Accounts receivable balance",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dec-18]])","v":0}]
[null,"Bad debt balance",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dec-18]])","v":0}]
[null,"Inventory on hand",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dec-18]])","v":0}]
[null,"Accounts payable balance",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dec-18]])","v":0}]
[null,"Depreciation",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[Jan-18]:[Dec-18]])","v":0}]

{"sheet":"Cash Flow Chart","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"merged":[[1,1,34,16],[36,1,36,2]]}
[]
[null,"Combination chart showing Cash on Hand Minimum Alert and Cash Flow Projection is in this cell."]
{"$rows_empty":34}
[null,"Cash balance alert minimum",null,{"$f":"[0]!Cash_minimum","v":{"v":0,"d":"$0"}}]