DISTRICT CODE: 020601 STATE AID 2007-08
DISTRICT NAME: ANDOVER DATE: JULY 8, 2008
EDITION NO. 803
DISTRICT LAST UPDATED ON 07/07/08
NOTE: DATA DISPLAYED IS TENTATIVE PENDING AUDIT
2007-08 FOUNDATION AID OUTPUT REPORT PAGE 1
PART I: CALCULATION OF 2007-08 FOUNDATION AID
_____________________________________________
1. 2007-08 ADJUSTED FOUNDATION AMOUNT/PUPIL
(PART II ENT 7) 11,032.55
2. 2007-08 EXPECTED MINIMUM LOCAL CONTRIBUTION
(PART III ENT 3) 1,776.24
3. 2007-08 SELECTED FOUNDATION AID/PUPIL
(GREATER OF 500 OR (ENT 1 - ENT 2)) 9,256.31
4. 2007-08 SELECTED TAFPU FOR 0708 AID (PART IV ENT 23) 450
5. 2007-08 TOTAL FOUNDATION AID (ENT 3 * ENT 4) 4,165,339
6. 2007-08 TOTAL FOUNDATION AID BASE (FAB) 2,547,804
2007-08 FOUNDATION AID BASE OUTPUT REPORT
7. 2007-08 TAFPU * SELECTED FOUNDATION AID MINUS FAB
(MIN=0) (PHASE-IN OPTION 1) (ENT 5 - ENT 6) 1,617,535
8. 2007-08 12.55% OF FOUNDATION AID BASE
(PHASE-IN OPTION 2) (.1255 * ENT 6) 319,749
9. 2007-08 SELECTED PHASE-IN FOUNDATION INCREASE
(20% OF (MAX ENT 7 OR ENT 8)) 323,507
10. 2007-08 CALCULATED 2007-08 FOUNDATION AID
(ENT 6 + ENT 9) 2,871,311
11. 2007-08 103% OF FAB (1.03 * ENT 6) 2,624,238
12. 2007-08 125% OF FAB (1.25 * ENT 6) 3,184,755
13. 2007-08 AID DUE MINIMUM 3% INCREASE
(IF ENT 10 < ENT 11, THEN ENT 11 MINUS ENT 10, ELSE 0) 0
14. 2007-08 AID DEDUCT 25% MAX INCREASE
(IF ENT 10 > ENT 12, THEN ENT 12 MINUS ENT 10, ELSE 0) 0
15. 2007-08 FOUNDATION AID PAYABLE (ENTS 10 + 13 + 14) 2,871,311
PART II: CALCULATION OF ADJUSTED FOUNDATION AMOUNT (AFA)
________________________________________________________
1. 2007-08 FOUNDATION AMOUNT 5,258
2. 2007-08 PHASE-IN FOUNDATION PERCENT 1.0768
3. 2007-08 FOUNDATION AMT ADJUSTED BY PHASE-IN PERCENT
(ENT 1 * ENT 2) 5,662
4. 2007-08 REGIONAL COST INDEX (RCI) FOR 2007-08 AID 1.091
5. 2007-08 EXTRAORDINARY NEEDS % (EN%)(EN COUNT/0607 ENR) 0.786
6. 2007-08 PUPIL NEED INDEX (PNI) (1 + EN%, MIN 1, MAX 2) 1.786
7. 2007-08 ADJUSTED FOUNDATION AMOUNT/PUPIL (AFA)
(ENT 3 * ENT 4 * ENT 6) 11,032.55
PART III: SELECTED EXPECTED MINIMUM LOCAL CONTRIBUTION
______________________________________________________
1. 2007-08 EXPECTED MINIMUM LOCAL CONTRIBUTION(A)(ENT 15) 1,962.71
2. 2007-08 EXPECTED MINIMUM LOCAL CONTRIBUTION(B)(ENT 29) 1,776.24
3. 2007-08 SELECTED EXPECTED MINIMUM LOCAL CONTRIBUTION
(< OF ENT 1 OR ENT 2) 1,776.24
EXPECTED MINIMUM LOCAL CONTRIBUTION (A)
_______________________________________
4. 2003 ACTUAL VALUATION 77,237,317
5. 2004 ACTUAL VALUATION 74,357,132
6. 2007-08 TWO YEAR AVERAGE ACTUAL VALUATION 75,797,224
7. 2007-08 SELECTED ACTUAL VALUATION 74,357,132
8. TWFPU FOR 0708 AID 394
9. 2007-08 SELECTED AV PER TWFPU 188,723
10. 2007-08 LOCAL TAX FACTOR 0.016
11. 2004 ADJUSTED GROSS INCOME (AGI) 30,363,065
12. 2007-08 AGI PER TWFPU 77,063
13. 2007-08 STATE AVERAGE AGI PER TWFPU 169,000
14. 2007-08 INCOME WEALTH INDEX FOR LOCAL CONTRIBUTION
(ENT 12 / ENT 13, MAX 2.0, MIN .65) 0.650
15. 2007-08 EXPECTED MINIMUM LOCAL CONTRIBUTION (A)
(ENT 9 * ENT 10 * ENT 14) 1,962.71
EXPECTED MINIMUM LOCAL CONTRIBUTION (B)
_______________________________________
16. 2005-06 TOT WEALTH PUPIL UNITS (TWPU) 458
17. ACTUAL VALUATION (2004) PER TWPU 162,351
18. PUPIL WEALTH RATIO 0.380
19. PUPIL WEALTH RATIO * .5 0.190
20. ADJUSTED GROSS INCOME PER TWPU 66,294
21. ALTERNATE PUPIL WEALTH RATIO 0.485
22. ALTERNATE PUPIL WEALTH RATIO * .5 0.242
23. COMBINED WEALTH RATIO (ENT 19 + ENT 22) 0.432
24. STATE SHARING RATIO 1 (1.37 - (1.23 * CWR)) 0.839
25. STATE SHARING RATIO 2 (1.00 - (0.64 * CWR)) 0.724
26. STATE SHARING RATIO 3 (0.80 - (0.39 * CWR)) 0.632
27. STATE SHARING RATIO FOUNDATION AID ONLY
(0.51 - (0.173 * CWR)) 0.436
28. 2007-08 STATE SHARING RATIO FOR TOTAL FOUNDATION AID
(MAX ENT 24,25,26,27 MIN 0, MAX .900) 0.839
29. 2007-08 EXPECTED MINIMUM LOCAL CONTRIBUTION (B)
(PART II ENT 7 * (1 - ENT 28) 1,776.24
PART IV: PUPIL COUNTS FOR FOUNDATION AID
________________________________________
1. 2006-07 K-12 ENROLLMENT 408
2. 2006-07 LIMITED ENGLISH PROFICIENCY COUNT
(FORM A ENT 73) 0
SPARSITY COUNT
3. 2007-08 K-12 INDICATOR 1
4. SQUARE MILES IN DISTRICT 55.378
5. BASE YEAR ENROLLMENT PER SQUARE MILE (ENT 1 / ENT 4) 7.367
6. 2007-08 SPARSITY FACTOR ((25 - ENT 5) / 50.9 MIN=0) 0.346
7. SPARSITY COUNT FOR 2007-08 AID (ENT 3 * ENT 1 * ENT 6) 141
LUNCH COUNT
8. 2003-04 K-6 FREE & REDUCED LUNCH APPLICANTS 103
9. 2004-05 K-6 FREE & REDUCED LUNCH APPLICANTS 99
10. 2005-06 K-6 FREE & REDUCED LUNCH APPLICANTS 105
11. 2003-04 K-6 ENROLLMENT 209
12. 2004-05 K-6 ENROLLMENT 199
13. 2005-06 K-6 ENROLLMENT 198
14. 2007-08 LUNCH COUNT
(ENT 8 + ENT 9 + ENT 10/ENT 11 + ENT 12 + ENT 13) * ENT 1) 206
15. AGED 5-17 IN PUB SCH & FAMILY BELOW POVERTY 69
16. AGED 5-17 IN PUB SCH 389
17. 2007-08 CENSUS COUNT (ENT 1 * (ENT 15 / ENT 16)) 72
18. 2007-08 POVERTY COUNT((.65 * ENT 14) + (.65 * ENT 17)) 180
19. 2007-08 EXTRAORDINARY NEEDS COUNT
((.5 * ENT 2) + ENT 7 + ENT 18) 321
TAFPU
20. TAFPU BASED ON 05-06 SCHOOL YEAR DATA 450
TAFPU & TWFPU BASED ON 05-06 SCHOOL YEAR DATA
21. TAFPU BASED ON 04-05 SCHOOL YEAR DATA 440
TAFPU BASED ON 04-05 SCHOOL YEAR DATA
22. AVERAGE OF TAFPU BASED ON 0506 AND 0405 SCHOOL YEAR DATA
((ENT 20 + ENT 21) / 2) 445
23. SELECTED TAFPU FOR 2007-08 FOUNDATION AID
(MAX ENT 20 OR ENT 22) 450
NYSED HOME PAGE | STATE AID HOME PAGE | DISTRICT HOME PAGE