{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cash Flow Statement","3-Year Cash Flow","12-Month Cash Flow"],"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 Statement","index":0,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":false,"merged":[[34,1,34,2],[37,1,37,2],[44,1,44,2],[42,1,42,2],[0,1,0,4],[2,6,3,6],[3,1,3,3],[2,1,2,3],[33,1,33,3],[8,1,8,3],[9,1,9,2],[12,1,12,2],[21,1,21,3],[22,1,22,2],[26,1,26,2],[19,1,19,2],[31,1,31,2]]}
[null,"3-YEAR CASH FLOW TEMPLATE"]
[]
[null,"[Company Name]",null,null,null,null,"CLICK HERE TO CREATE 3-YEAR CASH FLOW TEMPLATES IN SMARTSHEET"]
[null,"CASH FLOW STATEMENT"]
[]
[null,null,"For the Year Ending","2019-12-31"]
[null,null,"Cash at Beginning of Year",0]
[]
[null,"Operations"]
[null,"Cash Receipts from"]
[null,null,"Customers",0]
[null,null,"Other Operations",0]
[null,"Cash Paid for"]
[null,null,"Inventory Purchases",0]
[null,null,"General Operating and Administrative Expenses",0]
[null,null,"Wage Expenses",0]
[null,null,"Interest",0]
[null,null,"Income Taxes",0]
[]
[null,"Net Cash Flow from Operations",null,{"$f":"SUM(D11:D18)","v":0}]
[]
[null,"Investing Activities"]
[null,"Cash Receipts from"]
[null,null,"Sale of Property and Equipment",0]
[null,null,"Collection of Principal on Loans",0]
[null,null,"Sale of Investment Securities",0]
[null,"Cash Paid for"]
[null,null,"Purchase of Property and Equipment",0]
[null,null,"Making Loans to Other Entities",0]
[null,null,"Purchase of Investment Securities",0]
[]
[null,"Net Cash Flow from Investing Activities",null,{"$f":"SUM(D24:D30)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "]
[]
[null,"Financing Activities"]
[null,"Cash Receipts from"]
[null,null,"Issuance of Stock",0]
[null,null,"Borrowing",0]
[null,"Cash Paid for"]
[null,null,"Repurchase of Stock (Treasury Stock)",0]
[null,null,"Repayments of Loans",0]
[null,null,"Dividends",0]
[]
[null,"Net Cash Flow from Financing Activities",null,{"$f":"SUM(D36:D41)","v":0}]
[]
[null,"Net Increase in Cash",null,{"$f":"D20+D32+D43","v":0}]
[]
[null,null,"Cash at End of Year",{"$f":"D7+D45","v":0}]

{"sheet":"3-Year Cash Flow","index":1,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":false,"merged":[[32,1,32,2],[43,1,43,2],[38,1,38,2],[45,1,45,2],[2,1,2,5],[3,1,3,5],[9,1,9,2],[22,1,22,2],[34,1,34,2],[23,1,23,2],[27,1,27,2],[35,1,35,2],[10,1,10,2],[13,1,13,2],[20,1,20,2]]}
[]
[]
[null,"[Company Name]"]
[null,"3-YEAR CASH FLOW"]
[]
[null,null,"For the Year Ending","2017-12-31","2018-12-31","2019-12-31"]
[null,null,"Cash at Beginning of Year",0,0,0]
[null,null,"Cash at End of Year",{"$f":"D7+D46","v":0},{"$f":"E7+E46","v":0},{"$f":"F7+F46","v":0}]
[]
[null,"Operations",null,2017,2018,2019]
[null,"Cash Receipts from"]
[null,null,"Customers",0,0,0]
[null,null,"Other Operations",0,0,0]
[null,"Cash Paid for"]
[null,null,"Inventory Purchases",0,0,0]
[null,null,"General Operating and Administrative Expenses",0,0,0]
[null,null,"Wage Expenses",0,0,0]
[null,null,"Interest",0,0,0]
[null,null,"Income Taxes",0,0,0]
[]
[null,"Net Cash Flow from Operations",null,{"$f":"SUM(D12:D19)","v":0},{"$f":"SUM(E12:E19)","v":0},{"$f":"SUM(F12:F19)","v":0}]
[]
[null,"Investing Activities"]
[null,"Cash Receipts from"]
[null,null,"Sale of Property and Equipment",0,0,0]
[null,null,"Collection of Principal on Loans",0,0,0]
[null,null,"Sale of Investment Securities",0,0,0]
[null,"Cash Paid for"]
[null,null,"Purchase of Property and Equipment",0,0,0]
[null,null,"Making Loans to Other Entities",0,0,0]
[null,null,"Purchase of Investment Securities",0,0,0]
[]
[null,"Net Cash Flow from Investing Activities",null,{"$f":"SUM(D25:D31)","v":0},{"$f":"SUM(E25:E31)","v":0},0," "," "," "," "," "," "," "," "," "," "]
[]
[null,"Financing Activities"]
[null,"Cash Receipts from"]
[null,null,"Issuance of Stock",0,0,0]
[null,null,"Borrowing",0,0,0]
[null,"Cash Paid for"]
[null,null,"Repurchase of Stock (Treasury Stock)",0,0,0]
[null,null,"Repayments of Loans",0,0,0]
[null,null,"Dividends",0,0,0]
[]
[null,"Net Cash Flow from Financing Activities",null,{"$f":"SUM(D37:D42)","v":0},{"$f":"SUM(E37:E42)","v":0},0]
[]
[null,"Net Increase in Cash",null,{"$f":"D21+D33+D44","v":0},{"$f":"E21+E33+E44","v":0},0]

{"sheet":"12-Month Cash Flow","index":2,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":false,"merged":[[40,1,40,2],[45,1,45,2],[47,1,47,2],[2,1,2,14],[3,1,3,14],[24,1,24,2],[25,1,25,2],[29,1,29,2],[34,1,34,2],[36,1,36,2],[37,1,37,2],[11,1,11,2],[12,1,12,2],[15,1,15,2],[22,1,22,2]]}
[]
[]
[null,"[Company Name]"]
[null,"12-MONTH CASH FLOW"]
[]
[null,null,"Period Beginning","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01"]
[null,null,"Period Ending","2020-01-31","2020-02-29","2020-03-31","2020-04-30","2020-05-31","2020-06-30","2020-07-31","2020-08-31","2020-09-30","2020-10-31","2020-11-30","2020-12-31"]
[null,null," "," "," "," "]
[null,null,"Cash at Beginning of Period",0,0,{"$f":"E10","v":0},{"$f":"F10","v":0},{"$f":"G10","v":0},0,0,0,0,0,0,0]
[null,null,"Cash at End of Period",{"$f":"D9+D48","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Operations",null,{"$f":"D6","v":"2020-01-01"},{"$f":"DATE(YEAR(D12), MONTH(D12)+1, DAY(D12))","v":"2020-02-01"},{"$f":"DATE(YEAR(E12), MONTH(E12)+1, DAY(E12))","v":"2020-03-01"},"2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01"]
[null,"Cash Receipts from"]
[null,null,"Customers",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Other Operations",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cash Paid for"]
[null,null,"Inventory Purchases",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"General Operating and Administrative Expenses",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Wage Expenses",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Interest",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Income Taxes",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Net Cash Flow from Operations",null,{"$f":"SUM(D14:D21)","v":0},{"$f":"SUM(E14:E21)","v":0},0,0,{"$f":"SUM(H14:H21)","v":0},0,0,0,0,0,0,{"$f":"SUM(O14:O21)","v":0}]
[]
[null,"Investing Activities"]
[null,"Cash Receipts from"]
[null,null,"Sale of Property and Equipment"," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "]
[null,null,"Collection of Principal on Loans"," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "]
[null,null,"Sale of Investment Securities"," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "]
[null,"Cash Paid for"]
[null,null,"Purchase of Property and Equipment"," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "]
[null,null,"Making Loans to Other Entities"," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "]
[null,null,"Purchase of Investment Securities"," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "]
[]
[null,"Net Cash Flow from Investing Activities",null,{"$f":"SUM(D27:D33)","v":0},0,0,0,0,0,0,0,0,0,0,0," "]
[]
[null,"Financing Activities"]
[null,"Cash Receipts from"]
[null,null,"Issuance of Stock"," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "]
[null,null,"Borrowing"," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "]
[null,"Cash Paid for"]
[null,null,"Repurchase of Stock (Treasury Stock)"," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "]
[null,null,"Repayments of Loans"," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "]
[null,null,"Dividends"," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "," $-  "]
[]
[null,"Net Cash Flow from Financing Activities",null,{"$f":"SUM(D39:D44)","v":0},{"$f":"SUM(E39:E44)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"Net Increase in Cash",null,{"$f":"D23+D35+D46","v":0},{"$f":"E23+E35+E46","v":0},0,0,0,0,0,0,0,0,0,0]