{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Summary of Funding","Budget Share Statement","Minimum Funding Level","MFG Calculation","De-delegation","EYSFF statement","Further Delegation Info","ISB","LogIn","LoginPage","Funding Floor"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":27,"defined_names":22,"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":"Summary of Funding","index":0,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":true,"merged":[[17,0,17,3],[2,0,2,7],[3,0,3,7],[5,0,5,7],[1,0,1,7],[9,0,9,2]]}
["Date Issued: 27th February 2026",null,null,null,null,null,null,"Last amended: 25th February 2026"]
["COVENTRY CITY COUNCIL"]
["2026/27 Funding Allocations for Schools",null,null,null,null,null,null,null,null,null,null,null,null,2]
["INDICATIVE Summary of Funding"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$C:$C)","v":"Aldermoor Farm Primary School"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
[{"$f":"IF((N32+N33)=0,\"\",\"***ERROR - CALCULATED ADJUSTMENT DOES NOT EQUAL ACTUAL ***\")","v":""}]
["Main Funding Elements"]
[]
["School Budget Share 2026/27",null,null,null,null,{"$f":"'Budget Share Statement'!K58","v":3655362.4432440689},null,null,null,null,null,null,null,{"$f":"F12-'Budget Share Statement'!K58","v":0}]
[]
["Indicative Early Years Funding 2026/27* (to be updated)",null,null,null,null,{"$f":"'EYSFF statement'!K30","v":165098.47705333331},null,null,null,null,null,null,null,{"$f":"F14-'EYSFF statement'!K30","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(F12,F14)","v":3820460.920297402},null,null,null,null,null,{"$f":"N12+N14","v":0}]
[]
["Other 2026/27 Funding Elements "]
[]
["Indicative Pupil Premium Grant † (excludes LAC & EYPP elements)",null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[6]Allocations!$A$1:$A$65536,[6]Allocations!$U$1:$U$65536)","v":322400}]
[]
["Indicative High Needs Top-up Funding §",null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[7]HN Top-up Calculation'!$A:$A,'[7]HN Top-up Calculation'!$M:$M)","v":129386.87}]
[]
["Class Size Funding ",null,null,null,null,{"$f":"_xlfn.XLOOKUP(N3,'[8]Class size'!$A:$A,'[8]Class size'!$N:$N)","v":0}]
[]
["Bulge Class Future Year Funding",null,null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[8]Bulge Class 3rd Year'!$R:$R,'[8]Bulge Class 3rd Year'!$T:$T),0)","v":0}]
[]
["Disproportionate SEN",null,null,null,null,{"$f":"-_xlfn.XLOOKUP(\"P\"&$N$3,[9]Sheet1!$C:$C,[9]Sheet1!$T:$T)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"F20+F22+F24+F28+F26","v":451786.87}]
[]
["Total Revenue Resources",null,null,null,null,null,null,{"$f":"H16+H30","v":4272247.7902974021},null,null,null,null,null,{"$f":"N12+N14+N20+N22+N24+N16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(('Budget Share Statement'!O58+'EYSFF statement'!N30+'De-delegation'!O25+'Minimum Funding Level'!O28+'Funding Floor'!N42+'MFG Calculation'!N55),0)","v":0}]
[]
["Notes "]
["This funding summary is intended to give you an overview of the resources allocated to the school for the financial year 2026/27."]
["Please ensure that you read this budget share pack in conjunction with the explanatory notes which are available to download online."]
[]
["* Early Years funding has been estimated based on participation at the 25/26 census levels for Sum-26 & Aut-26, and the Spr-27 has been "]
["estimated based on participation at the 24/25 census levels. - please see the EYSFF statement for further detail."]
["† Pupil Premium Funding has been updated to reflect 25/26 eligibility data using 2026/27 funding rates which will be subject to change."]
["§ Indicative High Needs Top-up Funding has been calculated based on your number of pupils on high needs bandings as at Aut-25 "]
["using 2026/27 funding rates. This figure will change based on the real time movement of pupils during the 2026/27 financial year "]
["and so will not be final until March 2027."]

{"sheet":"Budget Share Statement","index":1,"n_rows":63,"n_cols":15,"rows_kept":63,"cut":false,"hidden":true,"merged":[[1,0,1,10],[18,2,18,4],[19,2,19,4],[3,0,3,10],[17,2,17,4],[16,2,16,4],[2,0,2,10],[5,0,5,10],[9,2,9,4],[55,7,55,8],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[53,7,53,8],[39,2,39,4],[39,7,39,8],[51,2,51,4],[24,2,24,4],[47,7,47,8],[37,2,37,4],[31,2,31,4],[35,2,35,4],[51,7,51,8],[43,7,43,8]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 27th February 2026"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 25th February 2026"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2026/27 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":2}]
["INDICATIVE School Budget Share Statement"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[10]Minimum Funding Guarantee'!$A:$A,'[10]Minimum Funding Guarantee'!$C:$C)","v":"Aldermoor Farm Primary School"},null,null,null,null,null,null,null,null,null,null," ",null,null,"Checks"]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[]
["Factors",null,"Factor Measurement",null,null,null,"Number\nof Units",null,"Funding\nPer Unit",null,"Funding \nAllocated"]
[null,null,null,null,null,null,null,null,"£",null,"£"," "]
["Basic Entitlement"]
["Funding",null,"Pupil Number: (Oct-25 Census)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$G:$G)","v":601},null,{"$f":"[5]Formula!$D$2","v":4078.30528},null,{"$f":"G13*I13","v":2451061.47328},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$D:$D)-K13","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K13","v":2451061.47328}]
[]
["Deprivation Funding",null,"IDACI Band G:  Pupil's IDACI < 0.20",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$V:$V)","v":78.999999999999815},null,0,null,{"$f":"G17*I17","v":0}]
[null,null,"IDACI Band F:  0.20 ≤ Pupil's IDACI < 0.25",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$W:$W)","v":2.9999999999999978},null,{"$f":"[5]Formula!$N$2","v":240.84479999999999},null,{"$f":"G18*I18","v":722.53439999999944}," ",null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$N:$N)-K18","v":0}]
[null,null,"IDACI Band E:  0.25 ≤ Pupil's IDACI < 0.30",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$X:$X)","v":218.99999999999974},null,{"$f":"[5]Formula!$O$2","v":291.02080000000001},null,63733.55519999993," ",null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$O:$O)-K19","v":0}]
[null,null,"IDACI Band D:  0.30 ≤ Pupil's IDACI < 0.35",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$Y:$Y)","v":10.999999999999948},null,{"$f":"[5]Formula!$P$2","v":456.60159999999996},null,5022.6175999999759," ",null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$P:$P)-K20","v":0}]
[null,null,"IDACI Band C:  0.35 ≤ Pupil's IDACI < 0.40",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$Z:$Z)","v":7.9999999999999627},null,{"$f":"[5]Formula!$Q$2","v":501.76},null,4014.0799999999813,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$Q:$Q)-K21","v":0}]
[null,null,"IDACI Band B:  0.40 ≤ Pupil's IDACI < 0.50",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$AA:$AA)","v":273.99999999999977},null,{"$f":"[5]Formula!$R$2","v":531.86559999999997},null,145731.17439999987,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$R:$R)-K22","v":0}]
[null,null,"IDACI Band A:  0.50 ≤ Pupil's IDACI ≤ 1.00",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$AB:$AB)","v":6.9999999999999662},null,{"$f":"[5]Formula!$S$2","v":702.46399999999994},null,4917.2479999999759,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$S:$S)-K23","v":0}]
[null,null,"Free School Meals: (Oct-25 FSM Eligibility)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$T:$T)","v":188.99999999999989},null,{"$f":"[5]Formula!$E$2","v":506.77760000000001},null,95780.966399999947,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$E:$E)-K24","v":0}]
[null,null,"Free School Meals Ever 6: (Oct-25 FSM Eligibility)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$U:$U)","v":195.9999999999998},null,{"$f":"[5]Formula!$F$2","v":1214.2592},null,237994.80319999976,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$F:$F)-K25","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K17:K25)","v":557916.97919999936}]
[]
["Prior Attainment Funding",null,"No.pupils not reaching expected level of development",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$AC:$AC)","v":218.56810972743904},null,{"$f":"[5]Formula!$G$2","v":1204.2239999999999},null,{"$f":"G29*I29","v":263204.96336841554},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$G:$G)-K29","v":0}]
[]
["English as an Additional"]
["Language Funding",null,"No. EAL in compulsory education for 3 years or less",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$AD:$AD)","v":190.81178707224277},null,{"$f":"[5]Formula!$H$2","v":612.1472},null,{"$f":"G32*I32","v":116804.90118326961},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$H:$H)-K32","v":0}]
[]
["Pupil Mobility Funding",null,"No.pupils in last 3 years who didn’t start school in Sept",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$AE:$AE)","v":38.435812395309476},null,{"$f":"[5]Formula!$I$2","v":988.46719999999993},null,{"$f":"G34*I34","v":37992.539858116848},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$I:$I)-K34","v":0}]
[]
["Lump Sum",null,"One set amount for all schools",null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$J:$J)","v":153237.50399999999},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$J:$J)-K36","v":0}]
[]
["Split Sites Funding",null,"Lump Sum",null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$L:$L)","v":0},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]Formula!$L:$L)-K38","v":0}]
[]
["Rates Funding",null,"Estimated 2026/27 rates bill",null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$K:$K)","v":73837.649999999994},{"$f":"INDEX([12]Formula!$J:$J,MATCH(\"P\"&$N$3,[12]Formula!$A:$A,0))-E40","v":128432.63999999998},null,{"$f":"H40","v":73837.649999999994},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]Formula!$K:$K)-K40","v":0}]
[]
["Total Formula Factor Funding",null,null,null,null,null,null,null,null,null,{"$f":"K15+K27+K32+K34+K36+K38+K40+K29","v":3654056.0108898012},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$U:$U)-K42","v":0}]
[]
["Minimum Per Pupil (MPP) Funding Level Allocation",null,null,null,null,null,null,{"$f":"'Minimum Funding Level'!J28","v":0},null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$V:$V)-H44","v":0}]
[]
["Total Funding Allocated before Minimum Funding Guarantee (MFG)",null,null,null,null,null,null,null,null,null,{"$f":"K42+H44","v":3654056.0108898012},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$W:$W)-K46","v":0}]
[]
["MFG Protection (additional funding/top-slice)",null,null,null,null,null,null,{"$f":"'MFG Calculation'!J62","v":105170.7358188224},null,null,null,null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$Z:$Z),2)-H48","v":4.1811776027316228E-3}]
[]
["Total Funding Allocated after protection Arrangements",null,null,null,null,null,null,null,null,null,{"$f":"K46+H48","v":3759226.7467086236},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$AA:$AA)-K50","v":0}]
[]
["26/27 De-delegation",null,"See separate 'De-delegation' sheet",null,null,null,null,{"$f":"'De-delegation'!K25","v":-30026.653464554623},null,null,null,null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$AB:$AB),2)-H52","v":3.46455462204176E-3}]
[]
["26/27 Indicative Risk Protection Arrangement Deduction",null,null,null,null,null,null,{"$f":"-IFERROR(_xlfn.XLOOKUP(\"P\"&$N$3,'[13]LAMS Data'!$AI:$AI,'[13]LAMS Data'!$AC:$AC),0)","v":0}]
[]
["26/27 Business Rates Deduction",null,null,null,null,null,null,{"$f":"-H40","v":-73837.649999999994}]
[]
["Total Funding Allocated after MFG, De-delegation and RPA & NNDR Adjustments",null,null,null,null,null,null,null,null,null,{"$f":"K50+H52+H54+H56","v":3655362.4432440689},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$AC:$AC),2)-K58+H56+H54","v":-3.2440690265502781E-3}]
[]
["Notes"]
["If you have chosen to join the DfE Risk Protection Arrangement, the value of your charge has been deducted from your budget share. "]
["This is based on Nursery  pupils FTE in the 2025/26 DfE RPA calculation and  Primary pupils number in the October 25 census at 2026/27 rate."]
["The figure is for indicative purpose and is subjected to the final calculation from DfE."]

