Notes to capital project by Rabia06

VIEWS: 162 PAGES: 12

									                       Worksheet for Determining Preliminary Rating Under The                                 Release 1.0
                             Financial Integrity Rating System of Texas                                         8/14/2006
                              (2007-08 Rating Based on 2006-07 Data)
                    Commissioner's Rules (Proposed Effective Date: August 13, 2006)
                        By Omar Garcia, Director, Statewide Finance Initiative
                                Region XIII Education Service Center


The 77th Legislative Session directed the commissioner of education, in consultation of the Comptroller's
office, to "...develop and implement a financial accountability rating system for school districts in this state."
In response to this directive, the Texas Education Agency (TEA) developed the Financial Integrity Rating System
of Texas (FIRST), which was fully implemented in the 2003-04 school year using 2002-03 data.

This template was developed to allow districts to determine what their 2007-08 rating might be (using 2006-07 data)
under the Commissioner's rules currently estimated to take effect August 13, 2006. This template is NOT
intended to produce THE OFFICIAL rating, but should produce the same rating as THE OFFICIAL rating if the
data that TEA will use and the data that are entered in the "Data Entry" section of this template are the same.
Exception: For Indicator #7, the comparison of Schedule C-2 expenditures to like data reported to PEIMS
is done in aggregate by fund on this template in order to keep from having multitudes of data entry cells.
TEA will do the actual comparison by function by fund.

If you have any questions on the use of this template, you can call me at 512-919-5349 or
e-mail me at omar.garcia@esc13.txed.net.




       10/26/2011
