DISTRICT CODE: 641610 STATE AID 2007-08
DISTRICT NAME: CAMBRIDGE DATE: SEPT 30, 2008
EDITION NO. 1012
DISTRICT LAST UPDATED ON 09/29/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) 9,940.70
2. 2007-08 EXPECTED MINIMUM LOCAL CONTRIBUTION
(PART III ENT 3) 2,869.40
3. 2007-08 SELECTED FOUNDATION AID/PUPIL
(GREATER OF 500 OR (ENT 1 - ENT 2)) 7,071.30
4. 2007-08 SELECTED TAFPU FOR 0708 AID (PART IV ENT 23) 1,321
5. 2007-08 TOTAL FOUNDATION AID (ENT 3 * ENT 4) 9,341,187
6. 2006-07 TOTAL FOUNDATION AID BASE (FAB) (FAB ENT 20) 5,872,773
2006-07 FOUNDATION AID BASE OUTPUT REPORT
7. 2007-08 TAFPU * SELECTED FOUNDATION AID MINUS FAB
(MIN=0) (PHASE-IN OPTION 1) (ENT 5 - ENT 6) 3,468,414
8. 2007-08 12.55% OF FOUNDATION AID BASE
(PHASE-IN OPTION 2) (.1255 * ENT 6) 737,033
9. 2007-08 SELECTED PHASE-IN FOUNDATION INCREASE
(20% OF (MAX ENT 7 OR ENT 8)) 693,682
10. 2007-08 CALCULATED 2007-08 FOUNDATION AID
(ENT 6 + ENT 9) 6,566,455
11. 2007-08 103% OF FAB (1.03 * ENT 6) 6,048,956
12. 2007-08 125% OF FAB (1.25 * ENT 6) 7,340,966
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) 6,566,455
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.124
5. 2007-08 EXTRAORDINARY NEEDS % (EN%)(EN COUNT/0607 ENR) 0.562
6. 2007-08 PUPIL NEED INDEX (PNI) (1 + EN%, MIN 1, MAX 2) 1.562
7. 2007-08 ADJUSTED FOUNDATION AMOUNT/PUPIL (AFA)
(ENT 3 * ENT 4 * ENT 6) 9,940.70
PART III: SELECTED EXPECTED MINIMUM LOCAL CONTRIBUTION
______________________________________________________
1. 2007-08 EXPECTED MINIMUM LOCAL CONTRIBUTION(A)(ENT 15) 2,869.40
2. 2007-08 EXPECTED MINIMUM LOCAL CONTRIBUTION(B)(ENT 29) 2,892.74
3. 2007-08 SELECTED EXPECTED MINIMUM LOCAL CONTRIBUTION
(< OF ENT 1 OR ENT 2) 2,869.40
EXPECTED MINIMUM LOCAL CONTRIBUTION (A)
_______________________________________
4. 2003 ACTUAL VALUATION 292,385,840
5. 2004 ACTUAL VALUATION 316,811,183
6. 2007-08 TWO YEAR AVERAGE ACTUAL VALUATION 304,598,511
7. 2007-08 SELECTED ACTUAL VALUATION 304,598,511
8. TWFPU FOR 0708 AID 1,104
9. 2007-08 SELECTED AV PER TWFPU 275,904
10. 2007-08 LOCAL TAX FACTOR 0.016
11. 2004 ADJUSTED GROSS INCOME (AGI) 103,729,680
12. 2007-08 AGI PER TWFPU 93,958
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) 2,869.40
EXPECTED MINIMUM LOCAL CONTRIBUTION (B)
_______________________________________
16. 2005-06 TOT WEALTH PUPIL UNITS (TWPU) 1,394
17. ACTUAL VALUATION (2004) PER TWPU 227,267
18. PUPIL WEALTH RATIO 0.532
19. PUPIL WEALTH RATIO * .5 0.266
20. ADJUSTED GROSS INCOME PER TWPU 74,411
21. ALTERNATE PUPIL WEALTH RATIO 0.544
22. ALTERNATE PUPIL WEALTH RATIO * .5 0.272
23. COMBINED WEALTH RATIO (ENT 19 + ENT 22) 0.538
24. STATE SHARING RATIO 1 (1.37 - (1.23 * CWR)) 0.709
25. STATE SHARING RATIO 2 (1.00 - (0.64 * CWR)) 0.656
26. STATE SHARING RATIO 3 (0.80 - (0.39 * CWR)) 0.591
27. STATE SHARING RATIO FOUNDATION AID ONLY
(0.51 - (0.173 * CWR)) 0.417
28. 2007-08 STATE SHARING RATIO FOR TOTAL FOUNDATION AID
(MAX ENT 24,25,26,27 MIN 0, MAX .900) 0.709
29. 2007-08 EXPECTED MINIMUM LOCAL CONTRIBUTION (B)
(PART II ENT 7 * (1 - ENT 28) 2,892.74
PART IV: PUPIL COUNTS FOR FOUNDATION AID
________________________________________
1. 2006-07 K-12 ENROLLMENT 1,069
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 103.922
5. BASE YEAR ENROLLMENT PER SQUARE MILE (ENT 1 / ENT 4) 10.286
6. 2007-08 SPARSITY FACTOR ((25 - ENT 5) / 50.9 MIN=0) 0.289
7. SPARSITY COUNT FOR 2007-08 AID (ENT 3 * ENT 1 * ENT 6) 308
LUNCH COUNT
8. 2003-04 K-6 FREE & REDUCED LUNCH APPLICANTS 203
9. 2004-05 K-6 FREE & REDUCED LUNCH APPLICANTS 180
10. 2005-06 K-6 FREE & REDUCED LUNCH APPLICANTS 185
11. 2003-04 K-6 ENROLLMENT 564
12. 2004-05 K-6 ENROLLMENT 529
13. 2005-06 K-6 ENROLLMENT 494
14. 2007-08 LUNCH COUNT
(ENT 8 + ENT 9 + ENT 10/ENT 11 + ENT 12 + ENT 13) * ENT 1) 382
15. AGED 5-17 IN PUB SCH & FAMILY BELOW POVERTY 75
16. AGED 5-17 IN PUB SCH 1,150
17. 2007-08 CENSUS COUNT (ENT 1 * (ENT 15 / ENT 16)) 69
18. 2007-08 POVERTY COUNT((.65 * ENT 14) + (.65 * ENT 17)) 293
19. 2007-08 EXTRAORDINARY NEEDS COUNT
((.5 * ENT 2) + ENT 7 + ENT 18) 601
TAFPU
20. TAFPU BASED ON 05-06 SCHOOL YEAR DATA 1,281
TAFPU & TWFPU BASED ON 05-06 SCHOOL YEAR DATA
21. TAFPU BASED ON 04-05 SCHOOL YEAR DATA 1,362
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) 1,321
23. SELECTED TAFPU FOR 2007-08 FOUNDATION AID
(MAX ENT 20 OR ENT 22) 1,321
NYSED HOME PAGE | STATE AID HOME PAGE | DISTRICT HOME PAGE