{"sheet":"Minimum Funding Level","index":2,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":true,"merged":[[11,6,11,7],[19,6,19,7],[21,6,21,7],[16,6,16,7],[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,5,10],[8,6,8,7],[9,6,9,7]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 27th February 2026"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 25th February 2026"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2026/27 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":2}]
["Calculation of Minimum Per Pupil (MPP) Funding Level"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[10]Minimum Funding Guarantee'!$A:$A,'[10]Minimum Funding Guarantee'!$C:$C)","v":"Aldermoor Farm Primary School"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
[null,null,null,null,null,null,"£",null,null,"£"]
["NFF Minimum per pupil funding rate",null,null,null,null,null,{"$f":"'[5]Minimum Per Pupil'!$D$3","v":5115},null,null,null,null,null,null,{"$f":"'[5]Minimum Per Pupil'!$D$3-G10","v":0}]
[]
["October 2025 Pupil Numbers",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Per Pupil'!$A:$A,'[5]Minimum Per Pupil'!$D:$D)","v":601},null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Per Pupil'!$A:$A,'[5]Minimum Per Pupil'!$D:$D)-G12","v":0}]
[]
["Minimum Funding Level (MFL)",null,null,null,null,"[A]",null,null,null,{"$f":"G10*G12","v":3074115},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Per Pupil'!$A:$A,'[5]Minimum Per Pupil'!$E:$E)-J14","v":0}]
[]
[]
["Total Formula Factor Funding",null,null,null,null,null,{"$f":"'Budget Share Statement'!K42","v":3654056.0108898012},null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Per Pupil'!$A:$A,'[5]Minimum Per Pupil'!$G:$G)-G17","v":0}]
[]
["Less: exempt premises factors"]
["2026/27 NNDR",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$K:$K)","v":73837.649999999994},{"$f":"INDEX([12]Formula!$K:$K,MATCH(\"P\"&$N$3,[12]Formula!$A:$A,0))-A20","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$K:$K)-G20","v":0}]
[]
["2026/27 Split Site",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$L:$L)","v":0},{"$f":"INDEX([12]Formula!$K:$K,MATCH(\"P\"&$N$3,[12]Formula!$A:$A,0))-A22","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$L:$L)-G22","v":0}]
[]
[]
["2026/27 Funding for MFL comparison",null,null,null,null,"[B]",null,null,null,{"$f":"G17-SUM(G20:G22)","v":3580218.3608898013},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Per Pupil'!$A:$A,'[5]Minimum Per Pupil'!$K:$K)-J25","v":0}]
[]
[]
["MFL shortfall to be funded  [B] - [A]",null,null,null,null,"= [B] - [A]  ",null,null,null,{"$f":"IF(J25<J14,J14-J25,0)","v":0},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Per Pupil'!$A:$A,'[5]Minimum Per Pupil'!$M:$M)-J28","v":0}]

{"sheet":"MFG Calculation","index":3,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":true,"merged":[[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,5,10],[17,6,17,7],[8,6,8,7],[57,6,57,7],[59,6,59,7],[10,6,10,7],[49,6,49,7],[15,6,15,7],[29,6,29,7],[13,6,13,7],[27,6,27,7],[51,6,51,7],[42,6,42,7],[47,6,47,7],[33,6,33,7],[40,6,40,7],[20,6,20,7]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 27th February 2026"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 25th February 2026"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2026/27 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":2}]
["Calculation of Minimum Funding Guarantee"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[10]Formula!$A:$A,[10]Formula!$C:$C)","v":"Aldermoor Farm Primary School"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
["Baseline",null,{"$f":"IF(N55>=0,\" \",\"DOES NOT BALANCE\")","v":" "},null,null,null,"£",null,null,"£"]
[]
["Final Budget Share 2025/26 (Excluding Early Years)",null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$H:$H)","v":3774739.1189237479}]
[]
["Less:"]
["2025/26 Rates Funding",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$J:$J)","v":73837.649999999994},{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[14]Minimum Funding Guarantee'!$A:$A,'[14]Minimum Funding Guarantee'!$H:$H)","v":3107365.4818805745}]
[]
["2026/27 Lump Sum",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$I:$I)","v":153237.50399999999},{"$f":"INDEX('[12]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,0))","v":2672266.0569657432}]
[]
["2025/26 Split Site",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$L:$L)","v":0},{"$f":"INDEX('[12]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,0))","v":2672266.0569657432},null,{"$f":"-SUM(G14,G16,G18)","v":-227075.15399999998}]
[]
["Add:"]
["2025/26 Supplementary Grant",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$M:$M)","v":113784.35830000001},{"$f":"INDEX('[12]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,0))","v":2672266.0569657432},null,{"$f":"G21","v":113784.35830000001}]
[]
["Adjusted Budget Share 2025/26",null,null,null,null,null,null,null,null,{"$f":"J11+J18+J21","v":3661448.3232237478},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$N:$N)-J23","v":0}]
[]
[]
["Guaranteed Unit Funding Calculation",null,null,null,null,null,null,null,null,"£"]
[]
["Adjusted Budget Share 2025/26",null,null,null,null,null,{"$f":"J23","v":3661448.3232237478}]
[]
["October 2024 Pupil Number",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$D:$D)","v":623},{"$f":"INDEX('[12]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,0))","v":2672266.0569657432}]
[]
["Adjusted Budget Share 2025/26 Per Pupil",null,null,null,null,null,null,null,null,{"$f":"G28/G30","v":5877.1241143238331},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$O:$O)-J32","v":0}]
[]
["Minimum Funding Guarantee Protection Level",null,null,null,null,null,{"$f":"'[5]Minimum Funding Guarantee'!$R$3-1","v":0}]
[]
["2026/27 Guaranteed Unit Funding",null,null,null,null,null,null,null,null,{"$f":"J32*(1+G34)","v":5877.1241143238331}]
[]
[]
["Guaranteed Funding Level Calculation"]
[]
["2026/27 Guaranteed Unit Funding",null,null,null,null,null,{"$f":"J36","v":5877.1241143238331}]
[]
["October 2025 Pupil Number",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$E:$E)","v":601},{"$f":"INDEX('[12]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,0))","v":2672266.0569657432}]
[]
["2026/27 Guaranteed Funding Level",null,null,null,null,null,null,null,null,{"$f":"G41*G43","v":3532151.5927086235}]
[]
["Add:"]
["2026/27 Rates",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$Z:$Z)","v":73837.649999999994},{"$f":"INDEX('[12]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,0))","v":2672266.0569657432}]
[]
["2026/27 Lump Sum",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$Y:$Y)","v":153237.50399999999},{"$f":"INDEX('[12]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,0))","v":2672266.0569657432}]
[]
["2026/27 Split Site",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$AA:$AA)","v":0},{"$f":"INDEX('[12]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,0))","v":2672266.0569657432},null,{"$f":"SUM(G48,G50)","v":227075.15399999998}]
[]
[]
["2026/27 Minimum Funding Guarantee",null,null,null,null,null,null,null,null,{"$f":"J45+J52","v":3759226.7467086236},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$Q:$Q)-J55","v":0}]
[]
[]
["2026/27 Minimum Funding Guarantee",null,null,null,null,null,{"$f":"J45+J52","v":3759226.7467086236}]
[]
["2026/27 Total Formula Funding allocated pre-MFG",null,null,null,null,null,{"$f":"'Budget Share Statement'!K46","v":3654056.0108898012}]
[]
["2026/27 MFG Protection (additional funding/top-slice)",null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$V:$V)","v":105170.7358188224},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$V:$V)-J62","v":0}]
[]
["Note:"]
["The Minimum Funding Guarantee is compared with your Budget Share before 2025/26 de-delegated budgets are removed."]

{"sheet":"De-delegation","index":4,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":true,"merged":[[22,2,22,4],[9,2,9,4],[18,2,18,4],[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,5,10]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 27th February 2026"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 25th February 2026"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2026/27 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":2}]
[{"$f":"\"De-Delegation Detail\"","v":"De-Delegation Detail"}]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[10]Formula!$A:$A,[10]Formula!$C:$C)","v":"Aldermoor Farm Primary School"},null,null,null,null,null,null,null,null,null,null," ",null,null,"Checks"]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
["Factors",null,"Factor Measurement",null,null,null,"Number\nof Units",null,"Funding\nPer Unit",null,"Funding \nAllocated"]
[null,null,null,null,null,null,null,null,"£",null,"£"]
["Basic Entitlement"]
["Funding"]
["Maternity Cover",null,"Pupil Number: (Oct-25 Census)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$D:$D)","v":601},null,{"$f":"-'[5]New Del & De-Del'!$G$9","v":-33.02218303254952},null,{"$f":"G14*I14","v":-19846.332002562263},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]New Del & De-Del'!$A:$A,'[5]New Del & De-Del'!$K:$K)+K14,0)","v":0}]
["Trade Union Facility",null,"Pupil Number: (Oct-25 Census)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$D:$D)","v":601},null,{"$f":"-'[5]New Del & De-Del'!$G$10","v":-4},null,{"$f":"G15*I15","v":-2404},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]New Del & De-Del'!$A:$A,'[5]New Del & De-Del'!$L:$L)+K15,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K14:K15)","v":-22250.332002562263},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]New Del & De-Del'!$A:$A,'[5]New Del & De-Del'!$D:$D)+K17,0)","v":0}]
["Deprivation Funding"]
["Free School Meal Eligibility",null,"Free School Meals: (Oct-25 FSM Eligibility)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$T:$T)","v":188.99999999999989},null,{"$f":"-'[5]New Del & De-Del'!$G$7","v":-2.6288454242661423},null,{"$f":"G19*I19","v":-496.85178518630062},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]New Del & De-Del'!$A:$A,'[5]New Del & De-Del'!$E:$E)+K19,0)","v":0}]
[]
["English as an Additional"]
["Language Funding"]
["EMAS: New Arrivals Grant",null,"EAL3:  EAL in child's 1st 3 years of compulsory education",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Data!$A:$A,[5]Data!$AD:$AD)","v":190.81178707224277},null,{"$f":"-'[5]New Del & De-Del'!$G$12","v":-38.15},null,{"$f":"G23*I23","v":-7279.4696768060612},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]New Del & De-Del'!$A:$A,'[5]New Del & De-Del'!$F:$F)+K23,0)","v":0}]
[]
["Total De-Delegation",null,null,null,null,null,null,null,null,null,{"$f":"K17+K19+K23","v":-30026.653464554623},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]New Del & De-Del'!$A:$A,'[5]New Del & De-Del'!$H:$H)+K25,0)","v":0}]

