Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
12-SEPTEMBER 2013 FINANCIAL STATEMENT
SEPTEMBER 2013 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department December 18, 2013 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 13,247,165 622,786.88 12,317,912.54 13,973,732.64 - (726,567.64) 105.48% Franchises 1,665,763 143,338.44 1,567,035.04 1,609,891.59 - 55,871.41 96.65% Permits 1,216,840 80,088.44 1,075,833.02 1,320,630.78 - (103,790.78) 108.53% Licenses 70,200 5,210.00 70,467.50 78,150.50 - (7,950.50) 111.33% Fees 2,997,169 193,699.61 2,928,793.49 3,016,060.84 - (18,891.84) 100.63% Fines 25,000 2,460.16 28,543.30 30,256.69 - (5,256.69) 121.03% Inter-Jurisdictional 640,167 436,675.25 646,583.64 953,750.97 - (313,583.97) 148.98% Fund Transfers 1,964,042 (170,364.75) 1,349,652.08 1,663,426.26 - 300,615.74 84.69% Miscellaneous 455,547 142,949.89 902,591.46 509,178.65 - (53,631.65) 111.77% TOTAL REVENUES 22,281,893 1,456,843.92 20,887,412.07 23,155,078.92 - (873,185.92) 103.92% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 22,606 2,288.02 20,917.33 21,897.54 - 708.46 96.87% Supplies 400 25.60 697.25 645.89 - (245.89) 161.47% City Support Services 40,215 179.99 8,141.59 40,056.85 - 158.15 99.61% Operations Support 500 - 7.20 482.76 - 17.24 96.55% Staff Support 23,750 1,817.01 16,964.20 21,463.00 895.15 1,391.85 94.14% Operating Equipment 700 - - - - 700.00 0.00% TOTAL CITY COUNCIL 88,171 4,310.62 46,727.57 84,546.04 895.15 2,729.81 96.90% CITY MANAGER Personnel Services 924,280 97,737.23 861,685.46 951,751.16 - (27,471.16) 102.97% Supplies 4,100 94.44 3,032.03 1,081.50 - 3,018.50 26.38% Operations Support 100 - 45.00 - - 100.00 0.00% Staff Support 39,550 8,527.99 26,253.65 32,092.92 156.24 7,300.84 81.54% Operating Equipment - - - - - - 0.00% TOTAL CITY MANAGER 968,030 106,359.66 891,016.14 984,925.58 156.24 (17,051.82) 101.76% *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 1 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 MUNICIPAL COURT Personnel Services 281,300 27,075.30 259,995.60 263,449.64 - 17,850.36 93.65% Supplies 3,000 410.30 1,910.27 2,397.86 - 602.14 79.93% City Support Services 1,000 - 1,000.00 - - 1,000.00 0.00% Operations Support 3,500 - 2,767.00 4,176.00 - (676.00) 119.31% Staff Support 7,100 518.03 2,763.61 3,538.44 260.00 3,301.56 53.50% Court Support 800 - - 120.00 - 680.00 15.00% Professional Services 65,250 3,299.10 51,944.63 51,543.04 - 13,706.96 78.99% Maintenance Services 2,800 100.00 1,849.94 1,400.00 600.00 800.00 71.43% Operating Equipment 800 - 497.14 - - 800.00 0.00% TOTAL MUNICIPAL COURT 365,550 31,402.73 322,728.19 326,624.98 860.00 38,065.02 89.59% CUSTOMER RELATIONS-311 Personnel Services 107,853 10,826.78 102,582.61 104,689.04 - 3,163.96 97.07% Supplies 200 32.76 279.37 49.86 - 150.14 24.93% Staff Support 1,750 - 710.42 336.00 - 1,414.00 19.20% Operating Equipment 500 - 213.00 - - 500.00 0.00% TOTAL CUSTOMER RELATIONS-311 110,303 10,859.54 103,785.40 105,074.90 - 5,228.10 95.26% PLANNING & ZONING Personnel Services 119,973 11,952.69 139,027.98 108,698.66 - 11,274.34 90.60% Supplies 2,850 518.72 1,689.39 1,752.59 - 1,097.41 61.49% Operations Support 495 28.00 91.78 199.88 - 295.12 40.38% Staff Support 16,415 8,397.05 8,800.10 10,483.47 65.00 5,866.53 64.26% Professional Services 46,150 - 78,082.16 40,602.97 - 5,547.03 87.98% Operating Equipment - - 2,112.00 - - - 0.00% TOTAL PLANNING & ZONING 185,883 20,896.46 229,803.41 161,737.57 65.00 24,080.43 87.05% LEGAL SERVICES Operations Support 12,000 5,051.09 6,483.81 9,021.09 84.76 2,894.15 75.88% Professional Services 348,000 134,650.32 544,310.15 502,310.23 - (154,310.23) 144.34% TOTAL LEGAL SERVICES 360,000 139,701.41 550,793.96 511,331.32 84.76 (151,416.08) 142.06% 2 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 FACILITIES MAINTENANCE Personnel Services 565,203 58,465.97 603,986.41 566,441.68 - (1,238.68) 100.22% Supplies 68,897 5,431.96 63,627.51 65,906.65 140.00 2,850.35 95.86% Utility Services 104,848 22,332.13 99,751.73 101,364.01 - 3,483.99 96.68% Staff Support 12,699 2,773.20 9,726.13 11,442.50 210.65 1,045.85 91.76% Maintenance Services 62,953 3,845.61 96,696.38 53,838.19 - 9,114.81 85.52% Rental/Leasing 459 - 331.59 458.25 - 0.75 99.84% Operating Equipment 2,450 2,527.09 7,895.35 2,527.09 - (77.09) 103.15% TOTAL FACILITIES MAINTENANCE 817,509 95,375.96 882,015.10 801,978.37 350.65 15,179.98 98.14% BUILDING 6-8 MAINTENANCE Supplies 29,400 6,401.86 - 27,405.67 - 1,994.33 93.22% Utility Services 91,700 18,500.65 - 80,250.61 - 11,449.39 87.51% Maintenance Services 65,650 8,020.83 - 47,131.35 550.00 17,968.65 72.63% Operating Equipment 10,650 - - 9,249.00 1,049.93 351.07 96.70% TOTAL BUILDING 6-8 MAINTENANCE 197,400 32,923.34 - 164,036.63 1,599.93 31,763.44 83.91% CITY SECRETARY Personnel Services 168,506 17,166.77 166,334.05 148,707.99 - 19,798.01 88.25% Supplies 1,250 86.88 1,000.45 674.76 - 575.24 53.98% City Support Services 7,500 - 2,606.65 7,087.78 - 412.22 94.50% Staff Support 7,850 487.75 7,393.50 4,568.47 210.83 3,070.70 60.88% TOTAL CITY SECRETARY 185,106 17,741.40 177,334.65 161,039.00 210.83 23,856.17 87.11% NON-DEPARTMENTAL Supplies - - 201.28 - - - 0.00% City Support Services 357,000 36,518.46 289,505.45 352,631.71 32,341.00 (27,972.71) 107.84% Operations Support 154,500 18,590.62 161,025.62 135,012.93 - 19,487.07 87.39% Staff Support - - 96.90 12.88 - (12.88) 0.00% City Assistance 699,433 - 481,160.88 671,153.77 - 28,279.23 95.96% Professional Services 178,520 2,521.36 88,300.01 94,195.56 - 84,324.44 52.76% Fund Chrgs/Transfrs-Spec Events Fnd 220,000 4,196.41 63,270.40 169,196.41 - 50,803.59 76.91% Operating Equipment 269 - - 269.00 - - 100.00% Capital Outlay - - 204,762.25 - - - 0.00% TOTAL NON-DEPARTMENTAL 1,609,722 61,826.85 1,288,322.79 1,422,472.26 32,341.00 154,908.74 90.38% 3 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 PUBLIC AFFAIRS Personnel Services 286,253 19,881.31 277,733.16 240,523.44 - 45,729.56 84.02% Supplies 3,500 393.81 2,799.89 3,021.20 148.90 329.90 90.57% Operations Support 27,100 12,820.97 30,649.97 28,083.32 219.95 (1,203.27) 104.44% Staff Support 5,900 52.00 3,584.57 3,101.40 - 2,798.60 52.57% TOTAL PUBLIC AFFAIRS 322,753 33,148.09 314,767.59 274,729.36 368.85 47,654.79 85.23% RECORDS MANAGEMENT Personnel Services 48,144 5,075.97 48,230.45 47,999.80 - 144.20 99.70% Supplies 5 35.26 259.47 40.54 - (35.54) 810.80% Staff Support 1,460 - 1,109.75 1,230.65 - 229.35 84.29% Professional Services 12,000 159.50 7,003.66 11,247.76 - 752.24 93.73% Operating Equipment 495 - - 360.22 83.77 51.01 89.69% TOTAL RECORDS MANAGEMENT 62,104 5,270.73 56,603.33 60,878.97 83.77 1,141.26 98.16% SCHERTZ TALES MAGAZINE Personnel Services 130,560 14,059.47 131,413.25 132,286.41 - (1,726.41) 101.32% Supplies 200 - 175.83 200.00 - - 100.00% Opperations Support 200 22.50 - 22.50 - 177.50 11.25% Staff Support 2,005 - 1,249.08 770.82 - 1,234.18 38.44% Professional Services 300,700 27,134.89 286,893.88 275,400.43 125.00 25,174.57 91.63% Fund Charges/Transfers 10,000 9,250.00 - 9,250.00 - 750.00 92.50% TOTAL SCHERTZ TALES MAGAZINE 443,665 50,466.86 419,732.04 417,930.16 125.00 25,609.84 94.23% ENGINEERING Personnel Services 211,873 9,049.27 70,807.73 122,200.29 - 89,672.71 57.68% Supplies 1,100 201.42 1,083.30 643.03 116.93 340.04 69.09% Utility Services 1,440 196.46 474.62 787.91 - 652.09 54.72% Operations Support - - - 195.00 - (195.00) 0.00% Staff Support 6,741 222.20 506.99 1,598.45 - 5,142.55 23.71% Professional Services 80,216 11,697.24 91,322.46 79,000.26 - 1,215.74 98.48% Maintenance Services - - 3,345.29 - - - 0.00% Operating Equipment 2,000 292.13 4,561.30 292.13 - 1,707.87 14.61% Capital Outlay - - 23,714.00 - - - 0.00% TOTAL ENGINEERING 303,370 21,658.72 195,815.69 204,717.07 116.93 98,536.00 67.52% 4 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 GIS Personnel Services 128,356 14,424.01 125,472.35 128,653.85 - (297.85) 100.23% Supplies 2,800 85.57 1,736.15 1,414.74 110.00 1,275.26 54.46% Staff Support 2,725 - - 1,781.41 - 943.59 65.37% Professional Services 1,500 - 14.00 306.56 - 1,193.44 20.44% TOTAL GIS 135,381 14,509.58 127,222.50 132,156.56 110.00 3,114.44 97.70% TOTAL GENERAL GOVERNMENT 6,154,947 646,451.95 5,606,668.36 5,814,178.77 37,368.11 303,400.12 95.07% PUBLIC SAFETY POLICE Personnel Services 4,661,502 504,095.45 4,506,017.26 4,687,294.99 - (25,792.99) 100.55% Supplies 47,811 10,470.01 46,484.35 47,345.57 186.31 279.12 99.42% City Support Services 20,657 - 19,518.41 20,657.01 - (0.01) 100.00% Utility Services 132,735 24,739.76 120,732.77 132,016.12 - 718.88 99.46% Operations Support 2,596 764.95 1,565.00 3,271.92 82.00 (757.92) 129.20% Staff Support 59,959 20,521.89 45,126.80 62,329.01 - (2,370.01) 103.95% City Assistance 3,005 30.00 9,733.34 781.36 - 2,223.64 26.00% Professional Services 18,767 1,201.75 5,530.85 19,368.66 - (601.66) 103.21% Fund Charges/Transfers - 33,167.00 - 33,167.00 - (33,167.00) 0.00% Maintenance Services 42,979 4,579.00 43,700.14 38,557.21 6,000.00 (1,578.21) 103.67% Operating Equipment 143,277 17,459.82 97,711.00 153,832.10 1,438.74 (11,993.84) 108.37% Capital Outlay 210,961 - 142,521.25 164,584.50 - 46,376.50 78.02% TOTAL POLICE 5,344,249 617,029.63 5,038,641.17 5,363,205.45 7,707.05 (26,663.50) 100.50% FIRE RESCUE Personnel Services 2,593,286 274,585.26 2,468,151.63 2,659,969.36 - (66,683.36) 102.57% Supplies 16,200 999.70 16,913.31 4,707.15 1.00 11,491.85 29.06% Utility Services 51,500 9,564.95 50,353.26 52,845.04 - (1,345.04) 102.61% Operations Support 1,200 - 552.03 689.35 - 510.65 57.45% Staff Support 113,800 10,703.84 103,614.25 105,875.02 372.09 7,552.89 93.36% City Assistance 16,200 5,695.65 14,611.67 8,846.59 - 7,353.41 54.61% Professional Services 17,000 - 12,148.19 11,430.00 - 5,570.00 67.24% Maintenance Services 49,900 4,978.20 42,081.04 27,294.57 - 22,605.43 54.70% Operating Equipment 62,379 12,256.53 40,412.30 49,265.14 - 13,113.86 78.98% Capital Outlay - - 31,116.00 - - - 0.00% TOTAL FIRE RESCUE 2,921,465 318,784.13 2,779,953.68 2,920,922.22 373.09 169.69 99.99% 5 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 INSPECTIONS Personnel Services 428,700 47,487.80 423,245.18 429,678.09 - (978.09) 100.23% Supplies 2,638 - 1,997.75 1,840.56 - 797.44 69.77% City Support Services - - 594.50 - - - 0.00% Utility Services 6,500 1,082.30 5,918.62 6,218.82 - 281.18 95.67% Operations Support 1,777 456.13 561.00 1,586.01 - 190.99 89.25% Staff Support 7,574 945.63 3,770.64 5,920.77 130.00 1,523.23 79.89% Professional Services 7,594 - - - - 7,594.00 0.00% Operating Equipment 545 544.58 - 544.58 - 0.42 99.92% TOTAL INSPECTIONS 455,328 50,516.44 436,087.69 445,788.83 130.00 9,409.17 97.93% MARSHAL SERVICE Personnel Services 545,219 57,135.03 520,009.91 538,427.78 - 6,791.22 98.75% Supplies 4,300 99.97 3,090.93 1,024.45 - 3,275.55 23.82% Utility Services 16,000 2,158.15 15,363.08 15,447.83 - 552.17 96.55% Operations Support 4,000 - 1,477.84 706.96 186.00 3,107.04 22.32% Staff Support 11,600 1,616.69 7,372.33 5,402.51 - 6,197.49 46.57% City Assistance - 30.00 - 30.00 - (30.00) 0.00% Maintenance Services 16,500 1,157.23 7,922.31 10,183.23 - 6,316.77 61.72% Operating Equipment 21,000 7,611.48 17,967.09 10,451.99 1,476.46 9,071.55 56.80% Capital Outlay - - 25,545.00 - - - 0.00% TOTAL MARSHAL SERVICE 618,619 69,808.55 598,748.49 581,674.75 1,662.46 35,281.79 94.30% TOTAL PUBLIC SAFETY 9,339,661 1,056,138.75 8,853,431.03 9,311,591.25 9,872.60 18,197.15 99.81% 6 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 PUBLIC ENVIRONMENT STREETS Personnel Services 688,834 71,396.08 668,662.64 656,431.47 - 32,402.53 95.30% Supplies 7,100 15.45 4,755.24 5,263.46 - 1,836.54 74.13% Utility Services 134,900 22,360.94 137,725.15 143,229.31 - (8,329.31) 106.17% Staff Support 10,265 1,075.82 6,960.25 6,674.66 - 3,590.34 65.02% Maintenance Services 165,400 11,050.53 154,737.66 134,485.07 - 30,914.93 81.31% Rental/Lease 200 - - - - 200.00 0.00% Operating Equipment 5,500 - 3,485.99 5,444.13 - 55.87 98.98% TOTAL STREETS 1,012,199 105,898.82 976,326.93 951,528.10 - 60,670.90 94.01% TOTAL PUBLIC ENVIRONMENT 1,012,199 105,898.82 976,326.93 951,528.10 - 60,670.90 94.01% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 503,327 50,321.92 488,159.61 498,800.24 - 4,526.76 99.10% Supplies 41,905 5,373.80 31,454.67 33,077.98 2,300.00 6,527.02 84.42% Utility Services 143,800 22,805.07 141,703.73 154,940.40 231.64 (11,372.04) 107.91% Operations Support 350 - - - - 350.00 0.00% Staff Support 8,823 2,123.92 7,892.18 7,146.02 129.45 1,547.53 82.46% Professional Services 46,615 8,905.84 63,140.15 43,399.34 5,417.50 (2,201.84) 104.72% Maintenance Services 18,495 897.00 17,337.65 14,043.98 - 4,451.02 75.93% Rental/Leasing 44,000 6,450.80 39,785.73 42,968.85 - 1,031.15 97.66% Operating Equipment 3,000 345.80 - 2,522.07 344.25 133.68 95.54% TOTAL PARKS DEPARTMENT 810,315 97,224.15 789,473.72 796,898.88 8,422.84 4,993.28 99.38% SWIM POOL Supplies 20,700 5,203.32 16,423.25 14,528.82 - 6,171.18 70.19% Utility Services 29,000 5,352.08 25,809.89 23,869.47 - 5,130.53 82.31% Staff Support 925 - 750.00 - - 925.00 0.00% Maintenance Services 203,378 925.60 192,793.95 187,971.25 - 15,406.75 92.42% Rental/Lease 500 - 208.20 - - 500.00 0.00% TOTAL SWIM POOL 254,503 11,481.00 235,985.29 226,369.54 - 28,133.46 88.95% 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 EVENT FACILITIES Personnel Services 56,535 5,888.93 55,839.74 53,452.59 - 3,082.47 94.55% Supplies 27,000 2,328.03 12,933.70 16,162.97 272.57 10,564.46 60.87% Utility Services 48,200 9,138.80 40,465.53 45,229.61 - 2,970.39 93.84% Operations Support 25,982 3,993.59 14,826.09 19,622.58 - 6,359.42 75.52% Staff Support 2,727 - 1,996.48 1,497.61 - 1,229.39 54.92% Professional Services 1,600 45.00 150.00 195.00 - 1,405.00 12.19% Operating Equipment 1,350 - 4,999.70 - - 1,350.00 0.00% TOTAL EVENT FACILITIES 163,394 21,394.35 131,211.24 136,160.36 272.57 26,961.13 83.50% TOTAL PARKS & RECREATION 1,228,212 130,099.50 1,156,670.25 1,159,428.78 8,695.41 60,087.87 95.11% CULTURAL LIBRARY Personnel Services 704,940 73,581.86 693,265.79 681,902.80 - 23,037.20 96.73% Supplies 12,000 1,159.59 9,425.39 10,980.64 - 1,019.36 91.51% Utility Services 51,000 13,181.94 51,106.62 55,857.02 - (4,857.02) 109.52% Operations Support 3,500 377.98 1,157.00 3,019.67 - 480.33 86.28% Staff Support 4,040 435.21 1,554.71 1,916.30 - 2,123.70 47.43% Professional Services 2,225 - 3,340.00 2,140.00 - 85.00 96.18% Maintenance Services 2,400 - 2,400.00 600.00 - 1,800.00 25.00% Operating Equipment 75,000 9,410.40 59,101.63 73,733.01 1,233.40 33.59 99.96% TOTAL LIBRARY 855,105 98,146.98 821,351.14 830,149.44 1,233.40 23,722.16 97.23% TOTAL CULTURAL 855,105 98,146.98 821,351.14 830,149.44 1,233.40 23,722.16 97.23% 8 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 HEALTH ANIMAL SERVICES Personnel Services 298,953 25,806.67 270,685.44 260,481.22 - 38,471.78 87.13% Supplies 23,500 5,928.53 23,307.81 23,792.08 100.00 (392.08) 101.67% Utility Services 11,200 2,500.92 10,976.92 12,371.87 - (1,171.87) 110.46% Operations Support 500 - - 346.95 - 153.05 69.39% Staff Support 12,760 3,089.58 8,642.58 8,051.93 - 4,708.07 63.10% City Assistance 13,500 3,032.70 10,958.17 13,327.55 - 172.45 98.72% Professional Services 14,655 4,356.75 12,482.30 13,559.76 - 1,095.24 92.53% Maintenance Services 7,280 443.38 4,625.15 4,117.22 - 3,162.78 56.56% Operating Equipment 9,000 2,790.95 4,639.14 5,912.44 - 3,087.56 65.69% TOTAL ANIMAL SERVICES 391,348 47,949.48 346,317.51 341,961.02 100.00 49,286.98 87.41% TOTAL HEALTH 391,348 47,949.48 346,317.51 341,961.02 100.00 49,286.98 87.41% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 287,476 37,786.79 285,642.31 302,109.41 - (14,633.41) 105.09% Supplies 2,920 71.04 318.24 541.51 - 2,378.49 18.54% City Support Services 395,762 5,780.37 276,233.90 295,458.06 35,000.00 65,303.94 83.50% Utility Services 167,866 16,737.49 172,111.60 190,552.04 25.19 (22,711.23) 113.53% Staff Support 18,330 497.98 16,537.12 16,887.04 1,344.46 98.50 99.46% Professional Services 2,500 - - - - 2,500.00 0.00% Maintenance Services 8,000 (258.71) 9,464.36 6,738.43 79.00 1,182.57 85.22% Operating Equipment 106,500 721.86 131,050.36 95,548.09 249.36 10,702.55 89.95% Capital Outlay - - 27,152.45 - - - 0.00% TOTAL INFORMATION TECHNOLOGY 989,354 61,336.82 918,510.34 907,834.58 36,698.01 44,821.41 95.47% 9 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 HUMAN RESOURCES Personnel Services 311,710 28,599.17 270,981.45 285,735.57 - 25,974.43 91.67% Supplies 1,329 699.75 1,827.54 1,192.76 100.59 35.65 97.32% Human Services 55,156 6,279.53 40,511.97 42,104.61 200.00 12,851.39 76.70% Operations Support 16,596 2,028.00 7,773.25 10,982.31 960.00 4,653.69 71.96% Staff Support 14,897 3,371.92 10,033.71 14,369.36 - 527.64 96.46% City Assistance 9,860 2,603.91 8,716.50 11,550.41 - (1,690.41) 117.14% Operating Equipment - - 6,289.27 - - - 0.00% TOTAL HUMAN RESOURCES 409,548 43,582.28 346,133.69 365,935.02 1,260.59 42,352.39 89.66% FINANCE Personnel Services 443,306 48,665.89 436,913.35 443,526.16 - (220.16) 100.05% Supplies 2,732 263.74 2,997.95 2,761.73 - (29.73) 101.09% Operations Support 987 - 197.50 986.50 - 0.50 99.95% Staff Support 16,576 1,281.10 6,983.52 6,956.05 - 9,619.95 41.96% Rental/Leasing - - 502.32 - - - 0.00% Operating Equipment 1,795 25.00 266.47 1,795.00 - - 100.00% TOTAL FINANCE 465,396 50,235.73 447,861.11 456,025.44 - 9,370.56 97.99% PURCHASING & ASSET MGT Personnel Services 246,662 26,817.89 245,562.36 248,324.37 - (1,662.37) 100.67% Supplies 619 - 6,456.73 520.36 - 98.64 84.06% Utility Services 500 81.91 419.85 459.94 - 40.06 91.99% Operations Support 25 - 5.20 13.19 - 11.81 52.76% Staff Support 7,635 1,097.41 4,524.15 6,007.26 - 1,627.74 78.68% Operating Equipment 2,270 - 7,590.82 - 1,821.69 448.31 80.25% TOTAL PURCHASING & ASSET MGT 257,711 27,997.21 264,559.11 255,325.12 1,821.69 564.19 99.78% 10 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 FLEET SERVICE Personnel Services 218,528 22,520.68 186,524.62 182,982.38 - 35,545.62 83.73% Supplies 160,182 20,757.41 130,444.10 164,310.57 22.78 (4,151.35) 102.59% City Support Services 2,400 - 1,500.00 2,388.00 - 12.00 99.50% Utility Services 7,200 636.49 3,709.92 3,869.08 - 3,330.92 53.74% Operations Support 368 - - 142.00 - 226.00 38.59% Staff Support 4,500 156.82 2,894.91 1,943.64 - 2,556.36 43.19% Maintenance Services 94,250 10,359.87 69,411.00 98,240.86 - (3,990.86) 104.23% Rental/Lease 200 - 269.80 - - 200.00 0.00% Operating Equipment 5,000 - 4,931.79 9,451.28 - (4,451.28) 189.03% TOTAL FLEET SERVICE 492,628 54,431.27 399,686.14 463,327.81 22.78 29,277.41 94.06% BUILDING MAINTENANCE Personnel Services 75,142 9,895.28 - 71,555.43 - 3,586.57 95.23% Supplies 43 - - - - 43.00 0.00% Utility Services 2,952 624.46 - 2,712.48 - 239.52 91.89% Staff Support 675 97.73 - 582.40 - 92.60 86.28% Professional Services - - - 12,622.50 - (12,622.50) 0.00% Maintenance Services 67,788 10,783.04 - 60,292.62 - 7,495.38 88.94% Rental/Leasing 1,400 - - 375.00 - 1,025.00 26.79% Operating Equipment - - - 539.50 - (539.50) 0.00% Capital Outlay 41,781 - - - 12,127.50 29,653.50 29.03% TOTAL BUILDING MAINTENANCE 189,781 21,400.51 - 148,679.93 12,127.50 28,973.57 84.73% TOTAL INTERNAL SERVICE 2,804,418 258,983.82 2,376,750.39 2,597,127.90 51,930.57 155,359.53 94.46% 11 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 MISC & PROJECTS CITY ASSISTANCE Utility Services - - 281.17 - - - 0.00% Patient Assistance 5,000 - 5,000.00 5,000.00 - - 100.00% Children's Advocacy Assistance 5,000 - 5,000.00 5,000.00 - - 100.00% Senior Citizen's Hot Meals 42,000 - 42,000.00 42,000.00 - - 100.00% TOTAL CITY ASSISTANCE 52,000 - 52,281.17 52,000.00 - - 100.00% COURT - RESTRICTED FUNDS Operating Equipment 51,053 731.00 15,019.00 21,081.90 4,910.00 25,061.10 50.91% TOTAL CITY ASSISTANCE 51,053 731.00 15,019.00 21,081.90 4,910.00 25,061.10 50.91% TOTAL MISC & PROJECTS 103,053 731 67,300 73,082 4,910 25,061.10 75.68% TOTAL EXPENDITURES 21,888,943 2,344,400.30 20,204,815.78 21,079,047.16 114,110.09 695,785.81 96.82% REVENUE OVER(UNDER) EXPEND.392,950 2,076,031.76 12 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 7,481,207 7,179.89 6,883,059.48 7,473,920.14 - 7,286.86 99.90% 000-411200 Advalorem Tax - Delinquent 50,000 2,145.56 51,218.71 49,256.84 - 743.16 98.51% 000-411300 Advalorem Tax - P&I 50,000 1,786.30 36,174.06 42,219.44 - 7,780.56 84.44% 000-411400 Roll Back Property Tax - - 9,855.84 - - - 0.00% 000-411500 Sales Tax Revenue-Gen Fund 5,637,958 611,675.13 5,309,018.16 6,377,915.45 - (739,957.45) 113.12% 000-411700 Mixed Beverage Tax 28,000.00 - 28,586.29 30,420.77 - (2,420.77) 108.65% TOTAL Taxes 13,247,165 622,786.88 12,317,912.54 13,973,732.64 - (726,567.64) 105.48% Franchises 000-421200 Center Point/Entex Energy 58,763 2,877.00 52,073.49 58,473.50 - 289.50 99.51% 000-421220 City Public Service 375,000 35,538.13 366,987.06 408,101.99 - (33,101.99) 108.83% 000-421240 Guadalupe Valley Elec Co-op 430,000 45,650.84 405,517.17 413,489.96 - 16,510.04 96.16% 000-421250 New Braunfels Utilities 50,000 5,557.22 55,203.48 52,977.17 - (2,977.17) 105.95% 000-421300 Time Warner-State Franchise 350,000 29,747.23 329,900.47 324,526.45 - 25,473.55 92.72% 000-421460 AT&T Franchise Fee 190,000 17,749.53 198,647.25 237,169.69 - (47,169.69) 124.83% 000-421480 Other Telecom Franchise 110,000 151.98 55,721.08 8,953.39 - 101,046.61 8.14% 000-421500 Solid Waste Franchise Fee 102,000 6,066.51 102,985.04 106,199.44 - (4,199.44) 104.12% TOTAL Franchises 1,665,763 143,338.44 1,567,035.04 1,609,891.59 - 55,871.41 96.65% Permits 000-431100 Home Occupation Permit 490 35.00 350.00 490.00 - - 100.00% 000-431205 Building Permit - Residential 408,618 23,716.00 418,487.00 451,914.00 - (43,296.00) 110.60% 000-431210 Building Permit - Commercial 368,149 - 203,101.00 352,983.00 - 15,166.00 95.88% 000-431215 Building Permit - General 118,714 8,801.00 112,421.00 136,837.00 - (18,123.00) 115.27% 000-431300 Mobile Home Permit 325 50.00 250.00 575.00 - (250.00) 176.92% 000-431400 Signs Permit 1,700 672.00 2,934.00 6,139.00 - (4,439.00) 361.12% 000-431500 Food Establishmnt Permit 33,000 28,720.00 42,875.00 43,165.00 - (10,165.00) 130.80% 000-431600 Garage Sale Permit 8,160 815.00 11,680.00 12,070.00 - (3,910.00) 147.92% 000-431700 Plumbing Permit 117,324 6,444.00 113,237.34 125,023.65 - (7,699.65) 106.56% 000-431750 Electrical Permit 45,020 3,300.00 47,710.50 59,720.00 - (14,700.00) 132.65% 000-431800 Mechanical Permit 48,440 3,160.00 54,600.00 56,520.00 - (8,080.00) 116.68% 000-431900 Solicitor/Peddler Permit 1,000 - 1,640.00 1,670.00 - (670.00) 167.00% 000-431950 Animal/Pet Permit 2,000 95.00 2,175.00 1,895.00 - 105.00 94.75% 000-432000 Cert. of Occupancy Prmt 10,900 850.00 7,300.00 5,700.00 - 5,200.00 52.29% ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 13 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 000-432100 Security Alarm Permit 45,000 2,282.44 48,747.18 46,071.44 - (1,071.44) 102.38% 000-432300 Grading/Clearing Permit - - - 2,482.69 - (2,482.69) 0.00% 000-435000 Fire Permit 8,000 1,148.00 8,325.00 17,375.00 - (9,375.00) 217.19% TOTAL Permits 1,216,840 80,088.44 1,075,833.02 1,320,630.78 - (103,790.78) 108.53% Licenses 000-441000 Alcohol Beverage License 6,000 30.00 5,497.50 6,359.50 - (359.50) 105.99% 000-441300 Mobile Home License 200 - 80.00 160.00 - 40.00 80.00% 000-442000 Contractors License 60,000 4,765.00 60,410.00 67,070.00 - (7,070.00) 111.78% 000-444000 Pet License 4,000 415.00 4,480.00 4,561.00 - (561.00) 114.03% TOTAL Licenses 70,200 5,210.00 70,467.50 78,150.50 - (7,950.50) 111.33% Fees 000-451000 Municipal Court Fines 1,610,000 88,236.11 1,479,052.50 1,399,196.55 - 210,803.45 86.91% 000-451100 Arrest Fee 52,734 4,052.77 63,266.74 63,287.45 - (10,553.45) 120.01% 000-451110 Expunction Fee 120 - 30.00 30.00 - 90.00 25.00% 000-451200 Warrant Fees 138,500 8,527.26 141,399.79 160,736.78 - (22,236.78) 116.06% 000-451210 Court - Claims & Judgements - - 1,642.43 (388.00) - 388.00 0.00% 000-451320 Civil Justice Fee-Court 82 6.34 99.78 98.43 - (16.43) 120.04% 000-451321 Civil Justice Fee-State 737 57.13 900.23 886.91 - (149.91) 120.34% 000-451340 Judicial Fee - City 7,022 529.87 8,299.88 8,444.95 - (1,422.95) 120.26% 000-451400 Traffic Fine Costs TTL 27,011 2,069.09 32,623.27 32,351.99 - (5,340.99) 119.77% 000-451500 Teen Court Admin Fee 500 - 440.00 220.00 - 280.00 44.00% 000-451510 Juvenile Case Mgmt Fee 58,582 4,415.41 69,234.94 70,434.51 - (11,852.51) 120.23% 000-451600 Technology Fund Fee 47,122 3,516.20 55,633.85 56,488.00 - (9,366.00) 119.88% 000-451700 Security Fee 34,340 2,637.15 41,725.43 42,366.00 - (8,026.00) 123.37% 000-451800 Time Payment Fee - City 5,598 462.29 5,389.25 6,328.80 - (730.80) 113.05% 000-451850 State Fines 10% Service Fee 61,204 - 68,804.90 88,442.58 - (27,238.58) 144.50% 000-451900 DPS Payment - Local 10,956 680.00 11,135.07 12,695.88 - (1,739.88) 115.88% 000-452000 Child Safety Fee 23,000 1,109.12 24,951.32 19,318.96 - 3,681.04 84.00% 000-452050 Indigent Defense Fee 22,524 1,742.91 26,957.49 27,763.50 - (5,239.50) 123.26% 000-452100 Platting Fees 77,000 1,500.00 65,500.00 49,811.00 - 27,189.00 64.69% 000-452200 Site Plan Fee 30,000 3,000.00 24,000.00 25,500.00 - 4,500.00 85.00% 000-452300 Plan Check Fee 289,401 15,315.00 349,668.50 456,942.50 - (167,541.50) 157.89% 000-452310 Miscellaneous Review Fee 10,800 - 6,000.02 600.00 - 10,200.00 5.56% 000-452320 Tree Mitigation Admin Fee 10,500 - 12,200.25 3,277.50 - 7,222.50 31.21% 000-452400 BOA/Zoning Fees 6,500 - 3,250.00 4,000.00 - 2,500.00 61.54% 000-452500 Food Handler Class 3,000 80.00 17,150.00 18,094.00 - (15,094.00) 603.13% 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 000-452520 Fire Training Classes 1,000 - - - - 1,000.00 0.00% 000-452600 Specific Use/Zone Chng Fee 47,700 500.00 30,500.00 22,500.00 - 25,200.00 47.17% 000-452710 Zoning Ltr & Dev Rights 2,100 450.00 1,950.00 1,800.00 - 300.00 85.71% 000-453100 Reinspection Fees 39,500 3,375.00 40,200.00 34,650.00 - 4,850.00 87.72% 000-453110 Swim Pool Inspection Fee 1,000 - 1,500.00 1,725.00 - (725.00) 172.50% 000-453200 Lot Abatement 5,000 435.00 2,798.43 9,755.71 - (4,755.71) 195.11% 000-453211 Admin Fee-Inspections 7,480 600.00 8,940.00 5,300.00 - 2,180.00 70.86% 000-453310 Misc Inspection Fee 250 - 269.49 - - 250.00 0.00% 000-453710 Foster Care 750 - 700.00 1,150.00 - (400.00) 153.33% 000-454100 Swim Pool Reservation Fee - - 55.00 - - - 0.00% 000-454200 Pool Gate Admission Fee 20,000 - 23,949.31 23,163.75 - (3,163.75) 115.82% 000-454300 Seasonal Pool Pass Fee 7,500 - 5,034.50 5,665.00 - 1,835.00 75.53% 000-456500 Haz Mat Fees 1,500 - 6,984.73 1,250.00 - 250.00 83.33% 000-456600 Fire Re-inspection Fee 750 - 700.00 1,100.00 - (350.00) 146.67% 000-458110 Sale of Merchandise-GovDeal - - 36.50 5,073.63 - (5,073.63) 0.00% 000-458300 Sale of Property/Auction 25,000 (88.89) 20,740.93 2,667.81 - 22,332.19 10.67% 000-458400 Civic Center Rental Fees 132,200 37,277.57 110,063.63 192,935.32 - (60,735.32) 145.94% 000-458401 Capital Recovery Fee-Civic Cntr 4,800 - 5,225.00 4,825.00 - (25.00) 100.52% 000-458450 North Center Rental Fees 23,000 4,586.98 22,093.33 21,996.98 - 1,003.02 95.64% 000-458500 Community Center Rental Fees 26,000 4,110.20 25,531.68 29,465.26 - (3,465.26) 113.33% 000-458550 Pavilion Rental Fees 18,000 2,095.00 17,577.00 19,053.50 - (1,053.50) 105.85% 000-458560 Chamber of Comm rent 11,700 - 7,800.00 7,800.00 - 3,900.00 66.67% 000-458570 Non-Resident SYSA League 19,000 - 16,030.00 7,845.00 - 11,155.00 41.29% 000-458650 NonResident User Fee-BVYA 17,000 - 8,860.00 9,550.00 - 7,450.00 56.18% 000-458660 BVYA Utility Reimbursement 5,000 - 9,517.56 2,952.98 - 2,047.02 59.06% 000-458670 SYSA Utility Reimbursement 7,500 - 6,578.61 2,999.36 - 4,500.64 39.99% 000-458675 Lions Futbol Utility Reimbursement - - - 9,288.00 - (9,288.00) 0.00% 000-458680 Tournament Fees-Soccer 3,000 - 7,625.00 600.00 - 2,400.00 20.00% 000-458700 Vehicle Impoundment 5,779 - 1,380.00 6,440.00 - (661.00) 111.44% 000-459200 NSF Check Fee 250 27.00 649.50 517.00 - (267.00) 206.80% 000-459300 Notary Fee 250 18.00 372.00 234.00 - 16.00 93.60% 000-459400 Maps, Copies, UDC, & Misc F 250 5.00 78.10 115.00 - 135.00 46.00% 000-459600 Animal Adoption Fee 14,000 1,380.00 12,609.00 16,564.50 - (2,564.50) 118.32% 000-459700 Pet Impoundment Fee 14,000 408.00 16,882.25 13,728.55 - 271.45 98.06% 000-459800 Police Reports Fee 8,677 584.10 6,206.30 6,421.20 - 2,255.80 74.00% TOTAL Fees 2,997,169 193,699.61 2,928,793.49 3,016,060.84 - (18,891.84) 100.63% 15 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 Fines 000-463000 Library Fines 25,000 2,460.16 28,543.30 30,256.69 - (5,256.69) 121.03% TOTAL Fines 25,000 2,460.16 28,543.30 30,256.69 - (5,256.69) 121.03% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,072 1,756.48 21,077.76 21,077.76 - (5.76) 100.03% 000-473200 City of Seguin - Fire Contract 31,452 3,355.26 40,263.12 40,263.12 - (8,811.12) 128.01% 000-473300 Guad Co - Library 208,343 34,723.82 190,815.96 208,342.92 - 0.08 100.00% 000-473400 Randolph AFB-Animal Cntrl 1,000 - 600.00 1,400.00 - (400.00) 140.00% 000-474200 Library Services - Cibolo 20,000 20,000.00 20,000.00 20,000.00 - - 100.00% 000-474210 Library Services-Selma 18,393 - 18,392.80 26,560.00 - (8,167.00) 144.40% 000-474400 Dispatch Service - Cibolo 133,305 33,326.25 133,305.00 133,305.00 - - 100.00% 000-474600 School Crossing Guard-Bexar 27,000 3,338.98 35,826.07 37,138.58 - (10,138.58) 137.55% 000-474610 School Cross Guard-Guadalupe 24,602 3,344.20 36,302.93 37,445.33 - (12,843.33) 152.20% 000-474620 School Crossing Guard-Comal - - - 1,388.00 - (1,388.00) 0.00% 000-474700 School Officer Funding 155,000 72,500.00 150,000.00 162,500.00 - (7,500.00) 104.84% 000-474800 CPS CIED Funding - 264,330.26 - 264,330.26 - (264,330.26) 0.00% TOTAL Inter-Jurisdictional 640,167 436,675.25 646,583.64 953,750.97 - (313,583.97) 148.98% Fund Transfers 000-480000 Indirect Costs - EMS 87,840 7,320.00 87,840.00 87,840.00 - - 100.00% 000-480100 Indirect Costs - Hotel/Motel 157,517 13,126.42 142,626.00 157,517.04 - (0.04) 100.00% 000-485000 Interfund Charge-Drainage 49,708 4,142.33 35,480.00 49,707.96 - 0.04 100.00% 000-486000 Interfund Chrges-Admin W&S 1,060,963 88,413.58 881,222.04 1,060,962.96 - 0.04 100.00% 000-486106 Transfer in-Special Events - - 1,000.00 - - - 0.00% 000-486202 Transfer In-W&S 80,000 - - - - 80,000.00 0.00% 000-486317 Transfer From Park Fund - - - - - - 0.00% 000-486322 Transfer-In - Library Grants - - - - - - 0.00% 000-487000 Interfund Charges-Fleet 112,761 9,396.75 98,484.00 112,761.00 - - 100.00% 000-488000 Interfund Charges-4B 243,350 (28,433.57) 53,000.04 194,637.30 - 48,712.70 79.98% 000-489000 Transfer In 171,903 (264,330.26) - - - 171,903.00 0.00% 000-489620 Contribution - SEDC - - 50,000.00 - - - 0.00% TOTAL Fund Transfers 1,964,042 (170,364.75) 1,349,652.08 1,663,426.26 - 300,615.74 84.69% 16 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 Miscellaneous 000-491000 Interest Earned 350 31.91 332.84 458.28 - (108.28) 130.94% 000-491200 Investment Income 45,000 2,750.72 47,914.66 41,975.16 - 3,024.84 93.28% 000-491800 Gain/Loss - (17.58) (9,810.33) (16,605.66) - 16,605.66 0.00% 000-491900 Unrealized Gain/Loss (26,000) 1,435.13 (19,284.88) (15,650.27) - (10,349.73) 0.00% 000-492100 Proceeds-Sale of Land - - 194,467.85 - - - 0.00% 000-493120 Donations-Public Library - - - 7,500.00 - (7,500.00) 0.00% 000-493130 Donations-Writing the Next Chap.2,000 - 5,331.34 325.00 - 1,675.00 16.25% 000-493400 Donation - Animal Control 4,000 242.50 4,473.09 2,219.55 - 1,780.45 55.49% 000-493401 Donations-A/C Microchip 2,000 115.00 1,990.00 1,585.00 - 415.00 79.25% 000-493402 Donations-Spay&Neuter 12,000 1,390.50 14,875.50 13,158.38 - (1,158.38) 109.65% 000-493503 Donations - Fire Rescue - - - 2,250.00 - (2,250.00) 0.00% 000-494481 LawEnforcemtOfficersStnd&Ed - - 50.00 - - - 0.00% 000-494482 Grants - Police 2,997 - 175,510.50 - - 2,997.00 0.00% 000-495040 Friends of N. Schertz Park - - 3,149.00 885.00 - (885.00) 0.00% 000-495100 Mobile Stage Rental Fees 2,000 - 2,850.00 1,550.00 - 450.00 77.50% 000-497000 Misc Income-Gen Fund 50,000 (5,876.83) 88,772.87 2,243.33 - 47,756.67 4.49% 000-497005 Schertztales Advertising 220,000 21,639.81 215,999.00 230,247.81 - (10,247.81) 104.66% 000-497007 Misc Income-Schertz Artz - 40.00 2.00 50.00 - (50.00) 0.00% 000-497100 Misc Income-Police 20,000 321.00 18,666.78 12,391.13 - 7,608.87 61.96% 000-497150 Misc Income-Fire Department - - 292.37 292.37 - (292.37) 0.00% 000-497200 Misc Income-Library 4,000 437.00 3,856.94 4,369.80 - (369.80) 109.25% 000-497210 Misc Income-Library Copier 12,000 1,491.65 13,433.81 14,571.57 - (2,571.57) 121.43% 000-497300 Misc Income-Animal Control 200 110.00 110.00 300.00 - (100.00) 150.00% 000-497400 Misc Income-Streets Dept.15,000 630.46 18,280.33 19,584.14 - (4,584.14) 130.56% 000-497500 Misc Income-TML Insurance 2,000 - 14,333.37 17,116.19 - (15,116.19) 855.81% 000-497550 Misc Income-TML Reimbursemt 15,000 - 18,978.28 19,792.84 - (4,792.84) 131.95% 000-497600 Misc Income-Vending Mach.2,000 167.13 1,755.13 2,433.23 - (433.23) 121.66% 000-498000 Reimbursmnt-Gen Fund 50,000 118,041.49 31,210.92 134,320.59 - (84,320.59) 268.64% 000-498100 Reimbursmnt Fire - Training 1,000 - - - - 1,000.00 0.00% 000-498105 Reimburmnt Police - DEA - - 8,059.69 6,075.89 - (6,075.89) 0.00% 000-498110 Reimbursmnt Fire - Emg. Acti-O 20,000 - 46,990.40 5,739.32 - 14,260.68 28.70% TOTAL Miscellaneous 455,547 142,949.89 902,591.46 509,178.65 - (53,631.65) 111.77% TOTAL REVENUES 22,281,893 1,456,843.92 20,887,412.07 23,155,078.92 - (873,185.92) 103.92% 17 Cash in Bank Claim on Operating Cash Pool-Checking 142,423.93$ Cash in Investments LOGIC Investment-General Fund 3,059,041.07 LOGIC Investment-Equip Replacement 73,577.50 LOGIC Investment-Veh Replacement 211,051.98 LOGIC Investment-Air Condi Replacment 171,404.60 CAPITAL ONE Investment-General Fund 1,342,348.59 Total Cash in Bank & Investments 5,146,429.51$ CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2013 GENERAL FUND 18 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 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,179.89 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 2009-10 1,277,006 1,642,355 702,874 1,730,904 562,689 (32,792)59,545 34,762 19,836 29,955 5,346 3,535 2008-09 703,350 1,823,090 757,602 1,345,602 699,462 114,537 10,514 45,087 36,659 25,468 13,593 21,472 ADVALOREM TAX 19 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 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 2008-09 332,597 414,845 371,763 300,829 434,646 298,499 282,410 394,233 317,296 310,159 373,041 315,947 2007-08 336,749 350,854 312,547 327,798 421,873 330,131 287,316 355,054 336,094 328,147 360,965 338,085 2% 24% 40% 2% 37% 14% 17% 23% 37% 38% 13% 11% $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 Sales Tax - General Fund 20 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 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 2009-10 77,354 61,468 63,276 80,716 2008-09 77,308 53,071 57,506 83,329 $- $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000 CITY PUBLIC SERVICE 21 106-SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 75,150.00 61,226.43 37,250.00 61,226.43 - 13,923.57 41.00% Wilenchik Walk for Life 31,000.00 - 26,451.06 20,846.16 - 10,153.84 104.23% Hal Balwin Scholarship 24,000.00 - 19,227.00 19,668.88 - 4,331.12 0.00% Miscellaneous 1,150.00 72.02 1,417.33 10,419.89 - (9,269.89) 144.72% TOTAL REVENUES 131,300.00 61,298.45 84,540.08 112,161.36 - 19,138.64 63.53% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 5,150.00 731.64 2,385.00 731.64 - 4,418.36 0.00% TOTAL GENERAL GOVERNMENT 5,150.00 731.64 2,385.00 731.64 - 4,418.36 0.00% CULTURAL Festival of Angels 14,750.00 - 13,050.46 16,017.55 - (1,267.55) 108.59% Employee Appreciation Event 6,485.00 - - 6,385.23 - 99.77 98.46% National Night Out 150.00 - - - - 150.00 0.00% Wilenchik Walk for Life 31,000.00 - 26,451.06 20,846.16 - 10,153.84 67.25% TML Events - - 194.69 - - - 0.00% Schertz Sweetheart 37,500.00 1,812.00 27,075.06 31,350.47 87.23 6,062.30 83.83% Jazzfest 20,000.00 - - 15,538.41 - 4,461.59 77.69% Hal Baldwin Scholarship 12,000.00 - 4,767.40 11,739.72 - 260.28 97.83% Other Events 4,265.00 - 10,340.89 2,337.13 - 1,927.87 54.80% TOTAL CULTURAL 126,150.00 1,812.00 81,879.56 104,214.67 87.23 21,848.10 82.68% TOTAL EXPENDITURES 131,300.00 2,543.64 84,264.56 104,946.31 87.23 26,266.46 80.00% REVENUE OVER(UNDER) EXPEND - 7,215.05 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************** 22 Cash in Bank Claim on Operating Cash Pool-Checking 75,090.49$ Cash in Investments MBIA Special Events 26,761.96 Total Cash in Bank & Investments 101,852.45$ CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2013 SPECIAL EVENTS FUND 23 110-PEG FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 98,000.00 35,543.61 92,518.90 93,261.18 - 4,738.82 95.16% Fund Transfers 33,000.00 - - - - 33,000.00 0.00% Miscellaneous - - 19.34 - - - 0.00% TOTAL REVENUES 131,000.00 35,543.61 92,538.24 93,261.18 - 37,738.82 71.19% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 131,000.00 6,340.98 123.19 45,545.88 - 85,454.12 34.77% TOTAL GENERAL GOVERNMENT 131,000.00 6,340.98 123.19 45,545.88 - 85,454.12 34.77% TOTAL EXPENDITURES 131,000.00 6,340.98 123.19 45,545.88 - 85,454.12 34.77% REVENUE OVER(UNDER) EXPEND - 47,715.30 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************** 24 110-PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421350 Time Warner - PEG Fee 65,000 - 62,966.10 57,717.57 - 7,282.43 88.80% 000-421465 AT&T PEG Fee 33,000 35,543.61 29,552.80 35,543.61 - (2,543.61) 107.71% TOTAL Franchises 98,000 35,544 92,518.90 93,261.18 - 4,738.82 95.16% Fund Transfers 000-481000 Transfer In - Reserves 33,000 - - - - 33,000.00 0.00% TOTAL Fund Transfers 33,000 - - - - 33,000.00 0.00% Miscellaneous 000-491000 Interest Earned - - 19.34 - - - 0.00% TOTAL Miscellaneous - - 19.34 - - - 0.00% TOTAL REVENUES 131,000 35,544 92,538.24 93,261 - 37,738.82 71.19% C I T Y O F S C H E R T Z ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************** REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 25 Cash in Bank Cash Balance 434,297.52$ Total Cash in Bank & Investments 434,297.52$ CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2013 PEG FUND 26 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 187,920 40,804.87 184,016.40 198,322.01 - (10,402.01) 105.54% Permits - - - 38,793.75 - (38,793.75) 0.00% Fees 14,655,376 1,164,088.05 14,873,696.43 15,190,454.77 - (535,078.77) 103.65% Fund Transfers 1,419,298 9,941.50 113,004.05 119,298.00 - 1,300,000.00 8.41% Miscellaneous 430,148 30,859.17 401,863.51 436,728.07 - (6,580.07) 101.53% TOTAL REVENUES 16,692,742 1,245,693.59 15,572,580.39 15,983,596.60 - 709,145.40 95.75% EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services 436,694 39,695.61 383,990.87 395,923.71 - 40,770.29 90.66% Supplies 4,517 1,499.26 4,754.12 4,011.88 - 505.12 88.82% Human Services 183 - 40.00 122.00 - 61.00 66.67% City Support Services 1,000 - - - - 1,000.00 0.00% Operations Support 110,000 9,338.86 96,538.49 106,067.64 - 3,932.36 96.43% Staff Support 7,150 140.18 3,892.56 2,711.35 43.30 4,395.35 38.53% Professional Services 23,000 2,070.62 23,383.49 22,423.15 - 576.85 97.49% Fund Charges/Transfers 20,000 4,714.81 - 4,714.81 - 15,285.19 23.57% Maintenance Services 11,000 - 7,060.00 9,800.00 680.00 520.00 95.27% Operating Equipment 2,300 - 5,932.94 1,452.44 - 847.56 63.15% TOTAL BUSINESS OFFICE 615,844 57,459.34 525,592.47 547,226.98 723.30 67,893.72 88.98% W & S ADMINISTRATION Personnel Services 1,184,013 114,209.75 1,021,524.69 1,062,234.02 - 121,778.98 89.71% Supplies 198,570 32,027.54 135,448.21 162,707.48 1,974.17 33,888.35 82.93% Human Services 1,000 - 596.00 398.00 - 602.00 39.80% City Support Services 73,650 - 35,389.59 47,615.04 - 26,034.96 64.65% Utility Services 2,728,163 311,979.52 3,358,895.04 3,180,990.47 - (452,827.83) 116.60% Operations Support 9,250 272.53 6,746.04 3,487.63 - 5,762.37 37.70% Staff Support 31,580 3,949.30 19,759.05 21,934.42 - 9,645.58 69.46% City Assistance 1,912 57.00 769.00 510.00 - 1,402.00 26.67% Professional Services 261,526 185,245.16 249,432.20 396,421.24 22,796.73 (157,691.97) 160.30% Fund Charges/Transfers 3,072,921 2,026,177.13 4,613,468.39 4,455,143.83 - (1,382,222.83) 144.98% Maintenance Services 5,604,250 909,445.13 5,786,835.63 5,925,359.29 1,880.00 (322,989.29) 105.76% Other Costs 40,000 - 30,956.44 29,541.85 - 10,458.15 73.85% ******************************************************* 2 0 1 2 - 2 0 1 3 ****************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 27 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ******************************************************* 2 0 1 2 - 2 0 1 3 ****************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 Debt Service 1,353,891 (8,982.16) 167,958.87 371,777.15 - 982,113.37 27.46% Rental-Leasing 6,070 - 3,215.95 3,570.91 - 2,499.09 58.83% Operating Equipment 6,400 - 20,107.19 1,840.76 399.98 4,159.26 35.01% Capital Outlay 188,000 - - - - 188,000.00 0.00% TOTAL PUBLIC WORKS 14,761,195 3,574,380.90 15,451,102.29 15,663,532.09 27,050.88 (929,387.81) 106.30% MISC & PROJECTS PROJECTS Professional Services - - - - - - 0.00% Fund Charges/Transfers 367,519 - - 367,519.00 - - 100.00% Maintenance Services 902,000 - - - - 902,000.00 0.00% TOTAL PROJECTS 1,269,519 - - 367,519.00 - 902,000.00 28.95% AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services 1,018 - - - - 1,018.00 0.00% Professional Services 31,963 - - - - 31,963.00 0.00% TOTAL AVIATION HEIGHTS WTR IMP 32,981 - - - - 32,981.00 0.00% TOTAL MISC & PROJECTS 1,302,500 - - 367,519.00 - 934,981.00 28.22% TOTAL EXPENDITURES 16,679,539 3,631,840 15,976,695 16,578,278 27,774 73,487 99.56% ** REVENUE OVER(UNDER)EXPENSES **13,203 (594,681.47) 28 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421490 Tower Leasing 187,920 40,804.87 184,016.40 198,322.01 - (10,402.01) 105.54% TOTAL Franchises 187,920 40,804.87 184,016.40 198,322.01 - (10,402.01) 105.54% Permits 000-432400 Development Permit - - - 38,793.75 - (38,793.75) 0.00% TOTAL Permits - - - 38,793.75 - (38,793.75) 0.00% Fees 000-455200 Garbage Collection Fee 3,600,000 257,120.26 3,427,008.45 3,542,592.37 - 57,407.63 98.41% 000-455600 Fire Line Fees 20,000 (196.06) 20,414.42 20,438.94 - (438.94) 102.19% 000-455700 Recycle Fee Revenue 250,000 16,707.21 244,053.82 253,932.16 - (3,932.16) 101.57% 000-455800 W&S Line Constructn Reimbursemnt 30,000 2,965.10 24,500.44 22,780.73 - 7,219.27 75.94% 000-457100 Sale of Water 7,279,626 588,103.76 7,657,695.38 7,660,164.74 - (380,538.74) 105.23% 000-457110 Edwards Water Lease 166,250 - 204,398.59 96,942.09 - 69,307.91 58.31% 000-457120 Water Transfer Charge-Selma 20,000 - 25,343.55 38,445.76 - (18,445.76) 192.23% 000-457130 Water Transfer Charge-U. C. 2,000 - 2,199.97 8,072.40 - (6,072.40) 403.62% 000-457140 Water Transfer Charge-Converse 15,000 - - 32,351.04 - (17,351.04) 215.67% 000-457200 Sale of Meters 90,000 4,106.56 60,849.16 56,719.24 - 33,280.76 63.02% 000-457400 Sewer Charges 3,000,000 279,558.46 3,023,567.38 3,271,096.18 - (271,096.18) 109.04% 000-457500 Water Penalties 180,000 15,522.76 180,795.27 182,379.12 - (2,379.12) 101.32% 000-458000 Sales of General Fixed Assets - - - 2,000.00 - (2,000.00) 0.00% 000-459200 NSF Check Fee-Water&Sewer 2,500 200.00 2,870.00 2,540.00 - (40.00) 101.60% TOTAL Fees 14,655,376 1,164,088.05 14,873,696.43 15,190,454.77 - (535,078.77) 103.65% Fund Transfers 000-481000 Transfer In- Reserve 1,300,000 - - - - 1,300,000.00 0.00% 000-486100 Transfer In - - 28,330.01 - - - 0.00% 000-486204 Interfnd Chrg-Drainage Bill 119,298 9,941.50 84,674.04 119,298.00 - - 100.00% TOTAL Fund Transfers 1,419,298 9,941.50 113,004.05 119,298.00 - 1,300,000.00 8.41% ******************************************************* 2 0 1 2 - 2 0 1 3 ****************************************************** AS OF: SEPTEMBER 30th, 2013 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 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ******************************************************* 2 0 1 2 - 2 0 1 3 ****************************************************** AS OF: SEPTEMBER 30th, 2013 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z Miscellaneous 000-490000 Misc Charges 200 - 779.62 5,912.78 - (5,712.78) 2956.39% 000-491000 Interest Earned 1,600 136.44 1,868.29 1,574.40 - 25.60 98.40% 000-491200 Investment Income 12,000 3,420.65 13,470.29 10,145.38 - 1,854.62 84.54% 000-493400 Donations-Christmas Activities - - 750.00 - - - 0.00% 000-495013 Capital Contribution - W&S - - (35,862.14) - - - 0.00% 000-496050 SSLG - SAWS Reservation 269,000 - 269,000.00 269,000.00 - - 100.00% 000-497000 Misc Income-W&S 40,000 1,205.41 47,833.43 47,140.43 - (7,140.43) 117.85% 000-498110 Reimbursement-SSLGC 107,348 26,096.67 104,024.02 102,955.08 - 4,392.92 95.91% TOTAL Miscellaneous 430,148 30,859.17 401,863.51 436,728.07 - (6,580.07) 101.53% TOTAL REVENUES 16,692,742 1,245,693.59 15,572,580.39 15,983,596.60 - 709,145.40 95.75% 30 Cash in Bank Claim on Operating Cash Pool-Checking 317,274.69$ Cash in Investments Lone Star Investment-Water&Sewer 38,008.24 Lone Star Investment-W&S Customer Deposits 294,896.92 Lone Star Investment-W&S Equip Replacement 24,632.04 Lone Star Investment-W&S Veh Replacement 46,258.36 Lone Star Investment-Water/SSLGC SAWS 324,373.55 Schertz Bank & Trust-Certificate of Deposit 1,060,132.25 1,788,301.36$ Total Cash in Bank & Investments 2,105,576.05$ CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2013 WATER & SEWER 31 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 4,149,402 365,155.28 3,521,402.69 4,741,743.69 (300.00) (592,041.69) 114.27% Inter-Jurisdictional 1,486,723 23,843.88 1,452,262.40 1,484,980.80 - 1,742.20 99.88% Miscellaneous 236,500 1,448.17 110,881.85 93,817.99 - 142,682.01 39.67% TOTAL REVENUES 5,872,625 390,447.33 5,084,546.94 6,320,542.48 (300.00) (447,617.48) 107.62% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 2,815,722 298,565.64 2,725,195.64 2,781,260.79 - 34,461.23 98.78% Supplies 317,089 32,121.84 296,155.61 316,289.02 5,985.27 (5,185.29) 101.64% Human Services 800 - 230.00 193.00 - 607.00 24.13% City Support Services 32,500 - 10,277.40 15,571.98 - 16,928.02 47.91% Utility Services 107,600 25,512.22 131,839.35 146,408.50 - (38,808.50) 136.07% Operations Support 52,652 2,564.01 48,482.65 53,827.12 - (1,175.12) 102.23% Staff Support 72,900 7,366.33 61,686.36 63,411.54 2,731.78 6,756.68 90.73% City Assistance 11,550 538.03 11,751.28 12,823.20 - (1,273.20) 111.02% Professional Services 165,886 22,954.42 122,075.35 151,294.47 4,124.52 10,467.01 93.69% Fund Charges/Transfers 1,980,055 147,532.55 1,668,784.10 1,578,108.82 - 401,946.18 79.70% Maintenance Services 53,700 2,117.70 39,633.52 31,414.90 - 22,285.10 58.50% Debt Service 110,545 - 12,465.50 8,521.36 - 102,023.31 7.71% Rental-Leasing 12,000 - - - - 12,000.00 0.00% Operating Equipment 124,200 9,482.56 43,008.12 112,321.06 4,657.77 7,221.17 94.19% Capital Outlay - - - - - - 0.00% TOTAL PUBLIC SAFETY 5,857,199 548,755.30 5,171,584.88 5,271,445.76 17,499.34 568,253.59 90.30% TOTAL EXPENDITURES 5,857,199 548,755.30 5,171,584.88 5,271,445.76 17,499.34 568,253.59 90.30% ** REVENUE OVER(UNDER) EXPENSES **15,426 1,049,096.72 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 32 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000-456100 Ambulance/Mileage Transport 3,908,602 354,069.78 3,431,478.49 4,640,214.69 - (731,612.69) 118.72% 000-456110 Subscription Program Fees 40,000 85.00 18,300.00 18,630.00 - 21,370.00 46.58% 000-456120 EMT Class - Fees 100,800 9,300.00 68,001.00 73,185.00 (300.00) 27,915.00 72.31% 000-459200 Paramedic Class Fees 100,000 - - - - 100,000.00 0.00% 000-456130 Immunization Fees - - 3,623.20 20.00 - (20.00) 0.00% 000-456140 Billing Fees - Alamo Heights - 1,700.50 - 9,029.00 - (9,029.00) 0.00% 000-458110 Sales of Merchandise - GovDeal - - - 645.00 - (645.00) 0.00% 000-459200 NSF Check Fee - - - 20.00 - (20.00) 0.00% TOTAL Fees 4,149,402 365,155.28 3,521,402.69 4,741,743.69 (300.00) (592,041.69) 114.27% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 286,126 23,843.88 286,126.56 286,401.56 - (275.56) 100.10% 000-474300 Cibolo Support 228,830 - 222,099.92 228,830.20 - (0.20) 100.00% 000-475100 Comal Co ESD #6 85,418 - 82,905.92 86,752.61 - (1,334.61) 101.56% 000-475200 Live Oak Support 165,188 - 160,329.52 165,187.96 - 0.04 100.00% 000-475300 Universal City Support 233,107 - 227,101.32 233,107.40 - (0.40) 100.00% 000-475400 Selma Support 69,693 - 67,643.40 69,693.20 - (0.20) 100.00% 000-475500 Schertz Support 395,830 - 384,187.64 395,829.68 - 0.32 100.00% 000-475600 Santa Clara Support 9,121 - 8,852.24 9,120.48 - 0.52 99.99% 000-475800 Marion Support 13,410 - 13,015.88 10,057.71 - 3,352.29 75.00% TOTAL Inter-Jurisdictional 1,486,723 23,843.88 1,452,262.40 1,484,980.80 - 1,742.20 99.88% Fund Transfers 000-486100 Transfer In - - 29,930.14 - - - 0.00% TOTAL Fund Transfers - - 29,930.14 - - - 0.00% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 33 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% 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: SEPTEMBER 30th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** Miscellaneous 000-491200 Investment Income 500 - 667.01 344.08 - 155.92 68.82% 000-493203 Donations-EMS 4,000 50.00 1,095.00 902.00 - 3,098.00 22.55% 000-493204 Donations-Dilworth Fund 2,000 - - - - 2,000.00 0.00% 000-493205 Donations- Golf Tournament - - 15,550.00 14,162.00 - (14,162.00) 0.00% 000-497000 Misc Income 130,000 1,153.17 87,390.51 73,045.71 - 56,954.29 56.19% 000-497100 Recovery of Bad Debt 100,000 245.00 6,179.33 5,364.20 - 94,635.80 2.75% TOTAL Miscellaneous 236,500 1,448.17 110,881.85 93,817.99 - 142,682.01 39.67% TOTAL REVENUES 5,872,625 390,447.33 5,114,477.08 6,320,542.48 (300.00) (447,617.48) 107.62% 34 Cash in Bank Claim on Operating Cash Pool-Checking (187,077.16)$ Total Cash in Bank & Investments (187,077.16)$ CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2013 SCHERTZ EMS 35 204-DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 998,157 86,046.83 734,529.73 1,027,958.02 - (29,801.02) 154.93% Miscellaneous 800 386.54 1,572.71 3,780.79 - (2,980.79) 240.81% TOTAL REVENUES 998,957 86,433.37 740,136.92 1,031,738.81 - (32,781.81) 155.13% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 447,406 37,598.83 325,467.91 355,609.66 - 91,796.34 79.48% Supplies 8,300 147.60 4,551.78 4,374.35 - 3,925.65 52.70% Human Services 325 - 184.00 - - 325.00 0.00% City Support Services 26,855 - 1,508.72 3,233.63 - 23,621.37 12.04% Utility Services 30,888 4,755.58 21,375.47 28,094.45 - 2,793.55 90.96% Operations Support 2,460 - - - - 2,460.00 0.00% Staff Support 7,875 420.22 3,705.12 4,542.32 - 3,332.68 57.68% City Assistance 840 87.00 378.00 167.56 - 672.44 19.95% Professional Services 65,800 5,304.27 20,759.25 17,073.19 - 48,726.81 25.95% Fund Charges/Transfers 189,136 84,261.14 165,045.98 256,902.40 - (67,766.40) 135.83% Maintenance Services 22,000 10,055.00 42.12 13,449.40 - 8,550.60 61.13% Other costs 200 - 100.00 100.00 - 100.00 50.00% Debt Service 18,091 (102.92) 3,168.57 2,587.78 - 15,503.22 14.30% Rental/Leasing 500 - 561.29 - - 500.00 0.00% Operating Equipment - - - 11,468.42 - (11,468.42) 0.00% Capital Outlay 139,900 - - 16,724.80 - 123,175.20 11.95% TOTAL DRAINAGE 960,576 142,526.72 546,848.21 714,327.96 - 246,248.04 74.36% TOTAL EXPENDITURES 960,576 142,526.72 546,848.21 714,327.96 - 246,248.04 74.36% ** REVENUE OVER(UNDER) EXPEND 38,381 317,410.85 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 **************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 36 204-DRAINAGE CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000-457500 Drainage Penalties 4,000 539.12 5,169.63 7,526.91 - (3,526.91) 188.17% 000-457600 Drainage Fee 994,157 85,507.71 729,360.10 1,020,431.11 - (26,274.11) 102.64% TOTAL Fees 998,157 86,046.83 734,529.73 1,027,958.02 - (29,801.02) 102.99% Fund Transfers 000-486100 Transfer In - - 4,034.48 - - - 0.00% TOTAL Fees - - 4,034.48 - - - 0.00% Miscellaneous 000-491000 Interest Earned 100 9.00 90.99 86.99 - 13.01 86.99% 000-491200 Investment Interest 600 77.54 810.83 959.94 - (359.94) 159.99% 000-497000 Misc Income-Drainage 100 300.00 670.89 2,733.86 - (2,633.86) 2733.86% TOTAL Miscellaneous 800 386.54 1,572.71 3,780.79 - (2,980.79) 472.60% TOTAL REVENUES 998,957 86,433.37 740,136.92 1,031,738.81 - (32,781.81) 103.28% C I T Y O F S C H E R T Z *********************************************** 2 0 1 2 - 2 0 1 3 ************************************************* REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 37 Cash in Bank Claim on Operating Cash Pool-Checking 197,794.16 Cash in Investments Lone Star Investment-Drainage Maint Fund 604,851.41 Total Cash in Bank & Investments 802,645.57$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2013 38 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 492,417 101,937.07 470,290.28 503,267.09 - (10,850.09) 102.20% Fund Transfers 10,000 - - - - 10,000 0.00% Miscellaneous 300 31.35 419.54 512.87 - (212.87) 170.96% TOTAL REVENUES 502,717 101,968.42 470,709.82 503,779.96 - (1,062.96) 100.21% EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,000 - 1,826.50 - - 2,000.00 0.00% City Support Services 78,378 6,000.00 65,318.07 77,759.56 - 618.44 99.21% Operations Support 83,588 7,838.25 45,428.77 45,707.73 - 37,880.27 54.68% Professional Services 11,685 - 2,500.00 11,685.00 - - 100.00% Fund Charges/Transfers 248,767 94,352.85 199,876.00 238,743.47 - 10,023.53 95.97% Operating Equipment 59,527 2,091.00 66,717.92 50,195.11 6,729.40 2,602.49 95.63% Capital Outlay 8,000 - - - - 8,000.00 0.00% TOTAL NONDEPARTMENTAL 491,945 110,282.10 381,667.26 424,090.87 6,729.40 61,124.73 87.57% TOTAL EXPENDITURES 491,945 110,282.10 381,667.26 424,090.87 6,729.40 61,124.73 87.57% REVENUE OVER(UNDER) EXPENDITURE 10,772 79,689.09 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 **************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 39 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411800 Hotel Occupancy Tax 492,417 101,937.07 470,290.28 503,267.09 - (10,850.09) 102.20% TOTAL Taxes 492,417 101,937.07 470,290.28 503,267.09 - (10,850.09) 102.20% Fund Transfers 000-481000 Transfer From Reserve 10,000 - - - - 10,000.00 0.00% TOTAL Fund Transfers 10,000 - - - - 10,000.00 0.00% Miscellaneous 000-491000 Interest Earned 150 8.84 90.38 65.50 - 84.50 43.67% 000-491200 Investment Interest 150 22.51 329.16 447.37 - (297.37) 298.25% TOTAL Miscellaneous 300 31.35 419.54 512.87 - (212.87) 170.96% TOTAL REVENUES 502,717 101,968.42 470,709.82 503,779.96 - (1,062.96) 100.21% C I T Y O F S C H E R T Z *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 40 Cash in Bank Claim on Operating Cash Pool-Checking 114,008.93$ Cash in Investments MBIA - Hotel Tax 298,902.57 Total Cash in Bank & Investments 412,911.50$ CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2013 HOTEL OCCUPANCY TAX FUND 41 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 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 2009-10 23,625 22,026 20,768 19,924 23,169 33,638 26,531 32,368 36,676 46,069 36,697 26,655 2008-09 17,549 20,134 18,461 17,255 15,138 19,297 19,548 24,769 29,695 32,336 37,633 45,428 $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 HOTEL OCCUPANCY TAX 42 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 150,000 - 148,025.00 192,000.00 - (42,000.00) 128.00% Miscellaneous 316,834 13.08 655.87 225.24 - 316,608.76 0.07% TOTAL REVENUES 466,834 13.08 148,680.87 192,225.24 - 274,608.76 41.18% EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Transfers 189,650 - - 189,650.00 - - 100.00% TOTAL PARKLAND DEDICATION 189,650 - - 189,650.00 - - 100.00% PARKLAND DEDICATION Professional Services - - 23,350.00 545.00 - (545.00) 0.00% Fund Charges/Transfers 138,884 - 100,000.00 138,884.00 - - 100.00% Maintenance Services-Landscape - - 135.88 - - - 0.00% Operating Equipment - 5,663.00 67,901.63 10,049.30 - (10,049.30) 0.00% Capital Outlay 107,600 - 23,416.00 - - 107,600.00 0.00% TOTAL PARKLAND DEDICATION 246,484 5,663.00 214,803.51 149,478.30 - 97,005.70 60.64% TOTAL EXPENDITURES 436,134 5,663.00 214,803.51 339,128.30 - 97,005.70 77.76% REVENUE OVER(UNDER) EXPEND 30,700 (146,903.06) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 43 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458800 Parkland Dedication 150,000 - 148,025.00 192,000.00 - (42,000.00) 128.00% TOTAL Fees 150,000 - 148,025.00 192,000.00 - (42,000.00) 128.00% Miscellaneous 000-491000 Interest Earned - 0.62 48.84 34.29 - (34.29) 0.00% 000-491200 Investment Interest 300 12.46 607.03 190.95 - 109.05 63.65% 000-499100 Transfer from Reserves 316,534 - - - - 316,534.00 0.00% TOTAL Miscellaneous 316,834 13.08 655.87 225.24 - 316,608.76 0.07% TOTAL REVENUES 466,834 13.08 148,680.87 192,225.24 - 274,608.76 41.18% C I T Y O F S C H E R T Z ******************************************************* 2 0 1 2 - 2 0 1 3 ******************************************************* REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 44 Cash in Bank Claim on Operating Cash Pool-Checking $7,114.14 Cash in Investments MBIA Investment-Park Fund 165,353.19 Total in Investment Pool 165,353.19 Total Cash in Bank & Investments $172,467.33 CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2013 PARK FUND 45 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 35,000 - 69,134.75 19,172.50 - 15,827.50 54.78% Miscellaneous 61,725 10.40 - 1,842.77 - 59,882.23 2.99% TOTAL REVENUES 96,725 10.40 69,134.75 21,015.27 - 75,709.73 21.73% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services-Trees 73,299 - 6,335.50 57,730.00 24,300.00 (8,731.06) 111.91% Capital Outlay 23,226 - 19,900.00 23,226.06 - - 100.00% TOTAL TREE MITIGATION 96,525 - 26,235.50 80,956.06 24,300.00 (8,731.06) 109.05% TOTAL EXPENDITURES 96,525 - 26,235.50 80,956.06 24,300.00 (8,731.06) 109.05% REVENUE OVER(UNDER) EXPEND 200 (59,940.79) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 46 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458900 Tree Mitigation 35,000 - 69,134.75 19,172.50 - 15,827.50 54.78% TOTAL Fees 35,000 - 69,134.75 19,172.50 - 15,827.50 54.78% Miscellaneous 000-491000 Interest Earned - 3.03 26.27 - (26.27) 0.00% 000-491200 Investment Interest 200 7.37 - 126.50 - 73.50 63.25% 000-497000 Misc Income - - - 1,690.00 - (1,690.00) 0.00% 000-499000 Transfer In Reserves 61,525 - - - - 61,525.00 0.00% TOTAL Miscellaneous 61,725 10.40 - 1,842.77 - 59,882.23 2.99% TOTAL REVENUES 96,725 10.40 69,134.75 21,015.27 - 75,709.73 21.73% C I T Y O F S C H E R T Z ******************************************************* 2 0 1 2 - 2 0 1 3 ******************************************************* REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 47 Cash in Bank Claim on Operating Cash Pool-Checking $60,411.15 Cash in Investments MBIA Investment-Tree Mitigation 97,247.63 Total Cash in Bank & Investments $157,658.78 CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2013 TREE MITIGATION FUND 48 411-CAPITAL RECOVERY CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 1,924,200 78,426.00 1,686,256.32 1,358,061.84 - 566,138.16 70.58% Fund Transfers 1,542,674 - 487,342.00 - - 1,542,674.00 0.00% Miscellaneous 298,750 8,115.59 19,302.39 39,656.19 - 259,093.81 13.27% TOTAL REVENUES 3,765,624 86,541.59 2,192,900.71 1,397,718.03 - 2,367,905.97 37.12% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 5,000 - - - - 5,000.00 0.00% Operations Support 109 1,800.00 108.50 1,800.00 - (1,691.00) 1651.38% Professional Services 450,000 355.69 6,610.29 10,362.83 - 439,637.17 2.30% Fund Charges/Transfers - - 218,391.10 - - - 0.00% Maintenance Services 10,000 - 5,740.00 - - 10,000.00 0.00% Debt Service 206,515 - 215,537.50 - - 206,515.00 0.00% TOTAL NON DEPARTMENTAL 671,624 2,155.69 446,387.39 12,162.83 - 659,461.17 1.81% MISC & PROJECTS Water Projects 1,680,000 - - - - 1,680,000.00 0.00% Sewer Projects 1,414,000 - - - - 1,414,000.00 0.00% Schaefer Road Water Improvements - - - - - - 0.00% TOTAL MISC & PROJECTS 3,094,000 - - - - 3,094,000.00 0.00% TOTAL EXPENDITURES 3,765,624 2,155.69 446,387.39 12,162.83 - 3,753,461.17 0.32% REVENUE OVER(UNDER) EXPENDITURES - 1,385,555 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 ******************************************************* 2 0 1 2 - 2 0 1 3 ******************************************************* 49 411-CAPITAL RECOVERY CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fees 000-455900 Capital Recovery - Water 1,173,600 44,010.00 1,038,730.04 827,388.00 - 346,212.00 70.50% 000-455910 Capital Recovery - Waste Wtr 667,200 20,016.00 571,926.28 428,073.84 - 239,126.16 64.16% 000-455913 Cap Recovery-North Sewer Tr 83,400 14,400.00 75,600.00 102,600.00 - (19,200.00) 123.02% TOTAL Fees 1,924,200 78,426.00 1,686,256.32 1,358,061.84 - 566,138.16 70.58% Fund Transfers 000-481000 Transfer from Reserves 1,542,674 - 487,342.00 - - 1,542,674.00 0.00% TOTAL Fund Transfers 1,542,674 - 487,342.00 - - 1,542,674.00 0.00% Miscellaneous 000-491000 Interest Earned 250 3,038.62 398.24 27,150.82 - (26,900.82) ######## 000-491200 Investment Income 40,000 4,152.01 54,389.49 54,520.68 - (14,520.68) 136.30% 000-491800 Gain/Loss - (11,562.50) (18,314.28) (31,506.33) - 31,506.33 0.00% 000-491900 Unrealized Gain/Loss-Cap One (25,000) 12,487.46 (17,221.37) (10,508.98) - (14,491.02) 0.00% 000-497000 Misc Income - - 50.31 - - - 0.00% 000-498200 Re-imbursement-Water Meters 283,500 - - - - 283,500.00 0.00% TOTAL Miscellaneous 298,750 8,115.59 19,302.39 39,656.19 - 259,093.81 13.27% TOTAL REVENUES 3,765,624 86,541.59 2,192,900.71 1,397,718.03 - 2,367,905.97 37.12% C I T Y O F S C H E R T Z **************************************************** 2 0 1 2 - 2 0 1 3 ***************************************************** REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 50 Cash in Bank Claim on Operating Cash Pool-Checking 502,025.82$ Cash in Investments Lone Star Investment-Capital Recovery Water 3,687,743.23 Lone Star Investment-Capital Recovery Sewer 1,449,603.73 Capital One-Investment 1,720,409.66 Total Cash in Bank & Investments 7,359,782.44$ CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2013 CAPITAL RECOVERY 51 505-TAX I&S CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 5,032,646 7,082.04 4,306,882.41 5,057,898.62 - (25,252.62) 100.50% Fund Transfers 55,000 - - - - 55,000.00 0.00% Miscellaneous 381,625 (25,762.62) 390,726.04 364,663.89 - 16,961.11 95.56% TOTAL REVENUES 5,469,271 (18,680.58) 4,697,608.45 5,422,562.51 - 46,708.49 99.15% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 42,350 400.00 37,760.39 1,750.00 - 40,600.00 4.13% Debt Service 5,159,586 - 4,549,424.41 5,159,422.11 - 163.39 100.00% Other Financing Sources - - - - - - 0.00% TOTAL GENERAL GOVERNMENT 5,201,936 400.00 4,587,184.80 5,161,172.11 - 40,763.39 99.22% TOTAL EXPENDITURES 5,201,936 400.00 4,587,184.80 5,161,172.11 - 40,763.39 99.22% ** REVENUE OVER(UNDER) EXPEND 267,336 261,390.40 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 ****************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 52 505-TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y-T-D BUDGET 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411900 Property Tax Revenue 5,032,646 7,082.04 4,306,882.41 5,057,898.62 - (25,252.62) 100.50% TOTAL Taxes 5,032,646 7,082.04 4,306,882.41 5,057,898.62 - (25,252.62) 100.50% Fund Transfers 000-486401 Transfer In Fund 401 55,000 - - - - 55,000.00 0.00% TOTAL Fund Transfers 55,000 - - - - 55,000.00 0.00% Miscellaneous 000-491000 Interest Earned 50 0.53 41.42 56.91 - (6.91) 113.82% 000-491200 Investment Earnings 12,500 (25,763.15) 23,859.60 1,955.51 - 10,544.49 15.64% 000-495015 Contribution from SED 369,075 - 366,825.00 369,075.00 - - 100.00% 000-497000 Misc Income - - 0.02 (6,423.53) - 6,423.53 0.00% TOTAL Miscellaneous 381,625 (25,762.62) 390,726.04 364,663.89 - 16,961.11 95.56% TOTAL REVENUES 5,469,271 (18,680.58) 4,697,608.45 5,422,562.51 - 46,708.49 99.15% C I T Y O F S C H E R T Z ***************************************************** 2 0 1 2 - 2 0 1 3 ***************************************************** REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 53 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF NON DEPARTMENTAL BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101-541500 Paying Agent 2,350 400.00 1,950.00 1,200.00 - 1,150.00 51.06% 101-541502 Cost of Bond Issuance 40,000 - 35,810.39 550.00 - 39,450.00 1.38% TOTAL Professional Services 42,350 400 37,760.39 1,750.00 - 40,600.00 4.13% Debt Service 101-555612 Bond-GO Refunding 2010-Principal 250,000 - 240,000.00 250,000.00 - - 100.00% 101-555612.1 Bond-GO Refunding 2010 Interest 77,125 - 82,650.00 77,125.00 - - 100.00% 101-555622 Schertz C O SR2003-Principal 210,000 - 200,000.00 210,000.00 - - 100.00% 101-555622.1 Schertz C O SR2003-Interest 3,833 - 11,265.00 3,832.50 - 0.50 99.99% 101-555624 Comm Proj Bond-SR04-Principal 325,000 - 315,000.00 325,000.00 - - 100.00% 101-555624.1 Comm Proj Bond SR04-Interest 6,910 - 20,703.13 6,906.25 - 3.75 99.95% 101-555626 LS&D SR2006-Principal 200,000 - 100,000.00 200,000.00 - - 100.00% 101-555626.1 LS&D SR2006-Interest 642,982 - 648,981.25 642,981.25 - 0.75 100.00% 101-555628 CO Bond 2007-Principal 109,534 - 102,900.00 109,533.33 - 0.67 100.00% 101-555628.1 CO Bond 2007-Interest 18,499 - 22,176.64 18,498.14 - 0.86 100.00% 101-555629 GO Bond 2007-Principal 235,000 - 225,000.00 235,000.00 - - 100.00% 101-555629.1 GO Bond 2007-Interest 189,561 - 198,819.50 189,418.72 - 142.28 99.92% 101-555630 GO Bond SR2008 Principal 385,000 - 370,000.00 385,000.00 - - 100.00% 101-555630.1 GO Bond SR2008 Interest 349,089 - 364,679.00 349,088.25 - 0.75 100.00% 101-555631 GO Bond SR2009 Principal 510,000 - 505,000.00 510,000.00 - - 100.00% 101-555631.1 BO Bond SR2009 Interest 327,950 - 340,637.50 327,950.00 - - 100.00% 101-555633 GO SR2011 Principal 200,000 - 90,000.00 200,000.00 - - 100.00% 101-555633.1 GO SR2011 Interest 367,238 - 474,591.84 367,237.50 - - 100.00% 101-555634 GO SR2011A Refund Principal 70,000 - 140,000.00 70,000.00 - - 100.00% 101-555634.1 GO SR2011A Refund Interest 153,081 - 97,020.55 153,067.41 - 13.59 99.99% 101-555635 GO SR2012 Principal 295,000 - - 295,000.00 - - 100.00% 101-555635.1 GO SR2012 Interest 233,784 - - 233,783.76 - 0.24 100.00% TOTAL Debt Service 5,159,586 - 4,549,424.41 5,159,422.11 - 163.39 100.00% TOTAL EXPENDITURES 5,201,936 400.00 4,587,184.80 5,161,172.11 - 40,763.39 99.22% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 ***************************************************** 2 0 1 2 - 2 0 1 3 ***************************************************** 54 Cash in Bank Claim on Operating Cash Pool-Checking 28,020.00$ Cash in Investments MBIA Investment- Tax I&S 398,748.80 Total Cash in Bank & Investments 426,768.80$ CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2013 TAX I&S 55 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 2,820,260 308,411.20 2,659,193.60 3,193,838.59 - (373,578.59) 113.25% Fund Transfers 50,910 - 976 - - 50,910 0.00% Miscellaneous 17,450 1,511.77 25,068.63 8,819.15 - 8,630.85 50.54% TOTAL REVENUES 2,888,620 309,922.97 2,685,238.00 3,202,657.74 - (314,037.74) 110.87% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies - - 26,226.54 - - - 0.00% Utility Service - - 83,431.08 - - - 0.00% Maintenance Services - - 52,367.98 - - - 0.00% TOTAL NONDEPARTMENTAL - - 162,025.60 - - - 0.00% ECONOMIC DEVELOPMENT Personnel Services 294,593 35,086.85 248,531.43 304,104.33 - (9,511.33) 103.23% Supplies 2,200 71.23 730.57 553.11 - 1,646.89 25.14% Human Services 200 - - - - 200.00 0.00% City Support Services 16,500 - 9,128.12 1,212.05 - 15,287.95 7.35% Utility Services 5,950 88.07 1,417.35 1,128.20 - 4,821.80 18.96% Operations Support 166,100 3,394.81 101,297.22 103,407.51 - 62,692.49 62.26% Staff Support 20,250 2,250.15 33,958.88 6,648.58 - 13,601.42 32.83% City Assistance 995,000 - 10,000.00 587.95 - 994,412.05 0.06% Professional Services 178,410 1,657.05 245,481.01 154,501.09 - 23,908.91 86.60% Fund Charges/Transfers 615,647 (28,165.07) 472,810.04 566,934.30 - 48,712.70 92.09% Debt Service 428,504 - 428,329.00 428,503.50 - 0.50 100.00% Operating Equipment 2,000 374.57 372.39 736.80 - 1,263.20 36.84% TOTAL ECONO DEVELOPMENT 2,725,354 14,757.66 1,552,056.01 1,568,317.42 - 1,157,036.58 57.55% TOTAL EXPENDITURES 2,725,354 14,757.66 1,714,081.61 1,568,317.42 - 1,157,036.58 57.55% ** REVENUE OVER(UNDER) EXPEND 163,266 1,634,340.32 C I T Y O F S C H E R T Z ***************************************************** 2 0 1 2 - 2 0 1 3 ***************************************************** REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2013 56 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411500 Sales Tax Revenue (4B)2,820,260 308,411.20 2,659,193.60 3,193,838.59 - (373,578.59) 113.25% TOTAL Taxes 2,820,260 308,411.20 2,659,193.60 3,193,838.59 - (373,578.59) 113.25% Fund Transfers 000-486000 Transfer In - - 975.77 - - - 0.00% 000-486010 Transfer In - Reserves 50,910 - - - - 50,910.00 0.00% TOTAL Fund Transfers 50,910 - 975.77 - - 50,910.00 0.00% Miscellaneous 000-491000 Interest Earned 200 14.17 148.65 125.70 - 74.30 62.85% 000-491200 Investment Earnings 12,250 1,497.60 9,046.18 8,693.45 - 3,556.55 70.97% 000-497000 Misc Income 5,000 - 15,873.80 - - 5,000.00 0.00% TOTAL Miscellaneous 17,450 1,511.77 25,068.63 8,819.15 - 8,631 50.54% TOTAL REVENUES 2,888,620 309,922.97 2,685,238.00 3,202,657.74 - (314,037.74) 110.87% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** AS OF: SEPTEMBER 30th, 2013 57 Cash in Bank Claim on Operating Cash Pool-Checking 318,368.86$ Cash in Investments MBIA Investment-Economic Development Corp 4,112,374.31 Schertz Bank & Trust-Certificate of Deposit 1,040,078.07 Total Cash in Bank & Investments 5,470,821.24$ CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2013 SED CORPORATION 58 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 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 2009-10 150,192 169,257 140,629 144,175 238,531 146,589 136,939 184,582 175,160 163,328 210,780 201,402 2008-09 166,298 207,422 185,879 150,414 217,323 149,249 141,205 197,117 158,648 155,080 185,494 159,088 2% 24% 40% 2% 37% 14% 17% 23% 37% 38% 13% 11% $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 4B SALES TAX 59 INVESTMENT REPORT C I T Y O F S C H E R T Z FOR MONTH ENDING SEPTEMBER 30th, 2013 60 INVESTMENT POOLS Par Beginning Deposits/Ending Ending Maturity Interest Weighted Value Book Value Yield Purchases Withdrawals Book Value Mkt Value Date Earned Avg Mat. OPERATIONS-BANK CASH Schertz Bank & Trust - Pooled Cash 4,276,913.15 3,802,678.66 0.0500 6,028,670.26 5,554,435.77 4,276,913.15 4,276,913.15 N/A 161.40 Schertz Bank & Trust - PEG Fund 434,297.52 408,265.38 0.0000 35,543.61 9,511.47 434,297.52 434,297.52 N/A - TOTAL OPERATIONS 4,711,210.67 4,210,944.04 6,064,213.87 5,563,947.24 4,711,210.67 4,711,210.67 - 161.40 LOGIC General Fund 3,059,041.07 3,458,722.52 0.1125 318.55 400,000.00 3,059,041.07 3,059,041.07 N/A 318.55 57 Days G/F-Equipment Replacement 73,577.50 73,570.65 0.1125 6.85 - 73,577.50 73,577.50 N/A 6.85 57 Days G/F-Vehicle Replacement 211,051.98 102,636.67 0.1125 108,415.31 - 211,051.98 211,051.98 N/A 13.31 57 Days G/F-Air Conditioner Replacement 171,404.60 146,890.15 0.1125 24,514.45 - 171,404.60 171,404.60 N/A 14.45 57 Days SR2009 Bond-Street Projects(II)1,670,856.78 1,670,702.23 0.1125 154.55 - 1,670,856.78 1,670,856.78 N/A 154.55 57 Days TOTAL LOGIC 5,185,931.93 5,452,522.22 133,409.71 400,000.00 5,185,931.93 5,185,931.93 - 507.71 LONESTAR Capital Recovery - Sewer 1,449,603.73 1,449,417.90 0.1600 185.83 - 1,449,603.73 1,449,603.73 N/A 185.83 71 Days Capital Recovery - Water 3,687,743.23 3,687,270.48 0.1600 472.75 - 3,687,743.23 3,687,743.23 N/A 472.75 71 Days Drainage Fund 604,851.41 604,773.87 0.1600 77.54 - 604,851.41 604,851.41 N/A 77.54 71 Days GO SR2011 Animal Shelter 1,024,195.12 1,269,067.36 0.1600 161.73 245,033.97 1,024,195.12 1,024,195.12 N/A 161.73 71 Days GO SR2011 Athletic Fields 2,678,183.44 2,813,379.91 0.1600 360.16 135,556.63 2,678,183.44 2,678,183.44 N/A 360.45 71 Days GO SR2011 Soccer Fields 2,646,539.80 2,661,759.80 0.1600 341.21 15,561.21 2,646,539.80 2,646,539.80 N/A 341.21 71 Days GO SR2011 Swimming Pool 6,054,904.27 6,084,871.21 0.1600 780.03 30,746.97 6,054,904.27 6,054,904.27 N/A 780.03 71 Days GO SR2012 Downtown Improvements 1,001,854.83 1,001,842.50 0.1600 128.45 116.12 1,001,854.83 1,001,854.83 N/A 128.45 71 Days W/S-Customer Deposits 294,896.92 294,859.12 0.1600 37.80 - 294,896.92 294,896.92 N/A 37.80 71 Days W/S-Equipment Repl/Cap.Imp 24,632.04 374,585.42 0.1600 46.62 350,000.00 24,632.04 24,632.04 N/A 46.62 71 Days Water&Sewer 38,008.24 737,916.44 0.1600 91.80 700,000.00 38,008.24 38,008.24 N/A 91.80 71 Days W/S-Vehicle Replacement 46,258.36 546,190.34 0.1600 68.02 500,000.00 46,258.36 46,258.36 N/A 68.02 71 Days Water/SSLG - SAWS 324,373.55 539,799.12 0.1600 134,574.43 350,000.00 324,373.55 324,373.55 N/A 74.43 71 Days TOTAL LONESTAR 19,876,044.94 22,065,733.47 137,326.37 2,327,014.90 19,876,044.94 19,876,044.94 - 2,826.66 MBIA Tax I&S 398,748.80 381,493.94 0.0900 17,254.86 - 398,748.80 398,748.80 N/A 28.99 40 Days Police Forfeiture 338,668.13 338,642.62 0.0900 25.51 - 338,668.13 338,668.13 N/A 25.51 40 Days Park Fund 165,353.19 165,340.73 0.0900 12.46 - 165,353.19 165,353.19 N/A 12.46 40 Days Economic Development Corporation 4,112,374.31 3,962,073.51 0.0900 150,300.80 - 4,112,374.31 4,112,374.31 N/A 300.80 40 Days Library 44,811.78 44,808.41 0.0900 3.37 - 44,811.78 44,811.78 N/A 3.37 40 Days Tree Mitigation 97,247.63 97,240.26 0.0900 7.37 - 97,247.63 97,247.63 N/A 7.37 40 Days Tax Note 2013 Fire Truck 65,632.34 65,627.41 0.0900 4.93 - 65,632.34 65,632.34 N/A 4.93 40 Days Hotel Tax 298,902.57 298,880.06 0.0900 22.51 - 298,902.57 298,902.57 N/A 22.51 40 Days Special Events Fund 26,761.96 26,759.94 0.0900 2.02 - 26,761.96 26,761.96 N/A 2.02 40 Days Citywide Projects SR2007 870,266.35 870,200.85 0.0900 65.50 - 870,266.35 870,266.35 N/A 65.50 40 Days Tax Note 2013 A P25 785,306.88 785,247.81 0.0900 59.07 - 785,306.88 785,306.88 N/A 59.07 40 Days TOTAL MBIA 7,204,073.94 7,036,315.54 167,758.40 - 7,204,073.94 7,204,073.94 - 532.53 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING SEPTEMBER 30th, 2013 61 62 TOTAL OPERATIONS 11% TOTAL LOGIC 13% TOTAL LONESTAR 47% TOTAL MBIA 17% TOTAL CAPITAL ONE 7% TOTAL C.D.s 5% City Portfolio By Investment Type 63 Operations, $10,210,740.82 Projects, $16,271,174.14 Debt Service Fund, $398,748.80 Special Revenue Funds, $13,515,231.93 Designated Funds, $1,744,334.36 City Portfolio By Use 64 OCT-12 NOV-12 DEC-12 JAN-13 FEB-13 MAR-13 APR-13 MAY-13 JUN-13 JUL-13 AUG-13 SEP-13 1 Month T-Bill 0.0900 0.1100 0.0200 0.0400 0.0700 0.0600 0.0300 0.0300 0.0200 0.0300 0.0300 0.0300 3 Month T-Bill 0.1100 0.0800 0.0500 0.0700 0.1100 0.0800 0.0500 0.0400 0.0400 0.0400 0.0200 0.0200 6 Month T-Bill 0.1600 0.1300 0.1100 0.1200 0.1300 0.1100 0.0900 0.0700 0.1000 0.0800 0.0500 0.0400 Schertz Portfolio 0.4300 0.3954 0.4128 0.3900 0.3727 0.3785 0.3777 0.3443 0.3464 0.3607 0.3352 0.3225 Schertz Bank&Trust 0.0500 0.0500 0.0500 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.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 CD 180 Days 0.3000 0.3000 0.3000 0.3000 0.3000 0.3000 0.3000 0.3000 0.4000 0.4000 0.4000 0.4000 LOGIC 0.1971 0.1804 0.1785 0.1553 0.1543 0.1540 0.1457 0.1320 0.1264 0.1107 0.1053 0.1125 LoneStar 0.2300 0.2100 0.2100 0.1800 0.1700 0.1800 0.1900 0.1800 0.1800 0.1800 0.1800 0.1600 MBIA 0.2100 0.1900 0.2100 0.1800 0.1700 0.1700 0.1600 0.1600 0.1600 0.1400 0.1000 0.0900 Federated 0.1500 0.1300 0.1200 0.1000 0.0900 0.0900 0.0800 0.0600 Capital One 2.8800 2.8700 2.8700 2.8600 2.8600 2.8500 2.8000 2.4700 2.4700 2.5500 2.3875 2.1000 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 MONTHLY YIELDS 65 C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:9/30/2013 General Fund Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Prime Mmkt Port Fd #690 141,132.25 141,132.25 141,132.25 69.00 0.05 Total Cash & Equivalents 141,132.25 141,132.25 141,132.25 69.00 0.05% Fixed Income Federal Home Loan Bks Cons Bds 8/13/2014 317.00 125,000.00 141,987.30 130,903.75 6,875.00 4.84 Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 807.00 100,000.00 116,185.00 109,698.00 4,875.00 4.20 Federal Natl Mtg Assn 1/30/2017 1218.00 100,000.00 102,366.80 101,204.00 1,250.00 1.22 Federal Home Ln Mtg Corp Reference Nts 11/25/2014 421.00 200,000.00 200,609.40 201,300.00 1,500.00 0.75 Federal Natl Mtg Assn 7/28/2015 666.00 125,000.00 132,828.63 129,626.25 2,968.00 2.23 US Treasury Note 11/30/2015 791.00 60,000.00 61,936.72 61,291.80 825.00 1.33 US Treasury Note 5/31/2016 974.00 325,000.00 337,135.74 335,461.75 5,687.00 1.69 US Treasury Note 8/31/2016 1066.00 75,000.00 75,205.07 75,806.25 750.00 1.00 US Treasury Note 9/15/2014 350.00 50,000.00 50,052.74 50,069.50 125.00 0.25 Total Fixed Income 1,160,000.00 1,218,307.40 1,195,361.30 24,855.00 2.04% Total Assets 670.44 1,301,132.25 1,359,439.65 1,336,493.55 24,924.00 1.83% Capital Recovery Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Prime Mmkt Port Fd #690 15,315.14 15,315.14 15,315.14 7.00 0.05 Total Cash & Equivalents 15,315.14 15,315.14 15,315.14 7.00 0.05% Fixed Income Federal Home Loan Bks Cons Bds 8/13/2014 317.00 165,000.00 187,423.24 172,792.95 9,075.00 4.84 Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 807.00 200,000.00 230,779.00 219,396.00 9,750.00 4.22 Federal Home Ln Mtg Corp Deb 11/15/2013 46.00 150,000.00 168,603.75 150,895.50 7,312.00 4.34 Federal Natl Mtg Assn 12/21/2015 812.00 100,000.00 99,989.10 99,791.00 375.00 0.38 Federal Home Ln Mtg Corp Reference Nts 11/25/2014 421.00 220,000.00 220,078.68 221,430.00 1,650.00 0.75 Federal Natl Mtg Assn 7/28/2015 666.00 135,000.00 143,454.91 139,996.35 3,206.00 2.23 US Treasury Note 11/30/2015 791.00 150,000.00 153,746.29 153,229.50 2,062.00 1.34 US Treasury Note 5/31/2016 974.00 350,000.00 364,567.38 361,266.50 6,125.00 1.68 US Treasury Note 7/15/2016 1019.00 175,000.00 174,471.68 175,253.75 1,093.00 0.63 Total Fixed Income 1,645,000.00 1,743,114.03 1,694,051.55 40,648.00 2.33% Total Assets 669.51 1,660,315.14 1,758,429.17 1,709,366.69 40,655.00 2.31% 66