Year-to-Date Summary $30M 4% $15M 2% April 2019 Financial Report - - PDF document

year to date summary
SMART_READER_LITE
LIVE PREVIEW

Year-to-Date Summary $30M 4% $15M 2% April 2019 Financial Report - - PDF document

FAC PRESENTATION MAY 15, 2019 5/13/2019 Columbus City Schools MONTHLY FINANCIAL REPORT For the month ending April 30, 2019 FINANCE AND APPROPRIATIONS COMMITTEE REVIEW May 15, 2019 PRESENTED TO THE BOARD OF EDUCATION May 21, 2019


slide-1
SLIDE 1

FAC PRESENTATION MAY 15, 2019 5/13/2019 1

Columbus City Schools MONTHLY FINANCIAL REPORT

For the month ending April 30, 2019

FINANCE AND APPROPRIATIONS COMMITTEE REVIEW May 15, 2019 PRESENTED TO THE BOARD OF EDUCATION May 21, 2019

Year-to-Date Summary

$30M 4% $15M 2%

April 2019 Financial Report

slide-2
SLIDE 2

FAC PRESENTATION MAY 15, 2019 5/13/2019 2

Financial Highlights

  • Revenue

– Property Tax Allocation

  • Last month variance resolved as expected

– Other Revenues

  • PILOTS +14.2M YTD to plan
  • Expenditures

– Personnel $11.1M under plan YTD ~ 2.3% – Charter schools line beginning to run under plan

April 2019 Financial Report

Revenues Year-To-Date

April 2019 Financial Report

slide-3
SLIDE 3

FAC PRESENTATION MAY 15, 2019 5/13/2019 3

Other Revenues Year-To-Date

April 2019 Financial Report

Revenues Year-To-Date

April 2019 Financial Report

slide-4
SLIDE 4

FAC PRESENTATION MAY 15, 2019 5/13/2019 4

Revenues Year-To-Date

April 2019 Financial Report

Expenditures Year-To-Date

April 2019 Financial Report

slide-5
SLIDE 5

FAC PRESENTATION MAY 15, 2019 5/13/2019 5

April 2019 Financial Report

Expenditures Year-To-Date

April 2019 Financial Report

slide-6
SLIDE 6

FAC PRESENTATION MAY 15, 2019 5/13/2019 6

Expenditures Year-To-Date

April 2019 Financial Report

Expenditures Year-To-Date

April 2019 Financial Report

slide-7
SLIDE 7

FAC PRESENTATION MAY 15, 2019 5/13/2019 7

Expenditures Year-To-Date

WITHOUT CHARTER

April 2019 Financial Report

VARIANCE ANALYSIS − REVENUES

April 2019 Financial Report

slide-8
SLIDE 8

FAC PRESENTATION MAY 15, 2019 5/13/2019 8

April 2019 Financial Report

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 Low High 3.5% All Other Revenues High High 1.9% Other Financing Sources Low Low 1.5%

April 2019 Financial Report

slide-9
SLIDE 9

FAC PRESENTATION MAY 15, 2019 5/13/2019 9

Other Revenues

  • +$14.5 million PILOTS
  • +$5.6 million Investment Income
  • +$3.7 million Medicaid reimbursement

April 2019 Financial Report

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 $16.2 $4.4 $2.0 REVENUE SHARING $1.8 $3.6 $0.0 $2.1 $1.5 $1.6 $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.8 $10.3 $6.1

April 2019 Financial Report

slide-10
SLIDE 10

FAC PRESENTATION MAY 15, 2019 5/13/2019 10

VARIANCE ANALYSIS − EXPENDITURES

April 2019 Financial Report April 2019 Financial Report

slide-11
SLIDE 11

FAC PRESENTATION MAY 15, 2019 5/13/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 High 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%

April 2019 Financial Report

Year-to-Date Summary

$30M 4% $15M 2%

April 2019 Financial Report