{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["5 Year Renewal Charter Budget"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":8,"comments":1,"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":"5 Year Renewal Charter Budget","index":0,"n_rows":189,"n_cols":24,"rows_kept":189,"cut":false,"hidden":false,"merged":[[7,13,11,13],[16,8,16,12],[17,8,17,12],[2,1,2,5],[3,1,3,5],[4,1,4,5],[2,6,2,12],[3,6,3,12],[4,6,4,12],[19,8,19,12],[16,1,16,7],[1,1,1,12],[6,1,6,12],[7,1,7,12],[14,1,15,4],[14,6,15,6],[14,7,15,7],[5,6,5,12],[5,1,5,5]]}
[]
[null,"Charter School Name Here"]
[null,"Contact Name:"]
[null,"Contact Email:"]
[null,"Contact Phone:"]
[null,"Proposed Renewal Charter Term:",null,null,null,null,"(Example) July 1, 2024 to June 30, 2029"]
[null,"PROJECTED BUDGET FOR RENEWAL CHARTER PERIOD",null,null,null,null,null,null,null,null,null,null,null,"DESCRIPTION OF ASSUMPTIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: The completion of this section is mandatory as this additional information is essential for NYSED to follow the assumptions in your budget. "]
[null,"Total Revenue",null,null,null,null,null,null,{"$f":"I54","v":0},{"$f":"J54","v":0},{"$f":"K54","v":0},{"$f":"L54","v":0},{"$f":"M54","v":0}]
[null,"Total Expenses",null,null,null,null,null,null,{"$f":"I150","v":0},{"$f":"J150","v":0},{"$f":"K150","v":0},{"$f":"L150","v":0},{"$f":"M150","v":0}]
[null,"Net Income (Before Cash Flow Adjustments)",null,null,null,null,null,null,{"$f":"I9-I10","v":0},{"$f":"J152","v":0},{"$f":"K152","v":0},{"$f":"L152","v":0},{"$f":"M152","v":0}]
[null,"Actual Student Enrollment",null,null,null,null,null,null,{"$f":"I163","v":0},{"$f":"J163","v":0},{"$f":"K163","v":0},{"$f":"L163","v":0},{"$f":"M163","v":0}]
[null,"Total Paid Student Enrollment",null,null,null,null,null,null,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,null,null,null,null,null,null,"2024-2025","2025-2026","2026-2027","2027-2028","2028-2029"]
[null,"Note: Please insert additional detail lines as appropriate."]
[null,"REVENUE",null,null,null,null,null,null,"Per Pupil Revenue Percentage Increase"]
[null,null,"REVENUES FROM STATE SOURCES",null,null,null,null,null,0,0,0,0,0]
[null,null,null,"Per Pupil Revenue:",null,null,"CY Per Pupil Rate",null,"https://stateaid.nysed.gov/charter/"]
[null,null,null,null,"School District 1 (Enter Name)",null,null,null,0,0,0,0,0]
[null,null,null,null,"School District 2 (Enter Name)",null,null,null,0,0,0,0,0]
[null,null,null,null,"School District 3 (Enter Name)",null,null,null,0,0,0,0,0]
[null,null,null,null,"School District 4 (Enter Name)",null,null,null,0,0,0,0,0]
[null,null,null,null,"School District 5 (Enter Name)",null,null,null,0,0,0,0,0]
[null,null,null,null,"School District 6 (Enter Name)",null,null,null,0,0,0,0,0]
[null,null,null,null,"School District - ALL OTHER",null,null,null,0,0,0,0,0]
[null,null,null,"TOTAL Per Pupil Revenue (Average Districts Per Pupil Funding)",null,null,{"$f":"IF(G21>0,SUM(G21:G27)/X28,0)","v":0},null,{"$f":"SUM(I21:I27)","v":0},{"$f":"SUM(J21:J27)","v":0},{"$f":"SUM(K21:K27)","v":0},{"$f":"SUM(L21:L27)","v":0},{"$f":"SUM(M21:M27)","v":0},null,null,null,{"$f":"IF(G21>0,1,IF(G21=0,0,0))","v":0},{"$f":"IF(G22>0,1,IF(G22=0,0,0))","v":0},{"$f":"IF(G23>0,1,IF(G23=0,0,0))","v":0},{"$f":"IF(G24>0,1,IF(G24=0,0,0))","v":0},{"$f":"IF(G25>0,1,IF(G25=0,0,0))","v":0},{"$f":"IF(G26>0,1,IF(G26=0,0,0))","v":0},{"$f":"IF(G27>0,1,IF(G27=0,0,0))","v":0},{"$f":"SUM(Q28:W28)","v":0}]
[null,null,null,"Special Education Revenue",null,null,null,null,0,0,0,0,0,null,null,null,21,22,23,24,25,26,27]
[null,null,null,"Grants"]
[null,null,null,"Other",null,null,null,null,0,0,0,0,0]
[null,null,"TOTAL REVENUE FROM STATE SOURCES",null,null,null,null,null,{"$f":"SUM(I28:I31)","v":0},{"$f":"SUM(J28:J31)","v":0},{"$f":"SUM(K28:K31)","v":0},{"$f":"SUM(L28:L31)","v":0},{"$f":"SUM(M28:M31)","v":0}]
[]
[null,null,"REVENUE FROM FEDERAL FUNDING"]
[null,null,null,"IDEA Special Needs",null,null,null,null,0,0,0,0,0]
[null,null,null,"Title I",null,null,null,null,0,0,0,0,0]
[null,null,null,"Title Funding - Other",null,null,null,null,0,0,0,0,0]
[null,null,null,"School Food Service (Free Lunch)",null,null,null,null,0,0,0,0,0]
[null,null,null,"CARES/ARP Funding"]
[null,null,null,"Grants"]
[null,null,"TOTAL REVENUE FROM FEDERAL SOURCES",null,null,null,null,null,{"$f":"SUM(I35:I40)","v":0},{"$f":"SUM(J35:J40)","v":0},{"$f":"SUM(K35:K40)","v":0},{"$f":"SUM(L35:L40)","v":0},{"$f":"SUM(M35:M40)","v":0}]
[]
[null,null,"LOCAL and OTHER REVENUE"]
[null,null,null,"Contributions and Donations",null,null,null,null,0,0,0,0,0]
[null,null,null,"Fundraising",null,null,null,null,0,0,0,0,0]
[null,null,null,"Erate Reimbursement",null,null,null,null,0,0,0,0,0]
[null,null,null,"Earnings on Investments",null,null,null,null,0,0,0,0,0]
[null,null,null,"Interest Income",null,null,null,null,0,0,0,0,0]
[null,null,null,"Food Service (Income from meals)",null,null,null,null,0,0,0,0,0]
[null,null,null,"Text Book",null,null,null,null,0,0,0,0,0]
[null,null,null,"OTHER",null,null,null,null,0,0,0,0,0]
[null,null,"TOTAL REVENUE FROM LOCAL and OTHER SOURCES",null,null,null,null,null,{"$f":"SUM(I44:I51)","v":0},{"$f":"SUM(J44:J51)","v":0},{"$f":"SUM(K44:K51)","v":0},{"$f":"SUM(L44:L51)","v":0},{"$f":"SUM(M44:M51)","v":0}]
[]
[null,"TOTAL REVENUE ",null,null,null,null,null,null,{"$f":"I52+I41+I32","v":0},{"$f":"J52+J41+J32","v":0},{"$f":"K52+K41+K32","v":0},{"$f":"L52+L41+L32","v":0},{"$f":"M52+M41+M32","v":0}]
[]
[null,"EXPENSES"]
[null,null,"ADMINISTRATIVE STAFF PERSONNEL COSTS",null,null,null,"No. of Positions"]
[null,null,null,"Executive Management",null,null,0,null,0,0,0,0,0]
[null,null,null,"Instructional Management",null,null,0,null,0,0,0,0,0]
[null,null,null,"Deans, Directors & Coordinators",null,null,0,null,0,0,0,0,0]
[null,null,null,"CFO / Director of Finance",null,null,0,null,0,0,0,0,0]
[null,null,null,"Operation / Business Manager",null,null,0,null,0,0,0,0,0]
[null,null,null,"Administrative Staff",null,null,0,null,0,0,0,0,0]
[null,null,"TOTAL ADMINISTRATIVE STAFF",null,null,null,{"$f":"SUM(G58:G63)","v":0},null,{"$f":"SUM(I58:I63)","v":0},{"$f":"SUM(J58:J63)","v":0},{"$f":"SUM(K58:K63)","v":0},{"$f":"SUM(L58:L63)","v":0},{"$f":"SUM(M58:M63)","v":0}]
[]
[null,null,"INSTRUCTIONAL PERSONNEL COSTS"]
[null,null,null,"Teachers - Regular",null,null,0,null,0,0,0,0,0]
[null,null,null,"Teachers - SPED",null,null,0,null,0,0,0,0,0]
[null,null,null,"Substitute Teachers",null,null,0,null,0,0,0,0,0]
[null,null,null,"Teaching Assistants",null,null,0,null,0,0,0,0,0]
[null,null,null,"Specialty Teachers",null,null,0,null,0,0,0,0,0]
[null,null,null,"Aides",null,null,0,null,0,0,0,0,0]
[null,null,null,"Therapists & Counselors",null,null,0,null,0,0,0,0,0]
[null,null,null,"Other",null,null,0,null,0,0,0,0,0]
[null,null,"TOTAL INSTRUCTIONAL",null,null,null,{"$f":"SUM(G67:G74)","v":0},null,{"$f":"SUM(I67:I74)","v":0},{"$f":"SUM(J67:J74)","v":0},{"$f":"SUM(K67:K74)","v":0},{"$f":"SUM(L67:L74)","v":0},{"$f":"SUM(M67:M74)","v":0}]
[]
[null,null,"NON-INSTRUCTIONAL PERSONNEL COSTS"]
[null,null,null,"Nurse",null,null,0,null,0,0,0,0,0]
[null,null,null,"Librarian",null,null,0,null,0,0,0,0,0]
[null,null,null,"Custodian",null,null,0,null,0,0,0,0,0]
[null,null,null,"Security",null,null,0,null,0,0,0,0,0]
[null,null,null,"Other",null,null,0,null,0,0,0,0,0]
[null,null,"TOTAL NON-INSTRUCTIONAL",null,null,null,{"$f":"SUM(G78:G82)","v":0},null,{"$f":"SUM(I78:I82)","v":0},{"$f":"SUM(J78:J82)","v":0},{"$f":"SUM(K78:K82)","v":0},{"$f":"SUM(L78:L82)","v":0},{"$f":"SUM(M78:M82)","v":0}]
[]
[null,null,"SUBTOTAL PERSONNEL SERVICE COSTS",null,null,null,{"$f":"G64+G75+G83","v":0},null,{"$f":"I64+I75+I83","v":0},{"$f":"J64+J75+J83","v":0},{"$f":"K64+K75+K83","v":0},{"$f":"L64+L75+L83","v":0},{"$f":"M64+M75+M83","v":0}]
[]
[null,null,"PAYROLL TAXES AND BENEFITS"]
[null,null,null,"Payroll Taxes",null,null,null,null,0,0,0,0,0]
[null,null,null,"Fringe / Employee Benefits",null,null,null,null,0,0,0,0,0]
[null,null,null,"Retirement / Pension",null,null,null,null,0,0,0,0,0]
[null,null,"TOTAL PAYROLL TAXES AND BENEFITS",null,null,null,null,null,{"$f":"SUM(I88:I90)","v":0},{"$f":"SUM(J88:J90)","v":0},{"$f":"SUM(K88:K90)","v":0},{"$f":"SUM(L88:L90)","v":0},{"$f":"SUM(M88:M90)","v":0}]
[]
[null,null,"TOTAL PERSONNEL SERVICE COSTS",null,null,null,{"$f":"G85","v":0},null,{"$f":"I85+I91","v":0},{"$f":"J85+J91","v":0},{"$f":"K85+K91","v":0},{"$f":"L85+L91","v":0},{"$f":"M85+M91","v":0}]
[]
[null,null,"CONTRACTED SERVICES"]
[null,null,null,"Accounting / Audit ",null,null,null,null,0,0,0,0,0]
[null,null,null,"Legal",null,null,null,null,0,0,0,0,0]
[null,null,null,"Management Company Fee",null,null,null,null,0,0,0,0,0]
[null,null,null,"Nurse Services",null,null,null,null,0,0,0,0,0]
[null,null,null,"Food Service / School Lunch",null,null,null,null,0,0,0,0,0]
[null,null,null,"Payroll Services",null,null,null,null,0,0,0,0,0]
[null,null,null,"Special Ed Services",null,null,null,null,0,0,0,0,0]
[null,null,null,"Titlement Services (i.e. Title I)",null,null,null,null,0,0,0,0,0]
[null,null,null,"Related service provider costs not reimbursed by the district of residence"]
[null,null,null,"Other Purchased / Professional / Consulting",null,null,null,null,0,0,0,0,0]
[null,null,"TOTAL CONTRACTED SERVICES",null,null,null,null,null,{"$f":"SUM(I96:I105)","v":0},{"$f":"SUM(J96:J105)","v":0},{"$f":"SUM(K96:K105)","v":0},{"$f":"SUM(L96:L105)","v":0},{"$f":"SUM(M96:M105)","v":0}]
[]
[null,null,"SCHOOL OPERATIONS"]
[null,null,null,"Board Expenses",null,null,null,null,0,0,0,0,0]
[null,null,null,"Board Development"]
[null,null,null,"Classroom / Teaching Supplies & Materials",null,null,null,null,0,0,0,0,0]
[null,null,null,"Special Ed Supplies & Materials",null,null,null,null,0,0,0,0,0]
[null,null,null,"Textbooks / Workbooks",null,null,null,null,0,0,0,0,0]
[null,null,null,"Supplies & Materials other",null,null,null,null,0,0,0,0,0]
[null,null,null,"Equipment / Furniture",null,null,null,null,0,0,0,0,0]
[null,null,null,"Telephone ",null,null,null,null,0,0,0,0,0]
[null,null,null,"Technology",null,null,null,null,0,0,0,0,0]
[null,null,null,"Student Testing & Assessment",null,null,null,null,0,0,0,0,0]
[null,null,null,"Field Trips",null,null,null,null,0,0,0,0,0]
[null,null,null,"Transportation (student)",null,null,null,null,0,0,0,0,0]
[null,null,null,"Student Services - other",null,null,null,null,0,0,0,0,0]
[null,null,null,"Office Expense",null,null,null,null,0,0,0,0,0]
[null,null,null,"Staff Development",null,null,null,null,0,0,0,0,0]
[null,null,null,"Staff Recruitment",null,null,null,null,0,0,0,0,0]
[null,null,null,"Student Recruitment / Marketing",null,null,null,null,0,0,0,0,0]
[null,null,null,"School Meals / Lunch",null,null,null,null,0,0,0,0,0]
[null,null,null,"Travel (Staff)",null,null,null,null,0,0,0,0,0]
[null,null,null,"Fundraising",null,null,null,null,0,0,0,0,0]
[null,null,null,"Other",null,null,null,null,0,0,0,0,0]
[null,null,"TOTAL SCHOOL OPERATIONS",null,null,null,null,null,{"$f":"SUM(I109:I129)","v":0},{"$f":"SUM(J109:J129)","v":0},{"$f":"SUM(K109:K129)","v":0},{"$f":"SUM(L109:L129)","v":0},{"$f":"SUM(M109:M129)","v":0}]
[]
[null,null,"FACILITY OPERATION & MAINTENANCE"]
[null,null,null,"Insurance",null,null,null,null,0,0,0,0,0]
[null,null,null,"Janitorial",null,null,null,null,0,0,0,0,0]
[null,null,null,"Building and Land Rent / Lease",null,null,null,null,0,0,0,0,0]
[null,null,null,"Repairs & Maintenance ",null,null,null,null,0,0,0,0,0]
[null,null,null,"Equipment / Furniture",null,null,null,null,0,0,0,0,0]
[null,null,null,"Security",null,null,null,null,0,0,0,0,0]
[null,null,null,"Utilities",null,null,null,null,0,0,0,0,0]
[null,null,"TOTAL FACILITY OPERATION & MAINTENANCE",null,null,null,null,null,{"$f":"SUM(I133:I139)","v":0},{"$f":"SUM(J133:J139)","v":0},{"$f":"SUM(K133:K139)","v":0},{"$f":"SUM(L133:L139)","v":0},{"$f":"SUM(M133:M139)","v":0}]
[]
[null,null,"DEPRECIATION & AMORTIZATION"]
[null,null,null,"Insert Detail as Applicable",null,null,null,null,0,0,0,0,0]
[null,null,null,"Insert Detail as Applicable",null,null,null,null,0,0,0,0,0]
[null,null,null,"Insert Detail as Applicable",null,null,null,null,0,0,0,0,0]
[null,null,"TOTAL DEPRECIATION AND AMORTIZATION",null,null,null,null,null,{"$f":"SUM(I143:I145)","v":0},{"$f":"SUM(J143:J145)","v":0},{"$f":"SUM(K143:K145)","v":0},{"$f":"SUM(L143:L145)","v":0},{"$f":"SUM(M143:M145)","v":0}]
[]
[null,null,"*****TOTAL FUNDS IN DISSOLUTION ESCROW & RESERVES / CONTIGENCY",null,null,null,null,null,0,0,0,0,0,"    Note: School needs to maintain an escrow account of no less than  $100,000 by December 31st of  YR 2 (2024-2025). You should already have $75K set aside for this purpose and  now need to add 25K. NYSED may request most recent bank statements to support this entry."]
[]
[null,"TOTAL EXPENSES",null,null,null,null,null,null,{"$f":"I93+I106+I130+I140+I146+I148","v":0},{"$f":"J93+J106+J130+J140+J146+J148","v":0},{"$f":"K93+K106+K130+K140+K146+K148","v":0},{"$f":"L93+L106+L130+L140+L146+L148","v":0},{"$f":"M93+M106+M130+M140+M146+M148","v":0}]
[]
[null,"NET INCOME",null,null,null,null,null,null,{"$f":"I54-I150","v":0},{"$f":"J54-J150","v":0},{"$f":"K54-K150","v":0},{"$f":"L54-L150","v":0},{"$f":"M54-M150","v":0}]
[]
[]
[null,"ENROLLMENT - *School Districts Are Linked To Above Entries*",null,null,null,null,null,null,null,null,null,null,null,"Add as many school districts as necessary. "]
[null,null,null,null,{"$f":"E21","v":"School District 1 (Enter Name)"},null,null,null,0,0,0,0,0]
[null,null,null,null,"School District 2 (Enter Name)",null,null,null,0,0,0,0,0]
[null,null,null,null,"School District 3 (Enter Name)",null,null,null,0,0,0,0,0]
[null,null,null,null,"School District 4 (Enter Name)",null,null,null,0,0,0,0,0]
[null,null,null,null,"School District 5 (Enter Name)",null,null,null,0,0,0,0,0]
[null,null,null,null,"School District 6 (Enter Name)",null,null,null,0,0,0,0,0]
[null,null,null,null,"School District - ALL OTHER",null,null,null,0,0,0,0,0]
[null,"TOTAL ENROLLMENT",null,null,null,null,null,null,{"$f":"SUM(I156:I162)","v":0},{"$f":"SUM(J156:J162)","v":0},{"$f":"SUM(K156:K162)","v":0},{"$f":"SUM(L156:L162)","v":0},{"$f":"SUM(M156:M162)","v":0}]
[]
[null,"REVENUE PER PUPIL",null,null,null,null,null,null,{"$f":"IF(I163>0,I54/I163,0)","v":0},{"$f":"IF(J163>0,J54/J163,0)","v":0},{"$f":"IF(K163>0,K54/K163,0)","v":0},{"$f":"IF(L163>0,L54/L163,0)","v":0},{"$f":"IF(M163>0,M54/M163,0)","v":0}]
[]
[null,"EXPENSES PER PUPIL",null,null,null,null,null,null,{"$f":"IF(I163>0,I150/I163,0)","v":0},{"$f":"IF(J163>0,J150/J163,0)","v":0},{"$f":"IF(K163>0,K150/K163,0)","v":0},{"$f":"IF(L163>0,L150/L163,0)","v":0},{"$f":"IF(M163>0,M150/M163,0)","v":0}]
[]
[null,"CASH FLOW ADJUSTMENTS"]
[null,null,"OPERATING ACTIVITIES"]
[null,null,null,"Example - Add Back Depreciation",null,null,null,null,0,0,0,0,0]
[null,null,null,"Other",null,null,null,null,0,0,0,0,0]
[null,null,"Total Operating Activities",null,null,null,null,null,{"$f":"I171+I172","v":0},{"$f":"J171+J172","v":0},{"$f":"K171+K172","v":0},{"$f":"L171+L172","v":0},{"$f":"M171+M172","v":0}]
[null,null,"INVESTMENT ACTIVITIES"]
[null,null,null,"Example - Subtract Property and Equipment Expenditures",null,null,null,null,0,0,0,0,0]
[null,null,null,"Other",null,null,null,null,0,0,0,0,0]
[null,null,"Total Investment Activities",null,null,null,null,null,{"$f":"I175+I176","v":0},{"$f":"J175+J176","v":0},{"$f":"K175+K176","v":0},{"$f":"L175+L176","v":0},{"$f":"M175+M176","v":0}]
[null,null,"FINANCING ACTIVITIES"]
[null,null,null,"Example - Add Expected Proceeds from a Loan or Line of Credit",null,null,null,null,0,0,0,0,0]
[null,null,null,"Other",null,null,null,null,0,0,0,0,0]
[null,null,"Total Financing Activities",null,null,null,null,null,{"$f":"I179+I180","v":0},{"$f":"J179+J180","v":0},{"$f":"K179+K180","v":0},{"$f":"L179+L180","v":0},{"$f":"M179+M180","v":0}]
[]
[null,"Total Cash Flow Adjustments",null,null,null,null,null,null,{"$f":"I173+I177+I181","v":0},{"$f":"J173+J177+J181","v":0},{"$f":"K173+K177+K181","v":0},{"$f":"L173+L177+L181","v":0},{"$f":"M173+M177+M181","v":0}]
[]
[null,"NET INCOME",null,null,null,null,null,null,{"$f":"I152+I183","v":0},{"$f":"J152+J183","v":0},{"$f":"K152+K183","v":0},{"$f":"L152+L183","v":0},{"$f":"M152+M183","v":0}]
[]
[null,"Beginning Cash Balance",null,null,null,null,null,null,0,{"$f":"I189","v":0},{"$f":"J189","v":0},{"$f":"K189","v":0},{"$f":"L189","v":0}]
[]
[null,"ENDING CASH BALANCE",null,null,null,null,null,null,{"$f":"I185+I187","v":0},{"$f":"J185+J187","v":0},{"$f":"K185+K187","v":0},{"$f":"L185+L187","v":0},{"$f":"M185+M187","v":0}]