Loading...
09-JUNE 2015 FINANCIAL STATEMENT JUNE 2015 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department DECEMBER 24, 2015 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 16,700,082 803,641.73 13,450,527.56 14,546,469.24 - 2,153,612.76 87.10% Franchises 1,986,159 186,937.60 1,258,285.06 1,531,685.20 - 454,473.80 77.12% Permits 1,175,803 135,557.50 1,052,269.82 1,036,701.20 - 139,101.80 88.17% Licenses 91,229 6,285.00 66,695.00 61,735.00 - 29,494.00 67.67% Fees 2,814,366 223,808.52 2,172,978.21 1,955,306.95 125.00 858,934.05 69.48% Fines 31,000 3,634.43 23,193.56 22,779.72 (4.99) 8,225.27 73.47% Inter-Jurisdictional 720,892 56,635.15 455,406.65 551,677.22 - 169,214.78 76.53% Fund Transfers 1,835,754 141,042.08 1,314,871.47 1,269,378.72 - 566,375.28 69.15% Miscellaneous 462,650 78,456.16 337,101.38 320,292.11 - 142,357.89 69.23% TOTAL REVENUES 25,817,935 1,635,998.17 20,131,328.71 21,296,025.36 120.01 4,521,789.63 82.49% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 23,575 1,813.46 17,481.32 16,651.44 - 6,923.56 70.63% Supplies 1,800 213.00 476.41 514.87 - 1,285.13 28.60% City Support Services 40,600 281.66 40,537.64 29,069.24 173.08 11,357.68 72.03% Operations Support 400 52.98 60.69 219.93 - 180.07 54.98% Staff Support 21,300 - 12,784.78 10,256.18 592.37 10,451.45 50.93% TOTAL CITY COUNCIL 87,675 2,361.10 71,340.84 56,711.66 765.45 30,197.89 65.56% CITY MANAGER Personnel Services 833,454 64,172.13 671,094.82 599,636.20 - 233,817.80 71.95% Supplies 3,000 72.84 2,448.26 2,199.03 273.88 527.09 82.43% City Support Services 2,540 - 1,762.50 2,535.46 - 4.54 99.82% Staff Support 28,480 1,256.20 13,539.56 12,587.91 5,094.12 10,797.97 62.09% Operating Equipment 725 724.91 - 1,449.82 - (724.82) 199.98% TOTAL CITY MANAGER 868,199 66,226.08 688,845.14 618,408.42 5,368.00 244,422.58 71.85% *************************************************** 2 0 1 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 MUNICIPAL COURT Personnel Services 301,231 20,643.68 209,027.45 191,713.37 - 109,517.63 63.64% Supplies 3,500 - 1,051.38 729.24 151.68 2,619.08 25.17% City Support Services 1,000 - - - - 1,000.00 0.00% Operations Support 4,500 - 1,131.00 1,928.00 - 2,572.00 42.84% Staff Support 7,710 423.02 4,159.40 1,818.95 777.30 5,113.75 33.67% Court Support 560 - - 210.00 - 350.00 37.50% Professional Services 68,340 3,427.50 40,217.65 33,735.00 - 34,605.00 49.36% Maintenance Services 2,800 150.00 1,550.00 1,250.00 550.00 1,000.00 64.29% Operating Equipment 800 262.94 37.27 280.70 - 519.30 35.09% TOTAL MUNICIPAL COURT 390,441 24,907.14 257,174.15 231,665.26 1,478.98 157,296.76 59.71% CUSTOMER RELATIONS-311 Personnel Services 113,241 8,441.61 80,231.27 73,326.19 - 39,914.81 64.75% Supplies 200 - 121.35 164.70 - 35.30 82.35% Staff Support 750 95.48 171.00 453.48 - 296.52 60.46% Operating Equipment 500 - - - - 500.00 0.00% TOTAL CUSTOMER RELATIONS-311 114,691 8,537.09 80,523.62 73,944.37 - 40,746.63 64.47% PLANNING & ZONING Personnel Services 133,705 10,136.18 90,828.22 92,911.27 - 40,793.73 69.49% Supplies 4,875 27.50 648.40 1,289.85 - 3,585.15 26.46% Operations Support 99 - - 31.48 - 67.52 31.80% Staff Support 18,580 598.08 430.18 7,319.53 125.00 11,135.47 40.07% Professional Services 82 - 21.00 66.00 - 16.00 80.49% Operating Equipment 486 486.00 - 486.00 - - 100.00% TOTAL PLANNING & ZONING 157,827 11,247.76 91,927.80 102,104.13 125.00 55,597.87 64.77% LEGAL SERVICES Operations Support 10,000 - 3,831.04 4,551.29 84.76 5,363.95 46.36% Professional Services 350,000 16,856.93 206,346.15 128,861.68 - 221,138.32 36.82% TOTAL LEGAL SERVICES 360,000 16,856.93 210,177.19 133,412.97 84.76 226,502.27 37.08% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 GENERAL SERVICES Personnel Services 590,190 41,650.67 398,018.22 417,849.62 14,167.33 158,173.05 73.20% Supplies 60,004 5,144.94 39,385.78 36,097.84 4,190.62 19,715.54 67.14% Utility Services 99,880 6,922.66 60,644.16 60,215.29 - 39,664.71 60.29% Staff Support 11,749 666.21 6,886.40 6,174.81 856.15 4,718.04 59.84% Maintenance Services 31,900 1,456.00 13,274.85 26,534.65 273.89 5,091.46 84.04% Rental/Leasing 421 - - 420.75 - 0.25 99.94% Operating Equipment 10,800 - 9,807.24 0.49 3,360.00 7,439.51 31.12% TOTAL GENERAL SERVICES 804,944 55,840.48 528,016.65 547,293.45 22,847.99 234,802.56 70.83% BUILDING 6-8 MAINTENANCE Supplies 25,250 4,730.43 20,566.34 17,575.41 3,674.79 3,999.80 84.16% Utility Services 89,235 6,055.78 49,700.22 45,981.89 - 43,253.11 51.53% Maintenance Services 63,700 1,593.99 38,428.33 38,167.42 8,360.24 17,172.34 73.04% Operating Equipment 23,000 - 14,358.00 - 22,027.00 973.00 95.77% TOTAL BUILDING 6-8 MAINTENANCE 201,185 12,380.20 123,052.89 101,724.72 34,062.03 65,398.25 67.49% CITY SECRETARY Personnel Services 167,772 12,791.35 115,508.45 118,855.10 - 48,916.90 70.84% Supplies 1,200 83.25 423.14 577.16 23.70 599.14 50.07% City Support Services 9,700 - 9,576.38 2,638.27 - 7,061.73 27.20% Operations Support 150 - 50.00 - - 150.00 0.00% Staff Support 8,795 477.74 3,530.06 2,885.49 790.00 5,119.51 41.79% TOTAL CITY SECRETARY 187,617 13,352.34 129,088.03 124,956.02 813.70 61,847.28 67.04% NON-DEPARTMENTAL City Support Services 511,427 41,074.22 271,367.04 295,922.48 2,200.00 213,304.52 58.29% Operations Support 141,500 4,686.64 96,007.52 78,465.42 2,036.14 60,998.44 56.89% Staff Support 150 - 140.08 80.00 - 70.00 53.33% City Assistance 1,243,779 - 794,592.65 921,017.51 116,422.02 206,339.47 83.41% Professional Services 222,400 19,258.51 3,766.98 81,812.42 57,512.50 83,075.08 62.65% Fund Chrgs/Transfrs-Spec Events Fnd 572,800 - - - - 572,800.00 0.00% Operating Equipment 54,465 251.12 1,955.00 4,901.67 - 49,563.33 9.00% TOTAL NON-DEPARTMENTAL 2,746,521 65,270.49 1,167,829.27 1,382,199.50 178,170.66 1,186,150.84 56.81% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 PUBLIC AFFAIRS Personnel Services 257,970 19,360.09 136,746.15 171,064.14 - 86,905.86 66.31% Supplies 3,500 258.62 1,898.15 2,775.16 37.92 686.92 80.37% Operations Support 25,341 - 9,065.03 10,016.37 - 15,324.63 39.53% Staff Support 5,209 1,239.69 2,664.33 2,700.21 390.06 2,118.73 59.33% Professional Services 13,500 - 4,290.00 589.00 - 12,911.00 4.36% Operating Equipment 2,700 - 99.99 1,921.82 - 778.18 71.18% TOTAL PUBLIC AFFAIRS 308,220 20,858.40 154,763.65 189,066.70 427.98 118,725.32 61.48% RECORDS MANAGEMENT Personnel Services 52,174 3,809.78 35,175.97 36,206.42 - 15,967.58 69.40% Supplies 400 5.38 107.77 187.82 - 212.18 46.96% Staff Support 1,750 10.87 1,064.14 1,150.74 - 599.26 65.76% Professional Services 10,000 549.50 2,989.50 6,668.00 70.00 3,262.00 67.38% Operating Equipment - - - - 83.77 (83.77) 0.00% TOTAL RECORDS MANAGEMENT 64,324 4,375.53 39,337.38 44,212.98 153.77 19,957.25 68.97% SCHERTZ MAGAZINE Personnel Services 137,208 10,646.77 95,292.41 97,740.54 - 39,467.46 71.24% Supplies 200 - 73.94 74.00 49.99 76.01 62.00% Opperations Support 100 - - - - 100.00 0.00% Staff Support 3,000 757.53 808.06 1,464.53 38.97 1,496.50 50.12% Professional Services 253,500 19,362.47 147,634.56 156,432.66 8,431.20 88,636.14 65.04% Fund Charges/Transfers 10,000 - - - - 10,000.00 0.00% Operating Equipment 600 - 455.00 - - 600.00 0.00% TOTAL SCHERTZ MAGAZINE 404,608 30,766.77 244,263.97 255,711.73 8,520.16 140,376.11 65.31% ENGINEERING Personnel Services 187,058 14,621.16 117,489.46 130,617.25 - 56,440.75 69.83% Supplies 1,300 - 567.18 567.02 116.93 616.05 52.61% City Support Services 1,500 - 262.80 262.80 - 1,237.20 17.52% Utility Services 1,498 50.95 523.76 241.30 - 1,256.70 16.11% Staff Support 10,512 274.00 936.29 456.35 346.37 9,709.28 7.64% Professional Services 38,800 - 11,671.25 3,410.00 2,740.00 32,650.00 15.85% Operating Equipment 600 - 2,001.75 161.49 - 438.51 26.92% TOTAL ENGINEERING 241,268 14,946.11 133,452.49 135,716.21 3,203.30 102,348.49 57.58% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 GIS Personnel Services 135,495 10,684.54 93,618.69 97,643.83 - 37,851.17 72.06% Supplies 2,910 - 704.61 - - 2,910.00 0.00% Staff Support 5,235 390.50 3,327.40 2,810.40 - 2,424.60 53.68% Rental/Leasing 3,805 - - - - 3,805.00 0.00% Operating Equipment 7,350 - - 3,080.81 - 4,269.19 0.00% TOTAL GIS 154,795 11,075.04 97,650.70 103,535.04 - 51,259.96 66.89% TOTAL GENERAL GOVERNMENT 7,092,315 359,001.46 4,017,443.77 4,100,663.16 256,021.78 2,735,630.06 61.43% PUBLIC SAFETY POLICE Personnel Services 5,149,607 365,500.88 3,439,823.37 3,526,215.95 - 1,623,391.05 68.48% Supplies 47,646 5,126.28 24,373.61 23,159.51 3,470.54 21,015.95 55.89% City Support Services 26,750 - 26,721.66 24,151.52 - 2,598.48 90.29% Utility Services 127,140 7,508.25 85,526.47 54,082.73 230.24 72,827.03 42.72% Operations Support 2,950 610.91 1,424.53 2,007.75 - 942.25 68.06% Staff Support 109,923 16,533.38 57,781.61 69,990.79 3,413.78 36,518.43 66.78% City Assistance 8,723 298.84 5,828.15 3,094.04 1,792.27 3,836.69 56.02% Professional Services 48,058 5,687.59 26,312.35 29,427.85 661.70 17,968.45 62.61% Fund Charges/Transfers - - - - - - 0.00% Maintenance Services 57,632 3,222.80 35,464.15 24,432.81 2,615.80 30,583.39 46.93% Operating Equipment 123,281 4,437.51 85,958.49 55,199.68 42,532.43 25,548.89 79.28% Capital Outlay 228,155 15,133.09 128,505.24 71,794.09 156,009.28 351.63 99.85% TOTAL POLICE 5,929,865 424,059.53 3,917,719.63 3,883,556.72 210,726.04 1,835,582.24 69.05% FIRE RESCUE Personnel Services 2,987,869 223,790.76 1,930,442.54 2,033,201.97 - 954,667.03 68.05% Supplies 17,050 286.44 6,728.40 4,885.69 706.02 11,458.29 32.80% Utility Services 58,700 4,045.61 36,089.31 33,362.35 181.57 25,156.08 57.14% Operations Support 650 - 953.37 134.41 - 515.59 20.68% Staff Support 109,100 9,242.79 61,758.20 45,692.07 17,655.62 45,752.31 58.06% City Assistance 16,200 - - 1,118.52 - 15,081.48 6.90% Professional Services 25,000 - 13,218.00 160.00 9,853.00 14,987.00 40.05% Maintenance Services 62,932 860.00 28,612.61 22,429.92 1,341.30 39,160.78 37.77% Rental/Leasing 14,000 - - - 1,666.94 12,333.06 11.91% Operating Equipment 65,900 302.50 26,804.81 41,567.47 18,432.75 5,899.78 91.05% Capital Outlay 210,600 12,345.00 5,334.15 79,635.00 21,365.00 109,600.00 47.96% TOTAL FIRE RESCUE 3,568,001 250,873.10 2,109,941.39 2,262,187.40 71,202.20 1,234,611.40 65.40% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 INSPECTIONS Personnel Services 512,538 35,954.94 330,057.71 324,857.20 - 187,680.80 63.38% Supplies 3,516 248.37 1,020.17 1,791.00 - 1,725.00 50.94% Utility Services 6,500 288.80 4,475.65 2,488.51 - 4,011.49 38.28% Operations Support 2,000 422.48 729.00 1,338.94 - 661.06 66.95% Staff Support 13,324 1,167.54 3,771.56 5,285.34 225.05 7,813.61 41.36% Professional Services 29,300 2,515.00 45.59 6,132.50 16,000.00 7,167.50 75.54% Operating Equipment 28,668 - 429.99 199.99 467.96 28,000.05 2.33% Capital Outlay - 290.82 - 20,435.82 - (20,435.82) 0.00% TOTAL INSPECTIONS 595,846 40,887.95 340,529.67 362,529.30 16,693.01 216,623.69 63.64% MARSHAL'S OFFICE Personnel Services 583,782 42,421.06 411,830.04 405,437.76 - 178,344.24 69.45% Supplies 6,400 302.96 1,103.67 1,923.42 190.62 4,285.96 33.03% Utility Services 16,000 730.60 6,869.51 4,834.02 - 11,165.98 30.21% Operations Support 3,500 40.56 906.51 655.85 177.00 2,667.15 23.80% Staff Support 14,800 879.49 3,228.70 5,895.51 650.00 8,254.49 44.23% City Assistance 2,500 979.60 - 979.60 - 1,520.40 39.18% Maintenance Services 17,700 480.00 4,031.14 3,418.00 295.20 13,986.80 20.98% Operating Equipment 19,700 - 7,689.47 11,796.87 492.72 7,410.41 62.38% Capital Outlay 8,000 - 28,566.00 - - 8,000.00 0.00% TOTAL MARSHAL'S OFFICE 672,382 45,834.27 464,225.04 434,941.03 1,805.54 235,635.43 64.96% TOTAL PUBLIC SAFETY 10,766,094 761,654.85 6,832,415.73 6,943,214.45 300,426.79 3,522,452.76 67.28% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 PUBLIC ENVIRONMENT STREETS Personnel Services 696,734 53,390.78 483,326.92 489,035.56 - 207,698.44 70.19% Supplies 5,700 1,242.79 4,247.96 4,959.03 56.29 684.68 87.99% Utility Services 136,200 12,055.68 82,718.04 70,237.85 - 65,962.15 51.57% Staff Support 11,805 1,967.40 6,310.26 8,659.11 - 3,145.89 73.35% City Assistance 500 - - - - 500.00 0.00% Professional Services 33,225 2,650.00 - 24,650.00 - 8,575.00 74.19% Maintenance Services 102,500 13,993.85 101,985.75 50,457.16 3,157.55 48,885.29 52.31% Rental/Lease 200 - 414.72 175.00 - 25.00 87.50% Operating Equipment 300 - 44,159.84 237.56 - 62.44 79.19% Capital Outlay 28,000 1,165.49 63,529.00 25,985.49 - 2,014.51 92.81% TOTAL STREETS 1,015,164 86,465.99 786,692.49 674,396.76 3,213.84 337,553.40 66.75% TOTAL PUBLIC ENVIRONMENT 1,015,164 86,465.99 786,692.49 674,396.76 3,213.84 337,553.40 66.75% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 470,301 29,753.37 342,965.26 293,418.97 - 176,882.03 62.39% Supplies 41,905 6,485.25 18,069.45 28,972.07 1,771.29 11,161.64 73.36% Utility Services 143,800 10,972.78 81,724.47 112,973.05 559.18 30,267.77 78.95% Operations Support 250 876.00 - 876.00 - (626.00) 350.40% Staff Support 8,473 727.92 5,120.43 6,515.66 914.94 1,042.40 87.70% Professional Services 72,000 5,367.00 18,800.21 20,305.80 3,691.50 48,002.70 33.33% Maintenance Services 20,000 1,083.69 7,256.49 16,730.06 513.04 2,756.90 86.22% Rental/Leasing 39,600 1,541.26 32,159.97 27,988.33 9,057.48 2,554.19 93.55% Operating Equipment 2,000 - 1,043.45 1,648.92 344.25 6.83 99.66% Capital Outlay 60,000 44,995.50 - 54,134.82 5,660.23 204.95 99.66% TOTAL PARKS DEPARTMENT 858,329 101,802.77 507,139.73 563,563.68 22,511.91 272,253.41 68.28% SWIM POOL Supplies 20,700 6,141.73 9,400.01 11,254.40 3,275.30 6,170.30 70.19% Utility Services 29,000 1,282.78 10,464.42 9,786.35 359.76 18,853.89 34.99% Maintenance Services 203,378 1,038.00 61,567.91 4,275.44 62,468.27 136,634.29 32.82% TOTAL SWIM POOL 253,078 8,462.51 81,432.34 25,316.19 66,103.33 161,658.48 36.12% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 EVENT FACILITIES Personnel Services 58,642 4,287.92 38,220.24 39,302.22 - 19,339.78 67.02% Supplies 15,400 948.44 9,780.90 9,085.17 931.99 5,382.84 65.05% Utility Services 51,400 3,841.24 28,947.77 30,213.56 - 21,186.44 58.78% Operations Support 22,411 500.00 9,994.39 14,549.00 - 7,862.00 64.92% Staff Support 2,448 - 1,860.47 1,156.16 - 1,291.84 47.23% Professional Services 500 - 528.45 - - 500.00 0.00% Operating Equipment 5,000 - - 1,098.70 - 3,901.30 21.97% TOTAL EVENT FACILITIES 155,801 9,577.60 89,332.22 95,404.81 931.99 59,464.20 61.83% SENIOR CITIZEN CENTER Supplies 7,650 704.46 4,465.92 4,468.76 455.02 2,726.22 64.36% Utility Services 4,240 - 414.00 216.78 - 4,023.22 5.11% Operations Support 1,500 - - 591.92 - 908.08 39.46% City Assistence 20,000 325.34 12,494.40 7,911.48 156.42 11,932.10 40.34% Professional Services 8,000 300.00 3,966.74 2,977.50 440.00 4,582.50 42.72% Maintenance Services 5,000 - 7,548.20 336.04 125.50 4,538.46 9.23% TOTAL SENIOR CITIZEN CENTER 46,390 1,329.80 28,889.26 16,502.48 1,176.94 28,710.58 38.11% TOTAL PARKS & RECREATION 1,313,598 121,172.68 706,793.55 700,787.16 90,724.17 522,086.67 60.26% CULTURAL LIBRARY Personnel Services 672,828 46,958.02 474,081.49 434,266.97 - 238,561.03 64.54% Supplies 13,500 804.17 7,138.79 10,035.13 799.01 2,665.86 80.25% Utility Services 56,500 3,891.22 28,811.30 28,204.81 - 28,295.19 49.92% Operations Support 3,000 35.59 617.85 516.12 860.00 1,623.88 45.87% Staff Support 6,345 47.58 2,715.76 2,250.34 - 4,094.66 35.47% Professional Services 2,300 - 2,190.00 2,175.00 - 125.00 94.57% Operating Equipment 88,000 5,166.48 53,006.63 68,038.55 10,677.11 9,284.34 89.45% TOTAL LIBRARY 842,473 56,903.06 568,561.82 545,486.92 12,336.12 284,649.96 66.21% TOTAL CULTURAL 842,473 56,903.06 568,561.82 545,486.92 12,336.12 284,649.96 66.21% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 HEALTH ANIMAL SERVICES Personnel Services 306,397 23,152.83 191,036.06 197,471.77 - 108,925.23 64.45% Supplies 34,783 1,809.39 19,603.07 14,248.51 1,455.91 19,078.58 45.15% Utility Services 46,840 2,215.32 13,263.78 22,375.59 359.57 24,104.84 48.54% Operations Support 1,000 516.39 - 516.39 - 483.61 51.64% Staff Support 11,390 90.06 4,572.90 2,447.70 311.63 8,630.67 24.23% City Assistance 17,550 2,027.00 6,441.38 7,526.61 - 10,023.39 42.89% Professional Services 26,500 6,002.50 19,786.78 13,899.80 - 12,600.20 52.45% Maintenance Services 23,200 455.00 3,238.35 6,429.80 - 16,770.20 27.71% Operating Equipment 11,500 - 1,662.44 409.48 1,082.43 10,008.09 12.97% Capital Outlay 24,100 - - - - 24,100.00 0.00% TOTAL ANIMAL SERVICES 503,260 36,268.49 259,604.76 265,325.65 3,209.54 234,724.81 53.36% TOTAL HEALTH 503,260 36,268.49 259,604.76 265,325.65 3,209.54 234,724.81 53.36% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 443,792 33,356.47 296,716.33 291,343.35 - 152,448.65 65.65% Supplies 3,500 154.74 1,548.49 825.15 158.27 2,516.58 28.10% City Support Services 581,743 8,974.88 266,360.93 316,625.23 44,643.20 220,474.57 62.10% Utility Services 253,722 16,386.52 122,311.45 129,327.81 5,519.83 118,874.36 53.15% Operations Support - - - 50.00 - (50.00) 0.00% Staff Support 37,400 4,765.64 20,077.07 21,650.25 836.57 14,913.18 60.13% Maintenance Services 15,600 496.61 7,609.58 7,397.26 1,285.90 6,916.84 55.66% Operating Equipment 291,571 11,112.97 197,989.95 147,314.98 5,902.69 138,353.33 52.55% TOTAL INFORMATION TECHNOLOGY 1,627,328 75,247.83 912,613.80 914,534.03 58,346.46 654,447.51 59.78% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 HUMAN RESOURCES Personnel Services 310,863 13,458.76 209,229.45 194,260.93 - 116,602.07 62.49% Supplies 1,000 - 925.01 485.41 - 514.59 48.54% Human Services 67,000 2,656.64 28,617.33 43,023.61 - 23,976.39 64.21% Operations Support 10,500 299.00 6,991.24 3,150.17 - 7,349.83 30.00% Staff Support 15,120 2,190.00 10,323.13 12,981.75 90.00 2,048.25 86.45% City Assistance 10,000 357.00 2,439.14 6,270.75 - 3,729.25 62.71% Professional Services 9,200 744.75 1,250.00 5,957.50 - 3,242.50 64.76% Operating Equipment - - - - - - 0.00% TOTAL HUMAN RESOURCES 423,683 19,706.15 259,775.30 266,130.12 90.00 157,462.88 62.83% FINANCE Personnel Services 516,715 40,527.25 321,722.02 346,140.46 - 170,574.54 66.99% Supplies 6,750 544.96 1,995.46 4,305.44 480.79 1,963.77 70.91% Operations Support 1,940 - 834.00 3,887.60 - (1,947.60) 200.39% Staff Support 9,815 219.00 5,889.99 2,985.38 2,008.02 4,821.60 50.88% Operating Equipment 900 173.86 - 895.86 - 4.14 99.54% TOTAL FINANCE 536,120 41,465.07 330,441.47 358,214.74 2,488.81 175,416.45 67.28% PURCHASING & ASSET MGT Personnel Services 261,548 18,411.78 181,002.81 144,658.73 - 116,889.27 55.31% Supplies 1,200 108.50 308.26 448.20 226.77 525.03 56.25% City Support Services 800 525.60 - 788.40 - 11.60 98.55% Utility Services 905 10.00 212.63 256.68 32.52 615.80 31.96% Operations Support 300 95.97 - 95.97 - 204.03 31.99% Staff Support 6,165 1,050.00 3,339.38 3,028.71 1,035.83 2,100.46 65.93% Operating Equipment 2,550 - 1,840.63 1,245.00 374.99 930.01 63.53% TOTAL PURCHASING & ASSET MGT 273,468 20,201.85 186,703.71 150,521.69 1,670.11 121,276.20 55.65% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 FLEET SERVICE Personnel Services 313,447 23,838.77 153,395.74 179,414.20 - 134,032.80 57.24% Supplies 174,525 20,616.17 138,783.23 129,538.86 6,594.91 38,391.23 78.00% City Support Services 3,500 - 2,100.00 2,232.24 - 1,267.76 63.78% Utility Services 5,000 329.04 2,902.51 2,504.24 - 2,495.76 50.08% Operations Support 400 - - 75.03 - 324.97 18.76% Staff Support 4,500 488.92 1,883.23 4,517.51 46.49 (64.00) 101.42% City Assistance 180 - - - - 180.00 0.00% Maintenance Services 73,750 14,294.08 68,581.75 65,345.36 455.43 7,949.21 89.22% Rental/Lease 200 - - - - 200.00 0.00% Operating Equipment 8,200 4,904.92 3,188.79 7,037.00 - 1,163.00 85.82% Capital Outlay 65,000 6,496.92 - 40,496.92 - 24,503.08 62.30% TOTAL FLEET SERVICE 648,702 70,968.82 370,835.25 431,161.36 7,096.83 210,443.81 67.56% BUILDING MAINTENANCE Personnel Services 140,150 9,066.14 70,254.71 78,681.32 - 61,468.68 56.14% Supplies 1,043 42.88 203.43 616.84 - 426.16 59.14% Utility Services 2,350 184.67 2,139.02 1,521.45 - 828.55 64.74% Staff Support 2,900 152.24 1,668.13 1,559.75 18.60 1,321.65 54.43% Professional Services 6,240 675.00 7,645.00 675.00 - 5,565.00 10.82% Maintenance Services 93,132 11,417.10 76,233.86 78,270.30 4,177.80 10,683.90 88.53% Rental/Leasing 1,400 - - 296.75 - 1,103.25 21.20% Operating Equipment 5,500 - 3,712.50 1,438.43 - 4,061.57 26.15% Capital Outlay 43,510 - - - 34,674.00 8,836.00 79.69% TOTAL BUILDING MAINTENANCE 296,225 21,538.03 161,856.65 163,059.84 38,870.40 94,294.76 68.17% TOTAL INTERNAL SERVICE 3,805,526 249,127.75 2,222,226.18 2,283,621.78 108,562.61 1,413,341.61 62.86% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 MISC & PROJECTS CITY ASSISTANCE Patient Assistance 5,000 - 5,000.00 5,000.00 - - 100.00% Transportation Assistance 31,678 - 22,020.00 31,678.00 - - 100.00% Children's Advocacy Assistance 5,000 - - - - 5,000.00 0.00% Senior Citizen's Hot Meals 45,000 - 55,628.00 - - 45,000.00 0.00% TOTAL CITY ASSISTANCE 86,678 - 82,648.00 36,678.00 - 50,000.00 42.32% COURT - RESTRICTED FUNDS Fund Charges/Transfers - - - - - - 0.00% Operating Equipment 85,872 - 840.00 - 1,840.00 84,032.00 2.14% TOTAL CITY ASSISTANCE 85,872 - 840.00 - 1,840.00 84,032.00 2.14% TOTAL MISC & PROJECTS 172,550 - 83,488 36,678 1,840 134,032.00 22.32% TOTAL EXPENDITURES 25,510,980 1,670,594.28 15,477,226.30 15,550,173.88 776,334.85 9,184,471.27 64.00% REVENUE OVER(UNDER) EXPEND.306,955 5,745,851.48 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 9,222,912 30,488.26 8,010,382.92 9,304,863.43 - (81,951.43) 100.89% 000-411200 Advalorem Tax - Delinquent 50,000 4,797.02 22,521.93 33,459.21 - 16,540.79 66.92% 000-411300 Advalorem Tax - P&I 50,000 5,475.23 36,816.94 34,706.94 - 15,293.06 69.41% 000-411500 Sales Tax Revenue-Gen Fund 7,346,170 762,881.22 5,351,126.18 5,141,377.75 - 2,204,792.25 69.99% 000-411600 Bingo Tax - - 30.62 - - - 0.00% 000-411700 Mixed Beverage Tax 31,000.00 - 29,648.97 32,061.91 - (1,061.91) 103.43% TOTAL Taxes 16,700,082 803,641.73 13,450,527.56 14,546,469.24 - 2,153,612.76 87.10% Franchises 000-421200 Center Point/Entex Energy 87,202 3,264.99 64,532.46 63,638.82 - 23,563.18 72.98% 000-421220 City Public Service 649,940 71,605.68 403,873.46 533,441.53 - 116,498.47 82.08% 000-421240 Guadalupe Valley Elec Co-op 443,320 44,664.32 203,856.10 329,680.23 - 113,639.77 74.37% 000-421250 New Braunfels Utilities 60,697 (10,185.60) 44,173.45 29,366.36 - 31,330.64 48.38% 000-421300 Time Warner-State Franchise 275,000 22,345.03 211,007.03 203,708.37 - 71,291.63 74.08% 000-421460 AT&T Franchise Fee 250,000 40,663.48 186,377.59 223,664.76 - 26,335.24 89.47% 000-421480 Other Telecom Franchise 100,000 - 50,831.02 50,630.39 - 49,369.61 50.63% 000-421500 Solid Waste Franchise Fee 120,000 14,579.70 93,633.95 97,554.74 - 22,445.26 81.30% TOTAL Franchises 1,986,159 186,937.60 1,258,285.06 1,531,685.20 - 454,473.80 77.12% Permits 000-431100 Home Occupation Permit 420 - 525.00 385.00 - 35.00 91.67% 000-431205 Building Permit - Residential 356,476 67,572.00 285,327.00 438,898.00 - (82,422.00) 123.12% 000-431210 Building Permit - Commercial 125,521 7,715.00 228,249.00 100,950.00 - 24,571.00 80.42% 000-431215 Building Permit - General 350,000 19,175.00 283,836.00 179,144.00 - 170,856.00 51.18% 000-431300 Mobile Home Permit 525 50.00 625.00 350.00 - 175.00 66.67% 000-431400 Signs Permit 11,920 1,862.00 5,886.00 6,707.00 - 5,213.00 56.27% 000-431500 Food Establishmnt Permit 48,000 1,935.00 27,190.00 56,580.00 - (8,580.00) 117.88% 000-431600 Garage Sale Permit 10,840 1,221.00 9,359.00 7,772.00 - 3,068.00 71.70% 000-431700 Plumbing Permit 100,851 13,666.50 74,718.80 93,061.40 - 7,789.60 92.28% 000-431750 Electrical Permit 50,000 7,060.00 40,144.50 46,460.00 - 3,540.00 92.92% 000-431800 Mechanical Permit 50,000 8,500.00 38,340.00 48,560.00 - 1,440.00 97.12% 000-431900 Solicitor/Peddler Permit 1,000 790.00 580.00 1,410.00 - (410.00) 141.00% 000-431950 Animal/Pet Permit 2,000 - 1,515.00 1,180.00 - 820.00 59.00% 000-432000 Cert. of Occupancy Prmt 5,250 900.00 5,050.00 6,000.00 - (750.00) 114.29% ************************************************ 2 0 1 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 000-432100 Security Alarm Permit 45,000 3,220.00 27,890.00 29,571.00 - 15,429.00 65.71% 000-432300 Grading/Clearing Permit 3,000 250.00 3,732.52 3,834.80 - (834.80) 127.83% 000-435000 Fire Permit 15,000 1,641.00 19,302.00 15,838.00 - (838.00) 105.59% TOTAL Permits 1,175,803 135,557.50 1,052,269.82 1,036,701.20 - 139,101.80 88.17% Licenses 000-441000 Alcohol Beverage License 7,000 120.00 5,185.00 4,415.00 - 2,585.00 63.07% 000-441300 Mobile Home License 160 - 160.00 160.00 - - 100.00% 000-442000 Contractors License 79,569 5,765.00 58,610.00 54,555.00 - 25,014.00 68.56% 000-444000 Pet License 4,500 400.00 2,740.00 2,605.00 - 1,895.00 57.89% TOTAL Licenses 91,229 6,285.00 66,695.00 61,735.00 - 29,494.00 67.67% Fees 000-451000 Municipal Court Fines 1,300,000 83,263.30 966,646.78 818,648.70 - 481,351.30 62.97% 000-451100 Arrest Fee 56,534 3,349.27 39,348.32 34,193.10 - 22,340.90 60.48% 000-451110 Expunction Fee 120 - - 60.00 - 60.00 50.00% 000-451200 Warrant Fees 150,000 10,000.00 105,400.09 93,515.26 - 56,484.74 62.34% 000-451210 Court - Claims & Judgements - - - 219.00 - (219.00) 0.00% 000-451320 Civil Justice Fee-Court 34 - 18.40 - - 34.00 0.00% 000-451321 Civil Justice Fee-State 288 - 165.94 - - 288.00 0.00% 000-451340 Judicial Fee - City 7,567 456.93 5,259.23 4,564.81 - 3,002.19 60.33% 000-451400 Traffic Fine Costs TTL 28,060 1,691.05 19,490.79 17,403.61 - 10,656.39 62.02% 000-451500 Teen Court Admin Fee 200 - 40.00 - - 200.00 0.00% 000-451510 Juvenile Case Mgmt Fee 63,062 3,807.57 43,836.88 38,055.49 - 25,006.51 60.35% 000-451520 Truancy Fee 4,586 672.86 3,802.34 6,658.17 (2,072.17) 145.18% 000-451600 Technology Fund Fee 50,872 1,706.42 35,317.48 29,137.19 - 21,734.81 57.28% 000-451700 Security Fee 38,160 2,282.58 26,488.09 23,016.91 - 15,143.09 60.32% 000-451800 Time Payment Fee - City 8,122 476.68 5,258.18 4,567.87 - 3,554.13 56.24% 000-451850 State Fines 10% Service Fee 90,736 - 52,265.58 46,358.96 - 44,377.04 51.09% 000-451900 DPS Payment - Local 12,053 785.34 8,266.69 7,048.99 - 5,004.01 58.48% 000-452000 Child Safety Fee 23,570 1,119.16 15,631.30 21,607.92 - 1,962.08 91.68% 000-452050 Indigent Defense Fee 8,852 - 5,099.02 - - 8,852.00 0.00% 000-452100 Platting Fees 47,500 3,500.00 40,250.00 42,500.00 - 5,000.00 89.47% 000-452200 Site Plan Fee 30,000 500.00 15,500.00 14,000.00 - 16,000.00 46.67% 000-452300 Plan Check Fee 400,000 48,984.50 395,972.50 359,320.50 - 40,679.50 89.83% 000-452310 Miscellaneous Review Fee 1,200 - 3,000.00 300.00 - 900.00 25.00% 000-452320 Tree Mitigation Admin Fee 10,000 1,755.00 40,192.50 33,547.50 - (23,547.50) 335.48% 000-452400 BOA/Zoning Fees 5,000 500.00 4,000.00 4,000.00 - 1,000.00 80.00% 000-452500 Food Handler Class 20,000 880.00 12,450.00 8,840.00 - 11,160.00 44.20% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 000-452520 Fire Training Classes 500 - - - - 500.00 0.00% 000-452600 Specific Use/Zone Chng Fee 25,800 - 11,450.00 - - 25,800.00 0.00% 000-452710 Zoning Ltr & Dev Rights 1,050 - 450.00 1,350.00 - (300.00) 128.57% 000-453100 Reinspection Fees 26,900 1,491.00 25,370.98 27,636.00 - (736.00) 102.74% 000-453110 Swim Pool Inspection Fee 1,800 2,310.00 2,275.00 2,530.00 - (730.00) 140.56% 000-453200 Lot Abatement 7,000 517.50 6,181.42 1,210.00 - 5,790.00 17.29% 000-453211 Admin Fee-Inspections 6,600 1,000.00 6,992.65 5,200.00 - 1,400.00 78.79% 000-453310 Misc Inspection Fee 3,750 - 2,950.00 150.00 - 3,600.00 4.00% 000-453710 Foster Care 900 - 700.00 900.00 - - 100.00% 000-454200 Pool Gate Admission Fee 23,200 8,145.75 9,594.50 8,296.75 - 14,903.25 35.76% 000-454300 Seasonal Pool Pass Fee 4,900 4,986.10 5,293.15 5,266.10 - (366.10) 107.47% 000-456110 Senior Center Memberships 2,000 663.00 1,650.32 10,947.60 - (8,947.60) 547.38% 000-456120 Senior Center Meal Fee 16,000 - 5,880.00 5,905.61 - 10,094.39 36.91% 000-456500 Haz Mat Fees 12,000 - 810.35 - - 12,000.00 0.00% 000-456600 Fire Re-inspection Fee 750 - 700.00 850.00 - (100.00) 113.33% 000-458100 Sale of Merchandise - - 210.00 - - - 0.00% 000-458110 Sale of Merchandise-GovDeal 5,000 699.01 11,339.01 4,437.97 - 562.03 88.76% 000-458300 Sale of Property/Auction 2,000 - 16.82 1,968.75 - 31.25 98.44% 000-458400 Civic Center Rental Fees 142,000 22,116.00 125,788.00 136,763.50 125.00 5,111.50 96.40% 000-458401 Capital Recovery Fee-Civic Cntr 5,500 2,060.00 5,440.00 9,205.00 - (3,705.00) 167.36% 000-458450 North Center Rental Fees 21,000 1,660.00 16,947.00 16,415.75 - 4,584.25 78.17% 000-458460 Senior Center Rental 7,000 1,950.00 5,839.00 19,852.00 - (12,852.00) 283.60% 000-458500 Community Center Rental Fees 26,000 3,726.00 17,830.07 22,687.53 - 3,312.47 87.26% 000-458550 Pavilion Rental Fees 17,500 1,847.50 13,032.50 12,545.00 - 4,955.00 71.69% 000-458560 Chamber of Comm rent 7,800 - 5,850.00 5,850.00 - 1,950.00 75.00% 000-458570 Non-Resident SYSA League 8,000 - - - - 8,000.00 0.00% 000-458650 NonResident User Fee-BVYA 9,500 - 9,140.00 2,740.00 - 6,760.00 28.84% 000-458660 BVYA Utility Reimbursement 12,500 - 6,571.32 5,100.50 - 7,399.50 40.80% 000-458670 SYSA Utility Reimbursement 1,500 - - - - 1,500.00 0.00% 000-458675 Lions Futbol Utility Reimbursement 14,000 2,344.00 2,700.00 12,180.00 - 1,820.00 87.00% 000-458680 Tournament Fees-Soccer 500 - - - - 500.00 0.00% 000-458700 Vehicle Impoundment 8,000 690.00 5,490.00 7,330.00 - 670.00 91.63% 000-459200 NSF Check Fee 500 - 195.00 50.00 - 450.00 10.00% 000-459300 Notary Fee 300 18.00 204.00 132.00 - 168.00 44.00% 000-459400 Maps, Copies, UDC, & Misc F 100 15.00 89.70 75.00 - 25.00 75.00% 000-459600 Animal Adoption Fee 16,000 895.00 8,360.00 8,208.01 - 7,791.99 51.30% 000-459700 Pet Impoundment Fee 14,000 422.00 10,032.01 7,687.00 - 6,313.00 54.91% 000-459800 Police Reports Fee 6,000 522.00 3,905.30 4,272.90 - 1,727.10 71.22% TOTAL Fees 2,814,366 223,808.52 2,172,978.21 1,955,306.95 125.00 858,934.05 69.48% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 Fines 000-463000 Library Fines 31,000 3,634.43 23,193.56 22,779.72 (4.99) 8,225.27 73.47% TOTAL Fines 31,000 3,634.43 23,193.56 22,779.72 (4.99) 8,225.27 73.47% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,072 - 7,025.92 7,025.92 - 14,046.08 33.34% 000-473200 City of Seguin - Fire Contract 30,000 2,435.90 21,923.10 21,923.10 - 8,076.90 73.08% 000-473300 Guad Co - Library 208,000 17,662.83 156,257.19 158,965.47 - 49,034.53 76.43% 000-473400 Randolph AFB-Animal Cntrl 1,500 200.00 1,100.00 500.00 - 1,000.00 33.33% 000-474200 Library Services - Cibolo 25,000 30,000.00 - 30,000.00 - (5,000.00) 120.00% 000-474210 Library Services-Selma 28,220 - 28,220.00 30,544.00 - (2,324.00) 108.24% 000-474400 Dispatch Service - Cibolo 160,000 - 66,652.50 80,000.00 - 80,000.00 50.00% 000-474600 School Crossing Guard-Bexar 40,000 3,203.30 27,544.18 28,586.51 - 11,413.49 71.47% 000-474610 School Cross Guard-Guadalupe 38,000 3,133.12 27,627.21 27,588.56 - 10,411.44 72.60% 000-474620 School Crossing Guard-Comal 1,500 - 1,456.55 1,543.66 - (43.66) 102.91% 000-474700 School Officer Funding 155,100 - 117,600.00 165,000.00 - (9,900.00) 106.38% 000-474750 Crime Victim Liaison Agreement 12,500 - - - - 12,500.00 0.00% TOTAL Inter-Jurisdictional 720,892 56,635.15 455,406.65 551,677.22 - 169,214.78 76.53% Fund Transfers 000-480000 Indirect Costs - EMS 136,087 11,340.58 102,778.47 102,065.22 - 34,021.78 75.00% 000-480100 Indirect Costs - Hotel/Motel 66,405 5,533.75 109,038.78 49,803.75 - 16,601.25 75.00% 000-482150 Transfer From Court Security 27,249 - - - - 27,249.00 0.00% 000-485000 Interfund Charge-Drainage 57,130 4,760.83 38,850.03 42,847.47 - 14,282.53 75.00% 000-486000 Interfund Chrges-Admin W&S 1,152,350 96,029.17 864,262.53 864,262.53 - 288,087.47 75.00% 000-487000 Interfund Charges-Fleet 180,237 15,019.75 97,757.91 135,177.75 - 45,059.25 75.00% 000-488000 Interfund Charges-4B 100,296 8,358.00 102,183.75 75,222.00 - 25,074.00 75.00% 000-489000 Transfer In 116,000 - - - - 116,000.00 0.00% TOTAL Fund Transfers 1,835,754 141,042.08 1,314,871.47 1,269,378.72 - 566,375.28 69.15% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 Miscellaneous 000-491000 Interest Earned 550 19.45 387.26 442.01 - 107.99 80.37% 000-491200 Investment Income 26,000 2,685.40 20,214.77 20,534.51 - 5,465.49 78.98% 000-491800 Gain/Loss - (3,790.61) (17,122.84) (4,400.01) - 4,400.01 0.00% 000-491900 Unrealized Gain/Loss (20,000) 3,196.72 7,983.00 497.85 - (20,497.85) 0.00% 000-492100 Proceeds-Sale of Land - - - 10,000.00 - (10,000.00) 0.00% 000-493120 Donations-Public Library 5,000 - 7,250.90 1,634.75 - 3,365.25 32.70% 000-493400 Donation - Animal Control 1,000 35.00 837.97 412.50 - 587.50 41.25% 000-493401 Donations-A/C Microchip 1,400 225.00 945.00 905.00 - 495.00 64.64% 000-493402 Donations-Spay&Neuter 10,000 686.50 6,986.00 7,781.50 - 2,218.50 77.82% 000-493403 Donations-Animal Adoption Trailer 9,000 480.00 2,000.00 9,145.52 - (145.52) 101.62% 000-493460 Donations-Parks - - - 500.00 - (500.00) 0.00% 000-493465 Donations-Senior Center 12,000 594.53 21,516.01 4,518.88 - 7,481.12 37.66% 000-493502 Donations-PD - - 2,400.00 500.00 - (500.00) 0.00% 000-493618 Donations-Veteran's Memorial - 900.00 - 2,250.00 - (2,250.00) 0.00% 000-494481 LawEnforcemtOfficersStnd&Ed - 3,931.29 3,878.26 - (3,878.26) 0.00% 000-494482 Grants - Police, Fire, Gen Fund - - 4,678.85 - - - 0.00% 000-495060 Grant-Wellmed/Senior Center 3,500 - - - - 3,500.00 0.00% 000-495100 Mobile Stage Rental Fees 2,000 - 1,550.00 - - 2,000.00 0.00% 000-497000 Misc Income-Gen Fund 20,000 37,837.92 15,124.40 (15,219.78) - 35,219.78 -76.10% 000-497005 Schertz Magazine Advertising 220,000 28,550.00 170,175.00 201,465.00 - 18,535.00 91.58% 000-497100 Misc Income-Police 15,000 734.00 (1,803.60) 5,499.40 - 9,500.60 36.66% 000-497200 Misc Income-Library 4,000 497.35 3,462.89 4,436.70 - (436.70) 110.92% 000-497210 Misc Income-Library Copier 14,000 1,867.50 10,500.20 14,455.17 - (455.17) 103.25% 000-497300 Misc Income-Animal Control - - - 10.00 - (10.00) 0.00% 000-497400 Misc Income-Streets Dept.18,000 2,800.78 25,568.70 14,732.85 - 3,267.15 81.85% 000-497500 Misc Income-TML Insurance 20,000 - 4,842.50 - - 20,000.00 0.00% 000-497550 Misc Income-TML Reimbursemt 20,000 - 19,664.05 3,503.99 - 16,496.01 17.52% 000-497600 Misc Income-Vending Mach.2,000 192.22 1,507.40 1,723.67 - 276.33 86.18% 000-498000 Reimbursmnt-Gen Fund 60,000 944.40 10,242.98 17,085.27 - 42,914.73 28.48% 000-498100 Reimbursmnt Fire - Training 1,000 - 3,206.67 - - 1,000.00 0.00% 000-498105 Reimburmnt Police - DEA 6,200 - 3,420.36 6,999.07 - (799.07) 112.89% 000-498107 Reimburmnt Police - Event 7,000 - 3,500.00 7,000.00 - - 100.00% 000-498110 Reimbursmnt Fire - Emg. Acti-O 5,000 - 4,131.62 - - 5,000.00 0.00% TOTAL Miscellaneous 462,650 78,456.16 337,101.38 320,292.11 - 142,357.89 69.23% TOTAL REVENUES 25,817,935 1,635,998.17 20,131,328.71 21,296,025.36 120.01 4,521,789.63 82.49% 17 Cash in Bank Claim on Operating Cash Pool-Checking 890,159.07$ Cash in Investments LOGIC Investment-General Fund 9,043,313.70 LOGIC Investment-Equip Replacement 73,702.86 LOGIC Investment-Veh Replacement 306,887.13 LOGIC Investment-Air Condi Replacment 196,215.00 CAPITAL ONE Investment-General Fund 1,354,092.57 Total Cash in Bank & Investments 12,010,952.17$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2015 GENERAL FUND 18 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014-15 357,436 356,940 4,463,962 2,741,991 1,198,153 85,775 44,720 25,398 30,488 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 2010-11 1,406,160 244,255 2,331,487 1,725,242 735,329 174,687 37,341 43,108 15,120 26,143 13,773 5,356 ADVALOREM TAX 19 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014-15 495,499 638,904 505,026 421,339 795,382 450,965 494,050 723,404 465,966 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 439,433 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,995 463,636 339,192 415,822 461,400 365,083 347,395 535,930 398,080 408,851 575,414 440,250 2010-11 339,709 332,264 347,605 353,229 470,399 324,575 283,300 425,848 408,664 342,513 453,063 385,230 2009-10 300,384 338,514 281,259 288,350 477,063 293,178 273,874 366,704 350,314 324,169 419,127 402,804 3% -3% -9% 1% 9% -8% -9% -7% -33% $- $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 2014-15 215,257 172,814 172,628 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 2010-11 83,433 62,692 67,561 95,887 $- $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 106,125.00 - - - - 106,125.00 0.00% Wilenchik Walk for Life 25,000.00 - 23,464.72 13,925.54 - 11,074.46 55.70% Hal Baldwin Scholarship 18,750.00 - 23,612.00 18,802.00 - (52.00) 0.00% Miscellaneous 3,925.00 2.03 7,033.11 1,619.30 - 2,305.70 41.26% TOTAL REVENUES 153,800.00 2.03 54,109.83 34,346.84 - 119,453.16 15.22% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 10,850.00 - - - - 10,850.00 0.00% TOTAL GENERAL GOVERNMENT 10,850.00 - - - - 10,850.00 0.00% CULTURAL Festival of Angels 15,000.00 - 10,283.94 11,556.53 - 3,443.47 77.04% Employee Appreciation Event 15,000.00 5,652.67 11,510.21 11,155.79 - 3,844.21 74.37% National Night Out 200.00 - - - - 200.00 0.00% Wilenchik Walk for Life 25,000.00 - 4,762.00 13,925.54 - 11,074.46 55.70% Schertz Sweetheart 35,000.00 1,283.59 28,554.64 14,756.01 91.33 20,152.66 42.42% Jazzfest 20,000.00 - 14,504.83 20,020.00 - (20.00) 100.10% Hal Baldwin Scholarship 18,750.00 4,000.00 8,730.20 12,309.68 16.00 6,424.32 65.74% Other Events 14,000.00 (380.36) 52,877.26 5,283.10 300.00 8,416.90 39.88% TOTAL CULTURAL 142,950.00 10,555.90 131,223.08 89,006.65 407.33 53,536.02 62.55% TOTAL EXPENDITURES 153,800.00 10,555.90 131,223.08 89,006.65 407.33 64,386.02 58.14% REVENUE OVER(UNDER) EXPEND - (54,659.81) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 ************************************************** 2 0 1 4 - 2 0 1 5 ************************************************** 22 Cash in Bank Claim on Operating Cash Pool-Checking 15,325.76$ Cash in Investments Texas Class- Special Events 16,798.18 Total Cash in Bank & Investments 32,123.94$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2015 SPECIAL EVENTS FUND 23 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 119,572.00 14,047.92 70,794.59 77,541.62 - 42,030.38 64.85% Fund Transfers 109,428.00 - - - - 109,428.00 0.00% Miscellaneous - - - 2.00 - (2.00) 0.00% TOTAL REVENUES 229,000.00 14,047.92 70,794.59 77,543.62 - 151,456.38 33.86% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 229,000.00 3,170.49 51,893.44 68,280.77 2,762.70 157,956.53 31.02% TOTAL GENERAL GOVERNMENT 229,000.00 3,170.49 51,893.44 68,280.77 2,762.70 157,956.53 31.02% MISC & PROJECTS Projects - - - 1,835.38 620.98 (2,456.36) 0.00% TOTAL MISC & PROJECTS - - - 1,835.38 620.98 (2,456.36) 0.00% TOTAL EXPENDITURES 229,000.00 3,170.49 51,893.44 70,116.15 3,383.68 155,500.17 32.10% REVENUE OVER(UNDER) EXPEND - 7,427.47 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 ************************************************** 2 0 1 4 - 2 0 1 5 ************************************************** 24 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 78,772 4,248.25 39,361.58 38,295.18 - 40,476.82 48.62% 000-421465 AT&T PEG Fee 40,800 9,799.67 31,433.01 39,246.44 - 1,553.56 96.19% TOTAL Franchises 119,572 14,047.92 70,794.59 77,541.62 - 42,030.38 64.85% Fund Transfers 000-481000 Transfer In - Reserves 109,428 - - - - 109,428.00 0.00% TOTAL Fund Transfers 109,428 - - - - 109,428.00 0.00% Miscellaneous 000-497000 Misc Income - - - 2.00 - (2.00) 0.00% TOTAL Miscellaneous - - - 2.00 - (2.00) 0.00% TOTAL REVENUES 229,000 14,047.92 70,794.59 77,543.62 - 151,456.38 33.86% 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 30th, 2015 25 Cash in Bank Cash Balance 421,511.43$ Total Cash in Bank & Investments 421,511.43$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2015 PEG FUND 26 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 211,813 - 163,717.82 174,549.35 - 37,263.65 82.41% Permits 60,000.00 12,740.06 56,903.85 66,013.85 - (6,013.85) 110.02% Fees 17,169,500 1,396,101.10 12,166,957.25 12,475,105.32 - 4,694,394.68 72.66% Fund Transfers 276,425 11,426.08 93,237.03 102,834.72 - 173,590.28 37.20% Miscellaneous 142,940 4,792.34 226,240.33 98,818.31 - 44,121.69 69.13% TOTAL REVENUES 17,860,678 1,425,059.58 12,707,056.28 12,917,321.55 - 4,943,356.45 72.32% EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services 450,477 34,071.10 293,158.69 316,883.10 - 133,593.90 70.34% Supplies 4,600 173.62 2,890.42 2,147.95 25.00 2,427.05 47.24% Human Services 183 - 116.95 - - 183.00 0.00% City Support Services 24,098 - - 831.00 - 23,267.00 3.45% Utility Services 520 51.42 - 51.42 51.42 417.16 19.78% Operations Support 123,000 5,715.85 87,325.09 91,556.56 - 31,443.44 74.44% Staff Support 7,300 150.80 2,506.75 1,831.87 43.30 5,424.83 25.69% Professional Services 77,252 5,386.69 18,345.21 55,616.94 - 21,635.06 71.99% Maintenance Services 13,440 5,795.00 6,540.00 9,255.00 1,200.00 2,985.00 77.79% Operating Equipment 1,550 - - - - 1,550.00 0.00% TOTAL BUSINESS OFFICE 702,420 51,344.48 410,883.11 478,173.84 1,319.72 222,926.44 68.26% W & S ADMINISTRATION Personnel Services 1,255,365 84,541.56 813,154.99 821,486.26 - 433,878.74 65.44% Supplies 193,150 13,504.30 107,999.52 124,511.49 331.87 68,306.64 64.64% Human Services 1,000 - 389.95 476.00 - 524.00 47.60% City Support Services 103,403 - 55,676.99 35,702.56 - 67,700.44 34.53% Utility Services 3,454,440 265,421.85 2,191,420.63 2,116,137.29 328.40 1,337,974.31 61.27% Operations Support 9,250 1,030.35 2,149.40 2,950.69 2,894.30 3,405.01 63.19% Staff Support 31,150 2,048.38 18,849.09 15,379.73 2,042.05 13,728.22 55.93% City Assistance 1,900 - 708.25 1,110.00 - 790.00 58.42% Professional Services 259,113 15,620.19 206,744.08 134,193.53 44,000.00 80,919.47 68.77% Fund Charges/Transfers 3,492,504 144,074.65 2,336,589.85 2,212,453.03 - 1,280,050.97 63.35% Maintenance Services 6,543,586 657,483.74 4,380,781.07 4,684,494.04 67,206.88 1,791,885.08 72.62% Other Costs 35,000 - 27,650.20 27,150.20 - 7,849.80 77.57% ******************************************************* 2 0 1 4 - 2 0 1 5 ****************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 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 ******************************************************* 2 0 1 4 - 2 0 1 5 ****************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 Debt Service 1,534,512 - 204,338.59 211,759.71 - 1,322,752.29 13.80% Rental-Leasing 6,070 - 2,472.62 3,091.21 - 2,978.79 50.93% Operating Equipment 21,200 - 15,606.90 16,329.92 399.98 4,470.10 78.91% Capital Outlay 124,500 2,701.54 431,526.00 69,867.20 32,904.13 21,728.67 82.55% TOTAL PUBLIC WORKS 17,066,143 1,186,426.56 10,796,058.13 10,477,092.86 150,107.61 6,438,942.53 62.27% MISC & PROJECTS PROJECTS Fund Charges/Transfers - 810,471.46 - 945,227.88 - (945,227.88) 0.00% TOTAL PROJECTS - 810,471.46 - 945,227.88 - (945,227.88) 0.00% TOTAL MISC & PROJECTS - 810,471.46 - 945,227.88 - (945,227.88) 0.00% TOTAL EXPENDITURES 17,768,563 2,048,242.50 11,206,941.24 11,900,494.58 151,427.33 5,716,641.09 67.83% ** REVENUE OVER(UNDER)EXPENSES **92,115 1,016,826.97 28 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 211,813 - 163,717.82 174,549.35 - 37,263.65 82.41% TOTAL Franchises 211,813 - 163,717.82 174,549.35 - 37,263.65 82.41% Permits 000-432400 Development Permit 60,000 12,740.06 56,903.85 66,013.85 - (6,013.85) 110.02% TOTAL Permits 60,000 12,740.06 56,903.85 66,013.85 - (6,013.85) 110.02% Fees 000-455200 Garbage Collection Fee 4,000,000 337,471.48 2,957,709.74 3,063,081.76 - 936,918.24 76.58% 000-455600 Fire Line Fees 25,000 - 23,985.00 25,630.00 - (630.00) 102.52% 000-455700 Recycle Fee Revenue 270,000 22,922.84 196,743.21 203,700.77 - 66,299.23 75.44% 000-455800 W&S Line Constructn Reimbursemnt 25,000 3,104.00 18,367.52 18,996.00 - 6,004.00 75.98% 000-457100 Sale of Water 8,100,000 621,356.07 5,514,243.49 5,376,979.42 - 2,723,020.58 66.38% 000-457110 Edwards Water Lease 127,000 2,128.25 310,930.58 137,517.00 - (10,517.00) 108.28% 000-457120 Water Transfer Charge-Selma 42,000 - 28,328.27 21,600.91 - 20,399.09 51.43% 000-457130 Water Transfer Charge-U. C. 8,000 - 12,351.39 4,911.69 - 3,088.31 61.40% 000-457140 Water Transfer Charge-Converse 30,000 - 22,971.15 20,164.70 - 9,835.30 67.22% 000-457200 Sale of Meters 90,000 9,817.00 40,620.46 62,878.02 - 27,121.98 69.86% 000-457400 Sewer Charges 4,250,000 383,773.01 2,885,241.68 3,378,063.39 - 871,936.61 79.48% 000-457500 Water Penalties 200,000 15,328.45 151,004.76 158,231.66 - 41,768.34 79.12% 000-458110 Sale of Merchandise - Gov Deals - - 180.00 - - - 0.00% 000-458300 Sale of Property/Auction - - - 1,575.00 - (1,575.00) 0.00% 000-458400 Building rental Fee - - 2,000.00 - - - 0.00% 000-459200 NSF Check Fee-Water&Sewer 2,500 200.00 2,280.00 1,775.00 - 725.00 71.00% TOTAL Fees 17,169,500 1,396,101.10 12,166,957.25 12,475,105.32 - 4,694,394.68 72.66% Fund Transfers 000-486204 Interfnd Chrg-Drainage Bill 137,113 11,426.08 93,237.03 102,834.72 - 34,278.28 75.00% 000-486411 Transfer In-Capital Recovery 139,312 - - - - 139,312.00 0.00% TOTAL Fund Transfers 276,425 11,426.08 93,237.03 102,834.72 - 173,590.28 37.20% ******************************************************* 2 0 1 4 - 2 0 1 5 ****************************************************** AS OF: JUNE 30th, 2015 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z 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 ******************************************************* 2 0 1 4 - 2 0 1 5 ****************************************************** AS OF: JUNE 30th, 2015 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z Miscellaneous 000-490000 Misc Charges 700 - 391.50 471.00 - 229.00 67.29% 000-491000 Interest Earned 1,500 54.51 1,072.28 890.52 - 609.48 59.37% 000-491200 Investment Income 10,000 327.39 3,674.47 3,993.78 - 6,006.22 39.94% 000-496050 SSLG - SAWS Reservation - - 134,500.00 - - - 0.00% 000-497000 Misc Income-W&S 20,000 4,410.44 6,889.12 5,985.62 - 14,014.38 29.93% 000-498110 Reimbursement-SSLGC 110,740 - 79,637.00 87,477.39 - 23,262.61 78.99% 000-498300 Reimbursement-City Property - - 75.96 - - - 0.00% TOTAL Miscellaneous 142,940 4,792.34 226,240.33 98,818.31 - 44,121.69 69.13% TOTAL REVENUES 17,860,678 1,425,059.58 12,707,056.28 12,917,321.55 - 4,943,356.45 72.32% 30 Cash in Bank Claim on Operating Cash Pool-Checking 601,672.96$ Cash in Investments Lone Star Investment-Water&Sewer 1,771,090.98 Lone Star Investment-W&S Customer Deposits 295,629.75 Lone Star Investment-W&S Equip Replacement 177,746.47 Lone Star Investment-W&S Veh Replacement 256,770.98 Lone Star Investment-Water/SSLGC SAWS 810,574.85 Schertz Bank & Trust-Certificate of Deposit 1,068,630.27 4,380,443.30$ Total Cash in Bank & Investments 4,982,116.26$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2015 WATER & SEWER 31 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 66.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 6,416,343 505,370.15 4,009,097.12 4,118,886.48 - 2,297,456.52 64.19% Inter-Jurisdictional 1,601,076 23,843.88 1,198,310.38 1,254,357.48 - 346,718.52 78.34% Miscellaneous 169,500 5,011.24 90,944.15 45,101.30 - 124,398.70 26.61% TOTAL REVENUES 8,186,919 534,225.27 5,298,351.65 5,418,345.26 - 2,768,573.74 66.18% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 3,111,899 243,175.53 2,097,447.64 2,282,394.89 - 829,504.11 73.34% Supplies 386,786 56,447.71 241,052.01 273,282.27 38,721.77 74,781.96 80.67% Human Services 1,000 - 343.00 674.00 - 326.00 67.40% City Support Services 35,052 - 17,826.32 14,617.51 - 20,434.49 41.70% Utility Services 135,305 8,236.29 93,596.21 74,978.76 702.86 59,623.38 55.93% Operations Support 66,027 3,440.27 45,411.33 49,333.81 703.44 15,989.75 75.78% Staff Support 85,353 9,455.27 63,117.71 63,834.45 8,217.29 13,301.26 84.42% City Assistance 11,900 - 10,522.30 11,715.73 - 184.27 98.45% Professional Services 153,080 5,867.16 109,282.26 121,569.11 4,049.83 27,461.06 82.06% Fund Charges/Transfers 3,366,084 271,145.39 1,373,364.12 1,616,624.38 - 1,749,459.62 48.03% Maintenance Services 42,971 1,621.27 14,239.05 23,836.11 - 19,134.89 55.47% Debt Service 270,820 - 3,531.58 2,165.42 - 268,654.58 0.80% Rental-Leasing 81,541 5,795.07 - 52,735.14 17,385.21 11,420.65 85.99% Operating Equipment 265,080 38,928.22 66,958.31 149,349.40 12,164.59 103,566.01 60.93% Capital Outlay 138,382 - - 50,746.29 1,105.00 86,530.71 37.47% TOTAL PUBLIC SAFETY 8,151,280 644,112.18 4,136,691.84 4,787,857.27 83,049.99 3,280,372.74 59.76% TOTAL EXPENDITURES 8,151,280 644,112.18 4,136,691.84 4,787,857.27 83,049.99 3,280,372.74 59.76% ** REVENUE OVER(UNDER) EXPENSES **35,639 630,487.99 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2015 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 32 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 66.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000-456100 Ambulance/Mileage Transport 6,249,943 498,458.35 3,914,871.46 3,987,330.76 - 2,262,612.24 63.80% 000-456110 Subscription Program Fees 40,000 85.00 23,005.00 25,980.00 - 14,020.00 64.95% 000-456120 EMT Class - Fees 104,400 5,325.00 57,096.00 89,025.90 - 15,374.10 85.27% 000-456130 Immunization Fees - - - 420.00 - (420.00) 0.00% 000-456140 Billing Fees - Alamo Heights 22,000 1,501.80 14,074.66 15,974.82 - 6,025.18 72.61% 000-458110 Sales of Merchandise - GovDeal - - - 155.00 - (155.00) 0.00% 000-459200 NSF Check Fee - - 50.00 - - - 0.00% TOTAL Fees 6,416,343 505,370.15 4,009,097.12 4,118,886.48 - 2,297,456.52 64.19% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 286,126 23,843.88 238,438.80 238,438.80 - 47,687.20 83.33% 000-474300 Cibolo Support 261,370 - 190,317.60 196,044.75 - 65,325.25 75.01% 000-475100 Comal Co ESD #6 95,217 - 68,316.30 69,497.10 - 25,719.90 72.99% 000-475200 Live Oak Support 179,608 - 130,782.60 142,177.50 - 37,430.50 79.16% 000-475300 Universal City Support 247,353 - 181,511.60 185,531.64 - 61,821.36 75.01% 000-475400 Selma Support 73,952 - 55,848.80 55,469.25 - 18,482.75 75.01% 000-475500 Schertz Support 433,542 - 315,686.16 349,266.03 - 84,275.97 80.56% 000-475600 Santa Clara Support 9,678 - 7,047.00 7,259.07 - 2,418.93 75.01% 000-475800 Marion Support 14,230 - 10,361.52 10,673.34 - 3,556.66 75.01% TOTAL Inter-Jurisdictional 1,601,076 23,843.88 1,198,310.38 1,254,357.48 - 346,718.52 78.34% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2015 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 33 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 66.67% 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: MAY 31st, 2015 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** Miscellaneous 000-491000 Interest Earned - 11.66 36.41 68.15 - (68.15) 0.00% 000-491200 Investment Income - 106.23 - 526.96 - (526.96) 0.00% 000-493203 Donations-EMS 2,000 100.00 30.00 710.00 - 1,290.00 35.50% 000-493204 Donations-Dilworth Fund 3,500 - - - - 3,500.00 0.00% 000-493205 Donations- Golf Tournament 9,000 300.00 15,125.00 7,380.00 - 1,620.00 82.00% 000-497000 Misc Income 145,000 202.86 72,208.62 28,885.59 - 116,114.41 19.92% 000-497100 Recovery of Bad Debt 10,000 4,290.49 3,493.12 7,530.60 - 2,469.40 75.31% 000-498300 Reimbursement- City Property - - 51.00 - - - 0.00% TOTAL Miscellaneous 169,500 5,011.24 90,944.15 45,101.30 - 124,398.70 26.61% TOTAL REVENUES 8,186,919 534,225.27 5,298,351.65 5,418,345.26 - 2,768,573.74 66.18% 34 Cash in Bank Claim on Operating Cash Pool-Checking 238,807.55$ Cash in Investments Texas Class- Tax Note 2015 Ambulances 893,526.96 Total Cash in Bank & Investments 1,132,334.51$ CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2015 SCHERTZ EMS 35 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 180.00 2,740.00 2,100.00 - 900.00 70.00% Fees 1,155,500 91,412.33 767,843.75 810,726.22 - 344,773.78 70.16% Miscellaneous 25,700 209.84 860.35 26,293.31 - (593.31) 102.31% TOTAL REVENUES 1,184,200 91,802.17 771,444.10 839,119.53 - 345,080.47 70.86% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 456,029 33,037.19 259,323.06 322,628.19 - 133,400.81 70.75% Supplies 8,300 271.67 4,195.93 4,524.26 22.57 3,753.17 54.78% Human Services 325 - 61.00 - - 325.00 0.00% City Support Services 27,932 - 2,166.61 2,306.64 - 25,625.36 8.26% Utility Services 30,370 1,644.64 15,438.11 12,988.48 141.68 17,239.84 43.23% Operations Support 2,460 19.99 - 64.97 - 2,395.03 2.64% Staff Support 8,116 663.08 3,307.40 3,636.77 264.98 4,214.25 48.07% City Assistance 840 - - - - 840.00 0.00% Professional Services 23,500 - 2,360.01 5,307.94 937.50 17,254.56 26.58% Fund Charges/Transfers 221,818 18,401.49 147,378.06 165,613.41 - 56,204.59 74.66% Maintenance Services 47,000 - 1,733.68 1,457.90 25,920.00 19,622.10 58.25% Other costs 200 - 200.00 100.00 - 100.00 50.00% Debt Service 140,530 - 1,036.58 705.76 - 139,824.24 0.50% Rental/Leasing 500 - - - - 500.00 0.00% Operating Equipment 5,500 - 11,303.80 4,091.64 - 1,408.36 74.39% Capital Outlay - - 24,322.00 - - - 0.00% TOTAL DRAINAGE 973,420 54,038.06 472,826.24 523,425.96 27,286.73 422,707.31 56.58% PROJECTS City Support Services 3,200 - - - - 3,200.00 0.00% Operations Support 1,000 - - 591.34 - 408.66 59.13% Professional Services 7,700 - 21,840.00 5,138.75 8,000.00 (5,438.75) 170.63% Maintenance Services 134,298 46,720.66 16,800.00 137,727.74 44,781.89 (48,211.63) 135.90% TOTAL PROJECTS 146,198 46,720.66 38,640.00 143,457.83 52,781.89 (50,041.72) 134.23% TOTAL EXPENDITURES 1,119,618 100,758.72 511,466.24 666,883.79 80,068.62 372,665.59 66.71% ** REVENUE OVER(UNDER) EXPEND 64,582 172,235.74 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 **************************************************** 2 0 1 4 - 2 0 1 5 **************************************************** 36 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 180.00 2,740.00 2,100.00 - 900.00 70.00% TOTAL Permits 3,000 180.00 2,740.00 2,100.00 - 900.00 70.00% Fees 000-457500 Drainage Penalties 8,000 723.11 6,367.48 7,190.80 - 809.20 89.89% 000-457600 Drainage Fee 1,147,500 90,689.22 761,476.27 803,535.42 - 343,964.58 70.02% TOTAL Fees 1,155,500 91,412.33 767,843.75 810,726.22 - 344,773.78 70.16% Miscellaneous 000-491000 Interest Earned 100 7.07 142.00 196.60 - (96.60) 196.60% 000-491200 Investment Interest 500 202.77 652.35 1,096.71 - (596.71) 219.34% 000-493204 Donations- Drainage Project 25,000 - - 25,000.00 - 100.00% 000-497000 Misc Income-Drainage 100 - 60.00 - - 100.00 0.00% 000-498300 Reimbursement- City Property - - 6.00 - - - 0.00% TOTAL Miscellaneous 25,700 209.84 860.35 26,293.31 - (593.31) 102.31% TOTAL REVENUES 1,184,200 91,802.17 771,444.10 839,119.53 - 345,080.47 70.86% 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 30th, 2015 37 Cash in Bank Claim on Operating Cash Pool-Checking 158,237.08 Cash in Investments Lone Star Investment-Drainage Maint Fund 1,006,428.78 Total Cash in Bank & Investments 1,164,665.86$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2015 38 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 544,753 43,373.07 290,626.52 346,788.04 - 197,964.96 63.66% Miscellaneous 600 69.42 292.65 388.83 - 211.17 64.81% TOTAL REVENUES 545,353 43,442.49 290,919.17 347,176.87 - 198,176.13 63.66% EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 - - - - 2,500.00 0.00% City Support Services 61,500 3,999.99 46,221.00 31,175.58 - 30,324.42 50.69% Operations Support 69,500 1,986.00 18,008.66 15,110.50 154.65 54,234.85 21.96% Professional Services 5,825 - 2,800.00 3,000.00 1,875.00 950.00 83.69% Fund Charges/Transfers 126,405 5,533.75 132,538.78 73,303.75 - 53,101.25 57.99% Maintenance Services - - 23,462.00 - - - 0.00% Operating Equipment 37,000 - 7,710.59 3,928.04 5,602.80 27,469.16 25.76% TOTAL NONDEPARTMENTAL 302,730 11,519.74 230,741.03 126,517.87 7,632.45 168,579.68 44.31% TOTAL EXPENDITURES 302,730 11,519.74 230,741.03 126,517.87 7,632.45 168,579.68 44.31% REVENUE OVER(UNDER) EXPENDITURE 242,623 220,659.00 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 **************************************************** 2 0 1 4 - 2 0 1 5 **************************************************** 39 314-HOTEL TAX 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 Taxes 000-411800 Hotel Occupancy Tax 544,753 43,373.07 290,626.52 346,788.04 - 197,964.96 63.66% TOTAL Taxes 544,753 43,373.07 290,626.52 346,788.04 - 197,964.96 63.66% Miscellaneous 000-491000 Interest Earned 100 9.98 80.15 93.68 - 6.32 93.68% 000-491200 Investment Interest 500 59.44 212.50 295.15 - 204.85 59.03% TOTAL Miscellaneous 600 69.42 292.65 388.83 - 211.17 64.81% TOTAL REVENUES 545,353 43,442.49 290,919.17 347,176.87 - 198,176.13 63.66% 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 30th, 2015 40 Cash in Bank Claim on Operating Cash Pool-Checking 185,080.31$ Cash in Investments Texas Class - Hotel Tax 499,481.99 Total Cash in Bank & Investments 684,562.30$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2015 HOTEL OCCUPANCY TAX FUND 41 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014-15 44,724 42,229 35,309 33,055 46,037 58,530 43,715 43,525 53,346 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 2010-11 27,689 25,112 23,231 19,619 22,667 36,728 28,215 34,157 45,854 53,433 42,181 32,294 $- $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 100,000 - 52,150.00 18,000.00 - 82,000.00 18.00% Miscellaneous - 9.65 15.96 79.91 - (79.91) 0.00% TOTAL REVENUES 100,000 9.65 52,165.96 18,079.91 - 81,920.09 18.08% EXPENDITURE SUMMARY PARKLAND DEDICATION Fund Charges/Transfers 32,405 - - 32,405.00 - - 100.00% Capital Outlay 60,000 - - 10,930.00 7,184.49 41,885.51 30.19% TOTAL PARKLAND DEDICATION 92,405 - - 43,335.00 7,184.49 41,885.51 54.67% TOTAL EXPENDITURES 92,405 - - 43,335.00 7,184.49 41,885.51 54.67% REVENUE OVER(UNDER) EXPEND 7,595 (25,255.09) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 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 100,000 - 52,150.00 18,000.00 - 82,000.00 18.00% TOTAL Fees 100,000 - 52,150.00 18,000.00 - 82,000.00 18.00% Miscellaneous 000-491000 Interest Earned - 9.39 14.60 68.69 - (68.69) 0.00% 000-491200 Investment Interest - 0.26 1.36 11.22 - (11.22) 0.00% 000-497000 Misc Income - - - - - - 0.00% TOTAL Miscellaneous - 9.65 15.96 79.91 - (79.91) 0.00% TOTAL REVENUES 100,000 9.65 52,165.96 18,079.91 - 81,920.09 18.08% 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 30th, 2015 44 Cash in Bank Claim on Operating Cash Pool-Checking $165,536.38 Cash in Investments Texas Class- Park Fund 1,355.81 Total Cash in Bank & Investments $166,892.19 CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 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 36,000 9,945.00 227,757.50 188,002.50 - (152,002.50) 522.23% Fund Transfers 176,939 - - - - 176,939 0.00% Miscellaneous 210 54.98 171.34 248.91 - (38.91) 118.53% TOTAL REVENUES 213,149 9,999.98 227,928.84 188,251.41 - 24,897.59 88.32% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services-Trees 212,939 - 39,956.30 9,154.00 - 203,785.00 4.30% TOTAL TREE MITIGATION 212,939 - 39,956.30 9,154.00 - 203,785.00 4.30% TOTAL EXPENDITURES 212,939 - 39,956.30 9,154.00 - 203,785.00 4.30% REVENUE OVER(UNDER) EXPEND 210 179,097.41 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 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 36,000 9,945.00 227,757.50 188,002.50 - (152,002.50) 522.23% TOTAL Fees 36,000 9,945.00 227,757.50 188,002.50 - (152,002.50) 522.23% Fund Transfers 000-481000 Transfer In - Reserves 176,939 - - - - 176,939.00 0.00% TOTAL Fund Transfers 176,939 - - - - 176,939.00 0.00% Miscellaneous 000-491000 Interest Earned 90 7.71 102.77 118.13 - (28.13) 131.26% 000-491200 Investment Interest 120 47.27 68.57 130.78 - (10.78) 108.98% TOTAL Miscellaneous 210 54.98 171.34 248.91 - (38.91) 118.53% TOTAL REVENUES 213,149 9,999.98 227,928.84 188,251.41 - 24,897.59 88.32% 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 30th, 2015 47 Cash in Bank Claim on Operating Cash Pool-Checking $140,822.31 Cash in Investments MBIA Investment-Tree Mitigation 397,480.21 Total Cash in Bank & Investments $538,302.52 CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2015 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 880,200 130,563.00 626,409.00 847,516.30 - 32,683.70 96.29% Fund Transfers - - - - - - 0.00% Miscellaneous 5,300 623.94 4,257.85 4,538.55 - 761.45 85.63% TOTAL REVENUES 885,500 131,186.94 630,666.85 852,054.85 - 33,445.15 96.22% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 5,000 - - - - 5,000.00 0.00% Operations Support 109 - - - - 109.00 0.00% Professional Services 80,000 - 1,000.00 1,000.00 625.00 78,375.00 2.03% Fund Charges/Transfers 116,000 - 77,778.00 3,579.00 - 112,421.00 3.09% Maintenance Services 1,000 - - - - 1,000.00 0.00% Capital Outlay 450,000 - - - - 450,000.00 0.00% TOTAL NON DEPARTMENTAL 652,109 - 78,778.00 4,579.00 625.00 646,905.00 0.80% MISC & PROJECTS Water Projects - - - 85,186.10 186,732.71 (271,918.81) 0.00% TOTAL MISC & PROJECTS - - - 85,186.10 186,732.71 (271,918.81) 0.00% TOTAL EXPENDITURES 652,109 - 78,778.00 89,765.10 187,357.71 374,986.19 42.50% REVENUE OVER(UNDER) EXPENDITURES 233,391 762,289.75 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 ******************************************************* 2 0 1 4 - 2 0 1 5 ******************************************************* 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 880,200 130,563.00 626,409.00 847,516.30 - 32,683.70 96.29% TOTAL Fees 880,200 130,563.00 626,409.00 847,516.30 - 32,683.70 96.29% Miscellaneous 000-491000 Interest Earned 300 50.33 280.48 514.62 - (214.62) 171.54% 000-491200 Investment Income 5,000 573.61 3,977.37 4,023.93 - 976.07 80.48% TOTAL Miscellaneous 5,300 623.94 4,257.85 4,538.55 - 761.45 85.63% TOTAL REVENUES 885,500 131,186.94 630,666.85 852,054.85 - 33,445.15 96.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 30th, 2015 50 Cash in Bank Claim on Operating Cash Pool-Checking 969,181.29$ Cash in Investments Lone Star Investment-Capital Recovery Water 4,497,056.01 Total Cash in Bank & Investments 5,466,237.30$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2015 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 600,400 74,752.08 438,209.90 483,295.44 - 117,104.56 80.50% Fund Transfers 559,497 - 77,778.00 - - 559,497.00 0.00% Miscellaneous 600 1,448.73 10,385.54 13,240.43 - (12,640.43) 2206.74% TOTAL REVENUES 1,160,497 76,200.81 526,373.44 496,535.87 - 663,961.13 42.79% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 3,143 358.97 4,214.73 4,229.50 625.00 (1,711.50) 154.45% Fund Charges/Transfers 139,312 - - - - 139,312.00 0.00% TOTAL NON DEPARTMENTAL 142,455 358.97 4,214.73 4,229.50 625.00 137,600.50 3.41% MISC & PROJECTS Sewer Projects 1,018,042 - - - - 1,018,042.00 0.00% TOTAL MISC & PROJECTS 1,018,042 - - - - 1,018,042.00 0.00% TOTAL EXPENDITURES 1,160,497 358.97 4,214.73 4,229.50 625.00 1,155,642.50 0.42% REVENUE OVER(UNDER) EXPENDITURES - 492,306.37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 ******************************************************* 2 0 1 4 - 2 0 1 5 ******************************************************* 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,400 67,552.08 342,143.90 425,695.44 - 74,704.56 85.07% 000-455913 Cap Recovery-North Sewer Tr 100,000 7,200.00 96,066.00 57,600.00 - 42,400.00 57.60% TOTAL Fees 600,400 74,752.08 438,209.90 483,295.44 - 117,104.56 80.50% Fund Transfers 000-481000 Transfer from Reserves 559,497 - - - - 559,497.00 0.00% 000-486411 Transfer In-Cap Recovery Water - - 77,778.00 - - - 0.00% TOTAL Fund Transfers 559,497 - 77,778.00 - - 559,497.00 0.00% Miscellaneous 000-491000 Interest Earned 100 35.10 163.59 314.27 - (214.27) 314.27% 000-491200 Investment Income 500 2,436.40 24,172.07 20,901.98 - (20,401.98) 4180.40% 000-491800 Gain/Loss - (8,096.32) (40,015.93) (10,238.49) - 10,238.49 0.00% 000-491900 Unrealized Gain/Loss-Cap One - 7,073.55 26,065.81 2,262.67 - (2,262.67) 0.00% TOTAL Miscellaneous 600 1,448.73 10,385.54 13,240.43 - (12,640.43) 2206.74% TOTAL REVENUES 1,160,497 76,200.81 526,373.44 496,535.87 - 663,961.13 42.79% 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 30th, 2015 53 Cash in Bank Claim on Operating Cash Pool-Checking 652,202.87$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 1,953,298.92 Capital One-Investment 1,734,039.69 Total Cash in Bank & Investments 4,339,541.48$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2015 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,338,513 23,667.61 5,260,291.76 5,363,047.94 - (24,534.94) 100.46% Miscellaneous 368,763 294.14 8,796,280.00 353,072.79 - 15,690.21 95.75% TOTAL REVENUES 5,707,276 23,961.75 14,056,571.76 5,716,120.73 - (8,844.73) 100.15% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 42,350 - 164,650.00 1,550.00 - 40,800.00 3.66% Debt Service 5,593,807 - 3,635,146.86 4,442,606.03 - 1,151,200.97 79.42% TOTAL GENERAL GOVERNMENT 5,636,157 - 12,982,047.09 4,444,156.03 - 1,192,000.97 78.85% TOTAL EXPENDITURES 5,636,157 - 12,982,047.09 4,444,156.03 - 1,192,000.97 78.85% ** REVENUE OVER(UNDER) EXPEND 71,119 1,271,964.70 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 ****************************************************** 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,338,513 23,667.61 5,260,291.76 5,363,047.94 - (24,534.94) 100.46% TOTAL Taxes 5,338,513 23,667.61 5,260,291.76 5,363,047.94 - (24,534.94) 100.46% Miscellaneous 000-491000 Interest Earned 75 (60.55) 49.94 7.16 - 67.84 9.55% 000-491200 Investment Earnings 1,500 354.69 1,161.31 1,996.88 - (496.88) 133.13% 000-495015 Contribution from SED 367,188 - 345,068.75 351,068.75 - 16,119.25 95.61% 000-498000 Proceeds From Refunding Debt - - 8,450,000.00 - - - 0.00% TOTAL Miscellaneous 368,763 294.14 8,796,280.00 353,072.79 - 15,690.21 95.75% TOTAL REVENUES 5,707,276 23,961.75 14,056,571.76 5,716,120.73 - (8,844.73) 100.15% 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 30th, 2015 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,350 - 1,150.00 1,550.00 - 800.00 65.96% 101-541502 Cost of Bond Issuance 40,000 - 163,500.00 - - 40,000.00 0.00% TOTAL Professional Services 42,350 - 164,650.00 1,550.00 - 40,800.00 3.66% Debt Service 101-555612 Bond-GO Refunding 2010-Principal 265,000 - 260,000.00 265,000.00 - - 100.00% 101-555612.1 Bond-GO Refunding 2010 Interest 63,525 - 37,000.00 33,750.00 - 29,775.00 53.13% 101-555626 LS&D SR2006-Principal 350,000 - 200,000.00 350,000.00 - - 100.00% 101-555626.1 LS&D SR2006-Interest 204,419 - 319,490.64 105,709.38 - 98,709.62 51.71% 101-555628 CO Bond 2007-Principal 116,134 - - - - 116,134.00 0.00% 101-555628.1 CO Bond 2007-Interest 9,582 - 7,052.93 4,790.61 - 4,791.39 50.00% 101-555629 GO Bond 2007-Principal 255,000 - 245,000.00 255,000.00 - - 100.00% 101-555629.1 GO Bond 2007-Interest 169,618 - 92,001.36 87,268.47 - 82,349.53 51.45% 101-555630 GO Bond SR2008 Principal 420,000 - 430,000.00 420,000.00 - - 100.00% 101-555630.1 GO Bond SR2008 Interest 314,706 - 170,569.00 161,689.50 - 153,016.50 51.38% 101-555631 GO Bond SR2009 Principal 535,000 - 590,000.00 535,000.00 - - 100.00% 101-555631.1 BO Bond SR2009 Interest 298,800 - 160,787.50 153,412.50 - 145,387.50 51.34% 101-555633 GO SR2011 Principal 220,000 - 210,000.00 220,000.00 - - 100.00% 101-555633.1 GO SR2011 Interest 349,438 - 181,118.75 176,918.75 - 172,519.25 50.63% 101-555634 GO SR2011A Refund Principal 610,000 - 615,000.00 610,000.00 - - 100.00% 101-555634.1 GO SR2011A Refund Interest 130,830 - 76,132.75 68,968.00 - 61,862.00 52.72% 101-555635 GO SR2012 Principal 295,000 - 285,000.00 295,000.00 - - 100.00% 101-555635.1 GO SR2012 Interest 206,444 - 113,204.38 106,079.38 - 100,364.62 51.38% 101-555636 Tax Note - SR2013 - Principal 165,000 - 160,000.00 165,000.00 - - 100.00% 101-555636.1 Tax Note - SR2013 - Interest 7,543 - 7,079.88 4,142.50 - 3,400.50 54.92% 101-555637 Tax Note - SR 2013A - Principal 160,000 - 155,000.00 160,000.00 - - 100.00% 101-555637.1 Tax Note - SR2013 - Interest 7,345 - 6,846.67 4,192.50 - 3,152.50 57.08% 101-555638 Bond-GO 2014 Refund-Principal 50,000 - - 50,000.00 - - 100.00% 101-555638.1 Bond-GO 2014 Refund-Interest 358,322 - - 210,684.44 - 147,637.56 58.80% 101-555900 Debt Service 32,101 - - - - 32,101.00 0.00% 101-555800 Bond Premium - - (686,137.00) - - - 0.00% TOTAL Debt Service 5,593,807 - 3,635,146.86 4,442,606.03 - 1,151,200.97 79.42% Other Financing Sources 101-556300 Payment to Refund Debt - - 9,182,250.23 - - - 0.00% TOTAL Other Financing Sources - - 9,182,250.23 - - - 0.00% TOTAL EXPENDITURES 5,636,157 - 12,982,047.09 4,444,156.03 - 1,192,000.97 78.85% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 ***************************************************** 2 0 1 4 - 2 0 1 5 ***************************************************** 57 Cash in Bank Claim on Operating Cash Pool-Checking (1,051,749.05)$ Cash in Investments MBIA Investment- Tax I&S 2,982,890.18 Total Cash in Bank & Investments 1,931,141.13$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2015 TAX I&S 58 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,682,057 356,534.55 2,675,561.70 2,476,811.96 - 1,205,245.04 67.27% Miscellaneous 10,200 2,730.93 6,355.72 11,381.22 - (1,181.22) 111.58% TOTAL REVENUES 3,692,257 359,265.48 2,681,917.42 2,488,193.18 - 1,204,063.82 67.39% EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services 364,312 19,971.07 226,220.12 113,702.91 - 250,609.09 31.21% Supplies 1,050 - 420.80 501.10 105.62 443.28 57.78% Human Services 1,000 - - 135.00 - 865.00 13.50% City Support Services 16,545 - 1,174.29 1,114.09 - 15,430.91 6.73% Utility Services 4,120 102.16 1,309.91 615.35 51.42 3,453.23 16.18% Operations Support 147,145 351.00 67,861.26 53,285.14 - 93,859.86 36.21% Staff Support 18,250 - 3,240.86 1,934.83 - 16,315.17 10.60% City Assistance 1,025,000 - 500,078.59 - - 1,025,000.00 0.00% Professional Services 92,500 - 16,132.41 7,021.95 1,000.00 84,478.05 8.67% Fund Charges/Transfers 471,280 8,674.33 436,713.39 429,137.72 - 42,142.28 91.06% Debt Service 430,608 - 270,270.00 274,494.00 - 156,114.00 63.75% Operating Equipment 2,000 - 38.99 368.77 - 1,631.23 18.44% TOTAL ECONO DEVELOPMENT 2,573,810 29,098.56 1,523,460.62 882,310.86 1,157.04 1,690,342.10 34.33% MISC & PROJECTS PROJECTS 450,000 - - 6,400.00 - 443,600.00 1.42% TOTAL MISC & PROJECTS 450,000 - 6,400.00 - 443,600.00 0.00% TOTAL EXPENDITURES 3,023,810 29,098.56 1,523,460.62 888,710.86 1,157.04 2,133,942.10 29.43% ** REVENUE OVER(UNDER) EXPEND 668,447 1,599,482.32 C I T Y O F S C H E R T Z ***************************************************** 2 0 1 4 - 2 0 1 5 ***************************************************** REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2015 59 620-SED CORPORATION 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 Taxes 000-411500 Sales Tax Revenue (4B)3,682,057 356,534.55 2,675,561.70 2,476,811.96 - 1,205,245.04 67.27% TOTAL Taxes 3,682,057 356,534.55 2,675,561.70 2,476,811.96 - 1,205,245.04 67.27% Miscellaneous 000-491000 Interest Earned 200 (2.10) 239.83 139.99 - 60.01 70.00% 000-491200 Investment Earnings 10,000 2,733.03 6,115.89 8,912.91 - 1,087.09 89.13% 000-497000 Misc Income - - - 2,328.32 - (2,328.32) 0.00% TOTAL Miscellaneous 10,200 2,730.93 6,355.72 11,381.22 - (1,181.22) 111.58% TOTAL REVENUES 3,692,257 359,265.48 2,681,917.42 2,488,193.18 - 1,204,063.82 67.39% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** AS OF: JUNE 30th, 2015 60 Cash in Bank Claim on Operating Cash Pool-Checking 42,173.16$ Cash in Investments Texas Class Investment-Economic Development Corp 7,782,762.96 Schertz Bank & Trust-Certificate of Deposit 1,049,082.71 Total Cash in Bank & Investments 8,874,018.83$ CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2015 SED CORPORATION 61 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014-15 247,750 319,452 252,513 210,669 397,691 225,482 247,025 361,702 232,983 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 2010-11 171,042 166,132 173,802 177,864 235,199 163,627 141,650 212,924 204,332 171,256 226,531 192,615 3.0% -2.8% -8.9% 1.2% 9.2% -7.6%-8.8% -7.4% -32.7% $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 4B SALES TAX 62 INVESTMENT REPORT C I T Y O F S C H E R T Z FOR MONTH ENDING JUNE 30th, 2015 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 4,868,851.82 0.0500 4,516,635.50 3,988,989.92 215.90 5,396,713.30 5,396,713.30 5,396,713.30 N/A Schertz Bank & Trust - PEG Fund 424,681.92 0.0000 - 3,170.49 - 421,511.43 421,511.43 421,511.43 N/A TOTAL OPERATIONS 5,293,533.74 4,516,635.50 3,992,160.41 215.90 5,818,224.73 5,818,224.73 5,818,224.73 - LOGIC General Fund 9,641,340.96 0.1249 - 600,000.00 972.74 9,042,313.70 9,042,313.70 9,042,313.70 N/A 50 Days G/F-Equipment Replacement 73,695.29 0.1249 - - 7.57 73,702.86 73,702.86 73,702.86 N/A 50 Days G/F-Vehicle Replacement 306,855.63 0.1249 - - 31.50 306,887.13 306,887.13 306,887.13 N/A 50 Days G/F-Air Conditioner Replacement 196,194.85 0.1249 - - 20.15 196,215.00 196,215.00 196,215.00 N/A 50 Days SR2009 Bond-Street Projects(II)1,030,814.13 0.1249 - - 105.80 1,030,919.93 1,030,919.93 1,030,919.93 N/A 50 Days TOTAL LOGIC 11,248,900.86 - 600,000.00 1,137.76 10,650,038.62 10,650,038.62 10,650,038.62 - LONESTAR Capital Recovery - Sewer 1,953,049.77 0.1600 - - 249.15 1,953,298.92 1,953,298.92 1,953,298.92 N/A 40 Days Capital Recovery - Water 4,496,482.40 0.1600 - - 573.61 4,497,056.01 4,497,056.01 4,497,056.01 N/A 40 Days Drainage Fund 1,006,300.41 0.1600 - - 128.37 1,006,428.78 1,006,428.78 1,006,428.78 N/A 40 Days Facilities Master Plan 145,252.19 0.1600 - - 18.53 145,270.72 145,270.72 145,270.72 N/A 40 Days GO SR2011 Animal Shelter 31,315.51 0.1600 - 19,791.45 3.48 11,527.54 11,527.54 11,527.54 N/A 40 Days GO SR2011 Soccer Fields 377,558.70 0.1600 - 167,413.90 43.85 210,188.65 210,188.65 210,188.65 N/A 40 Days GO SR2011 Swimming Pool 5,840,943.38 0.1600 - 55,383.01 743.70 5,786,304.07 5,786,304.07 5,786,304.07 N/A 40 Days GO SR2012 Downtown Improvements 980,249.60 0.1600 - 554.57 125.04 979,820.07 979,820.07 979,820.07 N/A 40 Days SE Elevated Water Tank - 0.1600 810,471.46 - 103.39 810,574.85 810,574.85 810,574.85 N/A 40 Days Sewer/CCMA Project 2,929,303.30 0.1600 - - 373.69 2,929,676.99 2,929,676.99 2,929,676.99 N/A 40 Days W/S-Customer Deposits 295,592.04 0.1600 - - 37.71 295,629.75 295,629.75 295,629.75 N/A 40 Days W/S-Equipment Repl/Cap.Imp 177,723.80 0.1600 - - 22.67 177,746.47 177,746.47 177,746.47 N/A 40 Days Water&Sewer 1,470,895.61 0.1600 300,000.00 - 195.37 1,771,090.98 1,771,090.98 1,771,090.98 N/A 40 Days W/S-Vehicle Replacement 256,738.23 0.1600 - - 32.75 256,770.98 256,770.98 256,770.98 N/A 40 Days Water/SSLG - SAWS 810,574.85 0.1600 - 810,471.46 0.01 103.40 103.40 103.40 N/A 40 Days TOTAL LONESTAR 20,771,979.79 1,110,471.46 1,053,614.39 2,651.32 20,831,488.18 20,831,488.18 20,831,488.18 - TEXAS CLASS Tax I&S 2,982,535.49 0.1500 - - 354.69 2,982,890.18 2,982,890.18 2,982,890.18 N/A 56 Days Police Forfeiture 244,216.04 0.1500 - - 29.02 244,245.06 244,245.06 244,245.06 N/A 56 Days Park Fund 1,355.55 0.1500 - - 0.26 1,355.81 1,355.81 1,355.81 N/A 56 Days Economic Development Corporation 7,781,837.56 0.1500 - - 925.40 7,782,762.96 7,782,762.96 7,782,762.96 N/A 56 Days Library Board 44,888.50 0.1500 - - 5.36 44,893.86 44,893.86 44,893.86 N/A 56 Days Tree Mitigation 397,432.94 0.1500 - - 47.27 397,480.21 397,480.21 397,480.21 N/A 56 Days Tax Note 2013 Fire Truck 4,933.28 0.1500 - - 0.60 4,933.88 4,933.88 4,933.88 N/A 56 Days Hotel Tax 499,422.55 0.1500 - - 59.44 499,481.99 499,481.99 499,481.99 N/A 56 Days Special Events Fund 16,796.15 0.1500 - - 2.03 16,798.18 16,798.18 16,798.18 N/A 56 Days Citywide Projects SR2007 803,994.15 0.1500 - 78,135.32 93.42 725,952.25 725,952.25 725,952.25 N/A 56 Days Tax Notes 2015 EMS Ambulances 893,420.73 0.1500 - - 106.23 893,526.96 893,526.96 893,526.96 N/A 56 Days Tax Notes 2015 Drainage Equipment 625,312.39 0.1500 - - 74.40 625,386.79 625,386.79 625,386.79 N/A 56 Days Tax Notes 2015 Water Equipment 327,153.85 0.1500 - - 38.89 327,192.74 327,192.74 327,192.74 N/A 56 Days Tax Notes 2015 General Fund Equipment 238,112.14 0.1500 - - 28.35 238,140.49 238,140.49 238,140.49 N/A 56 Days TOTAL TEXAS CLASS 14,861,411.32 - 78,135.32 1,765.36 14,785,041.36 14,785,041.36 14,785,041.36 - C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING JUNE 30th, 2015 64 65 TOTAL OPERATIONS 10% TOTAL LOGIC 19% TOTAL LONESTAR 36% TOTAL TEXAS CLASS 26% TOTAL CAPITAL ONE 5% TOTAL C.D.s 4% City Portfolio By Investment Type 66 Operations, $19,058,194.93 Projects, $13,904,010.60 Debt Service Fund, $2,982,890.18 Special Revenue Funds, $19,165,628.78 Designated Funds, $1,373,578.11 City Portfolio By Use 67 0.00 0.50 1.00 1.50 2.00 2.50 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 1 Month T-Bill 0.0100 0.0400 0.0300 0.0100 0.0200 0.0500 0.0000 0.0100 0.0200 3 Month T-Bill 0.0100 0.0200 0.0400 0.0200 0.0200 0.0300 0.0100 0.0100 0.0100 6 Month T-Bill 0.0500 0.0700 0.1200 0.0700 0.0700 0.1400 0.0600 0.0600 0.1100 Schertz Portfolio 0.2422 0.2371 0.2197 0.2265 0.2262 0.2283 0.2368 0.2339 0.3006 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.4000 0.4000 0.4000 0.7500 0.7500 0.7500 0.7500 0.7500 0.7500 CD 180 Days 0.6000 0.6000 0.3500 0.3500 0.3500 0.3500 0.3500 0.3500 0.6000 LOGIC 0.0879 0.0871 0.0974 0.0843 0.0921 0.0999 0.1130 0.1122 0.1249 LoneStar 0.1300 0.1400 0.1400 0.1300 0.1300 0.1400 0.1400 0.1500 0.1600 MBIA 0.1000 0.1000 0.1000 0.1100 0.1100 0.1200 0.1400 0.1400 0.1500 Capital One 1.4135 1.3208 1.4416 1.4858 1.4594 1.4575 1.4587 1.4596 2.2923 MONTHLY YIELDS 68 C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:6/30/2015 General Fund Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Prime Mmkt Port Fd #690 28,054.38 28,054.38 28,054.38 24.00 0.09 Total Cash & Equivalents 28,054.38 28,054.38 28,054.38 24.00 0.09% Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 169.00 100,000.00 116,185.00 102,112.00 4,875.00 4.77 Federal Natl Mtg Assn 1/30/2017 580.00 100,000.00 102,366.80 101,053.00 1,250.00 1.24 Federal Home LN Mtg Corp Reference Nts 11/17/2017 871.00 100,000.00 109,860.00 110,059.00 5,125.00 4.66 Federal Home LN Mtg Corp Refrnce 8 6/13/2018 1079.00 275,000.00 305,095.45 305,552.50 13,406.00 4.39 US Treasury Note 3/15/2017 624.00 100,000.00 99,835.94 100,360.00 750.00 0.75 US Treasury Note 10/15/2017 838.00 100,000.00 99,875.00 100,235.00 875.00 0.87 US Treasury Note 11/15/2017 869.00 100,000.00 99,425.78 100,196.00 875.00 0.87 US Treasury Note 11/30/2015 153.00 60,000.00 61,936.72 60,325.80 825.00 1.37 US Treasury Note 5/31/2016 336.00 190,000.00 197,094.74 192,494.70 3,325.00 1.73 US Treasury Note 2/28/2018 974.00 50,000.00 49,585.94 49,805.00 375.00 0.75 US Treasury Note 7/15/2017 746.00 100,000.00 99,664.06 100,422.00 875.00 0.87 Total Fixed Income 1,275,000.00 1,340,925.43 1,322,615.00 32,556.00 2.46% Total Assets 682.72 1,303,054.38 1,368,979.81 1,350,669.38 32,580.00 2.41% Capital Recovery Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Prime Mmkt Port Fd #690 65,894.50 65,894.50 65,894.50 58.00 0.09 Total Cash & Equivalents 65,894.50 65,894.50 65,894.50 58.00 0.09% Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 169.00 200,000.00 230,779.00 204,224.00 9,750.00 4.77 Federal Natl Mtg Assn 10/26/2017 849.00 125,000.00 124,588.38 125,086.25 1,093.00 0.87 Federal Home LN Mtg Corp Reference Nts 11/17/2017 871.00 100,000.00 109,860.00 110,059.00 5,125.00 4.66 Federal Home Mtg Corp Refrnce 8 6/13/2018 1079.00 200,000.00 221,887.60 222,220.00 9,750.00 4.39 Federal Home LN Mtg Corp 3/27/2019 1366.00 100,000.00 108,297.40 108,681.00 3,750.00 3.45 US Treasury Note 3/15/2017 624.00 150,000.00 149,753.91 150,540.00 1,125.00 0.75 US Treasury Note 10/15/2017 838.00 100,000.00 99,644.53 100,235.00 875.00 0.87 US Treasury Note 10/31/2019 1584.00 50,000.00 49,998.05 50,031.50 750.00 1.50 US Treasury Note 11/15/2017 869.00 100,000.00 99,425.78 100,196.00 875.00 0.87 US Treasury Note 5/31/2016 336.00 150,000.00 156,243.16 151,969.50 2,625.00 1.73 US Treasury Note 2/28/2018 974.00 100,000.00 99,175.78 99,610.00 750.00 0.75 US Treasury Note 7/15/2016 381.00 240,000.00 239,781.76 240,674.40 1,500.00 0.62 Total Fixed Income 1,615,000.00 1,689,435.35 1,663,526.65 37,968.00 2.28% Total Assets 689.79 1,680,894.50 1,755,329.85 1,729,421.15 38,026.00 2.20% 69