Financial Integrity Rating System of Texas                                                                               Release 1.0
Data Entry Requirements for Preliminary 2007-08 Rating                                                                     8/14/2006
District:    Enter District Name Here

  Data for
 Indicator                                                       Required Data                                          Entry
  1,21,22     Total Fund Balance, General Fund on 6/30/07 or 8/31/07                                                              0
      1       Total Reserved Fund Balance, General Fund on 6/30/07 or 8/31/07                                                     0
     22       Total Designated Fund Balance in the General Fund on 6/30/07 or 8/31/07                                             0
     22       Total Unreserved, Undesignated Fund Balance, General Fund on 6/30/07 or 8/31/07                                     0
     22       Total Unreserved, Undesignated Fund Balance, General Fund on 6/30/05 or 8/31/05                                     0
      2       Total Net Asset Balance in the Governmental Activities column in Exhibit A -1                                       0
      2       Accretion of Interest for Capital Appreciation Bonds                                                                0
      8       2004-05 Total Tax Collections (M&O + I&S + delinquent taxes)                                                        0
      8       2004-05 Total Tax Levy                                                                                              0
      8       2005-06 Total Tax Collections (M&O + I&S + delinquent taxes)                                                        0
      8       2005-06 Total Tax Levy                                                                                              0
    8,13      2006-07 Total Tax Collections (M&O + I&S + delinquent taxes)                                                        0
      8       2006-07 Total Tax Levy                                                                                              0
     12       2006-07 Total Expenditures, General Fund, Reported to PEIMS                                                         0
     12       2006-07 Total Expenditures, Special Revenue Fund, Reported to PEIMS                                                 0
     12       2006-07 Total Expenditures, Capital Projects Fund, Reported to PEIMS                                                0
     12       2006-07 Total Expenditures, Debt Service Fund, Reported to PEIMS                                                    0
     12       2006-07 Total Expenditures, General Fund, Reported in Schedule C-2                                                  0
     12       2006-07 Total Expenditures, Special Revenue Fund, Reported in Schedule C-2                                          0
     12       2006-07 Total Expenditures, Capital Projects Fund, Reported in Schedule C-2                                         0
     12       2006-07 Total Expenditures, Debt Service Fund, Reported in Schedule C-2                                             0
     13       2006-07 Total Tax Rate in Pennies (i.e., $1.50 tax rate = 150 pennies)                                              0
     10       2006-07 Expenditures, General Fund - Function 71, excluding Object Codes 6524 and 6525                              0
     10       2006-07 Expenditures, Debt Service Fund - Function 71, excluding Object Codes 6524 and 6525                         0
     10       2006-07 EDA Allotment                                                                                               0
     10       2006-07 IFA Allotment                                                                                               0
     13       2002-03 Enrollment                                                                                                  0
   13,14      2006-07 Expenditures, General Fund - Function 11, Object Codes 6112 - 6499                                          0
     14       2006-07 Expenditures, General Fund - Function 12, Object Codes 6112 - 6499                                          0
   13,14      2006-07 Expenditures, General Fund - Function 36, Object Codes 6112 - 6499                                          0
   13,14      2006-07 Expenditures, General Fund - Function 93, Object Codes 6112 - 6499                                          0
   13,14      2006-07 Expenditures, General Fund - Function 95, Object Codes 6112 - 6499                                          0
     14       2006-07 Expenditures, General Fund - Function 31, Object Codes 6112 - 6499                                          0
     14       2006-07 Expenditures, General Fund - Function 33, Object Codes 6112 - 6499                                          0
     13       2006-07 Expenditures, Sp Rev Fund (exclude SSA Fund Codes) - Function 11, Obj Codes 6112 - 6499                     0
     14       2006-07 Expenditures, Sp Rev Fund (exclude SSA Fund Codes) - Function 12, Obj Codes 6112 - 6499                     0
   13,14      2006-07 Expenditures, Sp Rev Fund (exclude SSA Fund Codes) - Function 36, Obj Codes 6112 - 6499                     0
   13,14      2006-07 Expenditures, Sp Rev Fund (exclude SSA Fund Codes) - Function 93, Obj Codes 6112 - 6499                     0
   13,14      2006-07 Expenditures, Sp Rev Fund (exclude SSA Fund Codes) - Function 95, Obj Codes 6112 - 6499                     0
     14       2006-07 Expenditures, Sp Rev Fund (exclude SSA Fund Codes) - Function 31, Obj Codes 6112 - 6499                     0
     14       2006-07 Expenditures, Sp Rev Fund (exclude SSA Fund Codes) - Function 33, Obj Codes 6112 - 6499                     0
     13       2006-07 Expenditures, Capital Projects Fund - Function 11, Object Codes 6112 - 6499                                 0
     14       2006-07 Expenditures, Capital Projects Fund - Function 12, Object Codes 6112 - 6499                                 0
   13,14      2006-07 Expenditures, Capital Projects Fund - Function 36, Object Codes 6112 - 6499                                 0
   13,14      2006-07 Expenditures, Capital Projects Fund - Function 93, Object Codes 6112 - 6499                                 0
   13,14      2006-07 Expenditures, Capital Projects Fund - Function 95, Object Codes 6112 - 6499                                 0
     14       2006-07 Expenditures, Capital Projects Fund - Function 31, Object Codes 6112 - 6499                                 0
     14       2006-07 Expenditures, Capital Projects Fund - Function 33, Object Codes 6112 - 6499                                 0
   13,14      2006-07 Exp, Gen Op Fund - Functions 11 - 61, and 93 and 95, Obj Codes 6112 - 6499 (see Data Source)                0
   13,14      2006-07 Exp, Sp Rev Fund - Functions 11 - 61, and 93 and 95, Obj Codes 6112 - 6499 (see Data Source)                0
   13,14      2006-07 Exp, Fund 701 - Functions 11 - 61, and 93 and 95, Obj Codes 6112 - 6499 (see Data Source)                   0
     15       2006-07 Total Budgeted Expenditures, General Fund                                                                   0
     15       2006-07 Total Budgeted Other Uses, General Fund                                                                     0
     15       2006-07 Total Budgeted Revenues, General Fund                                                                       0
     15       2006-07 Total Budgeted Other Resources, General Fund                                                                0
   15,16      Fund Balance, General Fund as of 7/1/06 or 9/1/06                                                                   0
     16       Fund Balance, Capital Projects Fund as of 7/1/06 or 9/1/06                                                          0
     16       2006-07 Expenditures, General Fund - Function 81                                                                    0
     16       2006-07 Expenditures, Capital Projects Fund - Function 81                                                           0
     16       2006-07 Other Resources for Real Property Financing, General Fund                                                   0
     16       2006-07 Other Resources for Real Property Financing, Capital Projects Fund                                          0
     17       Deferred Revenues, General Fund as of 6/30/07 or 8/31/07                                                            0
     17       Net Delinquent Taxes Receivable as of 6/30/07 or 8/31/07                                                            0
     18       2006-07 Administrative Cost Ratio                                                                              0.0000
