Five Year Financial Forecast by 0m63vv

VIEWS: 20 PAGES: 16

									Five Year Financial Forecast Spreadsheet
Instructions
     This spreadsheet was developed by the SSDT to assist school               Tip
     district's in preparing the Five Year Financial Forecast required by
     HB412 and EMIS.                                                        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              http://ssdt.oecn.k12.oh.us/forums
     which 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       will be there to help you.
     or 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:
                                                                               Be sure to download the CSV file in
     1) Run USASFF and review the report. The text report includes the
                                                                               the correct mode.
     detail budget/revenue accounts which are included in each line.
                                                                               For example, if using FTP or Kermit,
     2) Download the CSV file (USASFF.CSV) produced by USASFF to
                                                                               download the CSV file in "ASCII"
     your PC or Mac. Your OECN DAS personnel may need to help you
                                                                               mode.
     with this step.

     3) You should now have both this forecast spreadsheet and the CSV
     file open in Excel. Now do the following:
           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 F58 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.
                                                            Lucas Local Schools October-2009
                                                                                    Richland
                                                     Schedule of Revenues, Expenditures and Changes in Fund Balances
                                                      For the Fiscal Years Ended June 30, 2007, 2008 and 2009 Actual
                                                        Forecasted Fiscal Years Ending June 30, 2010 Through 2014
                                                                  Actual                                                             Forecasted
                                                   Fiscal Year    Fiscal Year   Fiscal Year    Average   Fiscal Year   Fiscal Year     Fiscal Year   Fiscal Year   Fiscal Year
                                                      2007           2008          2009        Change       2010          2011            2012          2013          2014
        Revenues
1.010   General Property Tax (Real Estate)           $1,376,205    $1,829,205    $2,153,587     25.3%    $2,155,200     $1,689,000     $1,325,200    $1,331,000    $1,342,000
1.020   Tangible Personal Property Tax                  529,794       513,391       440,487     -8.6%       441,310        340,221        265,000       275,000       275,000
1.030   Income Tax
1.035   Unrestricted Grants-in-Aid                    2,243,967     2,248,322     2,194,179     -1.1%      2,197,816     2,153,859       2,196,935     2,230,500     2,230,500
1.040   Restricted Grants-in-Aid                         11,185         6,784        18,884     69.5%          7,500         7,500           7,500         7,500         7,500
1.050   Property Tax Allocation                         215,743       289,476       367,281     30.5%        325,500       275,650         175,000       175,000       175,000
1.060   All Other Revenues                              102,530       132,555       104,500      4.1%         95,000        95,000          95,000        95,000        95,000
1.070 Total Revenues                                 4,479,424     5,019,733     5,278,918       8.6%    5,222,326      4,561,230      4,064,635     4,114,000     4,125,000
        Other Financing Sources
2.010   Proceeds from Sale of Notes
2.020   State Emergency Loans and Advancements (Approved)
2.040   Operating Transfers-In
2.050   Advances-In                               104,421              55,441            66     -73.4%        75,000        75,000          75,000        75,000        75,000
2.060   All Other Financing Sources                     1
2.070   Total Other Financing Sources             104,422              55,441            66     -73.4%        75,000        75,000          75,000        75,000        75,000
                                           4,583,846
2.080 Total Revenues and Other Financing Sources                   5,075,174     5,278,984       7.4%    5,297,326      4,636,230      4,139,635     4,189,000     4,200,000
        Expenditures
3.010   Personal Services                             2,627,067     2,668,040     2,816,828    3.6%        2,894,290     2,981,000       3,067,500     3,158,000     3,251,000
3.020   Employees' Retirement/Insurance Benefits        706,228       758,392       680,825   -1.4%          720,600       895,000         966,000     1,045,000     1,128,600
3.030   Purchased Services                              547,795       719,826       735,553   16.8%          780,300       897,300         985,000     1,085,800     1,195,000
3.040   Supplies and Materials                          130,191       148,777       141,563    4.7%          150,000       175,000         200,000       200,000       200,000
3.050   Capital Outlay                                      685         8,985        86,321 1036.2%           90,000        90,000          90,000        90,000        90,000
3.060   Intergovernmental
        Debt Service:
