{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Guidelines","Explanation","Projected Cash Flow","Actual Cash Flow"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Guidelines","index":0,"n_rows":2,"n_cols":2,"rows_kept":2}
[]
[null,"GUIDELINES"]

{"sheet":"Explanation","index":1,"n_rows":51,"n_cols":3,"rows_kept":51,"merged":[[1,1,1,2]]}
[]
[null,"EXPLANATION OF DATA"]
[]
[null,"1. Cash On Hand"]
[null,"[Beginning of month]","Cash on hand, Cash Position Previous Month"]
[null,"2. Cash Receipts"]
[null,"(a) Cash Sales","All cash sales.  Credit sales only if cash is actually received."]
[null,"(b) Collections from Credit Accounts","Amount to be expected from all credit accounts."]
[null,"(c) Loan or Other Cash Injection","Indicate here all cash injections not shown in 2(a) or 2(b) above."]
[null,"3. Total Cash Receipts"]
[null,"[2a + 2b + 2c=3]","Self-explanatory"]
[null,"4. Total Cash Available"]
[null,"[Before cash out] (1 + 3)","Self-explanatory"]
[null,"5. Cash Paid Out","Real Estate Only"]
[null,"(a) Rent","Merchandise for resale or for use in product"]
[null,"(b) Gross Wages (excludes withdrawals)","Base pay plus overtime"]
[null,"(c) Payroll Expenses (Taxes, etc.)","Paid vacations, paid sick leave, health insurance, unemployment insurance, other benefits"]
[null,"(d) Utilities","Water, Heat, Light, Power"]
[null,"(e) Supplies (Office and operating)","Items purchased for use in the business [not for resale]"]
[null,"(f) Repairs and Maintenance","Include periodic large expenditures such as painting, decorating, repair of broken equipment"]
[null,"(g) Advertising","This amount should be adequate to maintain sales volume – include telephone book yellow page cost"]
[null,"(h) Auto, Delivery, and Travel","If personal vehicle is used, charge in this column – include parking"]
[null,"(i) Accounting and Legal","Outside services, including, for example, bookkeeping and tax return preparation"]
[null,"(j) Purchases (Merchandise)","Merchandise for resale or for use in product"]
[null,"(k) Telephone","Self-explanatory"]
[null,"(l) Outside Services","This could include outside labor and/or materials for specialized overflow work, including subcontracting"]
[null,"(m) Insurance","Coverages on business property and products, e.g., fire, liability; also workers' compensation, fidelity, etc. Exclude \"executive life [include in \"5w\"]"]
[null,"(n) Taxes (Real Estate, etc.)","Plus inventory tax – sales tax – excise tax, if applicable"]
[null,"(o) Interest","Remember to add interest on loan as it is injected [See 2(c) above]"]
[null,"(p) Other Expenses [Specify each]","Unexpected expenditures may be included here as a safety factor"]
[null,null,"Equipment expenses during the month should be included here [Non-capital equipment]"]
[null,null,"When equipment is rented or leased, record payments here"]
[null,"(q) Miscellaneous [Unspecified]","Small expenditures for which separate accounts would not be practical"]
[null,"(r) Subtotal","This subtotal indicates cash out for operating costs"]
[null,"(s) Loan Principal Payment","Include payment on all loans, including vehicle and equipment purchases on time payment"]
[null,"(t) Capital Purchases [Specify]","Non-expensed [depreciable] expenditures such as equipment, building, vehicle purchases, and leasehold improvements"]
[null,"(u) Other Start-up Costs","Expenses incurred prior to first month projection and paid after the \"start-up\" position"]
[null,"(v) Reserve and/or Escrow [Specify]","Example:  insurance, tax, or equipment escrow to reduce impact of large periodic payments"]
[null,"(w) Owner's Withdrawal","Should include payment for such things as owner's income tax, social security, health insurance, \"executive\" life insurance premiums, etc."]
[null,"6. Total Cash Paid Out"]
[null,"[Total 5a thru 5w]","Self-explanatory"]
[null,"7. Cash Position"]
[null,"[End of month]  (4 minus 6)","Enter this amount in (1) Cash on Hand following month – See \"A\" of \"Analysis\""]
[null,"Essential Operating Data","This is basic information necessary for proper planning and for proper cash flow projection.  In conjunction with this data, the cash flow can be evolved and shown in the above form."]
[null,"[Non-cash flow information]"]
[null,"A. Sales Volume [Dollars]","This is a very important figure and should be estimated carefully, taking into account size of facility and employee output as well as realistic anticipated sales [Actual sales performed – not orders received]"]
[null,"B. Accounts Receivable [End of Month]","Previous unpaid credit sales plus current month's credit sales, less amounts received current month [deduct \"C\" below]"]
[null,"C. Bad Debt [End of Month]","Bad debts should be subtracted from (B) in the month anticipated"]
[null,"D. Inventory on Hand [End of Month]","Last month's inventory plus merchandise received and/or manufactured current month minus amount sold current month"]
[null,"E. Accounts Payable [End of Month]","Previous month's payable plus current month's payable minus amount paid during month"]
[null,"F. Depreciation","Established by your accountant, or value of all your equipment divided by useful life [in months] as allowed by Internal Revenue Service"]

