Year-to-Date Summary March 2019 $43M 5% $13M 2% 2 1 FAC - - PDF document

▶

Dec 05, 2023 406 likes •522 views

FAC PRESENTATION April 11, 2019 4/6/2019 Columbus City Schools MONTHLY FINANCIAL REPORT For the month ending March 31, 2019 PRESENTED TO THE BOARD OF EDUCATION April 16, 2019 FINANCE AND APPROPRIATIONS COMMITTEE REVIEW April 11, 2019 1

SLIDE 1

FAC PRESENTATION April 11, 2019 4/6/2019 1

Columbus City Schools MONTHLY FINANCIAL REPORT

For the month ending March 31, 2019

PRESENTED TO THE BOARD OF EDUCATION April 16, 2019 FINANCE AND APPROPRIATIONS COMMITTEE REVIEW April 11, 2019

Year-to-Date Summary – March 2019

$43M 5% $13M 2%

1 2

SLIDE 2

FAC PRESENTATION April 11, 2019 4/6/2019 2

March 2019 – Financial Highlights

Revenue

– Property Taxes

Last month variance resolved to 0.97% favorable (+$4.9M) as

expected

– Other Revenues

PILOTS +13M YTD to plan
Expenditures

– Personnel $10.2M under plan YTD ~ 2% – Purchased services $5.4M under plan YTD ~ 12%

Revenues Year-To-Date

through March 2019

3 4

SLIDE 3

FAC PRESENTATION April 11, 2019 4/6/2019 3

Other Revenues Year-To-Date

through March 2019

Revenues Year-To-Date

through March 2019

5 6

SLIDE 4

FAC PRESENTATION April 11, 2019 4/6/2019 4

Revenues Year-To-Date

through March 2019

Expenditures Year-To-Date

through March 2019

7 8

SLIDE 5

FAC PRESENTATION April 11, 2019 4/6/2019 5

Expenditures Year-To-Date

through March 2019

9 10

SLIDE 6

FAC PRESENTATION April 11, 2019 4/6/2019 6

Expenditures Year-To-Date

through March 2019

Expenditures Year-To-Date

through March 2019

11 12

SLIDE 7

FAC PRESENTATION April 11, 2019 4/6/2019 7

Expenditures Year-To-Date

through March 2019 – WITHOUT CHARTER

VARIANCE ANALYSIS − REVENUES

13 14

SLIDE 8

FAC PRESENTATION April 11, 2019 4/6/2019 8

Variances

“High”: Variance amount >= $5 million OR Variance percentage >= 5%

Source Variance amount Variance Percentage Percent of Total Est. Rev. Property Taxes Low Low 54.5% State Aid Low Low 38.5%

Restrict. Fed. Grants

Low Low 0.1% Property Tax Allocation High High 3.5% All Other Revenues High High 1.9% Other Financing Sources Low Low 1.5%

15 16

SLIDE 9

FAC PRESENTATION April 11, 2019 4/6/2019 9

Other Revenues

$22.5 million favorable variance YTD (February)

– $3.7 million Medicaid reimbursement – $13 million PILOTS – $5 million investment income

Other Revenues

$Millions 2014 2015 2016 2017 2018 2019 2014-18 Average FY19 Est. PILOTS $2.6 $1.2 $7.7 $5.1 $5.5 $14.9 $4.4 $2.0 REVENUE SHARING $1.8 $3.6 $0.0 $2.1 $1.5 $1.8 $1.8 $2.0 WIN-WIN $3.1 $4.9 $4.6 $4.7 $3.1 $0.0 $4.1 $2.1 TOTAL $7.4 $9.7 $12.3 $11.9 $10.1 $17.1 $10.3 $6.1

17 18

SLIDE 10

FAC PRESENTATION April 11, 2019 4/6/2019 10

VARIANCE ANALYSIS − EXPENDITURES

19 20

SLIDE 11

FAC PRESENTATION April 11, 2019 4/6/2019 11

Variances

“High”: Variance amount >= $5 million OR Variance percentage >= 5%

Source Variance amount Variance Percentage Percent of Total Budget Personnel High Low 65.6% Purchased Services High High 7.9% Charter Low Low 21.4% Supplies Low Low 2.2% Capital Outlay Low High 0.4% Debt Low Low 0.4% Other Objects Low Low 1.1% Other Uses Low High 0.9%

Year-to-Date Summary – March 2019

$43M 5% $13M 2%

21 22