{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Weekly Cash Flow Projection"],"not_rendered":{"external_links":2,"defined_names":34,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Weekly Cash Flow Projection","index":0,"n_rows":42,"n_cols":8,"rows_kept":42,"merged":[[44,1,44,7]]}
[]
[]
[]
[null,"Weekly Cash Flow Projection"]
[null,"Your Company, Inc."]
[null,"For July, 2009"]
[]
[]
[null,"CASH RECEIVED","2009-06-26",{"$f":"C9+7","v":"2009-07-03"},{"$f":"D9+7","v":"2009-07-10"},{"$f":"E9+7","v":"2009-07-17"},{"$f":"IF(DAY(F9+7)<8,\"\",F9+7)","v":"2009-07-24"},{"$f":"IF(ISTEXT(G9),\"\",IF(DAY(G9+7)<8,\"\",G9+7))","v":"2009-07-31"}]
[null,"Beginning Cash Balance",{"v":24250,"d":"$24,250"},{"$f":"IF(SUM(C42),C42,\"\")","v":{"v":54500,"d":"$54,500"}},{"$f":"IF(SUM(D42),D42,\"\")","v":{"v":60666,"d":"$60,666"}},{"$f":"IF(SUM(E42),E42,\"\")","v":{"v":57394,"d":"$57,394"}},{"$f":"IF(SUM(F42),F42,\"\")","v":{"v":51943,"d":"$51,943"}},{"$f":"IF(SUM(G42),G42,\"\")","v":{"v":64464,"d":"$64,464"}}]
[null,"Cash Sales",{"v":33500,"d":"$33,500"},{"v":37500,"d":"$37,500"},{"v":32000,"d":"$32,000"},{"v":27500,"d":"$27,500"},{"v":36000,"d":"$36,000"},{"v":42200,"d":"$42,200"}]
[null,"Receivables Collected",{"v":49000,"d":"$49,000"},{"v":61540,"d":"$61,540"},{"v":61095,"d":"$61,095"},{"v":52502,"d":"$52,502"},{"v":63231,"d":"$63,231"},{"v":54285,"d":"$54,285"}]
[null,"Other Cash Received",{"$nulls":4},{"v":10000,"d":"$10,000"},{"v":18908,"d":"$18,908"}]
[null,"Total Cash Available  ",{"$f":"IF(COUNT(C11:C13),SUM(C10:C13),\"\")","v":{"v":106750,"d":"$106,750"}},{"v":153540,"d":"$153,540"},{"v":153761,"d":"$153,761"},{"v":137396,"d":"$137,396"},{"v":161174,"d":"$161,174"},{"v":179857,"d":"$179,857"}]
[]
[null,"CASH DISBURSED"]
[null,"Salaries and Wages",{"v":14750,"d":"$14,750"},{"v":14750,"d":"$14,750"},{"v":14750,"d":"$14,750"},{"v":15855,"d":"$15,855"},{"v":15855,"d":"$15,855"},{"v":15855,"d":"$15,855"}]
[null,"Lease/Mortgage",{"v":11750,"d":"$11,750"}]
[null,"Insurance",null,{"v":11085,"d":"$11,085"}]
[null,"Office Supplies",{"v":5500,"d":"$5,500"},{"v":3505,"d":"$3,505"},{"v":3505,"d":"$3,505"},{"v":4088,"d":"$4,088"},{"v":2970,"d":"$2,970"},{"v":4088,"d":"$4,088"}]
[null,"Utilities",{"$nulls":3},{"v":6693,"d":"$6,693"}]
[null,"Repairs and Maintenance",{"v":4500,"d":"$4,500"},{"v":4155,"d":"$4,155"},{"v":4155,"d":"$4,155"},{"v":5117,"d":"$5,117"},{"v":4546,"d":"$4,546"},{"v":5117,"d":"$5,117"}]
[null,"Operating Supplies",{"v":3000,"d":"$3,000"},{"v":3950,"d":"$3,950"},{"v":3950,"d":"$3,950"},{"v":2862,"d":"$2,862"},{"v":3765,"d":"$3,765"},{"v":2862,"d":"$2,862"}]
[null,"Professional Fees",null,null,{"v":1575,"d":"$1,575"}]
[null,"Commissions",{"v":13500,"d":"$13,500"},{"v":12850,"d":"$12,850"},{"v":12850,"d":"$12,850"},{"v":12543,"d":"$12,543"},{"v":15043,"d":"$15,043"},{"v":12543,"d":"$12,543"}]
[null,"Travel and Entertainment",{"v":3750,"d":"$3,750"},{"v":4580,"d":"$4,580"},{"v":4620,"d":"$4,620"},{"v":3080,"d":"$3,080"},{"v":3444,"d":"$3,444"},{"v":3080,"d":"$3,080"}]
[null,"Purchases",{"v":4250,"d":"$4,250"},{"v":4500,"d":"$4,500"},{"v":4290,"d":"$4,290"},{"v":4171,"d":"$4,171"},{"v":4697,"d":"$4,697"},{"v":4171,"d":"$4,171"}]
[null,"Advertising",{"v":2000,"d":"$2,000"},{"v":2850,"d":"$2,850"},{"v":2410,"d":"$2,410"},{"v":2009,"d":"$2,009"},{"v":2758,"d":"$2,758"},{"v":2009,"d":"$2,009"}]
[null,"Transportation",{"v":10000,"d":"$10,000"},{"v":9543,"d":"$9,543"},{"v":11432,"d":"$11,432"},{"v":13717,"d":"$13,717"},{"v":12453,"d":"$12,453"},{"v":13717,"d":"$13,717"}]
[null,"Purchase of Capital Assets",{"v":2000,"d":"$2,000"},{"v":1574,"d":"$1,574"},{"v":1512,"d":"$1,512"},{"v":3244,"d":"$3,244"},{"v":1200,"d":"$1,200"},{"v":2244,"d":"$2,244"}]
[null,"Loan Payment with Interest",null,{"v":8214,"d":"$8,214"}]
[null,"Dividends",{"$nulls":5},{"v":5500,"d":"$5,500"}]
[null,"Other Cash Disbursed",{"v":12250,"d":"$12,250"},{"v":11318,"d":"$11,318"},{"v":11318,"d":"$11,318"},{"v":12074,"d":"$12,074"},{"v":9979,"d":"$9,979"},{"v":12074,"d":"$12,074"}]
[null,"Total Disbursements  ",{"$f":"IF(COUNT(C17:C33),SUM(C17:C33),\"\")","v":{"v":87250,"d":"$87,250"}},{"v":92874,"d":"$92,874"},{"v":76367,"d":"$76,367"},{"v":85453,"d":"$85,453"},{"v":76710,"d":"$76,710"},{"v":83260,"d":"$83,260"}]
[]
[null,"CASH POSITION"]
[null,"Balance Before Financing",{"$f":"IF(COUNT(C11:C13),C14-C34,\"\")","v":19500},{"v":60666,"d":"60,666 "},{"v":77394,"d":"77,394 "},{"v":51943,"d":"51,943 "},{"v":84464,"d":"84,464 "},{"v":96597,"d":"96,597 "}]
[null,"Loan (Repayment)",{"$nulls":5},{"v":-50000,"d":"(50,000)"}]
[null,"Securities Sale (Purchase)",35000,null,{"v":-20000,"d":"($20,000)"},null,{"v":-20000,"d":"($20,000)"}]
[null,"Stock Issue (Repurchase)"]
[null,"Other Received (Disbursed)"]
[null,"End Of Month Balance  ",{"$f":"IF(COUNT(C11:C13),SUM(C37:C41),\"\")","v":{"v":54500,"d":"$54,500"}},{"v":60666,"d":"$60,666"},{"v":57394,"d":"$57,394"},{"v":51943,"d":"$51,943"},{"v":64464,"d":"$64,464"},{"v":46597,"d":"$46,597"}]