Spreadsheet: 02cd31a6-9c30-480f-ae38-afda71abb26a
Sheet: Sheet1

Data from CPS AFR, 2006-07 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | (10) | (20) | (30) | (40) | (50) | (60) | (70) | (80) | (90) | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23
 |  | Description | Acct # | Educational | Operations & Maintenance | Bond & Interest | Transportation | Municipal Retirement/ Social Security | Site & Construction/ Capital Improvement | Working Cash | Rent | Fire Prevention & Safety | CPS Totals Including Charter Totals | Statewide Totals Minus Charter Totals | CPS District Enrollment Minus charters (K - 12) | All PreK Enrollment (charters & districts) | All PreK PPR (charters & Districts based on average) | Local PPR | Other PPR | State PPR | Federal PPR | Indeterminate PPR | Total PPR
RECEIPTS/REVENUES FROM LOCAL SOURCES |  |  | 1000 |  |  |  |  |  |  |  |  |  | 0 |  | 372861 |  |  | 5281.512869407098 | 1027.052410952071 | 4455.853366267858 | 1766.17397815808 | -349.9762606440469 | 12180.61636414106
 | AD VALOREM TAXES LEVIED BY LOCAL EDUCATION AGENCY |  |  |  |  |  |  |  |  |  |  |  | 0
 | 1 | General [NAME] | 1110 | 1380509986 | 336006298 | 51244458 |  |  |  |  |  |  | 1767760742
 | 2 | Tort Immunity Levy | 1120 |  |  |  |  |  |  |  |  |  | 0
 | 3 | [NAME]10 | 1130 |  |  |  |  |  |  |  |  |  | 0
 | 4 | Special Education Levy | 1140 |  |  |  |  |  |  |  |  |  | 0
 | 5 | Social Security/Medicare Only [NAME] | 1150 |  |  |  |  |  |  |  |  |  | 0
 | 6 | Area Vocational Construction Levy | 1160 |  |  |  |  |  |  |  |  |  | 0
 | 7 | Summer School Levy | 1170 |  |  |  |  |  |  |  |  |  | 0
 | 8 | Other Tax Levies (Describe & Itemize) | 1190 |  |  |  |  |  |  |  |  |  | 0
 | 9 | Total Ad Valorem Taxes Levied By [NAME] |  | 1380509986 | 336006298 | 51244458 | 0 | 0 | 0 | 0 | 0 | 0 | 1767760742 | 1767760742
 | PAYMENTS IN LIEU OF TAXES |  |  |  |  |  |  |  |  |  |  |  | 0
 | 10 | Mobile Home Privilege Tax | 1210 |  |  |  |  |  |  |  |  |  | 0
 | 11 | Payments from Local Housing Authorities | 1220 |  |  |  |  |  |  |  |  |  | 0
 | 12 | Corporate Personal Property Replacement Taxes 11 | 1230 | 147403350 |  | 54106078 |  |  |  |  |  |  | 201509428
 | 13 | Other Payments in Lieu of Taxes | 1290 |  |  |  |  |  |  |  |  |  | 0
 | 14 | Total Payments in Lieu of Taxes |  | 147403350 | 0 | 54106078 | 0 | 0 | 0 | 0 | 0 | 0 | 201509428 | 201509428
 |  | TOTAL REVENUES FROM LOCAL SOURCES |  | 1527913336 | 336006298 | 105350536 | 0 | 0 | 0 | 0 | 0 | 0 | 1969270170 | 1969270170 | 441356834 | 1183.703401535693
