{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Certification","Alternative Form","MACROS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":88,"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":[[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],[6,10,6,15],[7,10,7,15],[8,10,8,15],[9,10,9,15],[12,4,12,15],[11,4,11,15],[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]]}
["CHARTER SCHOOL UNAUDITED ACTUALS"]
["FINANCIAL REPORT -- ALTERNATIVE FORM"]
["July 1, 2015  to  June 30, 2016"]
[]
["CHARTER SCHOOL CERTIFICATION"]
[]
[null,null,null,null,null,null,null,null,null,"Charter School Name:","Academy of Arts and Sciences: Del Mar Elementary (K-5)"]
[null,null,null,null,null,null,null,null,null,"CDS #:",{"$f":"MID(CELL(\"filename\"),FIND(\"[\",CELL(\"filename\"))+1,FIND(\"]\",CELL(\"filename\"))-FIND(\"[\",CELL(\"filename\"))-1-5)","v":"37682130127068"}]
[null,null,null,null,null,null,null,null,null,"Charter Approving Entity:","Mountain Empire"]
[null,null,null,null,null,null,null,null,null,"County:","San Diego"]
[null,null,null,null,null,null,null,null,null,"Charter #:","1452"]
[]
[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,"Debbie McDonald",null,null,null,null,null,"J.J. Lewis"]
[null,null,null,null,"Name",null,null,null,"Name",null,null," ",null," ","Name"]
[null,null,null,null,null,null,null,null,"Director of Finance",null,null,null,null,null,"President and CEO"]
[null,null,null,null,"Title",null,null,null,"Title",null,null," ",null," ","Title"]
[null,null,null,null,null,null,null,null,"619-473-9022",null,null,null,null,null,"855-937-4227"]
[null,null,null,null,"Telephone",null,null,null,"Telephone",null,null," ",null," ","Telephone"]
[null,null,null,null,null,null,null,null,"debbie.mcdonald@meusd.k12.ca.us",null,null,null,null,null,"jj.lewis@aascalifornia.org"]
[null,null,null,null,"E-mail address",null,null,null,"E-mail address",null,null," ",null," ","E-mail address"]
[]
[null,null,null,null,"To the entity that approved the charter school:"]
["(","X",")",null,"2015-16 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:",null,null,null,null,null,null,"       Title:"]
[]
[null,null,null,null,"To the County Superintendent of Schools:"]
["(","X",")",null,"2015-16 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,"2015-16 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":268,"n_cols":16,"rows_kept":268,"cut":false,"hidden":false,"merged":[[141,2,141,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],[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]]}
["c1","c2","c3",4,"objcode","unrestr","restr","ttl"]
["CHARTER SCHOOL UNAUDITED ACTUALS"]
["FINANCIAL REPORT -- ALTERNATIVE FORM"]
["July 1, 2015 to  June 30, 2016"]
[]
["Charter School Name:",null,null,null,{"$f":"Certification!K7","v":"Academy of Arts and Sciences: Del Mar Elementary (K-5)"}]
["CDS #:",null,null,null,{"$f":"Certification!K8","v":"37682130127068"}]
["Charter Approving Entity:",null,null,null,{"$f":"Certification!K9","v":"Mountain Empire"}]
["County:",null,null,null,{"$f":"Certification!K10","v":"San Diego"}]
["Charter #:",null,null,null,{"$f":"Certification!K11","v":"1452"}]
[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, 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, 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,388876,null,{"$f":"SUM(F21)","v":388876}]
[null,null,null,"Education Protection Account State Aid - Current Year",8012,121590,null,121590]
[null,null,null,"State Aid - Prior Years",8019,-8104,null,-8104]
[null,null,null,"Transfers to Charter Schools in Lieu of Property Taxes",8096,185158,null,{"$f":"SUM(F24)","v":185158}]
[null,null,null,"Other LCFF Transfers","8091, 8097",null,null,{"$f":"SUM(F25:G25)","v":0}]
[null,null,null,"          Total, LCFF Sources"," ",{"$f":"SUM(F21:F25)","v":687520},{"$f":"SUM(G25)","v":0},{"$f":"SUM(F26:G26)","v":687520}]
[null,null,null,null," "]
[null,"2.","Federal Revenues (see NOTE in Section L)",null," "]
[null,null,null,"No Child Left Behind ",8290,null,null,{"$f":"SUM(G29)","v":0}]
[null,null,null,"Special Education - Federal","8181, 8182",null,null,{"$f":"SUM(G30)","v":0}]
[null,null,null,"Child Nutrition - Federal",8220,null,null,{"$f":"SUM(G31)","v":0}]
[null,null,null,"Donated Food Commodities",8221,null,null,{"$f":"SUM(G32)","v":0}]
[null,null,null,"Other Federal Revenues ","8110, 8260-8299",null,null,{"$f":"SUM(F33:G33)","v":0}]
[null,null,null,"          Total, Federal Revenues "," ",{"$f":"SUM(F33)","v":0},{"$f":"SUM(G29:G33)","v":0},{"$f":"SUM(F34:G34)","v":0}]
[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,{"$f":"-52159.66+44777.27","v":-7382.39},{"$f":"SUM(G38)","v":-7382.39}]
[null,null,null,"All Other State Revenues","StateRevAO",148049.32999999999,12453.92,{"$f":"SUM(F39:G39)","v":160503.25}]
[null,null,null,"         Total, Other State Revenues"," ",{"$f":"SUM(F37,F39)","v":148049.32999999999},{"$f":"SUM(G38,G39)","v":5071.53},{"$f":"SUM(F40:G40)","v":153120.85999999999}]
[null,null,null,null," "]
[null,"4.","Other Local Revenues",null," "]
[null,null,null,"All Other Local Revenues","LocalRevAO",2351.25,null,{"$f":"SUM(F43:G43)","v":2351.25}]
[null,null,null,"          Total, Local Revenues"," ",{"$f":"SUM(F43)","v":2351.25},{"$f":"SUM(G43)","v":0},{"$f":"SUM(F44:G44)","v":2351.25}]
[null,null," "," "," "]
[null,"5.","TOTAL REVENUES",null," ",{"$f":"SUM(F26,F34,F40,F44)","v":837920.58},{"$f":"SUM(G26,G34,G40,G44)","v":5071.53},{"$f":"SUM(F46:G46)","v":842992.11}]
[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,104351.99,null,{"$f":"SUM(F50:G50)","v":104351.99}]
[null,null,null,"Certificated Pupil Support Salaries",1200,null,null,{"$f":"SUM(F51:G51)","v":0}]
[null,null,null,"Certificated Supervisors' and Administrators' Salaries",1300,11894.49,null,{"$f":"SUM(F52:G52)","v":11894.49}]
[null,null,null,"Other Certificated Salaries",1900,null,3026.58,{"$f":"SUM(F53:G53)","v":3026.58}]
[null,null,null,"          Total, Certificated Salaries"," ",{"$f":"SUM(F50:F53)","v":116246.48},{"$f":"SUM(G50:G53)","v":3026.58},{"$f":"SUM(F54:G54)","v":119273.06}]
[null,null,null,null," "]
[null,"2.","Noncertificated Salaries",null," "]
[null,null,null,"Noncertificated Instructional Salaries",2100,null,null,{"$f":"SUM(F57:G57)","v":0}]
[null,null,null,"Noncertificated Support Salaries",2200,null,null,0]
[]
[null,null,null,"Noncertificated Supervisors' and Administrators' Salaries",2300,6394.59,null,6394.59]
[null,null,null,"Clerical and Office Salaries",2400,17272.3,null,17272.3]
[null,null,null,"Other Noncertificated Salaries",2900,null,null,0]
[null,null,null,"          Total, Noncertificated Salaries"," ",{"$f":"SUM(F57:F62)","v":23666.89},{"$f":"SUM(G57:G62)","v":0},23666.89]
[null,null,null,"              Description","Object Code","Unrestricted","Restricted","Total"]
[null,"3.","Employee Benefits",null," "]
[null,null,null,"STRS","3101-3102",10068.49,210.63,{"$f":"SUM(F66:G66)","v":10279.120000000001}]
[null,null,null,"PERS","3201-3202",null,null,{"$f":"SUM(F67:G67)","v":0}]
[null,null,null,"OASDI / Medicare / Alternative","3301-3302",3749.98,null,3749.98]
[null,null,null,"Health and Welfare Benefits","3401-3402",16348.51,-9.58,16338.93]
[null,null,null,"Unemployment Insurance","3501-3502",2812.56,null,2812.56]
[null,null,null,"Workers' Compensation Insurance","3601-3602",2500.3200000000002,null,2500.3200000000002]
[null,null,null,"OPEB, Allocated","3701-3702",null,null,0]
[null,null,null,"OPEB, Active Employees","3751-3752",null,null,{"$f":"SUM(F73:G73)","v":0}]
[null,null,null,"Other Employee Benefits","3901-3902",-28.1,null,-28.1]
[null,null,null,"          Total, Employee Benefits"," ",{"$f":"SUM(F66:F74)","v":35451.760000000002},{"$f":"SUM(G66:G74)","v":201.05},{"$f":"SUM(F75:G75)","v":35652.81}]
[null,null,null,null," "]
[null,"4.","Books and Supplies",null," "]
[null,null,null,"Approved Textbooks and Core Curricula Materials",4100,70135.259999999995,148.56,{"$f":"SUM(F78:G78)","v":70283.820000000007}]
[null,null,null,"Books and Other Reference Materials",4200,37651.120000000003,null,37651.120000000003]
[null,null,null,"Materials and Supplies",4300,306.52999999999997,null,306.52999999999997]
[null,null,null,"Noncapitalized Equipment",4400,4570.3999999999996,null,4570.3999999999996]
[null,null,null,"Food",4700,null,null,0]
[null,null,null,"          Total, Books and Supplies"," ",{"$f":"SUM(F78:F82)","v":112663.31},{"$f":"SUM(G78:G82)","v":148.56},112811.87]
[null,null,null,null," "]
[null,"5.","Services and Other Operating Expenditures",null," "]
[null,null,null,"Subagreements for Services",5100,null,null,{"$f":"SUM(F86:G86)","v":0}]
[null,null,null,"Travel and Conferences",5200,695.09,null,{"$f":"SUM(F87:G87)","v":695.09}]
[null,null,null,"Dues and Memberships",5300,163.80000000000001,null,{"$f":"SUM(F88:G88)","v":163.80000000000001}]
[null,null,null,"Insurance",5400,1389.82,null,1389.82]
[null,null,null,"Operations and Housekeeping Services",5500,734.5,null,734.5]
[null,null,null,"Rentals, Leases, Repairs, and Noncap. Improvements",5600,14421.3,null,14421.3]
[null,null,null,"Transfers of Direct Costs","5700-5799",null,null,0]
[null,null,null,"Professional/Consulting Services and Operating Expend.",5800,94028.800000000003,1695.34,95724.14]
[null,null,null,"Communications",5900,1344.69,null,1344.69]
[null,null,null,"          Total, Services and Other Operating Expenditures"," ",{"$f":"SUM(F86:F94)","v":112778},{"$f":"SUM(G86:G94)","v":1695.34},114473.34]
[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,"Depreciation Expense (accrual basis only)",6900,null,null,0]
[null,null," ","          Total, Capital Outlay"," ",{"$f":"SUM(F99,F100,F102,F103,F104,F105)","v":0},{"$f":"SUM(G99,G100,G102,G103,G104,G105)","v":0},0]
[null,null,null,null," "]
[null,"7.","Other Outgo ",null," "]
[null," ",null,"Tuition to Other Schools","7110-7143",null,null,{"$f":"SUM(F109:G109)","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,null,0]
[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,675.74,null,{"$f":"SUM(F116:G116)","v":675.74}]
[null,null,null,"     Principal (for modified accrual basis only)",7439,null,null,{"$f":"SUM(F117:G117)","v":0}]
[null,null,null,"           Total Debt Service",null,{"$f":"SUM(F116:F117)","v":675.74},{"$f":"SUM(G116:G117)","v":0},{"$f":"SUM(F118:G118)","v":675.74}]
[null,null,null,"Total, Other Outgo"," ",{"$f":"SUM(F109,F110,F111,F112,F113,F114,F116,F117)","v":675.74},{"$f":"SUM(G109,G110,G111,G112,G113,G114,G116,G117)","v":0},{"$f":"SUM(F119:G119)","v":675.74}]
[null,null,null,null," "]
[null,"8.","TOTAL EXPENDITURES",null," ",{"$f":"SUM(F54,F63,F75,F83,F95,F106,F119)","v":401482.18},{"$f":"SUM(G54,G63,G75,G83,G95,G106,G119)","v":5071.53},{"$f":"SUM(F121:G121)","v":406553.71},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-F121)","v":436438.4},{"$f":"SUM(G46-G121)","v":0},{"$f":"SUM(F124:G124)","v":436438.4}]
[]
["D.","OTHER FINANCING SOURCES / USES"]
[null,"1.","Other Sources",null,"8930-8979",null,null,{"$f":"SUM(F127:G127)","v":0}]
[null,"2.","Less:  Other Uses",null,"7630-7699",null,null,{"$f":"SUM(F128:G128)","v":0}]
[null,"3.","Contributions Between Unrestricted and Restricted Accounts",null,null,null,null,{"$f":"IF(H130=0,\"\",\"(must be zero)\")","v":""}]
[null,null,"(must net to zero)",null,"8980-8999",null,null,{"$f":"SUM(F130:G130)","v":0}]
[null," ",null,null," "]
[null,"4.","TOTAL OTHER FINANCING SOURCES / USES",null," ",{"$f":"SUM(+F127-F128+F130)","v":0},{"$f":"SUM(+G127-G128+G130)","v":0},{"$f":"SUM(F132:G132)","v":0}]
[null,null,null,null," "]
["E.","NET INCREASE (DECREASE) IN FUND BALANCE /NET POSITION (C+D4)",null,null,null,{"$f":"SUM(F124,F132)","v":436438.4},{"$f":"SUM(G124,G132)","v":0},{"$f":"SUM(H124,H132)","v":436438.4}]
[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,734468,null,{"$f":"SUM(F138:G138)","v":734468}]
[" ",null,"b.","Adjustments/Restatements","9793, 9795",10143,null,{"$f":"SUM(F139:G139)","v":10143}]
[null,null,"c.","Adjusted Beginning Fund Balance /Net Position"," ",{"$f":"SUM(F138,F139)","v":744611},{"$f":"SUM(G138,G139)","v":0},{"$f":"SUM(F140:G140)","v":744611}]
[null,"2.","Ending Fund Balance /Net Position, June 30 (E+F1c)",null," ",{"$f":"SUM(F134,F140)","v":1181049.3999999999},{"$f":"SUM(G134,G140)","v":0},{"$f":"SUM(F141:G141)","v":1181049.3999999999}]
[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(F144:G144)","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,0]
[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,null,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":1181049.3999999999},{"$f":"F2Restricted - SUM(F2FRestricted)","v":0},1181049.3999999999]
[null,null,null,"              Description","Object Code","Unrestricted","Restricted","Total"]
["G.","ASSETS",null,null," "]
[null,"1.","Cash",null," "]
[null,null,null,"In County Treasury",9110,30758.28,null,{"$f":"SUM(F165:G165)","v":30758.28}]
[null,null,null,"Fair Value Adjustment to Cash in County Treasury",9111,null,null,{"$f":"SUM(F166:G166)","v":0}]
[null,null,null,"In Banks",9120,{"$f":"1299381.34-52159.66","v":1247221.68},52159.66,1299381.3400000001]
[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,32432.28,null,32432.28]
[null,"4.","Due from Grantor Governments",null,9290,null,null,0]
[null,"5.","Stores",null,9320,null,null,0]
[null,"6.","Prepaid Expenditures (Expenses)",null,9330,null,null,0]
[null,"7.","Other Current Assets",null,9340,null,null,0]
[null,"8.","Capital Assets (accrual basis only)",null,"9400-9489",null,null,0]
[null,null,null,null," "," "]
[null,"9.","TOTAL ASSETS",null," ",{"$f":"SUM(F165:F178)","v":1310412.24},{"$f":"SUM(G165:G177)","v":52159.66},{"$f":"SUM(F179:G179)","v":1362571.9}]
[]
["H.","DEFERRED OUTFLOWS OF RESOURCES"]
[null,"1.","Deferred Outflows of Resources",null,9490,null,null,{"$f":"SUM(F182:G182)","v":0}]
[]
[null,"2.","TOTAL DEFERRED OUTFLOWS",null,null,{"$f":"SUM(F182)","v":0},{"$f":"SUM(G182)","v":0},{"$f":"SUM(F184:G184)","v":0}]
[]
["I.","LIABILITIES",null,null," "]
[null,"1.","Accounts Payable",null,9500,null,null,{"$f":"SUM(F187:G187)","v":0}]
[null,"2.","Due to Grantor Governments",null,9590,129362.84,null,{"$f":"SUM(F188:G188)","v":129362.84}]
[null,"3.","Current Loans",null,9640,null,null,{"$f":"SUM(F189:G189)","v":0}]
[null,"4.","Unearned Revenue",null,9650,null,52159.66,{"$f":"SUM(F190:G190)","v":52159.66}]
[null,"5.","Long-Term Liabilities (accrual basis only)",null,"9660-9669",null,null,{"$f":"SUM(F191:G191)","v":0}]
[null,null,null,null," "]
[null,"6.","TOTAL LIABILITIES",null," ",{"$f":"SUM(F187:F191)","v":129362.84},{"$f":"SUM(G187:G191)","v":52159.66},{"$f":"SUM(F193:G193)","v":181522.5}]
[]
["J.","DEFERRED INFLOWS OF RESOURCES"]
[null,"1.","Deferred Inflows of Resources",null,9690,null,null,{"$f":"SUM(F196:G196)","v":0}]
[]
[null,"2.","TOTAL DEFERRED INFLOWS",null,null,{"$f":"SUM(F196)","v":0},{"$f":"SUM(G196)","v":0},{"$f":"SUM(F198:G198)","v":0}]
[null,null,null,null," ",null,null,null,null,null,{"$f":"ROUND(SUM(F202-F141),0)","v":0},{"$f":"ROUND(SUM(G202-G141),0)","v":0}," "]
["K.","FUND BALANCE /NET POSITION",null,null," ",null,null,null,null,null,{"$f":"IF(ABS(K199)<10.01,0,K199)","v":0},{"$f":"IF(ABS(L199)<10.01,0,L199)","v":0}]
[null,null,"Ending Fund Balance /Net Position, June 30 (G9 + H2) - (I6 + J2)",null,null,{"$f":"IF(K200=0,\"\",\"(must = Line F2)\")","v":""},{"$f":"IF(L200=0,\"\",\"(must = Line F2)\")","v":""}]
[null,null,"(must agree with Line F2)",null," ",{"$f":"SUM((F179+F184) - (F193+F198))","v":1181049.3999999999},{"$f":"SUM((G179+G184) - (G193+G198))","v":0},{"$f":"SUM((H179+H184) - (H193+H198))","v":1181049.3999999999}]
[]
["L. FEDERAL NO CHILD LEFT BEHIND (NCLB) 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 NO CHILD LEFT BEHIND (NCLB) 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","$",null,null,{"$f":"SUM(F216,G216)","v":0}]
[null,null,"b.",null,null,null,null,{"$f":"SUM(F217,G217)","v":0}]
[null,null,"c.",null,null,null,null,{"$f":"SUM(F218,G218)","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(F225,G225)","v":0}]
[]
[null,null,null,"TOTAL FEDERAL REVENUES USED FOR CAPITAL OUTLAY AND DEBT SERVICE",null,{"$f":"SUM(F216:F225)","v":0},{"$f":"SUM(G216:G225)","v":0},{"$f":"SUM(F227:G227)","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(G236:G240)","v":0}]
[]
[]
[null,"3.","State and Local Expenditures to be Used for Annual NCLB Maintenance of Effort Calculation:"]
[null,null,"Results of this calculation will be used for comparison with 2014-15 expenditures. Failure to maintain the required"]
[null,null,"90 percent expenditure level on either an aggregate or per capita expenditure basis will result in reduction to"]
[null,null,"allocations for covered programs in 2017-18."]
[]
[null,null,"a.","Total Expenditures (B8)",null,null,{"$f":"B8Total","v":406553.71}]
[]
[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":0}]
[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(J3ATotalExpenditures - J3BLessFederal)","v":406553.71}]
[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)","v":675.74}]
[null,null,null,"[Total B6 plus objects 7438 and 7439, less L1 Total]"]
[]
[null,null,null,"TOTAL STATE & LOCAL EXPENDITURES SUBJECT TO MOE",null,"$",{"$f":"SUM(J3CTotal -J3DTotal-J3ETotal)","v":405877.97}]
[null,null,null,"[c minus d minus e]"]
[{"$f":"CELL(\"filename\")","v":"C:\\Users\\AAS\\AppData\\Local\\Microsoft\\Windows\\INetCache\\Content.Outlook\\B84T85I8\\[37682130127068.xlsm]Certification"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",2001.1]

{"sheet":"MACROS","index":2,"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," "]