Loading...
Fiscal Year 2020 Annual Financial ReportCity of Dubuque City Council Meeting Consent Items # 19. Copyrighted October 19, 2020 ITEM TITLE: Fiscal Year 2020 Annual Financial Report SUMMARY: City Manager recommending approval to file the Fiscal Year2020 State of Iowa Annual Financial Report with the State of Iowa Auditor. SUGGESTED Suggested Disposition: Receive and File; Approve DISPOSITION: ATTACHMENTS: Description Type MVM Memo City Manager Memo Staff Memo Staff Memo FY20 AFR Supporting Documentation FY20 AFR Signature Page Supporting Documentation FY20 AFR Newspaper Notice Supporting Documentation Masterpiece on the Mississippi TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2020 State of Iowa Annual Financial Report DATE: October 12, 2020 Dubuque bend III -America City 11111 r 2007-2012.2013 2017*2019 Director of Finance and Budget Jennifer Larson is recommending approval to file the Fiscal Year 2020 State of Iowa Annual Financial Report with the State of Iowa Auditor. I concur with the recommendation and respectfully request Mayor and City Council approval. Michael C. Van Milligen MCVM/jml Attachment cc: Crenna Brumwell, City Attorney Cori Burbach, Assistant City Manager Jennifer Larson, Director of Finance and Budget Cassie Ross, Assistant Director of Finance Masterpiece on the Mississippi TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Director of Finance and Budget SUBJECT: Fiscal Year 2020 State of Iowa Annual Financial Report DATE: October 12, 2020 INTRODUCTION Dubuque treed III -America City 111111 2007.2012.2013 2017*2019 The purpose of this memorandum is to submit the Fiscal Year 2020 State of Iowa Annual Financial Report. BACKGROUND The Annual Financial Report must be filed with State of Iowa Auditor pursuant to the Code of Iowa Section 384.22 by December 1, 2020. DISCUSSION The Annual Financial Report 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 after City Council approval. There is no statutory requirement for the City Council to approve the Annual Financial Report or pass a resolution prior to publication and filing. However, when possible, City Council review and approval of the official document is recommended. REQUEST I respectfully recommend approval to file the Fiscal Year 2020 State of Iowa Annual Financial Report with the State of Iowa Auditor. JML STATE OF IOWA 2020 FINANCIAL REPORT FISCAL YEAR ENDED DUNE 30, 2020 CITY OF DUBUQUE, IOWA DUE: December 1, 2020 16203100700000 CITY OF DUBUQUE 50 W 13th Street DUBUQUE IA 52001-4864 POPULATION: 57637 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 Governmental (a) Proprietary (b) Total Actual (c) Budget (d) Revenues and Other Financing Sources Taxes Levied on Property 25,907,300 25,907,300 26,305,451 Less: Uncollected Property Taxes -Levy Year 0 0 0 Net Current Property Taxes 25,907,300 25,907,300 26,305,451 Delinquent Property Taxes 920 920 0 TIF Revenues 9,959,562 9,959,562 10,738,108 Other City Taxes 17,995,431 0 17,995,431 18,167,857 Licenses and Permits 1,466,337 36,915 1,503,252 1,904,123 Use of Money and Property 13,963,472 511,296 14,474,768 14,391,312 Intergovernmental 37,824,568 2,545,052 40,369,620 100,118,847 Charges for Fees and Service 5,647,359 33,528,171 39,175,530 43,900,588 Special Assessments 113,709 0 113,709 30,000 Miscellaneous 3,764,602 5,132,032 8,896,634 11,461,791 Other Financing Sources 26,463,979 18,929,273 45,393,252 38,221,185 Transfers In 24,197,239 5,534,144 29,731,383 36,016,027 Total Revenues and Other Sources 143,107,239 60,682,739 203,789,978 301,255,289 Expenditures and Other Financing Uses Public Safety 29,268,525 29,268,525 30,915,634 Public Works 12,307,869 12,307,869 14,384,293 Health and Social Services 970,434 970,434 1,313,039 Culture and Recreation 12,316,173 12,316,173 13,840,099 Community and Economic Development 14,432,317 14,432,317 15,029,497 General Government 10,013,656 10,013,656 10,694,999 Debt Service 12,165,590 12,165,590 12,233,320 Capital Projects 28,946,802 28,946,802 89,270,227 Total Governmental Activities Expenditures 120,421,366 0 120,421,366 187,681,108 BUSINESS TYPE ACTIVITIES 54,048,579 54,048,579 95,000,608 Total All Expenditures 120,421,366 54,048,579 174,469,945 282,681,716 Other Financing Uses 23,705,981 6,025,402 29,731,383 Transfers Out 23,705,981 6,025,402 29,731,383 36,016,027 Total All Expenditures/and Other Financing Uses 144,127,347 60,073,981 204,201,328 318,697,743 Excess Revenues and Other Sources Over (Under) Expenditures/and Other Financing Uses -1,020,108 608,758 -411,350 -17,442,454 Beginning Fund Balance July 1, 2019 56,906,271 23,976,359 80,882,630 82,384,365 Ending Fund Balance June 30, 2020 55,886,163 24,585,117 80,471,280 64,941,911 NOTE - These balances do not include the following, which were not budgeted and are not available for city operations: Non -budgeted Internal Service Funds 6,909,377 Pension Trust Funds Private Purpose Trust Funds Agency Funds 15,210,269 Indebtedness at June 30, 2020 Amount Indebtedness at June 30, 2020 Amount General Obligation Debt 76,664,999 Other Long -Term Debt 6,051,626 Revenue Debt 149,120,645 Short -Term Debt 0 TIF Revenue Debt 19,076,860 General Obligation Debt Limit 227,664,182 CERTIFICATION The forgoing report is correct to the best of my knowledge and belief 4'----/-''',X----- Publication 10/21/2020 Signature of Preparer Printed name of Preparer Jennifer Larson Phone Number 5635894322 / Roy D. Btiol, Mayor Date Signed 10/19 /20 REVENUE P2 CITY OF DUBUQUE REVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2020 NON-GAAP/CASH BASIS Item Description General (a) Special Revenue (b) TIF Special Revenue (c) Debt Service (d) Capital Projects (e) Permanent (f) Total Governmental (Sum of (a) through (f)) (g) Proprietary (h) Grand Total (Sum of (g) and (h)) (i) Section A - Taxes 1 1 Taxes levied on property 2 22,171,348 3,469,746 266,206 25,907,300 25,907,300 2 Less: Uncollected Property Taxes - Levy Year 3 0 0 3 Net Current Property Taxes 4 22,171,348 3,469,746 266,206 0 0 25,907,300 25,907,300 4 Delinquent Property Taxes 5 783 123 14 920 920 5 Total Property Tax 6 22,172,131 3,469,869 266,220 0 0 25,908,220 25,908,220 6 TIF Revenues 7 9,959,562 9,959,562 9,959,562 7 Other City Taxes Utility Tax Replacement Excise Taxes 8 0 0 8 Utility Franchise Tax (Chapter 364.2, Code of Iowa) 9 5,007,413 573,297 5,580,710 5,580,710 9 Parimutuel Wager Tax 10 21,304 21,304 21,304 10 Gaming Wager Tax 11 476,913 476,913 476,913 11 Mobile Home Tax 12 45,042 7,073 471 52,586 52,586 12 Hotel / Motel Tax 13 2,262,630 2,262,630 2,262,630 13 Other Local Option Taxes 14 4,800,644 4,800,644 9,601,288 9,601,288 14 Total Other City Taxes 15 12,613,946 580,370 471 4,800,644 0 17,995,431 0 17,995,431 15 Section B - Licenses and Permits 16 1,466,337 1,466,337 36,915 1,503,252 16 Section C - Use of Money and Property 17 17 Interest 18 12,224,877 134,500 273,411 379,311 6,148 13,018,247 483,841 13,502,088 18 Rents and Royalties 19 750 18,720 19,470 27,455 46,925 19 Other Miscellaneous Use of Money and Property 20 704,915 220,840 925,755 925,755 20 21 0 0 21 Total Use of Money and Property 22 12,224,877 840,165 273,411 0 618,871 6,148 13,963,472 511,296 14,474,768 22 Section D - Intergovernmental 24 24 Federal Grants and Reimbursements 26 26 Federal Grants 27 504,965 11,844,182 1,693,797 14,042,944 2,151,576 16,194,520 27 Community Development Block Grants 28 1,382,353 1,382,353 1,382,353 28 Housing and Urban Development 29 6,017,700 6,017,700 6,017,700 29 Public Assistance Grants 30 0 0 30 Payment in Lieu of Taxes 31 0 0 31 32 0 0 32 Total Federal Grants and Reimbursements 33 504,965 19,244,235 0 1,693,797 0 21,442,997 2,151,576 23,594,573 33 REVENUE P3 CITY OF DUBUQUE REVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2020 NON-GAAP/CASH BASIS Item Description General (a) Special Revenue (b) TIF Special Revenue (c) Debt Service (d) Capital Projects (e) Permanent (f) Total Governmental (Sum of (a) through (f)) (g) Proprietary (h) Grand Total (Sum of (g) and (h)) (i) Section D - Intergovernmental - Continued 41 41 State Shared Revenues 43 43 Road Use Taxes 44 7,408,566 7,408,566 7,408,566 44 Other state grants and reimbursements 48 48 State grants 49 525,188 106,583 4,709,559 5,341,330 1,700 5,343,030 49 Iowa Department of Transportation 50 142,803 142,803 333,988 476,791 50 Iowa Department of Natural Resources 51 0 0 51 Iowa Economic Development Authority 52 0 0 52 CEBA grants 53 0 0 53 Commercial &Industrial Replacement Claim 54 830,772 129,965 411,380 10,099 1,382,216 1,382,216 54 Military Credit 55 1,325 90 1,415 1,415 55 56 0 0 56 57 0 0 57 58 0 0 58 59 0 0 59 Total State 60 1,355,960 7,646,439 411,380 10,189 4,852,362 0 14,276,330 335,688 14,612,018 60 Local Grants and Reimbursements County Contributions 63 555,163 555,163 57,788 612,951 63 Library Service 64 0 0 64 Township Contributions 65 0 0 65 Fire/EMT Service 66 303,806 175,112 478,918 478,918 66 Landfill 67 387,593 387,593 387,593 67 Agency Escrow Disbursement 68 683,567 683,567 683,567 68 69 0 0 69 Total Local Grants and Reimbursements 70 1,246,562 0 683,567 0 175,112 0 2,105,241 57,788 2,163,029 70 Total Intergovernmental (Sum of lines 33, 60, and 70) 71 3,107,487 26,890,674 1,094,947 10,189 6,721,271 0 37,824,568 2,545,052 40,369,620 71 Section E -Charges for Fees and Service 72 72 Water 73 0 8,930,249 8,930,249 73 Sewer 74 9,899 9,899 12,527,870 12,537,769 74 Electric 75 0 0 75 Gas 76 0 0 76 Parking 77 360 360 2,131,270 2,131,630 77 Airport 78 2,580,668 46,569 122,690 2,749,927 2,749,927 78 Landfill/garbage 79 0 4,378,362 4,378,362 79 Hospital 80 0 0 80 REVENUE P4 CITY OF REVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, NON-GAAP/CASH BASIS Item Description General (a) Special Revenue (b) TIF Special Revenue (c) Debt Service (d) Capital Projects (e) Permanent (f) Total Governmental (Sum of (a) through (f)) (g) Proprietary (h) Grand Total (Sum of (g) and (h)) (i) Section E - Charges for Fees and Service - Continued 81 81 Transit 82 0 337,269 337,269 82 Cable TV 83 0 0 83 Internet 84 0 0 84 Telephone 85 0 0 85 Housing Authority 86 0 0 86 Storm Water 87 0 4,876,223 4,876,223 87 Other: 88 88 Nursing Home 89 0 0 89 Police Service Fees 90 32,290 32,290 32,290 90 Prisoner Care 91 0 0 91 Fire Service Charges 92 0 0 92 Ambulance Charges 93 1,395,218 1,395,218 1,395,218 93 Sidewalk Street Repair Charges 94 27,972 1,255 29,227 29,227 94 Housing and Urban Renewal Charges 95 98,394 98,394 98,394 95 River Port and Terminal Fees 96 211.083 211,083 346,753 557,836 96 Public Scales 97 0 0 97 Cemetery Charges 98 0 0 98 Library Charges 99 25,962 25,962 25,962 99 Park, Recreation, and Cultural Charges 100 1,070,685 9,096 1,079,781 175 1,079,956 100 Animal Control Charges 101 0 0 101 Copies 102 11,792 11,792 11,792 102 Weed/Snow Nuisance 103 3,426 3,426 3,426 103 Total Charges for Service 104 5,256,666 268,003 0 0 122,690 0 5,647,359 33,528,171 39,175,530 104 Section F - Special Assesments 106 113,709 113,709 113,709 106 Section G - Miscellaneous 107 107 Contributions 108 722,160 24,580 175,675 2,684 158 925,257 180,146 1,105,403 108 Deposits and Sales/Fuel Tax Refunds 109 103,217 106,327 2,197 211,741 80,251 291,992 109 Sale of Property and Merchandise 110 0 0 110 Fines 111 362,018 362,018 198,506 560,524 111 Internal Service Charges 112 782,514 782,514 3,545,661 4,328,175 112 Misc Charges, Damage Claims, 113 796,361 129,983 4,805 551,923 1,483,072 1,127,468 2,610,540 113 114 0 0 114 115 0 0 115 116 0 0 116 117 0 0 117 118 0 0 118 119 0 0 119 Total Miscellaneous 120 2,766,270 260,890 180,480 0 556,804 158 3,764,602 5,132,032 8,896,634 120 REVENUE P5 CITY OF REVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, NON-GAAP/CASH BASIS Item Description General (a) Special Revenue (b) TIF Special Revenue (c) Debt Service (d) Capital Projects (e) Permanent (f) Total Governmental (Sum of (a) through (f)) (g) Proprietary (h) Grand Total (Sum of (g) and (h)) (i) Total All Revenues (Sum of lines 6, 7, 15,16,22, 71, 104, 106, and 120) 121 59,607,714 32,423,680 11,508,400 276,880 12,820,280 6,306 116,643,260 41,753,466 158,396,726 121 Section H - Other Financing Sources 123 123 Proceeds of capital asset sales 124 53,048 149,106 609,241 3,000 814,395 4,966 819,361 124 Proceeds of long-term debt (Excluding TIF internal borrowing) 125 31,678 1,420,667 1,452,345 13,390,163 14,842,508 125 Proceeds of anticipatory warrants or other short- term debt 126 0 0 126 Regular transfers in and interfund loans 127 9,363,438 141,821 4,720,847 1,279,064 15,505,170 4,177,307 19,682,477 127 Internal TIF loans and transfers in 128 533,960 150,000 5,737,229 2,270,880 8,692,069 1,356,837 10,048,906 128 129 0 0 129 130 0 0 130 Total Other Financing Sources 131 9,982,124 440,927 609,241 11,878,743 3,552,944 0 26,463,979 18,929,273 45,393,252 131 Total Revenues Except for Beginning Balances (Sum of lines 121 and 131) 132 69,589,838 32,864,607 12,117,641 12,155,623 16,373,224 6,306 143,107,239 60,682,739 203,789,978 132 Beginning Fund Balance July 1, 2019 134 19,539,251 7,844,454 8,193,618 9,967 21,228,304 90,677 56,906,271 23,976,359 80,882,630 134 Total Revenues and Other Financing Sources (Sum of lines 132 and 134) 136 89,129,089 40,709,061 20,311,259 12,165,590 37,601,528 96,983 200,013,510 84,659,098 284,672,608 136 EXPENDITURES P6 CITY OF DUBUQUE EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2020 NON-GAAP/CASH BASIS Item Description Line General (a) Special Revenue (b) TIF Special Revenue (c) Debt Service (d) Capital Projects (e) Permanent (0through ( Total Governmental (Sum of cols. (a) (0) (g) Proprietary (h) Grand Total (Sum of col. (g)) (i) Line Section A - Public Safety 1 1 Police Depaitnient/Crime Prevention 2 15,085,305 3,102 15,088,407 15,088,407 2 Jail 3 0 0 3 Emergency Management 4 1,598,546 1,598,546 1,598,546 4 Flood control 5 247,654 247,654 247,654 5 Fire Department 6 9,269,476 9,269,476 9,269,476 6 Ambulance 7 1,955,393 1,955,393 1,955,393 7 Building Inspections 8 747,180 747,180 747,180 8 Miscellaneous Protective Services 9 0 0 9 Animal Control 10 361,869 361,869 361,869 10 Other Public Safety 11 0 0 11 12 0 0 12 13 0 0 13 Total Public Safety 14 29,265,423 3,102 0 0 0 29,268,525 29,268,525 14 Section B - Public Works 15 15 Roads, Bridges, Sidewalks 16 1,226,170 3,554,627 4,780,797 4,780,797 16 Parking Meter and Off -Street 17 0 0 17 Street Lighting 18 311,847 814,957 1,126,804 1,126,804 18 Traffic Control Safety 19 118,129 12,000 130,129 130,129 19 Snow Removal 20 1,350,736 1,350,736 1,350,736 20 Highway Engineering 21 0 0 21 Street Cleaning 22 653,080 653,080 653,080 22 Airport (if not an enterprise) 23 3,875,243 3,875,243 3,875,243 23 Garbage (if not an enterprise) 24 0 0 24 Other Public Works 25 391,080 391,080 391,080 25 26 0 0 26 27 0 0 27 Total Public Works 28 5,922,469 6,385,400 0 0 0 12,307,869 12,307,869 28 Section C - Health and Social Services 29 29 Welfare Assistance 30 0 0 30 City Hospital 31 0 0 31 Payments to Private Hospitals 32 0 0 32 Health Regulation and Inspections 33 368,147 35,878 404,025 404,025 33 Water, Air, and Mosquito Control 34 0 0 34 Community Mental Health 35 0 0 35 Other Health and Social Services 36 528,653 528,653 528,653 36 Social Services Grants 37 37,756 37,756 37,756 37 38 0 0 38 Total Health and Social Services 39 896,800 73,634 0 0 0 970,434 970,434 39 Section D - Culture and Recreation 40 40 Library Services 41 3,352,167 138,749 1,760 3,492,676 3,492,676 41 Museum, Band, Theater 42 0 0 42 Parks 43 3,227,967 2,030 3,229,997 3,229,997 43 Recreation 44 3,207,213 110,146 3,317,359 3,317,359 44 Cemetery 45 0 0 45 Community Center, Zoo, Marina, and Auditorium 46 1,922,485 1,922,485 1,922,485 46 Other Culture and Recreation 47 353,656 353,656 353,656 47 48 0 0 48 49 0 0 49 Total Culture and Recreation 50 12,063,488 250,925 0 0 1,760 12,316,173 12,316,173 50 EXPENDITURES P7 CITY OF EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, -- Cont.nued NON-GAAP/CASH BASIS Item description Line 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) Grand Total (Sum of col. (g)) (i) Line Section E — Community and Economic Development 51 51 Community beautification 52 57,392 95,157 152,549 152,549 52 Economic development 53 2,154,611 317,686 2,472,297 2,472,297 53 Housing and urban renewal 54 1,312,574 7.095,022 8,407,596 8,407,596 54 Planning and zoning 55 945,420 945,420 945,420 55 Other community and economic development 56 0 0 56 TIF Rebates 57 2,454,455 2,454,455 2,454,455 57 58 0 0 58 Total Community and Economic Development 59 4,469,997 7,190,179 2,772,141 0 0 0 14,432,317 14,432,317 59 Section F — General Government 60 60 Mayor, Council and City Manager 61 2,502,328 344,199 2,846,527 2,846,527 61 Clerk, Treasurer, Financial Administration 62 3,582,200 3,582,200 3,582,200 62 Elections 63 0 0 63 Legal Services and City Attorney 64 1,073,134 1,073,134 1,073,134 64 City Hall and General Buildings 65 866,433 866,433 866,433 65 Tort Liability 66 0 0 66 Other General Government 67 1,381,540 263,822 1,645,362 1,645,362 67 68 0 0 68 69 0 0 69 Total General Government 70 9,405,635 608,021 0 0 0 10,013,656 10,013,656 70 SectionG — Debt Service 71 12,165,590 12,165,590 12,165,590 71 72 0 0 72 73 0 0 73 Total Debt Service 74 0 0 0 12,165,590 0 0 12,165,590 12,165,590 74 Section H — Regular Capital Projects — Specify 75 75 Government Capital Projects 76 2,028,928 12,694,225 8,723,516 23,446,669 23,446,669 76 77 0 0 77 Subtotal Regular Capital Projects 78 2,028,928 12,694,225 0 8,723,516 0 23,446,669 23,446,669 78 TIF Capital Projects — Specify 79 79 TIF Capital Projects 80 5,500,133 5,500,133 5,500,133 80 81 0 0 81 Subtotal TIF Capital Projects 82 0 0 0 5,500,133 0 5,500,133 5,500,133 82 Total Capital Projects 83 2,028,928 12,694,225 0 14,223,649 0 28,946,802 28,946,802 83 Total Governmental Activities Expenditures 84 64,052,740 27,205,486 2,772,141 12,165,590 14,223,649 1,760 120,421,366 120,421,366 84 (Sum of lines 14, 28, 39, 50, 59, 70, 74, 83) 85 85 TIF Rebates are expended out of the TIF Special Revenue Fund within the Community and Economic Development program's actin ty "Other" EXPENDITURES P8 CITY OF EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, -- Continued NON-GAAP/CASH BASIS Item description Line General (a) Special Revenue (b) TIF Special Revenue (c) Debt Service (d) Capital Projects (e) Permanent (0through Total Governmental (Sum of cols. (a) (I)) (g) Proprietary (h) Grand Total (Sum of col. (g)) (i) Line Section I — Business Type Activities 87 87 Water —Current Operation 88 5,351,051 5,351,051 88 Capital Outlay 89 3,240,542 3,240,542 89 Debt Service 90 4,970,399 4,970,399 90 Sewer and Sewage Disposal — Current Operation 91 5,560,625 5,560,625 91 Capital Outlay 92 2,605,960 2,605,960 92 Debt Service 93 6,402,886 6,402,886 93 Electric — Current Operation 94 0 94 Capital Outlay 95 0 95 Debt Service 96 0 96 Gas Utility — Current Operation 97 0 97 Capital Outlay 98 0 98 Debt Service 99 0 99 Parking — Current Operation 100 1,673,346 1,673,346 100 Capital Outlay 101 90,136 90,136 101 Debt Service 102 1,479,507 1,479,507 102 Airport — Current Operation 103 0 103 Capital Outlay 104 0 104 Debt Service 105 0 105 Landfill/Garbage — Current operation 106 3,052,621 3,052,621 106 Capital Outlay 107 3,831 3,831 107 Debt Service 108 7,286 7,286 108 Hospital — Current Operation 109 0 109 Capital Outlay 110 0 110 Debt Service 111 0 111 Transit— Current Operation 112 3,804,027 3,804,027 112 Capital Outlay 113 239,768 239,768 113 Debt Service 114 0 114 Cable TV, Telephone, Internet — Current Operation 115 0 115 Capital Outlay 116 0 116 Housing Authority — Current Operation 117 0 117 Capital Outlay 118 0 118 Debt Service 119 0 119 Storm Water Current Operation 120 1,547,059 1,547,059 120 Capital Outlay 121 8,197,431 8,197,431 121 Debt Service 122 2,207,270 2,207,270 122 Other Business Type — Current Operation 123 305,918 305,918 123 Capital Outlay 124 3,161 3,161 124 Debt Service 125 0 125 Internal Service Funds — Specify 126 126 Engineering/Stores/Central Printing 127 3,291,495 3,291,495 127 Garage Capital 128 14,260 14,260 128 Total Business Type Activities 129 54,048,579 54,048,579 129 EXPENDITURES P9 CITY OF DUBUQUE EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2020 -- Continued NON-GAAP/CASH BASIS Item description Line 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) Grand Total (Sum of col. (g)) (i) Line Subtotal Expenditures (Sum of lines 84 and 129) 130 64,052,740 27,205,486 2,772,141 12,165,590 14,223,649 1,760 120,421,366 54,048,579 174,469,945 130 Section J — Other Financing Uses Including Transfers Out 131 131 Regular transfers out 132 5,262,664 4,205,841 4,188,570 13,657,075 6,025,402 19,682,477 132 Internal TIF loans/repayments and transfers out 133 10,048,906 10,048,906 10,048,906 133 134 0 0 134 Total Other Financing Uses 135 5,262,664 4,205,841 10,048,906 0 4,188,570 0 23,705,981 6,025,402 29,731,383 135 Total Expenditures and Other Financing Uses (Sum of lines 130 and 135) 136 69,315,404 31,411,327 12,821,047 12,165,590 18,412,219 1,760 144,127,347 60,073,981 204,201,328 136 137 137 Ending fund balance June 30, : 138 138 Governmental: 139 139 Nonspendable 140 95,223 95,223 95,223 140 Restricted 141 9,297,734 7,490,212 2,080,000 18,867,946 18,867,946 141 Committed 142 4,977,666 17,109,309 22,086,975 22,086,975 142 Assigned 143 1,000 1,000 1,000 143 Unassigned 144 14,835,019 14,835,019 14,835,019 144 Total Governmental 145 19,813,685 9,297,734 7,490,212 0 19,189,309 95,223 55,886,163 55,886,163 145 Proprietary 146 24,585,117 24,585,117 146 Total Ending Fund Balance June 30, 147 19,813,685 9,297,734 7,490,212 0 19,189,309 95,223 55,886,163 24,585,117 80,471,280 147 Total Requirements (Sum of lines 136 and 147) 148 89,129,089 40,709,061 20,311,259 12,165,590 37,601,528 96,983 200,013,510 84,659,098 284,672,608 148 OTHER P10 Part III Intergovernmental Expenditures Please repo below expenditures made to the State or to other local governments on a reimbursement or cost sharing basis. Include these expenditures in part II. Enter amount. Purpose Amount paid to other local governments Purpose Amount paid to State Correction Highways Health All other Highways Transit Subsidies Libraries Police protection Sewerage Sanitation All other Part IV Wages & Salaries 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. YOU ARE REQUIRED TO ENTER SALARY DOLLARS IN THE Amount areas FOR SALARIES AND WAGES PAID Amount Total Salaries and Wages Paid 44.396.588 Part V Debt Outstanding, Issued, and Retired Transit subsidies A. Long -Term Debt Debt During the Fiscal Year Debt Outstanding JUNE 30, 2020 Purpose Line Debt Outstanding JULY 1, 2019 Issued Retired General Obligation TIF Revenue Revenue Other Interest Paid This Year Water Utility 1. 27,069,500 4,844,418 4,131,165 11,438,806 14,343,947 2,000,000 839,235 Sewer Utility 2. 77,247,256 2,028,430 4,729,711 9,747,334 64,798,641 1,673,174 Electric Utility 3. Gas Utili y 4. Transit -Bus 5. 3,433,499 237,218 3,196,281 86,829 Industrial Revenue 6. Mortgage Revenue 7. TIF Revenue 8. 50,251,541 305,629 3,505,751 24,040,448 19,076,860 600,000 2,298,678 Other Purposes / Miscellaneous 9. 70,646 5,222 65,424 2,064 GO 10. 12,525,108 1,067,277 2,567,022 11,060,179 3,299,295 459,645 Parking 11. 7,212,547 126.133 1,273,733 5,912,616 152.331 205,774 Airport 12. 3,111,384 261,043 2,850,341 95,372 Stormwater 13. 74,766,602 6,346,265 2,781,240 8,353,570 69,978,057 2,068,117 Section 108 14. Total Long -Term 255,688,083 14,718,152 19,492,105 76,664,999 19,076,860 149,120,645 6.051.626 7,728,888 B. Short -Term Debt Amount Outstanding as of July 1, 2019 Outstanding as of JUNE 30, 2020 DEBT LIMITATION FOR GENERAL OBLIGATIONS Part VI Actual valuation -- January 1, 2018 Part VII CASH AND INVESTMENT ASSETS AS OF JUNE 30, 2020 Type of asset 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. REMARKS 4,553,283,653 Amount Amount x.0.5 = $ 227,664,182.65 Bond and interest Bond construction Pension/retirement All other Funds Total (e) funds (a) funds (b) funds (c) (d) 6 828 682 98 392 871 105 221 553 If you budget on a NON-GAAP CASH BASIS, the amount in the Total above SHOULD EQUAL the above summed amounts on the sheet All Funds P 1: Ending fund balance, column C PLUS the amounts in the shaded Note area. STATE OF IOWA 2020 FINANCIAL REPORT FISCAL YEAR ENDED JUNE 30, 2020 CITY OF DUBUQUE, IOWA DUE: December 1, 2020 16203100700000 CITY OF DUBUQUE 50 W 13th Street DUBUQUE IA 52001-4864 POPULATION: 57637 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 Governmental (a) Proprietary (b) Total Actual (c) Budget (d) Revenues and Other Financing Sources Taxes Levied on Property 25907300 25,907,300 26,305,451 Less: Uncollected Property Taxes -Levy Year 0 0 0 Net Current Property Taxes 25,907,300 25,907,300 26,305,451 Delinquent Property Taxes 920 920 0 TIF Revenues 9,959,562 9,959,562 10,738,108 Other City Taxes 17,995,431 0 17,995,431 18,167,857 Licenses and Permits 1,466,337 36,915 1,503,252 1,904,123 Use of Money and Property 13,963,472 511,296 14,474,768 14,391,312 Intergovernmental 37,824,568 2,545,052 40,369,620 100,118,847 Charges for Fees and Service 5,647,359 33,528,171 39,175,530 43,900,588 Special Assessments 113,709 0 113,709 30,000 Miscellaneous 3,764,602 5,132,032 8,896,634 11,461,791 Other Financing Sources, Including Transfers in 26,463,979 18,929,273 45,393,252 74,237,212 Total Revenues and Other Sources 143,107,239 60,682,739 203,789,978 301,255,289 Expenditures and Other Financing Uses Public Safety 29,268,525 29,268,525 30,915,634 Public Works 12,307,869 12,307,869 14,384,293 Health and Social Services 970,434 970,434 1,313,039 Culture and Recreation 12,316,173 12,316,173 13,840,099 Community and Economic Development 14,432,317 14,432,317 15,029,497 General Government 10,013,656 10,013,656 10,694,999 Debt Service 12,165,590 12,165,590 12,233,320 Capital Projects 28,946,802 28,946,802 89,270,227 Total Governmental Activities Expenditures 120,421,366 0 120,421,366 187,681,108 Business type activities 54,048,579 54,048,579 95,000,608 Total All Expenditures 120,421,366 54,048,579 174,469,945 282,681,716 Other Financing Uses, Including Transfers Out 23,705,981 6,025,402 29,731,383 36,016,027 Total All Expenditures/and Other Financing Uses 144,127,347 60,073,981 204,201,328 318,697,743 Excess Revenues and Other Sources Over (Under) Expenditures/and Other Financing Uses -1,020,108 608,758 -411,350 -17,442,454 Beginning Fund Balance July 1, 2019 56,906,271 23,976,359 80,882,630 82,384,365 Ending Fund Balance June 30, 2020 55,886,163 24,585,117 80,471,280 64,941,911 NOTE - These balances do not include the following, which were not budgeted and are not available for city operations: Non -budgeted Internal Service Funds 6,909,377 Pension Trust Funds Private Purpose Trust Funds Agency Funds 15,210,269 Indebtedness at June 30, 2020 Amount Indebtedness at June 30, 2020 Amount General Obligation Debt 76,664,999 Other Long -Term Debt 6,051,626 Revenue Debt 149,120,645 Short -Term Debt 0 TIF Revenue Debt 19,076,860 General Obligation Debt Limit 227,664,182 STATE OF IOWA SS: DUBUQUE COUNTY CERTIFICATE OF PUBLICATION I, Kathy Goetzinger, 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: ' 10/21/2020 and for which the charge is 146.75 STbscribed to before me, Notary Public i( ad for Dubuque County, Iowa, this 21 st day of October, 2020 _ ---- Nota blic in and for Dubuque ounty, Iowa. Comnmissim Number 199959 Wy Comm. Exp, DEC 11, 2622