REVENUES FROM OTHER SOURCES
 | TUITION
 | 15 | Regular Tuition from Pupils or Parents | 1311 | 254151
 | 16 | Regular Tuition from Other LEAs | 1312
 | 17 | Regular Tuition from Other Sources | 1313
 | 18 | Summer School Tuition from Pupils or Parents | 1321
 | 19 | Summer School Tuition from Other LEAs | 1322
 | 20 | Summer School Tuition from Other Sources | 1323
 | 21 | [NAME] from Pupils or Parents | 1331
 | 22 | [NAME] from Other LEAs | 1332
 | 23 | [NAME] from Other Sources | 1333
 | 24 | Special Education Tuition from Pupils or Parents | 1341
 | 25 | Special Education Tuition from Other LEAs | 1342
 | 26 | Special Education Tuition from Other Sources | 1343
 | 27 | [NAME] from Pupils or Parents | 1351
 | 28 | [NAME] from Other LEAs | 1352
 | 29 | [NAME] from Other Sources | 1353
 | 30 | Total Tuition |  | 254151 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 254151
 | TRANSPORTATION FEES
 | 31 | Regular Transportation Fees from Pupils or Parents | 1411
 | 32 | Regular Transportation Fees from Other LEAs | 1412
 | 33 | Regular Transportation Fees from Private Sources | 1413
 | 34 | Regular Transportation Fees from Co-curricular Activities | 1415
 | 35 | Summer School Transportation Fees from Pupils or Parents | 1421
 | 36 | Summer School Transportation Fees from Other LEAs | 1422
 | 37 | Summer School Transportation Fees from Other Sources | 1423
 | 38 | Vocational Transportation Fees from Pupils or Parents | 1431
 | 39 | Vocational Transportation Fees from Other LEAs | 1432
 | 40 | Vocational Transportation Fees from Other Sources | 1433
 | 41 | [NAME]. Transportation Fees from Pupils or Parents | 1441
 | 42 | [NAME]. Transportation Fees from Other LEAs | 1442
 | 43 | [NAME]. Transportation Fees from Other Sources | 1443
 | 44 | Adult Transportation Fees from Pupils or Parents | 1451
 | 45 | Adult Transportation Fees from Other LEAs | 1452
 | 46 | Adult Transportation Fees from Other Sources | 1453
 | 47 | Total Transportation Fees |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | EARNINGS ON INVESTMENTS
 | 48 | Interest on Investments | 1510 | 56189726 | 5404961 | 19724205 |  |  | 35586529
 | 49 | Gain or Loss on Sale of Investments | 1520
 | 50 | Total Earnings on Investments |  | 56189726 | 5404961 | 19724205 | 0 | 0 | 35586529 | 0 | 0 | 0 | 116905421
 | FOOD SERVICE
 | 51 | Sales to Pupils - Lunch | 1611 | 5019459
 | 52 | Sales to Pupils - Breakfast | 1612 | 437435
 | 53 | Sales to Pupils - A la Carte | 1613 | 1816696
 | 54 | Sales to Pupils - Other | 1614 | 481
 | 55 | Sales to Adults | 1620 | 1309182
 | 56 | Other Food Service | 1690 | 201197
 | 57 | Total Food Service |  | 8784450 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8784450
 | PUPIL ACTIVITIES
 | 58 | Admissions - Athletic | 1711
 | 59 | Admissions - Other (Describe & Itemize) | 1719
 | 60 | Fees | 1720
 | 61 | Book Store Sales | 1730
 | 62 | Other Pupil Activity Revenue (Describe & Itemize) | 1790
 | 63 | Total Pupil Activities |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TEXTBOOKS
 | 64 | Rentals - Regular Textbooks | 1811
 | 65 | Rentals - Summer School Textbooks | 1812
 | 66 | Rentals - Adult/Continuing Education Textbooks | 1813
 | 67 | Rentals - Other (Describe & Itemize) | 1819
 | 68 | Sales - Regular Textbooks | 1821
 | 69 | Sales - Summer School Textbooks | 1822
 | 70 | Sales - Adult/Continuing Education Textbooks | 1823
 | 71 | Sales - Other (Describe & Itemize) | 1829
 | 72 | Other (Describe & Itemize) | 1890
 | 73 | Total Textbooks |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | OTHER REVENUE FROM LOCAL SOURCES
 | 74 | Rentals | 1910 | 1994933
 | 75 | Contributions and Donations from Private Sources | 1920 | 7262006 |  |  |  |  | 355000
 | 76 | Services Provided Other LEAs | 1940
 | 77 | Refund of Prior Years' Expenditures | 1950
 | 78 | Payment from Other LEAs | 1991
 | 79 | Sale of Vocational Projects | 1992
 | 80 | Local Fees | 1993
 | 81 | Other (Describe & Itemize) | 1999 | 32008778 | 21646 | 153796697 |  |  | 35891607
 | 82 | Total Other Revenue from Local Sources |  | 41265717 | 21646 | 153796697 | 0 | 0 | 36246607 | 0 | 0 | 0 | 231330667
 | 83 | TOTAL REVENUES FROM OTHER SOURCES |  | 106494044 | 5426607 | 173520902 | 0 | 0 | 71833136 | 0 | 0 | 0 | 357274689 | 382947789
