{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Startup","YEAR 1","YEAR 2","YEAR 3","LHA Detail"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":13,"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":"Startup","index":0,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[50,12,51,12],[50,6,51,6],[50,13,51,13],[50,14,51,14],[50,15,51,15],[50,16,51,16],[0,0,0,2],[50,1,51,1],[50,3,51,3],[50,4,51,4],[50,5,51,5],[0,3,0,17],[50,17,51,17],[50,7,51,7],[50,8,51,8],[50,9,51,9],[50,10,51,10],[50,11,51,11]]}
["XYZ CHARTER SCHOOL",null,null,"STARTUP YEAR - PROJECTED CASH FLOW"]
[null,null,"Object","July","Aug","Sept","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","June","Sub-total","Accruals","Total"]
[null,"Actuals through Month of:","N/A"]
["A","Beginning Cash",9110,0,{"$f":"D53","v":0},{"$f":"E53","v":0},0,0,0,0,0,0,0,0,0,{"$f":"D4","v":0}]
["B","Receipts"]
[null,"LCFF Sources"]
[null,"State Aid - Current Year",8011,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D7:O7)","v":0},null,{"$f":"SUM(P7:Q7)","v":0}]
[null,"Education Protection Account",8012,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,{"$f":"SUM(P8:Q8)","v":0}]
[null,"State Aid - Prior Years",8019,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Local In Lieu of Prop. Taxes",8096,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Federal Revenue (List)","8100-8299",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"A ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D12:O12)","v":0},null,{"$f":"SUM(P12:Q12)","v":0}]
[null,"B",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other State Revenue (List)","8300-8599",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"A ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D16:O16)","v":0},null,{"$f":"SUM(P16:Q16)","v":0}]
[null,"B  ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Local Revenue (List)","8600-8799",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"A ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D20:O20)","v":0},null,{"$f":"SUM(P20:Q20)","v":0}]
[null,"B  ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Interfund Transfers In","8910-8929",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"All Other Financing Sources","8930-8979",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Receipts/Non-Revenue","TRANS",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Total Receipts",null,{"$f":"SUM(D7:D25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P26:Q26)","v":0}]
["C","Disbursements"]
[null,"Certificated Salaries","1000-1999",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D28:O28)","v":0},null,{"$f":"SUM(P28:Q28)","v":0}]
[null,"Classified Salaries","2000-2999",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:O29)","v":0},null,{"$f":"SUM(P29:Q29)","v":0}]
[null,"Employee Benefits","3000-3999",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Books & Supplies","4000-4999",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Services","5000-5999",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Capital Outlay","6000-6599",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Outgo","7000-7499",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Interfund Transfers Out","7600-7629",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"All Other Financing Uses","7630-7699",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Disbursements/Non-Exp.",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Total Disbursements",null,{"$f":"SUM(D28:D37)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["D","Prior Year Transactions","PY Amount"," "]
[null,"Accounts Receivable-9200",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D40:O40)","v":0},null,{"$f":"SUM(P40:Q40)","v":0}]
[null,"Due From Grantor Govts.-9290",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(P41:Q41)","v":0}]
[null,"Due From Other Funds-9310",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Prepaid Expense-9330",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Accounts Payable-9500",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Due To Grantor Govts.-9590",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Due to Other Funds-9610",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Due to Other Agencies-9620",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Current Loans/TRANs-9640",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Deferred Revenue-9650",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Total Pr. Yr. Transactions",{"$f":"SUM(C40:C43)-SUM(C44:C49)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E","Net Increase/Decrease                                       (B-C+D)",null,{"$f":"D26-D38+D50","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"R26-R38+R50","v":0}]
[]
["F","Ending Cash (A+E)",null,{"$f":"D4+D51","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["G","Ending Cash plus Accruals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P53+Q51","v":0}]

{"sheet":"YEAR 1","index":1,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[50,10,51,10],[50,11,51,11],[50,12,51,12],[50,13,51,13],[50,14,51,14],[50,15,51,15],[0,0,0,2],[0,3,0,17],[50,1,51,1],[50,3,51,3],[50,4,51,4],[50,5,51,5],[50,6,51,6],[50,7,51,7],[50,8,51,8],[50,9,51,9],[50,16,51,16],[50,17,51,17]]}
["XYZ CHARTER SCHOOL",null,null,"YEAR 1 - PROJECTED CASH FLOW"]
[null,null,"Object","July","Aug","Sept","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","June","Sub-total","Accruals","Total"]
[null,"Actuals through Month of:","N/A"]
["A","Beginning Cash",9110,0,{"$f":"D53","v":0},{"$f":"E53","v":0},0,0,0,0,0,0,0,0,0,{"$f":"D4","v":0}]
["B","Receipts"]
[null,"LCFF Sources"]
[null,"State Aid - Current Year",8011,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D7:O7)","v":0},null,{"$f":"SUM(P7:Q7)","v":0}]
[null,"Education Protection Account",8012,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,{"$f":"SUM(P8:Q8)","v":0}]
[null,"State Aid - Prior Years",8019,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Local In Lieu of Prop. Taxes",8096,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Federal Revenue (List)","8100-8299",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"A ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"B",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other State Revenue (List)","8300-8599",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"A ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"B  ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Local Revenue (List)","8600-8799",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"A ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"B  ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Interfund Transfers In","8910-8929",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"All Other Financing Sources","8930-8979",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Receipts/Non-Revenue","TRANS",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Total Receipts",null,{"$f":"SUM(D7:D25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P26:Q26)","v":0}]
["C","Disbursements"]
[null,"Certificated Salaries","1000-1999",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D28:O28)","v":0},null,{"$f":"SUM(P28:Q28)","v":0}]
[null,"Classified Salaries","2000-2999",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:O29)","v":0},null,{"$f":"SUM(P29:Q29)","v":0}]
[null,"Employee Benefits","3000-3999",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Books & Supplies","4000-4999",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Services","5000-5999",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Capital Outlay","6000-6599",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Outgo","7000-7499",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Interfund Transfers Out","7600-7629",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"All Other Financing Uses","7630-7699",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Disbursements/Non-Exp.",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Total Disbursements",null,{"$f":"SUM(D28:D37)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["D","Prior Year Transactions","PY Amount"," "]
[null,"Accounts Receivable-9200",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D40:O40)","v":0},null,{"$f":"SUM(P40:Q40)","v":0}]
[null,"Due From Grantor Govts.-9290",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(P41:Q41)","v":0}]
[null,"Due From Other Funds-9310",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Prepaid Expense-9330",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Accounts Payable-9500",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Due To Grantor Govts.-9590",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Due to Other Funds-9610",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Due to Other Agencies-9620",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Current Loans/TRANs-9640",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Deferred Revenue-9650",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Total Pr. Yr. Transactions",{"$f":"SUM(C40:C43)-SUM(C44:C49)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E","Net Increase/Decrease                                       (B-C+D)",null,{"$f":"D26-D38+D50","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"R26-R38+R50","v":0}]
[]
["F","Ending Cash (A+E)",null,{"$f":"D4+D51","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["G","Ending Cash plus Accruals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P53+Q51","v":0}]

{"sheet":"YEAR 2","index":2,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[50,10,51,10],[50,11,51,11],[50,12,51,12],[50,13,51,13],[50,14,51,14],[50,15,51,15],[0,0,0,2],[0,3,0,17],[50,1,51,1],[50,3,51,3],[50,4,51,4],[50,5,51,5],[50,6,51,6],[50,7,51,7],[50,8,51,8],[50,9,51,9],[50,16,51,16],[50,17,51,17]]}
["XYZ CHARTER SCHOOL",null,null,"YEAR 2 - PROJECTED CASH FLOW"]
[null,null,"Object","July","Aug","Sept","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","June","Sub-total","Accruals","Total"]
[null,"Actuals through Month of:","N/A"]
["A","Beginning Cash",9110,0,{"$f":"D53","v":0},{"$f":"E53","v":0},0,0,0,0,0,0,0,0,0,{"$f":"D4","v":0}]
["B","Receipts"]
[null,"LCFF Sources"]
[null,"State Aid - Current Year",8011,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D7:O7)","v":0},null,{"$f":"SUM(P7:Q7)","v":0}]
[null,"Education Protection Account",8012,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,{"$f":"SUM(P8:Q8)","v":0}]
[null,"State Aid - Prior Years",8019,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Local In Lieu of Prop. Taxes",8096,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Federal Revenue (List)","8100-8299",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"A ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"B",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other State Revenue (List)","8300-8599",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"A ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"B  ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Local Revenue (List)","8600-8799",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"A ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"B  ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Interfund Transfers In","8910-8929",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"All Other Financing Sources","8930-8979",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Receipts/Non-Revenue","TRANS",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Total Receipts",null,{"$f":"SUM(D7:D25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P26:Q26)","v":0}]
["C","Disbursements"]
[null,"Certificated Salaries","1000-1999",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D28:O28)","v":0},null,{"$f":"SUM(P28:Q28)","v":0}]
[null,"Classified Salaries","2000-2999",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:O29)","v":0},null,{"$f":"SUM(P29:Q29)","v":0}]
[null,"Employee Benefits","3000-3999",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Books & Supplies","4000-4999",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Services","5000-5999",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Capital Outlay","6000-6599",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Outgo","7000-7499",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Interfund Transfers Out","7600-7629",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"All Other Financing Uses","7630-7699",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Disbursements/Non-Exp.",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Total Disbursements",null,{"$f":"SUM(D28:D37)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["D","Prior Year Transactions","PY Amount"," "]
[null,"Accounts Receivable-9200",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D40:O40)","v":0},null,{"$f":"SUM(P40:Q40)","v":0}]
[null,"Due From Grantor Govts.-9290",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(P41:Q41)","v":0}]
[null,"Due From Other Funds-9310",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Prepaid Expense-9330",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Accounts Payable-9500",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Due To Grantor Govts.-9590",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Due to Other Funds-9610",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Due to Other Agencies-9620",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Current Loans/TRANs-9640",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Deferred Revenue-9650",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Total Pr. Yr. Transactions",{"$f":"SUM(C40:C43)-SUM(C44:C49)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E","Net Increase/Decrease                                       (B-C+D)",null,{"$f":"D26-D38+D50","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"R26-R38+R50","v":0}]
[]
["F","Ending Cash (A+E)",null,{"$f":"D4+D51","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["G","Ending Cash plus Accruals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P53+Q51","v":0}]

{"sheet":"YEAR 3","index":3,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[50,10,51,10],[50,11,51,11],[50,12,51,12],[50,13,51,13],[50,14,51,14],[50,15,51,15],[0,0,0,2],[0,3,0,17],[50,1,51,1],[50,3,51,3],[50,4,51,4],[50,5,51,5],[50,6,51,6],[50,7,51,7],[50,8,51,8],[50,9,51,9],[50,16,51,16],[50,17,51,17]]}
["XYZ CHARTER SCHOOL",null,null,"YEAR 3 - PROJECTED CASH FLOW"]
[null,null,"Object","July","Aug","Sept","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","June","Sub-total","Accruals","Total"]
[null,"Actuals through Month of:","N/A"]
["A","Beginning Cash",9110,0,{"$f":"D53","v":0},{"$f":"E53","v":0},0,0,0,0,0,0,0,0,0,{"$f":"D4","v":0}]
["B","Receipts"]
[null,"LCFF Sources"]
[null,"State Aid - Current Year",8011,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D7:O7)","v":0},null,{"$f":"SUM(P7:Q7)","v":0}]
[null,"Education Protection Account",8012,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,{"$f":"SUM(P8:Q8)","v":0}]
[null,"State Aid - Prior Years",8019,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Local In Lieu of Prop. Taxes",8096,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Federal Revenue (List)","8100-8299",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"A ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"B",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other State Revenue (List)","8300-8599",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"A ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"B  ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Local Revenue (List)","8600-8799",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"A ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"B  ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Interfund Transfers In","8910-8929",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"All Other Financing Sources","8930-8979",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Receipts/Non-Revenue","TRANS",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Total Receipts",null,{"$f":"SUM(D7:D25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P26:Q26)","v":0}]
["C","Disbursements"]
[null,"Certificated Salaries","1000-1999",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D28:O28)","v":0},null,{"$f":"SUM(P28:Q28)","v":0}]
[null,"Classified Salaries","2000-2999",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:O29)","v":0},null,{"$f":"SUM(P29:Q29)","v":0}]
[null,"Employee Benefits","3000-3999",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Books & Supplies","4000-4999",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Services","5000-5999",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Capital Outlay","6000-6599",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Outgo","7000-7499",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Interfund Transfers Out","7600-7629",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"All Other Financing Uses","7630-7699",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Other Disbursements/Non-Exp.",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Total Disbursements",null,{"$f":"SUM(D28:D37)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["D","Prior Year Transactions","PY Amount"," "]
[null,"Accounts Receivable-9200",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D40:O40)","v":0},null,{"$f":"SUM(P40:Q40)","v":0}]
[null,"Due From Grantor Govts.-9290",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(P41:Q41)","v":0}]
[null,"Due From Other Funds-9310",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Prepaid Expense-9330",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Accounts Payable-9500",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Due To Grantor Govts.-9590",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Due to Other Funds-9610",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Due to Other Agencies-9620",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Current Loans/TRANs-9640",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Deferred Revenue-9650",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Total Pr. Yr. Transactions",{"$f":"SUM(C40:C43)-SUM(C44:C49)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E","Net Increase/Decrease                                       (B-C+D)",null,{"$f":"D26-D38+D50","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"R26-R38+R50","v":0}]
[]
["F","Ending Cash (A+E)",null,{"$f":"D4+D51","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["G","Ending Cash plus Accruals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P53+Q51","v":0}]

{"sheet":"LHA Detail","index":4,"n_rows":74,"n_cols":8,"rows_kept":74,"cut":false,"hidden":true,"merged":[]}
["ASPIRE PUBLIC SCHOOLS"]
["Langston Hughes Academy"]
["5 YEAR PRO FORMA INCOME STATEMENT"]
[]
[null,"ENROLLMENT",144,204,264,324,384,267]
[]
[null,null,"FY07-08","FY08-09","FY09-10","FY10-11","FY11-12","FY12-13"]
[null,null,"Projection","Projection","Projection","Projection","Projection","Projection"]
[]
["REVENUES"]
["State Aid Per Pupil Revenue",null,662298.48,935725.67999999993,1282585.68,1608464.88,1934344.08,2863460.76]
["Federal Income",null,53595,51609.600000000006,73113.600000000006,139617.60000000001,116121.60000000001,212625.6]
["CDE Grant",null,0,180000,180000,0,0,0]
["Categorical Block Grant",null,67897.600000000006,91021.599999999991,114145.60000000001,137269.59999999998,160393.59999999998,235071.39999999997]
["Other State Revenue",null,76044.319999999978,83771.12000000001,183997.92,191724.72000000003,199451.52000000002,204628.98000000004]
["Donations",null,0,0,0,0,0,0]
["In-lieu Tax Revenue",null,133600.31999999998,189267.11999999997,244933.91999999998,300600.71999999997,356267.52000000002,548317.98]
["Other Local Revenue",null,0,0,0,0,0,0]
["Interfund Transfers In",null,0,0,0,0,0,0]
[null,"TOTAL REVENUES",{"$f":"SUM(C11:C19)","v":993435.71999999986},1531395.1199999999,2078776.72,2377677.52,2766578.3200000003,4064104.7199999997]
[]
["EXPENSES"]
["Personnel"]
[null,"Certificated",379600,597750,807450,1041700,1253400,1248400]
[null,"Classified",114447,124447,212812,222812,232812,232812]
[null,"Benefits",114202.09502000001,167002.44502000001,240118.62591999996,299935.07592000003,352019.63592000003,280805.83592000004]
[null,"   Total Personnel",{"$f":"SUM(C24:C26)","v":608249.09502000001},889199.44501999998,1260380.62592,1564447.07592,1838231.63592,1762017.83592]
[]
["Books & Supplies"]
["Books",null,18750,25500,33000,40500,48000,73875]
["Materials/Supplies",null,38371,46768.44,73800.040000000008,92771.64,106743.24,139945.26]
["Food Services",null,5000,2000,2000,2000,2000,95000]
[null,"Tot Books/Supplies",{"$f":"SUM(C30:C32)","v":62121},74268.44,108800.04000000001,135271.64000000001,156743.24,308820.26]
[]
["Services & Other Operating Expenses"]
["Travel and Conference",null,14240,9000,13000,18000,22000,17600]
["Dues & Subscriptions",null,500,500,500,500,500,500]
["Insurance",null,2736,3876,5016,6156,7296,11229]
["PG&E",null,49968,70788,91608,112428,133248,205077]
["Other Utilities",null,0,0,0,0,0,0]
["Rent ",null,10000,12500,15625,15625,15625,115200]
["Rent - Furn/Equip",null,0,0,0,0,0,0]
["Repairs & Maint",null,5000,0,0,0,0,0]
["Architect Fees",null,0,0,0,0,0,0]
["Educ Consultant",null,18000,25500,33000,40500,48000,73875]
["Facilities Contractor",null,28080,39780,51480,63180,74880,2340]
["Other Consultants",null,0,0,0,0,0,0]
["Marketing/Advertisement",null,1000,1000,1000,1000,1000,0]
["Field Trip",null,2500,5000,5000,5000,5000,5000]
["Printing/Reprod",null,9200,10920,13856,15072.8,16654.64,14654.64]
["Fingerprinting",null,500,500,500,500,500,500]
["License & Permits",null,0,0,0,0,0,0]
["Transportation",null,0,0,0,0,0,0]
["Interest Expense",null,19589.330000000002,19589.330000000002,19589.330000000002,19589.330000000002,19589.330000000002,0]
["Depreciation",null,74832,74832,74832,74832,74832,74832]
["Communications",null,15000,15000,15000,15000,15000,13000]
[null,"Tot Services",{"$f":"SUM(C36:C56)","v":251145.33000000002},288785.33,340006.33,387383.13,434124.97000000003,533807.64]
[null,null,null,{"$f":"+(D57-C57)/C57","v":0.14987338207722198},{"$f":"+(E57-D57)/D57","v":0.17736704284805602},{"$f":"+(F57-E57)/E57","v":0.13934093521141205},{"$f":"+(G57-F57)/F57","v":0.12066049443092688}]
["Capital Outlay"]
["Site Improvements",null,0,0,0,0,0,0]
["Equipment",null,11000,30000,30000,30000,74000,39600]
[null,"Tot Capital Outlay",{"$f":"SUM(C60:C61)","v":11000},30000,30000,30000,74000,39600]
[]
["Other Expenses"]
["Facilities Allocation",null,33501,33501,33501,33501,33501,33501]
["Corp Admin(7%)",null,60519.121599999999,85640.245599999995,115901.66559999999,144694.4296,173487.19360000003,265924.67019999999]
["Dist Admin (1%)",null,8645.5887999999995,12234.3208,16557.380799999999,20670.632799999999,24783.8848,37989.238599999997]
["Reserve (3%)",null,6437.7663999999968,10766.196,12969.18,12339.755999999994,12339.756000000008,51955.8174]
["Interfund Transfers Out",null,0,0,0,0,0,0]
[null,"Tot Other Activity",{"$f":"SUM(C65:C69)","v":109103.47679999999},142141.76239999998,178929.22639999999,211205.81839999999,244111.83440000005,389370.72619999998]
[]
[null,"TOTAL EXPENSES",{"$f":"+C27+C33+C57+C62+C70","v":1041618.9018199999},1424394.9774199999,1918116.2223200002,2328307.6643199995,2747211.6803200003,3033616.4621199998]
[]
["NET PROFIT (LOSS)",null,{"$f":"+C20-C72","v":-48183.181820000056},107000.14257999999,160660.4976799998,49369.855680000503,19366.639680000022,1030488.2578799999]