[PPT] - NEW HAVEN UNIFIED SCHOOL DISTRICT 2019/20 First Interim Report PowerPoint Presentation

SLIDE 1

1

NEW HAVEN UNIFIED

SCHOOL DISTRICT

2019/20 First Interim Report

Business Services Division December 10, 2019

SLIDE 2

2

Overview

Education Code section 42130:

“The superintendent of each school district shall, in addition to any other powers and

duties granted to or imposed upon him or her, submit two reports to the governing board of the district during each fiscal year. The first report shall cover the financial and budgetary status of the district for the period ending October 31. The second report shall cover the period ending January 31. Both reports shall be approved by the district governing board no later than 45 days after the close of the period being

reported. All reports required by this subdivision shall be in a format or on forms

prescribed by the Superintendent of Public Instruction, and shall be based on standards and criteria for fiscal stability adopted by the State Board of Education pursuant to Section 33127. The reports, and supporting data, shall be maintained and made available by the school district for public review.”

SLIDE 3

3

Budget Cycle: 2019/20

Budget Adoption June 18, 2019 45 Day Budget [August 20, 2019]

First Interim

[December 10, 2019]

Second Interim

[March 10, 2020] Estimated Actuals

[June 16, 2020] Unaudited Actuals [September, 2020]

SLIDE 4

4

PLANNING FACTORS USED

Fiscal Year Planning Factor 2019/20 2020/21 2021/22 COLA (Department of Finance - DOF) 3.26% 3.00% 2.80% STRS Employer Rates 17.10% 18.40% 18.10% PERS Employer Rates 19.721% 22.70% 24.60% Lottery - Unrestricted per ADA $153 $153 $153 Lottery - Prop 20 per ADA $54 $54 $54 Mandate Block Grant per ADA - K-8 $32.18 $33.15 $34.08 Mandate Block Grant per ADA - 9-12 $61.94 $63.80 $65.59

SLIDE 5

5

LOCAL CONTROL FORMULA (LCFF) REVENUE ASSUMPTIONS

LCFF Revenue Assumptions 2019/20 Adopted Budget 2019/20 First Interim Budget Enrollment 10,962 11,008 Average Daily Attendance (Funded) 10,767.23 10,780.63 COLA 3.26% 3.26% Unduplicated Pupil % 53.31% 53.39%

SLIDE 6

6

LOCAL CONTROL FUNDING FORMULA (LCFF)

LCFF REVENUE CALCULATION: 2019/20 COLA 3.26% Unduplicated pupil count as % of Enrollment 53.39% ADA Projection Base Grade Span Supplemental Concentration TARGET Grades TK‐3 3,083.16 $7,702 $801 $908 $0 $29,015,466 Grades 4‐6 2,292.09 $7,818 $835 $0 $19,833,010 Grades 7‐8 1,694.39 $8,050 $860 $0 $15,096,302 Grades 9‐12 3,710.99 $9,329 $243 $1,022 $0 $39,314,592.33 TOTAL ADA 10,780.63 TOTAL FUNDING $89,925,723 $3,371,382 $9,962,265 $0 $103,259,370 Add on: Targeted Instructional Improvement $220,053 Add on: Transportation $301,115 LCFF FUNDING LEVEL $103,780,538

SLIDE 7

7

Object Code

DESCRIPTION

Range

A. REVENUES:

Unrestricted Restricted Total Unrestricted Restricted Total Unrestricted Restricted Total Unrestricted Restricted Total 1) LCFF / Local Taxes

8000-8099

103,637,722 $ 638,527 $ 104,276,249 $ 103,780,538 $ 644,295 $ 104,424,833 $ 104,100,297 $ 654,295 $ 104,754,592 $ 103,898,763 $ 664,295 $ 104,563,058 $ 2) Federal Revenue

8100-8299

$

5,433,764 $ 5,433,764 $ 788,949 $ 6,369,800 $ 7,158,749 $

$

5,650,618 $ 5,650,618 $

$

5,400,618 $ 5,400,618 $ 3) Other State Revenue

8300-8599

2,136,753 $ 6,461,592 $ 8,598,345 $ 3,069,748 $ 8,882,618 $ 11,952,366 $ 2,158,621 $ 8,862,618 $ 11,021,239 $ 2,143,621 $ 8,842,618 $ 10,986,239 $ 4) Other Local Revenue

