DISTRICT CODE: 641610 STATE AID 2008-09
DISTRICT NAME: CAMBRIDGE DATE: NOV 24, 2009
EDITION NO. 1319
DISTRICT LAST UPDATED ON 11/23/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) 9,960.23
2. 2008-09 EXPECTED MINIMUM LOCAL CONTRIBUTION
(PART III ENT 3) 2,729.10
3. 2008-09 SELECTED FOUNDATION AID/PUPIL
(GREATER OF 500 OR (ENT 1 - ENT 2)) 7,231.13
4. 2008-09 SELECTED TAFPU FOR 0708 AID (PART IV ENT 23) 1,345
5. 2008-09 TOTAL FOUNDATION AID (ENT 3 * ENT 4) 9,725,869
6A. 2006-07 TOTAL FOUNDATION AID BASE (FAB) (FAB ENT 20) 5,872,773
2006-07 FOUNDATION AID BASE OUTPUT REPORT
6B. 2007-08 FOUNDATION AID PAYABLE (0708 FOA ENT 15) 6,579,098
7. 2008-09 TOTAL FOUNDATION AID MINUS FAB
(PHASE-IN OPTION 1) (ENT 5 - ENT 6A, MIN = 0) 3,853,096
8. 12.55% OF FOUNDATION AID BASE
(PHASE-IN OPTION 2) (.1255 * ENT 6A) 737,033
9. 2008-09 SELECTED PHASE-IN FOUNDATION INCREASE
(37.5% OF (MAX ENT 7 OR ENT 8)) 1,444,911
10. 2008-09 CALCULATED FOUNDATION AID
(ENT 6A + ENT 9) 7,317,684
11. 103% OF 2007-08 FOUNDATION AID PAYABLE (1.03 * ENT 6B) 6,776,470
12. 115% OF 2007-08 FOUNDATION AID PAYABLE (1.15 * ENT 6B) 7,565,962
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,317,684
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.556
6. 2008-09 PUPIL NEED INDEX (PNI) (1 + EN%, MIN 1, MAX 2) 1.556
7. 2008-09 ADJUSTED FOUNDATION AMOUNT/PUPIL (AFA)
(ENT 3 * ENT 4 * ENT 6) 9,960.23
PART III: SELECTED EXPECTED MINIMUM LOCAL CONTRIBUTION
______________________________________________________
1. 2008-09 EXPECTED MINIMUM LOCAL CONTRIBUTION(A)(ENT 15) 3,091.39
2. 2008-09 EXPECTED MINIMUM LOCAL CONTRIBUTION(B)(ENT 34) 2,729.10
3. 2008-09 SELECTED EXPECTED MINIMUM LOCAL CONTRIBUTION
(< OF ENT 1 OR ENT 2) 2,729.10
EXPECTED MINIMUM LOCAL CONTRIBUTION (I)
_______________________________________
4. 2004 ACTUAL VALUATION 316,811,183
5. 2005 ACTUAL VALUATION 357,058,370
6. 2008-09 TWO YEAR AVERAGE ACTUAL VALUATION
((ENT 4 + ENT 5) * .50) 336,934,776
7. 2008-09 SELECTED ACTUAL VALUATION ( < ENT 5 OR ENT 6) 336,934,776
8. TOTAL WEALTH FOUNDATION PUPIL UNITS FOR 0809 AID
(TWFPU) (0809 FAPU-1 PART III ENT 14) 1,091
9. 2008-09 SELECTED AV PER TWFPU (ENT 7 / ENT 8) 308,831
10. 2008-09 LOCAL TAX FACTOR 0.0154
11. 2005 ADJUSTED GROSS INCOME (AGI) 100,560,378
12. 2008-09 AGI PER TWFPU (ENT 11 / ENT 8) 92,172
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,091.39
EXPECTED MINIMUM LOCAL CONTRIBUTION (II)
________________________________________
16. 2006-07 TOT WEALTH PUPIL UNITS (TWPU) FOR 2008-09
AID (2007-08 ATT ENT 153) 1,378
17. SELECTED ACTUAL VALUATION PER TWPU (ENT 7 / ENT 16) 244,509
18. FOUNDATION AID PUPIL WEALTH RATIO (FAPWR)
(ENT 17 / $453,100) 0.539
19. FOUNDATION AID PUPIL WEALTH RATIO * .5 (ENT 18 * 0.5) 0.269
20. 2004 ADJUSTED GROSS INCOME (AGI) 103,729,680
21. 2008-09 TWO YEAR AVERAGE ADJUSTED GROSS INCOME
((ENT 11 + ENT 20) * 0.5) 102,145,029
22. 2008-09 SELECTED ADJUSTED GROSS INCOME
(LESSER OF ENT 11 OR ENT 21) 100,560,378
23. SELECTED ADJUSTED GROSS INCOME PER TWPU
(ENT 22 / ENT 16) 72,975
24. FOUNDATION AID ALTERNATE PUPIL WEALTH RATIO (FAAPWR)
(ENT 23 / 143,000) 0.510
25. FOUNDATION AID ALTERNATE PUPIL WEALTH RATIO * .5
(ENT 24 * 0.5) 0.255
26. FOUNDATION AID COMBINED WEALTH RATIO (FACWR)
(ENT 19 + ENT 25) 0.524
27. FOUNDATION AID STATE SHARING RATIO 1
(1.37 - (1.23 * FACWR)) 0.726
28. FOUNDATION AID STATE SHARING RATIO 2
(1.00 - (0.64 * FACWR)) 0.665
29. FOUNDATION AID STATE SHARING RATIO 3
(0.80 - (0.39 * FACWR)) 0.596
30. FOUNDATION AID STATE SHARING RATIO 4
(0.51 - (0.173 * FACWR)) 0.420
31. 2008-09 FOUNDATION AID STATE SHARING RATIO (FASSR)
(MAX ENT 27,28,29,30 MIN 0, MAX .900) 0.726
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) 2,729.10
PART IV: PUPIL COUNTS FOR FOUNDATION AID
________________________________________
1. 2007-08 K-12 ENROLLMENT 1,065
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 103.922
5. BASE YEAR ENROLLMENT PER SQUARE MILE (ENT 1 / ENT 4) 10.248
6. 2008-09 SPARSITY FACTOR ((25 - ENT 5) / 50.9 MIN=0) 0.289
7. SPARSITY COUNT FOR 2008-09 AID (ENT 3 * ENT 1 * ENT 6) 307
LUNCH COUNT
8. 2004-05 K-6 FREE & REDUCED LUNCH APPLICANTS 180
9. 2005-06 K-6 FREE & REDUCED LUNCH APPLICANTS 185
10. 2006-07 K-6 FREE & REDUCED LUNCH APPLICANTS 164
11. 2004-05 K-6 ENROLLMENT 529
12. 2005-06 K-6 ENROLLMENT 494
13. 2006-07 K-6 ENROLLMENT 488
14. 2008-09 LUNCH COUNT
(ENT 8 + ENT 9 + ENT 10/ENT 11 + ENT 12 + ENT 13) * ENT 1) 372
15. AGED 5-17 IN PUB SCH & FAMILY BELOW POVERTY 75
16. AGED 5-17 IN PUB SCH 1,150
17. 2008-09 CENSUS COUNT (ENT 1 * (ENT 15 / ENT 16)) 69
18. 2008-09 POVERTY COUNT((.65 * ENT 14) + (.65 * ENT 17)) 286
19. 2008-09 EXTRAORDINARY NEEDS COUNT
((.5 * ENT 2) + ENT 7 + ENT 18) 593
SELECTED TAFPU FOR 2008-09 FOUNDATION AID
20. TAFPU BASED ON 06-07 SCHOOL YEAR DATA 1,345
TAFPU & TWFPU BASED ON 06-07 SCHOOL YEAR DATA
21. TAFPU BASED ON 05-06 SCHOOL YEAR DATA 1,289
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,317
23. SELECTED TAFPU FOR 2008-09 FOUNDATION AID
(MAX ENT 20 OR ENT 22) 1,345
NYSED HOME PAGE | STATE AID HOME PAGE | DISTRICT HOME PAGE