Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Annual Financial Report for Fiscal Year 2012
Masterpiece on the Mississippi TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2012 State of Iowa Annual Financial Report DATE: November 7, 2012 Dubuque kital All- America City II 111! 2012 Finance Director Ken TeKippe recommends City Council approval of the City of Dubuque's Fiscal Year 2012 Annual Financial Report. I concur with the recommendation and respectfully request Mayor and City Council approval. /),2t Michael C. Van Milligen MCVM:jh Attachment cc: Barry Lindahl, City Attorney Cindy Steinhauser, Assistant City Manager Teri Goodmann, Assistant City Manager Ken TeKippe, Finance Director THE CITY OF Dui Masterpiece on the Mississippi TO: Michael C. Van Milligen, City Manager FROM: Ken TeKippe, Finance Director DATE: November 5, 2012 SUBJECT: Fiscal Year 2012 State of Iowa Annual Financial Report Dubuque had All-America City ' 11' 2007 DISCUSSION The City of Dubuque's Fiscal Year2012 Annual Financial Report [AFR) is attached. The AFR is prepared on a cash basis consistent with the annual budget. The City is required to publish the first page of this report before filing the report with the State Auditor's Office. The Dubuque Telegraph Herald will publish this report on Friday, November 23, 2012. There is no statutory requirement for the City Council to approve the AFR or pass a resolution priorto publication and filing. However, when possible, City Council review and approval of this official document is recommended. The report, with a Certification of Publication, must be filed with David A. Vaudt, Auditor of the State pursuant to the Code of Iowa Section 384.22 by December 1 , 2012. Should you have any questions on the attached report, please feel free to contact me. Thank you. cc: cc: Jenny Larson, Budget Director Enc(1) Form F -66 (IA -2) (5 -7 -2012) STATE OF IOWA 2012 FINANCIAL REPORT FISCAL YEAR ENDED JUNE 30, 2012 CITY OF DUBUQUE , IOWA 16203100700000 Finance Director 50 W 13th St. Dubuque, IA 52001 (Please correct any error in name, address, and ZIP Code) DUE: December 1, 2012 WHEN David A. Vaudt, CPA COMPLETED, Auditor of State PLEASE State Capitol Building RETURN TO Des Moines, IA 50319 -0004 _ NOTE - The information supplied in this report will be shared by the Iowa State Auditor's Office, the U.S. Census Bureau, various public interest groups, and State and federal agencies. ALL FUNDS Item description Governmental (a) Proprietary (b) Total actual (c) Budget (d) Revenues and Other Financing Sources Taxes levied on property 20,559,847 ' . ' . `. 20,559,847 20,559,847 Less: Uncollected property taxes -levy year 32,517 32,517 0 Net current property taxes 20,527,330. 20,527,330 20,559,847 Delinquent property taxes 94,233 ' •' •' • •' • •' 94,233 0 TIF revenues 9,590,342 9,590,342 10,151,097 Other city taxes 13,435,863 0 13,435,863 14,904,342 1,254,672 Licenses and permits 2,252,358 8,586 2,260,944 Use of money and property 12,290,489 158,814 12,449,303 12,834,532 Intergovernmental 37,466,108 10,676,276 48,142,384 86,786,356 Charges for fees and service 6,022,281 22,820,512 28,842,793 32,838,902 Special assessments 413,400 0 413,400 1,878,335 8,147 541 Miscellaneous 3,989,496 6,111,095 10,100,591 Other financing sources 39,058,913 60,162,372 99,221,285 107,743,437 Total revenues and other sources 145,140,813 99,937,655 245,078,468 297,099,061 Expenditures and Other Financing Uses Public safety 24,557,646 0 24,557,646 .. . 24,851,798 Public works 11,544,396 0 11,544,396 12,077,963 Health and social services 865,604 0 865,604 1,014,042 Culture and recreation 10,093,940 0 10,093,940 10,394,551 Community and economic development 12,786,052 0 12,786,052 12,904,361 General government 6,834,175 0 6,834,175 7,165,386 6,934,294 Debt service 6,080,944 0 6,080,944 Capital projects 42,463,206 0 42,463,206 100,173,594 Total governmental activities expenditures 115,225,963 0 115,225,963 175,515,989 Business type activities 0 78,191,996 78,191,996 120,130,864 Total ALL expenditures 115,225,963 78,191,996 193,417,959 295,646,853 Other financing uses, including transfers out 15,971,057 13,365,995 29,337,052 27,043,765 Total ALL expenditures /And other financing uses 131,197,020 91,557,991 222,755,011 322,690,618 Excess revenues and other sources over (Under) Expenditures /And other financing uses 13,943,793 8,379,664 22,323,457 - 25,591,557 Beginning fund balance July 1, 2011 34,006,976 13,914,820 47,921,796 39,718,581 Ending fund balance June 30, 2012 47,950,769 22,294,484 70,245,253 14,127,024 Note - These balances do not include $ 2,216791! held in non - budgeted' internal service funds; $ held in Pension Trust Funds; $ held in Private Purpose Trust funds and $ 11,570;481 held in agency funds which were not budgeted and are not available for city operations- Indebtedness at June 30, 2012 Amount - Omit cents Indebtedness at June 30, 2012 Amount - Omit cents General obligation debt $ 88,000,000 Other long -term debt $ 5,066,949 $ 0 Revenue debt $ 68,457,748 Short-term debt TIF Revenue debt $ 24,256,617 General obligation debt limit $ 177,485,091 . . . . ... :' CERTIFICATION THE FOREGOING REPORT IS CORRECT TO THE BEST OF MY KNOWLEDGE AND BELIEF Signature of city clerk ��%� Date Published /Posted 11 -23 -2012 Mark (x) one Date Published El ❑ Date Posted Printed name of city clerk Kevin S Firnstahl Telephone Area Code 563 Number 589.4121 Extension —► Signature of Mayor of other City official (Name and Title) Roy D. Buol, Mayor Date Sig dG� ///:;.Z 1 //� PLE E PUBLISH THIS PAGE ONLY Part 1 REVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2012 CITY OF DUBUQUE DGAAP Indicate by placing an X in the appropriate NON -GAAP = CASH BASIS box on this sheet ONLY X Line No. Item description General (a) Special revenue (b) TIF special revenue Debt service Capital projects Permanent Total governmental (Sum of cols. (a) through (f)) Proprietary ( 1 9 Code GRAND TOTAL (Sum of cols. (g) and (h)) Si). Line No. 1 SectionA -TAXES ............. . .. . ... . . . . . ..c.. .. . . ... . ... . ... . ... . ... . . .(a) . ... . . . . .. . ... . . . . ... . ... . ... . . . . . . . . . . • . • .' . •.•.'.•.•.'.•.•.'.• • . • • ; • ......•.•.•.•....... .".'.'.".'.'.".'.'. . • . ' . ' • . • ; • ; • . • .' . . • . • ; • . • . • . • . • . • ' . ' .' . ' . ' . • . • . • . • . • . ; • ; • ; • ; • ; • -. . .-. . .-. . .-. . .- 1 2 Taxes levied on property 16,618,053 3,823,318 118,476 20,559,847 20,559,847 2 3 Less: Uncollected property taxes - Levy year 32,517 32,517 32,517 3 4 Net current property taxes 16,585,536 3,823,318 0 118,476 0 0 20,527,330 T01 20,527,330 4 5 Delinquent property taxes 1,021 76,861 _ 16,351 94,233 T01 94,233 5 6 Total property tax 16,586,557 3,900,179 0 134,827 0 0 20,621,563. 20,621,563 6 7 TIF revenues • • • • • • • • • • . • .•.•.•.•. • . • • • • • • • • • • .•. ..... 9,590,342 • • • • . • • • . • • • • • • • .•.•. • • • • • • • • • • • • • • • • • • . . . 9,590,342 T01 9,590,342 7 . . . . ...... 686,8908 8 Othercity taxes Utility tax replacement excise taxes . . . . . . . . . . . . . .. ..... 639,831 43,512 3,547 686,890 T15 9 Utility franchise tax (Chapter 364.2, Code of Iowa) 1,561,217 606,977 2,168,194 T15 2,168,194 9 10 Parimutuelwagertax 27,282 27,282 C30 27,282 10 11 Gaming wager tax 597,605 597,605 C30 597,605 11 12 Mobile home tax 32,062 32,062 T19 32,062 12 13 Hotel /motel tax 1,889,648 1,889,648 T19 1,889,648 13 14 Other local option taxes 4,017,091 4,017,091 8,034,182 T09 8,034,182 14 15 TOTAL OTHER CITY TAXES 8,764,736 650,489 0 3,547 4,017,091 0 13,435,863 0 13,435,863 15 16 Section B - LICENSES AND PERMITS 2,252,358 0 0 2,252,358 8,586 T29 2,260,944 16 17 Section C - USE OF MONEY AND PROPERTY 17 18 Interest 428,978 36,224 233,895 97,977 4,569 801,643 158,814 U20 960,457 18 19 Rents and royalties 10,568,324 14,703 10,583,027 U40 10,583,027 19 20 Other miscellaneous use of money and property 64,371 420,898 405,167 15,383 905,819 U20 905,819 20 21 0 0 21 22 TOTAL USE OF MONEY AND PROPERTY 11,061,673 457,122 639,062 0 128,063 4,569 12,290,489 158,814 12,449,303 22 23 ..................................................................................................................... . . . . .' . . . . . . . . ....... ......................... ......... . . . . . . . . . . . . . . . . . . . . . . . . . . ............................... ............................... . . . . . . . . . . . . . . . . . . . . . . . . . . . ................. . . . . . . . . . . . . . . ................. ................. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................... . ...................... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 24 Section D - INTERGOVERNMENTAL . . . . . . . . . . . . . . . . . . 24 25 25 26 Federal grants and reimbursements 26 27 _ _ _ Federal grants 1,459,989 7,194,444 28,370 27,195 15,319,087 24,029,085 5,825,356 B89 29,854,441 27 28 Community development block grants 1,251,014 1,251,014 B50 1,251,014 28 29 Housing and urban development 262,813 4,365,939 4,628,752 B50 4,628,752 29 30 _ _ Public assistance grants 143,580 13,946 157,526 1,110,132 B79 1,267,658 30 31 Payment in lieu of taxes 0 B30 0 31 32 5469255.77 0 0 32 33 Total Federal grants and reimbursements 1,866,382 12,825,343 28,370 27,195 15,319,087 0 30,066,377 6,935,488 37,001,865 33 34 ...... ............................... ......... ............................... ................. ..................... 34 . 39 39 Continued on next page Continued on next page Page 2 FORM F- 66(IA -2) (4 -20 -2011) Part I REVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2012 -- Continued CITY OF DUBUQUE fGAAP NON -GAAP = CASH BASIS X Line No Item description General (a) Special revenue (b) TIF special revenue (c) Debt service (d) Capital projects (e) Permanent (f) Total governmental (Sum of cols. (a) through (f)) (g) Proprietary (h) Code GRAND TOTAL (Sum of cols. (g) and (h)) (1) Line No. 41 Section D - INTERGOVERNMENTAL - Continued ................................... .. . ..... ..... ..... ..... ..... .. ............................... ' • ' 1 .............. .................... 41 42 ......... i 42 43 State shared revenues 44 Road use taxes 5466933' I 5,466,9331' C46 r 5,466,933 44 45 ...... .. .. .. .......... .. ..... 45 47 47 48 Other state grants and reimbursements . ..... 49 State grants 663,395 32,027 695,422 3,210,338 C89 3,905,760 49 50 Iowa Department of Transportation 632,391 632,391 195,440 C89 827,831 50 51 Iowa Department of Natural Resources 0 C89 0 51 52 Iowa Department of Economic Development 0 C89 0 52 53 CEBA grants 0 C89 0 53 54 Vision Iowa 0 189,142 C89 189,142 54 55 Military Servcie Tax Credit 0 0 55 56 Replacement County 70,438 70,438 70,438 56 57 Transfer of Jurisdiciton Payments 2,323 2,323 2,323 57 58 0 0 58 59 0 0 59 60 Total state 733,833 5,469,256 0 0 664,418 0 6,867,507 3,594,920 10,462,427 60 61 ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .............................. . . . . . . . . . . . . . . . . . . . . ... ... ... . _ 61 62 Local grants and reimbursements 62 63 County contributions 392,349 392,349 145,868 538,217 63 64 Library service 12,153 12,153 D89 12,153 64 65 Township contributions 0 D89 1 0 65 66 Fire /EMT service 127,722 127,722 D89 127,722 66 67 0 D89 0 67 68 0 0 68 69 0 0 69 70 Total local grants and reimbursements 532,224 0 0 0 0 0 532,224 145,868 678,092 70 71 TOTAL INTERGOVERNMENTAL (Sum of lines 33, 60, and 70) 3,132,439 18,294,599 28,370_ 27,195 15,983,505 0 37,466,108 10,676,276 48,142,384 71 72 Section E - CHARGES FOR FEES AND SERVICE 72 73 Water 16,257 16,257 6,101,149 A91 6,117,406 73 74 Sewer 0 7,305,171 A80 7,305,171 74 75 Electric 0 A92 0 75 76 Gas 0 A93 0 76 77 Parking 0 2,077,910 A60 2,077,910 77 78 Airport 3,032,370 57,222 139,363 3,228,955 A01 3,228,955 78 79 Landfill /garbage 0 3,336,826 A81 3,336,826 79 80 Hospital 0 A36 0 80 Continued on next page Page 3 FORM F- 66(IA -2) (4 -20 -2011) Part I REVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2012 -- Continued CITY OF DUBUQUE DGAAP NON -GAAP = CASH BASIS X Line No. Item description General (a) Special revenue (b) TIF special revenue (c) Debt service (d) Capital projects (e) Permanent (f) Total governmental (Sum of cols. (a) through (f)) (g) Proprietary (h) Code GRAND TOTAL (Sum of cols. (g) and (h)) (1) Line No. 81 Section E - CHARGES FOR FEES AND SERVICE - Continued .......................... ... ............................... -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ..................... - - - - - - - - - - - - - - - - - - - - - - - - - - 81 82 Transit 0 244,013 A94 244,013 82 83 Cable TV 0 T15 0 83 84 Internet 0 A03 0 84 85 Telephone 0 A03 0 85 86 Housing authority 0 A50 0 86 87 Storm water 0_ 3,145,423 A80 3,145,423 87 88 Other: ......... ............................. .......................... ......................... ............................... 88 89 Nursing home 0 A89 0 89 90 Police service fees 15,742 15,742 A89 15,742 90 91 Prisoner care 0 A89 0 91 92 Fire service charges 0 A89 0 92 93 Ambulance charges 1,056,572 1,056,572 A89 1,056,572 93 94 Sidewalk street repair charges 23,538 9,967 33,505 A44 33,505 94 95 Housing and urban renewal charges 72,002 20,400 92,402 A50 92,402 95 96 River port and terminal fees 0 A87 0 96 97 Public scales 0 A89 0 97 98 Cemetery charges 0 A03 0 98 99 Library charges 38,860 38,860 A89 38,860 99 100 Park, recreation, and cultural charges 1,492,399 2,269 1,494,668 A61 1,494,668 100 101 Animal control charges 0 A89 0 101 102 Other charges - Specify 33,447 8,871 42,318 42,318 102 103 Salt Sales 3,002 3,002 610,020 613,022 103 104 TOTAL CHARGES FOR SERVICE 5,784,189 98,729 0 0 139,363 0 6,022,281_ 22,820,512 28,842,793 104 105 ....................................... ............................... ................. ................... ........105 106 Section F - SPECIAL ASSESSMENTS 413,4001 413,4001 U011 413,400 106 107 Section G - MISCELLANEOUS 107 108 Contributions 507,195 1,028,126 21,662 1,556,983 167,872 U99 1,724,855 108 109 Deposits and sales /fuel tax refunds 245,436 64,443 309,879_ 32,689 U99 342,568 109 110 Sale of property and merchandise 0 U11 0 110 111 Fines 599,329 675 600,004 409,472 U30 1,009,476 111 112 Internal service charges 446,827 446,827_ 4,015,659 NR 4,462,486 112 113 Other miscellaneous - Specify 65,051 44,074 20 109,145 47,733 156,878 113 114 Insurance Claims 9,849 5,643 132,425 147,917 585,231 733,148 114 115 Damage Claims 424,131 2,099 426,230_ 6,592 432,822 115 116 Reimbursements 303,283 77,112 5,511 6,605 392,511 218,005 610,516 116 117 Sales Tax Collection 0 627,842 627,842 117 118 0 0 118 119 0 0 119 120 TOTAL MISCELLANEOUS 2,601,101 1,222,172 5,511 0 160,712 0 3,989,496 6,111,095 10,100,591 120 Continued on next page Page 4 FORM F- 66(IA -2) (4 -20 -2011) Part I REVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2012 -- Continued CITY OF DUBUQUE fGAAP NON -GAAP = CASH BASIS X Line No Item description General (a) Special revenue (b) TIF special revenue (c) Debt service (d) Capital projects (e) Permanent (f) Total governmental (Sum of cols. (a) through (f)) (g) Proprietary (h) Code GRAND TOTAL (Sum of cols. (g) and (h)) (1) Line No. 121 TOTAL ALL REVENUES (Sum of lines 6, 7, 15,16,22 71, 104, 106, and 120) 50,183,053 25,036,690 10,263,285 165,569 20,428,734 4,569 106,081,900 39,775,283 145,857,183 121 122 122 123 Section H - OTHER FINANCING SOURCES 123 124 Proceeds of capital asset sales 297,253 71,871 1,453,761 1,822,885 63,329 NR 1,886,214 124 125 Proceeds of long -term debt (Excluding TIF internal borrowing) 4,959,648 19,653 16,347,212 21,326,513 46,671,506 NR 67,998,019 125 126 Proceeds of anticipatory warrants or other short-term debt 0 A89 0 126 127 Regular transfers in and interfund loans 9,265,886 587,201 . . . . . . . . 729,116 2,069,637 0 12,651,840 12,942,150 25,593,990 127 128 internal TIF loans and transfers in 681,566 361,280 1,238,739 385,930 590,160 3,257,675 485,387 3,743,062 128 129 0 0 129 130 0 0 130 131 TOTAL OTHER FINANCING SOURCES 15,204,353 1,020,352 1,258,392 1,115,046 20,460,770 0 39,058,913 60,162,372 99,221,285 131 132 TOTAL REVENUES except for beginning balances (Sum of lines 121 and 131) 65,387,406 26,057,042_ 11,521,677 1,280,615 40,889,504_ 4,569 145,140,813 99,937,655 I 245,078,468 132 133 .............................. ............................... ......................... ...... ..................... 133 134 Beginning fund balance July 1, 2011 13,570,046 3,090,3961 3,014,599 112,131 14,163,040 56,764 34,006,976( 13,914,820( J 47,921,796 134 135 ..... . ... . ... . ... . ... . ... . ... . ... . ... . ... . ... . ... ....... ... . ... . ... . ..... .' .-.-. .-. . .- . .-. . .-.-. .-. . .-.-. .-. -.-. .-. . .-.-. . . .-.-. .-. . .-.-. .-. . .-.-. .-. . .-. . .-. . .-. . . 135 136 TOTAL REVENUES AND OTHER FINANCING SOURCES (Sum of lines 132 and 134) 78,957,452 29,147,4381 14,536,276 1,392,746 55,052,5441 61,333 179,147,789 113,852,475 293,000,264 136 137 ......................................................... ............................... ............................. 137 138 ........................................................................................ ............................................ ............................... ............................... 138 139 ........................................................................................ ............................... 139 140 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 140 141 ........................................................................................ ............................... 141 142 . 142 143 143 144 144 145 ....................................................................................... .. ... ... ... ... ... ... ... .. ... ... 145 146 ....................................................................................... ........................................................................................ ............................... 146 147 147 148 ....................................................................................... .. ... ... ... ... ... ... ... .. ... ... 148 149 149 150 . 150 151 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 151 152 152 153 ....................................................................................... .. ... ... ... ... ... ... ... .. ... ... 153 154 154 155 . 155 156 ....................................................................................... ............................... 156 157 ........................................................................................ ............................... 157 158 ........................................................................................ ....................................................................................... ............................... ............................... 158 159 ....................................................................................... ............................... 159 Continued on next page Page 5 FORM F- 66(IA -2) (4 -20 -2011) Part II EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2012 CITY OF DUBUQUE DGAAP NON -GAAP = CASH BASIS X Line No. Item description General (a) Special revenue (b) TIF special revenue (c) Debt service (d). Capital projects (e) Permanent (f) Total governmental (Sum of cols. (a) through (f)) (9). Proprietary (h). Code GRAND TOTAL (Sum of cols. (g) and (h)) Q) Line No. 1 Section A— PUBLIC SAFETY . . . . . . . . . . • • .. .. .. .. .. .. .. .. .. ....... ......... .. .. .. . .. .. .. .. . . •. ... .. .. .-. . . .-. .-. -. . .-. . .-. ......... . ........... ... . ... .-. . .-. .-. ...-.-.-.-.-.-. 1 2 Police department/Crime prevention — Current operation 12,195,735 43,169 12,238,904 E62 12,238,904 2 3 Purchase of land and equipment 314,844 314,844 G62 314,844 3 4 Construction 0 F62 0 4 5 Jail — Current operation 0 E04 _ 0 5 6 Purchase of land and equipment 0 G04 0 6 7 Construction 0 F04 0 7 8 Emergency management— Current operation 1,237,819 1,237,819 E89 1,237,819 8 9 Purchase of land and equipment 0 G89 0 9 10 Flood control — Current operation 171,026 171,026 E59 171,026 10 11 Purchase of land and equipment _ 0 G59 0 11 12 Construction 0 F59 0 12 13 Fire department— Current operation 7,838,819 39,603 7,878,422 E24 7,878,422 13 14 Purchase of land and equipment 101,721 101,721 G24 101,721 14 15 Construction 0 F24 0 15 16 Ambulance — Current operation 1,538,067 1,538,067 E32 1,538,067 16 17 Purchase of land and equipment 1,180 1,180 G32 1,180 17 18 Building inspections — Current operation 812,918 812,918 E66 812,918 18 19 Purchase of land and equipment 0 G66 0 19 20 Construction 0 F66 0 20 21 Miscellaneous protective services — Current operation 0 E66 0 21 22 Purchase of land and equipment 0 G66 0 22 23 Construction 0 F66 _ 0 23 24 Animal control — Current operation 262,745 262,745 E32 262,745 24 25 Purchase of land and equipment 0 G32 0 25 26 Construction 0 F32 0 26 27 Other public safety — Current operation 0 E89 0 27 28 Purchase of land and equipment 0 G89 0 28 29 0 0 29 30 0 0 30 31 0 0 31 32 0 0 32 33 0 0 33 34 0 0 34 35 0 0 35 36 0 0 36 37 0 0 37 38 0 0 38 39 0 0 39 40 TOTAL PUBLIC SAFETY 24,474,874 82,772 0 0 0 0 24,557,646 0 24,557,646 40 Continued on next page Page 6 FORM F- 66(IA -2) (4 -20 -2011) Part II EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2012 - Continued CITY OF DUBUQUE DGAAP NON -GAAP = CASH BASIS X Line No Item description General (a) Special revenue (b) TIF special revenue (c) Debt service (d) Capital projects (e) Permanent (f) Total governmental (Sum of cols. (a) through (f)) (g) Proprietary (h) Code GRAND TOTAL (Sum of cols. (g) and (h)) (1) Line No. 41 Section B — PUBLIC WORKS 41 42 Roads, bridges, sidewalks — Current operation 1,142,316 2,736,169 3,878,485 E44 3,878,485 42 43 Purchase of land and equipment 38,817 81,876 120,693 G44 120,693 43 44 Construction 0 F44 0 44 45 Parking meter and off- street— Current operation 0 E60 0 45 46 Purchase of land and equipment 0 G60 0 46 47 Construction 0 F60 0 47 48 Street lighting — Current operation 685,784 685,784 E44 685,784 48 49 Traffic control safety — Current operation 92,663 92,663 E44 92,663 49 50 Purchase of land and equipment 0 G44 0 50 51 Construction 0 F44 0 51 52 Snow removal — Current operation 1,343,044 1,343,044 E44 1,343,044 52 53 Purchase of land and equipment 35,732 35,732 G44 35,732 53 54 Highway engineering — Current operation 0 E44 0 54 55 Purchase of land and equipment 0 G44 0 55 56 Construction 0 F44 0 56 57 Street cleaning — Current operation 735,382 735,382 E81 735,382 57 58 Purchase of and and equipment 5,470 5,470 G81 5,470 58 59 Airport (if not an enterprise) — Current operation 4,209,239 4,209,239 E01 4,209,239 59 60 Purchase of land and equipment 60,179 60,179 G01 60,179 60 61 Construction 0 F01 0 61 62 Garbage (if not an enterprise) — Current operation 0 E81 0 62 63 Purchase of land and equipment 0 G81 0 63 64 Construction 0 F81 0 64 65 Other public works — Current operation 270,712 106,413 377,125 E89 377,125 65 66 Purchase of land and equipment 600 600 G89 600 66 67 Construction 0 F89 0 67 68 68 69 69 70 70 71 71 72 72 73 73 74 74 75 75 76 76 77 77 78 78 79 79 80 TOTAL PUBLIC WORKS 6,500,310 5,044,086 0 0 0 0 11,544,396 0 11,544,396 80 Continued on next page Page 7 FORM F- 66(IA -2) (4 -20 -2011) Part II EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2012 - Continued CITY OF DUBUQUE DGAAP NON -GAAP = CASH BASIS X Line No Item description General (a) Special revenue (b) TIF special revenue (c) Debt service (d) Capital projects (e) Permanent (f) Total governmental (Sum of cols. (a) through (f)) (g) Proprietary (h) Code GRAND TOTAL (Sum of cols. (g) and (h)) (i) Line No. 81 Section C — HEALTH AND SOCIAL SERVICES 81 82 Welfare assistance — Current operation 0 E79 0 82 83 Purchase of land and equipment 0 G79 01 83 84 City hospital — Current operation 0 E36 0 84 85 Purchase of land and equipment 0 G36 0 85 86 Construction 0 F36 0 86 87 Payments to private hospitals — Current operation 0 E36 0 87 88 Health regulation and inspections — Current operation 340,287 29,873 370,160 E32 370,160 88 89 Purchase of land and equipment 0 G32 0 89 90 Construction 0 F32 0 90 91 Water, air, and mosquito control — Current operation 0 E32 0 91 92 Purchase of land and equipment 0 G32 0 92 93 Construction 0 F32 0 93 94 Community mental health — Current operation 0 E32 0 94 95 Purchase of land and equipment 0 G32 0 95 96 Construction 0 F32 0 96 97 Other health and social services — Current operation 461,426 34,018 495,444 E79 495,444 97 98 Purchase of land and equipment 0 G79 0 98 99 Construction 0 F79 0 99 100 0 0 100 101 0 0 101 102 0 0 102 103 TOTAL HEALTH AND SOCIAL SERVICES 801,713 63,891 0 0 0 0 865,604 0 865,604 103 104 ........... ............................... ................. ................ ........ ............................... 104 105 . . . 105 106 ........... ............................... ................. ................ ......... ............................... 106 107 •. 107 108 ...... .......... 108 .................... ............................... .................................. ............................... 109 109 110 .. 110 111 .................... ............................... .................................. ............................... 111 112 112 113 113 114 •. 114 115 ..................... ............................... .................................. ............................... 115 116 :. 116 117 .. 117 118 .. .................... ............................... .................................. ............................... 118 119 .......... ............................... ................. ................ ......... ............................... 119 120 .......................... ........... .......... ............................. ..................... ............................... .................................. ............................... 120 Continued on next page Page 8 FORM F- 66(IA -2) (4 -20 -2011) Part II EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30 ,2012 - Continued CITY OF DUBUQUE DGAAP NON -GAAP = CASH BASIS X Line No. Item description General (a) Special revenue (b) TIF special revenue (c) Debt service (d) Capital projects (e) Permanent (f) Total governmental (Sum of cols. (a) through (f)) (g) Proprietary (h) Code GRAND TOTAL (Sum of cols. (g) and (h)) (i) Line No. 121 Section D — CULTURE AND RECREATION 121 122 Library services — Current operation 2,838,065 67,512 2,905,577 E52 2,905,577 122 123 Purchase of land and equipment 11,989 11,989 G52 11,989 123 124 Construction 0 F52 0 124 125 Museum, band, theater — Current operation 0 E61 0 125 126 Purchase of land and equipment 0 G61 0 126 127 Parks — Current operation 2,630,265 1,070 2,631,335 E61 2,631,335 127 128 Purchase of land and equipment 142,588 432 143,020 G61 143,020 128 129 Construction 0 F61 0 129 130 Recreation — Current operation 2,801,458 139,872 2,941,330 E61 2,941,330 130 131 Purchase of land and equipment 34,680 34,680 G61 34,680 131 132 Construction 0 F61 0 132 133 Cemetery — Current operation 0 E03 0 133 134 Purchase of land and equipment 0 G03 0 134 135 Community center, zoo, marina, and auditorium 1,148,891 1,148,891 E61 1,148,891 135 136 Other culture and recreation 277,118 277,118 E61 277,118 136 137 Purchase of land and equipment 0 G61 0 137 138 Construction 0 F61 0 138 139 TOTAL CULTURE AND RECREATION 9,885,054 207,384 432 0 0 1,070 10,093,940 0 10,093,940 139 140 Section E — COMMUNITY AND ECONOMIC DEVELOPMENT 140 141 Community beautification — Current operation 111,568 111,568_ E89 111,568 141 142 Purchase of land and equipment 0 G89 0 142 143 Economic development — Current operation 1,520,357 450,957 20,286 1,991,600_ E89 1,991,600 143 144 Purchase of land and equipment 0 G89 0 144 145 Housing and urban renewal — Current operation 484,408 5,744,272 6,228,680_ E50 6,228,680 145 146 Purchase of land and equipment 23,441 23,441_ G50 23,441 146 147 Construction 0 F50 0 147 148 Planning and zoning — Current operation 709,157 27,462 736,6191 E29 736,619 148 149 Purchase of land and equipment 1,753 1,753_ G29 1,753 149 150 Other community and economic development — Current operation 3,692,391 3,692,391_ E89 3,692,391 150 151 Purchase of land and equipment 0 G89 0 151 152 Construction 0 F89 0 152 153 TIF Rebates 0 E89 0 153 154 TOTAL COMMUNITY AND ECONOMIC DEVELOPMENT 2,715,675 6,357,700 3,712,677 0 0 0 12,786,052_ 0 12,786,052 154 155 ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' • • � • • � • . • TIF Rebates a e expended out of he TIF Special • � • • � • • Revenue Fund within the Community and Economic : : : • • • • : . • . Development program's activity "Other" • .'.'.'.'.'.'.'.'.'.'.'.'.'.'.'.'.'.'.'.'.'.'.'.'. • • • : : • • • • : : • • : ' • • • • : ' • '.'.'.'.'.'.'.'.'.'.'.'.'.'.'. • ' ' • • • • ' ' ' • • • 155 156 156 157 157 158 158 Continued on next page Page 9 FORM F- 66(IA -2) (4 -20 -2011) Part II EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2012 — Continued CITY OF DUBUQUE DGAAP NON -GAAP = CASH BASIS X Line No Item description General (a) Special revenue (b) TIF special revenue (c) Debt service (d) Capital projects (e) Permanent (f) Total governmental (Sum of cols. (a) through (f)) (g) Proprietary (h) Code GRAND TOTAL (Sum of cols. (g) and (h)) (i) Line No. 159 Section F — GENERAL GOVERNMENT 159 160 Mayor, council and city manager — Current operation 2,005,965 450,948 2,456,913. 25,710•' • . • . • . • . • . • . • . • . • . •' •' •' •' •' •' •' •' • • . • . • . • . • . • . • . • . • . • E29 2,456,913 160 161 Purchase of land and equipment 10,386 15,324 G29 25,710 161 162 Clerk, Treasurer, financial administration — Current operation 1,963,235 1,963,235 E23 1,963,235 162 163 Purchase of land and equipment 671 671. • • • • • • • • • • G23 671 163 164 Elections — Current operation _ 0 E89 0 164 165 Purchase of land and equipment 0'.'.'.'.'.'.'.'.'.' G89 0 165 166 Legal services and city attorney — Current operation 770,563 770,563. • . • . • . • . • . • . • . • . • . •' •' •' •' •' •' •' •' •' • • . • . • . • . • . • . • . • . • . • . • . • . • . • . • . • . •. •. •. •' •' •' •' •' •' •' •' •' • .'.'. .'.'.'.'.'. •. •. •: •. •. •: •. •. •. -' . ' • • -' . ' • • -' . ' • • - : - • - • - • : • : • : • : • : • : • : • : • : • • • • • • • • • • • • • : • • • • • • '.'.'- '.'.'- '.'.'- . • . • . • . • . • . • . • . • . • . • E25 770,563 166 167 Purchase of land and equipment 758 758 G25 758 167 168 City hall and general buildings — Current operation 577,154 6,590 583,744 E31 583,744 168 169 Purchase of land and equipment 0 G31 0 169 170 Construction 0 F31 0 170 171 Tort liability — Current operation 0 E89 0 171 172 Other general government — Current operation 916,191 95,955 1,012,146: 20,435 E89 1,012,146 172 173 Purchase of land and equipment 20,435 G89 20,435 173 174 0' 0 174 175 0 0 175 176 TOTAL GENERAL GOVERNMENT 6,265,358 568,817 0 0 0 0 6,834,175 6,834,175 176 177 Section G — DEBT SERVICE 136,183 0 4,702,130 1,242,631 0 6,080,944 6,080,944 177 178 0- 0 178 179 0'.'.'.'.'.'.'.'.'.' 0 179 180 _ 0 0 180 181 0 0 181 182 TOTAL DEBT SERVICE 136,183 0 4,702,130 1,242,631 0 0 6,080,944 6,080,944 182 183 Section H — REGULAR CAPITAL PROJECTS — Specify . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . - . • . • . • . • . • . • . • . • . • 0183 184 9,711,050 8,022,481 24,394,675 42,128,206 42,128,206 184 185 0'• 0 185 186 0.'.'.'.'.'.'.'.'.'. 42,128,206 • . • . • . • . • . • . • . • . • . • • • . • • . • • • 0 186 187 Subtotal Regular Capital Projects 9,711,050 8,022,481 0 0 24,394,675 6 42,128,206 187 188 — TIF CAPITAL PROJECTS — Specify • 0 188 189 0- '.'.'- '.'.'- '.'.'- 0 189 190 335,000 335,000. 335,000 190 191 0 0 191 192 Subtotal TIF Capital Projects 0 0 335,000 0 0 0 335,000. • . • . • . • . • . • . • . • . • . • 335,000 192 193 TOTAL CAPITAL PROJECTS 9,711,050 8,022,481 335,000 0 24, 394,675 0 42,463,206 42,463,206 193 194 TOTAL GOVERNMENTAL ACTIVITIES EXPENDITURES 60,490,217 20,347,131 8,750,239 1,242,631 24,394,675 1,070 115,225,963 •: • : •: •: • : •: •: • : •: • 115,225,963 194 19b (Sum of lines 40, 80, 103, 139, 154, 176, 182, 193) ....... .. ............................... ............................ 195 196 196 Continued on next page Page 10 FORM F- 66(IA -2) (4-20 -2011) Part II EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2012 - Continued CITY OF DUBUQUE DGAAP NON -GAAP = CASH BASIS X Line No. Item description General Sa) Special revenue 5b) J TIF Special revenue c) Debt service cd). Capital projects Se) Permanent Fund (f} Total current governmental (Sum of cols. (a) through (f)) O. Proprietary (h) Code GRAND TOTAL (Sum of cols. (g) and (h)) (9 Line No. 197 Section I — BUSINESS TYPE ACTIVITIES . . .. . . . . . . . . . . . . . . .. . . . . . . . . . '- •.•'.'.'.'.'.'.'.'.'.'.'.'.'.'.'.'.' .'.'.'.'.'.'.'.'.'.'.'.'.'.'.'. • .'.'.'.'.'.'.'.'.'.'.' .'.'.'.'.'.'.'.'.'.'.'.'.'.'.. " " " " " " " " " " " " " " " " " " " " " " " " " " •' "' " ' "' " ' "' " ' "' " ' """" "' " ' "' " ' "' " ' • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • -' • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • .............................. ............................... ..................................... ............................... • - • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • •'.'.'.'.'.'.'.'.'.'.'.'.'.'.'.'.'.'.' .'.'.'.'.'.'.'.'.'.'.'.'.'.'.'. .'.'.'.'.'.'.'.'.'.'.' .'.'.'.'.'.'.'.'.'.'.'.'.'.'.'. • -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • ............................... ............................... : • - . • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • - - - - • - • • • - - - • - • • • - - - • - • • • - - - • - • • • - - - • - • • • - - - - • • • - - - • - • • • - - - • - • • • - - - • .............................. ............................... ' . -' ....................................... ............................... ..................... ............................... • . • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • . . .... ............................... .......................... . - . .............................. ............................... ............................... ............................... ............................... ................. .............................. ........................................... ............................... ................. ............................... , . . . . . , " "" . . . . . . . . . .. . . . . . . 197 198 Water — Current operation 4,030,166 E91 4,030,166 198 199 Purchase of land and equipment 65,255' G91 65,255 199 200 Construction "' " • • • • • • • • • • • • • • • • • F91 0 200 201 Sewer and sewage disposal — Current operation 5,176,396 E80 5,176,396 201 202 Purchase of land and equipment 46,966 G80 46,966 202 203 Construction F80 0 203 204 Electric — Current operation 205 Purchase of land and equipment G92 0 205 206 Construction F92 0 206 207 Gas Utility — Current operation E93 0 207 208 Purchase of land and equipment G93 0 208 209 Construction F93 0 209 210 Parking — Current operation • • • • • • • • 1,326,313 E60 1,326,313 210 211 Purchase of land and equipment 26,934 G60 26,934 211 212 Construction F60 0 212 213 Airport— Current operation - - - - - - - - E01 0 213 214 Purchase of land and equipment G01 0 214 215 Construction • • • • • • • F01 0 215 216 Landfill /Garbage — Current operation 2,564,666 E81 2,564,666 216 217 Purchase of land and equipment 26,765 G81 26,765 217 218 Construction • • • • • • • • • - • • • - - - - • 534,469 F81 534,469 218 219 Hospital — Current operation E36 0 219 220 Purchase of land and equipment G36 0 220 221 Construction F36 0 221 222 Transit — Current operation 2,610,348 E94 2,610,348 222 223 Purchase of land and equipment 194,092 G94 194,092 223 224 Construction 258,724 F94 258,724 224 225 _Cable TV, telephone, Internet— Current operation E03 0 225 226 Purchase of land and equipment G03 0 226 227 Housing authority — Current operation E50 0 227 228 Purchase of land and equipment • • • • • • • • • • • • • • G50 0 228 229 Construction F50 0 229 230 Storm water — Current operation 438,957 E80 438,957 230 231 Purchase of land and equipment 654,586 G80 654,586 231 232 Construction F80 0 232 233 •. . ..................................... . • . ...........................,233 . 234 234 235 236 236 Continued on next page Page 11 FORM F- 66(IA -2) (4 -20 -2011) Part II EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2012 - Continued CITY OF DUBUQUE DGAAP NON -GAAP = CASH BASIS X Line No Item description General (a) Special revenue (b) TIF special revenue (c) Debt service (d) Capital projects (e) Permanent (f) Total governmental (Sum of cols. (a) through (f)) (g) Proprietary (h) Code GRAND TOTAL (Sum of cols. (g) and (h)) (i) Line No. 237 Section I — BUSINESS TYPE ACTIVITIES — Cont. .......... ........ - ' -' . . • .......... .......... - • : •: • . . . . . ........ .......... . . .. -. ....... ............................... .................. ........................ .......................... . . . . . . ...... ............................... . . . . . . ..... . . . . . ........................ . . . . . ............................... ................. .. ........................ .......................... •..•..•..•..•..•..•..•..•..•..• .•..•..•..•..•... • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .••••• •••••••••••••••••••••••• •••••••••••••••••••••••.... • . • . • . • . • . • . . • . • . • . • . • . • . • . • . • . • . • . • . • . • . • . • . • . • . • . • . • . • . • . • . . • . • . • . • . • . • . • . . • . • . • . • . • . • . • . • . • . • . • . • . • . • . . . ........................ .......................... •..•..•..•..•..•..•..•..•..•..• .•..•..•..•..•... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ...... ..... ...... ...... ..... .. .... ...... ...... ..... .... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ........................ .......................... . . . . . . . . . . . . . . . . . . . . . 237 238 Other business type — Current operation 86 E89 86 238 239 Purchase of land and equipment G89 0 239 240 Construction F89 0 240 241 ..................... 241 242 Enterprise Debt Service 7,881,839 7,881,839 242 243 Enterprise Capital Projects 48,155,854 48,155,854 243 244 Enterprise TIF Capital Projects 0 244 245 Internal service funds — Specify . . . .. .. .. .. . . . . . . . . . . . . . . . . . . . . . . . 245 246 1,935, 891 1, 935,891 246 247 2,239,827 2,239,827 247 248 2, 211 2, 211 248 249 21, 651 21, 651 249 250 0 250 251 TOTAL BUSINESS TYPE ACTIVITIES 78,191,996 78,191,996 251 252 ...... ............................... 252 253 TOTAL EXPENDITURES (Sum of lines 194 and 251) 60,490,217) 20,347,131( 8,750,239) 1,242,6311 24,394,675 1,070( 115,225,963 78,191,996 193,417,959 253 254 Section J — OTHER FINANCING USES INCLUDING TRANSFERS OUT • • • - NE . • . . 254 255 255 Regular transfers out 5,374,138 4,462,676. • . • . • . • . • . •. • . • . 2,391,181 0 12,227,995 13,365,995 25,593,990 256 Internal TIF loans /repayments and transfers out 1,813,622 1,929,440 3,743,062 3,743,062 256 257 0 0 257 258 TOTAL OTHER FINANCING USES 5,374,138 4,462,676 1,813,622 0 4,320,621 0 15,971,057 13,365,995 29,337,052 258 259 TOTAL EXPENDITURES AND OTHER FINANCING USES (sum of lines 253 and 258) 65 2 864 L 355 24, 809, 807 10, 563, 861 1,242, 631 28, 715, 296 1,070 131,197, 020 91,557, 991 222, 755,011 259 260 ................................................................................................................... 260 261 Ending fund balance June 30, 2012: •. . ... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ... . . . . . . 261 262 Governmental: 262 263 Nonspendable 23,514 23,514 23,514 263 264 Restricted 459,648 4,337,631 _ 3,972,415 20,347,712 36,749 29,154,155.•. • - • - • - • - • - • - • . • . 29,154,155 264 265 Committed 150,115 5,989,536 6,139,651 . . . . . . . . . . 6,139,651 265 266 Assigned 0 0 266 267 Unassigned 12,633,449 12,633,449 • • . • • • • •. • • • • • . • • • • 12,633,449 267 268 Total Governmental 13,093,097 4,337,631 3,972,415 150,115 26,337,248 60,263 47,950,769 • • 47,950,769 268 269 Proprietary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22,294,484 22,294,484 269 270 Total ending fund balance June 30, 2012 I 13,093,097 4,337,631 3,972,415 150,115 26,337,248 60,263 47,950,769 22,294,484 70,245,253 270 271 TOTAL REQUIREMENTS (Sum of lines 259 and 270) 78,957,452 29,147,438 14,536,276 1,392,746 55,052,544 61,333 179,147,789 113,852,475 293,000,264 271 .. ............................... .......... ............................... ................. ..................... Continued on next page Page 12 FORM F- 66(IA -2) (4 -20 -2011) Part III INTERGOVERNMENTAL Please report below Include these expenditures Purpose Correction ............... Health. Highways. Transit subsidies...... Libraries. Police protection...... Sewerage ............... Sanitation. All other. EXPENDITURES expenditures made to in part II. Enter CITY OF DUBUQUE the State or to other local governments on a reimbursement or cost sharing basis. amount, omit cents. Purpose Highways........ All other.......... Amount paid to other local governments Amount paid to State M05 $ 0 L44 $ 0 M32 0 L89 0 M44 0 M94 0 M52 0 M62 0 M80 0 M81 0 M89 $ $ 0 Part IV SALARIES AND WAGES Report here the total salaries and wages paid to all employees of your government before deductions of social retirement, etc. Inc ude also salaries and wages paid to employees of any utility owned and operated by your government, as well as salaries and wages of municipal employees charged to construction projects. Total salaries and wages paid security, Amount - Omit cents Z00 $ 37 686 777 Part V DEBT OUTSTANDING, ISSUED, AND RETIRED A. Long -term debt Purpose Debt outstanding JULY 1, 2011 )a) Debt during the fiscal year Debt Outstanding JUNE 30, 2012 Interest paid this year )h) Issued (b) Retired )c) General obligation )d) TIF revenue (e) Revenue )f) Other (g) 1. Water utility 19U $ 6.755.000 29U $ 39U $ 255.000 49U $ 49U $ 49U $ 6.500.000 49U $ 191 $ 237.608 2. Sewer utility 19U 29U 39U 49U 49U 49U 49U 189 3. Electric utility 19U 29U 39U 49U 49U 49U 192 4. Gas utility 19U 29U 39U 49U 49U 49U 193 5. Transit -bus 19U 29U 39U 49U 49U 49U 194 6. Industrial Revenue 19T 24T 34T 44T 44T 189 7. Mortgage revenue 19T 24T 34T 44T 44T 189 8. TIF revenue 19U 25,199,240 29U 19,653 39U 962,276 49U 49U 24,256,617 49U 49U 189 1,873,574 Other - Specify 9. IFA 19U 29U 4,500,000 39U 49U 49U 49U 49U 4,500,000 189 85,125 GO Corp 1g. Purpose 19U 57.775.000 29U 33.935.000 39U 3.710.000 49U 88.000.000 49U 49U 49U 189 2.537.521 SRF 11. 19U 33,165,408 29U 29,401,340 39U 609,000 49U 49U 49U 61,957,748 49U 189 1,625,410 Private 12. Dbq Initiative 19U 352,109 29U 39U 20,874 49U 49U 49U 49U 331,235 189 17,348 Bank Notes 13. US Bank 19U 1.900.000 29U 39U 1.900.000 49U 49U 49U 49U 189 22.333 Purchase Agmt 14. IDOT 19U 282,857 29U 39U 47,143 49U 49U 49U 49U 235,714 189 0 Total long -term debt 125,429,614 67,855,993 7,504,293 88,000,000 24,256,617 68,457,748 5,066,949 6,398,919 B. Short -term debt Outstanding as of JULY 1, 2011 Outstanding as of JUNE 30, 2012 Amount - Omit cents 61V $ o 64V $ 0 Part VI DEBT LIMITATION FOR GENERAL OBLIGATION BONDS Click to visit DOM Valuation WEBSITE. 1005 VAL BY INDIVIDUAL LEVY AUTHORITY Actual valuation -- January 1, 2010 Amount - Omit cents $ 3,549,701,816 x.05 = $ I 177,485,091 Part VII CASH AND INVESTMENT ASSETS AS OF JUNE 30, 2012 Type of asset _ Amount - Omit cents Bond and interest funds (a) Bond construction funds (b) Pension!retirement funds (c) all other funds funds (d) Total (el Cash and investments - Include cash on hand, CD's, time, checking and savings deposits, Federal securities, Federal agency securities, State and local government securities, and all othersecurltles. Exclude value of real property. W01 W31 W61 $ $ 33,752,433 50,280,092 84,032,525 REMARKS V98 FORM F- 66(IA -2) (4 -20 -2011) Page 13