4.010     Principal-All (Historical Only)
4.020     Principal-Notes
4.030     Principal-State Loans
4.040     Principal-State Advancements
4.050     Principal-HB 264 Loans
4.055     Principal-Other
4.060     Interest and Fiscal Charges
4.300   Other Objects                                   134,412       164,962       180,179     16.0%       175,000        175,000        175,000       175,000       175,000
4.500 Total Expenditures                             4,146,378     4,468,982     4,641,269       5.8%    4,810,190      5,213,300      5,483,500     5,753,800     6,039,600
        Other Financing Uses
5.010   Operating Transfers-Out                                        20,000                                 50,000        50,000          50,000        50,000        50,000
5.020   Advances-Out                                    131,993        86,026        74,617     -24.0%        75,000        75,000          75,000        75,000        75,000
5.030   All Other Financing Uses
5.040   Total Other Financing Uses                      131,993       106,026        74,617     -24.6%      125,000        125,000        125,000       125,000       125,000
                                             Uses
5.050 Total Expenditures and Other Financing 4,278,371             4,575,008     4,715,886       5.0%    4,935,190      5,338,300      5,608,500     5,878,800     6,164,600

6.010 Excess of Revenues and Other
      Financing Sources over (under)                   305,475       500,166       563,098      38.2%      362,136        702,070-     1,468,865-    1,689,800-    1,964,600-
      Expenditures and Other
7.010
      Cash Balance July 1 - Excluding
      Proposed Renewal/Replacement
      and New Levies                                 1,269,681     1,575,156     2,075,322      27.9%    2,638,420      3,000,556      2,298,486       829,621       860,179-

7.020 Cash Balance June 30                           1,575,156     2,075,322     2,638,420      29.4%    3,000,556      2,298,486        829,621       860,179-    2,824,779-

8.010 Estimated Encumbrances June 30                   258,749       242,407       274,268       3.4%      250,000        250,000        250,000       250,000       250,000
        Reservation of Fund Balance
9.010     Textbooks and Instructional Materials
9.020     Capital Improvements
9.030     Budget Reserve
9.040     DPIA
9.050     Debt Service
9.060     Property Tax Advances
9.070     Bus Purchases
9.080    Subtotal
10.010 Fund Balance June 30 for                      1,316,407     1,832,915     2,364,152      34.1%    2,750,556      2,048,486        579,621     1,110,179-    3,074,779-
       Revenue from Replacement/Renewal Levies
11.010 Income Tax - Renewal
11.020 Property Tax - Renewal or Replacement

11.300 Cumulative Balance of Replacement/Renewal Levies

12.010 Fund Balance June 30 for
       Certification of Contracts, Salary
       Schedules and Other Obligations
                                                     1,316,407     1,832,915     2,364,152      34.1%    2,750,556      2,048,486        579,621     1,110,179-    3,074,779-

       Revenue from New Levies
13.010 Income Tax - New
13.020 Property Tax - New

13.030 Cumulative Balance of New Levies
14.010 Revenue from Future State Advancements
15.010 Unreserved Fund Balance June 30               1,316,407     1,832,915     2,364,152      34.1%    2,750,556      2,048,486        579,621     1,110,179-    3,074,779-
Parameters                                              SSDT Forecast Spreadsheet: Version 2.01-3
Enter the global parameters below. These values affect how the headings and
calculations function on the other sheets.




