{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["12-Month Cash Flow Forecast"],"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":"12-Month Cash Flow Forecast","index":0,"n_rows":39,"n_cols":28,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,2,2,3],[2,4,2,5],[2,8,2,9],[2,10,2,11],[2,12,2,13],[2,6,2,7],[2,26,2,27],[2,20,2,21],[2,22,2,23],[2,24,2,25],[2,14,2,15],[2,16,2,17],[2,18,2,19],[38,1,38,27]]}
[null,"12-MONTH CASH FLOW FORECAST TEMPLATE"]
[]
[null,"COMPANY NAME","JANUARY",null,"FEBRUARY",null,"MARCH",null,"APRIL",null,"MAY",null,"JUNE",null,"JULY",null,"AUGUST",null,"SEPTEMBER",null,"OCTOBER",null,"NOVEMBER",null,"DECEMBER",null,"YEARLY TOTALS"]
[null,"FISCAL YEAR DATES","EXPECTED","ACTUAL","EXPECTED","ACTUAL","EXPECTED","ACTUAL","EXPECTED","ACTUAL","EXPECTED","ACTUAL","EXPECTED","ACTUAL","EXPECTED","ACTUAL","EXPECTED","ACTUAL","EXPECTED","ACTUAL","EXPECTED","ACTUAL","EXPECTED","ACTUAL","EXPECTED","ACTUAL","EXPECTED","ACTUAL"]
[null,"CASH ON HAND (beginning of month)",0,0,{"$f":"C37","v":0},{"$f":"D37","v":0},{"$f":"E37","v":0},{"$f":"F37","v":0},0,{"$f":"H37","v":0},{"$f":"I37","v":0},{"$f":"J37","v":0},{"$f":"K37","v":0},{"$f":"L37","v":0},{"$f":"M37","v":0},{"$f":"N37","v":0},{"$f":"O37","v":0},{"$f":"P37","v":0},{"$f":"Q37","v":0},{"$f":"R37","v":0},{"$f":"S37","v":0},{"$f":"T37","v":0},{"$f":"U37","v":0},{"$f":"V37","v":0},{"$f":"W37","v":0},{"$f":"X37","v":0},{"$f":"Y5+W5+U5+S5+Q5+O5+M5+K5+I5+G5+E5+C5","v":0},{"$f":"Z5+X5+V5+T5+R5+P5+N5+L5+J5+H5+F5+D5","v":0}]
[]
[null,"CASH RECEIPTS"]
[null,"Customers",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y8+W8+U8+S8+Q8+O8+M8+K8+I8+G8+E8+C8","v":0},{"$f":"Z8+X8+V8+T8+R8+P8+N8+L8+J8+H8+F8+D8","v":0}]
[null,"Other Operations",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y9+W9+U9+S9+Q9+O9+M9+K9+I9+G9+E9+C9","v":0},{"$f":"Z9+X9+V9+T9+R9+P9+N9+L9+J9+H9+F9+D9","v":0}]
[null,"Sale of Property and Equipment",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Collection of Principal on Loans",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Sale of Investment Securities",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Issuance of Stock",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y13+W13+U13+S13+Q13+O13+M13+K13+I13+G13+E13+C13","v":0},{"$f":"Z13+X13+V13+T13+R13+P13+N13+L13+J13+H13+F13+D13","v":0}]
[null,"Borrowing",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y14+W14+U14+S14+Q14+O14+M14+K14+I14+G14+E14+C14","v":0},{"$f":"Z14+X14+V14+T14+R14+P14+N14+L14+J14+H14+F14+D14","v":0}]
[null,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y16+W16+U16+S16+Q16+O16+M16+K16+I16+G16+E16+C16","v":0},{"$f":"Z16+X16+V16+T16+R16+P16+N16+L16+J16+H16+F16+D16","v":0}]
[null,"TOTAL CASH RECEIPTS",{"$f":"SUM(C8:C16)","v":0},{"$f":"SUM(D8:D16)","v":0},{"$f":"SUM(E8:E16)","v":0},0,0,0,{"$f":"SUM(I8:I16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AA8:AA16)","v":0},{"$f":"SUM(AB8:AB16)","v":0}]
[null,"TOTAL CASH AVAILABLE (before cash out)",{"$f":"C5+C17","v":0},{"$f":"D5+D17","v":0},{"$f":"E5+E17","v":0},0,0,{"$f":"H5+H17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AA5+AA17","v":0},{"$f":"AB5+AB17","v":0}]
[]
[null,"CASH PAID OUT"]
[null,"Purchase of Property and Equipment",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y21+W21+U21+S21+Q21+O21+M21+K21+I21+G21+E21+C21","v":0},{"$f":"Z21+X21+V21+T21+R21+P21+N21+L21+J21+H21+F21+D21","v":0}]
[null,"Making Loans to Other Entities",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y22+W22+U22+S22+Q22+O22+M22+K22+I22+G22+E22+C22","v":0},{"$f":"Z22+X22+V22+T22+R22+P22+N22+L22+J22+H22+F22+D22","v":0}]
[null,"Purchase of Investment Securities",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Inventory Purchases",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"General Operating and Administrative Expenses",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Wage Expenses",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y27+W27+U27+S27+Q27+O27+M27+K27+I27+G27+E27+C27","v":0},{"$f":"Z27+X27+V27+T27+R27+P27+N27+L27+J27+H27+F27+D27","v":0}]
[null,"Income Taxes",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Z28+X28+V28+T28+R28+P28+N28+L28+J28+H28+F28+D28","v":0}]
[null,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Z30+X30+V30+T30+R30+P30+N30+L30+J30+H30+F30+D30","v":0}]
[null,"SUBTOTAL",{"$f":"SUM(C21:C30)","v":0},{"$f":"SUM(D21:D30)","v":0},0,0,0,{"$f":"SUM(H21:H30)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AA21:AA30)","v":0},{"$f":"SUM(AB21:AB30)","v":0}]
[null,"Repurchase of Stock (Treasury Stock)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y32+W32+U32+S32+Q32+O32+M32+K32+I32+G32+E32+C32","v":0},{"$f":"Z32+X32+V32+T32+R32+P32+N32+L32+J32+H32+F32+D32","v":0}]
[null,"Repayments of Loans",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y33+W33+U33+S33+Q33+O33+M33+K33+I33+G33+E33+C33","v":0},{"$f":"Z33+X33+V33+T33+R33+P33+N33+L33+J33+H33+F33+D33","v":0}]
[null,"Dividends",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Z34+X34+V34+T34+R34+P34+N34+L34+J34+H34+F34+D34","v":0}]
[null,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL CASH PAID OUT",{"$f":"SUM(C31:C35)","v":0},{"$f":"SUM(D31:D35)","v":0},{"$f":"SUM(E31:E35)","v":0},{"$f":"SUM(F31:F35)","v":0},{"$f":"SUM(G31:G35)","v":0},{"$f":"SUM(H31:H35)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AA31:AA35)","v":0},{"$f":"SUM(AB31:AB35)","v":0}]
[null,"CASH POSITION (end of month)",{"$f":"C17-C36","v":0},{"$f":"D17-D36","v":0},{"$f":"E17-E36","v":0},{"$f":"F17-F36","v":0},{"$f":"G17-G36","v":0},{"$f":"H17-H36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AA17+AA31+AA36","v":0},{"$f":"AB17+AB31+AB36","v":0}]
[]
[null,"CLICK HERE TO CREATE 12-MONTH CASH FLOW FORECAST TEMPLATES IN SMARTSHEET"]