{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Certification","Alternative Form","Data","MACROS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":92,"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":"Certification","index":0,"n_rows":54,"n_cols":25,"rows_kept":54,"cut":false,"hidden":false,"merged":[[22,8,22,12],[20,4,20,6],[16,14,16,15],[18,14,18,15],[20,14,20,15],[22,14,22,15],[18,8,18,12],[20,8,20,12],[6,10,6,15],[7,10,7,15],[8,10,8,15],[9,10,9,15],[12,4,12,15],[11,4,11,15],[15,8,15,11],[44,5,44,9],[44,12,44,14],[10,10,10,15],[36,12,36,14],[36,5,36,9],[28,5,28,9],[31,5,31,9],[28,12,28,14],[39,5,39,9],[39,12,39,14],[31,12,31,14],[16,4,16,6],[18,4,18,6],[22,4,22,6],[16,8,16,12]]}
["CHARTER SCHOOL UNAUDITED ACTUALS"]
["FINANCIAL REPORT -- ALTERNATIVE FORM"]
["July 1, 2021  to  June 30, 2022"]
[]
["CHARTER SCHOOL CERTIFICATION"]
[]
[null,null,null,null,null,null,null,null,null,"Charter School Name:","Three Rivers Charter School"]
[null,null,null,null,null,null,null,null,null,"CDS #:",{"$f":"TRIM(LEFT(SUBSTITUTE(MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,255),\".xl\",REPT(\" \",255)),255))","v":"23655650123737"}]
[null,null,null,null,null,null,null,null,null,"Charter Approving Entity:","Fort Bragg Unified School District"]
[null,null,null,null,null,null,null,null,null,"County:"," Mendocino"]
[null,null,null,null,null,null,null,null,null,"Charter #:"," 1275"]
[]
[null,null,null,null,"NOTE:  An Alternative Form submitted to the California Department of Education will not be considered a valid submission if the following information is missing:"]
[null,null,null,null,"For information regarding this report, please contact:"]
[]
[null,null,null,null,"For County Fiscal Contact:",null,null,null,"For Approving Entity:",null,null,null,null," ","For Charter School:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," Susan Lefkowitz"]
[null,null,null,null,"Name",null,null,null,"Name",null,null," ",null," ","Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," Regional School Business Director"]
[null,null,null,null,"Title",null,null,null,"Title",null,null," ",null," ","Title"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," 951-694-3050"]
[null,null,null,null,"Telephone",null,null,null,"Telephone",null,null," ",null," ","Telephone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"slefkowitz@csmci.com"]
[null,null,null,null,"Email address",null,null,null,"Email address",null,null," ",null," ","Email address"]
[]
[null,null,null,null,"To the entity that approved the charter school:"]
["(","X",")",null,"2021-22 CHARTER SCHOOL UNAUDITED ACTUALS FINANCIAL REPORT -- ALTERNATIVE FORM:  This report"]
[null,null,null,null,"has been approved, and is hereby filed by the charter school pursuant to Education Code Section 42100(b)."]
[null,null,null,null,"Signed:",null,null,null,null,null,null,"      Date:"]
[null,null,null,null,null,"Charter School Official"]
[null,null,null,null,null,"(Original signature required)"]
[null,null,null,null,"Printed\nName:","Roger Coy",null,null,null,null,null,"       Title:","Director"]
[]
[null,null,null,null,"To the County Superintendent of Schools:"]
["(","X",")",null,"2021-22 CHARTER SCHOOL UNAUDITED ACTUALS FINANCIAL REPORT -- ALTERNATIVE FORM:  This report"]
[null,null,null,null,"is hereby filed with the County Superintendent pursuant to Education Code Section 42100(a)."]
[null,null,null,null,"Signed:",null,null,null,null,null,null,"      Date:"]
[null,null,null,null,null,"Authorized Representative of\nCharter Approving Entity"]
[null,null,null,null,null,"(Original signature required)"]
[null,null,null,null,"Printed\nName:",null,null,null,null,null,null,"       Title:"]
[]
[null,null,null,null,"To the Superintendent of Public Instruction:"]
["(","X",")",null,"2021-22 CHARTER SCHOOL UNAUDITED ACTUALS FINANCIAL REPORT -- ALTERNATIVE FORM:  This report has been"]
[null,null,null,null,"verified for mathematical accuracy by the County Superintendent of Schools pursuant to Education Code Section 42100(a)."]
[null,null,null,null,"Signed:",null,null,null,null,null,null,"      Date:"]
[null,null,null,null,null,"County Superintendent/Designee"]
[null,null,null,null,null,"(Original signature required)"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",2004.1]

{"sheet":"Alternative Form","index":1,"n_rows":284,"n_cols":16,"rows_kept":284,"cut":false,"hidden":false,"merged":[[1,0,1,7],[3,0,3,7],[2,0,2,7],[6,0,6,3],[5,0,5,3],[6,4,6,7],[5,4,5,7],[143,2,143,4],[9,0,9,3],[7,4,7,7],[8,4,8,7],[9,4,9,7],[8,0,8,3],[7,0,7,3]]}
["c1","c2","c3",4,"objcode","unrestr","restr","ttl"]
["CHARTER SCHOOL UNAUDITED ACTUALS"]
["FINANCIAL REPORT -- ALTERNATIVE FORM"]
["July 1, 2021 to  June 30, 2022"]
[]
["Charter School Name:",null,null,null,{"$f":"Certification!K7","v":"Three Rivers Charter School"}]
["CDS #:",null,null,null,{"$f":"Certification!K8","v":"23655650123737"}]
["Charter Approving Entity:",null,null,null,{"$f":"Certification!K9","v":"Fort Bragg Unified School District"}]
["County:",null,null,null,{"$f":"Certification!K10","v":" Mendocino"}]
["Charter #:",null,null,null,{"$f":"Certification!K11","v":" 1275"}]
[null,"This charter school uses the following basis of accounting:"]
[null,"(Please enter an \"X\" in the applicable box below; check only one box)"]
[null,"X","Accrual Basis (Applicable Capital Assets/Interest on Long-Term Debt/Long-Term Liabilities/Net Position objects are 6900, 6910, 7438, "]
[null,null,null,"9400-9489, 9660-9669, 9796, and 9797)"]
[null,null,"Modified Accrual Basis (Applicable Capital Outlay/Debt Service/Fund Balance objects are 6100-6170, 6200-6500, 6600, 7438, 7439,"]
[null," "," ","and 9711-9789) "]
[]
[null,null,null,"              Description","Object Code","Unrestricted","Restricted","Total"]
["A.","REVENUES",null,null," "]
[null,"1.","LCFF Sources",null," "]
[null,null,null,"State Aid - Current Year",8011,368867,null,{"$f":"SUM(F21)","v":368867}]
[null,null,null,"Education Protection Account State Aid - Current Year",8012,168780,null,168780]
[null,null,null,"State Aid - Prior Years",8019,0,null,0]
[null,null,null,"Transfers to Charter Schools in Lieu of Property Taxes",8096,332692,null,{"$f":"SUM(F24)","v":332692}]
[null,null,null,"Other LCFF Transfers","8091, 8097",0,0,{"$f":"SUM(F25:G25)","v":0}]
[null,null,null,"          Total, LCFF Sources"," ",{"$f":"SUM(F21:F25)","v":870339},{"$f":"SUM(G25)","v":0},{"$f":"SUM(F26:G26)","v":870339}]
[null,null,null,null," "]
[null,"2.","Federal Revenues (see NOTE in Section L)",null," "]
[null,null,null,"No Child Left Behind/Every Student Succeeds Act",8290,null,45730.26,{"$f":"SUM(G29)","v":45730.26}]
[null,null,null,"Special Education - Federal","8181, 8182",null,0,{"$f":"SUM(G30)","v":0}]
[null,null,null,"Child Nutrition - Federal",8220,null,0,{"$f":"SUM(G31)","v":0}]
[null,null,null,"Donated Food Commodities",8221,null,0,{"$f":"SUM(G32)","v":0}]
[null,null,null,"Other Federal Revenues ","8110, 8260-8299",0,25083.24,{"$f":"SUM(F33:G33)","v":25083.24}]
[null,null,null,"          Total, Federal Revenues "," ",{"$f":"SUM(F33)","v":0},{"$f":"SUM(G29:G33)","v":70813.5},{"$f":"SUM(F34:G34)","v":70813.5}]
[null,null,null,null," "]
[null,"3.","Other State Revenues",null," "]
[null,null,null,"Charter Schools Categorical Block Grant ",8480,null,null,{"$f":"SUM(F37)","v":0}]
[null,null,null,"Special Education - State","StateRevSE",null,0,{"$f":"SUM(G38)","v":0}]
[null,null,null,"All Other State Revenues","StateRevAO",20460.650000000001,108587.95,{"$f":"SUM(F39:G39)","v":129048.6}]
[null,null,null,"         Total, Other State Revenues"," ",{"$f":"SUM(F37,F39)","v":20460.650000000001},{"$f":"SUM(G38,G39)","v":108587.95},{"$f":"SUM(F40:G40)","v":129048.6}]
[null,null,null,null," "]
[null,"4.","Other Local Revenues",null," "]
[null,null,null,"All Other Local Revenues","LocalRevAO",29248.48,0,{"$f":"SUM(F43:G43)","v":29248.48}]
[null,null,null,"          Total, Local Revenues"," ",{"$f":"SUM(F43)","v":29248.48},{"$f":"SUM(G43)","v":0},{"$f":"SUM(F44:G44)","v":29248.48}]
[null,null," "," "," "]
[null,"5.","TOTAL REVENUES",null," ",{"$f":"SUM(F26,F34,F40,F44)","v":920048.13},{"$f":"SUM(G26,G34,G40,G44)","v":179401.45},{"$f":"SUM(F46:G46)","v":1099449.58}]
[null,null,null,null," "]
["B.","EXPENDITURES (see NOTE in Section L)",null,null," "]
[null,"1.","Certificated Salaries",null," "]
[null,null,null,"Certificated Teachers' Salaries",1100,174278.91,31415.65,{"$f":"SUM(F50:G50)","v":205694.56}]
[null,null,null,"Certificated Pupil Support Salaries",1200,0,0,{"$f":"SUM(F51:G51)","v":0}]
[null,null,null,"Certificated Supervisors' and Administrators' Salaries",1300,67499.91,100,{"$f":"SUM(F52:G52)","v":67599.91}]
[null,null,null,"Other Certificated Salaries",1900,0,0,{"$f":"SUM(F53:G53)","v":0}]
[null,null,null,"          Total, Certificated Salaries"," ",{"$f":"SUM(F50:F53)","v":241778.82},{"$f":"SUM(G50:G53)","v":31515.65},{"$f":"SUM(F54:G54)","v":273294.46999999997}]
[null,null,null,null," "]
[null,"2.","Noncertificated Salaries",null," "]
[null,null,null,"Noncertificated Instructional Salaries",2100,135532.89000000001,5183.88,{"$f":"SUM(F57:G57)","v":140716.76999999999}]
[null,null,null,"Noncertificated Support Salaries",2200,0,36305.910000000003,36305.910000000003]
[]
[null,null,null,"Noncertificated Supervisors' and Administrators' Salaries",2300,0,0,{"$f":"SUM(F60:G60)","v":0}]
[null,null,null,"Clerical, Technical and Office Salaries",2400,30088.15,0,30088.15]
[null,null,null,"Other Noncertificated Salaries",2900,0,0,0]
[null,null,null,"          Total, Noncertificated Salaries"," ",{"$f":"SUM(F57:F62)","v":165621.04},{"$f":"SUM(G57:G62)","v":41489.79},207110.83]
[null,null,null,"              Description","Object Code","Unrestricted","Restricted","Total"]
[null,"3.","Employee Benefits",null," "]
[null,null,null,"STRS","3101-3102",42891.44,182.91,{"$f":"SUM(F66:G66)","v":43074.35}]
[null,null,null,"PERS","3201-3202",0,0,{"$f":"SUM(F67:G67)","v":0}]
[null,null,null,"OASDI / Medicare / Alternative","3301-3302",14285.32,5204.3599999999997,19489.68]
[null,null,null,"Health and Welfare Benefits","3401-3402",50658.89,-47.49,50611.4]
[null,null,null,"Unemployment Insurance","3501-3502",2652.24,224.21,2876.45]
[null,null,null,"Workers' Compensation Insurance","3601-3602",9405.36,0,9405.36]
[null,null,null,"OPEB, Allocated","3701-3702",0,0,0]
[null,null,null,"OPEB, Active Employees","3751-3752",0,0,{"$f":"SUM(F73:G73)","v":0}]
[null,null,null,"Other Employee Benefits","3901-3902",0,0,0]
[null,null,null,"          Total, Employee Benefits"," ",{"$f":"SUM(F66:F74)","v":119893.25},{"$f":"SUM(G66:G74)","v":5563.99},{"$f":"SUM(F75:G75)","v":125457.24}]
[null,null,null,null," "]
[null,"4.","Books and Supplies",null," "]
[null,null,null,"Approved Textbooks and Core Curricula Materials",4100,0,11220.9,{"$f":"SUM(F78:G78)","v":11220.9}]
[null,null,null,"Books and Other Reference Materials",4200,0,99.87,99.87]
[null,null,null,"Materials and Supplies",4300,5928.48,16695.189999999999,22623.67]
[null,null,null,"Noncapitalized Equipment",4400,3343.28,5514.89,8858.17]
[null,null,null,"Food",4700,1357.49,4001.61,5359.1]
[null,null,null,"          Total, Books and Supplies"," ",{"$f":"SUM(F78:F82)","v":10629.25},{"$f":"SUM(G78:G82)","v":37532.46},48161.71]
[null,null,null,null," "]
[null,"5.","Services and Other Operating Expenditures",null," "]
[null,null,null,"Subagreements for Services",5100,0,0,{"$f":"SUM(F86:G86)","v":0}]
[null,null,null,"Travel and Conferences",5200,-70,9111.6299999999992,{"$f":"SUM(F87:G87)","v":9041.6299999999992}]
[null,null,null,"Dues and Memberships",5300,7971.19,455.8,{"$f":"SUM(F88:G88)","v":8426.99}]
[null,null,null,"Insurance",5400,23422.639999999999,0,23422.639999999999]
[null,null,null,"Operations and Housekeeping Services",5500,1441.28,20852.84,22294.12]
[null,null,null,"Rentals, Leases, Repairs, and Noncap. Improvements",5600,18615.79,35780.32,54396.11]
[null,null,null,"Transfers of Direct Costs","5700-5799",0,0,0]
[null,null,null,"Professional/Consulting Services and Operating Expend.",5800,86319.86,6090.25,92410.11]
[null,null,null,"Communications",5900,5492.49,4.1500000000000004,5496.64]
[null,null,null,"          Total, Services and Other Operating Expenditures"," ",{"$f":"SUM(F86:F94)","v":143193.25},{"$f":"SUM(G86:G94)","v":72294.990000000005},215488.24]
[null,null," ","          "," "]
[null,"6.","Capital Outlay",null," "]
[null,null,null,"(Objects 6100-6170, 6200-6500 modified accrual basis only) "]
[null,null,null,"Land and Land Improvements ","6100-6170",null,null,{"$f":"SUM(F99:G99)","v":0}]
[null,null,null,"Buildings and Improvements of Buildings",6200,null,null,{"$f":"SUM(F100:G100)","v":0}]
[null,null,null,"Books and Media for New School Libraries or Major"," "]
[null,null,null,"     Expansion of School Libraries ",6300,null,null,{"$f":"SUM(F102:G102)","v":0}]
[null,null,null,"Equipment ",6400,null,null,0]
[null,null,null,"Equipment Replacement ",6500,null,null,0]
[null,null,null,"Lease Assets",6600,null,null,0]
[null,null,null,"Depreciation Expense (accrual basis only)",6900,null,null,0]
[null,null,null,"Amortization Expense - Lease Assets",6910,null,null,{"$f":"SUM(F107:G107)","v":0}]
[null,null," ","          Total, Capital Outlay"," ",{"$f":"SUM(F99,F100,F102,F103,F104,F105,F106,F107)","v":0},{"$f":"SUM(G99,G100,G102,G103,G104,G105,G106,G107)","v":0},0]
[null,null,null,null," "]
[null,"7.","Other Outgo ",null," "]
[null," ",null,"Tuition to Other Schools","7110-7143",null,null,{"$f":"SUM(F111:G111)","v":0}]
[null,null,null,"Transfers of Pass-Through Revenues to Other LEAs","7211-7213",null,null,0]
[null,null,null,"Transfers of Apportionments to Other LEAs - Spec. Ed.","7221-7223SE",null,109630.32,109630.32]
[null,null,null,"Transfers of Apportionments to Other LEAs - All Other","7221-7223AO",null,null,0]
[null,null,null,"All Other Transfers","7281-7299",null,null,0]
[null,null,null,"Transfers of Indirect Costs","7300-7399",null,null,0]
[null,null,null,"Debt Service:"," "]
[null,null,null,"     Interest ",7438,null,null,{"$f":"SUM(F118:G118)","v":0}]
[null,null,null,"     Principal (for modified accrual basis only)",7439,null,null,{"$f":"SUM(F119:G119)","v":0}]
[null,null,null,"           Total Debt Service",null,{"$f":"SUM(F118:F119)","v":0},{"$f":"SUM(G118:G119)","v":0},{"$f":"SUM(F120:G120)","v":0}]
[null,null,null,"Total, Other Outgo"," ",{"$f":"SUM(F111,F112,F113,F114,F115,F116,F118,F119)","v":0},{"$f":"SUM(G111,G112,G113,G114,G115,G116,G118,G119)","v":109630.32},{"$f":"SUM(F121:G121)","v":109630.32}]
[null,null,null,null," "]
[null,"8.","TOTAL EXPENDITURES",null," ",{"$f":"SUM(F54,F63,F75,F83,F95,F108,F121)","v":681115.61},{"$f":"SUM(G54,G63,G75,G83,G95,G108,G121)","v":298027.2},{"$f":"SUM(F123:G123)","v":979142.81},null," "]
[null,null,null,"              Description","Object Code","Unrestricted","Restricted","Total"]
["C.","EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES",null,null," "]
[null,"BEFORE OTHER FINANCING SOURCES AND USES (A5-B8)",null,null," ",{"$f":"SUM(F46-F123)","v":238932.52},{"$f":"SUM(G46-G123)","v":-118625.75},{"$f":"SUM(F126:G126)","v":120306.77}]
[]
["D.","OTHER FINANCING SOURCES / USES"]
[null,"1.","Other Sources",null,"8930-8979",null,null,{"$f":"SUM(F129:G129)","v":0}]
[null,"2.","Less:  Other Uses",null,"7630-7699",null,null,{"$f":"SUM(F130:G130)","v":0}]
[null,"3.","Contributions Between Unrestricted and Restricted Accounts",null,null,null,null,{"$f":"IF(H132=0,\"\",\"(must be zero)\")","v":""}]
[null,null,"(must net to zero)",null,"8980-8999",-118625.75,118625.75,{"$f":"SUM(F132:G132)","v":0}]
[null," ",null,null," "]
[null,"4.","TOTAL OTHER FINANCING SOURCES / USES",null," ",{"$f":"SUM(+F129-F130+F132)","v":-118625.75},{"$f":"SUM(+G129-G130+G132)","v":118625.75},{"$f":"SUM(F134:G134)","v":0}]
[null,null,null,null," "]
["E.","NET INCREASE (DECREASE) IN FUND BALANCE /NET POSITION (C+D4)",null,null,null,{"$f":"SUM(F126,F134)","v":120306.77},{"$f":"SUM(G126,G134)","v":0},{"$f":"SUM(H126,H134)","v":120306.77}]
[null," ",null,null," "]
["F.","FUND BALANCE / NET POSITION",null,null," "]
[null,"1.","Beginning Fund Balance/Net Position"]
[null,null,"a.","As of July 1",9791,1252508.98,0,{"$f":"SUM(F140:G140)","v":1252508.98}]
[" ",null,"b.","Adjustments/Restatements","9793, 9795",null," ",{"$f":"SUM(F141:G141)","v":0}]
[null,null,"c.","Adjusted Beginning Fund Balance /Net Position"," ",{"$f":"SUM(F140,F141)","v":1252508.98},{"$f":"SUM(G140,G141)","v":0},{"$f":"SUM(F142:G142)","v":1252508.98}]
[null,"2.","Ending Fund Balance /Net Position, June 30 (E+F1c)",null," ",{"$f":"SUM(F136,F142)","v":1372815.75},{"$f":"SUM(G136,G142)","v":0},{"$f":"SUM(F143:G143)","v":1372815.75}]
[null,null,"Components of Ending Fund Balance (Modified Accrual Basis only)"]
[null,null,"a.","Nonspendable"]
[null,null,null,"1.  Revolving Cash (equals Object 9130)",9711,null,null,{"$f":"SUM(F146:G146)","v":0}]
[null,null,null,"2.  Stores (equals Object 9320)        ",9712,null,null,0]
[null,null,null,"3.  Prepaid Expenditures (equals Object 9330)",9713,null,null,0]
[null,null,null,"4.  All Others",9719,null,null,0]
[null,null,"b.","Restricted",9740," ",null,0]
[null,null,"c. Committed","Committed"]
[null,null,null,"1.  Stabilization Arrangements",9750,null," ",0]
[null,null,null,"2.  Other Commitments",9760,null,null,0]
[null,null,"d.","Assigned",9780,null,null,0]
[null,null,"e. ","Unassigned/Unappropriated"]
[null,null,null,"1.  Reserve for Economic Uncertainties",9789,null,null,0]
[null,null,null,"2.  Unassigned/Unappropriated Amount","9790M",null,null,0]
[]
[null,"3.","Components of Ending Net Position (Accrual Basis only)",null,null,{"$f":"IF(AND(SUM(F177)>0,LEN(TRIM(F2F1Unrestricted)) = 0),\"Enter amount for F.3.a\",\"\" )","v":""},{"$f":"IF(AND(SUM(G177)>0,LEN(TRIM(F2F1Restricted)) = 0),\"Enter amount for F.3.a\",\"\" )","v":""}]
[null,null,null,"a.  Net Investment in Capital Assets",9796,0,null,0,null,null," "," "]
[null,null,null,"b.  Restricted Net Position",9797,null,null,0]
[null,null,null,null,null,null,{"$f":"IF(F2F3RestrictedSum=0,\"\",IF(F2F3RestrictedSum<0,\"\",\"(must be zero or negative)\"))","v":""}]
[null,null,null,"c.  Unrestricted Net Position","9790A",{"$f":"F2Unrestricted-F2F1Unrestricted","v":1372815.75},{"$f":"F2Restricted - SUM(F2FRestricted)","v":0},1372815.75]
[null,null,null,"              Description","Object Code","Unrestricted","Restricted","Total"]
["G.","ASSETS",null,null," "]
[null,"1.","Cash",null," "]
[null,null,null,"In County Treasury",9110,1307049.72,null,{"$f":"SUM(F167:G167)","v":1307049.72}]
[null,null,null,"Fair Value Adjustment to Cash in County Treasury",9111,null,null,{"$f":"SUM(F168:G168)","v":0}]
[null,null,null,"In Banks",9120,283785.61,null,283785.61]
[null,null,null,"In Revolving Fund ",9130,null,null,0]
[null,null,null,"With Fiscal Agent/Trustee",9135,null,null,0]
[null,null,null,"Collections Awaiting Deposit",9140,null,null,0]
[null,"2.","Investments",null,9150,null,null,0]
[null,"3.","Accounts Receivable",null,9200,283.69,null,283.69]
[null,"4.","Due from Grantor Governments",null,9290,29858.65,null,29858.65]
[null,"5.","Stores",null,9320,null,null,0]
[null,"6.","Prepaid Expenditures (Expenses)",null,9330,8436.32,null,8436.32]
[null,"7.","Other Current Assets",null,9340,null,null,0]
[null,"8.","Lease Receivable",null,9380,null,null,0]
[null,"9.","Capital Assets (accrual basis only)",null,"9400-9489",5400,null,5400]
[null,null,null,null," "," "]
[null,"10.","TOTAL ASSETS",null," ",{"$f":"SUM(F167:F181)","v":1634813.99},{"$f":"SUM(G167:G180)","v":0},{"$f":"SUM(F182:G182)","v":1634813.99}]
[]
["H.","DEFERRED OUTFLOWS OF RESOURCES"]
[null,"1.","Deferred Outflows of Resources",null,9490,null,null,{"$f":"SUM(F185:G185)","v":0}]
[]
[null,"2.","TOTAL DEFERRED OUTFLOWS",null,null,{"$f":"SUM(F185)","v":0},{"$f":"SUM(G185)","v":0},{"$f":"SUM(F187:G187)","v":0}]
[]
["I.","LIABILITIES",null,null," "]
[null,"1.","Accounts Payable",null,9500,14467.53,null,{"$f":"SUM(F190:G190)","v":14467.53}]
[null,"2.","Due to Grantor Governments",null,9590,172849.62,null,{"$f":"SUM(F191:G191)","v":172849.62}]
[null,"3.","Current Loans",null,9640,null,null,{"$f":"SUM(F192:G192)","v":0}]
[null,"4.","Unearned Revenue",null,9650,74680.820000000007,null,{"$f":"SUM(F193:G193)","v":74680.820000000007}]
[null,"5.","Long-Term Liabilities (accrual basis only)",null,"9660-9669",null,null,{"$f":"SUM(F194:G194)","v":0}]
[null,null,null,null," "]
[null,"6.","TOTAL LIABILITIES",null," ",{"$f":"SUM(F190:F194)","v":261997.97},{"$f":"SUM(G190:G194)","v":0},{"$f":"SUM(F196:G196)","v":261997.97}]
[]
["J.","DEFERRED INFLOWS OF RESOURCES"]
[null,"1.","Deferred Inflows of Resources",null,9690,null,null,{"$f":"SUM(F199:G199)","v":0}]
[]
[null,"2.","TOTAL DEFERRED INFLOWS",null,null,{"$f":"SUM(F199)","v":0},{"$f":"SUM(G199)","v":0},{"$f":"SUM(F201:G201)","v":0}]
[null,null,null,null," ",null,null,null,null,null,{"$f":"ROUND(SUM(F205-F143),0)","v":0},{"$f":"ROUND(SUM(G205-G143),0)","v":0}," "]
["K.","FUND BALANCE /NET POSITION",null,null," ",null,null,null,null,null,{"$f":"IF(ABS(K202)<10.01,0,K202)","v":0},{"$f":"IF(ABS(L202)<10.01,0,L202)","v":0}]
[null,null,"Ending Fund Balance /Net Position, June 30 (G10 + H2) - (I6 + J2)",null,null,{"$f":"IF(K203=0,\"\",\"(must = Line F2)\")","v":""},{"$f":"IF(L203=0,\"\",\"(must = Line F2)\")","v":""}]
[null,null,"(must agree with Line F2)",null," ",{"$f":"SUM((F182+F187) - (F196+F201))","v":1372816.02},{"$f":"SUM((G182+G187) - (G196+G201))","v":0},{"$f":"SUM((H182+H187) - (H196+H201))","v":1372816.02}]
[]
["L. FEDERAL EVERY STUDENT SUCCEEDS ACT (ESSA) MAINTENANCE OF EFFORT REQUIREMENT"]
[]
["NOTE:   IF YOUR CHARTER SCHOOL RECEIVED FEDERAL FUNDING, AS REPORTED IN SECTION A2,  THE FOLLOWING"]
[null,null,null,"ADDITIONAL INFORMATION MUST BE PROVIDED IN ORDER FOR THE CDE TO CALCULATE COMPLIANCE WITH"]
[null,null,null,"THE FEDERAL EVERY STUDENT SUCCEEDS ACT (ESSA) MAINTENANCE OF EFFORT REQUIREMENT:"]
[]
[null,"1.","Federal Revenue Used for Capital Outlay and Debt Service"]
[null," ","Included in the Capital Outlay and Debt Service expenditures reported in sections B6 and B7 are "]
[null,null,"the following amounts paid out of federal funds: "]
[]
[null,null,null,"                         Federal Program Name (If no amounts, indicate \"NONE\")                                 ",null,"   Capital Outlay   ","   Debt Service   ","          Total          "]
[]
[null,null,"a.","None","$",0,0,{"$f":"SUM(F219,G219)","v":0}]
[null,null,"b.",null,null,null,null,{"$f":"SUM(F220,G220)","v":0}]
[null,null,"c.",null,null,null,null,{"$f":"SUM(F221,G221)","v":0}]
[null,null,"d.",null,null,null,null,0]
[null,null,"e.",null,null,null,null,0]
[null,null,"f.",null,null,null,null,0]
[null,null,"g.",null,null,null,null,0]
[null,null,"h.",null,null,null,null,0]
[null,null,"i.",null,null,null,null,0]
[null,null,"j.",null,null,null,null,{"$f":"SUM(F228,G228)","v":0}]
[]
[null,null,null,"TOTAL FEDERAL REVENUES USED FOR CAPITAL OUTLAY AND DEBT SERVICE",null,{"$f":"SUM(F219:F228)","v":0},{"$f":"SUM(G219:G228)","v":0},{"$f":"SUM(F230:G230)","v":0}]
[]
[]
[null,"2.","Community Services Expenditures"]
[null," ","Provide the amount of State and Local funds reported in Section B that were expended for Community Services Activities:"]
[]
[null,null,null,null,null,null,"Amount"]
[null,null,null,"Objects of Expenditures    ",null,null,"      (Enter \"0.00\" if none)      "]
[]
[null,null,"a.","Certificated Salaries","1000-1999",null,0]
[null,null,"b.","Noncertificated Salaries","2000-2999",null,0]
[null,null,"c.","Employee Benefits                                    "," 3000-3999\nexcept 3801-38002",null,0]
[null,null,"d.","Books and Supplies","4000-4999",null,0]
[null,null,"e.","Services and Other Operating Expenditures","5000-5999",null,0]
[]
["New 02/26/04"]
[null,null,null,"TOTAL COMMUNITY SERVICES EXPENDITURES",null,null,{"$f":"SUM(G239:G243)","v":0}]
[]
[null,"3. Supplemental State and Local Expenditures resulting from a Presidentially Declared Disaster"]
[null,null,null,null,null,null,"Amount"]
[null,null,null,"Brief Description i.e., COVID-19 (If no amounts, indicate “None”)"," "]
[]
[null,null,"a.",null," "]
[null,null,"b.",null," "]
[null,null,"c.",null," "]
[null,null,"d.",null," "]
[null,null,null,null," "]
[null,null,null,"TOTAL SUPPLEMENTAL EXPENDITURES (Should not be negative)",null,null,{"$f":"SUM(G252:G255)","v":0}]
[]
[null,"4.","State and Local Expenditures to be Used for ESSA Annual Maintenance of Effort Calculation:"]
[null,null,"Results of this calculation will be used for comparison with 2020-21 expenditures. Failure to maintain the required"]
[null,null,"90 percent expenditure level on either an aggregate or per capita expenditure basis may result in reduction to"]
[null,null,"allocations for covered programs in 2023-24."]
[]
[null,null,"a.","Total Expenditures (B8)",null,null,{"$f":"B8Total","v":979142.81}]
[]
[null,null,"b.","Less Federal Expenditures (Total A2)"]
[null,null,null,"[Revenues are used as proxy for expenditures because most federal revenues",null,null,{"$f":"FederalRevenue","v":70813.5}]
[null,null,null,"are normally recognized in the period that qualifying expenditures are incurred]"]
[]
[null,null,"c.","Subtotal of State & Local Expenditures",null,null,{"$f":"SUM(J4ATotalExpenditures - J4BLessFederal)","v":908329.31}]
[null,null,null,"[a minus b]"]
[]
[null,null,"d.","Less Community Services",null,null,{"$f":"J2Total","v":0}]
[null,null,null,"[L2 Total]"]
[]
[null,null,"e.","Less Capital Outlay & Debt Service",null,null,{"$f":"SUM((B6Total+B7DebtServiceTotal)-SUM(SectionA2Total))-B6AmortizationTotal-B6LeaseAssetsTotal","v":0}]
[null,null,null,"[Total B6 plus objects 7438 and 7439, less L1 Total, less objects 6600 and 6910]"]
[]
[null,null,"f.","Less Supplemental State and Local Expenditures resulting from a Presidentially",null,null,{"$f":"J3Total","v":0}]
[null,null,null,"Declared Disaster"]
[]
[null,null,null,"TOTAL STATE & LOCAL EXPENDITURES SUBJECT TO MOE",null,"$",{"$f":"SUM(J4CTotal -J4DTotal-J4ETotal-J4FTotal)","v":908329.31}]
[null,null,null,"[c minus d minus e minus f]"]
[{"$f":"CELL(\"filename\")","v":"/Users/kimberlymorgan/Downloads/[23655650123737.xlsm]Alternative Form"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",2001.1]

{"sheet":"Data","index":2,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["12345678912345",20000,30000]
["12345678912345",256445,300]
["12345678912345",25488,1]
["12345678912345",2500,33665]

{"sheet":"MACROS","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Macros must be enabled to use this workbook."]
[null,"Please close the file and re-open it with macros enabled."]
[]
[null,"Instructions:"]
[null,"Go to your File tab – Options – Trust Center – Trust Center Settings –  Macro Settings – Enable all macros"]
[null," "]
[null," "]