The URL can be used to link to this page

Q3-June-2017 Financials3rd Quarter Financial Report C I T Y OF S C H E R T Z Prepared By: Finance Department June 30th, 2017 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2017 ********************************* 2016 - 2017 *********************************** CURRENT CURRENT Y-T-D BUDGET 75% BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET General Fund, 101 Total Revenues 29,773,195.00 24,429,843.32 -5,343,351.68 82.05% Total General Government 7,487,448.20 4,614,341.05 230,097.74 2,643,009.41 64.70% Total Public Safety 12,380,893.49 9,109,898.09 122,863.07 3,148,132.33 74.57% Total Public Environment 1,227,407.00 881,309.46 79,078.98 267,018.56 78.25% Total Parks & Recreation 1,814,217.00 1,032,991.87 156,816.28 624,408.85 65.58% Total Cultural 868,161.00 650,816.78 12,185.46 205,158.76 76.37% Total Health 787,854.00 512,765.95 69,334.48 205,753.57 73.88% Total Internal Service 4,929,355.00 3,501,357.32 156,360.18 1,271,637.50 74.20% Total Misc & Projects 269,708.00 202,269.09 5,390.47 62,048.44 76.99% General Fund, 101 Total Cash in Bank & Investments 13,836,523.89 Special Events Fund, 106 Total Revenues 196,350.00 73,393.03 -122,956.97 37.38% Total Expenditures 186,350.00 73,363.79 1,633.56 111,352.65 40.25% Special Events Fund, 106 Total Cash in Bank & Investments 70,420.62 Peg Fund, 110 Total Revenues 113,300.00 67,771.31 -45,528.69 59.82% Total Expenditures 108,600.00 449.00 -108,151.00 0.41% Peg Fund, 110 Total Cash in Bank & Investments 621,979.35 Water & Sewer, 202 Total Revenues 21,293,219.00 16,299,442.77 -4,993,776.23 76.55% Total Expenditures 21,233,817.00 13,872,628.36 112,679.12 7,248,509.52 65.86% Water & Sewer, 202 Total Cash in Bank & Investments 6,570,615.64 EMS, 203 Total Revenues 9,119,812.17 6,574,715.09 -3,095,097.08 72.09% Total Expenditures 9,003,895.81 5,656,340.55 92,275.31 3,255,279.95 63.85% EMS, 203 Total Cash in Bank & Investments 276,193.21 Drainage, 204 Total Revenues 1,632,200.00 870,732.95 -761,467.05 53.35% Total Expenditures 1,606,764.00 703,727.68 29,703.32 873,333.00 45.65% Drainage, 204 Total Cash in Bank & Investments 1,097,185.81 Quarterly Statement Schertz, Texas CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2017 ********************************* 2016 - 2017 *********************************** CURRENT CURRENT Y-T-D BUDGET 75% BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Hotel Tax, 314 Total Revenues 611,452.00 347,767.51 -263,684.49 56.88% Total Expenditures 260,995.00 154,473.88 (1,176.40)107,697.52 58.74% Hotel Tax, 314 Total Cash in Bank & Investments 1,347,597.12 Park, 317 Total Revenues 190,700.00 100,413.02 -90,286.98 52.65% Total Expenditures 190,700.00 14,176.00 4,630.00 171,894.00 9.86% Park, 317 Total Cash in Bank & Investments 430,958.68 Tree Mitigation, 319 Total Revenues 142,000.00 62,973.24 -79,026.76 44.35% Total Expenditures 142,000.00 85,901.00 -56,099.00 60.49% Tree Mitigation, 319 Total Cash in Bank & Investments 317,458.69 Capital Recovery Water, 411 Total Revenues 1,040,600.00 1,087,781.48 -(47,181.48)104.53% Total Expenditures 156,000.00 1,000.00 -155,000.00 0.64% Capital Recovery Water, 411 Total Cash in Bank & Investments 4,461,297.09 Capital Recovery Sewer, 421 Total Revenues 625,500.00 588,439.22 -37,060.78 94.08% Total Expenditures 235,500.00 4,263.72 -231,236.28 1.81% Capital Recovery Sewer, 421 Total Cash in Bank & Investments 5,422,578.42 I&S, 505 Total Revenues 6,614,581.00 6,611,629.38 -2,951.62 99.96% Total Expenditures 6,614,581.00 5,331,133.69 -1,283,447.31 80.60% I&S, 505 Total Cash in Bank & Investments 2,592,072.56 SED Corporation, 620 Total Revenues 3,738,260.00 2,752,809.37 -985,450.63 73.64% Total Expenditures 2,062,617.00 752,180.87 3,648.16 1,306,787.97 36.64% SED Corporation, 620 Total Cash in Bank & Investments 12,582,304.70 Quarterly Statement Schertz, Texas 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 18,720,400.00 1,996,640.63 15,748,652.19 16,466,655.14 - 2,253,744.86 87.96% Franchises 2,306,600.00 543,037.84 1,507,346.08 1,543,942.48 - 762,657.52 66.94% Permits 1,404,500.00 642,230.85 881,303.20 1,569,626.35 - (165,126.35) 111.76% Licenses 51,160.00 17,047.50 42,949.50 51,255.00 - (95.00) 100.19% Fees 2,251,582.00 694,062.50 1,859,582.43 1,968,993.99 - 282,588.01 87.45% Fines 28,000.00 6,326.76 18,694.88 17,606.54 - 10,393.46 62.88% Inter-Jurisdictional 879,508.00 119,716.69 607,764.59 550,869.12 - 328,638.88 62.63% Fund Transfers 3,642,745.00 603,938.76 1,210,347.41 1,811,816.24 - 1,830,928.76 49.74% Miscellaneous 488,700.00 175,326.41 409,657.94 449,078.46 - 39,621.54 91.89% TOTAL REVENUES 29,773,195.00 4,798,327.94 22,286,298.22 24,429,843.32 - 5,343,351.68 82.05% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 32,132.00 9,369.15 17,012.95 24,254.14 - 7,877.86 75.48% Supplies 1,300.00 253.18 173.42 389.96 - 910.04 30.00% City Support Services 53,500.00 787.54 67,095.29 34,368.74 - 19,131.26 64.24% Operations Support 500.00 - 184.58 336.04 - 163.96 67.21% Staff Support 28,910.00 1,430.52 12,256.40 20,084.41 - 8,825.59 69.47% Operating Equipment 640.00 - - 723.00 - (83.00) 112.97% TOTAL CITY COUNCIL 116,982.00 11,840.39 96,722.64 80,156.29 - 36,825.71 68.52% CITY MANAGER Personnel Services 1,076,365.00 278,704.58 600,901.08 764,566.38 - 311,798.62 71.03% Supplies 2,750.00 721.75 1,599.02 1,294.67 - 1,455.33 47.08% City Support Services 7,535.00 - 522.67 4,989.85 103.64 2,441.51 67.60% Utility Services - 52.50 114.82 118.49 - (118.49) 0.00% Operations Support - 23.98 - 23.98 - (23.98) 0.00% Staff Support 35,745.00 6,572.56 16,717.23 15,194.74 1,589.37 18,960.89 46.96% TOTAL CITY MANAGER 1,122,395.00 286,075.37 619,854.82 786,188.11 1,693.01 334,513.88 70.20% *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 MUNICIPAL COURT Personnel Services 287,455.00 64,829.85 198,654.57 204,930.87 - 82,524.13 71.29% Supplies 2,000.00 279.24 739.03 721.59 679.72 598.69 70.07% City Support Services 1,000.00 - - 37.78 - 962.22 3.78% Operations Support 3,250.00 - 941.00 - - 3,250.00 0.00% Staff Support 7,310.00 1,779.26 3,711.63 2,757.39 626.92 3,925.69 46.30% Court Support 520.00 - 192.00 186.00 - 334.00 35.77% Professional Services 67,380.00 12,690.00 34,382.38 40,840.00 7,840.00 18,700.00 72.25% Maintenance Services 2,000.00 450.00 1,500.00 1,920.00 - 80.00 96.00% Operating Equipment - - 3,547.24 39.02 - (39.02) 0.00% TOTAL MUNICIPAL COURT 370,915.00 80,028.35 243,667.85 251,432.65 9,146.64 110,335.71 70.25% CUSTOMER RELATIONS-311 Personnel Services 113,744.00 30,830.44 76,210.96 87,456.55 - 26,287.45 76.89% Supplies 150.00 - 74.93 40.30 - 109.70 26.87% Staff Support 475.00 71.00 204.32 170.00 - 305.00 35.79% TOTAL CUSTOMER RELATIONS-311 114,369.00 30,901.44 76,490.21 87,666.85 - 26,702.15 76.65% PLANNING & ZONING Personnel Services 190,445.00 52,526.32 90,823.43 144,584.00 - 45,861.00 75.92% Supplies 3,060.00 424.74 1,480.12 695.23 75.36 2,289.41 25.18% City Support Services - - 295.20 - - - 0.00% Operations Support 150.00 56.79 163.13 70.29 - 79.71 46.86% Staff Support 24,299.00 6,019.99 3,018.49 9,573.78 462.68 14,262.54 41.30% Professional Services 170.00 11.00 39 100 - 70.00 58.82% Operating Equipment - - - - 3,400.40 (3,400.40) 0.00% TOTAL PLANNING & ZONING 218,124.00 59,038.84 95,819.37 155,023.30 3,938.44 59,162.26 72.88% LEGAL SERVICES Operations Support 10,000.00 863.13 1,397.41 1,422.79 88.25 8,488.96 15.11% Professional Services 230,000.00 41,209.44 69,687.31 69,924.62 - 160,075.38 30.40% TOTAL LEGAL SERVICES 240,000.00 42,072.57 71,084.72 71,347.41 88.25 168,564.34 29.76% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 GENERAL SERVICES Personnel Services - - 394,793.39 - - - 0.00% Supplies - - 64,703.14 - - - 0.00% Utility Services - - 112,304.29 - - - 0.00% Staff Support - - 6,806.07 - - - 0.00% Maintenance Services - - 19,587.72 - - - 0.00% Rental/Leasing - - 593.25 - - - 0.00% Capital Outlay - - 23,087.90 - - - 0.00% TOTAL GENERAL SERVICES - - 621,875.76 - - - 0.00% CITY SECRETARY Personnel Services 175,687.00 47,724.30 122,658.64 133,847.74 - 41,839.26 76.19% Supplies 1,350.00 415.80 183.58 1,202.51 86.05 61.44 95.45% City Support Services 12,500.00 2,950.43 8,139.37 4,975.46 - 7,524.54 39.80% Staff Support 6,225.00 364.22 2,609.93 2,794.66 298.00 3,132.34 49.68% TOTAL CITY SECRETARY 195,762.00 51,454.75 133,591.52 142,820.37 384.05 52,557.58 73.15% NON-DEPARTMENTAL City Support Services 654,360.00 51,464.06 286,809.26 327,906.00 41,074.25 285,379.75 56.39% Operations Support 141,500.00 40,561.58 106,002.71 51,956.73 34.50 89,508.77 36.74% Staff Support 200.00 - 10,080.00 165.50 - 34.50 82.75% City Assistance 1,732,157.00 845,489.87 1,541,976.63 1,585,307.64 126,020.97 20,828.39 98.80% Professional Services 71,135.00 32,110.99 53,005.22 59,670.92 29,450.00 (17,985.92) 125.28% Fund Chrgs/Transfrs-Spec Events Fnd 1,011,700.00 - - - - 1,011,700.00 0.00% Operating Equipment - - 1,874.00 - - - 0.00% TOTAL NON-DEPARTMENTAL 3,611,052.00 969,626.50 1,999,747.82 2,025,006.79 196,579.72 1,389,465.49 61.52% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 PUBLIC AFFAIRS Personnel Services 271,039.00 72,799.38 188,020.23 205,115.61 - 65,923.39 75.68% Supplies 2,300.00 272.55 1,714.57 817.29 214.13 1,268.58 44.84% Operations Support 22,450.00 5,910.22 12,028.34 11,130.12 - 11,319.88 49.58% Staff Support 4,000.00 580.00 1,439.03 1,279.00 1,217.02 1,503.98 62.40% Professional Services 24,000.00 - - 22,900.00 - 1,100.00 95.42% Operating Equipment 1,000.00 - 2,214.09 - - 1,000.00 0.00% TOTAL PUBLIC AFFAIRS 324,789.00 79,562.15 205,416.26 241,242.02 1,431.15 82,115.83 74.72% RECORDS MANAGEMENT Personnel Services 52,832.00 7,265.85 37,126.49 29,519.56 - 23,312.44 55.87% Supplies 250.00 - 66.37 31.22 - 218.78 12.49% Staff Support 350.00 - 44.44 - - 350.00 0.00% Professional Services 12,000.00 2,288.33 6,881.50 7,000.88 184.45 4,814.67 59.88% Operating Equipment 250.00 - - - - 250.00 0.00% TOTAL RECORDS MANAGEMENT 65,682.00 9,554.18 44,118.80 36,551.66 184.45 28,945.89 55.93% SCHERTZ MAGAZINE Personnel Services 133,608.00 32,264.36 80,934.45 98,289.96 - 35,318.04 73.57% Supplies 200.00 151.36 127.50 180.85 - 19.15 90.43% Opperations Support 1,120.00 985.25 - 985.25 - 134.75 87.97% Staff Support 1,860.00 749.00 848.60 1,245.00 62.00 553.00 70.27% Professional Services 245,754.00 42,915.42 168,657.39 170,351.97 7,817.00 67,585.03 72.50% Fund Charges/Transfers 10,000.00 - - - - 10,000.00 0.00% Operating Equipment 126.00 125.98 - 125.98 - 0.02 99.98% TOTAL SCHERTZ MAGAZINE 392,668.00 77,191.37 250,567.94 271,179.01 7,879.00 113,609.99 71.07% ENGINEERING Personnel Services 462,286.00 121,880.20 135,806.71 312,213.89 - 150,072.11 67.54% Supplies 1,620.00 283.81 566.45 408.77 8.00 1,203.23 25.73% City Support Services 295.20 295.20 590.40 295.20 - - 100.00% Utility Services 3,500.00 393.62 246.44 675.76 - 2,824.24 19.31% Operations Support 2,550.00 35.98 - 71.96 29.98 2,448.06 4.00% Staff Support 9,475.00 1,045.59 2,436.59 1,818.38 40.00 7,616.62 19.61% Professional Services 70,800.00 - 2,338.00 27,986.40 5,795.00 37,018.60 47.71% Rental/Leasing 2,825.00 - - 2,824.47 - 0.53 99.98% Operating Equipment 400.00 - - - - 400.00 0.00% TOTAL ENGINEERING 553,751.20 123,934.40 141,984.59 346,294.83 5,872.98 201,583.39 63.60% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 GIS Personnel Services 151,979.00 40,892.00 101,659.21 115,362.04 - 36,616.96 75.91% Supplies 2,295.00 1,575.07 - 1,575.07 - 719.93 68.63% Staff Support 4,600.00 - 4,515.32 931.80 2,379.10 1,289.10 71.98% Rental/Leasing 2,085.00 694.60 1,910.15 1,562.85 520.95 1.20 0.00% TOTAL GIS 160,959.00 43,161.67 108,084.68 119,431.76 2,900.05 38,627.19 76.00% TOTAL GENERAL GOVERNMENT 7,487,448.20 1,864,441.98 4,709,026.98 4,614,341.05 230,097.74 2,643,009.41 64.70% PUBLIC SAFETY POLICE Personnel Services 6,038,924.00 1,557,333.85 4,001,134.10 4,449,359.97 - 1,589,564.03 73.68% Supplies 84,323.38 49,715.82 28,283.10 69,426.07 9,516.60 5,380.71 93.62% City Support Services 19,081.00 - 19,081.45 21,294.42 - (2,213.42) 111.60% Utility Services 86,637.40 21,330.33 43,255.27 51,444.84 - 35,192.56 59.38% Operations Support 3,065.00 308.95 2,413.77 1,752.70 - 1,312.30 57.18% Staff Support 130,380.31 37,404.96 48,603.97 64,188.01 25,163.14 41,029.16 68.53% City Assistance 15,537.00 3,471.50 6,676.88 9,934.17 392.94 5,209.89 66.47% Professional Services 44,408.00 4,317.76 34,732.91 31,836.13 3,638.43 8,933.44 79.88% Maintenance Services 57,562.95 7,259.05 44,470.59 28,164.53 3,806.25 25,592.17 55.54% Rental/Leasing 44,470.00 (60.84) - 44,158.64 - 311.36 99.30% Operating Equipment 83,982.05 5,103.70 110,461.18 25,788.16 14,738.33 43,455.56 48.26% Capital Outlay 473,196.40 356,112.36 204,959.75 420,647.38 11,340.69 41,208.33 91.29% TOTAL POLICE 7,081,567.49 2,042,297.44 4,544,072.97 5,217,995.02 68,596.38 1,794,976.09 74.65% FIRE RESCUE Personnel Services 3,541,745.00 892,449.46 2,298,934.80 2,624,382.07 - 917,362.93 74.10% Supplies 10,907.00 789.85 12,239.02 3,569.51 830.18 6,507.31 40.34% Utility Services 44,200.00 12,279.77 28,437.50 31,772.33 - 12,427.67 71.88% Operations Support 550.00 - 700.69 - - 550.00 0.00% Staff Support 139,350.00 30,129.49 78,323.30 114,137.27 10,407.64 14,805.09 89.38% City Assistance 22,593.00 1,246.37 2,219.42 3,804.22 9,235.07 9,553.71 57.71% Professional Services 35,200.00 32,696.00 13,643.00 32,696.00 - 2,504.00 92.89% Maintenance Services 53,000.00 11,779.92 38,520.24 24,067.86 7,962.92 20,969.22 60.44% Rental/Leasing 16,890.00 3,950.82 11,964.83 11,964.83 3,950.82 974.35 94.23% Operating Equipment 80,625.00 9,754.07 51,096.28 39,830.39 19,513.01 21,281.60 73.60% Capital Outlay 44,500.00 - - 44,300.23 - 199.77 99.55% TOTAL FIRE RESCUE 3,989,560.00 995,075.75 2,536,079.08 2,930,524.71 51,899.64 1,007,135.65 74.76% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 INSPECTIONS Personnel Services 541,414.00 152,457.06 327,726.54 424,314.78 - 117,099.22 78.37% Supplies 3,835.00 640.52 1,846.88 2,263.24 49.18 1,522.58 60.30% Utility Services 5,000.00 995.92 2,172.43 2,227.19 - 2,772.81 44.54% Operations Support 2,000.00 547.96 679.00 1,516.47 - 483.53 75.82% Staff Support 26,680.00 5,325.28 7,382.44 12,146.17 1,690.87 12,842.96 51.86% Professional Services 227,000.00 61,425.00 84,054.50 147,175.00 - 79,825.00 64.83% TOTAL INSPECTIONS 805,929.00 221,391.74 423,861.79 589,642.85 1,740.05 214,546.10 73.38% MARSHAL'S OFFICE Personnel Services 448,770.00 112,341.88 432,862.68 342,347.75 - 106,422.25 76.29% Supplies 3,350.00 373.09 2,333.11 1,592.68 - 1,757.32 47.54% Utility Services 10,000.00 1,747.01 4,268.83 4,128.56 - 5,871.44 41.29% Operations Support 1,000.00 274.85 675.51 274.85 177.00 548.15 45.19% Staff Support 12,540.00 3,559.77 6,885.16 4,707.88 250.00 7,582.12 39.54% City Assistance 1,250.00 - - - - 1,250.00 0.00% Maintenance Services 4,700.00 400.00 6,416.00 1,200.00 200.00 3,300.00 29.79% Operating Equipment 4,227.00 - 3,757.75 2,080.74 - 2,146.26 49.22% Capital Outlay 18,000.00 - 70,112.00 15,403.05 - 2,596.95 85.57% TOTAL MARSHAL'S OFFICE 503,837.00 118,696.60 527,311.04 371,735.51 627.00 131,474.49 73.91% TOTAL PUBLIC SAFETY 12,380,893.49 3,377,461.53 8,031,324.88 9,109,898.09 122,863.07 3,148,132.33 74.57% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 PUBLIC ENVIRONMENT STREETS Personnel Services 741,825.00 180,820.69 477,149.01 547,913.52 - 193,911.48 73.86% Supplies 90,450.00 32,366.09 3,873.18 48,670.83 5,004.25 36,774.92 59.34% Utility Services 151,200.00 24,018.50 100,624.22 89,560.22 217.00 61,422.78 59.38% Staff Support 11,950.00 4,909.71 7,502.89 9,375.18 31.74 2,543.08 78.72% Professional Services 31,950.00 - 32,950.99 5,037.50 66,667.00 (39,754.50) 224.43% Maintenance Services 40,000.00 17,468.18 59,741.37 38,501.12 - 1,498.88 96.25% Rental/Lease 5,200.00 1,497.48 - 1,756.48 - 3,443.52 33.78% Operating Equipment 12,201.00 2,670.58 - 2,670.58 6,268.00 3,262.42 73.26% Capital Outlay 142,631.00 131,008.04 72,806.52 137,824.03 890.99 3,915.98 97.25% TOTAL STREETS 1,227,407.00 394,759.27 754,648.18 881,309.46 79,078.98 267,018.56 78.25% TOTAL PUBLIC ENVIRONMENT 1,227,407.00 394,759.27 754,648.18 881,309.46 79,078.98 267,018.56 78.25% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 511,343.00 127,090.62 320,632.66 372,157.19 - 139,185.81 72.78% Supplies 39,315.00 16,784.92 30,967.82 26,892.01 6,217.28 6,205.71 84.22% City Support Services 11,500.00 2,876.70 2,360.00 8,452.63 1,628.19 1,419.18 87.66% Utility Services 171,250.00 46,050.55 133,030.33 147,983.92 268.03 22,998.05 86.57% Operations Support 1,673.00 1,121.80 606.04 1,673.20 - (0.20) 100.01% Staff Support 10,625.00 3,543.41 4,855.48 8,870.72 238.35 1,515.93 85.73% Professional Services 93,670.00 20,851.84 40,160.42 60,291.79 13,539.32 19,838.89 78.82% Maintenance Services 25,047.00 927.12 10,753.94 16,060.56 500.00 8,486.44 66.12% Rental/Leasing 41,600.00 9,057.48 27,262.49 28,080.88 9,057.48 4,461.64 89.27% Operating Equipment 16,000.00 7,630.94 1,935.32 12,555.07 675.80 2,769.13 82.69% Capital Outlay 10,000.00 - 27,840.60 - - 10,000.00 0.00% TOTAL PARKS DEPARTMENT 932,023.00 235,935.38 600,405.10 683,017.97 32,124.45 216,880.58 76.73% SWIM POOL Supplies 25,100.00 6,758.48 8,728.30 14,582.25 4,556.19 5,961.56 76.25% Utility Services 27,000.00 3,573.90 8,276.87 15,207.57 - 11,792.43 56.32% Professional Services 3,800.00 3,632.56 - 3,632.56 - 167.44 95.59% Maintenance Services 662,078.00 124,814.93 3,387.47 231,315.10 119,918.00 310,844.90 53.05% Operating Equipment - 212.21 - - - 0.00% TOTAL SWIM POOL 717,978.00 138,779.87 20,604.85 264,737.48 124,474.19 328,766.33 54.21% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 EVENT FACILITIES Personnel Services 59,006.00 16,423.02 37,552.60 45,231.42 - 13,774.58 76.66% Supplies 15,000.00 1,029.93 7,600.92 2,574.57 217.64 12,207.79 18.61% Utility Services 51,750.00 10,437.19 32,624.17 27,551.03 - 24,198.97 53.24% Operations Support 10,900.00 3,800.00 4,840.47 4,902.53 - 5,997.47 44.98% Staff Support 2,180.00 - 840.00 1,305.48 - 874.52 59.88% Operating Equipment 25,380.00 5,522.00 6,143.00 3,671.39 - 21,708.61 14.47% TOTAL EVENT FACILITIES 164,216.00 37,212.14 89,601.16 85,236.42 217.64 78,761.94 52.04% SENIOR CITIZEN CENTER Supplies - - 2,170.98 - - - 0.00% City Assistence - - 19,136.93 - - - 0.00% Professional Services - - 1,016.77 - - - 0.00% Maintenance Services - - 138.50 - - - 0.00% TOTAL SENIOR CITIZEN CENTER - - 22,463.18 - - - 0.00% TOTAL PARKS & RECREATION 1,814,217.00 411,927.39 733,074.29 1,032,991.87 156,816.28 624,408.85 65.58% CULTURAL LIBRARY Personnel Services 677,981.00 194,957.74 478,745.17 536,404.88 - 141,576.12 79.12% Supplies 15,000.00 3,584.75 11,395.41 9,230.53 1,123.64 4,645.83 69.03% Utility Services 55,600.00 9,031.50 31,148.16 21,888.43 - 33,711.57 39.37% Operations Support 3,150.00 247.97 2,295.13 1,127.92 231.98 1,790.10 43.17% Staff Support 6,615.00 2,720.73 4,041.77 4,426.46 46.73 2,141.81 67.62% Professional Services 2,315.00 - 2,247.00 2,252.00 - 63.00 97.28% Operating Equipment 107,500.00 21,842.21 70,126.71 75,486.56 10,783.11 21,230.33 80.25% TOTAL LIBRARY 868,161.00 232,384.90 599,999.35 650,816.78 12,185.46 205,158.76 76.37% TOTAL CULTURAL 868,161.00 232,384.90 599,999.35 650,816.78 12,185.46 205,158.76 76.37% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 HEALTH ANIMAL SERVICES Personnel Services 320,519.00 86,186.98 210,381.74 243,423.38 - 77,095.62 75.95% Supplies 33,380.00 11,302.73 21,659.99 24,352.62 3,445.10 5,582.28 83.28% City Support Services 3,500.00 - 88.35 2,052.13 - 1,447.87 58.63% Utility Services 37,500.00 8,762.42 20,086.84 28,501.77 - 8,998.23 76.00% Operations Support 1,000.00 21.98 158.50 711.98 - 288.02 71.20% Staff Support 10,750.00 1,438.96 7,173.56 3,422.57 666.57 6,660.86 38.04% City Assistance 18,550.00 2,100.44 8,707.78 7,986.87 1,026.93 9,536.20 48.59% Professional Services 25,000.00 5,245.38 14,349.00 12,266.64 1,473.05 11,260.31 54.96% Maintenance Services 17,010.00 1,114.40 7,867.09 8,303.92 1,095.08 7,611.00 55.26% Operating Equipment 38,000.00 4,146.76 1,799.34 5,657.42 882.75 31,459.83 17.21% Capital Outlay 63,000.00 - 31,330.00 27,870.00 60,745.00 (25,615.00) 140.66% TOTAL ANIMAL SERVICES 568,209.00 120,320.05 323,602.19 364,549.30 69,334.48 134,325.22 76.36% ENVIRONMENTAL HEALTH Personnel Services 190,240.00 51,174.82 - 136,730.99 - 53,509.01 71.87% Supplies 3,505.00 308.04 - 620.60 - 2,884.40 17.71% Operations Support 1,800.00 659.32 - 702.61 - 1,097.39 39.03% Staff Support 6,550.00 462.27 - 2,815.76 - 3,734.24 42.99% City Assistance 1,000.00 699.34 - 900.81 - 99.19 90.08% Professional Services 500.00 - - 176.00 - 324.00 35.20% Maintenance Services 10,600.00 2,500.00 - 4,985.00 - 5,615.00 47.03% Operating Equipment 5,450.00 851.44 - 1,284.88 - 4,165.12 23.58% TOTAL ANIMAL SERVICES 219,645.00 56,655.23 - 148,216.65 - 71,428.35 67.48% TOTAL HEALTH 787,854.00 176,975.28 323,602.19 512,765.95 69,334.48 205,753.57 73.88% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 524,491.00 134,871.96 299,715.55 350,663.91 - 173,827.09 66.86% Supplies 7,000.00 3,224.31 904.64 4,849.81 1,088.93 1,061.26 84.84% City Support Services 519,162.00 108,071.16 320,507.54 343,778.04 36,690.00 138,693.96 73.29% Utility Services 227,646.00 49,653.15 147,977.69 140,788.91 320.00 86,537.09 61.99% Staff Support 34,100.00 8,539.69 35,967.56 24,129.39 1,450.00 8,520.61 75.01% Maintenance Services 17,580.00 6,145.39 13,724.53 10,917.77 2,957.67 3,704.56 78.93% Rental/Leasing 38,047.00 8,204.49 31,704.90 30,397.92 - 7,649.08 Operating Equipment 227,123.00 43,005.02 113,042.52 158,443.88 40,857.13 27,821.99 87.75% Capital Outlay 13,000.00 - - - - 13,000.00 0.00% TOTAL INFORMATION TECHNOLOGY 1,608,149.00 361,715.17 963,544.93 1,063,969.63 83,363.73 460,815.64 71.34% HUMAN RESOURCES Personnel Services 350,331.00 70,713.72 189,413.26 221,928.67 - 128,402.33 63.35% Supplies 1,000.00 209.67 907.62 397.75 181.46 420.79 57.92% Human Services 71,500.00 13,740.28 35,999.69 38,043.73 3,290.05 30,166.22 57.81% Operations Support 10,000.00 35.00 6,060.40 3,181.44 - 6,818.56 31.81% Staff Support 17,100.00 5,081.79 14,540.78 7,350.23 199.00 9,550.77 44.15% City Assistance 10,000.00 1,716.00 10,144.00 4,578.00 - 5,422.00 45.78% Professional Services 9,600.00 2,234.25 6,752.75 7,202.75 - 2,397.25 75.03% Operating Equipment 1,000.00 547.14 1,362.96 614.94 - 385.06 61.49% TOTAL HUMAN RESOURCES 470,531.00 94,277.85 265,181.46 283,297.51 3,670.51 183,562.98 60.99% FINANCE Personnel Services 584,190.00 147,007.85 362,897.04 423,711.77 - 160,478.23 72.53% Supplies 4,981.77 940.89 3,378.88 3,744.37 - 1,237.40 75.16% Operations Support 1,917.00 35.98 2,582.69 1,916.64 - 0.36 99.98% Staff Support 7,973.00 2,808.73 8,361.52 3,823.73 - 4,149.27 47.96% Professional Sevices - 24,255.00 505.00 24,255.00 - (24,255.00) 0.00% Operating Equipment 2,970.23 52.24 - 112.23 2,857.29 0.71 99.98% TOTAL FINANCE 602,032.00 175,100.69 377,725.13 457,563.74 2,857.29 141,610.97 76.48% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 PURCHASING & ASSET MGT Personnel Services 190,620.00 54,775.34 97,624.79 124,267.09 - 66,352.91 65.19% Supplies 1,050.00 495.14 512.19 599.96 - 450.04 57.14% Utility Services 250.00 46.25 163.64 107.75 - 142.25 43.10% Operations Support 100.00 - 22.30 26.35 - 73.65 26.35% Staff Support 6,149.00 455.17 4,703.11 1,825.69 10.00 4,313.31 29.85% City Assistance 3,000.00 271.00 2,190.46 1,036.00 - 1,964.00 34.53% Operating Equipment 451.00 - - 150.77 300.23 33.43% TOTAL PURCHASING & ASSET MGT 201,620.00 56,042.90 105,216.49 127,862.84 160.77 73,596.39 63.50% FLEET SERVICE Personnel Services 343,327.00 89,207.90 203,648.67 253,862.66 - 89,464.34 73.94% Supplies 169,100.00 38,546.45 106,716.96 127,340.66 14,077.87 27,681.47 83.63% City Support Services 6,150.00 - 2,244.72 2,354.40 - 3,795.60 38.28% Utility Services 6,200.00 2,042.83 2,983.57 5,298.56 - 901.44 85.46% Operations Support 200.00 - - 59.69 - 140.31 29.85% Staff Support 10,856.62 1,685.29 4,488.76 5,255.99 547.01 5,053.62 53.45% Maintenance Services 165,793.38 36,568.13 133,161.91 121,978.33 14,097.23 29,717.82 82.08% Operating Equipment 7,700.00 1,596.56 7,941.49 4,719.30 927.41 2,053.29 73.33% Capital Outlay 36,600.00 - 88,461.00 - - 36,600.00 0.00% TOTAL FLEET SERVICE 745,927.00 169,647.16 549,647.08 520,869.59 29,649.52 195,407.89 73.80% BUILDING MAINTENANCE Personnel Services 781,125.00 200,596.64 106,125.45 580,289.07 4,363.84 196,472.09 74.85% Supplies 103,087.69 20,322.92 1,563.70 75,395.31 7,015.10 20,677.28 79.94% Utility Services 153,715.00 29,838.77 1,923.29 87,610.44 - 66,104.56 57.00% Staff Support 10,536.60 1,083.71 2,518.70 8,524.23 348.99 1,663.38 84.21% Professional Services 9,000.00 - 43,784.99 - - 9,000.00 0.00% Maintenance Services 215,019.72 87,007.20 107,474.67 265,830.66 24,930.43 (75,741.37) 135.23% Rental/Leasing 39.31 - 1,263.27 2,210.69 - (2,171.38) 5623.73% Operating Equipment 2,700.00 2,060.93 - 2,060.93 - 639.07 76.33% Capital Outlay 25,872.68 25,872.68 - 25,872.68 - - 100.00% TOTAL BUILDING MAINTENANCE 1,301,096.00 366,782.85 264,654.07 1,047,794.01 36,658.36 216,643.63 83.35% TOTAL INTERNAL SERVICE 4,929,355.00 1,223,566.62 2,525,969.16 3,501,357.32 156,360.18 1,271,637.50 74.20% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 MISC & PROJECTS CITY ASSISTANCE City's Assistance to Agencies 250,260.00 78,893.24 150,189.73 201,912.09 3,550.47 44,797.44 82.10% TOTAL CITY ASSISTANCE 250,260.00 78,893.24 150,189.73 201,912.09 3,550.47 44,797.44 82.10% COURT - RESTRICTED FUNDS Operating Equipment 19,448.00 - 3,924.25 357.00 1,840.00 17,251.00 11.30% TOTAL CITY ASSISTANCE 19,448.00 - 3,924.25 357.00 1,840.00 17,251.00 11.30% TOTAL MISC & PROJECTS 269,708.00 78,893.24 154,113.98 202,269.09 5,390.47 62,048.44 76.99% TOTAL EXPENDITURES 29,765,043.69 7,760,410.21 17,831,759.01 20,505,749.61 832,126.66 8,427,167.42 71.69% REVENUE OVER(UNDER) EXPEND.8,151.31 3,924,093.71 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 11,203,881.00 135,318.73 10,359,461.35 11,073,815.33 - 130,065.67 98.84% 000-411200 Advalorem Tax - Delinquent 40,000.00 4,646.33 17,158.59 (10,541.57) - 50,541.57 -26.35% 000-411300 Advalorem Tax - P&I 45,000.00 19,082.34 41,325.31 45,039.48 - (39.48) 100.09% 000-411500 Sales Tax Revenue-Gen Fund 7,385,419.00 1,827,871.82 5,298,367.43 5,326,232.12 - 2,059,186.88 72.12% 000-411600 Bingo Tax 100.00 - 0.62 31.25 - 68.75 31.25% 000-411700 Mixed Beverage Tax 46,000.00 9,721.41 32,338.89 32,078.53 - 13,921.47 69.74% TOTAL Taxes 18,720,400.00 1,996,640.63 15,748,652.19 16,466,655.14 - 2,253,744.86 87.96% Franchises 000-421200 Center Point/Entex Energy 74,000.00 15,236.55 53,204.30 54,349.75 - 19,650.25 73.45% 000-421220 City Public Service 873,600.00 236,762.25 537,701.43 627,016.76 - 246,583.24 71.77% 000-421240 Guadalupe Valley Elec Co-op 513,000.00 111,493.77 306,332.26 304,328.57 - 208,671.43 59.32% 000-421250 New Braunfels Utilities 70,000.00 19,157.38 50,037.54 50,246.11 - 19,753.89 71.78% 000-421300 Time Warner-State Franchise 238,000.00 59,952.96 193,101.90 194,702.38 - 43,297.62 81.81% 000-421460 AT&T Franchise Fee 300,000.00 73,257.87 187,352.45 163,315.58 - 136,684.42 54.44% 000-421480 Other Telecom Franchise 100,000.00 2,850.70 77,497.36 55,196.35 - 44,803.65 55.20% 000-421500 Solid Waste Franchise Fee 138,000.00 24,326.36 102,118.84 94,786.98 - 43,213.02 68.69% TOTAL Franchises 2,306,600.00 543,037.84 1,507,346.08 1,543,942.48 - 762,657.52 66.94% Permits 000-431100 Home Occupation Permit 500.00 70.00 490.00 490.00 - 10.00 98.00% 000-431205 Building Permit - Residential 483,000.00 201,834.50 319,421.00 468,917.50 - 14,082.50 97.08% 000-431210 Building Permit - Commercial 170,000.00 238,504.00 129,230.00 595,837.00 - (425,837.00) 350.49% 000-431215 Building Permit - General 292,000.00 66,741.00 137,539.00 148,094.00 - 143,906.00 50.72% 000-431300 Mobile Home Permit 300.00 125.00 200.00 225.00 - 75.00 75.00% 000-431400 Signs Permit 7,000.00 1,858.00 4,752.00 3,930.00 - 3,070.00 56.14% 000-431500 Food Establishmnt Permit 60,000.00 3,360.00 59,690.00 57,890.00 - 2,110.00 96.48% 000-431600 Garage Sale Permit 10,500.00 2,948.00 8,180.00 7,024.00 - 3,476.00 66.90% 000-431700 Plumbing Permit 117,000.00 42,177.00 83,517.25 103,712.00 - 13,288.00 88.64% 000-431750 Electrical Permit 58,800.00 22,380.00 43,360.00 53,320.00 - 5,480.00 90.68% 000-431800 Mechanical Permit 59,520.00 21,640.00 40,300.00 51,240.00 - 8,280.00 86.09% 000-431900 Solicitor/Peddler Permit 1,500.00 940.00 1,130.00 1,004.50 - 495.50 66.97% 000-431950 Animal/Pet Permit 1,500.00 200.00 790.00 215.00 - 1,285.00 14.33% 000-432000 Cert. of Occupancy Prmt 7,000.00 2,250.00 5,350.00 5,250.00 - 1,750.00 75.00% *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 000-432100 Security Alarm Permit 35,000.00 11,390.00 27,408.00 30,596.00 - 4,404.00 87.42% 000-432300 Grading/Clearing Permit 4,000.00 2,577.00 5,604.95 5,900.00 - (1,900.00) 147.50% 000-432400 Development Permit 81,880.00 14,456.35 - 14,456.35 000-435000 Fire Permit 15,000.00 8,780.00 14,341.00 21,525.00 - (6,525.00) 143.50% TOTAL Permits 1,404,500.00 642,230.85 881,303.20 1,569,626.35 - (232,550.00) 111.76% Licenses 000-441000 Alcohol Beverage License 8,000.00 2,832.50 6,112.50 6,110.00 - 1,890.00 76.38% 000-441300 Mobile Home License 160.00 - 160.00 160.00 - - 100.00% 000-442000 Contractors License 40,000.00 13,300.00 34,310.00 42,450.00 - (2,450.00) 106.13% 000-444000 Pet License 3,000.00 915.00 2,367.00 2,535.00 - 465.00 84.50% TOTAL Licenses 51,160.00 17,047.50 42,949.50 51,255.00 - (95.00) 100.19% Fees 000-451000 Municipal Court Fines 884,000.00 188,335.35 770,056.45 607,008.82 - 276,991.18 68.67% 000-451100 Arrest Fee 28,053.00 6,860.25 28,384.07 21,355.64 - 6,697.36 76.13% 000-451110 Expunction Fee 60.00 - 90.00 90.00 - (30.00) 150.00% 000-451200 Warrant Fees 130,000.00 22,677.18 98,409.17 83,763.88 - 46,236.12 64.43% 000-451210 Court - Claims & Judgements - (170.00) (3,204.40) (461.40) - 461.40 0.00% 000-451340 Judicial Fee - City 3,796.00 933.11 3,852.86 2,956.51 - 839.49 77.88% 000-451400 Traffic Fine Costs TTL 13,492.00 3,220.12 13,663.28 10,145.91 - 3,346.09 75.20% 000-451510 Juvenile Case Mgmt Fee 31,616.00 7,801.15 32,096.99 24,673.17 - 6,942.83 78.04% 000-451520 Truancy Fee 5,342.00 1,401.43 5,662.60 4,338.60 1,003.40 81.22% 000-451600 Technology Fund Fee 22,932.00 6,215.14 25,209.38 19,840.62 - 3,091.38 86.52% 000-451700 Security Fee 19,448.00 4,661.36 19,583.52 14,880.48 - 4,567.52 76.51% 000-451800 Time Payment Fee - City 5,616.00 1,284.32 4,287.53 5,012.05 - 603.95 89.25% 000-451850 State Fines 10% Service Fee 40,838.00 10,615.93 37,478.01 29,228.42 - 11,609.58 71.57% 000-451900 DPS Payment - Local 47,665.00 1,674.81 7,247.17 6,198.14 - 41,466.86 13.00% 000-452000 Child Safety Fee 13,522.00 907.77 13,031.15 2,913.48 - 10,608.52 21.55% 000-452100 Platting Fees 57,000.00 15,000.00 48,000.00 52,500.00 - 4,500.00 92.11% 000-452200 Site Plan Fee 30,000.00 8,500.00 29,000.00 24,500.00 - 5,500.00 81.67% 000-452300 Plan Check Fee 432,000.00 251,183.50 293,282.50 602,583.00 - (170,583.00) 139.49% 000-452310 Miscellaneous Review Fee 600.00 - 300.00 - - 600.00 0.00% 000-452320 Tree Mitigation Admin Fee 12,000.00 165.00 7,282.50 10,352.70 - 1,647.30 86.27% 000-452400 BOA/Zoning Fees 2,000.00 610.51 2,000.00 2,610.51 - (610.51) 130.53% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 000-452600 Specific Use/Zone Chng Fee 12,600.00 2,000.00 9,300.00 15,000.00 - (2,400.00) 119.05% 000-452710 Zoning Ltr & Dev Rights 1,500.00 1,350.00 1,350.00 2,250.00 - (750.00) 150.00% 000-453100 Reinspection Fees 45,000.00 29,050.00 76,480.00 84,125.00 - (39,125.00) 186.94% 000-453110 Swim Pool Inspection Fee 2,600.00 1,760.00 1,760.00 1,760.00 - 840.00 67.69% 000-453200 Lot Abatement 5,000.00 - 1,000.17 1,325.50 - 3,674.50 26.51% 000-453211 Admin Fee-Inspections 6,600.00 4,600.00 9,000.00 10,800.00 - (4,200.00) 163.64% 000-453310 Misc Inspection Fee 150.00 - 100.00 - - 150.00 0.00% 000-453710 Foster Care 1,000.00 350.00 850.00 900.00 - 100.00 90.00% 000-454200 Pool Gate Admission Fee 24,750.00 9,020.00 7,254.05 9,020.00 - 15,730.00 36.44% 000-454300 Seasonal Pool Pass Fee 4,900.00 5,144.00 4,770.00 5,144.00 - (244.00) 104.98% 000-456110 Senior Center Memberships - - 2,988.00 - - - 0.00% 000-456120 Senior Center Meal Fee - - 864.00 401.00 - (401.00) 0.00% 000-456500 Haz Mat Fees 6,000.00 400.00 2,941.00 400.00 - 5,600.00 6.67% 000-456600 Fire Re-inspection Fee 1,000.00 350.00 850.00 900.00 - 100.00 90.00% 000-458110 Sale of Merchandise-GovDeal 20,000.00 4,465.47 26,627.98 25,904.77 - (5,904.77) 129.52% 000-458300 Sale of Property/Auction 4,000.00 - 2,194.00 - - 4,000.00 0.00% 000-458400 Civic Center Rental Fees 175,000.00 61,510.00 134,973.25 147,129.00 - 27,871.00 84.07% 000-458401 Capital Recovery Fee-Civic Cntr 10,000.00 5,775.00 8,900.00 12,335.00 - (2,335.00) 123.35% 000-458450 North Center Rental Fees 18,500.00 6,550.00 16,200.00 18,412.50 - 87.50 99.53% 000-458460 Senior Center Rental - 1,400.00 16,162.00 8,100.00 - (8,100.00) 0.00% 000-458500 Community Center Rental Fees 25,000.00 8,257.50 27,415.00 23,335.50 - 1,664.50 93.34% 000-458550 Pavilion Rental Fees 17,000.00 7,368.00 14,753.50 14,150.50 - 2,849.50 83.24% 000-458560 Chamber of Comm rent 7,800.00 1,950.00 6,050.00 5,850.00 - 1,950.00 75.00% 000-458650 NonResident User Fee-BVYA 15,000.00 6.00 10,120.00 1,506.00 - 13,494.00 10.04% 000-458660 BVYA Utility Reimbursement 13,000.00 - 10,092.81 17,985.79 - (4,985.79) 138.35% 000-458670 SYSA Utility Reimbursement 7,000.00 - - - - 7,000.00 0.00% 000-458675 Lions Futbol Utility Reimbursement 14,052.00 - 3,516.00 5,860.00 - 8,192.00 41.70% 000-458700 Vehicle Impoundment 8,000.00 2,450.00 5,250.00 7,330.00 - 670.00 91.63% 000-459200 NSF Check Fee 250.00 - 50.00 50.00 - 200.00 20.00% 000-459300 Notary Fee 250.00 18.00 144.00 108.00 - 142.00 43.20% 000-459400 Maps, Copies, UDC, & Misc F 250.00 - 60.00 5.00 - 245.00 2.00% 000-459600 Animal Adoption Fee 10,000.00 5,216.00 9,317.89 14,965.00 - (4,965.00) 149.65% 000-459700 Pet Impoundment Fee 10,000.00 1,818.50 8,489.30 4,927.50 - 5,072.50 49.28% 000-459800 Police Reports Fee 5,400.00 1,377.10 4,046.70 4,523.40 - 876.60 83.77% TOTAL Fees 2,251,582.00 694,062.50 1,859,582.43 1,968,993.99 - 282,588.01 87.45% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 Fines 000-463000 Library Fines 28,000.00 6,326.76 18,694.88 17,606.54 - 10,393.46 62.88% TOTAL Fines 28,000.00 6,326.76 18,694.88 17,606.54 - 10,393.46 62.88% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,077.00 - 10,258.29 21,077.76 - (0.76) 100.00% 000-473200 City of Seguin - Fire Contract 29,231.00 7,307.70 23,238.48 21,923.10 - 7,307.90 75.00% 000-473300 Guad Co - Library 212,000.00 36,192.00 176,628.30 162,864.00 - 49,136.00 76.82% 000-473400 Randolph AFB-Animal Cntrl 1,200.00 - 1,200.00 500.00 - 700.00 41.67% 000-474200 Library Services - Cibolo 35,000.00 - 35,000.00 - - 35,000.00 0.00% 000-474210 Library Services-Selma 32,000.00 - 31,540.00 - - 32,000.00 0.00% 000-474400 Dispatch Service - Cibolo 166,000.00 40,000.00 120,026.00 120,000.00 - 46,000.00 72.29% 000-474600 School Crossing Guard-Bexar 38,500.00 12,857.34 27,016.43 30,942.65 - 7,557.35 80.37% 000-474610 School Cross Guard-Guadalupe 38,000.00 10,859.65 28,791.11 28,561.61 - 9,438.39 75.16% 000-474620 School Crossing Guard-Comal 1,500.00 - 1,565.98 - - 1,500.00 0.00% 000-474700 School Officer Funding 255,000.00 - 127,500.00 127,500.00 - 127,500.00 50.00% 000-474750 Crime Victim Liaison Agreement 50,000.00 12,500.00 25,000.00 37,500.00 - 12,500.00 75.00% TOTAL Inter-Jurisdictional 879,508.00 119,716.69 607,764.59 550,869.12 - 328,638.88 62.63% Fund Transfers 000-480000 Indirect Costs - EMS 150,087.00 37,521.75 112,730.67 112,565.25 - 37,521.75 75.00% 000-480100 Indirect Costs - Hotel/Motel 66,405.00 16,601.25 - 49,803.75 - 16,601.25 75.00% 000-481000 Transfer In Reserves 950,000.00 - - - - 950,000.00 0.00% 000-482200 Transfer-Vehicle Replcemt 43,278.00 - - - - 43,278.00 0.00% 000-482300 Transfer IN-Resrv Child Saf 126,345.00 - - - - 126,345.00 0.00% 000-485000 Interfund Charge-Drainage 184,425.00 46,106.25 40,612.50 138,318.75 - 46,106.25 75.00% 000-486000 Interfund Chrges-Admin W&S 1,186,812.00 296,703.00 864,262.49 890,109.00 - 296,703.00 75.00% 000-487000 Interfund Charges-Fleet 397,581.00 99,395.25 155,223.76 298,185.75 - 99,395.25 75.00% 000-488000 Interfund Charges-4B 430,445.00 107,611.26 37,517.99 322,833.74 - 107,611.26 75.00% 000-489000 Transfer In 107,367.00 - - - - 107,367.00 0.00% TOTAL Fund Transfers 3,642,745.00 603,938.76 1,210,347.41 1,811,816.24 - 1,830,928.76 49.74% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2017 Miscellaneous 000-491000 Interest Earned 800.00 70.52 599.08 711.64 - 88.36 88.96% 000-491200 Investment Income 60,000.00 43,109.83 55,586.89 100,963.52 - (40,963.52) 168.27% 000-491800 Gain/Loss - 5,288.08 (28,397.02) (1,049.53) - 1,049.53 0.00% 000-491900 Unrealized Gain/Loss - 2,076.75 17,825.54 (9,220.99) - 9,220.99 0.00% 000-493120 Donations-Public Library 2,500.00 3,806.00 2,182.73 3,996.65 - (1,496.65) 159.87% 000-493400 Donation - Animal Control 10,000.00 3,793.27 140.00 13,287.27 - (3,287.27) 132.87% 000-493401 Donations-A/C Microchip 5,000.00 120.00 1,400.00 250.00 - 4,750.00 5.00% 000-493402 Donations-Spay&Neuter 15,000.00 3.50 10,278.50 810.00 14,190.00 5.40% 000-493403 Donations-Animal Adoption Trailer - 450.29 2,222.00 552.29 - (552.29) 0.00% 000-493404 Donations-TNR Program 1,000.00 - 600.00 - - 1,000.00 0.00% 000-493460 Donations-Parks 4,000.00 13,741.09 - 13,741.09 - (9,741.09) 343.53% 000-493465 Donations-Senior Center - 2,966.36 8,150.02 8,066.72 - (8,066.72) 0.00% 000-493502 Donations-PD - 1,634.25 1,799.68 5,234.25 - (5,234.25) 0.00% 000-493503 Donations-Fire Rescue - - 21.00 000-493618 Donations-Veteran's Memorial 6,000.00 - 5,650.67 - - 6,000.00 0.00% 000-494481 LawEnforcemtOfficersStnd&Ed 3,900.00 - 3,850.98 3,679.47 - 220.53 94.35% 000-494482 Grants - Police, Fire, Gen Fund - 541.11 4,902.95 5,433.14 - (5,433.14) 0.00% 000-495100 Mobile Stage Rental Fees - 1,550.00 1,550.00 1,550.00 - (1,550.00) 0.00% 000-497000 Misc Income-Gen Fund 40,000.00 5,805.55 29,779.91 17,388.20 - 22,611.80 43.47% 000-497005 Schertz Magazine Advertising 190,000.00 41,375.00 141,525.00 145,525.00 - 44,475.00 76.59% 000-497100 Misc Income-Police 7,500.00 3,392.26 14,509.12 16,677.96 - (9,177.96) 222.37% 000-497150 Misc Income-Fire Department - - - 1,750.00 - (1,750.00) 0.00% 000-497200 Misc Income-Library 5,000.00 1,247.25 3,503.76 3,661.60 - 1,338.40 73.23% 000-497210 Misc Income-Library Copier 19,500.00 4,652.25 14,894.00 13,253.10 - 6,246.90 67.96% 000-497300 Misc Income-Animal Control - - 360.00 390.00 - (390.00) 0.00% 000-497400 Misc Income-Streets Dept.30,000.00 9,073.75 29,991.38 47,596.30 - (17,596.30) 158.65% 000-497500 Misc Income-TML Insurance 5,000.00 3,664.11 873.33 9,252.06 - (4,252.06) 185.04% 000-497550 Misc Income-TML Reimbursemt 20,000.00 7,013.90 11,610.09 10,866.33 - 9,133.67 54.33% 000-497600 Misc Income-Vending Mach.2,500.00 605.55 1,565.15 1,495.39 - 1,004.61 59.82% 000-498000 Reimbursmnt-Gen Fund 35,000.00 17,540.55 18,437.97 19,484.63 - 15,515.37 55.67% 000-498100 Reimbursmnt Fire - Training 3,500.00 - 4,360.00 7.00 - 3,493.00 0.20% 000-498105 Reimburmnt Police - DEA - 1,805.19 4,212.11 5,763.94 - (5,763.94) 0.00% 000-498107 Reimburmnt Police - Event - - 3,500.00 - - - 0.00% 000-498110 Reimbursmnt Fire - Emg. Acti-O 20,000.00 - 42,194.10 3,267.16 - 16,732.84 16.34% 000-498150 Reimbursemnt - Library 2,500.00 - - 4,673.27 - (2,173.27) 186.93% TOTAL Miscellaneous 488,700.00 175,326.41 409,657.94 449,078.46 - 39,642.54 91.89% TOTAL REVENUES 29,773,195.00 4,798,327.94 22,286,298.22 24,429,843.32 - 5,275,949.03 82.05% Cash in Bank Claim on Operating Cash Pool-Checking -$ Cash in Investments LOGIC Investment-General Fund 11,459,979.68 LOGIC Investment-Equip Replacement 74,608.95 LOGIC Investment-Veh Replacement 503,071.04 LOGIC Investment-Air Condi Replacment 273,775.26 CAPITAL ONE Investment-General Fund 1,378,507.12 Total Cash in Bank & Investments 13,836,523.89$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2017 GENERAL FUND OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2016-17 419,931 328,521 5,447,189 2,515,077 2,106,927 120,850 42,362 34,666 58,291 2015-16 360,300 303,202 4,754,503 3,709,486 888,174 211,253 50,559 54,867 27,116 21,347 10,866 8,696 2014-15 357,436 356,940 4,463,962 2,741,991 1,198,153 85,775 44,720 25,398 30,488 49,777 14,839 3,787 2013-14 363,589 538,568 3,641,091 2,726,044 585,058 72,116 16,554 48,791 18,572 20,939 10,460 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 ADVALOREM TAX OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2016-17 574,470 758,598 580,171 560,431 747,281 486,739 432,444 669,542 553,540 2015-16 479,069 744,668 529,686 493,136 783,019 530,498 531,707 615,841 568,508 523,141 691,061 678,167 2014-15 495,499 638,904 505,026 421,339 795,382 450,965 494,050 723,404 465,966 496,241 759,879 508,305 2013-14 481,247 657,271 554,578 416,261 728,443 487,933 541,476 781,057 692,446 448,577 680,332 547,431 2012-13 659,150 575,041 474,246 424,191 632,716 415,829 405,378 660,648 544,675 563,636 650,124 487,170 -18.7 1.9% 13.2%-18.7% 8.7% $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 Sales Tax -General Fund OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2016-17 252,947 191,140 213,951 2015-16 237,314 183,530 173,336 178,081 2014-15 215,257 172,814 172,628 227,438 2013-14 133,486 115,592 176,520 213,412 2012-13 101,440 94,054 96,303 123,044 $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 CITY PUBLIC SERVICE 106-SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 81,450.00 - - - - 81,450.00 0.00% Miscellaneous 114,900.00 34,556.19 33,138.81 73,393.03 - 41,506.97 63.88% TOTAL REVENUES 196,350.00 34,556.19 33,138.81 73,393.03 - 122,956.97 37.38% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 10,750.00 - - - - 10,750.00 0.00% TOTAL GENERAL GOVERNMENT 10,750.00 - - - - 10,750.00 0.00% CULTURAL Festival of Angels 13,000.00 - 11,871.69 10,912.90 - 2,087.10 83.95% Employee Appreciation Event 13,000.00 1,652.89 4,272.45 10,338.72 349.93 2,311.35 82.22% 4th of July Jubilee 26,000.00 4,212.50 - 4,212.50 1,008.25 20,779.25 20.08% National Night Out 300.00 - - - - 300.00 0.00% Wilenchik Walk for Life 25,000.00 9,116.32 3,732.92 12,620.00 - 12,380.00 50.48% Schertz Fest 30,000.00 - - 35.00 - 29,965.00 0.12% Schertz Sweetheart 34,250.00 10,109.29 15,182.10 13,431.64 (32.22) 20,850.58 39.12% Hal Baldwin Scholarship 20,050.00 5,000.00 14,247.75 14,047.17 7.60 5,995.23 70.10% Other Events 14,000.00 198.34 5,560.47 7,765.86 300.00 5,934.14 57.61% TOTAL CULTURAL 175,600.00 30,289.34 54,867.38 73,363.79 1,633.56 100,602.65 42.71% TOTAL EXPENDITURES 186,350.00 30,289.34 54,867.38 73,363.79 1,633.56 111,352.65 40.25% REVENUE OVER(UNDER) EXPEND 10,000.00 4,266.85 (21,728.57) 29.24 (1,633.56) 11,604.32 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 ************************************************** 2 0 1 6 - 2 0 1 7 ************************************************** 106-SPECIAL EVENTS FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fund Transfers 000-481000 Transfer from Reserves 10,750.00 - - - - 10,750.00 0.00% 000-481314 Transfer from Hotel/Motel - - - - - - 0.00% 000-486100 Transfer In 9,000.00 - - - - 9,000.00 0.00% 000-486101 Transfer In - General Fund 61,700.00 - - - - 61,700.00 0.00% TOTAL Fund Transfers 81,450.00 - - - - 81,450.00 0.00% Miscellaneous 000-491200 Investment Income - 46.19 55.81 123.03 - (123.03) 0.00% 000-492200 Wilenchik Walk for Life 25,000.00 1,210.00 14,513.00 12,620.00 - 12,380.00 50.48% 000-493256 Donations - Police Events 3,000.00 26,565.00 - 26,565.00 - (23,565.00) 885.50% 000-493000 July 4th Activities 31,000.00 - - - - 31,000.00 0.00% 000-493150 SchertzQ 35,000.00 - - - - 35,000.00 0.00% 000-493455 Proceeds-Festival of Angels - 5,030.00 720.00 5,615.00 - (5,615.00) 0.00% 000-493460 Schertz Sweetheart 850.00 1,705.00 1,240.00 1,705.00 - (855.00) 200.59% 000-493621 Hal Baldwin Scholarship 20,050.00 - 16,360.00 25,765.00 - (5,715.00) 128.50% 000-497000 Misc Income - - 250.00 1,000.00 - (1,000.00) 0.00% TOTAL Miscellaneous 114,900.00 34,556.19 33,138.81 73,393.03 - 41,506.97 63.88% TOTAL REVENUES 196,350.00 34,556.19 33,138.81 73,393.03 - 122,956.97 37.38% C I T Y O F S C H E R T Z ************************************************** 2 0 1 6 - 2 0 1 7 ************************************************** REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 Cash in Bank Claim on Operating Cash Pool-Checking 53,406.50$ Cash in Investments Texas Class- Special Events 17,014.12 Total Cash in Bank & Investments 70,420.62$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2017 SPECIAL EVENTS FUND 110-PEG FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 113,300.00 21,998.71 76,315.81 67,771.31 - 45,528.69 59.82% TOTAL REVENUES 113,300.00 21,998.71 76,315.81 67,771.31 - 45,528.69 59.82% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental - - 864.99 - - - 0.00% TOTAL GENERAL GOVERNMENT - - 864.99 - - - 0.00% MISC & PROJECTS Projects 108,600.00 - 30,492.46 449.00 - 108,151.00 0.41% TOTAL MISC & PROJECTS 108,600.00 - 30,492.46 449.00 - 108,151.00 0.41% TOTAL EXPENDITURES 108,600.00 - 31,357.45 449.00 - 108,151.00 0.41% REVENUE OVER(UNDER) EXPEND 4,700.00 21,998.71 44,958.36 67,322.31 - (62,622.31) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 ************************************************** 2 0 1 6 - 2 0 1 7 ************************************************** 110-PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421350 Time Warner - PEG Fee 50,000.00 13,330.73 50,406.06 39,887.09 - 10,112.91 79.77% 000-421465 AT&T PEG Fee 63,300.00 8,667.98 25,909.75 27,884.22 - 35,415.78 44.05% TOTAL Franchises 113,300.00 21,998.71 76,315.81 67,771.31 - 45,528.69 59.82% TOTAL REVENUES 113,300.00 21,998.71 76,315.81 67,771.31 - 45,528.69 59.82% C I T Y O F S C H E R T Z ************************************************** 2 0 1 6 - 2 0 1 7 ************************************************** REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 Cash in Bank Cash Balance 621,979.35$ Total Cash in Bank & Investments 621,979.35$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2016 PEG FUND 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 229,096.00 128,744.56 191,431.33 197,222 - 31,874.20 86.09% Permits - - 119,741.40 49,563.52 - (49,563.52) 0.00% Fees 19,219,995.00 5,241,018.27 13,853,344.19 15,604,285 - 3,615,709.86 81.19% Fund Transfers 1,681,081.00 34,230.00 64,980.00 68,460 - 1,612,621.00 4.07% Miscellaneous 163,047.00 44,853.40 49,280.60 379,912 - (216,865.31) 233.01% TOTAL REVENUES 21,293,219.00 5,448,846.23 14,278,777.52 16,299,442.77 - 4,993,776.23 76.55% EXPENDITURE SUMMARY NON DEPARTMENTAL Transfer to Public Improvements 699,161.00 - - - - 699,161.00 0.00% TOTAL NON DEPARTMENTAL 699,161.00 - - - - 699,161.00 0.00% BUSINESS OFFICE Personnel Services 472,754.00 99,617.21 312,705.68 318,319.95 - 154,434.05 67.33% Supplies 4,300.00 467.96 2,858.43 467.96 25.00 3,807.04 11.46% Human Services - - 201.00 203.00 - (203.00) 0.00% City Support Services 7,125.00 - - 27.50 - 7,097.50 0.39% Utility Services 700.00 226.63 451.15 391.64 - 308.36 55.95% Operations Support 140,500.00 26,240.53 100,578.91 83,999.67 88.78 56,411.55 59.85% Staff Support 7,050.00 1,264.47 3,374.35 2,498.34 43.30 4,508.36 36.05% Professional Services 85,000.00 28,451.74 75,495.59 86,379.94 - (1,379.94) 101.62% Maintenance Services 8,000.00 1,260.00 5,700.00 4,860.00 1,780.00 1,360.00 83.00% Operating Equipment 600.00 - - - 3,400.40 (2,800.40) 566.73% Capital Outlay - - 44,129.80 - - - 0.00% TOTAL BUSINESS OFFICE 726,029.00 157,528.54 545,494.91 497,148.00 5,337.48 223,543.52 69.21% ******************************************************* 2 0 1 6 - 2 0 1 7 ****************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ******************************************************* 2 0 1 6 - 2 0 1 7 ****************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 W & S ADMINISTRATION Personnel Services 1,161,362.00 338,476.47 862,520.27 785,994.69 - 375,367.31 67.68% Supplies 191,500.00 73,333.70 140,832.46 132,583.23 7,107.59 51,809.18 72.95% Human Services - 202.00 282.00 539.00 - (539.00) 0.00% City Support Services 99,500.00 20,849.82 45,114.81 64,271.87 - 35,228.13 64.59% Utility Services 3,504,060.00 834,136.07 2,344,253.04 2,251,929.99 105.00 1,252,025.01 64.27% Operations Support 11,500.00 1,314.68 5,784.99 4,002.06 14.39 7,483.55 34.93% Staff Support 27,350.00 7,526.22 19,045.21 13,992.74 1,046.78 12,310.48 54.99% City Assistance 2,000.00 540.00 1,293.00 1,337.00 - 663.00 66.85% Professional Services 179,729.00 107,704.50 131,315.52 210,894.36 21,298.32 (52,463.68) 129.19% Fund Charges/Transfers 4,467,025.00 831,637.60 3,010,881.50 3,646,388.49 - 820,636.51 81.63% Maintenance Services 7,558,090.00 1,996,640.58 5,183,663.90 5,434,511.62 6,630.83 2,116,947.55 71.99% Other Costs 35,000.00 - 27,160.20 36,605.45 - (1,605.45) 104.59% Debt Service 1,578,511.00 - 614,139.02 743,932.97 62,281.25 772,296.78 51.07% Rental-Leasing 144,500.00 - 2,623.19 23,501.89 - 120,998.11 16.26% Operating Equipment 3,500.00 515.00 - 515.00 399.98 2,585.02 26.14% Capital Outlay - - 32,904.13 - - - 0.00% TOTAL PUBLIC WORKS 18,963,627.00 4,212,876.64 12,421,813.24 13,351,000.36 98,884.14 5,513,742.50 70.92% MISC & PROJECTS PROJECTS Professional Services - 24,480.00 - 24,480.00 8,457.50 (32,937.50) 0.00% Maintenance Services 85,000.00 - - - - 85,000.00 0.00% TOTAL PROJECTS 85,000.00 24,480.00 - 24,480.00 8,457.50 52,062.50 38.75% SEWER PROJECT Professional Services 360,000.00 - - - - 360,000.00 0.00% Maintenance Services 400,000.00 - - - - 400,000.00 0.00% TOTAL SEWER PROJECTS 760,000.00 - - - - 760,000.00 0.00% TOTAL MISC & PROJECTS 845,000.00 24,480 - 24,480 8,458 812,063 3.90% TOTAL EXPENDITURES 21,233,817.00 4,394,885.18 12,967,308.15 13,872,628.36 112,679.12 7,248,509.52 65.86% ** REVENUE OVER(UNDER)EXPENSES **59,402.00 1,053,961.05 1,311,469.37 2,426,814.41 (112,679.12) (2,254,733.29) 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421490 Tower Leasing 229,096.00 128,744.56 191,431.33 197,221.80 - 31,874.20 86.09% TOTAL Franchises 229,096.00 128,744.56 191,431.33 197,221.80 - 31,874.20 86.09% Permits 000-432400 Development Permit - - 119,741.40 49,563.52 - (49,563.52) 0.00% TOTAL Permits - - 119,741.40 49,563.52 - (49,563.52) 0.00% Fees 000-455200 Garbage Collection Fee 4,270,000.00 1,181,998.85 3,307,987.58 3,461,879.71 - 808,120.29 81.07% 000-455600 Fire Line Fees 27,700.00 - 27,025.00 29,540.00 - (1,840.00) 106.64% 000-455700 Recycle Fee Revenue 284,000.00 74,077.22 212,731.76 220,829.71 - 63,170.29 77.76% 000-455800 W&S Line Constructn Reimbursemnt - 11,835.70 28,716.87 26,175.60 - (26,175.60) 0.00% 000-457100 Sale of Water 9,306,795.00 2,340,657.76 5,981,408.70 6,733,966.66 - 2,572,828.34 72.36% 000-457110 Edwards Water Lease 97,000.00 - 81,975.30 125,531.25 - (28,531.25) 129.41% 000-457120 Water Transfer Charge-Selma 42,000.00 6,560.83 42,186.19 24,641.14 - 17,358.86 58.67% 000-457130 Water Transfer Charge-U. C. - - 203.11 - - - 0.00% 000-457140 Water Transfer Charge-Converse - - 13,527.69 - - - 0.00% 000-457200 Sale of Meters 90,000.00 37,168.62 50,071.10 83,574.62 - 6,425.38 92.86% 000-457400 Sewer Charges 4,900,000.00 1,531,918.14 3,940,228.34 4,715,960.06 - 184,039.94 96.24% 000-457500 Water Penalties 200,000.00 56,176.15 165,632.55 180,336.39 - 19,663.61 90.17% 000-459200 NSF Check Fee-Water&Sewer 2,500.00 625.00 1,650.00 1,850.00 - 650.00 74.00% TOTAL Fees 19,219,995.00 5,241,018.27 13,853,344.19 15,604,285.14 - 3,615,709.86 81.19% Fund Transfers 000-481000 Transfer In- Reserve 1,544,161.00 - - - - 1,544,161.00 0.00% 000-486204 Interfnd Chrg-Drainage Bill 136,920.00 34,230.00 64,980.00 68,460.00 - 68,460.00 50.00% TOTAL Fund Transfers 1,681,081.00 34,230.00 64,980.00 68,460.00 - 1,612,621.00 4.07% ******************************************************* 2 0 1 6 - 2 0 1 7 ****************************************************** AS OF: JUNE 30, 2017 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ******************************************************* 2 0 1 6 - 2 0 1 7 ****************************************************** AS OF: JUNE 30, 2017 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z Miscellaneous 000-490000 Misc Charges 500.00 - 398.00 279,951.71 - (279,451.71) 55990.34% 000-491000 Interest Earned 800.00 256.42 313.28 639.33 - 160.67 79.92% 000-491200 Investment Income 20,000.00 12,614.55 11,605.56 26,869.58 - (6,869.58) 134.35% 000-497000 Misc Income-W&S 15,000.00 4,907.98 7,584.92 9,282.12 - 5,717.88 61.88% 000-498110 Reimbursement-SSLGC 126,747.00 27,074.45 29,378.84 63,169.57 - 63,577.43 49.84% 000-498200 Reimbursement- W&S Project - - - - - - 0.00% TOTAL Miscellaneous 163,047.00 44,853.40 49,280.60 379,912.31 - (216,865.31) 233.01% TOTAL REVENUES 21,293,219.00 5,448,846.23 14,278,777.52 16,299,442.77 - 4,993,776.23 76.55% Cash in Bank Claim on Operating Cash Pool-Checking 136,758.76$ Cash in Investments Lone Star Investment-Water&Sewer 4,605,498.34 Lone Star Investment-W&S Customer Deposits 299,116.72 Lone Star Investment-W&S Equip Replacement 179,843.03 Lone Star Investment-W&S Veh Replacement 259,799.60 Schertz Bank & Trust-Certificate of Deposit 1,089,599.19 6,433,856.88$ Total Cash in Bank & Investments 6,570,615.64$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2017 WATER & SEWER 20 3 - E M S CU R R E N T C U R R E N T P R I O R Y E A R Y - T - D Y - T - D B U D G E T 7 5 % O F FI N A N C I A L S U M M A R Y B U D G E T Q U A R T E R Y - T - D A C T U A L A C T U A L E N C U M B R B A L A N C E B UDGET RE V E N U E S U M M A R Y Fe e s 6 , 5 8 0 , 3 3 5 . 0 0 1 , 0 6 9 , 4 4 2 . 4 0 4 , 1 6 9 , 1 5 4 . 1 4 4 , 0 1 0 , 0 0 6 . 3 0 - 2 , 5 7 0 , 3 2 8 . 7 0 6 0 . 9 4 % In t e r - J u r i s d i c t i o n a l 2 , 4 1 2 , 6 2 7 . 1 7 8 9 0 , 4 8 5 . 1 9 1 , 3 5 4 , 7 8 7 . 7 3 1 , 8 1 9 , 8 6 7 . 8 0 - 5 9 2 , 7 5 9 . 3 7 7 5 . 4 3 % Fu n d T r a n s f e r s - 5 5 0 , 0 0 0 . 0 0 - 5 5 0 , 0 0 0 . 0 0 - - 0 . 0 0 % Mi s c e l l a n e o u s 1 2 6 , 8 5 0 . 0 0 83 , 4 4 0 . 0 3 66 , 3 8 3 . 2 6 19 4 , 8 4 0 . 9 9 - (6 7 , 9 9 0 . 9 9 ) 153.60% TO T A L R E V E N U E S 9 , 1 1 9 , 8 1 2 . 1 7 2 , 5 9 3 , 3 6 7 . 6 2 5 , 5 9 0 , 3 2 5 . 1 3 6 , 5 7 4 , 7 1 5 . 0 9 - 3 , 0 9 5 , 0 9 7 . 0 8 7 2 . 0 9 % EX P E N D I T U R E S U M M A R Y PU B L I C S A F E T Y SC H E R T Z E M S Pe r s o n n e l S e r v i c e s 3 , 8 6 7 , 7 5 0 . 0 0 9 7 0 , 4 8 5 . 1 2 2 , 4 1 6 , 8 0 9 . 5 5 2 , 7 9 8 , 2 4 4 . 4 5 - 1 , 0 6 9 , 5 0 5 . 5 5 7 2 . 3 5 % Su p p l i e s 4 7 2 , 4 0 4 . 0 0 1 0 7 , 8 2 6 . 1 6 2 9 7 , 3 2 3 . 9 3 3 1 9 , 0 2 6 . 2 4 3 2 , 8 9 8 . 4 5 1 2 0 , 4 7 9 . 3 1 7 4 . 5 0 % Hu m a n S e r v i c e s - 4 1 3 . 0 0 3 6 2 . 5 0 6 5 1 . 0 0 2 8 8 . 0 0 ( 9 3 9 . 0 0 ) 0 . 0 0 % Ci t y S u p p o r t S e r v i c e s 7 5 , 8 5 0 . 0 0 1 0 0 . 0 0 1 6 , 8 5 4 . 0 3 5 1 , 4 7 5 . 2 0 1 , 4 1 8 . 4 5 2 2 , 9 5 6 . 3 5 6 9 . 7 3 % Ut i l i t y S e r v i c e s 1 2 8 , 6 0 0 . 0 0 2 9 , 7 9 6 . 0 7 6 1 , 1 0 2 . 8 7 7 5 , 6 2 0 . 6 6 - 5 2 , 9 7 9 . 3 4 5 8 . 8 0 % Op e r a t i o n s S u p p o r t 8 7 , 4 0 0 . 0 0 1 3 , 3 7 5 . 8 0 5 1 , 4 5 3 . 8 3 4 5 , 8 3 0 . 1 2 1 , 9 6 3 . 0 5 3 9 , 6 0 6 . 8 3 5 4 . 6 8 % St a f f S u p p o r t 7 5 , 2 5 0 . 0 0 1 8 , 3 5 6 . 2 7 5 2 , 0 2 1 . 9 4 3 9 , 6 5 4 . 3 1 4 , 5 9 3 . 1 5 3 1 , 0 0 2 . 5 4 5 8 . 8 0 % Ci t y A s s i s t a n c e 5 6 8 , 8 6 6 . 8 1 1 9 1 , 2 1 5 . 8 7 6 , 9 5 4 . 7 8 3 7 5 , 5 0 7 . 4 7 4 9 . 9 0 1 9 3 , 3 0 9 . 4 4 6 6 . 0 2 % Pr o f e s s i o n a l S e r v i c e s 1 3 0 , 0 0 0 . 0 0 2 1 , 6 5 7 . 5 7 8 3 , 5 8 8 . 3 0 7 6 , 9 5 1 . 9 7 8 , 2 5 0 . 0 0 4 4 , 7 9 8 . 0 3 6 5 . 5 4 % Fu n d C h a r g e s / T r a n s f e r s 2 , 9 8 3 , 0 3 9 . 0 0 5 0 1 , 0 1 2 . 1 0 1 , 6 8 3 , 7 9 8 . 6 1 1 , 7 5 2 , 6 1 4 . 5 3 - 1 , 2 3 0 , 4 2 4 . 4 7 5 8 . 7 5 % Ma i n t e n a n c e S e r v i c e s 5 6 , 3 2 0 . 0 0 1 , 7 2 0 . 0 0 2 2 , 0 8 2 . 9 4 1 6 , 0 1 0 . 0 4 8 6 0 . 0 0 3 9 , 4 4 9 . 9 6 2 9 . 9 5 % De b t S e r v i c e 2 7 1 , 3 7 5 . 0 0 - 7 , 7 2 2 . 6 1 5 , 6 4 8 . 7 2 - 2 6 5 , 7 2 6 . 2 8 2 . 0 8 % Re n t a l - L e a s i n g 8 1 , 5 4 1 . 0 0 1 7 , 3 8 5 . 2 1 5 2 , 1 5 5 . 6 3 5 2 , 7 3 5 . 1 4 1 7 , 3 8 5 . 2 1 1 1 , 4 2 0 . 6 5 8 5 . 9 9 % Op e r a t i n g E q u i p m e n t 1 2 5 , 5 0 0 . 0 0 4 , 2 3 8 . 8 1 3 6 , 7 5 2 . 0 1 1 1 , 8 6 0 . 7 0 1 6 , 2 5 4 . 1 0 9 7 , 3 8 5 . 2 0 2 2 . 4 0 % Ca p i t a l O u t l a y 80 , 0 0 0 . 0 0 - 86 4 , 1 3 1 . 3 6 34 , 5 1 0 . 0 0 8 , 3 1 5 . 0 0 37 , 1 7 5 . 0 0 53.53% TO T A L P U B L I C S A F E T Y 9 , 0 0 3 , 8 9 5 . 8 1 1 , 8 7 7 , 5 8 1 . 9 8 5 , 6 5 3 , 1 1 4 . 8 9 5 , 6 5 6 , 3 4 0 . 5 5 9 2 , 2 7 5 . 3 1 3 , 2 5 5 , 2 7 9 . 9 5 6 3 . 8 5 % TO T A L E X P E N D I T U R E S 9 , 0 0 3 , 8 9 5 . 8 1 1, 8 7 7 , 5 8 1 . 9 8 5, 6 5 3 , 1 1 4 . 8 9 5, 6 5 6 , 3 4 0 . 5 5 9 2 , 2 7 5 . 3 1 3, 2 5 5 , 2 7 9 . 9 5 63.85% ** R E V E N U E O V E R ( U N D E R ) E X P E N S E S * * 1 1 5 , 9 1 6 . 3 6 71 5 , 7 8 5 . 6 4 (6 2 , 7 8 9 . 7 6 ) 91 8 , 3 7 4 . 5 4 ( 9 2 , 2 7 5 . 3 1 ) (1 6 0 , 1 8 2 . 8 7 ) C I T Y O F S C H E R T Z RE V E N U E A N D E X P E N S E R E P O R T ( U N A U D I T E D ) AS O F : J U N E 3 0 , 2 0 1 7 ** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 2 0 1 6 - 2 0 1 7 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 20 3 - E M S CU R R E N T C U R R E N T P R I O R Y E A R Y - T - D Y - T - D B U D G E T 7 5 % O F RE V E N U E S B U D G E T Q U A R T E R Y - T - D A C T U A L A C T U A L E N C U M B R B A L A N C E B U D G E T Fe e s 00 0 - 4 5 6 1 0 0 A m b u l a n c e / M i l e a g e T r a n s p o r t 6 , 2 7 2 , 1 0 0 . 0 0 1 , 0 0 3 , 9 3 7 . 7 5 4 , 0 1 3 , 1 1 2 . 7 0 3 , 7 8 1 , 3 2 5 . 5 2 - 2 , 4 9 0 , 7 7 4 . 4 8 6 0 . 2 9 % 00 0 - 4 5 6 1 1 0 S u b s c r i p t i o n P r o g r a m F e e s 3 0 , 0 0 0 . 0 0 8 2 5 . 0 0 2 7 , 9 0 0 . 0 0 2 4 , 7 4 0 . 0 0 - 5 , 2 6 0 . 0 0 8 2 . 4 7 % 00 0 - 4 5 6 1 2 0 E M T C l a s s - F e e s 9 0 , 0 0 0 . 0 0 2 3 , 7 7 5 . 0 0 1 0 0 , 7 5 4 . 9 7 6 5 , 1 2 3 . 0 0 - 2 4 , 8 7 7 . 0 0 7 2 . 3 6 % 00 0 - 4 5 6 1 2 2 C E C l a s s - F e e s 2 2 , 0 0 0 . 0 0 1 4 , 2 2 5 . 0 0 - 1 4 , 2 2 5 . 0 0 - 7 , 7 7 5 . 0 0 6 4 . 6 6 % 00 0 - 4 5 6 1 3 0 I m m u n i z a t i o n F e e s 7 , 0 0 0 . 0 0 8 , 0 1 0 . 0 0 8 , 3 6 4 . 0 0 9 , 1 3 8 . 0 0 - ( 2 , 1 3 8 . 0 0 ) 1 3 0 . 5 4 % 00 0 - 4 5 6 1 4 0 B i l l i n g F e e s - E x t e r n a l 2 5 , 0 0 0 . 0 0 4 , 7 6 0 . 6 0 1 5 , 0 5 9 . 9 7 1 3 , 9 3 4 . 7 8 - 1 1 , 0 6 5 . 2 2 5 5 . 7 4 % 00 0 - 4 5 6 1 5 0 S t a n d b y F e e s 2 5 , 0 0 0 . 0 0 2 , 0 1 3 . 0 5 - 2 1 , 8 4 8 . 5 0 3 , 1 5 1 . 5 0 8 7 . 3 9 % 00 0 - 4 5 6 1 5 5 C o m m u n i t y S e r v i c e s S u p p o r t 1 0 9 , 2 3 5 . 0 0 1 1 , 8 9 6 . 0 0 - 7 9 , 6 2 1 . 5 0 2 9 , 6 1 3 . 5 0 7 2 . 8 9 % 00 0 - 4 5 8 1 1 0 S a l e s o f M e r c h a n d i s e - G o v D e a l - - 3 , 9 3 7 . 5 0 - - - 0 . 0 0 % 00 0 - 4 5 9 2 0 0 N S F C h e c k F e e - - 25 . 0 0 50 . 0 0 - (5 0 . 0 0 ) 0.00% TO T A L F e e s 6 , 5 8 0 , 3 3 5 . 0 0 1 , 0 6 9 , 4 4 2 . 4 0 4 , 1 6 9 , 1 5 4 . 1 4 4 , 0 1 0 , 0 0 6 . 3 0 - 2 , 5 7 0 , 3 2 8 . 7 0 6 0 . 9 4 % In t e r - J u r i s d i c t i o n a l 00 0 - 4 7 3 5 0 0 S e g u i n / G u a d a l u p e C o S u p p o r t 8 4 3 , 5 7 7 . 1 7 3 1 6 , 3 4 1 . 4 4 3 0 2 , 9 4 9 . 6 7 6 3 2 , 6 8 2 . 8 8 - 2 1 0 , 8 9 4 . 2 9 7 5 . 0 0 % 00 0 - 4 7 4 3 0 0 C i b o l o S u p p o r t 3 1 9 , 0 9 8 . 0 0 1 1 9 , 6 6 1 . 7 5 2 0 1 , 9 1 8 . 7 5 2 3 9 , 3 2 3 . 5 0 - 7 9 , 7 7 4 . 5 0 7 5 . 0 0 % 00 0 - 4 7 5 1 0 0 C o m a l C o E S D # 6 1 0 0 , 0 7 6 . 0 0 3 7 , 5 2 8 . 5 0 7 1 , 4 8 7 . 5 0 7 5 , 0 5 7 . 0 0 - 2 5 , 0 1 9 . 0 0 7 5 . 0 0 % 00 0 - 4 7 5 2 0 0 L i v e O a k S u p p o r t 2 0 6 , 9 5 6 . 0 0 7 7 , 6 0 8 . 5 0 1 5 2 , 0 0 9 . 2 8 1 5 5 , 2 1 7 . 0 0 - 5 1 , 7 3 9 . 0 0 7 5 . 0 0 % 00 0 - 4 7 5 3 0 0 U n i v e r s a l C i t y S u p p o r t 2 6 8 , 8 7 1 . 0 0 1 0 0 , 8 2 6 . 6 3 1 9 1 , 0 9 0 . 6 4 2 0 1 , 6 5 3 . 2 5 - 6 7 , 2 1 7 . 7 5 7 5 . 0 0 % 00 0 - 4 7 5 4 0 0 S e l m a S u p p o r t 1 0 6 , 6 5 6 . 0 0 3 9 , 9 9 6 . 0 0 5 7 , 1 3 1 . 2 5 7 9 , 9 9 2 . 0 0 - 2 6 , 6 6 4 . 0 0 7 5 . 0 0 % 00 0 - 4 7 5 5 0 0 S c h e r t z S u p p o r t 5 0 4 , 0 8 3 . 0 0 1 8 9 , 0 3 1 . 1 3 3 5 9 , 7 3 0 . 9 3 3 7 8 , 0 6 2 . 2 5 - 1 2 6 , 0 2 0 . 7 5 7 5 . 0 0 % 00 0 - 4 7 5 6 0 0 S a n t a C l a r a S u p p o r t 1 0 , 3 5 4 . 0 0 3 , 8 8 2 . 7 5 7 , 4 7 6 . 5 7 7 , 7 6 5 . 5 0 - 2 , 5 8 8 . 5 0 7 5 . 0 0 % 00 0 - 4 7 5 8 0 0 M a r i o n S u p p o r t 1 4 , 9 5 6 . 0 0 5 , 6 0 8 . 5 0 1 0 , 9 9 3 . 1 4 1 1 , 2 1 7 . 0 0 - 3 , 7 3 9 . 0 0 7 5 . 0 0 % 00 0 - 4 7 5 9 1 0 T A S P P P r o g r a m 3 8 , 0 0 0 . 0 0 - - 38 , 8 9 7 . 4 2 - (8 9 7 . 4 2 ) 102.36% TO T A L I n t e r - J u r i s d i c t i o n a l 2 , 4 1 2 , 6 2 7 . 1 7 8 9 0 , 4 8 5 . 1 9 1 , 3 5 4 , 7 8 7 . 7 3 1 , 8 1 9 , 8 6 7 . 8 0 - 5 9 2 , 7 5 9 7 5 . 4 3 % Fu n d T r a n s f e r s 00 0 - 4 8 6 1 0 0 T r a n s f e r I n - 55 0 , 0 0 0 . 0 0 - 55 0 , 0 0 0 . 0 0 - - 0.00% TO T A L F u n d T r a n s f e r s - 5 5 0 , 0 0 0 . 0 0 - 5 5 0 , 0 0 0 . 0 0 - - 0 . 0 0 % C I T Y O F S C H E R T Z RE V E N U E R E P O R T ( U N A U D I T E D ) AS O F : J U N E 3 0 , 2 0 1 7 *** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 2 0 1 6 - 2 0 1 7 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 20 3 - E M S CU R R E N T C U R R E N T P R I O R Y E A R Y - T - D Y - T - D B U D G E T 7 5 % O F RE V E N U E S B U D G E T Q U A R T E R Y - T - D A C T U A L A C T U A L E N C U M B R B A L A N C E B U D G E T C I T Y O F S C H E R T Z RE V E N U E R E P O R T ( U N A U D I T E D ) AS O F : J U N E 3 0 , 2 0 1 7 *** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 2 0 1 6 - 2 0 1 7 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Mi s c e l l a n e o u s 00 0 - 4 9 1 0 0 0 I n t e r e s t E a r n e d 1 0 0 . 0 0 2 8 . 0 9 6 6 . 5 4 7 9 . 2 2 - 2 0 . 7 8 7 9 . 2 2 % 00 0 - 4 9 1 2 0 0 I n v e s t m e n t I n c o m e 7 5 0 . 0 0 3 1 6 . 2 2 5 5 8 . 2 4 7 2 1 . 5 9 - 2 8 . 4 1 9 6 . 2 1 % 00 0 - 4 9 3 2 0 3 D o n a t i o n s - E M S 2 , 0 0 0 . 0 0 - 5 3 1 . 1 5 1 5 0 . 0 0 - 1 , 8 5 0 . 0 0 7 . 5 0 % 00 0 - 4 9 3 2 0 5 D o n a t i o n s - G o l f T o u r n a m e n t 9 , 0 0 0 . 0 0 1 0 , 0 6 0 . 0 0 1 1 , 4 8 5 . 0 0 1 0 , 0 6 0 . 0 0 - ( 1 , 0 6 0 . 0 0 ) 1 1 1 . 7 8 % 00 0 - 4 9 5 1 0 0 U H G r a n t P r o g r a m 9 0 , 0 0 0 . 0 0 3 6 , 3 1 6 . 7 6 - 9 9 , 5 7 9 . 0 3 - ( 9 , 5 7 9 . 0 3 ) 1 1 0 . 6 4 % 00 0 - 4 9 7 0 0 0 M i s c I n c o m e 1 5 , 0 0 0 . 0 0 1 5 , 6 9 5 . 2 4 4 5 , 5 0 9 . 1 4 4 0 , 5 6 6 . 8 8 - ( 2 5 , 5 6 6 . 8 8 ) 2 7 0 . 4 5 % 00 0 - 4 9 7 1 0 0 R e c o v e r y o f B a d D e b t 1 0 , 0 0 0 . 0 0 21 , 0 2 3 . 7 2 8, 2 3 3 . 1 9 43 , 6 8 4 . 2 7 - (3 3 , 6 8 4 . 2 7 ) 436.84% TO T A L M i s c e l l a n e o u s 1 2 6 , 8 5 0 . 0 0 8 3 , 4 4 0 . 0 3 6 6 , 3 8 3 . 2 6 1 9 4 , 8 4 0 . 9 9 - ( 6 7 , 9 9 0 . 9 9 ) 1 5 3 . 6 0 % TO T A L R E V E N U E S 9 , 1 1 9 , 8 1 2 . 1 7 2 , 5 9 3 , 3 6 7 . 6 2 5 , 5 9 0 , 3 2 5 . 1 3 6 , 5 7 4 , 7 1 5 . 0 9 - 3 , 0 9 5 , 0 9 7 . 0 8 7 2 . 0 9 % Ca s h i n B a n k Cl a i m o n O p e r a t i n g C a s h P o o l - C h e c k i n g 1 8 6 , 4 4 0 . 8 2 $ Ca s h i n I n v e s t m e n t s Te x a s C l a s s - T a x N o t e 2 0 1 5 A m b u l a n c e s 8 9 , 7 5 2 . 3 9 To t a l C a s h i n B a n k & I n v e s t m e n t s 2 7 6 , 1 9 3 . 2 1 $ CA S H I N B A N K A N D I N V E S T M E N T S AS O F : J U N E 3 0 , 2 0 1 7 SC H E R T Z E M S 204-DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Permits 3,000.00 800.00 2,280.00 2,080 - 920.00 69.33% Fees 1,141,000.00 287,780.79 837,158.15 857,150 - 283,850.02 75.12% Fund Transfers 484,000.00 - - - - 484,000.00 0.00% Miscellaneous 4,200.00 4,169.38 4,795.95 11,503 - (7,302.97) 273.88% TOTAL REVENUES 1,632,200.00 292,750.17 844,234.10 870,732.95 - 761,467.05 53.35% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 301,780.00 40,922.35 298,220.66 266,854.89 - 34,925.11 88.43% Supplies 4,200.00 1,023.71 2,414.58 2,462.24 885.99 851.77 79.72% City Support Services 5,180.00 - 2,703.95 4,576.16 - 603.84 88.34% Utility Services 16,200.00 5,308.38 7,735.89 11,913.28 383.00 3,903.72 75.90% Operations Support 700.00 - - - - 700.00 0.00% Staff Support 7,000.00 1,579.80 2,527.62 4,357.77 31.73 2,610.50 62.71% City Assistance 400.00 287.00 120.00 287.00 - 113.00 71.75% Professional Services 48,720.00 31,850.00 14,500.00 33,350.00 - 15,370.00 68.45% Fund Charges/Transfers 428,134.00 106,783.50 160,929.76 320,350.50 - 107,783.50 74.82% Maintenance Services 13,600.00 3,696.03 22,030.86 5,356.21 102.66 8,141.13 40.14% Other costs 200.00 - 100.00 100.00 - 100.00 50.00% Debt Service 120,150.00 - 6,327.18 5,040.40 - 115,109.60 4.20% Operating Equipment 6,500.00 4,299.23 4,594.98 4,659.23 1,079.94 760.83 88.29% Capital Outlay - - 50,063.72 - - - 0.00% TOTAL DRAINAGE 952,764.00 195,750.00 572,269.20 659,307.68 2,483.32 290,973.00 69.46% PROJECTS City Support Services 43,389.00 - - - - 43,389.00 0.00% Operations Support 611.00 - - - - 611.00 0.00% Professional Services 71,640.00 44,420.00 - 44,420.00 27,220.00 - 100.00% Maintenance Services 538,360.00 - 13.59 - - 538,360.00 0.00% Capital Outlay - - 33,700.00 - - - 0.00% TOTAL PROJECTS 654,000.00 44,420.00 33,713.59 44,420.00 27,220.00 582,360.00 10.95% TOTAL EXPENDITURES 1,606,764.00 240,170.00 605,982.79 703,727.68 29,703.32 873,333.00 45.65% ** REVENUE OVER(UNDER) EXPEND 25,436.00 52,580.17 167,005.27 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 **************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** 204-DRAINAGE CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000-432400 Floodplain Permit 3,000.00 800.00 2,280.00 2,080.00 - 920.00 69.33% TOTAL Permits 3,000.00 800.00 2,280.00 2,080.00 - 920.00 69.33% Fees 000-457500 Drainage Penalties 10,000.00 2,357.43 7,076.42 7,299.53 - 2,700.47 73.00% 000-457600 Drainage Fee 1,131,000.00 285,423.36 830,081.73 849,850.45 - 281,149.55 75.14% TOTAL Fees 1,141,000.00 287,780.79 837,158.15 857,149.98 - 283,850.02 75.12% Fund Transfers 000-481000 Transfer In 484,000.00 - - - - 484,000.00 0.00% TOTAL Funds Transfers 484,000.00 - - - - 484,000 0.00% Miscellaneous 000-491000 Interest Earned 100.00 24.61 58.59 78.12 - 21.88 78.12% 000-491200 Investment Interest 4,000.00 4,132.77 4,737.36 10,557.85 - (6,557.85) 263.95% 000-497000 Misc Income-Drainage 100.00 12.00 - 867.00 - (767.00) 867.00% TOTAL Miscellaneous 4,200.00 4,169.38 4,795.95 11,502.97 - (7,302.97) 273.88% TOTAL REVENUES 1,632,200.00 292,750.17 844,234.10 870,732.95 - 761,467.05 53.35% C I T Y O F S C H E R T Z **************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 Cash in Bank Claim on Operating Cash Pool-Checking 171,044.66 Cash in Investments Lone Star Investment-Drainage Maint Fund 926,141.15 Total Cash in Bank & Investments 1,097,185.81$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2017 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 609,302.00 142,644.82 355,899.83 339,787.96 - 269,514.04 55.77% Miscellaneous 2,150.00 3,145.16 2,273.30 7,979.55 - (5,829.55) 371.14% TOTAL REVENUES 611,452.00 145,789.98 358,173.13 347,767.51 - 263,684.49 56.88% EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 67,165.00 8,049.00 43,472.00 66,506.22 - 658.78 99.02% Operations Support 66,425.00 6,168.13 14,910.50 31,651.97 - 34,773.03 47.65% Professional Services 3,000.00 - 3,000.00 3,000.00 - - 100.00% Fund Charges/Transfers 114,405.00 16,601.25 - 49,803.75 - 64,601.25 43.53% Maintenance Services 10,000.00 2,950.00 5,555.00 3,511.94 - 6,488.06 35.12% Operating Equipment - - - - (1,176.40) 1,176.40 0.00% TOTAL NONDEPARTMENTAL 260,995.00 33,768.38 66,937.50 154,473.88 (1,176.40) 107,697.52 58.74% TOTAL EXPENDITURES 260,995.00 33,768.38 66,937.50 154,473.88 (1,176.40) 107,697.52 58.74% REVENUE OVER(UNDER) EXPENDITURE 350,457.00 193,293.63 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 **************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** Cash in Bank Claim on Operating Cash Pool-Checking 156,188.03$ Cash in Investments Texas Class - Hotel Tax 1,191,409.09 Total Cash in Bank & Investments 1,347,597.12$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2017 HOTEL OCCUPANCY TAX FUND OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2016-17 33,917 33,203 30,940 32,131 33,710 51,467 47,698 43,479 55,151 2015-16 40,800 40,351 38,394 34,516 39,732 54,142 49,741 45,524 51,636 68,491 48,302 33,241 2014-15 44,724 42,229 35,309 33,055 46,037 58,530 43,715 43,525 53,346 72,297 51,772 39,195 2013-14 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 $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000 HOTEL OCCUPANCY TAX 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 145,000.00 1,000.00 130,000.00 98,000 - 47,000.00 67.59% Miscellaneous 45,700.00 903.98 1,176.08 2,413 - 43,286.98 5.28% TOTAL REVENUES 190,700.00 1,903.98 131,176.08 100,413.02 - 90,286.98 52.65% EXPENDITURE SUMMARY PARKLAND DEDICATION Operating Equipment 22,700.00 10,171.00 750.00 14,176.00 4,630.00 3,894.00 82.85% Capital Outlay 168,000.00 - 22,857.00 - - 168,000.00 0.00% TOTAL PARKLAND DEDICATION 190,700.00 10,171.00 23,607.00 14,176.00 4,630.00 171,894.00 9.86% TOTAL EXPENDITURES 190,700.00 10,171.00 23,607.00 14,176.00 4,630.00 171,894.00 9.86% REVENUE OVER(UNDER) EXPEND - 86,237.02 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 *********************************************** 2 0 1 6 - 2 0 1 7 *********************************************** 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458800 Parkland Dedication 145,000.00 1,000.00 130,000.00 98,000.00 - 47,000.00 67.59% TOTAL Fees 145,000.00 1,000.00 130,000.00 98,000.00 - 47,000.00 67.59% Miscellaneous 000-491000 Interest Earned 250.00 10.03 97.46 31.52 - 218.48 12.61% 000-491200 Investment Interest 1,000.00 893.95 208.50 2,381.50 - (1,381.50) 238.15% 000-497000 Misc Income - - 870.12 - - - 0.00% 000-499100 Transfer From Parks Reserve 44,450.00 - - - - 44,450.00 0.00% TOTAL Miscellaneous 45,700.00 903.98 1,176.08 2,413.02 - 43,286.98 5.28% TOTAL REVENUES 190,700.00 1,903.98 131,176.08 100,413.02 - 90,286.98 52.65% C I T Y O F S C H E R T Z *********************************************** 2 0 1 6 - 2 0 1 7 *********************************************** REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 Cash in Bank Claim on Operating Cash Pool-Checking $101,606.39 Cash in Investments Texas Class- Park Fund 329,352.29 Total Cash in Bank & Investments $430,958.68 CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2017 PARK FUND 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 85,300.00 2,935.00 41,267.50 60,665 - 24,634.70 71.12% Fund Transfers 54,950.00 - - - - 54,950.00 0.00% Miscellaneous 1,750.00 849.37 1,102.04 2,308 - (557.94) 131.88% TOTAL REVENUES 142,000.00 3,784.37 42,369.54 62,973.24 - 79,026.76 44.35% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services-Trees 142,000.00 40,177.50 67,189.00 85,901.00 - 56,099.00 60.49% TOTAL TREE MITIGATION 142,000.00 40,177.50 67,189.00 85,901.00 - 56,099.00 60.49% TOTAL EXPENDITURES 142,000.00 40,177.50 67,189.00 85,901.00 - 56,099.00 60.49% REVENUE OVER(UNDER) EXPEND - (36,393.13) (24,819.46) (22,927.76) - 22,927.76 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30,2017 *************************************************** 2 0 1 6 - 2 0 1 7 *************************************************** 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458900 Tree Mitigation 85,300.00 2,935.00 41,267.50 60,665.30 - 24,634.70 71.12% TOTAL Fees 85,300.00 2,935.00 41,267.50 60,665.30 - 24,634.70 71.12% Fund Transfers 000-481000 Transfer In - Reserves 54,950.00 - - - - 54,950.00 0.00% TOTAL Fund Transfers 54,950.00 - - - - 54,950.00 0.00% Miscellaneous 000-491000 Interest Earned 250.00 4.00 23.21 11.48 - 238.52 4.59% 000-491200 Investment Interest 1,500.00 845.37 1,078.83 2,296.46 - (796.46) 153.10% TOTAL Miscellaneous 1,750.00 849.37 1,102.04 2,307.94 - (557.94) 131.88% TOTAL REVENUES 142,000.00 3,784.37 42,369.54 62,973.24 - 79,026.76 44.35% C I T Y O F S C H E R T Z *************************************************** 2 0 1 6 - 2 0 1 7 *************************************************** REVENUE REPORT (UNAUDITED) AS OF: JUNE 30,2017 Cash in Bank Claim on Operating Cash Pool-Checking $6,017.32 Cash in Investments MBIA Investment-Tree Mitigation 311,441.37 Total Cash in Bank & Investments $317,458.69 CASH IN BANK AND INVESTMENTS AS OF: JUNE 30,2017 TREE MITIGATION FUND 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 1,020,000.00 434,232.00 698,292.00 1,063,575 - (43,575.00) 104.27% Fund Transfers - - - - - - 0.00% Miscellaneous 20,600.00 10,132.14 15,791.40 24,206 - (3,606.48) 117.51% TOTAL REVENUES 1,040,600.00 444,364.14 714,083.40 1,087,781.48 - (47,181.48) 104.53% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 156,000.00 - 1,000.00 1,000.00 - 155,000.00 0.64% TOTAL NON DEPARTMENTAL 156,000.00 - 1,000.00 1,000.00 - 155,000.00 0.64% MISC & PROJECTS PROJECTS Fund Charges/Transfers - - 366,594.84 - - - 0.00% TOTAL MISC & PROJECTS - - 366,594.84 - - - 0.00% TOTAL EXPENDITURES 156,000.00 - 367,594.84 1,000.00 - 155,000.00 0.64% REVENUE OVER(UNDER) EXPENDITURES 884,600.00 444,364.14 346,488.56 1,086,781.48 - (202,181.48) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 ******************************************************* 2 0 1 6 - 2 0 1 7 ******************************************************* 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fees 000-455900 Capital Recovery - Water 1,020,000.00 434,232.00 698,292.00 1,063,575.00 - (43,575.00) 104.27% TOTAL Fees 1,020,000.00 434,232.00 698,292.00 1,063,575.00 - (43,575.00) 104.27% Miscellaneous 000-491000 Interest Earned 600.00 26.03 437.28 126.09 - 473.91 21.02% 000-491200 Investment Income 20,000.00 10,106.11 15,354.12 24,080.39 - (4,080.39) 120.40% TOTAL Miscellaneous 20,600.00 10,132.14 15,791.40 24,206.48 - (3,606.48) 117.51% TOTAL REVENUES 1,040,600.00 444,364.14 714,083.40 1,087,781.48 - (47,181.48) 104.53% C I T Y O F S C H E R T Z ******************************************************* 2 0 1 6 - 2 0 1 7 ******************************************************* REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 Cash in Bank Claim on Operating Cash Pool-Checking 413,746.17$ Cash in Investments Lone Star Investment-Capital Recovery Water 4,047,550.92 Total Cash in Bank & Investments 4,461,297.09$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2017 CAPITAL RECOVERY WATER 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 600,000.00 300,246.60 359,941.89 568,336 - 31,664.40 94.72% Miscellaneous 25,500.00 12,307.30 27,668.26 20,104 - 5,396.38 78.84% TOTAL REVENUES 625,500.00 312,553.90 387,610.15 588,439.22 - 37,060.78 94.08% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 85,500.00 1,088.23 4,246.63 4,263.72 - 81,236.28 4.99% TOTAL NON DEPARTMENTAL 85,500.00 1,088.23 4,246.63 4,263.72 - 81,236.28 4.99% MISC & PROJECTS Professional Services 150,000.00 - - - - 150,000.00 0.00% TOTAL MISC & PROJECTS 150,000.00 - - - - 150,000.00 0.00% TOTAL EXPENDITURES 235,500.00 1,088.23 4,246.63 4,263.72 - 231,236.28 1.81% REVENUE OVER(UNDER) EXPENDITURES 390,000.00 311,465.67 383,363.52 584,175.50 - C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 ******************************************************* 2 0 1 6 - 2 0 1 7 ******************************************************* 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fees 000-455910 Capital Recovery - Waste Wtr 600,000.00 287,646.60 327,541.89 544,935.60 - 55,064.40 90.82% 000-455913 Cap Recovery-North Sewer Tr - 12,600.00 32,400.00 23,400.00 - (23,400.00) 0.00% TOTAL Fees 600,000.00 300,246.60 359,941.89 568,335.60 - 31,664.40 94.72% Miscellaneous 000-491000 Interest Earned 500.00 34.49 296.95 96.64 - 403.36 19.33% 000-491200 Investment Income 25,000.00 16,294.83 33,959.48 44,893.26 - (19,893.26) 179.57% 000-491800 Gain/Loss - (9,396.49) (35,426.62) (12,928.67) - 12,928.67 0.00% 000-491900 Unrealized Gain/Loss-Cap One - 5,374.47 28,838.45 (11,957.61) - 11,957.61 0.00% TOTAL Miscellaneous 25,500.00 12,307.30 27,668.26 20,103.62 - 5,396.38 78.84% TOTAL REVENUES 625,500.00 312,553.90 387,610.15 588,439.22 - 37,060.78 94.08% C I T Y O F S C H E R T Z ******************************************************* 2 0 1 6 - 2 0 1 7 ******************************************************* REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 Cash in Bank Claim on Operating Cash Pool-Checking 425,171.71$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 3,235,975.69 Capital One-Investment 1,761,431.02 Total Cash in Bank & Investments 5,422,578.42$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2017 CAPITAL RECOVERY SEWER 505-TAX I&S CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 6,102,433.00 87,210.63 5,777,515.17 6,108,623.22 - (6,190.22) 100.10% Fund Transfers 40,860.00 - - - - 40,860.00 0.00% Miscellaneous 471,288.00 394,930.60 4,547,102.99 503,006.16 - (31,718.16) 106.73% TOTAL REVENUES 6,614,581.00 482,141.23 10,324,618.16 6,611,629.38 - 2,951.62 99.96% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 102,500.00 - 83,574.23 1,550.00 - 100,950.00 1.51% Debt Service 6,512,081.00 - 4,411,781.19 5,329,583.69 - 1,182,497.31 81.84% Other Financing Sources - - 4,220,709.38 - - - 0.00% TOTAL GENERAL GOVERNMENT 6,614,581.00 - 8,716,064.80 5,331,133.69 - 1,283,447.31 80.60% - TOTAL EXPENDITURES 6,614,581.00 - 8,716,064.80 5,331,133.69 - 1,283,447.31 80.60% ** REVENUE OVER(UNDER) EXPEND - 1,280,495.69 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 ****************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** 505-TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411900 Property Tax Revenue 6,102,433.00 87,210.63 5,777,515.17 6,108,623.22 - (6,190.22) 100.10% TOTAL Taxes 6,102,433.00 87,210.63 5,777,515.17 6,108,623.22 - (6,190.22) 100.10% 000-486000 Transfer From Reserves 40,860.00 - - - - 40,860.00 0.00% TOTAL Fund Transfers 40,860.00 - - - - 40,860.00 0.00% Miscellaneous 000-491000 Interest Earned 500.00 34.14 256.48 163.49 - 336.51 32.70% 000-491200 Investment Earnings 4,000.00 33,877.71 5,727.76 41,823.92 - (37,823.92) 1045.60% 000-495015 Contribution from SED 366,788.00 361,018.75 356,118.75 361,018.75 - 5,769.25 98.43% 000-495020 Contribution from YMCA 100,000.00 - - 100,000.00 - - 100.00% 000-498000 Proceeds From Refunding Debt - - 4,185,000.00 - - - 0.00% TOTAL Miscellaneous 471,288.00 394,930.60 4,547,102.99 503,006.16 - (31,718.16) 106.73% TOTAL REVENUES 6,614,581.00 482,141.23 10,324,618.16 6,611,629.38 - 2,951.62 99.96% C I T Y O F S C H E R T Z ****************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF NON DEPARTMENTAL BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101-541500 Paying Agent 2,500.00 - 1,350.00 1,550.00 - 950.00 62.00% 101-541502 Cost of Bond Issuance 100,000.00 - 82,224.23 - - 100,000.00 0.00% TOTAL Professional Services 102,500.00 - 83,574.23 1,550.00 - 100,950.00 1.51% Debt Service 101-555612 Bond-GO Refunding 2010-Principal 285,000.00 - 275,000.00 285,000.00 - - 100.00% 101-555612.1 Bond-GO Refunding 2010 Interest 47,025.00 - 29,775.00 25,650.00 - 21,375.00 54.55% 101-555626 LS&D SR2006-Principal - - 394,772.50 - - - 0.00% 101-555626.1 LS&D SR2006-Interest - - 0.01 - - - 0.00% 101-555628 CO Bond 2007-Principal - - - - - - 0.00% 101-555628.1 CO Bond 2007-Interest - - 2,461.75 - - - 0.00% 101-555629 GO Bond 2007-Principal 280,000.00 - 264,944.60 280,000.00 - - 100.00% 101-555629.1 GO Bond 2007-Interest 147,945.00 - 82,214.00 76,821.25 - 71,123.75 51.93% 101-555630 GO Bond SR2008 Principal 460,000.00 - 440,000.00 460,000.00 - - 100.00% 101-555630.1 GO Bond SR2008 Interest 278,362.00 - 153,016.50 143,930.50 - 134,431.50 51.71% 101-555631 GO Bond SR2009 Principal 550,000.00 - 540,000.00 550,000.00 - - 100.00% 101-555631.1 BO Bond SR2009 Interest 266,325.00 - 145,387.50 137,287.50 - 129,037.50 51.55% 101-555633 GO SR2011 Principal 235,000.00 - 225,000.00 235,000.00 - - 100.00% 101-555633.1 GO SR2011 Interest 334,763.00 - 172,518.75 169,143.75 - 165,619.25 50.53% 101-555634 GO SR2011A Refund Principal 620,000.00 - 605,000.00 620,000.00 - - 100.00% 101-555634.1 GO SR2011A Refund Interest 102,404.00 - 61,861.50 54,813.25 - 47,590.75 53.53% 101-555635 GO SR2012 Principal 320,000.00 - 310,000.00 320,000.00 - - 100.00% 101-555635.1 GO SR2012 Interest 181,755.00 - 100,363.75 94,357.50 - 87,397.50 51.91% 101-555636 Tax Note - SR2013 - Principal 170,000.00 - 170,000.00 170,000.00 - - 100.00% 101-555636.1 Tax Note - SR2013 - Interest 3,995.00 - 3,400.00 2,550.00 - 1,445.00 63.83% 101-555637 Tax Note - SR 2013A - Principal 160,000.00 - 160,000.00 160,000.00 - - 100.00% 101-555637.1 Tax Note - SR2013 - Interest 3,185.00 - 3,152.51 2,112.50 - 1,072.50 66.33% 101-555638 Bond-GO 2014 Refund-Principal 100,000.00 - 100,000.00 100,000.00 - - 100.00% 101-555638.1 Bond-GO 2014 Refund-Interest 292,275.00 - 147,637.50 146,637.50 - 145,637.50 50.17% 101-555639 Tax Note - SR2015 - Principal 35,000.00 - - - - 35,000.00 0.00% 101-555639.1 Tax Note - SR2015 - Interest 3,150.00 - 1,875.17 1,564.26 - 1,585.74 49.66% 101-555640 Bond-Ref 2015 Bond- Principal 450,000.00 - 80,000.00 450,000.00 - - 100.00% 101-555640.1 Bond-GO Ref 2015- Interest 102,125.00 - 27,056.25 53,312.50 - 48,812.50 52.20% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 ****************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF NON DEPARTMENTAL BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 ****************************************************** 2 0 1 6 - 2 0 1 7 **************************************************** - 101-555641 Tax Note - SR2015A - Principal 145,000.00 - - - - 145,000.00 0.00% 101-555641.1 Tax Note - SR2015A - Interest 13,783.00 - - 6,859.42 - 6,923.58 49.77% 101-555642 GO Bond SR2016 Principal - - - 405,000.00 - (405,000.00) 0.00% 101-555642.1 GO Bond SR2016 Interest - - - 89,903.13 - (89,903.13) 0.00% 101-555643 CO Bond Tax SR2016 Principal - - - 55,000.00 - (55,000.00) 0.00% 101-555643.1 CO Bond Tax SR2016 Interest - - - 24,856.25 - (24,856.25) 0.00% 101-555644 CO Bond nonTax SR2016 Principal - - - 170,000.00 - (170,000.00) 0.00% 101-555644 CO Bond nonTax SR2016 Interest - - - 39,784.38 - (39,784.38) 0.00% 101-555900 Debt Service 924,989.00 - - - - 924,989.00 0.00% 101-555800 Bond Premium - - (83,656.10) - - - 0.00% TOTAL Debt Service 6,512,081.00 - 4,411,781.19 5,329,583.69 - 1,182,497.31 81.84% Other Financing Sources 101-556300 Payment to Refund Debt - - 4,220,709.38 - - - 0.00% TOTAL Other Financing Sources - - 4,220,709.38 - - - 0.00% TOTAL EXPENDITURES 6,614,581.00 - 8,716,064.80 5,331,133.69 - 1,283,447.31 80.60% Cash in Bank Claim on Operating Cash Pool-Checking 106,864.56$ Cash in Investments MBIA Investment- Tax I&S 2,485,208.00 Total Cash in Bank & Investments 2,592,072.56$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2017 TAX I&S 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 3,692,710.00 913,936.54 2,649,184.71 2,663,118.01 - 1,029,591.99 72.12% Miscellaneous 45,550.00 32,910.69 31,199.30 89,691.36 - (44,141.36) 196.91% TOTAL REVENUES 3,738,260.00 946,847.23 2,680,384.01 2,752,809.37 - 985,450.63 73.64% EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services - - 193,052.74 - - - 0.00% Supplies 750.00 46.96 122.83 402.08 11.98 335.94 55.21% Human Services 1,000.00 44.44 44.44 389.64 - 610.36 38.96% City Support Services 7,700.00 1,131.51 1,643.91 3,894.84 - 3,805.16 50.58% Utility Services 4,820.00 565.66 1,712.36 1,601.00 34.99 3,184.01 33.94% Operations Support 131,000.00 24,686.95 78,393.24 41,769.29 3,383.69 85,847.02 34.47% Staff Support 22,300.00 5,743.54 4,197.49 11,410.66 147.50 10,741.84 51.83% City Assistance 1,005,000.00 884.43 281.27 979.02 - 1,004,020.98 0.10% Professional Services 87,500.00 2,945.60 14,480.88 7,121.37 70.00 80,308.63 8.22% Fund Charges/Transfers 797,847.00 468,783.52 394,386.75 684,312.98 - 113,534.02 85.77% Debt Service - - 3,107.25 - - - 0.00% Operating Equipment 4,700.00 - 1,927.09 299.99 - 4,400.01 6.38% TOTAL ECONO DEVELOPMENT 2,062,617.00 504,832.61 693,350.25 752,180.87 3,648.16 1,306,787.97 36.64% MISC & PROJECTS PROJECTS - - 190,226.35 - - - 0.00% TOTAL MISC & PROJECTS - - 190,226.35 - - - 0.00% TOTAL EXPENDITURES 2,062,617.00 504,832.61 883,576.60 752,180.87 3,648.16 1,306,787.97 36.64% ** REVENUE OVER(UNDER) EXPEND 1,675,643.00 442,014.62 1,796,807.41 2,000,628.50 (3,648.16) (321,337.34) C I T Y O F S C H E R T Z ***************************************************** 2 0 1 6 - 2 0 1 7 ***************************************************** REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2017 Cash in Bank Claim on Operating Cash Pool-Checking 319,236.19$ Cash in Investments Texas Class Investment-Economic Development Corp 11,202,731.81 Schertz Bank & Trust-Certificate of Deposit 1,060,336.70 Total Cash in Bank & Investments 12,582,304.70$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2017 SED CORPORATION OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2016-17 287,235 379,299 290,086 280,216 373,641 243,369 216,222 334,771 276,770 2015-16 239,534 372,334 264,843 246,568 391,510 265,249 265,854 307,920 284,254 261,570 2014-15 247,750 319,452 252,513 210,669 397,691 225,482 247,025 361,702 232,983 248,121 379,939 254,153 2013-14 240,623 328,635 277,289 208,130 364,222 243,967 270,738 390,528 346,223 224,288 340,166 273,715 2012-13 219,717 287,520 237,123 212,096 316,358 207,915 202,689 330,324 272,337 281,818 325,062 243,585 19.9% 1.9% 13.6% $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 4B SALES TAX By Collection Month INVESTMENT REPORT C I T Y O F S C H E R T Z FOR MONTH ENDING June 30th, 2017 INVESTMENT POOLS Beginning Deposits/Interest Ending Ending Par Maturity Weighted Book Value Yield Purchases Withdrawals Earned Book Value Mkt Value Value Date Avg Mat. OPERATIONS-BANK CASH Schertz Bank & Trust - Pooled Cash 9,356,139.33 0.0500 15,524,537.32 16,183,702.75 457.95 8,697,431.85 8,697,431.85 8,697,431.85 N/A Schertz Bank & Trust - PEG Fund 621,979.35 0.0000 - - - 621,979.35 621,979.35 621,979.35 N/A TOTAL OPERATIONS 9,978,118.68 15,524,537.32 16,183,702.75 457.95 9,319,411.20 9,319,411.20 9,319,411.20 - LOGIC General Fund 12,949,003.93 1.1333 - 1,500,000.00 10,975.75 11,459,979.68 11,459,979.68 11,459,979.68 N/A 25 days G/F-Equipment Replacement 74,539.52 1.1333 - - 69.43 74,608.95 74,608.95 74,608.95 N/A 25 days G/F-Vehicle Replacement 502,602.87 1.1333 - - 468.17 503,071.04 503,071.04 503,071.04 N/A 25 days G/F-Air Conditioner Replacement 273,520.47 1.1333 - - 254.79 273,775.26 273,775.26 273,775.26 N/A 25 days SR2009 Bond-Street Projects(II)878,257.02 1.1333 - - 818.10 879,075.12 879,075.12 879,075.12 N/A 25 days GO2017 FIRE STATION 3 - 1.1333 4,000,000.00 - 528.09 4,000,528.09 4,000,528.09 4,000,528.09 N/A 25 days CO2017 AMBULANCES - 1.1333 550,000.00 - 72.61 550,072.61 550,072.61 550,072.61 N/A 25 days CO2017 BUILDING REPAIRS - 1.1333 250,000.00 - 33.01 250,033.01 250,033.01 250,033.01 N/A 25 days CO2017 FIRE APPARATUS - 1.1333 140,874.00 - 18.59 140,892.59 140,892.59 140,892.59 N/A 25 days CO2017 PARK MAINT - 1.1333 50,000.00 - 6.59 50,006.59 50,006.59 50,006.59 N/A 25 days CO2017 PARK TRAIL - 1.1333 250,000.00 - 33.01 250,033.01 250,033.01 250,033.01 N/A 25 days CO2017 SCHERTZ PKWY - 1.1333 700,000.00 - 92.41 700,092.41 700,092.41 700,092.41 N/A 25 days CO2017 STATION2 REPAIR - 1.1333 400,000.00 - 52.80 400,052.80 400,052.80 400,052.80 N/A 25 days CO2017 STREETS - 1.1333 2,200,000.00 - 290.45 2,200,290.45 2,200,290.45 2,200,290.45 N/A 25 days TOTAL LOGIC 15,556,181.83 8,540,874.00 1,500,000.00 13,713.80 22,611,587.73 22,611,587.73 22,611,587.73 - LONESTAR Capital Recovery - Sewer 3,083,125.92 1.0006 150,000.00 - 2,849.77 3,235,975.69 3,235,975.69 3,235,975.69 N/A 24 days Capital Recovery - Water 3,893,979.03 1.0006 150,000.00 - 3,571.89 4,047,550.92 4,047,550.92 4,047,550.92 N/A 24 days Drainage Fund 865,328.90 1.0006 60,000.00 - 812.25 926,141.15 926,141.15 926,141.15 N/A 24 days Facilities Master Plan 26,183.12 1.0006 - - 23.32 26,206.44 26,206.44 26,206.44 N/A 24 days GO SR2011 Animal Shelter 8,677.81 1.0006 - - 7.73 8,685.54 8,685.54 8,685.54 N/A 24 days GO SR2011 Soccer Fields 163,477.70 1.0006 - - 145.59 163,623.29 163,623.29 163,623.29 N/A 24 days GO SR2011 Swimming Pool 1,857.22 1.0006 - - 1.65 1,858.87 1,858.87 1,858.87 N/A 24 days GO SR2012 Downtown Improvements 988,899.39 1.0006 - - 880.68 989,780.07 989,780.07 989,780.07 N/A 24 days SE Elevated Water Tank 2,439,727.27 1.0006 - - 2,172.74 2,441,900.01 2,441,900.01 2,441,900.01 N/A 24 days Sewer/CCMA Project 2,869,269.25 1.0006 - - 2,555.27 2,871,824.52 2,871,824.52 2,871,824.52 N/A 24 days W/S-Customer Deposits 298,850.57 1.0006 - - 266.15 299,116.72 299,116.72 299,116.72 N/A 24 days W/S-Equipment Repl/Cap.Imp 179,683.01 1.0006 - - 160.02 179,843.03 179,843.03 179,843.03 N/A 24 days Water&Sewer 3,601,597.25 1.0006 1,000,000.00 - 3,901.09 4,605,498.34 4,605,498.34 4,605,498.34 N/A 24 days W/S-Vehicle Replacement 259,568.44 1.0006 - - 231.16 259,799.60 259,799.60 259,799.60 N/A 24 days TOTAL LONESTAR 18,680,224.88 1,360,000.00 - 17,579.31 20,057,804.19 20,057,804.19 20,057,804.19 - TEXAS CLASS Tax I&S 2,082,988.38 1.1300 400,000.00 - 2,219.63 2,485,208.01 2,485,208.01 2,485,208.01 N/A 71 Days Justice Forfeiture 247,156.46 1.1300 - - 229.37 247,385.83 247,385.83 247,385.83 N/A 71 Days Park Fund 329,046.96 1.1300 - - 305.33 329,352.29 329,352.29 329,352.29 N/A 71 Days Economic Development Corporation 10,867,413.94 1.1300 325,000.00 - 10,317.87 11,202,731.81 11,202,731.81 11,202,731.81 N/A 71 Days Library Board 45,428.90 1.1300 - - 42.16 45,471.06 45,471.06 45,471.06 N/A 71 Days Tree Mitigation 311,152.62 1.1300 - - 288.75 311,441.37 311,441.37 311,441.37 N/A 71 Days Tax Note 2013 Fire Truck 4,992.79 1.1300 - - 4.63 4,997.42 4,997.42 4,997.42 N/A 71 Days Hotel Tax 1,140,315.02 1.1300 50,000.00 - 1,094.07 1,191,409.09 1,191,409.09 1,191,409.09 N/A 71 Days Special Events Fund 16,998.36 1.1300 - - 15.76 17,014.12 17,014.12 17,014.12 N/A 71 Days Tax Notes 2015 EMS Ambulances 89,669.21 1.1300 - - 83.18 89,752.39 89,752.39 89,752.39 N/A 71 Days Tax Notes 2015 Drainage Equipment 687,755.98 1.1300 - - 638.24 688,394.22 688,394.22 688,394.22 N/A 71 Days Tax Notes 2015 Water Equipment 284,908.83 1.1300 - - 264.38 285,173.21 285,173.21 285,173.21 N/A 71 Days Tax Notes 2015 General Fund Equipment 243,161.76 1.1300 - - 225.66 243,387.42 243,387.42 243,387.42 N/A 71 Days Tax Notes 2015A Fire Trucks & Equip 631.76 1.1300 - - 0.60 632.36 632.36 632.36 N/A 71 Days 2016 CO Roads 1,006,963.61 1.1300 - - 934.46 1,007,898.07 1,007,898.07 1,007,898.07 N/A 71 Days 2016 CO Building Repairs 173,938.89 1.1300 - - 161.42 174,100.31 174,100.31 174,100.31 N/A 71 Days 2016 CO Rec Center Windows 12.05 1.1300 - - - 12.05 12.05 12.05 N/A 71 Days 2016 GO Fire Station 3 4,027,854.24 1.1300 - - 3,737.86 4,031,592.10 4,031,592.10 4,031,592.10 N/A 71 Days TOTAL TEXAS CLASS 21,560,389.76 775,000.00 - 20,563.37 22,355,953.13 22,355,953.13 22,355,953.13 - C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING June 30th, 2017 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING June 30th, 2017 Beginning Interest Ending Par Maturity INVESTMENT MANAGED ACCOUNT Book Value Yield Purchases Withdrawals Earned Book Value Mkt Value Value Date Avg Mat. Capital One General Fund 1,366,137.76 2.0000 2,212.75 (5,571.37) 2,138.34 1,378,507.12 1,364,917.48 1,354,518.30 N/A 685 Days Capital One Capital Recovery Sewer 1,752,382.75 1.9500 5,566.17 (9,760.00) 2,645.70 1,761,431.02 1,750,834.62 1,737,242.32 N/A 676 Days TOTAL CAPITAL ONE 3,118,520.51 7,778.92 (15,331.37) 4,784.04 3,139,938.14 3,115,752.10 3,091,760.62 - C. D. CERTIFICATES OF DEPOSIT Term SB&T-Water&Sewer 1,089,599.19 1.0000 - - - 1,089,599.19 1,094,853.15 1,089,599.19 1/6/2018 365 Days Schertz Economic Development Corp.1,060,336.70 0.6000 - - - 1,060,336.70 1,060,946.76 1,060,336.70 11/23/2017 180 Days Schertz Economic Development Corp.1,012,004.38 1.0000 - - - 1,012,004.38 1,016,856.46 1,012,004.38 1/7/2018 365 Days TOTAL C.D.s 3,161,940.28 - - - 3,161,940.28 3,172,656.37 3,161,940.28 TOTAL PORTFOLIO 1.12 57,098.47$ 80,646,634.67$ 80,633,164.72$ 80,598,457.15$ 89 Days City Manager Executive Director Executive Director Finance Director This investment portfolio represents a liquid and diverse holding by the City of Schertz. This portfolio is in compliance with the City's Investment Policy and with the Public Funds Investment Act. The investment strategy is to hold the monthly operating funds in the bank while investing other funds. By looking at the purpose of the funds being invested, it can be determined that it is in best interest of the City to invest in securities over 1 year to maximize yield while still maintaining all collateral and other safety requirements. TOTAL OPERATIONS 11% TOTAL LOGIC 28% TOTAL LONESTAR 25% TOTAL TEXAS CLASS 28% TOTAL CAPITAL ONE 4% TOTAL C.D.s 4% City Portfolio By Investment Type Operations, $27,844,659.85 Projects, $14,782,972.11 Debt Service Fund, $2,485,208.01 Special Revenue Funds, $25,320,625.99 Designated Funds, $1,657,697.20 City Portfolio By Use 0.00 0.50 1.00 1.50 2.00 2.50 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 1 Month T-Bill 0.1800 0.3700 0.4300 0.4900 0.3900 0.7300 0.6800 0.8500 0.8200 3 Month T-Bill 0.3400 0.4800 0.5100 0.5200 0.5400 0.7500 0.8800 0.9600 1.0100 6 Month T-Bill 0.5100 0.6100 0.6100 0.6300 0.6800 0.8900 0.9900 1.0600 1.1200 Schertz Portfolio 0.8000 0.8000 1.0000 1.0000 0.9551 1.0267 1.0774 1.0935 1.1202 Schertz Bank&Trust 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 CD 365 Days 0.8000 0.8000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 CD 180 Days 0.6000 0.6000 0.6000 0.6000 0.6000 0.6000 0.6000 0.6000 0.6000 LOGIC 0.8112 0.8364 1.1333 1.1333 0.9716 1.1333 1.0739 1.0761 1.1333 LoneStar 0.6900 0.7087 1.0006 1.0006 0.8362 1.0006 0.9848 1.0006 1.0006 MBIA 0.8300 0.9000 1.1300 1.1300 0.9700 1.1300 1.0600 1.0900 1.1300 Capital One 1.6900 1.6900 2.0000 2.0000 1.6900 1.9460 1.9463 1.9432 1.7902 MONTHLY YIELDS C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:6/30/2017 General Fund Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Imm Government Fund #2642 49,518.30 49,518.30 49,518.30 430.00 0.87 Total Cash & Equivalents 49,518.30 49,518.30 49,518.30 430.00 0.87% Fixed Income Federal Natl Mtg Assn 1/27/2020 941.00 25,000.00 24,981.80 24,958.75 425.00 1.70 Federal Home LN Mtg Corp Reference 11/17/2017 140.00 50,000.00 54,930.00 50,747.00 2,562.00 5.05 Federal Home LN Mtg Corp Refrnce 8 6/13/2018 348.00 100,000.00 110,756.94 103,378.00 4,875.00 4.72 US Treasury Note 10/15/2017 107.00 40,000.00 39,913.84 39,976.80 350.00 0.88 US Treasury Note 10/31/2019 853.00 100,000.00 101,875.00 100,149.00 1,500.00 1.50 US Treasury Note 12/31/2019 914.00 50,000.00 50,208.98 50,194.50 812.00 1.62 US Treasury Note 8/15/2020 1142.00 100,000.00 103,394.53 103,155.00 2,625.00 2.54 US Treasury Note 12/15/2018 533.00 125,000.00 126,181.64 124,832.50 1,562.00 1.25 US Treasury Note 2/28/2019 608.00 50,000.00 49,996.09 50,012.00 687.00 1.37 US Treasury Note 4/30/2019 669.00 50,000.00 49,945.31 49,883.00 625.00 1.25 US Treasury Note 10/31/2019 853.00 100,000.00 99,601.56 99,612.00 1,250.00 1.25 US Treasury Note 11/30/2019 883.00 100,000.00 99,554.69 98,955.00 1,000.00 1.01 US Treasury Note 1/31/2020 945.00 100,000.00 101,312.50 99,739.00 1,375.00 1.38 US Treasury Note 7/31/2018 396.00 75,000.00 75,791.99 75,072.00 1,031.00 1.37 US Treasury Note 3/15/2020 989.00 75,000.00 75,225.59 75,246.00 1,218.00 1.62 US Treasury Note 5/31/2020 1066.00 75,000.00 74,991.21 74,901.00 1,125.00 1.50 US Treasury Note 5/15/2020 1050.00 75,000.00 74,956.05 74,924.25 1,125.00 1.50 Upper Trinity Regl Wtr Dist Te Rev 8/1/2017 32.00 15,000.00 15,371.10 15,032.70 600.00 3.99 Total Fixed Income 1,305,000.00 1,328,988.82 1,310,768.50 24,747.00 1.89% Total Assets 716.79 1,354,518.30 1,378,507.12 1,360,286.80 25,177.00 1.85% Capital Recovery Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Imm Government Fund #2642 27,242.32 27,242.32 27,242.32 236.00 0.87 Total Cash & Equivalents 27,242.32 27,242.32 27,242.32 236.00 0.87% Federal Natl Mtg Assn 10/26/2017 118.00 125,000.00 124,588.38 124,916.25 1,093.00 Federal Natl Mtg Assn 1/27/2020 941.00 50,000.00 49,963.60 49,917.50 850.00 1.70 Federal Home Mtg Corp Refrnce 8 6/13/2018 348.00 100,000.00 110,753.60 103,378.00 4,875.00 4.72 Federal Home LN Mtg Corp 3/27/2019 635.00 100,000.00 108,297.40 104,052.00 3,750.00 3.60 US Treasury Note 10/31/2019 853.00 100,000.00 100,065.85 100,149.00 1,500.00 1.50 US Treasury Note 12/31/2019 914.00 100,000.00 100,417.97 100,389.00 1,625.00 1.62 US Treasury Note 8/15/2020 1142.00 100,000.00 103,394.53 103,155.00 2,625.00 2.54 US Treasury Note 12/15/2018 533.00 100,000.00 100,945.31 99,866.00 1,250.00 1.25 US Treasury Note 2/28/2019 608.00 100,000.00 99,992.19 100,024.00 1,375.00 1.37 US Treasury Note 4/30/2019 669.00 100,000.00 99,890.63 99,766.00 1,250.00 1.25 US Treasury Note 10/31/2019 853.00 100,000.00 99,601.57 99,612.00 1,250.00 1.25 US Treasury Note 11/30/2019 883.00 200,000.00 199,226.56 197,910.00 2,000.00 1.01 US Treasury Note 1/31/2020 945.00 50,000.00 50,656.25 49,869.50 687.00 1.38 US Treasury Note 6/30/2018 365.00 75,000.00 75,916.99 75,072.00 1,031.00 1.37 US Treasury Note 3/15/2020 989.00 100,000.00 100,300.78 100,328.00 1,625.00 1.62 US Treasury Note 5/31/2020 1066.00 100,000.00 99,988.28 99,868.00 1,500.00 1.50 US Treasury Note 5/15/2020 1050.00 100,000.00 99,941.41 99,899.00 1,500.00 1.50 Upper Trinity Regl Wtr Dist Te Rev 8/1/2017 32.00 10,000.00 10,247.40 10,021.80 400.00 3.99 Total Fixed Income 1,710,000.00 1,734,188.70 1,718,193.05 30,186.00 1.76% Total Assets 725.82 1,737,242.32 1,761,431.02 1,745,435.37 30,422.00 1.74% 3,285.00