{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["What is a Cash flow","Completing this document","Current Rates","STAFF RATES","Staff Salaries","Workings to Cash flow","CASH FLOW YR 1","CASH FLOW YR 2","CASH FLOW YR 3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"What is a Cash flow","index":0,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[[9,3,9,9]]}
["What is a cash flow forecast?"]
["This is the process of estimating the flow of cash in and out of your business over a specific period of time"]
["Why is it helpful?"]
["It is important to know how much cash you will have in the business at any one time. A cash flow spreadsheet allows you to enter all your income (money that you receive) and expenditure (money that you pay out) for a 12 month period (or financial year). The result of this (income minus expenditure) will indicate whether your business will either break even (you made enough just to cover your expenditure), make a profit/surplus (your income is more than your expenditure) or a loss/deficit (your income is less than your expenditure)."]
["A cash flow can also help to:"]
["•   plan ahead for the coming years– are any projects being planned now or in the future? \n•   be aware of where your business stands financially\n•   access additional funding\n•  allow you to anticipate short falls - the clear, completed document will help you identify peaks and drops (i.e. if parental fees drop, this may indicate a reduction in child attendance and vice versa) With this information you can then take the steps needed to rectify the situation before it becomes a serious problem. This may mean allocating additional resources to marketing your service etc and budgeting for this. \n\n\n"]

{"sheet":"Completing this document","index":1,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,3,2,9]]}
["Useful tips for using this cash flow template"]
[]
["If you are applying for ECC funding you will need to complete 3 years cashflow forecast"]
["The compulsary cells to complete are highlighted in blue, however all cells can be overwritten if appropriate"]
["Once tab ‘STAFF RATES’ has been completed, it will pull through the figures into tab ‘Staff Salaries’. "]
["It will automatically calculate the staff costs for the year and give you a break down of this per month."]
["Once checked, and you feel that this is correct to the best of your knowledge, you can move on to tab  'Workings to Cash flow'"]
["The information above will automatically be pulled into the ‘wages and salaries’ section and will also estimate holiday cover and staff training costs."]
["This method works if you pay your staff the same amount each month.  If the amount your staff are paid varies each month based on the number of hours worked, you will need to overwrite the formula on the tab 'Cash flow’ with your actual numbers for each month. "]
["NB:  Where figures are automatically entered that are not appropriate to your business you can overwrite the formula "]
["Select the appropriate cell(s), the cell you would like to alter should now have a black border around it. Now enter the figure that is realistic to your business. "]
["Complete the rest of the ‘Cash flow’ as normal. Refer to tips"]
["To complete your cash flow, you must enter your opening balance. If this is not entered your cash flow will be deemed as incomplete"]
[]
["If you would like advice or need guidance with completing your cash flow forecast or additionally need advice, guidance and support for any other business need, please email"]
["Early Years and Childcare Business Management Consultants Team:"]
["Rosemary Newell - Mid Quadrant - email: Rosemary.newell@essex.gov.uk"]
["Caroline Brown - South Quadrant - email: Caroline.brown@essex.gov.uk"]
["Alan Haylock - North East Quadrant - email: Alan.haylock@essex.gov.uk "]
["Carmen Saunders - West Quadrant - email: Carmen.Saunders@essex.gov.uk "]

{"sheet":"Current Rates","index":2,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Information needed prior to completing cashflow","Rates from April 2024"]
[]
["Please check relevant PAYE and NIC rates",null,"Check details on www.gov.uk"]
[]
["Please check National Minimum Wage",null,"Check details on www.gov.uk"]
[]
["Refer to pension regulator for relevant pension information",null,"https://www.thepensionsregulator.gov.uk/"]
[]
["For wraparound please check school holiday term dates",null,"With relevant school"]
[]
["FEEE Rates for each age category "]
["Please ensure parents/carers meet eligibility criteria"]
["FEEE1W",10.73,"Refer to your Essex Provider handbook for current rates"]
["FEEE2",8,"Refer to your Essex Provider handbook for current rates"]
["FEEE2W",7.85,"Refer to your Essex Provider handbook for current rates"]
["FEEE 3 - 4",5.23,"Refer to your Essex Provider handbook for current rates"]
[]
["Please reflect correct timings of FEEE income throughout your cash flow."]

{"sheet":"STAFF RATES","index":3,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,1,6,4],[2,1,2,8],[2,9,2,12],[4,1,4,8]]}
[]
[]
[null,"Setting Name: ",null,null,null,null,null,null,null,"Date Form Completed"]
[]
[null,"Staff Salary Rates "]
[null,null,null,null,null,null,null,null,"Please insert Pension Rate"]
[null,"Please complete all the white boxes below for each position that you have ",null,null,null,null,null,null,"Pension Rate",0]
[]
[null,"Staff Roles                    The headings below can be amended","Hourly Rate","No hours Per Week","No weeks Per Year","Annual  salary","National Insurance","Pension YES / NO","Pension","Staff Costs per Person",null,"No of staff",null,"Total Staff Costs"]
[]
[null,"Manager or Overtype",null,null,null,{"$f":"C11*D11*E11","v":0},{"$f":"IF(F11>9100,(F11-9100)*0.138,0)","v":0},null,{"$f":"IF(H11=\"yes\",F11*$J$7,0)","v":0},{"$f":"F11+G11+I11","v":0},null,null,null,{"$f":"J11*L11","v":0}]
[]
[null,"Assistant Manager",null,null,null,{"$f":"C13*D13*E13","v":0},{"$f":"IF(F13>9100,(F13-9100)*0.138,0)","v":0},null,{"$f":"IF(H13=\"yes\",F13*$J$7,0)","v":0},{"$f":"F13+G13+I13","v":0},null,null,null,{"$f":"J13*L13","v":0}]
[]
[null,"Early Years Practitioner",null,null,null,{"$f":"C15*D15*E15","v":0},0,null,0,{"$f":"F15+G15+I15","v":0},null,null,null,{"$f":"J15*L15","v":0}]
[]
[null,"Early Years Practitioner",null,null,null,{"$f":"C17*D17*E17","v":0},0,null,0,{"$f":"F17+G17+I17","v":0},null,null,null,{"$f":"J17*L17","v":0}]
[]
[null,"Early Years Practitioner",null,null,null,{"$f":"C19*D19*E19","v":0},0,null,0,{"$f":"F19+G19+I19","v":0},null,null,null,{"$f":"J19*L19","v":0}]
[]
[null,"Wraparound Practitioner",null,null,null,{"$f":"C21*D21*E21","v":0},0,null,0,{"$f":"F21+G21+I21","v":0},null,null,null,{"$f":"J21*L21","v":0}]
[]
[null,"Wraparound Practitioner",null,null,null,{"$f":"C23*D23*E23","v":0},0,null,0,{"$f":"F23+G23+I23","v":0},null,null,null,{"$f":"J23*L23","v":0}]