{"sheet":"EYSFF statement","index":5,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":true,"merged":[[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,5,10],[8,4,8,6],[8,8,8,10]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 27th February 2026"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 25th February 2026"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2026/27 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":2}]
["INDICATIVE Early Years Funding Statement"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[10]Formula!$A:$A,[10]Formula!$C:$C)","v":"Aldermoor Farm Primary School"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
["School Data",null,null,null,"Early Years Rates"]
[null,null,null,null,"Free Entitlement",null,"Extended Entitlement"]
["January 2024 Headcount "]
["IDACI based on January 2025 census",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[15]Sheet1!$A:$A,[15]Sheet1!$D:$D),0)","v":0.24482222222222208},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[15]Sheet1!$A:$A,[15]Sheet1!$D:$D),0)","v":0.24482222222222208}]
["Universal Base Rate",null,null,null,5.56,null,5.56]
["Universal Deprivation Rate",null,null,null,1.67,null,1.67]
[]
[]
[null,null,null,null,"Summer \nTerm 2026",null,"Autumn\nTerm 2026",null,"Spring\nTerm 2027",null,"Whole\nFinancial Year"]
[null,null,null,null,"(12 Weeks)",null,"(15 Weeks)",null,"(11 Weeks)",null,"(38 Weeks)"]
[null,null,null,null,"(Per May 25 census)",null,"(Per Oct 25 census)",null,"(Per Jan 25 census)"]
["Formula Factors",null,null,null,"To be updated",null,"To be updated",null,"To be updated"]
["Free Entitlement Headcount",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[15]Sheet1!$A:$A,[15]Sheet1!$H:$H),0)","v":44},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[16]Sheet1!$A:$A,[16]Sheet1!$O:$O),0)","v":44},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[17]Sheet1!$A:$A,[17]Sheet1!$W:$W),0)","v":45}]
["Free Entitlement Hours Provided",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[15]Sheet1!$A:$A,[15]Sheet1!$G:$G),0)","v":7920},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[16]Sheet1!$A:$A,[16]Sheet1!$N:$N),0)","v":9900},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[17]Sheet1!$A:$A,[17]Sheet1!$V:$V),0)/12*11","v":7425}]
["Extended Entitlement Headcount",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[15]Sheet1!$A:$A,[15]Sheet1!$J:$J),0)","v":7},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[16]Sheet1!$A:$A,[16]Sheet1!$Q:$Q),0)","v":0},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[17]Sheet1!$A:$A,[17]Sheet1!$Y:$Y),0)","v":7}]
["Extended Entitlement Hours Provided",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[15]Sheet1!$A:$A,[15]Sheet1!$I:$I),0)","v":1260},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[16]Sheet1!$A:$A,[16]Sheet1!$P:$P),0)","v":0},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[17]Sheet1!$A:$A,[17]Sheet1!$X:$X),0)/12*11","v":1155}]
[]
["Base Rate Funding",null,null,null,{"$f":"IFERROR((E22+E24)*$E13,0)","v":51040.799999999996},null,{"$f":"IFERROR((G22+G24)*$E13,0)","v":55043.999999999993},null,{"$f":"IFERROR((I22+I24)*$E13,0)","v":47704.799999999996}]
[]
["Deprivation Funding",null,null,null,{"$f":"IFERROR((E21+E23)*$E$14*15*12*$E$12,0)","v":3753.2715599999974},null,{"$f":"IFERROR((G21+G23)*$E$14*15*15*$E$12,0)","v":4047.6457999999966},null,{"$f":"IFERROR((I21+I23)*$E$14*15*11*$E$12,0)","v":3507.9596933333319}]
[]
["Total 2026/27 Funding Under EYSFF (£)",null,null,null,{"$f":"E28+E26","v":54794.071559999997},null,{"$f":"G28+G26","v":59091.645799999991},null,{"$f":"I28+I26","v":51212.759693333326},null,{"$f":"E30+G30+I30","v":165098.47705333331}]
[]
[]
["Note:"]
["This Early Years budget has been estimated based on full participation at the 25/26 census levels for Sum-26 and Aut-26, "]
["and 24/25 census levels for Spr-27 using the 26/27 hourly rates."]
[]
["At this point in time, you will have the best knowledge of relevant pupil numbers and as such are in the best position to estimate "]
["what the EYSFF funding position will be. Work with your SFO's to make an estimate and work through the financial implications."]
[]
["Your actual Early Years funding will be updated through the year to reflect the actual provision delivered as recorded on the"]
["Summer-26, Autumn-26 and Spring-27 school census information. As in previous years, this means that your Early Years"]
["funding will not be finalised until after the Spring 2027 census has been finalised."]