8600-8799

1,413,100 $ 6,748,990 $ 8,162,090 $ 1,573,945 $ 6,943,429 $ 8,517,374 $ 934,365 $ 6,953,429 $ 7,887,794 $ 884,365 $ 6,963,429 $ 7,847,794 $ 5) TOTAL REVENUES 107,187,575 $ 19,282,873 $ 126,470,448 $ 109,213,180 $ 22,840,142 $ 132,053,322 $ 107,193,283 $ 22,120,960 $ 129,314,243 $ 106,926,749 $ 21,870,960 $ 128,797,709 $

B. EXPENDITURES:

1) Certificated Wages

1000-1999

50,543,465 $ 12,372,396 $ 62,915,861 $ 52,096,012 $ 12,337,151 $ 64,433,163 $ 51,652,954 $ 12,490,433 $ 64,143,387 $ 51,204,169 $ 12,645,624 $ 63,849,793 $ 2) Classified Wages

2000-2999

9,433,105 $ 7,307,670 $ 16,740,775 $ 9,856,722 $ 7,832,589 $ 17,689,311 $ 9,965,880 $ 7,914,531 $ 17,880,411 $ 10,088,604 $ 8,012,159 $ 18,100,764 $ 3) Employee Benefits

3000-3999

18,375,681 $ 13,328,775 $ 31,704,456 $ 19,026,039 $ 15,485,495 $ 34,511,534 $ 19,943,552 $ 15,950,645 $ 35,894,197 $ 19,934,080 $ 16,137,907 $ 36,071,986 $ 4) Books & Supplies

4000-4999

891,705 $ 1,718,775 $ 2,610,480 $ 952,892 $ 2,798,825 $ 3,751,717 $ 952,892 $ 2,179,013 $ 3,131,905 $ 952,892 $ 2,379,013 $ 3,331,905 $ 5) Services & Other Operating Expenses

5000-5999

8,118,894 $ 5,001,075 $ 13,119,969 $ 7,552,913 $ 5,461,182 $ 13,014,095 $ 7,557,913 $ 5,961,182 $ 13,519,095 $ 7,558,402 $ 6,461,182 $ 14,019,584 $ 6) Capital Outlay

6000-6999

$
$
$
$

111,765 $ 111,765 $

$
$
$
$
$
$

7)Other Outgo

7100-7299

1,318,144 $

$

1,318,144 $ 1,318,144 $

$

1,318,144 $ 1,318,144 $

$

1,318,144 $ 1,318,144 $

$

1,318,144 $ 8) Indirect Cost

7300-7399

(1,820,290.00) $ 1,564,106 $ (256,184) $ (1,905,034.00) $ 1,653,201 $ (251,833) $ (2,031,665.14) $ 1,779,832 $ (251,833) $ (2,077,268.41) $ 1,825,435 $ (251,833) $ 9) TOTAL EXPENDITURES 86,860,704 $ 41,292,797 $ 128,153,501 $ 88,897,688 $ 45,680,208 $ 134,577,896 $ 89,359,670 $ 46,275,636 $ 135,635,305 $ 88,979,022 $ 47,461,321 $ 136,440,343 $

C. EXCESS (DEFICIENCY) OF

20,326,871 $ (22,009,924) $ (1,683,053) $ 20,315,492 $ (22,840,066) $ (2,524,574) $ 17,833,613 $ (24,154,676) $ (6,321,062) $ 17,947,727 $ (25,590,361) $ (7,642,634) $ REVENUES OVER EXPENSES BEFORE OTHER SOURCES/USES (A5 - B9)

D. OTHER FINANCING SOURCES:

1) Interfund Transfers a) Interfund Transfers In

8910-8929

80,000 $ 80,000 $ 80,000 $

$

80,000 $ 80,000 $

$

80,000 $ 80,000 $

$

80,000 $ b) Interfund Transfers Out

7610-7629

(1,200,000) $ (1,200,000) $ (11,000,000) $

$

(11,000,000) $ (1,200,000) $

$

(1,200,000) $ (1,200,000) $

$

(1,200,000) $ 2) Other Sources/Uses

$

a) Other Sources

8930-8979

