1 of 9

Finance Committee - 2/2/24

Board of Directors - 2/7/24

LCPS Finance Report

2 of 9

2023-24 Timeline Overview

Month to Month - where we are headed!

2

First Semester

October

Board Meeting:

  • Dashboard Update
  • Finalized our Audit submissions on 9/27
  • Capital Expenses from Bond

Finance Committee:

  • Director final interviews

November

Finance Committee -

  • Budget Revision and 1st Interim preparation
  • Audit Committee (target date)
  • Preliminary teacher and staff compensation review for FY 24-25 SY

December

Board Meeting:

  • Dashboard Update
  • Bond Report
  • Audit approval
  • First Interim Approval
  • Preview teacher and staff compensation review for FY 24-25 for Board Feedback

Second Semester

January

Finance Committee -

  • Preliminary teacher and staff compensation review for FY 24-25 SY Continued
  • Budget Revision and 2nd Interim preparation
  • Preliminary FY 24-25 Budget

February

Board Meeting:

  • Dashboard Update
  • Approve teacher and staff compensation for FY 24-25 Budget
  • Enrollment Lottery Update
  • Preliminary FY 24-25 Budget for Board Feedback, including Special Education

March

Board Meeting:

  • Dashboard Update
  • Second Interim Approval

Finance Committee:

  • FY 24-25 Budget Continued

April / June

Board Meeting:

Finance Committee:

  • Finalize FY 24-25 Budget and LCAPs

3 of 9

2023-24 ADA Overview

Enrollment and Attendance

3

Key Metrics for ADA

Notes

Internal Dashboard

LCPS ADA (to date)

  • Enrollment (vs. Budgeted 1620) - 1567 (Dec report was 1587)
  • Attendance (vs. Budgeted 90%) - 90.8% (Dec report was 91.8)
  • ADA Budgeted (1620 x 90% = 1458); ADA to Date (1587 x 91.8% = 1422)

  • Loss of 20 students across LCPS from end of Oct
  • Added a few students for 2nd semester
  • 2 grade levels at L* under-enrolled (K and 9)

Elementary

  • Lighthouse - 310 students; 91.5% (Dec report was 314 students; 92.2%)
  • Lodestar - 289 students; 89.8% (Dec report was 283 students; 90.7%)

  • Kindergarten at Lodestar - 34 students (short 16-18)
  • All other grades 50+ per site

Middle Schools

  • Lighthouse - 231 students; 92.4 % (Dec report was 236 students; 93.2%)
  • Lodestar - 222 students; 92.4% (Dec report was 227 students; 94.1%)
  • Lodestar - hold enrollment due to ratio of SWD (despite interest)

High Schools

  • Lighthouse - 297 students; 90.2% (Dec report was 298; 90.9%)
  • Lodestar - 219 students; 88.8% (Dec report was 226; 90%)
  • 9th grade at Lodestar - 49 students (short 20 to 25)

L*

LH

L*

LH

L*

LH

4 of 9

Cash Flow vs. Bond Covenants

4

Notes:

  1. No major changes to Cash

5 of 9

Cash Flow vs. Bond Covenants

5

Key Metrics / Bond Covenant

Current (Nov, 2023)

Dashboard

Our Debt Coverage Ratio

  • This is defined as LCPS’s ability to cover our debt service
  • Our bond covenant sets this at 1.1

  • 1.83 debt coverage ratio

Our Days Cash on Hand

  • This is defined as our current cash divided by our operating expenses divided by 365 days; our daily cash rate is ~$98K
  • Our bond covenant sets our days cash at 45 days

  • 82 days of cash on hand projected for end of year

  • 88 days “hard” cash on hand today

  • Cash $8,823,246.68

Bond Covenant Days Cash (June 2024 Projections)

  • The bond covenant includes cash and 3 months of accounts receivables
  • 122 days Bond Covenant cash on hand

6 of 9

Budgeted vs Projected Revenue

Waterfall Chart

6

Notes:

These new grant revenues will be applied in 2nd Interim as we will need to budget for this year and subsequent years

  • Bi Partisan School Safety (state) received. $2.1M - will add $700K in federal revenue this SY
  • LCRSET Grant (Elementary literacy grant focused on schools with high UPP %) 500K thru 26-27 SY

Grants we have applied for / awaiting response FY 24-25.

  • OCAP: Oakland Community Action Partnership (County)
  • Golden State Pathway (State)
  • CTC Resident Teacher (State)
  • ASSETS and CCLC (State/Fed)

7 of 9

Budget to Date

By Revenues and Expenses (July - Dec; 2nd Q close)

7

Notes:

  • Strong second quarter close

  • Data used to plan for budget revision and second Interim

8 of 9

Budget to Date

Revenue and Expense variables

8

Expenses

Individual and Team Budgets:

  • High Substitute usage due to COVID and Vacancies in first 6 months. We should see a decline in Sub costs by end of year. Minimal “net / net” impact.
  • Budget analysis through December; adjustments as part of Budget Revise for March Board Meeting. Key areas to access and monitor: SPED, Operations and Tech, Contracted Services, Books and Supplies.
  • Note: We will be moving to a “pre-pay” model, as many expenditures in the second half of the year are for the upcoming school year.

Unbudgeted Expenses to monitor:

  • Substitute Teachers -
  • Legal

Revenues

ADA Off - Track: Drop of 1% on aggregate

  • Enrollment and Attendance have been challenging since the last board report (November thru January)
  • We have not “backfilled’ due to community challenges this year

New Grant:

  • BiPartisan Safety Grant - $700K this year; $2.1M total (will cover unbudgeted security costs
  • Literacy Grant - May start in 23-24 - $500K over 4 years
  • CTEIG - $75K - May start in 24-25

ERC:

  • Submitted our ERC application - for $2.5 to 2.7M after tax attorney fees

9 of 9

2023-24 Lottery and Enrollment

Applications to date

We had 432 applications at the end of January; last year we had 583 (Decline of 25%). Oakland Charters are seeing an overall decline in applications.

Current 1st, 2nd, and 3rd ranked applications