{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Front","data","graphs"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":1,"defined_names":284,"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":"Front","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[22,1,22,11],[7,3,7,11],[2,1,2,11],[4,1,4,11]]}
[]
[]
[null,"WHERE DID THE                  MONEY GO?"]
[]
[null,"Use this tool to produce a funds flow spreadsheet. It is really useful for clients to know how they spent their money.  If gets them thinking about cash management.  "]
[]
[]
[null,"Client Name",null,"Demonstration Limited"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Version 3.01","2023-01-01","(243-2301)"]

{"sheet":"data","index":1,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,1,2,6],[6,9,6,19],[7,9,7,18],[44,1,44,6],[46,1,46,6],[36,1,36,2],[40,1,40,2],[3,1,3,6],[7,1,7,2],[33,1,33,2],[31,1,31,2],[10,1,10,2],[17,1,17,2],[20,1,20,2],[30,1,30,2],[4,1,4,6]]}
[null,null,null,null,null,null,"WHERE DID THE MONEY GO?"]
[]
[null,{"$f":"Front!D8","v":"Demonstration Limited"}]
[null,"Where did the money go?"]
[null,"Use this tool to produce a funds flow spreadsheet. It is really useful for clients to know how they spent their money.  If gets them thinking about cash management.  "]
[null,null,null,null,2023,null,2022,null,null,"Hints and Tips"]
[null,null,null,null,null,null,null,null,null,"Enter figures in the How we have spent the money section as negative - they will appear red."]
[null,"Money from trading",null,null,null,null,null,null,null,"Hide unwanted rows before producing graphs."]
[null,null,"The net profit before depreciation",null,150000,null,120000]
[null,null,null," ",null," "]
[null,"Money from other sources"]
[null,null,"Increase in HP liability",null,20000,null," ",null,null,null,null,{"$f":"IF(E12>0,1,IF(G12>0,1,0))","v":1}]
[null,null,"Sales of assets"," ",2000," ",5000,null,null,null,null,{"$f":"IF(E13>0,1,IF(G13>0,1,0))","v":1}]
[null,null,"Increase in what we owe our suppliers and others"," ",1000," "," ",null,null,null,null,{"$f":"IF(E14>0,1,IF(G14>0,1,0))","v":1}]
[null,null,"Capital Introduced"," ",20000," ",20000,null,null,null,null,{"$f":"IF(SUM(E15:G15)>0,1,0)","v":1}]
[null,null,"Spare"," "," "," ",null,null,null,null,null,{"$f":"IF(SUM(E16:G16)>0,1,0)","v":0}]
[null,null,"Spare"," "," ",null,null,null,null,null,null,0]
[null,"Total extra money for the year",null," ",{"$f":"SUM(E8:E17)","v":193000},null,{"$f":"SUM(G8:G17)","v":145000}]
[]
[]
[null,"How we have spent this money"]
[null,null,"Our private or personal expenses",null,-15000,null,-20000,null,null,null,null,{"$f":"IF(SUM(E22:G22)<>0,1,0)","v":1}]
[null,null,"Our income tax bill"," ",-30000," ",-20000,null,null,null,null,{"$f":"IF(SUM(E23:G23)<>0,1,0)","v":1}]
[null,null,"Purchase of assets"," ",-30000," ",-25000,null,null,null,null,1]
[null,null,"Increase in the amount our customers and others owe us"," ",-3000," "," ",null,null,null,null,1]
[null,null,"Decrease in loans"," ",-15000," "," ",null,null,null,null,1]
[null,null,"Spare"," ",null," "," ",null,null,null,null,0]
[null,null,"Spare",null," "," "," ",null,null,null,null,0]
[null,"Total money spent in the year",null,null,{"$f":"SUM(E22:E28)","v":-93000}," ",{"$f":"SUM(G22:G28)","v":-65000}]
[]
[null,"This leaves us with-"]
[null,"Increase/(decrease) in cash",null,null,{"$f":"+E18+E29","v":100000},null,{"$f":"+G18+G29","v":80000}]
[]
[]
[null,"Reconciled to cash movement:"]
[]
[null,"Cash at bank and in hand"]
[null,null,"At the beginning of the year",null,75000,null,-5000]
[null,null,"At the end of the year"," ",175000," ",75000]
[null,null,null," ",null," "]
[null,"Increase/(decrease) in cash",null,null,{"$f":"E39-E38","v":100000},null,{"$f":"G39-G38","v":80000}]
[]
[]
[]
[null,{"$f":"IF((E38-G39)<>0,\"WARNING !!!Cash at end of last year and at beginning of this year differ!\",\"\")","v":""}]

{"sheet":"graphs","index":2,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,1,2,6],[3,1,3,6]]}
[null,null,null,null,null,null,null,null,null,null,null,"WHERE DID THE MONEY GO?"]
[]
[null,{"$f":"Front!D8","v":"Demonstration Limited"}]
[null,"Where did the money go?"]
[null,"Use this tool to produce a funds flow spreadsheet. It is really useful for clients to know how they spent their money.  If gets them thinking about cash management.  "]