DISTRICT CODE: 490101 STATE AID 2008-09
DISTRICT NAME: BERLIN DATE: NOV 19, 2009
EDITION NO. 1307
DISTRICT LAST UPDATED ON 11/18/09
NOTE: DATA DISPLAYED IS TENTATIVE PENDING AUDIT
2008-09 FOUNDATION AID OUTPUT REPORT PAGE 1
PART I: CALCULATION OF 2008-09 FOUNDATION AID
_____________________________________________
1. 2008-09 ADJUSTED FOUNDATION AMOUNT/PUPIL
(PART II ENT 7) 10,856.40
2. 2008-09 EXPECTED MINIMUM LOCAL CONTRIBUTION
(PART III ENT 3) 3,823.78
3. 2008-09 SELECTED FOUNDATION AID/PUPIL
(GREATER OF 500 OR (ENT 1 - ENT 2)) 7,032.62
4. 2008-09 SELECTED TAFPU FOR 0708 AID (PART IV ENT 23) 1,227
5. 2008-09 TOTAL FOUNDATION AID (ENT 3 * ENT 4) 8,629,024
6A. 2006-07 TOTAL FOUNDATION AID BASE (FAB) (FAB ENT 20) 6,255,893
2006-07 FOUNDATION AID BASE OUTPUT REPORT
6B. 2007-08 FOUNDATION AID PAYABLE (0708 FOA ENT 15) 6,739,923
7. 2008-09 TOTAL FOUNDATION AID MINUS FAB
(PHASE-IN OPTION 1) (ENT 5 - ENT 6A, MIN = 0) 2,373,131
8. 12.55% OF FOUNDATION AID BASE
(PHASE-IN OPTION 2) (.1255 * ENT 6A) 785,114
9. 2008-09 SELECTED PHASE-IN FOUNDATION INCREASE
(37.5% OF (MAX ENT 7 OR ENT 8)) 889,924
10. 2008-09 CALCULATED FOUNDATION AID
(ENT 6A + ENT 9) 7,145,817
11. 103% OF 2007-08 FOUNDATION AID PAYABLE (1.03 * ENT 6B) 6,942,120
12. 115% OF 2007-08 FOUNDATION AID PAYABLE (1.15 * ENT 6B) 7,750,911
13. 2008-09 AID DUE MINIMUM 3% INCREASE
(IF ENT 10 < ENT 11, THEN ENT 11 MINUS ENT 10, ELSE 0) 0
14. 2008-09 AID DEDUCT 15% MAX INCREASE
(IF ENT 10 > ENT 12, THEN ENT 12 MINUS ENT 10, ELSE 0) 0
15. 2008-09 FOUNDATION AID PAYABLE (ENTS 10 + 13 + 14) 7,145,817
PART II: CALCULATION OF ADJUSTED FOUNDATION AMOUNT (AFA)
________________________________________________________
1. 2008-09 FOUNDATION AMOUNT 5,258
2. 2008-09 PHASE-IN FOUNDATION PERCENT 1.0526
3. 2008-09 FOUNDATION AMT ADJUSTED BY PHASE-IN PERCENT
AND CPI (ENT 1 * ENT 2 * 1.029) 5,695
4. 2008-09 REGIONAL COST INDEX (RCI) FOR 2008-09 AID 1.124
5. 2008-09 EXTRAORDINARY NEEDS % (EN%)(EN COUNT/0708 ENR) 0.696
6. 2008-09 PUPIL NEED INDEX (PNI) (1 + EN%, MIN 1, MAX 2) 1.696
7. 2008-09 ADJUSTED FOUNDATION AMOUNT/PUPIL (AFA)
(ENT 3 * ENT 4 * ENT 6) 10,856.40
PART III: SELECTED EXPECTED MINIMUM LOCAL CONTRIBUTION
______________________________________________________
1. 2008-09 EXPECTED MINIMUM LOCAL CONTRIBUTION(A)(ENT 15) 3,823.78
2. 2008-09 EXPECTED MINIMUM LOCAL CONTRIBUTION(B)(ENT 34) 4,461.98
3. 2008-09 SELECTED EXPECTED MINIMUM LOCAL CONTRIBUTION
(< OF ENT 1 OR ENT 2) 3,823.78
EXPECTED MINIMUM LOCAL CONTRIBUTION (I)
_______________________________________
4. 2004 ACTUAL VALUATION 370,071,572
5. 2005 ACTUAL VALUATION 421,428,094
6. 2008-09 TWO YEAR AVERAGE ACTUAL VALUATION
((ENT 4 + ENT 5) * .50) 395,749,833
7. 2008-09 SELECTED ACTUAL VALUATION ( < ENT 5 OR ENT 6) 395,749,833
8. TOTAL WEALTH FOUNDATION PUPIL UNITS FOR 0809 AID
(TWFPU) (0809 FAPU-1 PART III ENT 14) 1,036
9. 2008-09 SELECTED AV PER TWFPU (ENT 7 / ENT 8) 381,997
10. 2008-09 LOCAL TAX FACTOR 0.0154
11. 2005 ADJUSTED GROSS INCOME (AGI) 120,451,732
12. 2008-09 AGI PER TWFPU (ENT 11 / ENT 8) 116,266
13. 2008-09 STATE AVERAGE AGI PER TWFPU 185,100
14. 2008-09 INCOME WEALTH INDEX FOR LOCAL CONTRIBUTION
(ENT 12 / ENT 13, MAX 0.95, MIN .65) 0.650
15. 2008-09 EXPECTED MINIMUM LOCAL CONTRIBUTION (I)
(ENT 9 * ENT 10 * ENT 14) 3,823.78
EXPECTED MINIMUM LOCAL CONTRIBUTION (II)
________________________________________
16. 2006-07 TOT WEALTH PUPIL UNITS (TWPU) FOR 2008-09
AID (2007-08 ATT ENT 153) 1,322
17. SELECTED ACTUAL VALUATION PER TWPU (ENT 7 / ENT 16) 299,356
18. FOUNDATION AID PUPIL WEALTH RATIO (FAPWR)
(ENT 17 / $453,100) 0.660
19. FOUNDATION AID PUPIL WEALTH RATIO * .5 (ENT 18 * 0.5) 0.330
20. 2004 ADJUSTED GROSS INCOME (AGI) 116,963,059
21. 2008-09 TWO YEAR AVERAGE ADJUSTED GROSS INCOME
((ENT 11 + ENT 20) * 0.5) 118,707,395
22. 2008-09 SELECTED ADJUSTED GROSS INCOME
(LESSER OF ENT 11 OR ENT 21) 118,707,395
23. SELECTED ADJUSTED GROSS INCOME PER TWPU
(ENT 22 / ENT 16) 89,793
24. FOUNDATION AID ALTERNATE PUPIL WEALTH RATIO (FAAPWR)
(ENT 23 / 143,000) 0.627
25. FOUNDATION AID ALTERNATE PUPIL WEALTH RATIO * .5
(ENT 24 * 0.5) 0.313
26. FOUNDATION AID COMBINED WEALTH RATIO (FACWR)
(ENT 19 + ENT 25) 0.643
27. FOUNDATION AID STATE SHARING RATIO 1
(1.37 - (1.23 * FACWR)) 0.580
28. FOUNDATION AID STATE SHARING RATIO 2
(1.00 - (0.64 * FACWR)) 0.589
29. FOUNDATION AID STATE SHARING RATIO 3
(0.80 - (0.39 * FACWR)) 0.550
30. FOUNDATION AID STATE SHARING RATIO 4
(0.51 - (0.173 * FACWR)) 0.399
31. 2008-09 FOUNDATION AID STATE SHARING RATIO (FASSR)
(MAX ENT 27,28,29,30 MIN 0, MAX .900) 0.589
32. HIGH NEED DISTRICT INDICATOR 0
33. 2008-09 FOUNDATION AID STATE SHARING RATIO FOR HN
DISTRICTS (ENT 31 * 1.05 * ENT 32, MAX .900) 0.000
34. 2008-09 EXPECTED MINIMUM LOCAL CONTRIBUTION (II)
(PART II ENT 7 * (1 - ENT 31 OR 33) 4,461.98
PART IV: PUPIL COUNTS FOR FOUNDATION AID
________________________________________
1. 2007-08 K-12 ENROLLMENT 952
2. 2007-08 LIMITED ENGLISH PROFICIENCY COUNT
(FORM A ENT 73) 0
SPARSITY COUNT
3. 2008-09 K-12 INDICATOR 1
4. SQUARE MILES IN DISTRICT 161.425
5. BASE YEAR ENROLLMENT PER SQUARE MILE (ENT 1 / ENT 4) 5.897
6. 2008-09 SPARSITY FACTOR ((25 - ENT 5) / 50.9 MIN=0) 0.375
7. SPARSITY COUNT FOR 2008-09 AID (ENT 3 * ENT 1 * ENT 6) 357
LUNCH COUNT
8. 2004-05 K-6 FREE & REDUCED LUNCH APPLICANTS 187
9. 2005-06 K-6 FREE & REDUCED LUNCH APPLICANTS 201
10. 2006-07 K-6 FREE & REDUCED LUNCH APPLICANTS 194
11. 2004-05 K-6 ENROLLMENT 541
12. 2005-06 K-6 ENROLLMENT 525
13. 2006-07 K-6 ENROLLMENT 509
14. 2008-09 LUNCH COUNT
(ENT 8 + ENT 9 + ENT 10/ENT 11 + ENT 12 + ENT 13) * ENT 1) 351
15. AGED 5-17 IN PUB SCH & FAMILY BELOW POVERTY 149
16. AGED 5-17 IN PUB SCH 1,174
17. 2008-09 CENSUS COUNT (ENT 1 * (ENT 15 / ENT 16)) 120
18. 2008-09 POVERTY COUNT((.65 * ENT 14) + (.65 * ENT 17)) 306
19. 2008-09 EXTRAORDINARY NEEDS COUNT
((.5 * ENT 2) + ENT 7 + ENT 18) 663
SELECTED TAFPU FOR 2008-09 FOUNDATION AID
20. TAFPU BASED ON 06-07 SCHOOL YEAR DATA 1,213
TAFPU & TWFPU BASED ON 06-07 SCHOOL YEAR DATA
21. TAFPU BASED ON 05-06 SCHOOL YEAR DATA 1,241
TAFPU BASED ON 05-06 SCHOOL YEAR DATA
22. AVERAGE OF TAFPU BASED ON 0607 AND 0506 SCHOOL YEAR DATA
((ENT 20 + ENT 21) / 2) 1,227
23. SELECTED TAFPU FOR 2008-09 FOUNDATION AID
(MAX ENT 20 OR ENT 22) 1,227
NYSED HOME PAGE | STATE AID HOME PAGE | DISTRICT HOME PAGE