{"sheet":"Further Delegation Info","index":6,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":true,"merged":[[10,0,13,7],[16,0,17,0],[16,1,17,1],[16,2,16,4],[16,5,16,7],[8,0,9,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,7]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 27th February 2026"},null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 25th February 2026"},null,null,null,null,null,"ID"]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2026/27 Funding Allocations for Schools"}]
["Further Delegation Information"]
[]
["All Schools"]
[]
[]
["The 2013/14 School Funding Reform required local authorities to delegate some centrally retained DSG budgets to schools; those budgets are listed below in the columns headed \"Delegated in 2013/14\" for your information.\n"]
[]
["For 2026/27 maintained schools have opted to return some of this funding to the Local Authority to continue central provision of the relevant services. The delegated budget available to each maintained school therefore excludes these returned budgets. The relevant amounts are listed below in the columns headed \"De-delegation in 2026/27\" for your reference."]
[]
[]
[]
[]
[]
["S251 line","Further Delegation Areas","Delegated in 2013/14",null,null,"De-delegation in 2026/27"]
[null,null,"Primary\n(all)\n£","Secondary\n(all)\n£","Total\n(all)\n£","Primary\nMaintained\n£","Secondary\nMaintained\n£","Total\nMaintained\n£"]
["1.1.4","Free school meal eligibility",20899.321122915815,11151.538623932094,32050.859746847909,{"$f":"'[5]New Del & De-Del'!$I$7","v":12381.861948293508},0,{"$f":"SUM(F19:G19)","v":12381.861948293508}]
["1.1.7","Licences/subscriptions",56639.723182411013,35735.642889017559,92375.36607142858,{"$f":"+'[5]New Del & De-Del'!$I$8","v":0},0,{"$f":"SUM(F20:G20)","v":0}]
["1.1.8","Maternity/special staffing suspension",356766.17682212021,225094.12075930767,581860.29758142785,{"$f":"'[5]New Del & De-Del'!$I$9","v":607509.10124981357},0,607509.10124981357]
["1.1.9","Trade Union facility",195944.4399044039,123627.02600013438,319571.46590453829,{"$f":"'[5]New Del & De-Del'!$I$10","v":73588},0,73588]
["1.1.10","School Improvement",0,0,0,{"$f":"'[5]New Del & De-Del'!$I$11","v":0},0,0]
["1.1.3","Ethnic Minority Acheivement Service (EMAS)",991053,284303,1275356,{"$f":"'[5]New Del & De-Del'!$I$12","v":158738.90148490755},0,158738.90148490755]
["1.1.2","Behaviour support services",310504,256781,567285,{"$f":"+'[5]New Del & De-Del'!$I$13","v":0},{"$f":"-'[18]New Del & De-Del'!$J13","v":0},0]
[null,"Totals",{"$f":"SUM(C19:C25)","v":1931806.6610318511},936692.32827239169,2868498.9893042427,852217.86468301457,0,852217.86468301457,null,{"$f":"H26-'[5]New Del & De-Del'!$K$14","v":0}]

