{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Feasibility Guide - Mod. Cash","Feasibility Guide - Accrual","Primary Fees","Secondary Fees","Feasibility","Cashflow","Comments"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Instructions","index":0,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,0,1,2],[21,0,21,2],[24,0,24,2],[27,0,27,2],[9,2,10,2]]}
[]
["2024 CDF CASHFLOW INSTRUCTIONS"]
[]
["Please use the yellow dropdown boxes to indicate the:"]
[]
["School type:","Primary"]
[]
["Accounting method used:"]
[]
["Fee structure:",null,{"$f":"IF(Fee_Structure=\"Tiered or per child\",\"Please Note: There is a fee calculation tab available for the\nTiered or per child fee structure\",\"\")","v":""}]
[]
["This template consists of six worksheets which appear depending on your selections above"]
[]
["1. Instructions"]
[]
["2. Guide to completing the Feasibility Worksheet - Modified Cash or Accural"]
[]
["3. Primary Fees or Secondary Fees"]
["This worksheet is required if your fee structure is \"Tiered or per child\". The values entered flow into the Cashflow worksheet"]
[]
["4. Feasibility"]
["This worksheet is the input sheet where data is to be entered.  Data is to be obtained from past and current audited Annual Financial Statements (audited AFS actual figures for the three previous years + AFS budget figures) along with budget figures for the two subsequent years.\n\nThe table on the following worksheet provides an outline of where the amounts for each of the items can be obtained from within the Annual Financial Statement."]
[]
["5. Cashflow"]
["This worksheet is a summary of the past, current and budgeted financial position of the school.\n\nIf any discrepancies are detected e.g. the budget figures show a percentage change that is outside the expected range, then the relevant area will be highlighted as per the legend located on the bottom left of the 'Cashflow' worksheet.  In this case, a comment should be provided to explain the discrepancy by clicking on the 'Add Comment' button located on the bottom right of the 'Cashflow' worksheet."]
[]
["6. Comments"]
["This worksheet lists all comments that have been added to explain any discrepancies on the 'Cashflow' worksheet.  This worksheet can also be used to add any additional, explanatory comments."]

{"sheet":"Feasibility Guide - Mod. Cash","index":1,"n_rows":69,"n_cols":5,"rows_kept":69,"cut":false,"hidden":true,"merged":[[3,1,4,2],[1,1,1,4]]}
[]
[null,"GUIDE TO COMPLETING THE FEASIBILITY WORKSHEET - MODIFIED CASH"]
[]
[null,null,null,"ACTUAL/BUDGET","Subtotal"]
[null,null,null,"YEAR 20XX ($)","Ref in AFS"]
[null,"Number of students",null,"From AFS Notes to Page 1"]
[null,"Number of families",null,"From AFS Notes to Page 1"]
[]
[null,"Annual fees"]
[null,"Tuition ",null,"Per family fee from AFS Notes to Page 1. If tiered or per child structure, perform the appropriate calculation by using the Fees tab."]
[null,"Capital  ",null,"Per family fee from AFS Notes to Page 1. If tiered or per child structure, perform the appropriate calculation by using the Fees tab."]
[null,"Total fees",null,"This is a calculated field (Tuition fee + Capital fee)."]
[]
[null,"Total collection rate",null,"This is a calculated field (Total fees collected / Total fees)."]
[]
[null,"Recurrent Income"]
[null,"Fees received",null,"Sum of  AFS accounts  0110"]
[null,"Government grants",null,"Sum of AFS accounts 0600, 0610 to 0624, 0627, 0650, 0651, 0660 to 0667, 0671 and 0675"]
[null,"Parish contribution and school building fund- recurrent",null,"Sum of AFS accounts 0540 and 0710"]
[null,"\nOther recurrent income (ORI)",null,"Sum of the remainder of the AFS recurrent income accounts\n0420, 0120, 0115, 0310, 0122, 0425, 0435, 0450, 0510, 0520, 0541, 0550, 0715, 0720, 0910 & 0915 & \n8075, 0445, 0460, 0465, 0470, 0480 & 8095 "]
[null,"Total Recurrent Income",null,"This is a calculated field (Sum of recurrent income)","A1"]
[null,"Recurrent Expenditure"]
[null,"Salaries",null,"Sum of AFS accounts 1030 to 1035,  1040 to 1048, 1950,1960, 1970 1990, 1910 & 1850"]
[null,"Interest expense",null,"Sum of AFS Accounts 2910, 2920 and 2940."]
[null,"Other recurrent expenditure (ORC)",null,"Sum of remainder of the AFS accounts   1980 to 2972 and 2810 (RE.080)\n& 2012, 2014,2015,2025, 2035, 2045, 2050, 2061, 2070 (RE.090)  \n& 2060, 2063 (RE.095) & 2990 (RE.085)\n& 2601, 2602, 9510, 1050, 1051, 1052, 2486 to 2489, 2500 and 8096."]
[null,"Total Recurrent Expenditure",null,"This is a calculated field (Sum of recurrent expenditure)","A3"]
[null,"Recurrent surplus/deficit",null,"This is a calculated field (Total Recur. Income - Total Recur. Expenditure)","A7"]
[null,"Capital Income"]
[null,"Capital grant",null,"Sum of AFS accounts 0680 to 0693"]
[null,"Fees",null,"Equal or portion of AFS account 0925"]
[null,"Levies (if applicable)",null,"Amount collected specifically to assist with loan repayments, equal or portion of AFS account 0925 "]
[null,"Donations and sale of assets",null,"Sum of AFS account 0730 and 0820"]
[null,"School building and library funds",null,"Sum of AFS accounts 0731 and 0732"]
[null,"Parish contribution",null,"Equal to AFS account 0733"]
[null,"Interest",null,"Sum of AFS accounts 0734"]
[null,"New borrowings",null,"Equal to AFS account 0952"]
[null,"Bridging finance -  temporary loan",null,"Equal to AFS account 0953"]
[null,"Borrowings from parents loan scheme",null,"Equal to AFS account 8110"]
[null,"Receipts from diocesan capital fund (SCF)",null,"Equal to AFS account 0999"]
[null,"Other capital receipts",null,"Sum of remaining A5 AFS accounts 0735 to 0745, 8097, 0920 and 0930"]
[null,"Total Capital Income",null,"This is a calculated field (Sum of Capital Income)","A5"]
[null,"Capital Expenditure"]
[null,"Land, buildings and improvements",null,"Sum of AFS accounts 5010, 5110 and 5150"]
[null,"Furniture and equipment, library books",null,"Sum of AFS accounts 5210, 5220 and 5230"]
[null,"Motor vehicles, plant and machinery",null,"Sum of AFS accounts 5310 and 5410"]
[null,"Principal component of lease expense",null,"Equal to AFS account 5510"]
[null,"Loan repayments",null,"Equal to AFS account 9520"]
[null,"Bridging finance -  loan repayment",null,"Equal to AFS account 9540"]
[null,"Payment to parents loan scheme",null,"Equal to AFS account 9530"]
[null,"Diocesan capital fund levy",null,"Sum of AFS accounts 5689 (Country Diocese Capital Fund) and 5699"]
[null,"Other applications of capital",null,"Equal to the AFS account 5600"]
[null,"Total capital expenditure",null,"This is a calculated field (Sum of Capital Expenditure)","A6"]
[null,"Capital surplus/deficit",null,"This is a calculated field (Total Capital Income - Total Cap. Expenditure)","A8"]
[null,"Total surplus/deficit",null,"This is a calculated field \n(Sum of Recurr. Surplus/Deficit and Capital Surplus/Deficit)","A9"]
[null,"Bank balance"]
[null,"Adjusted bank balance – as at 31 December/January",null,"Adjusted bank balance as at 31 December/January as per page 7 of the AFS (Item (N) - Adjusted bank balances)","AFS pg 7"]
[null,"Less: Commit to Spend",null,"Equal to the amount of Commit to Spend for the year (may be found on Remittance Slips sent to the school.  The following programs may have sent prepayment of salaries: LNSLN, NCCD, State, GRG and Literacy.  If in doubt, please contact the finance helpdesk on (03) 9267 0319 or <financehelpdesk@ceomelb.catholic.edu.au>.)"]
[null,"Closing balance",null,"This is a calculated field ('Adjusted bank balance - as at 31 December/January' - Prepaid salaries)"]
[null,"Adjusted closing balance/total recurrent income",null,"This is a calculated field (Closing Balance / Total Recur. Income)"]
[null,"DEBT"]
[null,"Closing balance – as at 31 December/January",null,"For the first 'Actual' input year, this equals the closing loan balance as per AFS page 8.  For subsequent years, this is a calculated field (Previous years closing debt balance + 'New Borrowings' + 'Bridging finance - temporary loan' - 'Loan repayments')","AFS pg 8 loan bal 31/12/xx"]
[null,"Debt per pupil",null,"This is a calculated field \n('Closing Balance - as at 31 December/January' / 'Number of Students')"]
[]
[null,"Additional information"]
[null,"Bridging Finance",null,"From AFS Notes to Page 10"]
[null,"Other reserves (Investment accounts for specific purposes)",null,"From AFS Notes to Page 11"]
[null,"School building fund – as at 31 December/January",null,"From AFS Notes to Page 11"]
[null,"School library fund – as at 31 December/January",null,"From AFS Notes to Page 11"]
[null,"Parents loan scheme",null,"From AFS Notes to Page 11"]

