The URL can be used to link to this page

Q1-December-2015 FinancialsCITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 17,335,590 5,545,393.27 6,941,168.30 7,249,860.10 - 10,085,729.90 41.82% Franchises 2,221,153 159,895.69 443,282.68 475,477.40 - 1,745,675.60 21.41% Permits 1,249,839 83,257.07 314,466.00 322,516.51 - 927,322.49 25.80% Licenses 84,160 5,665.00 13,600.00 12,224.50 - 71,935.50 14.53% Fees 2,470,622 170,677.62 585,349.10 573,907.12 (57.75) 1,896,772.63 23.23% Fines 31,000 2,091.96 6,832.08 5,945.24 - 25,054.76 19.18% Inter - Jurisdictional 783,847 136,400.52 162,441.74 195,662.34 - 588,184.66 24.96% Fund Transfers 1,921,266 134,483.05 423,126.24 403,449.11 - 1,517,816.89 21.00% Miscellaneous 462,000 75,216.15 126,338.61 139,090.72 - 322,909.28 30.11% TOTAL REVENUES 26,559,477 6,313,080.33 9;016,604:75 9,378,133.04 (57:75) 17,181,401.71 35.31 %i EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 23,575 2,720.19 5,671.32 5,777.63 - 17,797.37 24.51% Supplies 2,600 - 65.34 39.30 - 2,560.70 1.51% City Support Services 68,176 6,903.40 27,070.32 42,770.48 - 25,405.52 62.74% Operations Support 500 - 96.95 - - 500.00 0.00% Staff Support 26,500 6,140.52 7,181.53 10,661.52 256.26 15,582.22 41.20% TOTAL CITY COUNCIL 121,351 15,764.1!1 40,085.46 59,248.93 256.26 61,845.81 49.04% CITY MANAGER Personnel Services 839,798 92,384.03 219,136.79 221,366.19 - 618,431.81 26.36% Supplies 3,000 126.50 169.68 671.89 - 2,328.11 22.40% City Support Services 2,770 - 1,362.50 - - 2,770.00 0.00% Staff Support 33,775 826.44 3,767.53 1,726.98 2,056.62 29,991 11.20% TOTAL CITY MANAGER 879,343 93,336:97 224,436`.50 223,765.06 2,056:62 653,521'.32 25.68% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MUNICIPAL COURT Personnel Services 278,579 30,056.62 69,429.80 71,764.22 - 206,814.78 25.76% Supplies 3,500 3.75 89.75 138.60 62.65 3,298.75 5.75% City Support Services 1,000 - - - - 1,000.00 0.00% Operations Support 4,500 - - - - 4,500.00 0.00% Staff Support 7,710 318.87 607.52 1,033.71 643.40 6,032.89 21.75% Court Support 700 - - - - 700.00 0.00% Professional Services 61,200 3,493.50 10,557.50 10,480.50 39,619.50 11,100.00 81.86% Maintenance Services 2,800 50.00 450.00 350.00 1,650.00 800.00 71.43% Operating Equipment 7,800 - - - 400.00 7,400.00 5.13% TOTAL MUNICIPAL COURT 367,789 33,92214 81,134.57 83,767.03 42,375.55 241,646.42 34.30% CUSTOMER RELATIONS -311 Personnel Services 115,445 12,113.71 27,964.31 29,724.87 - 85,720.13 25.75% Supplies 200 - 10.97 - 15.19 184.81 7.60% Staff Support 975 - - - - 975.00 0.00% Operating Equipment 500 - - - - 500.00 0.00% TOTAL CUSTOMER RELATIONS -311 117,120 12,11171 27,975.28 29,724.87 15.19 87,379.94 25.39% PLANNING & ZONING Personnel Services 144,435 15,369.56 32,550.12 34,851.91 - 109,583.09 24.13% Supplies 2,476 88.74 37.94 181.94 10.94 2,283.12 7.79% City Support Services 296 - - - - 296.00 0.00% Operations Support 750 - - - - 750.00 0.00% Staff Support 23,350 635.59 363.80 1,035.46 625.00 21,689.54 7.11% Professional Services 300 - - - - 300 0.00% TOTAL PLANNING & ZONING 171,607 16,093.89 32,951.86 36,069.31 635.94 134,901.75 21.39% LEGAL SERVICES Operations Support 10,000 - 37.44 - 126.88 9,873.12 1.27% Professional Services 275,000 8,615.40 16,543.00 8,615.40 - 266,384.60 3.13% TOTAL LEGAL SERVICES 285,000 8,615.40 16,580.44 8,61!5.40 126288 276,257.72 107% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GENERAL SERVICES Personnel Services 619,523 56,097.43 152,428.92 154,931.33 718.26 463,873.41 25.12% Supplies 102,544 8,331.45 6,037.65 13,878.34 4,515.61 84,150.05 17.94% Utility Services 188,015 15,213.02 13,553.98 30,088.90 4,177.83 153,748.27 18.23% Staff Support 11,749 734.70 931.83 1,765.03 259.34 9,724.63 17.23% Maintenance Services 52,060 1,575.00 5,012.16 2,749.14 6,283.88 43,026.98 17.35% Rental /Leasing 421 - - - - 421.00 0.00% Operating Equipment 3,600 - - - - 3,600 0.00% Capital Outlay 24,000 - - - - 24,000.00 0.00% TOTAL GENERAL SERVICES 1,001,9112 81,951.60 177,964.54 203,412.74 15, 954.92 782,544.34 21.89 %s CITY SECRETARY Personnel Services 169,988 19,130.13 41,982.58 42,889.35 - 127,098.65 25.23% Supplies 1,350 29.95 299.95 84.66 - 1,265.34 6.27% City Support Services 10,500 - - 3,914.02 - 6,585.98 37.28% Operations Support 450 - - - - 450.00 0.00% Staff Support 8,725 486.00 867.67 902.00 748.96 7,074.04 18.92% TOTAL CITY SECRETARY 191,013 19,646.08 43,150.20 47,790.03 748:96 142,474.01 25.41 %!' NON - DEPARTMENTAL City Support Services 377,094 35,648.24 184,527.99 182,225.80 2,273.68 192,594.52 48.93% Operations Support 134,500 9,149.35 29,203.11 13,789.28 - 120,710.72 10.25% Staff Support 9,900 - 80.00 - - 9,900.00 0.00% City Assistance 1,746,326 - - 119,910.31 - 1,626,415.69 6.87% Professional Services 63,285 6,049.09 11,865.74 13,940.28 29,450.00 19,894.72 68.56% Fund Chrgs /Transfrs -Spec Events Fnd 65,200 - - - - 65,200.00 0.00% Operating Equipment - - - 1,874.00 - (1,874.00) 0.00% TOTAL NON- DEPARTMENTAL 2,396,305 50,846.68 225,676.84 331,739.67 31,723.68 2,032,841'.65 15.17% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC AFFAIRS Personnel Services 272,396 29,334.34 58,090.25 67,026.27 - 205,369.73 24.61% Supplies 3,850 29.36 708.53 29.36 45.35 3,775.29 1.94% Operations Support 23,640 1.00 842.50 1,123.00 453.00 22,064.00 6.67% Staff Support 4,230 150.00 462.96 180.00 18.00 4,032.00 4.68% Professional Services 2,700 - - - - 2,700.00 0.00% Operating Equipment 3,300 - 1,709.93 - - 3,300.00 0.00% TOTAL PUBLIC AFFAIRS 310,116 29,51430 61,814.17 68,358.63 51635 241,241.02 22.21 %` RECORDS MANAGEMENT Personnel Services 52,540 5,492.53 13,574.12 13,950.93 - 38,589.07 26.55% Supplies 400 - 46.76 25.69 - 374.31 6.42% Staff Support 1,250 - 804.61 - - 1,250.00 0.00% Professional Services 10,000 607.50 2,176.00 2,090.00 - 7,910.00 20.90% Operating Equipment - - - - 83.77 (83.77) 0.00% TOTAL RECORDS' MANAGEMENT 64,190 6,100:03 16,601.49 16,066.62 83.77 48,039.61 25.16 %' SCHERTZ MAGAZINE Personnel Services 140,795 8,627.58 34,480.36 19,635.70 - 121,159.30 13.95% Supplies 200 - - - - 200.00 0.00% Staff Support 2,220 - 237.00 - - 2,220.00 0.00% Professional Services 245,500 11,516.49 42,039.37 39,103.81 8,149.24 198,246.95 19.25% Fund Charges /Transfers 10,000 - - - - 10,000.00 0.00% Operating Equipment 1,500 - - - - 1,500.00 0.00% TOTAL SCHERTZ MAGAZINE 400,215 20,144.07 76,756.73 58,739.51 8,149.24 333,326.25 16.71% ENGINEERING Personnel Services 258,764 21,552.12 43,029.75 46,500.33 - 212,263.67 17.97% Supplies 1,246 30.72 170.82 50.70 500.28 695.02 44.22% City Support Services 591 590.40 - 590.40 - 0.60 99.90% Utility Services 700 39.83 83.32 124.40 - 575.60 17.77% Staff Support 8,503 - 24.85 - - 8,503.00 0.00% Professional Services 35,800 - - 495.00 - 35,305.00 1.38% Operating Equipment 400 - - - - 400.00 0.00% TOTAL ENGINEERING 306,004 22,21107 43,308.74 47,760.83 500.28 257,742.89 15.77 %! CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GIS Personnel Services 142,882 15,582.50 34,850.48 36,326.39 - 106,555.61 25.42% Supplies 2,200 - - - - 2,200.00 0.00% Staff Support 4,390 - - - - 4,390.00 0.00% Rental /Leasing 3,805 520.95 - 520.95 1,389.20 1,894.85 0.00% TOTAL GIS 153,277 16,103.45 34,850.48 36,847.34 1,389.20 115,040.46 24.95 %i TOTAL GENERAL GOVERNMENT 6,765,242 426,366.50 1,103,287.30 1,251,905.97 104,532.84 5,408,803.19 20.05 %' PUBLIC SAFETY POLICE Personnel Services 5,504,509 626,854.28 1,303,655.96 1,467,332.16 - 4,037,176.84 26.66% Supplies 36,906 1,043.04 12,013.44 13,324.01 1,772.58 21,809.48 40.91% City Support Services 19,081 - 23,151.52 19,081.45 - (0.45) 100.00% Utility Services 112,663 5,649.94 16,487.36 11,989.61 - 100,673.69 10.64% Operations Support 2,950 76.95 284.94 695.95 700.00 1,554.05 47.32% Staff Support 114,631 2,587.33 18,763.83 8,530.35 1,800.17 104,300.83 9.01% City Assistance 10,150 - 357.20 1,357.88 414.00 8,378.12 17.46% Professional Services 37,288 865.25 5,399.68 15,998.80 388.94 20,900.26 43.95% Maintenance Services 57,780 6,080.00 3,958.96 15,865.00 1,291.95 40,623.05 29.69% Operating Equipment 116,090 30,774.06 9,522.90 57,427.41 40,532.32 18,130.17 84.38% Capital Outlay 199,327 24,776.25 55,175.00 199,126.25 200.00 0.50 100.00% TOTAL POLICE 6,211,375 698,707.10 1,448,770.79 1,810,728.87 47,099;96 4,353,546.54 29.91 %!' FIRE RESCUE Personnel Services 3,205,808 365,920.46 784,032.22 840,580.16 - 2,365,227.84 26.22% Supplies 16,500 315.70 822.95 1,124.61 305.50 15,069.89 8.67% Utility Services 60,400 3,278.66 9,696.75 8,006.33 828.81 51,564.86 14.63% Operations Support 600 68.97 - 68.97 - 531.03 11.50% Staff Support 110,600 10,312.02 14,331.23 23,242.88 12,927.36 74,429.76 32.70% City Assistance 16,200 - - 95.34 - 16,104.66 0.59% Professional Services 26,000 - 160.00 - - 26,000.00 0.00% Maintenance Services 60,000 2,113.49 6,614.24 5,975.18 1,660.63 52,364.19 12.73% Rental /Leasing 14,000 1,316.94 - 4,063.19 - 9,936.81 29.02% Operating Equipment 66,600 11,673.38 1,099.40 15,631.57 20,214.98 30,753.45 53.82% Capital Outlay 150,000 - - - 1,653.75 148,346.25 1.10% TOTAL FIRE RESCUE 3,726,708 394,999.62 816,756.79 898,788.23 37,591.03 2,790,328.74 25.13% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INSPECTIONS Personnel Services 552,775 47,444.25 113,883.31 114,038.34 - 438,736.66 20.63% Supplies 3,585 246.98 298.81 422.60 220.00 2,942.40 17.92% Utility Services 6,500 265.68 741.81 668.21 - 5,831.79 10.28% Operations Support 2,200 294.00 410.48 294.00 - 1,906.00 13.36% Staff Support 18,600 625.09 342.30 1,908.09 554.00 16,137.91 13.24% Professional Services 107,600 6,775.00 - 17,872.00 31,313.00 58,415.00 45.71% Operating Equipment 2,100 - - - - 2,100.00 0.00% TOTAL INSPECTIONS 693,360 55,651.00 115,676.71 135,20124 32,087.00 526,069.76 24.13 %d MARSHAL'S OFFICE Personnel Services 618,483 64,744.35 153,135.94 152,620.58 - 465,862.42 24.68% Supplies 6,211 204.25 501.06 622.03 765.84 4,823.13 22.35% Utility Services 16,000 500.18 1,380.50 1,157.33 - 14,842.67 7.23% Operations Support 3,500 - - - 177.00 3,323.00 5.06% Staff Support 14,300 205.92 766.78 1,053.42 494.90 12,751.68 10.83% City Assistance 2,500 - - - - 2,500.00 0.00% Maintenance Services 16,500 600.00 650.00 800.00 - 15,700.00 4.85% Operating Equipment 5,039 - 136.96 - - 5,039.00 0.00% Capital Outlay 72,950 28,080.00 - 63,371.25 7,823.60 1,755.15 97.59% TOTAL MARSHAL'S OFFICE 755,483 94,334.70 156,571 =:24 219,624.61 9,261:34 526,597.05 30.30 %' TOTAL PUBLIC SAFETY 11,386,926.37 1,243,692.42 2;537,775.53 3,064,344.95 126,039.33 8,196,542.09 28.02 %'i CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC ENVIRONMENT 20,700 69.98 4,191.12 441.98 59.96 20,198.06 2.42% Utility Services 29,000 1,100.61 3,780.78 2,238.64 178.79 26,582.57 8.34% STREETS 205,878 - - - - 205,878.00 0.00% PARKS DEPARTMENT 2,500 - - - - 2,500.00 0.00% Personnel Services 713,763 66,412.30 186,658.20 183,298.69 - 530,464.31 25.68% Supplies 7,100 211.87 1,198.74 1,592.34 114.92 5,392.74 24.05% Utility Services 196,604 12,356.24 7,225.52 24,804.87 392.95 171,406.18 12.82% Staff Support 10,030 507.95 2,189.70 2,605.32 277.86 7,146.82 28.75% Professional Services 40,000 - 22,000.00 - 2,940.00 37,060.00 7.35% Maintenance Services 122,000 5,815.79 12,161.03 15,004.41 1,627.82 105,367.77 13.63% Rental /Lease 200 - 175.00 - - 200.00 0.00% Operating Equipment 300 - - - - 300.00 0.00% Capital Outlay 81,400 - - - - 81,400.00 0.00% TOTAL STREETS 1,171,397 85,304.15 231,608.19 227,305.63 5,35155 938,737.82 19.86 %` TOTAL PUBLIC ENVIRONMENT ` 1,171,397 85,304.15 231,608!.19 227,305.63 5,35155 938,737.82 19.86% PARKS & RECREATION 20,700 69.98 4,191.12 441.98 59.96 20,198.06 2.42% Utility Services 29,000 1,100.61 3,780.78 2,238.64 178.79 26,582.57 8.34% Maintenance Services 205,878 - - - - 205,878.00 0.00% PARKS DEPARTMENT 2,500 - - - - 2,500.00 0.00% TOTAL SWIM POOL 258,078 1,170.59 7,971.90 2,680.62 238:75 255,158.63 1.13 %' Personnel Services 534,975 47,939.56 108,849.55 121,345.01 - 413,629.99 22.68% Supplies 41,905 2,527.83 2,286.11 4,584.70 3,090.97 34,229.33 18.32% City Support Services - 989.00 - 989.00 - (989.00) 0.00% Utility Services 173,800 19,082.42 20,103.63 28,832.29 9,343.01 135,624.70 21.97% Operations Support 1,250 - - - - 1,250.00 0.00% Staff Support 9,625 436.59 1,203.03 1,126.03 507.08 7,991.89 16.97% Professional Services 79,000 18,812.71 4,922.00 21,483.71 6,362.50 51,153.79 35.25% Maintenance Services 22,000 2,053.23 171.16 3,344.23 1,537.51 17,118.26 22.19% Rental /Leasing 39,600 3,019.16 12,076.64 9,057.48 27,172.44 3,370.08 91.49% Operating Equipment 2,000 784.04 1,121.94 784.04 344.25 871.71 56.41% Capital Outlay 38,000 - - - - 38,000.00 0.00% TOTAL PARKS DEPARTMENT 942,155 95,644.54 150,734.06 191,546.49 48 ,357.76 702,250.75 25.46 %' SWIM POOL Supplies 20,700 69.98 4,191.12 441.98 59.96 20,198.06 2.42% Utility Services 29,000 1,100.61 3,780.78 2,238.64 178.79 26,582.57 8.34% Maintenance Services 205,878 - - - - 205,878.00 0.00% Operating Equipment 2,500 - - - - 2,500.00 0.00% TOTAL SWIM POOL 258,078 1,170.59 7,971.90 2,680.62 238:75 255,158.63 1.13 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET EVENT FACILITIES LIBRARY Personnel Services 56,240 6,060.75 13,867.93 12,740.98 692,689 - 153,015.26 43,499.02 22.65% Supplies 15,500 736.15 15,000 700.42 1,487.32 3,710.48 1,352.50 10,946.41 12,660.18 18.32% Utility Services 51,850 3,513.81 10,924.79 6,653.97 8,047.26 20.05% 387.30 3,100 43,415.44 16.27% Operations Support 11,358 850.00 7.80% 4,435.00 850.00 1,522.33 250.00 1,597.32 10,258.00 9.68% Staff Support 2,500 2,284 - 583.74 550.00 - - 98.38% 1,950.00 22.00% Professional Services 500 25,682.66 - - 29.42% - - 104,083.69 500.00 0.00% Operating Equipment 12,612 25.47 %` - 431.26 104,08169 - - 4,989.20 12,612.00 0.00% TOTAL EVENT FACILITIES; 150,560 11,160.71 26,672,32 23,675.56 1,989.80 124,894.64 17.05% SENIOR CITIZEN CENTER Supplies - 424.89 1,040.25 1,846.93 259.70 (2,106.63) 0.00% Utility Services - - 216.78 - - - 0.00% City Assistence - 5,361.41 4,482.83 13,381.96 2,644.74 (16,026.70) 0.00% Professional Services - 395.77 560.00 936.27 80.50 (1,016.77) 0.00% Maintenance Services - - 239.08 138.50 - (138.50} 0.00% TOTAL SENIOR CITIZEN CENTER - 6,182.07 6,538.94 16,303.66 2,984.94 (19,288.60) 0.00% TOTAL PARKS & RECREATION - 1,350,793 114,157.91 191,917.22 234,206.33 ;53,571.25 1,063,015.42 21.30% CULTURAL LIBRARY Personnel Services 692,689 75,543.94 153,015.26 174,087.26 - 518,601.74 25.13% Supplies 15,000 1,338.78 2,839.21 3,710.48 343.11 10,946.41 27.02% Utility Services 56,500 6,640.84 7,013.44 10,924.79 402.54 45,172.67 20.05% Operations Support 3,100 225.70 231.98 241.69 - 2,858.31 7.80% Staff Support 7,715 1,522.33 864.76 1,597.32 509.00 5,608.68 27.30% Professional Services 2,284 2,247.00 2,175.00 2,247.00 - 37.00 98.38% Operating Equipment 100,000 16,565.10 20,541.86 25,682.66 3,734.55 70,582.79 29.42% TOTAL LIBRARY 877,288 104,083.69 186,681.51 218,491.20 4,989.20 653,807.60 25.47 %` TOTAL CULTURAL 877,288 104,08169 186,681''.51 218,49120 4,989.20 653,807.60 25.47 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HEALTH ANIMAL SERVICES Personnel Services 324,954 31,383.16 66,900.39 73,282.47 - 251,671.53 22.55% Supplies 41,380 3,553.24 6,085.79 4,796.33 562.92 36,020.75 12.95% City Support Services 3,776 - - - - 3,776.00 0.00% Utility Services 43,000 1,699.00 4,614.07 3,866.03 124.61 39,009.36 9.28% Operations Support 1,000 - - - - 1,000.00 0.00% Staff Support 10,750 725.85 531.31 1,480.83 100.00 9,169.17 14.71% City Assistance 17,550 2,042.82 1,889.65 2,513.85 - 15,036.15 14.32% Professional Services 32,500 800.00 2,007.00 1,497.50 - 31,002.50 4.61% Maintenance Services 28,280 450.00 689.99 5,050.00 - 23,230.00 17.86% Operating Equipment 10,000 - - 1,404.30 197.52 8,398.18 16.02% Capital Outlay 55,000 - - 22,588.15 - 32,411.85 41.07% TOTAL ANIMAL SERVICES'; 568,190 40,654.07 82,718.20 116,479.46 985.05 450,725.49 20.67% TOTAL HEALTH ` 568,190 40,654.07 82,718.20 116,479.46 985:05 450,725.49 20.67% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 462,042 48,552.63 92,753.81 107,130.33 - 354,911.98 23.19% Supplies 3,100 65.58 235.13 163.53 141.78 2,794.69 9.85% City Support Services 541,399 16,514.36 82,402.86 78,855.81 3,705.48 458,837.71 15.25% Utility Services 267,402 16,550.18 35,006.04 39,746.22 6,528.52 221,127.26 17.31% Operations Support - - - - - - 0.00% Staff Support 36,050 1,666.41 2,519.77 6,261.50 1,630.20 28,158.30 21.89% Maintenance Services 15,600 508.69 2,954.39 3,324.45 96.17 12,179.38 21.93% Rental /Leasing 38,047 3,170.49 - 12,681.96 3,170.49 22,194.55 41.67% Operating Equipment 235,866 18,233.14 12,791.60 26,271.99 43,519.20 166,074.81 29.59% TOTAL INFORMATION TECHNOLOGY 1,599,506 105,261.48 228,663.60 274,435.79 58,791 84 1,266,278.68 20.83 %i CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HUMAN RESOURCES Personnel Services 291,703 26,283.87 75,267.44 55,415.55 - 236,287.45 19.00% Supplies 1,000 - 369.79 - 6.25 993.75 0.63% Human Services 64,744 6,176.35 11,635.25 13,184.91 - 51,559.09 20.36% Operations Support 10,000 1,125.00 - 2,667.91 35.00 7,297.09 27.03% Staff Support 18,356 581.66 2,195.00 1,762.66 - 16,593.34 9.60% City Assistance 11,000 3,985.50 651.50 4,798.00 - 6,202.00 43.62% Professional Services 9,600 744.75 2,234.25 2,259.25 744.75 6,596.00 31.29% Operating Equipment 1,800 - - - 1,362.96 437.04 75.72% TOTAL HUMAN RESOURCES 408,203 38,897.13 92,35123 80,088.28 2,148.96 325,965.76 20.15% FINANCE Personnel Services 597,537 55,125.92 120,159.99 129,630.82 - 467,906.18 21.69% Supplies 3,500 568.89 646.40 685.89 402.02 2,412.09 31.08% Operations Support 3,000 - - - - 3,000.00 0.00% Staff Support 11,085 180.00 740.00 1,672.50 111.36 9,301.14 16.09% TOTAL FINANCE 615,122 55,874.81 121,546.39 131,989.21 513.38 482,619.41 21.54% PURCHASING & ASSET MGT Personnel Services 197,453 15,839.63 45,581.92 44,468.73 - 152,984.27 22.52% Supplies 1,100 39.54 - 51.33 88.34 960.33 12.70% Utility Services 500 - 134.96 - - 500.00 0.00% Operations Support 100 - - - - 100.00 0.00% Staff Support 6,600 625.63 687.40 817.63 275.00 5,507.37 16.56% City Assistance 2,500 355.00 - 1,113.80 39.00 1,347.20 46.11% TOTAL PURCHASING & ASSET MGT 208,253 16,859.80 46,404!.28 46,451.49 402:34 161,399.17 22.50 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET FLEET SERVICE Personnel Services 327,626 34,822.91 56,621.16 77,815.14 - 249,810.86 23.75% Supplies 125,895 7,634.97 23,479.60 26,810.56 5,949.01 93,135.43 26.02% City Support Services 3,500 - 2,232.24 2,244.72 - 1,255.28 64.13% Utility Services 6,454 283.47 855.39 837.95 - 5,616.05 12.98% Operations Support 300 - - - - 300.00 0.00% Staff Support 5,914 542.63 741.68 1,160.43 172.12 4,581.45 22.53% Maintenance Services 119,890 10,426.26 11,292.09 46,105.01 5,380.49 68,404.50 42.94% Rental /Lease 200 - - - - 200.00 0.00% Operating Equipment 8,200 828.00 2,132.08 1,706.52 - 6,493.48 20.81% Capital Outlay 93,372 - - 1,371.47 88,114.64 3,885.89 95.84% TOTAL FLEET SERVICE 691,351 54,538.24 97,354.24 158,051.80 99,616.26 433,682.94 37.27% BUILDING MAINTENANCE Personnel Services 148,103 14,382.86 29,756.43 37,765.87 - 110,337.13 25.50% Supplies 1,043 34.60 394.52 159.55 2.98 880.47 15.58% Utility Services 2,350 184.79 497.21 446.81 - 1,903.19 19.01% Staff Support 3,420 87.13 492.32 1,019.76 45.95 2,354.29 31.16% Professional Services 43,785 13,399.63 - 20,393.74 17,973.25 5,418.01 87.63% Maintenance Services 99,985 2,569.13 14,962.85 5,491.50 964.78 93,528.72 6.46% Rental /Leasing 1,400 978.02 - 978.02 - 421.98 69.86% Capital Outlay - - - - 8,415.00 (8,415.00) 0.00% TOTAL BUILDING MAINTENANCE 300,086 31,636.16 46,103.33 66,255.25 27,401 96 206,428.79 31.21°/% TOTAL INTERNAL SERVICE 3,822,521 303,067,62 632,425.07 757,271 .82 188,874.74 2';876,374!.75 24.75 %'i CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 REVENUE OVER(UNDER) EXPEND. 388,459 3,499,203.43 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MISC & PROJECTS CITY ASSISTANCE City's Assistance to Agencies 192,000 - 5,000.00 5,000.00 - 187,000.00 2.60% TOTAL CITY ASSISTANCE 192,000 - 5,000.00 5,000.00 - 187,000.00 2.60% COURT - RESTRICTED FUNDS Operating Equipment 36,660 3,924.25 - 3,924.25 1,840.00 30,895.75 15.72% TOTAL CITY ASSISTANCE 36,660 3,924.25 - 3,924.25 1,840.00 30,895.75 15.72 %` TOTAL MISC & PROJECTS 228,660 3,924:25 5,000.00 8,924.25 1,840:00 217,895.75 4.71% TOTAL EXPENDITURES 26,171,018 2,321,250.69 4,971,413.02 5,878,929.61 486,185;96 19,805,902.11 24.32 %' REVENUE OVER(UNDER) EXPEND. 388,459 3,499,203.43 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 10,162,766 4,754,503.16 5,178,337.61 5,418,005.65 - 4,744,760.35 53.31% 000 - 411200 Advalorem Tax - Delinquent 45,000 3,414.58 14,557.44 2,323.37 - 42,676.63 5.16% 000 - 411300 Advalorem Tax - P &I 45,000 1,043.64 5,232.57 1,969.63 - 43,030.37 4.38% 000 - 411500 Sales Tax Revenue -Gen Fund 7,036,724 786,431.89 1,731,615.43 1,816,171.33 - 5,220,552.67 25.81% 000 - 411600 Bingo Tax 100 - - - - 100.00 0.00% 000 - 411700 Mixed Beverage Tax 46,000.00 - 11,425.25 11,390.12 - 34,609.88 24.76% TOTAL Taxes 17,335,590 5,545;39127 6,941,168.30 7,249,86010 - 10,085,729.90 41.82% Franchises 000 - 421200 Center Point/Entex Energy 109,857 1,476.38 16,760.99 14,424.08 - 95,432.92 13.13% 000 - 421220 City Public Service 815,953 46,633.90 122,357.06 151,354.89 - 664,598.11 18.55% 000 - 421240 Guadalupe Valley Elec Co -op 453,465 41,443.57 104,689.84 106,598.87 - 346,866.13 23.51% 000 - 421250 New Braunfels Utilities 56,736 6,101.87 14,627.57 15,220.23 - 41,515.77 26.83% 000 - 421300 Time Warner -State Franchise 275,193 17,978.92 65,992.18 63,431.78 - 211,761.22 23.05% 000 - 421460 AT &T Franchise Fee 251,861 32,164.65 62,233.86 68,000.71 - 183,860.29 27.00% 000 - 421480 Other Telecom Franchise 125,000 53.88 22,302.57 24,380.56 - 100,619.44 19.50% 000 - 421500 Solid Waste Franchise Fee 133,088 14,042.52 34,318.61 32,066.28 - 101,021.72 24.09% TOTAL Franchises 2,221,153 159,895.69 443,282.68 475,477.40 - 1,745,675.60 21.41 %' Permits 000 - 431100 Home Occupation Permit 420 315.00 175.00 385.00 - 35.00 91.67% 000 - 431205 Building Permit - Residential 567,624 25,712.00 145,938.00 117,859.00 - 449,765.00 20.76% 000 - 431210 Building Permit - Commercial 182,270 10,535.00 7,607.00 50,506.00 - 131,764.00 27.71% 000 - 431215 Building Permit - General 150,000 8,845.00 37,103.00 28,097.00 - 121,903.00 18.73% 000 - 431300 Mobile Home Permit 525 75.00 150.00 125.00 - 400.00 23.81% 000 - 431400 Signs Permit 3,500 405.00 736.00 1,268.00 - 2,232.00 36.23% 000 - 431500 Food Establishmnt Permit 56,000 17,005.00 48,950.00 51,500.00 - 4,500.00 91.96% 000 - 431600 Garage Sale Permit 8,000 353.00 2,524.00 2,935.00 - 5,065.00 36.69% 000 - 431700 Plumbing Permit 105,000 7,644.00 27,859.00 28,096.00 - 76,904.00 26.76% 000 - 431750 Electrical Permit 51,000 4,040.00 12,620.00 14,940.00 - 36,060.00 29.29% 000 - 431800 Mechanical Permit 53,000 3,120.00 14,140.00 12,500.00 - 40,500.00 23.58% 000 - 431900 Solicitor /Peddler Permit 1,200 60.00 120.00 60.00 - 1,140.00 5.00% 000 - 431950 Animal /Pet Permit 1,800 - 100.00 - - 1,800.00 0.00% 000 - 432000 Cert. of Occupancy Prmt 6,000 850.00 2,650.00 2,100.00 - 3,900.00 35.00% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 432100 Security Alarm Permit 40,000 3,036.00 9,081.00 8,056.00 - 31,944.00 20.14% 000 - 432300 Grading /Clearing Permit 3,500 662.07 962.00 1,718.51 - 1,781.49 49.10% 000 - 435000 Fire Permit 20,000 600.00 3,751.00 2,371.00 - 17,629.00 11.86% TOTAL Permits 1,249,839 83,257.07 314,466.00 322,516.51 - 927,32249 25.80 %!' Licenses 000 - 441000 Alcohol Beverage License 7,000 1,785.00 1,245.00 3,147.50 - 3,852.50 44.96% 000 - 441300 Mobile Home License 160 120.00 80.00 120.00 - 40.00 75.00% 000 - 442000 Contractors License 74,000 3,450.00 11,815.00 8,260.00 - 65,740.00 11.16% 000 - 444000 Pet License 3,000 310.00 460.00 697.00 - 2,303.00 23.23% TOTAL Licenses 84,160 5,665.00 13,600.00: 12,224.50 - 71,935.50 14.53 %' Fees 000 - 451000 Municipal Court Fines 1,027,516 79,881.70 244,454.89 234,900.90 - 792,615.10 22.86% 000 - 451100 Arrest Fee 34,750 2,943.36 11,273.05 8,632.39 - 26,117.61 24.84% 000 - 451110 Expunction Fee 60 - 60.00 30.00 - 30.00 50.00% 000 - 451200 Warrant Fees 150,000 8,881.45 24,296.57 27,306.95 - 122,693.05 18.20% 000 - 451210 Court - Claims & Judgements - (319.00) - (219.00) - 219.00 0.00% 000 - 451340 Judicial Fee - City 5,250 393.76 1,467.71 1,173.18 - 4,076.82 22.35% 000 - 451400 Traffic Fine Costs TTL 20,000 1,445.56 5,838.32 4,241.67 - 15,758.33 21.21% 000 - 451510 Juvenile Case Mgmt Fee 45,650 3,261.27 12,231.07 9,761.21 - 35,888.79 21.38% 000 - 451520 Truancy Fee 7,225 594.13 2,204.48 1,777.93 5,447.07 24.61% 000 - 451600 Technology Fund Fee 36,660 2,658.23 9,818.04 7,857.66 - 28,802.34 21.43% 000 - 451700 Security Fee 28,250 1,993.67 7,360.56 5,893.24 - 22,356.76 20.86% 000 - 451800 Time Payment Fee - City 5,690 561.71 1,341.27 1,403.66 - 4,286.34 24.67% 000 - 451850 State Fines 10% Service Fee 64,500 - 16,483.31 13,270.02 - 51,229.98 20.57% 000 - 451900 DPS Payment - Local 7,500 701.60 1,772.50 2,091.61 - 5,408.39 27.89% 000 - 452000 Child Safety Fee 30,000 1,814.87 8,322.17 4,808.02 - 25,191.98 16.03% 000 - 452050 Indigent Defense Fee 1,741 - - - - 1,741.00 0.00% 000 - 452100 Platting Fees 57,000 4,000.00 22,500.00 10,500.00 - 46,500.00 18.42% 000 - 452200 Site Plan Fee 25,000 1,500.00 3,500.00 7,000.00 - 18,000.00 28.00% 000 - 452300 Plan Check Fee 455,979 21,619.00 95,257.00 97,068.00 - 358,911.00 21.29% 000 - 452310 Miscellaneous Review Fee 600 - 300.00 300.00 - 300.00 50.00% 000 - 452320 Tree Mitigation Admin Fee 10,000 1,470.00 11,925.00 6,645.00 - 3,355.00 66.45% 000 - 452400 BOA/Zoning Fees 5,000 - 1,500.00 500.00 - 4,500.00 10.00% 000 - 452500 Food Handler Class - - 3,160.00 - - - 0.00% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 452520 Fire Training Classes 500 - - - - 500.00 0.00% 000 - 452600 Specific Use /Zone Chng Fee 18,000 1,000.00 1,000.00 2,300.00 - 15,700.00 12.78% 000 - 452710 Zoning Ltr & Dev Rights 2,400 - 750.00 750.00 - 1,650.00 31.25% 000 - 453100 Reinspection Fees 35,000 8,425.00 9,620.00 17,125.00 - 17,875.00 48.93% 000 - 453110 Swim Pool Inspection Fee 2,000 - - - - 2,000.00 0.00% 000 - 453200 Lot Abatement 10,000 - 100.00 - - 10,000.00 0.00% 000 - 453211 Admin Fee - Inspections 6,600 1,200.00 1,200.00 2,600.00 - 4,000.00 39.39% 000 - 453310 Misc Inspection Fee - - - 100.00 - (100.00) 0.00% 000 - 453710 Foster Care 1,000 - 250.00 300.00 - 700.00 30.00% 000 - 454200 Pool Gate Admission Fee 24,750 - - - - 24,750.00 0.00% 000 - 454300 Seasonal Pool Pass Fee 4,900 - - - - 4,900.00 0.00% 000 - 456110 Senior Center Memberships - 739.00 1,022.60 2,638.00 - (2,638.00) 0.00% 000 - 456120 Senior Center Meal Fee - 401.00 5,235.51 401.00 - (401.00) 0.00% 000 - 456500 Haz Mat Fees 12,000 1,202.50 - 1,202.50 - 10,797.50 10.02% 000 - 456600 Fire Re- inspection Fee 1,000 - 250.00 300.00 - 700.00 30.00% 000 - 458110 Sale of Merchandise- GovDeal 5,000 1,500.02 672.01 13,152.06 - (8,152.06) 263.04% 000 - 458300 Sale of Property /Auction 4,000 2,194.00 - 2,194.00 - 1,806.00 54.85% 000 - 458400 Civic Center Rental Fees 159,000 8,635.75 35,634.50 34,706.00 (57.75) 124,351.75 21.79% 000 - 458401 Capital Recovery Fee -Civic Cntr 6,500 500.00 1,100.00 1,800.00 - 4,700.00 27.69% 000 - 458450 North Center Rental Fees 18,500 1,150.00 7,805.75 4,850.00 - 13,650.00 26.22% 000 - 458460 Senior Center Rental 8,400 1,950.00 3,130.00 5,150.00 - 3,250.00 61.31% 000 - 458500 Community Center Rental Fees 24,500 2,665.00 5,594.88 11,490.00 - 13,010.00 46.90% 000 - 458550 Pavilion Rental Fees 17,370 285.00 2,630.00 2,038.50 - 15,331.50 11.74% 000 - 458560 Chamber of Comm rent 7,800 - 1,950.00 1,950.00 - 5,850.00 25.00% 000 - 458570 Non - Resident SYSA League 3,000 - - - - 3,000.00 0.00% 000 - 458650 NonResident User Fee -BVYA 13,825 - 2,740.00 10,000.00 - 3,825.00 72.33% 000 - 458660 BVYA Utility Reimbursement 8,340 1,133.04 5,100.50 5,000.82 - 3,339.18 59.96% 000 - 458670 SYSA Utility Reimbursement 1,968 - - - - 1,968.00 0.00% 000 - 458675 Lions Futbol Utility Reimbursement 14,148 1,172.00 5,860.00 1,172.00 - 12,976.00 8.28% 000 - 458700 Vehicle Impoundment 9,000 - 2,300.00 - - 9,000.00 0.00% 000 - 459200 NSF Check Fee 250 - - 25.00 - 225.00 10.00% 000 - 459300 Notary Fee 250 12.00 36.00 48.00 - 202.00 19.20% 000 - 459400 Maps, Copies, UDC, & Misc F 250 5.00 10.00 25.00 - 225.00 10.00% 000 - 459600 Animal Adoption Fee 14,000 1,496.00 2,952.51 3,075.00 - 10,925.00 21.96% 000 - 459700 Pet Impoundment Fee 12,000 1,095.00 1,976.00 3,341.00 - 8,659.00 27.84% 000 - 459800 Police Reports Fee 6,000 516.00 1,362.90 1,230.80 - 4,769.20 20.51% TOTAL Fees 2,470,622 170,677.62 ; 585,349.10'- 573,907.12 (5715), 1,896,772.63 2123°/x% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fines 000 - 463000 Library Fines 31,000 2,091.96 6,832.08 5,945.24 - 25,054.76 19.18% TOTAL Fines 31,000 2,091.96 '` 6,832.08 5,945.24 - 25,054.76 19.18% Inter - Jurisdictional 000 - 473100 Bexar Co - Fire 21,072 3,512.96 5,269.44 8,501.81 - 12,570.19 40.35% 000 - 473200 City of Seguin - Fire Contract 29,231 4,871.80 7,307.70 7,307.70 - 21,923.30 25.00% 000 - 473300 Guad Co - Library 212,000 35,325.66 52,988.49 35,325.66 - 176,674.34 16.66% 000 - 473400 Randolph AFB - Animal Cntrl 1,500 - - - - 1,500.00 0.00% 000 - 474200 Library Services - Cibolo 30,000 35,000.00 - 35,000.00 - (5,000.00) 116.67% 000 - 474210 Library Services -Selma 30,544 - - - - 30,544.00 0.00% 000 - 474400 Dispatch Service - Cibolo 160,000 40,000.00 - 40,000.00 - 120,000.00 25.00% 000 - 474600 School Crossing Guard - Bexar 40,000 2,627.60 8,501.26 5,889.23 - 34,110.77 14.72% 000 - 474610 School Cross Guard - Guadalupe 38,000 2,562.50 8,374.85 8,637.94 - 29,362.06 22.73% 000 - 474620 School Crossing Guard -Coma) 1,500 - - - - 1,500.00 0.00% 000 - 474700 School Officer Funding 170,000 - 80,000.00 42,500.00 - 127,500.00 25.00% 000 - 474750 Crime Victim Liaison Agreement 50,000 12,500.00 - 12,500.00 - 37,500.00 25.00% TOTAL Inter - Jurisdictional 783,847 136,400.52 162,441.74 195,662.34 - 588,184.66 24.96 %'I Fund Transfers 000 - 480000 Indirect Costs - EMS 150,308 12,525.63 34,021.74 37,576.89 - 112,731.11 25.00% 000 - 480100 Indirect Costs - Hotel /Motel 66,405 - 16,601.25 - - 66,405.00 0.00% 000 - 482200 Transfer - Vehicle Replcemt 241,088 - - - - 241,088.00 0.00% 000 - 485000 Interfund Charge- Drainage 54,150 4,512.50 14,282.49 13,537.50 - 40,612.50 25.00% 000 - 486000 Interfund Chrges -Admin W &S 1,152,350 96,029.17 288,087.51 288,087.47 - 864,262.53 25.00% 000 - 487000 Interfund Charges -Fleet 206,965 17,247.08 45,059.25 51,741.28 - 155,223.72 25.00% 000 - 488000 Interfund Charges -413 50,000 4,168.67 25,074.00 12,505.97 - 37,494.03 25.01% TOTAL Fund Transfers 1,921,266 134,483.05 423,126.24 403,449.11 - 1,51;7,816.89 21.00 %'i CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 600 86.41 116.71 131.95 - 468.05 21.99% 000 - 491200 Investment Income 26,000 3,982.32 5,822.18 12,197.41 - 13,802.59 46.91% 000 - 491800 Gain /Loss - (16,185.00) (609.40) (20,768.72) - 20,768.72 0.00% 000 - 491900 Unrealized Gain /Loss (15,000) 11,607.36 (2,091.83) 5,496.61 - (20,496.61) 0.00% 000 - 493120 Donations - Public Library 2,500 95.00 1,503.00 114.75 - 2,385.25 4.59% 000 - 493400 Donation - Animal Control 1,000 - 75.00 50.00 - 950.00 5.00% 000 - 493401 Donations -A/C Microchip 1,000 120.00 235.00 290.00 - 710.00 29.00% 000 - 493402 Donations - Spay &Neuter 10,000 1,400.50 2,228.00 3,248.25 - 6,751.75 32.48% 000 - 493403 Donations - Animal Adoption Trailer - 525.00 5,303.52 1,525.00 - (1,525.00) 0.00% 000 - 493465 Donations - Senior Center - 499.00 2,531.81 2,145.85 - (2,145.85) 0.00% 000 - 493618 Donations - Veteran's Memorial - 375.00 - 450.00 - (450.00) 0.00% 000 - 494481 LawEnforcemtOfficersStnd &Ed 3,900 - - - 3,900.00 0.00% 000 - 494482 Grants - Police, Fire, Gen Fund 15,000 - - - - 15,000.00 0.00% 000 - 495060 Grant - Wellmed /Senior Center - - - - - - 0.00% 000 - 495100 Mobile Stage Rental Fees - - - - - - 0.00% 000 - 497000 Misc Income -Gen Fund 36,000 14,412.40 4,299.85 23,914.63 - 12,085.37 66.43% 000 - 497005 Schertz Magazine Advertising 240,000 15,475.00 75,445.00 52,425.00 - 187,575.00 21.84% 000 - 497100 Misc Income - Police 7,000 3,331.60 2,113.50 1,765.51 - 5,234.49 25.22% 000 - 497200 Misc Income - Library 5,000 383.65 1,571.55 1,215.55 - 3,784.45 24.31% 000 - 497210 Misc Income - Library Copier 18,000 2,179.55 4,529.97 5,154.05 - 12,845.95 28.63% 000 - 497300 Misc Income - Animal Control - 10.00 - 30.00 - (30.00) 0.00% 000 - 497400 Misc Income - Streets Dept. 20,000 1,200.00 2,566.75 3,178.90 - 16,821.10 15.89% 000 - 497500 Misc Income -TML Insurance 20,000 - - - - 20,000.00 0.00% 000 - 497550 Misc Income -TML Reimbursemt 20,000 - 2,032.08 1,081.40 - 18,918.60 5.41% 000 - 497600 Misc Income - Vending Mach. 2,500 338.40 467.96 644.39 - 1,855.61 25.78% 000 - 498000 Reimbursmnt -Gen Fund 32,000 9,122.68 7,999.29 9,122.68 - 22,877.32 28.51% 000 - 498100 Reimbursmnt Fire - Training 1,000 - - 3,735.00 - (2,735.00) 373.50% 000 - 498105 Reimburmnt Police - DEA 6,000 - 3,198.67 2,185.23 - 3,814.77 36.42% 000 - 498107 Reimburmnt Police - Event 7,000 - 7,000.00 3,500.00 - 3,500.00 50.00% 000 - 498110 Reimbursmnt Fire - Emg. Acti -O 2,500 26,257.28 - 26,257.28 - (23,757.28) 1050.29% TOTAL Miscellaneous 462,000 75,216.15 126,338.61 139,090.72 - 322,909.28 30.11% TOTALiREVENUES 26,559,477 's 6,313,080.33 9,016,604.75` 9,378,133.04 (57.75) 17,181,401.71 3531 % GENERALFUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $ 3,521,613.57 Cash in Investments LOGIC Investment - General Fund 5,197,165.42 LOGIC Investment -Equip Replacement 73,762.18 LOGIC Investment -Veh Replacement 476,447.51 LOGIC Investment -Air Condi Replacment 220,873.62 CAPITAL ONE Investment - General Fund 1,351,144.04 Total Cash in Bank & Investments $10,987,588.18 2015-16 360,300 303,202 4,754,503 - fM2014-15 -------- M2013-14 357,436 363,589 356,940 538,568 4,4 - 63,962 3,641,091 2,741,991 2,726,044 1,198,153 585,058 85,_775 ---------- 72,116 --------- - 44,720 16,554 ---------- 25,3 - 98 48,791 30,488 18,572 49,777 1 ---------- 20,939 14,839 ---- 10,460 3,787 7,446 2012-13 292,988 636,964 3,422,107 2,180,145 637,568 177,645 29,444 49,157 11,566 20,778 8,379 7,180 62011-121 1,540,041 228,924 2,439,123 1,871,054 635,719 64,190 27,878 29,919 18,039 26,509 6,127 6,915 Sales Tax - General Fund CITY PUBLIC SERVICE $250,000 00,000 $2 $1 $1 50,000 00,000 50,000 J $ �- OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP --- - - - - -- - _____OCT 2015-161 - -- - - -- - -- 237,314 - - - - -- -- - -- - - -- - - - -- - - - -- - - -- -- - - - - -- ------- -- - - - - - -- - - .........------ - - -- - j 02014 -15 - -- - - -------------------------------------- 215,257 - - - - -- - -- 172,814 _ 172,628 -__ -------------------------------------- 227,438 -------------------------------------- - - -- -- ----------------------- 2013 -14 133,486 115,592 176,520 213,412 132012-13 101,440 94,054 96,303 123,044 - -- - - - - - -- -- - - - - -- -- 02011-12 - - - - -- - -- --------- 96,392 76,414 _____ -- - - - - -- -- - - - - -- 77,398 -- - - - - -- -- - - - - -- - - - -- -- -1 103,230 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2015 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 15 - 2 0 1 6 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 84,200.00 - - - - 84,200.00 0.00% Miscellaneous 47,600.00 809.20 19,060.84 17,340.59 - 30,259.41 36.43% TOTAL REVENUES 131,800.00 809.20 19,060.84 17,340 59 - 114,459.41 7.68% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 10,760.00 - - - - 10,760.00 0.00% TOTAL GENERAL GOVERNMENT 10,760.00 - - - - 10,760.00 0.00% CULTURAL Festival of Angels 15,000.00 5,793.38 4,725.93 5,873.36 6,837.95 2,288.69 84.74% Employee Appreciation Event 13,000.00 - - - 2,919.95 10,080.05 22.46% National Night Out 290.00 - - - - 290.00 0.00% Wilenchik Walk for Life 25,000.00 - - - - 25,000.00 0.00% Schertz Sweetheart 35,000.00 307.46 314.69 307.46 279.19 34,413.35 1.68% Hal Baldwin Scholarship 18,750.00 - 8,085.68 8,662.75 585.00 9,502.25 49.32% Other Events 14,000.00 83.77 4,709.26 1,253.77 1,027.71 11,718.52 16.30% TOTAL CULTURAL!' 121,040.00 6,184.61 17,835.56= 16,097.34 11,649.80 93,292.86 22.92% TOTAL EXPENDITURES 131,800.00 6,184.61 17,835.56 16,097.34 11,649.80 104,052.86 21.05 %« REVENUE OVER(UNDER) EXPEND - 1,243.25 CITY OF SCHERTZ Y -T -D BUDGET 25% OF ENCUMBR BALANCE BUDGET Fund Transfers 000 - 481000 Transfer from Reserves 10,000 - - - - 10,000.00 0.00% 000 - 486100 Transfer In 9,000 - - - - 9,000.00 0.00% 000 - 486101 Transfer In - General Fund 65,200 - - - - 65,200.00 0.00% TOTAL Fund Transfers 84,200' - - - 84,200.00 0.00% Miscellaneous 000 - 491200 Investment Income - 4.20 3.84 10.59 - (10.59) 0.00% 000 - 492200 Wilenchik Walk for Life 25,000 - - - - 25,000.00 0.00% 000 - 493256 Donations - Police Events 3,000 - - - - 3,000.00 0.00% 000 - 493455 Proceeds - Festival of Angels - 255.00 255.00 720.00 - (720.00) 0.00% 000 - 493460 Schertz Sweetheart 850 - - - - 850.00 0.00% 000 - 493621 Hal Baldwin Scholarship 18,750 300.00 18,802.00 16,360.00 - 2,390.00 87.25% 000 - 497000 Misc Income - 250.00 - 250.00 - (250.00) 0.00% TOTAL Miscellaneous s 47,600 809.20 19,060.84 17,340.59 - 30,259.41 36.43 %' TOTAL REVENUES 131,800" 809.20 1'9,060.84 17,340.59 - 114,459.41 13.16% SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 52,028.30 Cash in Investments Texas Class- Special Events 16,816.14 Total Cash in Bank & Investments $ 68,844.44 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31 ST, 2015 2 0 1 5- 2 0 1 6 110-PEG FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBIR BALANCE BUDGET REVENUE SUMMARY Franchises 107,000.00 12,310.30 25,645.50 24,804.30 - 82,195.70 23.18% Fund Transfers 145,500.00 - - - - 145,500.00 0.00% TOTAL REVENUES 252,500.00 12,31030 25,645.50 24,804.30 - 227,695.70 9.82% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 15,444.66 2,762.70 (2,762.70 ) 0.00% TOTAL GENERAL GOVERNMENT 15,444.66 2,762.70 _(2,762.70 ) 0.00% PROJECTS Capital Outlay 252,500.00 252,500.00 0.00% TOTAL PROJECTS 252,500.00 252,500.00 0.00% TOTAL EXPENDITURES 252,500.00 15,444.66 2,762.70 249,737.30 1.09% REVENUE OVER(UNDER) EXPEND 12,310.30 10,200.84 24,804.30 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31 ST, 2015 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421350 Time Warner- PEG Fee 52,000 12,310.00 13,198.00 24,804.30 - 27,195.70 47.70% 000 - 421465 AT &T PEG Fee 55,000 - 12,446.77 - - 55,000.00 0.00% TOTAL Franchises 107,000 12,310.00 25,644.77 24,804.30 82,195.70 23.18 %' Fund Transfers 000 - 481000 Transfer In - Reserves 145,500 - - - - 145,500.00 0.00% TOTAL Fund Transfers 145,500' - - - - 145,500.00 0.00% TOTAL REVENUES 252,500 12,310.00 25,644.77 24,804.30 227,695.70 9.82% PEG FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31ST, 2015 Cash in Bank Cash Balance $ 496,380.04 Total Cash in Bank & Investments $ 496,380.04 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31ST, 2015 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 220,285 - - 2,500.00 - 217,785.00 1.13% Permits 65,000.00 40,699.32 21,185.19 45,625.33 - 19,374.67 70.19% Fees 17,659,700 1,476,193.59 4,363,687.38 4,574,796.47 - 13,084,903.53 25.91% Fund Transfers 813,272 10,830.00 34,278.24 32,490.00 - 780,782.00 3.99% Miscellaneous 143,858 3,490.55 21,808.21 7,119.39 - 136,738.61 4.95% TOTAL REVENUES 18,902,115 1,531,213.46 4,440,959.02 4,662,531.19 14,239,583.81 24.67% BUSINESS OFFICE Personnel Services 467,483 49,734.86 114,707.27 121,874.24 - 345,608.76 26.07% Supplies 4,600 278.98 831.91 1,077.97 266.91 3,255.12 29.24% Human Services 183 - - - - 183.00 0.00% City Support Services 3,035 - 831.00 - - 3,035.00 0.00% Utility Services 700 51.37 - 90.75 51.37 557.88 20.30% Operations Support 139,340 4,004.40 29,972.12 29,259.62 - 110,080.38 21.00% Staff Support 7,300 55.44 138.32 123.20 320.03 6,856.77 6.07% Professional Services 71,000 5,488.20 16,261.75 18,478.20 - 52,521.80 26.03% Maintenance Services 12,000 - 1,780.00 740.00 4,300.00 6,960.00 42.00% Operating Equipment 1,550 - - - - 1,550.00 0.00% Capital Outlay 44,000 - - - - 44,000.00 0.00% TOTAL BUSINESS OFFICE 751,191 59,613.25 164,522.37 ' 171, 643.98 4,938.31 574,608.71 23.51% W & S ADMINISTRATION Personnel Services 1,295,299 142,930.67 305,749.32 332,328.94 - 962,970.06 25.66% Supplies 187,150 4,801.73 2,428.83 71,683.16 4,521.72 110,945.12 40.72% Human Services 1,000 - - - - 1,000.00 0.00% City Support Services 59,900 518.30 35,027.56 38,500.16 652.65 20,747.19 65.36% Utility Services 3,438,500 217,469.02 687,586.26 765,592.20 140,182.39 2,532,725.41 26.34% Operations Support 6,545 1,140.98 549.94 1,187.97 55.55 5,301.48 19.00% Staff Support 33,850 4,322.44 5,596.85 6,841.50 3,461.97 23,546.53 30.44% City Assistance 1,900 201.00 - 243.00 - 1,657.00 12.79% Professional Services 183,838 4,202.60 19,479.16 6,692.60 - 177,145.40 3.64% Fund Charges /Transfers 3,856,374 363,457.16 1,141,688.60 1,440,371.44 - 2,416,002.56 37.35% Maintenance Services 7,026,115 517,044.82 1,370,034.22 1,373,188.94 101,759.70 5,551,166.36 20.99% Other Costs 35,000 - 27,150.20 27,150.20 - 7,849.80 77.57% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31ST, 2015 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 202 -WATER & SEWER FINANCIAL SUMMARY CURRENT BUDGET CURRENT PRIOR YEAR PERIOD Y -T -D ACTUAL Y -T -D ACTUAL Y -T -D ENCUMBR BUDGET BALANCE 25% OF BUDGET Debt Service 1,453,258 - - - - 1,453,258.00 0.00% Rental- Leasing 6,070 - 709.61 - 477.56 5,592.44 7.87% Operating Equipment 8,000 - 6,525.13 - 399.98 7,600.02 5.00% Capital Outlay 11,881 - - 32,904.13 - (21,023.13) 276.95% TOTAL PUBLIC WORKS 17,604,680 1,256,088.72 3,602,525.68 4,096,684.24 251,511.52 13,256,484.24 2410% MISC & PROJECTS PROJECTS Fund Charges /Transfers 500,000 - - - 500,000.00 0.00% TOTAL PROJECTS 500,000 - - - - 500,000.00 0.00 % TOTAL MISC & PROJECTS 500,000 - - - - 500,000.00 0.00 % TOTAL EXPENDITURES 18,855,871 1,315,701.97 3,767,048.05 ` 4,268,328.22 256,449.83 14,331,092.95 24.00 %1 ` REVENUE OVER(UNDER)EXPENSES " 46,244 394,202.97 202 -WATER & SEWER REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31 ST, 2015 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421490 Tower Leasing 220,285 - - 2,500.00 - 217,785.00 1.13% TOTAL Franchises 220,285 - - 2,500.00 - 217,785.00 1.13 %` Permits 000 - 432400 Development Permit 65,000 40,699.32 21,185.19 45,625.33 - 19,374.67 70.19% TOTAL Permits 65,000 40,699.32 21,185.19 45,625.33 - 19,374.67 70.19% Fees 000 - 455200 Garbage Collection Fee 4,150,000 347,005.01 1,018,174.27 1,062,926.32 - 3,087,07168 25.61% 000 - 455600 Fire Line Fees 25,700 - 25,920.00 - - 25,700.00 0.00% 000 - 455700 Recycle Fee Revenue 275,000 23,051.61 67,407.93 69,055.28 - 205,944.72 25.11% 000 - 455800 W &S Line Constructn Reimbursemnt 25,000 1,104.00 5,661.00 5,278.00 - 19,722.00 21.11% 000 - 457100 Sale of Water 8,180,000 631,837.49 1,940,646.17 2,133,216.15 - 6,046,783.85 26.08% 000 - 457110 Edwards Water Lease 97,000 - 97,335.00 - - 97,000.00 0.00% 000 - 457120 Water Transfer Charge -Selma 42,000 - - 17,740.68 - 24,259.32 42.24% 000 - 457130 Water Transfer Charge -U. C. 10,000 - - 22.42 - 9,977.58 0.22% 000 - 457140 Water Transfer Charge- Converse 30,000 - - 8,368.38 - 21,631.62 27.89% 000 - 457200 Sale of Meters 90,000 3,643.00 17,448.14 18,318.00 - 71,682.00 20.35% 000 - 457400 Sewer Charges 4,532,000 448,650.05 1,133,764.81 1,199,094.53 - 3,332,905.47 26.46% 000 - 457500 Water Penalties 200,000 20,677.43 56,680.06 58,673.58 - 141,326.42 29.34% 000 - 458300 Sale of Property /Auction 500 - - - - 500.00 0.00% 000 - 459200 NSF Check Fee -Water &Sewer 2,500 225.00 650.00 625.00 - 1,875.00 25.00% TOTAL Fees 17,659,700 1,476,193.59 4,363,687.38 4,573,318.34 - 13,086,381.66 25.90% Fund Transfers 000 - 481000 Transfer In- Reserve 500,000 - - - - 500,000.00 0.00% 000 - 486103 Transfer In- Vehicle Reserves 44,000 - - - - 44,000.00 0.00% 000 - 486204 Interfnd Chrg- Drainage Bill 129,960 10,830.00 34,278.24 32,490.00 - 97,470.00 25.00% 000 - 486411 Transfer In- Capital Recovery 139,312 - - - - 139,312.00 0.00% TOTAL Fund Transfers 813,272 1'0,830.00 34,278:24 32,490.00 = 780,782.00 199 %' 202 -WATER & SEWER REVENUES Miscellaneous CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31 ST, 2015 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 490000 Misc Charges 500 123.00 223.00 273.00 - 227.00 54.60% 000 - 491000 Interest Earned 1,500 57.31 396.42 165.59 - 1,334.41 11.04% 000 - 491200 Investment Income 5,000 507.81 (2,300.44) 1,216.16 - 3,783.84 24.32% 000 - 497000 Misc Income -W &S 15,000 2,802.43 (5,199.90) 5,464.64 - 9,535.36 36.43% 000 - 498110 Reimbursement -SSLGC 121,858 - 28,689.13 - - 121,858.00 0.00% TOTAL Miscellaneous 143,858 3,490.55 21,808.21 7,11939 - 136,738.61 4.95% TOTAL REVENUES 18,902,115 1,531,213.46 4,440,959.02 4,661,05106 - 14,241,061.94 24.66 %' WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31ST, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $1,099,792.68 Cash in Investments Lone Star Investment -Water &Sewer Lone Star Investment -W &S Customer Deposits Lone Star Investment -W &S Equip Replacement Lone Star Investment -W &S Veh Replacement Schertz Bank & Trust - Certificate of Deposit 1,072,436.80 295, 928.39 177,926.03 257,030.36 1,068,630.27 $ 2,871,951.85 Total Cash in Bank & Investments $3,971,744.53 CITY O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31 ST, 2015 2D15'2O1G 2034EK8S CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBIR BALANCE BUDGET REVENUE SUMMARY F000 5,888,640 518,846.44 1,487,238.80 1.414,677.57 - 4,451.082.43 2411% Inter-Jurisdictional 1.742.807 (44/400.70) 409.777.60 424.280.46 - 1.318.518.54 24.35% Miscellaneous 131,850 —__1,801.2y0 3547670 25,129.14 ----------_ 106,720.8K6 19.06% TOTALREVENUES 7,741,297 476,240.94 1,912,493.10 1,864,09517 - 5,877,201.83 24.08% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 3,407.571 302.100.61 830.738.06 808.31017 - 2.538.200�83 25.48% Supplies 418.831 66.18845 63.774.61 107.04749 43.75227 268.031.24 36.0% Human Services 1.000 - 324.00 - - 1.000.00 0.0% City Support Services 34.050 1.050.76 14.017.51 15.534�84 - 18.31510 44.58% Utility Services 134.840 7.704.61 21.913.86 15.803.31 1.197.86 117.77&83 12.65% Operations Support 102.235 11.533.45 31.983.86 19.052.41 1.23917 81.343.42 20.43% Staff Support 84,600 7.586.50 11.999.99 13,20920 7,845.75 03.545.05 24.89% City Assistance 13/400 1.539.00 1.149.53 1.539.00 68545 11.175.55 10.00% Professional Services 107.00 2.623.01 29.739.36 32.18219 427.33 74.390.48 30.48% FundCharges/Transfers 2.556,485 271.895.59 402.079.59 079.348.93 - 1.07.136.07 26.57% Maintenance Gorviooa 07.100 2.527.84 860.00 12.210.48 - 54.883.52 18.21% Debt Service 205.498 - - - - 205.498.00 0.00% Rental-Leasing 81.541 5.795.07 23.180.28 17.385.21 52.155.63 12.00010 85.28% Operating Equipment 234.500 349.47 4.117.11 420.50 18.137.53 215.935.97 7.92% Capital Outlay —_109\000 ---____-_ - --794,744<00 -_ _(6}5,7u44J}0) 729L12% TOTAL PUBLIC SAFETY 7,558,451 741,58636 2,577,45973 125,440.99 4,855,550.28 ! , TOTAL EXPENDITURES 7,558,451 741,58636 1,443,07776 2,577,459.73 125,440.99 4,855,550.28 35.76% -' REVENUE OVER(UNDER) EXPENSES - 182,846 CITY O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31ST, 2015 2 014-2Q15 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y�-D BUDGET 25Y6OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000-450100 Ambu|onno/MUeageTnansport 5.717.840 484.124.39 1.434.894.01 1.341.810.37 - 4.376.029.03 23.4896 000-456110 Subscription Program Fees 40.000 20.000.00 7.325.00 21.595.00 - 18/05.00 53.99% 000-456120 EMTC!aoo - Feos 87.000 24.475.00 20.505.95 35.094.47 - 51.905.53 40.3496 000-456130 Immunization Fees - 7'730.00 - 8.266.00 - (8.266.00) 0.00% 000-450140 BiUingFees - A|omoHeights 22.000 1.527.05 4.258.24 4.174.23 - 17.825.77 18.87% 008-458110 Sales uf Merchandise -GuvDea| - - 155�0O 30375U - /3.037.50\ U.U0Y6 TOTAL Fees 5,866,640 518,846.44 1,467,238.80 1,414,677.57 - 4,451,962.43 24.11% 000-473500 Seguin/Guadalupe CoSupport 294.710 N4/406.70\ 71.531.64 75.899.70 - 218.710.30 25.79% 000-474300 Cibo|oSupport 289.225 - 65.348.25 67.306.25 - 201.91875 25.00% 000-475100 Como|CoESO#8 98.079 - 22.772.10 23.362.50 - 74.718.50 23.82% 000-475200 Live Oak Support 202.820 - 47.302.50 48.812.50 - 154.013.50 24.0796 000-475300 Universal City Support 254.788 - 61.843.88 63.098.88 - 101.081.12 25.00Y6 000-475400 Selma Support 104.528 - 18.48875 19.043J5 - 85.484.25 18.22% 000-475500 Schertz Support 494.024 - 116.422.01 119.910.31 - 374.113.69 24.27% 000-475000 Santa Clara Support 0.900 - 2.418.69 2.402.19 - 7.476.81 25.00Y6 000-475800 Marion Support 14,658 -__ 355778 386438 -__ 1090362 25.00% TOTAL Inter-Jurisdictional 1,742,807 (44,406.70) 409,777.60 424,288.46 - 1,318,518.54 24.35% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31 ST, 2015 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4 - 2 0 1 5 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 100 - 11.08 2.87 - 97.13 2.87% 000 - 491200 Investment Income 750 22.10 - 319.58 - 430.42 42.61% 000 - 493203 Donations -EMS 2,000 50.00 490.00 150.00 - 1,850.00 7.50% 000 - 493205 Donations- Golf Tournament 9,000 - - - - 9,000.00 0.00% 000 - 497000 Misc Income 110,000 1,389.10 33,662.51 22,687.89 - 87,312.11 20.63% 000 - 497100 Recovery of Bad Debt 10,000 340.00 1,313.11 1,968.80 - 8,031.20 19.69% TOTAL Miscellaneous 131;850 1,801.20 35,476.70 25,129.14 - 106,720.86 1`9.06 %' TOTAL REVENUES 7,741,297 476,24'0.94 1,91,2,493.10 1,864,095.17 - 5,877,201.83 24.08% SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31ST, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ (192,760.54) Cash in Investments Texas Class- Tax Note 2015 Ambulances 88,707.75 Total Cash in Bank & Investments CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31 ST, 2015 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY 471,053 45,194.69 121,700.60 117,654.17 Permits 3,000 260.00 640.00 680.00 - 2,320.00 22.67% Fees 1,083,000 92,752.27 268,392.35 277,026.40 - 805,973.60 25.58% Fund Transfers 213,920 - - - - 213,920 0.00% Miscellaneous 80,700 367.42 280.70 903.61 - 79,796.39 1.12% TOTAL REVENUES 1,594,540 93,379.69 269,313.05 278,610.01 - 1,315;929.99 17.47 %e »�t7ir�1��.YlJJi1��F_131 PUBLIC WORKS DRAINAGE Personnel Services 471,053 45,194.69 121,700.60 117,654.17 - 353,398.83 24.98% Supplies 8,300 573.79 953.11 1,171.39 251.97 6,876.64 17.15% Human Services 325 - - - - 325.00 0.00% City Support Services 28,500 - 2,306.64 2,556.92 - 25,943.08 8.97% Utility Services 30,370 1,156.58 4,310.75 2,712.21 35.57 27,622.22 9.05% Operations Support 2,460 - 20.48 - - 2,460.00 0.00% Staff Support 8,116 141.01 836.16 1,146.81 25.06 6,944.13 14.44% City Assistance 840 120.00 - 120.00 - 720.00 14.29% Professional Services 24,500 - 198.00 13,000.00 - 11,500.00 53.06% Fund Charges/Transfers 215,573 17,881.08 55,204.47 53,643.28 - 161,929.72 24.88% Maintenance Services 21,000 289.13 68.00 729.03 - 20,270.97 3.47% Other costs 200 - - 100.00 100.00 50.00% Debt Service 135,294 - - - 135,294.00 0.00% Rental /Leasing 500 - - - - 500.00 0.00% Operating Equipment 5,500 - 560.00 - - 5,500.00 0.00% Capital Outlay 54,500 - - - - 54,500.00 0.00% TOTAL DRAINAGE 1,007,031 65,356.28 1!86,15821 192,733.81 412.60 813,884.59 19.18 % PROJECTS Professional Services - - 5,133.00 - 8,000.00 (8,000.00) 0.00% Maintenance Services 213,920 - 3,287.67 13.59 - 213,906.41 0.01% TOTAL PROJECTS `; 213,920 - 8,420.676 13:59 8,000.00 205906.41 - 3.75% TOTAL EXPENDITURES 1,220,951 65;356.28 194,578.881 192,747.40 8,412.60 1,019,791.00 ? 16.48% - REVENUE OVER(UNDER) EXPEND 373,589 85,862.61 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31ST, 2015 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000 - 432400 Floodplain Permit 3,000 260.00 640.00 680.00 - 2,320.00 22.67% TOTAL Permits 3,000 260.00 640.00 680.00 - ` 2,320.00 22.67 %'! Fees 000 - 457500 Drainage Penalties 8,000 1,030.69 2,263.73 2,537.65 - 5,462.35 31.72% 000 - 457600 Drainage Fee 1,075,000 91,721.58 266,128.62 274,488.75 - 800,511.25 25.53% TOTAL Fees 1,083,000 92,752.27 268,392.35 277,026.40 - 805,973.60 25.58 %`' Fund Transfers 000 - 481000 Transfer In 213,920 - - - - 213,920.00 0.00% TOTAL Funds Transfers' 213,920 - - - - 213,920 0.00% Miscellaneous 000 - 491000 Interest Earned 100 2.09 71.08 11.03 - 88.97 11.03% 000 - 491200 Investment Interest 500 36533 209.62 892.58 - (392.58) 178.52% 000 - 493204 Donations- Drainage Project 80,000 - - - 80,000.00 0.00% 000 - 497000 Misc Income - Drainage 100 - - - - 100.00 0.00% TOTAL Miscellaneous 80,700 367.42 280.70 903.61 - 79,796.39 1.12 %? TOTAL REVENUES 1,380,620 93,379.69 269,313.05 278,610.01 - 1,102,009.99 20.18 %`i DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31 ST, 2015 Cash in Bank Claim on Operating Cash Pool-Checking 53,350.55 Cash in Investments Lone Star Investment-Drainage Maint Fund 807,271.99 Total Cash in Bank & Investments $ 860,622.54 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31ST, 2015 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *•. 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET I: ajok,l1J�al�J�i►� /e1:�'1 Taxes 592,707 76,483.05 115,423.12 120,345.40 - 472,361.60 20.30% Miscellaneous 570 142.25 99.73 362.59 - 207.41 63.61% TOTAL REVENUES 593,277 ` 76,625.30 115,522.85 120,707.99 - 472,569.01 20.35 %' EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 65,500 16,936.42 14,350.90 21,191.77 - 44,308.23 3235% Operations Support 66,425 7,206.00 2,786.00 9,290.00 - 57,135.00 13.99% Professional Services 3,000 - 3,000.00 0.00% Fund Charges /Transfers 114,405 - 16,601.25 - - 114,405.00 0.00% Maintenance Services 10,000 - - - - 10,000.00 0.00% Operating Equipment - - - - 1,712.60 (1,712.60) 0.00% TOTAL NONDEPARTMENTAL 259,330 24,142.42 33,738.15 30,481.77 1,712.60 227,135.63 12.41% TOTAL EXPENDITURES 259,330? 24,142.42 33,738.15 30,481.77 1,712.60 227,135.63 12.41 %' REVENUE OVER(UNDER) EXPENDITURE 333,947 90,226.22 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31ST, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 399,984.11 Cash in Investments Texas Class - Hotel Tax 500,016.57 Total Cash in Bank & Investments $ 900,000.68 HOTEL OCCUPANCY TAX $80,000 $70,000 - - - - - -- -- -- - - - - - - - $60,000 $50,000 aa, 0 000 $40,000 - - - -- - - - - - - - - -- - - I - $30,000 $20,000 - - - - - - - - - - -- - - - - -- - - - - - - $10,000 $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP - - -- - -- _ - - -------------- 0-2015-161 40,800 ------------ --- - ------------ 40,351 -- - - - - -- - - - - - -- 38,394 --- - - - - -- -- - - - - -- --- - - - - -_ --- - - - - -- - - - -- - - -- -- - - - - - - -- -- - - - - -- -- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- -- - - - - -- - - - - - -- --- - - - - -- ---- - - - - -� 2014 -15 44,724 42,229 35,309 33,055 462037 58,530 43,715 43,525 53,346 72,297 51,772 39,195 201314 40,023 40,709 33,342 29,778 36,680 56,699 48,081 49,579 54,858 67,329 57,399 34,297 2012 -13 35,851 39,439 32,392 32,120 31,531 49,811 39,900 39,692 54,395 61,999 51,840 34,297 2011 -12 33,128 32,675 32,143 35,829 36,215 45,071 36,518 1 40,335 48,397 53,622 46,551 29,807 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2015 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 111,129 - - - - 111,129.00 0.00% Miscellaneous 100 12.97 26.24 905.26 - (805.26) 905.26% TOTAL REVENUES 111,229 12.97 26.24 905.26 - 110,323.74 0.81% EXPENDITURE SUMMARY PARKLAND DEDICATION Operating Equipment 14,800 - - - - 14,800.00 0.00% Capital Outlay 20,000 - - - 7,184.49 12,815.51 35.92% TOTAL PARKLAND DEDICATION 34,800 - - 7,184.49 27,615.51 20.65 %` TOTAL EXPENDITURES 34,800 - - 7,184.49 27,615.51: 20.65 %' REVENUE OVER(UNDER) EXPEND 76,429 ` 905.26 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2015 k********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458800 Parkland Dedication 111,129 - - - - 111,129.00 0.00% TOTAL Fees 111,129 - - - - 111,129.00 0.00 %; Miscellaneous 000 - 491000 Interest Earned 75 10.52 26.08 32.12 - 42.88 42.83% 000 - 491200 Investment Interest 25 2.45 0.16 3.02 - 21.98 12.08% 000 - 497000 Misc Income - - - 870.12 - (870.12) 0.00% TOTAL Miscellaneous 100 12.97 26.24 905.26 - (805:26) 905.26 %> TOTAL REVENUES 111,229 12.97 26.24 90526 ' - 1;10,323:74 0.81% PARK FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $158,672.75 Cash in Investments Texas Class- Park Fund 76,359.61 Total Cash in Bank & Investments $235,032.36 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2015 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *. 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 40,000 8,330.00 65,475.00 37,655.00 - 2,345.00 94.14% Miscellaneous 250 81.97 66.66 235.15 - 14.85 94.06% TOTAL REVENUES 40,250 8,411.97 65,541.66 37,890.15 - 2,359.85 94.14% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services -Trees 27,000 - 300.00 140.00 - 26,860.00 0.52% TOTAL TREE MITIGATION 27,000 - 300.00 140.00 - 26,860.00 0.52% TOTAL EXPENDITURES 27,000 - 300.00 140.00 - 26,860.00 0.52 %s REVENUE OVER(UNDER) EXPEND 13,250 37,750.15 ' CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2015 t********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *, 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458900 Tree Mitigation 40,000 8,330.00 65,475.00 37,655.00 - 2,345.00 94.14% TOTAL Fees 40,000 8,330.00 65,475.00 37,655.00 2,345`.00 =94.14% Miscellaneous 000 - 491000 Interest Earned 150 2.83 43.50 11.56 - 138.44 7.71% 000 - 491200 Investment Interest 100 79.14 23.16 22159 - (123.59) 223.59% TOTAL Miscellaneous 250 81.97 66.66 235.15 14.85 94;06% TOTAL REVENUES 40,250 8,411.97 65,541 >.66 37,890.15 - 2,359.85 94.14 %I TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $65,837.44 Cash in Investments MBIA Investment-Tree Mitigation 317,879.15 Total Cash in Bank & Investments $383,716.59 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2015 2 0 1 5- 2 0 1 6********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *. 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 920,000 49,878.00 253,791.00 246,456.00 - 673,544.00 26.79% Fund Transfers 2,550,541 - - - - 2,550,541.00 0.00% Miscellaneous 6,600 1,158.34 1,450.30 2,79137 - 3,806.63 42.32% TOTAL REVENUES 3,477,141 51,036.34 255,241.30 249,249 37 - 3,227,891.63 7.17 %' EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 5,000 - - - - 5,000.00 0.00% Professional Services 106,000 - - - - 106,000.00 0.00% Maintenance Services 1,000 - - - - 1,000.00 0.00% TOTAL NON DEPARTMENTAL 112,000 - - - - 112,000.00 0.00 %I MISC & PROJECTS PROJECTS Professional Services 315,141 - - - 186,732.71 128,408.29 59.25% Fund Charges/Transfers 3,050,000 366,594.84 - 366,594.84 - 2,683,405.16 12.02% TOTAL MISC & PROJECTS 3,365,141 366,594.84 - 366,594.84 186,732.71 2,811,813.45 16.44 %'; TOTAL EXPENDITURES 3,477,141 366,594.84 - 366,594:84 186,732.71 2,923,813.45 15.91% REVENUE OVER(UNDER) EXPENDITURES - (117,34547)i CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2015 2 0 1 4- 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455900 Capital Recovery - Water 920,000 49,878.00 253,791.00 246,456.00 - 673,544.00 26.79% TOTAL Fees 920,000 49,878.00 253,791.00 246,456.00 673,544.00 26.79 %i Fund Transfers 000 - 481000 Transfer from Reserves 2,550,541 - - - - 2,550,541.00 0.00% TOTAL Fund Transfers 2,550,541 - - - - 2,550,541.00 0.00 % ` Miscellaneous 000 - 491000 Interest Earned 600 65.95 172.27 199.47 - 400.53 33.25% 000 - 491200 Investment Income 6,000 1,092.39 1,278.03 2,593.90 - 3,406.10 43.23% TOTAL Miscellaneous 6,600 1,158.34 1,450.30 2,793:37 - 3,806.63 42.32 %a! TOTAL REVENUES 3,477,141 51,03634 255,241.30 249,249'.37 - 3,227,891.63 7.17 % CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $ 1,195,615.75 Cash in Investments Lone Star Investment - Capital Recovery Water 4,501,598.84 Total Cash in Bank & Investments $ 5,697,214.59 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2015 2 0 1 5- 2 0 1 6********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *. 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 550,000 23,484.00 137,114.64 110,616.00 - 439,384.00 20.11% Fund Transfers 3,077,712 - - - - 3,077,712.00 0.00% Miscellaneous 16,000 (1,392.79) 1,847.55 (5,68115} - 21,683.15 - 35.52% TOTAL REVENUES 3,643 712 22,091.21 138,962.19 104,932:85 - 3,538,779.15 2.88 %'' EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 84,000 358.19 1,073.97 1,077.08 - 82,922.92 1.28% Fund Charges /Transfers 139,312 - - - - 139,312.00 0.00% Maintenance Services 320,400 - - - - 320,400.00 0.00% TOTAL NON DEPARTMENTAL 543,712 358.19 1,073.97 1,077.08 - 542,634.92 0.20 %'' MISC & PROJECTS Professional Services 100,000 - - - - 100,000.00 0.00% Sewer Projects 3,000,000 - - - - 3,000,000.00 0.00% TOTAL MISC &PROJECTS 3,100,000 - - - - 3,100,000.00 0.00% TOTAL EXPENDITURES 3,643,712 358.19 1,073.97 1,077.08 - 3,642,634.92 0.03 %'' REVENUE OVER(UNDER) EXPENDITURES - 1'03,855.77 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2015 2 0 1 4- 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455910 Capital Recovery -Waste Wtr 500,000 21,684.00 113,714.64 103,416.00 - 396,584.00 20.68% 000 - 455913 Cap Recovery -North Sewer Tr 50,000 1,800.00 23,400.00 7,200.00 - 42,800.00 14.40% TOTAL Fees 550,000 23,484.00 137,114.64 110,616100 439,384.00 20.11 %6 Fund Transfers 000 - 481000 Transfer from Reserves 3,077,712 - - - - 3,077,712.00 0.00% TOTAL Fund Transfers 3,077,712 - - - - 3,077,712.00 0.00 % ' Miscellaneous 000 - 491000 Interest Earned 1,000 38.93 100.25 111.57 - 888.43 11.16% 000 - 491200 Investment Income 15,000 3,767.04 6,849.81 11,616.17 - 3,383.83 77.44% 000 - 491800 Gain /Loss - (30,779.00) (78.68) (30,460.28) - 30,460.28 0.00% 000 - 491900 Unrealized Gain /Loss -Cap One - 25,580.24 (5,023.83) 13,049.39 - (13,049.39) 0.00% TOTAL Miscellaneous 16,000 (1,392.79) 1,847.55 (5,683.15) - 21,683.15 - 35.52 % TOTAL'' REVENUES 3,643,712 22,09111 138,962.19 104,932.85 - 3,538,779.15 2.88 % s CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 850,492.19 Cash in Investments Capital One-Investment 1,731,491.80 Total Cash in Bank & Investments $ 2,581,983.99 505 -TAX I &S FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2015 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 5,722,162 2,639,364.66 2,974,847.19 3,007,482.96 - 2,714,679.04 52.56% Miscellaneous 369,213 4,185,275.03 269.19 4,185,598.94 - (3,816,385.94) 1133.65% TOTAL REVENUES 6,091,375 6,824,639.69 2,975,116.38 7,193,081.90 - (1,101,706.90) 118.09 °Io'' EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 102,500 82,224.23 950.00 82,774.23 - 19,725.77 80.76% Debt Service 5,718,918 (96,883.60) - (96,883.60) - 5,815,801.60 - 1.69% Other Financing Sources - 4,220,709.38 - 4,220,709.38 - (4,220,709) 0.00% TOTAL GENERAL GOVERNMENT 5,821,41!8 4,206,050.01 950.00 4,206,600.01 r - 1,614,817.99 72.26°%0` TOTAL EXPENDITURES 5,821,418 4,206,050.01 950.00 4,206,600.01 - 1,614,817.99 72.26 %S " REVENUE OVER(UNDER) EXPEND 269,957 2,986,481.89 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2015 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 505 -TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000 - 411900 Property Tax Revenue 5,722,162 2,639,364.66 2,974,847.19 3,007,482.96 - 2,714,679.04 52.56% TOTAL Taxes 5,722,162 2,639,364.66 2,974,847.19 3,007,482.96 - 2,714,679.04 52.56% Miscellaneous 000 - 491000 Interest Earned 75 41.18 21.39 62.95 - 12.05 8193% 000 - 491200 Investment Earnings 2,000 23185 247.80 535.99 - 1,464.01 26.80% 000 - 495015 Contribution from SED 367,138 - - - - 367,138.00 0.00% 000 - 498000 Proceeds From Refunding Det - 4,185,000.00 - 4,185,000.00 - (4,185,000.00) 0.00% TOTAL Miscellaneous 369,213 4,185,275.03 269.19 4,185,598.94 - (3,816,385.94) 1133.65% TOTAL REVENUES 6,091,375 6,824,639.69 2,975,116.38 7,193,081.90 - (1,101,706.90) 118.09% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2015 505 -TAX 1& S ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF NON DEPARTMENTAL BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101 - 541500 Paying Agent 2,500 - - 550.00 - 1,950.00 22.00% 101 - 541502 Cost of Bond Issuance 100,000 82,224.23 - 82,224.23 - 17,775.77 82.22% TOTAL Professional Services 102,500 82,224.23 - 82,774.23 - 19,725.77 80.76% Debt Service 101 - 555612 Bond -GO Refunding 2010 - Principa 275,000 - - - - 275,000.00 0.00% 101 - 555612.1 Bond -GO Refunding 2010 Interest 55,425 - - - - 55,425.00 0.00% 101 - 555626 LS &D SR2006- Principal 400,000 (5,227.50) - (5,227.50) - 405,227.50 -1.31% 101 - 555626.1 LS &D SR2006- Interest 189,419 (8,000.00) - (8,000.00) - 197,419.00 -4.22% 101 - 555628 CO Bond 2007 - Principal 122,800 - - - - 122,800.00 0.00% 101 - 555628.1 CO Bond 2007 - Interest 4,925 - - - - 4,925.00 0.00% 101 - 555629 GO Bond 2007 - Principal 265,000 - - - - 265,000.00 0.00% 101 - 555629.1 GO Bond 2007 - Interest 159,036 - - - - 159,036.00 0.00% 101 - 555630 GO Bond SR2008 Principal 440,000 - - - - 440,000.00 0.00% 101 - 555630.1 GO Bond SR2008 Interest 296,946 - - - - 296,946.00 0.00% 101 - 555631 GO Bond SR2009 Principal 540,000 - - - - 540,000.00 0.00% 101 - 555631.1 BO Bond SR2009 Interest 282,675 - - - - 282,675.00 0.00% 101 - 555633 GO SR2011 Principal 225,000 - - - - 225,000.00 0.00% 101 - 555633.1 GO SR2011 Interest 341,663 - - - - 341,663.00 0.00% 101 - 555634 GO SR2011A Refund Principal 605,000 - - - - 605,000.00 0.00% 101 - 555634.1 GO SR2011A Refund Interest 116,675 - - - - 116,675.00 0.00% 101 - 555635 GO SR2012 Principal 310,000 - - - - 310,000.00 0.00% 101 - 555635.1 GO SR2012 Interest 194,721 - - - - 194,721.00 0.00% 101 - 555636 Tax Note - SR2013 - Principal 170,000 - - - - 170,000.00 0.00% 101 - 555636.1 Tax Note - SR2013 - Interest 5,950 - - - - 5,950.00 0.00% 101 - 555637 Tax Note - SR 2013A - Principal 160,000 - - - - 160,000.00 0.00% 101 - 555637.1 Tax Note - SR2013 - Interest 5,265 - - - - 5,265.00 0.00% 101 - 555638 Bond -GO 2014 Refund - Principal 100,000 - - - - 100,000.00 0.00% 101 - 555638.1 Bond -GO 2014 Refund- Interest 294,275 - - - - 294,275.00 0.00% 101 - 555639 Tax Note - SR2015 - Principal 35,000 - - - - 35,000.00 0.00% 101 - 555639.1 Tax Note - SR2015 - Interest 3,763 - - - - 3,763.00 0.00% 101 - 555900 Debt Service 120,380 - - - - 120,380.00 0.00% 101 - 555800 Bond Premium - (83,656.10) - (83,656.10) - 83,656.10 0.00% TOTAL Debt Service 5,718,918 (96,883.60) - (96,883.60) - 5,815,801.60 - 1.69 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2015 505 -TAX 1& S ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF NON DEPARTMENTAL BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Other Financing Sources 101 - 556300 Payment to Refund Debt - 4,220,709.38 - 4,220,709.38 - (4,220,709.38) 0.00% TOTAL Other financing Sources - 4,220,709 - 4,220,709.38 - (4,220,709.38) 0.00°1x' TOTAL EXPENDITURES 5,821,418 4,206,050.01 - 4,206,600.01 - 5,835,527.37 72.26 %' TAX I&S CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 1,786,686.41 Cash in Investments IVIBIA Investment- Tax I&S 2,046,972.74 Total Cash in Bank & Investments $ 3,833,659.15 620 -SED CORPORATION FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2015 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BUDGET 25% OF BALANCE BUDGET REVENUE SUMMARY Taxes 3,518,362 393,215.84 865,807.08 908,085.45 - 2,610,276.55 25.81% Miscellaneous 10,200 5,055.44 5,062.50 8,019.47 - 2,180.53 78.62% TOTAL REVENUES 3,528,562 398,271.28 870,869.58 916,104.92 - 2,612;457.08 25;96% Immaklialloul ECONOMIC DEVELOPMENT Personnel Services 325,458 30,389.13 39,035.97 65,184.68 - 260,273.32 20.03% Supplies 750 49.27 182.62 49.27 - 700.73 6.57% Human Services 1,000 - - - - 1,000.00 0.00% City Support Services 12,545 876.00 1,114.09 1,135.05 610.99 10,798.96 13.92% Utility Services 4,820 224.15 214.82 443.48 90.22 4,286.30 11.07% Operations Support 140,500 904.89 50,913.21 1,446.63 1,387.11 137,666.26 2.02% Staff Support 19,100 1,408.45 1,336.32 1,408.45 778.41 16,913.14 11.45% City Assistance 1,005,000 50.70 - 50.70 - 1,004,949.30 0.01% Professional Services 87,500 - 331.50 - 4,655.40 82,844.60 5.32% Fund Charges /Transfers 418,138 4,252.00 26,022.99 12,756.00 - 405,382.00 3.05% Debt Service 161,216 - - - - 161,216.00 0.00% Operating Equipment 1,700 - - - - 1,700.00 0.00% Capital Outlay 40,000 - - - - 40,000.00 0.00% TOTAL ECONO DEVELOPMENT 2,217,727 38,154.59 119,151.52 82,474.26 ` 7,522.13 2,127,730.61 4.06%' - MISC & PROJECTS PROJECTS 441,775 682.50 - 1,057.50 78935 439,928.15 0.42% TOTAL MISC &?PROJECTS 441,775 682.50 1,057.50 789.35 439,928.15 0.00% TOTAL EXPENDITURES 2,659,502 38,837.09 119,151.52 83,531.76 8,311.48 2,567,658.76 3.45% " REVENUE OVER(UNDER) EXPEND 869,060 ' 832,573.16 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $ 1,380,638.08 Cash in Investments Texas Class Investment - Economic Development Corl 7,590,913.76 Schertz Bank & Trust - Certificate of Deposit 1,052,186.85 Total Cash in Bank & Investments $ 10,023,738.69 4B SALES TAX By Collection Month 41 �� C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING DECEMBER 31st, 2015 I T Y O F S C H E R T INVESTMENT REPORT FOR MONTH ENDING DECEMBER 31st, 2015 INVESTMENT POOLS Beginning Book Value Yiel Deposits/ Purchases Interest Withdrawals Earns Ending Book Value Ending Mkt Value Par Value Maturity Date Weighted Avva Mat. OPERATIONS -BANK CASH Schertz Bank & Trust - Pooled Cash 11,326,637.00 0.0500 7,189,062.27 9,215,237.97 457.96 9,300,919.26 9,300,919.26 9,300,919.26 N/A Schertz Bank & Trust - PEG Fund 484,069.74 0.0000 12,310.30 - - 496,380.04 496,380.04 496,380.04 N/A TOTAL OPERATIONS '11,810,706.74 :7,201,372.57 - 9,215;237.97 457.96- 9,797,299.30 x:9,797,299 =.30 9,797,299.30 - LOGIC General Fund 3,946,353.05 0.2331 1,250,000.00 - 812.37 5,197,165.42 5,197,165.42 5,197,165.42 N/A 37 Days G /F- Equipment Replacement 73,747.59 0.2331 - - 14.59 73,762.18 73,762.18 73,762.18 N/A 37 Days G /F- Vehicle Replacement 307,073.51 0.2331 169,309.00 - 65.00 476,447.51 476,447.51 476,447.51 N/A 37 Days G/F -Air Conditioner Replacement 196,334.15 0.2331 24,500.00 - 39.47 220,873.62 220,873.62 220,873.62 N/A 37 Days SR2009 Bond- Street Projects(II) 1,031,545.98 0.2331 - - 204.27 1,031,750.25 1,031,750.25 1,031,750.25 N/A 37 Days TOTAL SLOGIC ;'5,555,054.28 y1,443,809.00 - (:1,135.70'. 6,999,998.98 6.,999,998.98 - 6,999,998.98 - LONESTAR Capital Recovery - Sewer 1,954,797.63 0.2900 - - 474.48 1,955,272.11 1,955,272.11 1,955,272.11 N/A 65 Days Capital Recovery - Water 4,500,506.45 0.2900 - - 1,092.39 4,501,598.84 4,501,598.84 4,501,598.84 N/A 65 Days Drainage Fund 807,076.09 0.2900 - - 195.90 807,271.99 807,271.99 807,271.99 N/A 65 Days Facilities Master Plan 145,382.18 0.2900 - - 35.29 145,417.47 145,417.47 145,417.47 N/A 65 Days GO SR2011 Animal Shelter 8,599.44 0.2900 - - 2.09 8,601.53 8,601.53 8,601.53 N/A 65 Days GO SR2011 Soccer Fields 161,839.92 0.2900 - - 39.28 161,879.20 161,879.20 161,879.20 N/A 65 Days GO SR2011 Swimming Pool 5,324,500.21 0.2900 - - 1,292.40 5,325,792.61 5,325,792.61 5,325,792.61 N/A 65 Days GO SR2012 Downtown Improvements 979,897.07 0.2900 - - 237.85 980,134.92 980,134.92 980,134.92 N/A 65 Days SE Elevated Water Tank 811,300.24 0.2900 - - 196.92 811,497.16 811,497.16 811,497.16 N/A 65 Days Sewer /CCMA Project 2,931,924.84 0.2900 - - 711.66 2,932,636.50 2,932,636.50 2,932,636.50 N/A 65 Days W /S- Customer Deposits 295,856.58 0.2900 - - 71.81 295,928.39 295,928.39 295,928.39 N/A 65 Days W /S- Equipment Repl /Cap.Imp 177,882.85 0.2900 - - 43.18 177,926.03 177,926.03 177,926.03 N/A 65 Days Water &Sewer 1,072,176.55 0.2900 - - 260.25 1,072,436.80 1,072,436.80 1,072,436.80 N/A 65 Days W /S- Vehicle Replacement 256.967.99 0.2900 - - 62.37 257.030.36 257.030.36 257.030.36 N/A 65 Days TOTAL- LONESTAR '19,428;708.04 - - 1:4,715.87:: 19;433,423:91 :19,433,423.91 .19,433;423.91 - TEXAS CLASS Tax I &S 796,738.89 0.2900 1,250,000.00 - 233.85 2,046,972.74 2,046,972.74 2,046,972.74 N/A 68 Days Police Forfeiture 244,445.60 0.2900 - - 60.89 244,506.49 244,506.49 244,506.49 N/A 68 Days Park Fund 1,357.16 0.2900 75,000.00 - 2.45 76,359.61 76,359.61 76,359.61 N/A 68 Days Economic Development Corporation 7,589,023.40 0.2900 - - 1,890.36 7,590,913.76 7,590,913.76 7,590,913.76 N/A 68 Days Library Board 44,930.75 0.2900 - - 11.17 44,941.92 44,941.92 44,941.92 N/A 68 Days Tree Mitigation 317,800.01 0.2900 - - 79.14 317,879.15 317,879.15 317,879.15 N/A 68 Days Tax Note 2013 Fire Truck 4,937.90 0.2900 - - 1.26 4,939.16 4,939.16 4,939.16 N/A 68 Days Hotel Tax 499,892.04 0.2900 - - 124.53 500,016.57 500,016.57 500,016.57 N/A 68 Days Special Events Fund 16,811.94 0.2900 - - 4.20 16,816.14 16,816.14 16,816.14 N/A 68 Days Citywide Projects SR2007 (0.00) 0.2900 - - - (0.00) (0.00) (0.00) N/A 68 Days Tax Notes 2015 EMS Ambulances 88,685.65 0.2900 - - 22.10 88,707.75 88,707.75 88,707.75 N/A 68 Days Tax Notes 2015 Drainage Equipment 680,212.27 0.2900 - - 169.43 680,381.70 680,381.70 680,381.70 N/A 68 Days Tax Notes 2015 Water Equipment 281,783.80 0.2900 - - 70.20 281,854.00 281,854.00 281,854.00 N/A 68 Days Tax Notes 2015 General Fund Equipme 240,494.67 0.2900 - - 59.91 240,554.58 240,554.58 240,554.58 N/A 68 Days Tax Notes 2015A Fire Trucks & EquiP 992,265.59 0.2900 - - 247.16 992,512.75 992,512.75 992,512.75 N/A 68 Days TOTAL':: TEXAS CLASS 11,799,379.67 :1,325,000.00 :'.2,976.658 13,:127,356.32 13.,127,356,32 13,127 356.32 I T Y 0 F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING DECEMBER 31st, 2015 INVESTMENT Beginning Values Purchases Interest Withdrawals Ending Book Value Mkt Value Par Maturity Mat. -1ZNAQZD-AQC= Capital One General Fund Book 1,348,544.41 Lield 2.6100 zamlad - 278.88 13,772.80 1,362,038.33 1,351,144.04 YAI= 1,301,510.22 DAte N/A &VQ 777 Days Capital One Capital Recovery Sewer 1,725,352.43 2.0600 - 358.19 13,151.62 1,738,145.86 1,731,491.80 1,685,311.41 N/A 736 Days TOTAL CAPITAL ONE 3,073,896.84 - 637.07 26,924.42 3,100,184.19 3,082,635.84 2,986,821.63 - C. D. CERTIFICATES OF DEPOSIT SB&T-Water&Sewer 1,068,630.27 0.7500 - - - 1,068,630.27 1,076,513.25 1,068,630.27 1/7/2016 Ter 365 Days Schertz Economic Development Corp. 1,049,082.71 0.3500 - 3,104.14 1,052,186.85 1,052,459.27 1,052,186.85 6/2/2016 180 Days TOTAL C.D.s 2,117,712.98 - 3,104.14 2,120,817.12 2,128,972.51 2,120,817.12 TOTAL PORTFOLIO 0.43 $36,210.60 $ 54,579,079.82 $ 54,569,686.86 $ 54,465,717.26 110 Days ty Manager /Executive Director Financj-DirectoyF I - ,�Tsq stant Finance Director TOTAL TEXAS CLASS 240 City Portfolio By Investment Type TOTAL C. D 36% TOTAL LOGIC 130 ❑ Special RevenUE Funds, $18,777,769.59 ❑ Debt $2 City Portfolio By Use M Designated Funds, $1,568,665.31 Operations, $18,494,558.81 ?rojects, $13,681,720.42 3.00 2.50 2.00 1.50 1.00 0.50 0.00 MONTHLY YIELDS Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-15 Nov-15 Dec-15 Jan-16 I Feb-16 Mar-16 Apr - 16 May-16 Jun-16 Jul -16 Sep-16 01 Month T-Bill 0.0100 0.1100 0.1400 03 Month T-Bill 0.0800 0.2200 0.1600 06 Month T-Bill 0.2300 0.4200 0.4900 OSchertz Portfolio 0.3930 0.4204 0.4328 BSchertz Bank&Trust 0.0500 0.0500 0.0500 BCD 365 Days 0.7500 ----- ------------------- --- ----- - - BCD 180 Days 0.6000 - - ------------------------ - -LOGIC 0.1635 0.7500 0.6000 0.1637 0.7500 0.3500 - 0.2331 - - ------------- - - - - -- ----------------- - - - - -- ----------------------------------------------- - - - - - --------- ----- ------------------- - - - - - - ---------------------------------------------- ------------------------- - - - - - - - - - - - - - ----------------------------------------------------------------------- DLoneStar 0.1900 0,2000 0.2900 1 1 1 1 BMBIA 0.2100 0.2400 0.2900 MCapital One 2.6936 2.6959 2.3028 C I T Y OF S C H E R T Z Investment Report Capital One Assets Date: 12/31/2015 General Fund Assets Capital Recovery Assets Projected Annual Current Cash & Equivalents Due Maturity Shares Cost Mrk Value Income Yield Fidelity Prime Mmkt Port Fd #690 60,311.41 60,311.41 60,311.41 173.00 0.29 Total Cash & Equivalents 60,311.41 60,311.41 60,311.41 173.00 0.29v Fixed Income Projected Federal Natl Mtg Assn 10/26/2017 665.00 125,000.00 124,588.38 124,517.50 1,093.00 0.88 Annual Current Cash & Equivalents Due Maturity Shares Cost Mrk Value Income Yield 350,000.00 Fidelity Prime Mmkt Port Fd #690 380,212.00 17,062.00 11,510.22 11,510.22 11,510.22 33.00 0.29 Total Cash & Equivalents 3,750.00 3.50 11,510.22 11,510.22 11,510.22 33.00 0.29° Fixed Income 0.75 US Treasury Note 9/30/2016 274.00 125,000.00 124,809.57 124,815.00 625.00 Federal Natl Mtg Assn 1/30/2017 396.00 100,000.00 102,366.80 100,391.00 1,250.00 1.25 0.88 Federal Home LN Mtg Corp Reference Nts 11/17/2017 687.00 100,000.00 109,860.00 107,415.00 5,125.00 4.77 US Treasury Note Federal Home LN Mtg Corp Refrnce 8 6/13/2018 895.00 475,000.00 526,095.45 516,002.00 23,156.00 4.49 2/28/2018 US Treasury Note 10/15/2017 654.00 175,000.00 174,623.05 174,497.75 1,531.00 0.88 197.00 US Treasury Note 11/15/2017 685.00 200,000.00 199,042.97 199,336.00 1,750.00 0.88 1 625, 000. 00 US Treasury Note 10/31/2019 1400.00 90,000.00 89,289.84 88,952.40 1,125.00 1.26 1,738,145.86? US Treasury Note 2/28/2018 790.00 50,000.00 49,585.94 49,582.00 375.00 0.76 US Treasury Note 7/15/2017 562.00 100,000.00 99,664.06 99,846.00 875.00 0.88 Total Fixed Income 1,290,000.00 1,350,528.11 1,336,022.15 35,187.00 2.630 Total Assets ` 776.49 1,301,510.22 1,362,038.33 1,347,532.!37 35,220.00 2.61% Capital Recovery Assets Projected Annual Current Cash & Equivalents Due Maturity Shares Cost Mrk Value Income Yield Fidelity Prime Mmkt Port Fd #690 60,311.41 60,311.41 60,311.41 173.00 0.29 Total Cash & Equivalents 60,311.41 60,311.41 60,311.41 173.00 0.29v Fixed Income Federal Natl Mtg Assn 10/26/2017 665.00 125,000.00 124,588.38 124,517.50 1,093.00 0.88 Federal Home LN Mtg Corp Reference Nts 11/17/2017 687.00 100,000.00 109,860.00 107,415.00 5,125.00 4.77 Federal Home Mtg Corp Refrnce 8 6/13/2018 895.00 350,000.00 387,637.60 380,212.00 17,062.00 4.49 Federal Home LN Mtg Corp 3/27/2019 1182.00 100,000.00 108,297.40 107,115.00 3,750.00 3.50 US Treasury Note 3/15/2017 440.00 150,000.00 149,753.91 149,806.50 1,125.00 0.75 US Treasury Note 9/30/2016 274.00 125,000.00 124,809.57 124,815.00 625.00 0.50 US Treasury Note 10/15/2017 654.00 100,000.00 99,644.53 99,713.00 875.00 0.88 US Treasury Note 10/31/2019 1400.00 175,000.00 175,115.24 174,475.00 2,625.00 1.50 US Treasury Note 11/15/2017 685.00 200,000.00 199,042.97 199,336.00 1,750.00 0.88 US Treasury Note 2/28/2018 790.00 100,000.00 99,175.78 99,164.00 750.00 0.76 US Treasury Note 7/15/2016 197.00 100,000.00 99,909.07 100,020.00 625.00 0.62 Total Fixed Income 1 625, 000. 00 1,677,834.45 1,666,589.00 35,405.00 2.12° Total Assets 735.30 1,685,311.41 1,738,145.86? 1,726,900.`41 35,578.00 2.06 %<