$
$
$
$
$
$
$
$
$
$

b) Other Uses

7630-7699

$
$
$
$
$
$
$
$
$
$

3) Contributions

8980-8999

(22,025,653) $ 22,025,653 $

$

(22,504,901) $ 22,504,901 $

$

(24,036,623) $ 24,036,623 $

$

(25,560,774) $ 25,560,774 $

$

4) TOTAL OTHER SOURCES/USES (23,145,653) $ 22,025,653 $ (1,120,000) $ (33,424,901) $ 22,504,901 $ (10,920,000) $ (25,156,623) $ 24,036,623 $ (1,120,000) $ (26,680,774) $ 25,560,774 $ (1,120,000) $

E. NET INCREASE (DECREASE)

IN FUND BALANCE (C + D4) (2,818,782) $ 15,729 $ (2,803,053) $ (13,109,409) $ (335,165) $ (13,444,574) $ (7,323,010) $ (118,052) $ (7,441,062) $ (8,733,048) $ (29,586) $ (8,762,634) $

F. FUND BALANCE, RESERVES

1) Beginning Fund Balance a) As of July 1 - Unaudited 22,641,675 $ 4,047,345 $ 26,689,020 $ 27,311,677 $ 4,541,120 $ 31,852,797 $ 14,202,268 $ 4,205,955 $ 18,408,223 $ 6,879,258 $ 4,087,903 $ 10,967,161 $ b) Audit Adjustments

$
$
$
$
$
$
$
$
$
$
$

c) As of July 1 - Audited (F1a + F1b) 22,641,675 $ 4,047,345 $ 26,689,020 $ 27,311,677 $ 4,541,120 $ 31,852,797 $ 14,202,268 $ 4,205,955 $ 18,408,223 $ 6,879,258 $ 4,087,903 $ 10,967,161 $ d) Other Restatements e) Adjusted Beginning Balance (F1c + F1d) 22,641,675 $ 4,047,345 $ 26,689,020 $ 27,311,677 $ 4,541,120 $ 31,852,797 $ 14,202,268 $ 4,205,955 $ 18,408,223 $ 6,879,258 $ 4,087,903 $ 10,967,161 $ 2) Ending Balance, June 30 (E + F1e) 19,822,893 $ 4,063,074 $ 23,885,967 $ 14,202,268 $ 4,205,955 $ 18,408,223 $ 6,879,258 $ 4,087,903 $ 10,967,161 $ (1,853,790) $ 4,058,316 $ 2,204,527 $ COMPONENTS OF ENDING FD BAL a) Nonspendable Revolving Cash

9711

48,000 $

$

48,000 $ 48,000 $

$

48,000 $ 48,000 $

$

48,000 $ 48,000 $

$

48,000 $ Stores

9712

$
$
$
$
$
$
$
$
$
$
$

Prepaid Expenditures

9713

$
$
$
$
$
$
$
$
$
$
$

All Others

9719

$
$
$
$
$
$
$
$
$
$

b) Restricted

9740

4,063,074 $ 4,063,074 $

$

4,205,955 $ 4,205,955 $

$

4,087,903 $ 4,087,903 $

$

4,058,316 $ 4,058,316 $ c) Committed

9750-9760

9,054,745 $ 9,054,745 $

$
$
$
$
$
$
$
$
$

d) Assigned - District Initiatives

9780

$
$

6,000,000 $

$

6,000,000 $ 2,000,000 $

$

2,000,000 $ 2,000,000 $

$

2,000,000 $ d) Assigned - Offset to Revenue loss/rising costs

9780

3,730,931 $ 3,730,931 $ 726,199 $ 726,199 $

$
$

d) Assigned - NHAA Prorate share Prof. Growth

9780

34,000 $

$
$
$
$
$
$

d) Assigned - Mandarin Dual Immersion Program

9780

350,000 $ 350,000 $ e) Unassigned/Unappropriated For Economic Uncertainties

9789

3,880,605 $ 3,880,605 $ 4,073,337 $

$

4,073,337 $ 4,105,059 $

$

4,105,059 $ 4,129,210 $

$

4,129,210 $ Unassigned/Unappropriated Amount

9790

6,805,543 $

$

6,839,543 $ $

$

$ (0) $

$

(0) $ (8,031,000) $

