{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["CASH FLOW"],"not_rendered":{"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"CASH FLOW","index":0,"n_rows":63,"n_cols":16,"rows_kept":63}
[]
[null,"SMALL BUSINESS CASH FLOW PROJECTION"]
[null,"[COMPANY NAME]"]
[]
[null,"Starting date","2013-07-07"]
[null,"Cash balance alert minimum",{"v":20,"d":"$20.00"},{"$f":"$C$6","v":{"v":20,"d":"$20.00"}},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"}]
[]
[null,null,"Beginning",{"$f":"IFERROR(EOMONTH(StartDate,COLUMN(A1)-2)+1,\"\")","v":"2013-07-01"},"2013-08-01","2013-09-01","2013-10-01","2013-11-01","2013-12-01","2014-01-01","2014-02-01","2014-03-01","2014-04-01","2014-05-01","2014-06-01","Total"]
[null,"Cash on hand (beginning of month)",{"v":50,"d":"$50.00"},{"$f":"C55","v":{"v":50,"d":"$50.00"}},{"$f":"D55","v":{"v":34,"d":"$34.00"}},{"v":18,"d":"$18.00"},{"v":2,"d":"$2.00"},{"v":-14,"d":"-$14.00"},{"v":-30,"d":"-$30.00"},{"v":-46,"d":"-$46.00"},{"v":-62,"d":"-$62.00"},{"v":-78,"d":"-$78.00"},{"v":-94,"d":"-$94.00"},{"v":-110,"d":"-$110.00"},{"v":-126,"d":"-$126.00"}]
[null,"Cash on hand (end of month)",{"$f":"C55","v":{"v":50,"d":"$50.00"}},{"v":34,"d":"$34.00"},{"v":18,"d":"$18.00"},{"v":2,"d":"$2.00"},{"v":-14,"d":"-$14.00"},{"v":-30,"d":"-$30.00"},{"v":-46,"d":"-$46.00"},{"v":-62,"d":"-$62.00"},{"v":-78,"d":"-$78.00"},{"v":-94,"d":"-$94.00"},{"v":-110,"d":"-$110.00"},{"v":-126,"d":"-$126.00"},{"v":-142,"d":"-$142.00"}]
[]
[null,"CASH RECEIPTS","Beginning",1,2,3,4,5,6,7,8,9,10,11,12,"Total"]
[null,"Cash sales",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"$f":"SUM(C13:O13)","v":{"v":12,"d":"$12.00"}}]
[null,"Returns and allowances",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"$f":"SUM(C14:O14)","v":{"v":12,"d":"$12.00"}}]
[null,"Collections on accounts receivable",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Interest, other income",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Loan proceeds",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Owner contributions",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"TOTAL CASH RECEIPTS",null,{"$f":"SUM(D13,D15:D18,(D14*-1))","v":{"v":4,"d":"$4.00"}},{"$f":"SUM(E13,E15:E18,(E14*-1))","v":{"v":4,"d":"$4.00"}},{"v":4,"d":"$4.00"},{"v":4,"d":"$4.00"},{"v":4,"d":"$4.00"},{"v":4,"d":"$4.00"},{"v":4,"d":"$4.00"},{"v":4,"d":"$4.00"},{"v":4,"d":"$4.00"},{"v":4,"d":"$4.00"},{"v":4,"d":"$4.00"},{"v":4,"d":"$4.00"},{"$f":"SUM(P13:P18)","v":{"v":72,"d":"$72.00"}}]
[null,"Total cash available",{"$f":"(C9+C19)","v":{"v":50,"d":"$50.00"}},{"$f":"(D9+D19)","v":{"v":54,"d":"$54.00"}},{"v":38,"d":"$38.00"},{"v":22,"d":"$22.00"},{"v":6,"d":"$6.00"},{"v":-10,"d":"-$10.00"},{"v":-26,"d":"-$26.00"},{"v":-42,"d":"-$42.00"},{"v":-58,"d":"-$58.00"},{"v":-74,"d":"-$74.00"},{"v":-90,"d":"-$90.00"},{"v":-106,"d":"-$106.00"},{"v":-122,"d":"-$122.00"}]
[]
[null,"CASH PAID OUT","Beginning",1,2,3,4,5,6,7,8,9,10,11,12,"Total"]
[null,"Advertising",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"$f":"SUM(D23:O23)","v":{"v":12,"d":"$12.00"}}]
[null,"Commissions and fees",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Contract labor",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Employee benefit programs",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Insurance (other than health)",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Interest expense",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Materials and supplies (in COGS)",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Meals and entertainment",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Mortgage interest",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Office expense",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Other interest expense",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Pension and profit-sharing plan",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Purchases for resale",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Rent or lease",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Rent or lease: vehicles, equipment",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Repairs and maintenance",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Supplies (not in COGS)",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Taxes and licenses",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Travel",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Utilities",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Wages (less emp. credits)",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Other expenses",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Other expenses",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Other expenses",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Miscellaneous",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"SUBTOTAL",null,{"$f":"SUM(D23:D47)","v":{"v":25,"d":"$25.00"}},{"$f":"SUM(E23:E47)","v":{"v":25,"d":"$25.00"}},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":300,"d":"$300.00"}]
[null,"Loan principal payment",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Capital purchases",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Other startup costs",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"To reserve and/or escrow",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"Owners' withdrawal",null,{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":1,"d":"$1.00"},{"v":12,"d":"$12.00"}]
[null,"TOTAL CASH PAID OUT",null,{"$f":"D48-SUM(D49:D53)","v":{"v":20,"d":"$20.00"}},{"$f":"E48-SUM(E49:E53)","v":{"v":20,"d":"$20.00"}},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":240,"d":"$240.00"}]
[null,"Cash on hand (end of month)",{"$f":"C20-C54","v":{"v":50,"d":"$50.00"}},{"v":34,"d":"$34.00"},{"v":18,"d":"$18.00"},{"v":2,"d":"$2.00"},{"v":-14,"d":"-$14.00"},{"v":-30,"d":"-$30.00"},{"v":-46,"d":"-$46.00"},{"v":-62,"d":"-$62.00"},{"v":-78,"d":"-$78.00"},{"v":-94,"d":"-$94.00"},{"v":-110,"d":"-$110.00"},{"v":-126,"d":"-$126.00"},{"v":-142,"d":"-$142.00"}]
[]
[null,"OTHER OPERATING DATA","Beginning","1","2","3","4","5","6","7","8","9","10","11","12","Total"]
[null,"Sales volume (dollars)",{"$nulls":13},{"$f":"SUM(D58:O58)","v":{"v":0,"d":"$0.00"}}]
[null,"Accounts receivable balance",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"Bad debt balance",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"Inventory on hand",{"$nulls":13},0]
[null,"Accounts payable balance",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"Depreciation",{"$nulls":13},{"v":0,"d":"$0.00"}]