10,19,20,24   2006-07 Enrollment                                                                                                  0
     19       2006-07 Teacher FTEs                                                                                                0
     20       2006-07 Total Staff                                                                                                 0
     23       2006-07 Total Amount Needed to Cover Cash Flow Deficit in General Fund                                              0
     23       2006-07 Estimate of One Month's Cash Disbursement During Regular Session (9/1 - 5/31)                               0
     22       2006-07 Total Actual Revenues, General Fund                                                                         0
     22       2006-07 Total Expenditures, General Fund, Functions 11-61, Object Codes 6100 - 6400                                 0
   17,23      Cash and Investments, General Fund                                                                                  0
     24       2006-07 Investment Earnings, All Funds Except Debt Service and Capital Projects Fund                                0

                                                 ANSWER THE FOLLOWING QUESTIONS:

                                                           Questions Requiring Response                              Enter Y or N
    3         Were there no disclosures in the Annual Financial Report and/or other sources of
              information concerning default on bonded indebtedness obligations?
    4         Was the Annual Financial Report filed within one month after November 27th or
              January 28th deadline depending upon the district's fiscal year end date
              (June 30th or August 31st)?
    5         Was there an unqualified opinion in the Annual Financial Report?
    6         Did the Annual Financial Report not disclose any instance(s) of material weaknesses in
              internal controls?
     7        Did the district's academic rating exceed Academically Unacceptable?
    11        Was there no disclosure in the Annual Audit Report of material noncompliance?
    12        Did the district have full accreditation status in relation to financial management
              practices?
    18        Did district qualify for the sparsity adjustment?
Financial Integrity Rating System of Texas (FIRST) -- Preliminary Rating for                                                        Release 1.0
School Year 2007-2008 Using Data for Fiscal Year Ended August 31, 2007                                                                8/14/2006
District: Enter District Name Here

    #                                     Indicators                                    Y or N Answer      Result
                                     Critical Indicators
    1     Was the total fund balance less reserved fund balance greater                            N                     0
          than zero in the General Fund?

    2     Was the Total Unreserved Net Asset Balance (Net of the Accretion of                      N                     0
          Interest for Capital Appreciation Bonds) in the Governmental Activities
          column in the Statement of Net Assets greater than zero?
          (If the district's five-year percent change in students was a 10%
          increase or more, then the answer is 'yes')

    3     Were there no disclosures in the Annual Financial Report and/or                0         0        N/A
          other sources of information concerning default on bonded
          indebtedness obligations?

    4     Was the Annual Financial Report filed within one month after                   0         0        N/A
          November 27th or January 28th deadline depending upon the
          district's fiscal year end date (June 30th or August 31st)?

    5     Was there an unqualified opinion in the Annual Financial Report?               0         0        N/A

    6     Did the Annual Financial Report not disclose any instance(s) of                0         0        N/A
          material weaknesses in internal controls?

                     Fiscal Responsibility and Academic Performance                                                           Points Awarded
    7     Did the district's academic rating exceed Academically                         0         0        N/A                      0
          Unacceptable?

    8     Was the three-year average percent of total tax collections (including       #DIV/0!   #DIV/0!            #DIV/0!      #DIV/0!
          delinquent) greater than 98%?

    9     Did the comparison of PEIMS data to like information in Annual                 Y                  N/A                     5
          Financial Report result in an aggregate variance of less than 3
          percent of expenditures per Fund Type (data quality measure)?

   10     Were debt related expenditures (net of IFA and/or EDA allotment)             #DIV/0!   #DIV/0!            #DIV/0!      #DIV/0!
          less than $250.00 per student? (if the district's five-year percent change
          in students was a 7% increase or more, or if property taxes collected
          per penny of tax effort were more than $200,000, then the district
Financial Integrity Rating System of Texas (FIRST) -- Preliminary Rating for                                                   Release 1.0
School Year 2007-2008 Using Data for Fiscal Year Ended August 31, 2007                                                           8/14/2006
District: Enter District Name Here

    #                                       Indicators                                Y or N Answer      Result
          receives 5 points)

   11     Was there no disclosure in the Annual Audit Report of material               0         0        N/A                 0
          noncompliance?

   12     Did the district have full accreditation status in relation to financial     0         0        N/A                 0
          management practices? (e.g., no master or monitor assigned)

                                        Budgeting
   13     Was the percent of operating expenditures expended for instruction         #DIV/0!   #DIV/0!            #DIV/0!   #DIV/0!
          more than or equal to 65%? (Functions 11, 36, 93, and 95) (phased in
          over three years: 55% for 2006-07; 60% for 2007-08; and 65% for
          2008-09)

   14     Was the percent of operating expenditures expended for instruction         #DIV/0!   #DIV/0!            #DIV/0!   #DIV/0!
          more than or equal to 65%? (Functions 11, 12, 31, 33, 36, 93, and 95)

   15     Was the aggregate of budgeted expenditures and other uses less                         N        N/A                 0
          than the aggregate of budgeted total revenues, other resources and
          fund balance in General Fund?

   16     If the district's aggregate fund balance in the General Fund and                       N        N/A                 0
          Capital Projects Fund was less than the zero, were construction
          projects adequately financed? (were construction projects adequately
          financed or adjusted by change orders of other legal means to avoid
          creating or adding to the fund balance deficit situation?)

   17     Was ratio of cash and investments to deferred revenues (excluding            Y                 0.00                 0
          amount equal to net delinquent taxes receivable) in the General
          Fund greater than or equal to 1:1? (if deferred revenues are less than
          net delinquent taxes receivable, then the district receives 5 points)

                                         Personnel
   18     Was the administrative cost ratio less than the threshold ratio?                       N                0.0000      0
          (see ranges below)

   19     Was the ratio of students to teachers within the ranges shown below        #DIV/0!   #DIV/0!            #DIV/0!   #DIV/0!
          according to district size? (see ranges below)
