Loading...
Information 08-16-2021Information City E Memorandum TO: Mayor and City Council From: Lori Stich, Assistant Finance Director Date: August 16, 2021 Subject: July 2021 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund, the Multipurpose Facility Special Revenue Fund, and the Enterprise Funds. These funds provide an important picture of the city's financial health. For the month of July, actual revenues (excluding property taxes and transfers in) and expenditures should run about 58% of the annual budget. It is natural for some of the items to vary from month to month, such as exceeding budget for Supplies but being below budget for Services. This is not considered serious as long as the total expenditure budget amount is not overspent. Significant variances from budget are highlighted below accompanied with a general discussion for the variance. GENERAL FUND Revenues: ■ July revenue collections include the remaining first half property tax settlement. ■ License & permit collections are about 97% of budget estimates with July collections consisting primarily of building -related permits. ■ Intergovernmental revenues for July include the second quarter law enforcement grant which is distributed to the participating agencies. Elk River's share of the grant is $6,904. ■ Charges for services are about 93% of budget estimates mainly due to billing for the second half fire contract for the City of Otsego and the school liaison contract for ISD 728 for the first half of the 2021-22 school year. ■ Transfers in consists of ERMU's 4% June electric revenues and the budgeted transfers into the General Fund. Expenditures: ■ Total departmental expenditures are about 52% of budget and most departments are within or below budget estimates. 2021 Monthly Expenditures $ 20, 000 $18,000 $16,000 p $14,000 z $12,000 _ $10,000 ~ $8,000 $6,000 $4,000 $2,000 $0 Jan Feb Mar Apr May )I.lnj.l Aug Sep Oct Nov Dec Actual $1,240 $2,094 $3,408 $5,009 $6,224 $7,743 $9,036 Budget $1,461 $2,922 $4,383 $5,844 $7,305 $8,766 $10,227 $11,688 $13,149 $14,610 $16,071 $17,533 MULTIPURPOSE FACILITY Through the end of July, expenditures of $618,578 exceed revenues of $524,695 by $93,883. The majority of July collections consist of ice rentals, facility rentals and registration fees. ATTACHMENTS ■ General Fund Revenue & Expense Report ■ Multipurpose Facility Revenue & Expense Report ■ Enterprise Funds — Budget to Actual ■ Cash Report — All Funds 8-10-2021 08:45 AM CITY OF ELK RIVER PAGE: 1 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2021 101-GENERAL FUND FINANCIAL SUMMARY 58.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE REVENUE SUMMARY General Fund 17,532,500.00 3,436,940.82 9,878,448.69 56.34 7,654,051.31 8,618,315.62 TOTAL REVENUES 17,532,500.00 3,436,940.82 9,878,448.69 56.34 7,654,051.31 8,618,315.62 EXPENDITURE SUMMARY General Government City Council 173,200.00 14,538.87 79,694.42 46.01 93,505.58 68,571.86 Communications 336,000.00 20,346.39 173,908.70 51.76 162,091.30 154,376.65 Administrative Services 593,150.00 45,268.38 313,529.41 52.86 279,620.59 305,778.00 Human Resources 355,750.00 20,939.83 180,828.15 50.83 174,921.85 157,292.54 Elections 6,800.00 77.86 6,377.86 93.79 422.14 32,621.40 Finance 655,800.00 44,893.54 376,402.96 57.40 279,397.04 373,801.86 Information Technology 489,800.00 33,856.63 238,018.24 48.59 251,781.76 223,979.84 Legal 255,000.00 15,786.59 104,520.98 40.99 150,479.02 119,696.67 Community Development 209,500.00 13,246.59 128,427.44 61.30 81,072.56 130,439.81 Planning 364,150.00 28,896.03 197,756.47 54.31 166,393.53 191,798.97 Building Maintenance 788,500.00 54,854.23 440,190.83 55.83 348,309.17 432,092.35 TOTAL General Government 4,227,650.00 292,704.94 2,239,655.46 52.98 1,987,994.54 2,190,449.95 Public Safety Police Administration 925,200.00 54,812.86 597,049.42 64.53 328,150.58 537,254.10 Patrol 3,274,300.00 259,060.20 1,605,829.02 49.04 1,668,470.98 1,473,115.21 Investigations 1,238,700.00 87,901.01 604,321.32 48.79 634,378.68 527,046.01 Police Support Services 834,550.00 56,451.39 381,375.84 45.70 453,174.16 377,273.85 Police Reserves 16,750.00 434.70 2,937.56 17.54 13,812.44 759.53 Public safety building 160,600.00 4,223.61 95,986.20 59.77 64,613.80 76,871.01 Fire Administration 981,700.00 86,295.07 466,772.62 47.55 514,927.38 336,601.71 Fire Operations 422,200.00 29,277.03 217,313.97 51.47 204,886.03 247,212.50 Emergency Management 62,700.00 3,621.88 11,051.16 17.63 51,648.84 15,202.46 Building Safety 531,850.00 39,951.05 275,831.85 51.86 256,018.15 287,462.66 Code Enforcement 86,300.00 6,690.13 45,830.44 53.11 40,469.56 44,822.23 Environmental 58,300.00 5,095.91 30,655.80 52.58 27,644.20 28,976.46 TOTAL Public Safety 8,593,150.00 633,814.84 4,334,955.20 50.45 4,258,194.80 3,952,597.73 Public Works Street Maintenance 1,462,850.00 130,763.50 771,668.00 52.75 691,182.00 753,844.55 Snow Removal 345,800.00 253.63 222,204.73 64.26 123,595.27 175,959.03 Equipment Services 254,050.00 17,408.08 135,439.55 53.31 118,610.45 121,565.27 Engineering 492,800.00 31,355.76 214,652.34 43.56 278,147.66 188,456.16 TOTAL Public Works 2,555,500.00 179,780.97 1,343,964.62 52.59 1,211,535.38 1,239,825.01 8-10-2021 08:45 AM CITY OF ELK RIVER PAGE: 2 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2021 101-GENERAL FUND FINANCIAL SUMMARY Culture & Recreation Parks Department Parks & Rec Admin Recreation Programs Farmers Market Sr Citizen Programs TOTAL Culture & Recreation Economic Development Economic Development Energy City TOTAL Economic Development General TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 58.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE 1,307,700.00 110,900.07 693,189.90 53.01 614,510.10 618,795.83 553,850.00 37,916.46 277,334.46 50.07 276,515.54 389,595.37 122,700.00 26,181.46 51,871.95 4.2.28 70,8.28.05 40,844.64 8,750.00 ( 5,122.47)( 4,534.29) 51.82- 13,284.29 ( 2,554.78) 129,300.00 11,795.41 68,357.88 52.87 60,942.12 95,504.90 2,122,300.00 181,670.93 1,086, 219. 90 51.18 1,036,080.10 1,142,185.96 0.00 5,691.89 17,994.85 0.00 ( 17,994.85) 28,395.33 33,900.00 1,744.52 13,511.68 39.86 20,388.32 11,265.74 33,900.00 7,436.41 31,506.53 92.94 2,393.47 39,661.07 17,532,500.00 1,295,408.09 9,036,301.71 51.54 8,496,198.29 8,564,719.72 0.00 2,141,532.73 842,146.98 ( 842,146.98) 53,595.90 8-10-2021 08:45 AM CITY OF ELK RIVER PAGE: 3 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2021 101-GENERAL FUND 58.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE General Fund faxes 101-3-0000-3111 Current Ad Valorem Taxes 101-3-0000-3112 Delinquent Ad Valorem Taxes 101-3-0000-3121 Gravel Tax 101-3-0000-3131 Penalties/Interest TOTAL Taxes Licenses & Permits 101-3-0000-3211 Liquor License 101-3-0000-3213 Cigarette License 101-3-0000-3214 Rental License 101-3-0000-3216 Mining License 101-3-0000-3217 Garbage Hauler License 101-3-0000-3218 Other Business License/Permit 101-3-0000-3229 NPDES Permit 101-3-0000-3231 Building Permit 101-3-0000-3.232 Plumbing/Heating Permit 101-3-0000-3233 Permit Surcharge 101-3-0000-3235 Animal License 101-3-0000-3237 Other Non -Business Lic/Permit TOTAL Licenses & Permits Intergovernmental Rev 101-3-0000-3322 MV Credit 101-3-0000-3323 Fire State Aid 101-3-0000-3325 Police 20 Aid 101-3-0000-3326 Police Training Reimb 101-3-0000-3329 State Crime Prevention Grant 101-3-0000-3330 Other State Grants TOTAL Intergovernmental Rev 12,315,000.00 1,941,555.61 6,468,037.37 52.52 5,846,962.63 5,978,015.35 0.00 31,598.70 31,598.70 0.00 ( 31,598.70) 35,310.99 150,000.00 74,149.49 93,009.77 62.01 56,990.23 67,524.51 0.00 2,622.32 2,622.32 0.00 ( 2,622.32) 965.31 12,465,000.00 2,049,926.12 6,595,268.16 52.91 5,869,731.84 6,081,816.16 76,000.00 1,340.00 61,285.00 80.64 14,715.00 39,476.16 3,000.00 0.00 1,436.25 47.88 1,563.75 0.00 65,000.00 4,584.00 48,044.00 73.91 16,956.00 39,869.00 25,000.00 0.00 25,849.37 103.40 ( 849.37) 25,760.95 2,000.00 0.00 420.00 21.00 1,580.00 360.00 15,000.00 410.00 9,235.00 61.57 5,765.00 10,380.00 20,000.00 3,500.00 15,050.00 75.25 4,950.00 10,003.25 450,000.00 61,429.00 441,400.49 98.09 8,599.51 206,700.35 110,000.00 20,581.42 132,622.31. 120.57 ( 22,622.31) 39,361.03 500.00 ( 5,485.24) 4,083.87 816.77 ( 3,583.87) 3,002.78 0.00 0.00 250.00 0.00 ( 250.00) 465.00 12,000.00 7,335.00 17,975.00 149.79 ( 5,975.00) 10,267.50 778,500.00 93,694.18 757,651.29 97.32 20,848.71 385,646.02 5,500.00 0.00 0.00 0.00 5,500.00 0.00 200,000.00 0.00 1,000.00 0.50 199,000.00 1,000.00 305,000.00 0.00 0.00 0.00 305,000.00 0.00 32,000.00 0.00 4,000.00 12.50 28,000.00 0.00 60,000.00 12,331.52 2.2,807.63 38.01 37,192.37 16,244.54 0.00 0.00 0.00 0.00 0.00 11,570.11 602,500.00 12,331.52 27,807.63 4.62 574,692.37 28,814.65 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 25,000.00 1,675.00 9,990.25 39.96 15,009.75 13,029.19 101-3-0000-3413 Plan Check Fee 220,000.00 26,337.53 208,218.11 94.64 11,781.89 81,034.15 101-3-0000-3415 Special Assessment Search 500.00 120.00 710.00 142.00 ( 210.00) 300.00 101-3-0000-3417 Copies 1,500.00 135.25 932.43 62.16 567.57 814.18 101-3-0000-3418 Other General Govt Services 500.00 0.00 0.00 0.00 500.00 13.00 101-3-0000-3430 Lockout Fees 5,500.00 340.00 2,260.00 41.09 3,240.00 2,625.00 101-3-0000-3431 Police Services 15,000.00 3,136.33 35,626.83 237.51 ( 20,626.83) 9,797.41 101-3-0000-3432 School Liaison 151,000.00 79,245.00 155,077.50 102.70 ( 4,077.50) 147,072.00 101-3-0000-3434 Animal Impound Fee 2,500.00 100.00 200.00 8.00 2,300.00 550.00 101-3-0000-3436 Fire Contracts 286,000.00 128,116.50 289,661.96 101.28 ( 3,661.96) 280,007.80 101-3-0000-3437 Fire Services 6,000.00 0.00 0.00 0.00 6,000.00 6,137.50 101-3-0000-3451 Street Services 25,000.00 3,230.00 15,850.66 63.40 9,149.34 12,276.00 101-3-0000-3452 Engineering Services Reimb 25,000.00 0.00 5,778.85 23.12 19,221.15 13,296.19 8-10-2021 08:45 AM CITY OF ELK RIVER PAGE: 4 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2021 101-GENERAL FUND 58.33% OF YEAR COMPLETED REVENUES CURRENT BUDGET CURRENT PERIOD YEAR TO DATE ACTUAL o OF BUDGET BUDGET BALANCE PRIOR FY YID BALANCE 101-3-0000-3461 Recreation Fees 60,000.00 ( 295.00) 36,143.00 60.24 23,857.00 12,878.50 101-3-0000-3462 Sr Center Activities 30,000.00 1,907.00 17,351.00 57.84 12,649.00 8,058.00 101-3-0000-3463 Farmer's Market 12,000.00 1,420.00 20,400.01 170.00 ( 8,400.01) 9,935.00 101-3-0000-3469 Elk RiverFest 10,000.00 7,132.00 20,262.00 202.62 ( 10,262.00) 500.00 101-3-0000-3472 Park Use Fee 20,000.00 1,885.87 14,498.67 72.49 5,501.33 4,665.25 101-3-0000-3483 Sewer Inspection Fee 12,000.00 1,860.00 9,370.00 78.08 2,630.00 9,250.00 101-3-0000-3484 Contractor License Check 1,000.00 180.00 815.00 81.50 185.00 610.00 TOTAL Charges for Services 908,500.00 256,525.48 843,146.27 92.81 65,353.73 612,849.17 Fines & Forfeits 101-3-0000-3510 Court Fines 120,000.00 11,496.80 65,328.50 54.44 54,671.50 49,117.48 101-3-0000-3511 Parking Fines 0.00 0.00 0.00 0.00 0.00 150.00 101-3-0000-3512 Ordinance Violations 0.00 1,500.00 1,500.00 0.00 ( 1,500.00) 0.00 TOTAL Fines & Forfeits 120,000.00 12,996.80 66,828.50 55.69 53,171.50 49,267.48 Special Assessments Other Revenue 101-3-0000-3621 Interest Income 75,000.00 0.00 50,192.66 66.92 24,807.34 69,091.10 101-3-0000-3625 Refunds & Reimbursements 130,000.00 6,963.49 11,183.76 8.60 118,816.24 ( 2,121.19) 101-3-0000-3626 Contributions 25,000.00 0.00 19,000.00 76.00 6,000.00 0.00 101-3-0000-3629 Miscellaneous Revenue 6,500.00 44.15 9,553.38 146.98 ( 3,053.38) 6,395.15 TOTAL Other Revenue 236,500.00 7,007.64 89,929.80 38.03 146,570.20 73,365.06 Transfers In 101-3-0000-3921 Transfers 0.00 0.00 460.00 0.00 ( 460.00) 0.00 101-3-0000-3924 Transfer - MIT 140,000.00 0.00 0.00 0.00 140,000.00 0.00 101-3-0000-3930 Transfer -Development 10,600.00 10,600.00 10,600.00 100.00 0.00 10,600.00 101-3-0000-3942 Transfer-WWTS 160,000.00 160,000.00 160,000.00 100.00 0.00 155,000.00 101-3-0000-3943 Transfer -Liquor 500,000.00 500,000.00 500,000.00 100.00 0.00 500,000.00 101-3-0000-3944 Transfer -Garbage 52,000.00 52,000.00 52,000.00 100.00 0.00 50,000.00 101-3-0000-3945 Transfer -Utilities 1,355,000.00 119,859.08 612,757.04 45.22 742,242.96 583,257.08 101-3-0000-3946 Transfer-Stormwater 121,000.00 121,000.00 121,000.00 100.00 0.00 15,500.00 101-3-0000-3948 Transfer-EDA 41,000.00 41,000.00 41,000.00 100.00 0.00 39,500.00 101-3-0000-3949 Transfer-HRA 41,900.00 0.00 0.00 0.00 41,900.00 32,700.00 TOTAL Transfers In 2,421,500.00 1,004,459.08 1,497,817.04 61.85 923,682.96 1,386,557.08 TOTAL General Fund 17,532,500.00 3,436,940.82 9,878,448.69 56.34 7,654,051.31 8,618,315.62 TOTAL REVENUE 17,532,500.00 3,436,940.82 9,878,448.69 56.34 7,654,051.31 8,618,315.62 8-10-2021 08:45 AM CITY OF ELK RIVER PAGE: 1 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2021 221-MULTIPURPOSE FACILITY FINANCIAL SUMMARY REVENUE SUMMARY Multipurpose Facility Hockey Skating Concessions TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Multipurpose Facility Hockey Skating Concessions TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 58.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE 1,521,850.00 16,512.35 422,031.44 27.73 1,099,818.56 114,381.44 61,000.00 49,435.00 85,277.34 139.80 ( 24,277.34) 55,934.00 35,000.00 1,760.00 7,871.00 22.49 27,129.00 ( 830.00) 139,300.00 0.00 9,515.63 6.83 129,784.37 15,082.74 1,757,150.00 67,707.35 524,695.41 29.86 1,.232,454.59 184,568.18 1,324,300.00 50,579.76 597,132.30 45.09 727,167.70 279,610.82 30,150.00 381.75 17,873.25 59.28 12,276.75 14,093.32 19,950.00 23.98 2,460.97 12.34 17,489.03 2,418.26 87,500.00 0.00 1,111.52 1.27 86,388.48 11,895.39 1,461,900.00 50,985.49 618,578.04 42.31 843,321.96 308,017.79 1,461,900.00 50,985.49 618,578.04 42.31 843,321.96 308,017.79 295,250.00 16,721.86 ( 93,882.63) 389,132.63 ( 123,449.61) Sales and cost of sales: Sales Cost of sales Gross profit Operating revenues: User charges Delinquency collections Other Total operating revenues Operating expenses: Personal services Supplies Other service charges Depreciation * Total operating expenses Operating income (loss) Nonoperating revenues (expenses): Interest income Interest expense/agent fees Total nonoperating revenues (expenses) Income (loss) before contributions & transfers Contributions - connection fees Sale of assets Transfers in Transfers out NET INCOME (LOSS) Items reclassified to balance sheet at year end: Capital Outlay Bond Payment Revenues over/(under) expenditures * Recorded at yearend CITY OF ELK RIVER ENTERPRISE FUNDS - BUDGET TO ACTUAL MONTH ENDED JULY, 2021 Liquor Sewer Garbage Stormwater Current Year to Date % of Current Year to Date % of Current Year to Date % of Current Year to Date % of Budget Actual Budget Budget Actual Budget Budget Actual Budget Budget Actual Budget $ 7,670,500 $ 4,910,062 64.01 % 5,403,500 3,324,076 61.52% $ 2,350,000 $ 1,174,585 49.98% $ 1,735,000 $ 878,653 50.64% $ 575,000 $ 290,112 50.45% 2,267,000 1,585,986 69.96% - - - - - - 500 869 173.80% - 1,430 - - 265 - 4,800 3,454 71.96% 120,000 79,478 66.23% - - - - - - 4,800 3,454 71.96% 2,470,500 1,254,932 50.80% 1,735,000 880,083 50.73% 575,000 290,377 50.50% 971,550 554,125 57.04% 743,800 389,345 52.35% 32,550 17,597 54.06% - - - 19,600 11,377 58.05% 260,100 146,724 56.41% 19,400 19,362 99.81% 1,000 48 4.80% 306,500 218,628 71.33% 700,400 423,086 60.41% 1,483,900 783,137 52.78% 522,900 114,259 21.85% 124,000 - 0.00% 1,646,000 - 0.00% - - - 458,000 - 0.00% 1,421,650 784,130 55.16% 3,350,300 959,155 28.63% 1,535,850 820,096 53.40% 981,900 114,307 11.64% 850,150 805,310 94.73% (879,800) 295,777 -33.62% 199,150 59,987 30.12% (406,900) 176,070 -43.27% 50,000 36,586 73.17% 50,000 47,370 94.74% 3,000 3,463 115.43% 5,000 9,116 182.32% - - - (231,100) (29,584) 12.80% - - - - - - 50,000 36,586 73.17% (181,100) 17,787 -9.82% 3,000 3,463 115.43% 5,000 9,116 182.32% 900,150 841,896 93.53% (1,060,900) 313,564 -29.56% 202,150 63,450 31.39% (401,900) 185,186 -46.08% - - - 100,000 982,336 982.34% - - - - - 0.00% - - 0.00% 0.00% 0.00% 0.00% - 0.00% 0.00% 0.00% 750,000 750,000 100.00% (160,000) (160,000) 100.00% (52,000) (52,000) 100.00% 121,000 121,000 100.00% 150,150 91,896 61.20% (1,120,900) 1,135,900 -101.34% 150,150 11,450 7.63% 522,900 64,186 -12.28% (20,000) (18,000) - (135,000) (28,323) - - (440,000) (440,000) - - - - 130,150 73,896 1,695,900 667,577 150,150 11,450 522,900 64,186 8-10-2021 09:54 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: JULY 31ST, 2021. FUND ACCOUNT# ACCOUNT NAME CLAIM ON CASH BEGINNING BALANCE CURRENT CURRENT ACTIVITY BALANCE 002-1010 Cash - Section 125 7,086.54 1,549.52 8,636.06 101-1010 Cash - General Fund 6,689,793.13 2,176,607.46 8,866,400.59 211-1010 Cash - Library 293,788.60 ( 2,259.38) 291,529.22 221-1010 Cash.- Multipurpose Facility 74,631.84 33,791.34 108,423.18 225-1010 Cash - Park Dedication 926,883.82 ( 9,169.71) 917,714.11 228-1010 Cash - Landfill 185,788.13 1,086.31 186,874.44 231-1010 Cash - Landfill Const Debris 803,444.38 0.00 803,444.38 240-1010 Cash. - Micro Loan Fund 838,290.37 3,6.27.50 841,917.87 242-1010 Cash - State DEED 183,053.93 4,149.90 187,203.83 245-1010 Cash - Development Fund 1,761,765.88 37,032.21 1,798,798.09 290-1010 Cash - Capital Outlay Reserve 1,518,632.65 ( 489.13) 1,518,143.52 291-1010 Cash. - Insurance Reserve 40,779.92 ( 18,018.10) 22,761.82 292-1010 Cash - Govt Bldgs Reserve 2,840,068.85 389,480.97 3,229,549.82 294-1010 Cash - Drug Forfeiture 26,420.45 5,532.77 31,953.22 295-1010 Cash - Severance Pay Reserve 78,496.69 0.00 78,496.69 296-1010 Cash. - GRE :Reserve 1,008,398.56 ( 20,000.00) 988,398.56 301-1010 Cash - 2020A GO CIP Bonds 4,144.64 0.00 4,144.64 302-1010 Cash - 2021A GO CIP BONDS 96,000.87 0.00 96,000.87 333-1010 Cash - 2020B (2010/2012) Bonds 681,282.34 105,814.99 787,097.33 343-1010 Cash.- 2019A Sales Tax Bonds 2,405,611.74 24,706.56 2,430,318.30 401-1010 Cash - Pavement Mgmt 4,938,833.02 ( 564,512.06) 4, 374, 320. 96 403-1010 Cash - Street Improvement 410,994.91 6,514.56 417,509.47 406-1010 Cash - City Wide Trunk Util 3,899,531.95 ( 280,140.95) 3,619,391.00 410-1010 Cash. - Equipment Replacement 623,586.07 235,564.69 859,150.76 420-1010 Cash - Active ER 4,556,295.73 524,881.18 5,081,176.91 421-1010 Cash - PS Building/Fire Sta 3 9,290,915.80 ( 807,349.62) 8,483,566.18 440-1010 Cash - Park Improvement 459,221.44 13,920.24 473,141.68 462-1010 Cash. - TIF 422 Downtown Redev ( 51.55) 51.55 0.00 463-1010 Cash - TIF 423 Prof Powder 5,641.26 22,834.33 28,475.59 602-1010 Cash - Wastewater Treatment 6,758,401.38 91,695.43 6,850,096.81 603-1010 Cash - Liquor 4,804,729.35 ( 232,342.68) 4,572,386.67 605-1010 Cash.- Garbage 492,221.11 ( 41,070.26) 451,150.85 607-1010 Cash - Storm Water 1,336,816.68 ( 76,050.22) 1,260,766.46 801-1010 Cash - Interest. 0.00 39,980.98 39,980.98 821-1010 Cash - Developer Escrow 662,401.86 78,141.61 740,543.47 TOTAL CLAIM ON CASH 58,703,902.34 1,745,561.99 60,449,464.33 CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 168,022,604.06 2,953,364.74 170,975,968.80 999-1001 PY BANK ACCOUNT (137,700,891.28)( 1,205,297.07)(138,906,188.35) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 58,703,902.34 1,748,067.67 60,4.51,970.01