2016-17 Unaudited Actuals Report September 5, 2017
General Fund Revenue and Expenditures
20 2016 16-17 17 Re Reven venue ue Other State Other Local 6% 8% Description Amount 175,174,110 LCFF 14,419,320 Federal Federal 14,076,032 Other State LCFF 7% 17,399,502 Other Local 79% Total Combined Revenue (Unrestricted & Restricted) 221,068,964 LCFF Federal Other State Other Local Total General Fund revenue entitlement in 2016-17 was $221 Million
General Fund Combined Revenue History Restricted Revenue * Contribution to Restricted: E.g., LCAP, Sp.Ed., RRMA Unrestricted Revenue $250,000,000 $200,000,000 $150,000,000 $100,000,000 $50,000,000 $- *Removed SELPA Income 2007-08 2008-09 2009-10 2010-11 2011-12 2012-13 2013-14 2014-15 2015-16 2016-17 We are close to reach the LCFF target funding and have received 97% of LCFF target in 2016-17. This means our revenue in future years will be pretty much a fixed funding rate plus COLA.
General Fund Revenue History by Classification Unrestricted Revenue in Millions Contribution to Restricted: E.g., LCAP, Sp.Ed., RRMA in Millions $56.91 $119.32 $119.61 $130.47 $128.62 $110.69 $120.58 $48.15 $93.36 $92.35 $93.23 $97.88 $31.70 $11.57 $17.01 $18.44 $14.22 $13.03 $14.22 $7.14 07-08 08-09 09-10 10-11 11-12 12-13 13-14 14-15 15-16 16-17 07-08 08-09 09-10 10-11 11-12 12-13 13-14 14-15 15-16 16-17 2016-17 Summary Restricted Revenue in Millions When we separate Revenue by classification; • Unrestricted Revenue drop $82 $80 $75 $73 • Unrestricted Contribution to restricted $44 $42 $36 $36 $34 $33 increased • Restricted Revenue is steady 07-08 08-09 09-10 10-11 11-12 12-13 13-14 14-15 15-16 16-17
Svcs & Oper. Capital Other Exp. Outlay 0% 12% 0% Textbooks & Supplies 7% Description Amount Certificated Cert. Salaries 92,257,081 Salaries 43% Class. Salaries 27,355,673 Benefits 52,684,899 Benefits Textbooks & Supplies 14,200,626 25% Svcs & Oper. Exp. 25,216,706 Classified Capital Outlay 292,124 Salaries Other * -626,963 13% Total General Fund Combined 211,380,145 Expenditures Certificated Salaries Classified Salaries Total General Fund expenditures in 2016-17 were $211.4 Million
General Fund Combined Expenditures History $250,000,000.00 $200,000,000.00 Certificated Salaries Classified Salaries $150,000,000.00 Employee Benefits $100,000,000.00 Books & Supplies $50,000,000.00 Services & Operating $- Capital Outlay Other Outgo* $(50,000,000.00) The District has seen its expenditures continue to trend materially upward each year starting in 2013-14
School Services of California LCFF Analysis Report Does the LCFF Restore Purchase Power Lost? Per SSC report, due the fact that Retirement system establish very high increases to employer contribution rates, the purchase power will not be fully restored to districts purchase power in 2007-08 as state LCFF project promised
STRS and PERS Projected Increases in % 30.000% STRS & PERS Rates 25.000% 20.000% 15.000% 10.000% 5.000% 0.000% 1 2 3 4 5 6 7 8 2013-14 2014-15 2015-16 2016-17 2017-18 2018-19 2019-20 2020-21 PERS Rate 11.442% 11.771% 11.847% 13.888% 15.531% 18.100% 20.80% 23.80% STRS Rate 8.250% 8.880% 10.730% 12.580% 14.430% 16.280% 18.13% 19.10% 9
STRS and PERS Projected Increases in $ 20,000,000 STRS & PERS District Projected Cost Increase 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 - 2013-14 2014-15 2015-16 2016-17 2017-18 2018-19 2019-20 2020-21 Increase in STRS Cost 5,610,076 6,477,961 8,482,766 11,162,174 12,803,670 14,445,166 16,086,662 16,947,338 Increase in PERS Cost 1,981,425 2,266,840 2,733,057 3,530,358 3,948,012 4,601,057 5,287,402 6,050,008 10
School Services of California General Fund Analysis Report School Agency Revenues vs. Expenditures Trends Expenditures Revenue Expenditures crossing the revenue line and going over Revenue Per SSC report, Revenue trend across all state school agency is steady and expenditures continue a growing trend to the point that they are crossing and exceeding revenue projections starting in 2017-18 and 2018-19
General Fund Revenue vs. Expenditures $300,000,000 Revenue Expenditures $250,000,000 Expenditures crossing the $200,000,000 revenue line and going over $150,000,000 Revenue $100,000,000 $50,000,000 $- 2007-08 2008-09 2009-10 2010-11 2011-12 2012-13 2013-14 2014-15 2015-16 2016-17 2017-18 2018-19 2019-20 The District GAP between revenue and expenditures for 2016-17 is much smaller than what we had in 2007-08 (pre-recession).
General Fund 2016-17 Ending Fund Balance 2016-17 2016-17 2016-17 Combined Unrestricted EFB Restricted EFB EFB 185,525,342 35,543,622 221,068,964 TOTAL REVENUES Unrestricted EFB prior to TOTAL EXPENDITURES plus CONTRIBUTIONS to 179,918,001 33,433,215 213,351,216 Restricted Resources & OTHER assignment is $55.2 Million use: 5,607,341 2,110,406 7,717,748 $44.1 M. are obligated as Increase/(Decrease) to Reserve this will cover for projected FUND BALANCE deficit spending for the 49,564,696 15,896,504 65,461,201 Beginning Fund Balance subsequent fiscal years Ending Fund Balance prior to other 55,172,038 18,006,911 73,178,948 Assignments 2017-18 to 2019-20. $10.3 M. EFB Assignment COMPONENTS OF ENDING FUND BALANCE Cash & Store Inventory, 1% 155,015 0 155,015 Revolving Cash & Stores Inventory Board reserve, 3% REU, & 2,113,801 0 2,113,801 Assigned - Board Designated 1% LCAP GAP. 0 0 0 Assigned – LCFF Gap Funding $778,720 unassigned 6,341,404 0 6,341,404 Economic Uncertainties – 3% 0 18,006,911 18,006,911 Reserve Restricted Fund Unappropriated Amount – Amount that 46,561,817 0 46,561,817 establishes our certification
2016 016-17 17 Fal allout lout 2016-17 EFB and Fallout Comparison Unrestricted Restricted Unrestricted/Restricted What happen at What happen at Projection UA (comparison Projection UA (comparison Projection ACTUAL What happen at UA @ 2nd ACTUALS to 2nd Interim @ 2nd ACTUALS to 2nd Interim @ 2nd S per (comparison to 2nd 2nd Int Interim UA per UA Differ./ Fallout Report)? 2nd Int Interim UA per UA Differ./ Fallout Report)? 2nd Int Interim UA UA Differ./ Fallout Interim Report)? More Revenue Less Revenue Less Revenue than than Projected than Projected Projected @ 2nd REVENUES 184,489,993 185,525,342 1,035,349 @ 2nd Interim 38,593,182 35,543,622 -3,049,560 @ 2nd Interim 223,083,175 221,068,964 -2,014,211 Interim EXPENDITURES + Less Less OTH. OUTGO+ Expenditures Expenditures Less Expenditures Contributions to than Projected than Projected than Projected @ Restricted Funds 181,521,627 179,918,001 -1,603,627 @ 2nd Interim 49,406,163 33,433,215 -15,972,948 @ 2nd Interim 230,927,790 213,351,216 -17,576,574 2nd Interim Increase/ Increase Increase Increase (Decrease) to Increase to Increase to Decrease to Increase to Decrease to to Reserve 2,968,366 to Reserve 5,607,341 Reserve 2,638,976 Reserve -10,812,981 to Reserve 2,110,406 Reserve 12,923,387 Reserve -7,844,615 Reserve 7,717,748 Reserve 15,562,363Increase to Reserve FUND BALANCE (FB) Beginning FB 49,572,134 49,564,696 -7,438 15,889,066 15,896,504 7,438 65,461,200 65,461,201 1 Ending FB Prior to Assignments 52,540,500 55,172,038 2,631,538 5,076,085 18,006,911 12,930,826 57,616,585 73,178,948 15,562,364 Removed assignments at UA as Removed requested- assignments at UA as Balance requested-Balance covering MYP covering MYP Deficit EFB Assignment 36,215,241 8,610,220 -27,605,021 Deficit spending 5,076,085 18,006,911 12,930,826 41,291,326 26,617,130 -14,674,196 spending Ending FB for Certification 16,325,259 46,561,818 30,236,560 0 0 0 16,325,259 46,561,818 30,236,560 Unrestricted EFB prior to assignment is $55.2 Million use: $44.1 M. are obligated as this will cover for projected deficit spending for the subsequent fiscal years 2017-18 to 2019-20. $10.3 M. EFB Assignment Cash & Store Inventory, 1% Board reserve, 3% REU, & LCAP GAP. $778,720 unassigned - See MYP including Minimum Wage Mandated Adjustments cost increase.
Revenue Fund 01 2016-17 Estimated Actuals 2016-17 Unaudited Actuals Variance Positive Description (EA) Budget (UA) (Negative) % Diff LCFF 176,431,801 175,174,110 -1,257,692 -0.71% Federal Revenue 13,667,655 14,419,320 751,665 5.50% State Revenue 15,311,176 14,076,032 -1,235,144 -8.07% Local Revenue 17,524,194 17,399,502 -124,692 -0.71% Grand Total 222,934,826 221,068,964 -1,865,863 -0.84% 2016-17 Estimated Actuals 2016-17 Unaudited Actuals Variance Positive Expenditures Fund 01 (EA) Budget (UA) (Negative) % Diff Certificated Salaries 91,412,015 92,257,081 845,066 -0.92% Classified Salaries 26,381,013 27,355,673 974,660 -3.69% Benefits 52,757,312 52,684,899 -72,413 0.14% Textbooks & Supplies 19,843,718 14,200,626 -5,643,092 28.44% Services & Oth Operating 27,805,112 25,216,706 -2,588,406 9.31% Capital Outlay 302,993 292,124 -10,869 3.59% Other Outgo, IC, & Others -653,798 -626,963 26,834 4.10% Grand Total 217,848,365 211,380,145 -6,468,220 2.97%
Recommend
More recommend
