{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Cash Flow Analysis Template"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cash Flow Analysis Template","index":0,"n_rows":80,"n_cols":5,"rows_kept":80,"cut":false,"hidden":false,"merged":[[79,1,79,4],[0,1,0,3],[9,1,9,4],[4,2,4,4],[63,1,63,4],[22,1,22,4],[32,1,32,4],[21,1,21,4]]}
[null,"CASH FLOW ANALYSIS TEMPLATE"]
[null,"COMPANY NAME","MANAGER NAME","COMPLETED BY","DATE COMPLETED"]
[]
[]
[null,"TIME PERIOD COVERED","CASH FLOW TYPE"]
[null,null,"PESSIMISTIC","EXPECTED","OPTIMISTIC"]
[]
[null,"BEGINNING BALANCE | CASH ON HAND",0,0,0]
[]
[null,"( + )  CASH RECEIPTS"]
[null,"CASH SALES",0,0,0]
[null,"CUSTOMER ACCOUNT COLLECTIONS",0,0,0]
[null,"LOAN / CASH INJECTION",0,0,0]
[null,"INTEREST INCOME",0,0,0]
[null,"TAX REFUND",0,0,0]
[null,"OTHER CASH RECEIPTS",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"TOTAL CASH RECEIPTS",{"$f":"SUM(C11:C19)","v":0},{"$f":"SUM(D11:D19)","v":0},{"$f":"SUM(E11:E19)","v":0}]
[]
[null,"( – )  CASH PAYMENTS"]
[null,"( – )  COST OF GOODS SOLD"]
[null,"DIRECT PRODUCT / SERVICE COSTS",0,0,0]
[null,"PAYROLL TAXES / BENEFITS - DIRECT",0,0,0]
[null,"SALARIES - DIRECT",0,0,0]
[null,"SUPPLIES",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"TOTAL COST OF GOODS SOLD",{"$f":"SUM(C24:C30)","v":0},{"$f":"SUM(D24:D30)","v":0},{"$f":"SUM(E24:E30)","v":0}]
[]
[null,"( – )  OPERATING EXPENSES"]
[null,"ACCOUNT FEES",0,0,0]
[null,"ADVERTISING",0,0,0]
[null,"BANK FEES",0,0,0]
[null,"CONTINUING EDUCATION",0,0,0]
[null,"DUES / SUBSCRIPTIONS",0,0,0]
[null,"INSURANCE",0,0,0]
[null,"INTERNET",0,0,0]
[null,"LICENSES / PERMITS",0,0,0]
[null,"MEALS / ENTERTAINMENT",0,0,0]
[null,"OFFICE SUPPLIES",0,0,0]
[null,"PAYROLL PROCESSING",0,0,0]
[null,"PAYROLL TAXES / BENEFITS - INDIRECT",0,0,0]
[null,"POSTAGE / SHIPPING",0,0,0]
[null,"PRINTING",0,0,0]
[null,"PROFESSIONAL SERVICES",0,0,0]
[null,"OCCUPANCY",0,0,0]
[null,"RENTAL FEES",0,0,0]
[null,"SALARIES - INDIRECT",0,0,0]
[null,"SUBCONTRACTORS",0,0,0]
[null,"TELEPHONE",0,0,0]
[null,"TRANSPORTATION",0,0,0]
[null,"TRAVEL",0,0,0]
[null,"UTILITIES",0,0,0]
[null,"WEB DEVELOPMENT",0,0,0]
[null,"WEB DOMAIN AND HOSTING",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"TOTAL OPERATING EXPENSES",{"$f":"SUM(C34:C61)","v":0},{"$f":"SUM(D34:D61)","v":0},{"$f":"SUM(E34:E61)","v":0}]
[]
[null,"( – )  ADDITIONAL EXPENSES"]
[null,"CASH DISBURSEMENTS TO OWNERS",0,0,0]
[null,"CHARITABLE CONTRIBUTIONS",0,0,0]
[null,"INTEREST EXPENSE",0,0,0]
[null,"INCOME TAX EXPENSE",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"OTHER",0,0,0]
[null,"TOTAL ADDITIONAL EXPENSES",{"$f":"SUM(C65:C71)","v":0},{"$f":"SUM(D65:D71)","v":0},{"$f":"SUM(E65:E71)","v":0}]
[]
[null,"TOTAL CASH PAYMENTS",{"$f":"SUM(C31,C62,C72)","v":0},{"$f":"SUM(D31,D62,D72)","v":0},{"$f":"SUM(E31,E62,E72)","v":0}]
[]
[null,"NET CASH CHANGE\n (CASH RECEIPTS – CASH PAYMENTS)",{"$f":"C20-C74","v":0},{"$f":"D20-D74","v":0},{"$f":"E20-E74","v":0}]
[]
[null,"MONTH-ENDING CASH POSITION\n (CASH ON HAND + CASH RECEIPTS – CASH PAYMENTS)",{"$f":"SUM(C8,C20)-C74","v":0},{"$f":"SUM(D8,D20)-D74","v":0},{"$f":"SUM(E8,E20)-E74","v":0}]
[]
[null,"CLICK HERE TO CREATE CASH FLOW ANALYSIS TEMPLATES IN SMARTSHEET"]