{"sheet":"Feasibility Guide - Accrual","index":2,"n_rows":85,"n_cols":5,"rows_kept":85,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,4,2],[62,3,68,3]]}
[]
[null,"GUIDE TO COMPLETING THE FEASIBILITY WORKSHEET - ACCRUAL"]
[]
[null,"School Location and Name",null,"ACTUAL/BUDGET","Subtotal"]
[null,null,null,"YEAR 20XX ($)","Ref in AFS"]
[null,"Number of students",null,"From  AFS Notes to Page 1"]
[null,"Number of families",null,"From  AFS Notes to Page 1"]
[]
[null,"Annual fees "]
[null,"Tuition ",null,"Per family fee from  AFS Notes to Page 1. If tiered or per child structure, perform the appropriate calculation by using the Fees tab."]
[null,"Capital  ",null,"Per family fee from AFS Notes to Page 1. If tiered or per child structure, perform the appropriate calculation by using the Fees tab."]
[null,"Total fees",null,"This is a calculated field (Tuition fee + Capital fee)."]
[]
[null,"Total collection rate",null,"This is a calculated field (Total fees collected / Total fees)."]
[]
[null,"Recurrent Income"]
[null,"Fees received",null,"Sum of  AFS accounts  0110"]
[null,"Government grants",null,"Sum of AFS accounts 0600, 0610 to 0624, 0627, 0650, 0660 to 0667, 0671 and 0675"]
[null,"Parish contribution and school building fund- recurrent",null,"Sum of AFS accounts 0540 and 0710"]
[null,"\nOther recurrent income (ORI)",null,"Sum of the remainder of the AFS recurrent income accounts\n0420, 0120, 0115, 0310, 0122, 0425, 0435, 0450, 0510, 0520, 0541, 0550, 0715, 0720, 0910 & 0915 \n8075, 0445, 0460, 0465, 0470, 0480 & 8095 "]
[null,"Total Recurrent Income",null,"This is a calculated field (Sum of recurrent income)","A1"]
[null,"Recurrent Expenditure"]
[null,"Salaries",null,"Sum of AFS accounts 1030 to 1035,  1040 to 1048, 1950,1960, 1970 1990, 1910 & 1850"]
[null,"Interest expense",null,"Sum of AFS Accounts 2910, 2920 and 2940."]
[null,"Other recurrent expenditure (ORC)",null,"Sum of remainder of the AFS accounts   1980 to 2972 and 2810 (RE.080)\n& 2012, 2014,2015,2025, 2035, 2045, 2050, 2061, 2062, 2070 (RE.090)  \n& 2060, 2063 (RE.095) & 2990 (RE.085) & 2720, 2730 (RE.130) and 2840 (RE.140)\n& 2601, 2602, 9510, 1050, 1051, 1052, 2486 to 2489, 2500 and 8096."]
[null,"Total Recurrent Expenditure",null,"This is a calculated field (Sum of recurrent expenditure)","A3"]
[null,"Less:  Depreciation / Band & Doubtful Debt Expense",null,"Equal to AFS account 2720, 2730 (RE.130) and 2840 (RE.140)"]
[null,"Recurrent surplus/deficit",null,"This is a calculated field (Total Recur. Income - Total Recur. Expenditure + Depreciation)","A7"]
[]
[null,"Capital Income"]
[null,"Capital grant",null,"Sum of AFS accounts 0680 to 0691"]
[null,"Fees (General Capital Fee collected)",null,"General Capital Fee collected, equal or portion of AFS account 0925"]
[null,"Levies (if applicable)",null,"Amount collected specifically to assist with loan repayments, equal or portion of AFS account 0925 "]
[null,"Donations and profits from the disposal of fixed assets",null,"Sum of AFS account 0730 and 0820"]
[null,"School building and library funds",null,"Sum of AFS accounts 0731 and 0732"]
[null,"Parish contribution",null,"Equal to AFS account 0733"]
[null,"Interest",null,"Sum of AFS accounts 0734"]
[null,"New borrowings",null,"Equal to AFS account 0952"]
[null,"Bridging finance -  temporary loan",null,"Equal to AFS account 0953"]
[null,"Borrowings from parents loan scheme",null,"Equal to AFS account 8110"]
[null,"Receipts from diocesan capital fund (SCF)",null,"Equal to AFS account 0999"]
[null,"Lease Liabilities Additions ",null,"Equal to AFS account 0954"]
[null,"Other capital receipts",null,"Sum of remaining A5 AFS accounts 0735 to 0745, 8097, 0920 and 0930"]
[null,"Total Capital Income",null,"This is a calculated field (Sum of Capital Income)","A5"]
[]
[null,"Capital Expenditure"]
[null,"Land, buildings and improvements",null,"Sum of AFS accounts 5010, 5110, 5120 and 5150"]
[null,"Furniture and equipment, library books",null,"Sum of AFS accounts 5210, 5220 and 5230"]
[null,"Motor vehicles, plant and machinery",null,"Sum of AFS accounts 5310 and 5410"]
[null,"Principal component of lease expense",null,"Equal to AFS account 5510"]
[null,"Loan repayments",null,"Equal to AFS account 9520"]
[null,"Bridging finance -  loan repayment",null,"Equal to AFS account 9540"]
[null,"Payment to parents loan scheme",null,"Equal to AFS account 9530"]
[null,"Diocesan capital fund levy",null,"Sum of AFS accounts 5689 (Country Diocese Capital Fund) and 5699"]
[null,"Repayments - Lease liabilities (excluding lease interest)",null,"Equal to AFS account 9550"]
[null,"Other applications of capital",null,"Equal to the AFS account 5600"]
[null,"Total capital expenditure",null,"  This is a calculated field (Sum of Capital Expenditure)","A6"]
[null,"Capital surplus/deficit",null,"This is a calculated field (Total Capital Income - Total Cap. Expenditure)","A8"]
[]
[null,"Total surplus/deficit",null,"This is a calculated field (Sum of Recurr. Surplus/Deficit and Capital Surplus/Deficit)","A9"]
[]
[null,"Bank balance"]
[null,"Cash on hand - petty cash",null,"As per AFS Page Accrual Balance Sheet (Statement of Financial Position)","AFS"]
[null,"General bank account"]
[null,"Other investment accounts",null,null,"Accrual"]
[null,"Family debtors",null,null,"Balance"]
[null,"Sundry debtors",null,null,"Sheet"]
[null,"Less: Fees and levies received in advance"]
[null,"Less: Grants received in advance/Commit to Spend"]
[null,"Less: Accrued Leave and Salary Entitlements"]
[null,"Less: Accounts payable, accruals and clearing accounts",null,"As per AFS Accrual Balance Sheet (Statement of Financial Position), from 2007 onwards"]
[null,"Adjusted Closing balance",null,"This is a calculated field ('Cash on hand - petty cash' + 'General bank account' + 'Other investment accounts' + 'Family debtors' + 'Sundry debtors' - 'Fees and levies received in advance' - 'Grants received in advance' - 'Accrued Leave and Salary Entitlements' - 'Accounts payable, accruals and clearing accounts')"]
[null,"Adjusted closing balance/total recurrent income",null,"This is a calculated field (Closing Balance / Total Recur. Income)"]
[null,"Working capital (current assets - current liabilities)",null,"As per AFS Page Accrual Balance Sheet (Statement of Financial Position)"]
[null,"DEBT"]
[null,"Closing balance – as at 31 December/January",null,"For the first 'Actual' input year, this equals the closing loan balance as per AFS page 8.  For subsequent years, this is a calculated field (Previous years closing debt balance + 'New Borrowings' + 'Bridging finance - temporary loan' - 'Loan repayments')","AFS pg 8 loan bal 31/12/xx"]
[null,"Debt per pupil",null,"This is a calculated field ('Closing Balance - as at 31 December/January' / 'Number of Students')"]
[]
[null,"Additional information"]
[null,"Bridging Finance",null,"From AFS Notes to Page 10"]
[null,"Other reserves (Investment accounts for specific purposes)",null,"From AFS Notes to Page 11"]
[null,"School building fund – as at 31 December/January",null,"From AFS Notes to Page 11"]
[null,"School library fund – as at 31 December/January",null,"From AFS Notes to Page 11"]
[null,"Parents loan scheme",null,"From AFS Notes to Page 11"]
[null," "]

