12
APPENDIX B:
ESTIMATED BUDGET PROJECTIONS AND ENROLLMENT
Five Year Projections
Year Ending Year Ending Year Ending Year Ending Year Ending
6/30/2022 6/30/2023 6/30/2024 6/30/2025 6/30/2026
Projected Enrollment
2594 2848 2859 2887 2909
Revenues
Federal Revenues 1,295,971$ 1,331,880$ 644,401$ 662,268$ 692,395$
LCFF Revenues 22,662,222 26,538,495 27,488,178 28,778,240 29,751,754
Other State Revenues 2,799,751 2,660,912 2,792,621 2,894,138 2,976,235
Local Revenues 859,290 1,002,955 1,041,341 1,070,380 1,093,368
Total Revenues 27,617,234 31,534,242 31,966,541 33,405,026 34,513,751
Expenses
Certificated Salaries 10,857,377 11,141,507 11,502,548 11,913,087 12,235,052
Classified Salaries 3,070,141 3,195,178 3,218,781 3,250,746 3,329,622
Employee benefits 3,160,613 3,529,406 3,932,007 4,203,445 4,379,066
Books and supplies 1,238,389 1,354,048 1,416,686 1,475,784 1,522,856
Services and other operating expenses 3,065,460 3,577,417 3,719,482 3,855,011 3,957,714
Base Rent Payments 2,805,844 2,114,167 2,112,598 2,344,718 3,038,861
Depreciation 235,516 216,392 198,197
171,014 115,810
NSD Funding 2,606,566 3,051,616 3,161,154 3,310,354 3,419,193
Total Expenses 27,039,906 28,179,731 29,261,452 30,524,158 31,998,175
CHANGE IN NET ASSETS 577,328$ 3,354,510$ 2,705,089$ 2,880,867$ 2,515,576$
Add Back: Base Rent Payments
2,805,844 2,114,167 2,112,598 2,344,718 3,038,861
Add Bak: Depreciation
235,516 216,392 198,197 171,014 115,810
Net Operating Revenues Available 3,618,687$ 5,685,069$ 5,015,884$ 5,396,599$ 5,670,248$
Base Rent Coverage 1.29 2.69 2.37 2.30 1.87
Projected Ending Cash Balance 5,869,905$ 7,883,882$ 9,283,033$ 10,750,692$ 11,743,691$
Days Cash On Hand 79.9 102.9 116.6 129.3 134.4