1 / 14

Mt. Diablo Unified School District Unaudited Actuals 2009-2010

Mt. Diablo Unified School District Unaudited Actuals 2009-2010. Bryan Richards Chief Financial Officer September 14, 2010. While you were at the beach this summer, Sacramento froze over…. State did NOT adopt a budget (again)

wigington
Download Presentation

Mt. Diablo Unified School District Unaudited Actuals 2009-2010

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Mt. Diablo Unified School DistrictUnaudited Actuals 2009-2010 Bryan Richards Chief Financial Officer September 14, 2010

  2. While you were at the beach this summer, Sacramento froze over… • State did NOT adopt a budget (again) • State DID pass special legislation, signed by Lt. Governor Maldonado to distribute Federal funding $6.4M • Failure to enact budget has frozen payment of all categorical funding (including Special Education) • Monitoring cash flow is critical

  3. Artificial Ending Balance Inflation • Tier 3 grants remain unrestricted • Their unspent balances and site carryovers make up majority of ending balance

  4. Rev Lim 159,012,690 Fed Rev 225,054 State Rv 31,683,519 Local Rv 3,490,005 Interfd in 0 Total Rv 194,411,267 Rev Lim 158,397,730 Fed Rev 82,901 State Rv 27,990,450 Local Rv 3,935,717 Interfd In 0 Total Rv 190,406,798 How the numbers play outUnrestricted RevenuesEstimated Actuals vs. Unaudited Actuals

  5. Cert Sal 84,550,535 Clsf Sal 20,205,871 Benefits 30,141,992 Bks/Supp 6,891,676 Svc/Othr 14,277,445 Cap Outl 564,563 Othr Out 929,381 Intfd Xfr 7,784,587 Contr (net) 34,869,362 Total 200,215,412 Cert Sal 82,428,637 Clsf Sal 21,168,333 Benefits 28,834,972 Bks/Supp 5,571,330 Svc/Othr 12,270,005 Cap Outl 333,535 Othr Out 926,780 Intfd Xfr 7,161,722 Contr (net) 31,450,116 Total 190,145,430 How the numbers play outUnrestricted ExpendituresEstimated Actuals vs. Unaudited Actuals

  6. Beg bal 24,529,701 Rev 194,411,267 Exp (200,215,412) End bal 18,725,556 Rvg cash (300,000) Stores (536,118) Prepd Exp (29,382) Econ Un* (5,438,064) Tier 3 (1,835,194) Site C/O 0 IRS asmt (533,500) Undesig 10,053,298 Beg bal 24,529,701 Rev 190,406,798 Exp (190,145,430) End bal 24,791,068 Rvg cash (300,000) Stores (447,156) Prepd Exp 0 Econ Un (5,438,064) Tier 3 (5,496,070) Site C/O (1,262,883) IRS asmt (533,500) Undesig 11,313,395 Unrestricted Fund BalanceEstimated Actuals vs. Unaudited Actuals

  7. If fund balance is up $6M why is undesignated only up $1.26M? • Tier 3 Cont Programs $3,660,876 • Site Carryovers $1,262,883 • Inventory & Prepaid adj. $ 118,344 • Fund Bal. Desig. Chgs $5,042,103 • Undesignated is up by $1.26M due to Special Education adjustments to ARRA to keep local maintenance of effort flat

  8. The new normalDeficit upon Deficit upon Deficit • 3 deficit factors in 2010/11 • Base Rev. Limit = $6,346.02/ADA • No COLA (2nd year) 9.215% ($587/ADA) • Add’l Cuts 10.068% of remaining ($582.23/ADA) • Additional deficit 3.85% (252.83/ADA) • Net Rev. Limit = $4,936.51/ADA • It totals a 22.21% deficit for 2010-11 or $46,453,160 • Equivalent to eliminating 40 days’ instruction • All three deficits are ongoing

  9. Rev Lim 6,815,118 Fed Rev 35,444,678 State Rv 37,607,078 Local Rv 9,749,285 Net Contr 37,833,313 Total Rv 127,449,472 Rev Lim 6,720,651 Fed Rev 27,849,149 State Rv 34,999,484 Local Rv 8,344,178 Net Contr 34,335,211 Total Rv 112,248,673 How the numbers play outRestricted RevenuesEstimated Actuals vs. Unaudited Actuals

  10. Cert Sal 46,080,547 Clsf Sal 22,787,324 Benefits 25,461,991 Bks/Supp 25,309,030 Svc/Othr 25,414,601 Cap Outl 1,108,851 Othr Out 2,081,889 Intfd Xfr 0 Total 148,244,233 Cert Sal 45,428,176 Clsf Sal 23,034,149 Benefits 24,168,080 Bks/Supp 6,539,033 Svc/Othr 23,276,942 Cap Outl 600,560 Othr Out 1,530,128 Intfd Xfr 15,080 Total 124,592,148 How the numbers play outRestricted ExpendituresEstimated Actuals vs. Unaudited Actuals

  11. Beg bal 22,687,425 Rev 127,449,472 Exp (148,244,233) End bal 1,892,664 Note: all ending balances are legally restricted Beg bal 22,687,425 Rev 112,248,673 Exp (124,592,148) End bal 10,343,950 Unspent restricted balance grant funds show as increased ending balance Unspent Deferred Revenue Grants do not appear on the books until received or earned through expenditure Restricted Fund BalanceEstimated Actuals vs. Unaudited Actuals

  12. Other Funds • Charter School – Form 09 • Adult Education – Form 11 • Cafeteria – Form 13 • Deferred Maintenance – Form 14 • Building – Form 21 (Measure C) • Capital Facilities (Dev. Fees) – Form 25 • State School Building – Form 35 • Cap. Proj. Mello Roos – Form 49 (Measure A) • Bond Int. & Redemption – Form 51 (Measure C) • Debt Svc. Mello Roos – Form 52 (Measure A) • Foundation Trust – Form 73 • All other funds have positive ending balances

  13. 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 (4.34% in 2011/12) • Lottery Report – Form L • No Child Left Behind MOE – Form NCMOE (We made 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 made MOE) • Special Education MOE (Budget) – Form SEMB (We make MOE)

  14. Will we ever get a State budget? Tune in next time for s a c r a m e n t o ----- ----------- Thank you to Nance, Mika & the fiscal staff

More Related