DISTRICT CODE: 280225 STATE AID 2007-08
DISTRICT NAME: MERRICK DATE: AUG 23, 2008
EDITION NO. 920
DISTRICT LAST UPDATED ON 08/22/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) 8,318.46
2. 2007-08 EXPECTED MINIMUM LOCAL CONTRIBUTION
(PART III ENT 3) 6,346.98
3. 2007-08 SELECTED FOUNDATION AID/PUPIL
(GREATER OF 500 OR (ENT 1 - ENT 2)) 1,971.48
4. 2007-08 SELECTED TAFPU FOR 0708 AID (PART IV ENT 23) 2,086
5. 2007-08 TOTAL FOUNDATION AID (ENT 3 * ENT 4) 4,112,507
6. 2007-08 TOTAL FOUNDATION AID BASE (FAB) 3,671,582
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) 440,925
8. 2007-08 12.55% OF FOUNDATION AID BASE
(PHASE-IN OPTION 2) (.1255 * ENT 6) 460,783
9. 2007-08 SELECTED PHASE-IN FOUNDATION INCREASE
(20% OF (MAX ENT 7 OR ENT 8)) 92,156
10. 2007-08 CALCULATED 2007-08 FOUNDATION AID
(ENT 6 + ENT 9) 3,763,738
11. 2007-08 103% OF FAB (1.03 * ENT 6) 3,781,729
12. 2007-08 125% OF FAB (1.25 * ENT 6) 4,589,477
13. 2007-08 AID DUE MINIMUM 3% INCREASE
(IF ENT 10 < ENT 11, THEN ENT 11 MINUS ENT 10, ELSE 0) 17,991
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) 3,781,729
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.425
5. 2007-08 EXTRAORDINARY NEEDS % (EN%)(EN COUNT/0607 ENR) 0.031
6. 2007-08 PUPIL NEED INDEX (PNI) (1 + EN%, MIN 1, MAX 2) 1.031
7. 2007-08 ADJUSTED FOUNDATION AMOUNT/PUPIL (AFA)
(ENT 3 * ENT 4 * ENT 6) 8,318.46
PART III: SELECTED EXPECTED MINIMUM LOCAL CONTRIBUTION
______________________________________________________
1. 2007-08 EXPECTED MINIMUM LOCAL CONTRIBUTION(A)(ENT 15) 18,335.45
2. 2007-08 EXPECTED MINIMUM LOCAL CONTRIBUTION(B)(ENT 29) 6,346.98
3. 2007-08 SELECTED EXPECTED MINIMUM LOCAL CONTRIBUTION
(< OF ENT 1 OR ENT 2) 6,346.98
EXPECTED MINIMUM LOCAL CONTRIBUTION (A)
_______________________________________
4. 2003 ACTUAL VALUATION 2,905,325,222
5. 2004 ACTUAL VALUATION 3,133,814,756
6. 2007-08 TWO YEAR AVERAGE ACTUAL VALUATION 3,019,569,989
7. 2007-08 SELECTED ACTUAL VALUATION 3,019,569,989
8. TWFPU FOR 0708 AID 3,739
9. 2007-08 SELECTED AV PER TWFPU 807,587
10. 2007-08 LOCAL TAX FACTOR 0.016
11. 2004 ADJUSTED GROSS INCOME (AGI) 897,152,661
12. 2007-08 AGI PER TWFPU 239,944
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) 1.419
15. 2007-08 EXPECTED MINIMUM LOCAL CONTRIBUTION (A)
(ENT 9 * ENT 10 * ENT 14) 18,335.45
EXPECTED MINIMUM LOCAL CONTRIBUTION (B)
_______________________________________
16. 2005-06 TOT WEALTH PUPIL UNITS (TWPU) 4,395
17. ACTUAL VALUATION (2004) PER TWPU 713,040
18. PUPIL WEALTH RATIO 1.670
19. PUPIL WEALTH RATIO * .5 0.835
20. ADJUSTED GROSS INCOME PER TWPU 204,130
21. ALTERNATE PUPIL WEALTH RATIO 1.494
22. ALTERNATE PUPIL WEALTH RATIO * .5 0.747
23. COMBINED WEALTH RATIO (ENT 19 + ENT 22) 1.582
24. STATE SHARING RATIO 1 (1.37 - (1.23 * CWR)) 0.000
25. STATE SHARING RATIO 2 (1.00 - (0.64 * CWR)) 0.000
26. STATE SHARING RATIO 3 (0.80 - (0.39 * CWR)) 0.184
27. STATE SHARING RATIO FOUNDATION AID ONLY
(0.51 - (0.173 * CWR)) 0.237
28. 2007-08 STATE SHARING RATIO FOR TOTAL FOUNDATION AID
(MAX ENT 24,25,26,27 MIN 0, MAX .900) 0.237
29. 2007-08 EXPECTED MINIMUM LOCAL CONTRIBUTION (B)
(PART II ENT 7 * (1 - ENT 28) 6,346.98
PART IV: PUPIL COUNTS FOR FOUNDATION AID
________________________________________
1. 2006-07 K-12 ENROLLMENT 1,874
2. 2006-07 LIMITED ENGLISH PROFICIENCY COUNT
(FORM A ENT 73) 26
SPARSITY COUNT
3. 2007-08 K-12 INDICATOR 1
4. SQUARE MILES IN DISTRICT 8.885
5. BASE YEAR ENROLLMENT PER SQUARE MILE (ENT 1 / ENT 4) 210.917
6. 2007-08 SPARSITY FACTOR ((25 - ENT 5) / 50.9 MIN=0) 0.000
7. SPARSITY COUNT FOR 2007-08 AID (ENT 3 * ENT 1 * ENT 6) 0
LUNCH COUNT
8. 2003-04 K-6 FREE & REDUCED LUNCH APPLICANTS 0
9. 2004-05 K-6 FREE & REDUCED LUNCH APPLICANTS 0
10. 2005-06 K-6 FREE & REDUCED LUNCH APPLICANTS 0
11. 2003-04 K-6 ENROLLMENT 1,970
12. 2004-05 K-6 ENROLLMENT 1,941
13. 2005-06 K-6 ENROLLMENT 1,912
14. 2007-08 LUNCH COUNT
(ENT 8 + ENT 9 + ENT 10/ENT 11 + ENT 12 + ENT 13) * ENT 1) 0
15. AGED 5-17 IN PUB SCH & FAMILY BELOW POVERTY 75
16. AGED 5-17 IN PUB SCH 1,965
17. 2007-08 CENSUS COUNT (ENT 1 * (ENT 15 / ENT 16)) 71
18. 2007-08 POVERTY COUNT((.65 * ENT 14) + (.65 * ENT 17)) 46
19. 2007-08 EXTRAORDINARY NEEDS COUNT
((.5 * ENT 2) + ENT 7 + ENT 18) 59
TAFPU
20. TAFPU BASED ON 05-06 SCHOOL YEAR DATA 2,082
TAFPU & TWFPU BASED ON 05-06 SCHOOL YEAR DATA
21. TAFPU BASED ON 04-05 SCHOOL YEAR DATA 2,091
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) 2,086
23. SELECTED TAFPU FOR 2007-08 FOUNDATION AID
(MAX ENT 20 OR ENT 22) 2,086
NYSED HOME PAGE | STATE AID HOME PAGE | DISTRICT HOME PAGE