| First Year of Operation Cash Flow Projection: Projected Revenues and Expenditures |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Instructions/Notes |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
FY: |
======
ID#AAAANX-Cj94
Brenton T. Stewart (2021-07-27 13:34:48)
Select Fiscal Year from drop-down list.
2023 |
|
|
Charter School: |
Innovators Charter School |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Please type in the name of your charter school in cells R4-AB4. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
July |
|
August |
|
September |
|
October |
|
November |
|
December |
|
January |
|
February |
|
March |
|
April |
|
May |
|
June |
|
======
ID#AAAANX-Cj98
Brenton T. Stewart (2021-07-27 13:34:48)
This Total column will be automatically calculated and should match the line items (except for the major assumptions and cash balance) found in Year 1 of the Three Year Budget Template.
Total |
|
|
|
|
|
|
|
|
FY |
2023 |
|
FY |
2023 |
|
FY |
2023 |
|
FY |
2023 |
|
FY |
2023 |
|
FY |
2023 |
|
FY |
2023 |
|
FY |
2023 |
|
FY |
2023 |
|
FY |
2023 |
|
FY |
2023 |
|
FY |
2023 |
|
FY |
2023 |
|
Please select your first year of operation from the FY drop-down list. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TOTAL REVENUE |
|
|
|
96,056 |
|
420,270 |
|
433,713 |
|
433,795 |
|
433,795 |
|
574,507 |
|
461,362 |
|
448,174 |
|
448,174 |
|
448,174 |
|
448,174 |
|
856,886 |
|
5,503,076 |
|
Total Operating Revenues will be automatically displayed based on the figures inputted |
|
|
TOTAL EXPENSE |
|
|
|
196,141 |
|
418,506 |
|
427,873 |
|
433,373 |
|
427,873 |
|
554,644 |
|
483,842 |
|
431,873 |
|
426,873 |
|
426,873 |
|
426,873 |
|
736,976 |
|
5,391,723 |
|
Total Operating Expenditures will be automatically displayed based on the figures inputted. |
|
|
SURPLUS/(DEFICIT) |
|
|
|
(100,085) |
|
1,764 |
|
5,839 |
|
421 |
|
5,921 |
|
19,862 |
|
(22,480) |
|
16,300 |
|
21,300 |
|
21,300 |
|
21,300 |
|
119,910 |
|
111,353 |
|
Surplus/(Deficit) calculates automatically. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
BEGINNING CASH BALANCE |
|
|
|
101,875 |
|
1,790 |
|
3,553 |
|
9,392 |
|
9,814 |
|
15,735 |
|
35,597 |
|
13,117 |
|
29,417 |
|
50,717 |
|
72,018 |
|
93,318 |
|
|
|
Beginning Cash Balance will be automatically displayed based on the figure inputted at the bottom of this spreadsheet. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ENDING CASH BALANCE |
|
|
|
1,790 |
|
3,553 |
|
9,392 |
|
9,814 |
|
15,735 |
|
35,597 |
|
13,117 |
|
29,417 |
|
50,717 |
|
72,018 |
|
93,318 |
|
213,228 |
|
|
|
Ending Cash Balance calculates automatically. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OPERATING REVENUES |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OPERATING REVENUES |
| 1 |
|
Tuition |
|
|
|
|
|
408,713 |
|
408,713 |
|
408,713 |
|
408,713 |
|
408,713 |
|
408,713 |
|
408,713 |
|
408,713 |
|
408,713 |
|
408,713 |
|
817,425 |
|
4,904,550 |
1 |
Tuition paid to the charter school by either the Commonwealth or sending school district (Horace Mann). Please visit http://www.doe.mass.edu/charter/finance/tuition/calculation.html for the latest information about monthly tuition calculation and disbursement. |
| 2 |
|
Grants - State |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
2 |
Grants awarded directly by the Commonwealth of MA such as those awarded by the Academic Support Unit at DESE. |
| 3 |
|
Grants - Federal |
|
|
|
|
|
|
|
|
|
25,082 |
|
25,082 |
|
25,082 |
|
25,082 |
|
25,082 |
|
25,082 |
|
25,082 |
|
25,082 |
|
25,082 |
|
225,738 |
3 |
Grants awarded by the federal government (including those that pass through DESE such as Title I, IDEA, etc.). |
| 4 |
|
Grants - Private |
|
|
|
|
|
|
|
25,000 |
|
|
|
|
|
35,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
60,000 |
4 |
Grants awarded by private foundations or corporations. |
| 5 |
|
Nutrition Funding - State & Federal |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
14,379 |
|
14,379 |
|
14,379 |
|
14,379 |
|
14,379 |
|
14,379 |
|
86,275 |
5 |
Funding for nutrition programs is split between the federal and state governments. The latest information can be found at http://www.doe.mass.edu/cnp/financial.html |
| 6 |
|
Program Fees |
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
6 |
Any fees that the school collects for nutrition programs, transportation, uniforms, etc. |
| 7 |
|
Contributions, in-kind |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
7 |
Monetary value of in-kind donations for services that would otherwise need to be purchased. (This should be expensed in the appropriate categories below to avoid overstating revenues). |
| 8 |
|
Contributions, in-cash |
|
|
|
|
|
|
|
|
|
|
|
|
|
50,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
50,000 |
8 |
Donations from individuals or corporations. |
| 9 |
|
Investment Income |
|
|
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
9 |
Income generated from investments. (Please be aware of restrictions on investing government funds, specifically federal grant funds.) |
| 10 |
|
Transportation Reimbursements |
|
|
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
10 |
Reimbursements from the Commonwealth or sending districts for transportation costs, if applicable. |
| 11 |
|
Other: |
LOC - Non Revolving |
|
|
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
11 |
Specify other revenues, if applicable, such as loans or lines of credit. Provide the title or a brief description of the operating revenue source in cells D30-E30. |
| 12 |
|
Other: |
LOC - Revolving |
|
96,056 |
|
11,557 |
|
0 |
|
0 |
|
0 |
|
55,712 |
|
13,188 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
176,513 |
12 |
Specify other revenues, if applicable. Provide the title or a brief description of the operating revenue source in cells D31-E31. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 13 |
|
TOTAL OPERATING REVENUES |
|
|
|
96,056 |
|
420,270 |
|
433,713 |
|
433,795 |
|
433,795 |
|
574,507 |
|
461,362 |
|
448,174 |
|
448,174 |
|
448,174 |
|
448,174 |
|
856,886 |
|
5,503,076 |
13 |
Total Operating Revenues calculates automatically. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OPERATING EXPENDITURES |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OPERATING EXPENDITURES |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Administration |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Administration (Non-instructional costs) |
| 14 |
|
Salaries - Administrative (Professional) |
|
|
|
47,308 |
|
47,308 |
|
47,308 |
|
47,308 |
|
47,308 |
|
70,962 |
|
47,308 |
|
47,308 |
|
47,308 |
|
47,308 |
|
47,308 |
|
70,962 |
|
615,000 |
14 |
Non-instructional personnel on payroll such as executive director, business manager, director of operation, etc. on payroll. (Principals and Instructional Leaders should be noted in line 33). |
| 15 |
|
Salaries - Administrative (Support/Clerical) |
|
|
|
3,846 |
|
3,846 |
|
3,846 |
|
3,846 |
|
3,846 |
|
5,769 |
|
3,846 |
|
3,846 |
|
3,846 |
|
3,846 |
|
3,846 |
|
5,769 |
|
50,000 |
15 |
Non-instructional administrative support personnel on payroll who support the organization as a whole by preparing, transcribing, systematizing or preserving communications, records and transactions. |
| 16 |
|
Accounting-Audit |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
20,000 |
|
20,000 |
16 |
Contracted professional services for accounting, independent audits, bookkeeping, etc. |
| 17 |
|
Legal |
|
|
|
833 |
|
833 |
|
833 |
|
833 |
|
833 |
|
833 |
|
833 |
|
833 |
|
833 |
|
833 |
|
833 |
|
833 |
|
10,000 |
17 |
Contracted professional services for legal counsel. |
| 18 |
|
Payroll |
|
|
|
3,333 |
|
3,333 |
|
3,333 |
|
3,333 |
|
3,333 |
|
3,333 |
|
3,333 |
|
3,333 |
|
3,333 |
|
3,333 |
|
3,333 |
|
3,333 |
|
40,000 |
18 |
Contracted professional services. |
| 19 |
|
Other Professional Services |
|
|
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
20,000 |
19 |
Contracted professional services for architect |
| 20 |
|
Information Management and Technology |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
20 |
Non-capitalized computers, servers, networks, scanners, software and licenses used for data processing that supports the needs of the organization as a whole. |
| 21 |
|
Office Supplies and Materials |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
21 |
Non-instructional administrative support including postage, printing, etc. |
| 22 |
|
Professional Development, Administrative/Board |
|
|
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
5,000 |
22 |
Professional development for non-instructional administrative staff and the Board of trustees. |
| 23 |
|
Dues, Licenses, and Subscriptions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
23 |
Dues, licenses, and subscriptions for non-instructional administrative staff or that support the organization as a whole. |
| 24 |
|
Fundraising |
|
|
|
|
|
|
|
|
|
5,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5,000 |
|
10,000 |
24 |
Contracted professional services and related costs. |
| 25 |
|
Recruitment/Advertising |
|
|
|
5,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
5,000 |
|
|
|
|
|
|
|
10,000 |
|
20,000 |
25 |
Recruiting/advertising for students, staff, and board members. |
| 26 |
|
Travel Expenses for Staff/Board |
|
|
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
5,000 |
26 |
Travel expenses for staff/Board that are paid for or reimbursed by the school. |
| 27 |
|
Bank Charges - Current (Short Term) |
|
|
|
1,591 |
|
1,566 |
|
1,540 |
|
1,515 |
|
1,489 |
|
1,463 |
|
1,437 |
|
1,411 |
|
1,385 |
|
1,359 |
|
1,333 |
|
1,307 |
|
17,397 |
27 |
Short-term lines of credit interest or regular bank charges. |
| 28 |
|
Purchased Management Services |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
28 |
Non-instructional administrative services provided by an Educational Management Organization (EMO) as specified in the contract. |
| 29 |
|
Other: |
Liability Insurance |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
15,000 |
29 |
Specify other administrative expenditures, if applicable. Provide the title or a brief description of the administrative expenditure in cells D55-E55. |
| 30 |
|
Other: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
30 |
Specify other administrative expenditures, if applicable. Provide the title or a brief description of the administrative expenditure in cells D56-E56. |
| 31 |
|
|
|
Subtotal: |
|
65,662 |
|
60,636 |
|
60,611 |
|
65,585 |
|
60,559 |
|
86,111 |
|
60,508 |
|
65,482 |
|
60,456 |
|
60,430 |
|
60,404 |
|
120,954 |
|
827,397 |
31 |
Subtotal calculates automatically. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Instructional Services |
|
|
|
General Education |
Special Education |
|
General Education |
Special Education |
|
General Education |
Special Education |
|
General Education |
Special Education |
|
General Education |
Special Education |
|
General Education |
Special Education |
|
General Education |
Special Education |
|
General Education |
Special Education |
|
General Education |
Special Education |
|
General Education |
Special Education |
|
General Education |
Special Education |
|
General Education |
Special Education |
|
General Education |
Special Education |
|
Instructional Services |
| 32 |
|
Salaries - Teachers |
|
|
|
|
|
|
59,304 |
8,087 |
|
118,609 |
16,174 |
|
118,609 |
16,174 |
|
118,609 |
16,174 |
|
177,913 |
24,261 |
|
118,609 |
16,174 |
|
118,609 |
16,174 |
|
118,609 |
16,174 |
|
118,609 |
16,174 |
|
118,609 |
16,174 |
|
177,913 |
24,261 |
|
1,364,000 |
186,000 |
32 |
Classroom teachers and specialists on payroll (potential bonuses that are considered part of an employees salary compensation should be included, if applicable). |
| 33 |
|
Salaries - Other (Professional) |
|
|
|
33,558 |
3,365 |
|
37,601 |
6,670 |
|
41,645 |
9,974 |
|
41,645 |
9,974 |
|
41,645 |
9,974 |
|
41,645 |
14,961 |
|
62,467 |
9,974 |
|
41,645 |
9,974 |
|
41,645 |
9,974 |
|
41,645 |
9,974 |
|
41,645 |
9,974 |
|
62,467 |
14,961 |
|
529,250 |
119,750 |
33 |
Instructional personnel on payroll such as Principal/Assistant Principals, Curriculum Directors (including SPED), Instructional Technology Coordinators, Occupational/Speech Therapists, Librarians, Guidance Counselors, Psychologists, etc. |
| 34 |
|
Salaries - Paraprofessionals |
|
|
|
|
0 |
|
|
4,565 |
|
|
9,130 |
|
|
9,130 |
|
|
9,130 |
|
|
13,696 |
|
|
9,130 |
|
|
9,130 |
|
|
9,130 |
|
|
9,130 |
|
|
9,130 |
|
|
13,696 |
|
0 |
105,000 |
34 |
Classroom instructional aids/assistance and paraprofessionals on payroll. |
| 35 |
|
Salaries - Support/Clerical |
|
|
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
35 |
Administrative support personnel on payroll who support classroom instruction by preparing, transcribing, systematizing or preserving communications, records and transactions. (e.g., a SPED clerical assistant). |
| 36 |
|
Contracted Services, Instructional |
|
|
|
0 |
0 |
|
0 |
0 |
0 |
0 |
3,500 |
|
0 |
3,500 |
|
0 |
3,500 |
|
0 |
3,500 |
|
0 |
3,500 |
|
0 |
3,500 |
|
0 |
3,500 |
|
0 |
3,500 |
0 |
0 |
3,500 |
|
0 |
3,500 |
|
0 |
35,000 |
36 |
Contracted professional services, including all related expenses covered by the contract, for guidance, psychological, occupational therapy, etc. (non-payroll substitute teachers should be included here). |
| 37 |
|
Instructional Technology in Classrooms |
|
|
|
|
|
|
100,000 |
1,000 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
21,750 |
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
121,750 |
1,000 |
37 |
Non-capitalized computers, servers, networks, scanners, digital cameras, etc. and software and licenses used for instruction (including non-capitalized hardware/software). |
| 38 |
|
Instructional Supplies & Materials |
|
|
|
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
0 |
0 |
38 |
Textbooks, paper, supplies, including bulk photocopying for instructional purposes. |
| 39 |
|
Testing & Assessment |
|
|
|
0 |
0 |
|
14,175 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
14,175 |
0 |
39 |
Materials and services related to the administration of tests and assessments. |
| 40 |
|
Professional Development, Instructional |
|
|
|
0 |
0 |
|
10,000 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
5,000 |
5,000 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
15,000 |
5,000 |
40 |
Professional development of instructional personnel. |
| 41 |
|
Dues, Licenses, and Subscriptions |
|
|
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
41 |
Dues, licenses, and subscriptions for instructional staff. |
| 42 |
|
Staff Stipends in addition to base salary |
|
|
|
0 |
0 |
|
652 |
0 |
|
1,304 |
0 |
|
1,304 |
0 |
|
1,304 |
0 |
|
1,957 |
0 |
|
1,304 |
0 |
|
1,304 |
0 |
|
1,304 |
0 |
|
1,304 |
0 |
|
1,304 |
0 |
|
1,957 |
0 |
|
15,000 |
0 |
42 |
Staff stipends for additional duties that are not included as part of their salary contract. |
| 43 |
|
Purchased Management Services |
|
|
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
43 |
Instructional services provided by an Educational Management Organization (EMO) as specified in the contract. |
| 44 |
|
Other: |
|
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
44 |
Specify other instructional expenditures, if applicable. Provide the title or a brief description of the instructional expenditure in cells D73-E73. |
| 45 |
|
Other: |
|
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
45 |
Specify other instructional expenditures, if applicable. Provide the title or a brief description of the instructional expenditure in cells D74-E74. |
| 46 |
|
|
|
Subtotal: |
|
33,558 |
3,365 |
|
221,733 |
20,322 |
|
161,558 |
38,778 |
|
161,558 |
38,778 |
|
161,558 |
38,778 |
|
221,514 |
56,418 |
|
209,130 |
43,778 |
|
161,558 |
38,778 |
|
161,558 |
38,778 |
|
161,558 |
38,778 |
|
161,558 |
38,778 |
|
242,337 |
56,418 |
|
2,059,175 |
451,750 |
46 |
Subtotal calculates automatically. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other Student Services |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other Student Services |
| 47 |
|
Salaries - Other Student Services |
|
|
|
|
|
3,696 |
|
7,391 |
|
7,391 |
|
7,391 |
|
11,087 |
|
7,391 |
|
7,391 |
|
7,391 |
|
7,391 |
|
7,391 |
|
11,087 |
|
85,000 |
47 |
School nurses, food service coordinators, coaches, etc. on payroll. |
| 48 |
|
Health Services |
|
|
|
|
|
|
|
1,000 |
|
1,000 |
|
1,000 |
|
1,000 |
|
1,000 |
|
1,000 |
|
1,000 |
|
1,000 |
|
1,000 |
|
1,000 |
|
10,000 |
48 |
Contracted professional services and related costs. |
| 49 |
|
Student Transportation (to and from school) |
|
|
|
|
|
|
|
20,000 |
|
20,000 |
|
20,000 |
|
20,000 |
|
20,000 |
|
20,000 |
|
20,000 |
|
20,000 |
|
20,000 |
|
20,000 |
|
200,000 |
49 |
Contracted professional services and related costs. |
| 50 |
|
Food Services |
|
|
|
|
|
|
|
10,353 |
|
10,353 |
|
10,353 |
|
10,353 |
|
10,353 |
|
10,353 |
|
10,353 |
|
10,353 |
|
10,353 |
|
10,353 |
|
103,530 |
50 |
Contracted professional services and related costs. |
| 51 |
|
Athletic Services |
|
|
|
|
|
|
|
500 |
|
500 |
|
500 |
|
500 |
|
500 |
|
500 |
|
500 |
|
500 |
|
500 |
|
500 |
|
5,000 |
51 |
Contracted professional services and related costs. |
| 52 |
|
Purchased Management Services |
|
|
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
52 |
Other students services provided by an Educational Management Organization (EMO) as specified in the contract. |
| 53 |
|
Other: |
|
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
53 |
Specify other student services expenditures, if applicable. Provide the title or a brief description of the student services expenditure in cells D85-E85. |
| 54 |
|
Other: |
|
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
54 |
Specify other student services expenditures, if applicable. Provide the title or a brief description of the student services expenditure in cells D86-E86. |
| 55 |
|
|
|
Subtotal: |
|
0 |
|
3,696 |
|
39,244 |
|
39,244 |
|
39,244 |
|
42,940 |
|
39,244 |
|
39,244 |
|
39,244 |
|
39,244 |
|
39,244 |
|
42,940 |
|
403,530 |
55 |
Subtotal calculates automatically. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Operation and Maintenance of Plant |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Operation and Maintenance of Plant |
| 56 |
|
Salaries - Operation and Maintenance of Plant |
|
|
|
6,154 |
|
6,154 |
|
6,154 |
|
6,154 |
|
6,154 |
|
9,231 |
|
6,154 |
|
6,154 |
|
6,154 |
|
6,154 |
|
6,154 |
|
9,231 |
|
80,000 |
56 |
Plant managers, custodians, maintenance staff, etc. on payroll. |
| 57 |
|
Utilities |
|
|
|
5,833 |
|
5,833 |
|
5,833 |
|
5,833 |
|
5,833 |
|
5,833 |
|
5,833 |
|
5,833 |
|
5,833 |
|
5,833 |
|
5,833 |
|
5,833 |
|
70,000 |
57 |
Coal, fuel, oil, electivity, gas, water, trash, waste disposal, telephone services, etc. |
| 58 |
|
Maintenance of Buildings & Grounds |
|
|
|
|
|
|
|
1,000 |
|
1,000 |
|
1,000 |
|
1,000 |
|
1,000 |
|
1,000 |
|
1,000 |
|
1,000 |
|
1,000 |
|
1,000 |
|
10,000 |
58 |
Custodial and maintenance services including building security. |
| 59 |
|
Maintenance of Equipment |
|
|
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
417 |
|
5,000 |
59 |
Maintenance of equipment, including vehicles: parts and repair, materials, and tools, including vehicles. |
| 60 |
|
Rental/Lease of Buildings & Grounds |
|
|
|
55,250 |
|
55,250 |
|
55,250 |
|
55,250 |
|
55,250 |
|
55,250 |
|
55,250 |
|
55,250 |
|
55,250 |
|
55,250 |
|
55,250 |
|
55,250 |
|
663,000 |
60 |
Operating lease/rental for building and grounds. |
| 61 |
|
Rental/Lease of Equipment |
|
|
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
1,667 |
|
20,000 |
61 |
Operating lease/rental for equipment, such as a photocopier. |
| 62 |
|
Capital Debt Service |
|
|
|
7,617 |
|
7,643 |
|
7,668 |
|
7,694 |
|
7,719 |
|
7,745 |
|
7,771 |
|
7,797 |
|
7,823 |
|
7,849 |
|
7,875 |
|
7,901 |
|
93,102 |
62 |
Annual payments for long-term capital debt. |
| 63 |
|
Renovation/Construction |
|
|
|
|
|
|
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
63 |
Annual costs for capital improvement or acquisition of building and grounds including related fees for services from architects, project planners, etc. |
| 64 |
|
Acquisition of Capital Equipment |
|
|
|
|
|
|
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
64 |
Annual costs for acquisition of capital equipment (including computer labs, furniture, etc.). |
| 68 |
|
Purchased Management Services |
|
|
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
68 |
Plant operation and maintenance services provided by an Educational Management Organization (EMO) as specified in the contract. |
| 66 |
|
Other: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
66 |
Specify other plant operation and maintenance expenditures, if applicable. Provide the title or a brief description of the operational or maintenance expenditure in cells D101-E101. |
| 67 |
|
Other: |
|
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
67 |
Specify other plant operation and maintenance expenditures, if applicable. Provide the title or a brief description of the operational or maintenance expenditure in cells D102-E102. |
| 68 |
|
|
|
Subtotal: |
|
76,938 |
|
76,963 |
|
77,989 |
|
78,014 |
|
78,040 |
|
81,142 |
|
78,091 |
|
78,117 |
|
78,143 |
|
78,169 |
|
78,196 |
|
81,299 |
|
941,102 |
68 |
Subtotal calculates automatically. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Fixed Charges |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Fixed Charges |
| 69 |
|
Payroll taxes |
|
|
|
4,061 |
|
7,639 |
|
11,216 |
|
11,216 |
|
11,216 |
|
15,926 |
|
12,113 |
|
11,216 |
|
11,216 |
|
11,216 |
|
11,216 |
|
16,824 |
|
135,075 |
69 |
Includes school contributions on behalf of its employees for Medicaid, social security, worker's compensation, and unemployment insurance. |
| 70 |
|
Fringe Benefits |
|
|
|
11,308 |
|
21,268 |
|
31,228 |
|
31,228 |
|
31,228 |
|
44,343 |
|
33,726 |
|
31,228 |
|
31,228 |
|
31,228 |
|
31,228 |
|
46,842 |
|
376,080 |
70 |
Health and life insurance premiums or payments, pension plans, and other employee retirement systems paid by the school for the benefit of the employee (school's portion). |
| 71 |
|
Insurance (non-employee) |
|
|
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
1,250 |
|
15,000 |
71 |
Insurance premiums for property, fire, liability, fidelity bonds; judgments against the school resulting from self-insurance. |
| 72 |
|
Purchased Management Services |
|
|
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
72 |
Fixed charges provided for by an Educational Management Organization (EMO) as specified in the contract. |
| 73 |
|
Other: |
|
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
73 |
Specify other fixed charge expenditures, if applicable, which may include costs of public safety inspections. Provide the title or a brief description of the fixed charges expenditure in cells D111-E111. |
| 74 |
|
Other: |
|
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
74 |
Specify other fixed charge expenditures, if applicable. Provide the title or a brief description of the fixed charges expenditure in cells D112-E112. |
| 75 |
|
|
|
Subtotal: |
|
16,619 |
|
30,156 |
|
43,694 |
|
43,694 |
|
43,694 |
|
61,519 |
|
47,090 |
|
43,694 |
|
43,694 |
|
43,694 |
|
43,694 |
|
64,915 |
|
526,155 |
75 |
Subtotal calculates automatically. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Community Services (Including Dissemination) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 76 |
|
Dissemination Activities |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,000 |
|
1,000 |
76 |
Activities designed to disseminate the school's best practices to external groups, including presentations at or hosting of conferences, etc. |
| 77 |
|
Civic Activities |
|
|
|
|
|
|
|
|
|
500 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
500 |
|
1,000 |
77 |
Services provided by the school for the community such as parent meetings, school council meetings, etc. |
| 78 |
|
|
|
Subtotal: |
|
0 |
|
0 |
|
0 |
|
500 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
0 |
|
1,500 |
|
2,000 |
78 |
Subtotal calculates automatically. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 79 |
|
Contingency Fund |
|
|
|
|
|
5,000 |
|
6,000 |
|
6,000 |
|
6,000 |
|
5,000 |
|
6,000 |
|
5,000 |
|
5,000 |
|
5,000 |
|
5,000 |
|
126,613 |
|
180,613 |
79 |
Funds purposefully set aside as a contingency. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 80 |
|
TOTAL OPERATING EXPENDITURES |
|
|
|
196,141 |
|
418,506 |
|
427,873 |
|
433,373 |
|
427,873 |
|
554,644 |
|
483,842 |
|
431,873 |
|
426,873 |
|
426,873 |
|
426,873 |
|
736,976 |
|
5,391,723 |
80 |
Total Operating Expenditures calculates automatically. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 81 |
|
SURPLUS/(DEFICIT) |
|
|
|
(100,085) |
|
1,764 |
|
5,839 |
|
421 |
|
5,921 |
|
19,862 |
|
(22,480) |
|
16,300 |
|
21,300 |
|
21,300 |
|
21,300 |
|
119,910 |
|
111,353 |
81 |
Surplus/(Deficit) calculates automatically. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 82 |
|
BEGINNING CASH BALANCE |
|
|
|
101,875 |
|
1,790 |
|
3,553 |
|
9,392 |
|
9,814 |
|
15,735 |
|
35,597 |
|
13,117 |
|
29,417 |
|
50,717 |
|
72,018 |
|
93,318 |
|
|
82 |
A formula is embedded to capture the previous month's Ending Cash Balance, adjust as necessary. Type in your initial cash balance, if any, in cells G130-H130. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 83 |
|
ENDING CASH BALANCE |
|
|
|
1,790 |
|
3,553 |
|
9,392 |
|
9,814 |
|
15,735 |
|
35,597 |
|
13,117 |
|
29,417 |
|
50,717 |
|
72,018 |
|
93,318 |
|
213,228 |
|
|
83 |
Ending Cash Balance calculates automatically. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2021 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2022 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2023 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2024 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2025 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2026 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2027 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2028 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2029 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2030 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
