Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
12.1 SR 08-19-2024
The Elk River Vision A welcoming community with revolutionary and spirited resourcefulness, exceptional service, and community engagement that encourages and inspires prosperity Request for Action To City Council Item Number 12.1 Meeting Date August 19, 2024 Prepared By Lori Stich, Finance Manager Item Description Financial Report - July Reviewed by Lori Stich Joe Stremcha Cal Portner Tina Allard Action Requested Information only Background/Discussion 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 revenues include the remaining first half property tax settlement. ▪ License & permit collections are at about 42% of budget estimates. July collections were primarily building-related permits and gravel mining licenses. ▪ Charges for services are about 83% of estimates with the school liaison contract with ISD 728 for the first half of the 2024-2025 school year, the second half of the Otsego fire contract, plan check fees, and recreation fees making up the majority of July collections. ▪ Transfers In consist of ERMU’s 4% June monthly electric revenues and the budgeted transfers to the General Fund. Expenditures: Page 319 of 327 • Total departmental expenditures are about 52% of budget and most departments are within or below budget estimates. Multipurpose Facility Through the end of July, expenditures of $894,637 exceeded revenues of $887,713 by $6,923. The majority of July collections consist of hockey and skating registrations, ice rent, facility rentals, and naming rights/sponsorships while expenditures are primarily attributable to personal services and utilities. Financial Impact N/A Mission/Policy/Goal Responsible for every dollar - good stewards. Attachments 1. 07-2024 Financial Reports Page 320 of 327 8-13-2024 01:36 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2024 101-GENERAL FUND FINANCIAL SUMMARY 58.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE __________________________________________________________________________________________________________________________________ REVENUE SUMMARY General Fund 21,570,600.00 4,425,880.09 11,495,826.78 53.29 10,074,773.22 11,051,766.46 TOTAL REVENUES 21,570,600.00 4,425,880.09 11,495,826.78 53.29 10,074,773.22 11,051,766.46 ============= ============= ============= ======= ============= ============= EXPENDITURE SUMMARY General Government City Council 213,550.00 10,204.82 106,173.91 49.72 107,376.09 102,413.77 Communications 485,300.00 32,860.68 244,861.51 50.46 240,438.49 226,550.49 Administrative Services 721,850.00 52,956.97 398,376.97 55.19 323,473.03 365,831.82 Human Resources 426,550.00 52,847.56 227,059.13 53.23 199,490.87 213,091.42 Elections 75,500.00 8.60 25,641.85 33.96 49,858.15 6,213.68 Finance 800,750.00 55,598.26 486,945.68 60.81 313,804.32 426,574.85 Information Technology 731,500.00 50,600.33 329,939.39 45.10 401,560.61 301,585.29 Legal 275,000.00 41,680.78 179,709.48 65.35 95,290.52 133,506.91 Community Development 0.00 10.99 34,290.02 0.00 ( 34,290.02) 133,445.73 Planning 485,100.00 34,312.29 245,358.11 50.58 239,741.89 133,131.48 Building Maintenance 1,085,250.00 85,695.11 576,585.39 53.13 508,664.61 565,873.51 TOTAL General Government 5,300,350.00 416,776.39 2,854,941.44 53.86 2,445,408.56 2,608,218.95 Public Safety Police Administration 1,175,550.00 57,667.61 800,045.51 68.06 375,504.49 693,735.24 Patrol 3,780,150.00 344,129.44 1,980,207.91 52.38 1,799,942.09 1,914,937.49 Investigations 1,430,850.00 126,446.51 646,543.17 45.19 784,306.83 703,942.23 Police Support Services 945,800.00 79,424.34 454,885.56 48.10 490,914.44 354,643.48 Police Reserves 16,550.00 620.04 1,390.10 8.40 15,159.90 5,221.02 Public safety building 229,500.00 20,914.79 96,798.04 42.18 132,701.96 108,457.41 Fire Administration 1,332,800.00 77,457.16 580,603.33 43.56 752,196.67 570,251.45 Fire Operations 630,450.00 26,150.76 292,190.69 46.35 338,259.31 390,888.54 Emergency Management 34,750.00 5,725.87 14,122.43 40.64 20,627.57 16,444.12 Building Safety 625,500.00 47,621.79 332,111.79 53.10 293,388.21 311,582.75 Code Enforcement 126,000.00 10,107.24 66,798.17 53.01 59,201.83 61,615.91 Environmental 101,700.00 10,516.51 67,116.07 65.99 34,583.93 53,278.46 TOTAL Public Safety 10,429,600.00 806,782.06 5,332,812.77 51.13 5,096,787.23 5,184,998.10 Public Works Street Maintenance 1,742,150.00 107,607.65 857,189.06 49.20 884,960.94 770,966.45 Snow Removal 411,150.00 475.00 205,118.13 49.89 206,031.87 237,737.21 Equipment Services 397,300.00 34,575.28 218,308.20 54.95 178,991.80 194,666.74 Engineering 489,150.00 26,176.57 245,556.92 50.20 243,593.08 253,995.37 TOTAL Public Works 3,039,750.00 168,834.50 1,526,172.31 50.21 1,513,577.69 1,457,365.77 Page 321 of 327 8-13-2024 01:36 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2024 101-GENERAL FUND FINANCIAL SUMMARY 58.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE __________________________________________________________________________________________________________________________________ Culture & Recreation Parks Department 1,743,700.00 145,996.02 862,412.54 49.46 881,287.46 740,954.78 Parks & Rec Admin 621,100.00 46,997.44 325,782.42 52.45 295,317.58 307,542.85 Recreation Programs 181,550.00 38,097.70 95,177.66 52.43 86,372.34 91,075.88 Farmers Market 9,500.00 1,224.94 7,696.55 81.02 1,803.45 5,820.90 Sr Citizen Programs 196,000.00 17,207.40 110,082.09 56.16 85,917.91 93,911.78 TOTAL Culture & Recreation 2,751,850.00 249,523.50 1,401,151.26 50.92 1,350,698.74 1,239,306.19 Economic Development Economic Development 0.00 125.59 23,412.92 0.00 ( 23,412.92) 29,799.50 Energy City 49,050.00 2,102.72 15,224.32 31.04 33,825.68 29,172.08 TOTAL Economic Development 49,050.00 2,228.31 38,637.24 78.77 10,412.76 58,971.58 General _____________ _____________ _____________ _______ _____________ _____________ TOTAL EXPENDITURES 21,570,600.00 1,644,144.76 11,153,715.02 51.71 10,416,884.98 10,548,860.59 ============= ============= ============= ======= ============= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 2,781,735.33 342,111.76 ( 342,111.76) 502,905.87 Page 322 of 327 8-13-2024 01:36 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2024 101-GENERAL FUND 58.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE __________________________________________________________________________________________________________________________________ General Fund ============ Taxes 101-3-0000-3111 Current Ad Valorem Taxes 14,917,700.00 2,286,970.92 7,619,611.79 51.08 7,298,088.21 7,201,889.90 101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 47,038.78 49,612.24 0.00 ( 49,612.24) 28,680.86 101-3-0000-3121 Gravel Tax 225,000.00 0.00 13,155.99 5.85 211,844.01 8,943.23 101-3-0000-3131 Penalties/Interest 0.00 1,696.65 2,449.11 0.00 ( 2,449.11) 251.38 TOTAL Taxes 15,142,700.00 2,335,706.35 7,684,829.13 50.75 7,457,870.87 7,239,765.37 Licenses & Permits 101-3-0000-3211 Liquor License 82,000.00 5,200.00 77,645.00 94.69 4,355.00 77,630.00 101-3-0000-3212 THC License 4,000.00 0.00 400.00 10.00 3,600.00 2,400.00 101-3-0000-3213 Cigarette License 4,000.00 0.00 450.00 11.25 3,550.00 300.00 101-3-0000-3214 Rental License 65,000.00 1,680.00 30,610.00 47.09 34,390.00 39,810.00 101-3-0000-3216 Mining License 26,000.00 20,259.55 26,887.75 103.41 ( 887.75) 26,842.75 101-3-0000-3217 Garbage Hauler License 2,500.00 0.00 2,505.00 100.20 ( 5.00) 765.00 101-3-0000-3218 Other Business License/Permit 16,000.00 1,500.00 13,490.00 84.31 2,510.00 8,370.00 101-3-0000-3229 NPDES Permit 23,000.00 2,275.00 5,950.00 25.87 17,050.00 5,075.00 101-3-0000-3231 Building Permit 600,000.00 46,339.35 190,034.75 31.67 409,965.25 324,062.50 101-3-0000-3232 Plumbing/Heating Permit 160,000.00 17,389.83 61,631.99 38.52 98,368.01 170,368.49 101-3-0000-3233 Permit Surcharge 700.00 2,996.44 5,813.38 830.48 ( 5,113.38) 3,222.71 101-3-0000-3235 Animal License 0.00 100.00 200.00 0.00 ( 200.00) 560.00 101-3-0000-3237 Other Non-Business Lic/Permit 25,000.00 1,180.00 6,571.19 26.28 18,428.81 17,645.00 TOTAL Licenses & Permits 1,008,200.00 98,920.17 422,189.06 41.88 586,010.94 677,051.45 Intergovernmental Rev 101-3-0000-3311 Federal Grant 0.00 0.00 0.00 0.00 0.00 308.70 101-3-0000-3322 MV Credit 6,000.00 0.00 0.00 0.00 6,000.00 0.00 101-3-0000-3323 Fire State Aid 230,000.00 0.00 3,000.00 1.30 227,000.00 4,000.00 101-3-0000-3325 Police 2% Aid 340,000.00 0.00 0.00 0.00 340,000.00 0.00 101-3-0000-3326 Police Training Reimb 35,000.00 0.00 0.00 0.00 35,000.00 0.00 101-3-0000-3329 State Crime Prevention Grant 48,000.00 20,586.04 31,545.97 65.72 16,454.03 21,236.32 101-3-0000-3330 Other State Grants 0.00 0.00 12,396.61 0.00 ( 12,396.61) 0.00 TOTAL Intergovernmental Rev 659,000.00 20,586.04 46,942.58 7.12 612,057.42 25,545.02 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 25,000.00 2,531.25 17,245.00 68.98 7,755.00 13,581.50 101-3-0000-3413 Plan Check Fee 250,000.00 17,733.84 80,917.06 32.37 169,082.94 151,621.24 101-3-0000-3415 Special Assessment Search 500.00 60.00 120.00 24.00 380.00 65.00 101-3-0000-3417 Copies 1,500.00 34.03 734.81 48.99 765.19 668.38 101-3-0000-3430 Lockout Fees 3,500.00 140.00 1,068.00 30.51 2,432.00 1,660.00 101-3-0000-3431 Police Services 45,000.00 320.00 11,966.82 26.59 33,033.18 13,820.00 101-3-0000-3432 School Liaison 183,000.00 89,567.50 183,124.26 100.07 ( 124.26) 90,492.68 101-3-0000-3434 Animal Impound Fee 500.00 0.00 350.00 70.00 150.00 300.00 101-3-0000-3436 Fire Contracts 400,000.00 211,205.50 470,798.46 117.70 ( 70,798.46) 238,139.39 101-3-0000-3437 Fire Services 3,000.00 0.00 1,009.34 33.64 1,990.66 ( 300.00) 101-3-0000-3451 Street Services 35,000.00 6,222.50 22,040.00 62.97 12,960.00 11,652.50 Page 323 of 327 8-13-2024 01:36 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2024 101-GENERAL FUND 58.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE __________________________________________________________________________________________________________________________________ 101-3-0000-3452 Engineering Services Reimb 20,000.00 5,065.00 5,065.00 25.33 14,935.00 14,635.45 101-3-0000-3461 Recreation Fees 50,000.00 2,703.00 35,699.04 71.40 14,300.96 45,259.02 101-3-0000-3462 Sr Center Activities 43,000.00 3,694.79 24,528.89 57.04 18,471.11 27,971.05 101-3-0000-3463 Farmer's Market 12,000.00 6,505.00 30,560.55 254.67 ( 18,560.55) 25,350.86 101-3-0000-3469 Elk RiverFest 20,000.00 8,983.39 21,468.00 107.34 ( 1,468.00) 24,023.05 101-3-0000-3472 Park Use Fee 40,000.00 4,927.16 40,955.84 102.39 ( 955.84) 31,202.54 101-3-0000-3483 Sewer Inspection Fee 15,000.00 2,780.00 9,720.00 64.80 5,280.00 8,660.00 101-3-0000-3484 Contractor License Check 1,200.00 120.00 535.00 44.58 665.00 375.00 TOTAL Charges for Services 1,148,200.00 362,592.96 957,906.07 83.43 190,293.93 699,177.66 Fines & Forfeits 101-3-0000-3510 Court Fines 150,000.00 14,538.81 82,039.80 54.69 67,960.20 79,484.18 101-3-0000-3512 Ordinance Violations 0.00 600.00 600.00 0.00 ( 600.00) 3,100.00 TOTAL Fines & Forfeits 150,000.00 15,138.81 82,639.80 55.09 67,360.20 82,584.18 Special Assessments _____________ _____________ _____________ _______ _____________ _____________ Other Revenue 101-3-0000-3621 Interest Income 150,000.00 0.00 105,861.88 70.57 44,138.12 95,719.41 101-3-0000-3625 Refunds & Reimbursements 145,000.00 6.99 ( 10,222.41) 7.05- 155,222.41 ( 1,048.82) 101-3-0000-3626 Contributions 25,000.00 0.00 25,750.00 103.00 ( 750.00) 42,260.00 101-3-0000-3629 Miscellaneous Revenue 10,000.00 2,756.07 7,144.94 71.45 2,855.06 4,820.83 TOTAL Other Revenue 330,000.00 2,763.06 128,534.41 38.95 201,465.59 141,751.42 Other Financing Sources _____________ _____________ _____________ _______ _____________ _____________ Transfers In 101-3-0000-3921 Transfers 0.00 0.00 224.52 0.00 ( 224.52) 748.79 101-3-0000-3926 Transfer-Capital Outlay Reserv 89,000.00 89,000.00 97,500.00 109.55 ( 8,500.00) 78,500.00 101-3-0000-3942 Transfer-WWTS 175,000.00 175,000.00 175,000.00 100.00 0.00 170,000.00 101-3-0000-3943 Transfer-Liquor 1,000,000.00 1,000,000.00 1,000,000.00 100.00 0.00 1,000,000.00 101-3-0000-3944 Transfer-Garbage 250,000.00 58,000.00 58,000.00 23.20 192,000.00 56,500.00 101-3-0000-3945 Transfer-Utilities 1,400,000.00 133,172.70 707,061.21 50.50 692,938.79 745,142.57 101-3-0000-3946 Transfer-Stormwater 135,000.00 135,000.00 135,000.00 100.00 0.00 135,000.00 101-3-0000-3948 Transfer-EDA 46,000.00 0.00 0.00 0.00 46,000.00 0.00 101-3-0000-3949 Transfer-HRA 37,500.00 0.00 0.00 0.00 37,500.00 0.00 TOTAL Transfers In 3,132,500.00 1,590,172.70 2,172,785.73 69.36 959,714.27 2,185,891.36 ____________________________________________________________________________________________ TOTAL General Fund 21,570,600.00 4,425,880.09 11,495,826.78 53.29 10,074,773.22 11,051,766.46 __________________________________________________________________________________________________________________________________ TOTAL REVENUE 21,570,600.00 4,425,880.09 11,495,826.78 53.29 10,074,773.22 11,051,766.46 ============= ============= ============= ======= ============= ============= Page 324 of 327 Current Budget Year to Date Actual % of Budget Revenues: Ice Rental $893,500 $433,502 48.52% Admissions 45,000 24,106 53.57% Dry Floor Events/Craft Shows 7,000 490 7.00% Facility Rental 244,400 113,427 46.41% Advertising/Naming Rights/Sponsorships 178,000 73,904 41.52% Recreation fees (Skating/Hockey)290,000 124,078 42.79% Concessions/vending 229,000 110,995 48.47% Other Revenues (interest, etc.)9,100 7,211 79.24% Total Revenues $1,896,000 $887,713 46.82% Operating expenses: Personal services $900,650 $499,942 55.51% Supplies 159,800 115,049 72.00% Other service charges 661,300 279,645 42.29% Capital Outlay 120,400 0 0.00% Total Expenditures $1,842,150 $894,637 48.56% Revenues over/(under) expenditures $53,850 ($6,923) CITY OF ELK RIVER MULTIPURPOSE FACILITY - BUDGET TO ACTUAL MONTH ENDED JULY 31, 2024 Budget, $1,896,000 Budget, $1,842,150 Actual $887,713 Actual $894,637 $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 $1,800,000 $2,000,000 Total Revenues Total Expenditures FTCenter July 2024 Page 325 of 327 Current Budget Year to Date Actual % of Budget Current Budget Year to Date Actual % of Budget Current Budget Year to Date Actual % of Budget Current Budget Year to Date Actual % of Budget Sales and cost of sales: Sales 8,161,000$ 4,800,135$ 58.82% Cost of sales (6,028,000) (3,128,981) 51.91% Gross profit 2,133,000 1,671,154 78.35% Operating revenues: User charges - - - 2,630,000$ 1,380,133$ 52.48%2,009,800$ 975,939$ 48.56%630,000$ 335,587$ 53.27% Delinquency collections - - - 1,000 1,026 102.61%- 1,207 - - 82 - Other 9,000 2,520 28.00%180,000 89,972 49.98%- - - - - - Total operating revenues 9,000 2,520 28.00%2,811,000 1,471,131 52.33%2,009,800 977,146 48.62%630,000 335,669 53.28% Operating expenses: Personal services 1,070,500 647,406 60.48%863,500 433,837 50.24%45,550 25,374 55.71%- - - Supplies 28,100 21,487 76.47%324,600 121,736 37.50%23,400 1,328 5.68%1,000 315 31.54% Other service charges 355,950 197,972 55.62%972,410 753,321 77.47%1,773,250 832,749 46.96%453,600 58,013 12.79% Depreciation *100,000 - 0.00%1,705,000 - 0.00%- - - 495,000 - 0.00% Total operating expenses 1,554,550 866,866 55.76%3,865,510 1,308,894 33.86%1,842,200 859,451 46.65%949,600 58,328 6.14% Operating income (loss)587,450 806,809 137.34%(1,054,510) 162,237 -15.39%167,600 117,695 70.22%(319,600) 277,341 -86.78% Nonoperating revenues (expenses): Interest income 125,000 59,275 47.42%125,000 144,102 115.28%8,000 14,216 177.70%25,000 33,255 133.02% Interest expense/agent fees - - - (82,800) (42,918) 51.83%- - - - - - Total nonoperating revenues (expenses)125,000 59,275 47.42%42,200 101,184 239.77%8,000 14,216 177.70%25,000 33,255 133.02% Income (loss) before contributions & transfers 712,450 866,084 121.56%(1,012,310) 263,421 -26.02%175,600 131,911 75.12%(294,600) 310,595 -105.43% Contributions - connection fees - - - 1,000,000 231,867 23.19%- - - - - - Transfers in (ARPA funds)- 350,000 0.00% Sale of assets - - 0.00%- 1,700 0.00%- - 0.00%- - 0.00% Transfers out (1,250,000) (1,000,000) 80.00%(175,000) (175,000) 100.00%(58,000) (58,000) 100.00%(175,000) (135,000) 77.14% NET INCOME (LOSS)(537,550) (133,916) 24.91%(187,310) 671,988 -358.76%117,600 73,911 62.85%(469,600) 175,595 -37.39% Items reclassified to balance sheet at year end: Bond Proceeds - - Capital Outlay (91,000) - - (173,000) (419,281) - - - - - - - Bond Payment (Payoff 2014B Refunded Debt)- - - (520,000) (520,000) - - - - - - - Revenues over/(under) expenditures (628,550) (133,916) (880,310) (267,293) 117,600 73,911 (469,600) 175,595 * Recorded at year-end CITY OF ELK RIVER ENTERPRISE FUNDS - BUDGET TO ACTUAL MONTH ENDED JULY 31, 2024 Liquor Sewer Garbage Stormwater Page 326 of 327 8-13-2024 02:44 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: JULY 31ST, 2024 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE __________________________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 10,610.36 2,887.58 13,497.94 101-1010 Cash - General Fund 6,814,952.38 2,480,547.43 9,295,499.81 211-1010 Cash - Library 193,251.66 5,586.22 198,837.88 219-1010 Cash - Federal COVID Fund 1,087,310.53 370.55 1,087,681.08 221-1010 Cash - Multipurpose Facility 23,661.11 ( 60,236.99)( 36,575.88) 225-1010 Cash - Park Dedication 1,441,213.14 ( 17,812.00) 1,423,401.14 228-1010 Cash - Landfill 177,907.88 ( 1,741.45) 176,166.43 231-1010 Cash - Landfill Const Debris 855,767.64 0.00 855,767.64 240-1010 Cash - Micro Loan Fund 1,156,340.71 ( 1,144.00) 1,155,196.71 242-1010 Cash - State DEED 465,561.83 2,642.66 468,204.49 245-1010 Cash - Development Fund 1,754,214.19 67,136.46 1,821,350.65 290-1010 Cash - Capital Outlay Reserve 2,660,908.16 ( 184,783.50) 2,476,124.66 291-1010 Cash - Insurance Reserve ( 159,392.11) 12,913.97 ( 146,478.14) 292-1010 Cash - Govt Bldgs Reserve 5,418,194.58 185,917.49 5,604,112.07 294-1010 Cash - Drug Forfeiture 7,289.46 67.14 7,356.60 296-1010 Cash - GRE Reserve 833,891.09 500.00 834,391.09 301-1010 Cash - 2020A GO CIP Bonds 251,888.05 94,898.29 346,786.34 302-1010 Cash - 2021A GO CIP BONDS 160,677.91 61,149.86 221,827.77 333-1010 Cash - 2020B (2010/2012) Bonds ( 173,296.30) 481.85 ( 172,814.45) 343-1010 Cash - 2019A Sales Tax Bonds 7,660,163.72 277,179.71 7,937,343.43 401-1010 Cash - Pavement Mgmt 5,076,772.65 346,050.92 5,422,823.57 403-1010 Cash - Street Improvement 536,291.51 ( 408.00) 535,883.51 406-1010 Cash - City Wide Trunk Util 211,665.96 43,355.78 255,021.74 410-1010 Cash - Equipment Replacement 1,866,999.48 79,318.28 1,946,317.76 411-1010 Cash - Technology Replacement 53,286.84 1,679.52 54,966.36 420-1010 Cash - Active ER 1,501,754.37 2,692.19 1,504,446.56 421-1010 Cash - PS Building/Fire Sta 3 924,749.68 3,725.25 928,474.93 440-1010 Cash - Park Improvement ( 126,223.35)( 9,198.53)( 135,421.88) 462-1010 Cash - TIF #22 Downtown Redev 1,342.75 91,376.32 92,719.07 463-1010 Cash - TIF #23 Pref Powder 5,399.29 ( 3,176.25) 2,223.04 465-1010 Cash - TIF 25 Jackson Hills 18,300.30 38,277.08 56,577.38 466-1010 Cash - TIF #26 Shoot Steel 2,017.70 13,836.83 15,854.53 467-1010 Cash - TIF #27 Delta Apartment 1,398.28 37,530.72 38,929.00 602-1010 Cash - Wastewater Treatment 9,560,178.79 33,964.41 9,594,143.20 603-1010 Cash - Liquor 4,178,366.00 ( 854,082.09) 3,324,283.91 605-1010 Cash - Garbage 1,007,471.71 ( 23,529.79) 983,941.92 607-1010 Cash - Storm Water 2,389,184.94 ( 79,345.05) 2,309,839.89 801-1010 Cash - Interest 0.00 169,458.19 169,458.19 821-1010 Cash - Developer Escrow 1,175,474.49 ( 2,865.50) 1,172,608.99 TOTAL CLAIM ON CASH 59,025,547.38 2,815,221.55 61,840,768.93 =============== ============== ============== CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 219,757,532.69 4,287,531.24 224,045,063.93 999-1001 PY BANK ACCOUNT (189,114,174.87)( 1,472,309.69)(190,586,484.56) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 59,025,547.38 2,815,221.55 61,840,768.93 Page 327 of 327