Financial Integrity Rating System of Texas (FIRST) -- Preliminary Rating for                                                      Release 1.0
School Year 2007-2008 Using Data for Fiscal Year Ended August 31, 2007                                                              8/14/2006
District: Enter District Name Here

    #                                     Indicators                               Y or N Answer            Result

   20     Was the ratio of students to total staff within the ranges shown        #DIV/0!   #DIV/0!                  #DIV/0!   #DIV/0!
          below according to district size? (see ranges below)

                                     Cash Management
   21     Was the total fund balance in the General Fund more than 50% and        #DIV/0!   #DIV/0!                       0    #DIV/0!
          less than 150% of optimum according to the fund balance and
          cash flow worksheet in the Annual Financial Report?

   22     Was the decrease in undesignated unreserved fund balance less             Y                                 0.00%      5
          than 20% over two fiscal years? (if 1.5 times optimum fund balance is
          less than total fund balance in General Fund or if total revenues
          exceeded operating expenditures in General Fund, then the district
          receives 5 points)

   23     Was the aggregate total of cash and investments in the General                      N                           0      0
          Fund more than $0.

   24     Were investment earnings in all funds (excluding Debt Service Fund      #DIV/0!   #DIV/0!                  #DIV/0!   #DIV/0!
          and Capital Projects Fund) more than $20.00 per student?


                                                                                                   Totals Points Awarded       #DIV/0!
