DISTRICT CODE:  630202                                     STATE AID    2007-08     
DISTRICT NAME:  NORTH WARREN                               DATE:  OCT  29, 2015     
                                                           EDITION NO.     4392     
DISTRICT LAST UPDATED ON 10/27/15                                                   
NOTE: DATA DISPLAYED IS TENTATIVE PENDING AUDIT                                     
                                                                                    
GENERAL FORMULA AID OUTPUT REPORT (GEN)                                  PAGE 1     
                                                                                    
PART I:  CALCULATED GENERAL AIDS SUMMARY                                            
________________________________________                                            
                                                                                    
 1  FOUNDATION AID                                (FA ENT 15)       2,338,999       
 2  LESS 0708 PUB EXCESS COST AID SET-ASIDE      (PUB ENT 33)         233,112       
 3  DEDUCT FOR LOCAL SHARE OF ED COSTS FOR CERTAIN STUDENTS                         
                                                     (ENT 66)          14,090       
 4  NET CURRENT YEAR AID              (ENT 1 - ENT 2 - ENT 3)       2,091,797       
 5  HIGH TAX AID                           (SA0708) (ENT 111)         100,000       
 6  REORGANIZATION INCENTIVE OPERATING AID           (ENT 74)               0       
 7  REG BUILDING AID                                                                
                (BLD, ENT 36 + BLD10, ENT 50 + BLD3, ENT 58 +                       
                  BLD4, ENT 30 + BLD, ENT 48 + BLD10, ENT 61)         754,452       
 8  REG REORG INCENTIVE BLDG AID                                                    
  (BLD, ENT 43 + BLD10, ENT 57 + BLD3, ENT 68 + BLD4, ENT 40)             395       
 9  TOTAL BUILDING AID PROSPECTIVE, PAYABLE JULY 2007                               
                                                 (SBA ENT 5A)               0       
10  NATIVE AMERICAN BUILDING AID                                                    
  (BLD, ENT 44 + BLD10, ENT 53 + BLD3, ENT 64 + BLD4, ENT 31)               0       
11  TRANSPORTATION AID                         (TRA, ENT 174)         132,511       
12  CAREER EDUCATION AID - BIG 5 & NONCOMPONENTS     (ENT 79)               0       
13 COMPUTER ADMINISTRATION AID-BIG 5 & NONCOMPONENTS (ENT 95)               0       
14  URBAN-SUBURBAN TRANSFER AID                     (ENT 105)               0       
15  CHARTER SCHOOL TRANSITIONAL AID            (CHART ENT 38)               0       
16  CAREER EDUCATION AID DEDUCT FROM GEN AID BASED ON                               
    MAINTENANCE OF EFFORT CHECK                      (ENT 88)               0       
17  LIMITED ENGLISH PROFICIENCY DEDUCT FROM GEN AID BASED                           
    ON 2006-07 LEP EXPENDITURE CHECK                 (ENT 54)               0       
18 TOTAL CALCULATED GENERAL AIDS                                            0       
               (SUM OF ENTRIES 4 THRU 15) - (ENT 16 + ENT 17)       3,079,155       
                                                                                    
19  TOTAL BUILDING AID PROSPECTIVE, PAID JULY 2007(SBA ENT5B)               0       
20  TOTAL ADJUSTED CALCULATED GENERAL AIDS                                          
               (ENT18+ENT3+ENT16+ENT17) - (ENT10+ENT14+ENT19)       3,093,245       
                                                                                    
21  TOTAL GENERAL AIDS DISPLAYED ON COMPUTER RUN #SA0708                            
    DATED MARCH 2007 EXCLUDING JULY 07 DEFERRED PROSPECTIVE                         
    BUILDING AID PAYMENT                                            3,077,145       