{"sheet":"Staff Salaries","index":4,"n_rows":27,"n_cols":16,"rows_kept":27,"cut":false,"hidden":false,"merged":[[6,1,6,7],[6,8,6,12],[26,12,26,13],[2,1,2,8],[2,11,2,12],[2,13,2,15],[4,1,4,8]]}
[]
[]
[null,{"$f":"'STAFF RATES'!B3","v":"Setting Name: "},null,null,null,null,null,null,null,null,null,"Date Form Completed",null,{"$f":"'STAFF RATES'!N3","v":"00:00:00"}]
[]
[null,"Staff Salaries"]
[]
[null,"ALL OF THESE FIGURES ARE CARRIED FORWARD FROM THE STAFF RATES PAGE"]
[]
[null,null,"Month 1 - overtype","Month 2 - overtype","Month 3 - overtype","Month 4 - overtype","Month 5 - overtype","Month 6 - overtype","Month 7 - overtype","Month 8 - overtype","Month 9 - overtype","Month 10 - overtype","Month 11 - overtype","Month 12 - overtype",null,"Total Staff Costs"]
[]
[null,"Manager or Overtype",{"$f":"'STAFF RATES'!$N$11/12","v":0},{"$f":"'STAFF RATES'!$N$11/12","v":0},{"$f":"'STAFF RATES'!$N$11/12","v":0},{"$f":"'STAFF RATES'!$N$11/12","v":0},{"$f":"'STAFF RATES'!$N$11/12","v":0},{"$f":"'STAFF RATES'!$N$11/12","v":0},{"$f":"'STAFF RATES'!$N$11/12","v":0},{"$f":"'STAFF RATES'!$N$11/12","v":0},{"$f":"'STAFF RATES'!$N$11/12","v":0},{"$f":"'STAFF RATES'!$N$11/12","v":0},{"$f":"'STAFF RATES'!$N$11/12","v":0},{"$f":"'STAFF RATES'!$N$11/12","v":0},null,{"$f":"SUM(C11:O11)","v":0}]
[]
[null,{"$f":"'STAFF RATES'!B13","v":"Assistant Manager"},{"$f":"'STAFF RATES'!$N$13/12","v":0},{"$f":"'STAFF RATES'!$N$13/12","v":0},{"$f":"'STAFF RATES'!$N$13/12","v":0},{"$f":"'STAFF RATES'!$N$13/12","v":0},{"$f":"'STAFF RATES'!$N$13/12","v":0},{"$f":"'STAFF RATES'!$N$13/12","v":0},{"$f":"'STAFF RATES'!$N$13/12","v":0},{"$f":"'STAFF RATES'!$N$13/12","v":0},{"$f":"'STAFF RATES'!$N$13/12","v":0},{"$f":"'STAFF RATES'!$N$13/12","v":0},{"$f":"'STAFF RATES'!$N$13/12","v":0},{"$f":"'STAFF RATES'!$N$13/12","v":0},null,{"$f":"SUM(C13:O13)","v":0}]
[]
[null,{"$f":"'STAFF RATES'!B15","v":"Early Years Practitioner"},{"$f":"'STAFF RATES'!$N$15/12","v":0},{"$f":"'STAFF RATES'!$N$15/12","v":0},{"$f":"'STAFF RATES'!$N$15/12","v":0},{"$f":"'STAFF RATES'!$N$15/12","v":0},{"$f":"'STAFF RATES'!$N$15/12","v":0},{"$f":"'STAFF RATES'!$N$15/12","v":0},{"$f":"'STAFF RATES'!$N$15/12","v":0},{"$f":"'STAFF RATES'!$N$15/12","v":0},{"$f":"'STAFF RATES'!$N$15/12","v":0},{"$f":"'STAFF RATES'!$N$15/12","v":0},{"$f":"'STAFF RATES'!$N$15/12","v":0},{"$f":"'STAFF RATES'!$N$15/12","v":0},null,{"$f":"SUM(C15:O15)","v":0}]
[]
[null,{"$f":"'STAFF RATES'!B17","v":"Early Years Practitioner"},{"$f":"'STAFF RATES'!$N$17/12","v":0},{"$f":"'STAFF RATES'!$N$17/12","v":0},{"$f":"'STAFF RATES'!$N$17/12","v":0},{"$f":"'STAFF RATES'!$N$17/12","v":0},{"$f":"'STAFF RATES'!$N$17/12","v":0},{"$f":"'STAFF RATES'!$N$17/12","v":0},{"$f":"'STAFF RATES'!$N$17/12","v":0},{"$f":"'STAFF RATES'!$N$17/12","v":0},{"$f":"'STAFF RATES'!$N$17/12","v":0},{"$f":"'STAFF RATES'!$N$17/12","v":0},{"$f":"'STAFF RATES'!$N$17/12","v":0},{"$f":"'STAFF RATES'!$N$17/12","v":0},null,{"$f":"SUM(C17:O17)","v":0}]
[]
[null,{"$f":"'STAFF RATES'!B19","v":"Early Years Practitioner"},{"$f":"'STAFF RATES'!$N$19/12","v":0},{"$f":"'STAFF RATES'!$N$19/12","v":0},{"$f":"'STAFF RATES'!$N$19/12","v":0},{"$f":"'STAFF RATES'!$N$19/12","v":0},{"$f":"'STAFF RATES'!$N$19/12","v":0},{"$f":"'STAFF RATES'!$N$19/12","v":0},{"$f":"'STAFF RATES'!$N$19/12","v":0},{"$f":"'STAFF RATES'!$N$19/12","v":0},{"$f":"'STAFF RATES'!$N$19/12","v":0},{"$f":"'STAFF RATES'!$N$19/12","v":0},{"$f":"'STAFF RATES'!$N$19/12","v":0},{"$f":"'STAFF RATES'!$N$19/12","v":0},null,{"$f":"SUM(C19:O19)","v":0}]
[]
[null,{"$f":"'STAFF RATES'!B21","v":"Wraparound Practitioner"},{"$f":"'STAFF RATES'!$N$21/12","v":0},{"$f":"'STAFF RATES'!$N$21/12","v":0},{"$f":"'STAFF RATES'!$N$21/12","v":0},{"$f":"'STAFF RATES'!$N$21/12","v":0},{"$f":"'STAFF RATES'!$N$21/12","v":0},{"$f":"'STAFF RATES'!$N$21/12","v":0},{"$f":"'STAFF RATES'!$N$21/12","v":0},{"$f":"'STAFF RATES'!$N$21/12","v":0},{"$f":"'STAFF RATES'!$N$21/12","v":0},{"$f":"'STAFF RATES'!$N$21/12","v":0},{"$f":"'STAFF RATES'!$N$21/12","v":0},{"$f":"'STAFF RATES'!$N$21/12","v":0},null,{"$f":"SUM(C21:O21)","v":0}]
[]
[null,{"$f":"'STAFF RATES'!B23","v":"Wraparound Practitioner"},{"$f":"'STAFF RATES'!$N$23/12","v":0},{"$f":"'STAFF RATES'!$N$23/12","v":0},{"$f":"'STAFF RATES'!$N$23/12","v":0},{"$f":"'STAFF RATES'!$N$23/12","v":0},{"$f":"'STAFF RATES'!$N$23/12","v":0},{"$f":"'STAFF RATES'!$N$23/12","v":0},{"$f":"'STAFF RATES'!$N$23/12","v":0},{"$f":"'STAFF RATES'!$N$23/12","v":0},{"$f":"'STAFF RATES'!$N$23/12","v":0},{"$f":"'STAFF RATES'!$N$23/12","v":0},{"$f":"'STAFF RATES'!$N$23/12","v":0},{"$f":"'STAFF RATES'!$N$23/12","v":0},null,{"$f":"SUM(C23:O23)","v":0}]
[]
[null,"TOTAL PER MONTH",{"$f":"SUM(C11:C24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total staff cost                        (Fully Staffed Year 1)",null,null,{"$f":"P25","v":0}]

{"sheet":"Workings to Cash flow","index":5,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Key considerations prior to calculating your income - WORKINGS ONLY"]
[null,"This sheet does not calculate through to the cashflow but you can use it to think about different income streams"]
[null,"Number of registered children"]
[]
[null,"Think about your breakeven point"]
[null,"Weekly Cost = Total annual expenditure divided by Number of weeks open"]
[null,"How many hours you have per week = Hours per day x Days open per week x Registered places"]
[null,"Charge per hour to breakeven = weekly expenditure divided by realistic hours occupied "]
[null,"Number of hours that need to be sold divided by hours per day divided by days open = number of children needed to breakeven"]
[]
[null,"Additional Charges"]
[null,"If you will be charging additional charges please ensure they are relevant to the needs of the child."]
[]
[null,"Income Breakdown for Early Years"]
[null,null,"Rates per hour","Number of children per hour","Number of Hours per week","Fees per week"]
[null,"Private Fees",null,null,null,{"$f":"C16*D16*E16","v":0}]
[null,"FEEE1W",null,null,null,{"$f":"C17*D17*E17","v":0}]
[null,"FEEE2",null,null,null,0]
[null,"FEEE2W",null,null,null,0]
[null,"FEEE3-4",null,null,null,0]
[null,"*SENIF",null,null,null,0]
[null,"*EYPP",null,null,null,0]
[null,"*DAF",null,null,null,0]
[null,"Total",null,null,null,{"$f":"SUM(F16:F23)","v":0}]
[null,"*If applicable"]

{"sheet":"CASH FLOW YR 1","index":6,"n_rows":103,"n_cols":19,"rows_kept":103,"cut":false,"hidden":false,"merged":[[82,16,82,17],[82,1,82,5],[82,9,82,15],[82,7,82,8],[2,7,2,8],[12,7,12,15],[8,1,9,1],[2,13,4,18],[6,3,6,17],[4,3,4,10],[2,3,2,5],[4,1,6,1]]}
[" "]
[]
[null,null,null,"Date completed",null,null,null,null,null,null,null,null,null,"Cashflow Forecast"]
[]
[null,{"$f":"IF(B9=0, \"Please select the year using the drop down menu below\", \"\")","v":""},null,{"$f":"'Staff Salaries'!B3","v":"Setting Name: "}]
[]
[null,null,null,"Only complete the white boxes below which apply to your setting.  Whilst this is only a forecast of income and expenditure, When completing the figures, please try to be as accurate as possible about the amount of income you expect to receive and when it is due, and also the amounts of expenditure and when they are due to go out."]
[]
[null,"YEAR 1",null,"Month 1","Month 2","Month 3",null,"Month 4","Month 5","Month 6",null,"Month 7","Month 8","Month 9",null,"Month 10","Month 11","Month 12","Totals"]
[null,null,null,{"$f":"'Staff Salaries'!C9","v":"Month 1 - overtype"},{"$f":"'Staff Salaries'!D9","v":"Month 2 - overtype"},{"$f":"'Staff Salaries'!E9","v":"Month 3 - overtype"},null,{"$f":"'Staff Salaries'!F9","v":"Month 4 - overtype"},{"$f":"'Staff Salaries'!G9","v":"Month 5 - overtype"},{"$f":"'Staff Salaries'!H9","v":"Month 6 - overtype"},null,{"$f":"'Staff Salaries'!I9","v":"Month 7 - overtype"},{"$f":"'Staff Salaries'!J9","v":"Month 8 - overtype"},{"$f":"'Staff Salaries'!K9","v":"Month 9 - overtype"},null,{"$f":"'Staff Salaries'!L9","v":"Month 10 - overtype"},{"$f":"'Staff Salaries'!M9","v":"Month 11 - overtype"},{"$f":"'Staff Salaries'!N9","v":"Month 12 - overtype"}]
[]
[]
[null,"Income",null,"Text can be changed",null,null,null,"PLEASE ENTER FIGURES IN WHITE BOXES ONLY "]
[]
[null,"FEEE1W ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D15:R15)","v":0}]
[null,"FEEE2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D16:R16)","v":0}]
[null,"FEEE2W",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"FEEE 3 - 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"*SENIF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"*EYPP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"*DAF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Capital ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Fees From Parents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D23:R23)","v":0}]
[null,"Local Authority Grants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D24:R24)","v":0}]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"TOTAL INCOME ",null,{"$f":"SUM(D15:D28)","v":0},{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},null,{"$f":"SUM(H15:H28)","v":0},{"$f":"SUM(I15:I28)","v":0},{"$f":"SUM(J15:J28)","v":0},null,{"$f":"SUM(L15:L28)","v":0},{"$f":"SUM(M15:M28)","v":0},{"$f":"SUM(N15:N28)","v":0},null,{"$f":"SUM(P15:P28)","v":0},{"$f":"SUM(Q15:Q28)","v":0},{"$f":"SUM(R15:R28)","v":0},{"$f":"SUM(S15:S28)","v":0}]
[]
[null,"Expenditure"]
[]
[null,"Wages & Salaries",null,{"$f":"'Staff Salaries'!C25","v":0},{"$f":"'Staff Salaries'!D25","v":0},{"$f":"'Staff Salaries'!E25","v":0},null,{"$f":"'Staff Salaries'!F25","v":0},{"$f":"'Staff Salaries'!G25","v":0},{"$f":"'Staff Salaries'!H25","v":0},null,{"$f":"'Staff Salaries'!I25","v":0},{"$f":"'Staff Salaries'!J25","v":0},{"$f":"'Staff Salaries'!K25","v":0},null,{"$f":"'Staff Salaries'!L25","v":0},{"$f":"'Staff Salaries'!M25","v":0},{"$f":"'Staff Salaries'!N25","v":0},{"$f":"SUM(D34:R34)","v":0}]
[null,"Holiday Cover @ 5%",null,{"$f":"D34/100*5","v":0},{"$f":"E34/100*5","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,0]
[null,"Staff  Training @ 1.5%",null,{"$f":"D34/100*1.5","v":0},{"$f":"E34/100*1.5","v":0},{"$f":"F34/100*1.5","v":0},null,{"$f":"H34/100*1.5","v":0},{"$f":"I34/100*1.5","v":0},{"$f":"J34/100*1.5","v":0},null,{"$f":"L34/100*1.5","v":0},{"$f":"M34/100*1.5","v":0},{"$f":"N34/100*1.5","v":0},null,{"$f":"P34/100*1.5","v":0},{"$f":"Q34/100*1.5","v":0},{"$f":"R34/100*1.5","v":0},0]
[null,"Other ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Staff Costs",null,{"$f":"SUM(D34:D37)","v":0},{"$f":"SUM(E34:E37)","v":0},{"$f":"SUM(F34:F37)","v":0},null,{"$f":"SUM(H34:H37)","v":0},{"$f":"SUM(I34:I37)","v":0},{"$f":"SUM(J34:J37)","v":0},null,{"$f":"SUM(L34:L37)","v":0},{"$f":"SUM(M34:M37)","v":0},{"$f":"SUM(N34:N37)","v":0},null,{"$f":"SUM(P34:P37)","v":0},{"$f":"SUM(Q34:Q37)","v":0},{"$f":"SUM(R34:R37)","v":0},{"$f":"SUM(S34:S37)","v":0}]
[null,"Rent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D39:R39)","v":0}]
[null,"Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Electricity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Gas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Business Rates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Water",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Cleaning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Premises",null,{"$f":"SUM(D39:D47)","v":0},{"$f":"SUM(E39:E47)","v":0},{"$f":"SUM(F39:F47)","v":0},null,{"$f":"SUM(H39:H47)","v":0},{"$f":"SUM(I39:I47)","v":0},{"$f":"SUM(J39:J47)","v":0},null,{"$f":"SUM(L39:L47)","v":0},{"$f":"SUM(M39:M47)","v":0},{"$f":"SUM(N39:N47)","v":0},null,{"$f":"SUM(P39:P47)","v":0},{"$f":"SUM(Q39:Q47)","v":0},{"$f":"SUM(R39:R47)","v":0},{"$f":"SUM(S39:S47)","v":0}]
[null,"Building Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:R49)","v":0}]
[null,"Contents Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D50:R50)","v":0}]
[null,"Employment Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D51:R51)","v":0}]
[null,"Total Insurance",null,{"$f":"SUM(D49:D51)","v":0},{"$f":"SUM(E49:E51)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S49:S51)","v":0}]
[]
[null,"Administration Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D54:R54)","v":0}]
[null,"Membership Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Bank Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Professional Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Subscriptions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Administration",null,{"$f":"SUM(D54:D60)","v":0},{"$f":"SUM(E54:E60)","v":0},{"$f":"SUM(F54:F60)","v":0},null,{"$f":"SUM(H54:H60)","v":0},{"$f":"SUM(I54:I60)","v":0},{"$f":"SUM(J54:J60)","v":0},null,{"$f":"SUM(L54:L60)","v":0},{"$f":"SUM(M54:M60)","v":0},{"$f":"SUM(N54:N60)","v":0},null,{"$f":"SUM(P54:P60)","v":0},{"$f":"SUM(Q54:Q60)","v":0},{"$f":"SUM(R54:R60)","v":0},{"$f":"SUM(S54:S60)","v":0}]
[null,"Consumables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D62:R62)","v":0}]
[null,"Visits & Trips out ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Catering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Misc / Sundries",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Repairs & renewals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Activity & Material Costs",null,{"$f":"SUM(D62:D67)","v":0},{"$f":"SUM(E62:E67)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S62:S67)","v":0}]
[null,"Advertising / Promotions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D69:R69)","v":0}]
[null,"Market Research",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D70:R70)","v":0}]
[null,"Total Advertising",null,{"$f":"SUM(D69:D70)","v":0},{"$f":"SUM(E69:E70)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S69:S70)","v":0}]
[null,"Capital Expenditure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D72:R72)","v":0}]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,{"$f":"SUM(D72:D74)","v":0},{"$f":"SUM(E72:E74)","v":0},{"$f":"SUM(F72:F74)","v":0},null,{"$f":"SUM(H72:H74)","v":0},{"$f":"SUM(I72:I74)","v":0},{"$f":"SUM(J72:J74)","v":0},null,{"$f":"SUM(L72:L74)","v":0},{"$f":"SUM(M72:M74)","v":0},{"$f":"SUM(N72:N74)","v":0},null,{"$f":"SUM(P72:P74)","v":0},{"$f":"SUM(Q72:Q74)","v":0},{"$f":"SUM(R72:R74)","v":0},{"$f":"SUM(S72:S74)","v":0}]
[null,"TOTAL REVENUE EXPENDITURE",null,{"$f":"D38+D48+D52+D61+D68+D71+D75","v":0},0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Opening balance",null,null,{"$f":"D81","v":0},{"$f":"E81","v":0},null,{"$f":"F81","v":0},0,0,null,{"$f":"J81","v":0},0,0,null,{"$f":"N81","v":0},0,0,{"$f":"R81","v":0}]
[null,"Total Income",null,{"$f":"D30","v":0},{"$f":"E30","v":0},{"$f":"F30","v":0},null,{"$f":"H30","v":0},{"$f":"I30","v":0},{"$f":"J30","v":0},null,{"$f":"L30","v":0},{"$f":"M30","v":0},{"$f":"N30","v":0},null,{"$f":"P30","v":0},{"$f":"Q30","v":0},{"$f":"R30","v":0},{"$f":"SUM(D79:R79)","v":0}]
[null,"Total Expenditure",null,{"$f":"D76","v":0},{"$f":"E76","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(D80:R80)","v":0}]
[null,"Closing balance",null,{"$f":"D78+D79-D80","v":0},0,0,null,0,0,0,null,0,0,0,null,0,0,{"$f":"R78+R79-R80","v":0}]
[]
[null,{"$f":"IF(D78=0,\"PLEASE ENTER OPENING BALANCE\",\"OPENING BALANCE OK\")","v":"PLEASE ENTER OPENING BALANCE"},null,null,null,null,null,{"$f":"IF(Q83=\"LOSS\",\"WARNING\",\"GOOD NEWS\")","v":"GOOD NEWS"},null,"The cashflow forecast is currently indicating that you will make a",null,null,null,null,null,null,{"$f":"IF(S83<0,\"LOSS\",IF(S83>0,\"PROFIT\",IF(S83=0,\"BREAK EVEN\")))","v":"BREAK EVEN"},{"$f":"IF(S80>S79,\"LOSS\",IF(S80<S79,\"PROFIT\",IF(S80=S79,\"BREAK EVEN\")))","v":"BREAK EVEN"},{"$f":"S79-S80","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Year 1"]
[null,"Year 2"]
[null,"Year 3"]
[null,"Year 4"]
[null,"Year 5"]
[null,"Year 6"]
[null,"Year 7"]
[null,"Year 8"]
[null,"Year 9"]
[null,"Year 10"]

{"sheet":"CASH FLOW YR 2","index":7,"n_rows":103,"n_cols":19,"rows_kept":103,"cut":false,"hidden":false,"merged":[[82,16,82,17],[2,3,2,5],[2,7,2,8],[2,13,4,18],[4,1,6,1],[4,3,4,10],[6,3,6,17],[8,1,9,1],[12,7,12,15],[82,1,82,5],[82,7,82,8],[82,9,82,15]]}
[]
[]
[null,null,null,"Date completed",null,null,null,{"$f":"'Staff Salaries'!N3","v":"00:00:00"},null,null,null,null,null,"Cashflow Forecast"]
[]
[null,{"$f":"IF(B9=0, \"Please select the year using the drop down menu below\", \"\")","v":""},null,{"$f":"'Staff Salaries'!B3","v":"Setting Name: "}]
[]
[null,null,null,"Only complete the white boxes below which apply to your setting.  Whilst this is only a forecast of income and expenditure, When completing the figures, please try to be as accurate as possible about the amount of income you expect to receive and when it is due, and also the amounts of expenditure and when they are due to go out."]
[]
[null,"YEAR 1",null,"Month 1","Month 2","Month 3",null,"Month 4","Month 5","Month 6",null,"Month 7","Month 8","Month 9",null,"Month 10","Month 11","Month 12","Totals"]
[null,null,null,{"$f":"'CASH FLOW YR 1'!D10","v":"Month 1 - overtype"},{"$f":"'CASH FLOW YR 1'!E10","v":"Month 2 - overtype"},{"$f":"'CASH FLOW YR 1'!F10","v":"Month 3 - overtype"},null,{"$f":"'CASH FLOW YR 1'!H10","v":"Month 4 - overtype"},{"$f":"'CASH FLOW YR 1'!I10","v":"Month 5 - overtype"},{"$f":"'CASH FLOW YR 1'!J10","v":"Month 6 - overtype"},null,{"$f":"'CASH FLOW YR 1'!L10","v":"Month 7 - overtype"},{"$f":"'CASH FLOW YR 1'!M10","v":"Month 8 - overtype"},{"$f":"'CASH FLOW YR 1'!N10","v":"Month 9 - overtype"},null,{"$f":"'CASH FLOW YR 1'!P10","v":"Month 10 - overtype"},{"$f":"'CASH FLOW YR 1'!Q10","v":"Month 11 - overtype"},{"$f":"'CASH FLOW YR 1'!R10","v":"Month 12 - overtype"}]
[]
[]
[null,"Income",null,null,"Text can be changed",null,null,"PLEASE ENTER FIGURES IN WHITE BOXES ONLY "]
[]
[null,"FEEE1W",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D15:R15)","v":0}]
[null,"FEEE2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"FEEE2W",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"FEEE 3 - 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"*SENIF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"*EYPP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"*DAF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Capital ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Fees From parents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Local Authority Grants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D28:R28)","v":0}]
[]
[null,"TOTAL INCOME ",null,{"$f":"SUM(D15:D28)","v":0},{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},null,{"$f":"SUM(H15:H28)","v":0},{"$f":"SUM(I15:I28)","v":0},{"$f":"SUM(J15:J28)","v":0},null,{"$f":"SUM(L15:L28)","v":0},{"$f":"SUM(M15:M28)","v":0},{"$f":"SUM(N15:N28)","v":0},null,{"$f":"SUM(P15:P28)","v":0},{"$f":"SUM(Q15:Q28)","v":0},{"$f":"SUM(R15:R28)","v":0},{"$f":"SUM(S15:S28)","v":0}]
[]
[null,"Expenditure"]
[]
[null,"Wages & Salaries",null,{"$f":"'Staff Salaries'!C25","v":0},{"$f":"'Staff Salaries'!D25","v":0},{"$f":"'Staff Salaries'!E25","v":0},null,{"$f":"'Staff Salaries'!F25","v":0},{"$f":"'Staff Salaries'!G25","v":0},{"$f":"'Staff Salaries'!H25","v":0},null,{"$f":"'Staff Salaries'!I25","v":0},{"$f":"'Staff Salaries'!J25","v":0},{"$f":"'Staff Salaries'!K25","v":0},null,{"$f":"'Staff Salaries'!L25","v":0},{"$f":"'Staff Salaries'!M25","v":0},{"$f":"'Staff Salaries'!N25","v":0},{"$f":"SUM(D34:R34)","v":0}]
[null,"Holiday Cover @ 5%",null,{"$f":"D34/100*5","v":0},{"$f":"E34/100*5","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,0]
[null,"Staff  Training @ 1.5%",null,{"$f":"D34/100*1.5","v":0},{"$f":"E34/100*1.5","v":0},{"$f":"F34/100*1.5","v":0},null,{"$f":"H34/100*1.5","v":0},{"$f":"I34/100*1.5","v":0},{"$f":"J34/100*1.5","v":0},null,{"$f":"L34/100*1.5","v":0},{"$f":"M34/100*1.5","v":0},{"$f":"N34/100*1.5","v":0},null,{"$f":"P34/100*1.5","v":0},{"$f":"Q34/100*1.5","v":0},{"$f":"R34/100*1.5","v":0},0]
[null,"Other ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Staff Costs",null,{"$f":"SUM(D34:D37)","v":0},{"$f":"SUM(E34:E37)","v":0},{"$f":"SUM(F34:F37)","v":0},null,{"$f":"SUM(H34:H37)","v":0},{"$f":"SUM(I34:I37)","v":0},{"$f":"SUM(J34:J37)","v":0},null,{"$f":"SUM(L34:L37)","v":0},{"$f":"SUM(M34:M37)","v":0},{"$f":"SUM(N34:N37)","v":0},null,{"$f":"SUM(P34:P37)","v":0},{"$f":"SUM(Q34:Q37)","v":0},{"$f":"SUM(R34:R37)","v":0},{"$f":"SUM(S34:S37)","v":0}]
[null,"Rent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D39:R39)","v":0}]
[null,"Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Electricity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Gas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Business Rates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Water",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Cleaning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Premises",null,{"$f":"SUM(D39:D47)","v":0},{"$f":"SUM(E39:E47)","v":0},{"$f":"SUM(F39:F47)","v":0},null,{"$f":"SUM(H39:H47)","v":0},{"$f":"SUM(I39:I47)","v":0},{"$f":"SUM(J39:J47)","v":0},null,{"$f":"SUM(L39:L47)","v":0},{"$f":"SUM(M39:M47)","v":0},{"$f":"SUM(N39:N47)","v":0},null,{"$f":"SUM(P39:P47)","v":0},{"$f":"SUM(Q39:Q47)","v":0},{"$f":"SUM(R39:R47)","v":0},{"$f":"SUM(S39:S47)","v":0}]
[null,"Building Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:R49)","v":0}]
[null,"Contents Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D50:R50)","v":0}]
[null,"Employment Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D51:R51)","v":0}]
[null,"Total Insurance",null,{"$f":"SUM(D49:D51)","v":0},{"$f":"SUM(E49:E51)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S49:S51)","v":0}]
[]
[null,"Administration Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D54:R54)","v":0}]
[null,"Membership Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Bank Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Professional Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Subscriptions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Administration",null,{"$f":"SUM(D54:D60)","v":0},{"$f":"SUM(E54:E60)","v":0},{"$f":"SUM(F54:F60)","v":0},null,{"$f":"SUM(H54:H60)","v":0},{"$f":"SUM(I54:I60)","v":0},{"$f":"SUM(J54:J60)","v":0},null,{"$f":"SUM(L54:L60)","v":0},{"$f":"SUM(M54:M60)","v":0},{"$f":"SUM(N54:N60)","v":0},null,{"$f":"SUM(P54:P60)","v":0},{"$f":"SUM(Q54:Q60)","v":0},{"$f":"SUM(R54:R60)","v":0},{"$f":"SUM(S54:S60)","v":0}]
[null,"Consumables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D62:R62)","v":0}]
[null,"Visits & Trips out ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Catering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Misc / Sundries",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Repairs & renewals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Activity & Material Costs",null,{"$f":"SUM(D62:D67)","v":0},{"$f":"SUM(E62:E67)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S62:S67)","v":0}]
[null,"Advertising / Promotions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D69:R69)","v":0}]
[null,"Market Research",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D70:R70)","v":0}]
[null,"Total Advertising",null,{"$f":"SUM(D69:D70)","v":0},{"$f":"SUM(E69:E70)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S69:S70)","v":0}]
[null,"Capital Expenditure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D72:R72)","v":0}]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,{"$f":"SUM(D72:D74)","v":0},{"$f":"SUM(E72:E74)","v":0},{"$f":"SUM(F72:F74)","v":0},null,{"$f":"SUM(H72:H74)","v":0},{"$f":"SUM(I72:I74)","v":0},{"$f":"SUM(J72:J74)","v":0},null,{"$f":"SUM(L72:L74)","v":0},{"$f":"SUM(M72:M74)","v":0},{"$f":"SUM(N72:N74)","v":0},null,{"$f":"SUM(P72:P74)","v":0},{"$f":"SUM(Q72:Q74)","v":0},{"$f":"SUM(R72:R74)","v":0},{"$f":"SUM(S72:S74)","v":0}]
[null,"TOTAL REVENUE EXPENDITURE",null,{"$f":"D38+D48+D52+D61+D68+D71+D75","v":0},0,{"$f":"F38+F48+F52+F61+F68+F71+F75","v":0},null,0,0,0,null,0,0,0,null,0,0,0,0]
[]
[null,"Opening balance",null,{"$f":"'CASH FLOW YR 1'!R81","v":0},{"$f":"D81","v":0},{"$f":"E81","v":0},null,{"$f":"F81","v":0},{"$f":"H81","v":0},0,null,{"$f":"J81","v":0},0,0,null,{"$f":"N81","v":0},0,0,{"$f":"R81","v":0}]
[null,"Total Income",null,{"$f":"D30","v":0},{"$f":"E30","v":0},{"$f":"F30","v":0},null,{"$f":"H30","v":0},{"$f":"I30","v":0},{"$f":"J30","v":0},null,{"$f":"L30","v":0},{"$f":"M30","v":0},{"$f":"N30","v":0},null,{"$f":"P30","v":0},{"$f":"Q30","v":0},{"$f":"R30","v":0},{"$f":"SUM(D79:R79)","v":0}]
[null,"Total Expenditure",null,{"$f":"D76","v":0},{"$f":"E76","v":0},{"$f":"F76","v":0},null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(D80:R80)","v":0}]
[null,"Closing balance",null,{"$f":"D78+D79-D80","v":0},0,{"$f":"F78+F79-F80","v":0},null,0,0,0,null,0,0,0,null,0,0,{"$f":"R78+R79-R80","v":0}]
[]
[null,"This figure should be your closing balance from Yr 1",null,null,null,null,null,{"$f":"IF(Q83=\"LOSS\",\"WARNING\",\"GOOD NEWS\")","v":"GOOD NEWS"},null,"The cashflow forecast is currently indicating that you will make a",null,null,null,null,null,null,{"$f":"IF(S83<0,\"LOSS\",IF(S83>0,\"PROFIT\",IF(S83=0,\"BREAK EVEN\")))","v":"BREAK EVEN"},{"$f":"IF(S80>S79,\"LOSS\",IF(S80<S79,\"PROFIT\",IF(S80=S79,\"BREAK EVEN\")))","v":"BREAK EVEN"},{"$f":"S79-S80","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Year 1"]
[null,"Year 2"]
[null,"Year 3"]
[null,"Year 4"]
[null,"Year 5"]
[null,"Year 6"]
[null,"Year 7"]
[null,"Year 8"]
[null,"Year 9"]
[null,"Year 10"]

{"sheet":"CASH FLOW YR 3","index":8,"n_rows":103,"n_cols":19,"rows_kept":103,"cut":false,"hidden":false,"merged":[[82,16,82,17],[2,3,2,5],[2,7,2,8],[2,13,4,18],[4,1,6,1],[4,3,4,10],[6,3,6,17],[8,1,9,1],[12,7,12,15],[82,1,82,5],[82,7,82,8],[82,9,82,15]]}
[]
[]
[null,null,null,"Date completed",null,null,null,{"$f":"'Staff Salaries'!N3","v":"00:00:00"},null,null,null,null,null,"Cashflow Forecast"]
[]
[null,{"$f":"IF(B9=0, \"Please select the year using the drop down menu below\", \"\")","v":""},null,{"$f":"'Staff Salaries'!B3","v":"Setting Name: "}]
[]
[null,null,null,"Only complete the white boxes below which apply to your setting.  Whilst this is only a forecast of income and expenditure, When completing the figures, please try to be as accurate as possible about the amount of income you expect to receive and when it is due, and also the amounts of expenditure and when they are due to go out."]
[]
[null,"YEAR 1",null,"Month 1","Month 2","Month 3",null,"Month 4","Month 5","Month 6",null,"Month 7","Month 8","Month 9",null,"Month 10","Month 11","Month 12","Totals"]
[null,null,null,{"$f":"'CASH FLOW YR 1'!D10","v":"Month 1 - overtype"},{"$f":"'CASH FLOW YR 1'!E10","v":"Month 2 - overtype"},{"$f":"'CASH FLOW YR 1'!F10","v":"Month 3 - overtype"},null,{"$f":"'CASH FLOW YR 1'!H10","v":"Month 4 - overtype"},{"$f":"'CASH FLOW YR 1'!I10","v":"Month 5 - overtype"},{"$f":"'CASH FLOW YR 1'!J10","v":"Month 6 - overtype"},null,{"$f":"'CASH FLOW YR 1'!L10","v":"Month 7 - overtype"},{"$f":"'CASH FLOW YR 1'!M10","v":"Month 8 - overtype"},{"$f":"'CASH FLOW YR 1'!N10","v":"Month 9 - overtype"},null,{"$f":"'CASH FLOW YR 1'!P10","v":"Month 10 - overtype"},{"$f":"'CASH FLOW YR 1'!Q10","v":"Month 11 - overtype"},{"$f":"'CASH FLOW YR 1'!R10","v":"Month 12 - overtype"}]
[]
[]
[null,"Income",null,null,"Text can be changed",null,null,"PLEASE ENTER FIGURES IN WHITE BOXES ONLY "]
[]
[null,"FEEE1W",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D15:R15)","v":0}]
[null,"FEEE2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"FEEE2W",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"FEEE 3 - 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"*SENIF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"*EYPP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"*DAF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Capital ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Fees From parents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Local Authority Grants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D28:R28)","v":0}]
[]
[null,"TOTAL INCOME ",null,{"$f":"SUM(D15:D28)","v":0},{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},null,{"$f":"SUM(H15:H28)","v":0},{"$f":"SUM(I15:I28)","v":0},{"$f":"SUM(J15:J28)","v":0},null,{"$f":"SUM(L15:L28)","v":0},{"$f":"SUM(M15:M28)","v":0},{"$f":"SUM(N15:N28)","v":0},null,{"$f":"SUM(P15:P28)","v":0},{"$f":"SUM(Q15:Q28)","v":0},{"$f":"SUM(R15:R28)","v":0},{"$f":"SUM(S15:S28)","v":0}]
[]
[null,"Expenditure"]
[]
[null,"Wages & Salaries",null,{"$f":"'Staff Salaries'!C25","v":0},{"$f":"'Staff Salaries'!D25","v":0},{"$f":"'Staff Salaries'!E25","v":0},null,{"$f":"'Staff Salaries'!F25","v":0},{"$f":"'Staff Salaries'!G25","v":0},{"$f":"'Staff Salaries'!H25","v":0},null,{"$f":"'Staff Salaries'!I25","v":0},{"$f":"'Staff Salaries'!J25","v":0},{"$f":"'Staff Salaries'!K25","v":0},null,{"$f":"'Staff Salaries'!L25","v":0},{"$f":"'Staff Salaries'!M25","v":0},{"$f":"'Staff Salaries'!N25","v":0},{"$f":"SUM(D34:R34)","v":0}]
[null,"Holiday Cover @ 5%",null,{"$f":"D34/100*5","v":0},{"$f":"E34/100*5","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,0]
[null,"Staff  Training @ 1.5%",null,{"$f":"D34/100*1.5","v":0},{"$f":"E34/100*1.5","v":0},{"$f":"F34/100*1.5","v":0},null,{"$f":"H34/100*1.5","v":0},{"$f":"I34/100*1.5","v":0},{"$f":"J34/100*1.5","v":0},null,{"$f":"L34/100*1.5","v":0},{"$f":"M34/100*1.5","v":0},{"$f":"N34/100*1.5","v":0},null,{"$f":"P34/100*1.5","v":0},{"$f":"Q34/100*1.5","v":0},{"$f":"R34/100*1.5","v":0},0]
[null,"Other ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Staff Costs",null,{"$f":"SUM(D34:D37)","v":0},{"$f":"SUM(E34:E37)","v":0},{"$f":"SUM(F34:F37)","v":0},null,{"$f":"SUM(H34:H37)","v":0},{"$f":"SUM(I34:I37)","v":0},{"$f":"SUM(J34:J37)","v":0},null,{"$f":"SUM(L34:L37)","v":0},{"$f":"SUM(M34:M37)","v":0},{"$f":"SUM(N34:N37)","v":0},null,{"$f":"SUM(P34:P37)","v":0},{"$f":"SUM(Q34:Q37)","v":0},{"$f":"SUM(R34:R37)","v":0},{"$f":"SUM(S34:S37)","v":0}]
[null,"Rent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D39:R39)","v":0}]
[null,"Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Electricity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Gas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Business Rates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Water",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Cleaning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Premises",null,{"$f":"SUM(D39:D47)","v":0},{"$f":"SUM(E39:E47)","v":0},{"$f":"SUM(F39:F47)","v":0},null,{"$f":"SUM(H39:H47)","v":0},{"$f":"SUM(I39:I47)","v":0},{"$f":"SUM(J39:J47)","v":0},null,{"$f":"SUM(L39:L47)","v":0},{"$f":"SUM(M39:M47)","v":0},{"$f":"SUM(N39:N47)","v":0},null,{"$f":"SUM(P39:P47)","v":0},{"$f":"SUM(Q39:Q47)","v":0},{"$f":"SUM(R39:R47)","v":0},{"$f":"SUM(S39:S47)","v":0}]
[null,"Building Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:R49)","v":0}]
[null,"Contents Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D50:R50)","v":0}]
[null,"Employment Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D51:R51)","v":0}]
[null,"Total Insurance",null,{"$f":"SUM(D49:D51)","v":0},{"$f":"SUM(E49:E51)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S49:S51)","v":0}]
[]
[null,"Administration Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D54:R54)","v":0}]
[null,"Membership Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Bank Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Professional Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Subscriptions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Administration",null,{"$f":"SUM(D54:D60)","v":0},{"$f":"SUM(E54:E60)","v":0},{"$f":"SUM(F54:F60)","v":0},null,{"$f":"SUM(H54:H60)","v":0},{"$f":"SUM(I54:I60)","v":0},{"$f":"SUM(J54:J60)","v":0},null,{"$f":"SUM(L54:L60)","v":0},{"$f":"SUM(M54:M60)","v":0},{"$f":"SUM(N54:N60)","v":0},null,{"$f":"SUM(P54:P60)","v":0},{"$f":"SUM(Q54:Q60)","v":0},{"$f":"SUM(R54:R60)","v":0},{"$f":"SUM(S54:S60)","v":0}]
[null,"Consumables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D62:R62)","v":0}]
[null,"Visits & Trips out ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Catering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Misc / Sundries",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Repairs & renewals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Activity & Material Costs",null,{"$f":"SUM(D62:D67)","v":0},{"$f":"SUM(E62:E67)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S62:S67)","v":0}]
[null,"Advertising / Promotions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D69:R69)","v":0}]
[null,"Market Research",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D70:R70)","v":0}]
[null,"Total Advertising",null,{"$f":"SUM(D69:D70)","v":0},{"$f":"SUM(E69:E70)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S69:S70)","v":0}]
[null,"Capital Expenditure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D72:R72)","v":0}]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,{"$f":"SUM(D72:D74)","v":0},{"$f":"SUM(E72:E74)","v":0},{"$f":"SUM(F72:F74)","v":0},null,{"$f":"SUM(H72:H74)","v":0},{"$f":"SUM(I72:I74)","v":0},{"$f":"SUM(J72:J74)","v":0},null,{"$f":"SUM(L72:L74)","v":0},{"$f":"SUM(M72:M74)","v":0},{"$f":"SUM(N72:N74)","v":0},null,{"$f":"SUM(P72:P74)","v":0},{"$f":"SUM(Q72:Q74)","v":0},{"$f":"SUM(R72:R74)","v":0},{"$f":"SUM(S72:S74)","v":0}]
[null,"TOTAL REVENUE EXPENDITURE",null,{"$f":"D38+D48+D52+D61+D68+D71+D75","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Opening balance",null,{"$f":"'CASH FLOW YR 2'!R81","v":0},{"$f":"D81","v":0},{"$f":"E81","v":0},null,{"$f":"F81","v":0},0,0,null,{"$f":"J81","v":0},0,0,null,{"$f":"N81","v":0},0,0,{"$f":"R81","v":0}]
[null,"Total Income",null,{"$f":"D30","v":0},{"$f":"E30","v":0},{"$f":"F30","v":0},null,{"$f":"H30","v":0},{"$f":"I30","v":0},{"$f":"J30","v":0},null,{"$f":"L30","v":0},{"$f":"M30","v":0},{"$f":"N30","v":0},null,{"$f":"P30","v":0},{"$f":"Q30","v":0},{"$f":"R30","v":0},{"$f":"SUM(D79:R79)","v":0}]
[null,"Total Expenditure",null,{"$f":"D76","v":0},{"$f":"E76","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(D80:R80)","v":0}]
[null,"Closing balance",null,{"$f":"D78+D79-D80","v":0},0,0,null,0,0,0,null,0,0,0,null,0,0,{"$f":"R78+R79-R80","v":0}]
[]
[null,"This figure should be your closing balance from Yr 2",null,null,null,null,null,{"$f":"IF(Q83=\"LOSS\",\"WARNING\",\"GOOD NEWS\")","v":"GOOD NEWS"},null,"The cashflow forecast is currently indicating that you will make a",null,null,null,null,null,null,{"$f":"IF(S83<0,\"LOSS\",IF(S83>0,\"PROFIT\",IF(S83=0,\"BREAK EVEN\")))","v":"BREAK EVEN"},{"$f":"IF(S80>S79,\"LOSS\",IF(S80<S79,\"PROFIT\",IF(S80=S79,\"BREAK EVEN\")))","v":"BREAK EVEN"},{"$f":"S79-S80","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Year 1"]
[null,"Year 2"]
[null,"Year 3"]
[null,"Year 4"]
[null,"Year 5"]
[null,"Year 6"]
[null,"Year 7"]
[null,"Year 8"]
[null,"Year 9"]
[null,"Year 10"]