Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Finance - Quarterly Reports - FY 21/22 4th Quarter - 09/30/2022
CITY OF EAGLEQUARTERLY TREASURER'S REPORT FOR THE THREE MONTHS ENDING SEPTEMBER 30, 2022 BEGINNING CASH ANNUAL %ANNUAL %CHANGE IN ENDING CASH FUND NUMBER AND TITLE BALANCE REVENUES REALIZED EXPENDITURES EXPENDED BALANCE SHEET BALANCE 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:45PM PAGE: 1 01 GENERAL FUND 706,917.31 3,015,119.74 77.39 2,923,486.38 58.48 ( 952,046.27) 1,750,596.94 06 LIBRARY FUND 13,938.73 435,792.10 73.12 471,443.87 66.83 ( 116,294.66)94,581.62 07 MUSEUM FUND .00 29,475.49 49.87 32,160.19 80.58 ( 2,684.70).00 08 PARK IMPACT FEE FUND 39,600.59 40,023.61 5.45 1,992,617.71 36.15 ( 2,013,685.37)100,691.86 09 RECREATION - SPECIAL EVENTS 81,717.22 18,257.07 18.03 40,926.67 53.78 ( 7,795.17)66,842.79 10 EAGLE HISTORICAL COMMISSION 21,016.85 .00 19.26 14.51 .16 .00 21,002.34 11 EXECUTIVE DEPARTMENT .00 78,108.89 73.34 85,536.01 74.97 ( 7,427.12).00 12 CITY CLERK/TREAS DEPARTMENT .00 148,249.28 91.16 164,032.00 91.51 ( 15,782.72).00 13 BUILDING DEPARTMENT .00 230,116.47 84.14 277,239.46 84.54 ( 47,122.99).00 14 P&Z DEPARTMENT .00 251,830.49 78.71 276,923.04 79.06 ( 25,092.55).00 17 RECREATION - PARKS AND REC 10,379.74 154,390.21 50.88 180,525.36 76.33 ( 15,755.41).00 18 IT DEPARTMENT .00 198,728.10 83.91 224,324.69 83.19 ( 25,596.59).00 19 CAPITAL PROJECTS FUND 3,866,277.53 207,037.77 17.10 2,567,408.48 48.54 1,274,886.02 231,020.80 21 ARTS COMMISSION 14,204.16 24,848.15 32.67 39,052.31 64.40 .00 .00 23 PUBLIC WORKS .00 477,275.60 38.34 536,668.96 70.04 ( 59,393.36).00 24 RECREATION - EAGLE FUN DAYS .00 80,623.97 84.67 75,854.50 65.11 .00 4,769.47 25 PATHWAY IMPACT FEE FUND 49,584.50 11,891.49 10.16 .00 .05 35,654.49 25,821.50 26 ECONOMIC DEVELOPMENT .00 28,137.85 81.99 32,764.08 82.48 ( 4,626.23).00 27 LAW ENF DEV IMPACT FEES 24,646.68 4,480.68 25.85 .00 .00 15,036.84 14,090.52 54 CITY HALL BOND FUND .00 91,249.76 96.69 91,249.76 100.00 .00 .00 60 WATER FUND 537,949.44 1,360,842.24 101.51 1,008,047.85 58.10 ( 46,381.59)937,125.42 61 FIBER FUND .00 2,390,649.30 .00 .00 .00 2,350,669.30 39,980.00 99 COMBINED CASH FUND ( 5,366,232.75).00 .00 .00 .00 ( 2,079,709.49) ( 3,286,523.26) TOTAL .00 9,277,128.26 11,020,275.83 ( 1,743,147.57).00 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, October 21, 2022 CITY OF EAGLE COMBINED CASH INVESTMENT SEPTEMBER 30, 2022 FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:29PM PAGE: 1 COMBINED CASH ACCOUNTS 99-0103-00-00 CASH IN CHECKING 3,028,356.01 99-0107-00-00 CASH CLEARING-UTILITY BILLING 302.48 99-0108-00-00 CASH CLEARING-ACCOUNTS REC 257,864.77 TOTAL COMBINED CASH 3,286,523.26 99-0101-00-00 CASH ALLOCATED TO OTHER FUNDS ( 3,286,523.26) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 1 ALLOCATION TO GENERAL FUND 1,750,596.94 6 ALLOCATION TO LIBRARY FUND 94,581.62 8 ALLOCATION TO PARK IMPACT FEE FUND 100,691.86 9 ALLOCATION TO RECREATION - SPECIAL EVENTS 66,842.79 10 ALLOCATION TO EAGLE HISTORICAL COMMISSION 21,002.34 19 ALLOCATION TO CAPITAL PROJECTS FUND 231,020.80 24 ALLOCATION TO RECREATION - EAGLE FUN DAYS 4,769.47 25 ALLOCATION TO PATHWAY IMPACT FEE FUND 25,821.50 27 ALLOCATION TO LAW ENF DEV IMPACT FEES 14,090.52 60 ALLOCATION TO WATER FUND 937,125.42 61 ALLOCATION TO FIBER FUND 39,980.00 TOTAL ALLOCATIONS TO OTHER FUNDS 3,286,523.26 ALLOCATION FROM COMBINED CASH FUND - 99-0101-00-00 ( 3,286,523.26) ZERO PROOF IF ALLOCATIONS BALANCE .00 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:29PM PAGE: 2 ASSETS 01-0101-00-00 CASH 1,750,596.94 01-0103-00-00 PETTY CASH 100.00 01-0107-00-00 TAXES RECEIVABLE DELINQUENT 14,402.55 01-0115-00-00 ACCOUNTS RECEIVABLE 40,700.48 01-0132-00-00 DUE FROM OTHER GOVERNMNTL UNTS 863,581.36 01-0151-25-00 FIRST INTERSTATE INVESTMENT 6,547,263.62 01-0151-28-00 ICCU CD 51,010.37 01-0170-00-00 HRA 10 % DEPOSIT 5,785.92 TOTAL ASSETS 9,273,441.24 LIABILITIES AND EQUITY LIABILITIES 01-0202-00-00 VOUCHERS PAYABLE 98,441.77 01-0203-00-00 ACCTS PAYABLE-ACHD IMPACT FEES ( 3,628.00) 01-0203-01-01 BONDS DEPOSITS PAYABLE 1,699,814.98 01-0203-01-02 FIREWORKS BOND DEPOSIT PAYABLE ( 2,000.00) 01-0203-01-03 VENDORS BOND DEPOSITS PAYABLE 5,139.00 01-0203-01-05 P&Z DEPOSITS PAYABLE 309,873.75 01-0203-01-06 LAND USE DEPOSITS PAYABLE 51,010.37 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,536.89 01-0226-00-00 DEFERRED REVENUE 12,637.20 TOTAL LIABILITIES 2,161,960.85 FUND EQUITY 01-0271-00-00 FUND BALANCE 3,834,619.85 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 3,276,860.54 BALANCE - CURRENT DATE 3,276,860.54 TOTAL FUND EQUITY 7,111,480.39 TOTAL LIABILITIES AND EQUITY 9,273,441.24 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:30PM PAGE: 3 REVENUE 01-0311-00-00 PROPERTY TAX 877,630.12 2,763,180.77 2,708,042.00 ( 55,138.77)102.0 01-0311-01-00 PENALTY/INTEREST ON TAXES 2,083.28 4,458.01 3,000.00 ( 1,458.01)148.6 01-0312-00-00 PERSONAL PROPERTY TAX REIMBURS 4,231.42 8,462.85 8,463.00 .15 100.0 01-0316-10-00 FRANCHISE FEE/EAGLE WATER CO..00 2,365.15 5,000.00 2,634.85 47.3 01-0316-10-02 FRANCHISE FEE/VEOLIA 6,995.68 19,480.45 15,000.00 ( 4,480.45)129.9 01-0316-11-00 FRANCHISE FEE/INTERMTN GAS 65,554.03 308,988.29 270,000.00 ( 38,988.29)114.4 01-0316-12-00 FRANCHISE FEE/CABLE TV 27,588.97 111,424.10 112,000.00 575.90 99.5 01-0316-13-00 FRANCHISE FEE/TRASH 99,673.99 376,608.72 275,000.00 ( 101,608.72)137.0 01-0316-14-00 FRANCHISE FEE/IDAHO POWER 47,468.22 238,420.16 212,000.00 ( 26,420.16)112.5 01-0321-10-00 ALCOHOLIC BEVERAGE LICENSES 3,035.00 41,064.13 30,000.00 ( 11,064.13)136.9 01-0321-30-00 BUSINESS LICENSE FEE 5,880.00 21,565.00 16,500.00 ( 5,065.00)130.7 01-0322-10-00 BUILDING & INSPECTION PERMITS 162,521.22 1,134,863.18 1,770,000.00 635,136.82 64.1 01-0322-12-00 BUILDING, PLAN REVIEW FEES 68,273.56 438,971.34 525,000.00 86,028.66 83.6 01-0322-13-00 ENERGY STANDARDS (IRES)2,200.00 15,600.00 30,000.00 14,400.00 52.0 01-0322-14-00 ELECTRICAL PERMIT FEES 63,852.05 263,886.14 252,000.00 ( 11,886.14)104.7 01-0322-15-00 PLUMBING PERMIT FEES 38,565.27 189,429.32 252,000.00 62,570.68 75.2 01-0322-16-00 MECHANICAL PERMIT FEES 54,666.94 264,144.18 252,000.00 ( 12,144.18)104.8 01-0322-20-00 FIRE IMPACT ADMIN FEES 680.00 6,810.00 12,000.00 5,190.00 56.8 01-0323-01-00 PZ ANNEX/ZONING PERMIT FEES 88,382.86 375,334.17 210,000.00 ( 165,334.17)178.7 01-0323-02-00 PLANNING INSPECTION FEES 2,450.00 3,665.00 8,000.00 4,335.00 45.8 01-0323-03-00 PLANNING, PLAN REVIEW FEES 5,950.00 24,925.00 40,000.00 15,075.00 62.3 01-0323-04-00 STREET LIGHT INSPECTION FEES 180.00 1,920.00 1,200.00 ( 720.00)160.0 01-0323-05-00 SURETY/LETTER OF CREDIT FEES 900.00 6,730.00 4,000.00 ( 2,730.00)168.3 01-0323-06-00 GRADING-DRAINAGE PERMIT FEES 2,250.00 10,767.50 16,000.00 5,232.50 67.3 01-0323-10-00 SPRING VALLEY STAFF TIME REIMB 3,281.25 3,281.25 10,000.00 6,718.75 32.8 01-0323-11-00 AVIMOR STAFF TIME REIMBURSE 8,662.50 8,662.50 85,000.00 76,337.50 10.2 01-0323-12-00 PZ STAFF TIME REIMBURSE .00 46,176.25 .00 ( 46,176.25).0 01-0324-01-00 TREE FUND .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 129,451.00 659,523.00 678,514.00 18,991.00 97.2 01-0335-50-00 STATE SALES TAX, AG REPL 4.75 23.75 .00 ( 23.75).0 01-0335-60-00 STATE REVENUE SHARING 1,019,622.80 3,363,769.02 3,019,563.00 ( 344,206.02)111.4 01-0338-40-00 COURT FEES 15,177.86 53,439.10 30,000.00 ( 23,439.10)178.1 01-0338-41-00 CITATION FEES/CODE ENFORCEMENT .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 1,961.00 6,594.00 4,000.00 ( 2,594.00)164.9 01-0341-12-00 ANIMAL CONTROL FEES 1,284.00 9,931.00 12,000.00 2,069.00 82.8 01-0341-13-00 ENGINEERING FEES - DEVELOPERS 99,143.72 382,682.98 150,000.00 ( 232,682.98)255.1 01-0341-14-00 ATTORNEY FEES - DEVELOPERS 9,184.00 31,559.00 15,000.00 ( 16,559.00)210.4 01-0341-15-00 MISC REIMBURSEMENTS-DEVELOPERS 2,000.00 12,656.00 .00 ( 12,656.00).0 01-0341-17-00 CID STAFF & MISC REIMBURSEMENT 210.13 4,935.01 1,000.00 ( 3,935.01)493.5 01-0341-20-00 REIMBURSE FROM WATER DEPT 28,200.00 37,803.00 12,803.00 ( 25,000.00)295.3 01-0341-21-00 PRESSURIZED IRRIGATION REIMB .00 10,561.82 .00 ( 10,561.82).0 01-0341-26-00 BACKGROUND CHECKS 107.25 1,136.75 1,500.00 363.25 75.8 01-0341-27-00 URA CITY STAFF REIMBURSEMENT 450.22 2,658.10 4,800.00 2,141.90 55.4 01-0341-28-00 ID POWER SUBSTATION WATER USE .00 120.00 120.00 .00 100.0 01-0341-29-00 REVEL EAGLE-EASEMENT-MERRILL P .00 1,000.00 1,000.00 .00 100.0 01-0350-02-00 IDAHO OPIOID SETTLEMENT 5,263.91 5,263.91 .00 ( 5,263.91).0 01-0350-05-00 FIELD OF HONOR 2,505.00 29,862.10 10,000.00 ( 19,862.10)298.6 01-0350-07-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:30PM PAGE: 4 01-0371-25-00 BANK INVESTMENT INTEREST 8,605.82 17,896.57 7,000.00 ( 10,896.57)255.7 01-0379-00-00 MISCELLANEOUS ( 2,566.57)47.03 1,000.00 952.97 4.7 01-0379-01-00 DUPLICATION/PUBLISHING/PRINTNG ( 1.20)405.13 500.00 94.87 81.0 01-0382-02-00 PROMOTIONAL SALES 7,500.00 8,010.00 .00 ( 8,010.00).0 01-0383-05-00 MISCELLANEOUS-REIMBURSEABLES 1,245.12 8,659.96 1,500.00 ( 7,159.96)577.3 01-0383-09-00 ROOM RESERVATIONS 1,273.08 2,249.08 600.00 ( 1,649.08)374.9 01-0383-14-00 SETTLEMENTS .00 1,750,000.00 .00 ( 1,750,000.00).0 01-0383-15-00 MISCELLANEOUS REVENUE 1,027.00 3,704.20 .00 ( 3,704.20).0 01-0383-16-00 INSURANCE REIMBURSEABLES 3,987.93 6,646.55 .00 ( 6,646.55).0 01-0385-00-00 FIRE DEPT IMPACT FEES 36,526.56 301,570.68 538,200.00 236,629.32 56.0 01-0399-00-00 CARRY OVER .00 .00 5,560,218.00 5,560,218.00 .0 TOTAL FUND REVENUE 3,015,119.74 13,409,856.20 17,328,023.00 3,918,166.80 77.4 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:30PM PAGE: 5 RESERVES 01-0410-19-00 RESERVES, EMERGENCIES .00 .00 480,673.00 480,673.00 .0 TOTAL RESERVES .00 .00 480,673.00 480,673.00 .0 ADMINISTRATION 01-0413-01-00 P&Z COMMISSIONERS COMPENSATION 1,110.00 3,920.00 4,200.00 280.00 93.3 01-0413-02-00 DESIGN REVIEW BRD COMPENSATION 1,450.00 5,030.00 5,000.00 ( 30.00)100.6 01-0413-05-00 OFFICE EXPENSES 7,262.39 21,291.93 25,000.00 3,708.07 85.2 01-0413-06-00 PRINTING & DISTRIBUTION .00 19.50 2,500.00 2,480.50 .8 01-0413-07-00 POSTAGE .00 8,436.87 9,000.00 563.13 93.7 01-0413-08-00 LEGAL ADVERTISING/PUBLICATION 2,863.38 5,005.22 8,000.00 2,994.78 62.6 01-0413-10-00 INSURANCE - PROPERTY .00 51,438.00 57,000.00 5,562.00 90.2 01-0413-12-00 PERSONNEL TRAINING 612.50 877.50 3,000.00 2,122.50 29.3 01-0413-13-00 TRAVEL & PER DIEM .00 .00 2,000.00 2,000.00 .0 01-0413-14-00 PROFESSIONAL DUES AND SERVICES 2,868.75 63,197.60 163,827.00 100,629.40 38.6 01-0413-25-00 MISCELLANEOUS 35.00 322.70 40,000.00 39,677.30 .8 01-0413-28-00 RESOURCE MATERIALS 2,811.11 7,842.16 4,500.00 ( 3,342.16)174.3 01-0413-29-00 REAL PROPERTY TAXES - CITY .00 231.58 225.00 ( 6.58)102.9 01-0413-30-00 CONSULTANT FEES - DEVELOPERS 4,000.00 4,000.00 .00 ( 4,000.00).0 01-0413-31-00 ENGINEERING FEES - DEVELOPERS 98,267.52 418,386.95 150,000.00 ( 268,386.95)278.9 01-0413-33-00 ATTORNEY FEES - DEVELOPERS 13,546.00 38,433.00 15,000.00 ( 23,433.00)256.2 01-0413-37-00 BACKGROUND CHECK-PERMITS/LIC 820.74 4,283.02 1,250.00 ( 3,033.02)342.6 01-0413-40-00 INSURANCE REIMBURSEABLES 2,838.99 9,240.49 .00 ( 9,240.49).0 01-0413-44-00 PHOTOS - MAYOR/CITY COUNCIL .00 172.33 900.00 727.67 19.2 01-0413-46-00 PROPERTY TAX EXP -3%.00 .00 250.00 250.00 .0 01-0413-50-00 JOB POSTINGS .00 3,567.25 6,000.00 2,432.75 59.5 01-0413-51-00 BACKGROUND CHK, PRE-EMPLOYMENT .00 237.79 1,500.00 1,262.21 15.9 01-0413-52-00 DRUG TESTING, PRE-EMPLOYMENT 224.00 1,024.00 1,500.00 476.00 68.3 TOTAL ADMINISTRATION 138,710.38 646,957.89 500,652.00 ( 146,305.89)129.2 PERSONNEL 01-0415-11-00 SALARIES - COUNCIL 12,720.00 50,880.00 50,880.00 .00 100.0 01-0415-21-00 FICA 973.08 3,892.32 4,500.00 607.68 86.5 01-0415-22-00 PERSI 1,518.72 6,074.88 6,200.00 125.12 98.0 01-0415-23-01 HRA/COBRA ADMIN FEES 466.36 1,064.47 1,800.00 735.53 59.1 01-0415-24-00 WORKERS' COMPENSATION 17.76 38,145.39 54,374.00 16,228.61 70.2 01-0415-24-01 WORK COMP/BOARDS-COMMISSIONS .00 69.76 100.00 30.24 69.8 01-0415-25-00 INSURANCE .00 .00 12,000.00 12,000.00 .0 01-0415-28-00 UNEMPLOYMENT BENEFITS .00 2,731.97 .00 ( 2,731.97).0 TOTAL PERSONNEL 15,695.92 102,858.79 129,854.00 26,995.21 79.2 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:30PM PAGE: 6 CONTRACTS & AGREEMENTS 01-0416-02-00 CITY ATTORNEY 38,177.64 126,944.14 250,000.00 123,055.86 50.8 01-0416-02-02 LITIGATION ATTORNEYS FEES .00 3,647.00 50,000.00 46,353.00 7.3 01-0416-05-00 PROSECUTOR 10,666.00 64,000.00 65,500.00 1,500.00 97.7 01-0416-06-00 IDAHO HUMANE SOCIETY 24,095.84 132,527.10 144,575.00 12,047.90 91.7 01-0416-07-00 CITY ENGINEERING 400.00 686.25 50,000.00 49,313.75 1.4 01-0416-07-04 PARK/REC ENGINEERING FEES .00 .00 20,000.00 20,000.00 .0 01-0416-08-00 CITY AUDITOR SERVICES 4,125.00 21,375.00 21,000.00 ( 375.00)101.8 01-0416-09-00 LAW ENFORCEMENT DEPARTMENT 893,166.00 3,572,671.12 3,572,672.00 .88 100.0 01-0416-23-00 GRANT WRITER .00 .00 15,000.00 15,000.00 .0 01-0416-34-00 BUDGET RESERVES, FY 1ST QTR .00 .00 1,500,000.00 1,500,000.00 .0 01-0416-35-00 ADMINISTRATION RESERVES .00 14,720.50 200,000.00 185,279.50 7.4 01-0416-45-00 CONSULTANTS FEES 4,437.25 4,437.25 .00 ( 4,437.25).0 01-0416-46-00 ALLUMBAUGH HOUSE .00 13,311.75 17,749.00 4,437.25 75.0 01-0416-49-00 DRUGFREE IDAHO 411.73 1,666.15 1,090.00 ( 576.15)152.9 01-0416-54-00 IDAHO SUICIDE PREVENTION .00 10,000.00 10,000.00 .00 100.0 01-0416-55-00 EAGLE SENIOR CENTER 12,500.00 50,000.00 50,000.00 .00 100.0 01-0416-56-00 CRIME STOPPERS .00 3,500.00 3,500.00 .00 100.0 TOTAL CONTRACTS & AGREEMENTS 987,979.46 4,019,486.26 5,971,086.00 1,951,599.74 67.3 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 20,723.56 24,627.38 10,000.00 ( 14,627.38)246.3 01-0422-15-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 TOTAL RESTRICTED 20,723.56 24,627.38 14,000.00 ( 10,627.38)175.9 CONTINUING EDUCATION 01-0461-01-00 CONTINUING EDUCATION .00 2,626.00 3,800.00 1,174.00 69.1 TOTAL CONTINUING EDUCATION .00 2,626.00 3,800.00 1,174.00 69.1 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:30PM PAGE: 7 PUBLIC AFFAIRS/COMM RELATIONS 01-0462-01-00 PUBLIC RELATIONS 1,512.53 5,057.93 6,000.00 942.07 84.3 01-0462-02-00 AWARDS & RECOGNITIONS 131.75 1,088.83 1,500.00 411.17 72.6 01-0462-03-00 CITY BRANDING/LOGO .00 .00 5,000.00 5,000.00 .0 TOTAL PUBLIC AFFAIRS/COMM RELATIONS 1,644.28 6,146.76 12,500.00 6,353.24 49.2 GENERAL FUND TRANSFERS 01-0463-01-00 MUSEUM DEPT TRANSFER 29,475.49 77,139.79 142,185.00 65,045.21 54.3 01-0463-02-00 ARTS COMMISSION TRANSFER 24,848.15 24,848.15 44,901.00 20,052.85 55.3 01-0463-04-00 HISTORICAL COMMISSION TRANSFER .00 .00 3,118.00 3,118.00 .0 01-0463-05-00 SPECIAL EVENTS TRANSFER .00 .00 221,095.00 221,095.00 .0 01-0463-06-00 RECREATION PARKS-REC TRANSFER 82,309.26 82,309.26 443,770.00 361,460.74 18.6 01-0463-07-00 CAPITAL PROJECTS TRANSFER .00 .00 1,708,900.00 1,708,900.00 .0 01-0463-08-00 EAGLE FUN DAYS TRANSFER 70,491.24 110,118.32 90,000.00 ( 20,118.32)122.4 01-0463-11-00 PUBLIC WORKS TRANSFER 471,618.24 903,553.25 2,167,755.00 1,264,201.75 41.7 01-0463-11-01 EXECUTIVE DEPT TRANSFER 78,108.89 293,377.68 400,030.00 106,652.32 73.3 01-0463-12-00 CITY HALL BOND FUND TRANSFER 91,249.76 99,543.71 102,950.00 3,406.29 96.7 01-0463-12-01 CLERK/TREAS DEPT TRANSFER 148,249.28 571,133.60 626,550.00 55,416.40 91.2 01-0463-13-01 BUILDING DEPT TRANSFER 230,116.47 972,986.76 1,156,430.00 183,443.24 84.1 01-0463-14-01 PLANNING AND ZONING DEPT TRANS 251,830.49 955,674.06 1,214,100.00 258,425.94 78.7 01-0463-18-01 IT DEPT TRANSFER 198,728.10 750,041.28 893,820.00 143,778.72 83.9 01-0463-26-01 ECONOMIC DEV DEPT TRANSFER 28,137.85 173,858.04 212,056.00 38,197.96 82.0 TOTAL GENERAL FUND TRANSFERS 1,705,163.22 5,014,583.90 9,427,660.00 4,413,076.10 53.2 COMMUNITY PROJECTS-CAP OUTLAY 01-0468-10-00 VRT HWY 44 EXPRESS SRV ENHANC .00 2,644.00 87,898.00 85,254.00 3.0 01-0468-10-01 VRT EAGLE SENIOR CITIZENS .00 9,700.00 9,700.00 .00 100.0 TOTAL COMMUNITY PROJECTS-CAP OUTLA .00 12,344.00 97,598.00 85,254.00 12.7 FIRE DEPARTMENT IMPACT FEES 01-0469-00-00 FIRE DEPT IMPACT FEES 53,569.56 303,364.68 538,200.00 234,835.32 56.4 TOTAL FIRE DEPARTMENT IMPACT FEES 53,569.56 303,364.68 538,200.00 234,835.32 56.4 TOTAL FUND EXPENDITURES 2,923,486.38 10,132,995.66 17,328,023.00 7,195,027.34 58.5 NET REVENUE OVER EXPENDITURES 91,633.36 3,276,860.54 .00 ( 3,276,860.54).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 LIBRARY FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:30PM PAGE: 8 ASSETS 06-0101-00-00 CASH 94,581.62 06-0103-00-00 LIBRARY/PETTY CASH 300.00 06-0104-00-00 PETTY CASH-CHILDRENS PROGRAMS 300.00 06-0107-00-00 LIBRARY/TAXES RECEIVABLE 8,865.78 06-0151-25-00 FIRST INTERSTATE INVESTMENT 925,115.17 06-0170-00-00 HRA 10% DEPOSIT 1,872.00 TOTAL ASSETS 1,031,034.57 LIABILITIES AND EQUITY LIABILITIES 06-0202-00-00 LIBRARY/VOUCHERS PAYABLE 4,017.88 06-0216-00-00 LIBRARY/ACCRUED PAYROLL 19,220.15 06-0217-03-00 LIBRARY/FICA 3,039.93 06-0217-04-00 LIBRARY/PUBLIC RETIREMENT 3,284.67 06-0217-07-00 LIBRARY HEALTH INSURANCE 14,032.25 06-0217-09-00 WORKERS' COMPENSATION 14,637.32 06-0217-10-00 HSA CONTRIBUTION 2,454.00 06-0226-00-00 DEFERRED REVENUE 7,786.25 TOTAL LIABILITIES 68,472.45 FUND EQUITY 06-0271-00-00 LIBRARY/FUND BALANCE 832,267.12 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 130,295.00 BALANCE - CURRENT DATE 130,295.00 TOTAL FUND EQUITY 962,562.12 TOTAL LIABILITIES AND EQUITY 1,031,034.57 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:30PM PAGE: 9 REVENUE 06-0356-00-00 LIBRARY/PROPERTY TAX REVENUE 431,533.66 1,492,845.00 1,492,845.00 .00 100.0 06-0356-01-00 LIBRARY/PENALTY & INT PROP TXS .00 1,462.76 1,000.00 ( 462.76)146.3 06-0361-20-00 LIBRARY/FINES/FEES 1,115.08 3,517.55 .00 ( 3,517.55).0 06-0361-20-01 LOST ITEMS 1,466.96 5,490.33 2,500.00 ( 2,990.33)219.6 06-0361-21-00 LIBRARY/COPY MACHINE REVENUE 469.62 1,759.60 3,600.00 1,840.40 48.9 06-0361-21-01 3 D PRINTING .00 4.92 400.00 395.08 1.2 06-0371-25-00 BANK INTEREST 855.80 2,199.79 700.00 ( 1,499.79)314.3 06-0379-00-00 MISCELLANEOUS 330.98 7,612.31 750.00 ( 6,862.31)1015.0 06-0380-02-00 GRANTS-GIFTS-MEMORIALS 20.00 20.00 .00 ( 20.00).0 06-0399-00-00 CARRY OVER .00 .00 120,040.00 120,040.00 .0 06-0399-01-00 BUDGET RESERVE, FY 1ST QTR .00 .00 450,000.00 450,000.00 .0 TOTAL FUND REVENUE 435,792.10 1,514,912.26 2,071,835.00 556,922.74 73.1 EXPENDITURES RESERVES 06-0410-01-00 RESERVES .00 .00 460,000.00 460,000.00 .0 TOTAL RESERVES .00 .00 460,000.00 460,000.00 .0 CONTRACTS/AGREEMENTS 06-0416-01-00 LEGAL - CITY ATTORNEY 2,250.00 3,072.50 10,000.00 6,927.50 30.7 06-0416-02-00 PHOTOCOPIERS 2,665.04 6,726.52 14,570.00 7,843.48 46.2 TOTAL CONTRACTS/AGREEMENTS 4,915.04 9,799.02 24,570.00 14,770.98 39.9 OPERATIONS & MAINTENANCE 06-0420-01-00 ADMINISTRATION 6,409.21 22,906.77 15,000.00 ( 7,906.77)152.7 06-0420-03-00 OPERATIONS SUBSCRIPTIONS 11,745.45 44,271.15 41,310.00 ( 2,961.15)107.2 06-0420-04-00 MARKETING 11,508.58 25,250.23 11,300.00 ( 13,950.23)223.5 06-0420-04-01 OUTREACH .00 20.51 2,500.00 2,479.49 .8 06-0420-05-00 OFFICE SUPPLIES 1,145.76 7,559.59 9,373.00 1,813.41 80.7 06-0420-05-01 MATERIAL PROCESSING SUPPLIES 7,716.21 10,521.48 8,000.00 ( 2,521.48)131.5 06-0420-06-00 UNIFORMS 2,820.20 5,724.96 3,905.00 ( 1,819.96)146.6 06-0420-07-00 SMALL FURNITURE REPLACEMENT 1,051.85 6,861.06 1,400.00 ( 5,461.06)490.1 06-0420-09-00 MAINTENANCE AGREEMENTS 12,638.04 26,201.04 31,194.00 4,992.96 84.0 06-0420-10-00 POSTAGE 1,829.16 2,909.52 2,500.00 ( 409.52)116.4 06-0420-11-00 SUBSCRIPTIONS & MEMBERSHIPS 520.00 3,819.63 11,000.00 7,180.37 34.7 06-0420-13-00 PRINTING AND PUBLISHING .00 909.10 1,500.00 590.90 60.6 TOTAL OPERATIONS & MAINTENANCE 57,384.46 156,955.04 138,982.00 ( 17,973.04)112.9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:30PM PAGE: 10 LYNX1 CONSORTIUM 06-0430-00-00 LYNK! SYSTEM 6,048.02 24,192.08 24,192.00 ( .08)100.0 06-0430-02-00 LYNX! COURIER 3,158.08 11,370.65 11,600.00 229.35 98.0 TOTAL LYNX1 CONSORTIUM 9,206.10 35,562.73 35,792.00 229.27 99.4 COST RECOVERY OR PASS THRU 06-0435-00-00 CREDIT CARD PROCESSING FEE 1,090.01 3,323.86 2,700.00 ( 623.86)123.1 06-0435-01-00 3D PRINTING .00 .00 2,600.00 2,600.00 .0 06-0435-02-00 LOST ITEMS REFUNDS .00 23.00 1,700.00 1,677.00 1.4 06-0435-03-00 OPEN ACCESS 929.71 1,820.27 1,200.00 ( 620.27)151.7 TOTAL COST RECOVERY OR PASS THRU 2,019.72 5,167.13 8,200.00 3,032.87 63.0 TECHNOLOGY 06-0440-00-00 COMPUTER SOFTWARE .00 .00 13,650.00 13,650.00 .0 06-0440-01-00 COMPUTER MAINTENANCE & REPAIR .00 .00 1,250.00 1,250.00 .0 06-0440-02-00 COMPUTER EQUIPMENT (SMALL).00 3,542.74 3,163.00 ( 379.74)112.0 TOTAL TECHNOLOGY .00 3,542.74 18,063.00 14,520.26 19.6 GUEST RESOURCES 06-0450-00-00 BOOKS 42,887.10 116,184.78 136,301.00 20,116.22 85.2 06-0450-01-00 PRINT VENDOR PROCESSING 894.24 5,873.64 6,000.00 126.36 97.9 06-0450-02-00 BOOKS -DIGITAL 42,787.08 64,108.38 61,919.00 ( 2,189.38)103.5 06-0450-03-00 MAGAZINES & NEWSPAPERS 88.99 683.36 5,920.00 5,236.64 11.5 06-0450-03-01 MAGAZINES - DIGITAL .00 11,014.00 9,606.00 ( 1,408.00)114.7 06-0450-04-00 MEDIA 29,962.97 93,889.52 74,057.00 ( 19,832.52)126.8 06-0450-05-00 MEDIA - DIGITAL 36,609.62 72,611.61 61,609.00 ( 11,002.61)117.9 06-0450-06-00 DATABASES .00 5,176.00 11,050.00 5,874.00 46.8 06-0450-07-00 HOTSPOT 1,052.52 3,141.39 5,562.00 2,420.61 56.5 TOTAL GUEST RESOURCES 154,282.52 372,682.68 372,024.00 ( 658.68)100.2 GUEST CLASSES & EVENTS 06-0455-00-00 CLASSES & EVENTS 18,881.64 35,334.39 25,000.00 ( 10,334.39)141.3 TOTAL GUEST CLASSES & EVENTS 18,881.64 35,334.39 25,000.00 ( 10,334.39)141.3 PERSONNEL 06-0461-10-00 SALARIES - FULL TIME 101,151.42 343,311.64 453,000.00 109,688.36 75.8 06-0461-10-01 SALARIES - PERSONNEL SERVICES 12,856.96 37,729.01 .00 ( 37,729.01).0 06-0461-11-00 OVERTIME 1,505.62 4,665.87 5,000.00 334.13 93.3 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:31PM PAGE: 11 06-0461-15-00 SALARIES - PART TIME 46,276.14 172,495.13 221,600.00 49,104.87 77.8 06-0461-15-01 SALARIES - PERSONNEL SERVICES 9,308.40 18,165.04 .00 ( 18,165.04).0 06-0461-21-00 FICA 11,240.07 39,504.14 51,990.00 12,485.86 76.0 06-0461-22-00 PERSI 12,278.70 42,090.21 54,050.00 11,959.79 77.9 06-0461-23-00 HRA BUY-DOWN .00 .00 5,500.00 5,500.00 .0 06-0461-23-01 HRA/COBRA ADMIN FEES 314.80 912.89 900.00 ( 12.89)101.4 06-0461-24-00 WORKERS' COMPENSATION 644.34 3,122.98 5,476.00 2,353.02 57.0 06-0461-25-00 INSURANCE 10,763.48 40,293.98 67,788.00 27,494.02 59.4 06-0461-26-00 HSA CONTRIBUTION 550.00 2,440.00 5,760.00 3,320.00 42.4 06-0461-27-00 PTO CASH OUT .00 4,533.95 20,000.00 15,466.05 22.7 06-0461-28-00 UNEMPLOYMENT BENEFITS .00 .00 18,540.00 18,540.00 .0 06-0461-29-00 EMPLOYMENT TESTING .00 .00 1,000.00 1,000.00 .0 TOTAL PERSONNEL 206,889.93 709,264.84 910,604.00 201,339.16 77.9 STAFF DEVELOPMENT 06-0463-00-00 TRAVEL & PER DIEM 3,251.89 3,801.89 17,300.00 13,498.11 22.0 06-0463-01-00 MILEAGE REIMBURSEMENT .00 .00 1,000.00 1,000.00 .0 06-0463-02-00 TRAINING .00 790.15 2,200.00 1,409.85 35.9 06-0463-03-00 CONTINUING EDUCATION 1,596.30 15,683.08 12,500.00 ( 3,183.08)125.5 06-0463-04-00 RECRUITMENT .00 324.00 1,000.00 676.00 32.4 06-0463-06-00 TRUSTEE-TRAVEL/MEETINGS .00 .00 5,600.00 5,600.00 .0 06-0463-08-00 VIRTUAL TRAINING 188.10 2,698.45 1,500.00 ( 1,198.45)179.9 TOTAL STAFF DEVELOPMENT 5,036.29 23,297.57 41,100.00 17,802.43 56.7 FACILITY (BLDGS & GROUNDS) 06-0464-00-00 BUILDING .00 8.00 1,500.00 1,492.00 .5 06-0464-01-00 BUILDING SUPPLIES .00 .00 1,500.00 1,500.00 .0 06-0464-02-00 UTILITIES 7,764.67 24,669.84 27,000.00 2,330.16 91.4 06-0464-03-00 TELEPHONE 434.26 2,105.38 2,000.00 ( 105.38)105.3 06-0464-04-00 SECURITY SYSTEM .00 534.96 3,000.00 2,465.04 17.8 06-0464-05-00 CUSTODIAL .00 104.93 .00 ( 104.93).0 06-0464-06-00 GROUNDS .00 .00 1,000.00 1,000.00 .0 06-0464-07-00 FLOOR MATS 288.00 1,246.77 1,500.00 253.23 83.1 TOTAL FACILITY (BLDGS & GROUNDS)8,486.93 28,669.88 37,500.00 8,830.12 76.5 CAPITAL IMPROVEMENT 06-0466-01-00 CAPITAL FURNISHING 4,341.24 4,341.24 .00 ( 4,341.24).0 TOTAL CAPITAL IMPROVEMENT 4,341.24 4,341.24 .00 ( 4,341.24).0 TOTAL FUND EXPENDITURES 471,443.87 1,384,617.26 2,071,835.00 687,217.74 66.8 NET REVENUE OVER EXPENDITURES ( 35,651.77)130,295.00 .00 ( 130,295.00).0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:31PM PAGE: 12 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 MUSEUM FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:31PM PAGE: 13 LIABILITIES AND EQUITY LIABILITIES 07-0202-00-00 VOUCHERS PAYABLE 1,585.39 07-0217-03-00 FICA 246.54 07-0217-04-00 MUSEUM/PERSI RETIREMENT 240.94 07-0217-07-00 MUSEUM HEALTH INSURANCE 879.55 07-0217-09-00 WORKERS' COMPENSATION 1,469.29 TOTAL LIABILITIES 4,421.71 FUND EQUITY 07-0271-00-00 MUSEUM FUND BALANCE 43,745.48 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 48,167.19) BALANCE - CURRENT DATE ( 48,167.19) TOTAL FUND EQUITY ( 4,421.71) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 MUSEUM FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:31PM PAGE: 14 REVENUE 07-0316-12-00 FUNDING FROM GENERAL FUND 29,475.49 77,139.79 142,185.00 65,045.21 54.3 07-0376-00-00 MUSEUM CONTRIBUTIONS/DONATIONS .00 848.92 150.00 ( 698.92)566.0 07-0379-00-00 MUSEUM MISC REVENUE .00 26.00 25.00 ( 1.00)104.0 07-0379-02-00 ARCADIA BOOKS SALES/ROYALTIES .00 198.28 400.00 201.72 49.6 07-0379-03-00 SALES TAX REVENUE .00 1.30 5.00 3.70 26.0 07-0380-00-00 GIFT SHOP REVENUE .00 17.00 100.00 83.00 17.0 07-0399-00-00 CARRY OVER .00 .00 14,000.00 14,000.00 .0 TOTAL FUND REVENUE 29,475.49 78,231.29 156,865.00 78,633.71 49.9 EXPENDITURES PERSONNEL 07-0420-10-00 SALARIES - FULL TIME 17,249.52 57,802.96 57,500.00 ( 302.96)100.5 07-0420-15-00 SALARIES - PART TIME .00 17,837.71 52,500.00 34,662.29 34.0 07-0420-15-01 SALARIES - PERSONNEL SERVICES 6,527.88 13,978.24 .00 ( 13,978.24).0 07-0420-21-00 FICA 1,319.57 5,786.36 7,500.00 1,713.64 77.2 07-0420-22-00 PERSI 2,059.62 6,901.72 6,800.00 ( 101.72)101.5 07-0420-24-00 WORKERS' COMPENSATION 32.77 143.73 .00 ( 143.73).0 07-0420-25-00 INSURANCE 204.15 2,314.02 7,600.00 5,285.98 30.5 07-0420-27-00 HRA BUY DOWN .00 .00 1,540.00 1,540.00 .0 TOTAL PERSONNEL 27,393.51 104,764.74 133,440.00 28,675.26 78.5 EDUCATION 07-0461-02-00 ASSOCIATION MEMBERSHIP .00 309.50 325.00 15.50 95.2 07-0461-03-00 CONFERENCES & SEMINARS 633.88 943.88 1,500.00 556.12 62.9 07-0461-04-00 TRAVEL & PER DIEM 2,684.09 2,684.09 3,500.00 815.91 76.7 TOTAL EDUCATION 3,317.97 3,937.47 5,325.00 1,387.53 73.9 ADMINISTRATION 07-0462-30-00 CONSERVATION/PRESERVATION .00 .00 1,000.00 1,000.00 .0 07-0462-31-00 OFFICE SUPPLIES 149.92 772.33 .00 ( 772.33).0 07-0462-32-00 ARCHIVAL SUPPLIES 128.67 807.64 1,000.00 192.36 80.8 07-0462-33-00 PUBLICITY-PRINTING .00 21.67 1,000.00 978.33 2.2 07-0462-34-00 RESEARCH MATERIAL 278.89 487.79 100.00 ( 387.79)487.8 07-0462-35-00 UNIFORMS .00 .00 400.00 400.00 .0 07-0462-68-00 MUSEUM PROGRAMS 444.36 1,329.00 2,000.00 671.00 66.5 07-0462-69-00 MISCELLANEOUS 150.00 769.86 200.00 ( 569.86)384.9 07-0462-73-00 EAGLE BOOK-ARCADIA PUBLISHING 296.87 296.87 300.00 3.13 99.0 TOTAL ADMINISTRATION 1,448.71 4,485.16 6,000.00 1,514.84 74.8 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 MUSEUM FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:31PM PAGE: 15 EXHIBITS 07-0463-01-00 DISPLAY SUPPLIES .00 206.83 300.00 93.17 68.9 07-0463-02-00 EXHIBIT ITEMS .00 .00 500.00 500.00 .0 07-0463-03-00 EXHIBIT CONSTRUCTION .00 2,398.90 1,000.00 ( 1,398.90)239.9 07-0463-04-00 ANNUAL EXHIBIT .00 10,605.38 10,000.00 ( 605.38)106.1 TOTAL EXHIBITS .00 13,211.11 11,800.00 ( 1,411.11)112.0 PROGRAMS 07-0464-08-00 GIFT SHOP SUPPLIES .00 .00 300.00 300.00 .0 TOTAL PROGRAMS .00 .00 300.00 300.00 .0 TOTAL FUND EXPENDITURES 32,160.19 126,398.48 156,865.00 30,466.52 80.6 NET REVENUE OVER EXPENDITURES ( 2,684.70)( 48,167.19).00 48,167.19 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 PARK IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:31PM PAGE: 16 ASSETS 08-0101-00-00 CASH 100,691.86 08-0151-25-00 FIRST INTERSTATE INVESTMENT 1,867,828.33 TOTAL ASSETS 1,968,520.19 LIABILITIES AND EQUITY LIABILITIES 08-0202-00-00 VOUCHERS PAYABLE 15,774.50 TOTAL LIABILITIES 15,774.50 FUND EQUITY 08-0271-00-00 PARK FUND/FUND BALANCE 3,700,742.90 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 1,747,997.21) BALANCE - CURRENT DATE ( 1,747,997.21) TOTAL FUND EQUITY 1,952,745.69 TOTAL LIABILITIES AND EQUITY 1,968,520.19 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 PARK IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:31PM PAGE: 17 REVENUE 08-0322-19-00 PARKS DEVELOPMENT IMPACT FEES 37,934.48 303,475.84 669,432.00 365,956.16 45.3 08-0364-01-00 CONTRIBUTIONS AND DONATIONS .00 .00 288,286.00 288,286.00 .0 08-0371-25-00 BANK INTEREST 2,089.13 7,085.43 4,200.00 ( 2,885.43)168.7 08-0399-00-00 CARRY OVER .00 .00 4,732,830.00 4,732,830.00 .0 TOTAL FUND REVENUE 40,023.61 310,561.27 5,694,748.00 5,384,186.73 5.5 EXPENDITURES CAPITAL IMPROVEMENTS 08-0438-37-00 CAPITAL IMPROVEMENTS 1,992,617.71 2,058,558.48 5,694,748.00 3,636,189.52 36.2 TOTAL CAPITAL IMPROVEMENTS 1,992,617.71 2,058,558.48 5,694,748.00 3,636,189.52 36.2 TOTAL FUND EXPENDITURES 1,992,617.71 2,058,558.48 5,694,748.00 3,636,189.52 36.2 NET REVENUE OVER EXPENDITURES ( 1,952,594.10)( 1,747,997.21).00 1,747,997.21 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 RECREATION - SPECIAL EVENTS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:31PM PAGE: 18 ASSETS 09-0101-00-00 CASH 66,842.79 TOTAL ASSETS 66,842.79 LIABILITIES AND EQUITY LIABILITIES 09-0202-00-00 VOUCHERS PAYABLE 3,990.34 09-0217-03-00 FICA 243.03 09-0217-04-00 PUBLIC RETIREMENT 337.51 09-0217-07-00 HEALTH INSURANCE 13,362.48 09-0217-09-00 WORKERS' COMPENSATION 14,404.40 09-0217-10-00 HSA CONTRIBUTION 3,319.35 TOTAL LIABILITIES 35,657.11 FUND EQUITY 09-0271-00-00 FUND BALANCE 126,879.30 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 95,693.62) BALANCE - CURRENT DATE ( 95,693.62) TOTAL FUND EQUITY 31,185.68 TOTAL LIABILITIES AND EQUITY 66,842.79 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 RECREATION - SPECIAL EVENTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:31PM PAGE: 19 REVENUE 09-0301-00-00 FUNDING FROM GENERAL FUND .00 .00 221,095.00 221,095.00 .0 09-0347-06-00 CHRISTMAS MARKET .00 3,583.44 2,750.00 ( 833.44)130.3 09-0347-08-00 SATURDAY MARKET 10,978.95 31,865.77 22,500.00 ( 9,365.77)141.6 09-0347-10-00 GAZEBO CONCERT SERIES 130.00 3,160.00 825.00 ( 2,335.00)383.0 09-0347-11-00 HARVEST FEST MARKET 6,448.12 6,935.53 2,750.00 ( 4,185.53)252.2 09-0376-13-00 SPONSORSHIPS .00 .00 15,000.00 15,000.00 .0 09-0376-15-00 EVENT APPLICATION FEES 700.00 2,700.00 1,500.00 ( 1,200.00)180.0 09-0376-17-00 SECURITY DEPOSIT .00 .00 1,200.00 1,200.00 .0 TOTAL FUND REVENUE 18,257.07 48,244.74 267,620.00 219,375.26 18.0 EXPENDITURES PERSONNEL 09-0420-10-00 SALARIES - FULL TIME 16,166.38 70,407.29 118,800.00 48,392.71 59.3 09-0420-11-00 OVERTIME 1,641.18 2,278.92 2,000.00 ( 278.92)114.0 09-0420-15-00 SALARIES - PART TIME .00 863.29 26,700.00 25,836.71 3.2 09-0420-21-00 FICA 1,346.04 5,549.96 11,400.00 5,850.04 48.7 09-0420-22-00 PERSI 2,072.54 8,383.49 14,300.00 5,916.51 58.6 09-0420-24-00 WORKERS' COMPENSATION 497.13 2,211.87 .00 ( 2,211.87).0 09-0420-25-00 INSURANCE 1,948.87 7,086.18 15,920.00 8,833.82 44.5 09-0420-26-00 HSA CONTRIBUTION 250.00 1,100.00 .00 ( 1,100.00).0 09-0420-29-00 PTO CASH OUT .00 .00 2,500.00 2,500.00 .0 TOTAL PERSONNEL 23,922.14 97,881.00 191,620.00 93,739.00 51.1 ADMINISTRATION 09-0463-11-00 OFFICE SUPPLIES 359.96 463.20 800.00 336.80 57.9 09-0463-12-00 PROMOTIONS .00 4,967.65 14,000.00 9,032.35 35.5 09-0463-19-00 TRAINING .00 328.55 1,200.00 871.45 27.4 09-0463-20-00 TRAVEL/PER DIEM .00 1,103.02 4,000.00 2,896.98 27.6 09-0463-21-00 PROFESSIONAL DUES .00 1,766.90 2,150.00 383.10 82.2 09-0463-22-00 UNIFORMS .00 190.50 600.00 409.50 31.8 09-0463-23-00 GAS/MILEAGE .00 .00 100.00 100.00 .0 09-0463-25-00 SECURITY DEPOSIT REFUND .00 .00 1,200.00 1,200.00 .0 09-0463-26-00 MEMBERSHIPS .00 .00 700.00 700.00 .0 TOTAL ADMINISTRATION 359.96 8,819.82 24,750.00 15,930.18 35.6 ACTIVITIES 09-0467-02-00 EAGLE SATURDAY MARKET 3,470.00 8,342.97 11,000.00 2,657.03 75.9 09-0467-03-00 CHRISTMAS MARKET .00 9,715.02 6,500.00 ( 3,215.02)149.5 09-0467-04-00 GAZEBO CONCERT SERIES 6,674.35 9,024.35 8,750.00 ( 274.35)103.1 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 RECREATION - SPECIAL EVENTS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:31PM PAGE: 20 09-0467-05-00 GENERAL EVENTS 6,136.43 6,886.43 10,000.00 3,113.57 68.9 09-0467-06-00 EAGLE HARVEST FEST 60.00 2,214.98 4,000.00 1,785.02 55.4 09-0467-07-00 EVENT EQUIPMENT PURCHASES 303.79 303.79 3,000.00 2,696.21 10.1 09-0467-08-00 EVENT EQUIPMENT RENTAL .00 750.00 8,000.00 7,250.00 9.4 TOTAL ACTIVITIES 16,644.57 37,237.54 51,250.00 14,012.46 72.7 TOTAL FUND EXPENDITURES 40,926.67 143,938.36 267,620.00 123,681.64 53.8 NET REVENUE OVER EXPENDITURES ( 22,669.60)( 95,693.62).00 95,693.62 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 EAGLE HISTORICAL COMMISSION FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:31PM PAGE: 21 ASSETS 10-0101-00-00 CASH 21,002.34 TOTAL ASSETS 21,002.34 LIABILITIES AND EQUITY FUND EQUITY 10-0271-00-00 FUND BALANCE 19,283.33 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 1,719.01 BALANCE - CURRENT DATE 1,719.01 TOTAL FUND EQUITY 21,002.34 TOTAL LIABILITIES AND EQUITY 21,002.34 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 EAGLE HISTORICAL COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:31PM PAGE: 22 REVENUE 10-0316-12-00 FUNDING FROM GENERAL FUND .00 .00 3,118.00 3,118.00 .0 10-0333-01-00 GRANTS, STATE .00 1,733.52 .00 ( 1,733.52).0 10-0399-00-00 CARRY OVER .00 .00 5,882.00 5,882.00 .0 TOTAL FUND REVENUE .00 1,733.52 9,000.00 7,266.48 19.3 EXPENDITURES ADMINISTRATION 10-0462-02-00 PUBLICITY - PRINTING .00 .00 1,000.00 1,000.00 .0 10-0462-05-00 EDUCATION/TRAINING .00 .00 500.00 500.00 .0 TOTAL ADMINISTRATION .00 .00 1,500.00 1,500.00 .0 PROGRAMS 10-0464-07-00 PRESERVATION .00 .00 1,000.00 1,000.00 .0 10-0464-08-00 COMM ENGAGEMENT/SPECIAL EVENTS 14.51 14.51 500.00 485.49 2.9 TOTAL PROGRAMS 14.51 14.51 1,500.00 1,485.49 1.0 GRANTS 10-0465-02-00 MUNICIPAL GRANT FUNDS .00 .00 6,000.00 6,000.00 .0 TOTAL GRANTS .00 .00 6,000.00 6,000.00 .0 TOTAL FUND EXPENDITURES 14.51 14.51 9,000.00 8,985.49 .2 NET REVENUE OVER EXPENDITURES ( 14.51)1,719.01 .00 ( 1,719.01).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 EXECUTIVE DEPARTMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:31PM PAGE: 23 LIABILITIES AND EQUITY LIABILITIES 11-0202-00-00 VOUCHERS PAYABLE 169.08 11-0216-00-00 ACCRUED PAYROLL 1,750.00 11-0217-03-00 FICA 452.83 11-0217-04-00 EXEC DEPT/PUBLIC RETIREMENT 675.73 11-0217-07-00 EXEC DEPT HEALTH INSURANCE 3,238.38 11-0217-09-00 WORKERS' COMPENSATION 6,530.81 11-0217-10-00 HSA CONTRIBUTION ( 224.00) TOTAL LIABILITIES 12,592.83 FUND EQUITY 11-0271-00-00 FUND BALANCE ( 6,073.74) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 6,519.09) BALANCE - CURRENT DATE ( 6,519.09) TOTAL FUND EQUITY ( 12,592.83) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 EXECUTIVE DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:32PM PAGE: 24 REVENUE 11-0301-00-00 FUNDING FROM GENERAL FUND 78,108.89 293,377.68 400,030.00 106,652.32 73.3 TOTAL FUND REVENUE 78,108.89 293,377.68 400,030.00 106,652.32 73.3 EXPENDITURES ADMINISTRATION 11-0413-04-00 UNIFORMS .00 250.10 300.00 49.90 83.4 11-0413-05-00 OFFICE EXPENSES 207.50 490.58 500.00 9.42 98.1 11-0413-12-00 PERSONNEL TRAINING 1,069.00 1,454.00 3,500.00 2,046.00 41.5 11-0413-13-00 TRAVEL & PER DIEM 2,644.04 2,786.04 6,000.00 3,213.96 46.4 11-0413-14-00 PROFESSIONAL DUES .00 1,476.00 1,900.00 424.00 77.7 11-0413-19-00 TELEPHONE & COMMUNICATIONS 37.00 37.00 .00 ( 37.00).0 TOTAL ADMINISTRATION 3,957.54 6,493.72 12,200.00 5,706.28 53.2 PERSONNEL 11-0415-10-00 SALARIES - FULL TIME 61,142.29 218,545.47 221,700.00 3,154.53 98.6 11-0415-11-00 OVERTIME .00 17.92 500.00 482.08 3.6 11-0415-21-00 FICA 4,543.21 16,513.79 17,100.00 586.21 96.6 11-0415-22-00 PERSI 7,043.92 26,352.38 26,700.00 347.62 98.7 11-0415-24-00 WORKERS' COMPENSATION 1,316.16 4,719.70 .00 ( 4,719.70).0 11-0415-25-00 INSURANCE 4,334.16 18,423.80 19,300.00 876.20 95.5 11-0415-26-00 HSA CONTRIBUTION 60.00 600.00 1,200.00 600.00 50.0 11-0415-27-00 PTO CASH OUT .00 4,304.46 10,000.00 5,695.54 43.0 11-0415-28-00 HRA BUY-DOWN .00 .00 3,080.00 3,080.00 .0 TOTAL PERSONNEL 78,439.74 289,477.52 299,580.00 10,102.48 96.6 STATE OF THE CITY 11-0417-01-00 STATE OF THE CITY .00 .00 2,250.00 2,250.00 .0 TOTAL STATE OF THE CITY .00 .00 2,250.00 2,250.00 .0 DEPARTMENT 0418 11-0418-00-00 COMP PLAN REWRITE .00 77.40 83,000.00 82,922.60 .1 TOTAL DEPARTMENT 0418 .00 77.40 83,000.00 82,922.60 .1 COMMUNITY & STAFF RELATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 EXECUTIVE DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:32PM PAGE: 25 11-0422-01-00 COMMUNITY/STAFF RELATIONS 3,513.73 3,848.13 3,000.00 ( 848.13)128.3 11-0422-02-00 STAFF RELATIONS ( 375.00).00 .00 .00 .0 TOTAL COMMUNITY & STAFF RELATIONS 3,138.73 3,848.13 3,000.00 ( 848.13)128.3 TOTAL FUND EXPENDITURES 85,536.01 299,896.77 400,030.00 100,133.23 75.0 NET REVENUE OVER EXPENDITURES ( 7,427.12)( 6,519.09).00 6,519.09 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 CITY CLERK/TREAS DEPARTMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:32PM PAGE: 26 LIABILITIES AND EQUITY LIABILITIES 12-0202-00-00 VOUCHERS PAYABLE 1,414.58 12-0216-00-00 ACCRUED PAYROLL 7,001.54 12-0217-02-00 FEDERAL WITHHOLDING TAX .02 12-0217-03-00 FICA 1,420.86 12-0217-04-00 CLERKS DEPT/PUBLIC RETIREMENT 2,212.17 12-0217-07-00 CLERK DEPT HEALTH INSURANCE 7,877.76 12-0217-09-00 WORKERS' COMPENSATION 7,305.80 TOTAL LIABILITIES 27,232.73 FUND EQUITY 12-0271-00-00 FUND BALANCE ( 25,013.59) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 2,219.14) BALANCE - CURRENT DATE ( 2,219.14) TOTAL FUND EQUITY ( 27,232.73) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 CITY CLERK/TREAS DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:32PM PAGE: 27 REVENUE 12-0301-00-00 FUNDING FROM GENERAL FUND 148,249.28 571,133.60 626,550.00 55,416.40 91.2 TOTAL FUND REVENUE 148,249.28 571,133.60 626,550.00 55,416.40 91.2 EXPENDITURES ADMINISTRATION 12-0413-05-00 OFFICE EXPENSES 120.25 647.80 1,000.00 352.20 64.8 12-0413-06-00 DUPLICATION/PUBLISHING/PRINTIG 30.00 60.00 200.00 140.00 30.0 12-0413-12-00 PERSONNEL TRAINING & RESOURCES 2,694.46 4,619.64 10,000.00 5,380.36 46.2 12-0413-13-00 TRAVEL & PER DIEM 1,499.27 1,535.55 5,000.00 3,464.45 30.7 12-0413-14-00 PROFESSIONAL DUES 215.00 775.00 1,400.00 625.00 55.4 12-0413-29-00 UNIFORMS .00 389.80 750.00 360.20 52.0 12-0413-30-00 MISCELLANEOUS 50.14 196.94 500.00 303.06 39.4 TOTAL ADMINISTRATION 4,609.12 8,224.73 18,850.00 10,625.27 43.6 PERSONNEL 12-0415-10-00 SALARIES - FULL TIME 117,524.65 403,833.99 408,000.00 4,166.01 99.0 12-0415-11-00 OVERTIME .00 2,073.37 3,000.00 926.63 69.1 12-0415-15-00 SALARIES - PART TIME .00 9,378.07 16,500.00 7,121.93 56.8 12-0415-21-00 FICA 8,893.44 30,997.41 32,800.00 1,802.59 94.5 12-0415-22-00 PERSI 14,326.82 49,101.99 51,200.00 2,098.01 95.9 12-0415-23-00 HRA BUY- DOWN .00 1,039.60 8,000.00 6,960.40 13.0 12-0415-23-02 HSA CONTRIBUTION 300.00 500.00 1,200.00 700.00 41.7 12-0415-24-00 WORKERS' COMPENSATION 227.97 798.97 .00 ( 798.97).0 12-0415-25-00 INSURANCE 15,709.66 61,329.87 82,000.00 20,670.13 74.8 12-0415-26-00 PTO CASH OUT 2,440.34 6,074.74 5,000.00 ( 1,074.74)121.5 TOTAL PERSONNEL 159,422.88 565,128.01 607,700.00 42,571.99 93.0 TOTAL FUND EXPENDITURES 164,032.00 573,352.74 626,550.00 53,197.26 91.5 NET REVENUE OVER EXPENDITURES ( 15,782.72)( 2,219.14).00 2,219.14 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 BUILDING DEPARTMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:32PM PAGE: 28 ASSETS 13-0103-00-00 PETTY CASH 100.00 TOTAL ASSETS 100.00 LIABILITIES AND EQUITY LIABILITIES 13-0202-00-00 VOUCHERS PAYABLE 31,831.17 13-0216-00-00 ACCRUED PAYROLL 5,067.00 13-0217-03-00 FICA 1,396.51 13-0217-04-00 BLDG DEPT/PUBLIC RETIREMENT 2,022.42 13-0217-07-00 BLDG DEPT HEALTH INSURANCE 10,141.65 13-0217-09-00 WORKERS' COMPENSATION 47,785.11 13-0217-10-00 HSA CONTRIBUTION ( 1,900.00) TOTAL LIABILITIES 96,343.86 FUND EQUITY 13-0271-00-00 FUND BALANCE ( 91,593.51) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 4,650.35) BALANCE - CURRENT DATE ( 4,650.35) TOTAL FUND EQUITY ( 96,243.86) TOTAL LIABILITIES AND EQUITY 100.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 BUILDING DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:32PM PAGE: 29 REVENUE 13-0301-00-00 FUNDING FROM GENERAL FUND 230,116.47 972,986.76 1,156,430.00 183,443.24 84.1 TOTAL FUND REVENUE 230,116.47 972,986.76 1,156,430.00 183,443.24 84.1 EXPENDITURES ADMINISTRATION 13-0413-05-00 OFFICE EXPENSES 1,399.62 5,062.87 6,500.00 1,437.13 77.9 13-0413-08-00 LEGAL ADS & PUBLICATIONS .00 42.00 400.00 358.00 10.5 13-0413-09-00 COMMERCIAL PLAN REVIEW 3,725.00 3,725.00 6,000.00 2,275.00 62.1 13-0413-12-00 TRAINING & CERTIFICATION RENEW 2,150.22 4,273.22 4,400.00 126.78 97.1 13-0413-13-00 TRAVEL & PER DIEM .00 .00 3,000.00 3,000.00 .0 13-0413-14-00 PROFESSIONAL DUES .00 865.00 540.00 ( 325.00)160.2 13-0413-25-00 MISCELLANEOUS .00 .00 300.00 300.00 .0 13-0413-28-00 RESOURCE MATERIALS 90.00 1,911.25 1,500.00 ( 411.25)127.4 13-0413-29-00 BUILDING PERMIT REFUNDS .00 250.00 .00 ( 250.00).0 13-0413-29-03 MECHANICAL FEE REFUND ( 390.00)3,985.00 500.00 ( 3,485.00)797.0 13-0413-29-04 PLUMBING PERMIT REFUND .00 1,480.00 500.00 ( 980.00)296.0 13-0413-29-05 ELECTRICAL PERMIT REFUND .00 1,875.20 500.00 ( 1,375.20)375.0 13-0413-30-00 UNIFORMS .00 1,952.93 1,750.00 ( 202.93)111.6 TOTAL ADMINISTRATION 6,974.84 25,422.47 25,890.00 467.53 98.2 PERSONNEL 13-0415-10-00 SALARIES - FULL TIME 92,945.81 322,934.17 407,000.00 84,065.83 79.4 13-0415-10-01 SALARIES - PERSONNEL SERVICES 763.20 13,432.32 .00 ( 13,432.32).0 13-0415-11-00 OVERTIME 671.56 1,460.06 8,000.00 6,539.94 18.3 13-0415-21-00 FICA 6,935.25 23,769.28 31,800.00 8,030.72 74.8 13-0415-22-00 PERSI 10,993.72 38,548.31 49,700.00 11,151.69 77.6 13-0415-23-00 HRA BUY-DOWN .00 125.66 9,240.00 9,114.34 1.4 13-0415-24-00 WORKERS' COMPENSATION 3,022.98 10,754.08 .00 ( 10,754.08).0 13-0415-25-00 INSURANCE 15,462.27 62,997.57 87,000.00 24,002.43 72.4 13-0415-26-00 HSA CONTRIBUTION 600.00 2,400.00 1,200.00 ( 1,200.00)200.0 13-0415-28-00 PTO CASH OUT .00 .00 5,000.00 5,000.00 .0 TOTAL PERSONNEL 131,394.79 476,421.45 598,940.00 122,518.55 79.5 CONTRACTS & AGREEMENTS 13-0416-09-00 PLUMBING INSPECTOR 30,930.15 112,316.60 150,000.00 37,683.40 74.9 13-0416-11-00 MECHANICAL INSPECTOR 43,680.02 156,745.56 150,000.00 ( 6,745.56)104.5 13-0416-13-00 BLDG INSPECTOR 14,686.00 50,096.00 62,000.00 11,904.00 80.8 13-0416-14-00 PLAN REVIEW - CONTRACT .00 .00 15,000.00 15,000.00 .0 13-0416-25-00 ELECTRICAL INSPECTOR 49,520.11 156,500.17 150,000.00 ( 6,500.17)104.3 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 BUILDING DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:32PM PAGE: 30 TOTAL CONTRACTS & AGREEMENTS 138,816.28 475,658.33 527,000.00 51,341.67 90.3 VEHICLE OPERATIONS 13-0417-02-00 GAS AND OIL 53.55 134.86 600.00 465.14 22.5 13-0417-03-00 VEHICLE REPLACEMENT .00 .00 4,000.00 4,000.00 .0 TOTAL VEHICLE OPERATIONS 53.55 134.86 4,600.00 4,465.14 2.9 TOTAL FUND EXPENDITURES 277,239.46 977,637.11 1,156,430.00 178,792.89 84.5 NET REVENUE OVER EXPENDITURES ( 47,122.99)( 4,650.35).00 4,650.35 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 P&Z DEPARTMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:32PM PAGE: 31 LIABILITIES AND EQUITY LIABILITIES 14-0202-00-00 VOUCHERS PAYABLE 1,804.30 14-0216-00-00 ACCRUED PAYROLL 9,808.33 14-0217-03-00 FICA 3,391.86 14-0217-04-00 P&Z DEPT/PUBLIC RETIREMENT 5,215.16 14-0217-07-00 P&Z DEPT HEALTH INSURANCE ( 31,040.84) 14-0217-08-00 P&Z DEPT/GARNISHMENTS 203.34 14-0217-09-00 WORKERS' COMPENSATION 74,316.28 TOTAL LIABILITIES 63,698.43 FUND EQUITY 14-0271-00-00 FUND BALANCE ( 59,544.03) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 4,154.40) BALANCE - CURRENT DATE ( 4,154.40) TOTAL FUND EQUITY ( 63,698.43) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 P&Z DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:32PM PAGE: 32 REVENUE 14-0301-00-00 FUNDING FROM GENERAL FUND 251,830.49 955,674.06 1,214,100.00 258,425.94 78.7 TOTAL FUND REVENUE 251,830.49 955,674.06 1,214,100.00 258,425.94 78.7 EXPENDITURES ADMINISTRATION 14-0413-05-00 OFFICE EXPENSES 334.73 1,698.20 1,800.00 101.80 94.3 14-0413-06-00 DUPLICATION/PUBLISHING/PRNTG .00 183.32 1,000.00 816.68 18.3 14-0413-08-00 LEGAL ADS & PUBLICATIONS 1,373.59 4,844.56 8,000.00 3,155.44 60.6 14-0413-12-00 PERSONNEL TRAINING 175.00 1,538.00 5,100.00 3,562.00 30.2 14-0413-13-00 TRAVEL & PER DIEM 42.79 4,524.24 15,000.00 10,475.76 30.2 14-0413-14-00 PROFESSIONAL DUES 919.00 2,044.00 2,500.00 456.00 81.8 14-0413-25-00 MISCELLANEOUS 70.97 955.19 1,000.00 44.81 95.5 14-0413-26-00 REIMBURSE-ANNEX/ZONING/DR FEES .00 1,866.54 3,000.00 1,133.46 62.2 14-0413-28-00 RESOURCE MATERIALS .00 .00 200.00 200.00 .0 14-0413-30-01 ENVIRONMENTAL REVIEW SERVICES 4,485.00 4,485.00 5,000.00 515.00 89.7 14-0413-37-00 ARBORICULTURE .00 .00 500.00 500.00 .0 TOTAL ADMINISTRATION 7,401.08 22,139.05 43,100.00 20,960.95 51.4 PERSONNEL 14-0415-10-00 SALARIES - FULL TIME 199,951.15 681,546.87 788,000.00 106,453.13 86.5 14-0415-11-00 OVERTIME 1,768.65 6,110.92 11,300.00 5,189.08 54.1 14-0415-21-00 FICA 15,208.31 52,094.40 61,500.00 9,405.60 84.7 14-0415-22-00 PERSI 24,085.33 82,927.85 95,600.00 12,672.15 86.7 14-0415-24-00 WORKERS' COMPENSATION 2,547.66 10,154.47 .00 ( 10,154.47).0 14-0415-25-00 INSURANCE 22,525.86 80,814.57 137,000.00 56,185.43 59.0 14-0415-26-00 HSA CONTRIBUTION 300.00 1,300.00 4,800.00 3,500.00 27.1 14-0415-29-00 PTO CASH OUT .00 6,882.01 15,000.00 8,117.99 45.9 14-0415-30-00 HRA BUY- DOWN .00 2,963.33 17,000.00 14,036.67 17.4 TOTAL PERSONNEL 266,386.96 924,794.42 1,130,200.00 205,405.58 81.8 CONTRACTS & AGREEMENTS 14-0416-02-00 TRAILS CONSULTANTS-STUDIES .00 .00 20,000.00 20,000.00 .0 14-0416-03-00 PROFESSIONAL SERVICE CONTRACTS 3,135.00 12,635.00 10,000.00 ( 2,635.00)126.4 TOTAL CONTRACTS & AGREEMENTS 3,135.00 12,635.00 30,000.00 17,365.00 42.1 PUBLIC RELATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 P&Z DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:32PM PAGE: 33 14-0422-01-00 PUBLIC RELATIONS .00 .00 200.00 200.00 .0 TOTAL PUBLIC RELATIONS .00 .00 200.00 200.00 .0 CAPITAL OUTLAY 14-0465-03-00 OFFICE EQUIPMENT .00 259.99 600.00 340.01 43.3 TOTAL CAPITAL OUTLAY .00 259.99 600.00 340.01 43.3 COMMUNITY PLANNING PROJECTS 14-0468-11-00 OTHER .00 .00 10,000.00 10,000.00 .0 TOTAL COMMUNITY PLANNING PROJECTS .00 .00 10,000.00 10,000.00 .0 TOTAL FUND EXPENDITURES 276,923.04 959,828.46 1,214,100.00 254,271.54 79.1 NET REVENUE OVER EXPENDITURES ( 25,092.55)( 4,154.40).00 4,154.40 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 RECREATION - PARKS AND REC FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:32PM PAGE: 34 LIABILITIES AND EQUITY LIABILITIES 17-0202-00-00 VOUCHERS PAYABLE 5,722.38 17-0217-02-00 FEDERAL WITHOLDING TAX 29.48 17-0217-03-00 FICA 1,637.19 17-0217-04-00 PUBLIC RETIREMENT 1,079.92 17-0217-07-00 HEALTH INSURANCE ( 10,064.95) 17-0217-09-00 WORKERS' COMPENSATION 40,782.79 17-0217-10-00 HSA CONTRIBUTION ( 4,225.93) TOTAL LIABILITIES 34,960.88 FUND EQUITY 17-0271-00-00 FUND BALANCE 133,692.11 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 168,652.99) BALANCE - CURRENT DATE ( 168,652.99) TOTAL FUND EQUITY ( 34,960.88) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 RECREATION - PARKS AND REC PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:32PM PAGE: 35 REVENUE 17-0301-00-00 FUNDING FROM GENERAL FUND 82,259.26 82,259.26 443,770.00 361,510.74 18.5 17-0302-00-00 REGISTRATION 51,278.97 207,646.59 188,000.00 ( 19,646.59)110.5 17-0302-01-00 SPONSORSHIPS .00 500.00 10,000.00 9,500.00 5.0 17-0302-03-00 PARK RESERVATION FEES 20,851.98 46,824.72 20,000.00 ( 26,824.72)234.1 17-0303-00-00 SCHOLARSHIP FUNDS .00 .00 1,000.00 1,000.00 .0 TOTAL FUND REVENUE 154,390.21 337,230.57 662,770.00 325,539.43 50.9 EXPENDITURES CONTRACTS 17-0416-00-00 CONTRACT-PERMITS-CAMPS/CLASSES .00 525.00 35,000.00 34,475.00 1.5 17-0416-01-00 CONTRACT-PERMITS TEAM SPORTS 1,024.54 9,716.04 15,000.00 5,283.96 64.8 TOTAL CONTRACTS 1,024.54 10,241.04 50,000.00 39,758.96 20.5 PERSONNEL 17-0420-10-00 SALARIES - FULL TIME 80,770.85 259,024.09 266,500.00 7,475.91 97.2 17-0420-10-01 SALARIES - PERSONNEL SERVICES 34,208.25 46,622.63 .00 ( 46,622.63).0 17-0420-11-00 SALARIES - SEASONAL 3,740.85 4,995.48 58,500.00 53,504.52 8.5 17-0420-15-00 SALARIES - PART TIME .00 4,716.93 30,500.00 25,783.07 15.5 17-0420-18-00 OVERTIME .00 1,144.40 4,000.00 2,855.60 28.6 17-0420-21-00 FICA 6,406.38 20,353.12 27,550.00 7,196.88 73.9 17-0420-22-00 PERSI 10,095.25 29,810.06 31,800.00 1,989.94 93.7 17-0420-23-00 HRA BUY-DOWN .00 .00 4,620.00 4,620.00 .0 17-0420-24-00 WORKERS' COMPENSATION 3,142.30 10,040.16 .00 ( 10,040.16).0 17-0420-25-00 INSURANCE 8,679.99 26,524.34 27,500.00 975.66 96.5 17-0420-26-00 HSA CONTRIBUTION 450.00 1,400.00 4,800.00 3,400.00 29.2 17-0420-27-00 PTO CASH OUT .00 .00 5,400.00 5,400.00 .0 TOTAL PERSONNEL 147,493.87 404,631.21 461,170.00 56,538.79 87.7 RESTRICTED 17-0421-00-00 SCHOLARSHIP FUNDS .00 .00 1,000.00 1,000.00 .0 TOTAL RESTRICTED .00 .00 1,000.00 1,000.00 .0 ADMINISTRATION 17-0422-00-00 TRAINING-PROFESSIONAL DEVELOP .00 62.02 2,000.00 1,937.98 3.1 17-0422-01-00 OFFICE SUPPLIES 33.09 1,132.91 1,000.00 ( 132.91)113.3 17-0422-02-00 ADVERTISING/MKTING CAMP/CLASS .00 35.00 5,500.00 5,465.00 .6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 RECREATION - PARKS AND REC YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:32PM PAGE: 36 17-0422-02-01 ADVERTISING/MKTNG TEAM SPORTS 100.00 150.00 5,500.00 5,350.00 2.7 17-0422-04-00 GAS/MILEAGE .00 38.03 100.00 61.97 38.0 17-0422-05-00 COMMUNICATION 111.00 185.00 .00 ( 185.00).0 17-0422-06-00 PRINTING AND PUBLISHING 239.40 239.40 10,000.00 9,760.60 2.4 17-0422-07-00 PROFESSIONAL DUES 50.00 50.00 2,000.00 1,950.00 2.5 17-0422-08-00 TRAINING .00 .00 3,000.00 3,000.00 .0 17-0422-09-00 TRAVEL/PER DIEM .00 194.50 8,000.00 7,805.50 2.4 17-0422-10-00 BACKGROUND CHECKS 682.85 2,421.40 2,000.00 ( 421.40)121.1 17-0422-11-00 REFUNDS-PARK REC PROGRAMS 795.00 2,935.00 2,000.00 ( 935.00)146.8 TOTAL ADMINISTRATION 2,011.34 7,443.26 41,100.00 33,656.74 18.1 RECREATION 17-0423-00-00 REC SUPPLIES-CAMPS & CLASSES 7,515.93 9,812.74 6,000.00 ( 3,812.74)163.6 17-0423-00-01 REC SUPPLIES-TEAM SPORTS 4,418.35 12,584.14 15,000.00 2,415.86 83.9 17-0423-01-00 UNIFORMS 2,051.65 18,493.08 15,000.00 ( 3,493.08)123.3 17-0423-02-00 FIELD TRIPS 7,612.42 8,477.85 15,000.00 6,522.15 56.5 17-0423-03-00 FACILITY RENTAL 1,575.00 13,387.50 10,000.00 ( 3,387.50)133.9 17-0423-04-00 TRANSPORTATION SERVICES 9,948.81 13,746.62 10,000.00 ( 3,746.62)137.5 17-0423-05-00 DADDY DAUGHTER DANCE .00 1,450.66 2,200.00 749.34 65.9 17-0423-05-01 EAGLE FUN DAYS ( 3,417.26).00 .00 .00 .0 17-0423-07-00 GLOW IN THE PARK 5.40 5.40 15,500.00 15,494.60 .0 17-0423-08-00 HALLOWEEN TRICK-OR-TREAT .00 .00 800.00 800.00 .0 17-0423-09-00 VETERAN'S BREAKFAST 35.00 400.69 1,000.00 599.31 40.1 17-0423-10-00 NEW PROGRAMS .00 .00 2,000.00 2,000.00 .0 TOTAL RECREATION 29,745.30 78,358.68 92,500.00 14,141.32 84.7 VEHICLES 17-0424-03-00 GAS 250.31 390.70 1,000.00 609.30 39.1 TOTAL VEHICLES 250.31 390.70 1,000.00 609.30 39.1 CAPITAL EQUIPMENT 17-0425-00-00 REC EQUIPMENT-TEAM SPORTS .00 4,818.67 15,000.00 10,181.33 32.1 17-0425-01-00 REC EQUIPMENT-CAMPS/CLASSES .00 .00 1,000.00 1,000.00 .0 TOTAL CAPITAL EQUIPMENT .00 4,818.67 16,000.00 11,181.33 30.1 TOTAL FUND EXPENDITURES 180,525.36 505,883.56 662,770.00 156,886.44 76.3 NET REVENUE OVER EXPENDITURES ( 26,135.15)( 168,652.99).00 168,652.99 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 IT DEPARTMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:32PM PAGE: 37 LIABILITIES AND EQUITY LIABILITIES 18-0202-00-00 VOUCHERS PAYABLE 17,624.76 18-0217-03-00 FICA 555.58 18-0217-04-00 PUBLIC RETIRMENT 936.81 18-0217-07-00 HEALTH INSURANCE ( 25,891.99) 18-0217-09-00 WORKERS' COMPENSATION 1,877.40 18-0217-10-00 HSA CONTRIBUTION 820.00 TOTAL LIABILITIES ( 4,077.44) FUND EQUITY 18-0271-00-00 FUND BALANCE ( 2,402.36) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 6,479.80 BALANCE - CURRENT DATE 6,479.80 TOTAL FUND EQUITY 4,077.44 TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 IT DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:32PM PAGE: 38 REVENUE 18-0301-00-00 FUNDING FROM GENERAL FUND 198,728.10 750,041.28 893,820.00 143,778.72 83.9 TOTAL FUND REVENUE 198,728.10 750,041.28 893,820.00 143,778.72 83.9 EXPENDITURES ADMINISTRATION 18-0413-01-00 OFFICE SUPPLIES .00 .00 1,000.00 1,000.00 .0 18-0413-02-00 SUPPLIES 7.99 492.98 4,000.00 3,507.02 12.3 18-0413-03-00 TRAINING 1,267.68 1,267.68 6,450.00 5,182.32 19.7 18-0413-04-00 TRAVEL AND PER DIEM 1,848.06 2,572.25 6,600.00 4,027.75 39.0 18-0413-05-00 PROFESSIONAL DUES .00 .00 750.00 750.00 .0 18-0413-06-00 UNIFORMS .00 .00 800.00 800.00 .0 TOTAL ADMINISTRATION 3,123.73 4,332.91 19,600.00 15,267.09 22.1 PERSONNEL 18-0415-10-00 SALARIES - FULL TIME 66,553.63 236,774.87 237,000.00 225.13 99.9 18-0415-11-00 IT DEPT/OVERTIME 50.19 1,091.15 3,000.00 1,908.85 36.4 18-0415-21-00 FICA 4,840.04 17,158.82 18,500.00 1,341.18 92.8 18-0415-22-00 PERSI 7,956.05 28,401.10 28,800.00 398.90 98.6 18-0415-23-00 HRA BUY- DOWN .00 .00 4,620.00 4,620.00 .0 18-0415-24-00 WORKERS' COMPENSATION 126.62 451.08 .00 ( 451.08).0 18-0415-25-00 INSURANCE 9,645.69 38,126.74 41,300.00 3,173.26 92.3 18-0415-26-00 HSA 180.00 720.00 1,200.00 480.00 60.0 18-0415-27-00 PTO CASH OUT .00 .00 2,000.00 2,000.00 .0 TOTAL PERSONNEL 89,352.22 322,723.76 336,420.00 13,696.24 95.9 CONTRACT & AGREEMENTS 18-0416-01-00 CONTRACT AND AGREEMENTS 77,933.04 249,390.65 330,000.00 80,609.35 75.6 TOTAL CONTRACT & AGREEMENTS 77,933.04 249,390.65 330,000.00 80,609.35 75.6 INTERNET/PHONE SERVICES 18-0417-01-00 INTERNET & PHONE SERVICES 24,240.58 66,245.09 74,000.00 7,754.91 89.5 TOTAL INTERNET/PHONE SERVICES 24,240.58 66,245.09 74,000.00 7,754.91 89.5 OPERATIONAL RESERVES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 IT DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 39 18-0418-01-00 IT EQUIPMENT/SOFTWARE 651.58 33,907.97 35,000.00 1,092.03 96.9 TOTAL OPERATIONAL RESERVES 651.58 33,907.97 35,000.00 1,092.03 96.9 CAPITAL OUTLAY 18-0419-01-00 FURNITURE .00 .00 1,300.00 1,300.00 .0 18-0419-02-00 EQUIPMENT 29,023.54 63,479.67 60,000.00 ( 3,479.67)105.8 18-0419-03-00 SOFTWARE PURCHASES .00 1,450.00 25,000.00 23,550.00 5.8 18-0419-04-00 WEBSITE DEVELOPMENT .00 .00 12,000.00 12,000.00 .0 18-0419-05-00 TOOLS .00 2,031.43 500.00 ( 1,531.43)406.3 TOTAL CAPITAL OUTLAY 29,023.54 66,961.10 98,800.00 31,838.90 67.8 TOTAL FUND EXPENDITURES 224,324.69 743,561.48 893,820.00 150,258.52 83.2 NET REVENUE OVER EXPENDITURES ( 25,596.59)6,479.80 .00 ( 6,479.80).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 CAPITAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 40 ASSETS 19-0101-00-00 CASH 231,020.80 19-0151-25-00 FIRST INTERSTATE INVESTMENT 6,617,003.46 TOTAL ASSETS 6,848,024.26 LIABILITIES AND EQUITY LIABILITIES 19-0202-00-00 VOUCHERS PAYABLE 227,775.78 19-0225-00-00 UNEARNED GRANT REVENUE, ARPA 3,204,501.48 TOTAL LIABILITIES 3,432,277.26 FUND EQUITY 19-0271-00-00 FUND BALANCE 10,001,468.10 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 6,585,721.10) BALANCE - CURRENT DATE ( 6,585,721.10) TOTAL FUND EQUITY 3,415,747.00 TOTAL LIABILITIES AND EQUITY 6,848,024.26 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 41 REVENUE 19-0301-00-00 FUNDING FROM GENERAL FUND .00 .00 1,708,900.00 1,708,900.00 .0 19-0301-01-00 BANK INTEREST 2,661.80 5,601.63 500.00 ( 5,101.63)1120.3 19-0301-02-00 DRY CREEK GRANT REIMBURSEMENT 3,775.51 3,775.51 .00 ( 3,775.51).0 19-0301-03-00 FOOTHILLS REIMB AGREEMENT .00 .00 100,000.00 100,000.00 .0 19-0301-05-00 EAGLE RD PED/BIKE BRIDGE .00 133,463.98 .00 ( 133,463.98).0 19-0301-12-00 FEMA GENERAL REVENUE 200,600.46 200,600.46 1,057,905.00 857,304.54 19.0 19-0301-13-00 EURA COST SHARE .00 33,429.13 424,000.00 390,570.87 7.9 19-0301-20-00 COMPASS CIM GRANT .00 .00 25,000.00 25,000.00 .0 19-0331-01-00 ARPA, AMERICAN RESCUE PLAN ACT .00 3,204,501.48 3,200,000.00 ( 4,501.48)100.1 19-0333-01-00 STATE BROADBAND GRANT .00 .00 250,000.00 250,000.00 .0 19-0371-25-01 BANK INTEREST, EXPANSION .00 874.91 .00 ( 874.91).0 19-0399-00-00 CARRY OVER .00 .00 10,982,829.00 10,982,829.00 .0 19-0399-01-00 CARRY OVER, ARPA FUNDS .00 .00 3,200,000.00 3,200,000.00 .0 TOTAL FUND REVENUE 207,037.77 3,582,247.10 20,949,134.00 17,366,886.90 17.1 EXPENDITURES RESERVES 19-0410-01-00 RESERVES, FUTURE PROJECTS 14,435.00 14,435.00 4,560,041.00 4,545,606.00 .3 TOTAL RESERVES 14,435.00 14,435.00 4,560,041.00 4,545,606.00 .3 CAPITAL MAINTENANCE 19-0462-01-00 CAPITAL MAINTENANCE SET ASIDE 120,464.72 270,796.08 2,015,889.00 1,745,092.92 13.4 19-0462-03-00 FEMA TRAIL REPLACEMENT 830,324.75 1,419,276.99 1,596,204.00 176,927.01 88.9 TOTAL CAPITAL MAINTENANCE 950,789.47 1,690,073.07 3,612,093.00 1,922,019.93 46.8 CITY CAPITAL PROJECTS 19-0465-05-00 GENERAL CITY PROJECTS 5,631.61 5,631.61 100,000.00 94,368.39 5.6 19-0465-06-00 EXPANSION OF CITY HALL 233,822.19 2,710,357.14 2,800,000.00 89,642.86 96.8 19-0465-07-00 LAND PURCHASES ( 1,974,343.21)948,557.88 .00 ( 948,557.88).0 19-0465-08-00 CURRENT FISCAL YEAR PROJECTS 1,257.50 1,257.50 .00 ( 1,257.50).0 TOTAL CITY CAPITAL PROJECTS ( 1,733,631.91)3,665,804.13 2,900,000.00 ( 765,804.13)126.4 PZ CAPITAL PROJECTS 19-0466-03-00 AIKENS EXTENSION .00 .00 617,000.00 617,000.00 .0 19-0466-05-00 EAGLE RD PED/BIKE BRIDGE 171,173.75 338,553.27 900,000.00 561,446.73 37.6 19-0466-06-00 HALF CFI PED/BIKE EDUCATION .00 3,300.00 .00 ( 3,300.00).0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 CAPITAL PROJECTS FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 42 19-0466-09-00 EAGLE-STATE ST INTERSECTION 16,607.50 19,438.75 840,000.00 820,561.25 2.3 19-0466-10-00 P&Z CAPITAL PROJECTS FY22 3,950.00 3,950.00 50,000.00 46,050.00 7.9 TOTAL PZ CAPITAL PROJECTS 191,731.25 365,242.02 2,407,000.00 2,041,757.98 15.2 PARK CAPITAL PROJECTS 19-0467-02-00 PARK CAPITAL PROJECTS FY22 .00 .00 200,000.00 200,000.00 .0 TOTAL PARK CAPITAL PROJECTS .00 .00 200,000.00 200,000.00 .0 PW CAPITAL PROJECTS 19-0469-09-00 PW CAPITAL PROJECTS FY22 .00 .00 250,000.00 250,000.00 .0 TOTAL PW CAPITAL PROJECTS .00 .00 250,000.00 250,000.00 .0 TRAILS & PATHWAYS 19-0473-03-00 GREENBELT MAINTENANCE .00 .00 370,000.00 370,000.00 .0 TOTAL TRAILS & PATHWAYS .00 .00 370,000.00 370,000.00 .0 FEDERAL FUNDS PROJECTS 19-0486-01-00 ARPA, CAPITAL PROJECTS, TBD 19,099.56 19,099.56 3,400,000.00 3,380,900.44 .6 19-0486-01-01 ARPA, SOFTWARE PURCHASES 112,641.86 140,036.86 .00 ( 140,036.86).0 19-0486-01-02 ARPA, MISC LEGAL .00 1,300.75 .00 ( 1,300.75).0 19-0486-01-03 ARPA, FIBER EQUIPMENT 395,847.24 1,096,607.77 .00 ( 1,096,607.77).0 19-0486-01-04 ARPA, FACILITIES 29,634.16 188,710.86 .00 ( 188,710.86).0 19-0486-01-05 ARPA, FIBER MATERIALS 98,081.85 98,081.85 .00 ( 98,081.85).0 19-0486-02-00 ARPA, FIBER NETWORK CONNECT 98,800.00 498,596.33 3,250,000.00 2,751,403.67 15.3 19-0486-02-01 ARPA, FIBER INTRFND TRANS, OUT 2,389,980.00 2,389,980.00 .00 ( 2,389,980.00).0 TOTAL FEDERAL FUNDS PROJECTS 3,144,084.67 4,432,413.98 6,650,000.00 2,217,586.02 66.7 TOTAL FUND EXPENDITURES 2,567,408.48 10,167,968.20 20,949,134.00 10,781,165.80 48.5 NET REVENUE OVER EXPENDITURES ( 2,360,370.71)( 6,585,721.10).00 6,585,721.10 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 ARTS COMMISSION FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 43 LIABILITIES AND EQUITY FUND EQUITY 21-0271-00-00 FUND BALANCE 24,558.04 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 24,558.04) BALANCE - CURRENT DATE ( 24,558.04) TOTAL FUND EQUITY .00 TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 ARTS COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 44 REVENUE 21-0301-00-00 FUNDING FROM GENERAL FUND 24,848.15 24,848.15 44,901.00 20,052.85 55.3 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 .00 430.00 500.00 70.00 86.0 21-0376-12-00 POSTCARD REVENUE .00 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 24,848.15 25,296.80 77,420.00 52,123.20 32.7 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 965.00 9,537.00 15,000.00 5,463.00 63.6 TOTAL ART EDUCATION 965.00 9,537.00 15,000.00 5,463.00 63.6 ART INSTALLATION 21-0422-00-00 ARTS IN PUBLIC SPACES/BEAUTIFY 38,087.31 38,178.61 33,120.00 ( 5,058.61)115.3 TOTAL ART INSTALLATION 38,087.31 38,178.61 33,120.00 ( 5,058.61)115.3 ACQUISITION OF ART 21-0423-00-00 ACQUISITION OF ART .00 600.00 1,500.00 900.00 40.0 TOTAL ACQUISITION OF ART .00 600.00 1,500.00 900.00 40.0 COMMUNITY EVENTS 21-0425-00-00 COMMUNITY EVENTS .00 1,527.40 18,000.00 16,472.60 8.5 TOTAL COMMUNITY EVENTS .00 1,527.40 18,000.00 16,472.60 8.5 GALLERY MTNC/SUPPLIES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 ARTS COMMISSION YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 45 21-0427-00-00 GALLERY MTNC/SLUPPLIES .00 11.83 1,500.00 1,488.17 .8 TOTAL GALLERY MTNC/SUPPLIES .00 11.83 1,500.00 1,488.17 .8 TOTAL FUND EXPENDITURES 39,052.31 49,854.84 77,420.00 27,565.16 64.4 NET REVENUE OVER EXPENDITURES ( 14,204.16)( 24,558.04).00 24,558.04 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 PUBLIC WORKS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 46 LIABILITIES AND EQUITY LIABILITIES 23-0202-00-00 VOUCHERS PAYABLE 37,495.96 23-0216-00-00 ACCRUED PAYROLL 10,783.10 23-0217-02-00 FEDERAL WITHHOLDING 25.57 23-0217-03-00 FICA 3,569.98 23-0217-04-00 PUBLIC RETIREMENT 2,814.49 23-0217-05-00 PW DEPT MISC DEDUCTIONS ( 14,386.03) 23-0217-07-00 HEALTH INSURANCE 18,221.28 23-0217-08-00 GARNISHMENT ( 1,162.50) 23-0217-09-00 WORKERS' COMPENSATION 113,314.01 23-0217-10-00 HSA CONTRIBUTION ( 1,160.00) TOTAL LIABILITIES 169,515.86 FUND EQUITY 23-0271-00-00 FUND BALANCE 587,726.71 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 757,242.57) BALANCE - CURRENT DATE ( 757,242.57) TOTAL FUND EQUITY ( 169,515.86) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 47 REVENUE 23-0302-00-00 FUNDING FROM GENERAL FUND 471,618.24 903,553.25 2,167,755.00 1,264,201.75 41.7 23-0303-00-00 VENDOR LEASE PAYMENTS, PARKS 2,670.52 6,130.22 3,000.00 ( 3,130.22)204.3 23-0315-01-00 SANITATION SERVICES .00 .00 25,000.00 25,000.00 .0 23-0315-02-00 SIDEWALKS, LTS, TREES, STR-REP .00 .00 150,000.00 150,000.00 .0 23-0315-06-00 TREE FUNDS, CARRYOVER .00 .00 29,511.00 29,511.00 .0 23-0315-09-00 WYCLIFF PUMP STATION .00 .00 6,690.00 6,690.00 .0 23-0316-00-00 ARBOR DAY, TREE CITY USA GRANT .00 .00 300.00 300.00 .0 23-0316-01-00 MEMORIAL DONATIONS 2,986.84 5,904.94 6,000.00 95.06 98.4 TOTAL FUND REVENUE 477,275.60 915,588.41 2,388,256.00 1,472,667.59 38.3 EXPENDITURES ADMINISTRATION 23-0413-01-00 OFFICE SUPPLIES 38.78 336.78 1,000.00 663.22 33.7 23-0413-02-00 PRINTING AND PUBLISHING .00 .00 1,000.00 1,000.00 .0 23-0413-03-00 LEGAL, ADV, PUBLICATION .00 1,920.36 7,500.00 5,579.64 25.6 23-0413-04-00 TRAINING ( 1,215.56)11,311.16 15,500.00 4,188.84 73.0 23-0413-05-00 TRAVEL & PER DIEM .00 438.22 6,725.00 6,286.78 6.5 23-0413-06-00 PROFESSIONAL DUES .00 30.00 2,500.00 2,470.00 1.2 23-0413-09-00 UNIFORMS AND SAFETY CLOTHING 4,305.22 4,755.22 5,500.00 744.78 86.5 23-0413-10-00 PUBLIC RELATIONS .00 .00 1,000.00 1,000.00 .0 TOTAL ADMINISTRATION 3,128.44 18,791.74 40,725.00 21,933.26 46.1 GEN MAINTENANCE & REPAIR 23-0414-01-00 DO NOT USE .00 567.96 .00 ( 567.96).0 23-0414-02-00 MISC MTNC & REPAIR GROUNDS 12,783.72 28,927.28 40,000.00 11,072.72 72.3 23-0414-03-00 MATERIALS AND SUPPLIES 29,853.56 61,835.55 47,000.00 ( 14,835.55)131.6 23-0414-04-00 HOLIDAY LIGHTING 7,961.15 11,761.15 7,000.00 ( 4,761.15)168.0 23-0414-05-00 PAPER PRODUCTS 11,433.04 40,607.38 40,000.00 ( 607.38)101.5 23-0414-06-00 BACK FLOW PARTS REPLACEMENT .00 239.29 5,000.00 4,760.71 4.8 23-0414-07-01 MTNC/RPR SNOW EQUIPMENT .00 250.00 5,000.00 4,750.00 5.0 23-0414-08-00 SIGNS & SIGN REPLACEMENT 3,446.88 4,585.55 5,000.00 414.45 91.7 23-0414-10-00 ROOF MAINTENANCE .00 .00 3,000.00 3,000.00 .0 23-0414-11-00 HVAC MAINTENANCE 178.02 3,383.86 2,500.00 ( 883.86)135.4 23-0414-12-00 EMERGENCY REPAIRS .00 5,035.00 25,000.00 19,965.00 20.1 TOTAL GEN MAINTENANCE & REPAIR 65,656.37 157,193.02 179,500.00 22,306.98 87.6 RESTRICTED 23-0415-02-00 SIDEWALKS, LTS, TREES, STR-REP 35,200.00 35,200.00 150,000.00 114,800.00 23.5 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 48 TOTAL RESTRICTED 35,200.00 35,200.00 150,000.00 114,800.00 23.5 CONTRACTS & AGREEMENTS 23-0416-00-00 WYCLIFFE PUMP STATION 3,919.03 5,032.42 6,690.00 1,657.58 75.2 23-0416-01-00 FARMERS UNION .00 1,300.74 1,200.00 ( 100.74)108.4 23-0416-02-00 EAST ENTRY SIGN .00 339.11 1,000.00 660.89 33.9 23-0416-03-00 SCENIC BYWAY .00 .00 154.00 154.00 .0 23-0416-07-00 CHAUMONT LEASE AGREEMENT .00 1.00 1.00 .00 100.0 23-0416-08-00 BASELINE MANAGER AGREEMENT .00 3,582.00 3,500.00 ( 82.00)102.3 23-0416-09-00 NEW DRY CREEK DITCH CO .00 306.00 1,000.00 694.00 30.6 23-0416-10-00 BALLANTYNE/BOISE VALLEY DITCH .00 766.25 2,000.00 1,233.75 38.3 TOTAL CONTRACTS & AGREEMENTS 3,919.03 11,327.52 15,545.00 4,217.48 72.9 VEHICLES 23-0417-01-00 VEHICLE MTNC & REPAIR 7,440.19 14,145.94 17,000.00 2,854.06 83.2 23-0417-02-00 GAS AND OIL 13,345.98 32,811.62 25,000.00 ( 7,811.62)131.3 23-0417-05-00 VEHICLE CAR WASH 60.00 78.00 2,200.00 2,122.00 3.6 TOTAL VEHICLES 20,846.17 47,035.56 44,200.00 ( 2,835.56)106.4 PROGRAMS 23-0418-03-00 MEMORIALS, MTNC/REPAIR 105.40 5,081.60 6,000.00 918.40 84.7 TOTAL PROGRAMS 105.40 5,081.60 6,000.00 918.40 84.7 FLOWER BASKETS 23-0419-01-00 MATERIALS & SUPPLIES .00 .00 2,000.00 2,000.00 .0 23-0419-02-00 FLOWERS 16,610.00 16,610.00 15,000.00 ( 1,610.00)110.7 TOTAL FLOWER BASKETS 16,610.00 16,610.00 17,000.00 390.00 97.7 EQUIPMENT MTNC & REPAIR 23-0420-00-00 MTNC/REPAIR EQUIPMENT 145.13 7,890.21 10,000.00 2,109.79 78.9 TOTAL EQUIPMENT MTNC & REPAIR 145.13 7,890.21 10,000.00 2,109.79 78.9 SUSTAINABILITY-CONSERVATION 23-0421-00-00 SUSTAINABILITY & CONSERVATION .00 3,383.92 .00 ( 3,383.92).0 23-0421-01-00 SANITATION SERVICES 9,587.35 23,722.48 54,000.00 30,277.52 43.9 23-0421-02-00 TREE FUNDS 900.00 900.00 29,511.00 28,611.00 3.1 23-0421-03-00 TREE VOUCHER PROGRAM .00 15,073.87 15,000.00 ( 73.87)100.5 23-0421-04-00 ARBOR DAY, TREE CITY USA GRANT .00 .00 300.00 300.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 49 TOTAL SUSTAINABILITY-CONSERVATION 10,487.35 43,080.27 98,811.00 55,730.73 43.6 FLEET MANAGEMENT 23-0423-00-00 VEHICLE REPLACEMENT .00 88,104.00 83,700.00 ( 4,404.00)105.3 TOTAL FLEET MANAGEMENT .00 88,104.00 83,700.00 ( 4,404.00)105.3 PERSONNEL 23-0433-10-00 SALARIES-FULL TIME 179,718.89 541,371.50 654,000.00 112,628.50 82.8 23-0433-10-01 SALARIES - PERSONNEL SERVICES 14,915.76 68,959.32 .00 ( 68,959.32).0 23-0433-11-00 OVERTIME 4,182.76 10,178.25 18,600.00 8,421.75 54.7 23-0433-15-00 SALARIES - PART TIME 549.56 1,307.74 .00 ( 1,307.74).0 23-0433-16-00 SALARIES -SEASONAL 134.74 28,026.31 195,400.00 167,373.69 14.3 23-0433-21-00 FICA 13,813.73 43,847.68 66,500.00 22,652.32 65.9 23-0433-22-00 PERSI 22,047.62 67,398.41 78,500.00 11,101.59 85.9 23-0433-24-00 WORKERS' COMPENSATION 7,341.44 23,355.50 .00 ( 23,355.50).0 23-0433-25-00 INSURANCE 23,890.77 74,155.42 142,500.00 68,344.58 52.0 23-0433-26-00 HSA CONTRIBUTION 1,110.00 3,940.00 15,600.00 11,660.00 25.3 23-0433-27-00 HRA BUY-DOWN .00 .00 7,700.00 7,700.00 .0 23-0433-29-00 PTO CASH OUT .00 6,958.40 .00 ( 6,958.40).0 TOTAL PERSONNEL 267,705.27 869,498.53 1,178,800.00 309,301.47 73.8 SHOP 23-0440-00-00 SHOP LEASE 4,627.76 26,467.08 27,000.00 532.92 98.0 23-0440-01-00 BLDG MAINTENANCE & REPAIR 535.00 535.00 .00 ( 535.00).0 23-0440-02-00 UTILITIES 255.30 2,417.85 3,750.00 1,332.15 64.5 TOTAL SHOP 5,418.06 29,419.93 30,750.00 1,330.07 95.7 STREET LIGHTS 23-0441-01-00 MAINTENANCE & REPAIR .00 123.00 8,000.00 7,877.00 1.5 23-0441-02-00 UTILITIES 6,211.37 25,786.23 55,000.00 29,213.77 46.9 TOTAL STREET LIGHTS 6,211.37 25,909.23 63,000.00 37,090.77 41.1 CITY HALL 23-0442-01-00 BLDG MAINTENANCE & REPAIR 5,677.34 8,975.34 2,500.00 ( 6,475.34)359.0 23-0442-02-00 MTNC & REPAIR GROUNDS .00 277.14 1,500.00 1,222.86 18.5 23-0442-04-00 UTILITIES 9,292.20 36,359.00 40,000.00 3,641.00 90.9 TOTAL CITY HALL 14,969.54 45,611.48 44,000.00 ( 1,611.48)103.7 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 50 SENIOR CENTER 23-0443-01-00 BLDG MAINTENANCE & REPAIR 95.00 2,594.69 2,500.00 ( 94.69)103.8 23-0443-02-00 MTNC & REPAIR GROUNDS .00 .00 1,500.00 1,500.00 .0 TOTAL SENIOR CENTER 95.00 2,594.69 4,000.00 1,405.31 64.9 LIBRARY 23-0444-01-00 BLDG MAINTENANCE & REPAIR 2,146.78 12,136.22 5,000.00 ( 7,136.22)242.7 23-0444-02-00 MTNC & REPAIR GROUNDS 105.60 105.60 2,000.00 1,894.40 5.3 TOTAL LIBRARY 2,252.38 12,241.82 7,000.00 ( 5,241.82)174.9 MUSEUM 23-0445-01-00 BLDG MAINTENANCE & REPAIR .00 4,029.18 2,500.00 ( 1,529.18)161.2 TOTAL MUSEUM .00 4,029.18 2,500.00 ( 1,529.18)161.2 ARBORETUM PARK 23-0446-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0446-02-00 EQUIPMENT MTNC & REPAIRS .00 .00 500.00 500.00 .0 23-0446-03-00 GROUNDS MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0446-04-00 UTILITIES 457.24 471.86 1,000.00 528.14 47.2 TOTAL ARBORETUM PARK 457.24 471.86 2,500.00 2,028.14 18.9 FLAG PLAZA 23-0447-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0447-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0447-03-00 GROUNDS - MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0447-04-00 UTILITIES 99.98 319.63 225.00 ( 94.63)142.1 TOTAL FLAG PLAZA 99.98 319.63 1,725.00 1,405.37 18.5 FRIENDSHIP PARK 23-0448-01-00 BLDGS/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0448-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0448-03-00 GROUNDS MTNC & REPAIR .00 .00 2,500.00 2,500.00 .0 23-0448-04-00 UTILITIES 1,020.38 1,847.39 3,000.00 1,152.61 61.6 TOTAL FRIENDSHIP PARK 1,020.38 1,847.39 6,500.00 4,652.61 28.4 GUERBER PARK CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 51 23-0449-01-00 BLDGS/STRUCTURES MTNC & REPAIR 1,481.96 2,194.96 6,500.00 4,305.04 33.8 23-0449-02-00 EQUIPMENT MTNC & REPAIR .00 1,667.69 1,500.00 ( 167.69)111.2 23-0449-03-00 GROUNDS MTNC & REPAIR .00 19.98 5,000.00 4,980.02 .4 23-0449-04-00 UTILITIES 3,656.83 13,532.01 24,000.00 10,467.99 56.4 TOTAL GUERBER PARK 5,138.79 17,414.64 37,000.00 19,585.36 47.1 HERITAGE PARK 23-0450-01-00 BLDG/STRUCTURES MTNC & REPAIR 533.60 533.60 2,000.00 1,466.40 26.7 23-0450-02-00 EQUIPMENT MTNC & REPAIR .00 36.98 1,500.00 1,463.02 2.5 23-0450-03-00 GROUNDS MTNC & REPAIR .00 94.45 500.00 405.55 18.9 23-0450-04-00 UTILITIES 1,572.48 3,515.51 3,000.00 ( 515.51)117.2 TOTAL HERITAGE PARK 2,106.08 4,180.54 7,000.00 2,819.46 59.7 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 540.65 541.70 1,000.00 458.30 54.2 TOTAL MCDONALDS PARK/PATHWAY 540.65 541.70 2,000.00 1,458.30 27.1 MERRILL PARK 23-0452-01-00 BLDG/STRUCTURES MTNC & REPAIR .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 .00 189.00 5,000.00 4,811.00 3.8 23-0452-04-00 UTILITIES 10,027.25 21,465.13 9,500.00 ( 11,965.13)226.0 TOTAL MERRILL PARK 10,027.25 23,625.13 22,500.00 ( 1,125.13)105.0 ORVAL KRASEN PARK 23-0453-01-00 BLDGS/STRUCTURES MTNC & REPAIR 5,726.71 5,726.71 500.00 ( 5,226.71)1145.3 23-0453-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0453-03-00 GROUNDS MTNC & REPAIR 16.73 16.73 500.00 483.27 3.4 23-0453-04-00 UTILITIES 1,744.14 3,062.52 2,000.00 ( 1,062.52)153.1 TOTAL ORVAL KRASEN PARK 7,487.58 8,805.96 3,500.00 ( 5,305.96)251.6 SPORTS COMPLEX 23-0454-01-00 BLDGS/STRUCTURES MTNC & REPAIR 288.93 2,179.60 2,500.00 320.40 87.2 23-0454-02-00 EQUIPMENT MTNC & REPAIR 424.19 2,093.44 1,000.00 ( 1,093.44)209.3 23-0454-03-00 GROUNDS MTNC & REPAIR 312.00 312.00 1,000.00 688.00 31.2 23-0454-04-00 UTILITIES 15,865.58 31,876.55 20,000.00 ( 11,876.55)159.4 TOTAL SPORTS COMPLEX 16,890.70 36,461.59 24,500.00 ( 11,961.59)148.8 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 52 TOWN ENTRANCE SIGNS 23-0455-01-00 BLDGS/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0455-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0455-03-00 GROUNDS MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0455-04-00 UTILITIES 5,629.24 9,297.98 21,000.00 11,702.02 44.3 TOTAL TOWN ENTRANCE SIGNS 5,629.24 9,297.98 22,500.00 13,202.02 41.3 PLAZA DRIVE 23-0456-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0456-03-00 GROUNDS MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0456-04-00 UTILITIES 545.79 1,416.14 1,500.00 83.86 94.4 TOTAL PLAZA DRIVE 545.79 1,416.14 2,500.00 1,083.86 56.7 PAMELA BAKER PARK 23-0459-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0459-02-00 GROUNDS MTNC & REPAIR 1,483.75 1,875.00 500.00 ( 1,375.00)375.0 23-0459-03-00 EQUIPMENT MTNC/REPAIR .00 .00 500.00 500.00 .0 23-0459-04-00 UTILITIES 245.32 6,009.59 5,000.00 ( 1,009.59)120.2 TOTAL PAMELA BAKER PARK 1,729.07 7,884.59 6,500.00 ( 1,384.59)121.3 CAPITAL EQUIPMENT 23-0460-00-00 TOOLS 924.37 4,874.22 5,000.00 125.78 97.5 23-0460-01-00 EQUIPMENT 410.96 22,729.47 85,000.00 62,270.53 26.7 TOTAL CAPITAL EQUIPMENT 1,335.33 27,603.69 90,000.00 62,396.31 30.7 CITY LANDSCAPE MAINTENANCE 23-0462-00-00 EQUIPMENT RENTAL 295.27 3,996.16 7,500.00 3,503.84 53.3 23-0462-01-00 SPRAYING/FERTILIZING 2,053.00 26,497.78 48,000.00 21,502.22 55.2 23-0462-02-00 SAFETY EQUIPMENT .00 .00 1,000.00 1,000.00 .0 23-0462-03-00 DUMPING-DISPOSAL 64.51 715.79 5,000.00 4,284.21 14.3 TOTAL CITY LANDSCAPE MAINTENANCE 2,412.78 31,209.73 61,500.00 30,290.27 50.8 LINDER ROAD RESTROOM 23-0463-01-00 BLDG/STRUCTURES MTNC REPAIR .00 737.50 1,000.00 262.50 73.8 23-0463-02-00 EQUIPMENT MTNC-REPAIR .00 198.98 500.00 301.02 39.8 23-0463-03-00 GROUNDS MTNC & REPAIR .00 3,120.91 500.00 ( 2,620.91)624.2 23-0463-04-00 UTILITIES 789.51 2,887.01 6,000.00 3,112.99 48.1 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 53 TOTAL LINDER ROAD RESTROOM 789.51 6,944.40 8,000.00 1,055.60 86.8 TRAILS 23-0464-00-00 GROUNDS MTNC/REPAIR .00 2,501.00 5,000.00 2,499.00 50.0 23-0464-01-00 EQUIPMENT RENTAL 94.00 390.41 4,000.00 3,609.59 9.8 TOTAL TRAILS 94.00 2,891.41 9,000.00 6,108.59 32.1 FISCAL YEAR CAPITAL PROJECTS 23-0480-15-00 LANDSCAPE UPGRADES - PARKS 17,588.08 37,141.94 25,000.00 ( 12,141.94)148.6 TOTAL FISCAL YEAR CAPITAL PROJECTS 17,588.08 37,141.94 25,000.00 ( 12,141.94)148.6 FY 21/22 PROJECTS 23-0483-01-00 CAPITAL PROJECTS FY22 10,027.00 35,153.88 80,500.00 45,346.12 43.7 TOTAL FY 21/22 PROJECTS 10,027.00 35,153.88 80,500.00 45,346.12 43.7 TOTAL FUND EXPENDITURES 536,668.96 1,672,830.98 2,388,256.00 715,425.02 70.0 NET REVENUE OVER EXPENDITURES ( 59,393.36)( 757,242.57).00 757,242.57 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 RECREATION - EAGLE FUN DAYS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 54 ASSETS 24-0101-00-00 CASH 4,769.47 TOTAL ASSETS 4,769.47 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 28,476.05 BALANCE - CURRENT DATE 28,476.05 TOTAL FUND EQUITY 28,476.05 TOTAL LIABILITIES AND EQUITY 4,769.47 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 RECREATION - EAGLE FUN DAYS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:33PM PAGE: 55 REVENUE 24-0301-00-00 FUNDING FROM GENERAL FUND 70,491.24 110,118.32 90,000.00 ( 20,118.32)122.4 24-0303-00-00 SPONSORSHIPS .00 .00 21,000.00 21,000.00 .0 24-0303-01-00 CAR SHOW 1,542.00 2,997.00 3,300.00 303.00 90.8 24-0303-02-00 CORNHOLE .00 .00 1,250.00 1,250.00 .0 24-0303-03-00 FUN RUN 68.00 68.00 3,000.00 2,932.00 2.3 24-0303-04-00 VENDORS 5,186.73 5,866.73 7,000.00 1,133.27 83.8 24-0303-05-00 ROCKY MOUNTAIN OYSTER FEED 3,336.00 4,191.00 20,000.00 15,809.00 21.0 TOTAL FUND REVENUE 80,623.97 123,241.05 145,550.00 22,308.95 84.7 EXPENDITURES ADMIN EXPENDITURES 24-0401-01-00 FUN DAYS CONTRACTS 5,000.00 10,000.00 10,000.00 .00 100.0 24-0401-03-00 FIREWORKS 7,000.00 17,000.00 20,000.00 3,000.00 85.0 24-0401-04-00 ADVERTISEMENT .00 1,150.00 12,000.00 10,850.00 9.6 24-0401-05-00 MUSIC & ENTERTAINMENT 10,036.50 10,036.50 10,000.00 ( 36.50)100.4 24-0401-06-00 SUPPLIES 612.50 1,435.00 6,000.00 4,565.00 23.9 24-0401-07-00 EQUIPMENT 5,319.27 5,319.27 6,000.00 680.73 88.7 TOTAL ADMIN EXPENDITURES 27,968.27 44,940.77 64,000.00 19,059.23 70.2 LOGISTICS 24-0410-00-00 PORTA POTTIES 1,745.00 1,745.00 2,000.00 255.00 87.3 24-0410-01-00 SUPPLIES 1,065.00 1,065.00 2,500.00 1,435.00 42.6 24-0410-02-00 TRAFFIC BARRIERS & CONTROL 20,400.75 20,400.75 8,000.00 ( 12,400.75)255.0 24-0410-03-00 GOLF CART RENTALS .00 .00 500.00 500.00 .0 24-0410-04-00 POLICE OVERTIME .00 .00 7,000.00 7,000.00 .0 24-0410-05-00 STREET CLOSURES 386.50 386.50 4,500.00 4,113.50 8.6 24-0410-06-00 SIGNAGE .00 .00 2,500.00 2,500.00 .0 24-0410-07-00 SECURITY 8,531.00 8,531.00 7,000.00 ( 1,531.00)121.9 24-0410-09-00 EQUIPMENT 1,366.86 1,366.86 1,500.00 133.14 91.1 TOTAL LOGISTICS 33,495.11 33,495.11 35,500.00 2,004.89 94.4 FUN RUN 24-0420-01-00 PROMOTIONS 382.76 382.76 2,000.00 1,617.24 19.1 24-0420-02-00 BIBS .00 .00 300.00 300.00 .0 24-0420-03-00 BREAKFAST .00 .00 500.00 500.00 .0 24-0420-04-00 ADVERTISING 25.00 25.00 200.00 175.00 12.5 24-0420-05-00 MISCELLANEOUS 3,917.06 3,917.06 400.00 ( 3,517.06)979.3 TOTAL FUN RUN 4,324.82 4,324.82 3,400.00 ( 924.82)127.2 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 RECREATION - EAGLE FUN DAYS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:34PM PAGE: 56 CAR SHOW 24-0430-00-00 MARKETING/ADVERTISING .00 .00 100.00 100.00 .0 24-0430-01-00 DASH PLAQUES .00 .00 300.00 300.00 .0 24-0430-02-00 TROPHIES 225.32 2,163.32 2,500.00 336.68 86.5 24-0430-03-00 SUPPLIES 15.49 15.49 300.00 284.51 5.2 24-0430-04-00 PARKING .00 .00 500.00 500.00 .0 24-0430-05-00 MISCELLANEOUS 28.61 28.61 150.00 121.39 19.1 24-0430-06-00 RAFFLE .00 .00 500.00 500.00 .0 24-0430-08-00 COMMUNITY GROUP 771.00 771.00 500.00 ( 271.00)154.2 TOTAL CAR SHOW 1,040.42 2,978.42 4,850.00 1,871.58 61.4 CORNHOLE 24-0440-00-00 BUILDING/PAINT SUPPLIES .00 .00 200.00 200.00 .0 24-0440-01-00 ARTIST .00 .00 300.00 300.00 .0 24-0440-02-00 BEAN BAGS .00 .00 300.00 300.00 .0 24-0440-03-00 ADVERTISING 1,150.00 1,150.00 .00 ( 1,150.00).0 TOTAL CORNHOLE 1,150.00 1,150.00 800.00 ( 350.00)143.8 ROCKY MOUNTAIN OYSTER FEED 24-0445-01-00 COMMUNITY BENEFICIARY .00 .00 20,000.00 20,000.00 .0 24-0445-03-00 FOOD AND BEVERAGE 7,875.88 7,875.88 17,000.00 9,124.12 46.3 TOTAL ROCKY MOUNTAIN OYSTER FEED 7,875.88 7,875.88 37,000.00 29,124.12 21.3 TOTAL FUND EXPENDITURES 75,854.50 94,765.00 145,550.00 50,785.00 65.1 NET REVENUE OVER EXPENDITURES 4,769.47 28,476.05 .00 ( 28,476.05).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 PATHWAY IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:34PM PAGE: 57 ASSETS 25-0101-00-00 CASH 25,821.50 25-0151-25-00 FIRST INTERSTATE INVESTMENT 829,204.39 TOTAL ASSETS 855,025.89 LIABILITIES AND EQUITY FUND EQUITY 25-0271-00-00 FUND BALANCE 763,927.09 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 91,098.80 BALANCE - CURRENT DATE 91,098.80 TOTAL FUND EQUITY 855,025.89 TOTAL LIABILITIES AND EQUITY 855,025.89 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 PATHWAY IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:34PM PAGE: 58 REVENUE 25-0322-19-00 DEVELOPMENT IMPACT FEE 11,237.00 89,896.00 198,300.00 108,404.00 45.3 25-0371-25-00 BANK INTEREST 654.49 1,685.80 1,080.00 ( 605.80)156.1 25-0399-00-00 CARRY OVER .00 .00 702,268.00 702,268.00 .0 TOTAL FUND REVENUE 11,891.49 91,581.80 901,648.00 810,066.20 10.2 EXPENDITURES CAPITAL IMPROVEMENTS 25-0438-00-00 CAPITAL IMPROVEMENTS .00 483.00 801,648.00 801,165.00 .1 25-0438-01-00 EAGLE ISLAND ST PK CONNECTION .00 .00 100,000.00 100,000.00 .0 TOTAL CAPITAL IMPROVEMENTS .00 483.00 901,648.00 901,165.00 .1 TOTAL FUND EXPENDITURES .00 483.00 901,648.00 901,165.00 .1 NET REVENUE OVER EXPENDITURES 11,891.49 91,098.80 .00 ( 91,098.80).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:34PM PAGE: 59 LIABILITIES AND EQUITY LIABILITIES 26-0202-00-00 VOUCHERS PAYABLE 1,152.00 26-0217-03-00 FICA 371.85 26-0217-04-00 PUBLIC RETIREMENT 583.73 26-0217-07-00 HEALTH INSURANCE ( 140.33) 26-0217-09-00 WORKERS' COMPENSATION 830.15 TOTAL LIABILITIES 2,797.40 FUND EQUITY 26-0271-00-00 FUND BALANCE ( 1,747.65) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 1,049.75) BALANCE - CURRENT DATE ( 1,049.75) TOTAL FUND EQUITY ( 2,797.40) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:34PM PAGE: 60 REVENUE 26-0301-00-00 FUNDING FROM GENERAL FUND 28,137.85 173,858.04 212,056.00 38,197.96 82.0 TOTAL FUND REVENUE 28,137.85 173,858.04 212,056.00 38,197.96 82.0 EXPENDITURES ADMINISTRATION 26-0413-05-00 OFFICE SUPPLIES 781.98 883.59 500.00 ( 383.59)176.7 26-0413-06-00 DUPLICATION/PUBLISHING/PRINTIN .00 1,043.08 1,500.00 456.92 69.5 26-0413-12-00 TRAINING .00 750.00 6,895.00 6,145.00 10.9 26-0413-13-00 TRAVEL & PER DIEM ( 407.00)1,504.48 6,400.00 4,895.52 23.5 26-0413-14-00 PROFESSIONAL DUES .00 1,397.88 4,281.00 2,883.12 32.7 26-0413-19-00 COMMUNICATIONS 2,152.00 11,505.51 12,200.00 694.49 94.3 26-0413-29-00 UNIFORMS .00 .00 200.00 200.00 .0 TOTAL ADMINISTRATION 2,526.98 17,084.54 31,976.00 14,891.46 53.4 PERSONNEL 26-0415-10-00 SALARIES - FULL TIME 23,600.85 121,155.69 135,500.00 14,344.31 89.4 26-0415-11-00 OVERTIME .00 72.88 .00 ( 72.88).0 26-0415-21-00 FICA 1,805.39 9,260.60 10,400.00 1,139.40 89.0 26-0415-22-00 PERSI 2,778.72 14,435.57 16,300.00 1,864.43 88.6 26-0415-23-00 HRA BUY-DOWN .00 .00 3,080.00 3,080.00 .0 26-0415-24-00 WORKERS' COMPENSATION 44.81 230.23 .00 ( 230.23).0 26-0415-25-00 INSURANCE 2,007.33 12,668.28 14,800.00 2,131.72 85.6 TOTAL PERSONNEL 30,237.10 157,823.25 180,080.00 22,256.75 87.6 TOTAL FUND EXPENDITURES 32,764.08 174,907.79 212,056.00 37,148.21 82.5 NET REVENUE OVER EXPENDITURES ( 4,626.23)( 1,049.75).00 1,049.75 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 LAW ENF DEV IMPACT FEES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:34PM PAGE: 61 ASSETS 27-0101-00-00 CASH 14,090.52 27-0151-25-00 FIRST INTERSTATE INVESTMENTS 65,069.80 TOTAL ASSETS 79,160.32 LIABILITIES AND EQUITY FUND EQUITY 27-0271-00-00 POLICE IMPACT FEE/FUND BALANCE 42,529.49 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 36,630.83 BALANCE - CURRENT DATE 36,630.83 TOTAL FUND EQUITY 79,160.32 TOTAL LIABILITIES AND EQUITY 79,160.32 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 LAW ENF DEV IMPACT FEES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:34PM PAGE: 62 REVENUE 27-0322-19-00 RESIDENTIAL IMPACT FEES 4,443.84 36,590.52 66,600.00 30,009.48 54.9 27-0322-20-00 COMMERCIAL - IMPACT FEES .00 .00 30,000.00 30,000.00 .0 27-0371-25-00 BANK INTEREST 36.84 40.31 100.00 59.69 40.3 27-0399-00-00 CARRY OVER .00 .00 45,000.00 45,000.00 .0 TOTAL FUND REVENUE 4,480.68 36,630.83 141,700.00 105,069.17 25.9 EXPENDITURES CAPITAL IMPROVEMENTS 27-0438-00-00 EQUIPMENT .00 .00 70,850.00 70,850.00 .0 27-0438-01-00 CITY FACILITY .00 .00 70,850.00 70,850.00 .0 TOTAL CAPITAL IMPROVEMENTS .00 .00 141,700.00 141,700.00 .0 TOTAL FUND EXPENDITURES .00 .00 141,700.00 141,700.00 .0 NET REVENUE OVER EXPENDITURES 4,480.68 36,630.83 .00 ( 36,630.83).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 CITY HALL BOND FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:34PM PAGE: 63 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 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 CITY HALL BOND FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:34PM PAGE: 64 REVENUE 54-0399-01-00 FUNDING FROM GENERAL FUND 91,249.76 99,543.71 102,950.00 3,406.29 96.7 TOTAL FUND REVENUE 91,249.76 99,543.71 102,950.00 3,406.29 96.7 EXPENDITURES BOND PAYMENTS 54-0480-81-00 PRINCIPAL BOND PAYMENT 80,000.00 80,000.00 80,000.00 .00 100.0 54-0480-82-00 INTEREST BOND PAYMENT 11,249.76 22,498.93 22,500.00 1.07 100.0 54-0480-84-00 PAYING AGENT FEE .00 450.00 450.00 .00 100.0 TOTAL BOND PAYMENTS 91,249.76 102,948.93 102,950.00 1.07 100.0 TOTAL FUND EXPENDITURES 91,249.76 102,948.93 102,950.00 1.07 100.0 NET REVENUE OVER EXPENDITURES .00 ( 3,405.22).00 3,405.22 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:34PM PAGE: 65 ASSETS 60-0101-00-00 CASH 937,125.42 60-0115-00-00 WATER/ACCOUNTS RECEIVABLE 152,905.18 60-0151-01-00 INVESTMENTS, DEQ LOAN PMTS 722,216.69 60-0151-02-00 INVESTMENTS, DEQ LOAN RESERVE 182,000.00 60-0151-25-00 FIRST INTERSTATE INVESTMENT 4,146,887.44 60-0161-00-00 WATER/LAND 93,250.00 60-0162-00-00 WATER/BUILDINGS & STRUCTURES 559,285.00 60-0163-00-00 WATER/ACCUMULATED DEP.-BLDGS.&( 172,451.00) 60-0164-00-00 WATER/IMPROVEMENTS-OTHER THAN 12,593,065.00 60-0165-00-00 WATER/ACCUM. DEP.-IMPROVEMENTS ( 3,518,225.00) 60-0166-00-00 WATER/MACHINERY & EQUIPMENT 1,394,602.00 60-0167-00-00 WATER/ACCUMULATED DEPREC-EQUIP ( 915,756.00) 60-0170-00-00 HRA 10% DEPOSIT 550.08 60-0171-00-00 DEFERRED OUTFLOWS-PENSION 82,423.00 TOTAL ASSETS 16,257,877.81 LIABILITIES AND EQUITY LIABILITIES 60-0202-00-00 WATER/VOUCHERS PAYABLE 45,189.40 60-0204-00-00 WATER/LEXINGTON - TVV 1,787.89 60-0215-00-00 INTEREST PAYABLE 15,099.00 60-0216-00-00 ACCRUED PAYROLL 6,081.88 60-0217-00-00 COMPENSATED ABSENCE PAYABLE 13,084.04 60-0217-03-00 FICA 1,542.82 60-0217-04-00 PUBLIC RETIREMENT 2,618.32 60-0217-07-00 WATER DEPT HEALTH INSURANCE 9,209.64 60-0217-08-00 GARNISHMENTS 1,162.50 60-0217-09-00 WORKERS' COMPENSATION 62,024.99 60-0217-10-00 HSA CONTRIBUTION ( 100.00) 60-0217-11-00 NET PENSION LIABILITY ( 5,717.00) 60-0217-12-00 DEFERRED INFLOWS-PENSION 182,893.00 60-0220-00-00 WATER/SERVICE DEPOSITS 102,950.00 60-0231-00-00 DEQ LOAN 1,115,023.00 TOTAL LIABILITIES 1,552,849.48 FUND EQUITY 60-0271-00-00 WATER/FUND BALANCE 13,156,448.78 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 1,548,579.55 BALANCE - CURRENT DATE 1,548,579.55 TOTAL FUND EQUITY 14,705,028.33 TOTAL LIABILITIES AND EQUITY 16,257,877.81 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:34PM PAGE: 66 REVENUE 60-0346-59-00 STL-STORAGE & TRUNK LINE FEE 881,615.47 1,689,067.78 105,000.00 ( 1,584,067.78)1608.6 60-0346-60-00 HOOK UP FEES CITY 2,100.00 154,070.00 157,500.00 3,430.00 97.8 60-0347-01-00 BILLING REVENUE 349,506.47 1,254,827.35 1,158,396.00 ( 96,431.35)108.3 60-0347-02-00 OTHER REVENUE 1,950.11 8,370.11 8,400.00 29.89 99.6 60-0347-03-00 RECONNECT FEES 175.00 350.00 600.00 250.00 58.3 60-0347-04-00 DELINQUENT FEES 2,848.50 10,449.00 8,736.00 ( 1,713.00)119.6 60-0347-05-00 MISCELLANEOUS REVENUE 1,494.76 9,074.32 7,500.00 ( 1,574.32)121.0 60-0347-06-00 SYSTEM ENHANCEMENT FEE 116,946.95 451,567.47 400,000.00 ( 51,567.47)112.9 60-0355-01-00 WCE-WATER CONST EQUIV FEE .00 33,600.00 20,000.00 ( 13,600.00)168.0 60-0371-10-00 INVESTMENTS, DEQ, TRANSFERS .00 733.24 .00 ( 733.24).0 60-0371-25-00 BANK INTEREST 4,204.98 9,194.91 6,000.00 ( 3,194.91)153.3 60-0399-00-00 CARRY OVER .00 .00 171,047.00 171,047.00 .0 60-0399-01-00 RESERVES, FOR BUDGET .00 .00 310,000.00 310,000.00 .0 60-0399-02-00 RESERVES, EMERGENCY REPL ITEMS .00 .00 150,000.00 150,000.00 .0 60-0399-03-00 RESERVES, EQUIP/BLDG REPLCMNT .00 .00 225,000.00 225,000.00 .0 60-0399-04-00 RESERVES, REPAIR/ MAINTENANCE .00 .00 150,000.00 150,000.00 .0 60-0399-05-00 RESERVES, VEHICLE REPLACEMENT .00 .00 60,000.00 60,000.00 .0 60-0399-06-00 RESERVES, STL FEES .00 .00 629,200.00 629,200.00 .0 TOTAL FUND REVENUE 1,360,842.24 3,621,304.18 3,567,379.00 ( 53,925.18)101.5 EXPENDITURES VEHICLE OPERATIONS - LEASES 60-0420-01-00 GAS AND OIL 3,294.71 9,144.96 15,000.00 5,855.04 61.0 60-0420-03-00 VEHICLE MTNC & REPAIR 3,730.48 5,993.04 9,000.00 3,006.96 66.6 TOTAL VEHICLE OPERATIONS - LEASES 7,025.19 15,138.00 24,000.00 8,862.00 63.1 PERSONNEL 60-0433-10-00 SALARIES - FULL TIME 90,159.31 312,334.76 372,000.00 59,665.24 84.0 60-0433-10-02 ON-CALL TIME 569.72 2,111.94 7,500.00 5,388.06 28.2 60-0433-11-00 OVERTIME 320.66 1,331.89 4,500.00 3,168.11 29.6 60-0433-21-00 FICA 6,822.94 23,674.33 29,400.00 5,725.67 80.5 60-0433-22-00 PERSI 10,877.39 37,752.75 45,900.00 8,147.25 82.3 60-0433-23-00 HRA BUY-DOWN .00 .00 7,700.00 7,700.00 .0 60-0433-23-01 HRA/COBRA ADMIN FEES .00 .00 800.00 800.00 .0 60-0433-24-00 WORKERS' COMPENSATION 2,516.30 14,723.45 13,500.00 ( 1,223.45)109.1 60-0433-25-00 INSURANCE 11,122.80 42,613.64 58,500.00 15,886.36 72.8 60-0433-26-00 HSA CONTRIBUTIONS 600.00 2,400.00 2,400.00 .00 100.0 60-0433-29-00 PTO CASH OUT .00 1,077.22 15,000.00 13,922.78 7.2 TOTAL PERSONNEL 122,989.12 438,019.98 557,200.00 119,180.02 78.6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:34PM PAGE: 67 OPERATIONS & MAINTENANCE 60-0434-15-00 OFFICE SUPPLIES 148.75 1,037.04 1,800.00 762.96 57.6 60-0434-19-00 TELECOMMUNICATIONS/SCADA 1,815.51 5,832.74 10,836.00 5,003.26 53.8 60-0434-20-00 ADVERTISING - PUBLICATIONS 33.87 33.87 2,000.00 1,966.13 1.7 60-0434-22-00 TRAVEL-MTNGS-EDUCATION 559.50 1,634.50 8,000.00 6,365.50 20.4 60-0434-23-00 DUES & SUBSCRIPTIONS 110.00 819.00 3,100.00 2,281.00 26.4 60-0434-25-00 MTNC EQUIP-COPIERS/SOFTWARE .00 4,149.28 7,800.00 3,650.72 53.2 60-0434-26-00 TOOLS, EQUIPMENT AND SUPPS 1,882.33 5,886.91 10,000.00 4,113.09 58.9 60-0434-27-00 POSTAGE 601.50 601.50 1,300.00 698.50 46.3 60-0434-41-00 LIABILITY INSURANCE .00 4,620.00 4,620.00 .00 100.0 60-0434-42-00 ENGINEERING SERVICES 20,461.44 37,117.89 35,000.00 ( 2,117.89)106.1 60-0434-42-01 LEGAL SERVICES 520.67 1,523.17 25,000.00 23,476.83 6.1 60-0434-42-02 MISC LEGAL AND ENG SERVICES 1,794.50 14,123.00 145,920.00 131,797.00 9.7 60-0434-42-03 PROFESSIONAL SERV - DEVELOPERS 2,413.75 2,413.75 .00 ( 2,413.75).0 60-0434-43-01 CONTRACT SERVICES (REPAIR)2,212.50 5,927.25 35,000.00 29,072.75 16.9 60-0434-44-00 DIG LINE 964.92 3,977.62 4,500.00 522.38 88.4 60-0434-45-00 CITY AUDITOR SERVICES .00 2,500.00 2,500.00 .00 100.0 60-0434-47-00 MAIL SERVICE-CUSTOMER BILLING 9,060.17 27,545.60 28,800.00 1,254.40 95.6 60-0434-50-00 SHOP LEASE 1,983.32 11,624.94 13,400.00 1,775.06 86.8 60-0434-50-01 SHOP UTILITIES 66.69 1,177.73 4,800.00 3,622.27 24.5 60-0434-53-01 PUBLIC WATER DRINKING FEES .00 12,112.00 12,800.00 688.00 94.6 60-0434-53-03 PERMITS AND FEES .00 .00 1,500.00 1,500.00 .0 60-0434-58-00 RPR/MTNC-LINES-METERS-ETC 4,579.96 8,328.61 40,000.00 31,671.39 20.8 60-0434-58-01 RPR/MTNC PUMPS-WELLS-CHEMICAL 8,229.88 14,443.94 50,000.00 35,556.06 28.9 60-0434-59-00 CHEMICALS 2,454.10 7,388.23 9,000.00 1,611.77 82.1 60-0434-60-00 UTILITIES 18,595.90 47,793.59 55,000.00 7,206.41 86.9 60-0434-68-00 UNIFORMS AND SAFETY CLOTHING 299.99 1,462.32 2,300.00 837.68 63.6 60-0434-83-00 MAPPING PROFESSIONAL SERVICES 25,000.00 25,000.00 25,000.00 .00 100.0 TOTAL OPERATIONS & MAINTENANCE 103,789.25 249,074.48 539,976.00 290,901.52 46.1 TESTING-WK-MO-QTR-ANNUAL 60-0435-56-00 TESTING-WK-MO-QTR-ANNUAL 9,693.00 24,359.00 12,000.00 ( 12,359.00)203.0 TOTAL TESTING-WK-MO-QTR-ANNUAL 9,693.00 24,359.00 12,000.00 ( 12,359.00)203.0 DEQ REVOLVING LOAN PAYMENT 60-0436-01-00 DEQ/STATE REVOLVING LOAN PMT .00 400,000.00 400,000.00 .00 100.0 TOTAL DEQ REVOLVING LOAN PAYMENT .00 400,000.00 400,000.00 .00 100.0 RESTRICTED 60-0437-01-00 STL FEES, WATER SYS EXPANSION 8,898.75 43,652.75 100,000.00 56,347.25 43.7 60-0437-03-00 STL FEES, REFUNDS .00 .00 50,000.00 50,000.00 .0 60-0437-99-01 RESERVES, STL FEES .00 .00 35,000.00 35,000.00 .0 TOTAL RESTRICTED 8,898.75 43,652.75 185,000.00 141,347.25 23.6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:34PM PAGE: 68 CAPITAL EXPENDITURES 60-0438-01-00 EQUIPMENT .00 6,313.00 9,950.00 3,637.00 63.5 60-0438-05-01 CURRENT STL PROJECTS 709,314.37 709,314.37 549,200.00 ( 160,114.37)129.2 60-0438-05-02 HORSESHOE BND1-GREENBROOK ( 5,930.57).00 .00 .00 .0 60-0438-08-00 METER SETS, NEW CUSTOMERS 24,276.64 100,302.08 86,250.00 ( 14,052.08)116.3 60-0438-10-00 WATER MASTER PLAN-UPDATE 10,000.00 41,280.00 40,000.00 ( 1,280.00)103.2 60-0438-11-00 CAPITAL CONSTRUCTION PROJECTS 14,792.10 32,467.97 134,000.00 101,532.03 24.2 60-0438-82-00 CITY HALL ADM OVERHEAD 3,200.00 12,803.00 12,803.00 .00 100.0 60-0438-99-01 RESERVES, FOR BUDGET .00 .00 325,000.00 325,000.00 .0 60-0438-99-02 RESERVES, EMERGENCY REPL ITEMS .00 .00 175,000.00 175,000.00 .0 60-0438-99-03 RESERVES, EQUIP, BLDG REPLCMNT .00 .00 250,000.00 250,000.00 .0 60-0438-99-04 RESERVES, WATER SYSTEM R&M .00 .00 175,000.00 175,000.00 .0 60-0438-99-05 RESERVES, VEHICLE REPLACEMENT .00 .00 72,000.00 72,000.00 .0 60-0438-99-06 RESERVES, IDENTIFIED PROJECTS .00 .00 20,000.00 20,000.00 .0 TOTAL CAPITAL EXPENDITURES 755,652.54 902,480.42 1,849,203.00 946,722.58 48.8 TOTAL FUND EXPENDITURES 1,008,047.85 2,072,724.63 3,567,379.00 1,494,654.37 58.1 NET REVENUE OVER EXPENDITURES 352,794.39 1,548,579.55 .00 ( 1,548,579.55).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2022 FIBER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:34PM PAGE: 69 ASSETS 61-0101-00-00 CASH 39,980.00 61-0151-25-00 FIRST INTERSTATE INVESTMENT 2,350,669.30 TOTAL ASSETS 2,390,649.30 LIABILITIES AND EQUITY FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 2,390,649.30 BALANCE - CURRENT DATE 2,390,649.30 TOTAL FUND EQUITY 2,390,649.30 TOTAL LIABILITIES AND EQUITY 2,390,649.30 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2022 FIBER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/20/2022 03:34PM PAGE: 70 REVENUE 61-0347-90-00 BANK INTEREST 669.30 669.30 .00 ( 669.30).0 61-0381-00-00 INTERFUND TRANSFERS, IN 2,389,980.00 2,389,980.00 .00 ( 2,389,980.00).0 TOTAL FUND REVENUE 2,390,649.30 2,390,649.30 .00 ( 2,390,649.30).0 NET REVENUE OVER EXPENDITURES 2,390,649.30 2,390,649.30 .00 ( 2,390,649.30).0