22  AIDS USED FOR GENERAL AID PAYMENTS THROUGH JUNE 2008,                           
    FROZEN 12/1/07 AND RECALCULATED IN MAY 2008 EXCLUDING                           
    JULY 2007 DEFERRED PROSPECTIVE BUILDING AID                                     
        (IF #20<#21,THEN #18-#19 ELSE #21-#3-#16-#17+#10+#14)       3,064,555       
                                                                                    
                                                                                    
PART II:  ADDITIONAL GENERAL AIDS AND ADJUSTMENTS                                   
_________________________________________________                                   
                                                                                    
23  FULL DAY K CONVERSION AID                       (ENT 107)               0       
24  IMPACT AID (+) (SED USE ONLY)                                           0       
25  SHORT SESSION DEDUCT (-) (SED USE ONLY)                                 0       
                                                                                    
BLDG AID ADJ FOR FINAL COST REPTS PURSUANT TO CH. 70 OF THE LAWS OF                 
2004 OR MISCELLANEOUS BLDG AID ADJ DUE TO STATUTE                                   
    25A SED USE ONLY (+)                                                    0       
    25B SED USE ONLY (-)                                                    0       
26  GRAND TOT GENERAL AIDS         (ENTS 18+23+24-25+25A-25B)       3,079,155       
                                                                                    
PART III: PAYMENTS THRU JUNE 2008 AND EXCESS DUE SEPT 2008                          
__________________________________________________________                          
                                                                                    
27  FULL DAY K CONVERSION AID DISPLAYED ON COMPUTER RUN                             
    SA0708 DATED MARCH 2007                                                 0       
28  FULL DAY CONVERSION AIDS                         (ENT 23)               0       
29  FULL DAY CONVERSION PAYABLE JUNE 2008                                           
              (IF ATT ENT 158 > 0, LSR ENT 27 OR 28)                        0       
30  TOTAL BUILDING AID PROSPECTIVE, PAID JULY 2007   (ENT 19)               0       
31  TOTAL PAYMENTS THRU JUNE 2008  (ENT 22 + ENT 29 + ENT 30)       3,064,555       
                                                                                    
32  GRAND TOTAL GENERAL AIDS        (ENT 26, FROZEN 8/1/2008)       3,064,490       
33  BALANCE PAYMENTS DUE SEPTEMBER 2008     (ENT 32 - ENT 31)               0       
                                                                                    
PART IV: STATE SHARING RATIO FOR 2007-08 AID CALCULATIONS                           
_________________________________________________________                           
                                                                                    
34  2004 ACTUAL VALUATION                                         785,128,905       
35  2005-06 TOT WEALTH PUPIL UNITS (TWPU)                                 711       
36  ACTUAL VALUATION PER TWPU               (ENT 34 / ENT 35)       1,104,260       
37  PUPIL WEALTH RATIO                     (ENT 36 / 426,800)           2.587       
38  PUPIL WEALTH RATIO * .50                  (ENT 37 * 0.50)           1.293       
39  2004 ADJUSTED GROSS INCOME                                     69,237,828       
40  ADJUSTED GROSS INCOME / TWPU            (ENT 39 / ENT 35)          97,380       
41  ALTERNATE PUPIL WEALTH RATIO           (ENT 40 / 136,600)           0.712       
42  ALTERNATE PUPIL WEALTH RATIO * .50        (ENT 41 * 0.50)           0.356       
43  COMBINED WEALTH RATIO (CWR)             (ENT 38 + ENT 42)           1.649       
                                                                                    
    SELECTED SHARING RATIO:                                                         
                                                                                    
44  CWR * 1.230                              (ENT 43 * 1.230)           2.028       
45  FORMULA 1 SHARING RATIO (1.370 - ENT 44, MIN 0, MAX .900)           0.000       
46  CWR * 0.640                               (ENT 43 * .640)           1.055       
47  FORMULA 2 SHARING RATIO (1.000 - ENT 46, MIN 0, MAX .900)           0.000       
48  CWR * 0.390                              (ENT 43 * 0.390)           0.643       
49  FORMULA 3 SHARING RATIO (0.800 - ENT 48, MIN 0, MAX .900)           0.157       
50  CWR * 0.220                              (ENT 43 * 0.220)           0.362       
51  FORMULA 4 SHARING RATIO (0.510 - ENT 50, MIN 0, MAX .900)           0.148       
52  SELECTED SHARING RATIO                                                          
          (HIGHEST OF ENTS 45, 47, 49 OR 51, MIN 0, MAX .900)           0.157       
                                                                                    
PART V: REQUIRED SETASIDE FOR ATTENDANCE IMPROVEMENT/DROPOUT                        
____________________________________________________________                        
        PREVENTION (NEW YORK CITY ONLY)                                             
        _______________________________                                             
                                                                                    
53   REQUIRED SET-ASIDE FOR AI/DP  (2007-08 SET-ASIDE MONIES)               0       
  (BASED ON DATA ON FILE AS OF 7/1/07, NOT SUBJECT TO CHANGE)                       
                                                                                    
PART VI: CALCULATION OF LEP AID DEDUCT FROM 2007-08 GENERAL AID BASED               
_____________________________________________________________________               
         ON 2006-07 SETASIDE CHECK                                                  
         _________________________                                                  
                                                                                    
 54  A. 2006-07 SETASIDE                     (06 GEN ENT 117)               0       
     B. 2006-07 LEP AID EXPENDITURES REPORTED TO BILINGUAL                          
        OFFICE                                                              0       
     C. 2007-08 LEP AID DEDUCT AFTER 2006-07 EXPENDITURE                            
        CHECK                                                                       
       (IF 54A LESS THAN OR EQUAL TO 54B THEN 0 ELSE 54A-54B)               0       
                                                                                    
PART VII: CALCULATION OF DEDUCT FOR LOCAL SHARE OF EDUCATIONAL                      
______________________________________________________________                      
          COSTS FOR CERTAIN STUDENTS                                                
          __________________________                                                
                                                                                    
 55  BASIC CONTRIBUTION                          (PRI, ENT 5)       13,167.85       
                                                                                    
     THE FOLLOWING CHILDREN ARE FROM THE STAC FILE:                                 
 56  FTE - BLIND/DEAF - STATE SUPPORTED SCHS                            0.000       
 57  FTE - CHAPTER 47, LAWS OF 1977                                     0.000       
 58  FTE - CHAPTER 66, LAWS OF 1978                                     0.000       
 59  FTE - CHAPTER 721, LAWS OF 1979 + CRP                              0.000       
 60  FTE - CHAPTER 563, LAWS OF 1980                                    0.000       
 61  FTE - CHAPTER 947, LAWS OF 1981(OMH)                               1.000       
 62  FTE - CHAPTER 947, LAWS OF 1991(DSS)                               0.000       
 63  FTE - INCARCERATED YOUTH * 1.2                                     0.074       
 64  FTE - HOMELESS YOUTH                                               0.000       
 65  TOTAL PUPILS              (SUM OF ENTRIES 56 THROUGH 64)            1.07       
 66  LOCAL SHARE OF CERTAIN RES PUPIL COSTS                                         
                                       (ENT 55 * ENT 65, RND)          14,090       
                                                                                    
PART VIII: CALCULATION OF INCENTIVE OPERATING AID FOR REORGANIZED                   
_________________________________________________________________                   
           DISTRICTS                                                                
           _________                                                                
                                                                                    
 67  2006-07 SELECTED OPERATING AID     (FROZEN FEB 15, 2007)         670,254       
 68  2005-06 APPROVED OPERATING EXPENSE (2006-07 AOE, ENT 52)       8,289,667       
 69  AID LIMIT                                 (.95 * ENT 68)       7,875,183       
 70  2007-08 INCENTIVE OPERATING PERCENT                               0.0000       
 71  UNLIMITED INCENTIVE AID                (ENT 67 * ENT 70)               0       
 72  AID PLUS UNLIMITED INCENTIVE           (ENT 67 + ENT 71)         670,254       
 73  LOSS DUE TO LIMIT               (ENT 72 - ENT 69, MIN 0)               0       
 74  2007-08 INCENTIVE OPERATING AID                                                
                                (ENT 71 - ENT 73, MIN 0, RND)               0       
                                                                                    
 BEGINNING IN 2007-08, PURSUANT TO THE LAWS OF 2007, ONLY DISTRICTS                 
 THAT REORGANIZE AFTER 7/1/07 QUALIFY FOR INCENTIVE OPERATING AID.                  
                                                                                    
PART IX:   CALCULATION OF SPECIAL SERVICES AID FOR LARGE CITY                       
_____________________________________________________________                       
           SCHOOL DISTRICTS AND NONCOMPONENTS OF BOCES IN 2006-07                   
           ______________________________________________________                   
                                                                                    
 75  CAREER EDUCATION ATTENDANCE               (ATT, ENT 115)            0.00       
 76  COMBINED WEALTH RATIO * .590             (ENT 43 * .590)           0.000       
 77  CAREER ED AID RATIO       (GTR (1.000 - ENT 76) OR .360)           0.000       
 78  AID PER PUPIL UNIT                     (ENT 77 * $3,900)               0       
 79  2007-08 CAREER EDUCATION AID      (ENT 75 * ENT 78, RND)               0       
 80  2006-07 CAREER EDUCATION AID                                           0       
 81  2007-08 CAREER EDUCATION AID EXPENSE        (FORM F 158)               0       
 82  2006-07 CAREER EDUCATION LOCAL SHARE                                           
                                     (ENT 81 - ENT 80, MIN 0)               0       
 83 2005-06 CAREER EDUCATION LOCAL SHARE(2006-07 GEN ENT 195)               0       
 84  2006-07 CAREER EDUCATION PER PUPIL EXPENSE                                     
                                       (ENT 81 / ATT ENT 115)               0       
                                                                                    
 85  2005-06 CAREER EDUCATION PER PUPIL EXPENSE                                     
                         (2006 FORM F 158 / 2006 ATT ENT 115)               0       
 86  CAREER EDUCATION PER PUPIL EXPENSE MAINTENANCE OF EFFORT                       
     WAIVER INDICATOR(IF ENT 84 >= ENT 85 THEN = 0, ELSE = 1)               0       
 87  CAREER EDUCATION MAINTENANCE OF EFFORT AMOUNT                                  
            (IF ENT 82 >= ENT 83 THEN 0 ELSE ENT 83 - ENT 82)               0       
 88  CAREER EDUCATION MAINTENANCE OF EFFORT DEDUCT                                  
                                            (ENT 86 * ENT 87)               0       
 89  2006 K-12 PUBLIC SCHOOL ENROLLMENT (INCL CHARTER)                    582       
 90  K-12 ENROLLMENT * $62.30               (ENT 89 * $62.30)               0       
 91  APPROVED 2006-07 EXPS FOR DATA PROC     (FRM_F, ENT 157)               0       
 92  LESSER OF ENT 90 OR ENT 91                                             0       
 93  COMBINED WEALTH RATIO * .510             (ENT 43 * .510)           0.000       
 94  COMPUTER EXPS AID RATIO   (GTR (1.000 - ENT 93) OR .300)           0.000       
 95  2007-08 AID FOR COMPUTER EXPENSES  (ENT 92 * ENT 94,RND)               0       
                                                                                    
PART X: CALCULATION OF URBAN SUBURBAN TRANSFER AID                                  
__________________________________________________                                  
                                                                                    
 96  TRANSFER PUPILS RECEIVED                 (SCH C, ENT 16)               0       
 97  07-08 FOUNDATION AID                         (FA ENT 15)       2,338,999       
 98  07-08 FOUNDATION AID BASE                     (FA ENT 6)       2,270,873       
 99  INCREASE IN AID        (0.365 * (ENT 97 - ENT 98, MIN 0)          24,865       
100  AID PAID PER PUPIL             (ENT 97 / SEL 0708 TAFPU)        3,527.90       
101  FORMULA PUPIL MARGIN                  (ENT 99 / ENT 100)               7       
102  EXCESS TRANSFER PUPILS         (ENT 96 - ENT 101, MIN 0)               0       
103  AID PAYABLE PURSUANT TO 3602 15C, PARA C                                       
                               (SEL FOUNDATION AID * ENT 102)               0       
104  AID PAYABLE PURSUANT TO 3602 15E, PARA E  (SCH C, COL G)               0       
105  2007-08 TOT URBAN-SUBURB TRANSFER AID                                          
                                     (ENT 103 + ENT 104, RND)               0       
                                                                                    
PART XI: CALCULATION OF FULL DAY K CONVERSION AID                                   
_________________________________________________                                   
         (PAYABLE JUNE 2008 OR SEPT 2008)                                           
         ________________________________                                           
                                                                                    
106  INCREASE IN FULL DAY K ENROLLMENT ELIGIBLE FOR                                 
     CONVERSION AID                            (ATT, ENT 158)               0       
107  2007-08 FULL DAY K CONVERSION AID                                              
                              (ENT 106 * SEL 0708 FOUNDATION)               0       
                                                                                    
PART XII:  CALCULATION OF HIGH TAX AID                                              
______________________________________                                              
                                                                                    
TIER 1 HIGH TAX AID                                                                 
108 AVERAGE TAX EFFORT RATIO OF COUNTY INDICATOR                                    
                   IF > 4.2%*     1 = YES            (SA0708)               0       
109  2006 PUBLIC SCHOOL ENROLLMENT                   (SA0708)             582       
110 2007-08 FORMULA HIGH TAX AID($147.29 * ENT 108 * ENT 109)               0       
111  2007-08 HIGH TAX AID       (GREATER ENT 110 OR $100,000)               0       
                                                                                    
* AVERAGE TAX EFFORT RATIO OF COUNTY EQUALS TOTAL COUNTYWIDE 2004                   
  RESIDENTIAL TAX LEVY DIVIDED BY THE TOTAL COUNTYWIDE 2004 ADJUSTED                
  GROSS INCOME.                                                                     
                                                                                    
TIER 2 HIGH TAX AID                                                                 
112  REGIONAL COST INDEX                             (SA0708)           1.124       
113  AVERAGE TAX EFFORT RATIO OF DISTRICT INDICATOR                                 
            IF > 4.0% BUT < 4.2% & RCI > 1.3 1 = YES (SA0708)               0       
114  2007-08 TIER 2              ($30.00 * ENT 113 * ENT 109)               0       
115  2007-08 HIGH TAX AID: TIER 1 + TIER 2(ENT 111 + ENT 114)         100,000       
                                                                                    
PART XIII: CALCULATED EXCESS COST AID SUMMARY - PAYABLE UNDER 3609-B                
____________________________________________________________________                
                                                                                    
116  07-08 PUBLIC EXCESS COST AID SET-ASIDE      (PUB ENT 33)         233,112       
117  0708 PUBLIC HIGH COST EXCESS COST AID       (PUB ENT 16)          16,011       
118  0708 SUPPLEMENTAL PUBLIC EXCESS COST AID    (PUB ENT 30)               0       
119  0708 PRIVATE EXCESS COST AID                (PRI ENT 13)               0       
120  TOTAL EXCESS COST AIDS      (ENTS 116 + 117 + 118 + 119)         249,123       
121  TOTAL EXCESS COST AID AS SHOWN ON COMPUTER RUN SA0708            272,456       
122  AIDS USED FOR EXCESS COST AIDS THRU AUGUST 2008                                
                               (LESSER OF ENT 120 OR ENT 121)         260,036       
123  BALANCE DUE SEPTEMBER 2008 FOR EXCESS COST AIDS                                
                                   (ENT 120 - ENT 122, MIN 0)               0       
                                                                                    
PART XIV:  ADDITIONAL CALCULATED AIDS                                               
_____________________________________                                               
                                                                                    
124  0708 TEXTBOOK AID                            (IMA ENT 8)          30,615       
125  0708 COMPUTER SOFTWARE AID                  (IMA ENT 15)           8,719       
126  0708 LIBRARY MATERIALS AID                  (IMA ENT 18)           3,637       
127  0708 COMPUTER HARDWARE AND TECHNOLOGY AID   (IMA ENT 29)               0       
128  0708 UNIVERSAL PRE-KINDERGARTEN GRANT     (UPREK ENT 10)          33,400       
129  0708 BOCES AID                                                   121,547       
130  TOTAL 0708 STATE AID    (ENTS 26 + 120 + (124 THRU 129))       3,526,196       
                                                                                    
               
                                                                                    

NYSED HOME PAGE | STATE AID HOME PAGE | DISTRICT HOME PAGE