School District Name      Lancaster City Schools
County                    Fairfield
Fiscal Year                                        2005




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-3
Line                1998     1999     2000 Avg Chg          2001
        1.01    13040807 15343137 15934359        9.6   16502371
        1.02     6014389 6652416 7194470          9.3    5840637
        1.03                                        0
       1.035    12592839 13101104 13944064        5.2   15064327
        1.04      135997   229234   377327       55.2     202000
        1.05     1760595 2042767 2064045          8.5    2000000
        1.06     1032993 1497347 1234853         15.3    1200000
        1.07    34577621 38866005 40749118        8.1   40809335
        2.01                                        0
        2.02                                        0
        2.04                                        0
        2.05       21648    82179   128760     168.1      200000
        2.06      337695    13178    33723       13.4          0
        2.07      359344    95357   162483       -3.8     200000
        2.08    34936965 38961362 40911601        7.8   41009335
        3.01    22052726 23618326 24979535        6.4   26303615
        3.02     5743441 6476816 6823921          9.1    7096879
        3.03     2093170 2396146 2491404          9.2    2566145
        3.04     1160389 1432566 1511734         14.5    1557086
        3.05      710807 1656443 1392336         58.5    1400000
        3.06                                        0
        4.01                                        0
        4.02                                        0
        4.03                                        0
        4.04                                        0
        4.05                        290000          0    305000
       4.055                                        0
        4.06                         65520          0      51984
          4.3     489551   521369   508142          2     553121
          4.5   32250085 36101667 38062595        8.1   39833830
        5.01        9387     7000     4000      -34.1      10000
        5.02       82274   428760   308000     196.4      200000
        5.03        4286     6000       50      -29.6      12000
        5.04       95946   441760   312050     165.5      222000
        5.05    32346031 36543427 38374645        8.5   40055830
        6.01     2590933 2417935 2536955         -0.9     953505
        7.01     3709194 6300127 8718062         54.1   11255018
        7.02     6300127 8718062 11255017        33.7   12208523
        8.01      866994   832015 1487530        37.4     800000
        9.01                                        0
        9.02                                        0
        9.03                       1030173          0   1430173
        9.04                                        0
        9.05                                        0
        9.06                                        0
        9.07                                        0
        9.08                       1030173          0   1430173
       10.01                       8737315          0   9978350
       11.01                                        0
       11.02                                        0
        11.3                                        0
12.01   8737315   0   9978350
13.01             0
13.02             0
13.03             0
14.01             0
15.01             0
Line                1998     1999     2000 Avg Chg          2001
        1.01    13040807 15343137 15578838        9.6   15484625
        1.02     6014389 6652416 7194470          9.3    5744170   This was original data as downloaded from
        1.03                                        0              USAS files through USASFF. The DATA
       1.035    12592839 13101104 13953564        5.2   15435499   worksheet was then changed to reflect
        1.04      135997   229234   325227       55.2     184869   Roy's numbers so 2001 would match.
        1.05     1760595 2042767 2064045          8.5    2000000
        1.06     1032993 1497347 1281789         15.3    1062000
        1.07    34577621 38866005 40397932        8.1   39911163
        2.01                                        0
        2.02                                        0
        2.04                                        0
        2.05       21648    82179   128760     168.1      200000
        2.06      337695    13178    29384       13.4       2000
        2.07      359344    95357   158144       -3.8     202000
        2.08    34936965 38961362 40556076        7.8   40113163
        3.01    22052726 23618326 24979535        6.4   26328995
        3.02     5743441 6476816 6823921          9.1    7422863
        3.03     2093170 2396146 2491404          9.2    4081811
        3.04     1160389 1432566 1511734         14.5    3296948
        3.05      710807 1656443 1392336         58.5    1639297
        3.06                                        0
        4.01                                        0
        4.02                                        0
        4.03                                        0
        4.04                                        0
        4.05                                        0
       4.055                                        0
        4.06                                        0
          4.3     489551   521369   508142          2     570534
          4.5   32250085 36101667 37707071        8.1   43340448
        5.01        9387     7000     4000      -34.1     505023
        5.02       82274   428760   308000     196.4      200000
        5.03        4286     6000       50      -29.6      12000
        5.04       95946   441760   312050     165.5      717023
        5.05    32346031 36543427 38019121        8.5   44057471
        6.01     2590933 2417935 2536955         -0.9   -3944308
        7.01     3709194 6300127 8718062         54.1   11255017
        7.02     6300127 8718062 11255017        33.7    7310709
        8.01      866994   832015 1487530        37.4
        9.01                                        0
        9.02                                        0
        9.03                                        0
        9.04                                        0
        9.05                                        0
        9.06                                        0
        9.07                                        0
        9.08                                        0
       10.01                                        0
       11.01                                        0
       11.02                                        0
        11.3                                        0
