{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Help","Company Information","Forecast","Actuals","Summary"],"not_rendered":{"charts":2,"images":1,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Help","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[19,4,19,11],[21,4,21,5],[21,7,21,8],[21,10,21,11]]}
["How to use the Cash Flow Model"]
[]
[null,"Company Information"]
[null,null,"Enter Company Name"]
[null,null,"Enter Start Date for the Year"]
[]
[null,"Forecast"]
[null,null,"Enter data into all of the white blank cells (including other Income and Other Expense categories if required)"]
[]
[null,"Actuals"]
[null,null,"This sheet pulls in all the numbers from the Forecast sheet"]
[null,null,"As you progress through the year, you can replace the forecast numbers with actual numbers"]
[null,null,"The cell colour for manually entered actual numbers will turn green (Excel 2013 onwards)"]
[null,null,"This allows you to see the projected year end cash position based on year to date actuals and forecasted numbers"]
[]
[null,"Summary"]
[null,null,"Some high level summary information and Charts"]
[]
[]
[{"$nulls":4},"Xlteq the Excel Spreadsheet and Access Database Experts"]
[]
[null,null,"www.xlteq.com",null,"020 3817 6945",null,"*","info@xlteq.com",null,"*","www.xlteq.com"]

{"sheet":"Company Information","index":1,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,4,5,7],[7,4,7,7],[1,1,2,8],[5,9,5,16],[7,9,7,10],[7,12,7,13],[7,15,7,16]]}
[]
[null,"Cash Flow Model"]
[]
[]
[]
[null,"Company Name",null,null,"Company Name",{"$nulls":4},"Xlteq the Excel Spreadsheet and Access Database Experts"]
[]
[null,"Start Date",null,null,"2020-04-01",{"$nulls":4},"020 3817 6945",null,"*","info@xlteq.com",null,"*","www.xlteq.com"]