{"sheet":"Projected Cash Flow","index":2,"n_rows":60,"n_cols":16,"rows_kept":60,"merged":[[1,1,1,15]]}
[]
[null,"2013 PROJECTED MONTHLY CASH FLOW"]
[null,"COMPANY NAME"]
[null,"2013-03-23"]
[null,null,"PRE-STARTUP","MONTH 1","MONTH 2","MONTH 3","MONTH 4","MONTH 5","MONTH 6","MONTH 7","MONTH 8","MONTH 9","MONTH 10","MONTH 11","MONTH 12","TOTAL"]
[null,"1. Cash On Hand"]
[null,"[Beginning of month]",null,{"$f":"C45","v":{"v":0,"d":"$0.00"}},{"$f":"D45","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"2. Cash Receipts"]
[null,"(a) Cash Sales",{"$nulls":13},{"$f":"SUM('Projected Cash Flow'!$C9:$O9)","v":{"v":0,"d":"$0.00"}}]
[null,"(b) Collections from Credit Accounts",{"$nulls":13},{"$f":"SUM('Projected Cash Flow'!$C10:$O10)","v":{"v":0,"d":"$0.00"}}]
[null,"(c) Loan or Other Cash Injection",{"$nulls":13},{"$f":"SUM('Projected Cash Flow'!$C11:$O11)","v":{"v":0,"d":"$0.00"}}]
[null,"3. Total Cash Receipts"]
[null,"[2a + 2b + 2c=3]",{"$f":"SUM(C9:C11)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(D9:D11)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM('Projected Cash Flow'!$P$9:$P$11)","v":{"v":0,"d":"$0.00"}}]
[null,"4. Total Cash Available"]
[null,"[Before cash out] (1 + 3)",{"$f":"C7+C13","v":{"v":0,"d":"$0.00"}},{"$f":"D7+D13","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"5. Cash Paid Out"]
[null,"(a) Rent",{"$nulls":13},{"$f":"SUM(D17:O17)","v":{"v":0,"d":"$0.00"}}]
[null,"(b) Gross Wages (excludes withdrawals)",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(c) Payroll Expenses (Taxes, etc.)",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(d) Utilities",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(e) Supplies (Office and operating)",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(f) Repairs and Maintenance",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(g) Advertising",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(h) Auto, Delivery, and Travel",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(i) Accounting and Legal",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(j) Purchases (Merchandise)",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(k) Telephone",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(l) Outside Services",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(m) Insurance",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(n) Taxes (Real Estate, etc.)",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(o) Interest",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(p) Other Expenses [Specify each]",{"$nulls":13},{"v":0,"d":"$0.00"}]
[{"$nulls":15},{"v":0,"d":"$0.00"}]
[{"$nulls":15},{"v":0,"d":"$0.00"}]
[null,"(q) Miscellaneous [Unspecified]",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(r) Subtotal",{"$f":"SUM(C17:C35)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(D17:D35)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(SUM('Projected Cash Flow'!$P$17:$P$35)=SUM('Projected Cash Flow'!$D$36:$O$36),SUM('Projected Cash Flow'!$P$17:$P$35),\"Error\")","v":{"v":0,"d":"$0.00"}}]
[null,"(s) Loan Principal Payment",{"$nulls":13},{"$f":"SUM(D37:O37)","v":{"v":0,"d":"$0.00"}}]
[null,"(t) Capital Purchases [Specify]",{"$nulls":13},{"$f":"SUM(D38:O38)","v":{"v":0,"d":"$0.00"}}]
[null,"(u) Other Start-up Costs",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(v) Reserve and/or Escrow [Specify]",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(w) Owner's Withdrawal",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"6. Total Cash Paid Out",{"$nulls":13},{"$f":"SUM(D42:O42)","v":{"v":0,"d":"$0.00"}}]
[null,"[Total 5a thru 5w]",{"$f":"SUM(C36:C41)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(D36:D41)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(C43:O43)","v":{"v":0,"d":"$0.00"}}]
[null,"7. Cash Position"]
[null,"[End of month]  (4 minus 6)",{"$f":"C15-C43","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"Essential Operating Data"]
[null,"[Non-cash flow information]"]
[null,"A. Sales Volume [Dollars]",{"$nulls":13},{"$f":"SUM(D48:O48)","v":{"v":0,"d":"$0.00"}}]
[null,"B. Accounts Receivable [End of Month]"]
[null,"C. Bad Debt [End of Month]",{"$nulls":13},{"$f":"SUM(D50:O50)","v":{"v":0,"d":"$0.00"}}]
[null,"D. Inventory on Hand [End of Month]"]
[null,"E. Accounts Payable [End of Month]"]
[null,"F. Depreciation",{"$nulls":13},{"$f":"SUM(D53:O53)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[null,"Checking Calculation Verification"]
[null,"Check #1",{"$f":"+IF(D6+P13-P42=O43,\"Verified\",\"Error\")","v":"Verified"}]
[null,"Check #2",{"$f":"+IF(P45+C46-P9-P10-P47=O46,\"Verified\",\"Error\")","v":"Verified"}]
[null,"Check #3",{"$f":"+IF(P42=SUM(P37:P41),\"Verified\",\"Error\")","v":"Verified"}]
[null,"Check #4",{"$f":"+IF(SUM(D13:O13)=SUM(P9:P11),\"Verified\",\"Error\")","v":"Verified"}]

{"sheet":"Actual Cash Flow","index":3,"n_rows":60,"n_cols":16,"rows_kept":60,"merged":[[1,1,1,15]]}
[]
[null,"2013 ACTUAL MONTHLY CASH FLOW"]
[null,{"$f":"'Projected Cash Flow'!B3","v":"COMPANY NAME"}]
[null,{"$f":"'Projected Cash Flow'!B4","v":"2013-03-23"}]
[null,null,"PRE-STARTUP","MONTH 1","MONTH 2","MONTH 3","MONTH 4","MONTH 5","MONTH 6","MONTH 7","MONTH 8","MONTH 9","MONTH 10","MONTH 11","MONTH 12","TOTAL"]
[null,"1. Cash On Hand"]
[null,"[Beginning of month]",null,{"$f":"C45","v":{"v":0,"d":"$0.00"}},{"$f":"D45","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"2. Cash Receipts"]
[null,"(a) Cash Sales",{"$nulls":13},{"$f":"SUM('Actual Cash Flow'!$C9:$O9)","v":{"v":0,"d":"$0.00"}}]
[null,"(b) Collections from Credit Accounts",{"$nulls":13},{"$f":"SUM('Actual Cash Flow'!$C10:$O10)","v":{"v":0,"d":"$0.00"}}]
[null,"(c) Loan or Other Cash Injection",{"$nulls":13},{"$f":"SUM('Actual Cash Flow'!$C11:$O11)","v":{"v":0,"d":"$0.00"}}]
[null,"3. Total Cash Receipts"]
[null,"[2a + 2b + 2c=3]",{"$f":"SUM(C9:C11)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(D9:D11)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM('Actual Cash Flow'!$P$9:$P$11)","v":{"v":0,"d":"$0.00"}}]
[null,"4. Total Cash Available"]
[null,"[Before cash out] (1 + 3)",{"$f":"C7+C13","v":{"v":0,"d":"$0.00"}},{"$f":"D7+D13","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"5. Cash Paid Out"]
[null,"(a) Rent",{"$nulls":13},{"$f":"SUM(D17:O17)","v":{"v":0,"d":"$0.00"}}]
[null,"(b) Gross Wages (excludes withdrawals)",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(c) Payroll Expenses (Taxes, etc.)",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(d) Utilities",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(e) Supplies (Office and operating)",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(f) Repairs and Maintenance",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(g) Advertising",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(h) Auto, Delivery, and Travel",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(i) Accounting and Legal",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(j) Purchases (Merchandise)",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(k) Telephone",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(l) Outside Services",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(m) Insurance",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(n) Taxes (Real Estate, etc.)",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(o) Interest",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(p) Other Expenses [Specify each]",{"$nulls":13},{"v":0,"d":"$0.00"}]
[{"$nulls":15},{"v":0,"d":"$0.00"}]
[{"$nulls":15},{"v":0,"d":"$0.00"}]
[null,"(q) Miscellaneous [Unspecified]",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(r) Subtotal",{"$f":"SUM(C17:C35)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(D17:D35)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(SUM('Actual Cash Flow'!$P$17:$P$35)=SUM('Actual Cash Flow'!$D$36:$O$36),SUM('Actual Cash Flow'!$P$17:$P$35),\"Error\")","v":{"v":0,"d":"$0.00"}}]
[null,"(s) Loan Principal Payment",{"$nulls":13},{"$f":"SUM(D37:O37)","v":{"v":0,"d":"$0.00"}}]
[null,"(t) Capital Purchases [Specify]",{"$nulls":13},{"$f":"SUM(D38:O38)","v":{"v":0,"d":"$0.00"}}]
[null,"(u) Other Start-up Costs",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(v) Reserve and/or Escrow [Specify]",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"(w) Owner's Withdrawal",{"$nulls":13},{"v":0,"d":"$0.00"}]
[null,"6. Total Cash Paid Out",{"$nulls":13},{"$f":"SUM(D42:O42)","v":{"v":0,"d":"$0.00"}}]
[null,"[Total 5a thru 5w]",{"$f":"SUM(C36:C41)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(D36:D41)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(C43:O43)","v":{"v":0,"d":"$0.00"}}]
[null,"7. Cash Position"]
[null,"[End of month]  (4 minus 6)",{"$f":"C15-C43","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"Essential Operating Data"]
[null,"[Non-cash flow information]"]
[null,"A. Sales Volume [Dollars]",{"$nulls":13},{"$f":"SUM(D48:O48)","v":{"v":0,"d":"$0.00"}}]
[null,"B. Accounts Receivable [End of Month]"]
[null,"C. Bad Debt [End of Month]",{"$nulls":13},{"$f":"SUM(D50:O50)","v":{"v":0,"d":"$0.00"}}]
[null,"D. Inventory on Hand [End of Month]"]
[null,"E. Accounts Payable [End of Month]"]
[null,"F. Depreciation",{"$nulls":13},{"$f":"SUM(D53:O53)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[null,"Checking Calculation Verification"]
[null,"Check #1",{"$f":"+IF(D6+P13-P42=O43,\"Verified\",\"Error\")","v":"Verified"}]
[null,"Check #2",{"$f":"+IF(P45+C46-P9-P10-P47=O46,\"Verified\",\"Error\")","v":"Verified"}]
[null,"Check #3",{"$f":"+IF(P42=SUM(P37:P41),\"Verified\",\"Error\")","v":"Verified"}]
[null,"Check #4",{"$f":"+IF(SUM(D13:O13)=SUM(P9:P11),\"Verified\",\"Error\")","v":"Verified"}]