12.01   0
13.01   0
13.02   0
13.03   0
14.01   0
15.01   0
original data as downloaded from
 s through USASFF. The DATA
 t was then changed to reflect
mbers so 2001 would match.
                                                    Lancaster City Schools
                                                                    Fairfield
                        Summary Forecasted Statement of Revenues, Expenditures and Changes in Fund Balances
                                      For the Fiscal Years Ending June 30, 2005 Through 2009
                                                                                                          Forecasted
                                                       Historical Annual   Fiscal Year      Fiscal Year    Fiscal Year   Fiscal Year   Fiscal Year   Average Annual
                                                       Average Change         2005             2006           2007          2008          2009          Change
Revenues
General Property Tax (Real Estate)                                25.3%     $2,155,200      $1,689,000      $1,325,200   $1,331,000     $1,342,000           -10.5%
Tangible Personal Property Tax                                    -8.6%        441,310         340,221         265,000      275,000        275,000           -10.3%
Income Tax                                                         0.0%                                                                                        0.0%
Unrestricted Grants-in-Aid                                        -1.1%         2,197,816     2,153,859      2,196,935     2,230,500     2,230,500             0.4%
Restricted Grants-in-Aid                                          69.5%             7,500         7,500          7,500         7,500         7,500             0.0%
Property Tax Allocation                                           30.5%           325,500       275,650        175,000       175,000       175,000           -13.0%
All Other Revenues                                                 4.1%            95,000        95,000         95,000        95,000        95,000             0.0%
Total Revenues                                                    8.6%     5,222,326         4,561,230      4,064,635     4,114,000     4,125,000            -5.5%
Other Financing Sources
Proceeds from Sale of Notes                                        0.0%                                                                                        0.0%
State Emergency Loans and Advancements (Approved)                  0.0%                                                                                        0.0%
Operating Transfers-In                                             0.0%                                                                                        0.0%
Advances-In                                                      -73.4%           75,000         75,000         75,000        75,000        75,000             0.0%
All Other Financing Sources                                        0.0%                                                                                        0.0%
Total Other Financing Sources                                    -73.4%        75,000           75,000         75,000        75,000        75,000             0.0%
Total Revenues and Other Financing Sources                        7.4%      5,297,326        4,636,230      4,139,635     4,189,000     4,200,000                 -
Expenditures
Personal Services                                                 3.6%          2,894,290     2,981,000      3,067,500     3,158,000     3,251,000             2.9%
Employees' Retirement/Insurance Benefits                         -1.4%            720,600       895,000        966,000     1,045,000     1,128,600            12.1%
Purchased Services                                               16.8%            780,300       897,300        985,000     1,085,800     1,195,000            11.3%
Supplies and Materials                                            4.7%            150,000       175,000        200,000       200,000       200,000             7.7%
Capital Outlay                                                 1036.2%             90,000        90,000         90,000        90,000        90,000             0.0%
Intergovernmental                                                 0.0%                                                                                         0.0%
Debt Service:
  Principal-All (Historical Only)                                  0.0%                                                                                        0.0%
  Principal-Notes                                                  0.0%                                                                                        0.0%
  Principal-State Loans                                            0.0%                                                                                        0.0%
  Principal-State Advancements                                     0.0%                                                                                        0.0%
  Principal-HB 264 Loans                                           0.0%                                                                                        0.0%
  Principal-Other                                                  0.0%                                                                                        0.0%
  Interest and Fiscal Charges                                      0.0%                                                                                        0.0%
