150 likes | 163 Vues
A report on the unaudited actuals of the Mt. Diablo Unified School District's finances for the 2008-2009 fiscal year, highlighting the impact of budget revisions and funding changes.
E N D
Mt. Diablo Unified School DistrictUnaudited Actuals 2008-2009 Bryan Richards Director, Fiscal Services September 22, 2009
What a difference summer makes! • State did NOT adopt budget revisions prior to June 30 for the end of the fiscal year • State DID adopt budget revisions on July 24, 2009, some retroactive to July 1, 2008 • Failure to act by June 30 forced 2008/09 revenue limits back up to the February level • State comes back in 2009/10 to take away with 4 deficit factors
Artificial Ending Balance Inflation • State moved all Tier 3 grants to unrestricted, with exception of 6/30/08 balance of Instructional Materials • Includes all programs available for sweep and all Tier 3, not just ones acted on specifically by the board
Rev Lim 175,699,751 Fed Rev 153,171 State Rv 16,712,493 Local Rv 5,490,756 Interfd in 1,758,835 Total Rv 199,815,006 Rev Lim 182,218,757 Fed Rev 402,858 State Rv 14,426,885 Local Rv 4,524,340 Interfd In 2,204,626 Total Rv 203,777,466 How the numbers play outUnrestricted RevenuesEstimated Actuals vs. Unaudited Actuals
Cert Sal 101,337,853 Clsf Sal 21,916,429 Benefits 31,422,120 Bks/Supp 3,880,776 Svc/Othr 13,566,687 Cap Outl 1,860,454 Othr Out 934,379 Intfd Xfr 155,928 Contr (net) 38,581,932 Total 213,656,558 Cert Sal 101,446,867 Clsf Sal 22,464,564 Benefits 31,459,761 Bks/Supp 2,406,577 Svc/Othr 12,936,837 Cap Outl 1,019,349 Othr Out 926,780 Intfd Xfr 607,967 Contr (net) 27,531,938 Total 200,800,640 How the numbers play outUnrestricted ExpendituresEstimated Actuals vs. Unaudited Actuals
Beg bal 18,902,671 Rev 199,815,006 Exp (213,656,558) End bal 5,061,119 Rvg cash (300,000) Stores (510,879) Prepd Exp 0 Econ Un* (3,337,725) Tier 3 0 IRS asmt (833,550) FCMAT rec (78,965) Undesig 0 Beg bal 18,902,671 Rev 203,777,466 Exp (200,800,640) End bal 21,879,497 Rvg cash (300,000) Stores (536,118) Prepd Exp (29,382) Econ Un (5,472,456) Tier 3 (6,991,764) IRS asmt (833,550) FCMAT rec (78,965) Undesig 7,631,262 Unrestricted Fund BalanceEstimated Actuals vs. Unaudited Actuals *Note: 2% reserve not fully funded at estimated actuals
Why the big difference? • Inventory & Prepaids $ 54,621 • Restore 2% reserve $2,134,731 • Tier 3 Cont Programs $6,991,764 • Expenditure decreases $1,805,924 • SBX3-4 Sweep to UGF $5,165,487
What the Feds Giveth… • ARRA Funding • SFSF $13,213,696 Eagle Pk $59,247 • IDEA $ 6,667,377 • IDEA PreK $ 232,059 • IDEA PreK $ 338,049 • Title I $ 3,710,146 • Homeless $ 24,500 • Equipment $ 189,981 • Total $ 24,375,808 Note: These are one time funds
…the State Taketh Away • 4 deficit factors in 2009/10 • Base Rev. Limit = $6,370.02/ADA • No COLA (2nd year) 9.215% ($587/ADA) • Add’l Cuts 10.068% of remaining ($582.23/ADA) • Additional deficit due to failure to cut pre 6/30 (252.83/ADA) • QEIA $4,486,100 (135.35/ADA) • Net Rev. Limit = $4,812.61/ADA • That totals a 24.45% deficit for 2009-10 or $51,617,660 Note: First two deficits are ongoing
Rev Lim 6,091,483 Fed Rev 32,475,004 State Rv 53,992,756 Local Rv 5,858,482 Net Contr 39,240,566 Total Rv 137,658,291 Rev Lim 7,189,798 Fed Rev 28,084,455 State Rv 54,986,527 Local Rv 5,602,383 Net Contr 28,144,805 Total Rv 124,007,968 How the numbers play outRestricted RevenuesEstimated Actuals vs. Unaudited Actuals
Cert Sal 37,339,303 Clsf Sal 22,401,014 Benefits 21,174,486 Bks/Supp 30,966,009 Svc/Othr 27,127,405 Cap Outl 1,633,846 Othr Out 1,979,413 Intfd Xfr 764,074 Total 143,385,550 Cert Sal 34,641,596 Clsf Sal 23,094,525 Benefits 20,855,614 Bks/Supp 8,045,838 Svc/Othr 25,073,021 Cap Outl 1,210,436 Othr Out 2,094,680 Intfd Xfr 1,131,929 Total 116,147,639 How the numbers play outRestricted ExpendituresEstimated Actuals vs. Unaudited Actuals
Beg bal 14,827,213 Rev 137,658,291 Exp (143,385,550) End bal 9,099,954 Note: all ending balances are legally restricted Beg bal 14,827,213 Rev 124,007,968 Exp (116,147,639) End bal 22,687,542 The big difference is ARRA-SFSF designated as Restricted Ending Balance Restricted Fund BalanceEstimated Actuals vs. Unaudited Actuals
Other Funds • Charter School – Form 09 • Adult Education – Form 11 • Cafeteria – Form 13 • Deferred Maintenance – Form 14 • Building – Form 21 • Capital Facilities (Dev. Fees) – Form 25 • State School Building – Form 35 • Cap. Proj. Mello Roos – Form 49 • Bond Int. & Redemption – Form 51 • Debt Svc. Mello Roos – Form 52 • Foundation Trust – Form 73 • All other funds have positive ending balances
Other Forms • Attendance – Form A • Certification – Form CA • Current Expense Formula – Form CEA • Community Day – Form DAY • Long-term Liabilities – Form DEBT • Appropriations Limit – Form GANN (See next item – resolution) • Indirect Cost Worksheet – Form ICR (5.73% in 2010/11) • Lottery Report – Form L • No Child Left Behind MOE – Form NCMOE (We make MOE!) • Program Cost Allocation Factors – Form PCRAF • Program Cost Allocations – Form PCR • Revenue Limit – Form RL • Summary of Interfund Activities – Form SIAA • Pupil Transportation – Form TRAN • Special Education MOE (Actuals) – Form SEMA (We make MOE!) • Special Education MOE (Budget) – Form SEMB (We make MOE!)