$

(8,031,000) $ New Haven Unified School District General Fund 2019/20 First Interim Financials and Projections for 2020/21 and 2021/22

TOTAL GENERAL FUND

Adopted Budget First Interim Budget Projection Budget Projection [Includes $3.5 million reductions] [No Reductuctions] 2019/20 2019/20 2020/21 [No Reductions] 2021/22

2019/20: $3.5 million reductions  2020/21: No reductions 2021/22: No reductions

NO REDUCTIONS

SLIDE 8

8

Unrestricted Budget: Three Year Projections

2018‐19 2019‐20 2020‐21 2021‐22 Money Received 109,213,180 107,193,283 106,926,749 Money Spent Transferred Out (Cabello Proceeds to Fund 17) 112,522,589 9,800,000 122,322,589 114,516,293 115,659,796 Surplus/Deficit (13,109,409) (7,323,010) (8,733,048) Previous Year Ending Balance $27,311,677 $14,202,268 $6,879,258 Ending Balance Unavailable Assigned Available = $27,311,677 (12,803,450) (14,508,226) $14,202,268 (4,121,337) (10,080,931) $6,879,258 (4,153,059) (2,726,199) ($1,853,789) (4,177,210) (2,000,000) (8,031,000) NO REDUCTIONS

SLIDE 9

9

Object Code

DESCRIPTION

Range

A. REVENUES:

Unrestricted Restricted Total Unrestricted Restricted Total Unrestricted Restricted Total Unrestricted Restricted Total 1) LCFF / Local Taxes

8000-8099

103,637,722 $ 638,527 $ 104,276,249 $ 103,780,538 $ 644,295 $ 104,424,833 $ 104,100,297 $ 654,295 $ 104,754,592 $ 103,898,763 $ 664,295 $ 104,563,058 $ 2) Federal Revenue

8100-8299

$

5,433,764 $ 5,433,764 $ 788,949 $ 6,369,800 $ 7,158,749 $

$

5,650,618 $ 5,650,618 $

$

5,400,618 $ 5,400,618 $ 3) Other State Revenue

8300-8599

2,136,753 $ 6,461,592 $ 8,598,345 $ 3,069,748 $ 8,882,618 $ 11,952,366 $ 2,158,621 $ 8,862,618 $ 11,021,239 $ 2,143,621 $ 8,842,618 $ 10,986,239 $ 4) Other Local Revenue

8600-8799

1,413,100 $ 6,748,990 $ 8,162,090 $ 1,573,945 $ 6,943,429 $ 8,517,374 $ 934,365 $ 6,953,429 $ 7,887,794 $ 884,365 $ 6,963,429 $ 7,847,794 $ 5) TOTAL REVENUES 107,187,575 $ 19,282,873 $ 126,470,448 $ 109,213,180 $ 22,840,142 $ 132,053,322 $ 107,193,283 $ 22,120,960 $ 129,314,243 $ 106,926,749 $ 21,870,960 $ 128,797,709 $

B. EXPENDITURES:

1) Certificated Wages

1000-1999

50,543,465 $ 12,372,396 $ 62,915,861 $ 52,096,012 $ 12,337,151 $ 64,433,163 $ 51,652,954 $ 12,490,433 $ 64,143,387 $ 51,204,169 $ 12,645,624 $ 63,849,793 $ 2) Classified Wages

2000-2999

9,433,105 $ 7,307,670 $ 16,740,775 $ 9,856,722 $ 7,832,589 $ 17,689,311 $ 9,965,880 $ 7,914,531 $ 17,880,411 $ 10,088,604 $ 8,012,159 $ 18,100,764 $ 3) Employee Benefits

3000-3999

18,375,681 $ 13,328,775 $ 31,704,456 $ 19,026,039 $ 15,485,495 $ 34,511,534 $ 19,943,552 $ 15,950,645 $ 35,894,197 $ 19,934,080 $ 16,137,907 $ 36,071,986 $ 4) Books & Supplies

4000-4999

891,705 $ 1,718,775 $ 2,610,480 $ 952,892 $ 2,798,825 $ 3,751,717 $ 952,892 $ 2,179,013 $ 3,131,905 $ 952,892 $ 2,379,013 $ 3,331,905 $ 5) Services & Other Operating Expenses

