{"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":1,"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":7,"n_cols":1,"rows_kept":7,"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"]
["Last Update 11/2025"]

{"sheet":"Completing this document","index":1,"n_rows":19,"n_cols":1,"rows_kept":19,"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"]
[]
["Early Years and Childcare Business Management Consultancy Team:"]
["Alan Haylock - North Essex - email: Alan.haylock@essex.gov.uk "]
["Rosemary Newell - Mid Essex - email: Rosemary.newell@essex.gov.uk"]
["Caroline Brown - South Essex - email: Caroline.brown@essex.gov.uk"]
["Carmen Saunders - West Essex - 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 2025"]
[]
["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.92,"Refer to your provider handbook for current rates"]
["FEEE2",8.16,"Refer to your provider handbook for current rates"]
["FEEE2W",7.96,"Refer to your provider handbook for current rates"]
["FEEE 3 - 4",5.54,"Refer to your provider handbook for current rates"]
[]
["Please accuratley reflect the timings of your FEEE funding.  ",null,"Childminders, CMA and Day Nurseries will move to 12 monthly payments."]

{"sheet":"STAFF RATES","index":3,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[6,1,6,4],[2,1,2,8],[4,1,4,8]]}
[]
[]
[null,"Setting Name: "]
[]
[null,"Staff Salary Rates "]
[null,null,null,null,null,null,null,null,null,"Please insert Pension Rate"]
[null,null,null,null,null,null,null,null,null,"Pension Rate"]
[]
[null,"Staff Roles                    The headings below can be amended","Hourly Rate","No hours Per Week","No weeks Per Year","Annual  salary","Employers National Insurance Contributions","Pension YES / NO","Pension","Staff Costs per Person","No of staff","Total Staff Costs"]
[null,"Manager",null,null,null,{"$f":"C10*D10*E10","v":0},{"$f":"IF(F10>5000,(F10-5000)*0.15,0)","v":0},null,{"$f":"IF(H10=\"yes\",F10*$K$7,0)","v":0},{"$f":"F10+G10+I10","v":0},null,{"$f":"J10*K10","v":0}]
[null,"Assistant Manager",null,null,null,{"$f":"C11*D11*E11","v":0},{"$f":"IF(F11>5000,(F11-5000)*0.15,0)","v":0},null,{"$f":"IF(H11=\"yes\",F11*$K$7,0)","v":0},{"$f":"F11+G11+I11","v":0},null,{"$f":"J11*K11","v":0}]
[null,"Early Years Practitioner",null,null,null,{"$f":"C12*D12*E12","v":0},0,null,{"$f":"IF(H12=\"yes\",F12*$K$7,0)","v":0},{"$f":"F12+G12+I12","v":0},null,{"$f":"J12*K12","v":0}]
[null,"Early Years Practitioner",null,null,null,{"$f":"C13*D13*E13","v":0},0,null,{"$f":"IF(H13=\"yes\",F13*$K$7,0)","v":0},{"$f":"F13+G13+I13","v":0},null,{"$f":"J13*K13","v":0}]
[null,"Early Years Practitioner",null,null,null,{"$f":"C14*D14*E14","v":0},0,null,{"$f":"IF(H14=\"yes\",F14*$K$7,0)","v":0},{"$f":"F14+G14+I14","v":0},null,{"$f":"J14*K14","v":0}]
[null,"Wraparound Practitioner",null,null,null,{"$f":"C15*D15*E15","v":0},0,null,{"$f":"IF(H15=\"yes\",F15*$K$7,0)","v":0},{"$f":"F15+G15+I15","v":0},null,{"$f":"J15*K15","v":0}]
[null,"Wraparound Practitioner",null,null,null,{"$f":"C16*D16*E16","v":0},0,null,{"$f":"IF(H16=\"yes\",F16*$K$7,0)","v":0},{"$f":"F16+G16+I16","v":0},null,{"$f":"J16*K16","v":0}]

