NAPERVILLE ILLINOIS CAFR Analysis Amanda Grieco December 2
NAPERVILLE, ILLINOIS CAFR Analysis Amanda Grieco December 2, 2013
DEMOGRAPHICS �Incorporated in 1857 �Located in the northeastern part of the state �Top growth area in the state �One of the top growth areas in the country. �Unemployment rate was 7. 1% � 6, 000 building permits were issued. �Population: 143, 289 �Per capita personal income: $45, 012 �Median age: 39. 2 �Education level: 15. 41 �School enrollment: 46, 790.
MAJOR FUND QUALIFICATION COMPUTATIONS COMPOSITION OF NAPERVILLE, IL. • Audited by Sikich • Unqualified opinion • Certificate of Achievement for Excellence in Financial Reporting • The primary government uses 21 individual funds. • • • One General Fund 20 Other funds Major funds • • • Debt Service Fund Electric Utility Fund, Water and Wastewater Utility Fund Internal Service Fund Pension Trust Fund. DEBT SERVICE FUND (Q: EXPENSES) 10% ASSETS $8, 598, 000 $98, 826, 000 10% LIABILITIES ---------- 10% REVENUES $11, 743, 000 $135, 473, 000 10% EXPENSES 5% 8. 7% ELECTRIC UTILITY FUND (Q: ALL) WATER & WASTE FUND (Q: ALL) $286, 809, 000 $553, 877, 000 51. 8% $254, 028, 000 $553, 877, 000 45. 9% $58, 760, 000 $94, 086, 000 62. 5% $35, 308, 000 $94, 086, 000 37. 5% 8. 7% $134, 580, 000 $184, 289, 000 73. 0% $47, 578, 000 $184, 289, 000 25. 8% $15, 333, 000 $138, 767, 000 11. 0% $127, 814, 000 $163, 739, 000 78. 1% $34, 147, 000 $163, 739, 000 20. 9% ASSETS $8, 598, 000 $652, 703, 000 1. 3% $286, 809, 000 $652, 703, 000 43. 9% $254, 028, 000 $652, 703, 000 38. 9% 5% LIABILITIES --------- $58, 760, 000 $113, 806, 000 51. 6% $35, 308, 000 $113, 806, 000 31. 0% 5% REVENUES $11, 743, 000 $319, 762, 000 3. 7% $134, 580, 000 $319, 762, 000 42. 1% $47, 578, 000 $319, 762, 000 14. 9% 5% EXPENSES $15, 333, 000 $302, 506, 000 5. 1% $127, 814, 000 $302, 506, 000 42. 3% $34, 147, 000 $302, 506, 000 11. 3%
FINANCIAL CONDITION • Assets exceeded liabilities by $928 million (net position) • $69 million unrestricted to use as needed. • Total Net Position decreased by $4. 8 million: • Governmental -$6. 1 million • Business-type: +$1. 3 million. • Governmental fund balances totaled $47. 5 million • $31. 5 million (69%) is unassigned • $13 million above the 20% policy reserve level. • Total debt decreased by $10. 4 million (5. 77%). • Issued $30 million General Obligation bonds to refund the outstanding bonds.
COMPARISONS Revenues & Expenses Governmental Activities Budgeted & Actual Activity
FINANCIAL RATIOS NET DEBT PER CAPITA General Obligation Debt – Debt Service Fund Balance Population 164, 580, 000 - 4, 717, 628 143, 289 $1, 115. 66 NET DEBT TO FAIR VALUE OF PROPERTY General Obligation Debt – Debt Service Fund Balance Market Value Of Property 164, 580, 000 - 4, 717, 628 6, 072, 976, 994 2. 6% General Fund Unassigned Fund Balance General Fund Total Balance 25, 573, 000 103, 058, 000 24. 8% GOVERNMENTAL REVENUES PER CAPITA Total Revenue: Governmental Funds Population 135, 473, 000 143, 289 $945. 45 INTEREST COVERAGE – REVENUE BONDS Operating Income: Enterprise Funds Interest Expense (5, 644, 000) 2, 251, 000 -2. 51 163, 739, 000 – 184, 289, 000 553% UNASSIGNED FUND BALANCE REVENUES OPERATING RATIOENTERPRISE FUNDS Operating Expense – Depreciation Expense Operating Revenues (5, 644, 000)
ADDITIONAL ANALYSIS � All revenues showed improvement trends higher than budget collection for FY 2013, 5% increase ($5, 000). � The Retail Sales Tax increased by 7%, or $32. 3 million � 40% increase in home sales � Reduced property tax levy by 4. 31% � Property tax collection in 2011 was $48, 317, 459, 99. 2% collected. � The City of Naperville is considered unstable due to the fact that it relies on the tax revenues as the sole source of income: $109, 884, 000, or 81%, of revenues totaled � Also can be considered stable because it was able to collect a high percentage of its taxes.
ADDITIONAL ANALYSIS � � � � Reduced gross healthcare costs by 2%! The decline in revenues ($1 million) is due to reduction in property taxes. Offset the reduction: increase in home sales and sales taxes The city invested $851 million in capital assets in FY 2103. Total expenditures of governmental activities ($331 million) 64. 3% general revenues 34. 2% program revenues. 20. 3% increase of general government expenditures Reduced by lowering charges Now purchasing wholesale power from IMEA, resulting in lower costs, which is more favorable than most markets. Capital projects Smart Grid Initiative Library Roof Replacement.
ADDITIONAL ANALYSIS �$169. 84 million outstanding debt �Un-funded public safety pension liability $99. 6 million. �$6 million of increased revenues above budget was split to increase pension contribution to each of the two public safety pension funds. �The compound interest on the accelerated payment is expected to save the city at least $16 million over the next 20 years.
FINAL CONCLUSION �STANDARD & POOR – AAA BOND RATING �DEBT ELIMINATION EFFORTS �IMPROVING ECONOMY, INCREASED REVENUES �CAPITAL IMPROVEMENTS �DOES NOT RELY ON INTERGOVERNMENTAL REVENUES �HIGH LIQUIDITY RATIO �ABLE TO SIGNIFICANTLY REDUCE EXPENDITURES �“BUY” CONCLUSION
- Slides: 10