Loading...
State of Iowa Annual Financial ReportMasterpiece on the Mississippi TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2011 State of Iowa Annual Financial Report DATE: November 1, 2011 Dubuque bitd AA- America City I'll! 2007 Finance Director Ken TeKippe recommends City Council approval of the City of Dubuque's Annual Financial Report for Fiscal Year ending June 30, 2011. I concur with the recommendation and respectfully request Mayor and City Council approval. Mic gen ael C. Van Milligen Attachment cc: Barry Lindahl, City Attorney Cindy Steinhauser, Assistant City Manager Ken TeKippe, Finance Director Masterpiece on the Mississippi TO: Michael C. Van Milligen, City Manager FROM: Ken TeKippe, Finance Director Fiscal Year 2011 State of Iowa Annual Financial Report DATE: October 25, 2011 Dubuque Al- America City I'll', 2007 The City of Dubuque's Fiscal Year 2011 Annual Financial Report 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 11, 2011. There is no statutory requirement for the City Council to approve the AFR or pass a resolution prior to 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 the David A. Vaudt, Auditor of the State pursuant to the Code of Iowa Section 384.22 by December 1, 2011. Should you have any questions on the attached report, please feel free to contact me. Thank you. Cc: Jenny Larson, Budget Director Enc (1) A. ART'" DED • ,I iszaStOrinaiicio 61.', , DUbu1gie.." 0'IA 52031 • i'44'., , •,1 •• , r • .,. ■ Tese.•; .nom add ea. and ZIP Cogs) ' 04 NOTE -The imronnaiion enpp6ed. J ' 'regthriSretbe shared by the Iowa Stets• Auditors ORice;• ie 111.S. Cebu* :`eadoos public Indereet'9roups; anr3 State` and federal meanies, �, ALSEUND3 , _ Governmental • (a) Proprietary • , (b)- .. : Total actual (c).;. , , Budget ' (d), es 19,177592 i rri::x at ':: :[ =: 19,1 7,697, 191J.7697 If 123.919 ,' yr ti ;: - :• •ff5. . .,, _123.919 0 ' . • • 19553;778 : ;rk6:. : •19053.778 , . . , .19,12x;697 50$. «. >.:. r:s -: -r: = :�,, :',•, }`y: :. ,, 50,958 :1: ei ,,:i0 :'9.080e6A2 8,35B38T .. .............::: . .8.358.362 10,967.592 ,. .1d0:96T,89 . 14,628.325 4,207,871 12,890 "4;220,71 •_ _ . , 1.1:8,750 • 16,285.368 • . 174.453 ._ • 16,459.829. 17,45'0,449 24,97001591 5:567,6 : "' , '3.53.233. 89087.060 - 5,564.798 21,348.43 U , .. ' X911,225 ' 2795,269 88":1 0 +z :lee St;, `.'''' 19,550543. 5,0'15923, .24.566:766 " 9;'1`5'1;669 25.232599 ' 4 "' " .6'5.965.230' 1U5,4'00:1 . 134,53'1.341 ' ' "7.4849,570'' ..,' 207:3$0,91"! 'T'9&:80t.' :i6 .23.313589 . 0 . 23at8,91iii' : 23963,288 11,3911228_ . d s ' 11,39.128 8is.hs8i, 1$ :o87,742 9sz 72 886:5E 2 • 0'''R' 9.696479 tv 9:896.979 4 i �. . '696.402 11312,B54 0 •1',:312,854 ,,.. ' ';2,249';95 74614 42 0 s' ' 7;0615.842 ' 7319042 6, '8;ff3 ' 0' ' '6,'78&1T3 245.58,007 . 95:'491,644 5,722'.717 94,494:211 ,•', . 187 A- 170 25536,097 0' 95,491,644 • 0 0 • 73.35754 73165144 a ...a,,,',,..,,,. . • 95.491544 73,357544. . 16589,283. ' 287.43,478, n K460.699 4 61281 38 ft1g969 ' . 38,1051298' 123,952343 78ala.905 .. _ .' 20.6 L ::• 325,508.776 rs aver • 5,51998 :169. ,• 409663 . - 26.702840 28‘42i538 19,0.84,155: ', 47512.133' :. 447.41215 34:006.9715 .13,914,320, ,. •... ' 's. '334038,375 •u" ; r 'I: r7 ; '-v'- '^ f,'. id_ :. Aa lrrt045' 4 s ' i i,,;„, :.r.. , in aP p.oseT Trustfundsand"' 'f'll 725,868 - • aren,aktiied�ted�id are notaJailable'fot:caty operations: ns - `, , _ :".:,.•-.,[ :• .' .1 .. • . STATE OF IOWA {SS: DUBUQUE COUNTY CERTIFICATION OF PUBLICATION I, Suzanne Pike, a Billing Clerk for Woodward Communications, Inc., an Iowa corporation, publisher of the Telegraph Herald,a newspaper of general circulation published in the City of Dubuque, County of Dubuque and State of Iowa; hereby certify that the attached notice was published in said newspaper on the following dates: November 11, 2011, and for which the charge is $205.19. Subscribed to before me otary Public in and for Dubuque County, Iowa, this �6 -- — day of tr , 20 // . rle Notary Public in and for Dubuque County, Iowa. MARY K. WdESTERMEYER Commisslen Number 154''E5 '''' Form F-66 (IA -2) N- 204011) • . . STATE OF IOWA. . 2011 ' FINANCIAL REPORT FISCAL YEAR ENDED JUNE 30,2011 CITY OF DUBUQUE • , IOWA - - 16203100700000 , Dubuque 50W13thSt. Dubuque, IA 52001 . • (Please coned any enorin name, address, and z!P Cade) DUE: December 1, 2011 WHEN David A, Vaudt, CPA COMPLETED, Auditor of State PLEASE State Capitol Building RETURN TO Des Moines, IA 50319 -0004 NOTE -The information supplied injthls report will be shared by the Iowa State Auditors Office; the U.S. Census Bureau, various public Interest groups, and State and federal agencies. ALL FUNDS Item description • Govemmental (a) Proprietary (b) Total actual (c) Budget (d) Revenues and Other Financing Sources 'Taxes levied on property 19,177,697 =:: ::i:;:;:j:;:c;:j ;:::;` :::- 19,17./,697 19,177,697 " Less: Uncollected property taxes -levy year 123,919 123,919 0 Net current property taxes ' - • • 19,053,778 '' ::::::::::::::•." >::::: 19.053,778 19,177,697 Delinquent property taxes 50,958 i? ::: >:2 :::: :: ::: : :`. :: 50,958 0 TIF revenues 8,358,387 8,358,387 9,080,612 Other city taxes - - 10,967,592 0 10.967.592 14,628,325 licenses and permits 4,207,871 -12,890 4,220,761 1,187,750 Use of money and properly • 16,285,368 174,453 • 16,459,821 17,450,449 Intergovernmental 24,970,591 5,567,642 30,538 233 89.087,080 Charges for fees and service 5,564,798 21,346,431 26,911,229 30.276.892 Special assessments 288,156 0 288,156 2,765,269 Miscellaneous 19.550,843 5,015.923 • 24,566,766 9.751,669 Other financing sources 25,232,999 40,732,231 65,965.230 105.400.193 Total revenues and other sources 134,531,341 72,849,570 207,380,911 298,805,936 Expenditures and Other Financing Uses Public safety 23.318,989 • 0 23,318,989 23,903,288 Public works 11,391,328 0 11,391,328 13,087,242 Health and social services 885,582 • 0 885.582 962,372 Culture and recreation 9,696,979 0 9,696,979 9,699.402 Community and economic development 11,312,854 0 - 11,312,854 7,061,642 12,249,796 7,190,142 General government 7,061,642 0 Debt service 6,288,173 0 6288,173 5,722,717 Capital projects 25.536.097 0 25,536,097 94,490.211 Total governmental activities expenditures . 95.491,644 0 95,491,644 •. 167,305,170 Business type activities 0 73.357,644 73,357,644 120,098,308 Total ALL expenditures 95,491,644 73,357,644 168,849,288 ' 287,403,478 Other financing uses, including transfers out 33,460,699 4.661,261 38,121,960 38,105,298 Total ALL expenditures/And • ' other financing uses 128,952,343 78.018,905 206,971,248 . 325,508,776 Excess revenues and other sources over (Under) Expenditures /And other financing uses 5,578.998 -5,169,335 • 409,663 - 26,702.840 Beginning fund balance July 1, 2010 28,427,978 19,084,155 47,512,133 49,741.215 Ending fund balance June 30, 2011 34,006,676 13,914,820 47,921,796 23,038,375 Note -._these balances do not ndfude $ " _ -051 ;687' ", "' - held in non - budgeted 'nternaf seivicerrfunds; $ ,,y;', . - . held in Pension Trust'Fuilds :', • • z ,- '['i[: :r, ,.... .. _ . - "field'iri P"rivate'Purp ose.Trust hinds.- and-$ . r- 11,725,868 -'- held in agency funds =which werenotbudgetedand are not•available for aty "operations . .. Indebtedness at June 30, 2011 Amount - Omit cenls Indebtedness at June 30, 2011 Amount -Omit cents General obligation debt - $ 57,775,000 Other long -term debt $ 2,534,966 Revenue debt 39,920,408 Short-term debt $ 0 TIF Revenue debt .$ $ 25,199,240 • General obligation debt limit . $ 1.74 156118 .• CERTIFICATION. • TH `•REGOING REPORT IS CORRECT TO THE BEST OF MY KNOWLEDGE AND BELIEF ' Signature of city Berk 1. ' - wall/, 21Pr / /� /, /i / , - Date Published/Posted 11 -11 -2011 Mark-(,) one ® Date Pubruhed ; 0 Date Posted Printed name of city d - Kevin S. Frristahl • - Te1ephone Area Code 553 Number 589 -4121 Extension _ --r Signature of Mayor of other City official (Na nd e) Roy D. Buol, Mayor (/)f 7 Date signed 11-07 -2011 it11/11 - 403524- 91A(11 -9 STAT DUBE_ I, Suzanne corporatic published certify the dates: No Subscribe this Fonn F-66 (IA -2) (9- 20-2011) STATE OF IOWA 2011 FINANCIAL REPORT FISCAL YEAR ENDED JUNE 30, 2011 CITY OF DUBUQUE , IOWA 16203100700000 Dubuque 50 W 13th St. Dubuque, IA 52001 (Please correct any error in name, address, and ZIP Code) DUE: December 1, 2011 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 Stale 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 19,177,697 .::::::.'::= :::::::: ..................... :::::::::::::::::::::::: > ....... ....... 19,177,697 19,177,697 Less: Uncollected property taxes -levy year 123,919 123,919 0 Net current property taxes - 19,053,778 :::::::::::::::•::::::::.:::: 19,053,778 19,177,697 Delinquent property taxes 50,958 ;: =: ; :::: :::::::::::::::: :: ..................... .................... 50,958 0 TIF revenues 8,358 387 8,358,387 9,080,612 Other city taxes 10,967,592 0 10,967,592 14,628,325 Licenses and permits 4,207,871 12,890 4,220,761 1,187,750 Use of money and property 16,285,368 174,453 16,459,821 17,450,449 Intergovernmental 24,970,591 5,567,642 30,538,233 89,087,080 Charges for fees and service 5,564,798 21,346,431 26,911,229 30,276,892 Special assessments 288,156 0 288,156 2,765,269 Miscellaneous 19,550 843 5,015,923 24,566,766 9,751,669 Other financing sources 25,232,999 40,732,231 65,965,230 105,400,193 Total revenues and other sources 134,531,341 72,849,570 207,380,911 298,805,936 Expenditures and Other Financing Uses Public safety 23,318,989 }k 0 23,318,989 23,903,288 Public works 11,391,328 0 11,391,328 13,087,242 Health and social services 885,582 0 885,582 962,372 Culture and recreation 9,696,979 0 9,696,979 9,699,402 Community and economic development 11,312,854 0 11,312,854 12,249,796 General government 7,061,642 0 7,061,642 7,190,142 Debt service 6,288,173 0 6,288,173 5,722,717 Capital projects 25,536,097 0 25,536,097 94,490,211 Total governmental activities expenditures 95,491,644 0 95,491,644 167,305,170 Business type activities 0 73,357,644 73,357,644 120,098,308 Total ALL expenditures 95,491,644 73,357,644 168,849,288 - 287,403,478 Other financing uses, including transfers out 33,460,699 4,661,261 38,121,960 38,105,298 Total ALL expenditures /And other financing uses 128,952,343 78,018,905 206,971,248 325,508,776 Excess revenues and other sources over (Under) Expenditures /And other financing uses 5,578,998 - 5,169,335 409,663 - 26,702,840 Beginning fund balance July 1, 2010 28,427,978 19,084,155 47,512,133 49,741,215 Ending fund balance June 30, 2011 34,006,976 13,914,820 47,921,796 23,038,375 l Note - These balances do not include $ 1,051,687 held in non - budgeted internal service funds; $ held in Pension Trust Funds; $ held in Private Purpose Trust funds and $ 11,725,868 held in agency funds which were not budgeted and are not available or city operations. Indebtedness at June 30, 2011 Amount - Omit cents Indebtedness at June 30, 2011 Amount - Omit cents General obligation debt $ 57,775,000 Other long -term debt $ 2,534,966 Revenue debt $ 39,920,408 Short -term debt $ 0 TIF Revenue debt $ 25,199,240 General obligation debt limit 174,156,118 CERTIFICATION TH re REGOING REPORT IS CORRECT TO THE BEST OF MY KNOWLEDGE AND BELIEF Signature of city clerk / , wO /1fi�� �i����A)10/ " Date Published/Posted 11 -11 -2011 Mark (x) one i Dale Published ❑ Dale Posted Printed name of city cle' Kevin S. Firnstahl Telephone —a- Area Code 563 Number 589 -4121 Extension Signature of Mayor of other City official (N0- ndt le) Roy D. Buol, Mayor V `� Dale signed 11 -07 -2011 PLEASE PUBLISH THIS PAGE ONLY 19 Rents and royalties 15, 039, 953 15,903 15, 055, 856 801 U40 15,056,657 19 Part I REVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2011 CITY OF DUBUQUE Line No. Item description General (a) Special revenue (b) TIF special revenue (c) Debt service (d) Capital projects (e) 0GAAP ©NON-GAAP = CASH BASIS Indicate by placing an X in the appropriate box on this sheet ONLY Permanent (f) Total governmental (Sum of cols. (a) through (0) (9) Proprietary (h) Code GRAND TOTAL (Sum of cols. (g) and (h)) (i) Line No. 1 2 3 4 5 6 7 Section A - TAXES Taxes levied on property 16,524,980 2,539,864 112,853 Less: Uncollected property taxes - Levy year 123,919 0 0 Net current property taxes 16,401,061 2,539,864 0 112,853 0 0 Delinquent property taxes 11,874 26,125 12,959 Total property tax 16,412,935 2,565,989 0 125,812 0 TIF revenues 8 9 Other city taxes Utility tax replacement excise taxes Utility franchise tax (Chapter 364.2, Code of Iowa) 8,358,387 19,177,697 123,919 19, 053, 778 50,958 19,104, 736 8,358,387 617,264 50,187 3,547 670,998 T01 T01 T15 1 19,177,697 2 123,919 3 19,053,778 4 50,958 5 19,104,736 6 8,358,387 7 670,998 8 0 T15 0 9 10 11 Parimutuel wager tax Gaming wager tax 26,009 26,009 C30 26,009 10 12 Mobile home tax 594,835 594,835 C30 594,835 11 13 Hotel /motel tax 30,549 30,549 T19 30,549 12 14 1,754,149 1,754,149 T19 1,754,149 13 15 Other local option taxes TOTAL OTHER CITY TAXES 3,945,526 3,945,526 7,891,052 T09 7,891,052 14 6,968,332 16 Section B - LICENSES AND PERMITS 3,727,538 50,187 480,333 0 3,547 3,945,526 0 10, 967, 592 0 10, 967, 592 15 4,207,871 12,890 T29 4,220, 761 16 17 Section C - USE OF MONEY AND PROPERTY 17 18 Interest 283,101 37,421 201,511 94,235 4,132 620,400 173,652 U20 794,052 18 20 21 Other miscellaneous use of money and property 82,740 429,924 96,448 609,112 U20 609,112 20 0 21 22 15,405, 794 23 TOTAL USE OF MONEY AND PROPERTY 24 Section D - INTERGOVERNMENTAL 25 26 Federal grants and reimbursements 27 Federal grants 467,345 297,959 0 110,138 4,132 16, 285, 368 174,453 16, 459, 821 2,327,959 95,794 29,024 27,598 6,158,527 8,638,902 3,966,741 B89 12,605,643 22 23 24 25 26 27 28 Community development block grants 1,194,282 1,194, 282 B50 1,194,282 28 29 Housing and urban development 29,950 5,848,851 5,878,801 B50 5,878,801 29 30 Public assistance grants 253,141 253,141 B79 253,141 30 31 Payment in lieu of taxes 0 B30 0 31 32 0 32 33 34 35 36 37 38 39 40 Total Federal grants and reimbursements 2,611,050 7,138,927 29,024 27,598 6,158,527 0 15, 965,126 3,966,741 19,931,867 33 34 35 36 37 38 39 40 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, 2011 -- 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 (9) Proprietary (h) Code GRAND TOTAL (Sum of cols. (g) and (i) Line No. 41 Section D - INTERGOVERNMENTAL - Continued .. 41 42 42 43 State shared revenues 43 44 Road use taxes 5,251,421 5,251,421 1 C46 1 - 5,251,421 44 45 ,........... 45 46 46 47 47 48 Other state grants and reimbursements 48 49 State grants 2,175,236 650,488 2,825,724 1,290,886 C89 4,116,610 49 50 Iowa Department of Transportation 31,243 31,243 172,590 C89 203,833 50 51 Iowa Department of Natural Resources 0 C89 0 51 52 Iowa Department of Economic Development 227,266 227,266 C89 227,266 52 53 CEBA grants 0 C89 0 53 54 Vision Iowa 68,629 68,629 C89 68,629 54 55 Military Service Tax Credit 13,009 13,009 13,009 55 56 Replacement County 57,036 57,036 57,036 56 57 Transfer of Jurisdiction Payments 2,229 2,229 2,229 57 58 0 0 58 59 0 0 59 60 Total state 2,313,910 5,253,650 0 0 908,997 0 8,476,557 1,463,476 9,940,033 60 62 Local grants and reimbursements 62 63 County contributions 379,735 379,735 137,425 517,160 63 64 Library service 9,229 9,229 D89 9,229 64 65 Township contributions 0 D89 0 65 66 Fire /EMT service 139,944 139,944 D89 139,944 66 67 0 D89 0 67 68 0 0 68 69 0 0 69 70 Total local grants and reimbursements 528,908 0 0 0 0 0 528,908 137,425 666,333 70 71 TOTAL INTERGOVERNMENTAL (Sum of lines 33, 60, and 70) 5,453,868 12,392,577 29,024 27,598 7,067,524 0 24,970,591 5,567,642 30,538,233 71 72 Section E - CHARGES FOR FEES AND SERVICE 72 73 Water 11,745 11,745 5,712,607 A91 5,724,352 73 74 Sewer 0 6,531,642 A80 6,531,642 74 75 Electric 0 A92 0 75 76 Gas 0 A93 0 76 77 Parking 0 2,162,286 A60 2,162,286 77 78 Airport 2,715,823 59,280 143,085 2,918,188 0 A01 2,918,188 78 79 Landfill /garbage 0 3,106,520 A81 3,106,520 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, 2011 -- 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 E - CHARGES FOR FEES AND SERVICE - Continued 82 Transit 0 192,343 A94 192,343 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 2,867,775 A80 2,867,775 87 88 Other: 88 89 Nursing home 0 A89 0 89 90 Police service fees 16,875 16,875 A89 16,875 90 91 Prisoner care 0 A89 0 91 92 Fire service charges 0 A89 0 92 93 Ambulance charges 1,089,325 1,089,325 A89 1,089,325 93 94 Sidewalk street repair charges 18,155 18,155 A44 18,155 94 95 Housing and urban renewal charges 73,097 20,400 93,497 A50 93,497 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 19,986 19,986 A89 19,986 99 100 Park, recreation, and cultural charges 1,335,359 1,335,359 A61 1,335,359 100 101 Animal control charges 0 A89 0 101 102 Other charges - Specify 53,801 7,867 61,668 61,668 102 103 Salt sales 0 773,258 773,258 103 104 TOTAL CHARGES FOR SERVICE 5,316,011 105,702 0 0 143,085 0 5,564,798 21,346,431 26,911,229 104 105 . 105 106 Section F - SPECIAL ASSESSMENTS 288,156 288,156 U011 288,156 ......... . 106 107 107 Section G - MISCELLANEOUS 108 Contributions 1,048,027 124,047 22,396 1,194,470 202,218 U99 1,396,688 108 109 Deposits and sales /fuel tax refunds 98,756 84,341 25 183,122 16,257 U99 199,379 109 110 Sale of property and merchandise 0 U11 0 110 111 Fines 506,520 1,050 507,570 302,268 U30 809,838 111 1.12 Internal service charges 510,190 510,190 3,537,379 NR 4,047,569 112 113 Other miscellaneous - Specify 135,786 33,333 5,540 174,659 13,960 188,619 113 114 Insurance Claims 8,540 627,632 636,172 65,224 701,396 114 115 Damage Claims 29,201 4,013 33,214 28,363 61,577 115 116 Reimbursements 349,361 92,843 202,691 16 644,911 268,159 913,070 116 117 Sales Tax Collections 0 582,095 582,095 117 118 Bond Proceeds Holding 15,666,535 15,666,535 15,666,535. 118 119 0 0 119 120 TOTAL MISCELLANEOUS 2,686,381 339,627 0 15,666,535_ 858,284_ 16__ 19,550,843 5,015,923 24,566,766 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, 2011 -- Continued CITY OF DUBUQUE EIGAAP 9 NON -GAAP = CASH BASIS Line No. Item description General (a) Special revenue (b) TIF special revenue (c) 121 TOTAL ALL REVENUES (Sum of lines 6, 7, 15,16,22 71, 104, 106, and 120) 55, 970, 859 16,689,916 8,685,370 Debt service (d) 15,823,492 Capital projects (e) 12,124,557 Permanent (f) Total governmental (Sum of cols. (a) through (f)) (9) Proprietary (h) Code GRAND TOTAL (Sum of cols. (g) and (h)) (i) Line No. 4,148 109, 298, 342 32,117,339 141,415,681 121 122 123 Section H - OTHER FINANCING SOURCES 122 123 124 Proceeds of capital asset sales 125,513 627,640 753,153 35,786 NR 788,939 124 125 Proceeds of long -term debt (Excluding TIF internal bon-owing) 0 360,700 0 0 360,700 26,693,631 NR 27,054,331 125 126 Proceeds of anticipatory warrants or other short-term debt 0 A89 0 126 127 Regular transfers in and interfund loans 11,572,780 1,963,646 1,342,961 7,298,035 5,140 22,182,562 13, 383,121 35, 565,683 127 128 Internal TIF loans and transfers in 351,566 398,146 670,772 391,100 125,000 1,936,584 619,693 2,556,277 128 129 0 0 129 130 0 0 130 131 TOTAL OTHER FINANCING SOURCES 12,049,859 2,361,792 1,031,472 1,734,061 8,050,675 5,140 25,232,999 40,732,231 65,965,230 131 132 TOTAL REVENUES except for beginning balances (Sum of lines 121 and 131) 68, 020, 718 19,051,708 9,716,842 17,557,553 20,175,232 9,288 134,531,341 72,849,570 207, 380, 911 132 133 133 134 Beginning fund balance July 1, 2010 12,181,6881 2, 595, 8901 3,190,190 73,360] 10,329,871 135 56,9791 28,427, 9781 19, 084,155 47, 512,133 134 135 136 TOTAL REVENUES AND OTHER FINANCING SOURCES (Sum of lines 132 and 134) 80,202,406 21, 647, 598 12, 907, 032 17,630,913 30, 505,103 66,267 162,959,319 91,933,725 254, 893, 044 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, 2011 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. 1 Section A - PUBLIC SAFETY 1 2 Police department/Crime prevention - Current operation 10,967,816 126,230 11,094,046 E62 11,094,046 2 3 Purchase of and and equipment 345,983 345,983 G62 345,983 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,219,088 1,219,088 E89 1,219,088 8 9 Purchase of land and equipment 1,387 1,387 G89 1,387 9 10 Flood control - Current operation 318,563 318,563 E59 318,563 10 11 Purchase of land and equipment 0 G59 0 11 12 Construction 0 F59 0 12 13 Fire department - Current operation 7,238,166 37,895 7,276,061 E24 7,276,061 13 14 Purchase of land and equipment 123,607 123,607 G24 123,607 14 15 Construction 0 F24 0 15 16 Ambulance - Current operation 1,381,680 1,381,680 E32 1,381,680 16 17 Purchase of land and equipment 14,369 14,369 G32 14,369 17 18 Building inspections - Current operation 785,271 785,271 E66 785,271 18 19 Purchase of land and equipment 4,936 4,936 G66 4,936 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 260,806 260,806 E32 260,806 24 25 Purchase of land and equipment 21,527 21,527 G32 21,527 25 26 Construction 0 F32 0 26 27 Other public safety - Current operation 471,665 471,665 E89 471,665 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 23,154,864 164,125 0 0 0 0 23,318,989 0 23,318,989 _ 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, 2011 - Continued CITY OF DUBUQUE IIGAAP 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,017,624 2,604,026 3,621,650 E44 3,621,650 42 43 Purchase of land and equipment 33,459 304,375 337,834 G44 337,834 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 709,190 709,190 E44 709,190 48 49 Traffic control safety — Current operation 88,273 88,273 E44 88,273 49 50 Purchase of and and equipment 0 G44 0 50 51 Construction 0 F44 0 51 52 Snow removal — Current operation 1,918,051 1,918,051 E44 1,918,051 52 53 Purchase of land and equipment 4,726 4,726 G44 4,726 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 554,268 554,268 E81 554,268 57 58 Purchase of land and equipment 919 919 G81 919 58 59 Airport (if not an enterprise) — Current operation 3,674,633 3,674,633 E01 3,674,633 59 60 Purchase of land and equipment 142,187 142,187 G01 142,187 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 337,898 337,898 E89 337,898 65 66 Purchase of land and equipment 1,699 1,699 G89 1,699 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,004,963 5,386,365 0 0 0 0 11,391,328 0 11,391,328 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, 2011 - Continued CITY OF DUBUQUE IDGAAP NON -GAAP = CASH BASIS 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 C — HEALTH AND SOCIAL SERVICES 81 82 Welfare assistance — Current operation 0 E79 0 82 83 Purchase of land and equipment 0 G79 0 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 329,061 29,402 358,463 E32 358,463 88 89 Purchase of land and equipment 610 610 G32 610 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 439,195 87,314 526,509 E79 526,509 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 768,866 116,716 0 0 0 0 885,582 0 885,582 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 Continued on next page Page 8 FORM F- 66(IA -2) (4 -20 -2011) Part 11 EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2011 - Continued CITY OF DUBUQUE IIGAAP 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 Section D - CULTURE AND RECREATION 121 122 Library services - Current operation 2,763,702 104,606 7,371 2,875,679 E52 2,875,679 122 123 Purchase of land and equipment 29,049 12,900 41,949 G52 41,949 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,536,732 2,132 2,538,864 E61 2,538,864 127 128 Purchase of land and equipment 64,335 64,335 G61 64,335 128 129 Construction 0 F61 0 129 130 Recreation - Current operation 2,549,835 143,267 2,693,102 E61 2,693,102 130 131 Purchase of land and equipment 37,493 37,493 G61 37,493 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, auditorium, zoo and marina 1,113,591 1,113,591 E61 1,113,591 135 136 Other culture and recreation 331,691 331,691 E61 331,691 136 137 Purchase of land and equipment 275 275 G61 275 137 138 Construction 0 F61 0 138 139 TOTAL CULTURE AND RECREATION 9,426,703 260,773 0 0 0 9,503 9,696,979 0 9,696,979 139 140 Section E - COMMUNITY AND ECONOMIC DEVELOPMENT 140 141 Community beautification - Current operation 100,246 100,246 E89 100,246 141 142 Purchase of land and equipment 2,478 2,478 G89 2,478 142 143 Economic development- Current operation 1,271,578 261,140 344,797 1,877,515 E89 1,877,515 143 144 Purchase of land and equipment 0 G89 0 144 145 Housing and urban renewal - Current operation 641,210 5,607,820 6,249,030 E50 6,249,030 145 146 Purchase of land and equipment 1,481 24,252 25,733 G50 25,733 146 147 Construction 0 F50 0 147 148 Planning and zoning - Current operation 646,592 79,257 725,849 E29 725,849 148 149 Purchase of and and equipment 3,168 3,168 G29 3,168 149 150 Other community and economic development - Current operation 30,450 2,298,385 2,328,835 E89 2,328,835 150 151 Purchase of land and equipment 0 G89 0 151 152 Construction 0 F89 0 152 153 TOTAL COMMUNITY AND ECONOMIC DEVELOPMENT 2,594,479 6,075,193 2,643,182 0 0 0 11,312,854 0 11,312,854 153 154 .. .. TIF Rebates are expended out of the : TIF Special Revenue Fund within the Community and Economic Development program's activity "Oth a 154 155 155 156 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, 2011 - Continued CITY OF DUBUQUE IIGAAP X NON -GAAP = CASH BASIS 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,213,643 449,301 2,662,944 E29 2,662,944 160 161 Purchase of land and equipment 15,462 14,758 30,220 ............ G29 30,220 161 162 Clerk, Treasurer, financial administration - Current operation 1,899,010 1,899,010 E23 1,899,010 162 163 Purchase of land and equipment 22,571 22,571 G23 22,571 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 712,777 712,777 E25 712,777 166 167 Purchase of land and equipment 3,920 3,920 G25 3,920 167 168 City hall and general buildings - Current operation 560,563 6,272 566,835 E31 566,835 168 169 Purchase of land and equipment 2,079 2,079 G31 2,079 169 170 Construction 0 F31 0 170 171 171 Tort liability - Current operation 0 E89 0 172 Other general government - Current operation 1,020,767 94,753 1,115,520 E89 1,115,520 172 173 Purchase of land and equipment 45,766 45,766. G89 45,766 173 174 0 :: 0 174 175 0 :. :.. 0 175 176 TOTAL GENERAL GOVERNMENT 6,496,558 565,084 0 0 0 0 7,061,642 :; 7,061,642 176 177 Section G - DEBT SERVICE 48,374 4,387,552 1,852,247 6,288,173 :::.:.:.... .: 6,288,173 177 178 0 0 178 179 0 0 179 180 0 .... : :: ".. 0 180 181 0 0 181 182 TOTAL DEBT SERVICE 48,374 0 4,387,552 1,852,247 0 0 6,288,173 6,288,173 182 183 Section H - REGULAR CAPITAL PROJECTS - Specify ....: 0 183 184 184 Governmental 7,446,433 2,348,901 94,839 15,240,502 25,130,675 . . 25,130,675 185 Special TIF 0 0 185 186 0 0 186 187 Subtotal Regular Capital Projects 7,446,433 2,348,901 0 94,839 15,240,502 0 25,130,675 25,130,675 187 188 -TIF CAPITAL PROJECTS - Specify • ::.... :.... ..... • .. 0 188 189 Downtown Rehab and Downtown loan pool. 405,422 405,422 405,422 189 190 0 : 0 190 191 0 0 191 192 Subtotal TIF Capital Projects 0 0 405,422 0 0 0 405,422 405,422 192 193 TOTAL CAPITAL PROJECTS 7,446,433 2,348,901 405,422 94,839 15,240,502 0 25,536,097. ....... 25,536,097 193 194 TOTAL GOVERNMENTAL ACTIVITIES EXPENDITURES 55,941,240 14,917,157 7,436,156 1,947,086 15,240,502 9,503 95,491,644 ;:; ::; 95,491,644 194 95 (Sum of lines 40, 80, 103, 139, 153, 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, 2011 - Continued CITY OF DUBUQUE EIGAAP 9 NON -GAAP = CASH BASIS Line No. Item description General (a) Special revenue (b) TIF Special revenue (c) Debt service (d) Capital projects (e) Permanent Fund Total current governmental (Sum of cols. (a) through (f)) (9) Proprietary (h) Code GRAND TOTAL (Sum of cols. (g) and (h)) (i) Line No. 197 198 199 200 201 202 203 Section I — BUSINESS TYPE ACTIVITIES Water — Current operation 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 Purchase of land and equipment Construction Sewer and sewage disposal — Current operation Purchase of land and equipment Construction Electric — Current operation Purchase of land and equipment Construction Gas Utility — Current operation Purchase of land and equipment Construction Parking — Current operation Purchase of land and equipment Construction Airport — Current operation Purchase of land and equipment Construction Landfill /Garbage — Current operation Purchase of land and equipment Construction Hospital — Current operation Purchase of land and equipment Construction Transit — Current operation Purchase of land and equipment Construction Cable TV, telephone, Internet — Current operation Purchase of land and equipment Housing authority — Current operation Purchase of land and equipment Construction Storm water — Current operation Purchase of land and equipment Construction 4,369,805 98,489 4,090,115 17,680 1,314,798 32,393 2,347, 598 66,844 2,547,051 21,698 406,401 1,279 E91 G91 F91 E80 G80 F80 E92 G92 F92 E93 G93 F93 E60 G60 F60 E01 G01 F01 E81 G81 F81 E36 G36 F36 E94 G94 F94 E03 G03 E50 G50 F50 E80 G80 F80 4,369,805 98,489 0 4,090,115 17,680 0 0 0 0 0 0 0 1,314,798 32,393 0 0 0 0 2,347, 598 66,844 0 0 0 0 2,547, 051 21,698 0 0 0 0 0 0 406,401 1,279 0 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 Continued on next page Page 11 FORM F- 66(IA -2) (4 -20 -2011) Part 11 EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2011 - Continued CITY OF DUBUQUE GAAP X NON -GAAP = CASH BASIS 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 (0) (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 671,647 E89 671,647 238 239 Purchase of land and equipment G89 0 239 240 Construction F89 0 240 241 241 242 Enterprise Debt Service 5,052,477 5,052,477 242 243 Enterprise Capital Projects 48,578,744 48,578,744 243 244 Enterprise TIF Capital Projects 0 244 245 Internal service funds — Specify 245 246 Enginering 1,682,392 1,682,392 246 247 Garage 2,037,098 2,037,098 247 248 Stores & General 21,135 21,135 248 249 0 249 250 0 . 250 251 TOTAL BUSINESS TYPE ACTIVITIES 73,357,644 73,357,644 251 252 ;:...... 252 ■ 253 TOTAL EXPENDITURES (Sum of lines 194 and 251) 55,941,2401 14 917 1571 7,436,1561 1,947,0861 15,240,502] 9,5031 95,491,644 73,357,644 168,849,288 253 254 Section J — OTHER FINANCING USES INCLUDING TRANSFERS OUT �....... :: .. NE . • 254 255 255 Regular transfers out 10,691,120 3,640,045 : . 15,571,696 1,001,561 30,904,422 4,661,261 35,565,683 256 Internal TIF loans /repayments and transfers out 2,456,277 100,000 2,556,277 2,556,277 256 257 0 0 257 258 TOTAL OTHER FINANCING USES 10,691,120 3,640,045 2,456,277 15,571,696 1,101,561 0 33,460,699 4,661,261 38,121,960 258 259 TOTAL EXPENDITURES AND OTHER FINANCING USES (Sum of lines 253 and 258) 66,632,360 18,557202 9,892,433 17,518,782 16,342063 9,503 128,952,343_ 78,018,905 _ 206,971,248 259 260 260 261 Ending fund balance June 30, 2011: 261 262 Governmental: 262 263 Nonspendable 23,514 23,514 23,514 263 264 Restricted 3,090,396 3,014,599 112,131 33,250 6,250,376 6,250,376 264 265 Committed 5,421,098 5,421098 5,421,098 265 266 Assigned 13,421,447 8,741,942 22,163,389 22,163,389 266 267 Unassigned 148,599 148,599 148,599 267 268 Total Governmental 13,570,046 3,090,396 3,014,599 112,131 14,163,040 56,764 34,006,976 34,006,976 268 269 Proprietary 13,914,820 13,914,820 269 270 Total ending fund balance June 30, 2011 13,570,046 3,090,396 3,014,599 112,131 14,163,040 56,764 34,006,976 13,914,820 47,921,796 270 271 TOTAL REQUIREMENTS (Sum of lines 259 and 270) 80,202,406 21,647,598 12,907,032_ 17,630,913 30,505,103 66,267 162,959,319 91,933,725 254,893,044 271 272 272 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 0. Enter 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 security, retirement, etc. Include 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.. .. .... ....... ...... ... ... ...... Amount - omit cents Z00 $ 38,512,243 Part V DEBT OUTSTANDING, ISSUED, AND RETIRED A. Long -term debt Purpose Debt outstanding JULY 1, 2010 (a) Debt during the fiscal year Debt Outstanding JUNE 30, 2011 Interest paid this year (8) Issued (b) Retired (c) General obligation (d) TIF revenue (e) Revenue (1) Other (g) 1. Water utility 19U $ 1,125,000 29U $ 5,700 000 39U $ 70,000 49U $ 49U $ 49U $ 6,755,000 49U $ 191 $ 181,743 2. Sewer utlllty 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 738 911 29U 360 700 39U 900,371 49U 49U 25,199,240 49U 49U 189 1,936,875 Other - Specify 9. 19U 29U 39U 49U 49U 49U 49U 189 GO Corp 10 Purpose 19U 51,765,000 29U 9,970,000 39U 3,960,000 49U 57,775,000 49U 49U 49U 189 2,373,711 SRF 11. 19U 8,289,621 29U 25,043,787 39U 168,000 49U 49U 49U 33,165,408 49U 189 672,706 Dbq Initiative 12. 19U 371 978 29U 39U 19,869 49U 49U 49U 49U 352,109 189 18,354 US Bank 13. 19U 29U 2 850 000 39U 950,000 49U 49U 49U 49U 1,900,000 189 29,450 IDOT 14. 19U 282,857 29U 39U 49U 49U 49U 49U 282,857 189 Total long -term debt 87 573,367 43 924 487 6 068 240 57 775,000 25 199 240 39 920,408 2,534,966 5,212,839 B. Short-term debt Outstanding as of JULY 1, 2010 Outstanding as of JUNE 30, 2011 Amount - Omit cents 61V $ 0 64V $ 0 Part VI DEBT LIMITATION FOR GENERAL OBLIGATION BONDS Valuation WEBSITE. 100'% VAL BY INDIVIDUAL LEVY AUTHORITY Actual valuation -- January 1, 2009 Amount - Omrt cents Click to visit DOM $ 3,483,122,368 x .05 = $ 174,156,118 Part VII CASH AND INVESTMENT ASSETS AS OF JUNE 30, 2011 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 (e) 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 other securities Exclude value of real property. W0i W31 W61 $ $ 10,503,554 51,687,056 YL 19C,..-AU REMARKS V98 Total other debt differs from Outstanding Debt Report 8/1/2011 IDOT debt reported as $188,571 in error. Actual balance Is $282,857 To be corrected on FY12 OSD report SRF loan new debt includes $727,350 administation fees that have no offsetting bond proceeds, $472,806 received in FY10 not listed as it was part of the $1 million forgivable transfer from bond proceeds to grant revenue In FY11 Debt Service Expense exceeded budget by $565,455 due current refunding $690,000 of Series 2002B bonds. ERROR MESSAGE Ending fund balance plus internal service funds and agency funds does not equal total cash and investments. The difference $1,491,258 represents payroll] liabilities accrued at fiscal year end The City of Dubuque makes a year end computation to expense payroll attributed to current ficscal year, but paid in next fiscal year Payroll expense is debited lowering fund balance and payroll liability credited No offsetting cash transaction. This Is the only year end accrual for the City. It has been an ongoing process for the City and is part of our annual budgeting procedure. This has been discussed with Susan Battani AFR report 2008 FORM F- 66(IA -2) (4- 242011) Page 13