{"sheet":"Staff Salaries","index":4,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,1,4,7],[4,8,4,12],[15,12,15,13],[2,1,2,8],[2,11,2,12],[2,13,2,14],[3,1,3,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'!M3","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","Total Staff Costs"]
[null,{"$f":"'[1] 2. Staff Rates Year 1'!C11","v":"Manager or Overtype"},{"$f":"'STAFF RATES'!$L$10/12","v":0},{"$f":"'STAFF RATES'!$L$10/12","v":0},{"$f":"'STAFF RATES'!$L$10/12","v":0},{"$f":"'STAFF RATES'!$L$10/12","v":0},{"$f":"'STAFF RATES'!$L$10/12","v":0},{"$f":"'STAFF RATES'!$L$10/12","v":0},{"$f":"'STAFF RATES'!$L$10/12","v":0},{"$f":"'STAFF RATES'!$L$10/12","v":0},{"$f":"'STAFF RATES'!$L$10/12","v":0},{"$f":"'STAFF RATES'!$L$10/12","v":0},{"$f":"'STAFF RATES'!$L$10/12","v":0},{"$f":"'STAFF RATES'!$L$10/12","v":0},{"$f":"SUM(C8:N8)","v":0}]
[null,{"$f":"'STAFF RATES'!B11","v":"Assistant Manager"},{"$f":"'STAFF RATES'!$L$11/12","v":0},{"$f":"'STAFF RATES'!$L$11/12","v":0},{"$f":"'STAFF RATES'!$L$11/12","v":0},{"$f":"'STAFF RATES'!$L$11/12","v":0},{"$f":"'STAFF RATES'!$L$11/12","v":0},{"$f":"'STAFF RATES'!$L$11/12","v":0},{"$f":"'STAFF RATES'!$L$11/12","v":0},{"$f":"'STAFF RATES'!$L$11/12","v":0},{"$f":"'STAFF RATES'!$L$11/12","v":0},{"$f":"'STAFF RATES'!$L$11/12","v":0},{"$f":"'STAFF RATES'!$L$11/12","v":0},{"$f":"'STAFF RATES'!$L$11/12","v":0},{"$f":"SUM(C9:N9)","v":0}]
[null,{"$f":"'STAFF RATES'!B12","v":"Early Years Practitioner"},{"$f":"'STAFF RATES'!$L$12/12","v":0},{"$f":"'STAFF RATES'!$L$12/12","v":0},{"$f":"'STAFF RATES'!$L$12/12","v":0},{"$f":"'STAFF RATES'!$L$12/12","v":0},{"$f":"'STAFF RATES'!$L$12/12","v":0},{"$f":"'STAFF RATES'!$L$12/12","v":0},{"$f":"'STAFF RATES'!$L$12/12","v":0},{"$f":"'STAFF RATES'!$L$12/12","v":0},{"$f":"'STAFF RATES'!$L$12/12","v":0},{"$f":"'STAFF RATES'!$L$12/12","v":0},{"$f":"'STAFF RATES'!$L$12/12","v":0},{"$f":"'STAFF RATES'!$L$12/12","v":0},{"$f":"SUM(C10:N10)","v":0}]
[null,{"$f":"'STAFF RATES'!B13","v":"Early Years Practitioner"},{"$f":"'STAFF RATES'!$L$13/12","v":0},{"$f":"'STAFF RATES'!$L$13/12","v":0},{"$f":"'STAFF RATES'!$L$13/12","v":0},{"$f":"'STAFF RATES'!$L$13/12","v":0},{"$f":"'STAFF RATES'!$L$13/12","v":0},{"$f":"'STAFF RATES'!$L$13/12","v":0},{"$f":"'STAFF RATES'!$L$13/12","v":0},{"$f":"'STAFF RATES'!$L$13/12","v":0},{"$f":"'STAFF RATES'!$L$13/12","v":0},{"$f":"'STAFF RATES'!$L$13/12","v":0},{"$f":"'STAFF RATES'!$L$13/12","v":0},{"$f":"'STAFF RATES'!$L$13/12","v":0},{"$f":"SUM(C11:N11)","v":0}]
[null,{"$f":"'STAFF RATES'!B14","v":"Early Years Practitioner"},{"$f":"'STAFF RATES'!$L$14/12","v":0},{"$f":"'STAFF RATES'!$L$14/12","v":0},{"$f":"'STAFF RATES'!$L$14/12","v":0},{"$f":"'STAFF RATES'!$L$14/12","v":0},{"$f":"'STAFF RATES'!$L$14/12","v":0},{"$f":"'STAFF RATES'!$L$14/12","v":0},{"$f":"'STAFF RATES'!$L$14/12","v":0},{"$f":"'STAFF RATES'!$L$14/12","v":0},{"$f":"'STAFF RATES'!$L$14/12","v":0},{"$f":"'STAFF RATES'!$L$14/12","v":0},{"$f":"'STAFF RATES'!$L$14/12","v":0},{"$f":"'STAFF RATES'!$L$14/12","v":0},{"$f":"SUM(C12:N12)","v":0}]
[null,{"$f":"'STAFF RATES'!B15","v":"Wraparound Practitioner"},{"$f":"'STAFF RATES'!$L$15/12","v":0},{"$f":"'STAFF RATES'!$L$15/12","v":0},{"$f":"'STAFF RATES'!$L$15/12","v":0},{"$f":"'STAFF RATES'!$L$15/12","v":0},{"$f":"'STAFF RATES'!$L$15/12","v":0},{"$f":"'STAFF RATES'!$L$15/12","v":0},{"$f":"'STAFF RATES'!$L$15/12","v":0},{"$f":"'STAFF RATES'!$L$15/12","v":0},{"$f":"'STAFF RATES'!$L$15/12","v":0},{"$f":"'STAFF RATES'!$L$15/12","v":0},{"$f":"'STAFF RATES'!$L$15/12","v":0},{"$f":"'STAFF RATES'!$L$15/12","v":0},{"$f":"SUM(C13:N13)","v":0}]
[null,{"$f":"'STAFF RATES'!B16","v":"Wraparound Practitioner"},{"$f":"'STAFF RATES'!$L$16/12","v":0},{"$f":"'STAFF RATES'!$L$16/12","v":0},{"$f":"'STAFF RATES'!$L$16/12","v":0},{"$f":"'STAFF RATES'!$L$16/12","v":0},{"$f":"'STAFF RATES'!$L$16/12","v":0},{"$f":"'STAFF RATES'!$L$16/12","v":0},{"$f":"'STAFF RATES'!$L$16/12","v":0},{"$f":"'STAFF RATES'!$L$16/12","v":0},{"$f":"'STAFF RATES'!$L$16/12","v":0},{"$f":"'STAFF RATES'!$L$16/12","v":0},{"$f":"'STAFF RATES'!$L$16/12","v":0},{"$f":"'STAFF RATES'!$L$16/12","v":0},{"$f":"SUM(C14:N14)","v":0}]
[null,"TOTAL PER MONTH",{"$f":"SUM(C8:C14)","v":0},{"$f":"SUM(D8:D14)","v":0},{"$f":"SUM(E8:E14)","v":0},{"$f":"SUM(F8:F14)","v":0},{"$f":"SUM(G8:G14)","v":0},{"$f":"SUM(H8:H14)","v":0},{"$f":"SUM(I8:I14)","v":0},{"$f":"SUM(J8:J14)","v":0},{"$f":"SUM(K8:K14)","v":0},{"$f":"SUM(L8:L14)","v":0},{"$f":"SUM(M8:M14)","v":0},{"$f":"SUM(N8:N14)","v":0},{"$f":"SUM(O8:O14)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total staff cost                        (Fully Staffed Year 1)",null,{"$f":"O15","v":0}]

{"sheet":"Workings to Cash flow","index":5,"n_rows":34,"n_cols":6,"rows_kept":34,"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"]
[null,"Income Breakdown for Wraparound"]
[null,"Varying Rates","Hourly Rate","Number of Children per hour","Number of Hours per week","Fees per week"]
[null,"Breakfast Club",null,null,null,{"$f":"C28*D28*E28","v":0}]
[null,"One Rate 3pm - 6pm",null,null,null,{"$f":"C29*D29*E29","v":0}]
[null,"Rate for 3pm - 4pm",null,null,null,0]
[null,"Rate for 4pm - 5pm",null,null,null,0]
[null,"Rate for 5pm - 6pm",null,null,null,0]
[null,null,null,null,null,0]
[null,"Total",null,null,null,{"$f":"SUM(F28:F33)","v":0}]

{"sheet":"CASH FLOW YR 1","index":6,"n_rows":88,"n_cols":16,"rows_kept":88,"cut":false,"hidden":false,"merged":[[67,13,67,14],[67,1,67,5],[67,8,67,12],[67,6,67,7],[2,6,2,7],[8,1,9,1],[2,11,4,15],[6,3,6,14],[4,3,4,8],[2,3,2,5],[4,1,6,1]]}
[" "]
[]
[null,null,null,"Date completed",null,null,"2000-01-01",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,"PLEASE NOTE: Only complete the blue boxes below which apply to your setting.  "]
[]
[null,"YEAR 1",null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Totals"]
[null,null,null,{"$f":"'Staff Salaries'!C7","v":"Month 1 - overtype"},{"$f":"'Staff Salaries'!D7","v":"Month 2 - overtype"},{"$f":"'Staff Salaries'!E7","v":"Month 3 - overtype"},{"$f":"'Staff Salaries'!F7","v":"Month 4 - overtype"},{"$f":"'Staff Salaries'!G7","v":"Month 5 - overtype"},{"$f":"'Staff Salaries'!H7","v":"Month 6 - overtype"},{"$f":"'Staff Salaries'!I7","v":"Month 7 - overtype"},{"$f":"'Staff Salaries'!J7","v":"Month 8 - overtype"},{"$f":"'Staff Salaries'!K7","v":"Month 9 - overtype"},{"$f":"'Staff Salaries'!L7","v":"Month 10 - overtype"},{"$f":"'Staff Salaries'!M7","v":"Month 11 - overtype"},{"$f":"'Staff Salaries'!N7","v":"Month 12 - overtype"}]
[null,"Income"]
[]
[null,"FEEE1W",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:O13)","v":0}]
[null,"FEEE2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:O14)","v":0}]
[null,"FEEE2W",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D15:O15)","v":0}]
[null,"FEEE 3 - 4",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D16:O16)","v":0}]
[null,"Private Fees for additional hours",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D17:O17)","v":0}]
[null,"Voluntary Meal and Snack Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Voluntary Consumables Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Voluntary Activity Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D20:O20)","v":0}]
[null,"Other - please overtype",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D21:O21)","v":0}]
[]
[null,"TOTAL INCOME ",null,{"$f":"SUM(D13:D21)","v":0},{"$f":"SUM(E13:E21)","v":0},{"$f":"SUM(F13:F21)","v":0},{"$f":"SUM(G13:G21)","v":0},{"$f":"SUM(H13:H21)","v":0},{"$f":"SUM(I13:I21)","v":0},{"$f":"SUM(J13:J21)","v":0},{"$f":"SUM(K13:K21)","v":0},{"$f":"SUM(L13:L21)","v":0},{"$f":"SUM(M13:M21)","v":0},{"$f":"SUM(N13:N21)","v":0},{"$f":"SUM(O13:O21)","v":0},{"$f":"SUM(P13:P21)","v":0}]
[]
[null,"Expenditure"]
[]
[null,"Wages & Salaries",null,{"$f":"'Staff Salaries'!C15","v":0},{"$f":"'Staff Salaries'!D15","v":0},{"$f":"'Staff Salaries'!E15","v":0},{"$f":"'Staff Salaries'!F15","v":0},{"$f":"'Staff Salaries'!G15","v":0},{"$f":"'Staff Salaries'!H15","v":0},{"$f":"'Staff Salaries'!I15","v":0},{"$f":"'Staff Salaries'!J15","v":0},{"$f":"'Staff Salaries'!K15","v":0},{"$f":"'Staff Salaries'!L15","v":0},{"$f":"'Staff Salaries'!M15","v":0},{"$f":"'Staff Salaries'!N15","v":0},{"$f":"SUM(D27:O27)","v":0}]
[null,"Holiday Cover @ 5%",null,{"$f":"D27/100*5","v":0},{"$f":"E27/100*5","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D28:O28)","v":0}]
[null,"Staff  Training @ 1.5%",null,{"$f":"D27/100*1.5","v":0},{"$f":"E27/100*1.5","v":0},{"$f":"F27/100*1.5","v":0},{"$f":"G27/100*1.5","v":0},{"$f":"H27/100*1.5","v":0},{"$f":"I27/100*1.5","v":0},{"$f":"J27/100*1.5","v":0},{"$f":"K27/100*1.5","v":0},{"$f":"L27/100*1.5","v":0},{"$f":"M27/100*1.5","v":0},{"$f":"N27/100*1.5","v":0},{"$f":"O27/100*1.5","v":0},{"$f":"SUM(D29:O29)","v":0}]
[null,"Other ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:O30)","v":0}]
[null,"Total Staff Costs",null,{"$f":"SUM(D27:D30)","v":0},{"$f":"SUM(E27:E30)","v":0},{"$f":"SUM(F27:F30)","v":0},{"$f":"SUM(G27:G30)","v":0},{"$f":"SUM(H27:H30)","v":0},{"$f":"SUM(I27:I30)","v":0},{"$f":"SUM(J27:J30)","v":0},{"$f":"SUM(K27:K30)","v":0},{"$f":"SUM(L27:L30)","v":0},{"$f":"SUM(M27:M30)","v":0},{"$f":"SUM(N27:N30)","v":0},{"$f":"SUM(O27:O30)","v":0},{"$f":"SUM(P27:P30)","v":0}]
[null,"Rent",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D32:O32)","v":0}]
[null,"Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D33:O33)","v":0}]
[null,"Electricity",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D34:O34)","v":0}]
[null,"Gas",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D35:O35)","v":0}]
[null,"Business Rates",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D36:O36)","v":0}]
[null,"Water",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D37:O37)","v":0}]
[null,"Cleaning",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D38:O38)","v":0}]
[null,"Total Premises",null,{"$f":"SUM(D32:D38)","v":0},{"$f":"SUM(E32:E38)","v":0},{"$f":"SUM(F32:F38)","v":0},{"$f":"SUM(G32:G38)","v":0},{"$f":"SUM(H32:H38)","v":0},{"$f":"SUM(I32:I38)","v":0},{"$f":"SUM(J32:J38)","v":0},{"$f":"SUM(K32:K38)","v":0},{"$f":"SUM(L32:L38)","v":0},{"$f":"SUM(M32:M38)","v":0},{"$f":"SUM(N32:N38)","v":0},{"$f":"SUM(O32:O38)","v":0},{"$f":"SUM(P32:P38)","v":0}]
[null,"Building Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D40:O40)","v":0}]
[null,"Contents Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D41:O41)","v":0}]
[null,"Employment Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D42:O42)","v":0}]
[null,"Total Insurance",null,{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P40:P42)","v":0}]
[]
[null,"Administration Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D45:O45)","v":0}]
[null,"Membership Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D46:O46)","v":0}]
[null,"Bank Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D47:O47)","v":0}]
[null,"Professional Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:O48)","v":0}]
[null,"Subscriptions",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:O49)","v":0}]
[null,"Total Administration",null,{"$f":"SUM(D45:D49)","v":0},{"$f":"SUM(E45:E49)","v":0},{"$f":"SUM(F45:F49)","v":0},{"$f":"SUM(G45:G49)","v":0},{"$f":"SUM(H45:H49)","v":0},{"$f":"SUM(I45:I49)","v":0},{"$f":"SUM(J45:J49)","v":0},{"$f":"SUM(K45:K49)","v":0},{"$f":"SUM(L45:L49)","v":0},{"$f":"SUM(M45:M49)","v":0},{"$f":"SUM(N45:N49)","v":0},{"$f":"SUM(O45:O49)","v":0},{"$f":"SUM(P45:P49)","v":0}]
[null,"Consumables",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D51:O51)","v":0}]
[null,"Visits & Trips out ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D52:O52)","v":0}]
[null,"Catering",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D53:O53)","v":0}]
[null,"Misc / Sundries",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D54:O54)","v":0}]
[null,"Repairs & renewals",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D55:O55)","v":0}]
[null,"Total Activity & Material Costs",null,{"$f":"SUM(D51:D55)","v":0},{"$f":"SUM(E51:E55)","v":0},{"$f":"SUM(F51:F55)","v":0},{"$f":"SUM(G51:G55)","v":0},{"$f":"SUM(H51:H55)","v":0},{"$f":"SUM(I51:I55)","v":0},{"$f":"SUM(J51:J55)","v":0},{"$f":"SUM(K51:K55)","v":0},{"$f":"SUM(L51:L55)","v":0},{"$f":"SUM(M51:M55)","v":0},{"$f":"SUM(N51:N55)","v":0},{"$f":"SUM(O51:O55)","v":0},{"$f":"SUM(P51:P55)","v":0}]
[null,"Advertising / Promotions",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D57:O57)","v":0}]
[null,"Total Advertising",null,{"$f":"SUM(D57:D57)","v":0},{"$f":"SUM(E57:E57)","v":0},{"$f":"SUM(F57:F57)","v":0},{"$f":"SUM(G57:G57)","v":0},{"$f":"SUM(H57:H57)","v":0},{"$f":"SUM(I57:I57)","v":0},{"$f":"SUM(J57:J57)","v":0},{"$f":"SUM(K57:K57)","v":0},{"$f":"SUM(L57:L57)","v":0},{"$f":"SUM(M57:M57)","v":0},{"$f":"SUM(N57:N57)","v":0},{"$f":"SUM(O57:O57)","v":0},{"$f":"SUM(P57:P57)","v":0}]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D59:O59)","v":0}]
[null,"Other",null,{"$f":"SUM(D59:D59)","v":0},{"$f":"SUM(E59:E59)","v":0},{"$f":"SUM(F59:F59)","v":0},{"$f":"SUM(G59:G59)","v":0},{"$f":"SUM(H59:H59)","v":0},{"$f":"SUM(I59:I59)","v":0},{"$f":"SUM(J59:J59)","v":0},{"$f":"SUM(K59:K59)","v":0},{"$f":"SUM(L59:L59)","v":0},{"$f":"SUM(M59:M59)","v":0},{"$f":"SUM(N59:N59)","v":0},{"$f":"SUM(O59:O59)","v":0},{"$f":"SUM(P59:P59)","v":0}]
[null,"TOTAL REVENUE EXPENDITURE",null,{"$f":"D31+D39+D43+D50+D56+D58+D60","v":0},{"$f":"E31+E39+E43+E50+E56+E58+E60","v":0},{"$f":"F31+F39+F43+F50+F56+F58+F60","v":0},{"$f":"G31+G39+G43+G50+G56+G58+G60","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Opening balance",null,null,{"$f":"D66","v":0},{"$f":"E66","v":0},{"$f":"F66","v":0},0,0,{"$f":"I66","v":0},0,0,{"$f":"L66","v":0},0,0,{"$f":"O66","v":0}]
[null,"Total Income",null,{"$f":"D23","v":0},{"$f":"E23","v":0},{"$f":"F23","v":0},{"$f":"G23","v":0},{"$f":"H23","v":0},{"$f":"I23","v":0},{"$f":"J23","v":0},{"$f":"K23","v":0},{"$f":"L23","v":0},{"$f":"M23","v":0},{"$f":"N23","v":0},{"$f":"O23","v":0},{"$f":"SUM(D64:O64)","v":0}]
[null,"Total Expenditure",null,{"$f":"D61","v":0},{"$f":"E61","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D65:O65)","v":0}]
[null,"Closing balance",null,{"$f":"D63+D64-D65","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"O63+O64-O65","v":0}]
[]
[null,{"$f":"IF(D63=0,\"PLEASE ENTER OPENING BALANCE\",\"OPENING BALANCE OK\")","v":"PLEASE ENTER OPENING BALANCE"},null,null,null,null,{"$f":"IF(N68=\"LOSS\",\"WARNING\",\"GOOD NEWS\")","v":"GOOD NEWS"},null,"The cashflow forecast is currently indicating that you will make a",null,null,null,null,{"$f":"IF(P68<0,\"LOSS\",IF(P68>0,\"PROFIT\",IF(P68=0,\"BREAK EVEN\")))","v":"BREAK EVEN"},{"$f":"IF(P65>P64,\"LOSS\",IF(P65<P64,\"PROFIT\",IF(P65=P64,\"BREAK EVEN\")))","v":"BREAK EVEN"},{"$f":"P64-P65","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":88,"n_cols":16,"rows_kept":88,"cut":false,"hidden":false,"merged":[[67,1,67,5],[67,6,67,7],[67,8,67,12],[67,13,67,14],[2,3,2,5],[2,6,2,7],[2,11,4,15],[4,1,6,1],[4,3,4,8],[6,3,6,14],[8,1,9,1]]}
[" "]
[]
[null,null,null,"Date completed",null,null,"2000-01-01",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,"PLEASE NOTE: Only complete the blue boxes below which apply to your setting.  "]
[]
[null,"YEAR 2",null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Totals"]
[null,null,null,{"$f":"'Staff Salaries'!C7","v":"Month 1 - overtype"},{"$f":"'Staff Salaries'!D7","v":"Month 2 - overtype"},{"$f":"'Staff Salaries'!E7","v":"Month 3 - overtype"},{"$f":"'Staff Salaries'!F7","v":"Month 4 - overtype"},{"$f":"'Staff Salaries'!G7","v":"Month 5 - overtype"},{"$f":"'Staff Salaries'!H7","v":"Month 6 - overtype"},{"$f":"'Staff Salaries'!I7","v":"Month 7 - overtype"},{"$f":"'Staff Salaries'!J7","v":"Month 8 - overtype"},{"$f":"'Staff Salaries'!K7","v":"Month 9 - overtype"},{"$f":"'Staff Salaries'!L7","v":"Month 10 - overtype"},{"$f":"'Staff Salaries'!M7","v":"Month 11 - overtype"},{"$f":"'Staff Salaries'!N7","v":"Month 12 - overtype"}]
[null,"Income"]
[]
[null,"FEEE1W",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:O13)","v":0}]
[null,"FEEE2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:O14)","v":0}]
[null,"FEEE2W",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D15:O15)","v":0}]
[null,"FEEE 3 - 4",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D16:O16)","v":0}]
[null,"Private Fees for additional hours",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D17:O17)","v":0}]
[null,"Voluntary Meal and Snack Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Voluntary Consumables Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Voluntary Activity Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D20:O20)","v":0}]
[null,"Other - please overtype",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D21:O21)","v":0}]
[]
[null,"TOTAL INCOME ",null,{"$f":"SUM(D13:D21)","v":0},{"$f":"SUM(E13:E21)","v":0},{"$f":"SUM(F13:F21)","v":0},{"$f":"SUM(G13:G21)","v":0},{"$f":"SUM(H13:H21)","v":0},{"$f":"SUM(I13:I21)","v":0},{"$f":"SUM(J13:J21)","v":0},{"$f":"SUM(K13:K21)","v":0},{"$f":"SUM(L13:L21)","v":0},{"$f":"SUM(M13:M21)","v":0},{"$f":"SUM(N13:N21)","v":0},{"$f":"SUM(O13:O21)","v":0},{"$f":"SUM(P13:P21)","v":0}]
[]
[null,"Expenditure"]
[]
[null,"Wages & Salaries",null,{"$f":"'Staff Salaries'!C15","v":0},{"$f":"'Staff Salaries'!D15","v":0},{"$f":"'Staff Salaries'!E15","v":0},{"$f":"'Staff Salaries'!F15","v":0},{"$f":"'Staff Salaries'!G15","v":0},{"$f":"'Staff Salaries'!H15","v":0},{"$f":"'Staff Salaries'!I15","v":0},{"$f":"'Staff Salaries'!J15","v":0},{"$f":"'Staff Salaries'!K15","v":0},{"$f":"'Staff Salaries'!L15","v":0},{"$f":"'Staff Salaries'!M15","v":0},{"$f":"'Staff Salaries'!N15","v":0},{"$f":"SUM(D27:O27)","v":0}]
[null,"Holiday Cover @ 5%",null,{"$f":"D27/100*5","v":0},{"$f":"E27/100*5","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D28:O28)","v":0}]
[null,"Staff  Training @ 1.5%",null,{"$f":"D27/100*1.5","v":0},{"$f":"E27/100*1.5","v":0},{"$f":"F27/100*1.5","v":0},{"$f":"G27/100*1.5","v":0},{"$f":"H27/100*1.5","v":0},{"$f":"I27/100*1.5","v":0},{"$f":"J27/100*1.5","v":0},{"$f":"K27/100*1.5","v":0},{"$f":"L27/100*1.5","v":0},{"$f":"M27/100*1.5","v":0},{"$f":"N27/100*1.5","v":0},{"$f":"O27/100*1.5","v":0},{"$f":"SUM(D29:O29)","v":0}]
[null,"Other ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:O30)","v":0}]
[null,"Total Staff Costs",null,{"$f":"SUM(D27:D30)","v":0},{"$f":"SUM(E27:E30)","v":0},{"$f":"SUM(F27:F30)","v":0},{"$f":"SUM(G27:G30)","v":0},{"$f":"SUM(H27:H30)","v":0},{"$f":"SUM(I27:I30)","v":0},{"$f":"SUM(J27:J30)","v":0},{"$f":"SUM(K27:K30)","v":0},{"$f":"SUM(L27:L30)","v":0},{"$f":"SUM(M27:M30)","v":0},{"$f":"SUM(N27:N30)","v":0},{"$f":"SUM(O27:O30)","v":0},{"$f":"SUM(P27:P30)","v":0}]
[null,"Rent",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D32:O32)","v":0}]
[null,"Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D33:O33)","v":0}]
[null,"Electricity",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D34:O34)","v":0}]
[null,"Gas",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D35:O35)","v":0}]
[null,"Business Rates",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D36:O36)","v":0}]
[null,"Water",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D37:O37)","v":0}]
[null,"Cleaning",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D38:O38)","v":0}]
[null,"Total Premises",null,{"$f":"SUM(D32:D38)","v":0},{"$f":"SUM(E32:E38)","v":0},{"$f":"SUM(F32:F38)","v":0},{"$f":"SUM(G32:G38)","v":0},{"$f":"SUM(H32:H38)","v":0},{"$f":"SUM(I32:I38)","v":0},{"$f":"SUM(J32:J38)","v":0},{"$f":"SUM(K32:K38)","v":0},{"$f":"SUM(L32:L38)","v":0},{"$f":"SUM(M32:M38)","v":0},{"$f":"SUM(N32:N38)","v":0},{"$f":"SUM(O32:O38)","v":0},{"$f":"SUM(P32:P38)","v":0}]
[null,"Building Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D40:O40)","v":0}]
[null,"Contents Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D41:O41)","v":0}]
[null,"Employment Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D42:O42)","v":0}]
[null,"Total Insurance",null,{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P40:P42)","v":0}]
[]
[null,"Administration Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D45:O45)","v":0}]
[null,"Membership Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D46:O46)","v":0}]
[null,"Bank Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D47:O47)","v":0}]
[null,"Professional Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:O48)","v":0}]
[null,"Subscriptions",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:O49)","v":0}]
[null,"Total Administration",null,{"$f":"SUM(D45:D49)","v":0},{"$f":"SUM(E45:E49)","v":0},{"$f":"SUM(F45:F49)","v":0},{"$f":"SUM(G45:G49)","v":0},{"$f":"SUM(H45:H49)","v":0},{"$f":"SUM(I45:I49)","v":0},{"$f":"SUM(J45:J49)","v":0},{"$f":"SUM(K45:K49)","v":0},{"$f":"SUM(L45:L49)","v":0},{"$f":"SUM(M45:M49)","v":0},{"$f":"SUM(N45:N49)","v":0},{"$f":"SUM(O45:O49)","v":0},{"$f":"SUM(P45:P49)","v":0}]
[null,"Consumables",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D51:O51)","v":0}]
[null,"Visits & Trips out ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D52:O52)","v":0}]
[null,"Catering",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D53:O53)","v":0}]
[null,"Misc / Sundries",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D54:O54)","v":0}]
[null,"Repairs & renewals",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D55:O55)","v":0}]
[null,"Total Activity & Material Costs",null,{"$f":"SUM(D51:D55)","v":0},{"$f":"SUM(E51:E55)","v":0},{"$f":"SUM(F51:F55)","v":0},{"$f":"SUM(G51:G55)","v":0},{"$f":"SUM(H51:H55)","v":0},{"$f":"SUM(I51:I55)","v":0},{"$f":"SUM(J51:J55)","v":0},{"$f":"SUM(K51:K55)","v":0},{"$f":"SUM(L51:L55)","v":0},{"$f":"SUM(M51:M55)","v":0},{"$f":"SUM(N51:N55)","v":0},{"$f":"SUM(O51:O55)","v":0},{"$f":"SUM(P51:P55)","v":0}]
[null,"Advertising / Promotions",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D57:O57)","v":0}]
[null,"Total Advertising",null,{"$f":"SUM(D57:D57)","v":0},{"$f":"SUM(E57:E57)","v":0},{"$f":"SUM(F57:F57)","v":0},{"$f":"SUM(G57:G57)","v":0},{"$f":"SUM(H57:H57)","v":0},{"$f":"SUM(I57:I57)","v":0},{"$f":"SUM(J57:J57)","v":0},{"$f":"SUM(K57:K57)","v":0},{"$f":"SUM(L57:L57)","v":0},{"$f":"SUM(M57:M57)","v":0},{"$f":"SUM(N57:N57)","v":0},{"$f":"SUM(O57:O57)","v":0},{"$f":"SUM(P57:P57)","v":0}]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D59:O59)","v":0}]
[null,"Other",null,{"$f":"SUM(D59:D59)","v":0},{"$f":"SUM(E59:E59)","v":0},{"$f":"SUM(F59:F59)","v":0},{"$f":"SUM(G59:G59)","v":0},{"$f":"SUM(H59:H59)","v":0},{"$f":"SUM(I59:I59)","v":0},{"$f":"SUM(J59:J59)","v":0},{"$f":"SUM(K59:K59)","v":0},{"$f":"SUM(L59:L59)","v":0},{"$f":"SUM(M59:M59)","v":0},{"$f":"SUM(N59:N59)","v":0},{"$f":"SUM(O59:O59)","v":0},{"$f":"SUM(P59:P59)","v":0}]
[null,"TOTAL REVENUE EXPENDITURE",null,{"$f":"D31+D39+D43+D50+D56+D58+D60","v":0},{"$f":"E31+E39+E43+E50+E56+E58+E60","v":0},{"$f":"F31+F39+F43+F50+F56+F58+F60","v":0},{"$f":"G31+G39+G43+G50+G56+G58+G60","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Opening balance",null,{"$f":"'CASH FLOW YR 1'!O66","v":0},{"$f":"D66","v":0},{"$f":"E66","v":0},{"$f":"F66","v":0},0,0,{"$f":"I66","v":0},0,0,{"$f":"L66","v":0},0,0,{"$f":"O66","v":0}]
[null,"Total Income",null,{"$f":"D23","v":0},{"$f":"E23","v":0},{"$f":"F23","v":0},{"$f":"G23","v":0},{"$f":"H23","v":0},{"$f":"I23","v":0},{"$f":"J23","v":0},{"$f":"K23","v":0},{"$f":"L23","v":0},{"$f":"M23","v":0},{"$f":"N23","v":0},{"$f":"O23","v":0},{"$f":"SUM(D64:O64)","v":0}]
[null,"Total Expenditure",null,{"$f":"D61","v":0},{"$f":"E61","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D65:O65)","v":0}]
[null,"Closing balance",null,{"$f":"D63+D64-D65","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"O63+O64-O65","v":0}]
[]
[null,{"$f":"IF(D63=0,\"PLEASE ENTER OPENING BALANCE\",\"OPENING BALANCE OK\")","v":"PLEASE ENTER OPENING BALANCE"},null,null,null,null,{"$f":"IF(N68=\"LOSS\",\"WARNING\",\"GOOD NEWS\")","v":"GOOD NEWS"},null,"The cashflow forecast is currently indicating that you will make a",null,null,null,null,{"$f":"IF(P68<0,\"LOSS\",IF(P68>0,\"PROFIT\",IF(P68=0,\"BREAK EVEN\")))","v":"BREAK EVEN"},{"$f":"IF(P65>P64,\"LOSS\",IF(P65<P64,\"PROFIT\",IF(P65=P64,\"BREAK EVEN\")))","v":"BREAK EVEN"},{"$f":"P64-P65","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":88,"n_cols":16,"rows_kept":88,"cut":false,"hidden":false,"merged":[[2,3,2,5],[2,6,2,7],[2,11,4,15],[4,1,6,1],[4,3,4,8],[6,3,6,14],[8,1,9,1],[67,1,67,5],[67,6,67,7],[67,8,67,12],[67,13,67,14]]}
[" "]
[]
[null,null,null,"Date completed",null,null,"2000-01-01",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,"PLEASE NOTE: Only complete the blue boxes below which apply to your setting.  "]
[]
[null,"YEAR 3",null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Totals"]
[null,null,null,{"$f":"'Staff Salaries'!C7","v":"Month 1 - overtype"},{"$f":"'Staff Salaries'!D7","v":"Month 2 - overtype"},{"$f":"'Staff Salaries'!E7","v":"Month 3 - overtype"},{"$f":"'Staff Salaries'!F7","v":"Month 4 - overtype"},{"$f":"'Staff Salaries'!G7","v":"Month 5 - overtype"},{"$f":"'Staff Salaries'!H7","v":"Month 6 - overtype"},{"$f":"'Staff Salaries'!I7","v":"Month 7 - overtype"},{"$f":"'Staff Salaries'!J7","v":"Month 8 - overtype"},{"$f":"'Staff Salaries'!K7","v":"Month 9 - overtype"},{"$f":"'Staff Salaries'!L7","v":"Month 10 - overtype"},{"$f":"'Staff Salaries'!M7","v":"Month 11 - overtype"},{"$f":"'Staff Salaries'!N7","v":"Month 12 - overtype"}]
[null,"Income"]
[]
[null,"FEEE1W",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:O13)","v":0}]
[null,"FEEE2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:O14)","v":0}]
[null,"FEEE2W",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D15:O15)","v":0}]
[null,"FEEE 3 - 4",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D16:O16)","v":0}]
[null,"Private Fees for additional hours",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D17:O17)","v":0}]
[null,"Voluntary Meal and Snack Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Voluntary Consumables Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Voluntary Activity Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D20:O20)","v":0}]
[null,"Other - please overtype",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D21:O21)","v":0}]
[]
[null,"TOTAL INCOME ",null,{"$f":"SUM(D13:D21)","v":0},{"$f":"SUM(E13:E21)","v":0},{"$f":"SUM(F13:F21)","v":0},{"$f":"SUM(G13:G21)","v":0},{"$f":"SUM(H13:H21)","v":0},{"$f":"SUM(I13:I21)","v":0},{"$f":"SUM(J13:J21)","v":0},{"$f":"SUM(K13:K21)","v":0},{"$f":"SUM(L13:L21)","v":0},{"$f":"SUM(M13:M21)","v":0},{"$f":"SUM(N13:N21)","v":0},{"$f":"SUM(O13:O21)","v":0},{"$f":"SUM(P13:P21)","v":0}]
[]
[null,"Expenditure"]
[]
[null,"Wages & Salaries",null,{"$f":"'Staff Salaries'!C15","v":0},{"$f":"'Staff Salaries'!D15","v":0},{"$f":"'Staff Salaries'!E15","v":0},{"$f":"'Staff Salaries'!F15","v":0},{"$f":"'Staff Salaries'!G15","v":0},{"$f":"'Staff Salaries'!H15","v":0},{"$f":"'Staff Salaries'!I15","v":0},{"$f":"'Staff Salaries'!J15","v":0},{"$f":"'Staff Salaries'!K15","v":0},{"$f":"'Staff Salaries'!L15","v":0},{"$f":"'Staff Salaries'!M15","v":0},{"$f":"'Staff Salaries'!N15","v":0},{"$f":"SUM(D27:O27)","v":0}]
[null,"Holiday Cover @ 5%",null,{"$f":"D27/100*5","v":0},{"$f":"E27/100*5","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D28:O28)","v":0}]
[null,"Staff  Training @ 1.5%",null,{"$f":"D27/100*1.5","v":0},{"$f":"E27/100*1.5","v":0},{"$f":"F27/100*1.5","v":0},{"$f":"G27/100*1.5","v":0},{"$f":"H27/100*1.5","v":0},{"$f":"I27/100*1.5","v":0},{"$f":"J27/100*1.5","v":0},{"$f":"K27/100*1.5","v":0},{"$f":"L27/100*1.5","v":0},{"$f":"M27/100*1.5","v":0},{"$f":"N27/100*1.5","v":0},{"$f":"O27/100*1.5","v":0},{"$f":"SUM(D29:O29)","v":0}]
[null,"Other ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:O30)","v":0}]
[null,"Total Staff Costs",null,{"$f":"SUM(D27:D30)","v":0},{"$f":"SUM(E27:E30)","v":0},{"$f":"SUM(F27:F30)","v":0},{"$f":"SUM(G27:G30)","v":0},{"$f":"SUM(H27:H30)","v":0},{"$f":"SUM(I27:I30)","v":0},{"$f":"SUM(J27:J30)","v":0},{"$f":"SUM(K27:K30)","v":0},{"$f":"SUM(L27:L30)","v":0},{"$f":"SUM(M27:M30)","v":0},{"$f":"SUM(N27:N30)","v":0},{"$f":"SUM(O27:O30)","v":0},{"$f":"SUM(P27:P30)","v":0}]
[null,"Rent",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D32:O32)","v":0}]
[null,"Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D33:O33)","v":0}]
[null,"Electricity",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D34:O34)","v":0}]
[null,"Gas",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D35:O35)","v":0}]
[null,"Business Rates",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D36:O36)","v":0}]
[null,"Water",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D37:O37)","v":0}]
[null,"Cleaning",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D38:O38)","v":0}]
[null,"Total Premises",null,{"$f":"SUM(D32:D38)","v":0},{"$f":"SUM(E32:E38)","v":0},{"$f":"SUM(F32:F38)","v":0},{"$f":"SUM(G32:G38)","v":0},{"$f":"SUM(H32:H38)","v":0},{"$f":"SUM(I32:I38)","v":0},{"$f":"SUM(J32:J38)","v":0},{"$f":"SUM(K32:K38)","v":0},{"$f":"SUM(L32:L38)","v":0},{"$f":"SUM(M32:M38)","v":0},{"$f":"SUM(N32:N38)","v":0},{"$f":"SUM(O32:O38)","v":0},{"$f":"SUM(P32:P38)","v":0}]
[null,"Building Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D40:O40)","v":0}]
[null,"Contents Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D41:O41)","v":0}]
[null,"Employment Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D42:O42)","v":0}]
[null,"Total Insurance",null,{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P40:P42)","v":0}]
[]
[null,"Administration Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D45:O45)","v":0}]
[null,"Membership Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D46:O46)","v":0}]
[null,"Bank Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D47:O47)","v":0}]
[null,"Professional Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:O48)","v":0}]
[null,"Subscriptions",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:O49)","v":0}]
[null,"Total Administration",null,{"$f":"SUM(D45:D49)","v":0},{"$f":"SUM(E45:E49)","v":0},{"$f":"SUM(F45:F49)","v":0},{"$f":"SUM(G45:G49)","v":0},{"$f":"SUM(H45:H49)","v":0},{"$f":"SUM(I45:I49)","v":0},{"$f":"SUM(J45:J49)","v":0},{"$f":"SUM(K45:K49)","v":0},{"$f":"SUM(L45:L49)","v":0},{"$f":"SUM(M45:M49)","v":0},{"$f":"SUM(N45:N49)","v":0},{"$f":"SUM(O45:O49)","v":0},{"$f":"SUM(P45:P49)","v":0}]
[null,"Consumables",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D51:O51)","v":0}]
[null,"Visits & Trips out ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D52:O52)","v":0}]
[null,"Catering",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D53:O53)","v":0}]
[null,"Misc / Sundries",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D54:O54)","v":0}]
[null,"Repairs & renewals",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D55:O55)","v":0}]
[null,"Total Activity & Material Costs",null,{"$f":"SUM(D51:D55)","v":0},{"$f":"SUM(E51:E55)","v":0},{"$f":"SUM(F51:F55)","v":0},{"$f":"SUM(G51:G55)","v":0},{"$f":"SUM(H51:H55)","v":0},{"$f":"SUM(I51:I55)","v":0},{"$f":"SUM(J51:J55)","v":0},{"$f":"SUM(K51:K55)","v":0},{"$f":"SUM(L51:L55)","v":0},{"$f":"SUM(M51:M55)","v":0},{"$f":"SUM(N51:N55)","v":0},{"$f":"SUM(O51:O55)","v":0},{"$f":"SUM(P51:P55)","v":0}]
[null,"Advertising / Promotions",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D57:O57)","v":0}]
[null,"Total Advertising",null,{"$f":"SUM(D57:D57)","v":0},{"$f":"SUM(E57:E57)","v":0},{"$f":"SUM(F57:F57)","v":0},{"$f":"SUM(G57:G57)","v":0},{"$f":"SUM(H57:H57)","v":0},{"$f":"SUM(I57:I57)","v":0},{"$f":"SUM(J57:J57)","v":0},{"$f":"SUM(K57:K57)","v":0},{"$f":"SUM(L57:L57)","v":0},{"$f":"SUM(M57:M57)","v":0},{"$f":"SUM(N57:N57)","v":0},{"$f":"SUM(O57:O57)","v":0},{"$f":"SUM(P57:P57)","v":0}]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D59:O59)","v":0}]
[null,"Other",null,{"$f":"SUM(D59:D59)","v":0},{"$f":"SUM(E59:E59)","v":0},{"$f":"SUM(F59:F59)","v":0},{"$f":"SUM(G59:G59)","v":0},{"$f":"SUM(H59:H59)","v":0},{"$f":"SUM(I59:I59)","v":0},{"$f":"SUM(J59:J59)","v":0},{"$f":"SUM(K59:K59)","v":0},{"$f":"SUM(L59:L59)","v":0},{"$f":"SUM(M59:M59)","v":0},{"$f":"SUM(N59:N59)","v":0},{"$f":"SUM(O59:O59)","v":0},{"$f":"SUM(P59:P59)","v":0}]
[null,"TOTAL REVENUE EXPENDITURE",null,{"$f":"D31+D39+D43+D50+D56+D58+D60","v":0},{"$f":"E31+E39+E43+E50+E56+E58+E60","v":0},{"$f":"F31+F39+F43+F50+F56+F58+F60","v":0},{"$f":"G31+G39+G43+G50+G56+G58+G60","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Opening balance",null,{"$f":"'CASH FLOW YR 2'!O66","v":0},{"$f":"D66","v":0},{"$f":"E66","v":0},{"$f":"F66","v":0},0,0,{"$f":"I66","v":0},0,0,{"$f":"L66","v":0},0,0,{"$f":"O66","v":0}]
[null,"Total Income",null,{"$f":"D23","v":0},{"$f":"E23","v":0},{"$f":"F23","v":0},{"$f":"G23","v":0},{"$f":"H23","v":0},{"$f":"I23","v":0},{"$f":"J23","v":0},{"$f":"K23","v":0},{"$f":"L23","v":0},{"$f":"M23","v":0},{"$f":"N23","v":0},{"$f":"O23","v":0},{"$f":"SUM(D64:O64)","v":0}]
[null,"Total Expenditure",null,{"$f":"D61","v":0},{"$f":"E61","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D65:O65)","v":0}]
[null,"Closing balance",null,{"$f":"D63+D64-D65","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"O63+O64-O65","v":0}]
[]
[null,{"$f":"IF(D63=0,\"PLEASE ENTER OPENING BALANCE\",\"OPENING BALANCE OK\")","v":"PLEASE ENTER OPENING BALANCE"},null,null,null,null,{"$f":"IF(N68=\"LOSS\",\"WARNING\",\"GOOD NEWS\")","v":"GOOD NEWS"},null,"The cashflow forecast is currently indicating that you will make a",null,null,null,null,{"$f":"IF(P68<0,\"LOSS\",IF(P68>0,\"PROFIT\",IF(P68=0,\"BREAK EVEN\")))","v":"BREAK EVEN"},{"$f":"IF(P65>P64,\"LOSS\",IF(P65<P64,\"PROFIT\",IF(P65=P64,\"BREAK EVEN\")))","v":"BREAK EVEN"},{"$f":"P64-P65","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"]