BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 CHICAGO HEIGHTS, ILLINOIS ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED JUNE 30, 2016
ILLINOIS STATE BOARD OF EDUCATION School Business Services Division 100 North First Street, Springfield, Illinois 62777-0001 217/785-8779
Due to ROE on Friday, October 14th Due to ISBE on Tuesday, November 15th SD/JA16
Illinois School District/Joint Agreement Annual Financial Report * June 30, 2016
School District Joint Agreement
Accounting Basis: School District/Joint Agreement Information
Certified Public Accountant Information
(See instructions on inside of this page.)
X
CASH ACCRUAL
School District/Joint Agreement Number:
Name of Auditing Firm:
07-016-2060-17
GW & Associates, P.C
County Name:
Name of Audit Manager:
Cook
John Wysocki
Name of School District/Joint Agreement:
Address:
Bloom High School District 206
2617 Chicago Road
Filing Status:
Address:
100 W. 10th Street
City:
Submit electronic AFR directly to ISBE
City:
State:
So. Chicago Heights Phone Number:
Chicago Heights, IL
Click on the Link to Submit: Send ISBE a File
Email Address:
Zip Code:
IL
60411
Fax Number:
(708)755-8182
(708)755-8326
IL License Number (9 digit):
Expiration Date:
65025792 Zip Code:
Email Address:
60411
[email protected]
Annual Financial Report
Single Audit Status: ISBE Use Only
Type of Auditor's Report Issued:
Qualified Adverse Disclaimer
X
Unqualified
X X X
YES YES YES
NO Are Federal expenditures greater than $750,000? NO Is all Single Audit Information completed and attached? NO Were any financial statement or federal awards findings issued?
Reviewed by District Superintendent/Administrator
Reviewed by Township Treasurer (Cook County only)
Reviewed by Regional Superintendent/Cook ISC
Name of Township: District Superintendent/Administrator Name (Type or Print):
Dr. Lenell Navarre Email Address:
Township Treasurer Name (type or print)
RegionalSuperintendent/Cook ISC Name (Type or Print):
Dr. Robert G. Grossi
Dr. Vanessa Kinder (ISC#4)
Email Address:
Email Address:
[email protected] Telephone:
708-755-7010 Signature & Date:
Fax Number:
708-755-6859
Telephone:
Fax Number:
Telephone:
Fax Number:
(708-754-6859
(708)754-0208
708-754-6600
708-754-8687
Signature & Date:
* This form is based on 23 Illinois Administrative Code 100, Subtitle A, Chapter I, Subchapter C (Part 100). ISBE Form SD50-35/JA50-60 (05/16, Revised 9/26/2016)
Signature & Date: This form is based on 23 Illinois Administrative Code, Subtitle A, Chapter I, Subchapter C, Part 100. In some instances, use of open account codes (cells) may not be authorized by statute or administrative rule. Each school district or joint agreement is responsible for obtaining the concurring legal opinion and/or other s upporting authorization/documentation, as necessary, to use the applicable account code (cell).
Printed: 1/10/2017 afr-16-form 206 v1.xlsm
TABLE OF CONTENTS TAB Name Auditor's Questionnaire……………………………...………....…………………………..……….....................................................Aud Quest Comments Applicable to the Auditor's Questionnaire……..……..………………. ………………….…………………………. Aud Quest Financial Profile Information …………………………………………….…………………………………………….................................................. FP Info Estimated Financial Profile Summary…………………………………………………………………………………………………………...... Financial Profile Basic Financial Statements Assets-Liab Statement of Assets and Liabilities Arising from Cash Transactions/Statement of Position ………………............................................... Statement of Revenues Received/Revenues, Expenditures Disbursed/Expenditures, Other Sources (Uses) and Changes in Fund Balances (All Funds)…...……………..…………………….......................................... Acct Summary Revenues Statements of Revenues Received/Revenues (All Funds)………………………………………………………………................................. Expenditures Statements of Expenditures Disbursed/Expenditures Budget to Actual (All Funds)……………………….................................................... Supplementary Schedules Federal Stimulus - American Recovery and Reinvestment Act (ARRA) Schedule……………………………………………. ARRA Sched Schedule of Ad Valorem Tax Receipts…………………………………………………………………………………………….. Tax Sched Short-Term Long-Term Debt Schedule of Short-Term Debt/Long-Term Debt ………………………………………………………….................................................... Schedule of Restricted Local Tax Levies and Selected Revenue Sources/ Schedule of Tort Immunity Expenditures…………………………………..….……………….……………………..…....... Rest Tax Levies-Tort Im Statistical Section Cap Outlay Deprec Schedule of Capital Outlay and Depreciation……………………………………………………………………................................................ Estimated Operating Expenditures Per Pupil and Per Capita Tuition Charge Computation…………………………… PCTC-OEPP Estimated Indirect Cost Rate for Federal Programs (Section I, Section II)………………………………………………............................................. ICR Computation Report on Shared Services or Outsourcing ………………………………………………................................................................................................................ Shared Outsourced Serv. Administrative Cost Worksheet……………………………………………………………………….……………................................................ AC Itemization Schedule…………………………………………………………………………………………………................................................ ITEMIZATION Reference Page……………………………………………………………………………………………………….................................................. REF Notes, Opinion Letters, etc…… Opinion-Notes Deficit Reduction Calculation…… Deficit AFR Sum Calc Audit Checklist/Balancing Schedule………………………………………………………………………………................................................. AUDITCHECK Single Audit Section Single Audit Cover - CAP Annual Federal Compliance Report………………………………………………………………………………….............................................
AFR Page No. 2 2 3 4 5-6 7-8 9 - 14 15 - 22 23 24 25 26 27 28 - 29 30 31 32 33 34 35 36 37 - 46
INSTRUCTIONS/REQUIREMENTS: For School Districts/Joint Agreements All School Districts/Joint Agreements must complete this form (Note: joint agreement supplementary/statistical schedules may not be applicable)
Round all amounts to the nearest dollar. Do not enter cents. (Exception: 9 Month ADA on page 28, line 78) This form complies with Part 100 (Requirements for Accounting, Budgeting, Financial Reporting, and Auditing). 23, Illinois Administrative Code 100, Subtitle A, Chapter I, Subchapter C (Part 100)
Any errors left unresolved by the Audit Checklist/Balancing Schedule must be explained in the itemization page. Submit AFR Electronically * The Annual Financial Reports (AFR) must be submitted directly through the Attachment Manager to the AFR Group by the Auditor or School District designated personnel (Please see Instructions for complete submission procedures). Attachment Manager Link Note: CD/Disk no longer accepted.
* AFR supporting documentation must be embedded as Microsoft Word (.doc), Word Perfect (*.wpd) or Adobe (*.pdf) and inserted within tab "Opinions & Notes". These documents include: The Audit, Management letter, Opinion letters, Compliance letters, Financial notes etc…. For embedding instructions see "Opinions & Notes" tab of this form. Note: Adobe Acrobat (*.pdf) files cannot be embedded if you do not have the software. Simply attach files as separate docs in the Attachment Manager and they will be embedded for you.
Submit Paper Copy of AFR with Signatures 1) The auditor must send three paper copies of the AFR form (cover through page 8 at minimum) to the School District with the auditor signature. Note: School Districts and Regional Superintendents may prefer a complete paper copy in lieu of an electronic file. Please comply with their requests as neccessary.
2) Upon receipt, the School District retains one copy for their records, signs, and forwards the remaining two copies to the Regional Superintendent's office no later than October 15, annually. 3) Upon receipt, the Regional Superintendent's office retains one copy for their records, signs, and forwards the remaining paper copy to ISBE no later than November 15, annually. * Yellow Book, CPE, and Peer Review requirements must be met if the Auditor issues an opinion stating "Governmental Auditing Standards" were utilized. Single Audit Act
Qualifications of Auditing Firm * School District/Joint Agreement entities must verify the qualifications of the auditing firm by requesting the most current peer review report and the corresponding acceptance letter from the approved peer review program, for the current peer review period. * A school district/joint agreement who engages with an auditing firm who is not licensed and qualified will be required to complete a new audit by a qualified auditing firm at the school district's/joint agreement's expense.
Printed: 1/10/2017 afr-16-form 206 v1.xlsm
GW & ASSOCIATES, P.C. CERTIFIED PUBLIC ACCOUNTANTS
2617 Chicago Road South Chicago Heights, IL 60411
Phone (708) 755-8182 Fax (708) 755-8326 INDEPENDENT AUDITOR’S REPORT
To the Board of Trustees Bloom Township High School District 206 We have audited the accompanying financial statements of Bloom Township High School District 206, which comprise the statement of assets and liabilities arising from cash transactions/statement of position as of June 30, 2016, and the related statement of revenues received/revenues, expenditures disbursed/expenditures, other sources (uses) and changes in fund balances (all funds); revenues received/revenues (all funds); and expenditures disbursed/expenditures budget to actual (all funds) for the year then ended, and the related notes to the financial statements. Management’s Responsibility for the Financial Statements Management is responsible for the preparation and fair presentation of these financial statements in accordance with the financial reporting provisions of the Illinois State Board of Education. Management is also responsible for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Auditor’s Responsibility Our responsibility is to express an opinion on these financial statements based on our audit. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free from material misstatement. An audit involves performing procedures to obtain audit evidence about the amounts and disclosures in the financial statements. The procedures selected depend on the auditor’s judgment, including the assessment of the risks of material misstatement of the financial statements, whether due to fraud or error. In making those risk assessments, the auditor considers internal control relevant to the entity’s preparation and fair presentation of the financial statements in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the entity’s internal control. Accordingly, we express no such opinion. An audit also includes evaluating the appropriateness of accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluating the overall presentation of the financial statements. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our audit opinions. Basis for Adverse Opinion on U.S. Generally Accepted Accounting Principles As described in Note 1, the financial statements are prepared by Bloom Township High School District 206 on the basis of the financial reporting provisions of the Illinois State Board of Education, which is a basis of accounting other than accounting principles generally accepted in the United States of America, to meet the requirements of the Illinois State Board of Education. The effects on the financial statements of the variances between the regulatory basis of accounting described in Note 1 and accounting principles generally accepted in the United States of America, although not reasonably determinable, are presumed to be material. Adverse Opinion on U.S. Generally Accepted Accounting Principles In our opinion, because of the significance of the matter discussed in the Basis for Adverse Opinion on U.S. Generally Accepted Accounting Principles paragraph, the financial statements referred to above do not present fairly, in accordance with accounting principles generally accepted in the United States of America, the financial position of Bloom Township High School District 206 as of June 30, 2016, or changes in financial position for the year then ended.
Basis for Qualified Opinion As more fully described in Note 4 to the financial statements, Bloom Township High School District 206 has not determined the complete historical cost of its fixed assets. The regulatory basis of accounting described in Note 1 requires reporting of historical costs of fixed assets in the General Fixed Asset Account Group on the statement of assets and liabilities arising from cash transactions/statement of position. Quantification of the effects of that departure on the financial statements is not practicable. As more fully described in Note 10 to the financial statements, Bloom Township High School District 206 has omitted disclosures required by Governmental Accounting Standards Board Statement No. 45, Accounting and Financial Reporting by Employers for Postemployment Benefits Other than Pensions. Quantification of the effects of that departure on the financial statements is not practicable. Qualified Opinion on Regulatory Basis of Accounting In our opinion, except for the effects of the matters discussed in the Basis for Qualified Opinion paragraph, the financial statements referred to above present fairly, in all material respects, the assets and liabilities resulting from cash transactions of the of Bloom Township High School District 206 as of June 30, 2016, and the revenues it received and expenditures it paid for the year then ended, in accordance with the financial reporting provisions of the Illinois State Board of Education as described in Note 1. Other Matters Other Information Our audit was conducted for the purpose of forming an opinion on the financial statements that collectively comprise Bloom Township High School District 206’s basic financial statements. The information on pages 2 through 4, the Supplementary Schedules on pages 23 through 26, the Statistical Section on pages 27 through 29, the information on pages 30 through 34 and page 36, and the Supplementary Information are presented for purposes of additional analysis and are not a required part of the financial statements of Bloom Township High School District 206. The schedule of expenditures of federal awards is presented for purposes of additional analysis as required by Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, and is also not a required part of the financial statements. The information on pages 3 through 4, the Supplementary Schedules on pages 23 through 26, the information on pages 27, 32 and 33 and the schedule of expenditures of federal awards are the responsibility of management and were derived from and relate directly to the underlying accounting and other records used to prepare the basic financial statements. Such information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or to the basic financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the information is fairly stated in all material respects in relation to the financial statement taken as a whole. The information on pages 28 through 31, page 34 and page 36 and the supplementary information have not been subjected to the auditing procedures applied in the audit of the basic financial statements and, accordingly, we do not express an opinion or provide any assurance on them. Other Reporting Required by Government Auditing Standards In accordance with Government Auditing Standards, we have also issued our report dated December 20, 2016, on our consideration of Bloom Township High School District 206’s internal control over financial reporting and on our tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements and other matters. The purpose of that report is to describe the scope of our testing of internal control over financial reporting and compliance and the results of that testing, and not to provide an opinion on internal control over financial reporting or on compliance. That report is an integral part of an audit performed in accordance with Government Auditing Standards in considering Bloom Township High School District 206’s internal control over financial reporting and compliance.
South Chicago Heights, Illinois December 20, 2016
GW & ASSOCIATES, P.C. CERTIFIED PUBLIC ACCOUNTANTS
2617 Chicago Road South Chicago Heights, IL 60411
Phone (708) 755-8182 Fax (708) 755-8326
INDEPENDENT AUDITOR’S REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS To the Board of Education Bloom Township High School District 206 We have audited, in accordance with the auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards issued by the Comptroller General of the United States, the statement of assets and liabilities arising from cash transactions/statement of position as of June 30, 2016, and the related statement of revenues received/revenues, expenditures disbursed/expenditures, other sources (uses) and changes in fund balances (all funds); revenues received/revenues (all funds); and expenditures disbursed/expenditures budget to actual (all funds) of Bloom Township High School District 206, as of and for the year ended June 30, 2016, and the related notes to the financial statements, which collectively comprise Bloom Township High School District 206’s basic financial statements and have issued our report thereon dated December 20, 2016. Because the financial statements were prepared on the basis of the financial reporting provisions of the Illinois State Board of Education, which is a basis of accounting other than accounting principles generally accepted in the United States of America, our opinion was adverse. However, except for the effect of incomplete fixed asset records and omitted disclosures required by Governmental Accounting Standards Board Statement No. 45, Accounting and Financial Reporting by Employers for Postemployment Benefits Other Than Pensions, the financial statements were found to be fairly presented in accordance with the financial reporting provisions of the Illinois State Board of Education. Internal Control over Financial Reporting In planning and performing our audit of the financial statements, we considered Bloom Township High School District 206’s internal control over financial reporting (internal control) to determine the audit procedures that are appropriate in the circumstances for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of Bloom Township High School District 206’s internal control. Accordingly, we do not express an opinion on the effectiveness of Bloom Township High School District 206’s internal control. Our consideration of internal control was for the limited purpose described in the preceding paragraph and was not designed to identify all deficiencies in internal control that might be material weaknesses or significant deficiencies and therefore, material weaknesses or significant deficiencies may exist that were not identified. However, as described in the accompanying schedule of findings and questioned costs, we identified certain deficiencies in internal control that we consider to be material weaknesses and significant deficiencies. A deficiency in internal control exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, misstatements on a timely basis. A material weakness is a deficiency, or a combination of deficiencies, in internal control such that there is a reasonable possibility that a material misstatement of the entity’s financial statements will not be prevented, or detected and corrected on a timely basis. We consider the deficiencies described in the accompanying schedule of findings and questioned costs as 2016-001 and 2016-003 to be material weaknesses. A significant deficiency is a deficiency, or a combination of deficiencies, in internal control that is less severe than a material weakness, yet important enough to merit attention by those charged with governance. We consider the deficiencies described in the accompany schedule of findings and questioned costs as 2016-002 to be significant deficiencies.
Compliance and Other Matters As part of obtaining reasonable assurance about whether Bloom Township High School District 206’s financial statements are free from material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of our audit, and accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance or other matters that are required to be reported under Government Auditing Standards.. Bloom Township High School District 206’s Response to Findings Bloom Township High School District 206s response to the findings identified in our audit is described in the accompanying schedule of findings and questioned costs. Bloom Township High School District 206’s response was not subjected to the auditing procedures applied in the audit of the financial statements and, accordingly, we express no opinion on it. Purpose of this Report The purpose of this report is solely to describe the scope of our testing of internal control and compliance and the results of that testing, and not to provide an opinion on the effectiveness of the entity’s internal control or on compliance. This report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the entity’s internal control and compliance. Accordingly, this communication is not suitable for any other purpose.
South Chicago Heights, Illinois December 20, 2016
Page 2
Page 2
AUDITOR'S QUESTIONNAIRE INSTRUCTIONS: If your review and testing of State, Local, and Federal Programs revealed any of the following statements to be true, then check the box on the left, and attach the appropriate findings/comments.
PART A - FINDINGS 1. One or more school board members, administrators, certified school business officials, or other qualifying district employees failed to file economic interest statements pursuant to the Illinois Government Ethics Act. [5 ILCS 420/4A-101] 2. One or more custodians of funds failed to comply with the bonding requirements pursuant to Sections 8-2, 10-20.19 or 19-6 of the School Code. [105 ILCS 5/8-2; 10-20.19; 19-6] 3. One or more contracts were executed or purchases made contrary to the provisions of Section 10-20.21 of the School Code. [105 ILCS 5/10-20.21] 4. One or more violations of the Public Funds Deposit Act or the Public Funds Investment Act were noted. [30 ILCS 225/1 et. seq. and 30 ILCS 235/1 et. seq.] 5. Restricted funds were commingled in the accounting records or used for other than the purpose for which they were restricted. 6. One or more short-term loans or short-term debt instruments were executed in non-conformity with the applicable authorizing statute or without statutory Authority. 7. One or more long-term loans or long-term debt instruments were executed in non-conformity with the applicable authorizing statute or without statutory Authority. 8. Corporate Personal Property Replacement Tax monies were deposited and/or used without first satisfying the lien imposed pursuant to the State Revenue Sharing Act. [30 ILCS 115/12] 9. One or more interfund loans were made in non-conformity with the applicable authorizing statute or without statutory authorization. 10. One or more interfund loans were outstanding beyond the term provided by statute. 11. One or more permanent transfers were made in non-conformity with the applicable authorizing statute/regulation or without statutory/regulatory authorization. 12. Substantial, or systematic misclassification of budgetary items such as, but not limited to, revenues, receipts, expenditures, disbursements or expenses were observed. 13. The Chart of Accounts used to define and control budget and accounting records does not conform to the minimum requirements imposed by ISBE rules pursuant to Sections 2-3.27 and 2-3.28 of the School Code. [105 ILCS 5/2-3.27; 2-3.28]
x
14. At least one of the following forms was filed with ISBE late: The FY15 AFR (ISBE FORM 50-35), FY15 Annual Statement of Affairs (ISBE Form 50-37) and FY16 Budget (ISBE FORM 50-36). Explain in the comments box below. ISBE rules pursuant to Sections 3-15.1, 10-17, and 17-1 of the School Code [105 ILCS 5/3-15.1; 5/10-17; 5/17-1]
PART B - FINANCIAL DIFFICULTIES/CERTIFICATION Criteria pursuant to Section 1A-8 of the School Code [105 ILCS 5/1A-8] 15. The district has issued tax anticipation warrants or tax anticipation notes in anticipation of a second year's taxes when warrants or notes in anticipation of current year taxes are still outstanding, as authorized by Sections 17-16 or 34-23 thru 34-27 of the School Code. [105 ILCS 5/17-16 or 34-23 thru 34-27] 16. The district has issued short-term debt against two future revenue sources, such as, but not limited to, tax anticipation warrants and General State Aid certificates or tax anticipation warrants and revenue anticipation notes. 17. The district has issued school or teacher orders for wages as permitted in Sections 8-16, 32-7.2 and 34-76 of the School Code or issued funding bonds for this purpose pursuant to Section 19-8 of the School Code. [105 ILCS 5/8-6, 32-7.2, 34-76, and 19-8] 18. The district has for two consecutive years shown an excess of expenditures/other uses over revenues/other sources and beginning fund balances on its annual financial report for the aggregate totals of the Educational, Operations & Maintenance, Transportation, and Working Cash Funds.
PART C - OTHER ISSUES 19. Student Activity Funds, Imprest Funds, or other funds maintained by the district were excluded from the audit. 20. Findings, other than those listed in Part A (above), were reported (e.g. student activity fund findings). 21. Federal Stimulus Funds were not maintained and expended in accordance with the American Recovery and Reinvestment Act (ARRA) of 2009. If checked, an explanation must be provided.
Effective Date:
1/1/1994
x
22. Check this box if the district is subject to the Property Tax Extension Limitation Law.
x
23. If the type of Auditor Report designated on the cover page is other than an unqualified opinion and is due to reason(s) other than solely Cash Basis Accounting, please check and explain the reason(s) in the box below.
Part A - #14 - Prior Year AFR was filed late in part due to a change in audit firms. Part C - #23 - A qualified opinion was issued regarding the regulatory basis of accounting because of a lack of historical cost data for fixed assets and the omission of disclosures related to GASB Statement No. 45
Printed: 1/10/2017 afr-16-form 206 v1.xlsm
(Ex: 00/00/0000)
Page 2
Page 2
PART D - EXPLANATION OF ACCOUNTING PRACTICES FOR LATE MANDATED CATEGORICAL PAYMENTS (For School Districts who report on an Accrual/Modified Accrual Accounting Basis only) School districts that report on the accrual/modified accrual basis of accounting must identify where late mandated categorical payments (Acct Codes 3100, 3105, 3110, 3500, and 3510) are recorded. Depending on the accounting procedure these amounts will be used to adjust the Direct Receipts/Revenues in calculation 1 and 2 of the Financial Profile Score. In FY2016, identify those late payments recorded as Intergovermental Receivables, Other Recievables, or Deferred Revenue & Other Current Liabilities or Direct Receipts/Revenue. Payments should only be listed once.
Date:
24. Enter the date that the district used to accrue mandated categorical payments
25. For the listed mandated categorical (Revenue Code (3110, 3500, 3510, 3100, 3105) that were vouchered prior to June 30th, but not released until after year end as reported in ISBE FRIS system, enter the amounts that were accrued in the chart below.
Account Name Deferred Revenues (490)
3110
3500
3510
3100
3105
Mandated Categoricals Payments (3110, 3500, 3510, 3100, 3105)
Total
0
Direct Receipts/Revenue Mandated Categoricals Payments (3110, 3500, 3510, 3100, 3105
0
Total
0
* Revenue Code (3110-Sp Ed Personnel, 3510-Sp Ed Transportation, 3500-Regular/Vocational Transportation, 3105-Sp Ed Funding for Children Requiring Services,3100-Sp Ed Private Facilities)
PART E - QUALIFICATIONS OF AUDITING FIRM * School District/Joint Agreement entities must verify the qualifications of the auditing firm by requesting the most current peer review report and the corresponding acceptance letter from the approved peer review program for the current peer review. * A school district/joint agreement who engages with an auditing firm who is not licensed and qualified will be required to complete a new audit by a qualified auditing firm at the school district's/joint agreement's expense.
Comments Applicable to the Auditor's Questionnaire: A16djH
GW & Associates, P.C. Name of Audit Firm (print) The undersigned affirms that this audit was conducted by a qualified auditing firm and in accordance with the applicable standards [23 Illinois Administrative Code Part 100] and the scope of the audit conformed to the requirements of subsection (a) or (b) of 23 Illinois Administrative Code Part 100 Section 110, as applicable. 12/20/16
Signature
mm/dd/yyyy
Page 3
Page 3
A
B
C
D
E
F
G
H
I
J
K
L
M
FINANCIAL PROFILE INFORMATION
1 2 3 Required to be completed for School Districts only. 4 Tax Rates (Enter the tax rate - ex: .0150 for $1.50) 5 A. 6 Equalized Assessed Valuation (EAV): Tax Year 2015 7 8 9 10 11 12 13 B. 14 15 16 17 18 19 20 C. 21 22 23 24 25 26 27 28 D. 29 30 31 32 33 34 35 36 37 38 39 40 E. 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
Operations & Maintenance
Educational
0.026753 +
Rate(s):
691,831,875
Transportation
0.004191
Combined Total
0.002794 =
+
Working Cash
0.033740
0.004190
Results of Operations * Disbursements/ Expenditures
Receipts/Revenues
50,113,810
Excess/ (Deficiency)
51,535,944
Fund Balance
(1,422,134)
12,863,860 * The numbers shown are the sum of entries on Pages 7 & 8, lines 8, 17, 20, and 81 for the Educational, Operations & Maintenance, Transportation and Working Cash Funds.
Short-Term Debt ** CPPRT Notes
TAWs
0 Other
TANs
0
+
+
GSA Certificates
TO/EMP. Orders
0
+
0
+
Total
0 = 0 ** The numbers shown are the sum of entries on page 25. Long-Term Debt Check the applicable box for long-term debt allowance by type of district.
x
47,736,399
a. 6.9% for elementary and high school districts, b. 13.8% for unit districts.
Long-Term Debt Outstanding: c. Long-Term Debt (Principal only) Outstanding:……….....……………....
Acct
511
6,541,696
Material Impact on Financial Position If applicable, check any of the following items that may have a material impact on the entity's financial position during future reporting periods. Attach sheets as needed explaining each item checked. Pending Litigation Material Decrease in EAV Material Increase/Decrease in Enrollment Adverse Arbitration Ruling Passage of Referendum Taxes Filed Under Protest Decisions By Local Board of Review or Illinois Property Tax Appeal Board (PTAB) Other Ongoing Concerns (Describe & Itemize) Comments:
Printed: 1/10/2017 afr-16-form 206 v1.xlsm
0
+
Page 4
A B 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
Page 4
C
D
E
F
G
H
I
K
L
M
N
O
PQ R
ESTIMATED FINANCIAL PROFILE SUMMARY (Go to the following website for reference to the Financial Profile) www.isbe.net/sfms/p/profile.htm
District Name: District Code: County Name:
Bloom High School District 206 07-016-2060-17 Cook
1. Fund Balance to Revenue Ratio: Total Sum of Fund Balance (P8, Cells C81, D81, F81 & I81) Total Sum of Direct Revenues (P7, Cell C8, D8, F8 & I8) Less: Operating Debt Pledged to Other Funds (P8, Cell C54 thru D74) (Excluding C:D57, C:D61, C:D65, C:D69 and C:D73)
Total Funds 10, 20, 40, 70 + (50 & 80 if negative) Funds 10, 20, 40, & 70, Minus Funds 10 & 20
12,863,860.00 50,113,810.00 0.00
Funds 10, 20 & 40 Funds 10, 20, 40 & 70, Minus Funds 10 & 20
51,535,944.00 50,113,810.00 0.00
2. Expenditures to Revenue Ratio: Total Sum of Direct Expenditures (P7, Cell C17, D17, F17, I17) Total Sum of Direct Revenues (P7, Cell C8, D8, F8, & I8) Less: Operating Debt Pledged to Other Funds (P8, Cell C54 thru D74) (Excluding C:D57, C:D61, C:D65, C:D69 and C:D73) Possible Adjustment:
Total
Total Funds 10, 20 40 & 70 Funds 10, 20, 40 divided by 360
12,863,860.00 143,155.40
4. Percent of Short-Term Borrowing Maximum Remaining: Tax Anticipation Warrants Borrowed (P25, Cell F6-7 & F11) EAV x 85% x Combined Tax Rates (P3, Cell J7 and J10)
Score
4
0.257
Weight Value
0.35 1.40
Score
3
Ratio 1.028
Adjustment Weight Value
3. Days Cash on Hand: Total Sum of Cash & Investments (P5, Cell C4, D4, F4, I4 & C5, D5, F5 & I5) Total Sum of Direct Expenditures (P7, Cell C17, D17, F17 & I17)
Ratio
Total Funds 10, 20 & 40 (.85 x EAV) x Sum of Combined Tax Rates
0.00 19,841,046.34
5. Percent of Long-Term Debt Margin Remaining:
Total
Long-Term Debt Outstanding (P3, Cell H37) Total Long-Term Debt Allowed (P3, Cell H31)
6,541,696.00 47,736,399.38
Days
Score
2
Weight Value
0.10 0.20
Percent
Score
4
100.00
Weight Value
0.10 0.40
Percent 86.29
Score
4
Weight Value
0.10 0.40
Estimated 2017 Financial Profile Designation:
*
Printed: 1/10/2017 afr-16-form 206 v1.xlsm
1.05
89.85
Total Profile Score:
38 39 40 41 42
0 0.35
3.45 * REVIEW
Total Profile Score may change based on data provided on the Financial Profile Information, page 3 and by the timing of mandated categorical payments. Final score will be calculated by ISBE.
BASIC FINANCIAL STATEMENTS STATEMENT OF ASSETS AND LIABILITIES ARISING FROM CASH TRANSACTIONS STATEMENT OF POSITION AS OF JUNE 30, 2016
Page 5
A 1
ASSETS (Enter Whole Dollars)
2 3 4 5 6 7 8 9 10 11 12 13
CURRENT ASSETS (100)
14 15 16 17 18 19 20 21 22 23
CAPITAL ASSETS (200)
24 25 26 27 28 29 30 31 32 33 34
CURRENT LIABILITIES (400)
35 36 37 38 39 40 41
LONG-TERM LIABILITIES (500)
Cash (Accounts 111 through 115) Investments
B Acct. #
1
Page 5
C
D
E
F
G
H
I
J
K
(10)
(20)
(30)
(40)
(50)
(60)
(70)
(80)
(90)
Educational
Operations & Maintenance
Debt Services
Transportation
Municipal Retirement/Social Security
Capital Projects
Working Cash
Tort
Fire Prevention & Safety
8,006,114
1,841,356
1,623,819
852,630
2,132,244
25,807
2,163,760
49,371
39,152
8,006,114
1,841,356
1,623,819
852,630
2,132,244
25,807
2,163,760
49,371
39,152
0
0
0
0
0 0
0 0
0
0
0
0
0
0
0
0
0
8,006,114
1,841,356
1,623,819
852,630
2,132,244
25,807
2,163,760
49,371
39,152
8,006,114
1,841,356
1,623,819
852,630
2,132,244
25,807
2,163,760
49,371
39,152
120
Taxes Receivable
130
Interfund Receivables
140
Intergovernmental Accounts Receivable
150
Other Receivables
160
Inventory
170
Prepaid Items
180
Other Current Assets (Describe & Itemize)
190
Total Current Assets
Works of Art & Historical Treasures
210
Land
220
Building & Building Improvements
230
Site Improvements & Infrastructure
240
Capitalized Equipment
250
Construction in Progress
260
Amount Available in Debt Service Funds
340
Amount to be Provided for Payment on Long-Term Debt
350
Total Capital Assets
Interfund Payables
410
Intergovernmental Accounts Payable
420
Other Payables
430
Contracts Payable
440
Loans Payable
460
Salaries & Benefits Payable
470
Payroll Deductions & Withholdings
480
Deferred Revenues & Other Current Liabilities
490
Due to Activity Fund Organizations
493
Total Current Liabilities
Long-Term Debt Payable (General Obligation, Revenue, Other)
0 0
511
Total Long-Term Liabilities Reserved Fund Balance
714
Unreserved Fund Balance
730
Investment in General Fixed Assets Total Liabilities and Fund Balance
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
BASIC FINANCIAL STATEMENTS STATEMENT OF ASSETS AND LIABILITIES ARISING FROM CASH TRANSACTIONS STATEMENT OF POSITION AS OF JUNE 30, 2016
Page 6
A 1
ASSETS (Enter Whole Dollars)
2 3 4 5 6 7 8 9 10 11 12 13
CURRENT ASSETS (100)
14 15 16 17 18 19 20 21 22 23
CAPITAL ASSETS (200)
24 25 26 27 28 29 30 31 32 33 34
CURRENT LIABILITIES (400)
35 36 37 38 39 40 41
LONG-TERM LIABILITIES (500)
Cash (Accounts 111 through 115) Investments
B
L
Acct. #
Agency Fund
1
130 140
Intergovernmental Accounts Receivable
150
Other Receivables
160
Inventory
170
Prepaid Items
180
Other Current Assets (Describe & Itemize)
190
352,755
Total Current Assets
Works of Art & Historical Treasures
210
Land
220
Building & Building Improvements
230
Site Improvements & Infrastructure
240
Capitalized Equipment
250
Construction in Progress
260
Amount Available in Debt Service Funds
340
Amount to be Provided for Payment on Long-Term Debt
350
330,172 16,102,901 2,851,102 341,452
19,625,627
Total Capital Assets
420
Other Payables
430
Contracts Payable
440
Loans Payable
460
Salaries & Benefits Payable
470
Payroll Deductions & Withholdings
480
Deferred Revenues & Other Current Liabilities
490
Due to Activity Fund Organizations
493
Total Current Liabilities
352,755 352,755 6,541,696 6,541,696
511
Total Long-Term Liabilities Reserved Fund Balance
714
Unreserved Fund Balance
730
Investment in General Fixed Assets
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
1,623,819 4,917,877 6,541,696
410
Intergovernmental Accounts Payable
Total Liabilities and Fund Balance
General LongTerm Debt
352,755
Interfund Receivables
Long-Term Debt Payable (General Obligation, Revenue, Other)
General Fixed Assets
120
Taxes Receivable
Interfund Payables
M N Account Groups
352,755
19,625,627 19,625,627
6,541,696
Page 6
BASIC FINANCIAL STATEMENT STATEMENT OF REVENUES RECEIVED/REVENUES, EXPENDITURES/DISBURSED/EXPENDITURES, OTHER SOURCES (USES) AND CHANGES IN FUND BALANCE ALL FUNDS - FOR THE YEAR ENDING JUNE 30, 2016
Page 7
A
B
1 Description
Acct #
(Enter Whole Dollars)
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Page 7
C
D
E
F
G
H
I
J
K
(10)
(20)
(30)
(40)
(50)
(60)
(70)
(80)
(90)
Educational
Operations & Maintenance
Debt Services
Transportation
Municipal Retirement/ Social Security
Capital Projects
Working Cash
Tort
Fire Prevention & Safety
RECEIPTS/REVENUES LOCAL SOURCES FLOW-THROUGH RECEIPTS/REVENUES FROM ONE DISTRICT TO ANOTHER DISTRICT STATE SOURCES
1000 2000
FEDERAL SOURCES
4000
3000
Total Direct Receipts/Revenues Receipts/Revenues for "On Behalf" Payments
2
3998
Total Receipts/Revenues
20,159,736
2,777,491
4,672,553
1,501,006
1,982,252
385
131,524
1,771
1,606
0 13,151,639 8,549,832 41,861,207
0 2,000,000 0 4,777,491
0 0 4,672,553
0 1,842,582 0 3,343,588
0 382,683 0 2,364,935
0 0 385
0 0 131,524
0 0 1,771
0 0 1,606
10,384,274 52,245,481
4,777,491
4,672,553
3,343,588
2,364,935
385
131,524
1,771
1,606
23,333,429 16,242,466 112,674 1,745,673 0 41,434,242
6,193,365 0 0 0 6,193,365
547,979 1,118,024 3,079 0 0 1,669,082
0
0
0 4,636,700 4,636,700
3,908,337 0 0 0 3,908,337
0
0 0
0 0 0
10,384,274 51,818,516
0 6,193,365
0 4,636,700
0 3,908,337
0 1,669,082
0 0
0 0
0 0
695,853
385
1,771
1,606
DISBURSEMENTS/EXPENDITURES Instruction
1000
Support Services
2000
Community Services
3000
Payments to Other Districts & Govermental Units
4000
Debt Service
5000
Total Direct Disbursements/Expenditures Disbursements/Expenditures for "On Behalf" Payments Total Disbursements/Expenditures
2
4180
0 0
Excess of Direct Receipts/Revenues Over (Under) Direct
20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
Disbursements/Expenditures
3
426,965
(1,415,874)
35,853
(564,749)
131,524
OTHER SOURCES/USES OF FUNDS OTHER SOURCES OF FUNDS (7000) PERMANENT TRANSFER FROM VARIOUS FUNDS 12
Abolishment of the Working Cash Fund
12
7110
Abatement of the Working Cash Fund Transfer of Working Cash Fund Interest
7110
Transfer Among Funds
7130
Transfer of Interest
7140
Transfer from Capital Project Fund to O&M Fund Transfer of Excess Fire Prevention & Safety Tax and Interest Proceeds
7150 7160
0
0
0
7120
4
to O&M Fund Transfer to Excess Fire Prevention & Safety Bond and Interest Proceeds 7170 5
to Debt Service Fund SALE OF BONDS (7200)
Principal on Bonds Sold
7210
Premium on Bonds Sold
7220
Accrued Interest on Bonds Sold
7230 6
Sale or Compensation for Fixed Assets Transfer to Debt Service to Pay Principal on Capital Leases
7300
Transfer to Debt Service to Pay Interest on Capital Leases
7500
Transfer to Debt Service to Pay Principal on Revenue Bonds
7600
Transfer to Debt Service Fund to Pay Interest on Revenue Bonds
7700
Transfer to Capital Projects Fund
7800
ISBE Loan Proceeds
7900
Other Sources Not Classified Elsewhere
7990
Total Other Sources of Funds OTHER USES OF FUNDS (8000)
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
0 0 0 0
7400
0
0
0
0
0
0
0
0
0
0
BASIC FINANCIAL STATEMENT STATEMENT OF REVENUES RECEIVED/REVENUES, EXPENDITURES/DISBURSED/EXPENDITURES, OTHER SOURCES (USES) AND CHANGES IN FUND BALANCE ALL FUNDS - FOR THE YEAR ENDING JUNE 30, 2016
Page 8
A
B
1 Description
Acct #
(Enter Whole Dollars)
2 46 47 48 49 50 51
Abolishment or Abatement of the Working Cash Fund Transfer of Working Cash Fund Interest Transfer Among Funds
12
12
D
E
F
G
H
I
J
K
(20)
(30)
(40)
(50)
(60)
(70)
(80)
(90)
Educational
Operations & Maintenance
Debt Services
Transportation
Municipal Retirement/ Social Security
Capital Projects
Working Cash
Tort
Fire Prevention & Safety
8110
0
8120
0
8130
Transfer of Interest
8140
Transfer from Capital Project Fund to O&M Fund Transfer of Excess Fire Prevention & Safety Tax & Interest Proceeds to
8150
4
O&M Fund Transfer of Excess Fire Prevention & Safety Bond and Interest Proceeds
53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77
to Debt Service Fund
80 81
C (10)
PERMANENT TRANSFER TO VARIOUS OTHER FUNDS (8100)
52
78 79
Page 8
5
Taxes Pledged to Pay Principal on Capital Leases
0
8160
0
8170
0
8410
Grants/Reimbursements Pledged to Pay Principal on Capital Leases
8420
Other Revenues Pledged to Pay Principal on Capital Leases
8430
Fund Balance Transfers Pledged to Pay Principal on Capital Leases
8440
Taxes Pledged to Pay Interest on Capital Leases
8510
Grants/Reimbursements Pledged to Pay Interest on Capital Leases
8520
Other Revenues Pledged to Pay Interest on Capital Leases
8530
Fund Balance Transfers Pledged to Pay Interest on Capital Leases
8540
Taxes Pledged to Pay Principal on Revenue Bonds
8610
Grants/Reimbursements Pledged to Pay Principal on Revenue Bonds
8620
Other Revenues Pledged to Pay Principal on Revenue Bonds
8630
Fund Balance Transfers Pledged to Pay Principal on Revenue Bonds
8640
Taxes Pledged to Pay Interest on Revenue Bonds
8710
Grants/Reimbursements Pledged to Pay Interest on Revenue Bonds
8720
Other Revenues Pledged to Pay Interest on Revenue Bonds
8730
Fund Balance Transfers Pledged to Pay Interest on Revenue Bonds
8740
Taxes Transferred to Pay for Capital Projects
8810
Grants/Reimbursements Pledged to Pay for Capital Projects
8820
Other Revenues Pledged to Pay for Capital Projects
8830
Fund Balance Transfers Pledged to Pay for Capital Projects
8840
Transfer to Debt Service Fund to Pay Principal on ISBE Loans
8910
Other Uses Not Classified Elsewhere
8990
Total Other Uses of Funds
0
0
0
0
0
0
0
0
0
Total Other Sources/Uses of Funds
0
0
0
0
0
0
0
0
0
Excess of Receipts/Revenues and Other Sources of Funds (Over/Under) Expenditures/Disbursements and Other Uses of Funds Fund Balances - July 1, 2015
695,853
385
131,524
1,771
1,606
7,579,149
426,965
(1,415,874) 3,257,230
1,587,966
35,853
1,417,379
(564,749)
1,436,391
25,422
2,032,236
47,600
37,546
8,006,114
1,841,356
1,623,819
852,630
2,132,244
25,807
2,163,760
49,371
39,152
Other Changes in Fund Balances - Increases (Decreases) (Describe & Itemize)
Fund Balances - June 30, 2016
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
STATEMENT OF REVENUES RECEIVED/REVENUES FOR THE YEAR ENDING JUNE 30, 2016
Page 9
A
B
1 Description
Acct #
(Enter Whole Dollars)
2 3
Page 9
C
D
E
F
G
H
I
J
K
(10)
(20)
(30)
(40)
(60)
(70)
(80)
(90)
Educational
Operations & Maintenance
Debt Services
Transportation
(50) Municipal Retirement/ Social Security
Capital Projects
Working Cash
Tort
Fire Prevention & Safety
RECEIPTS/REVENUES FROM LOCAL SOURCES (1000)
4 5 6 7 8 9 10 11 12
AD VALOREM TAXES LEVIED BY LOCAL EDUCATION AGENCY
13 14 15 16 17 18
PAYMENTS IN LIEU OF TAXES
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
TUITION
41 42 43 44 45 46 47 48 49 50 51
TRANSPORTATION FEES
Designated Purposes Levies (1110-1120)
1100
7
16,072,665
8
1130
Leasing Purposes Levy Special Education Purposes Levy
FICA/Medicare Only Purposes Levies
1140 1150
Area Vocational Construction Purposes Levy
1160
Summer School Purposes Levy
1170
Other Tax Levies (Describe & Itemize)
1190
Total Ad Valorem Taxes Levied By District
4,672,545
1,501,006
928,568
131,524
1,040
1,040
0
131,524
1,040
1,040
0
0
0
0
1,104 1,040 950,815
16,073,705
2,734,189
3,028,492 0 3,028,492
0
4,672,545
1,501,006
1,879,383
1200
Mobile Home Privilege Tax
1210
Payments from Local Housing Authorities
1220 9
Corporate Personal Property Replacement Taxes Other Payments in Lieu of Taxes (Describe & Itemize)
1230 1290
Total Payments in Lieu of Taxes 1300
Regular - Tuition from Pupils or Parents (In State)
1311
Regular - Tuition from Other Districts (In State)
1312
Regular - Tuition from Other Sources (In State)
1313
Regular - Tuition from Other Sources (Out of State)
1314
Summer Sch - Tuition from Pupils or Parents (In State)
1321
Summer Sch - Tuition from Other Districts (In State)
1322
Summer Sch - Tuition from Other Sources (In State)
1323
Summer Sch - Tuition from Other Sources (Out of State)
1324
CTE - Tuition from Pupils or Parents (In State)
1331
CTE - Tuition from Other Districts (In State)
1332
CTE - Tuition from Other Sources (In State)
1333
CTE - Tuition from Other Sources (Out of State)
1334
Special Ed - Tuition from Pupils or Parents (In State)
1341
Special Ed - Tuition from Other Districts (In State)
1342
Special Ed - Tuition from Other Sources (In State)
1343
Special Ed - Tuition from Other Sources (Out of State)
1344
Adult - Tuition from Pupils or Parents (In State)
1351
Adult - Tuition from Other Districts (In State)
1352
Adult - Tuition from Other Sources (In State)
1353
Adult - Tuition from Other Sources (Out of State)
1354
0
0
0
Total Tuition 1400
Regular -Transp Fees from Pupils or Parents (In State)
1411
Regular - Transp Fees from Other Districts (In State)
1412
Regular - Transp Fees from Other Sources (In State)
1413
Regular - Transp Fees from Co-curricular Activities (In State)
1415
Regular Transp Fees from Other Sources (Out of State)
1416
Summer Sch - Transp. Fees from Pupils or Parents (In State)
1421
Summer Sch - Transp. Fees from Other Districts (In State)
1422
Summer Sch - Transp. Fees from Other Sources (In State)
1423
Summer Sch - Transp. Fees from Other Sources (Out of State) CTE - Transp Fees from Pupils or Parents (In State)
1424 1431
Printed Date: 1/10/2017 afr-16-form 206 v1.xlsm
2,733,085
0
90,000 0 0
0
90,000
STATEMENT OF REVENUES RECEIVED/REVENUES FOR THE YEAR ENDING JUNE 30, 2016
Page 10
A
B
1 Description (Enter Whole Dollars)
2 52 53 54 55 56 57 58 59 60 61 62 63
CTE - Transp Fees from Other Districts (In State)
Acct #
C
D
E
F
G
H
I
J
K
(10)
(20)
(30)
(40)
(60)
(70)
(80)
(90)
Educational
Operations & Maintenance
Debt Services
Transportation
(50) Municipal Retirement/ Social Security
Capital Projects
Working Cash
Tort
Fire Prevention & Safety
1432
CTE - Transp Fees from Other Sources (In State)
1433
CTE - Transp Fees from Other Sources (Out of State)
1434
Special Ed - Transp Fees from Pupils or Parents (In State)
1441
Special Ed - Transp Fees from Other Districts (In State)
1442
Special Ed - Transp Fees from Other Sources (In State)
1443
Special Ed - Transp Fees from Other Sources (Out of State)
1444
Adult - Transp Fees from Pupils or Parents (In State)
1451
Adult - Transp Fees from Other Districts (In State)
1452
Adult - Transp Fees from Other Sources (In State)
1453
Adult - Transp Fees from Other Sources (Out of State)
1454
0
Total Transportation Fees
64 65 66 67
EARNINGS ON INVESTMENTS
1500
Interest on Investments
1510
Gain or Loss on Sale of Investments
1520
68 69 70 71 72 73 74 75
FOOD SERVICE
76 77 78 79 80 81 82
DISTRICT/SCHOOL ACTIVITY INCOME
83 84 85 86 87 88 89 90 91 92 93
TEXTBOOK INCOME
94 95 96 97 98 99 100 101
33 0
33
1600
Sales to Pupils - Lunch
1611
Sales to Pupils - Breakfast
1612
Sales to Pupils - A la Carte
1613
Sales to Pupils - Other (Describe & Itemize)
1614
Sales to Adults
1620
Other Food Service (Describe & Itemize)
1690
Total Food Service
420 141,422 1,755 16,573 160,170
1700
Admissions - Athletic
1711
Admissions - Other (Describe & Itemize)
1719
Fees
1720
Book Store Sales
1730
Other District/School Activity Revenue (Describe & Itemize)
1790
Total District/School Activity Income
20,008 20,008
0
1800
Rentals - Regular Textbooks
1811
Rentals - Summer School Textbooks
1812
Rentals - Adult/Continuing Education Textbooks
1813
Rentals - Other (Describe & Itemize)
1819
Sales - Regular Textbooks
1821
Sales - Summer School Textbooks
1822
Sales - Adult/Continuing Education Textbooks
1823
Sales - Other (Describe & Itemize)
1829
Other (Describe & Itemize)
1890
180,743
18,266 199,009
Total Textbook Income 1900
Rentals
1910
Contributions and Donations from Private Sources
1920
Impact Fees from Municipal or County Governments
1930
Services Provided Other Districts
1940
Refund of Prior Years' Expenditures
1950
Payments of Surplus Moneys from TIF Districts
1960
Drivers' Education Fees
1970
Printed Date: 1/10/2017 afr-16-form 206 v1.xlsm
260,834 260,834
Total Earnings on Investments
OTHER REVENUE FROM LOCAL SOURCES
Page 10
39,157
3,546 0 65,589
0 28,385
(25) 0
0
12,869
385
12,869
385
0
731
566
731
566
STATEMENT OF REVENUES RECEIVED/REVENUES FOR THE YEAR ENDING JUNE 30, 2016
Page 11
A
B
1 Description (Enter Whole Dollars)
2 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144
Acct #
Proceeds from Vendors' Contracts
1980
School Facility Occupation Tax Proceeds
1983
Payment from Other Districts
1991
Sale of Vocational Projects
1992
Other Local Fees (Describe & Itemize)
1993
Other Local Revenues (Describe & Itemize)
1999
Total Other Revenue from Local Sources Total Receipts/Revenues from Local Sources
1000
Page 11
C
D
E
F
G
H
I
J
K
(10)
(20)
(30)
(40)
(60)
(70)
(80)
(90)
Educational
Operations & Maintenance
Debt Services
Transportation
(50) Municipal Retirement/ Social Security
Capital Projects
Working Cash
Tort
Fire Prevention & Safety
2,095
307,131 417,518
14,917 43,302
20,159,736
2,777,491
(25)
4,672,553
0
0
0
0
0 0
0
1,501,006
1,982,252
385
131,524
1,771
1,606
0
0
FLOW-THROUGH RECEIPTS/REVENUES FROM ONE DISTRICT TO ANOTHER DISTRICT (2000) Flow-through Revenue from State Sources
2100
Flow-through Revenue from Federal Sources
2200
0
Other Flow-Through (Describe & Itemize) 2300 Total Flow-Through Receipts/Revenues from One District to Another 2000 District
0
0
10,999,764 479,738
2,000,000
RECEIPTS/REVENUES FROM STATE SOURCES (3000) UNRESTRICTED GRANTS-IN-AID (3001-3099) General State Aid- Sec. 18-8.05
3001
General State Aid - Hold Harmless/Supplemental
3002
Reorganization Incentives (Accounts 3005-3021) Other Unrestricted Grants-In-Aid from State Sources (Describe & Itemize)
382,683
3005 3099
1,940 11,481,442
Total Unrestricted Grants-In-Aid
2,000,000
0
0
382,683
RESTRICTED GRANTS-IN-AID (3100 - 3900) SPECIAL EDUCATION Special Education - Private Facility Tuition
3100
Special Education - Funding for Children Requiring Sp ED Services
3105
Special Education - Personnel
3110
Special Education - Orphanage - Individual
3120
Special Education - Orphanage - Summer Individual
3130
Special Education - Summer School
3145
Special Education - Other (Describe & Itemize)
3199
53,347 469,184 422,661 291,841 0 13,241 1,250,274
Total Special Education
0
0
CAREER AND TECHNICAL EDUCATION (CTE) CTE - Technical Education - Tech Prep
3200
CTE - Secondary Program Improvement (CTEI)
3220
CTE - WECEP
3225
CTE - Agriculture Education
3235
CTE - Instructor Practicum
3240
CTE - Student Organizations
3270
CTE - Other (Describe & Itemize)
3299
92,988
92,988
Total Career and Technical Education
0
0
BILINGUAL EDUCATION Bilingual Ed - Downstate - TPI and TBE
3305
Bilingual Education Downstate - Transitional Bilingual Education
3310
Total Bilingual Ed
Printed Date: 1/10/2017 afr-16-form 206 v1.xlsm
0
1,303 0 1,303
0
0
0
0
STATEMENT OF REVENUES RECEIVED/REVENUES FOR THE YEAR ENDING JUNE 30, 2016
Page 12
A
B
1 Description (Enter Whole Dollars)
2 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188
Acct #
State Free Lunch & Breakfast
3360
School Breakfast Initiative
3365
Driver Education
3370
Adult Ed (from ICCB)
3410
Adult Ed - Other (Describe & Itemize)
3499
Page 12
C
D
E
F
G
H
I
J
K
(10)
(20)
(30)
(40)
(60)
(70)
(80)
(90)
Educational
Operations & Maintenance
Debt Services
Transportation
(50) Municipal Retirement/ Social Security
Capital Projects
Working Cash
Tort
Fire Prevention & Safety
10,098 0 47,422
TRANSPORTATION Transportation - Regular and Vocational
3500
Transportation - Special Education
3510
Transportation - Other (Describe & Itemize)
3599
739,075 1,103,507 0
Total Transportation Learning Improvement - Change Grants
3610
Scientific Literacy
3660
Truant Alternative/Optional Education
3695
Early Childhood - Block Grant
3705
Reading Improvement Block Grant
3715
Reading Improvement Block Grant - Reading Recovery
3720
Continued Reading Improvement Block Grant
3725
Continued Reading Improvement Block Grant (2% Set Aside)
3726
Chicago General Education Block Grant
3766
Chicago Educational Services Block Grant
3767
School Safety & Educational Improvement Block Grant
3775
Technology - Technology for Success
3780
State Charter Schools
3815
Extended Learning Opportunities - Summer Bridges
3825
Infrastructure Improvements - Planning/Construction
3920
0
1,842,582
0
74,706 0
0
School Infrastructure - Maintenance Projects
3925
Other Restricted Revenue from State Sources (Describe & Itemize)
3999
193,406
0
3000
1,670,197 13,151,639
0 2,000,000
0 0
1,842,582 1,842,582
0 382,683
0 0
0 0
0 0
0 0
0
0
0
0
0
0
0
0
0
0
0
Total Restricted Grants-In-Aid Total Receipts from State Sources
RECEIPTS/REVENUES FROM FEDERAL SOURCES (4000) UNRESTRICTED GRANTS-IN-AID RECEIVED DIRECTLY FROM FEDERAL GOVT (4001-4009) Federal Impact Aid 4001 Other Unrestricted Grants-In-Aid Received Directly from the Fed Govt 4009 (Describe & Itemize) Total Unrestricted Grants-In-Aid Received Directly from the Federal Govt RESTRICTED GRANTS-IN-AID RECEIVED DIRECTLY FROM FEDERAL GOVT (4045-4090) Head Start
4045
Construction (Impact Aid)
4050
MAGNET Other Restricted Grants-In-Aid Received Directly from the Federal Govt (Describe & Itemize) Total Restricted Grants-In-Aid Received Directly from Federal Govt
4060 4090
0
389,901 389,901
RESTRICTED GRANTS-IN-AID RECEIVED FROM FEDERAL GOVT THRU THE STATE (4100-4999) TITLE VI Title VI - Innovation and Flexibility Formula
4100
Title VI - District Projects
4105
Printed Date: 1/10/2017 afr-16-form 206 v1.xlsm
0
0
0
STATEMENT OF REVENUES RECEIVED/REVENUES FOR THE YEAR ENDING JUNE 30, 2016
Page 13
A
B
1 Description (Enter Whole Dollars)
2 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211
Acct #
Title VI - Rural Education Initiative (REI)
4107
Title V - Other (Describe & Itemize)
4199
C
D
E
F
G
H
I
J
K
(10)
(20)
(30)
(40)
(60)
(70)
(80)
(90)
Educational
Operations & Maintenance
Debt Services
Transportation
(50) Municipal Retirement/ Social Security
Capital Projects
Working Cash
Tort
Fire Prevention & Safety
0
Total Title V
Page 13
0
0
0
FOOD SERVICE Breakfast Start-Up Expansion
4200
National School Lunch Program
4210
Special Milk Program
4215
School Breakfast Program
4220
Summer Food Service Program
4225
Child Adult Care Food Program
4226
Fresh Fruits & Vegetables
4240
Food Service - Other (Describe & Itemize)
4299
1,137,777 133,772
1,271,549
Total Food Service
0
TITLE I Title I - Low Income
4300
Title I - Low Income - Neglected, Private
4305
Title I - Comprehensive School Reform
4332
Title I - Reading First
4334
Title I - Even Start
4335
Title I - Reading First SEA Funds
4337
Title I - Migrant Education
4340
Title I - Other (Describe & Itemize)
4399
Total Title I
212 213 214 215 216
TITLE IV
217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240
FEDERAL - SPECIAL EDUCATION
Title IV - Safe & Drug Free Schools - Formula
4400
Title IV - 21st Century Comm Learning Centers
4421
Title IV - Other (Describe & Itemize)
4499
1,864,900 4,896,187
0
0
0
0
0
0
649,491
0
0
0
0 267,921 267,921
0
0 0 0
Total Title IV Fed - Spec Education - Preschool Flow-Through
4600
Fed - Spec Education - Preschool Discretionary Fed - Spec Education - IDEA - Flow Through
4605 4620
Fed - Spec Education - IDEA - Room & Board
4625
Fed - Spec Education - IDEA - Discretionary
4630 4699
Fed - Spec Education - IDEA - Other (Describe & Itemize)
3,031,287
Total Federal - Special Education
0 649,491 0
CTE - PERKINS CTE - Perkins - Title IIIE - Tech Prep
4770
CTE - Other (Describe & Itemize) Total CTE - Perkins
4799
Federal - Adult Education
4810
ARRA - General State Aid - Education Stabilization
4850
ARRA - Title I - Low Income
4851
ARRA - Title I - Neglected, Private
4852
ARRA - Title I - Delinquent, Private
4853
ARRA - Title I - School Improvement (Part A)
4854
ARRA - Title I - School Improvement (Section 1003g)
4855
ARRA - IDEA - Part B - Preschool
4856
ARRA - IDEA - Part B - Flow-Through
4857
ARRA - Title IID - Technology-Formula
4860
ARRA - Title IID - Technology-Competitive
4861
ARRA - McKinney - Vento Homeless Education
4862
Printed Date: 1/10/2017 afr-16-form 206 v1.xlsm
0
0
STATEMENT OF REVENUES RECEIVED/REVENUES FOR THE YEAR ENDING JUNE 30, 2016
Page 14
A
B
1 Description (Enter Whole Dollars)
2 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275
Acct #
ARRA - Child Nutrition Equipment Assistance
4863
Impact Aid Formula Grants
4864
Impact Aid Competitive Grants
4865
Qualified Zone Academy Bond Tax Credits
4866
Qualified School Construction Bond Credits
4867
Build America Bond Tax Credits
4868
Build America Bond Interest Reimbursement
4869
ARRA - General State Aid - Other Govt Services Stabilization
4870
Other ARRA Funds - II
4871
Other ARRA Funds - III
4872
Other ARRA Funds - IV
4873
Other ARRA Funds - V
4874
ARRA - Early Childhood
4875
Other ARRA Funds VII
4876
Other ARRA Funds VIII
4877
Other ARRA Funds IX
4878
Other ARRA Funds X
4879
Other ARRA Funds Ed Job Fund Program
4880
Total Stimulus Programs Race to the Top Program
4901
Race to the Top - Preschool Expansion Grant
4902
Advanced Placement Fee/International Baccalaureate
4904
Title III - Immigrant Education Program (IEP)
4905
Title III - Language Inst Program - Limited Eng (LIPLEP)
4909
Learn & Serve America
4910
McKinney Education for Homeless Children
4920
Title II - Eisenhower Professional Development Formula
4930
Page 14
C
D
E
F
G
H
I
J
K
(10)
(20)
(30)
(40)
(60)
(70)
(80)
(90)
Educational
Operations & Maintenance
Debt Services
Transportation
(50) Municipal Retirement/ Social Security
Capital Projects
Working Cash
Tort
Fire Prevention & Safety
0
0 0
0
0
0
0
0
0
0
11,864
283,826
Title II - Teacher Quality
4932
Federal Charter Schools
4960
Medicaid Matching Funds - Administrative Outreach
4991
Medicaid Matching Funds - Fee-for-Service Program Other Restricted Revenue from Federal Sources (Describe & Itemize)
4992 4999
71,700 544,137 163,256
8,159,931
0
0
0
0
0
0
0
4000
8,549,832
0
0
0
0
0
0
0
0
41,861,207
4,777,491
4,672,553
3,343,588
2,364,935
385
131,524
1,771
1,606
Total Restricted Grants-In-Aid Received from the Federal Govt Thru the State
Total Receipts/Revenues from Federal Sources Total Direct Receipts/Revenues
Printed Date: 1/10/2017 afr-16-form 206 v1.xlsm
0
STATEMENT OF EXPENDITURES DISBURSED/EXPENDITURES, BUDGET TO ACTUAL FOR THE YEAR ENDING JUNE 30, 2016
Page 15
A 1
Description (Enter Whole Dollars)
2 3
B Funct #
Page 15
C
D
E
F
G
H
I
J
K
(100)
(200)
(300)
(400)
(500)
(600)
(700)
(800)
(900)
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other Objects
Non-Capitalized Equipment
Termination Benefits
Total
0
30,897
L Budget
10 - EDUCATIONAL FUND (ED)
4 INSTRUCTION (ED) Regular Programs 5 Tuition Payment to Charter Schools 6 Pre-K Programs 7 Special Education Programs (Functions 1200-1220) 8 Special Education Programs Pre-K 9 Remedial and Supplemental Programs K-12 10 Remedial and Supplemental Programs Pre-K 11 Adult/Continuing Education Programs 12 CTE Programs 13 Interscholastic Programs 14 Summer School Programs 15 Gifted Programs 16 Driver's Education Programs 17 Bilingual Programs 18 Truant Alternative & Optional Programs 19 Pre-K Programs - Private Tuition 20 Regular K-12 Programs - Private Tuition 21 Special Education Programs K-12 - Private Tuition 22 Special Education Programs Pre-K - Tuition 23 Remedial/Supplemental Programs K-12 - Private Tuition 24 Remedial/Supplemental Programs Pre-K - Private Tuition 25 Adult/Continuing Education Programs - Private Tuition 26 CTE Programs - Private Tuition 27 Interscholastic Programs - Private Tuition 28 Summer School Programs - Private Tuition 29 Gifted Programs - Private Tuition 30 Bilingual Programs - Private Tuition 31 Truants Alternative/Optional Ed Progms - Private Tuition 32 33 Total Instruction 10 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
SUPPORT SERVICES (ED)
52 53
Tort Immunity Services
1000 1100
11,783,121
1,897,565
679,738
678,169
0
3,080,588
479,381
0 333,655
0 17,797
76,526
0
0
645
0
1,075,204 919,759 0
138,719 43,176 0
29,284 200,309 0
135,872 56,416 0
184,730 198,227 265,851
15,968 9,890 53,981
7,451
0
0
15,069,490 0 1,350 3,993,104 0 645 0 0 1,477,842 1,235,902 0 0 208,149 208,117 319,832 0 0 818,998 0 0 0 0 0 0 0 0 0 0 23,333,429
25,441,551
0
1,712,820 1,856,690 218,025 133,203 66,042 157,070 4,143,850
1,667,294 1,550,100 221,950 35,000 80,000 160,659 3,715,003
0
1,278,993 606,782 191,728 2,077,503
1,299,271 617,388 133,350 2,050,009
2,173,548 695,550 836,034
2,823,515 578,400 551,025
0 3,705,132
225,000 4,177,940
1115 1125 1200
1,350 5,157
1225 1250 1275 1300 1400 1500 1600
73,197 0
6,038
25,566 10,204
1650 1700 1800 1900
0
1910 1911
818,998
1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1000
17,507,480
2,638,680
1,251,082
888,254
149,723
826,386
71,824
1,460,946 1,541,979 158,623 52,472 0 80,124 3,294,144
241,485 281,363 29,797 33,081 0 8,139 593,865
10,000 20,852 29,044 47,650 66,042 41,175 214,763
389 12,496 561
26,284 39,730
496,793 470,251 74,505 1,041,549
176,883 75,239 14,421 266,543
428,635 33,532 92,875 555,042
36,680 27,760 2,571 67,011
10,000 548,356 682,639
1,078,679 106,063 152,873
1,077,499 26,962 0
2,300 9,049 13
0
5,070 5,120 509
0
1,240,995
0 1,337,615
1,104,461
11,362
0
10,699
0
16,037,772
4,108,522 1,000
1,414,382 1,235,678
219,760 203,747 270,690
1,950,000
2000
SUPPORT SERVICES - PUPILS Attendance & Social Work Services
2110
Guidance Services
2120
Health Services
2130
Psychological Services
2140
Speech Pathology & Audiology Services
2150
Other Support Services - Pupils (Describe & Itemize)
2190
Total Support Services - Pupils
2100
0
0
0 1,348 1,348
0
0
140,002 0 7,356 147,358
SUPPORT SERVICES - INSTRUCTIONAL STAFF Improvement of Instruction Services
2210
Educational Media Services
2220
Assessment & Testing
2230
Total Support Services - Instructional Staff
2200
0 0 0
SUPPORT SERVICES - GENERAL ADMINISTRATION Board of Education Services
2310
Executive Administration Services
2320
Special Area Administration Services
Total Support Services - General Administration
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
2330 2360 2370 2300
0
STATEMENT OF EXPENDITURES DISBURSED/EXPENDITURES, BUDGET TO ACTUAL FOR THE YEAR ENDING JUNE 30, 2016
Page 16
A 1 2 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
B
Description
Funct #
(Enter Whole Dollars)
C
D
E
F
G
H
I
J
K
(100)
(200)
(300)
(400)
(500)
(600)
(700)
(800)
(900)
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other Objects
Non-Capitalized Equipment
Termination Benefits
Total
L Budget
SUPPORT SERVICES - SCHOOL ADMINISTRATION Office of the Principal Services Other Support Services - School Admin (Describe & Itemize)
2410 2490
Total Support Services - School Administration
2400
1,343,648 479,324 1,822,972
309,988 143,107 453,095
107,625 254,468 13,990
33,487 9,952 0 203,277 0 246,716
9,098
21,741
0
1,375
1,950
9,098
21,741
0
1,375
1,950
0
4,045 104 0
0
0
0
4,149
0
1,687,800 622,431 2,310,231
1,414,655 546,500 1,961,155 146,750 246,200 190,801
0
145,477 264,524 165,851 64,700 1,653,094 160,223 2,453,869
1,594,600 196,750 2,375,101
SUPPORT SERVICES - BUSINESS Direction of Business Support Services
2510
Fiscal Services
2520
Operation & Maintenance of Plant Services
2540
Pupil Transportation Services
2550
Food Services
2560
Internal Services
2570
Total Support Services - Business
2500
561,406 0 937,489 0
0 151,961 64,700 4,470
320 0 (100)
0
221,131
883,941 160,223 1,044,384
671,370
3,122
674,492
515,000 0
0 43,665 46,787
0 0
0
0
0
32,747 0 259,244 586,155 1,552,638
254,453 656,050 1,425,503
1,231,015
0
17,571
149,308
0
(757) 16,242,466
15,704,711
0
SUPPORT SERVICES - CENTRAL Direction of Central Support Services
2610
Planning, Research, Development, & Evaluation Services
2620
Information Services
2630
Staff Services
2640
Data Processing Services
2660
32,747 171,059 234,930 405,989
60,059 50,632 110,691
Total Support Services - Central
2600
Other Support Services (Describe & Itemize)
2900
Total Support Services
2000
8,743,138
3,008,525
75 COMMUNITY SERVICES (ED)
3000
16,927
2,172
76 PAYMENTS TO OTHER DISTRICTS & GOVT UNITS (ED) 77 PAYMENTS TO OTHER GOVT UNITS (IN-STATE) Payments for Regular Programs 78 Payments for Special Education Programs 79 Payments for Adult/Continuing Education Programs 80 Payments for CTE Programs 81 Payments for Community College Programs 82 Other Payments to In-State Govt. Units (Describe & Itemize) 83 Total Payments to Other Govt Units (In-State) 84 85 Payments for Regular Programs - Tuition 86 Payments for Special Education Programs - Tuition Payments for Adult/Continuing Education Programs - Tuition 87 88 Payments for CTE Programs - Tuition 89 Payments for Community College Programs - Tuition 90 Payments for Other Programs - Tuition 91 Other Payments to In-State Govt Units
4000
92 93 94 95
Page 16
Total Payments to Other Govt Units -Tuition State)
(In
4110
28,126 256,928 989,171 (757) 3,092,909 71,175
22,400
112,674
0 0
4120 4130 4140 4170 4190
93,651
4100
93,651
4210 4220
0 0 0 1,652,022
4240 4270 4280 4290
1,652,022
1,652,022
Payments for Regular Programs - Transfers
4310
Payments for Special Education Programs - Transfers
4320
0 0
Payments for Adult/Continuing Ed Programs-Transfers
4330
0
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
16,740 8,000 24,740 460,000
0 0 0 0 0
4230
4200
0 0 0 0 93,651 0 93,651 0 1,652,022
144,095
460,000
STATEMENT OF EXPENDITURES DISBURSED/EXPENDITURES, BUDGET TO ACTUAL FOR THE YEAR ENDING JUNE 30, 2016
Page 17
A 1 2 96 97 98 99 100 101 102
Description (Enter Whole Dollars)
B Funct #
139 140 141 142
F
G
H
I
J
K
(400)
(500)
(600)
(700)
(800)
(900)
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other Objects
Non-Capitalized Equipment
Termination Benefits
Total
L Budget
4340
0 0
Payments for Other Programs - Transfers
4380
0
Other Payments to In-State Govt Units - Transfers
4390
0
Total Payments to Other Govt Units -Transfers (In-State) Payments to Other Govt Units (Out-of-State) Total Payments to Other Govt Units
4300
0
0
93,651
1,652,022
0 0 1,745,673
4400 4000
0 484,740
5000
0 0 0 0 0 0 0 0
5110 5120 5130 5140 5150
0
5100 5200
0
5000
0 0
6000
26,267,545
5,649,377
4,508,817
2,141,669
149,723
2,495,979
221,132
0
Excess (Deficiency) of Receipts/Revenues Over Disbursements/Expenditures
41,434,242
41,775,097
426,965
20 - OPERATIONS & MAINTENANCE FUND (O&M)
COMMUNITY SERVICES (O&M)
131 PAYMENTS TO OTHER DIST & GOVT UNITS (O&M) 132 PAYMENTS TO OTHER GOVT UNITS (IN-STATE) Payments for Special Education Programs 133 Payments for CTE Programs 134 135 136 137 138
E (300)
4370
118 SUPPORT SERVICES (O&M) 119 SUPPORT SERVICES - PUPILS Other Support Services - Pupils (Describe & Itemize) 120 121 SUPPORT SERVICES - BUSINESS Direction of Business Support Services 122 Facilities Acquisition & Construction Services 123 Operation & Maintenance of Plant Services 124 Pupil Transportation Services 125 Food Services 126 127 Total Support Services - Business Other Support Services (Describe & Itemize) 128 129 Total Support Services 130
D (200)
Payments for Community College Program - Transfers
113 PROVISIONS FOR CONTINGENCIES (ED) 114 Total Direct Disbursements/Expenditures
117
C (100)
Payments for CTE Programs - Transfers
103 DEBT SERVICES (ED) 104 DEBT SERVICES - INTEREST ON SHORT-TERM DEBT Tax Anticipation Warrants 105 Tax Anticipation Notes 106 Corporate Personal Prop. Repl. Tax Anticipation Notes 107 State Aid Anticipation Certificates 108 Other Interest on Short-Term Debt 109 110 Total Interest on Short-Term Debt 111 Debt Services - Interest on Long-Term Debt 112 Total Debt Services
115 116
Page 17
Other Payments to In-State Govt. Units (Describe & Itemize)
2000 2190
2530 2540
2,761,327
416,735
4,560
915
1,068,001
799,910
975,894
0
5,996
43,739
1,117,215
996,500
115,472
5,075,334
4,840,600
0
2550 2560 2500
2,761,327
416,735
2,761,327
416,735
2900 2000
804,470 0 804,470
976,809
1,068,001
976,809
1,068,001
5,996 816 6,812
3000
159,211
0
159,211
0
0 6,192,549 816 6,193,365 0
0 0
4120 4140 4190
Payments to Other Govt. Units (Out of State)
4400 4000
0
0
0
0
0 0 0 0
5000
DEBT SERVICES - INTEREST ON SHORT-TERM DEBT Tax Anticipation Warrants
5110
Tax Anticipation Notes
5120
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
5,837,100 3,500 5,840,600
4000
4100
Total Payments to Other Govt Units
0
2510
Total Payments to Other Govt. Units (In-State)
DEBT SERVICES (O&M)
0
0 0
0 0
STATEMENT OF EXPENDITURES DISBURSED/EXPENDITURES, BUDGET TO ACTUAL FOR THE YEAR ENDING JUNE 30, 2016
Page 18
A 1 2 143 144 145 146 147 148
B
Description (Enter Whole Dollars)
Funct #
Corporate Personal Prop. Repl. Tax Anticipation Notes
5130
State Aid Anticipation Certificates
5140
Other Interest on Short-Term Debt (Describe & Itemize)
5150
Total Debt Service - Interest on Short-Term Debt
5100
DEBT SERVICE - INTERST ON LONG-TERM DEBT
5200
Total Debt Services
153
4000
155 DEBT SERVICES (DS) 156 DEBT SERVICES - INTEREST ON SHORT-TERM DEBT Tax Anticipation Warrants 157 Tax Anticipation Notes 158 Corporate Personal Prop. Repl. Tax Anticipation Notes 159 State Aid Anticipation Certificates 160 Other Interest on Short-Term Debt (Describe & Itemize) 161 Total Debt Services - Interest On Short-Term Debt 162 163 DEBT SERVICES - INTEREST ON LONG-TERM DEBT
5000
DEBT SERVICES - PAYMENTS OF PRINCIPAL ON LONG-TERM DEBT (Lease/Purchase Principal Retired)
171
DEBT SERVICES - OTHER (Describe & Itemize) Total Debt Services
G
H
I
J
K
(500)
(600)
(700)
(800)
(900)
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other Objects
Non-Capitalized Equipment
Termination Benefits
Total
0 416,735
804,470
976,809
1,068,001
6,812
Budget 0 0 0 0 0 0
0
2,761,327
L
159,211
0
6,193,365 (1,415,874)
0 0 5,840,600
0
5100
0
0 0 0 0 0 0
5200 5300
283,200
283,200
435,410
4,350,000
4,200,000 4,635,410 4,635,410
5110 5120 5130 5140 5150
5400 5000
3,500 3,500
4,633,200
4,350,000 3,500 4,636,700
3,500
4,633,200
4,636,700
0
6000
35,853
40 - TRANSPORTATION FUND (TR)
COMMUNITY SERVICES (TR)
180 PAYMENTS TO OTHER DIST & GOVT UNITS (TR) 181 PAYMENTS TO OTHER GOVT UNITS (IN-STATE) Payments for Regular Programs 182 Payments for Special Education Programs 183 Payments for Adult/Continuing Education Programs 184 Payments for CTE Programs 185 Payments for Community College Programs 186 187 188
F (400)
Excess (Deficiency) of Receipts/Revenues Over Disbursements/Expenditures
172 SUPPORT SERVICES (TR) 173 SUPPORT SERVICES - PUPILS Other Support Services - Pupils (Describe & Itemize) 174 175 SUPPORT SERVICES - BUSINESS Pupil Transportation Services 176 177 Other Support Services (Describe & Itemize) 178 Total Support Services 179
E (300)
11
167 PROVISION FOR CONTINGENCIES (DS) Total Disbursements/ Expenditures 168 169 170
D (200)
30 - DEBT SERVICES (DS)
154 PAYMENTS TO OTHER DIST & GOVT UNITS (DS)
164 165 166
C (100)
5000
6000 149 PROVISIONS FOR CONTINGENCIES (O&M) Total Direct Disbursements/Expenditures 150 Excess (Deficiency) of Receipts/Revenues/Over Disbursements/ 151 152 Expenditures
Page 18
Other Payments to In-State Govt. Units (Describe & Itemize) Total Payments to Other Govt. Units (In-State) Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
0
2190 2550
56,605
2,606
3,847,376
1,750
0
56,605
2,606
3,847,376
1,750
0
2900 2000
0
3000
0
0
3,908,337 0 3,908,337
3,973,125 3,973,125
0
4000
0 0 0 0 0
4110 4120 4130
0
4140 4170 4190 4100
0
0
0 0
0
STATEMENT OF EXPENDITURES DISBURSED/EXPENDITURES, BUDGET TO ACTUAL FOR THE YEAR ENDING JUNE 30, 2016
Page 19
A 1 2 189 190 191 192 193 194 195 196 197 198 199
B
Description (Enter Whole Dollars) PAYMENTS TO OTHER GOVT UNITS (OUT-OF-STATE) Total Payments to Other Govt Units DEBT SERVICES (TR)
207
E
F
G
H
I
J
K
(300)
(400)
(500)
(600)
(700)
(800)
(900)
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other Objects
Non-Capitalized Equipment
Termination Benefits
Total
4400
0
L Budget
0
0 0
0
0
0 0 0 0 0 0
0
DEBT SERVICE - INTEREST ON SHORT-TERM DEBT Tax Anticipation Warrants
5110
Tax Anticipation Notes Corporate Personal Prop. Repl. Tax Anticipation Notes
5120 5130
State Aid Anticipation Certificates
5140
Other Interest on Short-Term Debt (Describe & Itemize)
5150
Total Debt Services - Interest On Short-Term Debt
5100
DEBT SERVICES - INTEREST ON LONG-TERM DEBT DEBT (Lease/Purchase Principal Retired)
5200 5300
0
11
DEBT SERVICES - OTHER (Describe & Itemize) Total Debt Services
5400
0
5000
0 0 0
0
3,908,337
3,973,125
6000
56,605
2,606
Excess (Deficiency) of Receipts/Revenues Over Disbursements/Expenditures
3,847,376
1,750
0
0
0
0
(564,749)
50 - MUNICIPAL RETIREMENT/SOCIAL SECURITY FUND (MR/SS)
208 INSTRUCTION (MR/SS) Regular Programs 209 Pre-K Programs 210 Special Education Programs (Functions 1200-1220) 211 Special Education Programs - Pre-K 212 Remedial and Supplemental Programs - K-12 213 Remedial and Supplemental Programs - Pre-K 214 Adult/Continuing Education Programs 215 CTE Programs 216 Interscholastic Programs 217 Summer School Programs 218 Gifted Programs 219 Driver's Education Programs 220 Bilingual Programs 221 Truants' Alternative & Optional Programs 222 223 Total Instruction 224 225 226 227 228 229 230 231 232 233 234 235 236 237
D (200)
5000
203 PROVISION FOR CONTINGENCIES (TR) Total Disbursements/ Expenditures 204 205 206
C (100)
4000
DEBT SERVICE - PAYMENTS OF PRINCIPAL ON LONG-TERM
200 201 202
Funct #
Page 19
SUPPORT SERVICES (MR/SS)
1000 1100
265,770
39,673 34,718 0 0 2,611 2,534 15,471 547,979
265,770 0 187,202 0 0 0 0 39,673 34,718 0 0 2,611 2,534 15,471 547,979
94,466 73,830 2,212 727 0 14,639 185,874
94,466 73,830 2,212 727 0 14,639 185,874
18,050 140,850
6,019 46,006 12,146 64,171
6,019 46,006 12,146 64,171
51,000 1,250 52,250
1125 1200
187,202
1225 1250
0
1275 1300 1400 1500 1600 1650 1700 1800 1900 1000
235,000 225,000
41,500 38,500
2,500 10,000 552,500
2000
SUPPORT SERVICES - PUPILS Attendance & Social Work Services
2110
Guidance Services
2120
Health Services
2130
Psychological Services
2140
Speech Pathology & Audiology Services
2150
Other Support Services - Pupils (Describe & Itemize)
2190
Total Support Services - Pupils
2100
63,500 47,500 11,800
SUPPORT SERVICES - INSTRUCTIONAL STAFF Improvement of Instruction Services
2210
Educational Media Services
2220
Assessment & Testing
2230
Total Support Services - Instructional Staff
2200
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
STATEMENT OF EXPENDITURES DISBURSED/EXPENDITURES, BUDGET TO ACTUAL FOR THE YEAR ENDING JUNE 30, 2016
Page 20
A 1 2 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273
Description (Enter Whole Dollars)
B Funct #
Page 20
C
D
E
F
G
H
I
J
K
(100)
(200)
(300)
(400)
(500)
(600)
(700)
(800)
(900)
L
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other Objects
Non-Capitalized Equipment
Termination Benefits
Total
Budget
SUPPORT SERVICES - GENERAL ADMINISTRATION Board of Education Services
2310
Executive Administration Services
2320
Service Area Administrative Services
2330
Claims Paid from Self Insurance Fund
2361 2362
Workers' Compensation or Workers' Occupation Disease Acts Payments Unemployment Insurance Payments
1,921 31,116 34,694
2364
Risk Management and Claims Services Payments
2365
Judgment and Settlements Educational, Inspectional, Supervisory Services Related to Loss Prevention or Reduction Reciprocal Insurance Payments
2366 2367
34,000 32,900
0 0 0 0 0
2363
Insurance Payments (Regular or Self-Insurance)
1,921 31,116 34,694 0
Legal Services
2369
Total Support Services - General Administration
2300
67,731
0 0 0 67,731
Office of the Principal Services Other Support Services - School Administration (Describe & Itemize)
2410 2490
90,349
90,349
97,000
Total Support Services - School Administration
2400
16,607 106,956
16,607 106,956
87,000 184,000
1,719 47,725
1,719 47,725 0 482,831 10,426 101,545 0 644,246
7,200 54,000
2368
66,900
SUPPORT SERVICES - SCHOOL ADMINISTRATION
SUPPORT SERVICES - BUSINESS Direction of Business Support Services
2510
Fiscal Services
2520
Facilities Acquisition & Construction Services
2530
Operation & Maintenance of Plant Services
2540
Pupil Transportation Services
2550
Food Services
2560
Internal Services
2570
Total Support Services - Business
2500
482,831 10,426 101,545 0 644,246
479,500 13,400 116,000 22,500 692,600
SUPPORT SERVICES - CENTRAL Direction of Central Support Services Planning, Research, Development, & Evaluation Services
2600
6,249 42,797 49,046
0 0 6,249 42,797 49,046
23,200 23,200
2900 2000
1,118,024
0 1,118,024
1,159,800
3000
3,079
3,079
0
0 0 0
Information Services Staff Services
2630 2640
Data Processing Services
2660
Total Support Services - Central Other Support Services (Describe & Itemize) Total Support Services
274 COMMUNITY SERVICES (MR/SS) 275 PAYMENTS TO OTHER DIST & GOVT UNITS (MR/SS) Payments for Special Education Programs 276 Payments for CTE Programs 277 278 Total Payments to Other Govt Units 279 DEBT SERVICES (MR/SS) 280 DEBT SERVICE - INTEREST ON SHORT-TERM DEBT Tax Anticipation Warrants 281 Tax Anticipation Notes 282 Corporate Personal Prop. Repl. Tax Anticipation Notes 283
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
0
2610 2620
4000 4120 4140 4000 5000 5110 5120 5130
0 0 0
0
STATEMENT OF EXPENDITURES DISBURSED/EXPENDITURES, BUDGET TO ACTUAL FOR THE YEAR ENDING JUNE 30, 2016
Page 21
A 1 2 284 285 286 287 288 289 290
Description (Enter Whole Dollars)
297 298 299 300 301 302 303
5140
Other (Describe & Itemize)
5150
Total Debt Services - Interest
5000
PROVISION FOR CONTINGENCIES (MR/SS)
313 314 315 316 317 318 319 320 321 322 323 324 325 326 327
D
E
F
G
H
I
J
K
(200)
(300)
(400)
(500)
(600)
(700)
(800)
(900)
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other Objects
Non-Capitalized Equipment
Termination Benefits
Total
L Budget
0
0 0 0
0
0
1,669,082
1,712,300
6000
1,669,082
Total Disbursements/Expenditures
695,853
60 - CAPITAL PROJECTS (CP) SUPPORT SERVICES (CP)
2000
SUPPORT SERVICES - BUSINESS Facilities Acquisition and Construction Services
2530
Other Support Services (Describe & Itemize)
2900
Total Support Services
2000
PAYMENTS TO OTHER DIST & GOVT UNITS (CP)
0
0
0
0
0
0
0
0
0 0 0
0
0 0 0 0 0
0
0
0
4000
PAYMENTS TO OTHER GOVT UNITS (In-State) Payments to Other Govt Units (In-State)
4100
Payments for Special Education Programs
4120
Payments for CTE Programs Other Payments to In-State Govt. Units (Describe & Itemize)
4140 4190
Total Payments to Other Govt Units
0
4000
0
6000
0
0
0
0
0
0
0
0
Excess (Deficiency) of Receipts/Revenues Over Disbursements/Expenditures
385
70 - WORKING CASH (WC)
308 309 310 311 312
C (100)
Excess (Deficiency) of Receipts/Revenues Over Disbursements/Expenditures
304 PROVISION FOR CONTINGENCIES (S&C/CI) Total Disbursements/ Expenditures 305 306 307
Funct #
State Aid Anticipation Certificates
291 292 293 294 295 296
B
Page 21
80 - TORT FUND (TF) SUPPORT SERVICES - GENERAL ADMINISTRATION Claims Paid from Self Insurance Fund Workers' Compensation or Workers' Occupation Disease Acts Payments Unemployment Insurance Payments
2364
Risk Management and Claims Services Payments
2365
Judgment and Settlements Educational, Inspectional, Supervisory Services Related to Loss Prevention or Reduction Reciprocal Insurance Payments
2366 2367
Legal Services
2369
2368
Property Insurance (Buildings & Grounds)
2371
Vehicle Insurance (Transporation)
2372
Total Support Services - General Administration
0 0 0 0 0
0
2363
Insurance Payments (Regular or Self-Insurance)
DEBT SERVICES (TF)
0
2361 2362
2000
0
0
0
0
0
0
0
0
0 0 0 0 0 0
5000
DEBT SERVICES - INTEREST ON SHORT-TERM DEBT Tax Anticipation Warrants
5110
Corporate Personal Prop. Repl. Tax Anticipation Notes
5130
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
0 0
0
STATEMENT OF EXPENDITURES DISBURSED/EXPENDITURES, BUDGET TO ACTUAL FOR THE YEAR ENDING JUNE 30, 2016
Page 22
A 1
B
Description
Funct #
(Enter Whole Dollars)
2 328
Other Interest or Short-Term Debt
5150
329
Total Debt Services - Interest on Short-Term Debt
5000
330 331 332 333 334
PROVISIONS FOR CONTINGENCIES (TF)
343 344
E
F
G
H
I
J
K
(300)
(400)
(500)
(600)
(700)
(800)
(900)
L
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other Objects
Non-Capitalized Equipment
Termination Benefits
Total
Budget 0
0
0
0
0
0
0
0
0
0
0
0 1,771
0
90 - FIRE PREVENTION & SAFETY FUND (FP&S) 2000
2500 2000
Total Payments to Other Govt Units
4000
Excess (Deficiency) of Receipts/Revenues Over Disbursements/Expenditures
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0 0 0 0
0 0
4000 4190
Total Debt Service
0
2900
Other Payments to In-State Govt. Units (Describe & Itemize)
Debt Service - Payments of Principal on Long-Term Debt (Lease/Purchase Principal Retired)
0
2530 2540
PAYMENTS TO OTHER DIST & GOVT UNITS (FP&S)
353 PROVISION FOR CONTINGENCIES (FP&S) Total Disbursements/Expenditures 354 355
D (200)
0
Total Disbursements/Expenditures Excess (Deficiency) of Receipts/Revenues Over Disbursements/Expenditures
345 DEBT SERVICES (FP&S) 346 DEBT SERVICES- INTEREST ON SHORT-TERM DEBT Tax Anticipation Warrants 347 Other Interest on Short-Term Debt (Describe & Itemize) 348 349 Total Debt Service - Interest on Short-Term Debt 350 DEBT SERVICES - INTEREST ON LONG-TERM DEBT 351 352
C (100)
6000
335 SUPPORT SERVICES (FP&S) 336 SUPPORT SERVICES - BUSINESS Facilities Acquisition & Construction Services 337 Operation & Maintenance of Plant Services 338 339 Total Support Services - Business Other Support Services (Describe & Itemize) 340 341 Total Support Services 342
Page 22
0
0 0
0
0
0 0 0
0
5000 5110 5150 5100 15
5200 5300
0
0
5000
0 0
0
0
0
6000
0
0
0
0
0
0
0
0
1,606
Page 23
Page 23
FEDERAL STIMULUS - AMERICAN RECOVERY AND REINVESTMENT ACT (ARRA) of 2009
(Detailed Schedule of Receipts and Disbursements) A 1 2
B
ARRA Revenue Source Code
3 4 Beginning Balance July 1, 2015 ARRA - General State Aid 5 ARRA - Title I Low Income 6 ARRA - Title I Neglected - Private 7 ARRA - Title I Delinquent - Private 8 ARRA - Title I School Improvement (Part A) 9 10 ARRA - Title I School Improvement (Section 1003g) 11 ARRA - IDEA Part B Preschool 12 ARRA - IDEA Part B Flow Through 13 ARRA - Title II D Technology Formula 14 ARRA - Title II D Technology Competitive 15 ARRA - McKenney - Vento Homeless Education 16 ARRA - Child Nutrition Equipment Assistance 17 Impact Aid Construction Formula 18 Impact Aid Construction Competitive 19 QZAB Tax Credits 20 QSCB Tax Credits 21 Build America Bonds Tax Credits 22 Build America Bonds Interest Reimbursement 23 ARRA - General State Aid - Other Govt Services Stabilization 24 ARRA - Other II 25 ARRA - Other III 26 ARRA - Other IV 27 ARRA - Other V 28 ARRA - Early Childhood 29 ARRA - Other VII 30 ARRA - Other VIII 31 ARRA - Other IX 32 ARRA - Other X 33 ARRA - Other XI Total ARRA Programs 34 Ending Balance June 30, 2016 35 36 37 1. 38 39 40 41 42 43 44 45 46 2. 47 48 49 50 51 52 53 54 55 56 Print Date: afr-16-form 206 v1.xlsm 1/10/2017
C
D
----RECEIPTS----
District's Accounting Basis is CASH Acct #
4850 4851 4852 4853 4854 4855 4856 4857 4860 4861 4862 4863 4864 4865 4866 4867 4868 4869 4870 4871 4872 4873 4874 4875 4876 4877 4878 4879 4880
ARRA Receipts
1,200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E
F
G
H
I
J
K
L
-------------------------------------------------------------------------------------------DISBURSEMENTS-----------------------------------------------------------------------------------(100)
(200)
(300)
(400)
(500)
(600)
(700)
(800)
(900)
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other
Non-Capitalized Equipment
Termination Benefits
Total Expenditures
0
0
0
0
0
0
1,200 Were any funds from the State Fiscal Stabilization Fund Program (SFSF) General State-Aid Accounts 4850, line 5 & 4870, line 23 used for the following non-allowable purposes: Payments of maintenance costs; Stadiums or other facilities used for athletic contests, exhibitions or other events for which admission is charged to the general public; Purchase or upgrade of vehicles; Improvements of stand-alone facilities whose purpose is not the education of children such as central office administrative buildings; Financial assistance to students to attend private elementary or secondary schools unless the funds are used to provide special education and related services to children with disabilities as authorized by the IDEA Act; School modernization, renovation, or repair that is inconsistent with State Law. If any above boxes are checked provide the total amount of questioned costs and provide an explanation below:
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Page 24
Page 24
A 1
C
D
E
F
Taxes Received 7-1-15 Thru 6-30-16 (from 2014 Levy & Prior Levies) *
Taxes Received (from the 2015 Levy)
Taxes Received (from 2014 & Prior Levies)
Total Estimated Taxes (from the 2015 Levy)
Estimated Taxes Due (from the 2015 Levy)
SCHEDULE OF AD VALOREM TAX RECEIPTS
Description
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
B
(Enter Whole Dollars)
(Column B - C) Educational Operations & Maintenance Debt Services ** Transportation Municipal Retirement Capital Improvements Working Cash Tort Immunity Fire Prevention & Safety Leasing Levy Special Education Area Vocational Construction Social Security/Medicare Only Summer School Other (Describe & Itemize) Totals
16,072,665 2,733,085 4,672,545 1,501,006 928,568 0 131,524 1,040 1,040 1,104 1,040 0 950,815 0 0 26,994,432
7,900,382 1,223,960 2,256,280 835,627 407,483 0 131,083 600 600 596 600 0 406,192 0 0 13,163,403
* The formulas in column B are unprotected to be overidden when reporting on a ACCRUAL basis. ** All tax receipts for debt service payments on bonds must be recorded on line 6 (Debt Services).
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
8,172,283 1,509,125 2,416,265 665,379 521,085 0 441 440 440 508 440 0 544,623 0 0 13,831,029
(Column E - C)
19,780,907 3,098,813 5,607,194 2,065,875 1,032,938 0 309,806 1,355 1,355 1,355 1,355 0 1,032,938 0 0 32,933,893
11,880,525 1,874,853 3,350,914 1,230,248 625,455 0 178,723 755 755 759 755 0 626,746 0 0 19,770,490
Page 25
A
B
D
E
F
Outstanding Beginning 07/01/15
Issued 07/01/15 Through 06/30/16
Retired 07/01/15 Through 06/30/16
Outstanding Ending 06/30/16
Description (Enter Whole Dollars)
2
CORPORATE PERSONAL PROPERTY REPLACEMENT TAX ANTICIPATION NOTES (CPPRT) Total CPPRT Notes
I
J
Any differences described and itemized
Retired 7/1/15 thru 6/30/16
Outstanding Ending 6/30/16
Amount to be Provided for Payment on LongTerm Debt
0
0
0 0 0 0 0 0 0 0 0 0
0
0 0 0 0 0
Educational Fund Operations & Maintenance Fund Debt Services - Construction Debt Services - Working Cash Debt Services - Refunding Bonds Transportation Fund Municipal Retirement/Social Security Fund Fire Prevention & Safety Fund Other - (Describe & Itemize)
0
Total TAWs
0
TAX ANTICIPATION NOTES (TAN) Educational Fund Operations & Maintenance Fund Fire Prevention & Safety Fund Other - (Describe & Itemize)
0
Total TANs
0
TEACHERS'/EMPLOYEES' ORDERS (T/EO) Total T/EOs (Educational, Operations & Maintenance, &
0 0 0
SCHEDULE OF LONG-TERM DEBT
Identification or Name of Issue
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
H
TAX ANTICIPATION WARRANTS (TAW)
23 Transportation Funds) 24 GENERAL STATE-AID ANTICIPATION CERTIFICATES (GSAAC) Total GSAACs (All Funds) 25 26 OTHER SHORT-TERM BORROWING Total Other Short-Term Borrowing (Describe & Itemize) 27 28 29
G
SCHEDULE OF SHORT-TERM DEBT
1
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
C
Working Cash Working Cash Capital Lease
Date of Issue (mm/dd/yy)
Amount of Original Issue
11/17/09 07/12/11 09/01/06
9,770,000 10,000,000 1,255,010
Type of Issue
*
21,025,010
1 1 7
Outstanding Beginning 07/1/15
Issued 7/1/15 thru 6/30/16
2,655,000 8,075,000 314,044
0 0 0
0 0 0
2,655,000 1,695,000 152,348
11,044,044
0
0
4,502,348
* Each type of debt issued must be identified separately with the amount: 1. Working Cash Fund Bonds 2. Funding Bonds 3. Refunding Bonds
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
4. Fire Prevent, Safety, Environmental and Energy Bonds 5. Tort Judgment Bonds 6. Building Bonds
7. Other Capital Lease 8. Other 9. Other
0 6,380,000 161,696 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6,541,696
0 4,756,181 161,696
4,917,877
Page 25
Schedule of Restricted Local Tax Levies and Selected Revenues Sources Schedule of Tort Immunity Expenditures
Page 26
A 1
B
C
D
E
19 20 21 22 23 24 25 26 27
G
H
I
Special Education
Area Vocational Construction
J
K
SCHEDULE OF RESTRICTED LOCAL TAX LEVIES AND SELECTED REVENUE SOURCES
Description
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
F
Page 26
(Enter Whole Dollars)
Account No
Tort Immunity
a
School Facility Occupation Taxes
Driver Education
b
Cash Basis Fund Balance as of July 1, 2015 RECEIPTS: Ad Valorem Taxes Received by District Earnings on Investments Drivers' Education Fees
30 or 60-1983
Driver Education Other Receipts (Describe & Itemize on tab "Itemization 32")
10 or 20-3370 10, 20, 40 or 60-7200
0
Instruction
10 or 50-1000
Facilities Acquisition & Construction Services
20 or 60-2530
Tort Immunity Services
47,422
--
Total Receipts DISBURSEMENTS:
DEBT SERVICE Debt Services - Interest on Long-Term Debt
65,589
10-1970
School Facility Occupation Tax Proceeds
Sale of Bonds
1,040
10, 20, 40 or 50-1100 10, 20, 40, 50 or 60-1500
1,040
0
1,040
113,011
30-5200 30-5300
Debt Services Other (Describe & Itemize on tab "Itemization 32")
30-5400
0
Total Debt Services --
Total Disbursements Ending Cash Basis Fund Balance as of June 30, 2016 Reserved Fund Balance Unreserved Fund Balance
113,011
10, 20, 40-2360-2370
Debt Services - Payments of Principal on Long-Term Debt (Lease/Purchase Principal Retired)
Other Disbursements (Describe & Itemize on tab "Itemization 32")
0
714 730
0 0
1,040 0
0 0
0 0
113,011 0
0
0
0
0
0
SCHEDULE OF TORT IMMUNITY EXPENDITURES a
28 29 Has the entity established an insurance reserve pursuant to 745 ILCS 10/9-103? 30 Yes No Total Claims Payments: 31 If yes, list in the aggregate the following: Total Reserve Remaining: 32 33 Using the following categories, list all other Tort Immunity expenditures not 34 included in line 30 above. Include the total dollar amount for each category. 35 Expenditures: 36 Workers' Compensation Act and/or Workers' Occupational Disease Act 37 Unemployment Insurance Act 38 Insurance (Regular or Self-Insurance) 39 Risk Management and Claims Service 40 Judgments/Settlements 41 42 43 44 45
Educational, Inspectional, Supervisory Services Related to Loss Prevention and/or Reduction
46 47 48
a
Reciprocal Insurance Payments (Insurance Code 72, 76, and 81) Legal Services Principal and Interest on Tort Bonds
b
Schedules for Tort Immunity are to be completed only if expenditures have been reported in any fund other than the Tort Immunity Fund (80) during the fiscal year as a result of existing (restricted) fund balances in those other funds that are being spent down. Cell G6 above should include interest earnings only from these restricted tort immunity monies and only if reported in a fund other than Tort Immunity Fund (80).
55 ILCS 5/5-1006.7 Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
Page 27
Page 27
A 1
B
C
D
E
F
G
H
I
J
K
Add: Additions 2015-2016
Less: Deletions 2015-2016
Cost Ending 6/30/16
Life In Years
Accumulated Depreciation Beginning 7/1/15
Add: Depreciation Allowable 2015-2016
Less: Depreciation Deletions 2015-2016
L
Schedule of Capital Outlay and Depreciation Description of Assets (Enter Whole Dollars)
2 3 Works of Art & Historical Treasures
Acct #
220
7 Buildings 8 Permanent Buildings Temporary Buildings 9
230
Improvements Other than Buildings
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
0
210
4 Land 5 Non-Depreciable Land Depreciable Land 6
10 (Infrastructure) 11 Capitalized Equipment 10 Yr Schedule 12 5 Yr Schedule 13 3 Yr Schedule 14 15 Construction in Progress Total Capital Assets 16 17 Non-Capitalized Equipment 18 Allowable Depreciation
Cost Beginning 7/1/15
221
330,172
222 231
36,899,747
232 240
330,172 0
50
36,899,747 0
20
50
20
20,064,896
731,950
1,267,650
185,263
Accumulated Ending Balance Depreciation Undepreciated Ending 6/30/16 6/30/16 0 0
0
330,172 0
20,796,846 0
16,102,901 0
1,452,913
2,851,102
3,236,015
1,068,000
4,304,015
8,068,137 853,738
39,805 7,020
8,107,942 860,758
10
252
5
7,703,953 801,555
323,963 13,702
8,027,916 815,257
80,026 45,501
253
260,352
102,899
363,251
3
43,392
103,934
147,326
215,925
0
--
29,881,446
1,358,812
31,240,258
19,625,627
250 251
260 200 700
49,648,161
1,217,724
0
50,865,885 380,343
10
0 38,034 1,396,846
0
Page 28
Page 28
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79
B
C
D
E
F
G
ESTIMATED OPERATING EXPENSE PER PUPIL (OEPP)/PER CAPITA TUITION CHARGE (PCTC) COMPUTATIONS (2015-2016) This schedule is completed for school districts only. Fund
Sheet, Row
ACCOUNT NO - TITLE
Amount
OPERATING EXPENSE PER PUPIL EXPENDITURES: ED O&M DS TR MR/SS TORT
Expenditures 15-22, L114 Expenditures 15-22, L150 Expenditures 15-22, L168 Expenditures 15-22, L204 Expenditures 15-22, L288 Expenditures 15-22, L331
Total Expenditures Total Expenditures Total Expenditures Total Expenditures Total Expenditures Total Expenditures
$
Total Expenditures
$
41,434,242 6,193,365 4,636,700 3,908,337 1,669,082 0 57,841,726
LESS RECEIPTS/REVENUES OR DISBURSEMENTS/EXPENDITURES NOT APPLICABLE TO THE REGULAR K-12 PROGRAM: TR TR TR TR TR TR TR TR TR TR TR O&M O&M-TR O&M-TR O&M-TR O&M ED ED ED ED ED ED ED ED ED ED ED ED ED ED ED ED ED ED ED ED ED ED O&M O&M O&M O&M DS DS TR TR TR TR TR MR/SS MR/SS MR/SS MR/SS MR/SS MR/SS MR/SS
Revenues 9-14, L43, Col F Revenues 9-14, L47, Col F Revenues 9-14, L48, Col F Revenues 9-14, L49, Col F Revenues 9-14, L50 Col F Revenues 9-14, L52, Col F Revenues 9-14, L56, Col F Revenues 9-14, L59, Col F Revenues 9-14, L60, Col F Revenues 9-14, L61, Col F Revenues 9-14, L62, Col F Revenues 9-14, L148, Col D Revenues 9-14, L149, Col D & F Revenues 9-14, L218, Col D,F Revenues 9-14, L219, Col D,F Revenues 9-14, L229, Col D Expenditures 15-22, L7, Col K - (G+I) Expenditures 15-22, L9, Col K - (G+I) Expenditures 15-22, L11, Col K - (G+I) Expenditures 15-22, L12, Col K - (G+I) Expenditures 15-22, L15, Col K - (G+I) Expenditures 15-22, L20, Col K Expenditures 15-22, L21, Col K Expenditures 15-22, L22, Col K Expenditures 15-22, L23, Col K Expenditures 15-22, L24, Col K Expenditures 15-22, L25, Col K Expenditures 15-22, L26, Col K Expenditures 15-22, L27, Col K Expenditures 15-22, L28, Col K Expenditures 15-22, L29, Col K Expenditures 15-22, L30, Col K Expenditures 15-22, L31, Col K Expenditures 15-22, L32, Col K Expenditures 15-22, L75, Col K - (G+I) Expenditures 15-22, L102, Col K Expenditures 15-22, L114, Col G Expenditures 15-22, L114, Col I Expenditures 15-22, L130, Col K - (G+I) Expenditures 15-22, L138, Col K Expenditures 15-22, L150, Col G Expenditures 15-22, L150, Col I Expenditures 15-22, L154, Col K Expenditures 15-22, L164, Col K Expenditures 15-22, L179, Col K - (G+I) Expenditures 15-22, L190, Col K Expenditures 15-22, L200, Col K Expenditures 15-22, L204, Col G Expenditures 15-22, L204, Col I Expenditures 15-22, L210, Col K Expenditures 15-22, L212, Col K Expenditures 15-22, L214, Col K Expenditures 15-22, L215, Col K Expenditures 15-22, L218, Col K Expenditures 15-22, L274, Col K Expenditures 15-22, L278, Col K
1412 1421 1422 1423 1424 1432 1442 1451 1452 1453 1454 3410 3499 4600 4605 4810 1125 1225 1275 1300 1600 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 3000 4000 3000 4000 4000 5300 3000 4000 5300 1125 1225 1275 1300 1600 3000 4000
Regular - Transp Fees from Other Districts (In State) Summer Sch - Transp. Fees from Pupils or Parents (In State)
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,350 0 0 0 0 0 0 818,998 0 0 0 0 0 0 0 0 0 0 112,674 1,745,673 149,723 221,132 0 0 1,068,001 159,211 0 4,350,000 0 0 0 0 0 0 0 0 0 0 3,079 0
$
8,629,841 49,211,885
Summer Sch - Transp. Fees from Other Districts (In State) Summer Sch - Transp. Fees from Other Sources (In State) Summer Sch - Transp. Fees from Other Sources (Out of State) CTE - Transp Fees from Other Districts (In State) Special Ed - Transp Fees from Other Districts (In State) Adult - Transp Fees from Pupils or Parents (In State) Adult - Transp Fees from Other Districts (In State) Adult - Transp Fees from Other Sources (In State) Adult - Transp Fees from Other Sources (Out of State) Adult Ed (from ICCB) Adult Ed - Other (Describe & Itemize) Fed - Spec Education - Preschool Flow-Through Fed - Spec Education - Preschool Discretionary Federal - Adult Education Pre-K Programs Special Education Programs Pre-K Remedial and Supplemental Programs Pre-K Adult/Continuing Education Programs Summer School Programs Pre-K Programs - Private Tuition Regular K-12 Programs - Private Tuition Special Education Programs K-12 - Private Tuition Special Education Programs Pre-K - Tuition Remedial/Supplemental Programs K-12 - Private Tuition Remedial/Supplemental Programs Pre-K - Private Tuition Adult/Continuing Education Programs - Private Tuition CTE Programs - Private Tuition Interscholastic Programs - Private Tuition Summer School Programs - Private Tuition Gifted Programs - Private Tuition Bilingual Programs - Private Tuition Truants Alternative/Optional Ed Progms - Private Tuition Community Services Total Payments to Other Govt Units Capital Outlay Non-Capitalized Equipment Community Services Total Payments to Other Govt Units Capital Outlay Non-Capitalized Equipment Payments to Other Dist & Govt Units Debt Service - Payments of Principal on Long-Term Debt Community Services Total Payments to Other Govt Units Debt Service - Payments of Principal on Long-Term Debt Capital Outlay Non-Capitalized Equipment Pre-K Programs Special Education Programs - Pre-K Remedial and Supplemental Programs - Pre-K Adult/Continuing Education Programs Summer School Programs Community Services Total Payments to Other Govt Units
Total Deductions for OEPP Computation (Sum of Lines 18 - 73) Total Operating Expenses Regular K-12 (Line 14 minus Line 75) 9 Mo ADA from the General State Aid Claimable for 2015-2016 and Payable in 2016-2017 (ISBE 54-33), L12 Estimated OEPP (Line 76 divided by Line 77)
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
$
$
2,748.27 17,906.50
Page 29
Page 29
A 1 2 3 4 5 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182
B
C
D
E
F
G
ESTIMATED OPERATING EXPENSE PER PUPIL (OEPP)/PER CAPITA TUITION CHARGE (PCTC) COMPUTATIONS (2015-2016) This schedule is completed for school districts only. Fund
Sheet, Row
ACCOUNT NO - TITLE
Amount
PER CAPITA TUITION CHARGE
LESS OFFSETTING RECEIPTS/REVENUES: TR Revenues 9-14, L42, Col F TR Revenues 9-14, L44, Col F TR Revenues 9-14, L45, Col F TR Revenues 9-14, L46, Col F TR Revenues 9-14, L51, Col F TR Revenues 9-14, L53, Col F TR Revenues 9-14, L54, Col F TR Revenues 9-14, L55, Col F TR Revenues 9-14, L57, Col F TR Revenues 9-14, L58, Col F ED Revenues 9-14, L75, Col C ED-O&M Revenues 9-14, L82, Col C,D ED Revenues 9-14, L84, Col C ED Revenues 9-14, L87, Col C ED Revenues 9-14, L88, Col C ED Revenues 9-14, L91, Col C ED Revenues 9-14, L92, Col C ED-O&M Revenues 9-14, L95, Col C,D ED-O&M-TR Revenues 9-14, L98, Col C,D,F ED-O&M-DS-TR-MR/SS Revenues 9-14, L104, Col C,D,E,F,G ED Revenues 9-14, L106, Col C ED-O&M-TR Revenues 9-14, L131, Col C,D,F ED-O&M-MR/SS Revenues 9-14, L140, Col C,D,G ED-MR/SS Revenues 9-14, L144, Col C,G ED Revenues 9-14, L145, Col C ED-O&M-MR/SS Revenues 9-14, L146, Col C,D,G ED-O&M Revenues 9-14, L147,Col C,D ED-O&M-TR-MR/SS Revenues 9-14, L154, Col C,D,F,G ED Revenues 9-14, L155, Col C ED-O&M-TR-MR/SS Revenues 9-14, L156, Col C,D,F,G ED-TR-MR/SS Revenues 9-14, L157, Col C,F,G ED-TR-MR/SS Revenues 9-14, L159, Col C,F,G ED-TR-MR/SS Revenues 9-14, L160, Col C,F,G ED-TR-MR/SS Revenues 9-14, L161, Col C,F,G ED-TR-MR/SS Revenues 9-14, L162, Col C,F,G ED-O&M-TR-MR/SS Revenues 9-14, L163, Col C,D,F,G ED-O&M-TR-MR/SS Revenues 9-14, L164, Col C,D,F,G ED-O&M-DS-TR-MR/SS Revenues 9-14, L165, Col C,D,E,F,G ED-O&M-DS-TR-MR/SS Revenues 9-14, L166, Col C,D,E,F,G ED-TR Revenues 9-14, L167, Col C,F O&M Revenues 9-14, L170, Col D ED-O&M-DS-TR-MR/SS-Tort Revenues 9-14, L171, Col C-G,J ED Revenues 9-14, L180, Col C ED-O&M-TR-MR/SS Revenues 9-14, L184, Col C,D,F,G ED-O&M-TR-MR/SS Revenues 9-14, L191, Col C,D,F,G ED-MR/SS Revenues 9-14, L201, Col C,G ED-O&M-TR-MR/SS Revenues 9-14, L211, Col C,D,F,G ED-O&M-TR-MR/SS Revenues 9-14, L216, Col C,D,F,G ED-O&M-TR-MR/SS Revenues 9-14, L220, Col C,D,F,G ED-O&M-TR-MR/SS Revenues 9-14, L221, Col C,D,F,G ED-O&M-TR-MR/SS Revenues 9-14, L222, Col C,D,F,G ED-O&M-TR-MR/SS Revenues 9-14, L223, Col C,D,F,G ED-O&M-MR/SS Revenues 9-14, L228, Col C,D,G ED-O&M-DS-TR-MR/SS-Tort Revenue Adjustments (C231 thru J258) ED Revenues 9-14, L260, Col C ED-O&M-DS-TR-MR/SS-Tort Revenues 9-14, L261, Col C-G,J ED,O&M,MR/SS Revenues 9-14, L262, Col C,D,G ED-TR-MR/SS Revenues 9-14, L263, Col C,F,G ED-TR-MR/SS Revenues 9-14, L264, Col C,F,G ED-TR-MR/SS Revenues 9-14, L265, Col C,F,G ED-O&M-TR-MR/SS Revenues 9-14, L266, Col C,D,F,G ED-O&M-TR-MR/SS Revenues 9-14, L267, Col C,D,F,G ED-O&M-TR-MR/SS Revenues 9-14, L268, Col C,D,F,G ED-O&M-TR-MR/SS Revenues 9-14, L269, Col C,D,F,G ED-O&M-TR-MR/SS Revenues 9-14, L270, Col C,D,F,G ED-O&M-TR-MR/SS Revenues 9-14, L271, Col C,D,F,G ED-O&M-TR-MR/SS Revenues 9-14, L272, Col C,D,F,G
1411 1413 1415 1416 1431 1433 1434 1441 1443 1444 1600 1700 1811 1819 1821 1829 1890 1910 1940 1991 1993 3100 3200 3300 3360 3365 3370 3500 3610 3660 3695 3715 3720 3725 3726 3766 3767 3775 3780 3815 3925 3999 4045 4620 4625 4630 4699 4700 4800 4901 4902 4904 4905 4909 4910 4920 4930 4932 4960 4991 4992 4999
$
0 0 0 0 0 0 0 0 0 0 160,170 20,008 180,743 0 0 18,266 0 0 0 0 0 1,250,274 92,988 1,303 10,098 0 47,422 1,842,582 0 0 74,706 0 0 0 0 0 0 0 0 0 0 193,406 0 389,901 0 1,271,549 4,896,187 0 649,491 0 0 0 267,921 0 0 0 0 0 11,864 0 0 0 283,826 0 71,700 544,137 163,256
Total Deductions for PCTC Computation Line 83 through Line 173 $ Net Operating Expense for Tuition Computation (Line 76 minus Line 175) Total Depreciation Allowance (from page 27, Col I) Total Allowance for PCTC Computation (Line 176 minus Line 177) 9 Month ADA (from the GSA Claimable for 2015-2016 Payable in 2016-2017 (ISBE form 54-33, Line 12)) Total Estimated PCTC (Line 178 divided by Line 179) * $
12,441,798 36,770,087 1,396,846 38,166,933 2,748.27 13,887.62
Regular -Transp Fees from Pupils or Parents (In State) Regular - Transp Fees from Other Sources (In State) Regular - Transp Fees from Co-curricular Activities (In State) Regular Transp Fees from Other Sources (Out of State) CTE - Transp Fees from Pupils or Parents (In State) CTE - Transp Fees from Other Sources (In State) CTE - Transp Fees from Other Sources (Out of State) Special Ed - Transp Fees from Pupils or Parents (In State) Special Ed - Transp Fees from Other Sources (In State) Special Ed - Transp Fees from Other Sources (Out of State) Total Food Service Total District/School Activity Income Rentals - Regular Textbooks Rentals - Other (Describe & Itemize) Sales - Regular Textbooks Sales - Other (Describe & Itemize) Other (Describe & Itemize) Rentals Services Provided Other Districts Payment from Other Districts Other Local Fees (Describe & Itemize) Total Special Education Total Career and Technical Education Total Bilingual Ed State Free Lunch & Breakfast School Breakfast Initiative Driver Education Total Transportation Learning Improvement - Change Grants Scientific Literacy Truant Alternative/Optional Education Reading Improvement Block Grant Reading Improvement Block Grant - Reading Recovery Continued Reading Improvement Block Grant Continued Reading Improvement Block Grant (2% Set Aside) Chicago General Education Block Grant Chicago Educational Services Block Grant School Safety & Educational Improvement Block Grant Technology - Technology for Success State Charter Schools School Infrastructure - Maintenance Projects Other Restricted Revenue from State Sources Head Start (Subtract) Total Restricted Grants-In-Aid Received Directly from Federal Govt Total Title V Total Food Service Total Title I Total Title IV Fed - Spec Education - IDEA - Flow Through Fed - Spec Education - IDEA - Room & Board Fed - Spec Education - IDEA - Discretionary Fed - Spec Education - IDEA - Other (Describe & Itemize) Total CTE - Perkins Total ARRA Program Adjustments Race to the Top Race to the Top-Preschool Expansion Grant Advanced Placement Fee/International Baccalaureate Title III - Immigrant Education Program (IEP) Title III - Language Inst Program - Limited Eng (LIPLEP) Learn & Serve America McKinney Education for Homeless Children Title II - Eisenhower Professional Development Formula Title II - Teacher Quality Federal Charter Schools Medicaid Matching Funds - Administrative Outreach Medicaid Matching Funds - Fee-for-Service Program Other Restricted Revenue from Federal Sources (Describe & Itemize)
* The total OEPP/PCTC may change based on the data provided. The final amounts will be calculated by ISBE
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
Page 30
Page 30
ESTIMATED INDIRECT COST DATA
A
B
C
D
E
F
G
ESTIMATED INDIRECT COST RATE DATA 1 2 SECTION I 3 Financial Data To Assist Indirect Cost Rate Determination 4 (Source document for the computation of the Indirect Cost Rate is found in the "Expenditures 15-22" tab.) CODE
5
ALL OBJECTS EXCLUDE CAPITAL OUTLAY. With the exception of line 11, enter the disbursements/expenditures included within the following functions charged directly to and reimbursed from federal grant programs. Also, include all amounts paid to or for other employees within each function that work with specific federal grant programs in the same capacity as those charged to and reimbursed from the same federal grant programs. For example, if a district received funding for a Title I clerk, all other salaries for Title I clerks performing like duties in that function must be included. Include any benefits and/or purchased services paid on or to persons whose salaries are classified as direct costs in the function listed.
6 Support Services - Direct Costs (1-2000) and (5-2000) Direction of Business Support Services (1-2510) and (5-2510) 7 Fiscal Services (1-2520) and (5-2520) 8 Operation and Maintenance of Plant Services (1, 2, and 5-2540) 9 10 Food Services (1-2560) Must be less than (P16, Col E-F, L62) 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
7,726 1,176,354
Value of Commodities Received for Fiscal Year 2016 (Include the value of commodities when determining if a Single Audit is required) . Internal Services (1-2570) and (5-2570) Staff Services (1-2640) and (5-2640) Data Processing Services (1-2660) and (5-2660)
95,195 220,108 24,071
SECTION II Estimated Indirect Cost Rate for Federal Programs
Instruction Support Services: Pupil Instructional Staff General Admin. School Admin Business: Direction of Business Spt. Srv. Fiscal Services Oper. & Maint. Plant Services Pupil Transportation Food Services Internal Services Central: Direction of Central Spt. Srv. Plan, Rsrch, Dvlp, Eval. Srv. Information Services Staff Services Data Processing Services Other: Community Services Total
Print Date: 1/10/2017 afr-16-form 206 v1.xlsm
Function 1000
Restricted Program Indirect Costs Direct Costs
2100 2200 2300 2400 2510 2520 2540 2550 2560 2570 2610 2620 2630 2640 2660 2900 3000
147,196 312,249
23,659,861
23,659,861
4,329,724 1,994,316 3,772,863 2,415,237
4,329,724 1,994,316 3,772,863 2,415,237
0 0 5,608,544 3,983,463 578,285 0
160,223
674,492 32,747 0 220,108 24,071 59 115,753 47,409,523
45,385 604,881
1,269,934 Restricted Rate Total Indirect Costs: Total Direct Costs:
=
Unrestricted Program Indirect Costs Direct Costs
1,269,934 47,409,523 2.68%
147,196 312,249 5,600,818
0 0 7,726 3,983,463 578,285 0
160,223
674,492 32,747 0 220,108 24,071 59 115,753 41,808,705
45,385 604,881
6,870,752 Unrestricted Rate Total Indirect costs: Total Direct Costs:
=
6,870,752 41,808,705 16.43%
H
A
B
C
D
E
F
G
REPORT ON SHARED SERVICES OR OUTSOURCING
1 2 3 4
School Code, Section 17-1.1 (Public Act 97-0357 ) Fiscal Year Ending June 30, 2016
5 Complete the following for attempts to improve fiscal efficiency through shared services or outsourcing in the prior, current and next fiscal years. 0 6 0 7 Check if the schedule is not applicable.
8
Prior Fiscal Year
Current Fiscal Year
Next Fiscal Year
Name of the Local Education Agency (LEA) Participating in the Joint Agreement, Cooperative or Shared Service.
9 Indicate with an (X) If Deficit Reduction Plan Is Required in the Budget Barriers to Implementation
Service or Function ( Check all that apply )
10 11 Curriculum Planning 12 Custodial Services 13 Educational Shared Programs 14 Employee Benefits 15 Energy Purchasing 16 Food Services 17 Grant Writing 18 Grounds Maintenance Services 19 Insurance 20 Investment Pools 21 Legal Services 22 Maintenance Services 23 Personnel Recruitment 24 Professional Development 25 Shared Personnel 26 Special Education Cooperatives 27 STEM (science, technology, engineering and math) Program Offerings 28 Supply & Equipment Purchasing 29 Technology Services 30 Transportation 31 Vocational Education Cooperatives 32 All Other Joint/Cooperative Agreements 33 Other 34 35 Additional space for Column (D) - Barriers to Implementation: 36 37 38 40 Additional space for Column (E) - Name of LEA : 41 42 43
(Limit text to 200 characters, for additional space use line 33 and 38)
X X
X X
N/A N/A
Members of CLIC (Collective Liability Insurance Cooperative) Bloom Township Treasurer's Office
X
X
N/A
Member of SPEED SEJA No. 802
Page 31
#####
Page 32
Page 32
ILLINOIS STATE BOARD OF EDUCATION School Business Services Division (N-330) 100 North First Street Springfield, IL 62777-0001 LIMITATION OF ADMINISTRATIVE COSTS WORKSHEET (Section 17-1.5 of the School Code)
School District Name: RCDT Number: Actual Expenditures, Fiscal Year 2016 (10)
Description
Funct. No.
Educational Fund
(20) Operations & Maintenance Fund
Bloom High School District 206 07-016-2060-17
Budgeted Expenditures, Fiscal Year 2017 (10) Total
Educational Fund
(20) Operations & Maintenance Fund
Total
1. Executive Administration Services
2320
695,550
695,550
587,900
587,900
2. Special Area Administration Services
2330
836,034
836,034
692,780
692,780
3. Other Support Services - School Administration
2490
622,431
622,431
546,500
4. Direction of Business Support Services
2510
145,477
145,477
146,750
5. Internal Services
2570
160,223
160,223
196,750
196,750
6. Direction of Central Support Services
2610
674,492
674,492
539,091
539,091
0
7. Deduct - Early Retirement or other pension obligations required by state law and included above.
0 3,134,207
8. Totals
546,500 0
0
3,134,207
146,750
0 2,709,771
0
Percent Increase (Decrease) for FY2017 (Budgeted) over 9. FY2016 (Actual)
2,709,771 -14%
CERTIFICATION I certify that the amounts shown above as "Actual Expenditures, Fiscal Year 2016" agree with the amounts on the district's Annual Financial Report for Fiscal Year 2016. I also certify that the amounts shown above as "Budgeted Expenditures, Fiscal Year 2017" agree with the amounts on the budget adopted by the Board of Education.
Signature of Superintendent
Date
Contact Name
Contact Telephone Number
If line 9 is greater than 5% please check one box below. The District is ranked by ISBE in the lowest 25th percentile of like districts in administrative expenditures per student (4th quartile) and will waive the limitation by board action, subsequent to a public hearing. Waiver resolution must be adopted no later than June 30. The district is unable to waive the limitation by board action and will be requesting a waiver from the General Assembly pursuant to the procedures in Chapter 105 ILCS 5/23.25g. Waiver applications must be postmarked by August 12, 2016 to ensure inclusion in the Fall 2016 report, postmarked by January 13, 2017 to ensure inclusion in the Spring 2017 report, or postmarked by August 11, 2017 to ensure inclusion in the Fall 2017 report. Information on the waiver process can be found at www.isbe.net/isbewaivers/default.htm. The district will amend their budget to become in compliance with the limitation. Budget amendments must be adopted no later than June 30.
Page 33
Page 33
This page is provided for detailed itemizations as requested within the body of the report. Type Below.
Statement of Revenue: Fund 10, Account 1690 In-district catering
$
16,573
Registration fees
$
20,008
Bookstore supplies sale
$
18,266
$
146,978 5,120 9,077 1,027 125,959 6,500 12,470 307,131
$
1,940
$
192,082 1,324 193,406
High School Graduation Initiative
$
389,901
School Improvement Grant
$
1,864,900
Perkins - CTE
$
267,921
Positive Youth Development Program
$
163,256
Other miscellaneous income
$
14,917
Fund 10, Account 1790
Fund 10, Account 1829
Fund 10, Account 1999 Medical - employee contributions Reimbursement of cell phones Reimbursement Rebate E-Rate Refunds Other miscellaneous income
Fund 10, Account 3099 Per Capital Library Grant
Fund 10, Account 3999 Orphanage Tuition Illinois False Claim - Stericycle
Fund 10, Account 4090
Fund 10, Account 4399
Fund 10, Account 4799
Fund 10, Account 4999
Fund 20, Account 1999
Statement of Expenditures Fund 10, Account 2190 Bookstore salaries Bookstore employee benefits Professional/technical services Graduation facility rentals Bookstore - supplies Judgments
80,124 8,139 13,887 27,288 26,284 477
Page 33
Page 33
Miscellaneous $
871 157,070
$
426,592 52,732 143,107 622,431
$
816 816
Financial consulting services
$
3,500
Administrative and secretary benefits
$
14,639
Benefits
$
16,607
Fund 10, Account 2490 Administrative salaries Secretary salaries Benefits
Fund 20, Account 2900 Other
Fund 30, Account 5400
Fund 50, Account 2190
Fund 50, Account 2490
Note: Principal payments retired on page 18 do not trace to principal payments retired on pages 25 as capital lease payments are not paid from the debt service fund.
Bloom High School District 206 07-016-2060-17
Page 34
Reference Pages. 1
Do not enter negative numbers. Reports with negative numbers will be returned for correction.
2 GASB Statement No. 24; Accounting and Financial Reporting for Certain Grants and Other Financial Assistance. The "On Behalf of" Payments should only be reflected
on this page. 3 Equals Line 8 minus Line 17 4 May require notification to the county clerk to abate an equal amount from taxes next extended. Refer to Section 17-2.11 for the applicable provisions and other "limited" transfer
authority to O&M through June 30, 2013 5 Requires notification to the county clerk to abate an equal amount from taxes next extended. See Section 10-22.14
6 Use of proceeds from the sale of school sites buildings, or other real estate is limited. See Sections 5-22 and 10-22.8 of the School Code. 7 Include revenue accounts 1110 through 1115, 1117, 1118 & 1120. Include taxes for bonds sold that are in addition to those identified separately. 8 Educational Fund (10) - Computer Technology only. 9 Corporate personal property replacement tax revenue must be first applied to the Municipal Retirement/Social Security Fund to replace tax revenue lost due to the
abolition of the corporate personal property tax (30 ILCS 115/12). This provision does not apply to taxes levied for Medicare-Only purposes. 10 Include only tuition payments made to private facilities. See Function 4200 or 4400 for public facility disbursements/expenditures. 11 Payment towards the retirement of lease/purchase agreements or bonded/other indebtedness (principal only) otherwise reported within the fund―e.g. alternate revenue
bonds( Describe & Itemize). 12 Only abolishment of Working Cash Fund must transfer its funds directly to the Educational Fund upon adoption of a resolution and at the close of the
current school Year (see 105 ILCS 5/20-8 for further explanation) Only abatement of working cash fund can transfer its funds to any fund in most need of money (see 105 ILCS 5/20-10 for further explanation)
Page 34
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES Bloom Township High School District 206’s (the District) accounting policies conform to the accounting practices appropriate for local governmental units using the modified cash basis method of accounting prescribed by the Illinois Program Accounting Manual for Local Education Agencies. The following is a summary of the significant accounting policies: Criteria Used to Determine Scope of Entity The District has developed criteria to determine whether any outside agencies should be included within its financial reporting entity. The criteria include, but are not limited to, whether the District exercises oversight responsibility (which includes financial interdependency, selection of governing authority, designation of management, ability to significantly influence operations, and accountability for fiscal matters), scope of public service, and special financing relationships. The District has determined that no other outside agency meets the above criteria and, therefore, no other agency has been included as a component unit in the District’s financial statements. In addition, the District is not aware of any entity which would exercise such oversight which would result in the District being considered a component unit of the entity. The District is a member of the Special Education Co-op of South Cook County (SPEED) Joint Agreement No. 802, along with other area school districts. The District’s pupils benefit from programs administered under this joint agreement, and the District benefits from jointly administered grants and programming. SPEED is a jointly governed organization in which the District has no ongoing financial interest. Financial information may be obtained directly from SPEED at 1125 Division Street, Chicago Heights, Illinois 60411. Basis of Accounting The District’s financial records are maintained on a modified cash basis method of accounting as described in the Illinois Program Accounting Manual for Local Education Agencies and, accordingly, revenues are recorded when cash is received rather than when earned and expenditures are recorded when cash is disbursed rather than when incurred. Only assets representing a right to receive cash from a previous payment of cash are recorded as assets of a fund. In the same manner, only liabilities resulting from cash transactions are recorded as liabilities of a particular fund. Proceeds from sales of bonds are included as other financing sources in the appropriate fund on the date received. Related bond principal payable in the future is recorded at the same time in the General Long-Term Debt Account Group. The District records on-behalf payments made by the State to the Teachers’ Retirement System (TRS) and Teacher Health Insurance Security (THIS) Fund and commodities as revenues and expenditures.
35
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Basis of Presentation - Fund Accounting The accounts of the District are organized on the basis of funds and account groups, each of which is considered a separate accounting entity. The operations of each fund are accounted for with a separate set of self-balancing accounts that are comprised of its assets, liabilities, fund balance, revenues received, and expenditures disbursed. The District maintains individual funds as required by the State of Illinois. District resources are allocated to and accounted for in individual funds based upon the purposes for which they are to be spent and the means by which spending activities are controlled. The Illinois State Board of Education has provided the District with the following funds and account groups: The Educational Fund covers transactions that are not specifically covered in another fund. Certain expenditures disbursed that must be charged to this fund include direct costs of instructional, health and attendance services, lunch programs, all costs of administration (even those for buildings and grounds), and related insurance costs. Certain revenues received that must be credited to this fund include educational tax levies, tuition and textbook rentals. The Operations and Maintenance Fund includes all costs of maintaining, improving, or repairing school buildings and property, renting buildings and property for school purposes, or paying of premiums for insurance on school buildings. The Debt Services Fund accounts for taxes levied to provide cash to retire and pay interest on bonds generally issued to finance the construction of buildings. To protect the bondholders, these tax collections must be accounted for in the Debt Services Fund. The Transportation Fund accounts for any payments for transporting pupils, including the purchase of vehicles and insurance on buses. Monies received for transportation purposes from any source must be deposited into this fund except for the portion of state reimbursement applicable to other funds. The Municipal Retirement/Social Security Fund accounts for a separate tax levied for the purpose of providing resources for the District’s share of retirement benefits for covered employees and/or a separate tax levied for the purpose of providing resources for the District’s share of Social Security and Medicare payments for covered employees. The Capital Projects Fund accounts for a separate tax levied for the purpose of capital improvements which may include construction costs, the purchase of land, other items directly related to the construction project, and administrative costs directly related to the construction project. The Working Cash Fund accounts for a tax levied for working cash purposes or if bonds are sold for this purpose. Interfund loans from the District’s Working Cash Fund may be made to any fund for which taxes are levied. The Tort Fund accounts for a tax levied or bonds issued for insurance, risk management, judgments/settlements, legal services and other loss prevention purposes.
35a
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) The Fire Prevention and Safety Fund accounts for a tax levied or bonds issued for fire prevention, safety, energy conservation or school security purposes. The Agency Fund (Activity Funds) accounts for assets held by the District as an agent for the students and teachers. These funds are custodial in nature and do not involve the measurement of the results of operations. The amounts due to Activity Fund organizations are equal to the assets. The General Fixed Assets Account Group maintains records of physical assets which have a long-term (i.e., more than one year) period of usefulness to the District in a group of accounts separate from the fund which provided the cash for the purchase of those assets. The General Long-Term Debt Account Group maintains records of the District’s total bonded debt in a group of accounts separate from the Debt Services Fund. Other types of general long-term debt are also included in this fund. General Fixed Assets General fixed assets are those acquired for general governmental purposes. Assets purchased are recorded as current expenditures at the date of acquisition in the governmental funds and capitalized at cost in the General Fixed Assets Account Group. Donated general fixed assets are recorded, if material, at estimated fair market value at date of acquisition. The District has set a capitalization threshold of $5,000 for all fixed asset types. The financial statements make no provision for depreciation. Depreciation is applicable only for computing per capita tuition charges on the Illinois State Board of Education's Annual Financial Report. Depreciation is computed by the straight-line method over the following estimated useful lives of the fixed assets: Buildings: 50 years Site improvements and infrastructure: 20 years Equipment: 5 - 10 years Pooled Cash and Investments The District is one of 18 entities that participate in the Bloom Township School Treasurer’s cash and investment pool. The District’s investment in the pool is carried on the District’s books at cost determined on a first-in, first-out basis. The Treasurer maintains records that segregate the cash and investment balances by District. Earnings on investments, including gains and losses on sales of investments, are allocated monthly based upon the District’s percentage participation in the cash and investment pool. No entity is permitted to borrow from another entity through deficit spending within the Treasurer's cash and investment pool. Within each entity itself, interfund loans and repayments are made from time to time among the various funds. State law permits these temporary interfund loans caused by deficit spending on special tax levies. No interest income or expense is recognized on interfund loans.
35b
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Inventories Inventory of supplies is not normally recorded using the modified cash basis of accounting. In addition, the District does not maintain inventories in amounts material to the financial statements. Use of Estimates The preparation of financial statements in conformity with the modified cash basis of accounting requires management to make estimates and assumptions that affect the amounts reported in the financial statements and accompanying notes. Actual results may differ from those estimates. Subsequent Events Subsequent events have been evaluated through December 20, 2016, which is the date the financial statements were available to be issued. NOTE 2 – PROPERTY TAXES – GENERAL The District’s property tax is levied each calendar year on all taxable real property located in the District’s jurisdiction. The School Board must adopt the tax levy and file a certified copy of the levy with the County Clerk's Office on or before the last Tuesday in December. The District adopted its 2015 levy on December 14, 2015. Property taxes attach retroactively as an enforceable lien as of January 1 of the levy year and are payable in two installments on March 1 and thirty days after release of the second billing which is generally between August and November of the current calendar year (for Will County June 2 and September 2 of the current calendar year). The District receives significant distributions approximately one month after the collection dates. Taxes recorded in these financial statements are from the 2015 and prior tax levies. NOTE 3 – CASH AND INVESTMENTS Local education agencies may invest public funds according to Chapter 30, Section 235 of the Illinois Compiled Statutes. Allowable investments include the following:
Securities guaranteed both as to principal and interest by the full faith and credit of the United States;
Bonds, notes, debentures, or other similar obligations of the United States or its agencies;
Interest bearing savings accounts, certificates of deposit or time deposits in a federally insured bank;
In limited circumstances, short-term corporate obligations of corporations having assets exceeding $500 million dollars;
35c
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 3 – CASH AND INVESTMENTS (Continued)
Money market mutual funds that are both registered under the Investment Company Act of 1940 and the holdings of which are limited to securities guaranteed both as to principal and interest by the full faith and credit of the United States;
Public Treasurers’ Investment Pools created under Section 17 of the Illinois State Treasurer Act.
The components of cash and investments at June 30, 2016 are as follows:
Total Reported Cash and investment - net Bloom Township Treasurer's cash and investment pool Book balance of accounts in District's name Deposit-in-transit Outstanding checks Bank balance of cash and investments in District's name
$
$
17,087,008 (15,852,508) 1,234,500 21,261 (66,485) 1,189,276
Deposits Custodial credit risk for deposits is the risk that, in the event of a bank failure, the District’s deposits may not be returned or the District will not be able to recover collateral securities in the possession of an outside party. Neither the State of Illinois nor the District has a deposit policy for custodial credit risk. At June 30, 2016 100% of the District’s book balance of $1,189,276 is fully insured and collateralized. Investments The District’s investing activities are managed under the custody of the Bloom Township School Treasurer which is a non-rated, external investment pool. Investing is performed in accordance with investment policies adopted by the Bloom Township Trustees of Schools complying with the Illinois Compiled Statutes. The District’s portion of this pool is included in the statement of assets and liabilities arising from cash transactions as cash and investments. Overall credit ratings are not applicable for the cash and investment pool as a whole. Financial information and investment risk disclosures regarding the cash and investment pool’s underlying investments may be obtained directly from the Treasurer at 3311 Chicago Road, South Chicago Heights, Illinois 60411. At June 30, 2016, the total fair value of pooled cash and investments held by the Treasurer was approximately $293,129,340 and the amount of cash and investments allocated to the District on a cost basis was $15,852,508.
35d
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 4 – CAPITAL ASSETS AND DEPRECIATION The District does not maintain historical cost records of fixed assets. The General Fixed Assets Account Group includes costs of fixed assets purchased less proceeds from sales of assets. It does not necessarily reflect losses, thefts, or abandonments. A summary of changes in capital assets for the year ended June 30, 2016 is as follows: Balance July 1, 2015 Capital assets, not being depreciated Land $ Capital assets being depreciated Buildings Site improvement & infrastructure Equipment Total capital assets being depreciated Total
330,172
Additions $
Balance June 30, 2016
Deletions
-
$
-
$
330,172
36,899,747 3,236,015 9,182,227
1,068,000 149,724
-
36,899,747 4,304,015 9,331,951
49,317,989
1,217,724
-
50,535,713
$ 49,648,161
$
1,217,724
$
-
$
50,865,885
Accumulated depreciation at June 30, 2016 is $31,240,259 NOTE 5 – FUND BALANCES Under the Regulatory Basis of Accounting, revenues received from special tax levies and selected revenue sources are restricted as to their use and classified as reserved fund balances on the statement of assets and liabilities arising from cash transactions. The changes in the reserved fund balances for the fiscal year ended June 30, 2016 is as follows:
Reserved July 1, 2015
Revenues
Educational Fund Special tax levy Special Education
$
-
$
1,040
Other revenue source Driver Education Total
$
-
$
113,281 114,321
35e
Expenditures
$
Reserved June 30, 2016
1,040
$
-
113,281 $ 114,321
$
-
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 5 – FUND BALANCES (Continued) Governmental Accounting Standards Board (GASB) Statement No. 54, Fund Balance Reporting and Governmental Fund Type Definitions established five fund balance classifications that comprise a hierarchy based primarily on the extent to which a government is bound to observe constraints imposed upon the use of the resources. Nonspendable fund balance - Includes amounts that cannot be spent because they are either (a) not in spendable form - prepaid items or inventories; or (b) legally or contractually required to be maintained intact. Restricted fund balance - Refers to amounts that are subject to outside restrictions not controlled by the entity, such as restrictions imposed by creditors, grantors, contributors, or laws and regulations of other governments, or imposed by law through constitutional provisions or enabling legislation. Committed fund balance - Amounts that can be used only for specific purposes because of a formal action (resolution or ordinance) by the District’s highest level of decision-making authority, the Board of Education. Assigned fund balance - Amounts that are constrained by the District’s intent to be used for specific purposes, but that do not meet the criteria to be classified as restricted or committed. Intent can be stipulated by the District’s Board of Education or by an official to whom that authority has been given. Unassigned fund balance - The residual classification for amounts in the Educational, Operations and Maintenance, and Working Cash funds. Negative unassigned fund balances in other funds represents excess expenditures incurred over the amounts restricted, committed or assigned to those purposes.
35f
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 5 – FUND BALANCES (Continued) The regulatory basis of accounting used by the District does not utilize these categories. If the June 30, 2016 regulatory basis fund balances were reported in accordance with GASB Statement No. 54, they would be allocated as follows: Fund Educational Operations & Maintenance Debt Services Transportation Municipal Retirement/ Social Security Capital Projects Working Cash Tort Fire Prevention & Safety Totals
Nonspendable $
$
-
Restricted $
-
Fund Balances Committed Assigned
Unassigned
$
-
$ 8,006,114
-
$
Total $
8,006,114
-
1,623,819 852,630
-
-
1,841,356 -
1,841,356 1,623,819 852,630
-
2,132,244 25,807 -
-
-
2,163,760 49,371
2,132,244 25,807 2,163,760 49,371
-
39,152 $ 4,673,652
-
$ 12,060,601
-
$
$
$
39,152 16,734,253
Unless specifically identified, expenditures disbursed act to reduce restricted balances first, then committed balances, next assigned balances, and finally unassigned balances. Expenditures disbursed for a specifically identified purpose will act to reduce the specific classification of fund balance that is identified. NOTE 6 – LONG-TERM OBLIGATIONS The following is a summary of the District’s long-term obligations for the year ended June 30, 2016:
Liability at July 1, 2015 New bonds issued Retirement of existing debt Totals
General Obligation Bonds
Capital Lease
Total
$ 10,730,000 (4,350,000) $ 6,380,000
$ 314,044 (152,348) $ 161,696
$ 11,044,044 (4,502,348) $ 6,541,696
35g
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 6 – LONG-TERM OBLIGATIONS (Continued) Long-term obligations payable at June 30, 2016 consist of the following:
Issue of July 12, 2011 2007 capital lease obligation Totals
Interest Rates
Outstanding Amount
2.20% - 3.00% 6.13%
$ 6,380,000 161,696 $ 6,541,696
Principal and interest on the capital lease obligation were paid from the Operations and Maintenance Fund. Principal and interest payments by year to liquidate all long-term obligations are as follows:
Fiscal Year Ending June 30, 2016 2017 2018 Total
Principal 4,696,696 1,845,000
Interest 127,068 27,675
6,541,696
$ 154,743
$
Total 4,823,764 1,872,675 $
6,696,439
Illinois State Statute limits the amount of a District’s total debt to 6.9 percent of Equalized Assessed Valuation. The District’s legal debt margin is computed as follows:
Equalized Assessed Valuation Maximum legal debt rate Maximum debt
$ 691,831,875 6.90% $ 47,736,399
Outstanding debt subject to limitation at June 30, 2016
35h
$
6,380,000
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 7 – RISK MANAGEMENT The District has joined together with other school districts in the State of Illinois to form Collective Liability Insurance Cooperative (CLIC), a public entity risk pool currently operating as a common risk management and insurance program for 173 members. The District pays premiums to CLIC for its general insurance coverage, auto and workers’ compensation insurance. CLIC is self-sustaining through member premiums and reinsures through commercial companies for claims in excess of $1,000,000 for each insured event. The District is self-insured for medical and dental benefits for eligible employees and dependents. Plan participants are full-time employees who have completed the enrollment form and authorized the necessary employee contributions, if any. Participation begins the first day of full-time employment and ends at termination. Coverage can be continued during an approved leave of absence or as a retiree. The District utilizes a third-party administrator to process the District’s medical and dental claims. Total claims paid during the year ended June 30, 2016 for medical and dental were $3,823,603 and $222,436 respectively. The District carries commercial insurance for all other risks of loss including vision and life insurance. Settled claims resulting from these risks have not exceeded commercial insurance coverage in the past three years.
35i
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 8 - RETIREMENT SYSTEMS The retirement plans of the District include the Teachers’ Retirement System of the State of Illinois (TRS) and the Illinois Municipal Retirement Fund (IMRF). Most funding for TRS is provided through payroll withholdings of certified employees and contributions made by the State of Illinois on-behalf of the District. IMRF is funded through property taxes and a perpetual lien of the District’s corporate personal property replacement tax. Each retirement system is discussed below. Due to the modified cash nature of the financial statements, the following net pension liability, deferred inflows/outflows of resources and pension expense balances are not reported in the financial statements. Below is aggregate information related to the TRS and IMRF plans in total reported by the District as of and for the year ended June 30, 2016: TRS
Total Net Pension Liability Deferred Outflows of Resources Deferred Inflows of Resources Pension Expense
IMRF $ $ 4,466,376 978,704 3,539,882 (2,369,030) (81,179) 1,774,023
Total $ 4,466,376 4,518,586 (2,369,030) 1,692,844
Teachers' Retirement System Plan Description. The District participates in the Teachers’ Retirement System of the State of Illinois (TRS). TRS is a cost-sharing multiple-employer defined benefit pension plan that was created by the Illinois legislature for the benefit of Illinois public school teachers employed outside the city of Chicago. TRS members include all active non-annuitants who are employed by a TRS-covered employer to provide services for which teacher licensure is required. The Illinois Pension Code outlines the benefit provisions of TRS, and amendments to the plan can be made only by legislative action with the Governor’s approval. The TRS Board of Trustees is responsible for the System’s administration. TRS issues a publicly available financial report that can be obtained at http://trs.illinois.gov/pubs/cafr; by writing to TRS at 2815 W. Washington, PO Box 19253, Springfield, IL 62794; or by calling (888) 877-0890, option 2. Benefits Provided. TRS provides retirement, disability, and death benefits. Tier I members have TRS or reciprocal system service prior to January 1, 2011. Tier I members qualify for retirement benefits at age 62 with five years of service, at age 60 with 10 years, or age 55 with 20 years. The benefit is determined by the average of the four highest years of creditable earnings within the last 10 years of creditable service and the percentage of average salary to which the member is entitled. Most members retire under a formula that provides 2.2 percent of final average salary up to a maximum of 75 percent with 34 years of service. Disability and death benefits are also provided. Tier II members qualify for retirement benefits at age 67 with 10 years of service, or a discounted annuity can be paid at age 62 with 10 years of service. Creditable earnings for retirement purposes are capped and the final average salary is based on the highest consecutive eight years of creditable service rather than the last 35j
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 8 - RETIREMENT SYSTEMS (Continued) four. Disability provisions for Tier II are identical to those of Tier I. Death benefits are payable under a formula that is different from Tier I. Essentially all Tier I retirees receive an annual 3 percent increase in the current retirement benefit beginning January 1 following the attainment of age 61 or on January 1 following the member’s first anniversary in retirement, whichever is later. Tier II annual increases will be the lesser of three percent of the original benefit or one-half percent of the rate of inflation beginning January 1 following attainment of age 67 or on January 1 following the member’s first anniversary in retirement, whichever is later. Contributions. The State of Illinois maintains the primary responsibility for funding TRS. The Illinois Pension Code, as amended by Public Act 88-0593 and subsequent acts, provides that for years 2010 through 2045, the minimum contribution to the System for each fiscal year shall be an amount determined to be sufficient to bring the total assets of the System up to 90 percent of the total actuarial liabilities of the System by the end of fiscal year 2045. Contributions from active members and TRS contributing employers are also required by the Illinois Pension Code. The contribution rates are specified in the pension code. The active member contribution rate for the year ended June 30, 2016 was 9.4 percent of creditable earnings. The member contribution, which may be paid on behalf of employees by the District, is submitted to TRS by the District. On Behalf Contributions to TRS. The State of Illinois makes employer pension contributions on behalf of the District. For the year ended June 30, 2016, State of Illinois contributions recognized by the District were based on the state’s proportionate share of the collective net pension liability associated with the District, and the District recognized revenue and expenditures of $10,152,729 in pension contributions from the State of Illinois. 2.2 Formula Contributions. Employers contribute 0.58 percent of total creditable earnings for the 2.2 formula change. The contribution rate is specified by statute. Contributions for the year ended June 30, 2016, were $125,448, and are deferred because they were paid after the June 30, 2015 measurement date. Federal and Trust Fund Contributions. When TRS members are paid from federal and special trust funds administered by the District, there is a statutory requirement for the District to pay an employer pension contribution from those funds. Under a policy adopted by the TRS Board of Trustees that has been in effect since the fiscal year ended June 30, 2006, employer contributions for employees paid from federal and special trust funds will be the same as the state contribution rate to TRS. Public Act 98-0674 now requires the two rates to be the same. For the year ended June 30, 2016, the District pension contribution was 36.06 percent of salaries paid from federal and special trust funds. Contributions for the year ended June 30, 2016, were $567,279. These contributions are deferred because they were paid after the June 30, 2015 measurement date. Early Retirement Option. Contributions that an employer is required to pay because of a TRS member retiring are categorized as specific liability payments. The District is required to make a one-time contribution to TRS for members retiring under the Early Retirement Option (ERO). The payments vary depending on the member’s age and salary. The maximum employer ERO contribution under the current program is 146.5 35k
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 8 - RETIREMENT SYSTEMS (Continued) percent and applies when the member is age 55 at retirement. For the year ended June 30, 2016, the District paid $0 to TRS for employer ERO contributions. Salary increases over 6 percent. The District is also required to make a one-time contribution to TRS for members granted salary increases over 6 percent if those salaries are used to calculate a retiree’s final average salary. For the year ended June 30, 2016, the District paid $0 to TRS for employer contributions due on salary increases in excess of 6 percent. Excess sick leave. A one-time contribution is also required for members granted sick leave days in excess of the normal annual allotment if those days are used as TRS service credit. For the year ended June 30, 2016, the District made no payments to TRS for sick leave days granted in excess of the normal annual allotment. TRS Fiduciary Net Position. Detailed information about the TRS’s fiduciary net position as of June 30, 2015, is available in the separately issued TRS Comprehensive Annual Financial Report. Net Pension Liability. At June 30, 2016, the District reported a liability for its proportionate share of the net pension liability (first amount shown below) that reflected a reduction for state pension support provided to the District. The state’s support and total are for disclosure purposes only. The amount recognized by the District as its proportionate share of the net pension liability, the related state support, and the total portion of the net pension liability that was associated with the District were as follows: District's proportionate share of the collective net pension liability State's proportionate share of the collective net pension liability associated with the District Total
$
8,409,883 123,921,926 $ 132,331,809
The net pension liability was measured as of June 30, 2015, and the total pension liability used to calculate the net pension liability was determined by an actuarial valuation as of June 30, 2014, and rolled forward to June 30, 2015. The District’s proportion of the net pension liability was based on the District’s share of contributions to TRS for the measurement year ended June 30, 2015, relative to the projected contributions of all participating TRS employers and the state during that period. At June 30, 2015, the District’s proportion was 0.0128375418 percent, which was a decrease of 0.0037719019 percent from its proportion measured as of June 30, 2014. The net pension liability is not recorded in these modified cash basis financial statements. Summary of Significant Accounting Policies. For purposes of measuring the collective net pension liability, deferred outflows of resources and deferred inflows of resources related to pensions, and pension expense, information about the fiduciary net position of TRS and additions to/deductions from TRS fiduciary net position have been determined on the same basis as they are reported by TRS. For this purpose, benefit payments (including refunds of employee contributions) are recognized when due and payable in accordance with the benefit terms. Investments are reported at fair value. Actuarial Assumptions. The assumptions used to measure the total pension liability in the June 30, 2015 actuarial valuation included (a) 7.50% investment rate of return net of pension plan investment expense, 35l
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 8 - RETIREMENT SYSTEMS (Continued) including inflation, (b) projected salary increases vary by amount of service credit, and (c) inflation of 3.00%. The actuarial assumptions for the years ended June 30, 2015 and 2014 were different. The actuarial assumptions used in the June 30, 2015 valuation were based on the 2015 actuarial experience analysis. The investment return assumption remained at 7.5 percent, salary increase assumptions were lowered, retirement rates were increased, mortality updates were made and other assumptions were revised. The actuarial assumptions used in the June 30, 2014 valuation were based on updates to economic assumptions adopted in 2014 which lowered the investment return assumption from 8.0 percent to 7.5 percent. The salary and inflation assumptions were also lowered from their 2013 levels. Mortality. Mortality rates were based on the RP-2014 White Collar Table with adjustments as appropriate for TRS experience. The rates are used on a fully-generational basis using projection table MP-2014. Long-Term Expected Real Rate of Return. The long-term expected rate of return on pension plan investments was determined using a building-block method in which best-estimate ranges of expected future real rates of return (expected returns, net of pension plan investment expense and inflation) are developed for each major asset class. These ranges are combined to produce the long-term expected rate of return by weighting the expected future real rates of return by the target asset allocation percentage and by adding expected inflation. The target allocation and best estimates of arithmetic real rates of return for each major asset class that were used by the actuary are summarized in the following table:
Target Allocation 18.00% 18.00% 16.00% 2.00% 11.00% 4.00% 8.00% 8.00% 1.00% 14.00%
Asset Class U.S. large cap Global equity excluding U.S Aggregate bonds U.S. TIPS NCREIF Opportunistic real estate ARS Risk parity Diversified inflation strategy Private equity
Long-Term Expected Real Rate of Return 7.53% 7.88% 1.57% 2.82% 5.11% 9.09% 2.57% 4.87% 3.26% 12.33%
Discount Rate. At June 30, 2015, the discount rate used to measure the total pension liability was a blended rate of 7.47 percent, which was a change from the June 30, 2014 rate of 7.50 percent. The projection of cash flows used to determine the discount rate assumed that employee contributions, employer contributions, and state contributions will be made at the current statutorily-required rates. Based on those assumptions, TRS’s fiduciary net position at June 30, 2015 was not projected to be available to make all projected future benefit payments of current active and inactive members and all benefit recipients. Tier I’s liability is partially funded by Tier II members, as the Tier II member contribution is higher 35m
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 8 - RETIREMENT SYSTEMS (Continued) than the cost of Tier II benefits. Due to this subsidy, contributions from future members in excess of the service cost are also included in the determination of the discount rate. Despite the subsidy, all projected future payments were not covered, so a slightly lower long-term expected rate of return on TRS investments was applied to all periods of projected benefit payments to determine the total pension liability. At June 30, 2014, the discount rate used to measure the total pension liability was 7.50 percent. The discount rate was the same as the actuarially-assumed rate of return on investments that year because TRS’s fiduciary net position and the subsidy provided by Tier II were sufficient to cover all projected benefit payments. Discount Rate Sensitivity. The following presents the District’s proportionate share of the net pension liability calculated using the discount rate of 7.47 percent, as well as what the District’s proportionate share of the net pension liability would be if it were calculated using a discount rate that is 1-percentage-point lower (6.47 percent) or 1-percentage-point higher (8.47 percent) than the current rate:
District's proportionate share of the collective net pension liability
1% Decrease (6.47%)
Current Discount Rate (7.47%)
1% Increase (8.47%)
$ 10,392,554
$ 8,409,883
$ 6,784,040
Pension Expense and Deferred Outflows of Resources and Deferred Inflows of Resources Related to Pensions. For the year ended June 30, 2016, the District recognized pension expense of ($81,179) and on-behalf revenue and expenditures of $10,152,729 for support provided by the state. At June 30, 2016, the District reported deferred outflows of resources and deferred inflows of resources related to pensions from the following sources: Deferred Outflow of Resources Differences between expected and actual experience Net difference between projected and actual earnings on pension plan investments Changes of assumptions Changes in proportion and differences between District contributions and proportionate share of contributions District contributions subsequent to the measurement date Total
35n
$
$
3,125
Deferred Inflow of Resources $
(9,218)
166,552 116,300
(294,486) -
692,727 978,704
(2,065,326) $ (2,369,030)
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 8 - RETIREMENT SYSTEMS (Continued) Pension expense, deferred outflows of resources and deferred inflows of resources are not recorded in these modified cash basis financial statements. The amount reported as deferred outflows resulting from contributions subsequent to the measurement date in the above table will be recognized as a reduction in the net pension liability for the year ending June 30, 2016. The remaining amounts reported as deferred outflows and inflows of resources related to pensions ($1,390,326) will be recognized in pension expense as follows: Year Ending June, 30 2017 2018 2019 2020 Total
Amount $ 129,383 (563,345) (563,345) (393,019) $ (1,390,326)
Illinois Municipal Retirement Fund Plan Description. The District’s defined benefit pension plan for Regular employees provides retirement and disability benefits, post retirement increases, and death benefits to plan members and beneficiaries. The District's plan is affiliated with the Illinois Municipal Retirement Fund (IMRF), an agent multiple-employer plan. Benefit provisions are established by statute and may only be changed by the General Assembly of the State of Illinois. IMRF issues a publicly available financial report that includes financial statements and required supplementary information. The report may be obtained on-line at www.imrf.org. All employees hired in positions that meet or exceed the prescribed annual hourly standard must be enrolled in IMRF as participating members. Public Act 96-0889 created a second tier for IMRF’s Regular Plan. IMRF assigns a benefit tier to a member when he or she is enrolled in IMRF. The tier is determined by the member’s first IMRF participation date. If the member first participated in IMRF before January 1, 2011, they participate in Regular Tier 1. If the member first participated in IMRF on or after January 1, 2011, they participate in Regular Tier 2. For Regular Tier 1, pension benefits vest after eight years of service. Participating members who retire at or after age 60 with 8 years of service are entitled to an annual retirement benefit, payable monthly for life in an amount equal to 1 2/3% of their final rate (average of the highest 48 consecutive months earnings during the last 10 years) of earnings for each year of credited service up to 15 years and 2% for each year thereafter. For Regular Tier 2, pension benefits vest after ten years of service. Participating members who retire at or after age 67 with 10 years of service, or age 62 with 35 years of service are entitled to an annual retirement benefit as described above. IMRF also provides death and disability benefits. These benefit provisions and all other requirements are established by state statute.
35o
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 8 - RETIREMENT SYSTEMS (Continued) Plan Membership. At December 31, 2015, the measurement date, membership of the plan was as follows: Retirees and beneficiaries Inactive, non-retired members Active members Total
359 187 187 733
Contributions. As set by statute, District employees participating in IMRF are required to contribute 4.50 percent of their annual covered salary. The statute requires the District to contribute the amount necessary, in addition to member contributions, to finance the retirement coverage of its own employees. The District's actuarially determined contribution rate for calendar year 2015 was 10.91 percent of annual covered payroll. The District also contributes for disability benefits, death benefits and supplemental retirement benefits, all of which are pooled at the IMRF level. Contribution rates for disability and death benefits are set by the IMRF Board of Trustees, while the supplemental retirement benefits rate is set by statute. Net Pension Liability/(Asset). The net pension liability/(asset) was measured as of December 31, 2015, and the total pension liability used to calculate the net pension liability/(asset) was determined by an annual actuarial valuation as of that date. The net pension liability is not recorded in these modified cash basis financial statements. Summary of Significant Accounting Policies. For purposes of measuring the net pension liability/(asset), deferred outflows of resources and deferred inflows of resources related to pensions, and pension expense, information about the fiduciary net position of IMRF and additions to/deductions from IMRF fiduciary net position have been determined on the same basis as they are reported by IMRF. For this purpose, benefit payments (including refunds of employee contributions) are recognized when due and payable in accordance with the benefit terms. Investments are reported at fair value. Actuarial Assumptions. The assumptions used to measure the total pension liability in the December 31, 2015 annual actuarial valuation included (a) 7.48% investment rate of return, (b) projected salary increases from 3.75% to 14.50%, including inflation, and (c) inflation of 3.50% and price inflation of 2.75%. The retirement age is based on experience-based table of rates that are specific to the type of eligibility condition. The tables were last updated for the 2014 valuation pursuant to an experience study of the period 2011- 2013. Mortality. For non-disabled retirees, an IMRF specific mortality table was used with fully generational projection scale MP-2014 (base year 2014). The IMRF specific rates were developed from the RP-2014 Blue Collar Health Annuitant Mortality Table with adjustments to match current IMRF experience. For disabled retirees, an IMRF specific mortality table was used with fully generational projection scale MP- 2014 (base year 2014). The IMRF specific rates were developed from the RP-2014 Disabled Retirees Mortality Table applying the same adjustment that were applied for non-disabled lives. For active members, an IMRF
35p
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 8 - RETIREMENT SYSTEMS (Continued) specific mortality table was used with fully generational projection scale MP-2014 (base year 2014). The IMRF specific rates were developed from the RP-2014 Employee Mortality Table with adjustments to match current IMRF experience. Long-Term Expected Real Rate of Return. The long-term expected rate of return on pension plan investments was determined using an asset allocation study in which best-estimate ranges of expected future real rates of return (net of pension plan investment expense and inflation) were developed for each major asset class. These ranges were combined to produce long-term expected rate of return by the target asset allocation percentage and by adding expected inflation. The target allocation and best estimates of arithmetic and geometric real rates of return for each major asset class are summarized in the following table:
Asset Class Equities International equities Fixed Income Real Estate Alternatives Private equity Hedge funds Commodities Cash equivalents
Target Allocation 38% 17% 27% 8% 9%
1%
Projected Returns/Risk One Year Ten Year Arithmatic Geometric 8.85% 1.39% 9.55% 7.59% 3.05% 3.00% 7.20% 6.00%
13.15% 5.55% 4.40% 2.25%
8.15% 5.25% 2.75% 2.25%
Discount Rate. The discount rate used to measure the total pension liability for IMRF was 7.48%. The discount rate calculated using the December 31, 2014 measurement date was 7.49%. The projection of cash flows used to determine the discount rate assumed that member contributions will be made at the current contribution rate and that District contributions will be made at rates equal to the difference between actuarially determined contribution rates and the member rate. Based on those assumptions, the fiduciary net position was projected not to be available to make all projected future benefit payments of current plan members. Therefore, the long-term expected rate of return on investments of 7.50% was blended with the index rate of 3.57% for tax exempt 20-year general obligation municipal bonds with an average AA credit rating at December 31, 2015 to arrive at a discount rate of 7.48 used to determine the total pension liability. The year ending December 31, 2086 is the last year in the 2016 to 2115 projection period for which projected benefit payments are fully funded.
35q
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 8 - RETIREMENT SYSTEMS (Continued) Discount Rate Sensitivity. The following is a sensitivity analysis of the net pension liability/(asset) to changes in the discount rate. The table below presents the pension liability of the District calculated using the discount rate of 7.48% as well as what the net pension liability/(asset) would be if it were to be calculated using a discount rate that is 1 percentage point lower (6.48%) or 1 percentage point higher (8.48%) than the current rate:
Total pension liability Plan fiduciary net position Net pension liability/(asset)
1% Decrease
Current Discount Rate
1% Increase
$ 49,709,471 39,954,291 $ 9,755,180
$ 44,420,667 39,954,291 $ 4,466,376
$ 40,029,380 39,954,291 $ 75,089
Changes in Net Pension Liability/(Asset). The District's changes in net pension liability/(asset) for the calendar year ended December 31, 2015 was as follows:
Balances at December 31, 2014 Service cost Interest on total pension liability Differences between expected and actual experience of the total pension liability Change of assumptions Benefit payments, including refunds of employee contributions Contributions - employer Contributions - employee Net investment income Other (net transfer) Balances at December 31, 2015
Increase (Decrease) Plan Fiduciary Net Pension Net Position Liability/(Asset (b) (a) - (b) $ 40,763,487 $ 2,177,200 797,751 3,148,471 92,602 92,602 48,949 48,949 (2,607,793) (2,607,793) 798,658 (798,658) 345,911 (345,911) 200,159 (200,159) 453,869 (453,869)
Total Pension Liability (a) $ 42,940,687 797,751 3,148,471
$ 44,420,667
35r
$ 39,954,291
$ 4,466,376
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 8 - RETIREMENT SYSTEMS (Continued) Pension Expense and Deferred Outflows of Resources and Deferred Inflows of Resources Related to Pensions. For the year ended June 30, 2016, the District recognized pension expense of $1,774,023. The District reported deferred outflows and inflows of resources related to pension from the following sources:
Deferred Outflow of Resources Differences between expected and actual experience Assumption changes Net difference between projected and actual earnings on pension plan investments Contributions subsequent to the measurement date Total
$
145,754 375,721
2,582,877 435,530 $ 3,539,882
Deferred Inflow of Resources $
$
-
Pension expense, deferred outflows of resources and deferred inflows of resources are not recorded in these modified cash basis financial statements. The amount reported as deferred outflows resulting from contributions subsequent to the measurement date in the above table will be recognized as a reduction in the net pension liability/(asset) for the year ending June 30, 2016. The remaining amounts reported as deferred outflows and inflows of resources related to pensions ($3,539,882) will be recognized in pension expense as follows: Year Ending June 30, 2015 2016 2017 2018 Total
35s
Amount $ 1,602,839 700,184 673,007 563,852 $ 3,539,882
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 9 - POSTEMPLOYMENT BENEFITS – THIS FUND The District participates in the Teacher Health Insurance Security (THIS) Fund, a cost-sharing, multipleemployer defined benefit postemployment healthcare plan that was established by the Illinois legislature for the benefit of retired Illinois public school teachers employed outside the City of Chicago. The THIS Fund provides medical, prescription, and behavioral health benefits, but it does not provide vision, dental, or life insurance benefits to annuitants of the Teachers’ Retirement System (TRS). Annuitants not enrolled in Medicare may participate in the state administered participating provider option plan or choose from several managed care options. Annuitants who were enrolled in Medicare Parts A and B may be eligible to enroll in Medicare Advantage plans. The State Employees Group Insurance Act of 1971 (5 ILCS 375) outlines the benefit provisions of THIS Fund and amendments to the plan can be made only by legislative action with the Governor’s approval. Effective July 1, 2012, in accordance with Executive Order 12-01, the plan is administered by the Illinois Department of Central Management Services (CMS) with the cooperation of TRS. Section 6.6 of the State Employees Group Insurance Act of 1971 requires all active contributors to TRS who are not employees of the state to make a contribution to THIS Fund. The percentage of employer required contributions in the future will not exceed 105 percent of the percentage of salary actually required to be paid in the previous fiscal year. On-behalf contributions to THIS Fund The State of Illinois makes employer retiree health insurance contributions on behalf of the District. State contributions are intended to match contributions to THIS Fund from active members which were 1.02 percent of pay during the year ended June 30, 2016. State of Illinois contributions were $231,545 and the District recognized revenue and expenditures of this amount during the year. Employer contributions to THIS Fund The District also makes contributions to THIS Fund. The employer THIS Fund contribution was .80 percent during the year ended June 30, 2016. For the year ended June 30, 2016 District paid $173,118 to the THIS Fund, which was 100 percent of the required contribution. Further information on THIS Fund The publicly available financial report of THIS Fund may be found on the website of the Illinois Auditor General: http://www.auditor.illinois.gov/Audit-Reports/ABC-List.asp. The current report is listed under “Central Management Services.” Prior reports are available under “Healthcare and Family Services.”
35t
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 Notes to financial statements June 30, 2016 NOTE 10 – OTHER POSTEMPLOYMENT BENEFITS The District provides postretirement benefits for certain employees. These benefits consist of allowing certain retired employees to continue health and dental coverage under the District’s health plan through participant-paid contributions, which could affect the overall cost of claims paid by the District. The liability for postretirement benefit obligations would not normally be recorded in modified cash basis financial statements. However, disclosure of the liability is required under generally accepted accounting principles. The District has not calculated the liability for any postretirement benefit obligations. NOTE 11 – INDIVIDUAL FUND DISCLOSURES
1. The following fund had expenditures over budget for the year ended June 30, 2016: Actual
Budget
Over
Operations & Maintenance
$ 6,193,365
$ 5,840,600
$
352,765
Debt Service
$ 4,636,700
$ 4,635,410
$
1,290
2. The District did not have any funds that had a negative fund balance as of June 30, 2016. NOTE 12 – CONTINGENCIES The District has received funds from state and federal grants in the current and prior years which are subject to audit by the granting agencies. The School Board believes any adjustments that might arise from these audits would be insignificant to District operations. NOTE 13 – SUBSEQUENT EVENTS On August 2, 2016, the District issued debt: $30,000,000 Debt Certificates, Series 2016A (“Series 2016A Certificates”). The purpose of the Series 2016A Certificates is to (a) purchase real or personal property to improve the sites of, and alter, repair, remodel and equip, the District’s facilities, and including, in connection with said work, acquisition of all land or rights in land, mechanical, electrical, and other services necessary, useful, or advisable thereto (including reimbursements to the District for such costs); and (b) pay certain costs associated with the issuance of the Certificates. On September 28, 2016, the District issued debt: $30,000,000 Taxable General Obligation Limited Tax School Bonds, Series 2016B (“Series 2016B Bonds”). The purpose of the Series 2016B Bonds was to (a) pay claims against the District; and (b) pay costs associated with the issuance of the Bonds.
35u
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 SUPPLEMENTARY INFORMATION SCHEDULE OF CHANGES IN THE DISTRICT'S NET PENSION LIABILITY AND RELATED RATIOS ILLINOIS MUNICIPAL RETIREMENT FUND JUNE 30, 2016
Last 10 Fiscal Years*
2016
2015
$ 797,751 3,148,471 ‐
$ 831,112 2,891,696 ‐
$ ‐ ‐ ‐
$ ‐ ‐ ‐
$ ‐ ‐ ‐
$ ‐ ‐ ‐
$ ‐ ‐ ‐
$ ‐ ‐ ‐
$ ‐ ‐ ‐
$ ‐ ‐ ‐
92,602 48,949
476,432 1,823,104
‐ ‐
‐ ‐
‐ ‐
‐ ‐
‐ ‐
‐ ‐
‐ ‐
‐ ‐
(2,607,793) 1,479,980 42,940,687 $ 44,420,667
(2,444,092) 3,578,252 39,362,435 $ 42,940,687
‐ ‐ ‐ $ ‐
‐ ‐ ‐ $ ‐
‐ ‐ ‐ $ ‐
‐ ‐ ‐ $ ‐
‐ ‐ ‐ $ ‐
‐ ‐ ‐ $ ‐
‐ ‐ ‐ $ ‐
‐ ‐ ‐ $ ‐
$ 798,658 345,911 200,159
$ 777,971 307,303 2,385,157
$ ‐ ‐ ‐
$ ‐ ‐ ‐
$ ‐ ‐ ‐
$ ‐ ‐ ‐
$ ‐ ‐ ‐
$ ‐ ‐ ‐
$ ‐ ‐ ‐
$ ‐ ‐ ‐
(2,607,793) 453,869 $ (809,196)
(2,444,092) (43,196) $ 983,143
‐ ‐ $ ‐
‐ ‐ $ ‐
‐ ‐ $ ‐
‐ ‐ $ ‐
‐ ‐ $ ‐
‐ ‐ $ ‐
‐ ‐ $ ‐
‐ ‐ $ ‐
Plan Fiduciary Net Position ‐ Beginning Plan Fiduciary Net Position ‐ Ending (b)
40,763,487 $ 39,954,291
39,780,344 $ 40,763,487
‐ $ ‐
‐ $ ‐
‐ $ ‐
‐ $ ‐
‐ $ ‐
‐ $ ‐
‐ $ ‐
‐ $ ‐
Net Pension Liability ‐ Ending (a)‐(b)
$ 4,466,376
$ 2,177,200
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
89.95%
94.93%
$ 7,265,370
$ 6,949,428
61.47%
31.33%
Total Pension Liability Service cost Interest Changes of benefit terms Differences between expected and actual experience Changes of assumptions Benefit payments, including refunds of member contributions Net Change in Total Pension Liability Total Pension Liability ‐ Beginning Total Pension Liability ‐ Ending (a) Plan Fiduciary Net Position Contributions ‐ employer Contributions ‐ member Net investment income Benefit payments, including refunds of member contributions Other Net Change in Fiduciary Net Position
Plan Fiduciary Net Position as a Percentage of the Total Pension Liability Covered‐Employee Payroll Net Pension Liability as a Percentage of Covered‐ Employee Payroll
2014
0.00% $ ‐ 0.00%
2013
0.00% $ ‐ 0.00%
*Information is presented for those years for which it was available
35v
2012
0.00% $ ‐ 0.00%
2011
0.00% $ ‐ 0.00%
2010
0.00% $ ‐ 0.00%
2009
0.00% $ ‐ 0.00%
2008
0.00% $ ‐ 0.00%
2007
0.00% $ ‐ 0.00%
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 SUPPLEMENTARY INFORMATION SCHEDULE OF EMPLOYER CONTRIBUTIONS ILLINOIS MUNICIPAL RETIREMENT FUND JUNE 30, 2016
Last 10 Fiscal Years*
2016
2015
2014
2013
2012
2011
2010
2009
2008
2007
Actuarially determined contribution Contributions in relation to the actuarially determined contribution Contribution deficiency (excess)
$ 792,652
$ 784,590
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
798,658 (6,006)
777,971 6,619
‐ ‐
‐ ‐
‐ ‐
‐ ‐
‐ ‐
‐ ‐
‐ ‐
‐ ‐
Covered‐employee payroll
$ 7,265,370
$ 6,949,428
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
10.99%
11.19%
Contributions as a percentage of covered‐ Notes to Schedule: Valuation Date: Actuarial Cost Method: Amortization Method: Remaining Amortization Period: Asset Valuation Method: Inflation: Salary Increases: Investment Rate of Return: Retirement Age: Mortality: Other Information:
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
Actuarially determined contribution rates are calculated as of December 31 each year, which is 6 months prior to the beginning of the fiscal year in which contributions are reported Aggregate entry age normal Level percentage of payroll, closed 28‐year closed period 5‐Year smoothed market; 20% corridor 3% 4.40% to 16.00% including inflation 7.50% Experience‐based table of rates that are specific to the type of eligibility condition. Last updated for the 2011 valuation pursuant to an experience study of the period 2008‐2010 RP‐2000 CHBCA There were no benefit changes during the year
*Information is presented for those years for which it was available
35w
0.00%
BLOOM TOWNSHIP HIGH SCHOOL DISTRICT 206 SUPPLEMENTARY INFORMATION SCHEDULE OF DISTRICT'S PROPORTIONATE SHARE OF THE NET PENSION LIABILITY AND DISTRICT CONTRIBUTIONS TEACHERS' RETIREMENT SYSTEM JUNE 30, 2016 Last 10 Fiscal Years*
2016 District's proportion of the net pension liability District's proportionate share of the net pension liability State's proportionate share of the net pension liability Total net pension liability Covered‐employee payroll District's proportionate share of the net pension liability as a percentage of covered payroll Plan fiduciary net position as a percentage of the total pension liability Contractually required contribution Contributions in relation to the contractually required contribution Contribution deficiency (excess) Contributions as a percentage of covered employee payroll
0.0128375%
2015 0.0169878%
2014
2013
0.00%
2012
0.00%
2011
0.00%
2010
0.00%
2009
0.00%
2008
0.00%
2007
0.00%
0.00%
$ 8,409,883
$ 10,108,220
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
$ ‐
123,921,926 132,331,809 23,212,859
113,978,004 124,086,224 20,220,376
‐ ‐ ‐
‐ ‐ ‐
‐ ‐ ‐
‐ ‐ ‐
‐ ‐ ‐
‐ ‐ ‐
‐ ‐ ‐
‐ ‐ ‐
17.54%
16.30%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
41.50% 692,774
43.00% 464,151
0.00% ‐
0.00% ‐
0.00% ‐
0.00% ‐
0.00% ‐
0.00% ‐
0.00% ‐
0.00% ‐
(692,727) 47
(465,144) (993)
‐ ‐
‐ ‐
‐ ‐
‐ ‐
‐ ‐
‐ ‐
‐ ‐
‐ ‐
2.9842%
2.3004%
0.0000%
0.0000%
0.0000%
0.0000%
0.0000%
0.0000%
0.0000%
0.0000%
Notes to Schedule: Amounts reported in 2015 reflect an investment rate of return of 7.5 percent, an inflation rate of 3.0 percent and real return of 4.5 percent, and a salary increases that vary by service credit. In 2014, assumptions used were an investment rate of return of 7.5 percent, an inflation rate of 3.0 percent and real return of 4.5 percent, and salary increases of 5.75 percent. *Information is presented for those years for which it was available
35x
Page 36
Page 36
A
B
C
D
E
F
DEFICIT ANNUAL FINANCIAL REPORT (AFR) SUMMARY INFORMATION New Provisions in the School Code, Section 17-1 (105 ILCS 5/17-1)
1
2
3
Instructions: If the Annual Financial Report (AFR) reflects that a "deficit reduction plan" is required as calculated below, then the school district is to complete the "deficit reduction plan" in the annual budget and submit the plan to Illinois State Board of Education (ISBE) within 30 days after accepting the audit report. This may require the FY2017 annual budget to be amended to include a "deficit reduction plan" and narrative. The "deficit reduction plan" is developed using ISBE guidelines and format in the School District Budget Form 50-36. A plan is required when the operating funds listed below result in direct revenues (line 7) being less than direct expenditures (line 8) by an amount equal to or greater than one-third (1/3) of the ending fund balance (line 10). That is, if the ending fund balance is less than three times the deficit spending, the district must adopt and submit an original budget/amended budget with ISBE that provides a "deficit reduction plan" to balance the shortfall within the next three years.
DEFICIT AFR SUMMARY INFORMATION - Operating Funds Only (All AFR pages must be completed to generate the following calculation)
4 Description
5 6 Direct Revenues 7 Direct Expenditures 8 Difference 9 Fund Balance - June 30, 2016
EDUCATIONAL FUND (10)
41,861,207 41,434,242 426,965 8,006,114
OPERATIONS & MAINTENANCE FUND (20)
TRANSPORTATION FUND (40)
4,777,491
3,343,588
6,193,365
3,908,337
(1,415,874)
(564,749)
1,841,356
852,630
WORKING CASH FUND (70)
131,524
TOTAL
50,113,810 51,535,944
131,524 2,163,760
(1,422,134) 12,863,860
10 11 12 13
Unbalanced - however, a deficit reduction plan is not required at this time.
Page 36
Page 36
Audit Checklist All entries must balance within the individual fund statements and schedules as instructed below. Any error messages left unresolved below, will be returned to the school district/joint agreement. 1. The auditor's Opinion and Notes to the Financial Statements are embedded in the "Opinion-Notes 34" tab. 2. Student Activity Funds, Convenience Accounts, and other agency funds are included, if applicable. 3. All audit questions on page 2 are answered appropriatly by checking all that apply. This page must also be certified with the signature of the CPA firm. Comments and explanations are included for all checked items at the bottom of page 2. 4. All Other accounts and functions labeled "(describe & itemize) are properly noted on the "Itemization 32" tab. 5. In all funds, Function No. 2900 does not include Worker's Compensation or Unemployment Insurance. 6. Tuition paid to another school district or to a joint agreement (in state) is coded to Function 4200, and Other Objects (600). 7. Business Manager/Bookkeeper Costs are charged to the proper Function (No. 2510/2520). 8. If district is subject to PTELL on tab "Aud Quest 2", line 21 be sure to check the box and enter the effective date. 9. All entries were entered to the nearest whole dollar amount.
Balancing Schedule Check this Section for Error Messages The following assures that various entries are in balance. Any out of balance condition is followed by an error message in RED and must be resolved before submitting to ISBE. One or more errors detected may cause this AFR to be returned for corrections and resubmission. If impossible for entries to balance please explain on the itemization page. Description: 1. Cover Page: The Accounting Basis must be Cash or Accrual. 2. The Single Audit related documents must be completed and attached. What Basis of Accounting is used? Accounting for late payments (Audit Questionnaire Section D) Are Federal Expenditures greater than $750,000? Is all Single Audit information completed and enclosed? Is Budget Deficit Reduction Plan Required? 3. Page 3: Financial Information must be completed. Section A: Tax rates are not entered in the following format: [1.50 should be .0150]. Please enter with the correct decimal point. Section D: Check a or b that agrees with the school district type. 4. Page 5: Cells C4:L4 Acct 111-115 - Cash Balances cannot be negative. Fund (10) ED: Cash balances cannot be negative. Fund (20) O&M: Cash balances cannot be negative. Fund (30) DS: Cash balances cannot be negative. Fund (40) TR: Cash balances cannot be negative. Fund (50) MR/SS: Cash balances cannot be negative. Fund (60) CP: Cash balances cannot be negative. Fund (70) WC: Cash balances cannot be negative. Fund (80) Tort: Cash balances cannot be negative. Fund (90) FP&S: Cash balances cannot be negative. 5. Page 5 & 6: Total Current & Capital Assets must = Total Liabilities & Fund Balance. Fund 10, Cell C13 must = Cell C41. Fund 20, Cell D13 must = Cell D41. Fund 30, Cell E13 must = Cell E41. Fund 40, Cell F13 must = Cell F41. Fund 50, Cell G13 must = Cell G41. Fund 60, Cell H13 must = Cell H41. Fund 70, Cell I13 must = Cell I41. Fund 80, Cell J13 must = Cell J41. Fund 90, Cell K13 must = Cell K41. Agency Fund, Cell L13 must = Cell L41. General Fixed Assets, Cell M23 must = Cell M41. General Long-Term Debt, Cell N23 must = Cell N41. 6. Page 5: Sum of Reserved & Unreserved Fund Balance must = Page 8, Ending Fund Balance. Fund 10, Cells C38+C39 must = Cell C81. Fund 20, Cells D38+D39 must = Cell D81. Fund 30, Cells E38+E39 must = Cell E81 Fund 40, Cells F38+F39 must = Cell F81. Fund 50, Cells G38+G39 must = Cell G81. Fund 60, Cells H38+H39 must = Cell H81. Fund 70, Cells I38+I39 must = Cell I81. Fund 80, Cells J38+J39 must = Cell J81. Fund 90, Cells K38+K39 must = Cell K81. 8. Page 25: Schedule of Bonds Payable must = Pages 5, 8 & 18: Basic Financial Statements. Note: Explain any unreconcilable differences in the Itemization sheet. Total Long-Term Debt Issued (P25, Cell F49) must = Principal on Long-Term Debt Sold (P8, Cells C33:F33, H33:K33). Total Long-Term Debt (Principal) Retired (P18, Cells H163) must = Debt Service - Long-Term Debt (Principal) Retired (P25, Cells H49). 9. Page 7 & 8: Other Sources of Funds (L 24:42) must = Other Uses of Funds (P8, L46:59). Acct 7130 - Transfer Among Funds, Cells C27:K27 must = Acct 8130 Transfer Among Funds, Cells C49:K49 Acct 7140 - Transfer of Interest, Cells C28:K28 must = Acct 8140 Transfer of Interest, Cells C50:K50. Acct 7900 - ISBE Loan Proceeds (Cells C42:K42) must = Acct 8910 - Transfers to Debt Service Fund to Pay Principal on ISBE Loans (Cells C74:K74) 10. Restricted Local Tax Levies Page 26, Line 25 must = Reserved Fund Balance, Pages 5 & 6, Line 38.
11. 12. 13. 14.
Reserved Fund Balance, Page 5, Cells C38:H38 must be => Reserve Fund Balance Cell G25:K25. Unreserved Fund Balance, Page 5, Cells C39:H39 must be > 0 Page 5: "On behalf" payments to the Educational Fund Fund (10) ED: Account 3998 must be entered Page 28: The 9 Month ADA must be entered on Line 77. Page 32: LIMITATION OF ADMINISTRATIVE COST, Budget Information must be completed and submitted to ISBE. Page 31: SHARED OUTSOURCED SERVICES, Completed.
School No: afr-16-form 206 v1.xlsm
Error Message
CASH OK OK OK Deficit reduction plan is not required. OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK
OK ERROR!
OK OK OK
OK OK OK OK OK OK
Page 37
Page 37
ANNUAL FEDERAL FINANCIAL COMPLIANCE REPORT (COVER SHEET) DISTRICT/JOINT AGREEMENT Year Ending June 30, 2016
DISTRICT/JOINT AGREEMENT NAME
RCDT NUMBER
Bloom High School District 206
CPA FIRM 9-DIGIT STATE REGISTRATION NUMBER
07-016-2060-17
ADMINISTRATIVE AGENT IF JOINT AGREEMENT (as applicable)
65025792 NAME AND ADDRESS OF AUDIT FIRM
GW & Associates, P.C 2617 Chicago Road So. Chicago Heights
ADDRESS OF AUDITED ENTITY
IL
60411
(Street and/or P.O. Box, City, State, Zip Code) E-MAIL ADDRESS:
100 W. 10th Street Chicago Heights, IL IL 60411
[email protected]
NAME OF AUDIT SUPERVISOR
John Wysocki CPA FIRM TELEPHONE NUMBER
(708)755-8182
FAX NUMBER
(708)755-8326
THE FOLLOWING INFORMATION MUST BE INCLUDED IN THE SINGLE AUDIT REPORT: A copy of the CPA firm's most recent peer review report and acceptance letter has been submitted to ISBE (either with the audit or under separate cover). Financial Statements including footnotes Title 2 CFR §200.510 (a) Schedule of Expenditures of Federal Awards including footnotes Title 2 CFR §200.510 (b) Independent Auditor's Report Title 2 CFR §200.515 (a) Independent Auditor's Report on Compliance and on Internal Control Over Financial Reporting Based on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards Title 2 CFR §200.515 (b) Independent Auditor's Report on Compliance with Requirements Applicable to each Major Program and Internal Control over Compliance Title 2 CFR §200.515 (c ) Schedule of Findings and Questioned Costs Title 2 CFR §200.515 (d) (1) - (3) Summary Schedule of Prior Year Audit Findings Title 2 CFR §200.511 (b) Corrective Action Plan Title 2 CFR §200.511 (c)
THE FOLLOWING INFORMATION IS HIGHLY RECOMMENDED TO BE INCLUDED: Copy of Federal Data Collection Form Title 2 CFR §200.512 (b) Copy(ies) of Management Letter(s)
GW & ASSOCIATES, P.C. CERTIFIED PUBLIC ACCOUNTANTS
2617 Chicago Road South Chicago Heights, IL 60411
Phone (708) 755-8182 Fax (708) 755-8326
INDEPENDENT AUDITOR’S REPORT ON COMPLIANCE FOR EACH MAJOR PROGRAM AND ON INTERNAL CONTROL OVER COMPLIANCE REQUIRED BY THE UNIFORM GUIDANCE To the Board of Education Bloom Township High School District 206 Report on Compliance for Each Major Federal Program We have audited Bloom Township High School District 206’s compliance with the types of compliance requirements described in the OMB Compliance Supplement that could have direct and material effect on each of Bloom Township High School District 206’s major federal programs for the year ended June 30, 2016. Bloom Township High School District 206’s major federal programs are identified in the summary of auditor’s results section of the accompanying schedule of findings and questioned costs. Management’s Responsibility Management is responsible for compliance with the requirements of federal statutes, regulations, and the terms and conditions of its federal awards applicable to its federal programs. Auditor’s Responsibility Our responsibility is to express an opinion on compliance for each of Bloom Township High School District 206’s major federal programs based on our audit of the types of compliance requirements referred to above. We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America; the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States; and the audit requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Those standards and the Uniform Guidance require that we plan and perform the audit to obtain reasonable assurance about whether noncompliance with the types of compliance requirements referred to above that could have a direct and material effect on a major federal program occurred. An audit includes examining, on a test basis, evidence about Bloom Township High School District 206’s compliance with those requirements and performing such other procedures as we considered necessary in the circumstances. We believe that our audit provides a reasonable basis for our opinion on compliance for each major federal program. However, our audit does not provide a legal determination of Bloom Township High School District 206’s compliance. Basis for Qualified Opinion on Title I Low Income As described in the accompanying schedule of findings and questioned costs, Bloom Township High School District 206 did not comply with requirements regarding CFDA 84.010A Title I – Low Income as described in finding number 2016-004 for Allowable Costs/Cost Principles, Cash Management, and Reporting. Compliance with such requirements is necessary, in our opinion, for Bloom Township High School District 206 to comply with the requirements applicable to that program. Qualified Opinion on Title I Low Income In our opinion, except for the noncompliance described in the Basis for Qualified Opinion paragraph, Bloom Township High School District 206 complied, in all material respects, with the types of compliance requirements referred to above that could have a direct and material effect on Title I Low Income for the year ended June 30, 2016.
Unmodified Opinion on Each of the Other Major Federal Programs In our opinion, Bloom Township High School District 206 complied, in all material respects, with the types of compliance requirements referred to above that could have a direct and material effect on each of its other major federal programs identified in the summary of auditor’s results section of the accompanying schedule of findings and questioned costs for the year ended June 30, 2016. Other Matters Bloom Township High School District 206’s response to the noncompliance findings identified in our audit is described in the accompanying schedule of findings and questioned costs. Bloom Township High School District 206’s response was not subjected to the auditing procedures applied in the audit of compliance and, accordingly, we express no opinion on the response. Report on Internal Control over Compliance Management of the Bloom Township High School District 206, is responsible for establishing and maintaining effective internal control over compliance with the types of compliance requirements referred to above. In planning and performing our audit of compliance, we considered the Bloom Township High School District 206’s internal control over compliance with the types of requirements that could have a direct and material effect on each major federal program to determine the auditing procedures that are appropriate in the circumstances for the purpose of expressing an opinion on compliance for each major federal program and to test and report on internal control over compliance in accordance with the Uniform Guidance, but not for the purpose of expressing an opinion on the effectiveness of internal control over compliance. Accordingly, we do not express an opinion on the effectiveness of the Bloom Township High School District 206’s internal control over compliance. Our consideration of internal control over compliance was for the limited purpose described in the preceding paragraph and was not designed to identify all deficiencies in internal control over compliance that might be material weaknesses or significant deficiencies and therefore, material weaknesses or significant deficiencies may exist that were not identified. However, as discussed below, we identified certain deficiencies in internal control over compliance that we consider to be material weaknesses and significant deficiencies. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. A material weakness in internal control over compliance is a deficiency, or combination of deficiencies, in internal control over compliance, such that there is a reasonable possibility that material noncompliance with a type of compliance requirement of a federal program will not be prevented, or detected and corrected, on a timely basis. We consider the deficiencies in internal control over compliance described in the accompanying schedule of findings and questioned costs as items 2016-004 to be material weaknesses. A significant deficiency in internal control over compliance is a deficiency, or a combination of deficiencies, in internal control over compliance with a type of compliance requirement of a federal program that is less severe than a material weakness in internal control over compliance, yet important enough to merit attention by those charged with governance. We consider the deficiencies in internal control over compliance described in the accompanying schedule of findings and questioned costs as items 2016-005 to be significant deficiencies. Bloom Township High School District 206’s response to the internal control over compliance findings identified in our audit is described in the accompanying schedule of findings and questioned costs. Bloom Township High School District 206’s response was not subjected to the auditing procedures applied in the audit of compliance and, accordingly, we express no opinion on the response. The purpose of this report on internal control over compliance is solely to describe the scope of our testing of internal control over compliance and the results of that testing based on the requirements of the Uniform Guidance. Accordingly, this report is not suitable for any other purpose.
South Chicago Heights, Illinois December 20, 2016
Page 38
Page 38
Bloom High School District 206 07-016-2060-17 SINGLE AUDIT INFORMATION CHECKLIST The following checklist is OPTIONAL; it is not a required form for completion of Single Audit information. The purpose of the checklist is to assist in determining if appropriate information has been correctly completed within the Annual Financial Report (AFR). This is not a complete listing of all Single Audit requirements, but highlights some of the more common errors found during ISBE reviews. GENERAL INFORMATION 1. Signed copies of audit opinion letters have been included with audit package submitted to ISBE. 2. All opinion letters use the most current audit language and formatting as mandated in SAS 115/SAS 117 and other pronouncements. 3. ALL Single Audit forms within the AFR Excel workbook have been completed, where appropriate. - For those forms that are not applicable, "N/A" or similar language has been indicated. 4. ALL Federal revenues reported in FRIS Report 0053 (Summary of Payments) are accounted for in the Schedule of Expenditures of Federal Awards (SEFA). Programs funded through ARRA are identified separately in SEFA 5. Federal revenues reported on the AFR reconcile to Federal revenues reported on the SEFA. - Verify or reconcile on reconciliation worksheet. 6. The total value of non-cash COMMODITIES has been included within the AFR on the INDIRECT COSTS page (ICR Computation 30) on Line 11. It should not be included in the Statement of Revenues Received (REVENUES 9-14) within the AFR Accounts 4210 - 4299. Those accounts are specific cash programs, not non-cash assistance such as COMMODITIES. 7. Complete audit package (Data Collection Form, audit reports, etc.) has been submitted electronically to the Federal Audit Clearinghouse in Jeffersonville, Indiana. SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS 8. Programs funded through ARRA (Federal Stimulus funds) are identified separately from "regular" Federal programs - Program name includes "ARRA - " prefix - Correct ARRA CFDA and ISBE program numbers are listed 9. All prior year's projects are included and reconciled to final FRIS report amounts. - Including reciept/revenue and expenditure/disbursement amounts. 10. All current year's projects are included and reconciled to most recent FRIS report filed. - Including revenue and expenditure/disbursement amounts. 11. Differences in reported spending amounts on the SEFA and the final FRIS reports should be detailed and/or documented in a finding, with discrepancies reported as Questioned Costs. 12. Prior-year and Current-year Child Nutrition Programs (CNP) are included on the SEFA (with prior-year program showing total cash received): Project year runs from October 1 to September 30, so projects will cross fiscal year; This means that audited year revenues will include funds from both the prior year and current year projects. 13. 14. 15. 16. 17.
Each CNP project should be reported on separate line (one line per project year per program). Total CNP Revenue amounts are consistent with grant amounts awarded by ISBE for each program by project year. Total CNP Expenditure amounts are consistent with grant amounts awarded by ISBE for each program by project year. Exceptions should result in a finding with Questioned Costs. The total value of non-cash COMMODITIES has been reported on the SEFA (CFDA 10.555). - The value is determined from the following, with each item on a separate line: * Non-Cash Commodities: Monthly Commodities Bulletin for April (From the Illinois Commodities System accessed through ISBE web site) Total commodities = A PAL Allocated + B PAL Allocated + Processing Deductions + Total Bonus Allocated Verify Non-Cash Commodities amount on ISBE web site: http://www.isbe.net/business.htm. * Non-Cash Commodities: Commodities information for non-cash items received through Other Food Services Districts should track separately through year; no specific report available from ISBE Verify Non-Cash Commodities amount through Other Food Services on ISBE web site: http://www.isbe.net/business.htm. * Department of Defense Fresh Fruits and Vegetables (District should track through year) - The two commodity programs should be reported on separate lines on the SEFA. Verify Non-Cash Commodities amount through DoD Fresh Fruits and Vegetables on ISBE web site: http://www.isbe.net/business.htm. * Amounts verified for Fresh Fruits and Vegetables cash grant program (ISBE code 4240) CFDA number: 10.582
18. 19. 20. 21. 22. 23.
TOTALS have been calculated for Federal revenue and expenditure amounts (Column totals). Obligations and Encumbrances are included where appropriate. FINAL STATUS amounts are calculated, where appropriate. Medicaid Fee-for-Service funds, E-Rate reimbursements and Build America Bond interest subsidies have not been included on the SEFA. All programs tested (not just Type A programs) are indicated by either an * or (M) on the SEFA. NOTES TO THE SEFA within the AFR Excel workbook (SEFA NOTES) have been completed. Including, but not limited to: Basis of Accounting Name of Entity Type of Financial Statements Subrecipient information (Mark "N/A" if not applicable) * ARRA funds are listed separately from "regular" Federal awards
24. 25. 26. 27.
SUMMARY OF AUDITOR RESULTS/FINDINGS/CORRECTIVE ACTION PLAN 28. 29. 30. 31.
Audit opinions expressed in opinion letters match opinions reported in Summary. All Summary of Auditor Results questions have been answered. All tested programs are listed. Correct testing threshold has been entered. Title 2 CFR §200.518
Findings have been filled out completely and correctly (if none, mark "N/A"). 32. 32. 33. 34. 35. 36. 37.
38.
Financial Statement and/or Federal Awards Findings information has been completely filled out for each finding, with finding numbers in correct format. Finding completed for each Significant Deficiency and for each Material Weakness noted in opinion letters. Separate finding for each Federal program (i.e., don't report same finding for multiple programs on one sheet). Separate finding sheet for each finding on programs (e.g., excess interest earned and unallowable expenditures are two findings and should be reported separately, even if both are on same program). Questioned Costs have been calculated where there are questioned costs. Questioned Costs are separated by project year and by program (and sub-project, if necessary). Questioned Costs have been calculated for Interest Earned on Excess Cash on Hand. - Should be based on actual amount of interest earned - Questioned Cost amounts are broken out between programs if multiple programs are listed on the finding A CORRECTIVE ACTION PLAN has been completed for each finding. - Including Finding number, action plan details, projected date of completion, name and title of contact person
Page 39
Page 39
Bloom High School District 206 07-016-2060-17 RECONCILIATION OF FEDERAL REVENUES
Annual Financial Report to Schedule of Expenditures of Federal Awards TOTAL FEDERAL REVENUE IN AFR
Account Summary 7-8, Line 7 Flow-through Federal Revenues Revenues 9-14, Line 112 Value of Commodities Indirect Cost Info 30, Line 11 Less: Medicaid Fee-for-Service Revenues 9-14, Line 271
Account 4000
$
Account 2200
8,549,832 95,195
Account 4992
(544,137) $
AFR TOTAL FEDERAL REVENUES:
8,100,890
ADJUSTMENTS TO AFR FEDERAL REVENUE AMOUNTS:
Reason for Adjustment: Commodities included in the Account 4000 line above
$
ADJUSTED AFR FEDERAL REVENUES
$
8,005,695
Total Current Year Federal Revenues Reported on SEFA: Federal Revenues Column D
$
8,005,695
ADJUSTED SEFA FEDERAL REVENUE:
$
8,005,695
DIFFERENCE:
$
-
(95,195)
Adjustments to SEFA Federal Revenues:
Reason for Adjustment:
Page 40
Page 40
Bloom High School District 206 07-016-2060-17 SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Year Ending June 30, 2016 ISBE Project # Federal Grantor/Pass-Through Grantor/Subrecipients * Program or Cluster Title and Major Program Designation
CFDA
Expenditure/Disbursements4
Receipts/Revenues
(1st 8 digits)
Year
Year
Year
Year
Obligations/
Final
Budget
Number (A)
or Contract #3 (B)
7/1/14-6/30/15 (C)
7/1/15-6/30/16 (D)
7/1/14-6/30/15 (E)
7/1/15-6/30/16 (F)
Encumb. (G)
Status (H)
(I)
84.215E
S215E150569
-
163,256
-
205,916
-
205,916
360,588
84.360
S360A100178
1,213,678
389,901
1,129,319
389,901
-
1,519,220
1,555,803
1,213,678
553,157
1,129,319
595,817
-
1,725,136
1,916,391
2
Office of Elementary and Secondary Education, U.S. Department of Education
Positive Youth Development Program
High School Graduation Initiative Year 5 Total Office of Elementary and Secondary Education, U.S. Department of Education Office of Elementary and Secondary Education, U.S. Department of Education/ISBE
Title I - Low Income (M)
84.010A
16-4300-00
-
1,794,700
-
2,028,363
-
2,028,363
2,436,252
84.010A
15-4300-00
655,887
1,236,587
985,782
908,022
-
1,893,804
2,276,028
655,887
3,031,287
985,782
2,936,385
-
3,922,167
4,712,280
Total Title I - Low Income (M)
Title III - Immigrant Education Program (IEP)
Title III - Language Instruction Program
84.365A
16-4905-00
-
-
-
3,000
-
3,000
3,000
84.365A
16-4909-00
-
6,427
-
10,397
-
10,397
15,000
84.365A
15-4909-00
8,985
5,437
14,422
-
-
14,422
19,254
8,985
11,864
14,422
10,397
-
24,819
34,254
Total Title III - Language Instruction Program
Title II - Teacher Quality
84.367A
16-4932-00
-
111,284
-
143,250
-
143,250
169,768
84.367A
15-4932-00
91,518
172,542
213,428
50,632
-
264,060
284,029
91,518
283,826
213,428
193,882
-
407,310
453,797
Total Title II - Teacher Quality
School Improvement Grant
84.377
16-4339-00
-
768,444
-
1,488,642
253,000
1,741,642
2,057,625
84.377
15-4339-00
854,562
1,096,456
1,285,279
559,146
-
1,844,425
1,951,020
854,562
1,864,900
1,285,279
2,047,788
253,000
3,586,067
4,008,645
Page 40
Page 40
Total Office of Elementary and Secondary Education, U.S. Department of Education/ISBE
1,610,952
5,191,877
2,498,911
5,191,452
253,000
7,943,363
9,211,976
Food and Nutrition Service U.S. Department of Agriculture/ISBE National School Lunch Program (M)
10.555
16-4210-00
-
817,541
-
817,541
-
817,541
N/A
10.555
15-4210-00
794,062
225,041
794,062
225,041
-
1,019,103
N/A
794,062
1,042,582
794,062
1,042,582
-
1,836,644
N/A
Total National School Lunch Program (M)
School Breakfast Program (M)
10.553
16-4220-00
-
106,202
-
106,202
-
106,202
N/A
10.553
15-4220-00
115,701
27,570
115,701
27,560
-
143,261
N/A
115,701
133,772
115,701
133,762
-
249,463
N/A
Total School Breakfast Program (M)
National School Lunch Program - Commodities (M) 2016
10.555
N/A
-
82,571
-
82,571
-
82,571
N/A
2015
10.555
N/A
75,314
-
75,314
-
-
75,314
N/A
75,314
82,571
75,314
82,571
-
157,885
N/A
985,077
1,258,925
985,077
1,258,915
-
2,243,992
N/A
2,596,029
6,450,802
3,483,988
6,450,367
253,000
10,187,355
N/A
Total National School Lunch Program - Commodities (M)
Total Food and Nutrition Service U.S. Department of Agriculture/ISBE
Total ISBE Funding
Office of Elementary and Secondary Education, U.S. Department of Education/ISBE/South Cook Intermediate Service Center 4 Food and Nutrition Service, Department of Agriculture/Department of Defense Commodities - Fruits and Vegetables (M) FY 2016
10.555
N/A
-
12,624
-
12,624
-
12,624
N/A
FY 2015
10.555
N/A
16,490
-
16,490
-
-
16,490
N/A
16,490
12,624
16,490
12,624
-
29,114
N/A
Total Commodities - Fruits and Vegetables
Office of Special Education and Rehabilitative Service, U.S. Department of Education/ISBE/SPEED
IDEA Part B Flow Through (M)
84.027
16-4620-00
-
459,510
-
820,008
-
820,008
1,149,639
84.027
15-4620-00
339,341
189,981
644,758
-
-
644,758
1,068,267
339,341
649,491
644,758
820,008
-
1,464,766
2,217,906
-
216,286
-
216,286
-
216,286
216,622
Total Office of Special Education and Rehabilitative Service, U.S. Department of Education/ISBE/SPEED Office of Assistant Secretary for Vocational and Adult Education, U.S. Department of Education/Career Preparation Network Vocational Ed. - Carl Perkins FY2016
84.048A
N/A
Page 40 FY2015
Page 40
84.048A
N/A
Total Office of Assistant Secretary for Vocational and Adult Education, U.S. Department of Education/Career Preparation
157,857
51,635
197,744
11,748
-
209,492
209,492
157,857
267,921
197,744
228,034
-
425,778
426,114
U.S. Department of Health and Human Services/Illinois Department of Healthcare and Family Services Medicaid Matching - Admin Outreach FY2016
93.778
N/A
-
71,700
-
71,700
-
71,700
N/A
FY2015
93.778
N/A
70,735
-
70,735
-
-
70,735
N/A
70,735
71,700
70,735
71,700
-
142,435
N/A
12,988
-
11,788
-
-
11,788
N/A
4,407,118
8,005,695
5,554,822
8,178,550
253,000
13,986,372
Total U.S. Department of Health and Human Services/Illinois Department of Healthcare and Family Services Office of Elementary and Secondary Education, U.S. Department of Education/Governors State Univ. ARRA, Teacher Quality Partnership Grant FY2015 Total Office of Elementary and Secondary Education, U.S. Department of Education/Governors State Univ.
84.405A
Total Federal Assistance
N/A
• (M) Program was audited as a major program as defined by §200.518. * NEW - Also include the total amount provided to subrecipients from each Federal program. §200.510 (b)(4). The accompanying notes are an integral part of this schedule. 1
2
To meet state or other requirements, auditees may decide to include certain nonfederal awards (for example, state awards) in this schedule. If such nonfederal data are presented, they should be segregated and clearly designated as nonfederal. The title of the schedule should also be modified to indicate that nonfederal awards are included. When the CFDA number is not available, the auditee should indicate that the CFDA number is not available and include in the schedule the program's name and, if applicable, other identifying number.
3
When awards are received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included in the schedule. §200.510 (b)(2)
4
The Uniform Guidance requires that the value of federal awards expended in the form of non-cash assistance, the amount of insurance in effect during the year, and loans or loan guarantees outstanding at year end be included in either the schedule or a note to the schedule. Although it is not required, the Uniform Guidance states that it is preferable to present this information in the schedule (versus the notes to the schedule). If the auditee presents non-cash assistance in the notes to the schedule, the auditor should be aware that such amounts must still be included in part III of the data collection form.
Page 41
Page 41
Bloom High School District 206 07-016-2060-17 NOTES TO THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (SEFA) Year Ending June 30, 2016 5
Note 1: Basis of Presentation The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Bloom High School District 206 and is presented on the modified cash basis of accounting. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements.
Note 2: Indirect Facilities & Administration costs
6
Auditee elected to use 10% de minimis cost rate?
YES
Note 3: Subrecipients 7 Of the federal expenditures presented in the schedule, Bloom High School District 206 provided federal awards to subrecipients as follows:
Program Title/Subrecipient Name
Federal CFDA Number
Amount Provided to Subrecipients
None
Note 4: Non-Cash Assistance The following amounts were expended in the form of non-cash assistance by Bloom High School District 206 and are included in the Schedule of Expenditures of Federal Awards: NON-CASH COMMODITIES (CFDA 10.555)**: $95,195 OTHER NON-CASH ASSISTANCE $0 Note 5: Other Information Insurance coverage in effect paid with Federal funds during the fiscal year: Property $0 Auto $0 General Liability $0 Workers Compensation $0 Loans/Loan Guarantees Outstanding at June 30: $0 District had Federal grants requiring matching expenditures No (Yes/No) ** The amount reported here should match the value reported for non-cash Commodities on the Indirect Cost Rate Computation page. 5
6
7
This note is included to meet the Uniform Guidance requirement that the schedule include notes that describe the significant accounting policies used in preparing the schedule. The Uniform Guidance requires the Schedule of Expenditures of Federal Awards to note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. §200.510 (b)(6) The Uniform Guidance requires the Schedule of Expenditures of Federal Awards to include, to the extent practical, an identification of the total amount provided to subrecipients, from each federal program. Although this example includes the required subrecipient information in the notes to the schedule, the information may be included on the face of the schedule as a separate column or section, if that is preferred by the auditee. §200.510 (b)(2)
X
NO
Page 42
Page 42
Bloom High School District 206 07-016-2060-17 SCHEDULE OF FINDINGS AND QUESTIONED COSTS Year Ending June 30, 2016 SECTION I - SUMMARY OF AUDITOR'S RESULTS
FINANCIAL STATEMENTS
Adverse
Type of auditor's report issued:
(Unmodified, Qualified, Adverse, Disclaimer) INTERNAL CONTROL OVER FINANCIAL REPORTING: • Material weakness(es) identified?
x
YES
None Reported
• Significant Deficiency(s) identified that are not considered to
x
YES
None Reported
be material weakness(es)? • Noncompliance noted?
YES
x
NO
FEDERAL AWARDS INTERNAL CONTROL OVER MAJOR PROGRAMS: • Material weakness(es) identified?
x
YES
None Reported
• Significant Deficiency(s) identified that are not considered to
x
YES
None Reported
be material weakness(es)?
Qualified
Type of auditor's report issued on compliance for major programs:
(Unmodified, Qualified, Adverse, Disclaimer7) Any audit findings disclosed that are required to be reported in
x
accordance with §200.516 (a)?
YES
NO
IDENTIFICATION OF MAJOR PROGRAMS:8 CFDA NUMBER(S)9 10.555, 10.553 84.010A 84.027
NAME OF FEDERAL PROGRAM or CLUSTER10 Child Nutrition Cluster Title I - Low Income IDEA Part B Flow Through
Dollar threshold used to distinguish between Type A and Type B programs: Auditee qualified as low-risk auditee? 7
8 9 10
$750,000.00 YES
x
NO
If the audit report for one or more major programs is other than unmodified, indicate the type of report issued for each program. Example: "Unmodified for all major programs except for [name of program], which was modified and [name of program], which was a disclaimer." Major programs should generally be reported in the same order as they appear on the SEFA. When the CFDA number is not available, include other identifying number, if applicable. The name of the federal program or cluster should be the same as that listed in the SEFA. For clusters, auditors are only required to list the name of the cluster.
Page 43
Page 43
Bloom High School District 206 07-016-2060-17 SCHEDULE OF FINDINGS AND QUESTIONED COSTS Year Ending June 30, 2016
SECTION II - FINANCIAL STATEMENT FINDINGS 1. FINDING NUMBER:11
2016- 001
2. THIS FINDING IS:
New
X
Repeat from Prior Year?
Year originally reported?
2007
3. Criteria or specific requirement
Professional standards indicate that depending on the financial statements prepared for the organization, including footnote disclosures, and knowledge of organization personnel, the inability of the organization to prepare financial statements and footnote disclosures in accordance with the basis of accounting used by the organization would be a control deficiency that normally would be considered a significant deficiency or material weakness. 4. Condition
While select District management personnel fully understand the District's financial statements and related footnotes, they do not necessarily stay current with all new accounting pronouncements that could impact the District's financial statement reporting. As a result, District personnel are not able to prepare financial statements complete with all footnote disclosures. 5. Context12
None
6. Effect
The potential effect of this control deficiency is that a misstatement or omission in the financial statements would not be prevented, detected or corrected on a timely basis.
7. Cause
None
8. Recommendation
We recommend that management evaluate the situation. Management should consider the cost in time and hard dollars of requiring employees with financial statement responsibility to remain current with all applicable accounting pronouncements. 9. Management's response13
Management believes it would not be cost beneficial for the District to hire another employee or service provider to prepare the District's financial statements or train current employees to be able to do so. Management believes it is in the best interest of the District to continue to retain the auditing firm to prepare its financial statements in conjunction with the year end audit. For ISBE Review Date:
Resolution Criteria Code Number
Initials:
Disposition of Questioned Costs Code Letter
11
A suggested format for assigning reference numbers is to use the digits of the fiscal year being audited followed by a numeric sequence of findings. For example, findings identified and reported in the audit of fiscal year 2016 would be assigned a reference number of 2016-001, 2016-002, etc. The sheet is formatted so that only the number need be entered (1, 2, etc.). 12 Provide sufficient information for judging the prevalence and consequences of the finding, such as relation to universe of costs and/or number of items examined and quantification of audit findings in dollars. 13 See §200.521 Management decision for additional guidance on reporting management's response.
Bloom High School District 206 07-016-2060-17 SCHEDULE OF FINDINGS AND QUESTIONED COSTS Year Ending June 30, 2016
SECTION II - FINANCIAL STATEMENT FINDINGS 1. FINDING NUMBER:11
2016- 002
2. THIS FINDING IS:
New
X
Repeat from Prior Year?
Year originally reported?
2015
3. Criteria or specific requirement
Best practices indicate that manual adjusting journal entries are to be accompanied by appropriate supporting documentation.
4. Condition
While reviewing a sample of 10 adjusting journal entries, it was noted that 6 adjusting journal entries did not appear to have a signature present to signify that a secondary review was performed. Additionally, it was a manual journal entry that led to the reclassification of $84,716 in Title I expenditures that were reported to ISBE in both project year 2015 and 2016. This double reporting led ISBE to reimburse the same expenditures twice. This particular entry was one of the 6 that did not have evidence of review. 5. Context12
The entries selected were primarily for reclassifications between mainly grant accounts that could lead to erroneous reporting to granting agencies and potential duplicate reimbursements.
6. Effect
Adjusting journal entries without a proper secondary review could lead to erroneous financial and grant reporting.
7. Cause
Adjusting journal entries were not consistently signed off as reviewed by a secondary employee.
8. Recommendation
We recommend that the District review the adjusting journal entry process to ensure that recorded entries are reviewed and that such a review is documented with a signature by the reviewing party.
9. Management's response13
In addition to maintaining adequate backup for adjusting journal entries (as corrected per the 2015 audit), personnel will provide backup which consistently demonstrates that a secondary review of an entry has taken place and that such review is documented with a signature of the reviewing party. For ISBE Review Date:
Resolution Criteria Code Number
Initials:
Disposition of Questioned Costs Code Letter
11
A suggested format for assigning reference numbers is to use the digits of the fiscal year being audited followed by a numeric sequence of findings. For example, findings identified and reported in the audit of fiscal year 2016 would be assigned a reference number of 2016-001, 2016-002, etc. The sheet is formatted so that only the number need be entered (1, 2, etc.). 12 Provide sufficient information for judging the prevalence and consequences of the finding, such as relation to universe of costs and/or number of items examined and quantification of audit findings in dollars. 13 See §200.521 Management decision for additional guidance on reporting management's response.
Bloom High School District 206 07-016-2060-17 SCHEDULE OF FINDINGS AND QUESTIONED COSTS Year Ending June 30, 2016
SECTION II - FINANCIAL STATEMENT FINDINGS
1. FINDING NUMBER:
11
2016- 003
2. THIS FINDING IS:
New
X
Repeat from Prior Year?
Year originally reported?
2015
3. Criteria or specific requirement
Uniform Guidance indicates that management is responsible for preparing the Schedule of Expenditures of Federal Awards ("SEFA") to detail all federal revenues received and associated expenses paid during the fiscal year. The inability to do so would be considered a control deficiency that would be considered a material weakness. 4. Condition
While the District has set up separate accounts for revenues and expenditures for each federal program, the District's accounting for grant expenditures does not easily reconcile between the general ledger and reports submitted to funding agencies. Additionally, the District did not prepare a SEFA.
5. Context12
In some instances, grants could not be easily reconciled between the general ledger and reports submitted to funding agencies.
6. Effect
Since the auditors prepare the SEFA on behalf of the District, the risk is higher that a program could be omitted from the schedule or amounts associated with various programs could be misstated. Additionally, with the lack of reconciliation between certain grant related general ledger accounts to the reports submitted to funding agencies, the District may put itself in a position where it is either requesting reimbursement for activity that should not be reimbursed or is unable to submit for reimbursement for an activity that may not have been posted to the proper account. 7. Cause
None
8. Recommendation
We recommend that the District evaluate the situation and consider preparing the SEFA to ensure accurate financial reporting associated with the Federal expenditures related to grants by reconciling general ledger accounts to the reports submitted to funding agencies. 9. Management's response
13
The District shall endeavor to prepare the SEFA report associated with the Federal expenditures related to grants. The District will seek consultation and guidance from the auditor in advance of the next year's audit in order to gain competency in preparing future SEFA reports. For ISBE Review Date:
Resolution Criteria Code Number
Initials:
Disposition of Questioned Costs Code Letter
11
A suggested format for assigning reference numbers is to use the digits of the fiscal year being audited followed by a numeric sequence of findings. For example, findings identified and reported in the audit of fiscal year 2016 would be assigned a reference number of 2016-001, 2016-002, etc. The sheet is formatted so that only the number need be entered (1, 2, etc.). 12 Provide sufficient information for judging the prevalence and consequences of the finding, such as relation to universe of costs and/or number of items examined and quantification of audit findings in dollars. 13 See §200.521 Management decision for additional guidance on reporting management's response.
Page 44 Bloom High School District 206 07-016-2060-17 SCHEDULE OF FINDINGS AND QUESTIONED COSTS Year Ending June 30, 2016 SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS 1. FINDING NUMBER:14
2016- 004
2. THIS FINDING IS:
X
New
Repeat from Prior year? Year originally reported?
Title I Low Income
3. Federal Program Name and Year: 4. Project No.: 6. Passed Through: 7. Federal Agency:
15-4300-00; 16-4300-00
5. CFDA No.:
84.010A
Illinois State Board of Education Office of Elementary and Secondary Education, U.S. Department of Education/ISBE/South Cook Intermediate
8. Criteria or specific requirement (including statutory, regulatory, or other citation)
Compliance requirements: B - Allowable Costs/Cost Principles; C - Cash Management; L - Reporting - Reports filed by the District should be able to trace to the general ledger and such costs should not be reported and subsequently reimbursed more than once. 9. Condition
15
It was noted that a total of $84,716 for the Title I Low Income grant was reported and reimbursed twice - first for project year 2015 and again for project year 2016. 10. Questioned Costs16
$84,716
11. Context17
The duplicated amount was initially recorded in the general ledger for project year 2015. The total expenditure amount was reported to ISBE prior to a reclassification of costs from project year 2015 to project year 2016 which subsequently lowered the balances in the general ledger. After the reclassification, the resulting totals for project year 2016 were then reported to and reimbursed by ISBE. 12. Effect
Since the initial balances for project year 2015 were used by the District to report to ISBE prior to the reclassification, the District received reimbursement for the same expenditures twice. 13. Cause
The journal entry that reclassified the expenditures between project years did not appear to be reviewed by secondary personnel that may have caught the error or questioned why such costs needed to be reclassified and if such reclassification could have a ramification on previously reported numbers. 14. Recommendation
Prior to reclassifying costs between project years, the District should implement controls to ensure that any such costs have not been reported to granting agencies for reimbursement in order to avoid duplicate claims that may lead to questioned costs. 15. Management's response18
Grant personnel will set up an internal control for Title I, specifically 5th quarter encumbrances, to track purchase orders and payments so as to best ensure that costs associated with aged payments do not result in duplicate claims. For ISBE Review Date:
Resolution Criteria Code Number
Initials:
Disposition of Questioned Costs Code Letter
14 15 16 17 18
See footnote 11. Include facts that support the deficiency identified on the audit finding. Identify questioned costs as required by §200.516 (a)(3 - 4). See footnote 12. To the extent practical, indicate when management does not agree with the finding, questioned cost, or both.
Bloom High School District 206 07-016-2060-17 SCHEDULE OF FINDINGS AND QUESTIONED COSTS Year Ending June 30, 2016
SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS 1. FINDING NUMBER:
14
2016- 005
2. THIS FINDING IS:
X
New
Repeat from Prior year? Year originally reported?
3. Federal Program Name and Year:
Individuals with Disabilities Education Act (IDEA) 16-4620-00
4. Project No.:
5. CFDA No.:
84.027
SPEED Office of Special Education and Rehabilitative Service, U.S. Department of Education
6. Passed Through: 7. Federal Agency:
8. Criteria or specific requirement (including statutory, regulatory, or other citation)
Compliance requirement L - reporting. Controls for grant reporting are most effective when reports are reviewed and such a review uncovers potential errors. 9. Condition
15
Per GWA's review of a sample of 2 quarterly reports associated with the IDEA grant, it was noted that one of the reports included a budgeted figure as an actual amount to be reported/reimbursed.
10. Questioned Costs
16
N/A
11. Context
17
Despite evidence showing that an employee performed a secondary review of the report, the budgeted figure of $78,000 for salaries was reported to SPEED for the 3rd quarter of project year 2016. SPEED returned the report to the District so that it could be corrected and resubmitted. The District did so, avoiding erroneous reporting and reimbursement. 12. Effect
Due to an ineffective control process, the error for reporting a budgeted figure as actual was not discovered by District personnel. 13. Cause
Even though the reports for IDEA were signed off by a reviewing party, the District filed an erroneous initial third quarter report that was ultimately discovered by the pass-through entity, SPEED. Despite the fact that the error was caught and the District was given the opportunity to correct the report, it appears that controls at the District did not detect the error in the first place. 14. Recommendation
The District should put into place procedures that are aimed to ensure that reviews of reports filed with granting agencies tie-out properly to supporting documentation, such as the trial balance. Such a comparison would provide greater comfort that reports are correctly stated and will increase the probability that errors will be detected prior to submission. 15. Management's response
18
Grant personnel will work with the pass-through entity, SPEED, to put a procedure in place which allows for a "draft" version of an expenditure report aimed at detecting errors in advance of final submissions. For ISBE Review Date:
Resolution Criteria Code Number
Initials:
Disposition of Questioned Costs Code Letter
14 15 16 17 18
See footnote 11. Include facts that support the deficiency identified on the audit finding. Identify questioned costs as required by §200.516 (a)(3 - 4). See footnote 12. To the extent practical, indicate when management does not agree with the finding, questioned cost, or both.
Page 45
Page 45
Bloom High School District 206 07-016-2060-17 SUMMARY SCHEDULE OF PRIOR AUDIT FINDINGS 19 Year Ending June 30, 2016
Finding Number
Condition
Current Status
20
2015-001
The District does not currently require personnel to have the industry-specific training, knowledge and level of skill needed to prepare its financial statements.
Remains a finding. See finding 2016-001
2015-002
Based upon the sample selected, it was noted that instances existed where the Business Manager did not provide approval signatures on procurement card reports.
The District remedied this issue during fiscal year 2016. This finding will not be repeated.
2015-003
Based upon the sample selected, it was noted Remains a finding. See finding 2016-002 that instances existed where the manual entries were not accompanied by supporting documentation to support the entry that had been entered into the system.
2015-004
The District does not have a policy regarding the tracking and disposition of equipment purchased with Federal funding. Addtionally, property records maintained by the District do not consistently contain acquisition dates, cost, percentage of Federal participation, disposal dates and sale prices.
The District remedied this issue during fiscal year 2016. This finding will not be repeated.
2015-005
The District does not check sam.gov to confirm that vendors are not suspended or debarred. As a result, documentation is not maintained to signify that such a review occurred.
It appears that while sam.gov was not reviewed at the moment contracts pertaining to grants were entered into during FY 2016, GWA did note that sam.gov was reviewed in May 2016, which was after the finding from the previous year was communicated. Even though such a review should be performed in conjunction with entering into a contract, the District's review appears to signify a willingness to implement such a control. Therefore, the finding will not be repeated.
2015-006
The accounting structure maintained for revenues Remains a finding. See finding 2016-003 and expenditures for federal programs do not allow for easy reconciliation between reports submitted and the general ledger. Additionally, the District does not prepare a SEFA.
2015-007
Monthly free and reduced lunch claims lacked evidence of review and approval for the Child Nutrition Cluster.
The District began signifying review of monthly free and reduced lunch claims in December 2015. This finding will not be repeated.
Page 45
2015-008
Page 45
The District submitted reimbursement for equipment purchases to SPEED for items that were not on their approved budget for the IDEA grant.
No such transactions were noted in FY 2016. This finding will not be repeated.
When possible, all prior findings should be on the same page Explanation of this schedule - §200.511 (b) 20 Current Status should include one of the following: 19
• A statement that corrective action was taken • A description of any partial or planned corrective action • An explanation if the corrective action taken was significantly different from that previously reported or in the management decision received from the pass-through entity.
Page 46
Page 46
Bloom High School District 206 07-016-2060-17 CORRECTIVE ACTION PLAN FOR CURRENT YEAR AUDIT FINDINGS21 Year Ending June 30, 2016
Corrective Action Plan Finding No.:
2016-
001
Condition:
While select District management personnel fully understand the District's financial statements and related footnotes, they do not necessarily stay current with all new accounting pronouncements that could impact the District's financial statement reporting. As a result, District personnel are not able to prepare financial statements complete with all footnote disclosures.
Plan:
Management believes it would not be cost beneficial for the District to hire another employee or service provider to prepare the District's financial statements or train current employees to be able to do so. Management believes it is in the best interest of the District to continue to retain the auditing firm to prepare its financial statements in conjunction with the year end audit.
Anticipated Date of Completion:
6/30/2017
Name of Contact Person:
Kenneth J. Korbel
Management Response:
See Plan above.
21
Explanation of this schedule - §200.511 ( c)
Page 46
Page 46
Bloom High School District 206 07-016-2060-17 CORRECTIVE ACTION PLAN FOR CURRENT YEAR AUDIT FINDINGS21 Year Ending June 30, 2016
Corrective Action Plan Finding No.:
2016-
002
Condition:
While reviewing a sample of 10 adjusting journal entries, it was noted that 6 adjusting journal entries did not appear to have a signature present to signify that a secondary review was performed. Additionally, it was a manual journal entry that led to the reclassification of $84,716 in Title I expenditures that were reported to ISBE in both project year 2015 and 2016. This double reporting led ISBE to reimburse the same expenditures twice. This particular entry was one of the 6 that did not have evidence of review. Plan:
In addition to maintaining adequate backup for adjusting journal entries (as corrected per the 2015 audit), personnel will provide backup which consistently demonstrates that a secondary review of an entry has taken place and that such review is documented with a signature of the reviewing party.
Anticipated Date of Completion:
Immediate or 1/1/17
Name of Contact Person:
Kenneth J. Korbel
Management Response:
See Plan above.
21
Explanation of this schedule - §200.511 ( c)
Page 46
Page 46
Bloom High School District 206 07-016-2060-17 CORRECTIVE ACTION PLAN FOR CURRENT YEAR AUDIT FINDINGS21 Year Ending June 30, 2016
Corrective Action Plan Finding No.:
2016-
003
Condition:
While the District has set up separate accounts for revenues and expenditures for each federal program, the District's accounting for grant expenditures does not easily reconcile between the general ledger and reports submitted to funding agencies. Additionally, the District did not prepare a SEFA.
Plan:
The District shall endeavor to prepare the SEFA report associated with the Federal expenditures related to grants. The District will seek consultation and guidance from the auditor in advance of the next year's audit in order to gain competency in preparing future SEFA reports.
Anticipated Date of Completion:
6/30/2017
Name of Contact Person:
Kenneth J. Korbel
Management Response:
See Plan above.
21
Explanation of this schedule - §200.511 ( c)
Page 46
Page 46
Bloom High School District 206 07-016-2060-17 CORRECTIVE ACTION PLAN FOR CURRENT YEAR AUDIT FINDINGS21 Year Ending June 30, 2016
Corrective Action Plan Finding No.:
2016-
004
Condition:
It was noted that a total of $84,716 for the Title I Low Income grant was reported and reimbursed twice - first for project year 2015 and again for project year 2016.
Plan:
Grant personnel will set up an internal control for Title I, specifically 5th quarter encumbrances, to track purchase orders and payments so as to best ensure that costs associated with aged payments do not result in duplicate claims.
Anticipated Date of Completion:
Immediate or 1/1/17
Name of Contact Person:
Jennifer Norrell
Management Response:
See Plan above.
21
Explanation of this schedule - §200.511 ( c)
Page 46
Page 46
Bloom High School District 206 07-016-2060-17 CORRECTIVE ACTION PLAN FOR CURRENT YEAR AUDIT FINDINGS21 Year Ending June 30, 2016
Corrective Action Plan Finding No.:
2016-
005
Condition:
Per GWA's review of a sample of 2 quarterly reports associated with the IDEA grant, it was noted that one of the reports included a budgeted figure as an actual amount to be reported/reimbursed.
Plan:
Grant personnel will work with the pass-through entity, SPEED, to put a procedure in place which allows for a "draft" version of an expenditure report aimed at detecting errors in advance of final submissions.
Anticipated Date of Completion:
1/1/2017
Name of Contact Person:
Dawn Angelini
Management Response:
See Plan above.
21
Explanation of this schedule - §200.511 ( c)