RECEIPTS/REVENUES FROM STATE SOURCES |  |  | 3000
Flow-through Revenue from State Sources |  |  | 2000
 | 83 | Flow-through Revenue from State Sources | 2100
 |  | Total State Flow-through |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 84 | Other Flow-Through (Describe & Itemize) | 2300
 | UNRESTRICTED GRANTS-IN-AID
 | 85 | General State Aid- Sec. 18-8.05 | 3001 | 888219861 |  | 134021541 |  |  | 18000000
 | 86 | General State Aid Hold Harmless/Supplemental | 3002
 | 87 | Reorganization Incentives | 3005
 | 88 | Other Unrestricted Grants-In-Aid from State Sources           (Describe & Itemize) | 3099
 | 89 | Total Unrestricted Grants-In-Aid |  | 888219861 | 0 | 134021541 | 0 | 0 | 18000000 | 0 | 0 | 0 | 1040241402
 | [NAME]
 | SPECIAL EDUCATION
 | 90 | Special Education - Private Facility Tuition | 3100
 | 91 | Special Education - Extraordinary | 3105
 | 92 | Special Education - Personnel | 3110
 | 93 | Special Education - Orphanage - Individual | 3120
 | 94 | Special Education - Orphanage - Summer | 3130
 | 95 | Special Education - Summer School | 3145
 | 96 | Special Education - Other (Describe & Itemize) | 3199
 | 97 | Total Special Education |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME]
 | 98 | Vocational Education - Tech. Prep. | 3200
 | 99 | Vocational Education - Coordination Grants | 3210
 | 100 | Vocational Education - Formula | 3215
 | 101 | Vocational Education - Jobs for Illinois Graduates | 3217 | 1086014
 | 102 | Vocational Education - Secondary Program Improvement | 3220 | 4588689
 | 103 | [NAME] | 3225 | 1075205
 | 104 | Vocational Education - Elem. Career Development Program | 3275
 | 105 | Vocational Education - Other (Describe & Itemize) | 3299
 | 106 | Total Vocational Education |  | 6749908 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6749908
 | BILINGUAL
 | 107 | Bilingual Education - Downstate - TPI | 3305
 | 108 | Bilingual Education - Downstate - TBE | 3310
 | 109 | Total Bilingual Education |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | OTHER STATE FUNDS
 | 110 | Gifted Education | 3350
 | 111 | State Free Lunch & Breakfast | 3360
 | 112 | School Breakfast Initiative | 3365 | 112191
 | 113 | Driver Education | 3370 | 2827507
 | 114 | Adult Education from Community College Board | 3410 |  |  |  |  |  |  |  |  |  | 0
 | 115 | Adult Education - Other (Describe & Itemize) | 3499 |  |  |  |  |  |  |  |  |  | 0
 |  | Total other State Funds |  | 2939698 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2939698
 | TRANSPORTATION
 | 116 | Transportation - Regular/Vocational | 3500
 | 117 | Transportation - Special Education | 3510
 | 118 | Transportation - Other (Describe & Itemize) | 3599
 | 119 | Total Transportation |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME]
 | 120 | Learning Improvement - Change Grants | 3610
 | 121 | Scientific Literacy | 3660
 | 122 | Truant Alternative/Optional Education | 3695
 | 123 | Early Childhood - Block Grant | 3705 | 117754200 |  |  |  |  |  |  |  |  | 117754200 | 117754200
 | 124 | Reading Improvement Block Grant | 3715
 | 125 | Reading Improvement Block Grant - Reading Recovery | 3720
 | 126 | Chicago General Education Block Grant | 3766 | 37274900
 | 127 | Chicago Educational Services Block Grant | 3767 | 384148886
 | 128 | School Safety & Educational Improvement Block Grant | 3775 | 14415060
 | 129 | Technology - Closing the Gaps | 3792
 | 130 | State [NAME] | 3800 | 287906
 | 131 | Illinois Arts Council Grants | 3801 | 81414
 | 132 | Illinois Scholars Program | 3803
 | 133 | Illinois Occupational Information Coordinating Committee | 3806
 | 134 | Project Success | 3807
 | 135 | IDOT Safety | 3808
 | 136 | IDOT Alcohol Awareness | 3809
 | 137 | State Charter Schools | 3815 | 3350502
 | 138 | [NAME] | 3825
 | 139 | Academic Early Warning List | 3830
 | 140 | Infrastructure Improvements - Planning/Construction | 3920
 | 141 | School Infrastructure - Maintenance Projects | 3925
 | 142 | Other Restricted Revenue from State Sources                     (Describe & Itemize) | 3999 | 19038045 |  |  |  |  | 60000
 | 143 | Total Other Restricted Grants |  | 576350913 | 0 | 0 | 0 | 0 | 60000 | 0 | 0 | 0 | 576410913 |  |  |  | Capital state revenue per student
 | 144 | Total Receipts from State Sources |  | 1474260380 | 0 | 134021541 | 0 | 0 | 18060000 | 0 | 0 | 0 | 1790566146 | 1661413942 | Total state deductions | 117754200 | 152081541 | 407.8773081657776