5000-5999

8,118,894 $ 5,001,075 $ 13,119,969 $ 7,552,913 $ 5,461,182 $ 13,014,095 $ 4,957,913 $ 5,961,182 $ 10,919,095 $ 2,508,402 $ 6,461,182 $ 8,969,584 $ 6) Capital Outlay

6000-6999

$
$
$
$

111,765 $ 111,765 $

$
$
$
$
$
$

7)Other Outgo

7100-7299

1,318,144 $

$

1,318,144 $ 1,318,144 $

$

1,318,144 $ 1,318,144 $

$

1,318,144 $ 1,318,144 $

$

1,318,144 $ 8) Indirect Cost

7300-7399

(1,820,290.00) $ 1,564,106 $ (256,184) $ (1,905,034.00) $ 1,653,201 $ (251,833) $ (2,031,665.14) $ 1,779,832 $ (251,833) $ (2,077,268.41) $ 1,825,435 $ (251,833) $ 9) TOTAL EXPENDITURES 86,860,704 $ 41,292,797 $ 128,153,501 $ 88,897,688 $ 45,680,208 $ 134,577,896 $ 86,759,670 $ 46,275,636 $ 133,035,305 $ 83,929,022 $ 47,461,321 $ 131,390,343 $

C. EXCESS (DEFICIENCY) OF

20,326,871 $ (22,009,924) $ (1,683,053) $ 20,315,492 $ (22,840,066) $ (2,524,574) $ 20,433,613 $ (24,154,676) $ (3,721,062) $ 22,997,727 $ (25,590,361) $ (2,592,634) $ REVENUES OVER EXPENSES BEFORE OTHER SOURCES/USES (A5 - B9)

D. OTHER FINANCING SOURCES:

1) Interfund Transfers a) Interfund Transfers In

8910-8929

80,000 $ 80,000 $ 80,000 $

$

80,000 $ 80,000 $

$

80,000 $ 80,000 $

$

80,000 $ b) Interfund Transfers Out

7610-7629

(1,200,000) $ (1,200,000) $ (11,000,000) $

$

(11,000,000) $ (1,200,000) $

$

(1,200,000) $ (1,200,000) $

$

(1,200,000) $ 2) Other Sources/Uses

$

a) Other Sources

8930-8979

$
$
$
$
$
$
$
$
$
$

b) Other Uses

7630-7699

$
$
$
$
$
$
$
$
$
$

3) Contributions

8980-8999

(22,025,653) $ 22,025,653 $

$

(22,504,901) $ 22,504,901 $

$

(23,958,623) $ 23,958,623 $

$

(25,409,274) $ 25,409,274 $

$

4) TOTAL OTHER SOURCES/USES (23,145,653) $ 22,025,653 $ (1,120,000) $ (33,424,901) $ 22,504,901 $ (10,920,000) $ (25,078,623) $ 23,958,623 $ (1,120,000) $ (26,529,274) $ 25,409,274 $ (1,120,000) $

E. NET INCREASE (DECREASE)

IN FUND BALANCE (C + D4) (2,818,782) $ 15,729 $ (2,803,053) $ (13,109,409) $ (335,165) $ (13,444,574) $ (4,645,010) $ (196,052) $ (4,841,062) $ (3,531,548) $ (181,086) $ (3,712,634) $

F. FUND BALANCE, RESERVES

1) Beginning Fund Balance a) As of July 1 - Unaudited 22,641,675 $ 4,047,345 $ 26,689,020 $ 27,311,677 $ 4,541,120 $ 31,852,797 $ 14,202,268 $ 4,205,955 $ 18,408,223 $ 9,557,258 $ 4,009,903 $ 13,567,161 $ b) Audit Adjustments

$
$
$
$
$
$
$
$
$
$
$