{"sheet":"Forecast","index":2,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Cash Flow Forecast for:  \"&rCompanyName","v":"Cash Flow Forecast for:  Company Name"}]
[]
[null,null,{"$f":"rStartDate","v":"2020-04-01"},{"$f":"EDATE(C3,1)","v":"2020-05-01"},{"$f":"EDATE(D3,1)","v":"2020-06-01"},"2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","Year Total"]
[null,"Cash In - Income"]
[null,"Sales",{"$nulls":12},{"$f":"SUM(C5:N5)","v":0}]
[null,"Loan or cash introduced",{"$nulls":12},{"$f":"SUM(C6:N6)","v":0}]
[null,"Other",{"$nulls":12},0]
[null,"Other",{"$nulls":12},0]
[null,"Total Cash In",{"$f":"SUM(C5:C8)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Cash Out - Expenditure"]
[null,"Salaries",{"$nulls":12},{"$f":"SUM(C12:N12)","v":0}]
[null,"Salary Costs (NI, Pensions)",{"$nulls":12},0]
[null,"Rent",{"$nulls":12},0]
[null,"Rates",{"$nulls":12},0]
[null,"Insurance",{"$nulls":12},0]
[null,"Cleaning",{"$nulls":12},0]
[null,"Water",{"$nulls":12},0]
[null,"Electricity",{"$nulls":12},0]
[null,"Gas/Oil",{"$nulls":12},0]
[null,"Stationery",{"$nulls":12},0]
[null,"Office Equipment",{"$nulls":12},0]
[null,"Telephone",{"$nulls":12},0]
[null,"Mobile",{"$nulls":12},0]
[null,"Internet",{"$nulls":12},0]
[null,"Computer equipment",{"$nulls":12},0]
[null,"Computer Software",{"$nulls":12},0]
[null,"Advertising & Marketing",{"$nulls":12},0]
[null,"Travel",{"$nulls":12},0]
[null,"Subsistence",{"$nulls":12},0]
[null,"Training",{"$nulls":12},0]
[null,"Bank Loans",{"$nulls":12},0]
[null,"Interest Payments",{"$nulls":12},0]
[null,"Bank Charges",{"$nulls":12},0]
[null,"Legal Expenses",{"$nulls":12},0]
[null,"Accountants",{"$nulls":12},{"$f":"SUM(C36:N36)","v":0}]
[null,"VAT",{"$nulls":12},{"$f":"SUM(C37:N37)","v":0}]
[null,"Other 1",{"$nulls":12},0]
[null,"Other 2",{"$nulls":12},0]
[null,"Other 3",{"$nulls":12},0]
[null,"Total Cash Out",{"$f":"SUM(C12:C40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Net Cash Flow",{"$f":"C9-C41","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Opening Balance",null,{"$f":"C46","v":0},{"$f":"D46","v":0},0,0,0,0,0,0,0,0,0]
[null,"Closing Balance",{"$f":"C45+C43","v":0},{"$f":"D45+D43","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"Actuals","index":3,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,5,0,15]]}
[{"$f":"\"Cash Flow Actuals for:  \"&rCompanyName","v":"Cash Flow Actuals for:  Company Name"},{"$nulls":4},"Figures come from the forecast sheet and can be overwritten with actuals showing an actual + forecast cash position.\nActuals are coloured green"]
[]
[null,null,{"$f":"rStartDate","v":"2020-04-01"},{"$f":"EDATE(C3,1)","v":"2020-05-01"},{"$f":"EDATE(D3,1)","v":"2020-06-01"},"2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","Year Total"]
[null,"Cash In - Income"]
[null,{"$f":"Forecast!B5","v":"Sales"},{"$f":"Forecast!C5","v":0},{"$f":"Forecast!D5","v":0},{"$f":"Forecast!E5","v":0},{"$f":"Forecast!F5","v":0},{"$f":"Forecast!G5","v":0},{"$f":"Forecast!H5","v":0},{"$f":"Forecast!I5","v":0},{"$f":"Forecast!J5","v":0},{"$f":"Forecast!K5","v":0},{"$f":"Forecast!L5","v":0},{"$f":"Forecast!M5","v":0},{"$f":"Forecast!N5","v":0},{"$f":"SUM(C5:N5)","v":0}]
[null,{"$f":"Forecast!B6","v":"Loan or cash introduced"},{"$f":"Forecast!C6","v":0},{"$f":"Forecast!D6","v":0},{"$f":"Forecast!E6","v":0},{"$f":"Forecast!F6","v":0},{"$f":"Forecast!G6","v":0},{"$f":"Forecast!H6","v":0},{"$f":"Forecast!I6","v":0},{"$f":"Forecast!J6","v":0},{"$f":"Forecast!K6","v":0},{"$f":"Forecast!L6","v":0},{"$f":"Forecast!M6","v":0},{"$f":"Forecast!N6","v":0},{"$f":"SUM(C6:N6)","v":0}]
[null,{"$f":"Forecast!B7","v":"Other"},{"$f":"Forecast!C7","v":0},{"$f":"Forecast!D7","v":0},{"$f":"Forecast!E7","v":0},{"$f":"Forecast!F7","v":0},{"$f":"Forecast!G7","v":0},{"$f":"Forecast!H7","v":0},{"$f":"Forecast!I7","v":0},{"$f":"Forecast!J7","v":0},{"$f":"Forecast!K7","v":0},{"$f":"Forecast!L7","v":0},{"$f":"Forecast!M7","v":0},{"$f":"Forecast!N7","v":0},0]
[null,{"$f":"Forecast!B8","v":"Other"},{"$f":"Forecast!C8","v":0},{"$f":"Forecast!D8","v":0},{"$f":"Forecast!E8","v":0},{"$f":"Forecast!F8","v":0},{"$f":"Forecast!G8","v":0},{"$f":"Forecast!H8","v":0},{"$f":"Forecast!I8","v":0},{"$f":"Forecast!J8","v":0},{"$f":"Forecast!K8","v":0},{"$f":"Forecast!L8","v":0},{"$f":"Forecast!M8","v":0},{"$f":"Forecast!N8","v":0},0]
[null,"Total Cash In",{"$f":"SUM(C5:C8)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Cash Out - Expenditure"]
[null,{"$f":"Forecast!B12","v":"Salaries"},{"$f":"Forecast!C12","v":0},{"$f":"Forecast!D12","v":0},{"$f":"Forecast!E12","v":0},{"$f":"Forecast!F12","v":0},{"$f":"Forecast!G12","v":0},{"$f":"Forecast!H12","v":0},{"$f":"Forecast!I12","v":0},{"$f":"Forecast!J12","v":0},{"$f":"Forecast!K12","v":0},{"$f":"Forecast!L12","v":0},{"$f":"Forecast!M12","v":0},{"$f":"Forecast!N12","v":0},{"$f":"SUM(C12:N12)","v":0}]
[null,{"$f":"Forecast!B13","v":"Salary Costs (NI, Pensions)"},{"$f":"Forecast!C13","v":0},{"$f":"Forecast!D13","v":0},{"$f":"Forecast!E13","v":0},{"$f":"Forecast!F13","v":0},{"$f":"Forecast!G13","v":0},{"$f":"Forecast!H13","v":0},{"$f":"Forecast!I13","v":0},{"$f":"Forecast!J13","v":0},{"$f":"Forecast!K13","v":0},{"$f":"Forecast!L13","v":0},{"$f":"Forecast!M13","v":0},{"$f":"Forecast!N13","v":0},0]
[null,{"$f":"Forecast!B14","v":"Rent"},{"$f":"Forecast!C14","v":0},{"$f":"Forecast!D14","v":0},{"$f":"Forecast!E14","v":0},{"$f":"Forecast!F14","v":0},{"$f":"Forecast!G14","v":0},{"$f":"Forecast!H14","v":0},{"$f":"Forecast!I14","v":0},{"$f":"Forecast!J14","v":0},{"$f":"Forecast!K14","v":0},{"$f":"Forecast!L14","v":0},{"$f":"Forecast!M14","v":0},{"$f":"Forecast!N14","v":0},0]
[null,{"$f":"Forecast!B15","v":"Rates"},{"$f":"Forecast!C15","v":0},{"$f":"Forecast!D15","v":0},{"$f":"Forecast!E15","v":0},{"$f":"Forecast!F15","v":0},{"$f":"Forecast!G15","v":0},{"$f":"Forecast!H15","v":0},{"$f":"Forecast!I15","v":0},{"$f":"Forecast!J15","v":0},{"$f":"Forecast!K15","v":0},{"$f":"Forecast!L15","v":0},{"$f":"Forecast!M15","v":0},{"$f":"Forecast!N15","v":0},0]
[null,{"$f":"Forecast!B16","v":"Insurance"},{"$f":"Forecast!C16","v":0},{"$f":"Forecast!D16","v":0},{"$f":"Forecast!E16","v":0},{"$f":"Forecast!F16","v":0},{"$f":"Forecast!G16","v":0},{"$f":"Forecast!H16","v":0},{"$f":"Forecast!I16","v":0},{"$f":"Forecast!J16","v":0},{"$f":"Forecast!K16","v":0},{"$f":"Forecast!L16","v":0},{"$f":"Forecast!M16","v":0},{"$f":"Forecast!N16","v":0},0]
[null,{"$f":"Forecast!B17","v":"Cleaning"},{"$f":"Forecast!C17","v":0},{"$f":"Forecast!D17","v":0},{"$f":"Forecast!E17","v":0},{"$f":"Forecast!F17","v":0},{"$f":"Forecast!G17","v":0},{"$f":"Forecast!H17","v":0},{"$f":"Forecast!I17","v":0},{"$f":"Forecast!J17","v":0},{"$f":"Forecast!K17","v":0},{"$f":"Forecast!L17","v":0},{"$f":"Forecast!M17","v":0},{"$f":"Forecast!N17","v":0},0]
[null,{"$f":"Forecast!B18","v":"Water"},{"$f":"Forecast!C18","v":0},{"$f":"Forecast!D18","v":0},{"$f":"Forecast!E18","v":0},{"$f":"Forecast!F18","v":0},{"$f":"Forecast!G18","v":0},{"$f":"Forecast!H18","v":0},{"$f":"Forecast!I18","v":0},{"$f":"Forecast!J18","v":0},{"$f":"Forecast!K18","v":0},{"$f":"Forecast!L18","v":0},{"$f":"Forecast!M18","v":0},{"$f":"Forecast!N18","v":0},0]
[null,{"$f":"Forecast!B19","v":"Electricity"},{"$f":"Forecast!C19","v":0},{"$f":"Forecast!D19","v":0},{"$f":"Forecast!E19","v":0},{"$f":"Forecast!F19","v":0},{"$f":"Forecast!G19","v":0},{"$f":"Forecast!H19","v":0},{"$f":"Forecast!I19","v":0},{"$f":"Forecast!J19","v":0},{"$f":"Forecast!K19","v":0},{"$f":"Forecast!L19","v":0},{"$f":"Forecast!M19","v":0},{"$f":"Forecast!N19","v":0},0]
[null,{"$f":"Forecast!B20","v":"Gas/Oil"},{"$f":"Forecast!C20","v":0},{"$f":"Forecast!D20","v":0},{"$f":"Forecast!E20","v":0},{"$f":"Forecast!F20","v":0},{"$f":"Forecast!G20","v":0},{"$f":"Forecast!H20","v":0},{"$f":"Forecast!I20","v":0},{"$f":"Forecast!J20","v":0},{"$f":"Forecast!K20","v":0},{"$f":"Forecast!L20","v":0},{"$f":"Forecast!M20","v":0},{"$f":"Forecast!N20","v":0},0]
[null,{"$f":"Forecast!B21","v":"Stationery"},{"$f":"Forecast!C21","v":0},{"$f":"Forecast!D21","v":0},{"$f":"Forecast!E21","v":0},{"$f":"Forecast!F21","v":0},{"$f":"Forecast!G21","v":0},{"$f":"Forecast!H21","v":0},{"$f":"Forecast!I21","v":0},{"$f":"Forecast!J21","v":0},{"$f":"Forecast!K21","v":0},{"$f":"Forecast!L21","v":0},{"$f":"Forecast!M21","v":0},{"$f":"Forecast!N21","v":0},0]
[null,{"$f":"Forecast!B22","v":"Office Equipment"},{"$f":"Forecast!C22","v":0},{"$f":"Forecast!D22","v":0},{"$f":"Forecast!E22","v":0},{"$f":"Forecast!F22","v":0},{"$f":"Forecast!G22","v":0},{"$f":"Forecast!H22","v":0},{"$f":"Forecast!I22","v":0},{"$f":"Forecast!J22","v":0},{"$f":"Forecast!K22","v":0},{"$f":"Forecast!L22","v":0},{"$f":"Forecast!M22","v":0},{"$f":"Forecast!N22","v":0},0]
[null,{"$f":"Forecast!B23","v":"Telephone"},{"$f":"Forecast!C23","v":0},{"$f":"Forecast!D23","v":0},{"$f":"Forecast!E23","v":0},{"$f":"Forecast!F23","v":0},{"$f":"Forecast!G23","v":0},{"$f":"Forecast!H23","v":0},{"$f":"Forecast!I23","v":0},{"$f":"Forecast!J23","v":0},{"$f":"Forecast!K23","v":0},{"$f":"Forecast!L23","v":0},{"$f":"Forecast!M23","v":0},{"$f":"Forecast!N23","v":0},0]
[null,{"$f":"Forecast!B24","v":"Mobile"},{"$f":"Forecast!C24","v":0},{"$f":"Forecast!D24","v":0},{"$f":"Forecast!E24","v":0},{"$f":"Forecast!F24","v":0},{"$f":"Forecast!G24","v":0},{"$f":"Forecast!H24","v":0},{"$f":"Forecast!I24","v":0},{"$f":"Forecast!J24","v":0},{"$f":"Forecast!K24","v":0},{"$f":"Forecast!L24","v":0},{"$f":"Forecast!M24","v":0},{"$f":"Forecast!N24","v":0},0]
[null,{"$f":"Forecast!B25","v":"Internet"},{"$f":"Forecast!C25","v":0},{"$f":"Forecast!D25","v":0},{"$f":"Forecast!E25","v":0},{"$f":"Forecast!F25","v":0},{"$f":"Forecast!G25","v":0},{"$f":"Forecast!H25","v":0},{"$f":"Forecast!I25","v":0},{"$f":"Forecast!J25","v":0},{"$f":"Forecast!K25","v":0},{"$f":"Forecast!L25","v":0},{"$f":"Forecast!M25","v":0},{"$f":"Forecast!N25","v":0},0]
[null,{"$f":"Forecast!B26","v":"Computer equipment"},{"$f":"Forecast!C26","v":0},{"$f":"Forecast!D26","v":0},{"$f":"Forecast!E26","v":0},{"$f":"Forecast!F26","v":0},{"$f":"Forecast!G26","v":0},{"$f":"Forecast!H26","v":0},{"$f":"Forecast!I26","v":0},{"$f":"Forecast!J26","v":0},{"$f":"Forecast!K26","v":0},{"$f":"Forecast!L26","v":0},{"$f":"Forecast!M26","v":0},{"$f":"Forecast!N26","v":0},0]
[null,{"$f":"Forecast!B27","v":"Computer Software"},{"$f":"Forecast!C27","v":0},{"$f":"Forecast!D27","v":0},{"$f":"Forecast!E27","v":0},{"$f":"Forecast!F27","v":0},{"$f":"Forecast!G27","v":0},{"$f":"Forecast!H27","v":0},{"$f":"Forecast!I27","v":0},{"$f":"Forecast!J27","v":0},{"$f":"Forecast!K27","v":0},{"$f":"Forecast!L27","v":0},{"$f":"Forecast!M27","v":0},{"$f":"Forecast!N27","v":0},0]
[null,{"$f":"Forecast!B28","v":"Advertising & Marketing"},{"$f":"Forecast!C28","v":0},{"$f":"Forecast!D28","v":0},{"$f":"Forecast!E28","v":0},{"$f":"Forecast!F28","v":0},{"$f":"Forecast!G28","v":0},{"$f":"Forecast!H28","v":0},{"$f":"Forecast!I28","v":0},{"$f":"Forecast!J28","v":0},{"$f":"Forecast!K28","v":0},{"$f":"Forecast!L28","v":0},{"$f":"Forecast!M28","v":0},{"$f":"Forecast!N28","v":0},0]
[null,{"$f":"Forecast!B29","v":"Travel"},{"$f":"Forecast!C29","v":0},{"$f":"Forecast!D29","v":0},{"$f":"Forecast!E29","v":0},{"$f":"Forecast!F29","v":0},{"$f":"Forecast!G29","v":0},{"$f":"Forecast!H29","v":0},{"$f":"Forecast!I29","v":0},{"$f":"Forecast!J29","v":0},{"$f":"Forecast!K29","v":0},{"$f":"Forecast!L29","v":0},{"$f":"Forecast!M29","v":0},{"$f":"Forecast!N29","v":0},0]
[null,{"$f":"Forecast!B30","v":"Subsistence"},{"$f":"Forecast!C30","v":0},{"$f":"Forecast!D30","v":0},{"$f":"Forecast!E30","v":0},{"$f":"Forecast!F30","v":0},{"$f":"Forecast!G30","v":0},{"$f":"Forecast!H30","v":0},{"$f":"Forecast!I30","v":0},{"$f":"Forecast!J30","v":0},{"$f":"Forecast!K30","v":0},{"$f":"Forecast!L30","v":0},{"$f":"Forecast!M30","v":0},{"$f":"Forecast!N30","v":0},0]
[null,{"$f":"Forecast!B31","v":"Training"},{"$f":"Forecast!C31","v":0},{"$f":"Forecast!D31","v":0},{"$f":"Forecast!E31","v":0},{"$f":"Forecast!F31","v":0},{"$f":"Forecast!G31","v":0},{"$f":"Forecast!H31","v":0},{"$f":"Forecast!I31","v":0},{"$f":"Forecast!J31","v":0},{"$f":"Forecast!K31","v":0},{"$f":"Forecast!L31","v":0},{"$f":"Forecast!M31","v":0},{"$f":"Forecast!N31","v":0},0]
[null,{"$f":"Forecast!B32","v":"Bank Loans"},{"$f":"Forecast!C32","v":0},{"$f":"Forecast!D32","v":0},{"$f":"Forecast!E32","v":0},{"$f":"Forecast!F32","v":0},{"$f":"Forecast!G32","v":0},{"$f":"Forecast!H32","v":0},{"$f":"Forecast!I32","v":0},{"$f":"Forecast!J32","v":0},{"$f":"Forecast!K32","v":0},{"$f":"Forecast!L32","v":0},{"$f":"Forecast!M32","v":0},{"$f":"Forecast!N32","v":0},0]
[null,{"$f":"Forecast!B33","v":"Interest Payments"},{"$f":"Forecast!C33","v":0},{"$f":"Forecast!D33","v":0},{"$f":"Forecast!E33","v":0},{"$f":"Forecast!F33","v":0},{"$f":"Forecast!G33","v":0},{"$f":"Forecast!H33","v":0},{"$f":"Forecast!I33","v":0},{"$f":"Forecast!J33","v":0},{"$f":"Forecast!K33","v":0},{"$f":"Forecast!L33","v":0},{"$f":"Forecast!M33","v":0},{"$f":"Forecast!N33","v":0},0]
[null,{"$f":"Forecast!B34","v":"Bank Charges"},{"$f":"Forecast!C34","v":0},{"$f":"Forecast!D34","v":0},{"$f":"Forecast!E34","v":0},{"$f":"Forecast!F34","v":0},{"$f":"Forecast!G34","v":0},{"$f":"Forecast!H34","v":0},{"$f":"Forecast!I34","v":0},{"$f":"Forecast!J34","v":0},{"$f":"Forecast!K34","v":0},{"$f":"Forecast!L34","v":0},{"$f":"Forecast!M34","v":0},{"$f":"Forecast!N34","v":0},0]
[null,{"$f":"Forecast!B35","v":"Legal Expenses"},{"$f":"Forecast!C35","v":0},{"$f":"Forecast!D35","v":0},{"$f":"Forecast!E35","v":0},{"$f":"Forecast!F35","v":0},{"$f":"Forecast!G35","v":0},{"$f":"Forecast!H35","v":0},{"$f":"Forecast!I35","v":0},{"$f":"Forecast!J35","v":0},{"$f":"Forecast!K35","v":0},{"$f":"Forecast!L35","v":0},{"$f":"Forecast!M35","v":0},{"$f":"Forecast!N35","v":0},0]
[null,{"$f":"Forecast!B36","v":"Accountants"},{"$f":"Forecast!C36","v":0},{"$f":"Forecast!D36","v":0},{"$f":"Forecast!E36","v":0},{"$f":"Forecast!F36","v":0},{"$f":"Forecast!G36","v":0},{"$f":"Forecast!H36","v":0},{"$f":"Forecast!I36","v":0},{"$f":"Forecast!J36","v":0},{"$f":"Forecast!K36","v":0},{"$f":"Forecast!L36","v":0},{"$f":"Forecast!M36","v":0},{"$f":"Forecast!N36","v":0},{"$f":"SUM(C36:N36)","v":0}]
[null,{"$f":"Forecast!B37","v":"VAT"},{"$f":"Forecast!C37","v":0},{"$f":"Forecast!D37","v":0},{"$f":"Forecast!E37","v":0},{"$f":"Forecast!F37","v":0},{"$f":"Forecast!G37","v":0},{"$f":"Forecast!H37","v":0},{"$f":"Forecast!I37","v":0},{"$f":"Forecast!J37","v":0},{"$f":"Forecast!K37","v":0},{"$f":"Forecast!L37","v":0},{"$f":"Forecast!M37","v":0},{"$f":"Forecast!N37","v":0},0]
[null,{"$f":"Forecast!B38","v":"Other 1"},{"$f":"Forecast!C38","v":0},{"$f":"Forecast!D38","v":0},{"$f":"Forecast!E38","v":0},{"$f":"Forecast!F38","v":0},{"$f":"Forecast!G38","v":0},{"$f":"Forecast!H38","v":0},{"$f":"Forecast!I38","v":0},{"$f":"Forecast!J38","v":0},{"$f":"Forecast!K38","v":0},{"$f":"Forecast!L38","v":0},{"$f":"Forecast!M38","v":0},{"$f":"Forecast!N38","v":0},0]
[null,{"$f":"Forecast!B39","v":"Other 2"},{"$f":"Forecast!C39","v":0},{"$f":"Forecast!D39","v":0},{"$f":"Forecast!E39","v":0},{"$f":"Forecast!F39","v":0},{"$f":"Forecast!G39","v":0},{"$f":"Forecast!H39","v":0},{"$f":"Forecast!I39","v":0},{"$f":"Forecast!J39","v":0},{"$f":"Forecast!K39","v":0},{"$f":"Forecast!L39","v":0},{"$f":"Forecast!M39","v":0},{"$f":"Forecast!N39","v":0},0]
[null,{"$f":"Forecast!B40","v":"Other 3"},{"$f":"Forecast!C40","v":0},{"$f":"Forecast!D40","v":0},{"$f":"Forecast!E40","v":0},{"$f":"Forecast!F40","v":0},{"$f":"Forecast!G40","v":0},{"$f":"Forecast!H40","v":0},{"$f":"Forecast!I40","v":0},{"$f":"Forecast!J40","v":0},{"$f":"Forecast!K40","v":0},{"$f":"Forecast!L40","v":0},{"$f":"Forecast!M40","v":0},{"$f":"Forecast!N40","v":0},0]
[null,"Total Cash Out",{"$f":"SUM(C12:C40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Net Cash Flow",{"$f":"C9-C41","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Opening Balance",{"$f":"Forecast!C45","v":0},{"$f":"C46","v":0},{"$f":"D46","v":0},0,0,0,0,0,0,0,0,0]
[null,"Closing Balance",{"$f":"C45+C43","v":0},{"$f":"D45+D43","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"Summary","index":4,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[35,3,35,10],[37,3,37,4],[37,6,37,7],[37,9,37,10]]}
[{"$f":"\"Cash Flow Summary:  \"&rCompanyName","v":"Cash Flow Summary:  Company Name"}]
[]
[null,null,{"$f":"Forecast!C3","v":"2020-04-01"},{"$f":"Forecast!D3","v":"2020-05-01"},{"$f":"Forecast!E3","v":"2020-06-01"},{"$f":"Forecast!F3","v":"2020-07-01"},{"$f":"Forecast!G3","v":"2020-08-01"},{"$f":"Forecast!H3","v":"2020-09-01"},{"$f":"Forecast!I3","v":"2020-10-01"},{"$f":"Forecast!J3","v":"2020-11-01"},{"$f":"Forecast!K3","v":"2020-12-01"},{"$f":"Forecast!L3","v":"2021-01-01"},{"$f":"Forecast!M3","v":"2021-02-01"},{"$f":"Forecast!N3","v":"2021-03-01"},"Total"]
["Forecast","Income",{"$f":"Forecast!C9","v":0},{"$f":"Forecast!D9","v":0},{"$f":"Forecast!E9","v":0},{"$f":"Forecast!F9","v":0},{"$f":"Forecast!G9","v":0},{"$f":"Forecast!H9","v":0},{"$f":"Forecast!I9","v":0},{"$f":"Forecast!J9","v":0},{"$f":"Forecast!K9","v":0},{"$f":"Forecast!L9","v":0},{"$f":"Forecast!M9","v":0},{"$f":"Forecast!N9","v":0},{"$f":"SUM(C4:N4)","v":0}]
[null,"Expenditure",{"$f":"Forecast!C41","v":0},{"$f":"Forecast!D41","v":0},{"$f":"Forecast!E41","v":0},{"$f":"Forecast!F41","v":0},{"$f":"Forecast!G41","v":0},{"$f":"Forecast!H41","v":0},{"$f":"Forecast!I41","v":0},{"$f":"Forecast!J41","v":0},{"$f":"Forecast!K41","v":0},{"$f":"Forecast!L41","v":0},{"$f":"Forecast!M41","v":0},{"$f":"Forecast!N41","v":0},{"$f":"SUM(C5:N5)","v":0}]
[null,"Cash Closing Balance",{"$f":"Forecast!C46","v":0},{"$f":"Forecast!D46","v":0},{"$f":"Forecast!E46","v":0},{"$f":"Forecast!F46","v":0},{"$f":"Forecast!G46","v":0},{"$f":"Forecast!H46","v":0},{"$f":"Forecast!I46","v":0},{"$f":"Forecast!J46","v":0},{"$f":"Forecast!K46","v":0},{"$f":"Forecast!L46","v":0},{"$f":"Forecast!M46","v":0},{"$f":"Forecast!N46","v":0}]
["CALC ROW - Exp as Negative","Expenditure",{"$f":"-C5","v":0},{"$f":"-D5","v":0},0,0,0,0,0,0,0,0,0,0]
["CALC ROW - Net CF","Net Cashflow",{"$f":"C4-C5","v":0},{"$f":"D4-D5","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Actual","Income",{"$f":"Actuals!C9","v":0},{"$f":"Actuals!D9","v":0},{"$f":"Actuals!E9","v":0},{"$f":"Actuals!F9","v":0},{"$f":"Actuals!G9","v":0},{"$f":"Actuals!H9","v":0},{"$f":"Actuals!I9","v":0},{"$f":"Actuals!J9","v":0},{"$f":"Actuals!K9","v":0},{"$f":"Actuals!L9","v":0},{"$f":"Actuals!M9","v":0},{"$f":"Actuals!N9","v":0},{"$f":"SUM(C10:N10)","v":0}]
[null,"Expenditure",{"$f":"Actuals!C41","v":0},{"$f":"Actuals!D41","v":0},{"$f":"Actuals!E41","v":0},{"$f":"Actuals!F41","v":0},{"$f":"Actuals!G41","v":0},{"$f":"Actuals!H41","v":0},{"$f":"Actuals!I41","v":0},{"$f":"Actuals!J41","v":0},{"$f":"Actuals!K41","v":0},{"$f":"Actuals!L41","v":0},{"$f":"Actuals!M41","v":0},{"$f":"Actuals!N41","v":0},0]
[null,"Cash Closing Balance",{"$f":"Actuals!C46","v":0},{"$f":"Actuals!D46","v":0},{"$f":"Actuals!E46","v":0},{"$f":"Actuals!F46","v":0},{"$f":"Actuals!G46","v":0},{"$f":"Actuals!H46","v":0},{"$f":"Actuals!I46","v":0},{"$f":"Actuals!J46","v":0},{"$f":"Actuals!K46","v":0},{"$f":"Actuals!L46","v":0},{"$f":"Actuals!M46","v":0},{"$f":"Actuals!N46","v":0}]
["CALC ROW - Exp as Negative","Expenditure",{"$f":"-C11","v":0},{"$f":"-D11","v":0},0,0,0,0,0,0,0,0,0,0]
["CALC ROW - Net CF","Net Cashflow",{"$f":"C10-C11","v":0},{"$f":"D10-D11","v":0},0,0,0,0,0,0,0,0,0,0]
{"$rows_empty":21}
[null,null,null,"Xlteq the Excel Spreadsheet and Access Database Experts"]
[]
[null,null,null,"020 3817 6945",null,"*","info@xlteq.com",null,"*","www.xlteq.com"]