COLUMBUS COLUMBUS CITY SCHOOLS CITY SCHOOLS Monthly Financial - - PDF document

1

COLUMBUS COLUMBUS CITY SCHOOLS CITY SCHOOLS Monthly Financial Summary R Monthly Financial Summary Report port

Gener General Fund l Fund and related and related debt service debt service

– January 2016 January 2016 (FY2015-16) (FY2015-16)

Columbus Board of Columbus Board of Education Education Mee Meeting ing Februar bruary 16, 2016 16, 2016

2

2

3

Summary

YTD January 2016 (FY16)

02/16/2016

FYF LN Prior Year Current Year Estimate Current Year Actual 2.080 Total Revenues and Other Financing Sources $ 435,557,302 $ 474,330,191 $ 500,979,708 5.050 Total Expenditures and Other Financing Uses $ 460,407,073 $ 488,960,092 $ 477,121,618 Beginning Cash Balance $ 120,198,371 $ 138,873,287 $ 138,873,287 Ending Cash Balance $ 95,348,600 $ 124,243,387 $ 162,731,378

4

Variance Summary

YTD January 2016 (FY16)

02/16/2016

FYF LN Current Yr Over(Under) Estimate $ % 2.080 Total Revenues and Other Financing Sources $ 26,649,517 5.6% 5.050 Total Expenditures and Other Financing Uses $ (11,838,474) ‐2.4% Beginning Cash Balance $ ‐ 0.0% Ending Cash Balance $ 38,487,991 31.0%

3

5

Revenues

YTD Variance from Plan Total Revenues, FY2015-16

02/16/2016

‐$30 ‐$20 ‐$10 $0 $10 $20 $30 JUL AUG SEP OCT NOV DEC JAN (1.6) 1.0 (26.9) (4.2) (3.6) (3.7) 26.6 Millions

6

Revenues

YTD Variance from Plan by Source, FY2015-16

02/16/2016

‐$30 ‐$20 ‐$10 $0 $10 $20 $30 $40 JUL AUG SEP OCT NOV DEC JAN

0.6 ‐5.9 ‐5.4 ‐4.7 ‐4.4 ‐3.6 23.0 ‐1.4 7.6 ‐19.4 2.6 3.0 3.4 7.3 ‐0.8 ‐0.8 ‐2.2 ‐2.2 ‐2.2 ‐3.5 ‐3.6

Millions

Non‐operating State Local

4

10

Revenue – General Property Tax

Line 1.010 – Monthly as of January, FY2015-16

02/16/2016

$0 $20 $40 $60 $80 $100 $120 $140 $160 JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN

Millions

PLAN ACTUAL

12

Revenue – State Foundation

Lines 1.035 & 1.040 – Monthly as of January, FY2015-16

02/16/2016

$24.4 $28.3 $‐ $5 $10 $15 $20 $25 $30 $35 JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN

Millions 1.035 & 1.040 Plan 1.035 & 1.040 Actual

5

13

Revenue – State Foundation

Changes in Monthly Payment Jan #1 vs. Jan #2

02/16/2016

JAN JAN #1 #1 JAN JAN #2 #2 STATE SUPPORT ANNUAL AMT ANNUAL AMT ANNUAL AMT CHANGE OPPORTUNITY GRANT 163,496,850 160,122,812

• 3,374,039

TARGETED ASSISTANCE 16,507,108 16,166,455

• 340,653

K-3 LITERACY FUNDING 4,202,701 4,115,971

• 86,730

ECON DISADVANTAGED 42,813,366 41,929,838

• 883,527

LEP 4,153,243 4,067,534

• 85,709

GIFTED EDUCATION 1,794,652 1,757,617

• 37,036

TRANSPORTATION 23,225,148 28,032,842 4,807,694 SPECIAL EDUCATION 37,992,753 37,992,753 CAREER TECH EDUCATION 1,930,262 1,930,262 TOTAL STATE FUNDING 296,116,082 296,116,082

Total Calculated State Foundation Funding = $385,391,344 CA CAPPED PPED

14

Revenue – State Foundation

Changes in Monthly Payment Jan #1 vs. Jan #2

02/16/2016

TRANSPORTATION

ANNUAL ANNUAL AMT AMT YTD YTD AFTER JAN #2 AFTER JAN #2 SHOULD SHOULD BE (7/12 OF BE (7/12 OF ANNUAL ANNUAL AMOUNT) AMOUNT) YTD AS O YTD AS OF THE THE JAN AN #1 #1 PMT PMT B/M PMT (11) B/M PMT (11)

28, 28,032,842 032,842 16, 16,352,491 352,491 12, 12,598,858 98,858 3,753, 3,753,633 33

6

15

Revenue – State Foundation

Changes in Monthly Payment Jan #1 vs. Jan #2

02/16/2016