c) As of July 1 - Audited (F1a + F1b) 22,641,675 $ 4,047,345 $ 26,689,020 $ 27,311,677 $ 4,541,120 $ 31,852,797 $ 14,202,268 $ 4,205,955 $ 18,408,223 $ 9,557,258 $ 4,009,903 $ 13,567,161 $ d) Other Restatements e) Adjusted Beginning Balance (F1c + F1d) 22,641,675 $ 4,047,345 $ 26,689,020 $ 27,311,677 $ 4,541,120 $ 31,852,797 $ 14,202,268 $ 4,205,955 $ 18,408,223 $ 9,557,258 $ 4,009,903 $ 13,567,161 $ 2) Ending Balance, June 30 (E + F1e) 19,822,893 $ 4,063,074 $ 23,885,967 $ 14,202,268 $ 4,205,955 $ 18,408,223 $ 9,557,258 $ 4,009,903 $ 13,567,161 $ 6,025,710 $ 3,828,816 $ 9,854,527 $ COMPONENTS OF ENDING FD BAL a) Nonspendable Revolving Cash

9711

48,000 $

$

48,000 $ 48,000 $

$

48,000 $ 48,000 $

$

48,000 $ 48,000 $

$

48,000 $ Stores

9712

$
$
$
$
$
$
$
$
$
$
$

Prepaid Expenditures

9713

$
$
$
$
$
$
$
$
$
$
$

All Others

9719

$
$
$
$
$
$
$
$
$
$

b) Restricted

9740

4,063,074 $ 4,063,074 $

$

4,205,955 $ 4,205,955 $

$

4,009,903 $ 4,009,903 $

$

3,828,816 $ 3,828,816 $ c) Committed

9750-9760

9,054,745 $ 9,054,745 $

$
$
$
$
$
$
$
$
$

d) Assigned - District Initiatives

9780

$
$

6,000,000 $

$

6,000,000 $ 2,000,000 $

$

2,000,000 $ 2,000,000 $

$

2,000,000 $ d) Assigned - Offset to Revenue loss/rising costs

9780

3,730,931 $ 3,730,931 $ 3,482,199 $ 3,482,199 $

$
$

d) Assigned - NHAA Prorate share Prof. Growth

9780

34,000 $

$
$
$
$
$
$

d) Assigned - Mandarin Dual Immersion Program

9780

350,000 $ 350,000 $ e) Unassigned/Unappropriated For Economic Uncertainties

9789

3,880,605 $ 3,880,605 $ 4,073,337 $

$

4,073,337 $ 4,027,059 $

$

4,027,059 $ 3,977,710 $

$

3,977,710 $ Unassigned/Unappropriated Amount

9790

6,805,543 $

$

6,839,543 $ $

$

$ (0) $

$

(0) $ $

$

$ New Haven Unified School District General Fund 2019/20 First Interim Financials and Projections for 2020/21 and 2021/22

TOTAL GENERAL FUND

Adopted Budget First Interim Budget Projection Budget Projection [Includes $3.5 million reductions] [Includes $2.6 million reductions] 2019/20 2019/20 2020/21 [Includes $2.5 million reductions] 2021/22

2019/20: $3.5 million reductions  2020/21: $2.6 million reductions 2021/22: $2.5 million reductions

WITH REDUCTIONS

SLIDE 10

10

Unrestricted Budget: 3-Year Projection W/Cuts

2018‐19 2019‐20 2020‐21 2021‐22 Money Received 109,213,180 107,193,283 106,926,749 Money Spent Transferred Out (Cabello Proceeds to Fund 17) 2020/21 Ongoing Reductions 2021/22 Ongoing Reductions 112,522,589 9,800,000 122,322,589 114,438,293 (2,600,000) 111,838,293 112,908,296 (2,450,000) 110,458,296 Surplus/Deficit (13,109,409) (4,645,010) (3,531,548) Previous Year Ending Balance $27,311,677 $14,202,268 $9,557,258 Ending Balance Unavailable Assigned Available = $27,311,677 (12,803,450) (14,508,226) $14,202,268 (4,121,337) (10,080,931) $9,557,258 (4,075,059) (5,482,199) $6,025,710 (4,025,710) (2,000,000) WITH REDUCTIONS

SLIDE 11

11

Next Steps

 District Adoption of 2019/20 Budget – June 18, 2019  State Enactment of 2019/20 Budget – June 27, 2019  Unaudited Actuals Report 2018/19 – September 3, 2019  September Payroll – September 30, 2019  CALPADS – October 2, 2019

2019/20 First Interim Budget Update – December 10, 2019
2018/19 Audited Financial Report – January 21, 2020
2019/20 Second Interim Budget Update – March 10, 2020