Finance Advisory Committee

AMENDED AGENDA Finance Advisory Committee Meeting Thursday, September, 21, 2017 5:00 p.m. City Hall Council Chambers (Second Floor) 1. Call to Order 2. Roll Call for Attendance 3. Public Participation 4. Approval of Minutes a. Minutes of the Finance Advisory Committee Meeting of August 15, 2017 5. Police Pension and Fire Pension Actuarial Reports and Investment Return Study – Foster & Foster Actuaries and Consultants 6. Five Year Financial Plan 7. Water Sales Transfer to Water Capital Fund 8. FY2018 Budget Schedule 9. Other Items 10. Confirm Next Meeting Date and Time 11. Adjournment The Finance Advisory Committee’s role (as listed in Chapter 54-11) is to provide well-reasoned, financially sound recommendations to the Council. Meetings and reporting shall be on a project-by-project basis or as otherwise assigned by the City Council. The Finance Advisory Committee shall work in cooperation with the City Council and the City Manager to analyze the City’s financial policies, long term financial stability, options for greater efficiencies and possible revenue and expenditure modifications.  MINUTES FINANCE ADVISORY COMMITTEE CITY OF DEKALB AUGUST 15, 2017 A. CALL TO ORDER The Finance Advisory Committee meeting of August 15, 2017 was called to order at 5:01 p.m. by Chair Peddle. B. ROLL CALL Committee members present were Tom Teresinski, David Conlin, Steve Parker, Lynn Neeley, Ron Partch and Chairman Mike Peddle. Staff present: City Manager Anne Marie Gaura, Interim Finance Director Jeff Wilkins, and Account Technician III Carri Parker. Staff present in audience: Mayor Jerry Smith (left at 5:30 p.m.) and Management Analyst Aaron Stevens (left at 6:00 p.m.) Committee member not present were Jason Crome. Chair Peddle requested approval of the agenda. MOTION Committee Member Teresinski moved to approve the agenda; seconded by Committee Member Neeley. Chair Peddle requested a change to the agenda. He asked for the Public Participation be moved to the top of the agenda and asked for a motion to approve this change. MOTION Committee Member Teresinski moved to approve the amended agenda; seconded by Committee Member Neeley. VOTE Motion carried on an omnibus vote. Chair Peddle declared motion passed. C. APPROVAL OF MINUTES 1. Minutes of the Joint City Council and Finance Advisory Committee Meeting of October 27, 2016 2. Minutes of the Joint City Council and Finance Advisory Committee Meeting of November 3, 2016 3. Minutes of the Joint City Council and Finance Advisory Committee Meeting of November 8, 2016 Finance Advisory Committee Meeting August 15, 2017 Page 2 of 4 4. Minutes of the Joint City Council and Finance Advisory Committee Meeting of November 15, 2016 5. Minutes of the Finance Advisory Committee Meeting of May 2, 2017 MOTION Committee Member Neeley moved to approve the minutes; seconded by Committee Member Teresinski. VOTE Motion carried on an omnibus vote. Chair Peddle declared motion passed. D. PUBLIC PARTICIPATION Bessie Chronopoulos requested that she would like the Committee to scrutinize the budget. She also added that she would like the committee to meet more often throughout the year. Mark Charvat agreed that the Committee should look at the budget line by line, and meet more often. He added that he was told the Library will receive state capital reimbursement this year and inquired about the City’s ability to obtain repayment for the loan the City gave the Library for the past two years. Mr. Charvat questioned what happened to the points brought out by Alderman Jacobson referencing cuts in the FY2017 budget meeting on 10/27/16 and went through the list of cuts suggested. Chair Peddle provided information on the conversation that he had with Mr. Charvat a couple weeks prior. He stated that the libraries levy is large enough to handle the rebate in one year. He added that assuming that the Library receives the state capital reimbursement that the library’s levy should be $1.2 million for this year. E. OVERVIEW OF THE FY2016.5 COMPREHENSIVE ANNUAL FINANICAL REPORT (CAFR) Interim Finance Director Wilkins introduced Brian LeFevre from Sikich to provide an overview of the FY2016.5 CAFR. Mr. LeFevre provided an overview of the Government auditing standards section as it applies to the City’s internal controls, executive summary, fund financial statements, and statement of revenue. A discussion ensued between Committee members, staff and Mr. LeFevre on the fund balance, statements, and pension funding. Mr. LeFevre continued explaining the pension contributions, and how the actuary determines what the employer contribution rate will be. He added that the City has put a little more than what was recommended in the pension funds. Committee member Teresinski asked what type of fraud testing is conducted. Mr. These minutes have not been approved by the Finance Advisory Committee Finance Advisory Committee Meeting August 15, 2017 Page 3 of 4 LeFevre answered as part of any audit there is a risk assessment process. He added there is an entire assessment process related to finding deficiencies in controls. Committee Member Partch asked if there are any opinions or trends that the Committee should be reviewing. Mr. LeFevre suggested a pension funding policy to determine the pension funding and work directly with pension boards to determine appropriate rate of return. Chair Peddle mentioned that the City changed actuaries last year and they intend to review the rate of return. City Manager Gaura added that staff plans to bring the actuaries to the next meeting. Peddle commented the statistical and background sections have a lot of information the Committee would like to see in the Five Year Financial Plan. This plan will be bring all of the information into one place. He mentioned that staff will have a draft of the plan at the September meeting. F. OVERVIEW OF CITY’S BOND RATING SUMMARY REPORT Interim Finance Director Wilkins stated that William Blair has been the underwriter/financial advisor for the City for some time and will be pulling out of the Municipal finance field this year. He added that the bond rating has been reduced from AA3 to A1. He explained the bond rating history, rating comparisons, calculations and future plans. He stated that increased base is important. Chair Peddle commented on the economic conditions, that he was surprised that the real estate market in DeKalb is doing very well. He added that if this is true, it will feed through in the EAV from the assessment. He mentioned that there is some increased demand in the market, and on the fixed rate investment returns have been increased in the past months. Chair Peddle stated that nothing supports Moody’s projection and states that they are overly conservative. G. FY2018 GENERAL FUND MAJOR REVENUE RECOMMENDATIONS Interim Finance Director Wilkins provided a summary of the City’s revenues. He reviewed the projected taxes and explained how they are distributed. Committee Member Teresinski and Chair Peddle discussed the sales tax distribution. Interim Finance Director Wilkins continued explaining the tax revenue. Chair Peddle added that the income tax sharing on behalf of the state is not distributed evenly. He mentioned that none of the additional income tax funds are given to the local governments. He stated that the City will not hit the projected amount given. A discussion ensued between committee members and staff on the tax income why it is reduced and how the state determines the local distribution. These minutes have not been approved by the Finance Advisory Committee  Finance Advisory Committee Meeting August 15, 2017 Page 4 of 4 Committee Member Neeley left the meeting at 6:25 p.m. Interim Finance Director Wilkins continued explaining the FY2018 revenues. Chair Peddle mentioned that we have to have a quick turn-around with regard to restaurants. Committee Member Neeley returned to the meeting at 6:26 p.m. Interim Finance Director Wilkins continued revenue discussion. A discussion ensued between committee members and staff on the Ambulance fee rate increase. H. OTHER ITEMS Committee Member Neeley thanked staff for the summary. City Manager Gaura asked if there were any questions, and mentioned that the actuaries will be at next month’s meeting. Committee Member Teresinski asked for an update on the Water Capital Plan. Chair Peddle requested the report for the next fiscal year budget. Committee Member Teresinski also requested in the Five Year Financial Plan an explanation to rationalize our need. I. PUBLIC PARTICIPATION Mr. Charvat questioned the property tax increase and where did the projection come from. Chair Peddle explained that the actuaries have stated that if we do the exact same thing as we did last year that is what the result will be. He added that at this point we cannot predict future tax increases. He included that this was an actuarial based assumption. City Manager Gaura added that this would be in accordance with the financial polices established by the Committee and City Council. J. CONFIRM NEXT MEETING DATE AND TIME The next meeting will be Thursday, September 21, 2017 at 5:00 p.m. K. ADJOURNMENT Chair Peddle requested a motion to adjourn, moved by Committee Member Neeley and seconded by Committee Member Teresinski. Motion passed by an omnibus vote. Meeting adjourned at 6:46 p.m. __________________________________________ CARRI PARKER, Account Technician III These minutes have not been approved by the Finance Advisory Committee RETURN TO AGENDA DATE: September 15, 2017 TO: Mike Peddle, Chair Finance Advisory Committee FROM: Anne Marie Gaura, City Manager Jeff Wilkins, Interim Finance Director SUBJECT: Actuarial Reports for Police and Fire Pension Funds Foster & Foster Actuaries and Consultants will attend the September 21 Finance Advisory Committee meeting. They will review the actuarial valuation reports for the Police Pension Fund and Fire Pension Fund. Both actuarial valuation reports are attached for your review. Page 5 of each report shows the levy increase required. The Police Pension stipulates an increased employer contribution of $178,063 from $2,680,967 to $2,502,904. The Fire Pension stipulates an increased employer contribution of $193,000 from $2,990,000 to $3,183,910. They will also review investment return studies that show the impact of lowering the investment return assumptions from 7.5% to 7.25% and 7.00% respectively. Lowering the investment return increases the employer’s contribution. The Police Pension is affected as follows by lowering the investment return below 7.5%. At 7.25% return rate, the employer contribution increases to $2,830,983 ($150,016 vs. 7.5%). At 7.00% rate, the employer contribution increases to $2,987,254 ($306,287 vs. 7.5%). The Fire Pension is affected as follows by lowering the investment return below 7.5%. At 7.25% return rate, the employer contribution increases to $3,320,583 ($136,673 vs. 7.5%). At 7.00% rate, the employer contribution increases to $2,987,254 ($279,400 vs. 7.5%). Also in your packet is “Comparison of Police Pension Fund and Illinois Municipal Retirement Fund (IMRF). The comparison lists two major reasons IMRF investments are expected to outperform Police Pension Fund Plans over the long term: 1) Illinois Pension Code restricts investments of Police Pension Funds and, 2) Scale of IMRF allows for lower fees. Fire Pensions are restricted in the same manner by Illinois Pension Code. The Illinois Pension code has reduced restrictions slightly in 2011 and 2012. Police and Fire Pensions with more than $10 million can now invest up to 65% of assets in common and preferred U.S. stocks. Previous maximum was 60% before July 1, 2012 and 55% before July 1, 2011. Major restrictions still enforce are: U.S. bonds must be held directly by pension (cannot be in mutual fund), and foreign stocks and bonds must be held within a mutual fund. Please also find in your packet the “Revenue and Expenditure Policy” (Policy number: 01-04 dated January 9, 2017). This policy provides priority guidance regarding the City’s levy of property taxes. The first section lists the following priorities: 1. The City prefers to keep its property tax rate as low as possible. The following components shall be followed in priority order each year when establishing the property tax levy: a. Levy for Police, Fire and IMRF pensions per actuary calculations. If the actuarial reports indicated a higher employer contribution is needed, said increase will need to be added to the City’s overall previous year levy request to avoid underfunding problems. b. Levy for FICA. c. Levy for general obligation bond principal and interest less abatements. d. Levy to support General Fund operations including Police, Fire, Public Works, Community Development, Finance, Human Resources, I.T. and Administration. The annual increase for this component should not exceed the rate of inflation. e. Levy to fund additional personnel as determined by the City Council. Page |2  CITY OF DEKALB POLICE PENSION FUND ACTUARIAL VALUATION AS OF JANUARY 1, 2017 CONTRIBUTIONS APPLICABLE TO THE PLAN/FISCAL YEAR ENDING DECEMBER 31, 2018 GASB 67/68 DISCLOSURE INFORMATION AS OF DECEMBER 31, 2016  May 1, 2017 City of DeKalb c/o Robert Miller, Assistant Finance Director 200 South Fourth Street DeKalb, IL 60115 Re: Actuarial Valuation Report (including GASB Statements No. 67 and No. 68) – City of DeKalb Police Pension Fund Dear Mr. Miller: We are pleased to present to the City this report of the annual actuarial valuation of the City of DeKalb Police Pension Fund. Included are the related results for GASB Statements No. 67 and No. 68. The funding valuation was performed to determine whether the assets and contributions are sufficient to provide the prescribed benefits and to develop the appropriate funding requirements for the applicable plan year. The calculation of the liability for GASB results was performed for the purpose of satisfying the requirements of GASB Statements No. 67 and No. 68. Use of the results for other purposes may not be applicable and produce significantly different results. The valuations have been conducted in accordance with generally accepted actuarial principles and practices, including the applicable Actuarial Standards of Practice as issued by the Actuarial Standards Board, and reflects laws and regulations issued to date pursuant to the provisions of Article 3, Illinois Pension Code, as well as applicable federal laws and regulations. In our opinion, the assumptions used in this valuation, as adopted by the Board of Trustees, represent reasonable expectations of anticipated plan experience. Future actuarial measurements may differ significantly from the current measurements presented in this report for a variety of reasons including: changes in applicable laws, changes in plan provisions, changes in assumptions, or plan experience differing from expectations. In conducting the valuation, we have relied on personnel, plan design, and asset information supplied by the City, financial reports prepared by the custodian bank and the actuarial assumptions and methods described in the Actuarial Assumptions section of this report. While we cannot verify the accuracy of all this information, the supplied information was reviewed for consistency and reasonableness. As a result of this review, we have no reason to doubt the substantial accuracy of the information and believe that it has produced appropriate results. This information, along with any adjustments or modifications, is summarized in various sections of this report. The total pension liability, net pension liability, and certain sensitivity information shown in the GASB results are based on an actuarial valuation performed as of the valuation date. Certain schedules should include a 10-year history of information. As provided for in GASB Statements No. 67 and No.68, this historical information is only presented for the years in which the information was measured. This conforms to the requirements of GASB Statements No. 67 and No. 68. One Oakbrook Terrace, Suite 720 Oakbrook Terrace, IL 60181 · (630) 620-0200 · Fax (239) 481-0634 · www.foster-foster.com  The undersigned is familiar with the immediate and long-term aspects of pension valuations and meets the Qualification Standards of the American Academy of Actuaries necessary to render the actuarial opinions contained herein. All of the sections of this report are considered an integral part of the actuarial opinions. To our knowledge, no associate of Foster & Foster, Inc. working on valuations of the program has any direct financial interest or indirect material interest in the City of DeKalb, nor does anyone at Foster & Foster, Inc. act as a member of the Board of Trustees of City of DeKalb Police Pension Fund. Thus, there is no relationship existing that might affect our capacity to prepare and certify this actuarial report. If there are any questions, concerns, or comments about any of the items contained in this report, please contact us at 630-620-0200. Respectfully submitted, Foster & Foster, Inc. By: ______________________________ Jason L. Franken Enrolled Actuary #17-6888 JLF/lke Enclosures  TABLE OF CONTENTS Section Title Page I Introduction a. Summary of Report 5 b. Changes Since Prior Valuation 7 c. Comparative Summary of Principal Valuation Results 8 II Valuation Information a. Development of Amortization Payment 14 b. Statutory Minimum Required Contribution 15 c. Projection of Benefit Payments 16 d. Actuarial Assumptions and Methods 17 e. Glossary 19 III Trust Fund 20 IV Member Statistics a. Statistical Data 24 b. Age and Service Distribution 25 c. Valuation Participant Reconciliation 26 V Summary of Current Plan 27 VI Governmental Accounting Standards Board Statements No. 67 and No. 68 Disclosure Information 30 City of DeKalb Police Pension Fund FOSTER & FOSTER | 4  SUMMARY OF REPORT The regular annual actuarial valuation of the City of DeKalb Police Pension Fund, performed as of January 1, 2017, has been completed and the results are presented in this Report. The contribution amounts set forth herein are applicable to the plan/fiscal year ended December 31, 2018. The contribution requirements, compared with those set forth in the July 1, 2016 actuarial report, are as follows: Valuation Date 1/1/2017 7/1/2016 Applicable to Fiscal Year Ending 12/31/2018 6/30/2018 Total Required Contribution $3,217,853 $3,061,659 % of Projected Annual Payroll 59.4% 54.3% Member Contributions (Est.) 536,886 558,755 % of Projected Annual Payroll 9.9% 9.9% City Required Contribution 2,680,967 2,502,904 % of Projected Annual Payroll 49.5% 44.4% As you can see, the Total Required Contribution, when expressed as a percentage of annual payroll, shows an increase when compared to the results determined in the July 1, 2016 actuarial valuation report. The increase is primarily attributable to the projection of the mortality tables. The plan also had slightly unfavorable experience during the past 6 months. Unfavorable plan experience resulted from assets that earned a 5.83% investment return (Actuarial basis) which fell short of the 7.50% assumption. In addition, there were more active retirements than expected and no inactive deaths. This was partially offset by salary increases that were lower than assumed. City of DeKalb Police Pension Fund FOSTER & FOSTER | 5 The balance of this Report presents additional details of the actuarial valuation and the general operation of the Fund. The undersigned would be pleased to meet with the City in order to discuss the Report and answer any pending questions concerning its contents. Respectfully submitted, FOSTER & FOSTER, INC. By: ______________________________ Jason L. Franken, FSA, EA, MAAA City of DeKalb Police Pension Fund FOSTER & FOSTER | 6  Plan Changes Since Prior Valuation There have been no Plan changes since the prior valuation. Actuarial Assumption/Method Changes Since Prior Valuation The following assumptions have been changed since the prior valuation:  The mortality assumptions were updated to include a projection to the valuation date using Scale BB. City of DeKalb Police Pension Fund FOSTER & FOSTER | 7  COMPARATIVE SUMMARY OF PRINCIPAL VALUATION RESULTS New Assump Old Assump 1/1/2017 1/1/2017 7/1/2016 A. Participant Data Number Included Actives 61 61 63 Service Retirees 42 42 39 Beneficiaries 7 7 7 Disability Retirees 2 2 2 Terminated Vested 4 4 4 Total 116 116 115 Total Annual Payroll $5,417,619 $5,417,619 $5,638,291 Payroll Under Assumed Ret. Age 5,417,619 5,417,619 5,638,291 Annual Rate of Payments to: Service Retirees 2,678,299 2,678,299 2,410,518 Beneficiaries 212,170 212,170 212,170 Disability Retirees 100,337 100,337 100,337 Terminated Vested 91,326 91,326 91,326 B. Assets Actuarial Value 32,821,116 32,821,116 31,007,392 Market Value 31,126,232 31,126,232 28,699,935 C. Liabilities Present Value of Benefits Actives Retirement Benefits 28,257,332 27,417,892 29,680,982 Disability Benefits 2,733,954 2,664,001 2,768,961 Death Benefits 532,164 557,522 606,277 Vested Benefits 2,835,666 2,764,734 2,874,083 Service Retirees 36,684,619 34,840,639 30,997,396 Beneficiaries 2,019,135 1,943,613 1,956,807 Disability Retirees 1,312,526 1,268,085 1,278,205 Terminated Vested 615,360 593,645 771,265 Total 74,990,756 72,050,131 70,933,976 City of DeKalb Police Pension Fund FOSTER & FOSTER | 8  New Assump Old Assump C. Liabilities - (Continued) 1/1/2017 1/1/2017 7/1/2016 Present Value of Future Salaries 50,356,475 50,328,503 51,007,432 Present Value of Future Member Contributions 4,990,327 4,987,555 5,054,837 Normal Cost (Retirement) 770,557 747,393 793,331 Normal Cost (Disability) 170,791 167,323 177,193 Normal Cost (Death) 22,342 23,429 24,485 Normal Cost (Vesting) 127,558 124,463 125,808 Total Normal Cost 1,091,248 1,062,608 1,120,817 Present Value of Future Normal Costs 9,343,074 9,097,976 9,353,994 Accrued Liability (Retirement) 21,469,989 20,832,919 22,899,523 Accrued Liability (Disability) 1,242,114 1,201,152 1,262,945 Accrued Liability (Death) 354,377 371,553 414,666 Accrued Liability (Vesting) 1,949,562 1,900,549 1,999,175 Accrued Liability (Inactives) 40,631,640 38,645,982 35,003,673 Total Actuarial Accrued Liability 65,647,682 62,952,155 61,579,982 Unfunded Actuarial Accrued Liability (UAAL) 32,826,566 30,131,039 30,572,590 Funded Ratio (AVA / AL) 50.0% 52.1% 50.4% City of DeKalb Police Pension Fund FOSTER & FOSTER | 9  New Assump Old Assump 1/1/2017 1/1/2017 7/1/2016 D. Actuarial Present Value of Accrued Benefits Vested Accrued Benefits Inactives 40,631,640 38,645,982 35,003,673 Actives 6,179,127 5,856,060 7,674,598 Member Contributions 5,420,212 5,420,212 5,685,210 Total 52,230,979 49,922,254 48,363,481 Non-vested Accrued Benefits 1,370,764 1,351,472 1,333,106 Total Present Value Accrued Benefits 53,601,743 51,273,726 49,696,587 Funded Ratio (MVA / PVAB) 58.1% 60.7% 57.8% Increase (Decrease) in Present Value of Accrued Benefits Attributable to: Plan Amendments 0 0 Assumption Changes 2,328,017 0 New Accrued Benefits 0 1,188,208 Benefits Paid 0 (1,447,549) Interest 0 1,836,480 Other 0 0 Total 2,328,017 1,577,139 City of DeKalb Police Pension Fund FOSTER & FOSTER | 10  New Assump Old Assump Valuation Date 1/1/2017 1/1/2017 7/1/2016 Applicable to Fiscal Year Ending 12/31/2018 12/31/2018 6/30/2018 E. Pension Cost Normal Cost (with interest) $1,173,092 $1,142,304 $1,204,878 % of Total Annual Payroll ¹ 21.6 21.1 21.3 Administrative Expenses (with interest) 47,296 47,296 48,364 % of Total Annual Payroll ¹ 0.9 0.9 0.9 Payment Required to Amortize Unfunded Actuarial Accrued Liability over 24 years (as of 1/1/2017, with interest) 1,997,465 1,833,445 1,808,417 % of Total Annual Payroll ¹ 36.9 33.8 32.1 Total Required Contribution 3,217,853 3,023,045 3,061,659 % of Total Annual Payroll ¹ 59.4 55.8 54.3 Expected Member Contributions 536,886 536,886 558,755 % of Total Annual Payroll ¹ 9.9 9.9 9.9 Expected City Contribution 2,680,967 2,486,159 2,502,904 % of Total Annual Payroll ¹ 49.5 45.9 44.4 F. Past Contributions Plan Years Ending: 12/31/2016 Total Required Contribution 1,352,748 City 1,080,991 Actual Contributions Made: Members (excluding buyback) 271,757 City 2,085,233 Total 2,356,990 G. Net Actuarial (Gain)/Loss 198,905 ¹ Contributions developed as of 1/1/2017 are expressed as a percentage of total annual payroll at 1/1/2017 of $5,417,619. ² Contributions are presented as a full annual contribution despite the short plan year. City of DeKalb Police Pension Fund FOSTER & FOSTER | 11 H. Schedule Illustrating the Amortization of the Total Unfunded Actuarial Accrued Liability as of: Projected Unfunded Year Accrued Liability 2017 32,826,566 2018 33,291,093 2019 33,700,574 2025 34,484,182 2030 31,568,402 2036 20,277,508 2041 0 I. (i) 3 Year Comparison of Actual and Assumed Salary Increases Actual Assumed Year Ended 12/31/2016 2.80% 4.50% Year Ended 6/30/2016 4.48% 4.50% Year Ended 6/30/2015 4.70% 4.50% (ii) 3 Year Comparison of Investment Return on Actuarial Value Actual Assumed Year Ended 12/31/2016 5.83% 7.50% Year Ended 6/30/2016 3.49% 7.50% Year Ended 6/30/2015 N/A N/A City of DeKalb Police Pension Fund FOSTER & FOSTER | 12  STATEMENT BY ENROLLED ACTUARY This actuarial valuation was prepared and completed by me or under my direct supervision, and I acknowledge responsibility for the results. To the best of my knowledge, the results are complete and ac- curate, and in my opinion, the techniques and assumptions used are reasonable and meet the requirements and intent of the Illinois Pension Code and adhere to the Actuarial Standards of Practice. There is no ben- efit or expense to be provided by the plan and/or paid from the plan's assets for which liabilities or current costs have not been established or otherwise taken into account in the valuation. All known events or trends which may require a material increase in plan costs or required contribution rates have been taken into account in the valuation. ________________________ Jason L. Franken, FSA, EA, MAAA Enrolled Actuary #14-6888 City of DeKalb Police Pension Fund FOSTER & FOSTER | 13  DEVELOPMENT OF JANUARY 1, 2017 AMORTIZATION PAYMENT (1) Unfunded Actuarial Accrued Liability as of July 1, 2016 $30,572,590 (2) Sponsor Normal Cost developed as of July 1, 2016 281,031 (3) Expected administrative expenses for the year ended December 31, 2016 44,990 (4) Expected interest on (1), (2) and (3) 1,157,854 (5) Sponsor contributions to the System during the year ended December 31, 2016 2,085,233 (6) Expected interest on (5) 39,098 (7) Expected Unfunded Actuarial Accrued Liability as of December 31, 2016, (1)+(2)+(3)+(4)-(5)-(6) 29,932,134 (8) Change to UAAL due to Assumption Change 2,695,527 (9) Change to UAAL due to Actuarial (Gain)/Loss 198,905 (10) Unfunded Accrued Liability as of January 1, 2017 32,826,566 Date Years 1/1/2017 Amortization Established Remaining Amount Amount 1/1/2017 24 32,826,566 1,858,107 City of DeKalb Police Pension Fund FOSTER & FOSTER | 14  STATUTORY MINIMUM REQUIRED CONTRIBUTION Contribution requirements shown on this page are calculated according to statutory minimum funding requirements of the Illinois Pension Code. We do not believe this method is sufficient to fund future benefits; as such, we recommend funding according to the contributions developed in Section E of this report. New Assump Old Assump Valuation Date 1/1/2017 1/1/2017 7/1/2016 Applicable to Fiscal Year Ending 12/31/2018 12/31/2018 6/30/2018 Actuarial Accrued Liability (PUC) 62,613,983 60,024,909 58,640,424 Actuarial Value of Assets 32,821,116 32,821,116 31,007,392 Unfunded Actuarial Accrued Liability (UAAL) 29,792,867 27,203,793 27,633,032 UAAL Subject to Amortization 23,531,469 21,201,302 21,768,990 Normal Cost (with interest) $1,437,342 $1,398,975 1,204,878 % of Total Annual Payroll ¹ 26.5 25.8 21.3 Administrative Expenses (with interest) 47,296 47,296 48,364 % of Total Annual Payroll ¹ 0.9 0.9 0.9 Payment Required to Amortize Unfunded Actuarial Accrued Liability over 24 years (as of 1/1/2017, with interest) 1,431,867 1,290,079 1,808,417 % of Total Annual Payroll ¹ 26.4 23.8 32.1 Total Required Contribution 2,916,505 2,736,350 3,061,659 % of Total Annual Payroll ¹ 53.8 50.5 54.3 Expected Member Contributions 536,886 536,886 558,755 % of Total Annual Payroll ¹ 9.9 9.9 9.9 Expected City Contribution 2,379,619 2,199,464 2,502,904 % of Total Annual Payroll ¹ 43.9 40.6 44.4 Assumptions and Methods: Actuarial Cost Method Projected Unit Credit Amortization Method 90% Funding by 2040 All other assumptions and methods are as described in the Actuarial Assumptions and Methods section. ¹ Contributions developed as of 1/1/2017 are expressed as a percentage of total annual payroll at 1/1/2017 of $5,417,619. City of DeKalb Police Pension Fund FOSTER & FOSTER | 15  PROJECTION OF BENEFIT PAYMENTS Payments for Payments for Total Year Current Actives Current Inactives Payments 2017 93,315 2,964,281 3,057,596 2018 181,936 3,033,172 3,215,108 2019 301,059 3,089,352 3,390,411 2020 431,515 3,155,247 3,586,762 2021 622,097 3,208,895 3,830,992 2022 813,690 3,258,750 4,072,440 2023 1,006,957 3,304,204 4,311,161 2024 1,232,857 3,362,677 4,595,534 2025 1,433,526 3,397,320 4,830,846 2026 1,676,148 3,451,413 5,127,561 2027 1,928,557 3,472,292 5,400,849 2028 2,165,096 3,484,838 5,649,934 2029 2,472,021 3,488,364 5,960,385 2030 2,755,946 3,482,307 6,238,253 2031 3,113,429 3,465,980 6,579,409 2032 3,435,396 3,452,442 6,887,838 2033 3,736,816 3,442,751 7,179,567 2034 4,038,573 3,394,237 7,432,810 2035 4,288,000 3,333,964 7,621,964 2036 4,578,127 3,261,940 7,840,067 2037 4,867,868 3,178,107 8,045,975 2038 5,134,734 3,097,544 8,232,278 2039 5,406,627 2,991,814 8,398,441 2040 5,662,404 2,876,088 8,538,492 2041 5,924,850 2,751,456 8,676,306 2042 6,157,699 2,619,287 8,776,986 2043 6,358,514 2,481,159 8,839,673 2044 6,553,329 2,338,810 8,892,139 2045 6,713,552 2,194,081 8,907,633 2046 6,860,971 2,048,320 8,909,291 2047 6,980,112 1,902,991 8,883,103 2048 7,073,327 1,759,259 8,832,586 2049 7,151,071 1,617,946 8,769,017 2050 7,212,608 1,479,900 8,692,508 2051 7,255,801 1,345,959 8,601,760 2052 7,279,582 1,216,573 8,496,155 2053 7,281,883 1,092,200 8,374,083 2054 7,261,616 973,661 8,235,277 2055 7,217,211 861,481 8,078,692 2056 7,147,297 756,274 7,903,571 City of DeKalb Police Pension Fund FOSTER & FOSTER | 16  ACTUARIAL ASSUMPTIONS AND METHODS Mortality Rate RP-2000 Combined Healthy Mortality with a blue collar adjustment, projected to the valuation date with Scale BB. Disabled Mortality Rate RP-2000 Disabled Retiree Mortality, projected to the valuation date with Scale BB. Based on studies of public safety pension plans, we believe this assumption sufficiently accommodates expected future mortality improvements. Interest Rate 7.50% per year compounded annually, net of investment related expenses. We will continue to monitor the target asset allocation and expected return of the asset classes to ensure a reasonable relationship to the interest rate. Retirement Age See table on following page. This is based on an experience study performed in 2012. Disability Rate See table on following page. 70% of the disabilities are assumed to be in the line of duty. This is based on an experience study performed in 2012. Termination Rate See table on following page. This is based on an experience study performed in 2012. Salary Increases 4.50% per year. Payroll Growth 4.50% per year. Inflation 2.50%. Cost-of-Living Adjustment Tier 1: 3.00% per year after age 55. Those that retire prior to age 55 receive an increase of 1/12 of 3.00% for each full month since benefit commencement upon reaching age 55. Tier 2: 1.25% per year after the later of attainment of age 60 or first anniversary of retirement. Administrative Expenses Expenses paid out of the fund other than investment-related expenses are assumed to be equal to those paid in the previous year. Marital Status 80% of Members are assumed to be married. Spouse’s Age Males are assumed to be three years older than females. Funding Method Entry Age Normal Cost Method. Actuarial Asset Method Investment gains and losses are smoothed over a 5-year period. City of DeKalb Police Pension Fund FOSTER & FOSTER | 17 Funding Policy Amortization Method The UAAL is amortized according to a Level Percentage of Payroll method over a period ending in 2041. The initial amortization amount is 100% of the Accrued Liability less the Actuarial Value of Assets. Decrement Tables % Terminating % Becoming Disabled % Retiring During the Year During the Year During the Year Age Rate Age Rate Age Rate 15 - 24 10.00% 20 0.05% <=49 0% 25 7.50% 25 0.05% 50 - 54 20% 26 - 27 6.25% 30 0.22% 55 - 59 25% 28 - 31 5.00% 35 0.26% 60 - 62 33% 32 - 34 4.00% 40 0.40% 63 - 69 50% 35 - 37 3.00% 45 0.65% >=70 100% 38 - 49 2.00% 50 0.95% >=50 3.50% 55 1.30% 60 1.65% 65 2.00% City of DeKalb Police Pension Fund FOSTER & FOSTER | 18  GLOSSARY Total Annual Payroll is the projected annual rate of pay for the fiscal year following the valuation date of all covered members. Present Value of Benefits is the single sum value on the valuation date of all future benefits to be paid to current Members, Retirees, Beneficiaries, Disability Retirees and Vested Terminations. Normal (Current Year's) Cost is the current year's cost for benefits yet to be funded. Unfunded Accrued Liability is a liability which arises when a pension plan is initially established or improved and such establishment or improvement is applicable to all years of past service. Total Required Contribution is equal to the Normal Cost plus an amount sufficient to amortize the Unfunded Accrued Liability over a period ending in 2041. The required amount is adjusted for interest according to the timing of contributions during the year. Entry Age Normal Cost Method - Under this method, the normal cost is the sum of the individual normal costs for all active participants. For an active participant, the normal cost is the participant’s normal cost accrual rate, multiplied by the participant’s current compensation. (a) The normal cost accrual rate equals: (i) the present value of future benefits for the participant, determined as of the participant’s entry age, divided by (ii) the present value of the compensation expected to be paid to the participant for each year of the participant’s anticipated future service, determined as of the participant’s entry age. (b) In calculating the present value of future compensation, the salary scale is applied both retrospectively and prospectively to estimate compensation in years prior to and subsequent to the valuation year based on the compensation used for the valuation. (c) The accrued liability is the sum of the individual accrued liabilities for all participants and beneficiaries. A participant’s accrued liability equals the present value, at the participant’s attained age, of future benefits less the present value at the participant’s attained age of the individual normal costs payable in the future. A beneficiary’s accrued liability equals the present value, at the beneficiary’s attained age, of future benefits. The unfunded accrued liability equals the total accrued liability less the actuarial value of assets. (d) Under this method, the entry age used for each active participant is the participant’s age at the time he or she would have commenced participation if the plan had always been in existence under current terms, or the age as of which he or she first earns service credits for purposes of benefit accrual under the current terms of the plan. City of DeKalb Police Pension Fund FOSTER & FOSTER | 19  STATEMENT OF FIDUCIARY NET POSITION December 31, 2016 ASSETS MARKET VALUE Cash and Cash Equivalents: Checking Account 291,149 Money Market 73,932 Total Cash and Equivalents 365,081 Receivables: City Contributions in Transit 462,811 Prepaid Expenses 2,208 Accrued Past Due Interest 35,849 Total Receivable 500,868 Investments: State, Corporate and Local Obligations 2,801,220 U.S. Gov't and Agency Obligations 7,854,791 Mutual Funds 19,620,139 Total Investments 30,276,150 Total Assets 31,142,099 LIABILITIES Liabilities: Payable: Expenses 15,867 Total Liabilities 15,867 Net Assets: Active and Retired Members' Equity 31,126,232 NET POSITION RESTRICTED FOR PENSIONS 31,126,232 TOTAL LIABILITIES AND NET ASSETS 31,142,099 City of DeKalb Police Pension Fund FOSTER & FOSTER | 20  STATEMENT OF CHANGES IN FIDUCIARY NET POSITION FOR THE YEAR ENDED December 31, 2016 Market Value Basis ADDITIONS Contributions: Member 282,997 Miscellaneous Member Revenue 11,240 City 2,085,233 Total Contributions 2,379,470 Investment Income: Net Realized Gain (Loss) (218,213) Unrealized Gain (Loss) 1,310,147 Net Increase in Fair Value of Investments 1,091,934 Interest & Dividends 446,219 Less Investment Expense ¹ (21,779) Net Investment Income 1,516,374 Total Additions 3,895,844 DEDUCTIONS Distributions to Members: Benefit Payments 1,447,549 Total Distributions 1,447,549 Administrative Expenses 21,998 Total Deductions 1,469,547 Net Increase in Net Position 2,426,297 NET POSITION RESTRICTED FOR PENSIONS Beginning of the Year 28,699,935 End of the Year 31,126,232 ¹ Investment Related expenses include investment advisory, custodial and performance monitoring fees. City of DeKalb Police Pension Fund FOSTER & FOSTER | 21  ACTUARIAL ASSET VALUATION December 31, 2016 Actuarial Assets for funding purposes are developed by recognizing the total actuarial investment gain or loss for each Plan Year over a five year period. In the first year, 20% of the gain or loss is recognized. In the second year 40%, in the third year 60%, in the fourth year 80%, and in the fifth year 100% of the gain or loss is recognized. The actuarial investment gain or loss is defined as the actual return on investments minus the actuarial assumed investment return. Actuarial Assets shall not be less than 80% nor greater than 120% of the Market Value of Assets. Gains/(Losses) Not Yet Recognized Plan Year Amounts Not Yet Recognized by Valuation Year Ending Gain/(Loss) 2017 2018 2019 2020 2021 6/30/2013 (83,071) (8,307) 0 0 0 0 6/30/2014 1,335,651 400,695 133,565 0 0 0 6/30/2015 (1,849,608) (924,804) (554,882) (184,961) 0 0 6/30/2016 (2,144,172) (1,500,920) (1,072,086) (643,252) (214,417) 0 12/31/2016 423,065 338,452 253,839 169,226 84,613 0 Total (1,694,884) (1,239,564) (658,987) (129,804) 0 Development of Investment Gain/Loss Market Value of Assets, 6/30/2016 28,699,935 Contributions Less Benefit Payments & Administrative Expenses 909,923 Expected Investment Earnings¹ 1,093,309 Actual Net Investment Earnings 1,516,374 2017 Actuarial Investment Gain/(Loss) 423,065 ¹ Expected Investment Earnings = 7.50% x 1/2 x (28,699,935 + 0.5 x 909,923) Development of Actuarial Value of Assets Market Value of Assets, 12/31/2016 31,126,232 (Gains)/Losses Not Yet Recognized 1,694,884 Actuarial Value of Assets, 12/31/2016 32,821,116 (A) 6/30/2016 Actuarial Assets: 31,007,392 (I) Net Investment Income: 1. Interest and Dividends 446,219 2. Realized Gains (Losses) (218,213) 3. Change in Actuarial Value 697,574 4. Investment Expenses (21,779) Total 903,801 (B) 12/31/2016 Actuarial Assets: 32,821,116 Actuarial Asset Rate of Return = (2 x I) / (A + B - I) (Annualized): 5.83% Market Value of Assets Rate of Return (Annualized): 10.67% 12/31/2016 Limited Actuarial Assets: 32,821,116 City of DeKalb Police Pension Fund FOSTER & FOSTER | 22  CHANGES IN NET ASSETS AVAILABLE FOR BENEFITS December 31, 2016 Actuarial Asset Basis INCOME Contributions: Member 282,997 Miscellaneous Member Revenue 11,240 City 2,085,233 Total Contributions 2,379,470 Earnings from Investments Interest & Dividends 446,219 Net Realized Gain (Loss) (218,213) Change in Actuarial Value 697,574 Total Earnings and Investment Gains 925,580 EXPENSES Administrative Expenses: Investment Related ¹ 21,779 Other 21,998 Total Administrative Expenses 43,777 Distributions to Members: Benefit Payments 1,447,549 Total Distributions 1,447,549 Change in Net Assets for the Year 1,813,724 Net Assets Beginning of the Year 31,007,392 Net Assets End of the Year ² 32,821,116 ¹ Investment Related expenses include investment advisory, custodial and performance monitoring fees. ² Net Assets may be limited for actuarial consideration. City of DeKalb Police Pension Fund FOSTER & FOSTER | 23  STATISTICAL DATA ¹ 7/1/2014 7/1/2015 7/1/2016 1/1/2017 Actives - Tier 1 Number N/A 55 50 47 Average Current Age N/A N/A 43.1 42.7 Average Age at Employment N/A N/A 27.0 27.0 Average Past Service N/A N/A 16.1 15.7 Average Annual Salary N/A N/A $93,091 $92,556 Actives - Tier 2 Number N/A 9 13 14 Average Current Age N/A N/A 30.8 30.9 Average Age at Employment N/A N/A 28.6 28.3 Average Past Service N/A N/A 2.2 2.6 Average Annual Salary N/A N/A $75,674 $76,249 Service Retirees Number 34 35 39 42 Average Current Age N/A 67.9 67.3 67.1 Average Annual Benefit $59,459 $60,957 $61,808 $63,769 Beneficiaries Number 6 6 7 7 Average Current Age N/A 72.5 68.8 69.3 Average Annual Benefit $28,332 $28,332 $30,310 $30,310 Disability Retirees Number 2 2 2 2 Average Current Age N/A 52.1 53.1 53.6 Average Annual Benefit $43,261 $43,261 $50,169 $50,169 Terminated Vested Number 4 4 4 4 Average Current Age N/A 47.6 48.6 46.8 Average Annual Benefit $22,832 $22,832 $22,832 $22,832 ² ¹ Foster & Foster does not have enough historical data to include complete data prior to 7/1/2016. We will add historical data going forward. ² Average Annual Benefit for Terminated Vested members reflects the benefit for members entitled to a future annual benefit from the plan. City of DeKalb Police Pension Fund FOSTER & FOSTER | 24  AGE AND SERVICE DISTRIBUTION PAST SERVICE AGE 0 1 2 3 4 5-9 10-14 15-19 20-24 25-29 30+ Total 15 - 19 0 0 0 0 0 0 0 0 0 0 0 0 20 - 24 0 0 0 0 0 0 0 0 0 0 0 0 25 - 29 1 2 0 1 1 2 0 0 0 0 0 7 30 - 34 0 1 1 2 1 2 0 0 0 0 0 7 35 - 39 1 0 1 1 0 5 6 3 0 0 0 17 40 - 44 0 0 0 0 0 1 2 5 1 0 0 9 45 - 49 0 0 0 0 0 0 1 3 10 1 0 15 50 - 54 0 0 0 0 0 0 0 1 1 3 0 5 55 - 59 0 0 0 0 0 0 0 0 0 0 0 0 60 - 64 0 0 0 0 0 1 0 0 0 0 0 1 65+ 0 0 0 0 0 0 0 0 0 0 0 0 Total 2 3 2 4 2 11 9 12 12 4 0 61 City of DeKalb Police Pension Fund FOSTER & FOSTER | 25  VALUATION PARTICIPANT RECONCILIATION 1. Active lives a. Number in prior valuation 7/1/2016 63 b. Terminations i. Vested (partial or full) with deferred benefits 0 ii. Non-vested or full lump sum distribution received 0 iii. Transferred service to other fund 0 c. Deaths i. Beneficiary receiving benefits 0 ii. No future benefits payable 0 d. Disabled 0 e. Retired (3) f. Continuing participants 60 g. New entrants 1 h. Total active life participants in valuation 61 2. Non-Active lives (including beneficiaries receiving benefits) Service Retirees, Vested Receiving Receiving Receiving Death Disability Vested Benefits Benefits Benefits Deferred Total a. Number prior valuation 39 7 2 4 52 Retired 3 0 0 0 3 Vested Deferred 0 0 0 0 0 Death, With Survivor 0 0 0 0 0 Death, No Survivor 0 0 0 0 0 Disabled 0 0 0 0 0 Refund of Contributions 0 0 0 0 0 Rehires 0 0 0 0 0 Expired Annuities 0 0 0 0 0 Data Corrections 0 0 0 0 0 Hired/Termed in Same Year 0 0 0 0 0 b. Number current valuation 42 7 2 4 55 City of DeKalb Police Pension Fund FOSTER & FOSTER | 26  SUMMARY OF CURRENT PLAN Article 3 Pension Fund The Plan is established and administered as prescribed by “Article 3. Police Pension Fund – Municipalities 500,000 and Under” of the Illinois Pension Code. Plan Administration The Plan is administered by a Board of Trustees comprised of: a) Two members appointed by the Municipality, b) Two active Members of the Police Department elected by the Membership, and c) One retired Member of the Police Department elected by the Membership. Credited Service Complete years of service as a sworn police officer employed by the Municipality. Normal Retirement Date Tier 1: Age 50 and 20 years of Credited Service. Tier 2: Age 55 with 10 years of service. Benefit Tier 1: 50% of annual salary attached to rank on last day of service plus 2.50% of annual salary for each year of service over 20 years, up to a maximum of 75% of salary. The minimum monthly benefit is $1,000 per month. Tier 2: 2.50% per year of service times the average salary for the eight consecutive years prior to retirement times the number of years of service, up to a maximum of 75% of average salary. The minimum monthly benefit is $1,000 per month. Form of Benefit Tier 1: For married retirees, an annuity payable for the life of the Member; upon the death of the member, 100% of the Member’s benefit payable to the spouse until death. For unmarried retirees, the normal form is a Single Life Annuity. Tier 2: Same as above, but with 66 2/3% of benefit continued to spouse. Early Retirement Date Tier 1: Age 60 and 8 years of Credited Service. Tier 2: Age 50 with 10 years of service. Benefit Tier 1: Normal Retirement benefit with no minimum. Tier 2: Normal Retirement benefit, reduced 6% each year before age 55, with no minimum benefit. Form of Benefit Same as Normal Retirement. City of DeKalb Police Pension Fund FOSTER & FOSTER | 27 Disability Benefit Eligibility Total and permanent as determined by the Board of Trustees. Benefit Amount A maximum of: a.) 65% of salary attached to the rank held by Member on last day of service, and; b.) The monthly retirement pension that the Member is entitled to receive if he or she retired immediately. For non-service connected disabilities, a benefit of 50% of salary attached to rank held by Member on last day of service. Cost-of-Living Adjustment Tier 1: Retirees: An annual increase equal to 3.00% per year after age 55. Those that retire prior to age 55 receive an increase of 1/12 of 3.00% for each full month since benefit commencement upon reaching age 55. Disabled Retirees: An annual increase equal to 3.00% per year of the original benefit amount beginning at age 60. Those that become disabled prior to age 60 receive an increase of 3.00% of the original benefit amount for each year since benefit commencement upon reaching age 60. Tier 2: An annual increase each January 1 equal to 3.00% per year or one-half of the annual unadjusted percentage increase in the consumer price index-u for the 12 months ending with the September preceding each November 1, whichever is less, of the original pension after the attainment of age 60 or first anniversary of pension start date whichever is later. Pre-Retirement Death Benefit Service Incurred 100% of salary attached to rank held by Member on last day of service. Non-Service Incurred A maximum of: a.) 50% of salary attached to the rank held by Member on last day of service, and; b.) The monthly retirement pension earned by the deceased Member at the time of death, regardless of whether death occurs before or after age 50. For non-service deaths with less than 10 years of service, a refund of member contributions is provided. City of DeKalb Police Pension Fund FOSTER & FOSTER | 28 Vesting (Termination) Vesting Service Requirement Tier 1: 8 years. Tier 2: 10 years. Non-Vested Benefit Refund of Member Contributions. Vested Benefit Either the termination benefit, payable upon reaching age 60, provided contributions are not withdrawn, or a refund of member contributions. The termination benefit is 2.50% of annual salary held in the year prior to termination (8-year final average salary for Tier 2) times creditable service. Contributions Employee 9.91% of Salary. Municipality Remaining amount necessary for payment of Normal (current year’s) Cost and amortization of the accrued past service liability. City of DeKalb Police Pension Fund FOSTER & FOSTER | 29 GASB 67 STATEMENT OF FIDUCIARY NET POSITION December 31, 2016 ASSETS MARKET VALUE Cash and Cash Equivalents: Checking Account 291,149 Money Market 73,932 Total Cash and Equivalents 365,081 Receivables: City Contributions in Transit 462,811 Prepaid Expenses 2,208 Accrued Past Due Interest 35,849 Total Receivable 500,868 Investments: State, Corporate and Local Obligations 2,801,220 U.S. Gov't and Agency Obligations 7,854,791 Mutual Funds 19,620,139 Total Investments 30,276,150 Total Assets 31,142,099 LIABILITIES Liabilities: Payable: Expenses 15,867 Total Liabilities 15,867 Net Assets: Active and Retired Members' Equity 31,126,232 NET POSITION RESTRICTED FOR PENSIONS 31,126,232 TOTAL LIABILITIES AND NET ASSETS 31,142,099 City of DeKalb Police Pension Fund FOSTER & FOSTER | 30 GASB 67 STATEMENT OF CHANGES IN FIDUCIARY NET POSITION FOR THE YEAR ENDED December 31, 2016 Market Value Basis ADDITIONS Contributions: Member 282,997 Miscellaneous Member Revenue 11,240 City 2,085,233 Total Contributions 2,379,470 Investment Income: Net Realized Gain (Loss) (218,213) Unrealized Gain (Loss) 1,310,147 Net Increase in Fair Value of Investments 1,091,934 Interest & Dividends 446,219 Less Investment Expense ¹ (21,779) Net Investment Income 1,516,374 Total Additions 3,895,844 DEDUCTIONS Distributions to Members: Benefit Payments 1,447,549 Total Distributions 1,447,549 Administrative Expenses 21,998 Total Deductions 1,469,547 Net Increase in Net Position 2,426,297 NET POSITION RESTRICTED FOR PENSIONS Beginning of the Year 28,699,935 End of the Year 31,126,232 ¹ Investment Related expenses include investment advisory, custodial and performance monitoring fees. City of DeKalb Police Pension Fund FOSTER & FOSTER | 31 GASB 67 NOTES TO THE FINANCIAL STATEMENTS (For the Year Ended December 31, 2016) Plan Description Plan Administration The Plan is administered by a Board of Trustees comprised of: a.) Two members appointed by the City, b.) Two active Members of the Police Department elected by the Membership, and c.) One retired Member of the Police Department elected by the Membership. Plan Membership as of January 1, 2017: Inactive Plan Members or Beneficiaries Currently Receiving Benefits 51 Inactive Plan Members Entitled to but Not Yet Receiving Benefits 4 Active Plan Members 61 116 Benefits Provided The Plan provides retirement, termination, disability and death benefits. Normal Retirement: Age: Tier 1: Age 50 and 20 years of service. Tier 2: Age 55 with 10 years of service. Benefit: 2.50% of Average Final Compensation times Credited Service. Early Retirement: Age: Tier 1: Age 60 and 8 years of service. Tier 2: Age 50 with 10 years of service. Benefit: Determined as for Normal Retirement; Benefit for members hired after January 1, 2011 is reduced 6.00% for each year that Early Retirement precedes Normal Retirement. Vesting (Termination): Tier 1: Less than 8 years: Refund of accumulated contributions without interest. 8 or more: Refund of Contributions or accrued benefit payable at retirement age. Tier 2: Less than 10 years: Refund of accumulated contributions without interest. 10 or more: Refund of Contributions or accrued benefit payable at retirement age. Disability: Eligibility: Total and permanent as determined by the Board of Trustees. Benefit: Benefit accrued to date of disability. Minimum benefit for Service Incurred is 65% of AFC. For Non- Service Incurred benefit is 50% of Salary. Pre-Retirement Death Benefits: Service Incurred: 100% of Salary. Non-Vested: Refund of Required Contribution Account. City of DeKalb Police Pension Fund FOSTER & FOSTER | 32 GASB 67 Cost-of-Living Adjustments: Tier 1: Retirees - 3.00% per year upon attaining age 55. For retirements prior to age 55, 1/12 of 3.00% per month benefit commences prior to reaching age 55. Disabled Retirees - annual increase of 3.00% of the original benefit amount upon attaining age 60. For disablements prior to age 60, 3.00% of original benefit per year benefit commenced prior to age 60. Tier 2: An annual increase equal to the lesser of 3.00% per year or 1/2 the annual unadjusted percentage increase in the consumer price index-u for the 12 months ending with the September preceding each November 1 of the original pension after attaining age 60. Contributions Remaining amount necessary for payment of Normal (current year’s) Cost and amortization of the accrued past service liability over a period ending in 2041. Investments Investment Policy: The following was the Board's adopted asset allocation policy as of December 31, 2016: Asset Class Target Allocation Cash 3.00% Fixed Income 32.00% Domestic Equities 40.30% International Equities 22.75% Commodities 1.95% Total 100% Concentrations: The Plan did not hold investments in any one organization that represent 5 percent or more of the Pension Plan's fiduciary net position. Rate of Return: For the year ended December 31, 2016, the annual money-weighted rate of return on Pension Plan investments, net of pension plan investment expense, was N/A percent. The money-weighted rate of return expresses investment performance, net of investment expense, adjusted for the changing amounts actually invested. City of DeKalb Police Pension Fund FOSTER & FOSTER | 33 GASB 67 NET PENSION LIABILITY OF THE SPONSOR The components of the net pension liability of the sponsor on December 31, 2016 were as follows: Total Pension Liability $ 64,976,688 Plan Fiduciary Net Position (31,126,232) Sponsor's Net Pension Liability $ 33,850,456 Plan Fiduciary Net Position as a percentage of Total Pension Liability 47.90% Actuarial Assumptions: The total pension liability was determined by an actuarial valuation as of January 1, 2017 using the following actuarial assumptions applied to all measurement periods. Inflation 2.50% Salary Increases 4.50% Investment Rate of Return 7.50% Healthy Lives: RP-2000 Combined Healthy Mortality with a blue collar adjustment, projected to the valuation date with Scale BB. Disabled Lives: RP-2000 Disabled Retiree Mortality, projected to the valuation date with Scale BB. The demographic assumptions used in the January 1, 2017 valuation were based on the results of an actuarial experience study performed by the State of Illinois Department of Insurance. The long-term expected rate of return on pension plan investments could be determined using a building-block method in which best-estimate ranges of expected future real rates of return (expected returns, net of pension plan investment expenses and inflation) are developed for each major asset class. These ranges are combined to produce the long term expected rate of return by weighting the expected future real rates of return by the target asset allocation percentage and by adding expected inflation. Best estimates of arithmetic real rates of return for each major asset class included in the pension plan's target asset allocation as of December 31, 2016 are summarized in the following table: Long Term Expected Real Rate Asset Class of Return Cash 0.00% Fixed Income 2.19% Domestic Equities 5.00% International Equities 5.50% Commodities 0.75% City of DeKalb Police Pension Fund FOSTER & FOSTER | 34 GASB 67 Discount Rate: The discount rate used to measure the total pension liability was 7.50 percent. The projection of cash flows used to determine the discount rate assumed that plan member contributions will be made at the current contribution rate and that sponsor contributions will be made at rates equal to the difference between actuarially determined contribution rates and the member rate. Based on those assumptions, the pension plan's fiduciary net position was projected to be available to make all projected future benefit payments of current plan members. Therefore, the long-term expected rate of return on pension plan investments was applied to all periods of projected benefit payments to determine the total pension liability. Current Discount 1% Decrease Rate 1% Increase 6.50% 7.50% 8.50% Sponsor's Net Pension Liability $ 42,934,393 $ 33,850,456 $ 26,394,328 City of DeKalb Police Pension Fund FOSTER & FOSTER | 35 GASB 67 SCHEDULE OF CHANGES IN NET PENSION LIABILITY AND RELATED RATIOS Last 10 Fiscal Years 12/31/2016 06/30/2016 06/30/2015 ¹ 06/30/2014 ¹ Total Pension Liability Service Cost 581,851 1,138,556 994,063 983,478 Interest 2,278,348 4,396,163 3,816,916 3,601,542 Changes of Benefit Terms - - - - Differences Between Expected and Actual Experience (30,834) (981,619) 546,806 654,735 Changes of Assumptions 2,685,767 - 3,756,869 - Contributions - Buy Back 11,240 157,490 - - Benefit Payments, Including Refunds of Employee Contributions (1,447,549) (2,579,348) (2,480,487) (2,255,726) Net Change in Total Pension Liability 4,078,823 2,131,242 6,634,167 2,984,029 Total Pension Liability - Beginning 60,897,865 58,766,623 52,132,456 49,148,427 Total Pension Liability - Ending (a) $ 64,976,688 $ 60,897,865 $ 58,766,623 $ 52,132,456 Plan Fiduciary Net Position Contributions - Employer 2,085,233 1,622,105 1,448,949 1,352,291 Contributions - Employee 282,997 570,363 711,771 632,775 Contributions - Buy Back 11,240 157,490 - - Net Investment Income 1,516,374 17,314 312,398 3,240,785 Benefit Payments, Including Refunds of Employee Contributions (1,447,549) (2,579,348) (2,480,487) (2,255,726) Administrative Expense (21,998) (44,990) (44,531) (39,544) Other - - - - Net Change in Plan Fiduciary Net Position 2,426,297 (257,066) (51,900) 2,930,581 Plan Fiduciary Net Position - Beginning 28,699,935 28,957,001 29,008,901 26,078,320 Plan Fiduciary Net Position - Ending (b) $ 31,126,232 $ 28,699,935 $ 28,957,001 $ 29,008,901 Net Pension Liability - Ending (a) - (b) $ 33,850,456 $ 32,197,930 $ 29,809,622 $ 23,123,555 Plan Fiduciary Net Position as a Percentage of the Total Pension Liability 47.90% 47.13% 49.27% 55.64% Covered Employee Payroll $ 5,417,619 $ 5,638,291 $ 5,565,214 $ 5,215,818 Net Pension Liability as a Percentage of covered Employee Payroll 624.82% 571.06% 535.64% 443.34% Notes to Schedule: ¹ The 2014 and 2015 results were provided by the prior actuary, Timothy W. Sharpe, Actuary, Geneva (IL). Changes of assumptions: For measurement date 12/31/2016, amounts reported as changes of assumptions resulted from the following assumption changes: 1. For healthy lives, the mortality rates were updated from the RP-2000 Blue Collar Mortality to the RP-2000 Blue Collar Mortality projected to the valuation date with Scale BB. 2. For disabled lives, the mortality rates were updated from the RP-2000 Disabled Mortality to the RP-2000 Disabled Mortality projected to the valuation date with Scale BB. City of DeKalb Police Pension Fund FOSTER & FOSTER | 36 GASB 67 SCHEDULE OF CONTRIBUTIONS Last 10 Fiscal Years 12/31/2016 06/30/2016 06/30/2015 ¹ 06/30/2014 ¹ Actuarially Determined Contribution 1,080,991 1,730,712 1,627,268 1,379,234 Contributions in Relation to the Actuarially Determined Contributions 2,085,233 1,622,105 1,448,949 1,352,291 Contribution Deficiency (Excess) $ (1,004,242) $ 108,607 $ 178,319 $ 26,943 Covered Employee Payroll $ 5,417,619 $ 5,638,291 $ 5,565,214 $ 5,215,818 Contributions as a Percentage of Covered Employee Payroll 38.49% 28.77% 26.04% 25.93% ¹ The 2014 and 2015 results were provided by the prior actuary, Timothy W. Sharpe, Actuary, Geneva (IL). Notes to Schedule Valuation Date: 07/01/2015 07/01/2014 07/01/2013 07/01/2012 Actuarially determined contribution is calculated as of December 31 of two fiscal years prior to the year in which contributions are reported. Methods and assumptions used to determine contribution rates: Funding Method: Entry Age Normal. Amortization Method: Level percentage of pay, closed. Remaining Amortization Period: 26 Years (as of 7/1/2015). Actuarial Asset Method: Assets are valued with an adjustment made to expected assets to uniformly spread actuarial investment gains and losses (as measured by actual market value investment return against expected market value investment return) over a five-year period. Inflation: 2.50% per year. Salary Increases: 4.50% per year. Payroll Growth: 4.50% per year. Interest Rate: 7.50% per year compounded annually, net of investment related expenses. Retirement Rates: See Table Below. Termination Rates: See Table Below. Disability Rates: See Table Below. It is assumed that 70% of Disability Retirements and 5% of Pre-Retirement Deaths are service-related. Mortality: RP 2000 Mortality Table (CHBCA). There is no margin for future mortality improvement beyond the valuation date. City of DeKalb Police Pension Fund FOSTER & FOSTER | 37 GASB 67 Other Information: Termination and Disability Rate Table. % % Becoming Disabled During Age Terminating the Year 20 10.00% 0.05% 30 5.00% 0.22% 40 2.00% 0.40% 50 3.50% 0.95% Retirement Rate Table. % Retiring During the Age Year 50-54 20.00% 55-59 25.00% 60-62 33.00% 63-69 50.00% 70 100.00% City of DeKalb Police Pension Fund FOSTER & FOSTER | 38 GASB 67 SCHEDULE OF INVESTMENT RETURNS Last 10 Fiscal Years 12/31/2016 06/30/2016 06/30/2015 06/30/2014 Annual Money-Weighted Rate of Return Net of Investment Expense N/A 0.10% 1.05% 12.36% City of DeKalb Police Pension Fund FOSTER & FOSTER | 39 GASB 68 NOTES TO THE FINANCIAL STATEMENTS (For the Year Ended December 31, 2016) General Information about the Pension Plan Plan Administration The Plan is administered by a Board of Trustees comprised of: a.) Two members appointed by the City, b.) Two active Members of the Police Department elected by the Membership, and c.) One retired Member of the Police Department elected by the Membership. Plan Membership as of January 1, 2017: Inactive Plan Members or Beneficiaries Currently Receiving Benefits 51 Inactive Plan Members Entitled to but Not Yet Receiving Benefits 4 Active Plan Members 61 116 Benefits Provided The Plan provides retirement, termination, disability and death benefits. Normal Retirement: Age: Tier 1: Age 50 and 20 years of service. Tier 2: Age 55 with 10 years of service. Benefit: 2.50% of Average Final Compensation times Credited Service. Early Retirement: Age: Tier 1: Age 60 and 8 years of service. Tier 2: Age 50 with 10 years of service. Benefit: Determined as for Normal Retirement; Benefit for members hired after January 1, 2011 is reduced 6.00% for each year that Early Retirement precedes Normal Retirement. Vesting (Termination): Tier 1: Less than 8 years: Refund of accumulated contributions without interest. 8 or more: Refund of Contributions or accrued benefit payable at retirement age. Tier 2: Less than 10 years: Refund of accumulated contributions without interest. 10 or more: Refund of Contributions or accrued benefit payable at retirement age. Disability: Eligibility: Total and permanent as determined by the Board of Trustees. Benefit: Benefit accrued to date of disability. Minimum benefit for Service Incurred is 65% of AFC. For Non-Service Incurred benefit is 50% of Salary. Pre-Retirement Death Benefits: Service Incurred: 100% of Salary. Non-Service Incurred: Greater of 50% of salary or accrued benefit. Non-Vested: Refund of Required Contribution Account. City of DeKalb Police Pension Fund FOSTER & FOSTER | 40 GASB 68 Cost-of-Living Adjustments: Tier 1: Retirees - 3.00% per year upon attaining age 55. For retirements prior to age 55, 1/12 of 3.00% per month benefit commences prior to reaching age 55. Disabled Retirees - annual increase of 3.00% of the original benefit amount upon attaining age 60. For disablements prior to age 60, 3.00% of original benefit per year benefit commenced prior to age 60. Tier 2: An annual increase equal to the lesser of 3.00% per year or 1/2 the annual unadjusted percentage increase in the consumer price index-u for the 12 months ending with the September preceding each November 1 of the original pension after attaining age 60. Net Pension Liability The Sponsor's net pension liability was measured as of December 31, 2016. The total pension liability used to calculate the net pension liability was determined as of that date. Actuarial Assumptions: The total pension liability was determined by an actuarial valuation as of January 1, 2017 using the following actuarial assumptions applied to all measurement periods. Inflation 2.50% Salary Increases 4.50% Investment Rate of Return 7.50% Healthy Lives: RP-2000 Combined Healthy Mortality with a blue collar adjustment, projected to the valuation date with Scale BB. Disabled Lives: RP-2000 Disabled Retiree Mortality, projected to the valuation date with Scale BB. The demographic assumptions used in the January 1, 2017 valuation were based on the results of an actuarial experience study performed by the State of Illinois Department of Insurance. The long-term expected rate of return on pension plan investments could be determined using a building-block method in which best-estimate ranges of expected future real rates of return (expected returns, net of pension plan investment expenses and inflation) are developed for each major asset class. These ranges are combined to produce the long term expected rate of return by weighting the expected future real rates of return by the target asset allocation percentage and by adding expected inflation. Best estimates of arithmetic real rates of return for each major asset class included in the pension plan's target asset allocation as of December, 31 2016 are summarized in the following table: Long Term Expected Asset Class Target Allocation Real Rate of Return Cash 3.00% 0.00% Fixed Income 32.00% 2.19% Domestic Equities 40.30% 5.00% International Equities 22.75% 5.50% Commodities 1.95% 0.75% Total 100% City of DeKalb Police Pension Fund FOSTER & FOSTER | 41 GASB 68 Discount Rate: The discount rate used to measure the total pension liability was 7.50 percent. The projection of cash flows used to determine the discount rate assumed that plan member contributions will be made at the current contribution rate and that sponsor contributions will be made at rates equal to the difference between actuarially determined contribution rates and the member rate. Based on those assumptions, the pension plan's fiduciary net position was projected to be available to make all projected future benefit payments of current plan members. Therefore, the long-term expected rate of return on pension plan investments was applied to all periods of projected benefit payments to determine the total pension liability. City of DeKalb Police Pension Fund FOSTER & FOSTER | 42 GASB 68 CHANGES IN NET PENSION LIABILITY Increase (Decrease) Total Pension Plan Fiduciary Net Pension Liability Net Position Liability (a) (b) (a)-(b) Balances at June 30, 2016 $ 60,897,865 $ 28,699,935 $ 32,197,930 Changes for a Year: Service Cost 581,851 581,851 Interest 2,278,348 2,278,348 Differences Between Expected and Actual Experience (30,834) (30,834) Changes of Assumptions 2,685,767 2,685,767 Changes of Benefit Terms - - Contributions - Employer 2,085,233 (2,085,233) Contributions - Employee 282,997 (282,997) Contributions - Buy Back 11,240 11,240 - Net Investment Income 1,516,374 (1,516,374) Benefit Payments, Including Refunds of Employee Contributions (1,447,549) (1,447,549) - Administrative Expense (21,998) 21,998 Other Changes - - - New Changes 4,078,823 2,426,297 1,652,526 Balances at December 31, 2016 $ 64,976,688 $ 31,126,232 $ 33,850,456 Sensitivity of the net pension liability to changes in the discount rate. Current Discount 1% Decrease Rate 1% Increase 6.50% 7.50% 8.50% Sponsor's Net Pension Liability $ 42,934,393 $ 33,850,456 $ 26,394,328 Pension plan fiduciary net position. Detailed information about the pension plan's fiduciary net position is available in a separately issued Plan financial report. City of DeKalb Police Pension Fund FOSTER & FOSTER | 43 GASB 68 PENSION EXPENSE AND DEFERRED OUTFLOWS OF RESOURCES AND DEFERRED INFLOWS OF RESOURCES RELATED TO PENSIONS For the year ended December 31, 2016, the Sponsor will recognize a pension expense of $1,817,444. On December 31, 2016, the Sponsor reported deferred outflows of resources and deferred inflows of resources related to pensions from the following sources: Deferred Deferred Outflows of Inflows of Resources Resources Differences Between Expected and Actual Experience - 764,477 Changes of Assumptions 2,461,953 - Net Difference Between Projected and Actual Earnings on Pension Plan Investments 1,120,161 - Total $ 3,582,114 $ 764,477 Amounts reported as deferred outflows of resources and deferred inflows of resources related to pensions will be recognized in pension expense as follows: OUTFLOW INFLOW Year ended December 31: 2017 $ 623,107 2018 $ 623,107 2019 $ 623,107 2020 $ 408,690 2021 $ 318,382 Thereafter $ 221,244 City of DeKalb Police Pension Fund FOSTER & FOSTER | 44 GASB 68 SCHEDULE OF CHANGES IN NET PENSION LIABILITY AND RELATED RATIOS Last 10 Fiscal Years 12/31/2016 06/30/2016 Total Pension Liability Service Cost 581,851 1,138,556 Interest 2,278,348 4,396,163 Changes of Benefit Terms - Differences Between Expected and Actual Experience (30,834) (981,619) Changes of Assumptions 2,685,767 - Contributions - Buy Back 11,240 157,490 Benefit Payments, Including Refunds of Employee Contributions (1,447,549) (2,579,348) Net Change in Total Pension Liability 4,078,823 2,131,242 Total Pension Liability - Beginning 60,897,865 58,766,623 Total Pension Liability - Ending (a) $ 64,976,688 $ 60,897,865 Plan Fiduciary Net Position Contributions - Employer 2,085,233 1,622,105 Contributions - Employee 282,997 570,363 Contributions - Buy Back 11,240 157,490 Net Investment Income 1,516,374 17,314 Benefit Payments, Including Refunds of Employee Contributions (1,447,549) (2,579,348) Administrative Expense (21,998) (44,990) Other - - Net Change in Plan Fiduciary Net Position 2,426,297 (257,066) Plan Fiduciary Net Position - Beginning 28,699,935 28,957,001 Plan Fiduciary Net Position - Ending (b) $ 31,126,232 $ 28,699,935 Net Pension Liability - Ending (a) - (b) $ 33,850,456 $ 32,197,930 Plan Fiduciary Net Position as a Percentage of the Total Pension Liability 47.90% 47.13% Covered Employee Payroll $ 5,417,619 $ 5,638,291 Net Pension Liability as a Percentage of covered Employee Payroll 624.82% 571.06% Notes to Schedule: Changes of assumptions: For measurement date 12/31/2016, amounts reported as changes of assumptions resulted from the following assumption changes: 1. For healthy lives, the mortality rates were updated from the RP-2000 Blue Collar Mortality to the RP-2000 Blue Collar Mortality projected to the valuation date with Scale BB. 2. For disabled lives, the mortality rates were updated from the RP-2000 Disabled Mortality to the RP-2000 Disabled Mortality projected to the valuation date with Scale BB. City of DeKalb Police Pension Fund FOSTER & FOSTER | 45 GASB 68 SCHEDULE OF CONTRIBUTIONS Last 10 Fiscal Years 12/31/2016 06/30/2016 Actuarially Determined Contribution 1,080,991 1,730,712 Contributions in Relation to the Actuarially Determined Contributions 2,085,233 1,622,105 Contribution Deficiency (Excess) $ (1,004,242) $ 108,607 Covered Employee Payroll $ 5,417,619 $ 5,638,291 Contributions as a Percentage of Covered Employee Payroll 38.49% 28.77% Notes to Schedule Valuation Date: 07/01/2015 07/01/2014 Actuarially determined contribution is calculated as of December 31 of two fiscal years prior to the year in which contributions are reported. Methods and assumptions used to determine contribution rates: Funding Method: Entry Age Normal. Amortization Method: Level percentage of pay, closed. Remaining Amortization Period: 26 Years (as of 7/1/2015). Actuarial Asset Method: Assets are valued with an adjustment made to expected assets to uniformly spread actuarial investment gains and losses (as measured by actual market value investment return against expected market value investment return) over a five-year period. Inflation: 2.50% per year. Salary Increases: 4.50% per year. Payroll Growth: 4.50% per year. Interest Rate: 7.50% per year compounded annually, net of investment related expenses. Retirement Rates: See Table Below. Termination Rates: See Table Below. Disability Rates: See Table Below. It is assumed that 70% of Disability Retirements and 5% of Pre-Retirement Deaths are service-related. Mortality: RP 2000 Mortality Table (CHBCA). There is no margin for future mortality improvement beyond the valuation date. City of DeKalb Police Pension Fund FOSTER & FOSTER | 46 GASB 68 Other Information: Termination and Disability Rate Table. % Terminating % Becoming Disabled During Age During the Year the Year 20 10.00% 0.05% 30 5.00% 0.22% 40 2.00% 0.40% 50 3.50% 0.95% Retirement Rate Table. % Retiring During Age the Year 50-54 20.00% 55-59 25.00% 60-62 33.00% 63-69 50.00% 70 100.00% City of DeKalb Police Pension Fund FOSTER & FOSTER | 47 GASB 68 COMPONENTS OF PENSION EXPENSE FISCAL YEAR DECEMBER 31, 2016 Net Pension Deferred Deferred Liability Inflows Outflows Pension Expense Beginning Balance $ 32,197,930 $ 818,015 $ 1,715,337 Total Pension Liability Factors: Service Cost 581,851 581,851 Interest 2,278,348 2,278,348 Changes in Benefit Terms - - Contributions - Buy Back 11,240 11,240 Differences Between Expected and Actual Experience With Regard to Economic or Demographic Assumptions (30,834) 30,834 - Current Year Amortization (84,372) - (84,372) Changes in Assumptions About Future Economic or Demographic Factors or Other Inputs 2,685,767 - 2,685,767 Current Year Amortization - (223,814) 223,814 Benefit Payments (1,447,549) (1,447,549) Net Change 4,078,823 (53,538) 2,461,953 1,563,332 Plan Fiduciary Net Position: Contributions - Employer 2,085,233 Contributions - Employee 282,997 (282,997) Contributions - Buy Back 11,240 (11,240) Net Investment Income 1,093,309 (1,093,309) Difference Between Projected and Actual Earnings on Pension Plan Investments 423,065 423,065 - Current Year Amortization (42,307) (214,418) 172,111 Benefit Payments (1,447,549) 1,447,549 Administrative Expenses (21,998) 21,998 Other - - Net Change 2,426,297 380,758 (214,418) 254,112 Ending Balance $ 33,850,456 $ 1,145,235 $ 3,962,872 $ 1,817,444 City of DeKalb Police Pension Fund FOSTER & FOSTER | 48 GASB 68 AMORTIZATION SCHEDULE - EXPERIENCE Increase (Decrease) in Pension Expense Arising from the Recognition of the Effects of Differences between Expected and Actual Experience Differences Between Expected and Recognition Year Base Actual Period Established Experience (Years) 2016 2017 2018 2019 2020 2021 2022 2023 2016 $ (30,834) 6 $ (2,570) $ (5,139) $ (5,139) $ (5,139) $ (5,139) $ (5,139) $ (2,569) $ - 2015 $ (981,619) 6 $ (81,802) $ (163,603) $ (163,603) $ (163,603) $ (163,603) $ (81,801) $ - $ - Net Increase (Decrease) in Pension Expense $ (84,372) $ (168,742) $ (168,742) $ (168,742) $ (168,742) $ (86,940) $ (2,569) $ - City of DeKalb Police Pension Fund FOSTER & FOSTER | 49 GASB 68 AMORTIZATION SCHEDULE - CHANGES OF ASSUMPTIONS Increase (Decrease) in Pension Expense Arising from the Recognition of the Effects of Changes of Assumptions Recognition Year Base Change of Period Established Assumptions (Years) 2016 2017 2018 2019 2020 2021 2022 2023 2016 $ 2,685,767 6 $ 223,814 $ 447,628 $ 447,628 $ 447,628 $ 447,628 $ 447,628 $ 223,813 $ - 2015 $ - 6 $ - $ - $ - $ - $ - $ - $ - $ - Net Increase (Decrease) in Pension Expense $ 223,814 $ 447,628 $ 447,628 $ 447,628 $ 447,628 $ 447,628 $ 223,813 $ - City of DeKalb Police Pension Fund FOSTER & FOSTER | 50 GASB 68 AMORTIZATION SCHEDULE - INVESTMENTS Increase (Decrease) in Pension Expense Arising from the Recognition of the of Differences Between Projected and Actual Earnings on Pension Plan Investments Differences Between Year Base Projected and Actual Recognition Established Earnings Period (Years) 2016 2017 2018 2019 2020 2021 2022 2016 $ (423,065) 5 $ (42,307) $ (84,613) $ (84,613) $ (84,613) $ (84,613) $ (42,306) $ - 2015 $ 2,144,172 5 $ 214,418 $ 428,834 $ 428,834 $ 428,834 $ 214,417 $ - $ - Net Increase (Decrease) in Pension Expense $ 172,111 $ 344,221 $ 344,221 $ 344,221 $ 129,804 $ (42,306) $ - City of DeKalb Police Pension Fund FOSTER & FOSTER | 51  CITY OF DEKALB FIREFIGHTERS’ PENSION FUND ACTUARIAL VALUATION AS OF JANUARY 1, 2017 CONTRIBUTIONS APPLICABLE TO THE PLAN/FISCAL YEAR ENDING DECEMBER 31, 2018 GASB 67/68 DISCLOSURE INFORMATION AS OF DECEMBER 31, 2016  May 1, 2017 City of DeKalb c/o Robert Miller, Assistant Finance Director 200 South Fourth Street DeKalb, IL 60115 Re: Actuarial Valuation Report (including GASB Statements No. 67 and No. 68) – City of DeKalb Fire Pension Fund Dear Mr. Miller: We are pleased to present to the City this report of the annual actuarial valuation of the City of DeKalb Fire Pension Fund. Included are the related results for GASB Statements No. 67 and No. 68. The funding valuation was performed to determine whether the assets and contributions are sufficient to provide the prescribed benefits and to develop the appropriate funding requirements for the applicable plan year. The calculation of the liability for GASB results was performed for the purpose of satisfying the requirements of GASB Statements No. 67 and No. 68. Use of the results for other purposes may not be applicable and produce significantly different results. The valuations have been conducted in accordance with generally accepted actuarial principles and practices, including the applicable Actuarial Standards of Practice as issued by the Actuarial Standards Board, and reflects laws and regulations issued to date pursuant to the provisions of Article 4, Illinois Pension Code, as well as applicable federal laws and regulations. In our opinion, the assumptions used in this valuation, as adopted by the Board of Trustees, represent reasonable expectations of anticipated plan experience. Future actuarial measurements may differ significantly from the current measurements presented in this report for a variety of reasons including: changes in applicable laws, changes in plan provisions, changes in assumptions, or plan experience differing from expectations. In conducting the valuation, we have relied on personnel, plan design, and asset information supplied by the City, financial reports prepared by the custodian bank and the actuarial assumptions and methods described in the Actuarial Assumptions section of this report. While we cannot verify the accuracy of all this information, the supplied information was reviewed for consistency and reasonableness. As a result of this review, we have no reason to doubt the substantial accuracy of the information and believe that it has produced appropriate results. This information, along with any adjustments or modifications, is summarized in various sections of this report. The total pension liability, net pension liability, and certain sensitivity information shown in the GASB results are based on an actuarial valuation performed as of the valuation date. Certain schedules should include a 10-year history of information. As provided for in GASB Statements No. 67 and No.68, this historical information is only presented for the years in which the information was measured. This conforms to the requirements of GASB Statements No. 67 and No. 68. One Oakbrook Terrace, Suite 720 Oakbrook Terrace, IL 60181 · (630) 620-0200 · Fax (239) 481-0634 · www.foster-foster.com  The undersigned is familiar with the immediate and long-term aspects of pension valuations and meets the Qualification Standards of the American Academy of Actuaries necessary to render the actuarial opinions contained herein. All of the sections of this report are considered an integral part of the actuarial opinions. To our knowledge, no associate of Foster & Foster, Inc. working on valuations of the program has any direct financial interest or indirect material interest in the City of DeKalb, nor does anyone at Foster & Foster, Inc. act as a member of the Board of Trustees of City of DeKalb Fire Pension Fund. Thus, there is no relationship existing that might affect our capacity to prepare and certify this actuarial report. If there are any questions, concerns, or comments about any of the items contained in this report, please contact us at 630-620-0200. Respectfully submitted, Foster & Foster, Inc. By: ______________________________ Jason L. Franken Enrolled Actuary #17-6888 JLF/lke Enclosures  TABLE OF CONTENTS Section Title Page I Introduction a. Summary of Report 5 b. Changes Since Prior Valuation 7 c. Comparative Summary of Principal Valuation Results 8 II Valuation Information a. Development of Amortization Payment 14 b. Statutory Minimum Required Contribution 15 c. Projection of Benefit Payments 16 d. Actuarial Assumptions and Methods 17 e. Glossary 19 III Trust Fund 20 IV Member Statistics a. Statistical Data 24 b. Age and Service Distribution 25 c. Valuation Participant Reconciliation 26 V Summary of Current Plan 27 VI Governmental Accounting Standards Board Statements No. 67 and No. 68 Disclosure Information 30 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 4  SUMMARY OF REPORT The regular annual actuarial valuation of the City of DeKalb Firefighters’ Pension Fund, performed as of January 1, 2017, has been completed and the results are presented in this Report. The contribution amounts set forth herein are applicable to the plan/fiscal year ended December 31, 2018. The contribution requirements, compared with those set forth in the July 1, 2016 actuarial report, are as follows: Valuation Date 1/1/2017 7/1/2016 Applicable to Fiscal Year Ending 12/31/2018 6/30/2018 Total Required Contribution $3,646,756 $3,457,208 % of Projected Annual Payroll 74.5% 70.0% Member Contributions (Est.) 462,846 467,208 % of Projected Annual Payroll 9.5% 9.5% City Required Contribution 3,183,910 2,990,000 % of Projected Annual Payroll 65.0% 60.5% As you can see, the Total Required Contribution, when expressed as a percentage of annual payroll, shows an increase when compared to the results determined in the July 1, 2016 actuarial valuation report. The increase is primarily attributable to the projection of the mortality tables. The plan also had slightly unfavorable experience during the past 6 months. Unfavorable plan experience resulted from assets that earned a 6.27% investment return (Actuarial basis) which fell short of the 7.50% assumption. In addition, there were more active retirements than expected. There were no significant sources of plan gains. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 5 The balance of this Report presents additional details of the actuarial valuation and the general operation of the Fund. The undersigned would be pleased to meet with the City in order to discuss the Report and answer any pending questions concerning its contents. Respectfully submitted, FOSTER & FOSTER, INC. By: ______________________________ Jason L. Franken, FSA, EA, MAAA City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 6  Plan Changes Since Prior Valuation There have been no Plan changes since the prior valuation. Actuarial Assumption/Method Changes Since Prior Valuation The following assumptions have been changed since the prior valuation:  The mortality assumptions were updated to include a projection to the valuation date using Scale BB. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 7  COMPARATIVE SUMMARY OF PRINCIPAL VALUATION RESULTS New Assump Old Assump 1/1/2017 1/1/2017 7/1/2016 A. Participant Data Number Included Actives 55 55 57 Service Retirees 41 41 39 Beneficiaries 9 9 10 Disability Retirees 7 7 7 Terminated Vested 3 3 3 Total 115 115 116 Total Annual Payroll $4,895,248 $4,895,248 $4,941,381 Payroll Under Assumed Ret. Age 4,895,248 4,895,248 4,941,381 Annual Rate of Payments to: Service Retirees 2,720,884 2,720,884 2,581,348 Beneficiaries 222,144 222,144 240,058 Disability Retirees 364,485 364,485 364,485 Terminated Vested 0 0 0 B. Assets Actuarial Value 27,626,619 27,626,619 25,591,235 Market Value 26,144,516 26,144,516 23,471,471 C. Liabilities Present Value of Benefits Actives Retirement Benefits 27,537,371 26,721,247 27,441,873 Disability Benefits 3,693,626 3,588,912 3,615,029 Death Benefits 602,496 634,218 643,661 Vested Benefits 1,111,299 1,086,054 1,070,053 Service Retirees 37,646,661 35,830,766 33,821,243 Beneficiaries 1,995,112 1,909,531 1,993,212 Disability Retirees 5,036,564 4,839,974 4,817,677 Terminated Vested 4,420 4,420 4,420 Total 77,627,549 74,615,122 73,407,168 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 8  New Assump Old Assump C. Liabilities - (Continued) 1/1/2017 1/1/2017 7/1/2016 Present Value of Future Salaries 49,284,874 49,250,347 49,292,347 Present Value of Future Member Contributions 4,659,885 4,656,620 4,660,591 Normal Cost (Retirement) 803,514 779,736 801,284 Normal Cost (Disability) 210,732 206,232 208,844 Normal Cost (Death) 36,264 38,062 38,853 Normal Cost (Vesting) 62,351 61,153 59,986 Total Normal Cost 1,112,861 1,085,183 1,108,967 Present Value of Future Normal Costs 10,350,024 10,087,887 10,279,588 Accrued Liability (Retirement) 19,969,612 19,379,059 19,924,829 Accrued Liability (Disability) 1,676,241 1,614,994 1,630,509 Accrued Liability (Death) 267,555 283,068 286,658 Accrued Liability (Vesting) 681,360 665,423 649,032 Accrued Liability (Inactives) 44,682,757 42,584,691 40,636,552 Total Actuarial Accrued Liability 67,277,525 64,527,235 63,127,580 Unfunded Actuarial Accrued Liability (UAAL) 39,650,906 36,900,616 37,536,345 Funded Ratio (AVA / AL) 41.1% 42.8% 40.5% City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 9  New Assump Old Assump 1/1/2017 1/1/2017 7/1/2016 D. Actuarial Present Value of Accrued Benefits Vested Accrued Benefits Inactives 44,682,757 42,584,691 40,636,552 Actives 8,433,691 8,084,101 8,591,585 Member Contributions 4,501,882 4,501,882 4,547,865 Total 57,618,330 55,170,674 53,776,002 Non-vested Accrued Benefits 678,531 672,446 577,453 Total Present Value Accrued Benefits 58,296,861 55,843,120 54,353,455 Funded Ratio (MVA / PVAB) 44.8% 46.8% 43.2% Increase (Decrease) in Present Value of Accrued Benefits Attributable to: Plan Amendments 0 0 Assumption Changes 2,453,741 0 New Accrued Benefits 0 1,088,789 Benefits Paid 0 (1,607,243) Interest 0 2,008,119 Other 0 0 Total 2,453,741 1,489,665 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 10  New Assump Old Assump Valuation Date 1/1/2017 1/1/2017 7/1/2016 Applicable to Fiscal Year Ending 12/31/2018 12/31/2018 6/30/2018 E. Pension Cost Normal Cost (with interest) $1,196,326 $1,166,572 $1,192,140 % of Total Annual Payroll ¹ 24.4 23.8 24.1 Administrative Expenses (with interest) 37,711 37,711 44,734 % of Total Annual Payroll ¹ 0.8 0.8 0.9 Payment Required to Amortize Unfunded Actuarial Accrued Liability over 24 years (as of 1/1/2017, with interest) 2,412,719 2,245,366 2,220,334 % of Total Annual Payroll ¹ 49.3 45.9 45.0 Total Required Contribution 3,646,756 3,449,649 3,457,208 % of Total Annual Payroll ¹ 74.5 70.5 70.0 Expected Member Contributions 462,846 462,846 467,208 % of Total Annual Payroll ¹ 9.5 9.5 9.5 Expected City Contribution 3,183,910 2,986,803 2,990,000 % of Total Annual Payroll ¹ 65.0 61.0 60.5 F. Past Contributions Plan Years Ending: 12/31/2016 Total Required Contribution 1,488,993 City 1,312,560 Actual Contributions Made: Members (excluding buyback) 176,433 City 2,512,630 Total 2,689,063 G. Net Actuarial (Gain)/Loss 141,094 ¹ Contributions developed as of 1/1/2017 are expressed as a percentage of total annual payroll at 1/1/2017 of $4,895,248. ² Contributions are presented as a full annual contribution despite the short plan year. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 11 H. Schedule Illustrating the Amortization of the Total Unfunded Actuarial Accrued Liability as of: Projected Unfunded Year Accrued Liability 2017 39,650,906 2018 40,212,005 2019 40,706,613 2025 41,653,120 2030 38,131,157 2036 24,492,955 2041 0 I. (i) 3 Year Comparison of Actual and Assumed Salary Increases Actual Assumed Year Ended 12/31/2016 6.46% 4.50% Year Ended 6/30/2016 3.76% 4.50% Year Ended 6/30/2015 4.20% 4.50% (ii) 3 Year Comparison of Investment Return on Actuarial Value Actual Assumed Year Ended 12/31/2016 6.27% 7.50% Year Ended 6/30/2016 4.46% 7.50% Year Ended 6/30/2015 N/A N/A City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 12  STATEMENT BY ENROLLED ACTUARY This actuarial valuation was prepared and completed by me or under my direct supervision, and I acknowledge responsibility for the results. To the best of my knowledge, the results are complete and ac- curate, and in my opinion, the techniques and assumptions used are reasonable and meet the requirements and intent of the Illinois Pension Code and adhere to the Actuarial Standards of Practice. There is no ben- efit or expense to be provided by the plan and/or paid from the plan's assets for which liabilities or current costs have not been established or otherwise taken into account in the valuation. All known events or trends which may require a material increase in plan costs or required contribution rates have been taken into account in the valuation. ________________________ Jason L. Franken, FSA, EA, MAAA Enrolled Actuary #14-6888 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 13  DEVELOPMENT OF JANUARY 1, 2017 AMORTIZATION PAYMENT (1) Unfunded Actuarial Accrued Liability as of July 1, 2016 $37,536,345 (2) Sponsor Normal Cost developed as of July 1, 2016 320,880 (3) Expected administrative expenses for the year ended December 31, 2016 41,613 (4) Expected interest on (1), (2) and (3) 1,420,426 (5) Sponsor contributions to the System during the year ended December 31, 2016 2,512,630 (6) Expected interest on (5) 47,112 (7) Expected Unfunded Actuarial Accrued Liability as of December 31, 2016, (1)+(2)+(3)+(4)-(5)-(6) 36,759,522 (8) Change to UAAL due to Assumption Change 2,750,290 (9) Change to UAAL due to Actuarial (Gain)/Loss 141,094 (10) Unfunded Accrued Liability as of January 1, 2017 39,650,906 Date Years 1/1/2017 Amortization Established Remaining Amount Amount 1/1/2017 24 39,650,906 2,244,390 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 14  STATUTORY MINIMUM REQUIRED CONTRIBUTION Contribution requirements shown on this page are calculated according to statutory minimum funding requirements of the Illinois Pension Code. We do not believe this method is sufficient to fund future benefits; as such, we recommend funding according to the contributions developed in Section E of this report. New Assump Old Assump Valuation Date 1/1/2017 1/1/2017 7/1/2016 Applicable to Fiscal Year Ending 12/31/2018 12/31/2018 6/30/2018 Actuarial Accrued Liability (PUC) 65,549,373 62,882,180 61,454,373 Actuarial Value of Assets 27,626,619 27,626,619 25,591,235 Unfunded Actuarial Accrued Liability (UAAL) 37,922,754 35,255,561 35,863,138 UAAL Subject to Amortization 31,367,817 28,967,343 29,717,701 Normal Cost (with interest) $1,331,795 $1,296,595 1,326,601 % of Total Annual Payroll ¹ 27.2 26.5 26.8 Administrative Expenses (with interest) 37,711 37,711 44,734 % of Total Annual Payroll ¹ 0.8 0.8 0.9 Payment Required to Amortize Unfunded Actuarial Accrued Liability over 24 years (as of 1/1/2017, with interest) 1,908,701 1,762,635 1,757,849 % of Total Annual Payroll ¹ 39.0 36.0 35.6 Total Required Contribution 3,278,207 3,096,941 3,129,184 % of Total Annual Payroll ¹ 67.0 63.3 63.3 Expected Member Contributions 462,846 462,846 467,208 % of Total Annual Payroll ¹ 9.5 9.5 9.5 Expected City Contribution 2,815,361 2,634,095 2,661,976 % of Total Annual Payroll ¹ 57.5 53.8 53.8 Assumptions and Methods: Actuarial Cost Method Projected Unit Credit Amortization Method 90% Funding by 2040 All other assumptions and methods are as described in the Actuarial Assumptions and Methods section. ¹ Contributions developed as of 1/1/2017 are expressed as a percentage of total annual payroll at 1/1/2017 of $4,895,248. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 15  PROJECTION OF BENEFIT PAYMENTS Payments for Payments for Total Year Current Actives Current Inactives Payments 2017 104,181 3,279,705 3,383,886 2018 210,900 3,350,096 3,560,996 2019 333,306 3,410,101 3,743,407 2020 477,318 3,464,791 3,942,109 2021 619,897 3,539,818 4,159,715 2022 789,461 3,589,682 4,379,143 2023 959,680 3,635,138 4,594,818 2024 1,135,543 3,675,658 4,811,201 2025 1,355,829 3,711,463 5,067,292 2026 1,590,545 3,741,892 5,332,437 2027 1,834,797 3,766,304 5,601,101 2028 2,088,737 3,796,952 5,885,689 2029 2,367,889 3,808,117 6,176,006 2030 2,645,028 3,811,026 6,456,054 2031 2,910,609 3,804,792 6,715,401 2032 3,157,096 3,788,533 6,945,629 2033 3,426,754 3,761,286 7,188,040 2034 3,738,911 3,722,098 7,461,009 2035 4,014,452 3,670,092 7,684,544 2036 4,287,241 3,604,637 7,891,878 2037 4,557,672 3,525,405 8,083,077 2038 4,835,882 3,444,352 8,280,234 2039 5,099,198 3,338,402 8,437,600 2040 5,328,989 3,219,496 8,548,485 2041 5,562,298 3,088,701 8,650,999 2042 5,778,371 2,947,394 8,725,765 2043 6,008,158 2,797,441 8,805,599 2044 6,214,282 2,640,713 8,854,995 2045 6,383,262 2,479,123 8,862,385 2046 6,541,720 2,314,390 8,856,110 2047 6,675,117 2,148,136 8,823,253 2048 6,783,297 1,981,719 8,765,016 2049 6,872,696 1,816,567 8,689,263 2050 6,942,986 1,653,960 8,596,946 2051 6,996,211 1,494,613 8,490,824 2052 7,031,554 1,339,454 8,371,008 2053 7,047,685 1,189,719 8,237,404 2054 7,043,490 1,046,322 8,089,812 2055 7,017,641 910,254 7,927,895 2056 6,969,535 782,966 7,752,501 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 16  ACTUARIAL ASSUMPTIONS AND METHODS Mortality Rate RP-2000 Combined Healthy Mortality with a blue collar adjustment, projected to the valuation date with Scale BB. Disabled Mortality Rate RP-2000 Disabled Retiree Mortality, projected to the valuation date with Scale BB. Based on studies of public safety pension plans, we believe this assumption sufficiently accommodates expected future mortality improvements. Interest Rate 7.50% per year compounded annually, net of investment related expenses. We will continue to monitor this to ensure that the rate is supported by the target asset allocation and expected long- term returns. Retirement Age See table on following page. This is based on an experience study performed in 2012. Disability Rate See table on following page. 90% of the disabilities are assumed to be in the line of duty. This is based on an experience study performed in 2012. Termination Rate See table on following page. This is based on an experience study performed in 2012. Salary Increases 4.50% per year. Payroll Growth 4.50% per year. Inflation 2.50%. Cost-of-Living Adjustment Tier 1: 3.00% per year after age 55. Those that retire prior to age 55 receive an increase of 1/12 of 3.00% for each full month since benefit commencement upon reaching age 55. Tier 2: 1.25% per year after the later of attainment of age 60 or first anniversary of retirement. Administrative Expenses Expenses paid out of the fund other than investment-related expenses are assumed to be equal to those paid in the previous year. Marital Status 80% of Members are assumed to be married. Spouse’s Age Males are assumed to be three years older than females. Funding Method Entry Age Normal Cost Method. Actuarial Asset Method Investment gains and losses are smoothed over a 5-year period. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 17 Funding Policy Amortization Method The UAAL is amortized according to a Level Percentage of Payroll method over a period ending in 2041. The initial amortization amount is 100% of the Accrued Liability less the Actuarial Value of Assets. Decrement Tables % Terminating % Becoming Disabled % Retiring During the Year During the Year During the Year Age Rate Age Rate Age Rate 20 9.00% 20 0.10% 50 - 53 14.00% 25 5.00% 25 0.10% 54 - 59 20.00% 30 2.50% 30 0.20% 60 - 62 25.00% 35 2.00% 35 0.35% 63 - 64 33.00% 40 1.00% 40 0.50% 65 - 69 50.00% 45 1.00% 45 0.65% 70 100.00% 50 1.00% 50 1.00% 55 1.00% 55 1.50% 60 1.00% 60 3.00% 65 1.00% 65 4.25% City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 18  GLOSSARY Total Annual Payroll is the projected annual rate of pay for the fiscal year following the valuation date of all covered members. Present Value of Benefits is the single sum value on the valuation date of all future benefits to be paid to current Members, Retirees, Beneficiaries, Disability Retirees and Vested Terminations. Normal (Current Year's) Cost is the current year's cost for benefits yet to be funded. Unfunded Accrued Liability is a liability which arises when a pension plan is initially established or improved and such establishment or improvement is applicable to all years of past service. Total Required Contribution is equal to the Normal Cost plus an amount sufficient to amortize the Unfunded Accrued Liability over a period ending in 2041. The required amount is adjusted for interest according to the timing of contributions during the year. Entry Age Normal Cost Method - Under this method, the normal cost is the sum of the individual normal costs for all active participants. For an active participant, the normal cost is the participant’s normal cost accrual rate, multiplied by the participant’s current compensation. (a) The normal cost accrual rate equals: (i) the present value of future benefits for the participant, determined as of the participant’s entry age, divided by (ii) the present value of the compensation expected to be paid to the participant for each year of the participant’s anticipated future service, determined as of the participant’s entry age. (b) In calculating the present value of future compensation, the salary scale is applied both retrospectively and prospectively to estimate compensation in years prior to and subsequent to the valuation year based on the compensation used for the valuation. (c) The accrued liability is the sum of the individual accrued liabilities for all participants and beneficiaries. A participant’s accrued liability equals the present value, at the participant’s attained age, of future benefits less the present value at the participant’s attained age of the individual normal costs payable in the future. A beneficiary’s accrued liability equals the present value, at the beneficiary’s attained age, of future benefits. The unfunded accrued liability equals the total accrued liability less the actuarial value of assets. (d) Under this method, the entry age used for each active participant is the participant’s age at the time he or she would have commenced participation if the plan had always been in existence under current terms, or the age as of which he or she first earns service credits for purposes of benefit accrual under the current terms of the plan. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 19  STATEMENT OF FIDUCIARY NET POSITION December 31, 2016 ASSETS MARKET VALUE Cash and Cash Equivalents: Checking Account 965,000 Money Market 86,333 Total Cash and Equivalents 1,051,333 Receivables: City Contributions in Transit 354,040 Accrued Past Due Interest 49,716 Total Receivable 403,756 Investments: U.S. Gov't and Agency Obligations 8,150,076 Mutual Funds 16,547,291 Total Investments 24,697,367 Total Assets 26,152,456 LIABILITIES Liabilities: Payable: Expenses 7,940 Total Liabilities 7,940 Net Assets: Active and Retired Members' Equity 26,144,516 NET POSITION RESTRICTED FOR PENSIONS 26,144,516 TOTAL LIABILITIES AND NET ASSETS 26,152,456 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 20  STATEMENT OF CHANGES IN FIDUCIARY NET POSITION FOR THE YEAR ENDED December 31, 2016 Market Value Basis ADDITIONS Contributions: Member 257,245 Miscellaneous Member Revenue 80,812 City 2,512,630 Total Contributions 2,850,687 Investment Income: Net Realized Gain (Loss) (275,410) Unrealized Gain (Loss) 1,240,608 Net Increase in Fair Value of Investments 965,198 Interest & Dividends 503,412 Less Investment Expense ¹ (21,459) Net Investment Income 1,447,151 Total Additions 4,297,838 DEDUCTIONS Distributions to Members: Benefit Payments 1,607,243 Total Distributions 1,607,243 Administrative Expenses 17,540 Total Deductions 1,624,783 Net Increase in Net Position 2,673,055 NET POSITION RESTRICTED FOR PENSIONS Beginning of the Year 23,471,461 End of the Year 26,144,516 ¹ Investment Related expenses include investment advisory, custodial and performance monitoring fees. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 21  ACTUARIAL ASSET VALUATION December 31, 2016 Actuarial Assets for funding purposes are developed by recognizing the total actuarial investment gain or loss for each Plan Year over a five year period. In the first year, 20% of the gain or loss is recognized. In the second year 40%, in the third year 60%, in the fourth year 80%, and in the fifth year 100% of the gain or loss is recognized. The actuarial investment gain or loss is defined as the actual return on investments minus the actuarial assumed investment return. Actuarial Assets shall not be less than 80% nor greater than 120% of the Market Value of Assets. Gains/(Losses) Not Yet Recognized Plan Year Amounts Not Yet Recognized by Valuation Year Ending Gain/(Loss) 2017 2018 2019 2020 2021 6/30/2013 413,841 41,384 0 0 0 0 6/30/2014 1,484,434 445,330 148,443 0 0 0 6/30/2015 (1,710,469) (855,234) (513,141) (171,047) 0 0 6/30/2016 (2,212,531) (1,548,772) (1,106,265) (663,759) (221,253) 0 12/31/2016 543,986 435,189 326,392 217,594 108,797 0 Total (1,482,103) (1,144,571) (617,212) (112,456) 0 Development of Investment Gain/Loss Market Value of Assets, 6/30/2016 23,471,461 Contributions Less Benefit Payments & Administrative Expenses 1,225,904 Expected Investment Earnings¹ 903,165 Actual Net Investment Earnings 1,447,151 2017 Actuarial Investment Gain/(Loss) 543,986 ¹ Expected Investment Earnings = 7.50% x 1/2 x (23,471,461 + 0.5 x 1,225,904) Development of Actuarial Value of Assets Market Value of Assets, 12/31/2016 26,144,516 (Gains)/Losses Not Yet Recognized 1,482,103 Actuarial Value of Assets, 12/31/2016 27,626,619 (A) 6/30/2016 Actuarial Assets: 25,591,235 (I) Net Investment Income: 1. Interest and Dividends 503,412 2. Realized Gains (Losses) (275,410) 3. Change in Actuarial Value 602,937 4. Investment Expenses (21,459) Total 809,480 (B) 12/31/2016 Actuarial Assets: 27,626,619 Actuarial Asset Rate of Return = (2 x I) / (A + B - I) (Annualized): 6.27% Market Value of Assets Rate of Return (Annualized): 12.38% 12/31/2016 Limited Actuarial Assets: 27,626,619 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 22  CHANGES IN NET ASSETS AVAILABLE FOR BENEFITS December 31, 2016 Actuarial Asset Basis INCOME Contributions: Member 257,245 Miscellaneous Member Revenue 80,812 City 2,512,630 Total Contributions 2,850,687 Earnings from Investments Interest & Dividends 503,412 Net Realized Gain (Loss) (275,410) Change in Actuarial Value 602,937 Total Earnings and Investment Gains 830,939 EXPENSES Administrative Expenses: Investment Related ¹ 21,459 Other 17,540 Total Administrative Expenses 38,999 Distributions to Members: Benefit Payments 1,607,243 Total Distributions 1,607,243 Change in Net Assets for the Year 2,035,384 Net Assets Beginning of the Year 25,591,235 Net Assets End of the Year ² 27,626,619 ¹ Investment Related expenses include investment advisory, custodial and performance monitoring fees. ² Net Assets may be limited for actuarial consideration. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 23  STATISTICAL DATA ¹ 7/1/2014 7/1/2015 7/1/2016 1/1/2017 Actives - Tier 1 Number N/A 44 43 40 Average Current Age N/A 43.2 43.7 44.1 Average Age at Employment N/A 27.7 27.7 27.6 Average Past Service N/A 15.5 16.0 16.5 Average Annual Salary N/A $90,796 $92,340 $95,230 Actives - Tier 2 Number N/A 13 14 15 Average Current Age N/A 29.2 30.1 30.3 Average Age at Employment N/A 27.2 27.3 27.4 Average Past Service N/A 2.0 2.8 2.9 Average Annual Salary N/A $65,493 $69,340 $72,404 Service Retirees Number 39 38 39 41 Average Current Age N/A 65.5 66.1 66.0 Average Annual Benefit $60,312 $62,974 $66,188 $66,363 Beneficiaries Number 11 9 10 9 Average Current Age N/A 71.4 57.7 54.5 Average Annual Benefit $27,792 $28,294 $24,006 $24,683 Disability Retirees Number 6 6 7 7 Average Current Age N/A 57.3 55.5 56.0 Average Annual Benefit $51,899 $52,284 $52,069 $52,069 Terminated Vested Number 0 0 3 3 Average Current Age N/A N/A 38.8 39.3 Average Annual Benefit N/A N/A N/A N/A ² ¹ Foster & Foster does not have enough historical data to include complete data prior to 7/1/2016. We will add historical data going forward. ² Average Annual Benefit for Terminated Vested members reflects the benefit for members entitled to a future annual benefit from the plan. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 24  AGE AND SERVICE DISTRIBUTION PAST SERVICE AGE 0 1 2 3 4 5-9 10-14 15-19 20-24 25-29 30+ Total 15 - 19 0 0 0 0 0 0 0 0 0 0 0 0 20 - 24 0 0 0 0 0 0 0 0 0 0 0 0 25 - 29 2 0 1 2 1 1 0 0 0 0 0 7 30 - 34 0 0 0 5 1 4 1 0 0 0 0 11 35 - 39 0 0 0 0 2 1 3 1 0 0 0 7 40 - 44 0 0 0 0 0 1 7 4 0 0 0 12 45 - 49 0 0 0 0 0 0 1 2 6 0 0 9 50 - 54 0 0 0 0 0 0 1 0 4 3 0 8 55 - 59 0 0 0 0 0 0 0 0 1 0 0 1 60 - 64 0 0 0 0 0 0 0 0 0 0 0 0 65+ 0 0 0 0 0 0 0 0 0 0 0 0 Total 2 0 1 7 4 7 13 7 11 3 0 55 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 25  VALUATION PARTICIPANT RECONCILIATION 1. Active lives a. Number in prior valuation 7/1/2016 57 b. Terminations i. Vested (partial or full) with deferred benefits 0 ii. Non-vested or full lump sum distribution received 0 iii. Transferred service to other fund 0 c. Deaths i. Beneficiary receiving benefits 0 ii. No future benefits payable 0 d. Disabled 0 e. Retired (2) f. Continuing participants 55 g. New entrants 0 h. Total active life participants in valuation 55 2. Non-Active lives (including beneficiaries receiving benefits) Service Retirees, Vested Receiving Receiving Receiving Death Disability Vested Benefits Benefits Benefits Deferred Total a. Number prior valuation 39 10 7 3 59 Retired 2 0 0 0 2 Vested Deferred 0 0 0 0 0 Death, With Survivor 0 0 0 0 0 Death, No Survivor 0 (1) 0 0 (1) Disabled 0 0 0 0 0 Refund of Contributions 0 0 0 0 0 Rehires 0 0 0 0 0 Expired Annuities 0 0 0 0 0 Data Corrections 0 0 0 0 0 Hired/Termed in Same Year 0 0 0 0 0 b. Number current valuation 41 9 7 3 60 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 26  SUMMARY OF CURRENT PLAN Article 4 Pension Fund The Plan is established and administered as prescribed by “Article 4. Firefighters’ Pension Fund – Municipalities 500,000 and Under” of the Illinois Pension Code. Plan Administration The Plan is administered by a Board of Trustees comprised of: a) Two members appointed by the Municipality, b) Two active Members of the Fire Department elected by the Membership, and c) One retired Member of the Fire Department elected by the Membership. Credited Service Years and fractional parts of years of service (except as noted below) as a sworn Firefighter employed by the Municipality. Salary Annual salary, including longevity, attached to firefighter’s rank, as established by the municipality appropriation ordinance, excluding overtime pay, bonus pay and holiday pay except for the base 8 hours of the 10 pensionable holidays which is included. Normal Retirement Date Tier 1: Age 50 and 20 years of Credited Service. Tier 2: Age 55 and 10 years of service. Benefit Tier 1: 50% of annual salary attached to rank on last day of service plus 2.50% of annual salary for each year of service over 20 years, up to a maximum of 75% of salary. The minimum monthly benefit is $1,159.27 per month. Tier 2: 2.50% per year of service times the average salary for the eight consecutive years prior to retirement times the number of years of service, up to a maximum of 75% of average salary. The minimum monthly benefit is $1,159.27 per month. Form of Benefit Tier 1: For married retirees, an annuity payable for the life of the Member; upon the death of the member, 100% of the Member’s benefit payable to the spouse until death. For unmarried retirees, the normal form is a Single Life Annuity. Tier 2: Same as above, but with 66 2/3% of benefit continued to spouse. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 27 Early Retirement Date Tier 1: Age 60 and 10 years of Credited Service. Tier 2: Age 50 and 10 years of service. Benefit Tier 1: 1.5% plus 0.1% for each year of service in excess of 10 years, times salary x service (complete years). Tier 2: Normal Retirement Benefit, reduced 6% for each year before age 55, with no minimum benefit. Form of Benefit Same as Normal Retirement Disability Benefit Eligibility Total and permanent as determined by the Board of Trustees. Seven years of service required for non-service connected disability. Benefit Amount A maximum of: a.) 65% of salary attached to the rank held by Member on last day of service, and; b.) The monthly retirement pension that the Member is entitled to receive if he or she retired immediately. For non-service connected disabilities, a benefit of 50% of salary attached to rank held by Member on last day of service. Cost-of-Living Adjustment Tier 1: Retirees: An annual increase equal to 3.00% per year after age 55. Those that retire prior to age 55 receive an increase of 1/12 of 3.00% for each full month since benefit commencement upon reaching age 55. Disabled Retirees: An annual increase equal to 3.00% per year of the original benefit amount beginning at age 60. Those that become disabled prior to age 60 receive an increase of 3.00% of the original benefit amount for each year since benefit commencement upon reaching age 60. Tier 2: An annual increase each January 1 equal to 3.00% per year or one-half of the annual unadjusted percentage increase in the consumer price index-u for the 12 months ending with the September preceding each November 1, whichever is less, of the original pension after the attainment of age 60 or first anniversary of pension start date whichever is later. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 28 Pre-Retirement Death Benefit Service Incurred 100% of salary attached to rank held by Member on last day of service. Non-Service Incurred A maximum of: a.) 54% of salary attached to the rank held by Member on last day of service, and; b.) The monthly retirement pension earned by the deceased Member at the time of death, regardless of whether death occurs before or after age 50. Vesting (Termination) Less than 10 years Refund of Member Contributions. 10 or more years Either the termination benefit, payable upon reaching age 60, provided contributions are not withdrawn, or a refund of member contributions. Benefit Based on the monthly salary attached to the Member’s rank at separation from service and equals: 1.50% plus 0.1% for each year of service in excess of 10 years, times salary x service (based on complete years). Contributions Employee 9.455% of Salary. Municipality Remaining amount necessary for payment of Normal (current year’s) Cost and amortization of the accrued past service liability. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 29 GASB 67 STATEMENT OF FIDUCIARY NET POSITION December 31, 2016 ASSETS MARKET VALUE Cash and Cash Equivalents: Checking Account 965,000 Money Market 86,333 Total Cash and Equivalents 1,051,333 Receivables: City Contributions in Transit 354,040 Accrued Past Due Interest 49,716 Total Receivable 403,756 Investments: U.S. Gov't and Agency Obligations 8,150,076 Mutual Funds 16,547,291 Total Investments 24,697,367 Total Assets 26,152,456 LIABILITIES Liabilities: Payable: Expenses 7,940 Total Liabilities 7,940 Net Assets: Active and Retired Members' Equity 26,144,516 NET POSITION RESTRICTED FOR PENSIONS 26,144,516 TOTAL LIABILITIES AND NET ASSETS 26,152,456 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 30 GASB 67 STATEMENT OF CHANGES IN FIDUCIARY NET POSITION FOR THE YEAR ENDED December 31, 2016 Market Value Basis ADDITIONS Contributions: Member 257,245 Miscellaneous Member Revenue 80,812 City 2,512,630 Total Contributions 2,850,687 Investment Income: Net Realized Gain (Loss) (275,410) Unrealized Gain (Loss) 1,240,608 Net Increase in Fair Value of Investments 965,198 Interest & Dividends 503,412 Less Investment Expense ¹ (21,459) Net Investment Income 1,447,151 Total Additions 4,297,838 DEDUCTIONS Distributions to Members: Benefit Payments 1,607,243 Total Distributions 1,607,243 Administrative Expenses 17,540 Total Deductions 1,624,783 Net Increase in Net Position 2,673,055 NET POSITION RESTRICTED FOR PENSIONS Beginning of the Year 23,471,461 End of the Year 26,144,516 ¹ Investment Related expenses include investment advisory, custodial and performance monitoring fees. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 31 GASB 67 NOTES TO THE FINANCIAL STATEMENTS (For the Year Ended December 31, 2016) Plan Description Plan Administration The Plan is administered by a Board of Trustees comprised of: a.) Two members appointed by the City, b.) Two active Members of the Fire Department elected by the Membership, and c.) One retired Member of the Fire Department elected by the Membership. Plan Membership as of January 1, 2017: Inactive Plan Members or Beneficiaries Currently Receiving Benefits 57 Inactive Plan Members Entitled to but Not Yet Receiving Benefits 3 Active Plan Members 55 115 Benefits Provided The Plan provides retirement, termination, disability and death benefits. Normal Retirement: Age: Tier 1: Age 50 and 20 years of service. Tier 2: Age 55 with 10 years of service. Benefit: 2.50% of Average Final Compensation times Credited Service. Early Retirement: Age: Tier 1: Age 60 and 10 years of service. Tier 2: Age 50 with 10 years of service. Benefit: Tier 1: 1.5% plus 0.1% for each year of service in excess of 10 years, times salary times service (complete years). Tier 2: Determined as for Normal Retirement; Benefit for members hired after January 1, 2011 is reduced 6.00% for each year before age 55, with no minimum benefit. Vesting (Termination): Less than 10 years: Refund of accumulated contributions without interest. 10 or more: Refund of Contributions or accrued benefit payable at retirement age. Disability: Eligibility: Total and permanent as determined by the Board of Trustees. Benefit: Benefit accrued to date of disability. Minimum benefit for Service Incurred is 65% of AFC. For Non- Service Incurred benefit is 50% of Salary. Pre-Retirement Death Benefits: Service Incurred: 100% of Salary. Non-Service Incurred: Greater of 54% of salary or accrued benefit. Non-Vested: Refund of Required Contribution Account. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 32 GASB 67 Cost-of-Living Adjustments: Tier 1: Retirees - 3.00% per year upon attaining age 55. For retirements prior to age 55, 1/12 of 3.00% per month benefit commences prior to reaching age 55. Disabled Retirees - annual increase of 3.00% of the original benefit amount upon attaining age 60. For disablements prior to age 60, 3.00% of original benefit per year benefit commenced prior to age 60. Tier 2: An annual increase equal to the lesser of 3.00% per year or 1/2 the annual unadjusted percentage increase in the consumer price index-u for the 12 months ending with the September preceding each November 1, of the original pension after attaining age 60. Contributions Remaining amount necessary for payment of Normal (current year’s) Cost and amortization of the accrued past service liability over a period ending in 2041. Investments Investment Policy: The following was the Board's adopted asset allocation policy as of December 31, 2016: Asset Class Target Allocation T Bill 1.00% Short Government/Credit 5.00% Intermediate Government 36.00% Large 5.00% Large Value 5.00% Mid Value 6.00% Small 7.00% Small Value 7.00% International Developed 4.00% International Value 7.00% International Small 7.00% Emerging Markets 8.00% REIT 2.00% Total 100.00% Concentrations: The Plan did not hold investments in any one organization that represent 5 percent or more of the Pension Plan's fiduciary net position. Rate of Return: For the year ended December 31, 2016, the annual money-weighted rate of return on Pension Plan investments, net of pension plan investment expense, was 5.93 percent. The money-weighted rate of return expresses investment performance, net of investment expense, adjusted for the changing amounts actually invested. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 33 GASB 67 NET PENSION LIABILITY OF THE SPONSOR The components of the net pension liability of the sponsor on December 31, 2016 were as follows: Total Pension Liability $ 66,944,654 Plan Fiduciary Net Position (26,144,516) Sponsor's Net Pension Liability $ 40,800,138 Plan Fiduciary Net Position as a percentage of Total Pension Liability 39.05% Actuarial Assumptions: The total pension liability was determined by an actuarial valuation as of January 1, 2017 using the following actuarial assumptions applied to all measurement periods. Inflation 2.50% Salary Increases 4.50% Investment Rate of Return 7.50% Healthy Lives: RP-2000 Combined Healthy Mortality with a blue collar adjustment, projected to the valuation date with Scale BB. Disabled Lives: RP-2000 Disabled Retiree Mortality, projected to the valuation date with Scale BB. The demographic assumptions used in the January 1, 2017 valuation were based on the results of an actuarial experience study performed by the State of Illinois Department of Insurance. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 34 GASB 67 The long-term expected rate of return on pension plan investments could be determined using a building-block method in which best-estimate ranges of expected future real rates of return (expected returns, net of pension plan investment expenses and inflation) are developed for each major asset class. These ranges are combined to produce the long term expected rate of return by weighting the expected future real rates of return by the target asset allocation percentage and by adding expected inflation. Best estimates of arithmetic real rates of return for each major asset class included in the pension plan's target asset allocation as of December 31, 2016 are summarized in the following table: Long Term Expected Real Rate Asset Class of Return T Bill 0.50% Short Government/Credit 2.00% Intermediate Government 2.00% Large 4.50% Large Value 5.00% Mid Value 5.00% Small 6.00% Small Value 7.00% International Developed 4.50% International Value 7.00% International Small 8.00% Emerging Markets 8.00% REIT 4.00% Discount Rate: The discount rate used to measure the total pension liability was 7.50 percent. The projection of cash flows used to determine the discount rate assumed that plan member contributions will be made at the current contribution rate and that sponsor contributions will be made at rates equal to the difference between actuarially determined contribution rates and the member rate. Based on those assumptions, the pension plan's fiduciary net position was projected to be available to make all projected future benefit payments of current plan members. Therefore, the long-term expected rate of return on pension plan investments was applied to all periods of projected benefit payments to determine the total pension liability. Current Discount 1% Decrease Rate 1% Increase 6.50% 7.50% 8.50% Sponsor's Net Pension Liability $ 49,829,787 $ 40,800,138 $ 33,370,795 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 35 GASB 67 SCHEDULE OF CHANGES IN NET PENSION LIABILITY AND RELATED RATIOS Last 10 Fiscal Years 12/31/2016 06/30/2016 06/30/2015 ¹ 06/30/2014 ¹ Total Pension Liability Service Cost 560,373 1,103,489 1,077,550 1,033,286 Interest 2,345,602 4,495,233 4,102,276 3,857,132 Changes of Benefit Terms - - - - Differences Between Expected and Actual Experience 26,697 (102,841) (477,382) 1,330,700 Changes of Assumptions 2,745,788 - 2,460,941 - Contributions - Buy Back 80,812 - - - Benefit Payments, Including Refunds of Employee Contributions (1,607,243) (3,072,413) (2,982,470) (2,922,598) Net Change in Total Pension Liability 4,152,029 2,423,468 4,180,915 3,298,520 Total Pension Liability - Beginning 62,792,625 60,369,157 56,188,242 52,889,722 Total Pension Liability - Ending (a) $ 66,944,654 $ 62,792,625 $ 60,369,157 $ 56,188,242 Plan Fiduciary Net Position Contributions - Employer 2,512,630 2,158,166 2,024,522 2,037,490 Contributions - Employee 257,245 477,022 466,475 420,534 Contributions - Buy Back 80,812 - - - Net Investment Income 1,447,151 (403,920) 126,661 3,075,655 Benefit Payments, Including Refunds of Employee Contributions (1,607,243) (3,072,413) (2,982,470) (2,922,598) Administrative Expense (17,540) (41,613) (43,547) (34,562) Other - - - - Net Change in Plan Fiduciary Net Position 2,673,055 (882,758) (408,359) 2,576,519 Plan Fiduciary Net Position - Beginning 23,471,461 24,354,229 24,762,588 22,186,069 Plan Fiduciary Net Position - Ending (b) $ 26,144,516 $ 23,471,471 $ 24,354,229 $ 24,762,588 Net Pension Liability - Ending (a) - (b) $ 40,800,138 $ 39,321,154 $ 36,014,928 $ 31,425,654 Plan Fiduciary Net Position as a Percentage of the Total Pension Liability 39.05% 37.38% 40.34% 44.07% Covered Employee Payroll $ 4,895,248 $ 4,941,381 $ 4,846,412 $ 4,649,060 Net Pension Liability as a Percentage of covered Employee Payroll 833.46% 795.75% 743.13% 675.96% Notes to Schedule: ¹ The 2014 and 2015 results were provided by the prior actuary, Timothy W. Sharpe, Actuary, Geneva (IL). Changes of assumptions: For measurement date 12/31/2016, amounts reported as changes of assumptions resulted from the following assumption changes: 1. For healthy lives, the mortality rates were updated from the RP-2000 Blue Collar Mortality to the RP-2000 Blue Collar Mortality projected to the valuation date with Scale BB. 2. For disabled lives, the mortality rates were updated from the RP-2000 Disabled Mortality to the RP-2000 Disabled Mortality projected to the valuation date with Scale BB. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 36 GASB 67 SCHEDULE OF CONTRIBUTIONS Last 10 Fiscal Years 12/31/2016 06/30/2016 06/30/2015 ¹ 06/30/2014 ¹ Actuarially Determined Contribution 1,312,560 2,373,253 2,250,772 2,078,061 Contributions in Relation to the Actuarially Determined Contributions 2,512,630 2,158,166 2,024,522 2,037,490 Contribution Deficiency (Excess) $ (1,200,070) $ 215,087 $ 226,250 $ 40,571 Covered Employee Payroll $ 4,895,248 $ 4,941,381 $ 4,846,412 $ 4,649,060 Contributions as a Percentage of Covered Employee Payroll 51.33% 43.68% 41.77% 43.83% ¹ The 2014 and 2015 results were provided by the prior actuary, Timothy W. Sharpe, Actuary, Geneva (IL). Notes to Schedule Valuation Date: 07/01/2015 07/01/2014 07/01/2013 07/01/2012 Actuarially determined contribution is calculated as of December 31 of two fiscal years prior to the year in which contributions are reported. Methods and assumptions used to determine contribution rates: Funding Method: Entry Age Normal. Amortization Method: Level percentage of pay, closed. Remaining Amortization Period: 26 Years (as of 7/1/2015). Actuarial Asset Method: 5-year Average Market Value (PA 096-1495). Inflation: 2.50% per year. Salary Increases: 4.50% per year. Payroll Growth: 4.50% per year. Interest Rate: 7.50% per year compounded annually, net of investment related expenses. Retirement Rates: See Table Below. Termination Rates: See Table Below. Disability Rates: See Table Below. It is assumed that 70% of Disability Retirements and 5% of Pre-Retirement Deaths are service-related. Mortality: RP 2000 Mortality Table (CHBCA). There is no margin for future mortality improvement beyond the valuation date. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 37 GASB 67 Sample Annual Rates Per 100 Participants: Age Mortality Withdrawal Disability Retirement 20 0.03 9.00 0.10 25 0.04 5.00 0.10 30 0.07 2.50 0.20 35 0.11 2.00 0.35 40 0.14 1.00 0.50 45 0.18 1.00 0.64 50 0.24 1.00 1.00 14.00 55 0.42 1.00 1.50 20.00 60 0.83 1.00 3.00 25.00 65 1.55 1.00 4.25 50.00 70 2.68 100.00 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 38 GASB 67 SCHEDULE OF INVESTMENT RETURNS Last 10 Fiscal Years 12/31/2016 06/30/2016 06/30/2015 06/30/2014 Annual Money-Weighted Rate of Return Net of Investment Expense 5.93% -1.53% 0.73% 13.67% City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 39 GASB 68 NOTES TO THE FINANCIAL STATEMENTS (For the Year Ended December 31, 2016) General Information about the Pension Plan Plan Administration The Plan is administered by a Board of Trustees comprised of: a.) Two members appointed by the City, b.) Two active Members of the Fire Department elected by the Membership, and c.) One retired Member of the Fire Department elected by the Membership. Plan Membership as of January 1, 2017: Inactive Plan Members or Beneficiaries Currently Receiving Benefits 57 Inactive Plan Members Entitled to but Not Yet Receiving Benefits 3 Active Plan Members 55 115 Benefits Provided The Plan provides retirement, termination, disability and death benefits. Normal Retirement: Age: Tier 1: Age 50 and 20 years of service. Tier 2: Age 55 with 10 years of service. Benefit: 2.50% of Average Final Compensation times Credited Service. Early Retirement: Age: Tier 1: Age 60 and 10 years of service. Tier 2: Age 50 with 10 years of service. Benefit: Tier 1: 1.5% plus 0.1% for each year of service in excess of 10 years, times salary times service (complete years). Tier 2: Determined as for Normal Retirement; Benefit for members hired after January 1, 2011 is reduced 6.00% for each year before age 55, with no minimum benefit. Vesting (Termination): Less than 10 years: Refund of accumulated contributions without interest. 10 or more: Refund of Contributions or accrued benefit payable at retirement age. Disability: Eligibility: Total and permanent as determined by the Board of Trustees. Benefit: Benefit accrued to date of disability. Minimum benefit for Service Incurred is 65% of AFC. For Non- Service Incurred benefit is 50% of Salary. Pre-Retirement Death Benefits: Service Incurred: 100% of Salary. Non-Service Incurred: Greater of 54% of salary or accrued benefit. Non-Vested: Refund of Required Contribution Account. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 40 GASB 68 Cost-of-Living Adjustments: Tier 1: Retirees - 3.00% per year upon attaining age 55. For retirements prior to age 55, 1/12 of 3.00% per month benefit commences prior to reaching age 55. Disabled Retirees - annual increase of 3.00% of the original benefit amount upon attaining age 60. For disablements prior to age 60, 3.00% of original benefit per year benefit commenced prior to age 60. Tier 2: An annual increase equal to the lesser of 3.00% per year or 1/2 the annual unadjusted percentage increase in the consumer price index-u for the 12 months ending with the September preceding each November 1, of the original pension after attaining age 60. Contributions Remaining amount necessary for payment of Normal (current year’s) Cost and amortization of the accrued past service liability over a period ending in 2041. Net Pension Liability The Sponsor's net pension liability was measured as of December 31, 2016. The total pension liability used to calculate the net pension liability was determined as of that date. Actuarial Assumptions: The total pension liability was determined by an actuarial valuation as of January 1, 2017 using the following actuarial assumptions applied to all measurement periods. Inflation 2.50% Salary Increases 4.50% Investment Rate of Return 7.50% Healthy Lives: RP-2000 Combined Healthy Mortality with a blue collar adjustment, projected to the valuation date with Scale BB. Disabled Lives: RP-2000 Disabled Retiree Mortality, projected to the valuation date with Scale BB. The demographic assumptions used in the January 1, 2017 valuation were based on the results of an actuarial experience study performed by the State of Illinois Department of Insurance. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 41 GASB 68 The long-term expected rate of return on pension plan investments could be determined using a building-block method in which best-estimate ranges of expected future real rates of return (expected returns, net of pension plan investment expenses and inflation) are developed for each major asset class. These ranges are combined to produce the long term expected rate of return by weighting the expected future real rates of return by the target asset allocation percentage and by adding expected inflation. Best estimates of arithmetic real rates of return for each major asset class included in the pension plan's target asset allocation as of December, 31 2016 are summarized in the following table: Long Term Expected Asset Class Target Allocation Real Rate of Return T Bill 1.00% 0.50% Short Government/Credit 5.00% 2.00% Intermediate Government 36.00% 2.00% Large 5.00% 4.50% Large Value 5.00% 5.00% Mid Value 6.00% 5.00% Small 7.00% 6.00% Small Value 7.00% 7.00% International Developed 4.00% 4.50% International Value 7.00% 7.00% International Small 7.00% 8.00% Emerging Markets 8.00% 8.00% REIT 2.00% 4.00% Total 100.00% Discount Rate: The discount rate used to measure the total pension liability was 7.50 percent. The projection of cash flows used to determine the discount rate assumed that plan member contributions will be made at the current contribution rate and that sponsor contributions will be made at rates equal to the difference between actuarially determined contribution rates and the member rate. Based on those assumptions, the pension plan's fiduciary net position was projected to be available to make all projected future benefit payments of current plan members. Therefore, the long-term expected rate of return on pension plan investments was applied to all periods of projected benefit payments to determine the total pension liability. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 42 GASB 68 CHANGES IN NET PENSION LIABILITY Increase (Decrease) Total Pension Plan Fiduciary Net Pension Liability Net Position Liability (a) (b) (a)-(b) Balances at June 30, 2016 $ 62,792,625 $ 23,471,461 $ 39,321,164 Changes for a Year: Service Cost 560,373 560,373 Interest 2,345,602 2,345,602 Differences Between Expected and Actual Experience 26,697 26,697 Changes of Assumptions 2,745,788 2,745,788 Changes of Benefit Terms - - Contributions - Employer 2,512,630 (2,512,630) Contributions - Employee 257,245 (257,245) Contributions - Buy Back 80,812 80,812 - Net Investment Income 1,447,151 (1,447,151) Benefit Payments, Including Refunds of Employee Contributions (1,607,243) (1,607,243) - Administrative Expense (17,540) 17,540 Other Changes - - - New Changes 4,152,029 2,673,055 1,478,974 Balances at December 31, 2016 $ 66,944,654 $ 26,144,516 $ 40,800,138 Sensitivity of the net pension liability to changes in the discount rate. Current Discount 1% Decrease Rate 1% Increase 6.50% 7.50% 8.50% Sponsor's Net Pension Liability $ 49,829,787 $ 40,800,138 $ 33,370,795 Pension plan fiduciary net position. Detailed information about the pension plan's fiduciary net position is available in a separately issued Plan financial report. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 43 GASB 68 PENSION EXPENSE AND DEFERRED OUTFLOWS OF RESOURCES AND DEFERRED INFLOWS OF RESOURCES RELATED TO PENSIONS For the year ended December 31, 2016, the Sponsor will recognize a pension expense of $2,152,429. On December 31, 2016, the Sponsor reported deferred outflows of resources and deferred inflows of resources related to pensions from the following sources: Deferred Deferred Outflows of Inflows of Resources Resources Differences Between Expected and Actual Experience 24,473 77,130 Changes of Assumptions 2,516,972 - Net Difference Between Projected and Actual Earnings on Pension Plan Investments 1,059,184 - Total $ 3,600,629 $ 77,130 Amounts reported as deferred outflows of resources and deferred inflows of resources related to pensions will be recognized in pension expense as follows: OUTFLOW INFLOW Year ended December 31: 2017 $ 778,650 2018 $ 778,650 2019 $ 778,650 2020 $ 557,397 2021 $ 399,112 Thereafter $ 231,040 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 44 GASB 68 SCHEDULE OF CHANGES IN NET PENSION LIABILITY AND RELATED RATIOS Last 10 Fiscal Years 12/31/2016 06/30/2016 Total Pension Liability Service Cost 560,373 1,103,489 Interest 2,345,602 4,495,233 Changes of Benefit Terms - Differences Between Expected and Actual Experience 26,697 (102,841) Changes of Assumptions 2,745,788 - Contributions - Buy Back 80,812 - Benefit Payments, Including Refunds of Employee Contributions (1,607,243) (3,072,413) Net Change in Total Pension Liability 4,152,029 2,423,468 Total Pension Liability - Beginning 62,792,625 60,369,157 Total Pension Liability - Ending (a) $ 66,944,654 $ 62,792,625 Plan Fiduciary Net Position Contributions - Employer 2,512,630 2,158,166 Contributions - Employee 257,245 477,022 Contributions - Buy Back 80,812 - Net Investment Income 1,447,151 (403,920) Benefit Payments, Including Refunds of Employee Contributions (1,607,243) (3,072,413) Administrative Expense (17,540) (41,613) Other - - Net Change in Plan Fiduciary Net Position 2,673,055 (882,758) Plan Fiduciary Net Position - Beginning 23,471,461 24,354,229 Plan Fiduciary Net Position - Ending (b) $ 26,144,516 $ 23,471,471 Net Pension Liability - Ending (a) - (b) $ 40,800,138 $ 39,321,154 Plan Fiduciary Net Position as a Percentage of the Total Pension Liability 39.05% 37.38% Covered Employee Payroll $ 4,895,248 $ 4,941,381 Net Pension Liability as a Percentage of covered Employee Payroll 833.46% 795.75% Notes to Schedule: Changes of assumptions: For measurement date 12/31/2016, amounts reported as changes of assumptions resulted from the following assumption changes: 1. For healthy lives, the mortality rates were updated from the RP-2000 Blue Collar Mortality to the RP-2000 Blue Collar Mortality projected to the valuation date with Scale BB. 2. For disabled lives, the mortality rates were updated from the RP-2000 Disabled Mortality to the RP-2000 Disabled Mortality projected to the valuation date with Scale BB. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 45 GASB 68 SCHEDULE OF CONTRIBUTIONS Last 10 Fiscal Years 12/31/2016 06/30/2016 Contribution 1,312,560 2,373,253 Contributions in Relation to the Actuarially Determined 2,512,630 2,158,166 Contribution Deficiency (Excess) $ (1,200,070) $ 215,087 Covered Employee Payroll $ 4,895,248 $ 4,941,381 Contributions as a Percentage of Covered Employee Payroll 51.33% 43.68% Notes to Schedule Valuation Date: 07/01/2015 07/01/2014 Actuarially determined contribution is calculated as of December 31 of two fiscal years prior to the year in which contributions are reported. Methods and assumptions used to determine contribution rates: Funding Method: Entry Age Normal. Amortization Method: Level percentage of pay, closed. Remaining Amortization Peri 26 Years (as of 7/1/2015). Actuarial Asset Method: 5-year Average Market Value (PA 096-1495). Inflation: 2.50% per year. Salary Increases: 4.50% per year. Payroll Growth: 4.50% per year. Interest Rate: 7.50% per year compounded annually, net of investment Retirement Rates: See Table Below. Termination Rates: See Table Below. Disability Rates: See Table Below. It is assumed that 70% of Disability Retirements and 5% of Pre-Retirement Deaths are service- Mortality: RP 2000 Mortality Table (CHBCA). There is no margin for future mortality improvement beyond the valuation date. City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 46 GASB 68 Sample Annual Rates Per 100 Participants: Age Mortality Withdrawal Disability Retirement 20 0.03 9.00 0.10 25 0.04 5.00 0.10 30 0.07 2.50 0.20 35 0.11 2.00 0.35 40 0.14 1.00 0.50 45 0.18 1.00 0.64 50 0.24 1.00 1.00 14.00 55 0.42 1.00 1.50 20.00 60 0.83 1.00 3.00 25.00 65 1.55 1.00 4.25 50.00 70 2.68 100.00 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 47 GASB 68 COMPONENTS OF PENSION EXPENSE FISCAL YEAR DECEMBER 31, 2016 Net Pension Deferred Deferred Liability Inflows Outflows Pension Expense Beginning Balance $ 39,321,164 $ 85,700 $ 1,770,024 Total Pension Liability Factors: Service Cost 560,373 560,373 Interest 2,345,602 2,345,602 Changes in Benefit Terms - - Contributions - Buy Back 80,812 80,812 Differences Between Expected and Actual Experience With Regard to Economic or Demographic Assumptions 26,697 - 26,697 Current Year Amortization (8,570) (2,224) (6,346) Changes in Assumptions About Future Economic or Demographic Factors or Other Inputs 2,745,788 - 2,745,788 Current Year Amortization - (228,816) 228,816 Benefit Payments (1,607,243) (1,607,243) Net Change 4,152,029 (8,570) 2,541,445 1,602,014 Plan Fiduciary Net Position: Contributions - Employer 2,512,630 Contributions - Employee 257,245 (257,245) Contributions - Buy Back 80,812 (80,812) Net Investment Income 903,165 (903,165) Difference Between Projected and Actual Earnings on Pension Plan Investments 543,986 543,986 - Current Year Amortization (54,399) (221,253) 166,854 Benefit Payments (1,607,243) 1,607,243 Administrative Expenses (17,540) 17,540 Other - - Net Change 2,673,055 489,587 (221,253) 550,415 Ending Balance $ 40,800,138 $ 566,717 $ 4,090,216 $ 2,152,429 City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 48  GASB 68 AMORTIZATION SCHEDULE - EXPERIENCE Increase (Decrease) in Pension Expense Arising from the Recognition of the Effects of Differences between Expected and Actual Experience Differences Between Expected and Recognition Year Base Actual Period Established Experience (Years) 2016 2017 2018 2019 2020 2021 2022 2023 2016 $ 26,697 6 $ 2,224 $ 4,450 $ 4,450 $ 4,450 $ 4,450 $ 4,450 $ 2,223 $ - 2015 $ (102,841) 6 $ (8,570) $ (17,140) $ (17,140) $ (17,140) $ (17,140) $ (8,570) $ - $ - Net Increase (Decrease) in Pension Expense $ (6,346) $ (12,690) $ (12,690) $ (12,690) $ (12,690) $ (4,120) $ 2,223 $ - City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 49  GASB 68 AMORTIZATION SCHEDULE - CHANGES OF ASSUMPTIONS Increase (Decrease) in Pension Expense Arising from the Recognition of the Effects of Changes of Assumptions Recognition Year Base Change of Period Established Assumptions (Years) 2016 2017 2018 2019 2020 2021 2022 2023 2016 $ 2,745,788 6 $ 228,816 $ 457,631 $ 457,631 $ 457,631 $ 457,631 $ 457,631 $ 228,817 $ - 2015 $ - 6 $ - $ - $ - $ - $ - $ - $ - $ - Net Increase (Decrease) in Pension Expense $ 228,816 $ 457,631 $ 457,631 $ 457,631 $ 457,631 $ 457,631 $ 228,817 $ - City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 50 GASB 68 AMORTIZATION SCHEDULE - INVESTMENTS Increase (Decrease) in Pension Expense Arising from the Recognition of the of Differences Between Projected and Actual Earnings on Pension Plan Investments Differences Between Year Base Projected and Actual Recognition Established Earnings Period (Years) 2016 2017 2018 2019 2020 2021 2022 2016 $ (543,986) 5 $ (54,399) $ (108,797) $ (108,797) $ (108,797) $ (108,797) $ (54,399) $ - 2015 $ 2,212,531 5 $ 221,253 $ 442,506 $ 442,506 $ 442,506 $ 221,253 $ - $ - Net Increase (Decrease) in Pension Expense $ 166,854 $ 333,709 $ 333,709 $ 333,709 $ 112,456 $ (54,399) $ - City of DeKalb Firefighters' Pension Fund FOSTER & FOSTER | 51 July 13, 2017 City of DeKalb c/o Robert Miller, Assistant Finance Director 200 South Fourth Street DeKalb, IL 60115 Re: Impact of Lowering the Investment Return Assumption to 7.25% and 7.00% City of DeKalb Police Pension Fund Dear Mr. Miller: As requested, we have performed a special actuarial analysis to determine the impact on the Plan’s funding requirements if the assumed rate of investment return was lowered from 7.50% to 7.25% and 7.00% per year, net of investment related expenses. The impact on the Plan’s unfunded actuarial accrued liability (UAAL), funded ratio and the City’s minimum contribution requirements, determined as of January 1, 2017 (applicable to the fiscal year ending December 31, 2018), are illustrated below. Current (7.50%) Proposed (7.25%) Proposed (7.00%) (1) Actuarial Accrued Liability $65,647,682 $67,788,624 $70,041,001 (2) Actuarial Value of Assets $32,821,116 $32,821,116 $32,821,116 (3) Unfunded Actuarial Accrued Liability, (1) – (2) $32,826,566 $34,967,508 $37,219,885 (4) Funded Ratio, (2) ÷ (1) 50.0% 48.4% 46.9% (5) Impact on City Contribution Total Required Contribution $3,217,853 $3,367,869 $3,524,140 % of Projected Annual Payroll 59.4% 62.2% 65.0% Member Contributions $536,886 $536,886 $536,886 % of Projected Annual Payroll 9.9% 9.9% 9.9% City Required Contribution 2,680,967 $2,830,983 $2,987,254 % of Projected Annual Payroll 49.5% 52.3% 55.1% Please note the contents of this analysis and the January 1, 2017 actuarial valuation report are considered an integral part of the actuarial opinions. The undersigned is familiar with the immediate and long-term aspects of pension valuations, and meets the Qualification Standards of the American Academy of Actuaries necessary to render the actuarial opinions contained herein. If you have any questions, concerns, or would like to discuss the results in greater detail, please do not hesitate to contact us. Sincerely, Jason L. Franken, FSA, EA, MAAA One Oakbrook Terrace, Suite 720 Oakbrook Terrace, IL 60181 · (630) 620-0200 · Fax (239) 481-0634 · www.foster-foster.com July 13, 2017 City of DeKalb c/o Robert Miller, Assistant Finance Director 200 South Fourth Street DeKalb, IL 60115 Re: Impact of Lowering the Investment Return Assumption to 7.25% and 7.00% City of DeKalb Fire Pension Fund Dear Mr. Miller: As requested, we have performed a special actuarial analysis to determine the impact on the Plan’s funding requirements if the assumed rate of investment return was lowered from 7.50% to 7.25% and 7.00% per year, net of investment related expenses. The impact on the Plan’s unfunded actuarial accrued liability (UAAL), funded ratio and the City’s minimum contribution requirements, determined as of January 1, 2017 (applicable to the fiscal year ending December 31, 2018), are illustrated below. Current (7.50%) Proposed (7.25%) Proposed (7.00%) (1) Actuarial Accrued Liability $67,277,525 $69,385,020 $71,599,807 (2) Actuarial Value of Assets $27,626,619 $27,626,619 $27,626,619 (3) Unfunded Actuarial Accrued Liability, (1) – (2) $39,650,906 $41,758,401 $43,973,188 (4) Funded Ratio, (2) ÷ (1) 41.1% 39.8% 38.6% (5) Impact on City Contribution Total Required Contribution $3,646,756 $3,783,429 $3,926,156 % of Projected Annual Payroll 74.5% 77.3% 80.2% Member Contributions $462,846 $462,846 $462,846 % of Projected Annual Payroll 9.5% 9.5% 9.5% City Required Contribution $3,183,910 $3,320,583 $3,463,310 % of Projected Annual Payroll 65.0% 67.8% 70.7% Please note the contents of this analysis and the January 1, 2017 actuarial valuation report are considered an integral part of the actuarial opinions. The undersigned is familiar with the immediate and long-term aspects of pension valuations, and meets the Qualification Standards of the American Academy of Actuaries necessary to render the actuarial opinions contained herein. If you have any questions, concerns, or would like to discuss the results in greater detail, please do not hesitate to contact us. Sincerely, Jason L. Franken, FSA, EA, MAAA One Oakbrook Terrace, Suite 720 Oakbrook Terrace, IL 60181 · (630) 620-0200 · Fax (239) 481-0634 · www.foster-foster.com Revenue and Expenditure Policy ______________________________________________________________________________ Policy Number: 01-04 Date: January 9, 2017 Purpose: Revenues The City desires to maintain a diversified and stable revenue base to reduce the impacts of fluctuations in any one revenue source. The revenue mix combines elastic and inelastic revenue sources to minimize the effects of an economic downturn. The City also incorporates the following principles related to revenues as it furthers its financial planning and fulfills its fiscal responsibilities: 1. The City prefers to keep its property tax rate as low as possible. The following components shall be followed in priority order each year when establishing the property tax levy: a. Levy for Police, Fire and IMRF pensions per actuary calculations. If the actuarial reports indicated a higher employer contribution is needed, said increase will need to be added to the City’s overall previous year levy request to avoid underfunding problems. b. Levy for FICA. c. Levy for general obligation bond principal and interest less abatements. d. Levy to support General Fund operations including Police, Fire, Public Works, Community Development, Finance, Human Resources, I.T. and Administration. The annual increase for this component should not exceed the rate of inflation. e. Levy to fund additional personnel as determined by the City Council. 2. User charges and tap-on fees will be sufficient to finance all operating and debt service costs for the Water Fund. 3. The City Manager should impose spending limits if, in his/her judgment, revenues will be below original estimates. Staff should review and monitor on  a monthly basis expenditures to assure control of spending within available revenues. 4. Ongoing transfers will be made from the General Fund to the Fleet Replacement fund on an annual basis to help plan for the purchasing of large capital equipment needs. Expenditures The City will strive to adhere to the following policies: 1. The City will consistently budget the minimum level of expenditures which will provide for the public well-being and safety of the residents and businesses of the community. 2. Expenditures will be within the confines of generated revenue. Fund balances will not be used to pay for operating expenditures except in the case of emergencies and after careful consideration. RETURN TO AGENDA DATE: September 18, 2018 TO: Mike Peddle, Chair Finance Advisory Committee FROM: Anne Marie Gaura, City Manager Jeff Wilkins, Interim Finance Director SUBJECT: Five Year Financial Plan In 2015, the City undertook a strategic planning process that would set direction for City policy, budgeting and program development for the next 10 years. An extensive community engagement effort was conducted in order to capture the opinions and ideas about the future of DeKalb from people who live, work and/or learn in the City. In February of 2016, the City Council adopted the DeKalb 2025 Strategic Plan that provided an outline of priorities for a 10-year horizon. In past annual budget documents, the City has included a Five-Year Financial Forecast for the General Fund. It included assumptions required to understand the City’s financial position in future years beyond the information contained in the main portions of the annual operating budget for the General Fund. The Forecast is updated annually as part of the budget process. The development of the City’s inaugural Five Year Financial Plan is an extension of the continued and progressive path of effective financial management. The Five‐Year Financial Plan is a process and strategy for long‐term strategic financial planning that includes economic position analysis, benchmarking to comparable communities, revenue and expenditure analysis, capital planning and alternative policy considerations. The Plan will allow the City to address the individual or compounded effects of various policy choices and to demonstrate their impact on the City’s financial future. This information enables City Council and the community to discuss policy decisions with greater awareness of their long‐term financial implications. Through this process and strategy, the City seeks to achieve the balance of fiscal strength, accountability and results that the community values. The elements of the Five‐Year Financial Plan include: 1. Summary of DeKalb’s current economic position 2. Benchmarking DeKalb to comparable communities 3. Revenue and expenditure projections  4. Streets and Fleet Preliminary Asset Management Analysis 5. Alternative funding policy considerations As part of the summary on DeKalb’s current economic position, DeKalb’s economic strengths are summarized. Information is provided regarding DeKalb’s population, education attainment, housing and land use. This section also describes Northern Illinois University and its general impact on the community’s workforce. A commentary is also provided on retail and commercial real estate. Information is also provided describing DeKalb’s recent downgraded bond rating and debt obligations. In benchmarking DeKalb to comparable communities, 13 comparable communities and four university communities were analyzed. Information was gathered from the Comprehensive Annual Financial Reports for data points of 2016, 2011 and 2006. This section compares population, per capita personal income, full time employees, employees per 1,000 population, General Fund expenditures, General Fund Expenditures per capita, General Fund revenues and General Fund revenues per capita. General Fund revenues is further summarized by category – sales tax, income tax, utility tax. This section provides each communities’ information for property taxes levied, tax rates, assessed valuation and assessed valuation categories between 2006 and 2016. The last part of the benchmarking section contains comparable information for pension contributions, funding rate and unfunded liability for each community between 2006 and 2016. Summaries are provided for each detailed chart and table. The Revenues and Expenditures Forecast section includes historical fund balances, revenues and expenditures, and forecasts. Baseline forecast and alternative forecast is provided utilizing inflation assumptions. Each forecast contains a summary of the impact on fund balance and property tax rate. This section contains additional information describing the cost centers with significant effect on expenditures such as personnel costs, employee salaries, union contracts, health insurance and retiree health insurance. The Streets and Fleet Preliminary Asset Management Plan is outlined. For streets and fleet, this section includes detailed summaries of asset inventory and condition assessment, level of service evaluation, asset management strategy and financial strategy. Alternative Funding Policy Considerations sections includes detailed history of intergovernmental agreements with DeKalb County and the City of Sycamore. The current and projected impact of each agreement is provided. This section includes funding scenarios for streets and fleet. A forecast and policy consideration for General Fund stabilization is also provided. Since this is the Inaugural Five Year Financial Plan, it is being viewed as the foundation from which to build. Within the next year, the document will be revised and refined to be used in the development of the FY2019 Annual Budget and with subsequent budget documents. Page |2  2018-2022 Five Year Financial Plan  Table of Contents Introduction .................................................................................................................................................. 7 Purpose of Financial Planning ................................................................................................................... 7 Tool for Decision-Making .......................................................................................................................... 8 Long-Term Financial Plan .......................................................................................................................... 8 Elements of the Plan ................................................................................................................................. 9 Economic Position ....................................................................................................................................... 13 DeKalb’s Strengths .................................................................................................................................. 13 Population ............................................................................................................................................... 14 Northern Illinois University ..................................................................................................................... 17 Property Values and Taxes...................................................................................................................... 18 National Retail and Commercial Real Estate .......................................................................................... 20 Bond Rating and Debt Obligations .......................................................................................................... 21 Benchmarking DeKalb to Comparable Communities.................................................................................. 26 Comparable Communities ...................................................................................................................... 26 Benchmarking Data ................................................................................................................................. 28 Population and Per Capita Income ......................................................................................................... 28 Full-Time Equivalent Employees ............................................................................................................. 30 General Fund Expenditures..................................................................................................................... 32 General Fund Revenues .......................................................................................................................... 34 Home Rule Sales Tax ............................................................................................................................... 39 Property Taxes and Assessed Valuation ................................................................................................. 41  Pensions .................................................................................................................................................. 60 Revenue and Expenditure Projections ........................................................................................................ 80 Revenue and Expenditure Forecast ........................................................................................................ 80 Baseline Forecast ................................................................................................................................ 81 Alternative Forecast ............................................................................................................................ 84 Revenues ................................................................................................................................................. 86 Expenditures ........................................................................................................................................... 90 Personnel Costs ....................................................................................................................................... 91 Outsourcing of Services ...................................................................................................................... 93 Salaries ................................................................................................................................................ 93 Bargaining Units .................................................................................................................................. 94 Wellness .............................................................................................................................................. 95 Retiree Insurance ................................................................................................................................ 95 Health Insurance Plan Design ............................................................................................................. 97 Streets and Fleet Analysis – Preliminary Asset Management Plan........................................................... 101 Fleet Inventory ...................................................................................................................................... 101 Fleet Condition Assessment .................................................................................................................. 104 Level of Service ..................................................................................................................................... 107 Replacement Cost ................................................................................................................................. 108 Street Inventory .................................................................................................................................... 110 Pavement Condition Assessment ......................................................................................................... 110 Level of Service ..................................................................................................................................... 113 Pavement Management Plan................................................................................................................ 114 Alternative Funding Policy Considerations ............................................................................................... 119 Intergovernmental Agreements – Revenue Sharing ............................................................................ 119 DeKalb Market Square Agreements and the Peace Road Interchange ............................................ 119 Peace Road Interchange Improvements ........................................................................................... 121 DeKalb County Home Agreement ..................................................................................................... 124 Sycamore Boundary Agreement ....................................................................................................... 127 General Fund Stabilization – Property Tax Levy ................................................................................... 128 Streets and Fleet Funding ..................................................................................................................... 131 Streets and Fleet Conclusions ............................................................................................................... 136 Alternative Funding Policy Conclusions ................................................................................................ 137 Introduction  Introduction  Purpose of Financial Planning  Tool for Decision Making  Long-Term Financial Plan  Elements of the Plan  Introduction Over the past two years, the State of Illinois’ lack of a State budget has had direct and indirect impact on the City of DeKalb. The City’s budget has been impacted by declining and delayed revenue streams. It has also had an impact on the City’s latest bond rating by Moody’s. The two sectors hit hardest by the State’s lack of annual budgets include higher education and social services. The City’s largest employer Northern Illinois University has seen their funding drastically cut and revenue decreased which has had a domino effect on enrollment. Decreased social service agency funding has negatively impacted DeKalb residents who financially are the group that can least afford the reduction. All of these realities factor into the City’s ability to provide service to DeKalb residents and businesses, both short-term and long-term. In order to address the issues relating to the City, an important strategy in funding City operations is ensuring a diversified revenue base and creating stronger, more reliable revenue streams. One of the key components of that revenue base is a strong tax base and increasing the overall Equalized Assessed Valuation (EAV). The City has a number of projects that are in the works to assist in increasing the overall EAV and create stronger revenue streams. Purpose of Financial Planning The Government Finance Officers Association (GFOA) outlines a number of Best Practices. According to their list of Best Practices and one relating to long-term planning is the Establishment of Strategic Plans. GFOA identifies the following. Strategic planning is a comprehensive and systematic management tool designed to help organizations assess the current environment, anticipate and respond appropriately to changes in the environment, envision the future, increase effectiveness, develop commitment to the organizations mission and achieve consensus on strategies and objectives for achieving that mission. GFOA further recommends that, “all governmental entities use some form of strategic planning to provide a long-term perspective for service delivery and budgeting, thus establishing logical links between authorized spending and broad organizational goals.” In 2015, the City undertook a strategic planning process that would set direction for City policy, budgeting and program development for the next 10 years. An extensive community engagement effort was conducted in order to capture the opinions and ideas about the future of DeKalb from people who live, work and/or learn in the City. In February of 2016, the City Council adopted the DeKalb 2025 Strategic Plan that provided an outline of priorities for a 10- year horizon. GFOA’s Best Practice on Long-Term Financial Planning states: 7  Many governments have a comprehensive long-term financial planning process because it stimulates discussion and engenders a long-term perspective for decision makers. It can be used as a tool to prevent financial challenges; it stimulates long-term and strategic thinking; it can give consensus on long-term financial direction; and it is useful for communications with internal and external stakeholders. In past annual budget documents, the City has included a Five-Year Financial Forecast for the General Fund. It included assumptions required to understand the City’s financial position in future years beyond the information contained in the main portions of the annual operating budget for the General Fund. The Forecast is updated annually as part of the budget process. The development of the City’s inaugural Five Year Financial Plan is an extension of the continued and progressive path of effective financial management. The Five‐Year Financial Plan is a process and strategy for long‐term strategic financial planning that includes economic position analysis, benchmarking to comparable communities, revenue and expenditure analysis, capital planning and alternative policy considerations. The Plan will allow the City to address the individual or compounded effects of various policy choices and to demonstrate their impact on the City’s financial future. This information enables City Council and the community to discuss policy decisions with greater awareness of their long‐term financial implications. Through this process and strategy, the City seeks to achieve the balance of fiscal strength, accountability and results that the community values. Tool for Decision-Making To achieve results that the community values in a constrained economic environment, resources must be strategically aligned to reflect community values. This process of alignment cannot be completed in only a single budget cycle. This need for multi‐year alignment is addressed through long‐term planning. The Five‐Year Financial Plan does not include specific decisions on how to bring the City’s five‐ year revenues and expenditures in balance. It presents the causes of particular issues and provides an opportunity for examining various policy options while facilitating a community dialogue about those choices. Long-Term Financial Plan As outlined, long-term financial planning is a best management practice recommended by the GFOA. The planning process combines financial forecasting with strategy planning. It is a collaborative process that considers future scenarios and helps governments navigate challenges. Long-term financial planning works best as part of an overall strategic plan. GFOA states: 8  Financial forecasting is the process of projecting revenues and expenditures over a long-term period, using assumptions about economic conditions, future spending scenarios, and other salient variables. Long-term financial planning is the process of aligning financial capacity with long-term service objectives. Financial planning uses forecasts to provide insight into future financial capacity so that strategies can be developed to achieve long-term sustainability in light of the government's service objectives and financial challenges. According to GFOA, “a long-term financial plan should include these steps: 1. Mobilization Phase. The mobilization phase prepares the organization for long-term planning by creating consensus on what the purpose and results of the planning process should be. 2. Analysis Phase. The analysis phase is designed to produce information that supports planning and strategizing. The analysis phase includes the projections and financial analysis commonly associated with long-term financial planning. 3. Decision Phase. After the analysis phase is completed, the government must decide how to use the information provided. Key to decision phase is a highly participative process that involves elected officials, staff, and the public. The decision phase also includes a culminating event where the stakeholders can assess the planning process to evaluate whether the purposes for the plan described in the mobilization phase were fulfilled and where a sense of closure and accomplishment can be generated. Finally, the decision phase should address the processes for executing the plan to ensure tangible results are realized. 4. Execution Phase. After the plan is officially adopted, strategies must be put into action (e.g. funding required in achieving goals). The execution phase is where the strategies become operational through the budget, financial performance measures, and action plans. Regular monitoring should be part of this phase.” Elements of the Plan The elements of the Five‐Year Financial Plan include: 1. Summary of DeKalb’s current economic position 2. Benchmarking DeKalb to comparable communities 3. Revenue and expenditure projections 4. Streets and Fleet Preliminary Asset Management Analysis 5. Alternative funding policy considerations As part of the summary on DeKalb’s current economic position, DeKalb’s economic strengths are summarized. Information is provided regarding DeKalb’s population, education 9 attainment, housing and land use. This section also describes Northern Illinois University and its general impact on the community’s workforce. A commentary is also provided on retail and commercial real estate. Information is provided describing DeKalb’s recent downgraded bond rating and debt obligations. In benchmarking DeKalb to comparable communities, 13 comparable communities and four university communities were analyzed. Information was gathered from the Comprehensive Annual Financial Reports for data points of 2066, 2011 and 2016. This section compares population, per capita personal income, full time employees, employees per 1,000 population, General Fund expenditures, General Fund expenditures per capita, General Fund revenues and General Fund revenues per capita. General Fund revenues is further summarized by category – sales tax, income tax and utility tax. This section provides each communities’ information for property taxes levied, tax rates, assessed valuation and assessed valuation categories between 2006 and 2016. The last part of the benchmarking section contains comparable information for pension contributions, funding rate and unfunded liability for each community between 2006 and 2016. Summaries are provided for each detailed chart and table. The Revenues and Expenditures Forecast section includes historical fund balances, revenues and expenditures and forecasts. Baseline forecast and alternative forecast is provided utilizing inflation assumptions. Each forecast contains a summary of the impact on fund balance and property tax rate. This section contains additional information describing the cost centers with significant effect on expenditures such as personnel costs, employee salaries, union contracts, health insurance and retiree health insurance. The Streets and Fleet Preliminary Asset Management Plan is outlined. For streets and fleet, this section includes detailed summaries of asset inventory and condition assessment, level of service evaluation, asset management strategy and financial strategy. Alternative Funding Policy Considerations sections includes detailed history of intergovernmental agreements between the City of DeKalb and DeKalb County and also between the City of DeKalb and the City of Sycamore. The current and projected impact of each agreement is provided. This section includes funding scenarios for streets and fleet. A forecast and policy consideration for General Fund stabilization is also provided. Since this is the Inaugural Five Year Financial Plan, it is being viewed as the foundation from which to build. Within the next year, the document will be revised and refined to be used in the development of the FY2019 Annual Budget and with subsequent budget documents. 10  Economic Position 11  Economic Position  DeKalb’s Strengths  Population  Northern Illinois University  Property Values and Taxes  National Retail and Commercial Real Estate  Bond Rating and Debt Obligations 12  Economic Position DeKalb’s Strengths The City of DeKalb has several distinct advantages that make it an ideal location for a regional hub for industry and business, the first being its physical location. With adjacency to I-88 and the Union Pacific West line, DeKalb has two of the nation’s economic arteries passing directly through its jurisdiction. Combined with close proximity to I-39 and the Global 3 Intermodal, the City is in the crosshairs for businesses needing access to the entire Midwest region and beyond. The City’s connectivity to the global economy goes beyond road and rail. A 7,025 foot runway at the DeKalb Taylor Municipal Airport provides access via air for businesses and executives needing timely access to their local operations. The traditional trifecta of infrastructure is not the only strength of the City. DeKalb also offers a robust fiber optic network, which will continue to become a critical component of businesses staying globally connected. In addition to DeKalb’s locational advantages with infrastructure and connectivity to the larger economy, the City also has the advantage of being situated at the fringe of the Chicago Metro Area. Although there has been much discussion in the community in regards to the number of individuals that are employed in DeKalb, but living in the far western suburbs, this can also be considered an advantage. The proximity to some of the state’s most desirable communities is a recruitment tool for attracting large employers that will have highly compensated executives and managers. This proximity allows firms to locate in DeKalb and have congestion free access and offer and easy reverse commute for their employees. As significant a strength that infrastructure and geographic location are, DeKalb’s greatest asset is its workforce. Proud home to Northern Illinois University (NIU), with excellence in engineering and business, NIU has a 123 year legacy of being a pipeline of the region’s highly- skilled employees. The City is extremely proud of the “Communiversity” relationship with NIU. It has led to innovative programs that connect students with local businesses and non-profit organizations, to assist in research, problem-solving and driving innovation. Partnerships between NIU and the region’s community college contribute to a sustainable pipeline of a highly skilled workforce. As the economy and industries continue to evolve, higher education institutions will become critical innovation hubs, necessary to maintaining regional competitiveness in a globalized economy. With the $500+ million in community investment over the past decade, DeKalb has the capacity to continue growing. While these investments have had an impact on the community’s tax burden, one must not lose sight of the opportunities that it provides for continuing to make DeKalb a great place to work, learn and live. 13 Population First incorporated in 1856, and later being designated a City in 1877, the population of DeKalb in 1880 was 1,598. Over the next 140 years, DeKalb would grow to its current population of 43,862 (per 2010 census). The current population is estimated at 44,030. The City saw a significant increase in population in the decades between 1950 and 1970, largely due to 1955 state legislation authorizing Northern Illinois State Teachers College to broaden its educational services beyond teacher education. Now known as Northern Illinois University (NIU), the school acted as a magnet for the community, drawing young individuals and families, many of whom stayed after graduation to start families, businesses and careers. The City also saw a steady rise in population in the decades between 1990 and 2010, largely driven by suburban sprawl and national demand for single family homes. Though DeKalb is considered an exurb of the Chicago Metropolitan Area, many were lured to the community because of the comparatively low cost of housing to the western suburbs. However, following the collapse of the housing market in 2008, DeKalb has struggled to regain traction in residential development. Additionally, NIU has seen a decline in enrollment over the past 10 years. It is possible that the 2020 Census will indicate flat population growth. What is unknown is the impact on the population because the apartments that once housed students alone now house students and families. In addition to general population trends, the demographic make-up of the population can be telling of the local economy. Compared to both the State of Illinois and the nation, DeKalb has a relatively low median household income and high poverty rate. However, the City does have a relatively high percentage of the population with a college degree. Given that DeKalb is a university community, these are common traits. Given the low income of students, it may skew the statistics for income and poverty, though it is difficult to know how much. 14  DeKalb Illinois United States Median Household Income (2011-2015) $37,954 $57,574 $53,889 Percentage of Population with College Degree (2011-2015) 37.0% 32.3% 29.8% Persons in Poverty (2015) 32.3% 13.6% 13.5% Unemployment Rate (2016) 5.4% 5.9% 4.9% Retail Sales per Capita (2012) $11,608 $12,942 $13,443 Population per Square Mile (2010) 2,993.8 231.1 87.4 Owner Occupied Housing Units (2011-2015) 41.6% 66.4% 63.9% Median Value of Owner-Occupied Housing Units (2011-2015) $154,100 $173,800 $178,600 A total of 35% of DeKalb residents 25 years old and older have a Bachelor's degree or higher. In addition, 10% of DeKalb residents have attained an Associate’s degree while 24% have some college education. For 23% of DeKalb residents, the highest level of education attained is a high school diploma or General Education Diploma (GED). The data shows the focus on educational attainment in DeKalb is reflective of a university community, or commonly referred to as a gown town. Population Pyramid for City of DeKalb, 2010 85 years and over 75 to 79 years 67 to 69 years 62 to 64 years 55 to 59 years 45 to 49 years Male 35 to 39 years 25 to 29 years Female 21 years 18 and 19 years 10 to 14 years Under 5 years 8% 6% 4% 2% 0% 2% 4% 6% 8% 15 The population pyramid data shows the median age for all residents is 23.7 Years. DeKalb is a young community due to the presence of the students at Northern Illinois University. The breakdown in housing distribution in DeKalb is 45.4% is comprised of single family housing while the remaining housing is broken down with various types of multi-family housing including apartments, townhomes and duplexes. The median year that homes were constructed in DeKalb is 1976. City of DeKalb Land Use Right of Way Single Family Residence 14% 19% Two family Residence Vacant/Agriculture 1% 19% Multi-Family Residence 3% Commercial 4% Industrial Transportation/Utilities 10% 9% Public Open Space 12% 9% 16 Regarding overall land use, the two largest categories of land use at 19% apiece are single family homes and vacant or agricultural areas. Of the overall breakdown, residential comprises 23% of all land use with commercial at 4% and industrial at 10%. Northern Illinois University The impact of Northern Illinois University (NIU) on the community has a much larger impact than just demographics. NIU is the largest economic driver for the City, as both the largest direct employer and largest contributor to workforce development. According to a 2015 report, NIU contributes $895 million in total economic impact to the region and is responsible for employment of 12,874 individuals. A total of 3,303 are directly employed by NIU as faculty and staff. The impact was considered to be a conservative estimate, because it did not account for the spending of visitors. The draw of visitors and students to NIU is vital to the economic success of the community. Over the past 10 years, NIU has seen a decrease in enrollment. This decline has had a direct impact on the rental housing market, leading to a surplus of available units and vacancies. Purpose built student housing, which is affordable by nature, has attracted lower income individuals and families. As a result, neighborhoods that were designed for students now have both families and students living in close proximity. This situation presents challenges for low income families and individuals, such as limited access to employment and shopping (especially grocery). Limited access to opportunity and isolation exacerbate the challenges of poverty, making it difficult, if not impossible, to break the cycle of poverty. Though improvements to public transportation systems would lead to better connectivity between individuals and employers, there are limited opportunities for employment in sectors that pay living wages. Two of the City’s top six employment sectors are low wage industries, 17 including retail and food services. However, there is growth in both the Healthcare sector, as well as the Administration and Support sector. Thus, continued investment in workforce development can lead to improved employment opportunities. Property Values and Taxes The recession and collapse of the housing market has had a lingering impact on the community. A recent history of Equalized Assessed Value (EAV) of property in the City shows that the peak 18 value was in 2008. Using EAV as a measure of property wealth, between 2008 and 2014, the City lost a total of $233,418,755 in assessed value. This amounts to a loss of $700,256,596 in total real estate value (three times EAV), with the most substantial loss being in the residential sector at $500,291,244. Similar to national trends, home values peaked in the 2006-2008 period, with the median sale price of homes in 2008 being $171,700. Early 2013 marked the low point for sale prices in DeKalb, with the median sale prices hovering just over $100,000. A decade later, while the housing market has shown signs of recovery nationally, DeKalb’s housing values have struggled to recover. The median sale price of homes in 2017 is only $131,002. The number of closed sales year to date in 2017 is 429 and have surpassed figures from 2008 at 388. This is signaling there is some demand in the market. Additionally, the number of homes currently for sale in 2017 is 35.6% lower than the same time in 2008. The laws of supply and demand would indicate that prices should be recovering, however they are not. One factor may be the age and quality of the homes in the market place. In the years leading up to 2008, many of the homes being purchased in DeKalb were of newer construction. Overall, DeKalb has an aging housing stock. Many of the older homes on the market require updates, driving the sale price down. Another contributing factor is more stringent regulations on lending through the Frank Dodd Act. For example, if a home receives multiple offers above the asking price, a bank is not permitted to underwrite a loan if the home does not appraise for the value offered by the potential purchaser. An even greater challenge to financing a home in DeKalb is high property taxes. Although DeKalb a significantly lower price per square foot compared to the western suburbs, this strategic advantage is lost when property taxes are accounted for. In many instances, the monthly cost of property tax is greater than the principal and interest on a mortgage. Therefore, when calculating what an individual or family is capable of affording, their dollar no longer goes as far in DeKalb as it once did. In addition to having an impact on demand for housing, high property taxes are also a leading reason for individuals and families moving out of the community. To illustrate the growth in residential property taxes, two charts have been provided. The property tax bills of a 35 home sample was evaluated over a 10 year period. The average assessment of those homes in 2006 was $54,293.47, with an average total property tax bill of $4,071.33. By contrast, in 2016, the average assessment of the same homes was $50,720.03, with an average tax bill of $6,743.67. Although the assessed value of those homes is less in 2016, the average property tax bill has increased by 65.6%. Of the increase in the sample property tax bill, the City has contributed to 11.5% of the increase, or approximately $306.51 annually. As a direct point of comparison, the DeKalb School District contributed to 64.8% of 19 the increase, or approximately $1,731.18 annually. If the community is not able to grow its tax base at a rate faster than the total cumulative levy of all taxing bodies, high property taxes will continue to have a negative impact on the economic position of the City. Given the City’s 9.5% share of the total tax bill, it has limited ability to have a marked impact on lowering the current property tax burden through reductions in its levy. However, the City has the greatest ability to effect economic growth, which is the most sustainable approach to lowering the tax burden. National Retail and Commercial Real Estate The City relies heavily on sales tax as a revenue source to the General Fund to cover operational expenses. Therefore, it is important that the City be able to forecast potential economic downturns that may affect sales tax revenue. The continued growth of online consumerism has already had an impact on several retail sectors, especially among national retailers and chains. 20 Recent years have seen multiple national retailers shut their doors in some or all of their stores nationally. Other retailers are downsizing their typical footprints. Many of these are considered “big box” retailers, leaving large spaces vacant and difficult to fill with new tenants. This has a secondary impact on the local economy, lowering the value of commercial properties. Additionally, the impact of online retail has had a harsher impact on national retailers, compared to niche boutique types of retailers. These types of retailers contribute large amounts of sales tax, which means the loss of one can have a substantial impact on the fiscal health of the City. The collection of local sales tax on online sales has been considered, and currently the State of Illinois does collect its portion of sales tax. Online retail sales is not the only contributing factor impacting national chains. Consumer preferences are also shifting towards a unique experiential shopping experience. This change is a driving force in many communities reinvesting in their downtowns, and concentrating on programs that support small business. Although DeKalb’s current lease rates in the downtown do not allow for redevelopment or new development to pay its own way, the affordability of rent can be seen as an asset for recruiting entrepreneurs. Bond Rating and Debt Obligations Moody’s Investors Service downgraded the City’s $32 million General Obligation (GO) bonds to ‘A1’ from ‘Aa3’on May 24, 2017. Moody’s noted in its Report: The city’s leverage related to debt and pension liabilities has increased substantially in recent years, and is expected to remain elevated. The direct debt burden and the overall debt burden…..are above state and national medians. Moody’s also identified “Increases in leverage related to the city’s debt or pension burden” as one of the factors that could lead to a downgrade. Moody’s further stated:  Certain rating factors are outside of the City’s control 21  – Local economy and size of local tax base – Institutional presence of Northern Illinois University, whose debt was downgraded to ‘Ba2’ (below investment grade) by Moody’s on June 9, 2017  Rating factors that are within the City’s control that are addressed in the FMP – Pension Burdens – Financial Operations and General Fund Reserves The credit strengths include:  Institutional presence of Northern Illinois University  Home-rule with considerable revenue raising flexibility The credit challenges are:  Sizable and growing pension burden  Exposure of main local economic institution to the State of Illinois (Baa2 negative) The following factors that could lead to a downgrade include:  Deterioration in the socio-economic profile or tax base valuation  Declines in the City’s reserves or liquidity  Increases in leverage related to the City’s debt or pension burden Outstanding Bonded Debt (As of 7/17/2017) Original Current Final Optional Par Amount Outstanding Coupon Range Maturity Redemption General Obligation Bonds, Series 2010A (Downtown TIF, 12 Yr bonds) $ 10,800,000 $ 5,200,000 4.00% - 4.00% 12/1/2021 Non-Callable General Obligation Refunding Bonds, Series 2010B (Pub. Works, 18 Yr Refi CAB bonds) $ 3,905,000 $ 3,905,000 4.25% - 4.75% 1/1/2028 Non-Callable Taxable General Obligation Refunding Bonds, Series 2010C (Pub. Works, PD station, 13 Yr Refi bonds) $ 5,415,000 $ 4,065,000 4.35% - 5.90% 1/1/2023 Non-Callable General Obligation Bonds, Series 2012A (PD station, 17 Yr bonds) $ 9,905,000 $ 7,405,000 2.00% - 2.63% 1/1/2030 1/1/2023 General Obligation Bonds, Series 2013A (DeKalb Library, 20 Yr bonds) $ 6,685,000 $ 5,870,000 3.00% - 4.00% 1/1/2033 1/1/2023 General Obligation Bonds, Series 2013B (PD station, 9 Yr bonds) $ 2,380,000 $ 2,320,000 1.50% - 3.00% 1/1/2022 Non-Callable $ 28,765,000 The City of DeKalb is a home-rule community and has no legal debt limit set by the Illinois General Assembly. The City monitors the overlapping debt of all taxing districts and is sensitive to the burden debt places on the taxpayer. In FY 2016, the City’s ratio of General Obligation Bonded Debt to EAV was 0.67%. 22  Debt Payments - Total Principal & Interest 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 2010A 2010B 2010C 2012A 2013A 2013B The chart below provides a ratio of general obligation bonded debt per resident in the City of DeKalb for Fiscal Years 2007 through 2016.5. Prior to Fiscal Year 2016.5, the City’s fiscal year end was on June 30th. The City’s changed its fiscal year end in 2016 to December 31st. Historical Trends of Bonded Debt Per Capita (General Obligation Bonds) $787 $733 $666 $613 $581 $589 $554 $548 $374 $329 2008 2009 2010 2011 2012 2013 2014 2015 2016 2016.5 Due to Moody’s recent downgrade as well as the City’s total debt payment, there are implications on the City’s near-term bond issuance. Based on an analysis conducted by the financial advisor Ehlers, potential near-term bonds as early as 2018 could pose a rating challenge. This will likely necessitate a delay on the earliest bond issuance until 2020. 23  Benchmarking 24  Benchmarking  Comparable Communities  Benchmarking Data  Population and Per Capita Income  Full-Time Equivalent Employees  General Fund Expenditures  General Fund Revenues  Home Rule Sale Tax  Property Taxes and Assessed Valuation  Pensions 25  Benchmarking DeKalb to Comparable Communities Comparable Communities In 2015, the City contracted with Sikich, a regional accounting, auditing and consulting firm, to complete a comprehensive Pay and Compensation Study. In order to identify comparable local government employers, Sikich used an empirically based, weighted variable model applied to communities that met the following criteria:  Communities located within 40 mile radius of DeKalb (due to the potential labor pool)  Communities with a population plus or minus 50% of DeKalb’s population (between 22,015 and 66,045)  Contiguous local government employers that provide a similar breadth of services to those of DeKalb (Sycamore)  Communities that provide municipal fire services The empirical model used for the study employed a sliding scale of weighted variable that correspond to the measure community’s relative similarity to the City of DeKalb for the particular variable being measured. Eleven variables were assigned weighed value of 15, 10 or 5 points where proportional points were applied based a sliding scale of relativity to DeKalb. Based on a multivariate weighted model, Sikich determined 13 comparable cities or villages were sufficiently similar. The Carpentersville was the most comparable, while Sycamore and St. Charles were the least comparable. Scoring Rubric for Empirical Development of Comparable Communities Criterion Source Variable Weighting Max Point Value 1. Municipal Fire Office of the Illinois State Fire Marshal (OSFM) Department httg://webapps.sfm.illinois.gov/FireDeptSearch/ Yes/No 2. Home Rule Status Illinois Municipal League Website 5 pts. http://imlrma.org/page.cfm?key=2 3. Colleges or 5 pts. Community Webpages Universities 4. Population Illinois State Comptroller Local Government 15 pts. Warehouse FY 2013 5. Distance from http://www.distance-cities.co/ 10 pts. DeKalb 6. Number of Full- Illinois State Comptroller Local Government 15 pts. Time Employees Warehouse FY 2013 7. General Fund Total Illinois State Comptroller Local Government 10 pts. Expenditures Warehouse FY 2013 26  8. Total Expenditures Illinois State Comptroller Local Government 15 pts. Warehouse FY 2013 9. Equalized Assessed Illinois State Comptroller Local Government 10 pts. Value (EAV) Warehouse FY 2013 10. Square Miles U.S. Census 2010 5 pts. 11. Total Sales Tax Illinois State Comptroller Local Government 10 pts. Revenue Warehouse FY 2013 12. Median Family U.S. Census, 2012 - American Fact Finder 5-year 10 pts. Income Estimates City of DeKalb – 2014 Comparable Market Empirical Model Results Municipality Total Municipal Fire Score Department? DeKalb 110 Yes 1 Carpentersville 90 Yes 2 Hanover Park 85 Yes 3 Romeoville 84 Yes 4 Crystal Lake 82 Yes 5 Streamwood 80 Yes 6 Wheaton 80 Yes 7 Rolling Meadows 78 Yes 8 Batavia 75 Yes 9 Elk Grove Village 70 Yes 10 Belvidere 68 Yes 11 Hoffman Estates 64 Yes 12 St. Charles 60 Yes 13 Sycamore 60 Yes 14 DeKalb County -- N/A The data was provided by the City unless it was otherwise noted. The model was provided by the Sikich study team. Communities without municipal Fire Departments were excluded from analysis due to the financial impact municipalities’ face in providing Fire protection and Emergency Medical Services (EMS). The City of Sycamore was included because it is a contiguous community with comparable service offerings, even though it did not fall within the population criteria. DeKalb County was included at the City’s request as a multi-service local government serving DeKalb. This plan includes benchmarks for the 13 comparable communities and they are listed in alphabetical order: Batavia, Belvidere, Carpentersville, Crystal Lake, Elk Grove Village, Hanover Park, Hoffman Estates, Rolling Meadows, Romeoville, St. Charles, Streamwood, Sycamore and Wheaton. The plan further analyzes four university communities in Illinois and include: 27 Bloomington, Charleston, Champaign and Urbana. Benchmarking Data As part of the City’s benchmarking, the data will generally be broken down to between the 13 most comparable communities first and the other three university communities second. Population and Per Capita Income Population 2016 52,894 51,895 44,528 44,030 40,743 39,680 38,291 37,973 33,460 33,238 26,045 25,070 24,667 17,867 DeKalb has the fourth highest population (44,030) of the comparable communities. Wheaton has the highest population (52,894) and Sycamore has the lowest population (17,867). DeKalb has the 4th highest population but the lowest per capita personal income. DeKalb has the third highest population University Communities - (44,030) among the university Population 2016 communities. Champaign has the 86,096 highest population (86,096) while 78,730 Charleston has the lowest population 44,030 42,311 (21,133). The university community 21,133 most comparable based on population is Urbana (42,311). Champaign Bloomington DeKalb Urbana Charleston 28  Per Capita Personal Income 2016 38,565 37,218 36,581 33,423 32,238 31,133 30,735 30,199 30,011 22,643 21,347 20,604 19,088 In comparison to the 13 comparable communities, DeKalb has the lowest per capita income. It is also the only community that is home to a four year university. Wheaton is home to Wheaton College. This low ranking may be due, in part, to the presence of NIU students. Whereas DeKalb has the third highest University Communities - population among the university Per Capita Personal Income 2016 community, it has the lowest per capita 44,397 income of these four. Please note that 39,237 39,237 in many of the charts in this document, 19,088 Charleston’s information is not included because it was not available. Bloomington Champaign Urbana DeKalb 29 Full-Time Equivalent Employees Full-Time Equivalent Employees 2016 363 313 306.28 296.05 269.1 233 231.5 206 196 191 158 157 126.5 114 Note: DeKalb’s 2016 FTE’s provided by DeKalb’s Human Resources Department For the comparable communities, DeKalb has the 7th highest number of full-time equivalent employees (FTE’s) with 231.5. Hoffman Estates has the highest FTE’s with 363 and Belvidere has the lowest FTE’s with 114. The community closest to DeKalb in FTEs is Crystal Lake (233). DeKalb ranks 4th in population, 7th for FTE’s and 10th for FTE’s per 1,000 population. The number of DeKalb’s 2016 FTEs has been provided by the Human Resources Department. The total excludes employees from the DeKalb Sycamore Area Transportation Study since they are technically not City of DeKalb employees. DeKalb has the lowest number of FTEs University Communities - Full- (231.5) of the university communities. Time Equivalent Employees 2016 Bloomington has the highest number (621), which is over 2.5 times the 621 531 number of DeKalb FTEs. 270.1 231.5 DeKalb ranks as the 3rd highest in population yet ranks 4th or has the lowest number of FTEs and FTEs per Bloomington Champaign Urbana DeKalb 1,000 population. 30  Employees Per 1,000 Population 9.4 8.0 7.7 7.1 7.0 6.4 6.0 5.7 5.6 5.3 5.2 5.0 4.6 4.5 DeKalb has the 10th highest FTEs per 1,000 population, or alternatively the 5th lowest. Only four comparable communities have lower FTEs per 1,000 population compared to DeKalb ranking 10th highest for FTE’s per 1,000 population with 5.3 FTE’s. Elk Grove Village has the highest FTEs per 1,000 population with 9.4 and Belvidere has the lowest FTEs per 1,000 with 4.5. Hanover Park is the closest comparable with 5.2 employees per 1,000 population. DeKalb has the lowest FTEs per University Communities - FTE's Per thousand population of the university 1,000 Population communities. Bloomington employs 7.9 FTEs per thousand population, nearly 7.9 6.4 6.2 1.5 times the level of DeKalb. 5.3 Bloomington Urbana Champaign DeKalb 31 General Fund Expenditures General Fund Expenditures - Fiscal Year 2016 50,296,095 49,236,218 38,108,109 36,681,918 34,058,207 31,098,260 30,744,360 29,410,240 27,837,469 26,354,397 26,295,784 24,135,474 14,944,043 14,814,837 DeKalb’s actual General Fund expenditures for Fiscal Year 2016 ranks 7th out of the 14 comparable communities. Elk Grove Village, Hoffman Estates, Belvidere and Sycamore are outliers compared to 10 other communities both on the high and low ends. Hanover Park is the closest in total General Fund expenditures at $31,098,260. University communities shown have a University Communities - General wide range of expenditures. Fund Expenditures Fiscal Year 2016 Bloomington ranks the highest at 81,090,175 $81,090,175 and Charleston at the 58,477,641 lowest at $9,865,565. DeKalb has the 3rd highest General Fund expenditures 30,744,360 27,755,937 of the five university communities at 9,865,565 $30,744,360. Bloomington Champaign DeKalb Urbana Charleston 32  General Fund Expenditures per Capita Fiscal Year 2016 1192 1018 969 927 924 836 819 727 720 698 645 592 591 Although DeKalb ranks 7th for expenditures and FTE’s, the City ranks 10th for expenditures per capita. That means nine comparable communities are providing municipal services at a higher per capita cost ranging from $1,192 to $720. Only Belvidere, Streamwood and Crystal Lake have General Fund expenditures lower than DeKalb’s at $698 per capita. DeKalb, Champaign and Urbana have University Communities - General very similar expenditures per capita in Fund Expenditures per Capita 2016 ranging from $656 to $698 per Fiscal Year 2016 capita. 1030 698 679 656 467 Bloomington DeKalb Champaign Urbana Charleston 33 General Fund Revenues Total General Fund Revenues 2016 58,312,979 55,533,341 46,563,238 42,303,364 40,949,025 34,291,821 31,697,814 30,757,742 30,683,651 28,645,838 25,579,379 25,551,564 16,085,805 15,287,923 Although, DeKalb’s actual General Fund Expenditures for Fiscal Year 2016 rank 7th and 11th for expenditures per capita, the City ranks 9th for revenues and 11th for revenues per capita. DeKalb has the 4th highest General Fund University Communities - Total revenues for all of the university General Fund Revenues 2016 communities ($30,683,651). 94,251,263 Bloomington is over three times the 72,323,419 amount of General Fund revenue ($94,251,263). The university 32,212,393 30,683,651 community with the closest General 10,114,152 Fund revenue is Urbana ($32,212,393). Bloomington Champaign Urbana DeKalb Charleston 34  General Fund Revenues per Capita 2016 1671 1285 1264 1173 1124 982 903 856 803 774 697 643 642 627 DeKalb ranks 11th out of 14 comparable communities for General Fund revenues per capita at $697. Only Crystal Lake, Belvidere and Streamwood have lower revenues ranging from $627 to $643. DeKalb ranks 4th out of 5 university University Communities - General communities for General Fund revenues Fund Revenues per Capita 2016 per capita. Urbana is most comparable to DeKalb at $761 per capita. 1197 840 761 697 479 Bloomington Champaign Urbana DeKalb Charleston 35  GENERAL FUND REVENUES 2016 Actual Home Rule Sales Actual State Sales Income Tax Revenues Utility Tax Revenues Other Revenues 100% 90% 5,197,166 11,216,757 9,963,250 80% 12,572,077 0 18,350,573 8,100,480 28,223,604 7,519,996 24,738,070 4,167,471 27,798,456 17,201,807 70% 22,787,990 38,874,867 21,764,571 60% 3,202,384 1,509,812 4,310,194 50% 0 3,668,994 4,462,992 7,049,360 5,437,859 1,791,962 2,057,469 0 11,146,198 5,929,117 40% 2,502,164 3,514,119 1,120,243 1,896,000 3,530,426 382,919 30% 5,289,536 3,696,445 2,936,915 1,285,380 4,228,795 5,637,042 2,726,656 8,293,136 4,006,240 5,107,430 10,184,441 4,985,594 2,315,210 10,990,789 7,421,224 20% 5,520,622 5,911,386 6,042,779 7,887,857 3,665,593 10% 6,511,982 3,201,200 5,040,729 3,696,341 4,713,723 8,157,011 6,146,634 5,993,378 1,969,725 3,851,280 2,519,645 3,869,271 3,627,746 2,667,060 0% 0 36  General Fund Revenues 2016 20% 37% 39% 0% 41% 45% 50% 51% 53% 52% 49% 16% 55% 60% 67% 69% 10% 5% 17% 0% 12% 0% 17% 15% 10% 8% 12% 13% 44% 6% 10% 13% 6% 4% 11% 1% 17% 5% 4% 9% 14% 17% 27% 26% 20% 26% 18% 9% 7% 17% 26% 12% 15% 13% 12% 21% 20% 20% 14% 15% 15% 11% 13% 14% 13% 6% 8% 9% 9% 0% Actual Home Rule Sales Actual State Sales Income Tax Revenues Utility Tax Revenues Other Revenues Thirteen comparable communities have Home Rule Sales Tax. DeKalb relies relatively more on Home Rule Sales tax as indicated by the 21% of General Fund Revenues for 2016. Most communities rely on Home Rule Sales tax for 9% to 15% of General Fund revenue. Seven communities, including: Elk Grove, Hanover Park, Hoffman Estates, Rolling Meadows, Romeoville, St. Charles and Streamwood, rely on ''Other Revenue” category for more than 50% of their General Fund Revenues for 2016. This means that they are more reliant on property tax and revenues other than sales, income and utility taxes. At 37%, DeKalb is less reliant on property tax and other revenues compared to the other communities. 37  University Communities - General Fund Revenues 2016 11,216,757 43,667,487 15,728,955 4,683,925 47,918,926 3,202,384 2,383,483 776,122 4,462,992 8,118,812 2,944,800 6,837,815 4,131,774 8,164,515 2,233,739 5,289,536 18,153,637 14,213,470 5,108,103 6,511,982 18,273,051 2,420,366 17,116,537 4,298,761 0 DeKalb Champaign Urbana Charleston Bloomington Actual Home Rule Sales Actual State Sales Income Tax Revenues Utility Tax Revenues Other Revenues DeKalb and three other university communities have Home Rule Sales tax. Champaign and Bloomington collect more Home Rule Sales tax. Champaign’s Home Rules Sales tax and State Sale tax account for 50% of their General Fund revenue in 2016. DeKalb relies on Home Rule Sales tax and State Sales tax for 38% of General Fund revenue. Urbana, Charleston and Bloomington are more reliant on property taxes and fees. At 37%, DeKalb is less reliant on property tax and other revenues compared to the three university communities. University Communities - General Fund Revenues 2016 37% 35% 49% 46% 51% 3% 10% 11% 15% 9% 8% 7% 25% 13% 22% 9% 17% 15% 16% 21% 25% 24% 18% 13% 0% DeKalb Champaign Urbana Charleston Bloomington Actual Home Rule Sales Actual State Sales Income Tax Revenues Utility Tax Revenues Other Revenues 38 Home Rule Sales Tax City Home Rule Sales Taxes & Rate 2016 8,157,011 6,511,982 6,146,634 5,993,378 5,040,729 4,713,723 3,851,280 3,696,341 3,627,746 3,869,271 2,667,060 2,519,645 1,969,725 1.75% 1.00% 0 0 2.00% 0.75% 1.00% 0.75% 1.00% 1.00% 1.50% 1.00% 1.00% 1.75% 1.00% Communities with Home Rule Sales Tax range from 0.75% to 2%. In 2016, DeKalb ranks second in Home Rule Sales Tax revenue collection. Elk Grove Village is the highest revenue collector of Home Rules Sales Tax with $8,157,011. Only five communities including DeKalb, Crystal Lake, Elk Grove Village, Romeoville and St. Charles, collect over $5 million in home rule sales tax revenues. 39  University Communities - City Home Rule Sales Taxes & Rate 2016 18,273,051 17,116,537 6,511,982 4,298,761 1.75% 1.50% 1.50% 0 0 2.50% DeKalb Champaign Urbana Charleston Bloomington Note: Charleston does not have Home rule sales tax University communities with Home Rule Sales Tax range from 1.5% to 2.5%. In 2016, DeKalb ranks third in Home Rule Sales Tax revenue collection. There is a significant difference in sales tax revenues collected by Champaign ($18,273,051) and Bloomington ($17,116,537) versus DeKalb and Urbana. 40 Property Taxes and Assessed Valuation TOTAL PROPERTY TAXES LEVIED 2006 2011 2016 17,626,952 13,080,114 23,413,146 11,172,796 17,136,948 25,313,419 8,019,303 15,491,665 6,891,780 8,841,740 10,212,017 6,596,164 8,113,730 8,364,469 19,161,057 12,852,966 10,910,424 17,971,963 12,058,027 10,419,656 11,081,993 10,690,980 9,862,989 12,057,772 13,193,894 5,286,412 3,022,052 13,061,065 11,634,443 13,160,870 11,053,029 11,879,677 6,243,388 3,193,233 3,037,991 4,196,805 6,362,197 4,237,013 3,604,253 5,094,730 4,741,604 3,925,479 Each community increased their property tax levy between years 2006 and 2016. Only St. Charles experienced a slight decrease ($300) in their property tax levy from 2011 to 2016. Wheaton had the highest property tax levy in 2016 at $25,313,419. Hoffman Estates had the 2nd highest property tax levy in 2016 at $19,161,057. Although DeKalb’s population is ranked 4th, DeKalb is ranked 12th highest of 14 communities in 2016 with a levy of $5,094,730. Through the 10 year period, DeKalb has consistently ranked 12th to 14th for property tax levy. 41  Property Taxes Levied for Fiscal Year 2016 25,313,419 19,161,057 17,971,963 13,193,894 13,160,870 13,061,065 12,057,772 11,879,677 11,634,443 11,053,029 6,362,197 5,094,7304,741,604 3,925,479 DeKalb ranked 12th for the property tax levy in 2016. PROPERTY TAX RATES PER $100 OF ASSESSED VALUATION 2006 2011 2016 2.9299 2.7346 1.07045 1.009 1.87 1.3367 1.2716 0.901 1.04 0.9863 1.63369 0.593 1.693 0.6499 1.583 0.75444 0.687 0.986 1.0591 0.8302 0.6899 0.7574 1.024 0.719 1.2981 0.7537 1.6716 0.80356 0.8631 0.5748 1.563 0.7785 1.1942 0.5925 1.213 1.159 1.064 0.9109 1.06287 1.0342 0.6955 Each community experienced increase of property tax rates between years 2006 and 2016. All communities also experienced increase of property tax rates between year 2011 and 2016. Through the 10 year period, DeKalb has consistently ranked in the lower half of the 14 42 communities for property tax rate. DeKalb’s most comparable community, Carpentersville had the highest property tax rate in 2016 at 2.9299. DeKalb’s second most comparable community, Hanover Park (DuPage County) had the second highest property tax rate in 2016 at 2.7346. DeKalb’s property tax rate of 1.1942 is ranked 9th of 14 communities in 2016. Alternatively, it can be viewed as the 6th lowest. Property Tax Rates per $100 of Assessed Valuation for 2016 2.9299 2.7346 1.8700 1.6716 1.6337 1.5630 1.2981 1.2130 1.1942 1.1590 1.0629 1.0342 0.9109 0.6955 43  509,622,916 608,332,947 468,077,742 919,721,190 1,053,784,460 914,945,274 395,816,101 293,958,710 599,930,235 648,109,995 445,784,892 1,200,659,064 All communities experienced an increase in total assessed value of taxable property between 1,315,132,543 979,392,388 2,200,470,660 2,340,307,770 1,589,750,480 656,477,775 2006 743,626,927 525,854,318 TOTA L A SSESSE D VA LUE O F TA XA BLE PRO PE RT Y FO R T HE F I SC A L 44 2011 1,830,698,515 2,141,847,633 1,518,840,790 2016 959,038,502 1,003,838,180 703,906,897 2006 and 2011. However, from 2011 to 2016 all communities sustained a decrease in total 894,235,108 1,276,684,761 1,065,515,505 1,352,327,533 1,548,128,154 1,322,751,195 767,607,981 961,608,681 661,216,133 309,324,156 YEA R 436,016,750 357,501,358 1,807,481,291 assessed value. 2,168,300,482 1,883,310,764  Total Assessed Value of Taxable Property for Fiscal Year 2006 2011 2016 Difference DeKalb 509,622,916 608,332,947 468,077,742 -140,255,205 -23% Batavia 919,721,190 1,053,784,460 914,945,274 -138,839,186 -13% Belvidere 395,816,101 293,958,710 -101,857,391 -26% Carpentersville 599,930,235 648,109,995 445,784,892 -202,325,103 -31% Crystal Lake 1,200,659,064 1,315,132,543 979,392,388 -335,740,155 -26% Elk Grove Village 2,200,470,660 2,340,307,770 1,589,750,480 -750,557,290 -32% Hanover Park 656,477,775 743,626,927 525,854,318 -217,772,609 -29% Hoffman Estates 1,830,698,515 2,141,847,633 1,518,840,790 -623,006,843 -29% Rolling Meadows 959,038,502 1,003,838,180 703,906,897 -299,931,283 -30% Romeoville 894,235,108 1,276,684,761 1,065,515,505 -211,169,256 -17% St. Charles 1,352,327,533 1,548,128,154 1,322,751,195 -225,376,959 -15% Streamwood 767,607,981 961,608,681 661,216,133 -300,392,548 -31% Sycamore 309,324,156 436,016,750 357,501,358 -78,515,392 -18% Wheaton 1,807,481,291 2,168,300,482 1,883,310,764 -284,989,718 -13% Five communities had reductions between 13% and 19% (Batavia, Romeoville, St. Charles, Sycamore and Wheaton). Five communities incurred reductions between 20% and 29% (DeKalb, Belvidere, Crystal Lake, Hanover Park and Hoffman Estates). Four communities experienced reductions between 30% and 32% (Carpentersville, Elk Grove, Rolling Meadows and Streamwood). DeKalb's assessed value declined 23% from 2011 ($608,332,947) to 2016 ($468,077,742). 45  TOTAL ASSESSED VALUE OF TAXABLE PROPERTY 1,883,310,764 FOR FISCAL YEAR 2016 1,589,750,480 1,518,840,790 1,322,751,195 1,065,515,505 979,392,388 914,945,274 703,906,897 661,216,133 525,854,318 468,077,742 445,784,892 357,501,358 293,958,710 DeKalb ranks 11th in assessed valuation in 2016 and has been in the lower half since 2006. Even with the relatively lower assessed valuation, through the 10 year period, DeKalb has also consistently ranked in the lower half of the 14 communities for the property tax rate. 46  Assessed Value of Taxable Property for Fiscal Year 2016 32,833,576 12,177,758 39,511,338 9,401,320 56,205,928 15,223,571 38,998,251 78,686,402 125,965,723 63,099,260 149,545,866 56,768,073 308,118,039 49,645,834 122,473,358 79,253,886 217,281,136 341,110,857 68,982,503 108,495,593 441,647,788 142,889,179 763,642,797 305,076,606 56,976,024 242,324,603 116,055,318 235,964,563 505,826,859 376,194,689 891,708,866 1,564,260,751 656,321,694 699,260,973 393,686,769 261,933,495 283,233,886 178,575,396 506,065,090 845,660,790 382,895,892 587,790,868 Residential Commercial Industrial DeKalb ranks 12th for residential assessed value, 7th for commercial assessed value and 10th for industrial assessed value in 2016. 47  325,079,355 389,625,409 283,233,886 1,564,260,751 678,936,687 764,707,767 656,321,694 891,708,866 245,030,402 178,575,396 845,660,790 525,230,256 568,109,153 376,194,689 699,260,973 860,469,362 917,883,229 699,260,973 656,321,694 615,745,592 825,416,800 587,790,868 587,790,868 2006 499,096,061 591,605,225 DeKalb ranks 12th for residential assessed value. DeKalb’s most comparable communities 506,065,090 393,686,769 RESIDENTIAL ASSESSED VALUE OF TAXABLE RESIDENTIAL ASSESSED VALUE OF TAXABLE 48 2011 885,637,285 1,148,816,831 505,826,859 845,660,790 2016 389,984,765 393,686,769 511,782,750 382,895,892 605,668,990 382,895,892 684,151,001 506,065,090 376,194,689 944,422,898 1,044,846,020 891,708,866 283,233,886 573,211,376 753,228,512 PROPERTY FOR FISCAL YEAR 2016 PROPERTY FOR FISCAL YEAR 505,826,859 261,933,495 234,122,073 326,423,881 261,933,495 (Carpentersville, Hanover Park and Rolling Meadows) all rank in the lower half of the group. 178,575,396 1,521,893,691 1,819,849,352 1,564,260,751 All communities experienced declines in residential assessed valuation between 2011 and 2016.  145,545,772 167,457,427 142,889,179 103,432,157 124,426,791 108,495,593 64,064,954 56,976,024 64,447,072 64,028,623 56,768,073 266,195,135 312,815,076 217,281,136 299,132,396 286,235,274 235,964,563 COMMERCIAL ASSESSED VALUE OF TAXABLE 77,236,570 71,549,079 All communities experienced declines in commercial assessed valuation between 2011 and 68,982,503 49 403,147,597 395,150,291 341,110,857 393,743,154 325,424,028 242,324,603 64,905,424 120,416,770 116,055,318 281,505,774 354,606,287 305,076,606 PROPERTY FOR FISCAL YEAR 120,273,247 135,324,254 122,473,358 2006 2011 2016 61,287,971 91,033,462 79,253,886 2016. 283,652,466 336,922,887 308,118,039  COMMERCIAL ASSESSED VALUE OF TAXABLE PROPERTY FOR FISCAL YEAR 2016 341,110,857 308,118,039 305,076,606 242,324,603 235,964,563 217,281,136 142,889,179 122,473,358 116,055,318 108,495,593 79,253,886 68,982,503 56,976,024 56,768,073 DeKalb ranks 7th for commercial assessed value in 2016. DeKalb’s most comparable communities (Carpentersville, Hanover Park and Rolling Meadows) all rank in the lower half of the group. 50  37,922,484 49,380,638 38,998,251 133,382,625 763,642,797 164,235,277 149,545,866 441,647,788 50,204,923 49,645,834 9,592,567 149,545,866 14,989,957 12,177,758 125,965,723 71,554,658 81,683,777 56,205,928 78,686,402 1,284,938,287 1,227,423,162 763,642,797 63,099,260 80,121,173 80,447,378 63,099,260 DeKalb ranks 10th for industrial assessed value in 2016. DeKalb’s most comparable community INDUSTRIAL ASSESSED VALUE OF TAXABLE INDUSTRIAL ASSESSED VALUE OF TAXABLE 51 56,205,928 2006 163,668,867 195,331,416 39,511,338 49,645,834 2011 175,310,583 166,631,402 78,686,402 39,511,338 221,990,396 2016 471,631,539 441,647,788 38,998,251 126,398,861 148,675,847 32,833,576 125,965,723 74,034,248 72,993,042 15,223,571 32,833,576 PROPERTY FOR THE FISCAL YEAR 2016 13,378,053 PROPERTY FOR THE FISCAL YEAR 12,177,758 16,908,063 15,223,571 1,456,950 9,401,320 10,667,490 9,401,320 (Carpentersville) is ranked 13th. All communities experienced declines in industrial assessed valuation between 2011 and 2016.  PROPERTY TAXES LEVIED FOR FISCAL YEAR 2006 2011 2016 23,586,905 24,063,364 19,955,472 20,245,796 18,942,004 15,623,559 7,710,529 7,081,807 6,153,944 5,094,730 4,478,881 4,196,805 3,022,052 DEKALB CHAMPAIGN URBANA CHARLESTON BLOOMINGTON Note: Charleston information for 2006 and 2011 was not available. Each community increased their property tax levy between years 2006 and 2011 and 2011 and 2016. The levies for DeKalb, Urbana and Charleston are substantially lower than Champaign and Bloomington. University Communities - Property Taxes Levied for Fiscal Year 2016 24,063,364 20,245,796 7,081,807 5,094,730 4,478,881 Bloomington Champaign Urbana DeKalb Charleston 52  PROPERTY TAX RATES PER $100 OF ASSESSED VALUATION 2006 2011 2016 2.27434 1.312 1.2942 1.3152 1.312 1.2942 1.355 1.27185 1.31118 1.32827 1.1942 0.6899 0.593 DEKALB CHAMPAIGN URBANA CHARLESTON BLOOMINGTON DeKalb, Champaign and Urbana have very similar property tax rates in 2016. Charleston is substantially higher at 2.274 per $100 assessed value. Unlike the comparable communities, the rates have remained fairly flat for the university communities. Property Tax Rates per $100 of Assessed Valuation 2016 2.27434 1.355 1.32827 1.3152 1.1942 Charleston Urbana Bloomington Champaign DeKalb 53  TOTAL ASSESSED VALUE OF TAXABLE PROPERTY FOR THE FISCAL YEAR 1,799,164,559 1,811,618,358 2006 2011 2016 1,541,915,649 1,539,370,157 1,489,321,602 1,190,820,008 608,332,947 595,775,666 509,622,916 522,642,560 468,077,742 469,050,593 190,900,674 DEKALB CHAMPAIGN URBANA CHARLESTON BLOOMINGTON Unlike the declines experienced by comparable communities, the assessed valuation for Champaign and Bloomington have remained fairly flat between 2011 and 2016. Urbana experienced a 12% decline compared to DeKalb’s decrease of 23%. Total Assessed Value of Taxable Property for the Fiscal Year 2016 1,811,618,358 1,539,370,157 522,642,560 468,077,742 190,900,674 Bloomington Champaign Urbana DeKalb Charleston 54  Assessed Value of Taxable Property for Fiscal Year 2016 8,013,530 11,989,029 38,998,251 201,974,287 626,317,035 142,889,179 1,538,377,384 668,528,346 283,233,886 320,668,273 1,171,670,602 856,408,738 DeKalb Champaign Urbana Charleston Bloomington Residential Commercial Industrial DeKalb ranks last in the assessed value of taxable residential and commercial property and 2nd for industrial assessed value behind Champaign. 55  RE S I DE NTI AL AS S E S S E D VALUE O F TAX AB LE P RO P E RTY FO R FI S CAL YE AR (UNI V E RS I TY CO MMUNI TI E S ) 2006 2011 2016 1,152,480,233 1,171,670,602 902,553,042 922,457,891 856,408,738 711,817,507 389,625,409 350,754,767 325,079,355 320,668,273 283,233,886 272,438,176 DEKALB CHAMPAIGN URBANA CHARLESTON BLOOMINGTON Note: Charleston information not available Except Bloomington, all communities experienced declines in residential assessed valuation between 2011 and 2016. 56  Residential Assessed Value of Taxable Property for Fiscal Year 2016 1,171,670,602 856,408,738 320,668,273 283,233,886 Bloomington Champaign Urbana DeKalb DeKalb ranks last residential assessed value. COMMERCIAL ASSESSED VALUE OF TAXABLE PROPERTY FOR FISCAL YEAR (UNIVERSITY COMMUNITIES) 2006 2011 2016 668,528,346 624,502,192 636,484,972 626,317,035 556,329,628 466,974,314 245,020,899 196,612,417 201,974,287 145,545,772 167,457,427 142,889,179 DEKALB CHAMPAIGN URBANA CHARLESTON BLOOMINGTON Except Champaign, all communities experienced declines in commercial assessed valuation between 2011 and 2016. 57  Commercial Assessed Value of Taxable Property for the Fiscal Year 2016 668,528,346 626,317,035 201,974,287 142,889,179 Champaign Bloomington Urbana DeKalb DeKalb ranks last in commercial assessed value. INDUSTRIAL ASSESSED VALUE OF TAXABLE PROPERTY FOR FISCAL YEAR (UNIVERSITY COMMUNITIES) 1,538,377,384 2006 2011 2016 37,922,484 49,380,638 38,998,251 11,127,730 13,537,720 11,989,029 8,113,430 8,417,821 8,013,530 9,728,391 9,098,042 DEKALB CHAMPAIGN URBANA CHARLESTON BLOOMINGTON DeKalb and Urbana experienced declines in industrial assessed valuation between 2011 and 2016. Champaign experienced tremendous growth in industrial assessed valuation between 2011 and 2016. 58  Industrial Assessed Value of Taxable Property for Fiscal Year 2016 1,538,377,384 38,998,251 11,989,029 8,013,530 Champaign DeKalb Bloomington Urbana DeKalb ranks 2nd in industrial assessed value but is only 25% of Champaign’s industrial assessed value. 59 Pensions Employer Contributions for IMRF All comparable communities increased Illinois Municipal Retirement 2006 2011 2016 Fund (IMRF) contributions between 2006 and 2011 and between DeKalb 995,369 1,012,131 1,122,559 2011 and 2016. Batavia 737,959 914,496 981,899 Belvidere 317,526 448,219 Carpentersville 422,294 572,580 659,799 Crystal Lake 1,116,146 1,390,362 Elk Grove 905,947 1,425,084 2,647,031 Hanover Park 640,492 685,332 950,875 Hoffman Estates 1,090,910 1,431,656 1,743,250 Rolling Meadows 1,000,809 1,077,388 1,201,445 Romeoville 679,884 1,062,441 1,380,697 St. Charles 1,249,748 1,478,679 1,610,740 Streamwood 502,094 677,610 971,995 Sycamore 240,347 296,295 371,340 Wheaton 1,017,427 1,379,976 1,391,069 EMPLOYER CONTRIBUTIONS FOR IMRF 905,947 1,090,910 1,425,084 1,249,748 1,017,427 995,369 1,116,146 1,000,809 679,884 737,959 1,431,656 1,478,679 1,379,976 1,012,131 640,492 1,077,388 1,062,441 502,094 1,390,362 2,647,031 914,496 422,294 1,743,250 1,610,740 1,122,559 317,526 685,332 1,201,445 677,610 240,347 1,391,069 981,899 572,580 950,875 1,380,697 296,295 448,219 659,799 971,995 371,340 2006 2011 2016 60  University Communities – Employer Contributions for IMRF All university communities increased IMRF contributions between 2006 2006 2011 2016 and 2011 and between 2011 and 2016. DeKalb 995,369 1,012,131 1,122,559 Bloomington 2,349,425 3,494,133 3,951,246 Charleston 387,734 525,284 552,229 Champaign 1,611,238 2,221,754 2,392,432 Urbana 766,964 982,107 1,269,129 EMPLOYER CONTRIBUTIONS FOR IMRF 3,951,246 3,494,133 2,349,425 2,392,432 2,221,754 2006 1,611,238 1,269,129 2011 1,012,131 1,122,559 995,369 982,107 2016 766,964 525,284 552,229 387,734 DEKALB BLOOMINGTON CHARLESTON CHAMPAIGN URBANA 61 Funding Rate for IMRF 2006 2011 2016 DeKalb 100.00% 83.42% 81.80% All comparable communities had fully funded IMRF pension plans in Batavia 100.00% 107.82% 84.70% Belvidere 100.00% 84.20% 2006. In 2016, the communities have funded rates ranging between Carpentersville 100.00% 100.00% 86.74% 80.07% and 89.32%. Crystal Lake 71.23% 83.01% Elk Grove 100.00% 100.00% 86.93% Hanover Park 100.00% 86.00% 84.01% Hoffman Estates 100.00% 98.00% 83.80% Rolling Meadows 100.00% 90.54% 85.23% Romeoville 100.00% 100.00% 80.07% St. Charles 100.00% 100.00% 85.28% Streamwood 100.00% 89.00% 84.33% Sycamore 100.00% 88.00% 88.36% Wheaton 100.00% 100.00% 89.32% 100.00% FUNDING RATES FOR IMRF 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 107.82% 100.00% 100.00% 86.00% 98.00% 90.54% 100.00% 89.00% 88.00% 100.00% 83.42% 100.00% 84.20% 71.23% 81.80% 84.70% 86.74% 86.93% 84.01% 83.80% 85.23% 85.28% 84.33% 88.36% 89.32% 80.07% 83.01% 2006 2011 2016 62  University Communities – All university communities had fully funded IMRF pension plans in Funding Rates for IMRF 2006. In 2016, the communities have funded rates ranging 2006 2011 2016 between 81.80% and 86.94%. DeKalb 100.00% 83.42% 81.80% Bloomington 100.00% 88.19% 86.20% Charleston 100.00% 97.00% 85.58% Champaign 100.00% 100.00% 86.94% Urbana 100.00% 94.00% 85.31% FUNDING RATES FOR IMRF 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 97.00% 94.00% 88.19% 86.20% 85.58% 86.94% 83.42% 85.31% 81.80% 2006 2011 2016 DEKALB BLOOMINGTON CHARLESTON CHAMPAIGN URBANA 63 Unfunded Liability for IMRF 2006 2011 2016 DeKalb 4,603,233 9,157,004 9,961,368 Batavia 1,706,440 6,764,380 7,151,191 Unfunded IMRF liability for all comparable communities had grown Belvidere 3,650,134 3,386,517 substantially since 2006. DeKalb’s unfunded liability has more than Carpentersville 422,232 3,548,613 3,629,660 doubled since 2006. The unfunded liability for many communities has Crystal Lake 8,976,345 10,390,342 increased between 400% and 600%. Elk Grove 3,528,861 13,313,273 10,581,775 Hanover Park 1,690,487 8,011,352 7,694,890 Hoffman Estates 3,479,984 12,324,688 12,009,200 Rolling Meadows 4,530,426 12,049,696 9,975,524 Romeoville 2,420,502 6,706,742 9,241,171 St. Charles 2,960,311 11,051,305 12,229,685 Streamwood 399,637 6,964,541 6,370,850 Sycamore 173,853 2,221,266 2,078,628 Wheaton 1,288,665 9,974,336 8,565,106 13,313,273 UNFUNDED LIABILITY FOR IMRF 12,324,688 11,051,305 12,049,696 8,976,345 12,009,200 4,603,233 9,974,336 10,581,775 9,975,524 2,420,502 12,229,685 8,011,352 1,706,440 10,390,342 6,964,541 8,565,106 9,157,004 6,706,742 7,694,890 4,530,426 6,370,850 6,764,380 3,650,134 422,232 3,528,861 3,479,984 9,961,368 2,960,311 173,853 1,690,487 9,241,171 1,288,665 3,386,517 3,548,613 7,151,191 2,221,266 399,637 2006 3,629,660 2,078,628 2011 2016 64  University Communities – Unfunded Liability for IMRF Unfunded IMRF liability for all university communities had grown 2006 2011 2016 substantially since 2006. DeKalb’s unfunded liability has more than DeKalb 4,603,233 9,157,004 9,961,368 doubled since 2006. The unfunded liability for Champaign Bloomington 8,907,858 35,496,747 23,428,321 increased by more than $16 million. Charleston 1,636,393 4,553,888 4,388,274 Champaign 443,411 13,062,753 16,687,186 Urbana 1,845,271 8,638,400 8,668,246 UNFUNDED LIABILITY FOR IMRF 35,496,747 23,428,321 16,687,186 2006 13,062,753 2011 9,157,004 9,961,368 8,907,858 8,638,400 8,668,246 2016 4,603,233 4,553,888 4,388,274 1,636,393 1,845,271 443,411 DEKALB BLOOMINGTON CHARLESTON CHAMPAIGN URBANA 65 Employer Contributions for Police Pension Fund 2006 2011 2016 All comparable communities increased Police Pension Fund DeKalb 749,471 1,342,558 1,622,105 contributions between 2006 and 2011. Except St. Charles, all Batavia 777,012 1,219,262 1,808,325 comparable increased Police Pension Fund contributions Belvidere 885,875 1,079,609 Carpentersville 1,023,148 1,667,375 2,346,705 between 2011 and 2016. Crystal Lake 1,040,962 1,778,970 Elk Grove 952,813 1,995,569 2,226,035 Hanover Park 1,124,952 1,302,480 2,153,658 Hoffman Estates 1,471,015 2,497,419 3,228,471 Rolling Meadows 494,978 2,245,217 3,104,921 Romeoville 777,284 1,538,004 1,696,960 St. Charles 972,113 1,556,450 1,540,294 Streamwood 753,613 1,437,310 2,265,811 Sycamore 182,266 293,554 391,470 Wheaton 1,100,000 1,887,986 2,000,982 EMPLOYER CONTRIBUTIONS FOR POLICE PENSION FUND 1,471,015 2,245,217 1,023,148 2,497,419 753,613 1,995,569 1,124,952 777,012 3,104,921 1,100,000 749,471 1,667,375 1,040,962 2,226,035 777,284 972,113 1,302,480 3,228,471 1,437,310 1,887,986 1,342,558 1,219,262 885,875 1,538,004 1,556,450 2,346,705 1,778,970 952,813 2,153,658 2,000,982 1,622,105 1,808,325 1,079,609 1,696,960 1,540,294 2,265,811 494,978 182,266 293,554 2006 391,470 2011 2016 66  University Communities – All university communities increased Police Pension Fund Employer Contributions for Police Pension Fund contributions between 2006 and 2011. Except Urbana, all 2006 2011 2016 comparable increased Police Pension Fund contributions between DeKalb 749,471 1,342,558 1,622,105 2011 and 2016. Bloomington 1,953,492 4,111,770 4,690,359 Charleston 282,367 529,835 730,357 Champaign 2,925,758 3,690,543 5,455,449 Urbana 1,403,958 1,981,806 1,396,843 EMPLOYER CONTRIBUTIONS FOR POLICE PENSION FUND 5,455,449 4,690,359 4,111,770 3,690,543 2,925,758 2006 1,953,492 1,981,806 1,622,105 2011 1,342,558 1,403,958 1,396,843 2016 749,471 730,357 529,835 282,367 DEKALB BLOOMINGTON CHARLESTON CHAMPAIGN URBANA 67 Funding Rates for Police Pension Fund 2006 2011 2016 DeKalb 100.23% 99.58% 47.10% Batavia 99.02% 100.00% 53.20% Like DeKalb, many comparable communities had fully funded Police Belvidere 102.72% 58.20% Pension plans in 2006 and/or 2011. However by 2016, funding rates Carpentersville 86.50% 99.96% 52.39% dropped dramatically ranging between DeKalb’s 47.10% and Crystal Lake 55.48% 57.77% Streamwood’s 61.53%. Elk Grove 103.20% 104.90% 51.79% Hanover Park 118.17% 100.00% 54.12% Hoffman Estates 99.61% 100.83% 60.70% Rolling Meadows 68.89% 107.41% 50.30% Romeoville 99.90% 99.97% 61.53% St. Charles 99.76% 99.98% 49.79% Streamwood 102.80% 105.80% 61.90% Sycamore 107.20% 77.80% 58.25% Wheaton 102.16% 100.00% 59.00% FUNDING RATES FOR POLICE PENSION FUND 118.17% 107.41% 107.20% 103.20% 102.80% 102.72% 100.23% 99.02% 99.61% 99.90% 99.76% 102.16% 86.50% 104.90% 100.00% 105.80% 100.00% 99.58% 100.00% 100.83% 77.80% 99.97% 99.98% 99.96% 68.89% 58.20% 60.70% 61.53% 61.90% 59.00% 55.48% 53.20% 54.12% 58.25% 47.10% 52.39% 57.77% 51.79% 50.30% 49.79% 2006 2011 2016 68  University Communities – Funding Rates for Police Pension Fund Like DeKalb, most university communities had fully funded Police Pension plans in 2006 and/or 2011. However by 2016, funding 2006 2011 2016 rates dropped dramatically ranging between Charleston’s 36.07% DeKalb 100.23% 99.58% 47.10% to Urbana’s 68.6%. DeKalb’s funding rate in 2016 was 47.10%. Bloomington 108.51% 100.64% 49.80% Charleston 90.10% 76.00% 36.07% Champaign 145.23% 133.93% 73.16% Urbana 132.40% 139.20% 68.60% FUNDING RATES FOR POLICE PENSION FUND 145.23% 139.20% 133.93% 132.40% 108.51% 100.23% 99.58% 100.64% 90.10% 76.00% 73.16% 2006 68.60% 2011 47.10% 49.80% 2016 36.07% DEKALB BLOOMINGTON CHARLESTON CHAMPAIGN URBANA 69  Unfunded Liability for Police Pension Fund 2006 2011 2016 DeKalb 9,151,686 13,967,807 32,197,930 Batavia 9,088,382 15,291,965 24,101,519 Unfunded Police Pension liability for all comparable Belvidere 9,851,638 13,386,846 communities grew substantially since 2006. DeKalb’s unfunded Carpentersville 16,342,552 19,117,852 33,571,081 liability increased more than 350% while Sycamore’s unfunded Crystal Lake 18,066,611 24,677,865 liability increased more than 700%. Elk Grove 12,264,740 28,076,290 65,600,563 Hanover Park 9,259,783 16,156,172 25,268,664 Hoffman Estates 19,478,947 34,120,588 46,206,322 Rolling Meadows 29,592,959 12,953,912 37,295,637 Romeoville 8,972,160 13,421,388 21,496,873 St. Charles 10,449,466 14,152,354 29,676,393 Streamwood 7,800,156 15,320,644 27,259,383 Sycamore 1,185,574 2,917,500 8,382,443 Wheaton 4,190,858 22,202,964 32,705,597 65,600,563 UNFUNDED LIABILITY FOR POLICE PENSION FUND 19,478,947 16,342,552 29,592,959 9,151,686 34,120,588 10,449,466 4,190,858 12,264,740 9,259,783 7,800,156 9,088,382 18,066,611 19,117,852 12,953,912 8,972,160 13,967,807 22,202,964 14,152,354 15,291,965 9,851,638 24,677,865 16,156,172 46,206,322 15,320,644 28,076,290 13,421,388 33,571,081 37,295,637 1,185,574 32,197,930 29,676,393 2006 13,386,846 25,268,664 27,259,383 32,705,597 24,101,519 21,496,873 2,917,500 2011 8,382,443 2016 70  University Communities – Unfunded Police Pension liability for all university communities Unfunded Liability for Police Pension Fund grew substantially since 2006. DeKalb’s unfunded liability 2006 2011 2016 increased more than 350% while Urbana’s was overfunded by DeKalb 9,151,686 13,967,807 32,197,930 nearly $2.8 million in 2006, but had an unfunded liability of $16 Bloomington 27,241,249 37,844,830 64,590,330 million in 2016. Charleston 5,620,072 9,549,468 20,422,014 Champaign 7,273,004 24,696,387 32,976,770 Urbana -2,840,919 -4,616,230 16,004,791 UNFUNDED LIABILITY FOR POLICE PENSION FUND 64,590,330 37,844,830 32,197,930 32,976,770 27,241,249 24,696,387 2006 20,422,014 16,004,791 2011 13,967,807 9,151,686 9,549,468 2016 5,620,072 7,273,004 -2,840,919 -4,616,230 DEKALB BLOOMINGTON CHARLESTON CHAMPAIGN URBANA 71 Employer Contributions for Firefighters' Pension Fund 2006 2011 2016 DeKalb 1,062,734 2,001,368 2,158,156 All comparable communities increased Fire Pension Fund Batavia 429,456 697,577 805,379 Belvidere 882,299 783,447 contributions between 2006 and 2011. Except Elk Grove and Carpentersville 421,208 720,927 1,107,232 Belvidere, all comparable communities increased Fire Pension Crystal Lake 819,655 1,555,655 Fund contributions between 2011 and 2016. Elk Grove 1,049,747 2,131,657 844,917 Hanover Park 367,369 698,763 1,220,758 Hoffman Estates 1,347,220 2,488,676 2,867,272 Rolling Meadows 500,086 2,213,935 3,245,390 Romeoville 116,796 326,594 351,767 St. Charles 605,537 1,236,962 1,162,413 Streamwood 600,828 1,059,356 1,474,025 Sycamore 284,343 417,580 579,310 Wheaton 750,000 982,397 1,010,419 EMPLOYER CONTRIBUTIONS FOR FIREFIGHTERS' PENSION FUND 2,213,935 1,347,220 3,245,390 1,062,734 1,049,747 2,488,676 2,001,368 819,655 2,131,657 367,369 605,537 600,828 2,867,272 421,208 750,000 1,059,356 2,158,156 1,555,655 429,456 882,299 698,763 1,236,962 844,917 982,397 720,927 284,343 500,086 1,474,025 697,577 783,447 116,796 1,010,419 1,162,413 417,580 1,107,232 1,220,758 2006 805,379 326,594 579,310 351,767 2011 2016 72  University Communities - Employer Contributions for Firefighters' Pension Fund All university communities increased Fire Pension Fund 2006 2011 2016 contributions between 2006 and 2011. Except Urbana, all DeKalb 1,062,734 2,001,368 2,158,156 university communities increased Fire Pension Fund Bloomington 1,851,299 3,140,710 4,416,266 contributions between 2011 and 2016. Charleston 391,116 603,285 637,009 Champaign 1,903,310 3,486,399 3,363,170 Urbana 1,032,024 1,483,810 1,038,747 EMPLOYER CONTRIBUTIONS FOR FIREFIGHTERS' PENSION FUND 4,416,266 3,486,399 3,363,170 3,140,710 2,158,156 2,001,368 2006 1,851,299 1,903,310 1,483,810 2011 1,062,734 1,032,024 1,038,747 2016 603,285 637,009 391,116 DEKALB BLOOMINGTON CHARLESTON CHAMPAIGN URBANA 73 Funding Rates for Firefighters' Pension Fund 2006 2011 2016 DeKalb 100.23% 99.58% 37.40% Like DeKalb, many comparable communities had fully funded Fire Batavia 105.69% 101.17% 66.00% Pension plans in 2006 and/or 2011. However by 2016, funding Belvidere 121.70% 52.80% rates dropped dramatically ranging between DeKalb’s 37.40% and Carpentersville 77.10% 99.96% 62.34% Streamwood’s 68.51%. Only Romeoville was unique maintaining a Crystal Lake 60.99% 68.14% funding rate at 95.12%. Elk Grove 103.50% 105.60% 49.83% Hanover Park 112.44% 100% 57.42% Hoffman Estates 100.99% 100.57% 65.20% Rolling Meadows 77.65% 104.01% 42.61% Romeoville 100.45% 99.96% 95.12% St. Charles 99.79% 99.98% 68.46% Streamwood 105.70% 106.30% 68.51% Sycamore 108.50% 80.70% 56.29% Wheaton 117.26% 100.00% 68.31% FUNDING RATES FOR FIREFIGHTERS' PENSION FUND 105.69% 121.70% 103.50% 112.44% 105.70% 108.50% 117.26% 100.99% 77.65% 100.23% 100.45% 77.10% 99.79% 100.00% 99.96% 105.60% 99.58% 101.17% 100% 100.57% 99.98% 106.30% 80.70% 99.96% 104.01% 95.12% 60.99% 66.00% 65.20% 68.51% 68.31% 52.80% 57.42% 68.46% 62.34% 68.14% 49.83% 56.29% 37.40% 42.61% 2006 2011 2016 74  University Communities – Funding Rates for Firefighters' Pension Fund Like DeKalb, all but Champaign had over 95% funded Fire 2006 2011 2016 Pension plans in 2006. However by 2016, funding rates dropped DeKalb 100.23% 99.58% 37.40% dramatically with Charleston at 36.72%, DeKalb at 37.40% and Bloomington 108.85% 100.78% 45.41% Bloomington at 45.41%. Only Urbana was able to maintain over Charleston 98.20% 75.10% 36.72% 80% funding rate in 2016. Champaign 70.07% 90.20% 72.30% Urbana 123.30% 124.70% 82.69% FUNDING RATES FOR FIREFIGHTERS' PENSION FUND 123.30% 124.70% 108.85% 100.23% 99.58% 100.78% 98.20% 90.20% 82.69% 75.10% 72.30% 70.07% 2006 2011 45.41% 37.40% 36.72% 2016 DEKALB BLOOMINGTON CHARLESTON CHAMPAIGN URBANA 75 Unfunded Liability for Firefighters' Pension Fund 2006 2011 2016 DeKalb 17,514,196 24,717,144 39,321,164 Unfunded Fire Pension liability for all comparable communities Batavia 3,693,563 5,707,429 7,926,660 grew substantially since 2006. DeKalb’s unfunded liability Belvidere 7,663,869 12,076,827 increased more than 225% while Sycamore’s unfunded liability Carpentersville 3,305,653 4,296,687 12,214,388 increased more than 423%. Crystal Lake 9,609,727 12,943,084 Elk Grove 11,296,153 32,899,023 65,716,155 Hanover Park 2,789,781 5,908,438 12,752,687 Hoffman Estates 11,118,960 24,666,002 39,798,851 Rolling Meadows 14,667,478 30,637,778 39,237,063 Romeoville 963,540 403,821 402,317 St. Charles 2,658,994 4,599,962 15,186,079 Streamwood 2,776,348 10,907,535 16,370,840 Sycamore 2,224,698 4,986,375 9,515,499 Wheaton 12,625,237 7,432,612 12,603,008 65,716,155 UNFUNDED LIABILITY FOR FIREFIGHTERS' PENSION FUND 17,514,196 11,118,960 14,667,478 24,717,144 11,296,153 24,666,002 30,637,778 2,658,994 2,776,348 32,899,023 9,609,727 2,789,781 3,305,653 12,625,237 39,321,164 7,663,869 39,237,063 39,798,851 3,693,563 2,224,698 4,296,687 5,908,438 4,599,962 10,907,535 7,432,612 2006 5,707,429 12,076,827 12,943,084 4,986,375 963,540 12,603,008 12,214,388 12,752,687 15,186,079 16,370,840 2011 7,926,660 403,821 9,515,499 402,317 2016 76  University Communities – Unfunded Liability for Firefighters' Pension Fund Unfunded Fire Pension liability for all university communities 2006 2011 2016 grew substantially since 2006. DeKalb’s unfunded liability DeKalb 17,514,196 24,717,144 39,321,164 increased more than 225% and Charleston’s increased by 454%. Bloomington 27,559,680 37,640,948 59,715,325 Charleston 4,924,332 8,824,007 22,389,560 Champaign 17,708,139 16,464,274 29,285,394 Urbana -747,616 -1,870,862 8,732,709 UNFUNDED LIABILITY FOR FIREFIGHTERS' PENSION FUND 59,715,325 39,321,164 37,640,948 29,285,394 27,559,680 24,717,144 22,389,560 2006 17,514,196 17,708,139 16,464,274 2011 8,732,709 2016 8,824,007 4,924,332 -747,616 -1,870,862 DEKALB BLOOMINGTON CHARLESTON CHAMPAIGN URBANA 77 Revenue and Expenditure Projections 78  Revenue and Expenditure Projections  Revenue and Expenditure Forecasts  Baseline Forecast  Alternative Forecast  Revenues  Expenditures  Personnel Costs  Outsourcing of Service  Salaries  Bargaining Units  Wellness  Retiree Insurance  Health Insurance Plan Design 79  Revenue and Expenditure Projections Revenue and Expenditure Forecast With the beginning of the Great Recession, the City’s General Fund Balance dramatically declined from $2,161,911 in 2008 to only $22,169 in 2010. Since then, the City has succeeded in growing the fund balance to meet the City’s policy to maintain a balance of 25% of expenditures. General Fund Balance History $9,123,076 $8,374,964 $9,061,359 $8,018,755 $5,916,598 $5,177,514 $4,669,218 $2,161,911 $2,692,928 $416,652 $22,169 2008 2009 2010 2011 2012 2013 2014 2015 2016 2016.5 2017 Budget Total General Fund revenues from 2013 to 2016 have averaged 4.77% annual growth, while total General Fund expenditures have averaged 3.43% annual growth over the same period. However, General Fund Major Revenues (net of property tax) for FY2018 is projected to increase by 2.2%. Five Year Revenue and Expenditures Trend - General Fund $33,081,944 $35,175,019 $33,034,933 $28,898,412 $30,725,816 $30,744,360 $34,383,474 $31,655,635 $27,876,868 $29,010,286 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget Total Revenue, excluding transfers Total Expenditures, excluding transfers 80 The State of Illinois budget further complicates future revenue projections. The State reduced the local share of the Local Government Distributive Fund (LGDF) by 10% for State Fiscal Year 2018 and implemented a 2% administrative fee for local home rule sales taxes. The State consistently shows a willingness to consider reductions to other shared revenues. Listed below are General Fund major revenue trends. General Fund Major Revenue Trends Major Revenue Trend FY 2017 Budget FYE 2017 FY18 Projection FY18 v. FYE17 %/- Property Tax ↑ 5,565,384 5,565,384 5,937,357 6.7% Municipal Sales Tax ↑ 5,364,944 5,364,944 5,420,467 1.0% Home Rule Sales Tax ↑ 6,512,000 6,642,770 6,707,185 1.0% Local Use Tax ↑ 1,034,705 1,100,750 1,144,780 4.0% Income Tax ↓ 4,513,075 4,289,362 4,418,043 3.0% Restaurant & Bar Tax ↑ 1,935,000 1,964,381 2,003,668 2.0% Hotel/Motel Tax ↓ 290,000 261,241 261,241 0.0% Utility Tax ↓ 2,550,000 2,520,000 2,517,019 -0.1% Telecommunications Tax ↓ 819,000 752,347 737,595 -2.0% Crime Free Registration ↔ 195,000 195,000 195,000 0.0% Video Gaming Tax ↑ 205,000 208,021 245,000 17.8% Ambulance User Fees ↑ 1,060,000 1,103,829 1,269,403 15.0% Fire Services ↑ 910,000 969,951 1,004,000 3.5% TOTAL 30,954,108 30,937,980 31,860,758 3.0% TOTAL (Net Property Tax) 25,388,724 25,372,596 25,923,401 2.2% Baseline Forecast A baseline projection through 2023 was created using the following assumptions. Property tax increases cover projected Police and Fire Pensions. Sales and Use taxes increase annually by 2.5% and other revenues increase by 1.90%. Expenditures increase by 3.5% annually and Equalized Assessed Valuation (EAV) grows 2% annually. Inflation Assumptions 2018 2019 2020 2021 2022 2023 Property taxes 6.77% 5.00% 5.00% 5.00% 5.00% 5.00% Sales & Use taxes 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% Other Revenues 1.90% 1.90% 1.90% 1.90% 1.90% 1.90% Investment Income 0.50% 0.50% 0.50% 0.50% 0.75% 0.75% Expenditures 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% EAV growth 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Note: Police & Fire Pensions Levy Increase. Other levies only increase as TIF EAV realized. 81  Projection 2017 - 2023 Revenues, Expenditures & Fund Balance $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 $0 2017 2018 2019 2020 2021 2022 2023 -$10,000,000 Revenues Expenses Net Transfers In/Out Fund Balance (unassigned) Given the assumptions, each year results in deficits with the fund balance declining dramatically and depleted by 2023. Projected 2017 2018 2019 2020 2021 2022 2023 Revenues $35,175,019 $35,818,606 $36,747,847 $37,820,013 $38,824,798 $39,825,194 $41,102,873 Expenses $34,383,475 $35,766,619 $37,106,422 $38,497,519 $39,941,923 $41,441,730 $42,999,122 Net Transfers In/Out (390,863) (408,958) (399,514) (500,495) (495,767) (483,794) (1,149,978) Fund Balance (unassigned) $9,061,353 $8,704,382 $7,946,293 $6,768,292 $5,155,400 $3,055,070 $8,843 Projection 2017 - 2023 Fund Balance Decline $10,000,000 30% $8,000,000 25% 20% $6,000,000 15% $4,000,000 10% $2,000,000 5% $0 0% 2017 2018 2019 2020 2021 2022 2023 Fund Balance (unassigned) % of Fund Balance to Expense With 2% EAV growth, the property tax rate would increase from 1.2% to 1.4% to maintain annual pension levy increases of 5.0%. 82  Projection 2017-2023 Property Tax Rate $10,000,000 1.45% 1.40% $8,000,000 1.35% $6,000,000 1.30% $4,000,000 1.25% 1.20% $2,000,000 1.15% $0 1.10% 2017 2018 2019 2020 2021 2022 2023 Property Tax Levy Tax Rate Note: Assumption 2% annual EAV growth Projection 2017-2023 Pension Levy Increase $8,000,000 16% $7,000,000 14% $6,000,000 12% $5,000,000 10% $4,000,000 8% $3,000,000 6% $2,000,000 4% $1,000,000 2% $0 0% 2017 2018 2019 2020 2021 2022 2023 Pension Levy Pension Levy Increase Annual % Increase Note: Assumption only pension levy increase until TIF expiration in 2023 83  Projection 2017-2023 Pension Levy Increase $8,000,000 8% $7,000,000 7% $6,000,000 6% $5,000,000 5% $4,000,000 4% $3,000,000 3% $2,000,000 2% $1,000,000 1% $0 0% 2017 2018 2019 2020 2021 2022 2023 Police Pension Fire Pension Total Police & Fire Pension Annual % Increase The total Police and Fire Pension levy increases from $5,492,904 in 2017 to $7,485,234 in 2023. Pension levy is affected depending on an actuarial reports, actuarial assumptions, retirements and payroll of Police and Fire personnel. Alternative Forecast Below is an alternate projection through 2023. The projection was created to maintain General Fund balance near 25%. The following assumptions were utilized. Property tax increases to cover Police and Fire Pensions. Sales and Use Taxes increase annually by 5.0% and other revenues increase by 2.0%. Expenditures increase by 3.0% annually and Equalized Assessed Valuation (EAV) grows 2% annually. Inflation Assumptions 2018 2019 2020 2021 2022 2023 Property taxes 6.77% 5.00% 5.00% 5.00% 5.00% 5.00% Sales & Use taxes 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% Other Revenues 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Investment Income 0.50% 0.50% 0.50% 0.50% 0.75% 0.75% Expenditures 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% EAV growth 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Note: Police & Fire Pensions Levy Increase Only. Other levies only increase as TIF EAV realized. 84  Projection 2017 - 2023 Revenues, Expenditures & Fund Balance $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 $0 2017 2018 2019 2020 2021 2022 2023 -$10,000,000 Revenues Expenses Net Transfers In/Out Fund Balance (unassigned) Projected 2017 2018 2019 2020 2021 2022 2023 Revenues $35,175,019 $35,818,606 $37,208,044 $38,774,546 $40,309,775 $41,912,116 $43,820,631 Expenses $34,383,475 $35,622,165 $36,808,125 $38,035,531 $39,305,919 $40,620,883 $41,982,086 Net Transfers In/Out (390,863) (408,958) (399,514) (500,495) (495,767) (485,505) (1,153,511) Fund Balance (unassigned) $9,061,353 $8,848,836 $8,849,241 $9,087,761 $9,595,850 $10,401,578 $11,086,612 With these assumptions, minimal deficits occur and the fund balance is maintained at 25%. However, 5% growth of sales and use taxes is extremely aggressive with lower growth rates in sales tax between 2012 and 2016. Projection 2017-2023 Fund Balance Trend $12,000,000 $10,000,000 26.4% 26.4% $8,000,000 25.6% $6,000,000 24.8% 24.4% $4,000,000 24.0% 23.9% $2,000,000 $0 2017 2018 2019 2020 2021 2022 2023 Fund Balance (unassigned) % of Fund Balance to Expense 85 Revenues The General Fund’s major revenue categories are shown below. General Fund Revenue Sources 1. Sales & Use Taxes (41%) 6. Transfers in (4%) 2. Property Taxes (15%) 7. Other Income (3%) 3. Intergovernmental Revenues (14%) 8. Licenses & Permits (3%) 4. Franchise & Utility Tax (10%) 9. Fines (2%) 5. Service Charges & Fees (6%) DeKalb revenue is reliant on elastic funding sources for 85% of its revenue sources. With intergovernmental revenues dependent on the State Legislator and State budget, this category is more elastic than in the past. Home Rule Sales Tax History $6,673,332 $5,804,331 $6,794,013 $5,920,753 $6,511,982 $5,745,008 $5,948,654 $5,852,867 $4,248,925 $4,274,684 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 86 Home Rules Sales Tax has fluctuated over the last four years. The State of Illinois has also implemented a 2% collection fee starting SFY2018. State Sales Tax has flattened since 2015. State Sales Tax History $5,422,936 $5,289,536 $4,220,495 $3,621,333 $3,957,767 $4,458,400 $4,126,391 $3,782,236 $3,950,721 $3,871,872 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 87  Distribution of Sales Tax by SIC Code Reporting Agriculture &Manufacturers General All Others 7% Merchandise 6% Drugs & Misc. 24% Retail 15% Automotive & Food Filling Stations 12% 13% Lumber. Bldg, Furniture & Drinking and Hardware H.H & Radio Apparel Eating Place 5% 4% 2% 12% The chart above shows the type of local sales activity by percentage that generate sales tax for DeKalb. Components of the City Property Tax Levy $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $0 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Corporate GO Bonds IMRF Fire Pension Police Pension Social Security 88 The majority of the City’s property tax levy is dedicated to Police and Fire Pensions. The corporate levy for 2015 and 2016 is also dedicated to Police and Fire Pensions. Levies for Social Security and IMRF pension have been nearly eliminated. The General Obligation (GO) Bonds shown in 2013 through 2016 are dedicated to the construction of the Library on behalf of the Library Board. Income and Use Tax History $5,434,596 $5,503,607 $4,918,760 $4,982,520 $4,592,427 $4,225,360 $4,835,866 $4,246,923 $4,389,337 $4,017,481 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Income and Use Tax have shown flat growth. Telecommunications Tax History $1,073,724 $1,008,801 $948,051 $876,405 $849,837 2012 2013 2014 2015 2016 The Telecommunications Tax is consistently declining. 89 Expenditures The General Fund’s expenditures by departments are shown below. A combined 74% is expended on Public Safety and Public Works. General Fund Expenditures 1. Police (35%) 6. Community Development (4%) 11. Legislative (.5%) 2. Fire (29%) 7. City Manager Office (3%) 3. Public Works (10%) 8. IT (3%) 4. General Fund Support (7%) 9. Finance (2%) 5. Transfers Out (5%) 10. Human Resources (1%) Total General Fund revenues from 2013 to 2016 have averaged 4.77% annual growth. Five Year Revenue and Expenditures Trend - General Fund $33,081,944 $35,175,019 $33,034,933 $28,898,412 $30,725,816 $30,744,360 $34,383,474 $31,655,635 $27,876,868 $29,010,286 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget Total Revenue, excluding transfers Total Expenditures, excluding transfers 90 Outstanding Bonded Debt (As of 7/17/2017) Original Current Final Optional Par Amount Outstanding Coupon Range Maturity Redemption General Obligation Bonds, Series 2010A (Downtown TIF, 12 Yr bonds) $ 10,800,000 $ 5,200,000 4.00% - 4.00% 12/1/2021 Non-Callable General Obligation Refunding Bonds, Series 2010B (Pub. Works, 18 Yr Refi CAB bonds) $ 3,905,000 $ 3,905,000 4.25% - 4.75% 1/1/2028 Non-Callable Taxable General Obligation Refunding Bonds, Series 2010C (Pub. Works, PD station, 13 Yr Refi bonds) $ 5,415,000 $ 4,065,000 4.35% - 5.90% 1/1/2023 Non-Callable General Obligation Bonds, Series 2012A (PD station, 17 Yr bonds) $ 9,905,000 $ 7,405,000 2.00% - 2.63% 1/1/2030 1/1/2023 General Obligation Bonds, Series 2013A (DeKalb Library, 20 Yr bonds) $ 6,685,000 $ 5,870,000 3.00% - 4.00% 1/1/2033 1/1/2023 General Obligation Bonds, Series 2013B (PD station, 9 Yr bonds) $ 2,380,000 $ 2,320,000 1.50% - 3.00% 1/1/2022 Non-Callable $ 28,765,000 DeKalb’s debt service payments decline in 2023 with expiration of Downtown TIF bonds. Other General Obligation debt continues steady until 2027 after which debt payment reduce from nearly $2.5 million to $1.5 million. Debt Payments - Total Principal & Interest 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 2010A 2010B 2010C 2012A 2013A 2013B Personnel Costs The biggest single driver of City operating expenditures is personnel costs and particularly employee salaries. Municipal government is mostly service based and labor intensive. In large departments such as the Police and Fire Departments, personnel costs make up over 95% of operating budget expenditures. The current City’s workforce is comprised of 221 full-time equivalent (FTE) positions breakdown as follows: 40.5% from Police, 26.7% from Fire, 19.3% from Public Works and 13.5% from all other departments (Community Development, Finance, Human Resources, Information Technology and the City Manager’s Office). Since FY08, the City’s workforce has been reduced by approximately 13%. There have been 91 several reductions in force since FY08, and there were fewer City positions budgeted in FY17 than there were in FY08. Compared to FY08, the pre-recession era, the City is doing more with less in order to continue to provide responsive City services to the community. The City has shifted personnel costs from full-time to part-time positions. Compared to FY08, full-time positions were reduced by 15.3%, while part-time positions increased by 15%. Size of the City’s Workforce Size City's Workforce Fiscal FT PT FTEs 300 Year FY08 234 40 254 200 FY09 225 33 241.5 100 FY10 218 33 234.5 0 FY11 188 32 204 FY12 186 34 203 Fiscal Year FY13 187 53 213.5 FY14 195 58 224 FT PT FTEs FY15 197 63 228.5 FY16 199 65 231.5 FY16.5 200 65 232.5 FY17 198 46* 221 *Decrease due crossing guard services being outsourced in August 2017. The size of the City’s workforce data does not include DeKalb Sycamore Area Transportation Study (DSATS) personnel. DSATS staff salaries and benefits are funded entirely through federal and state grants. The City budget does not include any reimbursements from the General Fund for these positions. Wage Growth- All funds $17,275,013 $16,992,928 $15,545,704 $17,378,294 $18,368,083 $16,410,946 $16,650,470 $17,656,341 $16,744,278 $16,741,218 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 92  Outsourcing of Services The City of DeKalb continues to explore and evaluate opportunities to outsource services. During FY14, the City outsourced certain aspects of the Building Division and Crossing Guard services during FY17. Salaries The City of DeKalb employs a range of personnel in a variety of capacities, in order to provide the public with City services. To attract and retain the quality work force necessary for delivering quality services, the City seeks to remain competitive with neighboring jurisdictions and the labor market in general. In 2014, a Pay and Compensation Study was commissioned by the City Council to address compensation inequalities between collective bargaining units and non-bargaining unit employees. From FY02 to FY17, the compounded annual compensation increases for collective bargaining unit employees have exceeded the compensation increases for non-bargaining unit employees by 36.66%. NBU AFSCME FOP IAFF Increase Increase Differential Increase Differential Increase Differential FY02 2.00% 5.00% (3.00%) 5.00% (3.00%) 5.50% (3.50%) FY03 2.00% 5.00% (3.00%) 5.00% (3.00%) 5.00% (3.00%) FY04 2.00% 2.00% 0.00% 5.00% (3.00%) 5.00% (3.00%) FY05 0.00% 4.00% * (4.00%) 4.00% (4.00%) 5.00% (5.00%) FY06 2.00% 4.00% * (2.00%) 3.75% (1.75%) 4.00% (2.00%) FY07 0.00% 4.00% * (4.00%) 3.75% (3.75%) 3.50% (3.50%) * FY08 3.16% 6.00% * (2.84%) 4.00% (0.84%) 5.00% (1.84%) FY09 3.73% 4.00% (0.27%) 3.00% 0.73% 4.00% (0.27%) FY10 0.00% 4.00% (4.00%) 0.00% 0.00% 4.00% (4.00%) FY11 0.00% 1.50% (1.50%) 2.50% (2.50%) 4.00% (4.00%) FY12 1.33% 1.50% (0.17%) 2.50% (1.17%) 0.00% 1.33% FY13 2.00% 2.00% 0.00% 2.50% (0.50%) 2.00% 0.00% FY14 2.00% 2.00% 0.00% 2.50% (0.50%) 2.50% (0.50%) FY15 1.50% 2.00% (0.50%) 2.50% (1.00%) 2.25% (0.75%) FY16 2.50% 2.25% 0.25% 2.50% 0.00% 2.50% 0.00% FY16.5 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% FY17 2.50% 2.00% 0.50% 1.25% 1.25% 1.25% 1.25% Average 1.67% 3.20% (1.53%) 3.11% (1.44%) 3.47% (1.80%) Compd. Avg. 30.22% 65.37% (35.15%) 63.00% (32.78%) 72.26% (42.04%) Average Differential (36.66%) * AFSCME increases were 2% in July and 2% in January 93  ** AFSCME increases were 2% in July 2007 and 4% in January 2008 Based on the Study recommendations and approval by the Council, the City made adjustments to its compensation policy to ensure that compensation and benefits afforded to non- bargaining unit employees were commensurate with internal data, market data and wage policies from comparable municipalities. In addition to maintaining the pay plans, the City has also implemented a performance management program that will assist in transitioning to a pay for performance model. When the pay for performance system is fully implemented, non-bargaining unit employees will only receive performance based pay increases. As a note, non-bargaining unit employees previously received both an economic adjustment each year and a merit increase on their anniversary. This practice was eliminated during FY16 as a result of the Pay and Compensation Study because salaries were made more market competitive. Over the past two years, total employee salary costs have increased by 2.5% on average. In the five‐year baseline forecast, employee salaries are projected to increase by 2.5% per year in the next three years. The appropriate maintenance of the City’s pay plans and the establishment of a performance management program aligns with the DeKalb 2025 Strategic Plan vision of efficient, quality, responsive services and the goal of achieving the highest possible standards of public administration through sound Human Resources practices. The City must maintain its competitiveness with other municipalities and internal equity with bargaining units in order to retain and recruit a talented work force. Bargaining Units Employees of the City of DeKalb are represented by three bargaining units:  AFSCME: American Federation of State, County and Municipal Employees Union Local #813 represents all employees from Public Works, Finance, Information Technology and Police Telecommunications and Records, except managerial, supervisory, professional and confidential positions. AFSCME represents a total of 46 employees.  IAFF: International Association of Firefighters, Local 1236 represents all active full- time employees of the Fire Department who holds certificate of appointment by the Board of Fire and Police Commissioners, excluding the Fire Chief and Deputy Fire Chiefs. IAFF represents a total of 54 employees.  FOP: Fraternal Order of Police Lodge 115 represents all Sergeants and Police Officers. FOP represents a total of 58 employees. Bargaining unit increases are based upon collective bargaining agreements. Bargaining unit employees receive a wage adjustment each year in addition to step increase. The step 94 increase is an advancement in the salary schedule on anniversary date of appointment. Bargaining unit members reach the top of the pay range within eight years of employment. Negotiated bargaining unit increases are as follows: FY18 FY19 FY20 Average AFSCME 2.25% 2.50% 2.50% 2.42% IAFF 2.50% 2.50% 2.50% 2.50% FOP 2.50% 2.50% n/a 2.50% Wellness The City recognizes that our most valuable resource is our employees, and their health and wellness has a direct impact on the continued success of the City of DeKalb in the delivery of City services and is directly linked to healthcare costs. In 2017, the City initiated a Wellbeing Program. Representatives from all City department, including bargaining unit and non- bargaining unit employees, comprise the Wellbeing Team. The team’s goal is to promote and support wellness programs that encourage emotional, physical, financial, social and career wellbeing for its employee and families. Through the City’s membership with the Intergovernmental Personnel Benefits Cooperative (IPBC), the City introduced a comprehensive and integrated health management and preventive wellness solution. In 2017, biometric screenings were offered to all City employees and dependents covered through the City’s health insurance plan. While the program is in its infancy, based on our historical knowledge of the healthcare industry, the City believes a comprehensive and progressive wellness program has the opportunity to yield long term cost savings. The program also serves to engage employees and all covered lives in cost reduction and their own wellbeing. Retiree Insurance In December 2008, the City commissioned Executive Partners, Inc. (EPI) to review and evaluate the financial practices of the City. EPI recommended steps that could be taken to reverse the City’s budget deficit and create a sustainable long-term financial plan. One of EPI’s key recommendations was that the City eliminate the retiree health subsidy. The City has made progress in reducing its financial exposure for retiree insurance benefits. In 2014, the City concluded a five year phase out of subsidized retiree dependent coverage. Previously, retirees paid only a portion of the cost for dependent coverage. As of March 1, 2014 any retiree electing dependent coverage is required to pay the full premium cost. In 2012, the City implemented a plan to reduce future obligations for retiree insurance benefits. This plan provides a phase out of subsidized benefits based on an employee’s hire date. Under 95 this plan, the City has no obligation to subsidize benefits for future employees. Retiree Benefit after Medicare FOP Retiree Benefit until Medicare Age Age Hired Prior to 50% employee/20% spouse/0% 100% employee/0% spouse/0% Tier 1 3/1/86 dependent dependent Hired 3/1/86 to 50% employee/20% spouse/0% $2,000/year for Medicare Tier 2 7/1/01 dependent Supplement Hired 7/1/01 to $2,000 deferred comp match while Tier 3 7/1/11 employed No City Contribution Hired on/after Tier 4 7/1/11 No City Contribution No City Contribution Retiree Benefit after Medicare IAFF Retiree Benefit until Medicare Age Age Hired Prior to 50% employee/20% spouse/0% 100% employee/0% spouse/0% Tier 1 3/1/86 dependent dependent Hired 3/1/86 to 50% employee/20% spouse/0% $2,000/year for Medicare Tier 2 7/1/01 dependent Supplement Hired 7/1/01 to $2,000 deferred comp match while Tier 3 7/1/11 employed No City Contribution Hired on/after Tier 4 7/1/11 No City Contribution No City Contribution Retiree Benefit after Medicare AFSCME Retiree Benefit until Medicare Age Age Tier 1 N/A N/A N/A Hired Prior to $2,000/year for Medicare Tier 2 1/1/91 80% employee Supplement $2,000 deferred comp match while employed Hired 1/1/91 to $3,000 deferred comp match while Tier 3 12/31/11 employed No City Contribution 96  Hired on/after Tier 4 1/1/12 No City Contribution No City Contribution Retiree Benefit after Medicare NBU Retiree Benefit until Medicare Age Age Hired Prior to Tier 1 3/1/86 80% employee 100% employee $2,000 deferred comp match while employed Hired 3/1/86 to $2,000/year for Medicare Tier 2 12/31/01 80% employee Supplement $2,000 deferred comp match while employed Hired 1/1/02 to $3,000 deferred comp match while Tier 3 12/31/11 employed No City Contribution Hired on/after Tier 4 1/1/12 No City Contribution No City Contribution Health Insurance Plan Design In 2014, the City added a Medicare supplement plan for retirees over age 65. The reduced premium costs and plan design have provided a significant savings to the City, as well as retirees. In 2016, the City implemented various cost-saving options for health insurance benefits. A HMO and HDHP (high deductible health plan) were added to allow for cost-savings for the City as well as the employee. A HDHP provides a higher deductible and a lower premium cost than a traditional insurance plan. The IRS defines a HDHP as any plan with a deductible of at least $1,300 for single coverage or $2,600 for family coverage. The HDHP offers a health savings account that allows employees to contribute pre-tax dollars to use for current or future medical expenses. In 2016, IAFF employee contributions changed from a percent of base salary to a percent of premium. This change in contribution allows the City to better budget health insurance costs. It also allows for a change in contribution based on the premium increase each year, rather than a salary increase. FOP will change to percent of premium in 2018. In 2017, the City added an insurance opt-out program. Employees that choose to decline City 97 insurance coverage and can provide proof of other coverage will receive an incentive. This is a significant savings compared to the cost of the annual insurance premium. The City could see a savings up to 94% of the premium cost. The City continues to research benefit options that will reduce the cost for the City and employees. Health Insurance Cost Year Employee Coverage Retiree Coverage Total 2012 $3,361,590 $1,261,041 $4,622,631 2013 $3,699,413 $1,024,727 $4,724,140 2014 $3,625,770 $1,243,473 $4,869,243 2015 $3,593,477 $1,258,057 $4,851,534 2016 $3,598,465 $1,222,298 $4,820,763 2016.5 $1,715,882 $718,024 $2,433,906 2017 Budget $3,880,570 $1,316,700 $5,197,270 Health Insurance Costs $6,000,000 $5,000,000 $4,000,000 Retiree Coverage $3,000,000 Employee Coverage $2,000,000 $1,000,000 $0 2012 2013 2014 2015 2016 2016.5 2017 Budget 98 Streets and Fleet Analysis 99  Streets and Fleet Analysis  Fleet Inventory  Fleet Condition Assessment  Level of Service  Replacement Cost  Street Inventory  Pavement Condition Assessment  Level of Service  Pavement Management Plan 100  Streets and Fleet Analysis – Preliminary Asset Management Plan In 2017, the Public Works and Finance Departments, along with consultants from Engineering Enterprises, Inc. (EEI) and Ehlers, Inc. (Ehlers), developed a preliminary Asset Management Plan (AMP) for Streets and Fleet. EEI was engaged to perform the street portion of the plan. EEI has performed similar evaluations for other municipalities using the same software used by the City. The preliminary, high-level AMP examines the City’s needs for maintaining streets and replacing fleet over the next 10 years. The AMP also presents options for dedicated revenue sources to fund the improvements including local gas tax, vehicle stickers, trash hauler fees and sales tax with resident rebate. Staff and the consultants presented the preliminary plan at the Special Committee of the Whole on August 31, 2017. The preliminary AMP is a first draft of ideas for addressing the deterioration of the City’s streets and fleet. It incorporates input from residents received during two public outreach meetings, even though only eight residents attended these meetings. As a background, Asset Management (AM) is a set of coordinated activities designed to optimize the benefits derived from an asset. At its core, AM is about effectively managing City- owned assets over the long-term. The AMP sets forth ideas and principles to manage municipal infrastructure in a financially sustainable manner that meets the needs and expectations of residents. The preliminary AMP consists of four primary elements: 1. Asset Inventory and Condition Assessment 2. Expected Level of Service 3. Asset Management Strategy 4. Financial Strategy The asset inventory and condition assessment define the asset in terms of type, age, value, maintenance and other key characteristics. The expected level of service defines the performance goals of the asset. Together, the condition assessment and expected level of service are used to determine the financial resources required to meet expectations. The financial strategy lays out the funding plan for investing in the asset at the level required to meet the level of service objectives. Fleet Inventory The Public Works Department maintains a fleet database that includes the following information for all City vehicles: Equipment ID Chassis Description Asset Type Purchase Price 101  Purchase Year Age Useful Life Replacement Year Current Replacement Value Mileage (or Hours of Service) Cost of Maintenance Cost of Fuel Total Operating Cost The data was reviewed and evaluated as part of the fleet inventory. The current fleet consists of 173 units with a replacement value of approximately $12 million. The table below shows the number of units, percentage of total number of units, replacement cost and percentage of total replacement costs for nine categories. Category No. of Units % Replacement Cost % Fire Trucks 11 6.3% $3,934,842 32.8% Dump Trucks 23 13.3% $2,165,276 18.1% Trucks MD/HD 25 14.5% $1,756,722 14.7% SUV 33 19.1% $1,070,714 8.9% Construction 15 8.7% $1,018,477 8.5% L. Duty/Van 16 9.2% $706,001 5.9% Sedans 29 16.8% $664,750 5.5% Other 12 6.9% $406,883 3.4% Grounds Eq. 9 5.2% $258,761 2.2% TOTALS 173 $11,982,426 Each unit in the fleet was assigned to one of the nine general fleet categories described below. Fire Trucks – These are highly specialized vehicles used to respond to emergencies. Currently, the City owns 11 units with a replacement value of over $3.9 Million. The average age of the Fire Trucks is 13 years. The useful lives range between 15 to 20 years. Trucks Medium Duty/Heavy Duty – This class of vehicle includes light dump trucks, heavy duty pick-up trucks and specialty trucks. Uses for the light dump trucks include road repairs, asphalt hauling and storm water inlet construction. The heavy duty pick-ups are used to haul personnel, materials and equipment to and from work sites. The specialty trucks include aviation fuel trucks, de-icing truck, ambulances, flatbeds, aerial trucks, vac-all and the Police paddy wagon. These types of vehicles are used by Airport (3), Fire (6), Street (9), Police (1) and Utilities (6). The average age of the Medium and Heavy Duty Trucks is 14.8 years. Useful life ranges from 7 to 10 years for ambulances, heavy duty pick-ups and light dump trucks and 10 to 20 years for specialty trucks. Heavy Dump Trucks – These vehicles have a gross vehicle weight (GVW) of at least 33,000 pounds and a load carrying capacity of 10 tons. Heavy dump trucks are used to tow leaf 102 vacuums and leaf boxes during the fall season, large loads of rock salt during the winter and heavy loads and tow equipment trailers throughout the year. The exposure to salt causes the frame and other steel parts of these dump trucks to deteriorate faster than normal vehicles. The Utility Division has one heavy dump truck and the Airport has three older (more than 20 years old) heavy dump trucks. The Street Division requires at least 16 heavy dump trucks during the fall and winter for leaf and snow plowing/salting. Currently, the Street Division has 19 units on hand, two of which are 20 years old. The average age of the Street Division Heavy Dump Trucks is 12.6 years. The useful life of a heavy dump truck is 10 years. Construction – These units are mobile on-road and off-road equipment that is used to dig, load and carry large loads over short distances. The inventory includes tractors, backhoes, loaders, graders, vibratory rollers and excavators. These type of vehicles are used by Street (11) and Utilities (4). The average age of the construction equipment is 16.5 years. The useful life of this equipment is generally from 10 to 15 years. SUV – These four wheel drive sports utility vehicles are larger than, and provide more passenger room and better off road performance than traditional sedans or pick-up trucks. Because of their size, SUVs are highly visible and provide the operator with better visibility than sedans. These type of vehicles are used in the City Hall pool (3), IT (1), CD (1), Airport (2), DSATS (1), Fire (8), Street (5), Police (7) and Utilities (3). Six of the vehicles used by the Police Department are used for patrol cars. The average age of SUVs is 11.6 years. The useful lives for this class of vehicle is generally 10 years. Light Duty Trucks/Vans – This class of vehicle may be equipped with either two or four wheel drive and may have an extended cab capable of carrying a crew of five personnel along with light hand equipment or materials. These type of vehicles are used by Airport (2), Fire (1), Street (7), Police (2) and Utilities (4). The average age of these vehicles is 12.6 years. The typical useful life of this class of vehicle is 10 years. Sedans – This class of vehicle is used as almost exclusively by the Police Department. Currently, 26 of the 29 sedans are used by the Police Department. One is assigned to the Airport as a courtesy car and two are assigned to Community Development. The vehicles are used by detectives, commanders, school resources officers and for the resident officer program. Three of these vehicles are used as patrol cars. The older sedans are reassigned to the Community Development Department. The average age of these vehicles is 6.4 years. The typical useful life of this class of vehicle is eight to 10 years and four years for patrol cars. Other – These units include specialized equipment including two Harley Davidson motorcycles, two street sweepers, three forklifts, floor cleaner, scissor lift and a line laser truck used for roadway striping. These units are used by Airport (1), Street (6), Police (4) and Utilities (2). The average age of these vehicles is 11.4 years. The typical useful life of this class is seven to 15 years. Grounds Equipment – The equipment of this class includes tractors, motorized mowing 103 equipment and a motorized Airport runway broom. These units are used by Airport (5), Street (2) and Utilities (2). The average age of these vehicles is 13.9 years. The typical useful life of this class is five to 15 years. A summary of the number of units assigned to various departments and divisions is presented in the table below. Category Street Police Fire Utilities Airport Other TOTALS Fire Trucks - - 11 - - - 11 Dump Trucks 19 - - 1 3 - 23 Trucks MD/HD 9 1 6 6 3 - 25 SUV 5 7 8 3 2 8 33 Construction 11 - - 4 - - 15 L. Duty/Van 7 2 1 4 2 - 16 Sedans - 26 - - 1 2 29 Other 6 4 - 1 1 - 12 Grounds Eq. 2 - - 2 5 - 9 TOTALS 59 40 26 21 17 10 173 Fleet Condition Assessment Based on the input from residents, the condition of the fleet was evaluated using age, useful life, mileage (or hours of service) and annual maintenance costs. Historical trends such as average age, number of units beyond the recommended useful life and annual maintenance were also evaluated. These historical data indicate a declining fleet condition since about 2006. The decline corresponds to the same time that the City stopped systematically replacing vehicles beyond the useful life. Prior to 2006, the City replaced most of its fleet at the end of its useful life. The average age of the fleet increased from 5.7 years to 10.7 years between 2006 and 2016 as shown by the graph to the right. This trend is a consequence of allowing vehicles to age beyond their useful life before replacing them. The consistent increase in average age from year to year indicates this practice continued for several years. 104 The number of vehicles that are beyond their useful life also increased from 2006 to 2016. The graph to the right shows that in 2006 there were 18 vehicles in the fleet that were beyond their useful life. That number steadily increased to 95 in 2016. There are 173 units in the fleet. Currently about 55% of the fleet is beyond its useful life. This trend suggests there were on average seven to eight vehicles per year that were not being replaced during the last 10 years. Older vehicles require frequent maintenance and major repairs. The graph of total annual costs to maintain the fleet confirms this. It shows that from 2006 to 2016 the annual maintenance cost of the fleet increased from about $220,000 per year to about $312,000 per year. If the fleet is allowed to continue to age, maintenance costs will continue to increase. However, the greater concern is the impact of breakdowns on the delivery of services, particularly with respect to public safety. Staff evaluated each unit in the fleet using a condition rating system. These type of systems are commonly used by municipalities for fleet evaluations. Using this system, staff assigned points for age of the unit compared to useful life, mileage or hours of service and annual maintenance costs compared to value. The table below summarizes the point system. Criteria Points Age 1 point for every 10% of useful life, plus 2 points per year in service beyond the useful life. Use 1 point for every 10,000 miles or 300 hours of service. Maintenance Cost 1 point for maintenance cost <14% of value 2 points for maintenance costs 15 to 29% of value 3 points for maintenance costs 30 to 44% of value 4 points for maintenance costs 45 to 59% of value 5 points for maintenance costs 60 to 74% of value 105  6 points for maintenance costs 75 to 89% of value 7 points for maintenance costs 90 to 99% of value 2 points for every 5% beyond 100% To illustrate this system, consider a unit that is at the end of its useful life. That unit would receive 10 points for age (one point for every 10% of the useful life). Additionally, assume the unit has 150,000 miles (or 4,500 hours of service), which are both high amounts. The unit would be assessed another 15 points. Lastly, assume the amount of annual maintenance on the unit was equal to the value of the unit. That would earn the unit another 7 points for a total of 32 points. That unit would be at the entry point of the declining category using the following rating system. Rating Points Good <16 Average 16 – 31 Declining 32 – 42 (needs replacing) Critical 43+ (needs replacing) The result of applying this scoring system to the City fleet is shown on the 38% adjacent graph. Approximately 36% of 26% the fleet is in declining or critical 20% condition. Replacing the units that are 16% in declining or critical conditions would cost approximately $4.3 million, given the total fleet value is $12 million. <16 16 - 31 32 - 42 43+ The decline in condition of the fleet Good Average Declining Critical corresponds to a reduction in fleet replacement expenditures. The following graph illustrates fleet expenditures that were planned based on replacing vehicles at, or near, their useful life versus actual expenditures. The graph demonstrates a significant reduction in fleet replacement expenditures since 2008. From 2002 to 2007, fleet expenditures average about $710,000. Adjusting for inflation, that level of spending (in 2007) is the equivalent of about $860,000 today. From 2008 to 2017, fleet expenditures average just under $300,000. The difference between planned and actual expenditures increases after 2009. Prior to 2009, the difference is about $190,000, whereas, after 2009, the difference is about $500,000. 106  Fleet Cost (Planned) Fleet Cost (Actual) $2.0 Millions $1.5 $1.0 $0.5 $0.0 2002 2004 2006 2008 2010 2012 2014 2016 Level of Service Public meetings on May 23 and 25, 2017 solicited residents’ input on several aspects of the preliminary AMP for streets and fleet. During the meetings, staff presented the planning process and preliminary findings from the asset inventory and condition assessment. The meeting featured an interactive format in which staff presented information and the audience indicated their preference regarding several options. Staff also presented information concerning historical funding for fleet replacement. The following planning principles were identified as important to the participants of the survey.  The most important criteria for assessing vehicle condition are Useful Life and Maintenance Costs.  The most important criterion for fleet level of service is Safety followed by Reliability and Functionality. The most important policy for fleet replacement is Availability of Funds followed by Maintenance Costs.  Nearly all respondents agreed that annual maintenance costs of a particular vehicle should not exceed the value of the vehicle. Based on these planning principles the following preliminary levels of service are proposed. 1. Fleet vehicles should be replaced before they reach the end of their useful life unless there are specific reasons to keep the vehicles. 2. Fleet vehicles should be evaluated for safety, reliability and functionality as part of routine maintenance. 107  3. Fleet replacement schedules should be adjusted regularly to accommodate the availability of funds. 4. Replacement schedules should include consideration of maintenance costs. 5. Fleet vehicles that cost more to maintain than they are worth should be given priority in the fleet replacement schedule. Replacement Cost Each City department submitted a fleet replacement schedule based on replacing most of the units that were beyond their useful life over the next three years. The cost of this aggressive replacement schedule is shown graphically below. The replacement schedule assumes that some vehicles being replaced will be retained for use as pool cars. The first year of this replacement schedule is just over $2.5 million. The second and subsequent years of the schedule are closer to $1.5 million. The average over five years is $1.65 million. The impact of this aggressive replacement schedule on the average age of the fleet is shown on the following graph. It shows that the average age of the vehicles used by Street, Police and Fire would be reduced from current higher than desired levels to near the same average age of vehicles in 2006. Namely, for Street, the average age of vehicles would drop from 14.5 to 7.2 years. The average age in 2006 was 7.1 years. Likewise, for Police, the average age would drop from 6.1 to 3.7 years. The average age was 3.3 years in 2006. Lastly, for Fire, it would reduce the average age of vehicles from 11.1 to 6.7 years. The average age in 2006 was 4.8 years. 108  Street Police Fire 16 14 Average Age (Years) 12 10 8 6 4 2 0 2006 2008 2010 2012 2014 2016 2018 2020 2022 Recognizing that an average expenditure of $1.65 million per year for fleet may not be attainable. A more conservative replacement schedule was developed. In this scenario, each department reevaluated their needs, limiting replacement requests to those that were considered critical. The resulting replacement cost schedule is shown graphically below. The average age of the fleet in this scenario increases by about one year in 2022 compared to the aggressive replacement scenario. 109 Street Inventory The inventory and condition assessment of City-owned streets was conducted by EEI using data collected by Infrastructure Management Services, Inc. (IMS) during three separate surveys conducted over the past four years. As part of the surveys, IMS identified all roadways in the City’s network, assigned them a unique identifier, listed their physical characteristics (length, width, etc.) and attributes (pavement type, traffic and functional classification) and linked the network to the City’s GIS map. The condition of the roads was evaluated using specialized survey equipment referred to as a Laser Road Surface Tester (RST). This equipment was used to collect observations on the condition of the pavement surface, as well as collect digital imagery and spatial coordinate information. Additionally, deflection testing and analysis was performed to measure the strength of the pavement base. There are approximately 130 centerline miles of roads owned and maintained by the City. The functional classification of these roads are shown on the map and listed below:  Residential: 97.3 miles (74.8%)  Collector: 10.1 miles (7.7%)  Arterial: 22.7 miles (17.5%) Pavement Condition Assessment The key pavement condition data elements collected by the Laser RST include roughness (bumps per mile) and distress (cracking, potholes, raveling, etc.). The condition data for each City block was used to create a single score representing the overall condition of the pavement for that City block. The scores, ranging from 10 to 100, are referred to as the Pavement Condition Index (PCI). The PCI of a road can be used to characterize the condition of the pavement using the following six categories: PCI Rating 86 – 100 Excellent 80 – 85 Very Good 70 – 79 Good 60 – 69 Fair 40 – 59 Poor 10 – 39 Very Poor 110 The following pictures and descriptions of road surface, remaining life and maintenance activities are representative of several qualitative rating categories. Very Good to Excellent (PCI 80 – 100) Near perfect condition. Very minor defects may be present. Comfortable to drive. The remaining life is 15 to 25 years. Little to no maintenance required when new. Requires routine maintenance such as crack and joint sealing. Good (PCI 70-79) Structurally sound. Cracking and other minor distresses are present. Road still feels smooth to drive. The remaining life is 12 to 18 years. Routine maintenance such as patching and crack sealing with surface treatments. Fair (60-69) Structural damage may be present. Cracking and other minor distresses are extensive. Road may feel rough. The remaining life is 8 to 15 years. Heavier surface treatments and thin overlays. Localized panel replacements. Poor (PCI 40 – 59) Structural damage is extensive. The road is very rough. The remaining life is 5 to 10 years. Heavy surface-based inlays or overlays with localized repairs. Moderate to extensive panel replacements. 111 The table and graph below illustrate the distribution of pavement condition for the roadway network in DeKalb using the scale described previously. The average PCI for the City’s road network is currently 78. Approximately 25.7 miles of roads have a PCI less than 70. These roads need immediate maintenance to prevent further degradation. If the roads are allowed to continue to deteriorate, they will require higher levels maintenance (or reconstruction) at higher costs in the future. PCI Rating Miles % 86 - 100 Excellent 13.9 10.7% 80 – 85 Very Good 49.7 38.2% 70 - 79 Good 40.8 31.4% 60 - 69 Fair 16.3 12.5% 40 – 59 Poor 7.4 5.7% 10 - 39 Very Poor 2.0 1.5% 38.2% 31.4% 10.7% 12.5% 5.7% 1.5% 86 - 100 80 – 85 70 - 79 60 - 69 40 – 59 10 - 39 Pavement Condition Index The need for immediate maintenance on 25.7 miles of City streets is largely the result of a lack of funding for street maintenance over the past several years. The next graph shows street maintenance expenditures per year from 1992 to 2007. The average annual expenditure for this period is $860,000 per year. If inflation is considered, the $1.0 million spent in 1994 is the 112 equivalent of about $1.65 million in today’s dollars. $2.0 Aggregate MFT Local Gas Tax TIF Funds Millions $1.5 $1.0 $0.5 $0.0 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994 1993 1992 Level of Service Public meetings were held on May 23 and 25, 2017, to solicit resident’s preferences and opinions on several aspects of the preliminary AMP for streets and fleet. The following planning principles were identified as more important to the participants of the survey.  Most respondents believe the PCI of City streets is between 60 and 70 (on a scale of 10 to 100). The calculated PCI is 78.  Seventy-five percent (75%) of respondents believe the average PCI of City streets should be 10 points higher than it is now.  Most respondents believe 10% of City streets should have a PCI rating of less than 60. Currently, 18% of City streets have a PCI of less than 60.  Respondents believe funds should be prioritized to address Arterials and Collectors, ahead of Residential streets.  The majority of respondents believe it should take five years to “fix” DeKalb’s streets. Based on these planning principles, the following preliminary levels of service are proposed: 1. The average PCI for City streets should be 75 to 80. 2. No more than 10% of City streets should be in Poor condition or lower (PCI less than 60). 3. Annual street maintenance programs should prioritize Arterials and Collectors, ahead of Residential streets. 113  4. Street maintenance should significantly improve the conditions of City streets in five years or less. Pavement Management Plan A Pavement Management System (PMS) is a planning tool used to assist municipalities with the task of building and maintaining roadways. A PMS provides a means to collect, store, organize and analyze pavement condition information and help plan for preventative and future maintenance. Research and experience has shown it is far less expensive to maintain a road in good condition than it is to allow a road to deteriorate before repairing it as outlined in the graph below. Pavement Management Systems place priority on maintaining these good condition roads, which over the long-term will effectively provide a higher condition roadway at a lower cost. 120 100 Time for Preventative Time for Measures ($0.15-$1.00/SF) Resurfacing ($1.50 - $4.00/SF) 80 Time for Reconstruction RANK ($6.00 - $12.00/SF) 60 Standard Pavement Rank Reduction Curve 40 20 0 0 5 10 15 20 25 Time (Years) The IMS software used to store the street inventory and pavement condition data was employed in simulating several pavement maintenance scenarios along and estimating the associated costs. The scenarios were completed using certain rehabilitation strategies, average regional unit rates and pavement performance curves. A total of eight scenarios were evaluated. The scenario description, average annual street maintenance expenditures and the average road network PCI rating after five years and after 10 years are presented in the following chart. 114  Maintenance Scenarios with Resulting Average Expenditures Average Annual Street Avg. Avg. No. Scenario Description Maintenance PCI @ PCI @ Expenditures 5Yrs 10Yrs 1 Maintain the current rank of 78* $7,052,400 78 71 2 Maintain the rank at 70 $7,021,300 76 70 3 Increase rank to 80** $6,931,500 79 71 Maintain current spending amount 4 $1,403,200 70 59 ($1.2M + engineering) Resurface entire system over 20 years 5 $3,830,300 72 63 ($29.28/SY) Double amount in Scenario 5/Year 1, 6 then split the remaining costs over 19 $3,940,800 73 64 yrs. 7 Maintain the rank at 65 $4,622,400 73 65 8 Spend $2.5M per year $2,587,100 71 61 Notes: 1) These scenarios were run with only a resurfacing (3"/3") option. No reconstruction option was included. * Not achievable at 10 years without reconstruction. Estimate $13 million including reconstruction. ** Not achievable at five years without reconstruction. Estimate $13.5 million including reconstruction. The average annual street maintenance expenditures for each of the scenarios above is graphed versus average PCI for the road network at five and 10 years below. At Year 5 At Year 10 85 Average Pavement Condition Index 80 75 70 65 60 55 50 $0.0 $2.0 $4.0 $6.0 $8.0 Average Annual Street Maintenance Expenditure (Millions) 115 The red squares represent the average PCI at the end of five years given the corresponding average street maintenance expenditures of a particular scenario. The red dashed line shows the best-fit linear trend. Similarly, the blue circles represent the average PCI at the end of 10 years given the corresponding average street maintenance expenditures of a particular scenario. The blue dashed line shows the best-fit linear trend. The scenarios that meet resident’s level of service expectations after five years include scenarios 1, 2 and 3. These scenarios require over $7 million dollars of expenditures on street maintenance per year. Given the current maintenance program is only $1.3 million, it may not be reasonable to expect such a large increase in annual expenditures to be possible. Therefore, a more conservative scenario has been selected for inclusion in the preliminary financial management plan. Scenario 5, with an average annual expenditure of approximately $3.8 million, is included in the preliminary financial management plan. This scenario keeps the average PCI for City streets above 70 for the next five years. It represents a significant increase in current street maintenance expenditures and would produce noticeable improvements throughout the City. 116  Alternative Funding 117  Alternative Funding  Intergovernmental Agreements – Revenue Sharing  DeKalb Market Square Agreements  Peace Road Interchange Improvements  DeKalb County Home Agreement  Sycamore Boundary Agreement  General Fund Stabilization – Property Tax Levy  Streets and Fleet Funding  Streets and Fleet Conclusions  Alternative Funding Policy Conclusions 118  Alternative Funding Policy Considerations Intergovernmental Agreements – Revenue Sharing In the past, the City approved revenue sharing agreements with DeKalb County and the City of Sycamore. The intended purpose of each agreement with DeKalb County was to facilitate economic development projects or provide infrastructure. The intent of the boundary agreement with the City of Sycamore was also to enhance economic development and intergovernmental cooperation through revenue sharing within a specific area bordering both communities. Listed below is a short synopsis of each agreement and its associated financial impact to date and projected to the end of the agreements. In particular, the City should more thoroughly review the Peace Road Interchange Improvement agreement with DeKalb County for opportunities to end the agreement. DeKalb Market Square Agreements and the Peace Road Interchange Resolution 1993-115, Passed October 11, 1993 – An intergovernmental agreement and annexation agreement was approved by the City and the County (owner of the property) including 138 acres of property located at Barber Greene Road and Route 23. The 40 year agreement is effective from the date of passage on October 11, 1993. The City and the County agreed to equally share sales tax revenues generated from development on the property. The following sales taxes are shared equally: City’s Municipal Retailers’ Occupation Tax (1%), City’s Home Rule Sales Tax (.75%) and the County’s Sales Tax (.25%). The City’s payments (“City Share”) to the County have been at least $1.1 million per year since 2011 with 2014 being an exception. The County’s payments (“County Share”) to the City have been at least $125,000 since 2011 with 2014 being an exception. The net amount paid by the City to the County has been close to $1 million per year since 2010. Through 2016, a total of $20.7 million has been paid to the County and a total of $2.3 million has been received from the County since the start of this agreement. Projections to the end of the agreement in October of 2033, indicate the City will pay the County $40,352,840 and the County will pay the City $4,619,953. The net payments by the City are projected to total $35,732,866. 119 Tax Sharing Analysis DeKalb Market Square Resolution 93-115 City Share County Share Net Paid Year 50% Sales Tax 50% Sales Tax by City 1997 $235,977.31 $24,609.01 $211,368.30 1998 $753,761.50 $78,200.50 $675,561.00 1999 $765,779.00 $88,675.00 $677,104.00 2000 $821,661.00 $94,010.00 $727,651.00 2001 $850,154.00 $95,830.00 $754,324.00 2002 $926,726.86 $103,109.55 $823,617.31 2003 $719,600.24 $79,154.67 $640,445.57 2004 $943,515.07 $110,438.81 $833,076.26 2005 $1,235,943.83 $138,331.04 $1,097,612.79 2006 $1,615,006.07 $176,888.42 $1,438,117.65 2007 $1,383,536.02 $158,899.70 $1,224,636.32 2008 $1,358,715.06 $154,820.40 $1,203,894.66 2009 $1,294,528.23 $146,850.08 $1,147,678.15 2010 $1,239,505.92 $141,975.89 $1,097,530.03 2011 $1,197,385.48 $136,050.00 $1,061,335.48 2012 $1,120,365.00 $128,907.51 $991,457.49 2013 $1,099,069.24 $126,550.39 $972,518.85 2014 $866,898.03 $104,902.54 $761,995.49 2015 $1,110,996.20 $128,538.97 $982,457.23 2016 $1,152,013.88 $129,107.75 $1,022,906.13 Projected 2017 $1,111,000.00 $128,500.00 $982,500.00 Projected 2018 $1,116,555.00 $129,142.50 $987,412.50 Projected 2019 $1,122,137.78 $129,788.21 $992,349.56 Projected 2020 $1,127,748.46 $130,437.15 $997,311.31 Projected 2021 $1,133,387.21 $131,089.34 $1,002,297.87 Projected 2022 $1,139,054.14 $131,744.79 $1,007,309.36 Projected 2023 $1,144,749.41 $132,403.51 $1,012,345.90 Projected 2024 $1,150,473.16 $133,065.53 $1,017,407.63 Projected 2025 $1,156,225.53 $133,730.86 $1,022,494.67 Projected 2026 $1,162,006.65 $134,399.51 $1,027,607.14 Projected 2027 $1,167,816.69 $135,071.51 $1,032,745.18 Projected 2028 $1,173,655.77 $135,746.86 $1,037,908.91 Projected 2029 $1,179,524.05 $136,425.60 $1,043,098.45 Projected 2030 $1,185,421.67 $137,107.73 $1,048,313.94 Projected 2031 $1,191,348.78 $137,793.27 $1,053,555.51 Projected 2032 $1,197,305.52 $138,482.23 $1,058,823.29 Projected 2033 $1,203,292.05 $139,174.64 $1,064,117.41 Total $40,352,839.80 $4,619,953.46 $35,732,886.34 120 Resolution 1996-001, Passed January 8, 1996 – An addendum to the original 1993 Intergovernmental Agreement. Walmart is listed as a “known” store to develop on the property. The City and the County agreed to each expend $500,000 toward public improvements. Resolution 2002-095, Passed October 14, 2002 – A second amendment to the original 1993 Intergovernmental Agreement. The amendment is limited to Lot #12 of DeKalb Market Square (Kohl’s). The City and the County agreed to jointly fund and share equally in the cost of infrastructure improvements up to a total of $1,550,000 to be paid in cash or in the form of sales tax rebates of one-half of City/County sales tax receipts for a period of up to eight years following the opening of the store. The last payment to Kohl’s was on September 27, 2013 for the period of December 2012 through February 2013. The total paid to Kohl’s was $609,301.16. Resolution 02-95 COMPLETED in 2013 City Share Kohl's Res. 02-95 Year 50% Sales Tax $80,000.00 2004 $21,187.87 $70,000.00 2005 $64,016.04 $60,000.00 2006 $71,979.01 $50,000.00 2007 $75,603.30 $40,000.00 2008 $72,393.37 $30,000.00 2009 $67,552.96 $20,000.00 2010 $66,058.59 $10,000.00 2011 $64,521.24 $0.00 2012 $55,369.67 City Share 2013 $50,619.11 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 Total $609,301.16 Peace Road Interchange Improvements Peace Road Interchange - Resolution 2004-031, Passed May 24, 2004 – A second intergovernmental agreement with DeKalb County was passed to share the City’s Home Rule Sales Tax generated at the DeKalb Market Square property. The City’s payments cover costs associated with the Illinois Toll Highway Authority installing Peace Road Interchange Improvements. In December 1997, the City entered into an agreement with the Illinois Toll Highway Authority agreeing to pay them in excess of $2,300,000 by June 2004. The County agreed to participate in repayment of the City’s debt. However, the City would provide additional City Home Rule Sales Tax revenues to the County. The City increased the City’s Home Rule Sales Tax from .75% to 1.25%. The City and County equally share the additional .50% City Home Rule Sales Tax. The agreement has a clause stipulating in the event the City repeals the .50% sales tax increase, every payment made to the County from the City would be applied to the principal balance due to the County. Thus, each payment made reduces the principal dollar for dollar. At the time the City repeals the .50% sales tax, the remaining balance, if any, would be subject to a 4% 121 simple interest. However, no additional interest would accrue beyond May 24, 2014 (10 years from execution of agreement). The terms of this agreement continue throughout the 40 year term set in the original 1993 DeKalb Market Square Intergovernmental Agreement. Approximately $250,000 is paid annually to the County and a total of approximately $3.4 million has been paid between 2004 and 2016. The table shows the City has paid more than $3.4 million dollars versus the $2.3 million provided by the County in 2004. As of 2012, the City met the obligation by paying $2,410,343. Peace Road Interchange Improvements Resolution 04-31 City Share City Share Year 50% Sales Tax To Date 2004 $110,838.00 $110,838.00 2005 $290,174.00 $401,012.00 2006 $279,098.00 $680,110.00 2007 $317,791.00 $997,901.00 2008 $309,581.00 $1,307,482.00 2009 $293,161.00 $1,600,643.00 2010 $283,920.00 $1,884,563.00 2011 $267,385.00 $2,151,948.00 2012 $258,395.00 $2,410,343.00 2013 $253,101.00 $2,663,444.00 2014 $251,248.00 $2,914,692.00 2015 $255,784.00 $3,170,476.00 2016 $215,566.00 $3,386,042.00 Projected 2017 $250,000.00 $3,636,042.00 Projected 2018 $251,250.00 $3,887,292.00 Projected 2019 $252,506.25 $4,139,798.25 Projected 2020 $253,768.78 $4,393,567.03 Projected 2021 $255,037.63 $4,648,604.66 Projected 2022 $256,312.81 $4,904,917.47 Projected 2023 $257,594.38 $5,162,511.85 Projected 2024 $258,882.35 $5,421,394.20 Projected 2025 $260,176.76 $5,681,570.96 Projected 2026 $261,477.64 $5,943,048.60 Projected 2027 $262,785.03 $6,205,833.64 Projected 2028 $264,098.96 $6,469,932.59 Projected 2029 $265,419.45 $6,735,352.05 Projected 2030 $266,746.55 $7,002,098.60 Projected 2031 $268,080.28 $7,270,178.88 Projected 2032 $269,420.68 $7,539,599.56 Projected 2033 $270,767.79 $7,810,367.35 Total $7,810,367.35 For perspective, if the City had borrowed $2.3 million in 2004 at a 4% interest rate and 10 year term, annual payments would have been $283,569 and principal and interest payments for 10 122 years would total $2,835,691 (reference below – $2.3M Loan table). However, the City’s actual payments to the County totaled $2,914,691 by year 2014 (reference above – Peace Road Interchange Improvement table). As another example, if the City had borrowed $2.3 million in 2004 at a 4% interest rate and 12 year term, annual payments would have been $245,070 and principal and interest payments for 10 years would total $2,940,839 (reference below - $2.3M Loan table). However, the City’s actual payments to the County totaled $3,170,476 by year 2015 (reference above– Peace Road Improvement table). $ 2,300,000 Loan with Annual Payments $ 2,300,000 Loan with Annual Payments 4% Interest Rate Compounded Annually 4% Interest Rate Compounded Annually 10 Years 12 Years Year Payment Principal Paid Interest Paid Remaining Balance Year Payment Principal Paid Interest Paid Remaining Balance 1 $283,569.17 $191,569.17 $92,000.00 $2,108,430.83 1 $245,070.00 $153,070.00 $92,000.00 $2,146,930.00 2 $283,569.17 $199,231.94 $84,337.23 $1,909,198.89 2 $245,070.00 $159,192.80 $85,877.20 $1,987,737.20 3 $283,569.17 $207,201.21 $76,367.96 $1,701,997.68 3 $245,070.00 $165,560.51 $79,509.49 $1,822,176.69 4 $283,569.17 $215,489.26 $68,079.91 $1,486,508.42 4 $245,070.00 $172,182.93 $72,887.07 $1,649,993.76 5 $283,569.17 $224,108.83 $59,460.34 $1,262,399.59 5 $245,070.00 $179,070.25 $65,999.75 $1,470,923.51 6 $283,569.17 $233,073.19 $50,495.98 $1,029,326.40 6 $245,070.00 $186,233.06 $58,836.94 $1,284,690.45 7 $283,569.17 $242,396.11 $41,173.06 $786,930.29 7 $245,070.00 $193,682.38 $51,387.62 $1,091,008.07 8 $283,569.17 $252,091.96 $31,477.21 $534,838.33 8 $245,070.00 $201,429.68 $43,640.32 $889,578.39 9 $283,569.17 $262,175.64 $21,393.53 $272,662.69 9 $245,070.00 $209,486.86 $35,583.14 $680,091.53 10 $283,569.20 $272,662.69 $10,906.51 $0.00 10 $245,070.00 $217,866.34 $27,203.66 $462,225.19 11 $245,070.00 $226,580.99 $18,489.01 $235,644.20 Totals $2,835,691.73 $2,300,000.00 $535,691.73 12 $245,069.97 $235,644.20 $9,425.77 $0.00 Totals $2,940,839.97 $2,300,000.00 $640,839.97 It appears the City has fully paid the debt intended by this agreement. The City should thoroughly review the Peace Road Interchange Improvement agreement with DeKalb County for the opportunity to end the agreement. Otherwise, if the agreement and trend continues until expiration of the original 1993 Intergovernmental Agreement, the City could pay a total of approximately $7.8 million through Year 2033 for the benefit of $2.3 million received in 2004. DeKalb Market Square Res. 93-115/Peace Road Interchange Improvements Res. 04-31 $1,800,000.00 $1,600,000.00 $1,400,000.00 $1,200,000.00 $1,000,000.00 $800,000.00 $600,000.00 $400,000.00 $200,000.00 $0.00 City Share 50% Sales Tax County Share 50% Sales Tax City Share 50% Sales Tax 123 DeKalb County Home Agreement Resolution 1999-038, Passed June 28, 1999 – An Intergovernmental Agreement entered into with DeKalb County. DeKalb County agreed to purchase a 9.8 acre parcel of property to construct and relocate a new County Nursing Home and Health Center. The nursing home location at that time was a prime location for economic development. The nursing home was vacated and the property was developed for commercial development. The City agreed to assist the County with its bond obligations for the new County Nursing Home by equally sharing sales tax revenues of City’s Municipal Retailers’ Occupation Tax (1%), City’s Home Rule Sales Tax (as amended, currently 1.75%) and the County’s Sales Tax (.25%) for a term of 20 years from the issuance of the first occupancy permit for a minimum of 50,000 square feet. The County shares its property lease proceeds with the City. The City also receives an annual credit for municipal services ranging from $25,000 to $40,000 during the 20 year agreement. The City’s payments to the County have averaged $225,000 per year. However, the City receives an average of $108,000 from the County each year for a net average payment of $117,000 per year to the County. From 2002 to 2016, a total of $2.8 million has been paid to the County and a total of $1.54 million has been received from the County. If trends continue as shown below, at the end of the agreement in 2021, the City will pay the County a total of $4,045,728 and receive $2,115,016 from the County for estimated net total payments to the County totaling $1,930,723. DeKalb County Home Resolution 99-38 Year 2021 End Date City Share County Share Lease Proceeds Municipal Svcs County to City City Year 50% Sales Tax 50% Sales Tax to City to City Total Net Total 2002 $72,146.13 $10,280.58 $52,500 $25,000 $87,781 ($15,634) 2003 $84,028.35 $11,969.10 $87,500 $25,000 $124,469 ($40,441) 2004 $122,215.52 $16,360.92 $52,500 $25,000 $93,861 $28,355 2005 $157,362.68 $17,409.29 $52,500 $25,000 $94,909 $62,453 2006 $180,165.30 $19,926.52 $48,000 $25,000 $92,927 $87,239 2007 $184,270.57 $20,404.94 $39,375 $30,000 $89,780 $94,491 2008 $173,493.28 $19,165.66 $58,875 $30,000 $108,041 $65,453 2009 $249,102.04 $23,356.16 $52,500 $30,000 $105,856 $143,246 2010 $245,499.10 $22,246.75 $52,500 $30,000 $104,747 $140,752 2011 $242,740.74 $21,982.53 $52,500 $30,000 $104,483 $138,258 2012 $229,871.86 $20,798.79 $52,500 $35,000 $108,299 $121,573 2013 $208,928.50 $18,898.86 $52,500 $35,000 $106,399 $102,530 2014 $178,886.32 $16,221.79 $52,500 $35,000 $103,722 $75,165 2015 $212,804.26 $19,193.98 $52,500 $35,000 $106,694 $106,110 2016 $254,223.44 $23,049.65 $52,500 $35,000 $110,550 $143,674 Projected 2017 $250,000.00 $22,000.00 $52,500 $40,000 $114,500 $135,500 Projected 2018 $250,000.00 $22,000.00 $52,500 $40,000 $114,500 $135,500 Projected 2019 $250,000.00 $22,000.00 $52,500 $40,000 $114,500 $135,500 Projected 2020 $250,000.00 $22,000.00 $52,500 $40,000 $114,500 $135,500 Projected 2021 $250,000.00 $22,000.00 $52,500 $40,000 $114,500 $135,500 Total $4,045,738.09 $391,265.52 $1,073,750 $650,000 $2,115,016 $1,930,723 124  DeKalb County Home Res. 99-38 $300,000.00 $250,000.00 $200,000.00 $150,000.00 $100,000.00 $50,000.00 $0.00 City Share 50% Sales Tax County Share 50% Sales Tax Lease Proceeds to City Municipal Svcs to City County to City Total DeKalb County Home Res. 99-38 $300,000.00 $250,000.00 $200,000.00 $150,000.00 $100,000.00 $50,000.00 $0.00 City Share 50% Sales Tax County to City Total Ordinance 2012-019, Passed March 26, 2012 – A Development Agreement with First Rockford Group for Ulta retail store includes a 50/50 sales tax rebate of both the City’s share and the County’s share of sales tax proceeds to First Rockford to offset build-out costs incurred. The maximum rebate would be the lesser of $153,125 or 20% of the documented build-out costs. Through 2016, $15,798 has been paid by the City and $11,271 has been paid by the County for a total of $27,070. 125 126 Sycamore Boundary Agreement The City of DeKalb and the City of Sycamore entered into an Intergovernmental Boundary Line Agreement on August 31, 1995. The current Agreement had an initial term of 20 years and was set to expire on August 31, 2015. Prior to its expiration, either party could extend it for an additional 20 year period by giving written notice to the other party within 30 days of the expiration of the initial term. At its August 17, 2015 City Council Meeting, the City of Sycamore approved Resolution 639 authorizing the extension of the Intergovernmental Boundary Line Agreement between the City of Sycamore and the City of DeKalb. This extends the Agreement for another 20 years. City staff between both municipalities have had discussions regarding revisions and will continue to do so. Any changes that both municipalities can negotiate will be brought back to both City Councils for review and action. In the interim, the existing Agreement continues. 127  Sycamore Boundary Agreement $45,000 $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 $0 2014 2015 2016 DeKalb Paid to Sycamore Sycamore Paid to DeKalb Note: Original Approval August 31, 1995 and 20 Year Renewal August 31, 2015 General Fund Stabilization – Property Tax Levy Previously in this report, a projection through 2023 was created using the following assumptions. Property tax increases cover projected Police and Fire Pensions. Sales and Use Taxes increase annually by 2.5% and other revenues increase by 1.90%. Expenditures increase by 3.5% annually and Equalized Assessed Valuation (EAV) grows 2% annually. Given the assumptions, each year results in deficits with the fund balance declining dramatically and depleted by 2023. Projected 2017 2018 2019 2020 2021 2022 2023 Revenues $35,175,019 $35,818,606 $36,747,847 $37,820,013 $38,824,798 $39,825,194 $41,102,873 Expenses $34,383,475 $35,766,619 $37,106,422 $38,497,519 $39,941,923 $41,441,730 $42,999,122 Net Transfers In/Out (390,863) (408,958) (399,514) (500,495) (495,767) (483,794) (1,149,978) Fund Balance (unassigned) $9,061,353 $8,704,382 $7,946,293 $6,768,292 $5,155,400 $3,055,070 $8,843 For policy consideration, the following projection was created using the following assumptions. Property tax increases cover projected Police and Fire Pensions. A Corporate Property tax of $900,000 is levied for FY2019 and increased annually by 2%. Sales and Use Taxes increase annually by 2.75% and other revenues increase by 2.00%. Expenditures increase by 3.0% annually and Equalized Assessed Valuation (EAV) grows 3.50% annually. This scenario holds the property tax rate under 1.5% and maintains the General Fund balance above 25% through 2022. Any EAV growth would lower projected property tax rate. 128 Inflation Assumptions 2018 2019 2020 2021 2022 2023 Property taxes 6.77% 5.00% 5.00% 5.00% 5.00% 5.00% Corporate taxes $900,000 2.00% 2.00% 2.00% 2.00% Sales & Use taxes 2.75% 2.75% 2.75% 2.75% 2.75% 2.75% Other Revenues 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Investment Income 0.50% 0.50% 0.50% 0.50% 0.75% 0.75% Expenditures 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% EAV growth 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% Note: Police & Fire Pensions 5%/yr, $900,000 corporate initial 2019 + 2%/yr) Projection 2017 - 2023 Revenues, Expenditures & Fund Balance $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 $0 2017 2018 2019 2020 2021 2022 2023 -$10,000,000 Revenues Expenses Net Transfers In/Out Fund Balance (unassigned) Projected 2017 2018 2019 2020 2021 2022 2023 Revenues $35,175,019 $35,818,606 $37,703,405 $38,851,906 $40,051,722 $41,288,478 $42,111,232 Expenses $34,383,475 $35,622,165 $36,808,125 $38,035,531 $39,305,919 $40,620,883 $41,982,086 Net Transfers In/Out (390,863) (408,958) (399,514) (500,495) (495,767) (485,505) (1,153,511) Fund Balance (unassigned) $9,061,353 $8,848,836 $9,344,602 $9,660,482 $9,910,518 $10,092,608 $9,633,621 129  Projection 2017-2023 Fund Balance $10,500,000 27% $10,000,000 26% 25% $9,500,000 24% $9,000,000 23% $8,500,000 22% $8,000,000 21% 2017 2018 2019 2020 2021 2022 2023 Fund Balance (unassigned) % of Fund Balance to Expense Projected 2017 2018 2019 2020 2021 2022 2023 Fund Balance (unassigned) $9,061,353 $8,848,836 $9,344,602 $9,660,482 $9,910,518 $10,092,608 $9,633,621 % of Fund Balance to Expense 26% 25% 25% 25% 25% 25% 23% Projection 2017-2023 Property Tax Rate $12,000,000 1.60% 1.40% $10,000,000 1.20% $8,000,000 1.00% $6,000,000 0.80% 0.60% $4,000,000 0.40% $2,000,000 0.20% $0 0.00% 2017 2018 2019 2020 2021 2022 2023 Property Tax Levy Tax Rate Projected 2017 2018 2019 2020 2021 2022 2023 Property Tax Levy $6,052,009 $6,425,432 $7,619,826 $8,059,780 $8,517,453 $8,993,667 $10,054,664 Tax Rate 1.20% 1.23% 1.41% 1.41% 1.44% 1.46% 1.46% EAV growth 7.60% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 130 Streets and Fleet Funding A preliminary financial impact has been developed by Ehlers to evaluate the impact of a dedicated funding source for fleet replacement and street maintenance. The objectives of the plan are to identify additional dedicated revenue for fleet replacement and street maintenance and develop a 10-year plan for implementing the improvements while preserving the City’s bond rating. The financial management plan was developed using a spreadsheet-based model that includes several City funds including the general fund, motor fuel tax fund, capital project fund, capital project debt service fund, vehicle and equipment fund, vehicle and equipment debt service fund, Police Pension Fund and Fire Pension Fund. Inputs to the model can be changed to simulate the impact of various scenarios. In addition, the model can be updated based on actual revenues and expenditures. Thus, the model provides the City a long-term financial forecasting tool. There are a few key assumptions made in creating the financial model. These include: 1. General Fund pays for government operations, such as public safety, community development administration and public works. 2. Fund balance policy maintained at minimum of 25% of annual expenses. Adherence is needed to maintain reserves and bond rating. 3. Revenues keep pace with expenditures, i.e. there is no structural imbalance. Assumes 2.5% increase in annual sales tax revenues, 1.9% increase annually for other revenue categories, 2.0% expense increase in all categories. 4. Revenue sources are diversified but vulnerable to annual state budget decisions and elastic. 5. Major capital projects are not funded with the General Fund revenues. 6. Levy increases 6.77% in 2018 and 5% thereafter to fund rising Pension liability. 131  General Fund Revenue Sources Intergovernmental… Property taxes… Other Income 7% Sales and Use Charges Taxes for Service 26% State Income 7% Tax 13% Other Taxes 11% A total of 59% of the General Fund revenue sources are within elastic categories: sales and use taxes (26%), intergovernmental (20%) and state income tax (13%). Property Tax Primarily Pays for Pension Obligations Projected Property Tax Levy 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 0 Pensions Library Bonds TIF Replacement Social Security The projected Property Tax Rate:  Assumes 2% EAV growth annually  Models in TIF Districts expiring in 2020 and 2023  Assumes 5% levy increase each year for Pensions 132  1.6000% 1.4000% 1.2000% 1.0000% 0.8000% 0.6000% 0.4000% 0.2000% 0.0000% Annual capital expenditures between 2018 and 2022 average $7 million. That amount includes the conservative fleet replacement schedule (average annual cost $1.4 million) and the street maintenance scenario 5 (average annual cost $3.8 million) presented earlier in this plan. Other capital expenditures include other capital improvement projects (average annual cost $0.5 million), projects funded by motor fuel tax (average annual cost $1.0 million) and equipment (average annual cost $0.3 million). The capital expenditures were inflated by 3% per year. Other key assumptions in the model include no revenue growth for home rule motor fuel tax nor for the state motor fuel tax. Other revenues are assumed to increase by 1%. The existing funding sources for capital expenditures include motor fuel tax, home rule fuel tax and existing fund balances in the motor fuel tax and the equipment funds. The annual capital expenditures described above are shown graphically along with existing funding sources for a 10-year period in the graph below. The funding gap illustrated by the graph averages about $5.4 million per year. Capital Needs vs. Existing Funding Sources Total Capital Projects Existing funding sources 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 - 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 133 Several options for new funding sources were considered as part of the financial management plan. These options are described below. Option 1: Increase the Local Motor Fuel Tax  Current local tax is 2 cents per gallon  Generates $360,000 per year  Model assumes a 4 cent increase per gallon for a total local tax of 6 cents per gallon  Will generate an additional $720,000 per year The arguments for this option are drivers will pay for streets and this represents about $0.68 on a tank of gas. The arguments against this option are revenue does not increase over time and it’s a tax increase Option 2: Vehicle Stickers  Residents would purchase vehicle stickers  Model assumes sticker is $50 per year  Estimated to generate $1,000,000 per year The arguments for this option include: drivers will pay for streets; it is increasingly common in Illinois communities; and it can increase over time with fee adjustments. The arguments against this option include: it does not capture revenue from non-residents; it is a significant time to administer; and it’s a fee increase. Option 3: Trash Hauler Fee  Rationale: Trash haulers create disproportionate wear on residential streets  Fee would be established to generate $400,000 per year  If passed through to customers staff estimates would be about $4 per billing cycle The arguments for this option include: in a competitive environment, the full cost may not be passed on to residents and businesses; and it can increase over time with fee adjustments. The arguments against this option include: it does not capture revenue from non-residents; and it’s a fee increase. The following graph illustrates the revenues generated by implementing options 1, 2 and 3. This amount is shown in addition to the existing funding sources and the total proposed capital expenditures to illustrate the gap between sources and uses of funding. 134  Capital Needs vs. Existing and New Revenues Total Capital Projects Existing funding sources Proposed New Revenues 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 - 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 The fourth and final option considered in the financial management plan is a sales tax with resident rebate. The characteristics of this option are described below along with the pros and cons. Option 4: Sales Tax with Resident Rebate  Goal is to generate revenue from all people who put demands on City infrastructure, not just residents  Increase Home Rule Sales Tax from 1.75% to 2.75%  Rebate a portion of sales tax to residents  Rebate based on $4,500 purchases within City per year  Rebate may be given as credit on utility bills  Not provided if past due on utilities  Requires annual application and administration  Estimated to generate $3,155,000 per year  Would be applied to pay debt service on bonds that finance streets and fleet The arguments for this options include: all users of City infrastructure help pay for it; and a rebate program softens impact on residents. The arguments against this option include: it is a tax increase; and a new administrative process would be needed for rebate program. The funding from the sales tax with residential rebate option is modeled as bond proceeds received every two years. The results of applying this options along with options 1, 2 and 3 are illustrated by the following graph. 135  Proposed Funding Strategy Total Capital Projects Existing funding sources Proposed New Revenues Bond Proceeds 14,000,000 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 - 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 The implications of a near-term bond issuance may prevent the City from pursuing this option in the near future. The Municipal Advisors at Ehlers are concerned that taking on additional debt may overburden the City, particularly in light of the recent downgrading of the City’s General Obligations bonds in May 2017. As an alternative, the City could delay the first debt issuance until 2020 or later. That would allow some of the current debt to be retired and provide a history of sales tax collections to be established. This alternative would require a reduction in capital expenditures in 2018 and 2019 as shown below. Vehicles and Streets Equipment Planned 2018 and 2019 CIP $9,225,000 $4,175,000 Reduced 2018 and 2019 CIP $5,725,000 $1,425,000 Streets and Fleet Conclusions The level of funding for fleet replacement over the past 10 years has not been sufficient to sustain the overall condition of this asset. Vehicle replacement has averaged about $300,000 per year since 2006. That level is about $500,000 per year less than the amount needed to sustain the overall fleet condition of 2006. Currently, the fleet backlog is about $4.3 million. The fleet condition of 2006 can be attained in about five years with an investment of about 136  $1.65 million per year. A more conservative fleet replacement schedule averaging about $1.4 million per year was used in the financial model. The funding for street maintenance has averaged $860,000 per year over the past 25 years. The current funding level is $1.3 million and the average PCI of City streets is 78. Continuing to invest $1.3 million in street maintenance will result in the average PCI dropping to 70 in five years and 59 in 10 years. Based on the scenarios evaluated using the PMS, it would cost about $13 million per year to maintain a PCI of 78. The scenario used in the financial model includes about $3.8 million per year in street maintenance. This would result in the average PCI dropping from 78 to 72 in five years and to 63 in 10 years. A 10-year financial model of revenues and expenditures from the General Fund and other capital funds was used to evaluate the impact of an annual increase in capital expenditures of about $7.5 million. Options for funding the increased capital expenditures included fees and taxes (local motor fuel tax, city stickers, and waste hauler fees) in an amount of $2.12 million and a sales tax with local rebate generating $3.155 million per year. The recent downgrade of the City’s bond rating will impact the ability to issue bonds for capital improvement prior to 2020. The City could implement the capital improvement program as a pay-as-you-go program in 2018 and 2019 with an issuance of bonds in 2020 or later. Alternative Funding Policy Conclusions Peace Road Interchange Agreement The City should thoroughly review the Peace Road Interchange Improvement agreement with DeKalb County for the opportunity to end the agreement. City has fully paid the debt intended by this agreement. Otherwise, if the agreement and trend continues until expiration of the original 1993 Intergovernmental Agreement, the City could pay a total of approximately $7.8 million through Year 2033 for the benefit of $2.3 million received in 2004. Streets and Fleet Funding The recent downgrade of the City’s bond rating will impact the ability to issue bonds for capital improvement prior to 2020. The City could implement the capital improvement program as a pay-as-you-go program in 2018 and 2019 with an issuance of bonds in 2020 or later. General Fund Stabilization – Property Tax Levy Given projections, each year results in deficits with the fund balance declining dramatically and depleted by 2023. A Corporate Property tax of $900,000 should be considered for FY2019 and increased annually by 2%. With Equalized Assessed Valuation (EAV) growth of 3.50% annually, the projected scenario holds the property tax rate under 1.5% and maintains the General Fund balance above 25% through 2022. Any EAV growth greater than 3.5% would lower projected property tax rate. 137 RETURN TO AGENDA DATE: September 15, 2017 TO: Mike Peddle, Chair Finance Advisory Committee FROM: Anne Marie Gaura, City Manager Jeff Wilkins, Interim Finance Director SUBJECT: Water Sales Transfer to Water Capital Fund A question was raised at the August meeting of the Finance Advisory Committee whether a portion of the increased water rate sales is segregated for capital. The attached page shows a summary of the water sales transferred to the Water Capital Fund since the water rate increases in July 2016 and July 2017. Water rates increased by 2.2% effective July 2016 and 4.5% rate increase was implemented July 2017. As recommended by the Finance Advisory Committee, 66.7% of the increase has been segregated for water capital. To date a total of $120,061.67 has been transferred to Water Capital Fund #62.  Water Sales - Transfer to Capital Fund #62 Cumulative Total Water Sales Rate Rate Increase % to be Transfer Month Billing Increase Billing transferred Amount Jul - 2016 407,922.32 2.2% 8,781.11 66.7% 5,857.00 Aug - 2016 431,745.97 2.2% 9,293.94 66.7% 6,199.06 Sep - 2016 489,489.31 2.2% 10,536.95 66.7% 7,028.15 Oct - 2016 429,968.07 2.2% 9,255.67 66.7% 6,173.53 Nov - 2016 571,696.86 2.2% 12,306.59 66.7% 8,208.49 Dec - 2016 424,646.69 2.2% 9,141.12 66.7% 6,097.13 Jan - 2017 499,374.45 2.2% 10,749.74 66.7% 7,170.08 Feb - 2017 362,731.92 2.2% 7,808.32 66.7% 5,208.15 Mar - 2017 444,061.16 2.2% 9,559.05 66.7% 6,375.88 Apr - 2017 391,124.19 2.2% 8,419.50 66.7% 5,615.81 May - 2017 498,114.46 2.2% 10,722.62 66.7% 7,151.99 Jun - 2017 358,983.97 2.2% 7,727.64 66.7% 5,154.34 Jul - 2017 581,593.96 6.7% 36,519.96 66.7% 24,358.81 Aug - 2017 464,706.94 6.7% 29,180.29 66.7% 19,463.25 Total Water Sales Transferred to Water Capital Fund 120,061.67 Note: Rate Increases July 2016 2.20% July 2017 4.50% Page |2 RETURN TO AGENDA