columbus city schools monthly financial summary report · jul aug sep oct nov dec jan feb 0.6...

COLUMBUS CITY SCHOOLS

Monthly Financial Summary ReportGeneral Fund and related debt service

– February 2016 (FY2015-16)

Columbus Board of Education Meeting

March 15, 2016

2

3

SummaryYTD February 2016 (FY16)

03/15/2016

FYF LN Prior YearCurrent Year Estimate

Current Year Actual

2.080 Total Revenues and Other Financing Sources $ 575,909,661 $ 615,041,686 $ 605,239,724

5.050 Total Expenditures and Other Financing Uses $ 517,453,858 $ 552,290,133 $ 537,959,649

Beginning Cash Balance $ 120,198,371 $ 138,873,287 $ 138,873,287

Ending Cash Balance $ 178,654,174 $ 201,624,840 $ 206,153,362

4

RevenueYTD February 2016 (FY16)

03/15/2016


Current Year Actual

1.010 General Property Tax (Real Estate) $ 326,240,171 $ 369,000,000 $ 352,612,811

1.020 Tangible Personal Property $ 33,286 $ 19,000 $ 29,122 1.035 +

1.040

Unrestr. & Restr. State Grants‐in‐Aid $ 192,179,018 $ 195,423,954 $ 203,482,204

1.050 Property Tax Allocation $ 31,212,736 $ 26,917,474 $ 26,611,097 1.060 All Other Revenues $ 7,446,084 $ 6,784,000 $ 9,176,572 1.070 Total Revenues $ 557,111,295 $ 598,144,428 $ 591,911,807

Other Financing Sources2.040 Operating Transfers‐In $ 4,779,500 $ 3,981,258 $ 2,581,804 2.050 Advances‐In $ 11,707,139 $ 12,816,000 $ 10,388,454 2.060 All Other Financing Sources $ 2,311,728 $ 100,000 $ 357,658

2.070 Total Other Financing Sources $ 18,798,366 $ 16,897,258 $ 13,327,917

2.080 Total Revenues and Other Financing Sources $ 575,909,661 $ 615,041,686 $ 605,239,724

5

ExpendituresYTD February 2016 (FY16)

03/15/2016


Current Year Actual

3.010 +

3.020Personnel $ 362,974,727 $ 375,399,700 $ 369,935,562

3.030 Purchased Services $ 30,959,368 $ 36,669,930 $ 30,274,283

3.030 Charter Schools, STEM, Scholarship, etc. (478, 479) $ 92,437,782 $ 93,433,500 $ 107,939,228

3.040 Supplies and Materials $ 9,858,247 $ 21,486,500 $ 13,713,563 3.050 Capital Outlay $ 2,359,442 $ 4,333,778 $ 2,438,070 4.020 Principal‐Notes $ 3,280,000 $ 2,370,000 $ 2,370,000 4.055 Principal‐Other $ 657,665 $ 657,700 $ 657,665 4.060 Interest and Fiscal Charges $ 644,697 $ 616,625 $ 616,672 4.300 Other Objects $ 4,245,365 $ 4,637,000 $ 3,703,931 4.500 Total Expenditures $ 507,417,294 $ 539,604,733 $ 531,648,973 5.010 Operating Transfers‐Out $ 5,422,300 $ 5,250,000 $ 3,224,604 5.020 Advances‐Out $ 4,614,054 $ 7,431,400 $ 3,082,484 5.030 All Other Financing Uses $ 210 $ 4,000 $ 3,586 5.040 Total Other Financing Uses $ 10,036,564 $ 12,685,400 $ 6,310,675

5.050 Total Expenditures and Other Financing Uses $ 517,453,858 $ 552,290,133 $ 537,959,649

6

Variance SummaryYTD February 2016 (FY16)

03/15/2016

FYF LN Current Yr Over(Under) Estimate $ %

2.080 Total Revenues and Other Financing Sources $ (9,801,962) ‐1.6%

5.050 Total Expenditures and Other Financing Uses $ (14,330,484) ‐2.6%

Beginning Cash Balance $ ‐ 0.0%

Ending Cash Balance $ 4,528,522 2.2%

7

RevenuesYTD Variance from Plan Total Revenues, FY2015-16

03/15/2016

‐$30

‐$20

‐$10

$0

$10

$20

$30

JUL AUG SEP OCT NOV DEC JAN FEB

(1.6)

1.0

(26.9)

(4.2) (3.6) (3.7)

26.6

(9.8)

Millions

8

Revenue – VariancesYTD February 2016 (FY16)

03/15/2016

FYF LNCurrent Yr Over(Under)

Estimate $ %

1.010 General Property Tax (Real Estate) $ (16,387,189) ‐4.4%

1.020 Tangible Personal Property $ 10,122 53.3%1.035 +

1.040Unrestr. & Restr. State Grants‐in‐Aid $ 8,058,251 4.1%

1.050 Property Tax Allocation $ (306,377) ‐1.1%1.060 All Other Revenues $ 2,392,572 35.3%1.070 Total Revenues $ (6,232,621) ‐1.0%

Other Financing Sources2.040 Operating Transfers‐In $ (1,399,454) ‐35.2%2.050 Advances‐In $ (2,427,546) ‐18.9%2.060 All Other Financing Sources $ 257,658 257.7%

2.070 Total Other Financing Sources $ (3,569,341) ‐21.1%


9

RevenuesYTD Variance from Plan by Source, FY2015-16

03/15/2016

‐$30

‐$20

‐$10

$0

$10

$20

$30

$40


0.6‐5.9 ‐5.4 ‐4.7 ‐4.4 ‐3.6

