BROOKS COUNTY BOARD OF EDUCATION
QUITMAN, GEORGIA
ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED JUNE 30, 2018
(Including Independent Auditor's Reports)
BROOKS COUNTY BOARD OF EDUCATION - TABLE OF CONTENTS -
Page
SECTION I
FINANCIAL
INDEPENDENT AUDITOR'S REPORT
EXHIBITS
BASIC FINANCIAL STATEMENTS
GOVERNMENT-WIDE FINANCIAL STATEMENTS
A
STATEMENT OF NET POSITION
1
B
STATEMENT OF ACTIVITIES
2
FUND FINANCIAL STATEMENTS
C
BALANCE SHEET
GOVERNMENTAL FUNDS
4
D
RECONCILIATION OF THE GOVERNMENTAL FUNDS BALANCE SHEET
TO THE STATEMENT OF NET POSITION
5
E
STATEMENT OF REVENUES, EXPENDITURES AND CHANGES
IN FUND BALANCES
GOVERNMENTAL FUNDS
6
F
RECONCILIATION OF THE GOVERNMENTAL FUNDS STATEMENT
OF REVENUES, EXPENDITURES AND CHANGES IN FUND
BALANCES TO THE STATEMENT OF ACTIVITIES
7
G
STATEMENT OF FIDUCIARY NET POSITION
FIDUCIARY FUNDS
8
H
STATEMENT OF CHANGES IN FIDUCIARY NET POSITION
FIDUCIARY FUNDS
9
I NOTES TO THE BASIC FINANCIAL STATEMENTS
10
SCHEDULES
REQUIRED SUPPLEMENTARY INFORMATION
1 SCHEDULE OF PROPORTIONATE SHARE OF THE NET PENSION LIABILITY
TEACHERS RETIREMENT SYSTEM OF GEORGIA
35
2 SCHEDULE OF PROPORTIONATE SHARE OF THE NET PENSION LIABILITY
PUBLIC SCHOOL EMPLOYEES RETIREMENT SYSTEM OF GEORGIA
36
3 SCHEDULE OF PROPORTIONATE SHARE OF THE NET OPEB LIABILITY
SCHOOL OPEB FUND
37
4 SCHEDULE OF CONTRIBUTIONS TEACHERS RETIREMENT SYSTEM OF GEORGIA'''''''''''''38
5 SCHEDULE OF CONTRIBUTIONS SCHOOL OPEB FUND
39
6 NOTES TO THE REQUIRED SUPPLEMENTARY INFORMATION
40
7 SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND
BALANCES BUDGET AND ACTUAL
GENERAL FUND
41
BROOKS COUNTY BOARD OF EDUCATION - TABLE OF CONTENTS -
SECTION I
FINANCIAL
SCHEDULES
SUPPLEMENTARY INFORMATION
8 SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS 9 SCHEDULE OF STATE REVENUE 10 SCHEDULE OF APPROVED LOCAL OPTION SALES TAX PROJECTS
Page
42 43 45
SECTION II COMPLIANCE AND INTERNAL CONTROL REPORTS 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 INDEPENDENT AUDITOR'S REPORT ON COMPLIANCE FOR EACH MAJOR FEDERAL PROGRAM AND ON INTERNAL CONTROL OVER COMPLIANCE REQUIRED BY THE UNIFORM GUIDANCE
SECTION III AUDITEE'S RESPONSE TO PRIOR YEAR FINDINGS AND QUESTIONED COSTS SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS
SECTION IV FINDINGS AND QUESTIONED COSTS SCHEDULE OF FINDINGS AND QUESTIONED COSTS
SECTION V MANAGEMENT'S CORRECTIVE ACTION FOR CURRENT YEAR FINDINGS SCHEDULE OF MANAGEMENT'S CORRECTIVE ACTION
SECTION I FINANCIAL
Greg S. Griffin
STATE AUDITOR
(404) 656-2174
DEPARTMENT OF AUDITS AND ACCOUNTS
270 Washington Street, S.W., Suite 1-156 Atlanta, Georgia 30334-8400
March 24, 2020
The Honorable Brian P. Kemp, Governor of Georgia Members of the General Assembly of the State of Georgia Members of the State Board of Education
and Superintendent and Members of the Brooks County Board of Education
INDEPENDENT AUDITOR'S REPORT
Report on the Financial Statements
We have audited the accompanying financial statements of the governmental activities, each major fund, and the aggregate remaining fund information of the Brooks County Board of Education (School District), as of and for the year ended June 30, 2018, and the related notes to the financial statements, which collectively comprise the School District's basic financial statements as listed in the table of contents.
Management's Responsibility for the Financial Statements
Management is responsible for the preparation and fair presentation of these financial statements in accordance with accounting principles generally accepted in the United States of America; this includes 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 opinions 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.
Opinions
In our opinion, the financial statements referred to above present fairly, in all material respects, the respective financial position of the of the governmental activities, each major fund, and the aggregate remaining fund information of the School District as of June 30, 2018, and the respective changes in financial position for the year then ended in accordance with accounting principles generally accepted in the United States of America.
Emphasis of Matter
As described in Note 2 to the financial statements, in 2018, the School District adopted new accounting guidance, Governmental Accounting Standards Board (GASB) Statement No. 75, Accounting and Financial Reporting for Postemployment Benefits Other Than Pensions, as amended by GASB Statement No. 85, Omnibus 2017. The School District restated beginning net position for the effect of GASB Statement No. 75. Our opinions are not modified with respect to this matter.
Other Matters
Required Supplementary Information
Management has omitted the Management's Discussion and Analysis that accounting principles generally accepted in the United States of America require to be presented to supplement the basic financial statements. Such missing information, although not a part of the basic financial statements, is required by the Governmental Accounting Standards Board who considers it to be an essential part of financial reporting for placing the basic financial statements in an appropriate operational, economic, or historical context. Our opinion on the basic financial statements is not affected by this missing information.
Accounting principles generally accepted in the United States of America require that the required supplementary information listed in the table of contents be presented to supplement the basic financial statements. Such information, although not a part of the basic financial statements, is required by the Governmental Accounting Standards Board, who considers it to be an essential part of financial reporting for placing the basic financial statements in an appropriate operational, economic, or historical context. We have applied certain limited procedures to the required supplementary information in accordance with auditing standards generally accepted in the United States of America, which consisted of inquiries of management about the methods of preparing the information and comparing the information for consistency with management's responses to our inquiries, the basic financial statements, and other knowledge we obtained during our audit of the basic financial statements. We do not express an opinion or provide any assurance on the information because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance.
Other Information
Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the School District's basic financial statements. The accompanying supplementary information, as listed in the table of contents, is presented for the purposes of additional analysis and is not a required part of the basic financial statements. 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 basic financial statements.
The accompanying supplementary information is the responsibility of management and was derived from and relates 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 basic financial statements taken as a whole.
Other Reporting Required by Government Auditing Standards
In accordance with Government Auditing Standards, we have also issued our report dated March 24, 2020 on our consideration of the School District'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 solely 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 the effectiveness of the School District's 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 the School District's internal control over financial reporting and compliance.
A copy of this report has been filed as a permanent record in the office of the State Auditor and made available to the press of the State, as provided for by Official Code of Georgia Annotated section 50-6-24.
Respectfully submitted,
Greg S. Griffin State Auditor
(This page left intentionally blank)
BROOKS COUNTY BOARD OF EDUCATION
BROOKS COUNTY BOARD OF EDUCATION STATEMENT OF NET POSITION JUNE 30, 2018
ASSETS
Cash and Cash Equivalents Accounts Receivables, Net
Taxes State Government Federal Government Local Other Inventories Restricted Assets Cash and Investment with Fiscal Agent or Trustee Capital Assets, Non-Depreciable Capital Assets, Depreciable (Net of Accumulated Depreciation)
Total Assets
DEFERRED OUTFLOWS OF RESOURCES
Related to Defined Benefit Pension Plan Related to OPEB Plan
Total Deferred Outflows of Resources
LIABILITIES
Accounts Payable Salaries and Benefits Payable Payroll Withholdings Payable Interest Payable Contracts Payable Deposits and Unearned Revenues Net Pension Liability Net OPEB Liability Long-Term Liabilities
Due Within One Year Due in More Than One Year
Total Liabilities
DEFERRED INFLOWS OF RESOURCES
Related to Defined Benefit Pension Plan Related to OPEB Plan
Total Deferred Inflows of Resources
NET POSITION
Net Investment in Capital Assets Restricted for
Continuation of Federal Programs Debt Service Capital Projects Unrestricted (Deficit)
Total Net Position
The notes to the basic financial statements are an integral part of this statement.
EXHIBIT "A"
GOVERNMENTAL ACTIVITIES
$
5,798,022.81
600,428.30 1,686,875.44
438,680.73 7,276.14 1,176.38
57,090.77
6,002,620.90 546,863.00
26,223,273.75
41,362,308.22
3,017,476.98 1,136,658.00
4,154,134.98
171,164.08 2,361,389.62
3,129.27 20,956.25 718,329.00 77,220.00 17,899,324.00 20,768,510.00
1,226,636.54 12,329,683.09
55,576,341.85
1,616,758.00 1,581,469.00
3,198,227.00
24,215,864.96
268,726.02 1,252,036.47 4,885,620.82 (43,880,373.92)
$ (13,258,125.65)
- 1 -
BROOKS COUNTY BOARD OF EDUCATION STATEMENT OF ACTIVITIES
FOR THE YEAR ENDED JUNE 30, 2018
GOVERNMENTAL ACTIVITIES
Instruction Support Services
Pupil Services Improvement of Instructional Services Educational Media Services General Administration School Administration Business Administration Maintenance and Operation of Plant Student Transportation Services Other Support Services Operations of Non-Instructional Services Community Services Food Services Interest on Short-Term and Long-Term Debt
Total Governmental Activities
General Revenues Taxes Property Taxes For Maintenance and Operations Sales Taxes Special Purpose Local Option Sales Tax For Debt Service Other Sales Tax Grants and Contributions not Restricted to Specific Programs Investment Earnings Miscellaneous
Total General Revenues
Change in Net Position
Net Position - Beginning of Year (Restated)
Net Position - End of Year
EXPENSES
CHARGES FOR SERVICES
$ 19,257,485.81 $
1,894,805.23 1,007,707.25
546,847.51 1,204,631.83 1,843,943.03
613,545.30 2,400,972.46 1,163,638.97
26,557.34
1,725,852.78
104,501.48
$ 31,790,488.99 $
192,453.96
-
125.00 52,015.99
-
244,594.95
The notes to the basic financial statements are an integral part of this statement.
- 2 -
EXHIBIT "B"
PROGRAM REVENUES OPERATING GRANTS AND
CONTRIBUTIONS
CAPITAL GRANTS AND CONTRIBUTIONS
NET (EXPENSES) REVENUES
AND CHANGES IN NET POSITION
$
9,830,649.99 $
345,548.30 906,578.14 273,768.00 522,144.28 826,169.08
3,999.87 664,994.70 480,608.97
21,009.33
1,844,836.52
-
$
15,720,307.18 $
- $
154,535.83 -
-
154,535.83
(9,234,381.86)
(1,549,256.93) (101,129.11) (273,079.51) (682,487.55)
(1,017,773.95) (609,545.43)
(1,735,977.76) (528,494.17) (5,548.01)
125.00 170,999.73 (104,501.48)
(15,671,051.03)
7,453,494.74
1,029,516.13 91,362.24
885,577.00 47,921.78
512,863.15
10,020,735.04
(5,650,315.99)
(7,607,809.66)
$
(13,258,125.65)
- 3 -
BROOKS COUNTY BOARD OF EDUCATION BALANCE SHEET
GOVERNMENTAL FUNDS JUNE 30, 2018
EXHIBIT "C"
ASSETS
Cash and Cash Equivalents Accounts Receivable, Net
Taxes State Government Federal Government Local Other Inventories Restricted Cash and Investments with a Fiscal Agent or Trustee
GENERAL FUND
CAPITAL PROJECTS
FUND
DEBT SERVICE
FUND
TOTAL
$ 5,040,794.56 $
99,783.92 $
483,334.91 1,686,875.44
438,680.73 7,276.14 1,176.38
57,090.77
117,093.39 -
-
6,002,620.90
657,444.33 $
-
-
5,798,022.81
600,428.30 1,686,875.44
438,680.73 7,276.14 1,176.38
57,090.77
6,002,620.90
Total Assets
LIABILITIES
Accounts Payable Salaries and Benefits Payable Payroll Withholdings Payable Contracts Payable Deposits and Unearned Revenue
Total Liabilities
DEFERRED INFLOWS OF RESOURCES
Unavailable Revenue - Property Taxes
FUND BALANCES
Nonspendable Restricted Assigned Unassigned
Total Fund Balances
$ 7,715,228.93 $ 6,219,498.21 $
657,444.33 $ 14,592,171.47
$
171,164.08 $
2,361,389.62
3,129.27
-
77,220.00
2,612,902.97
- $ 718,329.00 -
718,329.00
- $
171,164.08
-
2,361,389.62
-
3,129.27
-
718,329.00
-
77,220.00
-
3,331,231.97
333,875.30
-
-
333,875.30
57,090.77 211,635.25
48,741.15 4,450,983.49
4,768,450.66
5,501,169.21
-
5,501,169.21
657,444.33
-
657,444.33
57,090.77 6,370,248.79
48,741.15 4,450,983.49
10,927,064.20
Total Liabilities, Deferred Inflows of Resources, and Fund Balances
$ 7,715,228.93 $ 6,219,498.21 $
657,444.33 $ 14,592,171.47
The notes to the basic financial statements are an integral part of this statement.
- 4 -
BROOKS COUNTY BOARD OF EDUCATION RECONCILIATION OF THE GOVERNMENTAL FUNDS BALANCE SHEET
TO THE STATEMENT OF NET POSITION JUNE 30, 2018
EXHIBIT "D"
Total fund balances - governmental funds (Exhibit "C")
Amounts reported for governmental activities in the Statement of Net Position are different because:
Capital assets used in governmental activities are not financial resources and therefore are not reported in the funds.
Land Buildings and improvements Equipment Land improvements Intangible assets Accumulated depreciation
Some liabilities are not due and payable in the current period and, therefore, are not reported in the funds.
Net pension liability Net OPEB liability
Deferred outflows and inflows of resources related to pensions and OPEB are applicable to future periods and, therefore, are not reported in the funds.
Related to pensions Related to OPEB
Taxes that are not available to pay for current period expenditures are deferred in the funds.
Long-term liabilities, and related accrued interest, are not due and payable in the current period and therefore are not reported in the funds.
Bonds payable Accrued interest payable Capital lease payable Energy efficiency lease payable
Net position of governmental activities (Exhibit "A")
$ 10,927,064.20
$
546,863.00
37,351,634.00
7,622,936.42
3,142,747.00
179,739.00
(22,073,782.67)
26,770,136.75
$ (17,899,324.00) (20,768,510.00)
(38,667,834.00)
$
1,400,718.98
(444,811.00)
955,907.98 333,875.30
$ (2,395,000.00) (20,956.25)
(159,271.79) (11,002,047.84)
(13,577,275.88)
$ (13,258,125.65)
The notes to the basic financial statements are an integral part of this statement.
- 5 -
BROOKS COUNTY BOARD OF EDUCATION STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES
GOVERNMENTAL FUNDS YEAR ENDED JUNE 30, 2018
EXHIBIT "E"
REVENUES
Property Taxes Sales Taxes State Funds Federal Funds Charges for Services Investment Earnings Miscellaneous
Total Revenues
EXPENDITURES
Current Instruction Support Services Pupil Services Improvement of Instructional Services Educational Media Services General Administration School Administration Business Administration Maintenance and Operation of Plant Student Transportation Services Other Support Services Food Services Operation
Capital Outlay Debt Services
Principal Dues and Fees Interest
Total Expenditures
Excess of Revenues over (under) Expenditures
OTHER FINANCING SOURCES (USES)
Capital Lease Transfers In Transfers Out
Total Other Financing Sources (Uses)
Net Change in Fund Balances
Fund Balances - Beginning
GENERAL FUND
CAPITAL PROJECTS
FUND
DEBT SERVICE
FUND
TOTAL
$
7,446,713.11 $
- $
91,362.24
1,029,516.13
12,896,743.26
-
3,873,128.83
-
244,594.95
-
7,291.71
40,630.07
512,863.15
-
25,072,697.25
1,070,146.20
- $ -
-
7,446,713.11 1,120,878.37 12,896,743.26 3,873,128.83
244,594.95 47,921.78
512,863.15
26,142,843.45
13,193,115.94
1,431,404.47 1,001,260.43
230,630.99 1,173,245.35 1,812,915.17
474,124.89 2,237,043.08 1,670,609.12
21,187.00 1,843,120.75
-
50,234.99 -
5,845.23
25,144,737.41
(72,040.16)
-
5,756,977.37
-
5,756,977.37
(4,686,831.17)
-
-
1,130,000.00 269.72
103,600.00
1,233,869.72
(1,233,869.72)
13,193,115.94
1,431,404.47 1,001,260.43
230,630.99 1,173,245.35 1,812,915.17
474,124.89 2,237,043.08 1,670,609.12
21,187.00 1,843,120.75 5,756,977.37
1,180,234.99 269.72
109,445.23
32,135,584.50
(5,992,741.05)
-
-
(72,040.16)
4,840,490.82
11,002,047.84 -
(1,233,869.72)
9,768,178.12
5,081,346.95
419,822.26
1,233,869.72
-
1,233,869.72
-
657,444.33
11,002,047.84 1,233,869.72 (1,233,869.72)
11,002,047.84
5,009,306.79
5,917,757.41
Fund Balances - Ending
$
4,768,450.66 $ 5,501,169.21 $
657,444.33 $ 10,927,064.20
The notes to the basic financial statements are an integral part of this statement.
- 6 -
BROOKS COUNTY BOARD OF EDUCATION RECONCILIATION OF THE GOVERNMENTAL FUNDS STATEMENT OF
REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES TO THE STATEMENT OF ACTIVITIES JUNE 30, 2018
EXHIBIT "F"
Net change in fund balances total governmental funds (Exhibit "E")
Amounts reported for governmental activities in the Statement of Activities are different because:
Governmental funds report capital outlays as expenditures. However, in the Statement of Activities, the cost of capital assets is allocated over their estimated useful lives as depreciation expense.
Capital outlay Depreciation expense
Taxes reported in the Statement of Activities that do not provide current financial resources are not reported as revenues in the funds.
The issuance of long-term debt provides current financial resources to governmental funds, while the repayment of the principal of long-term debt consumes the current financial resources of governmental funds. Neither transaction, however, has any effect on net position. Also, governmental funds report the effect of premiums, discounts and the difference between the carrying value of refunded debt and the acquisition cost of refunded debt when debt is first issued. These amounts are deferred and amortized in the Statement of Activities.
Energy efficiency lease issued Capital lease payments Bond principal retirements
District pension and OPEB contributions are reported as expenditures in the governmental funds when made. However, they are reported as deferred outflows of resources in the Statement of Net Position because the reported net pension and OPEB liability is measured a year before the District's report date. Pension and OPEB expense, which is the change in the net pension and OPEB liability adjusted for changes in deferred outflows and inflows of resources related to pensions and OPEB, is reported in the Statement of Activities.
Pension expense OPEB expense
Some items reported in the Statement of Activities do not require the use of current financial resources and therefore are not reported as expenditures in governmental funds.
Accrued interest
$ 5,009,306.79
$
465,229.00
(1,448,381.53)
(983,152.53) 6,781.63
$ (11,002,047.84) 50,234.99
1,130,000.00
(9,821,812.85)
641,748.22 (508,131.00)
133,617.20
4,943.75
Change in net position of governmental activities (Exhibit "B")
$ (5,650,316.01)
The notes to the basic financial statements are an integral part of this statement.
- 7 -
ASSETS Cash and Cash Equivalents Investments
Total Assets LIABILITIES Funds Held for Others NET POSITION Held in Trust for Private Purposes
BROOKS COUNTY BOARD OF EDUCATION STATEMENT OF FIDUCIARY NET POSITION
FIDUCIARY FUNDS JUNE 30, 2018
EXHIBIT "G"
PRIVATE PURPOSE TRUSTS
AGENCY FUNDS
$
1,635.85 $
201,353.61
32,480.81 -
$ 202,989.46 $ 32,480.81
$ 32,480.81
$ 202,989.46
The notes to the basic financial statements are an integral part of this statement.
- 8 -
BROOKS COUNTY BOARD OF EDUCATION STATEMENT OF CHANGES IN FIDUCIARY NET POSITION
FIDUCIARY FUNDS YEAR ENDED JUNE 30, 2018
ADDITIONS Investment Earnings Net Increase in Fair Value of Investments
DEDUCTIONS None Reported Change in Net Position
Net Position - Beginning
Net Position - Ending
EXHIBIT "H"
PRIVATE PURPOSE TRUSTS
$ 19,867.66
19,867.66 183,121.80
$ 202,989.46
The notes to the basic financial statements are an integral part of this statement.
- 9 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
NOTE 1: DESCRIPTION OF SCHOOL DISTRICT AND REPORTING ENTITY
REPORTING ENTITY
The Brooks County Board of Education (School District) was established under the laws of the State of Georgia and operates under the guidance of a board elected by the voters and a Superintendent appointed by the Board. The School District is organized as a separate legal entity and has the power to levy taxes and issue bonds. Its budget is not subject to approval by any other entity. Accordingly, the School District is a primary government and consists of all the organizations that compose its legal entity.
NOTE 2: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
The accompanying financial statements of the School District have been prepared in conformity with generally accepted accounting principles (GAAP) as prescribed by the Governmental Accounting Standards Board (GASB). GASB is the accepted standard-setting body for governmental accounting and financial reporting principles. The most significant of the School District's accounting policies are described below.
BASIS OF PRESENTATION
The School District's basic financial statements are collectively comprised of the government-wide financial statements, fund financial statements and notes to the basic financial statements. The government-wide statements focus on the School District as a whole, while the fund financial statements focus on major funds. Each presentation provides valuable information that can be analyzed and compared between years and between governments to enhance the information's usefulness.
GOVERNMENT-WIDE STATEMENTS:
The Statement of Net Position and the Statement of Activities display information about the financial activities of the overall School District, except for fiduciary activities. Eliminations have been made to minimize the double counting of internal activities. Governmental activities generally are financed through taxes, intergovernmental revenues, and other nonexchange transactions.
The Statement of Net Position presents the School District's non-fiduciary assets and liabilities, with the difference reported as net position. Net position is reported in three categories as follows:
1. Net investment in capital assets consists of the School District's total investment in capital assets, net of accumulated depreciation, and reduced by outstanding debt obligations related to those capital assets. To the extent debt has been incurred but not yet expended for capital assets, such amounts are not included as a component of net investment in capital assets.
2. Restricted net position consists of resources for which the School District is legally or contractually obligated to spend in accordance with restrictions imposed by external third parties or imposed by law through constitutional provisions or enabling legislation.
3. Unrestricted net position consists of resources not meeting the definition of the two preceding categories. Unrestricted net position often has constraints on resources imposed by management which can be removed or modified.
The Statement of Activities presents a comparison between direct expenses and program revenues for each function of the School District's governmental activities.
Direct expenses are those that are specifically associated with a program or function and, therefore, are clearly identifiable to a particular function. Indirect expenses (expenses of the School District related to the administration and support of the School District's programs, such as office and maintenance personnel and accounting) are not allocated to programs.
- 10 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
Program revenues include (a) charges paid by the recipients of goods or services offered by the programs and (b) grants and contributions that are restricted to meeting the operational or capital requirements of a particular program. Revenues that are not classified as program revenues, including all taxes, are presented as general revenues.
FUND FINANCIAL STATEMENTS
The fund financial statements provide information about the School District's funds, including fiduciary funds. Eliminations have been made to minimize the double counting of internal activities. Separate financial statements are presented for governmental and fiduciary funds. The emphasis of fund financial statements is on major governmental funds, each displayed in a separate column.
The School District reports the following major governmental funds:
The general fund is the School District's primary operating fund. It accounts for and reports all financial resources not accounted for and reported in another fund.
The capital projects fund accounts for and reports financial resources including Education Special Purpose Local Option Sales Tax (ESPLOST) that are restricted, committed or assigned for capital outlay expenditures, including the acquisition or construction of capital facilities and other capital assets.
The debt service fund accounts for and reports financial resources that are restricted, committed, or assigned including taxes (sales) legally restricted for the payment of general long-term principal and interest.
The School District reports the following fiduciary fund types:
Private purpose trust funds are used to report all trust arrangements, other than those properly reported elsewhere, in which principal and income benefit individuals, private organizations or other governments.
Agency funds are used to report resources held by the School District in a purely custodial capacity (assets equal liabilities) and do not involve measurement of results of operations.
BASIS OF ACCOUNTING
The basis of accounting determines when transactions are reported on the financial statements. The government-wide and fiduciary fund financial statements are reported using the economic resources measurement focus and the accrual basis of accounting. Revenues are recorded when earned and expenses are recorded at the time liabilities are incurred, regardless of when the related cash flows take place. Nonexchange transactions, in which the School District gives (or receives) value without directly receiving (or giving) equal value in exchange, include property taxes, sales taxes and grants. On an accrual basis, revenue from property taxes is recognized in the fiscal year for which the taxes are levied. Revenue from sales taxes is recognized in the fiscal year in which the underlying transaction (sale) takes place. Revenue from grants is recognized in the fiscal year in which all eligibility requirements have been satisfied.
The School District uses funds to report on its financial position and the results of its operations. Fund accounting is designed to demonstrate legal compliance and to aid financial management by segregating transactions related to certain governmental functions or activities. A fund is a separate accounting entity with a self-balancing set of accounts.
Governmental funds are reported using the current financial resources measurement focus and the modified accrual basis of accounting. Under this method, revenues are recognized when measurable and available. The School District considers all revenues reported in the governmental funds to be available if they are collected within sixty days after year-end. The School District considers all intergovernmental revenues to be available if they are collected within 60 days after year-end. Property taxes, sales taxes and interest are considered to be susceptible to accrual. Expenditures are recorded
- 11 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
when the related fund liability is incurred, except for principal and interest on general long-term debt, which are recognized as expenditures to the extent they have matured. Capital asset acquisitions are reported as expenditures in governmental funds. Proceeds of general long-term liabilities and acquisitions under capital leases are reported as other financing sources.
The School District funds certain programs by a combination of specific cost-reimbursement grants, categorical grants, and general revenues. Thus, when program costs are incurred, there are both restricted and unrestricted net assets available to finance the program. It is the School District's policy to first apply grant resources to such programs, followed by cost-reimbursement grants, then general revenues.
NEW ACCOUNTING PRONOUNCEMENTS
In fiscal year 2018, the School District adopted Governmental Accounting Standards Board (GASB) Statement No. 75, Accounting and Financial Reporting for Postemployment Benefits Other than Pensions. This statement establishes standards for recognizing and measuring liabilities, deferred outflows of resources, deferred inflows of resources, and expense/expenditures. For defined benefit OPEB, this statement identifies the methods and assumptions that are required to be used to project benefit payments, discount projected benefit payments to their actuarial present value, and attribute that present value to periods of employee service. Note disclosure and required supplementary information requirements about defined benefit OPEB also are addressed. The adoption of this statement has a significant impact on the School District's financial statements. As noted in the Restatement of Net Position note disclosure, the School District restated beginning net position for the cumulative effect of this accounting change.
In fiscal year 2018, the School District adopted Governmental Accounting Standards Board (GASB) Statement No. 81, Irrevocable Split-Interest Agreements. This statement requires that a government that receives resources pursuant to an irrevocable split-interest agreement recognize assets, liabilities, and deferred inflows of resources at the inception of the agreement. Furthermore, this statement requires that a government recognize assets representing its beneficial interests in irrevocable split-interest agreements that are administered by a third party, if the government controls the present service capacity of the beneficial interests. This statement requires that a government recognize revenue when the resources become applicable to the reporting period. The adoption of this statement does not have a significant impact on the School District's financial statements.
In fiscal year 2018, the School District adopted Governmental Accounting Standards Board (GASB) Statement No. 85, Omnibus 2017. The objective of this statement is to address practice issues that have been identified during implementation and application of certain GASB Statements. This statement addresses a variety of topics including issues related to blending component units, goodwill, fair value measurement and application, and postemployment benefits (pensions and other postemployment benefits [OPEB]). The adoption of this statement does not have a significant impact on the School District's financial statements.
In fiscal year 2018, the School District adopted Governmental Accounting Standards Board (GASB) Statement No. 86, Certain Debt Extinguishment Issues. The primary objective of this statement is to improve consistency in accounting and financial reporting for in-substance defeasance of debt by providing guidance for transactions in which cash and other monetary assets acquired with only existing resources--resources other than the proceeds of refunding debt--are placed in an irrevocable trust for the sole purpose of extinguishing debt. This statement also improves accounting and financial reporting for prepaid insurance on debt that is extinguished and notes to financial statements for debt that is defeased in substance. The adoption of this statement does not have a significant impact on the School District's financial statements.
- 12 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
CASH AND CASH EQUIVALENTS
Cash and cash equivalents consist of cash on hand, demand deposits, investments in the State of Georgia local government investment pool (Georgia Fund 1) and short-term investments with original maturities of three months or less from the date of acquisition in authorized financial institutions. Official Code of Georgia Annotated (O.C.G.A.) 45-8-14 authorizes the School District to deposit its funds in one or more solvent banks, insured Federal savings and loan associations or insured chartered building and loan associations.
INVESTMENTS
The School District can invest its funds as permitted by O.C.G.A. 36-83-4. In selecting among options for investment or among institutional bids for deposits, the highest rate of return shall be the objective, given equivalent conditions of safety and liquidity.
Investments made by the School District in nonparticipating interest-earning contracts (such as certificates of deposit) and repurchase agreements are reported at cost. Participating interest-earning contracts and money market investments with a maturity at purchase of one year or less are reported at amortized cost. All other investments are reported at fair value.
For accounting purposes, certificates of deposit are classified as investments if they have an original maturity greater than three months when acquired.
RECEIVABLES
Receivables consist of amounts due from property and sales taxes, grant reimbursements due on Federal, State or other grants for expenditures made but not reimbursed and other receivables disclosed from information available. Receivables are recorded when either the asset or revenue recognition criteria has been met. Receivables recorded on the basic financial statements do not include any amounts which would necessitate the need for an allowance for uncollectible receivables.
INVENTORIES
Food Inventories
On the basic financial statements, inventories of donated food commodities used in the preparation of meals are reported at their Federally assigned value and purchased foods inventories are reported at cost (calculated on the first-in, first-out basis). The School District uses the consumption method to account for inventories whereby donated food commodities are recorded as an asset and as revenue when received, and expenses/expenditures are recorded as the inventory items are used. Purchased foods are recorded as an asset when purchased and expenses/expenditures are recorded as the inventory items are used.
RESTRICTED ASSETS
Certain resources set aside for repayment of debt are classified as restricted assets on the Statement of net position because their use is limited by applicable debt statutes, e.g. Qualified Zone Academy Bond sinking funds.
CAPITAL ASSETS
On the government-wide financial statements, capital assets are recorded at cost where historical records are available and at estimated historical cost based on appraisals or deflated current replacement cost where no historical records exist. Donated capital assets are recorded at the acquisition value on the date donated. The cost of normal maintenance and repairs that do not add to the value of assets or materially extend the useful lives of the assets is not capitalized. The School District does not capitalize book collections or works of art.
Capital acquisition and construction are recorded as expenditures in the governmental fund financial statements at the time of purchase (including ancillary charges), and the related assets are reported as capital assets in the governmental activities column in the government-wide financial statements.
- 13 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
Depreciation is computed using the straight-line for all assets, except land, and is used to allocate the actual or estimated historical cost of capital assets over estimated useful lives.
Capitalization thresholds and estimated useful lives of capital assets reported in the government-wide statements are as follows:
Capitalization Policy
Estimated Useful Life
Land
Land Improvements
$
Buildings and Improvements $
Equipment
$
Intangible Assets
$
All 5,000.00 5,000.00 5,000.00 100,000.00
N/A 15 years
15 to 45 years 5 to 12 years
10 to 20 years
DEFERRED OUTFLOWS/INFLOWS OF RESOURCES
In addition to assets, the statement of financial position will report a separate section for deferred outflows of resources. This separate financial statement element represents a consumption of resources that applies to a future period(s) and therefore will not be recognized as an outflow of resources (expense/expenditure) until then.
In addition to liabilities, the statement of financial position will report a separate section for deferred inflows of resources. This separate financial statement element represents an acquisition of resources that applies to a future period(s) and therefore will not be recognized as an inflow of resources (revenue) until that time.
LONG-TERM LIABILITIES AND BOND DISCOUNTS/PREMIUMS
In the School District's government-wide financial statements, outstanding debt is reported as liabilities. Bond premiums and discounts and the difference between the reacquisition price and the net carrying value of refunded debt are deferred and amortized over the life of the bonds using the straight-line method. To conform to generally accepted accounting principles, bond premiums and discounts should be amortized using the effective interest method. The effect of this deviation is deemed to be immaterial to the fair presentation of the basic financial statements. Bond issuance costs are recognized as an outflow of resources in the fiscal year in which the bonds are issued.
In the governmental fund financial statements, the School District recognizes the proceeds of debt and premiums as other financing sources of the current period. Bond issuance costs are reported as debt service expenditures.
PENSIONS
For purposes of measuring the net pension liability, deferred outflows of resources and deferred inflows of resources related to pensions, and pension expense, information about the pension plan's fiduciary net position and additions to/deductions from the plan's fiduciary net position have been determined on the same basis as they are reported by the plan. 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.
POSTEMPLOYMENT BENEFITS OTHER THAN PENSIONS (OPEB)
For purposes of measuring the net OPEB liability, deferred outflows of resources and deferred inflows of resources related to OPEB, and OPEB expense, information about the fiduciary net position of the Georgia School Employees Postemployment Benefit Fund (School OPEB Fund) and additions to/deductions from School OPEB Fund fiduciary net position have been determined on the same basis as they are reported by School OPEB Fund. For this purpose, benefit payments are recognized when due and payable in accordance with the benefit terms. Investments are reported at fair value.
- 14 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
FUND BALANCES
Fund balance for governmental funds is reported in classifications that comprise a hierarchy based primarily on the extent to which the government is bound to honor constraints on the specific purposes for which amounts in those funds can be spent.
The School District's fund balances are classified as follows:
Nonspendable consists of resources that cannot be spent either because they are in a nonspendable form or because they are legally or contractually required to be maintained intact.
Restricted consists of resources that can be used only for specific purposes pursuant to constraints either (1) externally imposed by creditors, grantors, contributors, or laws and regulations of other governments or (2) imposed by law through constitutional provisions or enabling legislation.
Committed consists of resources that can be used only for specific purposes pursuant to constraints imposed by formal action of the Board. The Board is the School District's highest level of decisionmaking authority, and the formal action that is required to be taken to establish, modify, or rescind a fund balance commitment is a resolution approved by the Board. Committed fund balance also should incorporate contractual obligations to the extent that existing resources in the fund have been specifically committed for use in satisfying those contractual requirements.
Assigned consists of resources constrained by the School District's intent to be used for specific purposes, but are neither restricted nor committed. The intent should be expressed by (1) the Board or (2) the budget or finance committee, or the Superintendent, or designee, to assign amounts to be used for specific purposes.
Unassigned consists of resources within the general fund not meeting the definition of any aforementioned category. The general fund should be the only fund that reports a positive unassigned fund balance amount. In other governmental funds, it may be necessary to report a negative unassigned fund balance.
USE OF ESTIMATES
The preparation of the financial statements in conformity with accounting principles generally accepted in the United States 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.
PROPERTY TAXES
The Brooks County Board of Commissioners adopted the property tax levy for the 2017 tax digest year (calendar year) on August 24, 2017 (levy date) based on property values as of January 1, 2017. Taxes were due on November 15, 2017 (lien date). Taxes collected within the current fiscal year or within 60 days after year-end on the 2017 tax digest are reported as revenue in the governmental funds for fiscal year 2018. The Brooks County Board of Commissioners bills and collects the property taxes for the School District, withholds 2.5% of taxes collected as a fee for tax collection and remits the balance of taxes collected to the School District. Property tax revenues, at the fund reporting level, during the fiscal year ended June 30, 2018, for maintenance and operations amounted to $6,927,721.98.
The tax millage rate levied for the 2017 tax year (calendar year) for the School District was as follows (a mill equals $1 per thousand dollars of assessed value):
School Operations
15.07 mills
Additionally, Title Ad Valorem Tax revenues, at the fund reporting level, amounted to $518,991.13 during fiscal year ended June 30, 2018.
- 15 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
SALES TAXES
Education Special Purpose Local Option Sales Tax (ESPLOST), at the fund reporting level, during the year amounted to $1,029,516.13 and is to be used for capital outlay for educational purposes or debt service. This sales tax was authorized by local referendum and the sales tax must be re-authorized at least every five years.
NOTE 3: BUDGETARY DATA
The budget is a complete financial plan for the School District's fiscal year, and is based upon careful estimates of expenditures together with probable funding sources. The budget is legally adopted each year for the general fund. There is no statutory prohibition regarding over expenditure of the budget at any level. The budget for all governmental funds, except the various school activity (principal) accounts, is prepared and adopted by fund, function and object. The legal level of budgetary control was established by the Board at the aggregate function level. The budget for the general fund was prepared in accordance with accounting principles generally accepted in the United States of America.
The budgetary process begins with the School District's administration presenting an initial budget for the Board's review. The administration makes revisions as necessary based on the Board's guidelines, and a tentative budget is approved. After approval of this tentative budget by the Board, such budget is advertised at least once in a newspaper of general circulation in the locality, as well as the School District's website. At the next regularly scheduled meeting of the Board after advertisement, the Board receives comments on the tentative budget, makes revisions as necessary and adopts a final budget. The approved budget is then submitted, in accordance with provisions of O.C.G.A. 20-2-167(c), to the Georgia Department of Education. The Board may increase or decrease the budget at any time during the year. All unexpended budget authority lapses at fiscal year-end.
See the General Fund Schedule of Revenues, Expenditures and Changes in Fund Balances Budget to Actual in the Supplementary Information Section for a detail of any over/under expenditures during the fiscal year under review.
NOTE 4: DEPOSITS AND INVESTMENTS
COLLATERALIZATION OF DEPOSITS
O.C.G.A. 45-8-12 provides that there shall not be on deposit at any time in any depository for a time longer than ten days a sum of money which has not been secured by surety bond, by guarantee of insurance, or by collateral. The aggregate of the face value of such surety bond and the market value of securities pledged shall be equal to not less than 110% of the public funds being secured after the deduction of the amount of deposit insurance. If a depository elects the pooled method (O.C.G.A. 45-8-13.1) the aggregate of the market value of the securities pledged to secure a pool of public funds shall be not less than 110% of the daily pool balance.
Acceptable security for deposits consists of any one of or any combination of the following:
(1) Surety bond signed by a surety company duly qualified and authorized to transact business within the State of Georgia,
(2) Insurance on accounts provided by the Federal Deposit Insurance Corporation,
(3) Bonds, bills, notes, certificates of indebtedness or other direct obligations of the United States or of the State of Georgia,
(4) Bonds, bills, notes, certificates of indebtedness or other obligations of the counties or municipalities of the State of Georgia,
(5) Bonds of any public authority created by the laws of the State of Georgia, providing that the statute that created the authority authorized the use of the bonds for this purpose,
(6) Industrial revenue bonds and bonds of development authorities created by the laws of the State of Georgia, and
- 16 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
(7) Bonds, bills, notes, certificates of indebtedness, or other obligations of a subsidiary corporation of the United States government, which are fully guaranteed by the United States government both as to principal and interest or debt obligations issued by or securities guaranteed by the Federal Land Bank, the Federal Home Loan Bank, the Federal Intermediate Credit Bank, the Central Bank for Cooperatives, the Farm Credit Banks, the Federal Home Loan Mortgage Association, and the Federal National Mortgage Association.
CATEGORIZATION OF DEPOSITS
Custodial credit risk is the risk that in the event of a bank failure, the School District's deposits may not be returned to it. The School District does not have a deposit policy for custodial credit risk. At June 30, 2018, the School District had deposits with a carrying amount of $5,832,139.47, and a bank balance of $6,790,542.94. The bank balances insured by Federal depository insurance were $908,039.47, the bank balances collateralized with securities held by the pledging financial institution's trust department or agent in the School District's name were $1,629,388.89.
At June 30, 2018, $4,253,114.58 of the School District's bank balance was exposed to custodial credit risk and covered in the State's Secure Deposit Program.
The School District participates in the State's Secure Deposit Program (SDP), a multi-bank pledging pool. The SDP requires participating banks that accept public deposits in Georgia to operate under the policy and procedures of the program. The Georgia Office of State Treasurer (OST) sets the collateral requirements and pledging level for each covered depository. There are four tiers of collateralization levels specifying percentages of eligible securities to secure covered deposits: 25%, 50%, 75%, and 110%. The SDP also provides for collateral levels to be increased to an amount of up to 125% if economic or financial conditions warrant. The program lists the type of eligible collateral. The OST approves authorized custodians.
In accordance with the SDP, if a covered depository defaults, losses to public depositors are first satisfied with any applicable insurance, followed by demands of payment under any letters of credit or sale of the covered depository's collateral. If necessary, any remaining losses are to be satisfied by assessments made against the other participating covered depositories. Therefore, for disclosure purposes, all deposits of the SDP are considered to be fully collateralized.
CATEGORIZATION OF INVESTMENTS
At June 30, 2018, the School District had the following investments:
Investment Type
Fair Value
Other Investments Equity Mutual Funds Equity Securities - Domestic
$ 131,113.23 6,072,861.28
Total Investments
$ 6,203,974.51
Fair Value of Investments The School District measures and records its investments using fair value measurement guidelines established by generally accepted accounting principles. These guidelines recognize a three-tiered fair value hierarchy, as follows:
Level 1: Quoted prices for identical measurements in active markets; Level 2: Observable inputs other than quoted market prices; and, Level 3: Unobservable inputs.
- 17 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
At June 30, the School District had the following investments by fair value level:
Investments by fair value level:
Fair Value
Level 1
Level 2
Level 3
Equity Mutual Funds - Domestic Equity Securities - Domestic
$ 131,113.23 $ 131,113.23 $ 6,072,861.28 6,072,861.28
- $
-
-
-
Total investments by fair value level $ 6,203,974.51 $ 6,203,974.51 $
- $
-
Interest Rate Risk
Interest rate risk is the risk that changes in interest rates of debt investment will adversely affect the fair value of an investment. The School District does not have a formal policy for managing interest rate risk.
Custodial Credit Risk
Custodial credit risk for investments is the risk that, in the event of the failure of the counterparty to a transaction, the School District will not be able to recover the value of the investment or collateral securities that are in the possession of an outside party. The School District does not have a formal policy for managing custodial credit risk.
At June 30, 2018, $6,203,974.51 of the School District's applicable investments were held by the investment's counterparty, in the School District's name.
Credit Quality Risk
Credit quality risk is the risk that an issuer or other counterparty to an investment will not fulfill its obligations. State law limits investments to those prescribed O.C.G.A. 36-83-4. The School District does not have a formal policy that would further limit its investment choices or one that addresses credit risk.
Concentration of Credit Risk
Concentration of credit risk is the risk of loss attributed to the magnitude of a government's investment in a single issuer. The School District does not have a formal policy for managing concentration of credit risk. More than 5% of the School District's investments are in Equity Mutual Funds Domestic. These investments are 96.75% of the School District's total investments.
NOTE 5: RESTRICTED ASSETS
The restricted assets represent the investment balance of $6,002,620.90 for the energy efficiency lease escrow account.
- 18 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
NOTE 6: CAPITAL ASSETS
The following is a summary of changes in the capital assets for governmental activities during the fiscal year:
Balances July 1, 2017
Increases
Decreases
Balances June 30, 2018
Governmental Activities Capital Assets, Not Being Depreciated:
Land
$ 546,863.00 $
- $
- $ 546,863.00
Capital Assets Being Depreciated Buildings and Improvements Equipment Land Improvements Intangible Assets
Less Accumulated Depreciation for: Buildings and Improvements Equipment Land Improvements Intangible Assets
37,314,534.00 7,360,698.42 2,976,856.00 179,739.00
37,100.00 262,238.00 165,891.00
-
13,913,251.31 4,316,389.46 2,314,877.47 80,882.90
916,964.81 482,114.09
31,328.73 17,973.90
-
37,351,634.00
-
7,622,936.42
-
3,142,747.00
-
179,739.00
-
14,830,216.12
-
4,798,503.55
-
2,346,206.20
-
98,856.80
Total Capital Assets, Being Depreciated, Net
27,206,426.28
(983,152.53)
-
26,223,273.75
Governmental Activity Capital Assets - Net $ 27,753,289.28 $ (983,152.53) $
Current year depreciation expense by function is as follows:
Instruction Support Services
Pupil Services General Administration School Administration Business Administration Maintenance and Operation of Plant Student Transportation Services Food Services
$
289,020.01
1,800.00
2,500.00
17,973.90
18,970.96
158,416.50
- $ 26,770,136.75
$ 914,549.83
488,681.37 45,150.33
$ 1,448,381.53
NOTE 7: INTERFUND TRANSFERS INTERFUND TRANSFERS
Interfund transfers for the year ended June 30, 2018, consisted of the following:
Transfers to
Transfers From Capital Projects
Fund
Debt Service Fund
$ 1,233,869.72
- 19 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
Transfers are used to move revenue from the capital projects fund to the debt service fund to cover bond debt payments.
NOTE 8: LONG-TERM LIABILITIES
The changes in long-term liabilities during the fiscal year for governmental activities, were as follows:
Governmental Activities
Balance
Balance
Due Within
July 1, 2017
Additions
Deductions
June 30, 2018
One Year
General Obligation (G.O.) Bonds $ 3,525,000.00 $
- $ 1,130,000.00 $ 2,395,000.00 $ 1,175,000.00
Capital Leases
209,506.78
-
50,234.99
159,271.79
51,636.54
Energy Efficiency Leases
-
11,002,047.84
-
11,002,047.84
-
$ 3,734,506.78 $ 11,002,047.84 $ 1,180,234.99 $ 13,556,319.63 $ 1,226,636.54
GENERAL OBLIGATION DEBT OUTSTANDING
The School District's bonded debt consists of general obligation bonds that are generally noncallable with interest payable semiannually. Bond proceeds primarily pay for acquiring or constructing capital facilities. The School District repays general obligation bonds from voter-approved sales taxes. General obligation bonds are direct obligations and pledge the full faith and credit of the School District.
General obligation bonds currently outstanding are as follows:
Description
Interest Rate
Issue Date
Maturity Date Amount Issued
Amount Outstanding
General Government - Series 2008
3.50%
6/5/2008
10/1/2019 $ 6,000,000.00 $ 2,395,000.00
The following schedule details debt service requirements to maturity for the School District's total general obligation bonds payable:
Fiscal Year Ended June 30:
General Obligation Debt
Principal
Interest
2019 2020
$
1,175,000.00 $
63,262.50
1,220,000.00
21,350.00
Total Principal and Interest
$
2,395,000.00 $
84,612.50
CAPITAL LEASES
The School District has acquired buses under the provisions of a long-term lease agreement classified as a capital lease for accounting purposes because it provides for a bargain purchase option or a transfer of ownership by the end of the lease term.
- 20 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
The following assets were acquired through capital leases and are reflected in the capital asset note at fiscal year-end:
Governmental Activities
Equipment Less: Accumulated Depreciation
265,587.00 39,838.05
Capital leases currently outstanding are as follows:
$
225,748.95
Purpose
Interest Rate
Issue Date
Maturity Date
Amount Issued
Amount Outstanding
Bus Lease
2.79%
8/15/2016
8/15/2020 $
265,587.00 $
159,271.79
The following is a schedule of total capital lease payments:
Fiscal Year Ended June 30:
Principal
2019 2020 2021
$
51,636.54 $
53,077.20
54,558.05
Interest
4,443.68 3,003.02 1,522.17
Total Principal and Interest
$
159,271.79 $
8,968.87
OBLIGATIONS UNDER ENERGY EFFICIENCY LEASES
An energy efficiency lease agreement dated January 25, 2018 was executed by and between the School District, the lessee, and First Security Finance, Inc., the lessor. The agreement authorized the borrowing of $11,002,047.84 for the purchase of energy efficiency equipment, machinery, supplies, building modifications and other energy saving items. Payments of the lease shall be made from the School District's capital projects fund.
Debt currently outstanding is as follows:
Purpose
Interest Rate
Issue Date
Maturity Date
Amount Issued
Amount Outstanding
ABM Equipment Lease
3.49%
1/25/2018
3/15/2034 $
11,002,047.84 $ 11,002,047.84
- 21 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
The following is a schedule of total energy efficiency lease payments:
Fiscal Year Ended June 30:
Principal
Interest
2019 2020 2021 2022 2023 2024 - 2028 2029 - 2033 2034
$
- $
383,971.47
402,466.39
383,971.47
437,572.47
369,925.39
476,368.75
354,654.11
515,760.01
338,028.84
3,294,715.02
1,387,774.28
4,722,069.38
718,355.93
1,153,095.82
40,243.04
Total Principal and Interest
$ 11,002,047.84 $
3,976,924.53
NOTE 9: RISK MANAGEMENT
INSURANCE
Commercial Insurance
The School District is exposed to various risks of loss related to torts; theft of, damage to and destruction of assets; errors or omissions; job related illness or injuries to employees; and natural disasters. Except as described below, the School District carries commercial insurance for these risks. Settled claims resulting from these insured risks have not exceed commercial insurance coverage in any of the past three fiscal years.
The School District has elected to self-insure for losses related to natural disasters. In addition, the School District has elected to self-insure for risks for sexual harassment and discrimination. The School District has not experienced any losses related to these risks in the past three years.
WORKERS' COMPENSATION
Georgia Education Workers' Compensation Trust
The School District participates in the Georgia Education Workers' Compensation Trust (the Trust), a public entity risk pool organized on December 1, 1991, to develop, implement and administer a program of workers' compensation self-insurance for its member organizations. The School District pays an annual premium to the Trust for its general workers' compensation insurance coverage. Specific excess of loss insurance coverage is provided through an agreement by the Trust with the Safety National Casualty Company to provide coverage for potential losses sustained by the Trust in excess of $1.0 million loss per occurrence, up to the statutory limit. Employers' Liability insurance coverage is also provided with limits of $2.0 million. The Trust covers the first $1.0 million of each Employers Liability claim with Safety National providing additional Employers Liability limits up to a $2.0 million per occurrence maximum. Safety National Casualty Company also provides $2.0 million in aggregate coverage to the Trust, attaching at 110% of the loss fund and based on the Fund's annual normal premium.
UNEMPLOYMENT COMPENSATION
The School District is self-insured with regard to unemployment compensation claims. The School District accounts for claims within the general fund with expenses/expenditures and liability being reported when it is probable that a loss has occurred, and the amount of that loss can be reasonably estimated.
- 22 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
Changes in the unemployment compensation claims liability during the last two fiscal years are as follows:
Beginning of Year Liability
Claims and Changes in Estimates
Claims Paid
End of Year Liability
2017 $
-
$
912.00
$
912.00
$
-
2018 $
-
$ 12,961.00
$
12,961.00
$
-
SURETY BOND
The School District purchased surety bonds to provide additional insurance coverage as follows:
Position Covered
Amount
Superintendent
$
100,000.00
Assistant Superintendent
$
100,000.00
Each Principal
$
14,200.00
NOTE 10: FUND BALANCE CLASSIFICATION DETAILS
The School District's financial statements include the following amounts presented in the aggregate at June 30, 2018:
Nonspendable Inventories
Restricted Continuation of Federal Programs $ Capital Projects Debt Service
Assigned School Activity Accounts
Unassigned
$
211,635.25 4,885,620.82 1,272,992.72
57,090.77
6,370,248.79 48,741.15
4,450,983.49
Fund Balance, June 30, 2018
$ 10,927,064.20
When multiple categories of fund balance are available for expenditure, the School District will start with the most restricted category and spend those funds first before moving down to the next category with available funds.
NOTE 11: SIGNIFICANT COMMITMENTS
COMMITMENTS UNDER CONSTRUCTION CONTRACTS
The following is an analysis of significant outstanding construction or renovation contracts executed by the School District as of June 30, 2018:
Project
Unearned Executed Contracts (1)
Payments through June 30, 2018 (2)
ABM Energy Efficiency Project $
4,861,099.00 $
5,678,648.00
(1) The amounts described are not reflected in the basic financial statements. (2) Payments include contracts payable at year-end.
- 23 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
OPERATING LEASES
The School District leases copiers under the provisions of one or more long-term lease agreements classified as operating leases for accounting purposes. Rental expenditures under the terms of the operating leases totaled $39,741.00 for governmental activities for the year ended June 30, 2018. The following future minimum lease payments were required under operating leases at June 30, 2018:
Year Ending
Governmental Funds
2019
$
19,802.50
NOTE 12: SIGNIFICANT CONTINGENT LIABILITIES
FEDERAL GRANTS
Amounts received or receivable principally from the Federal government are subject to audit and review by grantor agencies. This could result in requests for reimbursement to the grantor agency for any costs which are disallowed under grant terms. Any disallowances resulting from the grantor audit may become a liability of the School District. However, the School District believes that such disallowances, if any, will be immaterial to its overall financial position.
LITIGATION
The School District is a defendant in various legal proceedings pertaining to matters incidental to the performance of routine School District operations. The ultimate disposition of these proceedings is not presently determinable but is not believed to have a material adverse effect on the financial condition of the School District.
NOTE 13: OTHER POST-EMPLOYMENT BENEFITS (OPEB)
GEORGIA SCHOOL PERSONNEL POST-EMPLOYMENT HEALTH BENEFIT FUND
Plan Description: Certified teachers and non-certified public school employees of the School District as defined in 20-2-875 of the Official Code of Georgia Annotated (O.C.G.A.) are provided OPEB through the School OPEB Fund - a cost-sharing multiple-employer defined benefit postemployment healthcare plan, reported as an employee trust fund and administered by a Board of Community Health (Board). Title 20 of the O.C.G.A. assigns the authority to establish and amend the benefit terms of the group health plan to the Board.
Benefits Provided: The School OPEB Fund provides healthcare benefits for retirees and their dependents due under the group health plan for public school teachers, including librarians, other certified employees of public schools, regional educational service agencies and non-certified public school employees. Retiree medical eligibility is attained when an employee retires and is immediately eligible to draw a retirement annuity from Employees' Retirement System (ERS), Georgia Judicial Retirement System (JRS), Legislative Retirement System (LRS), Teachers Retirement System (TRS) or Public School Employees Retirement System (PSERS). If elected, dependent coverage starts on the same day as retiree coverage. Medicare-eligible retirees are offered Standard and Premium Medicare Advantage plan options. Non-Medicare eligible retiree plan options include Health Reimbursement Arrangement (HRA), Health Maintenance Organization (HMO) and a High Deductible Health Plan (HDHP). The School OPEB Fund also pays for administrative expenses of the fund. By law, no other use of the assets of the School OPEB Fund is permitted.
Contributions: As established by the Board, the School OPEB Fund is substantially funded on a payas-you-go basis; that is, annual cost of providing benefits will be financed in the same year as claims occur. Contributions to the School OPEB Fund from the School District were $765,056.00 for the year ended June 30, 2018. Active employees are not required to contribute to the School OPEB Fund.
- 24 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
OPEB Liabilities, OPEB Expense, and Deferred Outflows of Resources and Deferred Inflows of Resources Related to OPEB
At June 30, 2018, the School District reported a liability of $20,768,510.00 for its proportionate share of the net OPEB liability. The net OPEB liability was measured as of June 30, 2017. The total OPEB liability used to calculate the net OPEB liability was based on an actuarial valuation as of June 30, 2016. An expected total OPEB liability as of June 30, 2017 was determined using standard roll-forward techniques. The School District's proportion of the net OPEB liability was actuarially determined based on employer contributions during the fiscal year ended June 30, 2017. At June 30, 2017, the School District's proportion was 0.147819%, which was an increase of 0.002910% from its proportion measured as of June 30, 2016.
For the year ended June 30, 2018, the School District recognized OPEB expense of $1,273,187.00. At June 30, 2018, the School District reported deferred outflows of resources and deferred inflows of resources related to OPEB from the following sources:
OPEB
Deferred Outflows of Resources
Deferred Inflows of Resources
Changes of assumptions
$
Net difference between projected and actual earnings on OPEB plan investments
- $ 1,581,469.00
6,074.00
-
Changes in proportion and differences
between School District contributions and
proportionate share of contributions
365,528.00
-
School District contributions subsequent to
the measurement date
765,056.00
-
Total
$ 1,136,658.00 $ 1,581,469.00
School District contributions subsequent to the measurement date of $765,056.00 are reported as deferred outflows of resources and will be recognized as a reduction of the net OPEB liability in the year ended June 30, 2019. Other amounts reported as deferred outflows of resources and deferred inflows of resources related to OPEB will be recognized in OPEB expense as follows:
Year Ended June 30:
OPEB
2019 2020 2021 2022 2023 2024
$ (217,176.00) $ (217,176.00) $ (217,176.00) $ (217,176.00) $ (218,695.00) $ (122,468.00)
- 25 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
Actuarial assumptions: The total OPEB liability as of June 30, 2017 was determined by an actuarial valuation as of June 30, 2016 using the following actuarial assumptions and other inputs, applied to all periods included in the measurement and rolled forward to the measurement date of June 30, 2017:
OPEB:
Inflation
2.75%
Salary increases
ERS
3.25% - 7.00%, including inflation
JRS
4.50%, including inflation
LRS
None
TRS
3.25 -- 9.00%, including inflation
PSERS
N/A
Long-term expected rate of return
Healthcare cost trend rate
3.88%, compounded annually, net of investment expense, and including inflation
Pre-Medicare Eligible Medicare Eligible
7.75% 5.75%
Ultimate trend rate
Pre-Medicare Eligible Medicare Eligible
5.00% 5.00%
Year of Ultimate trend rate
2022
Mortality rates were based on the RP-2000 Combined Mortality Table for Males or Females, as appropriate, with adjustments for mortality improvements based on Scale BB as follows:
For ERS, JRS and LRS members: The RP-2000 Combined Mortality Table projected to 2025
with projection scale BB and set forward 2 years or both males and females is used for the period after service retirement and for dependent beneficiaries. The RP-2000 Disabled Mortality Table projected to 2025 with projection scale BB and set back 7 years for males and set forward 3 years for females is used for the period after disability retirement.
For TRS members: The RP-2000 White Collar Mortality Table projected to 2025 with projection
scale BB (set forward 1 year for males) is used for death after service retirement and beneficiaries. The RP-2000 Disabled Mortality Table projected to 2025 with projection scale BB (set forward two years for males and four years for females) is used for death after disability retirement.
For PSERS members: The RP-2000 Blue-Collar Mortality Table projected to 2025 with
projection scale BB (set forward 3 years for males and 2 years for females) is used for the period after service retirement and for beneficiaries of deceased members. The RP-2000 Disabled Mortality Table projected to 2025 with projection scale BB (set forward 5 years for both males and females) is used for the period after disability retirement.
The actuarial assumptions used in the June 30, 2016 valuation were based on the results of an actuarial experience study for the pension systems, which covered the five-year period ending June 30, 2014.
- 26 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
Projection of benefits for financial reporting purposes are based on the substantive plan (the plan as understood by the employer and plan members) and include the types of benefits provided at the time of each valuation and the historical pattern of sharing of benefit costs between the employer and plan members to that point. The actuarial methods and assumptions used include techniques that are designed to reduce the effects of short-term volatility in actuarial accrued liabilities and the actuarial value of assets, consistent with the long-term perspective of the calculation.
Additionally, there was a change of assumption that affected measurement of the total OPEB liability since the prior measurement date. The methodology used to determine employee and retiree participation in the School OPEB Fund is based on their current or last employer payroll location. Current and former employees of public school districts, libraries, regional educational service agencies and community colleges are allocated to the School OPEB Fund irrespective of retirement system affiliation. In addition, the discount rate increased from 3.07% to 3.58%.
The long-term expected rate of return on OPEB plan investments was determined using a log-normal distribution analysis in which best-estimate ranges of expected future real rates of return (expected nominal returns, net of investment expense and the assumed rate of 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 are summarized in the following table:
Asset Class
Target Allocation
Long-Term Expected Real Rate of Return*
Local Government Investment Pool
100.00%
*Rate shown is net of the 2.75% assumed rate of inflation.
1.13%
Discount rate: In order to measure the total OPEB liability for the School OPEB Fund, a single equivalent interest rate of 3.58% was used as the discount rate. This is comprised mainly of the yield or index rate for 20 year tax-exempt general obligation municipal bonds with an average rating of AA or higher (3.56% per the Bond Buyers Index). The projection of cash flows used to determine the discount rate assumed that contributions from members and from the employer will be made at the current level as averaged over the last five years, adjusted for annual projected changes in headcount. Projected future benefit payments for all current plan members were projected through 2115. Based on these assumptions, the OPEB plan's fiduciary net position was projected to be available to make OPEB payments for inactive employees through year 2029. Therefore, the calculated discount rate of 3.58% was applied to all periods of projected benefit payments to determine the total OPEB liability.
Sensitivity of the District's proportionate share of the net OPEB liability to changes in the discount rate: The following presents the School District's proportionate share of the net OPEB liability calculated using the discount rate of 3.58%, as well as what the School District's proportionate share of the net OPEB liability would be if it were calculated using a discount rate that is 1-percentage-point lower (2.58%) or 1 percentage-point higher (4.58%) than the current discount rate:
Net OPEB Liability
1% Decrease (2.58%)
Current Discount Rate (3.58%)
1% Increase (4.58%)
$ 24,658,885.00 $
20,768,510.00 $ 17,698,216.00
- 27 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
Sensitivity of the District's proportionate share of the net OPEB liability to changes in the healthcare cost trend rates: The following presents the School District's proportionate share of the net OPEB
liability, as well as what the School District's proportionate share of the net OPEB liability would be if it
were calculated using healthcare cost trend rates that are 1-percentage-point lower or 1-percentage-
point higher than the current healthcare cost trend rates:
1% Decrease
Current Healthcare Cost Trend Rate
1% Increase
Net OPEB Liability
$ 17,214,729.00 $
20,768,510.00 $ 25,395,528.00
OPEB plan fiduciary net position: Detailed information about the OPEB plan's fiduciary net position is available in the Comprehensive Annual Financial Report (CAFR) which is publicly available at https://sao.georgia.gov/comprehensive-annual-financial-reports.
NOTE 14: RETIREMENT PLANS
The School District participates in various retirement plans administered by the State of Georgia, as further explained below.
TEACHERS RETIREMENT SYSTEM OF GEORGIA (TRS)
Plan Description: All teachers of the School District as defined in O.C.G.A 47-3-60 and certain other support personnel as defined by 47-3-63 are provided a pension through the Teachers Retirement System of Georgia (TRS). TRS, a cost-sharing multiple-employer defined benefit pension plan, is administered by the TRS Board of Trustees (TRS Board). Title 47 of the O.C.G.A. assigns the authority to establish and amend the benefit provisions to the State Legislature. The Teachers Retirement System of Georgia issues a publicly available separate financial report that can be obtained at www.trsga.com/publications.
Benefits Provided: TRS provides service retirement, disability retirement, and death benefits. Normal retirement benefits are determined as 2% of the average of the employee's two highest paid consecutive years of service, multiplied by the number of years of creditable service up to 40 years. An employee is eligible for normal service retirement after 30 years of creditable service, regardless of age, or after 10 years of service and attainment of age 60. Ten years of service is required for disability and death benefits eligibility. Disability benefits are based on the employee's creditable service and compensation up to the time of disability. Death benefits equal the amount that would be payable to the employee's beneficiary had the employee retired on the date of death. Death benefits are based on the employee's creditable service and compensation up to the date of death.
Contributions: Per Title 47 of the O.C.G.A., contribution requirements of active employees and participating employers, as actuarially determined, are established and may be amended by the TRS Board. Pursuant to O.C.G.A. 47-3-63, the employer contributions for certain full-time public school support personnel are funded on behalf of the employer by the State of Georgia. Contributions are expected to finance the costs of benefits earned by employees during the year, with an additional amount to finance any unfunded accrued liability. Employees were required to contribute 6% of their annual pay during fiscal year 2018. The School District's contractually required contribution rate for the year ended June 30, 2018 was 16.81% of annual School District payroll, of which 16.72% of payroll was required from the School District and 0.09% of payroll was required from the State. For the current fiscal year, employer contributions to the pension plan were $1,955,556.98 and $14,272.08 from the School District and the State, respectively.
PUBLIC SCHOOL EMPLOYEES RETIREMENT SYSTEM (PSERS)
Plan description: PSERS is a cost-sharing multiple-employer defined benefit pension plan established by the Georgia General Assembly in 1969 for the purpose of providing retirement allowances for public school employees who are not eligible for membership in the Teachers Retirement System of Georgia.
- 28 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
The ERS Board of Trustees, plus two additional trustees, administers PSERS. Title 47 of the O.C.G.A. assigns the authority to establish and amend the benefit provisions to the State Legislature. PSERS issues a publicly available financial report that can be obtained at www.ers.ga.gov/formspubs/formspubs.
Benefits provided: A member may retire and elect to receive normal monthly retirement benefits after completion of ten years of creditable service and attainment of age 65. A member may choose to receive reduced benefits after age 60 and upon completion of ten years of service.
Upon retirement, the member will receive a monthly benefit of $14.75, multiplied by the number of years of creditable service. Death and disability benefits are also available through PSERS. Additionally, PSERS may make periodic cost-of-living adjustments to the monthly benefits. Upon termination of employment, member contributions with accumulated interest are refundable upon request by the member. However, if an otherwise vested member terminates and withdraws his/her member contribution, the member forfeits all rights to retirement benefits.
Contributions: The general assembly makes an annual appropriation to cover the employer contribution to PSERS on behalf of local school employees (bus drivers, cafeteria workers, and maintenance staff). The annual employer contribution required by statute is actuarially determined and paid directly to PSERS by the State Treasurer in accordance with O.C.G.A. 47-4-29(a) and 60(b). Contributions are expected to finance the costs of benefits earned by employees during the year, with an additional amount to finance any unfunded accrued liability.
Individuals who became members prior to July 1, 2012 contribute $4 per month for nine months each fiscal year. Individuals who became members on or after July 1, 2012 contribute $10 per month for nine months each fiscal year. The State of Georgia, although not the employer of PSERS members, is required by statute to make employer contributions actuarially determined and approved and certified by the PSERS Board of Trustees. The current fiscal year contribution was $57,789.00.
Pension Liabilities, Pension Expense, and Deferred Outflows of Resources and Deferred Inflows of Resources Related to Pensions
At June 30, 2018, the School District reported a liability of $17,899,324.00 for its proportionate share of the net pension liability for TRS.
The TRS net pension liability reflected a reduction for support provided to the School District by the State of Georgia for certain public school support personnel. The amount recognized by the School District as its proportionate share of the net pension liability, the related State of Georgia support, and the total portion of the net pension liability that was associated with the School District were as follows:
School District's proportionate share of the net pension liability
$ 17,899,324.00
State of Georgia's proportionate share of the net pension liability associated with the School District
255,920.00
Total
$ 18,155,244.00
The net pension liability for TRS was measured as of June 30, 2017. The total pension liability used to calculate the net pension liability was based on an actuarial valuation as of June 30, 2016. An expected total pension liability as of June 30, 2017 was determined using standard roll-forward techniques. The School District's proportion of the net pension liability was based on contributions to TRS during the fiscal year ended June 30, 2017.
At June 30, 2017, the School District's TRS proportion was 0.096309%, which was a decrease of 0.000085% from its proportion measured as of June 30, 2016.
- 29 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
At June 30, 2018, the School District did not have a PSERS liability for a proportionate share of the net pension liability because of a Special Funding Situation with the State of Georgia, which is responsible for the net pension liability of the plan. The amount of the State's proportionate share of the net pension liability associated with the School District is $269,563.00.
The PSERS net pension liability was measured as of June 30, 2017. The total pension liability used to calculate the net pension liability was based on an actuarial valuation as of June 30, 2016. An expected total pension liability as of June 30, 2017 was determined using standard roll-forward techniques. The State's proportion of the net pension liability associated with the School District was based on actuarially determined contributions paid by the State during the fiscal year ended June 30, 2017.
For the year ended June 30, 2018, the School District recognized pension expense of $1,321,549.00 for TRS and $54,327.00 for PSERS and revenue of $8,282.00 for TRS and $54,327.00 for PSERS. The revenue is support provided by the State of Georgia. For TRS the State of Georgia support is provided only for certain support personnel.
At June 30, 2018, the School District reported deferred outflows of resources and deferred inflows of resources related to pensions from the following sources:
TRS
Deferred Outflows
Deferred Inflows
of Resources
of Resources
Differences between expected and actual experience
$
669,545.00 $
67,550.00
Changes of assumptions
392,375.00
-
Net difference between projected and actual earnings on pension plan investments
-
123,177.00
Changes in proportion and differences between School District contributions and proportionate share of contributions
-
1,426,031.00
School District contributions subsequent to the
measurement date
1,955,556.98
-
Total
$ 3,017,476.98 $ 1,616,758.00
The School District contributions subsequent to the measurement date of $1,955,556.98 for TRS are reported as deferred outflows of resources and will be recognized as a reduction of the net pension liability in the year ended June 30, 2019. Other amounts reported as deferred outflows of resources and deferred inflows of resources related to pensions will be recognized in pension expense as follows:
Year Ended June 30:
TRS
2019 2020 2021 2022 2023
$ (763,488.00) $ 419,014.00 $ 270,152.00 $ (491,054.00) $ 10,538.00
- 30 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
Actuarial assumptions: The total pension liability as of June 30, 2017 was determined by an actuarial valuation as of June 30, 2016, using the following actuarial assumptions, applied to all periods included in the measurement:
Teachers Retirement System:
Inflation
2.75%
Salary increases
3.25% 9.00%, average, including inflation
Investment rate of return
7.50%, net of pension plan investment expense, including inflation
Post-retirement mortality rates were based on the RP-2000 White Collar Mortality Table with future mortality improvement projected to 2025 with the Society of Actuaries' projection scale BB (set forward one year for males) for service requirements and dependent beneficiaries. The RP-2000 Disabled Mortality table with future mortality improvement projected to 2025 with Society of Actuaries' projection scale BB (set forward two years for males and four years for females) was used for the death after disability retirement. Rates of mortality in active service were based on the RP-2000 Employee Mortality Table projected to 2025 with projection scale BB.
The actuarial assumptions used in the June 30, 2016 valuation were based on the results of an actuarial experience study for the period July 1, 2009 June 30, 2014.
Public School Employees Retirement System:
Inflation
2.75%
Salary increases
N/A
Investment rate of return
7.50%, net of pension plan investment expense, including inflation
Post-retirement mortality rates were based on the RP-2000 Blue-Collar Mortality Table projected to 2025 with projection scale BB (set forward 3 years for males and 2 years for females) for the period after service retirements and for dependent beneficiaries. The RP-2000 Disabled Mortality projected to 2025 with projection scale BB (set forward 5 years for both males and females) was used for death after disability retirement. There is a margin for future mortality improvement in the tables used by the System. Based on the results of the most recent experience study adopted by the Board on December 17, 2015, the numbers of expected future deaths are 9-11% less than the actual number of deaths that occurred during the study period for healthy retirees and 9-11% less than expected under the selected table for disabled retirees. Rates of mortality in active service were based on the RP-2000 Employee Mortality Table projected to 2025 with projection scale BB.
The actuarial assumptions used in the June 30, 2016 valuation were based on the results of an actuarial experience study for the period July 1, 2009 June 30, 2014.
The long-term expected rate of return on TRS and PSERS pension plan investments was determined using a log-normal distribution analysis 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
- 31 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
by weighting the expected future real rates of return by the target asset allocation percentage and by adding expected inflation. The target asset allocation and best estimates of arithmetic real rates of return for each major asset class are summarized in the following table:
Asset class
TRS Target allocation
PSERS Target allocation
Long-term expected real rate of return*
Fixed income Domestic large stocks Domestic mid stocks Domestic small stocks International developed market stocks International emerging market stocks Alternative
Total
30.00% 39.80%
3.70% 1.50% 19.40% 5.60%
-
100.00%
30.00% 37.20%
3.40% 1.40% 17.80% 5.20% 5.00%
100.00%
(0.50)% 9.00% 12.00% 13.50% 8.00% 12.00% 10.50%
* Rates shown are net of the 2.75% assumed rate of inflation
Discount rate: The discount rate used to measure the total TRS and PSERS pension liability was 7.50%. The projection of cash flows used to determine the discount rate assumed that plan member contributions will be made at the current contribution rate and that employer and nonemployer contributions will be made at rates equal to the difference between actuarially determined contribution rates and the member rate. Based on those assumptions, the TRS and PSERS pension plan's fiduciary net position was projected to be available to make all projected future benefit payments of current plan members. Therefore, the long-term expected rate of return on pension plan investments was applied to all periods of projected benefit payments to determine the total pension liability.
Sensitivity of the School District's proportionate share of the net pension liability to changes in the discount rate: The following presents the School District's proportionate share of the net pension liability calculated using the discount rate of 7.50%, as well as what the School 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.50%) or 1-percentage-point higher (8.50%) than the current rate:
Teachers Retirement System:
1% Decrease (6.50%)
Current Discount Rate (7.50%)
1% Increase (8.50%)
School District's proportionate
share of the net pension liability
$ 29,374,891.00 $
17,899,324.00 $ 8,446,036.00
Pension plan fiduciary net position: Detailed information about the pension plan's fiduciary net
position is available in the separately issued TRS and PSERS financial report which is publicly available
at www.trsga.com/publications and http://www.ers.ga.gov/formspubs/formspubs.html.
- 32 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE BASIC FINANCIAL STATEMENTS
JUNE 30, 2018
EXHIBIT "I"
NOTE 15: RESTATEMENT OF PRIOR YEAR NET POSITION
For fiscal year 2018, the School District made prior period adjustments due to the adoption of GASB Statement No. 75, as described in "New Accounting Pronouncements", which requires the restatement of the June 30, 2017, net position in Governmental Activities. The result is a decrease in net position at July 1, 2017 of $20,705,190.00. This change is in accordance with generally accepted accounting procedures.
Net Position, July 1, 2017 as previously reported
$ 13,097,380.34
Prior Period Adjustment - Implementation of GASB No. 75: Net OPEB Liability (measurement date)
(21,475,928.00)
Deferred Outflows - School District's Contributions made during fiscal year 2017
770,738.00
Net Position, July 1, 2017, as restated
$ (7,607,809.66)
NOTE 16: SUBSEQUENT EVENTS
In the subsequent fiscal year, the School District issued general obligation bonds in the amount of $8,155,000.00. The proceeds from these bonds will be used for capital outlay projects.
- 33 -
(This page left intentionally blank)
BROOKS COUNTY BOARD OF EDUCATION REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF PROPORTIONATE SHARE OF THE NET PENSION LIABILITY TEACHERS RETIREMENT SYSTEM OF GEORGIA
FOR THE YEAR ENDED JUNE 30
SCHEDULE "1"
Year Ended
School District's proportion of the net pension liability
School District's proportionate share of the net pension liability
State of Georgia's proportionate share of the
net pension liability associated with the School
District
2018 2017 2016 2015
0.096309% $ 0.096394% $ 0.101210% $ 0.110036% $
17,899,324.00 $ 19,887,157.00 $ 15,408,217.00 $ 13,901,597.00 $
255,920.00 $ 384,151.00 $ 278,752.00 $ 235,239.00 $
Total
School District's covered payroll
School District's proportionate share of the net pension liability as a percentage of its covered
payroll
Plan fiduciary net position as a
percentage of the total pension liability
18,155,244.00 $ 20,271,308.00 $ 15,686,969.00 $ 14,136,836.00 $
11,217,119.89 10,777,661.78 10,913,977.00 11,225,888.00
159.57% 184.52% 141.18% 123.84%
79.33% 76.06% 81.44% 84.03%
This schedule is intended to show information for 10 years. Additional years will be displayed as they become available.
- 35 -
BROOKS COUNTY BOARD OF EDUCATION REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF PROPORTIONATE SHARE OF THE NET PENSION LIABILITY PUBLIC SCHOOLS EMPLOYEES RETIREMENT SYSTEM OF GEORGIA
FOR THE YEAR ENDED JUNE 30
SCHEDULE "2"
Year Ended
School District's proportion of the net
pension liability
School District's proportionate share of the
net pension liability
State of Georgia's proportionate share of the net pension liability
associated with the School District
2018 2017 2016 2015
0.00% $ 0.00% $ 0.00% $ 0.00% $
-
$
-
$
-
$
-
$
269,563.00 $ 367,668.00 $ 256,607.00 $ 224,650.00 $
Total
269,563.00 367,668.00 256,607.00 224,650.00
School District's covered payroll
$
800,291.35
$
848,481.80
$
895,553.70
$
914,943.32
School District's proportionate share of the net pension
liability as a percentage of its covered payroll
Plan fiduciary net position as a
percentage of the total pension liability
N/A
85.69%
N/A
81.00%
N/A
87.00%
N/A
88.29%
This schedule is intended to show information for 10 years. Additional years will be displayed as they become available.
- 36 -
BROOKS COUNTY BOARD OF EDUCATION REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF PROPORTIONATE SHARE OF THE NET OPEB LIABILITY
SCHOOL OPEB FUND FOR THE YEAR ENDED JUNE 30
SCHEDULE "3"
Year Ended
School District's proportion of the net OPEB liability
School District's proportionate share of the net OPEB liability
State of Georgia's proportionate share of the net OPEB liability
associated with the School District
2018
0.147819% $
20,768,510.00 $
-
$
Total
School District's covered-employee
payroll
School District's proportionate share of the net OPEB liability as
a percentage of its covered-employee
payroll
Plan fiduciary net position as a
percentage of the total OPEB liability
20,768,510.00 $ 10,203,839.42
203.54%
1.61%
This schedule is intended to show information for 10 years. Additional years will be displayed as they become available.
- 37 -
BROOKS COUNTY BOARD OF EDUCATION REQUIRED SUPPLEMENTARY INFORMATION
SCHEDULE OF CONTRIBUTIONS TEACHERS RETIREMENT SYSTEM OF GEORGIA
FOR THE YEAR ENDED JUNE 30
SCHEDULE "4"
Year Ended
2018 2017 2016 2015
Contractually required contribution
$
1,955,556.98
$
1,578,585.76
$
1,508,828.24
$
1,435,188.00
Contributions in relation to the contractually required
contribution
$
1,955,556.98
$
1,578,585.76
$
1,508,828.24
$
1,435,188.00
Contribution deficiency (excess)
$
-
$
-
$
-
$
-
School District's covered payroll
$
11,698,876.55
$
11,217,119.89
$
10,777,661.78
$
10,913,977.00
Contribution as a percentage of covered
payroll
16.72% 14.07% 14.00% 13.15%
This schedule is intended to show information for 10 years. Additional years will be displayed as they become available.
- 38 -
BROOKS COUNTY BOARD OF EDUCATION REQUIRED SUPPLEMENTARY INFORMATION
SCHEDULE OF CONTRIBUTIONS SCHOOL OPEB FUND
FOR THE YEAR ENDED JUNE 30
SCHEDULE "5"
Year Ended
2018 2017
Contractually required contribution
$
765,056.00
$
770,738.00
Contributions in relation to the contractually required
contribution
$
765,056.00
$
770,738.00
Contribution deficiency (excess)
$
-
$
-
School District's covered-employee
payroll
$ 11,135,226.72 $ 10,203,839.42
Contribution as a percentage of covered-
employee payroll
6.87% 7.55%
This schedule is intended to show information for 10 years. Additional years will be displayed as they become available.
- 39 -
BROOKS COUNTY BOARD OF EDUCATION NOTES TO THE REQUIRED SUPPLEMENTARY INFORMATION
FOR THE YEAR ENDED JUNE 30, 2018
SCHEDULE "6"
Teachers Retirement System
Changes of assumptions: In 2010 and later, the expectation of retired life mortality was changed to the RP 2000 Mortality Tables rather than the 1994 Group Annuity Mortality Table, which was used prior to 2010. In 2010, rates of withdrawal, retirement, disability and mortality were adjusted to more closely reflect actual experience. In 2010, assumed rates of salary increase were adjusted to more closely reflect actual and anticipated experience.
On November 1- 8, 2015, the Board adopted recommended changes to the economic and demographic assumptions utilized by the System. Primary among the changes were the updates to rates of mortality, retirement, disability, withdrawal and salary increases. The expectation of retired life mortality was changed to RP 2000 White Collar Mortality Table with future mortality improvement projected to 2025 with the Society of Actuaries' projection scale BB (set forward one year for males).
Public School Employees Retirement System
Changes of assumptions: In 2010 and later, the expectation of retired life mortality was changed to the RP 2000 Mortality Tables rather than the 1994 Group Annuity Mortality Table, which was used prior to 2010. In 2010, rates of withdrawal, retirement, disability and mortality were adjusted to more closely reflect actual experience.
- On December 17, 2015, the Board adopted recommended changes to the economic and demographic assumptions utilized by the System. Primary among the changes were the updates to rates of mortality, retirement and withdrawal. The expectation of retired life mortality was changed to the RP 2000 Blue Collar Mortality Table projected to 2025 with projection scale BB (set forward 3 years for males and 2 years for females).
School OPEB Fund
Changes of benefit terms: In June 30, 2010 actuarial valuation, there was a change of benefit terms to require Medicare-eligible recipients to enroll in a Medicare Advantage plan to receive the State subsidy.
Changes in assumptions: In the revised June 30, 2017 actuarial valuation, there was a change relating to employee allocation. Employees were previously allocated based on their Retirement System membership, and currently employees are allocated based on their current employer payroll location. Additionally, there were changes to the discount rate and an increase in the investment rate of return due to a longer-term investment strategy.
In the June 30, 2015 actuarial valuation, decremental and underlying inflation assumptions were changed to reflect the Retirement Systems' experience studies.
In the June 30, 2012 actuarial valuation, a data audit was performed and data collection procedures and assumptions were changed.
- 40 -
BROOKS COUNTY BOARD OF EDUCATION GENERAL FUND
SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL
YEAR ENDED JUNE 30, 2018
SCHEDULE "7"
REVENUES
Property Taxes Sales Taxes State Funds Federal Funds Charges for Services Investment Earnings Miscellaneous
Total Revenues
EXPENDITURES
Current Instruction Support Services Pupil Services Improvement of Instructional Services Educational Media Services General Administration School Administration Business Administration Maintenance and Operation of Plant Student Transportation Services Other Support Services Food Services Operation
Debt Service Principal
Total Expenditures
Excess of Revenues over (under) Expenditures
OTHER FINANCING SOURCES (USES)
Other Sources Other Uses
Total Other Financing Sources (Uses)
Net Change in Fund Balances
Fund Balances - Beginning
Adjustments
NONAPPROPRIATED BUDGETS
ORIGINAL (1)
FINAL (1)
ACTUAL AMOUNTS
VARIANCE OVER/UNDER
$
6,754,319.00 $
6,754,319.00 $
7,446,713.11 $
72,000.00
72,000.00
91,362.24
11,917,588.34
11,917,588.34
12,896,743.26
1,731,182.00
1,731,182.00
3,873,128.83
42,700.00
42,700.00
244,594.95
3,700.00
3,700.00
7,291.71
95,000.00
95,000.00
512,863.15
20,616,489.34
20,616,489.34
25,072,697.25
692,394.11 19,362.24
979,154.92 2,141,946.83
201,894.95 3,591.71
417,863.15
4,456,207.91
10,930,356.40
796,282.72 220,545.11 312,895.01 903,694.53 2,067,030.67 354,646.32 1,918,280.92 1,296,875.66
1,815,882.00
-
20,616,489.34
-
12,050,259.07
812,468.72 891,673.21 312,450.01 934,765.57 2,076,969.53 354,646.32 1,918,280.92 1,298,705.66
3,630,417.84
-
24,280,636.85
(3,664,147.51)
13,193,115.94
1,431,404.47 1,001,260.43
230,630.99 1,173,245.35 1,812,915.17
474,124.89 2,237,043.08 1,670,609.12
21,187.00 1,843,120.75
56,080.22
25,144,737.41
(72,040.16)
(1,142,856.87)
(618,935.75) (109,587.22)
81,819.02 (238,479.78) 264,054.36 (119,478.57) (318,762.16) (371,903.46)
(21,187.00) 1,787,297.09
(56,080.22)
(864,100.56)
3,592,107.35
-
22,050.00
-
(22,050.00)
-
(22,050.00)
-
22,050.00
-
-
-
-
-
(3,664,147.51)
(72,040.16)
3,592,107.35
-
5,107,684.98
4,840,490.82
(267,194.16)
-
(11,171.85)
-
11,171.85
Fund Balances - Ending
$
- $
1,432,365.62 $
4,768,450.66 $
3,336,085.04
Notes to the Schedule of Revenues, Expenditures and Changes in Fund Balances Budget and Actual
(1) Original and Final Budget amounts do not include the budgeted revenues or expenditures of the various principal accounts. The actual revenues and expenditures of the various principal accounts are $382,288.65 and $343,329.44, respectively.
The accompanying schedule of revenues, expenditures and changes in fund balances budget and actual is presented on the modified accrual basis of accounting which is the basis of accounting used in the presentation of the fund financial statements.
See notes to the basic financial statements.
- 41 -
BROOKS COUNTY BOARD OF EDUCATION SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
YEAR ENDED JUNE 30, 2018
SCHEDULE "8"
FUNDING AGENCY PROGRAM/GRANT
Agriculture, U. S. Department of Child Nutrition Cluster Pass-Through From Georgia Department of Education Food Services School Breakfast Program National School Lunch Program
Total U.S. Department of Agriculture
Education, U. S. Department of Special Education Cluster Pass-Through From Georgia Department of Education Special Education Grants to States Grants to States Preschool Grants
Total Special Education Cluster
Other Programs Pass-Through From Georgia Department of Education Career and Technical Education - Basic Grants to States Migrant Education - State Grant Program Migrant Education - State Grant Program Rural Education Rural Education Student Support and Academic Enrichment Program Supporting Effective Instruction State Grants Supporting Effective Instruction State Grants Title I Grants to Local Educational Agencies Title I Grants to Local Educational Agencies Twenty-First Century Community Learning Centers Twenty-First Century Community Learning Centers
Total Other Programs
Total U. S. Department of Education
Health and Human Services, U. S. Department of Child Care and Development Fund Cluster Pass-Through From Bright From the Start: Georgia Department of Early Care and Learning Child Care and Development Block Grant
CFDA NUMBER
PASSTHROUGH
ENTITY ID
NUMBER
EXPENDITURES IN PERIOD
10.553 10.555
18185GA324N1099 $ 18185GA324N1100
423,415.92 1,335,817.40
1,759,233.32
84.027 84.027 84.173
H027A160073 H027A170073 H173A160081
84.048 84.011 84.011 84.358 84.358 84.424A 84.367 84.367 84.010 84.010 84.287 84.287
V048A170010 S011A160011 S011A170011 S358B160010 S365B170010 S424A170011 S367A160001 S367A170001 S010A160010 S010A170010 S287C160010 S287C170010
65,082.00 257,524.25
900.00
323,506.25
35,540.91 8,444.00
38,731.67 5,967.00
33,946.56 42,875.15 73,262.00 28,142.15 139,329.00 850,865.43 71,196.00 915,550.97
2,243,850.84
2,567,357.09
93.575
24,300.00
Total Expenditures of Federal Awards
$
4,350,890.41
Notes to the Schedule of Expenditures of Federal Awards
Note 1. Basis of Presentation
The accompanying schedule of expenditures of federal awards (the "Schedule") includes the federal award activity of the Brooks County Board of Education (the "Board") under programs of the federal government for the year ended June 30, 2018. The information in this Schedule is presented in accordance with the 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). Because the Schedule presents only a selected portion of the operations of the Board, it is not intended to and does not present the financial position or changes in net position of the Board.
Note 2. Summary of Significant Accounting Policies
Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles in OMB Circular A-87, Cost Principles for State, Local, and Indian Tribal Governments , or the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards , wherein certain types of expenditures are not allowable or are limited as to reimbursement. The Board has elected not to use the 10-percent de minimis indirect cost rate as allowed under
See notes to the basic financial statements.
- 42 -
BROOKS COUNTY BOARD OF EDUCATION SCHEDULE OF STATE REVENUE YEAR ENDED JUNE 30, 2018
AGENCY/FUNDING
GRANTS Bright From the Start: Georgia Department of Early Care and Learning Pre-Kindergarten Program
Education, Georgia Department of Quality Basic Education Direct Instructional Cost Kindergarten Program Kindergarten Program - Early Intervention Program Primary Grades (1-3) Program Primary Grades - Early Intervention (1-3) Program Upper Elementary Grades (4-5) Program Upper Elementary Grades - Early Intervention (4-5) Program Middle School (6-8) Program High School General Education (9-12) Program Vocational Laboratory (9-12) Program Students with Disabilities Gifted Student - Category VI Remedial Education Program Alternative Education Program English Speakers of Other Languages (ESOL) Media Center Program 20 Days Additional Instruction Staff and Professional Development Principal Staff and Professional Development Indirect Cost Central Administration School Administration Facility Maintenance and Operations Mid-Term Adjustment Hold Harmless Amended Formula Adjustment Categorical Grants Pupil Transportation Regular State Bonds Nursing Services Education Equalization Funding Grant Other State Programs Food Services Math and Science Supplements Preschool Handicapped Program Teacher of the Year Teachers Retirement Vocational Education Vocational Supervisors
Office of the State Treasurer Public School Employees Retirement
See note to the basic financial statements.
SCHEDULE "9"
GOVERNMENTAL FUND TYPE GENERAL FUND
$
440,433.00
680,187.00 141,742.00 1,522,136.00 423,771.00 653,990.00 416,522.00 1,251,264.00 1,060,915.00 516,716.00 1,518,776.00 261,561.00 183,458.00
98,688.00 126,360.00 236,074.00
73,509.00 40,370.00
1,578.00
424,313.00 684,075.00 527,137.00
64,930.00 (180,005.00)
392,844.00 154,535.83
45,000.00 885,577.00
43,223.00 31,412.87
8,917.30 507.25
14,272.08 85,912.93
8,252.00
57,789.00
$ 12,896,743.26
- 43 -
(This page left intentionally blank)
BROOKS COUNTY BOARD OF EDUCATION SCHEDULE OF APPROVED LOCAL OPTION SALES TAX PROJECTS
YEAR ENDED JUNE 30, 2018
SCHEDULE "10"
PROJECT
ORIGINAL ESTIMATED
COST (1)
CURRENT ESTIMATED COSTS (2)
AMOUNT EXPENDED IN CURRENT
YEAR (3)
AMOUNT EXPENDED IN PRIOR YEARS (3)
TOTAL COMPLETION
COST
EXCESS PROCEEDS NOT
EXPENDED
The acquisition, construction and equipping
of a new high school in Brooks County and
a facility to house and service the School District's vehicles and
adding to, remodeling, renovating, improving, and equipping existing
educational buildings, properties, and other facilities of the School
District, and acquiring any necessary personal property and
equipment, including computers and related technology, safety and
security upgrades, and similar equipment.
$ 6,300,000.00 $ 25,186,010.56 $
- $ 24,598,677.00 $
- $
-
Retiring previously incurred general obligation debt
6,264,175.00
6,264,175.00
1,233,869.72
2,672,455.83
-
-
Improving existing educational facilities, including athletic facilities
550,000.00
550,000.00
-
-
-
-
Purchasing instructional and administrative technology
175,000.00
175,000.00
-
-
-
-
Purchasing textbooks
55,500.00
55,500.00
-
-
-
-
Purchasing school buses
320,000.00
320,000.00
-
-
-
-
Purchasing safety and security equipment
135,325.00
135,325.00
-
-
-
-
.
$ 13,800,000.00 $ 32,686,010.56 $ 1,233,869.72 $ 27,271,132.83 $
- $
-
ESTIMATED COMPLETION
DATE
6/30/2019 6/30/2019 6/30/2019 6/30/2019 6/30/2019 6/30/2019 6/30/2019
(1) The School District's original cost estimate as specified in the resolution calling for the imposition of the Local Option Sales Tax.
(2) The School District's current estimate of total cost for the projects. Includes all cost from project inception to completion.
(3) The voters of Brooks County approved the imposition of a 1% sales tax to fund the above projects and retire associated debt. Amounts expended for these projects may include sales tax proceeds, state, local property taxes and/or other funds over the life of the projects.
See notes to the basic financial statements.
- 45 -
SECTION II COMPLIANCE AND INTERNAL CONTROL REPORTS
Greg S. Griffin
STATE AUDITOR
(404) 656-2174
DEPARTMENT OF AUDITS AND ACCOUNTS
270 Washington Street, S.W., Suite 1-156 Atlanta, Georgia 30334-8400
March 24, 2020
The Honorable Brian P. Kemp, Governor of Georgia Members of the General Assembly of the State of Georgia Members of the State Board of Education
and Superintendent and Members of the Brooks County Board of Education
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
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 financial statements of the governmental activities, each major fund, and the aggregate remaining fund information of the Brooks County Board of Education (School District), as of and for the year ended June 30, 2018, and the related notes to the financial statements, which collectively comprise the School District's basic financial statements, and have issued our report thereon dated March 24, 2020.
Internal Control Over Financial Reporting
In planning and performing our audit of the financial statements, we considered the School District'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 the School District's internal control. Accordingly, we do not express an opinion on the effectiveness of the School District's internal control.
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 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. 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.
Our consideration of internal control was for the limited purpose described in the first paragraph of this section 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 have not been identified. We did identify certain deficiencies in internal control, described in the accompanying Schedule of Findings and Questioned Costs as items FS 2018-001 and FS 2018-002, that we consider to be material weaknesses.
Compliance and Other Matters
As part of obtaining reasonable assurance about whether the School District'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.
School District's Response to Findings
The School District's response to the findings identified in our audit is described in the accompanying Schedule of Findings and Questioned Costs. The School District'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 School District'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 School District's internal control and compliance. Accordingly, this communication is not suitable for any other purpose.
Respectfully submitted,
Greg S. Griffin State Auditor
Greg S. Griffin
STATE AUDITOR
(404) 656-2174
DEPARTMENT OF AUDITS AND ACCOUNTS
270 Washington Street, S.W., Suite 1-156 Atlanta, Georgia 30334-8400
March 24, 2020
The Honorable Brian P. Kemp, Governor of Georgia Members of the General Assembly of the State of Georgia Members of the State Board of Education
and Superintendent and Members of the Brooks County Board of Education
INDEPENDENT AUDITOR'S REPORT ON COMPLIANCE FOR EACH MAJOR FEDERAL PROGRAM AND ON INTERNAL CONTROL OVER COMPLIANCE REQUIRED BY THE UNIFORM GUIDANCE
Report on Compliance for Each Major Federal Program
We have audited the Brooks County Board of Education (School District) compliance with the types of compliance requirements described in the OMB Compliance Supplement that could have a direct and material effect on each of its major federal programs for the year ended June 30, 2018. The School District'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 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 the School District'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 the School District'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 the School District's compliance.
Basis for Qualified Opinion on Twenity-First Century Community Learning Centers (CFDA 84.287)
As described in the accompanying Schedule of Findings and Questioned Costs, the School District did not comply with requirements regarding Twenty-First Century Community Learning Centers (CFDA 84.287) as described in item FA 2018-002 for Reporting. Compliance with such requirements is necessary, in our opinion, for the School District to comply with requirements applicable to that program.
Qualified Opinion on Twenity-First Century Community Learning Centers (CFDA 84.287)
In our opinion, except for the noncompliance described in the Basis for Qualified Opinion paragraph, the School District complied, in all material respects, with the compliance requirements referred to above that could have a direct and material effect on Twenity-First Century Community Learning Centers (CFDA 84.287) for the year ended June 30, 2018.
Unmodified Opinion on Each of the Other Major Federal Programs
In our opinion, the School District 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, 2018.
Other Matters
The School District's response to the noncompliance findings identified in our audit is described in the accompanying Schedule of Findings and Questioned Costs. The School District'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 School District 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 School District'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 School District'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 a material weakness and a significant deficiency.
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 deficiency in internal control over compliance described in the accompanying Schedule of Findings and Questioned Costs as item FA 2018-002, to be a material weakness.
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 deficiency in internal control over compliance described in the accompanying Schedule of Findings and Questioned Costs as item FA 2018-001, to be a significant deficiency.
The School District's response to the internal control over compliance findings identified in our audit is described in the accompanying Schedule of Findings and Questioned Costs. The School District'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.
Respectfully submitted,
Greg S. Griffin State Auditor
SECTION III AUDITEE'S RESPONSE TO PRIOR YEAR FINDINGS AND QUESTIONED COSTS
BROOKS COUNTY BOARD OF EDUCATION AUDITEE'S RESPONSE
SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 2018
PRIOR YEAR FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS
FS 2016-001 Control Category: Internal Control Impact: Compliance Impact:
Financial Reporting Process Financial Reporting Material Weakness None
Finding Status:
Unresolved
Our staff continues to seek training and professional development to help eliminate reporting errors.
FS 2017-001 Control Category: Internal Control Impact: Compliance Impact:
Financial Reporting Process Financial Reporting Material Weakness None
Finding Status:
Unresolved
Our staff continues to seek training and professional development to help eliminate reporting errors.
FS 2016-002 Control Category:
Internal Control Impact: Compliance Impact:
Internal Control Procedures at Central Office Accounting Controls (Overall) Cash and Cash Equivalents Revenues/Receivables/Receipts Expenditures/Liabilities/Disbursements General Ledger Material Weakness None
Finding Status:
Unresolved
Brooks County Schools has experienced significant staff change-over and continues to seek additional training in order to develop more than adequate accounting controls in all areas.
FS 2017-002 Control Category:
Internal Control Impact: Compliance Impact:
Internal Control Procedures at Central Office Accounting Controls (Overall) Cash and Cash Equivalents Capital Assets Revenues/Receivables/Receipts Expenditures/Liabilities/Disbursements Debt and Debt Service General Ledger Material Weakness None
Finding Status:
Unresolved
Brooks County Schools has experienced significant staff change-over and continues to seek additional training in order to develop more than adequate accounting controls in all areas.
- 1 -
BROOKS COUNTY BOARD OF EDUCATION AUDITEE'S RESPONSE
SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 2018
PRIOR YEAR FEDERAL AWARD FINDINGS AND QUESTIONED COSTS
FA 2016-001 Compliance Requirement: Internal Control Impact: Compliance Impact: Federal Awarding Agency: Pass-Through Entity: CFDA Number and Title:
Time and Effort Support Allowable Cost/Cost Principles Material Weakness Material Noncompliance U.S. Department of Agriculture Georgia Department of Education CFDA 10.553 and 10.555 Child Nutrition Cluster
Finding Status:
Previously Reported Corrective Action Implemented
FA 2017-001 Compliance Requirements:
Internal Control Impact: Compliance Impact: Federal Awarding Agency: Pass-Through Entity: CFDA Number and Title:
Improve Controls over Expenditures Activities Allowed or Unallowed Allowable Cost/Cost Principles Procurement and Suspension and Debarment Significant Deficiency Nonmaterial Noncompliance U.S. Department of Agriculture Georgia Department of Education CFDA 10.553 and 10.555 Child Nutrition Cluster
Finding Status:
Previously Reported Corrective Action Implemented
FA 2014-003 Compliance Requirement: Internal Control Impact: Compliance Impact: Federal Awarding Agency: Pass-Through Entity: CFDA Number and Title:
Compliance with Equipment and Real Property Management Equipment and Real Property Management Significant Deficiency Nonmaterial Noncompliance U.S. Department of Agriculture Georgia Department of Education CFDA 10.553 and 10.555 Child Nutrition Cluster
Finding Status:
Unresolved
In May of each year the Director and Bookkeeper of SFS take an inventory of kitchen equipment. Each item is checked for working condition, proper location, and accurate decal numbers. The inventory is documented in a excel file that includes decal number, acquisition date, description, cost, location, condition, and date checked.
- 2 -
BROOKS COUNTY BOARD OF EDUCATION AUDITEE'S RESPONSE
SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 2018
PRIOR YEAR FEDERAL AWARD FINDINGS AND QUESTIONED COSTS
FA 2015-001 Compliance Requirements: Internal Control Impact: Compliance Impact: Federal Awarding Agency: Pass-Through Entity: CFDA Number and Title:
Compliance with Equipment and Real Property Management Equipment and Real Property Management Significant Deficiency Nonmaterial Noncompliance U.S. Department of Agriculture Georgia Department of Education CFDA 10.553 and 10.555 Child Nutrition Cluster
Finding Status:
Unresolved
In May of each year the Director and Bookkeeper of SFS take an inventory of kitchen equipment. Each item is checked for working condition, proper location, and accurate decal numbers. The inventory is documented in a excel file that includes decal number, acquisition date, description, cost, location, condition, and date checked.
FA 2016-002 Compliance Requirement: Internal Control Impact: Compliance Impact: Federal Awarding Agency: Pass-Through Entity: CFDA Number and Title:
Internal Control Procedures Equipment and Real Property Management Significant Deficiency Nonmaterial Noncompliance U.S. Department of Agriculture Georgia Department of Education CFDA 10.553 and 10.555 Child Nutrition Cluster
Finding Status:
Unresolved
In May of each year the Director and Bookkeeper of SFS take an inventory of kitchen equipment. Each item is checked for working condition, proper location, and accurate decal numbers. The inventory is documented in a excel file that includes decal number, acquisition date, description, cost, location, condition, and date checked.
FA 2017-002 Compliance Requirement: Internal Control Impact: Compliance Impact: Federal Awarding Agency: Pass-Through Entity: CFDA Number and Title:
Improve Controls over Equipment Equipment and Real Property Management Significant Deficiency Nonmaterial Noncompliance U.S. Department of Agriculture Georgia Department of Education CFDA 10.553 and 10.555 Child Nutrition Cluster
Finding Status:
Unresolved
In May of each year the Director and Bookkeeper of SFS take an inventory of kitchen equipment. Each item is checked for working condition, proper location, and accurate decal numbers. The inventory is documented in a excel file that includes decal number, acquisition date, description, cost, location, condition, and date checked.
- 3 -
BROOKS COUNTY BOARD OF EDUCATION AUDITEE'S RESPONSE
SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 2018
PRIOR YEAR FEDERAL AWARD FINDINGS AND QUESTIONED COSTS
FA 2017-003 Compliance Requirement: Internal Control Impact: Compliance Impact: Federal Awarding Agency: Pass-Through Entity: CFDA Number and Title:
Improve Controls over Journal Entries Period of Performance Material Weakness Material Noncompliance U.S. Department of Agriculture Georgia Department of Education CFDA 10.553 and 10.555 Child Nutrition Cluster
Finding Status:
Previously Reported Corrective Action Implemented
FA 2016-003 Compliance Requirement: Internal Control Impact: Compliance Impact: Federal Awarding Agency: Pass-Through Entity: CFDA Number and Title:
Internal Control Procedures Period of Performance Material Weakness Material Noncompliance U.S. Department of Agriculture Georgia Department of Education CFDA 10.553 and 10.555 Child Nutrition Cluster
Finding Status:
Previously Reported Corrective Action Implemented
- 4 -
SECTION IV FINDINGS AND QUESTIONED COSTS
BROOKS COUNTY BOARD OF EDUCATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS
YEAR ENDED JUNE 30, 2018
I SUMMARY OF AUDITOR'S RESULTS
Financial Statements
Type of auditor's report issue: Governmental Activities; General Fund; Capital Projects Fund; Debt Service Fund; Aggregate Remaining Fund Information
Unmodified
Internal control over financial reporting: Material weaknesses identified? Significant deficiency identified?
Yes None Reported
Noncompliance material to financial statements noted:
No
Federal Awards
Internal Control over major programs:
Material weakness identified?
Yes
Significant deficiencies identified?
Yes
Type of auditor's report issued on compliance for major programs: Unmodified for all major programs except for Twenty-first Century Community Learning Centers, which was qualified.
Any audit findings disclosed that are required to be reported in
accordance with 2 CFR 200.516(a)?
No
Identification of major programs:
CFDA Numbers
Name of Federal Program or Cluster
10.553, 10.555 84.287
Child Nutrition Cluster Twenty-First Century Community Learning Centers
Dollar threshold used to distinguish between Type A and Type B programs:
$750,000.00
Auditee qualified as low-risk auditee?
No
- 1 -
BROOKS COUNTY BOARD OF EDUCATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS
YEAR ENDED JUNE 30, 2018
II FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS
FS 2018-001
Financial Reporting Process
Control Category:
Financial Reporting
Internal Control Impact:
Material Weakness
Compliance Impact:
None
Repeat of Prior Year Findings: FS 2017-001, FS 2016-001
Description: The School District did not have adequate internal controls in place over the financial statement reporting process.
Criteria: Management is responsible for having adequate controls over the preparation of financial statements in accordance with generally accepted accounting principles (GAAP). The School District's internal controls over GAAP financial reporting should include adequately trained personnel with the knowledge, skills and experience to prepare GAAP based financial statements and include all disclosures as required by the Governmental Accounting Standards Board (GASB).
GASB Statement No. 34, Basic Financial Statements - Management's Discussion and Analysis for State and Local Governments (Statement), requires governments to present government-wide and fund financial statements as well as a summary reconciliation of the (a) total governmental funds balances to the net position of governmental activities in the Statement of Net Position, and (b) total change in governmental fund balances to the change in the net position of governmental activities in the Statement of Activities. In addition, the Statement requires information about the government's major and nonmajor funds in the aggregate, to be provided in the fund financial statements.
Chapter II Section 2, Annual Financial Reporting of the Financial Management for Georgia Local Units of Administration provides that School Districts must prepare their financial statements in accordance with generally accepted accounting principles.
Condition: The following errors and omissions were noted in the School District's financial statements as presented for audit:
A material audit adjustment totaling $11,759,598.27 was proposed and accepted by the client to correctly record the liability under an energy efficiency lease and the assets held on behalf of the School District by an escrow agent in the government-wide and governmental fund financial statements.
A material reclassification entry totaling $4,803,565.72 was proposed and accepted by the client to properly classify net position restricted for debt service and unrestricted net position in the government-wide financial statements.
A significant audit adjustment totaling $1,130,088.25 was proposed and accepted by the client to correctly record capital assets in the government-wide financial statements.
A significant audit adjustment totaling $1,186,080.22 was proposed and accepted by the client to correctly record long-term liabilities due within one year associated with bond debt and capital leases and interest expense associated with the capital lease in the governmentwide financial statements.
A material reclassification entry totaling $16,695,817.36 was proposed and accepted by the client to properly classify net position between net investment in capital assets and unrestricted net position in the government-wide financial statements.
- 2 -
BROOKS COUNTY BOARD OF EDUCATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS
YEAR ENDED JUNE 30, 2018
II FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS
A material reclassification entry totaling $4,885,620.82 was proposed and accepted by the client to properly classify net position between unrestricted net position and net position restricted for capital projects in the government-wide financial statements.
A material reclassification entry totaling $615,548.39 was proposed and accepted by the client to properly classify fund balance between restricted for debt service and unassigned in the capital projects fund on the governmental fund financial statements.
A material reclassification entry totaling $4,785,836.90 was proposed and accepted by the client to properly classify fund balance between restricted for capital projects and unassigned in the capital projects fund on the governmental fund financial statements.
A material audit adjustment totaling $28,141.54 was proposed and accepted by the client to correctly present cash and cash equivalents in the agency fund on the fiduciary financial statements.
Numerous other audit adjustments and reclassifications entries were proposed and accepted by management to properly present the School District's financial statements.
Cause: In discussing these deficiencies with the School District, they indicated the errors occurred due to oversights in preparing the financial statements and employee turnover in the Finance Department.
Effect or Potential Effect: Material misstatements were included in the financial statements presented for audit. The lack of controls and monitoring could impact the reporting of the School District's financial position and results of operations.
Recommendation: The School District should strengthen their internal controls and preparation and review procedures over financial reporting to ensure that the financial statements, including disclosures and schedules presented for audit are complete and accurate. These procedures should be performed by a properly trained individual(s) possessing a thorough understanding of GAAP, the applicable GASB pronouncements and knowledge of the School District's activities and operations. The School District should also consider implementing the use of a review checklist to assist in the review process over the financial statements.
Views of Responsible Officials: We concur with this finding.
FS 2018-002
Internal Control Procedures at Central Office
Control Category:
Accounting Controls (Overall)
Cash and Cash Equivalents
Capital Assets
Revenues/Receivables/Receipts
Expenditures/Liabilities/Disbursements
Debt and Debt Service
General Ledger
Internal Control Impact:
Material Weakness
Compliance Impact:
None
Repeat of Prior Year Findings: FS 2017-002, FS 2016-002
- 3 -
BROOKS COUNTY BOARD OF EDUCATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS
YEAR ENDED JUNE 30, 2018
II FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS
Description: The accounting procedures of the School District were insufficient to provide adequate internal controls over numerous control categories.
Criteria: The School District's management is responsible for designing and maintaining an adequate system of internal controls that provide reasonable assurance that transactions are processed according to established procedures. Such internal controls would limit any one individual's access to both physical assets and the related accounting records.
Condition: Accounting Controls (Overall)
The School District does not have adequate logical access controls in place to protect the integrity of information maintained in significant financial applications including no formal policy for managing user access to the financial system and supporting infrastructure. In addition, for the financial application system and food service point of sale system, we noted users with access rights that exceeded their need to complete their assigned job functions. Further, the access granted did not adequately separate the functions of initiating, authorizing, and recording transactions, reconciliations, and maintaining the custody of assets. Lastly, it was noted that recovery procedures are not adequate.
Cash and Cash Equivalents A review of twenty bank reconciliations revealed the following deficiencies: One bank reconciliation did not have evidence of proper preparer and approver. Two bank reconciliations did not have adequate documentation to support the outstanding check and wire amounts on the reconciliations. The deposits in transit on the June 30th bank reconciliation for one account do not tie to the deposits that cleared on the July bank statement. The amount of cash and cash equivalents included on the fiduciary financial statements for school activity accounts in the agency fund did not agree to the amounts of cash and cash equivalents on the general ledger reports from the schools. The amount of cash in the general ledger does not agree to the amount of cash per ledger on several bank reconciliations or for the private purpose trust fund cash and cash equivalents.
Capital Assets The School District did not maintain an updated capital asset listing. A review of twenty-two capital outlay expenditures and potential capital outlay expenditures revealed the following deficiencies: Three purchases did not have proper documentation. Six purchases did not have evidence of proper approval. Capital outlay expenditures were not properly recorded in the general ledger. The School District is not following its purchasing policy regarding Board approval of purchases over $25,000.00. The School District is not following its capital asset policy regarding depreciation of assets. Four assets were fully depreciated that should have had a remaining book value at the end of the year under review.
- 4 -
BROOKS COUNTY BOARD OF EDUCATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS
YEAR ENDED JUNE 30, 2018
II FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS
Revenues/Receivables/Receipts The School District booked invalid accounts receivable pertaining to several federal programs totaling $224,685.42. The auditor reviewed Student Activity receipts and found that one gate receipt reconciliation did not reconcile.
Expenditures/Liabilities/Disbursements A review of twenty-three current year expenditures revealed the following deficiencies: Five expenditures lacked proper documentation. One expenditure lacked proper evidence of approval. One expenditure lacked a purchase order. The credit card payment made in December was reviewed. Three of the credit card charges did not include receipts or invoices to support the charges and one charge did not include evidence of proper approval. During review of twenty-four subsequent period expenditures, the School District could not provide adequate documentation for six expenditures.
Employee Compensation A review and recalculation of salary was completed for twenty-one employees and revealed the following deficiencies: The entity could not provide documentation for some payments to two employees. This resulted in a combined potential overpayment to the employees of $2,045.86. The entity could not provide documentation for a raise given to one employee. This resulted in an overpayment of $6,000.00. Two employees were paid as transportation employees. There was not evidence of the Transportation Director's approval on the employee timesheets for multiple months.
Debt and Debt Service The School District did not properly account for a capital lease for buses. The School District did not properly account for an energy efficiency lease.
General Ledger A review of the State and Federal grant fund balances revealed that five federal grants were not properly closed out at year-end resulting in deficit fund balances for the five federal grants. A review of thirty-two journal entries revealed the following deficiencies: Nine journal entries did not have evidence of proper preparer and approver. Eight journal entries did not have adequate documentation.
Cause: In discussing this deficiency with the School District, they stated that turnover in the Finance Department was the cause of this deficiency.
Effect or Potential Effect: Without satisfactory accounting controls and procedures in place, the School District could place itself in a position where potential misappropriation of assets could occur. In addition, the lack of controls impacted its reporting of financial position and results of operations.
- 5 -
BROOKS COUNTY BOARD OF EDUCATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS
YEAR ENDED JUNE 30, 2018
II FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS
Recommendation: The School District should review accounting procedures in place and design and implement procedures relative to the above controls categories to strengthen the internal controls over the accounting functions. Management should ensure that proper separation of duties exist. In the case when management determines that separation of duties is not cost beneficial, management should implement compensation controls that assist in assuring that transactions are properly processed and reported.
Views of Responsible Officials: We concur with this finding.
III FEDERAL AWARD FINDINGS AND QUESTIONED COSTS
FA 2018-001
Improve Controls over Equipment
Compliance Requirement: Equipment and Real Property Management
Internal Control Impact:
Significant Deficiency
Compliance Impact:
Nonmaterial Noncompliance
Federal Awarding Agency: U.S. Department of Agriculture
Pass-Through Entity:
Georgia Department of Education
CFDA Number and Title:
CFDA 10.553 and 10.555 Child Nutrition Cluster
Federal Award Numbers: 18185GA324N1099 and 18185GA324N1100
Questioned Costs:
None Identified
Repeat of Prior Year Findings: FA 2017-002, FA 2016-002, FA 2015-001, FA 2014-003
Description: The policies and procedures of the School District were insufficient to provide adequate internal controls over equipment and real property management as it relates to the Child Nutrition Cluster.
Criteria: 2 CFR 200.313(d)(1) states, "Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property." In addition, 2 CFR 200.313(d)(2) states, "A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years."
Condition: The following deficiencies were noted when reviewing the Child Nutrition Cluster equipment listing:
Property records did not consistently include the required component of use and condition of the property.
One piece of equipment purchased during the prior year with Child Nutrition Cluster funds did not appear to be reported on the equipment listing.
Cause: In discussing this deficiency with management, they stated that the deficiencies occurred due to turnover in the School Nutrition Department. New School Nutrition Department staff were unaware of all of the components required to be reflected within the property records.
- 6 -
BROOKS COUNTY BOARD OF EDUCATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS
YEAR ENDED JUNE 30, 2018
III FEDERAL AWARD FINDINGS AND QUESTIONED COSTS
Effect or Potential Effect: Failure to maintain a complete and accurate equipment listing and reconcile results of the physical inventory performed to the property records exposes the School District to unnecessary risk of error and misuse of equipment and/or Federal funds. Additionally, the School District is not in compliance with the Uniform Guidance and Georgia Department of Education guidance.
Recommendation: The School District should strengthen controls over Child Nutrition equipment to ensure that the equipment records are complete and accurate. Management should update the equipment listing to reflect all required information, including a description, an identifying number, the source of funding, the title holder, the acquisition date, the cost, the percentage of federal participation in the project costs, the location, the use and condition, and any ultimate disposal data for each piece of equipment. Management should perform a physical inventory of equipment at least once every two years and reconcile the results of the physical inventory to the Child Nutrition equipment listing.
Views of Responsible Officials: We concur with this finding.
FA 2018-002 Compliance Requirement: Internal Control Impact: Compliance Impact: Federal Awarding Agency: Pass-Through Entity: CFDA Number and Title: Federal Award Numbers: Questioned Costs:
Improve Controls over Financial Reporting Reporting Material Weakness Material Noncompliance U.S. Department of Education Georgia Department of Education CFDA 84.287 Twenty-First Century Community Learning Centers S287C160010 and S287C170010 None Identified
Description: The School District did not file accurate completion reports for the Twenty-First Century Community Learning Centers program.
Criteria: 2 CFR 200.302(a) states in part that "the non-Federal entity's financial management systems must... be sufficient to permit the preparation of reports required by general and program-specific terms and conditions." In addition, 2 CFR 200.302(b)(2) states in part that the non-Federal entity's financial management systems must provide for "accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements."
Furthermore, 2 CFR 200.303(a) states in part that the "non-Federal must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the nonFederal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award... (c) Evaluate and monitor the non-Federal entity's compliance with statutes, regulations and the terms and conditions of Federal awards."
Condition: A review of the School District's accounting records and the program completion reports revealed that the amounts reported on the completion reports did not agree to the general ledger. The correct amounts could not be determined due to the way in which expenditures for the program and various grant periods are booked by the entity on the general ledger.
- 7 -
BROOKS COUNTY BOARD OF EDUCATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS
YEAR ENDED JUNE 30, 2018 III FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Cause: In discussing this deficiency with management, they stated that the deficiencies occurred due to turnover in the Finance Department. Effect or Potential Effect: Failure to accurately report Federal award expenditures through the completion report process could lead to the filing of reimbursement requests that do not agree to actual expenditures. Therefore, the School District may obtain more or less Federal funding than they were eligible to receive. Additionally, the School District is not in compliance with the Uniform Guidance and Georgia Department of Education guidance. Recommendation: The School District should revise and implement internal control procedures to ensure that completion reports submitted to the Georgia Department of Education are supported by the accounting records and reimbursement requests are prepared based upon actual expenditures incurred. In addition, management should develop and implement a monitoring process to ensure that control procedures are being followed. Views of Responsible Officials: We concur with this finding.
- 8 -
SECTION V MANAGEMENT'S CORRECTIVE ACTION