290 likes | 298 Views
This presentation provides an analysis of the fiscal health of Colorado school districts, focusing on ratios such as asset sufficiency, debt burden, operating reserve, operating margin, deficit fund balance, and change in fund balance. It identifies warning trends and factors that impacted six school districts. The report also includes appendices with ratio descriptions, district responses, and data for all school districts.
E N D
Fiscal Health Analysis of Colorado School Districts August 2011 Office of the State Auditor
Agenda for today’s presentation • Analysis and ratios • Roles of the OSA and CDE • Trends and evaluation of ratios • Factors that impacted 6 school districts
Background – Roles of OSA & CDE • 178 school districts in Colorado • Funding sources • Colorado Department of Education (CDE) • Oversight & monitoring of accreditation • Office of the State Auditor • Compliance with Local Government Audit Law • Authority to hold property taxes • Review of audit report
Background – Roles of OSA & CDE • Public School Transparency Act • CDE monitors through financial accreditation process • Development of Fiscal Health Analysis • Three year period to review • Focus on areas of highest risk – General Fund • Debt and changes in fund balance
Ratio 1: Asset Sufficiency Ratio • Are assets larger than liabilities? • Formula: General fund total assets General fund total liabilities • Warning trend: A consistent deficit in assets’ adequacy to meet obligations over the 3-year period.
Ratio 2: Debt Burden Ratio • Do annual revenues cover debt service payments? • Formula: Total governmental revenue of fund(s) paying debt Total governmental debt payments • Warning trend: Annual revenues consistently below the annual debt payment for each of the three years.
Ratio 3: Operating Reserve Ratio • How long will reserves last for future expenditures? • Formula: Fund balance of the general fund Total general fund expenditures (net transfers) • Warning trend: A reserve that covers less than 1 week of future expenditures, which is the equivalent of .0192, or 1/52, for each of the 3 years.
Ratio 4: Operating Margin Ratio • How much is added to reserves for every dollar generated in revenues? • Formula: General fund total revenue –(general fund total expenditures (net) General fund total revenues • Warning trend: A loss in reserves for each of the 3 years.
Ratio 5: Deficit Fund Balance Ratio • How much revenue does it take to cover a deficit fund balance? • Formula: Total (absolute value) deficit fund balance – positive fund balance of the general fund Total revenue in deficit fund balance(s) • Warning trend: The portion of annual revenue needed to cover the deficit fund balance is increasing over the 3-year period.
Ratio 6: Change in Fund Balance Ratio • Are reserves increasing or decreasing? • Formula: Current year fund balance of the general fund – prior year fund balance Prior year fund balance of the general fund • Warning trend: Consistent decreases in reserves.
Trend analysis • Purpose • Warning trends over three year period • 2008, 2009, 2010 • Limitations • Warning indicator in one year • Current budgetary actions
Warning Indicators • 26 school districts with one or more • 20 districts with one • 5 districts with two • 1 district with three
Warning Indicators • Warning indicators do not always mean there is a problem • Planned capital expenditures • Deliberate spending of reserves • However – the more warning indicators, the greater the risk • Identify potential problems early
Appendices • Appendix A • Ratio descriptions, calculations, benchmarks, warning indicators • Appendix B • Districts with two or more warning indicators • Comparison with prior year • District responses • Appendix C • Map • Appendix D • Data for all school districts
Districts with Two Warning Indicators • Otis R-3 (Washington County) • Ouray R-1 (Ouray County) • Jefferson County (Jefferson, Broomfield) • Buena Vista R-31 (Chaffee County) • La Veta RE-2 (Heurfano County)
Districts with Two Warning Indicators • Not necessarily a problem • Reasons centered around three themes • Various planned expenditures • Reductions in state school finance funding • Capital improvements • Plans to correct the situation • Budget cuts • Further spend down of fund balance • Apply for grants
Follow up from Prior Year • 19 districts identified with two in 2010 • Majority showed improvement • 13 districts had one last year – none this year • 3 districts decreased from two to one • Four districts with warning indicators in all three Fiscal Health Analysis reports • Hoehne • Platte Valley RE-3 • Pritchett RE-3 • Widefield 3
Follow up from Prior Year • Overall number of districts with warning indicators has declined • 2011 – 6 districts • 2010 – 19 districts • 2009 – 15 districts
District with Three Warning Indicators • Hoehne Reorganized 3 (Las Animas County) • Debt Burden • Operating Margin • Change in Fund Balance
Warning Indicators • Debt burden ratio • Decline in the ratios over the three year period • 2010 ratio less than one • Operating margin ratio • Decrease over the three year period • All three years less than zero • Decline in fund balance ratio • Decline in the ratios over the three year period • 2010 ending fund balance less than 2008 beginning fund balance.
Calculations for Hoehne • Debt burden ratio Revenue in funds making debt service payments Annual debt service payments $166,083 $185,400 • Ratio calculation: .90
Calculations for Hoehne • Operating margin ratio General fund total revenue –(general fund total expenditures (net) General fund total revenues
Calculations for Hoehne • Operating margin ratio General fund total revenue –(general fund total expenditures (net) General fund total revenues 3,692,252 – (3,823,548+135,000) 3,692,252 • Ratio calculation: (0.07)
Calculations for Hoehne • Change in fund balance ratio Current year fund bal of the general fund – prior year fund balance Prior year fund balance of the general fund
Calculations for Hoehne • Change in fund balance ratio Current year fund bal of the general fund – prior year fund balance Prior year fund balance of the general fund 775,206 – 1,041,502 1,041,502 • Ratio calculation: (0.26)
Hoehne School District • Causes: uncollected property taxes • 6% of total General Fund revenues • Applied for financial assistance • Solutions: • Spending limits • Reductions in staff • Checks and balances
Hoehne School District • Presentation to the Legislative Audit Committee • Hoehne Superintendent • CDE
Conclusion • Important analytical tool • Early warning system • Allows school districts to take prompt action