{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Cash Flow Statement","3-Year Cash Flow","12-Month Cash Flow"],"not_rendered":{"images":2},"read":"whole","date_system":"1900"}

{"sheet":"Cash Flow Statement","index":0,"n_rows":49,"n_cols":4,"rows_kept":49,"merged":[[4,1,4,3],[10,1,10,2],[13,1,13,2],[19,1,19,2],[22,1,22,2],[26,1,26,2],[30,1,30,2],[33,1,33,2],[36,1,36,2],[40,1,40,2],[42,1,42,2],[48,1,48,3]]}
[null,"CASH-FLOW STATEMENT"]
[]
[null,"Company Name"]
[]
[null,"CASH-FLOW STATEMENT"]
[]
[null,null,"For the Year Ending","2018-12-31"]
[null,null,"Cash at Beginning of Year",{"v":15700,"d":"15,700 "}]
[]
[null,"Operations"]
[null,"Cash Receipts from"]
[null,null,"Customers",{"v":693200,"d":"693,200 "}]
[null,null,"Other Operations"]
[null,"Cash Paid for"]
[null,null,"Inventory Purchases",{"v":-264000,"d":"(264,000)"}]
[null,null,"General Operating and Administrative Expenses",{"v":-112000,"d":"(112,000)"}]
[null,null,"Wage Expenses",{"v":-123000,"d":"(123,000)"}]
[null,null,"Interest",{"v":-13500,"d":"(13,500)"}]
[null,null,"Income Taxes",{"v":-32800,"d":"(32,800)"}]
[null,"Net Cash Flow from Operations",null,{"$f":"SUM(D12:D19)","v":{"v":147900,"d":"147,900 "}}]
[]
[null,"Investing Activities"]
[null,"Cash Receipts from"]
[null,null,"Sale of Property and Equipment",{"v":33600,"d":"33,600 "}]
[null,null,"Collection of Principal on Loans"]
[null,null,"Sale of Investment Securities"]
[null,"Cash Paid for"]
[null,null,"Purchase of Property and Equipment",{"v":-75000,"d":"(75,000)"}]
[null,null,"Making Loans to Other Entities"]
[null,null,"Purchase of Investment Securities"]
[null,"Net Cash Flow from Investing Activities",null,{"$f":"SUM(D23:D30)","v":{"v":-41400,"d":"(41,400)"}}]
[]
[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",{"v":-34000,"d":"(34,000)"}]
[null,null,"Dividends",{"v":-53000,"d":"(53,000)"}]
[null,"Net Cash Flow from Financing Activites",null,{"$f":"SUM(D34:D40)","v":{"v":-87000,"d":"(87,000)"}}]
[]
[null,"Net Increase in Cash",null,{"$f":"D20+D31+D41","v":{"v":19500,"d":"19,500 "}}]
[]
[null,null,"Cash at End of Year",{"$f":"D8+D43","v":{"v":35200,"d":"35,200 "}}]
[]
[]
[]
[null,"CLICK HERE TO CREATE CASH-FLOW STATEMENT TEMPLATES IN SMARTSHEET"]

{"sheet":"3-Year Cash Flow","index":1,"n_rows":42,"n_cols":6,"rows_kept":42,"merged":[[2,1,2,5],[8,1,8,2],[9,1,9,2],[12,1,12,2],[18,1,18,2],[20,1,20,2],[21,1,21,2],[25,1,25,2],[29,1,29,2],[31,1,31,2],[32,1,32,2],[35,1,35,2],[39,1,39,2],[41,1,41,2]]}
[null,{"$f":"'Cash Flow Statement'!B3","v":"Company Name"}]
[]
[null,"THREE-YEAR CASH FLOW"]
[]
[null,null,"For the Year Ending","2016-12-31","2017-12-31","2018-12-31"]
[null,null,"Cash at Beginning of Year",{"v":15700,"d":"15,700 "},{"$f":"D7","v":{"v":35200,"d":"35,200 "}},{"$f":"E7","v":{"v":56650,"d":"56,650 "}}]
[null,null,"Cash at End of Year",{"$f":"D6+D42","v":{"v":35200,"d":"35,200 "}},{"$f":"E6+E42","v":{"v":56650,"d":"56,650 "}},{"$f":"F6+F42","v":{"v":80245,"d":"80,245 "}}]
[]
[null,"Operations",null,2016,2017,2018]
[null,"Cash Receipts from"]
[null,null,"Customers",{"v":693200,"d":"693,200 "},{"v":762520,"d":"762,520 "},{"v":838772,"d":"838,772 "}]
[null,null,"Other Operations"]
[null,"Cash Paid for"]
[null,null,"Inventory Purchses",{"v":-264000,"d":"(264,000)"},{"v":-290400,"d":"(290,400)"},{"v":-319440,"d":"(319,440)"}]
[null,null,"General Operating and Administrative Expenses",{"v":-112000,"d":"(112,000)"},{"v":-123200,"d":"(123,200)"},{"v":-135520,"d":"(135,520)"}]
[null,null,"Wage Expenses",{"v":-123000,"d":"(123,000)"},{"v":-135300,"d":"(135,300)"},{"v":-148830,"d":"(148,830)"}]
[null,null,"Interest",{"v":-13500,"d":"(13,500)"},{"v":-14850,"d":"(14,850)"},{"v":-16335,"d":"(16,335)"}]
[null,null,"Income Taxes",{"v":-32800,"d":"(32,800)"},{"v":-36080,"d":"(36,080)"},{"v":-39688,"d":"(39,688)"}]
[null,"Net Cash Flow from Operations",null,{"$f":"SUM(D11:D18)","v":{"v":147900,"d":"147,900 "}},{"$f":"SUM(E11:E18)","v":{"v":162690,"d":"162,690 "}},{"v":178959,"d":"178,959 "}]
[]
[null,"Investing Activities",null,2016,2017,2018]
[null,"Cash Receipts from"]
[null,null,"Sale of Property and Equipment",{"v":33600,"d":"33,600 "},{"v":36960,"d":"36,960 "},{"v":40656,"d":"40,656 "}]
[null,null,"Collection of Principal on Loans"]
[null,null,"Sale of Investment Securities"]
[null,"Cash Paid for"]
[null,null,"Purchase of Property and Equipment",{"v":-75000,"d":"(75,000)"},{"v":-82500,"d":"(82,500)"},{"v":-90750,"d":"(90,750)"}]
[null,null,"Making Loans to Other Entities"]
[null,null,"Purchase of Investment Securities"]
[null,"Net Cash Flow from Investing Activities",null,{"$f":"SUM(D22:D29)","v":{"v":-41400,"d":"(41,400)"}},{"$f":"SUM(E22:E29)","v":{"v":-45540,"d":"(45,540)"}},{"v":-50094,"d":"(50,094)"}]
[]
[null,"Financing Activities",null,2016,2017,2018]
[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",{"v":-34000,"d":"(34,000)"},{"v":-37400,"d":"(37,400)"},{"v":-41140,"d":"(41,140)"}]
[null,null,"Dividends",{"v":-53000,"d":"(53,000)"},{"v":-58300,"d":"(58,300)"},{"v":-64130,"d":"(64,130)"}]
[null,"Net Cash Flow from Financing Activites",null,{"$f":"SUM(D33:D39)","v":{"v":-87000,"d":"(87,000)"}},{"$f":"SUM(E33:E39)","v":{"v":-95700,"d":"(95,700)"}},{"v":-105270,"d":"(105,270)"}]
[]
[null,"Net Increase in Cash",null,{"$f":"D19+D30+D40","v":{"v":19500,"d":"19,500 "}},{"$f":"E19+E30+E40","v":{"v":21450,"d":"21,450 "}},{"v":23595,"d":"23,595 "}]

{"sheet":"12-Month Cash Flow","index":2,"n_rows":45,"n_cols":16,"rows_kept":45,"merged":[[2,1,2,14],[11,1,11,2],[12,1,12,2],[15,1,15,2],[21,1,21,2],[23,1,23,2],[24,1,24,2],[28,1,28,2],[32,1,32,2],[34,1,34,2],[35,1,35,2],[38,1,38,2],[42,1,42,2],[44,1,44,2],[45,1,49,14]]}
[null,{"$f":"'Cash Flow Statement'!B3","v":"Company Name"}]
[]
[null,"12-MONTH CASH FLOW"]
[]
[null,null,"Period Beginning","2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01"]
[null,null,"Period Ending","2018-01-31","2019-02-28","2018-03-31","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31"]
[null,null," "," "," "," "]
[null,null,"Cash at Beginning of Period",{"v":15700,"d":"15,700 "},{"$f":"D10","v":{"v":17326,"d":"17,326 "}},{"$f":"E10","v":{"v":17326,"d":"17,326 "}},{"$f":"F10","v":{"v":17326,"d":"17,326 "}},{"$f":"G10","v":{"v":17326,"d":"17,326 "}},{"v":17326,"d":"17,326 "},{"v":17326,"d":"17,326 "},{"v":17326,"d":"17,326 "},{"v":17326,"d":"17,326 "},{"v":17326,"d":"17,326 "},{"v":17326,"d":"17,326 "},{"v":17326,"d":"17,326 "}]
[null,null," "," "," "," "]
[null,null,"Cash at End of Period",{"$f":"D8+D45","v":{"v":17326,"d":"17,326 "}},{"$f":"E8+E45","v":{"v":17326,"d":"17,326 "}},{"$f":"F8+F45","v":{"v":17326,"d":"17,326 "}},{"$f":"G8+G45","v":{"v":17326,"d":"17,326 "}},{"v":17326,"d":"17,326 "},{"v":17326,"d":"17,326 "},{"v":17326,"d":"17,326 "},{"v":17326,"d":"17,326 "},{"v":17326,"d":"17,326 "},{"v":17326,"d":"17,326 "},{"v":17326,"d":"17,326 "},{"v":17326,"d":"17,326 "}]
[]
[null,"Operations",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,"Cash Receipts from"]
[null,null,"Customers",{"v":57767,"d":"57,767 "}]
[null,null,"Other Operations"]
[null,"Cash Paid for"]
[null,null,"Inventory Purchases",{"v":-22000,"d":"(22,000)"}]
[null,null,"General Operating and Administrative Expenses",{"v":-9333,"d":"(9,333)"}]
[null,null,"Wage Expenses",{"v":-10250,"d":"(10,250)"}]
[null,null,"Interest",{"v":-1125,"d":"(1,125)"}]
[null,null,"Income Taxes",{"v":-2733,"d":"(2,733)"}]
[null,"Net Cash Flow From Operations",null,{"$f":"SUM(D14:D21)","v":{"v":12326,"d":"12,326 "}},{"$f":"SUM(E14:E21)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"$f":"SUM(G14:G21)","v":{"v":0,"d":"0 "}},{"$f":"SUM(H14:H21)","v":{"v":0,"d":"0 "}},{"$f":"SUM(I14:I21)","v":{"v":0,"d":"0 "}},{"$f":"SUM(J14:J21)","v":{"v":0,"d":"0 "}},{"$f":"SUM(K14:K21)","v":{"v":0,"d":"0 "}},{"$f":"SUM(L14:L21)","v":{"v":0,"d":"0 "}},{"$f":"SUM(M14:M21)","v":{"v":0,"d":"0 "}},{"$f":"SUM(N14:N21)","v":{"v":0,"d":"0 "}},{"$f":"SUM(O14:O21)","v":{"v":0,"d":"0 "}}]
[]
[null,"Investing Activities",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,"Cash Receipts from"]
[null,null,"Sale of Property and Equipment",{"v":2800,"d":"2,800 "}]
[null,null,"Collection of Principal on Loans"]
[null,null,"Sale of Investment Securities"]
[null,"Cash Paid for"]
[null,null,"Purchase of Property and Equipment",{"v":-6250,"d":"(6,250)"}]
[null,null,"Making Loans to Other Entities"]
[null,null,"Purchase of Investment Securities"]
[null,"Net Cash Flow from Investing Activities",null,{"$f":"SUM(D26:D32)","v":{"v":-3450,"d":"(3,450)"}},{"$f":"SUM(E26:E32)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}," "]
[]
[null,"Financing Activities",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[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",{"v":-2833,"d":"(2,833)"}]
[null,null,"Dividends",{"v":-4417,"d":"(4,417)"}]
[null,"Net Cash Flow from Financing Activites",null,{"$f":"SUM(D37:D42)","v":{"v":-7250,"d":"(7,250)"}},{"$f":"SUM(E37:E42)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[]
[null,"Net Increase in Cash",null,{"$f":"D22+D33+D43","v":{"v":1626,"d":"1,626 "}},{"$f":"E22+E33+E43","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"I22+I33+I43","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]