310 likes | 430 Views
Planning and Forecasting. TASBO Budget Academy January 14-15, 2010. Presentation Overview. Comparison Tools Developing Statistical History Revenue Projections Short- and Long-Term Projections Sources of Current Information. Comparison Tools.
E N D
Planning and Forecasting TASBO Budget Academy January 14-15, 2010
Presentation Overview • Comparison Tools • Developing Statistical History • Revenue Projections • Short- and Long-Term Projections • Sources of Current Information
Comparison Tools Information is a source of learning. But unless it is organized, processed, and available to the right people in a format for decision-making, it is a burden, not a benefit. William Pollard
Comparison Tools • AEIS Reports – Available on TEA website • Section II of report has student and staff demographics and prior year financial information • TEA Standard Reports – Examples: Staff FTE and Salary Reports; Enrollment Reports • FIRST – Available on TEA website • eFACTS+ – Available thru TASBO • Ability to create reports and customize comparisons • TASB – Salary Survey Reports for Superintendents, Teachers, Staff, Stipends; custom salary and staffing reports • District conducted surveys (via email or phone)
Comparison Tools • District records • General ledger reports • Data queries • Personnel/staffing reports • Facilities info; example – square footages of buildings • Annual audit report
Developing Statistical History In the business world, the rear view mirror is always clearer than the windshield. Warren Buffet
Developing Statistical History • For expenditures, develop a monthly history by object codes and function codes • For revenues, develop a monthly history by object code • Using these reports, can also develop a history of % of funds expended on a year-to-date basis • IMPORTANT – For 2009-10 and 2010-11, remember to include Fund 266 with General Fund
Developing Statistical History • Staffing ratios, patterns and trends • Instructional and non-instructional staff • By campus and department • Student enrollment and ADA • Special populations – SCE, CATE, Bilingual/ESL, G/T, Special Ed • Property values
Developing Statistical History Food Service Fund • Use monthly reimbursement claims to develop history of paid/reduced/free meals served
Revenue Projections There is no data on the future. Laurel Cutler
Revenue Projections • ADA Information • PEIMS Info – Superintendent Semester Summary Report (each 6-weeks period) • Pupil Projections – Template available on TASBO website; Click on Resources; Tools Templates; Pupil Projection Template • Know your district – subdivision development; housing projects being built or closed; industry moving in or out; charter or private schools
Revenue Projections • Pupil Projection Template • Getting Started Tab • Enrollment Conversion • Data Entry • Ratio Method • Cohort Method • Trend Method • Results • Graphs • Comp Ed • Mid Year
Revenue Projections • Property Tax Values and Collections • County Appraisal District • Estimated taxable property values to be certified by April 30 (instead of previous June 7) • Final certified values by July 25 • Build a relationship with the CAD staff • Comptroller Property Tax Division (CPTD) reports • 2008 Preliminary Findings issued in January 2009 • 2008 Final Findings issued in August 2009 • Tax Collection % Rate
Revenue Projections • State Revenue – • Use Summary of Finance Template from Region 13 • Version 6 has projections thru 2012-13 • Investment Earnings – project balances available to invest and interest rates • Athletic Revenues • Donations • Other/Miscellaneous Revenues • Federal Revenues – Medicaid/SHARS, Indirect Costs
Revenue Projections • Food Service Fund Revenue • Meal Sales and Meal Prices • National School Lunch & Breakfast Program reimbursements • Rates change annually • TDA Square Meals website – www.squaremeals.org • Commodities • Catering
Debt Service Fund Revenue • Local property tax collections • Based on I&S rate and assessed values • State Aid – IFA and EDA • Investment earnings Revenue Projections
Short- and Long-Term Financial Projections The great thing in the world is not so much where we stand, as in what direction we are moving. Oliver Wendell Holmes
Short- and Long-Term Financial Projections • For short-term projections, compare year-to-date expenditures to comparable period in prior year • Look at percentage of funds expended and compare to prior year(s) • Annualize expenditures to project year-end results • Look for unusual trends • Be aware of one-time transactions
Short- and Long-Term Financial Projections • For long-term projections (2-5 years), will need to make a variety of assumptions • ADA growth or decline • Anticipated raises for staff • Staffing increases or decreases • Inflation for utilities, insurance premiums, supplies, etc. • Campus openings or closings • Property value growth or decline • Changes in M&O and I&S tax rates (due to Tax Rate Election, state facilities aid, or bond payments)
Short- and Long-Term Financial Projections • HB3 (Section 59) requires TEA to develop a review process to anticipate future solvency of schools districts, including analysis of revenue and expenditures for the prior year, current year, and following 2 years • If review process results in projected fund balance deficit within the following 3 years, then the district will be required to provide interim financial reports as well as staff and student count data • TEA will use PEIMS data for prior year information and will request first quarter actual financial data from district • In effect for 2009-10
Sources of Information I find that a great part of the information I have was acquired by looking up something and finding something else on the way. Franklin P. Adams
Sources of Information • TASBO Website – www.tasbo.org • TEA Website – www.tea.state.tx.us • ListServ email messages – Register at http://miller.tea.state.tx.us/list/ • TexasISD.com • Region 13 Statewide School Finance -http://www5.esc13.net/finance/
Sources of Information • TASA – Texas Association of School Administrators – www.tasaonline.org • TASB – Texas Association of School Boards – www.tasb.org • Texas Comptroller – Property Taxes – www.window.state.tx.us/taxinfo/proptax • Moak, Casey and Associates – www.moakcasey.com • Equity Center – www.equitycenter.org
Good luck! How paramount the future is to the present when one is surrounded by children. Charles Darwin
Questions?? Contact Information: Julie P. Novak, RTSBA Director of Planning and Budget San Antonio ISD 210-554-8689 jnovak1@saisd.net