Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Q3-June-2016 Financials
3rd Quarter Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department AUGUST 30, 2016 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 17,335,590.00 727,576.73 14,546,469.24 15,748,652.19 - 1,586,937.81 90.85% Franchises 2,221,153.00 171,333.32 1,531,685.20 1,534,441.22 - 686,711.78 69.08% Permits 1,249,839.00 81,560.69 1,036,701.20 881,303.20 - 368,535.80 70.51% Licenses 84,160.00 5,305.00 61,735.00 42,949.50 - 41,210.50 51.03% Fees 2,470,622.00 183,673.07 1,955,306.95 1,859,582.43 - 611,039.57 75.27% Fines 31,000.00 2,789.05 22,779.72 18,694.88 - 12,305.12 60.31% Inter-Jurisdictional 783,847.00 84,614.62 551,677.22 607,764.59 - 176,082.41 77.54% Fund Transfers 1,921,266.00 134,483.05 1,269,378.72 1,210,347.41 - 710,918.59 63.00% Miscellaneous 462,000.00 53,569.51 320,292.11 406,770.05 (1.00) 55,230.95 88.05% TOTAL REVENUES 26,559,477 1,444,905.04 21,296,025.36 22,310,505.47 (1.00) 4,248,972.53 84.00% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 23,575 1,902.10 16,651.44 17,012.95 - 6,562.05 72.17% Supplies 2,600 103.88 514.87 173.42 - 2,426.58 6.67% City Support Services 68,176 49.00 29,069.24 67,095.29 78.00 1,002.71 98.53% Operations Support 500 (12.00) 219.93 184.58 - 315.42 36.92% Staff Support 26,500 39.03 10,256.18 12,046.93 - 14,453.07 45.46% TOTAL CITY COUNCIL 121,351 2,082.01 56,711.66 96,513.17 78.00 24,759.83 79.60% CITY MANAGER Personnel Services 815,887 58,285.12 599,636.20 600,901.08 - 214,985.92 73.65% Supplies 3,000 164.32 2,199.03 1,599.02 - 1,400.98 53.30% City Support Services 2,770 182.67 2,535.46 522.67 165.55 2,081.78 24.85% Staff Support 33,775 5,766 12,588 17,317 1,100.55 15,358 54.53% Operating Equipment - - 1,449.82 - - - 0.00% TOTAL CITY MANAGER 855,432 64,397.95 618,408.42 620,339.29 1,266.10 233,826.61 72.67% *************************************************** 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 1 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 MUNICIPAL COURT Personnel Services 278,579 21,553.34 191,713.37 198,654.57 - 79,924.43 71.31% Supplies 3,500 95.26 729.24 739.03 129.96 2,631.01 24.83% City Support Services 1,000 - - - - 1,000.00 0.00% Operations Support 4,500 - 1,928.00 941.00 - 3,559.00 20.91% Staff Support 7,710 737.74 1,818.95 3,711.63 864.07 3,134.30 59.35% Court Support 700 84.00 210.00 192.00 - 508.00 27.43% Professional Services 61,200 3,493.50 33,735.00 34,382.38 17,383.50 9,434.12 84.58% Maintenance Services 2,800 250.00 1,250.00 1,500.00 260.00 1,040.00 62.86% Operating Equipment 7,800 - 280.70 3,547.24 358.77 3,893.99 50.08% TOTAL MUNICIPAL COURT 367,789 26,213.84 231,665.26 243,667.85 18,996.30 105,124.85 71.42% CUSTOMER RELATIONS-311 Personnel Services 115,445 8,444.27 73,326.19 76,210.96 - 39,234.04 66.01% Supplies 200 - 164.70 74.93 - 125.07 37.47% Staff Support 975 - 453.48 204.32 - 770.68 20.96% Operating Equipment 500 - - - - 500.00 0.00% TOTAL CUSTOMER RELATIONS-311 117,120 8,444.27 73,944.37 76,490.21 - 40,629.79 65.31% PLANNING & ZONING Personnel Services 144,435 14,352.42 92,911.27 90,823.43 - 53,611.57 62.88% Supplies 2,476 201.96 1,289.85 1,478.52 28.05 969.43 60.85% City Support Services 296 295.20 - 295.20 - 0.80 99.73% Operations Support 750 105.95 31.48 163.13 - 586.87 21.75% Staff Support 23,120 1,226.62 7,319.53 3,018.49 475.00 19,626.51 15.11% Professional Services 300 - 66 39 - 261 13.00% Operating Equipment 230 - 486.00 - - 230.00 0.00% TOTAL PLANNING & ZONING 171,607 16,182.15 102,104.13 95,817.77 503.05 75,286.18 56.13% LEGAL SERVICES Operations Support 10,000 - 4,551.29 1,397.41 84.76 8,517.83 14.82% Professional Services 119,401 9,273.83 128,861.68 69,687.31 - 49,713.69 58.36% TOTAL LEGAL SERVICES 129,401 9,273.83 133,412.97 71,084.72 84.76 58,231.52 55.00% 2 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 GENERAL SERVICES Personnel Services 619,523 42,827.41 417,849.62 394,793.39 1,478.28 223,251.33 63.96% Supplies 102,544 10,032.85 36,097.84 64,703.14 6,769.78 31,071.08 69.70% Utility Services 188,015 13,066.52 60,215.29 112,304.29 - 75,710.71 59.73% Staff Support 11,749 1,442.01 6,174.81 6,806.07 875.77 4,067.16 65.38% Maintenance Services 52,060 1,919.63 26,534.65 19,587.72 644.39 31,827.89 38.86% Rental/Leasing 421 593.25 420.75 593.25 - (172.25) 140.91% Operating Equipment 3,600 - 0.49 - - 3,600 0.00% Capital Outlay 24,000 - - 23,087.90 - 912.10 96.20% TOTAL GENERAL SERVICES 1,001,912 69,881.67 547,293.45 621,875.76 9,768.22 370,268.02 63.04% CITY SECRETARY Personnel Services 169,988 13,414.16 118,855.10 122,658.64 - 47,329.36 72.16% Supplies 1,350 129.23 577.16 183.58 - 1,166.42 13.60% City Support Services 10,500 - 2,638.27 8,139.37 - 2,360.63 77.52% Operations Support 450 - - - - 450.00 0.00% Staff Support 8,725 - 2,885.49 2,609.93 - 6,115.07 29.91% TOTAL CITY SECRETARY 191,013 13,543.39 124,956.02 133,591.52 - 57,421.48 69.94% NON-DEPARTMENTAL City Support Services 346,293 35,144.46 295,922.48 286,559.26 2,200.00 57,533.74 83.39% Operations Support 134,500 30,110.54 78,465.42 106,002.71 - 28,497.29 78.81% Staff Support 9,900 80.00 80.00 10,080.00 - (180.00) 101.82% City Assistance 1,686,326 - 921,017.51 1,541,976.63 - 144,349.37 91.44% Professional Services 63,285 3,571.74 81,812.42 53,005.22 29,450.00 (19,170.22) 130.29% Fund Chrgs/Transfrs-Spec Events Fnd 125,200 - - - - 125,200.00 0.00% Operating Equipment - - 4,901.67 1,874.00 - (1,874.00) 0.00% TOTAL NON-DEPARTMENTAL 2,365,504 68,906.74 1,382,199.50 1,999,497.82 31,650.00 334,356.18 85.87% 3 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 PUBLIC AFFAIRS Personnel Services 272,396 20,313.13 171,064.14 188,020.23 - 84,375.77 69.02% Supplies 3,850 801.66 2,775.16 1,714.57 132.50 2,002.93 47.98% Operations Support 23,640 1,487.93 10,016.37 12,028.34 - 11,611.66 50.88% Staff Support 5,230 346.00 2,700.21 1,439.03 314.30 3,476.67 33.52% Professional Services 1,400 - 589.00 - - 1,400.00 0.00% Operating Equipment 3,600 2,214.09 1,921.82 2,214.09 - 1,385.91 61.50% TOTAL PUBLIC AFFAIRS 310,116 25,162.81 189,066.70 205,416.26 446.80 104,252.94 66.38% RECORDS MANAGEMENT Personnel Services 52,540 3,901.49 36,206.42 37,126.49 - 15,413.51 70.66% Supplies 400 - 187.82 66.37 - 333.63 16.59% Staff Support 1,250 - 1,150.74 44.44 - 1,205.56 3.56% Professional Services 10,000 914.50 6,668.00 6,881.50 - 3,118.50 68.82% Operating Equipment - - - - 83.77 (83.77) 0.00% TOTAL RECORDS MANAGEMENT 64,190 4,815.99 44,212.98 44,118.80 83.77 19,987.43 68.86% SCHERTZ MAGAZINE Personnel Services 140,795 10,274.41 97,740.54 80,934.45 - 59,860.55 57.48% Supplies 200 100.00 74.00 127.50 - 72.50 63.75% Staff Support 2,220 328.00 1,464.53 848.60 314.30 1,057.10 52.38% Professional Services 245,500 8,460.24 156,432.66 168,657.39 7,741.54 69,101.07 71.85% Fund Charges/Transfers 10,000 - - - - 10,000.00 0.00% Operating Equipment 1,500 - - - - 1,500.00 0.00% TOTAL SCHERTZ MAGAZINE 400,215 19,162.65 255,711.73 250,567.94 8,055.84 141,591.22 64.62% ENGINEERING Personnel Services 258,764 15,144.74 130,617.25 135,806.71 - 122,957.29 52.48% Supplies 1,246 - 567.02 566.45 116.93 562.62 54.85% City Support Services 591 - 262.80 590.40 - 0.60 99.90% Utility Services 700 - 241.30 246.44 - 453.56 35.21% Staff Support 8,503 - 456.35 2,436.59 - 6,066.41 28.66% Professional Services 35,800 - 3,410.00 2,338.00 - 33,462.00 6.53% Operating Equipment 400 - 161.49 - - 400.00 0.00% TOTAL ENGINEERING 306,004 15,144.74 135,716.21 141,984.59 116.93 163,902.48 46.44% 4 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 GIS Personnel Services 142,882 11,116.84 97,643.83 101,659.21 - 41,222.79 71.15% Supplies 2,200 - - - 1,454.13 745.87 66.10% Staff Support 4,390 - 2,810.40 4,515.32 - (125.32) 102.85% Rental/Leasing 3,805 521 - 1,910 - 1,894.85 0.00% Operating Equipment - - 3,080.81 - - - 0.00% TOTAL GIS 153,277 11,637.79 103,535.04 108,084.68 1,454.13 43,738.19 71.46% TOTAL GENERAL GOVERNMENT 6,554,931 354,849.83 3,998,938.44 4,709,050.38 72,503.90 1,773,376.72 72.95% PUBLIC SAFETY POLICE Personnel Services 5,504,509 436,499.04 3,526,215.95 4,001,134.10 - 1,503,374.90 72.69% Supplies 36,906 2,208.64 23,159.51 28,277.56 4,288.09 4,340.42 88.24% City Support Services 19,081 - 24,151.52 19,081.45 - (0.45) 100.00% Utility Services 109,634 6,620.46 54,082.73 43,255.27 - 66,379.03 39.45% Operations Support 2,950 393.97 2,007.75 2,413.77 536.23 81.82% Staff Support 114,631 3,747.42 69,990.79 48,603.97 34,589.27 31,438.11 72.57% City Assistance 13,179 250.00 3,094.04 6,676.88 1,806.87 4,695.25 64.37% Professional Services 37,288 5,710.50 29,427.85 34,732.91 77.00 2,478.09 93.35% Maintenance Services 58,581 6,080.00 24,432.81 44,470.59 175.00 13,935.41 76.21% Operating Equipment 116,090 23.72 55,199.68 110,461.18 7,142.21 (1,513.49) 101.30% Capital Outlay 199,327 - 71,794.09 204,959.75 200.00 (5,833.00) 102.93% TOTAL POLICE 6,212,176.37 461,533.75 3,883,556.72 4,544,067.43 48,278.44 1,619,830.50 73.92% FIRE RESCUE Personnel Services 3,285,930 259,096.60 2,033,201.97 2,298,934.80 - 986,995.20 69.96% Supplies 16,500 806.85 4,885.69 12,132.66 446.43 3,920.91 76.24% Utility Services 54,400 4,262.22 33,362.35 28,437.50 - 25,962.50 52.27% Operations Support 600 - 134.41 700.69 - (100.69) 116.78% Staff Support 116,600 10,980.82 45,692.07 78,323.30 3,441.48 34,835.22 70.12% City Assistance 16,200 931.85 1,118.52 2,219.42 1,671.01 12,309.57 24.02% Professional Services 26,000 13,368.00 160.00 13,643.00 - 12,357.00 52.47% Maintenance Services 60,000 9,493.34 22,429.92 38,520.24 - 21,479.76 64.20% Rental/Leasing 14,000 1,316.94 - 11,964.83 3,950.82 (1,915.65) 113.68% Operating Equipment 66,600 668.24 41,567.47 51,096.28 7,261.96 8,241.76 87.62% Capital Outlay 150,000 - 79,635.00 - - 150,000.00 0.00% TOTAL FIRE RESCUE 3,806,830 300,924.86 2,262,187.40 2,535,972.72 16,771.70 1,254,085.58 67.06% 5 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 INSPECTIONS Personnel Services 552,775 36,746.36 324,857.20 327,726.54 - 225,048.46 59.29% Supplies 3,585 229.37 1,791.00 1,842.20 385.80 1,357.00 62.15% Utility Services 6,104 398.55 2,488.51 2,172.43 - 3,931.57 35.59% Operations Support 2,200 385.00 1,338.94 679.00 445.00 1,076.00 51.09% Staff Support 18,600 2,562.55 5,285.34 7,382.44 622.42 10,595.14 43.04% Professional Services 107,600 17,512.50 6,132.50 84,054.50 13,713.00 9,832.50 90.86% Operating Equipment 2,496 - 199.99 - 931.00 1,565.00 37.30% Capital Outlay - - 20,435.82 - - - 0.00% TOTAL INSPECTIONS 693,360 57,834.33 362,529.30 423,857.11 16,097.22 253,405.67 63.45% MARSHAL'S OFFICE Personnel Services 618,483 47,638.83 405,437.76 432,862.68 - 185,620.32 69.99% Supplies 6,211 - 1,923.42 2,296.39 1,054.68 2,859.93 53.95% Utility Services 16,000 709.88 4,834.02 4,268.83 - 11,731.17 26.68% Operations Support 3,500 244.03 655.85 675.51 177.00 2,647.49 24.36% Staff Support 14,300 922.14 5,895.51 6,885.16 1,430.14 5,984.70 58.15% City Assistance 2,500 - 979.60 - 50.00 2,450.00 2.00% Maintenance Services 16,500 2,655.00 3,418.00 6,416.00 - 10,084.00 38.88% Operating Equipment 5,039 - 11,796.87 2,149.90 998.29 1,890.81 62.48% Capital Outlay 72,950 - - 71,719.85 100.00 1,130.15 98.45% TOTAL MARSHAL'S OFFICE 755,483 52,169.88 434,941.03 527,274.32 3,810.11 224,398.57 70.30% TOTAL PUBLIC SAFETY 11,467,849.37 872,462.82 6,943,214.45 8,031,171.58 84,957.47 3,351,720.32 70.77% 6 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 PUBLIC ENVIRONMENT STREETS Personnel Services 713,763 51,849.14 489,035.56 477,149.01 - 236,613.99 66.85% Supplies 7,100 3.04 4,959.03 3,873.18 88.23 3,138.59 55.79% Utility Services 149,604 15,811.83 70,237.85 100,624.22 327.41 48,652.37 67.48% Staff Support 10,030 956.78 8,659.11 7,502.89 299.26 2,227.85 77.79% Professional Services 107,000 3,783.84 24,650.00 32,950.99 - 74,049.01 30.80% Maintenance Services 98,700 9,120.43 50,457.16 59,741.37 12,105.75 26,852.88 72.79% Rental/Lease 200 - 175.00 - - 200.00 0.00% Operating Equipment 18,600 - 237.56 - - 18,600.00 0.00% Capital Outlay 81,400 72,806.52 25,985.49 72,806.52 18,074.12 (9,480.64) 111.65% TOTAL STREETS 1,186,397 154,331.58 674,396.76 754,648.18 30,894.77 400,854.05 66.21% TOTAL PUBLIC ENVIRONMENT 1,186,397 154,331.58 674,396.76 754,648.18 30,894.77 400,854.05 66.21% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 534,975 34,492.63 293,418.97 320,632.66 - 214,342.34 59.93% Supplies 43,405 2,180.16 28,972.07 30,967.82 2,244.88 10,192.30 76.52% City Support Services - 500.00 - 2,360.00 629.00 (2,989.00) 0.00% Utility Services 173,800 17,141.89 112,973.05 133,030.33 231.64 40,538.03 76.68% Operations Support 1,250 - 876.00 606.04 - 643.96 48.48% Staff Support 9,625 385.29 6,515.66 4,855.48 603.45 4,166.07 56.72% Professional Services 79,000 2,726.00 20,305.80 40,160.42 3,691.50 35,148.08 55.51% Maintenance Services 20,000 37.82 16,730.06 10,753.94 2,420.03 6,826.03 65.87% Rental/Leasing 39,600 3,019.16 27,988.33 27,262.49 9,057.48 3,280.03 91.72% Operating Equipment 2,500 331.55 1,648.92 1,935.32 675.80 (111.12) 104.44% Capital Outlay 38,000 27,840.60 54,134.82 27,840.60 2,439.00 7,720.40 79.68% TOTAL PARKS DEPARTMENT 942,155 88,655.10 563,563.68 600,405.10 21,992.78 319,757.12 66.06% SWIM POOL Supplies 28,700 2,343.93 11,254.40 8,728.30 5,347.62 14,624.08 49.05% Utility Services 29,000 1,547.82 9,786.35 8,276.87 - 20,723.13 28.54% Maintenance Services 197,878 2,630.61 4,275.44 3,387.47 640.30 193,850.23 2.04% Operating Equipment 2,500 212.21 - 212.21 1,864.81 422.98 83.08% TOTAL SWIM POOL 258,078 6,734.57 25,316.19 20,604.85 7,852.73 229,620.42 11.03% 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 EVENT FACILITIES Personnel Services 56,240 4,559.55 39,302.22 37,552.60 - 18,687.40 66.77% Supplies 15,500 650.00 9,085.17 7,600.92 418.60 7,480.48 51.74% Utility Services 51,850 4,065.47 30,213.56 32,624.17 - 19,225.83 62.92% Operations Support 10,258 - 14,549.00 4,840.47 - 5,417.53 47.19% Staff Support 2,500 - 1,156.16 840.00 - 1,660.00 33.60% Professional Services 500 - - - - 500.00 0.00% Operating Equipment 13,712 1,113.63 1,098.70 6,143.00 2,937.77 4,631.23 66.22% TOTAL EVENT FACILITIES 150,560 10,388.65 95,404.81 89,601.16 3,356.37 57,602.47 61.74% SENIOR CITIZEN CENTER Supplies - (9.64) 4,468.76 2,170.98 (73.99) (2,096.99) 0.00% Utility Services - - 216.78 - - - 0.00% Operations Support - - 591.92 - - - 0.00% City Assistence - - 7,911.48 19,136.93 - (19,136.93) 0.00% Professional Services - - 2,977.50 1,016.77 - (1,016.77) 0.00% Maintenance Services - - 336.04 138.50 - (138.50) 0.00% TOTAL SENIOR CITIZEN CENTER - (9.64) 16,502.48 22,463.18 (73.99) (22,389.19) 0.00% TOTAL PARKS & RECREATION 1,350,793 105,768.68 700,787.16 733,074.29 33,127.89 584,590.82 56.72% CULTURAL LIBRARY Personnel Services 692,689 51,112.83 434,266.97 478,745.17 - 213,943.83 69.11% Supplies 15,000 2,197.17 10,035.13 11,395.41 1,002.73 2,601.86 82.65% Utility Services 56,500 3,830.60 28,204.81 31,148.16 - 25,351.84 55.13% Operations Support 3,100 1,373.49 516.12 2,295.13 - 804.87 74.04% Staff Support 7,715 251.45 2,250.34 4,041.77 - 3,673.23 52.39% Professional Services 2,284 - 2,175.00 2,247.00 - 37.00 98.38% Maintenance Services - - - - 560.00 (560.00) 0.00% Operating Equipment 100,000 12,862.59 68,038.55 70,126.71 7,027.64 22,845.65 77.15% TOTAL LIBRARY 877,288 71,628.13 545,486.92 599,999.35 8,590.37 268,698.28 69.37% TOTAL CULTURAL 877,288 71,628.13 545,486.92 599,999.35 8,590.37 268,698.28 69.37% 8 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 HEALTH ANIMAL SERVICES Personnel Services 310,532 24,366.74 197,471.77 210,381.74 1,311.64 98,838.62 68.17% Supplies 33,380 7,149.31 14,248.51 21,659.99 4,475.77 7,244.24 78.30% City Support Services 3,776 - - 88.35 - 3,687.65 2.34% Utility Services 39,000 2,066.96 22,375.59 20,086.84 - 18,913.16 51.50% Operations Support 1,000 - 516.39 158.50 - 841.50 15.85% Staff Support 10,750 2,222.47 2,447.70 7,173.56 112.69 3,463.75 67.78% City Assistance 14,550 1,392.29 7,526.61 8,707.78 - 5,842.22 59.85% Professional Services 26,500 2,121.20 13,899.80 14,349.00 (38.80) 12,189.80 54.00% Maintenance Services 54,280 450.00 6,429.80 7,867.09 11,075.03 35,337.88 34.90% Operating Equipment 10,000 - 409.48 1,799.34 - 8,200.66 17.99% Capital Outlay 94,422 31,330.00 - 53,918.15 24,730.00 15,773.85 83.29% TOTAL ANIMAL SERVICES 598,190 71,098.97 265,325.65 346,190.34 41,666.33 210,333.33 64.84% TOTAL HEALTH 598,190 71,098.97 265,325.65 346,190.34 41,666.33 210,333.33 64.84% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 462,042 35,263.41 291,343.35 299,715.55 - 162,326.45 64.87% Supplies 3,100 198.87 825.15 876.43 90.08 2,133.49 31.18% City Support Services 541,399 15,578.59 316,625.23 320,507.54 3,945.34 216,946.12 59.93% Utility Services 252,402 23,745.75 129,327.81 147,977.69 - 104,424.31 58.63% Operations Support - - 50.00 - - - 0.00% Staff Support 36,050 4,020.70 21,650.25 35,967.56 261.99 (179.55) 100.50% Maintenance Services 15,600 1,163.60 7,397.26 13,724.53 79.00 1,796.47 88.48% Rental/Leasing 38,047 6,340.98 - 31,704.90 - 6,342.10 Operating Equipment 235,866 15,473.34 147,314.98 113,042.52 21,027.71 101,795.77 56.84% TOTAL INFORMATION TECHNOLOGY 1,584,506 101,785.24 914,534.03 963,516.72 25,404.12 595,585.16 62.41% 9 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 HUMAN RESOURCES Personnel Services 291,703 22,649.24 194,260.93 189,413.26 - 102,289.74 64.93% Supplies 1,000 101.84 485.41 907.62 - 92.38 90.76% Human Services 64,744 4,001.15 43,023.61 35,013.69 612.46 29,117.85 55.03% Operations Support 10,000 522.44 3,150.17 7,046.40 105.95 2,847.65 71.52% Staff Support 18,356 1,678.62 12,981.75 14,540.78 - 3,815.22 79.22% City Assistance 11,000 1,239.00 6,270.75 10,144.00 - 856.00 92.22% Professional Services 9,600 744.75 5,957.50 6,752.75 - 2,847.25 70.34% Operating Equipment 1,800 - - 1,362.96 - 437.04 75.72% TOTAL HUMAN RESOURCES 408,203 30,937.04 266,130.12 265,181.46 718.41 142,303.13 65.14% FINANCE Personnel Services 580,537 40,048.96 346,140.46 362,897.04 - 217,639.96 62.51% Supplies 3,500 545.00 4,305.44 3,378.88 - 121.12 96.54% Operations Support 3,000 606.04 3,887.60 2,582.69 - 417.31 86.09% Staff Support 11,085 1,627.74 2,985.38 8,361.52 514.00 2,209.48 80.07% Professional Sevices 17,000 - - 505.00 - 16,495.00 2.97% Operating Equipment - - 895.86 - - - 0.00% TOTAL FINANCE 615,122 42,827.74 358,214.74 377,725.13 514.00 236,882.87 61.49% PURCHASING & ASSET MGT Personnel Services 141,242 8,554.76 144,658.73 97,624.79 - 43,617.21 69.12% Supplies 1,100 183.99 448.20 512.19 59.45 528.36 51.97% City Support Services - - 788.40 - - - 0.00% Utility Services 500 40.05 256.68 163.64 - 336.36 32.73% Operations Support 100 (6.80) 95.97 22.30 6.80 70.90 29.10% Staff Support 6,600 955.16 3,028.71 4,703.11 160.00 1,736.89 73.68% City Assistance 2,500 66.00 - 2,190.46 194.00 115.54 95.38% Operating Equipment - - 1,245.00 - - - 0.00% TOTAL PURCHASING & ASSET MGT 152,042 9,793.16 150,521.69 105,216.49 420.25 46,405.26 69.48% 10 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 FLEET SERVICE Personnel Services 327,626 24,832.27 179,414.20 203,648.67 - 123,977.33 62.16% Supplies 125,895 12,483.80 129,538.86 106,716.96 13,654.24 5,523.80 95.61% City Support Services 3,500 - 2,232.24 2,244.72 - 1,255.28 64.13% Utility Services 6,454 460.31 2,504.24 2,983.57 - 3,470.43 46.23% Operations Support 300 - 75.03 - - 300.00 0.00% Staff Support 5,914 189.84 4,517.51 4,488.76 457.95 967.29 83.64% Maintenance Services 146,285 20,608.99 65,345.36 133,161.91 2,639.13 10,483.96 92.83% Rental/Lease 200 - - - - 200.00 0.00% Operating Equipment 8,200 - 7,037.00 6,570.02 - 1,629.98 80.12% Capital Outlay 93,372 - 40,496.92 89,832.47 - 3,539.53 96.21% TOTAL FLEET SERVICE 717,746 58,575.21 431,161.36 549,647.08 16,751.32 151,347.60 78.91% BUILDING MAINTENANCE Personnel Services 148,103 11,645.08 78,681.32 106,125.45 - 41,977.55 71.66% Supplies 1,043 1,038.29 616.84 1,563.70 582.13 (1,102.83) 205.74% Utility Services 2,350 272.21 1,521.45 1,923.29 - 426.71 81.84% Staff Support 3,420 839.97 1,559.75 2,518.70 504.57 396.73 88.40% Professional Services 43,785 - 675.00 43,784.99 - 0.01 100.00% Maintenance Services 180,342 25,368.30 78,270.30 107,474.67 16,219.21 56,648.12 68.59% Rental/Leasing 1,400 - 296.75 1,263.27 - 136.73 90.23% Operating Equipment - - 1,438.43 - - - 0.00% Capital Outlay - - - - 8,415.00 (8,415.00) 0.00% TOTAL BUILDING MAINTENANCE 380,443 39,163.85 163,059.84 264,654.07 25,720.91 90,068.02 76.33% TOTAL INTERNAL SERVICE 3,858,062 283,082.24 2,283,621.78 2,525,940.95 69,529.01 1,262,592.04 67.27% 11 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 MISC & PROJECTS CITY ASSISTANCE City's Assistance to Agencies 240,847 16,925.41 36,678.00 150,189.73 49.95 90,607.32 62.38% TOTAL CITY ASSISTANCE 240,847 16,925.41 36,678.00 150,189.73 49.95 90,607.32 62.38% COURT - RESTRICTED FUNDS Operating Equipment 36,660 - - 3,924.25 1,840.00 30,895.75 15.72% TOTAL CITY ASSISTANCE 36,660 - - 3,924.25 1,840.00 30,895.75 15.72% TOTAL MISC & PROJECTS 277,507 16,925.41 36,678.00 154,113.98 1,889.95 121,503.07 56.22% TOTAL EXPENDITURES 26,171,017.37 1,930,147.66 15,448,449.16 17,854,189.05 343,159.69 7,973,668.63 69.53% REVENUE OVER(UNDER) EXPEND.388,460 4,456,316.42 12 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 10,162,766 27,116.20 9,304,863.43 10,359,461.35 - (196,695.35) 101.94% 000-411200 Advalorem Tax - Delinquent 45,000 1,748.99 33,459.21 17,158.59 - 27,841.41 38.13% 000-411300 Advalorem Tax - P&I 45,000 4,199.91 34,706.94 41,325.31 - 3,674.69 91.83% 000-411500 Sales Tax Revenue-Gen Fund 7,036,724 694,511.63 5,141,377.75 5,298,367.43 - 1,738,356.57 75.30% 000-411600 Bingo Tax 100 - - 0.62 - 99.38 0.62% 000-411700 Mixed Beverage Tax 46,000.00 - 32,061.91 32,338.89 - 13,661.11 70.30% TOTAL Taxes 17,335,590 727,576.73 14,546,469.24 15,748,652.19 - 1,586,937.81 90.85% Franchises 000-421200 Center Point/Entex Energy 109,857 5,771.91 63,638.82 56,847.32 - 53,009.68 51.75% 000-421220 City Public Service 815,953 61,374.13 533,441.53 537,701.43 - 278,251.57 65.90% 000-421240 Guadalupe Valley Elec Co-op 453,465 32,994.87 329,680.23 310,336.16 - 143,128.84 68.44% 000-421250 New Braunfels Utilities 56,736 5,237.96 29,366.36 46,366.87 - 10,369.13 81.72% 000-421300 Time Warner-State Franchise 275,193 24,118.84 203,708.37 200,365.30 - 74,827.70 72.81% 000-421460 AT&T Franchise Fee 251,861 24,063.67 223,664.76 201,739.76 - 50,121.24 80.10% 000-421480 Other Telecom Franchise 125,000 1,582.46 50,630.39 78,965.54 - 46,034.46 63.17% 000-421500 Solid Waste Franchise Fee 133,088 16,189.48 97,554.74 102,118.84 - 30,969.16 76.73% TOTAL Franchises 2,221,153 171,333.32 1,531,685.20 1,534,441.22 - 686,711.78 69.08% Permits 000-431100 Home Occupation Permit 420 35.00 385.00 490.00 - (70.00) 116.67% 000-431205 Building Permit - Residential 567,624 33,723.00 438,898.00 319,421.00 - 248,203.00 56.27% 000-431210 Building Permit - Commercial 182,270 - 100,950.00 129,230.00 - 53,040.00 70.90% 000-431215 Building Permit - General 150,000 22,266.00 179,144.00 137,539.00 - 12,461.00 91.69% 000-431300 Mobile Home Permit 525 - 350.00 200.00 - 325.00 38.10% 000-431400 Signs Permit 3,500 907.00 6,707.00 4,752.00 - (1,252.00) 135.77% 000-431500 Food Establishmnt Permit 56,000 200.00 56,580.00 59,690.00 - (3,690.00) 106.59% 000-431600 Garage Sale Permit 8,000 1,076.00 7,772.00 8,180.00 - (180.00) 102.25% 000-431700 Plumbing Permit 105,000 9,919.25 93,061.40 83,517.25 - 21,482.75 79.54% 000-431750 Electrical Permit 51,000 4,240.00 46,460.00 43,360.00 - 7,640.00 85.02% 000-431800 Mechanical Permit 53,000 5,260.00 48,560.00 40,300.00 - 12,700.00 76.04% 000-431900 Solicitor/Peddler Permit 1,200 180.00 1,410.00 1,130.00 - 70.00 94.17% 000-431950 Animal/Pet Permit 1,800 - 1,180.00 790.00 - 1,010.00 43.89% 000-432000 Cert. of Occupancy Prmt 6,000 600.00 6,000.00 5,350.00 - 650.00 89.17% ************************************************ 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 13 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 000-432100 Security Alarm Permit 40,000 1,840.00 29,571.00 27,408.00 - 12,592.00 68.52% 000-432300 Grading/Clearing Permit 3,500 356.44 3,834.80 5,604.95 - (2,104.95) 160.14% 000-435000 Fire Permit 20,000 958.00 15,838.00 14,341.00 - 5,659.00 71.71% TOTAL Permits 1,249,839 81,560.69 1,036,701.20 881,303.20 - 368,535.80 70.51% Licenses 000-441000 Alcohol Beverage License 7,000 510.00 4,415.00 6,112.50 - 887.50 87.32% 000-441300 Mobile Home License 160 - 160.00 160.00 - - 100.00% 000-442000 Contractors License 74,000 4,500.00 54,555.00 34,310.00 - 39,690.00 46.36% 000-444000 Pet License 3,000 295.00 2,605.00 2,367.00 - 633.00 78.90% TOTAL Licenses 84,160 5,305.00 61,735.00 42,949.50 - 41,210.50 51.03% Fees 000-451000 Municipal Court Fines 1,027,516 74,201.37 818,648.70 770,056.45 - 257,459.55 74.94% 000-451100 Arrest Fee 34,750 3,095.56 34,193.10 28,384.07 - 6,365.93 81.68% 000-451110 Expunction Fee 60 30.00 60.00 90.00 - (30.00) 150.00% 000-451200 Warrant Fees 150,000 8,143.13 93,515.26 98,409.17 - 51,590.83 65.61% 000-451210 Court - Claims & Judgements - (2,976.40) 219.00 (3,204.40) - 3,204.40 0.00% 000-451340 Judicial Fee - City 5,250 407.58 4,564.81 3,852.86 - 1,397.14 73.39% 000-451400 Traffic Fine Costs TTL 20,000 1,532.15 17,403.61 13,663.28 - 6,336.72 68.32% 000-451510 Juvenile Case Mgmt Fee 45,650 3,396.33 38,055.49 32,096.99 - 13,553.01 70.31% 000-451520 Truancy Fee 7,225 642.89 6,658.17 5,662.60 1,562.40 78.38% 000-451600 Technology Fund Fee 36,660 2,769.60 29,137.19 25,209.38 - 11,450.62 68.77% 000-451700 Security Fee 28,250 2,077.20 23,016.91 19,583.52 - 8,666.48 69.32% 000-451800 Time Payment Fee - City 5,690 360.67 4,567.87 4,287.53 - 1,402.47 75.35% 000-451850 State Fines 10% Service Fee 64,500 - 46,358.96 37,478.01 - 27,021.99 58.11% 000-451900 DPS Payment - Local 7,500 624.00 7,048.99 7,247.17 - 252.83 96.63% 000-452000 Child Safety Fee 30,000 804.38 21,607.92 13,031.15 - 16,968.85 43.44% 000-452050 Indigent Defense Fee 1,741 - - - - 1,741.00 0.00% 000-452100 Platting Fees 57,000 5,000.00 42,500.00 48,000.00 - 9,000.00 84.21% 000-452200 Site Plan Fee 25,000 2,000.00 14,000.00 29,000.00 - (4,000.00) 116.00% 000-452300 Plan Check Fee 455,979 28,694.00 359,320.50 293,282.50 - 162,696.50 64.32% 000-452310 Miscellaneous Review Fee 600 - 300.00 300.00 - 300.00 50.00% 000-452320 Tree Mitigation Admin Fee 10,000 637.50 33,547.50 7,282.50 - 2,717.50 72.83% 000-452400 BOA/Zoning Fees 5,000 500.00 4,000.00 2,000.00 - 3,000.00 40.00% 000-452500 Food Handler Class - - 8,840.00 - - - 0.00% 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 000-452520 Fire Training Classes 500 - - - - 500.00 0.00% 000-452600 Specific Use/Zone Chng Fee 18,000 2,000.00 - 9,300.00 - 8,700.00 51.67% 000-452710 Zoning Ltr & Dev Rights 2,400 - 1,350.00 1,350.00 - 1,050.00 56.25% 000-453100 Reinspection Fees 35,000 7,225.00 27,636.00 76,480.00 - (41,480.00) 218.51% 000-453110 Swim Pool Inspection Fee 2,000 1,540.00 2,530.00 1,760.00 - 240.00 88.00% 000-453200 Lot Abatement 10,000 - 1,210.00 1,000.17 - 8,999.83 10.00% 000-453211 Admin Fee-Inspections 6,600 1,200.00 5,200.00 9,000.00 - (2,400.00) 136.36% 000-453310 Misc Inspection Fee - - 150.00 100.00 - (100.00) 0.00% 000-453710 Foster Care 1,000 150.00 900.00 850.00 - 150.00 85.00% 000-454200 Pool Gate Admission Fee 24,750 7,254.05 8,296.75 7,254.05 - 17,495.95 29.31% 000-454300 Seasonal Pool Pass Fee 4,900 4,770.00 5,266.10 4,770.00 - 130.00 97.35% 000-456110 Senior Center Memberships - - 10,947.60 2,988.00 - (2,988.00) 0.00% 000-456120 Senior Center Meal Fee - - 5,905.61 864.00 - (864.00) 0.00% 000-456500 Haz Mat Fees 12,000 1,080.00 - 2,941.00 - 9,059.00 24.51% 000-456600 Fire Re-inspection Fee 1,000 150.00 850.00 850.00 - 150.00 85.00% 000-458110 Sale of Merchandise-GovDeal 5,000 558.32 4,437.97 26,627.98 - (21,627.98) 532.56% 000-458300 Sale of Property/Auction 4,000 - 1,968.75 2,194.00 - 1,806.00 54.85% 000-458400 Civic Center Rental Fees 159,000 14,926.25 136,763.50 134,973.25 - 24,026.75 84.89% 000-458401 Capital Recovery Fee-Civic Cntr 6,500 1,525.00 9,205.00 8,900.00 - (2,400.00) 136.92% 000-458450 North Center Rental Fees 18,500 1,300.00 16,415.75 16,200.00 - 2,300.00 87.57% 000-458460 Senior Center Rental 8,400 1,950.00 19,852.00 16,162.00 - (7,762.00) 192.40% 000-458500 Community Center Rental Fees 24,500 1,829.50 22,687.53 27,415.00 - (2,915.00) 111.90% 000-458550 Pavilion Rental Fees 17,370 1,357.50 12,545.00 14,753.50 - 2,616.50 84.94% 000-458560 Chamber of Comm rent 7,800 - 5,850.00 6,050.00 - 1,750.00 77.56% 000-458570 Non-Resident SYSA League 3,000 - - - - 3,000.00 0.00% 000-458650 NonResident User Fee-BVYA 13,825 - 2,740.00 10,120.00 - 3,705.00 73.20% 000-458660 BVYA Utility Reimbursement 8,340 - 5,100.50 10,092.81 - (1,752.81) 121.02% 000-458670 SYSA Utility Reimbursement 1,968 - - - - 1,968.00 0.00% 000-458675 Lions Futbol Utility Reimbursement 14,148 - 12,180.00 3,516.00 - 10,632.00 24.85% 000-458700 Vehicle Impoundment 9,000 - 7,330.00 5,250.00 - 3,750.00 58.33% 000-459200 NSF Check Fee 250 25.00 50.00 50.00 - 200.00 20.00% 000-459300 Notary Fee 250 12.00 132.00 144.00 - 106.00 57.60% 000-459400 Maps, Copies, UDC, & Misc F 250 20.00 75.00 60.00 - 190.00 24.00% 000-459600 Animal Adoption Fee 14,000 1,067.89 8,208.01 9,317.89 - 4,682.11 66.56% 000-459700 Pet Impoundment Fee 12,000 1,275.00 7,687.00 8,489.30 - 3,510.70 70.74% 000-459800 Police Reports Fee 6,000 517.60 4,272.90 4,046.70 - 1,953.30 67.45% TOTAL Fees 2,470,622 183,673.07 1,955,306.95 1,859,582.43 - 611,039.57 75.27% 15 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 Fines 000-463000 Library Fines 31,000 2,789.05 22,779.72 18,694.88 - 12,305.12 60.31% TOTAL Fines 31,000 2,789.05 22,779.72 18,694.88 - 12,305.12 60.31% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,072 - 7,025.92 10,258.29 - 10,813.71 48.68% 000-473200 City of Seguin - Fire Contract 29,231 6,187.18 21,923.10 23,238.48 - 5,992.52 79.50% 000-473300 Guad Co - Library 212,000 17,662.83 158,965.47 176,628.30 - 35,371.70 83.32% 000-473400 Randolph AFB-Animal Cntrl 1,500 - 500.00 1,200.00 - 300.00 80.00% 000-474200 Library Services - Cibolo 30,000 - 30,000.00 35,000.00 - (5,000.00) 116.67% 000-474210 Library Services-Selma 30,544 - 30,544.00 31,540.00 - (996.00) 103.26% 000-474400 Dispatch Service - Cibolo 160,000 40,000.00 80,000.00 120,026.00 - 39,974.00 75.02% 000-474600 School Crossing Guard-Bexar 40,000 3,405.84 28,586.51 27,016.43 - 12,983.57 67.54% 000-474610 School Cross Guard-Guadalupe 38,000 3,292.79 27,588.56 28,791.11 - 9,208.89 75.77% 000-474620 School Crossing Guard-Comal 1,500 1,565.98 1,543.66 1,565.98 - (65.98) 104.40% 000-474700 School Officer Funding 170,000 - 165,000.00 127,500.00 - 42,500.00 75.00% 000-474750 Crime Victim Liaison Agreement 50,000 12,500.00 - 25,000.00 - 25,000.00 50.00% TOTAL Inter-Jurisdictional 783,847 84,614.62 551,677.22 607,764.59 - 176,082.41 77.54% Fund Transfers 000-480000 Indirect Costs - EMS 150,308 12,525.63 102,065.22 112,730.67 - 37,577.33 75.00% 000-480100 Indirect Costs - Hotel/Motel 66,405 - 49,803.75 - - 66,405.00 0.00% 000-482200 Transfer-Vehicle Replcemt 241,088 - - - - 241,088.00 0.00% 000-485000 Interfund Charge-Drainage 54,150 4,512.50 42,847.47 40,612.50 - 13,537.50 75.00% 000-486000 Interfund Chrges-Admin W&S 1,152,350 96,029.17 864,262.53 864,262.49 - 288,087.51 75.00% 000-487000 Interfund Charges-Fleet 206,965 17,247.08 135,177.75 155,223.76 - 51,741.24 75.00% 000-488000 Interfund Charges-4B 50,000 4,168.67 75,222.00 37,517.99 - 12,482.01 75.04% TOTAL Fund Transfers 1,921,266 134,483.05 1,269,378.72 1,210,347.41 - 710,918.59 63.00% 16 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 5 - 2 0 1 6 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 Miscellaneous 000-491000 Interest Earned 600 35.63 442.01 599.08 - 0.92 99.85% 000-491200 Investment Income 26,000 6,658.20 20,534.51 55,586.89 - (29,586.89) 213.80% 000-491800 Gain/Loss - - (4,400.01) (28,397.02) - 28,397.02 0.00% 000-491900 Unrealized Gain/Loss (15,000) 5,957.50 497.85 17,825.54 - (32,825.54) 0.00% 000-493120 Donations-Public Library 2,500 214.25 1,634.75 2,182.73 - 317.27 87.31% 000-493400 Donation - Animal Control 1,000 - 412.50 140.00 - 860.00 14.00% 000-493401 Donations-A/C Microchip 1,000 165.00 905.00 1,400.00 - (400.00) 140.00% 000-493402 Donations-Spay&Neuter 10,000 1,108.50 7,781.50 10,278.50 (278.50) 102.79% 000-493403 Donations-Animal Adoption Trailer - - 9,145.52 2,222.00 - (2,222.00) 0.00% 000-493404 Donations-TNR Program 600.00 - (600.00) 0.00% 000-493460 Donations-Parks - - 500.00 - - 0.00% 000-493465 Donations-Senior Center - 322.57 4,518.88 8,150.02 - (8,150.02) 0.00% 000-493502 Donations-PD - 1,205.04 500.00 1,799.68 - (1,799.68) 0.00% 000-493618 Donations-Veteran's Memorial - - 2,250.00 5,650.67 - (5,650.67) 0.00% 000-494481 LawEnforcemtOfficersStnd&Ed 3,900 3,878.26 3,850.98 - 49.02 98.74% 000-494482 Grants - Police, Fire, Gen Fund 15,000 - - 4,902.95 - 10,097.05 32.69% 000-495100 Mobile Stage Rental Fees - - - 1,550.00 - (1,550.00) 0.00% 000-497000 Misc Income-Gen Fund 36,000 5,489.49 (15,219.78) 26,892.02 (1.00) 9,108.98 74.70% 000-497005 Schertz Magazine Advertising 240,000 16,325.00 201,465.00 141,525.00 - 98,475.00 58.97% 000-497100 Misc Income-Police 7,000 4,336.62 5,499.40 14,509.12 - (7,509.12) 207.27% 000-497200 Misc Income-Library 5,000 296.20 4,436.70 3,503.76 - 1,496.24 70.08% 000-497210 Misc Income-Library Copier 18,000 1,481.75 14,455.17 14,894.00 - 3,106.00 82.74% 000-497300 Misc Income-Animal Control - 40.00 10.00 360.00 - (360.00) 0.00% 000-497400 Misc Income-Streets Dept.20,000 6,636.15 14,732.85 29,991.38 - (9,991.38) 149.96% 000-497500 Misc Income-TML Insurance 20,000 - - 873.33 - 19,126.67 4.37% 000-497550 Misc Income-TML Reimbursemt 20,000 - 3,503.99 11,610.09 - 8,389.91 58.05% 000-497600 Misc Income-Vending Mach.2,500 155.13 1,723.67 1,565.15 - 934.85 62.61% 000-498000 Reimbursmnt-Gen Fund 32,000 48.00 17,085.27 18,437.97 - 13,562.03 57.62% 000-498100 Reimbursmnt Fire - Training 1,000 - - 4,360.00 - (3,360.00) 436.00% 000-498105 Reimburmnt Police - DEA 6,000 - 6,999.07 4,212.11 - 1,787.89 70.20% 000-498107 Reimburmnt Police - Event 7,000 - 7,000.00 3,500.00 - 3,500.00 50.00% 000-498110 Reimbursmnt Fire - Emg. Acti-O 2,500 3,094.48 - 42,194.10 - (39,694.10) 1687.76% TOTAL Miscellaneous 462,000 53,569.51 320,292.11 406,770.05 (1.00) 55,230.95 88.05% TOTAL REVENUES 26,559,477 1,444,905.04 21,296,025.36 22,310,505.47 (1.00) 4,248,972.53 84.00% 17 Cash in Bank Claim on Operating Cash Pool-Checking 351,274.62$ Cash in Investments LOGIC Investment-General Fund 9,722,834.00 LOGIC Investment-Equip Replacement 73,949.40 LOGIC Investment-Veh Replacement 477,656.91 LOGIC Investment-Air Condi Replacment 221,434.32 CAPITAL ONE Investment-General Fund 1,369,916.88 Total Cash in Bank & Investments 12,363,647.97$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2016 GENERAL FUND 18 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2015-16 360,300 303,202 4,754,503 3,709,486 888,174 211,253 50,559 54,867 27,116 5,863 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 2011-12 1,540,041 228,924 2,439,123 1,871,054 635,719 64,190 27,878 29,919 18,039 26,509 6,127 6,915 ADVALOREM TAX 19 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2015-16 479,069 744,668 529,686 493,136 783,019 530,498 531,707 615,841 568,508 523,141 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 2011-12 428,994 463,636 339,192 399,061 461,400 365,083 347,395 535,930 398,080 408,851 575,414 440,250 -3.3% 16.6% 4.9% 17.0% -1.6% 17.6% 7.6% -14.9% 22.0% 5.4% $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 Sales Tax -General Fund 20 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2015-16 237,314 183,530 173,336 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 2011-12 96,392 76,414 77,398 103,230 $- $50,000 $100,000 $150,000 $200,000 $250,000 CITY PUBLIC SERVICE 21 106-SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 84,200.00 - - - - 84,200.00 0.00% Miscellaneous 47,600.00 8.75 34,346.84 33,138.81 - 14,461.19 69.62% TOTAL REVENUES 131,800.00 8.75 34,346.84 33,138.81 - 98,661.19 14.69% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 10,760.00 - - - - 10,760.00 0.00% TOTAL GENERAL GOVERNMENT 10,760.00 - - - - 10,760.00 0.00% CULTURAL Festival of Angels 15,000.00 - 11,556.53 11,871.69 1,060.00 2,068.31 86.21% Employee Appreciation Event 13,000.00 - 11,155.79 4,272.45 8,727.55 32.87% National Night Out 290.00 - - - - 290.00 0.00% Wilenchik Walk for Life 25,000.00 - 13,925.54 3,732.92 - 21,267.08 14.93% Schertz Sweetheart 35,000.00 1,275.99 14,756.01 15,182.10 179.87 19,638.03 43.89% Hal Baldwin Scholarship 18,750.00 5,000.00 12,309.68 14,247.75 - 4,502.25 75.99% Other Events 14,000.00 - 5,283.10 5,560.47 512.66 7,926.87 43.38% TOTAL CULTURAL 121,040.00 6,275.99 68,986.65 54,867.38 1,752.53 64,420.09 46.78% TOTAL EXPENDITURES 131,800.00 6,275.99 68,986.65 54,867.38 1,752.53 75,180.09 42.96% REVENUE OVER(UNDER) EXPEND - 475.33 (2,959.06) (21,728.57) (2,726.66) 7,541.08 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 5 - 2 0 1 6 ************************************************** 22 106-SPECIAL EVENTS FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fund Transfers 000-481000 Transfer from Reserves 10,000 - - - - 10,000.00 0.00% 000-481314 Transfer from Hotel/Motel - - - - - - 0.00% 000-486100 Transfer In 9,000 - - - - 9,000.00 0.00% 000-486101 Transfer In - General Fund 65,200 - - - - 65,200.00 0.00% TOTAL Fund Transfers 84,200 - - - - 84,200.00 0.00% Miscellaneous 000-491200 Investment Income - 8.75 14.30 55.81 - (55.81) 0.00% 000-492200 Wilenchik Walk for Life 25,000 - 13,925.54 14,513.00 - 10,487.00 58.05% 000-493256 Donations - Police Events 3,000 - 500.00 - - 3,000.00 0.00% 000-493455 Proceeds-Festival of Angels - - 255.00 720.00 - (720.00) 0.00% 000-493460 Schertz Sweetheart 850 - 850.00 1,240.00 - (390.00) 145.88% 000-493621 Hal Baldwin Scholarship 18,750 - 18,802.00 16,360.00 - 2,390.00 87.25% 000-497000 Misc Income - - - 250.00 - (250.00) 0.00% TOTAL Miscellaneous 47,600 8.75 34,346.84 33,138.81 - 14,461.19 69.62% TOTAL REVENUES 131,800 8.75 34,346.84 33,138.81 - 98,661.19 25.14% C I T Y O F S C H E R T Z ************************************************** 2 0 1 5 - 2 0 1 6 ************************************************** REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 23 Cash in Bank Claim on Operating Cash Pool-Checking 29,011.26$ Cash in Investments Texas Class- Special Events 16,836.33 Total Cash in Bank & Investments 45,847.59$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2016 SPECIAL EVENTS FUND 24 110-PEG FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 107,000.00 12,915.40 77,541.62 76,315.81 - 30,684.19 71.32% Fund Transfers 145,500.00 - - - - 145,500.00 0.00% Miscellaneous - - 2.00 - - - 0.00% TOTAL REVENUES 252,500.00 12,915.40 77,543.62 76,315.81 - 176,184.19 30.22% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental - - 68,280.77 864.99 2,762.70 (3,627.69) 0.00% TOTAL GENERAL GOVERNMENT - - 68,280.77 864.99 2,762.70 (3,627.69) 0.00% MISC & PROJECTS Projects 252,500.00 - 1,835.38 30,492.46 - 222,007.54 12.08% TOTAL MISC & PROJECTS 252,500.00 - 1,835.38 30,492.46 - 222,007.54 12.08% TOTAL EXPENDITURES 252,500.00 - 70,116.15 31,357.45 2,762.70 218,379.85 13.51% REVENUE OVER(UNDER) EXPEND - 12,915.40 7,427.47 44,958.36 (2,762.70) (42,195.66) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2015 ************************************************** 2 0 1 4 - 2 0 1 5 ************************************************** 25 110-PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421350 Time Warner - PEG Fee 52,000 12,915.40 38,295.18 50,406.06 - 1,593.94 96.93% 000-421465 AT&T PEG Fee 55,000 - 39,246.44 25,909.75 29,090.25 47.11% TOTAL Franchises 107,000 12,915.40 77,541.62 76,315.81 - 30,684.19 71.32% Fund Transfers 000-481000 Transfer In - Reserves 145,500 - - - - 145,500.00 0.00% TOTAL Fund Transfers 145,500 - - - - 145,500.00 0.00% Miscellaneous 000-497000 Misc Income - - 2.00 - - - 0.00% TOTAL Miscellaneous - - 2.00 - - - 0.00% TOTAL REVENUES 252,500 12,915.40 77,543.62 76,315.81 - 176,184.19 30.22% C I T Y O F S C H E R T Z ************************************************** 2 0 1 4 - 2 0 1 5 ************************************************** REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2015 26 Cash in Bank Cash Balance 516,923.07$ Total Cash in Bank & Investments 516,923.07$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2015 PEG FUND 27 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 220,285 5,000.00 174,549.35 191,431.33 - 28,853.67 86.90% Permits 65,000.00 18,697.94 66,013.85 119,741.94 - (54,741.94) 184.22% Fees 17,659,700 1,582,712.60 12,475,105.32 13,853,344.19 - 3,806,355.81 78.45% Fund Transfers 813,272 10,830.00 102,834.72 97,470.00 - 715,802.00 11.98% Miscellaneous 143,858 7,790.36 98,818.31 122,044.14 - 21,813.86 84.84% TOTAL REVENUES 18,902,115 1,625,030.90 12,917,321.55 14,384,031.60 - 4,518,083.40 76.10% EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers - - 860,041.78 - - - 0.00% TOTAL NON DEPARTMENTAL - - 860,041.78 - - - 0.00% BUSINESS OFFICE Personnel Services 467,483 34,781.29 316,883.10 312,705.68 - 154,777.32 66.89% Supplies 4,600 249.47 2,147.95 2,765.48 25.00 1,809.52 60.66% Human Services 183 201.00 - 201.00 - (18.00) 109.84% City Support Services 3,035 - 831.00 - - 3,035.00 0.00% Utility Services 700 103.00 51.42 451.15 - 248.85 64.45% Operations Support 139,340 16,863.23 91,556.56 100,578.91 - 38,761.09 72.18% Staff Support 7,300 763.26 1,831.87 3,374.35 128.16 3,797.49 47.98% Professional Services 71,000 7,264.47 55,616.94 75,495.59 - (4,495.59) 106.33% Maintenance Services 12,000 840.00 9,255.00 5,700.00 2,420.00 3,880.00 67.67% Operating Equipment 1,550 - - - - 1,550.00 0.00% Capital Outlay 44,000 22,064.90 - 44,129.80 - (129.80) 100.30% TOTAL BUSINESS OFFICE 751,191 83,130.62 478,173.84 545,401.96 2,573.16 203,215.88 72.95% ******************************************************* 2 0 1 5 - 2 0 1 6 ****************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 28 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ******************************************************* 2 0 1 5 - 2 0 1 6 ****************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 W & S ADMINISTRATION Personnel Services 1,295,299 77,038.83 821,486.26 862,520.27 - 432,778.73 66.59% Supplies 187,150 21,764.65 124,511.49 140,832.46 1,094.83 45,222.71 75.84% Human Services 1,000 80.00 476.00 282.00 - 718.00 28.20% City Support Services 59,900 - 35,702.56 45,114.81 407.97 14,377.22 76.00% Utility Services 3,378,500 307,768.74 2,116,137.29 2,393,086.04 327.41 985,086.55 70.84% Operations Support 6,545 1,300.59 2,950.69 5,784.99 - 760.01 88.39% Staff Support 33,850 612.27 15,379.73 19,045.21 1,064.57 13,740.22 59.41% City Assistance 1,900 354.00 1,110.00 1,293.00 32.00 575.00 69.74% Professional Services 183,838 10,122.81 134,193.53 131,315.52 - 52,522.48 71.43% Fund Charges/Transfers 3,856,374 222,872.51 2,212,453.03 3,010,881.50 - 845,492.50 78.08% Maintenance Services 7,086,115 621,926.77 4,684,494.04 5,183,663.90 2,474.27 1,899,976.83 73.19% Other Costs 35,000 10.00 27,150.20 27,160.20 - 7,839.80 77.60% Debt Service 1,453,258 - 211,759.71 614,139.02 - 839,118.98 42.26% Rental-Leasing 6,070 - 3,091.21 2,623.19 - 3,446.81 43.22% Operating Equipment 8,000 - 16,329.92 - 399.98 7,600.02 5.00% Capital Outlay 11,881 - 69,867.20 32,904.13 - (21,023.13) 276.95% TOTAL PUBLIC WORKS 17,604,680 1,263,851.17 10,477,092.86 12,470,646.24 5,801.03 5,128,232.73 70.87% MISC & PROJECTS PROJECTS Fund Charges/Transfers 500,000 - 85,186.10 - - 500,000.00 0.00% TOTAL PROJECTS 500,000 - 85,186.10 - - 500,000.00 0.00% TOTAL MISC & PROJECTS 500,000 - 85,186.10 - - 500,000.00 0.00% TOTAL EXPENDITURES 18,855,871 1,346,981.79 11,900,494.58 13,016,048.20 8,374.19 5,831,448.61 69.07% ** REVENUE OVER(UNDER)EXPENSES **46,244 278,049.11 1,016,826.97 1,367,983.40 (8,374.19) (1,313,365.21) 29 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421490 Tower Leasing 220,285 5,000.00 174,549.35 191,431.33 - 28,853.67 86.90% TOTAL Franchises 220,285 5,000.00 174,549.35 191,431.33 - 28,853.67 86.90% Permits 000-432400 Development Permit 65,000 18,697.94 66,013.85 119,741.94 - (54,741.94) 184.22% TOTAL Permits 65,000 18,697.94 66,013.85 119,741.94 - (54,741.94) 184.22% Fees 000-455200 Garbage Collection Fee 4,150,000 357,240.75 3,063,081.76 3,307,987.58 - 842,012.42 79.71% 000-455600 Fire Line Fees 25,700 - 25,630.00 27,025.00 - (1,325.00) 105.16% 000-455700 Recycle Fee Revenue 275,000 24,149.60 203,700.77 212,731.76 - 62,268.24 77.36% 000-455800 W&S Line Constructn Reimbursemnt 25,000 13,688.81 18,996.00 28,716.87 - (3,716.87) 114.87% 000-457100 Sale of Water 8,180,000 690,470.23 5,376,979.42 5,981,408.70 - 2,198,591.30 73.12% 000-457110 Edwards Water Lease 97,000 - 137,518.00 81,975.30 - 15,024.70 84.51% 000-457120 Water Transfer Charge-Selma 42,000 11,897.53 21,600.91 42,186.19 - (186.19) 100.44% 000-457130 Water Transfer Charge-U. C. 10,000 - 4,911.69 203.11 - 9,796.89 2.03% 000-457140 Water Transfer Charge-Converse 30,000 - 20,164.70 13,527.69 - 16,472.31 45.09% 000-457200 Sale of Meters 90,000 4,162.00 62,878.02 50,071.10 - 39,928.90 55.63% 000-457400 Sewer Charges 4,532,000 464,811.04 3,378,063.39 3,940,228.34 - 591,771.66 86.94% 000-457500 Water Penalties 200,000 16,042.64 158,231.66 165,632.55 - 34,367.45 82.82% 000-458300 Sale of Property/Auction 500 - 1,575.00 - - 500.00 0.00% 000-459200 NSF Check Fee-Water&Sewer 2,500 250.00 1,775.00 1,650.00 - 850.00 66.00% TOTAL Fees 17,659,700 1,582,712.60 12,475,106.32 13,853,344.19 - 3,806,355.81 78.45% Fund Transfers 000-481000 Transfer In- Reserve 500,000 - - - - 500,000.00 0.00% 000-486103 Transfer In-Vehicle Reserves 44,000 - - - - 44,000.00 0.00% 000-486204 Interfnd Chrg-Drainage Bill 129,960 10,830.00 102,834.72 97,470.00 - 32,490.00 75.00% 000-486411 Transfer In-Capital Recovery 139,312 - - - - 139,312.00 0.00% TOTAL Fund Transfers 813,272 10,830.00 102,834.72 97,470.00 - 715,802.00 11.98% ******************************************************* 2 0 1 5 - 2 0 1 6 ****************************************************** AS OF: JUNE 30, 2016 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z 30 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ******************************************************* 2 0 1 5 - 2 0 1 6 ****************************************************** AS OF: JUNE 30, 2016 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z Miscellaneous 000-490000 Misc Charges 500 - 471.00 623.00 - (123.00) 124.60% 000-491000 Interest Earned 1,500 113.45 890.52 589.96 - 910.04 39.33% 000-491200 Investment Income 5,000 979.56 3,993.78 14,488.75 - (9,488.75) 289.78% 000-497000 Misc Income-W&S 15,000 6,697.35 5,985.62 14,444.81 - 555.19 96.30% 000-498110 Reimbursement-SSLGC 121,858 - 87,477.39 88,027.87 - 33,830.13 72.24% 000-498200 Reimbursement- W&S Project - - - 3,869.75 - (3,869.75) 0.00% TOTAL Miscellaneous 143,858 7,790.36 98,818.31 122,044.14 - 21,813.86 84.84% TOTAL REVENUES 18,902,115 1,625,030.90 12,917,322.55 14,384,031.60 - 4,518,083.40 76.10% 31 Cash in Bank Claim on Operating Cash Pool-Checking 1,872,457.77$ Cash in Investments Lone Star Investment-Water&Sewer 1,075,112.65 Lone Star Investment-W&S Customer Deposits 296,666.77 Lone Star Investment-W&S Equip Replacement 178,369.99 Lone Star Investment-W&S Veh Replacement 257,671.68 Schertz Bank & Trust-Certificate of Deposit 3,130,647.95 4,938,469.04$ Total Cash in Bank & Investments 6,810,926.81$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2016 WATER & SEWER 32 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 5,866,640 362,992.11 4,118,886.48 4,169,179 - 1,697,461 71.07% Inter-Jurisdictional 1,742,807 26,078 1,254,357 1,354,788 - 388,019 77.74% Miscellaneous 300,347 3,284 45,101 66,383 - 233,964 22.10% TOTAL REVENUES 7,909,794 392,353.78 5,418,345.26 5,590,350.13 - 2,319,443.87 70.68% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 3,479,251 272,164.68 2,282,394.89 2,416,809.55 - 1,062,441.45 69.46% Supplies 425,731 36,667.34 273,282.27 297,323.93 17,384.09 111,022.98 73.92% Human Services 1,000 - 674.50 362.50 - 637.50 36.25% City Support Services 34,850 255.00 14,617.51 16,854.03 - 17,995.97 48.36% Utility Services 136,653 8,842.10 74,978.76 61,102.87 191.41 75,358.72 44.85% Operations Support 102,335 9,048.70 76,281.33 51,453.83 919.17 49,962.00 51.18% Staff Support 84,792 11,315.32 63,834.45 51,746.94 7,205.92 25,839.14 69.53% City Assistance 13,400 340.06 11,715.73 6,954.78 434.94 6,010.28 55.15% Professional Services 107,000 7,998.12 94,621.59 83,588.30 - 23,411.70 78.12% Fund Charges/Transfers 2,616,485 321,160.44 1,616,624.38 1,683,798.61 - 932,686.39 64.35% Maintenance Services 67,380 2,109.74 23,836.11 22,082.94 1,395.00 43,902.06 34.84% Debt Service 205,498 - 1,336.67 7,722.61 - 197,775.39 3.76% Rental-Leasing 81,541 5,795.07 52,735.14 52,155.63 17,385.21 12,000.16 85.28% Operating Equipment 182,827 7,829.90 149,349.40 36,752.01 3,866.93 142,208.06 22.22% Capital Outlay 188,205 47,652.36 50,746.29 864,131.36 5,831.00 (681,757.36) 462.24% TOTAL PUBLIC SAFETY 7,726,948 731,178.83 4,787,029.02 5,652,839.89 54,613.67 2,019,494.44 73.86% TOTAL EXPENDITURES 7,726,948 731,178.83 4,787,029.02 5,652,839.89 54,613.67 2,019,494.44 73.86% ** REVENUE OVER(UNDER) EXPENSES **182,846 (338,825) 631,316 (62,490) (54,614) 299,949 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 5 - 2 0 1 6 *************************************************** 33 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000-456100 Ambulance/Mileage Transport 5,717,640 361,540.21 3,987,330.76 4,013,112.70 - 1,704,527.30 70.19% 000-456110 Subscription Program Fees 40,000 30.00 25,980.00 27,900.00 - 12,100.00 69.75% 000-456120 EMT Class - Fees 87,000 (75.00) 89,025.90 100,754.97 - (13,754.97) 115.81% 000-456130 Immunization Fees - 420.00 8,364.00 - (8,364.00) 0.00% 000-456140 Billing Fees - Alamo Heights 22,000 1,496.90 15,974.82 15,059.97 - 6,940.03 68.45% 000-458110 Sales of Merchandise - GovDeal - 155.00 3,937.50 - (3,937.50) 0.00% 000-459200 NSF Check Fee - - - 50.00 - (50.00) 0.00% TOTAL Fees 5,866,640 362,992.11 4,118,886.48 4,169,179.14 - 1,697,460.86 71.07% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 294,710 26,077.61 238,438.80 302,949.67 - (8,239.67) 102.80% 000-474300 Cibolo Support 269,225 - 196,044.75 201,918.75 - 67,306.25 75.00% 000-475100 Comal Co ESD #6 98,079 - 69,497.10 71,487.50 - 26,591.50 72.89% 000-475200 Live Oak Support 202,826 - 142,177.50 152,009.28 - 50,816.72 74.95% 000-475300 Universal City Support 254,788 - 185,531.64 191,090.64 - 63,697.36 75.00% 000-475400 Selma Support 104,528 - 55,469.25 57,131.25 - 47,396.75 54.66% 000-475500 Schertz Support 494,024 - 349,266.03 359,730.93 - 134,293.07 72.82% 000-475600 Santa Clara Support 9,969 - 7,259.07 7,476.57 - 2,492.43 75.00% 000-475800 Marion Support 14,658 - 10,673.34 10,993.14 - 3,664.86 75.00% TOTAL Inter-Jurisdictional 1,742,807 26,077.61 1,254,357.48 1,354,787.73 - 388,019 77.74% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30,2016 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 34 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30,2016 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** Miscellaneous 000-491000 Interest Earned 100 13.73 68.15 66.54 - 33.46 66.54% 000-491200 Investment Income 750 46.07 526.96 558.24 - 191.76 74.43% 000-493203 Donations-EMS 2,000 100.00 710.00 531.15 - 1,468.85 26.56% 000-493205 Donations- Golf Tournament 9,000 - 7,380.00 11,485.00 - (2,485.00) 127.61% 000-495100 UH Grant Program 168,497 - - - - 168,497.00 0.00% 000-497000 Misc Income 110,000 2,828.86 28,885.59 45,509.14 - 64,490.86 41.37% 000-497100 Recovery of Bad Debt 10,000 295.40 7,530.60 8,233.19 - 1,766.81 82.33% TOTAL Miscellaneous 300,347 3,284.06 45,101.30 66,383.26 - 233,963.74 22.10% TOTAL REVENUES 8,097,999 440,006.14 5,469,091.55 6,454,481.49 5,831.00 1,637,686.51 79.78% 35 Cash in Bank Claim on Operating Cash Pool-Checking 278,118.66$ Cash in Investments Texas Class- Tax Note 2015 Ambulances 88,946.41 Total Cash in Bank & Investments 367,065.07$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30,2016 SCHERTZ EMS 36 204-DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Permits 3,000 300.00 2,100.00 2,280.00 - 720.00 76.00% Fees 1,083,000 93,528.25 810,726.22 837,158.15 - 245,841.85 77.30% Fund Transfers 213,920 - - - - 213,920.00 0.00% Miscellaneous 80,700 736.88 26,293.31 4,795.95 - 75,904.05 5.94% TOTAL REVENUES 1,380,620 94,565.13 839,119.53 844,234.10 - 536,385.90 61.15% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 471,053 28,875.89 322,628.19 298,220.66 172,832.34 63.31% Supplies 8,300 279.42 4,524.26 2,414.58 208.95 5,676.47 31.61% Human Services 325 - - - - 325.00 0.00% City Support Services 28,500 - 2,306.64 2,703.95 - 25,796.05 9.49% Utility Services 30,370 1,587.03 12,988.48 7,735.89 - 22,634.11 25.47% Operations Support 2,460 - 64.97 - - 2,460.00 0.00% Staff Support 8,116 100.76 3,636.77 2,527.62 255.37 5,333.01 34.29% City Assistance 840 - - 120.00 - 720.00 14.29% Professional Services 24,500 - 5,307.94 14,500.00 3,500.00 6,500.00 73.47% Fund Charges/Transfers 215,573 17,881.08 165,613.41 160,929.76 - 54,643.24 74.65% Maintenance Services 21,000 20,850.00 1,457.90 22,030.86 - (1,030.86) 104.91% Other costs 200 - 100.00 100.00 - 100.00 50.00% Debt Service 135,294 - 705.76 6,327.18 - 128,966.82 4.68% Rental/Leasing 500 - - - - 500.00 0.00% Operating Equipment 5,500 - 4,091.64 4,594.98 - 905.02 83.55% Capital Outlay 54,500 6,646.80 - 50,063.72 212.00 4,224.28 92.25% TOTAL DRAINAGE 1,007,031 76,220.98 523,425.96 572,269.20 4,176.32 430,585.48 57.24% PROJECTS Operations Support - - 591.34 - - - 0.00% Professional Services - - 5,138.75 - 8,000.00 (8,000.00) 0.00% Maintenance Services 213,920 - 137,727.74 13.59 - 213,906.41 0.01% TOTAL PROJECTS 213,920 - 143,457.83 13.59 8,000.00 205,906.41 3.75% TOTAL EXPENDITURES 1,220,951 76,220.98 666,883.79 572,282.79 12,176.32 636,491.89 47.87% ** REVENUE OVER(UNDER) EXPEND 159,669 271,951.31 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2015 **************************************************** 2 0 15 - 2 0 1 6 **************************************************** 37 204-DRAINAGE CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000-432400 Floodplain Permit 3,000 300.00 2,100.00 2,280.00 - 720.00 76.00% TOTAL Permits 3,000 300.00 2,100.00 2,280.00 - 720.00 76.00% Fees 000-457500 Drainage Penalties 8,000 584.18 7,190.80 7,076.42 - 923.58 88.46% 000-457600 Drainage Fee 14,000 92,944.07 803,535.42 830,081.73 - (816,081.73) 5929.16% TOTAL Fees 22,000 93,528.25 810,726.22 837,158.15 - (815,158.15) 3805.26% Fund Transfers 000-481000 Transfer In 213,920 - - - - 213,920.00 0.00% TOTAL Funds Transfers 213,920 - - - - 213,920 0.00% Miscellaneous 000-491000 Interest Earned 100 10.39 196.60 58.59 - 41.41 58.59% 000-491200 Investment Interest 500 726.49 1,096.71 4,737.36 - (4,237.36) 947.47% 000-493204 Donations- Drainage Project 80,000 - 25,000.00 - 80,000.00 0.00% 000-497000 Misc Income-Drainage 100 - - - - 100.00 0.00% TOTAL Miscellaneous 80,700 736.88 26,293.31 4,795.95 - 75,904.05 5.94% TOTAL REVENUES 319,620 94,565.13 839,119.53 844,234.10 - (524,614.10) 264.14% C I T Y O F S C H E R T Z *********************************************** 2 0 1 4 - 2 0 1 5 ************************************************* REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2015 38 Cash in Bank Claim on Operating Cash Pool-Checking 223,868.06 Cash in Investments Lone Star Investment-Drainage Maint Fund 809,286.22 Total Cash in Bank & Investments 1,033,154.28$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2015 39 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 592,707 19,028.48 346,788.04 355,899.83 - 472,361.60 60.05% Miscellaneous 570 381.41 388.83 2,273.30 - 207.41 398.82% TOTAL REVENUES 593,277 19,409.89 347,176.87 358,173.13 - 472,569.01 60.37% EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 65,500 9,837.10 31,175.58 43,472.00 2,668.00 19,360.00 70.44% Operations Support 66,425 1,798.50 15,110.50 14,910.50 649.50 50,865.00 23.42% Professional Services 3,000 - 3,000.00 3,000.00 - - 100.00% Fund Charges/Transfers 114,405 - 73,303.75 - - 114,405.00 0.00% Maintenance Services 10,000 - - 5,555.00 - 4,445.00 55.55% Operating Equipment - - 3,928.04 - 1,712.60 (1,712.60) 0.00% TOTAL NONDEPARTMENTAL 259,330 11,635.60 126,517.87 66,937.50 5,030.10 187,362.40 27.75% TOTAL EXPENDITURES 259,330 11,635.60 126,517.87 66,937.50 5,030.10 187,362.40 27.75% REVENUE OVER(UNDER) EXPENDITURE 333,947 291,235.63 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31ST, 2015 **************************************************** 2 0 1 5 - 2 0 1 6 **************************************************** 40 Cash in Bank Claim on Operating Cash Pool-Checking 399,174.05$ Cash in Investments Texas Class - Hotel Tax 701,836.04 Total Cash in Bank & Investments 1,101,010.09$ CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31ST, 2015 HOTEL OCCUPANCY TAX FUND 41 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2015-16 40,800 40,351 38,394 34,516 39,732 54,142 49,741 45,524 51,636 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 2011-12 33,128 32,675 32,143 35,829 36,215 45,071 36,518 40,335 48,397 53,622 46,551 29,807 $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000 HOTEL OCCUPANCY TAX 42 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 111,129 36,000.00 18,000.00 130,000.00 - (18,871.00) 116.98% Miscellaneous 100 50.74 79.91 1,176.08 - (1,076.08) 1176.08% TOTAL REVENUES 111,229 36,050.74 18,079.91 131,176.08 - (19,947.08) 117.93% EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Transfers - - 32,405.00 - - - 0.00% TOTAL PARKLAND DEDICATION - - 32,405.00 - - - 0.00% PARKLAND DEDICATION Operating Equipment 14,800 - - 750.00 - 14,050.00 5.07% Capital Outlay 20,000 - 10,930.00 22,857.00 7,184.49 (10,041.49) 150.21% TOTAL PARKLAND DEDICATION 34,800 - 10,930.00 23,607.00 7,184.49 4,008.51 88.48% TOTAL EXPENDITURES 34,800 - 43,335.00 23,607.00 7,184.49 4,008.51 88.48% REVENUE OVER(UNDER) EXPEND 76,429 107,569.08 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2015 *********************************************** 2 0 1 5 - 2 0 1 6 *********************************************** 43 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458800 Parkland Dedication 111,129 36,000.00 18,000.00 130,000.00 - (18,871.00) 116.98% TOTAL Fees 111,129 36,000.00 18,000.00 130,000.00 - (18,871.00) 116.98% Miscellaneous 000-491000 Interest Earned 75 11.03 68.69 97.46 - (22.46) 129.95% 000-491200 Investment Interest 25 39.71 11.22 208.50 - (183.50) 834.00% 000-497000 Misc Income - - - 870.12 - (870.12) 0.00% TOTAL Miscellaneous 100 50.74 79.91 1,176.08 - (1,076.08) 1176.08% TOTAL REVENUES 111,229 36,050.74 18,079.91 131,176.08 - (19,947.08) 117.93% C I T Y O F S C H E R T Z ******************************************************* 2 0 1 5 - 2 0 1 6 ******************************************************* REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2015 44 Cash in Bank Claim on Operating Cash Pool-Checking $265,131.09 Cash in Investments Texas Class- Park Fund 76,565.09 Total Cash in Bank & Investments $341,696.18 CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2015 PARK FUND 45 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 40,000 3,612.50 188,002.50 41,267.50 - (1,267.50) 103.17% Fund Transfers 5,000 - - - - 5,000.00 0.00% Miscellaneous 250 165.20 248.91 1,102.04 - (852.04) 440.82% TOTAL REVENUES 45,250 3,777.70 188,251.41 42,369.54 - 2,880.46 93.63% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services-Trees 32,000 - 9,154.00 67,189.00 52,375.00 (87,564.00) 373.64% TOTAL TREE MITIGATION 32,000 - 9,154.00 67,189.00 52,375.00 (87,564.00) 373.64% TOTAL EXPENDITURES 32,000 - 9,154.00 67,189.00 52,375.00 (87,564.00) 373.64% REVENUE OVER(UNDER) EXPEND 13,250 3,777.70 179,097.41 (24,819.46) (52,375.00) 90,444.46 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 5 - 2 0 1 6 *************************************************** 46 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458900 Tree Mitigation 40,000 3,612.50 188,002.50 41,267.50 - (1,267.50) 103.17% TOTAL Fees 40,000 3,612.50 188,002.50 41,267.50 - (1,267.50) 103.17% Fund Transfers 000-481000 Transfer In - Reserves 5,000 - - - - 5,000.00 0.00% TOTAL Fund Transfers 5,000 - - - - 5,000.00 0.00% Miscellaneous 000-491000 Interest Earned 150 - 118.13 23.21 - 126.79 15.47% 000-491200 Investment Interest 100 165.20 130.78 1,078.83 - (978.83) 1078.83% TOTAL Miscellaneous 250 165.20 248.91 1,102.04 - (852.04) 440.82% TOTAL REVENUES 45,250 3,777.70 188,251.41 42,369.54 - 2,880.46 93.63% C I T Y O F S C H E R T Z ******************************************************* 2 0 1 5 - 2 0 1 6 ******************************************************* REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 47 Cash in Bank Claim on Operating Cash Pool-Checking ($27,224.31) Cash in Investments MBIA Investment-Tree Mitigation 318,734.39 Total Cash in Bank & Investments $291,510.08 CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2016 TREE MITIGATION FUND 48 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 920,000 55,746.00 847,516.30 698,292.00 - 221,708.00 75.90% Fund Transfers 2,550,541 - - - - 2,550,541.00 0.00% Miscellaneous 6,600 2,444.88 4,538.55 15,791.40 - (9,191.40) 239.26% TOTAL REVENUES 3,477,141 58,190.88 852,054.85 714,083.40 - 2,763,057.60 20.54% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 5,000 - - - - 5,000.00 0.00% Professional Services 106,000 - 1,000.00 1,000.00 - 105,000.00 0.94% Fund Charges/Transfers - - 3,579.00 - - - 0.00% Maintenance Services 1,000 - - - - 1,000.00 0.00% TOTAL NON DEPARTMENTAL 112,000 - 4,579.00 1,000.00 - 111,000.00 0.89% MISC & PROJECTS PROJECTS Professional Services 315,141 - - - 186,732.71 128,408.29 59.25% Fund Charges/Transfers 3,050,000 - 85,186.10 366,594.84 - 2,683,405.16 12.02% TOTAL MISC & PROJECTS 3,365,141 - 85,186.10 366,594.84 186,732.71 2,811,813.45 16.44% TOTAL EXPENDITURES 3,477,141 - 89,765.10 367,594.84 186,732.71 2,922,813.45 15.94% REVENUE OVER(UNDER) EXPENDITURES - 58,190.88 762,289.75 346,488.56 (186,732.71) (159,755.85) 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 5 - 2 0 1 6 ******************************************************* 49 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fees 000-455900 Capital Recovery - Water 920,000 55,746.00 847,516.30 698,292.00 - 221,708.00 75.90% TOTAL Fees 920,000 55,746.00 847,516.30 698,292.00 - 221,708.00 75.90% Fund Transfers 000-481000 Transfer from Reserves 2,550,541 - - - - 2,550,541.00 0.00% TOTAL Fund Transfers 2,550,541 - - - - 2,550,541.00 0.00% Miscellaneous 000-491000 Interest Earned 600 42.04 514.62 437.28 - 162.72 72.88% 000-491200 Investment Income 6,000 2,402.84 4,023.93 15,354.12 - (9,354.12) 255.90% TOTAL Miscellaneous 6,600 2,444.88 4,538.55 15,791.40 - (9,191.40) 239.26% TOTAL REVENUES 3,477,141 58,190.88 852,054.85 714,083.40 - 2,763,057.60 20.54% C I T Y O F S C H E R T Z **************************************************** 2 0 1 5 - 2 0 1 6 ***************************************************** REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 50 Cash in Bank Claim on Operating Cash Pool-Checking 946,689.56$ Cash in Investments Lone Star Investment-Capital Recovery Water 5,214,359.06 Total Cash in Bank & Investments 6,161,048.62$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2016 CAPITAL RECOVERY WATER 51 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 550,000 39,275.25 483,295.44 359,941.89 - 190,058.11 65.44% Fund Transfers 3,077,712 - - - - 3,077,712.00 0.00% Miscellaneous 16,000 11,890.41 13,240.43 27,668.26 - (11,668.26) 172.93% TOTAL REVENUES 3,643,712 51,165.66 496,535.87 387,610.15 - 3,256,101.85 10.64% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 84,000 362.78 4,229.50 4,246.63 - 79,753.37 5.06% Fund Charges/Transfers 139,312 - - - - 139,312.00 0.00% Maintenance Services 320,400 - - - - 320,400.00 0.00% TOTAL NON DEPARTMENTAL 543,712 362.78 4,229.50 4,246.63 - 539,465.37 0.78% MISC & PROJECTS Professional Services 100,000 - - - - 100,000.00 0.00% Sewer Projects 3,000,000 - - - - 3,000,000.00 0.00% TOTAL MISC & PROJECTS 3,100,000 - - - - 3,100,000.00 0.00% TOTAL EXPENDITURES 3,643,712 362.78 4,229.50 4,246.63 - 3,639,465.37 0.12% REVENUE OVER(UNDER) EXPENDITURES - 50,802.88 492,306.37 383,363.52 - 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 5 - 2 0 1 6 ******************************************************* 52 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fees 000-455910 Capital Recovery - Waste Wtr 500,000 35,675.25 425,695.44 327,541.89 - 172,458.11 65.51% 000-455913 Cap Recovery-North Sewer Tr 50,000 3,600.00 57,600.00 32,400.00 - 17,600.00 64.80% TOTAL Fees 550,000 39,275.25 483,295.44 359,941.89 - 190,058.11 65.44% Fund Transfers 000-481000 Transfer from Reserves 3,077,712 - - - - 3,077,712.00 0.00% TOTAL Fund Transfers 3,077,712 - - - - 3,077,712.00 0.00% Miscellaneous 000-491000 Interest Earned 1,000 31.04 314.27 296.95 - 703.05 29.70% 000-491200 Investment Income 15,000 3,348.12 20,901.98 33,959.48 - (18,959.48) 226.40% 000-491800 Gain/Loss - - (10,238.49) (35,426.62) - 35,426.62 0.00% 000-491900 Unrealized Gain/Loss-Cap One - 8,511.25 2,262.67 28,838.45 - (28,838.45) 0.00% TOTAL Miscellaneous 16,000 11,890.41 13,240.43 27,668.26 - (11,668.26) 172.93% TOTAL REVENUES 3,643,712 51,165.66 496,535.87 387,610.15 - 3,256,101.85 10.64% C I T Y O F S C H E R T Z **************************************************** 2 0 1 5 - 2 0 1 6 ***************************************************** REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 53 Cash in Bank Claim on Operating Cash Pool-Checking 699,003.46$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 2,360,994.42 Capital One-Investment 1,720,426.42 Total Cash in Bank & Investments 4,780,424.30$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2016 CAPITAL RECOVERY SEWER 54 505-TAX I&S CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 5,722,162 18,422.05 5,363,047.94 5,777,515.17 - (55,353.17) 100.97% Miscellaneous 369,213 1,222.93 353,072.79 4,547,102.99 - (4,177,889.99) 1231.57% TOTAL REVENUES 6,091,375 19,644.98 5,716,120.73 10,324,618.16 - (4,233,243.16) 169.50% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 102,500 - 1,550.00 83,574.23 - 18,925.77 81.54% Debt Service 5,718,918 - 4,442,606.03 4,411,781.19 - 1,307,136.81 77.14% Other Financing Sources - - - 4,220,709.38 - (4,220,709.38) 0.00% TOTAL GENERAL GOVERNMENT 5,821,418 - 4,444,156.03 8,716,064.80 - (2,894,646.80) 149.72% - TOTAL EXPENDITURES 5,821,418 - 4,444,156.03 8,716,064.80 - (2,894,646.80) 149.72% ** REVENUE OVER(UNDER) EXPEND 269,957 1,608,553.36 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 4 - 2 0 1 5 **************************************************** 55 505-TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411900 Property Tax Revenue 5,722,162 18,422.05 5,363,047.94 5,777,515.17 - (55,353.17) 100.97% TOTAL Taxes 5,722,162 18,422.05 5,363,047.94 5,777,515.17 - (55,353.17) 100.97% Miscellaneous 000-491000 Interest Earned 75 4.34 7.16 256.48 - (181.48) 341.97% 000-491200 Investment Earnings 2,000 1,218.59 1,996.88 5,727.76 - (3,727.76) 286.39% 000-495015 Contribution from SED 367,138 - 351,068.75 356,118.75 - 11,019.25 97.00% 000-498000 Proceeds From Refunding Debt - - - 4,185,000.00 - (4,185,000.00) 0.00% TOTAL Miscellaneous 369,213 1,222.93 353,072.79 4,547,102.99 - (4,177,889.99) 1231.57% TOTAL REVENUES 6,091,375 19,644.98 5,716,120.73 10,324,618.16 - (4,233,243.16) 169.50% C I T Y O F S C H E R T Z ***************************************************** 2 0 1 4 - 2 0 1 5 ***************************************************** REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 56 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF NON DEPARTMENTAL BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101-541500 Paying Agent 2,500 - 1,550.00 1,350.00 - 1,150.00 54.00% 101-541502 Cost of Bond Issuance 100,000 - - 82,224.23 - 17,775.77 82.22% TOTAL Professional Services 102,500 - 1,550.00 83,574.23 - 18,925.77 81.54% Debt Service 101-555612 Bond-GO Refunding 2010-Principal 275,000 - 265,000.00 275,000.00 - - 100.00% 101-555612.1 Bond-GO Refunding 2010 Interest 55,425 - 33,750.00 29,775.00 - 25,650.00 53.72% 101-555626 LS&D SR2006-Principal 400,000 - 350,000.00 394,772.50 - 5,227.50 98.69% 101-555626.1 LS&D SR2006-Interest 189,419 - 105,709.38 0.01 - 189,418.99 0.00% 101-555628 CO Bond 2007-Principal 122,800 - - - - 122,800.00 0.00% 101-555628.1 CO Bond 2007-Interest 4,925 - 4,790.61 2,461.75 - 2,463.25 49.98% 101-555629 GO Bond 2007-Principal 265,000 - 255,000.00 264,944.60 - 55.40 99.98% 101-555629.1 GO Bond 2007-Interest 159,036 - 87,268.47 82,214.00 - 76,822.00 51.70% 101-555630 GO Bond SR2008 Principal 440,000 - 420,000.00 440,000.00 - - 100.00% 101-555630.1 GO Bond SR2008 Interest 296,946 - 161,689.50 153,016.50 - 143,929.50 51.53% 101-555631 GO Bond SR2009 Principal 540,000 - 535,000.00 540,000.00 - - 100.00% 101-555631.1 BO Bond SR2009 Interest 282,675 - 153,412.50 145,387.50 - 137,287.50 51.43% 101-555633 GO SR2011 Principal 225,000 - 220,000.00 225,000.00 - - 100.00% 101-555633.1 GO SR2011 Interest 341,663 - 176,918.75 172,518.75 - 169,144.25 50.49% 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 4 - 2 0 1 5 ***************************************************** 57 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF NON DEPARTMENTAL BUDGET PERIOD 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, 2016 ***************************************************** 2 0 1 4 - 2 0 1 5 ***************************************************** 101-555634 GO SR2011A Refund Principal 605,000 - 610,000.00 605,000.00 - - 100.00% 101-555634.1 GO SR2011A Refund Interest 116,675 - 68,968.00 61,861.50 - 54,813.50 53.02% 101-555635 GO SR2012 Principal 310,000 - 295,000.00 310,000.00 - - 100.00% 101-555635.1 GO SR2012 Interest 194,721 - 106,079.38 100,363.75 - 94,357.25 51.54% 101-555636 Tax Note - SR2013 - Principal 170,000 - 165,000.00 170,000.00 - - 100.00% 101-555636.1 Tax Note - SR2013 - Interest 5,950 - 4,142.50 3,400.00 - 2,550.00 57.14% 101-555637 Tax Note - SR 2013A - Principal 160,000 - 160,000.00 160,000.00 - - 100.00% 101-555637.1 Tax Note - SR2013 - Interest 5,265 - 4,192.50 3,152.51 - 2,112.49 59.88% 101-555638 Bond-GO 2014 Refund-Principal 100,000 - 50,000.00 100,000.00 - - 100.00% 101-555638.1 Bond-GO 2014 Refund-Interest 294,275 - 210,684.44 147,637.50 - 146,637.50 50.17% 101-555639 Tax Note - SR2015 - Principal 35,000 - - - - 35,000.00 0.00% 101-555639.1 Tax Note - SR2015 - Interest 3,763 - 1,875.17 - 1,887.83 49.83% 101-555640 Bond-Ref 2015 Bond- Principal - - - 80,000.00 - (80,000.00) 0.00% 101-555640.1 Bond-GO Ref 2015- Interest - - - 27,056.25 - (27,056.25) 0.00% 101-555900 Debt Service 120,380 - - - - 120,380.00 0.00% 101-555800 Bond Premium - - - (83,656.10) - 83,656.10 0.00% TOTAL Debt Service 5,718,918 - 4,442,606.03 4,411,781.19 - 1,307,136.81 77.14% Other Financing Sources 101-556300 Payment to Refund Debt - 4,220,709.38 - 4,220,709.38 - (4,220,709.38) 0.00% TOTAL Other Financing Sources - 4,220,709 - 4,220,709.38 - (4,220,709.38) 0.00% TOTAL EXPENDITURES 5,821,418 4,220,709.38 4,444,156.03 8,716,064.80 - 1,326,062.58 149.72% 58 Cash in Bank Claim on Operating Cash Pool-Checking 104,566.11$ Cash in Investments MBIA Investment- Tax I&S 2,351,164.51 Total Cash in Bank & Investments 2,455,730.62$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2016 TAX I&S 59 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 3,518,362 347,255.92 2,571,686.68 2,649,184.71 - 869,177.29 75.30% Miscellaneous 10,200 6,103.73 11,513.55 31,199.30 - (20,999.30) 305.88% TOTAL REVENUES 3,528,562 353,359.65 2,583,200.23 2,680,384.01 - 848,177.99 75.96% EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services 325,458 24,000.71 113,702.91 193,052.74 - 132,405.26 59.32% Supplies 750 69.23 501.10 122.83 - 627.17 16.38% Human Services 1,000 - 135.00 44.44 - 955.56 4.44% City Support Services 12,545 - 1,114.09 1,643.91 396.00 10,505.09 16.26% Utility Services 4,820 273.07 615.35 1,712.36 27.99 3,079.65 36.11% Operations Support 139,572 7,216.56 52,585.14 78,393.24 1,183.01 59,995.75 57.01% Staff Support 19,100 40.00 1,934.83 4,197.49 - 14,902.51 21.98% City Assistance 1,005,000 67.95 - 281.27 - 1,004,718.73 0.03% Professional Services 87,500 195.00 7,021.95 14,480.88 - 73,019.12 16.55% Fund Charges/Transfers 418,138 4,252.00 429,137.72 394,386.75 - 23,751.25 94.32% Debt Service 161,216 - 274,494.00 3,107.25 - 158,108.75 1.93% Operating Equipment 2,628 1,927.09 368.77 1,927.09 - 700.91 73.33% Capital Outlay 40,000 - - - 28,533.00 11,467.00 71.33% TOTAL ECONO DEVELOPMENT 2,217,727 38,041.61 881,610.86 693,350.25 30,140.00 1,494,236.75 32.62% MISC & PROJECTS PROJECTS 441,775 21,073.00 6,400.00 190,226.35 1,940.00 249,608.65 43.50% TOTAL MISC & PROJECTS 441,775 21,073.00 6,400.00 190,226.35 1,940.00 249,608.65 0.00% FM3009 ROAD&BRIDGE EXPANSION Maintenance Services - - 20,825.51 - - - 0.00% TOTAL FM3009 RD&BRIDGE EXPANSION - - 20,825.51 - - - 0.00% TOTAL EXPENDITURES 2,659,502 59,114.61 908,836.37 883,576.60 32,080.00 1,743,845.40 34.43% ** REVENUE OVER(UNDER) EXPEND 869,060 294,245.04 1,674,363.86 1,796,807.41 (32,080.00) (895,667.41) C I T Y O F S C H E R T Z ***************************************************** 2 0 1 5 - 2 0 1 6 ***************************************************** REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2016 60 Cash in Bank Claim on Operating Cash Pool-Checking 748,339.20$ Cash in Investments Texas Class Investment-Economic Development Corp 8,212,119.96 Schertz Bank & Trust-Certificate of Deposit 1,054,002.95 Total Cash in Bank & Investments 10,014,462.11$ CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2016 SED CORPORATION 61 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 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 2011-12 214,497 231,818 169,596 207,911 230,700 182,541 173,698 267,965 199,040 204,426 287,707 220,125 -3.3% 16.6% 4.9% 17.0% -1.6% 17.6% 7.6% -14.9% 22.0% 5.4% $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 4B SALES TAX By Collection Month 62 INVESTMENT REPORT C I T Y O F S C H E R T Z FOR MONTH ENDING JUNE 30th, 2016 63 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,394,403.47 0.0500 5,137,390.23 4,996,508.60 400.24 9,535,685.34 9,535,685.34 9,535,685.34 N/A Schertz Bank & Trust - PEG Fund 504,007.67 0.0000 12,915.40 - - 516,923.07 516,923.07 516,923.07 N/A TOTAL OPERATIONS 9,898,411.14 5,150,305.63 4,996,508.60 400.24 10,052,608.41 10,052,608.41 10,052,608.41 - LOGIC General Fund 9,718,329.25 0.5640 - - 4,504.93 9,722,834.18 9,722,834.18 9,722,834.18 N/A 38 Days G/F-Equipment Replacement 73,915.13 0.5640 - - 34.27 73,949.40 73,949.40 73,949.40 N/A 38 Days G/F-Vehicle Replacement 477,435.59 0.5640 - - 221.32 477,656.91 477,656.91 477,656.91 N/A 38 Days G/F-Air Conditioner Replacement 221,331.71 0.5640 - - 102.61 221,434.32 221,434.32 221,434.32 N/A 38 Days SR2009 Bond-Street Projects(II)870,899.71 0.5640 - - 403.71 871,303.42 871,303.42 871,303.42 N/A 38 Days TOTAL LOGIC 11,361,911.39 - - 5,266.84 11,367,178.23 11,367,178.23 11,367,178.23 - LONESTAR Capital Recovery - Sewer 2,359,906.44 0.5600 - - 1,087.98 2,360,994.42 2,360,994.42 2,360,994.42 N/A 43 Days Capital Recovery - Water 5,211,956.22 0.5600 - - 2,402.84 5,214,359.06 5,214,359.06 5,214,359.06 N/A 43 Days Drainage Fund 808,913.29 0.5600 - - 372.93 809,286.22 809,286.22 809,286.22 N/A 43 Days Facilities Master Plan 25,979.81 0.5600 - - 11.98 25,991.79 25,991.79 25,991.79 N/A 43 Days GO SR2011 Animal Shelter 8,610.43 0.5600 - - 3.97 8,614.40 8,614.40 8,614.40 N/A 43 Days GO SR2011 Soccer Fields 162,208.32 0.5600 - - 74.78 162,283.10 162,283.10 162,283.10 N/A 43 Days GO SR2011 Swimming Pool 3,884,264.29 0.5600 - 800,000.00 1,519.11 3,085,783.40 3,085,783.40 3,085,783.40 N/A 43 Days GO SR2012 Downtown Improvements 981,220.79 0.5600 - - 452.37 981,673.16 981,673.16 981,673.16 N/A 43 Days SE Elevated Water Tank 774,105.89 0.5600 - - 356.88 774,462.77 774,462.77 774,462.77 N/A 43 Days Sewer/CCMA Project 2,846,989.97 0.5600 - - 1,312.53 2,848,302.50 2,848,302.50 2,848,302.50 N/A 43 Days W/S-Customer Deposits 296,530.06 0.5600 - - 136.71 296,666.77 296,666.77 296,666.77 N/A 43 Days W/S-Equipment Repl/Cap.Imp 178,287.79 0.5600 - - 82.20 178,369.99 178,369.99 178,369.99 N/A 43 Days Water&Sewer 1,074,617.22 0.5600 - - 495.43 1,075,112.65 1,075,112.65 1,075,112.65 N/A 43 Days W/S-Vehicle Replacement 257,552.94 0.5600 - - 118.74 257,671.68 257,671.68 257,671.68 N/A 43 Days TOTAL LONESTAR 18,871,143.46 - 800,000.00 8,428.45 18,079,571.91 18,079,571.91 18,079,571.91 - TEXAS CLASS Tax I&S 2,349,945.92 0.6300 - - 1,218.59 2,351,164.51 2,351,164.51 2,351,164.51 N/A 77 Days Police Forfeiture 245,037.28 0.6300 - - 127.06 245,164.34 245,164.34 245,164.34 N/A 77 Days Park Fund 76,525.38 0.6300 - - 39.71 76,565.09 76,565.09 76,565.09 N/A 77 Days Economic Development Corporation 8,207,863.67 0.6300 - - 4,256.29 8,212,119.96 8,212,119.96 8,212,119.96 N/A 77 Days Library Board 45,039.48 0.6300 - - 23.35 45,062.83 45,062.83 45,062.83 N/A 77 Days Tree Mitigation 318,569.19 0.6300 - - 165.20 318,734.39 318,734.39 318,734.39 N/A 77 Days Tax Note 2013 Fire Truck 4,949.94 0.6300 - - 2.59 4,952.53 4,952.53 4,952.53 N/A 77 Days Hotel Tax 701,472.27 0.6300 - - 363.77 701,836.04 701,836.04 701,836.04 N/A 77 Days Special Events Fund 16,852.61 0.6300 - - 8.75 16,861.36 16,861.36 16,861.36 N/A 77 Days Tax Notes 2015 EMS Ambulances 88,900.34 0.6300 - - 46.07 88,946.41 88,946.41 88,946.41 N/A 77 Days Tax Notes 2015 Drainage Equipment 681,858.69 0.6300 - - 353.56 682,212.25 682,212.25 682,212.25 N/A 77 Days Tax Notes 2015 Water Equipment 282,465.87 0.6300 - - 146.48 282,612.35 282,612.35 282,612.35 N/A 77 Days Tax Notes 2015 General Fund Equipment 241,076.77 0.6300 - - 124.99 241,201.76 241,201.76 241,201.76 N/A 77 Days Tax Notes 2015A Fire Trucks & Equip 626.38 0.6300 - - 0.30 626.68 626.68 626.68 N/A 77 Days TOTAL TEXAS CLASS 13,261,183.79 - - 6,876.71 13,268,060.50 13,268,060.50 13,268,060.50 - C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING JUNE 30th, 2016 64 65 TOTAL OPERATIONS 17% TOTAL LOGIC 19% TOTAL LONESTAR 31% TOTAL TEXAS CLASS 23% TOTAL CAPITAL ONE 5% TOTAL C.D.s 5% City Portfolio By Investment Type 66 Operations, $23,301,270.31 Projects, $10,054,013.99 Debt Service Fund, $2,351,164.51 Special Revenue Funds, $21,754,166.51 Designated Funds, $1,572,625.79 City Portfolio By Use 67 0.00 0.50 1.00 1.50 2.00 2.50 3.00 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 1 Month T-Bill 0.0100 0.1100 0.1400 0.2200 0.2300 0.1800 0.1600 0.2700 0.2000 3 Month T-Bill 0.0800 0.2200 0.1600 0.3300 0.3300 0.2100 0.2200 0.3400 0.2600 6 Month T-Bill 0.2300 0.4200 0.4900 0.4300 0.4900 0.3900 0.4000 0.4900 0.3600 Schertz Portfolio 0.3930 0.4204 0.4328 0.5432 0.5913 0.6349 0.6619 0.6313 0.6551 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.7500 0.7500 0.7500 0.8000 0.8000 0.8000 0.8000 0.8000 0.8000 CD 180 Days 0.6000 0.6000 0.3500 0.3500 0.3500 0.3500 0.3500 0.3500 0.6000 LOGIC 0.1635 0.1637 0.2331 0.3922 0.4823 0.5206 0.5439 0.5496 0.5640 LoneStar 0.1900 0.2000 0.2900 0.4100 0.4500 0.5000 0.5300 0.5500 0.5600 MBIA 0.2100 0.2400 0.2900 0.4200 0.4900 0.5400 0.5700 0.5900 0.6300 Capital One 2.6936 2.6959 2.3028 2.2400 2.2891 2.3359 2.3733 1.5805 1.5726 MONTHLY YIELDS 68 C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:6/30/2016 General Fund Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Prime Mmkt Port Fd #690 53,581.20 53,581.20 53,581.20 243.00 0.45 Total Cash & Equivalents 53,581.20 53,581.20 53,581.20 243.00 0.45% Fixed Income Federal Home LN Mtg Corp Medium Term Nts 2/26/2018 606.00 100,000.00 100,000.00 100,061.00 1,100.00 1.10 Federal Natl Mtg Assn 1/30/2017 214.00 100,000.00 102,366.80 100,458.00 1,250.00 1.24 Federal Home LN Mtg Corp Reference Nts 11/17/2017 505.00 100,000.00 109,860.00 106,237.00 5,125.00 4.82 Federal Home LN Mtg Corp Refrnce 8 6/13/2018 713.00 100,000.00 110,756.94 108,099.00 4,875.00 4.51 US Treasury Note 10/15/2017 472.00 140,000.00 139,698.44 140,572.60 1,225.00 0.87 US Treasury Note 11/15/2017 503.00 200,000.00 199,042.97 200,860.00 1,750.00 0.87 US Treasury Note 2/15/2019 960.00 100,000.00 99,753.91 100,199.00 750.00 0.75 US Treasury Note 11/30/2019 1248.00 100,000.00 99,554.69 100,668.00 1,000.00 0.99 US Treasury Note 1/31/2020 1310.00 100,000.00 101,312.50 101,928.00 1,375.00 1.35 US Treasury Note 2/28/2018 608.00 50,000.00 49,585.94 50,138.50 375.00 0.75 US Treasury Note 7/31/2018 761.00 100,000.00 101,359.38 101,588.00 1,375.00 1.35 US Treasury Note 10/31/2018 853.00 100,000.00 101,101.56 101,407.00 1,250.00 1.23 Total Fixed Income 1,290,000.00 1,314,393.13 1,312,216.10 21,450.00 1.63% Total Assets 559.87 1,343,581.20 1,367,974.33 1,365,797.30 21,693.00 1.59% Capital Recovery Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Prime Mmkt Port Fd #690 45,426.42 45,426.42 45,426.42 206.00 0.45 Total Cash & Equivalents 45,426.42 45,426.42 45,426.42 206.00 0.45% Fixed Income Federal Home LN Mtg Corp Medium Term Nts 2/26/2018 606.00 100,000.00 100,000.00 100,061.00 1,100.00 1.10 Federal Natl Mtg Assn 10/26/2017 483.00 125,000.00 124,588.38 125,452.50 1,093.00 0.87 Federal Home LN Mtg Corp Reference Nts 11/17/2017 505.00 100,000.00 109,860.00 106,237.00 5,125.00 4.82 Federal Home Mtg Corp Refrnce 8 6/13/2018 713.00 100,000.00 110,753.60 108,099.00 4,875.00 4.51 Federal Home LN Mtg Corp 3/27/2019 1000.00 100,000.00 108,297.40 108,011.00 3,750.00 3.47 US Treasury Note 3/15/2017 258.00 150,000.00 149,753.91 150,297.00 1,125.00 0.75 US Treasury Note 10/15/2017 472.00 100,000.00 99,644.53 100,409.00 875.00 0.87 US Treasury Note 10/31/2019 1218.00 100,000.00 100,065.85 102,344.00 1,500.00 1.47 US Treasury Note 11/15/2017 503.00 200,000.00 199,042.97 200,860.00 1,750.00 0.87 US Treasury Note 2/15/2019 960.00 100,000.00 99,753.90 100,199.00 750.00 0.75 US Treasury Note 4/30/2021 1765.00 50,000.00 49,970.70 50,866.50 687.00 1.35 US Treasury Note 11/30/2019 1248.00 150,000.00 149,332.03 151,002.00 1,500.00 0.99 US Treasury Note 1/31/2020 1310.00 50,000.00 50,656.25 50,964.00 687.00 1.35 US Treasury Note 2/28/2018 608.00 100,000.00 99,175.78 100,277.00 750.00 0.75 US Treasury Note 7/15/2016 15.00 50,000.00 49,954.53 50,009.00 312.00 0.62 US Treasury Note 10/31/2018 853.00 100,000.00 101,101.56 101,407.00 1,250.00 1.23 Total Fixed Income 1,675,000.00 1,701,951.39 1,706,495.00 27,129.00 1.59% Total Assets 718.31 1,720,426.42 1,747,377.81 1,751,921.42 27,335.00 1.56% 69