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 Year-to-Date Summary $30M 4% $15M 2% April 2019 Financial Report 1

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

FAC PRESENTATION MAY 15, 2019 5/13/2019 Other Revenues Year-To-Date April 2019 Financial Report Revenues Year-To-Date April 2019 Financial Report 3

FAC PRESENTATION MAY 15, 2019 5/13/2019 Revenues Year-To-Date April 2019 Financial Report Expenditures Year-To-Date April 2019 Financial Report 4

FAC PRESENTATION MAY 15, 2019 5/13/2019 April 2019 Financial Report Expenditures Year-To-Date April 2019 Financial Report 5

FAC PRESENTATION MAY 15, 2019 5/13/2019 Expenditures Year-To-Date April 2019 Financial Report Expenditures Year-To-Date April 2019 Financial Report 6

FAC PRESENTATION MAY 15, 2019 5/13/2019 Expenditures Year-To-Date WITHOUT CHARTER April 2019 Financial Report VARIANCE ANALYSIS − REVENUES April 2019 Financial Report 7

FAC PRESENTATION MAY 15, 2019 5/13/2019 April 2019 Financial Report Variances Percent of Total Est. Source Variance amount Variance Percentage Rev. Property Taxes Low Low 54.5% State Aid Low Low 38.5% Restrict. Fed. Grants Low Low 0.1% Property Tax Low High 3.5% Allocation All Other Revenues High High 1.9% Other Financing Low Low 1.5% Sources “High”: Variance amount >= $5 million OR Variance percentage >= 5% April 2019 Financial Report 8

FAC PRESENTATION MAY 15, 2019 5/13/2019 Other Revenues • +$14.5 million PILOTS • +$5.6 million Investment Income • +$3.7 million Medicaid reimbursement April 2019 Financial Report Other Revenues 2014-18 FY19 $Millions 2014 2015 2016 2017 2018 2019 Average Est. PILOTS $2.6 $1.2 $7.7 $5.1 $5.5 $16.2 $4.4 $2.0 REVENUE $1.8 $3.6 $0.0 $2.1 $1.5 $1.6 $1.8 $2.0 SHARING 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 9

FAC PRESENTATION MAY 15, 2019 5/13/2019 VARIANCE ANALYSIS − EXPENDITURES April 2019 Financial Report April 2019 Financial Report 10

FAC PRESENTATION MAY 15, 2019 5/13/2019 Variances Percent of Total Source Variance amount Variance Percentage 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% “High”: Variance amount >= $5 million OR Variance percentage >= 5% April 2019 Financial Report Year-to-Date Summary $30M 4% $15M 2% April 2019 Financial Report 11