Other Objects                                                     16.0%          175,000        175,000        175,000       175,000       175,000             0.0%
Total Expenditures                                                 5.8%     4,810,190        5,213,300      5,483,500     5,753,800     6,039,600             5.9%
Other Financing Uses
Operating Transfers-Out                                            0.0%           50,000         50,000         50,000        50,000        50,000        49999.0%
Advances-Out                                                     -24.0%           75,000         75,000         75,000        75,000        75,000        74999.0%
All Other Financing Uses                                           0.0%                                                                                       0.0%
Total Other Financing Uses                                       -24.6%       125,000          125,000        125,000       125,000       125,000       124999.0%
Total Expenditures and Other Financing Uses                        5.0%     4,935,190        5,338,300      5,608,500     5,878,800     6,164,600          57,475

Excess of Revenues and Other Financing Sources
over (under) Expenditures and Other Financing Uses                38.2%         362,136        702,070-     1,468,865-    1,689,800-    1,964,600-                -
Cash Balance July 1 - Excluding Proposed
Renewal/Replacement and New Levies                                27.9%     2,638,420        3,000,556      2,298,486       829,621       860,179-           -69.3%

Cash Balance June 30                                              29.4%     3,000,556        2,298,486        829,621       860,179-    2,824,779-          -15.6%

Estimated Encumbrances June 30                                     3.4%         250,000        250,000        250,000       250,000       250,000              0.0%
Reservation of Fund Balance
  Textbooks and Instructional Materials                            0.0%                                                                                        0.0%
  Capital Improvements                                             0.0%                                                                                        0.0%
  Budget Reserve                                                   0.0%                                                                                        0.0%
  DPIA                                                             0.0%                                                                                        0.0%
  Debt Service                                                     0.0%                                                                                        0.0%
  Property Tax Advances                                            0.0%                                                                                        0.0%
  Bus Purchases                                                    0.0%                                                                                        0.0%
 Subtotal                                                          0.0%                                                                                       0.0%
Fund Balance June 30 for Certification of                         34.1%     2,750,556        2,048,486        579,621     1,110,179-    3,074,779-          -53.0%
Revenue from Replacement/Renewal Levies
 Income Tax - Renewal                                              0.0%                                                                                        0.0%
 Property Tax - Renewal or Replacement                             0.0%                                                                                        0.0%

Cumulative Balance of Replacement/Renewal Levies                   0.0%                                                                                        0.0%

Fund Balance June 30 for Certification of Contracts,
Salary Schedules and Other Obligations
                                                                  34.1%     2,750,556        2,048,486        579,621     1,110,179-    3,074,779-          -53.0%

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

Cumulative Balance of New Levies                                   0.0%                                                                                       0.0%
Revenue from Future State Advancements                             0.0%                                                                                        0.0%

Unreserved Fund Balance June 30                                   34.1%     2,750,556        2,048,486        579,621     1,110,179-    3,074,779-          -53.0%
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
                                                                               Lancaster City Schools
                                                                                             Fairfield
                                               Schedule of Percentage Changes of Revenues, Expenditures and Changes in Fund Balances
                                                          For the Forecasted Fiscal Years Ending June 30, 2005 Through 2009

                                                                                                                            Forecasted
                                                       Historical Annual   Fiscal Year   Fiscal Year     Percent    Fiscal Year    Percent    Fiscal Year    Percent   Fiscal Year   Percent
                                                       Average Change         2005          2006         Change        2007        Change        2008        Change       2009       Change
