The URL can be used to link to this page

Home My WebLink AboutStatisticSection2007CAFR CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION City of Auburn STATISTICAL SECTION December 31,2007 Financial Trends Information Financial trends schedules are intended to provide users with information to assist them in understanding and assessing how the City's financial position has changed over time. Schedule 1 Schedule 2 Schedule 3 Schedule 4 Schedule 5 Net assets by component...................................................................... 132 Changes in net assets........................................................................... 133 Fund balances, government funds........................................................ 132 Changes in fund balances, government funds ...................................... 135 Tax revenues by source, government funds .........................................136 Revenue Capacity Information The objective of providing revenue capacity information is to help users understand and assess the factors affecting the City's ability to generate its most significant local source revenues. Schedule 6 Schedule 7 Schedule 8 Schedule 9 Schedule 10 Assessed value by type.........................................................................137 Property tax data................................................................................... 138 Property tax levies and collections ........................................................140 Principal taxpayers-property taxes ........................................................ 141 Retail tax collections by sector ..............................................................142 Debt Capacity Information Debt capacity information is intended to assist users to understand and assess the City's current levels of outstanding debt and ability to issue additional debt in the future. Schedule 11 Schedule 12 Schedule 13 Schedule 14 Schedule 15 Schedule 16 Ratios of outstanding debt by type ........................................................143 Computation of legal debt margin.......................................................... 144 Legal debt margin ratios ........................................................................ 144 Computation of net direct and estimated overlapping debt ...................145 Ratio of net general bonded debt to assessed value ............................146 Pledged revenue bond coverages......................................................... 147 Demographic and Economic Information These schedules offer demographic and economic information to assist users in understanding certain aspects of the environment within which the City operates and to provide information that facilitates comparisons of financial statement information over time and across governmental units. Schedule 17 Population, income and housing trends ................................................148 Schedule 18 Major employers .................................................................................... 149 Operating Information These schedules contain service and infrastructure data to help users understand how the information in the City's financial report relates to the services the City provides and the activities it performs. Schedule 19 Staffing levels by department................................................................150 Schedule 20 Operating indicators by department ......................................................151 Schedule 21 Capital indicators by department........................................................... 152 131 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN, WASHINGTON SCHEDULE 1 NET ASSETS BY COMPONENTS LAST FIVE FISCAL YEARS (I) (ACCRUAL BASIS OF ACCOUNTING) 2003 2004 2005 2006 2007 Governmental activities: Invested in capital assets, net of related debt $ 167,057,262 $ 171,921,373 $ 194,121,232 $ 200,814,063 $ 212,611,232 Restricted 23,384,709 25,615,116 23,442,309 26,839,342 24,519,024 Unrestricted 29,547,005 28,490,736 24,095,336 24,148,157 26,774,107 iTotal governmental activities net assets $ 219,988,976 $ 226,027,225 $ 241,658,877 $ 251,801,562 $ 263,904,363 . Business-type activities: Invested in capital assets, net of related debt $ 104,513,351 $ 106,783,634 $ 115,137,273 $ 125,265,152 $ 130,515,163 Restricted 1,919,515 1,969,809 2,238,611 6,987,485 1,227,395 Unrestricted 29,489,320 31,849,110 32,513,576 25,693,517 40,655,261 !Total business-type activities net assets $ 135,922,186 $ 140,602,553 $ 149,889,460 $ 157,946,154 $ 172,397,8191 Primary government: Invested in capital assets, net of related debt $ 271,570,613 $ 278,705,007 $ 309,258,505 $ 326,079,215 $ 343,126,395 Restricted 25,304,224 27,584,925 25,680,920 33,826,827 25,746,419 Unrestricted 59,036,325 60,339,846 56,608,912 49,841,674 67,429,368 ITotal primary government net assets $ 355,911,162 $ 366,629,778 $ 391,548,337 $ 409,747,716 $ 436,302,182 . (1) Information available for 2003-2007 only due to new accounting and reporting standards beginning in 2003 with GASB Statement No. 34. Source: City of Auburn, Finance Department 132 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION Expenses Governmental activities: General govemment Public safety Transportation Physical environment Culture and recreation Economic environment Health and human services Interest on long-tenn debt Total govemmental activities expenses Business-type activities: Water Sewer Storm drainage Solid waste Golf course Non-major business-type activities Total business-type activities expenses ~Rrima!y' government ex~enses CITY OF AUBURN, WASHINGTON SCHEDULE 2 CHANGES IN NET ASSETS LAST FIVE FISCAL YEARS (1) (ACCRUAL BASIS OF ACCOUNTING) 2003 2004 2005 2006 2007 5,968,367 4,235,953 5.284.440 6.462,578 7,196.492 23,045,701 26,076,348 28,048,087 29,804,864 33,396,630 3,071,195 8,239,795 7,956,286 7,619.268 8,077.154 1,845,059 2.415,047 2.209,652 2.418,543 3,269,334 5,108,683 4,949,050 5,324,543 5,729.431 6,539.281 1,379,552 2,866.473 1,919,780 1,848,988 2.400,031 639,678 597.423 602,726 763,156 416.456 322,653 362,051 188.945 203,180 163,916 41,380,888 49,742,140 51,534.459 54,850,008 61.459.294 6.868,291 6,913,709 6,962.997 7,647,935 7,873,191 9,949,763 11,207,786 12,044,330 11,878.252 13,974,607 2,955,179 3,169,350 3,354,899 3,852,335 4,224,881 8,553,801 8,645,372 9,121,727 9,936.222 10,368,901 874,809 973,110 1,032,733 1,020,070 1,576,126 1,730,969 1,624,365 1,593,944 1,618.285 1,735,118 30,932,812 32,533,692 34,110,630 35,953,099 39,752,824 72.313.700 82.275,832 85.645.089 90,803.107 101.212,1181 Program revenues Governmental activities: Charges for services Public safety fines, fees and forfeitures Develoment fees and connection charges Transportation impact and mitigation fees Parks and recreation fees Other activities Total charges for services Operating grants and contributions Capital grants and contributions Total govemmental activities program revenues Business-type activities: Charges for services Operating grants and contributions Capital grants and contributions Total business-type activities program revenues Total primary govemment program revenues 1,396,252 1,581,812 1,943.468 1,935,689 2,691,182 2,088,948 3.478.451 3.429,516 2,946,785 2,529,594 582,384 372.925 987,033 517,728 1,844,921 642,183 618.485 692,385 772,857 1,157.208 498,651 841,391 913,082 1,702,317 1,827,025 5.208,418 6,893,064 7,965.484 7,875,376 10,049,930 1,959,919 2,178,951 2.445,913 2,714,324 2,923,968 12,336,814 5,192,593 11,162,241 5,174,350 9,213,115 19,505,151 14,264,608 21,573,638 15,764,050 22,187,013 31.233.491 31,747,066 32,658.440 36,226,324 38,784,127 33,384 33,384 54,999 47,961 43.263 6,985,742 4,351.278 7,857,856 3,988.202 12.479,500 38.252,617 36,131,728 40,571,295 40,262.487 51,306,890 57,757,768 50,396,336 62,144,933 56,026,537 73.493,903 (21,875,737) (35.477.532) (29,960,821 ) (39,085,958) (39,272.281) 7,319,805 3,598,036 6.460,665 4,309,388 11,554,066 ( 14,555.932) (31,879.496) , (23.500,156) , (34.776,570)= $ (27.718.215)1 12.440,724 12,598,954 13.464,390 15,186.456 16,164,073 13,970,383 15.429,527 16,333,169 17,784,374 18,958.484 1 ,696,389 1,714,102 1,792,136 1,983,652 2,095,901 4.225,725 5,012,010 5,349,713 5,893,041 6,073.429 3.401.498 3,384,515 4,633,037 4,568,549 3,862,692 1,699,275 1,678.485 1,796,224 1,859.428 2,005,836 769,239 708.259 1.465,102 2.454,694 2,993,174 96,168 192.469 564.416 69,037 (406,847) (1.225,054) 627,000 194,286 (570,588 ) (371,660) 37,074,347 41,345,321 45,592.473 49,228,643 51,375,082 306,862 421,803 895,870 1,574.444 2,098.417 545,087 1,287,528 2,124,658 1,602.274 427,522 1.225.054 (627.000) (194.286) 570.588 371.660 2.077.003 1,082,331 2,826.242 3,747,306 2,897,599 39.151.350 42.427.652 48.418.715 52.975.949 ~ $ 54.272.6811 15,198,610 5,867,789 15,631,652 10,142,685 12,102,801 9,396,808 4,680,367 9.286,907 8,056,694 14.451,665 24,595.418 10.548,156 24.918.559 18.199,379 = $ 26.554.4661 Net (expense )/revenue Governmental activities Business-type activities ~Rrima!y govemment net exp-ense General revenues and other changes in net assets Governmental activities: Taxes: Property taxes Retail sales and use tax Interfund utility taxes Utility taxes Excise taxes Other taxes Investment earnings Miscellaneous Transfers Total govemmental activities Business-type activities: Investment earnings Miscellaneous Transfers Total business-type activities: ~RNma!y govemment Change in net assets Governmental activities Business-type activities I:@'[RrimaQ',,9ovemmenf (1) Information available for 2003-2007 only due to new accounting and reporting standards beginning in 2003 with GASB Statement No. 34. Source: City of Auburn, Finance Department 133 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN, WASHINGTON SCHEDULE 3 FUND BALANCES, GOVERNMENT FUNDS LAST FIVE FISCAL YEARS (I) (MODIFIED ACCRUAL BASIS OF ACCOUNTING) 2003 2004 2005 2006 2007 General Fund Reserved $ 9,425 $ 9,625 $ 10,125 $ 10,125 $ 10.125 Unreserved 18.487.070 20,692,625 15.928.700 14,438,203 14.452,595 ITotal general fund $ 18.496.495 $ 20.702.250 $ 15.938.825 $ 14.448.328 $ 14.462.720 . All other governmental funds Reserved $ 1,133,206 $ 1,270.769 $ 1,375.591 $ 1,376.798 $ 1,501,033 Unreserved. reported in: Special revenue funds 9.776.846 10,612,069 8.967.039 10,738,431 13,124,661 Capital projects funds 13.930,030 13,852,020 13.111.273 14,727,423 9.873,331 Permanent funds 233,800 222,020 232,832 188,524 170,983 lTotal all other governmental funds $ 25,073,882 $ 25.956,878 $ 23,686,735 $ 27.031,176 $ 24,670,008 . (1) Information available for 2003-2007 only due to new accounting and reporting standards beginning 2003 with GASB Statement No. 34. Source: City of Auburn. Finance Department 134 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN, WASHINGTON SCHEDULE 4 CHANGES IN FUND BALANCES, GOVERNMENT FUNDS LAST FIVE FISCAL YEARS (I) (MODIFIED ACCRUAL BASIS OF ACCOUNTING) 2003 2004 2005 2006 2007 Revenues Taxes $ 35,734,592 $ 38,258,799 $ 41,467,853 $ 44,867,161 $ 46,721,651 Licenses and permits 1,255,582 2,248,576 2,227,963 1,683,320 1,606,950 Intergovernmental 6,756,672 4,697,501 6,826,222 6,831,240 5,766,484 Charges for services 2,924,962 3,393,178 3,939,610 3,659,773 5,017,224 Fines and forfeits 836,244 845,721 777,241 1,054,201 2,155,120 Special assessments 177,588 127,976 153,627 75,574 52,291 Investment earnings 300,213 336,442 1,175,258 1,477,368 2,456,291 Miscellaneous 1,102,089 2,452,468 1,247,252 1,865,079 877,473 Total revenues 49,087,942 52,360,661 57,815,026 61,513,716 64,653,484 Expenditures General government 5,737,882 5,472,630 5,308,663 6,062,037 6,834,084 Public safety 22,658,127 25,870,873 27,169,657 29,148,278 33,568,753 Transportation 4,327,863 5,152,344 10,337,587 9,403,147 7,385,929 Physical environment 1,911,616 2,304,248 2,191,796 2,435,201 3,352,466 Economic environment 1,316,782 2,796,902 1,877,675 1,928,978 2,142,282 Health and human services 639,678 597,423 602,726 763,156 416,456 Culture and recreation 4,453,173 4,806,217 4,815,643 5,016,554 6,571,275 Capital outlay (2) 3,357,827 12,100,966 507,484 3,822,895 7,346,316 Debt service: Principal 1,162,465 1,018,355 10,582,246 420,631 435,093 Interest / other 333,439 248,005 315,960 247,551 203,266 Total expenditures 45,898,852 60,367,963 63,709,437 59,248,428 68,255,920 Excess of revenues over (under) expenditures 3,189,090 (8,007,302) (5,894,411 ) 2,265,288 (3,602,436) Other financing sources (uses) Transfers in 5,458,804 3,946,424 9,753,294 8,873,200 6,103,144 Transfers out (6,561,204) (3,319,424) (11,703,804) (9,554,816) (5,542,988) Capital leases 10,350,000 695,504 Proceeds of long-term debt 142,313 Sales of capital assets 26,930 119,053 811,353 127,959 Total other financing sources (uses) (1,075,470) 11,096,053 (1,139,157) (411,344) 1,255,660 :Net change in fund balances $ 2,113,620 $ 3,088,751 $ (7,033,568) $ 1,853,944 $ (2,346,776)) Debt service as a percentage of noncapital expenditures 3.52% 2.62% 17.24% 1.21% 1.05% (1) Information available for 2003-2007 only due to new accounting and reporting standards beginning 2003 with GASB Statement No. 34. (2) Capital outlay of $7,346,316 for 2007 is for Governmental Funds only. Proprietary Funds captial outlay was $4,048,584 for total capital outlay of $11,394,900 as reported on the Reconciliation of the Statement of Revenues, Expenditures, and Changes in Fund Balances of Governmental Funds to the Statememt of Activities. Source: City of Auburn, Finance Department 135 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN, WASHINGTON SCHEDULE 5 TAX REVENUES BY SOURCE, GOVERNMENT FUNDS LAST TEN FISCAL YEARS Fiscal Sales Interfund Year Property & Use Utility Utility Excise Other Total 1998 $ 9,099,783 $ 10,976,666 $ 874,342 $ 3,627,891 $ 336,420 $ 68,826 $ 24,983,928 1999 9.224,087 12,388,117 913,629 3,694,650 603,461 83,858 26,907,802 2000 10.209,181 13,376,907 972,327 4,704.155 850,570 78.265 30,191,405 2001 11,016,263 13,467,184 1,016,366 6,143,060 1,172,417 44,660 32,859,950 2002 11,673,939 13,568,518 1,078,845 4,193,983 829,537 52,839 31,397,661 2003 12,396,502 13,970,383 1,696,389 4,225,725 3,401 ,498 44,095 35,734,592 2004 12,680,361 15,429,527 1,714,102 5,012,010 3,384,515 38,284 38,258,799 2005 13,319,740 16,333,169 1,792,136 5,349,713 4,633,037 40,058 41,467,853 2006 14,582,829 17,784,374 1,983,652 5,893,041 4,568,549 54,716 44,867,161 2007 15,666,016 18,958,484 2,095,901 6,073,429 3,862.692 65,129 46,721,651 Change 1998-2007 72.2% 72.7% 139.7% 67.4% 1048.2% -5.4% 87.0% Fiscal years 1998-2002 include tax revenues collected in the general and special revenue funds. Fiscal years 2003-2007 include all governmental funds. Source: City of Auburn, Finance Department FIGURE 5: TAX REVENUES BY SOURCE 1998 - 2007 $50,000 $45,000 $40,000 $35,000 Vi" -g $30,000 III gJ $25,000 .,g $20,000 I- ~ $15,000 $10,000 $5,000 $0 . Excise & other o Utility o Interfund utility . Sales & use o Property 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 136 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN, WASHINGTON SCHEDULE 6 ASSESSED VALUE BY TYPE LAST TEN FISCAL YEARS ~MOUNTSEXPRESSEDINTHOUSAND~ State Total Total Fiscal Property Personal Land and Assessed Direct Year and Other Property Building Value Rate 1998 $ 84,456 $ 719,317 $ 2,200,628 $ 3,004,401 $ 3.10 1999 82,105 746,579 2,345,551 3,174,235 3.04 2000 104,117 751,709 2.510,519 3,366,345 3.00 2001 115,189 800,159 3,104,524 4,019,872 2.99 2002 140,531 787,022 3,344,271 4,271,824 2.93 2003 150,458 742,255 3,599,466 4,492,179 2.93 2004 137,611 704,061 3,834,629 4,676,301 2.87 2005 116,895 623,298 4,359,276 5,099,469 2.87 2006 101,419 607,875 5,055,734 5.765,028 2.73 2007 107,302 635,352 5.783,641 6.526,295 1.48 Source: King County and Pierce County Departments of Assessments $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $0 FIGURE 6: ASSESSED VALUE BY TYPE 1998 - 2007 J J J J J .J J J J J 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 137 o State property o Personal property . Land and building CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN, WASHINGTON SCHEDULE 7 PROPERTY TAX DATA LAST TEN FISCAL YEARS Page 1 of 2 Item 1998 1999 2000 2001 Assessed and estimated actual values (1) Estimated and actual value (in thousands) $ 3,004,401 $ 3,174,235 $ 3,366,345 $ 4,019,872 Assessed value (in thousands) $ 3,004,401 $ 3,174,235 $ 3,366,345 $ 4,019,872 Ratio of assessed to actual 100% 100% 100% 100% Property tax rates (1) Direct regular and special General fund $ 3.10000 $ 3.04212 $ 3.00157 $ 2.98932 Debt service funds Subtotal $ 3.10000 $ 3.04212 $ 3.00157 $ 2.98932 Overlapping regular and special (1) Auburn School District $ 5.56770 $ 5.86647 $ 5.80795 $ 5.47999 King County 1.85109 1 .77385 1.68951 1.55218 State of Washington 3.51138 3.35872 3.30278 3.14502 Port of Seattle 0.26466 0.23898 0.21585 0.19029 Hospital district and emergency services 0.15934 0.44354 0.39129 0.34497 Valley Regional Fire Authority Subtotal 11.35417 11.68156 11.40738 10.71245 Total direct and overlapping $ 14.45417 $ 14.72368 $ 14.40895 $ 13.701771 Sources: (1) King County and Pierce County Deparments of Assessments; real and personal property has been assessed at 100% of the estimated actual value. (2) The decrease in property tax levy to $1.48 for 2007, for collection in 2008, is due to incorporation of the new Valley Regional Fire Authority effective 1/1/07. The VRFA will assess its own property tax levy in 2008, partially offsetting what was previously levied by the City. FIGURE 7A: TEN YEARS CITY PROPERTY TAX RATES 1998 - 2007 $3.50 c o ~ ro > " Q) Vl Vl Q) Vl Vl <( (; o o o_ W Q; $1.50 D- $3.00 $2.50 $2.00 $1.00 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 (2) 138 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION 2002 2003 2004 2005 2006 Page 2 of 2 2007 (2) $ 4,271,824 $ $ 4,271,824 $ 100% 4,492,179 $ 4,492,179 $ 100% 4,676,301 $ 4,676,301 $ 100% 5,099,469 $ 5,099,469 $ 100% 5,765,028 $ 5,765,028 $ 100% 6,526,295 6,526,295 100% $ 2.93353 $ 2.92857 $ 2.87319 $ 2.86520 $ 2.73076 $ 1 .48385 $ 2.93353 $ 2.92857 $ 2.87319 $ 2.86520 $ 2.73076 $ 1 .48385 $ 5.47810 $ 5.35720 $ 5.34914 $ 5.37383 $ 4.94903 $ 4.40970 1 .44949 1.34948 1.43146 1.32869 1.28956 1.20770 2.98946 2.89680 2.75678 2.49787 2.32535 2.18733 0.18956 0.25895 0.25402 0.23330 0.23158 0.22359 0.34643 0.33397 0.32917 1 .04884 0.76273 0.81836 1 .00000 10.45304 10.19640 10.12057 10.48253 9.55825 9.84668 1$ 13.38657 $ 13.12497 $ 12.99376 $ 13.34773 $ 12.28901 $ 11.33053 I FIGURE 78: PROPERTY TAX RATES Last Ten Fiscal Years . Hospital district and emergency services $14.00 '0$12.00 c ~ $10.00 :J ~,g $8 00 ..!!ll- . o ~ o If. $6.00 ~ $4.00 0:: ~ $2.00 $0.00 o Port of Seattle o State of Washington . King County o Auburn School District 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 (2) 139 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN, WASHINGTON SCHEDULE 8 PROPERTY TAX LEVIES AND COLLECTIONS LAST TEN FISCAL YEARS Total Tax Collected Within the Collections Fiscal Levy for Fiscal Year of the Levy in Subsequent Total Collections to Date Current Year Year Fiscal Year Amount % of Levy Years Amount % of Levy Levy Balance King County: 1998 9,320,307 9,159,702 98.3% 160.605 9.320,307 100.000% 1999 9,653,175 9,312,513 96.5% 340.397 9,652,910 99.997% 265 2000 10.105,414 10.022,441 99.2% 82,434 10.104.875 99.995% 539 2001 11,145,593 10,814,089 97.0% 319.186 11,133,275 99.889% 12,318 2002 11,519,341 11.261.600 97.8% 251.647 11,513,247 99.947% 6.094 2003 12.082,940 11,765,654 97.4% 309,355 12,075,009 99.934% 7,931 2004 12,212,739 12,031,253 98.5% 170.654 12.201,907 99.911% 10,832 2005 12,640,895 12,393.241 98.0% 221.956 12,615,197 99.797% 25,698 2006 13,402.738 13.164.248 98.2% 160.961 13.325.209 99.422% 77 .529 2007 13,855,330 13,605,301 98.2% 13,605,301 98.195% 250.029 $ 391 .235 Pierce County: 1998 1999 2000 60,601 59,086 97.5% 1.515 60,601 100.000% 2001 114,323 105.707 92.5% 8,616 114,323 100.000% 2002 267,001 258,385 96.8% 8,616 267.001 100.000% 2003 435,886 423,834 97.2% 12,052 435,886 100.000% 2004 579,828 566,356 97.7% 13,472 579,828 100.000% 2005 783.135 769.223 98.2% 13.912 783.135 100.000% 2006 1,242,039 1,220,642 98.3% 18.805 1.239,447 99.791% 2,592 2007 1 ,852.229 1.816.707 98.1% 1,816,707 98.082% 35.522 $ 38.114 Total current levy balance $ 429,349 Source: King County and Pierce County Departments of Assessments FIGURE 8: TEN YEARS COLLECTION OF LEVIED PROPERTY TAXES Last Ten Fiscal Years 100.0% 99.0% 98.0% 97.0% 96.0% 95.0% 94.0% 1998 1999 2000 2001 ~ Collection percentage within the fiscal year of the levy __ Total collection percentage 2002 2003 2004 2005 2006 2007 140 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN. WASHINGTON SCHEDULE 9a PRINCIPAL TAXPAYERS-PROPERTY TAXES CURRENT YEAR AND NINE YEARS AGO 2007 Taxpayer Percentage of Total City Assessed Taxable Value Rank Assessed Value 457,846,367 1 7.94% 124,696,902 2 2.16% 121,011,972 3 2.10% 74,665,100 4 1.30% 58,958,636 5 1.02% 57,234,500 6 0.99% 53,946,000 7 0.94% 47,220,355 8 0.82% 24,144,890 9 0.42% 19,217,762 10 0.33% 1,038,942.484 18.02% Boeing Company Glimcher Supermall Venture * Safewa y EPropertyTax Inc. puget Sound Energy" M uckleshoot India n Tribe Invesco Realty Advisors *** Universal Health u** Owest Corporation ***** Roundup Co. ( Fred Meyer) La Terra Limited Partnership Hapsmith-Rosche Washington .TOTALS 1998 Assessed Value Rank Percentage of Total City Taxable Assessed Value 22.58% 4.50% 1.48% 0.59% 0.74% 0.66% 0.39% 1.50% 0.87% 33.31% Source: King County Department of Assessments * Assessed value was appealed and lowered in 2004 ** puget Sound Energy was shown as two separate Taxpayers in 1998 -- PSE/Elec and PSE/Gas *** Formerly Complex Prop Advisors Corp **** Formerly Shanna Lehman ***** Formerly US West Communications 716,860,698 142,830,950 47,015,018 18,577,261 23,495,935 20,948,642 12,381,006 47,558,800 27,716,200 1,057,384,510 FIGURE 9a-1: TOP TAXPA YER ASSESSED VALUE AS A PERCENTAGE OF TOTAL ASSESSED VALUE Current Year and Nine Years Ago FIGURE 9a-2: TOP 10 TAXPAYERS ASSESSED VALUE AS A PERCENTAGE OF TOTAL ASSESSED VALUE Current Year and Nine Years Ago -[J 30% 20% 10% 0% '"TJJ 30% 20% 10% 0% 1998 1998 2007 CITY OF AUBURN, WASHINGTON SCHEDULE 9b PRINCIPAL TAXPAYERS-SALES TAXES CURRENT YEAR AND NINE YEARS AGO 2007 1998 Sales Tax Received Percentage of Total City Sales Taxes Received Rank Percentage of Total City Sales Taxes Received Sales Tax Received Sector (1) Sector(1) Distribution Automotive General retail General retail Automotive General retail Automotive General retail General retail Automotive Rank 541,347 427,621 384,815 367,913 353,429 337,904 263,683 251,244 247,669 243,894 1$3.419,519 1 2 3 4 5 6 7 8 9 10 3.1% 2.4% 2.2% 2.1% 2.0% 1.9% 1.5% 1.4% 1.4% 1.4% 19.4% NOT AVAILABLE Source: Washington State Department of Revenue (1) It is illegal to disclose specific taxpayer sales tax information, so the above information is being provided without identification 141 ~ 2007 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION 142 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN. WASHINGTON SCHEDULE 11 RATIO OF OUTSTANDING DEBT BY TYPE LAST TEN FISCAL YEARS Govrnmental Activities Business-type Activities General Special Public Works Total Percentage Fiscal Obli9ation Assessment Capital Revenue Trust Fund Primary of Personal Per Year Bonds Bonds Leases Bonds Loa ns Government Income (1) Capita 1998 4,000,000 811,077 4,880,000 9,691,077 1.58% 258.84 1999 5,545,000 541,077 12,825,000 18,911,077 2.94% 485.15 2000 7,956,600 1,013,904 11,990,000 20,960,504 3.05% 498.53 2001 7,700,000 738,904 11,110,000 7,367,157 26,916,061 3.85% 611.94 2002 7,402,000 548,904 1,367,108 10,190,000 7,826,039 27,334,051 3.84% 611.71 2003 7,088,000 347,904 689,643 9,230,000 7,428,695 24,784,242 3.27% 546.45 2004 6,754,000 228,354 10,322,787 8,220,000 7,066,042 32,591,183 4.16% 706.43 2005 6,478,000 132,354 7,020,000 8,679,509 22,309,863 2.68% 469.98 2006 11,210,000 36,827 5,905,000 9,853,410 27,005,237 3.04% 551.63 2007 10,650,000 36,827 663,553 4,730,000 10,149,419 26,229,799 2.77% 519.71 Source: City of Auburn, Finance Department (1) Personal income data provided by Hebert Research for 2000,2004 and 2005 only; other years are city estimates FIGURE 11: PER CAPITA DEBT Last Ten Fiscal Years $1,000 $750 $500 $250 $0 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 143 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN, WASHINGTON SCHEDULE 12 COMPUTATION OF LEGAL DEBT MARGIN AS OF DECEMBER 31,2007 General Capacity Special Purpose Capacity Parks and Utility Total Councilmanic Excess Levy Open Spaces Purpose Capacity December 31,2007 - Total Assessed Value: $6,526,294,998 2.5% of assessed value $ $ 163,157,375 $ 163,157,375 $ 163,157,375 $ 489,472,125 1.5% of assessed value 97,894,425 (97,894,425) Statutory debt limit 97.894,425 65.262.950 163,157.375 163,157.375 489,472.125 Debt outstanding 10,756,734 10,756,734 Less redemption fund assets: Available to pay principal 3,040,560 3,040,560 Plus liabilities: Payables 1.737,368 1.737,368 Vacation/sick leave 1 .267.382 1 .267.382 Net debt outstanding 10.720.924 10.720.924 Remaining debt capacity $ 87.173.501 $ 65.262.950 $ 163.157,375 $ 163.157.375 $ 478.751.200 CITY OF AUBURN, WASHINGTON SCHEDULE 13 LEGAL DEBT MARGIN RATIOS LAST TEN FISCAL YEARS (EXPRESSED IN THOUSANDS) 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 Debt Limit 238,059 238,068 252,476 252,476 294,669 336,913 350,782 350,782 432,377 489,472 Total net debt applicable to limit (2,033) 468 4,866 (4,871) (1,610) 3,576 17,055 17,055 11,352 10,757 [Legal aeot margin 240,092 237,600 247,610 257,347 296,279 333,337 333,727 333,727 421,025 478,7151 Total net debt applicable to the limit as a percentage of debt limit -0.85% 0.20% 1.93% -1.93% -0.55% 1.06% 4.86% 4.86% 2.63% 2.20% 144 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN, WASHINGTON SCHEDULE 14 COMPUTATION OF NET DIRECT AND ESTIMATED OVERLAPPING DEBT AS OF DECEMBER 31,2007 Net Debt Percent Bonded Amount Outstanding Applicable (3) Applicable Net di rect debt: Net direct debt - City of Auburn $ 10.650.000 Estimated net overlapping debt: (2) King County 1.099.915.324 1.68% 18.478.577 Port of Seattle 397,835,000 1.68% 6.683.628 School District No. 210 150,765,000 0.09% 135,689 School District No. 408 119.190.000 63.56% 75,757,164 School District No. 415 260.697.471 1.48% 3.858.323 Rural Library District 73,607,300 2.75% 2,024.201 Pierce County 127,077,169 0.67% 851,417 Total estimated net overlapping debt 107,788,998 Total direct and overlap.P.l!!g debt $ 118.438,998 I Sources: (1) City of Auburn finance department; includes both bonded and non bonded general long-term debt (2) Overlapping governments (3) King County Assessors office, except for Pierce Co. 145 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN, WASHINGTON SCHEDULE 15 RATIOS OF NET GENERAL BONDED DEBT TO ASSESSED VALUE AND GROSS BONDED DEBT PER CAPITA LAST TEN FISCAL YEARS Ratio of Net Debt Net Bonded Gross Assessed Gross Service Bonded Debt to Bonded Fiscal Value (1) Bonded Amount (3) Debt Assessed Debt per Year Population (Thousands) Debt (2) Available (Thousands) Value Capita 1998 37,440 3,004,400 4,000,000 10,330 3,990 0.13% 107 1999 38,980 3.201,769 3,890,000 47,274 3,843 0.12% 100 2000 42,045 3,392,920 7,956,600 1,807,092 6,150 0.18% 189 2001 43,985 3,752,065 7,700,000 1 ,923,800 5,776 0.15% 175 2002 44,685 3.928,917 8,769,108 1 ,843,957 6,925 0.18% 196 2003 45,546 4,492,179 7,088,000 66,779 7,021 0.16% 156 2004 46.135 4.677,093 6,754,000 159.042 6,595 0.14% 146 2005 47,470 5.099,469 6,478,000 218,498 6,260 0.12% 136 2006 48,955 5,765,028 11,210,000 144,449 11,066 0.19% 229 2007 50,470 6,526,295 10,650,000 181,666 10,468 0.16% 211 Notes: (1) From Figure 6 (2) Amount does not include special assessment and revenue bond debt. (3) Fund balances from debt service funds. FIGURE 15: BONDED DEBT RATIOS Last Ten Fiscal Years 0.0100 0.0080 ""C Q) '" 0.0060 '" Q) Q) '" " ~c;; ;:,> 0.0040 ..c Q) 0 0.0020 $250 $200 $150 $100 $50 $0 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 Year _Debt/AV ---.- Debt/Pop 146 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN, WASHINGTON SCHEDULE 16 PLEDGED REVENUE BOND COVERAGES LAST TEN FISCAL YEARS Direct(2) Debt SelVice Requirements Gross (1) Operating Net Revenue Times Year Revenue Expense Available Principal Interest Total Coverage 1998 15,850,761 11.352,277 4.498.484 460.000 286,435 746,435 6.03 1999 15,760.351 11.848,912 3.911.439 835,000 650.945 1 .485.945 2.63 2000 17.749.951 11.961.126 5.788.825 880.000 614.245 1.494.245 3.87 2001 18,638,847 12.866,310 5.772,537 1.102.368 579,260 1,681,628 3.43 2002 19,928,128 13,917,916 6,010,212 1,142,368 707,581 1,849,949 3.25 2003 21.243.060 15.611.753 5.631,307 1.407.343 603.357 2.010.700 2.80 2004 21,958,359 16,834.837 5,123.522 1,633,533 539,754 2,173,287 2.36 2005 24.562.487 18,078,747 6,483,740 1.800.568 417,834 2,218,402 2.92 2006 27.087.351 19.615,315 7.472,036 1.718.412 333.016 2.051.428 3.64 2007 27.492.779 21.237,294 6.255.485 1,914,523 281,065 2,195,588 2.85 Source: City of Auburn, Finance Department (1) Includes water. sewer & storm drainage operating. interest and other revenues. (2) Includes water, sewer & storm drainage operating expenses less depreciation. FIGURE 16: UTILITY BOND COVERAGES Last Ten Fiscal Years $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2.000,000 $1,000,000 $0 1998 1999 2000 2001 2002 2003 YEAR 2004 2005 2006 2007 --+- Net revenue available _ Debt service requirements 147 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITYOF AUBURN, WASHINGTON SCHEDULE 17 POPULATION, INCOME AND HOUSING TRENDS LAST TEN FISCAL YEARS Item 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 I School enrollment (1) 12,741 13,063 13,079 13,222 13,504 13,461 13,838 13,760 14,367 14,559 Rate of unemployment (2) 2.9% 3.7% 3.4% 4.8% 5.9% 6.6% 4.7% 4.9% 4.6% 3.6% Population (3) 37,440 38,980 42,045 43,985 44,685 45,355 46,135 47,470 48,955 50,470 Personal income (thousands of dollars) (4) $612,462 $642,219 $687,178 $699,540 $711,677 $758,326 $782,702 $832,921 $889,041 $948,633 Per capita personal income (4) $16,358 $16,476 $16,344 $15,904 $15,927 $16,720 $16,965 $17,546 $18,160 $18,796 Housing units (5) One unit 6,970 7,377 8,125 8,247 8,671 8,745 8,990 9,105 9,402 9,625 T VvO or more 6,715 7,217 7,520 7,667 7,452 7,790 8,078 8,655 8,943 9,623 Mobile home or special 2,208 2,204 2,212 2,302 2,144 2,474 2,421 2,346 2,407 2,382 Total housing units 15,893 16,798 17,857 18,216 18,267 19,009 19,489 20,106 20,752 21,630 Sources: (1) Auburn School District No. 408 (2) WA State Employment Security Department - average King County rate (3) WA State Office of Fiscal Management (4) Hebert Research; data available for the years 2000 and 2004 only, other years are city estimates (5) City of Auburn Planning department FIGURE 17: POPULATION AND HOUSING TRENDS Last Ten Fiscal Years 60,000 50.000 . 40,000 30,000 20,000 ~ ~ 10,000 0 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 1---.- Population --+- Total housing units I 148 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN, WASHINGTON SCHEDULE 18 MAJOR EMPLOYERS CURRENT YEAR AND NINE YEARS AGO Employer 2007 1998 Employees Rank 9,689 1 900 3 1,453 2 650 4 575 6 536 7 600 5 385 9 500 8 325 10 15,613 Employees Product/service Rank Percentage of Total City Employment (1) Aerospace Gaming Education Education Hospital GOy't I public offices Construction Horse racing Technology reseller City government GOy't I public Offices Federal government FIGURE 18A: AUBURN EMPLOYMENT BASE PERCENTAGE OF TOP EMPLOYER COMPARED TO ALL EMPLOYERS Last Ten Fiscal Years 4,200 2,100 1,995 850 625 600 575 500 500 455 Source: WA Employment Security Department (1) Percentage of total city employment based on 2002 total employment numbers 12,400 Percentage of Total City Employment 34.0% 3.2% 5.1% 2.3% 2.0% 1.9% 1.4% 1.8% 1.1% 52.71% WO% [lj 80% 60% 40% 20% 0% 1998 rn I.""m"~' IOAII employers 2007 149 1 2 3 4 5 6 7 8 9 10 11.7% 5.8% 5.5% 2.4% 1.7% 1.7% 1.6% 1.4% 1.4% 1.3% The Boein9 Company Muckleshoot Tribal Enterprises Auburn School District Green River Community College Auburn Regional Medical Center Social Security Administration Certainteed Corporation Emerald Downs Racetrack Zones, Inc. City of Auburn Federal Aviation Administration General Services Administration ITOT ALS 34.42% FIGURE 18B: AUBURN EMPLOYMENT BASE PERCENTAGE OF TOP 10 EMPLOYERS COMPARED TO ALL EMPLOYERS Last Ten Fiscal Years 100% 80% 60% 40% 20% 0% 1998 2007 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN, WASHINGTON SCHEDULE 19 STAFFING LEVELS BY DEPARTMENT LAST TEN FISCAL YEARS IDepartment 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007(1)1 Mayor 3 3 3 3 3 4 4 8 10 11 Human resources 6 6 6 6 7 7 7 7 15 17 Finance 20 25 25 26 27 28 28 21 23 24 Municipal court 7 9 10 11 12 12 13 14 15 17 Legal 11 11 13 13 13 13 13 13 13 14 Planning 12 12 12 12 13 31 31 32 25 29 Police 103 107 110 112 114 115 115 117 118 121 Fire 76 76 78 78 81 81 81 82 82 Public works 56 58 62 62 62 48 49 48 48 54 Parks & recreation 33 34 34 34 35 37 37 36 36 38 Street 13 13 13 13 13 13 13 11 11 15 Water 13 13 14 14 14 16 16 16 16 19 Sewer 6 6 7 7 7 7 6 8 8 11 Storm utility 7 7 7 7 7 7 7 9 9 12 Solid waste 6 6 6 6 6 2 2 2 2 2 Airport 5 4 3 3 3 3 3 Cemetery 7 7 7 7 7 7 7 6 6 7 Golf course 6 6 6 6 6 6 6 6 6 9 Equipment rental 9 8 8 8 8 10 10 10 9 9 Information services 10 11 15 ITOTAL 399 411 424 428 438 447 448 456 463 4241 Source: City of Auburn Finance Department (1) No data is presented for Fire employees for 2007 due to incorporation of the former Fire department into a separate legal entity effective 1/1/07. 140 120 <n 100 Q) Q) >- 0 "- 80 E w 0 ill 60 .0 E :J Z 40 20 FIGURE 19: STAFFING LEVELS BY TYPE OF SERVICE Last Ten Fiscal Years ~& <(:~0 0/ ~o~ .~0C:J &:,o~ i$-~~ & ~o ~C:Jo!:"e; ,. v" .,,'" <(,,1J.~ o'S' '*-~ .0 ~~C:J ...& ,,' ~v /? '<"~ 'f' ~& ~ 150 .1998 01999 02000 .2001 02002 02003 02004 .2005 iii 2006 02007 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN. WASHINGTON SCHEDULE 20 OPERATING INDICATORS BY DEPARTMENT LAST TEN FISCAL YEARS 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 Planning Commercial permits 414 432 471 431 434 337 217 240 248 214 Commercial construction value ($1 ,000's) $94,650 $93,971 $75,011 $74,924 $56,257 $50,269 $77,121 $71,047 $63,658 $63,658 Residential permits 610 361 583 422 421 583 766 604 485 293 Residential construction value ($1 ,000's) $69,420 $22,961 $65,077 $65,326 $55,108 $89,415 $155,551 $112,125 $61,872 $61,872 Police Crimes: Arson 36 28 31 35 46 45 43 33 36 30 Assault 133 125 139 143 169 145 135 168 158 143 Burglary 543 581 541 686 578 596 861 623 686 590 DUI 190 198 150 204 170 189 240 218 158 145 Homicide 2 2 3 2 1 1 1 Narcotics 340 426 628 606 499 506 399 472 493 368 Rape 27 19 28 19 33 32 24 13 24 12 Robbery 77 82 65 69 68 69 91 85 122 92 Theft 2,479 2,412 2,273 2,300 2,243 2,082 2,344 2,509 2,216 1,962 Theft - motor vehicle 739 672 594 692 875 816 802 869 642 672 Traffic: Non-criminal 9,388 7,599 7,690 9,072 9,643 9,946 7,962 6,850 4,978 6,865 Parking 1,296 1,555 1,802 1,803 2,188 1,821 1,827 2,140 3,965 4,802 Fire (5) Type of response: Building 77 81 92 103 101 114 107 94 98 Non-building 263 184 275 236 260 305 249 198 238 Alarm systems 417 515 496 562 511 486 497 474 524 Service 397 390 352 387 370 465 493 493 618 Other 689 537 673 747 819 917 940 870 979 First Aid 4,487 4,510 4,815 4,902 5,177 5,155 5,562 5,679 5,616 Parks and Recreation Athletic teams 484 512 455 464 467 523 507 445 459 479 Recreation activities 1,200 1,301 1,551 1,483 1,527 1,708 1,896 2,086 2,069 2,719 Golf course rounds (1) 56,936 55,672 56,527 53,864 53,967 41,753 45,336 47,501 43,454 50,500 Senior center visits (2) 27,573 29,778 31,949 29,572 32,121 31,418 32,103 35,308 35,381 34,427 Cultural activities 81 118 117 56 88 55 56 56 58 84 Museum audience served (3)(4) 8,000 9,000 11,000 11,000 8,994 9,417 10,274 9,340 9,400 12,090 Cemetery burials 302 291 300 301 277 272 271 277 277 245 Sources: Various city departments (1) 2003 - Portion of golf course closed for two months (2) 2001 - Senior center had reduced programs and 16 additional closure dates to facilitate move to new facility (3) 2002 - Museum actual service has increased; decline in count due to change in calculation method (4) 1998 & 2001 - Museum closed for renovations for several months (5) 2007 - Effective 1/1/2007 Valley Regional Fire Authority formed replacing the Fire Departments of Auburn, Pacific and Algona. 151 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION CITY OF AUBURN, WASHINGTON SCHEDULE 21 CAPITAL ASSET INDICATORS BY DEPARTMENT LAST TEN FISCAL YEARS 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 General City Total area (square miles) 20.5 21.0 21.0 22.6 22.7 22.8 22.8 23.3 23.4 23.4 Public Works Miles of streets 151 155 155 160 166 180 180 180 180 186 Number of streetlights 2,464 2,690 2,790 2,790 2,934 2,934 3,355 3,410 3,575 3,602 Number of traffic signals n/a n/a n/a n/a n/a n/a 66 72 72 72 Utilities Number of selVices 11,137 11,330 11,546 11,645 12,014 12,077 12,144 12,833 12,633 12,954 Miles of water mains 221 221 220 243 247 252 254 278 279 287 Miles of sanitary sewers 148 156 156 166 149 176 177 177 177 182 Miles of storm sewers n/a n/a n/a n/a n/a n/a 185 190 195 201 Number of fire hydrants n/a n/a n/a n/a n/a n/a 2,270 2,285 2,300 2,369 Public Safety Number of fire stations (1) 3 3 3 3 3 3 3 3 3 Number of police stations 2 2 2 3 3 2 2 2 2 2 Parks and Recreation Total park acreage 429 429 478 547 533 535 592 596 596 596 Number of softballlbaseball fields n/a n/a n/a n/a n/a n/a 19 19 19 19 Number of soccerlfootball fields n/a n/a n/a n/a n/a n/a 3 3 3 3 Number of playgrounds n/a n/a n/a n/a n/a n/a 25 29 30 30 Sources: Various city departments (1) Effective 1/1/2007 Valley Regional Fire Authority formed replacing the Fire Departments of Auburn, Pacific and Algona. 152 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION Prepared by: Shelley Coleman Finance Director Shawn Hunstock Assistant Finance Director Lanny Petitjean Senior Accountant T eri Ashton Accountant Timothy Henry Utility & Accounting Services Manager Karen Jester Financial Planning Manager Michelle Surdez Senior Accountant Consuelo Rogel Financial Analyst Kristen Hollis Finance Secretary 153 CITY OF AUBURN: 2007 CAFR STATISTICAL SECTION * * * * * MORE THAN YOU IMAGINED 154