Loading...
Finance - Quarterly Reports - FY 21/22 3rd Quarter - 06/30/2022CITY OF EAGLE QUARTERLY TREASURER'S REPORT FOR THE NINE MONTHS ENDING JUNE 30, 2022 BEGINNING CASH ANNUAL % ANNUAL % CHANGE IN ENDING CASH FUND NUMBER AND TITLE BALANCE REVENUES REALIZED EXPENDITURES EXPENDED BALANCE SHEET BALANCE 01 GENERAL FUND 640,585.60 10,394,736.46 59.99 7,209,509.28 41.61 3,118,895.47 706,917.31 06 LIBRARY FUND ( 43,479.61) 1,079,120.16 52.09 913,173.39 44.08 108,528.43 13,938.73 07 MUSEUM FUND 46,900.01 48,755.80 31.08 94,238.29 60.08 1,417.52 .00 08 PARK IMPACT FEE FUND 212,713.17 270,537.66 4.75 65,940.77 1.16 377,709.47 39,600.59 09 RECREATION - SPECIAL EVENTS 152,178.59 29,987.67 11.21 103,011.69 38.49 ( 2,562.65) 81,717.22 10 EAGLE HISTORICAL COMMISSION 19,283.33 1,733.52 19.26 .00 .00 .00 21,016.85 11 EXECUTIVE DEPARTMENT .00 215,268.79 53.81 214,360.76 53.59 908.03 .00 12 CITY CLERK/TREAS DEPARTMENT .00 422,884.32 67.49 409,320.74 65.33 13,563.58 .00 13 BUILDING DEPARTMENT .00 742,870.29 64.24 700,397.65 60.57 42,472.64 .00 14 P&Z DEPARTMENT .00 703,843.57 57.97 682,905.42 56.25 20,938.15 .00 17 RECREATION - PARKS AND REC 168,969.85 182,840.36 27.59 325,358.20 49.09 16,072.27 10,379.74 18 IT DEPARTMENT .00 551,313.18 61.68 519,236.79 58.09 32,076.39 .00 19 CAPITAL PROJECTS FUND 3,038,014.38 3,375,209.33 16.11 7,600,559.72 36.28 ( 5,053,613.54) 3,866,277.53 21 ARTS COMMISSION 24,558.04 448.65 .58 10,802.53 13.95 .00 14,204.16 23 PUBLIC WORKS .00 438,312.81 18.35 1,136,162.02 47.57 ( 697,849.21) .00 24 RECREATION - EAGLE FUN DAYS ( 23,706.58) 42,617.08 29.28 18,910.50 12.99 .00 .00 25 PATHWAY IMPACT FEE FUND 102,694.44 79,690.31 8.84 483.00 .05 132,317.25 49,584.50 26 ECONOMIC DEVELOPMENT .00 145,720.19 68.72 142,143.71 67.03 3,576.48 .00 27 LAW ENF DEV IMPACT FEES 8,614.24 32,150.15 22.69 .00 .00 16,117.71 24,646.68 54 CITY HALL BOND FUND 3,405.22 8,293.95 8.06 11,699.17 11.36 .00 .00 60 WATER FUND 945,182.58 2,260,461.94 63.36 1,064,676.78 29.84 1,603,018.30 537,949.44 99 COMBINED CASH FUND ( 5,295,913.26) .00 .00 .00 .00 70,319.49 ( 5,366,232.75) TOTAL .00 21,026,796.19 Citizens are invited to inspect the detailed supporting records of the attached financial statements. Idaho Code 50-1011 Making the Quarterly Treasurer's Report available for public review on the City's website shall satisfy publication requirements Idaho Code 50-2080 For additional information, please contact Eagle City Hall, 208-939-6813 City of Eagle Kellie Rekow, CMC City Treasurer Posted to the City of Eagle website, August 2, 2022 21,222,890.41 196,094.22) .00 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:56PM PAGE: 1 CITY OF EAGLE COMBINED CASH INVESTMENT JUNE 30, 2022 COMBINED CASH ACCOUNTS 99-0103-00-00 CASH IN CHECKING 99-0107-00-00 CASH CLEARING -UTILITY BILLING 99-0108-00-00 CASH CLEARING -ACCOUNTS REC TOTAL COMBINED CASH 99-0101-00-00 CASH ALLOCATED TO OTHER FUNDS TOTAL UNALLOCATED CASH CASH ALLOCATION RECONCILIATION 1 ALLOCATION TO GENERAL FUND 6 ALLOCATION TO LIBRARY FUND 8 ALLOCATION TO PARK IMPACT FEE FUND 9 ALLOCATION TO RECREATION - SPECIAL EVENTS 10 ALLOCATION TO EAGLE HISTORICAL COMMISSION 17 ALLOCATION TO RECREATION - PARKS AND REC 19 ALLOCATION TO CAPITAL PROJECTS FUND 21 ALLOCATION TO ARTS COMMISSION 25 ALLOCATION TO PATHWAY IMPACT FEE FUND 27 ALLOCATION TO LAW ENF DEV IMPACT FEES 60 ALLOCATION TO WATER FUND TOTAL ALLOCATIONS TO OTHER FUNDS ALLOCATION FROM COMBINED CASH FUND - 99-0101-00-00 ZERO PROOF IF ALLOCATIONS BALANCE 5,167, 787.16 580.82 197,864.77 5,366,232.75 ( 5,366,232.75) .00 706,917.31 13, 938.73 39,600.59 81, 717.22 21, 016.85 10,379.74 3,866,277.53 14, 204.16 49,584.50 24,646.68 537,949.44 5,366,232.75 ( 5,366,232.75) .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 1 CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 GENERALFUND 01-0101-00-00 CASH 706,917.31 01-0103-00-00 PETTY CASH 100.00 01-0107-00-00 TAXES RECEIVABLE DELINQUENT 14,402.55 01-0115-00-00 ACCOUNTS RECEIVABLE 43,496.01 01-0132-00-00 DUE FROM OTHER GOVERNMNTL UNTS 863,581.36 01-0151-25-00 FIRST INTERSTATE INVESTMENT 8,288,657.80 01-0151-28-00 ICCU CD 50,991.31 01-0170-00-00 HRA 10 % DEPOSIT 5,785.92 TOTAL ASSETS LIABILITIES AND EQUITY LIABILITIES 01-0202-00-00 VOUCHERS PAYABLE ( 3,542.16) 01-0203-00-00 ACCTS PAYABLE-ACHD IMPACT FEES 63,327.00 01-0203-01-01 BONDS DEPOSITS PAYABLE 2,586,105.11 01-0203-01-02 FIREWORKS BOND DEPOSIT PAYABLE ( 2,000.00) 01-0203-01-03 VENDORS BOND DEPOSITS PAYABLE 6,039.00 01-0203-01-05 P&Z DEPOSITS PAYABLE 249,873.75 01-0203-01-06 LAND USE DEPOSITS PAYABLE 50,991.31 01-0217-04-00 PUBLIC RETIREMENT ( .02) 01-0217-07-00 GEN ADMIN HEALTH INSURANCE ( 10,779.13) 01-0217-07-01 COBRA- HEALTH INSURANCE ( 85.96) 01-0217-09-00 WORKERS' COMPENSATION 1,519.13 01-0226-00-00 DEFERRED REVENUE 12,637.20 TOTAL LIABILITIES FUND EQUITY 01-0271-00-00 FUND BALANCE 3,834,619.85 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 3,185,227.18 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY 3,185,227.18 9,973,932.26 2,954,085.23 7,019,847.03 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 2 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 GENERALFUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 01-0311-00-00 PROPERTYTAX 1,885,550.65 1,885,550.65 2,708,042.00 822,491.35 69.6 01-0311-01-00 PENALTY/INTEREST ON TAXES 2,374.73 2,374.73 3,000.00 625.27 79.2 01-0312-00-00 PERSONAL PROPERTY TAX REIMBURS 4,231.43 4,231.43 8,463.00 4,231.57 50.0 01-0316-10-00 FRANCHISE FEE/EAGLE WATER CO. 2,365.15 2,365.15 5,000.00 2,634.85 47.3 01-0316-10-02 FRANCHISE FEE/VEOLIA 12,484.77 12,484.77 15,000.00 2,515.23 83.2 01-0316-11-00 FRANCHISE FEE/INTERMTN GAS 243,434.26 243,434.26 270,000.00 26,565.74 90.2 01-0316-12-00 FRANCHISE FEE/CABLE TV 83,835.13 83,835.13 112,000.00 28,164.87 74.9 01-0316-13-00 FRANCHISE FEE/TRASH 276,934.73 276,934.73 275,000.00 ( 1,934.73) 100.7 01-0316-14-00 FRANCHISE FEE/IDAHO POWER 190,951.94 190,951.94 212,000.00 21,048.06 90.1 01-0321-10-00 ALCOHOLIC BEVERAGE LICENSES 38,029.13 38,029.13 30,000.00 ( 8,029.13) 126.8 01-0321-30-00 BUSINESS LICENSE FEE 15,685.00 15,685.00 16,500.00 815.00 95.1 01-0322-10-00 BUILDING & INSPECTION PERMITS 972,341.96 972,341.96 1,770,000.00 797,658.04 54.9 01-0322-12-00 PLAN REVIEW FEES 370,697.78 370,697.78 525,000.00 154,302.22 70.6 01-0322-13-00 ENERGY STANDARDS (IRES) 13,400.00 13,400.00 30,000.00 16,600.00 44.7 01-0322-14-00 ELECTRICAL PERMIT FEES 200,034.09 200,034.09 252,000.00 51,965.91 79.4 01-0322-15-00 PLUMBING PERMIT FEES 150,864.05 150,864.05 252,000.00 101,135.95 59.9 01-0322-16-00 MECHANICAL PERMIT FEES 209,477.24 209,477.24 252,000.00 42,522.76 83.1 01-0322-20-00 FIRE IMPACTADMIN FEES 6,130.00 6,130.00 12,000.00 5,870.00 51.1 01-0323-01-00 PZ ANNEX/ZONING PERMIT FEES 286,951.31 286,951.31 210,000.00 ( 76,951.31) 136.6 01-0323-02-00 PLANNING INSPECTION FEES 1,215.00 1,215.00 8,000.00 6,785.00 15.2 01-0323-03-00 PLAN REVIEW FEES 18,975.00 18,975.00 40,000.00 21,025.00 47.4 01-0323-04-00 STREET LIGHT INSPECTION FEES 1,740.00 1,740.00 1,200.00 ( 540.00) 145.0 01-0323-05-00 SURETY/LETTER OF CREDIT FEES 5,830.00 5,830.00 4,000.00 ( 1,830.00) 145.8 01-0323-06-00 GRADING -DRAINAGE PERMIT FEES 8,517.50 8,517.50 16,000.00 7,482.50 53.2 01-0323-10-00 SPRING VALLEY STAFF TIME REIMB .00 .00 10,000.00 10,000.00 .0 01-0323-11-00 AVIMOR STAFF TIME REIMBURSE .00 .00 85,000.00 85,000.00 .0 01-0323-12-00 PZ STAFF TIME REIMBURSE 46,176.25 46,176.25 .00 ( 46,176.25) .0 01-0324-01-00 TREE FUND 5,950.00 5,950.00 .00 ( 5,950.00) .0 01-0331-61-00 MATCHING GRANT .00 .00 100,000.00 100,000.00 .0 01-0331-63-00 GRANTS/MATCHING FUNDS .00 .00 50,000.00 50,000.00 .0 01-0335-10-00 STATE LIQUOR 530,072.00 530,072.00 678,514.00 148,442.00 78.1 01-0335-50-00 STATE SALES TAX, AG REPL 19.00 19.00 .00 ( 19.00) .0 01-0335-60-00 STATE REVENUE SHARING 2,344,146.22 2,344,146.22 3,019,563.00 675,416.78 77.6 01-0338-40-00 COURT FEES 38,261.24 38,261.24 30,000.00 ( 8,261.24) 127.5 01-0338-41-00 CITATION FEES/CODE ENFORCEMENT 15.00 15.00 500.00 485.00 3.0 01-0338-42-00 WEED ABATEMENT .00 .00 2,000.00 2,000.00 .0 01-0341-11-00 MISCELLANEOUS PERMITS/LICENSES 4,633.00 4,633.00 4,000.00 ( 633.00) 115.8 01-0341-12-00 ANIMAL CONTROL FEES 8,647.00 8,647.00 12,000.00 3,353.00 72.1 01-0341-13-00 ENGINEERING FEES -DEVELOPERS 283,539.26 283,539.26 150,000.00 ( 133,539.26) 189.0 01-0341-14-00 ATTORNEY FEES - DEVELOPER 22,375.00 22,375.00 15,000.00 ( 7,375.00) 149.2 01-0341-15-00 MISC REIMBURSEMENTS -DEVELOPERS 10,656.00 10,656.00 .00 ( 10,656.00) .0 01-0341-17-00 CID STAFF & MISC REIMBURSEMENT 4,724.88 4,724.88 1,000.00 ( 3,724.88) 472.5 01-0341-20-00 REIMBURSE FROM WATER DEPT 9,603.00 9,603.00 12,803.00 3,200.00 75.0 01-0341-21-00 PRESSURIZED IRRIGATION REIMB 10,561.82 10,561.82 .00 ( 10,561.82) .0 01-0341-26-00 BACKGROUND CHECKS 1,029.50 1,029.50 1,500.00 470.50 68.6 01-0341-27-00 URA CITY STAFF REIMBURSEMENT 2,207.88 2,207.88 4,800.00 2,592.12 46.0 01-0341-28-00 ID POWER SUBSTATION WATER USE 120.00 120.00 120.00 .00 100.0 01-0341-29-00 REVEL EAGLE-EASEMENT-MERRILL P 1,000.00 1,000.00 1,000.00 .00 100.0 01-0350-05-00 FIELD OF HONOR 27,357.10 27,357.10 10,000.00 ( 17,357.10) 273.6 01-0350-07-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 01-0371-25-00 BANK INVESTMENT INTEREST 9,290.75 9,290.75 7,000.00 ( 2,290.75) 132.7 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 3 01-0379-00-00 MISCELLANEOUS 01-0379-01-00 DUPLICATION/PUBLISHING/PRINTNG 01-0382-02-00 PROMOTIONAL SALES 01-0383-05-00 MISCELLANEOUS-REIMBURSEABLES 01-0383-09-00 ROOM RESERVATIONS 01-0383-14-00 SETTLEMENTS 01-0383-15-00 MISCELLANEOUS REVENUE 01-0383-16-00 INSURANCE REIMBURSEABLES 01-0385-00-00 FIRE DEPT IMPACT FEES 01-0399-00-00 CARRY OVER TOTAL FUND REVENUE CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 GENERALFUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT 2,613.60 2,613.60 1,000.00 ( 1,613.60) 261.4 406.33 406.33 500.00 93.67 81.3 510.00 510.00 .00 ( 510.00) .0 7,414.84 7,414.84 1,500.00 ( 5,914.84) 494.3 976.00 976.00 600.00 ( 376.00) 162.7 1,750,000.00 1,750,000.00 .00 ( 1,750,000.00) .0 2,677.20 2,677.20 .00 ( 2,677.20) .0 2,658.62 2,658.62 .00 ( 2,658.62) .0 265,044.12 265,044.12 538,200.00 273,155.88 49.3 .00 .00 5,560,218.00 5,560,218.00 .0 10,394,736.46 10,394,736.46 17,328,023.00 6,933,286.54 60.0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 4 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 GENERALFUND YTD ACTUAL BUDGET UNEXPENDED PCNT RESERVES 01-0410-19-00 RESERVES, EMERGENCIES TOTAL RESERVES ADMINISTRATION 01-0413-01-00 P&Z COMMISSIONERS COMPENSATION 01-0413-02-00 DESIGN REVIEW BRD COMPENSATION 01-0413-05-00 OFFICE EXPENSES 01-0413-06-00 PRINTING & DISTRIBUTION 01-0413-07-00 POSTAGE 01-0413-08-00 LEGAL ADVERTISING/PUBLICATION 01-0413-10-00 INSURANCE - PROPERTY 01-0413-12-00 PERSONNEL TRAINING 01-0413-13-00 TRAVEL & PER DIEM 01-0413-14-00 PROFESSIONAL DUES AND SERVICES 01-0413-25-00 MISCELLANEOUS 01-0413-28-00 RESOURCE MATERIALS 01-0413-29-00 REAL PROPERTY TAXES/CITY 01-0413-31-00 ENGINEERING FEE/DEVELOPER CHGS 01-0413-33-00 ATTORNEY FEE -CHARGE DEVELOPERS 01-0413-37-00 BACKGROUND CHECK-PERMITS/LIC 01-0413-40-00 INSURANCE REIMBURSEABLES 01-0413-44-00 PHOTOS - MAYOR/CITY COUNCIL 01-0413-46-00 PROPERTY TAX EXP -3% 01-0413-50-00 JOB POSTINGS 01-0413-51-00 BACKGROUND CHK, PRE -EMPLOYMENT 01-0413-52-00 DRUG TESTING, PRE -EMPLOYMENT IEel r1 W 1o1ITAI101F31 ZT-AIEeP► PERSONNEL 01-0415-11-00 SALARIES - COUNCIL 01-0415-21-00 FICA 01-0415-22-00 PERSI 01-0415-23-01 HRA/COBRAADMIN FEES 01-0415-24-00 WORKERS' COMPENSATION 01-0415-24-01 WORK COMP/BOARDS-COMMISSIONS 01-0415-25-00 INSURANCE 01-0415-28-00 UNEMPLOYMENT BENEFITS TOTAL PERSONNEL .00 .00 480,673.00 480,673.00 .0 .00 .00 480,673.00 480,673.00 .0 2,810.00 2,810.00 4,200.00 1,390.00 66.9 3,580.00 3,580.00 5,000.00 1,420.00 71.6 14,029.54 14,029.54 25,000.00 10,970.46 56.1 19.50 19.50 2,500.00 2,480.50 .8 8,436.87 8,436.87 9,000.00 563.13 93.7 2,141.84 2,141.84 8,000.00 5,858.16 26.8 51,438.00 51,438.00 57,000.00 5,562.00 90.2 265.00 265.00 3,000.00 2,735.00 8.8 .00 .00 2,000.00 2,000.00 .0 60,328.85 60,328.85 163,827.00 103,498.15 36.8 287.70 287.70 40,000.00 39,712.30 .7 5,031.05 5,031.05 4,500.00 ( 531.05) 111.8 231.58 231.58 225.00 ( 6.58) 102.9 320,119.43 320,119.43 150,000.00 ( 170,119.43) 213.4 24,887.00 24,887.00 15,000.00 ( 9,887.00) 165.9 3,462.28 3,462.28 1,250.00 ( 2,212.28) 277.0 6,401.50 6,401.50 .00 ( 6,401.50) .0 172.33 172.33 900.00 727.67 19.2 .00 .00 250.00 250.00 .0 3,567.25 3,567.25 6,000.00 2,432.75 59.5 237.79 237.79 1,500.00 1,262.21 15.9 800.00 800.00 1,500.00 700.00 53.3 508,247.51 508,247.51 500,652.00 ( 7,595.51) 101.5 38,160.00 38,160.00 50,880.00 12,720.00 75.0 2,919.24 2,919.24 4,500.00 1,580.76 64.9 4,556.16 4,556.16 6,200.00 1,643.84 73.5 598.11 598.11 1,800.00 1,201.89 33.2 38,127.63 38,127.63 54,374.00 16,246.37 70.1 69.76 69.76 100.00 30.24 69.8 .00 .00 12,000.00 12,000.00 .0 2,731.97 2,731.97 .00 ( 2,731.97) .0 87,162.87 87,162.87 129,854.00 42,691.13 67.1 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 5 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 GENERALFUND YTD ACTUAL BUDGET UNEXPENDED PCNT CONTRACTS & AGREEMENTS 01-0416-02-00 CITYATTORNEY 88,766.50 88,766.50 250,000.00 161,233.50 35.5 01-0416-02-02 LITIGATION ATTORNEYS FEES 3,647.00 3,647.00 50,000.00 46,353.00 7.3 01-0416-05-00 PROSECUTOR 53,334.00 53,334.00 65,500.00 12,166.00 81.4 01-0416-06-00 IDAHO HUMANE SOCIETY 108,431.26 108,431.26 144,575.00 36,143.74 75.0 01-0416-07-00 CITY ENGINEERING 286.25 286.25 50,000.00 49,713.75 .6 01-0416-07-04 PARK/REC ENGINEERING FEES .00 .00 20,000.00 20,000.00 .0 01-0416-08-00 CITY AUDITOR SERVICES 17,250.00 17,250.00 21,000.00 3,750.00 82.1 01-0416-09-00 LAW ENFORCEMENT DEPARTMENT 2,679,505.12 2,679,505.12 3,572,672.00 893,166.88 75.0 01-0416-23-00 GRANT WRITER .00 .00 15,000.00 15,000.00 .0 01-0416-34-00 BUDGET RESERVES, FY 1STQTR .00 .00 1,500,000.00 1,500,000.00 .0 01-0416-35-00 ADMINISTRATION RESERVES 14,720.50 14,720.50 200,000.00 185,279.50 7.4 01-0416-46-00 ALLUMBAUGH HOUSE 13,311.75 13,311.75 17,749.00 4,437.25 75.0 01-0416-49-00 DRUGFREE IDAHO 1,254.42 1,254.42 1,090.00 ( 164.42) 115.1 01-0416-54-00 IDAHO SUICIDE PREVENTION 10,000.00 10,000.00 10,000.00 .00 100.0 01-0416-55-00 EAGLE SENIOR CENTER 37,500.00 37,500.00 50,000.00 12,500.00 75.0 01-0416-56-00 CRIME STOPPERS 3,500.00 3,500.00 3,500.00 .00 100.0 TOTAL CONTRACTS &AGREEMENTS 3,031,506.80 3,031,506.80 5,971,086.00 2,939,579.20 50.8 CODE ENFORCEMENT 01-0417-00-00 WEED ABATEMENT .00 .00 2,000.00 2,000.00 .0 TOTAL CODE ENFORCEMENT .00 .00 2,000.00 2,000.00 .0 GRANTS 01-0421-01-00 GRANTS/MATCHING FUNDS .00 .00 100,000.00 100,000.00 .0 01-0421-03-00 MATCHING GRANT .00 .00 50,000.00 50,000.00 .0 TOTAL GRANTS .00 .00 150,000.00 150,000.00 .0 RESTRICTED 01-0422-06-00 FIELD OF HONOR 3,903.82 3,903.82 10,000.00 6,096.18 39.0 01-0422-15-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 TOTAL RESTRICTED 3,903.82 3,903.82 14,000.00 10,096.18 27.9 CONTINUING EDUCATION 01-0461-01-00 CONTINUING EDUCATION 2,626.00 2,626.00 3,800.00 1,174.00 69.1 TOTAL CONTINUING EDUCATION 2,626.00 2,626.00 3,800.00 1,174.00 69.1 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 GENERALFUND YTD ACTUAL BUDGET UNEXPENDED PCNT PUBLIC AFFAIRS/COMM RELATIONS 01-0462-01-00 PUBLIC RELATIONS 01-0462-02-00 AWARDS & RECOGNITIONS 01-0462-03-00 CITY BRANDING/LOGO TOTAL PUBLIC AFFAIRS/COMM RELATIONS GENERAL FUND TRANSFERS 01-0463-01-00 MUSEUM DEPT TRANSFER 01-0463-02-00 ARTS COMMISSION TRANSFER 01-0463-04-00 HISTORICAL COMMISSION TRANSFER 01-0463-05-00 SPECIAL EVENTS TRANSFER 01-0463-06-00 RECREATION PARKS-REC TRANSFER 01-0463-07-00 CAPITAL PROJECTS TRANSFER 01-0463-08-00 EAGLE FUN DAYS TRANSFER 01-0463-11-00 PUBLIC WORKS TRANSFER 01-0463-11-01 EXECUTIVE DEPT TRANSFER 01-0463-12-00 CITY HALL BOND FUND TRANSFER 01-0463-12-01 CLERK/TREAS DEPT TRANSFER 01-0463-13-01 BUILDING DEPT TRANSFER 01-0463-14-01 PLANNING AND ZONING DEPT TRANS 01-0463-18-01 IT DEPT TRANSFER 01-0463-26-01 ECONOMIC DEV DEPT TRANSFER TOTAL GENERAL FUND TRANSFERS COMMUNITY PROJECTS -CAP OUTLAY 01-0468-10-00 VRT HWY 44 EXPRESS SRV ENHANC 01-0468-10-01 VRT EAGLE SENIOR CITIZENS TOTAL COMMUNITY PROJECTS -CAP OUTLA FIRE DEPARTMENT IMPACT FEES 01-0469-00-00 FIRE DEPT IMPACT FEES TOTAL FIRE DEPARTMENT IMPACT FEES TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES 3,545.40 3,545.40 6,000.00 2,454.60 59.1 957.08 957.08 1,500.00 542.92 63.8 .00 .00 5,000.00 5,000.00 .0 4,502.48 4,502.48 12,500.00 7,997.52 36.0 47,664.30 47,664.30 142,185.00 94,520.70 33.5 .00 .00 44,901.00 44,901.00 .0 .00 .00 3,118.00 3,118.00 .0 .00 .00 221,095.00 221,095.00 .0 .00 .00 443,770.00 443,770.00 .0 .00 .00 1,708,900.00 1,708,900.00 .0 39,627.08 39,627.08 90,000.00 50,372.92 44.0 431, 935.01 431,935.01 2,167, 755.00 1, 735, 819.99 19.9 215,268.79 215,268.79 400,030.00 184,761.21 53.8 8,293.95 8,293.95 102,950.00 94,656.05 8.1 422,884.32 422,884.32 626,550.00 203,665.68 67.5 742,870.29 742,870.29 1,156,430.00 413,559.71 64.2 703,843.57 703,843.57 1,214,100.00 510,256.43 58.0 551,313.18 551,313.18 893,820.00 342,506.82 61.7 145,720.19 145,720.19 212,056.00 66,335.81 68.7 3,309,420.68 3,309,420.68 9,427,660.00 6,118,239.32 35.1 2,644.00 2,644.00 87,898.00 85,254.00 3.0 9,700.00 9,700.00 9,700.00 .00 100.0 12,344.00 12,344.00 97,598.00 85,254.00 12.7 249,795.12 249,795.12 538,200.00 288,404.88 46.4 249,795.12 249,795.12 538,200.00 288,404.88 46.4 7,209,509.28 3,185,227.18 7,209,509.28 17,328,023.00 10,118,513.72 41.6 3,185,227.18 .00 ( 3,185,227.18) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 7 06-0101-00-00 CASH 06-0103-00-00 LIBRARY/PETTY CASH 06-0104-00-00 PETTY CASH-CHILDRENS PROGRAMS 06-0107-00-00 LIBRARY/TAXES RECEIVABLE 06-0151-25-00 FIRST INTERSTATE INVESTMENT 06-0170-00-00 HRA 10% DEPOSIT TOTALASSETS LIABILITIES AND EQUITY LIABILITIES 06-0202-00-00 LIBRARY/VOUCHERS PAYABLE 06-0216-00-00 LIBRARY/ACCRUED PAYROLL 06-0217-01-00 LIBRARY/STATE WITHHOLDING 06-0217-02-00 LIBRARY/FEDERAL WITHHOLDNG TAX 06-0217-03-00 LIBRARY/FICA 06-0217-04-00 LIBRARY/PUBLIC RETIREMENT 06-0217-04-01 LIBRARY/PERSI 401K CHOICE PLAN 06-0217-07-00 LIBRARY HEALTH INSURANCE 06-0217-09-00 WORKERS' COMPENSATION 06-0217-10-00 HSACONTRIBUTION 06-0226-00-00 DEFERRED REVENUE TOTAL LIABILITIES FUND EQUITY 06-0271-00-00 LIBRARY/FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 LIBRARY FUND 13,938.73 300.00 300.00 8,865.78 1,024,259.37 1,872.00 46.07 19,220.15 ( 467.80) ( 1,239.74) ( .64) 814.48 ( 1,023.75) 9,739.99 13,992.98 2,454.00 7.786.25 1,049,535.88 51,321.99 832,267.12 165,946.77 165,946.77 998,213.89 1,049,535.88 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 8 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 06-0356-00-00 LIBRARY/PROPERTY TAX REVENUE 06-0356-01-00 LIBRARY/PENALTY & INT PROP TXS 06-0361-20-00 LIBRARY/FINES/FEES 06-0361-20-01 LOST ITEMS 06-0361-21-00 LIBRARY/COPY MACHINE REVENUE 06-0361-21-01 3 D PRINTING 06-0371-25-00 BANK INTEREST 06-0379-00-00 MISCELLANEOUS 06-0399-00-00 CARRY OVER 06-0399-01-00 BUDGET RESERVE, FY 1ST QTR TOTAL FUND REVENUE EXPENDITURES RESERVES 06-0410-01-00 RESERVES TOTAL RESERVES CONTRACTS/AGREEMENTS 1,061,311.34 1,061,311.34 1,492,845.00 431,533.66 71.1 1,462.76 1,462.76 1,000.00 ( 462.76) 146.3 2,402.47 2,402.47 .00 ( 2,402.47) .0 4,023.37 4,023.37 2,500.00 ( 1,523.37) 160.9 1,289.98 1,289.98 3,600.00 2,310.02 35.8 4.92 4.92 400.00 395.08 1.2 1,343.99 1,343.99 700.00 ( 643.99) 192.0 7,281.33 7,281.33 750.00 ( 6,531.33) 970.8 .00 .00 120,040.00 120,040.00 .0 .00 .00 450,000.00 450,000.00 .0 1,079,120.16 1,079,120.16 2,071,835.00 992,714.84 52.1 .00 .00 460,000.00 460,000.00 .0 .00 .00 460,000.00 460,000.00 .0 06-0416-01-00 LEGAL -CITY ATTORNEY 822.50 822.50 10,000.00 9,177.50 8.2 06-0416-02-00 PHOTOCOPIERS 4,061.48 4,061.48 14,570.00 10,508.52 27.9 TOTAL CONTRACTS/AGREEMENTS 4,883.98 4,883.98 24,570.00 19,686.02 19.9 OPERATIONS & MAINTENANCE 06-0420-01-00 ADMINISTRATION 16,497.56 16,497.56 15,000.00 ( 1,497.56) 110.0 06-0420-03-00 OPERATIONS SUBSCRIPTIONS 32,525.70 32,525.70 41,310.00 8,784.30 78.7 06-0420-04-00 MARKETING 13,741.65 13,741.65 11,300.00 ( 2,441.65) 121.6 06-0420-04-01 OUTREACH 2O.51 20.51 2,500.00 2,479.49 .8 06-0420-05-00 OFFICE SUPPLIES 6,413.83 6,413.83 9,373.00 2,959.17 68.4 06-0420-05-01 MATERIAL PROCESSING SUPPLIES 2,805.27 2,805.27 8,000.00 5,194.73 35.1 06-0420-06-00 UNIFORMS 2,904.76 2,904.76 3,905.00 1,000.24 74.4 06-0420-07-00 SMALL FURNITURE REPLACEMENT 5,809.21 5,809.21 1,400.00 ( 4,409.21) 414.9 06-0420-09-00 MAINTENANCE AGREEMENTS 13,563.00 13,563.00 31,194.00 17,631.00 43.5 06-0420-10-00 POSTAGE 1,080.36 1,080.36 2,500.00 1,419.64 43.2 06-0420-11-00 SUBSCRIPTIONS & MEMBERSHIPS 3,299.63 3,299.63 11,000.00 7,700.37 30.0 06-0420-13-00 PRINTING AND PUBLISHING 909.10 909.10 1,500.00 590.90 60.6 TOTAL OPERATIONS & MAINTENANCE 99,570.58 99,570.58 138,982.00 39,411.42 71.6 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT LYNX1 CONSORTIUM 06-0430-00-00 LYNK! SYSTEM 06-0430-02-00 LYNX! COURIER TOTAL LYNX1 CONSORTIUM COST RECOVERY OR PASS THRU 06-0435-00-00 CREDIT CARD PROCESSING FEE 06-0435-01-00 3D PRINTING 06-0435-02-00 LOST ITEMS REFUNDS 06-0435-03-00 OPEN ACCESS TOTAL COST RECOVERY OR PASS THRU TECHNOLOGY 06-0440-00-00 COMPUTER SOFTWARE 06-0440-01-00 COMPUTER MAINTENANCE & REPAIR 06-0440-02-00 COMPUTER EQUIPMENT (SMALL) TOTAL TECHNOLOGY GUEST RESOURCES 06-0450-00-00 BOOKS 06-0450-01-00 PRINT VENDOR PROCESSING 06-0450-02-00 BOOKS -DIGITAL 06-0450-03-00 MAGAZINES & NEWSPAPERS 06-0450-03-01 MAGAZINES - DIGITAL 06-0450-04-00 MEDIA 06-0450-05-00 MEDIA- DIGITAL 06-0450-06-00 DATABASES 06-0450-07-00 HOTSPOT TOTAL GUEST RESOURCES GUEST CLASSES & EVENTS 06-0455-00-00 CLASSES & EVENTS TOTAL GUEST CLASSES & EVENTS PERSONNEL 06-0461-10-00 SALARIES - FULL TIME 06-0461-10-01 SALARIES - PERSONNEL SERVICES 06-0461-11-00 OVERTIME 06-0461-15-00 SALARIES - PART TIME FOR ADMINISTRATION USE ONLY 18,144.06 18,144.06 24,192.00 6,047.94 75.0 8,212.57 8,212.57 11,600.00 3,387.43 70.8 26,356.63 26,356.63 35,792.00 9,435.37 73.6 2,233.85 2,233.85 2,700.00 466.15 82.7 .00 .00 2,600.00 2,600.00 .0 23.00 23.00 1,700.00 1,677.00 1.4 890.56 890.56 1,200.00 309.44 74.2 3,147.41 3,147.41 8,200.00 5,052.59 38.4 .00 .00 13,650.00 13,650.00 .0 .00 .00 1,250.00 1,250.00 .0 3,542.74 3,542.74 3,163.00 ( 379.74) 112.0 3,542.74 3,542.74 18,063.00 14,520.26 19.6 73,297.68 73,297.68 136,301.00 63,003.32 53.8 4,979.40 4,979.40 6,000.00 1,020.60 83.0 21,321.30 21,321.30 61,919.00 40,597.70 34.4 594.37 594.37 5,920.00 5,325.63 10.0 11,014.00 11,014.00 9,606.00 ( 1,408.00) 114.7 63,926.55 63,926.55 74,057.00 10,130.45 86.3 36,001.99 36,001.99 61,609.00 25,607.01 58.4 5,176.00 5,176.00 11,050.00 5,874.00 46.8 2,088.87 2,088.87 5,562.00 3,473.13 37.6 218,400.16 218,400.16 372,024.00 153,623.84 58.7 16,452.75 16,452.75 25,000.00 8,547.25 65.8 16,452.75 16,452.75 25,000.00 8,547.25 65.8 242,160.22 242,160.22 453,000.00 210,839.78 53.5 24,872.05 24,872.05 .00 ( 24,872.05) .0 3,160.25 3,160.25 5,000.00 1,839.75 63.2 126,218.99 126,218.99 221,600.00 95,381.01 57.0 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 10 06-0461-15-01 SALARIES - PERSONNEL SERVICES 06-0461-21-00 FICA 06-0461-22-00 PERSI 06-0461-23-00 HRA BUY -DOWN 06-0461-23-01 HRA/COBRAADMIN FEES 06-0461-24-00 WORKERS' COMPENSATION 06-0461-25-00 INSURANCE 06-0461-26-00 HSA CONTRIBUTION 06-0461-27-00 PTO CASH OUT 06-0461-28-00 UNEMPLOYMENT BENEFITS 06-0461-29-00 EMPLOYMENT TESTING TOTAL PERSONNEL STAFF DEVELOPMENT 06-0463-00-00 TRAVEL & PER DIEM 06-0463-01-00 MILEAGE REIMBURSEMENT 06-0463-02-00 TRAINING 06-0463-03-00 CONTINUING EDUCATION 06-0463-04-00 RECRUITMENT 06-0463-06-00 TRUSTEE-TRAVEL/MEETINGS 06-0463-08-00 VIRTUALTRAINING TOTAL STAFF DEVELOPMENT FACILITY (BLDGS & GROUNDS) 06-0464-00-00 BUILDING 06-0464-01-00 BUILDING SUPPLIES 06-0464-02-00 UTILITIES 06-0464-03-00 TELEPHONE 06-0464-04-00 SECURITY SYSTEM 06-0464-05-00 CUSTODIAL 06-0464-06-00 GROUNDS 06-0464-07-00 FLOOR MATS TOTAL FACILITY (BLDGS & GROUNDS) TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 LIBRARY FUND YTD ACTUAL 8,856.64 8,856.64 28,264.07 28,264.07 29,811.51 29,811.51 .00 .00 598.09 598.09 2,478.64 2,478.64 29,530.50 29,530.50 1,890.00 1,890.00 4,533.95 4,533.95 .00 .00 .00 .00 502,374.91 502,374.91 BUDGET UNEXPENDED PCNT .00 ( 8,856.64) .0 51,990.00 23,725.93 54.4 54,050.00 24,238.49 55.2 5,500.00 5,500.00 .0 900.00 301.91 66.5 5,476.00 2,997.36 45.3 67,788.00 38,257.50 43.6 5,760.00 3,870.00 32.8 20,000.00 15,466.05 22.7 18,540.00 18,540.00 .0 1,000.00 1,000.00 .0 910,604.00 408,229.09 55.2 550.00 550.00 17,300.00 16,750.00 3.2 .00 .00 1,000.00 1,000.00 .0 790.15 790.15 2,200.00 1,409.85 35.9 14,086.78 14,086.78 12,500.00 ( 1,586.78) 112.7 324.00 324.00 1,000.00 676.00 32.4 .00 .00 5,600.00 5,600.00 .0 2,510.35 2,510.35 1,500.00 ( 1,010.35) 167.4 18,261.28 18,261.28 41,100.00 22,838.72 44.4 8.00 8.00 1,500.00 1,492.00 .5 .00 .00 1,500.00 1,500.00 .0 16,905.17 16,905.17 27,000.00 10,094.83 62.6 1,671.12 1,671.12 2,000.00 328.88 83.6 534.96 534.96 3,000.00 2,465.04 17.8 104.93 104.93 .00 ( 104.93) .0 .00 .00 1,000.00 1,000.00 .0 958.77 958.77 1,500.00 541.23 63.9 20,182.95 20,182.95 37,500.00 17,317.05 53.8 913,173.39 165,946.77 913,173.39 2,071,835.00 1,158,661.61 44.1 165,946.77 .00 ( 165,946.77) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 11 LIABILITIES AND EQUITY LIABILITIES 07-0217-01-00 STATE WITHHOLDING 07-0217-02-00 FEDERAL WITHHOLDING TAX 07-0217-03-00 FICA 07-0217-04-00 MUSEUM/PERSI RETIREMENT 07-0217-04-01 MUSEUM 401 K PERSI CHOICE 07-0217-07-00 MUSEUM HEALTH INSURANCE 07-0217-09-00 WORKERS' COMPENSATION TOTAL LIABILITIES FUND EQUITY 07-0271-00-00 MUSEUM FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 MUSEUM FUND ( 84.00) ( 163.13) ( 81.00) ( 167.97) ( 64.23) 860.82 1,436.52 1,737.01 43,745.48 ( 45,482.49) ( 45,482.49) ( 1,737.01) .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 12 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 MUSEUM FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 07-0316-12-00 FUNDING FROM GENERAL FUND 07-0376-00-00 MUSEUM CONTRIBUTIONS/DONATIONS 07-0379-00-00 MUSEUM MISC REVENUE 07-0379-02-00 ARCADIA BOOKS SALES/ROYALTI ES 07-0379-03-00 SALES TAX REVENUE 07-0380-00-00 GIFT SHOP REVENUE 07-0399-00-00 CARRY OVER TOTAL FUND REVENUE EXPENDITURES PERSONNEL 07-0420-10-00 SALARIES - FULL TIME 07-0420-15-00 SALARIES - PART TIME 07-0420-15-01 SALARIES - PERSONNEL SERVICES 07-0420-21-00 FICA 07-0420-22-00 PERSI 07-0420-24-00 WORKERS' COMPENSATION 07-0420-25-00 INSURANCE 07-0420-27-00 HRA BUY DOWN TOTAL PERSONNEL EDUCATION 07-0461-02-00 ASSOCIATION MEMBERSHIP 07-0461-03-00 CONFERENCES & SEMINARS 07-0461-04-00 TRAVEL & PER DIEM TOTAL EDUCATION ADMINISTRATION 07-0462-30-00 CONSERVATION/PRESERVATION 07-0462-31-00 OFFICE SUPPLIES 07-0462-32-00 ARCHIVAL SUPPLIES 07-0462-33-00 PUBLICITY -PRINTING 07-0462-34-00 RESEARCH MATERIAL 07-0462-35-00 UNIFORMS 07-0462-68-00 MUSEUM PROGRAMS 07-0462-69-00 MISCELLANEOUS 07-0462-73-00 EAGLE BOOK-ARCADIA PUBLISHING TOTAL ADMINISTRATION 47,664.30 47,664.30 142,185.00 94,520.70 33.5 848.92 848.92 150.00 ( 698.92) 566.0 26.00 26.00 25.00 ( 1.00) 104.0 198.28 198.28 400.00 201.72 49.6 1.30 1.30 5.00 3.70 26.0 17.00 17.00 100.00 83.00 17.0 .00 .00 14,000.00 14,000.00 .0 48,755.80 48,755.80 156,865.00 108,109.20 31.1 40,553.44 40,553.44 57,500.00 16,946.56 70.5 17,837.71 17,837.71 52,500.00 34,662.29 34.0 7,450.36 7,450.36 .00 ( 7,450.36) .0 4,466.79 4,466.79 7,500.00 3,033.21 59.6 4,842.10 4,842.10 6,800.00 1,957.90 71.2 110.96 110.96 .00 ( 110.96) .0 2,109.87 2,109.87 7,600.00 5,490.13 27.8 .00 .00 1,540.00 1,540.00 .0 77,371.23 77,371.23 133,440.00 56,068.77 58.0 309.50 309.50 325.00 15.50 95.2 310.00 310.00 1,500.00 1,190.00 20.7 .00 .00 3,500.00 3,500.00 .0 619.50 619.50 5,325.00 4,705.50 11.6 .00 .00 1,000.00 1,000.00 .0 622.41 622.41 .00 ( 622.41) .0 678.97 678.97 1,000.00 321.03 67.9 21.67 21.67 1,000.00 978.33 2.2 208.90 208.90 100.00 ( 108.90) 208.9 .00 .00 400.00 400.00 .0 884.64 884.64 2,000.00 1,115.36 44.2 619.86 619.86 200.00 ( 419.86) 309.9 .00 .00 300.00 300.00 .0 3,036.45 3,036.45 6,000.00 2,963.55 50.6 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 13 EXHIBITS 07-0463-01-00 DISPLAY SUPPLIES 07-0463-02-00 EXHIBIT ITEMS 07-0463-03-00 EXHIBIT CONSTRUCTION 07-0463-04-00 ANNUAL EXHIBIT TOTAL EXHIBITS PROGRAMS 07-0464-08-00 GIFT SHOP SUPPLIES TOTAL PROGRAMS TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 MUSEUM FUND YTD ACTUAL BUDGET UNEXPENDED PCNT 206.83 206.83 300.00 93.17 68.9 .00 .00 500.00 500.00 .0 2,398.90 2,398.90 1,000.00 ( 1,398.90) 239.9 10,605.38 10,605.38 10,000.00 ( 605.38) 106.1 13,211.11 13,211.11 11,800.00 ( 1,411.11) 112.0 .00 .00 300.00 300.00 .0 .00 .00 300.00 300.00 .0 94,238.29 94,238.29 156,865.00 62,626.71 60.1 ( 45,482.49) ( 45,482.49) .00 45,482.49 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 14 CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 PARK IMPACT FEE FUND ASSETS 08-0101-00-00 CASH 39,600.59 08-0151-25-00 FIRST INTERSTATE INVESTMENT 3,865,739.20 TOTAL ASSETS 3,905,339.79 LIABILITIES AND EQUITY FUND EQUITY 08-0271-00-00 PARK FUND/FUND BALANCE 3,700,742.90 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 204,596.89 BALANCE - CURRENT DATE 204,596.89 TOTAL FUND EQUITY 3,905,339.79 TOTAL LIABILITIES AND EQUITY 3,905,339.79 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 15 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 PARK IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 08-0322-19-00 PARKS DEVELOPMENT IMPACT FEES 08-0364-01-00 CONTRIBUTIONS AND DONATIONS 08-0371-25-00 BANK INTEREST 08-0399-00-00 CARRY OVER TOTAL FUND REVENUE EXPENDITURES CAPITAL IMPROVEMENTS 08-0438-37-00 CAPITAL IMPROVEMENTS TOTAL CAPITAL IMPROVEMENTS TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES 265,541.36 265,541.36 669,432.00 403,890.64 39.7 .00 .00 288,286.00 288,286.00 .0 4,996.30 4,996.30 4,200.00 ( 796.30) 119.0 .00 .00 4,732,830.00 4,732,830.00 .0 270,537.66 270,537.66 5,694,748.00 5,424,210.34 4.8 65,940.77 65,940.77 5,694,748.00 5,628,807.23 1.2 65,940.77 65,940.77 5,694,748.00 5,628,807.23 1.2 65,940.77 65,940.77 5,694,748.00 5,628,807.23 1.2 204,596.89 204,596.89 .00 ( 204,596.89) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 16 09-0101-00-00 CASH TOTALASSETS LIABILITIES AND EQUITY LIABILITIES 09-0217-01-00 STATE WITHHOLDING 09-0217-02-00 FEDERAL WITHHOLDING TAX 09-0217-03-00 FICA 09-0217-04-00 PUBLIC RETIREMENT 09-0217-04-01 401 K PERSI CHOICE PLAN 09-0217-07-00 HEALTH INSURANCE 09-0217-09-00 WORKERS' COMPENSATION 09-0217-10-00 HSACONTRIBUTION TOTAL LIABILITIES FUND EQUITY 09-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 RECREATION - SPECIAL EVENTS 81, 717.22 126.50) 200.04) 228.15) 257.86) 7.50) 11,455.37 13,907.27 3,319.35 81, 717.22 27,861.94 126,879.30 ( 73,024.02) ( 73,024.02) 53,855.28 81, 717.22 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 17 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 RECREATION - SPECIAL EVENTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT 09-0301-00-00 FUNDING FROM GENERAL FUND 09-0347-06-00 CHRISTMAS MARKET 09-0347-08-00 SATURDAY MARKET 09-0347-10-00 GAZEBO CONCERT SERIES 09-0347-11-00 HARVEST FEST MARKET 09-0376-13-00 SPONSORSHIPS 09-0376-15-00 EVENT APPLICATION FEES 09-0376-17-00 SECURITY DEPOSIT TOTAL FUND REVENUE EXPENDITURES PERSONNEL 09-0420-10-00 SALARIES - FULL TIME 09-0420-11-00 OVERTIME 09-0420-15-00 SALARIES - PART TIME 09-0420-21-00 FICA 09-0420-22-00 PERSI 09-0420-24-00 WORKERS' COMPENSATION 09-0420-25-00 INSURANCE 09-0420-26-00 HSA CONTRIBUTION 09-0420-29-00 PTO CASH OUT TOTAL PERSONNEL ADMINISTRATION 09-0463-11-00 OFFICE SUPPLIES 09-0463-12-00 PROMOTIONS 09-0463-19-00 TRAINING 09-0463-20-00 TRAVEL/PER DIEM 09-0463-21-00 PROFESSIONAL DUES 09-0463-22-00 UNIFORMS 09-0463-23-00 GAS/MILEAGE 09-0463-25-00 SECURITY DEPOSIT REFUND 09-0463-26-00 MEMBERSHIPS TOTAL ADMINISTRATION ACTIVITIES 09-0467-02-00 EAGLE SATURDAY MARKET 09-0467-03-00 CHRISTMAS MARKET 09-0467-04-00 GAZEBO CONCERT SERIES .00 .00 221,095.00 221,095.00 .0 3,583.44 3,583.44 2,750.00 ( 833.44) 130.3 20,886.82 20,886.82 22,500.00 1,613.18 92.8 3,030.00 3,030.00 825.00 ( 2,205.00) 367.3 487.41 487.41 2,750.00 2,262.59 17.7 .00 .00 15,000.00 15,000.00 .0 2,000.00 2,000.00 1,500.00 ( 500.00) 133.3 .00 .00 1,200.00 1,200.00 .0 29,987.67 29,987.67 267,620.00 237,632.33 11.2 54,240.91 54,240.91 118,800.00 64,559.09 45.7 637.74 637.74 2,000.00 1,362.26 31.9 863.29 863.29 26,700.00 25,836.71 3.2 4,203.92 4,203.92 11,400.00 7,196.08 36.9 6,310.95 6,310.95 14,300.00 7,989.05 44.1 1,714.74 1,714.74 .00 ( 1,714.74) .0 5,137.31 5,137.31 15,920.00 10,782.69 32.3 850.00 850.00 .00 ( 850.00) .0 .00 .00 2,500.00 2,500.00 .0 73,958.86 73,958.86 191,620.00 117,661.14 38.6 103.24 103.24 800.00 696.76 12.9 4,967.65 4,967.65 14,000.00 9,032.35 35.5 328.55 328.55 1,200.00 871.45 27.4 1,103.02 1,103.02 4,000.00 2,896.98 27.6 1,766.90 1,766.90 2,150.00 383.10 82.2 190.50 190.50 600.00 409.50 31.8 .00 .00 100.00 100.00 .0 .00 .00 1,200.00 1,200.00 .0 .00 .00 700.00 700.00 .0 8,459.86 8,459.86 24,750.00 16,290.14 34.2 4,872.97 4,872.97 11,000.00 6,127.03 44.3 9,715.02 9,715.02 6,500.00 ( 3,215.02) 149.5 2,350.00 2,350.00 8,750.00 6,400.00 26.9 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 18 09-0467-05-00 GENERAL EVENTS 09-0467-06-00 EAGLE HARVEST FEST 09-0467-07-00 EVENT EQUIPMENT PURCHASES 09-0467-08-00 EVENT EQUIPMENT RENTAL TOTAL ACTIVITIES TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 RECREATION - SPECIAL EVENTS YTD ACTUAL 750.00 750.00 2,154.98 2,154.98 .00 .00 750.00 750.00 20,592.97 20,592.97 103, 011.69 103, 011.69 ( 73,024.02) ( 73,024.02) BUDGET UNEXPENDED PCNT 10,000.00 9,250.00 7.5 4,000.00 1,845.02 53.9 3,000.00 3,000.00 .0 8,000.00 7,250.00 9.4 51,250.00 30,657.03 40.2 267,620.00 164,608.31 38.5 .00 73,024.02 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 19 CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 EAGLE HISTORICAL COMMISSION ASSETS 10-0101-00-00 CASH 21,016.85 TOTALASSETS LIABILITIES AND EQUITY FUND EQUITY 10-0271-00-00 FUND BALANCE 19,283.33 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 1,733.52 BALANCE - CURRENT DATE 1.733.52 TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY 21, 016.85 21,016.85 21, 016.85 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 20 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 EAGLE HISTORICAL COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT 10-0316-12-00 FUNDING FROM GENERAL FUND 10-0333-01-00 GRANTS, STATE 10-0399-00-00 CARRY OVER TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION 10-0462-02-00 PUBLICITY - PRINTING 10-0462-05-00 EDUCATION/TRAINING TOTAL ADMINISTRATION PROGRAMS 10-0464-07-00 PRESERVATION 10-0464-08-00 COMM ENGAGEMENT/SPECIAL EVENTS TOTAL PROGRAMS GRANTS 10-0465-02-00 MUNICIPAL GRANT FUNDS TOTAL GRANTS TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES .00 .00 3,118.00 3,118.00 .0 1,733.52 1,733.52 .00 ( 1,733.52) .0 .00 .00 5,882.00 5,882.00 .0 1,733.52 1,733.52 9,000.00 7,266.48 19.3 .00 .00 1,000.00 1,000.00 .0 .00 .00 500.00 500.00 .0 .00 .00 1,500.00 1,500.00 .0 .00 .00 1,000.00 1,000.00 .0 .00 .00 500.00 500.00 .0 .00 .00 1,500.00 1,500.00 .0 .00 .00 6,000.00 6,000.00 .0 .00 .00 6,000.00 6,000.00 .0 .00 .00 9,000.00 9,000.00 .0 1,733.52 1,733.52 .00 ( 1,733.52) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 21 CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 EXECUTIVE DEPARTMENT LIABILITIES AND EQUITY LIABILITIES 11-0216-00-00 ACCRUED PAYROLL 1,750.00 11-0217-01-00 STATE WITHHOLDING ( 268.60) 11-0217-02-00 FEDERAL WITHHOLDING TAX ( 786.85) 11-0217-03-00 FICA ( 803.97) 11-0217-04-00 EXEC DEPT/PUBLIC RETIREMENT ( 950.46) 11-0217-04-01 EXEC DEPT/401K PERSI CHOICE ( 50.97) 11-0217-07-00 EXEC DEPT HEALTH INSURANCE 1,285.91 11-0217-09-00 WORKERS' COMPENSATION 5,214.65 11-0217-10-00 HSA CONTRIBUTION ( 224.00) TOTAL LIABILITIES 5,165.71 FUND EQUITY 11-0271-00-00 FUND BALANCE ( 6,073.74) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 908.03 BALANCE - CURRENT DATE 908.03 TOTAL FUND EQUITY ( 5,165.71) TOTAL LIABILITIES AND EQUITY .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 22 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 EXECUTIVE DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 11-0301-00-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION 11-0413-04-00 UNIFORMS 11-0413-05-00 OFFICE EXPENSES 11-0413-12-00 PERSONNEL TRAINING 11-0413-13-00 TRAVEL & PER DIEM 11-0413-14-00 PROFESSIONAL DUES TOTAL ADMINISTRATION PERSONNEL 11-0415-10-00 SALARIES - FULL TIME 11-0415-11-00 OVERTIME 11-0415-21-00 FICA 11-0415-22-00 PERSI 11-0415-24-00 WORKERS' COMPENSATION 11-0415-25-00 INSURANCE 11-0415-26-00 HSA CONTRIBUTION 11-0415-27-00 PTO CASH OUT 11-0415-28-00 HRA BUY -DOWN TOTAL PERSONNEL STATE OF THE CITY 11-0417-01-00 STATE OF THE CITY TOTAL STATE OF THE CITY DEPARTMENT 0418 11-0418-00-00 COMP PLAN REWRITE TOTAL DEPARTMENT0418 COMMUNITY & STAFF RELATIONS FOR ADMINISTRATION USE ONLY 215,268.79 215,268.79 400,030.00 184,761.21 53.8 215,268.79 215,268.79 400,030.00 184,761.21 53.8 250.10 250.10 300.00 49.90 83.4 283.08 283.08 500.00 216.92 56.6 385.00 385.00 3,500.00 3,115.00 11.0 142.00 142.00 6,000.00 5,858.00 2.4 1,476.00 1,476.00 1,900.00 424.00 77.7 2,536.18 2,536.18 12,200.00 9,663.82 20.8 157,403.18 157,403.18 221,700.00 64,296.82 71.0 17.92 17.92 500.00 482.08 3.6 11,970.58 11,970.58 17,100.00 5,129.42 70.0 19,308.46 19,308.46 26,700.00 7,391.54 72.3 3,403.54 3,403.54 .00 ( 3,403.54) .0 14,089.64 14,089.64 19,300.00 5,210.36 73.0 540.00 540.00 1,200.00 660.00 45.0 4,304.46 4,304.46 10,000.00 5,695.54 43.0 .00 .00 3,080.00 3,080.00 .0 211,037.78 211,037.78 299,580.00 88,542.22 70.4 .00 .00 2,250.00 2,250.00 .0 .00 .00 2,250.00 2,250.00 .0 77.40 77.40 83,000.00 82,922.60 .1 77.40 77.40 83,000.00 82,922.60 .1 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE:23 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 EXECUTIVE DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT 11-0422-01-00 COMMUNITY/STAFF RELATIONS 334.40 334.40 3,000.00 2,665.60 11.2 11-0422-02-00 STAFF RELATIONS 375.00 375.00 .00 ( 375.00) .0 TOTAL COMMUNITY & STAFF RELATIONS 709.40 709.40 3,000.00 2,290.60 23.7 TOTAL FUND EXPENDITURES 214,360.76 214,360.76 400,030.00 185,669.24 53.6 NET REVENUE OVER EXPENDITURES 908.03 908.03 .00 ( 908.03) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 24 LIABILITIES AND EQUITY LIABILITIES 12-0216-00-00 ACCRUED PAYROLL 12-0217-01-00 STATE WITHHOLDING 12-0217-02-00 FEDERAL WITHHOLDING TAX 12-0217-03-00 FICA 12-0217-04-00 CLERKS DEPT/PUBLIC RETIREMENT 12-0217-04-01 CLERKS DEPT/401 K PERSI CHOICE 12-0217-07-00 CLERK DEPT HEALTH INSURANCE 12-0217-09-00 WORKERS' COMPENSATION TOTAL LIABILITIES FUND EQUITY 12-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 CITY CLERK/TREAS DEPARTMENT 7,001.54 612.80) 1,297.47) 897.68) 810.64) 927.03) 1,916.26 7,077.83 11,450.01 ( 25,013.59) 13,563.58 13,563.58 ( 11,450.01) .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 25 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 CITY CLERK/TREAS DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 12-0301-00-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION 12-0413-05-00 OFFICE EXPENSES 12-0413-06-00 DUPLICATION/PUBLISHING/PRINTIG 12-0413-12-00 PERSONNEL TRAINING & RESOURCES 12-0413-13-00 TRAVEL & PER DIEM 12-0413-14-00 PROFESSIONAL DUES 12-0413-29-00 UNIFORMS 12-0413-30-00 MISCELLANEOUS TOTAL ADMINISTRATION PERSONNEL 12-0415-10-00 SALARIES - FULL TIME 12-0415-11-00 OVERTIME 12-0415-15-00 SALARIES - PART TIME 12-0415-21-00 FICA 12-0415-22-00 PERSI 12-0415-23-00 HRA BUY- DOWN 12-0415-23-02 HSA CONTRIBUTION 12-0415-24-00 WORKERS' COMPENSATION 12-0415-25-00 INSURANCE 12-0415-26-00 PTO CASH OUT TOTAL PERSONNEL TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES 422,884.32 422,884.32 626,550.00 203,665.68 67.5 422,884.32 422,884.32 626,550.00 203,665.68 67.5 527.55 527.55 1,000.00 472.45 52.8 30.00 30.00 200.00 170.00 15.0 1,925.18 1,925.18 10,000.00 8,074.82 19.3 36.28 36.28 5,000.00 4,963.72 .7 560.00 560.00 1,400.00 840.00 40.0 389.80 389.80 750.00 360.20 52.0 146.80 146.80 500.00 353.20 29.4 3,615.61 3,615.61 18,850.00 15,234.39 19.2 286,309.34 286,309.34 408,000.00 121,690.66 70.2 2,073.37 2,073.37 3,000.00 926.63 69.1 9,378.07 9,378.07 16,500.00 7,121.93 56.8 22,103.97 22,103.97 32,800.00 10,696.03 67.4 34,775.17 34,775.17 51,200.00 16,424.83 67.9 1,039.60 1,039.60 8,000.00 6,960.40 13.0 200.00 200.00 1,200.00 1,000.00 16.7 571.00 571.00 .00 ( 571.00) .0 45,620.21 45,620.21 82,000.00 36,379.79 55.6 3,634.40 3,634.40 5,000.00 1,365.60 72.7 405,705.13 405,705.13 607,700.00 201,994.87 66.8 409,320.74 409,320.74 626,550.00 217,229.26 65.3 13,563.58 13,563.58 .00 ( 13,563.58) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 26 CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 BUILDING DEPARTMENT 13-0103-00-00 PETTY CASH 100.00 TOTAL ASSETS 100.00 LIABILITIES AND EQUITY LIABILITIES 13-0216-00-00 ACCRUED PAYROLL 5,067.00 13-0217-01-00 STATE WITHHOLDING ( 273.00) 13-0217-02-00 FEDERAL WITHHOLDING TAX ( 639.10) 13-0217-03-00 FICA ( 553.41) 13-0217-04-00 BLDG DEPT/PUBLIC RETIREMENT ( 505.99) 13-0217-04-01 BLDG DEPT/401K PERSI CHOICE ( 303.92) 13-0217-07-00 BLDG DEPT HEALTH INSURANCE 3,567.16 13-0217-09-00 WORKERS' COMPENSATION 44,762.13 13-0217-10-00 HSACONTRIBUTION ( 1,900.00) TOTAL LIABILITIES 49,220.87 FUND EQUITY 13-0271-00-00 FUND BALANCE ( 91,593.51) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 42,472.64 BALANCE - CURRENT DATE 42,472.64 TOTAL FUND EQUITY ( 49,120.87) TOTAL LIABILITIES AND EQUITY 100.00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 27 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 BUILDING DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 13-0301-00-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION 13-0413-05-00 OFFICE EXPENSES 13-0413-08-00 LEGAL ADS & PUBLICATIONS 13-0413-09-00 COMMERCIAL PLAN REVIEW 13-0413-12-00 TRAINING & CERTIFICATION RENEW 13-0413-13-00 TRAVEL & PER DIEM 13-0413-14-00 PROFESSIONAL DUES 13-0413-25-00 MISCELLANEOUS 13-0413-28-00 RESOURCE MATERIALS 13-0413-29-00 BUILDING PERMIT REFUNDS 13-0413-29-03 MECHANICAL FEE REFUND 13-0413-29-04 PLUMBING PERMIT REFUND 13-0413-29-05 ELECTRICAL PERMIT REFUND 13-0413-30-00 UNIFORMS TOTAL ADMINISTRATION PERSONNEL 13-0415-10-00 SALARIES - FULL TIME 13-0415-10-01 SALARIES - PERSONNEL SERVICES 13-0415-11-00 OVERTIME 13-0415-21-00 FICA 13-0415-22-00 PERSI 13-0415-23-00 HRA BUY -DOWN 13-0415-24-00 WORKERS' COMPENSATION 13-0415-25-00 INSURANCE 13-0415-26-00 HSA CONTRIBUTION 13-0415-28-00 PTO CASH OUT TOTAL PERSONNEL K�P►fll 7S�i.Y:I_[�l 7�gLl:l�fl 13-0416-09-00 PLUMBING INSPECTOR 13-0416-11-00 MECHANICAL INSPECTOR 13-0416-13-00 BLDG INSPECTOR 13-0416-14-00 PLAN REVIEW - CONTRACT 13-0416-25-00 ELECTRICAL INSPECTOR 742,870.29 742,870.29 1,156,430.00 413,559.71 64.2 742,870.29 742,870.29 1,156,430.00 413,559.71 64.2 3,663.25 3,663.25 6,500.00 2,836.75 56.4 42.00 42.00 400.00 358.00 10.5 .00 .00 6,000.00 6,000.00 .0 2,123.00 2,123.00 4,400.00 2,277.00 48.3 .00 .00 3,000.00 3,000.00 .0 865.00 865.00 540.00 ( 325.00) 160.2 .00 .00 300.00 300.00 .0 1,821.25 1,821.25 1,500.00 ( 321.25) 121.4 250.00 250.00 .00 ( 250.00) .0 4,375.00 4,375.00 500.00 ( 3,875.00) 875.0 1,480.00 1,480.00 500.00 ( 980.00) 296.0 1,875.20 1,875.20 500.00 ( 1,375.20) 375.0 1,952.93 1,952.93 1,750.00 ( 202.93) 111.6 18,447.63 18,447.63 25,890.00 7,442.37 71.3 229,988.36 229,988.36 407,000.00 177,011.64 56.5 12,669.12 12,669.12 .00 ( 12,669.12) .0 788.50 788.50 8,000.00 7,211.50 9.9 16,834.03 16,834.03 31,800.00 14,965.97 52.9 27,554.59 27,554.59 49,700.00 22,145.41 55.4 125.66 125.66 9,240.00 9,114.34 1.4 7,731.10 7,731.10 .00 ( 7,731.10) .0 47,535.30 47,535.30 87,000.00 39,464.70 54.6 1,800.00 1,800.00 1,200.00 ( 600.00) 150.0 .00 .00 5,000.00 5,000.00 .0 345,026.66 345,026.66 598,940.00 253,913.34 57.6 81,386.45 81,386.45 150,000.00 68,613.55 54.3 113,065.54 113,065.54 150,000.00 36,934.46 75.4 35,410.00 35,410.00 62,000.00 26,590.00 57.1 .00 .00 15,000.00 15,000.00 .0 106,980.06 106,980.06 150,000.00 43,019.94 71.3 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 28 TOTAL CONTRACTS & AGREEMENTS VEHICLE OPERATIONS 13-0417-02-00 GAS AND OIL 13-0417-03-00 VEHICLE REPLACEMENT TOTAL VEHICLE OPERATIONS TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 BUILDING DEPARTMENT YTD ACTUAL 336,842.05 336,842.05 BUDGET UNEXPENDED PCNT 527,000.00 190,157.95 63.9 81.31 81.31 600.00 518.69 13.6 .00 .00 4,000.00 4,000.00 .0 81.31 81.31 4,600.00 4,518.69 1.8 700,397.65 700,397.65 1,156,430.00 456,032.35 60.6 42,472.64 42,472.64 .00 ( 42,472.64) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 29 LIABILITIES AND EQUITY LIABILITIES 14-0216-00-00 ACCRUED PAYROLL 14-0217-01-00 STATE WITHHOLDING 14-0217-02-00 FEDERAL WITHHOLDING TAX 14-0217-03-00 FICA 14-0217-04-00 P&Z DEPT/PUBLIC RETIREMENT 14-0217-04-01 P&Z DEPT/401K PERSI CHOICE 14-0217-07-00 P&Z DEPT HEALTH INSURANCE 14-0217-08-00 P&Z DEPT/GARNISHMENTS 14-0217-09-00 WORKERS' COMPENSATION TOTAL LIABILITIES FUND EQUITY 14-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 P&Z DEPARTMENT 9,808.33 ( 1,026.00) ( 2,165.93) ( 786.32) ( 93.59) ( 293.77) ( 38,808.80) 203.34 71.768.62 38,605.88 ( 59,544.03) 20,938.15 20,938.15 ( 38,605.88) .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 30 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 P&Z DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 14-0301-00-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION 14-0413-05-00 OFFICE EXPENSES 14-0413-06-00 DUPLICATION/PUBLISHING/PRNTG 14-0413-08-00 LEGAL ADS & PUBLICATIONS 14-0413-12-00 PERSONNEL TRAINING 14-0413-13-00 TRAVEL & PER DIEM 14-0413-14-00 PROFESSIONAL DUES 14-0413-25-00 MISCELLANEOUS 14-0413-26-00 REIMBURSE-ANNEX/ZONING/DR FEES 14-0413-28-00 RESOURCE MATERIALS 14-0413-30-01 ENVIRONMENTAL REVIEW SERVICES 14-0413-37-00 ARBORICULTURE TOTAL ADMINISTRATION PERSONNEL 14-0415-10-00 SALARIES - FULL TIME 14-0415-11-00 OVERTIME 14-0415-21-00 FICA 14-0415-22-00 PERSI 14-0415-24-00 WORKERS' COMPENSATION 14-0415-25-00 INSURANCE 14-0415-26-00 HSA CONTRIBUTION 14-0415-29-00 PTO CASH OUT 14-0415-30-00 HRA BUY- DOWN TOTAL PERSONNEL CONTRACTS &AGREEMENTS 14-0416-02-00 TRAILS CONSULTANTS -STUDIES 14-0416-03-00 PROFESSIONAL SERVICE CONTRACTS TOTAL CONTRACTS & AGREEMENTS PUBLIC RELATIONS 703,843.57 703,843.57 1,214,100.00 510,256.43 58.0 703,843.57 703,843.57 1,214,100.00 510,256.43 58.0 1,363.47 1,363.47 1,800.00 436.53 75.8 183.32 183.32 1,000.00 816.68 18.3 3,470.97 3,470.97 8,000.00 4,529.03 43.4 1,363.00 1,363.00 5,100.00 3,737.00 26.7 4,481.45 4,481.45 15,000.00 10,518.55 29.9 1,125.00 1,125.00 2,500.00 1,375.00 45.0 884.22 884.22 1,000.00 115.78 88.4 1,866.54 1,866.54 3,000.00 1,133.46 62.2 .00 .00 200.00 200.00 .0 .00 .00 5,000.00 5,000.00 .0 .00 .00 500.00 500.00 .0 14,737.97 14,737.97 43,100.00 28,362.03 34.2 481,595.72 481,595.72 788,000.00 306,404.28 61.1 4,342.27 4,342.27 11,300.00 6,957.73 38.4 36,886.09 36,886.09 61,500.00 24,613.91 60.0 58,842.52 58,842.52 95,600.00 36,757.48 61.6 7,606.81 7,606.81 .00 ( 7,606.81) .0 58,288.71 58,288.71 137,000.00 78,711.29 42.6 1,000.00 1,000.00 4,800.00 3,800.00 20.8 6,882.01 6,882.01 15,000.00 8,117.99 45.9 2,963.33 2,963.33 17,000.00 14,036.67 17.4 658,407.46 658,407.46 1,130,200.00 471,792.54 58.3 .00 .00 20,000.00 20,000.00 .0 9,500.00 9,500.00 10,000.00 500.00 95.0 9,500.00 9,500.00 30,000.00 20,500.00 31.7 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 31 14-0422-01-00 PUBLIC RELATIONS TOTAL PUBLIC RELATIONS CAPITAL OUTLAY 14-0465-03-00 OFFICE EQUIPMENT TOTAL CAPITAL OUTLAY COMMUNITY PLANNING PROJECTS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 P&Z DEPARTMENT YTD ACTUAL .00 .00 .00 .00 14-0468-11-00 OTHER TOTAL COMMUNITY PLANNING PROJECTS TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES 259.99 259.99 259.99 259.99 .00 .00 .00 .00 682,905.42 682,905.42 20,938.15 20,938.15 BUDGET UNEXPENDED PCNT 200.00 200.00 .0 200.00 200.00 .0 600.00 340.01 43.3 600.00 340.01 43.3 10, 000.00 10, 000.00 .0 10,000.00 10,000.00 .0 1,214,100.00 531,194.58 56.3 .00 ( 20,938.15) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 32 17-0101-00-00 CASH TOTALASSETS LIABILITIES AND EQUITY LIABILITIES 17-0217-01-00 STATE WITHHOLDING 17-0217-02-00 FEDERAL WITHOLDING TAX 17-0217-03-00 FICA 17-0217-04-00 PUBLIC RETIREMENT 17-0217-04-01 401 K PERSI CHOICE PLAN 17-0217-07-00 HEALTH INSURANCE 17-0217-09-00 WORKERS' COMPENSATION 17-0217-10-00 HSACONTRIBUTION TOTAL LIABILITIES FUND EQUITY 17-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 RECREATION - PARKS AND REC 10,379.74 358.50) 516.45) 207.27) 1,247.53) 129.38) 11,749.96) 37,640.49 4,225.93) 10,379.74 19,205.47 133,692.11 ( 142,517.84) ( 142,517.84) ( 8,825.73) 10,379.74 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 33 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 RECREATION - PARKS AND REC PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 17-0301-00-00 FUNDING FROM GENERAL FUND 17-0302-00-00 REGISTRATION 17-0302-01-00 SPONSORSHIPS 17-0302-03-00 PARK RESERVATION FEES 17-0303-00-00 SCHOLARSHIP FUNDS TOTAL FUND REVENUE EXPENDITURES CONTRACTS 17-0416-00-00 CONTRACT-PERMITS-CAMPS/CLASSES 17-0416-01-00 CONTRACT -PERMITS TEAM SPORTS TOTAL CONTRACTS PERSONNEL 17-0420-10-00 SALARIES - FULL TIME 17-0420-10-01 SALARIES - PERSONNEL SERVICES 17-0420-11-00 SALARIES - SEASONAL 17-0420-15-00 SALARIES - PART TIME 17-0420-18-00 OVERTIME 17-0420-21-00 FICA 17-0420-22-00 PERSI 17-0420-23-00 HRA BUY -DOWN 17-0420-24-00 WORKERS' COMPENSATION 17-0420-25-00 INSURANCE 17-0420-26-00 HSA CONTRIBUTION 17-0420-27-00 PTO CASH OUT TOTAL PERSONNEL RESTRICTED 17-0421-00-00 SCHOLARSHIP FUNDS TOTAL RESTRICTED ADMINISTRATION 17-0422-00-00 TRAINING -PROFESSIONAL DEVELOP 17-0422-01-00 OFFICE SUPPLIES 17-0422-02-00 ADVERTISING/MKTING CAMP/CLASS FOR ADMINISTRATION USE ONLY .00 .00 443,770.00 443,770.00 .0 156,367.62 156,367.62 188,000.00 31,632.38 83.2 500.00 500.00 10,000.00 9,500.00 5.0 25,972.74 25,972.74 20,000.00 ( 5,972.74) 129.9 .00 .00 1,000.00 1,000.00 .0 182,840.36 182,840.36 662,770.00 479,929.64 27.6 525.00 525.00 35,000.00 34,475.00 1.5 8,691.50 8,691.50 15,000.00 6,308.50 57.9 9,216.50 9,216.50 50,000.00 40,783.50 18.4 178,253.24 178,253.24 266,500.00 88,246.76 66.9 12,414.38 12,414.38 .00 ( 12,414.38) .0 1,254.63 1,254.63 58,500.00 57,245.37 2.1 4,716.93 4,716.93 30,500.00 25,783.07 15.5 1,144.40 1,144.40 4,000.00 2,855.60 28.6 13,946.74 13,946.74 27,550.00 13,603.26 50.6 19,714.81 19,714.81 31,800.00 12,085.19 62.0 .00 .00 4,620.00 4,620.00 .0 6,897.86 6,897.86 .00 ( 6,897.86) .0 17,844.35 17,844.35 27,500.00 9,655.65 64.9 950.00 950.00 4,800.00 3,850.00 19.8 .00 .00 5,400.00 5,400.00 .0 257,137.34 257,137.34 461,170.00 204,032.66 55.8 .00 .00 1,000.00 1,000.00 .0 .00 .00 1,000.00 1,000.00 .0 62.02 62.02 1,099.82 1,099.82 35.00 35.00 75 % OF THE FISCAL YEAR HAS ELAPSED 2,000.00 1,937.98 3.1 1,000.00 ( 99.82) 110.0 5,500.00 5,465.00 .6 08/02/2022 01:50PM PAGE:34 17-0422-02-01 ADVERTISING/MKTNG TEAM SPORTS 17-0422-04-00 GAS/MILEAGE 17-0422-05-00 COMMUNICATION 17-0422-06-00 PRINTING AND PUBLISHING 17-0422-07-00 PROFESSIONAL DUES 17-0422-08-00 TRAINING 17-0422-09-00 TRAVEL/PER DIEM 17-0422-10-00 BACKGROUND CHECKS 17-0422-11-00 REFUNDS -PARK REC PROGRAMS TOTAL ADMINISTRATION RECREATION 17-0423-00-00 REC SUPPLIES -CAMPS & CLASSES 17-0423-00-01 REC SUPPLIES -TEAM SPORTS 17-0423-01-00 UNIFORMS 17-0423-02-00 FIELD TRIPS 17-0423-03-00 FACILITY RENTAL 17-0423-04-00 TRANSPORTATION SERVICES 17-0423-05-00 DADDY DAUGHTER DANCE 17-0423-05-01 EAGLE FUN DAYS 17-0423-07-00 GLOW IN THE PARK 17-0423-08-00 HALLOWEEN TRICK -OR -TREAT 17-0423-09-00 VETERAN'S BREAKFAST 17-0423-10-00 NEW PROGRAMS TOTAL RECREATION VEHICLES 17-0424-03-00 GAS TOTAL VEHICLES CAPITAL EQUIPMENT 17-0425-00-00 REC EQUIPMENT -TEAM SPORTS 17-0425-01-00 REC EQUIPMENT-CAMPS/CLASSES TOTAL CAPITAL EQUIPMENT TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 RECREATION - PARKS AND REC YTD ACTUAL 50.00 50.00 38.03 38.03 74.00 74.00 .00 .00 .00 .00 .00 .00 194.50 194.50 1,738.55 1,738.55 2,140.00 2,140.00 5,431.92 5,431.92 2,296.81 2,296.81 8,165.79 8,165.79 16,441.43 16,441.43 865.43 865.43 11,812.50 11,812.50 3,797.81 3,797.81 1,450.66 1,450.66 3,417.26 3,417.26 .00 .00 .00 .00 365.69 365.69 .00 .00 48,613.38 48,613.38 140.39 140.39 140.39 140.39 4,818.67 4,818.67 .00 .00 4,818.67 4,818.67 325,358.20 325,358.20 ( 142,517.84) ( 142,517.84) BUDGET UNEXPENDED PCNT 5,500.00 5,450.00 .9 100.00 61.97 38.0 .00 ( 74.00) .0 10,000.00 10,000.00 .0 2,000.00 2,000.00 .0 3,000.00 3,000.00 .0 8,000.00 7,805.50 2.4 2,000.00 261.45 86.9 2,000.00 ( 140.00) 107.0 41,100.00 35,668.08 13.2 6,000.00 3,703.19 38.3 15,000.00 6,834.21 54.4 15,000.00 ( 1,441.43) 109.6 15,000.00 14,134.57 5.8 10,000.00 ( 1,812.50) 118.1 10,000.00 6,202.19 38.0 2,200.00 749.34 65.9 .00 ( 3,417.26) .0 15,500.00 15,500.00 .0 800.00 800.00 .0 1,000.00 634.31 36.6 2,000.00 2,000.00 .0 92,500.00 43,886.62 52.6 1,000.00 859.61 14.0 1,000.00 859.61 14.0 15,000.00 10,181.33 32.1 1,000.00 1,000.00 .0 16,000.00 11,181.33 30.1 662,770.00 337,411.80 49.1 .00 142,517.84 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 35 CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 IT DEPARTMENT LIABILITIES AND EQUITY LIABILITIES 18-0217-01-00 STATE WITHHOLDING ( 278.80) 18-0217-02-00 FEDERAL WITHHOLDING TAX ( 661.48) 18-0217-03-00 FICA ( 743.52) 18-0217-04-00 PUBLIC RETIRMENT ( 791.10) 18-0217-04-01 401 K PERSI CHOICE PLAN ( 161.90) 18-0217-07-00 HEALTH INSURANCE ( 29,608.01) 18-0217-09-00 WORKERS' COMPENSATION 1,750.78 18-0217-10-00 HSA CONTRIBUTION 820.00 TOTAL LIABILITIES ( 29,674.03) FUND EQUITY 18-0271-00-00 FUND BALANCE ( 2,402.36) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 32,076.39 BALANCE - CURRENT DATE 32,076.39 TOTAL FUND EQUITY 29,674.03 TOTAL LIABILITIES AND EQUITY .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 36 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 IT DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 18-0301-00-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION 18-0413-01-00 OFFICE SUPPLIES 18-0413-02-00 SUPPLIES 18-0413-03-00 TRAINING 18-0413-04-00 TRAVEL AND PER DIEM 18-0413-05-00 PROFESSIONAL DUES 18-0413-06-00 UNIFORMS TOTAL ADMINISTRATION PERSONNEL 18-0415-10-00 SALARIES - FULL TIME 18-0415-11-00 IT DEPT/OVERTIME 18-0415-21-00 FICA 18-0415-22-00 PERSI 18-0415-23-00 HRA BUY- DOWN 18-0415-24-00 WORKERS' COMPENSATION 18-0415-25-00 INSURANCE 18-0415-26-00 HSA 18-0415-27-00 PTO CASH OUT TOTAL PERSONNEL CONTRACT & AGREEMENTS 18-0416-01-00 CONTRACT AND AGREEMENTS TOTAL CONTRACT & AGREEMENTS INTERNET/PHONE SERVICES 18-0417-01-00 INTERNET & PHONE SERVICES TOTAL INTERNET/PHONE SERVICES OPERATIONAL RESERVES FOR ADMINISTRATION USE ONLY 551,313.18 551,313.18 893,820.00 342,506.82 61.7 551,313.18 551,313.18 893,820.00 342,506.82 61.7 .00 .00 1,000.00 1,000.00 .0 484.99 484.99 4,000.00 3,515.01 12.1 .00 .00 6,450.00 6,450.00 .0 724.19 724.19 6,600.00 5,875.81 11.0 .00 .00 750.00 750.00 .0 .00 .00 800.00 800.00 .0 1,209.18 1,209.18 19,600.00 18,390.82 6.2 170,221.24 170,221.24 237,000.00 66,778.76 71.8 1,040.96 1,040.96 3,000.00 1,959.04 34.7 12,318.78 12,318.78 18,500.00 6,181.22 66.6 20,445.05 20,445.05 28,800.00 8,354.95 71.0 .00 .00 4,620.00 4,620.00 .0 324.46 324.46 .00 ( 324.46) .0 28,481.05 28,481.05 41,300.00 12,818.95 69.0 540.00 540.00 1,200.00 660.00 45.0 .00 .00 2,000.00 2,000.00 .0 233,371.54 233,371.54 336,420.00 103,048.46 69.4 171,457.61 171,457.61 330,000.00 158,542.39 52.0 171,457.61 171,457.61 330,000.00 158,542.39 52.0 42,004.51 42,004.51 74,000.00 31,995.49 56.8 42,004.51 42,004.51 74,000.00 31,995.49 56.8 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE:37 18-0418-01-00 IT EQUIPMENT/SOFTWARE TOTAL OPERATIONAL RESERVES CAPITAL OUTLAY 18-0419-01-00 FURNITURE 18-0419-02-00 EQUIPMENT 18-0419-03-00 SOFTWARE PURCHASES 18-0419-04-00 WEBSITE DEVELOPMENT 18-0419-05-00 TOOLS TOTAL CAPITAL OUTLAY TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 IT DEPARTMENT YTD ACTUAL 33,256.39 33,256.39 33,256.39 33,256.39 BUDGET UNEXPENDED PCNT 35, 000.00 1,743.61 95.0 35, 000.00 1,743.61 95.0 .00 .00 1,300.00 1,300.00 .0 34,456.13 34,456.13 60,000.00 25,543.87 57.4 1,450.00 1,450.00 25,000.00 23,550.00 5.8 .00 .00 12,000.00 12,000.00 .0 2,031.43 2,031.43 500.00 ( 1,531.43) 406.3 37,937.56 37,937.56 98,800.00 60,862.44 38.4 519,236.79 519,236.79 893,820.00 374,583.21 58.1 32,076.39 32,076.39 .00 ( 32,076.39) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 38 CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 CAPITAL PROJECTS FUND 19-0101-00-00 CASH 3,866,277.53 19-0151-25-00 FIRST INTERSTATE INVESTMENT 5,114,341.66 TOTAL ASSETS 8,980,619.19 LIABILITIES AND EQUITY LIABILITIES 19-0225-00-00 UNEARNED GRANT REVENUE, ARPA 3,204,501.48 TOTAL LIABILITIES 3,204,501.48 FUND EQUITY 19-0271-00-00 FUND BALANCE 10,001,468.10 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 4,225,350.39) BALANCE - CURRENT DATE ( 4,225,350.39) TOTAL FUND EQUITY 5,776,117.71 TOTAL LIABILITIES AND EQUITY 8,980,619.19 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 39 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 19-0301-00-00 FUNDING FROM GENERAL FUND 19-0301-01-00 BANK INTEREST 19-0301-03-00 FOOTHILLS REIMB AGREEMENT 19-0301-05-00 EAGLE RD PED/BIKE BRIDGE 19-0301-12-00 FEMA GENERAL REVENUE 19-0301-13-00 EURA COST SHARE 19-0301-20-00 COMPASS CIM GRANT 19-0331-01-00 ARPA, AMERICAN RESCUE PLAN ACT 19-0333-01-00 STATE BROADBAND GRANT 19-0371-25-01 BANK INTEREST, EXPANSION 19-0399-00-00 CARRY OVER 19-0399-01-00 CARRY OVER, ARPA FUNDS TOTAL FUND REVENUE EXPENDITURES RESERVES 19-0410-01-00 RESERVES, FUTURE PROJECTS TOTAL RESERVES CAPITAL MAINTENANCE 19-0462-01-00 CAPITAL MAINTENANCE SET ASIDE 19-0462-03-00 FEMA TRAIL REPLACEMENT TOTAL CAPITAL MAINTENANCE yrr-cH_i�rr_w�:za�xer, 19-0465-05-00 GENERAL CITY PROJECTS 19-0465-06-00 EXPANSION OF CITY HALL 19-0465-07-00 LAND PURCHASES TOTAL CITY CAPITAL PROJECTS PZ CAPITAL PROJECTS 19-0466-03-00 AIKENS EXTENSION 19-0466-05-00 EAGLE RD PED/BIKE BRIDGE 19-0466-06-00 HALF CFI PED/BIKE EDUCATION 19-0466-09-00 EAGLE -STATE ST INTERSECTION 19-0466-10-00 P&Z CAPITAL PROJECTS FY22 FOR ADMINISTRATION USE ONLY .00 .00 1,708,900.00 1,708,900.00 .0 2,939.83 2,939.83 500.00 ( 2,439.83) 588.0 .00 .00 100,000.00 100,000.00 .0 133,463.98 133,463.98 .00 ( 133,463.98) .0 .00 .00 1,057,905.00 1,057,905.00 .0 33,429.13 33,429.13 424,000.00 390,570.87 7.9 .00 .00 25,000.00 25,000.00 .0 3,204,501.48 3,204,501.48 3,200,000.00 ( 4,501.48) 100.1 .00 .00 250,000.00 250,000.00 .0 874.91 874.91 .00 ( 874.91) .0 .00 .00 10,982,829.00 10,982,829.00 .0 .00 .00 3,200,000.00 3,200,000.00 .0 3,375,209.33 3,375,209.33 20,949,134.00 17,573,924.67 16.1 .00 .00 4,560,041.00 4,560,041.00 .0 .00 .00 4,560,041.00 4,560,041.00 .0 150,331.36 150,331.36 2,015,889.00 1,865,557.64 7.5 588,952.24 588,952.24 1,596,204.00 1,007,251.76 36.9 739,283.60 739,283.60 3,612,093.00 2,872,809.40 20.5 .00 .00 100,000.00 100,000.00 .0 2,476,534.95 2,476,534.95 2,800,000.00 323,465.05 88.5 2,922,901.09 2,922,901.09 .00 ( 2,922,901.09) .0 5,399,436.04 5,399,436.04 2,900,000.00 ( 2,499,436.04) 186.2 .00 .00 617,000.00 617,000.00 .0 167,379.52 167,379.52 900,000.00 732,620.48 18.6 3,300.00 3,300.00 .00 ( 3,300.00) .0 2,831.25 2,831.25 840,000.00 837,168.75 .3 .00 .00 50,000.00 50,000.00 .0 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 40 TOTAL PZ CAPITAL PROJECTS PARK CAPITAL PROJECTS 19-0467-02-00 PARK CAPITAL PROJECTS FY22 TOTAL PARK CAPITAL PROJECTS PW CAPITAL PROJECTS 19-0469-09-00 PW CAPITAL PROJECTS FY22 TOTAL PW CAPITAL PROJECTS TRAILS & PATHWAYS 19-0473-03-00 GREENBELT MAINTENANCE TOTAL TRAILS & PATHWAYS FEDERAL FUNDS PROJECTS 19-0486-01-00 ARPA, CAPITAL PROJECTS, TBD 19-0486-01-01 ARPA, SOFTWARE PURCHASES 19-0486-01-02 ARPA, MISC LEGAL 19-0486-01-03 ARPA, FIBER EQUIPMENT 19-0486-01-04 ARPA, FACILITIES 19-0486-02-00 ARPA, FIBER NETWORK CONNECT TOTAL FEDERAL FUNDS PROJECTS TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 CAPITAL PROJECTS FUND YTD ACTUAL 173, 510.77 173, 510.77 BUDGET UNEXPENDED PCNT 2,407,000.00 2,233,489.23 7.2 .00 .00 200,000.00 200,000.00 .0 .00 .00 200,000.00 200,000.00 .0 .00 .00 250,000.00 250,000.00 .0 .00 .00 250,000.00 250,000.00 .0 .00 .00 370,000.00 370,000.00 .0 .00 .00 370,000.00 370,000.00 .0 .00 .00 3,400,000.00 3,400,000.00 .0 27,395.00 27,395.00 .00 ( 27,395.00) .0 1,300.75 1,300.75 .00 ( 1,300.75) .0 700,760.53 700,760.53 .00 ( 700,760.53) .0 159,076.70 159,076.70 .00 ( 159,076.70) .0 399,796.33 399,796.33 3,250,000.00 2,850,203.67 12.3 1,288,329.31 1,288,329.31 6,650,000.00 5,361,670.69 19.4 7,600,559.72 7,600,559.72 20,949,134.00 13,348,574.28 36.3 ( 4,225,350.39) ( 4,225,350.39) .00 4,225,350.39 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 41 CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 ARTS COMMISSION 21-0101-00-00 CASH 14,204.16 TOTAL ASSETS 14,204.16 LIABILITIES AND EQUITY FUND EQUITY 21-0271-00-00 FUND BALANCE 24,558.04 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 10,353.88) BALANCE - CURRENT DATE ( 10,353.88) TOTAL FUND EQUITY 14,204.16 TOTAL LIABILITIES AND EQUITY 14,204.16 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 42 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 ARTS COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 21-0301-00-00 FUNDING FROM GENERAL FUND .00 .00 44,901.00 44,901.00 .0 21-0376-07-00 DONATIONS .00 .00 500.00 500.00 .0 21-0376-09-00 SCHOLARSHIPS .00 .00 500.00 500.00 .0 21-0376-11-00 GALLERY MAINTENANCE 430.00 430.00 500.00 70.00 86.0 21-0376-12-00 POSTCARD REVENUE 18.65 18.65 300.00 281.35 6.2 21-0399-00-00 CARRY OVER .00 .00 30,719.00 30,719.00 .0 TOTAL FUND REVENUE 448.65 448.65 77,420.00 76,971.35 .6 EXPENDITURES ADMINISTRATION 21-0420-00-00 ADMINISTRATION .00 .00 8,000.00 8,000.00 .0 21-0420-01-00 POSTCARD EXPENDITURES .00 .00 300.00 300.00 .0 TOTAL ADMINISTRATION .00 .00 8,300.00 8,300.00 .0 ART EDUCATION 21-0421-00-00 ART EDUCATION & ADVOCACY 8,572.00 8,572.00 15,000.00 6,428.00 57.2 TOTAL ART EDUCATION 8,572.00 8,572.00 15,000.00 6,428.00 57.2 ART INSTALLATION 21-0422-00-00 ARTS IN PUBLIC SPACES/BEAUTIFY 91.30 91.30 33,120.00 33,028.70 .3 TOTAL ART INSTALLATION 91.30 91.30 33,120.00 33,028.70 .3 ACQUISITION OF ART 21-0423-00-00 ACQUISITION OF ART 600.00 600.00 1,500.00 900.00 40.0 TOTAL ACQUISITION OF ART 600.00 600.00 1,500.00 900.00 40.0 COMMUNITY EVENTS 21-0425-00-00 COMMUNITY EVENTS 1,527.40 1,527.40 18,000.00 16,472.60 8.5 TOTAL COMMUNITY EVENTS 1,527.40 1,527.40 18,000.00 16,472.60 8.5 GALLERY MTNC/SUPPLIES FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 43 21-0427-00-00 GALLERY MTNC/SLUPPLIES TOTAL GALLERY MTNC/SUPPLIES TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 ARTS COMMISSION YTD ACTUAL 11.83 11.83 11.83 11.83 10,802.53 10,802.53 ( 10,353.88) ( 10,353.88) BUDGET UNEXPENDED PCNT 1,500.00 1,488.17 .8 1,500.00 1,488.17 .8 77,420.00 66,617.47 14.0 .00 10,353.88 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 44 LIABILITIES AND EQUITY LIABILITIES 23-0202-00-00 VOUCHERS PAYABLE 23-0216-00-00 ACCRUED PAYROLL 23-0217-01-00 STATE WITHHOLDING 23-0217-02-00 FEDERAL WITHHOLDING 23-0217-03-00 FICA 23-0217-04-00 PUBLIC RETIREMENT 23-0217-04-01 401 K CHOICE PLAN 23-0217-05-00 PW DEPT MISC DEDUCTIONS 23-0217-07-00 HEALTH INSURANCE 23-0217-08-00 GARNISHMENT 23-0217-09-00 WORKERS' COMPENSATION 23-0217-10-00 HSACONTRIBUTION TOTAL LIABILITIES FUND EQUITY 23-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 PUBLIC WORKS ( 156.08) 10,783.10 ( 605.80) ( 1,358.79) ( .41) ( 1,762.58) ( 865.95) ( 14,386.03) 15, 067.27 ( 1,404.80) 105,972.57 ( 1,160.00) 110,122.50 587,726.71 ( 697,849.21) ( 697,849.21) ( 110,122.50) .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 45 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT 23-0302-00-00 FUNDING FROM GENERAL FUND 23-0303-00-00 VENDOR LEASE PAYMENTS, PARKS 23-0315-01-00 SANITATION SERVICES 23-0315-02-00 SIDEWALKS, LTS, TREES, STR-REP 23-0315-06-00 TREE FUNDS, CARRYOVER 23-0315-09-00 WYCLIFF PUMP STATION 23-0316-00-00 ARBOR DAY, TREE CITY USA GRANT 23-0316-01-00 MEMORIAL DONATIONS TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION 23-0413-01-00 OFFICE SUPPLIES 23-0413-02-00 PRINTING AND PUBLISHING 23-0413-03-00 LEGAL, ADV, PUBLICATION 23-0413-04-00 TRAINING 23-0413-05-00 TRAVEL & PER DIEM 23-0413-06-00 PROFESSIONAL DUES 23-0413-09-00 UNIFORMS AND SAFETY CLOTHING 23-0413-10-00 PUBLIC RELATIONS TOTAL ADMINISTRATION GEN MAINTENANCE & REPAIR 23-0414-01-00 DO NOT USE 23-0414-02-00 MISC MTNC & REPAIR GROUNDS 23-0414-03-00 MATERIALS AND SUPPLIES 23-0414-04-00 HOLIDAY LIGHTING 23-0414-05-00 PAPER PRODUCTS 23-0414-06-00 BACK FLOW PARTS REPLACEMENT 23-0414-07-01 MTNC/RPR SNOW EQUIPMENT 23-0414-08-00 SIGNS & SIGN REPLACEMENT 23-0414-10-00 ROOF MAINTENANCE 23-0414-11-00 HVAC MAINTENANCE 23-0414-12-00 EMERGENCY REPAIRS TOTAL GEN MAINTENANCE & REPAIR RESTRICTED 23-0415-02-00 SIDEWALKS, LTS, TREES, STR-REP 431, 935.01 431,935.01 2,167, 755.00 1, 735, 819.99 19.9 3,459.70 3,459.70 3,000.00 ( 459.70) 115.3 .00 .00 25,000.00 25,000.00 .0 .00 .00 150,000.00 150,000.00 .0 .00 .00 29,511.00 29,511.00 .0 .00 .00 6,690.00 6,690.00 .0 .00 .00 300.00 300.00 .0 2,918.10 2,918.10 6,000.00 3,081.90 48.6 438, 312.81 438, 312.81 2, 388, 256.00 1,949,943.19 18.4 298.00 298.00 1,000.00 702.00 29.8 .00 .00 1,000.00 1,000.00 .0 1,920.36 1,920.36 7,500.00 5,579.64 25.6 12,526.72 12,526.72 15,500.00 2,973.28 80.8 438.22 438.22 6,725.00 6,286.78 6.5 30.00 30.00 2,500.00 2,470.00 1.2 450.00 450.00 5,500.00 5,050.00 8.2 .00 .00 1,000.00 1,000.00 .0 15,663.30 15,663.30 40,725.00 25,061.70 38.5 567.96 567.96 .00 ( 567.96) .0 16,143.56 16,143.56 40,000.00 23,856.44 40.4 31,981.99 31,981.99 47,000.00 15,018.01 68.1 3,800.00 3,800.00 7,000.00 3,200.00 54.3 29,174.34 29,174.34 40,000.00 10,825.66 72.9 239.29 239.29 5,000.00 4,760.71 4.8 250.00 250.00 5,000.00 4,750.00 5.0 1,138.67 1,138.67 5,000.00 3,861.33 22.8 .00 .00 3,000.00 3,000.00 .0 3,205.84 3,205.84 2,500.00 ( 705.84) 128.2 5,035.00 5,035.00 25,000.00 19,965.00 20.1 91,536.65 91,536.65 179,500.00 87,963.35 51.0 .00 .00 150, 000.00 150, 000.00 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 46 TOTAL RESTRICTED CONTRACTS & AGREEMENTS 23-0416-00-00 WYCLIFFE PUMP STATION 23-0416-01-00 FARMERS UNION 23-0416-02-00 EAST ENTRY SIGN 23-0416-03-00 SCENIC BYWAY 23-0416-07-00 CHAUMONT LEASE AGREEMENT 23-0416-08-00 BASELINE MANAGER AGREEMENT 23-0416-09-00 NEW DRY CREEK DITCH CO 23-0416-10-00 BALLANTYNE/BOISE VALLEY DITCH TOTAL CONTRACTS & AGREEMENTS VEHICLES 23-0417-01-00 VEHICLE MTNC & REPAIR 23-0417-02-00 GAS AND OIL 23-0417-05-00 VEHICLE CAR WASH TOTAL VEHICLES PROGRAMS 23-0418-03-00 MEMORIALS, MTNC/REPAIR TOTAL PROGRAMS FLOWER BASKETS 23-0419-01-00 MATERIALS & SUPPLIES 23-0419-02-00 FLOWERS TOTAL FLOWER BASKETS EQUIPMENT MTNC & REPAIR 23-0420-00-00 MTNC/REPAIR EQUIPMENT TOTAL EQUIPMENT MTNC & REPAIR SUSTAINABILITY-CONSERVATION 23-0421-00-00 SUSTAINABILITY & CONSERVATION 23-0421-01-00 SANITATION SERVICES 23-0421-02-00 TREE FUNDS 23-0421-03-00 TREE VOUCHER PROGRAM 23-0421-04-00 ARBOR DAY, TREE CITY USA GRANT FOR ADMINISTRATION USE ONLY CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 PUBLIC WORKS YTD ACTUAL .00 .00 BUDGET UNEXPENDED PCNT 150,000.00 150,000.00 .0 1,113.39 1,113.39 6,690.00 5,576.61 16.6 1,300.74 1,300.74 1,200.00 ( 100.74) 108.4 339.11 339.11 1,000.00 660.89 33.9 .00 .00 154.00 154.00 .0 1.00 1.00 1.00 .00 100.0 3,582.00 3,582.00 3,500.00 ( 82.00) 102.3 306.00 306.00 1,000.00 694.00 30.6 766.25 766.25 2,000.00 1,233.75 38.3 7,408.49 7,408.49 15,545.00 8,136.51 47.7 6,705.75 6,705.75 17,000.00 10,294.25 39.5 19,465.64 19,465.64 25,000.00 5,534.36 77.9 18.00 18.00 2,200.00 2,182.00 .8 26,189.39 26,189.39 44,200.00 18,010.61 59.3 4,976.20 4,976.20 6,000.00 1,023.80 82.9 4,976.20 4,976.20 6,000.00 1,023.80 82.9 00 .00 2,000.00 2,000.00 .0 00 .00 15,000.00 15,000.00 .0 00 .00 17,000.00 17,000.00 .0 7,745.08 7,745.08 10,000.00 2,254.92 77.5 7,745.08 7,745.08 10,000.00 2,254.92 77.5 3,383.92 3,383.92 14,135.13 14,135.13 .00 .00 15,073.87 15,073.87 .00 .00 75 % OF THE FISCAL YEAR HAS ELAPSED .00 ( 3,383.92) .0 54,000.00 39,864.87 26.2 29,511.00 29,511.00 .0 15,000.00 ( 73.87) 100.5 300.00 300.00 .0 08/02/2022 01:50PM PAGE:47 TOTAL SUSTAINABILITY-CONSERVATIO FLEET MANAGEMENT 23-0423-00-00 VEHICLE REPLACEMENT TOTAL FLEET MANAGEMENT PERSONNEL 23-0433-10-00 SALARIES -FULL TIME 23-0433-10-01 SALARIES - PERSONNEL SERVICES 23-0433-11-00 OVERTIME 23-0433-15-00 SALARIES - PART TIME 23-0433-16-00 SALARIES -SEASONAL 23-0433-21-00 FICA 23-0433-22-00 PERSI 23-0433-24-00 WORKERS' COMPENSATION 2 3-0433-25-00 INSURANCE 23-0433-26-00 HSA CONTRIBUTION 23-0433-27-00 HRA BUY -DOWN 23-0433-29-00 PTO CASH OUT TOTAL PERSONNEL SHOP 23-0440-00-00 SHOP LEASE 23-0440-02-00 UTILITIES TOTAL SHOP STREET LIGHTS 23-0441-01-00 MAINTENANCE & REPAIR 23-0441-02-00 UTILITIES TOTAL STREET LIGHTS CITY HALL 23-0442-01-00 BLDG MAINTENANCE & REPAIR 23-0442-02-00 MTNC & REPAIR GROUNDS 23-0442-04-00 UTILITIES TOTAL CITY HALL SENIOR CENTER FOR ADMINISTRATION USE ONLY CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT N 32,592.92 32,592.92 98,811.00 66,218.08 33.0 88,104.00 88,104.00 83,700.00 ( 4,404.00) 105.3 88,104.00 88,104.00 83,700.00 ( 4,404.00) 105.3 361,652.61 361,652.61 654,000.00 292,347.39 55.3 54,043.56 54,043.56 .00 ( 54,043.56) .0 5,995.49 5,995.49 18,600.00 12,604.51 32.2 758.18 758.18 .00 ( 758.18) .0 27,891.57 27,891.57 195,400.00 167,508.43 14.3 30,033.95 30,033.95 66,500.00 36,466.05 45.2 45,350.79 45,350.79 78,500.00 33,149.21 57.8 16,014.06 16,014.06 .00 ( 16,014.06) .0 50,264.65 50,264.65 142,500.00 92,235.35 35.3 2,830.00 2,830.00 15,600.00 12,770.00 18.1 .00 .00 7,700.00 7,700.00 .0 6,958.40 6,958.40 .00 ( 6,958.40) .0 601,793.26 601,793.26 1,178,800.00 577,006.74 51.1 21,839.32 21,839.32 27,000.00 5,160.68 80.9 2,162.55 2,162.55 3,750.00 1,587.45 57.7 24,001.87 24,001.87 30,750.00 6,748.13 78.1 123.00 123.00 8,000.00 7,877.00 1.5 19,574.86 19,574.86 55,000.00 35,425.14 35.6 19,697.86 19,697.86 63,000.00 43,302.14 31.3 3,298.00 3,298.00 2,500.00 ( 798.00) 131.9 277.14 277.14 1,500.00 1,222.86 18.5 27,066.80 27,066.80 40,000.00 12,933.20 67.7 30,641.94 30,641.94 44,000.00 13,358.06 69.6 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE:48 23-0443-01-00 BLDG MAINTENANCE & REPAIR 23-0443-02-00 MTNC & REPAIR GROUNDS TOTAL SENIOR CENTER 23-0444-01-00 BLDG MAINTENANCE & REPAIR 23-0444-02-00 MTNC & REPAIR GROUNDS TOTAL LIBRARY MUSEUM 23-0445-01-00 BLDG MAINTENANCE & REPAIR TOTAL MUSEUM ARBORETUM PARK 23-0446-01-00 BLDG/STRUCTURES MTNC & REPAIR 23-0446-02-00 EQUIPMENT MTNC & REPAIRS 23-0446-03-00 GROUNDS MTNC & REPAIR 23-0446-04-00 UTILITIES TOTAL ARBORETUM PARK FLAG PLAZA 23-0447-01-00 BLDG/STRUCTURES MTNC & REPAIR 23-0447-02-00 EQUIPMENT MTNC & REPAIR 23-0447-03-00 GROUNDS - MTNC & REPAIR 23-0447-04-00 UTILITIES TOTAL FLAG PLAZA FRIENDSHIP PARK 23-0448-01-00 BLDGS/STRUCTURES MTNC & REPAIR 23-0448-02-00 EQUIPMENT MTNC & REPAIR 23-0448-03-00 GROUNDS MTNC & REPAIR 23-0448-04-00 UTILITIES TOTAL FRIENDSHIP PARK GUERBER PARK 23-0449-01-00 BLDGS/STRUCTURES MTNC & REPAIR FOR ADMINISTRATION USE ONLY CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 PUBLIC WORKS YTD ACTUAL 2,499.69 2,499.69 .00 .00 2,499.69 2,499.69 BUDGET UNEXPENDED PCNT 2,500.00 .31 100.0 1,500.00 1,500.00 .0 4,000.00 1,500.31 62.5 9,989.44 .00 9,989.44 9,989.44 .00 9,989.44 5,000.00 ( 2,000.00 7,000.00 ( 4,989.44) 2,000.00 2,989.44) 199.8 .0 142.7 4,029.18 4,029.18 2,500.00 ( 1,529.18) 161.2 4,029.18 4,029.18 2,500.00 ( 1,529.18) 161.2 .00 .00 500.00 500.00 .0 .00 .00 500.00 500.00 .0 .00 .00 500.00 500.00 .0 14.62 14.62 1,000.00 985.38 1.5 14.62 14.62 2,500.00 2,485.38 .6 .00 .00 500.00 500.00 .0 .00 .00 500.00 500.00 .0 .00 .00 500.00 500.00 .0 219.65 219.65 225.00 5.35 97.6 219.65 219.65 1,725.00 1,505.35 12.7 .00 .00 500.00 500.00 .0 .00 .00 500.00 500.00 .0 .00 .00 2,500.00 2,500.00 .0 827.01 827.01 3,000.00 2,172.99 27.6 827.01 827.01 6,500.00 5,672.99 12.7 713.00 713.00 6,500.00 5,787.00 11.0 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 49 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT 23-0449-02-00 EQUIPMENT MTNC & REPAIR 1,667.69 1,667.69 1,500.00 ( 167.69) 111.2 23-0449-03-00 GROUNDS MTNC & REPAIR 19.98 19.98 5,000.00 4,980.02 .4 23-0449-04-00 UTILITIES 9,875.18 9,875.18 24,000.00 14,124.82 41.2 TOTAL GUERBER PARK 12,275.85 12,275.85 37,000.00 24,724.15 33.2 HERITAGE PARK 23-0450-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 2,000.00 2,000.00 .0 23-0450-02-00 EQUIPMENT MTNC & REPAIR 36.98 36.98 1,500.00 1,463.02 2.5 23-0450-03-00 GROUNDS MTNC & REPAIR 94.45 94.45 500.00 405.55 18.9 23-0450-04-00 UTILITIES 1,943.03 1,943.03 3,000.00 1,056.97 64.8 TOTAL HERITAGE PARK 2,074.46 2,074.46 7,000.00 4,925.54 29.6 MCDONALDS PARK/PATHWAY 23-0451-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0451-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0451-03-00 GROUNDS MTNC & REPAIR 1.05 1.05 1,000.00 998.95 .1 TOTAL MCDONALDS PARK/PATHWAY 1.05 1.05 2,000.00 1,998.95 .1 MERRILL PARK 23-0452-01-00 BLDG/STRUCTURES MTNC & REPAIR 1,971.00 1,971.00 6,500.00 4,529.00 30.3 23-0452-02-00 EQUIPMENT MTNC & REPAIR .00 .00 1,500.00 1,500.00 .0 23-0452-03-00 GROUNDS MTNC & REPAIR 189.00 189.00 5,000.00 4,811.00 3.8 23-0452-04-00 UTILITIES 11,437.88 11,437.88 9,500.00 ( 1,937.88) 120.4 TOTAL MERRILL PARK 13,597.88 13,597.88 22,500.00 8,902.12 60.4 ORVAL KRASEN PARK 23-0453-01-00 BLDGS/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0453-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0453-03-00 GROUNDS MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0453-04-00 UTILITIES 1,318.38 1,318.38 2,000.00 681.62 65.9 TOTAL ORVAL KRASEN PARK 1,318.38 1,318.38 3,500.00 2,181.62 37.7 SPORTS COMPLEX 23-0454-01-00 BLDGS/STRUCTURES MTNC & REPAIR 1,890.67 1,890.67 2,500.00 609.33 75.6 23-0454-02-00 EQUIPMENT MTNC & REPAIR 1,669.25 1,669.25 1,000.00 ( 669.25) 166.9 23-0454-03-00 GROUNDS MTNC & REPAIR .00 .00 1,000.00 1,000.00 .0 23-0454-04-00 UTILITIES 16,010.97 16,010.97 20,000.00 3,989.03 80.1 TOTAL SPORTS COMPLEX 19,570.89 19,570.89 24,500.00 4,929.11 79.9 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:50PM PAGE: 50 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT TOWN ENTRANCE SIGNS 23-0455-01-00 BLDGS/STRUCTURES MTNC & REPAIR 23-0455-02-00 EQUIPMENT MTNC & REPAIR 23-0455-03-00 GROUNDS MTNC & REPAIR 23-0455-04-00 UTILITIES TOTAL TOWN ENTRANCE SIGNS PLAZA DRIVE 23-0456-02-00 EQUIPMENT MTNC & REPAIR 23-0456-03-00 GROUNDS MTNC & REPAIR 23-0456-04-00 UTILITIES TOTAL PLAZA DRIVE PAMELA BAKER PARK 23-0459-01-00 BLDG/STRUCTURES MTNC & REPAIR 23-0459-02-00 GROUNDS MTNC & REPAIR 23-0459-03-00 EQUIPMENT MTNC/REPAIR 23-0459-04-00 UTILITIES TOTAL PAMELA BAKER PARK CAPITAL EQUIPMENT 23-0460-00-00 TOOLS 23-0460-01-00 EQUIPMENT TOTAL CAPITAL EQUIPMENT CITY LANDSCAPE MAINTENANCE 23-0462-00-00 EQUIPMENT RENTAL 23-0462-01-00 SPRAYING/FERTILIZING 23-0462-02-00 SAFETY EQUIPMENT 23-0462-03-00 DUMPING -DISPOSAL TOTAL CITY LANDSCAPE MAINTENANCE LINDER ROAD RESTROOM 23-0463-01-00 BLDG/STRUCTURES MTNC REPAIR 23-0463-02-00 EQUIPMENT MTNC-REPAIR 23-0463-03-00 GROUNDS MTNC & REPAIR 23-0463-04-00 UTILITIES .00 .00 500.00 500.00 .0 .00 .00 500.00 500.00 .0 .00 .00 500.00 500.00 .0 3,668.74 3,668.74 21,000.00 17,331.26 17.5 3,668.74 3,668.74 22,500.00 18,831.26 16.3 .00 .00 500.00 500.00 .0 .00 .00 500.00 500.00 .0 870.35 870.35 1,500.00 629.65 58.0 870.35 870.35 2,500.00 1,629.65 34.8 .00 .00 500.00 500.00 .0 391.25 391.25 500.00 108.75 78.3 .00 .00 500.00 500.00 .0 5,764.27 5,764.27 5,000.00 ( 764.27) 115.3 6,155.52 6,155.52 6,500.00 344.48 94.7 3,949.85 3,949.85 5,000.00 1,050.15 79.0 22,318.51 22,318.51 85,000.00 62,681.49 26.3 26,268.36 26,268.36 90,000.00 63,731.64 29.2 3,700.89 3,700.89 7,500.00 3,799.11 49.4 24,444.78 24,444.78 48,000.00 23,555.22 50.9 .00 .00 1,000.00 1,000.00 .0 651.28 651.28 5,000.00 4,348.72 13.0 28,796.95 28,796.95 61,500.00 32,703.05 46.8 737.50 737.50 198.98 198.98 3,120.91 3,120.91 2,097.50 2,097.50 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 1,000.00 262.50 73.8 500.00 301.02 39.8 500.00 ( 2,620.91) 624.2 6,000.00 3,902.50 35.0 08/02/2022 01:51PM PAGE:51 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 PUBLIC WORKS YTD ACTUAL 6,154.89 6,154.89 TOTAL LINDER ROAD RESTROOM TRAILS 23-0464-00-00 GROUNDS MTNC/REPAIR 23-0464-01-00 EQUIPMENT RENTAL TOTAL TRAILS FISCAL YEAR CAPITAL PROJECTS 23-0480-15-00 LANDSCAPE UPGRADES - PARKS TOTAL FISCAL YEAR CAPITAL PROJECTS FY21/22 PROJECTS 23-0483-01-00 CAPITAL PROJECTS FY22 TOTAL FY 21/22 PROJECTS TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES BUDGET UNEXPENDED PCNT 8,000.00 1,845.11 76.9 2,501.00 2,501.00 5,000.00 2,499.00 50.0 296.41 296.41 4,000.00 3,703.59 7.4 2,797.41 2,797.41 9,000.00 6,202.59 31.1 19,553.86 19,553.86 25,000.00 5,446.14 78.2 19,553.86 19,553.86 25,000.00 5,446.14 78.2 25,126.88 25,126.88 80,500.00 55,373.12 31.2 25,126.88 25,126.88 80,500.00 55,373.12 31.2 1,136,162.02 1,136,162.02 2,388,256.00 1,252,093.98 47.6 ( 697,849.21) ( 697,849.21) .00 697,849.21 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51PM PAGE: 52 CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 RECREATION - EAGLE FUN DAYS LIABILITIES AND EQUITY LIABILITIES 24-0217-00-00 FUND BALANCE ( 23,706.58) TOTAL LIABILITIES ( 23,706.58) FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 23,706.58 BALANCE - CURRENT DATE 23,706.58 TOTAL FUND EQUITY 23,706.58 TOTAL LIABILITIES AND EQUITY .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51 PM PAGE: 53 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 RECREATION - EAGLE FUN DAYS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 24-0301-00-00 FUNDING FROM GENERAL FUND 24-0303-00-00 SPONSORSHIPS 24-0303-01-00 CAR SHOW 24-0303-02-00 CORNHOLE 24-0303-03-00 FUN RUN 24-0303-04-00 VENDORS 24-0303-05-00 ROCKY MOUNTAIN OYSTER FEED TOTAL FUND REVENUE EXPENDITURES ADMIN EXPENDITURES 24-0401-01-00 FUN DAYS CONTRACTS 24-0401-03-00 FIREWORKS 24-0401-04-00 ADVERTISEMENT 24-0401-05-00 MUSIC & ENTERTAINMENT 24-0401-06-00 SUPPLIES 24-0401-07-00 EQUIPMENT TOTALADMIN EXPENDITURES LOGISTICS 24-0410-00-00 PORTA POTTIES 24-0410-01-00 SUPPLIES 24-0410-02-00 TRAFFIC BARRIERS & CONTROL 24-0410-03-00 GOLF CART RENTALS 24-0410-04-00 POLICE OVERTIME 24-0410-05-00 STREET CLOSURES 24-0410-06-00 SIGNAGE 24-0410-07-00 SECURITY 24-0410-09-00 EQUIPMENT TOTAL LOGISTICS FUN RUN 24-0420-01-00 PROMOTIONS 24-0420-02-00 BIBS 24-0420-03-00 BREAKFAST 24-0420-04-00 ADVERTISING 24-0420-05-00 MISCELLANEOUS TOTAL FUN RUN FOR ADMINISTRATION USE ONLY 39,627.08 39,627.08 90,000.00 50,372.92 44.0 .00 .00 21,000.00 21,000.00 .0 1,455.00 1,455.00 3,300.00 1,845.00 44.1 .00 .00 1,250.00 1,250.00 .0 .00 .00 3,000.00 3,000.00 .0 680.00 680.00 7,000.00 6,320.00 9.7 855.00 855.00 20,000.00 19,145.00 4.3 42,617.08 42,617.08 145,550.00 102,932.92 29.3 5,000.00 5,000.00 10,000.00 5,000.00 50.0 10,000.00 10,000.00 20,000.00 10,000.00 50.0 1,150.00 1,150.00 12,000.00 10,850.00 9.6 .00 .00 10,000.00 10,000.00 .0 822.50 822.50 6,000.00 5,177.50 13.7 .00 .00 6,000.00 6,000.00 .0 16,972.50 16,972.50 64,000.00 47,027.50 26.5 .00 .00 2,000.00 2,000.00 .0 .00 .00 2,500.00 2,500.00 .0 .00 .00 8,000.00 8,000.00 .0 .00 .00 500.00 500.00 .0 .00 .00 7,000.00 7,000.00 .0 .00 .00 4,500.00 4,500.00 .0 .00 .00 2,500.00 2,500.00 .0 .00 .00 7,000.00 7,000.00 .0 .00 .00 1,500.00 1,500.00 .0 .00 .00 35,500.00 35,500.00 .0 00 .00 00 .00 00 .00 00 .00 00 .00 .00 .00 75 % OF THE FISCAL YEAR HAS ELAPSED 2,000.00 2,000.00 .0 300.00 300.00 .0 500.00 500.00 .0 200.00 200.00 .0 400.00 400.00 .0 3,400.00 3,400.00 .0 08/02/2022 01:51PM PAGE:54 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 RECREATION - EAGLE FUN DAYS YTD ACTUAL BUDGET UNEXPENDED PCNT CAR SHOW 24-0430-00-00 MARKETING/ADVERTISING 24-0430-01-00 DASH PLAQUES 24-0430-02-00 TROPHIES 24-0430-03-00 SUPPLIES 24-0430-04-00 PARKING 24-0430-05-00 MISCELLANEOUS 24-0430-06-00 RAFFLE 24-0430-08-00 COMMUNITY GROUP TOTAL CAR SHOW CORNHOLE 24-0440-00-00 BUILDING/PAINT SUPPLIES 24-0440-01-00 ARTIST 24-0440-02-00 BEAN BAGS TOTAL CORNHOLE ROCKY MOUNTAIN OYSTER FEED 24-0445-01-00 COMMUNITY BENEFICIARY 24-0445-03-00 FOOD AND BEVERAGE TOTAL ROCKY MOUNTAIN OYSTER FEED TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES .00 .00 100.00 100.00 .0 .00 .00 300.00 300.00 .0 1,938.00 1,938.00 2,500.00 562.00 77.5 .00 .00 300.00 300.00 .0 .00 .00 500.00 500.00 .0 .00 .00 150.00 150.00 .0 .00 .00 500.00 500.00 .0 .00 .00 500.00 500.00 .0 1,938.00 1,938.00 4,850.00 2,912.00 40.0 .00 .00 200.00 200.00 .0 .00 .00 300.00 300.00 .0 .00 .00 300.00 300.00 .0 .00 .00 800.00 800.00 .0 .00 .00 .00 .00 20,000.00 17,000.00 20,000.00 17,000.00 .0 .0 .00 .00 37,000.00 37,000.00 .0 18,910.50 18,910.50 145, 550.00 126,639.50 13.0 23,706.58 23,706.58 .00 ( 23,706.58) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51PM PAGE: 55 CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 PATHWAY IMPACT FEE FUND ASSETS 25-0101-00-00 CASH 49,584.50 25-0151-25-00 FIRST INTERSTATE INVESTMENT 793,549.90 TOTAL ASSETS 843.134.40 LIABILITIES AND EQUITY FUND EQUITY 25-0271-00-00 FUND BALANCE 763,927.09 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 79,207.31 BALANCE - CURRENT DATE 79,207.31 TOTAL FUND EQUITY 843,134.40 TOTAL LIABILITIES AND EQUITY 843,134.40 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51 PM PAGE: 56 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 PATHWAY IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 25-0322-19-00 DEVELOPMENT IMPACT FEE 25-0371-25-00 BANK INTEREST 25-0399-00-00 CARRY OVER TOTAL FUND REVENUE EXPENDITURES CAPITAL IMPROVEMENTS 25-0438-00-00 CAPITAL IMPROVEMENTS 25-0438-01-00 EAGLE ISLAND ST PK CONNECTION TOTAL CAPITAL IMPROVEMENTS TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES 78,659.00 78,659.00 198,300.00 119,641.00 39.7 1,031.31 1,031.31 1,080.00 48.69 95.5 .00 .00 702,268.00 702,268.00 .0 79,690.31 79,690.31 901,648.00 821,957.69 8.8 483.00 483.00 801,648.00 801,165.00 .1 .00 .00 100,000.00 100,000.00 .0 483.00 483.00 901,648.00 901,165.00 .1 483.00 483.00 901,648.00 901,165.00 .1 79,207.31 79,207.31 .00 ( 79,207.31) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51 PM PAGE: 57 CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 ECONOMIC DEVELOPMENT LIABILITIES AND EQUITY LIABILITIES 26-0217-01-00 STATE WITHHOLDING ( 189.00) 26-0217-02-00 FEDERAL WITHHOLDING ( 430.01) 26-0217-03-00 FICA ( 415.75) 26-0217-04-00 PUBLIC RETIREMENT ( 399.56) 26-0217-07-00 HEALTH INSURANCE ( 1,179.85) 26-0217-09-00 WORKERS' COMPENSATION 785.34 TOTAL LIABILITIES ( 1,828.83) FUND EQUITY 26-0271-00-00 FUND BALANCE ( 1,747.65) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 3,576.48 BALANCE - CURRENT DATE 3,576.48 TOTAL FUND EQUITY 1,828.83 TOTAL LIABILITIES AND EQUITY .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51 PM PAGE: 58 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 26-0301-00-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION 26-0413-05-00 OFFICE SUPPLIES 26-0413-06-00 DUPLICATION/PUBLISHING/PRINTIN 26-0413-12-00 TRAINING 26-0413-13-00 TRAVEL & PER DIEM 26-0413-14-00 PROFESSIONAL DUES 26-0413-19-00 COMMUNICATIONS 26-0413-29-00 UNIFORMS TOTAL ADMINISTRATION PERSONNEL 26-0415-10-00 SALARIES - FULL TIME 26-0415-11-00 OVERTIME 26-0415-21-00 FICA 26-0415-22-00 PERSI 26-0415-23-00 HRA BUY -DOWN 26-0415-24-00 WORKERS' COMPENSATION 26-0415-25-00 INSURANCE TOTAL PERSONNEL TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES 145,720.19 145,720.19 212,056.00 66,335.81 68.7 145,720.19 145,720.19 212,056.00 66,335.81 68.7 101.61 101.61 500.00 398.39 20.3 1,043.08 1,043.08 1,500.00 456.92 69.5 750.00 750.00 6,895.00 6,145.00 10.9 1,911.48 1,911.48 6,400.00 4,488.52 29.9 1,397.88 1,397.88 4,281.00 2,883.12 32.7 9,353.51 9,353.51 12,200.00 2,846.49 76.7 .00 .00 200.00 200.00 .0 14,557.56 14,557.56 31,976.00 17,418.44 45.5 97,554.84 97,554.84 135,500.00 37,945.16 72.0 72.88 72.88 .00 ( 72.88) .0 7,455.21 7,455.21 10,400.00 2,944.79 71.7 11,656.85 11,656.85 16,300.00 4,643.15 71.5 .00 .00 3,080.00 3,080.00 .0 185.42 185.42 .00 ( 185.42) .0 10,660.95 10,660.95 14,800.00 4,139.05 72.0 127,586.15 127,586.15 180,080.00 52,493.85 70.9 142,143.71 142,143.71 212,056.00 69,912.29 67.0 3,576.48 3,576.48 .00 ( 3,576.48) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51PM PAGE: 59 CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 LAW ENF DEV IMPACT FEES ASSETS 27-0101-00-00 CASH 24,646.68 27-0151-25-00 FIRST INTERSTATE INVESTMENTS 50,032.96 TOTAL ASSETS 74,679.64 LIABILITIES AND EQUITY FUND EQUITY 27-0271-00-00 POLICE IMPACT FEE/FUND BALANCE 42,529.49 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 32.150.15 BALANCE - CURRENT DATE 32,150.15 TOTAL FUND EQUITY 74,679.64 TOTAL LIABILITIES AND EQUITY 74,679.64 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51 PM PAGE: 60 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 LAW ENF DEV IMPACT FEES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT 27-0322-19-00 RESIDENTIAL IMPACT FEES 27-0322-20-00 COMMERCIAL - IMPACT FEES 27-0371-25-00 BANK INTEREST 27-0399-00-00 CARRY OVER TOTAL FUND REVENUE EXPENDITURES CAPITAL IMPROVEMENTS 27-0438-00-00 EQUIPMENT 27-0438-01-00 CITY FACILITY TOTAL CAPITAL IMPROVEMENTS TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES 32,146.68 32,146.68 66,600.00 34,453.32 48.3 .00 .00 30,000.00 30,000.00 .0 3.47 3.47 100.00 96.53 3.5 .00 .00 45,000.00 45,000.00 .0 32,150.15 32,150.15 141,700.00 109,549.85 22.7 .00 .00 70,850.00 70,850.00 .0 .00 .00 70,850.00 70,850.00 .0 .00 .00 141,700.00 141,700.00 .0 .00 .00 141,700.00 141,700.00 .0 32,150.15 32,150.15 .00 ( 32,150.15) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51PM PAGE: 61 CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 CITY HALL BOND FUND LIABILITIES AND EQUITY FUND EQUITY 54-0271-00-00 FUND BALANCE 3,405.22 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 3,405.22) BALANCE - CURRENT DATE ( 3,405.22) TOTAL FUND EQUITY .00 TOTAL LIABILITIES AND EQUITY .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51 PM PAGE: 62 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 CITY HALL BOND FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT REVENUE 54-0399-01-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES BOND PAYMENTS 54-0480-81-00 PRINCIPAL BOND PAYMENT 54-0480-82-00 INTEREST BOND PAYMENT 54-0480-84-00 PAYING AGENT FEE TOTAL BOND PAYMENTS TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES 8,293.95 8,293.95 102,950.00 94,656.05 8.1 8,293.95 8,293.95 102,950.00 94,656.05 8.1 .00 .00 80,000.00 80,000.00 .0 11,249.17 11,249.17 22,500.00 11,250.83 50.0 450.00 450.00 450.00 .00 100.0 11,699.17 11,699.17 102,950.00 91,250.83 11.4 11,699.17 11,699.17 102,950.00 91,250.83 11.4 ( 3,405.22) ( 3,405.22) .00 3,405.22 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51PM PAGE: 63 60-0101-00-00 CASH 60-0115-00-00 WATER/ACCOUNTS RECEIVABLE 60-0151-01-00 INVESTMENTS, DEQ LOAN PMTS 60-0151-02-00 INVESTMENTS, DEQ LOAN RESERVE 60-0151-25-00 FIRST INTERSTATE INVESTMENT 60-0161-00-00 WATER/LAND 60-0162-00-00 WATER/BUILDINGS & STRUCTURES 60-0163-00-00 WATER/ACCUMULATED DEP.-BLDGS.& 60-0164-00-00 WATER/IMPROVEMENTS-OTHER THAN 60-0165-00-00 WATER/ACCUM. DEP.-IMPROVEMENTS 60-0166-00-00 WATER/MACHINERY & EQUIPMENT 60-0167-00-00 WATER/ACCUMULATED DEPREC-EQUIP 60-0170-00-00 HRA 10% DEPOSIT 60-0171-00-00 DEFERRED OUTFLOWS -PENSION TOTALASSETS LIABILITIES AND EQUITY LIABILITIES 60-0202-00-00 WATER/VOUCHERS PAYABLE 60-0204-00-00 WATER/LEXINGTON - TVV 60-0215-00-00 INTEREST PAYABLE 60-0216-00-00 ACCRUED PAYROLL 60-0217-00-00 COMPENSATED ABSENCE PAYABLE 60-0217-01-00 STATE WITHHOLDING 60-0217-02-00 FEDERAL WITHHOLDING TAX 60-0217-03-00 FICA 60-0217-04-00 PUBLIC RETIREMENT 60-0217-04-01 401 K PERSI CHOICE PLAN 60-0217-07-00 WATER DEPT HEALTH INSURANCE 60-0217-08-00 GARNISHMENTS 60-0217-09-00 WORKERS' COMPENSATION 60-0217-10-00 HSACONTRIBUTION 60-0217-11-00 NET PENSION LIABILITY 60-0217-12-00 DEFERRED INFLOWS -PENSION 60-0220-00-00 WATER/SERVICE DEPOSITS 60-0231-00-00 DEQ LOAN Itell /_104F_1:111111aw FUND EQUITY 60-0271-00-00 WATER/FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 WATER FUND 1,195, 785.16 537,949.44 144,604.50 605,780.24 182,000.00 4,259,118.91 93,250.00 559,285.00 172,451.00) 12,593,065.00 3,518,225.00) 1,394,602.00 915,756.00) 550.08 82,423.00 227.00) 1,787.89 15,099.00 6,081.88 13, 084.04 249.20) 465.94) 295.78) 263.84 282.99) 5,171.30 1,162.50 59,508.69 100.00) 5,717.00) 182,893.00 101,225.00 1,115,023.00 13,156,448.78 1,195,785.16 15,846,196.17 1,493,962.23 14,352,233.94 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51 PM PAGE: 64 CITY OF EAGLE BALANCE SHEET JUNE 30, 2022 WATER FUND TOTAL LIABILITIES AND EQUITY 15, 846,196.17 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51 PM PAGE: 65 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 REVENUE 60-0346-59-00 STL-STORAGE & TRUNK LINE FEE 60-0346-60-00 HOOK UP FEES CITY 60-0347-01-00 BILLING REVENUE 60-0347-02-00 OTHER REVENUE 60-0347-03-00 RECONNECT FEES 60-0347-04-00 DELINQUENT FEES 60-0347-05-00 MISCELLANEOUS REVENUE 60-0347-06-00 SYSTEM ENHANCEMENT FEE 60-0355-01-00 WCE-WATER CONST EQUIV FEE 60-0371-10-00 INVESTMENTS, DEQ, TRANSFERS 60-0371-25-00 BANK INTEREST 60-0399-00-00 CARRY OVER 60-0399-01-00 RESERVES, FOR BUDGET 60-0399-02-00 RESERVES, EMERGENCY REPL ITEMS 60-0399-03-00 RESERVES, EQUIP/BLDG REPLCMNT 60-0399-04-00 RESERVES, REPAIR/ MAINTENANCE 60-0399-05-00 RESERVES, VEHICLE REPLACEMENT 60-0399-06-00 RESERVES, STL FEES TOTAL FUND REVENUE EXPENDITURES VEHICLE OPERATIONS - LEASES 60-0420-01-00 GAS AND OIL 60-0420-03-00 VEHICLE MTNC & REPAIR TOTAL VEHICLE OPERATIONS - LEASES PERSONNEL 60-0433-10-00 SALARIES - FULL TIME 60-0433-10-02 ON -CALL TIME 60-0433-11-00 OVERTIME 60-0433-21-00 FICA 60-0433-22-00 PERSI 60-0433-23-00 HRA BUY -DOWN 60-0433-23-01 HRA/COBRAADMIN FEES 60-0433-24-00 WORKERS' COMPENSATION 60-0433-25-00 INSURANCE 60-0433-26-00 HSA CONTRIBUTIONS 60-0433-29-00 PTO CASH OUT TOTAL PERSONNEL WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT 807,452.31 807,452.31 105,000.00 ( 702,452.31) 769.0 151,970.00 151,970.00 157,500.00 5,530.00 96.5 905,320.88 905,320.88 1,158,396.00 253,075.12 78.2 6,420.00 6,420.00 8,400.00 1,980.00 76.4 175.00 175.00 600.00 425.00 29.2 7,600.50 7,600.50 8,736.00 1,135.50 87.0 7,579.56 7,579.56 7,500.00 ( 79.56) 101.1 334,620.52 334,620.52 400,000.00 65,379.48 83.7 33,600.00 33,600.00 20,000.00 ( 13,600.00) 168.0 733.24 733.24 .00 ( 733.24) .0 4,989.93 4,989.93 6,000.00 1,010.07 83.2 .00 .00 171,047.00 171,047.00 .0 .00 .00 310,000.00 310,000.00 .0 .00 .00 150,000.00 150,000.00 .0 .00 .00 225,000.00 225,000.00 .0 .00 .00 150,000.00 150,000.00 .0 .00 .00 60,000.00 60,000.00 .0 .00 .00 629,200.00 629,200.00 .0 2,260,461.94 2,260,461.94 3,567,379.00 1,306,917.06 63.4 5,850.25 5,850.25 15,000.00 9,149.75 39.0 2,262.56 2,262.56 9,000.00 6,737.44 25.1 8,112.81 8,112.81 24,000.00 15,887.19 33.8 222,175.45 222,175.45 372,000.00 149,824.55 59.7 1,542.22 1,542.22 7,500.00 5,957.78 20.6 1,011.23 1,011.23 4,500.00 3,488.77 22.5 16,851.39 16,851.39 29,400.00 12,548.61 57.3 26,875.36 26,875.36 45,900.00 19,024.64 58.6 .00 .00 7,700.00 7,700.00 .0 .00 .00 800.00 800.00 .0 12,207.15 12,207.15 13,500.00 1,292.85 90.4 31,490.84 31,490.84 58,500.00 27,009.16 53.8 1,800.00 1,800.00 2,400.00 600.00 75.0 1,077.22 1,077.22 15,000.00 13,922.78 7.2 315,030.86 315,030.86 557,200.00 242,169.14 56.5 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51PM PAGE: 66 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 OPERATIONS & MAINTENANCE 60-0434-15-00 OFFICE SUPPLIES 60-0434-19-00 TELECOMMUNICATIONS/SCADA 60-0434-20-00 ADVERTISING - PUBLICATIONS 60-0434-22-00 TRAVEL-MTNGS-EDUCATION 60-0434-23-00 DUES & SUBSCRIPTIONS 60-0434-25-00 MTNC EQUIP-COPIERS/SOFTWARE 60-0434-26-00 TOOLS, EQUIPMENT AND SUPPS 60-0434-27-00 POSTAGE 60-0434-41-00 LIABILITY INSURANCE 60-0434-42-00 ENGINEERING SERVICES 60-0434-42-01 LEGAL SERVICES 60-0434-42-02 MISC LEGAL AND ENG SERVICES 60-0434-43-01 CONTRACT SERVICES (REPAIR) 60-0434-44-00 DIG LINE 60-0434-45-00 CITY AUDITOR SERVICES 60-0434-47-00 MAIL SERVICE -CUSTOMER BILLING 60-0434-50-00 SHOP LEASE 60-0434-50-01 SHOP UTILITIES 60-0434-53-01 PUBLIC WATER DRINKING FEES 60-0434-53-03 PERMITS AND FEES 60-0434-58-00 RPR/MTNC-LINES-METERS-ETC 60-0434-58-01 RPR/MTNC PUMPS -WELLS -CHEMICAL 60-0434-59-00 CHEMICALS 60-0434-60-00 UTILITIES 60-0434-68-00 UNIFORMS AND SAFETY CLOTHING 60-0434-83-00 MAPPING PROFESSIONAL SERVICES TOTAL OPERATIONS & MAINTENANCE TESTI NG-W K-MO-QTR-AN N UAL 60-0435-56-00 TESTING-WK-MO-QTR-ANNUAL TOTAL TESTING-WK-MO-QTR-ANNUAL DEQ REVOLVING LOAN PAYMENT 60-0436-01-00 DEQ/STATE REVOLVING LOAN PMT TOTAL DEQ REVOLVING LOAN PAYMENT RESTRICTED 60-0437-01-00 STL FEES, WATER SYS EXPANSION 60-0437-03-00 STL FEES, REFUNDS 60-0437-99-01 RESERVES, STL FEES TOTAL RESTRICTED WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT 888.29 888.29 1,800.00 911.71 49.4 4,017.23 4,017.23 10,836.00 6,818.77 37.1 .00 .00 2,000.00 2,000.00 .0 1,075.00 1,075.00 8,000.00 6,925.00 13.4 709.00 709.00 3,100.00 2,391.00 22.9 4,149.28 4,149.28 7,800.00 3,650.72 53.2 4,004.58 4,004.58 10,000.00 5,995.42 40.1 .00 .00 1,300.00 1,300.00 .0 4,620.00 4,620.00 4,620.00 .00 100.0 16,656.45 16,656.45 35,000.00 18,343.55 47.6 1,002.50 1,002.50 25,000.00 23,997.50 4.0 12,328.50 12,328.50 145,920.00 133,591.50 8.5 3,714.75 3,714.75 35,000.00 31,285.25 10.6 3,012.70 3,012.70 4,500.00 1,487.30 67.0 2,500.00 2,500.00 2,500.00 .00 100.0 18,485.43 18,485.43 28,800.00 10,314.57 64.2 9,641.62 9,641.62 13,400.00 3,758.38 72.0 1,111.04 1,111.04 4,800.00 3,688.96 23.2 12,112.00 12,112.00 12,800.00 688.00 94.6 .00 .00 1,500.00 1,500.00 .0 3,748.65 3,748.65 40,000.00 36,251.35 9.4 6,214.06 6,214.06 50,000.00 43,785.94 12.4 4,934.13 4,934.13 9,000.00 4,065.87 54.8 29,197.69 29,197.69 55,000.00 25,802.31 53.1 1,162.33 1,162.33 2,300.00 1,137.67 50.5 .00 .00 25,000.00 25,000.00 .0 145,285.23 145,285.23 539,976.00 394,690.77 26.9 14,666.00 14,666.00 12,000.00 ( 2,666.00) 122.2 14,666.00 14,666.00 12,000.00 ( 2,666.00) 122.2 400,000.00 400,000.00 400,000.00 .00 100.0 400,000.00 400,000.00 400,000.00 .00 100.0 34,754.00 34,754.00 100,000.00 65,246.00 34.8 .00 .00 50,000.00 50,000.00 .0 .00 .00 35,000.00 35,000.00 .0 34,754.00 34,754.00 185,000.00 150,246.00 18.8 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51PM PAGE: 67 CAPITAL EXPENDITURES 60-0438-01-00 EQUIPMENT 60-0438-05-01 CURRENT STL PROJECTS 60-0438-05-02 HORSESHOE BND1-GREENBROOK 60-0438-08-00 METER SETS, NEW CUSTOMERS 60-0438-10-00 WATER MASTER PLAN -UPDATE 60-0438-11-00 CAPITAL CONSTRUCTION PROJECTS 60-0438-82-00 CITY HALL ADM OVERHEAD 60-0438-99-01 RESERVES, FOR BUDGET 60-0438-99-02 RESERVES, EMERGENCY REPL ITEMS 60-0438-99-03 RESERVES, EQUIP, BLDG REPLCMNT 60-0438-99-04 RESERVES, WATER SYSTEM R&M 60-0438-99-05 RESERVES, VEHICLE REPLACEMENT 60-0438-99-06 RESERVES, IDENTIFIED PROJECTS TOTAL CAPITAL EXPENDITURES TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2022 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT 6,313.00 6,313.00 9,950.00 3,637.00 63.5 .00 .00 549,200.00 549,200.00 .0 5,930.57 5,930.57 .00 ( 5,930.57) .0 76,025.44 76,025.44 86,250.00 10,224.56 88.2 31,280.00 31,280.00 40,000.00 8,720.00 78.2 17,675.87 17,675.87 134,000.00 116,324.13 13.2 9,603.00 9,603.00 12,803.00 3,200.00 75.0 .00 .00 325,000.00 325,000.00 .0 .00 .00 175,000.00 175,000.00 .0 .00 .00 250,000.00 250,000.00 .0 .00 .00 175,000.00 175,000.00 .0 .00 .00 72,000.00 72,000.00 .0 .00 .00 20,000.00 20,000.00 .0 146,827.88 146,827.88 1,849,203.00 1,702,375.12 7.9 1,064,676.78 1,064,676.78 3,567,379.00 2,502,702.22 29.8 1,195, 785.16 1,195, 785.16 .00 ( 1,195,785.16) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2022 01:51PM PAGE: 68