Revenues
General Property Tax (Real Estate)                                25.3%     $2,155,200    $1,689,000       -21.6%    $1,325,200      -21.5%    $1,331,000       0.4%    $1,342,000      0.8%
Tangible Personal Property Tax                                    -8.6%        441,310       340,221       -22.9%       265,000      -22.1%       275,000       3.8%       275,000      0.0%
Income Tax                                                         0.0%                                      0.0%                      0.0%                     0.0%                    0.0%
Unrestricted Grants-in-Aid                                        -1.1%      2,197,816      2,153,859       -2.0%      2,196,935       2.0%      2,230,500      1.5%     2,230,500      0.0%
Restricted Grants-in-Aid                                          69.5%          7,500          7,500        0.0%          7,500       0.0%          7,500      0.0%         7,500      0.0%
Property Tax Allocation                                           30.5%        325,500        275,650      -15.3%        175,000     -36.5%        175,000      0.0%       175,000      0.0%
All Other Revenues                                                 4.1%         95,000         95,000        0.0%         95,000       0.0%         95,000      0.0%        95,000      0.0%
Total Revenues                                                     8.6%    5,222,326       4,561,230       -12.7%     4,064,635     -10.9%     4,114,000        1.2%    4,125,000       0.3%
Other Financing Sources
Proceeds from Sale of Notes                                        0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
State Emergency Loans and Advancements (Approved)                  0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
Operating Transfers-In                                             0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
Advances-In                                                      -73.4%         75,000         75,000        0.0%         75,000      0.0%          75,000      0.0%        75,000      0.0%
All Other Financing Sources                                        0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
Total Other Financing Sources                                    -73.4%        75,000         75,000         0.0%        75,000       0.0%        75,000        0.0%       75,000       0.0%
Total Revenues and Other Financing Sources                         7.4%     5,297,326      4,636,230       -12.5%     4,139,635     -10.7%     4,189,000        1.2%    4,200,000       0.3%
Expenditures
Personal Services                                                 3.6%       2,894,290      2,981,000        3.0%      3,067,500      2.9%       3,158,000      3.0%     3,251,000      2.9%
Employees' Retirement/Insurance Benefits                         -1.4%         720,600        895,000       24.2%        966,000      7.9%       1,045,000      8.2%     1,128,600      8.0%
Purchased Services                                               16.8%         780,300        897,300       15.0%        985,000      9.8%       1,085,800     10.2%     1,195,000     10.1%
Supplies and Materials                                            4.7%         150,000        175,000       16.7%        200,000     14.3%         200,000      0.0%       200,000      0.0%
Capital Outlay                                                 1036.2%          90,000         90,000        0.0%         90,000      0.0%          90,000      0.0%        90,000      0.0%
Intergovernmental                                                 0.0%                                       0.0%                     0.0%                      0.0%                    0.0%
Debt Service:                                                                                                0.0%                     0.0%                      0.0%                    0.0%
  Principal-All (Historical Only)                                  0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
  Principal-Notes                                                  0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
  Principal-State Loans                                            0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
  Principal-State Advancements                                     0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
  Principal-HB 264 Loans                                           0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
  Principal-Other                                                  0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
  Interest and Fiscal Charges                                      0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
Other Objects                                                     16.0%        175,000        175,000        0.0%        175,000      0.0%         175,000      0.0%       175,000      0.0%
Total Expenditures                                                 5.8%     4,810,190      5,213,300         8.4%     5,483,500       5.2%     5,753,800        4.9%    6,039,600       5.0%
Other Financing Uses
Operating Transfers-Out                                            0.0%         50,000         50,000        0.0%         50,000      0.0%          50,000      0.0%        50,000      0.0%
Advances-Out                                                     -24.0%         75,000         75,000        0.0%         75,000      0.0%          75,000      0.0%        75,000      0.0%
All Other Financing Uses                                           0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
Total Other Financing Uses                                       -24.6%       125,000        125,000         0.0%       125,000       0.0%       125,000        0.0%      125,000       0.0%
Total Expenditures and Other Financing Uses                        5.0%     4,935,190      5,338,300         8.2%     5,608,500       5.1%     5,878,800        4.8%    6,164,600       4.9%