STAT STATE SUPPO SUPPORT BAL PRIO BAL PRIOR TO R TO PMT PMT JAN #2 B/M PMT JAN #2 B/M PMT (11 (11) B/M B/M PMT PMT (JAN (JAN #1) #1) B/M B/M PMT PMT CHANGE CHANGE OPPOR PORTUNI UNITY TY GRAN GRANT 71,458 ,458,770 ,770 6,496,2 496,252 6,802,9 ,802,983

• 306,731

TA TARGETED RGETED ASSIS ASSISTANCE 7,192,7 192,720 653,88 ,884 684,85 ,852

• 30,96

0,968 K-3 K-3 LIT LITERA RACY FUND FUNDIN ING 1,839,5 839,508 167,22 ,228 175,11 ,113

• 7,885

,885 ECON ECON DISA DISADVAN ANTAGED 18,590 ,590,054 ,054 1,690,0 690,005 1,770,3 ,770,326

• 80,32

,321 LEP 1,720,9 ,720,936 156,44 ,449 164,24 ,240

• 7,792

,792 GI GIFTED EDUCAT EDUCATION 778, 778,708 70,792 70,792 74,159 74,159

• 3,367
• 3,367

TRANSPORTATION SPORTATION 15,433 5,433,984 ,984 3,753,6 753,633 966,02 ,026 2,787,6 787,607 SPEC SPECIAL EDUCAT IAL EDUCATION 17,389 17,389,538 538 1,580, 1,580,867 1,580, ,580,867 CAREER CAREER TECH TECH EDUCAT EDUCATION ON 884,70 ,703 80,428 ,428 80,428 ,428 TOT TOTAL STAT STATE FUND FUNDIN ING 135,28 5,288,92 8,921 14,649 4,649,537 ,537 12,298 ,298,993 ,993

2,350 2,350,5 ,544

BAL PRIO BAL PRIOR TO R TO PMT ÷ PMT ÷ 11 CATCH CATCH UP UP TO TO 7/12 t 7/12 ths 18

Expenditures

YTD Variance, FY2015-16

02/16/2016

‐$15 ‐$10 ‐$5 $0 $5 $10 JUL AUG SEP OCT NOV DEC JAN $1.0 $0.4 $4.1 ($11.8) ($12.3) $8.1 ($11.8) Millions Total Expenditures

7

19

Expenditures

YTD Variance by Category, FY2015-16

02/16/2016

‐$15 ‐$10 ‐$5 $0 $5 $10 $15 $20 JUL AUG SEP OCT NOV DEC JAN

‐$2.1 ‐$0.3 ‐$1.0 ‐$2.9 $16.2 ‐$5.3 $2.5 $7.4 ‐$3.7 ‐$2.0 ‐$1.7 ‐$0.1 $0.0 ‐$3.1 ‐$7.1 ‐$7.3 ‐$6.4 ‐$6.4

Millions

Other Financing Uses Non‐Personnel Personnel 20

Monthly Expenditure Flow

Plan/Actual thru January, FY2015-16

02/16/2016

$0 $10 $20 $30 $40 $50 $60 $70 JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN

Millions

Personnel‐Plan Non‐Personnel‐Plan Personnel‐Actual Non‐Personnel‐Actual

8

26

Expenditures – Monthly Deductions

Charter Schools, STEM, Scholarship, etc. (478, 479)

02/16/2016

$11.9

$0 $2 $4 $6 $8 $10 $12 $14 $16 $18 $20 JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN

Millions

FY16 PLAN FY16 ACTUAL YTD VARIANCE ACTUAL VS PLAN

27

Expenditures – Monthly Deductions

Charter Schools, STEM, Scholarship, etc. (478, 479)

02/16/2016

($5) $0 $5 $10 $15 $20 JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN

Millions

FY16 PLAN FY16 ACTUAL YTD VARIANCE ACTUAL VS PLAN

9

28

Expenditures – Monthly Deductions

Charter Schools, STEM, Scholarship, etc. (478, 479)

02/16/2016

($0.3) ($0.6) ($0.7) ($1.0) ($1.3) ($1.5) ($1.4)

($2) $0 $2 $4 $6 $8 $10 $12 $14 $16 JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN

Millions

FY16 PLAN‐ADJ FY16 ACTUAL YTD VARIANCE ACTUAL VS PLAN‐ ADJ

30

Annual Amount

Charter Schools, STEM, Scholarship, etc. (478, 479)

02/16/2016

$Millions

APPROPRIATION vs. SFPR

PLAN / APPROPRIATION $163.1 JUL #1 SFPR $160.2 $2.9 JUL #2 – AUG #1 SFPR $158.7 $4.4 AUG #2 – SEP #1 SFPR $159.5 $3.6 SEP #2 – Dec #1 SFPR $159.4 $3.7 Dec #2 – Jan #1 SFPR $159.6 $3.5 JAN #2 SFPR $163.4 ($0.3) FEB #1 SFPR $165.4 ($2.3)

10