Loading...
HomeMy WebLinkAbout2017 City of Rexburg, Idaho - Financial Statements-signed       CITY OF REXBURG, IDAHO          _______________    BASIC FINANCIAL STATEMENTS  AND SUPPLEMENTARY INFORMATION  WITH  INDEPENDENT AUDITOR’S REPORT  YEAR ENDED SEPTEMBER 30, 2017  _______________  CITY OF REXBURG, IDAHO TABLE OF CONTENTS Page INDEPENDENT AUDITORS' REPORT ....................................................................... 1-3 MANAGEMENT’S DISCUSSION AND ANALYSIS ................................................. 4-20 BASIC FINANCIAL STATEMENTS: Statement of Net Position – Government Wide ......................................................... 22 Statement of Activities – Government Wide .............................................................. 23 Balance Sheet – Governmental Funds...................................................................... 24 Reconciliation of the Balance Sheet of Governmental Funds to The Statement of Net Position ............................................................................... 25 Statement of Revenues, Expenditures, and Changes in Fund Balances – Governmental Funds .......................................................................... 26 Reconciliation of the Statement of Revenues, Expenditures, and Changes in Fund Balances of Governmental Funds to the Statement of Activities ........................................................................................... 27 Statement of Net Position – Proprietary Funds ......................................................... 28 Statement of Revenues, Expenses, and Changes in Fund Net Position – Proprietary Funds ........................................................................... 29 Statement of Cash Flows--Proprietary Funds ........................................................... 30 Notes to Financial Statements: 1 Summary of Significant Accounting Policies .................................................. 31-36 2 Cash and Short-term Investments ................................................................. 36-39 3 Capital Assets ................................................................................................ 40-41 4 Revolving Loans Receivable ......................................................................... 41-42 5 Property Taxes ................................................................................................... 42 6 Accrued Compensated Absences/Post Employment Health Plan ...................... 43 7 Health Reimbursement Arrangement (HRA) ....................................................... 44 CITY OF REXBURG, IDAHO TABLE OF CONTENTS (Continued) 8 Local Improvement Assessments ....................................................................... 44 9 Local Improvement District Warrants Payable ............................................... 44-45 10 Wastewater Revenue Bonds Payable ................................................................ 45 11 Water DEQ Loan Payable .................................................................................. 45 12 Obligations Under Capital Leases ...................................................................... 46 13 Changes in Long-term Obligations ..................................................................... 46 14 Bonded Debt Repayment Requirements ............................................................ 47 15 Retirement Plans ........................................................................................... 47-57 16 Other Required Individual Fund Disclosures ................................................. 57-58 17 Component Unit--Rexburg Urban Renewal Agency ...................................... 58-60 18 Interfund Transactions ................................................................................... 61-63 19 Lease with Hospital ............................................................................................ 64 20 Fund Balances……………………………………………………………………..64-66 21 Fund Balance Classifications.............................................................................. 66 21 Golf Course Fund Reclassification ..................................................................... 66 REQUIRED SUPPLEMENTARY INFORMATION: Budgetary Comparison Schedule – General Fund .................................................... 68 Budgetary Comparison Schedule – Street Fund ....................................................... 69 Budgetary Comparison Schedule – Emergency Services Fund ................................ 70 Schedule of Employer’s Share of Net Pension Liability And Employer Contribution – PERSI Base Plan ....................................................... 71 Schedule of Employer’s Share of Net Pension Liability And Employer Contribution – FRF Base Plan ........................................................... 72 Schedule of Employer’s Share of Net Pension Liability And Employer Contribution – FRF Excess Plan ........................................................ 73 OTHER SUPPLEMENTARY INFORMATION: Combining Balance Sheet – Nonmajor Governmental Funds .............................. 75-79 Combining Schedule of Revenues, Expenditures and Changes in Fund Balances – Nonmajor Governmental Funds ........................ 80-84 Schedule of Expenditures of Federal Awards ........................................................... 85 Notes to Schedule of Expenditures of Federal Awards ............................................. 86 CITY OF REXBURG, IDAHO TABLE OF CONTENTS (Continued) INDEPENDENT AUDITORS’ 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 ...................... 87-88 INDEPENDENT AUDITORS’ REPORT ON COMPLIANCE FOR EACH MAJOR PROGRAM AND ON INTERNAL CONTROL OVER COMPLIANCE REQUIRED BY THE UNIFORM GUIDANCE ......................................................................................... 89-91 Schedule of Findings and Questioned Costs ....................................................... 92-93 Schedule of Prior Year Findings and Questioned Costs ........................................... 94 1 INDEPENDENT AUDITOR’S REPORT To the Honorable Mayor and City Council City of Rexburg, Idaho Report on the Financial Statements We have audited the accompanying financial statements of the governmental activities, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information of City of Rexburg, Idaho, as of and for the year ended September 30, 2017, and the related notes to the financial statements, which collectively comprise the City’s basic financial statements as listed in the table of contents. Management’s Responsibility for the Financial Statements Management is responsible for the preparation and fair presentation of these financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Auditor’s Responsibility Our responsibility is to express opinions on these financial statements based on our audit. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free from material misstatement. An audit involves performing procedures to obtain audit evidence about the amounts and disclosures in the financial statements. The procedures selected depend on the auditor’s judgment, including the assessment of the risks of material misstatement of the financial statements, whether due to fraud or error. In making those risk assessments, the auditor considers internal control relevant to the entity’s preparation and fair presentation of the financial statements in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the entity’s internal control. Accordingly, we express no such opinion. An audit also includes evaluating the appropriateness of accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluating the overall presentation of the financial statements. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our audit opinions. 2 Basis for Qualified Opinion Management has not included negative fund balances as unassigned fund balances in the City’s financial statements as outlined in footnote 19. Accounting principles generally accepted in the United States of America require all negative fund balances be classified as unassigned funds in the governmental funds statements. The City’s management feels that it is more consistent and useful to show the negative fund balances in the appropriate fund type. Opinions In our opinion, except for the effects of the matter described in the “Basis for Qualified Opinion” paragraph, the financial statements referred to above present fairly, in all material respects, the respective financial position of the governmental activities, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information of the City of Rexburg, Idaho, as of September 30, 2017, and the respective changes in financial position, and, where applicable, cash flows thereof for the year then ended in accordance with accounting principles generally accepted in the United States of America. Emphasis of Matter – Change in Fund Classification As described in Note 1 and 22 to the financial statements, starting in 2017 the City is reporting the golf course fund with the governmental funds rather than in the business type funds. Other Matters Required Supplementary Information Accounting principles generally accepted in the United States of America require that the management’s discussion and analysis, budgetary comparison information and information and schedule of pension liabilities and contributions which are listed in the table of contents be presented to supplement the basic financial statements. Such information, although not a part of the basic financial statements, is required by the Governmental Accounting Standards Board, who considers it to be an essential part of financial reporting for placing the basic financial statements in an appropriate operational, economic, or historical context. We have applied certain limited procedures to the required supplementary information in accordance with auditing standards generally accepted in the United States of America, which consisted of inquiries of management about the methods of preparing the information and comparing the information for consistency with management’s responses to our inquiries, the basic financial statements, and other knowledge we obtained during our audit of the basic financial statements. We do not express an opinion or provide any assurance on the information because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance. Other Information Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the City of Rexburg, Idaho’s basic financial statements. The combining and individual nonmajor fund financial schedules are presented for purposes of additional analysis and are not a required part of the basic financial statements. The schedule of expenditures of federal awards is presented for purposes of additional analysis as required by Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, and is also not a required part of the basic financial statements. 3 The combining and individual nonmajor fund financial schedules and the schedule of expenditures of federal awards are the responsibility of management and were derived from and relate directly to the underlying accounting and other records used to prepare the basic financial statements. Such information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or to the basic financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the combining and individual nonmajor fund financial statements, the schedules of loans payable and the schedule of expenditures of federal awards are fairly stated in all material respects in relation to the basic financial statements as a whole. Other Reporting Required by Government Auditing Standards In accordance with Government Auditing Standards, we have also issued our report dated March 2, 2018, on our consideration of the City of Rexburg, Idaho’s internal control over financial reporting and on our tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements and other matters. The purpose of that report is to describe the scope of our testing of internal control over financial reporting and compliance and the results of that testing, and not to provide an opinion on internal control over financial reporting or on compliance. That report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the City of Rexburg, Idaho’s internal control over financial reporting and compliance. Rexburg, Idaho March 2, 2018 4 Management’s Discussion and Analysis Matthew K. Nielson, Chief Financial Officer Our discussion and analysis of the City of Rexburg’s financial performance provides an overview of the City’s financial activities for the fiscal year ended September 30, 2017. Please read this in conjunction with the City’s financial statements, which begin on page 22. FINANCIAL HIGHLIGHTS The assets and deferred outflows of the City exceeded its liabilities and deferred inflows at September 30, 2017 by $105,571,063.  Of this amount, ($2,859,940) of unrestricted net position and $24,671,648 of restricted assets is available to meet the City’s ongoing obligations to citizens and creditors.  The City’s net position increased $6,066,585 as a result of this year’s operations, which includes an increase of governmental type net position by $4,375,633 and of business-type net position by $1,690,952.  At fiscal year end, the City’s governmental funds reported combined ending fund balances of $13,189,154, an increase of $2,390,775 from last year.  The General Fund Balance was $4,489,233 or 42.38% of the total General Fund Expenditures and Fund Transfers. This leaves about a 5 month reserve in place. This is a 10.42% increase over the prior year. Of this balance, $347,000 was appropriated in the budget of the following fiscal year. OVERVIEW OF THE FINANCIAL STATEMENTS The Government-wide Financial Statements are presented in a format designed to provide a broad overview in a business-like manner. These statements include all assets and liabilities using full accrual accounting, which is similar to accounting used by most large businesses. Full accrual accounting reports all of the current year’s revenues and expenses when they are obligated, regardless of whether or not cash has yet been received or paid out. You will also need to consider non-financial factors, such as changes in the City’s property tax base and the condition of its streets, to assess its overall health. These statements distinguish functions that are principally supported by taxes and inter- governmental revenues (governmental activities) from functions that are supported by user fees (business-type activities). Governmental activities include: general administration, public safety, streets, parks, recreation, arts, and community development. The business-type activities include: water, wastewater (sewer), and sanitation (garbage). The golf courses were reclassified in 2017 to a governmental activity, rather than a business-type activity. The government-wide financial statements also include separately the financial information of the Rexburg Redevelopment Agency as a component unit. 5 The Statement of Net Position presents information on all of the City’s assets, liabilities, and deferred inflows/outflows of the City. The difference between them is called the Net Position. Over time, increases or decreases in net position may serve as a useful indicator of whether the financial position of the City is improving or deteriorating. The Statement of Activities defines the change in Net Position by reporting expenses of the different functions of the City and related revenues. Here expenses are listed before revenues in order to emphasize that in City government, revenues are generated to support the different functions and are not the driving force, service needs or functions are. The City is not here to make a profit, unlike business; it first identifies the service needs of its citizens and then raises the resources to meet those needs. Fund Financial Statements are used to maintain control over resources that have been segregated for specific activities, objectives or as may be required by law or grant or bond agreements. Major funds are shown in separate columns and include the General Fund, Street s, Emergency Services, Water, Wastewater, and Sanitation; all other funds are non-major funds and are summarized in one column. Details of the non-major funds are shown under Other Supplementary Information on pages 75-84 of this report. All of the funds of the City are also divided into two categories, governmental or enterprise (business -type). Governmental Funds Financial Statements focus more on current inflows, outflows and balances (reporting more on a cash/partial accrual accounting basis instead of a full accrual basis) rather than on long term effects on net position, such as depreciation might have, which is included in the Government-wide Statements. The City maintains 74 active funds, 66 are governmental funds and 8 are categorized as Enterprise Funds, which are the Utility funds. Enterprise Funds Financial Statements are used to report the business-type activities (supported by user fees) of the City that include the Utility Funds. These funds are reported on a full accrual basis, which is the same as the business-type accounting used in the Government-wide Financial Statements for all funds, but include more detail here. GOVERNMENT-WIDE FINANCIAL ANALYSIS Net Position For the years ended September 30, 2017 and September 30, 2016, Net Position changed as follows: Governmental Business-type All Activities Activities Activities Net Position 9/30/16 $ 57,584,695 $ 41,919,783 $ 99,504,478 Reclassification of Golf 717,751 -717,751 Increase in Net Position $ 3,657,882 $ 2,408,703 $ 6,066,585 Net Position 9/30/17 $ 61,960,328 $ 43,610,735 $105,571,063 Percent Increase 7.60% 4.03% 6.10% 6 Large item (over $50,000) increases came from: Purchase of new patrol vehicles/equipment (2) $ 87,318 Beehive Pavilion-Contributed Asset $ 105,000 2012 Deere Grader-Used $ 172,357 Heavy Brush International Truck-Fire Dept. $ 198,083 Small Brush Ram Truck (2)-Fire Dept. $ 261,425 Command Vehicles-2017 Tahoe (2)-Fire Dept. $ 96,661 Water Tender Truck-Fire District $ 103,541 1965 Beech Airplane $ 101,655 LID Projects-Water Portion $ 93,317 Replace Pump/Shaft/Bearing-Well #5 $ 51,065 LID Projects-Wastewater Portion $ 105,912 Field Lighting-Riverside Park-Phase I $ 227,518 Center Street Project: Water Portion $ 87,972 Wastewater Portion $ 50,486 Street Lights (17) $ 180,950 Reconstruct Sidewalk/Curb and Gutter $ 415,711 Trees/Landscape/Fire Pits $ 186,131 Reconstruct Street $ 233,580 Final Design/Architect Drawings $ 30,115 Romance Up Lights/Sprinkler Line Connection $ 8,969 Total Center Street Project 2017 (Phase I) $ 1,193,914 Water System Upgrade Project: Contracted Design/Engineering $ 185,064 Pipe for Extension & Replacement $ 373,810 Water Line Replacement/Expansion $ 2,706,591 Non-Grant Water Projects $ 0 SCADA Water Upgrade $ 64,012 In-house Engineering $ 65,317 Total Water System Upgrade Project 2017 (Phase II) $ 3,394,794 Seal coat and Chip Seal Street Projects $ 99,184 Traffic Signal- 7th S & University $ 267,076 Airport-relocation master plan study-FAA-On-going $ 265,105 Wastewater Plant improvements $ 4,121,412 LID 46-Street reconstruct-4th S-5th W to 2nd W Final $ 56,886 LID 47-Street reconstruct-5th W -Kennedy to 4th S $ 308,086 LID 47-Street reconstruct-4th W -Main to 1st N $ 85,288 LID 47-Street reconstruct-Ricks Avenue $ 59,419 LID 47-Street reconstruct-2nd W -1st N to 2nd N $ 95,860 Street Widening-2nd E-Stationary to Moody Rd-URA $ 226,873 Large Street Lighting Project-various locations (23 lights) $ 213,006 Also, see Note #3 on page 40 to 41. 7 Because the City has not been required by the Governmental Accounting Standards Board (GASB) to list streets and storm sewers acquired before October 1, 2003, those items are not included in the Beginning Net Asset amounts under Governmental Activities. All acquisitions of streets and storm sewers on or after that date will be included. The City may decide in the future to estimate the historical cost of those previously acquired streets and storm sewers and adjust the beginning balances at that time. 8 A summary of long-term transactions of the City for the year ended September 30, 2017, is as follows: There are currently no outstanding General Obligation Bonds. Governmental Activities The format of the Statement of Activities lists the expenses first and then the revenues with a resulting Net Expense. The reason for this kind of format is to highlight the relative financial burden or subsidy of each of the functions on the general revenues of the City, including property tax, after that function’s specific revenues are subtracted. 9 The City strives to maintain a total general fund committed fund balance equal to a minimum of 25%, or greater, of general fund budgeted expenditures for the last ended fiscal year for the necessary cash flow, for unforeseen emergencies, and to mitigate current and future risks. General and Administrative (Mayor & City Council, Economic Development, Customer Services, Information Systems, Financial Management, Human Resources, Building Maintenance, Legal, Planning and Zoning, Engineering, GIS, Building Safety, Shop, and miscellaneous other departments). A majority of these departments’ expenditures is offset by related r evenues. Public Safety (Police and Emergency Services) It is important to note that the Police and Fire functions create the most financial burden on the general revenues, but, customarily, that is what property tax is for. In an effort to provide the most efficient and effective funding of fire and ambulance services in Madison County, the City of Rexburg, the Madison County Ambulance District, and the Madison County Fire Protection District have formed a joint venture doing business as the Madison Fire Department. Madison County reimburses the City for Ambulance expenses and its portion of shared expenses. Madison County Fire Protection District also reimburses the City for its portion of shared expenses. Parks, Recreation and Cultural Arts The Parks Department is mostly funded by General Revenues. Only about $8,100 was taken in as parks reservation fees in 2017. The Recreation Administrative expenses are heavily subsidized by General Revenues, while the Recreation Programs are intended to be self-sufficient. In 2017, a transfer of over $56,105 from the general fund was made to subsidize 2017 losses in the recreation program fund. $41,845 of this transfer covered the building lease and operating deficit for “The Zone Rexburg Recreation Center.” We would anticipate that the Zone will continue to need to be subsidized each year. In 2017 the operating fund of the water park Rexburg Rapids experienced an operating loss of approximately $59,000, their largest operating loss in a single year. The City Council also transferred $65,000 from the general fund that will be kept in reserve for future major capital projects or repairs at the water park. When Rexburg Rapids was opened in 2011, a $99,000 reserve was put in place to cover operating losses. In 2017 the $99,000 reserve was exhausted. The seven year operating loss, including the $99,000, reached an amount of $126,824, which means Rexburg Rapids has been ran with an average operating loss of $18,117 per year in its first seven seasons. Cultural Arts includes the Tabernacle Civic Center and Museum of Rexburg (formerly Teton Flood Museum), the Legacy Flight Museum, the Romance Theater, the Rexburg Orchestra, and the Rexburg Cultural Arts fund. The Cultural Arts Funds are also heavily subsidized by general revenues and taxes. The Cultural Arts Funds were subsidized approximately $271,313 in 2017. Streets The Street Department is funded by State Highway User Fees, County Road & Bridge Property Taxes, and other charges and is not subsidized by General Revenues, except for 77.7% of the Rocky Mountain Power franchise fees that have been allocated to that fund. 10 11 Business-type Activities Utility Funds The Utility Departments include the Sanitation, Water, and Waste Water departments. The City maintains separate Capital Reserve Funds for Water and Wastewater that are funded through capacity fees and used for large construction projects to expand capacity. In 2010 the City started a project to expand the Wastewater Treatment plant and wastewater lines to increase capacity and to also address some other maintenance concerns at the existing plant , which work should conclude in the spring of 2018. In order to pay for the construction maintenance upgrades and expansion of the plant, the city secured a revenue bond of 10 million dollars on December 8, 2010, which will be paid back with capital reserve funds and increases in utility fees. The utility funds, which include utility operations, water capital reserve, sewer capital reserve, water capital construction, sewer/water line extension, and the sewer plant construction funds, decreased in cash and short term investments by $1,291,750, ending the year with a balance of $11,766,216. 12 The City of Rexburg provides wastewater treatment services to the City of Sugar City and the City of Teton at a per gallon charge that includes operating costs. Both cities have provided their share of capital up front through the payment of capitalization fees that reserve certain amounts of capacity for their usage. Those two cities together provide 5.95% of the total monthly billed revenue for the wastewater department. Sewer rates were last increased on October 1, 2017. Water rates were last increased on October 1, 2017. Sanitation rates were last increased on October 1, 2017. Water and sewer capacity fees were last increased in March 2017. We received the final findings of the water facilities planning study at the end of 2015 and began construction in 2016. The projected improvements will require additional funding beyond that available in our capital and operating reserve funds. The water upgrades will be funded with a combination of reserves and a loan from the Department of Environmental Quality (DEQ) of up to $11,100,000, which includes principal forgiveness of up to $2,211,300. The water project will provide needed production, storage, and delivery capacity to meet the current water demands and future water demands as our population grows. The city also substantially completed a final phase of improvements in 2017 at the wastewater treatment plant to eliminate odors, add new capacity, and help with the disposal of bio-solids. In 2012 the City began to provide curb-side pickup for recycling to single family residents at no additional cost to the customer. In 2015 the majority of single family residents were receiving the recycling option. The Recycling Program is a joint effort with Brigham Young University Idaho and a third party vendor. In 2014, 2015, and 2016 it became necessary to increase the recycling contract expenses in order to maintain the program at its current service level . There was no increase in recycling costs in 2017, but our third party vendor has indicated a substantial increase in fees will be necessary in 2018 because they are no longer able to sell all recyclables and have been forced to pay tipping fees for some items, which costs will now be passed on to the city . The city is not currently seeking to add the recycling option to commercial and multi -family users because the costs have increased and the value of the recycled products has dropped. When we recycle goods, it reduces the Madison County tipping fees expense we would otherwise pay for disposing goods. FUND FINANCIAL STATEMENT ANALYSIS As noted earlier, the City of Rexburg uses fund accounting to ensure and demonstrate compliance with legal, grant and budget requirements. Governmental Funds The focus of the City of Rexburg Governmental Funds is to provide information on current year cash flows and balances. Such information is useful in assessing the City’s current year financing requirements. In particular, unassigned fund balances that are not held for emergencies or cash flow purposes, may serve as a useful measure of the City’s net resources available for spending at the end of the fiscal year that could be added to expected revenues for the following fiscal year. The General Fund Balance (see page 68) increased by $423,487 during the year, due to actual expenses lower than the final expenses budgeted. The Street Funds’ Balances (see page 69) increased by $1,459,313, leaving a fund balance of $3,214,242. The fund balance will be carried over for projects that are already planned and budgeted for in future years. A significant portion of the fund balance is from receivables due from 13 the Urban Renewal Agency for a project that was substantially completed in fiscal year 2014 on the corner of 2nd West and 1st North and another project substantially completed from 2015 to 2016 on 2nd east near the new W almart. We anticipate the full payoff of these receivables within two years. The Emergency Services Fund (see page 70) is financed by three entities: the City of Rexburg (for fire suppression services), the Madison County Fire Protection District, and the Madison County Ambulance District. All expenditures are billed to the three entities based on the benefit received by each. The fund balance is normally always zero because the three entities reimburse all expenditures. The Emergency Services Fund ended the fiscal year $137,000 over budget. Police, Fire, Parks and Street Development Impact Fees were collected in the amounts of $82,622, $70,433, $425,635, and $475,671 respectively, totaling $1,054,371 for capital improvements in those departments. It is important to illustrate the need for impact fees by looking at the fund balances of each respective fund to determine the health of those funds in providing the necessary capital to meet the demands of the growth in our community and its impact on our c urrent service levels. At the end of the fiscal year 2017, the Police Impact Fee Fund was at a deficit of ($37,200) due to the purchase of the old street shop to be used as a storage/training facility. The Fire Impact Fee Fund had a balance of $55,845, which will help fund the future replacement of fire engines and expansion or addition of fire stations. The Parks Impact Fee Fund balance was $1,032,900 and is being accumulated for future projects, such as the addition of a baseball/softball quad at Community Fields and a possible future park location, which we hope to identify in the next few years with a park study being performed in 2018. The Street Impact Fees Fund balance is normally zeroed out as the expenses of qualified projects typically surpass the revenues provided from the Street Impact fees, however at this time, there is a current available balance that can be used for qualified street projects of $534,128. The Joint Fire Equipment Fund has a positive fund balance of $367,770, which comes from contributions by the City and the Madison County Fire Protection District . These funds are for future purchases of fire equipment. The GIS (Geographic Information System) Fund was first created in 2004 to track the funding of the joint City/County GIS Department on a 50/50 financing split. As mentioned earlier, the Golf Fund was reclassified to a governmental type fund from a business- type fund, and is not considered a major fund. Reports for the golf funds can be found in the combining statements. The golf courses, Teton Lakes of 27 holes and the Municipal Course (renamed in 2016 the “Legacy Golf Course”) of 9 holes, are jointly owned and managed by the City of Rexburg and Madison County. Their governing boards appoint a Golf Board consisting of 6 citizens and a member of each of the governing boards to act as a liaison to the Board. At the end of the fiscal year, together, the Golf Fund and Golf Construction Fund had a cash deficit of $616,746 (an increase of $3,806 over the prior fiscal year), which was covered by a loan from the City, half of which is guaranteed by the County. There was no transfer to the Golf Course Construction Fund at the end of the fiscal year from the Golf Operations Fund to pay down the cash deficit. The City and County did reduce the deficit $15,000 each (total of $30,000) with transfers from their general funds, which we plan to continue to do in the near future. The City and County are currently in the process of renegotiating the golf contract with the Golf Manager a nd expect to make some financial changes that will allow the golf course to operate in the black and help us address some necessary capital needs in the near future. 14 Proprietary Funds The City of Rexburg proprietary funds provide the same type of inform ation found in the government-wide statements, but in more detail. At the beginning of Fiscal Year 2015 it was decided to segregate t he Sanitation, Water and Wastewater Departments from the Utility Operations Fund (Fund 25). Fund 25 is the Sanitation Fund, Fund 26 the Water Operations Fund, and Fund 27 the Wastewater Operations Fund. These operating funds ended the year with net income of $3,918,803, of which $0 was due to contributed assets from developers. The Utility Operations Funds increased in cash by $31,154 ending the year with a balance of $9,504,747 in cash and investments. The Sanitation Fund ended with a balance of $709,421. The Water Operation Fund ended with a balance of $5,977,937. The Wastewater Operations Fund ended with a balance of $2,817,389, which was a decrease of $1,216,479 from the prior year . The City expects to use a significant portion of the water operating reserves for construction projects in 2018 and 2019. GENERAL FUND BUDGETARY HIGHLIGHTS Revenues Total Budget of Revenues $11,018,000 Budgeted Cash Carryover (Deficit) $ 62,700 Budgeted Revenues Expected Net of Carryover $10,955,300 Actual Revenues received $11,016,777 Surplus (Deficit) of Revenues vs. Budget $ (1,223) Expenditures Total Budget of Expenditures $11,018,000 Actual Expenditures $10,593,290 Under (Over) Budget $ 424,710 Excess (Deficiency) of Revenues over Expenditures $ 423,487 Fund Balance Beginning Fund Balance $ 4,065,746 Ending Fund Balance $ 4,489,233 However, some individual accounts showed variations that are notable: Significant Revenues Overage (Shortage) Property Tax $ 49,427 Franchise Fees- Rocky Mountain Power $ 19,626 Franchise Tax-Cable One $ 20,369 Investments/Unrealized Gain (Loss) $ (120,307) Miscellaneous Revenue-Significantly Solar Eclipse $ (101,123) Contributed Assets-Beehive Pavilion $ 105,000 Engineering Projects $ (68,466) Shop Expenses $ 54,291 15 Significant Expenditures Under (Over) Budget Mayor/Council $ 89,650 Customer Services $ 37,709 Information Technology $ 54,839 Financial Management $ 64,631 Police Administration $ 55,697 Engineering $ 70,535 Parks and Ball Diamonds due to Contributed Pavilion $ (95,089) Recreation Administration $ 74,615 Transfer to Planning and Zoning $ 35,091 Transfer to Tabernacle $ 52,379 Transfer to Joint Fire Operations $ (41,013) STREET FUND BUDGETARY HIGHLIGHTS Revenues Total Budget of Revenues $ 7,595,100 Actual Revenues received $ 5,961,963 Surplus (Deficit) of Revenues vs. Budget $(1,633,137) Expenditures Total Budget of Expenditures $ 7,595,100 Actual Expenditures $ 4,502,650 Surplus (Deficit) of Expenses vs. Budget $ 3,092,450 Excess (Deficiency) of Revenues vs. Expenses $ 1,459,313 Fund Balance Beginning Fund Balance $ 1,754,929 Ending Fund Balance $ 3,214,242 However, some individual accounts showed variations that are notable: Significant Revenues Overage (Shortage) Franchise Fees-Rocky Mountain Power $ 68,223 State Highway User Funds $ 108,778 County Road & Bridge $ (34,920) Contributions in Street Repair Fund $ 699,844 Contributed Capital (new finished streets) $ (500,000) Urban Renewal Reimbursements $ (900,000) Transfer in to Street Repair Fund from other street funds $ (294,700) Transfer in to New Street Construction Fund from DIF Fund $ 125,671 Significant Expenditures Under Budget (Over Budget) Street Operations Personnel Costs $ 126,376 Street Operations Other Costs-In large part from transfer to Street Reconstruction Fund $ (211,384) Capital Improvements-Street Repair $ 960,564 Capital Improvements-New Streets $ 2,251,711 Contributed Capital (new finished streets) $ 500,000 Urban Renewal Projects to be reimbursed $ 893,478 16 EMERGENCY SERVICES DEPARTMENT FUND BUDGETARY HIGHLIGHTS The City of Rexburg, through an agreement with Madison County Fire Protection District and the Madison Ambulance District, is responsible for the administration and accounting of the Emergency Services Department (ESD) operations. A governing board made up of one elected official from each entity plus a doctor, sets policies as needed for the department. ESD Fund Revenues are almost all provided by the sharing of costs by three entities: the City of Rexburg and the Madison Fire Protection District through an Operating Transfer in, and the Madison Ambulance District through warrants paid to the City. Costs are reimbursed based on benefits received by the three entities. The ESD Department utilized ambulance and fire equipment on site at various wild land fires throughout the state and nation. For their work, the respective entity that supplied equipment received reimbursement revenues that helped reduce the shared costs needed by the three entities that fund the ESD operations. They also sent out personnel to help in the wild land fire efforts and received reimbursement revenues to cover the wages and benefits paid to the employees. The Madison Ambulance District paid approximately 49% of the costs during the past fiscal year. The City and the Madison Fire District each paid about 32% and 19% respectively. ESD Operating Fund Revenues and Expenses were both approximately $137,606 over budget – both because this fund is usually zeroed out at the end of the year and any savings or overruns are shared by the three entities immediately. The City’s share of the net expenses was $866,013 of an $825,000 budget, or $41,013 over budget. REXBURG URBAN RENEWAL AGENCY Separately issued financial statements for the Rexburg Urban Renewal Agency, a component unit of the City of Rexburg is available at the City offices. 17 The Total Expense Budget pie chart shows the relative size of the departments or categories of expense budgets. Each Total Expense category includes both opera ting expense and capital purchase expense. Operating Expense does not include capital expense and is the amount needed to fund the day to day operations of the City. Capital Expense is usually defined as an expense if the benefit or item purchased is expected to last two or more years. Construction is generally the largest piece of the pie each year and is capital in nature, but varies widely from year to year in amount, due to the available funding and the particular needs of that year. Fund Transfers are made between different funds to pay for charges for services given or to fund the deficit position of particular funds with a transfer from the General Fund. The total expenses in 2017 increased by approximately $7.2 million dollars compared to 2016. This was due in part to construction upgrades in the water and sewer departments and an increase in emergency services due to the purchase of fire capital, wildland deployments, and an increase in personnel costs that was offset in large part by a contribution from BYU Idaho. Because of these construction projects, the transfers also increased significantly as we transferred monies from the capital and operating reserves to the construction funds to cover the construction expenses. 18 The Total Revenue Budget pie chart shows the relative size of the categories of revenue budget by source. Total Revenue categories include both operating revenue and revenue that is restricted to capital purchases. Operating Revenue does not include revenue reserved f or capital purchases and is the amount needed to fund the day to day operations of the City. Capital Revenue is usually defined as: revenue reserved to be used on purchases that are expected to last two or more years. Fund Transfers and Interfund Charges are made between different funds to pay for charges for services given or to fund the deficit position of particular fund s with a transfer from the General Fund. LID Assessments are revenues charged against particular benefited properties for improvements made by the City through a Local Improvement District (LID). State Taxes include Sales Tax and Liquor Tax Revenues that are distributed to the City by the State of Idaho. It is relevant to point out that Property Tax, however important it is to the f inancial well being of the City, is a relatively small part of the Total Revenue Budget. Road & Bridge Tax is property taxes levied by the County for their Road & Bridge Fund that are turned over by state law to the City. The amount of tax transferred is equal to half of the Road & Bridge Tax collected on properties within the City limits. The total revenues in 2017 increased by almost $7.7 million dollars compared to 2016. This was due in large part to construction upgrades in the water and sewer depar tments. Because of these construction projects, the transfers and contributed capital categories increased significantly as we transferred monies from the capital and operating reserves to the construction funds to cover the construction expenses. Federal grants received also increased by more than a million dollars in large part due to the DEQ loan grant forgiveness for the water project. We had a notable increase in building fees and impact fees in 2017 due to growth. 19 The Operating Expense Budget pie chart shows the relative size of the departments or categories of operating expense budgets. Operating Expense does not include capital expense funds and is the amount needed to fund the day to day operations of the City. Public Safety expense, which includes the Police, Fire, and Ambulance Departments, comprises about 32% of the operating expenses. The Utility Funds, which include the Wastewater, Sanitation, and Water Departments, are about 33% of the operating expenses of the budget, leaving about a 35% for the rest of the departments or categories. The operating expenses increased by approximately $1.25 million as compared to 2016, with the largest increases coming in the Emergency Services Department from due to the purchase of fire capital, wildland deployments, and an increase in personnel costs that was offset in large part by a contribution from BYU Idaho. The miscellaneous category almost doubled because this was the first full year of expenses for the two new departments of Building Main tenance and Human Resources. 20 The Operating Revenue Budget pie chart shows the relative size of the categories of operating revenue budgets. Operating Revenue does not include moneys meant for capital expense and is the amount provided to fund the day to day operations of the City. Utility Charges, which include the Wastewater, Sanitation, and Water user fees, are about 32% of the total. Property Tax, State Taxes, Franchise Fees and Interfund charges for services (Overhead Transfers) are general purpose revenues and can be used at the City Council’s discretion. Many of the other categories specified are each for a special purpose and must be spent according to state law or agreements signed. The operating revenues increased by approximately $ 608,196 as compared to 2016, with the largest increases occurring in the operating contributions, federal grants, and property tax categories. BASIC FINANCIAL STATEMENTS The Accompanying Notes are an Integral Part of the Financial Statements 22 Component Unit (Rexburg Governmental Business-type Urban Renewal Activities Activities Total Agency) ASSETS Current Assets: Cash and Short-term Investments 10,440,245$ 11,766,216$ 22,206,461$ 7,398,187$ Receivables 5,407,291 1,205,693 6,612,984 - Supplies 18,775 - 18,775 - Total Current Assets 15,866,311 12,971,909 28,838,220 7,398,187 Noncurrent Assets: Revolving Loan Receivable 899,897 - 899,897 - Capital Assets: Capital Assets 83,925,006 62,639,097 146,564,103 989,778 Accumulated Depreciation (32,239,095) (20,702,259) (52,941,354) - Net Capital Assets 51,685,911 41,936,838 93,622,749 989,778 Total Noncurrent Assets 52,585,808 41,936,838 94,522,646 989,778 TOTAL ASSETS 68,452,119 54,908,747 123,360,866 8,387,965 Deferred Outflows of Resources 747,458 121,084 868,542 - TOTAL ASSETS AND DEFERRED OUTFLOWS 69,199,577 55,029,831 124,229,408 8,387,965 LIABILITIES: Current Liabilities: Accounts Payable 3,095,230 746,267 3,841,497 1,221,935 Accrued Compensated Absences 386,874 55,967 442,841 - Accrued Interest Payable 5,568 47,820 53,388 - Deferred Revenue Other 12,000 101,283 113,283 - Current Portion of Long-term Obligations 95,000 655,000 750,000 407,750 Total Current Liabilities 3,594,672 1,606,337 5,201,009 1,629,685 Noncurrent Liabilities: Noncurrent Portion of Long-term Obligations 125,000 9,003,693 9,128,693 5,234,738 Net Pension Liability 3,051,678 570,273 3,621,951 - Total Noncurrent Liabilities 3,176,678 9,573,966 12,750,644 5,234,738 TOTAL LIABILITIES 6,771,350 11,180,303 17,951,653 6,864,423 DEFERRED INFLOWS OF RESOURCES Bond issue premium, net of amortization - 156,879 156,879 - Pension Deferred Inflows 467,899 81,914 549,813 - TOTAL DEFERRED INFLOWS OF RESOURCES 467,899 238,793 706,692 - TOTAL LIABILITIES AND DEFERRED INFLOWS OF RESOURCES 7,239,249 11,419,096 18,658,345 6,864,423 NET POSITION (DEFICIT): Invested In Capital Assets, Net of Related Debt 51,685,911 32,073,444 83,759,355 989,778 Restricted for: Capital projects 8,620,918 1,936,151 10,557,069 - Debt service 45,053 - 45,053 - Intergovernmental Agreement 1,118,589 - 1,118,589 - Operations 1,413,646 11,537,291 12,950,937 - Unrestricted (923,789) (1,936,151) (2,859,940) 533,764 TOTAL NET POSITION 61,960,328$ 43,610,735$ 105,571,063$ 1,523,542$ CITY OF REXBURG, IDAHO STATEMENT OF NET POSITION GOVERNMENT WIDE September 30, 2017 Primary Government The Accompanying Notes are an Integral Part of the Financial Statements 23 Charges Operating Capital for Services Grants and Grants and FUNCTIONS/PROGRAMS Expenses and Taxes Contributions Contributions Total PRIMARY GOVERNMENT: GOVERNMENTAL ACTIVITIES: General and Administrative 5,241,073$ 4,258,013$ 476,755$ 89,791$ (416,514)$ Public Safety 8,475,098 2,421,215 2,263,225 237,725 (3,552,933) Parks, Recreation and Arts 2,740,219 1,179,753 27,434 732,625 (800,407) Streets 4,242,039 3,631,238 - 2,587,259 1,976,458 Total Governmental Activities 20,698,429 11,490,219 2,767,414 3,647,400 (2,793,396) GENERAL REVENUES: Property Taxes Levied for General Purposes - 4,357,967 - - 4,357,967 Franchise Fees - 445,097 - - 445,097 State Taxes - 1,604,834 - - 1,604,834 Investment Earnings - 28,852 - - 28,852 Miscellaneous - 14,528 - - 14,528 Total General Revenue - 6,451,278 - - 6,451,278 Total Governmental Activities 3,657,882 NET GOVERNMENTAL ASSETS - BEGINNING BALANCE 58,302,446 NET GOVERNMENTAL ASSETS - ENDING BALANCE 61,960,328$ BUSINESS-TYPE ACTIVITIES Water 2,492,575$ 2,676,567$ -$ 1,010,105$ 1,194,097$ Waste Water 4,168,009 4,078,354 - 989,141 899,486 Sanitation 1,905,194 2,118,607 - - 213,413 Total Business-type Activities 8,565,778 8,873,528 - 1,999,246 2,306,996 GENERAL REVENUES: Investment Earnings - 101,707 - - 101,707 Total Business Type Activities 2,408,703 NET BUSINESS-TYPE ASSETS - BEGINNING BALANCE 41,202,032 NET BUSINESS-TYPE ASSETS - ENDING BALANCE 43,610,735$ TOTAL PRIMARY GOVERNMENT 29,264,207$ 26,916,732$ 2,767,414$ 5,646,646$ 6,066,585$ TOTAL PRIMARY GOVERNMENT NET ASSETS - BEGINNING BALANCE 99,504,478 TOTAL PRIMARY GOVERNMENT NET ASSETS - ENDING BALANCE 105,571,063$ COMPONENT UNIT (REXBURG URBAN RENEWAL AGENCY): General and Administrative 59,402$ -$ -$ -$ (59,402)$ Tax Reimbursement 119,397 - - - (119,397) Bond Costs 47,500 - - - (47,500) Construction 1,569,394 - - - (1,569,394) Interest & Amortization Expense 181,954 - - - (181,954) Total Component Units 1,977,647$ -$ -$ -$ (1,977,647)$ GENERAL REVENUES: Property taxes levied for general purposes - 2,079,725 Overhead Charges for Services 34,009 Investment Earnings 64,769 Total General Revenue 2,178,503 TOTAL COMPONENT UNIT ACTIVITIES 200,856 TOTAL COMPONENT UNIT - BEGINNING BALANCE 1,322,686 TOTAL COMPONENT UNIT - ENDING BALANCE 1,523,542$ CITY OF REXBURG, IDAHO STATEMENT OF ACTIVITIES GOVERNMENT WIDE September 30, 2017 Program Revenues The Accompanying Notes are an Integral Part of the Financial Statements 24 Emergency Other Total General Street Service Governmental Governmental ASSETS Fund Fund Fund Funds Funds Cash and Short Term Investments 2,813,467$ 2,357,061$ -$ 5,269,717$ 10,440,245$ Receivables 732,037 1,044,175 485,332 4,045,644 6,307,188 Inventory 18,770 - - - 18,770 Due from Other Funds 2,774,736 - - - 2,774,736 TOTAL ASSETS 6,339,010$ 3,401,236$ 485,332$ 9,315,361$ 19,540,939$ LIABILITIES AND FUND BALANCES LIABILITIES: Accounts Payable 1,787,553$ 180,794$ 80,162$ -$ 2,048,509$ Due to Other Funds - - 405,169 2,369,567 2,774,736 Other 5,000 6,200 - 800 12,000 TOTAL LIABILITIES 1,792,553 186,994 485,331 2,370,367 4,835,245 DEFERRED INFLOWS OF RESOURCES Unavailable revenues 57,224 - - 412,594 469,818 FUND BALANCES: Nonspendable 18,770 - - - 18,770 Restricted - 3,214,242 - 2,001,436 5,215,678 Committed 2,984,700 - - 3,484,243 6,468,943 Assigned - - - - - Unassigned 1,485,763 - - - 1,485,763 TOTAL FUND BALANCES 4,489,233 3,214,242 - 5,485,679 13,189,154 TOTAL LIABILITIES AND FUND BALANCES 6,339,010$ 3,401,236$ 485,331$ 8,268,640$ 18,494,217$ CITY OF REXBURG, IDAHO BALANCE SHEET GOVERNMENTAL FUNDS September 30, 2017 The Accompanying Notes are an Integral Part of the Financial Statements 25 Amounts reported for governmental activities in the statement of net assets are different because: TOTAL FUND BALANCE - GOVERNMENTAL FUNDS 13,189,154$ Capital assets used in governmental activities are not financial resources and, therefore, are not reported in the funds. Cost of Assets 83,925,006$ Accumulated Depreciation (32,239,095) Net Cost of Assets 51,685,911 Certain receivables are not financial resources and are reported as deferred revenues Property tax deferred revenue 84,480 Special Assessment deferred revenue 384,501 Deferred recreation revenues 759 Deferred capital project grants and contributions 84 Deferred rent income - Long-term liabilities, including bonds payable, are not due and payable in the current period and therefore are not reported in the funds Deferred Pension Outflows 747,458 Deferred Pension Inflows (467,899) Net Pension Liability (3,051,678) Long-term debt (220,000) Accrued compensated absences (386,874) Accrued interest payable (5,568) TOTAL NET POSITION - GOVERNMENTAL ACTIVITIES 61,960,328$ September 30, 2017 CITY OF REXBURG, IDAHO RECONCILIATION OF THE BALANCE SHEET OF GOVERNMENTAL FUNDS to the TO THE STATEMENT OF NET POSITION The Accompanying Notes are an Integral Part of the Financial Statements 26 Emergency Other Total General Street Service Governmental Governmental Fund Fund Fund Funds Funds REVENUES: Taxes 5,968,662$ 2,103,259$ -$ 1,896,912$ 9,968,833$ Grants and Contributions 786,794 551,964 1,618,721 1,415,602 4,373,081 Fees and Charges 4,145,123 1,300,133 76,427 4,443,682 9,965,365 Investment Earnings 24,691 - - 79,666 104,357 Miscellaneous 62,580 19,441 1,586 89,603 173,210 TOTAL REVENUES 10,987,850 3,974,797 1,696,734 7,925,465 24,584,846 EXPENDITURES: General and Administrative 3,706,300 - - 1,904,706 5,611,006 Public Safety 4,062,842 - 3,067,006 772,985 7,902,833 Parks and Recreation 685,174 - - 1,408,977 2,094,151 Streets - 1,627,600 - 77,464 1,705,064 Interest on Bonds and Other Debt - - - 24,707 24,707 Principal on Bonds and Other Debt - - - 95,000 95,000 Capital Improvements 279,959 651,434 - 3,829,917 4,761,310 TOTAL EXPENDITURES 8,734,275 2,279,034 3,067,006 8,113,756 22,194,071 EXCESS OF REVENUES OVER (UNDER) EXPENDITURES 2,253,575 1,695,763 (1,370,272) (188,291) 2,390,775 OTHER FINANCING SOURCES (USES): Operating Transfers In 28,927 475,671 1,370,272 2,496,038 4,370,908 Operating Transfers Out (1,859,015) (712,121) - (1,799,772) (4,370,908) TOTAL OTHER FINANCING SOURCES (USES)(1,830,088) (236,450) 1,370,272 696,266 - EXCESS OF REVENUES AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES 423,487 1,459,313 - 507,975 2,390,775 FUND BALANCE AT BEGINNING OF YEAR 4,065,746 1,754,929 - 4,977,704 10,798,379 FUND BALANCE AT END OF YEAR 4,489,233$ 3,214,242$ -$ 5,485,679$ 13,189,154$ CITY OF REXBURG, IDAHO STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES GOVERNMENTAL FUNDS September 30, 2017 The Accompanying Notes are an Integral Part of the Financial Statements 27 Amounts reported for governmental activities in the statement of activites are different because: NET CHANGES IN FUND BALANCES - TOTAL GOVERNMENTAL FUNDS 2,390,775$ Governmental funds report capital outlays as expenditures. However, in the statement of activities, assets with an initial, individual cost of more than $5,000 are capitalized and the cost is allocated over their estimated useful lives and reported as depreciation expense. This is the amount by which capital outlays are reduced by depreciation in the current period: Capital expenditures capitalized as fixed assets 4,761,310 Depreciation expense (3,524,798) Basis in Assets disposed of (105,488) Revenues in the Statement of Activities that do not provide current financial resources are not reported as revenues in the funds: Special assessments levied (50,923) Changes in Deferred Revenue not in Statement of Net Assets: Special assessment deferred revenue (175,697) Property tax deferrals (350) Recreation and Cultural Arts revenue deferral (55) Airport lot rent deferral (1,516) Compensated absences accrual adjustment (24,272) Net Pension (Expense) Revenue 291,903 Governmental funds report principal repayment on debt as an expenditure. However, in the statement of activities debt payments are not an expense: Proceeds from borrowing - Principal payments on long-term liabilities 95,000 Changes in accrued interest 1,993 CHANGE IN NET ASSETS OF GOVERNMENTAL ACTIVITIES 3,657,882$ September 30, 2017 CITY OF REXBURG, IDAHO RECONCILIATION OF THE STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES to the STATEMENT OF ACTIVITIES The Accompanying Notes are an Integral Part of the Financial Statements 28 Water Wastewater Sanitation Total ASSETS Current Assets: Cash and Short-term Investments 7,977,324$ 3,079,472$ 709,420$ 11,766,216$ Receivables 434,602 530,144 240,946 1,205,692 Total Current Assets 8,411,926 3,609,616 950,366 12,971,908 Noncurrent Assets: Capital Assets: Capital Assets 20,427,793 39,549,560 2,661,744 62,639,097 Accumulated Depreciation (6,060,858) (13,028,118) (1,613,281) (20,702,257) Total Noncurrent Assets 14,366,935 26,521,442 1,048,463 41,936,840 TOTAL ASSETS 22,778,861 30,131,058 1,998,829 54,908,748 Deferred Outflows of Resources 35,547 64,285 21,252 121,084 TOTAL ASSETS AND DEFERRED OUTFLOWS 22,814,408 30,195,343 2,020,081 55,029,832 LIABILITIES: Current Liabilities: Accounts Payable 489,636 184,165 72,466 746,267 Accrued Compensated Absences 18,098 30,221 7,649 55,968 Accrued Interest Payable 39,327 8,499 - 47,826 Due to Other Funds - - - - Other 100,747 - 533 101,280 Current Portion of Long-term Obligations - 655,000 - 655,000 Total Current Liabilities 647,808 877,885 80,648 1,606,341 Noncurrent Liabilities: Noncurrent Portion of Long-term Obligations 3,768,693 5,235,000 - 9,003,693 Net Pension Liability 172,134 301,513 96,626 570,273 TOTAL LIABILITIES 4,588,635 6,414,398 177,274 11,180,307 DEFERRED INFLOWS OF RESOURCES: Bond issue premium, net of amortization - 156,879 - 156,879 Deferred Inflows of Resources 24,725 43,310 13,879 81,914 TOTAL LIABILITIES AND DEFERRED INFLOWS OF RESOURCES 4,613,360 6,614,587 191,153 11,419,100 NET POSITION: Invested in Capital Assets Net of Related Debt 10,558,916 20,466,065 1,048,462 32,073,443 Restricted for: Capital Projects 1,650,752 285,399 - 1,936,151 Intergovernmental Agreement Operations 5,991,380 2,829,292 780,466 9,601,138 TOTAL NET POSITION 18,201,048$ 23,580,756$ 1,828,928$ 43,610,732$ Enterprise Funds CITY OF REXBURG, IDAHO PROPRIETARY FUNDS September 30, 2017 Business-type Activities STATEMENT OF NET POSITION The Accompanying Notes are an Integral Part of the Financial Statements 29 CITY OF REXBURG, IDAHO STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET POSITION PROPRIETARY FUNDS Water Wastewater Sanitation Totals OPERATING REVENUES: Monthly Utility Services 2,526,268$ 3,899,638$ 2,098,863$ 8,524,769$ One Time Fees 74,926 159,254 9,870 244,050 Miscellaneous 16,140 5,994 1,256 23,390 TOTAL OPERATING REVENUES 2,617,334 4,064,886 2,109,989 8,792,209 OPERATING EXPENSES: Utility Expenses 1,927,242 2,789,464 1,766,605 6,483,311 Depreciation and Amortization 526,887 1,168,952 138,588 1,834,427 TOTAL OPERATING EXPENSES 2,454,129 3,958,416 1,905,193 8,317,738 OPERATING INCOME 163,205 106,470 204,796 474,471 NON-OPERATING REVENUES / EXPENSES: Sale of Capacity and Contributions 1,061,515 989,141 - 2,050,656 Contributed Capital - - - - Sale of Assets - 789 2,136 2,925 Basis in Assets Sold (500) - - (500) Interest Income 69,889 46,540 12,259 128,688 Interest Expense (37,949) (209,591) - (247,540) TOTAL NON-OPERATING REVENUES / EXPENSES 1,092,955 826,879 14,395 1,934,229 CHANGE IN NET POSITION 1,256,160 933,349 219,191 2,408,700 TOTAL NET POSITION - BEGINNING BALANCE 16,944,888 22,647,407 1,609,737 41,202,032 TOTAL NET POSITION - ENDING BALANCE 18,201,048$ 23,580,756$ 1,828,928$ 43,610,732$ September 30, 2017 Business-type Activities Enterprise Funds The Accompanying Notes are an Integral Part of the Financial Statements 30 CITY OF REXBURG STATEMENT OF CASH FLOWS PROPRIETARY FUNDS Water Wastewater Sanitation Totals CASH FLOWS FROM OPERATING ACTIVITIES: Receipts from Customers 2,529,033$ 4,032,454$ 2,086,700$ 8,648,187$ Payments to Suppliers (607,824) (902,328) (897,299) (2,407,451) Payments to Employees (625,499) (860,922) (320,221) (1,806,642) Internal Activity - Payments to Other Funds for Services (680,623) (977,585) (587,014) (2,245,222) Other Payments - (9,528) (3,571) (13,099) NET CASH PROVIDED BY OPERATING ACTIVITIES 615,087 1,282,091 278,595 2,175,773 CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES: Borrowing 3,131,491 - - 3,131,491 Sale of Capacity and Contributions 1,061,522 989,141 2,050,663 Acquisitions of Property, Plant and Equipment (3,729,849) (4,344,231) (30,655) (8,104,735) (Increase) Decrease in Due From Other Funds 606,562 - - 606,562 (Increase) Decrease in Accounts Payable on Capital (78,138) (238,725) - (316,863) Increase (Decrease) in Accounts Receivable for Capital - (102,505) - (102,505) Proceeds from Sale of Assets - 789 2,136 2,925 Interest Income 69,889 46,540 12,259 128,688 Principal Payments on Revenue Bonds - (635,000) - (635,000) Interest Payments on Bonds and Leases - (228,749) - (228,749) NET CASH USED BY CAPITAL AND RELATED FINANCING ACTIVITIES 1,061,477 (4,512,740) (16,260) (3,467,523) NET INCREASE (DECREASE) IN CASH AND INVESTMENTS 1,676,564 (3,230,649) 262,335 (1,291,750) CASH AND INVESTMENTS AT BEGINNING OF YEAR 6,300,760 6,310,121 447,085 13,057,966 CASH AND INVESTMENTS AT END OF THE YEAR 7,977,324$ 3,079,472$ 709,420$ 11,766,216$ RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED (USED) BY OPERATING ACTIVITIES: Operating Income 163,205$ 106,470$ 204,796$ 474,471$ Adjustments to Reconcile Operating Income to Net Cash Provided by Operating Activities: Depreciation and Amortization 526,887 1,168,952 138,588 1,834,427 Net Pension Expense (Revenue) (49,888) 3,758 (40,411) (86,541) Changes in Assets and Liabilities: (Increase) decrease in accounts receivable (89,231) (32,120) (22,946) (144,297) Increase (decrease) in accounts payable 64,273 28,971 184 93,428 Increase (decrease) in accrued compensated absences (1,403) 6,060 (1,419) 3,238 Increase (decrease) in deposits payable 1,244 - (197) 1,047 NET CASH PROVIDED BY OPERATING ACTIVITIES 615,087$ 1,282,091$ 278,595$ 2,175,773$ Business-type Activities - Enterprise Funds September 30, 2017 31 CITY OF REXBURG, IDAHO NOTES TO FINANCIAL STATEMENTS September 30, 2017 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The City of Rexburg, Idaho (the City) was incorporated in 1883 under the provisions of the State of Idaho. The City operates under a Council-Mayor form of government and provides the following services as authorized by its charter: public safety (police and fire), streets, sanitation, culture-recreation, public improvements, planning and zoning, general administrative, utilities, and airport operations. The accompanying financial statements present the government and its component units, entities for which the government is considered to be financially accountable. The financial statements of the City of Rexburg, Idaho have been prepared in conformity with accounting principles generally accepted in the United States of America (GAAP) as applied to local government units. The Governmental Accounting Standards Board (GASB) is the accepted standard-setting body for establishing governmental accounting and financial reporting principles. The more significant accounting policies of the City are described below. Basic Financial Statements Basic financial statements are presented at both the government-wide and fund financial level. Both levels of statements categorize primary activities as either governmental or business-type. Governmental activities, which are normally supported by taxes and intergovernmental revenues, are reported separately from business-type activities, which rely to a significant extent on fees and charges for support. Government-Wide and Fund Financial Statements The government-wide financial statements (i.e., the statement of net position and the statement of changes in net position) report information on all of the non-fiduciary activities of the Primary Government and its component units. For the most part, the effect of interfund activity has been removed from these statements. Governmental activities, which normally are supported by taxes and intergovernmental revenues, are reported separately from business-type activities, which rely to a significant extent on fees and charges for support. The Statement of Activities demonstrates the degree to which the direct expenses of a given function or segment are offset by program revenues. Direct expenses are those that are clearly identifiable with a specific function. Program revenues include 1) charges to customers or applicants who purchase, use, or directly benefit from goods, services, or privileges provided by a given function or segment and 2) grants and contributions that are restricted to meeting the operational or capital requirements of a particular function or segment. Taxes and other items not properly included among program revenues are reported instead as general revenues. 32 Separate financial statements are provided for governmental funds and fiduciary funds, even though the latter are excluded from the government-wide financial statements. Major individual governmental funds are reported as separate columns in the fund financial statements. Measurement Focus, Basis of Accounting, and Financial Statement Presentation The government-wide financial statements are reported using the economic resources, measurement focus and the accrual basis of accounting, as are the proprietary fund financial statements. Revenues are recorded when earned and expenses are recorded when a liability is incurred, regardless of the timing of related cash flows. Property taxes are recognized as revenues in the year for which they are levied. Grants and similar items are recognized as revenue as soon as all eligibility requirements imposed by the provider have been met. Governmental fund financial statements are reported using the current financial resources measurement focus and the modified accrual basis of accounting. Revenues are recognized as soon as they are both 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 City considers revenues to be available if they are collected within 60 days of the end of the current fiscal period. Expenditures generally are recorded when a liability is incurred, as under accrual accounting. However, debt service expenditures, as well as expenditures related to compensated absences, early retirement, arbitrage rebates, and post employment healthcare benefits, are recorded only when payment is due. Property taxes, franchise taxes, licenses and interest associated with the current fiscal period are all considered to be susceptible to accrual and have been recognized as revenues of the current fiscal period. Only the portion of special assessments receivable due within the current fiscal period is considered to be accrued as revenue of the current period. All other revenue items are considered to be measurable and available only when the City receives cash. The City reports the following major governmental funds:  The General Fund is the City’s primary operating fund. It is used for all financial resources of the general government, except those required to be accounted for in another fund.  The Street Fund accounts for the resources accumulated and payments made for street and bridge maintenance, street lighting, traffic engineering, snow removal, street sweeping and storm sewer maintenance. Street Fund resources are restricted by law to be used only to benefit city streets.  The Emergency Services Fund accounts for the operations of the fire and ambulance service in and surrounding the City. 33 The City reports the following major enterprise funds:  The Utility Funds are the funds that account for the activities provided to the residents of the City for its utilities. These utilities include water, wastewater and sanitation. In 2015 these operating services were split to their own respective funds and in 2016 we began to report them in their respective funds on the financial statements. During 2017 the City began reporting the golf course fund as a governmental fund and it became a nonmajor fund in the governmental funds. Component Unit Component units are organizations which are legally separated from the City, which are financially accountable to the City, or their relationship with the City are such that exclusion would cause the City’s financial statements to be misleading or incomplete. Discretely presented component units are reported in a separate column to emphasize that they are legally separate from the primary government and are governed by separate boards. The City has one discretely presented component unit. A brief description of the discretely presented component unit follows: Rexburg Urban Renewal Agency – was organized to make improvements to infrastructure in specific areas of the City. It derives its revenues from the incremental tax increases that all taxing districts forfeit from increase in value of the land and buildings in the new construction areas. Private-sector standards of accounting and financial reporting issued prior to December 1, 1989, generally are followed in both government-wide and proprietary fund financial statements to the extent that those standards do not conflict with or contradict guidance of the Governmental Accounting Standards Board. Governments also have the option of following subsequent private-sector guidance for their business-type activities, subject to this same limitation. The City has elected not to follow subsequent private-sector guidance. When both restricted and unrestricted resources are available for use, it is the government’s policy to use restricted resources first, then unrestricted resources as they are needed. The City considers restricted amounts to have been spent first when an expenditure is incurred for purposes for which multiple classifications may be included in a fund balance. For example, restricted amounts are used first, followed by committed, assigned, and unassigned amounts in that order, for purposes of reporting fund balance. As a general rule the effect of interfund activity has been eliminated from the government-wide financial statements. Amounts reported as program revenues include 1) charges to customers or applicants for goods, services, or privileges provided, 2) operating grants and contributions, and 3) capital grants and contributions, including special assessments. 34 Internally dedicated resources are reported as general revenues rather than as program revenues. Likewise, general revenues include all taxes. Proprietary funds distinguish operating revenues and expenses from non-operating items. Operating revenues and expenses generally result from providing services and producing and delivering goods in connection with a proprietary fund’s principal on-going operations. The principle operating revenues of water, wastewater, and sanitation services enterprise funds are charges to customers and users for sales and services. Operating expenses for enterprise funds include the cost of sales and services, administrative expenses and depreciation on capital assets. All revenue and expenses not meeting this definition are reported as non-operating revenues and expenses. Property, Plant and Equipment Property, plant and equipment used in governmental fund type operations (those items which relate to the general activities and services of the City) are accounted for in the government-wide financial statements. The City defines capital assets as assets with an initial, individual cost of more than $5,000 (see Resolution 2012-02), with an estimated useful life in excess of two years. Property, plant and equipment used in proprietary fund type operations (i.e., the Utility and the Golf Course Funds) are accounted for within the proprietary funds and on the government-wide financial statements. Depreciation is provided on property, plant and equipment using the straight-line method over the estimated useful lives of the related assets: Server/Software…………………………………………………. 6 years Office Equipment ................................................................. 10 years Furniture .............................................................................. 20 years Vehicles ................................................................................. 7 years Light Equipment ................................................................... 10 years Heavy Equipment ................................................................ 20 years Buildings .............................................................................. 40 years Water and Wastewater Systems ................................... 20-100 years Deferred Outflows/Inflows of Resources In addition to assets, the statement of financial 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/expenditure) until then. The City has only one type of deferred outflows of resources. This amount relates to the City’s allocable share of the effect of changes during the year on the valuation of the net pension liability. This amount is reported only in the business-type funds and in the government-wide financial statements. 35 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 a future period(s) and so will not be recognized as an inflow of resources (revenue) until that time. The City has three types of items in this area. One item, which arises only under a modified accrual basis of accounting, unavailable revenue, is reported only in the governmental funds balance sheet and represents unavailable revenues from property taxes and grant revenues received in advance. These amounts are deferred and recognized as an inflow of resources in the period that the amounts become available. The government also has a deferred premium on refunding resulting from the difference in the carrying value of refunded debt and its reacquisition price. This amount is deferred and amortized over the life of the refunding. The third type of deferred inflows of resources relates to the effect of changes during the year in the calculation of the net pension liability. Pensions For purposes of measuring the net pension liability and pension expense (revenue), information about the fiduciary net position of the Public Employee Retirement System of Idaho Base Plan (Base Plan) and the Firefighters’ Retirement Fund Plan (FRF) and additions to/deductions from Base Plan’s and FRF’s fiduciary net position have been determined on the same basis as they are reported by the Base Plan and FRF. 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. Budgetary Policy The City prepares one combined budget which includes the operations of all funds. The combined statement of revenues and expenditures budget and actual--all budgetary funds presents comparisons of legally adopted budgets with actual data on a budgetary basis. Under Idaho Code, the City's budget establishes maximum legal authorization for expenditures during the fiscal year. Expenditures are not to exceed the budgeted amounts, except as allowed by the Code for certain events. During the fiscal year ended September 30, 2017 the City amended the budget for several of the funds. Encumbrances Encumbrance accounting, under which purchase orders, contracts, and other commitments for the expenditures of monies are recorded in order to reserve that portion of the applicable appropriation, is not employed by the City because it is not considered necessary to assure effective budgetary control or to facilitate effective cash planning and control. 36 Inventory Inventory is stated at the lower of cost or market. Inventory for all funds consists of expendable supplies held for consumption and is recorded when consumed (consumption method). Cash Equivalents For the purpose of the statement of cash flows for the proprietary funds, the City considers all highly liquid debt instruments purchased with a maturity of three months or less to be cash equivalents. Funds invested with the State Treasurer's Pool are classified as investments on the combined balance sheet and are considered to be cash equivalents. Use of Estimates The preparation of financial statements in conformity with generally accepted accounting principles requires management to make estimates and assumptions that affect the reported amounts of assets and liabilities and 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. Subsequent Events In preparing these financial statements, the management of the City has evaluated events and transactions for potential recognition and disclosure through March 2, 2018, the date the financial statements were available to be issued. 2. CASH AND SHORT-TERM INVESTMENTS The City is authorized under Idaho Code to invest in cash, certificates of deposit, U.S. Government securities, commercial paper and repurchase agreements. All investments must be held by or registered in the name of the City. Cash balances of most of the City’s funds are pooled and invested. Interest earned from investments purchased with pooled cash is allocated to each of the funds based on the fund's cash balance. The City maintains two primary checking accounts and other miscellaneous accounts with local banks where a minimum balance is maintained. All excess funds are then invested with the State Treasurer’s Local Government Investment Pool, the State’s Diversified Fund or accounts managed through contracts with private investment advisors (Managed Accounts). These accounts invest in time certificates of deposit, local government tax anticipation notes, federal loans, U.S. treasury notes and other U.S. governmental securities. Information regarding insurance or collateralization of amounts invested in the pooled accounts is not available. 37 The City has adopted the provisions of GASB Statement No. 40, Deposit and Investment Risk Disclosures. This statement establishes and modifies disclosure requirements related to investment and deposit risk; accordingly, the note disclosures on cash and investments are in conformity with the provisions of GASB Statement No. 40.  Deposits – At September 30, 2017, the carrying amount of the City’s bank deposits including Certificates of Deposits (CDs) was $2,941,717, of which $2,128,185 were insured with the FDIC and $703,101 was collateralized through Zions Bank.  Custodial Credit Risk, Deposits – Custodial credit risk is the risk that, in the event of a bank failure, the government’s deposits may not be returned. As of September 30, 2017, $110,431 of the City’s total deposits in Zions Bank was not covered by federal depository insurance, and thus was exposed to custodial credit risk.  Investments – As of September 30, 2017, the City had the following investments:  Custodial Credit Risk, Investments – For an investment, custodial credit risk is the risk that, in the event of the failure of the counterparty, the City will not be able to recover the value of the investments. The State diversifies these funds to reduce this risk.  Interest Rate Risk – As a means of limiting its exposure to fair value losses arising from changes in interest rates, the City structures its portfolio so that securities mature to meet cash requirements for ongoing operations. The Weighted Average Maturity (WAM) is stated above.  The CDARS program is through a local bank and invests the funds in less 38 than $250,000 increments in different banks to keep below the FDIC insurance amounts for coverage. The Collateralized Municipal MM Fund is also through a local bank that invests in money market accounts that the bank collateralizes with underlying investments.  The following is a reconciliation of the City’s deposit and investment balance as of September 30, 2017: Fair Value Measurements The City has implemented GASB No. 72, Fair Value Measurement and Application. This guidance requires government entities to measure investments and certain other items at fair value. The objective is to enhance comparability of financial statements among governments by requiring measurement of certain assets and liabilities at fair value using a consistent and more detailed definition of fair value and accepted valuation techniques. This guidance clarifies that fair value is an exit price, representing the amount that would be received to sell an asset or paid to transfer a liability in an orderly transaction between market participants. Under this guidance, fair value measurements are not adjusted for transaction costs. This guidance establishes a fair value hierarchy that prioritizes the inputs to valuation techniques used to measure fair value. The hierarchy gives the highest priority to unadjusted quoted prices in active markets for identical assets or liabilities (Level 1 measurements) and the lowest priority to unobservable inputs (Level 3 measurements). GASB No. 72 specifies a hierarchy of valuation techniques based upon whether the inputs to those valuation techniques reflect assumptions other market participants would use based upon market data obtained from independent sources (observable inputs). The following summarizes the fair value hierarchy: Level 1 Inputs – Unadjusted quoted market prices for identical assets and liabilities in an active market. Level 2 Inputs – Inputs other than the quoted process in active markets that are observable either directly or indirectly. Level 3 Inputs – Inputs based on prices or valuation techniques that are both unobservable and significant to the overall fair value measurements. GASB No. 72 requires the use of observable market data, when available, in making fair value measurements. When inputs used to measure fair value fall 39 within different levels of the hierarchy, the level within which the fair value measurement is categorized is based on the lowest level input that is significant to the fair value measurements. Valuation techniques used need to maximize the use of observable inputs. All assets have been valued using a market approach. There were no changes in the valuation techniques during the year. There are no assets or liabilities measured at fair value on a nonrecurring basis. State pooled funds are classified as Level 2 investments and are valued by the underlying assets in those funds which are valued at quoted market prices as the State of Idaho has determined. Land is categorized at a Level 3 which was determined by recent purchase price and appraisal. There were no changes in the valuation techniques during the year, except that the Managed Accounts were changed from book value to market value (Level 1). There are no assets or liabilities measured at fair value on a nonrecurring basis. 40 3. CAPITAL ASSETS Capital assets activity for the year ended September 30, 2017, was as follows: 30-Sep 30-Sep PRIMARY GOVERNMENT: 2016 Increases Decreases 2017 GOVERNMENTAL ACTIVITIES: Capital assets, not being depreciated: Land 2,775,915$ -$ -$ 2,775,915$ Total capital assets, not being depreciated 2,775,915 - - 2,775,915 Capital assets, being depreciated Office 2,601,232 4,500 (3,360) 2,602,372 Legal 5,437 - - 5,437 Archer Station 1,703,522 - - 1,703,522 Police 3,921,670 121,650 - 4,043,320 Fire 7,231,440 659,712 - 7,891,152 Engineering 385,311 - (31,025) 354,286 GIS 136,594 18,049 - 154,643 Community Development 306,845 28,889 (8,073) 327,661 Streets 41,615,887 2,780,071 (40,000) 44,355,958 Shop 950,210 201,479 - 1,151,689 Golf Courses 1,937,760 12,000 (13,648) 1,936,112 Parks 4,966,806 421,206 (19,580) 5,368,432 Merry-go-round 143,091 - - 143,091 Ball diamond 40,893 - - 40,893 Airport 2,774,783 320,404 - 3,095,187 Fiber 72,617 - - 72,617 Recreation 6,092,298 7,226 - 6,099,524 Romance Theatre 461,469 54,371 (4,643) 511,197 Legacy of Flight Museum 613,462 126,655 (85,000) 655,117 Tabernacle 631,784 5,097 - 636,881 Total capital assets, being depreciated 76,593,111 4,761,309 (205,329) 81,149,091 Less accumulated depreciation (28,814,139) (3,524,798) 88,341 (32,250,596) Total capital assets, being depreciated, net 47,778,972 1,236,511 (116,988) 48,898,495 GOVERNMENTAL ACTIVITIES CAPITAL ASSETS, NET 50,554,887$ 1,236,511$ (116,988)$ 51,674,410$ Depreciation expense was charged to the government activities as follows: 41 30-Sep 30-Sep PRIMARY GOVERNMENT: 2016 Increases Decreases 2017 BUSINESS-TYPE ACTIVITIES: Capital assets, not being depreciated: Land 117,880$ -$ -$ 117,880$ Total capital assets, not being depreciated 117,880 - - 117,880 Capital assets, being depreciated: Sanitation 2,631,089 30,655 - 2,661,744 Water 16,721,775 3,729,851 (23,833) 20,427,793 Wastewater 35,087,449 4,344,231 - 39,431,680 Total capital assets, being depreciated 54,440,313 8,104,737 (23,833) 62,521,217 Less accumulated depreciation: Sanitation (1,474,694) (138,589) (1,613,283) Water (5,557,302) (526,888) 23,333 (6,060,857) Wastewater (11,859,167) (1,168,952) (13,028,119) Total accumulated depreciation (18,891,163) (1,834,429) 23,333 (20,702,259) Total capital assets, being depreciated, net 35,549,150 6,270,308 (500) 41,818,958 BUSINESS-TYPE ACTIVITIES CAPITAL ASSETS, NET 35,667,030$ 6,270,308$ (500)$ 41,936,838$ The golf course fund has been transferred from proprietary type funds to governmental type funds during 2017. The assets and depreciation in the golf course fund have been moved from the business type assets to the governmental type assets 4. REVOLVING LOANS RECEIVABLE The City received a grant from the United States Department of Housing and Urban Development, the proceeds of which have been designated to be used as a revolving loan fund for small businesses within the community. Repayments on the initial loan have been used to finance other projects at the discretion of the City. The East Central Idaho Development Company (ECIDC) is currently administering these funds for the City. The balances of outstanding loans at September 30, 2017 are as follows: 42 Recipient Repayment Terms Amount Smith Family Properties Receivable in monthly installments including interest through 2019. 9,680$ Robertson Taylor, LLC Receivable in monthly installments including interest through 2028. 89,693 Patriot Company Receivable in monthly installments including interest through 2034. 215,224 Appible, LLC Receivable in monthly installments including interest through 2017. 35,757 Clear Water Hackle Receivable in monthly installments including interest through 2019. 20,744 Grand Peaks Medical Receivable in monthly installments including interest through 2019. 32,583 Coates Landscape Receivable in monthly installments including interest through 2037. 371,216 The Development Company Terms of repayment not finalized. This was matching funds to create the the USDA Rural Development IRP Revolving Loan Fund 125,000 899,897$ The Development Company is holding $221,593 in an interest bearing account for the City, which is available for future revolving loan projects. 5. PROPERTY TAXES Property taxes of the City are based on the assessments against property owners as of the first Monday in January of the calendar year in which the fiscal year commences. Tax levies on such assessed values are certified to the County prior to the commencement of the fiscal year. Taxes are collected by Madison County and remitted to the City primarily in January and July of the fiscal year. Accordingly, the tax revenues for the fiscal year ended September 30, 2017, are based on the assessed values and tax revenues established in 2016. The City defers recognition of property taxes assessed but not collected by fiscal year-end. Such amounts will be recognized as revenues in the fiscal year they become available. 43 6. ACCRUED COMPENSATED ABSENCES/ POST EMPLOYMENT HEALTH PLAN (PEHP) The City has elected to show its unused sick leave benefits as compensated absences. In 1990, the City established individual sick leave banks whereby an employee’s unused days over the 60 day maximum at the end of the calendar year were deposited in the sick leave bank, after the first 2 days were converted to vacation. From 2001 and thereafter, the employees no longer accumulate sick days at the end of the year in the sick bank, which will eventually phase out as those with remaining balances become eligible for full retirement. The current policy states that all additional, unused, accumulated sick leave above 480 hours for each employee (above 672 hours for ESD27 department employees), after the first 2 days were converted to vacation, will be converted to cash at a rate of 35% of the employee’s current hourly rate and deposited in the City’s designated Health Reimbursement Arrangement (HRA), and/or Voluntary Employee Benefit Association (VEBA) and/or Post Employment Health Plan (PEHP) in that employee’s name in the custody of a third party administrator so there is no outstanding unfunded liability. Upon retirement, the City will add to the employee’s PEHP/ VEBA/HRA account 35% of their unused Sick Leave of the first 480 hours (672 hours for ESD27 department employees) plus 35% of any Sick Leave Bank balance. The balance in the employee’s PEHP/VEBA/HRA account is subject to a 20 year eligibility proration. The percentage of their account that is made available to them at qualified retirement shall be calculated by adding five percent (5%) for each full year of employment of the individual employee up to a maximum of one hundred percent or twenty years (100% = 20 years times 5% each). Employees will be eligible for this benefit after 5 years of continuous City employment and upon eligible retirement as described below. To promote longevity, this benefit is available only to employees who obtain one of the following requirements: 1) They receive full monthly retirement benefits as defined and controlled by the State of Idaho Retirement System (PERSI) meeting the Rule of 80 or 90 as applicable, or a combination thereof depending on applicability and as determined by PERSI. 2) They meet the age requirements of a PERSI Service Retirement. 3) The employee is terminated without cause. The Sick Leave Bank is not a savings account, nor is it maintained with any specific funding. Therefore, no interest is earned, nor may any be claimed or drawn upon it. If the employee does not obtain one of the three requirements identified above, the unearned balance of their accounts will be remitted back to the City. 44 7. HEALTH REIMBURSEMENT ARRANGEMENT (HRA) The City will contribute a designated amount per deductible, into an HRA account administered by a third party provider of the City for each eligible employee annually in order to offset the employee’s share of costs related to a high deductible health insurance plan. The HRA designated contribution amount is available each year if the employee and their spouse (if applicable) have completed a wellness exam form in the prior calendar year. This amount is available to the employees at the start of each calendar year and can be carried forward for reimbursement in future years to offset qualified medical expenses. HRA balances may be used during employment or after termination of employment to pay, or be reimbursed for, eligible medical bills. The City contributes the amount of this liability every year to an account in the employee’s name in the custody of a third party administrator so that there is no outstanding unfunded liability. 8. LOCAL IMPROVEMENT ASSESSMENTS Assessments are made against property owners within the City for each owner's pro-rata share of the costs of Local Improvement District construction. Such assessments represent a lien against the related property and are generally payable in ten equal payments of principal and interest. Special assessments are recognized as revenue only to the extent that individual installments are currently due. The balance of such assessments is shown as deferred inflow. The collection of revenues for special assessments and the payment of special assessment bonds are accounted for in the LID Debt Service Fund. 9. LOCAL IMPROVEMENT DISTRICT WARRANTS PAYABLE Each year, as needed the City authorizes warrants to finance the improvements of certain streets along with constructing or reconstructing sidewalks, curbs, gutters, drainage facilities and other work incidental to improvements along streets and issues warrants to finance the construction. The balance of warrants outstanding at September 30, 2017, was as follows: 45 10. WASTEWATER REVENUE BONDS PAYABLE Wastewater Revenue Bonds outstanding at September 30, 2017, were as follows: The bond ordinance for the revenue bonds provides for the establishment of certain accounts and reserves and further provides that all revenues of the wastewater system are to be used initially for payment of operation and maintenance costs of the system, principal and interest on the bonds, and establishment of certain defined debt repayment reserves. The bonds sold at a premium of $294,149. The costs and the premium are being amortized over the life of the bond. 11. WATER DEQ LOAN PAYABLE Water DEQ Loan outstanding as of September 30, 2017: Description Interest Rate Fiscal Years Balance Water DEQ Loan Payable 1.75% 2016 to 2045 3,768,693$ This loan was obtained through the Idaho State Department of Environmental Quality (DEQ) and is funded 77.5281% by the Federal Environmental Protection Agency (EPA) and 22.4719% by DEQ. The total amount the City is able to draw is $11,100,000, of which approximately 20% will be forgiven as a grant, leaving a total loan payable, if fully utilized, of $8,888,750. The accrued interest is added to the loan upon each draw and the final amortization schedule of payments will be calculated when the full capacity of the loan is drawn. 46 12. OBLIGATIONS UNDER CAPITAL LEASES The City has no capital leases at this time. All leases where paid off in 2016. 13. CHANGES IN LONG-TERM OBLIGATIONS A summary of long-term transactions of the City for the year ended September 30, 2017, is as follows: Long-Term Long-Term Obligations Obligations September 30, Obligations Obligations September 30, Due Within 2016 Incurred Paid 2017 One Year Governmental activities: Local improvement district warrants payable (Note 9) 315,000$ -$ (95,000)$ 220,000$ 95,000$ Accrued compensated absences (Note 6) 362,601 24,273 - 386,874 386,874 PERSI Net Pension Liability (See Notes) 3,973,602 - (921,924) 3,051,678 - Governmental Activity Long-Term Liabilities 4,651,203$ 24,273$ (1,016,924)$ 3,658,552$ 481,874$ Business-type activities: Accrued compensated absences (Note 6) 52,729$ 3,238$ (5)$ 55,967$ 55,967$ PERSI Net Pension Liability 768,034 - (197,761) 570,273 - (See Notes) Water DEQ Loan 637,202 3,131,491$ -$ 3,768,693 - Wastewater revenue bonds payable (Note 10) 6,525,000 - (635,000) 5,890,000 655,000 Business-type Activity Long-Term Liabilities 7,982,965$ 3,134,729$ (832,766)$ 10,284,933$ 710,967$ Total Governmental and Business-type Activiites Long-Term Liabilities 12,634,168$ 3,159,002$ (1,849,690)$ 13,943,485$ 1,192,841$ 47 14. BONDED DEBT REPAYMENT REQUIREMENTS The annual requirements to amortize all bonded debt outstanding as of September 30, 2017, including interest, are as follows: Local Water Wastewater Year Ending Improvement DEQ Revenue September 30, Warrants Loan Bonds Total 2018 106,138$ 65,952$ 864,700$ 1,036,790$ 2019 38,825 118,526 865,050 1,022,401 2020 37,175 451,845 864,800 1,353,820 2021 35,525 451,845 867,213 1,354,583 2022 28,875 451,845 867,013 1,347,733 2023-2027 - 2,259,224 1,729,275 3,988,499 2028-2032 - 2,259,224 - 2,259,224 2033-2037 - 2,259,224 - 2,259,224 2038-2042 - 2,259,224 - 2,259,224 2043-2047 - 1,355,534 - 1,355,534 Total Commitment 246,538$ 11,932,444$ 6,058,051$ 18,237,032$ Interest Portion 26,538$ 3,043,694$ 168,051$ 3,238,283$ The local improvement warrant interest expenditures are recorded in the LID Debt Service Funds. 15. RETIREMENT PLANS Public Employee Retirement System of Idaho Plan Description The City contributes to the Base Plan and the Fireman’s Retirement Fund (FRF), which are cost-sharing multiple-employer defined benefit pension plans administered by Public Employee Retirement System of Idaho (PERSI or System) that covers substantially all employees of the State of Idaho, its agencies, and various participating political subdivisions. The cost to administer the plan is financed through the contributions and investment earnings of the plans. PERSI issues a publicly available financial report that includes financial statements and the required supplementary information for PERSI. That report may be obtained on the PERSI website at www.persi.idaho.gov. Responsibility for administration of the Base Plan and FRF is assigned to the Board comprised of five members appointed by the Governor and confirmed by the Idaho Senate. State law requires that two members of the Board be active Base Plan 48 members with at least ten years of service and three members who are Idaho citizens not members of the Base Plan except by reason of having served on the Board. Pension Benefits The Base Plan provides retirement, disability, death and survivor benefits of eligible members or beneficiaries. Benefits are based on members’ years of service, age, and highest average salary. Members become fully vested in their retirement benefits with five years of credited service (5 months for elected or appointed officials). Members are eligible for retirement benefits upon attainment of the ages specified for their employment classification. The annual service retirement allowance for each month of credited service is 2.0% (2.3% for police/firefighters) of the average monthly salary for the highest consecutive 42 months. The benefit payments for the Base Plan and FRF are calculated using a benefit formula adopted by the Idaho Legislature. The FRF cost of living increase is based on the increase in the statewide average firefighter’s wage. The Base Plan is required to provide a 1% minimum cost of living increase per year provided the Consumer Price Index increases 1% or more. The PERSI Board has the authority to provide higher cost of living increases to a maximum of the Consumer Price Index movement or 6%, whichever is less; however, any amount above the 1% minimum is subject to review by the Idaho Legislature. The FRF provides retirement, disability, death and survivor benefits of eligible members or beneficiaries. Benefits are based on members’ years of service as well as the final average salary. A firefighter must have 5 years of service to be eligible for a lifetime retirement allowance at age 60. Members are eligible for retirement benefits upon attainment of the ages specified for their employment classification. The annual service retirement allowance is based on Idaho Code Title 72 Chapter 14. The benefit payments for the FRF are calculated using a benefit formula adopted by the Idaho Legislature. The FRF cost of living increase is based on the increase in the statewide average firefighter’s wage. Member and Employer Contributions Member and employer contributions paid to the Base Plan and FRF are set by statute and are established as a percent of covered compensation. Contribution rates are determined by the PERSI Board within limitations, as defined by state law. The Board may make periodic changes to employer and employee contribution rates (expressed as percentages of annual covered payroll) that are adequate to accumulate sufficient assets to pay benefits when due. The contribution rates for employees covered under the Base Plan are set by statute at 60% of the employer rate for general employees and 72% for police and firefighters. As of June 30, 2017, the employee contribution rate was 6.79% for 49 general employees and 8.36% for police and firefighters. The employer contribution rate as a percent of covered payroll is set by the Retirement Board and was 11.32% for general employees and 11.66% for police and firefighters of covered compensation. The City’s contributions required and paid to the Base Plan were $882,266 for the year ended September 30, 2017. As of January 1, 2016, the total FRF employer rate was reduced to 16.66% which includes the lower employer excess class D rate of 5% plus the PERSI class 2 firefighters rate of 11.66%. The City’s contributions to FRF were $41,684 for the year ended September 30, 2017. Pension Liabilities, Pension Expense (Revenue), and Deferred Outflows of Resources and Deferred Inflows of Resources Related to Pensions At September 30, 2017, the City reported a liability for its proportionate share of the net pension liability of the PERSI Base Plan and an asset for its proportionate share of the net pension asset of FRF. The net pension asset of FRF and net pension liability of the Base Plan were measured as of July 1, 2017, and the total State of Idaho pension liability for the Plans used to calculate the net pension asset/liability were determined by an actuarial valuation as of that date. The City’s proportion of the net pension liability, expense, and deferrals is split into three parts: 1) Base Plan including non-FRF firemen .2405212% 2) Base Plan including FRF firemen .0081586% 3) FRF Excess Costs Plan. .3343618% The allocation of net pension liability, expense, and deferrals was based on the City’s share of contributions to each relative to the total contributions of all Plan employers as of July 1, 2017. For the year ended September 30, 2017, the City recognized pension expense (revenue) of: Base Plan: $(29,809) Base FRF Plan: $ 720 FRF Excess Plan: $(53,385) At September 30, 2017, the City reported deferred outflows of resources and deferred inflows of resources related to the Base Plan pension plan from the following sources: 50 $241,653 reported as deferred outflows of resources related to Base Plan pensions resulting from Employer contributions subsequent to the measurement date will be recognized as a reduction of the net pension liability in the year ending September 30, 2017. The average of the expected remaining service lives of all employees that are provided with pensions through the System (active and inactive employees) determined for the period ended June 30, 2017, is 4.9 years and for the period ending June 30, 2016 is 4.9 years. 51 At September 30, 2017, the City reported deferred outflows of resources and deferred inflows of resources related to the Base FRF pension plan from the following sources: Deferred Outflows Deferred Inflows of Resources of Resources Differences between expected and actual experience 17,765$ 11,553$ Changes in assumptions or other inputs 2,371 - Net difference between projected and actual earnings on pension plan investments - 7,683 Changes in the employer's proportion and differences between the employer's contributions and the employer's proportionate contributions - (18,853) Employer contributions subsequent to the measurement date 9,175 - Total 29,311$ 383$ $9,175 reported as deferred outflows of resources related to Base FRF pensions resulting from Employer contributions subsequent to the measurement date will be recognized as a reduction of the net pension liability in the year ending September 30, 2017. The average of the expected remaining service lives of all employees that are provided with pensions through the System (active and inactive employees) determined for the period ended June 30, 2017, is 4.9 years and for the period ending June 30, 2016 is 4.9 years. 52 At September 30, 2017, the City reported deferred outflows of resources and deferred inflows of resources related to the FRF Excess pension plan from the following sources: Deferred Outflows Deferred Inflows of Resources of Resources Differences between expected and actual experience -$ -$ Changes in assumptions or other inputs - - Net difference between projected and actual earnings on pension plan investments - 6,387 Changes in the employer's proportion and differences between the employer's contributions and the employer's proportionate contributions - - Employer contributions subsequent to the measurement date 3,935 - Total 3,935$ 6,387$ $3,935 reported as deferred outflows of resources related to FRF pensions resulting from Employer contributions subsequent to the measurement date will be recognized as a reduction of the net pension liability in the year ending September 30, 2017. The average of the expected remaining service lives of all employees that are provided with pensions through the System (active and inactive employees) determined for the period ended June 30, 2017, is 1 year and for the period ending June 30, 2016 is 1 year. Other amounts reported as deferred outflows of resources and deferred inflows of resources related to pensions will be recognized in pension expense (revenue) as follows: 53 Actuarial Assumptions Valuations are based on actuarial assumptions, the benefit formulas, and employee groups. Level percentages of payroll normal costs are determined using the Entry Age Normal Cost Method. Under the Entry Age Normal Cost Method, the actuarial present value of the projected benefits of each individual included in the actuarial valuation is allocated as a level percentage of each year’s earnings of the individual between entry age and assumed exit age. The Base Plan amortizes any unfunded actuarial accrued liability based on a level percentage of payroll. The maximum amortization period for the Base Plan permitted under Section 59-1322. Idaho Code, is 25 years. Unfunded actuarial accrued liability for FRF is the difference between the actuarial present value of the FRF benefits not provided by the Base Plan and the FRF assets. Currently FRF assets exceed this actuarial present value; therefore there is not an unfunded liability to amortize at this time. The maximum amortization period for FRF permitted under Section 59-1394. Idaho Code, is 50 years. The total pension liability in the July 1, 2017 actuarial valuation was determined using the following actuarial assumptions, applied to all periods included in the measurement: Mortality rates were based on the RP – 2000 combined table for healthy males or females as appropriate with the following offsets:  Set back 3 years for teachers  No offset for male fire and police  Forward one year for female fire and police  Set back one year for all general employees and all beneficiaries 54 For the Base Plan, an experience study was performed for the period July 1, 2007 through June 30, 2013 which reviewed all economic and demographic assumptions other than mortality. Mortality and all economic assumptions were studied in 2014 for the period from July 1, 2009 through June 30, 2013. The Total Pension Liability as of June 30, 2017 is based on the results of an actuarial valuation date July 1, 2017. For the FRF Plan, an experience study was performed for the period July 1, 2011 through June 30, 2015 which reviewed all economic and demographic assumptions other than mortality. Mortality and all economic assumptions were studied in 2014 for the period from July 1, 2009 through June 30, 2013. The Total Pension Asset as of June 30, 2017 is based on the results of an actuarial valuation date of July 1, 2017. The long-term expected rate of return on pension plan investments was determined using the building block approach and a forward-looking model 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 weighing the expected future real rates of return by the target asset allocation percentage and by adding expected inflation. Even though history provides a valuable perspective for setting the investment return assumption, the System relies primarily on an approach which builds upon the latest capital market assumptions. Specifically, the System uses consultants, investment managers and trustees to develop capital market assumptions in analyzing the System’s asset allocation. The assumptions and the System’s formal policy for asset allocation are shown below. The formal asset allocation policy is somewhat more conservative than the current allocation of System’s assets. The best-estimate range for the long-term expected rate of return is determined by adding expected inflation to expected long-term real returns and reflecting expected volatility and correlation. The capital market assumptions are as of January 1, 2017. 55 Capital Market Assumptions Actuarial Assumptions Assumed Inflation – Mean 3.25% Assumed Inflation – Standard Deviation 2.00% Portfolio Arithmetic Mean Return 8.42% Portfolio Long-Term Expected Geometric Rate of Return 7.50% Assumed Investment Expenses 0.40% Long-Term Expected Geometric Rate of Return Net of Expenses 7.10% Discount Rate The discount rate used to measure the total pension liability was 7.10%. The projection of cash flows used to determine the discount rate assumed that contributions from plan members will be made at the current contribution rate. Based on these assumptions, the pension plans’ 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. The long-term expected rate of return was determined net of pension plan investment expense but without reduction for pension plan administrative expense. 56 Sensitivity of the Employer’s proportionate share of the net pension liability to changes in the discount rate. The following presents the Employer’s proportionate share of the net pension liability calculated using the discount rate of 7.10 percent, as well as what the Employer’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.10 percent) or 1-percentage-point higher (8.10 percent) than the current rate: Current 1% Decrease Discount Rate 1% Increase (6.10%) (7.10%) (8.10%) Employer's proportionate share of the net pension liability (asset) 8,786,846$ 3,780,580$ (379,760)$ Current 1% Decrease Discount Rate 1% Increase (6.10%) (7.10%) (8.10%) Employer's proportionate share of the net pension liability (asset) 298,054$ 128,239$ (12,882)$ Current 1% Decrease Discount Rate 1% Increase (6.10%) (7.10%) (8.10%) Employer's proportionate share of the net pension liability (asset) (184,614)$ (286,868)$ (373,637)$ FRF Excess Plan Base Plan Base FRF Plan Pension plan fiduciary net position Detailed information about the pension plan’s fiduciary net position is available in the separately issued PERSI financial report. PERSI issues a publicly available financial report that includes financial statements and the required supplementary information for PERSI. That report may be obtained on the PERSI website at www.persi.idaho.gov. 57 Payables to the pension plan At September 30, 2017, the City reported payables to the Base Plan (including FRF Base Plan) of $36,655, and $1,181 for the FRF Plan for legally required employer contributions. The City also reported payables to the Base Plan (including FRF Base Plan) of $23,712, and $592 for the FRF Plan for legally required employee contributions, which had been withheld from employee wages, but not yet remitted to PERSI. 401(k) Plan The City has a single employer defined contribution 401(k) pension plan (the Plan), established by ordinance and in compliance with Internal Revenue Service Regulations. The Plan covers substantially all city employees who meet defined age and service requirements. The Plan is a salary reduction contribution plan with the employer matching 50% of the first four percent of the employee’s contribution. Employees are 100% vested immediately on their salary reduction amounts and become 100% vested after five years of service with the City on the employer’s contribution portion. The City’s total 2017 fiscal year payroll for all employees was $9,013,688 of which $6,170,957 was for covered payroll for employees who were members of the Plan. Employer and employee contributions to the Plan were 2.00% and 4.50% respectively, of covered payroll. Total contributions to the Plan for the fiscal year by the City and the employees were $123,419 and $277,989 respectively. The Plan had $5,951,342 in net assets at September 30, 2017. 16. OTHER REQUIRED INDIVIDUAL FUND DISCLOSURES The City expenditures exceeded the budgeted amounts in the following funds during the year ended September 30, 2017: 58 The following individual funds had fund deficits on September 30, 2017: Police Impact Fee Fund --There is a fund deficit of $37,230 that was created from the purchase of the old street shop to be used as a police storage facility building and training area. The City expects to eliminate this deficit as police impact fees are received. High 5 & Other Grants Fund-- There is a fund deficit of $9,611. The City expects to eliminate this deficit as grant revenues are received. Golf Course Operations Fund-- There is a fund deficit of $38,632. The City expects to eliminate this deficit as net income increases and transfers are received from other funds and contributions from Madison County. Golf Course Construction Fund-- There is a fund deficit of $578,114. The City expects to reduce/eliminate this deficit from transfers each year from the golf operations fund, the general fund, and contributions from Madison County. Although the loan is guaranteed 50% by the City, thru the Revolving Loan Fund, and 50% by Madison County, the actual loan is shown on the financials as due to the Water Operations Fund. LID Debt Service Fund-- There is a fund deficit of $119,448. The City expects to eliminate this deficit as assessments are collected on the LID projects. 17. COMPONENT UNIT – REXBURG URBAN RENEWAL AGENCY Reporting Entity In evaluating how to define the City, for financial reporting purposes, management has considered all potential component units. The decision to include a potential component unit in the reporting entity was made by applying the criteria set forth in Generally Accepted Accounting Principles. The basic, but not the only, criterion for including a potential component within the reporting entity is the governing body's ability to exercise oversight responsibility. The most significant manifestation of this ability is financial interdependency. Other manifestations of the ability to exercise oversight responsibility include, but are not limited to, the selection of governing authority, the designation of management, the ability to significantly influence operations and accountability for fiscal matters. Other criteria used to evaluate potential component units for inclusion or exclusion from the reporting entity include the existence of special financing relationships, regardless of whether the City is able to exercise oversight responsibilities. Based upon the application of these criteria, the following is a brief review of the component units addressed in defining the government's reporting entity. 59 Included with the reporting entity: Rexburg Urban Renewal Agency – This component unit was organized to make improvements to infrastructure. It derives its revenues from the incremental tax increases that all taxing districts forfeit from increase in value of the land and buildings in the new construction areas. Cash and Investments – The component unit had total cash and investment balances of $7,398,187, broken down as follows: Wells Fargo bank deposits of $286,548 (bank balance of $286,607), covered by FDIC insurance up to $250,000. DL Evans Bank Bond Reserve Fund deposit of $350,678, covered up to $250,000 by FDIC insurance, Citizens Community Bank CD Deposits of $33,283 all FDIC insured. Idaho State Local Government Investment Pool of $4,713,133 which is diversified to reduce risk and is mostly invested in US Government securities, Idaho State Diversified Bond Fund of $2,014,545 which is diversified to reduce risk and is mostly invested in US Government securities, for a total of $7,398,246. Long-term Debt – Revenue Allocation (Tax Increment) Bonds do not constitute indebtedness within the meaning of any constitutional or statutory debt limitation or restriction, and does not constitute a general obligation or debt of the City of Rexburg, Idaho, or any municipality, the State of Idaho, or any of its political subdivisions. In no event does this Bond give rise to a general obligation or liability of the Agency, any municipality, the State of Idaho, or any of its political subdivisions, or give rise to a charge against their general credit or taxing powers, or be payable out of any funds or properties other than those of the Agency specifically pledged therefore. Only tax increment property tax revenues, which are paid to the tax increment district for which the bonds were sold, are obligated to pay off the bond. 60 Revenue Bonds Outstanding at September 30, 2017 were as follows: September 30, 2017 Description Interest Rate Fiscal Years Balance North Highway Revenue Allocation Bonds Refunding Series 2016, Dated November 15, 2016 2.45% 2018 to 2022 2,142,488$ (original amount - $ 2,553,070) North Interchange Revenue Allocation Bonds 3.32% 2018-2036 3,500,000 Series 2016, Dated September 12, 2016 (original amount - $ 3,500,000) Total 5,642,488$ Scheduled Payments Principal Interest Total 2018 407,750$ 171,034$ 578,784$ 2019 417,878 160,906 578,784 2020 583,445 149,626 733,071 2021 599,769 133,302 733,071 2022 616,132 116,939 733,071 2023-2027 920,007 440,496 1,360,503 2028-2032 1,087,071 273,432 1,360,503 2033-2036 1,010,436 77,966 1,088,402 Total 5,642,488 1,523,701 7,166,189 61 18. INTERFUND TRANSACTIONS Transfers between funds during the year were as follows: Operating Operating Governmental: Transfers Out Transfers In General Fund 1,859,015$ 28,927$ Street Fund (02, 43, 44) 712,121 475,671 Recreation Fund - 56,106 Tabernacle Fund - 107,921 Rexburg Orchesta Fund - 7,600 Police DARE Fund - 8,500 Police Grant Fund 28,927 - Police Animal Control Fund - 108,735 Emergency Services Fund - 1,370,272 Joint Fire Equipment Fund - 210,000 Madison County Fire District Fund 609,259 - Fire Impact Fee Fund 70,000 - Rexburg Rapids Operations Fund - 65,000 Legacy Flight Museum Fund - 9,600 Community Development Fund 214,410 Downtown Revitalization Fund 189,921 New Shop Building Fund 97,338 Street Impact Fee Fund 475,671 Arts Promulgation Fund 27,287 - Parks Impact Fee Fund 233,896 Romance Theatre Fund - 129,257 Riverside Park Construction Fund - 233,896 Mayors Youth Advisory Board Fund - 3,500 Airport Operations Fund - 5,500 Airport Construction Fund - 12,937 Airport Relocation Reserve Fund 190,000 Golf Course Construction Fund 15,000 LID Construction Funds - 764,626 LID Debt Service Funds 172,869 17,154 Rexburg Cultural Arts Fund 812 36,165 EIBC Fund 7,000 New Streets 2nd East Fund - 5,872 Safety Lighting Fund 180,951 - Rexburg Foundation Fund 100 - 4,370,908$ 4,370,908$ 62 The General Fund transfers cash to cover specific expenses or deficits in the following funds: Legacy Flight Museum Fund for half the insurance cost Airport Construction Fund for half of the local share of repairs and upgrades Community Development Fund to cover the costs associated with Planning and Zoning Rexburg Cultural Arts Fund Eastern Idaho Business Competition (EIBC) Fund Mayors Youth Advisory Board Fund Golf Course Construction Fund loan payback Airport Operations Fund Romance Theatre Fund Downtown Revitalization Fund Police Dare Fund Recreation Programs Fund Tabernacle Fund Joint Fire Equipment for its assessment for new fire equipment Airport Relocation Reserve Fund for future expenditures to relocate the Airport. Police Animals Control Fund Rexburg Orchestra Fund Emergency Services Operations Fund for its share of costs Rexburg Rapids Fund to cover the future cost of replacing capital or adding features to the Aquatic facility. Arts Council Fund for a fixed contribution to its operations Street Fund transfers cash to cover street expenses in the LID funds or the new Street Shop Fund. Madison County Fire District Fund transfers cash to the Emergency Services Operations Fund to cover its allocation of costs for the year and to the Joint Fire Equipment Fund. Fire Impact Fee Fund transfers cash to cover the City’s share of new large equipment costs. The ESD Paramedic Care Unit Fund transfers to the Fire Station Construction Fund. The Street Impact Fee Fund transfers cash to the New Street Construction Fund to help cover the costs of new streets that added capacity to the city’s circulation system. The Arts Promulgation Fund transfers cash to cover a portion of the costs for the Arts Council staff. 63 The Parks Impact Fee Fund transfers cash to cover costs in Park Construction Funds The LID Debt Service Funds transfer cash to the LID Construction Funds to provide for local property owners share of the construction within the LIDs. The Rexburg Cultural Arts Funds transfer cash to cover its expenses for using the Tabernacle and/or Romance Theater. The Safety Lighting Fund transfers cash for installing street lighting in other construction fund projects. The Rexburg Foundation Fund transfers cash for eligible projects in other funds. The following is a schedule of interfund receivables and payables as of September 30, 2017: Due From Due To Primary Government: Other Funds Other Funds General Fund* 2,774,736$ -$ Emergency Services Fund - 405,169 Recreation Fund - 2,008 Police Impact Fee Fund - 37,230 Police Small Grants Fund - 7,767 High 5 & Other Grants Fund - 9,611 Geographic Information Systems Fund - 42,042 Downtown Revitalization Fund - 616,405 ESD Paramedic Care Unit Fund - 402,795 Riverside Park Construction Fund - 38,148 Airport Operation Fund - 2,682 Airport Construction Fund - 46,321 Golf Course Operations Fund - 35,171 Golf Course Construction Fund - 578,114 LID Debt Service Funds - 121,961 North 2nd East Construction Fund - 429,312 2,774,736$ 2,774,736$ *The above amounts were loaned from the General Fund to the various other funds to cover cash deficits. 64 19. LEASE WITH HOSPITAL In 2009 the City entered into a lease agreement, effective October 1, 2009, with Madison Memorial Hospital to lease a portion of the City building to the Hospital. The City renewed the lease for another five years in 2015 and payments are in monthly installments of $6,533 or $78,400 annually. Lease income from the Hospital was $78,396 for the year ended September 30, 2017. Future Lease income is expected to be $78,396 each year through FY 2019. 20. FUND BALANCES Beginning in Fiscal year 2011, in accordance with GASB 54, The City began to classify fund balances depending on the relative strength of the spending constraints placed on the purposes for which resources can be used as follows: Nonspendable fund balance- Amounts that cannot be spent because they are not in spendable form or they are legally or contractually required to be maintained intact. Restricted fund balance- Amounts constrained for a specific purpose by external creditors, grantors, laws, or regulations of other governments. Committed fund balance- Amounts that can be used only for the specific purposes determined by a formal action of the City Council. Assigned fund balance- Amounts intended to be used by the government for specific purposes. Intent can be expressed by the governing body or by an official or body to which the governing body delegates the authority. In the case of the City, this authority is not delegated, which is why there is no assigned fund balance. Unassigned fund balance- Amounts not contained in the other classifications. Unassigned amounts are technically available for any purpose. Positive unassigned amounts are only reported in the general fund. GASB 54 states that if another governmental fund has a fund balance deficit, then it will be reported as a negative amount in the unassigned classification in that fund. In the case of Rexburg, we have left negative fund balances in the fund balance category where they would have been classified if they had a positive fund balance to provide consistency from year to year on the governmental financial statements and because those deficits will be paid back with future revenues from those specific funds and not the revenues of other governmental funds. The City considers restricted amounts to have been spent first when an expenditure is incurred for purposes for which multiple classifications may be included in a fund balance. For example, restricted amounts are used first, followed by committed, assigned, and unassigned amounts in that order, for purposes of reporting fund balance. 65 Detail of constraints on fund balances of governmental funds:09/30/17 General Streets Emergency  Services Non‐Major  Funds  Total  Capital Projects  Fund Balances: Nonspendable: Inventory 18,770$             ‐$                      ‐$                    ‐$                        18,770$             Prepaid Expenses ‐                          ‐                        ‐                     ‐                          ‐                         Restricted for: Streets ‐                         3,214,242       ‐                     ‐                         3,214,242       3,214,242$              Emergency Services ‐                          ‐                        ‐                     ‐                          ‐                         Police Impact ‐                          ‐                        ‐                    (37,230)             (37,230)            (37,230)$                  DARE ‐                          ‐                        ‐                    4,615                 4,615                Police Drug Enforcement ‐                          ‐                        ‐                    18,986              18,986              Police Small Grants ‐                          ‐                        ‐                     ‐                          ‐                         High 5 & Other Grants ‐                          ‐                        ‐                    (9,611)               (9,611)              (9,611)$                    Joint Fire Equipment ‐                          ‐                        ‐                    367,770            367,770           367,770$                 Madison County Fire Prot. District ‐                          ‐                        ‐                    745,639            745,639            Fire Impact ‐                          ‐                        ‐                    55,845              55,845             55,845$                   ESD Rexburg Employees ‐                          ‐                        ‐                    27,590              27,590              Legacy Flight Museum ‐                          ‐                        ‐                    80,689              80,689              GIS ‐                          ‐                        ‐                     ‐                          ‐                         Downtown Revitalization ‐                          ‐                        ‐                    121,660            121,660           121,660$                 Shop Building Construction ‐                          ‐                        ‐                     ‐                          ‐                         ‐$                          Street Impact ‐                          ‐                        ‐                     ‐                          ‐                         ‐$                          ESD Paramedic Care ‐                          ‐                        ‐                    220,986            220,986            Parks Impact ‐                          ‐                        ‐                    1,032,869         1,032,869       1,032,869$              Riverside Park Construction ‐                          ‐                        ‐                     ‐                          ‐                         ‐$                          Airport Operations ‐                          ‐                        ‐                    436                    436                   Airport Construction ‐                          ‐                        ‐                    59,102              59,102             59,102$                   Golf Operations ‐                          ‐                        ‐                    (38,632)             (38,632)             Golf Construction ‐                          ‐                        ‐                    (578,114)           (578,114)         (578,114)$                LID Construction ‐                          ‐                        ‐                     ‐                          ‐                         ‐$                          LID Debt Service ‐                          ‐                        ‐                    (119,448)           (119,448)          2nd East Construction ‐                          ‐                        ‐                     ‐                          ‐                         ‐$                          Veterans Memorial ‐                          ‐                        ‐                    5,002                 5,002               5,002$                      Shop with a Cop ‐                          ‐                        ‐                    30,329              30,329              ESD Pipes and Drums ‐                          ‐                        ‐                    12,953              12,953              Arts Council Trust ‐                          ‐                        ‐                     ‐                          ‐                         City 501c3 Foundation ‐                          ‐                        ‐                     ‐                          ‐                         Committed to:‐                         Stabilization 2,984,700          ‐                        ‐                     ‐                         2,984,700        Recreation ‐                          ‐                        ‐                     ‐                          ‐                         Tabernacle ‐                          ‐                        ‐                    20,083              20,083             20,083$                   Orchestra ‐                          ‐                        ‐                    485                    485                   Police Animal Control ‐                          ‐                        ‐                    25,824              25,824              Revolving Loans ‐                          ‐                        ‐                    1,293,750         1,293,750        Aquatic Center Operations ‐                          ‐                        ‐                    258,058            258,058            Community Development ‐                          ‐                        ‐                    1,130,059         1,130,059        Arts Promulgation ‐                          ‐                        ‐                    187,508            187,508            Romance Theatre ‐                          ‐                        ‐                    20,083              20,083             20,083$                   Mayors Youth Advisory ‐                          ‐                        ‐                    5,443                 5,443                Airport Reserve ‐                          ‐                    532,830            532,830           532,830$                 Rexburg Cultural Arts ‐                          ‐                        ‐                     ‐                          ‐                         Eastern Idaho Business Comp.‐                          ‐                        ‐                    4,069                 4,069                Community Safety Lighting ‐                          ‐                        ‐                    6,051                 6,051               6,051$                      Assigned to: Unassigned:1,485,763          ‐                        ‐                     ‐                         1,485,763        Total Fund Balances 4,489,233$       3,214,242$      ‐$                   5,485,679$        13,189,154$   4,810,582$              Major Revenue Funds 66 General Streets Emergency  Services Non‐Major  Funds  Total  Capital Projects  Fund Balances: Nonspendable 18,770$             ‐$                      ‐$                    ‐$                        18,770$             ‐$                              Restricted ‐                        3,214,242       ‐                    2,001,436         5,215,678      4,231,535                 Committed 2,984,700          ‐                        ‐                    3,484,243         6,468,943      579,047                   Assigned ‐                         ‐                        ‐                     ‐                          ‐                         ‐                                 Unassigned 1,485,763          ‐                        ‐                     ‐                         1,485,763       ‐                                 Total Fund Balances 4,489,233$       3,214,242$      ‐$                   5,485,679$        13,189,154$   4,810,582$               Major Revenue Funds The City Council has established a minimum fund balance guideline for the general fund. As a general practice, the City will strive to maintain a total general fund committed fund balance equal to a minimum of 25% or greater of general fund budgeted expenditures for the last ended fiscal year. The City Council strives to maintain a minimum committed fund balance in the general fund to mitigate current and future risks (e.g., revenue shortfalls, unanticipated expenditures, and natural disasters or emergencies). Fund balance levels are affected by actual revenues and expenditures and will be used to achieve and maintain the City’s minimum fund balance goals and to meet the next year’s budget expenditure requirements. In the event there is excess fund balance in the general fund over the 25% minimum reserve, good management of public monies would suggest that the surplus be designated to future expenses to increase service levels that are currently deficient and maintain those that are sufficient. 21. FUND BALANCES CLASSIFICATIONS Beginning in Fiscal year 2011, in accordance with GASB 54, The City began to classify fund balances depending on the relative strength of the spending constraints placed on the purposes for which resources can be used. GASB 54 also requires that negative fund balances be classified as unassigned. The management of the City feels that this is misleading and inconsistent in the way the City handles its funds. See Note 19 for the funds that had negative fund balances. 22. GOLF COURSE FUND RECLASSIFICATION Beginning in Fiscal year 2017, the City determined that the golf course fund would be better classified as a governmental fund rather than an enterprise fund as it had been done in the past. The fund was moved out of the business type funds into the governmental type funds. All of its fixed assets were also transferred to the governmental fund fixed assets. The governmental type fund balance was increased by $717,751 and the business type fund balances was decreased by the same amount. REQUIRED SUPPLEMENTARY INFORMATION See Independent Auditors’ Report. 68 CITY OF REXBURG, IDAHO BUDGETARY COMPARISON SCHEDULE GENERAL FUND Year Ended September 30, 2017 Variance with Original Final Final Budget - Budget Budget Actual Amounts Positive Amount Amount Budgetary Basis (Negative) REVENUES: Taxes 5,822,400$ 5,822,400$ 5,968,662$ 146,262$ Grants & Contributions 662,400 680,400 786,794 106,394 Fees & Charges 4,132,300 4,132,300 4,145,123 12,823 Interest Earned 145,500 145,500 24,691 (120,809) Transfers in from Other Funds - - 28,927 28,927 Miscellaneous 54,100 237,400 62,580 (174,820) TOTAL REVENUES 10,816,700 11,018,000 11,016,777 (1,223) EXPENDITURES: General and Administrative Operations 3,659,200 3,963,000 3,706,300 256,700 Public Safety Operations 4,034,500 4,086,700 4,062,842 23,858 Parks and Recreation 729,700 749,000 685,174 63,826 Capital Improvements 304,800 326,000 279,959 46,041 Transfers 1,878,900 1,892,100 1,859,015 33,085 Contingency 209,600 1,200 - 1,200 TOTAL EXPENDITURES 10,816,700 11,018,000 10,593,290 424,710 EXCESS (DEFICIENCY) OF REVENUES AND OTHER SOURCES OVER EXPENDITURES AND OTHER USES - - 423,487 423,487 FUND BALANCE AT BEGINNING OF YEAR - - 4,065,746 4,065,746 FUND BALANCE AT END OF YEAR -$ -$ 4,489,233$ 4,489,233$ See Independent Auditors’ Report. 69 CITY OF REXBURG, IDAHO BUDGETARY COMPARISON SCHEDULE STREET FUND Year Ended September 30, 2017 Variance with Original Final Final Budget - Budget Budget Actual Amounts Positive Amount Amount Budgetary Basis (Negative) REVENUES: Taxes 2,029,400$ 2,029,400$ 2,103,259$ 73,859$ Grants & Contributions 1,285,000 1,960,000 551,964 (1,408,036) Fees & Charges 1,234,800 1,234,800 1,300,133 65,333 Interest Earned - - - - Miscellaneous 40,000 40,000 19,441 (20,559) Transfers In - Internal 1,111,900 1,106,100 1,511,495 405,395 Transfers in from Other Funds 350,000 350,000 475,671 125,671 Fund Balance Carryover 1,024,500 874,800 - (874,800) TOTAL REVENUES 7,075,600 7,595,100 5,961,963 (1,633,137) EXPENDITURES: Street Maintenance 1,720,800 1,736,600 1,627,600 109,000 Capital Improvements 1,961,500 2,361,500 651,434 1,710,066 Contingency 362,000 279,500 - 279,500 Transfers Out-Internal 1,111,900 1,106,100 1,511,495 (405,395) Transfers to Other Street Projects 1,919,400 2,111,400 712,121 1,399,279 TOTAL EXPENDITURES 7,075,600 7,595,100 4,502,650 3,092,450 EXCESS (DEFICIENCY) OF REVENUES AND OTHER SOURCES OVER EXPENDITURES AND OTHER USES - - 1,459,313 1,459,313 FUND BALANCE AT BEGINNING OF YEAR - - 1,754,929 1,754,929 FUND BALANCE AT END OF YEAR -$ -$ 3,214,242$ 3,214,242$ See Independent Auditors’ Report. 70 CITY OF REXBURG, IDAHO BUDGETARY COMPARISON SCHEDULE EMERGENCY SERVICES FUND Year Ended September 30, 2017 Variance with Original Final Final Budget - Budget Budget Actual Amounts Positive Amount Amount Budgetary Basis (Negative) REVENUES: Grants & Contributions 1,665,700$ 1,569,100$ 1,618,721$ 49,621$ Fees & Charges 24,000 24,000 76,427 52,427 Miscellaneous 3,900 3,900 1,586 (2,314) Transfers in from Other Funds 1,348,200 1,332,400 1,370,272 37,872 TOTAL REVENUES 3,041,800 2,929,400 3,067,006 137,606 EXPENDITURES: Public Safety Operations 3,007,000 2,894,600 3,067,006 (172,406) Capital Improvements 34,800 34,800 - 34,800 TOTAL EXPENDITURES 3,041,800 2,929,400 3,067,006 (137,606) EXCESS (DEFICIENCY) OF REVENUES AND OTHER SOURCES OVER EXPENDITURES AND OTHER USES - - - - FUND BALANCE AT BEGINNING OF YEAR - - - - FUND BALANCE AT END OF YEAR -$ -$ -$ -$ See Independent Auditors’ Report. 71 CITY OF REXBURG, IDAHO Schedule of Employer's Share of Net Pension Liability PERSI Base Plan Last 10 Fiscal Years* Net Pension Liability % Share Amount of Proportionate Share of Net Pension Liability Covered Employee Payroll Net Pension Liability % of Covered Payroll Plan Fiduciary Net Position as a % of Total Pension Liability 2017 0.2405212% 3,780,580$ 7,754,370$ 48.75% 90.68% 2016 0.2346076% 4,755,856$ 6,828,131$ 69.65% 87.26% 2015 0.2354998% 3,101,149$ 6,532,443$ 47.47% 91.38% * GASB Statement No. 68 requires ten years of information to be presented in this table. However, until a full 10-year trend is compiled, the City will present information for those years for which information is available. Date repored is measured as of June 30, 2017 (measurement date) Schedule of Employer Contributions PERSI Base Plan Last 10 Fiscal Years* Statutorily Required Contributions Contributions in Relation to Statutorily Required Contributions Contribution (Deficiency) Excess Employer's Covered Employee Payroll Contributions Percent of Covered Employee Payroll 2017 882,116$ 882,266$ 150$ 7,754,370$ 11.38% 2016 782,344$ 783,573$ 1,229$ 6,828,131$ 11.48% 2015 754,259$ 754,704$ 445$ 6,532,443$ 11.55% * GASB Statement No. 68 requires ten years of information to be presented in this table. However, until a full 10-year trend is compiled, the City will present information for those years for which information is available. Date repored is measured as of June 30, 2017 (measurement date) See Independent Auditors’ Report. 72 CITY OF REXBURG, IDAHO Schedule of Employer's Share of Net Pension Liability PERSI Base FRF Plan Last 10 Fiscal Years* Net Pension Liability % Share Amount of Proportionate Share of Net Pension Liability Covered Employee Payroll Net Pension Liability % of Covered Payroll Plan Fiduciary Net Position as a % of Total Pension Liability 2017 0.0081586% 129,239$ 250,204$ 51.65% 90.68% 2016 0.0069380% 140,644$ 203,554$ 69.09% 87.26% 2015 0.0074381% 97,948$ 202,664$ 48.33% 91.38% * GASB Statement No. 68 requires ten years of information to be presented in this table. However, until a full 10-year trend is compiled, the City will present information for those years for which information is available. Date repored is measured as of June 30, 2017 (measurement date) Schedule of Employer Contributions PERSI Base FRF Plan Last 10 Fiscal Years* Statutorily Required Contributions Contributions in Relation to Statutorily Required Contributions Contribution (Deficiency) Excess Employer's Covered Employee Payroll Contributions Percent of Covered Employee Payroll 2017 29,240$ 29,175$ (65)$ 250,204$ 11.66% 2016 24,062$ 23,734$ (328)$ 203,554$ 11.66% 2015 23,584$ 24,308$ 724$ 202,664$ 11.99% * GASB Statement No. 68 requires ten years of information to be presented in this table. However, until a full 10-year trend is compiled, the City will present information for those years for which information is available. Date repored is measured as of June 30, 2017 (measurement date) See Independent Auditors’ Report. 73 CITY OF REXBURG, IDAHO Schedule of Employer's Share of Net Pension Liability FRF Excess Plan Last 10 Fiscal Years* Net Pension Liability % Share Amount of Proportionate Share of Net Pension Liability Covered Employee Payroll Net Pension Liability % of Covered Payroll Plan Fiduciary Net Position as a % of Total Pension Liability 2017 0.3343618% (286,868)$ 250,204$ -114.65% 129.65% 2016 0.2881284% (154,864)$ 203,554$ -76.08% 118.42% 2015 0.3292887% (177,851)$ 202,664$ -87.76% 118.08% * GASB Statement No. 68 requires ten years of information to be presented in this table. However, until a full 10-year trend is compiled, the City will present information for those years for which information is available. Date repored is measured as of June 30, 2017 (measurement date) Schedule of Employer Contributions FRF Excess Plan Last 10 Fiscal Years* Statutorily Required Contributions Contributions in Relation to Statutorily Required Contributions Contribution (Deficiency) Excess Employer's Covered Employee Payroll Contributions Percent of Covered Employee Payroll 2017 12,445$ 12,510$ 65$ 250,204$ 5.00% 2016 10,318$ 10,178$ (140)$ 203,554$ 5.00% 2015 17,600$ 16,894$ (706)$ 202,664$ 8.34% * GASB Statement No. 68 requires ten years of information to be presented in this table. However, until a full 10-year trend is compiled, the City will present information for those years for which information is available. Date repored is measured as of June 30, 2017 (measurement date) OTHER SUPPLEMENTARY INFORMATION See Independent Auditor’s Report 75 Fund Number 03 04 05 07 08 09 13 Tabernacle Police & Rexburg Police Police Drug Small Recreation Museum Orchestra Impact Fee DARE Enforcement Grants ASSETS Fund Fund Fund Fund Fund Fund Fund Cash and Short Term Investments -$ 23,243$ 2,231$ -$ 4,615$ 18,986$ -$ Receivables 6,560 800 - - - - 7,767 TOTAL ASSETS 6,560$ 24,043$ 2,231$ -$ 4,615$ 18,986$ 7,767$ LIABILITIES AND FUND BALANCES LIABILITIES: Accounts Payable 3,791$ 3,735$ 1,746$ -$ -$ -$ -$ Due to Other Funds 2,008 - - 37,230 - - 7,767 Other - 150 - - - - - TOTAL LIABILITIES 5,799 3,885 1,746 37,230 - - 7,767 DEFERRED INFLOWS OF RESOURCES: Unavailable revenues 761 75 - - - - - FUND BALANCES (DEFICIT): Restricted - - - (37,230) 4,615 18,986 - Committed - 20,083 485 - - - - Unassigned - - - - - - - Total Fund Balances - 20,083 485 (37,230) 4,615 18,986 - TOTAL LIABILITIES AND FUND BALANCES 6,560$ 24,043$ 2,231$ -$ 4,615$ 18,986$ 7,767$ NONMAJOR GOVERNMENTAL FUNDS CITY OF REXBURG, IDAHO COMBINING BALANCE SHEET September 30, 2017 See Independent Auditor’s Report 76 14 15 18 19 20 21 22 23 24 28 29 Madison Police High 5 County Fire ESD Rexburg Legacy Geographic Animal & Other Joint Fire Protection Fire Impact Rexburg Revolving Rapids Flight Community Information Control Grants Equipment District Fee Employee Loan Operations Museum Development Systems Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund 26,510$ -$ 252,699$ 745,639$ 55,845$ 27,590$ 393,853$ 260,000$ 81,233$ 1,139,339$ -$ 3,515 - 125,759 27,256 - - 899,897 14,116 - - 44,252 30,025$ -$ 378,458$ 772,895$ 55,845$ 27,590$ 1,293,750$ 274,116$ 81,233$ 1,139,339$ 44,252$ 4,201$ -$ 10,688$ -$ -$ -$ -$ 16,058$ 544$ 8,980$ 2,210$ - 9,611 - - - - - - - - 42,042 - - - - - - - - - 300 - 4,201 9,611 10,688 - - - - 16,058 544 9,280 44,252 - - - 27,256 - - - - - - - - (9,611) 367,770 745,639 55,845 27,590 - - 80,689 - - 25,824 - - - - 1,293,750 258,058 - 1,130,059 - - - - - - - - - - - - 25,824 (9,611) 367,770 745,639 55,845 27,590 1,293,750 258,058 80,689 1,130,059 - 30,025$ -$ 378,458$ 772,895$ 55,845$ 27,590$ 1,293,750$ 274,116$ 81,233$ 1,139,339$ 44,252$ See Independent Auditor’s Report 77 Fund Number 30 31 33 36 37 38 40 ESD Downtown Street Shop Street Arts Paramedic Parks Impact Romance Revitalization Building Const Impact Fee Promulgation Care Unit Fee Theatre ASSETS Fund Fund Fund Fund Fund Fund Fund Cash and Short Term Investments -$ 4,886$ -$ 187,508$ -$ 1,032,791$ 24,321$ Receivables 987,200 - - - 634,746 - - TOTAL ASSETS 987,200$ 4,886$ -$ 187,508$ 634,746$ 1,032,791$ 24,321$ LIABILITIES AND FUND BALANCES LIABILITIES: Accounts Payable 249,135$ 4,886$ -$ -$ 10,965$ (78)$ 3,888$ Due to Other Funds 616,405 - - - 402,795 - - Other - - - - - - 350 TOTAL LIABILITIES 865,540 4,886 - - 413,760 (78) 4,238 DEFERRED INFLOWS OF RESOURCES: Unavailable revenues - - - - - - - FUND BALANCES (DEFICIT): Restricted 121,660 - - - 220,986 1,032,869 - Committed - - - 187,508 - - 20,083 Unassigned - - - - - - - Total Fund Balances 121,660 - - 187,508 220,986 1,032,869 20,083 TOTAL LIABILITIES AND FUND BALANCES 987,200$ 4,886$ -$ 187,508$ 634,746$ 1,032,791$ 24,321$ CITY OF REXBURG, IDAHO COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS September 30, 2017 See Independent Auditor’s Report 78 41 45 47 48 49 50 51 53-58 59-79 81 83 Mayor's Eastern Youth Golf Golf Rexburg Idaho Riverside Advisory Airport Airport Airport Course Course LID LID Debt Cultural Business Park Board Operation Construction Reserve Operations Construction Construction Service Arts Competition Fund Fund Fund Fund Fund Fund Fund Funds Funds Fund Fund -$ 6,113$ -$ -$ 532,830$ -$ -$ 365,679$ -$ 2,397$ 4,069$ 48,455 - 4,921 178,914 - 7,741 - - 419,387 - - 48,455$ 6,113$ 4,921$ 178,914$ 532,830$ 7,741$ -$ 365,679$ 419,387$ 2,397$ 4,069$ 10,307$ 670$ 1,803$ 73,491$ -$ 11,202$ -$ 365,679$ 32,372$ 2,397$ -$ 38,148 - 2,682 46,321 - 35,171 578,114 - 121,961 - - - - - - - - - - - - - 48,455 670 4,485 119,812 - 46,373 578,114 365,679 154,333 2,397 - - - - - - - - - 384,502 - - - - 436 59,102 - (38,632) (578,114) - (119,448) - - - 5,443 - - 532,830 - - - - - 4,069 - - - - - - - - - - - - 5,443 436 59,102 532,830 (38,632) (578,114) - (119,448) - 4,069 48,455$ 6,113$ 4,921$ 178,914$ 532,830$ 7,741$ -$ 365,679$ 419,387$ 2,397$ 4,069$ See Independent Auditor’s Report 79 Fund Number 84 85 90 91 93 94 95 North 2nd East Community Shop Arts City Total Construc- Safety Veterans with a ESD Pipes Council 501c3 Nonmajor tion Lighting Memorial Cop & Drums Trust Foundation Governmental ASSETS Fund Fund Fund Fund Fund Fund Fund Funds Cash and Short Term Investments -$ 28,928$ 5,002$ 30,377$ 13,033$ -$ -$ 5,269,717$ Receivables 612,134 22,224 - - - - - 4,045,644 TOTAL ASSETS 612,134$ 51,152$ 5,002$ 30,377$ 13,033$ -$ -$ 9,315,361$ LIABILITIES AND FUND BALANCES LIABILITIES: Accounts Payable 182,822$ 45,101$ -$ 48$ 80$ -$ -$ 1,046,721$ Due to Other Funds 429,312 - - - - - - 2,369,567 Other - - - - - - 800 TOTAL LIABILITIES 612,134 45,101 - 48 80 - - 3,417,088 DEFERRED INFLOWS OF RESOURCES: Unavailable revenues - - - - - - - 412,594 FUND BALANCES (DEFICIT): Restricted - - 5,002 30,329 12,953 - - 2,001,436 Committed - 6,051 - - - - - 3,484,243 Unassigned - - - - - - - - Total Fund Balances - 6,051 5,002 30,329 12,953 - - 5,485,679 TOTAL LIABILITIES AND FUND BALANCES 612,134$ 51,152$ 5,002$ 30,377$ 13,033$ -$ -$ 9,315,361$ CITY OF REXBURG, IDAHO COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS September 30, 2017 See Independent Auditor’s Report 80 03 04 05 07 08 09 13 Police Police Police Drug Small Recreation Tabernacle Orchestra Impact Fee DARE Enforcement Grants Fund Fund Fund Fund Fund Fund Fund REVENUES: Taxes -$ -$ -$ -$ -$ -$ -$ Grants and Contributions 25,506 8,589 628 - 11,500 - 44,027 Fees and Charges 154,879 14,161 - 82,622 - - - Interest Earned - 83 - - - - - Miscellaneous - 267 - - - 798 - TOTAL REVENUES 180,385 23,100 628 82,622 11,500 798 44,027 EXPENDITURES: General and Administrative - - - - - - - Public Safety - - - - 18,591 2,219 17,631 Parks and Recreation and Arts 236,491 105,841 9,372 - - - - Streets - - - - - - - Interest on Debt - - - 981 - - - Principal on Debt - - - - - - - Capital Improvements - 5,097 - - - - - TOTAL EXPENDITURES 236,491 110,938 9,372 981 18,591 2,219 17,631 EXCESS OF REVENUES OVER (UNDER) EXPENDITURES (56,106) (87,838) (8,744) 81,641 (7,091) (1,421) 26,396 OTHER FINANCING SOURCES (USES): Proceeds from Borrowing - - - - - - - Transfers In 56,106 107,921 7,600 - 8,500 - - Transfers Out - - - - - - (28,927) TOTAL OTHER FINANCING SOURCES (USES)56,106 107,921 7,600 - 8,500 - (28,927) EXCESS (DEFICIENCY) OF REVENUES AND OTHER SOURCES OVER EXPENDITURES AND OTHER USES - 20,083 (1,144) 81,641 1,409 (1,421) (2,531) FUND BALANCES (DEFICITS) AT BEGINNING OF YEAR - - 1,629 (118,871) 3,206 20,407 2,531 FUND BALANCES (DEFICITS) AT END OF YEAR -$ 20,083$ 485$ (37,230)$ 4,615$ 18,986$ -$ CITY OF REXBURG, IDAHO COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND NONMAJOR GOVERNMENTAL FUNDS BALANCES For the Year Ended September 30, 2017 See Independent Auditor’s Report 81 14 15 18 19 20 21 22 23 24 28 29 Madison Police High 5 County Fire ESD Rexburg Legacy Geographic Animal & Other Joint Fire Protection Fire Impact Rexburg Revolving Rapids Flight Community Information Control Grants Equipment District Fee Employee Loan Operations Museum Development Systems Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund -$ -$ -$ 771,253$ -$ -$ -$ -$ -$ -$ -$ 32,441 - - - - - - - 51,414 - 406,505 14,766 - 147,682 - 70,443 6,954 - 418,685 36,106 901,265 48 - - 2,948 870 482 194 25,176 1,740 97 - - - - - 5,660 - - - - 80,144 - - 47,207 - 150,630 777,783 70,925 7,148 25,176 420,425 167,761 901,265 406,553 - - - - - - 6,426 - - 962,402 388,504 131,334 9,611 - 74 9,907 - - - - - - - - - - - - 472,153 58,271 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 556,171 103,542 - - - 7,226 126,657 28,889 18,049 131,334 9,611 556,171 103,616 - 9,907 6,426 479,379 184,928 991,291 406,553 (84,127) (9,611) (405,541) 674,167 70,925 (2,759) 18,750 (58,954) (17,167) (90,026) - - - - - - - - - - - - 108,735 - 210,000 - - - - 65,000 9,600 214,410 - - - - (609,259) (70,000) - - - - - - 108,735 - 210,000 (609,259) (70,000) - - 65,000 9,600 214,410 - 24,608 (9,611) (195,541) 64,908 925 (2,759) 18,750 6,046 (7,567) 124,384 - 1,216 - 563,311 680,731 54,920 30,349 1,275,000 252,012 88,256 1,005,675 - 25,824$ (9,611)$ 367,770$ 745,639$ 55,845$ 27,590$ 1,293,750$ 258,058$ 80,689$ 1,130,059$ -$ See Independent Auditor’s Report 82 30 31 33 36 37 38 39 Street Shop ESD Parks Trails of Downtown Building Street Arts Paramedic Impact Madison Revitalization Constr Impact Fee Promulgation Care Unit Fee County Fund Fund Fund Fund Fund Fund Fund REVENUES: Taxes 1,125,659$ -$ -$ -$ -$ -$ -$ Grants and Contributions - - - - - - - Fees and Charges - - 475,671 101,130 726,034 425,636 - Interest Earned - - - 379 - 7,626 - Miscellaneous - - - - - - TOTAL REVENUES 1,125,659 - 475,671 101,509 726,034 433,262 - EXPENDITURES: General and Administrative 138,460 - - - - - - Public Safety - - - - 582,444 - - Parks and Recreation and Arts - - - - - - - Streets - - - - - - - Interest on Debt - - - - 1,581 - - Principal on Debt - - - - - - - Capital Improvements 1,055,460 161,969 - - - 24,554 - TOTAL EXPENDITURES 1,193,920 161,969 - - 584,025 24,554 - EXCESS OF REVENUES OVER (UNDER) EXPENDITURES (68,261) (161,969) 475,671 101,509 142,009 408,708 - OTHER FINANCING SOURCES (USES): Proceeds from Borrowing - - - - - - - Transfers In 189,921 97,338 - - - - - Transfers Out - (475,671) (27,287) - (233,896) - TOTAL OTHER FINANCING SOURCES (USES)189,921 97,338 (475,671) (27,287) - (233,896) - EXCESS (DEFICIENCY) OF REVENUES AND OTHER SOURCES OVER EXPENDITURES AND OTHER USES 121,660 (64,631) - 74,222 142,009 174,812 - FUND BALANCES (DEFICITS) AT BEGINNING OF YEAR - 64,631 - 113,286 78,977 858,057 - FUND BALANCES (DEFICITS) AT END OF YEAR 121,660$ -$ -$ 187,508$ 220,986$ 1,032,869$ -$ CITY OF REXBURG, IDAHO COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES NONMAJOR GOVERNMENTAL FUNDS For the Year Ended September 30, 2017 See Independent Auditor’s Report 83 40 41 45 47 48 49 50 51 53-58 59-79 81 Mayor's Youth Golf Golf Rexburg Romance Riverside Advisory Airport Airport Airport Course Course LID LID Debt Cultural Theatre Park Board Operation Construction Reserve Operations Construction Construction Service Arts Fund Fund Fund Fund Fund Fund Fund Fund Funds Funds Fund -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 78 48,456 - 7,666 303,429 - - 15,000 199,228 - - 10,090 - 364 27,662 - - 369,464 - - 220,847 29,656 83 - - 4 - 2,830 - - 36,964 - - - - - - 2,734 - - - - 10,251 48,456 364 35,332 303,429 2,830 372,198 15,000 199,228 257,811 29,656 - - 1,386 31,732 - - - - 354,944 - - - - - - - - - - - - - 74,024 - - - - - 387,816 - - - 65,009 - - - - - - - - - - - - - - 7 - 674 5,514 - 15,950 - - - - - - - - - 95,000 - 45,401 282,352 - - 320,404 - 12,000 - 605,542 - - 119,425 282,352 1,386 31,732 320,411 - 400,490 5,514 960,486 110,950 65,009 (109,174) (233,896) (1,022) 3,600 (16,982) 2,830 (28,292) 9,486 (761,258) 146,861 (35,353) - - - - - - - - - - - 129,257 233,896 3,500 5,500 12,937 190,000 - 15,000 764,626 17,154 36,165 - - - - - (172,869) (812) 129,257 233,896 3,500 5,500 12,937 190,000 - 15,000 764,626 (155,715) 35,353 20,083 - 2,478 9,100 (4,045) 192,830 (28,292) 24,486 3,368 (8,854) - - - 2,965 (8,664) 63,147 340,000 (10,340) (602,600) (3,368) (110,594) - 20,083$ -$ 5,443$ 436$ 59,102$ 532,830$ (38,632)$ (578,114)$ -$ (119,448) -$ See Independent Auditor’s Report 84 83 84 85 90 91 93 94 95 Eastern North Idaho 2nd East Community Shop Arts City Total Business Construc- Safety Veterans with a ESD Pipes Council 501c3 Nonmajor Competition tion Lighting Memorial Cop & Drums Trust Foundation Governmental Fund Fund Fund Fund Fund Fund Fund Fund Funds REVENUES: Taxes -$ -$ -$ -$ -$ -$ -$ -$ 1,896,912$ Grants and Contributions 8,000 234,735 - 50 10,601 7,649 - 100 1,415,602 Fees and Charges 130 - 208,407 - - 980 - - 4,443,682 Interest Earned - - - 35 131 24 - - 79,666 Miscellaneous - - - - - - - - 89,603 TOTAL REVENUES 8,130 234,735 208,407 85 10,732 8,653 - 100 7,925,465 EXPENDITURES: General and Administrative 13,213 - - 79 5,198 - 2,362 - 1,904,706 Public Safety - - - - - 1,174 - - 772,985 Parks and Recreation and Arts - - - - - - - - 1,408,977 Streets - - 77,464 - - - - - 77,464 Interest on Debt - - - - - - - - 24,707 Principal on Debt - - - - - - - - 95,000 Capital Improvements - 240,607 235,997 - - - - - 3,829,917 TOTAL EXPENDITURES 13,213 240,607 313,461 79 5,198 1,174 2,362 - 8,113,756 EXCESS OF REVENUES OVER (UNDER) EXPENDITURES (5,083) (5,872) (105,054) 6 5,534 7,479 (2,362) 100 (188,291) OTHER FINANCING SOURCES (USES): Proceeds from Borrowing - - - - - - - - - Transfers In 7,000 5,872 - - - - - - 2,496,038 Transfers Out - - (180,951) - - - - (100) (1,799,772) TOTAL OTHER FINANCING SOURCES (USES)7,000 5,872 (180,951) - - - - (100) 696,266 EXCESS (DEFICIENCY) OF REVENUES AND OTHER SOURCES OVER EXPENDITURES AND OTHER USES 1,917 - (286,005) 6 5,534 7,479 (2,362) - 507,975 FUND BALANCES (DEFICITS) AT BEGINNING OF YEAR 2,152 - 292,056 4,996 24,795 5,474 2,362 - 4,977,704 FUND BALANCES (DEFICITS) AT END OF YEAR 4,069$ -$ 6,051$ 5,002$ 30,329$ 12,953$ -$ -$ 5,485,679$ CITY OF REXBURG, IDAHO COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES NONMAJOR GOVERNMENTAL FUNDS For the Year Ended September 30, 2017 85 Federal CFDA Federal Number Expenditures Department of Justice Pass Through the State of Idaho: Bulletproof Vest Partnership Program 16.607 3,809$ Federal Aviation Administration: Airport Improvement Program 20.106 278,221 Department of Transportation: Pass Through the State of Idaho: State and Community Highway Safety Cluster: State and Community Highway Safety 20.600 13,211 Alcohol Traffic Safety and Drunk Driving Prevention 20.616 23,351 Total Cluster 36,562 Minimum Penalties for Repeat Offenders for Driving While Intoxicated 20.608 13,602 Total Deparatment of Transportation 50,164 Department of Homeland Security: Homeland Security Grant Program 97.067 5,381 Envorionmental Protection Agency: * Pass Through the State of Idaho: Capitalization Grants for Drinking and Water State Revolving Funds 66.458 3,910,512 Department of Health and Human Services: Pass Through the State of Idaho: Hospital Preparedness Program (HPP) and Public Health Emergency Prepardness (PHEP) Aligned Cooperative Agreements 93.074 3,569 TOTAL FEDERAL ASSISTANCE 4,251,656$ * Major Program CITY OF REXBURG, IDAHO SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS September 30, 2017 See Independent Auditors’ Report. 86 CITY OF REXBURG, IDAHO NOTES TO THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS For the Year Ended September 30, 2017 1. Basis of Presentation The accompanying schedule of expenditures of federal awards includes the federal grant activity of the City of Rexburg, Idaho and is presented in accordance with the requirements of the Uniform Guidance. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of the general-purpose financial statements. 2. Summary of Significant Accounting Policies Expenditures reported on the Schedule of Expenditures of Federal Awards are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain expenditures are not allowed or are limited as to reimbursement. The City does not use the 10% de minimis indirect cost rate. See Independent Auditors’ Report. 87 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 Honorable Mayor and City Council City of Rexburg, Idaho 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, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information of City of Rexburg, Idaho, as of and for the year ended September 30, 2017, and the related notes to the financial statements, which collectively comprise City of Rexburg, Idaho’s basic financial statements, and have issued our report thereon dated March 2, 2018. Internal Control Over Financial Reporting In planning and performing our audit of the financial statements, we considered City of Rexburg, Idaho’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 City of Rexburg, Idaho’s internal control. Accordingly, we do not express an opinion on the effectiveness of City of Rexburg, Idaho’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. 88 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. Compliance and Other Matters As part of obtaining reasonable assurance about whether City of Rexburg, Idaho’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. Rexburg, Idaho March 2, 2018 89 INDEPENDENT AUDITORS’ REPORT ON COMPLIANCE FOR EACH MAJOR PROGRAM AND ON INTERNAL CONTROL OVER COMPLIANCE REQUIRED BY THE UNIFORM GUIDANCE To the Honorable Mayor and City Council City of Rexburg, Idaho Report on Compliance for Each Major Federal Program We have audited City of Rexburg, Idaho’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 City of Rexburg, Idaho’s major federal programs for the year ended September 30, 2017. City of Rexburg, Idaho’s major federal programs are identified in the summary of auditors’ results section of the accompanying schedule of findings and questioned costs. Management’s Responsibility Management is responsible for compliance with the requirements of laws, regulations, contracts, and grants applicable to its federal programs. Auditor’s Responsibility Our responsibility is to express an opinion on compliance for each of City of Rexburg, Idaho’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 City of Rexburg, Idaho’s compliance with those requirements and performing such other procedures as we considered necessary in the circumstances. 90 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 City of Rexburg, Idaho’s compliance. Opinion on Each Major Federal Program In our opinion, City of Rexburg, Idaho, 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 September 30, 2017. Report on Internal Control Over Compliance Management of City of Rexburg, Idaho, 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 City of Rexburg, Idaho’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 City of Rexburg, Idaho’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. 91 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. Rexburg, Idaho March 2, 2018 92 CITY OF REXBURG, IDAHO SCHEDULE OF FINDINGS AND QUESTIONED COSTS FOR THE YEAR ENDED SEPTEMBER 30, 2017 Section I - Summary of Auditors’ Results (i) Financial Statements Type of auditors’ report issued: Qualified Internal control over financial reporting: Material weaknesses identified? No Reportable conditions identified that are not considered to be material weaknesses? No Noncompliance material to financial statements noted? No (ii) Federal Awards Internal control over major programs: Material weaknesses identified? No Reportable conditions identified that are not considered to be material weaknesses? No Type of auditors’ report issued on compliance for major programs: Unmodified Any audit findings disclosed that are required to be reported in accordance with 2 CFR Section 200.516(a)? No See Independent Auditors’ Report. Identification of major programs: CFDA Number(s) Name of Federal Program 66.458 Capitalization Grants for Drinking Water State Revolving Funds Dollar threshold used to distinguish between Type A and Type B programs: $750,000 Auditee qualified as low-risk auditee? No Section II – Financial Statement Finding None Section III – Federal Award Findings and Questioned Costs None See Independent Auditors’ Report. 93 CITY OF REXBURG, IDAHO SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS FOR THE YEAR ENDED SEPTEMBER 30, 2017 Section II – Financial Statement Finding None Section III – Federal Award Findings and Questioned Costs None See Independent Auditors’ Report. 94