{"sheet":"ISB","index":7,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":true,"merged":[[1,0,1,5],[2,0,2,5],[4,0,4,5],[7,0,11,5]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 27th February 2026"},null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 25th February 2026"},null,null,null,"ID"]
["COVENTRY CITY COUNCIL"]
["2026/27 Funding Allocations for Schools"]
[]
["Individual Schools Budget (ISB) 2026/27"]
[]
[]
["This page shows how the Individual Schools Budget (ISB), which is the total of all schools block delegated budget shares, has changed from the previous year. It shows the financial effect, in overall budget terms, of policy and funding decisions in terms of the increased or decreased level of resources for schools. The final ISB figure represents the total level of resources which go into the Fair Funding Formula to produce schools budget shares."]
[]
[]
[]
[]
[]
[null,null,"Schools ","Schools"]
[null,null,"Block","Block"]
[null,null,"(Primary)","(Secondary)"]
[null,null,"£","£"]
[]
[null,"FINAL ISB 2024/25",176665979.38928458,166103758.73568979,null,null,null,null,null,null,null,{"$f":"[19]Schools_block_and_CSSB!$J$5-[19]Schools_block_and_CSSB!$I$5","v":315280287}]
[]
[null,"Resource Adjustments"]
[null,"De-delegation adjustments",{"$f":"-([20]Formula!$AB$93-[21]Formula!$AB$93)","v":-41488.030254384968},null,null,null,null,null,null,null,null,{"$f":"C22","v":-41488.030254384968}]
[null,"NFF - Additional resource",{"$f":"[22]Schools_block_and_CSSB!$C$190","v":3283272.9008370349},{"$f":"[22]Schools_block_and_CSSB!$D$190+[22]Schools_block_and_CSSB!$E$185","v":4246306.6239629695},null,null,null,null,null,null,null,{"$f":"[23]Schools_block_and_CSSB!$J$7-[19]Schools_block_and_CSSB!$J$8-L24+[24]Formula!$AB$93","v":1897090.2291259873}]
[null,"NFF - SBSG & NICs funding rolled into DSG",{"$f":"[22]Schools_block_and_CSSB!$C$189+252639","v":5906647.5991629651},{"$f":"[22]Schools_block_and_CSSB!$D$189-250029","v":4215000.0210370375},null,null,null,null,null,null,null,{"$f":"'[24]Minimum Funding Guarantee'!$M$125","v":22224475.1017}]
[null,"Pupil number changes funding",{"$f":"[22]Schools_block_and_CSSB!$C$183","v":-3217771.0500000003},{"$f":"[22]Schools_block_and_CSSB!$D$183","v":574774.41},null,null,null,null,null,null,null,{"$f":"C25+D25-204","v":-2643200.64}]
[]
[null,"Education Service PPR"]
[]
[null,"Pupil data changes",{"$f":"'[25]Data Changes Impact'!$B$10","v":477622.77000000008},{"$f":"'[25]Data Changes Impact'!$C$10","v":616055.59000000008},null,null,null,null,null,null,null,{"$f":"C29+D29","v":1093678.3600000001}]
[null,"Capping and Scaling",{"$f":"SUM([20]Formula!$Z$7,[20]Formula!$Z$10:$Z$20,[20]Formula!$Z$22:$Z$23,[20]Formula!$Z$25:$Z$29,[20]Formula!$Z$31:$Z$38,[20]Formula!$Z$40:$Z$43,[20]Formula!$Z$45:$Z$50,[20]Formula!$Z$53:$Z$55,[20]Formula!$Z$57:$Z$63,[20]Formula!$Z$65,[20]Formula!$Z$68:$Z$74,[20]Formula!$Z$76:$Z$81,[20]Formula!$Z$83:$Z$92)","v":-450413.01345729257},{"$f":"SUM([20]Formula!$Z$103:$Z$105,[20]Formula!$Z$107:$Z$122,[20]Formula!$Z$124)","v":-562899.62507249659},null,null,null,null,null,null,null,{"$f":"C30+D30","v":-1013312.6385297892}]
[]
[null,"FINAL ISB 2025/26",{"$f":"SUM(C19:C31)","v":182623850.56557289},{"$f":"SUM(D19:D31)","v":175192995.75561729},null,null,null,null,null,null,null,{"$f":"SUM(L19:L30)","v":336797529.38204187}]
[]
[]
[]
["If you have any queries about any of this information, please contact Paul Hammond 7697 2635"]

