Docstoc

Five-Year-Financial-Forecast

Document Sample
Five-Year-Financial-Forecast Powered By Docstoc
					Five Year Financial Forecast Spreadsheet
Instructions
This spreadsheet was developed by the SSDT to assist school district's in preparing the Five Year Financial Forecast required by HB412 and EMIS. Tip

If you have questions or need assistance using this spreadsheet, The spreadsheet may be used alone (by hand entering the values) or visit the USAS forum on the OECN in conjunction with the USASFF program provided by the SSDT with Public Discussion forums at the USAS software. The USASFF program provides a CSV file which http://ssdt.oecn.k12.oh.us/forums can be imported into this spreadsheet to provide the three prior year actual values as well as the expendable/receivable values for the The Forums are a web-based current year estimate. 'discussion' areas (similar to DEC Notes). Someone from the SSDT Note: These instructions assume you are using Microsoft Excel 97 or will be there to help you. Excel 2000. The spreadsheet is believed to be compatible with earlier versions of Excel. However, the precise steps may vary slightly if you are using a different spreadsheet application.

Getting Started
This spreadsheet is actually a 'workbook" which contains multiple "worksheets" . You will need to switch between the various sheets while you prepare the forecast. You are currently viewing the "Instructions" worksheet. Near the bottom of this window are tabs which allow you to switch between the various sheets. You should see the following worksheets: -'Instructions' is the sheet you are currently viewing -'Forecast' contains the Five Year Forecast - 'Parameters' contains global parameters (district's name, FY) - 'Data' may contain the information imported from USASFF. Now switch to the 'Parameters' sheet and enter your district's name, county and the fiscal year. After you enter these values, switch to the 'Forecast' sheet to see that your district name and fiscal year appear in the headings

Importing Data From USASFF
If you choose to import data using USASFF. You should follow these Tip basic steps: 1) Run USASFF and review the report. The text report includes the detail budget/revenue accounts which are included in each line. 2) Download the CSV file (USASFF.CSV) produced by USASFF to your PC or Mac. Your OECN DAS personnel may need to help you with this step. 3) You should now have both this forecast spreadsheet and the CSV file open in Excel. Now do the following: Be sure to download the CSV file in the correct mode. For example, if using FTP or Kermit, download the CSV file in "ASCII" mode.

