DOUGLAS COUNTY BOARD OF EDUCATION ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED JUNE 30, 2018 DOUGLAS COUNTY BOARD OF EDUCATION ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED JUNE 30, 2018 TABLE OF CONTENTS I. Financial Section Independent Auditor's Report Management's Discussion and Analysis Basic Financial Statements: Government-wide Financial Statements: Statement of Net Position Statement of Activities Fund Financial Statements: Balance Sheet Governmental Funds Reconciliation of the Governmental Funds Balance Sheet to the Statement of Net Position Statement of Revenues, Expenditures, and Changes in Fund Balances Governmental Funds Reconciliation of the Statement of Revenues, Expenditures, and Changes in Fund Balances of Governmental Funds to the Statement of Activities General Fund Statement of Revenues, Expenditures, and Changes in Fund Balances Budget and Actual Statement of Fiduciary Assets and Liabilities Agency Fund Notes to the Basic Financial Statements II. Required Supplementary Information Schedule of Proportionate Share of Net Pension Liability Teachers Retirement System of Georgia Schedule of Contributions Teachers Retirement System of Georgia Schedule of Proportionate Share of Net Pension Liability Public School Employees Retirement System of Georgia Schedule of Proportionate Share of Net OPEB Liability School OPEB Fund Schedule of Contributions School OPEB Fund Notes to Required Supplementary Information III. Other Supplementary Information Schedule of Expenditures of Special Purpose Local Option Sales Tax Proceeds IV. Single Audit Section 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 Schedule of Expenditures of Federal Awards Schedule of Findings and Questioned Costs Schedule of Prior Audit Findings Page 1-3 4-10 11 12 13 14 15 16 17 18 19-54 55 56 57 58 59 60 61 62 and 63 64-66 67 and 68 69 and 70 71 I. FINANCIAL SECTION INDEPENDENT AUDITOR'S REPORT To the Superintendent and Members of the Douglas County Board of Education Douglasville, Georgia 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 Douglas County Board of Education as of and for the year ended June 30, 2018, and the related notes to the financial statements, which collectively comprise the Douglas County Board of Education'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. 200 GALLERIA PARKWAY S.E., SUITE 1700 ATLANTA, GA 30339-5946 770-955-8600 800-277-0080 FAX 770-980-4489 www.mjcpa.com Members of The American Institute of Certified Public Accountants 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 governmental activities, each major fund, and the aggregate remaining fund information of the Douglas County Board of Education as of June 30, 2018, and the respective changes in financial position, and the budgetary comparison for the General Fund, for the year then ended in accordance with accounting principles generally accepted in the United States of America. Emphasis of Matter As discussed in Notes 15 and 17, the Douglas County Board of Education implemented Governmental Accounting Standards Board (GASB) Statement No. 75, Accounting and Financial Reporting for Postemployment Benefits Other Than Pensions, as of July 1, 2017. This standard significantly changed the accounting for the Douglas County Board of Education's net other postemployment benefits (OPEB) liability and the related disclosures. Our opinions are not modified with respect to this matter. Other Matters Required Supplementary Information Accounting principles generally accepted in the United States of America require that the Management's Discussion and Analysis, Schedule of Proportionate Share of Net Pension Liability Teachers Retirement System of Georgia, Schedule of Contributions Teachers Retirement System of Georgia, Schedule of Proportionate Share of Net Pension Liability Public School Employees Retirement System of Georgia, Schedule of Proportionate Share of Net OPEB Liability School OPEB Fund, and Schedule of Contributions School OPEB Fund, as 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. 2 Other Information Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the Douglas County Board of Education's basic financial statements. The schedule of expenditures of special purpose local option sales tax proceeds, as required by the Official Code of Georgia 48-8-121, and the schedule of expenditures of federal awards, 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, as listed in the table of contents, are presented for purposes of additional analysis and are not a required part of the basic financial statements. The schedule of expenditures of special purpose local option sales tax proceeds and the schedule of expenditures of federal awards (collectively "the supplementary information") are the responsibility of management and were derived from and relate directly to the underlying accounting and other records used to prepare the basic financial statements. Such information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or to the basic financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the supplementary information is fairly stated, in all material respects, in relation to the basic financial statements as a whole. Other Reporting Required by Governmental Auditing Standards In accordance with Government Auditing Standards, we have also issued our report dated December 11, 2018 on our consideration of the Douglas County Board of Education'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 Douglas County Board of Education'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 Douglas County Board of Education's internal control over financial reporting and compliance. Atlanta, Georgia December 11, 2018 3 DOUGLAS COUNTY BOARD OF EDUCATION MANAGEMENT'S DISCUSSION AND ANALYSIS FOR THE FISCAL YEAR ENDED JUNE 30, 2018 Our discussion and analysis of the Douglas County Board of Education's ("School District") financial performance provides an overall review of the School District's financial activities for the fiscal year ended June 30, 2018. The intent of this discussion and analysis is to look at the School District's financial performance as a whole; readers should also review the financial statements and the notes to the basic financial statements to enhance their understanding of the School District's financial performance. Financial Highlights Key financial highlights for fiscal year 2018 are as follows: Net position decreased approximately $3.6 million, which represents an 8.5 percent decrease from fiscal year 2017. The decrease in net position is mainly due to the increase in net pension and OPEB (other postemployment benefits other than pensions). It is also important to note that there was a prior period restatement for GASB Statement No. 75 Accounting and Financial Reporting for Postemployment Benefits Other Than Pensions. General revenues accounted for approximately $127.9 million in revenue or 41.8 percent of all revenues. Program specific revenues in the form of charges for services and sales, grants and contributions accounted for approximately $178.4 million or 58 percent of total revenues. Total revenues were approximately $306.3 million. Total revenues increased approximately $12.8 million from fiscal year 2017 due to the increase in property taxes and state funding. The School District had $309.9 million in expenses related to governmental activities; only approximately $178.4 million of these expenses were offset by program specific charges for services, grants or contributions. Using the Basic Financial Statements This annual report consists of management's discussion and analysis, a series of financial statements and notes to those statements. These statements are organized so the reader can understand the Douglas County School District as a financial whole, or as an entire operating entity. The district-wide financial statements include the Statement of Net Position and Statement of Activities. These statements provide information about the activities of the School District, presenting both an aggregate view of the School District's finances and a longer-term view of those finances. The fund financial statements provide the next level of detail. For governmental funds, these statements tell how services were financed in the short-term as well as what remains for future spending. The fund financial statements also look at the School District's most significant funds. In the case of the Douglas County School District, the General Fund, District-wide Capital Projects Fund, and Debt Service Fund are the most significant funds. 4 District-Wide Statements The District-Wide financial statements are a consolidation of the District's operating funds into one column, with both short and long-term focus, called governmental activities. While these documents contain the large number of funds used by the District to provide programs and activities, the view of the District as a whole looks at all financial transactions and asks the question, "How did we do financially during fiscal year 2018?" The Statement of Net Position and the Statement of Activities answer this question. These statements include all assets, all deferred outflows of resources, all liabilities, and all deferred inflows of resources, using the accrual basis of accounting similar to the accounting used by most private-sector companies. This basis of accounting takes into account all of the current year's revenues and expenses regardless of when cash is received or paid. These two statements report the District's net position and changes in net position. This change in net position is important because it tells the reader whether, for the District as a whole, the financial position of the School District has improved or diminished. The causes of this change may be the result of many factors, some financial, some not. Non-financial factors include the District's property tax base, facility conditions, required educational programs and other factors. In the Statement of Net Position and the Statement of Activities, the District has one distinct type of activity: Governmental Activities - All of the District's programs and services are reported here including instruction, support services, operation and maintenance of plant, pupil transportation, food service, after school program, school activity accounts and various others. Fund Financial Statements Fund financial reports provide detailed information about the District's major funds. The District uses many funds to account for a multitude of financial transactions. However, these fund financial statements focus on the District's most significant funds. The District's major governmental funds are the general fund, the district-wide capital projects fund, and the debt service fund. Governmental Funds Most of the District's activities are reported in governmental funds, which focus on how money flows into and out of those funds and the balances left at year-end available for spending in future periods. These funds are reported using an accounting method called modified accrual accounting, which measures cash and all other financial assets that can readily be converted to cash. The governmental fund statements provide a detailed short-term view of the District's general government operations and the basic services it provides. Governmental fund information helps you determine whether there are more or fewer financial resources that can be spent in the near future to finance educational programs. The relationship (or differences) between governmental activities (reported in the Statement of Net Position and the Statement of Activities) and governmental funds is reconciled in the financial statements. Fiduciary Funds The District is the trustee, or fiduciary, for assets that belong to others, such as school clubs and organizations within the school activity accounts. The District is responsible for ensuring that the assets reported in these funds are used only for their intended purposes and by those to whom the assets belong. The District excludes these activities from the district-wide financial statements because it cannot use these assets to finance its operations. 5 FINANCIAL ANALYSIS OF THE SCHOOL DISTRICT AS A WHOLE The perspective of the Statement of Net Position is of the District as a whole. Table 1 provides a summary of the District's net position for fiscal year 2018 compared to fiscal year 2017. Assets Current and Other Assets Capital Assets, Net Total Assets Governmental Activities Fiscal Fiscal Year 2018 Year 2017 $ 123,159,243 392,639,248 515,798,491 $ 129,401,854 401,858,843 531,260,697 Deferred outflows of resources 52,284,177 79,542,279 Liabilities Current and Other Liabilities Long-Term Liabilities Total Liabilities 62,926,901 528,642,424 591,569,325 65,086,961 582,732,845 647,819,806 Deferred inflows of resources 22,648,128 5,488,713 Net position Net investment in capital assets Restricted Unrestricted Total net position 264,208,329 39,971,841 (350,314,955) $ (46,134,785) 259,621,844 44,004,925 (346,132,312) $ (42,505,543) Total net position decreased approximately $3.6 million. For fiscal year 2018, the net position decreased due to an increase in net pension and OPEB liabilities. Table 2 shows the changes in net position for fiscal year 2018 compared to the changes in net position for fiscal year 2017. 6 Change in Net Position Table 2 Revenues Program Revenues: Charges for Services and Sales Operating Grants and Contributions Capital Grants and Contributions Total Program Revenues General Revenues: Taxes Property Taxes For M aintenance and Operations For Debt Service Sales Taxes Special Purpose Local Option Sales Tax For Debt Service For Capital Projects Other Taxes Grants and Contributions not Restricted to Specific Programs Investment Earnings Total General Revenues Governmental Activities Fiscal Fiscal Year 2018 Year 2017 $ 5,588,189 172,391,701 432,520 178,412,410 $ 5,662,132 166,947,844 2,241,157 174,851,133 73,474,914 4,465,995 68,142,509 4,158,983 14,117,388 10,202,429 8,441,142 16,983,259 236,119 127,921,246 15,777,102 7,057,878 7,601,614 15,752,532 128,098 118,618,716 Total Revenues Program Expenses Instruction Support Services Pupil Services Improvement of Instructional Services Educational M edia Services Federal Grant Administration General Administration School Administration Business Administration M aintenance and Operations of Plant Student Transportation Services Central Support Services Other Support Services Operations of Non-Instructional Services M iscellaneous Non-Instructional Services Food Services Operation Interest on Long-Term Debt Total Expenses Change in Net Position Net Position, Beginning of Year Restatement Net Position, End of Year 306,333,656 293,469,849 200,913,104 191,048,959 9,044,723 7,088,978 5,499,822 453,225 2,532,110 19,092,360 3,791,930 19,141,662 14,120,581 4,981,811 1,998,621 8,742,429 7,581,297 5,355,582 420,837 2,596,470 18,140,245 3,034,992 18,101,192 13,911,325 3,943,774 2,278,541 1,498,150 15,546,360 4,259,461 309,962,898 (3,629,242) (42,505,543) $ (46,134,785) 1,405,020 15,714,992 5,949,149 298,224,804 (4,754,955) 159,914,928 (197,665,516) $ (42,505,543) 7 Governmental Activities Instruction comprises 64.8 percent of governmental program expenses. Interest expense comprises 1.4 percent of governmental program expenses. Interest expense was attributable to the outstanding bonds for capital projects. The Statement of Activities shows the cost of program services and the charges for services and grants offsetting those services. Table 3 shows, for governmental activities, the total cost of services and the net cost of services. That is, it identifies the cost of these services supported by tax revenue and unrestricted State entitlements. Table 3 Governmental Activities Total Cost of Services Fiscal Fiscal Year 2018 Year 2017 Net Cost of Services Fiscal Fiscal Year 2018 Year 2017 Instruction Support Services Pupil Services Improvement of Instructional Services Educational Media Services Federal Grant Administration General Administration School Administration Business Administration Maintenance and Operation of Plant Student Transportation Services Central Support Services Other Support Services Operations of Non-Instructional Services Miscellaneous Non-Instructional Services Food Services Operation Interest on Long-Term Debt $ 200,913,104 9,044,723 7,088,978 5,499,822 453,225 2,532,110 19,092,360 3,791,930 19,141,662 14,120,581 4,981,811 1,998,621 1,498,150 15,546,360 4,259,461 $ 191,048,959 8,742,429 7,581,297 5,355,582 420,837 2,596,470 18,140,245 3,034,992 18,101,192 13,911,325 3,943,774 2,278,541 1,405,020 15,714,992 5,949,149 $ 70,410,106 $ 65,508,201 6,953,016 2,299,055 2,069,415 1,514,491 12,213,616 3,540,758 10,998,053 11,670,478 3,819,495 1,912,457 6,705,176 2,455,034 2,059,675 1,384,834 11,508,448 2,787,316 9,971,874 10,853,321 2,997,798 2,112,563 (174,356) 64,443 4,259,461 (1,116,982) 197,264 5,949,149 Total Expenses $ 309,962,898 $ 298,224,804 $ 131,550,488 $ 123,373,671 Although program revenues make up a majority of the revenues, the District is still dependent upon tax revenues for governmental activities. Over 35 percent of instruction activities are supported through taxes and other general revenues; for all governmental activities general revenue support is 42.4 percent. The District's Funds The District's governmental funds are accounted for using the modified accrual basis of accounting. Total governmental funds had revenues and other financing sources of approximately $320.8 million and expenditures and other financing uses of approximately $323.3 million. Included in the expenditures were approximately $16.2 million of capital outlay expenditures and approximately $15.1 million of principal retirement. The School System's General Fund remains in sound financial position with a year-end fund balance of approximately $47.4 million. 8 General Fund Budgetary Highlights The District's budget is prepared according to Georgia law. The most significant budgeted fund is the General Fund. The District uses site-based budgeting. The budgeting systems are designed to tightly control total site budgets but provide flexibility for site management. For the General Fund, the actual revenues of approximately $276.6 million were approximately $7.9 million more than the final budgeted amount. This difference was related primarily to local school funds that were not included in the School District budget and actual tax collections exceeding projections. The actual expenditures of approximately $273.9 million for the General Fund were more than the budgeted amount by approximately $3.4 million due in part to local school funds that were not included in the School District budget. The District's Board continues to monitor fund balance in anticipation of future needs, continued decline in funding, and continued increases to expenditures. These results are evidence of their work. Capital Assets and Debt Administration Capital Assets At the end of fiscal year 2018, the District had approximately $392.6 million invested in capital assets, all in governmental activities. Table 4 shows fiscal year 2018 balances compared with fiscal year 2017 balances. Table 4 Capital Assets (Net of Depreciation) Governmental Activities Fiscal Fiscal Year 2018 Year 2017 Land Construction in Progress Buildings and Improvements Equipment Land Improvement $ 31,719,369 5,723,467 313,507,236 16,081,009 25,608,167 $ 31,719,369 2,253,181 320,432,054 20,003,571 27,450,668 Total $ 392,639,248 $ 401,858,843 The growth in the county has slowed down, so the District is focusing construction on additions and renovations to existing facilities. More detailed information on the District's capital assets can be found in the notes to the financial statements. 9 Debt At June 30, 2018, the Board had approximately $132.3 million in bonds outstanding with approximately $15.5 million due within one year. Table 5 shows fiscal year 2018 balances compared with fiscal year 2017 balances. Table 5 Debt at June 30 Governmental Activities Fiscal Fiscal Year 2018 Year 2017 General Obligation Bonds $ 132,322,000 $ 147,386,000 More detailed information on the District's long-term debt can be found in Note 10 of the financial statements. Economic Factors The Douglas County School System is financially stable. The School System's operating millage rate for the 2017 tax digest year is 19.75 which produces approximately $3.3 million per mill. The operating millage rate for the 2017 tax digest year, which supported the fiscal year 2018 budget, decreased from the 2016 tax digest rate of 19.80. The School System's management and Board are committed to continue to effectively and prudently manage the available resources to provide quality educational opportunities for all of the System's students. Contacting the Board's Financial Management This financial report is designed to provide our citizens, taxpayers, investors, and creditors with a general overview of the District's finances and to show the District's accountability for the money it receives. If you have questions about this report or need additional information, contact the Douglas County Board of Education, 9030 Highway 5, Douglasville, Georgia 30134 or call 770651-2000. 10 BASIC FINANCIAL STATEMENTS DOUGLAS COUNTY BOARD OF EDUCATION STATEMENT OF NET POSITION JUNE 30, 2018 ASSETS Cash and cash equivalents Investments Receivables: Taxes Intergovernmental: State Federal Local Other Inventory Capital assets (nondepreciable) Capital assets (depreciable, net of accumulated depreciation) Total assets DEFERRED OUTFLOWS OF RESOURCES Deferred charges on refunding Pension related items OPEB related items Total deferred outflows of resources LIABILITIES Accounts payable Salaries and benefits payable Contracts payable Accrued interest payable Retainage payable Unearned revenue Claims payable due within one year Claims payable due in more than one year Bonds payable due within one year Bonds payable due in more than one year Compensated absences due within one year Compensated absences due in more than one year Net pension liability Net OPEB liability Total liabilities DEFERRED INFLOWS OF RESOURCES Pension related items OPEB related items Total deferred inflows of resources NET POSITION Net investment in capital assets Restricted for: Federal programs Capital projects Debt service Winston Ruritan Club - expendable Winston Ruritan Club - nonexpendable Unrestricted Total net position The accompanying notes are an integral part of these financial statements. 11 Governmental Activities $ 93,618,554 89,491 3,642,554 21,254,163 3,624,289 339,984 28,451 561,757 37,442,836 355,196,412 515,798,491 4,388,179 40,685,133 7,210,865 52,284,177 3,709,219 38,692,022 218,099 870,837 66,316 142,352 2,732,454 482,198 15,517,000 117,172,828 978,602 172,695 217,336,220 193,478,483 591,569,325 7,271,730 15,376,398 22,648,128 264,208,329 8,424,269 28,746,280 2,711,801 43,588 45,903 (350,314,955) $ (46,134,785) DOUGLAS COUNTY BOARD OF EDUCATION STATEMENT OF ACTIVITIES FOR THE FISCAL YEAR ENDED JUNE 30, 2018 Functions/Programs Governmental activities: Instruction $ Support services: Pupil services Improvement of instructional services Educational media services Federal grant administration General administration School administration Business administration Maintenance and operation of facilities Student transportation services Central support services Other support services Operations of non-instructional services: Miscellaneous non-instructional services Food services operation Interest on long-term debt Total governmental activities $ Expenses 200,913,104 9,044,723 7,088,978 5,499,822 453,225 2,532,110 19,092,360 3,791,930 19,141,662 14,120,581 4,981,811 1,998,621 1,498,150 15,546,360 4,259,461 309,962,898 Charges for Services Program Revenues Operating Grants and Contributions Capital Grants and Contributions $ 1,340,714 $ 129,162,284 $ - - 2,091,707 - - - 7,200 - - 4,789,923 3,430,407 453,225 1,017,619 6,878,744 251,172 8,136,409 2,372,783 1,162,316 86,164 - - 77,320 - - 1,317,306 - 2,922,969 12,558,948 - - $ 5,588,189 $ 172,391,701 $ 355,200 - 432,520 Net (Expense) Revenue and Changes in Net Position Governmental Activities $ (70,410,106) (6,953,016) (2,299,055) (2,069,415) (1,514,491) (12,213,616) (3,540,758) (10,998,053) (11,670,478) (3,819,495) (1,912,457) 174,356 (64,443) (4,259,461) (131,550,488) General revenues: Taxes: Property taxes, levied for general purposes Property taxes, levied for debt service Sales taxes: For debt service For capital projects Other taxes Grants and contributions not restricted to specific programs Unrestricted investment earnings Total general revenues Change in net position Net position, beginning of year, as restated Net position, end of year The accompanying notes are an integral part of these financial statements. 73,474,914 4,465,995 14,117,388 10,202,429 8,441,142 16,983,259 236,119 127,921,246 (3,629,242) (42,505,543) $ (46,134,785) 12 DOUGLAS COUNTY BOARD OF EDUCATION BALANCE SHEET GOVERNMENTAL FUNDS JUNE 30, 2018 ASSETS Cash and cash equivalents Investments Receivables: Taxes Intergovernmental: State Federal Local Other Due from other funds Inventory General District-Wide Capital Projects $ 61,609,740 $ 28,533,006 $ - - 1,274,155 2,235,803 21,254,163 3,624,289 339,984 28,451 561,757 77,320 - Total assets $ LIABILITIES, DEFERRED INFLOWS OF RESOURCES AND FUND BALANCES LIABILITIES Accounts payable $ Unearned revenue Contracts payable Salaries and benefits payable Retainage payable Due to other funds 88,692,539 $ 1,738,749 $ 142,352 - 38,692,022 - 77,320 30,846,129 $ 1,944,704 $ - 218,099 - 66,316 - Total liabilities DEFERRED INFLOWS OF RESOURCES Unavailable revenue - property taxes 40,650,443 623,371 2,229,119 - Total deferred inflows of resources FUND BALANCES Nonspendable: Inventory Permanent fund corpus Restricted for: Winston Ruritan Club Federal programs Capital projects Debt service Unassigned: General fund Total fund balances Total liabilities, deferred inflows of resources and fund balances 623,371 - 561,757 - 7,862,512 - 38,994,456 47,418,725 - 28,617,010 - - 28,617,010 $ 88,692,539 $ 30,846,129 $ The accompanying notes are an integral part of these financial statements. Debt Service Non-major Winston Ruritan Club Total Governmental Funds 3,475,808 $ - - $ 89,491 93,618,554 89,491 132,596 - 3,642,554 - - 21,254,163 - - 3,624,289 - - 339,984 - - 28,451 - - 77,320 - - 561,757 3,608,404 $ 89,491 $ 123,236,563 25,766 $ - 25,766 46,919 46,919 3,535,719 3,535,719 3,608,404 $ - $ - - - - 3,709,219 142,352 218,099 38,692,022 66,316 77,320 42,905,328 670,290 670,290 45,903 43,588 - - 89,491 561,757 45,903 43,588 7,862,512 28,617,010 3,535,719 38,994,456 79,660,945 89,491 $ 123,236,563 13 DOUGLAS COUNTY BOARD OF EDUCATION RECONCILIATION OF THE GOVERNMENTAL FUNDS BALANCE SHEET TO THE STATEMENT OF NET POSITION JUNE 30, 2018 Total fund balances - governmental funds $ Amounts reported for governmental activities in the statement of net position are different because: Capital assets used in governmental activities are not current financial resources and, therefore, are not reported in the funds. Cost Less accumulated depreciation $ 592,930,962 (200,291,714) Other long-term assets are not available to pay for current-period expenditures and, therefore, are unavailable in the funds. Property taxes The net pension liability is not a financial liability in governmental fund activities and, therefore, not reported in governmental funds. Net pension liability Pension related deferred outflows of resources $ (217,336,220) 40,685,133 Pension related deferred inflows of resources (7,271,730) The net OPEB liability is not a financial liability in governmental fund activities and, therefore, not reported in governmental funds. Net OPEB liability $ (193,478,483) OPEB related deferred outflows of resources 7,210,865 OPEB related deferred inflows of resources (15,376,398) Long-term liabilities and related items are not due and payable in the current period and, therefore, are not reported in the funds. Bonds payable $ (132,322,000) Premium, net of amortization (367,828) Unamortized loss on refunding 4,388,179 Accrued interest (870,837) Compensated absences (1,151,297) Claims liability (3,214,652) Net position of governmental activities $ The accompanying notes are an integral part of these financial statements. 79,660,945 392,639,248 670,290 (183,922,817) (201,644,016) (133,538,435) (46,134,785) 14 DOUGLAS COUNTY BOARD OF EDUCATION STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES GOVERNMENTAL FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 2018 REVENUES Property taxes Sales taxes Other taxes State funds Federal funds Investment income (loss) Charges for services Miscellaneous Total revenues EXPENDITURES Current: Instruction Support services: Pupil services Improvement of instructional services Educational media services Federal grant administration General administration School administration Business administration Maintenance and operation of facilities Student transportation services Central support services Other support services Miscellaneous non-instructional services Food services operation Capital outlay Debt service: Principal retirement Interest and fees Total expenditures Excess (deficiency) of revenues over expenditures OTHER FINANCING SOURCES (USES) Transfers in Transfers out Sale of capital assets Total other financing sources (uses) Net change in fund balances General $ 74,051,111 $ - 7,479,891 157,892,486 26,408,676 31,971 4,143,459 6,607,933 276,615,527 District Wide Capital Projects - $ 24,319,817 213,595 24,533,412 Debt Service Non-major Winston Ruritan Club Total Governmental Funds 4,539,547 $ - 961,251 - 1,993 - 5,502,791 - $ (5,153) (5,153) 78,590,658 24,319,817 8,441,142 157,892,486 26,408,676 242,406 4,143,459 6,607,933 306,646,577 175,829,509 8,849,839 6,985,663 5,072,858 443,991 1,707,411 18,623,747 3,756,594 16,647,034 12,944,705 4,896,632 1,998,621 1,498,150 14,691,586 - 273,946,340 2,669,187 31,741 31,741 2,700,928 - 16,196,206 16,196,206 8,337,206 (14,117,388) (14,117,388) (5,780,182) - 1,949 - 15,064,000 3,928,955 18,994,904 (13,492,113) 14,117,388 - 14,117,388 625,275 - - - (5,153) - (5,153) 175,829,509 8,849,839 6,985,663 5,072,858 443,991 1,707,411 18,623,747 3,758,543 16,647,034 12,944,705 4,896,632 1,998,621 1,498,150 14,691,586 16,196,206 15,064,000 3,928,955 309,137,450 (2,490,873) 14,117,388 (14,117,388) 31,741 31,741 (2,459,132) FUND BALANCES, beginning of year 44,717,797 34,397,192 FUND BALANCES, end of year $ 47,418,725 $ 28,617,010 $ The accompanying notes are an integral part of these financial statements. 2,910,444 3,535,719 $ 94,644 89,491 $ 82,120,077 79,660,945 15 DOUGLAS COUNTY BOARD OF EDUCATION RECONCILIATION OF THE STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES OF GOVERNMENTAL FUNDS TO THE STATEMENT OF ACTIVITIES FOR THE FISCAL YEAR ENDED JUNE 30, 2018 Amounts reported for governmental activities in the statement of activities are different because: Net change in fund balances - total governmental funds $ Governmental funds report capital outlays as expenditures. However, in the statement of activities the cost of those assets is allocated over their estimated useful lives and reported as depreciation expense. The amount by which depreciation exceeded capital outlays in the current period is as follows: Capital outlay Depreciation expense $ 11,979,935 (21,456,708) The net effect of miscellaneous transactions involving capital assets is as follows: Net book value of assets sold Donation of capital assets $ (98,022) 355,200 Revenues in the statement of activities that do not provide current financial resources are not reported as revenues in the funds. Property taxes In the governmental funds, current year expenditures related to pensions are comprised solely of amounts contributed to the plan for the current year. However, in the statement of activities, expenses related to pensions include amounts that do not require the use of current financial resources. This amount represents the difference in the required accounting treatment of pensions and related items. In the governmental funds, current year expenditures related to OPEB are comprised solely of amounts contributed to the plan for the current year. However, in the statement of activities, expenses related to OPEB include amounts that do not require the use of current financial resources. This amount represents the difference in the required accounting treatment of pensions and related items. 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 assets. This amount is the net effect of these differences in the treatment of long-term debt and related items. Principal payments - bonds Some expenses 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. Amortization of bond premium Amortization of loss on refunding Change in claims payable Change in compensated absences Change in accrued interest Change in net position of governmental activities $ 405,438 (849,301) (740,427) (5,489) 113,357 $ The accompanying notes are an integral part of these financial statements. (2,459,132) (9,476,773) 257,178 (649,749) (1,309,844) (3,978,500) 15,064,000 (1,076,422) (3,629,242) 16 DOUGLAS COUNTY BOARD OF EDUCATION GENERAL FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL (GAAP BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 2018 REVENUES Taxes State funds Federal funds Charges for services Investment income Miscellaneous Total revenues EXPENDITURES Current: Instruction Support services: Pupil services Improvement of instructional services Educational media services Federal grant administration General administration School administration Business administration Maintenance and operation of plant Student transportation services Central support services Other support services Miscellaneous non-instructional services Food services operation Total expenditures Excess (deficiency) of revenues over expenditures OTHER FINANCING SOURCES (USES) Transfers out Sale of capital assets Total other financing sources (uses) Net change in fund balances FUND BALANCES, beginning of year FUND BALANCES, end of year Budget Original Final $ 77,357,417 $ 78,833,684 $ 153,852,335 154,783,755 21,243,214 29,586,446 3,048,702 3,048,702 47,000 47,000 2,361,024 2,465,424 257,909,692 268,765,011 166,795,597 9,241,956 5,599,786 4,981,760 87,926 1,483,176 18,112,191 1,965,439 16,425,068 12,582,242 4,398,248 906,542 - 15,679,698 258,259,629 (349,937) 174,486,582 9,980,284 8,008,671 5,031,995 480,589 1,790,085 18,297,711 2,224,259 16,474,111 12,740,549 4,595,495 801,510 - 15,679,698 270,591,539 (1,826,528) (260,000) 100,000 (160,000) (260,000) 100,000 (160,000) (509,937) (1,986,528) 44,717,797 44,717,797 $ 44,207,860 $ 42,731,269 $ The accompanying notes are an integral part of these financial statements. Actual Variance With Final Budget 81,531,002 $ 157,892,486 26,408,676 4,143,459 31,971 6,607,933 276,615,527 2,697,318 3,108,731 (3,177,770) 1,094,757 (15,029) 4,142,509 7,850,516 175,829,509 8,849,839 6,985,663 5,072,858 443,991 1,707,411 18,623,747 3,756,594 16,647,034 12,944,705 4,896,632 1,998,621 1,498,150 14,691,586 273,946,340 2,669,187 (1,342,927) 1,130,445 1,023,008 (40,863) 36,598 82,674 (326,036) (1,532,335) (172,923) (204,156) (301,137) (1,197,111) (1,498,150) 988,112 (3,354,801) 4,495,715 31,741 31,741 2,700,928 44,717,797 47,418,725 $ 260,000 (68,259) 191,741 4,687,456 - 4,687,456 17 DOUGLAS COUNTY BOARD OF EDUCATION STATEMENT OF FIDUCIARY ASSETS AND LIABILITIES AGENCY FUND JUNE 30, 2018 Cash Total assets Funds held for others Total liabilities ASSETS LIABILITIES The accompanying notes are an integral part of these financial statements. Club and Athletics Fund $ 849,322 $ 849,322 $ 849,322 $ 849,322 18 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 1: DESCRIPTION OF SCHOOL DISTRICT AND REPORTING ENTITY Reporting Entity The Douglas County Board of Education (School District) was established under the laws of the State of Georgia and operates under the guidance of a school board elected by the voters and a Superintendent appointed by the Board. The Board 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 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 of the Douglas County Board of Education. 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 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. 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. In the Statement of Net Position, equity is reported as net position and consists of net investment in capital assets, amounts restricted by outside parties for specific purposes and unrestricted amounts. 19 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 2: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Basis of Presentation (Continued) 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 statements for each category (governmental and fiduciary) are presented. 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: General Fund is the School District's primary operating fund. It accounts for all financial resources of the School District, except those resources required to be accounted for in another fund. District-Wide Capital Projects Fund accounts for financial resources including Special Purpose Local Option Sales Tax (SPLOST), Bond Proceeds and grants from Georgia State Financing and Investment Commission to be used for the acquisition, construction or renovation of major capital facilities. Debt Service Fund accounts for taxes (property and sales) legally restricted for the payment of general long-term debt principal, interest and paying agent's fees. The School District also reports the following fund types: Agency Fund accounts for assets held by the School District as an agent for various individual school clubs and activities. Permanent Fund accounts for the operations of the School District's endowment for which the corpus held in this fund cannot be used. Basis of Accounting/Measurement Focus The basis of accounting determines when transactions are reported on the financial statements. The Districtwide governmental activities and fiduciary fund financial statements are reported using the economic resources measurement focus and the accrual basis of accounting. Agency funds are custodial in nature and do not present results of operations or have a measurement focus. 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, grants and donations. 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 and donations is recognized in the fiscal year in which all eligibility requirements have been satisfied. 20 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 2: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Basis of Accounting/Measurement Focus (Continued) 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. Revenues are considered to be available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. For this purpose, the School District considers most revenues to be available if they are collected within 60 days of the end of the current fiscal period; however, intergovernmental revenues reported in the governmental funds are considered to be available if they are collected within 120 days after year-end. Property taxes, sales taxes, intergovernmental revenue, and interest are considered to be susceptible to accrual. Expenditures are recorded when the related fund liability is incurred, except for principal and interest on general long-term debt, claims and judgments and compensated absences, 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 capital leases are reported as other financing sources. Revenue from grants and donations is recognized in the year in which all eligibility requirements have been satisfied. Eligibility requirements include timing requirements, which specify the year when the resources are required to be used or the year when use is first permitted, matching requirements, in which the School District must provide local resources to be used for a specified purpose, and expenditure requirements, in which the resources are provided to the School District on a reimbursement basis. The State of Georgia reimburses the School District for teachers' salaries and operating costs through the Quality Basic Education (QBE) Formula Earnings program. State of Georgia law defines the formula driven grant that determines the cost of an academic school year and the State of Georgia's share in this cost. Generally teachers are contracted for the school year (July 1 June 30) and paid over a twelve month contract period, generally September 1 through August 31. In accordance with the requirements of the enabling legislation of the QBE program, the State of Georgia reimburses the School District over the same twelve month period in which teachers are paid, funding the academic school year expenditures. At June 30, the amount of teachers' salaries incurred but not paid until July and August of the subsequent year are accrued as the State of Georgia has only postponed the final payment of their share of the cost until the subsequent appropriations for cash management purposes. By June 30 of each year, the State of Georgia has a signed appropriation that includes this final amount, which represents the State of Georgia's intent to fund this final payment. Based on guidance in Government Accounting Standards Board (GASB) Statement No. 33, paragraph 74, the State of Georgia recognizes its QBE liability for the July and August salaries at June 30, and the School District recognizes the same QBE as a receivable and revenue, consistent with symmetrical recognition. 21 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 2: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Basis of Accounting/Measurement Focus (Continued) 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 position 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. Cash and Cash Equivalents COMPOSITION OF DEPOSITS Cash and cash equivalents consist of cash on hand, demand deposits, Georgia Fund 1 and short-term investments with original maturities of three months or less from the date of acquisition in authorized financial institutions. Georgia Laws OCGA 45-8-14 authorizes the School District to deposit its funds in one or more solvent banks or insured federal savings and loan associations. Investments COMPOSITION OF INVESTMENTS 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. Both participating interest-earning contracts and money market investments with a maturity at purchase greater than one year are reported at fair value. The Official Code of Georgia Annotated Section 36-83-4 authorizes the School District to invest its funds. 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. Funds may be invested in the following: (1) Obligations issued by the State of Georgia or by other states, (2) Obligations issued by the United States government, (3) Obligations fully insured or guaranteed by the United States government or a United States government agency, (4) Obligations of any corporation of the United States government, (5) Prime banker's acceptances, (6) The Local Government Investment Pool administered by the State Treasurer of the State of Georgia, (7) Repurchase agreements, and (8) Obligations of other political subdivisions of the State of Georgia. The School District does not have a formal policy regarding investments that addresses credit risks, custodial credit risks, concentration of credit risks, interest rate risks or foreign currency risks. 22 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 2: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) 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 are reported net of an allowance for uncollectible receivables when necessary. Property Taxes The Douglas County Tax Commissioner levied the property tax for the 2017 tax digest year (calendar year) on September 15, 2017 (levy date). 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 Douglas County Tax Commissioner bills and collects the property taxes for the School District, withholds 1% 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 $74,051,111 and for debt service amounted to $4,539,547. Allowances for uncollectible property taxes at June 30, 2018 for the School District's General Fund and Debt Service Fund are $26,003 and $2,706, respectively. The Georgia Constitution, Article VIII, Section VI, Paragraph I requires the board of education of each school system to annually certify to its fiscal authority or authorities a school tax not greater than 20 mills per dollar for the support and maintenance of education. The Douglas County Board of Education is in compliance with this law. Tax millage rates levied for the 2017 tax year (calendar year) for the Douglas County Board of Education were as follows (a mill equals $1 per thousand dollars of assessed value): School Maintenance and Operations School Bonds Sales Taxes 19.75 mills 1.20 mills 20.95 mills Special Purpose Local Option Sales Tax, at the fund reporting level, during the year amounted to $24,319,817 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. 23 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 2: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Inventories CONSUMABLE SUPPLIES On the basic financial statements, consumable supplies are reported at cost (first-in, first-out). The School District uses the consumption method to account for the consumable supplies inventory whereby an asset is recorded when supplies are purchased and expenses/expenditures are recorded at the time the supplies are consumed. 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 (first-in, first-out). 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. Prepaid Items Payments made to vendors for services that will benefit periods subsequent to June 30, 2018, are recorded as prepaid items. Capital Assets Capital assets purchased, including capital outlay costs, are recorded as expenditures in the fund financial statements at the time of purchase (including ancillary charges). On the District-wide financial statements, all purchased capital assets are valued 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 estimated acquisition value on the date donated. Disposals are deleted at depreciated recorded cost. 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. Depreciation is computed using the straight-line method. The School District does not capitalize book collections or works of art. Depreciation is used to allocate the actual or estimated historical cost of all capital assets over estimated useful lives. 24 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 2: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Capital Assets (Continued) Capitalization thresholds and estimated useful lives of capital assets reported in the District-wide statements are as follows: Capitalization Estimated Policy Useful Life Land Land Improvements Buildings Temporary Permanent Building Improvements Equipment All N/A $ 10,000 20 years $ 10,000 25 years $ 50,000 50 years $ 10,000 7 to 30 years $ 10,000 4 to 20 years Deferred Outflows/Inflows of Resources In addition to assets, the statement of net position will sometimes report a separate section for deferred outflows of resources. This separate financial statement element, deferred outflows of resources, represents a consumption of net position that applies to a future period(s) and so will not be recognized as an outflow of resources (expense) until then. The District has seven (7) items that qualify for reporting in this category which occurs only in the governmental activities. Governmental Activities report (1) a deferred outflow of resources for the District's actual contributions to the pension plan during the fiscal year ended June 30, 2018 which are subsequent to the measurement date of the net pension liability and will be recognized in fiscal year 2019; (2) a deferred outflow of resources for experience gains or losses related to the pension plan which will be amortized over the remaining service period; (3) a deferred outflow of resources for the changes in actuarial assumptions which will be amortized over the remaining service period; (4) a deferred outflow of resources for the change in the District's proportionate share based on actual contributions towards the pension plan, which will be amortized over the remaining service period; (5) a deferred outflow of resources for the District's actual contributions to the OPEB plan during the fiscal year ended June 30, 2018 which are subsequent to the measurement date of the net OPEB liability and will be recognized in fiscal year 2019; (6) a deferred outflow of resources for the change in the District's proportionate share based on actual contributions towards the school OPEB plan, which will be amortized over the remaining service period; and (7) a deferred outflow of resources for the net difference between projected and actual investment earnings on the OPEB assets, which will be amortized over a five year period. 25 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 2: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Deferred Outflows/Inflows of Resources (Continued) In addition to liabilities, the statement of financial position will sometimes report a separate section for deferred inflows of resources. This separate financial statement element, deferred inflows of resources, represents an acquisition of net position that applies to future period(s) and so will not be recognized as an inflow of resources (revenue) until that time. The District has one type of deferred inflow under a modified accrual basis of accounting that qualifies for reporting in this category. Accordingly, the item, unavailable revenue, is reported only in the governmental funds balance sheet. The governmental funds report unavailable revenues from property taxes and these amounts are deferred and will be recognized as an inflow of resources in the period in which the amounts become available. The District has five (5) items that qualify for reporting in this category which occurs only in the governmental activities. Governmental Activities report (1) a deferred inflow of resources for the net difference between projected and actual investment earnings on the pension assets, which will be amortized over a five year period; (2) a deferred inflow of resources for experience gains or losses from periodic studies by the actuary, which will be amortized over the remaining service period; (3) a deferred inflow of resources for the change in the District's proportionate share based on actual contributions towards the pension plan, which will be amortized over the remaining service period; (4) a deferred inflow of resources for the changes in actuarial assumptions in relation to the OPEB plan which will be amortized over the remaining service period; (5) a deferred inflow of resources for the change in the District's proportionate share based on actual contributions towards the OPEB plan, which will be amortized over the remaining service period. General Obligation Bonds The School District issues general obligation bonds to provide funds for the acquisition and construction of major capital facilities. In addition, general obligation bonds have been issued to refund existing general obligations bonds. Bond issuance costs are recognized in the financial statements during the fiscal year bonds are issued. General obligation bonds are direct obligations and pledge the full faith and credit of the government. In the fund financial statements, the face amount of debt issued and any related premium, is reported as other financing sources. Issuance costs, whether or not withheld from actual proceeds, are reported as debt service expenditures. In the government-wide financial statements, long-term debt and other long-term obligations are reported as liabilities in the applicable governmental activities statement of net position. Bond premiums and discounts are accrued and amortized over the life of the bonds using the effective interest method. Bonds payable are reported net of the applicable bond premium or discount. Bond issuance costs are expensed when incurred. 26 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 2: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Use of Estimates The preparation of financial statements in conformity with accounting principles generally accepted in the United States requires management to make estimates and assumptions that affect the reported amounts of assets, deferred outflows of resources, liabilities and deferred inflows of resources, the disclosure of contingent assets and liabilities at the date of the financial statements, and the reported amounts of revenues and expenses during the reporting period. Actual results could differ from those estimates. 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 fiduciary net position of the Teachers Retirement System of Georgia (TRS) and additions to/deductions from TRS's fiduciary net position have been determined on the same basis as they are reported by TRS. For this purpose, benefit payments (including refunds of employee contributions) are recognized when due and payable in accordance with the benefit terms. Investments are reported at fair value. 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 fiduciary net position of the Public School Employees Retirement System of Georgia (PSERS) and additions to/deductions from PSERS's fiduciary net position have been determined on the same basis as they are reported by PSERS. 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. Other Postemployment Benefits (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 the School OPEB Fund's fiduciary net position have been determined on the same basis as they are reported by the 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. 27 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 2: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Fund Equity Fund equity at the governmental fund financial reporting level is classified as "fund balance." Fund equity for all other reporting is classified as "net position." Fund Balance Generally, fund balance represents the difference between the assets, liabilities and deferred inflows of resources under the current financial resources measurement focus of accounting. In the fund financial statements, governmental funds report fund balance classifications that comprise a hierarchy based primarily on the extent to which the School District is bound to honor constraints on the specific purposes for which amounts in those funds can be spent. Fund balances are classified as follows: Nonspendable Fund balances are reported as nonspendable when amounts cannot be spent because they are either (a) not in spendable form (i.e., items that are not expected to be converted to cash) or (b) legally or contractually required to be maintained intact. Restricted Fund balances are reported as restricted when there are limitations imposed on their use either through the enabling legislation adopted by the School District or through external restrictions imposed by creditors, grantors, or laws or regulations of other governments. Committed Fund balances are reported as committed when they can be used only for specific purposes pursuant to constraints imposed by formal action of the Board of Education through the adoption of a resolution. Only the Board of Education may modify or rescind the commitment through adoption of a subsequent resolution. Assigned Fund balances are reported as assigned when amounts are constrained by the School District's intent to be used for specific purposes, but are neither restricted nor committed. Through resolution, the Board of Education has authorized the Superintendent or his or her designee to assign fund balances. Unassigned Fund balances are reported as unassigned as the residual amount when the balances do not meet any of the above criterion. The School District reports positive unassigned fund balance only in the general fund. Negative unassigned fund balances may be reported in all funds. Flow Assumptions When both restricted and unrestricted amounts of fund balance are available for use for expenditures incurred, it is the School District's policy to use restricted amounts first and then unrestricted amounts as they are needed. For unrestricted amounts of fund balance, it is the School District's policy to use fund balance in the following order: Committed Assigned Unassigned 28 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 2: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Fund Equity (Continued) Net Position - Net position represents the difference between assets and deferred outflows of resources, and liabilities and deferred inflows of resources in reporting which utilizes the economic resources measurement focus. Net investment in capital assets, consists of capital assets, net of accumulated depreciation, reduced by the outstanding balances of any borrowing used (i.e., the amount that the School District has spent) for the acquisition, construction or improvement of those assets. Net position is reported as restricted using the same definition as used for restricted fund balance as described in the section above. All other net position is reported as unrestricted. The School District applies restricted resources first when an expense is incurred for purposes for which both restricted and unrestricted net position is available. Note 3: STEWARDSHIP, COMPLIANCE AND ACCOUNTABILITY The School System adopts an annual budget for the General Fund and Debt Service Fund. The budget is prepared in accordance with provisions of the Quality Basic Education Act, OCGA Section 20-2-167 and in accordance with U.S. generally accepted accounting principles. After the Board of Education has tentatively adopted the budget, such budget is advertised at least one time in a local newspaper of general circulation. At the next regular meeting of the Board after advertisement, the budget is revised as necessary and adopted as the final budget. The following functions had excesses of actual expenditures over appropriations in the amount shown for the fiscal year ended June 30, 2018. General Fund: Instruction Support services: Educational media services School administration Business administration Maintenance and operation of plant Student transportation services Central support services Other support services Other miscellaneous non-instructional services $ 1,342,927 40,863 326,036 1,532,335 172,923 204,156 301,137 1,197,111 1,498,150 These over expended departments were funded with revenues recognized in excess of anticipated levels. 29 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 4: DEPOSITS AND INVESTMENTS CATEGORIZATION OF INVESTMENTS At June 30, 2018, the carrying value of the School District's total investments was $89,491, which is stated at fair value. The investment in the local government investment pool, "Georgia Fund 1," created by OCGA 36-83-8, is a stable asset value investment pool, which follows Standard and Poor's criteria for AAAf rated money market funds and is regulated by the Georgia Office of the State Treasurer. The pool is not registered with the SEC as an investment company. The pool's primary objectives are safety of capital, investment income, liquidity and diversification while maintaining principal ($1 per share value). The asset value is calculated weekly to ensure stability. The pool distributes earnings (net of management fees) on a monthly basis and determines participants' shares sold and redeemed based on $1 per share. The pool also adjusts the value of its investments to fair market value as of year-end and the School District's investment in the Georgia Fund 1 is reported at fair value. The School District considers amounts held in Georgia Fund 1 as cash equivalents for financial statement presentation. Investment Georgia Fund 1 Common stock Total Maturity 10 days N/A Fair Value $ 16,337,832 89,491 $ 16,427,323 INTEREST RATE RISK The School District does not have a formal investment policy that limits investment maturities as a means of managing its exposure to fair value losses arising from increasing interest rates. FAIR VALUE MEASUREMENTS The School District categorizes its fair value measurements within the fair value hierarchy established by generally accepted accounting principles. The hierarchy is based on the valuation inputs used to measure the fair value of the asset. Level 1 inputs are quoted prices in active markets for identical assets; Level 2 inputs are significant other observable inputs; and Level 3 inputs are significant unobservable inputs. The School District has the following recurring fair value measurements as of June 30, 2018: Investment Level 1 Common Stock $ 89,491 Investments not subject to level disclosure: Georgia Fund 1 Total investments Fair Value $ 89,491 16,337,832 $ 16,427,323 30 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 4: DEPOSITS AND INVESTMENTS (Continued) FAIR VALUE MEASUREMENTS (Continued) The common stock classified in Level 1 of the fair value hierarchy is valued using prices quoted in active markets for those investments. The Georgia Fund 1 is an investment pool which does not meet the criteria of GASB Statement No. 79 and is thus valued at fair value in accordance with GASB Statement No. 31. As a result, the School District does not disclose investment in the Georgia Fund 1 within the fair value hierarchy. CUSTODIAL CREDIT RISK Custodial credit risk for deposits is the risk that, in the event of the failure of a depository financial institution, the School District will not be able to recover deposits or will not be able to recover collateral securities that are in the possession of an outside party. State statutes require all deposits and investments (other than federal or state government instruments) amounts that exceed standard depository insurance limits are required to be collateralized either (1) individually by the financial institutions through pledged obligations of the U.S. Government, obligations backed by the full faith and credit of the U.S. Government, obligations of the State of Georgia or other states, or obligations of counties, municipalities, or public authorities of the State of Georgia, or (2) participation in the State of Georgia Secure Deposit Program. As of June 30, 2018, the financial institution holding some of the District's deposits is a participant in the State of Georgia Secure Deposit Program, which is administered by the Office of the State Treasurer, requires participating banks holding deposits of public funds to pledge collateral at varying rates depending on the tier assigned by the State. As of June 30, 2018, the School District's cash accounts were insured and/or collateralized as defined by GASB Standards. Note 5: NON-MONETARY TRANSACTIONS The School District receives food commodities from the United States Department of Agriculture (USDA) for school breakfast and lunch programs. For the year ended June 30, 2018, the commodities usage is recorded at their federally assigned value of $810,066. Remainder of the page intentionally left blank 31 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 6: CAPITAL ASSETS The following is a summary of changes in the capital assets during the fiscal year: Balances July 1, 2017 Governmental activities: Capital assets, not being depreciated: Land $ Construction in progress Total 31,719,369 $ 2,253,181 33,972,550 Capital assets, being depreciated: Building improvements Equipment Land improvements Total Less accumulated depreciation for: Building improvements Equipment Land improvements Total 439,705,548 68,783,612 39,238,454 547,727,614 (119,273,494) (48,780,041) (11,787,786) (179,841,321) Total capital assets, being depreciated, net 367,886,293 Governmental activities capital assets, net $ 401,858,843 $ Increases 8,848,901 8,848,901 22,006 3,341,744 122,484 3,486,234 (12,227,417) (7,264,306) (1,964,985) (21,456,708) (17,970,474) (9,121,573) Decreases $ - - (157,003) (947,334) - (1,104,337) 58,981 947,334 - 1,006,315 (98,022) $ (98,022) Transfers $ - (5,378,615) (5,378,615) 5,378,615 - - 5,378,615 - - - 5,378,615 $ - Balances June 30, 2018 $ 31,719,369 5,723,467 37,442,836 444,949,166 71,178,022 39,360,938 555,488,126 (131,441,930) (55,097,013) (13,752,771) (200,291,714) 355,196,412 $ 392,639,248 Depreciation expense was charged to functions as follows: Instruction Support services: Educational media services General administration Maintenance and operation of facilities Student transportation services Operations of non-instructional services Food services $ 18,369,973 300,656 796,493 59,482 1,148,043 782,061 $ 21,456,708 32 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 7: INTERFUND RECEIVABLES, PAYABLES AND TRANSFERS Interfund receivables/payables as of June 30, 2018, consisted of the following: Interfund Payable General Fund Interfund Receivable District-Wide Capital Projects $ 77,320 The interfund balance above represents State grant revenues received in the General Fund used to supplement capital projects. Interfund transfers for the year ended June 30, 2018, consisted of the following: Transfers To Debt Service Transfers From District-Wide Capital Projects $ 14,117,388 Transfers are used to move SPLOST proceeds from District-Wide Capital Projects Fund to Debt Service Fund to fund debt service as allowed in the referendum. Note 8: RISK MANAGEMENT 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; acts of God; and unemployment compensation and vision plan. The School District participates in the Georgia School Boards Association Risk and Insurance Management System, a public entity risk pool organized on July 1, 1994, to develop and administer a plan to reduce risk of loss on account of general liability, motor vehicle liability, or property damage, including safety engineering and other loss prevention and control techniques, and to administer one or more groups of selfinsurance funds, including the processing and defense of claims brought against members of the district. The School District pays an annual premium to the district for its general insurance coverage. Additional coverage is provided through agreements by the district with other companies according to their specialty for property, boiler and machinery (including coverage for flood and earthquake), general liability (including coverage for sexual harassment, molestation and abuse), errors and omissions, crime and automobile risks. Payment of excess insurance for the district varies by line of coverage. 33 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 8: RISK MANAGEMENT (Continued) The School District has established a limited risk management program for workers' compensation claims. A premium is paid by the General Fund at the beginning of the fiscal year for an excess workers' compensation coverage policy which covers individual claims in excess of $450,000 loss per occurrence, up to the statutory limit. Assessments of individual programs, except School Food Services, are performed, as needed, on the basis of that program's payroll to total payroll in order to cover estimated claims budgeted by management based on known claims and prior experiences. School Food Services is billed by the General Fund for the actual amount of claims for that program. The School District accounts for claims with expenses/expenditures and liabilities being reported when it is probable that a loss has occurred and the amount of that loss can be reasonably estimated. For purposes of estimating the unpaid claims liability as of June 30, 2018, the School District's third party administrator computed the reserve liability based on the estimated cost of each outstanding claim from claims experience of similar claims, including consideration of any incurred, but not reported amounts. Changes in the workers' compensation claims liability during the last two fiscal years are as follows: Beginning of Year Claims and Changes in Estimates Claims Paid End of Year Due Within One Year 2017 $ 3,028,143 $ 1,157,852 $ 1,711,770 $ 2,474,225 $ 2,103,092 2018 $ 2,474,225 $ 1,514,459 $ 774,032 $ 3,214,652 $ 2,732,454 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. Changes in the unemployment compensation claims liability during the last two fiscal years are as follows: Beginning of Year Claims and Changes in Estimates Claims Paid End of Year 2017 $ -$ 192 $ 192 $ - 2018 $ - $ 7,139 $ 7,139 $ - 34 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 8: RISK MANAGEMENT (Continued) The School District has purchased surety bonds to provide additional insurance coverage as follows: Position Covered Amount Superintendent All other employees $100,000 $250,000 Note 9: OPERATING LEASES Douglas County Board of Education is committed under various leases for equipment. These leases are considered for accounting purposes to be operating leases. Lease expenditures for the year totaled approximately $234,211. Future minimum lease payments on these leases are as follows: Year ending June 30, 2019 $ 234,211 Note 10: LONG TERM DEBT COMPENSATED ABSENCES Compensated absences represent obligations of the School District relating to employees' rights to receive compensation for future absences based upon service already rendered. This obligation relates only to vesting accumulating leave in which payment is probable and can be reasonably estimated. Typically, the General Fund is the fund used to liquidate this long-term debt. The School District uses the vesting method to compute compensated absences. GENERAL OBLIGATION DEBT OUTSTANDING General Obligation Bonds currently outstanding are as follows: Purpose Interest Rates Outstanding Balance at June 30, 2018 General Government - Series 2012 General Government - Series 2013 General Government - Series 2014 3.43% - 4.00% 2.60% 2.41% $ 12,580,000 69,205,000 50,537,000 $ 132,322,000 35 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 10: LONG TERM DEBT (Continued) The changes in long-term obligations during the fiscal year ended June 30, 2018, were as follows: Governmental activities: General obligation bonds Unamortized bond premium Total bonds payable Claims payable Net pension liability Net OPEB Liability Compensated absences Governmental activity Long-term liabilities Re s tate d B e ginning B alance Additions Re ductions Ending B alance Due Within One Year $ 147,386,000 $ - $ (15,064,000) $ 132,322,000 $ 15,517,000 773,266 - (405,438) 367,828 - 148,159,266 - (15,469,438) 132,689,828 15,517,000 2,474,225 1,514,459 (774,032) 3,214,652 2,732,454 244,248,882 29,760,880 (56,673,542) 217,336,220 - 204,845,693 11,189,365 (22,556,575) 193,478,483 - 1,145,808 883,688 (878,199) 1,151,297 978,602 $ 600,873,874 $ 43,348,392 $ (96,351,786) $ 547,870,480 $ 19,228,056 For governmental activities, compensated absences and the net pension and OPEB liabilities are being liquidated primarily by the General Fund. In fiscal year 2012, the School District issued $27,970,000 of Series 2012 General Obligation Refunding Bonds to (i) refund a portion of the Series 2005 General Obligation Refunding Bonds and (ii) pay the costs of issuing the Series 2012 General Obligation Refunding Bonds. The School District defeased the 2005 bonds by placing the proceeds of new bonds in an irrevocable trust to provide for all future debt service payments on the old bonds. Accordingly, the trust account assets and the liability for the defeased bonds are not included in the School District's financial statements. At June 30, 2018, $12,855,000 of bonds outstanding are considered defeased. The School District has pledged its full faith and credit and taxing power to service the debt. 36 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 10: LONG TERM DEBT (Continued) In fiscal year 2014, the School District issued $75,000,000 of Series 2013 General Obligation Refunding Bonds to (i) refund a portion of the Series 2007 General Obligation Bonds and (ii) pay the costs of issuing the Series 2013 General Obligation Refunding Bonds. The School District defeased the 2007 bonds by placing the proceeds of new bonds in an irrevocable trust to provide for all future debt service payments on the old bonds. The School District also issued $62,478,000 of Series 2014 General Obligation Refunding Bonds to (i) refund a portion of the Series 2007 General Obligation Bonds and (ii) pay the costs of issuing the Series 2014 General Obligation Refunding Bonds. The School District defeased the 2007 bonds by placing the proceeds of new bonds in an irrevocable trust to provide for all future debt service payments on the old bonds. Accordingly, the trust account assets and the liability for the defeased bonds are not included in the School District's financial statements. At June 30, 2018, $112,870,000 of bonds outstanding are considered defeased. The School District has pledged its full faith and credit and taxing power to service the debt. At June 30, 2018, payments due by fiscal year, which includes principal and interest, for these items are as follows: Fiscal Year Ended June 30 General Obligation Bonds Principal Interest 2019 2020 2021 2022 2023 2024-2027 Total $ 15,517,000 $ 15,995,000 12,336,000 13,174,000 13,899,000 61,401,000 $ 132,322,000 $ 3,476,816 2,998,641 2,538,267 2,230,897 1,903,832 4,050,093 17,198,546 37 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 11: ON-BEHALF PAYMENTS The School District has recognized revenues and costs in the amount of $387,701 for retirement contributions paid on the School District's behalf by the following State Agencies. Georgia Department of Education Paid to the Teachers Retirement District for Teachers Retirement (TRS) in the amount of $31,598 State Treasurer of the State of Georgia Paid to the Public School Employees Retirement System for Public School Employees Retirement (PSERS) Employer's Cost in the amount of $356,103 Note 12: SIGNIFICANT COMMITMENTS The following is an analysis of significant outstanding construction or renovation contracts executed by the School District as of June 30, 2018: Project New Manchester High School Fieldhouse Build-out $ 804,600 The amount described in this note is not reflected in the basic financial statements. Note 13: SIGNIFICANT CONTINGENT LIABILITIES 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. The School District believes that such disallowances, if any, will be immaterial to its overall financial position. 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 be material to the basic financial statements. 38 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 14: RETIREMENT PLANS GENERAL INFORMATION ABOUT THE TEACHERS RETIREMENT SYSTEM OF GEORGIA (TRS) Plan description: All teachers of the District as defined in 47-3-60 of the Official Code of Georgia Annotated (O.C.G.A.) 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. TRS issues a publicly available 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.00 % 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, excluding payroll attributable to those personnel funded on behalf of the District by the State. District contributions to TRS, excluding contributions funded by the State on behalf of the District were $23,569,416 for the year ended June 30, 2018. 39 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 14: RETIREMENT PLANS (Continued) PENSION LIABILITIES, PENSION EXPENSE, AND DEFERRED OUTFLOWS OF RESOURCES AND DEFERRED INFLOWS OF RESOURCES RELATED TO PENSIONS At June 30, 2018, the District reported a liability for its proportionate share of the net pension liability that reflected a reduction for support attributable to those personnel funded on behalf of the District by the State of Georgia. The amount recognized by the 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 District were as follows: District's proportionate share of the net pension liability State of Georgia's proportionate share of the net pension liability associated with the District Total $ 217,336,220 379,884 $ 217,716,104 The 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 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 District's proportion was 1.169398%, which was a decrease of 0.014488% from its proportion measured as of June 30, 2016. 40 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 14: RETIREMENT PLANS (Continued) PENSION LIABILITIES, PENSION EXPENSE, AND DEFERRED OUTFLOWS OF RESOURCES AND DEFERRED INFLOWS OF RESOURCES RELATED TO PENSIONS (Continued) For the year ended June 30, 2018, the District recognized pension expense of $24,882,209 and revenue of $10,027 for support provided by the State of Georgia for certain support personnel. At June 30, 2018, the District reported deferred outflows of resources and deferred inflows of resources related to pensions from the following sources: Net difference between projected and actual earnings on pension plan investments Differences between expected and actual experience Deferred Outflows of Resources $ - Deferred Inflows of Resources $ 1,495,637 8,129,713 820,204 Changes in proportion and differences between District contributions and proportionate share of contributions Actuarial assumption changes District contributions subsequent to the measurement date Total 4,221,725 4,955,889 4,764,279 - 23,569,416 - $ 40,685,133 $ 7,271,730 District contributions subsequent to the measurement date of $23,569,416 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 ending June 30: 2019 2020 2021 2022 2023 Total $ (334,111) 10,880,259 5,238,038 (6,022,584) 82,385 $ 9,843,987 41 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 14: RETIREMENT PLANS (Continued) PENSION LIABILITIES, PENSION EXPENSE, AND DEFERRED OUTFLOWS OF RESOURCES AND DEFERRED INFLOWS OF RESOURCES RELATED TO PENSIONS (Continued) 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: Inflation Salary increases Investment rate of return 2.75% 3.25 9.00%, average, including inflation 7.50%, net of pension plan investment expense, including inflation Postretirement 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. 42 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 14: RETIREMENT PLANS (Continued) PENSION LIABILITIES, PENSION EXPENSE, AND DEFERRED OUTFLOWS OF RESOURCES AND DEFERRED INFLOWS OF RESOURCES RELATED TO PENSIONS (Continued) The long-term expected rate of return on pension 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 pension plan 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 Fixed income Domestic large equities Domestic mid equities Domestic small equities International developed market equities International emerging market equities Total * Rates shown are net of the 2.75% assumed rate of inflation Target allocation 30.00% 39.80 3.70 1.50 19.40 5.60 100.00% Long-term expected real rate of return* (0.50)% 9.00 12.00 13.50 8.00 12.00 Discount rate: The discount rate used to measure the total 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 State of Georgia contributions will be made at rates equal to the difference between actuarially determined contribution rates and the member rate. Based on those assumptions, the 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. 43 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 14: RETIREMENT PLANS (Continued) PENSION LIABILITIES, PENSION EXPENSE, AND DEFERRED OUTFLOWS OF RESOURCES AND DEFERRED INFLOWS OF RESOURCES RELATED TO PENSIONS (Continued) Sensitivity of the District's proportionate share of the net pension liability to changes in the discount rate: The following presents the District's proportionate share of the net pension liability calculated using the discount rate of 7.50%, as well as what the District's proportionate share of the net pension liability would be if it were calculated using a discount rate that is 1-percentage-point lower (6.50%) or 1-percentage-point higher (8.50%) than the current rate: District's proportionate share of the net pension liability 1% Decrease (6.50%) $ 356,674,237 Current discount rate (7.50%) $ 217,336,220 1% Increase (8.50%) $ 102,553,012 Pension plan fiduciary net position: Detailed information about the pension plan's fiduciary net position is available in the separately issued TRS financial report which is publically available at www.trsga.com/publications. GENERAL INFORMATION ABOUT THE 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. 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/financials. 44 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 14: RETIREMENT PLANS (Continued) GENERAL INFORMATION ABOUT THE PUBLIC SCHOOL EMPLOYEES RETIREMENT SYSTEM (PSERS) (Continued) 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. Pension Liabilities and Pension Expense At June 30, 2018, the District did not have a liability for a proportionate share of the net pension liability because of the related State of Georgia support. The amount of the State's proportionate share of the net pension liability associated with the District is as follows: State of Georgia's proportionate share of the Net Pension Liability associated with the District $ 1,891,026 The 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 District was based on actuarially determined contributions paid by the State during the fiscal year ended June 30, 2017. 45 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 14: RETIREMENT PLANS (Continued) GENERAL INFORMATION ABOUT THE PUBLIC SCHOOL EMPLOYEES RETIREMENT SYSTEM (PSERS) (Continued) For the year ended June 30, 2018, the District recognized pension expense of $381,115 and revenue of $381,115 for support provided by the State of Georgia. Actuarial assumptions: The total pension liability was determined by an actuarial valuation as of June 30, 2016, using the following actuarial assumptions, applied to all periods included in the measurement: Inflation Salary increase Investment rate of return 2.75% N/A 7.50%, net of pension plan investment expense, including inflation Postretirement 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. 46 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 14: RETIREMENT PLANS (Continued) GENERAL INFORMATION ABOUT THE PUBLIC SCHOOL EMPLOYEES RETIREMENT SYSTEM (PSERS) (Continued) The long-term expected rate of return on 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 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 Fixed income Domestic large stocks Domestic mid stocks Domestic small stocks International developed market stocks International emerging market stocks Alternatives Total Target allocation 30.00% 37.20 3.40 1.40 17.80 5.20 5.00 100.00% Long-term expected real rate of return* (0.50)% 9.00 12.00 13.50 8.00 12.00 11.00 * Rates shown are net of the 2.75% assumed rate of inflation Discount rate: The discount rate used to measure the total 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 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. 47 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 15: POSTEMPLOYMENT BENEFITS GEORGIA SCHOOL PERSONNEL EMPLOYEES POSTEMPLOYMENT HEALTH BENEFIT FUND Plan Description. The District participates in the State of Georgia School Employees Postemployment Benefit Fund (School OPEB Fund), which is an other postemployment benefit (OPEB) plan administered by the State of Georgia Department of Community Health (DCH). Certified teachers and non-certified employees of the 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 of the State of Georgia and administered by a Board of Community Health (DCH 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 DCH Board. The School OPEB Fund is included in the State of Georgia Comprehensive Annual Financial Report which is publicly available and can be obtained at https://sao.georgia.gov/comprehensive-annual-financial-reports. Benefits: 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 of Community Health, the School OPEB Fund is substantially funded on a pay-as-you-go basis; that is, annual cost of providing benefits will be financed in the same year as claims occur. Contributions required and made to the School OPEB Fund from the District were $7,154,276 for the year ended June 30, 2018. Active employees are not required to contribute to the School OPEB Fund. 48 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 15: POSTEMPLOYMENT BENEFITS (Continued) OPEB Liabilities, OPEB Expense, and Deferred Outflows of Resources and Deferred Inflows of Resources Related to OPEB Effective July 1, 2017, the District implemented the provisions of GASB Statement No. 75, Accounting and Financial Reporting for Postemployment Benefits Other Than Pensions, which significantly changed the District's accounting for OPEB amounts. The information disclosed in this note is presented in accordance with this new standard. At June 30, 2018, the District reported a liability of $193,478,483 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 District's proportion of the net OPEB liability was actuarially determined based on employer contributions to the School OPEB Fund during the fiscal year ended June 30, 2017. At June 30 2017, the District's proportion was 1.377075%, which was a decrease of 0.005123% from its proportion measured as of June 30, 2016. For the year ended June 30, 2018, the District recognized OPEB expense of $11,132,776. At June 30, 2018, the District reported deferred outflows of resources and deferred inflows of resources related to OPEB from the following sources: Net difference between projected and actual earnings on OPEB plan investments Changes in proportion and differences between District contributions and proportionate share of contributions Changes in plan assumptions District contributions subsequent to the measurement date Total Deferred Outflows of Resources Deferred Inflows of Resources $ 56,589 $ - - 643,505 - 14,732,893 7,154,276 - $ 7,210,865 $ 15,376,398 49 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 15: POSTEMPLOYMENT BENEFITS (Continued) District contributions subsequent to the measurement date of $7,154,276 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 ending June 30: 2019 2020 2021 2022 2023 2024 Total $ (2,751,391) (2,751,391) (2,751,391) (2,751,391) (2,765,539) (1,548,706) $ (15,319,809) 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: Inflation Salary Increases Long-term expected rate of return Healthcare cost trend rate: Pre-Medicare eligible Medicare eligible Ultimate trend rate Pre-Medicare eligible Medicare eligible Year of ultimate trend rate 2.75% TRS 3.25-9.00%, including inflation PSERS N/A 3.88%, compounded annually, net of investment expense, and including inflation 7.75% 5.75% 5.00% 5.00% 2022 50 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 15: POSTEMPLOYMENT BENEFITS (Continued) 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 TRS Members: The RP-2000 White Collar Mortality Table projected to 2025 with projection scale BB (set forward 1 year for males) was used for death after service retirement and beneficiaries. The RP-2000 Disabled Mortality Table projected to 2025 with projection scale BB (set forward 2 years for males and four years for females) was 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) was 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) was 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 system, which covered the five-year period ending June 30, 2014. Projection of benefits for financial reporting purposes are based on the substantive plan (the plan as understood by the District 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 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. 51 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 15: POSTEMPLOYMENT BENEFITS (Continued) 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 Local Government Investment Pool Target allocation 100.00% Long-term expected real rate of return 3.88% Discount rate: The discount rate has changed since the prior measurement date from 3.07% to 3.58%. 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 Buyer Index). The projection of cash flows used to determine the discount rate assumed that the current sharing of costs between the employer and the member will continue and that contributions 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 long-term expected rate of return on OPEB plan investments was applied to discount projected benefit payments until 2029. The discount rate of 3.58% was the single rate which, when applied to all projected benefit payments, resulted in the same present value of benefit payments when the above discussed calculations are combined. The calculated discount rate of 3.58% was applied to all periods of projected benefit payments to determine the total OPEB liability. 52 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 15: POSTEMPLOYMENT BENEFITS (Continued) Sensitivity of the District's proportionate share of the net OPEB liability to changes in the discount rate: The following presents the District's proportionate share of the net OPEB liability calculated using the discount rate of 3.58%, as well as what the 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 rate: District's proportionate share of the net OPEB liability $ 1% Decrease (2.58%) Current discount rate (3.58%) 229,721,042 $ 193,478,483 $ 1% Increase (4.58%) 164,845,765 Sensitivity of the District's proportionate share of the net OPEB liability to changes in the healthcare cost trend rate: The following presents the District's proportionate share of the net OPEB liability calculated using the healthcare cost trend rates of 5.00% to 7.75%, as well as what the 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 (4.00% to 6.75%) or 1-percentage-point higher (6.00% to 8.75%) than the current rates: District's proportionate share of the net OPEB liability 1% Current 1% Decrease discount rate Increase (4.00% to 6.75%) (5.00% to 7.75%) (6.00% to 8.75%) $ 160,371,620 $ 193,478,483 $ 236,583,568 53 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 2018 Note 16: TAX ABATEMENTS For the year ended June 30, 2018, School District property tax revenues were reduced by $4,741,521 under agreements entered into by the Development Authority of Douglas County and the Development Authority of the City of Douglasville. Under the agreements, taxes on both real property and personal property are reduced based on jobs created and investments made by the corporation to whom the incentives were offered as long as the corporation meets certain investment targets. Note 17: CHANGE IN ACCOUNTING PRINCIPLE In conjunction with the implementation of Governmental Accounting Standards Board (GASB) Statement No. 75, Accounting and Financial Reporting for Postemployment Benefits Other Than Pensions, the District is required to change its accounting treatment of OPEB liabilities and the related OPEB expense. The new standard requires that the District's proportionate share of the Net OPEB Liability be recorded on the Statement of Net Position. Therefore, in conjunction with the implementation of Statement No. 75, the following restatement was required to the beginning net position of the Governmental Activities to properly recognize the District's Net OPEB Liability and related deferred outflows of resources for contributions subsequent to the measurement date as of the end of the prior period: Net Position - beginning, as prevoiously reported Recognition of the net OPEB liability related to the OPEB plan accordance with GASB Statement No. 75 Recognition of the beginning of the measurement period deferred outflows of resources for contributions subsequent to the measurement period in accordance with GASB Statement No. 75 Net Position - beginning, as restated Governmental Activities $ 155,159,973 (204,845,693) 7,180,177 $ (42,505,543) 54 II. REQUIRED SUPPLEMENTARY INFORMATION DOUGLAS COUNTY BOARD OF EDUCATION REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF PROPORTIONATE SHARE OF NET PENSION LIABILITY TEACHERS RETIREMENT SYSTEM OF GEORGIA FOR THE FISCAL YEAR ENDED JUNE 30 District's proportion of the net pension liability 2018 1.169398% 2017 1.183886% 2016 1.180525% 2015 1.221354% District's proportionate share of the net pension liability $ 217,336,220 $ 244,248,882 $ 179,723,209 $ 154,301,968 State of Georgia's proportionate share of the net pension liability associated with the District 379,884 618,933 433,427 480,712 Total $ 217,716,104 $ 244,867,815 $ 180,156,636 $ 154,782,680 District's covered payroll $ 134,253,308 $ 129,904,093 $ 124,746,171 $ 124,824,359 District's proportionate share of the net pension liability as a percentage of its covered payroll 161.89% 188.02% 144.07% 123.62% Plan fiduciary net position as a percentage of the total pension liability 79.33% 76.06% 81.44% 84.03% Note: Schedule is intended to show information for the last 10 fiscal years. Additional years will be displayed as they become available. 55 DOUGLAS COUNTY BOARD OF EDUCATION REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF CONTRIBUTIONS TEACHERS RETIREMENT SYSTEM OF GEORGIA FOR THE FISCAL YEAR ENDED JUNE 30 Contractually required contributions 2018 2017 2016 2015 $ 23,569,416 $ 19,157,947 $ 18,537,314 $ 16,387,830 $ Contributions in relation to the contractually required contributions 23,569,416 19,157,947 18,537,314 16,387,830 Contribution deficiency (excess) $ - $ - $ - $ - $ District's covered payroll $ 140,210,684 $ 134,253,308 $ 129,904,093 $ 124,746,171 $ Contributions as a percentage of covered payroll 16.81% 14.27% 14.27% 13.14% Note: Schedule is intended to show information for the last 10 fiscal years. Additional years will be displayed as they become available. 2014 15,301,164 $ 15,301,164 - $ 124,824,359 $ 12.26% 2013 14,223,779 $ 14,223,779 - $ 124,505,755 $ 11.42% 2012 12,695,949 $ 2011 12,865,793 $ 12,695,949 - $ 12,865,793 - $ 123,987,972 $ 124,740,716 $ 10.24% 10.31% 2010 12,287,112 $ 12,287,112 - $ 125,319,117 $ 9.80% 2009 11,629,926 11,629,926 - 124,926,441 9.31% 56 DOUGLAS COUNTY BOARD OF EDUCATION REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF PROPORTIONATE SHARE OF NET PENSION LIABILITY PUBLIC SCHOOLS EMPLOYEES RETIREMENT SYSTEM OF GEORGIA FOR THE FISCAL YEAR ENDED JUNE 30 District's proportion of the net pension liability District's proportionate share of the net pension liability State of Georgia's proportionate share of the net pension liability associated with the District Total District's covered-employee payroll District's proportionate share of the net pension liability as a percentage of its coveredemployee payroll Plan fiduciary net position as a percentage of the total pension liability 2018 0.000000% 2017 0.000000% 2016 0.000000% $ - $ - $ - $ 1,891,026 2,497,988 1,581,254 $ 1,891,026 $ 2,497,988 $ 1,581,254 $ $ 6,856,376 $ 6,396,975 $ 6,390,704 $ N/A 85.69% N/A 81.00% N/A 87.00% 2015 0.000000% - 1,923,001 1,923,001 9,435,322 N/A 88.29% Note: Schedule is intended to show information for the last 10 fiscal years. Additional years will be displayed as they become available. 57 DOUGLAS COUNTY BOARD OF EDUCATION REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF PROPORTIONATE SHARE OF NET OPEB LIABLITY SCHOOL OPEB FUND FOR THE FISCAL YEAR ENDED JUNE 30 District's proportion of the net OPEB liability District's proportionate share of the net OPEB liability Total District's covered-employee payroll District's proportionate share of the net OPEB liability as a percentage of its coveredemployee payroll Plan fiduciary net position as a percentage of the total OPEB liability 2018 1.377075% $ 193,478,483 $ 193,478,483 $ 111,409,524 173.66% 1.61% Note: Schedule is intended to show information for the last 10 fiscal years. Additional years will be displayed as they become available. 58 DOUGLAS COUNTY BOARD OF EDUCATION REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF CONTRIBUTIONS SCHOOL OPEB FUND FOR THE FISCAL YEAR ENDED JUNE 30 Contractually required contributions 2018 $ 7,154,276 Contributions in relation to the contractually required contributions 7,154,276 Contribution deficiency (excess) $ - District's covered-employee payroll $ 120,449,723 Contributions as a percentage of covered-employee payroll 5.940% Note: Schedule is intended to show information for the last 10 fiscal years. Additional years will be displayed as they become available. 59 DOUGLAS COUNTY BOARD OF EDUCATION NOTES TO REQUIRED SUPPLEMENTARY INFORMATION FOR THE FISCAL YEAR ENDED JUNE 30, 2018 Teachers Retirement System of Georgia: Changes of assumptions : In 2010 and later, the expectation of retired life mortality was changed to the RP2000 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 18, 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 Schools Employees Retirement System of Georgia: 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 the 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. 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. 60 III. OTHER SUPPLEMENTARY INFORMATION DOUGLAS COUNTY BOARD OF EDUCATION SCHEDULE OF EXPENDITURES OF SPECIAL PURPOSE LOCAL OPTION SALES TAX PROCEEDS FOR THE FISCAL YEAR ENDED JUNE 30, 2018 Project Original Estimated Cost (1) Current Estimated Cost (2) Expended In Current Year (3) Expended In Prior Years (3) Total Completion Cost Project Status SPLOST Issue 2011: The payment of a portion of principal and interest on the School District's Series 2005 and 2007 Bonds and Series 2010 Refunding Bond. $ 61,000,000 $ 57,481,335 $ 6,096,560 $ The adding to, renovating, repairing, improving, furnishing, equipping and completing existing school buildings and other buildings and facilities; acquiring technology improvements; acquiring and making modifications to land; acquiring new school equipment; acquiring band instruments, textbooks and instructional materials and equipment; acquiring any necessary or desirable property, both real and personal. 61,000,000 58,343,507 7,906,996 51,384,775 $ 39,361,765 57,481,335 Closed 47,268,761 Ongoing SPLOST Issue 2016: The payment of a portion of principal and interest on the School District's Series 2007 and Series 2010 Bonds and Series 2013 and Series 2014 Refunding Bonds. The constructing and equipping classrooms and instructional and support space; remodeling, renovating, modifying, and equipping classrooms, instructional and support space and other facilities (including physical education/athletic facilities) at existing school district facilities; acquiring property, both real and personal, and any interest therein, for educational or instructional purposes; acquiring furnishings, equipment and fixtures for new and existing facilities district-wide including, but not limited to technology equipment, safety and security equipment, textbooks, signage, band instruments, and playgrounds. 74,000,000 90,000,000 74,000,000 90,000,000 8,020,828 7,499,496 - 8,020,828 Ongoing 194,986 7,694,482 Ongoing Total $ 286,000,000 $ 279,824,842 $ 29,523,880 $ 90,941,526 $ 120,465,406 (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 project(s). Includes all cost from project inception to completion. (3) The voters of Douglas 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. 61 IV. SINGLE AUDIT SECTION INDEPENDENT AUDITOR'S REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS To the Superintendent and Members of the Douglas County Board of Education Douglasville, Georgia 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 Douglas County Board of Education, as of and for the year ended June 30, 2018, and the related notes to the financial statements, which collectively comprise the Douglas County Board of Education's basic financial statements, and have issued our report thereon dated December 11, 2018. Our report includes a reference to the changes in accounting principle resulting from the implementation of Governmental Accounting Standards Board Statement No. 75, Accounting and Financial Reporting for Postemployment Benefits Other Than Pensions. Internal Control Over Financial Reporting In planning and performing our audit of the financial statements, we considered the Douglas County Board of Education'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 Douglas County Board of Education's internal control. Accordingly, we do not express an opinion on the effectiveness of the Douglas County Board of Education'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 a combination of deficiencies, in internal control, such that there is a reasonable possibility that a material misstatement of the entity's financial statements will not be prevented, or detected and corrected on a timely basis. 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. Given these limitations, during our audit we did not identify any deficiencies in internal control that we consider to be material weaknesses. However, material weaknesses may exist that have not been identified. 200 GALLERIA PARKWAY S.E., SUITE 1700 ATLANTA, GA 30339-5946 770-955-8600 800-277-0080 FAX 770-980-4489 www.mjcpa.com Members of The American Institute of Certified Public Accountants Compliance and Other Matters As part of obtaining reasonable assurance about whether the Douglas County Board of Education'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. Purpose of this Report The purpose of this report is solely to describe the scope of our testing of internal control and compliance and the results of that testing, and not to provide an opinion on the effectiveness of the entity's internal control or on compliance. This report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the entity's internal control and compliance. Accordingly, this communication is not suitable for any other purpose. Atlanta, Georgia December 11, 2018 63 INDEPENDENT AUDITOR'S REPORT ON COMPLIANCE FOR EACH MAJOR FEDERAL PROGRAM AND ON INTERNAL CONTROL OVER COMPLIANCE REQUIRED BY THE UNIFORM GUIDANCE To the Superintendent and Members of the Douglas County Board of Education Douglasville, Georgia Report on Compliance for Each Major Federal Program We have audited the Douglas County Board of Education's compliance with the types of compliance requirements described in the OMB Compliance Supplement that could have a direct and material effect on each of the Douglas County Board of Education's major federal programs for the year ended June 30, 2018. The Douglas County Board of Education'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 Douglas County Board of Education'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 Douglas County Board of Education'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 Douglas County Board of Education's compliance. 200 GALLERIA PARKWAY S.E., SUITE 1700 ATLANTA, GA 30339-5946 770-955-8600 800-277-0080 FAX 770-980-4489 www.mjcpa.com Members of The American Institute of Certified Public Accountants Opinion on Each Major Federal Program In our opinion, the Douglas County Board of Education 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 major federal programs for the year ended June 30, 2018. Report on Internal Control Over Compliance Management of the Douglas County Board of Education 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 Douglas County Board of Education'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 Douglas County Board of Education's internal control over compliance. 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. 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. Our consideration of internal control over compliance was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control over compliance that might be material weaknesses or significant deficiencies. We did not identify any deficiencies in internal control over compliance that we consider to be material weaknesses. However, material weaknesses may exist that have not been identified. 65 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. Atlanta, Georgia December 11, 2018 66 DOUGLAS COUNTY BOARD OF EDUCATION SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS FOR THE FISCAL YEAR ENDED JUNE 30, 2018 Federal Grantor/Pass-Through Grantor/Program Title U. S. DEPARTMENT OF AGRICULTURE: Passed through Georgia Department of Education: Child Nutrition Cluster School Breakfast Program - Cash Assistance National School Lunch Program: Non-Cash Assistance - Commodities (1) Cash Assistance School Snack Program Total Child Nutrition Cluster Total U. S. Department of Agriculture U. S. DEPARTMENT OF DEFENSE Junior R.O.T.C. Total U. S. Department of Defense U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES Abstinence Education and Youth Development Grant Total U.S. Department of Health and Human Services U. S. DEPARTMENT OF EDUCATION Passed through the Georgia Department of Education: Title I, Part A Program - Local Education Agency Title I, Part A Program - Local Education Agency Total Title I, Part A Program Title II-A - Advanced Placement Grant Title II-A - Improving Teacher Quality Total Title II Program Special Education Cluster (IDEA) Title VI-B Preschool Title VI-B Preschool Title VI-B Flowthrough Title VI-B Flowthrough Title VI-B High Cost Fund Pool Total Special Education Cluster (IDEA) Education for Homeless Children and Youth Education for Homeless Children and Youth Total Education for Homeless Children and Youth Title III Program Title III - Limited English Proficient Title III - Limited English Proficient Total Title III Program Federal CFDA Number Pass Through Entity Identifying Number Total Expenditures 10.553 10.555 10.555 10.555 18185GA324N1099 $ 18185GA324N1100 18185GA324N1100 18185GA324N1100 2,868,552 810,066 7,656,024 261,300 11,595,942 11,595,942 12.unknown N/A 308,127 308,127 93.235 N/A 9,970 9,970 84.010 84.010 84.367 84.367 84.173 84.173 84.027 84.027 84.027 84.196 84.196 84.365 84.365 S010A160010 S010A170010 S367A170001 S367A170001 585,702 4,870,811 5,456,513 5,450 706,283 711,733 H173A160081 H173A170081 H027A160073 H027A170073 H027A170073 S196A160011 S196A170011 5,607 108,301 319,430 3,926,918 52,444 4,412,700 207 42,854 43,061 S367A160001 S367A170001 39,558 157,013 196,571 (Continued) 67 DOUGLAS COUNTY BOARD OF EDUCATION SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS FOR THE FISCAL YEAR ENDED JUNE 30, 2018 Federal Grantor/Pass-Through Grantor/Program Title Federal CFDA Number Pass Through Entity Identifying Number Total Expenditures U. S. DEPARTMENT OF EDUCATION (Continued): Passed through Georgia Department of Education (continued): Vocational Education - Program Improvement Vocational Education - Perkins IV - Reserve - Perkins Carryover Total Vocational Education 84.048 84.048 V048A170010 V048A170010 191,294 10,526 201,820 Title IV A - Student Support and Academic Enrichment 84.424 S424A170011 61,242 Title IV B - Twenty-first Century Community Learning Centers Title IV B - Twenty-first Century Community Learning Centers Total Title IV B - Twenty-first Century Community Learning Centers 84.287 84.287 S287C160010 S287C170010 207,258 2,006,371 2,213,629 Total Passed Through Georgia Department of Education 13,297,269 Total U. S. Department of Education 13,297,269 Total Expenditures of Federal Awards $ 25,211,308 (1) The amounts shown for the Food Distribution Program represents the federally assigned value of nonmonetary assistance for donated commodities received and/or consumed by the system during the current fiscal year. The Schedule of Expenditures of Federal Awards includes the federal grant activity of the Douglas County Board of Education and is presented on the modified accrual basis of accounting. The School District did not utilize the 10% de minimis indirect cost rate. 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. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of the financial statements. 68 DOUGLAS COUNTY BOARD OF EDUCATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS FOR THE YEAR ENDED JUNE 30, 2018 SECTION I SUMMARY OF AUDITOR'S RESULTS Financial Statements Type of report the auditor issued on whether the financial statements audited were prepared in accordance with GAAP: Unmodified Internal control over financial reporting: Material weaknesses identified? yes X no Significant deficiencies identified? yes X none reported Noncompliance material to financial statements noted? yes X no Federal Awards Internal Control over major federal programs: Material weaknesses identified? yes X no Significant deficiencies identified? yes X none reported Type of auditor's report issued on compliance for major federal programs: Unmodified Any audit findings disclosed that are required to be reported in accordance with 2 CFR 200.516(a)? yes X no Identification of major federal program: Name of Federal Program or Cluster Child Nutrition Cluster CFDA Number 10.553 and 10.555 Dollar threshold used to distinguish between Type A and Type B programs: $756,339 Auditee qualified as low-risk auditee? X yes no 69 DOUGLAS COUNTY BOARD OF EDUCATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS FOR THE YEAR ENDED JUNE 30, 2018 None reported. None reported. SECTION II FINANCIAL STATEMENT FINDINGS AND RESPONSES SECTION III FEDERAL AWARDS FINDINGS AND QUESTIONED COSTS 70 None reported. DOUGLAS COUNTY BOARD OF EDUCATION SCHEDULE OF PRIOR AUDIT FINDINGS FOR THE YEAR ENDED JUNE 30, 2018 STATUS OF PRIOR YEAR FINDINGS 71