{"sheet":"LogIn","index":8,"n_rows":85,"n_cols":3,"rows_kept":85,"cut":false,"hidden":true,"merged":[]}
["User Name","Password","ID"]
["Alderman's Green ","NcR96Na",1]
["Aldermoor Farm","8UBcN4",2]
["Allesley","uE98HX",3]
["Allesley Hall","c2r66H",4]
["Broad Heath","94ctnJ",5]
["Cannon Park","4V8gK4",6]
["Charter","bHkpG8a",7]
["Clifford Bridge ","VksmRa1a",8]
["Coundon Primary","4Y428c",9]
["Courthouse Green","BE75nX1a",10]
["Earlsdon","ZkcST6",11]
["Eastern Green Junior","24x4Xc",12]
["Edgewick","R3kRR4",13]
["Ernesford Grange","GKD5A2",14]
["Finham","9TWJzm1a",15]
["Frederick Bird","agw9kda",16]
["Gosford Park ","cuxXcd",17]
["Grange Farm","V2DGxe",18]
["Grangehurst","aFbkW3",19]
["Hearsall ","3JcVC31a",20]
["Henley Green","J5cwAZ",21]
["Hill Farm Academy","8S7cc81a",22]
["Holbrook ","GkEHwt",23]
["Hollyfast","D4N45K",24]
["Howes","ccAeb5",25]
["John Gulson","26cA4V",26]
["John Shelton","B8cds4",27]
["Joseph Cash ","33GsH6",28]
["Keresley Grange","RPPyVD1a",29]
["Limbrick Wood ","uk7NEQa",30]
["Little Heath","Av3kpba",31]
["Longford Park ","79byb7",32]
["Manor Park","MkRSqT",33]
["Moathouse","7URcPj",34]
["Moseley","FHQ99Q",35]
["Mount Nod","t9C84k",36]
["Parkgate","vk7KgW1a",37]
["Parkhill","CDXegf",38]
["Pearl Hyde","j3MNSS1a",39]
["Potters Green","YEy8sya",40]
["Radford Academy","p43M6w1a",41]
["Ravensdale","APVTV2",42]
["Richard Lee","hAt28j1a",43]
["Sir Frank Whittle","GX72Yc1a",44]
["St. Christopher","47967b",45]
["Southfields ","5Wbz28",46]
["Sowe Valley","CmbnbG",47]
["Spon Gate ","kyX882",48]
["Stanton Bridge ","334HJR1a",49]
["Stivichall","7Qc6H3",50]
["Stoke","6R28Wf",51]
["Stoke Heath","abbM4V",52]
["Templars","X23zbq",53]
["Whitley Abbey","64t3u4",54]
["Whitmore Park","bY76ab",55]
["Whoberley Hall","Q6kTTB",56]
["Willenhall Community","rHAW8H",57]
["Wyken Croft","U4pEJ3",58]
["All Saints' CE","BgJH5H",59]
["All Souls' RC","5dQG7T",60]
["Christ the King RC Primary","AbcSYP1a",61]
["Corpus Christi RC","E446Hn1a",62]
["St Laurance's CE Academy","j877qE1a",63]
["Good Shepherd RC","ZX6bRM1a",64]
["Holy Family RC","y8FdX4",65]
["Leigh CE","y5ZNQz1a",66]
["Our Lady of the Assumption RC","6f89MQ",67]
["Sacred Heart RC","4n6E5w1a",68]
["St. Andrew's CE Infant","zS5569",69]
["St. Anne's RC","H2YK64",70]
["St. Augustine's RC","cAb7FY1a",71]
["St. Bartholomew's Academy","CPKbKb1a",72]
["St. Elizabeth's RC","2s47541a",73]
["St. Gregory's RC","YHzVS61a",74]
["St. John Fisher RC","G97Ncj1a",75]
["St. John Vianney RC","RkP3wb1a",76]
["St. John's CE","WV25551a",77]
["St. Mary's & St. Benedict's RC","hNW6cM",78]
["St. Osburg's RC","D7UP4r",79]
["St. Patrick's RC","6bP7aV1a",80]
["Sts. Peter & Paul RC","K43Jb31a",81]
["St. Thomas More RC","Kc3rR81a",82]
["Stretton CE Academy","BMJT831a",83]
["Walsgrave CE","DM93SH1a",84]