a. Switch to the CSV file and select the entire worksheet. The easiest way to do this is to click on the upper left corner of the sheet (in the corner adjacent to the column A and row 1 labels.). Alternatively, you may click-drag from cell A1 through F56 to select the appropriate cells. b. On the menu bar, choose Edit->Copy. A dashed box should appear around the copied cells. c. Switch back to the 'Data' sheet in the Forecast workbook and click on cell A1. d. From the menu bar, choose Edit->Paste. The data from the CSV file should now appear in the 'Data' sheet. 4) If you completed the above steps successfully the data from the CSV file should be in the 'Data' sheet of this workbook. Now switch to the 'Forecast' sheet. You should see the values from the 'Data' sheet have been automatically placed in the correct locations of the Forecast. If you see any error values (e.g. #VALUE, #N/A, etc) then something went wrong during the import. If this occurs, it is recommended that you start over with a fresh copy of the spreadsheet. (If you have already done a significant amount work in the forecast and don't want to start over, see "Correcting Common Problems" below. After the data is loaded, you can proceed with completing the forecast (see below).

Entering or Correcting Data Manually
If you choose not use the data from USASFF, or you are not a state software user, then you must enter the actual values manually. You may do this by simply switching to the 'Forecast' sheet and enter the values in the appropriate row and column. There will be formulas in the cells. You may simply type the numeric values over the formulas. (Note: Once this is done, you may not load the USASFF CSV file later. If you type over the formulas then the link between the 'Forecast' and 'Data' sheets will be broken.) Even if you loaded the data from USASFF, you will probably need to make manual changes to correct errors or reclassify revenues or expenditures. In this case, you have two choices. You may correct the values in the 'Data' sheet or you can replace the formulas on the 'Forecast' sheet as described above. If you make the changes in the 'Data' sheet, then the values will be automatically updated in the 'Forecast' sheet. When entering manual data, you should not enter any values in lines which contain sub-totals (i.e., Cells that contain a SUM formula). The subtotals will be adjusted automatically when you change the detailed data.

Completing the Forecast After importing or entering the actual values, you must complete the forecast. USASFF cannot supply all of the information necessary so you must enter the appropriate values in the 'Forecast' sheet. For example, you must enter values for 'New Levies', and 'Reserve' balances. It is left to the Treasurer to determine which values are needed to produce a valid and complete forecast. The spreadsheet does not attempt to calculate values for the forecasted columns of the forecast. You may either calculate the numbers manually and enter the values in the appropriate column and row, or you devise your own formulas for the forecasted amounts.

Correcting Common Problems Running out of memory If Excel complains that it is 'out of memory', it's likely that this "Instructions" sheet is too large. Print the "Instructions" sheet and then delete the instructions (right click on the 'Instructions' tab and choose Delete). Damaged Formula If you accidentally delete or type over a formula, don't panic. The formulas in this spreadsheet were constructed to be easy to fix. A given formula on the spreadsheet can be recreated very easily. Simply select a formula from a similar cell that is still working and choose Edit->Copy. Then move to the cell with the damaged formula and choose Edit->Paste Special. In the dialog box, choose the 'Formulas' radio button and click OK. Excel will automatically adjust the formula you copied to have the correct references. Other Problems If you manage to damage your copy of the spreadsheet in other way, you don't necessarily have to start over. Your local DA Site may be able to help you recover the spreadsheet. Alternatively, you can contact the SSDT for assistance. The best way to do this is via the OECN Forums web site (see link in first "Tip"). We may ask you to upload your spreadsheet to the forum so that we can look at it or repair it for you. Exporting for use with EMIS (FFIMPORT) After you have completed the forecast, you must provide the Note: information to the EMIS system. You may either manually re-enter the data from this spreadsheet, or you may use the EMIS FFIMPORT The spreadsheet is compatible with program to import the results of this spreadsheet. the default options of FFIMPORT. You do not need to enter any special To prepare this spreadsheet for importing into EMIS, switch to the values in FFIMPORT unless you 'Forecast' sheet and choose File->Save As... Give the file a different have added or removed columns name and in the 'Save as Type' field choose 'Text (tab-delimited)'. from the spreadsheet. The resulting file must then be uploaded to the DAS computer system for loading into EMIS using FFIMPORT. Your DAS personnel may need to help you with the uploading process. Important: Be certain that you extract the 'Forecast' sheet and not the 'Percentage View' or 'Summary View'. Only the 'Forecast' sheet has all the information required by EMIS.

Other Suggestions This spreadsheet was formatted to print acceptably on a laser or inkjet printer. If you find that the forecast does not print well on a single page with your printer, then you should use File->Page Setup and change the "Fit to" parameters appropriately. Most likely, you will want to print one page wide and two pages tall. If the shading does not print well, or just annoys you, you can remove it easily by selecting the entire forecast sheet and choosing Format->Cells. Select the Patterns tab and then 'No color". This will remove the fill colors from the entire spreadsheet.

SSDT "Extras" for the Five Year Forecast
This version of the SSDT Financial Forecast Spreadsheet has several optional sheets included. The extra sheets consist of the following: "Percentage View" sheet "Summary View" sheet "Charts" sheet The extra sheets are entirely optional and may be deleted or modified as desired. These sheets will update automatically as you work in the 'Data' and 'Forecast' sheets. The Percentage and Summary views are alternative presentations of the Five Year Forecast which you may find useful for presenting to your school board or to the public. You may also use them as examples for providing your own presentations. Both of these sheets were based on similar presentations provided by the AOS spreadsheets. The Charts sheet contains several sample Excel charts which display the forecast data graphically. You may wish to use these charts, in your own documents or use them as examples for creating your own charts. The charts can also be copied and pasted into other documents. For example, you could select one of the charts and choose "Edit-Copy". Then switch to a Word document and choose "Edit->Paste". Word and Excel can maintain a "link" to between the document and spreadsheet so that as you modify the forecast data, the document will be updated automatically. Warning: If you have a slower PC/Mac or one with insufficient memory you may find that the "Extras" cause your computer to run too slowly or run out of memory. If this happens you may need to delete the extra sheets. You may also delete this instructions sheet.

Bellevue City Schools Huron County
Schedule of Revenues, Expenditures and Changes in Fund Balances For the Fiscal Years Ended June 30, 2006, 2007 and 2008 Actual; Forecasted Fiscal Years Ending June 30, 2009 Through 2013

9/18/2008

Actual
Fiscal Year 2006 1.010 1.020 1.030 1.035 1.040 1.050 1.050a 1.060 Revenues General Property Tax (Real Estate) Tangible Personal Property Tax Income Tax Unrestricted Grants-in-Aid/State Reimb Offset-Tang Pers Restricted Grants-in-Aid Property Tax Allocation Tangible Personal Property Tax Reimbursed by the State All Other Revenues Other Financing Sources Operating Transfers-In Advances-In All Other Financing Sources Total Other Financing Sources Expenditures Personal Services Employees' Retirement/Insurance Benefits Purchased Services Supplies and Materials Capital Outlay Intergovernmental Debt Service: Principal-Notes Loans Principal-HB 264 Principal-Other Interest and Fiscal Charges Other Objects $5,805,045 1,533,518 1,117,217 7,605,340 99,838 685,935 181,632 641,913 Fiscal Year 2007 $5,985,618 1,135,170 1,181,198 7,921,727 103,396 693,169 855,731 799,476 Fiscal Year 2008 $6,133,278 995,025 1,275,762 7,912,016 118,250 794,681 756,997 811,984 Average Change 2.8% -19.2% 6.9% 2.0% 9.0% 7.8% 13.1% 3.2% Fiscal Year 2009 6,153,612 315,534 1,262,875 8,597,805 120,024 885,000 1,082,110 842,064 Fiscal Year 2010 6,246,160 27,804 1,300,761 9,000,000 121,824 885,000 762,241 811,064

Forecasted
Fiscal Year 2011 6,311,143 13,902 1,339,784 9,475,000 123,651 885,000 530,599 790,064 Fiscal Year 2012 5,962,353 1,087,437 9,740,000 125,506 885,000 511,460 790,064 Fiscal Year 2013 5,633,899

9,935,000 127,389 885,000 470,718 790,064

1.070 Total Revenues
2.040 2.050 2.060 2.070

17,670,438

18,675,485

18,797,993

19,259,024

19,154,854

19,469,144

19,101,820

17,842,070

65,227 3,730 68,957

40,190 20,267 60,457

176,480 4,000 180,480

150.4% 181.5% 93.1%

72,648 2,000 74,648

100,000 2,000 102,000

100,000 2,000 102,000

100,000 2,000 102,000

100,000 2,000 102,000

2.080 Total Revenues and Other Financing Sources
3.010 3.020 3.030 3.040 3.050 3.060 4.020 4.050 4.055 4.060 4.300

17,739,395
10,963,824 3,540,232 2,156,343 617,095 126,747

18,735,942
11,232,746 3,511,878 2,429,204 609,806 61,480

18,978,473
11,235,990 3,463,396 2,563,541 934,838 184,491

3.5%
1.2% -1.1% 9.1% 26.1% 74.3%

19,333,672
11,706,843 3,805,538 2,732,583 867,955 41,000

19,256,854
12,250,111 3,925,616 2,787,235 926,994 25,000

19,571,144
12,670,957 4,111,010 2,815,107 936,264 25,000

19,203,820
13,052,935 4,282,032 2,843,258 945,627 25,000

17,944,070
13,429,247 4,495,603 2,871,691 955,083 25,000

133,522 8,929 248,048

69,398 1,827 262,102

-74.0% -89.8% 2.1%

258,042

287,150

290,022

292,922

295,851

298,809

4.500 Total Expenditures
5.010 5.020 5.030 5.040 Other Financing Uses Operating Transfers-Out Advances-Out All Other Financing Uses Total Other Financing Uses

17,794,740
7,581 40,190 47,771

18,178,441
5,672 176,480 100 182,252

18,640,298
4,951 72,648 77,599

2.3%
-18.9% 140.1% 112.0%

19,441,069
10,000 100,000 500 110,500

20,204,977
10,000 100,000 500 110,500

20,851,260
10,000 100,000 500 110,500

21,444,703
10,000 100,000 500 110,500

22,075,433
10,000 100,000 500 110,500

5.050 Total Expenditures and Other Financing Uses 6.010 Excess of Revenues and Other Financing Sources over (under) Expenditures and Other Financing Uses 7.010 Cash Balance July 1 - Excluding Proposed Renewal/Replacement and New Levies 7.020 Cash Balance June 30 8.010 Estimated Encumbrances June 30
Reservation of Fund Balance 9.010 Textbooks and Instructional Materials 9.020 Capital Improvements 9.070 Bus Purchases

17,842,511 103,1161,836,191 1,733,075 199,950

18,360,693 375,249 1,733,075 2,108,324 514,277

18,717,897

2.4%

19,551,569 (217,897) 2,368,900 2,151,003

20,315,477 (1,058,623) 2,151,003 1,092,380

20,961,760 (1,390,616) 1,092,380 (298,236)

21,555,203 (2,351,383) (298,236) (2,649,619)

22,185,933 (4,241,863) (2,649,619) (6,891,482)

260,576 -247.2% 2,108,324 2,368,900 307,850 8.0% 17.0% 58.5%

9.080

Subtotal 1,533,125 1,594,047 2,061,050 16.6% 2,151,003 1,092,380 (298,236) (2,649,619)
292,541 395,001

10.010 Fund Balance June 30 for Certification of Appro
Revenue from Replacement/Renewal Levies 11.010 Income Tax - Renewal 11.020 Property Tax - Renewal or Replacement

(6,891,482)
1,421,377 790,002

11.300 Cumulative Balance of Replacement/Renewal Levies 12.010 Fund Balance June 30 for Certification of Contracts, Salary Schedules and Other Obligations
Revenue from New Levies Income Tax - New Property Tax - New

687,542 1,533,125 1,594,047 2,061,050 16.6% 2,151,003 1,092,380 (298,236) (1,962,077)

2,898,921 (3,992,561)

13.010 13.020

445,832

891,664

891,664

891,664

891,664

13.030 Cumulative Balance of New Levies
14.010 Revenue from Future State Advancements

445,832

1,337,496

2,229,159

3,120,823

4,012,487

15.010 Unreserved Fund Balance June 30
ADM Forecasts Kindergarten - October Count Grades 1-12 - October Count Kindergarten - February Count Grades 1-12 - February Count

1,533,125

1,594,047

2,061,050

16.6%

2,596,835

2,429,875

1,930,923

1,158,746

19,925

20.010 20.015 20.02 20.025

157 2,134 n/a n/a

146 2,090 143 2,069

173 2,019 177 2,003

5.7% -2.7% 23.8% -3.2%

167 2030 167 2030

167 2022 167 2022

167 2019 167 2019

167 2029 167 2029

167 2033 167 2033

Page 29

SSDT Forecast Spreadsheet: Version 2.01-4 Enter the global parameters below. These values affect how the headings and calculations function on the other sheets.

Parameters

School District Name County Fiscal Year

Bellevue City Schools Huron County 2009

Note: Do not change cells below this line The cells below are scratch areas used to calculate amounts for use in the Charts sheet. If you remove or change any of these cells, the charts may not function.

Version 2.01-4

Line 1.01 1.02 1.03 1.035 1.04 1.05 1.06 1.07 2.01 2.02 2.04 2.05 2.06 2.07 2.08 3.01 3.02 3.03 3.04 3.05 3.06 4.01 4.02 4.03 4.04 4.05 4.055 4.06 4.3 4.5 5.01 5.02 5.03 5.04 5.05 6.01 7.01 7.02 8.01 9.01 9.02 9.03 9.04 9.05 9.06 9.07 9.08 10.01 11.01 11.02 11.3

2006 2007 2008 Avg Chg 5805045 5985618 6133278 2.8 1533518 1135170 995025 -19.1 1117217 1181198 1275762 6.8 7605340 7921727 7912016 2 99838 103396 118250 9 867567 1548900 1551678 39.3 641913 799476 811984 13 17670439 18675485 18797994 3.2 0 0 0 65227 40190 176480 150.3 3730 20267 4000 181.5 68958 60457 180480 93.1 17739396 18735942 18978474 3.4 10963824 11232746 11235990 1.2 3540232 3511878 3463396 -1.1 2156343 2429204 2563541 9.1 617095 609806 934838 26 126747 61480 184491 74.3 0 0 0 0 0 0 0 0 248048 262102 258042 2.1 17652290 18107217 18640299 2.7 150031 76897 4951 -71.1 40190 176480 72648 140.1 100 0 190221 253476 77599 -18 17842511 18360693 18717898 2.4 -103114 375249 260576 -247.2 1836191 1733077 2108326 8 1733077 2108326 2368902 17 199950 514277 307850 58.5 0 0 0 0 0 0 0 0 0 0 0 0

2009

12.01 13.01 13.02 13.03 14.01 15.01 20.01 20.015 20.02 20.025

0 0 0 0 0 0 0 0 0 0

Bellevue City Schools
Huron County

Summary Forecasted Statement of Revenues, Expenditures and Changes in Fund Balances For the Fiscal Years Ending June 30, 2009 Through 2013

Forecasted
Historical Annual Average Change Revenues General Property Tax (Real Estate) Tangible Personal Property Tax Income Tax Unrestricted Grants-in-Aid Restricted Grants-in-Aid Property Tax Allocation All Other Revenues 2.8% -19.2% 6.9% 2.0% 9.0% 7.8% 13.1% Fiscal Year 2009 $6,153,612 315,534 1,262,875 8,597,805 120,024 885,000 842,064 Fiscal Year 2010 $6,246,160 27,804 1,300,761 9,000,000 121,824 885,000 811,064 Fiscal Year 2011 $6,311,143 13,902 1,339,784 9,475,000 123,651 885,000 790,064 Fiscal Year 2012 $5,962,353 1,087,437 9,740,000 125,506 885,000 790,064 Fiscal Year 2013 $5,633,899 Average Annual Change -2.1% -60.3% -28.2% 3.7% 1.5% 0.0% -1.6%

9,935,000 127,389 885,000 790,064

Total Revenues
Other Financing Sources Proceeds from Sale of Notes State Emergency Loans and Advancements (Approved) Operating Transfers-In Advances-In All Other Financing Sources Total Other Financing Sources

3.2% 18,176,914
0.0% 0.0% 0.0% 150.4% 181.5% 93.1%

18,392,613

18,938,545

18,590,360

17,371,352

-1.1%
0.0% 0.0% 0.0% 9.4% 0.0%

72,648 2,000

100,000 2,000

100,000 2,000

100,000 2,000

100,000 2,000

Total Revenues and Other Financing Sources
Expenditures Personal Services Employees' Retirement/Insurance Benefits Purchased Services Supplies and Materials Capital Outlay Intergovernmental Debt Service: Principal-All (Historical Only) Principal-Notes Principal-State Loans Principal-State Advancements Principal-HB 264 Loans Principal-Other Interest and Fiscal Charges Other Objects

3.5%
1.2% -1.1% 9.1% 26.1% 74.3% 0.0% 0.0% -74.0% 0.0% 0.0% 0.0% 0.0% -89.8% 2.1% 2.3% -18.9% 140.1% 0.0% 112.0% 2.4%

74,648 19,333,672
11,706,843 3,805,538 2,732,583 867,955 41,000

102,000 19,256,854
12,250,111 3,925,616 2,787,235 926,994 25,000

102,000 19,571,144
12,670,957 4,111,010 2,815,107 936,264 25,000

102,000 19,203,820
13,052,935 4,282,032 2,843,258 945,627 25,000

102,000 17,944,070
13,429,247 4,495,603 2,871,691 955,083 25,000

9.2% 3.5% 4.3% 1.3% 2.5% -9.8% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 1.0%

287,150

290,022

292,922

295,851

298,809

Total Expenditures
Other Financing Uses Operating Transfers-Out Advances-Out All Other Financing Uses Total Other Financing Uses

19,441,069
10,000 100,000 500

20,204,977
10,000 100,000 500

20,851,260
10,000 100,000 500

21,444,703
10,000 100,000 500

22,075,433
10,000 100,000 500

3.2%
9999.0% 99999.0% 499.0%

Total Expenditures and Other Financing Uses Excess of Revenues and Other Financing Sources over (under) Expenditures and Other Financing Uses Cash Balance July 1 - Excluding Proposed Renewal/Replacement and New Levies Cash Balance June 30 Estimated Encumbrances June 30
Reservation of Fund Balance Textbooks and Instructional Materials Capital Improvements Budget Reserve DPIA Debt Service Property Tax Advances Bus Purchases

110,500 19,551,569

110,500 20,315,477

110,500 20,961,760

110,500 21,555,203

110,500 22,185,933

110499.0% 212,546

-247.2%

217,8972,368,900 2,151,003

1,058,6232,151,003 1,092,380

1,390,6161,092,380 298,236-

2,351,383298,2362,649,619-

4,241,8632,649,6196,891,482-

1
150.7%

8.0% 17.0% 58.5% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 16.6% 0.0% 0.0% 0.0%

193.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%

Subtotal Fund Balance June 30 for Certification of
Revenue from Replacement/Renewal Levies Income Tax - Renewal Property Tax - Renewal or Replacement

0.0% 2,151,003 1,092,380 298,2362,649,619292,541 395,001

6,891,4821,421,377 790,002

193.0%
96.5% 25.0% 80.4%

Cumulative Balance of Replacement/Renewal Levies Fund Balance June 30 for Certification of Contracts, Salary Schedules and Other Obligations

687,542

2,898,921

16.6% Revenue from New Levies Income Tax - New Property Tax - New

2,151,003

1,092,380

298,236-

1,962,077-

3,992,561-

121.2%

0.0% 0.0% 0.0% 0.0% 16.6%

445,832

891,664

891,664

891,664

891,664

0.0% 25.0%

Cumulative Balance of New Levies
Revenue from Future State Advancements

445,832

1,337,496

2,229,159

3,120,823

4,012,487

83.8%
0.0%

Unreserved Fund Balance June 30
ADM Forecasts Kindergarten - October Count Grades 1-12 - October Count Kindergarten - February Count Grades 1-12 - February Count

2,596,835
167 2,030 167 2,030

2,429,875
167 2,022 167 2,022

1,930,923
167 2,019 167 2,019

1,158,746
167 2,029 167 2,029

19,925
167 2,033 167 2,033

-41.3%
0.0% 0.0% 0.0% 0.0%

5.7% -2.7% 23.8% -3.2%

See accompanying summary of significant forecast assumptions and accounting policies Includes: General fund, Emergency Levy fund, DPIA fund, Textbook fund and any portion of Debt Service fund related to General fund debt

Bellevue City Schools
Huron County

Schedule of Percentage Changes of Revenues, Expenditures and Changes in Fund Balances For the Forecasted Fiscal Years Ending June 30, 2009 Through 2013

Forecasted
Historical Annual Average Change Revenues General Property Tax (Real Estate) Tangible Personal Property Tax Income Tax Unrestricted Grants-in-Aid Restricted Grants-in-Aid Property Tax Allocation All Other Revenues Fiscal Year 2009 Fiscal Year 2010 $6,246,160 27,804 1,300,761 9,000,000 121,824 885,000 811,064 Percent Change 1.5% -91.2% 3.0% 4.7% 1.5% 0.0% -3.7% Fiscal Year 2011 $6,311,143 13,902 1,339,784 9,475,000 123,651 885,000 790,064 Percent Change 1.0% -50.0% 3.0% 5.3% 1.5% 0.0% -2.6% Fiscal Year 2012 $5,962,353 1,087,437 9,740,000 125,506 885,000 790,064 Percent Change -5.5% -100.0% -18.8% 2.8% 1.5% 0.0% 0.0% Fiscal Year 2013 $5,633,899 Percent Change -5.5% 0.0% -100.0% 2.0% 1.5% 0.0% 0.0%

Total Revenues
Other Financing Sources Proceeds from Sale of Notes State Emergency Loans and Advancements (Approved) Operating Transfers-In Advances-In All Other Financing Sources Total Other Financing Sources

2.8% $6,153,612 -19.2% 315,534 6.9% 1,262,875 2.0% 8,597,805 9.0% 120,024 7.8% 885,000 13.1% 842,064 3.2% 18,176,914 0.0% 0.0% 0.0% 150.4% 181.5% 93.1% 3.5% 1.2% -1.1% 9.1% 26.1% 74.3% 0.0% 0.0% -74.0% 0.0% 0.0% 0.0% 0.0% -89.8% 2.1% 2.3% -18.9% 140.1% 0.0% 112.0% 2.4%

9,935,000 127,389 885,000 790,064

18,392,613

1.2%
0.0% 0.0% 0.0% 37.7% 0.0%

18,938,545

3.0%
0.0% 0.0% 0.0% 0.0% 0.0%

18,590,360

-1.8%
0.0% 0.0% 0.0% 0.0% 0.0%

17,371,352

-6.6%
0.0% 0.0% 0.0% 0.0% 0.0%

72,648 2,000

100,000 2,000

100,000 2,000

100,000 2,000

100,000 2,000

Total Revenues and Other Financing Sources
Expenditures Personal Services Employees' Retirement/Insurance Benefits Purchased Services Supplies and Materials Capital Outlay Intergovernmental Debt Service: Principal-All (Historical Only) Principal-Notes Principal-State Loans Principal-State Advancements Principal-HB 264 Loans Principal-Other Interest and Fiscal Charges Other Objects

74,648 19,333,672
11,706,843 3,805,538 2,732,583 867,955 41,000

102,000 19,256,854
12,250,111 3,925,616 2,787,235 926,994 25,000

36.6% -0.4%
4.6% 3.2% 2.0% 6.8% -39.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 1.0%

102,000 19,571,144
12,670,957 4,111,010 2,815,107 936,264 25,000

0.0% 1.6%
3.4% 4.7% 1.0% 1.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 1.0%

102,000 19,203,820
13,052,935 4,282,032 2,843,258 945,627 25,000

0.0% -1.9%
3.0% 4.2% 1.0% 1.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 1.0%

102,000 17,944,070
13,429,247 4,495,603 2,871,691 955,083 25,000

0.0% -6.6%
2.9% 5.0% 1.0% 1.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 1.0%

287,150

290,022

292,922

295,851

298,809

Total Expenditures
Other Financing Uses Operating Transfers-Out Advances-Out All Other Financing Uses Total Other Financing Uses

19,441,069
10,000 100,000 500

20,204,977
10,000 100,000 500

3.9%
0.0% 0.0% 0.0%

20,851,260
10,000 100,000 500

3.2%
0.0% 0.0% 0.0%

21,444,703
10,000 100,000 500

2.8%
0.0% 0.0% 0.0%

22,075,433
10,000 100,000 500

2.9%
0.0% 0.0% 0.0%

Total Expenditures and Other Financing Uses Excess of Revenues and Other Financing Sources over (under) Expenditures and Other Financing Uses Cash Balance July 1 - Excluding Proposed Renewal/Replacement and New Levies Cash Balance June 30 Estimated Encumbrances June 30
Reservation of Fund Balance Textbooks and Instructional Materials Capital Improvements Budget Reserve DPIA Debt Service Property Tax Advances Bus Purchases

110,500 19,551,569

110,500 20,315,477

0.0% 3.9%

110,500 20,961,760

0.0% 3.2%

110,500 21,555,203

0.0% 2.8%

110,500 22,185,933

0.0% 2.9%

-247.2%

217,8972,368,900 2,151,003

1,058,6232,151,003 1,092,380

385.8% -9.2% -49.2% 0.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%

1,390,6161,092,380 298,236-

31.4% -49.2% -127.3% 0.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%

2,351,383298,2362,649,619-

69.1% -127.3% 788.4% 0.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%

4,241,8632,649,6196,891,482-

80.4% 788.4% 160.1% 0.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%

8.0% 17.0% 58.5% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 16.6% 0.0% 0.0% 0.0%

Subtotal Fund Balance June 30 for Certification of
Revenue from Replacement/Renewal Levies Income Tax - Renewal Property Tax - Renewal or Replacement

0.0% 2,151,003 1,092,380 -49.2%
0.0% 0.0%

0.0% 298,236-127.3%
0.0% 0.0%

0.0% 2,649,619292,541 395,001

0.0% 6,891,4821,421,377 790,002

788.4%
0.0% 0.0%

160.1%
385.9% 100.0%

Cumulative Balance of Replacement/Renewal Levies Fund Balance June 30 for Certification of Contracts, Salary Schedules and Other Obligations

0.0%

0.0%

687,542

0.0%

2,898,921

321.6%

16.6% Revenue from New Levies Income Tax - New Property Tax - New

2,151,003

1,092,380

-49.2%

298,236-

-127.3%

1,962,077-

557.9%

3,992,561-

103.5%

0.0% 0.0% 0.0% 0.0% 16.6%

445,832

891,664

0.0% 100.0%

891,664

0.0% 0.0%

891,664

0.0% 0.0%

891,664

0.0% 0.0%

Cumulative Balance of New Levies
Revenue from Future State Advancements

445,832

1,337,496

200.0%
0.0%

2,229,159

66.7%
0.0%

3,120,823

40.0%
0.0%

4,012,487

28.6%
0.0%

Unreserved Fund Balance June 30
ADM Forecasts Kindergarten - October Count Grades 1-12 - October Count Kindergarten - February Count Grades 1-12 - February Count

2,596,835

2,429,875

-6.4%

1,930,923

-20.5%

1,158,746

-40.0%

19,925

-98.3%

5.7% -2.7% 23.8% -3.2%

167 2,030 167 2,030

167 2,022 167 2,022

0.0% -0.4% 0.0% -0.4%

167 2,019 167 2,019

0.0% -0.1% 0.0% -0.1%

167 2,029 167 2,029

0.0% 0.5% 0.0% 0.5%

167 2,033 167 2,033

0.0% 0.2% 0.0% 0.2%

See accompanying summary of significant forecast assumptions and accounting policies Includes: General fund, Emergency Levy fund, DPIA fund, Textbook fund and any portion of Debt Service fund related to General fund debt

Total Expenditures, Revenues and Fund Balances
Thousands
25,000

20,000

15,000

10,000

5,000

0

5,000-

10,000-

Total Revenues Total Expenditures Excess Revenues over (under) Expenditures Cash Balance June 30 Fund Balance June 30 for Certification of Appro Unreserved Fund Balance June 30

Revenues by Source
Thousands $20,000 $18,000 $16,000 $14,000 $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 $

Total Other Financing Sources All Other Revenues Property Tax Allocation Restricted Grants-in-Aid Unrestricted Grants-in-Aid/State Reimb Offset-Tang Pers Income Tax Tangible Personal Property Tax

Expenditures by Category
Thousands

25,000

20,000

15,000

10,000

5,000

0 2006 2007 2008 2009 2010 2011 2012 2013

Total Other Financing Uses Capital Outlay Employees' Retirement/Insurance Benefits

Other Objects Supplies and Materials Personal Services

Intergovernmental Purchased Services


				
DOCUMENT INFO
Shared By:
Tags: Five-, Year-
Stats:
views:74
posted:11/28/2009
language:English
pages:15
Description: Five-Year-Financial-Forecast