{"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":60,"n_cols":15,"rows_kept":60,"merged":[[0,0,0,14],[1,0,1,14]]}
["Small Business Cash Flow Projection"]
["[Company Name]"]
["Starting date","2018-01-01"]
["Cash balance alert minimum",null,{"$f":"Cash_minimum","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Beginning",{"$f":"Start_date","v":"2018-01-01"},{"$f":"DATE(YEAR(C6),MONTH(C6)+1,1)","v":"2018-02-01"},{"$f":"DATE(YEAR(D6),MONTH(D6)+1,1)","v":"2018-03-01"},"2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","Total"]
["Cash on hand (beginning of month)",null,{"$f":"B52","v":0},{"$f":"C52","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["CASH RECEIPTS"]
["Cash sales",{"$nulls":13},{"$f":"SUM(C10:N10)","v":0}]
["Returns and allowances",{"$nulls":13},0]
["Collections on accounts receivable",{"$nulls":13},0]
["Interest, other income",{"$nulls":13},0]
["Loan proceeds",{"$nulls":13},0]
["Owner contributions",{"$nulls":13},0]
["TOTAL CASH RECEIPTS",null,{"$f":"SUM(C10,C12:C15,(C11*-1))","v":0},{"$f":"SUM(D10,D12:D15,(D11*-1))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(O10:O15)","v":0}]
["Total cash available",{"$f":"(B7+B16)","v":0},{"$f":"(C7+C16)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["CASH PAID OUT"]
["Advertising",{"$nulls":13},{"$f":"SUM(C20:N20)","v":0}]
["Commissions and fees",{"$nulls":13},0]
["Contract labor",{"$nulls":13},0]
["Employee benefit programs",{"$nulls":13},0]
["Insurance (other than health)",{"$nulls":13},0]
["Interest expense",{"$nulls":13},0]
["Materials and supplies (in COGS)",{"$nulls":13},0]
["Meals and entertainment",{"$nulls":13},0]
["Mortgage interest",{"$nulls":13},0]
["Office expense",{"$nulls":13},0]
["Other interest expense",{"$nulls":13},0]
["Pension and profit-sharing plan",{"$nulls":13},0]
["Purchases for resale",{"$nulls":13},0]
["Rent or lease",{"$nulls":13},0]
["Rent or lease: vehicles, equipment",{"$nulls":13},0]
["Repairs and maintenance",{"$nulls":13},0]
["Supplies (not in COGS)",{"$nulls":13},0]
["Taxes and licenses",{"$nulls":13},0]
["Travel",{"$nulls":13},0]
["Utilities",{"$nulls":13},0]
["Wages (less emp. credits)",{"$nulls":13},0]
["Other expenses",{"$nulls":13},0]
["Other expenses",{"$nulls":13},0]
["Other expenses",{"$nulls":13},0]
["Miscellaneous",{"$nulls":13},0]
["SUBTOTAL",null,{"$f":"SUM(C20:C44)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Loan principal payment",{"$nulls":13},0]
["Capital purchases",{"$nulls":13},0]
["Other startup costs",{"$nulls":13},0]
["To reserve and/or escrow",{"$nulls":13},0]
["Owners' withdrawal",{"$nulls":13},0]
["TOTAL CASH PAID OUT",null,{"$f":"C45-SUM(C46:C50)","v":0},{"$f":"D45-SUM(D46:D50)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(O45:O50)","v":0}]
["Cash on hand (end of month)",{"$f":"(B17-B51)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
["OTHER OPERATING DATA"]
["Sales volume (dollars)"]
["Accounts receivable balance"]
["Bad debt balance"]
["Inventory on hand"]
["Accounts payable balance"]
["Depreciation"]

{"sheet":"Cash Flow Chart","index":1,"n_rows":37,"n_cols":4,"rows_kept":37}
{"$rows_empty":36}
[null,"Cash balance alert minimum",null,{"$f":"[0]!Cash_minimum","v":0}]