RECEIPTS/REVENUES FROM FEDERAL SOURCES |  |  | 4000
 | UNRESTRICTED GRANTS IN AID RECEIVED DIRECTLY FROM FEDERAL GOVT.
 |  | Flow-through Revenue from Federal Sources | 2200 | 0
 |  | Total Flow-Through Revenue from Federal Sources |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 145 | Federal Impact Aid | 4001 | 187425
 | 146 | Other Unrestricted Grants-In-Aid Received Directly                         from the Federal Govt. | 4009
 | 147 | Total Unrestricted  Grants-In-Aid Received Directly from the Federal Government |  | 187425 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 187425
 | [NAME] RECEIVED DIRECTLY FROM FEDERAL GOVERNMENT
 | 148 | Emergency School Assistance Act | 4025
 | 149 | ESEA - Title VII - Bilingual | 4030
 | 150 | ESEA - Title VI - Excellence in Education | 4035
 | 151 | Community Action Program - OEO | 4040
 | 152 | Head Start | 4045 | 37671358 |  |  |  |  |  |  |  |  | 37671358 | 37671358
 | 153 | Construction (Impact Aid) | 4050
 | 154 | EPA Grant Proceeds (Life/Safety Purposes Only) | 4055
 | 155 | MAGNET | 4060
 | 156 | Other Restricted Grants-In-Aid Received Directly From Federal Govt. (Describe & Itemize) | 4099 | 19857493
 | 157 | Total Restricted Grants-In-Aid Received Directly From Federal Government |  | 57528851 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 57528851
 | [NAME] RECEIVED FROM FEDERAL                           GOVT. THRU THE STATE
 | TITLE V
 | 158 | Title V - Innovation and Flexibility Formula | 4100 | 2875770
 | 159 | Title V - LEA Projects | 4105
 | 160 | Title V - Rural & Low Income Schools | 4107
 | 161 | Title V - Class Size Reduction | 4110
 | 162 | Title V - State Assessments | 4120
 | 163 | Title V - Other (Describe & Itemize) | 4199
 | 164 | Total Title V |  | 2875770 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2875770
 | FOOD SERVICE
 | 165 | National School Lunch Program | 4210 | 112567724
 | 166 | Special Milk Program | 4215
 | 167 | School Breakfast Program | 4220 | 20775784
 | 168 | Summer Food Service Admin/Program | 4225
 | 169 | Child & Adult Care Food Program | 4226 | 3541963
 | 170 | Food Service - Other (Describe & Itemize) | 4299 | 10522100
 | 171 | Total Food Service |  | 147407571 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 147407571
 | TITLE I
 | 172 | Title I - Low Income | 4300 | 262597788
 | 173 | Title I - Low Income - Neglected,  Private | 4305 | 540983
 | 174 | Title I - Capital Expenses | 4325
 | 175 | Title I - School Improvement | 4331 | 7940465
 | 176 | Title I - Comprehensive School Reform | 4332 | 180401
 | 177 | Title I - Reading First | 4334 | 13937043
 | 178 | Title I - Even Start | 4335 |  |  |  |  |  |  |  |  |  | 0
 | 179 | Title I - Migrant Education | 4340
 | 180 | Title I - Other (Describe & Itemize) | 4399 | 811184
 | 181 | Total Title I |  | 286007864 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 286007864
 | TITLE IV
 | 182 | Title IV - Safe & Drug Free Schools - Formula | 4400 | 3545742
 | 183 | Title IV - Safe & Drug Free Schools - Violence Prevention | 4406
 | 184 | Title IV - Community Service | 4420
 | 185 | Title IV - 21st Century | 4421 | 5873063
 | 186 | Title IV - Other (Describe & Itemize) | 4499
 | 187 | Total Title IV |  | 9418805 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9418805
 | FEDERAL SPECIAL EDUCATION
 | 188 | Fed - Spec Education - Preschool Flow-Through | 4600 | 1581056 |  |  |  |  |  |  |  |  | 1581056
 | 189 | Fed - Spec Education - Preschool Discretionary | 4605 | 475629 |  |  |  |  |  |  |  |  | 475629 | 2056685
 | 190 | Fed - Spec Education - IDEA - Flow Through/Low Incidence | 4620 | 75459885
 | 191 | Fed - Spec Education - IDEA - Room & Board | 4625 | 1282034
 | 192 | Fed - Spec Education - IDEA - Discretionary | 4630 | 2682378
 | 193 | Fed - Spec Education - IDEA - Other (Describe & Itemize) | 4699 | 239934
 | 194 | Total Federal - Special Education |  | 81720916 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 81720916
 | [NAME] (VE) PERKINS
 | 195 | VE - Perkins - Title IIA State Leadership | 4720 | 68944
 | 196 | VE - Perkins - Title IIC Secondary | 4745 | 8520373
 | 197 | VE - Perkins - Title IIC - Postsecondary/Adult | 4750 |  |  |  |  |  |  |  |  |  | 0
 | 198 | VE - Perkins - Title IIIE - Tech. Prep. | 4770
 | 199 | VE - Education to Careers - Implementation (DOL) | 4777
 | 200 | VE - Other (Describe & Itemize) | 4799
 | 201 | Total Vocational Education |  | 8589317 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8589317
 | OTHER RESTRICTED FEDERAL GRANTS
 | 202 | Federal - Adult Education | 4810 |  |  |  |  |  |  |  |  |  | 0
 | 203 | Emergency Immigrant Assistance | 4905
 | 204 | Title III - English Language Acquisition | 4909 | 9104133
 | 205 | Learn & Serve America | 4910 | 131031
 | 206 | McKinney Education for Homeless Children | 4920 | 627074
 | 207 | Title II - Eisenhower Professional Development Formula | 4930
 | 208 | Title II - Teacher Quality | 4932 | 43536403
 | 209 | Goals 2000 | 4945
 | 210 | Goals 2000 - Leadership | 4946
 | 211 | Department of Rehabilitation Services | 4950
 | 212 | Federal Charter Schools | 4960
 | 213 | School Renovation | 4980
 | 214 | IDEA Part B - Supplemental Activities | 4981
 | 215 | School Renovation - Technology | 4982
 | 216 | Federal Emergency Management Aid (FEMA/IEMA) | 4990
 | 217 | Medicaid Matching Funds - Administrative Outreach | 4991 | 10248932
 | 218 | Medicaid Matching Funds - Fee-for-Service Program | 4992 | 14008209
 | 219 | Other Restricted Revenue from Federal Sources                  (Describe & Itemize) | 4999 | 22376913 |  |  |  |  | 9139080
 | 220 | Total Other Restricted Grants Federal |  | 100032695 | 0 | 0 | 0 | 0 | 9139080 | 0 | 0 | 0 | 109171775 |  | Total Federal Deductions | 39728043
 | 221 | Total Revenues from Federal Sources |  | 693769214 | 0 | 0 | 0 | 0 | 9139080 | 0 | 0 | 0 | 702908294 | 658537395.67
 |  | Total Indeterminate Revenues |  |  |  |  |  |  |  |  |  |  | 0 | -130492498.52
 |  | Total PreK [NAME] from above sources |  | 157482243 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 157482243 | 157482243
TOTAL STATEWIDE REVENUES |  |  |  | 3802436974 | 341432905 | 412892979 | 0 | 0 | 99032216 | 0 | 0 | 0 | 4655795074 | 4541676798.15
 |  | Total Charter School Revenues from Federal Sources |  |  |  |  |  |  |  |  |  |  | 4642855.33
 |  | Total Charter School Revenues from State Sources |  |  |  |  |  |  |  |  |  |  | 11398004
 |  | Total Charter School Revenues from Local Sources |  |  |  |  |  |  |  |  |  |  | 0
 |  | Total Charter School Revenues from Indeterminate Sources |  |  |  |  |  |  |  |  |  |  | 130492498.52
 |  | Total Charter School Revenues |  |  |  |  |  |  |  |  |  |  | 146533357.85
 |  | Other charter school revenues not included in deductions from CPS totals.  CPS does not claim these as revenue.
 |  | Charter school "revenue" deductions are based on total charter school expenditure data from CPS.  Charter revenue totals used for charter PPR calcuations are based on charter audits, which include revenues that CPS does not report.
 |  |  |  | 4845693000
 |  |  |  | 4655795074
 |  |  |  | 189897926 | 509.2995137598193