{"sheet":"Primary Fees","index":3,"n_rows":184,"n_cols":8,"rows_kept":184,"cut":false,"hidden":true,"merged":[]}
[]
[null,{"$f":"Feasibility!D3","v":2023},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C4*D4","v":0},{"$f":"C4*E4","v":0},{"$f":"SUM(F4:G4)","v":0}]
[null,"Total (A)",{"$f":"C4","v":0},null,null,{"$f":"SUM(F4)","v":0},{"$f":"SUM(G4)","v":0},{"$f":"SUM(H4)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C6*D6","v":0},{"$f":"C6*E6","v":0},{"$f":"SUM(F6:G6)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C7*D7","v":0},{"$f":"C7*E7","v":0},{"$f":"SUM(F7:G7)","v":0}]
[null,"Total (B)",{"$f":"SUM(C6:C7)","v":0},null,null,{"$f":"SUM(F6:F7)","v":0},{"$f":"SUM(G6:G7)","v":0},{"$f":"SUM(H6:H7)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C9*D9","v":0},{"$f":"C9*E9","v":0},{"$f":"SUM(F9:G9)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C10*D10","v":0},{"$f":"C10*E10","v":0},{"$f":"SUM(F10:G10)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C11*D11","v":0},{"$f":"C11*E11","v":0},{"$f":"SUM(F11:G11)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C12*D12","v":0},{"$f":"C12*E12","v":0},{"$f":"SUM(F12:G12)","v":0}]
[null,"Total (C )",{"$f":"SUM(C9:C12)","v":0},null,null,{"$f":"SUM(F9:F12)","v":0},{"$f":"SUM(G9:G12)","v":0},{"$f":"SUM(H9:H12)","v":0}]
[null,null,"Enrolments"]
[null,"Prep",null,0,0,{"$f":"C15*D15","v":0},{"$f":"C15*E15","v":0},{"$f":"SUM(F15:G15)","v":0}]
[null,"Year 1",null,0,0,0,0,0]
[null,"Year 2",null,0,0,0,0,0]
[null,"Year 3",null,0,0,0,0,0]
[null,"Year 4",null,0,0,{"$f":"C19*D19","v":0},{"$f":"C19*E19","v":0},{"$f":"SUM(F19:G19)","v":0}]
[null,"Year 5",null,0,0,0,0,0]
[null,"Year 6",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C15:C21)","v":0},null,null,{"$f":"SUM(F15:F21)","v":0},{"$f":"SUM(G15:G21)","v":0},{"$f":"SUM(H15:H21)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F5+F8+F13+F22","v":0},{"$f":"G5+G8+G13+G22","v":0},{"$f":"H5+H8+H13+H22","v":0}]
[]
[null,{"$f":"Feasibility!E3","v":2024},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C27*D27","v":0},{"$f":"C27*E27","v":0},{"$f":"SUM(F27:G27)","v":0}]
[null,"Total (A)",{"$f":"C27","v":0},null,null,{"$f":"SUM(F27)","v":0},{"$f":"SUM(G27)","v":0},{"$f":"SUM(H27)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C29*D29","v":0},{"$f":"C29*E29","v":0},{"$f":"SUM(F29:G29)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C30*D30","v":0},{"$f":"C30*E30","v":0},{"$f":"SUM(F30:G30)","v":0}]
[null,"Total (B)",{"$f":"SUM(C29:C30)","v":0},null,null,{"$f":"SUM(F29:F30)","v":0},{"$f":"SUM(G29:G30)","v":0},{"$f":"SUM(H29:H30)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C32*D32","v":0},{"$f":"C32*E32","v":0},{"$f":"SUM(F32:G32)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C33*D33","v":0},{"$f":"C33*E33","v":0},{"$f":"SUM(F33:G33)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C34*D34","v":0},{"$f":"C34*E34","v":0},{"$f":"SUM(F34:G34)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C35*D35","v":0},{"$f":"C35*E35","v":0},{"$f":"SUM(F35:G35)","v":0}]
[null,"Total (C )",{"$f":"SUM(C32:C35)","v":0},null,null,{"$f":"SUM(F32:F35)","v":0},{"$f":"SUM(G32:G35)","v":0},{"$f":"SUM(H32:H35)","v":0}]
[null,null,"Enrolments"]
[null,"Prep",null,0,0,{"$f":"C38*D38","v":0},{"$f":"C38*E38","v":0},{"$f":"SUM(F38:G38)","v":0}]
[null,"Year 1",null,0,0,0,0,0]
[null,"Year 2",null,0,0,0,0,0]
[null,"Year 3",null,0,0,{"$f":"C41*D41","v":0},{"$f":"C41*E41","v":0},{"$f":"SUM(F41:G41)","v":0}]
[null,"Year 4",null,0,0,0,0,0]
[null,"Year 5",null,0,0,0,0,0]
[null,"Year 6",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C38:C44)","v":0},null,null,{"$f":"SUM(F38:F44)","v":0},{"$f":"SUM(G38:G44)","v":0},{"$f":"SUM(H38:H44)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F28+F31+F36+F45","v":0},{"$f":"G28+G31+G36+G45","v":0},{"$f":"H28+H31+H36+H45","v":0}]
[]
[null,{"$f":"Feasibility!F3","v":2025},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C50*D50","v":0},{"$f":"C50*E50","v":0},{"$f":"SUM(F50:G50)","v":0}]
[null,"Total (A)",{"$f":"C50","v":0},null,null,{"$f":"SUM(F50)","v":0},{"$f":"SUM(G50)","v":0},{"$f":"SUM(H50)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C52*D52","v":0},{"$f":"C52*E52","v":0},{"$f":"SUM(F52:G52)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C53*D53","v":0},{"$f":"C53*E53","v":0},{"$f":"SUM(F53:G53)","v":0}]
[null,"Total (B)",{"$f":"SUM(C52:C53)","v":0},null,null,{"$f":"SUM(F52:F53)","v":0},{"$f":"SUM(G52:G53)","v":0},{"$f":"SUM(H52:H53)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C55*D55","v":0},{"$f":"C55*E55","v":0},{"$f":"SUM(F55:G55)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C56*D56","v":0},{"$f":"C56*E56","v":0},{"$f":"SUM(F56:G56)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C57*D57","v":0},{"$f":"C57*E57","v":0},{"$f":"SUM(F57:G57)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C58*D58","v":0},{"$f":"C58*E58","v":0},{"$f":"SUM(F58:G58)","v":0}]
[null,"Total (C )",{"$f":"SUM(C55:C58)","v":0},null,null,{"$f":"SUM(F55:F58)","v":0},{"$f":"SUM(G55:G58)","v":0},{"$f":"SUM(H55:H58)","v":0}]
[null,null,"Enrolments"]
[null,"Prep",null,0,0,{"$f":"C61*D61","v":0},{"$f":"C61*E61","v":0},{"$f":"SUM(F61:G61)","v":0}]
[null,"Year 1",null,0,0,0,0,0]
[null,"Year 2",null,0,0,{"$f":"C63*D63","v":0},{"$f":"C63*E63","v":0},{"$f":"SUM(F63:G63)","v":0}]
[null,"Year 3",null,0,0,0,0,0]
[null,"Year 4",null,0,0,0,0,0]
[null,"Year 5",null,0,0,0,0,0]
[null,"Year 6",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C61:C67)","v":0},null,null,{"$f":"SUM(F61:F67)","v":0},{"$f":"SUM(G61:G67)","v":0},{"$f":"SUM(H61:H67)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F51+F54+F59+F68","v":0},{"$f":"G51+G54+G59+G68","v":0},{"$f":"H51+H54+H59+H68","v":0}]
[]
[null,{"$f":"Feasibility!G3","v":2026},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C73*D73","v":0},{"$f":"C73*E73","v":0},{"$f":"SUM(F73:G73)","v":0}]
[null,"Total (A)",{"$f":"C73","v":0},null,null,{"$f":"SUM(F73)","v":0},{"$f":"SUM(G73)","v":0},{"$f":"SUM(H73)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C75*D75","v":0},{"$f":"C75*E75","v":0},{"$f":"SUM(F75:G75)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C76*D76","v":0},{"$f":"C76*E76","v":0},{"$f":"SUM(F76:G76)","v":0}]
[null,"Total (B)",{"$f":"SUM(C75:C76)","v":0},null,null,{"$f":"SUM(F75:F76)","v":0},{"$f":"SUM(G75:G76)","v":0},{"$f":"SUM(H75:H76)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C78*D78","v":0},{"$f":"C78*E78","v":0},{"$f":"SUM(F78:G78)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C79*D79","v":0},{"$f":"C79*E79","v":0},{"$f":"SUM(F79:G79)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C80*D80","v":0},{"$f":"C80*E80","v":0},{"$f":"SUM(F80:G80)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C81*D81","v":0},{"$f":"C81*E81","v":0},{"$f":"SUM(F81:G81)","v":0}]
[null,"Total (C )",{"$f":"SUM(C78:C81)","v":0},null,null,{"$f":"SUM(F78:F81)","v":0},{"$f":"SUM(G78:G81)","v":0},{"$f":"SUM(H78:H81)","v":0}]
[null,null,"Enrolments"]
[null,"Prep",null,0,0,{"$f":"C84*D84","v":0},{"$f":"C84*E84","v":0},{"$f":"SUM(F84:G84)","v":0}]
[null,"Year 1",null,0,0,0,0,0]
[null,"Year 2",null,0,0,{"$f":"C86*D86","v":0},{"$f":"C86*E86","v":0},{"$f":"SUM(F86:G86)","v":0}]
[null,"Year 3",null,0,0,0,0,0]
[null,"Year 4",null,0,0,0,0,0]
[null,"Year 5",null,0,0,0,0,0]
[null,"Year 6",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C84:C90)","v":0},null,null,{"$f":"SUM(F84:F90)","v":0},{"$f":"SUM(G84:G90)","v":0},{"$f":"SUM(H84:H90)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F74+F77+F82+F91","v":0},{"$f":"G74+G77+G82+G91","v":0},{"$f":"H74+H77+H82+H91","v":0}]
[]
[null,{"$f":"Feasibility!H3","v":2027},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C96*D96","v":0},{"$f":"C96*E96","v":0},{"$f":"SUM(F96:G96)","v":0}]
[null,"Total (A)",{"$f":"C96","v":0},null,null,{"$f":"SUM(F96)","v":0},{"$f":"SUM(G96)","v":0},{"$f":"SUM(H96)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C98*D98","v":0},{"$f":"C98*E98","v":0},{"$f":"SUM(F98:G98)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C99*D99","v":0},{"$f":"C99*E99","v":0},{"$f":"SUM(F99:G99)","v":0}]
[null,"Total (B)",{"$f":"SUM(C98:C99)","v":0},null,null,{"$f":"SUM(F98:F99)","v":0},{"$f":"SUM(G98:G99)","v":0},{"$f":"SUM(H98:H99)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C101*D101","v":0},{"$f":"C101*E101","v":0},{"$f":"SUM(F101:G101)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C102*D102","v":0},{"$f":"C102*E102","v":0},{"$f":"SUM(F102:G102)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C103*D103","v":0},{"$f":"C103*E103","v":0},{"$f":"SUM(F103:G103)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C104*D104","v":0},{"$f":"C104*E104","v":0},{"$f":"SUM(F104:G104)","v":0}]
[null,"Total (C )",{"$f":"SUM(C101:C104)","v":0},null,null,{"$f":"SUM(F101:F104)","v":0},{"$f":"SUM(G101:G104)","v":0},{"$f":"SUM(H101:H104)","v":0}]
[null,null,"Enrolments"]
[null,"Prep",null,0,0,{"$f":"C107*D107","v":0},{"$f":"C107*E107","v":0},{"$f":"SUM(F107:G107)","v":0}]
[null,"Year 1",null,0,0,0,0,0]
[null,"Year 2",null,0,0,0,0,0]
[null,"Year 3",null,0,0,0,0,0]
[null,"Year 4",null,0,0,0,0,0]
[null,"Year 5",null,0,0,0,0,0]
[null,"Year 6",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C107:C113)","v":0},null,null,{"$f":"SUM(F107:F113)","v":0},{"$f":"SUM(G107:G113)","v":0},{"$f":"SUM(H107:H113)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F97+F100+F105+F114","v":0},{"$f":"G97+G100+G105+G114","v":0},{"$f":"H97+H100+H105+H114","v":0}]
[]
[null,{"$f":"Feasibility!I3","v":2028},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C119*D119","v":0},{"$f":"C119*E119","v":0},{"$f":"SUM(F119:G119)","v":0}]
[null,"Total (A)",{"$f":"C119","v":0},null,null,{"$f":"SUM(F119)","v":0},{"$f":"SUM(G119)","v":0},{"$f":"SUM(H119)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C121*D121","v":0},{"$f":"C121*E121","v":0},{"$f":"SUM(F121:G121)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C122*D122","v":0},{"$f":"C122*E122","v":0},{"$f":"SUM(F122:G122)","v":0}]
[null,"Total (B)",{"$f":"SUM(C121:C122)","v":0},null,null,{"$f":"SUM(F121:F122)","v":0},{"$f":"SUM(G121:G122)","v":0},{"$f":"SUM(H121:H122)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C124*D124","v":0},{"$f":"C124*E124","v":0},{"$f":"SUM(F124:G124)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C125*D125","v":0},{"$f":"C125*E125","v":0},{"$f":"SUM(F125:G125)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C126*D126","v":0},{"$f":"C126*E126","v":0},{"$f":"SUM(F126:G126)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C127*D127","v":0},{"$f":"C127*E127","v":0},{"$f":"SUM(F127:G127)","v":0}]
[null,"Total (C )",{"$f":"SUM(C124:C127)","v":0},null,null,{"$f":"SUM(F124:F127)","v":0},{"$f":"SUM(G124:G127)","v":0},{"$f":"SUM(H124:H127)","v":0}]
[null,null,"Enrolments"]
[null,"Prep",null,0,0,{"$f":"C130*D130","v":0},{"$f":"C130*E130","v":0},{"$f":"SUM(F130:G130)","v":0}]
[null,"Year 1",null,0,0,0,0,0]
[null,"Year 2",null,0,0,0,0,0]
[null,"Year 3",null,0,0,0,0,0]
[null,"Year 4",null,0,0,0,0,0]
[null,"Year 5",null,0,0,0,0,0]
[null,"Year 6",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C130:C136)","v":0},null,null,{"$f":"SUM(F130:F136)","v":0},{"$f":"SUM(G130:G136)","v":0},{"$f":"SUM(H130:H136)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F120+F123+F128+F137","v":0},{"$f":"G120+G123+G128+G137","v":0},{"$f":"H120+H123+H128+H137","v":0}]
[]
[null,{"$f":"Feasibility!J3","v":2029},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C142*D142","v":0},{"$f":"C142*E142","v":0},{"$f":"SUM(F142:G142)","v":0}]
[null,"Total (A)",{"$f":"C142","v":0},null,null,{"$f":"SUM(F142)","v":0},{"$f":"SUM(G142)","v":0},{"$f":"SUM(H142)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C144*D144","v":0},{"$f":"C144*E144","v":0},{"$f":"SUM(F144:G144)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C145*D145","v":0},{"$f":"C145*E145","v":0},{"$f":"SUM(F145:G145)","v":0}]
[null,"Total (B)",{"$f":"SUM(C144:C145)","v":0},null,null,{"$f":"SUM(F144:F145)","v":0},{"$f":"SUM(G144:G145)","v":0},{"$f":"SUM(H144:H145)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C147*D147","v":0},{"$f":"C147*E147","v":0},{"$f":"SUM(F147:G147)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C148*D148","v":0},{"$f":"C148*E148","v":0},{"$f":"SUM(F148:G148)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C149*D149","v":0},{"$f":"C149*E149","v":0},{"$f":"SUM(F149:G149)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C150*D150","v":0},{"$f":"C150*E150","v":0},{"$f":"SUM(F150:G150)","v":0}]
[null,"Total (C )",{"$f":"SUM(C147:C150)","v":0},null,null,{"$f":"SUM(F147:F150)","v":0},{"$f":"SUM(G147:G150)","v":0},{"$f":"SUM(H147:H150)","v":0}]
[null,null,"Enrolments"]
[null,"Prep",null,0,0,{"$f":"C153*D153","v":0},{"$f":"C153*E153","v":0},{"$f":"SUM(F153:G153)","v":0}]
[null,"Year 1",null,0,0,0,0,0]
[null,"Year 2",null,0,0,0,0,0]
[null,"Year 3",null,0,0,0,0,0]
[null,"Year 4",null,0,0,0,0,0]
[null,"Year 5",null,0,0,0,0,0]
[null,"Year 6",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C153:C159)","v":0},null,null,{"$f":"SUM(F153:F159)","v":0},{"$f":"SUM(G153:G159)","v":0},{"$f":"SUM(H153:H159)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F143+F146+F151+F160","v":0},{"$f":"G143+G146+G151+G160","v":0},{"$f":"H143+H146+H151+H160","v":0}]
[]
[null,{"$f":"Feasibility!K3","v":2030},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C165*D165","v":0},{"$f":"C165*E165","v":0},{"$f":"SUM(F165:G165)","v":0}]
[null,"Total (A)",{"$f":"C165","v":0},null,null,{"$f":"SUM(F165)","v":0},{"$f":"SUM(G165)","v":0},{"$f":"SUM(H165)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C167*D167","v":0},{"$f":"C167*E167","v":0},{"$f":"SUM(F167:G167)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C168*D168","v":0},{"$f":"C168*E168","v":0},{"$f":"SUM(F168:G168)","v":0}]
[null,"Total (B)",{"$f":"SUM(C167:C168)","v":0},null,null,{"$f":"SUM(F167:F168)","v":0},{"$f":"SUM(G167:G168)","v":0},{"$f":"SUM(H167:H168)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C170*D170","v":0},{"$f":"C170*E170","v":0},{"$f":"SUM(F170:G170)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C171*D171","v":0},{"$f":"C171*E171","v":0},{"$f":"SUM(F171:G171)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C172*D172","v":0},{"$f":"C172*E172","v":0},{"$f":"SUM(F172:G172)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C173*D173","v":0},{"$f":"C173*E173","v":0},{"$f":"SUM(F173:G173)","v":0}]
[null,"Total (C )",{"$f":"SUM(C170:C173)","v":0},null,null,{"$f":"SUM(F170:F173)","v":0},{"$f":"SUM(G170:G173)","v":0},{"$f":"SUM(H170:H173)","v":0}]
[null,null,"Enrolments"]
[null,"Prep",null,0,0,{"$f":"C176*D176","v":0},{"$f":"C176*E176","v":0},{"$f":"SUM(F176:G176)","v":0}]
[null,"Year 1",null,0,0,0,0,0]
[null,"Year 2",null,0,0,0,0,0]
[null,"Year 3",null,0,0,0,0,0]
[null,"Year 4",null,0,0,0,0,0]
[null,"Year 5",null,0,0,0,0,0]
[null,"Year 6",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C176:C182)","v":0},null,null,{"$f":"SUM(F176:F182)","v":0},{"$f":"SUM(G176:G182)","v":0},{"$f":"SUM(H176:H182)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F166+F169+F174+F183","v":0},{"$f":"G166+G169+G174+G183","v":0},{"$f":"H166+H169+H174+H183","v":0}]

{"sheet":"Secondary Fees","index":4,"n_rows":176,"n_cols":8,"rows_kept":176,"cut":false,"hidden":true,"merged":[]}
[]
[null,{"$f":"Feasibility!D3","v":2023},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C4*D4","v":0},{"$f":"C4*E4","v":0},{"$f":"SUM(F4:G4)","v":0}]
[null,"Total (A)",{"$f":"C4","v":0},null,null,{"$f":"SUM(F4)","v":0},{"$f":"SUM(G4)","v":0},{"$f":"SUM(H4)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C6*D6","v":0},{"$f":"C6*E6","v":0},{"$f":"SUM(F6:G6)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C7*D7","v":0},{"$f":"C7*E7","v":0},{"$f":"SUM(F7:G7)","v":0}]
[null,"Total (B)",{"$f":"SUM(C6:C7)","v":0},null,null,{"$f":"SUM(F6:F7)","v":0},{"$f":"SUM(G6:G7)","v":0},{"$f":"SUM(H6:H7)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C9*D9","v":0},{"$f":"C9*E9","v":0},{"$f":"SUM(F9:G9)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C10*D10","v":0},{"$f":"C10*E10","v":0},{"$f":"SUM(F10:G10)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C11*D11","v":0},{"$f":"C11*E11","v":0},{"$f":"SUM(F11:G11)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C12*D12","v":0},{"$f":"C12*E12","v":0},{"$f":"SUM(F12:G12)","v":0}]
[null,"Total (C )",{"$f":"SUM(C9:C12)","v":0},null,null,{"$f":"SUM(F9:F12)","v":0},{"$f":"SUM(G9:G12)","v":0},{"$f":"SUM(H9:H12)","v":0}]
[null,null,"Enrolments"]
[null,"Year 7",null,0,0,{"$f":"C15*D15","v":0},{"$f":"C15*E15","v":0},{"$f":"SUM(F15:G15)","v":0}]
[null,"Year 8",null,0,0,0,0,0]
[null,"Year 9",null,0,0,0,0,0]
[null,"Year 10",null,0,0,0,0,0]
[null,"Year 11",null,0,0,0,0,0]
[null,"Year 12",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C15:C20)","v":0},null,null,{"$f":"SUM(F15:F20)","v":0},{"$f":"SUM(G15:G20)","v":0},{"$f":"SUM(H15:H20)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F5+F8+F13+F21","v":0},{"$f":"G5+G8+G13+G21","v":0},{"$f":"H5+H8+H13+H21","v":0}]
[]
[null,{"$f":"B2+1","v":2024},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C26*D26","v":0},{"$f":"C26*E26","v":0},{"$f":"SUM(F26:G26)","v":0}]
[null,"Total (A)",{"$f":"C26","v":0},null,null,{"$f":"SUM(F26)","v":0},{"$f":"SUM(G26)","v":0},{"$f":"SUM(H26)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C28*D28","v":0},{"$f":"C28*E28","v":0},{"$f":"SUM(F28:G28)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C29*D29","v":0},{"$f":"C29*E29","v":0},{"$f":"SUM(F29:G29)","v":0}]
[null,"Total (B)",{"$f":"SUM(C28:C29)","v":0},null,null,{"$f":"SUM(F28:F29)","v":0},{"$f":"SUM(G28:G29)","v":0},{"$f":"SUM(H28:H29)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C31*D31","v":0},{"$f":"C31*E31","v":0},{"$f":"SUM(F31:G31)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C32*D32","v":0},{"$f":"C32*E32","v":0},{"$f":"SUM(F32:G32)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C33*D33","v":0},{"$f":"C33*E33","v":0},{"$f":"SUM(F33:G33)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C34*D34","v":0},{"$f":"C34*E34","v":0},{"$f":"SUM(F34:G34)","v":0}]
[null,"Total (C )",{"$f":"SUM(C31:C34)","v":0},null,null,{"$f":"SUM(F31:F34)","v":0},{"$f":"SUM(G31:G34)","v":0},{"$f":"SUM(H31:H34)","v":0}]
[null,null,"Enrolments"]
[null,"Year 7",null,0,0,{"$f":"C37*D37","v":0},{"$f":"C37*E37","v":0},{"$f":"SUM(F37:G37)","v":0}]
[null,"Year 8",null,0,0,0,0,0]
[null,"Year 9",null,0,0,0,0,0]
[null,"Year 10",null,0,0,0,0,0]
[null,"Year 11",null,0,0,0,0,0]
[null,"Year 12",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C37:C42)","v":0},null,null,{"$f":"SUM(F37:F42)","v":0},{"$f":"SUM(G37:G42)","v":0},{"$f":"SUM(H37:H42)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F27+F30+F35+F43","v":0},{"$f":"G27+G30+G35+G43","v":0},{"$f":"H27+H30+H35+H43","v":0}]
[]
[null,{"$f":"B24+1","v":2025},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C48*D48","v":0},{"$f":"C48*E48","v":0},{"$f":"SUM(F48:G48)","v":0}]
[null,"Total (A)",{"$f":"C48","v":0},null,null,{"$f":"SUM(F48)","v":0},{"$f":"SUM(G48)","v":0},{"$f":"SUM(H48)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C50*D50","v":0},{"$f":"C50*E50","v":0},{"$f":"SUM(F50:G50)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C51*D51","v":0},{"$f":"C51*E51","v":0},{"$f":"SUM(F51:G51)","v":0}]
[null,"Total (B)",{"$f":"SUM(C50:C51)","v":0},null,null,{"$f":"SUM(F50:F51)","v":0},{"$f":"SUM(G50:G51)","v":0},{"$f":"SUM(H50:H51)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C53*D53","v":0},{"$f":"C53*E53","v":0},{"$f":"SUM(F53:G53)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C54*D54","v":0},{"$f":"C54*E54","v":0},{"$f":"SUM(F54:G54)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C55*D55","v":0},{"$f":"C55*E55","v":0},{"$f":"SUM(F55:G55)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C56*D56","v":0},{"$f":"C56*E56","v":0},{"$f":"SUM(F56:G56)","v":0}]
[null,"Total (C )",{"$f":"SUM(C53:C56)","v":0},null,null,{"$f":"SUM(F53:F56)","v":0},{"$f":"SUM(G53:G56)","v":0},{"$f":"SUM(H53:H56)","v":0}]
[null,null,"Enrolments"]
[null,"Year 7",null,0,0,{"$f":"C59*D59","v":0},{"$f":"C59*E59","v":0},{"$f":"SUM(F59:G59)","v":0}]
[null,"Year 8",null,0,0,0,0,0]
[null,"Year 9",null,0,0,0,0,0]
[null,"Year 10",null,0,0,0,0,0]
[null,"Year 11",null,0,0,0,0,0]
[null,"Year 12",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C59:C64)","v":0},null,null,{"$f":"SUM(F59:F64)","v":0},{"$f":"SUM(G59:G64)","v":0},{"$f":"SUM(H59:H64)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F49+F52+F57+F65","v":0},{"$f":"G49+G52+G57+G65","v":0},{"$f":"H49+H52+H57+H65","v":0}]
[]
[null,{"$f":"B46+1","v":2026},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C70*D70","v":0},{"$f":"C70*E70","v":0},{"$f":"SUM(F70:G70)","v":0}]
[null,"Total (A)",{"$f":"C70","v":0},null,null,{"$f":"SUM(F70)","v":0},{"$f":"SUM(G70)","v":0},{"$f":"SUM(H70)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C72*D72","v":0},{"$f":"C72*E72","v":0},{"$f":"SUM(F72:G72)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C73*D73","v":0},{"$f":"C73*E73","v":0},{"$f":"SUM(F73:G73)","v":0}]
[null,"Total (B)",{"$f":"SUM(C72:C73)","v":0},null,null,{"$f":"SUM(F72:F73)","v":0},{"$f":"SUM(G72:G73)","v":0},{"$f":"SUM(H72:H73)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C75*D75","v":0},{"$f":"C75*E75","v":0},{"$f":"SUM(F75:G75)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C76*D76","v":0},{"$f":"C76*E76","v":0},{"$f":"SUM(F76:G76)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C77*D77","v":0},{"$f":"C77*E77","v":0},{"$f":"SUM(F77:G77)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C78*D78","v":0},{"$f":"C78*E78","v":0},{"$f":"SUM(F78:G78)","v":0}]
[null,"Total (C )",{"$f":"SUM(C75:C78)","v":0},null,null,{"$f":"SUM(F75:F78)","v":0},{"$f":"SUM(G75:G78)","v":0},{"$f":"SUM(H75:H78)","v":0}]
[null,null,"Enrolments"]
[null,"Year 7",null,0,0,{"$f":"C81*D81","v":0},{"$f":"C81*E81","v":0},{"$f":"SUM(F81:G81)","v":0}]
[null,"Year 8",null,0,0,0,0,0]
[null,"Year 9",null,0,0,0,0,0]
[null,"Year 10",null,0,0,0,0,0]
[null,"Year 11",null,0,0,0,0,0]
[null,"Year 12",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C81:C86)","v":0},null,null,{"$f":"SUM(F81:F86)","v":0},{"$f":"SUM(G81:G86)","v":0},{"$f":"SUM(H81:H86)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F71+F74+F79+F87","v":0},{"$f":"G71+G74+G79+G87","v":0},{"$f":"H71+H74+H79+H87","v":0}]
[]
[null,{"$f":"B68+1","v":2027},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C92*D92","v":0},{"$f":"C92*E92","v":0},{"$f":"SUM(F92:G92)","v":0}]
[null,"Total (A)",{"$f":"C92","v":0},null,null,{"$f":"SUM(F92)","v":0},{"$f":"SUM(G92)","v":0},{"$f":"SUM(H92)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C94*D94","v":0},{"$f":"C94*E94","v":0},{"$f":"SUM(F94:G94)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C95*D95","v":0},{"$f":"C95*E95","v":0},{"$f":"SUM(F95:G95)","v":0}]
[null,"Total (B)",{"$f":"SUM(C94:C95)","v":0},null,null,{"$f":"SUM(F94:F95)","v":0},{"$f":"SUM(G94:G95)","v":0},{"$f":"SUM(H94:H95)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C97*D97","v":0},{"$f":"C97*E97","v":0},{"$f":"SUM(F97:G97)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C98*D98","v":0},{"$f":"C98*E98","v":0},{"$f":"SUM(F98:G98)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C99*D99","v":0},{"$f":"C99*E99","v":0},{"$f":"SUM(F99:G99)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C100*D100","v":0},{"$f":"C100*E100","v":0},{"$f":"SUM(F100:G100)","v":0}]
[null,"Total (C )",{"$f":"SUM(C97:C100)","v":0},null,null,{"$f":"SUM(F97:F100)","v":0},{"$f":"SUM(G97:G100)","v":0},{"$f":"SUM(H97:H100)","v":0}]
[null,null,"Enrolments"]
[null,"Year 7",null,0,0,{"$f":"C103*D103","v":0},{"$f":"C103*E103","v":0},{"$f":"SUM(F103:G103)","v":0}]
[null,"Year 8",null,0,0,0,0,0]
[null,"Year 9",null,0,0,0,0,0]
[null,"Year 10",null,0,0,0,0,0]
[null,"Year 11",null,0,0,0,0,0]
[null,"Year 12",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C103:C108)","v":0},null,null,{"$f":"SUM(F103:F108)","v":0},{"$f":"SUM(G103:G108)","v":0},{"$f":"SUM(H103:H108)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F93+F96+F101+F109","v":0},{"$f":"G93+G96+G101+G109","v":0},{"$f":"H93+H96+H101+H109","v":0}]
[]
[null,{"$f":"B90+1","v":2028},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C114*D114","v":0},{"$f":"C114*E114","v":0},{"$f":"SUM(F114:G114)","v":0}]
[null,"Total (A)",{"$f":"C114","v":0},null,null,{"$f":"SUM(F114)","v":0},{"$f":"SUM(G114)","v":0},{"$f":"SUM(H114)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C116*D116","v":0},{"$f":"C116*E116","v":0},{"$f":"SUM(F116:G116)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C117*D117","v":0},{"$f":"C117*E117","v":0},{"$f":"SUM(F117:G117)","v":0}]
[null,"Total (B)",{"$f":"SUM(C116:C117)","v":0},null,null,{"$f":"SUM(F116:F117)","v":0},{"$f":"SUM(G116:G117)","v":0},{"$f":"SUM(H116:H117)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C119*D119","v":0},{"$f":"C119*E119","v":0},{"$f":"SUM(F119:G119)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C120*D120","v":0},{"$f":"C120*E120","v":0},{"$f":"SUM(F120:G120)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C121*D121","v":0},{"$f":"C121*E121","v":0},{"$f":"SUM(F121:G121)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C122*D122","v":0},{"$f":"C122*E122","v":0},{"$f":"SUM(F122:G122)","v":0}]
[null,"Total (C )",{"$f":"SUM(C119:C122)","v":0},null,null,{"$f":"SUM(F119:F122)","v":0},{"$f":"SUM(G119:G122)","v":0},{"$f":"SUM(H119:H122)","v":0}]
[null,null,"Enrolments"]
[null,"Year 7",null,0,0,{"$f":"C125*D125","v":0},{"$f":"C125*E125","v":0},{"$f":"SUM(F125:G125)","v":0}]
[null,"Year 8",null,0,0,0,0,0]
[null,"Year 9",null,0,0,0,0,0]
[null,"Year 10",null,0,0,0,0,0]
[null,"Year 11",null,0,0,0,0,0]
[null,"Year 12",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C125:C130)","v":0},null,null,{"$f":"SUM(F125:F130)","v":0},{"$f":"SUM(G125:G130)","v":0},{"$f":"SUM(H125:H130)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F115+F118+F123+F131","v":0},{"$f":"G115+G118+G123+G131","v":0},{"$f":"H115+H118+H123+H131","v":0}]
[]
[null,{"$f":"B112+1","v":2029},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C136*D136","v":0},{"$f":"C136*E136","v":0},{"$f":"SUM(F136:G136)","v":0}]
[null,"Total (A)",{"$f":"C136","v":0},null,null,{"$f":"SUM(F136)","v":0},{"$f":"SUM(G136)","v":0},{"$f":"SUM(H136)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C138*D138","v":0},{"$f":"C138*E138","v":0},{"$f":"SUM(F138:G138)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C139*D139","v":0},{"$f":"C139*E139","v":0},{"$f":"SUM(F139:G139)","v":0}]
[null,"Total (B)",{"$f":"SUM(C138:C139)","v":0},null,null,{"$f":"SUM(F138:F139)","v":0},{"$f":"SUM(G138:G139)","v":0},{"$f":"SUM(H138:H139)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C141*D141","v":0},{"$f":"C141*E141","v":0},{"$f":"SUM(F141:G141)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C142*D142","v":0},{"$f":"C142*E142","v":0},{"$f":"SUM(F142:G142)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C143*D143","v":0},{"$f":"C143*E143","v":0},{"$f":"SUM(F143:G143)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C144*D144","v":0},{"$f":"C144*E144","v":0},{"$f":"SUM(F144:G144)","v":0}]
[null,"Total (C )",{"$f":"SUM(C141:C144)","v":0},null,null,{"$f":"SUM(F141:F144)","v":0},{"$f":"SUM(G141:G144)","v":0},{"$f":"SUM(H141:H144)","v":0}]
[null,null,"Enrolments"]
[null,"Year 7",null,0,0,{"$f":"C147*D147","v":0},{"$f":"C147*E147","v":0},{"$f":"SUM(F147:G147)","v":0}]
[null,"Year 8",null,0,0,0,0,0]
[null,"Year 9",null,0,0,0,0,0]
[null,"Year 10",null,0,0,0,0,0]
[null,"Year 11",null,0,0,0,0,0]
[null,"Year 12",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C147:C152)","v":0},null,null,{"$f":"SUM(F147:F152)","v":0},{"$f":"SUM(G147:G152)","v":0},{"$f":"SUM(H147:H152)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F137+F140+F145+F153","v":0},{"$f":"G137+G140+G145+G153","v":0},{"$f":"H137+H140+H145+H153","v":0}]
[]
[null,{"$f":"B134+1","v":2030},"School Fee Information"]
[null,"Fees & Charges","Number of Families","Recurrent","Capital","Total Recurrent Charged","Total Capital Charged","Total Amount Charged"]
[null,"Family Fee",null,0,0,{"$f":"C158*D158","v":0},{"$f":"C158*E158","v":0},{"$f":"SUM(F158:G158)","v":0}]
[null,"Total (A)",{"$f":"C158","v":0},null,null,{"$f":"SUM(F158)","v":0},{"$f":"SUM(G158)","v":0},{"$f":"SUM(H158)","v":0}]
[null,"1. Tier Fee",null,0,0,{"$f":"C160*D160","v":0},{"$f":"C160*E160","v":0},{"$f":"SUM(F160:G160)","v":0}]
[null,"2. Tier Fee",null,0,0,{"$f":"C161*D161","v":0},{"$f":"C161*E161","v":0},{"$f":"SUM(F161:G161)","v":0}]
[null,"Total (B)",{"$f":"SUM(C160:C161)","v":0},null,null,{"$f":"SUM(F160:F161)","v":0},{"$f":"SUM(G160:G161)","v":0},{"$f":"SUM(H160:H161)","v":0}]
[null,"1 Child Fee",null,0,0,{"$f":"C163*D163","v":0},{"$f":"C163*E163","v":0},{"$f":"SUM(F163:G163)","v":0}]
[null,"2 Children Fee",null,0,0,{"$f":"C164*D164","v":0},{"$f":"C164*E164","v":0},{"$f":"SUM(F164:G164)","v":0}]
[null,"3 Children Fee",null,0,0,{"$f":"C165*D165","v":0},{"$f":"C165*E165","v":0},{"$f":"SUM(F165:G165)","v":0}]
[null,"4 Children Fee",null,0,0,{"$f":"C166*D166","v":0},{"$f":"C166*E166","v":0},{"$f":"SUM(F166:G166)","v":0}]
[null,"Total (C )",{"$f":"SUM(C163:C166)","v":0},null,null,{"$f":"SUM(F163:F166)","v":0},{"$f":"SUM(G163:G166)","v":0},{"$f":"SUM(H163:H166)","v":0}]
[null,null,"Enrolments"]
[null,"Year 7",null,0,0,{"$f":"C169*D169","v":0},{"$f":"C169*E169","v":0},{"$f":"SUM(F169:G169)","v":0}]
[null,"Year 8",null,0,0,0,0,0]
[null,"Year 9",null,0,0,0,0,0]
[null,"Year 10",null,0,0,0,0,0]
[null,"Year 11",null,0,0,0,0,0]
[null,"Year 12",null,0,0,0,0,0]
[null,"Total (D)",{"$f":"SUM(C169:C174)","v":0},null,null,{"$f":"SUM(F169:F174)","v":0},{"$f":"SUM(G169:G174)","v":0},{"$f":"SUM(H169:H174)","v":0}]
[null,"Grand Total",null,null,null,{"$f":"F159+F162+F167+F175","v":0},{"$f":"G159+G162+G167+G175","v":0},{"$f":"H159+H162+H167+H175","v":0}]

{"sheet":"Feasibility","index":5,"n_rows":90,"n_cols":13,"rows_kept":90,"cut":false,"hidden":true,"merged":[[1,1,2,2],[90,3,92,9]]}
[null,{"$f":"Accounting_Method","v":0},null,null,null,null,null,null,null,null,null,"Modified Cash","Primary"]
[null,"School name - school location",null,"ACTUAL","ACTUAL","ACTUAL","BUDGET","BUDGET","BUDGET","BUDGET","BUDGET"]
[null,null,null,2023,{"$f":"D3+1","v":2024},{"$f":"E3+1","v":2025},2026,2027,2028,2029,2030]
[null,"Number of students",null," "]
[null,"Number of families"]
[]
[null,"ANNUAL FEES"]
[null,"Tuition",null,{"$f":"'Primary Fees'!F23","v":0},{"$f":"'Primary Fees'!F46","v":0},{"$f":"'Primary Fees'!F69","v":0},{"$f":"'Primary Fees'!F92","v":0},{"$f":"'Primary Fees'!F115","v":0},{"$f":"'Primary Fees'!F138","v":0},{"$f":"'Primary Fees'!F161","v":0},{"$f":"'Primary Fees'!F184","v":0}]
[null,"Capital",null,{"$f":"'Primary Fees'!G23","v":0},{"$f":"'Primary Fees'!G46","v":0},{"$f":"'Primary Fees'!G69","v":0},{"$f":"'Primary Fees'!G92","v":0},{"$f":"'Primary Fees'!G115","v":0},{"$f":"'Primary Fees'!G138","v":0},{"$f":"'Primary Fees'!G161","v":0},{"$f":"'Primary Fees'!G184","v":0}]
[null,"Total fees",null,{"$f":"SUM(D8:D9)","v":0},0,0,0,0,0,0,{"$f":"SUM(K8:K9)","v":0}]
[]
[null,"Total collection rate",null,{"$f":"IF(ISERROR(IF(Fee_Structure=\"Per family\", (D15+D32+D33)/(D10*D5), (D15+D32+D33)/D10)),\"\",\nIF(Fee_Structure=\"Per family\", (D15+D32+D33)/(D10*D5), (D15+D32+D33)/D10))","v":""},{"$f":"IF(ISERROR(IF(Fee_Structure=\"Per family\", (E15+E32+E33)/(E10*E5), (E15+E32+E33)/E10)),\"\",\nIF(Fee_Structure=\"Per family\", (E15+E32+E33)/(E10*E5), (E15+E32+E33)/E10))","v":""},"","","","","",""]
[]
[null,"RECURRENT INCOME"]
[null,"Fees received"]
[null,"Government grants"]
[null,"Parish contribution and school building fund - recurrent"]
[null,"Other recurrent income (ORI)"]
[null,"Total recurrent income",null,{"$f":"SUM(D15:D18)","v":0},0,0,0,0,0,0,{"$f":"SUM(K15:K18)","v":0}]
[]
[null,"RECURRENT EXPENDITURE"]
[null,"Salaries"]
[null,"Interest expense"]
[null,"Other recurrent expenditure (ORC)"]
[null,"Total recurrent expenditure",null,{"$f":"SUM(D22:D24)","v":0},0,0,0,0,0,0,{"$f":"SUM(K22:K24)","v":0}]
[null,"Less Depreciation/Bad & Doubtful Debt (Accrual only)"]
[]
[null,"Recurrent surplus/deficit (Excl Depreciation if Applicable)",null,{"$f":"D19-D25+D26","v":0},{"$f":"E19-E25+E26","v":0},0,0,0,0,0,0]
[]
[null,"CAPITAL INCOME"]
[null,"Capital grant"]
[null,"Capital fees (General purposes)"]
[null,"Capital levy (Amount collected specifically to assist with loan repayments)"]
[null,"Donations and sale of assets"]
[null,"School building and library funds"]
[null,"Parish contribution"]
[null,"Interest"]
[null,"New borrowings"]
[null,"Bridging finance -  temporary loan"]
[null,"Borrowings from parents loan scheme"]
[null,"Receipts from diocesan capital fund (SCF)"]
[null,"Lease Liabilities Additions (Accrual only)"]
[null,"Other capital receipts"]
[null,"Total capital income",null,{"$f":"SUM(D31:D43)","v":0},0,0,0,0,0,0,0]
[]
[null,"CAPITAL EXPENDITURE"]
[null,"Land, buildings and improvements"]
[null,"Furniture and equipment, library books"]
[null,"Motor vehicles, plant and machinery"]
[null,"Principal component of lease expense"]
[null,"Loan repayments"]
[null,"Bridging Loan repayments"]
[null,"Payment to parents loan scheme"]
[null,"Diocesan capital fund levy"]
[null,"Repayments - Lease liabilities (excluding lease interest, Accrual only)"]
[null,"Other applications of capital"]
[null,"Total capital expenditure",null,{"$f":"SUM(D47:D56)","v":0},0,0,0,0,0,0,0]
[]
[null,"Capital surplus/deficit",null,{"$f":"D44-D57","v":0},0,0,0,0,0,0,0]
[]
[null,"Total surplus/deficit",null,{"$f":"D28+D59","v":0},0,0,0,0,0,0,0]
[]
[null,"BANK BALANCE"]
[null,"Adjusted bank balance – as at 31 December/January",null,null,{"$f":"SUM(D64+E61)","v":0},{"$f":"SUM(E64+F61)","v":0},{"$f":"SUM(F64+G61)","v":0},{"$f":"SUM(G64+H61)","v":0},0,0,0]
[null,"Less: prepaid salaries"]
[null,"Cash on hand - petty cash"]
[null,"General bank account"]
[null,"Other investment accounts"]
[null,"Family Debtors"]
[null,"Sundry Debtors"]
[null,"Less: Fees and levies received in advance"]
[null,"Less: Grants received in advance"]
[null,"Less: Accounts payable, accruals and clearing accounts"]
[null,"Less: Accrued Leave and Salary Entitlements"]
[null,"Adjusted Closing balance",null,{"$f":"IF(OR($B$1 = \"Modified Cash\", $B$1 = \"\"), D64-D65, SUM(D66:D70)-SUM(D71:D74))","v":0},{"$f":"IF(OR($B$1 = \"Modified Cash\", $B$1 = \"\"), E64-E65, SUM(E66:E70)-SUM(E71:E74))","v":0},{"$f":"IF(OR($B$1 = \"Modified Cash\", $B$1 = \"\"), F64-F65, SUM(F66:F70)-SUM(F71:F74))","v":0},{"$f":"IF(OR($B$1 = \"Modified Cash\", $B$1 = \"\"), G64-G65, SUM(G66:G70)-SUM(G71:G74))","v":0},{"$f":"IF(OR($B$1 = \"Modified Cash\", $B$1 = \"\"), H64-H65, SUM(H66:H70)-SUM(H71:H74))","v":0},0,0,0]
[null,"Closing balance/total recurrent income",null,{"$f":"IF(ISERROR(D75/D19),\"\",D75/D19)","v":""},"","","","","","",""]
[null,"Working capital (current assets - current liabilities)"]
[]
[null,"DEBT"]
[null,"Closing balance – as at 31 December/January",null,null,{"$f":"SUM(D80-E51)+E38+E39","v":0},0,0,0,0,0,0]
[null,"Debt per pupil",null,{"$f":"IF(ISERROR(D80/D4),\"\",D80/D4)","v":""},"","","","","","",""]
[]
[null,"ADDITIONAL INFORMATION"]
[null,"Bridging finance"]
[null,"Other reserves (Investment accounts for specific purposes)"]
[null,"Future maintenance account – as at 31 December/January"]
[null,"Future sick leave account - as at 31 December/January"]
[null,"Parents loan scheme"]
[null,"School building fund – as at 31 December/January"]
[null," "]

{"sheet":"Cashflow","index":6,"n_rows":81,"n_cols":19,"rows_kept":81,"cut":false,"hidden":true,"merged":[[7,0,8,1],[2,3,2,10],[3,3,3,10],[4,3,4,10],[5,3,5,10]]}
[]
[]
[null,"Accounting Method Used",null,"Meeting target  (Income Above Expected Increase.                Expenditure Below Expected Increase)"]
[null,{"$f":"Instructions!E4","v":0},null,"Near target       (Income 0% - 5% Below Expected Increase.   Expenditure 0% - 5% Above Expected Increase)"]
[null,"School Type",null,"Not near target (Income 5% Below Expected Increase.           Expenditure 5% Above Expected Increase)"]
[null,{"$f":"Instructions!F4","v":0},null,"Capital Fees make up more than 25% of total recurrent fees collected"]
[]
[{"$f":"Feasibility!B2","v":"School name - school location"},null,"Actual","Actual","Actual","Budget","Change ","Budget","Change","Budget","Change","Budget","Change","Budget","Change","EXPECTED"]
[null,null,{"$f":"Feasibility!D3","v":2023},{"$f":"Feasibility!E3","v":2024},{"$f":"Feasibility!F3","v":2025},{"$f":"Feasibility!G3","v":2026},{"$f":"Feasibility!G3","v":2026},{"$f":"Feasibility!H3","v":2027},{"$f":"Feasibility!H3","v":2027},{"$f":"Feasibility!I3","v":2028},{"$f":"Feasibility!I3","v":2028},{"$f":"Feasibility!J3","v":2029},{"$f":"Feasibility!J3","v":2029},{"$f":"Feasibility!K3","v":2030},{"$f":"Feasibility!K3","v":2030},"INCREASE (%)"]
[]
["Enrolments",null,{"$f":"Feasibility!D4","v":" "},{"$f":"Feasibility!E4","v":0},{"$f":"Feasibility!F4","v":0},{"$f":"Feasibility!G4","v":0},null,{"$f":"Feasibility!H4","v":0},null,{"$f":"Feasibility!I4","v":0},null,{"$f":"Feasibility!J4","v":0},null,{"$f":"Feasibility!K4","v":0}]
["Total collection rate",null,{"$f":"IF(ISERR(Feasibility!D12), 0, Feasibility!D12)","v":""},{"$f":"IF(ISERR(Feasibility!E12), 0, Feasibility!E12)","v":""},{"$f":"IF(ISERR(Feasibility!F12), 0, Feasibility!F12)","v":""},{"$f":"IF(ISERR(Feasibility!G12), 0, Feasibility!G12)","v":""},null,{"$f":"IF(ISERR(Feasibility!H12), 0, Feasibility!H12)","v":""},null,{"$f":"IF(ISERR(Feasibility!I12), 0, Feasibility!I12)","v":""},null,{"$f":"IF(ISERR(Feasibility!J12), 0, Feasibility!J12)","v":""},null,{"$f":"IF(ISERR(Feasibility!K12), 0, Feasibility!K12)","v":""},null,0.82499999999999996,0.9,1,1.05]
["20 % of fees collected equals",null,{"$f":"(C17+C36)*0.2","v":0},{"$f":"(D17+D36)*0.2","v":0},{"$f":"(E17+E36)*0.2","v":0},{"$f":"(F17+F36)*0.2","v":0},null,{"$f":"(H17+H36)*0.2","v":0},null,{"$f":"(J17+J36)*0.2","v":0},null,{"$f":"(L17+L36)*0.2","v":0},null,{"$f":"(N17+N36)*0.2","v":0}]
["Loan repayment as a % of (fees collected and",null,{"$f":"IF((C17+C36) = 0, 0, (C47-C41-C40-C42-C37)/(C17+C36))","v":0},{"$f":"IF((D17+D36) = 0, 0, (D47-D41-D40-D42-D37)/(D17+D36))","v":0},{"$f":"IF((E17+E36) = 0, 0, (E47-E41-E40-E42-E37)/(E17+E36))","v":0},{"$f":"IF((F17+F36) = 0, 0, (F47-F41-F40-F42-F37)/(F17+F36))","v":0},null,{"$f":"IF((H17+H36) = 0, 0, (H47-H41-H40-H42-H37)/(H17+H36))","v":0},null,{"$f":"IF((J17+J36) = 0, 0, (J47-J41-J40-J42-J37)/(J17+J36))","v":0},null,{"$f":"IF((L17+L36) = 0, 0, (L47-L41-L40-L42-L37)/(L17+L36))","v":0},null,{"$f":"IF((N17+N36) = 0, 0, (N47-N41-N40-N42-N37)/(N17+N36))","v":0},null,0.08,0.1,0.2,0.3]
["supplementary capital fund and building funds)"]
["TOTAL RECURRENT INCOME",null,null,null,null," "]
[null,"Fees received",{"$f":"Feasibility!D15","v":0},{"$f":"Feasibility!E15","v":0},{"$f":"Feasibility!F15","v":0},{"$f":"Feasibility!G15","v":0},{"$f":"ROUND(IF(ISERR((F17-E17)/E17), 0, (F17-E17)/E17),4)","v":0},{"$f":"Feasibility!H15","v":0},{"$f":"IF(ISERR((H17-F17)/F17), 0, (H17-F17)/F17)","v":0},{"$f":"Feasibility!I15","v":0},{"$f":"IF(ISERR((J17-H17)/H17), 0, (J17-H17)/H17)","v":0},{"$f":"Feasibility!J15","v":0},{"$f":"IF(ISERR((L17-J17)/J17), 0, (L17-J17)/J17)","v":0},{"$f":"Feasibility!K15","v":0},{"$f":"IF(ISERR((N17-L17)/L17), 0, (N17-L17)/L17)","v":0},0.03]
[null,{"$f":"Feasibility!B16","v":"Government grants"},{"$f":"Feasibility!D16","v":0},{"$f":"Feasibility!E16","v":0},{"$f":"Feasibility!F16","v":0},{"$f":"Feasibility!G16","v":0},{"$f":"ROUND(IF(ISERR((F18-E18)/E18), 0, (F18-E18)/E18),4)","v":0},{"$f":"Feasibility!H16","v":0},{"$f":"IF(ISERR((H18-F18)/F18), 0, (H18-F18)/F18)","v":0},{"$f":"Feasibility!I16","v":0},{"$f":"IF(ISERR((J18-H18)/H18), 0, (J18-H18)/H18)","v":0},{"$f":"Feasibility!J16","v":0},{"$f":"IF(ISERR((L18-J18)/J18), 0, (L18-J18)/J18)","v":0},{"$f":"Feasibility!K16","v":0},{"$f":"IF(ISERR((N18-L18)/L18), 0, (N18-L18)/L18)","v":0},{"$f":"IF($B$6=\"Secondary\", 6.9%, 5%)","v":0.05}]
[null,"Parish contributions and SBF - recurrent",{"$f":"Feasibility!D17","v":0},{"$f":"Feasibility!E17","v":0},{"$f":"Feasibility!F17","v":0},{"$f":"Feasibility!G17","v":0},{"$f":"ROUND(IF(ISERR((F19-E19)/E19), 0, (F19-E19)/E19),4)","v":0},{"$f":"Feasibility!H17","v":0},{"$f":"IF(ISERR((H19-F19)/F19), 0, (H19-F19)/F19)","v":0},{"$f":"Feasibility!I17","v":0},{"$f":"IF(ISERR((J19-H19)/H19), 0, (J19-H19)/H19)","v":0},{"$f":"Feasibility!J17","v":0},{"$f":"IF(ISERR((L19-J19)/J19), 0, (L19-J19)/J19)","v":0},{"$f":"Feasibility!K17","v":0},{"$f":"IF(ISERR((N19-L19)/L19), 0, (N19-L19)/L19)","v":0}]
[null,"Other recurrent income",{"$f":"Feasibility!D18","v":0},{"$f":"Feasibility!E18","v":0},{"$f":"Feasibility!F18","v":0},{"$f":"Feasibility!G18","v":0},{"$f":"ROUND(IF(ISERR((F20-E20)/E20), 0, (F20-E20)/E20),4)","v":0},{"$f":"Feasibility!H18","v":0},{"$f":"IF(ISERR((H20-F20)/F20), 0, (H20-F20)/F20)","v":0},{"$f":"Feasibility!I18","v":0},{"$f":"IF(ISERR((J20-H20)/H20), 0, (J20-H20)/H20)","v":0},{"$f":"Feasibility!J18","v":0},{"$f":"IF(ISERR((L20-J20)/J20), 0, (L20-J20)/J20)","v":0},{"$f":"Feasibility!K18","v":0},{"$f":"IF(ISERR((N20-L20)/L20), 0, (N20-L20)/L20)","v":0},0.03]
[null,null,{"$f":"SUM(C17:C20)","v":0},{"$f":"SUM(D17:D20)","v":0},{"$f":"SUM(E17:E20)","v":0},{"$f":"SUM(F17:F20)","v":0},{"$f":"ROUND(IF(ISERR((F21-E21)/E21), 0, (F21-E21)/E21),4)","v":0},{"$f":"SUM(H17:H20)","v":0},{"$f":"IF(ISERR((H21-F21)/F21), 0, (H21-F21)/F21)","v":0},{"$f":"SUM(J17:J20)","v":0},{"$f":"IF(ISERR((J21-H21)/H21), 0, (J21-H21)/H21)","v":0},{"$f":"SUM(L17:L20)","v":0},{"$f":"IF(ISERR((L21-J21)/J21), 0, (L21-J21)/J21)","v":0},{"$f":"SUM(N17:N20)","v":0},{"$f":"IF(ISERR((N21-L21)/L21), 0, (N21-L21)/L21)","v":0}]
[]
[null,"15% of Recurrent Income and Capital Fees $ value   ",{"$f":"(C21+Feasibility!D32)*C24","v":0},{"$f":"(D21+Feasibility!E32)*D24","v":0},{"$f":"(E21+Feasibility!F32)*E24","v":0},{"$f":"(F21+Feasibility!G32)*F24","v":0},null,{"$f":"(H21+Feasibility!H32)*H24","v":0},null,{"$f":"(J21+Feasibility!I32)*J24","v":0},null,{"$f":"(L21+Feasibility!J32)*L24","v":0},null,{"$f":"(N21+Feasibility!K32)*N24","v":0}]
[null,null,0.15,0.15,0.15,0.15,null,0.15,null,0.15,null,0.15,null,0.15]
["TOTAL RECURRENT EXPENDITURE"]
[null,"Salaries",{"$f":"Feasibility!D22","v":0},{"$f":"Feasibility!E22","v":0},{"$f":"Feasibility!F22","v":0},{"$f":"Feasibility!G22","v":0},{"$f":"ROUND(IF(ISERR((F26-E26)/E26), 0, (F26-E26)/E26),4)","v":0},{"$f":"Feasibility!H22","v":0},{"$f":"IF(ISERR((H26-F26)/F26), 0, (H26-F26)/F26)","v":0},{"$f":"Feasibility!I22","v":0},{"$f":"IF(ISERR((J26-H26)/H26), 0, (J26-H26)/H26)","v":0},{"$f":"Feasibility!J22","v":0},{"$f":"IF(ISERR((L26-J26)/J26), 0, (L26-J26)/J26)","v":0},{"$f":"Feasibility!K22","v":0},{"$f":"IF(ISERR((N26-L26)/L26), 0, (N26-L26)/L26)","v":0},3.5000000000000003E-2]
[null,"Interest expense",{"$f":"Feasibility!D23","v":0},{"$f":"Feasibility!E23","v":0},{"$f":"Feasibility!F23","v":0},{"$f":"Feasibility!G23","v":0},{"$f":"ROUND(IF(ISERR((F27-E27)/E27), 0, (F27-E27)/E27),4)","v":0},{"$f":"Feasibility!H23","v":0},{"$f":"IF(ISERR((H27-F27)/F27), 0, (H27-F27)/F27)","v":0},{"$f":"Feasibility!I23","v":0},{"$f":"IF(ISERR((J27-H27)/H27), 0, (J27-H27)/H27)","v":0},{"$f":"Feasibility!J23","v":0},{"$f":"IF(ISERR((L27-J27)/J27), 0, (L27-J27)/J27)","v":0},{"$f":"Feasibility!K23","v":0},{"$f":"IF(ISERR((N27-L27)/L27), 0, (N27-L27)/L27)","v":0},0.03]
[null,"Other recurrent expenditure",{"$f":"Feasibility!D24","v":0},{"$f":"Feasibility!E24","v":0},{"$f":"Feasibility!F24","v":0},{"$f":"Feasibility!G24","v":0},{"$f":"ROUND(IF(ISERR((F28-E28)/E28), 0, (F28-E28)/E28),4)","v":0},{"$f":"Feasibility!H24","v":0},{"$f":"IF(ISERR((H28-F28)/F28), 0, (H28-F28)/F28)","v":0},{"$f":"Feasibility!I24","v":0},{"$f":"IF(ISERR((J28-H28)/H28), 0, (J28-H28)/H28)","v":0},{"$f":"Feasibility!J24","v":0},{"$f":"IF(ISERR((L28-J28)/J28), 0, (L28-J28)/J28)","v":0},{"$f":"Feasibility!K24","v":0},{"$f":"IF(ISERR((N28-L28)/L28), 0, (N28-L28)/L28)","v":0},0.03]
[null,"Less: Depreciation",{"$f":"Feasibility!D26","v":0},{"$f":"Feasibility!E26","v":0},{"$f":"Feasibility!F26","v":0},{"$f":"Feasibility!G26","v":0},null,{"$f":"Feasibility!H26","v":0},null,{"$f":"Feasibility!I26","v":0},null,{"$f":"Feasibility!J26","v":0},null,{"$f":"Feasibility!K26","v":0}]
[null,null,{"$f":"SUM(C26:C28)-C29","v":0},{"$f":"SUM(D26:D28)-D29","v":0},{"$f":"SUM(E26:E28)-E29","v":0},{"$f":"SUM(F26:F28)-F29","v":0},{"$f":"ROUND(IF(ISERR((F30-E30)/E30), 0, (F30-E30)/E30),4)","v":0},{"$f":"SUM(H26:H28)-H29","v":0},{"$f":"IF(ISERR((H30-F30)/F30), 0, (H30-F30)/F30)","v":0},{"$f":"SUM(J26:J28)-J29","v":0},{"$f":"IF(ISERR((J30-H30)/H30), 0, (J30-H30)/H30)","v":0},{"$f":"SUM(L26:L28)-L29","v":0},{"$f":"IF(ISERR((L30-J30)/J30), 0, (L30-J30)/J30)","v":0},{"$f":"SUM(N26:N28)-N29","v":0},{"$f":"IF(ISERR((N30-L30)/L30), 0, (N30-L30)/L30)","v":0}]
[]
["RECURRENT SURPLUS/DEFICIT",null,{"$f":"C21-C30","v":0},{"$f":"D21-D30","v":0},{"$f":"E21-E30","v":0},{"$f":"F21-F30","v":0},{"$f":"ROUND(IF(ISERR((F32-E32)/E32), 0, (F32-E32)/E32),4)","v":0},{"$f":"H21-H30","v":0},{"$f":"IF(ISERR((H32-F32)/F32), 0, (H32-F32)/F32)","v":0},{"$f":"J21-J30","v":0},{"$f":"IF(ISERR((J32-H32)/H32), 0, (J32-H32)/H32)","v":0},{"$f":"L21-L30","v":0},{"$f":"IF(ISERR((L32-J32)/J32), 0, (L32-J32)/J32)","v":0},{"$f":"N21-N30","v":0},{"$f":"IF(ISERR((N32-L32)/L32), 0, (N32-L32)/L32)","v":0}]
[]
["TOTAL CAPITAL INCOME (excluding Lease liabilities additions)"]
[null,"Capital grants",{"$f":"Feasibility!D31","v":0},{"$f":"Feasibility!E31","v":0},{"$f":"Feasibility!F31","v":0},{"$f":"Feasibility!G31","v":0},{"$f":"ROUND(IF(ISERR((F35-E35)/E35), 0, (F35-E35)/E35),4)","v":0},{"$f":"Feasibility!H31","v":0},{"$f":"IF(ISERR((H35-F35)/F35), 0, (H35-F35)/F35)","v":0},{"$f":"Feasibility!I31","v":0},{"$f":"IF(ISERR((J35-H35)/H35), 0, (J35-H35)/H35)","v":0},{"$f":"Feasibility!J31","v":0},{"$f":"IF(ISERR((L35-J35)/J35), 0, (L35-J35)/J35)","v":0},{"$f":"Feasibility!K31","v":0},{"$f":"IF(ISERR((N35-L35)/L35), 0, (N35-L35)/L35)","v":0}]
[null,"Capital fees",{"$f":"Feasibility!D32","v":0},{"$f":"Feasibility!E32","v":0},{"$f":"Feasibility!F32","v":0},{"$f":"Feasibility!G32","v":0},0,{"$f":"Feasibility!H32","v":0},0,{"$f":"Feasibility!I32","v":0},0,{"$f":"Feasibility!J32","v":0},0,{"$f":"Feasibility!K32","v":0},0,{"$f":"IF($B$6=\"Secondary\", 6.9%, 5%)","v":0.05}]
[null,"Capital levy (Amount collected specifically to assist with loan repayments)",{"$f":"Feasibility!D33","v":0},{"$f":"Feasibility!E33","v":0},{"$f":"Feasibility!F33","v":0},{"$f":"Feasibility!G33","v":0},0,{"$f":"Feasibility!H33","v":0},0,{"$f":"Feasibility!I33","v":0},0,{"$f":"Feasibility!J33","v":0},0,{"$f":"Feasibility!K33","v":0},0]
[null,"New borrowings",{"$f":"Feasibility!D38","v":0},{"$f":"Feasibility!E38","v":0},{"$f":"Feasibility!F38","v":0},{"$f":"Feasibility!G38","v":0},0,{"$f":"Feasibility!H38","v":0},0,{"$f":"Feasibility!I38","v":0},0,{"$f":"Feasibility!J38","v":0},0,{"$f":"Feasibility!K38","v":0},0]
[null,"Donations and sale of assets",{"$f":"Feasibility!D34","v":0},{"$f":"Feasibility!E34","v":0},{"$f":"Feasibility!F34","v":0},{"$f":"Feasibility!G34","v":0},0,{"$f":"Feasibility!H34","v":0},0,{"$f":"Feasibility!I34","v":0},0,{"$f":"Feasibility!J34","v":0},0,{"$f":"Feasibility!K34","v":0},0]
[null,"Parish contribution",{"$f":"Feasibility!D36","v":0},{"$f":"Feasibility!E36","v":0},{"$f":"Feasibility!F36","v":0},{"$f":"Feasibility!G36","v":0},0,{"$f":"Feasibility!H36","v":0},0,{"$f":"Feasibility!I36","v":0},0,{"$f":"Feasibility!J36","v":0},0,{"$f":"Feasibility!K36","v":0},0]
[null,"School building and library funds",{"$f":"Feasibility!D35","v":0},{"$f":"Feasibility!E35","v":0},{"$f":"Feasibility!F35","v":0},{"$f":"Feasibility!G35","v":0},0,{"$f":"Feasibility!H35","v":0},0,{"$f":"Feasibility!I35","v":0},0,{"$f":"Feasibility!J35","v":0},0,{"$f":"Feasibility!K35","v":0},0]
[null,"Supplementary Capital Fund",{"$f":"Feasibility!D41","v":0},{"$f":"Feasibility!E41","v":0},{"$f":"Feasibility!F41","v":0},{"$f":"Feasibility!G41","v":0},0,{"$f":"Feasibility!H41","v":0},0,{"$f":"Feasibility!I41","v":0},0,{"$f":"Feasibility!J41","v":0},0,{"$f":"Feasibility!K41","v":0},0]
[null,"Other (Receipts from interest, bridging finance,etc)",{"$f":"Feasibility!D37+Feasibility!D39+Feasibility!D40+Feasibility!D43","v":0},{"$f":"Feasibility!E37+Feasibility!E39+Feasibility!E40+Feasibility!E43","v":0},{"$f":"Feasibility!F37+Feasibility!F39+Feasibility!F40+Feasibility!F43","v":0},{"$f":"Feasibility!G37+Feasibility!G39+Feasibility!G40+Feasibility!G43","v":0},0,{"$f":"Feasibility!H37+Feasibility!H39+Feasibility!H40+Feasibility!H43","v":0},0,{"$f":"Feasibility!I37+Feasibility!I39+Feasibility!I40+Feasibility!I43","v":0},0,{"$f":"Feasibility!J37+Feasibility!J39+Feasibility!J40+Feasibility!J43","v":0},0,{"$f":"Feasibility!K37+Feasibility!K39+Feasibility!K40+Feasibility!K43","v":0},0]
[null,null,{"$f":"SUM(C35:C43)","v":0},{"$f":"SUM(D35:D43)","v":0},{"$f":"SUM(E35:E43)","v":0},{"$f":"SUM(F35:F43)","v":0},{"$f":"ROUND(IF(ISERR((F44-E44)/E44),0, (F44-E44)/E44),4)","v":0},{"$f":"SUM(H35:H43)","v":0},0,{"$f":"SUM(J35:J43)","v":0},{"$f":"IF(ISERR((J44-H44)/H44),0, (J44-H44)/H44)","v":0},{"$f":"SUM(L35:L43)","v":0},{"$f":"IF(ISERR((L44-J44)/J44),0, (L44-J44)/J44)","v":0},{"$f":"SUM(N35:N43)","v":0},{"$f":"IF(ISERR((N44-L44)/L44),0, (N44-L44)/L44)","v":0}]
[]
["TOTAL CAPITAL EXPENDITURE (excluding Lease liabilities repayments)"]
[null,"Loan repayments",{"$f":"Feasibility!D51","v":0},{"$f":"Feasibility!E51","v":0},{"$f":"Feasibility!F51","v":0},{"$f":"Feasibility!G51","v":0},{"$f":"ROUND(IF(ISERR((F47-E47)/E47), 0, (F47-E47)/E47),4)","v":0},{"$f":"Feasibility!H51","v":0},{"$f":"IF(ISERR((H47-F47)/F47), 0, (H47-F47)/F47)","v":0},{"$f":"Feasibility!I51","v":0},{"$f":"IF(ISERR((J47-H47)/H47), 0, (J47-H47)/H47)","v":0},{"$f":"Feasibility!J51","v":0},{"$f":"IF(ISERR((L47-J47)/J47), 0, (L47-J47)/J47)","v":0},{"$f":"Feasibility!K51","v":0},{"$f":"IF(ISERR((N47-L47)/L47), 0, (N47-L47)/L47)","v":0}]
[null,"Bridging Loan repayments",{"$f":"Feasibility!D52","v":0},{"$f":"Feasibility!E52","v":0},{"$f":"Feasibility!F52","v":0},{"$f":"Feasibility!G52","v":0},0,{"$f":"Feasibility!H52","v":0},0,{"$f":"Feasibility!I52","v":0},0,{"$f":"Feasibility!J52","v":0},0,{"$f":"Feasibility!K52","v":0},0]
[null,"Land and buildings",{"$f":"Feasibility!D47","v":0},{"$f":"Feasibility!E47","v":0},{"$f":"Feasibility!F47","v":0},{"$f":"Feasibility!G47","v":0},0,{"$f":"Feasibility!H47","v":0},0,{"$f":"Feasibility!I47","v":0},0,{"$f":"Feasibility!J47","v":0},0,{"$f":"Feasibility!K47","v":0},0]
[null,"Furniture and equipment, library books",{"$f":"Feasibility!D48","v":0},{"$f":"Feasibility!E48","v":0},{"$f":"Feasibility!F48","v":0},{"$f":"Feasibility!G48","v":0},0,{"$f":"Feasibility!H48","v":0},0,{"$f":"Feasibility!I48","v":0},0,{"$f":"Feasibility!J48","v":0},0,{"$f":"Feasibility!K48","v":0},0]
[null,"Other (Motor vehicles, diocesan capital fund levy, etc)",{"$f":"Feasibility!D49+Feasibility!D50+Feasibility!D53+Feasibility!D54+Feasibility!D56","v":0},{"$f":"Feasibility!E49+Feasibility!E50+Feasibility!E53+Feasibility!E54+Feasibility!E56","v":0},{"$f":"Feasibility!F49+Feasibility!F50+Feasibility!F53+Feasibility!F54+Feasibility!F56","v":0},{"$f":"Feasibility!G49+Feasibility!G50+Feasibility!G53+Feasibility!G54+Feasibility!G56","v":0},0,{"$f":"Feasibility!H49+Feasibility!H50+Feasibility!H53+Feasibility!H54+Feasibility!H56","v":0},0,{"$f":"Feasibility!I49+Feasibility!I50+Feasibility!I53+Feasibility!I54+Feasibility!I56","v":0},0,{"$f":"Feasibility!J49+Feasibility!J50+Feasibility!J53+Feasibility!J54+Feasibility!J56","v":0},0,{"$f":"Feasibility!K49+Feasibility!K50+Feasibility!K53+Feasibility!K54+Feasibility!K56","v":0},0]
[null,null,{"$f":"SUM(C47:C51)","v":0},{"$f":"SUM(D47:D51)","v":0},{"$f":"SUM(E47:E51)","v":0},{"$f":"SUM(F47:F51)","v":0},0,{"$f":"SUM(H47:H51)","v":0},0,{"$f":"SUM(J47:J51)","v":0},0,{"$f":"SUM(L47:L51)","v":0},0,{"$f":"SUM(N47:N51)","v":0},0]
[]
["CAPITAL SURPLUS/DEFICIT",null,{"$f":"C44-C52","v":0},{"$f":"D44-D52","v":0},{"$f":"E44-E52","v":0},{"$f":"F44-F52","v":0},{"$f":"ROUND(IF(ISERR((F54-E54)/E54), 0, (F54-E54)/E54),4)","v":0},{"$f":"H44-H52","v":0},{"$f":"IF(ISERR((H54-F54)/F54), 0, (H54-F54)/F54)","v":0},{"$f":"J44-J52","v":0},{"$f":"IF(ISERR((J54-H54)/H54), 0, (J54-H54)/H54)","v":0},{"$f":"L44-L52","v":0},{"$f":"IF(ISERR((L54-J54)/J54), 0, (L54-J54)/J54)","v":0},{"$f":"N44-N52","v":0},{"$f":"IF(ISERR((N54-L54)/L54), 0, (N54-L54)/L54)","v":0}]
[]
["TOTAL SURPLUS/DEFICIT",null,{"$f":"C32+C54","v":0},{"$f":"D32+D54","v":0},{"$f":"E32+E54","v":0},{"$f":"F32+F54","v":0},{"$f":"ROUND(IF(ISERR((F56-E56)/E56), 0, (F56-E56)/E56),4)","v":0},{"$f":"H32+H54","v":0},{"$f":"IF(ISERR((H56-F56)/F56), 0, (H56-F56)/F56)","v":0},{"$f":"J32+J54","v":0},{"$f":"IF(ISERR((J56-H56)/H56), 0, (J56-H56)/H56)","v":0},{"$f":"L32+L54","v":0},{"$f":"IF(ISERR((L56-J56)/J56), 0, (L56-J56)/J56)","v":0},{"$f":"N32+N54","v":0},{"$f":"IF(ISERR((N56-L56)/L56), 0, (N56-L56)/L56)","v":0}]
[]
["BANK BALANCE"]
["Adjusted bank balance – as at 31 December/January",null,{"$f":"Feasibility!D64","v":0},{"$f":"Feasibility!E64","v":0},{"$f":"Feasibility!F64","v":0},{"$f":"Feasibility!G64","v":0},{"$f":"ROUND(IF(ISERR((F59-E59)/E59), 0, (F59-E59)/E59),4)","v":0},{"$f":"Feasibility!H64","v":0},{"$f":"IF(ISERR((H59-F59)/F59), 0, (H59-F59)/F59)","v":0},{"$f":"Feasibility!I64","v":0},{"$f":"IF(ISERR((J59-H59)/H59), 0, (J59-H59)/H59)","v":0},{"$f":"Feasibility!J64","v":0},{"$f":"IF(ISERR((L59-J59)/J59), 0, (L59-J59)/J59)","v":0},{"$f":"Feasibility!K64","v":0},{"$f":"IF(ISERR((N59-L59)/L59), 0, (N59-L59)/L59)","v":0}]
["Less: prepaid salaries",null,{"$f":"Feasibility!D65","v":0},{"$f":"Feasibility!E65","v":0},{"$f":"Feasibility!F65","v":0},{"$f":"Feasibility!G65","v":0},{"$f":"ROUND(IF(ISERR((F60-E60)/E60), 0, (F60-E60)/E60),4)","v":0},{"$f":"Feasibility!H65","v":0},0,{"$f":"Feasibility!I65","v":0},0,{"$f":"Feasibility!J65","v":0},0,{"$f":"Feasibility!K65","v":0},0]
["Cash on hand - petty cash",null,{"$f":"Feasibility!D66","v":0},{"$f":"Feasibility!E66","v":0},{"$f":"Feasibility!F66","v":0},{"$f":"Feasibility!G66","v":0},0,{"$f":"Feasibility!H66","v":0},0,{"$f":"Feasibility!I66","v":0},0,{"$f":"Feasibility!J66","v":0},0,{"$f":"Feasibility!K66","v":0},0]
["General bank account",null,{"$f":"Feasibility!D67","v":0},{"$f":"Feasibility!E67","v":0},{"$f":"Feasibility!F67","v":0},{"$f":"Feasibility!G67","v":0},0,{"$f":"Feasibility!H67","v":0},0,{"$f":"Feasibility!I67","v":0},0,{"$f":"Feasibility!J67","v":0},0,{"$f":"Feasibility!K67","v":0},0]
["Other investment accounts",null,{"$f":"Feasibility!D68","v":0},{"$f":"Feasibility!E68","v":0},{"$f":"Feasibility!F68","v":0},{"$f":"Feasibility!G68","v":0},0,{"$f":"Feasibility!H68","v":0},0,{"$f":"Feasibility!I68","v":0},0,{"$f":"Feasibility!J68","v":0},0,{"$f":"Feasibility!K68","v":0},0]
["Family Debtors",null,{"$f":"Feasibility!D69","v":0},{"$f":"Feasibility!E69","v":0},{"$f":"Feasibility!F69","v":0},{"$f":"Feasibility!G69","v":0},0,{"$f":"Feasibility!H69","v":0},0,{"$f":"Feasibility!I69","v":0},0,{"$f":"Feasibility!J69","v":0},{"$f":"IF(ISERR((L64-J64)/J64), 0, (L64-J64)/J64)","v":0},{"$f":"Feasibility!K69","v":0},{"$f":"IF(ISERR((N64-L64)/L64), 0, (N64-L64)/L64)","v":0}]
["Sundary Debtors",null,{"$f":"Feasibility!D70","v":0},{"$f":"Feasibility!E70","v":0},{"$f":"Feasibility!F70","v":0},{"$f":"Feasibility!G70","v":0},0,{"$f":"Feasibility!H70","v":0},0,{"$f":"Feasibility!I70","v":0},0,{"$f":"Feasibility!J70","v":0},{"$f":"IF(ISERR((L65-J65)/J65), 0, (L65-J65)/J65)","v":0},{"$f":"Feasibility!K70","v":0},{"$f":"IF(ISERR((N65-L65)/L65), 0, (N65-L65)/L65)","v":0}]
["Less: fees and levies received in advance",null,{"$f":"Feasibility!D71","v":0},{"$f":"Feasibility!E71","v":0},{"$f":"Feasibility!F71","v":0},{"$f":"Feasibility!G71","v":0},0,{"$f":"Feasibility!H71","v":0},0,{"$f":"Feasibility!I71","v":0},0,{"$f":"Feasibility!J71","v":0},0,{"$f":"Feasibility!K71","v":0},0]
["Less: government grants received in advance",null,{"$f":"Feasibility!D72","v":0},{"$f":"Feasibility!E72","v":0},{"$f":"Feasibility!F72","v":0},{"$f":"Feasibility!G72","v":0},0,{"$f":"Feasibility!H72","v":0},0,{"$f":"Feasibility!I72","v":0},0,{"$f":"Feasibility!J72","v":0},0,{"$f":"Feasibility!K72","v":0},0]
["Less: Accounts payable, accruals and clearing accounts",null,{"$f":"Feasibility!D73","v":0},{"$f":"Feasibility!E73","v":0},{"$f":"Feasibility!F73","v":0},{"$f":"Feasibility!G73","v":0},0,{"$f":"Feasibility!H73","v":0},0,{"$f":"Feasibility!I73","v":0},0,{"$f":"Feasibility!J73","v":0},0,{"$f":"Feasibility!K73","v":0},0]
["Less: Accrued Leave and Salary Entitlements",null,{"$f":"Feasibility!D74","v":0},{"$f":"Feasibility!E74","v":0},{"$f":"Feasibility!F74","v":0},{"$f":"Feasibility!G74","v":0},0,{"$f":"Feasibility!H74","v":0},0,{"$f":"Feasibility!I74","v":0},0,{"$f":"Feasibility!J74","v":0},0,{"$f":"Feasibility!K74","v":0},0]
[]
["CLOSING BALANCE",null,{"$f":"Feasibility!D75","v":0},{"$f":"Feasibility!E75","v":0},{"$f":"Feasibility!F75","v":0},{"$f":"Feasibility!G75","v":0},0,{"$f":"Feasibility!H75","v":0},{"$f":"IF(ISERR((H71-F71)/F71), 0, (H71-F71)/F71)","v":0},{"$f":"Feasibility!I75","v":0},{"$f":"IF(ISERR((J71-H71)/H71), 0, (J71-H71)/H71)","v":0},{"$f":"Feasibility!J75","v":0},{"$f":"IF(ISERR((L71-J71)/J71), 0, (L71-J71)/J71)","v":0},{"$f":"Feasibility!K75","v":0},{"$f":"IF(ISERR((N71-L71)/L71), 0, (N71-L71)/L71)","v":0}]
["Working capital (current assets - current liabilities)",null,{"$f":"Feasibility!D77","v":0},{"$f":"Feasibility!E77","v":0},{"$f":"Feasibility!F77","v":0},{"$f":"Feasibility!G77","v":0},0,{"$f":"Feasibility!H77","v":0},{"$f":"IF(ISERR((H72-F72)/F72), 0, (H72-F72)/F72)","v":0},{"$f":"Feasibility!I77","v":0},{"$f":"IF(ISERR((J72-H72)/H72), 0, (J72-H72)/H72)","v":0},{"$f":"Feasibility!J77","v":0},{"$f":"IF(ISERR((L72-J72)/J72), 0, (L72-J72)/J72)","v":0},{"$f":"Feasibility!K77","v":0},{"$f":"IF(ISERR((N72-L72)/L72), 0, (N72-L72)/L72)","v":0}]
[]
["Bridging finance",null,{"$f":"Feasibility!D84","v":0},{"$f":"Feasibility!E84","v":0},{"$f":"Feasibility!F84","v":0},{"$f":"Feasibility!G84","v":0},0,{"$f":"Feasibility!H84","v":0},{"$f":"IF(ISERR((H74-F74)/F74), 0, (H74-F74)/F74)","v":0},{"$f":"Feasibility!I84","v":0},{"$f":"IF(ISERR((J74-H74)/H74), 0, (J74-H74)/H74)","v":0},{"$f":"Feasibility!J84","v":0},{"$f":"IF(ISERR((L74-J74)/J74), 0, (L74-J74)/J74)","v":0},{"$f":"Feasibility!K84","v":0},{"$f":"IF(ISERR((N74-L74)/L74), 0, (N74-L74)/L74)","v":0}]
["Future sick leave and other capital reserve(s)",null,{"$f":"Feasibility!D87","v":0},{"$f":"Feasibility!E87","v":0},{"$f":"Feasibility!F87","v":0},{"$f":"Feasibility!G87","v":0},0,{"$f":"Feasibility!H87","v":0},{"$f":"IF(ISERR((H75-F75)/F75), 0, (H75-F75)/F75)","v":0},{"$f":"Feasibility!I87","v":0},0,{"$f":"Feasibility!J87","v":0},0,{"$f":"Feasibility!K87","v":0},0]
["Future maintenance account – as at 31 December",null,{"$f":"Feasibility!D86","v":0},{"$f":"Feasibility!E86","v":0},{"$f":"Feasibility!F86","v":0},{"$f":"Feasibility!G86","v":0},0,{"$f":"Feasibility!H86","v":0},{"$f":"IF(ISERR((H76-F76)/F76), 0, (H76-F76)/F76)","v":0},{"$f":"Feasibility!I86","v":0},0,{"$f":"Feasibility!J86","v":0},0,{"$f":"Feasibility!K86","v":0},0]
["Other reserves (Investment accounts for specific purposes)",null,{"$f":"Feasibility!D85","v":0},{"$f":"Feasibility!E85","v":0},{"$f":"Feasibility!F85","v":0},{"$f":"Feasibility!G85","v":0},0,{"$f":"Feasibility!H85","v":0},{"$f":"IF(ISERR((H77-F77)/F77),0, (H77-F77)/F77)","v":0},{"$f":"Feasibility!I85","v":0},0,{"$f":"Feasibility!J85","v":0},0,{"$f":"Feasibility!K85","v":0},0]
["Parent loan scheme",null,{"$f":"Feasibility!D88","v":0},{"$f":"Feasibility!E88","v":0},{"$f":"Feasibility!F88","v":0},{"$f":"Feasibility!G88","v":0},0,{"$f":"Feasibility!H88","v":0},{"$f":"IF(ISERR((H78-F78)/F78), 0, (H78-F78)/F78)","v":0},{"$f":"Feasibility!I88","v":0},0,{"$f":"Feasibility!J88","v":0},0,{"$f":"Feasibility!K88","v":0},0,0]
["School building fund – as at 31 December",null,{"$f":"Feasibility!D89","v":0},{"$f":"Feasibility!E89","v":0},{"$f":"Feasibility!F89","v":0},{"$f":"Feasibility!G89","v":0},0,{"$f":"Feasibility!H89","v":0},{"$f":"IF(ISERR((H79-F79)/F79), 0, (H79-F79)/F79)","v":0},{"$f":"Feasibility!I89","v":0},0,{"$f":"Feasibility!J89","v":0},0,{"$f":"Feasibility!K89","v":0},0,0.1]
["TOTAL AVAILABLE CASH RESERVES",null,{"$f":"C71+SUM(C75:C79)","v":0},{"$f":"D71+SUM(D75:D79)","v":0},{"$f":"E71+SUM(E75:E79)","v":0},{"$f":"F71+SUM(F75:F79)","v":0},{"$f":"ROUND(IF(ISERR((F80-E80)/E80), 0, (F80-E80)/E80),4)","v":0},{"$f":"H71+SUM(H75:H79)","v":0},{"$f":"IF(ISERR((H80-F80)/F80), 0, (H80-F80)/F80)","v":0},{"$f":"J71+SUM(J75:J79)","v":0},0,{"$f":"L71+SUM(L75:L79)","v":0},0,{"$f":"N71+SUM(N75:N79)","v":0},0,0.15]
[null,"Reserves as a %   ",{"$f":"IF(C21 = 0, 0, C80/C21)","v":0},{"$f":"IF(D21 = 0, 0, D80/D21)","v":0},{"$f":"IF(E21 = 0, 0, E80/E21)","v":0},{"$f":"IF(F21 = 0, 0, F80/F21)","v":0},null,{"$f":"IF(H21 = 0, 0, H80/H21)","v":0},null,{"$f":"IF(J21 = 0, 0, J80/J21)","v":0},null,{"$f":"IF(L21 = 0, 0, L80/L21)","v":0},null,{"$f":"IF(N21 = 0, 0, N80/N21)","v":0},null,0.18]

{"sheet":"Comments","index":7,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Item","Year","Comment"]