Excess of Revenues and Other Financing Sources
over (under) Expenditures and Other Financing Uses                38.2%       362,136        702,070-     -293.9%     1,468,865-   109.2%      1,689,800-     15.0%     1,964,600-    16.3%

Cash Balance July 1 - Excluding Proposed
Renewal/Replacement and New Levies                                27.9%     2,638,420      3,000,556        13.7%     2,298,486     -23.4%        829,621     -63.9%      860,179-   -203.7%

Cash Balance June 30                                              29.4%     3,000,556      2,298,486       -23.4%       829,621     -63.9%        860,179-   -203.7%    2,824,779-   228.4%

Estimated Encumbrances June 30                                     3.4%       250,000        250,000         0.0%       250,000       0.0%        250,000       0.0%      250,000       0.0%
Reservation of Fund Balance
  Textbooks and Instructional Materials                            0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
  Capital Improvements                                             0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
  Budget Reserve                                                   0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
  DPIA                                                             0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
  Debt Service                                                     0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
  Property Tax Advances                                            0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
  Bus Purchases                                                    0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
 Subtotal                                                          0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
Fund Balance June 30 for Certification of                         34.1%     2,750,556      2,048,486       -25.5%       579,621     -71.7%     1,110,179-    -291.5%    3,074,779-   177.0%
Revenue from Replacement/Renewal Levies
 Income Tax - Renewal                                              0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
 Property Tax - Renewal or Replacement                             0.0%                                      0.0%                     0.0%                      0.0%                    0.0%

Cumulative Balance of Replacement/Renewal Levies                   0.0%                                      0.0%                     0.0%                      0.0%                    0.0%

Fund Balance June 30 for Certification of Contracts,
Salary Schedules and Other Obligations
                                                                  34.1%     2,750,556      2,048,486       -25.5%       579,621     -71.7%     1,110,179-    -291.5%    3,074,779-   177.0%

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

Cumulative Balance of New Levies                                   0.0%                                      0.0%                     0.0%                      0.0%                    0.0%
Revenue from Future State Advancements                             0.0%                                      0.0%                     0.0%                      0.0%                    0.0%

Unreserved Fund Balance June 30                                   34.1%     2,750,556      2,048,486       -25.5%       579,621     -71.7%     1,110,179-    -291.5%    3,074,779-   177.0%
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

                                                                                 8,000




                                                                     Thousands
                                                                                 6,000



                                                                                 4,000



                                                                                 2,000



                                                                                     0



                                                                                 2,000-



                                                                                 4,000-




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




                                                                                                                                                                                  Expenditures by Category
                                           Revenues by Source
                                                                                                                                                         7,000




                                                                                                                                             Thousands
            $6,000
Thousands




                                                                                                                                                         6,000
            $5,000
                                                                                                                                                         5,000
            $4,000
                                                                                                                                                         4,000
            $3,000
                                                                                                                                                         3,000
            $2,000
                                                                                                                                                         2,000
            $1,000
                                                                                                                                                         1,000
                $
                                                                                                                                                             0
                                                                                                                                                                 2007          2008   2009   2010   2011         2012             2013      2014
                General Property Tax (Real Estate)    Tangible Personal Property Tax
                Income Tax                            Unrestricted Grants-in-Aid                                                                           Personal Services                         Employees' Retirement/Insurance Benefits
                Restricted Grants-in-Aid              Property Tax Allocation
                                                                                                                                                           Purchased Services                        Supplies and Materials
                All Other Revenues                    Total Other Financing Sources
                                                                                                                                                           Capital Outlay                            Intergovernmental

                                                                                                                                                           Other Objects                             Total Other Financing Uses

								
To top