Financial Integrity Rating System of Texas (FIRST) -- Preliminary Rating for                                               Release 1.0
School Year 2007-2008 Using Data for Fiscal Year Ended August 31, 2007                                                       8/14/2006
District: Enter District Name Here

    #                                   Indicators                                  Y or N Answer        Result

                              Determination of District Rating
    A.    Did the district answer No to indicators 1, 2, 3, or 4, OR both 5 and 6
          If the district answered no to either, the district's rating is Substandard Achievement

    B.    Determine rating by applicable number of points                                                 Points        RATING
          Superior Achievement                                                                      >=75 AND Yes to
                                                                                                       Indicator 7
          Above Standard Achievement                                                                  >=65 <75 OR
                                                                                                     >=75 AND No
                                                                                                      to Indicator 7
          Standard Achievement                                                                          >=55 <65

          Substandard Achievement (if less than 55 points, OR if the district answered              <55 OR answered     #DIV/0!
          No to indicators 1, 2, 3, or 4, OR both 5 and 6                                           No to one default   #DIV/0!
                                                                                                        indicator
Financial Integrity Rating System of Texas (FIRST) -- Preliminary Rating for                             Release 1.0
School Year 2007-2008 Using Data for Fiscal Year Ended August 31, 2007                                     8/14/2006
District: Enter District Name Here

    #                                   Indicators                              Y or N Answer   Result

                                       Indicator 18
                                       ADA Group                               Standard
                                     10,00 and Above                            0.1105
                                      5,000 to 9,999                            0.1250
                                      1,000 to 4,999                            0.1401
                                        500 to 999                              0.1561
                                      Less than 500                             0.2654
                                          Sparse                                0.3614
<= The red font color under the 'Indicators' column
highlights the change to the indicator that was made
from last year's version.




                                             Determination of Points
           Points……………….
                 5                 4                   3               2                 1               0
   7            Y                                                                                        N



   8           > 98            >95 =< 98         >92 =< 95         >89 =< 92         >86 =< 89          =< 86
              #DIV/0!           #DIV/0!           #DIV/0!           #DIV/0!           #DIV/0!          #DIV/0!

   9             Y                                                                                       N



   10         < $250        =>$250 < $500      =>$500 < $750    =>$750 < $1,000   =>$1,000 < $1,250   => $1,250
              #DIV/0!          #DIV/0!            #DIV/0!           #DIV/0!            #DIV/0!         #DIV/0!
11          Y                                                                                             N


12          Y                                                                                             N



13                                             => 55%           =>52% < 55%         =>50% < 52%         < 50%
                                               #DIV/0!             #DIV/0!             #DIV/0!          #DIV/0!



14                                             => 65%           =>62% < 65%         =>59% < 62%         < 59%
                                               #DIV/0!             #DIV/0!             #DIV/0!          #DIV/0!

15          Y                                                                                             N



16          Y                                                                                             N




17       => 1.00        =>0.95 < 1.00       =>0.90 < 0.95       =>0.85 < 0.90       =>0.80 < 0.85       < 0.80
                    0                   0                   0                   0                   0             0




18          Y                                                                                             N


19   UL* <= 100%        >100% =<105%        >105% =<110%        >110% =<115%        >115% =<120%        > 120%
     LL** => 100%       =>95% <100%          =>90% <95%          =>85% <90%          =>80% <85%         < 80%
20   UL* <= 100%        >100% =<105%       >105% =<110%       >110% =<115%       >115% =<120%       > 120%
     LL** => 100%       =>95% <100%         =>90% <95%         =>85% <90%         =>80% <85%        < 80%


21   UL* < 150%        >150% =<152.5% >152.5% =<155% >155% =<157.5% >157.5% =<160%                  > 160%
     LL** > 50%         >47.5% =<50%    >45% =<47.5%   >42.5% =<45%    >40% =<42.5%                 =< 40%
               #DIV/0!          #DIV/0!        #DIV/0!         #DIV/0!         #DIV/0!                   #DIV/0!

22        < 20%         =>20% < 21%        =>21% < 22%        =>22% < 23%        =>23% < 24%        => 24%
                    5                  0                  0                  0                  0             0




23          Y                                                                                         N


24        > $20          >$19 =< $20        >$18 =< $19        >$17 =< $18        >$16 =< $17       =< $16
         #DIV/0!           #DIV/0!            #DIV/0!            #DIV/0!            #DIV/0!         #DIV/0!
* UL = Upper Limit
** LL = Lower Limit



                                                                    Ranges for Ratios
                      District Size - Number of Students Between   Low               High
Indicator 19
                                                          < 500     7.0              22
                                          500               999    10.0              22
                                        1,000             4,999    11.5              22

                                        5,000             9,999    13.0              22
                                    => 10,000                      13.5              22
Indicator 20
                                                          < 500    5.0               14
      500     999   5.8   14
    1,000   4,999   6.3   14
    5,000   9,999   6.8   14
=> 10,000           7.0   14

								
To top