Full Text
TOWN OF MONUMENT COMBINED CASH INVESTMENT APRIL 30, 2018 FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 1 COMBINED CASH ACCOUNTS 99-00-10200 WELLS FARGO OPERATING ACCOUNT 509,563.49 99-00-10203 PEOPLES BANK CD #10200 104,368.57 99-00-10204 PEOPLES BANK CD #10224 101,339.13 99-00-10205 FIRST NATIONAL BANK CD 102,767.59 99-00-10421 COLOTRUST GENERAL FUND 875,646.00 TOTAL COMBINED CASH 1,693,684.78 99-00-10100 CASH ALLOCATED TO OTHER FUNDS ( 1,693,684.78) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 1 ALLOCATION TO GENERAL FUND 635,397.69 2 ALLOCATION TO CAPITAL PROJECTS FUND 78,705.65 4 ALLOCATION TO 2A WATER ASD FUND 572,127.69 5 ALLOCATION TO DEBT SERVICE FUND 94,974.20 31 ALLOCATION TO COMMUNITY DEVELOPMENT FUND ( 9,686.07) 32 ALLOCATION TO TRAFFIC IMPACT FEE FUND 57,726.91 35 ALLOCATION TO STORM DRAINAGE IMPACT FEE FUND ( 222.82) 61 ALLOCATION TO WATER FUND 267,577.13 82 ALLOCATION TO CONSERVATION TRUST FUND ( 2,915.60) TOTAL ALLOCATIONS TO OTHER FUNDS 1,693,684.78 ALLOCATION FROM COMBINED CASH FUND - 99-0010100 ( 1,693,684.78) ZERO PROOF IF ALLOCATIONS BALANCE .00 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET APRIL 30, 2018 GENERAL FUND FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 2 ASSETS 01-00-10100 CASH IN COMBINED CASH FUND 635,397.69 01-00-10104 PETTY CASH FUNDS - LAW ENFORCE 600.00 01-00-10106 PETTY CASH FUNDS - ADMIN 999.91 01-00-10107 PETTY CASH-PW-SCRAP METAL 111.31 01-00-10202 WELLS FARGO CAFETERIA PLAN ACC 26,278.47 01-00-10420 COLOTRUST BONDS PAYABLE 291,814.96 01-00-10422 SANTA ON PATROL DONATIONS 8,983.12 01-00-10425 WELLS FARGO ESCROW FOR CL#405 94,166.58 01-00-10426 COLOTRUST DOJ SEIZURE PD 88.32 01-00-10750 A/R PAYROLL 687.84 01-00-11700 FRANCHISE FEES RECEIVABLE 23,144.00 01-00-11900 TAXES RECEIVABLE - PROPERTY 893,834.00 01-00-11950 DUE FROM OTHER GOVERNMENTS 1,066,705.35 01-00-15000 PREPAID EXPENSE 33,328.02 01-00-15001 PREPAID RECORDING FEES 1,829.53 01-00-15002 PREPAID AMERIFLEX PLAN 1,555.42 01-00-16000 ABATEMENTS RECEIVABLE 1,904.73 TOTAL ASSETS 3,081,429.25 LIABILITIES AND EQUITY LIABILITIES 01-00-20200 ACCOUNTS PAYABLE 23,805.25 01-00-20204 DONATIONS TO PW BUIDLING 10.00 01-00-20205 ACCOUNTS PAYABLE TRI-VIEW 314,898.37 01-00-20214 SANTA ON PATROL DONATIONS 6,605.87 01-00-20215 DOJ PAYMENTS 84.26 01-00-21710 WAGES PAYABLE 144,130.30 01-00-21711 FEDERAL W/H PAYABLE 12,152.72 01-00-21712 STATE W/H PAYABLE 4,283.00 01-00-21713 FICA PAYABLE 18,761.92 01-00-21715 SUTA PAYABLE 1,349.75 01-00-21716 MEDICARE PAYABLE 4,387.81 01-00-21742 RETIREMENT-VALIC/ICMA PAYABLE 15,372.24 01-00-21743 LIFE/DISABILITY INSURANCE - ST 5,798.98 01-00-21745 OUTSTANDING JUDGMENT WARRANTS 721.00 01-00-21746 BRAIN TRAUMA STATE FEES PAYABL ( 855.00) 01-00-21751 HEALTH/DENTAL INSURANCE - BENE 46,480.76 01-00-21752 CAFETERIA PLAN PYBLE-AMERIFLEX ( 2,963.39) 01-00-21755 AFLAC PAYABLE 1,047.98 01-00-21780 OTHER W/H PAYABLE 116.70 01-00-21785 DEPOSITS FOR PARK RESERVATION 225.00 01-00-24243 MVE/TMD BORDER FENCE DEPOSIT 250,000.00 01-00-24244 LEWIS PALMER SD#38 PAYABLE 20,250.00 01-00-24245 PLANNING RETAINER PAYABLE 26,946.77 01-00-24247 CASH-IN-LIEU FOR PARKS 7,068.60 01-00-24250 PLANNING BONDS PAYABLE 290,366.75 01-00-24260 DEFERRED REVENUE 893,834.00 TOTAL LIABILITIES 2,084,879.64 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET APRIL 30, 2018 GENERAL FUND FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 3 FUND EQUITY 01-00-30000 BEGINNING FUND BALANCE - GENER 674,854.36 01-00-30020 RESERVED GENERAL FUND BALANCE 99,445.00 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 222,250.25 BALANCE - CURRENT DATE 222,250.25 TOTAL FUND EQUITY 996,549.61 TOTAL LIABILITIES AND EQUITY 3,081,429.25 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 4 PUBLIC WORKS 01-30-40020 GRAVE OPENING & CLOSING 350.00 350.00 3,500.00 3,150.00 10.0 01-30-40030 PLOT SALES .00 2,400.00 10,000.00 7,600.00 24.0 01-30-40341 PW - PARK RESERVATION FEES 315.00 6,800.00 20,000.00 13,200.00 34.0 01-30-40430 HWY USER'S TAX FUND 19,402.40 75,198.93 235,389.00 160,190.07 32.0 01-30-40450 ROAD & BRIDGE .00 10,638.89 21,500.00 10,861.11 49.5 01-30-48020 GRANT REVENUE 5,726.00 6,486.96 .00 ( 6,486.96) .0 TOTAL PUBLIC WORKS 25,793.40 101,874.78 290,389.00 188,514.22 35.1 ADMINISTRATIVE AND LEGISLATIVE 01-45-40060 INTEREST & INVESTMENT INCOME 1,226.83 4,304.62 3,505.00 ( 799.62) 122.8 01-45-40110 GENERAL PROPERTY TAX 141,674.03 547,402.15 837,620.00 290,217.85 65.4 01-45-40115 SPECIFIC OWNERSHIP TAXES 8,352.64 34,330.80 101,105.00 66,774.20 34.0 01-45-40120 SALES TAX - GENERAL 173,088.49 647,718.75 2,428,364.00 1,780,645.25 26.7 01-45-40124 SALES TAX - AUTO 29,173.90 116,716.76 300,000.00 183,283.24 38.9 01-45-40126 SEVERANCE TAX FUND DIST .00 .00 500.00 500.00 .0 01-45-40127 FEDERAL MINERAL LEASE FUND DIS .00 .00 900.00 900.00 .0 01-45-40141 FRANCHISE FEE-MT VIEW ELEC .00 72,513.79 248,186.00 175,672.21 29.2 01-45-40143 FRANCHISE FEE - BLACK HILLS UT .00 31,110.59 90,846.00 59,735.41 34.3 01-45-40147 FRANCHISE FEE - CENTURY LINK .00 7,116.72 25,000.00 17,883.28 28.5 01-45-40149 ADMINISTRATIVE FEE-WATER FUND 5,803.75 23,215.00 72,195.00 48,980.00 32.2 01-45-40150 FRANCHISE FEE- COMCAST .00 26,239.87 30,000.00 3,760.13 87.5 01-45-40151 PAYMENT IN LIEU OF FF 8,594.47 34,377.88 103,136.00 68,758.12 33.3 01-45-40210 LIQUOR LICENSE 595.00 2,401.25 5,700.00 3,298.75 42.1 01-45-40320 SALE OF COPIES & ORDINANCES .00 90.00 100.00 10.00 90.0 01-45-40400 MOTOR VEHICLE REGISTRATION 2,368.50 10,117.00 46,500.00 36,383.00 21.8 01-45-40410 TOBACCO PRODUCTS TAX 1,950.54 7,213.34 7,000.00 ( 213.34) 103.1 TOTAL ADMINISTRATIVE AND LEGISLATIVE 372,828.15 1,564,868.52 4,300,657.00 2,735,788.48 36.4 COURT 01-46-40510 COURT COLLECTIONS & FEES 1,756.00 8,959.00 60,000.00 51,041.00 14.9 01-46-40515 COURT BONDS .00 2.00 100.00 98.00 2.0 01-46-40620 TRAFFIC SAFETY INCOME 960.00 11,805.00 55,000.00 43,195.00 21.5 TOTAL COURT 2,716.00 20,766.00 115,100.00 94,334.00 18.0 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 5 PLANNING DEPARTMENT 01-49-40130 USE TAX 29,459.22 160,983.66 584,260.00 423,276.34 27.6 01-49-40230 LAND USE PERMITS 2,525.00 12,325.00 40,380.00 28,055.00 30.5 01-49-40240 FENCE PERMITS 127.00 625.92 3,000.00 2,374.08 20.9 01-49-40245 LANDSCAPE PERMITS 1,400.00 3,670.00 7,200.00 3,530.00 51.0 01-49-40255 RIGHT OF WAY PERMITS 700.00 700.00 .00 ( 700.00) .0 01-49-40260 TEMPORARY USE PERMIT 50.00 250.00 500.00 250.00 50.0 01-49-40265 LAKE USE PERMITS .00 500.00 1,000.00 500.00 50.0 01-49-40270 SIGN PERMITS 175.00 1,450.00 2,000.00 550.00 72.5 01-49-40310 PLANNING FEES 10,850.00 21,228.00 43,830.00 22,602.00 48.4 01-49-40311 ENG REV/INSP FEES 150.00 9,125.00 45,000.00 35,875.00 20.3 01-49-40350 CODE ENFORCEMENT FEES .00 .00 300.00 300.00 .0 01-49-41050 INFRASTSRUCTURE FEE-TRIVIEW 6,000.00 20,500.00 50,000.00 29,500.00 41.0 TOTAL PLANNING DEPARTMENT 51,436.22 231,357.58 777,470.00 546,112.42 29.8 LAW ENFORCEMENT 01-51-40350 FEES FOR SERVICE 721.14 4,707.90 10,000.00 5,292.10 47.1 TOTAL LAW ENFORCEMENT 721.14 4,707.90 10,000.00 5,292.10 47.1 TOTAL FUND REVENUE 453,494.91 1,923,574.78 5,493,616.00 3,570,041.22 35.0 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 6 PUBLIC WORKS 01-30-60000 SALARIES 77,646.58 237,204.01 766,508.00 529,303.99 31.0 01-30-60010 OVERTIME PAY 1,530.60 6,223.34 25,000.00 18,776.66 24.9 01-30-60019 LONGEVITY RECOGNITION .00 .00 1,000.00 1,000.00 .0 01-30-60020 ON-CALL/STANDBY PAY 1,600.00 4,550.00 10,000.00 5,450.00 45.5 01-30-60071 STATE UNEMPLOYMENT TAXES 247.74 764.21 2,300.00 1,535.79 33.2 01-30-60080 HEALTH & DENTAL INSURANCE 20,657.63 53,951.03 166,912.00 112,960.97 32.3 01-30-60085 LIFE & DISABILITY INSURANCE 1,386.10 3,634.76 9,258.00 5,623.24 39.3 01-30-60092 EMPLOYER'S 457 2,884.44 8,990.47 38,325.00 29,334.53 23.5 01-30-60093 EMPLOYER'S FICA 4,778.79 14,845.08 47,523.00 32,677.92 31.2 01-30-60094 EMPLOYER'S MEDICARE 1,117.62 3,471.83 11,114.00 7,642.17 31.2 01-30-60095 PAYROLL & BANK FEES 59.16 236.64 625.00 388.36 37.9 01-30-60098 STAFF TUITITION .00 259.73 3,500.00 3,240.27 7.4 01-30-60100 WORKMANS COMP INS DEDUCTIBLE .00 601.52 500.00 ( 101.52) 120.3 01-30-60130 GENERAL INSURANCE DEDUCTIBLE .00 5,134.00 .00 ( 5,134.00) .0 01-30-60135 DRUG/ALCOHOL TESTING 166.40 266.40 1,000.00 733.60 26.6 01-30-60200 SAFETY EQUIPMENT 1,473.46 3,112.23 6,000.00 2,887.77 51.9 01-30-60210 UNIFORMS 348.68 1,193.49 4,300.00 3,106.51 27.8 01-30-60229 SUPPLIES - SHOP OPERATIONS 297.37 1,539.21 7,500.00 5,960.79 20.5 01-30-60231 SUPPLIES-OPERATIONS 352.77 1,617.15 8,000.00 6,382.85 20.2 01-30-60233 SUMMER YOUTH PROGRAM EXPENSES .00 .00 25,000.00 25,000.00 .0 01-30-60245 STORAGE UNIT #724 .00 .00 1,300.00 1,300.00 .0 01-30-60260 DUES AND SUBSCRIPTIONS 15.00 240.00 2,000.00 1,760.00 12.0 01-30-60300 PUBLIC/LEGAL NOTICES .00 .00 500.00 500.00 .0 01-30-60341 UTILITIES - ELECTRIC 448.38 10,850.76 32,800.00 21,949.24 33.1 01-30-60342 UTILITIES - GAS .00 1,951.85 7,300.00 5,348.15 26.7 01-30-60343 UTILITIES - SANITATION 140.00 455.00 2,000.00 1,545.00 22.8 01-30-60345 UTILITIES - TELEPHONE 935.32 3,667.59 12,000.00 8,332.41 30.6 01-30-60350 UTILITIES - TRASH PICKUP 350.00 1,485.50 4,500.00 3,014.50 33.0 01-30-60385 SMALL TOOLS 83.88 514.52 2,500.00 1,985.48 20.6 01-30-60386 SHOP TOOLS .00 73.00 3,000.00 2,927.00 2.4 01-30-60387 SALT/SAND .00 4,161.94 15,000.00 10,838.06 27.8 01-30-60610 FUEL 2,255.28 5,737.97 22,000.00 16,262.03 26.1 01-30-60770 TRAVEL,TRAINING,MEETINGS ( 425.00) 2,503.58 8,000.00 5,496.42 31.3 01-30-61085 PURCHASED SERVICES - PORT-A-LE 435.00 1,740.00 9,000.00 7,260.00 19.3 01-30-62000 REPAIR & MAINTENANCE - PARKS 998.89 16,825.62 70,000.00 53,174.38 24.0 01-30-65375 RENTAL MACHINERY & EQUIPMENT 41.44 2,044.55 3,000.00 955.45 68.2 01-30-65387 GPS TRACKING .00 2,038.70 .00 ( 2,038.70) .0 01-30-65390 REPAIR & MAINTENANCE - VEHICLE 3,894.05 17,111.68 50,000.00 32,888.32 34.2 01-30-65395 REPAIR & MAINTENANCE - EQUIPME 2,384.32 10,902.32 50,000.00 39,097.68 21.8 01-30-65396 MOSQUITO CONTROL PROGRAM .00 .00 11,800.00 11,800.00 .0 01-30-65399 CURB, GUTTER AND SIDEWALKS .00 .00 35,000.00 35,000.00 .0 01-30-65400 REPAIR & MAINT - STREETS 419.71 1,625.59 30,000.00 28,374.41 5.4 01-30-65450 REPAIRS & MAINTENANCE - BUILDI 1,080.08 3,699.92 17,500.00 13,800.08 21.1 01-30-65451 OLD TOWN HALL ROOF REPAIRS .00 6,402.60 23,000.00 16,597.40 27.8 01-30-65695 REPAIRS & MAINTENANCE - CEMTRY .00 2,118.46 2,500.00 381.54 84.7 01-30-65710 PROFESSIONAL SERVICES 700.00 1,085.00 6,000.00 4,915.00 18.1 01-30-65730 CEMETERY MEMORIAL DAY EVENT .00 .00 500.00 500.00 .0 01-30-66002 ASPHALT REPAIRS 647.83 647.83 250,000.00 249,352.17 .3 01-30-66061 DIRTY WOMAN PARK BLEACHERS .00 .00 6,000.00 6,000.00 .0 01-30-66071 PORTABLE TOWER LIGHTS .00 .00 10,000.00 10,000.00 .0 01-30-66072 HEAVY EQUIPMENT TIRES .00 .00 12,000.00 12,000.00 .0 01-30-66073 SHOULDERING ATTACHMENT .00 .00 9,500.00 9,500.00 .0 01-30-66078 LAVALETT 8' 4 SEAT SWING .00 .00 1,500.00 1,500.00 .0 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 7 01-30-66079 LIMBACH - 8' 4 SEAT SWING .00 .00 1,500.00 1,500.00 .0 01-30-66080 LIMBACH - 8' MERRY GO ROUND .00 .00 2,800.00 2,800.00 .0 01-30-66081 LIMBACH - 8' SLIDE .00 .00 7,000.00 7,000.00 .0 01-30-66082 WALK BEHIND AERATOR 19" 2,399.16 2,399.16 3,100.00 700.84 77.4 01-30-66083 WALK BEHIND SOD CUTTER 18" .00 .00 4,500.00 4,500.00 .0 01-30-66084 BRUSH CUTTER .00 .00 4,975.00 4,975.00 .0 01-30-66085 HEAVY DUTY SHELVES .00 .00 3,500.00 3,500.00 .0 01-30-66086 AIR COMPRESSOR FOR FACILITIES .00 .00 2,000.00 2,000.00 .0 01-30-66087 AC RECOVERY UNIT .00 .00 4,000.00 4,000.00 .0 01-30-68357 CONSERVATION PLAN REBATES .00 .00 2,000.00 2,000.00 .0 TOTAL PUBLIC WORKS 131,350.68 447,878.24 1,879,940.00 1,432,061.76 23.8 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 8 ADMINISTRATIVE AND LEGISLATIVE 01-45-60000 SALARIES 76,706.15 224,442.75 628,199.00 403,756.25 35.7 01-45-60010 OVERTIME PAY 2,410.42 4,504.42 10,000.00 5,495.58 45.0 01-45-60011 TM EMPLOYEE PFP POOL .00 .00 25,800.00 25,800.00 .0 01-45-60020 LONGEVITY RECOGNITION .00 .00 1,500.00 1,500.00 .0 01-45-60071 STATE UNEMPLOYMENT TAXES 237.32 686.64 1,990.00 1,303.36 34.5 01-45-60080 HEALTH & DENTAL INSURANCE 17,035.01 42,029.00 127,708.00 85,679.00 32.9 01-45-60085 LIFE & DISABILITY INSURANCE 1,290.75 3,199.47 8,472.00 5,272.53 37.8 01-45-60090 STAFF APPRECIATION 54.19 54.19 2,500.00 2,445.81 2.2 01-45-60092 EMPLOYER'S 457 3,531.20 10,206.58 33,160.00 22,953.42 30.8 01-45-60093 EMPLOYER'S FICA 4,570.65 13,182.98 41,118.00 27,935.02 32.1 01-45-60094 EMPLOYER'S MEDICARE 1,068.97 3,083.19 9,617.00 6,533.81 32.1 01-45-60095 BANK & PAYROLL FEES 1,904.41 4,259.90 8,000.00 3,740.10 53.3 01-45-60098 STAFF TUITION .00 .00 3,000.00 3,000.00 .0 01-45-60100 WORKERS COMPENSATION INSURANCE 5,579.98 22,319.92 75,000.00 52,680.08 29.8 01-45-60130 GENERAL INSURANCE 6,689.11 26,785.44 100,000.00 73,214.56 26.8 01-45-60133 2018 WAGE STUDY .00 .00 25,000.00 25,000.00 .0 01-45-60145 CONTRACT LABOR-JANITORIAL 901.25 3,605.00 10,000.00 6,395.00 36.1 01-45-60230 SUPPLIES - OFFICE/OPERATIONS 856.16 2,321.65 10,000.00 7,678.35 23.2 01-45-60231 FURNITURE, FIXTURES & EQUIP .00 .00 2,500.00 2,500.00 .0 01-45-60240 POSTAGE 404.84 827.82 5,000.00 4,172.18 16.6 01-45-60245 STORAGE UNIT-ADMINISTRATION 108.00 774.00 1,800.00 1,026.00 43.0 01-45-60254 ELECTION EXPENSE 1,570.29 1,779.93 15,000.00 13,220.07 11.9 01-45-60260 DUES AND SUBSCRIPTIONS 1,116.02 6,272.89 20,000.00 13,727.11 31.4 01-45-60300 PUBLIC/LEGAL NOTICES 63.00 63.00 1,000.00 937.00 6.3 01-45-60305 LEGAL SERVICES 273.00 673.00 40,000.00 39,327.00 1.7 01-45-60341 UTILITIES - ELECTRIC .00 2,800.25 10,850.00 8,049.75 25.8 01-45-60342 UTILITIES - GAS .00 1,567.35 4,500.00 2,932.65 34.8 01-45-60343 UTILITIES - SANITATION 52.71 175.86 1,000.00 824.14 17.6 01-45-60345 UTILITIES - TELEPHONE 1,145.84 5,838.82 17,000.00 11,161.18 34.4 01-45-60350 UTILITIES - TRASH PICKUP .00 130.00 650.00 520.00 20.0 01-45-60360 UTILITIES - WATER SERVICE USED 1,477.62 4,438.86 40,000.00 35,561.14 11.1 01-45-60430 TTM - BOARD OF TRUSTEES .00 1,819.62 2,500.00 680.38 72.8 01-45-60610 FUEL .00 .00 2,000.00 2,000.00 .0 01-45-60750 ACCOUNTING/AUDIT SERVICES .00 .00 9,000.00 9,000.00 .0 01-45-60770 TRAVEL,TRAINING & MEETINGS 2,754.41 8,900.29 30,000.00 21,099.71 29.7 01-45-60772 EMPLOYEE MILEAGE-TM 100.00 100.00 1,200.00 1,100.00 8.3 01-45-63000 TRIVIEW PROPERTY TAX PAYABLE .00 .00 243,115.00 243,115.00 .0 01-45-64000 TAX COLLECTION EXPENSE 2,904.90 11,314.56 30,000.00 18,685.44 37.7 01-45-65660 REPAIR & MAINTENANCE - COMPUTE 6,227.00 21,904.00 65,000.00 43,096.00 33.7 01-45-65661 COMPUTER LICENSES & SOFTWARE 1,650.00 5,434.00 25,000.00 19,566.00 21.7 01-45-65662 WEBMASTER MAINTENANCE 241.25 241.25 8,000.00 7,758.75 3.0 01-45-65665 REPAIR & MAINTENANCE - COPIER 949.31 6,383.83 9,000.00 2,616.17 70.9 01-45-65710 PROFESSIONAL CONSULTING 1,811.00 8,096.50 20,000.00 11,903.50 40.5 01-45-65711 EDC & COMMUNITY DEVELOPMENT .00 .00 5,000.00 5,000.00 .0 01-45-65712 PURCHASED SERVICES - ANIMAL CO 1,362.75 5,451.00 20,000.00 14,549.00 27.3 01-45-65883 TRI-LAKES CARES .00 .00 5,000.00 5,000.00 .0 01-45-65885 TRI LAKES VIEWS 5,000.00 5,000.00 5,000.00 .00 100.0 01-45-65996 CONTINGENCY .00 .00 5,000.00 5,000.00 .0 01-45-65998 TRI-LAKES SILVER ALLIANCE .00 12,000.00 12,000.00 .00 100.0 01-45-68355 CAPITAL LEASE PRINCIPAL ( 241.12) ( 241.12) .00 241.12 .0 01-45-68356 CAPITAL LEASE INTEREST ( 38.96) ( 38.96) .00 38.96 .0 TOTAL ADMINISTRATIVE AND LEGISLATIVE 151,767.43 472,387.88 1,777,179.00 1,304,791.12 26.6 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 9 COURT 01-46-60000 SALARIES 3,280.33 13,121.32 39,634.00 26,512.68 33.1 01-46-60010 OVERTIME PAY 100.00 400.00 1,200.00 800.00 33.3 01-46-60071 STATE UNEMPLOYMENT TAXES 12.92 51.68 155.00 103.32 33.3 01-46-60080 HEALTH & DENTAL INSURANCE 745.83 2,983.32 8,950.00 5,966.68 33.3 01-46-60085 LIFE & DISABILITY INSURANCE 50.00 200.00 600.00 400.00 33.3 01-46-60092 EMPLOYER'S 457 215.17 860.68 2,582.00 1,721.32 33.3 01-46-60093 EMPLOYER'S FICA 266.75 1,067.00 3,201.00 2,134.00 33.3 01-46-60094 EMPLOYER'S MEDICARE 62.42 249.68 749.00 499.32 33.3 01-46-60230 SUPPLIES - OFFICE/OPERATIONS .00 78.22 100.00 21.78 78.2 01-46-60240 POSTAGE .00 .00 100.00 100.00 .0 01-46-65701 WARRANT/JAIL COST .00 .00 100.00 100.00 .0 01-46-65715 MUNICIPAL COURT JUDGE 500.00 2,000.00 6,000.00 4,000.00 33.3 01-46-65717 PROSECUTING ATTORNEY 1,000.00 4,000.00 12,000.00 8,000.00 33.3 TOTAL COURT 6,233.42 25,011.90 75,371.00 50,359.10 33.2 PLANNING DEPARTMENT 01-49-60000 SALARIES 33,071.37 99,140.46 282,089.00 182,948.54 35.2 01-49-60010 OVERTIME PAY 1,067.19 2,020.50 3,500.00 1,479.50 57.7 01-49-60071 STATE UNEMPLOYMENT TAXES 102.41 303.46 846.00 542.54 35.9 01-49-60080 HEALTH & DENTAL INSURANCE 7,419.84 18,268.80 53,529.00 35,260.20 34.1 01-49-60085 LIFE & DISABILITY INSURANCE 592.80 1,457.70 3,535.00 2,077.30 41.2 01-49-60092 EMPLOYER'S 457 1,706.92 5,058.02 14,104.00 9,045.98 35.9 01-49-60093 EMPLOYER'S FICA 1,876.71 5,550.56 17,490.00 11,939.44 31.7 01-49-60094 EMPLOYER'S MEDICARE 438.90 1,298.10 4,090.00 2,791.90 31.7 01-49-60095 PAYROLL & BANK FEES 34.11 136.44 500.00 363.56 27.3 01-49-60098 STAFF TUITITION .00 .00 1,000.00 1,000.00 .0 01-49-60099 CODE ENFORCEMENT CONTRACT 2,653.46 3,965.46 19,000.00 15,034.54 20.9 01-49-60230 SUPPLIES - OFFICE/OPERATIONAL 80.38 1,013.87 2,300.00 1,286.13 44.1 01-49-60237 COPIES AND PHOTOS .25 .25 200.00 199.75 .1 01-49-60240 POSTAGE .00 32.92 200.00 167.08 16.5 01-49-60245 STORAGE UNIT RENTAL FEES .00 450.00 1,800.00 1,350.00 25.0 01-49-60260 DUES AND SUBSCRIPTIONS .00 450.00 1,500.00 1,050.00 30.0 01-49-60300 PUBLIC/LEGAL NOTICES .00 .00 750.00 750.00 .0 01-49-60305 LEGAL SERVICES 14.40 14.40 10,000.00 9,985.60 .1 01-49-60345 UTILITIES - TELEPHONE 186.22 1,046.97 5,000.00 3,953.03 20.9 01-49-60610 FUEL 195.37 431.83 2,000.00 1,568.17 21.6 01-49-60770 TRAVEL,TRAINING & MEETINGS 1,522.95 2,681.42 9,000.00 6,318.58 29.8 01-49-65710 PROFESSIONAL SERVICES 50.00 150.00 15,000.00 14,850.00 1.0 01-49-65711 GIS SERVICES 208.07 1,443.41 2,000.00 556.59 72.2 01-49-68355 CAPITAL LEASE FOR PLOTTER ( 355.32) 3,532.50 7,200.00 3,667.50 49.1 01-49-68356 CAPITAL LEASE INTEREST .00 116.91 2,000.00 1,883.09 5.9 TOTAL PLANNING DEPARTMENT 50,866.03 148,563.98 458,633.00 310,069.02 32.4 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 10 LAW ENFORCEMENT 01-51-60000 SALARIES 133,955.97 390,343.33 1,188,131.00 797,787.67 32.9 01-51-60010 OVERTIME PAY 11,185.45 29,942.14 25,000.00 ( 4,942.14) 119.8 01-51-60020 LONGEVITY RECOGNITION .00 .00 2,000.00 2,000.00 .0 01-51-60071 STATE UNEMPLOYMENT TAXES 432.65 1,256.10 3,564.00 2,307.90 35.2 01-51-60080 HEALTH & DENTAL INSURANCE 28,226.45 67,394.60 208,257.00 140,862.40 32.4 01-51-60084 FPPA FOR D&D .00 .00 25,745.00 25,745.00 .0 01-51-60085 LIFE & DISABILITY INSURANCE 2,302.27 5,479.11 3,496.00 ( 1,983.11) 156.7 01-51-60091 FPPA FOR RETIREMENT .00 .00 38,023.00 38,023.00 .0 01-51-60092 EMPLOYER'S 457 6,859.02 20,391.81 16,178.00 ( 4,213.81) 126.1 01-51-60093 EMPLOYER'S FICA 8,291.49 24,131.36 73,664.00 49,532.64 32.8 01-51-60094 EMPLOYER'S MEDICARE 1,939.08 5,643.47 17,228.00 11,584.53 32.8 01-51-60095 PAYROLL & BANK FEES 59.17 236.68 650.00 413.32 36.4 01-51-60098 STAFF TUITITION .00 .00 2,000.00 2,000.00 .0 01-51-60100 WORKERS COMPENSATION INSURANCE .00 1,438.64 1,500.00 61.36 95.9 01-51-60135 DRUG/ALCOHOL TESTING 287.12 903.51 3,000.00 2,096.49 30.1 01-51-60145 CONTRACT LABOR JANITORIAL SVC 901.25 3,605.00 10,000.00 6,395.00 36.1 01-51-60147 COLORADO MOUNTED RANGERS .00 .00 1,500.00 1,500.00 .0 01-51-60210 UNIFORMS 2,077.60 6,322.80 9,500.00 3,177.20 66.6 01-51-60230 SUPPLIES - OFFICE 251.95 1,845.83 7,000.00 5,154.17 26.4 01-51-60231 SUPPLIES-OPERATIONS 33.00 3,096.59 4,900.00 1,803.41 63.2 01-51-60233 EMERGENCY NETWORK FEE 572.00 1,430.00 2,500.00 1,070.00 57.2 01-51-60234 SUPPLIES-AMMUNITION 856.15 6,588.16 6,500.00 ( 88.16) 101.4 01-51-60240 POSTAGE 36.71 247.11 400.00 152.89 61.8 01-51-60260 DUES AND SUBSCRIPTIONS 154.30 715.55 3,500.00 2,784.45 20.4 01-51-60270 CIRSA/LEXIPOL POLICY M & T 5,108.00 5,108.00 5,200.00 92.00 98.2 01-51-60300 PUBLIC/LEGAL NOTICES .00 .00 200.00 200.00 .0 01-51-60305 LEGAL SERVICES .00 .00 250.00 250.00 .0 01-51-60341 UTILITIES - ELECTRIC .00 1,968.34 7,600.00 5,631.66 25.9 01-51-60342 UTILITIES - GAS .00 1,083.92 2,500.00 1,416.08 43.4 01-51-60343 UTILITIES - SANITATION 17.72 70.86 600.00 529.14 11.8 01-51-60345 UTILITIES - TELEPHONE 994.01 4,855.80 22,000.00 17,144.20 22.1 01-51-60350 UTILITIES - TRASH PICKUP .00 130.00 550.00 420.00 23.6 01-51-60610 FUEL 2,827.33 6,862.98 18,000.00 11,137.02 38.1 01-51-60770 TRAVEL, TRAINING & MEETINGS ( 788.56) 1,629.50 12,000.00 10,370.50 13.6 01-51-65380 TACTICAL EQUIPMENT .00 25.00 12,000.00 11,975.00 .2 01-51-65381 TASER CAMERA CLOUD STORAGE .00 .00 4,781.00 4,781.00 .0 01-51-65383 MDC AIRTIME 369.19 1,312.43 3,300.00 1,987.57 39.8 01-51-65384 INTELLICHOICE ANNUAL LICENSE .00 3,972.52 4,000.00 27.48 99.3 01-51-65385 RADIO U & U MANDATORY .00 880.00 8,630.00 7,750.00 10.2 01-51-65387 GPS TRACKING .00 2,389.24 .00 ( 2,389.24) .0 01-51-65660 REPAIR & MAINTENANCE - COMPUTE 270.00 1,579.00 .00 ( 1,579.00) .0 01-51-65665 REPAIR & MAINTENANCE - COPIER 649.17 2,846.67 3,000.00 153.33 94.9 01-51-66002 BODY WORN CAMERA EQUIPMENT 1,756.48 1,756.48 5,500.00 3,743.52 31.9 TOTAL LAW ENFORCEMENT 209,624.97 607,482.53 1,764,347.00 1,156,864.47 34.4 TOTAL FUND EXPENDITURES 549,842.53 1,701,324.53 5,955,470.00 4,254,145.47 28.6 NET REVENUE OVER EXPENDITURES ( 96,347.62) 222,250.25 ( 461,854.00) ( 684,104.25) 48.1 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET APRIL 30, 2018 CAPITAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 11 ASSETS 02-00-10100 CASH IN COMBINED CASH FUND 78,705.65 TOTAL ASSETS 78,705.65 LIABILITIES AND EQUITY FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 78,705.65 BALANCE - CURRENT DATE 78,705.65 TOTAL FUND EQUITY 78,705.65 TOTAL LIABILITIES AND EQUITY 78,705.65 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 12 DEPARTMENT 02 02-02-40120 CIP SALES TAX REVENUJE WATER 28,750.00 115,000.00 345,000.00 230,000.00 33.3 02-02-40121 CIP SALES TAX REVENUE GF 32,437.50 129,750.00 389,250.00 259,500.00 33.3 02-02-48085 GRANT GOCO LIMBACH PARK .00 .00 350,000.00 350,000.00 .0 02-02-48086 GRANT-PPACG FOR SIDEWALK .00 .00 40,000.00 40,000.00 .0 02-02-49000 CIP OTHER FINANCING WATER .00 .00 1,549,500.00 1,549,500.00 .0 02-02-49001 CIP OTHER FINANCING GF .00 .00 89,050.00 89,050.00 .0 TOTAL DEPARTMENT 02 61,187.50 244,750.00 2,762,800.00 2,518,050.00 8.9 TOTAL FUND REVENUE 61,187.50 244,750.00 2,762,800.00 2,518,050.00 8.9 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 13 02-02-66045 WELL 4 & 5 TREATMENT PLANT 154,588.73 154,588.73 924,500.00 769,911.27 16.7 02-02-66052 RASP LANE CHLORINE STATIONS .00 .00 20,000.00 20,000.00 .0 02-02-66054 RASP LANE DISTRIBUTION LINE .00 .00 75,000.00 75,000.00 .0 02-02-66055 WTP #7 MOV CHANGE .00 .00 100,000.00 100,000.00 .0 02-02-66056 WELL #4 & #5 BUILDING REHAB .00 .00 150,000.00 150,000.00 .0 02-02-66057 BOOSTER STATION UPGRADE .00 .00 625,000.00 625,000.00 .0 02-02-66076 SOLAR LIGHTS LIMBACH PARK .00 .00 50,000.00 50,000.00 .0 02-02-66077 WATER FOUNTAINS PARKS .00 .00 30,000.00 30,000.00 .0 02-02-66079 SPLASH PARK AT LIMBACH PARK .00 .00 600,000.00 600,000.00 .0 02-02-66080 TURF TRACTOR .00 .00 25,000.00 25,000.00 .0 02-02-66081 BEACON LITE SIDEWALK 5,727.81 11,455.62 38,000.00 26,544.38 30.2 02-02-66082 POUR & PLAY TOT LOT LIMBACH .00 .00 36,250.00 36,250.00 .0 02-02-68355 GENERAL FUND CAPITAL LEASES .00 .00 89,050.00 89,050.00 .0 TOTAL DEPARTMENT 02 160,316.54 166,044.35 2,762,800.00 2,596,755.65 6.0 TOTAL FUND EXPENDITURES 160,316.54 166,044.35 2,762,800.00 2,596,755.65 6.0 NET REVENUE OVER EXPENDITURES ( 99,129.04) 78,705.65 .00 ( 78,705.65) .0 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET APRIL 30, 2018 2A WATER ASD FUND FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 14 ASSETS 04-00-10100 CASH IN COMBINED CASH FUND 572,127.69 04-00-10425 COLOTRUST WATER ASD FUND ACCT 1,366,640.69 TOTAL ASSETS 1,938,768.38 LIABILITIES AND EQUITY FUND EQUITY 04-00-30000 BEGINNING FUND BALANCE - 2A W 1,781,913.29 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 156,855.09 BALANCE - CURRENT DATE 156,855.09 TOTAL FUND EQUITY 1,938,768.38 TOTAL LIABILITIES AND EQUITY 1,938,768.38 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 2A WATER ASD FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 15 04-04-40060 INTEREST INCOME 2A WATER ASD 1,888.45 6,192.53 7,590.00 1,397.47 81.6 04-04-40750 SALES TAX - 2A WATER ASD FUND 57,463.89 176,618.60 788,603.00 611,984.40 22.4 TOTAL DEPARTMENT 04 59,352.34 182,811.13 796,193.00 613,381.87 23.0 TOTAL FUND REVENUE 59,352.34 182,811.13 796,193.00 613,381.87 23.0 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 2A WATER ASD FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 16 04-04-60305 LEGAL SERVICES 292.08 2,321.04 10,275.00 7,953.96 22.6 04-04-62000 PROFESSIONAL SERVICES - LYTLE .00 1,030.00 35,591.00 34,561.00 2.9 04-04-62003 PROFESSIONAL SERVICES OTHER .00 .00 20,177.00 20,177.00 .0 04-04-66004 NEW WATER TANK & TRANSMISSION .00 11,737.53 2,250,280.00 2,238,542.47 .5 04-04-66008 RFWM PHASE I-SAMPLING .00 3,471.00 50,300.00 46,829.00 6.9 04-04-66009 CONNECT HUGH'S WELL AT LOR .00 .00 65,000.00 65,000.00 .0 04-04-66010 AREA 3 RESERVIOR (HPR) .00 .00 200,000.00 200,000.00 .0 04-04-66021 TRANSIT LOSS .00 7,396.47 8,500.00 1,103.53 87.0 TOTAL DEPARTMENT 04 292.08 25,956.04 2,640,123.00 2,614,166.96 1.0 TOTAL FUND EXPENDITURES 292.08 25,956.04 2,640,123.00 2,614,166.96 1.0 NET REVENUE OVER EXPENDITURES 59,060.26 156,855.09 ( 1,843,930.00) ( 2,000,785.09) 8.5 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET APRIL 30, 2018 DEBT SERVICE FUND FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 17 ASSETS 05-00-10100 CASH IN COMBINED CASH FUND 94,974.20 TOTAL ASSETS 94,974.20 LIABILITIES AND EQUITY FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 94,974.20 BALANCE - CURRENT DATE 94,974.20 TOTAL FUND EQUITY 94,974.20 TOTAL LIABILITIES AND EQUITY 94,974.20 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 DEBT SERVICE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 18 DEBT SERVICE FUND 05-05-40750 SALES TAX WEF - DEBT SVC 12,755.17 51,020.68 153,062.00 102,041.32 33.3 05-05-40751 SALES TAX GENERAL FUND DEBT 12,178.75 48,715.00 146,145.00 97,430.00 33.3 TOTAL DEBT SERVICE FUND 24,933.92 99,735.68 299,207.00 199,471.32 33.3 TOTAL FUND REVENUE 24,933.92 99,735.68 299,207.00 199,471.32 33.3 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 DEBT SERVICE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 19 DEBT SERVICE FUND 05-05-68330 WF CL SERIES 2016 #403-P .00 .00 21,077.00 21,077.00 .0 05-05-68331 WEF CL SERIES 2016 #403-I .00 .00 447.00 447.00 .0 05-05-68332 WEF CL SERIES 2016 #404-P .00 .00 49,247.00 49,247.00 .0 05-05-68333 WEF CL SERIES 2016 #404-I .00 .00 4,816.00 4,816.00 .0 05-05-68349 2018 LOAN PRINCIPAL .00 .00 77,475.00 77,475.00 .0 05-05-68350 GENERAL FUND CL SERIES #403-P .00 .00 46,914.00 46,914.00 .0 05-05-68351 GF CL SERIES 2016 #403-I .00 .00 995.00 995.00 .0 05-05-68352 GF CL SERIES #404-P .00 .00 10,087.00 10,087.00 .0 05-05-68353 GF CL SERIES 2016 #404-I .00 .00 987.00 987.00 .0 05-05-68354 GF CL SERIES 2017 #405-P .00 .00 44,681.00 44,681.00 .0 05-05-68355 GF CL SERIES 2017 #405-I .00 .00 5,008.00 5,008.00 .0 05-05-68356 GF CL VAR SERVER LEASE-P 280.08 4,254.90 7,790.00 3,535.10 54.6 05-05-68357 GF CL VAR SERVER LEASE -I .00 506.58 .00 ( 506.58) .0 05-05-68358 GF CL SERIES 2018 #406-P .00 .00 29,683.00 29,683.00 .0 TOTAL DEBT SERVICE FUND 280.08 4,761.48 299,207.00 294,445.52 1.6 TOTAL FUND EXPENDITURES 280.08 4,761.48 299,207.00 294,445.52 1.6 NET REVENUE OVER EXPENDITURES 24,653.84 94,974.20 .00 ( 94,974.20) .0 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET APRIL 30, 2018 COMMUNITY DEVELOPMENT FUND FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 20 ASSETS 31-00-10100 CASH IN COMBINED CASH FUND ( 9,686.07) 31-00-10428 COLOTRUST COMMUNITY DEV FND 31,494.57 TOTAL ASSETS 21,808.50 LIABILITIES AND EQUITY FUND EQUITY 31-00-30000 BEGINNING FUND BALANCE - COMMU 25,451.14 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 3,642.64) BALANCE - CURRENT DATE ( 3,642.64) TOTAL FUND EQUITY 21,808.50 TOTAL LIABILITIES AND EQUITY 21,808.50 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 COMMUNITY DEVELOPMENT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 21 COMMMUNITY DEVELOPMENT FUND 31-02-40060 INTEREST AND INVESTMENT INCOME 72.01 259.11 450.00 190.89 57.6 31-02-40065 TRANSFER FROM GENERAL FUND .00 .00 20,000.00 20,000.00 .0 31-02-40220 BUSINESS LICENSES-COMMUNITY DE 5,715.00 22,149.45 63,750.00 41,600.55 34.7 31-02-40225 SPONSORSHIP REVENUE 500.00 500.00 3,000.00 2,500.00 16.7 TOTAL COMMMUNITY DEVELOPMENT FUN 6,287.01 22,908.56 87,200.00 64,291.44 26.3 TOTAL FUND REVENUE 6,287.01 22,908.56 87,200.00 64,291.44 26.3 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 COMMUNITY DEVELOPMENT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 22 COMMMUNITY DEVELOPMENT FUND 31-02-60230 SUPPLIES - OFFICE/OPERATIONS 81.49 444.70 1,000.00 555.30 44.5 31-02-60260 DUES AND SUBSCRIPTIONS 185.00 220.00 1,000.00 780.00 22.0 31-02-60770 TRAVEL,TRAINING, MEETINGS 341.53 899.60 2,000.00 1,100.40 45.0 31-02-65371 BROCHURE DEVELOPMENT .00 .00 5,000.00 5,000.00 .0 31-02-65372 BROCHURE DISTRIBUTION 424.90 424.90 10,000.00 9,575.10 4.3 31-02-65373 SOCIAL MEDIA ARCHIVING .00 .00 3,000.00 3,000.00 .0 31-02-65374 ADVERTISING .00 900.00 4,000.00 3,100.00 22.5 31-02-66000 CAPITAL PROJECTS-TBD .00 8,067.00 9,678.00 1,611.00 83.4 31-02-66006 CDF GRANTS - DOWNTOWN .00 .00 5,000.00 5,000.00 .0 31-02-66007 CDF GRANTS - HIGHWAY 105 .00 250.00 1,500.00 1,250.00 16.7 31-02-66008 CDF GRANTS - JCP & CIPRIANI .00 .00 1,500.00 1,500.00 .0 31-02-66009 CDF GRANTS - MGMT DISCRETION .00 .00 5,000.00 5,000.00 .0 31-02-66012 EVENTS, MEETINGS, TRAINING .00 .00 2,000.00 2,000.00 .0 31-02-66013 TRI LAKES CHAMBER SPONSORSHIP .00 .00 20,000.00 20,000.00 .0 31-02-66015 MOVIE EQUIPMENT PURCHASE .00 15,345.00 19,775.00 4,430.00 77.6 31-02-66016 FACADE MURAL GRANT .00 .00 5,000.00 5,000.00 .0 31-02-66018 BINES AND BREWS .00 .00 3,000.00 3,000.00 .0 31-02-66020 FOURTH OF JULY EVENTS .00 .00 8,000.00 8,000.00 .0 31-02-66021 MOVIE NIGHTS .00 .00 3,600.00 3,600.00 .0 31-02-66022 MEMORIAL DAY .00 .00 500.00 500.00 .0 31-02-66031 CLEAN UP EVENTS .00 .00 1,000.00 1,000.00 .0 31-02-66032 PICKIN' ON THE DIVIDE .00 .00 1,225.00 1,225.00 .0 TOTAL COMMMUNITY DEVELOPMENT FUN 1,032.92 26,551.20 112,778.00 86,226.80 23.5 TOTAL FUND EXPENDITURES 1,032.92 26,551.20 112,778.00 86,226.80 23.5 NET REVENUE OVER EXPENDITURES 5,254.09 ( 3,642.64) ( 25,578.00) ( 21,935.36) ( 14.2) ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET APRIL 30, 2018 TRAFFIC IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 23 ASSETS 32-00-10100 CASH IN COMBINED CASH FUND 57,726.91 32-00-10427 COLOTRUST TRAFFIC IMPACT FEE F 143,981.78 TOTAL ASSETS 201,708.69 LIABILITIES AND EQUITY FUND EQUITY 32-00-30000 BEGINNING FUND BALANCE - TRAFF 176,295.33 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 25,413.36 BALANCE - CURRENT DATE 25,413.36 TOTAL FUND EQUITY 201,708.69 TOTAL LIABILITIES AND EQUITY 201,708.69 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 TRAFFIC IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 24 TRAFFIC IMPACT FEE FUND 32-10-40060 INTEREST INCOME 288.31 954.73 2,000.00 1,045.27 47.7 32-10-40460 TRAFFIC IMPACT FEES 707.00 13,146.63 50,000.00 36,853.37 26.3 32-10-40461 LOR SPECIAL IMPACT FEES PD 1,414.00 11,312.00 95,000.00 83,688.00 11.9 TOTAL TRAFFIC IMPACT FEE FUND 2,409.31 25,413.36 147,000.00 121,586.64 17.3 TOTAL FUND REVENUE 2,409.31 25,413.36 147,000.00 121,586.64 17.3 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 TRAFFIC IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 25 TRAFFIC IMPACT FEE FUND 32-10-65999 CAPITAL OUTLAY-TRAFFIC IMPACT .00 .00 327,329.00 327,329.00 .0 TOTAL TRAFFIC IMPACT FEE FUND .00 .00 327,329.00 327,329.00 .0 TOTAL FUND EXPENDITURES .00 .00 327,329.00 327,329.00 .0 NET REVENUE OVER EXPENDITURES 2,409.31 25,413.36 ( 180,329.00) ( 205,742.36) 14.1 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET APRIL 30, 2018 STORM DRAINAGE IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 26 ASSETS 35-00-10100 CASH IN COMBINED CASH FUND ( 222.82) 35-00-10429 COLOTRUST STORM DRAINAGE IMPAC 37,307.42 TOTAL ASSETS 37,084.60 LIABILITIES AND EQUITY FUND EQUITY 35-00-30000 BEGINNING FUND BALANCE - STORM 8,139.82 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 28,944.78 BALANCE - CURRENT DATE 28,944.78 TOTAL FUND EQUITY 37,084.60 TOTAL LIABILITIES AND EQUITY 37,084.60 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 STORM DRAINAGE IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 27 STORM DRAINAGE IMPACT FEE FUND 35-35-40060 INTEREST INCOME 32.83 101.11 100.00 ( 1.11) 101.1 35-35-41010 STORM DRAINAGE IMPACT FEES 148.67 26,399.54 40,000.00 13,600.46 66.0 35-35-41011 IMPACT FEES LOR 1,647.76 13,029.02 50,000.00 36,970.98 26.1 TOTAL STORM DRAINAGE IMPACT FEE FUN 1,829.26 39,529.67 90,100.00 50,570.33 43.9 TOTAL FUND REVENUE 1,829.26 39,529.67 90,100.00 50,570.33 43.9 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 STORM DRAINAGE IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 28 STORM DRAINAGE IMPACT FEE FUND 35-35-60770 TRAVEL, TRAINING AND MEETINGS .00 179.46 5,000.00 4,820.54 3.6 35-35-66000 STORMWATER DRAINAGE REPAIRS 4,100.13 10,405.43 112,945.00 102,539.57 9.2 TOTAL STORM DRAINAGE IMPACT FEE FUN 4,100.13 10,584.89 117,945.00 107,360.11 9.0 TOTAL FUND EXPENDITURES 4,100.13 10,584.89 117,945.00 107,360.11 9.0 NET REVENUE OVER EXPENDITURES ( 2,270.87) 28,944.78 ( 27,845.00) ( 56,789.78) 104.0 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET APRIL 30, 2018 WATER FUND FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 29 ASSETS 61-00-10100 CASH IN COMBINED CASH FUND 267,577.13 61-00-10230 WELLS FARGO-WATER DEPOSITS 20,600.00 61-00-10740 COLOTRUST WATER ENTERPRISE FUN 284,624.16 61-00-10745 COLOTRUST MLWS ESCROW 676,825.36 61-00-11750 UTILITY CASH CLEARING 11,195.29 61-00-14010 A/R-WATER 115,558.57 61-00-14500 WATER PAYMENT CONTRACTS REC ( 1,084.50) 61-00-15000 PREPAID EXPENSE 3,110.12 61-00-15001 PREPAID LOR WATER LINE LOOP 471,110.00 61-00-17800 WEF WATER RIGHTS 125,000.00 61-00-17801 WEF SOURCE OF SUP. ALLUVIUM WE 420,392.00 61-00-17802 WEF WATER TREATMENT PLANT 1,199,322.08 61-00-17803 WEF IRON TREATMENT PLANT 287,854.00 61-00-17804 WEF EQUIPMENT, F&F 1,222,596.59 61-00-17811 WEF SLABAUGH LINE 191,390.00 61-00-17814 WEF CIP-CONSTRUCTION OF DAM 2,781,510.11 61-00-17815 WELL #8 BOND ISSUANCE (WTR MP) 664,971.10 61-00-17817 WEF CAPITAL IMPROVEMENT-DAM 152,147.00 61-00-17818 WEF WELLS/TREATMENT 7,758,384.86 61-00-17820 WEF WELLS/TREATMENT 49,253.87 61-00-17821 WEF TRANSMISSION & DISTRIBUTIO 2,127,425.67 61-00-17822 WEF VEHICLES 384,291.90 61-00-17823 WEF BUILDINGS 118,897.00 61-00-19807 AD - WATER ENTERPRISE FUND EQU ( 9,831,858.40) TOTAL ASSETS 9,501,093.91 LIABILITIES AND EQUITY LIABILITIES 61-00-20225 WEF ACCRUED INTEREST 2,205.23 61-00-24300 ACCRUED VACATION & SICK LEAVE 33,583.94 61-00-25000 WATER METER DEPOSIT REFUNDS 20,300.00 61-00-28330 CAPITAL DEBT LEASES 177,131.39 TOTAL LIABILITIES 233,220.56 FUND EQUITY 61-00-30000 BEGINNING FUND BALANCE - WATER 3,581,380.20 61-00-30025 CONTRIBUTED CAPITAL-TAP FEE 2,137,183.00 61-00-30040 DEBT SERVICE FUND 2,037,528.26 61-00-30050 GRANTS 956,838.00 61-00-30060 WATER LINES 125,625.00 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 429,318.89 BALANCE - CURRENT DATE 429,318.89 TOTAL FUND EQUITY 9,267,873.35 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET APRIL 30, 2018 WATER FUND FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:38PM PAGE: 30 TOTAL LIABILITIES AND EQUITY 9,501,093.91 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:39PM PAGE: 31 61-15-40060 INTEREST AND INVESTMENT INCOME 1,456.84 5,103.46 9,944.00 4,840.54 51.3 61-15-46100 WATER REVENUE - RESIDENTIAL SA 49,273.76 208,701.40 918,352.00 709,650.60 22.7 61-15-46105 WATER REVENUE - COMMERCIAL SAL 50,145.80 163,089.07 670,479.00 507,389.93 24.3 61-15-46110 WATER REVENUE - BULK SALES 859.09 2,390.09 13,325.00 10,934.91 17.9 61-15-46111 LATE FEES 2,297.50 8,550.00 24,447.00 15,897.00 35.0 61-15-46115 SALES TAX-WATER FUND 9,883.13 70,437.52 192,992.00 122,554.48 36.5 61-15-48078 LOR WATER TAP IMPACT FEES 35,640.00 205,420.00 225,000.00 19,580.00 91.3 61-15-48080 WATER REVENUE - IMPACT FEES .00 126,520.00 90,000.00 ( 36,520.00) 140.6 61-15-48081 WATER METER IMPACT FEES 940.00 19,987.00 15,050.00 ( 4,937.00) 132.8 TOTAL DEPARTMENT 15 150,496.12 810,198.54 2,159,589.00 1,349,390.46 37.5 TOTAL FUND REVENUE 150,496.12 810,198.54 2,159,589.00 1,349,390.46 37.5 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:39PM PAGE: 32 61-15-60000 SALARIES 52,989.23 150,746.28 519,792.00 369,045.72 29.0 61-15-60010 OVERTIME PAY 64.25 1,971.28 10,000.00 8,028.72 19.7 61-15-60019 LONGEVITY RECOGNITION .00 .00 500.00 500.00 .0 61-15-60020 ON-CALL/STANDBY PAY 700.00 2,900.00 11,500.00 8,600.00 25.2 61-15-60071 STATE UNEMPLOYMENT TAXES 161.25 466.63 1,559.00 1,092.37 29.9 61-15-60080 HEALTH & DENTAL INSURANCE 14,882.48 35,820.35 117,362.00 81,541.65 30.5 61-15-60085 LIFE & DISABILITY INSURANCE 921.56 2,220.50 6,389.00 4,168.50 34.8 61-15-60092 EMPLOYER'S 457 2,373.40 6,797.72 25,990.00 19,192.28 26.2 61-15-60093 EMPLOYER'S FICA 2,999.34 8,660.66 32,227.00 23,566.34 26.9 61-15-60094 EMPLOYER'S MEDICARE 701.44 2,025.43 7,537.00 5,511.57 26.9 61-15-60095 BANK FEES FOR PSN PAYMENTS 119.95 1,012.11 .00 ( 1,012.11) .0 61-15-60096 PAYROLL & BANK FEES 59.17 236.68 850.00 613.32 27.8 61-15-60098 STAFFTUITION .00 150.00 3,000.00 2,850.00 5.0 61-15-60099 ADMIN FEE TO GENERAL FUND 5,803.75 23,215.00 72,195.00 48,980.00 32.2 61-15-60100 WORKERS COMPENSATION INSURANCE 2,748.35 11,493.40 24,985.00 13,491.60 46.0 61-15-60125 PAYMENT IN LIEU OF 5% FF 8,594.47 34,377.88 103,136.00 68,758.12 33.3 61-15-60130 GENERAL INSURANCE 3,294.64 13,178.56 29,618.00 16,439.44 44.5 61-15-60135 DRUG/ALCOHOL TESTING 35.00 431.40 800.00 368.60 53.9 61-15-60200 SAFETY EQUIPMENT 645.94 1,885.67 3,000.00 1,114.33 62.9 61-15-60210 UNIFORMS 46.00 577.31 2,700.00 2,122.69 21.4 61-15-60220 SMALL TOOLS .00 29.78 500.00 470.22 6.0 61-15-60229 SUPPLIES-SHOP OPERATIONS 241.00 652.25 1,800.00 1,147.75 36.2 61-15-60231 SUPPLIES-OPERATIONS/OFFICE 160.04 704.50 5,000.00 4,295.50 14.1 61-15-60250 WATER BILLING EXPENSE 644.85 2,956.28 9,500.00 6,543.72 31.1 61-15-60260 DUES AND SUBSCRIPTIONS .00 2,128.88 15,000.00 12,871.12 14.2 61-15-60300 PUBLIC/LEGAL NOTICES .00 .00 1,000.00 1,000.00 .0 61-15-60305 LEGAL SERVICES 270.90 4,038.23 40,000.00 35,961.77 10.1 61-15-60341 UTILITIES - ELECTRIC 5,329.92 31,636.83 167,000.00 135,363.17 18.9 61-15-60342 UTILITIES - GAS .00 1,572.19 4,500.00 2,927.81 34.9 61-15-60343 UTILITIES - SANITATION 739.94 1,984.53 12,000.00 10,015.47 16.5 61-15-60345 UTILITIES - TELEPHONE 551.62 2,348.33 12,000.00 9,651.67 19.6 61-15-60355 REPAIR & MAINTENANCE - DAM .00 4.24 6,000.00 5,995.76 .1 61-15-60400 CHEMICALS/GAS-WATER TREATMENT 874.91 2,662.04 60,400.00 57,737.96 4.4 61-15-60610 FUEL 813.31 1,611.77 6,000.00 4,388.23 26.9 61-15-60700 REPAIR & MAINTENANCE TEST: WAT 639.85 1,547.65 12,500.00 10,952.35 12.4 61-15-60720 UNCC MEMBERSHIP - LOCATES 123.25 279.85 1,000.00 720.15 28.0 61-15-60750 ACCOUNTING/AUDIT SERVICES .00 .00 6,000.00 6,000.00 .0 61-15-60770 TRAVEL, TRAINING & MEETINGS 42.80 2,511.59 10,000.00 7,488.41 25.1 61-15-60772 EMPLOYEE MILEAGE 100.00 100.00 .00 ( 100.00) .0 61-15-65375 RENTAL MACHINERY & EQUIPMENT .00 500.00 1,000.00 500.00 50.0 61-15-65390 REPAIR & MAINTENANCE - VEHICLE 670.40 3,237.58 3,800.00 562.42 85.2 61-15-65395 REPAIR & MAINTENANCE - EQUIPME .00 .00 2,500.00 2,500.00 .0 61-15-65400 REPAIR & MAINTENANCE - WELL SI 202.44 2,674.87 40,000.00 37,325.13 6.7 61-15-65403 REPAIR & MAINTENANCE - BOOSTE .00 .00 2,000.00 2,000.00 .0 61-15-65410 REPAIR & MAINTENANCE - DISTRIB 1,600.35 4,396.13 20,000.00 15,603.87 22.0 61-15-65420 REPAIR & MAINTENANCE-STORAGE T 1,600.00 1,600.00 2,750.00 1,150.00 58.2 61-15-65430 REPAIR & MAINTENANCE-WATER MET 3,195.89 3,580.76 15,000.00 11,419.24 23.9 61-15-65440 REPAIR & MAINTENANCE SCADA SYS .00 .00 4,000.00 4,000.00 .0 61-15-65444 BADGER METER BEACON BILLING .00 580.00 7,000.00 6,420.00 8.3 61-15-65660 REPAIR & MAINTENANCE - COMPUTE .00 1,800.00 .00 ( 1,800.00) .0 61-15-65710 PROFESSIONAL SERVICES 329.95 7,574.51 70,000.00 62,425.49 10.8 61-15-65996 CONTINGENCY .00 .00 75,000.00 75,000.00 .0 61-15-66024 CHART ANALYSIS-LIFE SPAN WELLS .00 .00 2,000.00 2,000.00 .0 61-15-66025 SCADA SYSTEM SOFTWARE UPGRADE .00 .00 7,250.00 7,250.00 .0 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:39PM PAGE: 33 61-15-66039 DISTRIBUTION LINE R&M .00 .00 25,325.00 25,325.00 .0 61-15-66042 SOURCE WATER PROTECTION GRANT .00 .00 5,000.00 5,000.00 .0 61-15-66045 WELL #4 & #5 PLANT ( 21,485.27) .00 .00 .00 .0 61-15-66058 TRUCK REPLACEMENT .00 .00 42,000.00 42,000.00 .0 61-15-66059 WTP FILTER REHAB WELLS 7 & 8 .00 .00 15,600.00 15,600.00 .0 61-15-66060 LAPTOP FOR METER READING SOFTW .00 .00 7,500.00 7,500.00 .0 TOTAL DEPARTMENT 15 93,786.37 380,879.65 1,691,065.00 1,310,185.35 22.5 TOTAL FUND EXPENDITURES 93,786.37 380,879.65 1,691,065.00 1,310,185.35 22.5 NET REVENUE OVER EXPENDITURES 56,709.75 429,318.89 468,524.00 39,205.11 91.6 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET APRIL 30, 2018 CONSERVATION TRUST FUND FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:39PM PAGE: 34 ASSETS 82-00-10100 CASH IN COMBINED CASH FUND ( 2,915.60) 82-00-10422 COLOTRUST CONSERVATION TRUST F 3,122.56 TOTAL ASSETS 206.96 LIABILITIES AND EQUITY FUND EQUITY 82-00-30000 BEGINNING FUND BALANCE - CONSE 3,107.75 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 2,900.79) BALANCE - CURRENT DATE ( 2,900.79) TOTAL FUND EQUITY 206.96 TOTAL LIABILITIES AND EQUITY 206.96 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 CONSERVATION TRUST FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:39PM PAGE: 35 CONSERVATION TRUST FUND 82-08-40060 INTEREST INCOME 5.02 14.81 50.00 35.19 29.6 82-08-41020 CTF - LOTTERY - PMT .00 9,641.76 40,000.00 30,358.24 24.1 TOTAL CONSERVATION TRUST FUND 5.02 9,656.57 40,050.00 30,393.43 24.1 TOTAL FUND REVENUE 5.02 9,656.57 40,050.00 30,393.43 24.1 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 4 MONTHS ENDING APRIL 30, 2018 CONSERVATION TRUST FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 33 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:39PM PAGE: 36 CONSERVATION TRUST FUND 82-08-66001 PARKS & OPEN SPACE IMPROVEMENT 5,737.07 12,557.36 43,934.00 31,376.64 28.6 TOTAL CONSERVATION TRUST FUND 5,737.07 12,557.36 43,934.00 31,376.64 28.6 TOTAL FUND EXPENDITURES 5,737.07 12,557.36 43,934.00 31,376.64 28.6 NET REVENUE OVER EXPENDITURES ( 5,732.05) ( 2,900.79) ( 3,884.00) ( 983.21) ( 74.7)