23.0

‐14.0

‐1.4

7.6

‐19.4

2.6 3.0 3.4

7.3

7.8

‐0.8

‐0.8

‐2.2

‐2.2 ‐2.2 ‐3.5

‐3.6

‐3.6

Millions

Non‐operating

State

Local

10

Revenue – General Property TaxLine 1.010 – Monthly as of February, FY2015-16

03/15/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

11

Revenue – General Property TaxLine 1.010 – Accumulative thru February, FY2015-16

03/15/2016

$407.6

$406.1

$0

$50

$100

$150

$200

$250

$300

$350

$400

$450


Millions

PLAN

ACTUAL

12

Revenue – State FoundationLines 1.035 & 1.040 – Actual thru February / Projected thru June

FY2015-16

03/15/2016

$‐

$5

$10

$15

$20

$25

$30

$35


Millions

1.035 &1.040 Plan

1.035 &1.040Actual &Projected

13

Revenue – State FoundationLines 1.035 & 1.040 – Accumulated Actual thru February / Projected

thru June FY2015-16

03/15/2016

$293.1

$299.9

$‐

$50

$100

$150

$200

$250

$300

$350


Millions

1.035 &1.040 Plan

1.035 &1.040 Actual& Projected

14

Variance SummaryYTD February 2016 (FY16)

03/15/2016




Beginning Cash Balance $ ‐ 0.0%

Ending Cash Balance $ 4,528,522 2.2%

15

ExpendituresYTD Variance, FY2015-16

03/15/2016

‐$15

‐$10

‐$5

$0

$5

$10


$1.0 $0.4

$4.1

($11.8) ($12.3)

$8.1

($11.8)

($14.3)

Millions

Total Expenditures

16

Expenditures - VariancesYTD February 2016 (FY16)

03/15/2016


3.010 + 3.020 Personnel $ (5,464,138) ‐1.5%

3.030 Purchased Services $ (6,395,647) ‐17.4%

3.030 Charter Schools, STEM, Scholarship, etc. (478, 479) $ 14,505,728 15.5%

3.040 Supplies and Materials $ (7,772,937) ‐36.2%3.050 Capital Outlay $ (1,895,708) ‐43.7%4.020 Principal‐Notes $ ‐ 0.0%4.055 Principal‐Other $ (35) 0.0%4.060 Interest and Fiscal Charges $ 47 0.0%4.300 Other Objects $ (933,069) ‐20.1%4.500 Total Expenditures $ (7,955,760) ‐1.5%5.010 Operating Transfers‐Out $ (2,025,396) ‐38.6%5.020 Advances‐Out $ (4,348,916) ‐58.5%5.030 All Other Financing Uses $ (414) 0.0%5.040 Total Other Financing Uses $ (6,374,725) ‐50.3%


17

ExpendituresYTD Variance by Category, FY2015-16

03/15/2016

‐$15

‐$10

‐$5

$0

$5

$10

$15

$20


($5.3) ($5.5)

($2.5)($6.4)

($6.4)

Millions

Other Financing Uses

Non‐Personnel

Personnel

18

ExpendituresNon-Personnel (Operating) YTD Variance

FY2015-16

03/15/2016

Jan Feb ChangePurchased Services $ (5,679,991) $ (6,395,647) $ (715,656)

Charter Schools, STEM, Scholarship, etc. (478, 479) $ 11,941,858 $ 14,505,728 $ 2,563,870

Supplies and Materials $ (3,767,366) $ (7,772,937) $(4,005,572)

Capital Outlay $ (1,665,808) $ (1,895,708) $ (229,900)

Principal‐Notes $ ‐ $ ‐ $ ‐

Principal‐Other $ (35) $ (35) $ ‐

Interest and Fiscal Charges $ 47 $ 47 $ ‐

Other Objects $ (965,617) $ (933,069) $ 32,548

$ (136,912) $ (2,491,621) $(2,354,709)

19

Expenditures – Monthly DeductionsCharter Schools, STEM, Scholarship, etc. (478, 479)

03/15/2016ACTUAL | PROJECTED

$0.7 $0

$5

$10

$15

$20


Millions

FY16 PLAN

FY16 ACTUAL

YTD VARIANCEACTUAL VS PLAN

20

Annual AmountCharter Schools, STEM, Scholarship, etc. (478, 479)

03/15/2016

$MillionsAPPROPRIATION vs.

SFPR*

PLAN / APPROPRIATION $163.10 JUL #1 SFPR $160.20 $2.90 JUL #2 – AUG #1 SFPR $158.70 $4.40 AUG #2 – SEP #1 SFPR $159.50 $3.60 SEP #2 – DEC #1 SFPR $159.40 $3.70 DEC #2 – JAN #1 SFPR $159.60 $3.50 JAN #2 SFPR $163.40 ($0.30)FEB #1 SFPR $165.40 ($2.30)FEB #2 – MAR #1 SFPR $163.40 ($0.30) *School Foundation Payment Report

21

Monthly Expenditure FlowPlan/Actual thru February, FY2015-16

03/15/2016

$0

$10

$20

$30

$40

$50

$60

$70


Millions

Personnel‐Plan Non‐Personnel‐Plan

Personnel‐Actual Non‐Personnel‐Actual

22

YTD Expenditure FlowPlan/Actual thru February, FY2015-16

03/15/2016

$0

$100

$200

$300

$400

$500

$600


Millions

Personnel‐Plan Non‐Personnel‐Plan

Personnel‐Actual Non‐Personnel‐Actual

columbus city schools monthly financial summary report · jul aug sep oct nov dec jan feb 0.6...

Documents