{"sheet":"LoginPage","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Funding Floor","index":10,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":true,"merged":[[19,8,19,9],[33,8,33,9],[8,8,8,9],[31,8,31,9],[21,8,21,9],[26,8,26,9],[13,8,13,9],[17,8,17,9],[1,0,1,11],[2,0,2,11],[3,0,3,11],[5,0,5,11],[15,8,15,9]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 27th February 2026"},null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 25th February 2026"}]
["COVENTRY CITY COUNCIL - PEOPLE'S DIRECTORATE"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2026/27 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":2}]
["Calculation of Funding Floor"]
[]
[{"$f":"VLOOKUP((\"P\"&N3),[26]Formula!$A$10:$X$96,3,FALSE)","v":"Aldermoor Farm"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
[null,null,null,null,null,null,null,null,"£",null,null,"£"]
[]
["2020/21 Total funding allocated after MFL",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":2231473.8862602995},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)-L11","v":0}]
[]
["Less: "]
["2020/21 Mobility",null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,7,FALSE)","v":5562.3874731538936},{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":2231473.8862602995},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,7,FALSE)-I14","v":0}]
[]
["2020/21 Lump Sum",null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,8,FALSE)","v":110364.09999999999},{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":2231473.8862602995},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,8,FALSE)-I16","v":0}]
[]
["2020/21 Split Site",null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,9,FALSE)","v":0},{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":2231473.8862602995},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,9,FALSE)-I18","v":0}]
[]
["2020/21 Rates Funding",null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,11,FALSE)","v":56082.210000000006},{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":2231473.8862602995},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,11,FALSE)-I20","v":0}]
[]
["2020/21 Education Improvement Commissioning Pot",null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,12,FALSE)","v":4491.5952068513207},{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":2231473.8862602995},null,{"$f":"-SUM(I14:I22)","v":-176500.29268000519},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,12,FALSE)-I22","v":0}]
[]
[]
["2020/21 Pupil Led Funding",null,null,null,null,null,null,null,null,null,null,{"$f":"L11+L22","v":2054973.5935802944},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,15,FALSE)-L25","v":0}]
[]
["October 2019 Pupil Number",null,null,null,null,null,null,"[A]",{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,17,FALSE)","v":497},{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":2231473.8862602995},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,17,FALSE)-I27","v":0}]
[]
["2020/21 Pupil Led Funding (per pupil)",null,null,null,null,null,null,"[B]",null,null,null,{"$f":"L25/I27","v":4134.755721489526},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,18,FALSE)-L29","v":0}]
[]
[]
["2017/18 calculated Funding Floor (FF) per Pupil ",null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,4,FALSE)","v":4529.9633999999996},{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":2231473.8862602995},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,4,FALSE)-I32","v":0}]
[]
["2020/21 Funding Floor protection level",null,null,null,null,null,null,null,0.01]
[]
["Funding Floor per pupil",null,null,null,null,null,null,"[C]",null,null,null,{"$f":"I32*(1+I34)","v":4575.2630339999996}]
[]
["Shortfall to Funding Floor per pupil",null,null,null,null,null,null,"[D] = [C] - [B]",null,null,null,{"$f":"IF(L29<L36,L36-L29,0)","v":440.50731251047364}]
[]
[]
[]
["2020/21 Funding Floor Adjustment",null,null,null,null,null,null,"= [A] x [D]",null,null,null,{"$f":"L38*I27","v":218932.13431770541},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,21,FALSE)-L42","v":0}]