The URL can be used to link to this page

Home My WebLink AboutFinancial Health Profile 1983-1987FINANCIAL HEALTH PROFILE CITY OF LINO LAKES Years Ended December 31 1983 through 1987 December, 1988 MOP ARNE H. CARLSON STATE AUDITOR STATE OF MINNESOTA OFFICE OF THE STATE AUDITOR SUITE 400 525 PARK STREET SAINT PALL 55103 MINNESOTA FINANCIAL HEALTH PROGRAM - A Synopsis - The problems which create fiscal difficulties seldom emerge overnight; rather, they develop slowly, thus making potential difficulties less obvious. - Is Your City Heading For Financial Difficulty? Municipal Finance Officers Association, 1978 296.2553 Cities and counties in Minnesota have faced a number of factors to the '80's which necessitated constant monitoring of their financial situations by elected officials and community residents. High inflation in the early '80's has given way to low inflation in the past few years. Intergovernmental revenues for cities (funds from the federal, state and county governments) continue the decline that started in the early '80's. Federal revenue sharing was discon- tinued in 1986. In addition to factors that influence the state as a whole, regional influences have taken their toll. While the 7- county metro area, which Includes Minneapolis and St. Paul, has remained strong, the mining- and farm- dependent areas are feeling the stress associated with declining market values, increasing unemployment and greater needs for welfare, health and social service programs. The Office of State Auditor designed the Minnesota Financial Health Program (MFHP) in 1980 to assist city and county government officials and community residents in monitoring statewide and regional fiscal stress influences. The MFHP then provides needed help in resolving financial problems. The MFHP currently includes all 87 Minnesota counties and 180 cities with populations of 2,500 or more as of the 1980 census. These cities and counties prepare annual financial statements in conformity with Generally Accepted Accounting Principles (GAAP) and use the Uniform Chart of Accounts, developed by the Office of State Auditor. There are, however, 188 cities with populations of less than 2,500 which, for the last two years, have elected to prepare annual financial statements in accordance with GAAP. These cities are being reviewed for possible addition to the MFHP data base in 1988. If added, the size of the program will nearly double. Five major fiscal trends have been identified in this program. By analyzing key financial indicators for five -year periods, it is possible to establish trends and patterns. It is from these statistics that interpretations of each local unit's financial health can be determined. AN EQUAL OPPORTUNITY EMPLOYER The five major trends and example indicators measured by this program are: A. Economic Vitality 1. Population: Is there an increase or decrease in population? 2. Real estate: Is the taxable valuation of real estate growing too slowly? 3. Retail sales: Does the growth or decline in the number of businesses and retail sales reflect an overall economic recession or an erosion of local economic vitality? 4. Social welfare: Is unemployment placing greater demands on health, welfare, and social service programs? B. Revenue Trends 1. Levy limit: Is the actual current levy rate at or approaching the legal levy limit? 2. Earnings on investments: Is the percent of revenues derived from earnings on investments changing? 3. Tax collection rate: Is the trend in property tax collection rates declining? 4. Revenue /expenditure comparisons: Is there a consistent pattern of revenue shortfalls? C. Expenditure Trends 1. Expenditures: Are the overall expenditures or expenditures by function in line with the current rate of inflation? 2. Per capita expenditures: Are the municipal expenditures per capita growing at a faster rate than the change in population? 3. Interest and fiscal charges: Is the cost for interest and fiscal charges escalating as a percent of total expenditures? D. Future Solvency 1. Debt: Is future financial flexibility being lost due to a growing debt burden? 2. Bond rating: Is there a change in the bond rating? 3. Debt service payments: Are debt service payments becoming a larger percentage of total revenues? 4. Fund balance: Is there a decline in the general fund balance? E. Management Practices 1. Auditor's opinion: Is there a consistent failure to obtain an unqualified opinion on financial statements from independent auditors? 2. Municipal employees: Is the number of municipal employees consistent with current population trends? 3. Fringe benefits: Will growth in fringe benefits and employer -paid contributions place undue demands on future revenues? 4. Municipal enterprises: Are the municipal enterprises incurring unplanned for losses or gains? The MFHP was developed as an index of economic indicators to help elected municipal officials determine fiscal trends. Identifying a negative trend does not automatically spell fiscal decay. Rather, the answers to these and other questions tell municipalities whether or not a sound fiscal course lies ahead. 2/88 MINIM Mar MINNESOTA FINANCIAL HEALTH PROFILE 1983 THROUGH 1987 TABLE OF CONTENTS Graphs Governmental Revenues (Metro Area Cities Only) Governmental Current Expenditures (Metro Area Cities Only) Indicated Market Value Gross Retail Sales Profile Page Indicator 1: Change in Population 1 Indicator 2: Change in Property Values 1 Indicator 3: Trend in Building Permits 1 Indicator 4: Trend in Retail Sales Activity 2 Indicator 5: Trend in Individual Economic Status 2 Indicator 6: Change in Consumer Price Index 2 Indicator 7: Trend in Revenue Sources 3 +- Indicator 8: Change in Property Tax Levy 4 Indicator 9: Trend in Property Tax Collection 4 Indicator 10: Tend in Earnings on Investments (Governmental Funds) 4 Indicator 11: Trend in Expenditures by Function 5 Indicator 12: Trend in Expenditures by Function (Per Capita) . . . 6 Indicator 13: Budget to Actual Revenues 7 Indicator 14: Budget to Actual Expenditures 7 Indicator 15: Trend in Outstanding Bonded Indebtedness 8 Indicator 16: Current or Change in Bond Rating 8 Indicator 17: Trend in Current Debt Service Costs (Governmental Funds) 8 Indicator 18: Trend in Governmental Fund Liabilities 8 Indicator 19: Change in Fund Balances (Unreserved, Undesignated) . 9 Indicator 20: Opinion on Financial Statements 9 Indicator 21: Trend in Number of Employees Compared to Population (Governmental Funds) 10 Indicator 22: Trend in Compensation and Employer Paid Fringe Benefits (Governmental Funds) 10 Indicator 23: Profit or Loss in Enterprises 10 Data Base: Content of Indicators for Financial Health Profiles Appendices Appendix A - Analysis by Class of City Appendix B - Regional Map and Analysis of Selected Indicators GOVERNMENTAL REVENUES (Totals for Metro Area Cities Only) Millions $900 $800 $700 1800 $500 1400 1300 $200 $100 10 1983. 1984 1985 1988 1987 Intergov'tal Revenue IM All Other Revenues GOVERNMENTAL CURRENT EXPENDITUi.. (Totals for Metro Area Cities Only) $175 $150 $125 $100 $75 $50 $25 10 Millions 1983 1984 1985 1988 1987 g= General Owernatent OM Fire gali Police II/ Streets I Highways :::?.....,,,.. ........... ........,- ---.. ,-. _....... . :^. • '----- -r.2.1.,«..,, 1983. 1984 1985 1988 1987 Intergov'tal Revenue IM All Other Revenues GOVERNMENTAL CURRENT EXPENDITUi.. (Totals for Metro Area Cities Only) $175 $150 $125 $100 $75 $50 $25 10 Millions 1983 1984 1985 1988 1987 g= General Owernatent OM Fire gali Police II/ Streets I Highways $70 $60 $50 $40 $30 $20 $10 SO INDICATED MARKET VALUE Billions 1983 1984 1985 1986 ED Metro 11111 Non-Metro 1987 Billions $18 $16 $14 $12 $10 $8 $6 $4 $2 $0 GROSS RETAIL SALES ED Metro 1111 Non-Metro e NNW MINNESOTA FINANCIAL HEALTH PROGRAM OFFICE OF THE STATE AUDITOR (612) 296 -2551 ECONOMIC VITALITY 1. INDICATOR: CHANGE IN POPULATION Population Percent Change Number of Households Percent Change CITY: LINO LAKES COUNTY: ANOKK 11/29/88 METRO AVERAGE 5 YEAR 5 YEAR 1983 1984 1985 1986 1987 % CHANGE % CHANGE 5,730 4.9% 1,655 6,030 5.2% 1,744 5.4% 2. INDICATOR: CHANGE IN PROPERTY VALUES Indicated Market Value 6,320 6,766 4.8% 7.1% 1,839 1,974 5.4% 7.3% 7,110 5.1% 24.1% 5.9% 2,112 7.0% 27.6% 10.1% METRO AVERAGE 5 YEAR 5 YEAR 1983 1984 1985 1986 1987 2 CHANGE % CHANGE $ 136,536,408 $ 138,598,949 $ 148,841,669 S 148,306,865 S 161,519,943 Percent Change 10.0% 1.5% 7.4% -0.4% 8.9% 18.3% 9.4% �- Assessed Valuation S 24,606,763 $ 24,464,645 $ 25,760,314 $ 27,350,937 S 29,997,115 Percent Change 8.7% -0.6% 5.3% 6.2% 9.7% 21.9% 21.1% Tax Increment District Captured Assessed Valuation S 0 S 0 S 0 S 0 S 0 Percent Change .... .... .... .... .... ... 133.6% Sala Ratio 0.788 0.808 0.808 3. INDICATOR: TREND IN BUILDING PERMITS 0.868 0.857 AVERAGE 5 YEAR 5 YEAR 1983 1984 1985 1986 1987 % CHANGE % CHANGE Value of Wilding Permits S 8,143,225 S 6,906,647 S 9,563,623 $ 12,424,118 $ 13,091,697 Percent Change 56.4% - 15.2% 38.5% 29.9% 5.4% 60.8% 95.0% Number of Building Permits Issued Percent Change 223 213 267 277 318 35.2% -4.5% 25.4% 3.7% 14.8% NOTE: Asterisks (••,•'•.'%) on any page indicate that a percentage change was too large to be meaningful. 1 42.6% OFFICE OF THE STATE AUDITOR CITY: LINO LAKES ECONOMIC VITALITY 11/29/88 4. INDICATOR: TREND IN RETAIL SALES ACTIVITY METRO AVERAGE 5 YEAR 5 YEAR 1983 1984 1985 1986 1987 % CHANGE % CHANGE Gross Retail Sales $ 5,578,278 $ 5,731,937 $ 6,656,310 $ 6,861,008 $ 6,326,814 Percent Change 25.2% 2.8% 16.1% 3.1% -7.8% 13.4% 42.7% .. Number of Businesses Percent Change 33 33 32 36 -5.7% 0.0% -3.0% 12.5% S. INDICATOR: TREND IN INDIVIDUAL ECONOMIC STATUS 40 11.1% 21.2% 1986 5 YEAR STATEWIDE 1983 1984 1985 1986 1987 % CHANGE PER CAPIT!- Per Capita Federal Adjusted Gross Income * S 6,151 Percent Change 7.7% Number of AFDC Recipients in County S 7,159 S 7,666 $ 8,140 Unavailable 511,906 16.4% 7.1% 6.2% .... 6,114 6,015 AFDC Recipients as a Percent of County Population 2.9% Unemployment Rate in County " 7.6% 5,410 5,461 2.9% 2.5X 5.0% 5.0% 6. INDICATOR: CHANGE IN CONSUMER PRICE INDEX Npts-St. Paul Percent Change '" 5,534 -9.5% 2.5% 2.5% 4.7% 4.7% 5 YEAR 1983 1984 1985 1986 1987 % CHANGE 2.2% 3.6% 3.8% 1.3% 3.0% 12.2% 1987 STATEWIDE RATE 5.42 Notes: t'] Per capita adjusted gross income figures for 1987 are not available at this time. t"] The 1983 through 1986 unemployment rates were revised in April 1987 by the Department of Jobs and Training. t"'] Source: U.S. Department of Labor, All Urban Consumers - (CPI -U) 1982 -84 ■ 100. 2 sr OFFICE OF THE STATE AUDITOR CITY: LINO LAKES REVENUE TRENDS 7. INDICATOR: TREND IN REVENUE SOURCES GOVERNMENTAL FUNDS REVENUES Intergovernmental Revenues Federal State County Local Total Intergovernmental Revenues Taxes Special Assessments Franchise Taxes Sales t Motel /Motel Taxes Licenses and Permits y^ Charges for Services Fines and Forfeits Miscellaneous Revenues Interest Earnings All Other Revenues w Total Revenues Total Revenues Per Capita Annual Percentage Change 1983 AMOUNT % 1984 AMOUNT % 1985 AMOUNT 1986 AMOUNT % 11/29/01 1987 AMOUNT 2 S 32,881 2.4% S 65,533 4.6% S 43,318 2.7% S 31,853 1.0% S 1,455 0.0 379,931 27.8% 430,431 30.3% 456,984 28.5% 507,213 15.4% 1,174,468 37.3 95,367 7.0% 47,819 3.4% 59,989 3.7% 5,976 0.2% 38,207 1.2 0 0.0% 0 0.0% 0 0.0% 0 0.0% 508,179 37.2% 543,783 38.2% 560,291 35.0% 545,042 16.5% 1,223,732 38.9 9.602 0.3 426,392 31.2% 516,445 36.3% 198,905 14.6% 103,533 7.3% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 75,096 5.5% 91,332 6.4% 82,062 6.0% 79,350 5.6% 24,263 1.8% 26,784 1.9% 553,178 34.5% 616,869 72 750,544 23.8 88,544 5.5% 1,697,950 51.6% 714,927 22.7 0 0.0% 0 0.0% 0 0.0 0 0.0% 0 0.0% 0 0. 110,343 6.9% 137,879 4.2% 164,115 5.2 107,829 6.7% 63,649 1.9% 59,069 1.9 68,492 4.3% 65,369 2.0% 68,448 2.2 33,226 2.4% 45,284 3.2% 53,501 3.3% 146,689 4.5% 108,098 17.191 1.3% 15.691 1.1% 59.748 3.7% 20.104 0.6% 59.662 1,365,314 100.0% 1,422,202 100.0% 1,601,926 100.0% 3,293,551 100.0% 3,148,595 100.0 S 238.27 Per Capita 19.7% ssasssasasa sssssa S 235.85 S 253.47 -1.0% 7.5% 3 8 486.78 92.0% $ 442.84 -9.0% OFFICE OF THE STATE AUDITOR CITY: LINO LAKES - REVENUE TRENDS 8. INDICATOR: CHANGE IN PROPERTY TAX LEVY 11/29/88 METRO AVERAGE 5 YEAR 5 YEAR 1983 1984 1985 1986 1987 X CHANGE % CHANGE Special Assessment S 213,253 $ 186,467 $ 168,651 $ 140,653 $ 369,014 73.0% Limited Levy 439,466 O 0 0 0 .... -. Other Local Levy 148.389 690.006 775.011 835.502 990.011 567.2% Total Property Tax Levy, Fiscal Disp. Levy and Sp. Assessment Levy 801,108 876,473 943,662 976,155 1,359,025 ! sss!lsss! Percent Change 5.0% 9.4% 7.7% 3.4% 39.2% 69.6% 26.3% Levy Limit 430,631 0 0 0 0 .... Limited Levy as a Percent of Levy Limit 102.1% .... .... .... .... fiscal Disparities Levy 65,932 79,280 118,308 128,758 167,822 154.5% 9. INDICATOR: TREND IN PROPERTY TAX COLLECTION 1983 Percent Collected 83.8% 1984 1985 1986 1987 85.9% 84.8% 10. INDICATOR: TREND IN EARNINGS ON INVESTMENTS (GOVERNMENTAL FUNDS) 79.5% 98.2% 5 YEAR METRO AVERAGE - 5 YEAR 1983 1984 1985 1986 1987 % CHANGE % CHANGE Interest Income S 33,226 $ 45,284 S 53,501 $ 146,689 S 108,098 Percent Change -46.3% 36.3% 18.1% 174.2% -26.3% 225.3% 44.0% Interest Income as • Percent of Total Revenues 2.4% 3.2% 3.3% 4.5% 3.4% 4 OFFICE OF THE STATE AUDITOR CITY: LINO LAKES EXPENDITURE TRENDS 11. INDICATOR: TREND IN EXPENDITURES BY FUNCTION GOVERNMENTAL FUNDS CURRENT EXPENDITURES teneral Government Police Fire Streets i Highways Refuse i Sanitation Culture and Recreation Urban Redevelopment i Housing Interest and Fiscal Charges Miscellaneous Expenditures Total Current Expenditures Total Current Expenditures Per Capita Annual Percentage Change Per Capita SUMMARY OF EXPENDITURES Total Current Expenditures Total Capital Outlay Debt Service Fund Principal Total Expenditures Total Expenditures Per Capita 1983 1984 1985 1986 11/29/88 1987 AMOUNT X AMOUNT % AMOUNT % AMOUNT % AMOUNT % $ 270,775 24.4% $ 259,556 20.4% S 304,553 25.8% S 363,256 24.5% $ 414,088 25.4% 279,197 25.2% 295,673 23.2% 311,974 26.4% 324,523 21.9% 376,147 23.0% 48,476 4.42 45,615 3.6% 75,386 6.4% 95,156 6.4% 107,520 6.6% 219,429 19.8% 279,375 21.9% 287,822 24.3% 344,767 23.3% 383,271 23.5% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 50,794 4.6% 49,744 3.9% 69,678 5.9% 86,549 5.8% 82,117 5.0% 92,402 8.3% 64,285 5.1% 11,375 1.0% 4,130 0.3% 4,443 0.3% 77,006 7.0% 83,860 6.6% 79,479 6.7% 707.546 14.0% 186,361 11.4% 69.491 6.3% 194.818 15.3% 42.185 3.6% 54.969 3.7% 77.978 4.8% 1,107,570 100.0% 1,272,926 100.0% 1,182,452 100.0% 1,480,896 100.0% 1,631,925 100.0% S 193.29 16.3% S 211.10 9.2% $ 187.10 -11.4% S 218.87 17.02 __■ S 229.53 4.92 1,107,570 89.5% 1,272,926 93.1% 1,182,452 84.3% 1,480,896 47.3% 1,631,925 38.2% 130,288 10.5% 94,974 6.9% 219,719 15.7% 1,617,493 51.6% 2,091,085 49.0% 0 0.0% 0 0.0% 0 0.0% 35.000 1.1% 544.820 12.8% 1,237,858 100.0% 1,367,900 100.0% 1,402,171 100.0% 3,133,389 100.0% 4,267,830 100.0% swam ZssZ=sssss= =warn maw ZZZZZZ ZZZZZZZSZRZ ZZZZZZ ===ZZZ=Z= == ZZZZ== S 216.03 Annual Percentage Change Per Capita 18.6% $ 226.85 5.0% S 221.86 -2.2% $ 463.11 108.7% $ 600.26 29.6% OFFICE OF THE STATE AUDITOR CITY: LINO LAKES EXPENDITURE TRENDS 11/29/88 12. INDICATOR: TREND IN EXPENDITURES BY FUNCTION (PER CAPITA) GOVERNMENTAL FUNDS CURRENT EXPENDITURES 1983 1984 1985 1986 1987 (Per Capita) AMOUNT % AMOUNT 2 AMOUNT % AMOUNT 2 AMOUNT % _ General Government S 47.26 24.4% $ 43.04 20.4% $ 48.19 25.8% S 53.69 24.5% $ 58.24 25.4 Police 48.73 25.2% 49.03 23.2% 49.36 26.4% 47.96 21.9% 52.90 23.0 Fire 8.46 4.4% 7.56 3.6% 11.93 6.4% 14.06 6.4% 15.12 6.6A Streets i Highways 38.29 19.8% 46.33 21.9% 45.54 24.3% 50.96 23.3% 53.91 23.1 Refuse i Sanitation 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0% ` Culture i Recreation 8.86 4.6% 8.25 3.9% 11.03 5.9% 12.79 5.8% 11.55 5.( Urban Redevelopment 8 Housing 16.13 8.3% 10.66 5.1% 1.80 1.0% 0.61 0.3% 0.62 0.3% Interest and Fiscal Charges 13.44 7.0% 13.91 6.6% 12.58 6.7% 30.67 14.0% 26.21 11.4 Miscellaneous Expenditures 12.13 6.3% 32.31 15.3% 6.67 3.6% 8.12 3.7% 10.97 4.8% Total Current Expenditures 193.29 100.0% 211.10 100.0% 187.10 100.0% 218.87 100.0% 229.53 100.( z =z rzzzzr. zzzz .z zzzzzz zzzzzzzzzzz zzzzzz zzzzzzzz.CZ szss== Annual Percentage Change 16.3% SUMMARY OF EXPENDITURES (Per Capita) Total Current Expenditures Total Capital Outlay Debt Service Fund Principal Total Expenditures 193.29 89.5% 22.74 10.5% 0.00 0.0% 216.03 100.0% 9.2% -11.4% 17.0% 4.9% 211.10 93.1% 187.10 84.3% 218.87 47.3% 229.53 38.Z_ 15.75 6.9% 34.77 15.7% 239.06 51.6% 294.10 49.C'- 0.00 0.0% 0.00 0.0% 5.17 1.1% 76.63 12.8,E Annual Percentage Change 18.6% 226.85 100.0% 221.86 100.0% 463.11 100.0% 600.26 100.0 zzzzzzzzzzz zzzzzz zzzzzzzzzzz zzzz. 5.0% -2.22 6 108.7% 29.6% INNEN Imme OFFICE OF TEE STATE AUDITOR CITY: LINO LAKES REVENUE /EXPENDITURE COMPARISONS 13. INDICATOR: BUDGET TO ACTUAL REVENUES GENERAL FUND: Budgeted Revenues Actual Revenues Percent Over/ -Under SPECIAL REVENUE FUNDS: Budgeted Revenues Actual Revenues Percent Over / -Under 1983 11/29/88 1984 1985 1986 1987 $ 831,700 $ 1,066,196 $ 1,176,475 $ 1,299,228 $ 1,465,360 898,407 1,120,314 1,337,940 1,370,759 1,617,286 8.0% 5.1% 13.7% 5.5% 10.4% 8 29,453 B 30,000 $ 41,760 $ 40,000 $ 32,346 38,053 42,901 29,993 9.8% 26.8% 2.7% -25.0X 14. INDICATOR: BUDGET TO ACTUAL EXPENDITURES 1983 GENERAL FUND: 1984 1985 1986 1987 0 0 Budgeted Expenditures $ 861,153 $ 1,087,646 $ 1,222,340 $ 1,288,228 S 1,482,001 Actual Expenditures 863,752 1,008,507 1,146,135 1,377,263 1,519,189 '.. Percent - Over /Under -0.3% 7.3% 6.2% -6.9% -2.5% SPECIAL REVENUE FUNDS: Budgeted Expenditures $ 0 $ 0 $ 0 $ 0 8 0 Actual Expenditures 0 0 0 0 0 — Percent - Over /Under .... .... .... .... OFFICE OF THE STATE AUDITOR CITY: LINO LAKES FUTURE SOLVENCY 15. INDICATOR: TREND IN OUTSTANDING BONDED INDEBTEDNESS 1983 11/29/88 METRO AVERAGE 5 YEAR 5 YEAR 1984 1985 1986 1987 % CHANGE % CHANGE general Obligation i S.O. Revenue Bonds $ 0 S 0 S 0 S 0 S 0 54.0% Per Capita 0.00 0.00 0.00 0.00 0.00 As a % of Assessed Valuation .... .... .... .... .... Special Assessment Rands $ 1,035,280 S 958,960 S 2,694,140 S 3,054,320 S 4,194,500 305.2% 6.1 %"- Per Capita 180.68 159.03 426.29 451.42 589.94 As a % of Assessed Valuation 4.2% 3.9% 10.5% 11.2% 14.0% Tax Increment Financing Bonds S Per Capita As a % of Tax Increment Value 0 S 0 5 0 S 0.00 0.00 0.00 16. INDICATOR: CURRENT OR CHANGE IN BOND RATING RATING FIRM Moody's Standard and Poor's 1983 A OMNI 0 S 0 152.3% 0.00 0.00 1984 1985 1986 1987 A A A Baal 17. INDICATOR: TREND IN CURRENT DEBT SERVICE COSTS (GOVERNMENTAL FUNDS) Debt Service Payments S Percent Change Debt Service as a Percent of Total Revenues 5 YEAR METRO AVERAGE 5 YEAR _ 1983 1984 1985 1986 1987 % CHANGE % CHANGE-- 184,026 S -84.5% 13.5% 195,180 S 6.1% 194,299 S -0.5% 13.7% 12.1% 357,366 S 83.9% 731,181 104.6% 297.3% 23.0% 10.9% 23.2% 18. INDICATOR: TREND IN GOVERNMENTAL FUND LIABILITIES METRO AVERAGE 5 YEAR 5 TEAR 1983 1984 1985 1986 1987 % CHANGE % CHANGE --. Total liabilities S 1,221,302 S 1,065,098 S 2,791,579 S 3,362,376 S 2,672,507 Percent Change 19.4% -12.8% 162.1% 20.4% -20.5% 118.8% -33.5% Liabilities as • Percent of Current Expenditures 110.3% 83.7% 236.1% 227.1% 163.8% 8 mmia r OFFICE OF THE STATE AUDITOR CITY: LINO LAKES FUTURE SOLVENCY 11/29/& 19. INDICATOR: CHANGE IN FUND BALANCES (UNRESERVED, UNDESIGNATED) METRO AVERAGE 5 YEAR 5 YEAR 1983 1984 1985 1986 1987 % CHANGE % CHANGE General Fund $ Percent Change % of Actual Expenditures Special Revenue Funds $ Percent Change % of Actual Expenditures General Fund Balance as a % of 80,032 $ 499.3% 9.3% 126,153 $ 57.6% 12.5% 350,675 s 178.0% 30.6% 0 S 0 S 0 S Total Current Expenditures 7.2% 9.9% 29.7% 457,927 $ 30.6% 33.2% MANAGEMENT PRACTICES 20. INDICATOR: OPINION ON FINANCIAL STATEMENTS 1983 589,799 28.8% 637.0% 44.5% 38.8% 0 s 0 422.3% 30.9% 36.1% 1984 1985 1986 1987 -- Auditor's Opinion QUALIFIED QUALIFIED QUALIFIED QUALIFIED QUALIFIED GFOA Certificate of Achievement OFFICE OF THE STATE AUDITOR CITY: LINO LAKES MANAGEMENT PRACTICES 21. INDICATOR: TREND IN NUMBER OF EMPLOYEES COMPARED TO POPULATION (GOVERNMENTAL FUNDS) (As Reported by the city) 11/29/88 METRO AVERAGE 5 YEAR 5 YEAR 1983 1984 1985 1986 1987 % CHANGE % CHANGE full -Time Employees 15 21 21 21 22 46.7% 1.7% Employees per 1,000 Population 2.62 3.48 3.32 3.10 3.09 Part-Tiee Employees 6 54 49 11 16 166.7% 93.0% Employees per 1,000 Population 1.05 8.96 7.75 1.63 2.25 22. INDICATOR: TREND IN COMPENSATION AND EMPLOYER PAID FRINGE BENEFITS (GOVERNMENTAL FUNDS) (As Reported by the city) METRO AVERAGE 5 YEAR 5 YEAR 1983 1984 1985 1986 1987 % CHANGE % CHANGE Total Payroll S 431,732 S 474,894 $ 638,083 S 699,505 S 799,297 Percent Change 27.7% 10.0% 34.4% 9.6% 14.3% 85.1% 41.6% Employer Paid fringe Benefits S 159,554 S 90,000 S 124,500 S 109,334 S 131,329 Percent Change 129.3% -43.6% 38.3% -12.2% 20.1% -17.7% 17.4% fringe Benefits as a Percent of Payroll 37.0% 19.0% 19.5% 23. INDICATOR: PROFIT OR -LOSS IN ENTERPRISES 15.6% 16.4% 1983 1984 1985 1986 1987 SEWER Operating Revenues S 38,919 S 39,282 .... Operating Expenses 51,328 53,947 Operating Income - 12,409 - 14,665 .... Net Income .... -5,271 -6,360 .... MATER Operating Revenues S 36,046 S 6,418 S 11,870 S 57,939 S 78,350 Operating Expenses 68,220 21,793 19,709 82,311 117,368 Operating Income -32,174 - 15,375 -7,839 - 24,372 - 39,018 - Met Income - 21,164 - 15,375 -7,839 - 17,272 - 28,946 GAS Operating Revenues S 269,556 S 281,581 S 285,691 S 212,084 S 195,695 Operating Expenses 245,391 263,702 259,140 228,407 198,064 Operating Income 24,165 17,879 26,551 - 16,323 -2,369 Met Income 21,642 16,043 24,473 - 18,418 302 10 Vow ARNE H. CARLSON STATE AUDITOR STATE OF MINNESOTA OFFICE OF THE STATE AUDITOR SUITE 400 525 PARK STREET SAINT PAUL 55103 DATA BASE CONTENT OF INDICATORS FOR FINANCIAL HEALTH PROFILES Throughout the profile, class refers to the following population groups: 1. First Class Cities (more than 100,000 population) 2. 20,000 to 100,000 population 3. 10,000 to 20,000 population 4. 2,500 to 10,000 population Note: Unless otherwise indicated, the source of information shown on the Financial Health profile is the annual financial statement. 1. Population - Source: Minnesota State Demographer; estimate Households - Source: Minnesota State Demographer; estimate 2. Property Values Source: Minnesota Department of Revenue. Data shown for the "payable" year; e.g., 1986 value is payable in 1987. Indicated market value, assessed valuation and sales ratios are from the Department of Revenue. 296-2551 3. Building Permits Source: Data provided by individual cities. 4. Retail Sales Source: Minnesota Department of Revenue's Historical Retail Sales data on "Gross Retail Sales," showing both taxable and nontaxable sales. Number of businesses equals the number of vendors who filed sales tax returns. 5. Individual Economic Status Per Capita Income - Source: Minnesota Department of Revenue. Federal Adjusted Gross Income (FAGI) divided by demographer's estimate of popu- lation. AFDC Recipients in Count - Source: Minnesota Department of Welfare's "Minnesota Aid to Families With Dependent Children" annual report (State Fiscal Year). Totals include caretakers and children. Unemployment Data - Source: Minnesota Department of Jobs and Training. AN EQUAL OPPORTUNITY EMPLOYER 6. Consumer Price Index Source: U.S. Department of Labor, Bureau of Labor Statistics 7. Revenue Sources Governmental Funds Revenues Intergovernmental Revenue: Federal State County Local Taxes Special Assessments Franchise Taxes Sales and Hotel /Motel Taxes Licenses and Permits Charges for Services Fines and Forfeits Miscellaneous Revenues: Interest Earnings All Other Revenues Total Revenues Revenues Per Capita (total revenues divided by current population in Indicator 1) 8. Property Tax Levy Special Assessments: Limited Levy: Other Local Levy: Total Levy: Levy Limit: Fiscal Disparities Levy: Source: Department of Revenue Source: Department of Revenue Total levy less limited levy The sum of the above Calculated by Department of Revenue pursuant to levy limit law. Source: Department of Revenue 9. Property Tax Collection Rate This is current -year data, showing the collection rate on the current year tax levy. Does not reflect delinquent tax collections. 10. Earnings on Investments (Governmental Funds) Interest income includes earnings on all governmental fund investments, such as surplus funds which may be temporarily Invested. General fund, special revenue funds and all other governmental funds are included. 2 11. Expenditures by Function Governmental Funds Current Expenditures General Government Police -- Fire Streets and Highways Refuse and Sanitation ... Culture and Recreation Urban Redevelopment and Housing Interest and Fiscal Charges Miscellaneous Expenditures Total Current Expenditures AMIN Total Current Expenditures Totals the functional current expenditures shown above. Not included are the following: capital outlay (where it is separated from current expenditures in annual financial reports), debt redemption (long term and short term), and operating transfers out (e.g., to special projects or for debt service). Total Capital Outlay Sum of annual capital outlay from all governmental funds including capital outlay for general fund types of activities, and also capital outlay for enterprise fund activities where those are financed by governmental funds. Debt Service Fund Principal Principal paid on long -term debt from debt service funds. (Does not include enterprise fund payments.) Total Expenditures These include current expenditures (as described above), capital outlay, and debt service principal, but exclude debt redemption for 1983 and 1984. Expenditures Per Capita Total expenditures divided by population in Indicator 1. 12. Expenditures by Function (Per Capita) Expenditures shown in Indicator 7, divided by the population in Indicator 1 for each year. 13 Budget to Actual Revenues ) Source: Annual Financial Statement 14. Budget to Actual Expenditures ) Compares budget to actual figures for two fund types: general fund and special revenue funds. Not shown are debt service funds, capital projects funds, special assessment funds, any enterprise funds, or fiduciary (trust and agency) funds which are not required to be compared to budget by GAAP. 15. Outstanding Bonded Indebtedness The outstanding principal portion of three types of long -term debt is shown. The types are: general obligation (general obligation and general obliga- tion revenue); special assessment debt; and tax Increment financing bonds. Each amount is also shown divided by current population and by assessed valuation. 16. Bond Ratings Source: Bond rating services. Note that often cities are rated only in years when the city markets an issue. 17. Current Debt Service Costs Includes the principal and interest paid during the year on long -term debt by the governmental funds. Total debt redemption Interest and fiscal charges 18. Governmental Fund Liabilities Total liabilities of the governmental fund types. Includes accounts payable, outstanding principal of short term debt, certain long -term debt, and other liabilities. 19. Fund Balances (unreserved, undesignated) Source: Annual Financial Statement General Fund Special Revenue Funds 4 Immo IMMO Imosit 20. Opinion on Financial Report and Certificate of Achievement Unqualified opinion ■ In auditor's professional opinion, the financial sta- tements conform to generally accepted accounting principles (GAAP). Qualified opinion . In the auditor's opinion, the financial statements are not in conformity with generally accepted accounting principles. A common example is general fixed assets, which may not be accounted for in a manner prescribed by GAAP. A "Certificate of Achievement" is awarded by the Government Finance Officers Association to cities which exhibit excellence in financial reporting. This Is the highest form of recognition in the area of governmental financial reporting, and its attainment represents a significant accomplishment by a government and its management. 21. Number of Employees (Governmental Funds) Source: Data provided by individual cities. Full -time generally includes full -time only. Part -time includes part -time and part -time seasonal workers. 22. Compensation and Employer -Paid Fringe Benefits (Governmental Funds) Source: Reported by city personnel. Compensation covers governmental fund employees. Also reported are fringe benefits including sick leave, vacation leave; severance pay; employer contributions for retirement; employer payments for health, life and disability insurance; benefits and insurance premiums for unemployment compensation and workers compensation; the value of past retirement benefits and any other benefits. Some cities have estimated fringe benefits, while some provide actual dollar amounts. 22. Enterprises - Profit or Loss Includes operating revenues, expenses, operating income and net income for enterprises such as water, sewer, and electric. APPENDIX A ANALYSIS BY CLASS OF CITY 09/26/88 bow OFFICE OF THE STATE AUDITOR FINANCIAL HEALTH PROFILE SUMMARY BY CLABB OF CITY For the Year Ended December 31, 1987 CLABB 1 (Greater than 90,000 in Population) Indicator Averaoe ALLIIIMT. Minimum Total Revenues - S Year Percent Change Change 12.7% 21.S% 7.0% State Intergovernmental Revenues - S Year Percent Change Change 16.9% 44.4% 7.9% Federal Intergovernmental Revenues - S Year Percent Change Change -39.6% 0.0% -42.3% Local Intergovernmental Revenues - 5 Year Percent Change Change 36.7% 157.1% -41.2% Total intergovernmental Revenues - S Year Percent Change Change -5.3% 18.6% -11.8% Property Taxes as a Percent of Total Revenues 31.3% 33.4% 23.3% Special Assessments as a Percent of Total Revenues 3.0% 5.1% 1.5% Total Intergovernmental Revenues as • Percent of Total Revenues 40.2% 44.7% 39.5% Limited Levy as • Percent of the Total Levy S8.5% 68.6% 45.5% Total Current Expenditures Per Capita S 795.98 $ 980.69 $ 565.58 Total Revenues Per Capita s 907.78 $ 1,026.59 $ 718.36 Total Expenditures Per Capita $1,125.54 S 1,358.64 s 759.46 General Obligation Indebtedness Per Capita $ 496.77 S 701.35 S 454.85 General obligation Debt as a Percent of Assessed Valuation 6.5% 19.5% 4.9% Special Assessment Indebtedness Per Capita $ 62.33 S 88.41 S 22.62 Special Assessment Debt as a Percent of Assessed Valuation 0.8% 2.1% 0.3% Total liabilities (Governmental Funds) as a % of Total Revenues 39.4% 56.8% 27.4% Total fund Balance as • Percent of Total Current Expenditures 3.0% 4.1% 0.4% Interest Income as a Percent of Total Revenues S.S% 6.3% 3.7% Debt service as • Percent of Total Revenues 19.S% 22.8% 14.1% Full -time Employees Per 1,000 in Population (Governmental Funds) 10.6 11.2 8.8 _- Port-tine Employees Per 1,000 in Population (Governmental Funds) 1.3 6.5 1.1 Fringe Benefits as a Percent Total Payroll (Governmental Funds) 21.9% 30.9% 19.S% 09/26/88 OFFICE OF TEE STATE AUDITOR FINANCIAL HEALTH PROFILE SUMMARY BY CLASS OF CITY For the Year Ended December 31, 1987 CLASS 2 (20,000 to 90,000 in Population) Indicator Average Maximum Minimum Total Revenues - 5 Year Percent Change Change 39.4% 124.8% -4.6% State Intergovernmental Revenues - 5 Year Percent Change Change 28.0% 163.4% -5.7% Federal Intergovernmental Revenues - 5 Year Percent Change Change -42.9% 132.5% - 100.0% Local Intergovernmental Revenues - 5 Year Percent Change Change 37.4% 92.4% -100.0% Total Intergovernmental Revenues - 5 Year Percent Change Change 18.2% 135.8% -20.4% Property Taxes as a Percent of Total Revenues 29.0% 52.1% 18.0% Special Assessments as a Percent of Total Revenues 17.1% 49.8% 0.3% Total Intergovernmental Revenues as • Percent of Total Revenues 24.0% 46.5% 9.8% Limited Levy as a Percent of the Total Levy 54.8% 80.4% 41.9% Total Current Expenditures Per Capita S 325.79 S 534.39 S 161.42 Total Revenues Per Capita S 528.60 S 888.54 S 236.36 Total Expenditures Per Capita $ 637.32 S 1,050.61 S 258.41 General Obligation Indebtedness Per Capita S 270.08 S 1,322.09 S 0.00 General Obligation Debt as a Percent of Assessed Valuation 3.3% 11.1% 0.0% Special Assessment Indebtedness Per Capita S 440.11 S 1,490.99 S 16.71 Special Assessment Debt as a Percent of Assessed Valuation 5.4% 16.7% 0.3% Total liabilities (Governmental Funds) as a % of Total Revenues 83.6% 225.8% 17.7% Total fund Balance as • Percent of Total Current Expenditures 27.1% 68.2% 0.0% Interest Income as a Percent of Total Revenues 11.1% 23.8% 3.1% Debt Service as • Percent of Total Revenues 30.0% 87.7% 9.3% full -time Employees Per 1,000 in Population (Governmental Funds) 4.3 6.9 1.4 Part -time Employees Per 1,000 in Population (Governmental Funds) 3.8 13.2 0.6 Fringe Benefits as a Percent Total Payroll (Governmental Funds) 24.2% 37.2% 12.8% 09/26/88 Ilmwo Woo OFFICE OF THE STATE AUDITOR FINAINCIAL REALM PROFILE SUMMARY BY CLASS OF CITY For the Year Ended December 31, 1987 CLASS 3 (10,000 to 20,000 in Population) Indicator Total Revenues - 5 Year Percent Change Change Average Maximum Minimun 47.7% 183.4% 1.2% State Intergovernmental Revenues - 5 Year Percent Change Change 24.9% 81.6% -27.0% federal Intergovernmental Revenues - 5 Year Percent Change Change 14.6% 1,971.5% - 100.0% Local Intergovernmental Revenues - 5 Year Percent Charge Change -28.1% 4,177.2% - 100.0% Total Intergovernmental Revenues - 5 Year Percent Charge Change 22.6% 151.0% -23.7% Property Taxes as a Percent of Total Revenues 26.7% 54.6% 10.1% Special Assessments as a Percent of Total Revenues 16.7% 50.4% 1.0% Total Intergovernmental Revenues as • Percent of Total Revenues 33.7% 72.7% 11.4% Limited levy as a Percent of the Total Levy 58.5% 83.5% 31.2% Total Current Expenditures Per Capita S 339.22 S 769.37 $ 155.49 Total Revenues Per Capita S 545.66 S 947.53 S 244.03 Total Expenditures Per Capita S 660.39 S 1,311.35 S 247.81 General Obligation Indebtedness Per Capita S 284.11 S 1,902.64 S 0.00 General Obligation Debt as a Percent of Assessed Valuation 5.1% 49.7% 0.0% Special Assessment Indebtedness Per Capita $ 480.95 S 1,619.50 S 0.00 Special Assessment Debt as a Percent of Assessed Valuation 8.6% 37.7% 0.0% Total Liabilities (Governmental Funds) as a 2 of Total Revenues 76.1% 440.0% 9.9% Total Fund Balance as a Percent of Total Current Expenditures 33.1% 74.6% 2.5% Interest Income as a Percent of Total Revenues 7.0% 16.1% 1.1% Debt Service as • Percent of Total Revenues 30.8% 123.6% 7.4% full -time Employees Per 1,000 in Population (Governmental Funds) 4.9 13.0 1.6 Part -time Employees Per 1,000 in Population (Governmental funds) 6.2 22.4 0.0 fringe Benefits as a Percent Total Payroll (Governmental Funds) 21.4% 33.7% 0.0% 09/26/88 OFFICE OF THE STATE AUDITOR FINANCIAL HEALTH PROFILE SUMMARY BY CLASS OF CITY For the Year Ended December 31, 1987 CLASS 4 (Less Than 10,000 in Population) Indicator Total Revenues - 5 Year Percent Change Charge Average Maximus Minimum 28.8% ","*.•% - 100.0% State Intergovernmental Revenues - 5 Year Percent Charge Charge 24.4% * *, * * *.•% -100.0% Federal Intergovernmental Revenues - 5 Year Percent Change Change •18.3% " , * * *.•% -100.0% Local Intergovernmental Revenues - 5 Year Percent Charge Change -58.8% 3,982.7% - 100.0% Total Intergovernmental Revenues - 5 Year Percent Charge Charge 11.6% ",•• *.•% - 100.0% Property Taxes as • Percent of Total Revenues 27.8% •*, * * *.*% 8.3% Special Assessments as a Percent of Total Revenues 14.0% • *,• * *. *% 0.0% Total Intergovernmental Revenues as • Percent of Total Revenues 36.6% * *,• * *. *% 8.9% Limited Levy as a Percent of the Total Levy 19.1% 99.3% 0.0% Total Current Expenditures Per Capita S 305.23 S 637.36 S 0.00 Total Revenues Per Capita S 463.65 S 1,158.97 S 0.00 Total Expenditures Per Capita S 565.93 S 1,778.33 S 0.00 General Obligation Indebtedness Per Capita S 240.43 S 1,821.54 $ 0.00 General Obligation Debt as a Percent of Assessed Valuation 4.3% 53.4% 0.0% Special Assessment Indebtedness Per Capita S 444.05 S 1,874.48 S 0.00 Special Assessment Debt as • Percent of Assessed Valuation 7.9% 45.4% 0.0% Total Liabilities (Governmental Funds) as a % of Total Revenues 79.9% ••,• *•.•% 1.3% Total Fund Balance as a Percent of Total Current Expenditures 36.2% **,** *.*% -6.1% Interest Income as • Percent of Total Revenues 6.7% ","'.•% 0.6% Debt Service as a Percent of Total Revenues 27.9% ",*•'.*% 0.0% Full -time Employees Per 1,000 in Population (Governmental Funds) 4.1 9.2 0.2 Part -time Employees Per 1,000 in Population (Governmental Funds) 9.0 78.3 0.3 fringe Benefits as a Percent Total Payroll (Governmental Funds) 20.4X ",*'*.*% 0.0% APPENDIX B REGIONAL ANALYSIS Minnesota County Outline By Region OFFICE OF THE STATE AUDITOR Minnesota Financial Health Program Cities over 2,500 in Population ANALYSIS OF POPULATION 09/27/88 1 Year 5 Year 1983 1984 1985 1986 1987 % Change % Change Region 1 25,017 25,121 24,869 24,910 24,681 -0.9% -1.3% Region 2 14,205 14,410 14,245 13,944 13,827 -0.8% -2.7% Region 3 188,481 186,627 182,325 179,640 177,727 -1.1% -5.7% Region 4 71,151 72,261 72,246 72,067 72,280 0.3% 1.6% Region 5 31,471 31,504 31,695 31,761 31,738 -0.1% 0.8% Region 6E 39,171 39,604 39,904 40,009 40,267 0.6% 2.8% Region 6u 15,485 15,644 15,431 15,379 15,271 -0.7% -1.4% '- Region 7E 9,241 9,299 9,412 9,351 9,483 1.4% 2.6% Region 7w 79,012 79,392 81,006 82,366 85,837 4.2% 8.6% Region 8 44,413 44,820 44,882 44,571 44,636 0.1% 0.5% Region 9 99,157 99,420 100,442 99,967 100,339 0.4% 1.2% Region 10 212,316 214,109 216,409 216,982 218,949 0.9% 3.1% Region 11 1,914,117 1,936,734 1,964,982 1,993,568 2,026,109 1.6% 5.9% Total 2,743,237 2,768,945 2,797,848 2,824,515 2,861,144 1.3% 4.3% OFFICE OF THE STATE AUDITOR Minnesota Financial Health Program Cities over 2,500 in Population ANALYSIS OF GROSS RETAIL SALES 09/27/88 1 Year 5 Year 1983 1984 1985 1986 1987 % Change % Change Region 1 196,691,594 216,523,255 220,947,878 215,153,915 195,491,120 -9.1% -0.6% Region 2 181,380,902 197,807,047 213,937,294 213,716,584 227,981,141 6.7% 25.7% Region 3 1,255,629,955 1,382,001,702 1,384,832,712 1,402,951,985 1,428,631,034 1.8% 13.8% Region 4 576,849,433 610,825, 914 636 ,278,792 634,948,737 664,200,661 4.6% 15.1% Region 5 361,344,629 392,902,316 404,534,853 433,433,128 439,186,702 1.3% 21.5% Region 6E 313, 836, 649 349, 172, 023 348 ,727,619 365,198,022 385,946,960 5.7% 23.0% Region 6W 132,455,563 143,277,242 139,408,817 127,384,369 138,273,348 8.5% 4.4% Region 7E 129,433,975 140,657,751 135,978,696 131,616,879 140,790,859 7.0% 8.8% Region 7W 674,526,701 755, 048, 092 825 ,227,366 964,968,731 950,853,707 -1.5% 41.0% Region 8 395,483,103 406,363,164 400,886,382 400,171,349 433,012,295 8.2% 9.5% Region 9 647,216,362 703,805,166 716 ,502,850 725,500,034 776,013,206 7.0% 19.9% Region 10 1,608,139,650 1,774,719,198 1,787,723,921 1,825,358,693 1,960,885,185 7.4% 21.9% Region 11 12,376,666,378 14,100,243,994 14,926,528,719 16,430,806,859 17,449,652,491 6.2% 41.0% Total 18,849,654,894 21,173,346,864 22,141,535,899 23,871,209,285 25,190,918,709 5.5% 33.6% 09/27/88 OFFICE OF THE STATE AIAIT0R Minnesota Financial Health Program Cities over 2,500 in Population ANALYSIS OF NUMBER OF RETAIL BUSINESSES 1 Year 5 Year 1983 1904 1945 1986 1987 % Change % Change Region 1 428 449 428 446 408 -8.5% -4.7% Region 2 539 598 604 609 628 3.1% 16.5% Region 3 3,466 3,618 3,646 3,493 3,413 -2.3% -1.5% Region 4 1,600 1,635 1,642 1,679 1,647 -1.9% 2.9% Region 5 1,010 1,049 1,058 1,039 1,022 -1.6% 1.2% Region 6E 856 891 935 938 909 -3.1% 6.2% Region 6w 457 460 442 428 417 -2.6% •8.8% Region 7E 342 339 360 363 366 G.8% 7.0% Region 74 1,405 1,514 1,604 1,594 1,615 1.3% 14.9% Region 8 1,062 1,078 1,079 1,042 1,025 -1.6% -3.5% Region 9 1,848 1,925 1,959 1,936 1,857 -4.1% 0.5% -'" Region 10 3,915 4,093 4,070 4,013 3,982 -0.8% 1.7% Region 11 21,795 22,510 22,829 23,329 23,110 -0.9% 6.0% Total 38,723 40,159 40,656 40,909 40,399 -1.2% 4.3% 09/27/88 OFFICE OF THE STATE AUDITOR Minnesota Financial Health Program Cities over 2,500 in Population ANALYSIS OF NUMBER OF BUILDING PERMITS ISSUED DURING THE TEAR 1 Year 5 Year 1983 1984 1985 1986 1987 % Change 2 Change Region 1 599 530 514 503 533 6.0% -11.0% Region 2 227 289 282 288 328 13.9% 44.5% Region 3 3,885 3,888 3,323 3,396 3,943 16.1% 1.5% Region 4 1,128 1,199 1,222 1,491 1,365 -8.5% 21.0% Region 5 687 642 748 689 784 13.8% 14.1% Region 6E 1,067 613 918 897 774 -13.7% -27.5% Region 6u 299 321 282 229 236 3.1% -21.1% Region 7E 234 249 236 311 330 6.1% 41.0% Region 7W 1,575 1,547 1,756 1,800 2,326 29.2% 47.7% Region 8 946 965 807 856 800 -6.5% -15.4% Region 9 2,466 2,478 2,444 2,354 2,441 3.7% -1.0% Region 10 4,872 4,680 4,660 4,782 4,737 -0.9% -2.8% Region 11 42,268 48,563 49,178 53,257 59,497 11.7% 40.8% Total 60,253 65,964 66,370 70,853 78,094 10.2% 29.6% 09/27/88 OFFICE OF THE STATE AUDITOR Minnesota Financial Nealth Program Cities over 2,500 in Population ANALYSIS OF VALUE OF BUILDING PERMITS ISSUED DURING THE YEAR 1 Year 5 Year 1983 1984 1985 1986 1987 % Change % Change Region 1 6,014,300 5,895,123 8,403,602 6,868,790 7,055,332 2.7% 17.3% Region 2 19,306,815 7,698,765 10,598,112 11,258,705 9,004,705 -20.0% -53.4% Region 3 42,913, 707 63, 096, 814 32,442,063 82,241,551 75,676,349 -8.0% 76.3% Region 4 28,161,095 27,055, 489 38, 371, 799 30 ,242,050 36,509,263 20.7% 29.6% Region 5 20,723,683 28,951,594 17,676,814 15,263,786 23,047,025 51.0% 11.2% Region 6E 22,658,261 20,295,333 32,224,538 24,735,146 34,509,481 39.5% 52.3% Region 6W 6,819,006 3,797,228 2,682,697 2,506,778 2,827,295 12.8% -58.5% Region 7E 10,612,355 9,734,470 10,348,140 9,096,769 11,537,737 26.8% 8.7% Region 7W 64,093,487 75,320,130 91,117,477 88,203,621 124,844,624 41.5% 94.8% Region 8 23,891,360 18,236,205 15,875,069 14,957,066 21,800,525 45.8% -8.8% Region 9 45,576,668 46,025,865 41,355,892 52,012,580 48,339,065 -7.1% 6.1% Region 10 128,193,894 189,890,242 160,378,885 180,444,255 195,797,576 8.5% 52.7% Region 11 1,719,669,991 2,143,648,331 2,608,108,627 3,122,627,188 3,404,655,891 9.0% 98.0% Total 2,138,634,622 2,639,645,589 3,069,583,715 3,640,458,285 3,995,604,868 9.8% 86.8% 09/27/88 OFFICE OF THE STATE AUDITOR Minnesota Financial Health Program Cities over 2,500 in Population ANALYSIS OF UNDESIGNATED, UNRESERVED GENERAL FUND BALANCE 1 Year 5 Year 1983 1984 1985 1906 1987 % Change % Change Region 1 1,881,916 2,112,273 2,215,014 2,467,101 2,759,584 11.9% 46.6% Region 2 1,782,977 2,095,549 2,546,753 2,738,777 2,758,227 0.7% 54.7% Region 3 13,219,189 15,771,128 14,527,731 16,156,001 15,586,701 -3.5% 17.9% Region 4 5,229,017 6,270,381 7,520,540 8,205,006 9,655,712 17.7% 84.7% Region 5 2,431,434 2,964,188 3,601,942 3,782,856 4,406,954 16.5% 81.2% Region 6E 2,107,826 2,048,550 1,808,121 2,348,402 2,725,886 16.1% 29.3% Region 6W 1,367,039 1,105,382 903,702 1,162,373 1,230,973 5.9% -10.0% Region 7E 567,583 424,260 440,549 420,395 557,963 32.7% -1.7% Region 7w 7,098,585 8,887,229 10,570,958 11,975,829 13,024,867 8.8% 83.5% Region 8 4,738,125 5,000,392 5,139,714 4,924,192 4,912,964 -0.2% 3.7% Region 9 5,916,435 7,601,605 8,683,008 9,588,881 10,025,841 4.6% 69.5% Region 10 22,701,828 27,030,677 27,682,469 29,753,900 31,080,918 4.5% 36.9% Region 11 91,616,891 106,503,232 116,049,883 131,385,935 132,370,835 0.7% 44.5% Total 160,658,845 187,814,846 201,690,384 224,909,648 231,097,425 2.8% 43.8% 09/27/88 OFFICE OF THE STATE AUDITOR Minnesota Financial Health Program Cities over 2,500 in Population ANALYSIS OF SPECIAL ASSESSMENT BONDED INDEBTEDNESS 1 Year 5 Year 1983 1984 1985 1986 1987 % Change % Change Region 1 11,585,000 12,245,000 11,075,000 10,200,000 9,240,000 -9.4% -20.2% Region 2 4,319,800 4,824,900 4,520,000 4,591,600 4,113,200 •10.4% -4.8% Region 3 15,288,000 15,995,000 15,051,000 14,227,000 15,612,000 9.7% 2.1% Region 4 30,009,112 28,756,173 27,220,635 24,519,597 23,013,558 -6.1% -23.3% Region 5 11,419,400 12,386,400 12,226,400 11,785,400 9,857,400 -16.4% -13.7% Region 6E 19,250,000 20,310,000 20,350,000 19,930,000 21,180,000 6.3% 10.0% Region 6W 3,351,104 3,463,604 3,941,104 3,593,604 4,222,170 17.S% 26.0% Region 7E 4,265,249 4,349,249 4,418,000 3,446,000 3,079,000 -10.7% -27.8% Region 7W 53,549,500 49,841,000 44,762,000 53,477,000 53,866,000 0.7% 0.6% Region 8 13,001,000 13,417,800 13,619,700 12,929,200 14,222,400 10.0% 9.4% Region 9 40,200,000 41,650,000 46,365,000 49,005,000 47,890,000 -2.3% 19.1% Region 10 55,848,500 58,157,000 59,320,000 63,437,000 61,090,000 -3.7% 9.4% Region 11 704,191,242 694,551,078 711,988,992 730,056,670 747,202,206 2.3% 6.1% Total 966,277,907 959,947,204 975,157,831 1,001,198,071 1,014,587,934 1.3% 5.0% 09/27/88 OFFICE OF THE STATE AUDITOR Minnesota Financial Health Program Cities over 2,500 in Population ANALYSIS OF GENERAL OBLIGATION AND G.O. REVENUE BONDED INDEBTEDNESS 1 Year 5 Year 1983 1984 1985 1986 1987 % Change % Change Region 1 12,350,000 11,773,000 11,068,000 10,620,000 10,603,000 -0.2% -14.1% Region 2 2,070,000 5,222,500 4,635,000 2,562,500 3,535,000 38.0% 70.8% Region 3 76, 667, 000 80,767,000 86,435,000 86,000,000 104,384,334 21.4% 36.2% Region 4 11,759,188 14,295,927 18,306,265 18,288,603 18,321,942 0.2% 55.8% Region 5 2,606,000 4,296,500 4,497,000 4,252,500 3,552,500 - 16.5% 36.3% Region 6E 28,695,000 17,760,000 40,445,000 27,770,000 34,750,000 25.1% 21.1% Region 6W 11,229,896 11,077,396 8,013,000 8,650,000 10,690,000 23.6% -4.8% Region 7E 312,000 192,000 107,000 57,000 17,000 -70.2% -94.6% Region 711 14,472,500 13,990,000 16,030,000 17,800,000 18,855,000 5.9% 30.3% Region 8 21,240,000 21,226,200 23,689,000 20,355,800 19,260,600 -5.4% -9.3% Region 9 23,670,000 20,895,000 20,050,000 20,475,000 21,410,000 4.6% -9.5% Region 10 51,989,000 52,675,000 54,875,000 53,780,653 54,517,653 1.4% 4.9% Region 11 408,488,965 446,130,637 491,776,848 596,291,000 622,678,000 4.4% 52.4% Total 665,549,549 700 ,301,160 779,927,113 866,903,056 922,575,029 6.4% 38.6% 09/27/88 OFFICE OF THE STATE AUDITOR Minnesota Financial Health Program Cities over 2,500 fn Population ANALYSIS OF TOTAL CURRENT EXPENDITURES 1 Year 5 Year 1983 1984 1985 1966 1987 2 theme 2 Change Region 1 8,824,791 9,625,755 10,575,775 11,284,650 11,820,285 4.7% 33.9% Region 2 3,690,269 4,144,951 4,219,657 4,339,171 4,374,336 0.8% 18.5% Region 3 73, 627, 607 80,290,798 85,196,490 82,947,285 87,594,661 5.6% 19.0% Region 4 21,418,861 23,810,703 24,517,911 25,109,742 24,377,310 -2.9% 13.8% Region 5 7,419,633 8,033,852 8,165,666 8,980,787 9,406,047 4.7% 26.8% Region 6E 11,356,412 12,081,720 12,828,799 13,041,074 14,217,662 9.0% 25.2% Region 6W 4,280,228 4,865,840 5,278,996 5,265,585 5,193,377 -1.4% 21.3% Region 7E 2,995,399 2,957,132 3,239,087 1,825,978 1,870,865 2.5% -37.5% Region 711 22,707,900 23,379,722 27,624,565 28,020,813 29 - 29.5% Region 8 12,624,248 15,114,439 15,566,661 15,564,989 16,242,343 4.42 28.7% Region 9 28,159,022 29,223,922 31,092,566 32,427,431 33,471,287 3.2% 18.9% Region 10 63,482,209 71,067,930 77,199,539 83,402,045 89,999,001 7.9% 41.8% Region 11 695,651,718 741 ,208,092 798,669,021 867,181,221 930,311,945 7.3% 33.7% Total 956,238,297 1,027,804,856 1,104,174,733 1,179,390,771 1,258,289,316 6.7% 31.6% OFFICE OF THE STATE AUDITOR Minnesota Financial Health Program Cities over 2,500 in Population ANALYSIS OF INDICATED MARKET VALUE 1983 1984 1985 1986 Region 1 421,260,976 391 ,707,071 383,799,766 402,780,983 Region 2 216,898,739 235,276,539 09/27/88 1 Year 5 Year 1987 % Change % Charge 372,473,254 -7.5% -11.6% 232 ,528,982 231,333,184 232,132,304 0.3X 7.0% 2,668,570,852 -8.3% -24.3% 1,232,010,551 -8.5% -4.3% 561,930,868 559,186,812 548,142,321 -2.0% 0.7% 863,577,008 879,640,782 807,789,100 -8.2% -1.3% 253 ,686,888 256,218,943 236,928,006 -7.5% -5.8% 212,946,164 226,856,724 219,746,964 -3.1% 9.5% 2,048,742,418 0.7X 18.6% 879,118,945 891,337,740 780,679,559 -12.4% -10.0% 1,913,564,125 -8.2% -4.4% 5,126,610,156 -6.6% 1.9% 7,734,013,642 2.9% 9.4% 1.0% 6.5% Region 3 3,524,011,457 3,335,893,024 3,036,220,506 2,909,806,721 Region 4 1,286,844,077 1,293,243,075 1,302,002,964 1,346,448,831 Region 5 544,368,457 556,901,256 Region 6E 818,369,597 817,330,649 Region 6u 251,590,068 261,619,273 Region 7E 200,647,315 202,665,859 Region 711 1,727,657,391 1,816,846,160 1,914,496,065 2,034,952,489 Region 8 867,113,992 852,560,930 Region 9 2,001,170,107 1,996,937,338 2,004,693,625 2,084,962,632 Region 10 5,030,015,542 4,885,777,882 5,180,017,869 5,491,720,018 Region 11 61,921,315,024 61,790,347,592 63,643,609,626 65,807,841,976 6 Total 78,811,262,742 78,437,106,648 80, 468, 629, 276 83,123,087,835 83,921,403,252